{"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":35,"n_cols":28,"rows_kept":35,"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","04-Dec-2019",null,null,"Ship Name","DHT OPAL (19-11-2019)"]
[]
[]
[]
[]
[]
[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,3141,43746.05846064815,"2019-03-01","Observation","Ship Staff","Ship Staff Insp.","Aux boiler control panel cooling window A/C not working","Boiler","Eng. / Strg. Comp.","Equipment Related",10.9,"Medium","Not Applicable","Not Applicable","Old units found defective. require new unit- request for supply of 2.7 KW unit (single cycle) DOPA 190193","2019-12-30","DOPA- 190193","In progress",null,"No","No","No","Internal"]
[null,null,null,null,3143,43687.070023136577,"2019-05-04","Deficiency","Ship Staff","Ship Staff Insp.","COT 2P,3C,4C,SLP-P PV valves leaking. attempted repair but leaks still exist, spares needed.","Deck Pipe / Fittings","Cargo / Ballast Systems","Equipment Related",8.19,"High","Not Applicable","Not Applicable","Renewed the pressure seat & disc for PV valves leak still persists, have received the procedure from makers to arrest the leak, same shall be attempted.\r\n","2019-12-31","DOPA190164","In progress",null,"No","No","No","Internal"]
[null,null,null,null,3145,43687.153009247697,"2019-05-14","Observation","SIRE / CDI Insp.","OM Insp. (Eg. SIRE, CDI etc.)","Pump room phone - deficiency - there is no connection from pumproom to bridge.","Miscellaneous","Communication","Equipment Related",5.17,"Very High","Not Applicable","Not Applicable","Remark was made by SIRE on other vessel- applies equally to all vessels.","2019-12-30","DOPA 190197","Not Started",null,"No","No","No","Internal"]
[null,null,null,null,3146,43746.160011574073,"2019-05-21","Observation","Ship Staff","Ship Staff Insp.","Few standby pumps to check for auto start.","Elect. Mach. & Equip.","Eng. / Strg. Comp.","Equipment Related","10.3.2",null,"Not Applicable","Not Applicable","JCFW P/p No.2 and LT Coller Fresh Water P/p No.2 are disconnected from kongsberg DPU. When we tried to connect it. The whole DPU gives short alarm. Need shore assistance - require further advice - GETTING MORE INFORMATION TO FORWARD","2019-12-31",null,"In progress",null,"No","No","No","Internal"]
[null,null,null,null,3147,43687.163321759297,"2019-05-28","Deficiency","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Port and Stbd navigation lights are painted glossy black, to be repainted to mat black.","Nav & comm. equip.","General Appearance","Equipment Related",4.8,"Medium","Not Applicable","Not Applicable","Awaiting supply of paints","2019-12-30","DOPA190124","Waiting spare",null,"No","No","No","Internal"]
[null,null,null,null,3150,43746.18408564815,"2019-06-24","Breakdown","Ship Staff","Ship Staff Insp.","Stern tube LO flow meter not working.","Elect. Mach. & Equip.","Eng. / Strg. Comp.","Equipment Related","10.3.2",null,"Not Applicable","Not Applicable","New flow meter on order.","2019-12-30","DOPA 190139","Waiting spare",null,"No","No","No","Internal"]
[null,null,null,null,3156,43687.203148148146,"2019-10-01","Deficiency","Ship Staff","Ship Staff Insp.","Bridge Morse Code indication light Malfunctioning ,giving continuous Light when switched on ","Elect. Mach. & Equip.","Navigation","Equipment Related",4.7,"High","Not Applicable","Not Applicable","Power outlet for the Horn controller checked, various terminals removed and checked, internal relay cheked ,DOPA190202 has been raised for supply of a new control unit ","2019-12-30","DOPA 190202","Waiting spare",null,"No","No","No","Internal"]
[null,null,null,null,3157,43746.205277777779,"2019-10-02","Deficiency","Ship Staff","Ship Staff Insp.","Wheelhouse  Split Air conditioning unit Malfuntioning ,showing EC error  on the internal unit  after running for around 1 Hr","Miscellaneous","Navigation","Equipment Related",10.23,"Medium","Not Applicable","Not Applicable","CheCked for any gas leakages ,asked office assistance as vessel does not have any manul for guidelines.Requires footing to be welded.","2019-12-30",null,"In progress",null,"No","No","No","Internal"]
[null,null,null,null,6094,"15/11/2019 9:16:51 PM","2019-11-11","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Talk back system from fore peak store entrance is missing.","Nav & comm. equip.","Communication","Human Error",9.2899999999999991,"Low","Not Applicable","Not Applicable","Mic for the talk back system located, Speaker for the system is missing, finding of speaker in progress","2019-12-30",null,"In progress",null,"No","No","No","Internal"]
[null,null,null,null,6110,"15/11/2019 7:18:31 PM","2019-10-18","Observation","Ship Staff","Ship Staff Insp.","Fixed gas detection system for WBT not working,(shows error analyse pump or internal leakage )\n\n\n\n","Miscellaneous","Cargo / Ballast Systems","Equipment Related",5.21,"Medium","Not Applicable","Not Applicable","Vaccum gauge is not working, received spares same replaced, under observation now.\r\n\r\n","2019-12-30","DOPA190126\r\n","In progress",null,"No","No","No","Internal"]
[null,null,null,null,6111,"15/11/2019 7:50:40 PM","2019-10-20","Breakdown,Deficiency","Ship Staff","Ship Staff Insp.","\n\nHydraulic Winch brake for winch W1 inboard drum does not hold when under tension. \n\n","Mooring Mach.","Mooring","Equipment Related","9.7","Medium","","","Awaiting spares \n\n","2019-12-15","DOPA 190217","Waiting spare",null,"No","No","No","Internal"]
[null,null,null,null,6112,"15/11/2019 7:52:33 PM","2019-11-03","Observation","Ship Staff","Ship Staff Insp.","During last discharge operation at Dong Jia Kou found No.1 AUS separator level shows only 50% filled.\n\n\n\n\n\n","Cargo Mach.","Cargo / Ballast Systems","Equipment Related","8.21","High","","","Shall be investigated during loaded passage, vessel presently in ballast condition.\n\n","2019-12-10","","Not Started",null,"No","No","No","Internal"]
[null,null,null,null,6113,"15/11/2019 7:55:13 PM","2019-11-03","Observation","Ship Staff","Ship Staff Insp.","Slop S COT remote gauge(Hanla System ) not operational, Other COT readings are normal\n\n\n\n\n\n","Miscellaneous","Cargo / Ballast Systems","Equipment Related",8.1199999999999992,"Medium","Not Applicable","Not Applicable","Awaiting spare\r\n\r\n","2019-12-12","DOPA190235","Waiting spare",null,"No","No","No","Internal"]
[null,null,null,null,6114,"15/11/2019 7:57:16 PM","2019-11-10","Observation","Ship Staff","Ship Staff Insp.","Independent IG pressure sensor for COT malfunctioning, 7 COT shows reading in excess of  +-50mmwg than the line pressure.(5C, 2S, 3S, 4P, 5P, SLP P, SLP S)\n\n\n\n","Miscellaneous","Cargo / Ballast Systems","Equipment Related","8.19","High","","","Fault finding in progress\n\n\n\n","2019-12-30","","In progress",null,"No","No","No","Internal"]
[null,null,null,null,6119,"15/11/2019 8:41:02 PM","2019-11-11","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Slop heating steam lines are removed from place and stored in mid ship. To install in place and test. same will be required during tank cleaning before docking in Dec.","Cargo Mach.","Cargo / Ballast Systems","External Factors",8.15,"High","Not Applicable","Not Applicable","Slop heating coils are stowed in FPK store at sea, As vessel is scheduled for DD after present voyage, same was shifted from the FPK store to put back in place. But due to unfavourable weather from discharge port to Singapore, same could not be completed, fitting of heating coil manifold in progress.","2019-12-12",null,"In progress",null,"No","No","No","Internal"]
[null,null,null,null,6122,"15/11/2019 9:12:16 PM","2019-11-11","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Stbd side manifold gratings to de-rust and paint.","Deck Pipe / Fittings","General Appearance","External Factors",6.6,"Medium","Not Applicable","Not Applicable","Derusting / painting of  stbd manifold Drip tray / grating in progress","2019-12-26",null,"In progress",null,"No","No","No","Internal"]
[null,null,null,null,null,"2019-12-04T21:08:46","2019-11-18","Breakdown","Ship Staff","Ship Staff Insp.","COT tank Radar system(Hanla) not operational,Remote gauges not working, All COT readings are in error.\t","Miscellaneous","Cargo / Ballast Systems","Equipment Related",8.1199999999999992,"Medium","Not Applicable","Not Applicable","Received spares, new spares installed, work in progress. Liasing with makers for initial setting","2019-12-15",null,"In progress",null,"No",null,null,"Internal"]
[null,null,null,null,null,"2019-12-04T21:11:16","2019-12-01","Observation","Ship Staff","Ship Staff Insp.","WBT remote gauge system showing incorrect reading for FPK & 2P WBT\t","Miscellaneous","Cargo / Ballast Systems","Equipment Related",8.1199999999999992,"Medium","Not Applicable","Not Applicable","Fault finding in progress.","2019-12-18",null,"In progress",null,"No",null,null,"Internal"]

