Omedia Gantt Template

Document Sample
Omedia Gantt Template Powered By Docstoc
					                                                                Example Project Plan Template




           Special Events      Start      End
             Time off       11/10/2012 11/23/2012
              Holiday        9/25/2012 9/25/2012




                                                              8/12 Aug




                                                                    Sep




                                                              10/1 Oct




                                                              10/15




                                                              10/22




                                                              10/29
                                                              10/10
                                                              10/11
                                                              10/12
                                                              10/13
                                                              10/14

                                                              10/16
                                                              10/17
                                                              10/18
                                                              10/19
                                                              10/20
                                                              10/21

                                                              10/23
                                                              10/24
                                                              10/25
                                                              10/26
                                                              10/27
                                                              10/28
                                                              8/13




                                                              8/20




                                                              8/27




                                                              9/10




                                                              9/17




                                                              9/24




                                                              10/8
                                                              8/14
                                                              8/15
                                                              8/16
                                                              8/17
                                                              8/18
                                                              8/19

                                                              8/21
                                                              8/22
                                                              8/23
                                                              8/24
                                                              8/25
                                                              8/26

                                                              8/28
                                                              8/29
                                                              8/30
                                                              8/31




                                                              9/11
                                                              9/12
                                                              9/13
                                                              9/14
                                                              9/15
                                                              9/16

                                                              9/18
                                                              9/19
                                                              9/20
                                                              9/21
                                                              9/22
                                                              9/23

                                                              9/25
                                                              9/26
                                                              9/27
                                                              9/28
                                                              9/29
                                                              9/30

                                                              10/2
                                                              10/3
                                                              10/4
                                                              10/5
                                                              10/6
                                                              10/7

                                                              10/9
                                                              9/3
                                                              9/1
                                                              9/2

                                                              9/4
                                                              9/5
                                                              9/6
                                                              9/7
                                                              9/8
                                                              9/9
                               Start       End     % Compl.
Project Deliverable 1         9/1/2012   9/14/2012
  Task 1                      9/1/2012   9/14/2012     80%
  Task 2                      9/4/2012   9/11/2012     60%
  Task 3                     9/14/2012    3/5/2010     10%

Project Deliverable 2        9/16/2012   10/6/2012
  Task 1                     9/16/2012   10/6/2012     25%
    Sub task 1               9/17/2012   9/30/2012     40%
    Sub task 2               9/30/2012   10/6/2012      0%

Project Deliverable 3        10/6/2012 11/1/2012
  Task 1                     10/6/2012 10/19/2012       0%
  Task 2                     10/6/2012 10/26/2012       0%
  Task 3                    10/26/2012 11/1/2012        0%

Project Deliverable 4        5/10/2010   12/5/2012
  Task 1                     11/2/2012   12/5/2012      0%
    Sub Task 1              11/15/2012   12/5/2012      0%
  Task 2                     5/10/2010   5/30/2010      0%
  Task 3                     5/31/2010   6/20/2010      0%
  Task 4                     6/13/2010    7/4/2010      0%

