Spreadsheet: 134845d1325674829-nested-and-if-problem-syntax-and-solve-errors-test
Sheet: 2

PL | Plan | 10 | Generic Project plan for outsourcing |  | PL |  | Plan |  |  | Project start > |  |  | Project start |  |  |  |  |  |  | 2012-01-01 00:00:00
DE | Design | 11 |  |  | DE |  | Design |  |  | Today > |  |  | Today
PR | Process | 12 |  |  | PR |  | Process |  |  | Date > |  |  | Week Number |  |  |  |  |  |  | 4
VA | Validate | 13 |  |  | VA |  | Validate |  |  | Week >
 |  |  | # | Task | Phase | Task Code | Task Type | Task code2 | Start date | Start | Duration Wks | End
 |  |  |  |  |  |  |  |  |  |  | Current week
 |  |  | 1 | Project Scope | PL |  | 1 |  |  |  | 1
 |  |  | 2 | Validate annual volumes & product variation | PL |  | 1 |  | 2012-01-01 00:00:00 |  | 1
 |  |  | 3 | Get BOM's excel format | PL |  | 0 |  | 2012-01-01 00:00:00 |  | 1
 |  |  | 4 | Opportunity to standardise & rationalise | PL |  | 1 |  | 2012-02-01 00:00:00 |  | 3
 |  |  | 5 | Compare BOM's using pivot table | PL |  | 1 |  | 2012-01-01 00:00:00 |  | 1
 |  |  | 6 | Top level assy drawings for review | PL |  | 1 |  | 2012-01-01 00:00:00 |  | 1
 |  |  | 7 | Top level manufacturing vision | PL |  | 1 |  | 2012-01-01 00:00:00 |  | 1
 |  |  | 8 | Discuss / review  top level bom structure / supplier selection with ME's & team leaders | PL |  | 1 |  | 2012-01-01 00:00:00 |  | 1
 |  |  | 9 | Present top level bom structure to ME's & team leaders | PL |  | 1 |  | 2012-01-01 00:00:00 |  | 1
 |  |  | 10 | Supply chain logistics | PL |  | 1 |  | 2012-01-01 00:00:00 |  | 1
 |  |  | 11 | Map supply chain for risk | PL |  | 1 |  | 2012-01-01 00:00:00 |  | 1
 |  |  | 12 | Understand current typical ordering schedules | PL |  | 1 |  | 2012-01-01 00:00:00 |  | 1
 |  |  | 13 | Cost driver & technical risk analysis | PL |  | 1 |  | 2012-01-01 00:00:00 |  | 1
 |  |  | 14 | Cost :-Detailed costed bom analysis | PL |  | 1 |  | 2012-01-01 00:00:00 |  | 1
 |  |  | 15 | Identify price breaks | PL |  | 1 |  | 2012-01-01 00:00:00 |  | 1
 |  |  | 16 | Pareto cost drivers | PL |  | 1 |  | 2012-01-01 00:00:00 |  | 1
 |  |  | 17 | Identify freight | PL |  | 1 |  | 2012-01-01 00:00:00 |  | 1
 |  |  | 18 | Other costs? U/S cleaning | PL |  | 1 |  | 2012-01-01 00:00:00 |  | 1
 |  |  | 19 | Labour & overhead | PL |  | 1 |  | 2012-01-01 00:00:00 |  | 1
 |  |  | 20 | Establish cost target for prospective supplier | PL |  | 1 |  | 2012-01-01 00:00:00 |  | 9
 |  |  | 21 | Technical :- | PL |  | 1 |  | 2012-01-01 00:00:00 |  | 1
 |  |  | 22 | Identify process & assy critical items | PL |  | 1 |  | 2012-01-01 00:00:00 |  | 1
 |  |  | 23 | Obtain component level drawings & check content | PL |  | 1 |  | 2012-01-01 00:00:00 |  | 1
 |  |  | 24 | Check for assy/design DFMEA | PL |  | 1 |  | 2012-01-01 00:00:00 |  | 1
 |  |  | 25 | Check assy build issues in project log | PL |  | 1 |  | 2012-01-01 00:00:00 |  | 1
 |  |  | 26 | Check for RTV's | PL |  | 1 |  | 2012-01-01 00:00:00 |  | 1
 |  |  | 27 | ECR & ECO review (past & current) | PL |  | 1 |  | 2012-02-15 00:00:00 |  | 1
 |  |  | 28 | WI's and care-points | PL |  | 1 |  | 2012-01-01 00:00:00 |  | 1
 |  |  | 29 | FAI submissions | PL |  | 1 |  | 2012-01-01 00:00:00 |  | 1
 |  |  | 30 | Review material spec standards | PL |  | 1 |  | 2012-01-01 00:00:00 |  | 1
 |  |  | 31 | review PSW requirements | PL |  | 1 |  | 2012-01-01 00:00:00 |  | 1
 |  |  | 32 | draft validation plan for key components | PL |  | 1 |  | 2012-01-01 00:00:00 |  | 1
 |  |  | 33 | Supplier Analysis | PL |  | 1 |  | 2012-01-01 00:00:00 |  | 1
 |  |  | 34 | Identify if NDA is required / in place | PL |  | 1 |  | 2012-01-01 00:00:00 |  | 1
 |  |  | 35 | Compare supplier capability and vertical integration to BOM from previous history | PL |  | 1 |  | 2012-01-01 00:00:00 |  | 1
 |  |  | 36 | Supplier key skills matrix - compare to bom components (threshold?) | PL |  | 1 |  | 2012-01-01 00:00:00 |  | 1
 |  |  | 37 | Select suppliers for RFQ - Assy & technical risk items | PL |  | 1 |  | 2012-01-01 00:00:00 |  | 1
 |  |  | 38 | Inform supplier of impending RFQ & timing expectations - supplier resource allocation | PL |  | 1 |  | 2012-01-01 00:00:00 |  | 1
 |  |  | 39 | 2 streams - Risk drivers & balance of bom | PL |  | 1 |  | 2012-01-01 00:00:00 |  | 1
 |  |  | 40 | Risk register creation | PL |  | 1 |  | 2012-01-01 00:00:00 |  | 1
 |  |  | 41 | Select priority components for initial RFQ check point | PL |  | 1 |  | 2012-01-01 00:00:00 |  | 1
 |  |  | 42 | Data Pack preparation | PL |  | 1 |  | 2012-01-01 00:00:00 |  | 1
 |  |  | 43 | Export control | PL |  | 1 |  | 2012-01-01 00:00:00 |  | 1
 |  |  | 44 | 2 bom's - priority/others | PL |  | 1 |  | 2012-01-01 00:00:00 |  | 1
 |  |  | 45 | As per standard format + PSW requirements | PL |  | 1 |  | 2012-01-01 00:00:00 |  | 1
 |  |  | 46 | RFQ Creation and issue | PL |  | 1 |  | 2012-01-01 00:00:00 |  | 1
 |  |  | 47 | Create RFQ document (NRE template) | PL |  | 1 |  | 2012-01-01 00:00:00 |  | 1
 |  |  | 48 | Issue to supplier via FTP site | PL |  | 1 |  | 2012-01-01 00:00:00 |  | 10
 |  |  | 49 | Supplier confirmation of RFQ receipt | PL |  | 1 |  | 2012-03-15 00:00:00 |  | 1
 |  |  | 50 | Follow up with supplier to convey expectations and understanding | PL |  | 1 |  | 2012-01-01 00:00:00 |  | 1
 |  |  | 51 | Agree review schedule (3, 5, 8 days?) | PL |  | 1 |  | 2012-01-01 00:00:00 |  | 1
 |  |  | 52 | Milestone progress review1 | PL |  | 1 |  | 2012-01-01 00:00:00 |  | 1
 |  |  | 53 | Milestone progress review2 | PL |  | 1 |  | 2012-01-01 00:00:00 |  | 1
 |  |  | 54 | Milestone progress review3 | PL |  | 1 |  | 2012-01-01 00:00:00 |  | 1
 |  |  | 55 | 2 weeks for risk items | PL |  | 1 |  | 2012-01-01 00:00:00 |  | 1
 |  |  | 56 | 2 weeks balance of bom | PL |  | 1 |  | 2012-01-01 00:00:00 |  | 1
 |  |  | 57 | Sprint Items | PL |  | 1 |  | 2012-01-01 00:00:00 |  | 1
 |  |  | 58 | MVB | PL |  | 1 |  | 2012-01-01 00:00:00 |  | 1
 |  |  | 59 | Receive quote for risk/sprint items | PL |  | 1 |  | 2012-01-01 00:00:00 |  | 1
 |  |  | 60 | Review quoted materials and standards | PL |  | 1 |  | 2012-01-01 00:00:00 |  | 1
 |  |  | 61 | Review costs against OIPT targets | PL |  | 1 |  | 2012-01-01 00:00:00 |  | 1
 |  |  | 62 | Review NRE | PL |  | 1 |  | 2012-01-01 00:00:00 |  | 1
 |  |  | 63 | Review Freight | PL |  | 1 |  | 2012-01-01 00:00:00 |  | 1
 |  |  | 64 | Review draft control plan/PFMEA's and Manufacturing process | PL |  | 1 |  | 2012-01-01 00:00:00 |  | 1
 |  |  | 65 | Review part delivery schedules | PL |  | 1 |  | 2012-01-01 00:00:00 |  | 1
 |  |  | 66 | Assembly supplier to continue developing full assy quote | PL |  | 1 |  | 2012-01-01 00:00:00 |  | 1
 |  |  | 67 | Summarise for PM/Exec. Decision: Sprint items: Assy items | PL |  | 1 |  | 2012-01-01 00:00:00 |  | 1
 |  |  | 68 | MVB milestone/decision on Sprint | PL |  | 1 |  | 2012-01-01 00:00:00 |  | 1
 |  |  | 69 | Techinical Risk/Sprint parts | PL |  | 1 |  | 2012-01-01 00:00:00 |  | 1
 |  |  | 70 | Order commitment for Sprint items(Material and tooling) | PL |  | 1 |  | 2012-01-01 00:00:00 |  | 1
 |  |  | 71 | Develop PFMEA/Control plan/Process flow charts/Part inspection std(PIS); for Sprint | PL |  | 1 |  | 2012-01-01 00:00:00 |  | 10
 |  |  | 72 | [NAME] validation plan (PV test) | PL |  | 1 |  | 2012-01-01 00:00:00 |  | 1
 |  |  | 73 | Finalise FAI/PSW submission requirements | PL |  | 1 |  | 2012-01-01 00:00:00 |  | 1
 |  |  | 74 | Tool development (TBD) | PL |  | 1 |  | 2012-01-01 00:00:00 |  | 1
 |  |  | 75 | Material order ([NAME]) | PL |  | 1 |  | 2012-01-01 00:00:00 |  | 1
 |  |  | 76 | Material Procurement (TBD) | PL |  | 1 |  | 2012-01-01 00:00:00 |  | 1
 |  |  | 77 | Part manufacture(TBD) | PL |  | 1 |  | 2012-01-01 00:00:00 |  | 1
 |  |  | 78 | Part measurement (Supplier) | PL |  | 1 |  | 2012-01-01 00:00:00 |  | 1
 |  |  | 79 | SDS/Part dimension review against PIS (both) | PL |  | 1 |  | 2012-01-01 00:00:00 |  | 1
 |  |  | 80 | Part shipment | PL |  | 1 |  | 2012-01-01 00:00:00 |  | 1
 |  |  | 81 | Receive FAI | PL |  | 1 |  | 2012-01-01 00:00:00 |  | 1
 |  |  | 82 | FAI dimensional and Visual approval | PL |  | 1 |  | 2012-01-01 00:00:00 |  | 1
 |  |  | 83 | (TBR)Part validation | PL |  | 1 |  | 2012-01-01 00:00:00 |  | 1
 |  |  | 84 | Mass Production order for sprint/technical parts | PL |  | 1 |  | 2012-01-01 00:00:00 |  | 1
 |  |  | 85 | Top level assy | PL |  | 1 |  | 2012-01-01 00:00:00 |  | 1
 |  |  | 86 | MVB | PL |  | 1 |  | 2012-01-01 00:00:00 |  | 1
 |  |  | 87 | Receive quote for entire assy. | PL |  | 1 |  | 2012-01-01 00:00:00 |  | 1
 |  |  | 88 | Review quoted materials and standards | PL |  | 1 |  | 2012-01-01 00:00:00 |  | 1
 |  |  | 89 | Review costs against OIPT targets | PL |  | 1 |  | 2012-01-01 00:00:00 |  | 1
 |  |  | 90 | Review NRE | PL |  | 1 |  | 2012-01-01 00:00:00 |  | 1
 |  |  | 91 | Review Freight | PL |  | 1 |  | 2012-01-01 00:00:00 |  | 1
 |  |  | 92 | Review draft control plan/PFMEA's and Manufacturing process | PL |  | 1 |  | 2012-01-01 00:00:00 |  | 1
 |  |  | 93 | Review part delivery schedules | PL |  | 1 |  | 2012-01-01 00:00:00 |  | 1
 |  |  | 94 | Negotiation | PL |  | 1 |  | 2012-01-01 00:00:00 |  | 1
 |  |  | 95 | Receive quote for entire assy. | PL |  | 1 |  | 2012-01-01 00:00:00 |  | 1
 |  |  | 96 | Review quoted materials and standards | PL |  | 1 |  | 2012-01-01 00:00:00 |  | 1
 |  |  | 97 | Review costs against OIPT targets | PL |  | 1 |  | 2012-01-01 00:00:00 |  | 1
 |  |  | 98 | Review NRE | PL |  | 1 |  | 2012-01-01 00:00:00 |  | 1
 |  |  | 99 | Review Freight | PL |  | 1 |  | 2012-01-01 00:00:00 |  | 1
 |  |  | 100 | Review draft control plan/PFMEA's and Manufacturing process | PL |  | 1 |  | 2012-01-01 00:00:00 |  | 1
 |  |  | 101 | Review part delivery schedules | PL |  | 1 |  | 2012-01-01 00:00:00 |  | 1
 |  |  | 102 | Summarise for PM/Exec. Decision:Assy | PL |  | 1 |  | 2012-01-01 00:00:00 |  | 1
 |  |  | 103 | OIPT Order commitment for [NAME] items(Material and tooling) | PL |  | 1 |  | 2012-01-01 00:00:00 |  | 1
 |  |  | 104 | Communicate intended supply chain map to assy partner/develop sub tier relationships (technical parts) | PL |  | 1 |  | 2012-01-01 00:00:00 |  | 1
 |  |  | 105 | Manufacture | PL |  | 1 |  | 2012-01-01 00:00:00 |  | 1
 |  |  | 106 | Supplier training at OIPT | PL |  | 1 |  | 2012-01-01 00:00:00 |  | 1
 |  |  | 107 | Develop PFMEA/Control plan/Process flow charts/Part inspection std(PIS); for Assembly | PL |  | 1 |  | 2012-01-01 00:00:00 |  | 1
 |  |  | 108 | [NAME] validation plan (PV test) | PL |  | 1 |  | 2012-01-01 00:00:00 |  | 1
 |  |  | 109 | Finalise FAI/PSW submission requirements | PL |  | 1 |  | 2012-01-01 00:00:00 |  | 1
 |  |  | 110 | Tool development | PL |  | 1 |  | 2012-01-01 00:00:00 |  | 1
 |  |  | 111 | Series production Packaging development | PL |  | 1 |  | 2012-01-01 00:00:00 |  | 1
 |  |  | 112 | Supplier material order | PL |  | 1 |  | 2012-01-01 00:00:00 |  | 1
 |  |  | 113 | Material Procurement | PL |  | 1 |  | 2012-01-01 00:00:00 |  | 1
 |  |  | 114 | FAI Assembly | PL |  | 1 |  | 2012-01-01 00:00:00 |  | 1
 |  |  | 115 | Validation of Assembly | PL |  | 1 |  | 2012-01-01 00:00:00 |  | 1
 |  |  | 116 | Part measurement (Supplier) | PL |  | 1 |  | 2012-01-01 00:00:00 |  | 1
 |  |  | 117 | SDS/Part dimension review against PIS (both) | PL |  | 1 |  | 2012-01-01 00:00:00 |  | 1
 |  |  | 118 | Part shipment | PL |  | 1 |  | 2012-01-01 00:00:00 |  | 1
 |  |  | 119 | Receive FAI | PL |  | 1 |  | 2012-01-01 00:00:00 |  | 1
 |  |  | 120 | FAI dimensional and Visual approval | PL |  | 1 |  | 2012-01-01 00:00:00 |  | 1
 |  |  | 121 | (TBR)Part validation | PL |  | 1 |  | 2012-01-01 00:00:00 |  | 1
 |  |  | 122 | Full FAI approval | PL |  | 1 |  | 2012-01-01 00:00:00 |  | 1
 |  |  | 123 | Mass production preparation | PL |  | 1 |  | 2012-01-01 00:00:00 |  | 1
 |  |  | 124 | Mass Production order | PL |  | 1 |  | 2012-01-01 00:00:00 |  | 1
 |  |  | 125 | Handover Technical risk parts from 2nd tier to first tier [NAME] supplier | PL |  | 1 |  | 2012-01-01 00:00:00 |  | 1
 |  |  | 126 | Develop Phase in/Phase out plan for existing/new stock | PL |  | 1 |  | 2012-01-01 00:00:00 |  | 1