Hello All

I have a spreadsheet which lists a set of projects in column A with
months across the top in Row 1. Each project has a total cost and
duration. My challenge is to distribute the cost across the duration
of the project according to a pre determined pattern. Different types
of projects will have different types of cost distribution, one type
front loaded and another back loaded, etc. I have also created a table
which lists different distribution patterns based on standard project
duration of 12 months. A drop down list is provided in Col B to select
the appropriate distribution pattern. The problem is that two
projects may have the same distribution of costs but different
durations. Is there a way for me to compress / or expand the
distribution pattern and then apply the resulting values to the project
cost and distribute the costs over the appropriate time period.


Thanks in advance for your help

Vitor Jose