Forum Discussion
Workload Chart
I have the following project data.
Project Start Date
Project Completion Date
Estimated Man Hours
Estimated Revenue
Project Manager
I have several project managers, and would like to ...
Hi Terry,
Could be different approaches, but in any case you need to spread workload and revenue over your time periods (days, months, etc.). If you don't have such data in your estimation you may distribute totals proportionally between Start Date and Completion Date.
Examples (not your case, but something around)
https://www.myonlinetraininghub.com/excel-formula-to-spread-income-or-costs-over-months
https://www.excel-university.com/excel-formula-to-allocate-an-amount-into-monthly-columns/
and just recent discussion
I believe there are more.