none
Resource standard rate in resource usage RRS feed

  • Question

  • Hello,

    Is it possible to get the resource standard rate into a column in the resource usage view? i need this rate next to each of the assigned resources' tasks.

    THanks.

    Monday, February 18, 2013 2:57 PM

Answers

  • You can insert a column in the resource usage view (or specify the column in a table) for standard rate. Note that this will be the A table rate for the resource and will not show the rates per assignment if these differ.
    • Marked as answer by eagle_one34 Monday, February 18, 2013 8:19 PM
    Monday, February 18, 2013 3:11 PM

All replies

  • eagle_one34 --
     
    You can insert the Standard Rate column to the right of the Resource Names column, but as you already know, this shows the rate for only the resource and not for the assignments.  If you insert the Cost Rate Table column, you can see which cost rate table is applied to each assignment, from A through E, but you cannot see the actual dollar rate.  Hope this helps.
     

    Dale A. Howard [MVP]
    VP of Educational Services
    msProjectExperts
    http://www.msprojectexperts.com
    http://www.projectserverexperts.com
    "We write the books on Project Server"

    Monday, February 18, 2013 3:07 PM
    Moderator
  • You can insert a column in the resource usage view (or specify the column in a table) for standard rate. Note that this will be the A table rate for the resource and will not show the rates per assignment if these differ.
    • Marked as answer by eagle_one34 Monday, February 18, 2013 8:19 PM
    Monday, February 18, 2013 3:11 PM
  • eagle_one34,

    Yes this can be done in an extra Assignment Test field (e.g. Text1) but the data will either have to be entered manually or it could be automated with a macro. And the following code should do what you want. Just add the Text1 field next to the Name field in the Resource Usage view.

    Sub AssRates()
    Dim r As Resource
    Dim a As Assignment
    Dim TblN As Integer, Tbl As String

    For Each r In ActiveProject.Resources
        For Each a In r.Assignments
            TblN = a.CostRateTable
            Select Case TblN
                Case 0: Tbl = "A"
                Case 1: Tbl = "B"
                Case 2: Tbl = "C"
                Case 3: Tbl = "D"
                Case 4: Tbl = "E"
            End Select
            a.Text1 = r.CostRateTables(Tbl).PayRates(1).StandardRate
        Next a
    Next r
    End Sub

    John


    Monday, February 18, 2013 4:22 PM
  • Thank you All.
    Monday, February 18, 2013 8:19 PM