Project Management Central

Please login or join to subscribe to this thread
Organizational resource planning and availability Matrix
Network:181



Right now I have challenge to see the entire developer's planning in single sheet and their next availability for further projects.
Few developers are working on single projects and few are on multiple projects at a time. I am looking for some spreadsheet template where I can see the developer's availability.
Please share your thoughts so that I can either use your templates or help me to build such spreadsheet.
Sort By:
Network:1146



Resource calendars can help you. I don't have a template ready with me.
Network:315



Hi Prashant,
I don't have any template. may be you can create a Histogram in Excel (or similar) where you have the projects on X Axis and the columns would be the "sum" of developers in the project
Network:106



Dear prashant,
This is typical staffing managent sub plan. In my opinion the best way to make such plan would be, to make a person wise project engagement amd availability schedule.
This can be done by listing all the person names in first column, then against each person name you can put the project name he is handling,
Additonal filters can also be applied by adding a column for available, on deputation, engaged etc. finally against each project and person name you can put the monthly spread.
After completion of this database you just need to put the pivot table and you can get the report in whichever fomat you want.

Please login or join to reply

Content ID:
ADVERTISEMENTS

"If we knew what it was we were doing, it would not be called research, would it?"

- Albert Einstein

ADVERTISEMENT

Sponsors