{"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":32,"n_cols":28,"rows_kept":32,"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","03-May-2022",null,null,"Ship Name","CAPE PHOENIX (04-04-2022)"]
[]
[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,24685,null,"129_23/3/2022 4:14:33 pm","2021-11-17T23:59:35","Observation","Ship Staff","Ship Staff Insp.","STEERING GEAR 1&2 LEAKING FROM SERVO CONTROLLER UNITS AND RAMS","E/R - Aux. Mach.","Eng. / Strg. Comp.","Equipment Related","","","","","NEED TO BE REPLACE ALL ASSOCIATE O-RINGS AND PACKINGS.","2022-05-31T23:59:35","CPHO 220020","Not Started",null,"No","No","No","Internal","spare already on board. to rectify at the first opportunity."]
[null,null,null,24688,null,"129_23/3/2022 5:44:59 pm","2021-11-17T23:59:35","Observation","Ship Staff","Ship Staff Insp.","ME CYL LO FLOWMETER DAMAGED AT HINGED","E/R - Pipes/ valves & fittings","Eng. / Strg. Comp.","Equipment Related","","","","","NEED TO BE REPLACE","2022-03-31T23:59:35","CPHO210044","Waiting spare",null,"No","No","No","Internal","to check spare received or not. or cancelled your have to raise RO for 2022."]
[null,null,null,24691,null,"129_2/4/2022 5:06:55 pm","2022-02-02T23:59:35","Observation","Ship Staff","Ship Staff Insp.","BREAST FWD, SPRING FWD & AFT SPRING MOORING WINCH MOTOR BODY DAMAGED","Deck - Mooring Machinery","Eng. / Strg. Comp.","Equipment Related","","","","","NEED TO BE REPLACE","2022-06-15T23:59:35","CPHO220015","Waiting spare",null,"No","No","No","Internal","it has been repaired. to monitor the condition. spare will supply in next convenient port"]
[null,null,null,24692,null,"129_2/4/2022 4:53:10 pm","2022-03-17T23:59:35","Observation","Ship Staff","Ship Staff Insp.","LS FO SETT TANK LEVEL GAUGE DAMAGED","Hull & Tanks","Eng. / Strg. Comp.","Equipment Related","","","","","NEED TO BE REPLACED IT'S PARTS","2022-06-06T23:59:35","","Waiting spare",null,"No","No","No","Internal","to raise RO for spare. provide RO number"]
[null,null,null,24693,null,"129_2/4/2022 4:56:55 pm","2022-03-27T23:59:35","Observation","Ship Staff","Suptd. Insp.","AE FO LINE PR REGULATING VALVE MALFUNCTIONING","E/R - Aux. Engine","Eng. / Strg. Comp.","Equipment Related","","","","","PART NEED TO BE REPLACE","2022-06-15T23:59:35","","Not Started",null,"No","No","No","Internal","to overhaul the valve and raise the RO for spare"]
[null,null,null,null,37025,"129_Tue Apr 19 2022 15:22:46 GMT+0800","2022-04-07T08:00:00","Observation","Ship Staff","Ship Staff Insp.","ALL ROLLER FAIRLEAD- TO DISMANTLE AND DERUST\n","Deck - Mooring Machinery","Mooring","Equipment Related","","","","","TO DISMANTLE AND DERUST\n","2022-07-07T08:00:00","","In progress",null,"No","No","No","Internal"]
[null,null,null,null,81387,"129_Wed Apr 27 2022 00:28:42 GMT+0800","2022-04-08T08:00:00","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","HATCH COVER HEAVY BOLT TO CARRY OUT MAINTENANCE","Cargo Mach.","Structural Condn. / WT integrity ","Equipment Related","","","","","DERUSTING AND LUBRICATION","2022-06-07T08:00:00","","In progress",null,"No","No","No","Internal"]
[null,null,null,null,92969,"129_Wed Apr 27 2022 00:31:17 GMT+0800","2022-04-08T08:00:00","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","HATCH COVER GAS SAMPLING POINT FROZEN IN SOME PLACES","Cargo Mach.","Structural Condn. / WT integrity ","Equipment Related","","","","","TO DERUST AND LUBRICATE THREAD","2022-06-08T08:00:00","","In progress",null,"No","No","No","Internal"]
[null,null,null,null,69172,"129_Wed Apr 27 2022 00:33:12 GMT+0800","2022-04-08T08:00:00","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","STBD SIDE ENTRANCE PLATFORM STEP- OBSERVED TO BE WEAK","Deck - Pipe / Fittings","Structural Condn. / WT integrity ","Equipment Related","","","","","SUBJECT FOR REPLACEMENT DUE TO DETERIORATION","2022-06-07T08:00:00","","Not Started",null,"No","No","No","Internal"]
[null,null,null,null,64325,"129_Wed Apr 27 2022 00:36:07 GMT+0800","2022-04-08T08:00:00","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","HATCH COVER CENTER STOPPER-MAINTENANCE","Cargo Mach.","Structural Condn. / WT integrity ","Equipment Related","","","","","TO DERUST, CHECK AND PAINT","2022-06-07T08:00:00","","Not Started",null,"No","No","No","Internal"]
[null,null,null,null,12193,"129_Wed Apr 27 2022 00:38:12 GMT+0800","2022-04-10T08:00:00","Non Conformity","Ship Staff","Ship Staff Insp.","RESCUE BOAT DECK SAFETY RAILINGS- FOR ADDITIONAL 1 DETTACHABLE RAILING","LSA / FFA","Safety / LSA / FFA","Equipment Related","","","","","TO RAISE RO AND INSTALL","2022-07-10T08:00:00","","Waiting spare",null,"No","No","No","Internal"]
[null,null,null,null,72222,"129_Wed Apr 27 2022 00:42:18 GMT+0800","2022-04-10T08:00:00","Observation","Ship Staff","Ship Staff Insp.","MF/HF ANTENNA- DETERIORATED SAFETY CHAIN GUARD","Navigation - GMDSS & Communication","Structural Condn. / WT integrity ","External Factors","","","","","TO RENEW","2022-07-10T08:00:00","","Waiting spare",null,"No","No","No","Internal"]
[null,null,null,null,74485,"129_Wed Apr 27 2022 00:44:15 GMT+0800","2022-04-10T08:00:00","Observation","Ship Staff","Ship Staff Insp.","GANGWAY UPPER PLATFORM-SUBJECT FOR THOROUGH INSPECTION","Deck - Machinery","Structural Condn. / WT integrity ","Equipment Related","","","","","TO DISMANTLE, DERUST AND INSPECT","2022-07-10T08:00:00","","Not Started",null,"No","No","No","Internal"]
[null,null,null,null,71821,"129_Wed Apr 27 2022 00:45:35 GMT+0800","2022-04-10T08:00:00","Observation","Ship Staff","Ship Staff Insp.","HATCH COVER VENT AND HOLD ACCESS RUBBER PACKING","Cargo Mach.","Structural Condn. / WT integrity ","Equipment Related","","","","","SUBJECT FOR REPLACEMENT","2022-07-10T08:00:00","","Waiting spare",null,"No","No","No","Internal"]
[null,null,null,null,57571,"129_Fri Apr 29 2022 01:34:17 GMT+0800","2022-04-07T08:00:00","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","AREAS IN ENGINE CASING TO CLEAN AND PAINT, CHECK ALL LIGHTS.","Miscellaneous","Eng. / Strg. Comp.","Equipment Related","","","","","CLEANING AND PAINTING  OF ENGINE ROOM CASING AREA","2022-06-07T08:00:00","","Not Started",null,"No","No","No","Internal"]

