Docstoc

Gantt Chart Template for Excel

Document Sample
Gantt Chart Template for Excel Powered By Docstoc
					  click here to buy premium edition at
              excelindo.com
        SETTING
  Start Date           :
                               2-Jan-12
                                                       PROJECT NAME                          New Product Package
  End Date             :                              DESCRIPTION                            The best




                                                                                                                                                                                             #######




                                                                                                                                                                                                                                     #######




                                                                                                                                                                                                                                                                             #######




                                                                                                                                                                                                                                                                                                                  #######




                                                                                                                                                                                                                                                                                                                                                          #######




                                                                                                                                                                                                                                                                                                                                                                                               #######




                                                                                                                                                                                                                                                                                                                                                                                                                                       #######




                                                                                                                                                                                                                                                                                                                                                                                                                                                                            #######




                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    #######




                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         #######
     End Date                  1-Feb-12                                                      Way
     Week Period                          20          LEADER                                 Bruce Jenner
  Working Days         :   R Monday
                           R Tuesday                      u      Start Date                    Mon, Jan 02, 2012           End Date :       Wed, Feb 01, 2012
                           R Wednesday                    u      Project Length                     5 Week
                           R Thursday                     u      Week Period (52 Week)             W1 - W5
                           R Friday                                                             1/2/12 - 2/5/12
                                                                    Saturday                                                                                                                  2        30                                                                     1         2         3        4  5
                                                                                                                                                                                                                           W1                                                                              W2                                                                           W3                                                                           W4                                                                           W5
                                                                    Sunday




                                                                                                                                                                              Remaining WD
                                                                                                                                                                  Work Days
  Today's Date         :                                 Level                       Task         Assignment               Start Date           Finish Date




                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        -Feb-12

                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  -Feb-12

                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   -Feb-12

                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             -Feb-12

                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       -Feb-12
                                                                                                                                                                                             -Jan-12

                                                                                                                                                                                                       -Jan-12

                                                                                                                                                                                                                 -Jan-12

                                                                                                                                                                                                                           -Jan-12

                                                                                                                                                                                                                                               -Jan-12

                                                                                                                                                                                                                                                         -Jan-12

                                                                                                                                                                                                                                                                   -Jan-12

                                                                                                                                                                                                                                                                             -Jan-12

                                                                                                                                                                                                                                                                                       -Jan-12

                                                                                                                                                                                                                                                                                                 -Jan-12

                                                                                                                                                                                                                                                                                                           -Jan-12

                                                                                                                                                                                                                                                                                                                            -Jan-12

                                                                                                                                                                                                                                                                                                                                      -Jan-12

                                                                                                                                                                                                                                                                                                                                                -Jan-12

                                                                                                                                                                                                                                                                                                                                                          -Jan-12

                                                                                                                                                                                                                                                                                                                                                                    -Jan-12

                                                                                                                                                                                                                                                                                                                                                                              -Jan-12

                                                                                                                                                                                                                                                                                                                                                                                        -Jan-12

                                                                                                                                                                                                                                                                                                                                                                                                         -Jan-12

                                                                                                                                                                                                                                                                                                                                                                                                                   -Jan-12

                                                                                                                                                                                                                                                                                                                                                                                                                             -Jan-12

                                                                                                                                                                                                                                                                                                                                                                                                                                       -Jan-12

                                                                                                                                                                                                                                                                                                                                                                                                                                                 -Jan-12

                                                                                                                                                                                                                                                                                                                                                                                                                                                           -Jan-12

                                                                                                                                                                                                                                                                                                                                                                                                                                                                     -Jan-12

                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      -Jan-12

                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                -Jan-12

                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          -Jan-12

                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    -Jan-12

                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              -Jan-12
                               24-Feb-12       Actual
                               7-Dec-11        User Defined
                                                            0




                                                                                                                                                                                             2

                                                                                                                                                                                                       3

                                                                                                                                                                                                                 4

                                                                                                                                                                                                                           5

                                                                                                                                                                                                                                               6

                                                                                                                                                                                                                                                         7

                                                                                                                                                                                                                                                                   8

                                                                                                                                                                                                                                                                             9




                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        1

                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  2

                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   3

                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             4

                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       5
                                                                                                                                                                                                                                                                                       #

                                                                                                                                                                                                                                                                                                 #

                                                                                                                                                                                                                                                                                                           #

                                                                                                                                                                                                                                                                                                                            #

                                                                                                                                                                                                                                                                                                                                      #

                                                                                                                                                                                                                                                                                                                                                #

                                                                                                                                                                                                                                                                                                                                                          #

                                                                                                                                                                                                                                                                                                                                                                    #

                                                                                                                                                                                                                                                                                                                                                                              #

                                                                                                                                                                                                                                                                                                                                                                                        #

                                                                                                                                                                                                                                                                                                                                                                                                         #

                                                                                                                                                                                                                                                                                                                                                                                                                   #

                                                                                                                                                                                                                                                                                                                                                                                                                             #

                                                                                                                                                                                                                                                                                                                                                                                                                                       #

                                                                                                                                                                                                                                                                                                                                                                                                                                                 #

                                                                                                                                                                                                                                                                                                                                                                                                                                                           #

                                                                                                                                                                                                                                                                                                                                                                                                                                                                     #

                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      #

                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                #

                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          #

                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    #

                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              #
  Level Type           : 1; 1.1; 1.1.1; ..             ####### Product Package Preparation                              Jenner
                                                                                                                   BruceMon, Jan 02, 2012     Fri, Jan 20, 2012      13
    DAYS MARKER                                        ####### Define Brand Name                                          Jenner
                                                                                                                   BruceMon, Jan 02, 2012   Wed, Jan 04, 2012          3
                       Today
                       : Yes                           ####### Box Cover Design                                           Thu,
                                                                                                                   Lisa Girl Jan 05, 2012   Mon, Jan 09, 2012          3
                       Holiday
                       : Yes                           ####### User Guide Cover Design                                    Thu,
                                                                                                                   Lisa Girl Jan 05, 2012   Mon, Jan 09, 2012          3
                       : No
                       Leave                           ####### Warranty Card Design                                       Thu,
                                                                                                                   Lisa Girl Jan 05, 2012   Mon, Jan 09, 2012          3
                       : No
                       Start/End                       ####### Production                                                 Tue,
                                                                                                                   Lois Lang Jan 10, 2012    Fri, Jan 20, 2012         7
                       : Yes
                       Passing Days                    ####### Marketing Kit                                             Tue, Jan
                                                                                                                   John Wayne 10, 2012      Mon, Jan 23, 2012          9
       DISPLAY                                         ####### Brochures                                                 Tue, Jan
                                                                                                                   John Wayne 10, 2012       Thu, Jan 12, 2012         3
                       Window
                       : 52 Week                       ####### Banners                                                    Tue, Jan
                                                                                                                   John Harper 10, 2012      Thu, Jan 12, 2012        3
                       Slider
                       : Weekly                        ####### Production                                                  Fri,
                                                                                                                   Lois Lang Jan 13, 2012   Mon, Jan 23, 2012         6
        ALERT                                          ####### Event                                                      Parker
                                                                                                                   SarahMon, Jan 02, 2012   Wed, Feb 01, 2012        22
                       Remaining Days
                       : ##############                ####### Define Location                                           Parker
                                                                                                                   SarahMon, Jan 02, 2012   Wed, Jan 04, 2012          3
                                                       ####### Book Location                                             Thu, Jan
                                                                                                                   Sarah Parker 05, 2012    Thu, Jan 05, 2012          1
                                                       ####### Press Conference                                         Kent
                                                                                                                   PeterWed, Feb 01, 2012   Wed, Feb 01, 2012          1
