Microsoft Project Help

[Jennifer]

How do I get the basline costs to add up all the sub tasks and the total to
be entered in the main task line. I know that I can do what I am wanting in
Excel but I want the scheduling part. i.e. Bathroom remodel, I have 5
differnet line items that I want to track the estimated cost and the actual
cost in a variance column. I want the 5 line items to add up in the Bathroom
column.

 

[Rod Gill]

Which column is the Bathroom column? If its a Cost1..Cost10 filed then
create a formula to do the sum for you.

 

[Steve House [Project MVP]]

Go to the Tools menu, Options, View tab, and in the lower right hand coender
turn on "View Project Summary Task." Then back in the Gantt chart, display
the Cost table.

 

[Jennifer]

How do I add a formula in the Cost1 column?

Which column is the Bathroom column? If its a Cost1..Cost10 filed then
create a formula to do the sum for you.

--

Rod Gill
Project MVP
Visit www.msproject-systems.com for Project Companion Tools and more

 

[Steve House [Project MVP]]

In the Tools menu choose Customise, Fields. It will probably open to show
task costs 1 thru 10 but if not, switch to display them. Pick one of them
and rename it to whatever you want to call it. Toward the bottom of that
screen, you'll find some settings for how you want that new column to roll
up to the summary line.

You said you want it to roll over into the Bathroom *column." Remember that
a project WBS is organized by deliverable and its components, broken down to
their smallest logical units. Generally I would expect "Bathroom" to be a
summary task LINE, not a column and the project organization would be ...

0 Remodel House
1 Remodel Bedroom
2 Remodel Kitchen
3 Remodel Bathroom
3.1 Remove old tile
3.2 Remove old fixtures
3.3 Install new fixtures
3.3.1 Plumb new fixtures
3.4 Install new tile
3.5 Repaint walls
4 Remodel Den
..etc
..
..