{"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":24,"n_cols":27,"rows_kept":24,"cut":false,"hidden":false,"merged":[[12,6,12,26],[8,6,8,26],[10,8,10,9],[10,12,10,13]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Defect - Damage Monitoring Sheet"]
[]
[null,null,null,null,null,null,null,"Date of Report","02-Oct-2019",null,null,"Ship Name","DHT SCANDINAVIA"]
[]
[]
[]
[]
[]
[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"]
[null,null,null,null,null,"2019-07-10T02:02:39","2019-07-06","Deficiency","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Hose crane Emergency pump for Hoist/Luff operation missing, emergency procedures not tried out","Deck Mach.","Mooring","Equipment Related",8.5,"Medium","Not Applicable","Not Applicable","To locate for the hand pump, carry out emerg ops drill and include in PAL as reqd. ","2019-09-22","SCAN190177","In progress",null,"No",null,null,"Internal"]
[null,null,null,null,null,"2019-07-10T02:04:42","2019-07-06","Deficiency","Owner / Marine / Tech. Suptd.","Suptd. Insp.","LT cooling line to AEs, running below AE Gen platform – soft patch and leaking","Aux. Engine","Eng. / Strg. Comp.","Equipment Related",10.32,"Very High","Not Applicable","Not Applicable","To look at possibility of repairing the patch on the line after isolating/back up on Emerg gen running for ","2019-09-12",null,"In progress",null,"No",null,null,"Internal"]
[null,null,null,null,null,"2019-07-10T02:09:03","2019-07-10","Deficiency","Ship Staff","Ship Staff Insp.","5P I.G pressure not showing on SAAB radar screen","Cargo Mach.","Cargo / Ballast Systems","Equipment Related",8.1300000000000008,"Medium","Not Applicable","Not Applicable","Troubleshooting done. Pressure sensor faulty. Same to be renewed. Reqn raised.","2019-08-15","SCAN190136","In progress",null,"No",null,null,"Internal"]
[null,null,null,null,null,"2019-07-10T02:11:44","2019-07-16","Deficiency","Ship Staff","Ship Staff Insp.","5C C.O.T level and I.G pressure not showing on SAAB radar screen and Loadicator","Cargo Mach.","Cargo / Ballast Systems","Equipment Related",8.1300000000000008,"Medium","Not Applicable","Not Applicable","Troubleshooting done. Electronic box to be supplied to vsl to rectify defect.","2019-09-21","SCAN190136","In progress",null,"No",null,null,"Internal"]
[null,null,null,null,null,"2019-07-10T06:26:06","2019-09-15","Deficiency","Ship Staff","Ship Staff Insp.","QMI MIST DETECTOR AUX BOILER NO 1 NOT OPERATIONAL ","Elect. Mach. & Equip.","Eng. / Strg. Comp.","Equipment Related",5.35,"Medium","Not Applicable","Not Applicable","DETECTOR DISMANTLED AND CLEANED AND FITTED BACK BUT NO POSITIVE RESULT , NEED TO REPLACE THE DETECTOR . RO SCAN190137","2019-10-15","SCAN190137","In progress",null,"No",null,null,"Internal"]
[null,null,null,null,null,"2019-07-10T06:33:22","2019-09-22","Deficiency","Owner / Marine / Tech. Suptd.","Suptd. Insp.","145 ltr foam fire extinguisher on boiler platform having superficial cracks on the flexible hose","LSA / FFA","LSA / FFA Appliances","Equipment Related",5.42,"Medium","Not Applicable","Not Applicable","Requistion for new hose raised. To renew after receipt of same.","2019-10-22","SCAN 190174","In progress",null,"No",null,null,"Internal"]
[null,null,null,null,null,null,"2019-09-22","Deficiency","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Whistle for 1 nos SCBA set (Helicopter Equipment) not working","LSA / FFA","LSA / FFA Appliances","Equipment Related",5.43,"High","Not Applicable","Not Applicable","Requistion for new whistle raised. To renew after receipt of same.","2019-10-22","SCAN 190174","In progress",null,"No",null,null,"Internal"]

{"sheet":"Completed","index":1,"n_rows":108,"n_cols":27,"rows_kept":108,"cut":false,"hidden":false,"merged":[[8,6,8,26],[10,8,10,9],[10,12,10,13],[12,6,12,26]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Defect - Damage Monitoring Sheet"]
[]
[null,null,null,null,null,null,null,"Date of Report","2-9-2019",null,null,"Ship Name","DHT SCANDINAVIA"]
[]
[]
[]
[]
[]
[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"]
[null,null,null,null,null,"2019-10-07T05:08:43","2019-07-06","Deficiency","Owner / Marine / Tech. Suptd.","Suptd. Insp.","ER arrival checklist not updated and signed – pages found blank","Miscellaneous","Eng. / Strg. Comp.","External Factors,Human Error",4.3,"Medium","Not Applicable","Not Applicable","Checklists are supposed to be diligently followed and updated and it’s a NC – for not following SMS procdures","2019-07-12",null,"Completed","2019-07-12","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-07T02:34:48","2019-01-06","Deficiency","Ship Staff","Ship Staff Insp.","DG LO purifier motor found with abnormal sound while running","Purifier","Eng. / Strg. Comp.","Equipment Related",10.32,"Very High","Not Applicable","Not Applicable","Motor overhauled , bearings renewed,working satisfactory.JOB ORDER NO : (V-SCAN017100/19)","2019-01-30",null,"Completed","2019-01-07","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-05T23:29:13","2019-01-07","Observation","Ship Staff","Ship Staff Insp.","Window wiper ( No.2 Stbd side)  found not working ","Nav & comm. equip.","Navigation","Equipment Related",12.1,"High","Not Applicable","Not Applicable","Carriage plate renewed with new spare, working satifactory.JOB ORDER NO : (V-SCAN017039/19) ","2019-01-29",null,"Completed","2019-01-09","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-07T02:41:54","2019-01-09","Deficiency","Ship Staff","Ship Staff Insp.","Main air compressor#2 auto unloading valve found not operating ","Air Comp.","Eng. / Strg. Comp.","Equipment Related",10.32,"Very High","Not Applicable","Not Applicable","Renewed with spare valve, working satisfactory .JOB ORDER NO :(V-SCAN 017040/19)","2019-01-30",null,"Completed","2019-01-10","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-07T04:47:08","2019-01-27","Deficiency","Ship Staff","Ship Staff Insp.","AE#2 auto start malfunctioning. AE#2 starting in auto except when it is in block condition ,while AE#3 starting/running ","Aux. Engine","Eng. / Strg. Comp.","Equipment Related",10.32,"Very High","Not Applicable","Not Applicable","Hyundai technician attended job at Singapore on 14/03/2019 . Found short circuit on cable from instrument panel to junction box. Same to be renewed. Temporarily shorting cables disconnected. Plan to swap the cable between No 1 & No 2 AE and test (18 Mar 2019). Spare cable to be arranged through Hyundai. Reqn pending.","2019-02-28","SCAN190058","Completed","2019-07-09","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-05T23:54:51","2019-02-03","Deficiency","Ship Staff","Ship Staff Insp.","STBD Bridge Wing Rudder Angle Indicator Dimmer Not Working","Nav & comm. equip.","Navigation","Equipment Related",8.1199999999999992,"Medium","Not Applicable","Not Applicable","Renewed with new spare PCB ,working satisfactory.unplaned job order no : V-SCAN018052/19","2019-03-07","SCAN190013","Completed","2019-03-07","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-05T23:46:18","2019-02-10","Deficiency","Ship Staff","Ship Staff Insp.","Angle indcator units for Port & Stbd gangways found damaged","Deck Pipe / Fittings","General Appearance","Equipment Related",5.47,"Medium","Not Applicable","Not Applicable","Fabricated new angle indicator units and renewed for both Port and Stbd gangways.","2019-02-15",null,"Completed","2019-02-13","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-05T23:33:31","2019-02-12","Deficiency","Ship Staff","Ship Staff Insp.","Deck seal water pressure switch found defective and giving alarm","Inert Gas","Cargo / Ballast Systems","Equipment Related",8.35,"Medium","Not Applicable","Not Applicable","Renewed with new pressure switch of same range . RO raised for spare. JOB ORDER NO: (V-SCAN017516/19)","2019-02-18","SCAN190020","Completed","2019-02-12","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-05T23:39:09","2019-02-12","Deficiency","Ship Staff","Ship Staff Insp.","Analyse Pump for Fix gas detection systm for ballast tank giving abnormal sound.","Miscellaneous","Cargo / Ballast Systems","Equipment Related",5.21,"Medium","Not Applicable","Not Applicable","Pump overhauled and Pump Diaphragm renewed. Pump tested and working satisfactory.JOB ORDER NO :(V-SCAN017523/19)","2019-02-15",null,"Completed","2019-02-12","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-06T00:22:06","2019-02-13","Deficiency","Ship Staff","Ship Staff Insp.","Acetylene pipe line above paint locker found with material wastage and holed at clamping area","Deck Pipe / Fittings","General Appearance","Equipment Related",5.26,"Medium","Not Applicable","Not Applicable","Wasted section renewed. System tested for leakage and found satisfactory.","2019-03-21",null,"Completed","2019-03-26","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-05T23:51:08","2019-02-21","Deficiency","Ship Staff","Ship Staff Insp.","Ullage and IG pressure feed not displayed for 1S COT in SAAB Radar console in CCR","Cargo Mach.","Cargo / Ballast Systems","Equipment Related",8.1199999999999992,"Medium","Not Applicable","Not Applicable","SAAB radar cover opened for 1S COT, found ingress of water. Same cleaned. Wire found core found broken in TGU unit. Same repaired.Working satisfactory now","2019-02-28",null,"Completed","2019-02-23","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-06T19:06:37","2019-02-26","Deficiency","Ship Staff","Ship Staff Insp.","At middle part of the Port gangway (joint) found some wastage (holes) on the gangway frame body due to corrosion.","Deck Mach.","General Appearance","Equipment Related",5.47,"Medium","Not Applicable","Not Applicable","Wastage built up by steel putty and boxed back. Permanent job to be done at DD. Shall include in Refman. Included in DD spec. REFMAN Export ID: SDR 16 DK.18 09-MAR-2019","2019-06-30",null,"Completed","2019-06-14","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-06T00:10:55","2019-03-17","Deficiency","Ship Staff","Ship Staff Insp.","AUS discharge valves of COPT #1, 2 & 3 not responding suitably for AUTO unloading operation.","Cargo Mach.","Cargo / Ballast Systems","Equipment Related",8.11,"Medium","Not Applicable","Not Applicable","Valve positioners of all three COPs calibrated and set for AUTO unloading operation.","2019-03-21",null,"Completed","2019-03-19","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-07T02:57:16","2019-03-22","Deficiency","Ship Staff","Ship Staff Insp.","ECR fwd HVAC unit ineffective cooling. Low sucn press and high dish pressures noticed.","Aux. Mach.","Eng. / Strg. Comp.","Equipment Related",10.32,"Very High","Not Applicable","Not Applicable","Dryer found defective. New dryer fitted and system put to service and found satisfactory.","2019-04-24",null,"Completed","2019-03-24","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-07T03:09:53","2019-03-23","Deficiency","Ship Staff","Ship Staff Insp.","Leakage from FWG seawater piping. A section of pipe found wasted.","Miscellaneous","Eng. / Strg. Comp.","Equipment Related",10.31,"Very High","Not Applicable","Not Applicable","Wasted section of pipe renewed and system put to service and found good.","2019-04-23",null,"Completed","2019-03-31","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-07T02:49:00","2019-01-22","Deficiency","Ship Staff","Ship Staff Insp.","Main engine fuel oil pressure transmitter found malfunctioning ( showing IFL & fluctuating frequently)","Main Engine ","Eng. / Strg. Comp.","Equipment Related",10.32,"Very High","Not Applicable","Not Applicable","Pressure transmitter renewed with new spare ,wiring checked, found working satisfactory.JOB ORDER NO :(V-SCAN017266/19)","2019-02-15",null,"Completed","2019-01-22","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-07T03:03:05","2019-03-31","Deficiency","Ship Staff","Ship Staff Insp.","Emg gen engine RPM indicator needle did not reflect the actual engine rpm.","Critical Equip.,Elect. Mach. & Equip.","Emgcy. Systems","Equipment Related",10.32,"Very High","Not Applicable","Not Applicable","Cables cleaned and retightened and found indicator working normal","2019-04-29",null,"Completed","2019-03-31","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-07T03:12:38","2019-04-03","Deficiency","Ship Staff","Ship Staff Insp.","#1 FWG condenser outlet line holed.","Aux. Mach.","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Pipe line to remove and fabricate new one.","2019-05-04",null,"Completed","2019-04-05","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-06T00:25:14","2019-04-14","Deficiency","Ship Staff","Ship Staff Insp.","Crew laundry drier not working.Bush got damaged","Miscellaneous","MLC Related","Equipment Related",null,null,"Not Applicable","Not Applicable","Bush fabricated and renewed.","2019-04-29",null,"Completed","2019-04-27","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-06T23:24:55","2019-04-14","Deficiency","Owner / Marine / Tech. Suptd.","Ship Staff Insp.","Stbd provision crane luffing cylinder top cover, hyd leak.","Deck Mach.","Mooring","Equipment Related",8.76,"Medium","Not Applicable","Not Applicable","Seal renewed. Tested and found satisfactory.","2019-07-30","SCAN190083","Completed","2019-07-12","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-07T03:20:07","2019-04-16","Deficiency","Ship Staff","Ship Staff Insp.","Sucn Pipe line choked.","Aux. Mach.","Eng. / Strg. Comp.","Equipment Related",10.32,"Very High","Not Applicable","Not Applicable","Removed pipe section. Cleared the obstruction and fitted back.","2019-05-17",null,"Completed","2019-04-24","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-06T19:02:34","2019-04-21","Deficiency","Ship Staff","Ship Staff Insp.","Port windlass, brake cyl hyd leak from bottom & top cover.","Mooring Mach.","Mooring","Equipment Related",9.14,"Medium","Not Applicable","Not Applicable","Seal ring renewed. System tested and found satisfactory.","2019-06-30",null,"Completed","2019-06-04","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-06T00:27:39","2019-04-24","Deficiency","Ship Staff","Ship Staff Insp.","No 3 COP NRV suspected to malfunction.","Cargo Mach.","Cargo / Ballast Systems","Equipment Related",8.11,"Medium","Not Applicable","Not Applicable","NRV inspected and found free. PAL JO: V-SCAN018857/19","2019-05-01",null,"Completed","2019-04-24","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-06T23:50:59","2019-04-24","Deficiency","Ship Staff","Ship Staff Insp.","Stbd hose crane, jerky during luffing operation","Deck Mach.","Mooring","Equipment Related",8.76,"Medium","Not Applicable","Not Applicable","Fulcrum pins to be lubricated. Crane to be operated and checked. Grease applied through lubrication points. Vibration has reduced. In communication with service provider. Crane luff cyl control valve spool inspected and found normal. Greasing routine repeated. Movement observed to be better. Need to operate onload and check. Job included in Refman DD spec.","2019-07-30",null,"Completed","2019-07-31","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-06T19:09:18","2019-04-28","Deficiency","Ship Staff","Ship Staff Insp.","No 1 COP AUS discharge valve positioner defective.","Cargo Mach.","Cargo / Ballast Systems","Equipment Related",8.11,"Medium","Not Applicable","Not Applicable","Feedback linkage to positioner found disconnected. Same fitted and calibrated. Found satisfactory","2019-06-05",null,"Completed","2019-06-03","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-07T00:58:18","2019-05-01","Deficiency","Ship Staff","Ship Staff Insp.","DGPS PRINTER NOT OPREATIONAL ","Nav & comm. equip.","Navigation","Equipment Related",4.7,"High","Not Applicable","Not Applicable","NEED TO REPLACE THE PRINTER . ( PRINTER HEAD WAS CHANGED AFTER RECEIVING THE SPARE BUT ISSUE NOT SOLVED. NEED TO REPLACE PRINTER UNIT )","2019-08-25","SCAN190093","Completed","2019-08-24","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-07T03:23:43","2019-05-03","Deficiency","Ship Staff","Ship Staff Insp.","Main Air Compressor #2, 2nd stage cyl head stud cracked.","Air Comp.","Eng. / Strg. Comp.","Equipment Related",10.32,"Very High","Not Applicable","Not Applicable","Compressor inspected. Cracked stud replaced with spare new stud. Tried out and found satisfactory.","2019-06-04",null,"Completed","2019-05-04","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-06T00:30:17","2019-05-08","Deficiency","Ship Staff","Ship Staff Insp.","Oil leakage from Aft winch hyd control valve block","Mooring Mach.","Mooring","Equipment Related",9.14,"Medium","Not Applicable","Not Applicable","Control valve block removed. Seals renewed. Winch tested and found satisfactory.","2019-05-15",null,"Completed","2019-05-10","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-07T03:30:59","2019-05-13","Deficiency","Ship Staff","Ship Staff Insp.","Main air compressor #2, Performance below normal.","Air Comp.","Eng. / Strg. Comp.","Equipment Related",10.32,"Very High","Not Applicable","Not Applicable","1st and 2nd stage valves inspected. 2nd stage discharge valve plate found broken. Valve overhauled with new spare. Compressor tried out and found satisfactory.","2019-06-14","V-SCAN019477/19","Completed","2019-05-14","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-07T03:34:07","2019-05-17","Deficiency","Ship Staff","Ship Staff Insp.","Pin hole in Seawater piping, soot tank eductor line.","ER Pipes, valves & fittings","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Pipe removed to workshop. Leaky section renewed and fitted back. Tested and found satisfactory.","2019-05-18","V-SCAN019478/19","Completed","2019-05-18","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-07T03:37:29","2019-05-24","Deficiency","Ship Staff","Ship Staff Insp.","AE #1, unit 6 exh temp dropped during operation. ","Aux. Engine","Eng. / Strg. Comp.","Equipment Related",10.32,"Very High","Not Applicable","Not Applicable","Upon trouble shooting found the fuel injector defective. Replaced with spare fuel injector. Tested and found satisfactory.","2019-06-25","V-SCAN019479/19","Completed","2019-05-25","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-07T03:43:18","2019-05-27","Deficiency","Ship Staff","Ship Staff Insp.","FWG Ejector pump shaft seal leaking","Aux. Mach.","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Pump overhauled, seal renewed and tested. Found satisfactory.","2019-05-28","V-SCAN019480/19","Completed","2019-05-27","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-07T03:48:25","2019-05-29","Deficiency","Ship Staff","Ship Staff Insp.","Main & COPT #3 cool SW pump shaft seal leaking.","Aux. Mach.","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Shaft seal renewed with spare.","2019-06-30","V-SCAN019802/19","Completed","2019-06-03","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-06T19:19:07","2019-05-30","Deficiency","Ship Staff","Ship Staff Insp.","Fwd spring winch  hyd return line corroded.","Mooring Mach.","Mooring","Equipment Related",9.14,"Medium","Not Applicable","Not Applicable","Oil drained, Section of pipe removed and Shifted to Engine room workshop. Section of pipe cropped and renewed. System tested and found no leak.","2019-06-30",null,"Completed","2019-06-01","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-06T19:31:32","2019-05-30","Deficiency","Ship Staff","Ship Staff Insp.","Stbd side Gangway securing arrangement found broken","Deck Mach.","General Appearance","Equipment Related",5.47,"Medium","Not Applicable","Not Applicable","permanent repair carried out. ","2019-06-30",null,"Completed","2019-06-27","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-06T19:34:33","2019-05-30","Deficiency","Ship Staff","Ship Staff Insp.","3 COT no.2 Cow machine found not rotating during cow wash at last discharge port","Cargo Mach.","Cargo / Ballast Systems","Equipment Related",8.34,"High","Not Applicable","Not Applicable","Machine need to be taken out and overhaul & box back. Overhauled and found satisfactory.","2019-06-30",null,"Completed","2019-06-24","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-06T19:42:49","2019-05-30","Deficiency","Ship Staff","Ship Staff Insp.","4 Port COT no.1 Cow machine drive unit found during cow wash not rotating as per maker","Cargo Mach.","Cargo / Ballast Systems","Equipment Related",8.34,"High","Not Applicable","Not Applicable","It has been planned to over haul Drive unit & box back on passage. Overhauled and found satisfactory.","2019-06-30",null,"Completed","2019-06-25","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-07T04:41:05","2019-06-02","Deficiency","Ship Staff","Ship Staff Insp.","Galley hot plate low IR","Elect. Mach. & Equip.","General Appearance","Equipment Related",null,null,"Not Applicable","Not Applicable","Galley hot plates dismantled to check the condition of wires and switch , brittle wires changed with spare , Hot plate IR measured found below 3 mega ohms . Due to low IR 440 low insulation alarm is getting activated , need to replace with spare . RO SCAN190102","2019-07-02","V-SCAN020093/19","Completed","2019-07-07","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-06T18:56:59","2019-06-03","Deficiency","Ship Staff","Ship Staff Insp.","VDR error","Nav & comm. equip.","Navigation","Equipment Related",4.7,"High","Not Applicable","Not Applicable","VDR error observed was coming due to alarm in the system same rectified working satisfcactory","2019-06-30",null,"Completed","2019-06-04","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-07T03:45:42","2019-06-03","Deficiency","Ship Staff","Ship Staff Insp.","Hydraphore pipe outlet to engine room found crack","ER Pipes, valves & fittings","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Pipe section renewed","2019-07-04","V-SCAN019801/19","Completed","2019-06-06","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-06T23:27:54","2019-06-03","Deficiency","Ship Staff","Ship Staff Insp.","FIXED GAS Detection system internal leakage ","Miscellaneous","Cargo / Ballast Systems","Equipment Related",5.21,"Medium","Not Applicable","Not Applicable","Pumps overhauled with spare kit. Tested and found satisfactory.","2019-07-30","SCAN190103","Completed","2019-07-15","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-06T19:00:02","2019-06-04","Deficiency","Ship Staff","Ship Staff Insp.","COT NO -5P PRESSURE ERROR ","Cargo Mach.","Cargo / Ballast Systems","Equipment Related",8.1199999999999992,"Medium","Not Applicable","Not Applicable","COT NO -5P PRESSURE ERROR and eratic readings were coming on display same rectified by dismantaling the pressure sensor; cleaned calibrated and fitted back, working satisfactory ","2019-06-30","V-SCAN019822/19","Completed","2019-06-07","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-06T19:22:08","2019-06-13","Deficiency","Ship Staff","Ship Staff Insp.","Forward air whistle not working","Nav & comm. equip.","Navigation","Equipment Related",4.7,"High","Not Applicable","Not Applicable","Whistle inspected and spares kept ready. Working Satisfactory","2019-06-26","V-SCAN019958/19","Completed","2019-06-26","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-07T08:18:49","2019-06-13","Deficiency","Ship Staff","Ship Staff Insp.","Forward Air whistle not working","Nav & comm. equip.","Navigation","Equipment Related",4.7,"High","Not Applicable","Not Applicable","Whistle inspected and spares kept ready.","2019-06-28","V-SCANNO19958/19","Completed","2019-06-26","No",null,null,"Internal"]
[null,null,null,null,null,"2019-07-10T05:20:40","2019-06-13","Deficiency","Owner / Marine / Tech. Suptd.","Suptd. Insp.","60% LT Cooler inlet elbow stub piece corroded","ER Pipes, valves & fittings","Eng. / Strg. Comp.","Equipment Related",10.32,"Very High","Not Applicable","Not Applicable","Stub piece to renew. At present cold repair carried out. Cooler need to be drained for repairs. Job shall be attended in ballast passage.","2019-06-13","V-SCAN020263/19","Completed","2019-07-13","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-07T03:56:52","2019-06-16","Deficiency","Ship Staff","Ship Staff Insp.","#2 Boiler FO pump seal found leaking","Boiler","Eng. / Strg. Comp.","Equipment Related",10.29,"Medium","Not Applicable","Not Applicable","Pump to overhaul.","2019-07-17","V-SCAN001481/18","Completed","2019-06-22","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-07T06:00:53","2019-06-17","Deficiency","Ship Staff","Ship Staff Insp.","Atmospheric condensor sea wateroutlet pipe found pin hole","ER Pipes, valves & fittings","Eng. / Strg. Comp.","External Factors",10.32,"Very High","Not Applicable","Not Applicable","Temporary repair done. Awaiting anchorage to do permant repair. DD spec made.","2019-07-25","DD SPEC","Completed","2019-07-25","Yes",null,null,"Internal"]
[null,null,null,null,null,"2019-10-07T05:29:45","2019-06-19","Deficiency","Ship Staff","Ship Staff Insp.","STBD waste water pipe storm valve defective. Pin hole in attached pipe","ER Pipes, valves & fittings","Eng. / Strg. Comp.","External Factors",10.32,"Very High","Not Applicable","Not Applicable","STORM VALVE RENEWED WITH NEW SPARE. Pinhole welded and repaired","2019-06-21","V-SCAN020265/19","Completed","2019-07-06","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-07T05:27:17","2019-06-20","Deficiency","Ship Staff","Ship Staff Insp.","GALLEY DRAIN OVERBOARD STORM VALVE BODY LEAKING. VALVE TO RENEW.","ER Pipes, valves & fittings","Eng. / Strg. Comp.","External Factors",6.4,"High","Not Applicable","Not Applicable","STORM VALVE RENEWED WITH NEW SPARE","2019-06-21","V-SCAN020264/20","Completed","2019-07-07","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-07T04:00:43","2019-06-22","Deficiency","Ship Staff","Ship Staff Insp.","PORT SIDE BRIDGE WING CAMERA HORIZONENTAL DISTORTION NOTICED ON THE SCREEN AND FLICKERING","Elect. Mach. & Equip.,Miscellaneous","Navigation","Equipment Related",null,null,"Not Applicable","Not Applicable","CAMERA DISMENTALED CHECKED FOR LOOSE CONNECTIONS ALL INTACT, FOUND NO BURNED PARTS ON PCB. SYSTEM RESTARTED AFTER CHECKS BUT SAME CONDITION , NEED OFFICE ADVICE ","2019-07-22",null,"Completed","2019-06-25","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-07T05:43:18","2019-06-26","Deficiency","Ship Staff","Ship Staff Insp.","FWG-2  Distallate pump moror windings found open ckt.","Aux. Mach.","Eng. / Strg. Comp.","External Factors",10.32,"Very High","Not Applicable","Not Applicable","Fabricating a spacer ring to fit the motor to the pump flange. Job in progress. ","2019-07-07",null,"Completed","2019-07-17","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-07T00:59:51","2019-06-29","Deficiency","Ship Staff","Ship Staff Insp.","Telegraph printer not printing properly","Nav & comm. equip.","Navigation","Equipment Related",4.7,"High","Not Applicable","Not Applicable","Movement started logging down in Bridge Bell Book and Req has been raised for defect item.","2019-08-30","SCAN190128","Completed","2019-08-24","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-07T00:12:33","2019-06-30","Deficiency","Owner / Marine / Tech. Suptd.","Suptd. Insp.","5P ballast tank valve indication needle overshoots full open posn and falls to zero position when valve is actually full open.","Cargo Mach.","Cargo / Ballast Systems","Equipment Related",null,null,"Not Applicable","Not Applicable","Local indicator opened up for wrong signal found normal working in range as there is mechanical stopper for the needle. Electronic indicator stop overshooting after adjusting from the PCB and dial adjuster below the indicator. ","2019-08-30",null,"Completed","2019-08-12","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-07T04:53:26","2019-07-06","Deficiency","Ship Staff","Ship Staff Insp.","Aft engine pit dirty and oily","Main Engine ","Eng. / Strg. Comp.","Equipment Related",10.19,"Very High","Not Applicable","Not Applicable","To clean, check source of leakage and maintain clean.Cleaned and made dry.","2019-08-07",null,"Completed","2019-07-07","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-07T08:28:37","2019-07-06","Deficiency","Owner / Marine / Tech. Suptd.","Suptd. Insp.","ER arrival Checklist not updated and signed pages found blank\t\t","Documentation","Cert. & Docu.","Human Error",8.1039999999999992,"Low","Not Applicable","Not Applicable","Checklist are supposed to be diligently followed and updated and its a NC for not following","2019-07-12",null,"Completed","2019-07-06","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-07T05:14:38","2019-07-06","Deficiency","Owner / Marine / Tech. Suptd.","Suptd. Insp."," CFW cooler Inlet elbow leaking from connection pipe weld seam","ER Pipes, valves & fittings","Eng. / Strg. Comp.","Equipment Related,External Factors",10.32,"Very High","Not Applicable","Not Applicable","To plan for welding repairs at suitable opportunity","2019-07-12","V-SCAN020263/19","Completed","2019-07-13","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-06T21:28:41","2019-07-06","Deficiency","Owner / Marine / Tech. Suptd.","Suptd. Insp.","No spare foam nozzle retaining springs","LSA / FFA","LSA / FFA Appliances","Equipment Related",null,null,"Not Applicable","Not Applicable","Vessel have spare  4 sets","2019-07-26",null,"Completed","2019-07-07","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-06T21:34:02","2019-07-06","Deficiency","Owner / Marine / Tech. Suptd.","Suptd. Insp.","IG drain line has soft patch","Deck Pipe / Fittings","Cargo / Ballast Systems","Equipment Related",11.4,"Very High","Not Applicable","Not Applicable","If opening flange to flange section is not possible, then to include in REFFMAN - Shifted to REFMAN","2019-07-26",null,"Completed","2019-07-11","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-07T05:33:08","2019-07-06","Deficiency","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Control air line to LT cooler 3 way valve actuator cylinder leaking","Aux. Engine","Eng. / Strg. Comp.","External Factors",10.32,"Very High","Not Applicable","Not Applicable","To check and rectify. //Gasket renewed.","2019-07-07",null,"Completed","2019-07-14","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-07T05:35:05","2019-07-06","Deficiency","Owner / Marine / Tech. Suptd.","Suptd. Insp.","FO heater #1, steam line outlet steam trap leaking from gasket","Main Engine ","Eng. / Strg. Comp.","External Factors",10.32,"Very High","Not Applicable","Not Applicable","To rectify the leakage. Replaced gasket and rectified","2019-07-07",null,"Completed","2019-07-15","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-07T05:37:31","2019-07-06","Deficiency","Owner / Marine / Tech. Suptd.","Suptd. Insp.","1 Frdge compressor running with sump oil level low","Aux. Mach.","Eng. / Strg. Comp.","External Factors",10.32,"Very High","Not Applicable","Not Applicable","To top up oil to correct level. // Topped up.","2019-07-07",null,"Completed","2019-07-08","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-07T05:40:04","2019-07-06","Deficiency","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Incinerator Noticed wrapped with cloth on sludge burner pump","Aux. Mach.","Eng. / Strg. Comp.","External Factors",10.32,"Very High","Not Applicable","Not Applicable","Gaskets renewed. No leak observed.","2019-07-30",null,"Completed","2019-07-15","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-06T23:32:14","2019-07-06","Deficiency","Owner / Marine / Tech. Suptd.","Suptd. Insp.","WBT valves opening hyd line on deck – cross deck line support back plates are wasted at few locations","Deck Pipe / Fittings","General Appearance","Equipment Related",11.5,"Medium","Not Applicable","Not Applicable","To include in REFFMAN, to carry out at DD -Shifted to REFMAN","2019-08-30",null,"Completed","2019-07-15","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-06T23:41:08","2019-07-06","Deficiency","Owner / Marine / Tech. Suptd.","Suptd. Insp.","2 foam monitor, gun/nozzle retaining spring, hanging looses, broken form support base","LSA / FFA","LSA / FFA Appliances","Equipment Related",5.35,"Medium","Not Applicable","Not Applicable","Retaining spring has been replace","2019-07-26",null,"Completed","2019-07-24","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-06T23:44:09","2019-07-06","Deficiency","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Few Hyd return lines were reported renewed recently, as same was wasted","Deck Pipe / Fittings","General Appearance","Equipment Related",11.5,"Medium","Not Applicable","Not Applicable","Wasted section Welded with doubler and fitted back, same has been enter in Refman for Permanent renewal","2019-08-12",null,"Completed","2019-07-26","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-06T23:46:11","2019-07-06","Deficiency","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Gangway Lubricator and moisture drain filters seems not carried out – covers were seized","Deck Mach.","General Appearance","Equipment Related",5.47,"Medium","Not Applicable","Not Applicable","Gangway Lubricator and moisture drain filters cleaned/overhaul and box back","2019-07-30",null,"Completed","2019-07-26","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-07T05:56:26","2019-07-06","Deficiency","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Noticed, Deep Freezer for wet garbage kept in dry provision room","Miscellaneous","Eng. / Strg. Comp.","External Factors",10.32,"Very High","Not Applicable","Not Applicable","Discussed with Supt as there is no issue for Deep Freezer in present location.","2019-07-25",null,"Completed","2019-07-19","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-07T05:59:03","2019-07-06","Deficiency","Owner / Marine / Tech. Suptd.","Suptd. Insp.","WO Sludge tk, Bilge tank – save all edges corroded/wasted","Deck Mach.","Eng. / Strg. Comp.","External Factors",10.32,"Very High","Not Applicable","Not Applicable","Included in REFFMA to carry out at DD","2019-07-25",null,"Completed","2019-07-19","Yes",null,null,"Internal"]
[null,null,null,null,null,"2019-10-06T23:52:57","2019-07-06","Deficiency","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Steering flat/storage COT, various valve seat rings lying open in cardboard box – prone to heat and damage","Miscellaneous","Cargo / Ballast Systems","Human Error",null,null,"Not Applicable","Not Applicable","To shift to any stores inside accommodation to avoid damage to seat rings, to take inventory of seat rings and maintain list/update PAL. Shifted.","2019-07-26",null,"Completed","2019-07-18","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-07T08:38:28","2019-07-06","Deficiency","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Steering flat/Stowage COT , various valve seat rings lying open in cardboard box\t","Miscellaneous","Eng. / Strg. Comp.","Human Error",null,null,"Not Applicable","Not Applicable","to shift to any store inside accomodation to avoid damage to seat rings, to take inventory","2019-07-26",null,"Completed","2019-07-18","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-06T23:56:19","2019-07-06","Deficiency","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Pumproom Blower damper remote operation cabinet corroded/wasted","Deck Mach.","General Appearance","External Factors",5.19,"Medium","Not Applicable","Not Applicable","Shifted to REFFMAN","2019-07-31",null,"Completed","2019-07-31","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-07T06:02:27","2019-07-06","Deficiency","Owner / Marine / Tech. Suptd.","Suptd. Insp.","2 FW cooler SW outletconnection flange piece considerable sea water leakage observed","Aux. Engine","Eng. / Strg. Comp.","External Factors",10.32,"Very High","Not Applicable","Not Applicable","To check/remove intermediate section, renew gasket as necessary. Planned for next ballast passage.","2019-07-25","V-SCAN020696/19","Completed","2019-08-07","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-07T06:06:33","2019-07-06","Deficiency","Owner / Marine / Tech. Suptd.","Suptd. Insp.","IGG sea water line filter casing holed and leaking","Inert Gas","Eng. / Strg. Comp.","External Factors",8.3000000000000007,"Very High","Not Applicable","Not Applicable","To remove the casing weld/repair and fit back","2019-07-25","V-SCAN020696/19","Completed","2019-08-08","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-07T00:55:15","2019-07-06","Deficiency","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Near Helicopter area, on deck, observed coating damage and paint peel off around/abt 30 sq mtrs area","Miscellaneous","General Appearance","External Factors",11.3,"Medium","Not Applicable","Not Applicable","Improper surface preparation, waste of paints – to ensure proper procedure is followed while paint application","2019-08-30",null,"Completed","2019-08-15","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-07T01:01:46","2019-07-06","Deficiency","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Stores/Space spaces Lying haphazard and doesn’t look organized","Miscellaneous","General Appearance","Human Error",5.1100000000000003,"Low","Not Applicable","Not Applicable","To utlize the next long Voyage, to take inventory, update and arrange/organize orderly. Stores and spares neatly arranged.","2019-08-30",null,"Completed","2019-08-28","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-07T06:08:39","2019-07-06","Deficiency","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Control air dryer Defective/In-operational","Air Comp.","Eng. / Strg. Comp.","External Factors",10.32,"Very High","Not Applicable","Not Applicable","New unit INSTALLED AND COMMISSSIONED","2019-09-05",null,"Completed","2019-09-03","No",null,null,"Internal"]
[null,null,null,null,null,"2019-07-10T06:12:18","2019-07-06","Deficiency","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Aux Engines Not fitted with Oil max filters yet","Aux. Engine","Eng. / Strg. Comp.","External Factors",10.32,"Very High","Not Applicable","Not Applicable","Fitted for all three DG's  and working satisfactory","2019-10-15",null,"Completed","2019-09-07","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-06T19:48:03","2019-07-10","Deficiency","Owner / Marine / Tech. Suptd.","Suptd. Insp.","All winch brake band adjusting bolt clearances were not as per maker’s reccommendation","Mooring Mach.","Mooring","Equipment Related",9.14,"Medium","Not Applicable","Not Applicable","Adjusted as per recommended clearance requiered.","2019-07-30",null,"Completed","2019-07-12","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-07T05:45:27","2019-07-17","Deficiency","Ship Staff","Ship Staff Insp.","E/R QMI oil mist detector for Aux. Boiler in fault","Elect. Mach. & Equip.","Eng. / Strg. Comp.","External Factors",10.32,"Very High","Not Applicable","Not Applicable","Detector dismentaled for repair cleaned and fitted back but no posstive result need to replace the detector RO SCAN190137","2019-08-15","SCAN190137","Completed","2019-07-18","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-07T05:48:58","2019-07-22","Deficiency","Ship Staff","Ship Staff Insp.","MGPS LOW SEA CHEST CURRENT GETTING ZERO AFTER SETTING ANY VALUE ","Elect. Mach. & Equip.","Eng. / Strg. Comp.","External Factors",10.32,"Very High","Not Applicable","Not Applicable","SYSTEM CHECKED FOR LOOSE CONNECTION FOUND ALL INTACT , SYSTEM RESTARTED BUT NO POSSITIVE RESULT , SUSPECTED POWER  AND CONTROL UNIT SAME OPENED AND REAPIRED SYSTEM WORKING SATISFACTORY  RO SCAN190139 MADE FOR FUTURE USE","2019-07-25","SCAN190139","Completed","2019-07-25","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-07T00:01:24","2019-08-03","Deficiency","Ship Staff","Ship Staff Insp.","Seawater flusing valve found leaking","LSA / FFA","LSA / FFA Appliances","Equipment Related",5.35,"Medium","Not Applicable","Not Applicable","Replace valve with spare","2019-08-30","V-SCAN020688","Completed","2019-08-05","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-07T00:53:01","2019-08-07","Deficiency","Ship Staff","Ship Staff Insp.","Stbd side Gangway securing one arrangement found sheared","Deck Mach.","General Appearance","Equipment Related",5.47,"Medium","Not Applicable","Not Applicable","Sheared part permanently repaired and fix back","2019-08-30",null,"Completed","2019-08-13","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-07T06:10:28","2019-08-17","Deficiency","Ship Staff","Ship Staff Insp.","SW leakage from #1 FWG eductor","Aux. Engine","Eng. / Strg. Comp.","External Factors",10.32,"Very High","Not Applicable","Not Applicable","Eductor body found erroded. Need to replace. RO raised for spare SCAN190158. Repaired by brazing. ","2019-10-15","SCAN190158","Completed","2019-09-04","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-07T01:08:05","2019-09-17","Deficiency","PSC Insp.","PSC Inspection","The Last 1 meter of the Vapor piping upstream of the vapor connection must be painted Red/Yellow/Red. The Vapor control piping on board did not meet the required Color Scheme ","Deck Pipe / Fittings","Cargo / Ballast Systems","Human Error",8.42,"Medium","Cargo operations including equipment","USCG","Red colour marking band of 100 mm as required were painted on the Vapour return line manifold same day of the observation.","2019-09-18",null,"Completed","2019-09-18","No",null,null,"External"]
[null,null,null,null,null,"2019-10-07T06:17:07","2019-09-18","Deficiency","PSC Insp.","PSC Inspection","The condition of the ship’s equipment shall not present dangers to the ship or it’s crew. The gasket material around the incinerator door was deteriorated","Miscellaneous","Eng. / Strg. Comp.","External Factors",null,null,"Other","USCG","Replaced Gasket.","2019-09-19",null,"Completed","2019-09-19","No",null,null,"External"]
[null,null,null,null,null,"2019-10-07T06:15:33","2019-09-18","Deficiency","PSC Insp.","PSC Inspection","The condition of the ship and its equipment shall be maintained to conform to the provisions of the current regulations & ensure the ship remains fit to proceed to sea w/o presenting dangers to the ship or persons. The refractory of the incinerator was degraded.","Miscellaneous","Eng. / Strg. Comp.","External Factors",null,null,"Other","USCG","Degraded refractory material restored with suitable refractory material","2019-09-19",null,"Completed","2019-09-19","No",null,null,"External"]
[null,null,null,null,null,"2019-10-07T01:10:29","2019-09-18","Deficiency","PSC Insp.","PSC Inspection","The Tank Overfill alarm requires an audible & visible alarm. The Warning light was not visible during tests.","Elect. Mach. & Equip.","Cargo / Ballast Systems","Equipment Related",8.24,"Medium","Alarms","USCG","Replaced Bulb.","2019-09-18",null,"Completed","2019-09-18","No",null,null,"External"]
[null,null,null,null,null,"2019-10-06T23:49:00","2019-07-06","Deficiency","Owner / Marine / Tech. Suptd.","Suptd. Insp.","WO Sludge tk, Bilge tank – save all edges corroded/wasted","Deck Pipe / Fittings","Structural Condn. / WT integrity ","External Factors",6.9,"Low","Not Applicable","Not Applicable","Included in REFFMA to carry out at DD","2019-07-30",null,"Completed","2019-07-19","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-07T02:00:46","2019-09-19","Deficiency","SIRE / CDI Insp.","OM Insp. (Eg. SIRE, CDI etc.)","The details relating to type and number of navigation equipment had not been completed within the OCIMF VPQ.","Documentation","Cert. & Docu.","Human Error",1.1399999999999999,"Low","Not Applicable","Not Applicable","The details updated in OCIMF VPQ.","2019-09-19",null,"Completed","2019-09-19","No",null,null,"External"]
[null,null,null,null,null,"2019-10-07T06:19:05","2019-09-20","Deficiency","Owner / Marine / Tech. Suptd.","Suptd. Insp.","DECK SEAL PUMP #2 MECHANICAL SEAL LEAK","Aux. Mach.","Eng. / Strg. Comp.","Equipment Related",10.32,"Very High","Not Applicable","Not Applicable","PUMP OVERHAULED, MECHANICAL SEAL RENEWED","2019-09-27",null,"Completed","2019-09-27","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-07T06:20:42","2019-09-20","Deficiency","Owner / Marine / Tech. Suptd.","Suptd. Insp.","AE FO SUPPLY PUMP MECHANICAL SEAL LEAK","Aux. Engine","Eng. / Strg. Comp.","Equipment Related",10.32,"Very High","Not Applicable","Not Applicable","PUMP OVERHAULED AND MECHANICAL SEAL RENWED. PUMP PUT IN USE NO LEAKS FOUND","2019-09-27",null,"Completed","2019-09-24","No",null,null,"Internal"]

{"sheet":"Calc","index":2,"n_rows":28,"n_cols":12,"rows_kept":28,"cut":false,"hidden":true,"merged":[]}
["Def_type","Def_cause","Equipments","VIQrefno","Observer_code"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Dim itemSele As Long"]
[null,null,null,null,null,null,null,null,null,null,null,"   dim startRow as integer"]
[null,null,null,null,null,null,null,null,null,null,null,"   startRow=1"]
[null,null,null,null,null,null,null,null,null,null,null,"        For itemSele = 0 To ListBox1.ListCount - 1"]
[null,null,null,null,null,null,null,null,null,null,null,"        If ListBox1.Selected(itemSele) = True Then"]
[null,null,null,null,null,null,null,null,null,null,null,"        Worksheets(\"WorksheetName\").Range(\"A\" & startRow).Value = ListBox1.List(itemSele)"]
[null,null,null,null,null,null,null,null,null,null,null,"        startRow = startRow + 1"]
[null,null,null,null,null,null,null,null,null,null,null,"        End If"]
[null,null,null,null,null,null,null,null,null,null,null,"        Next"]
[null,null,null,null,null,null,null,null,null,null,null,"Dim LastRowA As String"]
[null,null,null,null,null,null,null,null,null,null,null,"        Dim itemSele As Long"]
[null,null,null,null,null,null,null,null,null,null,null,"       Dim startRow as integer"]
[null,null,null,null,null,null,null,null,null,null,null,"        LastRowA = ActiveSheet.Cells(Rows.count, \"A\").End(xlUp).row"]
[null,null,null,null,null,null,null,null,null,null,null,"        startQue = 0"]
[null,null,null,null,null,null,null,null,null,null,null,"        For itemSele = 0 To ListBox1.ListCount - 1"]
[null,null,null,null,null,null,null,null,null,null,null,"        For startRow = 1 To LastRowA"]
[null,null,null,null,null,null,null,null,null,null,null,"        If Worksheets(\"WorksheetName\").Range(\"A\" & startRow).Value = ListBox1.List(itemSele) Then"]
[null,null,null,null,null,null,null,null,null,null,null,"        ListBox1.Selected(itemSele) = True"]
[null,null,null,null,null,null,null,null,null,null,null,"        Exit For"]
[null,null,null,null,null,null,null,null,null,null,null,"        End If"]
[null,null,null,null,null,null,null,null,null,null,null,"        Next j"]
[null,null,null,null,null,null,null,null,null,null,null,"        Next"]
[null,null,null,null,null,null,null,null,null,null,null,"        End If"]

{"sheet":"Areaofobs","index":3,"n_rows":17,"n_cols":2,"rows_kept":17,"cut":false,"hidden":true,"merged":[]}
["TITLE","ID"]
["Cargo / Ballast Systems",11]
["Cert. & Docu.",2]
["Communication",6]
["Crew Management",3]
["Emgcy. Systems",13]
["Eng. / Strg. Comp.",14]
["General Appearance",15]
["Ice Opns.",17]
["LSA / FFA Appliances",8]
["MLC Related",4]
["Mooring",12]
["Navigation",5]
["MARPOL Related",9]
["ISM Related",7]
["ISPS Related",10]
["Structural Condn. / WT integrity ",16]

{"sheet":"Vessel_type","index":4,"n_rows":1,"n_cols":2,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["Vessel_type","ID"]

{"sheet":"Deficiency_type","index":5,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":true,"merged":[]}
["TITLE","Type of deficiency_description","ID"]
["Breakdown",null,6]
["Condn of Class / Memo",null,5]
["Critical Equipment",null,4]
["Deficiency",null,1]
["Guarantee Claim",null,8]
["Non Conformity",null,2]
["Observation",null,3]
["Other",null,7]

{"sheet":"VIQrefno","index":6,"n_rows":427,"n_cols":3,"rows_kept":427,"cut":false,"hidden":true,"merged":[]}
["VIQ_ref_no","Risk Value of observation","ID"]
["1.1","Low",8243]
["1.10","Low",8252]
["1.11","Low",8253]
["1.12","Low",8254]
["1.13","Low",8255]
["1.14","Low",8256]
["1.15","Low",8257]
["1.16","Low",8259]
["1.17","Low",8260]
["1.18","Low",8261]
["1.19","Low",8262]
["1.2","Low",8244]
["1.20","Low",8263]
["1.21","Low",8265]
["1.22","Low",8266]
["1.23","Low",8267]
["1.24","Low",8268]
["1.25","Low",8269]
["1.26","Low",8270]
["1.3","Low",8245]
["1.4","Low",8246]
["1.5","Low",8247]
["1.6","Low",8248]
["1.7","Low",8249]
["1.8","Low",8250]
["1.9","Low",8251]
["1.99","High",11258]
["10.1","Medium",8461]
["10.10","High",8470]
["10.11","Medium",8471]
["10.12","Very High",8472]
["10.13","Very High",8473]
["10.14","Medium",8474]
["10.15","Low",8475]
["10.16","Very High",8476]
["10.17","Very High",8477]
["10.18","High",8478]
["10.19","Very High",8479]
["10.2","Low",8462]
["10.20","High",8480]
["10.21","Medium",8481]
["10.22","Low",8482]
["10.23","Medium",8483]
["10.24","Low",8484]
["10.25","Very High",8485]
["10.26","High",8486]
["10.27","Medium",8487]
["10.28","Low",8488]
["10.29","Medium",8489]
["10.3","Medium",8463]
["10.30","High",8490]
["10.31","Very High",8491]
["10.32","Very High",8492]
["10.33","High",8493]
["10.34","High",8494]
["10.35","Very High",8495]
["10.36","Very High",8496]
["10.37","Medium",8497]
["10.38","Medium",8498]
["10.39","High",8499]
["10.4","High",8464]
["10.40","Medium",8500]
["10.41","Medium",8501]
["10.42","Medium",8502]
["10.43","Medium",8503]
["10.44","Medium",8504]
["10.45","Very High",8505]
["10.46","High",8506]
["10.47","Medium",8507]
["10.48","High",8508]
["10.49","Medium",8509]
["10.5","Low",8465]
["10.50","High",8510]
["10.51","Low",8511]
["10.52","Medium",8512]
["10.53","Medium",8513]
["10.54","High",8514]
["10.55","Low",8515]
["10.6","Very High",8466]
["10.7","Medium",8467]
["10.8","Medium",8468]
["10.9","Medium",8469]
["10.99","High",8516]
["11.1","High",8420]
["11.10","Medium",8429]
["11.11","Very High",8430]
["11.12","Low",8431]
["11.13","Low",8432]
["11.14","Medium",8433]
["11.15","Low",8434]
["11.16","Low",8435]
["11.17","Low",8436]
["11.2","Medium",8421]
["11.3","Medium",8422]
["11.4","Very High",8423]
["11.5","Medium",8424]
["11.6","Medium",8425]
["11.7","High",8426]
["11.8","Low",8427]
["11.9","Low",8428]
["11.99","High",8437]
["12.1","High",8438]
["12.10","High",8448]
["12.11","High",8449]
["12.12","High",8450]
["12.13","High",8451]
["12.14","High",8452]
["12.15","High",8453]
["12.16","High",8454]
["12.17","High",8455]
["12.18","High",8456]
["12.19","High",8457]
["12.2","High",8439]
["12.20","High",8458]
["12.21","High",8459]
["12.3","High",8441]
["12.4","High",8442]
["12.5","High",8443]
["12.6","High",8444]
["12.7","High",8445]
["12.8","High",8446]
["12.9","High",8447]
["12.99","High",8460]
["2.1","Very High",8296]
["2.1.9","Very High",11259]
["2.10","Medium",8304]
["2.11","Medium",8305]
["2.12","Low",8306]
["2.13","Low",8307]
["2.14","Low",8308]
["2.15","Low",8309]
["2.16","Medium",8310]
["2.2","Medium",8297]
["2.3","High",8295]
["2.4","Medium",8298]
["2.5","Medium",8299]
["2.6","Low",8300]
["2.7","High",8301]
["2.8","High",8302]
["2.9","Medium",8303]
["2.99","High",8311]
["3.1","High",8312]
["3.2","Very High",8313]
["3.3","High",8314]
["3.4","Low",8294]
["3.5","Medium",8315]
["3.6","High",8316]
["3.7","Very High",8317]
["3.8","Very High",8318]
["3.99","High",8319]
["4.1","High",8320]
["4.10","High",8329]
["4.11","Medium",8330]
["4.12","Very High",8331]
["4.13","Very High",8332]
["4.14","Very High",8333]
["4.15","Very High",8334]
["4.16","Very High",8335]
["4.17","Very High",8336]
["4.18","Very High",8337]
["4.19","Low",8338]
["4.2","Medium",8321]
["4.20","Very High",8339]
["4.21","High",8340]
["4.22","Low",8341]
["4.23","High",8342]
["4.24","High",8343]
["4.25","Low",8344]
["4.26","Low",8345]
["4.27","High",8346]
["4.3","Medium",8322]
["4.4","High",8323]
["4.5","Very High",8324]
["4.6","Medium",8325]
["4.7","High",8326]
["4.8","Medium",8327]
["4.9","Medium",8328]
["4.99","High",8347]
["5.1","Very High",8517]
["5.10","High",8526]
["5.11","Low",8527]
["5.12","Medium",8528]
["5.13","High",8529]
["5.14","Very High",8530]
["5.15","Medium",8531]
["5.16","Very High",8532]
["5.17","Very High",8533]
["5.18","High",8534]
["5.19","Medium",8535]
["5.2","Very High",8518]
["5.20","Medium",8536]
["5.21","Medium",8537]
["5.22","High",8539]
["5.23","Very High",8540]
["5.24","Very High",8541]
["5.25","Medium",8542]
["5.26","Medium",8543]
["5.27","Medium",8544]
["5.28","Very High",8545]
["5.29","High",8546]
["5.3","Low",8519]
["5.30","High",8547]
["5.31","High",8548]
["5.32","High",8549]
["5.33","High",8550]
["5.34","Low",8551]
["5.35","Medium",8552]
["5.36","Low",8553]
["5.37","Low",8554]
["5.38","High",8555]
["5.39","Very High",8556]
["5.4","High",8520]
["5.40","Very High",8557]
["5.41","Very High",8558]
["5.42","Medium",8559]
["5.43","High",8560]
["5.44","High",8561]
["5.45","Medium",8564]
["5.46","Medium",8565]
["5.47","Medium",8566]
["5.48","Medium",8567]
["5.5","Low",8521]
["5.6","Low",8522]
["5.7","Medium",8523]
["5.8","Medium",8524]
["5.9","Very High",8525]
["5.99","High",8568]
["6.1","Medium",8348]
["6.10","Low",8357]
["6.11","High",8358]
["6.12","Medium",8359]
["6.13","Low",8360]
["6.14","High",8361]
["6.15","High",8362]
["6.16","Very High",8363]
["6.17","Very High",8364]
["6.18","Medium",8365]
["6.19","Low",8366]
["6.2","High",8349]
["6.20","Medium",8367]
["6.21","High",8368]
["6.22","Medium",8369]
["6.3","Low",8350]
["6.4","High",8351]
["6.5","Medium",8352]
["6.6","Medium",8353]
["6.7","High",8354]
["6.8","High",8355]
["6.9","Low",8356]
["6.99","High",8370]
["7.1","High",8371]
["7.10","High",8380]
["7.11","High",8381]
["7.12","High",8382]
["7.13","Medium",8383]
["7.14","Medium",8384]
["7.15","High",8385]
["7.16","High",8386]
["7.17","High",8387]
["7.2","High",8372]
["7.3","Low",8373]
["7.4","Low",8374]
["7.5","Low",8375]
["7.6","Medium",8376]
["7.7","Low",8377]
["7.8","High",8378]
["7.9","High",8379]
["7.99","High",8388]
["8.1","Very High",8569]
["8.10","Very High",8578]
["8.100","Low",11227]
["8.101","Medium",11228]
["8.102","Low",11229]
["8.103","Low",11230]
["8.104","Low",11231]
["8.105","Medium",11232]
["8.106","Medium",11233]
["8.107","Low",11234]
["8.108","High",11235]
["8.109","Very High",11236]
["8.11","Medium",8579]
["8.110","High",11237]
["8.111","Medium",11238]
["8.112","High",11239]
["8.113","Medium",11240]
["8.114","Low",11241]
["8.115","High",11242]
["8.116","Medium",11243]
["8.117","Medium",11244]
["8.118","Medium",11245]
["8.119","High",11246]
["8.12","Medium",8580]
["8.120","High",11247]
["8.121","Medium",11248]
["8.122","High",11249]
["8.123","High",11250]
["8.124","Low",11251]
["8.125","High",11252]
["8.126","Medium",11253]
["8.127","Medium",11254]
["8.13","Medium",8581]
["8.14","Very High",8582]
["8.15","High",8583]
["8.16","Very High",8584]
["8.17","Low",8585]
["8.18","High",8586]
["8.19","High",8587]
["8.199","High",11255]
["8.2","Medium",8570]
["8.20","Medium",8588]
["8.21","High",8589]
["8.22","Very High",8590]
["8.23","Medium",8591]
["8.24","Medium",8592]
["8.25","Very High",8593]
["8.26","High",8594]
["8.27","Medium",8595]
["8.28","Medium",8596]
["8.29","High",8598]
["8.3","Very High",8571]
["8.30","High",8599]
["8.31","High",8600]
["8.32","Low",8601]
["8.33","Medium",8602]
["8.34","High",8603]
["8.35","Medium",8604]
["8.36","Medium",8605]
["8.37","High",8607]
["8.38","Medium",8608]
["8.39","Medium",8609]
["8.4","Medium",8572]
["8.40","High",8610]
["8.41","Medium",8611]
["8.42","Medium",8612]
["8.43","Very High",8613]
["8.44","High",8615]
["8.45","High",8616]
["8.46","Very High",8617]
["8.47","Very High",8618]
["8.48","Medium",8619]
["8.49","High",8620]
["8.5","Very High",8573]
["8.50","Medium",8621]
["8.51","Low",8622]
["8.52","Low",8623]
["8.53","Low",8624]
["8.54","High",8625]
["8.55","Low",11182]
["8.56","Medium",11183]
["8.57","Medium",11184]
["8.58","High",11185]
["8.59","High",11186]
["8.6","Medium",8574]
["8.60","High",11187]
["8.61","Medium",11188]
["8.62","Very High",11189]
["8.63","High",11190]
["8.64","Medium",11191]
["8.65","Low",11192]
["8.66","High",11193]
["8.67","High",11194]
["8.68","High",11195]
["8.69","Medium",11196]
["8.7","High",8575]
["8.70","Medium",11197]
["8.71","Very High",11198]
["8.72","Medium",11199]
["8.73","Medium",11200]
["8.74","High",11201]
["8.75","Medium",11202]
["8.76","Medium",11203]
["8.77","Medium",11204]
["8.78","Medium",11205]
["8.79","Medium",11206]
["8.8","Medium",8576]
["8.80","Medium",11207]
["8.81","Low",11208]
["8.82","Medium",11209]
["8.83","Low",11210]
["8.84","Low",11211]
["8.85","Medium",11212]
["8.86","Medium",11213]
["8.87","Medium",11214]
["8.88","Low",11215]
["8.89","High",11216]
["8.9","High",8577]
["8.90","High",11217]
["8.91","High",11218]
["8.92","Medium",11219]
["8.93","Low",11220]
["8.94","Low",11221]
["8.95","Medium",11222]
["8.96","Medium",11223]
["8.97","Low",11224]
["8.98","High",11225]
["8.99","Medium",11226]
["9.1","Low",8390]
["9.10","Medium",8399]
["9.11","Medium",8400]
["9.12","Medium",8401]
["9.13","Low",8402]
["9.14","Medium",8403]
["9.15","Medium",8404]
["9.16","High",8405]
["9.17","High",8406]
["9.18","Low",8407]
["9.19","Low",8408]
["9.2","Very High",8391]
["9.20","Medium",8409]
["9.21","Medium",8410]
["9.22","Low",8411]
["9.23","Low",8412]
["9.24","Medium",8413]
["9.25","Low",8414]
["9.26","Low",8415]
["9.27","Low",8416]
["9.28","Medium",8417]
["9.29","Low",8418]
["9.3","Very High",8392]
["9.4","High",8393]
["9.5","High",8394]
["9.6","Low",8395]
["9.7","Medium",8396]
["9.8","Medium",8397]
["9.9","Medium",8398]
["9.99","High",8419]

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

{"sheet":"PSC_MOU","index":8,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
["TITLE","PSC_MOU_description","ID"]
["Asia and the Pacific",null,2]
["Caribbean",null,4]
["Europe and the North Atlantic",null,1]
["Latin America",null,3]
["The Black Sea region",null,6]
["The Indian Ocean",null,8]
["The Mediterranean",null,7]
["The Riyadh MoU",null,9]
["USCG",null,10]
["West and Central Africa",null,5]

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

{"sheet":"Deficiency_Cause","index":10,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
["TITLE","Deficiency_Cause_description","ID"]
["Behaviour Based",null,1]
["Equipment Related",null,4]
["External Factors",null,5]
["Human Error",null,7]
["Inappropriate Procedure",null,8]
["Industry Issue",null,6]
["Knowledge Based",null,3]

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

{"sheet":"Status_code","index":12,"n_rows":6,"n_cols":3,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
["TITLE","Status_code_description","ID"]
["Completed",null,6]
["Deferred to D D",null,5]
["In progress",null,3]
["Not Started",null,2]
["Waiting spare",null,4]

{"sheet":"PSC_ref_no","index":13,"n_rows":19,"n_cols":2,"rows_kept":19,"cut":false,"hidden":true,"merged":[]}
["TITLE","ID"]
["Alarms",9]
["Cargo operations including equipment",7]
["Certificates & Documentation",2]
["Dangerous Goods",13]
["Emergency Systems",5]
["Fire safety",8]
["ISM",16]
["ISPS",17]
["Life saving appliances",12]
["MLC, 2006",18]
["Other",19]
["Pollution Prevention",15]
["Propulsion and auxiliary machinery",14]
["Radio communication",6]
["Safety of Navigation",11]
["Structural condition",3]
["Water/Weathertight condition",4]
["Working and Living Conditions",10]

{"sheet":"Risk_value_of_obs","index":14,"n_rows":1,"n_cols":2,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["Risk Value of observation","ID"]

{"sheet":"Year","index":15,"n_rows":18,"n_cols":1,"rows_kept":18,"cut":false,"hidden":true,"merged":[]}
["Year"]
[2014]
[2015]
[2016]
[2017]
[2018]
[2019]
[2020]
[2021]
[2022]
[2023]
[2024]
[2025]
[2026]
[2027]
[2028]
[2029]
[2030]

{"sheet":"Month","index":16,"n_rows":13,"n_cols":1,"rows_kept":13,"cut":false,"hidden":true,"merged":[]}
["Month"]
["Jan"]
["Feb"]
["Mar"]
["Apr"]
["May"]
["Jun"]
["Jul"]
["Aug"]
["Sep"]
["Oct"]
["Nov"]
["Dec"]

{"sheet":"Date_","index":17,"n_rows":32,"n_cols":1,"rows_kept":32,"cut":false,"hidden":true,"merged":[]}
["Date"]
["01"]
["02"]
["03"]
["04"]
["05"]
["06"]
["07"]
["08"]
["09"]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]

{"sheet":"Sheet1","index":18,"n_rows":24,"n_cols":6,"rows_kept":24,"cut":false,"hidden":true,"merged":[]}
[]
[null,"ID","E",null,"Date Recorded",1]
[null,"UNIQUE ID","F",null,"Type of Deficiency",2]
[1,"Date Recorded","G",null,"Observer code",3]
["ignore","Vessel Type","H",null,"Type of Inspection",4]
[null,"Internal / External","I",null,"Description of Deficiency",5]
[null,"Drydock","J",null,"Equipment Categories",6]
[null,"Information Sharing","K",null,"Area of Observation",7]
[null,"Critical_item","L",null,"Deficiency Cause",8]
[null,"Deficiency Type","M",null,"VIQ Ref Number",9]
[null,"Deficiency Cause","N",null,"Risk Value of Obs",10]
[null,"Inspection Type","O",null,"PSC Ref Number",11]
[null,"Equipments","P",null,"PSC MOU ID",12]
[null,"VIQ Reference Number","Q",null,"Action Taken or Required",13]
[null,"Risk Value of the observation","R",null,"Target Date",14]
[null,"PSC Reference Number","S",null,"PO Ref No.",15]
[null,"PSC MOU","T",null,"Status Code",16]
[null,"Observer Code","U",null,"Date Completed",17]
[null,"Target Date","V",null,"Drydock",18]
[null,"Status Code","W",null,"Info Sharing",19]
[null,"Description of Deficiency","X",null,"Critical Item Flag",20]
[null,"Action taken / required","Y",null,"Audit Type",21]
[null,"PO ref no","Z"]
[null,"Date completed","AA"]

{"sheet":"Ship_information","index":19,"n_rows":2,"n_cols":3,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["Ship_ID","Ship_Name","FILE_NAME"]
["45","DHT SCANDINAVIA","45_1570025667073.xlsm"]