Inflating Standard Rates

[Jon Akers]

I want to add inflation to an existing resource sheet. i know how to do this
for each resoucre individually but surely there is a way to apply the same
annual inflation to the whole sheet???????????

 

[Mike Glen]

Hi Jon,

Welcome to this Microsoft Project newsgroup

In the Resource Sheet, inset a customisable column like Text1 and rename it Inflation. Right click the column heading and select Customize fields... In the dialog, select Formula... Enter this formula: [Standard Rate]+[Standard Rate]*10/100. Change the 10 to whatever the percent increase is. OK, OK to get back to the Resource Sheet. Now Copy the whole of the Inflation column and paste it into the Standard Cost column. Voilá! Use the same formula again next year.

FAQs, companion products and other useful Project information can be seen at this web address: http://project.mvps.org/faqs.htm

Hope this helps - please let us know how you get on

Mike Glen
MS Project MVP
See http://tinyurl.com/2xbhc for my free Project Tutorials



I want to add inflation to an existing resource sheet. i know how to do this
for each resoucre individually but surely there is a way to apply the same
annual inflation to the whole sheet???????????

 

[Jim Aksel]

A VBA Macro is neceessary I am afraid if you want to do it automatically.

For each resource, you can change the work rates by placng an effective date
and a new rate on the resource sheet. Double click the resource name, go to
their cost/rate table and enter the new data.

Repeat for each resourcce (making it a loop or a For Each)
--
If this post was helpful, please consider rating it.

Jim Aksel, MVP

Check out my blog for more information:
http://www.msprojectblog.com

 

[Rod Gill]

This is a quick and easy way, but all rates from the moment you do this have
the new value. If you want rates to increase only from a set date you need
to manually update each resource's rates from an effective date. Jim's VBA
idea would work.

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com



"Mike Glen" <mcglenAThotmail.com> wrote in message
Hi Jon,

Welcome to this Microsoft Project newsgroup

In the Resource Sheet, inset a customisable column like Text1 and rename it
Inflation. Right click the column heading and select Customize fields... In
the dialog, select Formula... Enter this formula: [Standard Rate]+[Standard
Rate]*10/100. Change the 10 to whatever the percent increase is. OK, OK to
get back to the Resource Sheet. Now Copy the whole of the Inflation column
and paste it into the Standard Cost column. Voilá! Use the same formula
again next year.

FAQs, companion products and other useful Project information can be seen at
this web address: http://project.mvps.org/faqs.htm

Hope this helps - please let us know how you get on

Mike Glen
MS Project MVP
See http://tinyurl.com/2xbhc for my free Project Tutorials



I want to add inflation to an existing resource sheet. i know how to do this
for each resoucre individually but surely there is a way to apply the same
annual inflation to the whole sheet???????????


__________ Information from ESET Smart Security, version of virus signature
database 4613 (20091116) __________

The message was checked by ESET Smart Security.

http://www.eset.com


__________ Information from ESET Smart Security, version of virus signature database 4613 (20091116) __________

The message was checked by ESET Smart Security.

http://www.eset.com