General Guidelines for use of Calculated field over using a Macro: 

• Schedule owner needs realtime information
• Calculation flags things that can be fixed at the source as they happen (example: indicator turns red if the amount of work or date is out of specified bounds)
• Data needs to be accurate even if you forget to run macro

General Guidelines for use of a Macro over using Calculated Field: 

• Calculation is dependent on results of other calculations or data from other tasks or assignments
• Data is being put into operational fields (ie: into actual finish, work, remaining work etc.)
• Calculation is part of a suite of calculations or checks that can be packaged and defined in the scheduling process
• Calculation of Field hurts performance when done on each change
• Calculation is very complicated and needs documentation & version control

Back to Main Page