Forum Discussion
Workload Projection
KHarrisonSJCA Attached a quick-and-dirty Excel formula based solution. No need for PQ here, I believe, though I recommend you to learn it as it will be a life saver in many other situations.
Since you say the tool should provide a 'rough idea' only, why make things more complicated than needed. The example looks 12 months ahead from a given date. If you want to expand it to the full date spectrum of all projects, I trust you can adjust the named date ranges used yourself.
Thanks for the quick reply as well.
To your point of the project duration column, that was on me. I was using the formula "=(DAYS(C2,B2))/12" when I should have been using "=(DAYS(C2,B2))/30" to give the approximate duration in months. (Approximate due to using 30 days for each month.)
Given that this tool is intended to provide a rough idea of what we can expect in future months based off bookings, I know the reality of scheduling will differ. For simplicity I was going to divide the number of hours equally through the date range, which gives me that 11-12 month duration like you said. If we can make it more accurate to reflect the working days available in each month, that would be great, but not worth overcomplicating it.
Hope this helps! Feel free to ask more questions as needed.
KHarrisonSJCA Attached a quick-and-dirty Excel formula based solution. No need for PQ here, I believe, though I recommend you to learn it as it will be a life saver in many other situations.
Since you say the tool should provide a 'rough idea' only, why make things more complicated than needed. The example looks 12 months ahead from a given date. If you want to expand it to the full date spectrum of all projects, I trust you can adjust the named date ranges used yourself.
- With some expected modifications, this gets what I need. Thank you so much for your help, Riny!