Free Newsletter Template - Excel

Document Sample
Free Newsletter Template - Excel Powered By Docstoc
					 Gantt Box Chart - Template                                              FREE Newsletter




                                                 Our Project Plan
                                               Shown as a Gantt Box Chart
                    31-May        14-Jun      28-Jun      12-Jul       26-Jul       9-Aug

       Project Kickoff

 Gather Requirements

     Design Module 1

     Design Module 2

             Develop

                 Test

          Implement




Task                         Start         Best Case   Realistic     Worst Case       Start2
Project Kickoff              1-Jun-10      5-Jun-10    9-Jun-10      14-Jun-10          4
Gather Requirements          6-Jun-10      13-Jun-10   18-Jun-10     23-Jun-10          7
Design Module 1              11-Jun-10     17-Jun-10   20-Jun-10     27-Jun-10          6
Design Module 2              11-Jun-10     16-Jun-10   19-Jun-10     26-Jun-10          5
Develop                      20-Jun-10     29-Jun-10   15-Jul-10     22-Jul-10          9
Test                         21-Jul-10     27-Jul-10   29-Jul-10     5-Aug-10           6
Implement                    8-Aug-10      14-Aug-10   16-Aug-10     23-Aug-10          6
    Chandoo.org



                      How to use this?

                      1) Set up your project plan using the table
                      in row 6
 23-Aug       6-Sep
                      2) Just enter first 5 columns of dates
                      3) Last 3 columns are calculated. Do not
                      mess with them.
                      4) If you have Excel 2007 or above, the
                      calculated columns should automatically
                      update when you add new rows to the
                      table.
                      6) The chart now shows the project plan as
                      a Gantt Box Chart
                      7) Adjust horizontal / date axis scaling and
                      major units to see dates clearly.

                      For more info. visit:
Realistic3   Worst
    4         5       http://chandoo.org/wp/2010/07/09/gantt
    5         5       -box-chart-proposal/
    3         7       http://chandoo.org/wp/2010/07/12/gantt
    3         7       -box-chart/
   16         7
    2         7
    2         7

				
DOCUMENT INFO
Description: Free Newsletter Template document sample