{"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":21,"n_cols":27,"rows_kept":21,"cut":false,"hidden":false,"merged":[[12,6,12,26],[8,6,8,26],[10,8,10,9],[10,12,10,13]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Defect - Damage Monitoring Sheet"]
[]
[null,null,null,null,null,null,null,"Date of Report","08-Oct-2019",null,null,"Ship Name","DHT REDWOOD"]
[]
[]
[]
[]
[]
[null,null,null,null,"ID","UNIQUE ID","Date Recorded","Type of Deficiency","Observer code","Type of Inspection","Description of Deficiency","Equipment Categories","Area of Observation","Deficiency Cause","VIQ Ref Number","Risk Value of Obs","PSC Ref Number","PSC MOU ID","Action Taken or Required","Target Date","PO Ref No.","Status Code","Date Completed","Drydock","Info Sharing","Critical Item","Audit Type"]
[null,null,null,null,null,"2019-10-10T12:30:16","2019-10-09","Deficiency","Ship Staff","Ship Staff Insp.","No.2 STBD Manfold pressure transmitter faulty. ","Deck Pipe / Fittings","Cargo / Ballast Systems","Equipment Related",8.31,null,"Not Applicable","Not Applicable","Faulty pressure transmitter to be replaced","2019-11-30","DRED190215","Waiting spare",null,"No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-10T13:51:26","2019-09-07","Observation","Ship Staff","Ship Staff Insp.","Faulty X-Guard unit of Vapor monitoring system","Inert Gas","Cargo / Ballast Systems","Equipment Related",null,null,"Not Applicable","Not Applicable","- Spare O2 cell was installed in the oxygen sensor junction box. No feedback received from the O2 cell, Observed 24 volt input to PCB but no output from unit. Span gas applied for calibration, no deflection in reading observed","2019-11-30","DRED190211","Waiting spare",null,"No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-12T14:54:31","2019-01-18","Deficiency","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Data logger GMT has diff of 13 minutes from actual","Critical Equip.","MARPOL Related","Equipment Related",null,null,"Not Applicable","Not Applicable","Office has been informed and they are waiting for advice from the maker.Official entry in ORB has been made for same.","2019-07-30","-","Not Started",null,"No",null,null,"Internal"]
[null,null,null,null,null,"2019-12-10T17:15:16","2019-08-07","Breakdown","Ship Staff","Ship Staff Insp.","Ship's Laundry thumble dryer on sunken deck and A-deck  found idler pulley damage and belt broken. Same to be renew/repair.","Elect. Mach. & Equip.","MLC Related","Equipment Related",null,null,"Not Applicable","Not Applicable","R.O raised","2019-08-25","DRED190177","In progress",null,"No",null,null,"Internal"]

{"sheet":"Completed","index":1,"n_rows":60,"n_cols":27,"rows_kept":60,"cut":false,"hidden":false,"merged":[[8,6,8,26],[10,8,10,9],[10,12,10,13],[12,6,12,26]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Defect - Damage Monitoring Sheet"]
[]
[null,null,null,null,null,null,null,"Date of Report","8-9-2019",null,null,"Ship Name","DHT REDWOOD"]
[]
[]
[]
[]
[]
[null,null,null,null,"ID","UNIQUE ID","Date Recorded","Type of Deficiency","Observer code","Type of Inspection","Description of Deficiency","Equipment Categories","Area of Observation","Deficiency Cause","VIQ Ref Number","Risk Value of Obs","PSC Ref Number","PSC MOU ID","Action Taken or Required","Target Date","PO Ref No.","Status Code","Date Completed","Drydock","Info Sharing","Critical Item","Audit Type"]
[null,null,null,null,null,"2019-10-10T14:07:25","2019-01-08","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Bridge window wiper blades broken","Accommodation ,Miscellaneous","Navigation","Equipment Related",null,null,"Not Applicable","Not Applicable","Window wiper blades renewed","2019-01-14",null,"Completed","2019-01-14","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-10T14:11:01","2019-01-18","Other","Ship Staff","Ship Staff Insp.","Bridge wing both sides water pot for wet temp was found empty","Miscellaneous","Navigation","Human Error",null,null,"Not Applicable","Not Applicable","Water pot for the muslin cloth was immediately filled up. Prudent watch keeping to be followed always.","2019-01-18",null,"Completed","2019-01-18","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-10T14:34:40","2019-01-18","Deficiency","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Brake band opening stopper bolts, Clearance more than 10 mm","Mooring Mach.","Mooring","Equipment Related",null,null,"Not Applicable","Not Applicable","Clearance to be maintained not more 5 mm. Same carried out","2019-01-25",null,"Completed","2019-01-24","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-10T15:27:20","2019-01-18","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Weekly deck water washing regimen/routines not followed ","Deck Pipe / Fittings","General Appearance","Human Error",null,null,"Not Applicable","Not Applicable","Same to be followed on a weekly basis","2019-01-25",null,"Completed","2019-01-26","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-10T15:30:17","2019-01-14","Deficiency","Ship Staff","Ship Staff Insp.","VECS control box at the manifold found badly corroded and with rust stains all over the box","Deck Pipe / Fittings","General Appearance","Equipment Related",null,null,"Not Applicable","Not Applicable","Cosmetic upgradation carried out","2019-01-30",null,"Completed","2019-01-28","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-10T15:33:21","2019-01-14","Observation","Ship Staff","Ship Staff Insp.","General housekeeping on deck and in stores found to be lacking standards.","Miscellaneous","General Appearance","Industry Issue",null,null,"Not Applicable","Not Applicable","All stores to be properly arranged and houskeeping to be improved significantly to maintain high standards  in safety and quality","2019-01-30",null,"Completed","2019-01-29","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-10T15:36:15","2019-01-18","Deficiency","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Pump room air damper remote stops cabin not water proof, water observed collected inside","Cargo Mach.","Cargo / Ballast Systems","External Factors",null,null,"Not Applicable","Not Applicable","To check coaming sealing/packing and renew/repair as necessary","2019-02-02",null,"Completed","2019-01-26","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-10T15:39:18","2019-01-14","Deficiency","Ship Staff","Ship Staff Insp.","Deck seal safety breather valve found in bad condition, with flanges & nutbolts rusted and flame screen broken","Inert Gas","Cargo / Ballast Systems","Equipment Related",null,null,"Not Applicable","Not Applicable","Flame screen renewed","2019-01-31",null,"Completed","2019-01-17","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-10T15:43:25","2019-01-18","Deficiency","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Stbd gangway wire reel drum bearing grease nipple painted over- no sign of grease","Deck Mach.,Miscellaneous","General Appearance","Equipment Related",null,null,"Not Applicable","Not Applicable","All grease nipples made free of paint and properly lubricated","2019-01-23",null,"Completed","2019-01-23","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-10T15:48:46","2019-01-05","Other","Ship Staff","Ship Staff Insp.","Forward CCTV Camera unit's PAN and TILT unit and zoom in/out function are in-operational.","LSA / FFA","LSA / FFA Appliances","Equipment Related",null,null,"Not Applicable","Not Applicable","Camera has been replaced due to zooming problem. Camera tried out, all functions are normal","2019-02-28",null,"Completed","2019-01-15","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-10T15:53:27","2019-01-14","Deficiency","Ship Staff","Ship Staff Insp.","/ All mooring winches relief valves found painted and frozen.","Mooring Mach.","Mooring","Equipment Related",null,null,"Not Applicable","Not Applicable","All relief valves to be made free of paint and ensure that they are working in good order","2019-01-31",null,"Completed","2019-01-30","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-10T18:20:13","2019-01-18","Deficiency","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Port side hyd motor reported knocking sound while paying out at low speed mode only","Mooring Mach.","Mooring","Equipment Related",null,null,"Not Applicable","Not Applicable","Motor replaced with new spare and working satisfcatoory.(Job order no: V-DRED018689/19)","2019-02-02",null,"Completed","2019-02-03","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-10T18:24:02","2019-01-18","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Fwd PV breaker  for WBTS – liquid level not visible","Deck Mach.","Cargo / Ballast Systems","Equipment Related",null,null,"Not Applicable","Not Applicable","Liquid topped to required level","2019-01-25",null,"Completed","2019-02-02","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-10T18:27:00","2019-01-14","Deficiency","Ship Staff","Ship Staff Insp.","Wheels of deck air and fresh water suply valves found badly wasted and corroded","Deck Pipe / Fittings","General Appearance","Equipment Related",null,null,"Not Applicable","Not Applicable","Same to be replace with new wheels.","2019-02-15",null,"Completed","2019-01-30","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-10T18:31:30","2019-01-18","Deficiency","Owner / Marine / Tech. Suptd.","Suptd. Insp.","SMGO bunker line desser coupling leaking near stbd side manifold ","Deck Pipe / Fittings","MARPOL Related","Equipment Related",null,null,"Not Applicable","Not Applicable","Dismantled the coupling and renewed them.","2019-01-28",null,"Completed","2019-02-09","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-10T18:39:19","2019-01-18","Deficiency","Owner / Marine / Tech. Suptd.","Suptd. Insp.","BWTS deck seal tank empty","Cargo Mach.","Cargo / Ballast Systems","Equipment Related",null,null,"Not Applicable","Not Applicable","BWTS to be started and checked every month, all associated equipment to be kept in ready condition","2019-01-25",null,"Completed","2019-02-10","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-10T18:45:09","2019-01-18","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Observed mast riser stay wires rusted and devoid of grease","Inert Gas","General Appearance","Inappropriate Procedure",null,null,"Not Applicable","Not Applicable","To ensure wires are sufficiently greased to avoid rust/damage","2019-02-15",null,"Completed","2019-02-26","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-10T18:47:53","2019-01-14","Deficiency","Ship Staff","Ship Staff Insp.","Protective plate for cables on the P/S L/B davit found to be corroded and wasted.","Deck Pipe / Fittings","General Appearance","External Factors,Inappropriate Procedure",null,null,"Not Applicable","Not Applicable","Plate to be renewed and fixed ","2019-03-15",null,"Completed","2019-02-28","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-10T18:50:46","2019-01-18","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Remote hyd valve box on deck, hinge & supports rusted","Cargo Mach.","General Appearance","Equipment Related,Inappropriate Procedure",null,null,"Not Applicable","Not Applicable","To derust and avoid wastage of steel","2019-03-15",null,"Completed","2019-03-21","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-10T18:53:37","2019-01-18","Deficiency","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Coaming thinned down/wasted at one location","Miscellaneous","General Appearance","External Factors",null,null,"Not Applicable","Not Applicable","Complete assembly to dismantle and to be repaired at ER w/shop","2019-03-31",null,"Completed","2019-04-23","No",null,null,"Internal"]
[null,null,null,null,null,"2019-12-10T14:06:18","2019-01-14","Breakdown","Ship Staff","Ship Staff Insp.","No.2P bunker tank vent saveall found corroded at the lip, same to be repaired. Also all Savealls on deck to be inspected for lips plate wastage and refman made.","Deck Pipe / Fittings","MARPOL Related","Equipment Related",null,null,"Not Applicable","Not Applicable","No other saveall lips found corroded, all in satisfactory condition.","2019-03-30",null,"Completed","2019-03-29","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-12T14:09:57","2018-01-18","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Isolated rust marks observed on pipe stacks – particualry on the stbd side Ballast tank IG pipe at the bottom/resting on supports","Deck Pipe / Fittings","General Appearance","Equipment Related",null,null,"Not Applicable","Not Applicable","To ensure maintenance is carried out immediately on observing isolated rust spots. Update as on 29 Mar: Cosmetic maintenance ongoing, new locations keep coming up for maintenance and same being undertaken asap. This job is being closed out as the locations observed by Suptd have already been attended to and cosmetics completed. ","2019-03-18",null,"Completed","2019-03-29","No",null,null,"Internal"]
[null,null,null,null,null,"2019-12-10T14:13:11","2018-01-18","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Cargo manifold platform Gratings rusted","Deck Pipe / Fittings","General Appearance","External Factors",null,null,"Not Applicable","Not Applicable","Port side manifold gratings is  hyblasted and cosmetic maintenance is completed.","2019-04-29",null,"Completed","2019-05-30","No",null,null,"Internal"]
[null,null,null,null,null,"2019-12-10T14:17:07","2019-01-18","Deficiency","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Gun retaining springs missing on Foam monitors #3, #4, #5 ","LSA / FFA","LSA / FFA Appliances","Equipment Related",null,null,"Not Applicable","Not Applicable","Foam monitor missing springs renewed.","2019-03-30","DRED190054","Completed","2019-05-30","No",null,null,"Internal"]
[null,null,null,null,null,"2019-12-10T14:22:37","2019-01-18","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","No test bench onboard for PV valve – given the numerous no. of valves (including for Ballast tanks)","Deck Pipe / Fittings","Cargo / Ballast Systems","External Factors",null,null,"Not Applicable","Not Applicable","R.O raised and approved from vessel's end","2019-04-30","DRED1900059","Completed","2019-08-21","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-12T14:27:45","2019-01-18","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Lubricator, mositure drain filter found fully wrapped with denzo tape – completely unware of function inside","Mooring Mach.","Mooring","Equipment Related",null,null,"Not Applicable","Not Applicable","To remove denzo tape, ensure same is maintained in working condition. Same complied with.","2019-01-23",null,"Completed","2019-01-22","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-12T14:36:09","2019-02-05","Deficiency","Ship Staff","Ship Staff Insp.","FWD mast steering light 220 volt insulation showing 0.5 mega ohms ","Miscellaneous","Navigation","Equipment Related",null,null,"Not Applicable","Not Applicable","Checked and found steeing light fitting had crack same renewed with new spare one checked insulation found 100 mega ohms","2019-02-15",null,"Completed","2019-02-08","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-12T14:38:43","2019-02-12","Deficiency","Ship Staff","Ship Staff Insp.","Bridge stbd wing Anemometer display found fallen down ","Nav & comm. equip.","Navigation","Equipment Related",null,null,"Not Applicable","Not Applicable","Panel open removed Display unit and fitted back.(Job order no: V-DRED019407/19) ","2019-02-15",null,"Completed","2019-02-14","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-12T14:41:41","2019-02-11","Deficiency","Ship Staff","Ship Staff Insp.","During greasing and closeup inspection of mooring wires, found strands of aft spring mooring wire on drum MW6B, broken at ~15 mtrs from eye. Upon calculation of no. of strands broken, confirmed that this end of wire is unfit for use and requires to be changed End for End or Replaced. Note: As per available maintenance records, this mooring wire was turned end to end on 09 May 2017.","Mooring Mach.","Mooring","Equipment Related",null,null,"Not Applicable","Not Applicable","Wire to be changed End for End or Replaced with spare mooring wire on board. Update as on 08 Mar 2019: Vessel has turned the wire End for End and this wire shall be replaced once New wire is received on board.","2019-03-15",null,"Completed","2019-03-08","No",null,null,"Internal"]
[null,null,null,null,null,"2019-12-10T14:44:39","2019-02-10","Deficiency","Ship Staff","Ship Staff Insp.","Deck seal pump#1 impeller key and shaft found damaged.","Deck Mach.","Cargo / Ballast Systems","Equipment Related",null,null,"Not Applicable","Not Applicable","Requisition has been raised. PO no DRED 190065. for the time being shaft has been replaced with Ballast deck seal pump #2","2019-03-30","DRED 190065","Completed","2019-02-11","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-12T14:49:02","2019-02-18","Deficiency","Ship Staff","Ship Staff Insp.","During GMDSS battery load test on 17.2.19 its found after 7 hrs battery voltage dropped bellow alarm level. ","Nav & comm. equip.","Navigation","Equipment Related",null,null,"Not Applicable","Not Applicable","Batteries rechanged and showing 25.7 volts. Batteries replaced with new one.","2019-04-30","DRED 190070","Completed","2019-04-21","No",null,null,"Internal"]
[null,null,null,null,null,"2019-12-10T16:08:19","2019-02-18","Deficiency","Owner / Marine / Tech. Suptd.","Suptd. Insp.","During GMDSS battery load test on 17.2.19 its found after 7 hrs battery voltage dropped bellow alarm level. Batteries rechanged and showing 25.7 volts. ","Nav & comm. equip.","Communication","Equipment Related",null,null,"Not Applicable","Not Applicable","Batteries replaced with new one.","2019-04-29","DRED190050","Completed","2019-04-21","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-12T16:16:42","2019-03-21","Deficiency","Ship Staff","Ship Staff Insp.","220volts low insulation 1 mega ohms  on deck midship port flood light ","Deck Pipe / Fittings,Elect. Mach. & Equip.","General Appearance","Equipment Related",null,null,"Not Applicable","Not Applicable","checked and found junction box some water ingressed found same cleaned and dryed treid out found insulation 80 mega ohms","2019-03-24",null,"Completed","2019-03-22","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-12T16:19:27","2019-03-25","Deficiency","Ship Staff","Ship Staff Insp.","Spilt bearing of Port windlass winch outboard drum gear shaft out of place.","Mooring Mach.","Mooring","Equipment Related",null,null,"Not Applicable","Not Applicable","Split bearing renewed. Please refer job no. V-DRED020399/19 for further details.","2019-04-30",null,"Completed","2019-03-27","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-12T16:32:28","2019-03-18","Critical Equipment,Deficiency","Ship Staff","Ship Staff Insp.","SCBA Straps found Cracked.","LSA / FFA","LSA / FFA Appliances","Equipment Related",null,null,"Not Applicable","Not Applicable","Spares recd. And changed in Rizhao, CHINA.","2019-04-30","DRED190054","Completed","2019-04-05","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-12T16:36:02","2019-03-27","Deficiency","Ship Staff","Ship Staff Insp.","STBD cargo line No 1 manifold pressure showing 0 in CCR PMS display.","Deck Pipe / Fittings","Cargo / Ballast Systems","Equipment Related",null,null,"Not Applicable","Not Applicable","Safty Barrier renewed with spare one raised.","2019-04-20",null,"Completed","2019-04-23","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-12T16:40:00","2019-03-29","Deficiency","Ship Staff","Ship Staff Insp.","Ship side scupper on Port Lifeboat deck found choked.","Deck Pipe / Fittings","General Appearance","Equipment Related",null,null,"Not Applicable","Not Applicable","Vessel has tried clearing the scupper pipe by various means, viz. hammering of the scupper pipe inside port void space, hydro blasting into the scupper pipe to clear debris, snake wire, derust liquid, but nothing has been effective. Solution: To rig staging on the ship side and try to clear the horizontal choked section from ship side externally. Vessel shall try to undertake this job at a suitable and safe anchorage at next available opportunity. Since vessel unable to clear the choke, have raised REFMAN for carrying out the job during DD. Note: The length of the scupper pipe is almost 5 meters inside the void space and is without any flange.","2019-05-31",null,"Completed","2019-08-15","Yes",null,null,"Internal"]
[null,null,null,null,null,"2019-10-12T16:45:03","2018-04-07","Deficiency","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Cleaning require around all sounding pipes in engine room bilges and deck as old oil not cleaned around them","Hull & Tanks","General Appearance","Human Error",null,null,"Not Applicable","Not Applicable","All soundings pipes already painted","2019-04-15",null,"Completed","2019-04-08","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-12T16:47:39","2019-04-07","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Lowest pressure Alarm displayed on CCR pressure transmitter panel","Cargo Mach.","Cargo / Ballast Systems","Equipment Related",null,null,"Not Applicable","Not Applicable","After testing the alarms of the pressure transmitter, the alarms to be set to zero.","2019-04-10",null,"Completed","2019-04-09","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-12T16:50:44","2018-04-07","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Printer for CCR pressure transmitter having faded printouts","Cargo Mach.","Cargo / Ballast Systems","Equipment Related",null,null,"Not Applicable","Not Applicable","Printouts for CCR pressure transmitter were still ligible and readable. However ribbon changed on 8-Apr-2019","2019-04-15",null,"Completed","2019-04-08","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-12T16:55:17","2018-04-06","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Minute holes observed in wire mess of 4P, 2P, 1P and Slop-S PV valves","Deck Pipe / Fittings","General Appearance","External Factors",null,null,"Not Applicable","Not Applicable","Flame screens of 1P and 4P were found to be having very miniscule holes and renewed. Also, these flamescreens have a dual screen protection for the purpose of spark arresting. And the condition of the secondary inner flame screen is good, without any holes.","2019-04-15",null,"Completed","2019-04-13","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-12T16:58:13","2019-04-06","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Recommend to fit quick release securing for embarkation ladders as currently the securing will take time to open","LSA / FFA","LSA / FFA Appliances","Equipment Related",null,null,"Not Applicable","Not Applicable","At present our embarkation ladder covers can be opened up by 2 persons within a minute. Hence the arrangement is found satisfactory from ship's end.","2019-04-15",null,"Completed","2019-04-08","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-12T17:01:36","2019-04-07","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Garden hose to be fitted below the ream of metal half drums kept at manifold to avoid metal to metal contacts","Miscellaneous","General Appearance","Behaviour Based,Industry Issue",null,null,"Not Applicable","Not Applicable","Own ship places rubber insulation mats below the drums, which serve the purpose of preventing metal to metal contact. Rubber mats cut to ensure they don’t cover any excess area beyond the half drum to ensure that any seepage beyond the half drum will go in ","2019-04-15",null,"Completed","2019-04-08","No",null,null,"Internal"]

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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