software

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 quot;Past'squot; estimate, then
I add my quot;This Week'squot; 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

quot;Edquot; wrote:

gt; Hello, I am making a weekly estimate of construction, basically in what I am
gt; interested for this question is, for several activities I have:
gt;
gt; Past weeks quantity / This week quantity / To finish quantity
gt;
gt; Example:
gt;
gt; Week: 5
gt; Walls- Total: 100 ft2, Past: 50ft2, This week: 20ft2, To finish: 30ft2
gt;
gt; Week: 6
gt; Walls- Total: 100ft2, Past: 70ft2, This week: 10ft2, To finish: 20ft2
gt;
gt; Week: 7
gt; Walls- Total: 100ft2, Past: 80ft2, This week: 10ft2, To finish: 10ft2
gt;
gt; and so on... What I do right now is to manually select the values of Last
gt; Week's (Past This week), to get the Week I am working quot;Past'squot; estimate, then
gt; I add my quot;This Week'squot; quantity and so on. Is there a way I can automatically
gt; do that and generate a new Tab or a New File each time?
gt;
gt; thanks!