
Create Gantt Chart and Cash Flow using Excel (Free Excel Template)
How to create a Time Schedule, Gantt chart, Bar chart, and Cash Flow using the attached Excel.
This Microsoft Excel sheet is fully automated and it will create the cash flow and draw the Gantt chart for you.
What is a Gantt Chart?
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 the current schedule status using percent-complete shadings and a vertical “TODAY” line.
How is my Microsoft Gantt chart working:
1- The sheet is based on working days, the first step is to identify the holidays and weekends.
2- Fill in the budget cost, planned start, planned finish, the activity duration (working days), planned value, and the planned % as of data date will be calculated automatically based on step no.1.
3- Fill in the actual date and the actual % completed and all other values will be filled automatically.
4- Cash flow will be created automatically.
Download the Excel Template
This is the view of the sheet.
What is the component of the sheet?
1. Bar Chart
Add the activity name, budgeted cost, planned start, and planned finish in the Excel sheet for the not started activities then all these columns will be calculated automatically
2. Data sheet
In the holidays columns put the year holidays and choose the weekend holidays.
There are a variety of holidays on the list.
3. Cash Flow
This cash flow is automatically generated from the budgeted cost inserted and it is distributed on the duration in weeks.
How does it work?
- Add new activity, put 1M as a budget cost, and the planned start.
- Once you add the planned finish, all these data are calculated.
The bar chart shows the activities in the timeline.
- Give the activity the actual 10% and observe what is the difference.
The bar chart shows the actual % of work and the remaining work. It also shows that the remaining work is delayed because it exceeds the planned dates.
This is the legend of the chart, once you change the data date the chart will be changed.
Download the PDF version of this Article to share with your colleagues
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