{"text_format":"1","workbook":"xlsx","n_sheets":24,"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","External_Deficiency_type","External_Inspection_type","External_Observer_code","Sheet Version"],"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":39,"n_cols":28,"rows_kept":39,"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","11-Oct-2021",null,null,"Ship Name","DHT HARRIER (11-10-2021)"]
[]
[null,null,null,null,null,null,"VERSION : 2.0"]
[]
[]
[]
[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,20626,"113_1/8/2021 8:37:28 PM","2021-02-18","Defect","Ship Staff","Ship Staff Insp.","BWTS AC is inoperational as No.1&2 Fan Motor and driver BLDC card is defective.","Miscellaneous","Cargo / Ballast Systems","Equipment Related","","","","","BLDC cards and Fan motor requistion has been placed and awaiting spares for the same.","2021-10-30","","Waiting spare",null,"No","No","No","Internal","Please always mention the PO number to check. Fyi, two motors were ordered and waiting readiness. BLDC card was supplied before. Please send an email providing PO number. Additional comment on 17 Sept.: Target date extended till  30 October as vessel is on long voyage from Norway to China and then to Singapore where spares can be supplied.\nComment on 11th Oct:  PO number still missing. Please confirm by email the PO number is 210154.  If it is so, then it is ready in Korea and will be supplied to vessel whn calls Singapore at end of October."]
[null,null,null,null,20804,"113_15/9/2021 3:36:44 PM","2021-04-27","Observation","Ship Staff","Ship Staff Insp.","LT cooler #1, #2 Sea water instrument flanges corroded/erroded , same needs to be replaced with new one.","E/R - Pipes/ valves & fittings","Eng. / Strg. Comp.","Equipment Related","10.31","Very High","","","awaiting spares","2021-11-15","DHAR210055","Waiting spare",null,"No","No","No","Internal","Spares ready with Forwarder in Europe. Will arrange to deliver next call Singapore in October."]
[null,null,null,null,20627,"113_1/8/2021 8:51:38 PM","2021-06-05","Defect","Ship Staff","Ship Staff Insp.","Aft peak De-ballasting operation cannot be carried out through BWTS as MPC valve for the system is malfunctioning and shutting down the system.","Miscellaneous","Cargo / Ballast Systems","Equipment Related","","","","","MPC valve needs replacement or attendance by shore technician to fix the system.As per superintendent comments RO rasied for Service technician","2021-10-15","DHAR210207","Waiting spare",null,"No","No","No","Internal","Procedure given to vessel to repair/clean the valve. Please revert. If not repairable then have to order to replace the valve. please revert to mr. Sajeesh as soon as possible.\nAdditional comments on 20/9/21:  Please send a separate email to fleet 3 with PO number.\nAdditional comment on 11 Oct: We are trying to procure the spares before vessel arrives Singapore at end of October.  Target date extended to 30 October as vessel is delayed in China."]
[null,null,null,null,20628,"113_1/8/2021 8:48:51 PM","2021-06-22","Defect","Ship Staff","Ship Staff Insp.","TRO 001 and 002 during ballasting doesn’t display any value.","Cargo Mach.","Cargo / Ballast Systems","Equipment Related","","","","","RO rasied as per superintendent comments","2021-10-15","DHAR210208","Waiting spare",null,"No","No","No","Internal","It was checked with maker who confirmed need to replace both the sensors. Please raise RO soon possible.\nAdditional comment on 20/9/21: Have you raised PO? Also add this item in dialogue with makers for Bi- weekly operational report.\nComment on 20/9/21: Please advise PO number and send a separate email on subject.\nAdditional comment on 11 October:  Ref email- as trouble shooting done and TRO sensors found in good working condition- please close this Defect."]
[null,null,null,null,20629,"113_30/8/2021 6:59:38 PM","2021-06-25","Non Conformity","Ship Staff","Ship Staff Insp.","CONDITION OF A-60 FIRE DOOR CONNECTING STEERING GEAR ROOM AND ENGINE ROOM IN A BAD STATE","Miscellaneous","Safety / LSA / FFA","Equipment Related","","","","","PO RAISED","2021-10-30","DHAR210124","Waiting spare",null,"No","No","No","Internal","Spare has been ordered from Korea and awaiting readiness. Will try to connect to vessel at next call Singapore around 1st week of October,\nAdditional comment on 11 Oct: Target date extended to 30 October as ETA Singapore delayed."]
[null,null,null,null,20630,"113_1/8/2021 8:40:20 PM","2021-07-18","Defect","Ship Staff","Ship Staff Insp.","Donkey boiler is unable to burn HFO due to defective heater.","E/R - Boiler","Eng. / Strg. Comp.","Equipment Related","","","","","Requistion has been raised for defective spare and will be corrected once spares are received","2021-10-30","DHAR210160","Waiting spare",null,"No","No","No","Internal","Spare has been ordered and will be kept ready for next call Singapore around 1st week of October ( Po 210160). Please always mention PO number.\nAdditional comment on 11 October: Spare is ready. Target date extended to 30 October as vessel is delayed to arrive Singapore."]
[null,null,null,null,20631,"113_1/8/2021 9:29:43 PM","2021-07-20","Critical Equipment,Defect","Ship Staff","Ship Staff Insp.","UPS FOR ALARM MONITORING SYSTEM NO. 2 is defective.","Elect. Mach. & Equip.","Eng. / Strg. Comp.","Equipment Related","","","","","RO DHAR210145 is raised.","2021-10-30","DHAR210145","Waiting spare",null,"No","No","No","Internal","Spare will be connected in Singapore next call around 1st week of October. Extended Target date to 15th October.\nAdditional comment on 11 October: Please urgently provide AMS makers details as ordinary UPS from local supplier will not work for AMS system.   See my separate email and reply asap.. Due to delay in vessel's ETA Singapore the target date changed to 30th October."]
[null,null,null,null,20632,"113_30/8/2021 6:42:05 PM","2021-08-01","Breakdown","Ship Staff","Ship Staff Insp.","GALLEY EXHAUST FAN STARTER CONTROLLER DEFECTIVE","Elect. Mach. & Equip.","General Appearance","Equipment Related","11.14","Medium","","","PO RAISED","2021-10-30","DHAR210047","Waiting spare",null,"No","No","No","Internal","Spare is ready in Singapore and will connect next call Singapore in 1st week of October.\non 11 October: Target date extended till end of October as vessel's ETA changed."]
[null,null,null,null,20633,"113_30/8/2021 6:44:39 PM","2021-08-01","Breakdown","Ship Staff","Ship Staff Insp.","GARBAGE DISPOSER IN GALLEY NOT OPERATIONAL, SEAL LEAKING","Miscellaneous","General Appearance","Equipment Related","11.14","Medium","","","PO RAISED","2021-10-30","DHAR210067","Waiting spare",null,"No","No","No","Internal","Spare is ready and will connect in Singapore around 1st week of October.\nOn 11 October: Target date extended to end October as ETA Singapore delayed."]
[null,null,null,null,20634,"113_30/8/2021 6:50:05 PM","2021-08-01","Breakdown","Ship Staff","Ship Staff Insp.","UPS FOR AUX ENGINE #2, #3 NOT OPERATIONAL","Elect. Mach. & Equip.","Eng. / Strg. Comp.","Equipment Related","","","","","PO RAISED","2021-10-30","DHAR210086","Waiting spare",null,"No","No","No","Internal","Spare is ready in Singapore and will be connected in Singapore around 1st week of September.\nComment on 11 October: Target date extended to 30th October as vessel's ETA to Singapore delayed ."]
[null,null,null,null,20625,"113_31/8/2021 12:11:43 PM","2021-08-05","Observation","Ship Staff","Ship Staff Insp.","MAIN ENGINE UNIT #1 CYLINDER EXHAUST LOCAL THERMOMETER NOT OPERATIONAL","E/R - Main Engine","Eng. / Strg. Comp.","Equipment Related","10.32","Very High","","","NEED TO REPLACE WITH SPARE NEW THERMOMETER","2021-10-30","DHAR210180","Waiting spare",null,"No","No","No","Internal","PO 210180 was received in PAL today (31/8). Will try to order as soon as receive the quote.\nAdditional Comment on 20 Sept 21: Spare has been ordered. Awaiting readiness.\non 11th October: Target date extended till end of October as vessel's ETA Singapore is delayed."]
[null,null,null,null,20635,"113_30/8/2021 7:43:42 PM","2021-08-12","Observation","Ship Staff","Ship Staff Insp.","VACUUM CONDENSOR SEA WATER PUMP SEAL LEAKING","E/R - Pumps","Eng. / Strg. Comp.","Equipment Related","10.31","Very High","","","SEAL TO BE REPLACED WITH NEW ONE","2021-10-30","DHAR210179","Waiting spare",null,"No","No","No","Internal","Po 210179 just received today (31/8/21) in PAL. Will try to get quote and order as soon as possible.\nAdditional comment on 20 Sept 21: Spares ordered and will arrange to deliver next call Singapore in early October.\nOn 11 Oct: Target date extended to 30th October as  vessel is delayed at Chine and ETA Singapore  is now end of October"]
[null,null,null,null,20636,"113_16/8/2021 6:16:16 PM","2021-08-14","Defect","Ship Staff","Ship Staff Insp.","No GPS input on RCP and MCP screen of BWTS","Cargo Mach.","Cargo / Ballast Systems","Equipment Related","","","","","Requires techician attendance.As per superintendent comments RO rasied for Service technician","2021-11-14","DHAR210207","Waiting spare",null,"No","No","No","Internal","Need  service engineer to attend. Please raise a RO for repair in Singapore. Also send an email listing any other issue with BWTS.\nAdditional comment on 20 Sept 21:  BWTS makers have sent some queries to vessel by email.  Please respond to those queries."]
[null,null,null,null,20637,"113_16/8/2021 6:22:05 PM","2021-08-14","Breakdown","Ship Staff","Ship Staff Insp.","Overfill alarm hooter inoperational","Cargo Mach.","Cargo / Ballast Systems","Equipment Related","8.14","Very High","","","RO raised : DHAR210149","2021-11-13","DHAR210149","Waiting spare",null,"No","No","No","Internal","Spares ordered from Korea and awaiting readiness. Wil try to connect next call Singapore around 1st week of OCtober 21."]
[null,null,null,null,20638,"113_16/8/2021 6:27:25 PM","2021-08-14","Breakdown","Ship Staff","Ship Staff Insp.","Wind Hi Hi alarm hooter inoperational","Cargo Mach.","Cargo / Ballast Systems","Equipment Related","","","","","PO raised : DHAR210149","2021-11-13","DHAR210149","Waiting spare",null,"No","No","No","Internal","Spares are order from Korea and waiting readiness.  Will try to connect next call Singapore in1st week of October,"]
[null,null,null,null,20639,"113_16/8/2021 6:31:19 PM","2021-08-14","Breakdown","Ship Staff","Ship Staff Insp.","Pumproom deadman hooter inoperational","Cargo Mach.","Cargo / Ballast Systems","Equipment Related","","","","","PO raised : DHAR210150","2021-11-13","DHAR210150","Waiting spare",null,"No","No","No","Internal","For Po 210150- not getting any quotes from Makers and Korean suppliers. Please send all details from the pump room horn name plate and also send photos to check locally in Singapore.\nAdditional comments on 11 Oct: Spares have been ordered. Also understand problem has been sorted out as malfunction of solenoid valve. Please close this defect."]
[null,null,null,null,20641,"113_16/8/2021 6:50:21 PM","2021-08-14","Observation","Ship Staff","Ship Staff Insp.","Mooring wires need end to end renewal but is currently dirffred as other end of mooring wire does not have a mechanical eye","Deck - Mooring Machinery","Mooring","Equipment Related","9.17","High","","","Wires will be turned end to end once the wire has a mechanical eye so that it can be lashed on main drum.Office needs to arrange for mechanical eye splicing at a convinient port","2021-11-13","","Not Started",null,"No","No","No","Internal","We are looking for suitable workshop in Singapore who can do the splicing. Will update once arranged.\nAdditional comment on 11 Oct: Have arranged a workshop who will carry out the job at next call Singapore at end of October."]
[null,null,null,null,20642,"113_16/8/2021 6:58:53 PM","2021-08-14","Defect","Ship Staff","Ship Staff Insp.","Port side manifold drain line CL318 common valve seat ring is damaged.","Deck - Pipe / Fittings","Cargo / Ballast Systems","Equipment Related","","","","","PO raised : DHAR210104 & DHAR210108","2021-11-13","DHAR210104 & DHAR210108","Waiting spare",null,"No","No","No","Internal","The Po 210104 is ready in Singapore. The PO 210108 was cancelled. Please check and confirm."]
[null,null,null,null,20649,"113_31/8/2021 12:08:14 PM","2021-08-15","Observation","Ship Staff","Ship Staff Insp.","Training EEBD found leaking","LSA / FFA","Safety / LSA / FFA","Equipment Related","5.44","High","","","Awaiting PO","2021-11-14","DHAR210154","Waiting spare",null,"No","No","No","Internal","Spares ordered and will try to connect next call Singapore after China in 1st week of October."]
[null,null,null,null,20805,"113_14/9/2021 1:28:16 PM","2021-09-14","Observation","Ship Staff","Ship Staff Insp.","Weather indicator (Barometric pressure, Temperature and humidity percentage) on bridge found to be inaccurate when compared with actual readings.","Navigation - Others","Navigation","Equipment Related","","","","","RO raised for transmitter","2021-12-14","DHAR210186","Waiting spare",null,"No","No","No","Internal","Spare has been ordered and waiting readiness. Will try to arrange delivery at earliest."]
[null,null,null,null,20806,"113_14/9/2021 1:31:49 PM","2021-09-14","Observation","Ship Staff","Suptd. Insp.","OWS power on/off switch is installed on bridge. GW requirement is that there should be a key for OWS power","Miscellaneous","MARPOL Related","Equipment Related","","","","","RO raised : DHAR210166","2021-12-14","RO raised : DHAR210166","Waiting spare",null,"No","No","No","Internal","Spare has been ordered and waiting for readiness. Will try to arrange delivery at earliest possible."]
[null,null,null,null,20807,"113_14/9/2021 1:34:35 PM","2021-09-14","Observation","Ship Staff","Ship Staff Insp.","X Band Spare magnetron not available onboard.","Navigation - RADAR","Safety / LSA / FFA","Equipment Related","","","","","RO raised : DHAR210184","2021-12-14","RO raised : DHAR210184","Waiting spare",null,"No","No","No","Internal","Understand spare magnetron has been consumed recently. Will try to supply the spare during next call Singapore in early October 2021."]

