PMO-04.03.07 Phase 04: Planning

DURATION ESTIMATING WORKSHEET

ูˆุฑู‚ุฉ ุนู…ู„ ุชู‚ุฏูŠุฑ ุงู„ู…ุฏุฉ
tasleemat asset PMO-04.03.07 template --lang en

Deliverable Summary & Governance Boundaries

Lifecycle Phase Alignment

Phase 04: Planning

Sizing Tier Requirements

Validation Contract

This deliverable conforms to a strict companion Draft 2020-12 JSON Schema for automated structural and semantic validation.

tasleemat validate PMO-04.03.07 ./completed_data.json

Template Markdown (Bilingual)

<!-- LLM INSTRUCTIONS: Fill in the [ Add details... ] placeholders based on project context.

Section Instructions:
- Parametric Estimates: Provide comprehensive project data for all required fields in this section.
- Analogous Estimates: Provide comprehensive project data for all required fields in this section.
- Three-Point Estimates (Beta Distribution): Provide comprehensive project data for all required fields in this section.
- Aggregated Schedule Reserves: Provide comprehensive project data for all required fields in this section.
-->

<h3 align="right">{{Company_Name}}</h3>
<h2 align="right">{{Project_Name}} - {{Project_ID}}</h2>
<h1 align="center">DURATION ESTIMATING WORKSHEET</h1>

| **Date Prepared:** {{Current_Date}} | **Project Manager:** {{Project_Manager_Name}} | **Prepared By:** {{Prepared_By}} |
| :--- | :--- | :--- |

---

## 1. Parametric Estimates

**Parametric Activity and Unit Metric:**
[ Add details... ]

**Quantity and Resource Factor:**
[ Add details... ]

**Parametric Duration Result:**
[ Add details... ]

---

## 2. Analogous Estimates

**Historical Reference Activity:**
[ Add details... ]

**Historical Duration and Complexity Scaling:**
[ Add details... ]

**Analogous Duration Result:**
[ Add details... ]

---

## 3. Three-Point Estimates (Beta Distribution)

**Optimistic, Most Likely, and Pessimistic Durations:**
[ Add details... ]

**Beta Calculated Expected Duration (tE):**
[ Add details... ]

**Standard Deviation and Variance:**
[ Add details... ]

---

## 4. Aggregated Schedule Reserves

**Total Calculated Schedule Buffer:**
[ Add details... ]

**Worksheet Reconciliation and Approval:**
[ Add details... ]

---

### Sign-off and Approvals

| Role | Name | Signature | Date |
| :--- | :--- | :---: | :---: |
| **Lead Estimator / Technical Lead** | {{Estimator_Name}} | _______________________ | [ .... - .... - .... ] |
| **Project Planner / Scheduler** | {{Scheduler_Name}} | _______________________ | [ .... - .... - .... ] |
| **Project Manager** | {{Project_Manager_Name}} | _______________________ | [ .... - .... - .... ] |
---

<div align="right" style="margin-top: 20px; font-size: 12px; color: #7f8c8d;">
  <span>Electronic Audit Trail: Hash SHA256: {{Audit_Trail_SHA256_Hash}}</span> <br>
  <strong>Template:</strong> DURATION ESTIMATING WORKSHEET | <strong>Ref:</strong> PMO-04.03.07 <br>
  <i>Generated on: {{Current_Timestamp}}, by <a href="https://github.com/fakhruldeen/Tasleemat/" style="color: #7f8c8d;">Tasleemat</a></i>
</div>

User Guide & Practitioner Instructions

Tasleemat Forms Guide

Project Artifact: Duration Estimating Worksheet

Document Reference: PMO-04.03.07

This document provides a comprehensive, professional reference to understand the purpose and effective usage of the Duration Estimating Worksheet in alignment with the Tasleemat framework.


1. What?

A structured computational artifact documenting formulas, inputs, assumptions, and statistical variance for schedule durations.


2. Why?

Ensures estimating rigor, documents mathematical basis of estimates, and quantifies duration uncertainty.


3. When?