{"sheet":"Completed","index":1,"n_rows":30,"n_cols":28,"rows_kept":30,"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","03-May-2022",null,null,"Ship Name","CAPE PHOENIX (04-04-2022)"]
[]
[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,24684,null,"129_23/3/2022 4:18:40 pm","2021-11-17T23:59:35","Defect","Ship Staff","Ship Staff Insp.","CONTROL AIR DRYER NOT WORKING\t","Miscellaneous","Eng. / Strg. Comp.","Equipment Related","","","","","NEED TO BE REPLACE WITH NEW PART","2022-03-31T23:59:35","CPHO210028","Completed","2022-03-22T23:59:35","No","No","No","Internal"]
[null,null,null,24689,null,"129_23/3/2022 5:47:35 pm","2021-11-17T08:00:00","Observation","Ship Staff","Ship Staff Insp.","BOILER FO PR SWITCH LEAKING FROM THE DIAPHARAM","E/R - Boiler","Eng. / Strg. Comp.","Equipment Related","","","","","pr.switch renewed with spare.","2022-03-31T08:00:00","CPHO210027","Completed","2022-03-24T08:00:00","No","No","No","Internal","spare should be delivered on board. please update"]
[null,null,null,24687,null,"129_23/3/2022 5:41:42 pm","2021-11-17T08:00:00","Observation","Ship Staff","Ship Staff Insp.","AE 1&2 LO BACKWASH FILTER DIFF INDICATOR VALVES ARE LEAKING","E/R - Aux. Engine","Eng. / Strg. Comp.","Equipment Related","","","","","valves renewed.","2022-03-31T08:00:00","CPHO210023","Completed","2022-03-29T08:00:00","No","No","No","Internal","to check spare received or not. or cancelled your have to raise RO for 2022."]
[null,null,null,24690,null,"129_2/4/2022 5:02:50 pm","2022-02-01T08:00:00","Observation","Ship Staff","Ship Staff Insp.","INCINERATOR SLUDGE PUMP LEAKING","E/R - Aux. Engine","Eng. / Strg. Comp.","Equipment Related","","","","","leakage through seal arrested.","2022-05-01T08:00:00","","Completed","2022-04-11T08:00:00","No","No","No","Internal","to overhaul the pump, change the seal. if spare required please raise RO."]
[null,null,null,null,82551,"129_Fri Apr 29 2022 01:21:02 GMT+0800","2022-04-11T08:00:00","Observation","Ship Staff","Ship Staff Insp.","BALLAST PUMP #2 WORKING STAND CORRODED ,HOLED.","Miscellaneous","Eng. / Strg. Comp.","Equipment Related","","","","","NEW PLATE FOR STAND TO FABRICATE AND FIX.","2022-04-30T08:00:00","","Completed","2022-04-15T08:00:00","No","No","No","Internal"]
[null,null,null,null,95662,"129_Fri Apr 29 2022 01:25:43 GMT+0800","2022-04-07T08:00:00","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","\tSHIP SIDE\tSHIP SIDE STRUCTURE NEAR MAIN ENGINE L.O AUTOBACKWASH FILTER TO DERUST AND PAINT\t\t\t","Miscellaneous","Eng. / Strg. Comp.","Equipment Related","","","","","SHIP SIDE DERUSTED AND APPLIED WHITE PAINT.","2022-05-07T08:00:00","","Completed","2022-04-20T08:00:00","No","No","No","Internal"]
[null,null,null,null,41057,"129_Fri Apr 29 2022 01:28:16 GMT+0800","2022-04-07T08:00:00","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","CENTRAL COOLER SW INLET PIPE LEAKAGE TO RECTIFY.","E/R - Pipes/ valves & fittings","Eng. / Strg. Comp.","Equipment Related","","","","","PIPE REPLACED WITH SPARE SACRIFICIAL PIPE.","2022-04-27T08:00:00","","Completed","2022-04-28T08:00:00","No","No","No","Internal"]
[null,null,null,null,77543,"129_Fri Apr 29 2022 01:30:55 GMT+0800","2022-04-07T08:00:00","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","FRESH HYD TANK DISCHARGE VALVE LEAKING CAUSE PUMP REVERSE ROTATION WHEN STOP PERIODE","E/R - Pipes/ valves & fittings","Eng. / Strg. Comp.","Equipment Related","","","","","VALVE REPLACED WITH OVERHAULED ONE , PUMP DOES NOT ROTATE ON STOP CONDITION.","2022-04-22T08:00:00","","Completed","2022-04-20T08:00:00","No","No","No","Internal"]
[null,null,null,null,34832,"129_Fri Apr 29 2022 01:36:33 GMT+0800","2022-04-07T08:00:00","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","FWG CONDENSOR S.W PIPE LEAK TO RECTIFY AND PAINT THE NEW FABRICATED PIPE.","E/R - Pipes/ valves & fittings","Eng. / Strg. Comp.","Equipment Related","","","","","NEW PIPE FABRICATED ,FITTED AND PAINT APPLIED.","2022-04-22T08:00:00","","Completed","2022-04-11T08:00:00","No","No","No","Internal"]
[null,null,null,null,95792,"129_Fri Apr 29 2022 01:39:03 GMT+0800","2022-04-07T08:00:00","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","A/E JACKET COOLER SAVE ALL TO CLEAN AND PAINT","Miscellaneous","Eng. / Strg. Comp.","Equipment Related","","","","","SAVE ALL CHIPPED AND DERUSTED , PAINTING CARRIED OUT.","2022-04-27T08:00:00","","Completed","2022-04-25T08:00:00","No","No","No","Internal"]
[null,null,null,null,25102,"129_Fri Apr 29 2022 01:41:44 GMT+0800","2022-04-11T08:00:00","Defect","Ship Staff","Ship Staff Insp.","AUX.ENGINE L.T COOLER S.W INLET PIPE LEAKING.","E/R - Pipes/ valves & fittings","Eng. / Strg. Comp.","Equipment Related","","","","","LEAKING PIPE REPLACED WITH NEW ONE.","2022-04-30T08:00:00","","Completed","2022-04-27T08:00:00","No","No","No","Internal"]
[null,null,null,null,53563,"129_Fri Apr 29 2022 01:44:16 GMT+0800","2022-04-12T08:00:00","Defect","Ship Staff","Ship Staff Insp.","MAIN ENGINE L.O COOLER S.W INLET PIPE HAVE SOFT PATCH/ LEAKING.","E/R - Pipes/ valves & fittings","Eng. / Strg. Comp.","Equipment Related","","","","","SYSTEM ISOLATED AT ANCHORAGE , PIPE REMOVED AND WELD REPAIRS CARRIED OUT IN WORSHOP AND FITTED BACK.","2022-04-30T08:00:00","","Completed","2022-04-28T08:00:00","No","No","No","Internal"]
[null,null,null,24686,null,"129_23/3/2022 5:03:16 pm","2021-11-17T08:00:00","Observation","Ship Staff","Ship Staff Insp.","PRESS REGULATING VALVE NOT WORKING","E/R - Pipes/ valves & fittings","Eng. / Strg. Comp.","Equipment Related","","","","","F.O PRESSURE REGULATING VALVE REPLACED WITH NEW .","2022-03-31T08:00:00","CPHO210046","Completed","2022-05-01T08:00:00","No","No","No","Internal","to check spare received or not.  or cancelled your have to raise RO for 2022."]

{"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":3,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["Ship_ID","Ship_Name","FILE_NAME"]
["129","CAPE PHOENIX (04-04-2022)","129_1650351994643.xlsm"]

{"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"]