{"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":28,"n_cols":28,"rows_kept":28,"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","26-Oct-2019",null,null,"Ship Name","A SYMPHONY"]
[]
[]
[]
[]
[]
[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,4345,"25/10/2019 8:00:28 PM","2019-07-14","Observation","Ship Staff","Ship Staff Insp.","AIS is showing “RX3 channel 3 malfunction”. Alarm not resetting","Nav & comm. equip.","Navigation","Equipment Related","4.7.11","High","Not Applicable","Not Applicable","The system is working ok, Tx and Rx operation tested and data verified.  The above fault is not getting reset. AIS to be upgraded,  RO raised.","2019-10-15","ASYM190192","Waiting spare",null,"No","No","No","Internal"]
[null,null,null,null,4346,"25/10/2019 8:06:41 PM","2019-07-17","Observation","Ship Staff","Ship Staff Insp.","VECS System Out of Order","Cargo Mach.","Cargo / Ballast Systems","Equipment Related",8.17,"Low","Not Applicable","Not Applicable","Sensors Not Working - PO raised, To be renewed once received","2019-09-30","ASYM190121","Waiting spare",null,"No","No","No","Internal"]
[null,null,null,null,4347,"25/10/2019 8:10:20 PM","2019-08-08","Observation","Ship Staff","Ship Staff Insp.","1 Number Mooring Wire W2-P Eye found damaged with broken strands.","Mooring Mach.","Mooring","Equipment Related",9.17,"High","Not Applicable","Not Applicable","Mooring wire to be renewed - RO raised. No Spare onboard","2019-09-15","ASYM190159","Waiting spare",null,"No","No","No","Internal"]
[null,null,null,null,4349,"25/10/2019 8:17:50 PM","2019-09-16","Observation","Ship Staff","Ship Staff Insp.","Manifold Spill tank gratings - Port and Stbd are in poor condition, require renewal. ","Deck Pipe / Fittings","MARPOL Related","Human Error",6.6,"Medium","Not Applicable","Not Applicable","Gratings needs to be renewed.","2019-11-30","ASYM190187","Waiting spare",null,"No","No","No","Internal"]
[null,null,null,null,4350,"25/10/2019 8:23:50 PM","2019-09-27","Observation","Ship Staff","Ship Staff Insp.","No.4 Steam coil for 5P COT tank heating found leaking.","Hull & Tanks","Cargo / Ballast Systems","Equipment Related",8.15,"High","Not Applicable","Not Applicable","Tried draining the heating coils, some amount of sludge came out from the heating coils. Coil blanked. Pressure test of coil to be planned.","2019-12-30",null,"In progress",null,"No","No","No","Internal"]
[null,null,null,null,4351,"25/10/2019 8:20:34 PM","2019-09-16","Observation","Ship Staff","Ship Staff Insp.","Hydraulic pipeline for deck machinery is thinned down near the U-clamps in several places and requires renewal","Deck Mach.","Mooring","Equipment Related",11.4,"Very High","Not Applicable","Not Applicable","Stbd side windlass leaking section renewed.","2019-11-30","ASYM190185","In progress",null,"No","No","No","Internal"]
[null,null,null,null,4352,"25/10/2019 8:27:40 PM","2019-09-27","Observation","Ship Staff","Ship Staff Insp.","No 4 Steam coil for 5S COT tank heating found leaking.","Hull & Tanks","Cargo / Ballast Systems","Equipment Related",8.15,"High","Not Applicable","Not Applicable","Tried draining the heating coils, some amount of sludge came out from the heating coils. Coil blanked. Pressure test of coil to be planned.","2019-12-30",null,"In progress",null,"No","No","No","Internal"]
[null,null,null,null,4353,"25/10/2019 8:32:14 PM","2019-09-28","Observation","Ship Staff","Ship Staff Insp.","Mono rail crane both hooks not operational.","Deck Mach.","ISM Related","Equipment Related",8.5,"Very High","Not Applicable","Not Applicable","Voltage module rectifier to be replaced.","2019-10-30","ASYM190199","Waiting spare",null,"No","No","No","Internal"]
[null,null,null,null,4354,"25/10/2019 9:40:00 PM","2019-09-23","Observation","Ship Staff","Nav Audit / Verification","Simultaneous comparison of GPS position on ECDIS cannot be done since only one GPS feed is available at any time. Changeover switch is provided for 2nd GPS. ","Nav & comm. equip.","Navigation","Equipment Related",4.17,"Very High","Not Applicable","Not Applicable","Laying of LAN cable has been done & service engineer is planned attend to connection during annual servicing of ECDIS.","2019-12-22",null,"In progress",null,"No","No","No","Internal"]
[null,null,null,null,null,"2019-11-04T14:55:37","2019-10-30","Breakdown","Ship Staff","Ship Staff Insp.","MF/HF Radio unit not working. Checked the antenna unit on the compass deck and components on the PCB which is found damaged(burnt).","Nav & comm. equip.","Communication","Equipment Related",4.21,"High","Not Applicable","Not Applicable","Requisition raised for spare PCB. Technician to be arranged for attending to repair of MF/HF unit.","2019-12-01","ASYM195096, ASYM190211","Waiting spare",null,"No",null,null,"Internal"]
[null,null,null,null,null,"15/11/2019 7:04:35 PM","2019-11-13","Breakdown","Ship Staff","Ship Staff Insp.","Accomodation A/C fan found tripping frequently.","Accommodation ","Eng. / Strg. Comp.","Equipment Related",10.32,"Very High","Not Applicable","Not Applicable","Investigated and found relay for A/C fan motor malfunctioning. PO raised for MOTOR RELAY FOR AC FAN MOTOR","2019-12-20","ASYM190214","Waiting spare",null,"No",null,null,"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","26-9-2019",null,null,"Ship Name","A SYMPHONY"]
[]
[]
[]
[]
[]
[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,4355,"24/10/2019 4:26:00 PM","2019-09-27","Observation","Ship Staff","Ship Staff Insp.","No.2 Boiler main feed pump pressure regulating line leaking and temporarily repaired.","ER Pipes, valves & fittings","Eng. / Strg. Comp.","Equipment Related",10.32,"Very High","Not Applicable","Not Applicable","Need to be removed from the place and fabricate the segment of the pipe.","2019-10-30",null,"Completed","2019-10-05","No","No","No","Internal"]
[null,null,null,null,4356,"24/10/2019 4:37:41 PM","2019-08-01","Observation","Ship Staff","Ship Staff Insp.","Safety rings are missing for fresh water tank ladders","ER Pipes, valves & fittings","Eng. / Strg. Comp.","Inappropriate Procedure",5.47,"Medium","Not Applicable","Not Applicable","Safety rings to be fabricated","2019-10-30",null,"Completed","2019-10-03","No","No","No","Internal"]
[null,null,null,null,4357,"24/10/2019 5:15:04 PM","2019-08-01","Observation","Ship Staff","Ship Staff Insp.","Stbd Windlass Speed Switch High Pressure Line Holed.","Mooring Mach.","Mooring","Equipment Related",9.14,"Medium","Not Applicable","Not Applicable","Line renewed. Rectified.","2019-08-30",null,"Completed","2019-08-08","No","No","No","Internal"]
[null,null,null,null,4358,"24/10/2019 5:19:08 PM","2019-08-01","Observation","Ship Staff","Ship Staff Insp.","Mooring Winch MW2 Pressure constant valve observed with pin hole leakage.","Mooring Mach.","Mooring","Equipment Related",9.14,"Medium","Not Applicable","Not Applicable","Valve opened and O-rings renewed","2019-08-30",null,"Completed","2019-08-07","No","No","No","Internal"]
[null,null,null,null,4359,"24/10/2019 4:59:53 PM","2019-07-20","Observation","Ship Staff","Ship Staff Insp.","Port and Stbd Ligeboats Air Bottle Pressure Less than the required working pressure","LSA / FFA","LSA / FFA Appliances","Human Error",5.28,"Very High","Not Applicable","Not Applicable","Both Lifeboats air bottle (Total 6 Btls) topped up to working pressure of 200 bars.","2019-07-22",null,"Completed","2019-07-22","No","No","No","Internal"]
[null,null,null,null,4360,"24/10/2019 5:24:07 PM","2019-07-22","Observation","Ship Staff","Ship Staff Insp.","Mooring Wires and Fire Wires Lubrication not adequate, dust accumulated on wires, carried over from Dry Dock. ","Mooring Mach.","Mooring","Human Error",9.17,"High","Not Applicable","Not Applicable","All Mooring Wires, Fire wires Greasing and Inspection completed","2019-08-30",null,"Completed","2019-08-07","No","No","No","Internal"]
[null,null,null,null,4361,"24/10/2019 5:37:24 PM","2019-08-01","Observation","Ship Staff","Ship Staff Insp.","Air Vent Mesh Covers Of FW Tk (P), DW Tk (P) and DW Tk (S) wasted. Mesh condition Poor.","Deck Pipe / Fittings","Structural Condn. / WT integrity ","Human Error",11.17,"Low","Not Applicable","Not Applicable","Vent Mesh Covers fabricated and fitted, Mesh renewed.","2019-08-30",null,"Completed","2019-08-06","No","No","No","Internal"]
[null,null,null,null,4362,"24/10/2019 5:47:21 PM","2019-07-17","Observation","Ship Staff","Ship Staff Insp.","Air Vents for ballast Tanks - 10 pcs heavy corroded internally","Deck Pipe / Fittings","Cargo / Ballast Systems","Human Error",1.17,"Low","Not Applicable","Not Applicable","All 10 Pcs vent heads renewed with new ones.","2019-08-30",null,"Completed","2019-08-26","No","No","No","Internal"]
[null,null,null,null,4363,"24/10/2019 8:08:48 PM","2019-07-20","Non Conformity","Ship Staff","Ship Staff Insp.","Port Side Lifeboat Deck PA Announcement Speaker Not Working.","Elect. Mach. & Equip.","Emgcy. Systems","Equipment Related",11.1,"High","Not Applicable","Not Applicable","PA Announcement Speaker received and renewed.","2019-08-30","ASYM190151","Completed","2019-08-26","No","No","No","Internal"]
[null,null,null,null,4364,"24/10/2019 8:16:26 PM","2019-08-16","Observation","Ship Staff","Ship Staff Insp.","WBT 3S - 128 - Hydraulic soenoid valve block not working. Unable to operate from CCR.","Cargo Mach.","Cargo / Ballast Systems","Equipment Related",8.11,"Medium","Not Applicable","Not Applicable","Valve Block opened and overhauled. However, started leaking after repairs. Leak to be rectified.\n\nCompleted 20th Aug 2019.","2019-08-30",null,"Completed","2019-08-20","No","No","No","Internal"]
[null,null,null,null,4365,"24/10/2019 8:27:53 PM","2019-08-25","Observation","Ship Staff","Ship Staff Insp.","Elbow for Emergency Inerting Equipments for WBTs to be prepared for Stand Pipe connection to Breather Valve","Cargo Mach.","Cargo / Ballast Systems","Equipment Related",8.3000000000000007,"Very High","Not Applicable","Not Applicable","Fabricated and Kept in Midship Store","2019-09-30",null,"Completed","2019-09-03","No","No","No","Internal"]
[null,null,null,null,4366,"24/10/2019 9:00:28 PM","2019-08-31","Observation","Owner / Marine / Tech. Suptd.","IT Audit","Gangway not having Lifebuoy fitted with light and line","LSA / FFA","LSA / FFA Appliances","Knowledge Based",5.47,"Medium","Not Applicable","Not Applicable","Portable 1 set of lifebuoy prepared with light and line to comply with VIQ requirement","2019-11-30",null,"Completed","2019-09-02","No","No","No","Internal"]
[null,null,null,null,4367,"24/10/2019 8:32:45 PM","2019-08-25","Observation","Ship Staff","Ship Staff Insp.","Foc'le Deck 2 Nos Deck Stand Rollers and Fwd 1 no. horizontal roller difficult to rotate with hand.\t","Mooring Mach.","Mooring","Equipment Related",9.18,"Low","Not Applicable","Not Applicable","Same Freed up and Greasing done","2019-09-06",null,"Completed","2019-09-02","No","No","No","Internal"]
[null,null,null,null,4368,"24/10/2019 11:28:32 PM","2019-08-31","Observation","Owner / Marine / Tech. Suptd.","Nav Audit / Verification","Course Recorder Rudder angle indicator stylus not printing on the recording paper","Nav & comm. equip.","Navigation","Equipment Related",4.7,"High","Not Applicable","Not Applicable","Rectified","2019-11-30",null,"Completed","2019-09-01","No","No","No","Internal"]
[null,null,null,null,4369,"24/10/2019 11:33:21 PM","2019-08-31","Observation","Owner / Marine / Tech. Suptd.","Nav Audit / Verification","Safety Contours setting not correctly mentioned in passage plan sheet - B considering Company's UKC policy for ocean and coastal waters","Nav & comm. equip.","Navigation","Human Error",4.1500000000000004,"Very High","Not Applicable","Not Applicable","Correct Settings mentioned in Passage plan - Rectified","2019-11-30",null,"Completed","2019-09-01","No","No","No","Internal"]
[null,null,null,null,4370,"24/10/2019 11:40:21 PM","2019-08-31","Observation","Owner / Marine / Tech. Suptd.","Nav Audit / Verification","Risk assessment not prepared for entering Port for the first time (Port Sudan, Suez canal Transit)","Nav & comm. equip.","Navigation","Human Error",7.9,"High","Not Applicable","Not Applicable","RA Prepared and discussed.","2019-11-30",null,"Completed","2019-09-01","No","No","No","Internal"]
[null,null,null,null,4371,"24/10/2019 11:43:49 PM","2019-08-31","Observation","Owner / Marine / Tech. Suptd.","Nav Audit / Verification","Conn changeover from Master to OOW not entered for arrival Suez anchorage on 22.08.2019","Nav & comm. equip.","Navigation","Human Error",4.2,"Medium","Not Applicable","Not Applicable","Entry made - Rectified","2019-11-30",null,"Completed","2019-09-01","No","No","No","Internal"]
[null,null,null,null,4372,"24/10/2019 11:53:48 PM","2019-08-31","Observation","Owner / Marine / Tech. Suptd.","IT Audit","Oxygen and Acetylene bottles to have indications for \"In use\", \"Full\" and \"Empty\"","Miscellaneous","Eng. / Strg. Comp.","Human Error",5.26,"Medium","Not Applicable","Not Applicable","Completed","2019-11-30",null,"Completed","2019-09-01","No","No","No","Internal"]
[null,null,null,null,4373,"25/10/2019 12:02:38 AM","2019-08-31","Observation","Owner / Marine / Tech. Suptd.","IT Audit","Eyepads in Pump room not highlighted and marked with SWL","Deck Pipe / Fittings","Cargo / Ballast Systems","Human Error",8.5,"Very High","Not Applicable","Not Applicable","Pump room eyepads highlighted and marked with SWL, Foc'le and E/R to be done","2019-09-30",null,"Completed","2019-09-04","No","No","No","Internal"]
[null,null,null,null,4374,"24/10/2019 11:49:11 PM","2019-08-31","Observation","Owner / Marine / Tech. Suptd.","IT Audit","Gymnasium to be cleaned and cleared of all stores and spares kept in it.","Accommodation ","General Appearance","Human Error",11.13,"Low","Not Applicable","Not Applicable","All these stores received in suez just before the audit. All items cleaned and gymnasium squarred up after dep suez","2019-11-30",null,"Completed","2019-09-02","No","No","No","Internal"]
[null,null,null,null,4375,"25/10/2019 12:07:35 AM","2019-08-31","Observation","Ship Staff","Ship Staff Insp.","Angle Indicator For gangway to be placed at the fwd end so that it is visible from deck level. Current indicator placed at middle level of the gangway","Deck Mach.","ISM Related","Equipment Related",5.47,"Medium","Not Applicable","Not Applicable","New Gangway angle indicators being fabricated to put at ends.","2019-09-30",null,"Completed","2019-09-03","No","No","No","Internal"]
[null,null,null,null,4376,"25/10/2019 12:10:41 AM","2019-08-31","Observation","Owner / Marine / Tech. Suptd.","IT Audit","MSDS Missing for newly received paint for suez","Documentation","Cert. & Docu.","Human Error",5.46,"Medium","Not Applicable","Not Applicable","MSDS not provided by supplier. Request has been made\t","2019-11-30",null,"Completed","2019-09-03","No","No","No","Internal"]
[null,null,null,null,4377,"25/10/2019 12:15:44 AM","2019-08-31","Observation","Owner / Marine / Tech. Suptd.","IT Audit","Foc'le door weathertight door dog bolts to be freed up and some external W/T doors not having Open / Shut marking on the dog bolts","Deck Pipe / Fittings","ISM Related","Human Error",11.6,"Medium","Not Applicable","Not Applicable","Foc'le door doglegs freed up and markings in progress","2019-11-30",null,"Completed","2019-09-04","No","No","No","Internal"]
[null,null,null,null,4378,"25/10/2019 1:37:38 PM","2019-08-31","Observation","Owner / Marine / Tech. Suptd.","Nav Audit / Verification","Time and Position for changeover to hand steering from auto pilot and vice versa for 22.08.2019 Arrival Suez anchorage, 24.08.2019 Dep Suez anchorage and 24.08.2019 Dep Suez transit not entered in bridge bell book","Nav & comm. equip.","Navigation","Human Error",4.0999999999999996,"High","Not Applicable","Not Applicable","Entry made and corrected","2019-11-30",null,"Completed","2019-09-01","No","No","No","Internal"]
[null,null,null,null,4379,"25/10/2019 1:40:51 PM","2019-08-31","Observation","Owner / Marine / Tech. Suptd.","IT Audit","Provision stores (Wet and Dry) requires cleaning, tidying up and arrangemnt of provisions","Accommodation ","General Appearance","Human Error",11.13,"Low","Not Applicable","Not Applicable","New provision received in Suez being arranged.","2019-11-30",null,"Completed","2019-09-04","No","No","No","Internal"]
[null,null,null,null,4380,"25/10/2019 1:59:04 PM","2019-06-06","Non Conformity","Ship Staff","Ship Staff Insp.","EM Log not working, as result Speed indicator on the wheel house and bridge wings also not working.","Nav & comm. equip.","Navigation","Equipment Related","4.7.54","High","Not Applicable","Not Applicable","Rectified","2019-09-06","ASYM190034","Completed","2019-09-03","No","No","No","Internal"]
[null,null,null,null,4381,"25/10/2019 2:25:58 PM","2019-07-22","Observation","Ship Staff","Ship Staff Insp.","Deck Hydraulic boxes packing missing.","Deck Pipe / Fittings","Structural Condn. / WT integrity ","Equipment Related",8.11,"Medium","Not Applicable","Not Applicable","Packings received as per PO and Renewed.","2019-09-15","ASYM190144","Completed","2019-09-15","No","No","No","Internal"]
[null,null,null,null,4382,"25/10/2019 2:37:13 PM","2019-09-03","Observation","Ship Staff","Ship Staff Insp.","Branch Return Line for Mooring Winch MW3 found pin holed and leaking","Deck Pipe / Fittings","Mooring","Equipment Related",11.4,"Very High","Not Applicable","Not Applicable","Hydraulic branch Line for MW3 renewed with New one fabricated onboard","2019-09-15",null,"Completed","2019-09-05","No","No","No","Internal"]
[null,null,null,null,4383,"25/10/2019 3:00:15 PM","2019-09-03","Observation","Ship Staff","Ship Staff Insp.","MW No 2 Gratings damaged and not secured to the platform","Deck Pipe / Fittings","Mooring","Equipment Related",11.3,"Medium","Not Applicable","Not Applicable","Railing repaired and Securing arrangement made","2019-09-15",null,"Completed","2019-09-05","No","No","No","Internal"]
[null,null,null,null,4384,"25/10/2019 3:02:43 PM","2019-09-03","Observation","Ship Staff","Ship Staff Insp.","Hydraulic Returm Line near Hose handling Crane found leaking  with pin hole","Deck Pipe / Fittings","Mooring","Equipment Related",11.4,"Very High","Not Applicable","Not Applicable","Line Renewed Flange to Flange","2019-09-15",null,"Completed","2019-09-05","No","No","No","Internal"]
[null,null,null,null,4385,"25/10/2019 3:05:01 PM","2019-09-12","Observation","Ship Staff","Ship Staff Insp.","Hydraulic Return Line for Deck Machinery found leaking and holed at No 7 COT area below U-clamp. ","Deck Pipe / Fittings","Mooring","Equipment Related",11.4,"Very High","Not Applicable","Not Applicable","\tRetuen Line Straight section and connecting Elbow section renewed with new one","2019-09-15",null,"Completed","2019-09-12","No","No","No","Internal"]
[null,null,null,null,4386,"25/10/2019 3:08:29 PM","2019-08-31","Non Conformity","Owner / Marine / Tech. Suptd.","IT Audit","Many pumps near bottom flat of engine room not fitted with guards","Elect. Mach. & Equip.","Eng. / Strg. Comp.","Equipment Related",10.27,"Medium","Not Applicable","Not Applicable","Job done","2019-11-30",null,"Completed","2019-09-04","No","No","No","Internal"]
[null,null,null,null,4387,"25/10/2019 3:19:03 PM","2019-09-04","Observation","Ship Staff","Ship Staff Insp.","Hawse Pipe Covers partially wasted - Hinges and locks not fixing in position correctly","Mooring Mach.","Mooring","Equipment Related",9.1999999999999993,"Very High","Not Applicable","Not Applicable","Port & Stbd side Hawse Pipe cover and Hinges renewed, primered & painted.","2019-09-30",null,"Completed","2019-09-30","No","No","No","Internal"]
[null,null,null,null,4388,"25/10/2019 3:25:19 PM","2019-09-16","Observation","Ship Staff","Ship Staff Insp.","Foam Hydrant - 2 Nos leaking near No 7 And No 6 Isolation valves","LSA / FFA","LSA / FFA Appliances","Equipment Related",5.4,"High","Not Applicable","Not Applicable","Hydrants overhauled & tested. No leaks found.","2019-09-30",null,"Completed","2019-09-30","No","No","No","Internal"]
[null,null,null,null,4389,"25/10/2019 3:48:04 PM","2019-08-31","Non Conformity","Owner / Marine / Tech. Suptd.","IT Audit","Pumproom Blowers, mastriser ladders more than 3 mtrs in heighty with no Safety rings","Deck Pipe / Fittings","ISM Related","Equipment Related",5.47,"Medium","Not Applicable","Not Applicable","Safety rings fabricated and fitted.","2019-11-30",null,"Completed","2019-10-02","No","No","No","Internal"]
[null,null,null,null,4390,"25/10/2019 7:46:43 PM","2019-09-27","Observation","Ship Staff","Ship Staff Insp.","Steam Main inlet valve for 6P COT found frozen in open condition.","Deck Pipe / Fittings","Cargo / Ballast Systems","Equipment Related",8.15,"High","Not Applicable","Not Applicable","Valve replaced with spare available onboard","2019-11-30",null,"Completed","2019-10-15","No","No","No","Internal"]
[null,null,null,null,4391,"25/10/2019 7:55:59 PM","2019-10-16","Observation","Ship Staff","Ship Staff Insp.","Pump room blower no.2 making abnormal sound\t","Elect. Mach. & Equip.","ISM Related","Equipment Related",5.18,"High","Not Applicable","Not Applicable","Checked and overhauled.","2019-10-20",null,"Completed","2019-10-18","No","No","No","Internal"]
[null,null,null,null,4392,"25/10/2019 7:35:23 PM","2019-09-27","Observation","Ship Staff","Ship Staff Insp.","No.2 Boiler Main Feed pump pressure regulating line leaking and temporarily repaired.","ER Pipes, valves & fittings","Eng. / Strg. Comp.","Equipment Related",10.29,"Medium","Not Applicable","Not Applicable","New pipe fabricated the leaking segment of the pipe renewed.","2019-10-30",null,"Completed","2019-10-05","No","No","No","Internal"]
[null,null,null,null,4393,"25/10/2019 7:41:29 PM","2019-09-16","Observation","Ship Staff","Ship Staff Insp.","No.2 COP governor is not responding from CCR at times. To be inspected & rectified","Cargo Mach.","Cargo / Ballast Systems","Equipment Related",8.8000000000000007,"Medium","Not Applicable","Not Applicable","Job completed","2019-09-30",null,"Completed","2019-10-07","No","No","No","Internal"]
[null,null,null,null,4394,"25/10/2019 7:43:57 PM","2019-10-11","Observation","Ship Staff","Ship Staff Insp.","Main engine jacket cooling water pump no.1 mechanical seal found leaking","Aux. Mach.","Eng. / Strg. Comp.","Equipment Related",10.29,"Medium","Not Applicable","Not Applicable","Renewed the seal","2019-10-16",null,"Completed","2019-10-15","No","No","No","Internal"]
[null,null,null,null,4395,"25/10/2019 7:38:52 PM","2019-09-16","Observation","Ship Staff","Ship Staff Insp.","Few cargo & ballast tank valve indicators in CCR panel hunting. To be inspected and rectified","Cargo Mach.","Cargo / Ballast Systems","Equipment Related",8.11,"Medium","Not Applicable","Not Applicable","Job completed","2019-11-30",null,"Completed","2019-10-05","No","No","No","Internal"]
[null,null,null,null,4396,"25/10/2019 7:54:06 PM","2019-10-16","Observation","Ship Staff","Ship Staff Insp.","Pump room blower no.1 making abnormal sound","Elect. Mach. & Equip.","ISM Related","Equipment Related",5.18,"High","Not Applicable","Not Applicable","Checked and overhauled.","2019-10-20",null,"Completed","2019-10-17","No","No","No","Internal"]
[null,null,null,null,null,"29/10/2019 5:34:54 PM","2019-08-31","Observation","Owner / Marine / Tech. Suptd.","IT Audit","Gangway not having Lifebuoy fitted with light and line","LSA / FFA","LSA / FFA Appliances","Knowledge Based",5.47,"Medium","Not Applicable","Not Applicable","Portable 1 set of lifebuoy prepared with light and line to comply with VIQ requirement. LSA plan for additional Lifebuoy endorsed by CLASS during external audits on 01-Nov-2019.","2019-11-29",null,"Completed","2019-11-01","No",null,null,"Internal"]
[null,null,null,null,null,"24/10/2019 4:12:11 PM","2019-09-28","Deficiency","Ship Staff","Ship Staff Insp.","Aft ETA Brake band support found corroded ","Mooring Mach.","Emgcy. Systems","Equipment Related",9.2799999999999994,"Medium","Not Applicable","Not Applicable","Aft ETA brake band supports renewed.","2019-11-30","ASYM190208","Completed","2019-11-15","No",null,null,"Internal"]
[null,null,null,null,null,"25/10/2019 8:13:22 PM","2019-08-31","Observation","Owner / Marine / Tech. Suptd.","IT Audit","Fresh water testing kit onboard is from the previous management and some chemical used for testing has expired.","Miscellaneous","MLC Related","External Factors",null,null,"Not Applicable","Not Applicable","New Fresh water test received and onboard test carried out","2019-11-30","ASYM190157","Completed","2019-11-03","No",null,null,"Internal"]
[null,null,null,null,null,"15/11/2019 6:57:14 PM","2019-11-13","Breakdown","Ship Staff","Ship Staff Insp.","Aux. Boiler burner No3 not firing.Flame trouble alarm is activated.","Boiler","Eng. / Strg. Comp.","Equipment Related",10.32,"Very High","Not Applicable","Not Applicable","Flame eye replaced for No3 burner, tested and found working satisfactory.","2019-11-20",null,"Completed","2019-11-14","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":427,"n_cols":3,"rows_kept":427,"cut":false,"hidden":true,"merged":[]}
["VIQ_ref_no","Risk Value of observation","ID"]
["1.1","Low",8243]
["1.10","Low",8252]
["1.11","Low",8253]
["1.12","Low",8254]
["1.13","Low",8255]
["1.14","Low",8256]
["1.15","Low",8257]
["1.16","Low",8259]
["1.17","Low",8260]
["1.18","Low",8261]
["1.19","Low",8262]
["1.2","Low",8244]
["1.20","Low",8263]
["1.21","Low",8265]
["1.22","Low",8266]
["1.23","Low",8267]
["1.24","Low",8268]
["1.25","Low",8269]
["1.26","Low",8270]
["1.3","Low",8245]
["1.4","Low",8246]
["1.5","Low",8247]
["1.6","Low",8248]
["1.7","Low",8249]
["1.8","Low",8250]
["1.9","Low",8251]
["1.99","High",11258]
["10.1","Medium",8461]
["10.10","High",8470]
["10.11","Medium",8471]
["10.12","Very High",8472]
["10.13","Very High",8473]
["10.14","Medium",8474]
["10.15","Low",8475]
["10.16","Very High",8476]
["10.17","Very High",8477]
["10.18","High",8478]
["10.19","Very High",8479]
["10.2","Low",8462]
["10.20","High",8480]
["10.21","Medium",8481]
["10.22","Low",8482]
["10.23","Medium",8483]
["10.24","Low",8484]
["10.25","Very High",8485]
["10.26","High",8486]
["10.27","Medium",8487]
["10.28","Low",8488]
["10.29","Medium",8489]
["10.3","Medium",8463]
["10.30","High",8490]
["10.31","Very High",8491]
["10.32","Very High",8492]
["10.33","High",8493]
["10.34","High",8494]
["10.35","Very High",8495]
["10.36","Very High",8496]
["10.37","Medium",8497]
["10.38","Medium",8498]
["10.39","High",8499]
["10.4","High",8464]
["10.40","Medium",8500]
["10.41","Medium",8501]
["10.42","Medium",8502]
["10.43","Medium",8503]
["10.44","Medium",8504]
["10.45","Very High",8505]
["10.46","High",8506]
["10.47","Medium",8507]
["10.48","High",8508]
["10.49","Medium",8509]
["10.5","Low",8465]
["10.50","High",8510]
["10.51","Low",8511]
["10.52","Medium",8512]
["10.53","Medium",8513]
["10.54","High",8514]
["10.55","Low",8515]
["10.6","Very High",8466]
["10.7","Medium",8467]
["10.8","Medium",8468]
["10.9","Medium",8469]
["10.99","High",8516]
["11.1","High",8420]
["11.10","Medium",8429]
["11.11","Very High",8430]
["11.12","Low",8431]
["11.13","Low",8432]
["11.14","Medium",8433]
["11.15","Low",8434]
["11.16","Low",8435]
["11.17","Low",8436]
["11.2","Medium",8421]
["11.3","Medium",8422]
["11.4","Very High",8423]
["11.5","Medium",8424]
["11.6","Medium",8425]
["11.7","High",8426]
["11.8","Low",8427]
["11.9","Low",8428]
["11.99","High",8437]
["12.1","High",8438]
["12.10","High",8448]
["12.11","High",8449]
["12.12","High",8450]
["12.13","High",8451]
["12.14","High",8452]
["12.15","High",8453]
["12.16","High",8454]
["12.17","High",8455]
["12.18","High",8456]
["12.19","High",8457]
["12.2","High",8439]
["12.20","High",8458]
["12.21","High",8459]
["12.3","High",8441]
["12.4","High",8442]
["12.5","High",8443]
["12.6","High",8444]
["12.7","High",8445]
["12.8","High",8446]
["12.9","High",8447]
["12.99","High",8460]
["2.1","Very High",8296]
["2.1.9","Very High",11259]
["2.10","Medium",8304]
["2.11","Medium",8305]
["2.12","Low",8306]
["2.13","Low",8307]
["2.14","Low",8308]
["2.15","Low",8309]
["2.16","Medium",8310]
["2.2","Medium",8297]
["2.3","High",8295]
["2.4","Medium",8298]
["2.5","Medium",8299]
["2.6","Low",8300]
["2.7","High",8301]
["2.8","High",8302]
["2.9","Medium",8303]
["2.99","High",8311]
["3.1","High",8312]
["3.2","Very High",8313]
["3.3","High",8314]
["3.4","Low",8294]
["3.5","Medium",8315]
["3.6","High",8316]
["3.7","Very High",8317]
["3.8","Very High",8318]
["3.99","High",8319]
["4.1","High",8320]
["4.10","High",8329]
["4.11","Medium",8330]
["4.12","Very High",8331]
["4.13","Very High",8332]
["4.14","Very High",8333]
["4.15","Very High",8334]
["4.16","Very High",8335]
["4.17","Very High",8336]
["4.18","Very High",8337]
["4.19","Low",8338]
["4.2","Medium",8321]
["4.20","Very High",8339]
["4.21","High",8340]
["4.22","Low",8341]
["4.23","High",8342]
["4.24","High",8343]
["4.25","Low",8344]
["4.26","Low",8345]
["4.27","High",8346]
["4.3","Medium",8322]
["4.4","High",8323]
["4.5","Very High",8324]
["4.6","Medium",8325]
["4.7","High",8326]
["4.8","Medium",8327]
["4.9","Medium",8328]
["4.99","High",8347]
["5.1","Very High",8517]
["5.10","High",8526]
["5.11","Low",8527]
["5.12","Medium",8528]
["5.13","High",8529]
["5.14","Very High",8530]
["5.15","Medium",8531]
["5.16","Very High",8532]
["5.17","Very High",8533]
["5.18","High",8534]
["5.19","Medium",8535]
["5.2","Very High",8518]
["5.20","Medium",8536]
["5.21","Medium",8537]
["5.22","High",8539]
["5.23","Very High",8540]
["5.24","Very High",8541]
["5.25","Medium",8542]
["5.26","Medium",8543]
["5.27","Medium",8544]
["5.28","Very High",8545]
["5.29","High",8546]
["5.3","Low",8519]
["5.30","High",8547]
["5.31","High",8548]
["5.32","High",8549]
["5.33","High",8550]
["5.34","Low",8551]
["5.35","Medium",8552]
["5.36","Low",8553]
["5.37","Low",8554]
["5.38","High",8555]
["5.39","Very High",8556]
["5.4","High",8520]
["5.40","Very High",8557]
["5.41","Very High",8558]
["5.42","Medium",8559]
["5.43","High",8560]
["5.44","High",8561]
["5.45","Medium",8564]
["5.46","Medium",8565]
["5.47","Medium",8566]
["5.48","Medium",8567]
["5.5","Low",8521]
["5.6","Low",8522]
["5.7","Medium",8523]
["5.8","Medium",8524]
["5.9","Very High",8525]
["5.99","High",8568]
["6.1","Medium",8348]
["6.10","Low",8357]
["6.11","High",8358]
["6.12","Medium",8359]
["6.13","Low",8360]
["6.14","High",8361]
["6.15","High",8362]
["6.16","Very High",8363]
["6.17","Very High",8364]
["6.18","Medium",8365]
["6.19","Low",8366]
["6.2","High",8349]
["6.20","Medium",8367]
["6.21","High",8368]
["6.22","Medium",8369]
["6.3","Low",8350]
["6.4","High",8351]
["6.5","Medium",8352]
["6.6","Medium",8353]
["6.7","High",8354]
["6.8","High",8355]
["6.9","Low",8356]
["6.99","High",8370]
["7.1","High",8371]
["7.10","High",8380]
["7.11","High",8381]
["7.12","High",8382]
["7.13","Medium",8383]
["7.14","Medium",8384]
["7.15","High",8385]
["7.16","High",8386]
["7.17","High",8387]
["7.2","High",8372]
["7.3","Low",8373]
["7.4","Low",8374]
["7.5","Low",8375]
["7.6","Medium",8376]
["7.7","Low",8377]
["7.8","High",8378]
["7.9","High",8379]
["7.99","High",8388]
["8.1","Very High",8569]
["8.10","Very High",8578]
["8.100","Low",11227]
["8.101","Medium",11228]
["8.102","Low",11229]
["8.103","Low",11230]
["8.104","Low",11231]
["8.105","Medium",11232]
["8.106","Medium",11233]
["8.107","Low",11234]
["8.108","High",11235]
["8.109","Very High",11236]
["8.11","Medium",8579]
["8.110","High",11237]
["8.111","Medium",11238]
["8.112","High",11239]
["8.113","Medium",11240]
["8.114","Low",11241]
["8.115","High",11242]
["8.116","Medium",11243]
["8.117","Medium",11244]
["8.118","Medium",11245]
["8.119","High",11246]
["8.12","Medium",8580]
["8.120","High",11247]
["8.121","Medium",11248]
["8.122","High",11249]
["8.123","High",11250]
["8.124","Low",11251]
["8.125","High",11252]
["8.126","Medium",11253]
["8.127","Medium",11254]
["8.13","Medium",8581]
["8.14","Very High",8582]
["8.15","High",8583]
["8.16","Very High",8584]
["8.17","Low",8585]
["8.18","High",8586]
["8.19","High",8587]
["8.199","High",11255]
["8.2","Medium",8570]
["8.20","Medium",8588]
["8.21","High",8589]
["8.22","Very High",8590]
["8.23","Medium",8591]
["8.24","Medium",8592]
["8.25","Very High",8593]
["8.26","High",8594]
["8.27","Medium",8595]
["8.28","Medium",8596]
["8.29","High",8598]
["8.3","Very High",8571]
["8.30","High",8599]
["8.31","High",8600]
["8.32","Low",8601]
["8.33","Medium",8602]
["8.34","High",8603]
["8.35","Medium",8604]
["8.36","Medium",8605]
["8.37","High",8607]
["8.38","Medium",8608]
["8.39","Medium",8609]
["8.4","Medium",8572]
["8.40","High",8610]
["8.41","Medium",8611]
["8.42","Medium",8612]
["8.43","Very High",8613]
["8.44","High",8615]
["8.45","High",8616]
["8.46","Very High",8617]
["8.47","Very High",8618]
["8.48","Medium",8619]
["8.49","High",8620]
["8.5","Very High",8573]
["8.50","Medium",8621]
["8.51","Low",8622]
["8.52","Low",8623]
["8.53","Low",8624]
["8.54","High",8625]
["8.55","Low",11182]
["8.56","Medium",11183]
["8.57","Medium",11184]
["8.58","High",11185]
["8.59","High",11186]
["8.6","Medium",8574]
["8.60","High",11187]
["8.61","Medium",11188]
["8.62","Very High",11189]
["8.63","High",11190]
["8.64","Medium",11191]
["8.65","Low",11192]
["8.66","High",11193]
["8.67","High",11194]
["8.68","High",11195]
["8.69","Medium",11196]
["8.7","High",8575]
["8.70","Medium",11197]
["8.71","Very High",11198]
["8.72","Medium",11199]
["8.73","Medium",11200]
["8.74","High",11201]
["8.75","Medium",11202]
["8.76","Medium",11203]
["8.77","Medium",11204]
["8.78","Medium",11205]
["8.79","Medium",11206]
["8.8","Medium",8576]
["8.80","Medium",11207]
["8.81","Low",11208]
["8.82","Medium",11209]
["8.83","Low",11210]
["8.84","Low",11211]
["8.85","Medium",11212]
["8.86","Medium",11213]
["8.87","Medium",11214]
["8.88","Low",11215]
["8.89","High",11216]
["8.9","High",8577]
["8.90","High",11217]
["8.91","High",11218]
["8.92","Medium",11219]
["8.93","Low",11220]
["8.94","Low",11221]
["8.95","Medium",11222]
["8.96","Medium",11223]
["8.97","Low",11224]
["8.98","High",11225]
["8.99","Medium",11226]
["9.1","Low",8390]
["9.10","Medium",8399]
["9.11","Medium",8400]
["9.12","Medium",8401]
["9.13","Low",8402]
["9.14","Medium",8403]
["9.15","Medium",8404]
["9.16","High",8405]
["9.17","High",8406]
["9.18","Low",8407]
["9.19","Low",8408]
["9.2","Very High",8391]
["9.20","Medium",8409]
["9.21","Medium",8410]
["9.22","Low",8411]
["9.23","Low",8412]
["9.24","Medium",8413]
["9.25","Low",8414]
["9.26","Low",8415]
["9.27","Low",8416]
["9.28","Medium",8417]
["9.29","Low",8418]
["9.3","Very High",8392]
["9.4","High",8393]
["9.5","High",8394]
["9.6","Low",8395]
["9.7","Medium",8396]
["9.8","Medium",8397]
["9.9","Medium",8398]
["9.99","High",8419]

{"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"]
["85","A SYMPHONY","85_1572073996248.xlsm"]