{"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":74,"n_cols":28,"rows_kept":74,"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","22-Dec-2020",null,null,"Ship Name","MING LONG (15-05-2020)"]
[]
[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,11782,"73_3/5/2020 11:08:04 AM","2020-05-16","Defect","Ship Staff","Ship Staff Insp.","Cargo vapour line 'U' bolts heavily corroded.","Deck - Pipe / Fittings","Cargo / Ballast Systems","Equipment Related","11.4","Very High","","","Crop and Renew 'U' bolts","2020-12-30","","In progress",null,"Yes","No","No","Internal"]
[null,null,null,null,11766,"73_2/5/2020 8:55:00 PM","2020-08-31","Observation","Ship Staff","Ship Staff Insp.","Aft mooring winch pump no2 on off switch broken","Deck - Mooring Machinery","Eng. / Strg. Comp.","Equipment Related,Human Error","10.37","Medium","","","Switch to replace once spares rcvd.","2020-11-30","MLON200011","In progress",null,"No","No","No","Internal"]
[null,null,null,null,11774,"73_2/5/2020 9:25:26 PM","2020-08-31","Defect","Ship Staff","Ship Staff Insp.","ME Lube oil Purifier no 2 non operational","E/R - Purifier","Eng. / Strg. Comp.","Equipment Related","10.32","Very High","","","Awaiting for spares","2020-11-30","MLON200009","In progress",null,"No","No","No","Internal"]
[null,null,null,null,11773,"73_2/5/2020 9:23:28 PM","2020-09-01","Observation","Ship Staff","Ship Staff Insp.","ER nemurous pumps /heaters /coolers Pressure gauges/temp gauges are damagedn missing","Miscellaneous","Eng. / Strg. Comp.","Equipment Related,Human Error","10.32","Very High","","","Vsl rcvd spares renewal in progress","2020-12-01","","In progress",null,"No","No","No","Internal"]
[null,null,null,null,11760,"73_2/5/2020 5:11:11 PM","2020-09-02","Observation","Ship Staff","Ship Staff Insp.","Marine growth protection system not operational","Miscellaneous","Eng. / Strg. Comp.","Equipment Related","10.33","High","","","Spares on order","2020-12-02","MLON200006","In progress",null,"No","No","No","Internal"]
[null,null,null,null,11762,"73_2/5/2020 5:56:25 PM","2020-09-02","Defect","Ship Staff","Ship Staff Insp.","Engine room workshop door A60 Class repaired with welding","Miscellaneous","Eng. / Strg. Comp.","Equipment Related","10.32","Very High","","","RO raised for Spare door","2020-12-02","MLON200035","In progress",null,"No","No","No","Internal"]
[null,null,null,null,11776,"73_2/5/2020 10:16:09 PM","2020-09-03","Other","Ship Staff","Ship Staff Insp.","Numerous MSDS for Chemicals/Lubricating oil Missing","Miscellaneous","Communication","Human Error","5.46","Medium","","","Office has been advised to provide same.","2020-12-15","","In progress",null,"No","No","No","Internal"]
[null,null,null,null,11525,"73_30/4/2020 1:37:19 PM","2020-09-04","Defect","Ship Staff","Ship Staff Insp.","Ballast tank remote sounding Tank no 1P,After peak,3&4S are showing sensor failure and midship draft gauge port and stbd incorrect sounding.","Hull & Tanks","Cargo / Ballast Systems","Equipment Related","8.19","Very High","","","Vessel has few spare sensor but vessel always engaged in cargo operationlooking for suitable oppurtunity to troublr shoot and renew sensors as required.","2020-12-04","","Not Started",null,"No","No","No","Internal"]
[null,null,null,null,11747,"73_2/5/2020 7:36:07 AM","2020-09-07","Observation","Ship Staff","Ship Staff Insp.","Port life boat Engine rpm meter not operational","LSA / FFA","Safety / LSA / FFA","Equipment Related","5.29","High","","","Spares to order after troubleshoot","2020-12-07","","Not Started",null,"No","No","No","Internal"]
[null,null,null,null,11735,"73_1/5/2020 5:00:35 PM","2020-09-08","Observation","Ship Staff","Ship Staff Insp.","Oil leakage observed through DG1 Shat seal even after seal has been renewed","E/R - Aux. Engine","Eng. / Strg. Comp.","Equipment Related","10.19","Very High","","","To be contacted makers for advise","2020-12-07","","In progress",null,"No","No","No","Internal"]
[null,null,null,null,11749,"73_2/5/2020 2:58:29 pm","2020-09-10","Observation","Ship Staff","Ship Staff Insp.","valve remote Hydraulic system recirculation valve near port side of cargo tank no 1  Wheel wasted and valves appears in frozen condition","Deck - Machinery,Deck - Pipe / Fittings","Cargo / Ballast Systems","Equipment Related,Human Error","6.4","High","","","Valve to be o/Hauled and Wheel to renew for smooth operation of valve","2020-12-10","","Not Started",null,"No","No","No","Internal"]
[null,null,null,null,11736,"73_1/5/2020 10:22:01 PM","2020-09-12","Observation","Ship Staff","Ship Staff Insp.","Hose handling control system in poor condition,Relief valve ,emergency stop valve ,Low/Speed selector valve ,JIB reset valve,Jib Angle indicator wasted,all three contrl vv for slewing,Hoisting ,Luffing leaking","Deck - Machinery","Cargo / Ballast Systems","Equipment Related","8.5","Medium","","","Informed tech suprinted advise to appoint hyd technician for repairs.","2020-12-11","","Not Started",null,"No","No","No","Internal"]
[null,null,null,null,11761,"73_2/5/2020 5:50:59 PM","2020-09-13","Observation","Ship Staff","Ship Staff Insp.","Engine room tank dorty and rusted","Miscellaneous","Eng. / Strg. Comp.","Human Error","10.29","Medium","","","Whole tank top to be cleaned chipped and painted same in progress.","2020-12-08","","In progress",null,"No","No","No","Internal"]
[null,null,null,null,11798,"73_3/5/2020 3:52:26 PM","2020-09-15","Observation","Ship Staff","Ship Staff Insp.","AE1 Oil max filter for L.O cleaning not effective due to RPM not optimum.","E/R - Aux. Engine","Eng. / Strg. Comp.","Equipment Related","10.32","Very High","","","Rotating drum bearings to be renewed.","2020-12-15","","Not Started",null,"No","No","No","Internal"]
[null,null,null,null,11732,"73_2/5/2020 6:44:14 AM","2020-09-15","Observation","Ship Staff","Ship Staff Insp.","PMS not fully functional ,Noon report not yet started,Running hrs based jobs are not reflecting in the system.","Miscellaneous","Communication","Human Error","10.12","Very High","","","PAL support system informed several times but not yet resolved issue.","2020-12-14","","In progress",null,"No","No","No","Internal"]
[null,null,null,null,11737,"73_1/5/2020 5:03:49 PM","2020-09-15","Observation","Ship Staff","Ship Staff Insp.","DG port side jacket cooler SW  Inlet Cover leaking","E/R - Pipes/ valves & fittings","Eng. / Strg. Comp.","Equipment Related","10.31","Very High","","","Cover to be removed from place and repaired ,Vessel awaiting for suitable opportunity","2020-12-15","","Not Started",null,"No","No","No","Internal"]
[null,null,null,null,11748,"73_2/5/2020 8:12:39 am","2020-09-15","Defect","Ship Staff","Ship Staff Insp.","Air bottle no2 Inner drain valve leaking","E/R - Pipes/ valves & fittings","Eng. / Strg. Comp.","Equipment Related","10.32","Very High","","","Air bottle to isoalte drain o/haul the valve","2020-12-15","","Not Started",null,"No","No","No","Internal"]
[null,null,null,null,11758,"73_2/5/2020 4:59:55 PM","2020-09-15","Defect","Ship Staff","Ship Staff Insp.","cargo plant cooling sea water Line Valve between inlet and overboatd body leaking","Deck - Pipe / Fittings","Cargo / Ballast Systems","Equipment Related","8.33","High","","","New gate valve 5K150 to procure and replace the same","2020-12-15","","Not Started",null,"No","No","No","Internal","Please create & submit RO for new valve."]
[null,null,null,null,11745,"73_2/5/2020 7:28:08 AM","2020-09-16","Observation","Ship Staff","Ship Staff Insp.","Compressor room natural vent head mesh fallen down","Deck - Pipe / Fittings","Cargo / Ballast Systems","Equipment Related","8.29","Medium","","","Mesh to be secured","2020-12-15","","Not Started",null,"No","No","No","Internal"]
[null,null,null,null,11767,"73_2/5/2020 8:59:56 PM","2020-09-18","Observation","Ship Staff","Ship Staff Insp.","Oxygen /Acetylene Flashback arrestor in Bottle stored room need to change as per VIQ Ref no 5.26","Miscellaneous","Safety / LSA / FFA","Equipment Related,Human Error","5.26","Medium","","","Vsl ordered but rcvd 1pc each","2020-12-17","MLON200020 Item no 6,7 but rcvd one pc each","In progress",null,"No","No","No","Internal"]
[null,null,null,null,11797,"73_3/5/2020 3:49:35 PM","2020-09-19","Observation","Ship Staff","Ship Staff Insp.","AE 1 Auto Valve for Cooling SW in to L.O Cooler leaking L.O from actuator spindle","E/R - Aux. Engine","Eng. / Strg. Comp.","Equipment Related","10.32","Very High","","","Actuator to be o/hauled","2020-12-18","","Not Started",null,"No","No","No","Internal"]
[null,null,null,null,11522,"73_29/4/2020 3:48:09 PM","2020-09-28","Defect","Ship Staff","Ship Staff Insp.","All three DG and ME /BLR exhaust pipe insulation in poor condition.","E/R - Aux. Engine","Eng. / Strg. Comp.","Equipment Related","10.19","Very High","","","Office  arranged “Kaizen Offshore & Marine Solutions Pte Ltd\" technician to Measurments awaiting their feed back","2020-12-28","","Not Started",null,"No","No","No","Internal"]
[null,null,null,null,11523,"73_29/4/2020 3:57:45 PM","2020-09-28","Observation","Ship Staff","Ship Staff Insp.","Numerous steam/Fuel pipes in ER insulation damaged and in poor condition","E/R - Pipes/ valves & fittings","Eng. / Strg. Comp.","Equipment Related","10.32","Very High","","","Office  arranged technician from “Kaizen Offshore & Marine Solutions Pte Ltd\" and has been taken dimension for damaged insulation awaiting for feed back and fresh insulation","2020-12-28","","In progress",null,"No","No","No","Internal"]
[null,null,null,null,15103,"73_Tue Nov 24 2020 04:30:30 GMT+0000","2020-09-30","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","WATER BALLAST REMOTE LEVEL GAUGING DISPLAY SHOWING ERROR – TO CHECK / INVESTIGATE AND REVERT","Hull & Tanks","","Equipment Related","","","","","investigate and change one sensor","2020-11-30","","In progress",null,"No","No","No","Internal"]
[null,null,null,null,11733,"73_1/5/2020 4:51:34 PM","2020-10-01","Defect","Ship Staff","Ship Staff Insp.","All 3DG not able to start in auto mode/remote mode ,need start Local/Manual","E/R - Aux. Engine","Eng. / Strg. Comp.","Equipment Related","10.19","Very High","","","Troubleshooting in Progress","2020-12-31","","Not Started",null,"No","No","No","Internal"]
[null,null,null,null,11739,"73_2/5/2020 7:07:02 AM","2020-10-02","Breakdown","Ship Staff","Ship Staff Insp.","Cargo compressor no1 2nd stage piston damaged.","Cargo Mach.","Cargo / Ballast Systems","Equipment Related","8.33","High","","","Spares are on order/once available compressor to be boxed back and make operational.","2020-12-02","MLON200021","In progress",null,"No","No","No","Internal"]
[null,null,null,null,11750,"73_2/5/2020 3:06:41 pm","2020-10-02","Defect","Ship Staff","Ship Staff Insp.","Inert Gas outlet dew point meter not operational","Inert Gas","Cargo / Ballast Systems","Equipment Related","8.22","High","","","Vessel rcvd new dew point meter but not same as existing one ,advise taken from office for installation job in progress.","2020-12-02","","In progress",null,"No","No","No","Internal"]
[null,null,null,null,11754,"73_2/5/2020 4:52:09 PM","2020-10-02","Defect","Ship Staff","Ship Staff Insp.","FO Purifier feed pp Isolating Valve to Filters iinternally leaking","E/R - Pipes/ valves & fittings","Eng. / Strg. Comp.","Equipment Related","10.32","Very High","","","valve to remove from place and o/haul at Suitable opportunity","2020-11-30","","Not Started",null,"No","No","No","Internal"]
[null,null,null,null,11755,"73_2/5/2020 4:54:16 PM","2020-10-02","Defect","Ship Staff","Ship Staff Insp.","FO settling valve Lower suction to Purifier internaly leaking","E/R - Pipes/ valves & fittings","Eng. / Strg. Comp.","Equipment Related","10.32","Very High","","","Settling tank to be drained completely Valve to be removed from place and o/hauled.","2020-12-02","","Not Started",null,"No","No","No","Internal"]
[null,null,null,null,11769,"73_2/5/2020 9:06:55 PM","2020-10-02","Observation","Ship Staff","Ship Staff Insp.","ME all 5units Local JCW outlet tep gauges are missing","E/R - Main Engine","Eng. / Strg. Comp.","Equipment Related","10.32","Very High","","","Gauges to be order in next store and replace","2020-12-09","","Not Started",null,"No","No","No","Internal"]
[null,null,null,null,11772,"73_2/5/2020 9:16:16 PM","2020-10-02","Observation","Ship Staff","Ship Staff Insp.","Engine room Nemurous electrical panels Indication Lights not working or On Off switches brittle partialy broken or in poor condition","Elect. Mach. & Equip.","Eng. / Strg. Comp.","Equipment Related,Human Error","10.32","Very High","","","To be repaired all brittle ,broken and fused lamps","2020-12-15","MLON200011","In progress",null,"No","No","No","Internal"]
[null,null,null,null,11809,"73_4/5/2020 1:12:49 PM","2020-10-03","Defect","Ship Staff","Ship Staff Insp.","All four cargo plant and inter cooler level controller not operational","Cargo Mach.","Cargo / Ballast Systems","Equipment Related","8.33","High","","","All controllers to be o/hauled.","2020-12-04","","Not Started",null,"No","No","No","Internal"]
[null,null,null,null,11800,"73_3/5/2020 3:58:16 PM","2020-10-15","Observation","Ship Staff","Ship Staff Insp.","Feed water pump no 1 has high vibration.","E/R - Pumps","Eng. / Strg. Comp.","Equipment Related","10.32","Very High","","","pump bearings to be renewed.","2020-11-30","","Not Started",null,"No","No","No","Internal"]
[null,null,null,null,11804,"73_3/5/2020 4:11:51 PM","2020-10-15","Observation","Ship Staff","Ship Staff Insp.","IG cooling SW pump Outlet is normal valve should be NRV type when Reliquifaction cooling pp running then rotate in other direction so discharge valve to be closed when in stop condition.","E/R - Pipes/ valves & fittings","Eng. / Strg. Comp.","Equipment Related","10.32","Very High","","","new valve recieved and will be installed","2020-12-15","","In progress",null,"No","No","No","Internal"]
[null,null,null,null,11753,"73_2/5/2020 4:20:22 PM","2020-10-15","Observation","Ship Staff","Ship Staff Insp.","Cargo Plant Cooling sea water Both Side Overboard valves leaking at the body temp repaire done","Deck - Pipe / Fittings","Cargo / Ballast Systems","Equipment Related","8.33","High","","","Both valves to be replaced Valve size 5K250 gate valve,Also Vessel is engaged everyday in Cargo operation can be done when no cargo operation at Leat 8Hrs.","2020-12-15","","Not Started",null,"No","No","No","Internal"]
[null,null,null,null,11759,"73_2/5/2020 5:07:00 PM","2020-10-15","Observation","Ship Staff","Ship Staff Insp.","Port side freshwater tank manhole door near vent head few bolts are missing","Hull & Tanks","Structural Condn. / WT integrity ","Human Error","11.6","Medium","","","Manhole cover to secured with bolts","2020-11-30","","Not Started",null,"No","No","No","Internal"]
[null,null,null,null,11770,"73_2/5/2020 9:09:20 PM","2020-10-15","Defect","Ship Staff","Ship Staff Insp.","Clean Bilge tank Sounding pipe clogged","Miscellaneous","Eng. / Strg. Comp.","Equipment Related","10.32","Very High","","","Tank to empty and sounding pipe to clean","2020-12-15","","Not Started",null,"No","No","No","Internal"]
[null,null,null,null,11792,"73_3/5/2020 12:29:19 PM","2020-10-18","Critical Equipment,Defect","Ship Staff","Ship Staff Insp.","Port side manifold.Forward  liquid line Hydraulic v/v leaking.","Cargo Mach.,Critical Equip.","Cargo / Ballast Systems","Equipment Related","8.6","Very High","","","Spares unavailable onboard.Continuous cargo operations onboard.","2020-12-17","","Not Started",null,"No","No","No","Internal"]
[null,null,null,null,11524,"73_30/4/2020 1:25:38 PM","2020-10-27","Defect","Ship Staff","Ship Staff Insp.","Bunker tank FOT 2(C) high Level not working","Hull & Tanks","Eng. / Strg. Comp.","Equipment Related","10.8","Medium","","","Spares to order after troubleshoot","2020-12-24","","Not Started",null,"No","No","No","Internal"]
[null,null,null,null,11805,"73_3/5/2020 4:14:12 PM","2020-10-28","Defect","Ship Staff","Ship Staff Insp.","Ballast pump no2 Mechanical seal leaking","E/R - Pumps","Eng. / Strg. Comp.","Equipment Related","10.32","Very High","","","Mechanical seal to renewed","2020-12-15","","Not Started",null,"No","No","No","Internal"]
[null,null,null,null,11803,"73_3/5/2020 4:07:18 PM","2020-10-30","Defect","Ship Staff","Ship Staff Insp.","IG cooling SW pump Inlet Valve Frozen in open position","E/R - Pipes/ valves & fittings","Eng. / Strg. Comp.","Equipment Related","10.32","Very High","","","Valves to replaced ,required to shutdown all eqpmt and isolate the seachest valves","2020-12-15","","Not Started",null,"No","No","No","Internal"]
[null,null,null,null,11738,"73_2/5/2020 6:51:37 AM","2020-10-30","Defect","Ship Staff","Ship Staff Insp.","All Four cargo plant Inter cooler and knock out drums Level gauges are dirty and cracked Liquig Level not visible.","Cargo Mach.","Cargo / Ballast Systems","Equipment Related","8.33","High","","","Spares are on order once received to make operational.","2020-12-30","MLON200029/30","In progress",null,"No","No","No","Internal"]
[null,null,null,null,11744,"73_2/5/2020 7:25:18 AM","2020-10-30","Observation","Ship Staff","Ship Staff Insp.","Both Life boat davit gear box Oil Level sight glass paited ,level not visible.","LSA / FFA","Safety / LSA / FFA","Human Error","5.27","Medium","","","Sight glass to clean","2020-11-30","","Not Started",null,"No","No","No","Internal"]
[null,null,null,null,11751,"73_2/5/2020 3:09:09 pm","2020-10-30","Defect","Ship Staff","Ship Staff Insp.","incinerator Furnance door Frame cracked 2places","Miscellaneous","Emgcy. Systems","Equipment Related","10.32","Very High","","","Furnance door to be reapired","2020-12-15","","Not Started",null,"Yes","No","No","Internal"]
[null,null,null,null,11734,"73_1/5/2020 4:57:05 PM","2020-10-31","Observation","Ship Staff","Ship Staff Insp.","All DG DG Numerous pressre/temp gauges defective","E/R - Aux. Engine","Eng. / Strg. Comp.","Equipment Related,Human Error","10.19","Very High","","","few are renewed ,remaining spares on order","2020-12-30","MLON200002","In progress",null,"No","No","No","Internal"]
[null,null,null,null,11799,"73_3/5/2020 3:55:20 PM","2020-11-01","Observation","Ship Staff","Ship Staff Insp.","AE F.O circulating pump # 2 leaking through shaft gland","E/R - Aux. Engine","Eng. / Strg. Comp.","Equipment Related","10.32","Very High","","","Shaft seal to renewed.","2020-11-30","","Not Started",null,"No","No","No","Internal"]
[null,null,null,null,11801,"73_3/5/2020 4:01:55 PM","2020-11-01","Defect","Ship Staff","Ship Staff Insp.","Boiler Low water level alarm not functiong it is erratic comes after TooLow Level alarm","E/R - Boiler","Eng. / Strg. Comp.","Equipment Related","10.32","Very High","","","Trouble shooting in progress","2020-12-15","MLON200050","In progress",null,"No","No","No","Internal"]
[null,null,null,null,11775,"73_2/5/2020 9:29:08 PM","2020-11-01","Defect","Ship Staff","Ship Staff Insp.","Both HFO purifier water detector not working","E/R - Purifier","Eng. / Strg. Comp.","Equipment Related","10.32","Very High","","","Trouble shooting in progress spares to order","2020-12-04","","In progress",null,"No","No","No","Internal"]
[null,null,null,null,11740,"73_2/5/2020 7:09:11 AM","2020-11-02","Observation","Ship Staff","Ship Staff Insp.","Cargo compressor no 3 Suction temp gauge erratic","Cargo Mach.","Cargo / Ballast Systems","Equipment Related","8.33","High","","","Gauge to be renwed","2020-12-31","","In progress",null,"No","No","No","Internal"]
[null,null,null,null,11765,"73_2/5/2020 8:49:43 PM","2020-11-04","Critical Equipment","Ship Staff","Ship Staff Insp.","Emergency fire pp on/off switch damaged","Critical Equip.","Safety / LSA / FFA","Equipment Related,Human Error","5.41","Very High","","","Switch to be replaced","2020-12-04","","Not Started",null,"No","No","No","Internal"]
[null,null,null,null,11763,"73_2/5/2020 8:39:32 PM","2020-11-06","Observation","Ship Staff","Ship Staff Insp.","Log Printer out of order","Documentation","Eng. / Strg. Comp.","Equipment Related,Human Error","10.32","Very High","","","To make operational trouble shooting in progress","2020-12-06","","In progress",null,"No","No","No","Internal"]
[null,null,null,null,11768,"73_2/5/2020 9:03:23 PM","2020-11-06","Observation","Ship Staff","Ship Staff Insp.","ME Local MNVR stand \"SLOW DOWN\",C/R,\"ASTERN\", ME TRIP Indication Light not working","Elect. Mach. & Equip.","Eng. / Strg. Comp.","Equipment Related,Human Error","10.32","Very High","","","Lights to be changed with Spare","2020-12-06","","Not Started",null,"No","No","No","Internal"]
[null,null,null,null,11771,"73_2/5/2020 9:13:49 PM","2020-11-09","Observation","Ship Staff","Ship Staff Insp.","Engine control Console nemurous Light Indication not working","Elect. Mach. & Equip.","Eng. / Strg. Comp.","Equipment Related,Human Error","10.32","Very High","","","AllNon operational Light to replace after receiving spares.","2020-12-08","MLON200011","In progress",null,"No","No","No","Internal"]
[null,null,null,null,11764,"73_2/5/2020 8:44:54 PM","2020-11-13","Observation","Ship Staff","Ship Staff Insp.","Engine room workshop port side door handle Loose","Miscellaneous","Eng. / Strg. Comp.","Equipment Related,Human Error","10.32","Very High","","","Door Lock to repair","2020-11-30","","Not Started",null,"No","No","No","Internal"]
[null,null,null,null,11757,"73_2/5/2020 4:56:54 PM","2020-11-14","Observation","Ship Staff","Ship Staff Insp.","Waste oil settling and Service sounding arrangement not operational","Miscellaneous","Eng. / Strg. Comp.","Equipment Related","10.32","Very High","","","Tank to be emptied and make operational","2020-12-13","","Not Started",null,"No","No","No","Internal"]
[null,null,null,null,11756,"73_2/5/2020 7:34:04 AM","2020-11-15","Observation","Ship Staff","Ship Staff Insp.","STBD Life boat marking on starter panel for start/stop ,on/off not readable","LSA / FFA","Safety / LSA / FFA","Human Error","5.29","High","","","TO  stenciled","2020-11-30","","Not Started",null,"No","No","No","Internal"]
[null,null,null,null,11752,"73_2/5/2020 4:05:48 PM","2020-11-20","Observation","Ship Staff","Ship Staff Insp.","Steering gear room door entrance to engine room door Lock handle Looose","Miscellaneous","Eng. / Strg. Comp.","Equipment Related","10.42","Medium","","","Door to be repaired","2020-11-30","","Not Started",null,"No","No","No","Internal"]