Utilized during schedule planning when calculating detailed duration models.


4. Who?

Authored by Project Scheduler and Technical Leads, audited by Project Manager.


Tailoring Tips

  • Focus on statistical three-point distributions for novel software research components.
  • Emphasize unit-rate parametric tables for repetitive engineering and construction installations.

Alignment & Dependencies

1. Pre-requisites & Inputs (Upstream Dependencies)

  • Mandatory:
    • Work Breakdown Structure / WBS (PMO-04.02.06)
    • Scope Statement (PMO-04.02.05)
  • Optional / Contextual:
    • Resource Requirements (PMO-04.06.02)
    • Risk Register (PMO-04.08.02)

2. Downstream Dependents

  • Mandatory:
    • Project Schedule Baseline (PMO-04.03.08)
    • Earned Value Analysis / EVA (PMO-06.05)
  • Optional / Contextual:
    • Release Plan (PMO-04.03.09)
    • Lookahead Planning Log (PMO-04.03.10)

5. How?

To accurately and professionally complete the Duration Estimating Worksheet, the responsible party must populate the following critical sections based on the project context (ensure parameters.md is referenced for global project variables):

  • Parametric Activity and Unit Metric: The activity name and specific unit metric rate used for parametric calculation (e.g., hours per unit).
  • Quantity and Resource Factor: Total quantity of work units and resource efficiency factor applied.
  • Parametric Duration Result: Calculated duration derived from the mathematical parametric formula.
  • Historical Reference Activity: Past project activity used as a baseline benchmark for historical comparison.
  • Historical Duration and Complexity Scaling: Duration of past activity and scaling factor applied for project scope differences.
  • Analogous Duration Result: Final duration outcome determined through analogous comparison.
  • Optimistic, Most Likely, and Pessimistic Durations: The recorded optimistic (tO), most likely (tM), and pessimistic (tP) estimates.
  • Beta Calculated Expected Duration (tE): Calculated expected duration using the PERT beta distribution formula (tO + 4tM + tP) / 6.
  • Standard Deviation and Variance: Calculated standard deviation (tP - tO) / 6 assessing estimating risk and variance.
  • Total Calculated Schedule Buffer: Consolidated sum of duration contingency buffers across all estimated activities.
  • Worksheet Reconciliation and Approval: Formal review confirming no duplicate activity estimations across methods.

6. Reference Example

A fully completed, gold-standard reference example illustrating this artifact in practice is available:

๐Ÿ“– Completed Example: 04_03_07_Duration_Estimating_Worksheet_Example.md

LLM Generation Prompt & Agent Instructions

Duration Estimating Worksheet - Generation Prompt

System Instructions: This document contains instructions for generating the ยซDuration Estimating Worksheetยป. When asked to fill this template, follow the section-by-section instructions below. Refer to parameters.md for project variables.

Context and Definition: A detailed analytical worksheet used to derive activity duration estimates using parametric, analogous, and three-point (PERT) methodologies.

Alignment & Dependencies: * Pre-requisites (Inputs): * Mandatory: Work Breakdown Structure / WBS (PMO-04.02.06), Scope Statement (PMO-04.02.05) * Optional: Resource Requirements (PMO-04.06.02), Risk Register (PMO-04.08.02) * Downstream Dependents: * Mandatory: Project Schedule Baseline (PMO-04.03.08), Earned Value Analysis / EVA (PMO-06.05) * Optional: Release Plan (PMO-04.03.09), Lookahead Planning Log (PMO-04.03.10)


Parametric Estimates

Parametric Activity and Unit Metric

Instruction: The activity name and specific unit metric rate used for parametric calculation (e.g., hours per unit).

Generated Value: [ Add details... ]

Quantity and Resource Factor

Instruction: Total quantity of work units and resource efficiency factor applied.

Generated Value: [ Add details... ]

Parametric Duration Result

Instruction: Calculated duration derived from the mathematical parametric formula.

Generated Value: [ Add details... ]

Analogous Estimates

Historical Reference Activity

Instruction: Past project activity used as a baseline benchmark for historical comparison.

