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)

Gantt Chart Bar Chart 1024x339 Create Gantt Chart and cash flow using excel with sample file

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)

Cash Flow Create Gantt Chart and cash flow using excel with sample file

 

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

———————————————————————————————————————————

share small Create Gantt Chart and cash flow using excel with sample file

Related Posts

This post is also available in: French, Arabic