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.mdfor 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... ]
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 |
| --- |
Generated on: 2026-03-15 10:00 UTC, by Tasleemat
Draft 2020-12 JSON Schema
{
"$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": ""
}
}
}