{"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":25,"n_cols":28,"rows_kept":25,"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 PANTHER (20-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,2833,"2019-10-10 14:49:21.000","2019-06-10","Deficiency","Ship Staff","Ship Staff Insp.","Meat Room Fan found vibrating. On removal found one of the four fan blades cracked and almost falling off.","Accommodation ","Eng. / Strg. Comp.","Equipment Related","11.13","Low","","","Refrigearated garbage locker fan removed and fitted in Meat room. New fan requested.","2019-12-31","DPAN190120","In progress",null,"No","No","No","Internal","Extended target date to 31 DEC 2019 while waiting spare parts to deliver to final port destination."]
[null,null,null,null,2834,"2019-10-10 14:55:16.999","2019-08-18","Deficiency","Ship Staff","Ship Staff Insp.","IGS Deck seal pump Motor No. 1 bearing housing worn, motor to be replaced.","Inert Gas","Eng. / Strg. Comp.","Equipment Related","10.32","Very High","","","To be replaced from spare.","2019-12-31","DPAN190150","In progress",null,"No","No","No","Internal","Extended target date to 31 DEC 2019 while waiting spare parts to deliver to final port destination."]
[null,null,null,null,2835,"2019-10-10 14:24:44.000","2019-09-20","Deficiency","Ship Staff","Ship Staff Insp.","Electric ballast pump BWTS Filter - pressure transmitter is defective","Miscellaneous","Cargo / Ballast Systems","Equipment Related","6.22","Medium","","","Requisition raised","2019-12-31","DPAN190181","In progress",null,"No","No","No","Internal","Extended target date to 31 DEC 2019 while waiting spare parts to deliver to final port destination."]
[null,null,null,null,2836,"2019-10-10 14:49:14.000","2019-09-21","Deficiency","Ship Staff","Ship Staff Insp.","Engine room crane not responding for transverse movement.After inspection motor was found breaker coil open.","Miscellaneous","Eng. / Strg. Comp.","Equipment Related","10.32","Very High","","","Requested new breaking coil","2019-12-31","DPAN195063","In progress",null,"No","No","No","Internal","Extended target date to 31 DEC 2019 while waiting spare parts to deliver to final port destination."]
[null,null,null,null,2839,"2019-10-15 07:42:53.999","2019-10-14","Deficiency","Ship Staff","Ship Staff Insp.","IG blower No. 2 discharge valve pneumatic actuator found leaking.","Cargo Mach.","Eng. / Strg. Comp.","Equipment Related","10.32","Very High","","","The actuator needs to overhauled. Spare to order","2019-12-31","DPAN190214","Not Started",null,"No","No","No","Internal","RO DPAN190214. Procurement is following up. Still not quoted from any supplier yet. Sandesh is chasing."]
[null,null,null,null,6255,"Wed Oct 30 2019 11:01:16 GMT+0000 (Coordinated Universal Time)","2019-10-30","Deficiency","Ship Staff","Ship Staff Insp.","ECR Package aircon processor PCB defective, Compressor is not starting.","Air Comp.,Elect. Mach. & Equip.","Eng. / Strg. Comp.","Equipment Related","10.32","Very High","","","Need to order Spare PCB and to replace.","2020-01-16","DPAN190210","In progress",null,"No","No","No","Internal","PO# already issued to Korean supplier, OCEAN MARINE. Waiting for spare readiness."]
[null,null,null,null,6256,"Wed Nov 06 2019 08:52:57 GMT+0000 (Coordinated Universal Time)","2019-11-01","Observation","Ship Staff","Ship Staff Insp.","ME UNIT No 1 AND 4 LDCL LINER COOLING WATER OUTLET THERMOMETERS SHOWING INAPROPRIATE READING.","Main Engine ","Eng. / Strg. Comp.","Equipment Related","10.32","Very High","","","ALL UNITS THERMOMETERS CALIBRATED, UNIT No1 AND 4 TERMOMETERS REQUIRED REPLACEMENT.","2019-12-31","DPAN190215","Not Started",null,"No","No","No","Internal","Supplier is DINTEC. Spare parts readiness is 25th NOV 2019."]
[null,null,null,null,null,"2019-11-23T14:57:26","2019-11-08","Deficiency","Ship Staff","Ship Staff Insp.","NO.5 COT STBD SAAB RADAR GAUGING TGE DEFECTIVE . NOT SHOWING CARGO LEVEL DURING LOADING ","Hull & Tanks","Cargo / Ballast Systems","Equipment Related",null,null,"Not Applicable","Not Applicable","SPARE TGE REQUISTION RAISED , NEED TO REPLACED WHEN RECIEV SPARE","2019-12-10","DPAN190198","In progress",null,"No",null,null,"Internal"]

{"sheet":"Completed","index":1,"n_rows":78,"n_cols":28,"rows_kept":78,"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 PANTHER (20-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,2837,"2019-10-10 15:04:06.999","2019-10-05","Deficiency","Ship Staff","Ship Staff Insp.","HT & LT mixing 3 way valve is malfunctioning and the ME jacket water temperature is not maintaining in Auto mode.","Main Engine ","Eng. / Strg. Comp.","Equipment Related","10.32","Very High","","","he positioner to be calibrated at earliest opportunity","2019-10-30","","Completed","2019-10-30","No","No","No","Internal"]
[null,null,null,null,2838,"2019-10-14 17:57:02.000","2019-10-04","Observation","Ship Staff","Ship Staff Insp.","The blower duct drain line found to be choked","Miscellaneous","Eng. / Strg. Comp.","External Factors","10.32","Very High","","","The chocke to be cleared","2019-10-30","","Completed","2019-10-30","No","No","No","Internal"]
[null,null,null,null,2840,"2019-10-08 11:16:11.000","2019-01-17","Deficiency","Ship Staff","Ship Staff Insp.","Composite boiler port side safety valve gasket leakage during sea steaming.","Boiler","Crew Management","Equipment Related","10.29","Medium","","","Composite Boiler de-pressurised, Safety valve removed and gasket renewed with spare one. Boiler checked in running condition found no leaks.","2019-01-31","","Completed","2019-01-25","No","No","No","Internal"]
[null,null,null,null,2841,"2019-10-08 11:25:25.000","2019-02-26","Deficiency","Ship Staff","Ship Staff Insp.","AE #3 Turbocharger Cartridge lube oil leak","Aux. Engine","Eng. / Strg. Comp.","Equipment Related","10.32","Very High","","","AE #3 Turbocharger cartridge replaced with spare one. Generator tested on load gradullay to maximum and found running satisfactory.","2019-02-26","","Completed","2019-02-26","No","No","No","Internal"]
[null,null,null,null,2842,"2019-10-08 11:45:38.000","2018-12-10","Deficiency","Ship Staff","Ship Staff Insp.","ECP - AMS PANEL - NO.2 LCD Monitor defective. No Display","Miscellaneous","Eng. / Strg. Comp.","Equipment Related","10.32","Very High","","","New LCD Monitor received on 2 Mar 2019 at Singapore. Same renewed found working satisfactory.","2018-12-31","DPAN190003","Completed","2019-03-04","No","No","No","Internal"]
[null,null,null,null,2843,"2019-10-08 11:56:47.999","2019-01-03","Deficiency","Ship Staff","Ship Staff Insp.","Incinerator Sluice inside door non operational.","Aux. Mach.","Eng. / Strg. Comp.","Equipment Related","10.32","Very High","","","Solenoid valve SV8 for air cylinder inside door received at Singapore on 2 Mar 2019. Same renewed found sluice door operating normal","2019-01-31","DPAN190005","Completed","2019-03-04","No","No","No","Internal"]
[null,null,null,null,2844,"2019-10-08 12:29:36.000","2019-01-04","Deficiency","Ship Staff","Ship Staff Insp.","Electric horn for light signal column at two p0laces in engine room not working.","Elect. Mach. & Equip.","Eng. / Strg. Comp.","Equipment Related","10.32","Very High","","","Speakers renewed and found working satisfactory","2019-01-31","DPAN190006","Completed","2019-03-04","No","No","No","Internal"]
[null,null,null,null,2845,"2019-10-08 14:54:43.000","2019-02-03","Deficiency","Ship Staff","Ship Staff Insp.","Main engine JCW Pump #2 Mechanical Seal leak.","Aux. Mach.","Eng. / Strg. Comp.","Equipment Related","10.32","Very High","","","Pump discharge valve renewed on 2 Mar 2019 at Singapore. Pump overhauled Mechanical seal renewed and pump tested found running satisfactory. ","2019-03-03","DPAN190037","Completed","2019-03-04","No","No","No","Internal"]
[null,null,null,null,2846,"2019-10-08 15:03:09.999","2019-01-22","Deficiency","Ship Staff","Ship Staff Insp.","Power supply unit for Local fire fighting system in engine room malfunction.","LSA / FFA","Eng. / Strg. Comp.","Equipment Related","12.15","High","","","Requisirion received on 2 Mar 2019. Power supply unit renewed found local fire fighting system working normal.","2019-03-10","DPAN190031","Completed","2019-03-05","No","No","No","Internal"]
[null,null,null,null,2847,"2019-10-08 15:23:04.999","2019-03-02","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Stbd. windlass gear case oil seems mixed with water in apperance. Oil to be renewed and leak source to be identified. While renewal of oil, gasket of inspection door also to be renewed, suspecting water leaking from there.","Mooring Mach.","Mooring","Equipment Related","9.14","Medium","","","Gear oil and inspection door gasket renewed.","2019-03-09","","Completed","2019-03-06","No","No","No","Internal"]
[null,null,null,null,2848,"2019-10-08 15:46:10.000","2019-03-02","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","The spool of sludge transfer from E/R to slop tank is store at entrance of pump room. The location is marked by writing with marker pen. Permanent stencil to be done from same.","Miscellaneous","General Appearance","Human Error","6.14","High","","","Stencil done","2019-03-09","","Completed","2019-03-05","No","No","No","Internal"]
[null,null,null,null,2849,"2019-10-08 15:50:32.000","2019-03-02","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Inventory for cargo sample and bunker sample to be kept in chemical locker where the samples are stored.","Miscellaneous","Crew Management","Human Error","5.48","Medium","","","Inventory list kept in paint locker","2019-03-09","","Completed","2019-03-06","No","No","No","Internal"]
[null,null,null,null,2850,"2019-10-08 15:57:27.999","2019-03-02","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","One of the flash light in helicopter kit was not operational, same renewed during inspection. Concerned officer to be briefed to carry out proper checks during his inspection","LSA / FFA","LSA / FFA Appliances","Human Error","5.13","High","","","Renewed at the time of inspection and concerned officer briefed.","2019-03-09","","Completed","2019-03-02","No","No","No","Internal"]
[null,null,null,null,2851,"2019-10-08 16:00:42.000","2019-03-02","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Poster for \"alkalis and Acids must be kept separate to be displayed in chemical locker","Miscellaneous","Eng. / Strg. Comp.","Human Error","10.29","Medium","","","Poster displayed","2019-03-09","","Completed","2019-03-05","No","No","No","Internal"]
[null,null,null,null,2852,"2019-10-08 16:04:12.000","2019-03-02","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Marking on floor, for fire sensors were missing in chemical and paint locker","LSA / FFA","LSA / FFA Appliances","Human Error","10.29","Medium","","","Marking on floor carried out and IMO symbol posted","2019-03-09","","Completed","2019-03-05","No","No","No","Internal"]
[null,null,null,null,2853,"2019-10-08 16:08:11.000","2019-03-02","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Only one way communication was possible with sound powered head phone at ME emergency platform.","Elect. Mach. & Equip.","Eng. / Strg. Comp.","Equipment Related","10.41","Medium","","","Phone working normal","2019-03-09","","Completed","2019-03-05","No","No","No","Internal"]
[null,null,null,null,2854,"2019-10-08 16:13:10.000","2019-03-02","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Dedicated wheel spanner to be kept near emergency bilge suction valve in engine room.","LSA / FFA","Eng. / Strg. Comp.","Human Error","10.16","Very High","","","Wheel spanner kept near Emergency Bilge suction","2019-03-12","","Completed","2019-03-05","No","No","No","Internal"]
[null,null,null,null,2855,"2019-10-08 16:17:04.000","2019-03-02","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Level gauge for grey water holding tank in-operational.","Aux. Mach.","Eng. / Strg. Comp.","Equipment Related","10.26","High","","","Zero calibration carried out, working normal.","2019-05-02","","Completed","2019-03-02","No","No","No","Internal"]
[null,null,null,null,2856,"2019-10-08 16:21:39.999","2019-03-02","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","One of the vent at stbd side, Engine room blower platform is not marked.","Miscellaneous","Eng. / Strg. Comp.","Human Error","11.7","High","","","Stenciled 'Air bottle safety valve release pipe'","2019-03-08","","Completed","2019-03-06","No","No","No","Internal"]
[null,null,null,null,2857,"2019-10-08 16:25:26.000","2019-03-02","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Autyo drains of all the air bottles were kept shut. Same was opened during inspection. All officers and crew to be briefed about the importance of auto drains and keeping it open.","Aux. Engine","Eng. / Strg. Comp.","Inappropriate Procedure","10.32","Very High","","","Opened and all engine staff's briefing carried out","2019-03-09","","Completed","2019-03-02","No","No","No","Internal"]
[null,null,null,null,2858,"2019-10-08 16:33:17.000","2019-03-02","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Very less exit signs were there around ME bottom platform. More signs to be pasted, so that from each location at least one exit sign is visible.","LSA / FFA","Eng. / Strg. Comp.","Human Error","10.15","Low","","","Additional IMO symbols for Emergency Exit Posted in bottom platform","2019-03-12","","Completed","2019-03-05","No","No","No","Internal"]
[null,null,null,null,2859,"2019-10-08 16:36:09.000","2019-03-02","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Emergency fire pump space drain valve  ( spring Loaded) at bottom platform is very hard to operated. Same to be made free.","ER Pipes, valves & fittings","Eng. / Strg. Comp.","Equipment Related","10.16","Very High","","","Spring loaded valve eased up.","2019-03-12","","Completed","2019-03-02","No","No","No","Internal"]
[null,null,null,null,2860,"2019-10-08 16:48:03.000","2019-03-02","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Near generators both side, lot of dust and soot found accumulated. Same to be cleaned","Miscellaneous","Eng. / Strg. Comp.","Human Error","10.32","Very High","","","Cleaned","2019-03-17","Nil","Completed","2019-03-04","No","No","No","Internal"]
[null,null,null,null,2861,"2019-10-08 16:53:37.000","2019-03-02","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Dried water leakage marks sighted on pipe lines above the boiler feed water pump area. To be cleaned and painted.","Miscellaneous","Eng. / Strg. Comp.","Human Error","10.32","Very High","","","Cleaned and painted","2019-03-17","Nil","Completed","2019-03-04","No","No","No","Internal"]
[null,null,null,null,2862,"2019-10-08 17:04:50.000","2019-03-02","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Pipe lines top around ME cylinder head platform, found covered with dust and soot. To be cleaned.","Miscellaneous","Eng. / Strg. Comp.","Human Error","10.32","Very High","","","Cleaned","2019-03-12","Nil","Completed","2019-03-04","No","No","No","Internal"]
[null,null,null,null,2863,"2019-10-08 17:34:49.000","2019-03-02","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Various important alarms found to be off scanned in AMS. All engineers must be briefed to check the alarm pannel before putting UMS","LSA / FFA","Eng. / Strg. Comp.","Human Error","10.32","Very High","","","All off scanned alarms removed","2019-03-09","","Completed","2019-03-02","No","No","No","Internal"]
[null,null,null,null,2864,"2019-10-08 17:38:00.000","2019-03-02","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Stbd boiler grating area near the main steam stop valve , found to be in dirty condition. Same to be cleaned. Picture attached.","Miscellaneous","Eng. / Strg. Comp.","Human Error","10.29","Medium","","","Cleaned.","2019-03-12","","Completed","2019-03-04","No","No","No","Internal"]
[null,null,null,null,2865,"2019-10-08 17:40:33.000","2019-03-02","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Face shield to be kept near the fuel injector testing area.","LSA / FFA","Eng. / Strg. Comp.","Human Error","5.5","Low","","","Face shield kept in place","2019-03-09","","Completed","2019-03-04","No","No","No","Internal"]
[null,null,null,null,2866,"2019-10-08 17:44:09.999","2019-01-06","Deficiency","Owner / Marine / Tech. Suptd.","Ship Staff Insp.","Navtex printer non operational","Nav & comm. equip.","Navigation","Equipment Related","","","","","Printer head renewed and found printing satisfactorily.","2019-01-31","DPAN190015","Completed","2019-03-16","No","No","No","Internal"]
[null,null,null,null,2867,"2019-10-08 17:48:18.000","2019-03-02","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Keep chains at various locations on main deck needs to be painted, Otherwise soon it will start rusting.","Miscellaneous","General Appearance","External Factors","11.3","Medium","","","Chains painted","2019-04-02","","Completed","2019-03-30","No","No","No","Internal"]
[null,null,null,null,2868,"2019-10-08 17:52:34.999","2019-03-02","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Thick rust sighted at HFO bunker line aft portion. Understand from C/O upgradation is in progress and aft portion of pipe lines are only remaining. To be completed.","Deck Pipe / Fittings","General Appearance","External Factors","11.4","Very High","","","Frames and pipe lines derusted and painted.","2019-05-02","","Completed","2019-03-30","No","No","No","Internal"]
[null,null,null,null,2869,"2019-10-09 08:30:58.000","2019-04-03","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Below the ME Intermediate Shaft Bearing has drip containers.","ER Pipes, valves & fittings","Eng. / Strg. Comp.","Human Error","10.32","Very High","","","Drip container removed","2019-06-03","","Completed","2019-04-03","No","No","No","Internal"]
[null,null,null,null,2870,"2019-10-09 08:35:20.999","2019-04-03","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","ME No.1 and No. 2 Turbocharger air filters are very dirty.","Main Engine ","Eng. / Strg. Comp.","Human Error","10.32","Very High","","","T/Ch felt filters renewed, its being done on weekly basis.","2019-04-20","","Completed","2019-04-03","No","No","No","Internal"]
[null,null,null,null,2871,"2019-10-09 08:39:04.000","2019-04-03","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","All D/G Turbocharger air filters are very dirty.","Aux. Engine","Eng. / Strg. Comp.","Human Error","10.32","Very High","","","T/C felt filters renewed, its being done on weekly basis","2019-04-03","","Completed","2019-04-03","No","No","No","Internal"]
[null,null,null,null,2872,"2019-10-09 08:43:42.000","2019-04-03","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","IG Blower deck vibration to put as defect in the REFMAN.","ER Pipes, valves & fittings","Eng. / Strg. Comp.","Industry Issue","10.12","Very High","","","Defect added to REFMAN.","2019-04-10","","Completed","2019-04-08","No","No","No","Internal"]
[null,null,null,null,2873,"2019-10-09 08:48:00.000","2019-04-03","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Steam Dumping line has one flange gasket is leaking steam.","ER Pipes, valves & fittings","Eng. / Strg. Comp.","Equipment Related","10.29","Medium","","","Gasket is renewed and leak rectified.","2019-06-03","","Completed","2019-04-05","No","No","No","Internal"]
[null,null,null,null,2874,"2019-10-09 09:00:04.000","2019-04-03","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Emergency Fire Pump suction valve hydraulic pump unit is leaking oil onto the deck.","LSA / FFA","Eng. / Strg. Comp.","Equipment Related","10.32","Very High","","","Leakage from level gauge sight glass rectifiedby putting teflon packing.","2019-04-03","","Completed","2019-04-03","No","No","No","Internal"]
[null,null,null,null,2875,"2019-10-09 09:05:04.000","2019-04-03","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","LDCL Pump motor cooling air duct to put as defect in the REFMAN","ER Pipes, valves & fittings","Eng. / Strg. Comp.","Industry Issue","10.12","Very High","","","Defect added to REFMAN.","2019-04-10","","Completed","2019-04-08","No","No","No","Internal"]
[null,null,null,null,2876,"2019-10-09 10:38:26.999","2019-04-06","Breakdown","Ship Staff","Ship Staff Insp.","No. 2 cargo pump discharge side NRV suspected blocked.","Cargo Mach.","Cargo / Ballast Systems","Equipment Related","8.11","Medium","","","Opened and Inspected, and fouled wires and sediments removed","2019-04-06","","Completed","2019-04-06","No","No","No","Internal"]
[null,null,null,null,2877,"2019-10-09 10:43:20.999","2019-04-03","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","P and S life boat canopy has discoloured","LSA / FFA","LSA / FFA Appliances","Equipment Related","5.27","Medium","","","Cleaned and painted","2019-06-04","","Completed","2019-04-04","No","No","No","Internal"]
[null,null,null,null,2878,"2019-10-09 15:56:21.000","2019-03-12","Deficiency","Ship Staff","Ship Staff Insp.","ME JCW Pump #2 Discharge flange gasket drop leak. Pump isolation tried out and found suction valve not holding.","ER Pipes, valves & fittings","Eng. / Strg. Comp.","Equipment Related","10.32","Very High","","","New spare valve received and renewed. Leakage rectified.","2019-04-12","DPAN190067","Completed","2019-06-08","No","No","No","Internal"]
[null,null,null,null,2879,"2019-10-09 16:04:27.999","2019-06-06","Deficiency","Ship Staff","Ship Staff Insp.","Slop stbd tank ullage showing error reading on the display monitor","Cargo Mach.","Cargo / Ballast Systems","Equipment Related","8.12","Medium","","","Tank isolated and cleaned transmitter","2019-06-10","","Completed","2019-06-06","No","No","No","Internal"]
[null,null,null,null,2880,"2019-10-09 16:10:54.000","2019-03-02","Deficiency","Owner / Marine / Tech. Suptd.","Suptd. Insp.","At random various inventory location checked in PAL and found various location missing. To be updated.","Documentation","Crew Management","Human Error","10.12","Very High","","","Inventory having zero ROB, location in PAL not mentioned. Same is in progress.","2019-06-02","","Completed","2019-06-20","No","No","No","Internal"]
[null,null,null,null,2881,"2019-10-09 16:15:26.000","2019-06-11","Deficiency","Ship Staff","Ship Staff Insp.","ME L.O. AUTO-FILTER HYDRAULIC MOTOR NOT ROTATING","Main Engine ","Eng. / Strg. Comp.","Equipment Related","10.32","Very High","","","Renewed hydraulic motor with spare ones received.","2019-07-15","DPAN190127","Completed","2019-08-08","No","No","No","Internal"]
[null,null,null,null,2882,"2019-10-10 08:16:29.000","2019-05-23","Deficiency","Ship Staff","Ship Staff Insp.","O2 Alarm Hooter - Fixed Gas DEtecting system not working","Inert Gas","Eng. / Strg. Comp.","Equipment Related","10.32","Very High","","","Office informed. Communication with office in progress. New hooter received and installed. Tried out working satisfactory.","2019-05-31","DPAN195029","Completed","2019-08-10","No","No","No","Internal"]
[null,null,null,null,2883,"2019-10-10 08:21:15.000","2019-05-27","Deficiency","Ship Staff","Ship Staff Insp.","F.O.auto-backwash filter diversion chamber companion spacer damage.","Main Engine ","Eng. / Strg. Comp.","Equipment Related","10.32","Very High","","","Companion spacer renewed with spare received in Capetown.","2019-06-02","","Completed","2019-08-24","No","No","No","Internal"]
[null,null,null,null,2884,"2019-10-10 08:27:49.000","2019-05-27","Deficiency","Ship Staff","Ship Staff Insp.","F.O. auto-backwash Filter casing leaking internally between Auto & Bypass chambers.","Aux. Engine","Eng. / Strg. Comp.","Equipment Related","10.32","Very High","","","Spares received, Casing was unable to supply.","2019-06-02","DPAN190114","Completed","2019-08-28","No","No","No","Internal"]
[null,null,null,null,2885,"2019-10-10 10:10:39.999","2019-06-23","Deficiency","Ship Staff","Ship Staff Insp.","Rudder Carrier grease pump Limit switch Activation Lever worn.","Miscellaneous","Eng. / Strg. Comp.","Equipment Related","10.32","Very High","","","Spare received and distributing valve block along with sensor renewed. Now working satisfactory.","2019-09-10","DPAN190128","Completed","2019-09-27","No","No","No","Internal"]
[null,null,null,null,2886,"2019-10-10 10:16:13.000","2019-05-16","Deficiency","Ship Staff","Ship Staff Insp.","Hotwel salinometer defective, Monitor outdated","Boiler","Eng. / Strg. Comp.","Equipment Related","10.32","Very High","","","New Salinometer received and installed, working satisfactory.","2019-08-31","DPAN190128","Completed","2019-09-27","No","No","No","Internal"]
[null,null,null,null,2887,"2019-10-10 10:50:38.000","2019-05-24","Deficiency","Ship Staff","Ship Staff Insp.","UV Sterilizer one ballast defective","Miscellaneous","Eng. / Strg. Comp.","Equipment Related","10.32","Very High","","","The defective ballast renewed with spare received at Singapore.","2019-08-31","DPAN190109","Completed","2019-09-28","No","No","No","Internal"]
[null,null,null,null,2888,"2019-10-10 10:54:12.000","2019-03-10","Deficiency","Ship Staff","Ship Staff Insp.","Fuel oil heaters thermometer defective","Miscellaneous","Eng. / Strg. Comp.","Equipment Related","10.32","Very High","","","Defective thermometers of all the Fuel oil heaters in Engine room renewed.","2019-04-10","DPAN190065","Completed","2019-09-30","No","No","No","Internal"]
[null,null,null,null,2889,"2019-10-10 10:58:05.000","2019-04-26","Deficiency","Ship Staff","Ship Staff Insp.","LDCL Sensor for Main Engine Cylinder Liner FW cooling Temperature non functional.","Main Engine ","Eng. / Strg. Comp.","Equipment Related","10.32","Very High","","","Renewed sensor and now LDCL sensor working asatisfactory.","2019-10-25","DPAN190090","Completed","2019-10-04","No","No","No","Internal"]
[null,null,null,null,2890,"2019-10-10 14:53:26.000","2019-10-02","Deficiency","Ship Staff","Ship Staff Insp.","All three AE's exhaust line draine to the sealing pot valve was closed and all drain lines was chocked.","Aux. Engine","Eng. / Strg. Comp.","Inappropriate Procedure","10.32","Very High","","","The vessel cleared all lines and now all three valves from exh. line to seal pot are opened","2019-10-10","","Completed","2019-10-05","No","No","No","Internal"]
[null,null,null,null,2891,"2019-10-10 12:32:16.000","2019-04-26","Deficiency","Ship Staff","Ship Staff Insp.","WBTS TRO PCB FOR APT NOT WORKING, CHECKED BY SERVICE ENGINEER","Miscellaneous","Eng. / Strg. Comp.","Equipment Related","6.21","High","","","SPARE PCB SUPPLIED  BY MAKER APPROVED SUPPLIER, FOUND TO BE NOT PROGRAMMED CORRECTLY. RECONDITION PCB RECIEVED ON 23RD SEPTEMBER AT SINGAPORE AND INSTALLED, PCB WORKING SATISFACTORY.","2019-10-15","DPAN1900066","Completed","2019-10-09","No","No","No","Internal"]
[null,null,null,null,2892,"2019-10-10 12:39:07.000","2019-04-26","Deficiency","Ship Staff","Ship Staff Insp.","WBTS TRO SOLENOID VALVES T3 & T4 Not operational for APT ballast/Deballast operations. N1 & N2 Neutralizing unit solenoid valves XV-1321 & XV-1322 non operational.","Miscellaneous","Eng. / Strg. Comp.","Equipment Related","6.21","High","","","Checked & found by service engineer, to replace valves on warranty & try system on auto mode.SOLENOID VALVE RECIEVED ON 23RD AT SINGAPORE. T3 & T4 rep[laced and tested working in order. XV 1321 / XV 1322 wrong supply, old solenoid overhauled and fitted , system tested found working satisfactory.","2019-10-15","Defective PCB Supplied at LONG BEACH","Completed","2019-10-09","No","No","No","Internal"]
[null,null,null,null,2893,"2019-10-10 14:58:27.999","2019-08-20","Deficiency","Ship Staff","Ship Staff Insp.","Top Bracing for Main Engine 3rd from forward leaking internally.","Miscellaneous","Eng. / Strg. Comp.","Equipment Related","10.32","Very High","","","The indicator is on the green band. The setting done as per the instruction manual","2019-10-25","DPAN190134","Completed","2019-10-14","No","No","No","Internal"]
[null,null,null,null,2894,"2019-10-14 18:01:45.000","2019-10-04","Observation","Ship Staff","Ship Staff Insp.","Aux. Boiler, Incinerator and Composite boiler exhaust drain line to sealing pot choked.","Miscellaneous","Eng. / Strg. Comp.","External Factors","10.32","Very High","","","All the drain line were removed from place and chocke cleared.","2019-10-15","","Completed","2019-10-09","No","No","No","Internal"]
[null,null,null,null,2895,"2019-10-14 18:06:31.000","2019-10-08","Observation","Ship Staff","Ship Staff Insp.","Electroliser feed water heat exchanger sea water inlet line leaking from flange.","Miscellaneous","Eng. / Strg. Comp.","Equipment Related","10.29","Medium","","","The leakage rectified by renewing the gasket","2019-10-20","","Completed","2019-10-12","No","No","No","Internal"]
[null,null,null,null,5690,"14/10/2019 5:57:02 PM","2019-10-04","Observation","Ship Staff","Ship Staff Insp.","The blower duct drain line found to be choked","Miscellaneous","Eng. / Strg. Comp.","External Factors","10.32","Very High","","","The chocke to be cleared.Drain line cleaned and painted.","2019-10-30","","Completed","2019-10-16","No","No","No","Internal"]
[null,null,null,null,6257,"Wed Nov 06 2019 08:46:08 GMT+0000 (Coordinated Universal Time)","2019-10-18","Deficiency","Ship Staff","Ship Staff Insp.","AE FUEL OIL AUTO FILTER CHANGE OVER COCK BY PASS FILTER NOT HOLDING","ER Pipes, valves & fittings","Eng. / Strg. Comp.","Equipment Related","10.32","Very High","","","COMPLETE CHANGE OVER COCK RENEWED","2019-10-31","DPAN190114","Completed","2019-10-30","No","No","No","Internal"]
[null,null,null,null,6258,"43768.4621527778","2019-10-30","Deficiency","Ship Staff","Ship Staff Insp.","Composite Boiler Burner Electric Tracing Heater not working.","Boiler","Eng. / Strg. Comp.","Equipment Related","10.32","Very High","","","Need to replaced electric heating element, need to raise Po.Wrong cabling in control circuit. same re-wirring done system working in order.","2020-01-16","DPAN190213-Cancelled","Completed","2019-11-13","No","No","No","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"]
["51","DHT PANTHER (20-11-2019)","51_1574232359020.xlsm"]