# 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.

Columns | Title | Description |
---|---|---|

activity_table_tid | Activity Table ID | The Table ID referencing the Task Network to use for a scenario. |

activity_table_name | Activity Table Name | The name of the table containing the Task Network to use for a scenario. |

task_types_tid | Task Types Table ID | A Task Types (p3) Table referenced by Table ID |

task_types_name | Task Types Name | A Task Types (p3) Table referenced by Name |

time_dist_curve_name | Time Distribution Curve Name | A time distribution curve referenced by Name |

time_dist_curve_tid | Time Distribution Curve Table ID | A time distribution curve referenced by Table ID |

cost_dist_curve_name | Cost Distribution Curve Name | A cost distribution curve referenced by Name. |

cost_dist_curve_tid | Cost Distribution Curve Table ID | A cost distribution curve referenced by Table ID |

time_est_short | Short Duration Estimate | The estimated shortest duration of an activity or task type. |

time_est_median | Median Duration Estimate | The estimated median duration of an activity or task type. |

time_est_long | Long Duration Estimate | The estimated longest duration of an activity or task type. |

time_probability_point | Time Probability Point | A percentage along one or more (cumulative) distribution curves representing a range of durations. |

cost_est_low | Low Cost Estimate | The estimated median cost of an activity or task type. |

cost_est_median | Median Cost Estimate | The estimated lowest cost of an activity or task type. |

cost_est_high | High Cost Estimate | The estimated highest cost of an activity or task type. |

cost_probability_point | Cost Probability Point | A percentage along one or more (cumulative) distribution curves representing a range of costs. |

db_format | Database Format | A format to use for a report. |

index_equation | Index Equation | A user defined function for purposes of prioritizing paths differently than PRETTI. |

precision | Precision | A number specifying the count of digits to the right of the decimal. |

tprecision | Time unit Precision | A number specifying the count of digits to the right of the decimal for time units. |

cprecision | Costs Precision | A number specifying the count of digits to the right of the decimal for cost units. |

eprecision | Eco2 Precision | A number specifying the count of digits to the right of the decimal for eco2 units. |

pert_omp | PERT expected time (Te) | Calculate a value from PERT 'expected time function' where Te = ( Optimal + 4 x Median + Pessimistic ) / 6 |

max_concurrent | Maximum Concurrent Tasks | The maximum number of a specific activity that can operate indefinitely. |

max_discount_pct | Max Discount Pct | Maximum Discount for batch (contiguous) runs. Expressed as a percent cost of a run. A 10% discount equals '0.1'. |

max_reduction_pct | Max Reduction Pct | Maximum Reduction for batch (contiguous) runs. Expressed as a percent eco2 of a run. A 10% reduction equals '0.1'. |

max_run_time | Max Run Time | A constraint of a maximum time a batch can run before a break. |

max_tasks_per_run | Max Tasks per Run | A constraint of a maximum number of times a task can be repeated without a break. |

max_overlap_pct | Percent Maximum Overlap | A decimal percentage (0 to 1) of maximum amount of overlap between concurrent operations of same activity. |

eco2_est_low | Low Eco2 Estimate | The estimated median eco2 of an activity or task type. |

eco2_est_median | Median Eco2 Estimate | The estimated lowest eco2 of an activity or task type. |

eco2_est_high | High Eco2 Estimate | The estimated highest eco2 of an activity or task type. |

eco2_probability_point | Eco2 Probability Point | A percentage along one or more (cumulative) distribution curves representing a range of eco2 values. |

eco2_dist_curve_tid | Eco2 Distribution Curve Table ID | An eco2 distribution curve referenced by Table ID |

eco2_dist_curve_name | Eco2 Distribution Curve Name | An eco2 distribution curve referenced by Name. |

## Task Network (p2) *

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

Columns | Title | Description |
---|---|---|

activity_ref | Activity Reference | A unique reference or ID for a specific, possibly repeatable task. |

dependent_tasks | Dependent Tasks | Tasks that this activity or task directly depends on. |

aid_type | Activity ID Type | Reference for an activity defined in the scenario's referenced Task Types (p3) table. |

name | Name | A unique word used as a reference as in a variable or table name. |

description | Description | A sentence or phrase describing activity or task type. |

max_concurrent | Maximum Concurrent Tasks | The maximum number of a specific activity that can operate indefinitely. |

max_discount_pct | Max Discount Pct | Maximum Discount for batch (contiguous) runs. Expressed as a percent cost of a run. A 10% discount equals '0.1'. |

max_reduction_pct | Max Reduction Pct | Maximum Reduction for batch (contiguous) runs. Expressed as a percent eco2 of a run. A 10% reduction equals '0.1'. |

max_run_time | Max Run Time | A constraint of a maximum time a batch can run before a break. |

max_tasks_per_run | Max Tasks per Run | A constraint of a maximum number of times a task can be repeated without a break. |

max_overlap_pct | Percent Maximum Overlap | A decimal percentage (0 to 1) of maximum amount of overlap between concurrent operations of same activity. |

