Trying to build variable period resource curves
I'm trying to build a tool to make "simple" resource curves based on a couple of variables.
All resources will have different values of hours "H" and all durations (In weeks) will fall into three groups Duration A, Duration B, Duration A+B where Duration A starts from the start of the timeline and duration B starts backwards from the end, Duration A+B would represent the total timeline. In my mind, Start date would be a manual entry field as well as duration A and duration B, end date would be calculated off the summation.
The hours would be spread over the duration (In months) using a selected curve 10/90 30/70, 50/50 etc... My super stretch goal is to then adjust hours in a time period to account for periods in a month 160 hours vs 200 for example.
Is there a function to this? Looking for someone to point me in the right direction to try build this myself over time.
[link] [comments]
Want to read more?
Check out the full article on the original site