{"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":21,"n_cols":28,"rows_kept":21,"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","28-Aug-2021",null,null,"Ship Name","SCARLETT (28-08-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,18366,"112_19/3/2021 1:49:48 AM","2021-02-21","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Some oil pressure gauge of hatch cover open control system lost and damaged, order the gauges","Deck - Machinery","General Appearance","External Factors",null,null,"Not Applicable","Not Applicable"," The gauges have been receipt, but the connect were corroded serously, need raise requisition for connect again.","2021-06-20","SCAR215115","In progress",null,"No","No","No","Internal","spare will supply in convenient port"]
[null,null,null,null,18379,"112_20/3/2021 3:50:59 PM","2021-02-21","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","LT,HT & Lo temp control vv actuator to be procured & supplied to vessel ,presently the controller & working in manual mode","Elect. Mach. & Equip.","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Actuators have been renewed, but they still working in manual mode, couldn't automatic control, need maker service for pcb setting.","2021-06-30",null,"In progress",null,"No","No","No","Internal","will supply in convenient port"]
[null,null,null,null,18383,"112_20/3/2021 3:59:13 PM","2021-02-21","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","GE & ME Viscotherm sensor to be procured & replaced","Elect. Mach. & Equip.","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Sensors have been renewed, but it display the viscocity of F.O different with F.O analysis report, need maker guide.","2021-06-30","SCAR215076    215077","In progress",null,"No","No","No","Internal","will supply in convenient port"]
[null,null,null,null,19532,"112_6/5/2021 8:39:29 AM","2021-04-30","Observation","Ship Staff","Ship Staff Insp.","ME & BOILER F.O. flowmeters are not calibrated, G/E F.O. flowmeter is not working","E/R - Aux. Mach.","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Order the G/E F.O. flowmeter and renewal once received, and calibrate M/E & BOILER F.O. flowmeters at next DD","2022-02-28","SCAR215078","Deferred to D D",null,"No","No","No","Internal","spare will supply in convenient port"]

{"sheet":"Completed","index":1,"n_rows":58,"n_cols":28,"rows_kept":58,"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","28-Aug-2021",null,null,"Ship Name","SCARLETT (28-08-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,20608,"112_31/7/2021 6:16:24 PM","2021-02-21","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","The accommodation ladder and combination ladder wire rope need renewal not exceed 30 months as company's policy, order wire rope & carry out renewal once received","Accommodation,Deck - Machinery","General Appearance","External Factors","","","","","the accommodation ladder and pilot combination ladders wire repes all renewed.","2021-06-20","","Completed","2021-07-15","No","No","No","Internal"]
[null,null,null,null,18361,"112_19/3/2021 1:29:57 AM","2021-02-21","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","The protecting plate of provision crane hook damaged, fabricate new plate onboard","Deck - Machinery","General Appearance","Equipment Related","","","","","Fabricate new plate onboard and renewl.","2021-03-30","","Completed","2021-03-20","No","No","No","Internal"]
[null,null,null,null,18362,"112_19/3/2021 1:37:41 AM","2021-02-21","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Some oil trap corroded, order  as required","Deck - Pipe / Fittings","General Appearance","External Factors","","","","","derust the oil trap","2021-04-10","","Completed","2021-03-27","No","No","No","Internal"]
[null,null,null,null,18363,"112_19/3/2021 1:40:28 AM","2021-02-21","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Accommodation rust partly, Plan derusting of area which can be accessible","Accommodation","General Appearance","External Factors","","","","","Derusted and painted","2021-04-20","","Completed","2021-04-19","No","No","No","Internal"]
[null,null,null,null,18365,"112_20/3/2021 3:32:36 PM","2021-02-21","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Fresh water production is low ,need to adjust the feed rate to increase the capacity.","E/R - Aux. Mach.","Eng. / Strg. Comp.","Equipment Related","","","","","Adjusted the heating water feed rate to increase the capacity. At the end of adjusting, the product is about 16ton /day maxmum","2021-03-25","","Completed","2021-03-25","No","No","No","Internal"]
[null,null,null,null,18367,"112_19/3/2021 1:21:23 AM","2021-02-21","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Fill mooring winch gear oil tank up to half level ,some gauge glass not able to see, order new glass & plan for renewal once received","Deck - Mooring Machinery","Mooring","Equipment Related","","","","","Fill mooring winch gear oil tank up to half level ,renewal new glass .","2021-06-20","","Completed","2021-03-18","No","No","No","Internal"]
[null,null,null,null,18369,"112_19/3/2021 2:02:42 AM","2021-02-21","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","The accommodation ladder and combination ladder wire rope need renewal not exceed 30 months as company's policy, order wire rope & carry out renewal once received","Accommodation,Deck - Machinery","General Appearance","External Factors","","","","","new wires received on board, renewal conducted on July 15,2021 all wire ropes in good condition ","2021-06-20","SCAR210015","Completed","2021-07-15","No","No","No","Internal","will supply in convenient port"]
[null,null,null,null,18370,"112_19/3/2021 2:09:44 AM","2021-02-21","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","hatch cover for emergency operation pump, try out the pump & make sure crew is aware of procedures for using in emergency, wire of pump should be put in each hatch plug to make sure the pump can be started & cover all the hatches (if required)","Deck - Machinery","General Appearance","Knowledge Based","","","","","Tye out the emergency operation pump ,training crews how to used the emergency pump.","2021-06-20","","Completed","2021-05-11","No","No","No","Internal","please provide RO number for tracing and supply"]
[null,null,null,null,18372,"112_2021/3/17 19:04:18","2021-02-21","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","The accommodation floors are dirty, same to be cleaned with hard chemical & stripper","Accommodation","MLC Related","External Factors","","","","","clean The accommodation floors ","2021-02-26","","Completed","2021-02-26","No","No","No","Internal"]
[null,null,null,null,18373,"112_2021/3/17 19:08:42","2021-02-21","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Bridge wing portside, the lower position switch of bottom control box cover does not rotate. Same to be freed","Navigation - Others","Navigation","External Factors","","","","","repair and grease the switch of bottom control box cover","2021-03-20","","Completed","2021-03-18","No","No","No","Internal"]
[null,null,null,null,18374,"112_19/3/2021 5:18:28 AM","2021-02-21","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Portside rudder angle indicator cover not clean, not able to read carefully ,cover to remove and clean.","Cargo Mach.,Navigation - Others","Navigation","External Factors","","","","","CLEAN Portside rudder angle indicator cover ","2021-02-26","","Completed","2021-02-26","No","No","No","Internal"]
[null,null,null,null,18375,"112_19/3/2021 1:04:18 AM","2021-02-21","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","The door closer of watertight door at E deck starboard side door is broken ,order & replace with new. Always keep min 3 closure doors as spare all the times","Accommodation","Structural Condn. / WT integrity ","External Factors","","","","","Replace with new","2021-03-11","","Completed","2021-03-11","No","No","No","Internal"]
[null,null,null,null,18376,"112_19/3/2021 1:00:04 AM","2021-02-21","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Whistle pipe drain valve on compass deck not rotate ,to make it free ","Navigation - Others","Navigation","External Factors","","","","","Make it free","2021-02-26","","Completed","2021-02-26","No","No","No","Internal"]
[null,null,null,null,18378,"112_20/3/2021 5:32:01 PM","2021-02-21","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Various places pressure gauges are blurred & damaged ,same to identify, ordered & renewed","Miscellaneous","Eng. / Strg. Comp.","Equipment Related","","","","","Renew damaged pressure gauges","2021-03-30","","Completed","2021-03-30","No","No","No","Internal"]
[null,null,null,null,18380,"112_19/3/2021 1:09:24 AM","2021-02-21","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","All lubricating nipple need to marked with yellow color","Deck - Machinery,Deck - Mooring Machinery","General Appearance","Equipment Related","","","","","Marked All lubricating with yellow color","2021-03-08","","Completed","2021-03-08","No","No","No","Internal"]
[null,null,null,null,18381,"112_19/3/2021 1:13:35 AM","2021-02-21","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Remove all the tool in Suez crew room to bosun store, get  the mattress back in position","Accommodation","Structural Condn. / WT integrity ","External Factors","","","","","Remove all the tool in Suez crew room to bosun store, get  the mattress back in position?clean","2021-02-26","","Completed","2021-02-26","No","No","No","Internal"]
[null,null,null,null,18382,"112_19/3/2021 1:18:32 AM","2021-02-21","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","To perform maintenance of  the greasing nipple of mooring winches ,Colour code yellow to avoid missing it out","Deck - Mooring Machinery","Mooring","Equipment Related","","","","","Perform maintenance of  the greasing nipple of mooring winches ?Remarked the nipple with yellow.","2021-03-10","","Completed","2021-03-10","No","No","No","Internal"]
[null,null,null,null,18384,"112_19/3/2021 1:25:58 AM","2021-02-21","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Watertight door of acetylene store room corroded, plan to derust & Paint","Miscellaneous","Structural Condn. / WT integrity ","External Factors","","","","","Derust & paint.","2021-03-18","","Completed","2021-03-18","No","No","No","Internal"]
[null,null,null,null,18385,"112_19/3/2021 1:34:43 AM","2021-02-21","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Some oil trap plugs are not in proper size and not fixed ,order correct size as required","Deck - Pipe / Fittings","General Appearance","External Factors","","","","","Change proper size plugs and fixed","2021-03-21","","Completed","2021-03-21","No","No","No","Internal"]
[null,null,null,null,18386,"112_19/3/2021 1:43:33 AM","2021-02-21","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","To check hose crane limit switch if working normal or not","Deck - Machinery","General Appearance","Equipment Related","","","","","Check hose crane limit ,in good order.","2021-03-18","","Completed","2021-03-18","No","No","No","Internal"]
[null,null,null,null,18387,"112_19/3/2021 1:55:30 AM","2021-02-21","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Rescue boat accumulators to try out at angle specified in manual without motor starting, also need to make sure accumulator is filled to required pressure at all times.","Critical Equip.","Safety / LSA / FFA","Equipment Related","","","","","Repaired the accumulator and filled pressure.","2021-03-17","","Completed","2021-03-17","No","No","No","Internal"]
[null,null,null,null,18388,"112_19/3/2021 2:15:29 AM","2021-02-21","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","The list of helicopter operation is not consistent to actual existing devices check ","LSA / FFA","General Appearance","External Factors","","","","","Supplement the short devices of the list of helicopter operation","2021-02-26","","Completed","2021-02-26","No","No","No","Internal"]
[null,null,null,null,18389,"112_19/3/2021 2:54:57 AM","2021-02-21","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","The co2 release box for forecastle paint room corroded, to derust & paint","LSA / FFA","Safety / LSA / FFA","External Factors","","","","","derust & paint the co2 release box for forecastle paint room ","2021-03-18","","Completed","2021-03-18","No","No","No","Internal"]
[null,null,null,null,18390,"112_19/3/2021 2:59:19 AM","2021-02-21","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","The p ‘side windlass gear box cover is heavily corroded","Deck - Machinery","General Appearance","External Factors","","","","","derusted and repaired the p ‘side windlass gear box cover ","2021-03-12","","Completed","2021-03-10","No","No","No","Internal"]
[null,null,null,null,18391,"112_19/3/2021 3:04:42 AM","2021-02-21","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","There is't O-ring for oil fill hole on top of windlass which can lead to water ingress, check the actual arrangement from drawing & fabricate accordingly to avoid ingress of water","Deck - Machinery","General Appearance","Equipment Related,External Factors","","","","","repaired the oil fill hole cover","2021-03-10","","Completed","2021-03-10","No","No","No","Internal"]
[null,null,null,null,18392,"112_19/3/2021 3:07:55 AM","2021-02-21","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","The scupper in upper deck WC room is obstructed, same to cleared.","Accommodation","Structural Condn. / WT integrity ","External Factors","","","","","Clear the scupper","2021-03-15","","Completed","2021-03-14","No","No","No","Internal"]
[null,null,null,null,18393,"112_19/3/2021 3:19:17 AM","2021-02-21","Breakdown","Owner / Marine / Tech. Suptd.","Suptd. Insp."," old broken chairs to be scrapped off & replace with new supply.","Accommodation","General Appearance","External Factors","","","","","replace with new supply.","2021-02-23","","Completed","2021-02-23","No","No","No","Internal"]
[null,null,null,null,18394,"112_19/3/2021 3:22:06 AM","2021-02-21","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","repaired upholstery(sofas) needs to be fitted back in place ","Accommodation","General Appearance","External Factors","","","","","Fitted the sofas back in place","2021-02-23","","Completed","2021-02-23","No","No","No","Internal"]
[null,null,null,null,18395,"112_19/3/2021 3:27:17 AM","2021-02-21","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Cargo hold ventilation Louvers to check ,if any rusted to take out & carry out  maintenance","Deck - Machinery","General Appearance","External Factors","","","","","Check and rusted the Cargo hold ventilation Louvers ","2021-03-18","","Completed","2021-03-18","No","No","No","Internal"]
[null,null,null,null,18396,"112_20/3/2021 3:46:33 PM","2021-02-21","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Sludge & Bilge pp greasing oil pot empty, oil need to be refilled.","E/R - Pumps","Eng. / Strg. Comp.","Human Error","","","","","refill oil to grease pots","2021-03-30","","Completed","2021-03-02","No","No","No","Internal"]
[null,null,null,null,18397,"112_20/3/2021 4:09:16 PM","2021-02-21","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","All 3 DGs LO Lube oil renewal to carry out as part of 2000 hours routines","E/R - Aux. Engine","Eng. / Strg. Comp.","Equipment Related","","","","","Renewed no.1 &2 DG sump tank L.O. on 08/03/2021  09/03/2021, the L.O. in NO.3 DG running hour no yet reach 2000hours","2021-03-10","","Completed","2021-03-09","No","No","No","Internal"]
[null,null,null,null,18398,"112_20/3/2021 5:28:41 PM","2021-02-21","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","line inside Acetylene room leaking ,source to find & rectify","E/R - Pipes/ valves & fittings","Eng. / Strg. Comp.","Equipment Related","","","","","Retified the leaking part","2021-02-28","","Completed","2021-02-25","No","No","No","Internal"]
[null,null,null,null,18399,"112_19/3/2021 3:16:36 AM","2021-02-21","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","All posters such as company's policy must be posted on the green board in alley way & Engine control room.","Accommodation","General Appearance","External Factors","","","","","posted All posters such as company's policy  on the green board in alley way & Engine control room.","2021-02-26","","Completed","2021-02-26","No","No","No","Internal"]
[null,null,null,null,18400,"112_19/3/2021 1:59:32 AM","2021-02-21","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","The oil level of s'side combination ladder can not read,check & replenish oil","Deck - Machinery","General Appearance","External Factors","","","","","Replenished oil to s'side combination ladder ","2021-04-10","","Completed","2021-03-23","No","No","No","Internal"]
[null,null,null,null,18478,"112_31/3/2021 8:43:44 PM","2021-03-30","Observation","Ship Staff","Ship Staff Insp.","NO.10 D.B.WBTK (wash water tank) air vent head fly net cover seriously corroded, need to fabricated new cover to change it","Deck - Pipe / Fittings","General Appearance","Equipment Related","","","","","Fabricated new cover and changed ","2021-04-03","","Completed","2021-04-06","No","No","No","Internal"]
[null,null,null,null,18477,"112_31/3/2021 9:05:53 PM","2021-03-31","Observation","Ship Staff","Ship Staff Insp.","Boiler cascade enter some oil, investigated found the A/E booster unit no.1 F.O. heater leaking.","E/R - Pipes/ valves & fittings","Eng. / Strg. Comp.","Equipment Related","","","","","Removed the oil and cleaned inspection tank of boiler cascade tank,  dismantled A/E no.1 F.O. Heater and pressure tested found leaking tube 1pc  and plugged,after install tested good","2021-04-03","","Completed","2021-04-02","No","No","No","Internal","Kindly let us know when you are going to open AE #1 FO heater to locate leaking tube."]
[null,null,null,null,18930,"112_28/4/2021 9:39:32 AM","2021-04-10","Defect,Observation","Ship Staff","Ship Staff Insp.","L.T water expension tank level drop down, suspected the boiler atmoshpere condenser tube leaking ","E/R - Boiler","Eng. / Strg. Comp.","Equipment Related","","","","","Open up both side cover of atmoshpere condenser, cleaned and carried pressure tested, found 3 tubes leaking, plugged them by newly made brass plugs. total 16pcs tubes hae been plugged","2021-04-22","","Completed","2021-04-22","No","No","No","Internal"]
[null,null,null,null,18931,"112_28/4/2021 9:47:35 AM","2021-04-15","Observation","Ship Staff","Ship Staff Insp."," F.W.G. heating water inlet valve and by pass valve leaking water from  vavle spindle seal.","E/R - Pipes/ valves & fittings","Eng. / Strg. Comp.","Equipment Related","","","","","Renewed both valves with new spare valves. checked the old valves found the rubber damaged","2021-04-23","","Completed","2021-04-23","No","No","No","Internal"]
[null,null,null,null,18932,"112_28/4/2021 9:52:01 AM","2021-04-15","Observation","Ship Staff","Ship Staff Insp.","NO.2 central cooler backflush sea water inlet valve stuck, could not open","E/R - Pipes/ valves & fittings","Eng. / Strg. Comp.","Equipment Related","","","","","Renewed the valve, check the old butterfly valve inside rubber is deformed and damaged.","2021-04-25","","Completed","2021-04-25","No","No","No","Internal"]
[null,null,null,null,18933,"112_28/4/2021 10:07:30 AM","2021-04-27","Observation","Ship Staff","Ship Staff Insp.","No.1 generator control panel voltage is not stable.","Elect. Mach. & Equip.","Eng. / Strg. Comp.","Equipment Related","","","","","Renewed the AVR for No.1 generator, tested found good.","2021-04-27","","Completed","2021-04-27","No","No","No","Internal"]
[null,null,null,null,19533,"112_6/5/2021 8:50:53 AM","2021-04-30","Observation","Ship Staff","Ship Staff Insp.","All steam traps in E/R and deck did not overhaul","E/R - Pipes/ valves & fittings","Eng. / Strg. Comp.","Equipment Related","","","","","Checked and Overhauled E/R and deck steam traps.","2021-05-10","","Completed","2021-05-12","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":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"]
["112","SCARLETT (28-08-2021)","112_1630136927504.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"]