Forum

Notifications
Clear all

Value distribution

2 Posts
2 Users
0 Reactions
82 Views
(@Anonymous)
Posts: 0
New Member Guest
 

Dear all, I have the following Excel problem: It has to do with man power demand distribution over time eg. I need a Project Manager over 12 month in total 120 hours. What is simple is to distribute the demand linear over 12 months which would result in 120/12 = 10h/month. Now what I want is eg. distribute the total demand as linear increasing or decreasing from month 1 to month 12 or similar (n to m) conserving the sum = total demand. How can I achieve this? I‘m lost … thx for any help

 
Posted : 26/02/2022 8:11 pm
Riny van Eekelen
(@riny)
Posts: 1217
Member Moderator
 

I created a small model that allows you to allocate 120 hrs, linearly over a 12 month period. 

The principle here is: ( First + Last ) / half the number of months = 120

Half of 12 = 6, so ( First + Last ) = 120 / 6 = 20

 

So, when the First value = 5, the Last value must be 15 (i.e. 20 - 5). Similarly, if First = 3 then Last = 17.

The formula used in the attached workbook is:

=period number * (last-first) / 11 + first - ( last - first ) / 11

Screenshot-2022-02-26-at-07.38.40.png

 
Posted : 27/02/2022 2:45 am
Share: