It consist two sheets first one uses conditional formatting and formulas while other is simpler. Project planning and monitoring can be done by this time line spreadsheet. Click to download and test
This is an example spreadsheet for project reporting if you are not sure what you should put in the data fields and what to delete i think it is better to refer to the example given in the spreadsheet. Edit and make suitable changes and build your own. Add tasks which you think that are important.
Gantt chart is a visual aid helping you to figure out the estimated progress of your project and the work distribution. This Team Project Draft Schedule spreadsheet will help you to focus on planning.Simple formulas are used to avoid complexities.