Gantt chart template pro unlock

GanttChart
Gantt Chart Version 1.7.3 © 2006-2014 Vertex42 LLC
Vertex42: Terms of Use and Copyright: See the Terms Of Use worksheet and the license agreement on Vertex42.com. Copyright notices may not be removed. 0
HELP
[Automation of Supply Chain Management System]
Ray & Young Inc. Today's Date: 10/22/15 Thursday
(vertical red line)
Project Lead: Rodney Wheeler [42]
Start Date: 10/22/15 Thursday
[42] First Day of Week (Mon=2): 2 10/19/15 10/20/15 10/21/15 10/22/15 10/23/15 10/24/15 10/25/15 10/26/15 10/27/15 10/28/15 10/29/15 10/30/15 10/31/15 11/1/15 11/2/15 11/3/15 11/4/15 11/5/15 11/6/15 11/7/15 11/8/15 11/9/15 11/10/15 11/11/15 11/12/15 11/13/15 11/14/15 11/15/15 11/16/15 11/17/15 11/18/15 11/19/15 11/20/15 11/21/15 11/22/15 11/23/15 11/24/15 11/25/15 11/26/15 11/27/15 11/28/15 11/29/15 11/30/15 12/1/15 12/2/15 12/3/15 12/4/15 12/5/15 12/6/15 12/7/15 12/8/15 12/9/15 12/10/15 12/11/15 12/12/15 12/13/15 12/14/15 12/15/15 12/16/15 12/17/15 12/18/15 12/19/15 12/20/15 12/21/15 12/22/15 12/23/15 12/24/15 12/25/15 12/26/15 12/27/15 12/28/15 12/29/15 12/30/15 12/31/15 1/1/16 1/2/16 1/3/16 1/4/16 1/5/16 1/6/16 1/7/16 1/8/16 1/9/16 1/10/16 1/11/16 1/12/16 1/13/16 1/14/16 1/15/16 1/16/16 1/17/16 1/18/16 1/19/16 1/20/16 1/21/16 1/22/16 1/23/16 1/24/16 1/25/16 1/26/16 1/27/16 1/28/16 1/29/16 1/30/16 1/31/16 2/1/16 2/2/16 2/3/16 2/4/16 2/5/16 2/6/16 2/7/16 2/8/16 2/9/16 2/10/16 2/11/16 2/12/16 2/13/16 2/14/16 2/15/16 2/16/16 2/17/16 2/18/16 2/19/16 2/20/16 2/21/16 2/22/16 2/23/16 2/24/16 2/25/16 2/26/16 2/27/16 2/28/16 2/29/16 3/1/16 3/2/16 3/3/16 3/4/16 3/5/16 3/6/16 3/7/16 3/8/16 3/9/16 3/10/16 3/11/16 3/12/16 3/13/16 3/14/16 3/15/16 3/16/16 3/17/16 3/18/16 3/19/16 3/20/16 3/21/16 3/22/16 3/23/16 3/24/16 3/25/16 3/26/16 3/27/16 3/28/16 3/29/16 3/30/16 3/31/16 4/1/16 4/2/16 4/3/16 4/4/16 4/5/16 4/6/16 4/7/16 4/8/16 4/9/16 4/10/16 4/11/16 4/12/16 4/13/16 4/14/16 4/15/16 4/16/16 4/17/16 4/18/16 4/19/16 4/20/16 4/21/16 4/22/16 4/23/16 4/24/16 4/25/16 4/26/16 4/27/16 4/28/16 4/29/16 4/30/16 5/1/16 5/2/16 5/3/16 5/4/16 5/5/16 5/6/16 5/7/16 5/8/16 5/9/16 5/10/16 5/11/16 5/12/16 5/13/16 5/14/16 5/15/16 5/16/16 5/17/16 5/18/16 5/19/16 5/20/16 5/21/16 5/22/16 5/23/16 5/24/16 5/25/16 5/26/16 5/27/16 5/28/16 5/29/16 5/30/16 5/31/16 6/1/16 6/2/16 6/3/16 6/4/16 6/5/16 6/6/16 6/7/16 6/8/16 6/9/16 6/10/16 6/11/16 6/12/16
WBS
Jon: Work Breakdown Structure Level 1: 1, 2, 3, ... Level 2: 1.1, 1.2, 1.3, ... Level 3: 1.1.1, 1.1.2, 1.1.3, … The WBS is automatically entered, but the formulas are different for different levels. Tasks Task Lead Start
Jon: Start Date Enter the starting date for this task. To associate the start date with the end of another task, enter a formula in the start date that refers to the end date of that task. End
Jon: End Date The ending date is calculated by adding the Duration (calendar days) to the Start date minus 1 day, because the task duration is from the beginning of the Start day to the end of the End day. Duration (Days)
Jon: Duration (Calendar Days) Enter the number of calendar days for the given task. Refer to the Working Days column or use a calendar to determine the corresponding working days. The duration is from the beginning of the Start date to the ending of the End Date. When the duration is calculated, it is calculated as End Date minus the Start Date plus 1 day, so that a task starting and ending on the same day has a duration of 1 day. % Complete
Jon: Percent Complete Update the status of this task by entering the percent complete (between 0% and 100%). Working Days
Jon: Working Days Counts the number of working days using the NETWORKDAYS() formula, which excludes weekends. When planning work based upon the number of working days, adjust the Duration until the desired # of working days is reached. Days Complete
Jon: Calendar Days Complete This column is calculated by multiplying the Duration by the %Complete and rounding down to the nearest integer. Days Remaining
Jon: Calendar Days Remaining This column is calculated by subtracting the Days Complete from the Duration. 19 - Oct - 15 26 - Oct - 15 02 - Nov - 15 09 - Nov - 15 16 - Nov - 15 23 - Nov - 15 30 - Nov - 15 07 - Dec - 15 14 - Dec - 15 21 - Dec - 15 28 - Dec - 15 04 - Jan - 16 11 - Jan - 16 18 - Jan - 16 25 - Jan - 16 01 - Feb - 16 08 - Feb - 16 15 - Feb - 16 22 - Feb - 16 29 - Feb - 16 07 - Mar - 16 14 - Mar - 16 21 - Mar - 16 28 - Mar - 16 04 - Apr - 16 11 - Apr - 16 18 - Apr - 16 25 - Apr - 16 02 - May - 16 09 - May - 16 16 - May - 16 23 - May - 16 30 - May - 16 06 - Jun - 16
1 Initiation Andrew Ray 1/2/15 1/16/15 15 0% 11 0 15
1.1 Charter Development 1/2/15 1/5/15 4 0% 2 0 4
1.2 Scope Definition 1/2/15 1/4/15 3 0% 1 0 3
1.2.1 Preliminary definition 1/4/15 1/5/15 2 0% 1 0 2
1.2.2 Final definition 1/6/15 1/7/15 2 0% 2 0 2
1.3 Defining objectives 1/7/15 1/7/15 1 0% 1 0 1
1.4 Mission statements 1/11/15 1/11/15 1 0% 0 0 1
2 Planning Andrew Ray 1/1/15 1/24/15 24 25% 17 6 18
2.1 Setting up the project 1/1/15 1/5/15 5 25% 3 1 4
2.2 Scope Definition 1/4/15 1/8/15 5 25% 4 1 4
2.3 Develop Project schedule 1/9/15 1/13/15 5 25% 3 1 4
2.4 Develop risk plan 1/14/15 1/22/15 9 25% 7 2 7
3 Execution Vincent Ayam 1/1/15 1/23/15 23 50% 17 11 12
3.1 Acquire project team 1/1/15 1/6/15 6 50% 4 3 3
3.2 Direct and manage 1/4/15 1/7/15 4 50% 3 2 2
3.3 Manage team performance 1/9/15 1/15/15 7 50% 5 3 4
3.4 Quality and contract management 1/14/15 1/19/15 6 50% 4 3 3
4 Monitoring and Completion Andrew Ray 1/1/15 1/30/15 30 0% 22 0 30
4.1 Monitoring and quality management 1/1/15 1/10/15 10 0% 7 0 10
4.2 Change control 1/4/15 1/13/15 10 0% 7 0 10
4.3 Completion 1/9/15 1/13/15 5 0% 3 0 5
4.4 Handing over the project 1/14/15 1/17/15 4 0% 3 0 4
TEMPLATE ROWS: Copy and insert the entire section, or just the specific sub tasks, depending on which level you want to use (formulas are different for different WBS levels)
1 Task Category 1 1/1/15 1/7/15 7 0% 5 0 7
1.1 Sub Task level 2 1/1/15 1/7/15 7 0% 5 0 7
1.1.1 Level 3 Task 1/1/15 1/7/15 7 0% 5 0 7
1.1.1.1 Level 4 task 1/1/15 1/7/15 7 0% 5 0 7
&8Gantt Chart Template by Vertex42.com &8© 2008 Vertex42 LLC