Project Deliverable 5         7/5/2010   8/15/2010
  Task 1                      7/5/2010   7/18/2010      0%
  Task 2                     7/19/2010    8/1/2010      0%
  Task 3                      8/2/2010    8/8/2010      0%
  Task 4                      8/9/2010   8/15/2010      0%




                                                                         Page 1 of 6
                                                                       Example Project Plan Template




           Special Events      Start      End                  Project Plan Template
             Time off       11/10/2012 11/23/2012
              Holiday        9/25/2012 9/25/2012




                                                              11/1 Nov




                                                              12/1 Dec




                                                                    Jan
                                                              11/12




                                                              11/19




                                                              11/26




                                                              12/10




                                                              12/17




                                                              12/24




                                                              12/31
                                                              10/30
                                                              10/31




                                                              11/10
                                                              11/11

                                                              11/13
                                                              11/14
                                                              11/15
                                                              11/16
                                                              11/17
                                                              11/18

                                                              11/20
                                                              11/21
                                                              11/22
                                                              11/23
                                                              11/24
                                                              11/25

                                                              11/27
                                                              11/28
                                                              11/29
                                                              11/30




                                                              12/11
                                                              12/12
                                                              12/13
                                                              12/14
                                                              12/15
                                                              12/16

                                                              12/18
                                                              12/19
                                                              12/20
                                                              12/21
                                                              12/22
                                                              12/23

                                                              12/25
                                                              12/26
                                                              12/27
                                                              12/28
                                                              12/29
                                                              12/30
                                                              11/5




                                                              12/3




                                                              1/14
                                                              11/2
                                                              11/3
                                                              11/4

                                                              11/6
                                                              11/7
                                                              11/8
                                                              11/9




                                                              12/2

                                                              12/4
                                                              12/5
                                                              12/6
                                                              12/7
                                                              12/8
                                                              12/9




                                                              1/10
                                                              1/11
                                                              1/12
                                                              1/13

                                                              1/15
                                                              1/16
                                                              1/7
                                                              1/1
                                                              1/2
                                                              1/3
                                                              1/4
                                                              1/5
                                                              1/6

                                                              1/8
                                                              1/9
                               Start       End     % Compl.
Project Deliverable 1         9/1/2012   9/14/2012
  Task 1                      9/1/2012   9/14/2012     80%
  Task 2                      9/4/2012   9/11/2012     60%
  Task 3                     9/14/2012    3/5/2010     10%

Project Deliverable 2        9/16/2012   10/6/2012
  Task 1                     9/16/2012   10/6/2012     25%
    Sub task 1               9/17/2012   9/30/2012     40%
    Sub task 2               9/30/2012   10/6/2012      0%

Project Deliverable 3        10/6/2012 11/1/2012
  Task 1                     10/6/2012 10/19/2012       0%
  Task 2                     10/6/2012 10/26/2012       0%
  Task 3                    10/26/2012 11/1/2012        0%

Project Deliverable 4        5/10/2010   12/5/2012
  Task 1                     11/2/2012   12/5/2012      0%
    Sub Task 1              11/15/2012   12/5/2012      0%
  Task 2                     5/10/2010   5/30/2010      0%
  Task 3                     5/31/2010   6/20/2010      0%
  Task 4                     6/13/2010    7/4/2010      0%

Project Deliverable 5         7/5/2010   8/15/2010
  Task 1                      7/5/2010   7/18/2010      0%
  Task 2                     7/19/2010    8/1/2010      0%
  Task 3                      8/2/2010    8/8/2010      0%
  Task 4                      8/9/2010   8/15/2010      0%




                                                                                Page 2 of 6
                                                                     Example Project Plan Template




           Special Events      Start      End
             Time off       11/10/2012 11/23/2012
              Holiday        9/25/2012 9/25/2012




                                                               Feb
                                                              1/21




                                                              1/28




                                                              2/11




                                                              2/18
                                                              1/17
                                                              1/18
                                                              1/19
                                                              1/20

                                                              1/22
                                                              1/23
                                                              1/24
                                                              1/25
                                                              1/26
                                                              1/27

                                                              1/29
                                                              1/30
                                                              1/31




                                                              2/10

                                                              2/12
                                                              2/13
                                                              2/14
                                                              2/15
                                                              2/16
                                                              2/17

                                                              2/19
                                                              2/20
                                                              2/21
                                                              2/22
                                                              2/23
                                                              2/4
                                                              2/1
                                                              2/2
                                                              2/3

                                                              2/5
                                                              2/6
                                                              2/7
                                                              2/8
                                                              2/9
                               Start       End     % Compl.
Project Deliverable 1         9/1/2012   9/14/2012
  Task 1                      9/1/2012   9/14/2012     80%
  Task 2                      9/4/2012   9/11/2012     60%
  Task 3                     9/14/2012    3/5/2010     10%

