Notifications
Clear all
General Excel Questions & Answers
2
Posts
2
Users
0
Reactions
53
Views
Topic starter
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, Klaus
Posted : 12/11/2021 9:34 am
Hi Klaus,
Formulas will not work, you will need a vba solution for this.
Please provide a sample file with a manual example showing before and after results, with all conditions and restrictions that needs to be respected, will try to help.
Posted : 15/11/2021 11:41 pm
