Spreadsheet: 213990d1360720437-summing-value-on-a-column-in-multiple-criterias-in-multiple-sheet-poc-sample-data
Sheet: MDL (Live)

 | PROJECT: BO-660
 | MASTER DRAWING & DOCUMENT LIST |  |  |  |  |  | Engineering Design Centre |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ST Marine Ltd
 | As of: | 41318 |  |  | Projection | 0 | Master Drawing List and Planned Schedule |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A company of ST Engineering
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OWNER |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  | CLASSIFICATION SOCIETY |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  | PCF RECEIVED & REPLIED |  |  |  |  |  |  |  |  |  |  |  |  |  | STM PRODUCTION |  |  |  |  |  |  |  |  |  |  | [NAME] |  | DRAWING COUNT |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Planning & Control
 | S/No | Dept | System No. | PROJ NO. / DOC NO. |  | Superseded (SS) | TITLE DESCRIPTION | Design | Drawn By | Designed By | Checked By | Approved By | EDC Planned Date to | EDC Planned Date to | PDR / CDR | Size of Drawing | Type of Drawing |  | Require to Send Owner | Plan Send to | Actual Send to | Owner Date Approval | Actual Send to | Owner Date Approval | Actual Send to | Owner Date Approval | Actual Send to | Owner Date Approval | Actual Send to | Owner Date Approval | Actual Send to | Owner Date Approval |  |  | Require to Send Class | Plan Send to | Actual Send to | Class Date Approval | Class Status | Actual Send to | Class Date Approval | Class Status | Actual Send to | Class Date Approval | Class Status | Actual Send to | Class Date Approval | Class Status |  |  | PCF received from (0) | PCF replied to (1) | PCF received from (2) | PCF replied to (3) | PCF received from (4) | PCF replied to (5) | PCF received from (6) | PCF replied to (7) | PCF received from (8) | PCF Open | PCF Closed | PCF Closed for verification | Comments |  | Require              to Send          Prod | Plan Dates to Prod | New Date (8 Jan 2013) | [NAME] | Send (Prelimary)/ info | Send Working |  |  |  |  |  |  |  | Owner Submitted | Owner Overdue | Class Submitted | Class Overdue | PROD Submitted | PROD Overdue | Recovery Plan for Class & Owner |  | Require for NSD | Issued | P(R0) | P (R1) | P(R2) | P(R3) |  | W(R0) | W(R1) | W(R2) | W(R3) |  | Required | Plan Owner | Plan Class | Plan Prod | Plan Min | A2E Factor
 |  |  |  |  |  |  |  | PIC |  |  |  |  | Start | Finish |  |  |  |  |  | Owner | Owner |  | Owner |  | Owner |  | Owner |  | Owner |  | Owner |  |  |  |  | Class | Class |  |  | Class |  |  | Class |  |  | Class
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | R0 | R0 | R1 | R1 | R2 | R2 | R3 | R3 | R4 | R4 | R5 | R5 |  |  |  |  | R0 | R0 |  | R1 | R1 |  | R2 | R2 |  | R3 | R3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | R0 | R1 | R2 | R3 | R4 | R5
 |  |  |  |  |  |  | Hull
 | 1 | H | 802-1 | 660 - 663 | 802-1.01-01 |  | General Arrangement | Bi Min | [NAME] | [NAME] | [NAME] | [NAME] |  | 41087 | PDR | A0 | Basic |  | 1 | 41117 | 41093 |  | 41148 |  | 41173 |  |  |  |  |  |  |  | 0 |  | 1 | 41117 | 41093 |  |  | 41148 | 41156 | Review | 41173 | Reviewed |  |  |  |  | 0 |  | 41166 | 41173 | 41201 |  |  |  |  |  |  | 1 |  |  | 8 |  | 1 | 41299 | 41285 | 0 |  |  |  |  |  |  |  | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 2012-07-27 00:00:00 | 2012-07-27 00:00:00 | 1900-01-01 00:00:00 | 2012-07-27 00:00:00 | 4
 | 2 | H | 801-1 | 660 - 663 | 801-1.01-01 |  | Lines Plan | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] |  | 41075 | PDR | A2 | [NAME] |  | 1 | 41105 | 41075 | Nil |  |  |  |  |  |  |  |  |  |  | 41173 |  | 1 | 41105 | 41075 | 41156 | File for Ref |  |  |  |  |  |  |  |  |  | 41173 |  | 41102 |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  | 41285 |  |  |  |  |  |  |  | 0 |  | 0 | 1 | 0 | 1 | 0 | 1 |  |  | 1 | 1 | 41195 |  |  |  |  |  |  |  |  |  | 1 | 2012-07-15 00:00:00 | 2012-07-15 00:00:00 | 2013-01-11 00:00:00 | 2012-07-15 00:00:00 | 1
 | 3 | H | 835-2 | 660 - 663 | 835-2.03-01 |  | Calculation - Weight And CG | Jang | All | All | [NAME] | [NAME] |  | 41087 | PDR | A2 | Basic |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 41075 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 41075 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  | 1 | 1 | 1 | 1 | 0 | 0 |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  | 0 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1
 | 4 | H | 051-1 | 660 - 663 | 051-1.40-01 |  | Resistance, Speed, Power Prediction | Jang | Jang | Jang | [NAME] | [NAME] | 41051 | 41131 | PDR | A2 | Basic |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  | 0 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1
 | 5 | H | 098-1 | 660 - 663 | 098-1.40-01 |  | Analysis - Sea Keeping | Jang | Jang | Jang | [NAME] | [NAME] | 41198 | 41201 | CDR | A2 | Basic |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  | 0 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1
 | 6 | H | 098-1 | 660 - 663 | 098-1.40-02 |  | Analysis - Manuevring | Jang | Jang | Jang | [NAME] | [NAME] | 41198 | 41201 | CDR | A2 | Basic |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  | 0 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1
 | 7 | H | 098-1 | 660 - 663 | 098-1.40-03 |  | Model Test Specification | Jang | Jang | Jang | [NAME] | [NAME] | 41086 | 41089 | PDR | A2 | Basic |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1
 | 8 | H | 098-1 | 660 - 663 | 098-1.40-04 |  | CFD For Helideck | Jang | Jang | Jang | [NAME] | [NAME] | 41116 | 41119 | CDR | A2 | Basic |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1
 | 9 | H | 098-1 | 660 - 663 | 098-1.40-05 |  | Wind Tunnel Tests | Jang | Jang | Jang | [NAME] | [NAME] | 41191 | 41194 | CDR | A2 | Basic |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1
 | 10 | H | 098-1 | 660 - 663 | 098-1.03-01 |  | Calculation - Bow Thruster Sizing (Limiting Wind Conditions) | Jang | Jang | Jang | [NAME] | [NAME] |  | 41117 | PDR | A2 | Basic |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1
 | 11 | H | 098-1 | 660 - 663 | 098-1.03-02 |  | Propeller Cavitations Test | Jang | Jang | Jang | [NAME] | [NAME] | 41268 | 41271 | CDR | A2 | Basic |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1
 | 12 | H | 835-2 | 660 - 663 | 835-2.03-02 |  | Calculation - Intact Stability Preliminary Intact Stability Calculation (Including Longitudinal Strength) | Jang | Jang | Jang | [NAME] | [NAME] | 41091 | 41096 | PDR | A2 | Basic |  | 1 | 41126 | 41136 |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 1 | 41126 | 41136 | 41229 | Reviewed |  |  |  |  |  |  |  |  |  | 0 |  | 41159 |  |  |  |  |  |  |  |  |  |  | 1 | 2 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 1 | 1 | 41195 |  |  |  |  |  |  |  |  |  | 1 | 2012-08-05 00:00:00 | 2012-08-05 00:00:00 | 1900-01-01 00:00:00 | 2012-08-05 00:00:00 | 1
 | 13 | H | 835-2 | 660 - 663 | 835-2.03-03 |  | Calculation - Damage Stability Preliminary Damage Stability Calculation | Jang | Jang | Jang | [NAME] | [NAME] | 41098 | 41103 | PDR | A2 | Basic |  | 1 | 41133 | 41136 |  |  |  |  |  |  |  |  |  |  |  | 41136 |  | 1 | 41133 | 41136 | 41260 | resubmission required |  |  |  |  |  |  |  |  |  | 41136 |  | 41159 |  |  |  |  |  |  |  |  | 1 |  |  | 2 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  | 0 | 1 | 0 | 1 | 0 | 0 |  |  | 1 | 1 | 41195 |  |  |  |  |  |  |  |  |  | 1 | 2012-08-12 00:00:00 | 2012-08-12 00:00:00 | 1900-01-01 00:00:00 | 2012-08-12 00:00:00 | 1
 | 14 | H | 835-2 | 660 - 663 | 835-2.03-04 |  | Hydrostatics | Jang | Jang | Jang | [NAME] | [NAME] |  | 41110 | PDR | A2 | Basic |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 41136 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 41136 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  | 1 | 1 | 1 | 1 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1
