1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

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.

submitted by /u/jcooklsu
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article