• Home
  • Blog
  • Courses
  • Tools
  • Jobs
  • Forums
Have any question?
(00) 201277767728
[email protected]
RegisterLogin

Login with your site account

Lost your password?

Not a member yet? Register now

Register a new account

Are you a member? Login now

Planning Engineer Est.
  • Home
  • Blog
  • Courses
  • Tools
  • Jobs
  • Forums
      • Cart

        0

    Excel in Planning

    • Home
    • Blog
    • Excel in Planning
    • Create Gantt Chart and cash flow using excel with sample file

    Create Gantt Chart and cash flow using excel with sample file

    • Posted by Hany Ismail, MSC, PMP
    • Categories Excel in Planning
    • Date November 23, 2012
    • Comments 34 comments

    How to create a time schedule, Gantt chart, Bar chart and cash flow using the attached excel sheet.

    This Microsoft Excel sheet is fully automated and it will create the cash flow and draw the gantt chart for you. (see the video below for more information)


     

    What is Gantt chart:

    Reference to Wikipedia A Gantt chart is a type of bar chart, developed by Henry Gantt in the 1910s, that illustrates a project schedule. Gantt charts illustrate the start and finish dates of the terminal elements and summary elements of a project. Terminal elements and summary elements comprise the work breakdown structure of the project. Some  charts also show the dependency (i.e. precedence network) relationships between activities. Gantt charts can be used to show current schedule status using percent-complete shadings and a vertical “TODAY” line as shown here.


    How is my Microsoft Gantt Chart working :

    1- The sheet is based on working days, First step is to identify the holidays and week ends


    2- Fill the budget cost, planned start and planned finish , the activity duration (working days), planned value, planned % as of data date will be calculated automatically based on step no. 1

    (see the video below for more information)

    bar chart
    bar chart

     

    3- fill the actual date and the actual % completed and all other values will be filled automatically.
    (see the video below for more information)


    4- Cash flow will be created automatically

    (see the video below for more information)

     


    See the video to see how this excel sheet is working  :

     


    I received a valuable comment in Arabic from Mr. Ahmed Ammar regarding activity 2, Actual % greater than the planned % and the forecast completion date greater than the planned completion date, i reviewd my formulas and i found a mistake, Therefore please download the Version 1 of the excel sheet below:


    Download Gantt Chart sample

    Create-Gantt-Chart-and-cash-flow R.1

    ——————————————————————————————————————————–

    Tag:Activity Duration, actual date, budget cost, cash, Cash Flow, chart, Create, excel, excel gantt chart, file, flow, gantt, gantt charts, henry gantt, holidays, planned %, planned finish, planned start, planned value, sample, week end, working days

    • Share:
    Hany Ismail, MSC, PMP
    Hany Ismail, MSC, PMP

    Hany Ismael is the founder and CEO of Planning Engineer Est. in Egypt. He has started his career back in 2003 as a site engineer, technical office engineer, planning engineer, planning manager, and finally planning department manager where he has been involved in several mega construction projects in Egypt and Saudi Arabia. In 2016, he established his own company in Egypt “Planning Engineer Est.” Hany gained his MSc degree in project management from Liverpool University-UK 2013-2016, PMP certified from PMI-USA 2010, and BSc Civil Engineer Tanta University-Egypt 2003. Hany provided more than 3,500 hours of planning and project management training on his website planningengineer.net, YouTube channel, and offline courses since 2011. He enjoys teaching project management in simple and practical way, and he developed several planning tools, techniques and courses.

    Previous post

    Video How to calculate working days using excel with sample
    November 23, 2012

    Next post

    Top 10 steps you should do to be a successful planning engineer
    November 24, 2012

    You may also like

    Materials Procurement Scheduling in a Baseline Programme
    Materials Procurement Scheduling in a Baseline Programme
    7 May, 2022
    Planned VS Actual Excel Sheet
    Mini Schedule Planned VS Actual Excel Sheet
    18 August, 2021
    3 weeks look ahead schedule
    3 weeks look ahead schedule excel sheet
    24 July, 2021

      34 Comments

    1. blank
      Harith M. AL-Jammas
      November 23, 2012
      Log in to Reply

      very important file.

    2. blank
      Mostafa Elkadi
      November 23, 2012
      Log in to Reply

      good work

      • blank
        Ahmed Gamal
        December 27, 2012
        Log in to Reply

        😀

    3. blank
      eng-hassan80
      November 24, 2012
      Log in to Reply

      You now
      I make your website as my default home page
      God bless you

    4. blank
      Ayman Alhaggar Abo Salma
      November 24, 2012
      Log in to Reply

      رائع يا باشمهندس جزاك الله خيرا.

      • blank
        Planning Engineer
        November 29, 2012
        Log in to Reply

        Thanks alot

    5. blank
      Mohamed Sweek
      November 25, 2012
      Log in to Reply

      very good

    6. blank
      Khalid Adnan Kuba
      November 26, 2012
      Log in to Reply

      amazing

    7. blank
      Ahmed Ammar
      November 27, 2012
      Log in to Reply

      مجهود رائع و لكن ازاى فى activity 2 المعدل الفعلى AV=20% أكبر من المعدل المخطط PV =16.1% و ]كون متأخر يوم ، و كذلك فى activity1 نفذ 50% فى 46 يوم و باقى 50% مطلوب ينفذها فى 17 يوم فقط ، برجاء التوضيح يا أستاذنا.

      • blank
        Planning Engineer
        November 29, 2012
        Log in to Reply

        أولا شكرا جزيلا على سؤالك. وفعلا كان فيه خطأ فى معادلة حساب تاريخ النهايه و تم تصحيحها رجاء تحميل الملف R.01

        بالنسبه ل activity1 المعادله المستخدمه المده المتبقيه = نسبة الانجاز فى المده الاصليه للبند ….. ياريت لو عندك ملاحظات تانيه تقولهالنا وانا هترجم الكومنت بتاعت حضرتك وردى عليها فى الموضوع علشان الى مش بيعرف عربى و شكرا جزيلا لك

      • blank
        Planning Engineer
        November 29, 2012
        Log in to Reply

        I received a valuable comment in Arabic from Mr. Ahmed Ammar regarding activity 2, Actual % greater than the planned % and the forecast completion date greater than the planned completion date, i reviewd my formulas and i found a mistake, Therefore please download the Version 1 of the excel sheet

    8. Hany Ismail, MSC, PMP
      admin
      November 29, 2012
      Log in to Reply

      Thanks a lot Engineer Hassan

    9. blank
      Mina Ayad
      January 25, 2013
      Log in to Reply

      شكرا جزيلا على المعلومات وعلى مجهودك العظيم بس عندي كم اسؤال رجاء المساعده التاب الاول والي هو البار جارت ماهي المعادلات الي تربط الاعمده ببعضها بمعنى اخر عندما تغير او تضيف قيمه الى اي خانه الخانات الاخرى تتغير تلقائيا وهذا بسبب معادلات تربط الخانات ببعضها ماهي والسؤال الثاني هو كيق الكاش فلو ظهر الكاش فلو لايمكن ان يرسم تلقائيا الا اذا كان هناك ربط بين البار جارت والكاش فلو لانه كلما غيرت بالبيانات في بارجارت الكاش فلو سوف يتغير سؤالي كيف تم الربط بين بارحارت تاب والكاش فلو تاب الرجاء توضيح الطريقه ولك الشكر على معلوماتك القيمه.

    10. blank
      Musa Ibrahim Al Hamdi
      June 30, 2013
      Log in to Reply

      الظاهر لدي انه الجدول لفترة زمنية محددة..كيف يمكن زيادة عدد الاسابيع؟؟.

    11. blank
      Osmanahmed
      November 19, 2013
      Log in to Reply

      Excellent Job Hany,
      Please keep up the updates,
      I created a similar sheet for progress tracking back in 2007, but I was working with International Contracors who did not get convinced by it.
      However, your template is very useful to link Progress with Cost for Managerial Level Reporting.
      I can imagine that If I want to report Packages Performance it would be great to represent the delays and Progress vs. Earned Value.
      Ma Shaa’ Allah.

    12. blank
      anas
      May 12, 2014
      Log in to Reply

      hi thanks alot for your job but how i can download this file and use it i need it too much

    13. blank
      anas
      May 14, 2014
      Log in to Reply

      thanks allot for your job

    14. blank
      AHMED
      May 26, 2014
      Log in to Reply

      GOOD

    15. blank
      hazemamr
      May 29, 2014
      Log in to Reply

      thanks

    16. blank
      ahmed noufal
      June 3, 2014
      Log in to Reply

      please sir
      i would like to see this excel sheet
      thank you

    17. blank
      ashraf2006
      June 5, 2014
      Log in to Reply

      thankyou

    18. blank
      ashraf2006
      June 5, 2014
      Log in to Reply

      thaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaankyou

    19. blank
      Mohamed Ezzat
      September 1, 2014
      Log in to Reply

      شكرا جزيلا

    20. blank
      haj89
      September 9, 2014
      Log in to Reply

      nice

    21. blank
      paul
      September 29, 2014
      Log in to Reply

      You are a true Professional! I am looking forward to getting more knowledge from your posts. Thanks

    22. blank
      abioye busayo
      November 3, 2014
      Log in to Reply

      how can I access this file please?

      • Hany Ismail, MSC, PMP
        Hany Ismael
        November 20, 2014
        Log in to Reply

        You need to be a Premium User. Join us https://planningengineer.net/join-us/

    23. blank
      eng.a1
      December 18, 2014
      Log in to Reply

      thank u

    24. blank
      Jawwad
      May 15, 2015
      Log in to Reply

      good work

    25. blank
      ibrahem
      May 29, 2015
      Log in to Reply

      thank you

    26. blank
      mahmoudateya
      July 27, 2015
      Log in to Reply

      thanks

    27. blank
      Thida Kong
      July 11, 2018
      Log in to Reply

      Great full . Thanks you for sharing .
      I’m try to looking for this chart and make a cash flow projection.

    28. blank
      Mushtaque Ali
      June 14, 2019
      Log in to Reply

      Comment *Thanks for sharing the valuable documents.

    29. blank
      Abdulqadir
      February 11, 2021
      Log in to Reply

      SIR I have no words how pay thanks to you?but this the absolutely unparalleled .may you many more successes in this world as well as hereafter

    Leave A Reply Cancel reply

    You must be logged in to post a comment.

    Cart

    0

    Planning Courses

    Cost Control for Construction Projects

    Cost Control for Construction Projects

    $299.00
    Power Bi Monitoring and Controlling with P6

    Power Bi Monitoring and Controlling with P6

    $299.00
    Advanced Planning 3 Courses Package

    Advanced Planning 3 Courses Package

    $499.00
    Data Management and Reporting

    Data Management and Reporting

    $199.00
    Primavera Online Basic Course -Arabic

    Primavera Online Basic Course -Arabic

    $99.00
    Professional Planning Engineer (PPE)

    Professional Planning Engineer (PPE)

    $335.00
    Claims Management and (EOT)

    Claims Management and (EOT)

    $175.00
    Primavera Online Basic Course -English

    Primavera Online Basic Course -English

    $99.00

    Follow Us:

    About Us | Contact Us | Terms of Service | Privacy Policy | Refund Policy

    Copyright ©2012- 2018 planningengineer.net | All materials, unless otherwise noted, were developed originally for Planning Engineer Website. In the event that there is still a problem or error with copyrighted material, the break of the copyright is unintentional and noncommercial and the material will be removed immediately upon presented proof.

    • Planning Courses
    • Planning Jobs
    • Planning Blog
    Posting....