{"sheet":"Completed","index":1,"n_rows":75,"n_cols":28,"rows_kept":75,"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","4-11-2019",null,null,"Ship Name","DHT OPAL (19-11-2019)"]
[]
[]
[]
[]
[]
[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,3158,"2019-08-10 18:08:38.000","2019-01-01","Observation","Ship Staff","Ship Staff Insp.","AE no. 3 starting from MSB and local panel, but stopping before reaching full rpm. It can only be started by emergency mode by operating air solenoid.","Aux. Engine","Eng. / Strg. Comp.","Equipment Related","","","","","completed","2019-01-21","","Completed","2019-01-15","No","No","No","Internal"]
[null,null,null,null,3159,"2019-08-10 20:36:56.999","2019-03-01","Deficiency","Ship Staff","Ship Staff Insp.","No.2 Bilge fire and GS pump breaker tripping and stopped button not working. ","Aux. Engine","Eng. / Strg. Comp.","Equipment Related","10.13","Very High","","","completed","2019-03-04","","Completed","2019-05-01","No","No","No","Internal"]
[null,null,null,null,3160,"2019-10-08 20:27:55.000","2019-01-01","Deficiency","Ship Staff","Ship Staff Insp.","Main air copressor in 1st follow up not starting even when bottle pressure comes down to 20bar. ","Air Comp.","Eng. / Strg. Comp.","Human Error","10.16","Very High","","","completed","2019-03-03","","Completed","2019-01-15","No","No","No","Internal"]
[null,null,null,null,3161,"22/10/2019 9:09:18 AM","2019-01-04","Deficiency","Ship Staff","Ship Staff Insp.","AE no. 3 jacket water pre-heater tripping on over current.","Aux. Mach.","Eng. / Strg. Comp.","Equipment Related","","","","","EOCR settings changed, pre-heater working normal.","2019-01-15","","Completed","2019-01-13","No","No","No","Internal"]
[null,null,null,null,3162,"22/10/2019 9:18:45 AM","2019-01-04","Deficiency","Ship Staff","Ship Staff Insp.","Engine room bilge well (S) high level alarm malfunctioning.","Elect. Mach. & Equip.","Eng. / Strg. Comp.","Equipment Related","10.19","Very High","","","Found magnet switch misaligned and float rod bend. Defect rectified. High level alarm working satisfactory.","2019-01-06","","Completed","2019-01-05","No","No","No","Internal"]
[null,null,null,null,3163,"22/10/2019 9:27:23 AM","2019-01-04","Observation","Ship Staff","Ship Staff Insp.","Laying of cable and Installation of Nav-box for ECDIS","Nav & comm. equip.","Navigation","Equipment Related","10.37","Medium","","","New cables laid from Navbox(Elec Equipt Room) to ECDIS 1&2, AIS JB, and Nav Laptop. Commissioning / integration carried out. Now operational.","2019-01-10","","Completed","2019-01-05","No","No","No","Internal"]
[null,null,null,null,3164,"22/10/2019 9:43:36 AM","2019-01-05","Deficiency","Ship Staff","Ship Staff Insp.","AE # 1 Fuel oil Autoklen filters not turning and drain valve not operational.","Aux. Engine","Eng. / Strg. Comp.","Equipment Related","","","","","Filter element removed and eased up. Drain vavle overhauled. Now both are operational.","2019-01-12","","Completed","2019-01-11","No","No","No","Internal"]
[null,null,null,null,3165,"22/10/2019 9:33:33 AM","2019-01-03","Deficiency","Ship Staff","Ship Staff Insp.","ME Air cooler#1 water drain high level switch malfunctioning","Miscellaneous","Eng. / Strg. Comp.","Equipment Related","10.34","High","","","Cable was broken. New cable laying carried out from DPU-ER  to ME JB-4. Working satisfactory.","2019-01-11","","Completed","2019-01-10","No","No","No","Internal"]
[null,null,null,null,3166,"22/10/2019 9:47:24 AM","2019-01-10","Deficiency","Ship Staff","Ship Staff Insp.","DONKEY BOILER GAUGE GLASS LEAKING","Boiler","Eng. / Strg. Comp.","Equipment Related","","","","","GAUGE GLASS REPLACED WITH SPARE NEW ONE.","2019-01-11","","Completed","2019-01-10","No","No","No","Internal"]
[null,null,null,null,3167,"22/10/2019 10:02:21 AM","2019-10-01","Deficiency","Ship Staff","Ship Staff Insp.","Vacuum condensor level sensor faulty.","Inert Gas","Eng. / Strg. Comp.","Equipment Related","8.19","High","","","Sensor removed & inspected, getting stuck on the shaft due to sticky sludge . Same cleaned and putted back. Now working satisfactory.","2019-12-01","","Completed","2019-10-01","No","No","No","Internal"]
[null,null,null,null,3168,"22/10/2019 10:14:31 AM","2019-01-05","Deficiency","Ship Staff","Ship Staff Insp.","ME FO heater bypass valve leaking from bonnet","ER Pipes, valves & fittings","Eng. / Strg. Comp.","Equipment Related","","","","","Gasket damaged, gasket renewed. No leakage.","2019-01-06","","Completed","2019-01-06","No","No","No","Internal"]
[null,null,null,null,3169,"22/10/2019 10:25:10 AM","2019-01-04","Deficiency","Ship Staff","Ship Staff Insp.","FWG steam valve leaking from the bonnet","ER Pipes, valves & fittings","Eng. / Strg. Comp.","Equipment Related","","","","","Damaged gasket renewed and lakage rectified","2019-01-06","","Completed","2019-01-06","No","No","No","Internal"]
[null,null,null,null,3170,"22/10/2019 10:40:31 AM","2019-01-15","Deficiency","Ship Staff","Ship Staff Insp.","Bonsun store winch locking lever broken","Deck Pipe / Fittings","Mooring","Equipment Related","5.11","Low","","","New lever fabricated onboard and fixed","2019-01-25","","Completed","2019-01-17","No","No","No","Internal"]
[null,null,null,null,3171,"22/10/2019 10:52:37 AM","2019-01-15","Deficiency","Ship Staff","Ship Staff Insp.","Aft winch break wasted and broken.","Deck Mach.","Mooring","Equipment Related","9.7","Medium","","","Hand pump to be replaced and spares ordered.","2019-01-15","DOPA190007","Completed","2019-01-17","No","No","No","Internal"]
[null,null,null,null,3172,"22/10/2019 11:00:24 AM","2019-01-17","Observation","Ship Staff","Ship Staff Insp.","Air cooler leaking from air side, suspected gasket damaged.","Main Engine ","Eng. / Strg. Comp.","Equipment Related","","","","","Cooler cover frame removed and found part of rubber gasket given away. A piece of rubber gasket was inserted and sealed with silicon. ","2019-01-23","","Completed","2019-01-23","No","No","No","Internal"]
[null,null,null,null,3173,"22/10/2019 11:10:44 AM","2019-01-20","Deficiency","Ship Staff","Ship Staff Insp.","STP SW flushing line found holed and leaking.","ER Pipes, valves & fittings","Eng. / Strg. Comp.","Equipment Related","","","","","Pipe removed from place and weld repaired in workshop.","2019-01-20","","Completed","2019-01-20","No","No","No","Internal"]
[null,null,null,null,3174,"22/10/2019 11:16:00 AM","2019-01-21","Deficiency","Ship Staff","Ship Staff Insp.","Boiler water circulating pump found making abnormal vibration.","Boiler","Eng. / Strg. Comp.","Equipment Related","","","","","Pump removed from place and opened up. Found diaphram broken. As there was no spare a new oone was made of teflon and rubber. Pump fitted back and tried out. Working satisfactorily.","2019-01-22","DOPA011690/19","Completed","2019-01-22","No","No","No","Internal"]
[null,null,null,null,3175,"22/10/2019 11:45:46 AM","2019-01-22","Deficiency","Ship Staff","Ship Staff Insp.","STP chemical dosing pump overload trip.","Boiler","Eng. / Strg. Comp.","Equipment Related","","","","","Pump removed from place and opened up. Found diaphram broken. As there was no spare a new oone was made of teflon and rubber. Pump fitted back and tried out. Working satisfactorily.","2019-01-24","DOPA 190099","Completed","2019-01-23","No","No","No","Internal"]
[null,null,null,null,3176,"22/10/2019 11:53:26 AM","2019-01-29","Deficiency","Ship Staff","Ship Staff Insp.","FWG steam inlet valve leaking from bonnet.","Miscellaneous","Eng. / Strg. Comp.","Equipment Related","","","","","Bonnet retightened and leakage rectified.","2019-01-29","","Completed","2019-01-29","No","No","No","Internal"]
[null,null,null,null,3177,"22/10/2019 12:05:25 PM","2019-01-29","Deficiency","Ship Staff","Ship Staff Insp.","Bridge window wiper (B) not working when tried out.","Nav & comm. equip.","Navigation","Equipment Related","","","","","Repair carried out, channel cleared and greasing carried out.","2019-01-31","","Completed","2019-01-30","No","No","No","Internal"]
[null,null,null,null,3178,"22/10/2019 12:27:39 PM","2019-01-19","Deficiency","Ship Staff","Ship Staff Insp.","WO Incinerator exhaust trunking spark arrestor clogged","Aux. Engine","Eng. / Strg. Comp.","Equipment Related","","","","","Spark arrestor to be cleared and leaking below joints to be tightened.","2019-01-25","","Completed","2019-01-31","No","No","No","Internal"]
[null,null,null,null,3179,"22/10/2019 12:30:30 PM","2019-01-19","Observation","Ship Staff","Ship Staff Insp.","Raptor system to be installed","Nav & comm. equip.","Navigation","Equipment Related","","","","","Raptor system to be installed.","2019-01-24","","Completed","2019-01-25","No","No","No","Internal"]
[null,null,null,null,3180,"22/10/2019 12:39:39 PM","2019-01-22","Deficiency","Ship Staff","Ship Staff Insp.","PV valves leaking 1P,2C ,4S","Cargo Mach.","Cargo / Ballast Systems","Equipment Related","8.19","High","","","Maintainance in progress","2019-02-14","","Completed","2019-10-02","No","No","No","Internal"]
[null,null,null,null,3181,"22/10/2019 12:42:39 PM","2019-01-22","Deficiency","Ship Staff","Ship Staff Insp.","PV valves for 1P,2C ,4S leaking","Cargo Mach.","Cargo / Ballast Systems","Equipment Related","8.19","High","","","Maintainance in progress","2019-02-14","","Completed","2019-10-02","No","No","No","Internal"]
[null,null,null,null,3182,"22/10/2019 12:49:38 PM","2019-02-06","Observation","Ship Staff","Ship Staff Insp.","220 feeder panel on msbd showing low insultion","Elect. Mach. & Equip.","Eng. / Strg. Comp.","Equipment Related","10.38","Medium","","","Low insulation found in ships name board (stbd) circuit.water ingress in one light fixture and rusted parts inside.new fixture fitted.","2019-02-10","","Completed","2019-02-07","No","No","No","Internal"]
[null,null,null,null,3183,"22/10/2019 12:54:13 PM","2019-02-07","Deficiency","Ship Staff","Ship Staff Insp.","Deck seal pump leaking from casing flange","Inert Gas","Eng. / Strg. Comp.","Equipment Related","","","","","Pump found leaking from gasket , gasket renewed.","2019-02-12","","Completed","2019-02-07","No","No","No","Internal"]
[null,null,null,null,3185,"23/10/2019 1:43:36 PM","2019-02-08","Observation","Ship Staff","Ship Staff Insp.","Doctor performance sensor and junction box installation for all 3 AE","Aux. Engine","Eng. / Strg. Comp.","Equipment Related","11.11","Very High","","","Doctor performance sensor and junction box installed for all 3 AE","2019-02-09","","Completed","2019-02-09","No","No","No","Internal"]
[null,null,null,null,3186,"2019-08-10 04:00:20.000","2019-05-28","Deficiency","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Both life boatsglass found partially opaque, need to be cleaned.","LSA / FFA","LSA / FFA Appliances","Equipment Related","5.29","High","","","Both Sides Lifeboat ,Opaque glasses changed with new recived Glasses","2019-10-10","DOPA 190143","Completed","2019-10-18","No","No","No","Internal"]
[null,null,null,null,3187,"2019-08-10 04:04:27.000","2019-05-28","Deficiency","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Embarcation ladders form both the life boats found damaged from the thimble","LSA / FFA","LSA / FFA Appliances","Equipment Related","5.29","High","","","New embarkation ladders recived at Singapore on 13th October 2019, And Repalced with the Damged Ones.","2019-10-10","DOPA 190127","Completed","2019-10-14","No","No","No","Internal"]
[null,null,null,null,6099,"2019-10-08 04:39:29.998","2019-08-20","Deficiency","Ship Staff","Ship Staff Insp.","No.3 E/R Vent Fan - impeller blades damaged - Fan now running with only 5 blades instead of 10","Miscellaneous","Eng. / Strg. Comp.","Equipment Related","10.18","High","","","New impeller installed,working satisfactory.","2019-10-30","DOPA 190165","Completed","2019-11-13","No","No","No","Internal"]
[null,null,null,null,6101,"15/11/2019 2:40:07 PM","2019-11-13","Breakdown","Ship Staff","Ship Staff Insp.","Prov.Reefer compressor# 1 shaft seal leaking.Same to renew.","Accommodation ","Eng. / Strg. Comp.","Equipment Related","","","","","Seal renewed.","2019-11-15","","Completed","2019-11-14","No","No","No","Internal"]
[null,null,null,null,6102,"15/11/2019 8:18:50 PM","2019-11-11","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Cargo leak sighted from one of the cargo pipe line in pump room. Leak to rectify and area to clean","Deck Pipe / Fittings","Cargo / Ballast Systems","External Factors","8.44","High","","","Flange tightened & rectified, shall monitor regularly.","2019-11-16","","Completed","2019-11-15","No","No","No","Internal"]
[null,null,null,null,6103,"15/11/2019 8:21:25 PM","2019-11-11","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Bunker / cargo manifold’s flange many bolts length is short. To renew.","Miscellaneous","Cargo / Ballast Systems","Human Error","8.41","Medium","","","Bolts renewed.","2019-11-18","","Completed","2019-11-14","No","No","No","Internal"]
[null,null,null,null,6104,"15/11/2019 9:05:19 PM","2019-11-11","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","The latch of fire hose box on stbd side of boat deck is broken. To be renewed.","LSA / FFA","LSA / FFA Appliances","External Factors","5.38","High","","","Latch renewed","2019-11-26","","Completed","2019-11-15","No","No","No","Internal"]
[null,null,null,null,6105,"15/11/2019 9:10:10 PM","2019-11-11","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Many numbers are missing from the numpad of emergency DG room phone. To replace.","Miscellaneous","Communication","Behaviour Based","10.32.10","Very High","Not Applicable","Not Applicable","Numbers replaced on numpad","2019-11-21",null,"Completed","2019-11-15","No","No","No","Internal"]
[null,null,null,null,6106,43784.994641203702,"2019-11-11","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","ME LO purifier temp found to be maintained at only 76 deg. Reminder has been sent from office to maintain around 95 deg. All engineers to be briefed.","Purifier","Eng. / Strg. Comp.","Equipment Related",10.119999999999999,"Very High","Not Applicable","Not Applicable","Temperature adjusted.All engineers briefed.","2019-11-17",null,"Completed","2019-11-15","No","No","No","External"]
[null,null,null,null,6107,43784.996655092589,"2019-11-11","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Near incinerator many drum are not lashed properly. To secure.","Miscellaneous","Eng. / Strg. Comp.","Human Error",10.29,"Medium","Not Applicable","Not Applicable","Drums secured and lashed.","2019-11-15",null,"Completed","2019-11-14","No","No","No","External"]
[null,null,null,null,6108,43784.998206018521,"2019-11-11","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Oxygen acetylene room securing bar to de-rust and paint.","Miscellaneous","Eng. / Strg. Comp.","Equipment Related",5.26,"Medium","Not Applicable","Not Applicable","Derusted and painted.","2019-11-15",null,"Completed","2019-11-15","No","No","No","External"]
[null,null,null,null,6124,43784.9997337963,"2019-11-11","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","ME T/C and air cooler U-tube manometer, not water or coloured liquid sighted.","Main Engine ","Eng. / Strg. Comp.","Equipment Related","10.32.10","Very High","Not Applicable","Not Applicable","U-tube manometer cleaned and filled with water.","2019-11-15",null,"Completed","2019-11-15","No","No","No","External"]
[null,null,null,null,null,43687.06517361111,"2019-03-08","Deficiency","Ship Staff","Ship Staff Insp.","Navigation light panel.","Nav & comm. equip.","Navigation","Equipment Related",4.8,"Medium","Not Applicable","Not Applicable","Main navigation light control panel on W/H, buzzer making abnormal tickling noiseintermittently, checked PCB on the navigation Relay board. New PCb has been ordered by the vesse. The vessel was to confirm actual no of PCB required, which has been done - COMPLETED","2019-10-30","DOPA- 190069","Completed","2019-11-22","No",null,null,"Internal"]
[null,null,null,null,null,43746.146782395801,"2019-05-08","Deficiency","Ship Staff","Ship Staff Insp.","Main engine Alfa lubricators - delivery accumulators","Main Engine ","Eng. / Strg. Comp.","Equipment Related",10.16,"Very High","Not Applicable","Not Applicable","Defective accumulator renewed.","2019-10-30","DOPA 190117","Completed","2019-11-22","No",null,null,"Internal"]
[null,null,null,null,null,43746.171956006947,"2019-05-28","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Donkey boiler FO pump #2 signs of mechanical seal leakage, to be identified.","Boiler","Eng. / Strg. Comp.","Equipment Related",10.29,"Medium","Not Applicable","Not Applicable","Seal Renewed","2019-10-10","DOPA 190099","Completed","2019-10-11","No",null,null,"Internal"]
[null,null,null,null,null,43746.174791655096,"2019-06-24","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Stern tube LO pump starter box broken.","Elect. Mach. & Equip.","Eng. / Strg. Comp.","Equipment Related","10.3.2",null,"Not Applicable","Not Applicable","New starter box on order.                                                            RENEWED","2019-10-10","DOPA 190136","Completed","2019-11-25","No",null,null,"Internal"]
[null,null,null,null,null,43746.186631944445,"2019-06-24","Breakdown","Ship Staff","Ship Staff Insp.","E/R drinking water fountain compressor not working.","Miscellaneous","Eng. / Strg. Comp.","Equipment Related",10.32,"Very High","Not Applicable","Not Applicable","New fountain installed.","2019-10-10","DOPA 190140","Completed","2019-11-14","No",null,null,"Internal"]
[null,null,null,null,null,43687.189398136572,"2019-06-24","Critical Equipment","Ship Staff","Ship Staff Insp.","STBD L/B No 2 battery charger showing erratic value","LSA / FFA","LSA / FFA Appliances","Equipment Related",5.29,"High","Not Applicable","Not Applicable","The charger is still working- only the display is defective -Replaced working satisfactory.","2019-11-30","DOPA 190137","Completed","2019-11-23","No",null,null,"Internal"]
[null,null,null,null,null,43687.191319432874,"2019-08-14","Deficiency","Ship Staff","Ship Staff Insp.","Crew Elevator - The elevator was put back into service following a period extreme rolling. When rising from bottom level, the elevator car got stuck between sunken deck and upper deck. Found one counterweight wire was entangled, now OK, but rope is slipping on the drum.","Elect. Mach. & Equip.","Eng. / Strg. Comp.","Equipment Related",10.32,"Very High","Not Applicable","Not Applicable","Service Technician attended,elevator is in operation.","2019-10-30",null,"Completed","2019-10-21","No",null,null,"Internal"]
[null,null,null,null,null,43746.194097210602,"2019-08-20","Deficiency","Ship Staff","Ship Staff Insp.","No.3 E/R Vent Fan - impeller blades damaged - Fan now running with only 5 blades instead of 10","Miscellaneous","Eng. / Strg. Comp.","Equipment Related",10.18,"High","Not Applicable","Not Applicable","New impeller installed,working satisfactory.","2019-11-30","DOPA 190165","Completed","2019-11-13","No",null,null,"Internal"]
[null,null,null,null,null,43746.196388888886,"2019-09-30","Deficiency","Ship Staff","Ship Staff Insp.","LT cooler FWD SW outlet pipe observed leaking from a pin hole of the welding seam after the isolating valve.","ER Pipes, valves & fittings","Eng. / Strg. Comp.","Equipment Related",10.29,"Medium","Not Applicable","Not Applicable","Pipeline renewed.","2019-10-30",null,"Completed","2019-10-25","No",null,null,"Internal"]
[null,null,null,null,null,"22/10/2019 1:06:34 PM","2019-01-02","Deficiency","Ship Staff","Ship Staff Insp.","Ballast pump no2 leaking from seal.","Cargo Mach.","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Pump dismantled, both seal inspected found top seal damaged, same replaced with spare new seal. Also seal nut found damaged, same replaced. Pump both top and bottom bearings renewed.","2019-08-02",null,"Completed","2019-08-02","No",null,null,"Internal"]
[null,null,null,null,null,43785.001759247687,"2019-11-11","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Understand that no 1 COPT sump oil was contaminated with water and due to this there was delay in starting same. It has happened twice. Please find the water ingress source and rectify. ","Cargo Mach.","Eng. / Strg. Comp.","Equipment Related",10.32,"Very High","Not Applicable","Not Applicable","Troubleshooting carried out,found Gland leakage line valve orifice choked.same cleared and fitted back.","2019-11-25",null,"Completed","2019-11-22","No",null,null,"External"]
[null,null,null,null,null,43785.003622685188,"2019-11-11","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Many numbers are missing from the numpad of emergency DG room phone. To replace.","Miscellaneous","Communication","Human Error","10.32.10","Very High","Not Applicable","Not Applicable","Numbers Replaced on the numpad","2019-11-20",null,"Completed","2019-11-15","No",null,null,"External"]
[null,null,null,null,null,"15/11/2019 8:26:09 PM","2019-11-11","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Canvas of forward liferaft embarkation ladder to renew.","Miscellaneous","General Appearance","External Factors",5.47,"Medium","Not Applicable","Not Applicable","Canvas cover renewed. ","2019-11-21",null,"Completed","2019-11-16","No",null,null,"Internal"]
[null,null,null,null,null,"15/11/2019 8:28:26 PM","2019-11-11","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Both mid ship store exterior to paint white. Paint has fade completely","Accommodation ,Miscellaneous","General Appearance","External Factors",11.8,"Low","Not Applicable","Not Applicable","Buffing followed by 2 coat primer & final coat painting carried out for both the midship store exterior.","2019-10-12",null,"Completed","2019-11-20","No",null,null,"Internal"]
[null,null,null,null,null,"15/11/2019 8:31:02 PM","2019-11-11","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Air duct pipe in laundry to paint. Paint has peeled off almost completely","Accommodation ","General Appearance","External Factors",11.7,"High","Not Applicable","Not Applicable","Painting of Air Duct pipe completed","2019-11-21",null,"Completed","2019-11-17","No",null,null,"Internal"]
[null,null,null,null,null,"15/11/2019 8:34:01 PM","2019-11-11","Observation","Ship Staff","Suptd. Insp.","Bunker and cargo sample cabinet in paint locker, has no latch, to fit one.","Miscellaneous","ISM Related","Human Error",5.48,"Medium","Not Applicable","Not Applicable","Latch arrangement made ","2019-11-26",null,"Completed","2019-11-16","No",null,null,"Internal"]
[null,null,null,null,null,"15/11/2019 8:51:03 PM","2019-11-11","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Most of the locations, eye wash found to be hanging by rope. That’s a eye shore. Please ensure proper eye wash cabinet is made and fixed in place.","Miscellaneous","General Appearance","Behaviour Based",8.67,"High","Not Applicable","Not Applicable","Cabinet made & secured in place.","2019-10-12",null,"Completed","2019-11-16","No",null,null,"Internal"]
[null,null,null,null,null,"15/11/2019 9:07:36 PM","2019-11-11","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Greasing points of both life boat and weather tight doors to be marked in yellow for easy identification.","Miscellaneous","General Appearance","External Factors",5.27,"Medium","Not Applicable","Not Applicable","Markings done for grease nipple","2019-11-26",null,"Completed","2019-11-18","No",null,null,"Internal"]
[null,null,null,null,null,"15/11/2019 9:15:10 PM","2019-11-11","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Stripping pump moving lever is too close to the copper pipe support. To relocate to avoid any accident.","Deck Pipe / Fittings","Cargo / Ballast Systems","Behaviour Based",5.17,"Very High","Not Applicable","Not Applicable","Copper pipe support relocated.","2019-01-12",null,"Completed","2019-11-18","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":16,"n_cols":2,"rows_kept":16,"cut":false,"hidden":true,"merged":[]}
["TITLE","ID"]
["Bunkering Audit",14]
["Others (Eg. Insurance etc.)",12]
["Engineering Audit",16]
["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"]
["28","DHT OPAL (19-11-2019)","28_1575439700631.xlsm"]