I can see this is the most hot topic and tags for ‘S-Curve in Excel’ is the highest!! Therefore, I’ll give priority for this topic and here it goes!
Step 1: Get Bill of Quantities (BQ) from Quantity Surveyor (QS) & tabulate as follow:
Step 2: With the input from your approved schedule, tabulate the cost into Month i.e. Preliminaries Works $709, 196.57 divide with 14 months = $50,656.90/month. Please remember this is linear tabulation & the accuracy is between 70%-80%. To get more accurate, breakdown Preliminaries activity into more detail instead of single line.
Step 3: Insert 2D or 3D lines and Select Data from Cummulative Amount.
Step 4: You can generate your Planned Value (PV) S-Curve now! Please remember to key in another 2 lines which is Actual Cost (AC) & Earned Value (EV) to measure your Cost Performance Index (CPI) & Schedule Performance Index (SPI). Good luck!