Hello, I am making a weekly estimate of construction, basically in what I am
interested for this question is, for several activities I have:

Past weeks quantity / This week quantity / To finish quantity

Example:

Week: 5
Walls- Total: 100 ft2, Past: 50ft2, This week: 20ft2, To finish: 30ft2

Week: 6
Walls- Total: 100ft2, Past: 70ft2, This week: 10ft2, To finish: 20ft2

Week: 7
Walls- Total: 100ft2, Past: 80ft2, This week: 10ft2, To finish: 10ft2

and so on... What I do right now is to manually select the values of Last
Week's (Past+This week), to get the Week I am working "Past's" estimate, then
I add my "This Week's" quantity and so on. Is there a way I can automatically
do that and generate a new Tab or a New File each time?

thanks!

Hi Ed
Week5
Total in A1, Past in B1,This week in C1, left in D1 type in =A1-(B1+C1).
Week 6 in say row 3
In Total type =A1, Past =B1+C1,This week =amount done, Left =A3-(B3+C3).

You can then copy this down as far as required.

If you want it to appear on a new page, the same formulae will apply except
it will need the sheet reference as well.

HTH
Michael

"Ed" wrote:

Hello, I am making a weekly estimate of construction, basically in what I am
interested for this question is, for several activities I have:

Past weeks quantity / This week quantity / To finish quantity

Example:

Week: 5
Walls- Total: 100 ft2, Past: 50ft2, This week: 20ft2, To finish: 30ft2

Week: 6
Walls- Total: 100ft2, Past: 70ft2, This week: 10ft2, To finish: 20ft2

Week: 7
Walls- Total: 100ft2, Past: 80ft2, This week: 10ft2, To finish: 10ft2

and so on... What I do right now is to manually select the values of Last
Week's (Past+This week), to get the Week I am working "Past's" estimate, then
I add my "This Week's" quantity and so on. Is there a way I can automatically
do that and generate a new Tab or a New File each time?

thanks!