Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Resource Cost - 3 questions about usage & manipulation RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    I have some questions about Resource Rates, any advice/ideas would be useful.

    At the outset I mention that

    i) I'm working with Project Server 2007 &

    ii) I haven't touched the PSI yet and I'm not familiar with it

     

    My questions related with Resource Rates are:

    1) A rather basic question - Other than Effective Date, how do we specify which Rate we want to apply for a resource in a particular Task?

    2) Is there any way to link the Resource Standard Rate & Overtime Rate to the Designation (custom field)? So that we don't need to enter the Rates for each individual, and can make any Rate changes at one place only.

    3) Is the Resource Rate available only in Binary format in Project Server 2007?

    Is there no way I can access it in the SQL tables?

     

    I may be asking for too much, considering I'm not programming at the PSI level :)

    Depending on the possibilities I may find it necessary to finally do that too.

     

    Thanks in advance.

     

     

    Wednesday, July 28, 2010 6:56 AM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hello msp adin

    1) To specify a rate for a task, use the Resource Usage view and insert the column "Cost Rate Table".  Here you can select which rate to use.

    2) You need to set up a macro to change rates for many resources.  There isn't a single place to make rates.  Of course you could go something like open up the "Resource Sheet" and grab all your resources.  Remember you can put in a rate and drag the column value.  Much like you do in excel.

    3) The rate is in binary format.  You don't want to do make changes using SQL queries.  There are to many business rules in other tables that are related. That's one reason it's import to use the PSI.  It helps you manage the business rules.

    There is a sample PSI program in the SDK, that can get you started real quick.

    Cheers!

    Micahel Wharton, MBA, PMP, MCT

    Sincerely, Michael Wharton, MBA, PMP, MCT, MCSD, MCSE+I, MCDBA www.WhartonComputer.com
    Wednesday, July 28, 2010 12:51 PM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hello msp adin

    1) To specify a rate for a task, use the Resource Usage view and insert the column "Cost Rate Table".  Here you can select which rate to use.

    2) You need to set up a macro to change rates for many resources.  There isn't a single place to make rates.  Of course you could go something like open up the "Resource Sheet" and grab all your resources.  Remember you can put in a rate and drag the column value.  Much like you do in excel.

    3) The rate is in binary format.  You don't want to do make changes using SQL queries.  There are to many business rules in other tables that are related. That's one reason it's import to use the PSI.  It helps you manage the business rules.

    There is a sample PSI program in the SDK, that can get you started real quick.

    Cheers!

    Micahel Wharton, MBA, PMP, MCT

    Sincerely, Michael Wharton, MBA, PMP, MCT, MCSD, MCSE+I, MCDBA www.WhartonComputer.com
    Wednesday, July 28, 2010 12:51 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    So PSI it is...

     

    Thank you Michael!

    Thursday, July 29, 2010 5:05 AM