Excel wbs formula

GanttChart
PEGGY PARK
HUSSAIN AL MUHANA
T00569488
Project Start Date 43371.0 Display Week 16 Week 16 Week 17 Week 18 Week 19 Week 20 Week 21 Week 22 Week 23
Project Lead 7 Jan 2019 14 Jan 2019 21 Jan 2019 28 Jan 2019 4 Feb 2019 11 Feb 2019 18 Feb 2019 25 Feb 2019
7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 1 2 3
WBS
Vertex42: 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 uses a formula to control the numbering, but the formulas are different for different levels. Copy and Paste the cells in the WBS column from the examples at the bottom of the worksheet. TASK
Vertex42: Task Description Enter the name of each task and sub-task. Use indents for sub-tasks. LEAD
Vertex42: Task Lead Enter the name of the Task Lead in this column. PREDECESSOR
Vertex42: Predecessor Tasks: You can use this column to enter the WBS of a predecessor for reference. The PRO version uses formulas to automatically calculate the Start Date based on the Predecessor. START
Vertex42: Task Start Date You can manually enter the Start Date for each task or use a formula to create a dependency on a Predecessor. For example, you could enter =enddate+1 to set the Start date to the next calendar day, or =WORKDAY(enddate,1) to set the Start date to the next work day (excluding weekends), where enddate is the cell reference for the End date of the Predecessor task. END
Vertex42.com Templates: End Date: The End Date is calculated based on the Start Date and the Calendar Days columns. DAYS
Vertex42: Duration (Calendar Days) The duration is the number of calendar days for the given task. The duration is calculated as the 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. Note: The conditional formatting used to create the gantt chart references this column.
Vertex42: Percent Complete Update the status of this task by entering the percent complete (between 0% and 100%). WORK DAYS
Vertex42: Work Days Counts the number of work days, excluding the weekends (Saturday and Sunday). In the PRO version, you can customize the work week and list specific non-working days like holidays. In the PRO version, the default input is the Work Days instead of the Calendar Days. M T W T F S S M T W T F S S M T W T F S S M T W T F S S M T W T F S S M T W T F S S M T W T F S S M T W T F S S
1 [Task Category] - -
1.1 PEGGY PARK Sat 9/29/18 Fri 4/05/19 189 135
1.2 SUBMITTALS Sat 9/29/18 Thu 11/29/18 62 44
1.3 MOBILIZATION Fri 10/05/18 Thu 10/18/18 14 10
1.4 TREE PRESERVATION Sat 10/06/18 Fri 10/12/18 7 5
0 DEMOTILTION Sat 10/06/18 Fri 11/02/18 28 20
0.1 STORM DRAINAGE Fri 10/12/18 Thu 10/25/18 14 10
0.1.1 ELECTRICAL ROUGH-IN Fri 10/19/18 Thu 11/29/18 42 30
0.2 PAVILLION Fri 10/05/18 Fri 3/01/19 148 106
0.3 DEMOTILTION Fri 10/05/18 Thu 11/01/18 28 20
0.4 SANDBLAST COLUMNS Fri 11/02/18 Thu 11/29/18 28 20
0.5 PAINT Thu 11/08/18 Wed 12/05/18 28 20
0.6 INSTALL LIGHTS Fri 12/28/18 Thu 1/31/19 35 25
0.7 FENCE Fri 1/18/19 Thu 1/31/19 14 10
0.8 COURT REPAIRS Sun 2/17/19 Sun 3/10/19 22 15
0.9 PAVING Fri 1/25/19 Thu 2/21/19 28 20
0.10 SIDEWALKS-SOUTH Wed 10/10/18 Sun 12/23/18 75 53
0.11 ACCENT PAVERS Sat 12/15/18 Fri 2/01/19 49 35
0.12 SIDEWALKS-NORTH Thu 2/01/18 Wed 2/28/18 28 20
0.13 OUTDOOR CLASSROOMS Fri 10/12/18 Thu 1/03/19 84