Calculation of assignment cost fields and task usage view

R

rsmithgi

I have written a macro that calculates the burdened cost (stored in cost10)
of tasks by summing the burdened cost for each resource assigned to the task.

In addition, I'd like the burdened cost for each assignment to be saved as
well (in the cost10 assignment field). I cannot figure out where these are
displayed in project.

Ultimately, I want to output (to excel) as spreadsheet that looks like the
table section of the task usage and resource usage views.

task name Cost10
Task 1 $10,000
res 1 $3,000
res 2 $5000
res 3 $2000


When I store the burdened cost in the assignment.cost10 field, the value
does not appear in the task usage display.

Any suggestions?

thanks
Rich
 
J

Jan De Messemaeker

Hi,

I bet you are using Project 2007.
Microsoft took the incredible and totally unlogical decision to double the
assignment custom fields into "Task Assignment" fields, visible in the Task
Usage view, and "Resource Assignment" Fields visible in the Resource Usage
view. I personally think it's an oversight of the analyst, but they claim it
is by design.
Knowing that both these fields are addressed in VBA as assignment.cost10, I
wouldn't be proud of the design which moreover is in contrdiction to all
help files on the subject.

Ouff! Now that I spit my venom I'm gonna try to help you.

Read Faqs 37 and 51 on http://www.mvps.org/project/faqs.htm , they explain
in full and there is a sample VBA routine to overcome the problem.

Hope this helps,

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

Mike Glen

Hi Rich,

Try posting on the developer newsgroup. Please see FAQ Item: 24. Project
Newsgroups. FAQs, companion products and other useful Project information
can be seen at this web address: http://project.mvps.org/faqs.htm

Mike Glen
Project MVP
 
R

rsmithgi

You are correct, I am using Project 2007. I will look into the FAQs you
suggest.

thank you
 
M

Mike Glen

No problem, Rich - you seem to have some answers from Jan :)

Mike Glen
Project MVP
 
R

rsmithgi

I must be missing something. I have a macro that does the following:

for each task
for each task assignment
calculate the burdened cost
assign the burdened cost to the assignment.cost10 field
add the assignment burdened cost to the total cost for the task

for each resource in the project
for each resource assignment
if the resource assignments task ID is the current task
set the resource assignment.cost10 field
add the assignment burdened cost to the total cost for this
resource
end if
for each res asgn
for each res
for each task asgn
for each task

Unfortunately the cost10 column in the task usage display is still $0 for
all assigned resources in the table. The table in the resource usage view
look fine.

Any ideas? I can post actual code if necessary.
 
J

Jan De Messemaeker

Hi,

Yes, sorry, you are missing something.
The current, updated version of FAQ 37 has a macro foreProject 2003 AND a
macro for 2007.
Hope this helps
--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top