time_est_short | Short Duration Estimate | The estimated shortest duration of an activity or task type. |

time_est_median | Median Duration Estimate | The estimated median duration of an activity or task type. |

time_est_long | Long Duration Estimate | The estimated longest duration of an activity or task type. |

time_dist_curve_tid | Time Distribution Curve Table ID | A time distribution curve referenced by Table ID |

time_dist_curve_name | Time Distribution Curve Name | A time distribution curve referenced by Name |

time_probability_point | Time Probability Point | A percentage along one or more (cumulative) distribution curves representing a range of durations. |

cost_est_low | Low Cost Estimate | The estimated median cost of an activity or task type. |

cost_est_median | Median Cost Estimate | The estimated lowest cost of an activity or task type. |

cost_est_high | High Cost Estimate | The estimated highest cost of an activity or task type. |

cost_dist_curve_tid | Cost Distribution Curve Table ID | A cost distribution curve referenced by Table ID |

cost_dist_curve_name | Cost Distribution Curve Name | A cost distribution curve referenced by Name. |

cost_probability_point | Cost Probability Point | A percentage along one or more (cumulative) distribution curves representing a range of costs. |

time_actual | Time Actual | The actual time it took for an activity to complete. |

cost_actual | Cost Actual | The actual cost it took to complete an activity. |

eco2_actual | Eco2 Actual | The eco2 it took to complete an activity. |

eco2_est_low | Low Eco2 Estimate | The estimated median eco2 of an activity or task type. |

eco2_est_high | High Eco2 Estimate | The estimated highest eco2 of an activity or task type. |

eco2_est_median | Median Eco2 Estimate | The estimated lowest eco2 of an activity or task type. |

eco2_dist_curve_tid | Eco2 Distribution Curve Table ID | An eco2 distribution curve referenced by Table ID |

eco2_dist_curve_name | Eco2 Distribution Curve Name | An eco2 distribution curve referenced by Name. |

eco2_probability_point | Eco2 Probability Point | A percentage along one or more (cumulative) distribution curves representing a range of eco2 values. |

## Task Types (p3)

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

Columns | Title | Description |
---|---|---|

type | Type | A classification of an activity or task. |

dependent_tasks | Dependent Tasks | Tasks that this activity or task directly depends on. |

dependent_types | Dependent Types | Types that this Task Type depends on. (not yet implemented) |

name | Name | A unique word used as a reference as in a variable or table name. |

description | Description | A sentence or phrase describing activity or task type. |

max_concurrent | Maximum Concurrent Tasks | The maximum number of a specific activity that can operate indefinitely. |

max_discount_pct | Max Discount Pct | Maximum Discount for batch (contiguous) runs. Expressed as a percent cost of a run. A 10% discount equals '0.1'. |

max_reduction_pct | Max Reduction Pct | Maximum Reduction for batch (contiguous) runs. Expressed as a percent eco2 of a run. A 10% reduction equals '0.1'. |

max_run_time | Max Run Time | A constraint of a maximum time a batch can run before a break. |

max_tasks_per_run | Max Tasks per Run | A constraint of a maximum number of times a task can be repeated without a break. |

max_overlap_pct | Percent Maximum Overlap | A decimal percentage (0 to 1) of maximum amount of overlap between concurrent operations of same activity. |

time_dist_curve_name | Time Distribution Curve Name | A time distribution curve referenced by Name |

time_dist_curve_tid | Time Distribution Curve Table ID | A time distribution curve referenced by Table ID |

cost_dist_curve_name | Cost Distribution Curve Name | A cost distribution curve referenced by Name. |

cost_dist_curve_tid | Cost Distribution Curve Table ID | A cost distribution curve referenced by Table ID |

time_est_short | Short Duration Estimate | The estimated shortest duration of an activity or task type. |

time_est_median | Median Duration Estimate | The estimated median duration of an activity or task type. |

time_est_long | Long Duration Estimate | The estimated longest duration of an activity or task type. |

cost_est_low | Low Cost Estimate | The estimated median cost of an activity or task type. |

cost_est_median | Median Cost Estimate | The estimated lowest cost of an activity or task type. |

cost_est_high | High Cost Estimate | The estimated highest cost of an activity or task type. |

eco2_est_low | Low Eco2 Estimate | The estimated median eco2 of an activity or task type. |

eco2_est_high | High Eco2 Estimate | The estimated highest eco2 of an activity or task type. |

eco2_est_median | Median Eco2 Estimate | The estimated lowest eco2 of an activity or task type. |

eco2_dist_curve_tid | Eco2 Distribution Curve Table ID | An eco2 distribution curve referenced by Table ID |

eco2_dist_curve_name | Eco2 Distribution Curve Name | An eco2 distribution curve referenced by Name. |

eco2_probability_point | Eco2 Probability Point | A percentage along one or more (cumulative) distribution curves representing a range of eco2 values. |

## Report Table (p4)

A tabular report with one path per column.

