Hi all,

I appreciate any help you can offer with the following. I am trying to
distribute or spread the cost of projects across different years given
specified ratios.

The ratios change according to project duration. If it is 3 quarters long,
the formula is 30%,40%,30% of the cost so that the total is 100%. If it is 4
quarters long, it becomes 20%,30%,30%,20% and so forth. I have the ratios
arranged by duration from 3 quarters until 24 quarters. so I already have 1
column showing duration, while the next columns showing the percentages..

Project starting dates are formatted as quarter number then year number
(such as, Q2 1999) and so on.

My data look like the following:
Project Name Cost Start Date Duration(Quarters) Q1 1995..Q1 1999 Q2 1999 Q3
1999..
Project1 $100 Q1 1999 3
Project2 $200 Q4 2000 4

As you can see, next to the table, I made a huge list of years from 1995
until 2020 split into quarters so that the costs can be distributed under
each one.
So, I would like the formula/function/macro to read the duration, then apply
the respective formula to the cost of that project and return the values
under each respective quarter which are listed in order to the right of that
table. For example, for project 1 above, the following cells should be filled:
Q1 1999 Q2 1999 Q3 1999
30 40 30

and for project 2, the following should take place:
Q4 2000 Q1 2001 Q2 2001 Q3 2001
40 60 60 40

I appreciate your help and thank you in advance..
regards,