ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAPAQARASATAUAVAWAXAYAZBABBBCBDBEBFBGBHBIBJBKBLBMBNBOBPBQBRBSBTBUBVBWBXBYBZCACBCCCDCECFCGCHCICJCKCLCMCNCOCPCQCRCSCTCUCV
1
Create a Project Schedule in this worksheet.
Enter title of this project in cell B1.
Information about how to use this worksheet, including instructions for screen readers and the author of this workbook is in the About worksheet.
Continue navigating down column A to hear further instructions.
AoA of Workstation Deployment Solution- Team3
3
Enter the name of the Project Lead in cell B3. Enter the Project Start date in cell E3. Project Start: label is in cell C3.
Team Lead: Mohammed Alam
Team Members:
Project Start:Mon, 8/29/2022
Project Plan
Milestone-1
Milestone-2
Milestone-3
Final Report
4
The Display Week in cell E4 represents the starting week to display in the project schedule in cell I4. The project start date is considered Week 1. To change the display week, simply enter a new week number in cell E4.
The starting date for each week, starting with the display week from cell E4, starts in cell I4 and is auto calculated. There are 8 weeks represented in this view from cell I4 through cell BF4.
You should not modify these cells.
Display Week: label is in cell C4.		Brittany Davis
Rahima Daino		Display Week:1Aug 29, 2022Sep 5, 2022Sep 12, 2022Sep 19, 2022Sep 26, 2022Oct 3, 2022Oct 10, 2022Oct 17, 2022Oct 24, 2022Oct 31, 2022Nov 7, 2022Nov 14, 2022Nov 21, 2022Nov 28, 2022
5
Cells I5 through BL5 contain the day number for the week represented in the cell block above each date cell and are auto calculated.
You should not modify these cells.
Today's date is outlined in Red (hex #AD3815) from today's date in row 5 through the entire date column to the end of the project schedule.		Kendrick Martin2930311234567891011121314151617181920212223242526272829301234567891011121314151617181920212223242526272829303112345678910111213141516171819202122232425262728
6
This row contains headers for the project schedule that follows below them.
Navigate from B6 through BL 6 to hear the content. The first letter of each day of the week for the date above that heading, starts in cell I6 and continues through cell BL6.
All project timeline charting is auto generated based on the start and end dates entered, using conditional formats.
Do not modify content in cells within columns after column I starting with cell I7.		TASKASSIGNED
TO		PROGRESSSTARTENDDAYSTOTAL HRMTWTFSSMTWTFSSMTWTFSSMTWTFSSMTWTFSSMTWTFSSMTWTFSSMTWTFSSMTWTFSSMTWTFSSMTWTFSSMTWTFSSMTWTFSSM
8
Cell B8 contains the Phase 1 sample title.
Enter a new Title in cell B8.
Enter a name to assign the phase to, if it applies for your project, in cell C8.
Enter Progress for the entire phase, if it applies for your project, in cell D8.
Enter the start and end dates for the entire phase, if it applies for your project, in cells E8 and F8.
The Gantt chart will automatically fill in the appropriate dates and shade according to the progress entered.
To delete the phase and work only from tasks, simply delete this row.		Planning
9
Cell B9 contains the sample task "Task 1."
Enter a new task name in cell B9.
Enter a person to assign the task to in cell C9.
Enter progress of the task in cell D9. A progress bar appears in the cell and is shaded according to the number in the cell. For example, 50 percent progress would shade half of the cell.
Enter task start date in cell E9.
Enter task end date in cell F9.
A status bar shaded for the dates entered appears in blocks starting from cell I9 through BL9. 		Prepare the Gantt ChartMohammed100%8/29/229/1/223
10
Rows 10 through 13 repeat the pattern from row 9.
Repeat the instructions from cell A9 for all task rows in this worksheet. Overwrite any sample data.
A sample of another phase starts in cell A14.
Continue entering tasks in cells A10 through A13 or go to cell A14 to learn more.		Prepare Planning Doc Part1Brittany100%8/29/229/1/223
11
Prepare Planning Doc Part2
Rahima100%8/29/229/1/223
12
The cell at right contains the Phase 2 sample title.
You can create a new phase at any time within column B. This project schedule does not require phases. To remove the phase, simply delete the row.
To create a new phase block in this row, enter a new Title in cell at right.
To continue adding tasks to the phase above, enter a new row above this one and fill in the task data as in cell A9's instruction.
Update the Phase details in cell at right based on cell A8's instruction.
Continue navigating down column A cells to learn more.
If you haven't added any new rows in this worksheet, you will find 2 additional sample phase blocks have been created for you in cells B20 and B26. Otherwise, navigate through column A cells to find the additional blocks.
Repeat the instructions from cells A8 and A9 whenever you need to.		Designing the Research
13
Milestone Report Template
Mohammed100%9/5/229/9/228
14
Understanding Requirement and find tools
Brittany100%9/5/229/9/228
15
Understanding Requirement and find tools
Rahima100%9/5/229/9/228
16
Sample phase title block
Collecting Data Phase1
17
Find 4 toolsMohammed100%9/12/229/16/228
18
Find 3 toolsBrittany100%9/12/229/16/228
19
Find 3 toolsRahima100%9/12/229/16/228
20
Sample phase title block
Collecting Data Phase2
21
Milestone Report Mohammed100%9/19/229/23/229
22
Milestone Report Brittany100%9/19/229/23/229
23
Milestone Report Rahima100%9/19/229/23/229
24
Sample phase title block
Collecting Data for Testing Environment
25
Collect data for test envMohammed100%9/26/229/30/225
26
Prepare Doc test envBrittany100%9/26/229/30/225
27
Collect data for test envRahima100%9/26/229/30/228
28
Sample phase title block
Perform Testing I
29
Prepare documentMohammed100%10/3/2210/7/2210
30
Install ToolsBrittany100%10/3/2210/7/228
31
Install ToolsRahima100%10/3/2210/7/228
32
Sample phase title block
Perform Testing II
33
Install Tools and TestMohammed100%10/10/2210/14/2210
34
Install Tools and TestBrittany100%10/10/2210/14/228
35
Install Tools and TestRahima100%10/10/2210/14/228
36
Sample phase title block
Perform Testing III
37
Test and Deploy OSMohammed100%10/17/2210/21/2230
38
Test and Deploy OSBrittany100%10/17/2210/21/2212
39
Test and Deploy OSRahima100%10/17/2210/21/2212
40
Sample phase title block
C-Day, Milestone 2
41
Prepare Milestone 2 and Gant Chart
Mohammed100%10/24/2210/28/227
42
Milestone 2 and C dayBrittany100%10/24/2210/28/228
43
Milestone 2 and C dayRahima100%10/24/2210/28/227
44
Sample phase title block
Milestone 2 and Testing Result
45
Milestone 2Mohammed100%10/31/2211/4/226
46
Tool testing and Milestone 2
Brittany100%10/31/2211/4/227
47
Milestone 2Rahima100%10/31/2211/4/226
48
Sample phase title block
C-Day Activities and Final Report
49
C-Day Postcard and Tool Testing
Mohammed100%11/6/2211/11/226
50
C-Day VideoBrittany100%11/6/2211/11/224
51
C-Day VideoRahima100%11/6/2211/11/224
52
Sample phase title block
Milestone 3 and Presentation Video
53
Prepare and Complete the PPT
Mohammed100%11/14/2211/18/2212
54
Complete the PPT Brittany100%11/14/2211/18/225
55
Complete the PPT Rahima100%11/14/2211/18/225
56
Sample phase title block
Prepare Final Report
57
Complete the PPT and Video
Mohammed100%11/21/2211/25/226
58
Complete the PPT and Video
Brittany100%11/21/2211/25/225
59
Complete the PPT and Video
Rahima100%11/21/2211/25/225
60
Sample phase title block
Final Report Submit
61
Complete the new websites, Prepare and Complete the Final report, Submit all Documents
Mohammed100%11/28/2212/2/2222
62
Complete the Final reportBrittany100%11/28/2212/2/228
63
Complete the Final reportRahima100%11/28/2212/2/228
64
This is an empty row
65
66
This row marks the end of the Project Schedule. DO NOT enter anything in this row.
Insert new rows ABOVE this one to continue building out your Project Schedule.		Insert new rows ABOVE this one
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102