Spreadsheet: 755880d1637161662-problem-with-ifand-function-example-list
Sheet: Sheet1

 |  |  |  | Task Description | PRE-Contract | PDR | CDR | LUAR | FFAR | CFAR | FAI | Program | Supply from UK ,  [NAME] or C | Drawing / Drafting | Check | Release | Total Hours | Cost | Comments | Deliverable
 |  | - | 001 | Pre-Contract Work, Feasibility Study |  |  | Y |  |  |  |  | Y |  |  |  |  |  |  |  | Y
 |  | - | 002 | Initial Design Read In |  |  | Y |  |  |  |  |  |  |  |  |  |  |  |  | Y
 |  | - | 003 | Technical Requirements/Supplier Equipment (SES/TRD) |  |  | Y
 |  | - | 004 | Kick off Meeting (KoM) |  |  | Y
 |  | - | 005 | Weight Report (WR) |  |  | Y
 |  | - | 006 | Configuration Index Document (CID) |  | Y | Y |  |  | Y
 |  | - | 007 | Design (3D) drawings |  |  | Y
 |  | - | 008 | Failure Modes and Effects Analysis / Summary FMEA (FMES) |  |  | Y | Y
 |  | - | 009 | Safety & Reliability Plan (S&RP) |  |  | Y |  |  |  | Y
 |  | - | 010 | Qualification Plan (QP) |  |  | Y
 |  | - | 011 | 2D drawings |  |  | Y |  | Y
 |  | - | 012 | Stress Analysis (SA) |  |  | Y
 |  | - | 013 | Interface Load Report (ILR) |  |  | Y
 |  | - | 014 | Supplier Development Plan (SDP) |  |  | Y
 |  | - | 015 | Prepare for Initial Design Review (PIDR) |  |  | Y
 |  | - | 016 | Design Failure, Modes and Effects Analysis (FMEA) | Y |  | Y
 |  | - | 017 | 3D Models Q Checking |  |  | Y
 |  | - | 018 | Design Baseline List |  |  | Y
 |  | - | 019 | Preliminary Design Review (PDR) - Preparation |  |  | Y
 |  | - | 020 | Preliminary Design Review (PDR) meeting |  |  | Y
 |  | - | 021 | Preliminary Design Review (PDR) - Meeting Minutes |  |  | Y
 |  | - | 022 | Qualification Testing |  |  | Y
 |  | - | 023 | Miscellaneous Test Reports (MTR's) |  |  | Y
 |  | - | 024 | Update Mass Analysis |  |  | Y
 |  | - | 025 | Materials & Process List (MPL) |  |  | Y
 |  | - | 026 | Reliability Report (RR) |  |  | Y
 |  | - | 027 | Material Technical Data Sheet (MTDS) |  |  | Y
 |  | - | 028 | Qualification Test Procedure (QTP) |  |  | Y
 |  | - | 029 | Component Design Dossier (CDD) |  |  | Y
 |  | - | 030 | Additional Attachment Structure Documents (AASD) |  |  | Y
 |  | - | 031 | Maintainability and [NAME] (MME) |  |  | Y
 |  | - | 032 | Critical Design Review (CDR) - Preparation |  |  | Y
 |  | - | 033 | Critical Design Review (CDR) meeting |  |  | Y
 |  | - | 034 | Critical Design review (CDR) - Mtg Minutes |  |  | Y
 |  | - | 035 | Trials Order for Fire, Smoke and Toxicity (FST) |  |  | Y
 |  | - | 036 | Design Checking/Test Frame |  |  | Y
 |  | - | 037 | Acceptance Test Procedure (ATP) |  |  | Y
 |  | - | 038 | Acceptance Test Report (ATR) |  |  | Y
 |  | - | 039 | Manufacture Prototype |  |  | Y
 |  | - | 040 | Environmental Test Frame Drawings |  |  | Y
 |  | - | 041 | Load Testing |  |  | Y
 |  | - | 042 | Full Scale Test (FST) time |  |  | Y
 |  | - | 043 | Cyclic Testing |  |  | Y
 |  | - | 044 | Lab Unit Acceptance Review (LUAR) |  |  | Y
 |  | - | 045 | Equipment Maintainability Dossier (EMD) |  |  | Y
 |  | - | 046 | Interface Control Document (ICD) |  |  | Y
 |  | - | 047 | Installation document (ID) |  |  | Y
 |  | - | 048 | Fire, Smoke and Toxicity (FST) Report |  |  | Y
 |  | - | 049 | Correlation Report |  |  | Y
 |  | - | 050 | Compliance Record/Report (CR) |  |  | Y
 |  | - | 051 | Qualification Test Report (QTR) |  |  | Y
 |  | - | 052 | Declaration of Design and Performance (DDP) |  |  | Y
 |  | - | 053 | Data Modules (IPL/CMM) |  |  | Y
 |  | - | 054 | [NAME] |  |  | Y
 |  | - | 055 | Certification Review Meeting (CRM) |  |  | Y
 |  | - | 056 | Justification Report (JR) |  |  | Y
 |  | - | 057 | Handling, Installation and Removal Instructions (HIRI) |  |  | Y
 |  | - | 058 | Certification Final Acceptance Review (CFAR) |  |  | Y
 |  | - | 059 | Mfr 1st article |  |  | Y
 |  | - | 060 | Support to Production (First of type) |  |  | Y
 |  | - | 061 | First Article Inspection (FAI) meeting |  |  | Y
 |  | - | 062 | Packing Process |  |  | Y
 |  | - | 063 | Administration |  |  | Y
 |  | - | 064 | [NAME] (ASB) Progress Meetings |  |  | Y
 |  | - | 065 | [NAME] (ASB) review meetings/admin |  |  | Y
 |  | - | 066 | Programme Management |  |  | Y
 |  | - | 067 | Supplier workshops |  |  | Y
 |  | - | 068 | Quality Assurance Plan (QAP) |  |  | Y
 |  | - | 069 | Plans Review (PR) |  |  | Y
 |  | - | 070 | Certified Equipment Minimum List (CEML) |  |  | Y
 |  | - | 071 | conformities |  |  | Y
 |  | - | 072 | contingency |  |  | Y
 |  | - | 073 | REWORK  / SPARES ACTIVITY - (Drgs etc) |  |  | Y
 |  | - | 074 | FAI - Customer Sign Off /Acceptance |  |  | Y
 |  | - | 075 |  |  |  | Y
 |  | - | 076 |  |  |  | Y
 |  | - | 077 |  |  |  | Y
 |  | - | 078 |  |  |  | Y
 |  | - | 079 |  |  |  | Y
 |  | - | 080 | NB - Production Readiness Review (PRR) priort o [NAME] |  |  | Y
 |  |  |  | Sum Total
 |  |  | Additional Costs
 |  |  | E | Task Description | PRE-Contract | PDR | CDR | LUAR | FFAR | CFAR | FAI | Program | MoSCOW | Supply from | Unit Cost (£) |  |  |  |  |  | [NAME] | Comments
 |  | - | 111 | Industrial Quality Dossier IQD |  |  |  |  |  | Y |  |  | M
 |  | - | 112 | Product Assurance Plan PAP |  |  |  | Y |  |  |  |  | M
 |  | - | 113 | Vendor [NAME] |  |  |  | Y |  |  |  |  | M
 |  | - | 114 | Product Delivery Documentation |  |  |  |  |  |  | Y |  | M
 |  | - | 115 | Supplier Chain Dossier SCD |  | Y | Y |  |  |  |  |  | M
 |  | - | 116 | Travel[1] (Flights/Subsistence/Hotels etc) |  |  |  |  |  |  |  |  | M
 |  | - | 117 | Travel[2] |  |  |  |  |  |  |  |  | M
 |  | - | 118 | Capital Investment |  |  |  |  |  |  |  |  | M
 |  | - | 119 | Prototype(s) |  |  |  | Y |  |  |  |  | M
 |  | - | 120 | Rapid Prototypes |  |  | Y | Y |  |  |  |  | M
 |  | - | 121 | Free ship sets @ cost |  |  |  |  |  |  |  |  | M
 |  | - | 122 |  |  |  |  |  |  |  |  |  | M
 |  | - | 123 |  |  |  |  |  |  |  |  |  | M
 |  | - | 124 |  |  |  |  |  |  |  |  |  | M
 |  | - | 125 |  |  |  |  |  |  |  |  |  | M
 |  | - | 126 |  |  |  |  |  |  |  |  |  | M
 |  | - | 127 |  |  |  |  |  |  |  |  |  | M
 |  | - | 128 |  |  |  |  |  |  |  |  |  | M
 |  | - | 129 |  |  |  |  |  |  |  |  |  | M
 |  | - | 130 |  |  |  |  |  |  |  |  |  | M
 |  | - | 131 |  |  |  |  |  |  |  |  |  | M
 |  | - | 132 |  |  |  |  |  |  |  |  |  | M
 |  | - | 133 |  |  |  |  |  |  |  |  |  | M
 |  | - | 134 |  |  |  |  |  |  |  |  |  | M
 |  | - | 135 |  |  |  |  |  |  |  |  |  | M
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total
 |  |  | RISKS
 |  |  | F | RISKS, unknowns and uncertainties | PRE-Contract | PDR | CDR | LUAR |  | CFAR | FAI | Program |  |  | [NAME] |  |  |  |  |  | Confidence  (H, M or L)
 |  | - | 136 | Technology |  |  |  |  |  |  |  |  |  |  | New / Unknown Technology
 |  | - | 137 | Processes |  |  |  |  |  |  |  |  |  |  | New undefined process requirements
 |  | - | 138 | Availability of sub-contracted items |  |  |  |  |  |  |  |  |  |  | Risk of supply
 |  | - | 139 | Knowledge of stds |  |  |  |  |  |  |  |  |  |  | Are we familiar with the standards we are to work to
 |  | - | 140 | [NAME] set |  |  |  |  |  |  |  |  |  |  | Are the required skills readily available
 |  | - | 141 | Materials |  |  |  |  |  |  |  |  |  |  | Are the materials within current capability of manufacture / supply
 |  | - | 142
 |  | - | 143
 |  |  | ASSUMPTIONS
 |  |  | G | [NAME]
 |  | - | 144
 |  | - | 145
 |  | - | 146
 |  | - | 147
 |  | - | 148
 |  | - | 149
 |  | - | 150
 |  | - | 151