{"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":6,"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":33,"n_cols":28,"rows_kept":33,"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","11-Dec-2020",null,null,"Ship Name","EPIC"]
[]
[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,14781,"105_Tue Nov 17 2020 10:55:53 GMT+0000","2020-11-10","Observation","Ship Staff","Ship Staff Insp.","Several hatch cover wires are corroded and needs renewal","Cargo Mach.","Cargo / Ballast Systems","External Factors","","","","","Needs wire renewal & on order","2020-11-30","CHAR200010","Not Started",null,"No","No","No","Internal"]
[null,null,null,null,null,"105_15-Dec-20 4:24:21 PM","2020-11-02","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Control air dryer to be replaced with new supplied spare","E/R - Aux. Mach.","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Will be replaced in Next Voyage","2020-12-02",null,"In progress",null,"No",null,null,"Internal"]
[null,null,null,null,null,"105_15-Dec-20 4:37:14 PM","2020-11-02","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","M/E four(4) units exhaust valve upper actuator oil leakages, O-rings renewal to be planned during vessel stay at anchorage","E/R - Main Engine","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Will be carried out at available oppurtunity","2020-12-02",null,"In progress",null,"No",null,null,"Internal"]
[null,null,null,null,null,"105_15-Dec-20 4:45:33 PM","2020-11-02","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Incinerator milling pump oil leakage to rectify","E/R - Aux. Mach.","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Will be carried out","2020-12-02",null,"In progress",null,"No",null,null,"Internal"]
[null,null,null,null,null,"105_15-Dec-20 4:57:38 PM","2020-11-02","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Aux engine Fuel oil press regulating valve leaking-same to be rectified","E/R - Aux. Engine","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Will be carried out at a suitable anchorage","2020-12-02",null,"In progress",null,"No",null,null,"Internal"]
[null,null,null,null,null,"105_15-Dec-20 5:02:49 PM","2020-11-02","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Cascade tank level gauge valve leaks  to be rectified","E/R - Aux. Mach.","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Will be carried out in DD","2020-12-02",null,"Deferred to D D",null,"No",null,null,"Internal"]
[null,null,null,null,null,"105_15-Dec-20 5:10:31 PM","2020-11-02","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Main Air Comp  no. 2  CW inlet flexible pipe leakage  to be rectified","E/R - Air Comp.","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Spares awaited.","2020-12-02",null,"Waiting spare",null,"No",null,null,"Internal"]
[null,null,null,null,null,"105_15-Dec-20 5:30:50 PM","2020-11-02","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Hyd power pack talk level gauge valve leakage to be rectified","Deck - Machinery,E/R - Aux. Mach.","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Will be carried out in DD","2020-12-02",null,"Deferred to D D",null,"No",null,null,"Internal"]
[null,null,null,null,null,"105_15-Dec-20 5:32:23 PM","2020-11-02","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","No. 1 Fuel oil supply  pump M/E oil seal leakage to rectify","E/R - Aux. Mach.","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Spares ordered EPIC200161","2020-12-02","EPIC200161","Waiting spare",null,"No",null,null,"Internal"]
[null,null,null,null,null,"105_15-Dec-20 5:34:04 PM","2020-11-02","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","No. 1 Fuel oil circulating  pump M/E oil seal leakage to rectify","E/R - Aux. Mach.","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Spares ordered EPIC200162","2020-12-02","EPIC200162","Waiting spare",null,"No",null,null,"Internal"]
[null,null,null,null,null,"105_15-Dec-20 5:40:54 PM","2020-11-02","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","A/E no. 1 fuel oil circulating pump oil leakage to rectify","E/R - Aux. Mach.","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Spares ordered EPIC200164","2020-12-02","EPIC200164","Waiting spare",null,"No",null,null,"Internal"]
[null,null,null,null,null,"105_15-Dec-20 5:45:04 PM","2020-11-02","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Change over valve  for A/E fuel oil auto & bypass filter leaking- same to be rectified","E/R - Aux. Mach.","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Will be carried out at available opportunity","2020-11-02",null,"In progress",null,"No",null,null,"Internal"]
[null,null,null,null,null,"105_15-Dec-20 5:55:32 PM","2020-11-02","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Main Engine fuel pump  unit no. 2, 3, 4 & 6 oil leakage to be rectified","E/R - Main Engine","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","To be carried out at DD","2020-12-02",null,"Deferred to D D",null,"No",null,null,"Internal"]
[null,null,null,null,null,"105_15-Dec-20 5:58:47 PM","2020-11-02","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","M/E lube oil auto backwash filter inlet valve gland leakage to be rectified.","E/R - Aux. Mach.","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","To be carried out in DD","2020-12-02",null,"Deferred to D D",null,"No",null,null,"Internal"]
[null,null,null,null,null,"105_15-Dec-20 6:10:30 PM","2020-11-02","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Deck plating  spot-derusting and touch up maintenance to be completed from CH No. 2 to CH No.6","Deck - Pipe / Fittings","General Appearance","Equipment Related",null,null,"Not Applicable","Not Applicable","In Progress","2020-12-02",null,"In progress",null,"No",null,null,"Internal"]
[null,null,null,null,null,"105_15-Dec-20 6:11:44 PM","2020-11-02","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Spot-derusting and touch up maintenance to be completed on the deck pipes & fittings from CH No. 2 to CH No.6","Deck - Pipe / Fittings","General Appearance","Equipment Related",null,null,"Not Applicable","Not Applicable","In Progress","2020-12-03",null,"In progress",null,"No",null,null,"Internal"]

