{"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":1,"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":35,"n_cols":28,"rows_kept":35,"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","15-Oct-2023",null,null,"Ship Name","DHT APPALOOSA (03-10-2023)"]
[]
[null,null,null,null,null,null,"VERSION : 2.0"]
[]
[]
[]
[null,null,null,"ID","SHIPSIDE UNIQUEID","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,31962,44720,"0_Thu Sep 07 2023 12:28:04 GMT+0800","2023-09-01T23:59:35","Defect","Ship Staff","Ship Staff Insp.","Auxiliary engine #3 attached cooling water pump has minor leakage from the mechanical seal","E/R - Aux. Engine","Eng. / Strg. Comp.","Equipment Related","10.32","Very High","","","Pump to be overhauled and mechanical seal to be renewed","2023-11-30T23:59:35","","Not Started",null,"No","No","No","Internal","- Plan the job before month end."]
[null,null,null,31970,54498,"0_Thu Sep 07 2023 12:25:43 GMT+0800","2023-09-01T23:59:35","Defect","Ship Staff","Ship Staff Insp.","Aft peak tank ballast overboard line valve's ,141V, indicator defective","Cargo Mach.","Cargo / Ballast Systems","Equipment Related","8.80","Medium","","","Valve indicator need to be replaced","2023-11-30T23:59:35","DAPP230047","In progress",null,"No","No","No","Internal","- Noted R.O. raised ,will arrange for supply at the earliest."]
[null,null,null,31971,50154,"134_Thu Sep 07 2023 15:01:27 GMT+0800","2023-09-01T23:59:35","Defect","Ship Staff","Ship Staff Insp.","Auxiliary boiler local control panel HMI screen is not responding to touch, accessing with external mouse also difficult","E/R - Boiler","Eng. / Strg. Comp.","Equipment Related","10.32","Very High","","","Need to replace the HMI screen with new one","2023-11-30T23:59:35","DAPP230089","In progress",null,"No","No","No","Internal","Noted , R.O. raised in place will arrange for supply."]
[null,null,null,31973,59178,"134_Sun Sep 10 2023 11:54:50 GMT+0800","2023-09-01T23:59:35","Defect","Ship Staff","Ship Staff Insp.","Power supply unit for the auxiliary engine SCR control cabinet is defective","E/R - Aux. Mach.","Eng. / Strg. Comp.","Equipment Related","10.32","Very High","","","Need to replace defective power supply unit with new one.","2023-11-30T23:59:35","DAPP230059","In progress",null,"No","No","No","Internal","- Noted  R.O. raised will plan to supply ."]
[null,null,null,31977,45217,"134_Thu Sep 07 2023 15:19:33 GMT+0800","2023-09-01T23:59:35","Defect","Ship Staff","Ship Staff Insp.","Hydraulic pumps for the aft system are not fitted with coupling pads for the motor coupling","Deck - Machinery","Eng. / Strg. Comp.","Equipment Related","10.32","Very High","","","Coupling pads to be fitted.","2023-11-30T23:59:35","DAPP230055","In progress",null,"No","No","No","Internal","Noted R.O. Raised - will supply,"]
[null,null,null,31965,60541,"0_Thu Sep 07 2023 11:30:28 GMT+0800","2023-09-02T23:59:35","Defect","Ship Staff","Ship Staff Insp.","High sea chest PE lining has cracked and damaged.","E/R - Pipes/ valves & fittings","Eng. / Strg. Comp.","Equipment Related","10.32","Very High","","","Damaged PE lining to be removed, thoroughly clean the surface and apply Ecoshield paint 3 coat.","2023-12-01T23:59:35","","Not Started",null,"No","No","No","Internal","- Noted , Plan the job at the earliest."]
[null,null,null,31966,99320,"0_Thu Sep 07 2023 11:33:27 GMT+0800","2023-09-02T23:59:35","Defect","Ship Staff","Ship Staff Insp.","Exhaust gas economizer safety valves are not provided with easing gear.","E/R - Boiler","Eng. / Strg. Comp.","Equipment Related","10.32","Very High","","","Safety valves are to be fitted with easing gear","2023-12-01T23:59:35","","Not Started",null,"No","No","No","Internal","- Pls check the feasibility of Fabricating the same."]
[null,null,null,31967,51438,"0_Thu Sep 07 2023 11:41:00 GMT+0800","2023-09-02T23:59:35","Defect","Ship Staff","Ship Staff Insp.","Auxiliary boiler main feed pump's recirculation line has temporary repair.","E/R - Pipes/ valves & fittings","Eng. / Strg. Comp.","Equipment Related","10.32","Very High","","","New recirculation line need to fabricate and fit in place","2023-12-01T23:59:35","","Not Started",null,"No","No","No","Internal","Plan the job this week trust vessel has material for the same."]
[null,null,null,31968,63028,"0_Thu Sep 07 2023 12:03:16 GMT+0800","2023-09-02T23:59:35","Defect","Ship Staff","Ship Staff Insp.","BWTS injection flowmeter FIT-1131 fails frequently due to sea water seepage into the back board","Cargo Mach.","Cargo / Ballast Systems","Equipment Related","6.21","High","","","The cause of the repetitive failures to be identified and rectified, new flow meter to be fitted once the root cause of the defect rectified","2023-12-01T23:59:35","","In progress",null,"No","No","No","Internal","Trust communication with maker in progress."]
[null,null,null,31976,35893,"134_Thu Sep 07 2023 14:57:52 GMT+0800","2023-09-02T23:59:35","Defect","Ship Staff","Ship Staff Insp.","Main engine lubricating oil pipe supporting bracket near the hydraulic pump area has cracked from the welding seam.","E/R - Pipes/ valves & fittings","Eng. / Strg. Comp.","Equipment Related","10.32","Very High","","","Need to remove the cracked portion and weld new support bracket","2023-12-01T23:59:35","","Not Started",null,"No","No","No","Internal","- Plan the job and inform office for concurrence."]
[null,null,null,31980,35001,"134_Thu Sep 07 2023 12:31:10 GMT+0800","2023-09-02T23:59:35","Defect","Ship Staff","Ship Staff Insp.","Gas analyzer for exhaust gas cleaning system has issue with calibration. After trouble shooting maker suggested to replace the chopper motor","E/R - Aux. Mach.","Eng. / Strg. Comp.","Equipment Related","10.11","Medium","","","Service technician need to attend the vessel and replace the chopper motor","2023-12-01T23:59:35","","In progress",null,"No","No","No","Internal","- Noted , communication with Maker in progress, I.R. unit replacement is planned in suitable port."]
[null,null,null,31963,11141,"134_Thu Sep 07 2023 11:20:39 GMT+0800","2023-09-06T23:59:35","Defect","Ship Staff","Ship Staff Insp.","Auxiliary engine 1 Unit 4 and 7 exhaust gas pyrometer opaque. Auxiliary engine 2 unit 4 and 7 exhaust gas pyrometer defective","E/R - Aux. Engine","Eng. / Strg. Comp.","Equipment Related","10.32","Very High","","","Need to be replaced with spare once received","2023-12-05T23:59:35","DAPP230105","In progress",null,"No","No","No","Internal","noted . will supply at the earliest."]
[null,null,null,31964,15941,"134_Thu Sep 07 2023 11:25:56 GMT+0800","2023-09-06T23:59:35","Breakdown","Ship Staff","Ship Staff Insp.","Auxiliary engine lube oil purifier not operational because of damaged cup spring, awaiting spare part.","E/R - Purifier","Eng. / Strg. Comp.","Equipment Related","10.32","Very High","","","Replace the damaged cup spring with new one","2023-12-05T23:59:35","DAPP230032","In progress",null,"No","No","No","Internal","noted will arrange for the spare."]
[null,null,null,31978,61537,"134_Wed Sep 20 2023 15:24:09 GMT+0800","2023-09-16T23:59:35","Defect","Ship Staff","Ship Staff Insp.","Stern tube lube oil flow meter for the seal line shows lesser flow than the required flow of 120 liters per hour even after fully opening the line valves, suspecting the flow meter defective","E/R - Aux. Mach.","Eng. / Strg. Comp.","Equipment Related","10.32","Very High","","","The flow meter need to be replaced","2023-12-15T23:59:35","","Not Started",null,"No","No","No","Internal","Pls check if there are any line filter or inbuilt strainer that needs to be cleaned."]
[null,null,null,31979,23963,"134_Sat Sep 16 2023 12:52:31 GMT+0800","2023-09-16T23:59:35","Defect","Ship Staff","Ship Staff Insp.","LT cooling water system temperature control valve and main engine lube oil cooler temperature control valve have heavy leakage of air","E/R - Aux. Mach.","Eng. / Strg. Comp.","Equipment Related","10.32","Very High","","","Controller to be overhauled or replaced","2023-12-15T23:59:35","DAPP230101","In progress",null,"No","No","No","Internal","- Pls check if there are any repair kit onboard, and check if it can be  rectified onboard."]
[null,null,null,null,55374,"134_Thu Sep 28 2023 14:02:15 GMT+0800","2023-09-18T08:00:00","Defect","Ship Staff","Ship Staff Insp.","Auxiliary boiler reflex gouge glass light not working","E/R - Boiler","Eng. / Strg. Comp.","Equipment Related","10.32","Very High","","","Need to replace the lights, vessel doesn't have the spare and requisition created. Once spare received will replace.","2023-12-17T08:00:00","DAPP230116","In progress",null,"No","No","No","Internal"]
[null,null,null,null,94045,"134_Wed Oct 04 2023 10:37:46 GMT+0800","2023-10-03T08:00:00","Defect","Ship Staff","Ship Staff Insp.","EGCS sea water Feed Pump A non return valve not holding causing the pump to rotate in reverse direction.","E/R - Pipes/ valves & fittings","Eng. / Strg. Comp.","Equipment Related","10.34","High","","","Feed pump A kept in forced preference to start first, spare on order. Once the spare non return valve received need to replace","2024-01-02T08:00:00","DAPP230115","In progress",null,"No","No","No","Internal"]
[null,null,null,null,28435,"134_Sun Oct 15 2023 13:05:15 GMT+0800","2023-10-15T08:00:00","Defect","Ship Staff","Ship Staff Insp.","1. Rectifier B power feeder bolt sea water leakage.\n2.Rectifier B imbalanced current and hunting.\n3. Rectifier C actual out put current could not be increased above 240 amps where set value was 450 amps.\n4.Water ingress to level switch PCB and level switch faulty during operation.","Deck - Machinery","Eng. / Strg. Comp.","Equipment Related","10.32","Very High","","","1. Rectifier B power feeder bolt to be removed, inspected and fitted back with new gasket.\n2. Vessel to inspect all electrolyser module thoroughly after chemical cleaning  and test run of the system.\n3.Level switch to be renewed after receiving spares. Vessel to raise RO for the same. \n4.Vessel requires makers attendance for thorough health check up for BWTS System. Flowmeter water ingress issues to be sorted out.","2023-11-15T08:00:00","","In progress",null,"No","No","No","Internal"]

{"sheet":"Completed","index":1,"n_rows":35,"n_cols":28,"rows_kept":35,"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","15-Oct-2023",null,null,"Ship Name","DHT APPALOOSA (03-10-2023)"]
[]
[null,null,null,null,null,null,"VERSION : 2.0"]
[]
[]
[]
[null,null,null,"ID","SHIPSIDE UNIQUEID","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,31991,37483,"134_Thu Sep 28 2023 00:44:31 GMT+0800","2023-08-19T23:59:35","Observation","SIRE / CDI Insp.","OM Insp. (Eg. SIRE / CDI etc.)","Insulation resistance of 1.5 megohms was observed on the AC 220V\nfeeder panel in the emergency generator room.","Elect. Mach. & Equip.","Eng. / Strg. Comp.","Equipment Related","10.38","Medium","","","Planned work on the emergency lights on the sunken deck was\ncompleted on 19 Aug 2023 and the Insulation resistance level on the 220V system was checked\nand found to be at infinity.","2023-09-30T23:59:35","","Completed","2023-08-23T23:59:35","No","No","No","External"]
[null,null,null,31992,58238,"0_Thu Sep 28 2023 00:46:58 GMT+0800","2023-08-19T23:59:35","Observation","SIRE / CDI Insp.","OM Insp. (Eg. SIRE / CDI etc.)","The helicopter landing area at the ship's port side forward was not\nmarked with the ship name.","Miscellaneous","Safety / LSA / FFA","Equipment Related","11.3","Medium","","","Ship name has been marked at the helicopter landing area as\nrequired by ICS Helicopter guide.","2023-09-30T23:59:35","","Completed","2023-08-23T23:59:35","No","No","No","External"]
[null,null,null,31975,41483,"134_Sat Sep 09 2023 13:50:51 GMT+0800","2023-09-01T23:59:35","Defect","Ship Staff","Ship Staff Insp.","Sea water flow to the deck seal pump found to be inadequate","E/R - Pipes/ valves & fittings","Eng. / Strg. Comp.","Equipment Related","10.32","Very High","","","All pipe sections in the suction side cleared of mud and shells.  Sea water flow is found to be satisfactory and pumps developing sufficient pressure.","2023-09-30T23:59:35","","Completed","2023-09-05T23:59:35","No","No","No","Internal"]
[null,null,null,31982,53645,"134_Mon Sep 11 2023 10:24:08 GMT+0800","2023-09-01T23:59:35","Defect","Ship Staff","Ship Staff Insp.","Windlass brake cylinder has oil leakage from the seal ","Deck - Mooring Machinery,Deck - Machinery","Mooring","Equipment Related","9.20","Medium","","","Seal rings renewed","2023-09-30T23:59:35","","Completed","2023-09-11T23:59:35","No","No","No","Internal"]
[null,null,null,31983,43291,"0_Sun Sep 10 2023 11:57:10 GMT+0800","2023-09-01T23:59:35","Defect","Ship Staff","Ship Staff Insp.","EGCS absorber section feed water inlet pressure gouge root valve leaking from the union","E/R - Pipes/ valves & fittings","Eng. / Strg. Comp.","Equipment Related","10.32","Very High","","","Removed the flange and taken to the workshop fabricated and fitted  ","2023-09-30T23:59:35","","Completed","2023-09-11T23:59:35","No","No","No","Internal"]
[null,null,null,31984,49201,"134_Sat Sep 09 2023 13:59:00 GMT+0800","2023-09-01T23:59:35","Defect","Ship Staff","Ship Staff Insp.","Oil leaking from ULSFO storage tank temperature gouge pocket ","E/R - Pipes/ valves & fittings","Eng. / Strg. Comp.","Equipment Related","10.32","Very High","","","Temperature pocket to be removed and gasket to renewed.","2023-09-30T23:59:35","","Completed","2023-09-11T23:59:35","No","No","No","Internal"]
[null,null,null,31985,59468,"134_Sat Sep 09 2023 13:48:12 GMT+0800","2023-09-01T23:59:35","Defect","Ship Staff","Ship Staff Insp.","Auxiliary cooling sea water pump tripping while starting, checked and found the pump hard to turn by hand","E/R - Pumps","Eng. / Strg. Comp.","Equipment Related","10.32","Very High","","","Motor overhauled, pump removed from place and found the impeller jammed. Taken to workshop dismantled, cleaned all parts and fitted back. Pump tried out and put into use.  ","2023-09-30T23:59:35","","Completed","2023-09-10T23:59:35","No","No","No","Internal"]
[null,null,null,31987,19158,"134_Sat Sep 09 2023 17:06:42 GMT+0800","2023-09-01T23:59:35","Defect","Ship Staff","Ship Staff Insp.","Auxiliary engine booster pump#2 is leaking from the mechanical seal","E/R - Pumps","Eng. / Strg. Comp.","Equipment Related","10.32","Very High","","","Pump dismantled and mechanical seal renewed","2023-11-30T23:59:35","","Completed","2023-09-13T23:59:35","No","No","No","Internal"]
[null,null,null,31988,32686,"134_Sat Sep 09 2023 14:42:37 GMT+0800","2023-09-01T23:59:35","Defect","Ship Staff","Ship Staff Insp.","HCU drain box chamber high level sensor not detecting oil while filled up with oil","E/R - Main Engine","Eng. / Strg. Comp.","Equipment Related","10.32","Very High","","","Checked the sensor and adjusted the sensitivity to detect oil and tested by filling oil in the chamber, found working satisfactory","2023-11-30T23:59:35","","Completed","2023-09-13T23:59:35","No","No","No","Internal"]
[null,null,null,null,47613,"134_Thu Sep 14 2023 18:43:19 GMT+0800","2023-09-01T08:00:00","Defect","Ship Staff","Ship Staff Insp.","Main engine fuel oil circulating pump #1 leaking from the mechanical seal","E/R - Pumps","Eng. / Strg. Comp.","Equipment Related","10.32","Very High","","","Pump dismantled and mechanical seal renewed","2023-10-15T08:00:00","","Completed","2023-09-14T08:00:00","No","No","No","Internal"]
[null,null,null,31990,34536,"0_Thu Sep 07 2023 12:22:13 GMT+0800","2023-09-01T23:59:35","Defect","Ship Staff","Ship Staff Insp.","Auxiliary engine #3 SCR system's urea handling unit flow meter display unit is defective ","E/R - Aux. Mach.","Eng. / Strg. Comp.","Equipment Related","10.32","Very High","","","Display unit replaced with spare, couldn't check as the power supply unit for the system is defective  ","2023-11-30T23:59:35","","Completed",null,"No","No","No","Internal"]
[null,null,null,31993,94396,"134_Sat Sep 09 2023 14:03:01 GMT+0800","2023-09-01T23:59:35","Defect","Ship Staff","Ship Staff Insp.","Auxiliary boiler feed water salinity cell is defective and showing high ppm even with distilled water","E/R - Boiler","Eng. / Strg. Comp.","Equipment Related","10.32","Very High","","","Feed water salinity cell replaced with new one.","2023-11-30T23:59:35","DAPP230089","Completed","2023-09-16T23:59:35","No","No","No","Internal"]
[null,null,null,31994,11533,"0_Thu Sep 07 2023 12:07:55 GMT+0800","2023-09-01T23:59:35","Defect","Ship Staff","Ship Staff Insp.","Air handling unit #1 mixing air temperature gouge is defective","Accommodation","General Appearance","Equipment Related","11.16","Low","","","Replaced with new one","2023-12-01T23:59:35","","Completed","2023-09-25T23:59:35","No","No","No","Internal"]
[null,null,null,31986,49735,"0_Thu Sep 07 2023 11:47:25 GMT+0800","2023-09-02T23:59:35","Defect","Ship Staff","Ship Staff Insp.","Main engine fuel oil circulating pump  #2 leaking from mechanical seal","E/R - Pumps","Eng. / Strg. Comp.","Equipment Related","10.32","Very High","","","Pump overhauled and mechanical seal renewed. ","2023-12-01T23:59:35","DAPP230082","Completed","2023-09-12T23:59:35","No","No","No","Internal"]
[null,null,null,null,88768,"134_Thu Sep 07 2023 12:19:13 GMT+0800","2023-09-01T08:00:00","Defect","Ship Staff","Ship Staff Insp.","Crew recreation room exhaust blower defective and portable blower fitted in place.","Accommodation","General Appearance","Equipment Related","11.16","Low","","","Portable blower  removed and new blower  fitted in place, working satisfactory.","2023-12-01T08:00:00","","Completed","2023-10-04T08:00:00","No","No","No","Internal","Noted spare blower onboard , Pls plan the job before port arrival."]
[null,null,null,null,17465,"134_Sat Sep 09 2023 13:54:20 GMT+0800","2023-09-01T08:00:00","Defect","Ship Staff","Ship Staff Insp.","Emergency diesel generator engine's fuel oil storage tank has a leakage from the inlet flange connected to the tank","Critical Equip.","Eng. / Strg. Comp.","Equipment Related","10.32","Very High","","","Tank need drained and gasket renewed. Filled up the tank and checked for leakages, found all in order.","2023-10-31T08:00:00","","Completed","2023-10-04T08:00:00","No","No","No","Internal","- Noted gasket to be renewed Pls plan the job and inform office for concurrence."]
[null,null,null,null,39990,"0_Wed Oct 04 2023 10:39:25 GMT+0800","2023-10-04T08:00:00","Defect","Ship Staff","Ship Staff Insp.","EGCS Sea water Feed pump A mechanical seal leaking","E/R - Pumps","Eng. / Strg. Comp.","Equipment Related","10.32","Very High","","","Pump overhauled, mechanical seal and bearings renewed. Tried out found all in good order.","2023-10-31T08:00:00","","Completed","2023-10-04T08:00:00","No","No","No","Internal"]
[null,null,null,null,20861,"0_Thu Sep 07 2023 11:37:55 GMT+0800","2023-09-03T08:00:00","Defect","Ship Staff","Ship Staff Insp.","Fresh water generator feed water line has temporary repair","E/R - Pipes/ valves & fittings","Eng. / Strg. Comp.","Equipment Related","10.32","Very High","","","New feed water line fabricated and fitted.","2023-12-02T08:00:00","DAPP230046","Completed","2023-10-07T08:00:00","No","No","No","Internal","- Plan the job at the earliest."]

{"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":4,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["Ship_ID","Ship_Name","FILE_NAME","Export_Date"]
["134","DHT APPALOOSA (03-10-2023)","134_1696319813542.xlsm","2023-10-15 17:10:94"]

{"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"]