Columns | Title | Description |
---|---|---|

path_1 | CP | Critical Path |

## Activity Audit Table (p5)

A tabular report with one activity per row.

Columns | Title | Description |
---|---|---|

activity_ref | Activity Reference | A unique reference or ID for a specific, possibly repeatable task. |

activity_counter | Activity Counter | A sequential activity number for waypoint or activity. Each path's first activity begins with one. |

dependencies_q | Has Dependencies? | Answers question about an activity. 1 is yes, 0 is no. |

direct_dependencies | Direct Dependencies | Tasks that an activity directly depends on. |

dependencies_count | Dependencies count | Count of all dependencies. |

count_on_cp_p | CP Count | Answers question: How many of this activity is on the critical path? |

on_a_sig_path_p | On a Significant Path? | Answers question: Is this activity on a significant path? |

act_freq_in_load_cp_alts | Activity Run Count | Number of times an activity is completed across all paths. |

popularity | Popularity | An indication to the relative use of item compared to others. |

activity_time | Activity Time | The duration of an activity at predesignated Time Probability Point |

waypoint_duration | Waypoint Duration | Duration of a path of activities and it's dependencies at specified Time Probability Point. |

t_dc_source | TDC Source | Source of time distribution curve (via acc_fin::curve_import) |

activity_cost | Activity Cost | Cost of an activity at predesignated Cost Probability Point |

waypoint_cost | Waypoint Cost | Subtotal of an activity's cost and it's dependencies at specified Cost Probability Point |

c_dc_source | CDC Source | Source of cost distribution curve (via acc_fin::curve_import) |

activity_eco2 | Activity Eco2 | Eco2 of an activity at predesignated Cost Probability Point |

waypoint_eco2 | Waypoint Eco2 | Subtotal of an activity's eco2 and it's dependencies at specified Eco2 Probability Point |

e_dc_source | EDC Source | Source of eco2 distribution curve (via acc_fin::curve_import) |

act_coef | Activity Coefficient | The number of times a base activity is processed, when an activity is defined as a multiple of another. |

max_concurrent | Maximum Concurrent Tasks | The maximum number of a specific activity that can operate indefinitely. |

max_run_time | Max Run Time | A constraint of a maximum time a batch can run before a break. |

max_tasks_per_run | Max Tasks per Run | A constraint of a maximum number of times a task can be repeated without a break. |

max_overlap_pct | Percent Maximum Overlap | |

max_discount_pct | Max Discount Pct | |

max_reduction_pct | Max Reduction Pct | |

max_path_duration | Maximum Path Duration | Maximum duration of paths that have a specific activity in common. |

t_dc | TDC | Time distribution curve's internal reference |

c_dc | CDC | Cost distribution curve's internal reference |

e_dc | EDC | Eco2 distribution curve's internal reference |

## Path Audit Table (p6)

A tabular report with one path per row.

Columns | Title | Description |
---|---|---|

path_idx | Path Index | An internally fixed path reference number for this report. |

path | Path | One route along the network from begining to end. |

path_counter | Path Counter | A path sequence number for this report. |

cp_q | In Critical Path? | Answers question about an activity. 1 is yes, 0 is no. |

significant_q | Relatively Significant? | Answers question about a path of activities. 1 is yes, 0 is no. |

path_duration | Path Duration | Duration of path. |

path_cost | Path Cost | Cost of a completed path including all dependencies not on path. |

index_custom | Index Custom | Index value using a custom (non-PRETTI) index equation |

path_eco2 | Path Eco2 | Eco2 of a completed path including all dependencies not on path. |

path_len | Path Length | Number of different activities in path |

path_len_w_coefs | Path Length with Coefficients | Number of activities in path |

## Distribution Curve (dc)

A table representing a discrete distribution curve.

Columns | Title | Description |
---|---|---|

y | Y | A 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. |

x | X | A number representing a relative weighted value or decimal probability percent (0 to 1) of variable Y occurring within a discrete (possibly cumulative) distribution. |

label | Label | A tag reference or short phrase that identifies a data point. |

* = Required

Unrecognized references are ignored.

## Index Equation Variables

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

Custom Equation Variable | PRETTI Variable | Description |
---|---|---|

$0 | path_len | Number of different activities in path |

$1 | path_len_w_coefs | Number of activities in path |

$2 | act_cp_ratio | Ratio of activities in path that are also in Critical Path |

$3 | cost_ratio | Cost ratio: cost of path / cost of project |

$4 | on_critical_path_p | 1 if path is Critical Path, otherwise 0 |

$5 | duration_ratio | Duration ratio: duration of path / duration of Critical Path |

$6 | path_counter | A path's sequence number from Critical Path based on PRETTI index |

$7 | act_count_median | Median count of unique activities on a path. |

$8 | act_count_max | Max count of unqiue activities on a path. |

$9 | paths_count | Count of all complete paths. |

$10 | a_sig_path_p | 1 if path contains at least one activity that is above the median count (act_path_count_median), otherwise 0 |