#1
|
|||
|
|||
Viewing Resource Rates
Hi - I am planning my budget for the next year. I am wondering if there is a way to pull a report or export to excel a view of just the resources I have entered in and their rates for the next budget year. Currently I am going one by one and it is taking forever! Please help! - decker |
#2
|
|||
|
|||
I am a little confused on what you are asking here.
Do you have multiple rates for the resources over the 12 month period? Do you want to view the total cost for each resource based on rates and hours? If you just need the rates for all resources and have only a single standard rate for each, can't you just pull the data from the resource sheet view. You can select and copy to excel. Please share more details about what exactly you need. Cheers! Leah |
#3
|
|||
|
|||
Thanks for the response Leah.
I am looking in the resource sheet view and want to see what the rates for my resources will be over the next 12 months. In the current view for February 2014, I can see the rates of the resources. What I want to see is from May 2014 - May 2015, since the rates will escalate during those periods. The way that I am looking them up now is by clicking on each name, going to the costs tab, and looking at the effective dates for each of the rates. I feel like there must be a simpler way to look at the resources projected rates for all my out dates. Does that help with the explanation? |
#4
|
|||
|
|||
I was afraid that was what you wanted. I don't know of a way to access the rate table other than the method you are using except using VBA. I am not programmer so I cannot help with this.
Sorry. |
#5
|
|||
|
|||
Have you looked at the visual reports? This may be an option. I am not sure. I haven't used the reports much.
|
#6
|
|||
|
|||
ARGH! Thanks for the feedback.
|
#7
|
|||
|
|||
Yes. it requires a custom report - but pretty easy to do:
Project Ribbon > Reports, Custom New. Select Resource. On the Resource Report definition page - rename the report. Select any time range you need. I would likely apply the Work Resource Filter. Click the details tab and select Cost Rates. Click OK You should now have the report showing each resource along with each of the 5 cost rates tables plus any changes. |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Multiple Standard Rates Based on Location | JohnTurner | Project | 3 | 01-23-2014 12:09 PM |
Over-allocated resource - resource holiday | scott.hannaford | Project | 1 | 10-21-2013 05:32 AM |
Please help :viewing reoccurred appointments | niceicman | Outlook | 0 | 01-20-2011 10:33 AM |
Viewing problem | tglandon | Excel | 0 | 06-09-2010 08:33 AM |
Viewing Faxes. | Wiley | Outlook | 16 | 09-05-2006 08:40 AM |