Re: How do i rollup resource fields into task fields in MS Project

Tech-Archive recommends: Fix windows errors by optimizing your registry

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



"Jan De Messemaeker" wrote:

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" <BazITstrategist@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message news:E3C627A7-6D57-412C-B049-364B140DC8C7@xxxxxxxxxxxxxxxx
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



"Rod Gill" wrote:

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" <Baz-ITstrategist @discussions.microsoft.com> wrote in
message news:B4594ED0-8869-49BE-97E9-BAA9A43C53F7@xxxxxxxxxxxxxxxx
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







.

Relevant Pages

  • Re: Resource text filds appearing in Gantt View
    ... This is only possible using a bit of VBA code and thus would require running ... Resource, the cell has a drop down menue for me to select a name from the ... Resource sheet. ... I would like to create a field on the Gantt ...
    (microsoft.public.project)
  • Re: Resource Allocate
    ... Task Usage and edit the hours for each day of the duration. ... Rod Gill ... How can i allocate the resource by this method. ...
    (microsoft.public.project)
  • Re: Filter not creating a drop down selection box - MSP2000
    ... resource and printing that. ... tasks for a selected resource, with a drop down selection for the resource. ... are you trying to create a report for each of several ... And yes, VBA code ...
    (microsoft.public.project)
  • Re: Filter not creating a drop down selection box - MSP2000
    ... SimmoH wrote: ... tasks for a selected resource, with a drop down selection for the resource. ... And yes, VBA code ...
    (microsoft.public.project)
  • Re: How do you merger multiple resources into one resource
    ... That depends on the number of occurrences. ... If you have many substitutions ... then try some vba code. ... the task and resource and click Replace... ...
    (microsoft.public.project)