J
Jenn
I am not sure if I should be posting here or on the developers discussion
group but here goes.
I am having some trouble with historic and current resource cost rates. I
need both in my project as the project spans multiple fiscal years and salary
changes occur between and during fiscal years.
We use the project import wizard to update our employee (resource)
information. The excel file contains employee name (which become resource
name in MSP) and cost rate (which becomes standard rate in MSP) along with
some other info like phone #, etc. This file is generated from our corporate
server which updates employee rates weekly.
We have 75-100 employees. We update the resource portion of the project file
quarterly. (This is due to the fact that our salary information for some of
our staff can change every 3-4 months). What I would like to do is perform
the import from excel using the same file described above, but when I import
I would like to be able to set the Effective Date for the resource cost rates
equal to the day that I perform the import. Then I would like the cost rate
I am importing to be the new standard rate for present and future tasks.
As it is now, when I import the data I can either override all of the past
employee salary rates (so I get the new cost rates applied to both past and
future tasks) or I can keep the employee cost rates the original values
entered initially (so the old rate is applied to the present and future
tasks). What I want is to be able to tell project “For all tasks performed in
the past keep the employees rates before the import date and for this day and
after use the new rate that I am importing.â€. I know I can do this manually
by going into the cost tab and typing in the Effective Date and its
corresponding rate but for 75+ employees that would be very tedious to do
every quarter.
Does anyone know if there is a way to do this?
I know some basic VBA so if any one has any suggestions or could point me in
the right direction I would really appreciate it.
TIA!
group but here goes.
I am having some trouble with historic and current resource cost rates. I
need both in my project as the project spans multiple fiscal years and salary
changes occur between and during fiscal years.
We use the project import wizard to update our employee (resource)
information. The excel file contains employee name (which become resource
name in MSP) and cost rate (which becomes standard rate in MSP) along with
some other info like phone #, etc. This file is generated from our corporate
server which updates employee rates weekly.
We have 75-100 employees. We update the resource portion of the project file
quarterly. (This is due to the fact that our salary information for some of
our staff can change every 3-4 months). What I would like to do is perform
the import from excel using the same file described above, but when I import
I would like to be able to set the Effective Date for the resource cost rates
equal to the day that I perform the import. Then I would like the cost rate
I am importing to be the new standard rate for present and future tasks.
As it is now, when I import the data I can either override all of the past
employee salary rates (so I get the new cost rates applied to both past and
future tasks) or I can keep the employee cost rates the original values
entered initially (so the old rate is applied to the present and future
tasks). What I want is to be able to tell project “For all tasks performed in
the past keep the employees rates before the import date and for this day and
after use the new rate that I am importing.â€. I know I can do this manually
by going into the cost tab and typing in the Effective Date and its
corresponding rate but for 75+ employees that would be very tedious to do
every quarter.
Does anyone know if there is a way to do this?
I know some basic VBA so if any one has any suggestions or could point me in
the right direction I would really appreciate it.
TIA!