Spreadsheet: 24299d1214485979-change-date-in-one-box-all-dates-change-6-24-08-generator-slide-tray-project
Sheet: Project Plan

 |  | Generator Slide Tray Project | 103.75
 |  | % Complete => | 0.2388426725265526 |  |  | 0.3333333333333333 |  |  | 2008-06-26 00:00:00 | <= Today's Date
 |  | Estimated Total => | 479.825 |  |  | 2008-06-06 00:00:00 |  |  | 2008-08-06 00:00:00 |  | 0 |  |  |  |  |  |  |  | 2008-06-11 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2008-07-16 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2008-08-16 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2008-09-14 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2008-10-15 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2008-11-13 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2008-12-14 00:00:00
ID |  | Task name | Est. (hrs.) | LOE ( .1 - 1 ) | % Comp. | Start | Start Time | Finish Time | Finish | Assigned resource | Actual (hrs) |  | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 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 | 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 | 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 | 29 | 30 | 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 | 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 | 29 | 30 | 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 | 29 | 30 | 31 | 1 | 2
 |  |  |  |  |  |  |  |  |  |  |  |  | 2008-06-05 00:00:00 | 2008-06-06 00:00:00 | 2008-06-07 00:00:00 | 2008-06-08 00:00:00 | 2008-06-09 00:00:00 | 2008-06-10 00:00:00 | 2008-06-11 00:00:00 | 2008-06-12 00:00:00 | 2008-06-13 00:00:00 | 2008-06-14 00:00:00 | 2008-06-15 00:00:00 | 2008-06-16 00:00:00 | 2008-06-17 00:00:00 | 2008-06-18 00:00:00 | 2008-06-19 00:00:00 | 2008-06-20 00:00:00 | 2008-06-21 00:00:00 | 2008-06-22 00:00:00 | 2008-06-23 00:00:00 | 2008-06-24 00:00:00 | 2008-06-25 00:00:00 | 2008-06-26 00:00:00 | 2008-06-27 00:00:00 | 2008-06-28 00:00:00 | 2008-06-29 00:00:00 | 2008-06-30 00:00:00 | 2008-07-01 00:00:00 | 2008-07-02 00:00:00 | 2008-07-03 00:00:00 | 2008-07-04 00:00:00 | 2008-07-05 00:00:00 | 2008-07-06 00:00:00 | 2008-07-07 00:00:00 | 2008-07-08 00:00:00 | 2008-07-09 00:00:00 | 2008-07-10 00:00:00 | 2008-07-11 00:00:00 | 2008-07-12 00:00:00 | 2008-07-13 00:00:00 | 2008-07-14 00:00:00 | 2008-07-15 00:00:00 | 2008-07-16 00:00:00 | 2008-07-17 00:00:00 | 2008-07-18 00:00:00 | 2008-07-19 00:00:00 | 2008-07-20 00:00:00 | 2008-07-21 00:00:00 | 2008-07-22 00:00:00 | 2008-07-23 00:00:00 | 2008-07-24 00:00:00 | 2008-07-25 00:00:00 | 2008-07-26 00:00:00 | 2008-07-27 00:00:00 | 2008-07-28 00:00:00 | 2008-07-29 00:00:00 | 2008-07-30 00:00:00 | 2008-07-31 00:00:00 | 2008-08-01 00:00:00 | 2008-08-02 00:00:00 | 2008-08-03 00:00:00 | 2008-08-04 00:00:00 | 2008-08-05 00:00:00 | 2008-08-06 00:00:00 | 2008-08-07 00:00:00 | 2008-08-08 00:00:00 | 2008-08-09 00:00:00 | 2008-08-10 00:00:00 | 2008-08-11 00:00:00 | 2008-08-12 00:00:00 | 2008-08-13 00:00:00 | 2008-08-14 00:00:00 | 2008-08-15 00:00:00 | 2008-08-16 00:00:00 | 2008-08-17 00:00:00 | 2008-08-18 00:00:00 | 2008-08-19 00:00:00 | 2008-08-20 00:00:00 | 2008-08-21 00:00:00 | 2008-08-22 00:00:00 | 2008-08-23 00:00:00 | 2008-08-24 00:00:00 | 2008-08-25 00:00:00 | 2008-08-26 00:00:00 | 2008-08-27 00:00:00 | 2008-08-28 00:00:00 | 2008-08-29 00:00:00 | 2008-08-30 00:00:00 | 2008-08-31 00:00:00 | 2008-09-01 00:00:00 | 2008-09-02 00:00:00 | 2008-09-03 00:00:00 | 2008-09-04 00:00:00 | 2008-09-05 00:00:00 | 2008-09-06 00:00:00 | 2008-09-07 00:00:00 | 2008-09-08 00:00:00 | 2008-09-09 00:00:00 | 2008-09-10 00:00:00 | 2008-09-11 00:00:00 | 2008-09-12 00:00:00 | 2008-09-13 00:00:00 | 2008-09-14 00:00:00 | 2008-09-15 00:00:00 | 2008-09-16 00:00:00 | 2008-09-17 00:00:00 | 2008-09-18 00:00:00 | 2008-09-19 00:00:00 | 2008-09-20 00:00:00 | 2008-09-21 00:00:00 | 2008-09-22 00:00:00 | 2008-09-23 00:00:00 | 2008-09-24 00:00:00 | 2008-09-25 00:00:00 | 2008-09-26 00:00:00 | 2008-09-27 00:00:00 | 2008-09-28 00:00:00 | 2008-09-29 00:00:00 | 2008-09-30 00:00:00 | 2008-10-01 00:00:00 | 2008-10-02 00:00:00 | 2008-10-03 00:00:00 | 2008-10-04 00:00:00 | 2008-10-05 00:00:00 | 2008-10-06 00:00:00 | 2008-10-07 00:00:00 | 2008-10-08 00:00:00 | 2008-10-09 00:00:00 | 2008-10-10 00:00:00 | 2008-10-11 00:00:00 | 2008-10-12 00:00:00 | 2008-10-13 00:00:00 | 2008-10-14 00:00:00 | 2008-10-15 00:00:00 | 2008-10-16 00:00:00 | 2008-10-17 00:00:00 | 2008-10-18 00:00:00 | 2008-10-19 00:00:00 | 2008-10-20 00:00:00 | 2008-10-21 00:00:00 | 2008-10-22 00:00:00 | 2008-10-23 00:00:00 | 2008-10-24 00:00:00 | 2008-10-25 00:00:00 | 2008-10-26 00:00:00 | 2008-10-27 00:00:00 | 2008-10-28 00:00:00 | 2008-10-29 00:00:00 | 2008-10-30 00:00:00 | 2008-10-31 00:00:00 | 2008-11-01 00:00:00 | 2008-11-02 00:00:00 | 2008-11-03 00:00:00 | 2008-11-04 00:00:00 | 2008-11-05 00:00:00 | 2008-11-06 00:00:00 | 2008-11-07 00:00:00 | 2008-11-08 00:00:00 | 2008-11-09 00:00:00 | 2008-11-10 00:00:00 | 2008-11-11 00:00:00 | 2008-11-12 00:00:00 | 2008-11-13 00:00:00 | 2008-11-14 00:00:00 | 2008-11-15 00:00:00 | 2008-11-16 00:00:00 | 2008-11-17 00:00:00 | 2008-11-18 00:00:00 | 2008-11-19 00:00:00 | 2008-11-20 00:00:00 | 2008-11-21 00:00:00 | 2008-11-22 00:00:00 | 2008-11-23 00:00:00 | 2008-11-24 00:00:00 | 2008-11-25 00:00:00 | 2008-11-26 00:00:00 | 2008-11-27 00:00:00 | 2008-11-28 00:00:00 | 2008-11-29 00:00:00 | 2008-11-30 00:00:00 | 2008-12-01 00:00:00 | 2008-12-02 00:00:00 | 2008-12-03 00:00:00 | 2008-12-04 00:00:00 | 2008-12-05 00:00:00 | 2008-12-06 00:00:00 | 2008-12-07 00:00:00 | 2008-12-08 00:00:00 | 2008-12-09 00:00:00 | 2008-12-10 00:00:00 | 2008-12-11 00:00:00 | 2008-12-12 00:00:00 | 2008-12-13 00:00:00 | 2008-12-14 00:00:00 | 2008-12-15 00:00:00 | 2008-12-16 00:00:00 | 2008-12-17 00:00:00 | 2008-12-18 00:00:00 | 2008-12-19 00:00:00 | 2008-12-20 00:00:00 | 2008-12-21 00:00:00 | 2008-12-22 00:00:00 | 2008-12-23 00:00:00 | 2008-12-24 00:00:00 | 2008-12-25 00:00:00 | 2008-12-26 00:00:00 | 2008-12-27 00:00:00 | 2008-12-28 00:00:00 | 2008-12-29 00:00:00 | 2008-12-30 00:00:00 | 2008-12-31 00:00:00 | 2009-01-01 00:00:00 | 2009-01-02 00:00:00
