william drescher wrote:
On 6/8/2010 7:11 AM, Tanstaafl wrote:
On 2010-06-08 6:55 AM, william drescher wrote:
I am computing a moving average and comparing it to a current value
(looking at the current weights of dogs compared to their average over
the prior 3 months).
So my cell formula is (in column I):
=h2 - ((e2 + f2 + g2)/3)
Each month I insert a new column just before the average column, then I
need to redo this formula.
How can I write the formula so that it uses
= 1_cell_to_the_left - (4_cells_to_the_left + 3_cells_to_the_left +
2_cell_to_the_left)/3)
I think you only need to change the option:
Tools> Options> Openoffice.org Calc> General
and check "Expand references when new columns/rows are inserted"
?
no, that won't do it as:
1: I don't have a range defined in the formula (which I could fix by
using SUM), and
2: I don't want to increase the number of columns in the moving
avarage, I want it to stay at 3.
Thanks for the idea though.
bill
Perhaps you might consider setting up a fairly simple database.
Then a query could easily produce the information you want.
Dan
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org
