Acumen Touchstone 8.1.5 Online Help

Using the Help Search
Using the Help Search
  • Phrase:Returns all topics that contain the exact phrase in the search criteria. Use quotation marks around the phrase.
    Ex."system administration"
  • And:Returns all topics that contain all the words in the search criteria, in any combination. Insert a plus sign between all words in the search criteria.
    Ex.system + administration
  • Or:Returns all topics with any combination of words in the search criteria. This is the default.
    Ex.system administration
For more information:Searching Online Help

Microsoft Project (MPP) Calculated Fields

This topic contains information about .mpp calculated fields.

To Calculate... Rules
Activity Constraint / Primary Constraint
  • If Tsk.ConstraintType = As Late As Possible, then value is As Late As Possible
  • If Tsk.ConstraintType = Finish No Earlier Than, then value is Finish on or After
  • If Tsk.ConstraintType = Must Finish On, then value is Must Finish On.
  • If Tsk.ConstraintType = Must Start On, then value is Must Start On.
  • If Tsk.ConstraintType = Start No Earlier Than, then value is Start On Or After.
  • If Tsk.ConstraintType = Start No Later Than, then value is Start On Or Before.
Activity Status
  • If Tsk.ActualStart is not specified, then value is Planned.
  • If Tsk.ActualStart is specified but Tsk.ActualFinish is not specified, then value is In Progress.
  • If Tsk.ActualStart and Tsk.ActualFinish are both specified, then value is Complete.
Activity Type
  • If Tsk.IsSummary is true or Tsk.IsSubproject is true, then value is Summary.
  • If Tsk.IsMilestone is true, then value is Milestone.
  • If Tsk.IsMilestone is false, then value is Normal.
Total Float Tsk.TotalSlack / 10
Free Float Tsk.FreeSlack / 10
Remaining Duration Elapsed
Value is True if Tsk.DurationFormat = any of the following:
  • ElapsedDay
  • ElapsedMinute
  • ElapsedHour
  • ElapsedWeek
  • ElapsedMonth
  • ElapsedPercent
  • ElapsedMinuteEstimated
  • ElapsedHourEstimated
  • ElapsedDayEstimated
  • ElapsedWeekEstimated
  • ElapsedMonthEstimated
  • ElapsedPercentEstimated

If Tsk.DurationFormat is anything other than one of the above, then value is False.

Actual Cost
  • If Tsk.IsSummary of the activity is true, then value is Actual Cost of the activity less all of the Actual Costs of its child activities.
  • If Tsk.IsSummary of the activity is false, then value is Tsk.ActualCost of the activity.
Remaining Cost
  • If Tsk.IsSummary of the activity is true, then value is Remaining Cost of the activity less all of the Remaining Costs of its child activities.
  • If Tsk.IsSummary of the activity is false, then value is Tsk.RemainingCost of the activity.
Early Start
  • If Tsk.ConstraintType is As Late As Possible, then value is Tsk.LateStart.
  • If Tsk.ConstraintType is anything else, then value is Tsk.EarlyStart.
Early Finish
  • If Tsk.ConstraintType is As Late As Possible, then value is Tsk.LateFinish.
  • If Tsk.ConstraintType is anything else, then value is Tsk.EarlyFinish.
Baseline Start
  • The Start value from the first baseline of the activity.
Baseline Finish
  • The Finish value from the first baseline of the activity.
Baseline Cost
  • The Cost value from the first baseline of the activity.
Baseline Duration
  • The Duration value from the first baseline of the activity.
Baseline Work
  • The Work value from the first baseline of the activity.
Budget Cost
  • The sum of all of the Budget Costs of all the activity's resource assignments.
Duration Percent Complete
  • Remaining Duration / Total Duration.
EAC
  • [Tsk.ACWP + (BaselineCost - Tsk.BCWP)] / [Tsk.BCWP / Tsk.ACWP].
Finish
  • If Tsk.ActualFinish is not empty, then value is Tsk.ActualFinish.
  • If Tsk.ConstraintType is As Late As Possible, then value is Tsk.LateFinish.
  • If neither of the above is true, then value is Tsk.EarlyFinish.
Start
  • If Tsk.ActualStart is not empty, then value is Tsk.ActualStart.
  • If Tsk.ConstraintType is As Late As Possible, then value is Tsk.LateStart.
  • If neither of the above is true, then value is Tsk.EarlyStart.
Maximum Lag
  • Largest value of Lag from the activity's list of successors.
Minimum Lag
  • Smallest value of Lag from the activity's list of successors.
Number of FS Predecessors
  • Find the number of activity predecessors that have a link type of Finish to Start.
Number of FS Successors
  • Find the number of activity successors that have a link type of Finish to Start.
Number of SS Predecessors
  • Find the number of activity predecessors that have a link type of Start to Start.
Number of SS Successors
  • Find the number of activity successors that have a link type of Start to Start.
Number of SF Predecessors
  • Find the number of activity predecessors that have a link type of Start to Finish.
Number of SF Successors
  • Find the number of activity successors that have a link type of Start to Finish.
Number of FF Predecessors
  • Find the number of activity predecessors that have a link type of Finish to Finish.
Number of FF Successors
  • Find the number of activity successors that have a link type of Finish to Finish.
Number of Lags
  • Find the number of activity predecessors that have a positive value of Lag.
Number of Leads
  • Find the number of activity predecessors that have a negative value of Lag.
Number of Predecessors
  • Find the number of activity predecessors.
Number of Successors
  • Find the number of activity successors.
Percent Complete
  • If Percent Complete Type is Physical, then value is Physical Percent Complete.
  • If Percent Complete Type is Duration, then value is Duration Percent Complete (Remaining Duration / Total Duration).
  • If Percent Complete Type is Units, then value is Units Percent Complete (Remaining Units / Total Units)
Percent Complete Type
  • Value is always Duration.
Project Time Now
  • If Prj.StatusDate has a value, then the Project Time Now value is Prj.StatusDate; otherwise, the value is Prj.StartDate.
Sub-Project
  • Value is the Prj.Name of the activity's parent project.
Total Cost
  • Actual Cost + Remaining Cost.
Total Duration
  • Actual Duration + Remaining Duration.
Unit Percent Complete
  • Remaining Units / Total Units.
WBS Code / WBS Name
  • The WBS GUID from the current activity's parent activity.
WBS
  • The current activity's parent activity WBS' generated GUID.

Touchstone reads external relationships and external activities. This makes the count of relationships more accurate for metrics. External activities from P6 XER schedule or MPP schedules are now part of the list of activities used in calculating a score for an uploaded schedule unless metrics exclude external activities. External activities, however, are excluded from the random selection of activities used in determining the Project Critical Path Test and Logic Sensitivity.