1 |  | Analysis | 133 |  | 0.8099999999999999 | 2008-06-06 00:00:00 |  |  | 2008-07-01 00:00:00 |  | 0
x | 1.01 | Identify requirements | 10 | 1 | 1 | 2008-06-06 00:00:00 |  |  | 2008-06-09 00:00:00 | [NAME] | 0
x | 1.02 | Identify team | 1 | 1 | 1 | 2008-06-10 00:00:00 |  |  | 2008-06-10 00:00:00 | [NAME] | 0
x | 1.03 | Finalize responsibilities | 2 | 1 | 1 | 2008-06-11 00:00:00 |  |  | 2008-06-11 00:00:00 | [NAME] | 0
 |  | Market Analysis
x | 1.04 | Market Research | 80 | 1 | 0.65 | 2008-06-12 00:00:00 |  |  | 2008-06-26 00:00:00 | [NAME] | 0
 | 1.05 | Motor Research | 40 | 1 | 0.4 | 2008-06-26 00:00:00 |  |  | 2008-07-01 00:00:00 | Kurt | 0
2 |  | Document summary of request | 5.5 |  | 0.15 | 2008-06-06 00:00:00 |  |  | 2008-06-07 00:00:00 |  | 0
 | 2.01 | Complete Business Feasability Expansion Form | 5 | 1 | 0.3 | 2008-06-06 00:00:00 |  |  | 2008-06-07 00:00:00 | Carter/Kurt | 0
 | 2.02 | Buy off | 0.5 | 1 | 0 | 2008-06-06 00:00:00 |  |  | 2008-06-06 00:00:00 | Team + Mgmt | 0
