{"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":59,"n_cols":28,"rows_kept":59,"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","30-Apr-2021",null,null,"Ship Name","CAPE BOSS (16-03-2021)"]
[]
[null,null,null,null,null,null,"VERSION : 2.0"]
[]
[]
[]
[null,null,null,null,"ID","UNIQUE ID","Date Recorded","Type of Deficiency","Observer code","Type of Inspection","Description of Deficiency","Equipment Categories","Area of Observation","Deficiency Cause","VIQ Ref Number","Risk Value of Obs","PSC Ref Number","PSC MOU ID","Action Taken or Required","Target Date","PO Ref No.","Status Code","Date Completed","Drydock","Info Sharing","Critical Item","Audit Type","Superintendent Remarks"]
[null,null,null,null,18229,"111_15/3/2021 10:13:11 PM","2021-04-30","Observation","Ship Staff","Ship Staff Insp.","Main sea water pumps found low dischare pressure, and suction line to be inspected","E/R - Pipes/ valves & fittings,E/R - Pumps","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","NO#1 main sea water  pump overhauled in singapore, the remaining jobs to be attended during docking","2021-08-01",null,"Deferred to D D",null,"Yes","No","No","Internal"]
[null,null,null,null,18233,"111_15/3/2021 9:55:27 PM","2021-03-15","Observation","Ship Staff","Ship Staff Insp.","steering gear rams leaking through seal","E/R - Aux. Mach.","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","To be attended during dry dock","2021-08-01",null,"Deferred to D D",null,"Yes","No","No","Internal"]
[null,null,null,null,18234,"111_15/3/2021 9:58:01 PM","2021-03-15","Observation","Ship Staff","Ship Staff Insp.","FWG main frame found badly corroded and heater plates deformation","E/R - Aux. Mach.","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","waiting spare","2021-06-01",null,"Waiting spare",null,"No","No","No","Internal"]
[null,null,null,null,18242,"111_15/3/2021 10:26:03 PM","2021-03-15","Observation","Ship Staff","Suptd. Insp.","AE NO.1 VLSFO leaking line valve to be renewed","E/R - Pipes/ valves & fittings","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","waiting spare","2021-06-01",null,"Waiting spare",null,"No","No","No","Internal"]
[null,null,null,null,18245,"111_16/3/2021 1:35:16 AM","2021-03-15","Observation","Ship Staff","Ship Staff Insp.","Provision crane badly corroded,power cable to be renewed","Deck - Machinery","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","To be overhauled in dry dock","2021-07-01",null,"Deferred to D D",null,"Yes","No","No","Internal"]
[null,null,null,null,18246,"111_16/3/2021 1:39:51 AM","2021-03-15","Observation","Ship Staff","Ship Staff Insp.","Forecastle port& starboard windlass handling area slightly leaking","Deck - Mooring Machinery","Mooring","Equipment Related","","","","","To be overhauled in dry dock","2021-07-01","","Not Started",null,"Yes","No","No","Internal"]
[null,null,null,null,18247,"111_16/3/2021 1:43:08 AM","2021-03-15","Observation","Ship Staff","Ship Staff Insp.","Forepeak tank hydraulic valve both leaking","Deck - Pipe / Fittings","Cargo / Ballast Systems","Equipment Related","","","","","To be overhauled in dry dock","2021-07-01","","Not Started",null,"Yes","No","No","Internal"]
[null,null,null,null,18248,"111_16/3/2021 1:50:06 AM","2021-03-15","Observation","Ship Staff","Ship Staff Insp.","Cargo hold bilge weel hydraulic valve no working","Deck - Pipe / Fittings","Cargo / Ballast Systems","Equipment Related","","","","","To be overhauled during docking","2021-07-01","","Not Started",null,"Yes","No","No","Internal"]
[null,null,null,null,18249,"111_16/3/2021 1:52:54 AM","2021-03-15","Observation","Ship Staff","Ship Staff Insp.","NO.1 port side and NO.5,7 starboardside locking cylinder leaking","Deck - Machinery","Cargo / Ballast Systems","Equipment Related","","","","","To be overhauled during docking","2021-07-01","","Not Started",null,"Yes","No","No","Internal"]
[null,null,null,null,18250,"111_16/3/2021 1:55:42 AM","2021-03-15","Observation","Ship Staff","Ship Staff Insp.","NO.1 TO 9 hatch cover handling block slightly leaking,part of hydraulic soft pipe leaking uncertainly","Deck - Machinery","Cargo / Ballast Systems","Equipment Related","","","","","To be attended during docking","2021-07-01","","Not Started",null,"Yes","No","No","Internal"]
[null,null,null,null,18251,"111_16/3/2021 2:00:17 AM","2021-03-15","Observation","Ship Staff","Ship Staff Insp.","Part of hatch cover wheels abrasion seriously lead difficulty to close it","Deck - Machinery","Cargo / Ballast Systems","Equipment Related","","","","","To be overhauled in dry docking","2021-07-01","","Not Started",null,"Yes","No","No","Internal"]
[null,null,null,null,18252,"111_16/3/2021 2:02:32 AM","2021-03-15","Observation","Ship Staff","Ship Staff Insp.","NO.6 cargo hold portside hydraulic jams leaking seriously","Deck - Machinery","Cargo / Ballast Systems","Equipment Related","","","","","To be overhauled in dry docking","2021-07-01","","Not Started",null,"Yes","No","No","Internal"]
[null,null,null,null,18253,"111_16/3/2021 2:12:39 AM","2021-03-15","Observation","Ship Staff","Ship Staff Insp.","Galley drain line & boat deck port side pipes choked","Accommodation","Structural Condn. / WT integrity ","Equipment Related","","","","","dreged in progress","2021-03-31","","In progress",null,"No","No","No","Internal"]
[null,null,null,null,18254,"111_16/3/2021 2:15:25 AM","2021-03-15","Observation","Ship Staff","Ship Staff Insp.","Ballast tank inside found badly corroded","Hull & Tanks","Cargo / Ballast Systems","Equipment Related","","","","","To be attended in dry docking","2021-07-01","","Not Started",null,"Yes","No","No","Internal"]
[null,null,null,null,18255,"111_16/3/2021 1:46:46 AM","2021-03-15","Observation","Ship Staff","Ship Staff Insp.","Port&starboard anchor chain easy to twist","Deck - Mooring Machinery","Mooring","Equipment Related","","","","","To be overhauled in dry dock","2021-07-01","","Not Started",null,"Yes","No","No","Internal"]
[null,null,null,null,18256,"111_16/3/2021 2:17:08 AM","2021-03-15","Observation","Ship Staff","Ship Staff Insp.","Ladders in all cargo hold found badly corroded","Hull & Tanks","Cargo / Ballast Systems","Equipment Related","","","","","To be overhauled in dry docking","2021-07-01","","Not Started",null,"Yes","No","No","Internal"]
[null,null,null,null,18257,"111_16/3/2021 2:20:08 AM","2021-03-15","Observation","Ship Staff","Ship Staff Insp.","Airpurge systerm & ballast,draft indication panel display malfunctioning","Deck - Pipe / Fittings","Cargo / Ballast Systems","Equipment Related","","","","","To be overhauled in dry docking","2021-07-01","","Not Started",null,"Yes","No","No","Internal"]
[null,null,null,null,18260,"111_16/3/2021 2:27:42 AM","2021-03-15","Observation","Ship Staff","Ship Staff Insp.","Starboard side accomodation ladder& port side gangway difficulty to recover in position","Accommodation","Structural Condn. / WT integrity ","Equipment Related","","","","","To be overhauled in dry docking","2021-07-01","","Not Started",null,"Yes","No","No","Internal"]
[null,null,null,null,18261,"111_16/3/2021 2:30:45 AM","2021-03-15","Observation","Ship Staff","Ship Staff Insp.","Too much cockroach found in galley/cabin,etc,accomodation areas","Accommodation","General Appearance","Equipment Related","","","","","To be attended during docking","2021-07-01","","Not Started",null,"Yes","No","No","Internal"]
[null,null,null,null,18262,"111_16/3/2021 2:08:38 AM","2021-03-15","Observation","Ship Staff","Ship Staff Insp.","NO.4-8 hatch coaming& hatch cover badly corroded,","Deck - Machinery","Cargo / Ballast Systems","Equipment Related","","","","","Derusted & painted in progress now,but need long time","2021-05-01","","In progress",null,"No","No","No","Internal"]
[null,null,null,null,18243,"111_15/3/2021 10:29:41 PM","2021-04-30","Observation","Ship Staff","Ship Staff Insp.","The gland packing type Boiler water circulating pumps found worn out easily, casuing steam enters into bearing housing and damage the bearings. Boiler control panel CPU to be renewed","E/R - Boiler","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Boiler water circulating pumps overhauled, boiler control panel CPU still waiting for the spare","2021-06-01",null,"In progress",null,"No","No","No","Internal"]
[null,null,null,null,18241,"111_15/3/2021 10:24:02 PM","2021-04-30","Observation","Ship Staff","Ship Staff Insp.","ER overhead crane wire found bad condition, onboard spare wire not fit for ER overhead crane use.STBD bunker davit magnetic brakes parted.","Elect. Mach. & Equip.","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","To be attended during DD and waiting for the spare.","2021-08-01",null,"Deferred to D D",null,"Yes","No","No","Internal"]
[null,null,null,null,18240,"111_15/3/2021 10:20:29 PM","2021-04-30","Observation","Ship Staff","Ship Staff Insp.","Main air comp. running hours due","E/R - Air Comp.","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable"," Routine maintenance  carried out and still waiting for the spares.","2021-06-01",null,"Waiting spare",null,"No","No","No","Internal"]
[null,null,null,null,18239,"111_15/3/2021 10:18:41 PM","2021-04-30","Observation","Owner / Marine / Tech. Suptd.","Ship Staff Insp.","Found main cooling sea water line, ballast line and fire &GS  line a lot of valves not holding. Ballast suction line doublers were applied","E/R - Pipes/ valves & fittings","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","To be attended during docking","2021-08-01",null,"Deferred to D D",null,"Yes","No","No","Internal"]
[null,null,null,null,18238,"111_15/3/2021 10:10:29 PM","2021-04-30","Observation","Ship Staff","Ship Staff Insp.","Main cooling sea water pipe coated rubber found aged and broken, the thickness of the pipes to be checked","E/R - Pipes/ valves & fittings","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","To be attended during docking","2021-08-01",null,"Deferred to D D",null,"Yes","No","No","Internal"]
[null,null,null,null,18237,"111_15/3/2021 10:06:24 PM","2021-04-30","Critical Equipment","Ship Staff","Ship Staff Insp.","Both life boat batteries found exhausted , one set of battery only can start the life boat engine one time.","LSA / FFA","Safety / LSA / FFA","Equipment Related",null,null,"Not Applicable","Not Applicable","waiting spare","2021-06-01",null,"Waiting spare",null,"No","No","No","Internal"]
[null,null,null,null,18235,"111_15/3/2021 10:01:37 PM","2021-04-30","Observation","Ship Staff","Ship Staff Insp.","sewage treatment plant division plates badly corroded","E/R - Aux. Mach.","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Temporary repair was done, the STP to be attended duing docking","2021-08-01",null,"Deferred to D D",null,"Yes","No","No","Internal"]
[null,null,null,null,18236,"111_15/3/2021 10:04:06 PM","2021-04-30","Breakdown","Ship Staff","Ship Staff Insp.","FWD ICCP found no DCA output current","Elect. Mach. & Equip.","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Troubleshooting in progress.","2021-05-15",null,"In progress",null,"No","No","No","Internal"]
[null,null,null,null,18232,"111_15/3/2021 9:52:18 PM","2021-04-30","Observation","Ship Staff","Ship Staff Insp.","AE NO.2&3 running hours for major overhaul due and observed high LO consumption , last owner cheating on running hours. AE NO.3 RPM pick up sensor not working. AE NO.2 T/C running hours due","E/R - Aux. Engine","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","AE#2 T/C overhauled, AE#3 RPM pick up sensor waiting for the spare. AE#2&3 major overhaul to be carried out during DD.","2021-08-01",null,"Deferred to D D",null,"Yes","No","No","Internal"]
[null,null,null,null,18231,"111_15/3/2021 9:47:31 PM","2021-04-30","Observation","Ship Staff","Ship Staff Insp.","ME intermediate shaft beaing found leaking. ME shaft grounding found not working.","E/R - Main Engine","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Faulty ME shaft grounding rectified and all satisfactroy.  Leaking ME intermeditate shaft bearing to be overhauled during DD.","2021-08-01",null,"Deferred to D D",null,"Yes","No","No","Internal"]
[null,null,null,null,18230,"111_15/3/2021 9:44:12 PM","2021-04-30","Observation","Ship Staff","Ship Staff Insp.","ME piston/exhaust/fuel pumps and valves/starting air valves and T/C running hours over due, observed last owner cheating on the running hours.","E/R - Main Engine","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","NO 3,4,5 &6 units fuel injectors renewed with spare, unit #5 exhaust valve renewed with spare.Remaining jobs to be carried out during DD .","2021-08-01",null,"Deferred to D D",null,"Yes","No","No","Internal"]
[null,null,null,null,null,"111_30/4/2021 10:33:15 PM","2021-04-30","Breakdown","Ship Staff","Ship Staff Insp.","Ballast/bilge strip eductor bust due be badly corrosion","E/R - Pipes/ valves & fittings","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Temporary repair was done and still wating for the spare.","2021-06-01",null,"Waiting spare",null,"No",null,null,"Internal"]
[null,null,null,null,null,"111_30/4/2021 10:36:44 PM","2021-04-30","Observation","Ship Staff","Ship Staff Insp.","PORT side bilge well high level switch not working sometime.","E/R - Pipes/ valves & fittings","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Troubleshooting carried out and waiting for spare.","2021-06-01",null,"In progress",null,"No",null,null,"Internal"]
[null,null,null,null,null,"111_30/4/2021 10:41:00 PM","2021-04-30","Breakdown,Observation","Ship Staff","Ship Staff Insp.","AE MGO return line valves found not holding","E/R - Aux. Engine,E/R - Pipes/ valves & fittings","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","valves unable to be repaired by lapping, AE MGO return lines temporary blanked, and waiting for spares","2021-06-01",null,"Waiting spare",null,"No",null,null,"Internal"]
[null,null,null,null,null,"111_30/4/2021 10:45:06 PM","2021-04-30","Observation","Ship Staff","Ship Staff Insp.","NO #1 LT cooler SW discharge vavle not holding, SW suction strainer become very weak and unable to be taken out.LT cooler plates to be cleaned.","E/R - Pipes/ valves & fittings","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","To be attended during DD.","2021-08-01",null,"Deferred to D D",null,"Yes",null,null,"Internal"]
[null,null,null,null,null,"111_30/4/2021 10:47:33 PM","2021-04-30","Breakdown","Ship Staff","Ship Staff Insp.","AE # 1 LOP LO feed pump gear worn out and PT 4 presure sensor not working","E/R - Purifier","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","waiting for spares","2021-06-01",null,"Waiting spare",null,"No",null,null,"Internal"]
[null,null,null,null,null,"111_1/5/2021 12:18:22 AM","2021-04-30","Observation","Ship Staff","Ship Staff Insp.","Windlass brake line need to be renewal","Deck - Mooring Machinery","Mooring","Equipment Related",null,null,"Not Applicable","Not Applicable","To be attended during docking","2021-07-01",null,"Not Started",null,"Yes",null,null,"Internal"]
[null,null,null,null,null,"111_1/5/2021 12:24:26 AM","2021-04-30","Observation","Ship Staff","Ship Staff Insp.","Mooring winch brake line need to be renewal& test","Deck - Mooring Machinery","Mooring","Equipment Related",null,null,"Not Applicable","Not Applicable","To be attended during docking","2021-07-01",null,"Deferred to D D",null,"Yes",null,null,"Internal"]
[null,null,null,null,null,"111_1/5/2021 12:28:06 AM","2021-04-30","Observation","Ship Staff","Ship Staff Insp.","TST Manhole need to be renewal from NO.1 to NO.5 port& starboard side","Deck - Pipe / Fittings","Cargo / Ballast Systems","Equipment Related",null,null,"Not Applicable","Not Applicable","To be attended during dry docking","2021-07-01",null,"Deferred to D D",null,"Yes",null,null,"Internal"]
[null,null,null,null,null,"111_1/5/2021 12:43:11 AM","2021-04-30","Observation","Ship Staff","Ship Staff Insp.","Fire line behind NO.2 cargo hold about 20 meters& paltform after each cargo hold to be renewal","Deck - Pipe / Fittings","Structural Condn. / WT integrity ","Equipment Related",null,null,"Not Applicable","Not Applicable","To be attended during dry docking","2021-07-01",null,"Deferred to D D",null,"Yes",null,null,"Internal"]
[null,null,null,null,null,"111_1/5/2021 12:46:14 AM","2021-04-30","Observation","Ship Staff","Ship Staff Insp.","Air pipe line& fresh water line on main deck need to be renewal including valves due to badly rusted","Deck - Pipe / Fittings","Structural Condn. / WT integrity ","Equipment Related",null,null,"Not Applicable","Not Applicable","To be attended during dry docking","2021-07-01",null,"Deferred to D D",null,"Yes",null,null,"Internal"]
[null,null,null,null,null,"111_1/5/2021 12:49:44 AM","2021-04-30","Critical Equipment","Ship Staff","Ship Staff Insp.","Replace & load testing of life boat wire due to will be expired","Critical Equip.","Safety / LSA / FFA","Equipment Related",null,null,"Not Applicable","Not Applicable","To be attended during docking","2021-07-01",null,"Deferred to D D",null,"Yes",null,null,"Internal"]

