Cost Rate Table question...help....

  • Thread starter R.Scott Fleming
  • Start date
R

R.Scott Fleming

Can someone suggest an easy way to modify my default (A) cost rate table and
copy it over into the (B) cost rate table?

I currently have all the cost data populated both for labor(w/effectively
dates) and material in the default cost rate table (A). I simply want to
apply a cost factor to labor (burden/overhead, example StandardRate*1.75) and
material (G&A, example StandardRate*1.85) and place those values in the (B)
rate table. I don't want to have to manually type all of those values into
(B).....too many resources.... Please help....

Is the only way to export the data from rate table A to excel, modify by
applying the factor, and then re-importing??? Seems to me there must be an
easier more reliable way...
 
R

Rod Gill

Sorry, I don't think there is. You can write a VBA macro to do this for you,
but if you are not skilled, it would be quicker to re-type them into B!

--

Rod Gill
Microsoft MVP for Project

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

R.Scott Fleming

Thank you Rod! I appreciate your quick response. I have a proposal due this
Monday, and was looking for a way to get this work done quicker... I will
take your advice and manually type it in... I have 30 resources with 2009 &
2010 rates and probably 25 material resources... I guess I better start
typing...

This sure seems to me something the program should make easier.... I guess
this however keeps VBA programmers/consultants employeed.

Thanks again!!!
 
R

R.Scott Fleming

Thank you Rod! I appreciate your quick response. I have a proposal due this
Monday, and was looking for a way to get this work done quicker... I will
take your advice and manually type it in... I have 30 resources with 2009 &
2010 rates and probably 25 material resources... I guess I better start
typing...

This sure seems to me something the program should make easier.... I guess
this however keeps VBA programmers/consultants employeed.

Thanks again!!!
 

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

Similar Threads

Cost Rate Table Macro request… 5
Add custom cost rate to rate tables 2
Maintenance of Cost Rate Tables in MS Project 2010 0
Default Alternate resource rate 2
Refer to resource cost in custom field formula 0
Adding Cost Field to Appointment 0
calculating cost of resources 4
Microsoft Project 2016 Monthly Cost Report/ Table Creation Help 0

Top