Using MS Project for your ‘by month’ resource forecast
Go to the resource view, change the timescales on the left pane (right click on the headers, >change timescale, middle tier units = quarter, bottom tier=months). In the right pane, where the resources are, hide the subtasks (hide subtasks button). This gives you an overview of resource usage per month, which you can copy (first right pane, then left pane) to excel (use the search/replace function in excel to get rid of the ‘hrs’ or other descriptions that make it text instead of numbers |