3 |  | Develop project plan | 4 |  | 0.4 | 2008-06-09 00:00:00 |  |  | 2008-06-09 00:00:00 |  | 0
x | 3.01 | Customize project template | 3 | 1 | 0.8 | 2008-06-09 00:00:00 |  |  | 2008-06-09 00:00:00 | Kurt | 0
 | 3.02 | Review project plan w/management | 1 | 1 | 0 | 2008-06-09 00:00:00 |  |  | 2008-06-09 00:00:00 | Team + Mgmt | 0
4 |  | Coordinate w/client and stakeholders | 6.25 |  | 0.39 | 2008-06-10 00:00:00 |  |  | 2008-06-11 00:00:00 |  | 0
x | 4.01 | Determine target date w/ implementation team | 5 | 1 | 0.95 | 2008-06-10 00:00:00 |  |  | 2008-06-11 00:00:00 | Team | 0
x | 4.02 | Schedule meeting w/stakeholders | 0.25 | 1 | 1 | 2008-06-10 00:00:00 |  |  | 2008-06-10 00:00:00 | Kurt | 0
x | 4.029999999999999 | Meet w/stakeholders | 1 | 1 | 0 | 2008-06-11 00:00:00 |  |  | 2008-06-11 00:00:00 | Team | 0
 |  | Review project plan |  |  |  | 2008-06-11 00:00:00 |  |  | 2008-06-11 00:00:00 |  | 0
 |  | Identify potential risks |  |  |  | 2008-06-11 00:00:00 |  |  | 2008-06-11 00:00:00 |  | 0
 |  | Set schedule |  |  |  | 2008-06-11 00:00:00 |  |  | 2008-06-11 00:00:00 |  | 0
 | 4.039999999999999 | Send stakeholders an e-mail summarizing meeting | 0.5 | 1 | 0 | 2008-06-11 00:00:00 |  |  | 2008-06-11 00:00:00 | Kurt | 0
 | 4.049999999999999 | Confirm schedule w/implementation team | 0.25 | 1 | 0 | 2008-06-11 00:00:00 |  |  | 2008-06-11 00:00:00 | [NAME] | 0
