I am a project manager and have an excel workbook that lets me plan how project resources (people) will be utilised across lots of different projects at any point in time.
Basically, you list a set of people who are available to work on projects by name and job type. You then allocate people by job type to your individual projects and state how much of their time is roughly needed. The spreadsheet then enables you to see a rolled up view of how each type of resource is under or over allocated at any point in time. You can then adjust the timing of some of your projects to ensure that you can get as much work done as possible with the people you have.
It’s a really cool tool but it has some limits. The main ones are:
- The number of resource types is limited to 10
- The number of projects is limited to 25
Please can you provide me with a quote for modifying this workbook to;
- expand the maximum number of resource types to 50 and
- expand the maximum number of projects to 200.
I’ve attached a blank copy of the spreadsheet to review.