{"sheet":"Completed","index":1,"n_rows":34,"n_cols":28,"rows_kept":34,"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","11-Oct-2021",null,null,"Ship Name","DHT HARRIER (11-10-2021)"]
[]
[null,null,null,null,null,null,"VERSION : 2.0"]
[]
[]
[]
[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,20644,"113_1/8/2021 1:48:27 PM","2021-02-18","Defect","Ship Staff","Ship Staff Insp.","No 2 aircon compressor had major breakdown before takeover","Accommodation","Eng. / Strg. Comp.","Equipment Related","","","","","overhauled completely with new sets of liner, unloader components (Rocker arm, bearing cup, springs), Discharge valve springs and plates for all units renewed,3 no’s of piston were replaced, all unit’s piston & scrapper rings renewed, conrod bearings and conrod bolts were renewed, LO oil filter renewed, suction filter cleaned and fresh charge of oil taken. The compressor leak test carried out after charging refrigerant. The compressor is now operational and running in order.","2021-05-15","","Completed","2021-05-14","No","No","No","Internal"]
[null,null,null,null,21087,"113_20/9/2021 12:03:06 PM","2021-06-02","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Both windlass cosmetics to improve","Deck - Mooring Machinery","Mooring","Equipment Related","9.2","Very High","","","Both windlass derusted and painted","2021-06-30","","Completed","2021-06-25","No","No","No","Internal"]
[null,null,null,null,21088,"113_20/9/2021 11:57:13 AM","2021-06-02","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Main deck spot maintenance and de-rusting of pipe clamps to be carried out","Deck - Pipe / Fittings","Structural Condn. / WT integrity ","Equipment Related","11.7","High","","","Main deck spot maintenance and de-rusting of pipe clamps in progress","2021-08-30","","Completed","2021-08-15","No","No","No","Internal"]
[null,null,null,null,21089,"113_20/9/2021 12:13:54 PM","2021-06-02","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Accom stores housekeeping has scope of improvement","Accommodation","General Appearance","Inappropriate Procedure","10.29","Medium","","","Accomodation cleaned and stores arranged","2021-06-30","","Completed","2021-06-20","No","No","No","Internal"]
[null,null,null,null,21090,"113_20/9/2021 7:29:52 AM","2021-06-02","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","All DG turbo charger filters cery dirty\t","E/R - Aux. Engine","Eng. / Strg. Comp.","Equipment Related","10.32","Very High","","","All DG turbo charger filters renewed with new ones","2021-06-15","","Completed","2021-06-04","No","No","No","Internal"]
[null,null,null,null,21091,"113_20/9/2021 12:38:13 PM","2021-06-02","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Spare parts inventory to be taken on priority. Start raising RO as inventory progresses.  Once physical inventory is completed- then PMS to be updated.","Miscellaneous","ISM Related","Inappropriate Procedure","10.12","Very High","","","PMS updated as per spare part inventory","2021-08-30","","Completed","2021-08-27","No","No","No","Internal"]
[null,null,null,null,20645,"113_1/8/2021 8:45:11 PM","2021-06-18","Defect","Ship Staff","Ship Staff Insp.","ER workshop AC is inoperational as there is gas leakage in the system.","Miscellaneous","Eng. / Strg. Comp.","Equipment Related","","","","","Gas leakage in the system detected after flushing the system with nitrogen and the leaking tube joint area brazed and pressure tested with nitrogen before drawing out the gas by vaccum and cahraging with referigerant. The system is now owrking satisfactorily","2021-09-18","","Completed","2021-07-29","No","No","No","Internal"]
[null,null,null,null,20646,"113_30/8/2021 6:53:33 PM","2021-08-01","Breakdown","Ship Staff","Ship Staff Insp.","EXHAUST GAS CLEANING SYSTEM INLET WASH WATER TURBIDITY SENSORSHOWING FAULT\t","E/R - Pipes/ valves & fittings","Eng. / Strg. Comp.","Equipment Related","10.11","Medium","","","NETWORK SETTINGS FOR TURBIDITY SENSOR RESETTED.","2021-08-31","","Completed","2021-08-27","No","No","No","Internal"]
[null,null,null,null,20650,"113_30/8/2021 7:07:37 PM","2021-08-03","Breakdown","Ship Staff","Ship Staff Insp.","MAIN AIR COMPRESSOR #1 NOT STARTING IN AUTO MODE. STARTED CONTACTOR IS BURNT AND START DELAY TIME FAULTY","E/R - Air Comp.","Eng. / Strg. Comp.","Equipment Related","10.32","Very High","","","CONTACTOR ROUTINES CARRIED OUT, REPLACED CONTACTS AND STARTER TIMER REPLACED WITH SPARE ONE.","2021-08-31","DHAR210165,DHAR210163","Completed","2021-08-18","No","No","No","Internal"]
[null,null,null,null,20647,"113_30/8/2021 7:40:12 PM","2021-08-12","Observation","Ship Staff","Ship Staff Insp.","MAIN AIR COMPRESSOR #2 , AIR LEAKING AFTER COOLER FROM AIR SIDE ","E/R - Air Comp.","Eng. / Strg. Comp.","Equipment Related","10.32","Very High","","","O RING FOR AFTERCOOLER ENDPLATE COVER REPLACED WITH NEW ONE","2021-08-31","","Completed","2021-08-18","No","No","No","Internal"]
[null,null,null,null,20640,"113_16/8/2021 6:45:37 PM","2021-08-14","Observation","Ship Staff","Ship Staff Insp.","Port side anchor lowering button for hydraulic brake operation found hard","Deck - Mooring Machinery","Mooring","Equipment Related","9.2","Very High","","","Button eased up.Working satisfatorily","2021-11-13","","Completed","2021-09-25","No","No","No","Internal","Finding it difficult to get any quotation with information from vessel. Procure and Mr. Sajeesh still sourcing for it and may take time.  Believe in problem with operation at the moment.\nAdditional comment on 20 Sept 21: Vessel has asked to cancel this PO on 15 Sept as buttons are now working. Please close this defect as completed."]
[null,null,null,null,20643,"113_31/8/2021 11:57:32 AM","2021-08-15","Observation","Ship Staff","Ship Staff Insp.","Port side provision crane few hoses to be replaced as per 5 yearly routine","Deck - Machinery","Cargo / Ballast Systems","Equipment Related","8.5","Very High","","","Replaced by ship staff","2021-11-14","","Completed","2021-09-14","No","No","No","Internal","It is long pending and must complete during current voyage in Sept 2021 and before arrival Rizhao on 2/9/21."]
[null,null,null,null,20648,"113_30/8/2021 7:52:13 PM","2021-08-20","Observation","Ship Staff","Ship Staff Insp.","FRESH WATER GENERATOR DEFLECTOR PLATE SUPPORT BRACKETS SHEARED OFF.","E/R - Aux. Mach.","Eng. / Strg. Comp.","Equipment Related","","","","","NEW FRAME FOR FITTING THE DEFLECTOR PLATE ON THE TUBE STACK FABRICATED AND DEFLECTOR INSTALLED. ","2021-08-31","","Completed","2021-08-26","No","No","No","Internal"]
[null,null,null,null,21462,"113_3/10/2021 8:55:29 AM","2021-09-09","Observation","Ship Staff","Ship Staff Insp.","Main engine TSA-A failure alarm","E/R - Main Engine","Eng. / Strg. Comp.","Equipment Related","10.32","Very High","","","MArker A sensor wiring tightened","2021-09-13","","Completed","2021-09-13","No","No","No","Internal"]
[null,null,null,null,20809,"113_14/9/2021 1:37:54 PM","2021-09-10","Observation","Ship Staff","Ship Staff Insp.","Microphone on Steering stand given for magnetic compass deck communication is not working.","Navigation - Others","Navigation","Equipment Related","","","","","Settings changed and found to be working","2021-12-10","","Completed","2021-09-11","No","No","No","Internal"]
[null,null,null,null,20808,"113_14/9/2021 3:15:04 PM","2021-09-14","Observation","Ship Staff","Ship Staff Insp.","Spare mooring wires onboard have a MBL of 121.4 T whereas the Ship Design MBL is 125T .As per MEG 4 the LDBF for mooring wire should be 100~105% of Ship design MBL.So the spare mooring wires cannot be used.","Deck - Mooring Machinery","Mooring","Human Error","9.5","High","","","Refer mail from technical and ops dept dated 28 Sept 2021 for same","2021-11-14","","Completed","2021-09-28","No","No","No","Internal","The RO is being processed. Please advise when the spare Mooring wire was supplied by Goodwood or were these inherited from last owners. Advise by email."]
[null,null,null,null,21463,"113_3/10/2021 8:59:10 AM","2021-09-15","Observation","Ship Staff","Ship Staff Insp.","Steering gear #1,#2 motor coupling chain worn out","E/R - Aux. Mach.","Eng. / Strg. Comp.","Equipment Related","10.32","Very High","","","Chain for both Steering motor #1,#2 replaced with new one","2021-09-15","","Completed","2021-09-15","No","No","No","Internal"]

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

