Weekly estimates
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!
|