How do i rollup resource fields into task fields in MS Project?

[Baz-ITstrategist]

Hi All

MS Project Prof 2003

I am trying to enter custom number or costs to resources in a task, using
the Task usage view, I am expecting the task Cost1 to roll up the resoucre
cost1's - as per following, but in my project the Task 1 does note get
calculated


(Cost 1)
- Task 1 $100
== Res1 $50
== Res2 $30
== Res3 $20

Thanks
Barry

 

[Rod Gill]

Task Cost1 and Resource Cost1 are two totally separate fields. The only way
to get your total will be via VBA code.

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com

 

[Baz-ITstrategist]

Thanks for confirming my problem,

Does anyone have some sample VBA code I can try adapt?
Or know of any VBA for dummies websites I can look through.

Thanks
Baz-ITstrategist

 

[Jan De Messemaeker]

Hi,

There is some inspiration in FAQ 37 in
http://www.mvps.org/project/faqs.htm

HTH

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf

 

[Baz-ITstrategist]

Thanks I had look at that code. And changed text1 to Cost5.
But the task summary becomes the value in one of its resources..

I think the algorithm would be:
while in the task usage view:
For each task
for each resource that is assigned to the task above
tempTotal_resource = resource.cost5 + tempTotal_resource
next resource
next task

and while in the Resource usage view
For each resource
for each task the resource is assigned to
tempTotal_Task= Task.cost5 + tempTotal_task
next resource
next task

Also I realise I have no idea how the Resource and tasks are linked by the
coding.

I has been a long while since I coded, and I am feeling very stale

Many thanks
Barry