5 |  | Itemize activities | 282 |  | 0.08 | 2008-06-10 00:00:00 |  |  | 2008-07-24 00:00:00 |  | 0
 |  | Front End Mock-up for R&D |  |  |  |  |  |  |  |  | 0
x | 5.01 | Research for front mock-up of chassis | 1.5 | 1 | 0.8 | 2008-06-25 00:00:00 |  |  | 2008-06-25 00:00:00 | Jeremy/Griffin | 0
 | 5.02 | [NAME]'s for mock-up | 14 | 1 | 0 | 2008-06-25 00:00:00 |  |  | 2008-06-27 00:00:00 | Jeremy/Griffin | 0
 | 5.029999999999999 | Put in order | 1 | 1 | 0 | 2008-06-27 00:00:00 |  |  | 2008-06-27 00:00:00 | Jeremy/Griffin | 0
 |  | [NAME]
 | 5.039999999999999 | Design Time | 80 | 1 | 0 | 2008-06-10 00:00:00 |  |  | 2008-06-24 00:00:00 | Jeremy/Griffin | 0
 | 5.049999999999999 | Put in order for proto | 30 | 1 | 0 | 2008-06-24 00:00:00 |  |  | 2008-06-28 00:00:00 | Jeremy/Griffin | 0
 | 5.059999999999999 | Proto Review | 30 | 1 | 0 | 2008-06-28 00:00:00 |  |  | 2008-07-02 00:00:00 | Team + Mgmt | 0
 |  | [NAME] |  |  |  |  |  |  |  |  | 0
 | 5.069999999999999 | Proto Redesign | 20 | 1 | 0 | 2008-07-02 00:00:00 |  |  | 2008-07-05 00:00:00 | Jeremy/Griffin | 0
 | 5.079999999999998 | Put in order for 2nd proto | 32 | 1 | 0 | 2008-07-05 00:00:00 |  |  | 2008-07-09 00:00:00 | Jeremy/Griffin | 0
 | 5.089999999999998 | Proto Review & Testing | 80 | 1 | 0 | 2008-07-09 00:00:00 |  |  | 2008-07-23 00:00:00 | Team + R&D
 | 5.1 | Finalize Prints for manufacturing | 10 | 1 | 0 | 2008-07-23 00:00:00 |  |  | 2008-07-24 00:00:00 | Jeremy/Griffin
6 |  | Miscellaneous  ( = 10% of estimated time required for project) | 43.075 |  | 0 | 2008-07-25 00:00:00 |  |  | 2008-08-02 00:00:00
 |  |  | 430.75
7 |  | Assess project | 5 |  | 0 | 2008-08-02 00:00:00 |  |  | 2008-08-05 00:00:00 | Carter/Kurt | 0
8 |  | Update project plan template | 1 |  | 0 | 2008-08-06 00:00:00 |  |  | 2008-08-06 00:00:00 | Kurt | 0