resources & rates importation into MS Project
 

Greetings:
This question has been submitted in prior postings with no responsive reply.
There is supposed to be a way for someone with excel to insert data
pertaining to the rates of workers as well as equipment. From this, MS
project can calculate the 'spend' rate for any person/ equipment.
Apparently, such data [which can possibly include overtime and other charges
for each worker and/or equipment] must be entered into the spreadsheet in a
certain way not apparent to excel novice. Exportation of data to a
spreadsheet is not a problem... It is the importation. Much thanks for any
guidance

resources & rates importation into MS Project
 

Look at worksheet menu Data - Validation. You can restrict the type of data
that can be entered into a cell.

"Maurice" wrote:

Greetings:
This question has been submitted in prior postings with no responsive reply.
There is supposed to be a way for someone with excel to insert data
pertaining to the rates of workers as well as equipment. From this, MS
project can calculate the 'spend' rate for any person/ equipment.
Apparently, such data [which can possibly include overtime and other charges
for each worker and/or equipment] must be entered into the spreadsheet in a
certain way not apparent to excel novice. Exportation of data to a
spreadsheet is not a problem... It is the importation. Much thanks for any
guidance