Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

How to apply business rules to all projects created in Microsoft project 2007

3 replies [Last post]
Gayatri Gadre
User offline. Last seen 12 years 13 weeks ago. Offline
Joined: 5 Apr 2012
Posts: 3
Groups: None

Hello,

 

I am looking for a tool to apply business rules to every project plan created in my organization. I am currently using Microsoft project 2007 and want to put some restrictions on every project manager creating a new project plan as per the business rules. Have you used any tool which can help me achieve that. Any help will be appreciated.

 

Thank you,

Gayatri Gadre

Replies

Rafael Davila
User offline. Last seen 2 days 7 hours ago. Offline
Joined: 1 Mar 2004
Posts: 5233

Do not judge all software based on the limitations of yours. Standard company rules can easily be implemented in Spider, so easy it is included on your first job tutorial.

Wat Gayatri is asking for makes a lot of sense, some software have their own implementations, most are basic, can only be applied to new jubs and not as powerful as for transfering changes to linked projects as Spider can do, but better something than nothing.

From Spider first job tutorial.

(Keep in mind it is just an introduction, more advanced functionalities such as filters, formulas, scripts etc. can be as easily linked to Reference Books, the following is just an introduction to the topic.)

SPIDER PROJECT

Instructions for novice users

PART

 

3. REFERENCE-BOOKS

 

Step 16. Creating Project Reference-Books

 

Reference-books or project databases are necessary for the implementation of the corporate project management standards.

 

Standard corporate reference-books include:

Resources reference-book that contains the list of project resources, their codes and other parameters,

Materials reference-book that contains the list of project materials, their codes and other parameters,

Cost Components reference-book that contains the list of project cost components, their codes and unit costs,

Cost and Material Requirements per Unit of Volume for typical activities,

Cost and Material Requirements per Unit of Volume for typical assignments,

Resource Productivity for typical assignments.

 

Other reference-books (including user defined) can be created and used if necessary.

One example: Activity type names reference-book may be used for setting Linear Diagram.

 

Reference-books can be linked with the projects and used for setting project parameters based on the corporate norms and standards. If this link is established then the data in all projects will be taken from the reference-books and changes in the reference-books can be applied to all projects that are linked with them. With this approach for creating project models one can be sure that all project data are consistent with the corporate norms and standards. Changing data in all projects (due to changes of the corporate norms, costs, etc.) becomes easy. It is sufficient to change data in the reference-books and update project models.

Best regards,

Rafael

Daniel Limson
User offline. Last seen 5 years 7 weeks ago. Offline
Joined: 13 Oct 2001
Posts: 318
Groups: None

 Hi Gayatri,

What kind of business rules are you talking about? If they are complex rules, i doubt existing sofwares can do it, especially if they involve any calculations.

If you can clarify more maybe we can help.

Regards,

Daniel