I would like to take the value of a project and divide it value by the number
of months it takes to construct. Then I would like to be able to take those
values and place in a table where the first entry is the month the project
starts in. There are multiple projects and multiple starting months.

Project Value Start Date Duration (months)

1 $500,000 1/10/2010 60
2 $400,000 2/25/2011 32
3 $900,000 8/15/2010 45

The goal is to be able to develop a cash flow by month over the duration of
all projects. I cannot seem to find any threads that deal with this idea.
The price, start date and duration may change periodically so I don't want to
keep manually reallocating the price.

Project Month 1 Month 2 Month 3 Month 4 Month 5 .....
Month x

1 10 10 10 10
2 30 30
30 30
3 20 20 20
20


Total 10 30 60 60
50 30

--
ksn