1 |  | H | 835-2 | 660-663 | 835-2.03-05 |  | [NAME] |  |  |  |  |  |  |  |  | A2 | Basic |  | 1 | 41152 | 41152 |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 1 | 41152 | 41152 | 41206 | File for Ref |  |  |  |  |  |  |  |  |  | 0 |  | 41197 |  |  |  |  |  |  |  |  |  | 1 |  | 0 |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 2012-08-31 00:00:00 | 2012-08-31 00:00:00 | 1900-01-01 00:00:00 | 2012-08-31 00:00:00 | 1
 | 15 | H | 123-1 | 660 - 663 | 123-1.03-01 |  | Tank Capacity Plan | Jang | [NAME] | [NAME] | [NAME] | [NAME] |  | 41075 | PDR | A2 | Basic |  | 1 | 41105 | 41096 | Nil | 41148 |  |  |  |  |  |  |  |  |  | 41152 |  | 1 | 41105 | 41096 |  |  | 41148 | 41156 | File for Ref |  |  |  |  |  |  | 41152 |  | 41108 | 41148 | 41158 |  |  |  |  |  |  |  | 1 |  | 0 |  | 1 | 41299 | 41285 | 0 |  |  |  |  |  |  |  | 0 |  | 0 | 1 | 0 | 1 | 0 | 0 |  |  | 1 |  |  | 41195 |  |  |  |  |  |  |  |  | 1 | 2012-07-15 00:00:00 | 2012-07-15 00:00:00 | 1900-01-01 00:00:00 | 2012-07-15 00:00:00 | 1
 | 16 | H | 123-1 | 660 - 663 | 123-1.03-02 |  | Tank Sounding Table | Jang | Jang | Jang | [NAME] | [NAME] |  | 41205 |  | A2 | Basic |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 41148 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 41148 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 41285 |  |  |  |  |  |  |  | 0 |  | 1 | 1 | 1 | 1 | 0 | 1 |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  | 0 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 2013-01-11 00:00:00 | 2013-01-11 00:00:00 | 1
 | 17 | H | 835-1 | 660 - 663 | 835-1.03-01 |  | Structural Design Loads | Shuchan | Shuchan | Shuchan | [NAME] | [NAME] | 41046 | 41051 | PDR | A2 | Basic |  | info |  | Nil | Nil | 41127 |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Internal Use |  |  | 0 |  | 41080 |  |  |  |  |  | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1
 | 18 | H | 835-1 | 660 - 663 | 835-1.03-02 |  | Scantling Calculations - Main Hull | Shuchan | Shuchan | Shuchan | [NAME] | [NAME] | 41048 | 41053 | PDR | A2 | Basic |  | info |  | 41127 |  |  |  |  |  |  |  |  |  |  |  | 41127 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 41080 |  | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1
 | 19 | H | 835-1 | 660 - 663 | 835-1.03-03 |  | Scantling Calculations - Flight Deck | Shuchan | Shuchan | Shuchan | [NAME] | [NAME] | 41053 | 41058 | PDR | A2 | Basic |  | 1 |  | 41149 |  |  |  |  |  |  |  |  |  |  |  | 41127 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 41197 |  |  |  |  |  |  |  |  |  | 1 |  | 0 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1
 | 20 | H | 835-1 | 660 - 663 | 835-1.03-04 |  | Scantling Calculations - Super Structure | Shuchan | Shuchan | Shuchan | [NAME] | [NAME] | 41063 | 41068 | PDR | A2 | Basic |  | info |  | 41136 |  |  |  |  |  |  |  |  |  |  |  | 41149 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  | 1 | 1 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1
 | 21 | H | 835-1 | 660 - 663 | 835-1.03-05 |  | Scantling Calculations - Mast | Shuchan | Shuchan | Shuchan | [NAME] | [NAME] | 41098 | 41103 | PDR CDR | A2 | Basic |  | info |  | 41179 |  |  |  |  |  |  |  |  |  |  |  | 41136 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1