D

#### Dream

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,