Display Annual Costs

[Evadbass]

We have projects and tasks that can last over several years. I would like to
create columns to display the cost for the tasks on an annual basis. My
current project has a one column each for 2007, 2008 & 2009, as well as a
total cost column. I can display these costs in the cost reports, but I am
unable to display them in the columns when looking at the Gantt Chart. I
figure I need to develop a formula for the calculation, but I do not know how
to calculate the costs using the year as a time constraint.

Any help would be greatly appreciated!!

 

[John]

We have projects and tasks that can last over several years. I would like to
create columns to display the cost for the tasks on an annual basis. My
current project has a one column each for 2007, 2008 & 2009, as well as a
total cost column. I can display these costs in the cost reports, but I am
unable to display them in the columns when looking at the Gantt Chart. I
figure I need to develop a formula for the calculation, but I do not know how
to calculate the costs using the year as a time constraint.

Any help would be greatly appreciated!!

Evadbass,
Why not use the Task Usage view and set the timescale to show years?

The data you want can be shown in the Gantt Chart view and it might be
possible with customized fields with formulas but those formulas will
get complex in a hurry for tasks that cross year boundaries. In my
opinion it would be much easier to use VBA to set up the Gantt Chart
view that you want.

John
Project MVP

 

[Evadbass]

Thank you for the quick reply John. I had found I could display the annual
(fiscal) cost information in the Task Usage screen, as well as in the
reports. The desire (from the corner office) was to provide a summary of the
project(s). As tasks are rolled up, the "summary" would show the Gantt Chart
as well as the projected annual costs, all on one sheet. Unfortunately, my
experience with VBA is even less than with MS Project. They may just have to
deal with two pages!

Thanks again for the help!

 

[John]

Thank you for the quick reply John. I had found I could display the annual
(fiscal) cost information in the Task Usage screen, as well as in the
reports. The desire (from the corner office) was to provide a summary of the
project(s). As tasks are rolled up, the "summary" would show the Gantt Chart
as well as the projected annual costs, all on one sheet. Unfortunately, my
experience with VBA is even less than with MS Project. They may just have to
deal with two pages!

Thanks again for the help!

Evadbass,
As I mentioned, if you don't have any tasks that cross a year boundary,
then you could use a formula in a custom field for each year. But
otherwise, it's VBA time.

John
Project MVP