So, I have a column of numbers. I want to create another column of numbers that starts at 1/2 the value and increases at 1/2 the rate.
To do this, I simply brought out the difference between each term in that first column by using
=B3-B2 and put it, say, in column
D. Then in the column that I want to generate from these numbers, I use in, say column
[1/2 the number in the first row of the first column], then
F1+(D1/2)+(D2/2)+(D3/3) of course where D contains the difference between corresponding rows in the first, initial column. Therefore, by taking the initial value (in
F1) and adding the difference between the corresponding first two rows in the initial column, divided by two, I create a curve that increases at 1/2 the rate.
The problem is, libre-office always generates an extrapolation that does NOT increase the number of terms in each row - it always finds a pattern that WOULD be correct - it advances all of the
D references by one row - but alas it never ADDs the d value - it only advances them.
I really really don’t want to enter this by hand… how might one create the desired effect?
Any help is really appreciated.