{"sheet":"Completed","index":1,"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","30-Apr-2021",null,null,"Ship Name","CAPE BOSS (16-03-2021)"]
[]
[null,null,null,null,null,null,"VERSION : 2.0"]
[]
[]
[]
[null,null,null,null,"ID","UNIQUE ID","Date Recorded","Type of Deficiency","Observer code","Type of Inspection","Description of Deficiency","Equipment Categories","Area of Observation","Deficiency Cause","VIQ Ref Number","Risk Value of Obs","PSC Ref Number","PSC MOU ID","Action Taken or Required","Target Date","PO Ref No.","Status Code","Date Completed","Drydock","Info Sharing","Critical Item","Audit Type","Superintendent Remarks"]
[null,null,null,null,null,"111_15/3/2021 10:32:03 PM","2021-04-01","Observation","Ship Staff","Ship Staff Insp.","Elevator annual inspection going to due 21 MAR 2021","Elect. Mach. & Equip.","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","completed.","2021-04-20",null,"Completed","2021-04-15","No",null,null,"Internal"]
[null,null,null,null,null,"111_16/3/2021 2:25:25 AM","2021-03-15","Observation","Ship Staff","Ship Staff Insp.","NO.5 TST 5S over board valve leaking","Deck - Pipe / Fittings","Cargo / Ballast Systems","Equipment Related",null,null,"Not Applicable","Not Applicable","Already put gasket inside anti leaking","2021-04-05",null,"Completed","2021-03-28","No",null,null,"Internal"]
[null,null,null,null,null,"111_16/3/2021 2:22:46 AM","2021-03-15","Observation","Ship Staff","Ship Staff Insp.","Dashboard of rudder angle,proeller shat tachometer,telegaph repeater on port& starboard side no light","Navigation - Others","Navigation","Equipment Related",null,null,"Not Applicable","Not Applicable","To be attended during dry docking","2021-07-01",null,"Completed","2021-03-22","Yes",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]
["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":1,"n_cols":3,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["VIQ_ref_no","Risk Value of observation","ID"]

{"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"]
["111","CAPE BOSS (16-03-2021)","111_1619771780286.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"]