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