cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

The community will undergo maintenance on October 16th at 10:00 PM PDT and will be unavailable for up to one hour.

Change part of a table

MWinther
4-Participant

Change part of a table

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

Table.PNG

6 REPLIES 6
LucMeekes
23-Emerald III
(To:MWinther)

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

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

 

Success!

Luc

MWinther
4-Participant
(To:LucMeekes)

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?

Werner_E
25-Diamond I
(To:MWinther)

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.

LucMeekes
23-Emerald III
(To:MWinther)

Something like this:

LucMeekes_1-1583850714194.png

 

Success!
Luc

MWinther
4-Participant
(To:LucMeekes)

Thanks!

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

Capture.PNG

LucMeekes
23-Emerald III
(To:MWinther)

Press the [F9] button.

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

 

Success!

Luc

 

Announcements

Top Tags