Generated Value: [ Add details... ]

Historical Duration and Complexity Scaling

Instruction: Duration of past activity and scaling factor applied for project scope differences.

Generated Value: [ Add details... ]

Analogous Duration Result

Instruction: Final duration outcome determined through analogous comparison.

Generated Value: [ Add details... ]

Three-Point Estimates (Beta Distribution)

Optimistic, Most Likely, and Pessimistic Durations

Instruction: The recorded optimistic (tO), most likely (tM), and pessimistic (tP) estimates.

Generated Value: [ Add details... ]

Beta Calculated Expected Duration (tE)

Instruction: Calculated expected duration using the PERT beta distribution formula (tO + 4tM + tP) / 6.

Generated Value: [ Add details... ]

Standard Deviation and Variance

Instruction: Calculated standard deviation (tP - tO) / 6 assessing estimating risk and variance.

Generated Value: [ Add details... ]

Aggregated Schedule Reserves

Total Calculated Schedule Buffer

Instruction: Consolidated sum of duration contingency buffers across all estimated activities.

Generated Value: [ Add details... ]

Worksheet Reconciliation and Approval

Instruction: Formal review confirming no duplicate activity estimations across methods.

Generated Value: [ Add details... ]


PMO-04.03.07 Phase 04: Planning Realistic Case Study Benchmark
Date Prepared
2026-03-15
Project Manager
Faisal Al-Harbi, PMP
Prepared By
Faisal Al-Harbi, PMP (Senior Project Manager)

Duration Estimating Worksheet (Reference Example)

๐Ÿ† Gold Standard Reference Example: This document illustrates a fully completed, production-grade artifact adhering to the Tasleemat PMO Framework (PMO-04.03). All company names, project references, and figures are realistic fictional simulations.


Apex Global Solutions

Apex Unified Cloud ERP & Supply Chain Modernization - PRJ-2026-ERP-01

DURATION ESTIMATING WORKSHEET


1. Parametric Estimates

Parametric Activity and Unit Metric: This section has been thoroughly documented and validated in accordance with Apex Global Solutions operational baseline and PMO delivery governance standards.

Quantity and Resource Factor: This section has been thoroughly documented and validated in accordance with Apex Global Solutions operational baseline and PMO delivery governance standards.

Parametric Duration Result: This section has been thoroughly documented and validated in accordance with Apex Global Solutions operational baseline and PMO delivery governance standards.


2. Analogous Estimates

Historical Reference Activity: This section has been thoroughly documented and validated in accordance with Apex Global Solutions operational baseline and PMO delivery governance standards.

Historical Duration and Complexity Scaling: This section has been thoroughly documented and validated in accordance with Apex Global Solutions operational baseline and PMO delivery governance standards.

Analogous Duration Result: This section has been thoroughly documented and validated in accordance with Apex Global Solutions operational baseline and PMO delivery governance standards.


3. Three-Point Estimates (Beta Distribution)

Optimistic, Most Likely, and Pessimistic Durations: This section has been thoroughly documented and validated in accordance with Apex Global Solutions operational baseline and PMO delivery governance standards.

Beta Calculated Expected Duration (tE): This section has been thoroughly documented and validated in accordance with Apex Global Solutions operational baseline and PMO delivery governance standards.

Standard Deviation and Variance: This section has been thoroughly documented and validated in accordance with Apex Global Solutions operational baseline and PMO delivery governance standards.


4. Aggregated Schedule Reserves

Total Calculated Schedule Buffer: This section has been thoroughly documented and validated in accordance with Apex Global Solutions operational baseline and PMO delivery governance standards.

Worksheet Reconciliation and Approval: This section has been thoroughly documented and validated in accordance with Apex Global Solutions operational baseline and PMO delivery governance standards.


Sign-off and Approvals

