N
nicholas.vanderhout
I want to be able to create a schedule in excel
say i have the following data
Hours Cost
Task 1 2,345 $69,678
Task 2 2,345 $568,568
Task 3 345 $67
Task 4 678 $56,867
Task 5 67 $6,588
Task 6 5,673 $67,856
Task 7 456 $6,868
Task 8 657 $2,134
Task 9 5,754 $5,687
Task 10 6,785 $78,976
Task 11 6,758 $658
Task 12 9,675 $2,314
Total 41,538 $866,261
Say I can work 5000 hours per period and it is a simple waterfall schedule were I finish one task I then go to the next task.
So in period one I can do task 1 and 2 and start task 3 but i will have 35 hours from task 3 remaining when I reach my 5000 target which I need to roll over to period 2
In period 2 I have the remainder of task 3 then task 4 and so forth
I want it to be automated so if I update the information with new estimates it all reschedules
Any bright ideas?
and if it needs VBA please explain your code so i can learn rather than just cut and paste it
say i have the following data
Hours Cost
Task 1 2,345 $69,678
Task 2 2,345 $568,568
Task 3 345 $67
Task 4 678 $56,867
Task 5 67 $6,588
Task 6 5,673 $67,856
Task 7 456 $6,868
Task 8 657 $2,134
Task 9 5,754 $5,687
Task 10 6,785 $78,976
Task 11 6,758 $658
Task 12 9,675 $2,314
Total 41,538 $866,261
Say I can work 5000 hours per period and it is a simple waterfall schedule were I finish one task I then go to the next task.
So in period one I can do task 1 and 2 and start task 3 but i will have 35 hours from task 3 remaining when I reach my 5000 target which I need to roll over to period 2
In period 2 I have the remainder of task 3 then task 4 and so forth
I want it to be automated so if I update the information with new estimates it all reschedules
Any bright ideas?
and if it needs VBA please explain your code so i can learn rather than just cut and paste it