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

Tagged with

#Excel alternatives for data analysis
#natural language processing for spreadsheets
#generative AI for data analysis
#real-time data collaboration
#real-time collaboration
#rows.com
#Excel compatibility
#cloud-based spreadsheet applications
#Excel alternatives
#resource curves
#hours
#variable period
#duration
#timeline
#manual entry
#duration A
#duration B
#end date
#start date
#adjust hours
Trying to build variable period resource curves