Dear all,
I am working with a workbook, which enables me to
1. have a capacity overview (total, per team, etc)
2. have a demand overview (total, per project, per team, per role)
3. make simulation / what-if scenarios.
The 3rd part is in order to make possible "movement" of projects from one date to another - in order to utilize the available capacity in the best possible way. I would like to be able to move around my demand blocks, so it gives me the best approximation against my available capacity.
The available capacity would be "heads", but also "realistic capacity", where I have considered productivity factor, etc.
Anyone have experience with such advanced workbooks? I am open for inspiration and advice...
Further, I would like to know if it is possible to have a first page, where you choose the project and enter the data.
_______________________________
But I also have a direct question...
In the attached sheet, I would like to calculate the columns "Min." and "Max." by taking sums of the "min" and "Max" values for every month (column range BE:EB). How can I do it quickly without doing it manually.
:::: Edited: How do I attach a file? I have uploaded it here
http://www.2shared.com/file/5960887/8931fafb/Test_capacityplan_ver03.html
Kind Regards
Baaz
I am working with a workbook, which enables me to
1. have a capacity overview (total, per team, etc)
2. have a demand overview (total, per project, per team, per role)
3. make simulation / what-if scenarios.
The 3rd part is in order to make possible "movement" of projects from one date to another - in order to utilize the available capacity in the best possible way. I would like to be able to move around my demand blocks, so it gives me the best approximation against my available capacity.
The available capacity would be "heads", but also "realistic capacity", where I have considered productivity factor, etc.
Anyone have experience with such advanced workbooks? I am open for inspiration and advice...
Further, I would like to know if it is possible to have a first page, where you choose the project and enter the data.
_______________________________
But I also have a direct question...
In the attached sheet, I would like to calculate the columns "Min." and "Max." by taking sums of the "min" and "Max" values for every month (column range BE:EB). How can I do it quickly without doing it manually.
:::: Edited: How do I attach a file? I have uploaded it here
http://www.2shared.com/file/5960887/8931fafb/Test_capacityplan_ver03.html
Kind Regards
Baaz
Last edited:
