{"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":26,"n_cols":28,"rows_kept":26,"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","20-Nov-2019",null,null,"Ship Name","DHT STALLION (01-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,2587,"18/10/2019 22:33:23","2019-09-01","Breakdown","Ship Staff","Ship Staff Insp.","Port side bridge wing camera not working.","Nav & comm. equip.","Navigation","Equipment Related","4.7","High","","","Camera landed during Singapore transit on 08th Oct 2019 for maker's repair. ","2019-12-01","","Waiting spare",null,"No","No","No","Internal","Repair is in progress. Will be connected next call Singapore."]
[null,null,null,null,2589,"20/10/2019 4:54:32 PM","2019-09-12","Observation","Ship Staff","Ship Staff Insp.","BWTS unit, inside filter unit many cleaning nozzles found in siezed and worn out condition.","Deck Mach.","Cargo / Ballast Systems","Equipment Related",6.21,"High","Not Applicable","Not Applicable","Awaiting Spares","2019-12-11",null,"In progress",null,"No","No","No","Internal","Spares are on order and have 60 days lead time. Will be supplied next call Singapore."]
[null,null,null,null,5609,"22/10/2019 2:23:29 PM","2019-10-22","Observation","Ship Staff","Ship Staff Insp.","Cargo Oil tank Pressure Sensor for 1 Port tank and 4 Stbd Showing erratic","Cargo Mach.","Cargo / Ballast Systems","Equipment Related",8.1300000000000008,"Medium","Not Applicable","Not Applicable","Cargo tank Pressure sensor to be renewed after receiwing new sensor.","2020-01-21","DSTA190156","Waiting spare",null,"No","No","No","Internal","3 nos, spare sensors are on order, for vessel to keep 1 as spare. Will be connected next call Singapore. "]
[null,null,null,null,5610,"23/10/2019 11:48:48 AM","2019-10-08","Breakdown,Observation","Ship Staff","Ship Staff Insp.","Steering gear rudder carrier greasing pump body cracked\t","Aux. Mach.","General Appearance","Equipment Related",10.32,"Very High","Not Applicable","Not Applicable","Temporary repair carried out, pump working satisfactory","2019-12-15","DSTA190159","Waiting spare",null,"No","No","No","Internal","Spare is order. Will be supplied next call Singapore."]
[null,null,null,null,5611,"27/10/2019 8:15:30 AM","2019-10-24","Observation","Ship Staff","Ship Staff Insp.","Red warning  light Glass  Shade for Hose handling crane Port side broken","Deck Mach.,Elect. Mach. & Equip.","Emgcy. Systems","Equipment Related",8.6300000000000008,"High","Not Applicable","Not Applicable","Glass shade to be renewed after receving new.","2020-01-23","DSTA-190163","Waiting spare",null,"No","No","No","Internal","Raise RO for spare ASAP."]
[null,null,null,null,5612,"27/10/2019 8:26:33 AM","2019-10-24","Observation","Ship Staff","Ship Staff Insp.","Vessel Call Sign to be changed to new Call Sign VRSX9 in BWTS Software System from the makers.","Elect. Mach. & Equip.","Cargo / Ballast Systems","Equipment Related",8.18,"High","Not Applicable","Not Applicable","Awaiting Maker to  access BWTS monitor by remote access( by internet) and change the Call Sign.","2020-01-23",null,"Not Started",null,"No","No","No","Internal","Since the maker tried remote access and unable to do because of slow internet speed, it has to be done at next service by maker."]
[null,null,null,null,5613,43476.243668969903,"2019-10-30","Breakdown,Deficiency","Ship Staff","Ship Staff Insp.","Fwd Anchor light and fitting damaged","Nav & comm. equip.","Navigation","Equipment Related,External Factors",4.8,"Medium","Not Applicable","Not Applicable","Office informed and waiting for spares","2020-01-29","DSTA190166","Not Started",null,"No","No","No","Internal","Waiting for quote."]
[null,null,null,null,null,"20/11/2019 2:33:15 PM","2019-11-12","Breakdown","Ship Staff","Ship Staff Insp.","Experiencing issues with Bridge Window Wiper controller panel. At present, the following wipers are in-operational :\r\nWiper No.1 \r\nWiper No.3 \r\nWiper No.5\r\nWiper No.6\r\nWiper No.7\r\nWiper No.9\r\n","Nav & comm. equip.","Navigation","Equipment Related",4.7,"High","Not Applicable","Not Applicable","As per discussion with Office, will raise PO for supply of new Wiper Controller panel.","2020-02-11","DSTA190174","Waiting spare",null,"No",null,null,"Internal"]
[null,null,null,null,null,"20/11/2019 11:06:06 PM","2019-11-12","Other","Owner / Marine / Tech. Suptd.","Ship Staff Insp.","Job operational spares to be updated in PAL.","Miscellaneous","Cert. & Docu.","Inappropriate Procedure",null,null,"Not Applicable","Not Applicable","Job Operational spares to be updated in PAL.","2019-11-30",null,"In progress",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","20-10-2019",null,null,"Ship Name","DHT STALLION (01-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,2590,"18/10/2019 22:47:02","2019-09-12","Observation","Ship Staff","Ship Staff Insp.","Ballast valves BA508 & BA510 is kept at 20% open to prevent the valve to be stuck at closed position.","Cargo Mach.","Cargo / Ballast Systems","Equipment Related","8.11","Medium","","","Both the valves renewed & tested. Working satisfactorily.","2019-12-11","DSTA-190089","Completed","2019-10-13","No","No","No","Internal"]
[null,null,null,null,2591,"20/10/2019 10:15:53 AM","2019-09-01","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Fire Station wakie talkie -one pouch missing (3 pouches for 4 walkie talkies)","LSA / FFA","Communication","Behaviour Based,Human Error","5.43","High","","","Missing Pouch returned in place.","2019-09-08","","Completed","2019-09-03","No","No","No","Internal"]
[null,null,null,null,2592,"20/10/2019 00:23:33","2019-05-06","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Axe was missing from the axe box on upper deck.","LSA / FFA","LSA / FFA Appliances","Behaviour Based","5.43","High","","","Same to be put back.","2019-05-13","","Completed","2019-05-07","No","No","No","Internal"]
[null,null,null,null,2593,"20/10/2019 00:31:27","2019-05-06","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Aft Mooring winch gear oil sight glass is dirty and hence, oil level is not visible.","Mooring Mach.","Mooring","Equipment Related","10.25","Very High","","","Same to be cleaned","2019-06-06","","Completed","2019-05-09","No","No","No","Internal"]
[null,null,null,null,2594,"20/10/2019 00:43:56","2019-05-06","Deficiency","Ship Staff","Ship Staff Insp.","Aft hydraulic Mooring system, HP line flange in engine room(Boiler platform stbd side)  found having having leakage.","ER Pipes, valves & fittings","Mooring","Equipment Related","10.29","Medium","","","HP pipe line O rings to be renewed and tested, no leakage.","2019-05-15","","Completed","2019-05-15","No","No","No","Internal"]
[null,null,null,null,2595,"20/10/2019 9:24:10 AM","2019-05-06","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Mooring wire are found dry and muddy in appereance.","Mooring Mach.","Mooring","Behaviour Based","9.17","High","","","To be cleaned and greased.","2019-08-06","","Completed","2019-05-17","No","No","No","Internal"]
[null,null,null,null,2596,"20/10/2019 9:28:22 AM","2019-05-06","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Vent for emergency DG room cofferdam, is not stencilled.","Miscellaneous","Eng. / Strg. Comp.","Behaviour Based","11.17","Low","","","proper stenciling to be done.","2019-05-16","","Completed","2019-05-16","No","No","No","Internal"]
[null,null,null,null,2597,"20/10/2019 9:33:09 AM","2019-05-06","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Stencil for fire sensor at various locations are not proper.  Same is written by permanent marker","Miscellaneous","Emgcy. Systems","Behaviour Based","5.4","High","","","Proper stenciling to be done","2019-05-16","","Completed","2019-05-16","No","No","No","Internal"]
[null,null,null,null,2598,"20/10/2019 10:21:17 AM","2019-09-01","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Bosun Store-Instruction regarding fire extinguisher fallen on floor.","LSA / FFA","LSA / FFA Appliances","Behaviour Based","5.42","Medium","","","Instruction for fire extinguisher inside bosun store put back in place","2019-09-04","","Completed","2019-09-03","No","No","No","Internal"]
[null,null,null,null,2599,"20/10/2019 10:26:21 AM","2019-09-01","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Fire extinguisher at entrance to cargo pump room-not checked in Aug 2019","LSA / FFA","LSA / FFA Appliances","Behaviour Based","5.42","Medium","","","Fire extinguisher at the entrance of pump room Inspected.","2019-09-08","","Completed","2019-09-07","No","No","No","Internal"]
[null,null,null,null,2600,"20/10/2019 10:29:51 AM","2019-09-01","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Deck foam line valve in foam room(Valve 13)  leaking from gland.","LSA / FFA","LSA / FFA Appliances","Equipment Related","5.38","High","","","Foam line Valve No 13 Gland packing tightening well and it is rectified.","2019-09-08","","Completed","2019-09-07","No","No","No","Internal"]
[null,null,null,null,2601,"20/10/2019 10:36:29 AM","2019-09-01","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Deck foam pump inlet and outlet line pressurised(beacause  of sea water flushing valve leaking(","Deck Pipe / Fittings","LSA / FFA Appliances","Equipment Related","5.38","High","","","Flushing globe valve gland packing opened and lapping of surface carried.  Found holding good.","2019-09-19","","Completed","2019-09-19","No","No","No","Internal"]
[null,null,null,null,2602,"20/10/2019 1:41:51 PM","2019-09-01","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Stbd Windlass brg dry.  Greasing to be carried out.","Mooring Mach.","Mooring","Behaviour Based","9.2","Very High","","","Greasing carried out before heaving up anchor at Fujairah.","2019-09-20","","Completed","2019-09-20","No","No","No","Internal"]
[null,null,null,null,2603,"20/10/2019 1:45:51 PM","2019-09-01","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Mooring Choke on sunken deck not stencilled.","Mooring Mach.","Mooring","Behaviour Based","9.19","Low","","","Completed stenciling","2019-09-19","","Completed","2019-09-19","No","No","No","Internal"]
[null,null,null,null,2604,"20/10/2019 1:49:38 PM","2019-09-01","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Port Windlass Gear Oil look emulisified.  Gear Oil to be renewed.","Mooring Mach.","Mooring","Equipment Related","9.2","Very High","","","Port Windlass Gear Oil drained, cleaned inside chamber and renewed with new Oil.","2019-10-15","","Completed","2019-10-05","No","No","No","Internal"]
[null,null,null,null,2605,"20/10/2019 1:52:23 PM","2019-09-01","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Cargo Stripping Pump Gland Packing Leaking","Cargo Mach.","Cargo / Ballast Systems","Equipment Related","8.18","High","","","Cargo Stripping Pump gland Packing renewed.","2019-10-08","","Completed","2019-10-05","No","No","No","Internal"]
[null,null,null,null,2606,"21/10/2019 9:30:28 AM","2019-03-06","Deficiency","Ship Staff","Ship Staff Insp.","No.1 Main LO pump seal leak.","Aux. Mach.","Eng. / Strg. Comp.","Equipment Related","10.29","Medium","","","Pump seal has been renewed.","2019-06-05","","Completed","2019-03-18","No","No","No","Internal"]
[null,null,null,null,2607,"21/10/2019 9:37:06 AM","2019-05-06","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Poster for “Alkaline and acidic chemicals to be kept separate” is missing in chemical locker.","Documentation,Miscellaneous","Eng. / Strg. Comp.","Inappropriate Procedure","10.29","Medium","","","Poster prepared and posted","2019-05-13","","Completed","2019-05-10","No","No","No","External"]
[null,null,null,null,2608,"21/10/2019 9:41:48 AM","2019-05-06","Deficiency","Ship Staff","Ship Staff Insp.","Aft hydraulic mooring system, HP line flange in engine room ( boiler platform stbd side) found having leakage.","Mooring Mach.","Eng. / Strg. Comp.","Equipment Related","10.29","Medium","","","HP pipe flange O-rings renewed and tested, no leaks observed.","2019-05-15","","Completed","2019-05-15","No","No","No","Internal"]
[null,null,null,null,2609,"21/10/2019 9:47:21 AM","2019-09-01","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","In ECR AMS, communication error alarm existing for master clock interface","Elect. Mach. & Equip.","Eng. / Strg. Comp.","Equipment Related","10.32","Very High","","","As per message and instructions from Kamlesh, ROS 2 computer was restarted and alarm was reset / master clock synchronized.","2019-09-30","","Completed","2019-09-29","No","No","No","External"]
[null,null,null,null,2610,"21/10/2019 9:53:21 AM","2019-05-15","Deficiency","Ship Staff","Ship Staff Insp.","FWG Sea water inlet thermomter faulty","Aux. Mach.","Eng. / Strg. Comp.","Equipment Related","10.32","Very High","","","Thermometer renewed","2019-05-25","","Completed","2019-05-20","No","No","No","Internal"]
[null,null,null,null,2611,"21/10/2019 10:02:27 AM","2019-05-06","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","There is no protection / curtains for Aft hydraulics power panel, even though sea water line is passing near the starter panel. In forward store starter panel, arrangement is made but in aft it is missing. ","Miscellaneous","Eng. / Strg. Comp.","Inappropriate Procedure","10.37","Medium","","","Plastic curtain and rod fabricated and fitted in place.","2019-08-06","","Completed","2019-05-25","No","No","No","External"]
[null,null,null,null,2612,"21/10/2019 10:11:12 AM","2019-05-15","Deficiency","Ship Staff","Ship Staff Insp.","ME Fuel oil auto filter element discs poor condition/some damaged and needs to be renewed.","Aux. Mach.","Eng. / Strg. Comp.","Equipment Related","10.32","Very High","","","The correct filter elements supplied and replaced. ","2019-07-30","DSTA 190005/190056","Completed","2019-07-04","No","No","No","Internal"]
[null,null,null,null,2613,"21/10/2019 10:14:40 AM","2019-07-16","Breakdown","Ship Staff","Ship Staff Insp.","ME # 7 Unit PMI sensor cable accidentally cut","Main Engine ","Eng. / Strg. Comp.","Human Error","10.32","Very High","","","New complete sensor with cable and connector received at S'pore on 01 sept 19, fitted, checked, found normal reading. ","2019-09-15","RO -DSTA 190098","Completed","2019-09-02","No","No","No","Internal"]
[null,null,null,null,2614,"21/10/2019 10:18:48 AM","2019-07-16","Deficiency","Ship Staff","Ship Staff Insp.","IG Scrubber area - Oxygen sensor defective /calibration not possible.","Aux. Mach.","Eng. / Strg. Comp.","Equipment Related","10.32","Very High","","","New sensor received at S'pore on 01st New sensor received at S'pore on 01st Sept'19, fitted , calibrated and sensor reading normal.","2019-09-15","RO -DSTA 190062","Completed","2019-09-02","No","No","No","Internal"]
[null,null,null,null,2615,"21/10/2019 10:25:08 AM","2019-08-27","Breakdown","Ship Staff","Ship Staff Insp.","ME # 2 FO Circulating pump - drive screw sheared","Aux. Mach.","Eng. / Strg. Comp.","Equipment Related","10.32","Very High","","","Spare screw kit received at S'pore. Pump boxed back with new spares on 02nd Sept and tested on 03rd Sept. Found working satisfactory. ","2019-09-05","RO-DSTA 195041","Completed","2019-09-03","No","No","No","Internal"]
[null,null,null,null,2616,"21/10/2019 10:28:25 AM","2019-06-30","Breakdown","Ship Staff","Ship Staff Insp.","# 2 AE Lub oil priming pump motor - winding zero insulation","Elect. Mach. & Equip.","Eng. / Strg. Comp.","Equipment Related","10.32","Very High","","","New motor received at S'pore on 01st Sept'19. Fitted on 04th Sept and tested, working satisfactory.","2019-09-05","GC's143E,167E / RO -DSTA 190097","Completed","2019-09-04","No","No","No","Internal"]
[null,null,null,null,2617,"21/10/2019 10:33:44 AM","2019-09-01","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","ER vent fan control panel showing inverter alarm","Elect. Mach. & Equip.","Eng. / Strg. Comp.","Equipment Related","10.32","Very High","","","We have checked the inverter panel for the fans and had also tried to put off and on the power. As such there is no alarm on the inverter. The alarms seen on the remote (ECR) panel are of 2018 and don't know why they are showing. ","2019-09-11","","Completed","2019-09-10","No","No","No","External"]
[null,null,null,null,2618,"21/10/2019 10:38:42 AM","2019-08-15","Breakdown","Ship Staff","Ship Staff Insp.","ME #2 unit FO Distributor block and aft fuel valve HP pipe threads damaged.","Main Engine ","Eng. / Strg. Comp.","Equipment Related","10.32","Very High","","","New FO Distributor block with HP pipe and spares received & renewed. ","2019-09-15","RO-DSTA 195037","Completed","2019-09-09","No","No","No","Internal"]
[null,null,null,null,2619,"21/10/2019 10:44:36 AM","2019-09-01","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Steam leakage from overhead pipe aft of ME system oil storage tank","Deck Pipe / Fittings,ER Pipes, valves & fittings","Eng. / Strg. Comp.","Equipment Related","10.32","Very High","","","Gaskets renewed and leakage rectified. ","2019-10-01","","Completed","2019-09-14","No","No","No","External"]
[null,null,null,null,2620,"21/10/2019 10:48:22 AM","2019-09-01","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","SCR decomposition unit inlet thermometer faulty.","Aux. Mach.","Eng. / Strg. Comp.","Equipment Related","10.32","Very High","","","Thermometer renewed.","2019-09-30","","Completed","2019-09-21","No","No","No","External"]
[null,null,null,null,2621,"21/10/2019 10:52:00 AM","2019-09-01","Deficiency","Owner / Marine / Tech. Suptd.","Suptd. Insp.","220V low insulation- Insulation level at 2M ohm when deck lights are switched on.","Elect. Mach. & Equip.","Eng. / Strg. Comp.","Equipment Related","10.32","Very High","","","The low insulation was originating from the forward navigation light, same has been repaired and fault rectified. ","2019-09-30","","Completed","2019-09-27","No","No","No","External"]
[null,null,null,null,5599,"23/10/2019 9:55:21 AM","2019-09-01","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","LO drums were lifted without using safety lead to control swing. Crew to be briefed\t\t","Miscellaneous","Crew Management","Human Error,Inappropriate Procedure","5.11","Low","","","All crew briefed during toolbox meeting after  departure port","2019-09-08","","Completed","2019-09-04","No","No","No","Internal"]
[null,null,null,null,5600,"23/10/2019 9:58:29 AM","2019-09-01","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Small steels pipes in ER workshop not lashed\t","Miscellaneous","Eng. / Strg. Comp.","Behaviour Based,Inappropriate Procedure","5.11","Low","","","small steel pipes etc removed ,placed properly and lashed.","2019-09-04","","Completed","2019-09-03","No","No","No","Internal"]
[null,null,null,null,5601,"23/10/2019 10:02:42 AM","2019-09-01","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Grey water pump leaking from flange\t","ER Pipes, valves & fittings","Eng. / Strg. Comp.","Equipment Related","10.29","Medium","","","gasket changed, save all trays painted","2019-09-08","","Completed","2019-09-07","No","No","No","Internal"]
[null,null,null,null,5602,"23/10/2019 10:38:44 AM","2019-09-01","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","IG system fresh air intake flange wing nuts to ease up\t","Inert Gas","Eng. / Strg. Comp.","Equipment Related","10.29","Medium","","","Wing nuts eased up and greased","2019-09-08","","Completed","2019-09-08","No","No","No","Internal"]
[null,null,null,null,5603,"23/10/2019 10:42:18 AM","2019-09-01","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp."," MGO filling line safety valve opening pressure not stencilled\t\t\t\t\t\t\t\t","ER Pipes, valves & fittings","Eng. / Strg. Comp.","Behaviour Based,Equipment Related","10.8","Medium","","","opening pressure stencilled- 5.0bar","2019-09-08","","Completed","2019-09-03","No","No","No","Internal"]
[null,null,null,null,5604,"23/10/2019 10:45:07 AM","2019-09-01","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Lifting hooks in steering gear room\t","Miscellaneous","Eng. / Strg. Comp.","Inappropriate Procedure","10.28","Low","","","all hooks color coded and SWL color code laminated poster posted in steering gear room","2019-09-18","","Completed","2019-09-18","No","No","No","Internal"]
[null,null,null,null,5605,"23/10/2019 11:34:13 AM","2019-09-01","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Main engine attached hydraulic pump no:3 accumulator cap has fallen down\t","Main Engine ","Eng. / Strg. Comp.","Equipment Related","10.32","Very High","","","Cap fitted back","2019-09-30","","Completed","2019-09-25","No","No","No","Internal"]
[null,null,null,null,5606,"23/10/2019 11:37:34 AM","2019-09-01","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Rudder rams (P fwd & Aft) have more leakage than stbd ones\t","Aux. Mach.","Eng. / Strg. Comp.","Equipment Related","10.29","Medium","","","Packing gland tightened as per maker instructions, oil leak reduced, under observation","2019-10-01","","Completed","2019-09-25","No","No","No","Internal"]
[null,null,null,null,5607,"23/10/2019 11:40:32 AM","2019-09-01","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","In ECR ams, communication error alarm existing for master clock interface\t\t","Miscellaneous","Eng. / Strg. Comp.","Equipment Related","10.32","Very High","","","As per msg from Suptd. Kamlesh, ROS2 computer restarted annd alarm was reset. Master clock interface working in order.","2019-09-30","","Completed","2019-10-01","No","No","No","Internal"]
[null,null,null,null,5608,"23/10/2019 11:43:39 AM","2019-09-01","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Spare hydraulic motors for windlass and winch kept in steering gear room to identify and also update in PAL PMS\t","Miscellaneous","Eng. / Strg. Comp.","Behaviour Based","5.11","Low","","","Spare motors shifed to mid ship locker and location in PAL updated","2019-10-01","","Completed","2019-10-14","No","No","No","Internal"]
[null,null,null,null,5614,"23/10/2019 9:40:25 AM","2019-05-06","Deficiency","Ship Staff","Suptd. Insp.","ME LO Purifier temeprature is set at 88'c. temperature to be maintained at 95'C","Purifier","Eng. / Strg. Comp.","Equipment Related","10.32","Very High","","","All engineers briefed about the same.And temperature maintained at 95'C","2019-05-30","","Completed","2019-05-07","No","No","No","Internal"]
[null,null,null,null,5615,"23/10/2019 9:46:54 AM","2019-09-01","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","In ECR Alarm monitoring system \"MSBD abnormal\" alarm found offscan\t\t\t\t","Elect. Mach. & Equip.","Eng. / Strg. Comp.","Behaviour Based,Equipment Related","10.38","Medium","","","Removed from offscan, alarm reset","2019-09-02","","Completed","2019-09-01","No","No","No","Internal"]
[null,null,null,null,5616,"23/10/2019 11:46:19 AM","2019-09-01","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","C2E feed pump discharge pressure guage needle broken\t","ER Pipes, valves & fittings","Eng. / Strg. Comp.","Equipment Related","10.31","Very High","","","pressure guage renewed with spare","2019-10-08","","Completed","2019-10-15","No","No","No","Internal"]
[null,null,null,null,null,"20/10/2019 4:51:03 PM","2019-09-12","Deficiency","Ship Staff","Ship Staff Insp.","BWTS No 1 Loop Filter inlet valve BA 614 & No1 loop filter Bypass valve BA 616 suspect valve passing in closed position.","Deck Pipe / Fittings","Cargo / Ballast Systems","Equipment Related",6.21,"High","Not Applicable","Not Applicable","Both Vaves were observed for integrity during ballasting operation at PAL, USWC and confimred to be holding. Will monitor again during Ballast exchange prior arrival Loadport.","2019-12-11",null,"Completed","2019-11-09","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"]
["57","DHT STALLION (01-11-2019)","57_1574228066507.xlsm"]