Can the limit of 5 cost rate tables be increased?

[Rick Strong]

We currently have a need to 12+ cost rate tables. Is there any work around
for this constraint. From a practial standpoint we perform upwards of 150
projects per year, many of which are multi-year efforts. Typically,
commercial, city, state, and federal all have different allowable rates. In
addition it can be different fee schedules between states.

Thanks,

Rick

 

[Rod Gill]

Unfortunately, no. There is one solution that looks like this:

In SQL Server create a table of rates for each resource in each project,
including effective date increases.

In Project use VBA to read in rates for reporting purposes. With project
Server these rates will be over-written next time you open the project. In
stand alone mode changes will survive, but you may want to delete them
before closing for security reasons.

If you only need to report on costs once a week, running a macro like this
is very doable and protects the data from those you don't want to see it.

If you don't have easy access to SQL Server, rate data can be stored in
Access or Excel. VBA works just as easily with them.

--

Rod Gill
Microsoft MVP for Project - http://www.project-systems.co.nz

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

We currently have a need to 12+ cost rate tables. Is there any work
around
for this constraint. From a practial standpoint we perform upwards of 150
projects per year, many of which are multi-year efforts. Typically,
commercial, city, state, and federal all have different allowable rates.
In
addition it can be different fee schedules between states.

Thanks,

Rick

__________ Information from ESET Smart Security, version of virus
signature database 4983 (20100329) __________

The message was checked by ESET Smart Security.

http://www.eset.com

__________ Information from ESET Smart Security, version of virus signature database 4983 (20100329) __________

The message was checked by ESET Smart Security.

http://www.eset.com