Issue : S-Curve in Excel

Posted on May 27, 2009 by farestplanner

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:

01

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.

02 (resize)

Step 3: Insert 2D or 3D lines and Select Data from Cummulative Amount.

03 (resize)

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!

04 (resize)

Filed under: Scheduling & Planning | Tagged: , |

« »

59 Responses

  1. Pravin Nerkar, on June 16, 2009 at 2:46 pm said:

    Learn to draw S-curve on Crtitical path duration of Power Boiler project

    Reply
  2. Sreekanth, on August 3, 2009 at 4:48 pm said:

    hey i want to know how to draw an s-curve for the projects
    and also the importance and other stuff related to S-Curves..
    can anyone mail such a material to sreekanth.civil@yahoo.co.in
    pleasee

    Reply
  3. adrianne, on January 1, 2010 at 3:04 pm said:

    i recently designed an ms program that parses automatically data from primavera 6 SDK and generate s-curve in excel. if interested kindly send me an email. this works in office 2007.

    Reply
  4. Kav, on January 6, 2010 at 10:06 pm said:

    very interesting… Can You please, give me some information of how can I find the area of a constructio Site using Excel…

    Thanks

    Reply
  5. Paul Horsford, on March 1, 2010 at 3:34 pm said:

    Hi Adrianne, will you please e-mail me the detail?
    Regards, Paul. horsie@yahoo.com

    Reply
  6. Fitri, on June 10, 2010 at 3:23 pm said:

    Dear Friend,

    Please provide me with the required to draw the S- curve in P5.
    I will be very thankful.
    Email :fitri_m48@yahoo.co.id

    Thanks

    Reply
  7. Awang, on August 29, 2010 at 10:07 am said:

    other than using cost to gauge the s curve. is it possible to use amount of rebar/concrete to gauge the planned/actual progress of the s curve? if u hv an example for me to review, pls email me at exuberant_life@yahoo.com.
    thanks in advance.

    Reply
  8. mathew john, on September 23, 2010 at 4:02 pm said:

    hey guys any of you help me by sending a soft copy of s-curve in excel pls

    Reply
  9. catherine, on September 28, 2010 at 12:56 am said:

    i wish to get the spreadsheet for my projects calculation .. i think this is wat my lecturer wan, do u mind mail me?

    Reply
  10. sahir, on October 27, 2010 at 8:33 pm said:

    Hi need steps to Draw S curve for a construction Project

    Reply
  11. MOS, on November 3, 2010 at 12:06 pm said:

    kindly send me as well the s curve by email. Thank you, very appreciated

    Wish you happy

    Reply
  12. jonathan lope, on January 19, 2011 at 11:33 am said:

    can you send me soft copy of this sample i need it asap
    i appreciate it very much thank you

    Reply
  13. Eli Caruci, on March 8, 2011 at 9:40 pm said:

    can you send me soft copy of this sample i need it asap
    i appreciate it very much thank you very much

    Reply
    • farestplanner, on March 9, 2011 at 4:14 pm said:

      Hi Eli,
      I’m sorry to say that I can’t do that. Work ethic, I need to protect the information for my client interest even though the project is completed. You can use the guidance given and try to spend your time to build the table & s-curve in MS excel. Trust me, by doing this you will know better.

      Reply
  14. HAK, on April 14, 2011 at 10:38 am said:

    Nice discussion

    Reply
  15. shaik mohammed, on May 25, 2011 at 6:21 pm said:

    Mr.adrianne

    Can you please send me details about S-Curve.

    Reply
  16. HAK, on May 26, 2011 at 1:06 pm said:

    Hi

    I’m new with the primavera 6. How to create the manhour S-curve in percentage by using the P^6

    Regards

    Reply
    • farestplanner, on May 31, 2011 at 1:58 pm said:

      HAK,

      Do you mean to create Schedule % Complete based on man/hour unit but without the labor cost/expenses/material cost?
      If yes, that is not possible. As default, Schedule % Complete always refer to cost as the basis for the calculation. The cost may comprise:

      1) Expenses only
      2) Man/hour i.e. Total Labor Cost
      3) Material cost
      4) All the above

      Hope this will explain. Have a good day!

      Reply
      • Hak, on May 31, 2011 at 2:08 pm said:

        Can i have u email address. I will email u the template that i need to do.

        hak

  17. flanery, on June 15, 2011 at 2:27 pm said:

    could someone please send me a sample of s curve diagram in excel.

    my email add : hepticfla@yahoo.com

    I appreciate

    Reply
  18. emeka, on July 5, 2011 at 2:04 am said:

    Hi Andrianne,

    Could you please send me the template for drawing up an Scurve in excel. thanks

    Reply
  19. Craig, on August 3, 2011 at 11:05 pm said:

    Please send me the Scurve template in excel. ccaldwell@mbkahn.com

    Thanks

    Reply
  20. Russell, on September 14, 2011 at 9:18 am said:

    Hi Andrianne, i would really appreciate it if you could forward me your s-curve template as demostrated above. i would also be happy to continue discussions with you in the future re any improvements that either of us could make to it. regards, russell
    ruste@hotmail.co.uk

    Reply
  21. Lee, on September 27, 2011 at 10:20 pm said:

    Hi Mr Adrian,

    Currently i working for the S-Curve with the excel files.
    Activity Vs. Manhours (M/H). Could i have the template. Thanks

    Reply
  22. zakiah, on October 1, 2011 at 8:55 am said:

    Hi there,
    appreciate if you could also forward me the S-Curve template in excel to my email address i.e. zakiahr@gmail.com
    Thank You.

    Reply
  23. faizal, on October 20, 2011 at 4:09 pm said:

    Hi Mr Adrian,

    Really appreciate if you can email to me too.. My email faizalj@sesb.com.my

    Thanks in advance..

    Faizal

    Reply
  24. jome, on December 11, 2011 at 11:02 am said:

    Thank you

    Reply
  25. NN Panchal, on January 25, 2012 at 3:13 pm said:

    I have MS project version 10 , i would like to prepred s curve based on
    % completed . Please help me.

    Reply
  26. fazal Rashid, on March 15, 2012 at 10:25 pm said:

    Dear Adraine

    I am new one to work on S curve excel sheet,kindly send me sample of excel sheet. engr.fazal.r@gmail.com

    Reply
  27. Dennis Sept, on April 2, 2012 at 9:41 pm said:

    Hi Andrianne,

    Could you also send me the template for drawing up an S-curve in excel.

    Thanks Dennis

    Reply
  28. Poornima, on April 18, 2012 at 5:14 pm said:

    Hi Andrianne,
    Could you also send me the template for drawing up an S-curve in excel.
    Thanks
    Poornima

    Reply
  29. jerry, on April 26, 2012 at 5:59 pm said:

    Hi!

    could you also send me the template for drawing s curved in exell.
    thanks..

    Reply
  30. zarni, on March 8, 2016 at 12:47 pm said:

    Dear Sir,

    I also like to get S-curve in excel template because I am beginner of project planning and I like to know how to construct the S-curve in excel. Please send me it with attached file. My mail address is civil.ptu;pyay@gmail.com. Thank for your knowledge sharing and I wish that you can share more than it.

    Zarni

    Reply

Leave a reply to Shahzaib Cancel reply