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 make a chart, showing total man hours & revenue managed for a given period (day, week, month), for each Project Manager.
Please help!
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.
