Historic Resource Costs  
Author Message
Ludovic





PostPosted: Tue Nov 01 05:08:39 CST 2005 Top

Microsoft Project >> Historic Resource Costs

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!

DotNet225  
 
 
Gérard





PostPosted: Tue Nov 01 05:08:39 CST 2005 Top

Microsoft Project >> Historic Resource Costs Hello Jenn,

Did you read John's answer : 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?

Gérard



> 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!
>


 
 
Jenn





PostPosted: Tue Nov 01 09:19:01 CST 2005 Top

Microsoft Project >> Historic Resource Costs Gerard,
Hello. yes I posted that last question too. I was hoping someone could point
me in the right direction for coding advice as I cannot do this all by hand
with so many employees. Unfortunately, like many others I have inherited this
ms project file...
Do you know of any other places I can look for a little VBA/ MS project help
with this?
Thanks so much!
Jenn



> Hello Jenn,
>
> Did you read John's answer : 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?
>
> Gérard
>


> > 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!
> >
>
>
>
 
 
Mike





PostPosted: Tue Nov 01 10:26:11 CST 2005 Top

Microsoft Project >> Historic Resource Costs Hi Jenn,

Try posting on the developer newsgroup. Please see FAQ Item: 24. Project
Newsgroups. FAQs, companion products and other useful Project information
can be seen at this web address: http://project.mvps.org/faqs.htm

Mike Glen
Project MVP



> Gerard,
> Hello. yes I posted that last question too. I was hoping someone
> could point me in the right direction for coding advice as I cannot
> do this all by hand with so many employees. Unfortunately, like many
> others I have inherited this ms project file...
> Do you know of any other places I can look for a little VBA/ MS
> project help with this?
> Thanks so much!
> Jenn
>

>
>> Hello Jenn,
>>
>> Did you read John's answer : 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?
>>
>> Gérard
>>


>>> 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!