Project Reporting Evaluation and Track Task Interpretation

or Project Activity Network Evaluation by Reporting Low Float Paths in Fast Tracks

Scenario (p1) *

A table of named variables and their values (name, value pairs) that specify a scenario. Rows and columns may be in any order.

ColumnsTitleDescription
activity_table_tidActivity Table IDThe Table ID referencing the Task Network to use for a scenario.
activity_table_nameActivity Table NameThe name of the table containing the Task Network to use for a scenario.
task_types_tidTask Types Table IDA Task Types (p3) Table referenced by Table ID
task_types_nameTask Types NameA Task Types (p3) Table referenced by Name
time_dist_curve_nameTime Distribution Curve NameA time distribution curve referenced by Name
time_dist_curve_tidTime Distribution Curve Table IDA time distribution curve referenced by Table ID
cost_dist_curve_nameCost Distribution Curve NameA cost distribution curve referenced by Name.
cost_dist_curve_tidCost Distribution Curve Table IDA cost distribution curve referenced by Table ID
time_est_shortShort Duration EstimateThe estimated shortest duration of an activity or task type.
time_est_medianMedian Duration EstimateThe estimated median duration of an activity or task type.
time_est_longLong Duration EstimateThe estimated longest duration of an activity or task type.
time_probability_pointTime Probability PointA percentage along one or more (cumulative) distribution curves representing a range of durations.
cost_est_lowLow Cost EstimateThe estimated median cost of an activity or task type.
cost_est_medianMedian Cost EstimateThe estimated lowest cost of an activity or task type.
cost_est_highHigh Cost EstimateThe estimated highest cost of an activity or task type.
cost_probability_pointCost Probability PointA percentage along one or more (cumulative) distribution curves representing a range of costs.
db_formatDatabase FormatA format to use for a report.
index_equationIndex EquationA user defined function for purposes of prioritizing paths differently than PRETTI.
precisionPrecisionA number specifying the count of digits to the right of the decimal.
tprecisionTime unit PrecisionA number specifying the count of digits to the right of the decimal for time units.
cprecisionCosts PrecisionA number specifying the count of digits to the right of the decimal for cost units.
eprecisionEco2 PrecisionA number specifying the count of digits to the right of the decimal for eco2 units.
pert_ompPERT expected time (Te)Calculate a value from PERT 'expected time function' where Te = ( Optimal + 4 x Median + Pessimistic ) / 6
max_concurrentMaximum Concurrent TasksThe maximum number of a specific activity that can operate indefinitely.
max_discount_pctMax Discount PctMaximum Discount for batch (contiguous) runs. Expressed as a percent cost of a run. A 10% discount equals '0.1'.
max_reduction_pctMax Reduction PctMaximum Reduction for batch (contiguous) runs. Expressed as a percent eco2 of a run. A 10% reduction equals '0.1'.
max_run_timeMax Run TimeA constraint of a maximum time a batch can run before a break.
max_tasks_per_runMax Tasks per RunA constraint of a maximum number of times a task can be repeated without a break.
max_overlap_pctPercent Maximum OverlapA decimal percentage (0 to 1) of maximum amount of overlap between concurrent operations of same activity.
eco2_est_lowLow Eco2 EstimateThe estimated median eco2 of an activity or task type.
eco2_est_medianMedian Eco2 EstimateThe estimated lowest eco2 of an activity or task type.
eco2_est_highHigh Eco2 EstimateThe estimated highest eco2 of an activity or task type.
eco2_probability_pointEco2 Probability PointA percentage along one or more (cumulative) distribution curves representing a range of eco2 values.
eco2_dist_curve_tidEco2 Distribution Curve Table IDAn eco2 distribution curve referenced by Table ID
eco2_dist_curve_nameEco2 Distribution Curve NameAn eco2 distribution curve referenced by Name.
activity_table_tid *

Task Network (p2) *

A table defining tasks and their dependencies. Columns may be in any order.

