Hello. First-time posting so please forgive any breaches of etiquette.
I have been using excel for over 20 years and rarely come across something that stumps me, but I have a real quandry on my hands and am very much in need of your collective wisdom.
I am analyzing the distribution of costs expended by month over the duration of various construction projects. The duration of each project varies based on the size and complexity of the job. My objective is to establish a standard cost distribution curve for a project of x duration based upon the historical distribution of costs relative to duration.
In order to accomplish this, I need to re-cast each project's distribution - increasing or decreasing the percentage of costs expended in each month to fit the desired time period (e.g. to convert the distribution for an 11 month project into a proportionately equivalent distribution over 9 months). Then I can calculate a normalized 9 month curve by averaging all projects, since all differences in duration have been normalized.
Below is a link to a graphic that illustrates what I am trying to accomplish. Any help is greatly appreciated!
https://app.box.com/s/zwl4lbt6lf20o3xp7nrb4x4m5lgbye84
I have been using excel for over 20 years and rarely come across something that stumps me, but I have a real quandry on my hands and am very much in need of your collective wisdom.
I am analyzing the distribution of costs expended by month over the duration of various construction projects. The duration of each project varies based on the size and complexity of the job. My objective is to establish a standard cost distribution curve for a project of x duration based upon the historical distribution of costs relative to duration.
In order to accomplish this, I need to re-cast each project's distribution - increasing or decreasing the percentage of costs expended in each month to fit the desired time period (e.g. to convert the distribution for an 11 month project into a proportionately equivalent distribution over 9 months). Then I can calculate a normalized 9 month curve by averaging all projects, since all differences in duration have been normalized.
Below is a link to a graphic that illustrates what I am trying to accomplish. Any help is greatly appreciated!
https://app.box.com/s/zwl4lbt6lf20o3xp7nrb4x4m5lgbye84
