Hey folks! I've been trying to develop a formula on my worksheet to generate trends and spend data for my project management group.
I have the following fields:
Design Budget
Construction Budget
Design Start Date
Design End Date
Const. Start Date
Const. End Date
Design Weight: X%
Const. Weight: Y%
What I would like is that I fill in those values and a chart or graph or list of months or weeks is generated with the proper spend rate, i.e. 15% of the budget spread across the design dates, then 85% of the budget spread across the construction period. There may or may not be a gap between Design and Construction, so it should drop to no spend in between.
Ultimately I was to generate a chart with two lines: one for the budget evenly trended (x dollars per day forming a flat line) + the more accurate spend curve based on the weighting and actual project dates.
Can anyone give me some guidance?
Thank you,
Scott
Bookmarks