{"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":20,"n_cols":28,"rows_kept":20,"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","10-Dec-2019",null,null,"Ship Name","DHT BRONCO (03-12-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,540,"Sat Aug 10 2019 15:26:11 GMT+0000","2019-09-15","Breakdown","Ship Staff","Ship Staff Insp.","MGO TRANSFER PUMP DAMAGED","Aux. Mach.,ER Pipes, valves & fittings","Eng. / Strg. Comp.","Equipment Related","","","","","New pump ordered, to be installed when arrived onboard","2020-01-15","DBRO190202","Waiting spare",null,"No","No","No","Internal","Spare pump has 60 days lead time. Expect readiness by end of January."]
[null,null,null,null,541,"Sat Aug 10 2019 15:28:34 GMT+0000","2019-09-28","Observation","Ship Staff","Ship Staff Insp.","AE #3 JCW HEATER COIL SHORT","Aux. Engine","Eng. / Strg. Comp.","Equipment Related","","","","","To renew shorted coils on arrival of spares onboard","2019-12-15","DBRO190207","Waiting spare",null,"No","No","No","Internal","Item will be ready by 22nd Nov. Will be connected next call Singapore around 30th Nov. Target date extended till 15 Dec."]
[null,null,null,null,5593,"29/10/2019 4:45:53 PM","2019-10-05","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Heavy  Spare Parts kept above ECR to secure properly by fabricating stand for each and welding.","Miscellaneous","General Appearance","Equipment Related","5.11","Low","","","To fabricate and weld in place","2019-12-29","","Not Started",null,"No","No","No","Internal","Stand to be fabricated for each item and all wooden boxes to be discarded."]

{"sheet":"Completed","index":1,"n_rows":83,"n_cols":28,"rows_kept":83,"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","10-11-2019",null,null,"Ship Name","DHT BRONCO (03-12-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,539,"Sat Aug 10 2019 15:23:11 GMT+0000","2019-06-04","Observation","Ship Staff","Ship Staff Insp.","GROUND FAULT MONITOR 440 (ESBD) MALFUNCTIONING","Elect. Mach. & Equip.","Emgcy. Systems","Equipment Related","","","","","New ground ffault monitor installed","2019-10-20","DBRO190131","Completed","2019-10-11","No","No","No","Internal"]
[null,null,null,null,542,"Tue Oct 08 2019 08:41:26 GMT+0000","2019-04-09","Breakdown","Owner / Marine / Tech. Suptd.","Suptd. Insp.","UV LAMP, SLEEVE,SOLENOID VALVE REPALCEMENT","Miscellaneous","Eng. / Strg. Comp.","Equipment Related","","","","","Replacement with new spare","2019-04-30","","Completed","2019-04-26","No","No","No","Internal"]
[null,null,null,null,543,"Tue Oct 08 2019 10:30:41 GMT+0000","2019-05-02","Deficiency","Owner / Marine / Tech. Suptd.","Suptd. Insp.","ME BOTH TURBOCHARGER SILENCER STUD BOLT CHANGE","Main Engine ","Eng. / Strg. Comp.","Equipment Related","","","","","to replace as per technical circular","2019-05-05","","Completed","2019-05-02","No","No","No","Internal"]
[null,null,null,null,544,"Sat Aug 10 2019 10:34:27 GMT+0000","2019-05-14","Deficiency","Ship Staff","Ship Staff Insp.","LEAKING MGO TRANSFER PUMP MECHANICAL SEAL","ER Pipes, valves & fittings","Eng. / Strg. Comp.","Equipment Related","","","","","to renew mechanical seal","2019-05-14","","Completed","2019-05-14","No","No","No","Internal"]
[null,null,null,null,545,"Tue Oct 08 2019 10:37:51 GMT+0000","2019-05-16","Other","Ship Staff","Ship Staff Insp.","Aft mooring winch sight glass leak","Mooring Mach.","Mooring","Equipment Related","","","","","packing renewal","2019-05-18","","Completed","2019-05-16","No","No","No","Internal"]
[null,null,null,null,546,"Tue Oct 08 2019 10:40:43 GMT+0000","2019-05-17","Other","Ship Staff","Ship Staff Insp.","UV STERILIZER TRIGGERING LOW INTENSITY ALARM","ER Pipes, valves & fittings","General Appearance","Equipment Related","","","","","renewal of sterilizer uv lamp","2019-05-17","","Completed","2019-05-17","No","No","No","Internal"]
[null,null,null,null,547,"Sat Aug 10 2019 10:43:31 GMT+0000","2019-05-18","Other","Ship Staff","Ship Staff Insp.","DRIER FILTER CLOGGED FOR NO 2 AC","Miscellaneous","Eng. / Strg. Comp.","Equipment Related","","","","","to renew the filter element","2019-05-18","","Completed","2019-05-18","No","No","No","Internal"]
[null,null,null,null,548,"Tue Oct 08 2019 10:47:46 GMT+0000","2019-05-18","Other","Ship Staff","Ship Staff Insp.","2P BUNKER TANK FILLING  VALVE TOO HARD TO OPEN","ER Pipes, valves & fittings","Eng. / Strg. Comp.","Equipment Related","","","","","to ease up & grease the spindle","2019-05-18","","Completed","2019-05-18","No","No","No","Internal"]
[null,null,null,null,549,"Tue Oct 08 2019 10:51:13 GMT+0000","2019-05-19","Other","Ship Staff","Ship Staff Insp.","1S BUNKER TANK FILLING  VALVE TOO HARD TO OPEN","ER Pipes, valves & fittings","Eng. / Strg. Comp.","Equipment Related","","","","","to ease up & grease the spindle","2019-05-19","","Completed","2019-05-19","No","No","No","Internal"]
[null,null,null,null,550,"Tue Oct 08 2019 10:54:15 GMT+0000","2019-05-26","Deficiency","Ship Staff","Ship Staff Insp.","FWG EJECTOR PUMP ANODE EATEN UP AND LEAKING","Aux. Mach.","Eng. / Strg. Comp.","Equipment Related","","","","","to renew anode with packings","2019-06-26","","Completed","2019-06-26","No","No","No","Internal"]
[null,null,null,null,551,"Tue Oct 08 2019 10:58:05 GMT+0000","2019-05-31","Deficiency","Ship Staff","Ship Staff Insp.","Ships network cabinet fan not operational","Nav & comm. equip.","Communication","Equipment Related","","","","","to renew fan as GC","2019-06-26","","Completed","2019-06-26","No","No","No","Internal"]
[null,null,null,null,552,"Tue Oct 08 2019 11:01:17 GMT+0000","2019-06-05","Observation","Ship Staff","Ship Staff Insp.","MEMBRANE AIR DRIER INSTALLATION","Air Comp.","Eng. / Strg. Comp.","Equipment Related","","","","","to install & put in service","2019-06-30","","Completed","2019-06-25","No","No","No","Internal"]
[null,null,null,null,553,"Sat Aug 10 2019 14:55:56 GMT+0000","2019-06-11","Deficiency","Ship Staff","Ship Staff Insp.","RENEWAL OF V-BELT FOR SCR COMPRESSOR","Air Comp.","Eng. / Strg. Comp.","Equipment Related","","","","","to renew V-belts","2019-06-12","","Completed","2019-06-11","No","No","No","Internal"]
[null,null,null,null,554,"Tue Oct 08 2019 14:58:29 GMT+0000","2019-06-16","Deficiency","Ship Staff","Ship Staff Insp.","RENEWAL OF SEALING RINGS OF AE#3 FUEL P/P No 1 DISTRIBUTION BLOCK & PIPES","Aux. Engine","Eng. / Strg. Comp.","Equipment Related","","","","","renewal of seals","2019-06-21","","Completed","2019-06-16","No","No","No","Internal"]
[null,null,null,null,555,"Tue Oct 08 2019 15:02:26 GMT+0000","2019-06-22","Deficiency","Ship Staff","Ship Staff Insp.","SHAFT GROUNDING ABNORMAL VOLTAGE","Main Engine ","Eng. / Strg. Comp.","Equipment Related","","","","","to remove and clean slip ring and to adjust the brushes","2019-06-22","","Completed","2019-06-22","No","No","No","Internal"]
[null,null,null,null,556,"Tue Oct 08 2019 15:05:27 GMT+0000","2019-08-21","Observation","Ship Staff","Ship Staff Insp.","NO.1 REF. COM. MOTOR MAIN CONTACTOR TIP DAMAGED","Aux. Mach.","Eng. / Strg. Comp.","Equipment Related","","","","","RENEWED DAMAGED TIP AND CLEANED CONTACTOR. INSPECT AND CHECKED COIL FOR CONTACTOR, FOUND GOOD. MEASURED INSULATION RESISTANCE FOR MOTOR, FOUND ABOVE 2000 Mohm.","2019-08-21","","Completed","2019-08-21","No","No","No","Internal"]
[null,null,null,null,557,"Tue Oct 08 2019 15:08:34 GMT+0000","2019-05-10","Observation","Ship Staff","Ship Staff Insp.","ICO LUBE INSTALLATION","Main Engine ","Eng. / Strg. Comp.","Equipment Related","","","","","ICOLUBE PIPELINES AND ELECTRICAL CONNECTIONS LAID AND MADE OUT, COMMISSIONING CARRIED OUT BY LUKOIL SE AT SINGAPORE","2019-06-17","","Completed","2019-10-05","No","No","No","Internal"]
[null,null,null,null,558,"Tue Oct 08 2019 13:35:19 GMT+0000","2019-08-29","Guarantee Claim","Ship Staff","Ship Staff Insp.","FPK Tank air pipe float found damaged during routine inspection","Hull & Tanks","Structural Condn. / WT integrity ","Equipment Related","11.7","High","","","1.Vessel raised GC-119 for spare float 2.Spare received at Singapore on 8 Sep 2019, 3. Renewed the damaged one with the spare received onboar","2019-10-10","","Completed","2019-09-09","No","No","No","Internal"]
[null,null,null,null,559,"Tue Oct 08 2019 13:43:11 GMT+0000","2019-06-17","Non Conformity","Ship Staff","Ship Staff Insp.","ISPS Visitor Cards found missing","Miscellaneous","ISPS Related","Human Error","7.3","Low","","","Training carried out and all crew were explained for the ISPS Measures and procedures. Also requisition raised for new missing visitor cards.","2019-07-31","","Completed","2019-06-27","No","No","No","Internal"]
[null,null,null,null,560,"Tue Oct 08 2019 14:30:06 GMT+0000","2019-05-26","Non Conformity","Ship Staff","Ship Staff Insp.","Stencil for various vent heads on poop deck found to be amiss during routine inspection","Hull & Tanks","General Appearance","Human Error","11.7","High","","","All vent heads on poop deck stenciled immediately.","2019-08-31","","Completed","2019-08-30","No","No","No","Internal"]
[null,null,null,null,561,"Tue Oct 08 2019 15:49:46 GMT+0000","2019-05-18","Deficiency","Ship Staff","Ship Staff Insp.","ACCOMODATION GAS DETECTION SYSTEM GAS SENSOR FAULTY","Cargo Mach.","Cargo / Ballast Systems","Equipment Related","8.46","Very High","","","SYSTEM CALIBRATION CARRIED OUT FROM CCR. INDIVIDUAL SENSOR CALIBRATION CARRIED OUT.  CRF 17 RAISED AND SUBMITTED TO OFFICE FOR AMENDMENT IN PAL REGARDING CALIBRATION ROUTINE OF SENSORS LOCALLY.","2019-05-31","","Completed","2019-08-29","No","No","No","Internal"]
[null,null,null,null,562,"Tue Oct 08 2019 15:55:13 GMT+0000","2019-05-24","Deficiency","Ship Staff","Ship Staff Insp.","No 3 C COT IG pressure sensor faulty","Cargo Mach.","Cargo / Ballast Systems","Equipment Related","8.19","High","","","1. faulty sensor replaced with new one & confirmed working","2019-05-31","","Completed","2019-05-25","No","No","No","Internal"]
[null,null,null,null,563,"Wed Oct 09 2019 01:10:48 GMT+0000","2019-09-19","Observation","PSC Insp.","PSC Inspection","One of the valve on 16K steam pipeline on boiler deck was leaking seriously, and the valves on the same pipeline do not have proper thermal protection","Boiler","Eng. / Strg. Comp.","Equipment Related","10.32","Very High","Other","","Gland nipped up and laggings renewed with bigger size.","2019-09-22","","Completed","2019-09-20","No","No","No","External"]
[null,null,null,null,564,"Wed Oct 09 2019 01:16:39 GMT+0000","2019-09-19","Observation","PSC Insp.","PSC Inspection","ENCLOSED SPACE ENTRY AND RESCUE DRILL WAS CARRIED OUT ON 22 AUG 2019.THE RECORD OF ENTRY PERMIT INCORRECT","Documentation","ISM Related","Human Error","5.13","High","Other","","Proper Training on Enclosed Space Rescue and entry procedures given to all crew","2019-09-22","","Completed","2019-09-20","No","No","No","External"]
[null,null,null,null,565,"Wed Oct 09 2019 01:24:41 GMT+0000","2019-06-27","Observation","Owner / Marine / Tech. Suptd.","IT Audit","Internal Audit - Fire Drill is required to be carried out weekly as per 15.01.01.001.00 However this was not complied with in the month of Feb, Mar, Apr, May. Vessel has complied with this in Jun 2019","Documentation","Cert. & Docu.","Human Error","5.13","High","","","Vessel complied in June for weekly routine of fire drill.","2019-09-26","","Completed","2019-06-27","No","No","No","Internal"]
[null,null,null,null,566,"Wed Oct 09 2019 01:29:24 GMT+0000","2019-06-27","Observation","Owner / Marine / Tech. Suptd.","IT Audit","Internal Audit - Oil Soaked lagging observed on M.E Autoback wash filter","Main Engine ","Eng. / Strg. Comp.","Equipment Related","10.32","Very High","","","lagging renewed.","2019-09-26","","Completed","2019-07-09","No","No","No","Internal"]
[null,null,null,null,567,"Tue Sep 10 2019 01:34:49 GMT+0000","2019-06-27","Observation","Owner / Marine / Tech. Suptd.","IT Audit","Internal Audit - Wire mesh of Slop-P PV valve observed with minute holes. Same requires to be renewed","Deck Pipe / Fittings","Cargo / Ballast Systems","Equipment Related","8.21","High","","","Flame screen renewed","2019-09-26","","Completed","2019-06-27","No","No","No","Internal"]
[null,null,null,null,568,"Wed Oct 09 2019 01:41:51 GMT+0000","2019-06-27","Observation","Owner / Marine / Tech. Suptd.","IT Audit","Cargo Audit - Deck officers not familiar with the procedure of calibration of Pressure guages and Thermometer guages. Training for same to be conducted onboard. ","Miscellaneous","Cargo / Ballast Systems","Knowledge Based","","","","","Use of pressure calibration equipment demonstarted to all deck officers","2019-09-26","","Completed","2019-07-08","No","No","No","Internal"]
[null,null,null,null,569,"Wed Oct 09 2019 01:53:59 GMT+0000","2019-06-27","Non Conformity","Owner / Marine / Tech. Suptd.","Nav Audit / Verification","Navigation Audit - Risk Assessment for Use of  ECDIS does not cover all hazards listed as per company's navigation procedure  - 12. 01.31.03.01","Documentation","Navigation","Inappropriate Procedure","5.1","Very High","","","Latest Risk assessment was made as per company's procedures and guidelines.","2019-09-26","","Completed","2019-07-08","No","No","No","Internal"]
[null,null,null,null,570,"Wed Oct 09 2019 01:59:37 GMT+0000","2019-06-27","Non Conformity","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Navigation Audit - Floor plan for Engine room bottom platform as required by 12.06.33.00.00. not available for fire rounds. Colour coded tags or other similar method to ensure compliance with fire round call point location not in place","Miscellaneous","Cert. & Docu.","Inappropriate Procedure","","","","","Floor Plan for Engine room bottom platform prepared and received approval from office. Also colour coded tags placed in required location.","2019-09-26","","Completed","2019-06-27","No","No","No","Internal"]
[null,null,null,null,571,"Wed Oct 09 2019 11:51:01 GMT+0000","2019-04-06","Non Conformity","Ship Staff","Ship Staff Insp.","Vessel does not have spare wire for hose handling crane as required by GSM. Also spare wire for crane is required for cargo operations at several ports such as Rastanura & STS by Chevron in USWC. RO for same was rose DBRO190039. Vessel is expected to berth at rastanura on 1 may 2019.","Critical Equip.","Cargo / Ballast Systems","Equipment Related","","","",""," it was supplied at Singapore on 13th Apr 2019 & closed.","2019-04-29","","Completed","2019-04-13","No","No","No","Internal"]
[null,null,null,null,572,"Wed Oct 09 2019 11:53:47 GMT+0000","2019-04-07","Non Conformity","Ship Staff","Ship Staff Insp.","TOPPING UP COMPRESSOR/EMERGENCY AIR COMPRESSOR COOLING WATER PUMP MOTOR FOUND SINGLE PHASING","Air Comp.","Eng. / Strg. Comp.","Equipment Related","","","","","new spare recieved, fitted in place. compressor made operation.","2019-04-30","","Completed","2019-04-24","No","No","No","Internal"]
[null,null,null,null,573,"Wed Oct 09 2019 11:56:42 GMT+0000","2019-04-26","Non Conformity","Ship Staff","Ship Staff Insp.","PR FIXED GAS DETECTION SYSTEM- H2S SENSOR FAILED TO CALIBRATE","Cargo Mach.","Cargo / Ballast Systems","Equipment Related","","","","","Since the vessel is on guarantee period, GC claim rose & technician attended at Fujairah on 24th Apr 2019 & resolved the issue.","2019-05-10","","Completed","2019-04-26","No","No","No","Internal"]
[null,null,null,null,574,"Wed Oct 09 2019 11:47:46 GMT+0000","2019-03-02","Observation","Ship Staff","Ship Staff Insp.","During wet rounds on Saturday, officers found CO2 operation cabinet present in Fire & Foam Station is not locked.","LSA / FFA","LSA / FFA Appliances","Human Error","","","","","mmediately removed the key and locked the cabinet","2019-03-02","","Completed","2019-03-02","No","No","No","Internal"]
[null,null,null,null,575,"Wed Oct 09 2019 09:01:23 GMT+0000","2019-02-21","Non Conformity","Ship Staff","Ship Staff Insp.","During Nav Audit carried out by Master with all deck officers, found that entries in GMDSS log for change over watch were not maintained.","Nav & comm. equip.","Navigation","Human Error","","","","","All deck officers were instructed to log down the details of change over watch in GMDSS log (as mentioned in \"Notes for Completion of RADIO LOG\")","2019-03-15","","Completed","2019-02-21","No","No","No","Internal"]
[null,null,null,null,576,"Wed Oct 09 2019 08:57:28 GMT+0000","2019-01-28","Observation","Ship Staff","Ship Staff Insp.","Spanners supplied at Singapore by Sinwa were of inferior quality. Spanners bend while trying to open nut bolts.","Deck Mach.","General Appearance","Equipment Related","","","","","All damaged spanners are decommisioned and same reported to office.","2019-03-26","","Completed","2019-03-15","No","No","No","Internal"]
[null,null,null,null,577,"Wed Oct 09 2019 08:54:57 GMT+0000","2019-01-05","Non Conformity","Ship Staff","Ship Staff Insp.","DURING ROUTINE ROUNDS FOUND LIFTING LUGS IN EMERGENCY GENERATOR ROOM NOT MARKED WITH THEIR SWL","ER Pipes, valves & fittings","General Appearance","Behaviour Based","","","","","same time yard book checked and SWL stanciled on that lug for future use","2019-01-05","","Completed","2019-01-06","No","No","No","Internal"]
[null,null,null,null,578,"Thu Oct 10 2019 07:13:05 GMT+0000","2019-03-28","Observation","SIRE / CDI Insp.","OM Insp. (Eg. SIRE, CDI etc.)","The Ship design MBL was 122 T however the synthetic tails used on baord had a TDBF of 167.2 T which was 37% higher than that of the ship design MBL. ","Mooring Mach.","Mooring","Equipment Related","9.5","High","","","MEG 3 was in force till delivery of v/l and rope tails were supplied at that time as per MEG3 requirement. V/L will be supplied with new rope tails as per MEG 4 during renewal.  ","2019-04-15","","Completed","2019-04-01","No","No","No","External"]
[null,null,null,null,579,"Thu Oct 10 2019 07:24:00 GMT+0000","2019-03-28","Observation","SIRE / CDI Insp.","OM Insp. (Eg. SIRE, CDI etc.)","The last tetsing report (dated on 19th jan 2019) for the auxilary engine no.2 was marked with \"Critical\" due to excessive blow by or partly or unburned fuel might have caused the viscocity and soot increase. The oil is not suitable for further use. the corrective action has been taken (Sum tank drained , cleaned and oil changed) and ship staff sent samples ashore at this port for analysis. ","Aux. Engine","Eng. / Strg. Comp.","Equipment Related","10.7","Medium","","","Sump cleaned , lube oil renewed and alos checked all fuel injecters , found in good working condition. All unit peak pressure checked,and found satisfactory. Thereafter AE performace checked and all parameters found normal. ","2019-04-16","","Completed","2019-03-28","No","No","No","External"]
[null,null,null,null,5594,"29/10/2019 4:56:10 PM","2019-10-29","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Operational spares identification in PAL not completely covered","Miscellaneous","Eng. / Strg. Comp.","Equipment Related","","","","","To identify and mark all operational spares in PAL","2019-11-15","","Completed","2019-11-15","No","No","No","Internal"]
[null,null,null,null,5595,"30/10/2019 4:20:33 PM","2019-10-26","Observation","Ship Staff","Ship Staff Insp.","UPS power fail alarm on DG LP SCR unit","Aux. Mach.","Eng. / Strg. Comp.","Equipment Related","","","","","Advise from makers for troubleshooting","2019-11-30","","Completed","2019-11-01","No","No","No","Internal","Please check condition of battery as advised by maker. Raise RO if the battery is spoiled."]
[null,null,null,null,5596,"29/10/2019 4:37:51 PM","2019-10-05","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","FWD Mast CCTV Camera defective","Miscellaneous","Communication","Equipment Related","11.1","High","","","To restore the functionality","2019-10-25","","Completed","2019-10-06","No","No","No","Internal"]
[null,null,null,null,5597,"29/10/2019 4:41:54 PM","2019-10-05","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","220V Insulation at 5M ohm, with deck lights on","Elect. Mach. & Equip.","General Appearance","Equipment Related","10.38","Medium","","","to improve the Insulation","2019-10-25","","Completed","2019-10-10","No","No","No","Internal"]
[null,null,null,null,5598,"29/10/2019 4:48:13 PM","2019-10-05","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","No:3 DG Start failure alarm during annual survey to investigate. Fuel pump racks are getting stuck, racks to be eased up/lubricated weekly.","Aux. Engine","Eng. / Strg. Comp.","Equipment Related","10.32","Very High","","","Orifices in the condensate drain of Air cooler/scavenge receiver cleaned; no more starting issues","2019-10-15","","Completed","2019-10-06","No","No","No","Internal"]
[null,null,null,null,6045,"15/11/2019 12:15:56 PM","2019-10-29","Deficiency","Ship Staff","Ship Staff Insp.","3S COT tank pressure on SAAB display showing erratic reading","Cargo Mach.","Cargo / Ballast Systems","Equipment Related","","","","","Same to be investigated and renew pressure sensor if required .","2019-11-10","","Completed","2019-11-11","No","No","No","Internal"]
[null,null,null,null,7114,"Fri Dec 06 2019 02:47:06 GMT+0000 (Coordinated Universal Time)","2019-11-18","Observation","Owner / Marine / Tech. Suptd.","ISM Audit","Ship Shore Safety Checklist 12.20.05.292.01 dated 22 Oct 2019 for Load Port Juaymah:\n\nPart B Pt. 33, 37 & 38 With Code A - No Comments in Remarks section sighted.\n\n","Documentation","ISM Related","Inappropriate Procedure","5.9","Very High","","","CA- Same has been corrected and was complied with during discharging at Daesan. ","2019-11-30","","Completed","2019-11-28","No","No","No","Internal"]
[null,null,null,null,7115,"Fri Dec 06 2019 02:50:48 GMT+0000 (Coordinated Universal Time)","2019-11-18","Observation","Owner / Marine / Tech. Suptd.","ISM Audit","Ship Shore Safety Checklist 12.20.05.292.01 dated 22 Oct 2019 for Load Port Juaymah:\n\nPart B Pt. 56 marked as checked, which is not Applicable for Loading Operation.\n\n","Documentation","Cert. & Docu.","Inappropriate Procedure","5.9","Very High","","","Same has been corrected and was complied with during discharging at Daesan","2019-12-30","","Completed","2019-11-28","No","No","No","Internal"]
[null,null,null,null,7116,"Fri Dec 06 2019 04:03:41 GMT+0000 (Coordinated Universal Time)","2019-11-18","Observation","Owner / Marine / Tech. Suptd.","ISM Audit","CCR Movement Log : Entry for Independent check of Line up did not include Venting for Loading Operation at Ras Tanura / Ras Laffan.","Documentation","Cargo / Ballast Systems","Inappropriate Procedure","","","","","Same has been corrected and was complied with during discharging at Daesan","2019-11-30","","Completed","2019-11-28","No","No","No","Internal"]
[null,null,null,null,7134,"Fri Dec 06 2019 04:08:38 GMT+0000 (Coordinated Universal Time)","2019-11-18","Observation","Owner / Marine / Tech. Suptd.","Mooring Audit","Mooring Winches sighted marked with BRC. However no marking sighted for Max Designed  BHC. Same to be marked along with BRC.  ","Mooring Mach.","Mooring","Inappropriate Procedure","9.19","Low","","","BHC was marked on Mooring winches along with BRC","2019-11-30","","Completed","2019-11-28","No","No","No","Internal"]
[null,null,null,null,null,"Sat Oct 12 2019 16:05:00 GMT+0000 (Coordinated Universal Time)","2019-06-23","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Stbd lifeboat embarkation light not working","LSA / FFA","LSA / FFA Appliances","Equipment Related",5.29,"High","Not Applicable","Not Applicable","replace bulb","2019-08-23",null,"Completed","2019-07-01","No",null,null,"Internal"]
[null,null,null,null,null,"Sat Oct 12 2019 16:07:51 GMT+0000 (Coordinated Universal Time)","2019-06-23","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","No MSDS for Glycol available in chemical locker","Miscellaneous","Cert. & Docu.","Human Error",5.46,"Medium","Not Applicable","Not Applicable","to post MSDS","2019-08-30",null,"Completed","2019-07-01","No",null,null,"Internal"]
[null,null,null,null,null,"Sat Oct 12 2019 16:10:37 GMT+0000 (Coordinated Universal Time)","2019-06-23","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Various MSDS for paints and items like varnish etc not available in paint locker","Miscellaneous","Cert. & Docu.","Human Error",5.46,"Medium","Not Applicable","Not Applicable","To post MSDS","2019-08-08",null,"Completed","2019-07-01","No",null,null,"Internal"]
[null,null,null,null,null,"Sat Oct 12 2019 16:13:07 GMT+0000 (Coordinated Universal Time)","2019-06-23","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Colour coding of cooking oil disposal container as per garbage management plan","Miscellaneous","ISM Related","Human Error",6.2,"High","Not Applicable","Not Applicable","To paint as per garbage management plan","2019-08-08",null,"Completed","2019-07-02","No",null,null,"Internal"]
[null,null,null,null,null,"Tue Dec 10 2019 16:15:18 GMT+0000 (Coordinated Universal Time)","2019-06-23","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","IMO symbol for liferaft showing 15P capacity however the actual capacity of liferaft is 16P","LSA / FFA","LSA / FFA Appliances","Human Error",5.28,"Very High","Not Applicable","Not Applicable","To put in place the right symbol","2019-08-08",null,"Completed","2019-07-04","No",null,null,"Internal"]
[null,null,null,null,null,"Sat Oct 12 2019 16:17:29 GMT+0000 (Coordinated Universal Time)","2019-06-23","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Quick release arrangement not fitted for life raft embarkation ladder fwd and aft","LSA / FFA","LSA / FFA Appliances","Equipment Related",5.27,"Medium","Not Applicable","Not Applicable","Quick release arrangement to be fitted for life raft embarkation ladder fwd and aft","2019-08-08",null,"Completed","2019-07-08","No",null,null,"Internal"]
[null,null,null,null,null,"Sat Oct 12 2019 16:20:14 GMT+0000 (Coordinated Universal Time)","2019-06-23","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","FW hydrant on deck near life boat having minor leakage","LSA / FFA","LSA / FFA Appliances","Equipment Related",10.119999999999999,"Very High","Not Applicable","Not Applicable","to rectify the leak","2019-08-08",null,"Completed","2019-07-06","No",null,null,"Internal"]
[null,null,null,null,null,"Sat Oct 12 2019 16:23:04 GMT+0000 (Coordinated Universal Time)","2019-06-23","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Slop-P PV valve wire mesh having minute holes","Deck Pipe / Fittings","General Appearance","Equipment Related",8.2100000000000009,"High","Not Applicable","Not Applicable","renew mesh","2019-08-08",null,"Completed","2019-07-05","No",null,null,"Internal"]
[null,null,null,null,null,"Sat Oct 12 2019 16:25:27 GMT+0000 (Coordinated Universal Time)","2019-06-23","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Stbd aft lamp post 1 nos light not operational","Elect. Mach. & Equip.","General Appearance","Equipment Related",11.9,"Low","Not Applicable","Not Applicable","replace bulb","2019-08-08",null,"Completed","2019-07-01","No",null,null,"Internal"]
[null,null,null,null,null,"Sat Oct 12 2019 16:27:30 GMT+0000 (Coordinated Universal Time)","2019-06-23","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Fore mast stbd light on windlass not operational","Elect. Mach. & Equip.","General Appearance","Equipment Related",11.9,"Low","Not Applicable","Not Applicable","replace bulb","2019-08-08",null,"Completed","2019-07-02","No",null,null,"Internal"]
[null,null,null,null,null,"Sat Oct 12 2019 16:29:42 GMT+0000 (Coordinated Universal Time)","2019-06-23","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Pipes stored athwart ship in fore peak store having possibility of shifting during rolling","Deck Pipe / Fittings","General Appearance","Human Error",11.4,"Very High","Not Applicable","Not Applicable","to properly secure pipes","2019-08-23",null,"Completed","2019-07-04","No",null,null,"Internal"]
[null,null,null,null,null,"Sat Oct 12 2019 16:32:31 GMT+0000 (Coordinated Universal Time)","2019-06-23","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Forward bosun store insulation meter fitted for light post panel not operational","Elect. Mach. & Equip.","ISM Related","Equipment Related",10.38,"Medium","Not Applicable","Not Applicable","to replace the insulation meter","2019-08-23",null,"Completed","2019-08-01","No",null,null,"Internal"]
[null,null,null,null,null,"Sat Oct 12 2019 16:35:31 GMT+0000 (Coordinated Universal Time)","2019-06-23","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Electrical hazard IMO symbol not posted on the AUS started panel (440v)","Elect. Mach. & Equip.","Cert. & Docu.","Equipment Related",10.24,"Low","Not Applicable","Not Applicable","Electrical hazard IMO symbol to be post on the AUS started panel (440v)","2019-08-23",null,"Completed","2019-07-02","No",null,null,"Internal"]
[null,null,null,null,null,"Sat Oct 12 2019 16:37:57 GMT+0000 (Coordinated Universal Time)","2019-06-23","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Electrical matt (green colour) at various locations in engine room observed to be without any markings nor a certificate available for same","Elect. Mach. & Equip.","Eng. / Strg. Comp.","Equipment Related",10.24,"Low","Not Applicable","Not Applicable","to fit certified electrical matting","2019-08-23",null,"Completed","2019-08-05","No",null,null,"Internal"]
[null,null,null,null,null,"Sat Oct 12 2019 16:41:40 GMT+0000 (Coordinated Universal Time)","2019-06-23","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","No-1 HFO purifier sludge pressure gauge tapping minor oil leakage","Purifier","Eng. / Strg. Comp.","Equipment Related",10.119999999999999,"Very High","Not Applicable","Not Applicable","to rectify leakage","2019-08-23",null,"Completed","2019-07-08","No",null,null,"Internal"]
[null,null,null,null,null,"Sat Oct 12 2019 16:43:37 GMT+0000 (Coordinated Universal Time)","2019-06-23","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","No-2 HFO purifier sludge connection pipe old oil","Purifier","Eng. / Strg. Comp.","Equipment Related",10.119999999999999,"Very High","Not Applicable","Not Applicable","to clean and observe for any leake","2019-08-23",null,"Completed","2019-07-08","No",null,null,"Internal"]
[null,null,null,null,null,"Sat Oct 12 2019 16:45:26 GMT+0000 (Coordinated Universal Time)","2019-06-23","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","NO-1,2,3 AE fuel oil filter oil observed below in tray","Aux. Engine","Eng. / Strg. Comp.","Equipment Related",10.119999999999999,"Very High","Not Applicable","Not Applicable","to rectify the leaks","2019-08-23",null,"Completed","2019-07-17","No",null,null,"Internal"]

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

{"sheet":"Ship_information","index":19,"n_rows":2,"n_cols":3,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["Ship_ID","Ship_Name","FILE_NAME"]
["33","DHT BRONCO (03-12-2019)","33_1575974696646.xlsm"]