How can I use MSProject to create cash flow diagrams, including b.

[Phil]

I'm trying to take the costs associated with a number of activities (approx
6000), roll them up to a summary level (approx 1200) and produce a cash flow
using MS Project.

Is there any way to create either a linear spread of the $$ against the
schedule. Preferably, I would spread the costs on specific criteria against
activities with similar traits, but would accept a linear spread of costs
against the schedule.

Thanks,

 

[John]

Phil,
For starters, have you tried the built-in Reports feature under,
View/Reports/Cash/Cash Flow report. Although the built-in reports lack
some flexibility, depending on the exact output structure you want, with
some judicious filtering, you may be able to get what you want.

If the Cash Flow Report just doesn't cut it, you might try customizing
the Task Usage view. With the usage view you can apply both filtering
and grouping for a little more flexibility.

If you want the ultimate in a customized report, I would use a VBA macro
to gather the data from Project and export it to Excel. Using this
approach, all Project data and any variants thereof can be created,
exported, formatted and plotted, if desired, in Excel.

Hope this helps.
John