Log In
Register
Home
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
Trusted Members
Moderators
Power BI
January 31, 2022
Online
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
1 Guest(s)
