locked
Efficiently Updating Resource Cost Rate Tables RRS feed

  • Question

  • Hi gang,

    Is it possible in version (server) 2010 to update resources' cost rates tables in bulk?  I.e., we would like edit the resource profile for a set of resources... e.g., edit table A, B, and C with a common rate (and effective date).  Is this possible without VBA?

     


    \Spiro Theopoulos PMP, MCITP. Montreal, QC (Canada)
    Saturday, November 6, 2010 12:55 AM

Answers

  • Cost Rate Table A is easy - that's just the Standard Rate.  You could open all of the resources in MS Project and just edit that field like you were using Excel.

    The other tables, I can't think of an easy way to bulk edit without VBA....


    Andrew Lavinsky [MVP] Twitter: @alavinsky Blog: http://blogs.catapultsystems.com/epm
    Saturday, November 6, 2010 3:32 AM

All replies

  • Cost Rate Table A is easy - that's just the Standard Rate.  You could open all of the resources in MS Project and just edit that field like you were using Excel.

    The other tables, I can't think of an easy way to bulk edit without VBA....


    Andrew Lavinsky [MVP] Twitter: @alavinsky Blog: http://blogs.catapultsystems.com/epm
    Saturday, November 6, 2010 3:32 AM
  • If I edit the Standard Rate field in MsP like Excel I modifying Standard Rate but I don't edit the effective date.

    How can I bulk edit resource cost rate of table A with an effective date ?  Do you know any VBA code or PSI or third party add-on that can help me ? 
    Tuesday, November 19, 2013 8:29 PM
  • See this example using the PSI: http://epmxperts.wordpress.com/2011/01/30/update-resource-cost-rate-using-psi/

    you could change this to do all resources.

    Paul


    Paul Mather | Twitter | http://pwmather.wordpress.com | CPS

    Tuesday, November 19, 2013 9:05 PM
  • Hi François,

    Our company has developed a VBA app that does this and bit more.  It allows you to export and / or import resource data to and from MS Project and Excel, including all the cost rate tables and their effective dates.

    Here is a short video that demos what and how it does it: http://www.screencast.com/t/HGTb5FMF

    If it is something that you would be interested in, feel free to contact me at: spiro@P2Dinc.ca

    Regards,

    Spiro Theopoulos

    P2D Inc.

    Laval, Quebec



    \Spiro Theopoulos PMP, MCITP. Montreal, QC (Canada)


    Wednesday, November 20, 2013 2:29 AM
  • Thanks this tips help a lot to make a choice on how I'll do the change.
    Monday, December 16, 2013 8:11 PM