{"text_format":"1","workbook":"xlsx","n_sheets":24,"sheets":["Mainsheet","Completed","Calc","Areaofobs","Vessel_type","Deficiency_type","VIQrefno","Equipment_list","PSC_MOU","Inspection_type","Deficiency_Cause","Observer_code","Status_code","PSC_ref_no","Risk_value_of_obs","Year","Month","Date_","Sheet1","Ship_information","External_Deficiency_type","External_Inspection_type","External_Observer_code","Sheet Version"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":12,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Mainsheet","index":0,"n_rows":42,"n_cols":28,"rows_kept":42,"cut":false,"hidden":false,"merged":[[10,8,10,9],[10,12,10,13],[12,6,12,27],[8,6,8,27]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Defect - Damage Monitoring Sheet"]
[]
[null,null,null,null,null,null,null,"Date of Report","29-Feb-2024",null,null,"Ship Name","VIKING ORCA (05-02-2024)"]
[]
[null,null,null,null,null,null,"VERSION : 2.0"]
[]
[]
[]
[null,null,null,"ID","SHIPSIDE UNIQUEID","UNIQUE ID","Date Recorded","Type of Deficiency","Observer code","Type of Inspection","Description of Deficiency","Equipment Categories","Area of Observation","Deficiency Cause","VIQ Ref Number","Risk Value of Obs","PSC Ref Number","PSC MOU ID","Action Taken or Required","Target Date","PO Ref No.","Status Code","Date Completed","Drydock","Info Sharing","Critical Item","Audit Type","Superintendent Remarks"]
[null,null,null,31428,76410,"0_Mon Aug 28 2023 17:41:52 GMT+0800","2023-07-08T23:59:35","Guarantee Claim","Ship Staff","Ship Staff Insp.","Daily bilge pump volume capacity decreased GC-013/Eng/2023","E/R - Pumps","Eng. / Strg. Comp.","Equipment Related","","","","","Replacement of stator GC-013/ENG/2023","2024-03-31T23:59:35","","In progress",null,"No","No","No","Internal","Awaiting GC from Yard - follow up in progress."]
[null,null,null,31085,72050,"133_Sat Aug 12 2023 18:59:19 GMT+0800","2023-07-09T23:59:35","Observation","Ship Staff","Ship Staff Insp.","DAMAGE RESTING PAD HC 2-S BAY 06 STBD. Mis handling of crane operator during cargo operation","Cargo Mach.,Deck - Pipe / Fittings","Structural Condn. / WT integrity ","External Factors","","","","","SDR issued target to repair by shore assistance Sept 2023","2024-03-31T23:59:35","SDR/003","Not Started",null,"No","No","No","Internal"]
[null,null,null,31086,60550,"133_Sat Aug 12 2023 19:53:09 GMT+0800","2023-07-12T23:59:35","Observation","Ship Staff","Ship Staff Insp.","DAMAGE PROJECTOR LIGHT POST & BRACKET ON CROSS BAY (BETWEEN BAY-18 & BAY-14 STBD SIDE). Mis handling of crane operator during cargo operation","Deck - Pipe / Fittings","Structural Condn. / WT integrity ","External Factors","","","","","SDR issued target to repair by shore assistance Sept 2023","2024-03-31T23:59:35","SDR/009","Not Started",null,"No","No","No","Internal"]
[null,null,null,31087,85133,"133_Sat Aug 12 2023 19:56:13 GMT+0800","2023-07-20T23:59:35","Observation","Ship Staff","Ship Staff Insp.","BEND CELL GUIDE BAY 30 BETWEEN ROW 01-ROW 02. Mis handling of crane operator during cargo operation","Deck - Pipe / Fittings","Structural Condn. / WT integrity ","External Factors","","","","","SDR issued target to repair by shore assistance Sept 2023","2024-03-31T23:59:35","SDR/010","Not Started",null,"No","No","No","Internal"]
[null,null,null,31623,13668,"133_Fri Sep 15 2023 21:46:42 GMT+0800","2023-07-23T23:59:35","Observation","Ship Staff","Ship Staff Insp.","DAMAGE CONTAINER SOCKET BAY-03 ROW 05 FORWARD  STARBOARD","Deck - Pipe / Fittings","Structural Condn. / WT integrity ","External Factors","","","","","To Repair by external work shop in coordination with charterer","2024-02-29T23:59:35","SDR/012","Not Started",null,"No","No","No","Internal"]
[null,null,null,31084,74346,"133_Sat Aug 12 2023 21:11:52 GMT+0800","2023-07-26T23:59:35","Observation","Ship Staff","Ship Staff Insp.","DAMAGE RESTING PAD HATCH COVER BAY 14 STBD SIDE. Mis handling of crane operator during cargo operation","Cargo Mach.,Deck - Pipe / Fittings","Structural Condn. / WT integrity ","External Factors","","","","","SDR issued target to repair by shore assistance Sept 2023","2024-02-29T23:59:35","SDR/020","Not Started",null,"No","No","No","Internal"]
[null,null,null,31092,18484,"133_Sat Aug 12 2023 21:13:07 GMT+0800","2023-07-26T23:59:35","Observation","Ship Staff","Ship Staff Insp.","BROKEN RUBBER PACKING HATCH COVER -BAY 30 CENTER AFT MID SECTION. Mis handling of crane operator during cargo operation","Deck - Pipe / Fittings","Structural Condn. / WT integrity ","External Factors","","","","","SDR issued target to repair by shore assistance Sept 2023","2024-02-29T23:59:35","SDR/021","Not Started",null,"No","No","No","Internal"]
[null,null,null,31624,75613,"133_Fri Sep 15 2023 21:50:29 GMT+0800","2023-07-26T23:59:35","Observation","Ship Staff","Ship Staff Insp.","BEND CELL GUIDE BAY 26 BETWEEN ROW 01 & ROW 03 AFT","Deck - Pipe / Fittings","Structural Condn. / WT integrity ","External Factors","","","","","To Repair by external work shop in coordination with charterer","2024-02-29T23:59:35","SDR/023","Not Started",null,"No","No","No","Internal"]
[null,null,null,31096,80728,"133_Sat Aug 12 2023 21:19:31 GMT+0800","2023-07-27T23:59:35","Observation","Ship Staff","Ship Staff Insp.","DAMAGE RESTING PAD HATCH COVER BAY 22 CENTER AFT. Mis handling of crane operator during cargo operation","Deck - Pipe / Fittings","Structural Condn. / WT integrity ","External Factors","","","","","SDR issued target to repair by shore assistance Sept 2023","2024-02-29T23:59:35","SDR/024","Not Started",null,"No","No","No","Internal"]
[null,null,null,31625,60258,"133_Fri Sep 15 2023 22:00:40 GMT+0800","2023-08-02T23:59:35","Observation","Ship Staff","Ship Staff Insp.","BEND CELL GUIDE BAY 22 BETWEEN ROW 08 & ROW 10 AFT","Deck - Pipe / Fittings","Structural Condn. / WT integrity ","External Factors","","","","","To Repair by external work shop in coordination with charterer","2024-02-29T23:59:35","SDR/026","Not Started",null,"No","No","No","Internal"]
[null,null,null,31626,51368,"133_Fri Sep 15 2023 22:03:43 GMT+0800","2023-08-02T23:59:35","Observation","Ship Staff","Ship Staff Insp.","BEND CELL GUIDE BAY 06 BETWEEN ROW 02 & ROW 04 AFT","Deck - Pipe / Fittings","Structural Condn. / WT integrity ","External Factors","","","","","To Repair by external work shop in coordination with charterer","2024-02-29T23:59:35","SDR/027","Not Started",null,"No","No","No","Internal"]
[null,null,null,31627,38947,"133_Fri Sep 15 2023 22:04:36 GMT+0800","2023-08-02T23:59:35","Observation","Ship Staff","Ship Staff Insp.","BEND CELL GUIDE BAY 06 BETWEEN ROW 01 & ROW 03 AFT","Deck - Pipe / Fittings","Structural Condn. / WT integrity ","External Factors","","","","","To Repair by external work shop in coordination with charterer","2024-02-29T23:59:35","SDR/028","Not Started",null,"No","No","No","Internal"]
[null,null,null,31433,93612,"0_Mon Aug 28 2023 17:51:01 GMT+0800","2023-08-08T23:59:35","Guarantee Claim","Ship Staff","Ship Staff Insp.","Leaking Y strainer cup found thread damage & worn-out","E/R - Boiler","Eng. / Strg. Comp.","Equipment Related","","","","","Replacement of Y strainer GC-018/ENG/2023","2024-02-29T23:59:35","","Waiting spare",null,"No","No","No","Internal","Awaiting GC from Yard - follow up in progress."]
[null,null,null,31089,56502,"133_Sat Aug 12 2023 21:28:25 GMT+0800","2023-08-09T23:59:35","Observation","Ship Staff","Ship Staff Insp.","BEND STBD SIDE BUNKER DAVIT JIB & BROKEN HOISTING WIRE. Mis handling of crane operator during cargo operation","Deck - Pipe / Fittings","Structural Condn. / WT integrity ","External Factors","","","","","SDR issued target to repair by shore assistance Sept 2023","2024-02-29T23:59:35","SDR/029","Not Started",null,"No","No","No","Internal"]
[null,null,null,31628,62550,"133_Fri Sep 15 2023 22:06:12 GMT+0800","2023-08-20T23:59:35","Observation","Ship Staff","Ship Staff Insp.","DAMAGE RESTING PAD HATCH COVER BAY 26 STBDS SIDE FORWARD PART","Deck - Pipe / Fittings","Structural Condn. / WT integrity ","External Factors","","","","","To Repair by external work shop in coordination with charterer","2024-02-29T23:59:35","SDR/030","Not Started",null,"No","No","No","Internal"]
[null,null,null,null,59874,"133_Thu Aug 31 2023 23:41:50 GMT+0800","2023-08-31T08:00:00","Guarantee Claim","Ship Staff","Ship Staff Insp.","Defective local level gauge FW storage tank STBD side not working properly GC-025/ENG/2023","Hull & Tanks","Eng. / Strg. Comp.","Equipment Related","","","","","Replacement of local level gauge FW tank STBD side GC-025/ENG/2023","2024-04-30T08:00:00","","Not Started",null,"No","No","No","Internal"]
[null,null,null,31622,96596,"0_Mon Sep 11 2023 16:10:13 GMT+0800","2023-09-07T23:59:35","Guarantee Claim","Ship Staff","Ship Staff Insp.","leaking galley 2 pcs faucet due to broken plastic valve","Accommodation","MLC Related","Equipment Related","","","","","Replacement of 2 pcs faucet under GC-027/Deck/2023","2024-02-29T23:59:35","","Waiting spare",null,"No","No","No","Internal"]
[null,null,null,31907,22973,"133_Sun Oct 01 2023 04:15:11 GMT+0800","2023-09-15T23:59:35","Observation","Ship Staff","Ship Staff Insp.","DAMAGE PROJECTOR LIGHT AND ITS HOUSING COVER AND BRACKET SUPPORTS BETWEEN BAY 10-14","Deck - Pipe / Fittings","Structural Condn. / WT integrity ","External Factors","","","","","To Repair by external work shop in coordination with charterer","2024-03-31T23:59:35","","Not Started",null,"No","No","No","Internal"]
[null,null,null,32180,72697,"133_Sun Oct 15 2023 18:44:09 GMT+0800","2023-10-15T23:59:35","Guarantee Claim","Ship Staff","Ship Staff Insp.","Starboard passage way door closer not working due to broken mechanism","Miscellaneous","Eng. / Strg. Comp.","Equipment Related","","","","","To replace with new door closer","2024-03-31T23:59:35","GC-029/ENG/2023","Waiting spare",null,"No","No","No","Internal"]
[null,null,null,32510,65296,"133_Wed Nov 15 2023 21:46:38 GMT+0800","2023-10-22T23:59:35","Guarantee Claim","Ship Staff","Ship Staff Insp.","Leaking  fuel oil Differential pressure fittings of auxiliary generator no. 2 FO filter","E/R - Aux. Engine","Eng. / Strg. Comp.","Equipment Related","","","","","For replacement of valve block Claim under GC 030/Eng/2023 ","2024-03-31T23:59:35","","Waiting spare",null,"No","No","No","Internal"]
[null,null,null,32512,81594,"0_Wed Nov 15 2023 21:52:21 GMT+0800","2023-11-07T23:59:35","Guarantee Claim","Ship Staff","Ship Staff Insp.","Pressure gauge connector leakage due to wasted edge body (pitting)","E/R - Pumps,E/R - Pipes/ valves & fittings","Eng. / Strg. Comp.","Equipment Related","","","","","For replacement under GC 032/Eng/2023","2024-03-31T23:59:35","","Waiting spare",null,"No","No","No","Internal"]
[null,null,null,33069,48104,"0_Thu Nov 30 2023 20:44:16 GMT+0800","2023-11-28T23:59:35","Guarantee Claim","Ship Staff","Ship Staff Insp.","Boiler feed water pump found leaking in mechanical seal overhaul and replace with spare mechanical seal ","E/R - Boiler","Eng. / Strg. Comp.","Equipment Related","","","","","Replacement under GC-34/2023","2024-03-31T23:59:35","","Waiting spare",null,"No","No","No","Internal"]
[null,null,null,null,65184,"133_Sun Dec 17 2023 01:59:22 GMT+0800","2023-12-16T08:00:00","Guarantee Claim","Ship Staff","Ship Staff Insp.","Garbage fire fighting sprinkler supply water valve crack and leaking ","LSA / FFA","Safety / LSA / FFA","Equipment Related","","","","","Under GC-36/Eng/2023 need replacement with new valve, as temporary repair the crack by welding","2024-04-30T08:00:00","","Waiting spare",null,"No","No","No","Internal"]
[null,null,null,33819,79500,"133_Mon Feb 05 2024 15:49:38 GMT+0800","2024-01-10T23:59:35","Guarantee Claim","Ship Staff","Ship Staff Insp.","Port side  chart lamp not working.","Navigation - Others","Navigation","Equipment Related","","","","","Replacement of chart lamp under GC 037/Deck/2024","2024-05-31T23:59:35","","In progress",null,"No","No","No","Internal"]
[null,null,null,33820,55209,"0_Mon Feb 05 2024 15:51:47 GMT+0800","2024-01-30T23:59:35","Guarantee Claim","Ship Staff","Ship Staff Insp.","CCR Loading computer not working","Cargo Mach.","Cargo / Ballast Systems","Equipment Related","","","","","Replacement of cargo loading computer under GC 038/Deck/2024","2024-05-31T23:59:35","","In progress",null,"No","No","No","Internal"]

{"sheet":"Completed","index":1,"n_rows":63,"n_cols":28,"rows_kept":63,"cut":false,"hidden":false,"merged":[[10,8,10,9],[10,12,10,13],[12,6,12,27],[8,6,8,27]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Defect - Damage Monitoring Sheet"]
[]
[null,null,null,null,null,null,null,"Date of Report","29-Feb-2024",null,null,"Ship Name","VIKING ORCA (05-02-2024)"]
[]
[null,null,null,null,null,null,"VERSION : 2.0"]
[]
[]
[]
[null,null,null,"ID","SHIPSIDE UNIQUEID","UNIQUE ID","Date Recorded","Type of Deficiency","Observer code","Type of Inspection","Description of Deficiency","Equipment Categories","Area of Observation","Deficiency Cause","VIQ Ref Number","Risk Value of Obs","PSC Ref Number","PSC MOU ID","Action Taken or Required","Target Date","PO Ref No.","Status Code","Date Completed","Drydock","Info Sharing","Critical Item","Audit Type","Superintendent Remarks"]
[null,null,null,31440,47180,"133_Mon Aug 28 2023 17:06:07 GMT+0800","2023-05-14T23:59:35","Guarantee Claim","Ship Staff","Ship Staff Insp.","No.1 Cylinder oil storage tank Leak from Bulkhead penetration","Hull & Tanks","Structural Condn. / WT integrity ","Equipment Related","","","","","Repair & Welding after pressure test by Yard GC-001/Eng/2023","2023-08-31T23:59:35","GC-001/Eng/2023","Completed","2023-05-28T23:59:35","No","No","No","Internal"]
[null,null,null,31441,32381,"0_Mon Aug 28 2023 17:08:21 GMT+0800","2023-05-15T23:59:35","Guarantee Claim","Ship Staff","Ship Staff Insp.","No.1 DG running hour meter defective","E/R - Aux. Engine","Eng. / Strg. Comp.","Equipment Related","","","","","Replacement hour meter GC-002/Eng/2023","2023-08-31T23:59:35","Spare received 18th May 2023","Completed","2023-05-18T23:59:35","No","No","No","Internal"]
[null,null,null,31442,37587,"0_Mon Aug 28 2023 17:11:34 GMT+0800","2023-05-18T23:59:35","Guarantee Claim","Ship Staff","Ship Staff Insp.","Main Engine fuel index calibration issue","E/R - Main Engine","Eng. / Strg. Comp.","Equipment Related","","","","","To consult maker and rectify error issue GC-003/Eng/2023","2023-08-31T23:59:35","GC-003/Eng/2023","Completed","2023-06-23T23:59:35","No","No","No","Internal"]
[null,null,null,31443,86852,"133_Mon Aug 28 2023 17:20:53 GMT+0800","2023-05-22T23:59:35","Guarantee Claim","Ship Staff","Ship Staff Insp.","All DG Frequency fluctuating at idle condition GC-004/Eng/2023","E/R - Aux. Engine","Eng. / Strg. Comp.","Equipment Related","","","","","Seek advice to Maker GC-004/Eng/2023","2023-08-31T23:59:35","","Completed","2023-06-01T23:59:35","No","No","No","Internal"]
[null,null,null,31014,51228,"133_Wed Aug 02 2023 14:03:01 GMT+0800","2023-05-25T23:59:35","Guarantee Claim","Ship Staff","Ship Staff Insp.","ESB 24 Volts battery charger not working defective/ GC-005-Eng-2023","Elect. Mach. & Equip.","Navigation","Equipment Related","","","","","Raise requisition Guarantee claim/ spare have been received and installed","2023-07-31T23:59:35","","Completed","2023-07-01T23:59:35","No","No","No","Internal"]
[null,null,null,31015,78158,"0_Wed Aug 02 2023 14:07:50 GMT+0800","2023-06-03T23:59:35","Breakdown","Ship Staff","Ship Staff Insp.","Accommodation air-condition compressor not working low insulation / GC-007-Eng-2023","Elect. Mach. & Equip.","Eng. / Strg. Comp.","Equipment Related","","","","","Raise requisition Guarantee claim/ spare received and replace with new compressor","2023-07-31T23:59:35","","Completed","2023-07-20T23:59:35","No","No","No","Internal"]
[null,null,null,31424,72269,"0_Mon Aug 28 2023 17:23:27 GMT+0800","2023-06-03T23:59:35","Guarantee Claim","Ship Staff","Ship Staff Insp.","Anemometer feed not going to Nav equipment GC-006/Eng/2023","Navigation - DGPS / EPFS / AIS","Communication","Equipment Related","","","","","New anemometer received and installed,  GC-006/Eng/2023 closed out","2023-09-30T23:59:35","","Completed","2023-09-01T23:59:35","No","No","No","Internal"]
[null,null,null,31425,68395,"0_Mon Aug 28 2023 17:29:15 GMT+0800","2023-06-03T23:59:35","Guarantee Claim","Ship Staff","Ship Staff Insp.","Deflective pressure gauge GC-008/Eng/2023","E/R - Aux. Mach.","Eng. / Strg. Comp.","Equipment Related","","","","","Received pressure gauge under GC-008/Eng/2023 closed out","2023-09-30T23:59:35","","Completed","2023-09-01T23:59:35","No","No","No","Internal"]
[null,null,null,31444,68393,"133_Mon Aug 28 2023 17:26:25 GMT+0800","2023-06-03T23:59:35","Guarantee Claim","Ship Staff","Ship Staff Insp.","Accommodation Aircon Compressor No. 1 Low insulation  winding GC-007/Eng/2023","E/R - Aux. Mach.","Eng. / Strg. Comp.","Equipment Related","","","","","Replace compressor","2023-08-31T23:59:35","","Completed","2023-07-20T23:59:35","No","No","No","Internal"]
[null,null,null,31445,42428,"0_Mon Aug 28 2023 17:31:43 GMT+0800","2023-06-05T23:59:35","Guarantee Claim","Ship Staff","Ship Staff Insp.","Defectives Fire Alarm Sensor GC-009/Eng/2023","Elect. Mach. & Equip.","Eng. / Strg. Comp.","Equipment Related","","","","","To replace under GC-009/Eng/2023","2023-08-31T23:59:35","","Completed","2023-06-30T23:59:35","No","No","No","Internal"]
[null,null,null,31426,13581,"0_Mon Aug 28 2023 17:34:23 GMT+0800","2023-06-11T23:59:35","Guarantee Claim","Ship Staff","Ship Staff Insp.","Defective pressure gauge GC-010/Eng/2023","E/R - Pumps","Eng. / Strg. Comp.","Equipment Related","","","","","Received pressure gauge GC-010/Eng/2023 closed out","2023-09-30T23:59:35","","Completed","2023-09-01T23:59:35","No","No","No","Internal"]
[null,null,null,31016,95854,"133_Wed Aug 02 2023 15:03:43 GMT+0800","2023-06-27T23:59:35","Breakdown","Ship Staff","Ship Staff Insp.","Emergency generator spring starter not working and defective/ GC-011-Eng-2023","Critical Equip.","Emgcy. Systems","Equipment Related","","","","","Raise requisition Guarantee claim/ GC-011-Eng-2023- spare received replaced & tested found working satisfactory now back to normal condition","2023-07-30T23:59:35","","Completed","2023-07-20T23:59:35","No","No","No","Internal"]
[null,null,null,31446,14506,"0_Mon Aug 28 2023 17:36:58 GMT+0800","2023-06-27T23:59:35","Guarantee Claim","Ship Staff","Ship Staff Insp.","Emergency generator Spring starter defective GC-011/ENG/2023","Elect. Mach. & Equip.","Emgcy. Systems","Equipment Related","","","","","To replace spring starter spare parts GC-011/ENG/2023","2023-08-31T23:59:35","","Completed","2023-07-20T23:59:35","No","No","No","Internal"]
[null,null,null,31090,68759,"133_Sat Aug 12 2023 18:43:05 GMT+0800","2023-07-08T23:59:35","Observation","Ship Staff","Ship Staff Insp.","BROKEN STANCHION POST BAY-30 AFT Mis handling of crane operator during cargo operation","Deck - Pipe / Fittings","Structural Condn. / WT integrity ","External Factors","","","","","Renew Broken stanchion post","2023-08-30T23:59:35","","Completed","2023-08-11T23:59:35","No","No","No","Internal"]
[null,null,null,31427,14272,"0_Mon Aug 28 2023 17:39:22 GMT+0800","2023-07-08T23:59:35","Guarantee Claim","Ship Staff","Ship Staff Insp.","Worn-out Rubber coupling GC-012/ENG/2023","E/R - Pumps","Eng. / Strg. Comp.","Equipment Related","","","","","Received rubber coupling under GC-012/ENG/2023 closed out","2023-09-30T23:59:35","","Completed","2023-09-01T23:59:35","No","No","No","Internal"]
[null,null,null,31093,72497,"133_Sat Aug 12 2023 19:09:01 GMT+0800","2023-07-10T23:59:35","Observation","Ship Staff","Ship Staff Insp.","BEND HAND RAIL BAY-26 ROW 04 FWD PART. Mis handling of crane operator during cargo operation","Deck - Pipe / Fittings","Structural Condn. / WT integrity ","External Factors","","","","","Renew Hand rail","2023-08-30T23:59:35","","Completed","2023-08-11T23:59:35","No","No","No","Internal"]
[null,null,null,31429,63192,"0_Mon Aug 28 2023 17:43:50 GMT+0800","2023-07-14T23:59:35","Guarantee Claim","Ship Staff","Ship Staff Insp.","Ballast pump No. 2 Contactor defective","Elect. Mach. & Equip.","Eng. / Strg. Comp.","Equipment Related","","","","","Replacement of Contactor GC-014/ENG/2023","2023-10-31T23:59:35","","Completed","2023-10-07T23:59:35","No","No","No","Internal","Awaiting GC from Yard - follow up in progress."]
[null,null,null,31017,50155,"0_Wed Aug 02 2023 15:07:18 GMT+0800","2023-07-22T23:59:35","Defect","Ship Staff","Ship Staff Insp.","ME Jacket Cooling FW pump motor bearing abnormal sound","E/R - Aux. Mach.","Eng. / Strg. Comp.","Equipment Related","","","","","Replaced bearing motor one end tested found normal sound and working satisfactory/ raise GC-015-Eng-2023 for replenish of bearing spare","2023-07-31T23:59:35","","Completed","2023-07-22T23:59:35","No","No","No","Internal"]
[null,null,null,31430,64432,"0_Mon Aug 28 2023 17:46:12 GMT+0800","2023-07-22T23:59:35","Guarantee Claim","Ship Staff","Ship Staff Insp.","ME Jacket cooling FW pump Worn out bearing motor GC-015/ENG/2023","E/R - Pumps","Eng. / Strg. Comp.","Equipment Related","","","","","Replacement of ball bearing taken from spare GC-015/ENG/2023","2023-09-30T23:59:35","","Completed","2023-10-07T23:59:35","No","No","No","Internal","If job completed - Pls close the item"]
[null,null,null,31094,38930,"133_Sat Aug 12 2023 20:11:06 GMT+0800","2023-07-23T23:59:35","Observation","Ship Staff","Ship Staff Insp.","BEND STANCHION POST BASE BAY-10 AFT PART. Mis handling of crane operator during cargo operation","Deck - Pipe / Fittings","Structural Condn. / WT integrity ","External Factors","","","","","Renew stanchion port base","2023-08-30T23:59:35","","Completed","2023-08-12T23:59:35","No","No","No","Internal"]
[null,null,null,31095,54725,"133_Sat Aug 12 2023 20:15:45 GMT+0800","2023-07-23T23:59:35","Observation","Ship Staff","Ship Staff Insp.","BEND HAND RAIL BAY-06  ROW 01 & ROW 02 FWD PART","Deck - Pipe / Fittings","Structural Condn. / WT integrity ","External Factors","","","","","Renew hand rail","2023-08-30T23:59:35","","Completed","2023-08-12T23:59:35","No","No","No","Internal"]
[null,null,null,31088,39213,"133_Sat Aug 12 2023 20:30:14 GMT+0800","2023-07-24T23:59:35","Observation","Ship Staff","Ship Staff Insp.","DAMAGED BASE LOCK 4 PIECES. Mis handling of crane operator during cargo operation","Miscellaneous","Structural Condn. / WT integrity ","External Factors","","","","","Base lock renewed  4Pcs 01 Sept 2023","2023-09-30T23:59:35","VORC230030","Completed","2023-09-01T23:59:35","No","No","No","Internal"]
[null,null,null,31091,94575,"133_Sat Aug 12 2023 21:16:18 GMT+0800","2023-07-26T23:59:35","Observation","Ship Staff","Ship Staff Insp.","DAMAGED BROKEN TWISTLOCK 5 Pcs (BASE LOCKS). Mis handling of crane operator during cargo operation","Miscellaneous","Structural Condn. / WT integrity ","External Factors","","","","","Base lock renewed  5Pcs 01 Sept 2023","2023-09-30T23:59:35","VORC230030","Completed","2023-09-01T23:59:35","No","No","No","Internal"]
[null,null,null,31629,57425,"133_Fri Sep 15 2023 21:37:42 GMT+0800","2023-07-27T23:59:35","Observation","Ship Staff","Ship Staff Insp.","DAMAGED BROKEN TWISTLOCK BAY-22 (BASE LOCK) 1 PC","Miscellaneous","Structural Condn. / WT integrity ","External Factors","","","","","Base lock renewed  1Pc 01 Sept 2023","2023-09-30T23:59:35","VORC230030","Completed","2023-09-01T23:59:35","No","No","No","Internal"]
[null,null,null,31431,26023,"0_Mon Aug 28 2023 17:47:45 GMT+0800","2023-08-01T23:59:35","Guarantee Claim","Ship Staff","Ship Staff Insp.","Galley cooking range with oven and bread oven indicator lamp busted LED","Elect. Mach. & Equip.","Eng. / Strg. Comp.","Equipment Related","","","","","Replacement of LED lights GC-016/ENG/2023","2023-09-30T23:59:35","","Completed","2023-10-07T23:59:35","No","No","No","Internal","Awaiting GC from Yard - follow up in progress."]
[null,null,null,31432,18726,"0_Mon Aug 28 2023 17:49:38 GMT+0800","2023-08-08T23:59:35","Guarantee Claim","Ship Staff","Ship Staff Insp.","Deck-2023 Search light busted lamp","Elect. Mach. & Equip.","Eng. / Strg. Comp.","Equipment Related","","","","","Replacement of busted lamp GC-017/ENG/2023","2023-09-30T23:59:35","","Completed","2023-10-07T23:59:35","No","No","No","Internal","Awaiting GC from Yard - follow up in progress."]
[null,null,null,31434,36503,"0_Mon Aug 28 2023 17:52:46 GMT+0800","2023-08-11T23:59:35","Guarantee Claim","Ship Staff","Ship Staff Insp.","leaking gasket of MGO cooler and LT cooling system contaminated with Fuel oil","E/R - Pipes/ valves & fittings","Eng. / Strg. Comp.","Equipment Related","","","","","Replacement of Gasket MGO cooler plate GC-019/ENG/2023","2023-09-30T23:59:35","","Completed","2023-10-07T23:59:35","No","No","No","Internal","Awaiting GC from Yard - follow up in progress."]
[null,null,null,31435,16129,"0_Mon Aug 28 2023 17:54:32 GMT+0800","2023-08-15T23:59:35","Guarantee Claim","Ship Staff","Ship Staff Insp.","BWTS Monitoring system inlet water filter leaking, For TRO","Deck - Machinery","Eng. / Strg. Comp.","Equipment Related","","","","","Replacement spare parts GC-020/ENG/2023","2023-09-30T23:59:35","","Completed","2023-10-07T23:59:35","No","No","No","Internal","Awaiting GC from Yard - follow up in progress."]
[null,null,null,31436,27565,"0_Mon Aug 28 2023 17:56:41 GMT+0800","2023-08-20T23:59:35","Guarantee Claim","Ship Staff","Ship Staff Insp.","Leaking Toilet bowl in dressing room","Accommodation","Eng. / Strg. Comp.","Equipment Related","","","","","Replacement of toilet bowl GC-021/ENG/2023","2023-09-30T23:59:35","","Completed","2023-10-07T23:59:35","No","No","No","Internal","Awaiting GC from Yard - follow up in progress."]
[null,null,null,31437,16269,"0_Mon Aug 28 2023 17:57:57 GMT+0800","2023-08-20T23:59:35","Guarantee Claim","Ship Staff","Ship Staff Insp.","Leaking Toilet bowl in Crew gym","Accommodation","Eng. / Strg. Comp.","Equipment Related","","","","","Replacement of Toilet bowl GC-022/ENG/2023","2023-09-30T23:59:35","","Completed","2023-10-07T23:59:35","No","No","No","Internal","Awaiting GC from Yard - follow up in progress."]
[null,null,null,31438,78959,"0_Mon Aug 28 2023 17:59:33 GMT+0800","2023-08-20T23:59:35","Guarantee Claim","Ship Staff","Ship Staff Insp.","Leaking Toilet bowl in Tally room","Accommodation","Eng. / Strg. Comp.","Equipment Related","","","","","Replacement of toilet bowl GC-023/ENG/2023","2023-09-30T23:59:35","","Completed",null,"No","No","No","Internal","Awaiting GC from Yard - follow up in progress."]
[null,null,null,31439,72380,"0_Mon Aug 28 2023 18:01:32 GMT+0800","2023-08-24T23:59:35","Guarantee Claim","Ship Staff","Ship Staff Insp.","Chart room lighting stbd defective dimmer","Elect. Mach. & Equip.","General Appearance","Equipment Related","","","","","Replacement spare lighting dimmer GC-024/DECK/2023","2023-09-30T23:59:35","","Completed","2023-10-07T23:59:35","No","No","No","Internal","Awaiting GC from Yard - follow up in progress."]
[null,null,null,31621,55730,"133_Mon Sep 11 2023 16:07:21 GMT+0800","2023-09-07T23:59:35","Guarantee Claim","Ship Staff","Ship Staff Insp.","SEWAGE TREATMENT UNIT CHEMICAL DOSING PUMP DEFECTIVE","E/R - Pumps","MARPOL Related","Equipment Related","","","","","Replacement of chemical dosing pump under GC-026/Eng/2023","2023-11-30T23:59:35","","Completed","2023-10-07T23:59:35","No","No","No","Internal"]
[null,null,null,31916,56681,"133_Sun Oct 01 2023 04:16:50 GMT+0800","2023-09-16T23:59:35","Observation","Ship Staff","Ship Staff Insp.","DAMAGE HAND RAIL ON CATWALK BAY 18 FWD ROW 01","Deck - Pipe / Fittings","Structural Condn. / WT integrity ","External Factors","","","","","Hand rail reparied by ships staff","2023-12-30T23:59:35","","Completed","2023-09-25T23:59:35","No","No","No","Internal"]
[null,null,null,31917,80017,"133_Sun Oct 01 2023 04:21:43 GMT+0800","2023-09-16T23:59:35","Observation","Ship Staff","Ship Staff Insp.","DAMAGED ANT-LIFTING DEVICE FOR HATCH COVER BAY 18 5P","Deck - Pipe / Fittings","Structural Condn. / WT integrity ","External Factors","","","","","REPAIRED BY SHIPS STAFF RE ALIGN ANTI LIFTING DEVICE USING HYDRAULIC EQUIPMENT.","2023-12-30T23:59:35","","Completed","2023-09-30T23:59:35","No","No","No","Internal"]
[null,null,null,31908,42893,"133_Sun Oct 01 2023 03:49:12 GMT+0800","2023-09-22T23:59:35","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Bridge Watch levels mentioned in the passage plan do not match with actual watch levels on the bridge. Bridge watch level was marked as 1 in deck logbook while Pilot was on board.      ","Navigation - Others","ISM Related","Human Error","","","","","Corrected and updated watch level on marked page of log book,","2023-12-21T23:59:35","","Completed","2023-09-22T23:59:35","No","No","No","Internal"]
[null,null,null,31909,91471,"133_Sun Oct 01 2023 03:54:15 GMT+0800","2023-09-22T23:59:35","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Gyro/ Magnetic Compass error was not calculated in each watch.      ","Navigation - Others","ISM Related","Human Error","","","","","Corrected and updated, each watch should take gyro/compass error log, if observation cannot be obtained due to weather condition, log as remarks that error cannot be obtain due to such condition.","2023-12-21T23:59:35","","Completed","2023-09-22T23:59:35","No","No","No","Internal"]
[null,null,null,31910,69646,"133_Sun Oct 01 2023 03:56:58 GMT+0800","2023-09-22T23:59:35","Other,Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","GMDSS: Procedures for sending Undesignated distress alert and Designated distress message were not available in wheel house","Navigation - Others","ISM Related","Human Error","","","","","Corrected and Procedures are posted for sending Undesignated distress alert and Designated distress message ","2023-12-21T23:59:35","","Completed","2023-09-22T23:59:35","No","No","No","Internal"]
[null,null,null,31911,17089,"133_Sun Oct 01 2023 03:58:43 GMT+0800","2023-09-22T23:59:35","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Wheel house computers: No warning was displayed on the computer stating “Not to be used except for Navigation Purpose”.","Navigation - Others","ISM Related","Human Error","","","","","Corrected and posted warning sign displayed on the computer stating “Not to be used except for Navigation Purpose”.","2023-12-21T23:59:35","","Completed","2023-09-22T23:59:35","No","No","No","Internal"]
[null,null,null,31912,63378,"133_Sun Oct 01 2023 04:00:19 GMT+0800","2023-09-22T23:59:35","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Change over procedure from GYRO compass to Transmitting Magnetic Compass (TMC) was not displayed in the wheel house. ","Navigation - Others","ISM Related","Human Error","","","","","Corrected and posted procedure from GYRO compass to Transmitting Magnetic Compass (TMC) displayed in the wheel house. ","2023-12-21T23:59:35","","Completed","2023-09-22T23:59:35","No","No","No","Internal"]
[null,null,null,31913,95259,"133_Sun Oct 01 2023 04:02:31 GMT+0800","2023-09-22T23:59:35","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","List of security equipment is not maintained as per SSP Section 08.04.","Miscellaneous","ISPS Related","Human Error","","","","","List of Security equipment updated and inline with the list on SSP Section 08.04","2023-12-21T23:59:35","","Completed","2023-09-22T23:59:35","No","No","No","Internal"]
[null,null,null,31914,71800,"133_Sun Oct 01 2023 04:06:31 GMT+0800","2023-09-22T23:59:35","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","On board compliant procedure was not available in all crew cabins.","Miscellaneous","MLC Related","Human Error","","","","","One Cabin with mis placed complaint procedure re posted the  procedure. in his cabin, all cabin checked plastic pouches to secure the procedure in place.","2023-12-21T23:59:35","","Completed","2023-09-22T23:59:35","No","No","No","Internal"]
[null,null,null,31915,23806,"133_Sun Oct 01 2023 04:08:19 GMT+0800","2023-09-22T23:59:35","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","MLC: Financial security cert (MLC Reg 2.5 & 4.2) is not displayed in common places.","Miscellaneous","MLC Related","Human Error","","","","","MLC Financial Cert MLC reg 2.5 & 4.2 are posted on each green notice board in all alleyways.","2023-11-30T23:59:35","","Completed","2023-09-22T23:59:35","No","No","No","Internal"]
[null,null,null,32511,21044,"0_Wed Nov 15 2023 21:49:43 GMT+0800","2023-11-07T23:59:35","Guarantee Claim","Ship Staff","Ship Staff Insp.","Defective float switch of stern tube forward seal tank","E/R - Main Engine","Eng. / Strg. Comp.","Equipment Related","","","","","For replacement under GC 31/Eng/2023","2024-03-31T23:59:35","","Completed","2024-02-07T23:59:35","No","No","No","Internal"]
[null,null,null,33068,83061,"133_Thu Nov 30 2023 20:42:35 GMT+0800","2023-11-28T23:59:35","Guarantee Claim","Ship Staff","Ship Staff Insp.","128 Zone 1 MCP 59 NO ANSWER UPPER DECK BOSUN STORE.","Critical Equip.","Emgcy. Systems","Equipment Related","","","","","Replacement under GC-33/2023 ","2024-03-31T23:59:35","","Completed","2024-02-07T23:59:35","No","No","No","Internal"]
[null,null,null,null,63125,"133_Fri Feb 16 2024 16:38:59 GMT+0800","2024-02-15T08:00:00","Defect","Ship Staff","Ship Staff Insp.","HFO Purifier no.1 sealing ring worn out/damage","E/R - Purifier","Eng. / Strg. Comp.","Equipment Related","","","","","Renewed sealing ring and O-rings.","2024-02-29T08:00:00","","Completed","2024-02-15T08:00:00","No","No","No","Internal"]

{"sheet":"Calc","index":2,"n_rows":28,"n_cols":12,"rows_kept":28,"cut":false,"hidden":true,"merged":[]}
["Def_type","Def_cause","Equipments","VIQrefno","Observer_code"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Dim itemSele As Long"]
[null,null,null,null,null,null,null,null,null,null,null,"   dim startRow as integer"]
[null,null,null,null,null,null,null,null,null,null,null,"   startRow=1"]
[null,null,null,null,null,null,null,null,null,null,null,"        For itemSele = 0 To ListBox1.ListCount - 1"]
[null,null,null,null,null,null,null,null,null,null,null,"        If ListBox1.Selected(itemSele) = True Then"]
[null,null,null,null,null,null,null,null,null,null,null,"        Worksheets(\"WorksheetName\").Range(\"A\" & startRow).Value = ListBox1.List(itemSele)"]
[null,null,null,null,null,null,null,null,null,null,null,"        startRow = startRow + 1"]
[null,null,null,null,null,null,null,null,null,null,null,"        End If"]
[null,null,null,null,null,null,null,null,null,null,null,"        Next"]
[null,null,null,null,null,null,null,null,null,null,null,"Dim LastRowA As String"]
[null,null,null,null,null,null,null,null,null,null,null,"        Dim itemSele As Long"]
[null,null,null,null,null,null,null,null,null,null,null,"       Dim startRow as integer"]
[null,null,null,null,null,null,null,null,null,null,null,"        LastRowA = ActiveSheet.Cells(Rows.count, \"A\").End(xlUp).row"]
[null,null,null,null,null,null,null,null,null,null,null,"        startQue = 0"]
[null,null,null,null,null,null,null,null,null,null,null,"        For itemSele = 0 To ListBox1.ListCount - 1"]
[null,null,null,null,null,null,null,null,null,null,null,"        For startRow = 1 To LastRowA"]
[null,null,null,null,null,null,null,null,null,null,null,"        If Worksheets(\"WorksheetName\").Range(\"A\" & startRow).Value = ListBox1.List(itemSele) Then"]
[null,null,null,null,null,null,null,null,null,null,null,"        ListBox1.Selected(itemSele) = True"]
[null,null,null,null,null,null,null,null,null,null,null,"        Exit For"]
[null,null,null,null,null,null,null,null,null,null,null,"        End If"]
[null,null,null,null,null,null,null,null,null,null,null,"        Next j"]
[null,null,null,null,null,null,null,null,null,null,null,"        Next"]
[null,null,null,null,null,null,null,null,null,null,null,"        End If"]

{"sheet":"Areaofobs","index":3,"n_rows":17,"n_cols":2,"rows_kept":17,"cut":false,"hidden":true,"merged":[]}
["TITLE","ID"]
["Cargo / Ballast Systems",11]
["Cert. & Docu.",2]
["Communication",6]
["Crew Management",3]
["Emgcy. Systems",13]
["Eng. / Strg. Comp.",14]
["General Appearance",15]
["Ice Opns.",17]
["ISM Related",7]
["ISPS Related",10]
["MARPOL Related",9]
["MLC Related",4]
["Mooring",12]
["Navigation",5]
["Safety / LSA / FFA",8]
["Structural Condn. / WT integrity ",16]

{"sheet":"Vessel_type","index":4,"n_rows":1,"n_cols":2,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["Vessel_type","ID"]

{"sheet":"Deficiency_type","index":5,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
["TITLE","Type of deficiency_description","ID"]
["Breakdown",null,6]
["Critical Equipment",null,4]
["Defect",null,1]
["Guarantee Claim",null,8]
["Non Conformity",null,2]
["Observation",null,3]
["Other",null,7]

{"sheet":"VIQrefno","index":6,"n_rows":1,"n_cols":3,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["VIQ_ref_no","Risk Value of observation","ID"]

{"sheet":"Equipment_list","index":7,"n_rows":28,"n_cols":3,"rows_kept":28,"cut":false,"hidden":true,"merged":[]}
["TITLE","Equipment_list_description","ID"]
["Accommodation",null,12]
["Cargo Mach.",null,13]
["Critical Equip.",null,16]
["Deck - Machinery",null,18]
["Deck - Mooring Machinery",null,15]
["Deck - Pipe / Fittings",null,20]
["Documentation",null,21]
["E/R - Air Comp.",null,8]
["E/R - Aux. Engine",null,4]
["E/R - Aux. Mach.",null,7]
["E/R - Boiler",null,5]
["E/R - Main Engine",null,3]
["E/R - Pipes/ valves & fittings",null,9]
["E/R - Pumps",null,32]
["E/R - Purifier",null,6]
["Elect. Mach. & Equip.",null,10]
["Hull & Tanks",null,19]
["Inert Gas",null,14]
["LSA / FFA",null,17]
["Miscellaneous",null,22]
["Navigation - DGPS / EPFS / AIS",null,28]
["Navigation - ECDIS",null,25]
["Navigation - Echo Sounder / Speed Log",null,26]
["Navigation - GMDSS & Communication",null,23]
["Navigation - Others",null,11]
["Navigation - RADAR",null,24]
["Navigation - VDR / BNWAS",null,30]

{"sheet":"PSC_MOU","index":8,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
["TITLE","PSC_MOU_description","ID"]
["Asia and the Pacific",null,2]
["Caribbean",null,4]
["Europe and the North Atlantic",null,1]
["Latin America",null,3]
["The Black Sea region",null,6]
["The Indian Ocean",null,8]
["The Mediterranean",null,7]
["The Riyadh MoU",null,9]
["USCG",null,10]
["West and Central Africa",null,5]

{"sheet":"Inspection_type","index":9,"n_rows":13,"n_cols":2,"rows_kept":13,"cut":false,"hidden":true,"merged":[]}
["TITLE","ID"]
["Bunkering Audit",14]
["Cargo Audit",17]
["Engineering Audit",16]
["ISM Audit",2]
["ISPS Audit",3]
["IT Audit",10]
["MLC Audit",1]
["Mooring Audit",9]
["Nav Audit / Verification",8]
["Onboard Training",18]
["Ship Staff Insp.",15]
["Suptd. Insp.",13]

{"sheet":"Deficiency_Cause","index":10,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
["TITLE","Deficiency_Cause_description","ID"]
["Behaviour Based",null,1]
["Equipment Related",null,4]
["External Factors",null,5]
["Human Error",null,7]
["Inappropriate Procedure",null,8]
["Industry Issue",null,6]
["Knowledge Based",null,3]

{"sheet":"Observer_code","index":11,"n_rows":3,"n_cols":3,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
["TITLE","Observer_code_description","ID"]
["Owner / Marine / Tech. Suptd.",null,3]
["Ship Staff",null,2]

{"sheet":"Status_code","index":12,"n_rows":6,"n_cols":3,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
["TITLE","Status_code_description","ID"]
["Completed",null,6]
["Deferred to D D",null,5]
["In progress",null,3]
["Not Started",null,2]
["Waiting spare",null,4]

{"sheet":"PSC_ref_no","index":13,"n_rows":19,"n_cols":2,"rows_kept":19,"cut":false,"hidden":true,"merged":[]}
["TITLE","ID"]
["Alarms",9]
["Cargo operations including equipment",7]
["Certificates & Documentation",2]
["Dangerous Goods",13]
["Emergency Systems",5]
["Fire safety",8]
["ISM",16]
["ISPS",17]
["Life saving appliances",12]
["MLC, 2006",18]
["Other",19]
["Pollution Prevention",15]
["Propulsion and auxiliary machinery",14]
["Radio communication",6]
["Safety of Navigation",11]
["Structural condition",3]
["Water/Weathertight condition",4]
["Working and Living Conditions",10]

{"sheet":"Risk_value_of_obs","index":14,"n_rows":1,"n_cols":2,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["Risk Value of observation","ID"]

{"sheet":"Year","index":15,"n_rows":18,"n_cols":1,"rows_kept":18,"cut":false,"hidden":true,"merged":[]}
["Year"]
[2014]
[2015]
[2016]
[2017]
[2018]
[2019]
[2020]
[2021]
[2022]
[2023]
[2024]
[2025]
[2026]
[2027]
[2028]
[2029]
[2030]

{"sheet":"Month","index":16,"n_rows":13,"n_cols":1,"rows_kept":13,"cut":false,"hidden":true,"merged":[]}
["Month"]
["Jan"]
["Feb"]
["Mar"]
["Apr"]
["May"]
["Jun"]
["Jul"]
["Aug"]
["Sep"]
["Oct"]
["Nov"]
["Dec"]

{"sheet":"Date_","index":17,"n_rows":32,"n_cols":1,"rows_kept":32,"cut":false,"hidden":true,"merged":[]}
["Date"]
["01"]
["02"]
["03"]
["04"]
["05"]
["06"]
["07"]
["08"]
["09"]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]

{"sheet":"Sheet1","index":18,"n_rows":24,"n_cols":6,"rows_kept":24,"cut":false,"hidden":true,"merged":[]}
[]
[null,"ID","E",null,"Date Recorded",1]
[null,"UNIQUE ID","F",null,"Type of Deficiency",2]
[1,"Date Recorded","G",null,"Observer code",3]
["ignore","Vessel Type","H",null,"Type of Inspection",4]
[null,"Internal / External","I",null,"Description of Deficiency",5]
[null,"Drydock","J",null,"Equipment Categories",6]
[null,"Information Sharing","K",null,"Area of Observation",7]
[null,"Critical_item","L",null,"Deficiency Cause",8]
[null,"Deficiency Type","M",null,"VIQ Ref Number",9]
[null,"Deficiency Cause","N",null,"Risk Value of Obs",10]
[null,"Inspection Type","O",null,"PSC Ref Number",11]
[null,"Equipments","P",null,"PSC MOU ID",12]
[null,"VIQ Reference Number","Q",null,"Action Taken or Required",13]
[null,"Risk Value of the observation","R",null,"Target Date",14]
[null,"PSC Reference Number","S",null,"PO Ref No.",15]
[null,"PSC MOU","T",null,"Status Code",16]
[null,"Observer Code","U",null,"Date Completed",17]
[null,"Target Date","V",null,"Drydock",18]
[null,"Status Code","W",null,"Info Sharing",19]
[null,"Description of Deficiency","X",null,"Critical Item Flag",20]
[null,"Action taken / required","Y",null,"Audit Type",21]
[null,"PO ref no","Z"]
[null,"Date completed","AA"]

{"sheet":"Ship_information","index":19,"n_rows":2,"n_cols":4,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["Ship_ID","Ship_Name","FILE_NAME","Export_Date"]
["133","VIKING ORCA (05-02-2024)","133_1708046442751.xlsm","2024-02-29 20:02:53"]

{"sheet":"External_Deficiency_type","index":20,"n_rows":5,"n_cols":3,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
["TITLE","Type of deficiency_description","ID"]
["Condn of Class / Memo",null,5]
["Defect",null,1]
["Non Conformity",null,2]
["Observation",null,3]

{"sheet":"External_Inspection_type","index":21,"n_rows":11,"n_cols":2,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
["TITLE","ID"]
["Cargo Audit",17]
["Flag State Insp.",5]
["ISM Audit",2]
["ISPS Audit",3]
["MLC Audit",1]
["Nav Audit / Verification",8]
["OM Insp. (Eg. SIRE / CDI etc.)",6]
["Others (Eg. Insurance etc.)",12]
["PSC Inspection",4]
["Terminal Insp.",11]

{"sheet":"External_Observer_code","index":22,"n_rows":7,"n_cols":3,"rows_kept":7,"cut":false,"hidden":true,"merged":[]}
["TITLE","Observer_code_description","ID"]
["Class Surveyor",null,4]
["FSC Inspector",null,5]
["Others (Eg. Insurance etc.)",null,9]
["PSC Insp.",null,6]
["SIRE / CDI Insp.",null,8]
["Terminal Insp.",null,7]

{"sheet":"Sheet Version","index":23,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["Version","Title"]
["2.0","Version 2.0"]