Create Gantt Chart and cash flow using excel with sample file
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)

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
——————————————————————————————————————————–
Leave A Reply
You must be logged in to post a comment.
34 Comments
very important file.
good work
😀
You now
I make your website as my default home page
God bless you
رائع يا باشمهندس جزاك الله خيرا.
Thanks alot
very good
amazing
مجهود رائع و لكن ازاى فى activity 2 المعدل الفعلى AV=20% أكبر من المعدل المخطط PV =16.1% و ]كون متأخر يوم ، و كذلك فى activity1 نفذ 50% فى 46 يوم و باقى 50% مطلوب ينفذها فى 17 يوم فقط ، برجاء التوضيح يا أستاذنا.
أولا شكرا جزيلا على سؤالك. وفعلا كان فيه خطأ فى معادلة حساب تاريخ النهايه و تم تصحيحها رجاء تحميل الملف R.01
بالنسبه ل activity1 المعادله المستخدمه المده المتبقيه = نسبة الانجاز فى المده الاصليه للبند ….. ياريت لو عندك ملاحظات تانيه تقولهالنا وانا هترجم الكومنت بتاعت حضرتك وردى عليها فى الموضوع علشان الى مش بيعرف عربى و شكرا جزيلا لك
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
Thanks a lot Engineer Hassan
شكرا جزيلا على المعلومات وعلى مجهودك العظيم بس عندي كم اسؤال رجاء المساعده التاب الاول والي هو البار جارت ماهي المعادلات الي تربط الاعمده ببعضها بمعنى اخر عندما تغير او تضيف قيمه الى اي خانه الخانات الاخرى تتغير تلقائيا وهذا بسبب معادلات تربط الخانات ببعضها ماهي والسؤال الثاني هو كيق الكاش فلو ظهر الكاش فلو لايمكن ان يرسم تلقائيا الا اذا كان هناك ربط بين البار جارت والكاش فلو لانه كلما غيرت بالبيانات في بارجارت الكاش فلو سوف يتغير سؤالي كيف تم الربط بين بارحارت تاب والكاش فلو تاب الرجاء توضيح الطريقه ولك الشكر على معلوماتك القيمه.
الظاهر لدي انه الجدول لفترة زمنية محددة..كيف يمكن زيادة عدد الاسابيع؟؟.
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.
hi thanks alot for your job but how i can download this file and use it i need it too much
thanks allot for your job
GOOD
thanks
please sir
i would like to see this excel sheet
thank you
thankyou
thaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaankyou
شكرا جزيلا
nice
You are a true Professional! I am looking forward to getting more knowledge from your posts. Thanks
how can I access this file please?
You need to be a Premium User. Join us https://planningengineer.net/join-us/
thank u
good work
thank you
thanks
Great full . Thanks you for sharing .
I’m try to looking for this chart and make a cash flow projection.
Comment *Thanks for sharing the valuable documents.
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