Primavera Calculation in Excel - Planned Value Cost & Earned Value Cost 💰

A simulated Primavera calculation aimed to create ‘Planned Value Cost’ and ‘Earned Value Cost’ Spreadsheets using a single formula covers more than 274,000 cells in Excel, utilizing a mixed reference technique that combines relative and absolute references in Excel.

Here’s how it works:
Whenever the spreadsheet field equals ‘Planned Value’, the formula will distribute the value of ‘Planned Value’ linearly between the ‘Planned Start Date’ and ‘Planned Finish Date’. This is based on the assumption that the ‘Planned Value’ will be distributed equally across the days, known as ‘Linear Distribution’.

Whenever the spreadsheet field equals ‘Earned Value’, the ‘Earned Value Cost’—multiplied by the percentage complete of the activity—will be distributed between the ‘Data Date’ and ‘Actual Start’. It is assumed that the remaining value will be distributed between the ‘Forecasted Date’ and ‘Data Date’."

Curious about the latest advancements in AEC? 🏗️

Learn more: https://masteryofdigital.com/