{"sheet":"Areaofobs","index":3,"n_rows":17,"n_cols":2,"rows_kept":17,"cut":false,"hidden":true,"merged":[]}
["TITLE","ID"]
["Cargo / Ballast Systems",11]
["Cert. & Docu.",2]
["Communication",6]
["Crew Management",3]
["Emgcy. Systems",13]
["Eng. / Strg. Comp.",14]
["General Appearance",15]
["Ice Opns.",17]
["ISM Related",7]
["ISPS Related",10]
["MARPOL Related",9]
["MLC Related",4]
["Mooring",12]
["Navigation",5]
["Safety / LSA / FFA",8]
["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":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
["TITLE","Type of deficiency_description","ID"]
["Breakdown",null,6]
["Critical Equipment",null,4]
["Defect",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":28,"n_cols":3,"rows_kept":28,"cut":false,"hidden":true,"merged":[]}
["TITLE","Equipment_list_description","ID"]
["Accommodation",null,12]
["Cargo Mach.",null,13]
["Critical Equip.",null,16]
["Deck - Machinery",null,18]
["Deck - Mooring Machinery",null,15]
["Deck - Pipe / Fittings",null,20]
["Documentation",null,21]
["E/R - Air Comp.",null,8]
["E/R - Aux. Engine",null,4]
["E/R - Aux. Mach.",null,7]
["E/R - Boiler",null,5]
["E/R - Main Engine",null,3]
["E/R - Pipes/ valves & fittings",null,9]
["E/R - Pumps",null,32]
["E/R - Purifier",null,6]
["Elect. Mach. & Equip.",null,10]
["Hull & Tanks",null,19]
["Inert Gas",null,14]
["LSA / FFA",null,17]
["Miscellaneous",null,22]
["Navigation - DGPS / EPFS / AIS",null,28]
["Navigation - ECDIS",null,25]
["Navigation - Echo Sounder / Speed Log",null,26]
["Navigation - GMDSS & Communication",null,23]
["Navigation - Others",null,11]
["Navigation - RADAR",null,24]
["Navigation - VDR / BNWAS",null,30]

{"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":13,"n_cols":2,"rows_kept":13,"cut":false,"hidden":true,"merged":[]}
["TITLE","ID"]
["Bunkering Audit",14]
["Cargo Audit",17]
["Engineering Audit",16]
["ISM Audit",2]
["ISPS Audit",3]
["IT Audit",10]
["MLC Audit",1]
["Mooring Audit",9]
["Nav Audit / Verification",8]
["Onboard Training",18]
["Ship Staff Insp.",15]
["Suptd. Insp.",13]

{"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":3,"n_cols":3,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
["TITLE","Observer_code_description","ID"]
["Owner / Marine / Tech. Suptd.",null,3]
["Ship Staff",null,2]

{"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"]
["113","DHT HARRIER (11-10-2021)","113_1633937503264.xlsm"]

{"sheet":"External_Deficiency_type","index":20,"n_rows":5,"n_cols":3,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
["TITLE","Type of deficiency_description","ID"]
["Condn of Class / Memo",null,5]
["Defect",null,1]
["Non Conformity",null,2]
["Observation",null,3]

{"sheet":"External_Inspection_type","index":21,"n_rows":11,"n_cols":2,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
["TITLE","ID"]
["Cargo Audit",17]
["Flag State Insp.",5]
["ISM Audit",2]
["ISPS Audit",3]
["MLC Audit",1]
["Nav Audit / Verification",8]
["OM Insp. (Eg. SIRE / CDI etc.)",6]
["Others (Eg. Insurance etc.)",12]
["PSC Inspection",4]
["Terminal Insp.",11]

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

{"sheet":"Sheet Version","index":23,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["Version","Title"]
["2.0","Version 2.0"]