ColumnsTitleDescription
activity_refActivity ReferenceA unique reference or ID for a specific, possibly repeatable task.
dependent_tasksDependent TasksTasks that this activity or task directly depends on.
aid_typeActivity ID TypeReference for an activity defined in the scenario's referenced Task Types (p3) table.
nameNameA unique word used as a reference as in a variable or table name.
descriptionDescriptionA sentence or phrase describing activity or task type.
max_concurrentMaximum Concurrent TasksThe maximum number of a specific activity that can operate indefinitely.
max_discount_pctMax Discount PctMaximum Discount for batch (contiguous) runs. Expressed as a percent cost of a run. A 10% discount equals '0.1'.
max_reduction_pctMax Reduction PctMaximum Reduction for batch (contiguous) runs. Expressed as a percent eco2 of a run. A 10% reduction equals '0.1'.
max_run_timeMax Run TimeA constraint of a maximum time a batch can run before a break.
max_tasks_per_runMax Tasks per RunA constraint of a maximum number of times a task can be repeated without a break.
max_overlap_pctPercent Maximum OverlapA decimal percentage (0 to 1) of maximum amount of overlap between concurrent operations of same activity.
time_est_shortShort Duration EstimateThe estimated shortest duration of an activity or task type.
time_est_medianMedian Duration EstimateThe estimated median duration of an activity or task type.
time_est_longLong Duration EstimateThe estimated longest duration of an activity or task type.
time_dist_curve_tidTime Distribution Curve Table IDA time distribution curve referenced by Table ID
time_dist_curve_nameTime Distribution Curve NameA time distribution curve referenced by Name
time_probability_pointTime Probability PointA percentage along one or more (cumulative) distribution curves representing a range of durations.
cost_est_lowLow Cost EstimateThe estimated median cost of an activity or task type.
cost_est_medianMedian Cost EstimateThe estimated lowest cost of an activity or task type.
cost_est_highHigh Cost EstimateThe estimated highest cost of an activity or task type.
cost_dist_curve_tidCost Distribution Curve Table IDA cost distribution curve referenced by Table ID
cost_dist_curve_nameCost Distribution Curve NameA cost distribution curve referenced by Name.
cost_probability_pointCost Probability PointA percentage along one or more (cumulative) distribution curves representing a range of costs.
time_actualTime ActualThe actual time it took for an activity to complete.
cost_actualCost ActualThe actual cost it took to complete an activity.
eco2_actualEco2 ActualThe eco2 it took to complete an activity.
eco2_est_lowLow Eco2 EstimateThe estimated median eco2 of an activity or task type.
eco2_est_highHigh Eco2 EstimateThe estimated highest eco2 of an activity or task type.
eco2_est_medianMedian Eco2 EstimateThe estimated lowest eco2 of an activity or task type.
eco2_dist_curve_tidEco2 Distribution Curve Table IDAn eco2 distribution curve referenced by Table ID
eco2_dist_curve_nameEco2 Distribution Curve NameAn eco2 distribution curve referenced by Name.
eco2_probability_pointEco2 Probability PointA percentage along one or more (cumulative) distribution curves representing a range of eco2 values.
activity_ref, dependent_tasks *

Task Types (p3)

A table defining task types. Columns may be in any order.

ColumnsTitleDescription
typeTypeA classification of an activity or task.
dependent_tasksDependent TasksTasks that this activity or task directly depends on.
dependent_typesDependent TypesTypes that this Task Type depends on. (not yet implemented)
nameNameA unique word used as a reference as in a variable or table name.
descriptionDescriptionA sentence or phrase describing activity or task type.
max_concurrentMaximum Concurrent TasksThe maximum number of a specific activity that can operate indefinitely.
max_discount_pctMax Discount PctMaximum Discount for batch (contiguous) runs. Expressed as a percent cost of a run. A 10% discount equals '0.1'.
max_reduction_pctMax Reduction PctMaximum Reduction for batch (contiguous) runs. Expressed as a percent eco2 of a run. A 10% reduction equals '0.1'.
max_run_timeMax Run TimeA constraint of a maximum time a batch can run before a break.
max_tasks_per_runMax Tasks per RunA constraint of a maximum number of times a task can be repeated without a break.
max_overlap_pctPercent Maximum OverlapA decimal percentage (0 to 1) of maximum amount of overlap between concurrent operations of same activity.
time_dist_curve_nameTime Distribution Curve NameA time distribution curve referenced by Name
time_dist_curve_tidTime Distribution Curve Table IDA time distribution curve referenced by Table ID
cost_dist_curve_nameCost Distribution Curve NameA cost distribution curve referenced by Name.
cost_dist_curve_tidCost Distribution Curve Table IDA cost distribution curve referenced by Table ID
time_est_shortShort Duration EstimateThe estimated shortest duration of an activity or task type.
time_est_medianMedian Duration EstimateThe estimated median duration of an activity or task type.
time_est_longLong Duration EstimateThe estimated longest duration of an activity or task type.
cost_est_lowLow Cost EstimateThe estimated median cost of an activity or task type.
cost_est_medianMedian Cost EstimateThe estimated lowest cost of an activity or task type.
cost_est_highHigh Cost EstimateThe estimated highest cost of an activity or task type.
eco2_est_lowLow Eco2 EstimateThe estimated median eco2 of an activity or task type.
eco2_est_highHigh Eco2 EstimateThe estimated highest eco2 of an activity or task type.
eco2_est_medianMedian Eco2 EstimateThe estimated lowest eco2 of an activity or task type.
eco2_dist_curve_tidEco2 Distribution Curve Table IDAn eco2 distribution curve referenced by Table ID
eco2_dist_curve_nameEco2 Distribution Curve NameAn eco2 distribution curve referenced by Name.
eco2_probability_pointEco2 Probability PointA percentage along one or more (cumulative) distribution curves representing a range of eco2 values.
type *

Report Table (p4)

A tabular report with one path per column.

ColumnsTitleDescription
path_1CPCritical Path