Project Deliverable 2        9/16/2012   10/6/2012
  Task 1                     9/16/2012   10/6/2012     25%
    Sub task 1               9/17/2012   9/30/2012     40%
    Sub task 2               9/30/2012   10/6/2012      0%

Project Deliverable 3        10/6/2012 11/1/2012
  Task 1                     10/6/2012 10/19/2012       0%
  Task 2                     10/6/2012 10/26/2012       0%
  Task 3                    10/26/2012 11/1/2012        0%

Project Deliverable 4        5/10/2010   12/5/2012
  Task 1                     11/2/2012   12/5/2012      0%
    Sub Task 1              11/15/2012   12/5/2012      0%
  Task 2                     5/10/2010   5/30/2010      0%
  Task 3                     5/31/2010   6/20/2010      0%
  Task 4                     6/13/2010    7/4/2010      0%

Project Deliverable 5         7/5/2010   8/15/2010
  Task 1                      7/5/2010   7/18/2010      0%
  Task 2                     7/19/2010    8/1/2010      0%
  Task 3                      8/2/2010    8/8/2010      0%
  Task 4                      8/9/2010   8/15/2010      0%




                                                                              Page 3 of 6
Project Plan Guide:
•To delete these instructions, select this text box and then hit [Delete].

Date Cells (H6:GU7)
   These cells power much of the conditional formatting and allow the project plan to "float." All the cells are indirectl
referenced to cell G6, which can be set to a firm date (ex. 2/1/2010) or a reference (ex. =MIN([project dates])). Adjusti
G6 will shift the entire calendar.

Task Cells (A10:F40)
  The tasks have three levels, deliverable, task and sub task. Each has a different conditional format in the Gantt char

   Deliverable Sections
   The deliverable section(s) (ex. 15:19) can be copied and pasted as rows to add new deliverable sections below the
existing sections if needed.
   Within each deliverable section you can add additional room for tasks by inserting a row above the light blue row (e
13). This way the appropriate conditional formatting is added and no formulas are compromised.

   Task s
   By entering a task in the B column the conditional formatting will make the associated bar a medium blue. By enter
task in the C column the associated bar will be light blue. The bar is shown via conditional formatting based on the dat
entered (Cols D:E) cross referenced with the calendar across the top.
   Task dependence/precedence can be managed by creating formulas between the data cells instead of firm dates (e
=E11+5 vs. 2/10/2010).

Special Events (B2:E7)
    Functionality was added to allow for up to five "special events" that will highlight the background color. This was
intended for non-task events that may need to be included.

Misc.
   - There is a current date indicator that will show the current date on the Gantt chart.
   - The Gantt chart bars and the task list will highlight according to % complete status.
   - The Page Setup includes repeating rows of 2:9 and repeating columns of A:G. To print a small section of the chart s
select the area of the Gantt chart (ex. H10:AZ41) and set it as the Print Area.
   - Hypothetically additional days can be added to the calendar by copy and inserting columns to the left of Column G
sure to check that the formulas in 6:7 and 4:5 have been copied appropriately.
  to "float." All the cells are indirectly
 (ex. =MIN([project dates])). Adjusting cell



onditional format in the Gantt chart area.


 ew deliverable sections below the

ng a row above the light blue row (ex.
compromised.


 ciated bar a medium blue. By entering a
ditional formatting based on the dates

he data cells instead of firm dates (ex.



ht the background color. This was




o print a small section of the chart simply

ing columns to the left of Column GU. Be
Version
          Initial Version:
              - Six month view
              - Floating calendar via conditional formatting
   1.0
              - Special events (5) with background fill
              - Deliverable, task and sub-task levels
              - Current day indicator
          Added % complete status for tasks
   1.1       - Added highlighting of Gantt chart bars for % complete
             - Added highlighting of tasks that are behind plan

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:9
posted:9/11/2012
language:Unknown
pages:6