Get Help

Turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- Community
- :
- PTC Mathcad
- :
- PTC Mathcad
- :
- Change part of a table

Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

03-10-2020
04:14 AM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

03-10-2020
04:14 AM

Change part of a table

I would like to shift the values of the last part of a table. Is that possible?

6 REPLIES 6

03-10-2020
06:20 AM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

03-10-2020
06:20 AM

Use the submatrix() function, possibly together with the stack() function.

Or do you mean to change their values instead of their position?

Success!

Luc

03-10-2020
07:18 AM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

03-10-2020
07:18 AM

I would like to change the values of the last third or so, by a tiny bit.

I suppose I could maybe use the submatrix and stack to: disassemble, manipulate and reassemble.

Or is there an easier way?

03-10-2020
10:02 AM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

03-10-2020
10:02 AM

if you wan to change the value of a vecor v, lets say at position 123, you can simply write v[123:=<any value you want>.

Or if you want it to increase by 1% you may write v[123:=1.01*v[123.

The "[" is the keyboard short for the vector index.

03-10-2020
10:31 AM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

03-11-2020
03:28 AM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

03-11-2020
03:28 AM

Thanks!

I have never used such operations before. How do you get it to run?

03-11-2020
08:53 AM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

03-11-2020
08:53 AM

Press the [F9] button.

(By default in my sheets, automatic calculation is switched off)

Success!

Luc