Activity Audit Table (p5)

A tabular report with one activity per row.

ColumnsTitleDescription
activity_refActivity ReferenceA unique reference or ID for a specific, possibly repeatable task.
activity_counterActivity CounterA sequential activity number for waypoint or activity. Each path's first activity begins with one.
dependencies_qHas Dependencies?Answers question about an activity. 1 is yes, 0 is no.
direct_dependenciesDirect DependenciesTasks that an activity directly depends on.
dependencies_countDependencies countCount of all dependencies.
count_on_cp_pCP CountAnswers question: How many of this activity is on the critical path?
on_a_sig_path_pOn a Significant Path?Answers question: Is this activity on a significant path?
act_freq_in_load_cp_altsActivity Run CountNumber of times an activity is completed across all paths.
popularityPopularityAn indication to the relative use of item compared to others.
activity_timeActivity TimeThe duration of an activity at predesignated Time Probability Point
waypoint_durationWaypoint DurationDuration of a path of activities and it's dependencies at specified Time Probability Point.
t_dc_sourceTDC SourceSource of time distribution curve (via acc_fin::curve_import)
activity_costActivity CostCost of an activity at predesignated Cost Probability Point
waypoint_costWaypoint CostSubtotal of an activity's cost and it's dependencies at specified Cost Probability Point
c_dc_sourceCDC SourceSource of cost distribution curve (via acc_fin::curve_import)
activity_eco2Activity Eco2Eco2 of an activity at predesignated Cost Probability Point
waypoint_eco2Waypoint Eco2Subtotal of an activity's eco2 and it's dependencies at specified Eco2 Probability Point
e_dc_sourceEDC SourceSource of eco2 distribution curve (via acc_fin::curve_import)
act_coefActivity CoefficientThe number of times a base activity is processed, when an activity is defined as a multiple of another.
max_concurrentMaximum Concurrent TasksThe maximum number of a specific activity that can operate indefinitely.
max_run_timeMax Run TimeA constraint of a maximum time a batch can run before a break.
max_tasks_per_runMax Tasks per RunA constraint of a maximum number of times a task can be repeated without a break.
max_overlap_pctPercent Maximum OverlapA decimal percentage (0 to 1) of maximum amount of overlap between concurrent operations of same activity.
max_discount_pctMax Discount PctMaximum Discount for batch (contiguous) runs. Expressed as a percent cost of a run. A 10% discount equals '0.1'.
max_reduction_pctMax Reduction PctMaximum Reduction for batch (contiguous) runs. Expressed as a percent eco2 of a run. A 10% reduction equals '0.1'.
max_path_durationMaximum Path DurationMaximum duration of paths that have a specific activity in common.
t_dcTDCTime distribution curve's internal reference
c_dcCDCCost distribution curve's internal reference
e_dcEDCEco2 distribution curve's internal reference

Path Audit Table (p6)

A tabular report with one path per row.

ColumnsTitleDescription
path_idxPath IndexAn internally fixed path reference number for this report.
pathPathOne route along the network from begining to end.
path_counterPath CounterA path sequence number for this report.
cp_qIn Critical Path?Answers question about an activity. 1 is yes, 0 is no.
significant_qRelatively Significant?Answers question about a path of activities. 1 is yes, 0 is no.
path_durationPath DurationDuration of path.
path_costPath CostCost of a completed path including all dependencies not on path.
index_customIndex CustomIndex value using a custom (non-PRETTI) index equation
path_eco2Path Eco2Eco2 of a completed path including all dependencies not on path.
path_lenPath LengthNumber of different activities in path
path_len_w_coefsPath Length with CoefficientsNumber of activities in path

Distribution Curve (dc)

A table representing a discrete distribution curve.

ColumnsTitleDescription
yYA value of time, cost, eco2 or other measure in a discrete set of variable Y values, where each value is associated with a probability or relative weighted frequency.
xXA number representing a relative weighted value or decimal probability percent (0 to 1) of variable Y occurring within a discrete (possibly cumulative) distribution.
labelLabelA tag reference or short phrase that identifies a data point.
y, x *

* = Required

Unrecognized references are ignored.

Index Equation Variables

Variables used in creating a custom PRETTI index for path sorting.

Custom Equation VariablePRETTI VariableDescription
$0path_lenNumber of different activities in path
$1path_len_w_coefsNumber of activities in path
$2act_cp_ratioRatio of activities in path that are also in Critical Path
$3cost_ratioCost ratio: cost of path / cost of project
$4on_critical_path_p1 if path is Critical Path, otherwise 0
$5duration_ratioDuration ratio: duration of path / duration of Critical Path
$6path_counterA path's sequence number from Critical Path based on PRETTI index
$7act_count_medianMedian count of unique activities on a path.
$8act_count_maxMax count of unqiue activities on a path.
$9paths_countCount of all complete paths.
$10a_sig_path_p1 if path contains at least one activity that is above the median count (act_path_count_median), otherwise 0