{"sheet":"Completed","index":1,"n_rows":68,"n_cols":28,"rows_kept":68,"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","22-Dec-2020",null,null,"Ship Name","MING LONG (15-05-2020)"]
[]
[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,11813,"73_3/5/2020 8:16:36 am","2020-04-26","Defect","Ship Staff","Nav Audit / Verification","Air bubble in magnetic compass bowl","Navigation - Others","Navigation","Equipment Related",4.9000000000000004,"Medium","Not Applicable","Not Applicable","Existing compass replaced with spare onboard","2020-05-07",null,"Completed","2020-04-26","No","No","No","Internal"]
[null,null,null,null,11777,"73_2/5/2020 10:25:21 PM","2020-05-02","Observation","Ship Staff","Ship Staff Insp.","FO bunker Line near break of accomodation two branch valves for Venting  and air connection for pressure testing purpose in poor condition","Deck - Pipe / Fittings","General Appearance","Equipment Related",6.7,"High","Not Applicable","Not Applicable","Valves replaced.","2020-08-01",null,"Completed","2020-06-11","No","No","No","Internal"]
[null,null,null,null,11778,"73_2/5/2020 10:37:04 PM","2020-05-02","Observation","Ship Staff","Ship Staff Insp.","All pressure/temp  gauge on deck for cargo ,bunker fire line are not  covered with canvas to avoid corrosion","Deck - Pipe / Fittings","General Appearance","Knowledge Based",11.8,"Low","Not Applicable","Not Applicable","Covers  fabricated with canvas","2020-08-02",null,"Completed","2020-07-22","No","No","No","Internal"]
[null,null,null,null,11780,"73_2/5/2020 10:58:40 PM","2020-05-02","Defect","Ship Staff","Ship Staff Insp.","Fwd Mooring/windlass  winches hydraulic pump cooler Cooling water outlet pipe temp. connected with flexible pipe and kept on deck.","Deck - Mooring Machinery","Mooring","Equipment Related",9.1999999999999993,"Very High","Not Applicable","Not Applicable","Overboard pipe or Valve suspecting clogged which passing through fore peak tank same emptied and  rectified","2020-08-02",null,"Completed","2020-06-30","No","No","No","Internal"]
[null,null,null,null,11781,"73_3/5/2020 10:59:56 AM","2020-05-02","Defect","Ship Staff","Ship Staff Insp.","Mooring winch gear cover plate corroded.","Deck - Mooring Machinery","Mooring","Equipment Related",9.14,"Medium","Not Applicable","Not Applicable","Crop & Renew plate","2020-08-02",null,"Completed","2020-07-02","Yes","No","No","Internal","transfer to refman"]
[null,null,null,null,11783,"73_3/5/2020 11:15:23 AM","2020-05-02","Critical Equipment,Defect","Ship Staff","Ship Staff Insp.","Cargo tank dome No.1.Forward starboard side Water spray line deck support structure corroded.","Deck - Pipe / Fittings,LSA / FFA","Safety / LSA / FFA","Equipment Related",8.73,"Medium","Not Applicable","Not Applicable","Crop & Renew support structure","2020-07-31",null,"Completed","2020-07-30","Yes","No","No","Internal","transfer to refman"]
[null,null,null,null,11784,"73_3/5/2020 11:24:11 AM","2020-05-02","Critical Equipment,Defect","Ship Staff","Ship Staff Insp.","Insulation of tank dome for cargo tank No.1,2,3 & 4 Damaged.","Cargo Mach.,Critical Equip.,Deck - Pipe / Fittings","Cargo / Ballast Systems","Equipment Related",8.4499999999999993,"High","Not Applicable","Not Applicable","Insulation to be renewed","2020-08-02",null,"Completed","2020-07-04","Yes","No","No","Internal","tranfer to refman"]
[null,null,null,null,11786,"73_3/5/2020 11:57:39 AM","2020-05-02","Defect","Ship Staff","Ship Staff Insp.","Flange & penetration pipe in forcastle for DCP line to fixed fire fighting system in fore peak store heavily corroded.","Critical Equip.,Deck - Pipe / Fittings,LSA / FFA","Safety / LSA / FFA","Equipment Related",8.68,"Medium","Not Applicable","Not Applicable","Crop & Renewal required","2020-08-02",null,"Completed","2020-06-26","Yes","No","No","Internal","Trandr to REFMAN; meanwhile make cold work as necessary"]
[null,null,null,null,11789,"73_3/5/2020 12:11:45 PM","2020-05-02","Defect","Ship Staff","Ship Staff Insp.","Electrical conduit piping corroded in forecastle near fwd winches.","Deck - Pipe / Fittings","Emgcy. Systems","Equipment Related",11.4,"Very High","Not Applicable","Not Applicable","Cropped and pipe conduit renewed","2020-08-02",null,"Completed","2020-07-22","No","No","No","Internal","Trandr to REFMAN"]
[null,null,null,null,11790,"73_3/5/2020 12:18:53 PM","2020-05-02","Defect","Ship Staff","Ship Staff Insp.","Cooling sea water line for hydraulic power pack in forepeak store leaking,corroded.Starboard side.","Deck - Mooring Machinery,Deck - Pipe / Fittings","Emgcy. Systems","Equipment Related",11.4,"Very High","Not Applicable","Not Applicable","Cropped and piping renewed","2020-08-02",null,"Completed","2020-05-30","No","No","No","Internal"]
[null,null,null,null,11791,"73_3/5/2020 12:24:13 PM","2020-05-02","Defect","Ship Staff","Ship Staff Insp.","Air line for foreward , starboard side mooring capstan corroded.","Deck - Mooring Machinery,Deck - Pipe / Fittings","Emgcy. Systems","Equipment Related",11.4,"Very High","Not Applicable","Not Applicable","Cropped and piping renewed","2020-08-02",null,"Completed","2020-08-01","No","No","No","Internal","DEFECT MOVED TO REFMAN"]
[null,null,null,null,11793,"73_3/5/2020 12:34:10 PM","2020-05-02","Defect","Ship Staff","Ship Staff Insp.","No.1 Cargo tank electrical wiring conduit cover box base frame  corroded.","Cargo Mach.,Elect. Mach. & Equip.","Cargo / Ballast Systems","Equipment Related",11.4,"Very High","Not Applicable","Not Applicable","Crop & renewal of base frame. To be done in DD. Entered in DD Spec Job No. DK1","2021-12-30",null,"Completed","2020-12-22","Yes","No","No","Internal","DEFECT MOVED TO REFMAN"]
[null,null,null,null,11794,"73_3/5/2020 11:52:03 AM","2020-05-02","Defect","Ship Staff","Ship Staff Insp.","Fixed firefighting DCP metal control box ,handle & door corroded.","Critical Equip.,LSA / FFA","Safety / LSA / FFA","Equipment Related",8.68,"Medium","Not Applicable","Not Applicable","Crop & renewal of base frame. To be done in DD. Entered in DD Spec Job No. SAF.1","2021-12-31",null,"Completed","2020-12-22","Yes","No","No","Internal","DEFECT MOVED TO REFMAN"]
[null,null,null,null,11796,"73_3/5/2020 12:38:19 PM","2020-05-02","Defect","Ship Staff","Ship Staff Insp.","Gas sampling point penetration point/piping for No.1 Hold space aft and No.2 Hold space fwd corroded.","Critical Equip.,Deck - Pipe / Fittings","Emgcy. Systems","Equipment Related",8.41,"Very High","Not Applicable","Not Applicable","Crop & renewal . To be done in DD. Entered in DD Spec Job No. S8.2","2021-10-31",null,"Completed","2020-12-22","Yes","No","No","Internal","DEFECT MOVED TO REFMAN"]
[null,null,null,null,11815,"73_2/5/2020 4:09:33 PM","2020-05-02","Observation","Ship Staff","Ship Staff Insp.","Boiler Hotwell Observation tank Manhole Cover have hole one place and all Bolts broken ","E/R - Boiler","Eng. / Strg. Comp.","Equipment Related",10.32,"Very High","Not Applicable","Not Applicable","Cover hole filedl up and broken bolts to remove and secure with new bolts.All bolts removed and fresh bolts put and hole filled up with welding","2020-08-02",null,"Completed","2020-05-04","No","No","No","Internal"]
[null,null,null,null,11741,"73_2/5/2020 7:12:24 AM","2020-05-02","Observation","Ship Staff","Ship Staff Insp.","All Four Cargo tank dome  Insulation in poor condition and damaged","Cargo Mach.","Cargo / Ballast Systems","Equipment Related",8.4499999999999993,"High","Not Applicable","Not Applicable","Insulation renewal out of scope for ship staff can be done external skilled worker.To be done in DD. Entered in DD Spec Job No. S8.3","2021-10-31",null,"Completed","2020-12-22","Yes","No","No","Internal","DEFECT MOVED TO REFMAN"]
[null,null,null,null,11742,"73_2/5/2020 7:16:48 AM","2020-05-02","Observation","Ship Staff","Ship Staff Insp.","All Four Cargo tank dome Manhole cover insulation covers are damaged","Cargo Mach.","Cargo / Ballast Systems","Equipment Related",8.4499999999999993,"High","Not Applicable","Not Applicable","Job of out of scope for ship staff can be done during next drydock or office to engage some workshop to make as per sample. To be done in DD. Entered in DD Spec Job No. S8.4","2021-10-31",null,"Completed","2020-12-22","Yes","No","No","Internal","DEFECT MOVED TO REFMAN."]
[null,null,null,null,11743,"73_2/5/2020 7:20:02 AM","2020-05-02","Defect","Ship Staff","Ship Staff Insp.","Pin hole on bulkhead between Ballast tank no4 and cargo hold space no 4","Hull & Tanks","Structural Condn. / WT integrity ","Equipment Related",8.18,"High","Not Applicable","Not Applicable","Can be repaired during next DD.Entered in DD Spec Job No. S8.5","2021-10-31",null,"Completed","2020-12-22","Yes","No","No","Internal","DEFECT MOVED TO REFMAN"]
[null,null,null,null,11746,"73_2/5/2020 7:31:01 AM","2020-05-02","Observation","Ship Staff","Ship Staff Insp.","Cargo Manifold PORT/STBD temp and pressure gauge securing panels wasted.","Deck - Pipe / Fittings","General Appearance","Equipment Related",8.6,"Very High","Not Applicable","Not Applicable","Required Hot work inplace can be done during next DD.Entered in DD Spec Job No. S8.6","2021-10-31",null,"Completed","2020-12-22","Yes","No","No","Internal","TRANSFER TO REFMAN/ DD"]
[null,null,null,null,11779,"73_2/5/2020 10:49:32 PM","2020-06-14","Observation","Owner / Marine / Tech. Suptd.","ISM Audit","W/T door dogs to be overhauled and a day light / chalk test undertaken to ensure tightness for (Motor room + Dry powder lockers on deck + fore peak store entrance + mid-ship stores + around accommodation)","Deck - Pipe / Fittings","Structural Condn. / WT integrity ","Inappropriate Procedure",8.8000000000000007,"High","Not Applicable","Not Applicable","Doors seals renewed and dogs overhauled.","2020-09-13",null,"Completed","2020-06-20","Yes","No","No","Internal","please transfer to REFMAN"]
[null,null,null,null,11785,"73_3/5/2020 11:31:30 AM","2020-06-14","Observation","Owner / Marine / Tech. Suptd.","ISM Audit","Fuel oil over flow bins around the accommodation only have capacity stencilled – but which tank it services was not available. Pl stencil name of each tank","Deck - Machinery,Hull & Tanks","Eng. / Strg. Comp.","Knowledge Based",6.2,"Very High","Not Applicable","Not Applicable","Tank name stencilled and reported","2020-09-13",null,"Completed","2020-06-17","No","No","No","Internal","Trandr to REFMAN"]
[null,null,null,null,11787,"73_3/5/2020 12:02:28 PM","2020-06-14","Defect","Owner / Marine / Tech. Suptd.","ISM Audit","A hydraulic leak was sighted in way of mid-ship crane – this is a pollution hazard as its monsoon season and leaked oil overboard will cause oil sheen in water","Deck - Pipe / Fittings","MARPOL Related","Equipment Related",8.73,"Medium","Not Applicable","Not Applicable","Leak rectified and reported","2020-09-13",null,"Completed","2020-06-17","No","No","No","Internal","Trandr to REFMAN"]
[null,null,null,null,11814,"73_3/5/2020 4:16:17 PM","2020-08-01","Defect","Ship Staff","Ship Staff Insp.","Ballast pump no 2 Inlet/Discharge valves internally leaking","E/R - Pipes/ valves & fittings","Eng. / Strg. Comp.","Equipment Related",10.32,"Very High","Not Applicable","Not Applicable","Valves  o/hauled.Now running satisfactorily","2020-09-30",null,"Completed","2020-09-04","No","No","No","Internal"]
[null,null,null,null,11806,"73_3/5/2020 4:18:49 PM","2020-08-10","Defect","Ship Staff","Ship Staff Insp.","AE 3 Fuel injection pipe unit no. 2 leaking","E/R - Aux. Engine","Eng. / Strg. Comp.","Equipment Related",10.32,"Very High","Not Applicable","Not Applicable","Fuel Injection pipe  renewed.","2020-11-10",null,"Completed","2020-09-08","No","No","No","Internal"]
[null,null,null,null,11807,"73_3/5/2020 4:21:10 PM","2020-08-12","Defect","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Water ballast remote level gauging display showing error. Same to be checked and rectified","Hull & Tanks","Structural Condn. / WT integrity ","Equipment Related",8.15,"Medium","Not Applicable","Not Applicable","Renewed with spare sensors and made opertional","2020-11-30",null,"Completed","2020-11-19","No","No","No","Internal"]
[null,null,null,null,15104,"73_Tue Nov 24 2020 04:32:09 GMT+0000","2020-08-12","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","IG air compressor to open and ovehaul","Cargo Mach.","Cargo / Ballast Systems","Equipment Related",8.5,"High","Not Applicable","Not Applicable","Overhauled and tested satisfactrorily","2020-11-30",null,"Completed","2020-11-20","No","No","No","Internal"]
[null,null,null,null,15105,"73_Tue Nov 24 2020 04:33:45 GMT+0000","2020-08-12","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Sea water system for cargo plant modification as discussed- To input in  DD SPECS (REFMAN)","Cargo Mach.","Cargo / Ballast Systems","Equipment Related",8.33,"High","Not Applicable","Not Applicable","REFMAN SPECS created.Job S8.1","2020-11-30",null,"Completed","2020-11-24","Yes","No","No","Internal"]
[null,null,null,null,15106,"73_Tue Nov 24 2020 04:35:18 GMT+0000","2020-08-12","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Structural condition of many secondary members on deck and cargo compressor room was found wasted. While many of these require hot work and should have been attended to in the DD (put in REFMAN); attempts will be made to fix the important ones with cold work or alternative means.","Cargo Mach.,Deck - Pipe / Fittings","Structural Condn. / WT integrity ","Equipment Related",8.33,"High","Not Applicable","Not Applicable","Spec created in REFMAN. Job S7.1. Additionally stores requisition raised for cold work","2021-12-31","MLON200190","Completed","2020-11-24","Yes","No","No","Internal","TRAMFWER IN REFMAN"]
[null,null,null,null,15107,"73_Tue Nov 24 2020 04:36:46 GMT+0000","2020-08-12","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Both forward windlasses have extreme vibrations while operations. This will need to be investigated as this is abnormal. Suspect excess clearances due to improper greasing. To investigate and revert.","Deck - Mooring Machinery","Mooring","Equipment Related",9.1999999999999993,"Medium","Not Applicable","Not Applicable","Old grease removed, clearance checked. New grease renwed. Running satisafctorily.","2020-09-30",null,"Completed","2020-09-12","No","No","No","Internal"]
[null,null,null,null,15108,"73_Tue Nov 24 2020 04:38:24 GMT+0000","2020-08-12","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Garbage compactor supplied – same to install and commissioned.","Miscellaneous","MLC Related","Equipment Related",11.13,"Low","Not Applicable","Not Applicable","Installed and working well","2020-10-31",null,"Completed","2020-10-02","No","No","No","Internal"]
[null,null,null,null,15109,"73_Tue Nov 24 2020 04:40:33 GMT+0000","2020-08-12","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Reefer system reported to have excessive leaks – same to check by crew first and then arrange shore assistance if required.","E/R - Aux. Mach.","MLC Related","Equipment Related",10.119999999999999,"Very High","Not Applicable","Not Applicable","System checked and tested, leaks arrested - running satisfactorily.","2020-10-31",null,"Completed","2020-10-16","No","No","No","Internal"]
[null,null,null,null,15110,"73_Tue Nov 24 2020 04:42:41 GMT+0000","2020-08-12","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Cargo tank dome covers No.1 and No.2 to repair and upgrade","Deck - Machinery","Cargo / Ballast Systems","Equipment Related",8.15,"Medium","Not Applicable","Not Applicable","Tank dome covers repaired and coated with fresh paint","2020-11-30",null,"Completed","2020-09-10","No","No","No","Internal","HAS BEEN VERIFIED ON 6TH NOV"]
[null,null,null,null,15120,"73_Tue Nov 24 2020 05:54:02 GMT+0000","2020-08-12","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Provision crane port side – to stencil in Bold RED – not to be used.","Deck - Machinery","Structural Condn. / WT integrity ","Equipment Related",8.73,"Medium","Not Applicable","Not Applicable","Stencilled in RED.","2020-09-30",null,"Completed","2020-09-18","No","No","No","Internal"]
[null,null,null,null,15121,"73_Tue Nov 24 2020 05:56:08 GMT+0000","2020-08-12","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Both gang ways to chip and paint","Deck - Machinery","General Appearance","Equipment Related",5.47,"Low","Not Applicable","Not Applicable","Both gang ways chipped and painted","2020-09-30",null,"Completed","2020-09-23","No","No","No","Internal"]
[null,null,null,null,15124,"73_Tue Nov 24 2020 06:02:42 GMT+0000","2020-08-12","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Air leaks in gang way winch line to arrest","Deck - Pipe / Fittings","Cargo / Ballast Systems","Equipment Related",5.47,"Low","Not Applicable","Not Applicable","Valves overhauled and air leaks arrested","2020-10-31",null,"Completed","2020-10-17","No","No","No","Internal"]
[null,null,null,null,15125,"73_Tue Nov 24 2020 06:04:10 GMT+0000","2020-08-12","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Water in oil sensor (Aw) monitor to install","E/R - Main Engine","Eng. / Strg. Comp.","Equipment Related",10.7,"Medium","Not Applicable","Not Applicable","Installed as discussed with office","2020-11-30",null,"Completed","2020-11-13","No","No","No","Internal"]
[null,null,null,null,15127,"73_Tue Nov 24 2020 06:06:35 GMT+0000","2020-08-12","Critical Equipment,Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","DG No.1 – exhaust gas parameters not balanced. Same to investigate (renew fuel pump of affected units as discussed).","E/R - Aux. Engine","Eng. / Strg. Comp.","Equipment Related",10.32,"Very High","Not Applicable","Not Applicable","Fuel pumps (2 numbers) as discussed with office renewed and adjustments carried out. Running satisfactorily","2020-11-30",null,"Completed","2020-11-09","No","No","No","Internal"]
[null,null,null,null,15129,"73_Tue Nov 24 2020 06:12:14 GMT+0000","2020-08-12","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Sea water soft patch on the MGPS line to repair","E/R - Pipes/ valves & fittings","Eng. / Strg. Comp.","Equipment Related",10.31,"Very High","Not Applicable","Not Applicable","Line renewed and put back in place. All satisfactory","2020-10-31",null,"Completed","2020-10-15","No","No","No","Internal"]
[null,null,null,null,15130,"73_Tue Nov 24 2020 06:13:59 GMT+0000","2020-08-12","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Funnel flaps-remove old grease and put new grease. Once closed, there should be no light when closed (horizontal flaps)","Miscellaneous","Eng. / Strg. Comp.","External Factors",10.32,"Very High","Not Applicable","Not Applicable","Old grease removed and line cleared. Grease renewed. Checked for sealing when flaps closed. All satisfactory","2020-09-30",null,"Completed","2020-09-16","No","No","No","Internal"]
[null,null,null,null,15132,"73_Tue Nov 24 2020 06:16:03 GMT+0000","2020-08-12","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Few non certified extensions are causing low insulation (110V). To remove and use certified ones.","Accommodation","MLC Related","Equipment Related",10.38,"Medium","Not Applicable","Not Applicable","Renewed with certified ones. All satisafctory","2020-09-30",null,"Completed","2020-09-24","No","No","No","Internal"]
[null,null,null,null,15133,"73_Tue Nov 24 2020 06:17:16 GMT+0000","2020-08-12","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","VPMS data to enter and reporting to activate","Miscellaneous","ISM Related","Equipment Related",10.119999999999999,"Very High","Not Applicable","Not Applicable","Entries made and liaised with PAL help desk","2020-11-30",null,"Completed","2020-11-06","No","No","No","Internal"]
[null,null,null,null,15170,"73_Tue Nov 24 2020 06:18:47 GMT+0000","2020-08-12","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Wheel house port side window frame holed. Same to repair with cold work filling","Accommodation","Navigation","Equipment Related",11.6,"Medium","Not Applicable","Not Applicable","Cold repaired. All satisfactory.","2020-10-31",null,"Completed","2020-10-21","No","No","No","Internal"]
[null,null,null,null,15172,"73_Tue Nov 24 2020 06:20:43 GMT+0000","2020-08-12","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Most of the cargo piping on the deck has corroded U-clamps. To renew gradually","Deck - Pipe / Fittings","Cargo / Ballast Systems","Equipment Related",11.5,"Medium","Not Applicable","Not Applicable","Major clamps renewed as marked by Superitendant","2020-11-30",null,"Completed","2020-11-20","No","No","No","Internal"]
[null,null,null,null,15178,"73_Tue Nov 24 2020 06:27:19 GMT+0000","2020-08-12","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Both chain stopper locking pins to remove and make free","Deck - Mooring Machinery","Mooring","Equipment Related",9.6,"Low","Not Applicable","Not Applicable","Removed pins, polished and fitted back.","2020-10-31",null,"Completed","2020-10-23","No","No","No","Internal"]
[null,null,null,null,15177,"73_Tue Nov 24 2020 06:23:49 GMT+0000","2020-08-12","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Some of the rollers are not rotating. Same shown to Ch Officer – to be freed","Deck - Machinery","Mooring","Equipment Related",9.18,"Low","Not Applicable","Not Applicable","Rollers freed and greased - now rotating free; being regularly moved","2020-09-30",null,"Completed","2020-09-20","No","No","No","Internal"]
[null,null,null,null,15128,"73_Tue Nov 24 2020 06:10:31 GMT+0000","2020-08-24","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","STP transparent tubes to clean; also no fluid observed to be flowing. Same to investigate and repair","Miscellaneous","Eng. / Strg. Comp.","Equipment Related",10.32,"Very High","Not Applicable","Not Applicable","Pipe dismantled and cleaned; all satisfactory.","2020-09-30",null,"Completed","2020-09-13","No","No","No","Internal"]
[null,null,null,null,11808,"73_4/5/2020 1:10:58 PM","2020-09-18","Defect,Non Conformity","Ship Staff","Ship Staff Insp.","During inspection of deck machinery, it was observed that few grease nipples broken / jammed.  ","Cargo Mach.","Cargo / Ballast Systems","Equipment Related",8.33,"High","Not Applicable","Not Applicable","Same cleared and some of them renewed.All okay now","2020-12-17",null,"Completed","2020-09-20","No","No","No","Internal","DEFECT MOVED TO REFMAN"]
[null,null,null,null,11810,"73_4/5/2020 1:14:45 PM","2020-10-01","Defect","Ship Staff","Ship Staff Insp.","Refrigeration system has minor leakage. Every 15days need to be charged","Miscellaneous","Eng. / Strg. Comp.","Equipment Related",10.32,"Very High","Not Applicable","Not Applicable","Troubleshooting carried out and leaks rectified.","2020-11-30",null,"Completed","2020-11-02","No","No","No","Internal"]
[null,null,null,null,11795,"73_3/5/2020 11:35:56 AM","2020-10-02","Defect","Ship Staff","Ship Staff Insp.","Hot water calorifier temp controller not working","Accommodation","MLC Related","Equipment Related",11.13,"Low","Not Applicable","Not Applicable","Controller renewed","2021-01-02","MLON200183","Completed","2020-12-16","No","No","No","Internal","DEFECT MOVED TO REFMAN"]
[null,null,null,null,11812,"73_4/5/2020 7:27:47 PM","2020-10-25","Defect","Ship Staff","Ship Staff Insp.","Gantry crane for Provision STBD Side trolley travelling track teeth  in poor condtion","Deck - Machinery,Miscellaneous","General Appearance","Equipment Related",8.73,"Medium","Not Applicable","Not Applicable","Track derusted and hydroblasted. Rack and roller greased. Running satisafctorily","2021-01-25",null,"Completed","2020-12-04","No","No","No","Internal","DEFECT MOVED TO REFMAN"]
[null,null,null,null,11788,"73_3/5/2020 12:05:15 PM","2020-11-19","Non Conformity","Ship Staff","Ship Staff Insp.","Ballast Pump No.2 inoperational","E/R - Pumps","Structural Condn. / WT integrity ","Equipment Related",10.31,"Very High","Not Applicable","Not Applicable","Pump overhauled. All satisafactory","2020-12-05",null,"Completed","2020-11-25","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":379,"n_cols":3,"rows_kept":379,"cut":false,"hidden":true,"merged":[]}
["VIQ_ref_no","Risk Value of observation","ID"]
["1.1","Low",10160]
["1.10","Low",10169]
["1.11","Low",10170]
["1.12","Low",10171]
["1.13","Low",10172]
["1.14","Low",10173]
["1.15","Low",10174]
["1.16","Low",10176]
["1.17","Low",10177]
["1.18","Low",10178]
["1.19","Low",10179]
["1.2","Low",10161]
["1.20","Low",10180]
["1.21","",10181]
["1.22","Low",10183]
["1.23","Low",10184]
["1.24","Low",10185]
["1.25","Low",10186]
["1.26","Low",10187]
["1.3","Low",10162]
["1.4","Low",10163]
["1.5","Low",10164]
["1.6","Low",10165]
["1.7","Low",10166]
["1.8","Low",10167]
["1.9","Low",10168]
["1.99","High",16296]
["10.1","Medium",10354]
["10.10","High",10363]
["10.11","Medium",10364]
["10.12","Very High",10365]
["10.13","Very High",10366]
["10.14","Medium",10367]
["10.15","Low",10368]
["10.16","Very High",10369]
["10.17","Very High",10370]
["10.18","High",10371]
["10.19","Very High",10372]
["10.2","Low",10355]
["10.20","High",10373]
["10.21","Medium",10374]
["10.22","Low",10375]
["10.23","Medium",10376]
["10.24","Low",10377]
["10.25","Very High",10378]
["10.26","High",10379]
["10.27","Medium",10380]
["10.28","Low",10381]
["10.29","Medium",10382]
["10.3","Medium",10356]
["10.30","High",10383]
["10.31","Very High",10384]
["10.32","Very High",10385]
["10.33","High",10386]
["10.34","High",10387]
["10.35","Very High",10388]
["10.36","Very High",10389]
["10.37","Medium",10390]
["10.38","Medium",10391]
["10.39","High",10392]
["10.4","High",10357]
["10.40","Medium",10393]
["10.41","Medium",10394]
["10.42","Medium",10395]
["10.43","Medium",10396]
["10.44","Medium",10397]
["10.45","Very High",10398]
["10.46","High",10399]
["10.47","Medium",10400]
["10.48","High",10401]
["10.49","Medium",10402]
["10.5","Low",10358]
["10.50","High",10403]
["10.51","Low",10404]
["10.52","Medium",10405]
["10.53","Medium",10406]
["10.54","High",10407]
["10.55","Low",10408]
["10.6","Very High",10359]
["10.7","Medium",10360]
["10.8","Medium",10361]
["10.9","Medium",10362]
["10.99","High",10409]
["11.1","High",10313]
["11.10","Medium",10322]
["11.11","Very High",10323]
["11.12","Low",10324]
["11.13","Low",10325]
["11.14","Medium",10326]
["11.15","Low",10327]
["11.16","Low",10328]
["11.17","Low",10329]
["11.2","Medium",10314]
["11.3","Medium",10315]
["11.4","Very High",10316]
["11.5","Medium",10317]
["11.6","Medium",10318]
["11.7","High",10319]
["11.8","Low",10320]
["11.9","Low",10321]
["11.99","High",10330]
["12.1","High",10331]
["12.10","High",10341]
["12.11","High",10342]
["12.12","High",10343]
["12.13","High",10344]
["12.14","High",10345]
["12.15","High",10346]
["12.16","High",10347]
["12.17","High",10348]
["12.18","High",10349]
["12.19","High",10350]
["12.2","High",10332]
["12.20","High",10351]
["12.21","High",10352]
["12.3","High",10334]
["12.4","High",10335]
["12.5","High",10336]
["12.6","High",10337]
["12.7","High",10338]
["12.8","High",10339]
["12.9","High",10340]
["12.99","High",10353]
["2.1","Very High",10190]
["2.1.9","Very High",16297]
["2.10","Medium",10198]
["2.11","Medium",10199]
["2.12","Low",10200]
["2.13","Low",10201]
["2.14","Low",10202]
["2.15","Low",10203]
["2.16","Medium",10204]
["2.2","Medium",10191]
["2.3","High",10189]
["2.4","Medium",10192]
["2.5","Medium",10193]
["2.6","Low",10194]
["2.7","High",10195]
["2.8","High",10196]
["2.9","Medium",10197]
["2.99","High",10205]
["3.1","High",10206]
["3.2","Very High",10207]
["3.3","High",10208]
["3.4","Low",10188]
["3.5","Medium",10209]
["3.6","High",10210]
["3.7","Very High",10211]
["3.8","Very High",10212]
["3.99","High",10213]
["4.1","High",10214]
["4.10","High",10223]
["4.11","Medium",10224]
["4.12","Very High",10225]
["4.13","Very High",10226]
["4.14","Very High",10227]
["4.15","Very High",10228]
["4.16","Very High",10229]
["4.17","Very High",10230]
["4.18","Very High",10231]
["4.19","Low",10232]
["4.2","Medium",10215]
["4.20","Very High",10233]
["4.21","High",10234]
["4.22","Low",10235]
["4.23","High",10236]
["4.24","High",10237]
["4.25","Low",10238]
["4.26","Low",10239]
["4.27","High",10240]
["4.3","Medium",10216]
["4.4","High",10217]
["4.5","Very High",10218]
["4.6","Medium",10219]
["4.7","High",10220]
["4.8","Medium",10221]
["4.9","Medium",10222]
["4.99","High",10241]
["5.1","Very High",10410]
["5.10","High",10419]
["5.11","Low",10420]
["5.12","Medium",10421]
["5.13","High",10422]
["5.14","Very High",10423]
["5.15","Medium",10424]
["5.16","Medium",10425]
["5.17","Very High",10426]
["5.18","High",10427]
["5.19","Medium",10428]
["5.2","Very High",10411]
["5.20","Medium",10429]
["5.21","Medium",10430]
["5.22","High",10432]
["5.23","Very High",10433]
["5.24","Very High",10434]
["5.25","Medium",10435]
["5.26","Medium",10436]
["5.27","Medium",10437]
["5.28","Very High",10438]
["5.29","High",10439]
["5.3","Low",10412]
["5.30","High",10440]
["5.31","High",10441]
["5.32","High",10442]
["5.33","High",10443]
["5.34","Low",10444]
["5.35","Medium",10445]
["5.36","Low",10446]
["5.37","Low",10447]
["5.38","High",10448]
["5.39","Very High",10449]
["5.4","High",10413]
["5.40","Very High",10450]
["5.41","Very High",10451]
["5.42","Medium",10452]
["5.43","High",10453]
["5.44","High",10454]
["5.45","Medium",10457]
["5.46","Medium",10458]
["5.47","Low",10459]
["5.48","Medium",10460]
["5.5","Low",10414]
["5.6","Low",10415]
["5.7","Medium",10416]
["5.8","Medium",10417]
["5.9","Very High",10418]
["5.99","High",10461]
["6.1","Medium",10242]
["6.10","Low",10251]
["6.11","High",10252]
["6.12","Medium",10253]
["6.13","Low",10254]
["6.14","High",10255]
["6.15","High",10256]
["6.16","Very High",10257]
["6.17","Very High",10258]
["6.18","Medium",10259]
["6.19","Low",10260]
["6.2","High",10243]
["6.20","Medium",10261]
["6.21","High",10262]
["6.22","Medium",10263]
["6.3","Low",10244]
["6.4","High",10245]
["6.5","Low",10246]
["6.6","Medium",10247]
["6.7","High",10248]
["6.8","High",10249]
["6.9","Low",10250]
["6.99","High",10264]
["7.1","High",10265]
["7.10","High",10274]
["7.11","High",10275]
["7.12","High",10276]
["7.13","Medium",10277]
["7.14","Medium",10278]
["7.15","High",10279]
["7.16","High",10280]
["7.17","High",10281]
["7.2","High",10266]
["7.3","Low",10267]
["7.4","Low",10268]
["7.5","Low",10269]
["7.6","Medium",10270]
["7.7","Low",10271]
["7.8","High",10272]
["7.9","High",10273]
["7.99","High",10282]
["8.1","Very High",10462]
["8.10","Very High",10471]
["8.11","Very High",10472]
["8.12","Medium",10473]
["8.13","High",10474]
["8.14","Very High",10475]
["8.15","Medium",10476]
["8.16","Medium",10477]
["8.17","Very High",10478]
["8.18","High",10479]
["8.19","Very High",10480]
["8.2","Medium",10463]
["8.20","Very High",10481]
["8.21","Very High",10482]
["8.22","High",10483]
["8.23","Medium",10484]
["8.24","High",10485]
["8.25","High",10486]
["8.26","Medium",10487]
["8.27","Medium",10488]
["8.28","High",10489]
["8.29","Medium",10491]
["8.3","Medium",10464]
["8.30","Very High",10492]
["8.31","Very High",10493]
["8.32","High",10494]
["8.33","High",10495]
["8.34","Very High",10496]
["8.35","Very High",10497]
["8.36","Very High",10498]
["8.37","Very High",10500]
["8.38","Very High",10501]
["8.39","Very High",10502]
["8.4","Medium",10465]
["8.40","Very High",10503]
["8.41","Very High",10504]
["8.42","Very High",10505]
["8.43","Very High",10506]
["8.44","Medium",10508]
["8.45","High",10509]
["8.46","High",10510]
["8.47","Medium",10511]
["8.48","Very High",10512]
["8.49","Medium",10513]
["8.5","Medium",10466]
["8.50","High",10514]
["8.51","Very High",10515]
["8.52","Very High",10516]
["8.53","Very High",10517]
["8.54","High",10518]
["8.55","High",16222]
["8.56","Very High",16223]
["8.57","Very High",16224]
["8.58","Very High",16225]
["8.59","Medium",16226]
["8.6","Very High",10467]
["8.60","Medium",16227]
["8.61","Medium",16228]
["8.62","Very High",16229]
["8.63","Very High",16230]
["8.64","High",16231]
["8.65","Very High",16232]
["8.66","Medium",16233]
["8.67","Medium",16234]
["8.68","Medium",16235]
["8.69","Very High",16236]
["8.7","High",10468]
["8.70","Very High",16237]
["8.71","Medium",16238]
["8.72","Very High",16239]
["8.73","Medium",16240]
["8.74","High",16241]
["8.75","High",16242]
["8.76","Medium",16243]
["8.77","Medium",16244]
["8.78","Medium",16245]
["8.79","Very High",16246]
["8.8","High",10469]
["8.9","Very High",10470]
["8.99","High",16266]
["9.1","Low",10283]
["9.10","Medium",10292]
["9.11","Medium",10293]
["9.12","Medium",10294]
["9.13","Low",10295]
["9.14","Medium",10296]
["9.15","Medium",10297]
["9.16","High",10298]
["9.17","High",10299]
["9.18","Low",10300]
["9.19","Low",10301]
["9.2","Very High",10284]
["9.20","Medium",10302]
["9.21","Medium",10303]
["9.22","Low",10304]
["9.23","Low",10305]
["9.24","Medium",10306]
["9.25","Low",10307]
["9.26","Low",10308]
["9.27","Low",10309]
["9.28","Medium",10310]
["9.29","Low",10311]
["9.3","Very High",10285]
["9.4","High",10286]
["9.5","High",10287]
["9.6","Low",10288]
["9.7","Medium",10289]
["9.8","Medium",10290]
["9.9","Medium",10291]
["9.99","High",10312]

{"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"]
["73","MING LONG (15-05-2020)","73_1608620583458.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"]