Is there any way to calculate this with the informatio provided, I can figure out the formulas required to correctly calculate the remaining weeks based on the number of resources and the effort working on the tasks:
So if is 290 weeks remaining (each task takes 26 weeks), how do you accuarately create a formula that will calcualte the time remaining based on numbers changing ( i.e. increase in writers, increase in % work spent on project) and also the team efficiancy?
| Excel 2010 | ||||
|---|---|---|---|---|
| B | C | |||
| 39 | Priojected Calendar Time for Remaining Tasks | |||
| 40 | Number of Tasks Remaining | 12 | ||
| 41 | Projected Calendar Time Remaining for Tasks | 264 | ||
| 42 | Add Contingency | 10% | ||
| 43 | Total Projected Calendar Weeks Remaining | 290 | ||
| 44 | ||||
| 45 | Projected Time Remaining Calculator | |||
| 46 | Number of Writers | 1.00 | ||
| 47 | Team Efficiency | 100% | ||
| 48 | Percentage Work Time Spent on Project | 50% | ||
| 49 | Projected Time Remaining | |||
Sheet1 | ||||
So if is 290 weeks remaining (each task takes 26 weeks), how do you accuarately create a formula that will calcualte the time remaining based on numbers changing ( i.e. increase in writers, increase in % work spent on project) and also the team efficiancy?
