Sounds like you need Project 2002! It has 10 extra baselines, so you could
apply Rate B, save to Baseline1 and you can also set which baseline Project
2002 uses to calculate Earned Value.
Use the following macro to swap rates quickly.
Dim R as Resource
Dim A as Assignment
For Each R In ActiveProject.Resources
For Each A In R.Assignments
A.CostRateTable = 0 '0 - Rate A, 1 - Rate B and so on.
Visit www.mvps.org/project/ for the Project MVP's FAQ and third party
Microsoft Project MVP
Visit www.projectlearning.com for customized Project and Office VBA macros
and Project companion software
> Thanks Rod
> This worked the way you describe but there are still some issues for me...
> I had set-up the rate table prior so that was there - Following your
> I changed the rate per task in the Resource Usage View - this did
> new costs at the new rate (although fill down doesn't seem to work for
> Back in the Guantt Chart tracking view I added the cost column - I had
> it out in favour of baseline and actual costs - which I prefer to track
> My baseline costs remained at the original numbers and my cost column
> displayed the new value - what could be interpreted as revenue and cost.
> Unfortunately I use EVR both internally and externally and this method
> not help me in that regard.
> Looks like I am still back to excel to manipulte the data
> > Hi,
> > Try:
> > View Resource Sheet.
> > Double-click each resource and under the Costs tab enter a rate B for
> > internal costs.
> > View, Resource Usage view.
> > Insert the Cost Rate Table column. Change the first A to a B then use
> > Fill Down to change the rest to Rate B. Your project costs are now
> > Now you can visit www.woodyswatch.com/project and search the archives
> > because I think I did a macro years ago that automated creating a report
> > Excel showing cost to client and internal cost. If you can't find it my
> > memory is obviously fading more than I thought, but the macro is
> > in Special Edition Using Project 2000 by Tim Pyron (I wrote the VBA
> > for it). A working copy should be on the accompanying CD. Visit my site
> > a direct link to Amazon to buy it. It will pay the cost of the book very
> > quickly if you have to produce that report regularly.
> > --
> > Visit www.mvps.org/project/ for the Project MVP's FAQ and third party
> > add-ons
> > Rod Gill
> > Microsoft Project MVP
> > Visit www.projectlearning.com for customized Project and Office VBA
> > and Project companion software
> > > I work in professional services and need to use two cost rates in my
> > > projects
> > > - one to report charges and budget budget to customers
> > > - one to report internal costs and budget performance to management
> > > I have tried using a custom field - aka cost1 - and changed it's name
> > > charge but it does not calculate in any view remaining at 0 while the
> > > standard cost calculates fine.
> > > and it does not even show as available for reports.
> > > this makes me have to do most of my reporting off line from MSP- I
> > > alone in this requirement but none of my current peers or work mates
> > an
> > > answer.
> > > has anyone solved this problem?