Resource Rate - Escalated Table

A

Aviator

Dear Sir (or Madam);
Contracting to the government involves planning labor rates, under two
circumstances: ON-SITE vs OFF-SITE, over an esclation schedule. For example;

ON-SITE ($/hr) | 2004| 2005| 2006| 2007|2008 etc..
Engineering Scientist |59.80|61.60|63.44|65.34|67.31|...
Engineering Technician |24.84|27.81|25.59|26.35|27.14|...
etc.

OFF-SITE ($/hr) | 2004| 2005| 2006| 2007|2008 etc..
Engineering Scientist |65.00|66.95|68.95|71.02|73.15|...
Engineering Technician |27.00|27.81|28.64|29.50|30.39|...
etc.

These Resource Rate data presently exist in an Excel spreadsheet. Question:
What's the best way to import this kind of resource info into Ms. Project?...
 
J

John

Aviator said:
Dear Sir (or Madam);
Contracting to the government involves planning labor rates, under two
circumstances: ON-SITE vs OFF-SITE, over an esclation schedule. For example;

ON-SITE ($/hr) | 2004| 2005| 2006| 2007|2008 etc..
Engineering Scientist |59.80|61.60|63.44|65.34|67.31|...
Engineering Technician |24.84|27.81|25.59|26.35|27.14|...
etc.

OFF-SITE ($/hr) | 2004| 2005| 2006| 2007|2008 etc..
Engineering Scientist |65.00|66.95|68.95|71.02|73.15|...
Engineering Technician |27.00|27.81|28.64|29.50|30.39|...
etc.

These Resource Rate data presently exist in an Excel spreadsheet. Question:
What's the best way to import this kind of resource info into Ms. Project?...
Click to expand...

Aviator,
Your question is nearly identical to one asked last week in this
newsgroup. Use a search and look for the post, "Import resource cost
data" by Jenn on Oct 26, 2005.

Hope this helps.
John
Project MVP
 
Top