{"text_format":"1","workbook":"xlsx","n_sheets":20,"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"],"not_rendered":{"charts":0,"images":5,"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":23,"n_cols":28,"rows_kept":23,"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 ","2019-12-15",null,null,"Ship Name","ARTEMIS"]
[]
[]
[]
[]
[]
[null,null,null,null,"ID","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,null,null,"28/11/2019 3:37:05 PM","2019-08-20","Breakdown","Ship Staff","Ship Staff Insp.","AE 1 CENTRIFUGAL FILTER BODY DAMAGE ","Aux. Engine","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","WRONG SPARE RECEIVED UNDER RO mzhu 190208, NEW RO RAISED MZHU 190372, EQUIPMENT ISOLATED","2020-02-20","MZHU190372","Waiting spare",null,"No",null,null,"Internal"]
[null,null,null,null,null,"2019-01-12T13:47:33","2019-12-01","Observation","Ship Staff","Ship Staff Insp.","Aux Engine No. 1 Exhaust gas inlet to TC temperature sensor for remote indication  malfunction.","Aux. Engine","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable"," Monitoring TC inlet Temperature  by local temperature gauge  and requistion has been raised for spare part as vessel is out of stock for temperature sensor.","2020-01-30","MZHU 190380","Waiting spare",null,"No",null,null,"Internal"]
[null,null,null,null,null,"2019-12-02T18:31:21","2019-12-02","Observation","Ship Staff","Ship Staff Insp.","SHIP\"S PERSONNEL ELEVATOR OVER TRAVEL SWITCH  DAMAGE","Accommodation ","ISM Related","Equipment Related",null,null,"Not Applicable","Not Applicable","BROKERN SWITCH  REPAIRED BY USING LOCKTITE  AND REQUISITION HAS BEEN RAISED FOR NEW SWITCH.","2020-02-25","MZHU 190378","Waiting spare",null,"No",null,null,"Internal"]
[null,null,null,null,null,"15/12/2019 1:57:23 PM","2019-12-01","Breakdown","Ship Staff","Ship Staff Insp.","EL MOTOR DAMAGE FOR CALORIFIER  HOT WATER CIRCULATION PUMP","Aux. Mach.","MLC Related","Equipment Related",null,null,"Not Applicable","Not Applicable"," STANDBY PUMP IN OPERATION AND REQUISITION HAS BEEN RAISED FOR NEW EL MOTOR. ","2020-01-28","MZHU 190379","Waiting spare",null,"No",null,null,"Internal"]
[null,null,null,null,null,"15/12/2019 1:00:36 PM","2019-12-09","Observation","Ship Staff","Ship Staff Insp.","2 PORT CARGO TANK LEVEL GAUGE MALFUNCTIONING / ERROR, SHOWING INCORRECT READING.","Cargo Mach.","Cargo / Ballast Systems","Equipment Related",null,null,"Not Applicable","Not Applicable","INFORMED MUSSASINO (MAKER), AWAITING REPLY","2020-02-09",null,"Not Started",null,"No",null,null,"Internal"]
[null,null,null,null,null,"15/12/2019 6:58:26 PM","2019-12-10","Observation","Ship Staff","Ship Staff Insp.","CARGO /BALLAST VALVE REMOTE HYDRAULIC SYSTEM ACCUMULATOR NITROGEN CHARGING ADAPTOR PIN DAMAGE.","Miscellaneous","Cargo / Ballast Systems","Equipment Related",null,null,"Not Applicable","Not Applicable","RO RAISED FOR NEW ADAPTOR ","2020-02-10","MZHU 190391","Waiting spare",null,"No",null,null,"Internal"]

{"sheet":"Completed","index":1,"n_rows":51,"n_cols":28,"rows_kept":51,"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","22-9-2019",null,null,"Ship Name","ARTEMIS"]
[]
[]
[]
[]
[]
[null,null,null,null,"ID","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,null,null,"25/10/2019 1:06:27 PM","2019-10-13","Breakdown","Ship Staff","Ship Staff Insp.","IGG C.S.W. Pump  Electrical motor damaged","Inert Gas","Cargo / Ballast Systems","Equipment Related",null,null,"Not Applicable","Not Applicable"," requistion has been raised for new EL motor and damaged motor landed for rewinding.","2019-10-22","MZHU190331","Completed","2019-10-22","No",null,null,"Internal"]
[null,null,null,null,null,"30/10/2019 3:28:09 PM","2019-01-17","Observation","Ship Staff","Ship Staff Insp.","accomodation ladder air winch amain drive shaft broken along with gear teeth , bearing and bearing casing damage.","Deck Mach.","Mooring","Equipment Related",null,null,"Not Applicable","Not Applicable","welded the broken shaft andfabricated and arrangement for installation of new bearing along with bearing cover .Damaged gear teeth filled and bought back to original shape . ro has bben raised for new air winch ","2019-01-21",null,"Completed","2019-01-21","No",null,null,"Internal"]
[null,null,null,null,null,"30/10/2019 3:33:32 PM","2019-01-25","Deficiency","Ship Staff","Ship Staff Insp.","during closeup inspection of gangway wire stbd side noted strand of lifting wire damageed and byond acceptable limit","Deck Mach.","Mooring","Equipment Related",null,null,"Not Applicable","Not Applicable","wire replaced with spare wire on board. Ro has bben raised for new wire.","2019-02-15",null,"Completed","2019-01-26","No",null,null,"Internal"]
[null,null,null,null,null,"30/10/2019 3:36:37 PM","2019-07-04","Observation","Ship Staff","Ship Staff Insp.","motor room water tight door packing to be renewed.","Deck Pipe / Fittings","ISM Related","Equipment Related",null,null,"Not Applicable","Not Applicable","packing renewed.","2019-07-10",null,"Completed","2019-07-09","No",null,null,"Internal"]
[null,null,null,null,null,"30/10/2019 3:43:59 PM","2019-06-22","Observation","Ship Staff","Ship Staff Insp.","Prov. condenser end covesr corroded. ","Aux. Mach.","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","to be renwed in DD as per sample.","2019-11-10",null,"Completed","2019-09-16","No",null,null,"Internal"]
[null,null,null,null,null,"30/10/2019 3:40:49 PM","2019-06-21","Observation","Ship Staff","Ship Staff Insp.","stbd side Aux engine L.O bunker pipe holed.","Deck Pipe / Fittings","MARPOL Related","Equipment Related",null,null,"Not Applicable","Not Applicable","cold repair done and pipe will be renewed in DD","2019-09-16",null,"Completed","2019-09-16","No",null,null,"Internal"]
[null,null,null,null,null,"30/10/2019 3:47:14 PM","2019-06-22","Observation","Ship Staff","Ship Staff Insp.","MID ship crane not working ","Deck Mach.","ISM Related","Equipment Related",null,null,"Not Applicable","Not Applicable","informed office and Job will be done in DD","2019-11-10",null,"Completed","2019-09-16","No",null,null,"Internal"]
[null,null,null,null,null,"30/10/2019 3:50:34 PM","2019-07-05","Observation","Ship Staff","Ship Staff Insp.","crack on FPK tank vent line ","Deck Pipe / Fittings","Cargo / Ballast Systems","Equipment Related",null,null,"Not Applicable","Not Applicable","cold repair carried out , line will be renewed in DD","2019-07-05",null,"Completed","2019-07-05","No",null,null,"Internal"]
[null,null,null,null,null,"30/10/2019 3:56:50 PM","2019-07-11","Observation","Ship Staff","Ship Staff Insp.","port and stbd side sewage discharge pipe holed at deck penetration ","Deck Pipe / Fittings","MARPOL Related","Equipment Related",null,null,"Not Applicable","Not Applicable","To be renewed in DD","2019-09-16",null,"Completed","2019-09-16","No",null,null,"Internal"]
[null,null,null,null,null,"30/10/2019 3:59:28 PM","2019-07-28","Observation","Ship Staff","Ship Staff Insp.","ACB for AE 3 UVT time delay module faulty.","Aux. Engine","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Replaced time delay module ","2019-08-09","MZHU190188","Completed","2019-08-11","No",null,null,"Internal"]
[null,null,null,null,null,"30/10/2019 4:02:00 PM","2019-07-28","Observation","Ship Staff","Ship Staff Insp.","fresh water generator ejector pump El motor damaged.","Aux. Mach.","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Received new pump with EL motor and installed.","2019-08-10",null,"Completed","2019-08-11","No",null,null,"Internal"]
[null,null,null,null,null,"30/10/2019 4:04:00 PM","2019-08-21","Observation","Ship Staff","Ship Staff Insp.","No. 2 hfo Purifier El motor noisy.","Aux. Mach.","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","bearing to be renewed","2019-08-22",null,"Completed","2019-08-21","No",null,null,"Internal"]
[null,null,null,null,null,"30/10/2019 4:06:31 PM","2019-08-21","Observation","Ship Staff","Ship Staff Insp.","ME Cooling pump Noisy due to coupling bolt rubber damaged.","Aux. Mach.","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Coupling bolt rubber  replaced.","2019-08-21",null,"Completed","2019-08-21","No",null,null,"Internal"]
[null,null,null,null,null,"30/10/2019 4:09:17 PM","2019-08-22","Observation","Ship Staff","Ship Staff Insp.","No.2 AE fuel oil supply pump noisy and mech seal leaking.","Aux. Mach.","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","pump overhauled , bearing and Mech seal renewed.","2019-08-25",null,"Completed","2019-08-24","No",null,null,"Internal"]
[null,null,null,null,null,"30/10/2019 4:11:29 PM","2019-08-15","Observation","Ship Staff","Ship Staff Insp.","deck spray line near stbd manifold leaking","LSA / FFA","LSA / FFA Appliances","Equipment Related",null,null,"Not Applicable","Not Applicable","pipe to be renewd.","2019-08-25",null,"Completed","2019-08-25","No",null,null,"Internal"]
[null,null,null,null,null,"30/10/2019 4:13:54 PM","2019-09-02","Observation","Ship Staff","Ship Staff Insp.","mooring winch hyd oil leak obeserved form flexible hose.","Deck Mach.","Mooring","Equipment Related",null,null,"Not Applicable","Not Applicable","flexible hose renewed.","2019-09-02",null,"Completed","2019-09-02","No",null,null,"Internal"]
[null,null,null,null,null,"30/10/2019 4:15:54 PM","2019-09-02","Observation","Ship Staff","Ship Staff Insp.","LPG CSW pump discharge pipe ELBOW holed.","Aux. Mach.","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","New Elbow fabricated and instaled .","2019-09-03",null,"Completed","2019-09-03","No",null,null,"Internal"]
[null,null,null,null,null,"30/10/2019 4:18:17 PM","2019-07-03","Observation","Ship Staff","Ship Staff Insp.","gangway securing wire corroded and damage.","Deck Mach.","Mooring","Equipment Related",null,null,"Not Applicable","Not Applicable","wire renewed","2019-09-20",null,"Completed","2019-09-15","No",null,null,"Internal"]
[null,null,null,null,null,"30/10/2019 4:20:31 PM","2019-08-27","Observation","Ship Staff","Ship Staff Insp.","fwd fire wire winch motor not working ","Deck Mach.","Mooring","Equipment Related",null,null,"Not Applicable","Not Applicable","motor overhauled.","2019-09-06",null,"Completed","2019-09-03","No",null,null,"Internal"]
[null,null,null,null,null,"30/10/2019 4:22:36 PM","2019-08-27","Observation","Ship Staff","Ship Staff Insp.","Aft fire wire winch motor not working ","Deck Mach.","Mooring","Equipment Related",null,null,"Not Applicable","Not Applicable","motor overhauled.","2019-09-06",null,"Completed","2019-09-04","No",null,null,"Internal"]
[null,null,null,null,null,"30/10/2019 4:24:27 PM","2019-08-28","Observation","Ship Staff","Ship Staff Insp.","Stbd pilot ladder winch motor not working ","Deck Mach.","Mooring","Equipment Related",null,null,"Not Applicable","Not Applicable","motor overhauled","2019-09-06",null,"Completed","2019-09-05","No",null,null,"Internal"]
[null,null,null,null,null,"30/10/2019 4:26:21 PM","2019-08-26","Observation","Ship Staff","Ship Staff Insp.","fpk store bilge eductor valve leaking ","Deck Pipe / Fittings","Cargo / Ballast Systems","Equipment Related",null,null,"Not Applicable","Not Applicable","eductor valve overhauled","2019-09-04",null,"Completed","2019-09-03","No",null,null,"Internal"]
[null,null,null,null,null,"30/10/2019 4:29:26 PM","2019-08-21","Observation","Ship Staff","Ship Staff Insp.","fire bilge and ballast pump leaking from gland packing ( stud bolt damage)","LSA / FFA","LSA / FFA Appliances","Equipment Related",null,null,"Not Applicable","Not Applicable","shifted to ref man , job will be done in DD as inlet valve not holding.","2019-11-11",null,"Completed","2019-09-14","No",null,null,"Internal"]
[null,null,null,null,null,"30/10/2019 4:31:55 PM","2019-09-25","Observation","Ship Staff","Ship Staff Insp.","FWD mast  NAV LIGHT  switch faulty  3 pole on off on ","Nav & comm. equip.","Navigation","Equipment Related",null,null,"Not Applicable","Not Applicable","switch repaired ","2019-09-25",null,"Completed","2019-09-25","No",null,null,"Internal"]
[null,null,null,null,null,"30/10/2019 4:34:06 PM","2019-09-20","Observation","Ship Staff","Ship Staff Insp.","AE 2 uit 4 cylinder head CFW leak.","Aux. Engine","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","cylinder head replaced with overhauled spare cyl head.","2019-09-20",null,"Completed","2019-09-20","No",null,null,"Internal"]
[null,null,null,null,null,"30/10/2019 4:36:34 PM","2019-09-21","Observation","Ship Staff","Ship Staff Insp.","Mooring winch 4 a flexible hyd hose leaking","Deck Mach.","Mooring","Equipment Related",null,null,"Not Applicable","Not Applicable","flexible hose renewed.","2019-09-21",null,"Completed","2019-09-21","No",null,null,"Internal"]
[null,null,null,null,null,"30/10/2019 4:39:12 PM","2019-08-26",null,"Ship Staff","Ship Staff Insp.","3 pressure gauges and 2 temperature gauges faulty in ER ","Aux. Mach.","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","gauges replaced with ship stock and requistion has been raised to replanish stock","2019-10-05","MZHU190229","Completed","2019-10-12","No",null,null,"Internal"]
[null,null,null,null,null,"25/10/2019 12:56:31 PM","2019-09-09","Breakdown","Ship Staff","Ship Staff Insp.","Aux boiler feed water pump #1 impeller, mechanical seal damaged.","Boiler","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","repaired impellers and Mechanical seal converted to gland packing , pump tested and kept on stby.Requistion has been raised for the spare parts. mech seal received at singapore on 15/09/2019","2019-11-10","MZHU190267","Completed","2019-11-11","No",null,null,"Internal"]
[null,null,null,null,null,"25/10/2019 1:11:33 PM","2019-10-21","Breakdown","Ship Staff","Ship Staff Insp.","AC/DC converter for AE 2 control system damaged","Aux. Engine","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Requisition has been raised for the same","2019-11-10","MZHU190334","Completed","2019-11-09","No",null,null,"Internal"]
[null,null,null,null,null,"26/10/2019 7:12:18 PM","2019-10-26","Breakdown","Ship Staff","Ship Staff Insp.","Fan damaged of Meat room evaporator.","Elect. Mach. & Equip.","MLC Related","Equipment Related",null,null,"Not Applicable","Not Applicable","All meat shifted to  fish room urgent requisition has been raised for new fan set.","2019-11-05","MZHU 190335","Completed","2019-11-09","No",null,null,"Internal"]
[null,null,null,null,null,"25/10/2019 12:51:04 PM","2019-08-20","Breakdown","Ship Staff","Ship Staff Insp.","AE 1 L.O. centifugal fiter body cracked.","Aux. Mach.","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","WRONG PART RECIVED UNDER RO MZHU 190208  EQUIPMENT ISOLATED PART WILL BE REPLACED ONCE RECEIVE.","2019-12-20"," NEW RO RAISED MZHU190372","Completed","2019-11-25","No",null,null,"Internal"]
[null,null,null,null,null,"25/10/2019 12:42:11 PM","2019-08-20","Observation","Ship Staff","Ship Staff Insp.","fire and GS pump mechanical seal leak and submerged bearing  damage ","LSA / FFA","LSA / FFA Appliances","Equipment Related",null,null,"Not Applicable","Not Applicable","sapre received  on 15/11/2019,pump will be overhauled shortly.","2019-11-25","NZHU 190250","Completed","2019-11-25","No",null,null,"Internal"]
[null,null,null,null,null,"30/10/2019 2:52:57 PM","2019-10-29","Non Conformity","Ship Staff","Ship Staff Insp.","Stbd life boad davit pneumatic master valve faulty. ","LSA / FFA","LSA / FFA Appliances","Equipment Related",null,null,"Not Applicable","Not Applicable","NEW TYPE VALVE RECEIVED AND INSTALLED DURING DD","2019-11-10","MZHU 190337","Completed","2019-11-22","Yes",null,null,"Internal"]
[null,null,null,null,null,"25/10/2019 1:01:57 PM","2019-10-04","Breakdown","Ship Staff","Ship Staff Insp.","LPG  Ref C.S.W. Pump impeller, mech seal, line bearing and mouth rings damged","Aux. Mach.","Cargo / Ballast Systems","Equipment Related",null,null,"Not Applicable","Not Applicable","mech seal replaced with new spare mech seal.fabricated line bearing, mouth rings buildup and machined.Pump assembled and put into service. Requisition for complete  new pump has been created.","2019-12-27","MZHU 190302","Completed","2019-12-10","No",null,null,"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]
["LSA / FFA Appliances",8]
["MLC Related",4]
["Mooring",12]
["Navigation",5]
["MARPOL Related",9]
["ISM Related",7]
["ISPS Related",10]
["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":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":true,"merged":[]}
["TITLE","Type of deficiency_description","ID"]
["Breakdown",null,6]
["Condn of Class / Memo",null,5]
["Critical Equipment",null,4]
["Deficiency",null,1]
["Guarantee Claim",null,8]
["Non Conformity",null,2]
["Observation",null,3]
["Other",null,7]

{"sheet":"VIQrefno","index":6,"n_rows":379,"n_cols":3,"rows_kept":379,"cut":false,"hidden":true,"merged":[]}
["VIQ_ref_no","Risk Value of observation","ID"]
["1.1","Low",10160]
["1.10","Low",10169]
["1.11","Low",10170]
["1.12","Low",10171]
["1.13","Low",10172]
["1.14","Low",10173]
["1.15","Low",10174]
["1.16","Low",10176]
["1.17","Low",10177]
["1.18","Low",10178]
["1.19","Low",10179]
["1.2","Low",10161]
["1.20","Low",10180]
["1.21","",10181]
["1.22","Low",10183]
["1.23","Low",10184]
["1.24","Low",10185]
["1.25","Low",10186]
["1.26","Low",10187]
["1.3","Low",10162]
["1.4","Low",10163]
["1.5","Low",10164]
["1.6","Low",10165]
["1.7","Low",10166]
["1.8","Low",10167]
["1.9","Low",10168]
["1.99","High",16296]
["10.1","Medium",10354]
["10.10","High",10363]
["10.11","Medium",10364]
["10.12","Very High",10365]
["10.13","Very High",10366]
["10.14","Medium",10367]
["10.15","Low",10368]
["10.16","Very High",10369]
["10.17","Very High",10370]
["10.18","High",10371]
["10.19","Very High",10372]
["10.2","Low",10355]
["10.20","High",10373]
["10.21","Medium",10374]
["10.22","Low",10375]
["10.23","Medium",10376]
["10.24","Low",10377]
["10.25","Very High",10378]
["10.26","High",10379]
["10.27","Medium",10380]
["10.28","Low",10381]
["10.29","Medium",10382]
["10.3","Medium",10356]
["10.30","High",10383]
["10.31","Very High",10384]
["10.32","Very High",10385]
["10.33","High",10386]
["10.34","High",10387]
["10.35","Very High",10388]
["10.36","Very High",10389]
["10.37","Medium",10390]
["10.38","Medium",10391]
["10.39","High",10392]
["10.4","High",10357]
["10.40","Medium",10393]
["10.41","Medium",10394]
["10.42","Medium",10395]
["10.43","Medium",10396]
["10.44","Medium",10397]
["10.45","Very High",10398]
["10.46","High",10399]
["10.47","Medium",10400]
["10.48","High",10401]
["10.49","Medium",10402]
["10.5","Low",10358]
["10.50","High",10403]
["10.51","Low",10404]
["10.52","Medium",10405]
["10.53","Medium",10406]
["10.54","High",10407]
["10.55","Low",10408]
["10.6","Very High",10359]
["10.7","Medium",10360]
["10.8","Medium",10361]
["10.9","Medium",10362]
["10.99","High",10409]
["11.1","High",10313]
["11.10","Medium",10322]
["11.11","Very High",10323]
["11.12","Low",10324]
["11.13","Low",10325]
["11.14","Medium",10326]
["11.15","Low",10327]
["11.16","Low",10328]
["11.17","Low",10329]
["11.2","Medium",10314]
["11.3","Medium",10315]
["11.4","Very High",10316]
["11.5","Medium",10317]
["11.6","Medium",10318]
["11.7","High",10319]
["11.8","Low",10320]
["11.9","Low",10321]
["11.99","High",10330]
["12.1","High",10331]
["12.10","High",10341]
["12.11","High",10342]
["12.12","High",10343]
["12.13","High",10344]
["12.14","High",10345]
["12.15","High",10346]
["12.16","High",10347]
["12.17","High",10348]
["12.18","High",10349]
["12.19","High",10350]
["12.2","High",10332]
["12.20","High",10351]
["12.21","High",10352]
["12.3","High",10334]
["12.4","High",10335]
["12.5","High",10336]
["12.6","High",10337]
["12.7","High",10338]
["12.8","High",10339]
["12.9","High",10340]
["12.99","High",10353]
["2.1","Very High",10190]
["2.1.9","Very High",16297]
["2.10","Medium",10198]
["2.11","Medium",10199]
["2.12","Low",10200]
["2.13","Low",10201]
["2.14","Low",10202]
["2.15","Low",10203]
["2.16","Medium",10204]
["2.2","Medium",10191]
["2.3","High",10189]
["2.4","Medium",10192]
["2.5","Medium",10193]
["2.6","Low",10194]
["2.7","High",10195]
["2.8","High",10196]
["2.9","Medium",10197]
["2.99","High",10205]
["3.1","High",10206]
["3.2","Very High",10207]
["3.3","High",10208]
["3.4","Low",10188]
["3.5","Medium",10209]
["3.6","High",10210]
["3.7","Very High",10211]
["3.8","Very High",10212]
["3.99","High",10213]
["4.1","High",10214]
["4.10","High",10223]
["4.11","Medium",10224]
["4.12","Very High",10225]
["4.13","Very High",10226]
["4.14","Very High",10227]
["4.15","Very High",10228]
["4.16","Very High",10229]
["4.17","Very High",10230]
["4.18","Very High",10231]
["4.19","Low",10232]
["4.2","Medium",10215]
["4.20","Very High",10233]
["4.21","High",10234]
["4.22","Low",10235]
["4.23","High",10236]
["4.24","High",10237]
["4.25","Low",10238]
["4.26","Low",10239]
["4.27","High",10240]
["4.3","Medium",10216]
["4.4","High",10217]
["4.5","Very High",10218]
["4.6","Medium",10219]
["4.7","High",10220]
["4.8","Medium",10221]
["4.9","Medium",10222]
["4.99","High",10241]
["5.1","Very High",10410]
["5.10","High",10419]
["5.11","Low",10420]
["5.12","Medium",10421]
["5.13","High",10422]
["5.14","Very High",10423]
["5.15","Medium",10424]
["5.16","Medium",10425]
["5.17","Very High",10426]
["5.18","High",10427]
["5.19","Medium",10428]
["5.2","Very High",10411]
["5.20","Medium",10429]
["5.21","Medium",10430]
["5.22","High",10432]
["5.23","Very High",10433]
["5.24","Very High",10434]
["5.25","Medium",10435]
["5.26","Medium",10436]
["5.27","Medium",10437]
["5.28","Very High",10438]
["5.29","High",10439]
["5.3","Low",10412]
["5.30","High",10440]
["5.31","High",10441]
["5.32","High",10442]
["5.33","High",10443]
["5.34","Low",10444]
["5.35","Medium",10445]
["5.36","Low",10446]
["5.37","Low",10447]
["5.38","High",10448]
["5.39","Very High",10449]
["5.4","High",10413]
["5.40","Very High",10450]
["5.41","Very High",10451]
["5.42","Medium",10452]
["5.43","High",10453]
["5.44","High",10454]
["5.45","Medium",10457]
["5.46","Medium",10458]
["5.47","Low",10459]
["5.48","Medium",10460]
["5.5","Low",10414]
["5.6","Low",10415]
["5.7","Medium",10416]
["5.8","Medium",10417]
["5.9","Very High",10418]
["5.99","High",10461]
["6.1","Medium",10242]
["6.10","Low",10251]
["6.11","High",10252]
["6.12","Medium",10253]
["6.13","Low",10254]
["6.14","High",10255]
["6.15","High",10256]
["6.16","Very High",10257]
["6.17","Very High",10258]
["6.18","Medium",10259]
["6.19","Low",10260]
["6.2","High",10243]
["6.20","Medium",10261]
["6.21","High",10262]
["6.22","Medium",10263]
["6.3","Low",10244]
["6.4","High",10245]
["6.5","Low",10246]
["6.6","Medium",10247]
["6.7","High",10248]
["6.8","High",10249]
["6.9","Low",10250]
["6.99","High",10264]
["7.1","High",10265]
["7.10","High",10274]
["7.11","High",10275]
["7.12","High",10276]
["7.13","Medium",10277]
["7.14","Medium",10278]
["7.15","High",10279]
["7.16","High",10280]
["7.17","High",10281]
["7.2","High",10266]
["7.3","Low",10267]
["7.4","Low",10268]
["7.5","Low",10269]
["7.6","Medium",10270]
["7.7","Low",10271]
["7.8","High",10272]
["7.9","High",10273]
["7.99","High",10282]
["8.1","Very High",10462]
["8.10","Very High",10471]
["8.11","Very High",10472]
["8.12","Medium",10473]
["8.13","High",10474]
["8.14","Very High",10475]
["8.15","Medium",10476]
["8.16","Medium",10477]
["8.17","Very High",10478]
["8.18","High",10479]
["8.19","Very High",10480]
["8.2","Medium",10463]
["8.20","Very High",10481]
["8.21","Very High",10482]
["8.22","High",10483]
["8.23","Medium",10484]
["8.24","High",10485]
["8.25","High",10486]
["8.26","Medium",10487]
["8.27","Medium",10488]
["8.28","High",10489]
["8.29","Medium",10491]
["8.3","Medium",10464]
["8.30","Very High",10492]
["8.31","Very High",10493]
["8.32","High",10494]
["8.33","High",10495]
["8.34","Very High",10496]
["8.35","Very High",10497]
["8.36","Very High",10498]
["8.37","Very High",10500]
["8.38","Very High",10501]
["8.39","Very High",10502]
["8.4","Medium",10465]
["8.40","Very High",10503]
["8.41","Very High",10504]
["8.42","Very High",10505]
["8.43","Very High",10506]
["8.44","Medium",10508]
["8.45","High",10509]
["8.46","High",10510]
["8.47","Medium",10511]
["8.48","Very High",10512]
["8.49","Medium",10513]
["8.5","Medium",10466]
["8.50","High",10514]
["8.51","Very High",10515]
["8.52","Very High",10516]
["8.53","Very High",10517]
["8.54","High",10518]
["8.55","High",16222]
["8.56","Very High",16223]
["8.57","Very High",16224]
["8.58","Very High",16225]
["8.59","Medium",16226]
["8.6","Very High",10467]
["8.60","Medium",16227]
["8.61","Medium",16228]
["8.62","Very High",16229]
["8.63","Very High",16230]
["8.64","High",16231]
["8.65","Very High",16232]
["8.66","Medium",16233]
["8.67","Medium",16234]
["8.68","Medium",16235]
["8.69","Very High",16236]
["8.7","High",10468]
["8.70","Very High",16237]
["8.71","Medium",16238]
["8.72","Very High",16239]
["8.73","Medium",16240]
["8.74","High",16241]
["8.75","High",16242]
["8.76","Medium",16243]
["8.77","Medium",16244]
["8.78","Medium",16245]
["8.79","Very High",16246]
["8.8","High",10469]
["8.9","Very High",10470]
["8.99","High",16266]
["9.1","Low",10283]
["9.10","Medium",10292]
["9.11","Medium",10293]
["9.12","Medium",10294]
["9.13","Low",10295]
["9.14","Medium",10296]
["9.15","Medium",10297]
["9.16","High",10298]
["9.17","High",10299]
["9.18","Low",10300]
["9.19","Low",10301]
["9.2","Very High",10284]
["9.20","Medium",10302]
["9.21","Medium",10303]
["9.22","Low",10304]
["9.23","Low",10305]
["9.24","Medium",10306]
["9.25","Low",10307]
["9.26","Low",10308]
["9.27","Low",10309]
["9.28","Medium",10310]
["9.29","Low",10311]
["9.3","Very High",10285]
["9.4","High",10286]
["9.5","High",10287]
["9.6","Low",10288]
["9.7","Medium",10289]
["9.8","Medium",10290]
["9.9","Medium",10291]
["9.99","High",10312]

{"sheet":"Equipment_list","index":7,"n_rows":21,"n_cols":3,"rows_kept":21,"cut":false,"hidden":true,"merged":[]}
["TITLE","Equipment_list_description","ID"]
["Accommodation ",null,12]
["Air Comp.",null,8]
["Aux. Engine",null,4]
["Aux. Mach.",null,7]
["Boiler",null,5]
["Cargo Mach.",null,13]
["Critical Equip.",null,16]
["Deck Mach.",null,18]
["Deck Pipe / Fittings",null,20]
["Documentation",null,21]
["Elect. Mach. & Equip.",null,10]
["Hull & Tanks",null,19]
["Inert Gas",null,14]
["LSA / FFA",null,17]
["Main Engine ",null,3]
["Miscellaneous",null,22]
["Nav & comm. equip.",null,11]
["ER Pipes, valves & fittings",null,9]
["Purifier",null,6]
["Mooring Mach.",null,15]

{"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":15,"n_cols":2,"rows_kept":15,"cut":false,"hidden":true,"merged":[]}
["TITLE","ID"]
["Bunkering Audit",14]
["Others (Eg. Insurance etc.)",12]
["Flag State Insp.",5]
["Ship Staff Insp.",15]
["IT Audit",10]
["OM Insp. (Eg. SIRE, CDI etc.)",6]
["ISM Audit",2]
["ISPS Audit",3]
["MLC Audit",1]
["Mooring Audit",9]
["Nav Audit / Verification",8]
["PSC Inspection",4]
["Suptd. Insp.",13]
["Terminal Insp.",11]

{"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":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":true,"merged":[]}
["TITLE","Observer_code_description","ID"]
["Class Surveyor",null,4]
["Others (Eg. Insurance etc.)",null,9]
["FSC Inspector",null,5]
["Owner / Marine / Tech. Suptd.",null,3]
["PSC Insp.",null,6]
["Ship Staff",null,2]
["SIRE / CDI Insp.",null,8]
["Terminal Insp.",null,7]

{"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"]
["40","ARTEMIS","40_1571737640692.xlsm"]