{"text_format":"1","workbook":"xlsx","n_sheets":20,"sheets":["Mainsheet","Completed","Calc","Areaofobs","Vessel_type","Deficiency_type","VIQrefno","Equipment_list","PSC_MOU","Inspection_type","Deficiency_Cause","Observer_code","Status_code","PSC_ref_no","Risk_value_of_obs","Year","Month","Date_","Sheet1","Ship_information"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":0,"defined_names":12,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Mainsheet","index":0,"n_rows":34,"n_cols":28,"rows_kept":34,"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","09-Nov-2019",null,null,"Ship Name","VIKING MERLIN"]
[]
[]
[]
[]
[]
[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,"2019-09-11T22:32:01","2019-07-28","Breakdown","Ship Staff","Ship Staff Insp.","Main LCD Monitor ECR display high resolution","Elect. Mach. & Equip.","Communication","Equipment Related",null,null,"Not Applicable","Not Applicable","Informed concerned supt.","2019-12-31",null,"In progress",null,"No",null,null,"Internal"]
[null,null,null,null,null,"2019-09-11T22:51:08","2019-07-28","Breakdown","Ship Staff","Ship Staff Insp.","Counter timer meter for FWG not working","Aux. Mach.","Eng. / Strg. Comp.","Equipment Related","VIQ_ref_no VRLV190170",null,"Not Applicable","Not Applicable","RO raised","2019-12-31",null,"Waiting spare",null,"No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-11T14:32:24","2019-10-04","Deficiency","Ship Staff","Ship Staff Insp.","Damaged solenoid valve for daily bilge priming","Aux. Engine","Eng. / Strg. Comp.","Equipment Related","VRLN190240",null,"Not Applicable","Not Applicable","Officed already informed","2019-12-31","VRLN190240","Waiting spare",null,"No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-11T14:35:30","2019-10-07","Deficiency","Ship Staff","Ship Staff Insp.","Erroneousflowmeter  reading","Main Engine ","Eng. / Strg. Comp.","Equipment Related","VRLN190233",null,"Not Applicable","Not Applicable","FO consumption adjusted base on daily average sounding.","2019-12-31","VRLN190233","Waiting spare",null,"No",null,null,"Internal"]
[null,null,null,null,null,"2019-11-10T14:43:09","2019-10-07","Deficiency","Ship Staff","Ship Staff Insp.","Low insulated Electric range Hot plate","Elect. Mach. & Equip.","Eng. / Strg. Comp.","Equipment Related","VRKN190231",null,"Not Applicable","Not Applicable","Switch off breaker and advice galley department  not to use until the arrival of new spare.","2019-12-31","VRLN190231","Waiting spare",null,"No",null,null,"Internal"]
[null,null,null,null,null,"2019-11-10T14:46:17","2019-10-29","Deficiency","Ship Staff","Ship Staff Insp.","Slight FO leak of the Fuel injector holder unit nos. 1, 2 & 7.","Main Engine ","Eng. / Strg. Comp.","Equipment Related","VRLN190201",null,"Not Applicable","Not Applicable","Overhauled using old o-ring but the leakage still persist at very minimal level ","2019-12-31","VRLN190201","Waiting spare",null,"No",null,null,"Internal"]
[null,null,null,null,null,"16/11/2019 10:02:28 AM","2019-11-16","Breakdown","Ship Staff","Ship Staff Insp.","CENTRAL FRESH WATER COOLER NO.1 INLET THERMOMETER GAUGE DEFECTIVE","Aux. Mach.","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Temperature monitored using laser gun thermometer.","2019-12-31","VRLN190247","Waiting spare",null,"No",null,null,"Internal"]
[null,null,null,null,null,"16/11/2019 10:04:46 AM","2019-11-16","Breakdown","Ship Staff","Ship Staff Insp.","CENTRAL FRESH WATER COOLER NO.2 OUTLET THERMOMETER GAUGE DEFECTIVE","Aux. Mach.","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Temperature monitored using laser gun thermometer","2019-12-31","VRLN190247","Waiting spare",null,"No",null,null,"Internal"]
[null,null,null,null,null,"26/11/2019 8:47:23 AM","2019-11-25","Breakdown","Ship Staff","Ship Staff Insp.","ME starting valve, 5/2 way directional valve pos. no. 27 has an abnormal purging of air at the exhaust port of the said item.","Main Engine ","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","inspect  5/2 way directional v/v but apparently no spares for replacement of the oring. Concerned supt.informed regarding the problem.","2019-12-31","VRLN190253","Waiting spare",null,"No",null,null,"Internal"]
[null,null,null,null,null,"27/11/2019 11:42:58 AM","2019-11-27","Deficiency","Ship Staff","Ship Staff Insp.","Steam/water leakage of Boiler feed water valve mounting.","Boiler","General Appearance","Equipment Related",null,null,"Not Applicable","Not Applicable","No spare availble onboard. Tech supt was informed regarding the leaking boiler v/v mounting. Steam leakage is minimal ","2019-12-31","VRLN190254","Waiting spare",null,"No",null,null,"Internal"]
[null,null,null,null,null,"2019-11-29T10:01:15","2019-11-29","Observation","Ship Staff","Ship Staff Insp.","OBSERVED THAT THE ANTI FOULING ANODE AND CATHODE WAS ALMOST WORN OUT, REPLACEMENT WAS NEEDED","Miscellaneous","Eng. / Strg. Comp.","Equipment Related","VRLN190257",null,"Not Applicable","Not Applicable","RAISED REQUISITION","2019-12-31",null,"Waiting spare",null,"No",null,null,"Internal"]
[null,null,null,null,null,"2019-11-29T10:08:06","2019-11-27","Breakdown","Ship Staff","Ship Staff Insp.","Ships WIFI router was energized but apparently no data.  ","Miscellaneous","Communication","Equipment Related",null,null,"Not Applicable","Not Applicable","made report and already inform office.","2019-12-31",null,"Not Started",null,"No",null,null,"Internal"]
[null,null,null,null,null,"2019-11-29T16:45:52","2019-11-27","Breakdown","Ship Staff","Ship Staff Insp.","Crew recreatoin computer defective. Operating system cannot load.","Miscellaneous","Communication","Equipment Related",null,null,"Not Applicable","Not Applicable","Already informed office","2019-12-31",null,"Not Started",null,"No",null,null,"Internal"]
[null,null,null,null,null,"2019-12-04T17:45:10","2019-12-04","Breakdown","Ship Staff","Ship Staff Insp.","Leaking HP FO flexible Pipe of AE no.1","Aux. Engine","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Replaced with fabricated HP FO pipe onboard","2019-12-31","VRLN190258","Waiting spare",null,"No",null,null,"Internal"]
[null,null,null,null,null,"2019-12-15T01:25:34","2019-12-12","Breakdown","Ship Staff","Ship Staff Insp.","Defective S-Band Radar display core unit.","Nav & comm. equip.","Navigation","Equipment Related",null,null,"Not Applicable","Not Applicable","Checked PCB Board and report submitted to office","2019-12-31",null,"Not Started",null,"No",null,null,"Internal"]
[null,null,null,null,null,"2019-12-15T01:33:54","2019-12-12","Observation","Ship Staff","Ship Staff Insp.","Worn out/damage rollers for slack wire device of crane 1 and 2","Deck Mach.","Cargo / Ballast Systems","Equipment Related",null,null,"Not Applicable","Not Applicable","Raised reqiusition","2019-12-31","VRLN190262","Waiting spare",null,"No",null,null,"Internal"]
[null,null,null,null,null,"2019-12-15T10:12:38","2019-12-12","Breakdown,Critical Equipment","Ship Staff","Ship Staff Insp.","Crane no.1 Hydraulic hose burst,leading to oil leak. ","Cargo Mach.","Cargo / Ballast Systems","Equipment Related",null,null,"Not Applicable","Not Applicable","Ships staff, Temporary patch the hole using fabricated fitted clamp to stop the leak. PO made awaiting for delivery.","2019-12-31","VRLN195043","Waiting spare",null,"No",null,null,"Internal"]

{"sheet":"Completed","index":1,"n_rows":82,"n_cols":28,"rows_kept":82,"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","9-10-2019",null,null,"Ship Name","VIKING MERLIN"]
[]
[]
[]
[]
[]
[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,"2019-11-10T14:20:08","2019-10-08","Deficiency","Ship Staff","Ship Staff Insp.","BWT actuator end cap cover broken","Cargo Mach.","Cargo / Ballast Systems","Equipment Related","VRLN190178",null,"Not Applicable","Not Applicable","RO raised - VRLN190178","2019-11-30","VRLN190178","Completed","2019-09-11","No",null,null,"Internal"]
[null,null,null,null,null,"2019-11-10T10:56:48","2019-10-10","Breakdown","Ship Staff","Ship Staff Insp.","Damaged flow control panel air line","Aux. Mach.","Eng. / Strg. Comp.","Equipment Related","VIQ_ref_no VRLN190232",null,"Not Applicable","Not Applicable","RO raised","2019-10-31",null,"Completed","2019-10-31","No",null,null,"Internal"]
[null,null,null,null,null,"2019-11-10T11:26:58","2019-11-01","Breakdown","Ship Staff","Ship Staff Insp.","MAGNETIC CONTACTOR FOR CENTRAL COOLING FRESH WATER PUMP","Elect. Mach. & Equip.","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","RAISED R.O","2019-02-28","VRLN190019","Completed","2019-01-15","No",null,null,"Internal"]
[null,null,null,null,null,"2019-11-10T10:42:50","2019-01-13","Breakdown","Ship Staff","Ship Staff Insp.","OWS SUCTION VALVE","Elect. Mach. & Equip.","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","RAISED RQUISITION","2019-02-13","VRLN190016","Completed","2019-04-02","No",null,null,"Internal"]
[null,null,null,null,null,"2019-11-10T10:30:06","2019-01-01","Breakdown","Ship Staff","Ship Staff Insp.","LOCAL TEMPERATURE INDICATOR","Aux. Engine","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","RAISED REQUISITION","2019-02-01","VRLN190013","Completed","2019-03-25","No",null,null,"Internal"]
[null,null,null,null,null,"2019-11-10T10:38:25","2019-01-13","Breakdown","Ship Staff","Ship Staff Insp.","DECK CRANE NO.1 LOAD CELL","Cargo Mach.","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","SPARE HAS RECEIVE AND TO BE INSTALLED IN DUE TIME","2019-02-13",null,"Completed","2019-01-30","No",null,null,"Internal"]
[null,null,null,null,null,"2019-11-10T10:35:15","2019-01-01","Breakdown","Ship Staff","Ship Staff Insp.","BOILER DOSSING PUMP","Boiler","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","RAISED REQUISITION","2019-08-02","VRLN190012","Completed","2019-03-28","No",null,null,"Internal"]
[null,null,null,null,null,"2019-11-10T11:29:35","2019-01-21","Breakdown","Ship Staff","Ship Staff Insp.","PLC MODULE FOR FRESH WATER LEVEL SENSOR (P.S AND SB.)","Elect. Mach. & Equip.","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","RAISED R.O","2019-03-31",190029,"Completed","2019-05-27","No",null,null,"Internal"]
[null,null,null,null,null,"2019-11-10T11:23:46","2019-01-24","Breakdown","Ship Staff","Ship Staff Insp.","BOILER FLOW METER NOT WORKING DUE TO BATTERY FAILURE","Boiler","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","RASED REQUITION","2019-03-31","VRLN190027","Completed","2019-04-02","No",null,null,"Internal"]
[null,null,null,null,null,"2019-11-12T09:38:13","2019-02-13","Breakdown","Ship Staff","Suptd. Insp.","Ballast water treatment system no.2 UV lamp burnt out","Elect. Mach. & Equip.","Cargo / Ballast Systems","Equipment Related",null,null,"Not Applicable","Not Applicable","RAISED R.O","2019-03-03","VRLN190049","Completed","2019-04-14","No",null,null,"Internal"]
[null,null,null,null,null,"2019-11-12T09:47:48","2019-03-22","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","BOTH FIRE & GS FIRE PUMP PRIMING AND BALLAST PUMP CLUTCH LINING WAS NOT TOUCHING THE PUMP LINING DURING STOP CONDITION. SAME TO BE ADJUSTED","Critical Equip.","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","OVERHAUL PRIMING PUMP AND ADJUST THE CLUTCH LINING ","2019-03-25",null,"Completed","2019-03-25","No",null,null,"Internal"]
[null,null,null,null,null,"2019-11-12T09:51:53","2019-03-22","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","CALORIFIER IS PRESENTLY RUNNING ON HEATER MODE, SAME TO BE CHANGED TO STEAM MODE & STOP HEATER IN ORDER TO AVOID FAILURE DUE TO CONTINOUS USE.","Elect. Mach. & Equip.","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","ELECTRIC HEATER IN AUTO MODE AND STEAM VALVE WAS OPEN","2019-03-25",null,"Completed","2019-03-25","No",null,null,"Internal"]
[null,null,null,null,null,"2019-11-12T09:57:46","2019-03-22","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","ICCP TO BE SWITCH OFF IN PORT AREAS. NOTICED TO BE POST IN ECR AS WELL NEAR ICCP PANEL","Elect. Mach. & Equip.","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","POSTER ARE POSTED NEAR ON THE ECR DOOR AS WELL IN THE ICCP SYSTEM PANEL ","2019-03-25",null,"Completed","2019-03-25","No",null,null,"Internal"]
[null,null,null,null,null,"2019-11-12T10:04:48","2019-03-22","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","IN CHEMICAL LOCKER ALKALIS AND AIDS ARE NOT SPEARATELY KEPT & MARKED, SAME TO BE CARRIED OUT","Miscellaneous","General Appearance","Inappropriate Procedure",null,null,"Not Applicable","Not Applicable","SEPARATE KEPT THE ALKALIS AND ACIDS AND MARKED","2019-03-25",null,"Completed","2019-03-25","No",null,null,"Internal"]
[null,null,null,null,null,"2019-11-12T10:11:46","2019-03-22","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","NO. 1 DG FUEL OIL INLET TEMP GAUGE FAULTY, NEEDS REPLACEMENT.","Aux. Mach.","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","RENEW GAUGE WITH SPARE","2019-03-25",null,"Completed","2019-03-25","No",null,null,"Internal"]
[null,null,null,null,null,"2019-11-12T10:15:11","2019-03-22","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","BOILER HOT WELL TEMP. ONLY 39 DEG. C WHICH WAS TOO LOW, OPEN ATMOSPHERIC CONDENSER BY PASS V/V TO INCREASE TEMP UP TO 80-85 DEG.","Boiler","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","OPEN STEAM TRACING FOR CASCADE TANK NOW 85 DEGREES C TEMP","2019-03-25",null,"Completed","2019-03-25","No",null,null,"Internal"]
[null,null,null,null,null,"2019-11-12T10:17:29","2019-03-22","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","NO.1 FEED PUMP SUCTION PRESSURE GAUGE FAULTY, NEED TO REPLACED WITH NEW ","Aux. Mach.","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","RENEW PRESSURE GAUGE","2019-03-25",null,"Completed","2019-03-25","No",null,null,"Internal"]
[null,null,null,null,null,"2019-11-12T10:21:21","2019-03-22","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","ME FUEL OIL FUEL V/V LOCKING NUTS ARE NOT TIGHTHTENED EVENLY WITH TORQUE SPANNER, SAME TO BE LOOSENED & RETITGHTEND AS PER MAKERS","Main Engine ","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","CHECKED AND RETIGTH AS PER MAKERS SPECIFICATION","2019-03-25",null,"Completed","2019-03-25","No",null,null,"Internal"]
[null,null,null,null,null,"2019-11-12T10:26:28","2019-03-22","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","STBD SIDE REEFER PLANT DISCHARGE PRESSURE GAUGE GLYCERINE TO BE ADDED, SUCTION /DISCHARGE PRESSURE TO COVERED WITH TRANSPARENT PLASTIC, ON SUCTION SIDE FROSTING CAN BE SEEN INDICATING LESS PRESSURE GAUGE. SAME TO BE RECHARGE AS WELL.","Elect. Mach. & Equip.","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","PRESSURE SWITCH HAS BEEN COVERED WITH PLASTIC ON BOTH SYSTEM. ALSO CHARGE OF FREON FOR ABOUT 3KGS. NOW FREON LEVEL IS AT NORMAL LEVEL. ALSO RAISED R.O VRLN190082 FOR GLYCERINE LIQUID","2019-03-25",null,"Completed","2019-03-25","No",null,null,"Internal"]
[null,null,null,null,null,"2019-11-12T10:32:09","2019-03-22","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","NO.3 EXHAUST LAGGING COVER IS NOT FITTED IN ONE SECTION, SAME TO BE FITTED ASAP. ON MAIN ENGINE FUEL PPNO. 2 HP PIPE OUTLET. ALL HIGH TEMPERATURE PIPING TO BE COVERED WITH INSULATION LAGGING INCLUDING ME & DG T/CS AS ITS WAS FIRE HAZARDS","Aux. Engine","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","FOUND MISSING LAGGING COVER INSTALLED BACK COMPLETED","2019-03-25",null,"Completed","2019-03-22","No",null,null,"Internal"]
[null,null,null,null,null,"2019-11-12T11:24:26","2019-03-25","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","SPARE PISTON DOESN'T HAVE ANY RECORD OF TESTING/OVERHAULING, SAME TO BE PRESSURE TESTTED. RING GROOVE CLEARANCES TO BE TAKEN & STUFFING BOX TO BE REMOVED & CLEANED. REPORT TO BE  SENT TO OFFICE AFTER","Main Engine ","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","CHECKED AND PRESSURE TEST PISTON AND TAKE MEASURE MENT CLEARANCES AND PUT TO RECORD TOGETHER WITH STUFFING BOX","2019-03-31",null,"Completed","2019-03-31","No",null,null,"Internal"]
[null,null,null,null,null,"2019-11-12T11:29:16","2019-03-25","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","AUTO DRAIN FOR MAIN AIR BOTTLES ARE BYPASSED SAME TO BE OPENED/OVERHAULED AND CHECKED FOR CORRECT OPERATION","ER Pipes, valves & fittings","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","BOTH AUTO DRAIN FOR MAIN AIR BOTTLES ARE OPENED AND OVEHAULED","2019-03-27",null,"Completed","2019-03-27","No",null,null,"Internal"]
[null,null,null,null,null,"2019-11-12T11:33:25","2019-03-25","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","SEA WATER PUMP ROOM STBD SIDE ONE OF THE SOUNDING PIPE SELF CLOSING LEVER WAS STUCK IN OPEN POSITION, ALL THE DB TANK SOUNDING PIPE MECHANISM TO CHECK FOR ITS WORKING AS ITS PSC ITEM","ER Pipes, valves & fittings","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","RECONITIONED STUCK SOUNDING PIPE AND CHECKED ALL DB PIPES .ALL FOUND OK","2019-03-25",null,"Completed","2019-03-25","No",null,null,"Internal"]
[null,null,null,null,null,"2019-11-12T11:37:14","2019-03-25","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","NEAR OWS OVERBOARD V/V NOTICED TO BE PUT.(NOT TO BE OPERATED WITHOUT THE PERMISION OF THE MASTER & CHIEF ENGINEER)","Miscellaneous","Eng. / Strg. Comp.","Inappropriate Procedure",null,null,"Not Applicable","Not Applicable","POSTED NOTICED NEAR OVERBOARD VALVE","2019-03-26",null,"Completed","2019-03-26","No",null,null,"Internal"]
[null,null,null,null,null,"2019-11-12T11:42:52","2019-03-25","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","L/B TANK FUEL LEVEL IS LESS 7 REQURES TOP UP, COOLANT LEVEL IS EXTREMELY LOW 7 NEED TO TOP UP IMMEDIATELY","Critical Equip.","LSA / FFA Appliances","Equipment Related",null,null,"Not Applicable","Not Applicable","TOP UP FUEL OIL TANK WITH DIESEL OIL TO MAXIMUM LEVEL","2019-04-30",null,"Completed","2019-03-25","No",null,null,"Internal"]
[null,null,null,null,null,"2019-11-12T11:46:06","2019-03-25","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","ME LO AUTO BACK WASH FILTER DIFFERENTIAL INDICATION 75% RED, NEED TO CLEAN CANDLES FILTER AT NEXT PORT","Aux. Mach.","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","CLEANED AUTO BACKWASH FILTER AND RED MARK INDICATION RETURN TO NORMAL","2019-04-30",null,"Completed","2019-03-26","No",null,null,"Internal"]
[null,null,null,null,null,"2019-11-12T11:51:38","2019-03-25","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","ENGINE VENTILATION FLAPS, NO.3 VENTILATION FLAPS CLOSED FULLY, BUT WHEN OPEN ITS FLAPS IS NOT EXACTLY 90 DEG & NEEDS ADJUSTMENT , NO.2 VENTILATION FLAPS NOT CLOSING 7 SLUGGISH, NO. 1 FLAPS ARE NOT CLOSING FULLY. THIS PSC DETAINABLE DEFICIENCY","Miscellaneous","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","ALL ENGINE FLAPS ARE OPEN EXATLY 90 DEG. AND CLOSED FULLY","2019-04-30",null,"Completed","2019-03-27","No",null,null,"Internal"]
[null,null,null,null,null,"2019-11-12T11:58:20","2019-03-25","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","FUNNEL FLAPS ESEPECIALLY THE TOP FLAPS NEEDS ADJUSTMENT AS THEY ARE NOT FULLY CLOSING.THIS WAS PSC DETAINABLE","Miscellaneous","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","REPAIR ENGINE FLAPS AND ADJUST LEVER LINK TESTED FOUND SATISFACTORY","2019-04-30",null,"Completed","2019-04-30","No",null,null,"Internal"]
[null,null,null,null,null,"2019-11-12T12:02:04","2019-03-25","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","AT BILGE WELL HAS THICK LAYER OF OIL, TANK TO BE COMPLTELY EMNPTIED & THROUGHLY CLEANED, AND FILLED WITH SEA WATER 3/4","Miscellaneous","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","CLEAN AFT BILGE WELL REMOVED OILY WATER AND TRANFER TO SLUDGE","2019-04-30",null,"Completed","2019-03-25","No",null,null,"Internal"]
[null,null,null,null,null,"2019-11-12T12:04:40","2019-03-25","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","ECR EMERGENCY ESCAPE DOES NOT HAVE BLOCK SHEAVE & HARNESS, SAME TO BE ARRANGED","LSA / FFA","LSA / FFA Appliances","Inappropriate Procedure",null,null,"Not Applicable","Not Applicable","ECR ESCAPE TRUNK PULLEY BLOCK AND SAFETY HARNESS","2019-04-30",null,"Completed","2019-03-26","No",null,null,"Internal"]
[null,null,null,null,null,"2019-11-12T12:08:54","2019-03-25","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","WATER BELOW L/B ENGINE CASING NEEDS TO BE REMOVED AND CLEANED","Miscellaneous","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","REMOVED WATER IN ENGINE CASING AND CLEANED THE AREA AND REPAIR LEAKING HOSE FOR ENGINE COOLING","2019-04-30",null,"Completed","2019-03-25","No",null,null,"Internal"]
[null,null,null,null,null,"2019-11-12T12:13:35","2019-03-25","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","POSTER FOR NUMBER OF VALVES SHUTTING DURING QUICK CLOSING VALVE OPERATION IS TORNED IN QUICK CLOSING V/V CABINET SAME TO BE POSTED.","LSA / FFA","LSA / FFA Appliances","Equipment Related",null,null,"Not Applicable","Not Applicable","POSTED SHUTTING VALVE NEW LAMINATED POSTER","2019-04-30",null,"Completed","2019-03-26","No",null,null,"Internal"]
[null,null,null,null,null,"2019-11-12T12:17:46","2019-03-25","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","DRAIN PLUGS OF DRIP TRAYS ON ECK FOR F.O VENTS BUNKER MANIFOLD ARE MISSING, PLUGS TO BE ORDERED/FABRICATED &LASHED WITH WIRE CHAIN","ER Pipes, valves & fittings","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","FABRICATED NEW DRAIN PLUGS OF DIP TRAY ON DECK FOR FO BUNKER MANIFOLD","2019-04-30",null,"Completed","2019-03-25","No",null,null,"Internal"]
[null,null,null,null,null,"2019-11-12T14:14:04","2019-03-25","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","DG SUMP TANK PURIFICATION ROUTINES TO BE STARTED EVERY 500 HOURS, PMS CHANGE REQUEST TO BE SENT TO OFFICE FOR ADDITION OF THIS JOB. START PURIFICATION WITH NO. 2 DG AS VISCOSITY 7 SPOT RESUSLT ARE ON HIGHER SIDE","Aux. Engine","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","STARTED PURIFICATION ON DG NO. 2 SUMP TANK","2019-03-27",null,"Completed","2019-03-27","No",null,null,"Internal"]
[null,null,null,null,null,"2019-11-12T14:19:24","2019-03-22","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","LUBE OIL MSDS ARE OF 2008 VERSION, TO REQUEST PROCEDURE FOR LATEST VERSION OF MSDS FOR GRADES ONBOARD","Documentation","General Appearance","Inappropriate Procedure",null,null,"Not Applicable","Not Applicable","MSDS LATEST VERSION RECEIVE THRU MAIL","2019-03-25",null,"Completed","2019-03-25","No",null,null,"Internal"]
[null,null,null,null,null,"2019-11-12T14:22:30","2019-03-25","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","PORT SIDE FWD AIR VENT BROKEN & NEEDS REPLACEMENT","Deck Pipe / Fittings","General Appearance","Equipment Related",null,null,"Not Applicable","Not Applicable","DETACHED AIR VENT HEAD AND OVERHAUL AND REPLACED SCREEN","2019-04-25",null,"Completed","2019-03-28","No",null,null,"Internal"]
[null,null,null,null,null,"2019-11-12T14:26:21","2019-03-25","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","NOTICE WITH DIAGRAM TO DISPLAY ON BOTH CRANES SHOWING DIRECTION FOR HOISTING (SLOW/FAST) & SLEWING TO BE POSTED","Cargo Mach.","Cargo / Ballast Systems","Equipment Related",null,null,"Not Applicable","Not Applicable","POST DIAGRM AND INSTRUCTION FOR CRANE OPERATION","2019-03-31",null,"Completed","2019-03-28","No",null,null,"Internal"]
[null,null,null,null,null,"2019-11-12T14:29:56","2019-03-25","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","BRAKE RENDERING TEST FOR ALL WINCHES & WINDLASS TO BE CARIED OUT AS NO MARKING HAS BEEN MADE FOR BRAKE TIGHTENING.","Deck Mach.","Mooring","Equipment Related",null,null,"Not Applicable","Not Applicable","BRAKE REDERING TEST CARRIED OUT FOR WINCHES AND WINDLASS AND MARKING WAS INSTALLED","2019-05-15",null,"Completed","2019-03-28","No",null,null,"Internal"]
[null,null,null,null,null,"2019-11-12T14:32:01","2019-03-22","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","NO.2 DG STARTING AIR PRESSURE GAUGE FAULTY","Aux. Engine","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","RENEW GAUGE WITH SPARE","2019-03-25",null,"Completed","2019-03-25","No",null,null,"Internal"]
[null,null,null,null,null,"2019-11-12T14:36:45","2019-03-25","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","IN CO2 ROOM DIAGRAM TO BE POSTED FOR INDIVIDUAL CARGO HOLDS FOR NO. OF VENTS , FLAPS , HATCHES & HATCH COVER FLAPS (P&S) TO BE CLOSED BEFORE RELEASING CO2 IN CASE OF CARGO HOLD FIRE","LSA / FFA","LSA / FFA Appliances","Equipment Related",null,null,"Not Applicable","Not Applicable","POSTED INDIVIDUAL CARGO HOLDS FOR NO. OF VENTS,FLAPS HATCHES AND HATCH COVER TO BE CLOSED BEFORE RELEASING CO2 IN CASE OF CARGO HOLD FIRE","2019-04-15",null,"Completed","2019-05-04","No",null,null,"Internal"]
[null,null,null,null,null,"2019-11-12T14:41:58","2019-03-25","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","DAVIT CRANES OR RESCUE BOAT, LIFEBOAT & SUEZ LIGHTS DAVITS HOOKS SAFETY LATCHES SPRING ARE BROKEN AND NEEDS ONBOARD FABRICATION","LSA / FFA","LSA / FFA Appliances","Equipment Related",null,null,"Not Applicable","Not Applicable","FABRICATED RECUE BOAT, LIFEBOAT & SUEZ CANAL LIGHTS DAVITS HOOKS SAFETY LATCHES SPRINGS AND INSTALLED","2019-04-25",null,"Completed","2019-04-04","No",null,null,"Internal"]
[null,null,null,null,null,"2019-11-12T14:53:12","2019-03-25","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","YELLOW IDENTIFICATION MARKINGS HAS TO BE MADE ON ALL GREASING POINTS ON DECK MACHINERY & EQUIPMENT FOR EASY IDENDIFICATION","Deck Mach.","General Appearance","Equipment Related",null,null,"Not Applicable","Not Applicable","ALL DECKS MACHINERIES FITTINGS  AROUND GREASING POINTS WERE PAINTED WITH YELLOW","2019-04-25",null,"Completed","2019-04-06","No",null,null,"Internal"]
[null,null,null,null,null,"2019-11-12T14:57:26","2019-03-22","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","PORT SIDE WINDLASS LINING IS WORNED FROM TOP,SAME TO BE PLANNED FOR RENEWAL  & LOCKING PIN CONNECTING 2 LINING TO BE TAKENOUT & FREED","Deck Mach.","General Appearance","Equipment Related",null,null,"Not Applicable","Not Applicable","WINDLASS (P) BRAKE LINING TOP RENEWED AND 2 LOCKING PINS RECONDITIONED","2019-05-15",null,"Completed","2019-04-17","No",null,null,"Internal"]
[null,null,null,null,null,"2019-11-12T14:59:59","2019-03-22","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","STBD SIDE STEERING GEAR RAM PRESSURE GAUGE FAULTY,SAME TO BE REPLACED","Critical Equip.","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","RAISED R.O","2019-03-25",null,"Completed","2019-04-22","No",null,null,"Internal"]
[null,null,null,null,null,"2019-11-12T15:02:29","2019-03-22","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","LATHE M/C DOES NOT HAVE PROTECTTIVE COVER FOR EYE,HINGE TYPE TO BE FABRICATED USING TRANSPARENT SHEET OR GLASS","Elect. Mach. & Equip.","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","RAISED R.O VRLN190090","2019-03-25",null,"Completed","2019-04-22","No",null,null,"Internal"]
[null,null,null,null,null,"2019-11-12T15:07:19","2019-03-25","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","BOTH ACHORS BOW STOPPER IS NOT SEATING COMPLETELY, WHEN ANCHOR WAS FULLY STOWED. TRY TO TWIST TH CHAIN FROM SWIVEL BY SECURING THE ANCXHOR & LOOSENING THE CHAIN, THEN USING SUPPORT OF THE OTHER WINCH & TURNING THE CHAIN, RAISED THE DEFECT IN REFMAN FOR PERMANENT","Deck Mach.","Mooring","Equipment Related",null,null,"Not Applicable","Not Applicable","TWISTED BOTH CHAIN FROM SWIVEL AND WILDAT BUT THE RESULT WAS STILL THE SAME CONDITION, THE STOPPER NOT SEATING COMPLETELY","2019-05-15",null,"Completed","2019-04-25","No",null,null,"Internal"]
[null,null,null,null,null,"2019-11-12T15:09:25","2019-03-14","Breakdown","Ship Staff","Ship Staff Insp.","AIR DRYER HERMETICAL COMPRESSOR BURN OUT","Aux. Mach.","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","RAISE R.O VRLN190070","2019-05-30","VRLN 190070","Completed","2019-05-06","No",null,null,"Internal"]
[null,null,null,null,null,"2019-11-12T15:13:21","2019-03-31","Observation","Ship Staff","Ship Staff Insp.","SEA WATER COMING FROM BILGE AND GS PUMP","Aux. Mach.","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","CORRODED SHAFT BUILD UP, MACHINE AND POLISH TEST RUN FOUND NO L;EAK","2019-06-30",null,"Completed","2019-04-16","No",null,null,"Internal"]
[null,null,null,null,null,"2019-11-12T15:15:12","2019-06-05","Breakdown","Ship Staff","Ship Staff Insp.","SEFA ACTUATOR NOT WORKING","Main Engine ","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","ORDER NEW SPARE AND INSTALL BY THE MAKER SERVICE","2019-05-31",null,"Completed","2019-05-27","No",null,null,"Internal"]
[null,null,null,null,null,"2019-11-12T15:19:48","2019-03-23","Breakdown","Ship Staff","Ship Staff Insp.","WASHING MACHINE AND DRYER FOR LAUNDRY","Accommodation ","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","RAISE R.O","2019-05-30","VRLN190078","Completed","2019-05-27","No",null,null,"Internal"]
[null,null,null,null,null,"2019-11-12T15:22:15","2019-03-22","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","SEWAGE PLANT AIR BLOWER SPARES FOR MOTOR & PUMP TO ORDER","Aux. Mach.","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","RAISED R.O","2019-05-30","VRLN190083","Completed","2019-05-27","No",null,null,"Internal"]
[null,null,null,null,null,"2019-11-12T15:25:14","2019-04-14","Breakdown","Ship Staff","Ship Staff Insp.","COMPRESSOR FOR GALLEY REFRIGRATOR","Elect. Mach. & Equip.","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","RAISED R.O","2019-05-25","VRLN190105","Completed","2019-05-29","No",null,null,"Internal"]
[null,null,null,null,null,"2019-11-12T15:28:33","2019-03-25","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","LOCAL MANUAL RELEASE OF AIR VENTILATION DAMPERS( TO BE USED IN CASE OF EMERGENCY)RE SEIZED 2 SETS TO ORDER AND REPLACED THEN TYHE REMAINING TO BE OVERHAULED AND FITTED BACK","Aux. Mach.,LSA / FFA","LSA / FFA Appliances","Equipment Related",null,null,"Not Applicable","Not Applicable","RAISE R.O","2019-05-31","VRLN190095","Completed","2019-05-31","No",null,null,"Internal"]
[null,null,null,null,null,"2019-11-12T15:30:34","2019-06-05","Breakdown","Ship Staff","Ship Staff Insp.","NORDIC FLOW CONTROL SYSTEM NOT WORKING","Elect. Mach. & Equip.","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","INFORM MAKER AND SET DATE FOR TEAMVIEW CONTROL OF MAIN COMPUTER","2019-05-31",null,"Completed","2019-05-31","No",null,null,"Internal"]
[null,null,null,null,null,"2019-11-12T15:33:35","2019-03-25","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","FIRE PLAN NEAR l/BS WAS FADED & GL STAMPING COULD NOT BE SEEN,TO ARRANGE FOR COLOR COPY 7 LAMINATION WITH ASSISTANCE FROM AGENT","LSA / FFA","LSA / FFA Appliances","Equipment Related",null,null,"Not Applicable","Not Applicable","WAITING LAMINATED ONES FROM FOODWOOD OFFICE","2019-06-25",null,"Completed","2019-06-25","No",null,null,"Internal"]
[null,null,null,null,null,"2019-11-12T16:17:23","2019-05-25","Breakdown","Ship Staff","Ship Staff Insp.","HFO PURIFIER FEED PUMP BURN OUT","Purifier","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","RAISED R.O","2019-06-30","VRLN190163","Completed","2019-06-19","No",null,null,"Internal"]
[null,null,null,null,null,"2019-11-12T16:20:13","2019-06-17","Breakdown","Ship Staff","Ship Staff Insp.","CRANE NO.1 TOP JIB MOUNTING WIRE SHEAVE BEARING DAMAGED","Cargo Mach.","Cargo / Ballast Systems","Equipment Related",null,null,"Not Applicable","Not Applicable","INFORM OFFICE AND RENEW THE WIRE SHEAVE WITH THE RECONDITION SPARE WITH NEW BEARING BY SHIPS CREW","2019-07-30",null,"Completed","2019-06-27","No",null,null,"Internal"]
[null,null,null,null,null,"2019-11-12T16:22:34","2019-06-29","Breakdown","Ship Staff","Ship Staff Insp.","BWTS NO.2 NOT WORKING DUE TO UV SENSOR AND REED SWITCH FOR WIPER MOTOR","Aux. Mach.","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","RAISED R.O","2019-07-30","VRLN190157","Completed","2019-07-06","No",null,null,"Internal"]
[null,null,null,null,null,"2019-11-12T16:24:24","2019-06-05","Breakdown","Ship Staff","Ship Staff Insp.","FAN MOTOR FOR AIR DRYER","Aux. Mach.","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","RAISED R.O","2019-07-30","VRLN190121","Completed","2019-06-02","No",null,null,"Internal"]
[null,null,null,null,null,"2019-11-12T16:29:25","2019-03-25","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","ONE OF EACH HOSES HAS TO BE KEPT AS SPARE, CHECKED INVENTORY & MAKE RFQ FOR REQUIRED HOSES","Cargo Mach.","Cargo / Ballast Systems","Equipment Related",null,null,"Not Applicable","Not Applicable","RAISED R.O","2019-07-31","VRLN 1900197","Completed","2019-07-31","No",null,null,"Internal"]
[null,null,null,null,null,"2019-11-12T16:31:17","2019-06-06","Breakdown","Ship Staff","Ship Staff Insp.","NORDIC FLOW CONTROL MIMIC PANEL NODE ERROR SIGNAL","Cargo Mach.","Cargo / Ballast Systems","Equipment Related",null,null,"Not Applicable","Not Applicable","INFORM OFFICE AND MAKER WAITING FOR INSTRUCTION","2019-07-31",null,"Completed","2019-07-31","No",null,null,"Internal"]
[null,null,null,null,null,"2019-11-12T16:34:22","2019-03-25","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","CARHO HOLD TUBE LIGHTS BUSTED, TO BE REPLACED WITH NEW 2 PIN TYPE & LIGHTS ","Elect. Mach. & Equip.","General Appearance","Equipment Related",null,null,"Not Applicable","Not Applicable","ORDER NEW LIGHT HOLDER TO MODIFY WITH LED LIGHT IN PROGRESS","2019-08-30",null,"Completed","2019-08-10","No",null,null,"Internal"]
[null,null,null,null,null,"2019-11-12T16:40:54","2019-08-14","Breakdown","Ship Staff","Ship Staff Insp.","SPIDER COUPLING OF STBD STEERING GEAR HYDRAULIC PUMP MOTOR BROKEN","Aux. Mach.","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","FABRICATED SPIDER COUPLING TEMPORARY","2019-09-30",null,"Completed","2019-09-29","No",null,null,"Internal"]
[null,null,null,null,null,"2019-09-11T23:00:08","2019-07-29","Deficiency","Ship Staff","Ship Staff Insp.","Worn out impeller and mouth ring of Main CSW pump no.1","Aux. Mach.","Eng. / Strg. Comp.","Equipment Related","VIQ_ref_no VRLN190166",null,"Not Applicable","Not Applicable","RO raised","2019-11-16",null,"Completed","2019-11-15","No",null,null,"Internal"]
[null,null,null,null,null,"2019-11-10T14:28:35","2019-09-30","Deficiency","Ship Staff","Ship Staff Insp.","Slight leakage of ME FO pump cover units 3 & 4","Main Engine ","Eng. / Strg. Comp.","Equipment Related","VRLN190217",null,"Not Applicable","Not Applicable","Replaced packing of pump cover. ","2019-12-15","VRLN190217","Completed","2019-12-01","No",null,null,"Internal"]

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

{"sheet":"Ship_information","index":19,"n_rows":2,"n_cols":3,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["Ship_ID","Ship_Name","FILE_NAME"]
["96","VIKING MERLIN","96_1573291487684.xlsm"]