{"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":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","04-Jan-2022",null,null,"Ship Name","DHT OSPREY (03-01-2022)"]
[]
[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,21391,"116_2/10/2021 4:50:25 AM","2021-09-22","Observation","Ship Staff","Ship Staff Insp.","VRCS observed to be giving LONG RUN alarm and unable to maintain required 145-185 bar pressure. It is able to maintain only 130-135 bar pressure when in operation.","Deck - Machinery,E/R - Pipes/ valves & fittings","Cargo / Ballast Systems","Equipment Related",8.8000000000000007,"Medium","Not Applicable","Not Applicable","We have now completed checking of all valves individually and have zerod it down to the ODME valve (CL152)(return line valve going to slop port tank. This valve block is causing the pressure drop from 150 to 0 bar is 10~15mins. We shall now wait for charge discharge operations to finish, after which we shall check this valve block and find out the fault. Incase need be, we shall raise RO for necessary spare. Other than this valve, system is all fine. ","2022-01-31",null,"In progress",null,"No","No","No","Internal","Extended target date to 31st JAN 2022. Revert your finding, job planning and rectification progress in the weekly deck maintenance report"]
[null,null,null,null,23285,"116_3/1/2022 11:50:42 AM","2021-12-22","Defect","Ship Staff","Ship Staff Insp.","ME HCU Acuumulators of units 1P,2P,3P & 3S,4P & 4S,7S - diaphragms are leaking. As such ME operation is not affected for now and all parameters are normal.","E/R - Main Engine","Eng. / Strg. Comp.","Equipment Related","10.32","Very High","","","The leakage oil is being collected into save all tray arrangement and transferred to 200 litres drum and put back into system after filteration. NOTE: All HCU units were overhauled in last Drydock and new diaphragms fitted. Apparantly, either due to poor workmanship or quality issues the diaphragms are found cracked /leaking. All HCU accumulator diaphragms need to be replaced at first opportunity. RO is raised for necessary spares.","2022-02-15","DOSP210191","Waiting spare",null,"No","No","No","Internal","PO# DOSP210191 issued to main engine parts supplier, DUBHE CO LTD.  Waiting spare readiness. Arranging to connect at your disport DAESAN. Or else, next call at SINGAPORE."]
[null,null,null,null,null,"116_15/1/2022 12:42:00 PM","2022-01-03","Breakdown","Ship Staff","Ship Staff Insp.","Elevator - C-DECK -Door contact -gate swtich is defective.The plastic internal parts of swtich are broken. ","Elect. Mach. & Equip.","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Elevator - for C-deck use is not operational and all staff have been adviced against use of elevator for C-deck. Urgent RO is raised for the necessary spare to rectify the fault. ","2022-03-02","DOSP 220022","Waiting spare",null,"No",null,null,"Internal"]

{"sheet":"Completed","index":1,"n_rows":62,"n_cols":28,"rows_kept":62,"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","04-Jan-2022",null,null,"Ship Name","DHT OSPREY (03-01-2022)"]
[]
[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,20610,"116_2/8/2021 7:21:00 PM","2021-04-12","Observation","Ship Staff","Ship Staff Insp.","Steering gear 1 and 2 phase relay defective.","Elect. Mach. & Equip.","Eng. / Strg. Comp.","Equipment Related","10.39","High","","","Repalced with new spare phase relay still problem persisted. Then checked the circuit found worngly connected output of phase relay same corrected now tested working in good condition.","2021-08-30","DOSP210058","Completed","2021-08-17","No","No","No","Internal",""]
[null,null,null,null,20611,"116_4/8/2021 12:21:52 PM","2021-06-03","Observation","Ship Staff","Ship Staff Insp.","M.E leaks from unit 1,2,7 lubricator assembly and unit 2,7 F.O booster p/p assembly.","E/R - Main Engine","Eng. / Strg. Comp.","Equipment Related","10.29","Medium","","","Workshop carried out the job in Singapore for the same issue and rectified.","2021-08-30","","Completed","2021-08-13","No","No","No","Internal",""]
[null,null,null,null,20622,"116_4/8/2021 6:09:31 PM","2021-07-01","Observation","Ship Staff","Ship Staff Insp.","No2 steering gear pump seal leak.","Elect. Mach. & Equip.,Miscellaneous","Eng. / Strg. Comp.","Equipment Related","10.32","Very High","","","Replaced the seal with new spare seal.Tried out no sign of leaks","2021-07-30","","Completed","2021-07-24","No","No","No","Internal"]
[null,null,null,null,20613,"116_1/8/2021 12:21:21 PM","2021-07-05","Observation","Owner / Marine / Tech. Suptd.","ISM Audit","Fwd embarkation ladder lowering light bracket on stbd side was found jammed. Same was freed up during inspection.","LSA / FFA","Safety / LSA / FFA","Equipment Related","5.28","Very High","","","Embarkation ladder lowering light bracket was freed up during the inspection. Greasing and lubrication was done","2021-10-05","","Completed","2021-07-05","No","No","No","Internal"]
[null,null,null,null,20615,"116_11/8/2021 5:39:11 PM","2021-07-05","Observation","Owner / Marine / Tech. Suptd.","ISPS Audit","Restricted area were not marked on few Cargo tanks.","Hull & Tanks","ISPS Related","Behaviour Based,Inappropriate Procedure","7.3","Low","","","All Cargo tanks were marked with restricted areas markings. All Marking of restricted areas were marked and re-verified as per SSP","2021-08-05","","Completed","2021-07-15","No","No","No","Internal"]
[null,null,null,null,20621,"116_27/7/2021 7:55:02 PM","2021-07-05","Non Conformity","Owner / Marine / Tech. Suptd.","ISM Audit","Foam isolation valve IMO symbol was found in place of foam hydrant IMO symbol.","Deck - Pipe / Fittings,LSA / FFA","Safety / LSA / FFA","Equipment Related,Human Error","5.38","High","","","Once observed, the particular IMO symbol for   Foam hydrant was put in place.All IMO symbols onboard were verified to check that no incorrect IMO symbols are in use. Condition of all IMO symbols were checked and found satisfactory.","2021-10-04","","Completed","2021-07-09","No","No","No","Internal"]
[null,null,null,null,20614,"116_4/8/2021 6:25:44 PM","2021-07-06","Observation","Ship Staff","Ship Staff Insp.","Boiler no 2 Emg feed water valve leaking from the boiler mounting.","E/R - Boiler","Eng. / Strg. Comp.","Equipment Related","10.32","Very High","","","Depressurised the boiler.Removed the valve and replaced the gasket with new metflex gasket.Tried out no signs of leaks.","2021-07-30","","Completed","2021-07-28","No","No","No","Internal"]
[null,null,null,null,20609,"116_11/8/2021 5:45:51 PM","2021-07-15","Defect","Ship Staff","Ship Staff Insp.","BA 528 valve was replaced with BA 508 as the no. 1 WBP discharge valves BA 508 was found defective and required for routine ballast operation. BA 528 valve need to be renewed on receipt of new valve","Deck - Pipe / Fittings","Cargo / Ballast Systems","Equipment Related","8.11","Medium","","","Seat ring renewed on BA 528 and fitted in place. BA528 not required during routine ballast operations. Received new valve at singapore on 29.09.2021. Renewed BA528 on 04.10.2021","2021-10-15","DOSP210099","Completed","2021-10-04","No","No","No","Internal",""]
[null,null,null,null,20612,"116_4/8/2021 12:50:36 PM","2021-07-15","Defect","Ship Staff","Ship Staff Insp.","E.R NO 2  Blower motor breaker tripped.","Elect. Mach. & Equip.","Eng. / Strg. Comp.","Equipment Related","10.32","Very High","","","Recieved the same motor and installed in place.Now running satisfactory.","2021-09-30","","Completed","2021-08-16","No","No","No","Internal",""]
[null,null,null,null,20616,"116_4/8/2021 6:16:24 PM","2021-07-18","Observation","Ship Staff","Ship Staff Insp.","Sewage no1 aeration blower tripped.","Elect. Mach. & Equip.","Eng. / Strg. Comp.","Equipment Related","10.32","Very High","","","On investigation found impeller stuck due to deposits restricting the movement. overhauled motor with new spare bearings and impeller casing cleaned.Tried out now working satisfactory.","2021-07-30","","Completed","2021-07-23","No","No","No","Internal"]
[null,null,null,null,20617,"116_4/8/2021 2:30:24 PM","2021-07-18","Observation","Ship Staff","Ship Staff Insp.","M.E unit  2 ,7 high pressure pipe leaking","E/R - Main Engine","Eng. / Strg. Comp.","Equipment Related","10.32","Very High","","","Vessel overhauled both high pressure pipe leak stops. Raised R.O for new Spare.","2021-09-30","DOSP210112","Completed","2021-08-13","No","No","No","Internal",""]
[null,null,null,null,20618,"116_4/8/2021 2:36:45 PM","2021-07-18","Observation","Ship Staff","Ship Staff Insp.","M.E F.O Autobackwash filter  spindle leaking during system in M.G.O","E/R - Pipes/ valves & fittings","Eng. / Strg. Comp.","Equipment Related","10.32","Very High","","","Recieved new O-rings same replaced.No more leaks observed on M.G.O and H.F.O","2021-09-30","DOSP210111","Completed","2021-08-13","No","No","No","Internal",""]
[null,null,null,null,20620,"116_11/8/2021 5:34:22 PM","2021-07-20","Observation","Ship Staff","Ship Staff Insp.","Forward draft gauge observed showing +30 cm to +40 cm draft in the draft readouts in CCR. Actual drafts were compared during loading opeartion at Rastanura from Jetty side. All draft gauges were calibrated in Dubai DD in May 2021. Needs to re-calibrate / adjust the fwd draft gauge.","Hull & Tanks","Structural Condn. / WT integrity ","Equipment Related","11.2","Medium","","","Scanvent technician attended vessel on 29.09.2021. Calibration and troubleshooting done. However old MCU card from store was put in use as new MCU card not available with Techinician.","2021-10-20","","Completed","2021-09-30","No","No","No","Internal",""]
[null,null,null,null,20619,"116_4/8/2021 6:32:27 PM","2021-07-23","Observation","Ship Staff","Ship Staff Insp.","M.E exhaust gas pyrometers for unit2,3,4 defective.","E/R - Main Engine","Eng. / Strg. Comp.","Equipment Related,External Factors","10.32","Very High","","","PO spares received at GOLA on 17th Nov and defective exhaust gas pyrometers replaced with new ones.","2021-11-20","DOSP210148","Completed","2021-11-19","No","No","No","Internal",""]
[null,null,null,null,21402,"116_1/10/2021 7:41:04 PM","2021-08-12","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","M/E spare Aux. Blower motor– to check and confirm ready to use.","E/R - Main Engine","Eng. / Strg. Comp.","Equipment Related","10.32","Very High","","","Vessel carried out the megger test found >500Mohm.Each windings ohmic value checked found in good order.Rotation checked found no vibration and free.","2021-10-13","","Completed","2021-09-13","No","No","No","Internal"]
[null,null,null,null,21381,"116_1/10/2021 7:53:28 PM","2021-08-13","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","LT coolers valves are leaking. Spares supplied. To renew at earliest opportunity. Also to clean both coolers in-situ first and then plan to clean cooler by dismantling if required.","Miscellaneous","Eng. / Strg. Comp.","Equipment Related","10.32","Very High","","","Fwd LT cooler SW in/outlet valves are renewed and inline filter cleaned. Plate stack flushed by opening outlet valve and draining water from the inlet filter flange. Aft LT cooler cleaning carried out by shore technican.Aft LT cooler was found in clean condition and based on its condition, there is no need of opening fwd LT cooler immdetiately","2021-11-12","DOSP 210122","Completed","2021-10-27","No","No","No","Internal",""]
[null,null,null,null,21382,"116_1/10/2021 5:40:28 PM","2021-08-13","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Main deck and poop deck spot maintenance and de-rusting of pipe clamps. To completed on priority utilising the additional RT OS.","Deck - Pipe / Fittings","Structural Condn. / WT integrity ","External Factors","11.3","Medium","","","Piping / U-clamps de rusting has been completed. Main deck major portions are already derusted and some spot area will be continued as and where necessary until full coating of deck is taken up.","2021-11-13","","Completed","2021-11-13","No","No","No","Internal",""]
[null,null,null,null,21383,"116_1/10/2021 5:45:32 PM","2021-08-13","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Both Windlass cosmetic to improve. All greasing points to check for passages are clear and all moving parts are free.","Deck - Mooring Machinery","Mooring","Equipment Related","9.2","Very High","","","Both windlass are derusted and painted.Greasing carried out and all greasing points are marked and numbered.","2021-10-28","","Completed","2021-10-17","No","No","No","Internal",""]
[null,null,null,null,21384,"116_1/10/2021 6:04:24 PM","2021-08-13","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Mooring Winch brake lining- All lining to check carefully and plan to renew as required. To order spares.","Deck - Mooring Machinery","Mooring","Equipment Related","9.15","Medium","","","Completed \n\nRenewal of brake lining is completed for all mooring winches & tested for BRC as per manufacturer instructions (photos are attached in weekly work done)","2021-11-12","","Completed","2021-11-14","No","No","No","Internal",""]
[null,null,null,null,21385,"116_1/10/2021 6:52:50 PM","2021-08-13","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Electrical workshop found hot. To check how to improve with cool ait from Workshop A/C duct. Advise office with a practical and economic proposal.","Elect. Mach. & Equip.,Miscellaneous","Eng. / Strg. Comp.","Industry Issue","10.32","Very High","","","For now, additional ventillation dust is provided from ER Worshop cooler unit and temperatures are within acceptable level. In due course we would think out of having permanent alternate.","2021-11-12","","Completed","2021-11-10","No","No","No","Internal",""]
[null,null,null,null,21386,"116_1/10/2021 7:15:19 PM","2021-08-13","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","To start overhauling Electrical motors as many are due for 60 monthly overhaul. Target to complete as soon as possible. Update office monthly basis.","Elect. Mach. & Equip.","Eng. / Strg. Comp.","Equipment Related","10.37","Medium","","","We have finished now major part of the machinery motors overhaul. Now we shall continue as per PMS interval.","2021-12-13","","Completed","2021-11-30","No","No","No","Internal",""]
[null,null,null,null,21387,"116_1/10/2021 7:18:32 PM","2021-08-13","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Vessel has 1 each M/E and A/E LO purifier. To check whether A/E LO purifier can be used for M/E sump purification.","E/R - Purifier","Eng. / Strg. Comp.","Industry Issue","10.32","Very High","","","Since modification is not an option, its best decided that we have redundancy enough spares for the Main LO purifier.","2021-11-12","","Completed","2021-11-12","No","No","No","Internal",""]
[null,null,null,null,21388,"116_1/10/2021 7:20:23 PM","2021-08-13","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","To improve the engine room cosmetic. Use one of the RT OS from Deck for short period.","Miscellaneous","Eng. / Strg. Comp.","External Factors","10.32","Very High","","","ER General cosmetic condition ( mainly cleaning) all completed. painting will be taken up as necessary. RT OS was releived from ER and sent back on deck for normal upgrade .","2021-10-13","","Completed","2021-10-08","No","No","No","Internal",""]
[null,null,null,null,21389,"116_1/10/2021 7:23:09 PM","2021-08-13","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Spare parts inventory to complete on priority. Once physical inventory is completed- update in PMS.","Miscellaneous","Eng. / Strg. Comp.","External Factors","10.29","Medium","","","Spare parts physical inventories are recorded and updated in the system. Its on going process and for now its closed out.","2021-11-12","","Completed","2021-11-10","No","No","No","Internal",""]
[null,null,null,null,21403,"116_1/10/2021 5:42:40 PM","2021-08-13","Defect","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Windlass (port) Hydraulic cylinder shaft found broken. To be repaired/renewed at earliest.","Deck - Mooring Machinery","Mooring","Equipment Related","9.2","Very High","","","Received new windlass brake cylinder shaft at Mina saqr and renewed.","2021-09-13","","Completed","2021-08-27","No","No","No","Internal"]
[null,null,null,null,21404,"116_1/10/2021 6:09:52 PM","2021-08-13","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","BWTS: Maintain the practice of testing and sending the Operating parameters to makers bi-weekly. ","Cargo Mach.","Cargo / Ballast Systems","Inappropriate Procedure","6.21","High","","","Vessel is carrying out BWTS testing every 2 weeks and sending the feedback to the makers.","2021-09-13","","Completed","2021-08-18","No","No","No","Internal"]
[null,null,null,null,21405,"116_1/10/2021 7:26:13 PM","2021-08-13","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","M/E Spare Exhaust valves to check/test and confirm ready to use as all Exhaust valves are coming due for renewal/overhaul.","E/R - Main Engine","Eng. / Strg. Comp.","Equipment Related,External Factors","10.32","Very High","","","Vessel has inspected and checked both the Spare exhaust valves. Both are ready to use.","2021-09-28","","Completed","2021-09-30","No","No","No","Internal"]
[null,null,null,null,21406,"116_1/10/2021 7:52:02 PM","2021-08-13","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","A/E Air cooler drain lines should regularly inspect for running and standby engine to ensure lines are clear and to avoid water leakage inside cooler housing. To display a poster for watch keepers.","E/R - Air Comp.,Miscellaneous","Eng. / Strg. Comp.","Equipment Related","10.32","Very High","","","All 3 A.E cooler drain inspection carried out.Duty engineer/duty oiler has been informed for regular inspection of drains while A.E runnings during rounds.Poster has been posted near A.E drains.","2021-09-13","","Completed","2021-09-13","No","No","No","Internal"]
[null,null,null,null,21407,"116_1/10/2021 7:46:20 PM","2021-08-13","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Observed soot on poop deck and China passage. To investigate during next voyage to find reason and inform office.","Miscellaneous","Eng. / Strg. Comp.","Equipment Related","10.32","Very High","","","On investigation found soot coming from the IG atmosphere uptake.IG scrubber spray pipe found to be damaged same defect has been raised in DDRL.Poop deck and china passage area cleaning carried out.","2021-10-13","","Completed","2021-08-16","No","No","No","Internal"]
[null,null,null,null,21287,"116_16/9/2021 1:26:28 PM","2021-09-08","Defect","Ship Staff","Ship Staff Insp.","During discharging it was observed water carry over from the IG Blower. On investigation found IG scrubber spray pipe damage and shifted from the plastic welded collar due to which water spraying from one side on Demister.","Inert Gas","Eng. / Strg. Comp.","Equipment Related,External Factors","10.32","Very High","","","The cold repairs which were carried out are holding well and as there is no isse. on receipt of new spray pipe, it will be fitted. For now, we close out the defect.","2021-12-07","DOSP210149","Completed","2021-11-30","No","No","No","Internal",""]
[null,null,null,null,21288,"116_16/9/2021 1:20:27 PM","2021-09-16","Observation","Ship Staff","Ship Staff Insp.","Gauges for atmo condenser,A.E 2 H.T C.W ,M.E auto back wash filter,L.T cooler S.W inlet outlet,M.G.O transfer p/p,I.G scrubber inlet.","E/R - Pipes/ valves & fittings,Hull & Tanks","Eng. / Strg. Comp.","Equipment Related,External Factors","10.32","Very High","","","New gauges were received at Gola and fitted in place. Observations closed out.","2021-12-15","DOSP210157","Completed","2021-11-30","No","No","No","Internal",""]
[null,null,null,null,21390,"116_1/10/2021 7:28:30 PM","2021-09-19","Defect","Ship Staff","Ship Staff Insp.","Cargo tanks overfill alarm unit on port side midship mast is found to be defective.","Miscellaneous","Cargo / Ballast Systems","Equipment Related","8.14","Very High","","","New spare received at Gola on 17th Nov 2021. Same fitted and tested, working fine.","2021-12-19","DOSP210146","Completed","2021-11-23","No","No","No","Internal",""]
[null,null,null,null,21289,"116_22/9/2021 3:30:25 PM","2021-09-22","Defect","Ship Staff","Ship Staff Insp.","No.1(FWD) LT Cooler - inlet /outlet sea water valves are leaking and hence unable to isolate the cooler or clean inline filter","E/R - Pipes/ valves & fittings","Eng. / Strg. Comp.","Equipment Related","10.32","Very High","","","Valves renewed with new ones and cooler isolated and inline filter cleaned (it was extremely dirty). job closed out.","2021-11-22","DOSP 210122","Completed","2021-10-27","No","No","No","Internal",""]
[null,null,null,null,21392,"116_2/10/2021 3:45:40 PM","2021-09-29","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Pipe line clamps aft of midship spot maintenance required","Deck - Pipe / Fittings","General Appearance","External Factors","11.3","Medium","","","Derusting of pipe U-clamps completed.","2021-11-28","","Completed","2021-11-28","No","No","No","Internal",""]
[null,null,null,null,21393,"116_2/10/2021 3:48:10 PM","2021-09-29","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Winches and deck machinery number of grease pints to be numbered and total points to be marked on side","Deck - Mooring Machinery","General Appearance","External Factors","11.3","Medium","","","All mooring winches & windlass are marked with yellow colour and all grease points are marked with numbers.","2021-11-28","","Completed","2021-11-05","No","No","No","Internal",""]
[null,null,null,null,21394,"116_2/10/2021 3:51:04 PM","2021-09-29","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Galley provision stores not well arranged. Dry provision store UV insect killer to install.","Miscellaneous","MLC Related","Industry Issue","12.12","High","","","Galley provision stores was all cleaned up,inventories taken and arranged properly. Since having cleaned and maintained, there are hardly any insects in the dry provision stores. We shall raise RO for insect killer /control and on receipt, it will be installed.","2021-11-28","DOSP210190","Completed","2021-11-27","No","No","No","Internal",""]
[null,null,null,null,21395,"116_3/10/2021 9:12:29 AM","2021-09-29","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Traces of oil in control air at various points, investigate and check the auto drains on all the air bottles.","E/R - Air Comp.","Eng. / Strg. Comp.","Equipment Related","10.32","Very High","","","vessel has checked and found the oil was accumulated over a period of time and the said points. The auto drains of air bottles are checked and work well.Control air drier works well. As such job is closed out. Vessel will be overhauling # 2 MAC in first week Nov and replacing the piston rings for both LP /HP piston apart from other jobs (6000 hrs routine).","2021-10-30","","Completed","2021-10-27","No","No","No","Internal",""]
[null,null,null,null,21396,"116_3/10/2021 9:14:46 AM","2021-09-29","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Aft stack coupling of air drier leak, visible oil strains","Miscellaneous","Eng. / Strg. Comp.","Equipment Related","10.29","Medium","","","coupling leakage rectified by applying thread seal for the union coupling and tightened .job closed .","2021-10-30","","Completed","2021-10-11","No","No","No","Internal",""]
[null,null,null,null,21397,"116_3/10/2021 9:17:47 AM","2021-09-29","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Oil traces coming out of start solenoid block- internal leak.","Cargo Mach.","Cargo / Ballast Systems","Equipment Related","10.32","Very High","","","Leakage rectified - o-ring /gasket changed and tightened.","2021-10-30","","Completed","2021-10-25","No","No","No","Internal",""]
[null,null,null,null,21398,"116_3/10/2021 9:20:40 AM","2021-09-29","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","SW inlet line orifice plate to check and verify against the makers recommendations","Inert Gas","Eng. / Strg. Comp.","Equipment Related","10.32","Very High","","","Orifice plate was removed and inspected. All found normal, plate in good condition and the orifice dia is as per the original dimensions.","2021-10-29","","Completed","2021-10-13","No","No","No","Internal",""]
[null,null,null,null,21399,"116_3/10/2021 9:22:49 AM","2021-09-29","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Small dried puddle of dirt below Galley grease trap. Check leak on the line flanges.","E/R - Pipes/ valves & fittings","Eng. / Strg. Comp.","Equipment Related","10.32","Very High","","","Galley grease trap was isolated. Filter and internals cleaned. Cover fitted with new gaskets and there is no more leakage now.Job completed.","2021-10-10","","Completed","2021-10-13","No","No","No","Internal",""]
[null,null,null,null,21400,"116_2/10/2021 3:54:18 PM","2021-09-30","Observation","Owner / Marine / Tech. Suptd.","Ship Staff Insp.","Posters in alleyways, mess rooms to be aesthetically placed and unwanted posters to removed.","Miscellaneous","General Appearance","Human Error,Inappropriate Procedure","11.13","Low","","","All unwanted posters removed from various locations and necessary posters pasted on respective notice boards.","2021-10-30","","Completed","2021-10-25","No","No","No","Internal",""]
[null,null,null,null,21401,"116_2/10/2021 3:56:31 PM","2021-09-30","Observation","Owner / Marine / Tech. Suptd.","Ship Staff Insp.","Winch brake hyd oil tank to install local temp gauge","Deck - Mooring Machinery","Mooring","Equipment Related","9.14","Medium","","","Temperature gauge stuck to outside of tank.","2021-11-30","","Completed","2021-11-14","No","No","No","Internal",""]
[null,null,null,null,22403,"116_2/11/2021 4:57:50 AM","2021-10-08","Defect","Ship Staff","Ship Staff Insp.","#2 MAC - HP cylinder bottom part air leaking from fastner seating area as a smal portion has erroded.","E/R - Air Comp.","Eng. / Strg. Comp.","Equipment Related","10.32","Very High","","","PO spares were received. MAC 6000 hrs routine overhaul completed and at the time the HP cylinder bottom part was also replaced with new spare. Compressor has been tested and all is in good order.","2021-11-15","DOSP 210163","Completed","2021-11-05","No","No","No","Internal",""]
[null,null,null,null,22404,"116_2/11/2021 5:08:03 AM","2021-10-08","Defect","Ship Staff","Ship Staff Insp.","No.1 Steering gear found giving hydraulic lock alarm. On investigation found one of the proximity switches is defective resulting in the alarm.","Elect. Mach. & Equip.","Eng. / Strg. Comp.","Equipment Related","10.39","High","","","New spare proximity switch received onboard at Gola on 17th and defective switch was replaced with new one on 18th Nov. Test carried out and switch and hydraulic alarm working satisfactory.","2022-01-07","DOSP 215159","Completed","2021-11-18","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"]
["116","DHT OSPREY (03-01-2022)","116_1641254509560.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"]