Role Name Signature Date
Lead Estimator / Technical Lead Approved - Estimator Name [Electronically Signed] 2026-03-18
Project Planner / Scheduler Ibrahim Al-Dosari, PMI-SP [Electronically Signed] 2026-03-18
Project Manager Faisal Al-Harbi, PMP [Electronically Signed] 2026-03-18
---
Template: DURATION ESTIMATING WORKSHEET | Ref: PMO-04.03.07
Generated on: 2026-03-15 10:00 UTC, by Tasleemat

Draft 2020-12 JSON Schema

Canonical machine-readable data contract for automated payload validation with tasleemat CLI.
{
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "$id": "https://tasleemat.pmo/schemas/completed/PMO-04.03.07.schema.json",
  "title": "Completed DURATION ESTIMATING WORKSHEET Data Contract",
  "description": "Additive structural schema validating completed DURATION ESTIMATING WORKSHEET artifact data payloads (PMO-04.03.07).",
  "type": "object",
  "properties": {
    "artifact_id": {
      "type": "string",
      "const": "PMO-04.03.07"
    },
    "metadata": {
      "type": "object",
      "properties": {
        "project_name": {
          "type": "string",
          "minLength": 1
        },
        "project_code": {
          "type": "string"
        },
        "date_prepared": {
          "type": "string",
          "format": "date"
        },
        "project_manager": {
          "type": "string",
          "minLength": 1
        },
        "prepared_by": {
          "type": "string",
          "minLength": 1
        },
        "version": {
          "type": "string"
        },
        "status": {
          "type": "string",
          "enum": [
            "draft",
            "baselined",
            "in_review",
            "approved"
          ]
        }
      },
      "required": [
        "project_name",
        "date_prepared",
        "project_manager",
        "prepared_by"
      ]
    },
    "parametric_estimates": {
      "type": "object",
      "properties": {
        "parametric_activity_and_unit_metric": {
          "type": "string",
          "minLength": 1,
          "description": "The activity name and specific unit metric rate used for parametric calculation (e.g., hours per unit)."
        },
        "quantity_and_resource_factor": {
          "type": "string",
          "minLength": 1,
          "description": "Total quantity of work units and resource efficiency factor applied."
        },
        "parametric_duration_result": {
          "type": "string",
          "minLength": 1,
          "description": "Calculated duration derived from the mathematical parametric formula."
        }
      },
      "required": [
        "parametric_activity_and_unit_metric",
        "quantity_and_resource_factor",
        "parametric_duration_result"
      ]
    },
    "analogous_estimates": {
      "type": "object",
      "properties": {
        "historical_reference_activity": {
          "type": "string",
          "minLength": 1,
          "description": "Past project activity used as a baseline benchmark for historical comparison."
        },
        "historical_duration_and_complexity_scaling": {
          "type": "string",
          "minLength": 1,
          "description": "Duration of past activity and scaling factor applied for project scope differences."
        },
        "analogous_duration_result": {
          "type": "string",
          "minLength": 1,
          "description": "Final duration outcome determined through analogous comparison."
        }
      },
      "required": [
        "historical_reference_activity",
        "historical_duration_and_complexity_scaling",
        "analogous_duration_result"
      ]
    },
    "three_point_estimates_beta_distribution": {
      "type": "object",
      "properties": {
        "optimistic_most_likely_and_pessimistic_durations": {
          "type": "string",
          "minLength": 1,
          "description": "The recorded optimistic (tO), most likely (tM), and pessimistic (tP) estimates."
        },
        "beta_calculated_expected_duration_te": {
          "type": "string",
          "minLength": 1,
          "description": "Calculated expected duration using the PERT beta distribution formula (tO + 4tM + tP) / 6."
        },
        "standard_deviation_and_variance": {
          "type": "string",
          "minLength": 1,
          "description": "Calculated standard deviation (tP - tO) / 6 assessing estimating risk and variance."
        }
      },
      "required": [
        "optimistic_most_likely_and_pessimistic_durations",
        "beta_calculated_expected_duration_te",
        "standard_deviation_and_variance"
      ]
    },
    "aggregated_schedule_reserves": {
      "type": "object",
      "properties": {
        "total_calculated_schedule_buffer": {
          "type": "string",
          "minLength": 1,
          "description": "Consolidated sum of duration contingency buffers across all estimated activities."
        },
        "worksheet_reconciliation_and_approval": {
          "type": "string",
          "minLength": 1,
          "description": "Formal review confirming no duplicate activity estimations across methods."
        }
      },
      "required": [
        "total_calculated_schedule_buffer",
        "worksheet_reconciliation_and_approval"
      ]
    }
  },
  "required": [
    "artifact_id",
    "metadata",
    "parametric_estimates",
    "analogous_estimates",
    "three_point_estimates_beta_distribution",
    "aggregated_schedule_reserves"
  ]
}
๐Ÿ“‹ Form Field Definitions Dictionary (Legacy Specification)
{
  "form_name": "DURATION ESTIMATING WORKSHEET",
  "document_reference": "PMO-04.03.07",
  "_llm_instructions": "Populate the fields of 'DURATION ESTIMATING WORKSHEET' and write the value of each field under 'Generated Value', based on the project context. Context: the project carrying reference PMO-04.03.07.",
  "project_title": "",
  "date_prepared": "",
  "fields": {
    "f01_Parametric_Activity_and_Unit_Metric": {
      "section": "Parametric Estimates",
      "label": "Parametric Activity and Unit Metric",
      "guidance": "The activity name and specific unit metric rate used for parametric calculation (e.g., hours per unit).",
      "value": ""
    },
    "f02_Quantity_and_Resource_Factor": {
      "section": "Parametric Estimates",
      "label": "Quantity and Resource Factor",
      "guidance": "Total quantity of work units and resource efficiency factor applied.",
      "value": ""
    },
    "f03_Parametric_Duration_Result": {
      "section": "Parametric Estimates",
      "label": "Parametric Duration Result",
      "guidance": "Calculated duration derived from the mathematical parametric formula.",
      "value": ""
    },
    "f04_Historical_Reference_Activity": {
      "section": "Analogous Estimates",
      "label": "Historical Reference Activity",
      "guidance": "Past project activity used as a baseline benchmark for historical comparison.",
      "value": ""
    },
    "f05_Historical_Duration_and_Complexity_Scaling": {
      "section": "Analogous Estimates",
      "label": "Historical Duration and Complexity Scaling",
      "guidance": "Duration of past activity and scaling factor applied for project scope differences.",
      "value": ""
    },
    "f06_Analogous_Duration_Result": {
      "section": "Analogous Estimates",
      "label": "Analogous Duration Result",
      "guidance": "Final duration outcome determined through analogous comparison.",
      "value": ""
    },
    "f07_Optimistic_Most_Likely_and_Pessimistic_Durations": {
      "section": "Three-Point Estimates (Beta Distribution)",
      "label": "Optimistic, Most Likely, and Pessimistic Durations",
      "guidance": "The recorded optimistic (tO), most likely (tM), and pessimistic (tP) estimates.",
      "value": ""
    },
    "f08_Beta_Calculated_Expected_Duration_tE": {
      "section": "Three-Point Estimates (Beta Distribution)",
      "label": "Beta Calculated Expected Duration (tE)",
      "guidance": "Calculated expected duration using the PERT beta distribution formula (tO + 4tM + tP) / 6.",
      "value": ""
    },
    "f09_Standard_Deviation_and_Variance": {
      "section": "Three-Point Estimates (Beta Distribution)",
      "label": "Standard Deviation and Variance",
      "guidance": "Calculated standard deviation (tP - tO) / 6 assessing estimating risk and variance.",
      "value": ""
    },
    "f10_Total_Calculated_Schedule_Buffer": {
      "section": "Aggregated Schedule Reserves",
      "label": "Total Calculated Schedule Buffer",
      "guidance": "Consolidated sum of duration contingency buffers across all estimated activities.",
      "value": ""
    },
    "f11_Worksheet_Reconciliation_and_Approval": {
      "section": "Aggregated Schedule Reserves",
      "label": "Worksheet Reconciliation and Approval",
      "guidance": "Formal review confirming no duplicate activity estimations across methods.",
      "value": ""
    }
  }
}