© 2012 excelindo.com
more free templates at exceltemplate.net
Date                           Holiday
    Sunday, January 01, 2012   New Year’s Day
    Monday, January 16, 2012   Martin Luther King, Jr. Day
   Monday, February 20, 2012   Presidents’ Day
      Monday, May 28, 2012     Memorial Day
    Wednesday, July 04, 2012   Independence Day
 Monday, September 03, 2012    Labor Day
   Monday, October 08, 2012    Columbus Day
  Sunday, November 11, 2012    Veterans Day
 Tuesday, November 22, 2011    Thanksgiving Day
 Tuesday, December 25, 2012    Christmas Day
          Excelindo Gantt Chart Premium Edition - Single User License          US$ 17.99
 PRICE                                                                                           click here to buy
          Excelindo Gantt Chart Premium Edition - Multi User License           US$ 34.99

EXCELINDO GANTT CHART PREMIUM EDITION FEATURES

Flexible Work Days
Some projects required different holidays instead of normal Saturday or Sunday. Using this flexible work days fea
days within one week.

Custom Holiday and Leave Dates
These features will allow users to add their company holidays and their personal leaves into the chart and being i
which will make the plan more precise.

Smart Workdays Calculation
Based on flexible workdays and custom holidays, the formula inside Workday column will calculate precisely user

Chart Marker
These are features that will colorize your chart based on your personal setting. There are five date markers
u Today: To mark today's date on gantt chart (blue border color surrounding the area below corresponding date)
u Holiday: To mark holiday's date on gantt chart (Red color for non working dates within a week, orange color for
u Leave: To mark employee leave's date on gantt chart (Dark violet solid color on corresponding leave dates).
u Start/End: To mark the beginning and the end of one task period (Black solid color in the beginning or end of an
u Passing Days: To view the progress and mark the number of days that has been passed from the beginning of an
color on corresponding dates).

Flexible Project Display Period with Scrolling Function
You can select project plan frame preference to be displayed and printed in Excel, and you can visually scroll the

Task and Remaining Days Alert
With this feature, any project managers can be reminded on how many parallel tasks in the same day that can be
many days left to complete their projects.
        click here to buy premium edition at excelindo.com




his flexible work days feature, users can select their own work



nto the chart and being included in total workday calculation



l calculate precisely users workdays.


 five date markers
low corresponding date).
 a week, orange color for national/company holidays).
ponding leave dates).
he beginning or end of any task period).
 from the beginning of any tasks until today's date (Blue solid



ou can visually scroll the plan weekly or daily.


he same day that can be carry on by his/her teams and on how

				
DOCUMENT INFO
Shared By:
Stats:
views:160
posted:2/24/2012
language:English
pages:5
Description: Gantt Chart template for excel is an easy to use Gantt Chart with excel as its platform. It will help you creating a professional Gantt Chart with several built-in features that you can use it directly. It doesn't need any advance skills in excel. It is created without Macro and requires Microsoft Excel 2007 or higher.