ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAPAQARASATAUAVAWAXAYAZBABBBCBDBEBFBGBHBIBJBKBLBMBNBOBPBQBRBSBTBUBVBWBXBYBZCACBCCCDCECFCGCHCICJCKCLCMCNCOCPCQCRCSCTCUCV
1
How to use this template: File > Make copy > Select the location of the new file > And create!
2
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.
MCA Example Project
DO NOT COPY
3
Enter Company Name in cell B2.
Team Number: 00Project Start:Mon, 1/10/2022
4
Enter the name of the Project Lead in cell B3. Enter the Project Start date in cell E3. Pooject Start: label is in cell C3.
Project Team Members: Dann Garcia, Luke Martin, Haile BrownDisplay Week:1
5
6
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.		ID#TASKASSIGNED TOPROGRESSSTARTENDDAYSMarginJan 10, 2022Jan 17, 2022Jan 24, 2022Jan 31, 2022Feb 7, 2022Feb 14, 2022Feb 21, 2022Feb 28, 2022Mar 7, 2022Mar 14, 2022Mar 21, 2022Mar 28, 2022Apr 4, 2022
7
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.		101112131415161718192021222324252627282930311234567891011121314151617181920212223242526272812345678910111213141516171819202122232425262728293031123456789
8
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.		MTWTFSSMTWTFSSMTWTFSSMTWTFSSMTWTFSSMTWTFSSMTWTFSSMTWTFSSMTWTFSSMTWTFSSMTWTFSSMTWTFSSMTWTFS
9
1Selection of Instrumentation20%1/10/222/1/222313
10
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 progres 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. 		1.1Perform a trade study to select detectorEngineeringComplete1/10/221/18/229
11
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.		1.2Draft final Bill of Materials (BOM)AdminNot complete1/15/221/18/224
12
1.4Schedule Margin1/19/221/31/2213
13
1.5◆ Purchase Instrument and MaterialsNot complete2/1/222/1/221◆
14
2Verification of Electronics Functionality0%2/2/222/23/22226
15
2.1Complete table top assembly of detectorElectrical, EngineeringNot complete2/2/222/5/224
16
2.2Verify nominal functionalityScienceNot complete2/6/222/11/226
17
2.3Perform callibration of detectorElectrical, EngineeringNot complete2/12/222/18/227
18
2.5Schedule Margin2/18/222/23/226
19
2.6◆ Completion of Hardware CheckNot complete2/23/222/23/221◆
20
Sample phase title block
3Completion of Data handling, Acquisition, and Conditioning0%2/2/222/23/22226
21
3.1Install any needed drivers SofwareNot complete2/2/222/4/223
22
3.2Write test programSofwareNot complete2/5/222/18/2214
23
3.5Schedule Margin2/18/222/23/226
24
3.6◆ Completion of Data Handeling Set-up Not complete2/23/222/23/221◆
25
Sample phase title block
4Validation of Detector Performance0%2/24/223/9/22141
26
4.1Perform Thermal Vacuum TestsScience, EngineeringNot complete2/24/222/28/225
27
4.2Perform Vibration Chamber TestsScience, EngineeringNot complete2/28/223/4/225
28
4.3Perform Simulated Atmosphere TestsScience, EngineeringNot complete3/4/223/8/225
29
4.5Schedule Margin3/9/223/9/221
30
4.6◆ Preliminary Instrument Tests CompleteNot complete3/9/223/9/221◆
31
This is an empty row
5Completion of Final Instrument Design 0%2/24/224/13/22498
32
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.		5.1Complete Draft 1 CADDann, HaileNot complete2/24/223/10/2215
33
5.2Print Vers. #1 of Instrument HousingLukeNot complete3/10/223/14/225
34
5.3Revise Design Based on TestingDann, HaileNot complete3/23/223/27/225
35
5.4Print Vers. #2 of Instrument HousingLukeNot complete3/27/223/31/225
36
5.5Fininalize DesignDann, HaileNot complete4/10/224/13/224
37
5.6Schedule Margin4/13/224/20/228
38
5.7◆ Print Final Housing in Space Grade PolymerNot complete4/20/224/20/221
39
6Execution of Housed Instrument Testing0%3/14/224/30/22481
40
6.1Perform Thermal Vacuum Test on Print #1Science, EngineeringNot complete3/14/223/17/224
41
6.2Perform Vibration Chamber Test on Print #1Science, EngineeringNot complete3/17/223/20/224
42
6.3Perform Simulated Atmosphere Test on Print #1Science, EngineeringNot complete3/20/223/23/224
43
6.4Perform Thermal Vacuum Test on Print #2Science, EngineeringNot complete3/31/224/3/224
44
6.5Perform Vibration Chamber Test on Print #2Science, EngineeringNot complete4/4/224/7/224
45
6.6Perform Simulated Atmosphere Test on Print #2Science, EngineeringNot complete4/7/224/10/224
46
6.7Perform Thermal Vacuum Test on Final PrintScience, EngineeringNot complete4/20/224/23/224
47
6.8Perform Vibration Chamber Test on Final PrintScience, EngineeringNot complete4/24/224/27/224
48
6.9Perform Simulated Atmosphere Test on Final PrintScience, EngineeringNot complete4/27/224/30/224
49
6.10Schedule Margin4/30/224/30/221
50
6.11◆ Detector Housing Design Complete and TestedNot complete4/30/224/30/221
51
7Completion of Critical Design Review (CDR) Presentation0%4/13/225/8/22262
52
7.1Draft 1 of CDRAllNot complete4/13/224/27/2215
53
7.2Revise CDRAllNot complete4/27/225/4/228
54
7.3Final Draft of CDRAllNot complete5/4/225/6/223
55
7.4Schedule Margin5/6/225/7/222
56
7.5◆ CDR PresentationNot complete5/8/225/8/221
57
58
59
60
61