{"sheet":"Completed","index":1,"n_rows":60,"n_cols":28,"rows_kept":60,"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","11-Dec-2020",null,null,"Ship Name","EPIC"]
[]
[null,null,null,null,null,null,"VERSION : 2.0"]
[]
[]
[]
[null,null,null,null,"ID","UNIQUE ID","Date Recorded","Type of Deficiency","Observer code","Type of Inspection","Description of Deficiency","Equipment Categories","Area of Observation","Deficiency Cause","VIQ Ref Number","Risk Value of Obs","PSC Ref Number","PSC MOU ID","Action Taken or Required","Target Date","PO Ref No.","Status Code","Date Completed","Drydock","Info Sharing","Critical Item","Audit Type","Superintendent Remarks"]
[null,null,null,null,null,"105_15/12/2020 9:41:02 AM","2020-08-05","Defect","Owner / Marine / Tech. Suptd.","Suptd. Insp.","No.6 cargo hold aft stbd side hydraulic cylinder seal leaking, to be replaced with overhauled hyd cylinder","Cargo Mach.","Cargo / Ballast Systems","Equipment Related",null,null,"Not Applicable","Not Applicable","Cylinder overhauled at shore workshop. All seals replaced.","2020-08-20","EPIC205083","Completed","2020-08-15","No",null,null,"Internal"]
[null,null,null,null,null,"105_12/15/2020 3:28:45 PM","2020-08-05","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Install & try out hydro blaster supplied at Singapore & carry out testing","Deck - Machinery","General Appearance","Equipment Related",null,null,"Not Applicable","Not Applicable","Hydroblaster installed and put in use","2020-08-15",null,"Completed","2020-08-15","No",null,null,"Internal"]
[null,null,null,null,null,"105_15/12/2020 5:11:24 PM","2020-08-05","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Monthly drinking water onboard test soft copy not maintained onboard, to test & save results on monthly basis.","Documentation","Cert. & Docu.","Inappropriate Procedure",null,null,"Not Applicable","Not Applicable","Procedure made from newly received water test kit.","2020-08-20",null,"Completed","2020-08-14","No",null,null,"Internal"]
[null,null,null,null,null,"105_15/12/2020 5:18:53 PM","2020-08-05","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Install Ro Purifier supplied at singapore","Miscellaneous","MLC Related","Equipment Related",null,null,"Not Applicable","Not Applicable","RO installed","2020-08-12",null,"Completed","2020-08-10","No",null,null,"Internal"]
[null,null,null,null,null,"105_15/12/2020 5:21:38 PM","2020-08-05","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","vessel is not maintaining register of daily sounding of DB tanks & ME sump tank, same to be made with immediate effect & sounding to be taken twice a day.","Documentation","Cert. & Docu.","Inappropriate Procedure",null,null,"Not Applicable","Not Applicable","register made and put in use","2020-08-12",null,"Completed","2020-08-05","No",null,null,"Internal"]
[null,null,null,null,null,"105_15/12/2020 5:25:34 PM","2020-08-05","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Leaking fire hydrants on deck & accommodation ,same to be ohualed","LSA / FFA","Safety / LSA / FFA","Equipment Related",null,null,"Not Applicable","Not Applicable","Same overhauled.","2020-08-15",null,"Completed","2020-08-30","No",null,null,"Internal"]
[null,null,null,null,null,"105_15-Dec-20 3:34:54 PM","2020-08-05","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Refman not installed/activated onboard PC, To liaise with PAL helpdesk foe installing on Pcs.","Miscellaneous","Cert. & Docu.","Equipment Related",null,null,"Not Applicable","Not Applicable","Refman installed and put in use in all PC's","2020-08-15",null,"Completed","2020-08-15","No",null,null,"Internal"]
[null,null,null,null,null,"105_15-Dec-20 3:36:56 PM","2020-08-05","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Many bolts missing on water ballast overboard pipes on deck, new nut and bolts to be put in place.","Deck - Pipe / Fittings","Cargo / Ballast Systems","Equipment Related",null,null,"Not Applicable","Not Applicable","Same completed","2020-08-19",null,"Completed","2020-08-19","No",null,null,"Internal"]
[null,null,null,null,null,"105_15-Dec-20 3:38:46 PM","2020-08-05","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Funnel painting to be carried out as per NGM specification","Miscellaneous","General Appearance","Equipment Related",null,null,"Not Applicable","Not Applicable","Painting completed","2020-10-05",null,"Completed","2020-09-18","No",null,null,"Internal"]
[null,null,null,null,null,"105_15-Dec-20 3:44:12 PM","2020-08-05","Defect","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Booby hatch entrance manhole rubber packing needs to be renewed and packing channel needs to be derusted.","Hull & Tanks","Structural Condn. / WT integrity ","Equipment Related",null,null,"Not Applicable","Not Applicable","Same completed","2020-09-05",null,"Completed","2020-08-30","No",null,null,"Internal"]
[null,null,null,null,null,"105_15-Dec-20 3:46:09 PM","2020-08-05","Defect","Owner / Marine / Tech. Suptd.","Suptd. Insp.","FPK store - Port and Stbd weather tight doors not closing properly with all dogs in closed position, Observed gap between Rubber Packing and Door sill (to be adjusted and packing to be renewed).","Hull & Tanks","Structural Condn. / WT integrity ","Equipment Related",null,null,"Not Applicable","Not Applicable","Same completed","2020-09-05",null,"Completed","2020-08-12","No",null,null,"Internal"]
[null,null,null,null,null,"105_15-Dec-20 3:49:43 PM","2020-08-05","Defect","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Renew stbd side bunker davit wire, broken strands sighted","Deck - Machinery","Safety / LSA / FFA","Equipment Related",null,null,"Not Applicable","Not Applicable","Same completed","2020-09-05",null,"Completed","2020-08-10","No",null,null,"Internal"]
[null,null,null,null,null,"105_15-Dec-20 3:51:08 PM","2020-08-05","Defect","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Renew Rescue boat davit wire, broken strands sighted.","Deck - Machinery","Safety / LSA / FFA","Equipment Related",null,null,"Not Applicable","Not Applicable","Same completed","2020-09-05",null,"Completed","2020-09-07","No",null,null,"Internal"]
[null,null,null,null,null,"105_15-Dec-20 3:52:56 PM","2020-08-05","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Carry out mooring lines inspection, renew damaged mooring ropes with newly supplied mooring ropes","Deck - Mooring Machinery","Mooring","Equipment Related",null,null,"Not Applicable","Not Applicable","Same completed.","2020-09-05",null,"Completed","2020-09-11","No",null,null,"Internal"]
[null,null,null,null,null,"105_15-Dec-20 3:54:36 PM","2020-08-05","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Start PAL Voyage module, start noon reports in PAL","Documentation","Cert. & Docu.","Equipment Related",null,null,"Not Applicable","Not Applicable","Same completed.","2020-09-05",null,"Completed","2020-08-07","No",null,null,"Internal"]
[null,null,null,null,null,"105_15-Dec-20 3:56:28 PM","2020-08-05","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","#1 Main Air compressor to supply a new/ re-con spare, same to be installed & try out","E/R - Air Comp.","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Same installation completed.","2020-09-05",null,"Completed","2020-09-14","No",null,null,"Internal"]
[null,null,null,null,null,"105_15-Dec-20 4:03:04 PM","2020-08-05","Defect","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Engine room 4 pressure and temperature controllers faulty to be ordered & installed","E/R - Aux. Mach.","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","All replaced with new spare rcvd.","2020-09-05",null,"Completed","2020-11-07","No",null,null,"Internal"]
[null,null,null,null,null,"105_15-Dec-20 4:05:28 PM","2020-08-05","Defect","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Ships pressure and temperature gauges faulty at many places, same to be ordered & renewed.","E/R - Pipes/ valves & fittings","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","All defective pressure and temperatures gauges replaced wit new rcvd spare.","2020-09-05",null,"Completed","2020-11-14","No",null,null,"Internal"]
[null,null,null,null,null,"105_15-Dec-20 4:07:37 PM","2020-08-05","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Newly supplied deck air compressor to be installed","Deck - Machinery,E/R - Aux. Mach.","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Same installed in ER 1st deck,","2020-09-20",null,"Completed","2020-09-19","No",null,null,"Internal"]
[null,null,null,null,null,"105_15-Dec-20 4:28:53 PM","2020-11-02","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","01 set of LT cooler gaskets to be ordered and kept as spare for standby","E/R - Aux. Mach.","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Same ordered.\r\nEPIC200142\r\n","2020-11-17","EPIC200142\r\n","Completed","2020-11-08","No",null,null,"Internal"]
[null,null,null,null,null,"105_15-Dec-20 4:34:21 PM","2020-11-02","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Port side funnel flap local operating switch knob is broken. To carry out temporary repair & order new spare immediately","Miscellaneous","Safety / LSA / FFA","Equipment Related",null,null,"Not Applicable","Not Applicable","Replaced with spare. Spare ordered EPIC200141","2020-11-09","EPIC200141","Completed","2020-11-08","No",null,null,"Internal"]
[null,null,null,null,null,"105_15-Dec-20 4:40:50 PM","2020-11-02","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","MAC no. 1 lubricator setting is on higher side leading to oil carryover with air, optimum feed rate adjustment to be carried out as per instruction manual ","E/R - Air Comp.","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Reduced to 2nd notch.","2020-12-02",null,"Completed","2020-11-08","No",null,null,"Internal"]
[null,null,null,null,null,"105_15-Dec-20 4:42:34 PM","2020-11-02","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Cascade tank observed always steaming lead to waste of steam/water, cause to be investigated & rectified, All steam traps to be checked","E/R - Aux. Mach.","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Temperatrure maintained above 80 deg c. Dumping only at sea.","2020-12-02",null,"Completed","2020-11-05","No",null,null,"Internal"]
[null,null,null,null,null,"105_15-Dec-20 4:44:15 PM","2020-11-02","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Aux boiler fuel oil system faulty return press control valve faulty, same to be replaced after receiving new spare","E/R - Boiler","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Same renewed with rcvd spare","2020-12-02",null,"Completed","2020-11-26","No",null,null,"Internal"]
[null,null,null,null,null,"105_15-Dec-20 4:47:08 PM","2020-11-02","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","HFO service tank return valve from A/E gland leakage to rectify","E/R - Aux. Mach.","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Same completed","2020-12-02",null,"Completed","2020-11-27","No",null,null,"Internal"]
[null,null,null,null,null,"105_15-Dec-20 4:48:57 PM","2020-11-02","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","A/E no. 2 Crankcase relief door A/E -3 nos leakage to rectify","E/R - Aux. Engine","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Same rectified","2020-11-02",null,"Completed","2020-11-26","No",null,null,"Internal"]
[null,null,null,null,null,"105_15-Dec-20 4:50:21 PM","2020-11-02","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","A/E no. 1 & 2  leakages from FO diff press switch leaking-same to be rectify","E/R - Aux. Engine","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Same rectified","2020-12-02",null,"Completed","2020-11-26","No",null,null,"Internal"]
[null,null,null,null,null,"105_15-Dec-20 5:00:35 PM","2020-11-02","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","A/E  no. 1 cooling water pump leakage to rectify","E/R - Aux. Engine","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","No such lekage observed. Pump earlier leakage tell tale sign painted.","2020-12-02",null,"Completed","2020-11-04","No",null,null,"Internal"]
[null,null,null,null,null,"105_15-Dec-20 5:04:57 PM","2020-11-02","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","No.2 boiler water circulating pump gland leakage to rectify","E/R - Aux. Mach.","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Same rectified","2020-12-02",null,"Completed","2020-11-05","No",null,null,"Internal"]
[null,null,null,null,null,"105_15-Dec-20 5:12:18 PM","2020-11-02","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Main Air Comp  no. 2  Cyl lubricating quills fitting leakage  to be rectified ","E/R - Air Comp.","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Same rectified","2020-12-02",null,"Completed","2020-11-06","No",null,null,"Internal"]
[null,null,null,null,null,"105_15-Dec-20 5:14:19 PM","2020-11-02","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Main Air Comp  no. 2  LP air gauge  fittings leakage  to be rectified ","E/R - Air Comp.","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Same rectified","2020-12-02",null,"Completed","2020-11-06","No",null,null,"Internal"]
[null,null,null,null,null,"105_15-Dec-20 5:29:21 PM","2020-11-02","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","FWG dosing tank filling  valve gland leakage to rectify","E/R - Aux. Mach.","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Valve replaced with new spare","2020-12-02",null,"Completed","2020-11-14","No",null,null,"Internal"]
[null,null,null,null,null,"105_15-Dec-20 5:42:21 PM","2020-11-02","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Generator auto back wash filter leakage to rectify","E/R - Aux. Mach.","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Same rectified","2020-12-02",null,"Completed","2020-11-14","No",null,null,"Internal"]
[null,null,null,null,null,"105_15-Dec-20 5:46:29 PM","2020-11-02","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Steam leakage A/E fuel oil heater no.2 to be rectified","E/R - Aux. Mach.","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Same rectified","2020-12-01",null,"Completed","2020-11-15","No",null,null,"Internal"]
[null,null,null,null,null,"105_15-Dec-20 5:49:50 PM","2020-11-02","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Aux boiler  fuel oil supply pump no.1 leakage to be rectified","E/R - Aux. Mach.","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Same rectified","2020-11-02",null,"Completed","2020-11-27","No",null,null,"Internal"]
[null,null,null,null,null,"105_15-Dec-20 5:51:08 PM","2020-11-02","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","SW pumps Dish pipe found  minor leaking at doubler  inserted areas-same to be rectified","E/R - Pipes/ valves & fittings","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Same rectified","2020-12-02",null,"Completed","2020-11-24","No",null,null,"Internal"]
[null,null,null,null,null,"105_15-Dec-20 5:57:27 PM","2020-11-02","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Main Engine scavenge door  unit no. 2, 4 &  leakage to be rectified","E/R - Main Engine","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Same rectified","2020-12-02",null,"Completed","2020-11-19","No",null,null,"Internal"]
[null,null,null,null,null,"105_15-Dec-20 6:00:14 PM","2020-11-02","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","M/E fuel oil auto backwash filter leakages to be rectified.","E/R - Aux. Mach.","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Same rectified","2020-12-02",null,"Completed","2020-11-19","No",null,null,"Internal"]
[null,null,null,null,null,"105_15-Dec-20 6:04:55 PM","2020-11-02","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","SPARE PARTS INVENTORY to be completed and re-arrange with good housekeeping","Miscellaneous","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Same duly arranged, Complete store and racks painted.","2020-11-02",null,"Completed","2020-11-12","No",null,null,"Internal"]
[null,null,null,null,null,"105_15-Dec-20 6:06:30 PM","2020-11-02","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","CRITICAL SPARE PARTS INVENTORY to be completed and re-arrange with visible colour code.","Miscellaneous","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Inventory duly taken and recorded","2020-11-02",null,"Completed","2020-11-14","No",null,null,"Internal"]
[null,null,null,null,null,"105_15-Dec-20 6:13:21 PM","2020-11-02","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Steering gear No.1 & 2 oil level to be checked and top up if required as sighted very low","E/R - Aux. Mach.","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Same completed","2020-11-02",null,"Completed","2020-11-04","No",null,null,"Internal"]
[null,null,null,null,null,"105_15-Dec-20 6:14:44 PM","2020-11-02","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Rudder stock top sighted dry and required to apply grease to avoid rusting","Miscellaneous","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Same completed.","2020-12-02",null,"Completed","2020-11-05","No",null,null,"Internal"]
[null,null,null,null,null,"105_15-Dec-20 6:15:59 PM","2020-11-02","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Cosmetic condition required to be improved  on sewage treatment plant including pipes & fittings","E/R - Aux. Mach.","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Same completed.","2020-12-02",null,"Completed","2020-11-14","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]
["ISM Related",7]
["ISPS Related",10]
["MARPOL Related",9]
["MLC Related",4]
["Mooring",12]
["Navigation",5]
["Safety / LSA / FFA",8]
["Structural Condn. / WT integrity ",16]

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

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

{"sheet":"VIQrefno","index":6,"n_rows":1,"n_cols":3,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["VIQ_ref_no","Risk Value of observation","ID"]

{"sheet":"Equipment_list","index":7,"n_rows":28,"n_cols":3,"rows_kept":28,"cut":false,"hidden":true,"merged":[]}
["TITLE","Equipment_list_description","ID"]
["Accommodation",null,12]
["Cargo Mach.",null,13]
["Critical Equip.",null,16]
["Deck - Machinery",null,18]
["Deck - Mooring Machinery",null,15]
["Deck - Pipe / Fittings",null,20]
["Documentation",null,21]
["E/R - Air Comp.",null,8]
["E/R - Aux. Engine",null,4]
["E/R - Aux. Mach.",null,7]
["E/R - Boiler",null,5]
["E/R - Main Engine",null,3]
["E/R - Pipes/ valves & fittings",null,9]
["E/R - Pumps",null,32]
["E/R - Purifier",null,6]
["Elect. Mach. & Equip.",null,10]
["Hull & Tanks",null,19]
["Inert Gas",null,14]
["LSA / FFA",null,17]
["Miscellaneous",null,22]
["Navigation - DGPS / EPFS / AIS",null,28]
["Navigation - ECDIS",null,25]
["Navigation - Echo Sounder / Speed Log",null,26]
["Navigation - GMDSS & Communication",null,23]
["Navigation - Others",null,11]
["Navigation - RADAR",null,24]
["Navigation - VDR / BNWAS",null,30]

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

{"sheet":"Inspection_type","index":9,"n_rows":13,"n_cols":2,"rows_kept":13,"cut":false,"hidden":true,"merged":[]}
["TITLE","ID"]
["Bunkering Audit",14]
["Cargo Audit",17]
["Engineering Audit",16]
["ISM Audit",2]
["ISPS Audit",3]
["IT Audit",10]
["MLC Audit",1]
["Mooring Audit",9]
["Nav Audit / Verification",8]
["Onboard Training",18]
["Ship Staff Insp.",15]
["Suptd. Insp.",13]

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

{"sheet":"Observer_code","index":11,"n_rows":3,"n_cols":3,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
["TITLE","Observer_code_description","ID"]
["Owner / Marine / Tech. Suptd.",null,3]
["Ship Staff",null,2]

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

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

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

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

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

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

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

{"sheet":"Ship_information","index":19,"n_rows":2,"n_cols":3,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["Ship_ID","Ship_Name","FILE_NAME"]
["105","EPIC","105_1607683794395.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"]