HELP - Modify the GREEN cells and the Tasks, and Task Lead columns. Some of the green cells contain formulas, but those formulas are just examples of ways to add automation and task dependency. You can enter values manually into the green cells, or use formulas. - The Start Date that you choose determines the first week in the gantt chart. - Change the first day of the week via cell K8 - Use the slider to adjust the range of dates shown in the gantt chart. - The number of weeks shown in the gantt chart is limited by the maximum number of columns available in Excel. - Only 34 weeks (7 1/2 months) can be shown/printed at one time, because each week uses up 7 columns. Q: The Working Days column shows "###". How do I fix that? You need to install the Analysis ToolPak add-in that comes with Excel. Go to Tools > Add-ins, and select Analysis ToolPak. Q: How do I make Task 2 start the day after the end of Task 1? Use the following formula for the start date of Task 2: =EndDate+1 where EndDate is the reference to the cell containing the end date of task 1. You can also use =WORKDAY(EndDate,1) to exclude weekends. Q: How do I add/insert tasks and subtasks? Copy the entire ROW (or a group of rows) for the type of task(s) you want to add and then right-click on the row where you want to insert the new tasks, then select Insert Copied Cells. You can copy rows from within the gantt chart, or copy rows from the Template Rows. Important Note: When inserting a new subtask after the last subtask or before the first subtask, you will need to update the formulas for calculating the Level 1 Start Date, %Complete and Duration, because the ranges won't automatically expand to include the additional row. Q: How to I calculate the Start Date for a Level 1 task based upon its subtasks? Example: If Task 1 is on row 10 and the subtasks are on rows 11-14, use the following formula: =MIN(D11:D16) Q: How do I calculate the %Complete for a Level 1 task based upon the %Complete of all of the associated subtasks? Example: If Task 1 is on row 10 and the subtasks are on rows 11-14, use the following formula: =SUMPRODUCT(F11:F14,G11:G14)/SUM(F11:F14) Q: How do I calculate the Duration for a Level 1 task based upon the largest end date of a sub task? Example: If the Level 1 task is on row 10 and the sub tasks are on rows 11-14, use the following formula =MAX(D11:D14)-C10+1 Q: How do I change the print settings? Select the entire range of cells that you want to print and then go to File > Print Area > Set Print Area. Then go to File > Page Setup or File > Print Preview and adjust the Scaling and Page Orientation as desired. Q: How do I exclude holidays? The functions WORKDAY() and NETWORKDAYS() allow you to include a list of holidays. See the Excel help (F1) for information about how to use these functions. Gantt Chart Template Pro includes a worksheet for listing all the dates of the holidays that you want to exclude. Q: How do I change the background color of the bars in the Gantt Chart? The colors used for the bars in the Gantt Chart are set using Conditional Formatting. The simplest approach for Excel 2002/2003 would be to change the colors via the color palette. Go to Tools > Options > Color tab. Or, you can select all of the cells in the Gantt Chart and go to Format > Conditional Formatting to change the colors. Q: How do I use grouping? [Feature unavailable when the spreadsheet is locked] You can expand or collapse a group of rows using Excel's "Group and Outline" feature. To define a group of rows, select the rows and go to Data > Group and Outline and select Group ...