Working up a budget like you would with a spreadsheet....

[John]

Hi,
Does anyone know if you can set up view with names of all
your resources on a project in columns, so that you can
quickly work up a budget, and see at a glance how many
hours each resource works each task? (similar to the way
you would set up a spreadsheet to work out a project
budget)
ie
Task Jack Kathryn Will John Cost
Task 1 8hrs 4hrs $1200
Task 2 2hrs $200
Task 3 1hr $100

Appreciate any advice....
Cheers
John

 

[Jan De Messemaeker]

Hi John,

1. The Task Usage view will give equivalent results;
2. To exactly make what you want you need some programming (f.i. VBA) to
make the Excel sheet as you see it.

HTH

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
Project Management Consultancy
Prom+ade BVBA
32-495-300 620

 

[John]

Many thanks for the answer Jan.

The task usage view is not quite what I want as the
resouces get listed in rows under each task, so it makes a
very long list. I was hoping that there would be a way to
list the reources in columns beside the tasks to make it
more compact, or are you saying this is not possible
without programming?

Regards
John

 

[Jan De Messemaeker]

Hi,

Yes unfortunately this sort of matrix is not a standard view in Project.
Greetings,

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
Project Management Consultancy
Prom+ade BVBA
32-495-300 620

 

[Rob Schneider]

John,

I don't know of a view/report that looks just like this, but without VBA
programming you could export the data from Project into an Excel
spreadsheet and then do a quick pivot table summing work by Task Name
and Resource Name