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

{"sheet":"Mainsheet","index":0,"n_rows":150,"n_cols":28,"rows_kept":150,"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","08-Nov-2019",null,null,"Ship Name","MOJO"]
[]
[]
[]
[]
[]
[null,null,null,null,"ID","UNIQUE ID","Date Recorded","Type of Deficiency","Observer code","Type of Inspection","Description of Deficiency","Equipment Categories","Area of Observation","Deficiency Cause","VIQ Ref Number","Risk Value of Obs","PSC Ref Number","PSC MOU ID","Action Taken or Required","Target Date","PO Ref No.","Status Code","Date Completed","Drydock","Info Sharing","Critical Item","Audit Type","Superintendent Remarks"]
[null,null,null,null,null,"2019-12-02T19:23:23","2019-08-14","Deficiency","Ship Staff","Ship Staff Insp.","Hull Paint in Poor Condition, especially topsides all around. ","Hull & Tanks","Structural Condn. / WT integrity ","External Factors",null,null,"Not Applicable","Not Applicable","DD Job","2020-01-31",null,"Deferred to D D",null,"Yes",null,null,"Internal"]
[null,null,null,null,null,"2019-02-12T19:27:34","2019-08-15","Deficiency","Ship Staff","Ship Staff Insp.","Both ECDIS UPS, expiring in jan 2020 ","Nav & comm. equip.","Navigation","Equipment Related",null,null,"Not Applicable","Not Applicable","ECDIS Servicing by shore technician","2020-01-31","007D/19","Not Started",null,"No",null,null,"Internal"]
[null,null,null,null,null,"2019-02-12T21:08:57","2019-08-15","Deficiency","Ship Staff","Ship Staff Insp.","Elevator to be recommissioned as per flag state requirements.","Miscellaneous","General Appearance","Equipment Related",null,null,"Not Applicable","Not Applicable","Shore technician to be arranged.","2020-01-31",null,"Deferred to D D",null,"Yes",null,null,"Internal"]
[null,null,null,null,null,"2019-02-12T08:49:02","2019-08-15","Deficiency","Ship Staff","Ship Staff Insp.","All Cargo holds show heavy rusting, including but not limited to CH booby hatch access, rubber packing retaining channel, Australian ladders / straight ladders & guard pipes show heavy corrosion & total wasting at many places. ","Cargo Mach.","Cargo / Ballast Systems","Equipment Related",null,null,"Not Applicable","Not Applicable","Hydro blasting of all cargo holds, 03 coats painting of all cargo holds, cropping & renewal of all wasted ladder parts & booby hatch package retaining channel of all cargo holds. ","2020-01-31",null,"Deferred to D D",null,"Yes",null,null,"Internal"]
[null,null,null,null,null,"2019-02-12T08:51:39","2019-08-15","Deficiency","Ship Staff","Ship Staff Insp.","All hatch cover packings & CH access hatch packings are hardened & grooved (Loss of resilience) & also  understand have few leakages. Also packing retaining channel totally wasted at many places. ","Cargo Mach.","Cargo / Ballast Systems","Equipment Related",null,null,"Not Applicable","Not Applicable","All hatch cover & hatch access lid packings to be renewed & packing retaining channel to be full derusted, cropped & renewed & painted as required.","2020-01-31",null,"Deferred to D D",null,"Yes",null,null,"Internal"]
[null,null,null,null,null,"2019-02-12T08:53:08","2019-08-15","Deficiency","Ship Staff","Ship Staff Insp.","Both windlass brake bands worn out by 70%. ","Mooring Mach.","Mooring","Equipment Related",null,null,"Not Applicable","Not Applicable","Both windlass brake bands to be renewed & one spare band to be maintained onboard.(One set spare available onboard with csk bolts & nuts).","2020-01-31",null,"Deferred to D D",null,"Yes",null,null,"Internal"]
[null,null,null,null,null,"2019-02-12T08:56:35","2019-08-15","Deficiency","Ship Staff","Ship Staff Insp.","Bridge sofa, Crew Mess Room, completely torn & upholstery held in place with tapes. Bridge radio station chair, ship's office chair, ECR chair to be replaced. ","Miscellaneous","General Appearance","Equipment Related",null,null,"Not Applicable","Not Applicable","Same to be re-upholstered & new chair for radio room to be ordered.","2020-01-31",null,"Deferred to D D",null,"Yes",null,null,"Internal"]
[null,null,null,null,null,"2019-02-12T09:30:42","2019-08-15","Deficiency","Ship Staff","Ship Staff Insp.","On stbd side stern frame, steering gear room bulkhead shows an indentation & slight bending of longitudinal (area about 02m x 02m)","Hull & Tanks","Structural Condn. / WT integrity ","Equipment Related",null,null,"Not Applicable","Not Applicable","As per class surveyor's approval in DD.","2020-01-31",null,"Deferred to D D",null,"Yes",null,null,"Internal"]
[null,null,null,null,null,"2019-02-12T09:32:42","2019-08-15","Deficiency","Ship Staff","Ship Staff Insp.","There is no solid fairlead on forecastle deck P&S side to pass tug boat towing lines. Similarly no solid centre lead on poop deck. It was observed vessel passes tug towing lines on forecastle deck & poop deck via roller fairleads, which are not designed for tug pulling stress. ","Mooring Mach.","Mooring","Equipment Related",null,null,"Not Applicable","Not Applicable","To install 02 solid fairleads for passing tug boat towing lines on forecastle deck, one on either side & One centre solid fairlead on poop deck, at her next DD.","2020-01-31",null,"Deferred to D D",null,"Yes",null,null,"Internal"]
[null,null,null,null,null,"2019-12-02T09:34:22","2019-08-15","Deficiency","Ship Staff","Ship Staff Insp.","Aft P side stern rope winch on poop dk & spring rope mooring winch between hatch no.08 & 09 - Control lever unit trickle leaking oil, also for aft breast line, stern lines, spring mooring winch gear engaging clutch lever base welding to main body has come off. ","Mooring Mach.","Mooring","Equipment Related",null,null,"Not Applicable","Not Applicable","Control lever to be checked for leaking seal & gear engagingclutch lever base to be welded back to main body. ","2020-01-31",null,"Deferred to D D",null,"No",null,null,"Internal"]
[null,null,null,null,null,"2019-02-12T09:35:52","2019-08-15","Deficiency","Ship Staff","Ship Staff Insp.","All mooring winches hydraulic motor gearbox oil seems to be curdled, no record of renewal. ","Mooring Mach.","Mooring","Equipment Related",null,null,"Not Applicable","Not Applicable","Oil to be renewed with gearbox specific oil.","2020-01-31",null,"Deferred to D D",null,"Yes",null,null,"Internal"]
[null,null,null,null,null,"2019-02-12T09:37:17","2019-08-15","Deficiency","Ship Staff","Ship Staff Insp.","Mooring winches hydraulic motor gearbox oil filling cap  frozen stiff in place & suspect to be wasted. ","Mooring Mach.","Mooring","Equipment Related",null,null,"Not Applicable","Not Applicable","To be cropped & renewed as required.","2020-01-31",null,"Deferred to D D",null,"Yes",null,null,"Internal"]
[null,null,null,null,null,"2019-02-12T09:38:52","2019-08-15","Deficiency","Ship Staff","Ship Staff Insp.","Spare anchor to be off landed in DD.","Mooring Mach.","Mooring","Equipment Related",null,null,"Not Applicable","Not Applicable","DD","2020-01-31",null,"Deferred to D D",null,"Yes",null,null,"Internal"]
[null,null,null,null,null,"2019-02-12T09:40:32","2019-01-15","Deficiency","Ship Staff","Ship Staff Insp.","Hull stress monitor is already decommissioned, all fittings on deck & bridge to be removed at DD","Deck Pipe / Fittings","General Appearance","Equipment Related",null,null,"Not Applicable","Not Applicable",". All fittings on deck & bridge to be cropped.","2020-01-31",null,"Deferred to D D",null,"Yes",null,null,"Internal"]
[null,null,null,null,null,"2019-02-12T09:42:18","2019-08-19","Deficiency","Ship Staff","Ship Staff Insp.","Almost all hatch cover not sitting on resting pads. Hatch cover lip resting on hatch coaming at many places","Cargo Mach.","Cargo / Ballast Systems","Equipment Related",null,null,"Not Applicable","Not Applicable",". Resting pads to be rebuilt as required & all hatch cover packings to be renewed.","2020-01-31",null,"Deferred to D D",null,"Yes",null,null,"Internal"]
[null,null,null,null,null,"2019-02-12T09:44:01","2019-08-19","Observation","Ship Staff","Ship Staff Insp.","All MS pipe lines on deck including hydraulic lines & electric conduit pipes show heavy corrosion at many places. ","Deck Pipe / Fittings","General Appearance","Equipment Related",null,null,"Not Applicable","Not Applicable","To be hydroblasted & painted 03 coats. Wasted areas of pipes to be cropped & renewed. ","2020-01-31",null,"Deferred to D D",null,"Yes",null,null,"Internal"]
[null,null,null,null,null,"2019-02-12T09:46:37","2019-08-19","Deficiency","Ship Staff","Ship Staff Insp.","Many hatch cover hydraulic lifting jack leaking from seal. ","Cargo Mach.","Cargo / Ballast Systems","Equipment Related",null,null,"Not Applicable","Not Applicable","All flexible hoses & seals of hatch cover lifting jacks to be renewed in next DD.","2020-01-31",null,"Deferred to D D",null,"Yes",null,null,"Internal"]
[null,null,null,null,null,"2019-02-12T09:49:56","2019-08-19","Deficiency","Ship Staff","Ship Staff Insp.","All cargo holds hatch cover natural vents flame arrestors badly painted over","Cargo Mach.","Cargo / Ballast Systems","Equipment Related",null,null,"Not Applicable","Not Applicable",". Old paint to be removed & Flame arrestors to be replaced as required.","2020-01-31",null,"Deferred to D D",null,"Yes",null,null,"Internal"]
[null,null,null,null,null,"2019-02-12T09:51:46","2019-08-19","Deficiency","Ship Staff","Ship Staff Insp.","X band RADARS Magnetron due for renewal. (Last renewal in Nov 2017). S Band Radar PM not working","Nav & comm. equip.","Navigation","Equipment Related",null,null,"Not Applicable","Not Applicable","Both Magnetrons to be renewed & 02 spare to be maintained onboard all the time.","2020-01-31",null,"Deferred to D D",null,"Yes",null,null,"Internal"]
[null,null,null,null,null,"2019-12-02T09:53:55","2019-08-19","Deficiency","Ship Staff","Ship Staff Insp.","Hatch cover drawing chains of following hatch covers full wasted & narrowed down (# 01PA, 02P&SF, 03, 04F, 05F, 07","Cargo Mach.","Cargo / Ballast Systems","Equipment Related",null,null,"Not Applicable","Not Applicable","). All hatch cover drawing chains to be thoroughly derusted & replaced with new ones as required.","2020-01-31",null,"Deferred to D D",null,"Yes",null,null,"Internal"]
[null,null,null,null,null,"2019-02-12T09:55:56","2019-08-19","Deficiency","Ship Staff","Ship Staff Insp.","No.04 & 02 hatch covers drawing hydraulic motor is leaking oil continuously from flexible pipe joint. ","Mooring Mach.","Cargo / Ballast Systems","Equipment Related",null,null,"Not Applicable","Not Applicable","Pipe & seal to be renewed as required.","2020-01-31","017E/19","Not Started",null,"No",null,null,"Internal"]
[null,null,null,null,null,"2019-02-12T09:58:13","2019-08-19","Deficiency","Ship Staff","Ship Staff Insp.","04 nos. Drinking water fountains in accommodation to be made operational. ","Accommodation ","MLC Related","Equipment Related",null,null,"Not Applicable","Not Applicable","Required spares to be requested & drinking water fountains to be made operational.","2020-01-31",null,"Deferred to D D",null,"Yes",null,null,"Internal"]
[null,null,null,null,null,"2019-12-02T10:02:33","2019-08-19","Observation","Ship Staff","Ship Staff Insp.","All cabins porthole curtains found dirty & velcro tape has lost resilience, unable to completely block out light. ","Miscellaneous","MLC Related","Equipment Related",null,null,"Not Applicable","Not Applicable","All curtains to be washed & cleaned & new velcro tapes to be stitched on them.","2020-01-31",null,"Not Started",null,"No",null,null,"Internal"]
[null,null,null,null,null,"2019-12-02T10:12:12","2019-08-19","Deficiency","Ship Staff","Ship Staff Insp.","Many cabins clocks not synchronizing with bridge slave clock & requires manual adjustment. For eg: Owner's cabin. ","Miscellaneous","MLC Related","Equipment Related",null,null,"Not Applicable","Not Applicable","Same to be attended by shore technician.","2020-01-31",null,"Deferred to D D",null,"Yes",null,null,"Internal"]
[null,null,null,null,null,"2019-02-12T10:14:00","2019-08-19","Deficiency","Ship Staff","Ship Staff Insp.","No additional locking arrangement on the inside of accommodation alleyways exit doors abv A deck, for piracy prone areas. Same to be attended in DD as per company discretion.","Miscellaneous","ISPS Related","Equipment Related",null,null,"Not Applicable","Not Applicable","Same to be attended in DD as per company discretion.","2020-08-31",null,"Deferred to D D",null,"Yes",null,null,"Internal"]
[null,null,null,null,null,"2019-12-02T10:16:36","2019-08-19","Deficiency","Ship Staff","Ship Staff Insp.","FWG Ejector pump casing and motor in place,shaft, impeller, mechanical seal and coupling missing.","Aux. Engine","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable"," Pump need to be overhauled, spares required.","2020-01-31","003E/19","Not Started",null,"No",null,null,"Internal"]
[null,null,null,null,null,"2019-12-02T10:18:06","2019-08-19","Deficiency","Ship Staff","Ship Staff Insp.","Aft Hydraulic Power Unit Oil  cooler sea water leaking from end cover","Mooring Mach.","Mooring","Equipment Related",null,null,"Not Applicable","Not Applicable",". Oil cooler end cover need to be repaired.","2020-01-31",null,"Not Started",null,"Yes",null,null,"Internal"]
[null,null,null,null,null,"2019-12-02T10:20:04","2019-08-19","Deficiency","Ship Staff","Ship Staff Insp.","Emergency air driven diesel oil pump leaking. ","Aux. Engine","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Pump need to be overhauled, spares required.","2020-01-31","006E/19","Not Started",null,"Yes",null,null,"Internal"]
[null,null,null,null,null,"2019-02-12T10:22:13","2019-08-19","Deficiency","Ship Staff","Ship Staff Insp.","It was observed Boiler burner unit is being held by chain block, whilst at sea","Boiler","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable"," Inspection to be done and appropriate action to be taken.","2020-01-31",null,"Not Started",null,"Yes",null,null,"Internal"]
[null,null,null,null,null,"2019-02-12T10:25:27","2019-08-19","Deficiency","Ship Staff","Ship Staff Insp.","Aux. Engine fuel oil auto filter not in use. ","Aux. Engine","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Inspection to be done and appropriate action to be taken.","2020-01-31","004 E / 19","Not Started",null,"No",null,null,"Internal"]
[null,null,null,null,null,"2019-02-12T10:27:32","2019-08-19","Deficiency","Ship Staff","Ship Staff Insp.","Main Engine fuel oil line pressure regulator not working","Main Engine ","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable"," Pressure regulator to be overhauled, need spares.","2020-01-31","005E/19","Not Started",null,"Yes",null,null,"Internal"]
[null,null,null,null,null,"2019-02-12T10:29:31","2019-08-19","Deficiency","Ship Staff","Ship Staff Insp.","Main Engine fuel oil viscometer fuel oil leaking from seal. ","Main Engine ","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Need to be overhauled, required spares.","2020-01-31","007E/19","Not Started",null,"No",null,null,"Internal"]
[null,null,null,null,null,"2019-02-12T10:31:42","2019-08-19","Deficiency","Ship Staff","Ship Staff Insp.","DW Sterlizer not working.","Aux. Mach.","MLC Related","Equipment Related",null,null,"Not Applicable","Not Applicable"," Inspection to be done and appropriate action to be taken","2020-01-31",null,"Not Started",null,"Yes",null,null,"Internal"]
[null,null,null,null,null,"2019-02-12T10:33:17","2019-08-19","Deficiency","Ship Staff","Ship Staff Insp.","STBD side sea chest both CU & AL anodes need to be renewed. ","ER Pipes, valves & fittings","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Spare on board need to change in next opportunity ","2020-01-31",null,"Not Started",null,"Yes",null,null,"Internal"]
[null,null,null,null,null,"2019-02-12T10:35:22","2019-08-19","Deficiency","Ship Staff","Ship Staff Insp.","Aft ICCP display showing module/system fault","Hull & Tanks","Structural Condn. / WT integrity ","Equipment Related",null,null,"Not Applicable","Not Applicable"," Inspection to be done and appropriate action to be taken","2020-01-31",null,"Not Started",null,"Yes",null,null,"Internal"]
[null,null,null,null,null,"2019-12-02T10:37:02","2019-08-19","Deficiency","Ship Staff","Ship Staff Insp.","Control air dryer not working properly","Aux. Mach.","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Need to charge gas.","2020-01-31","013E/19","Not Started",null,"Yes",null,null,"Internal"]
[null,null,null,null,null,"2019-02-12T10:41:05","2019-08-20","Deficiency","Ship Staff","Ship Staff Insp.","Hatch cover opening / closing control lever boxes many corroded & wasted. For eg: No.02 & 05","Cargo Mach.","Cargo / Ballast Systems","Equipment Related",null,null,"Not Applicable","Not Applicable"," New boxes to be fabricated & corroded ones to be cropped & renewed.","2020-01-31",null,"Deferred to D D",null,"Yes",null,null,"Internal"]
[null,null,null,null,null,"2019-02-12T10:43:07","2019-08-20","Deficiency","Ship Staff","Ship Staff Insp.","Air btl safety valve for QCV in fire fighting station is leaking continuously. ","LSA / FFA","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","To be checked & valve to be replaced if needed accordingly.","2020-01-31",null,"Deferred to D D",null,"Yes",null,null,"Internal"]
[null,null,null,null,null,"2019-02-12T10:50:43","2019-08-20","Deficiency","Ship Staff","Ship Staff Insp.","Yard supplied many cooking apparatus inoperational in galley. Only hot plates, one small kneader & one baking oven shelf working. ","Miscellaneous","MLC Related","Equipment Related",null,null,"Not Applicable","Not Applicable","Same to be checked & if possible rectified.","2020-01-31",null,"Deferred to D D",null,"Yes",null,null,"Internal"]
[null,null,null,null,null,"2019-02-12T11:24:58","2019-08-20","Deficiency","Ship Staff","Ship Staff Insp.","Water leaking from Main engine jacket temperature controler 3-way valve spindle. ","ER Pipes, valves & fittings","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Need to change the gland.","2020-01-31",null,"Not Started",null,"No",null,null,"Internal"]
[null,null,null,null,null,"2019-02-12T11:26:24","2019-08-21","Deficiency","Ship Staff","Ship Staff Insp.","Fwd winches & windlass power pack, temp. control sensor by-passed to avoid frequent overheating trip. ","Mooring Mach.","Mooring","Equipment Related",null,null,"Not Applicable","Not Applicable","Same to be checked & rectified.","2020-01-31",null,"Deferred to D D",null,"Yes",null,null,"Internal"]
[null,null,null,null,null,"2019-02-12T11:27:53","2019-08-21","Deficiency","Ship Staff","Ship Staff Insp.","All W/T door dogs on deck not free","Miscellaneous","Structural Condn. / WT integrity ","Equipment Related",null,null,"Not Applicable","Not Applicable",". All W/T door dogs to be overhauled.","2020-01-31",null,"Deferred to D D",null,"Yes",null,null,"Internal"]
[null,null,null,null,null,"2019-02-12T11:29:46","2019-08-21","Deficiency","Ship Staff","Ship Staff Insp.","Fire & G/S pump alone not efficient for ballast tank eductor operation. Onboard C/O using 02 pumps for WBT final eduction","Elect. Mach. & Equip.","Cargo / Ballast Systems","Equipment Related",null,null,"Not Applicable","Not Applicable"," Both G/S & stripping pumps to be checked internally.","2020-01-31",null,"Deferred to D D",null,"Yes",null,null,"Internal"]
[null,null,null,null,null,"2019-02-12T11:31:48","2019-08-21","Deficiency","Ship Staff","Ship Staff Insp.","All remote sounding gauges, draft gauges in ship's office not operational. ","Cargo Mach.","Cargo / Ballast Systems","Equipment Related",null,null,"Not Applicable","Not Applicable","Same to be checked & rectified as required.","2020-01-31",null,"Deferred to D D",null,"Yes",null,null,"Internal"]
[null,null,null,null,null,"2019-02-12T11:33:09","2019-08-21","Deficiency","Ship Staff","Ship Staff Insp.","No.03 WBT (P) remote shut indication light on ballast panel malfuntioning. Sensor to be checked at the actual v/v body in pipe duct. .","Deck Pipe / Fittings","Cargo / Ballast Systems","Equipment Related",null,null,"Not Applicable","Not Applicable","Sensor to be checked at the actual v/v body in pipe duct","2020-01-31",null,"Not Started",null,"No",null,null,"Internal"]
[null,null,null,null,null,"2019-02-12T11:35:19","2019-08-21","Observation","Ship Staff","Ship Staff Insp.","All hatch coamings stiffeners on deck show heavy rusting","Deck Pipe / Fittings","General Appearance","Equipment Related",null,null,"Not Applicable","Not Applicable","To be derusted, primered & painted accordingly.","2020-01-31",null,"Not Started",null,"No",null,null,"Internal"]
[null,null,null,null,null,"2019-02-12T11:36:58","2019-08-21","Deficiency","Ship Staff","Ship Staff Insp.","Both lifeboat - falls, self lowering wires & gripes due for renewal in next DD. ","LSA / FFA","LSA / FFA Appliances","Equipment Related",null,null,"Not Applicable","Not Applicable","To be renewed in next DD","2020-01-31",null,"Deferred to D D",null,"Yes",null,null,"Internal"]
[null,null,null,null,null,"2019-12-02T11:41:30","2019-08-21","Deficiency","Ship Staff","Ship Staff Insp.","All 3 A/E's are capable of taking only 340kW and below  with exhaust temperatures at around 480 degree celcius.(rated capacity 730 kW)resulting in breakage of exhaust valves\r\nSUSPECT: wrong timing and use of non genuine spares like inlet valve,s,exhaust valves,fuel valve nozzles,coolers and the turbochargers.Also appears that the lube oil used are in excess of 2000 running hours and not purified. ","Aux. Engine","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","All three A/E s to be overhauled at DD","2020-01-31","016E/19","Deferred to D D",null,"Yes",null,null,"Internal"]
[null,null,null,null,null,"2019-02-12T11:43:47","2019-08-21","Deficiency","Ship Staff","Ship Staff Insp.","Bilge fire & GS pump overboard valve gland leaking","Cargo Mach.,ER Pipes, valves & fittings","Cargo / Ballast Systems","Equipment Related",null,null,"Not Applicable","Not Applicable","Need to change the gland packing.","2020-01-31",null,"Not Started",null,"No",null,null,"Internal"]
[null,null,null,null,null,"2019-02-12T11:46:14","2019-08-21","Deficiency","Ship Staff","Ship Staff Insp.","No.3 HFO bunker tank Stbd, minor fuel oil leakage from the tank gauging system sensor","Aux. Engine","MARPOL Related","Equipment Related",null,null,"Not Applicable","Not Applicable","Need to change the Gasket for the flange.","2020-01-31",null,"Not Started",null,"No",null,null,"Internal"]
[null,null,null,null,null,"2019-02-12T11:47:36","2019-08-21","Deficiency","Ship Staff","Ship Staff Insp.","Main engine unit No.2 cylinder oil lubricator inlet line Y-filter leaking form the plug","Main Engine ","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Need to change the gasket for the plug.","2020-01-31",null,"Not Started",null,"No",null,null,"Internal"]
[null,null,null,null,null,"2019-02-12T11:50:51","2019-08-21","Deficiency","Ship Staff","Ship Staff Insp.","Cargo hold bilge eductor & ballast tank eductor were with doubler plate & jubilee clip repairs respectively, Now the doubler plate has been replaced with soft patch repair & some hot repair. ","Deck Pipe / Fittings","Cargo / Ballast Systems","Equipment Related",null,null,"Not Applicable","Not Applicable","Need to renew both the eductors.","2020-01-31",null,"Deferred to D D",null,"Yes",null,null,"Internal"]
[null,null,null,null,null,"2019-02-12T11:52:16","2019-08-21","Deficiency","Ship Staff","Ship Staff Insp.","Loadicator Computer is 15 yrs old. Same should be renewed to a newer computer & get Class approved. ","Miscellaneous","Cargo / Ballast Systems","Equipment Related",null,null,"Not Applicable","Not Applicable","To be done at next DD.","2020-01-31",null,"Deferred to D D",null,"No",null,null,"Internal"]
[null,null,null,null,null,"2019-02-12T11:54:11","2019-08-21","Deficiency","Ship Staff","Ship Staff Insp.","Both sides bridge wing, bridge front glass & its frame not clear & corroded & wasted respectively ","Nav & comm. equip.","Navigation","Equipment Related",null,null,"Not Applicable","Not Applicable","Same to be replaced in DD.","2020-01-31",null,"Deferred to D D",null,"Yes",null,null,"Internal"]
[null,null,null,null,null,"2019-02-12T11:56:09","2019-08-21","Deficiency","Ship Staff","Ship Staff Insp.","Fwd winches & windlass power pack have drip hydraulic oil leakage from its pipe. ","Mooring Mach.","Mooring","Equipment Related",null,null,"Not Applicable","Not Applicable","Same to be attended to in next DD","2020-01-31",null,"Not Started",null,"No",null,null,"Internal"]
[null,null,null,null,null,"2019-02-12T11:57:53","2019-08-21","Deficiency","Ship Staff","Ship Staff Insp.","Vessel unable to compact garbage volume & hence leading to garbage accumulation onboard. ","Miscellaneous","MARPOL Related","Equipment Related",null,null,"Not Applicable","Not Applicable","Vessel to be provided with heavy duty 440V/60Hz garbage compactor.","2020-01-31",null,"Deferred to D D",null,"Yes",null,null,"Internal"]
[null,null,null,null,null,"2019-02-12T11:59:53","2019-08-21","Deficiency","Ship Staff","MLC Audit","All cabin portholes on accommodation super structure are in poor condition & on outside show heavy rusting on the edges thus causing water ingress. ","Accommodation ","MLC Related","Equipment Related",null,null,"Not Applicable","Not Applicable","All porthole edges to be thoroughly derusted & sealed properly & then primered & painted.","2020-01-31",null,"Deferred to D D",null,"Yes",null,null,"Internal"]
[null,null,null,null,null,"2019-02-12T12:01:24","2019-08-21","Deficiency","Ship Staff","Ship Staff Insp.","Bridge Wings underside rusted at many unaccessible places. ","Accommodation ","Structural Condn. / WT integrity ","Equipment Related",null,null,"Not Applicable","Not Applicable","To be derusted, primered & painted accordingly. Possible only in DD as require staging from down up to attend this job.","2020-01-31",null,"Deferred to D D",null,"Yes",null,null,"Internal"]
[null,null,null,null,null,"2019-02-12T12:02:54","2019-08-21","Deficiency","Ship Staff","Ship Staff Insp.","Emergency generator radiator damaged badly and water leaking. ","Aux. Engine","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Radiator to be renewed.","2020-01-31",null,"Waiting spare",null,"No",null,null,"Internal"]
[null,null,null,null,null,"2019-02-12T12:04:44","2019-08-21","Deficiency","Ship Staff","Ship Staff Insp.","No.1 HFO bunker tank port & stbd level gauge defective. ","Hull & Tanks","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Inspection to be done and appropriate action to be taken.","2020-01-31",null,"Not Started",null,"No",null,null,"Internal"]
[null,null,null,null,null,"2019-02-12T12:06:46","2019-08-21","Deficiency","Ship Staff","Ship Staff Insp.","Rescue boat(port) battery expiring on May 2020. ","LSA / FFA","LSA / FFA Appliances","Equipment Related",null,null,"Not Applicable","Not Applicable","Need to renew the battery","2020-01-31",null,"Not Started",null,"No",null,null,"Internal"]
[null,null,null,null,null,"2019-03-12T06:14:55","2019-08-22","Deficiency","Ship Staff","Ship Staff Insp.","Excessive condemned material in forecastle store. .","Miscellaneous","MARPOL Related","Equipment Related",null,null,"Not Applicable","Not Applicable","Same to be offlanded ashore at DD","2020-01-31",null,"Not Started",null,"No",null,null,"Internal"]
[null,null,null,null,null,"2019-03-12T06:22:19","2019-08-22","Deficiency","Ship Staff","Ship Staff Insp.","Vessel has 03 pcs pneumatic de-mucking davits in defunct condition. Same to be made operational. ","Miscellaneous","Cargo / Ballast Systems","Equipment Related",null,null,"Not Applicable","Not Applicable","Same to be checked, spares ordered if required & to be made operational.","2020-01-31",null,"Deferred to D D",null,"Yes",null,null,"Internal"]
[null,null,null,null,null,"2019-03-12T06:24:47","2019-08-22","Deficiency","Ship Staff","Ship Staff Insp.","Fwd P side Windlass motor gear engaging hydraulic mechanism has been removed from place & manual engagament used. ","Mooring Mach.","Mooring","Equipment Related",null,null,"Not Applicable","Not Applicable","As per GSM discretion, job to be completed.","2020-01-31",null,"Deferred to D D",null,"Yes",null,null,"Internal"]
[null,null,null,null,null,"2019-03-12T06:26:03","2019-08-22","Deficiency","Ship Staff","Ship Staff Insp.","Fwd S side Windlass motor gear engaging hydraulic mechanism full corroded & about to break anytime. ","Mooring Mach.","Mooring","Equipment Related",null,null,"Not Applicable","Not Applicable","As per GSM discretion, job to be completed.","2020-01-31",null,"Deferred to D D",null,"Yes",null,null,"Internal"]
[null,null,null,null,null,"2019-03-12T06:27:59","2019-08-22","Deficiency","Ship Staff","Ship Staff Insp.","Fwd & Midship draft guage hydraulic purge v/v looks poorly maintained","Cargo Mach.,Deck Pipe / Fittings","Cargo / Ballast Systems","Equipment Related",null,null,"Not Applicable","Not Applicable","Same to be tested & purged as required & to be maintained well.","2020-01-31",null,"Deferred to D D",null,"Yes",null,null,"Internal"]
[null,null,null,null,null,"2019-03-12T06:29:23","2019-08-22","Deficiency","Ship Staff","Ship Staff Insp.","Both FWTks & DWTk cleaning & washing not done in the last 06 months. ","Hull & Tanks","MLC Related","Equipment Related",null,null,"Not Applicable","Not Applicable","Same to be attended as & when tanks become available without disturbing our RoB but by Nov 2019.","2020-01-31",null,"Deferred to D D",null,"Yes",null,null,"Internal"]
[null,null,null,null,null,"2019-12-03T06:30:55","2019-08-22","Observation","Ship Staff","Ship Staff Insp.","Master's cabin entrance door curtain in poor condition. ","Miscellaneous","MLC Related","Equipment Related",null,null,"Not Applicable","Not Applicable","Same to be ordered & replaced.","2020-01-31","001D/19","Not Started",null,"No",null,null,"Internal"]
[null,null,null,null,null,"2019-03-12T06:33:14","2019-08-22","Deficiency","Ship Staff","Ship Staff Insp.","Atmospheric condensor 14 Nos of tubes has been plugged. ","Boiler","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Same to be ordered & replaced.","2020-01-31","012E/19","Not Started",null,"No",null,null,"Internal"]
[null,null,null,null,null,"2019-03-12T06:35:20","2019-08-22","Deficiency","Ship Staff","Ship Staff Insp.","Boiler feed water controller erratic and leaking from the gland.","Boiler","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Inspection to be done and appropriate action to be taken","2020-01-31",null,"Not Started",null,"No",null,null,"Internal"]
[null,null,null,null,null,"2019-03-12T06:38:53","2019-08-22","Deficiency","Ship Staff","Ship Staff Insp.","Main Engine unit no.2,3 & 6 minor fuel oil leakage from shock absorber flange","Main Engine ","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Gasket need to be changed.","2020-01-31",null,"Not Started",null,"No",null,null,"Internal"]
[null,null,null,null,null,"2019-03-12T06:45:15","2019-08-22","Deficiency","Ship Staff","Ship Staff Insp.","Main engine unit no.6  minor fuel oil leakage from aft high pressure pipe. ","Main Engine ","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","High pressure pipe need to be overhauled.","2020-01-31",null,"Not Started",null,"No",null,null,"Internal"]
[null,null,null,null,null,"2019-03-12T06:47:01","2019-08-22","Deficiency","Ship Staff","Ship Staff Insp.","Fwd Liferaft launching instructions poster in poor condition. ","LSA / FFA","LSA / FFA Appliances","Equipment Related",null,null,"Not Applicable","Not Applicable","Same to be replaced with a new one or stencilled under Emergency light.","2020-01-31",null,"Not Started",null,"No",null,null,"Internal"]
[null,null,null,null,null,"2019-03-12T06:49:17","2019-08-22","Deficiency","Ship Staff","Ship Staff Insp.","All hatch cover opening chain drawing hydraulic motor open to shipping seas & thus prone to heavy seas & water damage.","Cargo Mach.","Cargo / Ballast Systems","Equipment Related",null,null,"Not Applicable","Not Applicable"," A protective guard plate to be welded in position to protect these hydraulic motors","2020-01-31",null,"Deferred to D D",null,"Yes",null,null,"Internal"]
[null,null,null,null,null,"2019-03-12T07:48:12","2019-08-22","Deficiency","Ship Staff","Ship Staff Insp.","WBTks remote hydraulic v/v operating power pack pumps always kept 'ON' & pumps running continuously to maintain pressure. ","Elect. Mach. & Equip.","Cargo / Ballast Systems","Equipment Related",null,null,"Not Applicable","Not Applicable","Must be investigated & repaired accordingly.","2020-01-31",null,"Not Started",null,"No",null,null,"Internal"]
[null,null,null,null,null,"2019-03-12T07:50:03","2019-08-22","Deficiency","Ship Staff","Ship Staff Insp.","All CH entrance booby hatches to be legibly stencilled following - \"Restricted Area, No unauthorized Access / Caution: Danger of Oxygen depletion\". ","Hull & Tanks","Cargo / Ballast Systems","Equipment Related",null,null,"Not Applicable","Not Applicable","Same to done by ship staff post take over within a month.","2020-01-31",null,"Not Started",null,"No",null,null,"Internal"]
[null,null,null,null,null,"2019-03-12T07:53:21","2019-08-22","Deficiency","Ship Staff","Ship Staff Insp.","Vacuum toilet pump No.1 minor leakage. ","Aux. Mach.","MLC Related","Equipment Related",null,null,"Not Applicable","Not Applicable","Inspection to be done and appropriate action to be taken.","2020-01-31",null,"Not Started",null,"No",null,null,"Internal"]
[null,null,null,null,null,"2019-03-12T07:55:32","2019-08-22","Deficiency","Ship Staff","Ship Staff Insp.","FWG feed water line chemical dosing pump not running","Aux. Mach.","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable"," Inspection to be done and appropriate action to be taken.","2020-01-31",null,"Not Started",null,"No",null,null,"Internal"]
[null,null,null,null,null,"2019-03-12T07:56:56","2019-08-22","Deficiency","Ship Staff","Ship Staff Insp.","Main engine unit no.3 aft fuel injector leaking. ","Main Engine ","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Need to change the injector with overhauled one.","2020-01-31",null,"Not Started",null,"No",null,null,"Internal"]
[null,null,null,null,null,"2019-03-12T07:59:22","2019-08-24","Deficiency","Ship Staff","Ship Staff Insp.","Main engine unit no.3 fwd stbd cooling water connection pipe leaking","Main Engine ","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Need to change the O-Ring for the connection pipe.","2020-01-31",null,"Not Started",null,"No",null,null,"Internal"]
[null,null,null,null,null,"2019-03-12T08:01:02","2019-08-24","Deficiency","Ship Staff","Ship Staff Insp.","Main engine camshaft lube oil inlet low pressure shutdown broken. Alarm showing in Safety system unit and alarm monitor. ","Main Engine ","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Inspection to be done and appropriate action to be taken.","2020-01-31",null,"Not Started",null,"No",null,null,"Internal"]
[null,null,null,null,null,"2019-03-12T08:03:04","2019-08-24","Deficiency","Ship Staff","Ship Staff Insp.","Main Engine Running Hour meter not working","Main Engine ","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable"," Need to replace the running hour meter.","2020-01-31",null,"Not Started",null,"No",null,null,"Internal"]
[null,null,null,null,null,"2019-12-03T08:05:32","2019-08-26","Deficiency","Ship Staff","Ship Staff Insp.","Actual location of Fireman's outfit not in compliance with Ship's Fire Safety Plan. Ship's Fire Safety Plan modified as per ship's convenience. But not all are updated. ","LSA / FFA","LSA / FFA Appliances","Equipment Related",null,null,"Not Applicable","Not Applicable","Actual location of Fireman's outfit to be made in compliance with Fire Safety Plan.","2020-01-31",null,"Not Started",null,"No",null,null,"Internal"]
[null,null,null,null,null,"2019-12-03T08:07:37","2019-08-26","Deficiency","Ship Staff","Ship Staff Insp.","Fireman's outfit suit & SCBAs visor in Fire Station looks worn out. One Safety helmet visor is missing. ","LSA / FFA","LSA / FFA Appliances","Equipment Related",null,null,"Not Applicable","Not Applicable","New Fireman's outfit & SCBA visors to be requisitioned along with one safety helmet with visor & neck protection","2020-01-31","004D/19","Not Started",null,"No",null,null,"Internal"]
[null,null,null,null,null,"2019-03-12T08:14:21","2019-08-27","Deficiency","Ship Staff","Ship Staff Insp.","Main engine exhaust pipe above the funnel exhaust platform welding is completely gone in fwd both port and stbd support frame. ","Main Engine ","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Inspection to be done and appropriate action to be taken.","2020-01-31",null,"Deferred to D D",null,"Yes",null,null,"Internal"]
[null,null,null,null,null,"2019-03-12T08:15:51","2019-08-27","Deficiency","Ship Staff","Ship Staff Insp.","All 3 Aux Engine exhaust pipe above the funnel exhaust platform completely rusted and holed. ","ER Pipes, valves & fittings","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Need to replace the pipe above the funnel exhaust platform","2020-01-31",null,"Deferred to D D",null,"Yes",null,null,"Internal"]
[null,null,null,null,null,"2019-03-12T08:17:50","2019-08-27","Deficiency","Ship Staff","Ship Staff Insp.","Incinerator exhaust pipe above the funnel exhaust platform rusted. ","ER Pipes, valves & fittings","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Need to replace the pipe above the funnel exhaust platform","2020-01-31",null,"Deferred to D D",null,"Yes",null,null,"Internal"]
[null,null,null,null,null,"2019-03-12T08:20:26","2019-08-27","Deficiency","Ship Staff","Ship Staff Insp.","Funnel hatch cover completely rusted","Hull & Tanks","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Need to replace the hatch cover.","2020-01-31",null,"Deferred to D D",null,"Yes",null,null,"Internal"]
[null,null,null,null,null,"2019-03-12T08:31:38","2019-08-27","Deficiency","Ship Staff","Ship Staff Insp.","Sewage discharge pump delivery line two section of pipes is holed in many places. Need to renewe the pipe.","ER Pipes, valves & fittings","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Need to renewe the pipe.","2020-01-31",null,"Not Started",null,"No",null,null,"Internal"]
[null,null,null,null,null,"2019-03-12T08:33:16","2019-08-27","Deficiency","Ship Staff","Ship Staff Insp.","Main engine unit No.1 port side FWD and AFT cooling water connection pipe minor leakage. ","Main Engine ","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Need to renew the o-ring for the cooling water connection pipe.","2020-01-31",null,"Not Started",null,"No",null,null,"Internal"]
[null,null,null,null,null,"2019-03-12T08:50:35","2019-08-27","Deficiency","Ship Staff","Ship Staff Insp.","Main engine fuel oil auto filter running hour meter is not working.","Aux. Engine","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable"," Inspection to be done and appropriate action to be taken","2020-01-31",null,"Not Started",null,"No",null,null,"Internal"]
[null,null,null,null,null,"2019-03-12T08:52:43","2019-08-28","Deficiency","Ship Staff","Ship Staff Insp.","Some W/T doors not sealing properly on closure. Also packing retaining channel seems corroded. ","Accommodation ","Structural Condn. / WT integrity ","Equipment Related",null,null,"Not Applicable","Not Applicable","All W/T doors to be checked for proper sealing. Packing retaining channel to be derusted & painted accordingly, wasted sections to be repaired.","2020-01-31",null,"Deferred to D D",null,"No",null,null,"Internal"]
[null,null,null,null,null,"2019-03-12T08:54:24","2019-08-28","Deficiency","Ship Staff","Ship Staff Insp.","All 03 embarkation ladders for both lifeboats & fwd liferafts, the shackle end thimble area & exposed ladder parts shows Sunrays / SW damage. .","LSA / FFA","LSA / FFA Appliances","Equipment Related",null,null,"Not Applicable","Not Applicable","Embarkation ladders to be checked for wear & ladder to be replaced accordingly","2020-01-31","013D/19","Not Started",null,"No",null,null,"Internal"]
[null,null,null,null,null,"2019-03-12T08:56:50","2019-08-28","Deficiency","Ship Staff","Ship Staff Insp.","Boiler fuel oil pump No.2 shaft seal leaking. ","Boiler","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Need to overhaul the pump with new shaft seal.","2020-01-31",null,"Not Started",null,"No",null,null,"Internal"]
[null,null,null,null,null,"2019-03-12T09:00:42","2019-08-28","Deficiency","Ship Staff","Ship Staff Insp.","No.1 HFO Purifier Fuel oil leaking from the inlet/outlet pipe flange. ","Aux. Mach.","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Need to change the gaskets ","2020-01-31",null,"Not Started",null,"No",null,null,"Internal"]
[null,null,null,null,null,"2019-03-12T09:04:37","2019-08-28","Deficiency","Ship Staff","Ship Staff Insp.","A/E No.3 lube oil inlet pipe to turbocharger leaking. ","Aux. Engine","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Inspection to be done and appropriate action to be taken.","2020-01-31",null,"Not Started",null,"No",null,null,"Internal"]
[null,null,null,null,null,"2019-12-03T09:10:15","2019-08-28","Deficiency","Ship Staff","Ship Staff Insp.","A/E ACONICS PMS system need to check as A/E synchronizing is being done manually. .","Aux. Engine","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Inspection to be done and appropriate action to be taken","2019-11-30",null,"Not Started",null,"No",null,null,"Internal"]
[null,null,null,null,null,"2019-03-12T09:18:52","2019-08-29","Deficiency","Ship Staff","Ship Staff Insp.","Fresh water expansion tank have some oil trace, A/E fuel injector is being cooled by fresh water. ","Aux. Engine","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Need to find which A/E injector is leaking.","2020-01-31",null,"Not Started",null,"No",null,null,"Internal"]
[null,null,null,null,null,"2019-12-03T09:21:00","2019-08-29","Deficiency","Ship Staff","Ship Staff Insp.","Boiler burner unit attached fuel oil pump leaking from shaft seal. ","Boiler","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Need to renew the shaft seal, need spare shaft seal.","2020-01-31",2E+19,"Not Started",null,"No",null,null,"Internal"]
[null,null,null,null,null,"2019-03-12T09:24:31","2019-08-29","Deficiency","Ship Staff","Ship Staff Insp.","Sea chest both Low & High and Cooling sea water overboard valves have remote operating option(From 2nd Deck) but not working. ","Aux. Engine","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Inspection to be done and appropriate action to be taken.","2020-01-31",null,"Not Started",null,"No",null,null,"Internal"]
[null,null,null,null,null,"2019-03-12T09:27:12","2019-08-30","Deficiency","Ship Staff","Ship Staff Insp.","Bridge wings - Anti skid walking mats in worn out condition. ","Accommodation ","General Appearance","Equipment Related",null,null,"Not Applicable","Not Applicable","Same to be replaced with new ones after ordering appropriate mats in DD","2020-01-31",null,"Deferred to D D",null,"Yes",null,null,"Internal"]
[null,null,null,null,null,"2019-03-12T09:29:34","2019-09-02","Deficiency","Ship Staff","Ship Staff Insp.","Vessel hawse pipes have no covering arrangement on forecastle deck for anti pilferage measure. Hawse pipe covers stowed in FPK store. ","Deck Pipe / Fittings","Structural Condn. / WT integrity ","Equipment Related",null,null,"Not Applicable","Not Applicable","Same to be installed on forecastle deck & put in use.","2020-01-31",null,"Not Started",null,"No",null,null,"Internal"]
[null,null,null,null,null,"2019-03-12T09:39:49","2019-09-02","Deficiency","Ship Staff","Ship Staff Insp.","No.2 main air compressor oil is getting emulsification. ","Aux. Mach.","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Need to inspect for any water leakage and appropriate action to be taken.","2019-12-30",null,"Not Started",null,"No",null,null,"Internal"]
[null,null,null,null,null,"2019-03-12T09:42:45","2019-09-02","Deficiency","Ship Staff","Ship Staff Insp.","Soft patch in STBD grey water overboard pipe line in bottom platform. ","ER Pipes, valves & fittings","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Need to replace the pipe.","2020-01-31",null,"Not Started",null,"No",null,null,"Internal"]
[null,null,null,null,null,"2019-03-12T09:50:43","2019-09-04","Deficiency","Ship Staff","Ship Staff Insp.","Steam pipe in purifier room is leaking from the flange. ","Aux. Mach.,ER Pipes, valves & fittings","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Need to change the gasket.","2020-01-31",null,"Not Started",null,"No",null,null,"Internal"]
[null,null,null,null,null,"2019-03-12T09:53:04","2019-09-04","Deficiency","Ship Staff","Ship Staff Insp.","A/E lube oil settling tank is filled with 8.45 m3 of sludge and water. ","Aux. Engine","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Need to transfer to shore facility and clean the tank.","2020-01-31",null,"Not Started",null,"No",null,null,"Internal"]
[null,null,null,null,null,"2019-03-12T09:55:25","2019-09-04","Deficiency","Ship Staff","Ship Staff Insp.","M/E lube oil settling tank is filled with 6.5 m3 of used oil. ","Main Engine ","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Need to transfer to shore facility and clean the tank.","2020-01-31",null,"Not Started",null,"No",null,null,"Internal"]
[null,null,null,null,null,"2019-03-12T10:00:30","2019-09-04","Deficiency","Ship Staff","Ship Staff Insp.","Pressure and temperature gauges of various pumps not working. ","Aux. Mach.,ER Pipes, valves & fittings","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Need to renew all defective gauges. Need spare gauges.","2020-01-31","011E/19","Deferred to D D",null,"No",null,null,"Internal"]
[null,null,null,null,null,"2019-03-12T10:02:35","2019-09-09","Deficiency","Ship Staff","Ship Staff Insp.","Both lifeboats, fwd & aft hooks engaged & locked position yellow marking is missing. ","LSA / FFA","LSA / FFA Appliances","Equipment Related",null,null,"Not Applicable","Not Applicable","Will need to create a lock position marking on both fwd & aft hooks of both lifeboats, as per manual.","2019-11-05",null,"Not Started",null,"No",null,null,"Internal"]
[null,null,null,null,null,"2019-03-12T10:04:14","2019-09-10","Deficiency","Ship Staff","Ship Staff Insp.","Both Boiler feed water pump discharge line holes repaired with soft patch","Boiler","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Need to renew the pipe.","2020-01-31",null,"Not Started",null,"No",null,null,"Internal"]
[null,null,null,null,null,"2019-03-12T10:11:44","2019-09-10","Deficiency","Ship Staff","Ship Staff Insp.","Oily bilge pump discharge line to OWS many places corroded and have trace of leakage. ","ER Pipes, valves & fittings","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Need to renew the pipe.","2020-01-31",null,"Not Started",null,"No",null,null,"Internal"]
[null,null,null,null,null,"2019-03-12T10:14:15","2019-09-10","Deficiency","Ship Staff","Ship Staff Insp.","Oxygen cylinder room closing valve have soft patch. .","ER Pipes, valves & fittings","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Need to renew the valve. Requisition raised","2020-01-31","009E/19","Not Started",null,"No",null,null,"Internal"]
[null,null,null,null,null,"2019-12-03T10:31:12","2019-10-18","Deficiency","Ship Staff","Ship Staff Insp.","No.03 hatch cover chain drawing hydraulic motor in not working condition & lying defunct.","Cargo Mach.","Cargo / Ballast Systems","Equipment Related",null,null,"Not Applicable","Not Applicable"," New hydraulic motor & some other internal spares of the said motor requisitioned.","2020-01-31","017E/19","Not Started",null,"No",null,null,"Internal"]
[null,null,null,null,null,"2019-03-12T10:33:09","2019-10-26","Deficiency","Ship Staff","Ship Staff Insp.","All hatch cover chain drawing hydraulic motors to be overhauled. (09 pcs) ","Cargo Mach.","Cargo / Ballast Systems","Equipment Related",null,null,"Not Applicable","Not Applicable","To overhaul & renew as required.","2020-12-31",null,"Deferred to D D",null,"Yes",null,null,"Internal"]
[null,null,null,null,null,"2019-03-12T10:35:18","2019-10-31","Deficiency","Ship Staff","Ship Staff Insp.","Fire & G/S pump No.2 leaking from shaft seal. .","Aux. Mach.","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","shaft seal to be renewed","2020-01-31",null,"Not Started",null,"No",null,null,"Internal"]
[null,null,null,null,null,"2019-03-12T10:37:26","2019-10-31","Deficiency","Ship Staff","Ship Staff Insp.","A/E fuel oil heater found slightly leaking from the end cover flange. ","Aux. Mach.","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Packing has to be changed and heater to be cleaned.","2020-01-31",null,"Not Started",null,"No",null,null,"Internal"]
[null,null,null,null,null,"2019-03-12T10:39:44","2019-10-31","Deficiency","Ship Staff","Ship Staff Insp.","FWG observed to be producing only 10 to 12 MT/day                   (capacity :- 25 MT) ","Aux. Mach.","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Evaporator and Condensor to be cleaned/ To be landed ashore for proper cleaning and pressure testing at dry dock.","2020-01-31",null,"Deferred to D D",null,"Yes",null,null,"Internal"]
[null,null,null,null,null,"2019-03-12T10:42:12","2019-10-31","Deficiency","Ship Staff","Ship Staff Insp.","All stained steam laggings in purifier room/Generators/Boilers/ME/General laggings in Engine Room. ","Aux. Mach.","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Laggings to be renewed.","2020-01-31",null,"Deferred to D D",null,"Yes",null,null,"Internal"]
[null,null,null,null,null,"2019-03-12T10:48:43","2019-11-01","Deficiency","Ship Staff","Ship Staff Insp.","All WB TSTs & DBTs onboard need thorough demucking, UT guaging & rerusting & painiting as required. ","Deck Pipe / Fittings","Structural Condn. / WT integrity ","Equipment Related",null,null,"Not Applicable","Not Applicable","Same to be done in DD","2020-01-31",null,"Deferred to D D",null,"Yes",null,null,"Internal"]
[null,null,null,null,null,"2019-03-12T10:52:24","2019-11-01","Deficiency","Ship Staff","Ship Staff Insp.","All lifting cranes & davit main wires + ancillary wires wires on board due for renewal in DD. (01 prov. Crane, 01 E/R o/h crane, 02 bunker davits, 02 gangways). ","Deck Mach.","Structural Condn. / WT integrity ","Equipment Related",null,null,"Not Applicable","Not Applicable","Same to be ordered & renewed in next DD.","2020-01-31",null,"Deferred to D D",null,"Yes",null,null,"Internal"]
[null,null,null,null,null,"2019-03-12T10:56:12","2019-11-01","Deficiency","Ship Staff","Ship Staff Insp.","Few  exhaust temperature guages for the AE are faulty and few are missing. ","Aux. Engine","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","To be renewed","2020-01-31",null,"Not Started",null,"No",null,null,"Internal"]
[null,null,null,null,null,"2019-03-12T11:07:15","2019-11-01","Deficiency","Ship Staff","Ship Staff Insp.","ME fuel oil auto filter running hour meter not operational. ","Main Engine ","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","To inspect and renew","2020-01-31",null,"Not Started",null,"No",null,null,"Internal"]
[null,null,null,null,null,"2019-03-12T11:13:15","2019-11-01","Deficiency","Ship Staff","Ship Staff Insp.","WMFF system in alarm condition/panel abnormal alarm. ","Critical Equip.","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","To inspect","2020-01-31",null,"Not Started",null,"No",null,null,"Internal"]
[null,null,null,null,null,"2019-03-12T11:22:33","2019-11-01","Deficiency","Ship Staff","Ship Staff Insp.","Main Engine Lubricators for all the units leaking. ","Main Engine ","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Leaks to be arrested","2020-01-31",null,"Not Started",null,"No",null,null,"Internal"]
[null,null,null,null,null,"2019-03-12T11:25:17","2019-11-01","Deficiency","Ship Staff","Ship Staff Insp.","No.02 HFO (P) bunker tank is not used for bunkering atleast in the last 11 months. ","ER Pipes, valves & fittings","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Tank to be thoroughly inspected & report to be made & put in general use.","2020-01-31",null,"Not Started",null,"No",null,null,"Internal"]
[null,null,null,null,null,"2019-03-12T11:27:16","2019-11-01","Deficiency","Ship Staff","Ship Staff Insp.","10 nos. mooring ropes put in use since 2014 / 2015 & are already 05 years old & in moderate condition.  ","Mooring Mach.","Mooring","Equipment Related",null,null,"Not Applicable","Not Applicable","The said mooring ropes to be replaced with new mooring ropes.","2020-01-31",null,"Not Started",null,"No",null,null,"Internal"]
[null,null,null,null,null,"2019-03-12T11:32:11","2019-11-01","Deficiency","Ship Staff","Ship Staff Insp.","All roller fairleads have no record of overhauling & all are not rotating easily. ","Mooring Mach.","Mooring","Equipment Related",null,null,"Not Applicable","Not Applicable","All roller fairleads to be overhauled in next upcoming DD.","2020-01-31",null,"Not Started",null,"No",null,null,"Internal"]
[null,null,null,null,null,"2019-12-03T11:35:12","2019-11-01","Deficiency","Ship Staff","Ship Staff Insp.","All hatch cover cleats have no record of last overhauling. ","Cargo Mach.","Cargo / Ballast Systems","Equipment Related",null,null,"Not Applicable","Not Applicable","All hatch cover securing cleats are being overhauled by the ship's staff and parts being checked and lubricated. ","2020-01-31",null,"In progress",null,"No",null,null,"Internal"]
[null,null,null,null,null,"2019-04-12T00:05:32","2019-11-22","Observation","Ship Staff","Ship Staff Insp.","Stbd anchor, one fluke shows a bend & anchor not used since last 08 months by the previous management","Mooring Mach.","Mooring","Equipment Related",null,null,"Not Applicable","Not Applicable","To be replaced with spare anchor onboard in DD","2020-01-31",null,"Deferred to D D",null,"Yes",null,null,"Internal"]
[null,null,null,null,null,"2019-12-04T00:09:37","2019-11-22","Deficiency","Ship Staff","Ship Staff Insp.","Gangway Starboard side ladderstep guard is broken at various places .\t","Miscellaneous","Structural Condn. / WT integrity ","Equipment Related",null,null,"Not Applicable","Not Applicable","Needs to be repaired in DD.","2020-01-31",null,"Deferred to D D",null,"Yes",null,null,"Internal"]
[null,null,null,null,null,"2019-04-12T00:13:38","2019-11-22","Deficiency","Ship Staff","Ship Staff Insp.","Gangway Stanchions are corroded and wasted.\t","Miscellaneous","Structural Condn. / WT integrity ","Equipment Related",null,null,"Not Applicable","Not Applicable","Need to be repaired.","2020-01-31",null,"Not Started",null,"No",null,null,"Internal"]
[null,null,null,null,null,"2019-12-04T00:18:35","2019-11-22","Deficiency","Ship Staff","Ship Staff Insp.","Cargo hold bilge sounding pipe of cargo hold No.3 Port side, No.4 stbd side and No.9 Port side are broken and sounding the Bilges are not possible.","Deck Pipe / Fittings","Cargo / Ballast Systems","Equipment Related",null,null,"Not Applicable","Not Applicable","Cargo Hold Bilges sounding pipes to be renewed in Dry dock after hydroblasting and painted 3 coats epoxy.","2020-01-31",null,"Deferred to D D",null,"Yes",null,null,"Internal"]
[null,null,null,null,null,"2019-12-04T02:15:30","2019-12-04","Deficiency","Ship Staff","Ship Staff Insp.","The control block and reduction gear of the Bunker Davit Port side are damaged & missing. The davits were not in use for a long time by previous crew.","Miscellaneous","MARPOL Related","Equipment Related",null,null,"Not Applicable","Not Applicable","Overhaul the Bunker davits and check the condition of the bearings. New control block and reduction gear to be fitted on port side Bunker davit.","2020-01-31",null,"Deferred to D D",null,"Yes",null,null,"Internal"]

{"sheet":"Completed","index":1,"n_rows":35,"n_cols":28,"rows_kept":35,"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","8-10-2019",null,null,"Ship Name","MOJO"]
[]
[]
[]
[]
[]
[null,null,null,null,"ID","UNIQUE ID","Date Recorded","Type of Deficiency","Observer code","Type of Inspection","Description of Deficiency","Equipment Categories","Area of Observation","Deficiency Cause","VIQ Ref Number","Risk Value of Obs","PSC Ref Number","PSC MOU ID","Action Taken or Required","Target Date","PO Ref No.","Status Code","Date Completed","Drydock","Info Sharing","Critical Item","Audit Type","Superintendent Remarks"]
[null,null,null,null,null,"2019-12-03T09:45:43","2019-09-04","Deficiency","Ship Staff","Ship Staff Insp.","Understand from ship staff, vessel has water ingress issue from No.02 CH Tank top","Hull & Tanks","Cargo / Ballast Systems","Equipment Related",null,null,"Not Applicable","Not Applicable","NO.2 CH tanktop repaired with insert plate in presence of class surveyor at Putian berth.","2020-01-31",null,"Completed","2019-11-01","No",null,null,"Internal"]
[null,null,null,null,null,"2019-03-12T09:48:54","2019-09-04","Deficiency","Ship Staff","Ship Staff Insp.","All Garbage collection receptacles to be colour coded as per Company GMP","Miscellaneous","MARPOL Related","Equipment Related",null,null,"Not Applicable","Not Applicable","Garbage Receptacles colour coded as per the Garbage Management Plan","2020-01-31",null,"Completed","2019-12-03","No",null,null,"Internal"]
[null,null,null,null,null,"2019-12-02T21:02:39","2019-08-15","Deficiency","Ship Staff","Ship Staff Insp.","Gyro Compass Annual servicing over due since July 2019","Nav & comm. equip.","Navigation","Equipment Related",null,null,"Not Applicable","Not Applicable","Gyro Compass servicing & gyrosphere replaced with reconditioned gyrosphere at Xiamen.","2019-09-15","002D/19","Completed","2019-11-13","No",null,null,"Internal"]
[null,null,null,null,null,"2019-02-12T10:00:13","2019-08-19","Deficiency","Ship Staff","Ship Staff Insp.","AIS still showing fault in vessel speed feed. ","Nav & comm. equip.","Navigation","Equipment Related",null,null,"Not Applicable","Not Applicable","Newly received AIS installed by Shore technician at Xiamen.","2019-11-05",null,"Completed","2019-11-10","No",null,null,"Internal"]
[null,null,null,null,null,"2019-12-02T10:53:17","2019-08-20","Deficiency","Ship Staff","Ship Staff Insp.","Main Engine oil mist detector was showing error E014 which is negative pressure/air flow too low & the alarm is kept in off-scan condition.The alarm is in offscan condition. ","Main Engine ","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Same was rectified by ship staff after take over","2020-01-31","015E/19","Completed","2019-11-10","Yes",null,null,"Internal"]
[null,null,null,null,null,"2019-12-02T11:49:26","2019-08-21","Deficiency","Ship Staff","Ship Staff Insp.","Topping up compressor is not being used, as it is not building up pressure","Elect. Mach. & Equip.","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Ship staff has put the compressor in use after take over.","2020-01-31",null,"Completed","2019-11-15","No",null,null,"Internal"]
[null,null,null,null,null,"2019-12-03T06:13:11","2019-08-22","Deficiency","Ship Staff","Ship Staff Insp.","Overside painting stage is in poor condition. Bos'n chair with hook also not available onboard. ","Miscellaneous","General Appearance","Equipment Related",null,null,"Not Applicable","Not Applicable","Received at Xiamen.","2020-01-31","008D/19","Completed","2019-11-08","No",null,null,"Internal"]
[null,null,null,null,null,"2019-12-03T07:51:45","2019-08-22","Deficiency","Ship Staff","Ship Staff Insp.","Helicopter Landing FFE- Fireman's Outfit Suit (02 pcs) completely worn out, helmets broken & unwearable. ","LSA / FFA","LSA / FFA Appliances","Equipment Related",null,null,"Not Applicable","Not Applicable","Received at Xiamen","2020-01-31",null,"Completed","2019-11-08","No",null,null,"Internal"]
[null,null,null,null,null,"2019-12-03T08:09:25","2019-08-26","Deficiency","Ship Staff","Ship Staff Insp.","Spare foam liquid in Fire Station stored in unlabelled water bottles. ","LSA / FFA","LSA / FFA Appliances","Equipment Related",null,null,"Not Applicable","Not Applicable","Spare foam charges receive at Xiamen","2020-01-31","011D/19","Completed","2019-11-08","No",null,null,"Internal"]
[null,null,null,null,null,"2019-12-03T09:16:18","2019-08-29","Deficiency","Ship Staff","Ship Staff Insp.","Portable extinguishers spare charges not in compliance with Ship's Fire Safety Plan or even SOLAS or flag requirement. ","LSA / FFA","LSA / FFA Appliances","Equipment Related",null,null,"Not Applicable","Not Applicable","Spare charges for portable extinguishers received at Xiamen","2019-11-30",null,"Completed","2019-11-08","No",null,null,"Internal"]
[null,null,null,null,null,"2019-12-03T08:12:22","2019-08-27","Deficiency","Ship Staff","Ship Staff Insp.","VDR data never downloaded by ship staff.","Nav & comm. equip.","Navigation","Equipment Related",null,null,"Not Applicable","Not Applicable","Data downloaded by shore technician during re-programming at Xiamen","2020-01-31",null,"Completed","2019-11-10","No",null,null,"Internal"]
[null,null,null,null,null,"2019-12-03T09:32:15","2019-09-02","Deficiency","Ship Staff","Ship Staff Insp.","SI lights on lifebuoys on deck looks worn out. ","LSA / FFA","LSA / FFA Appliances","Equipment Related",null,null,"Not Applicable","Not Applicable","New SI lights received at Xiamen","2020-01-31","011D/19","Completed","2019-11-08","No",null,null,"Internal"]
[null,null,null,null,null,"2019-12-03T09:34:49","2019-09-02","Deficiency","Ship Staff","Ship Staff Insp.","EPIRB HRU expiring in Nov 2019. ","LSA / FFA","LSA / FFA Appliances","Equipment Related",null,null,"Not Applicable","Not Applicable","New HRU ordered & installed.","2019-11-05","011D/19","Completed","2019-11-10","No",null,null,"Internal"]
[null,null,null,null,null,"2019-12-03T09:37:02","2019-09-02","Deficiency","Ship Staff","Ship Staff Insp.","Helicopter FFE foam concentrate stock is manufactured 2013 / 2014. More than 05 years old. ","LSA / FFA","LSA / FFA Appliances","Equipment Related",null,null,"Not Applicable","Not Applicable","Replaced with new stock, received at Xiamen.","2019-11-30","011D/19","Completed","2019-11-08","No",null,null,"Internal"]
[null,null,null,null,null,"2019-12-03T10:45:09","2019-10-31","Deficiency","Ship Staff","Ship Staff Insp.","No.02 CH straight ladder bottom platform is damaged during present discharging operation at Luoyu port. ","Cargo Mach.","Cargo / Ballast Systems","Equipment Related",null,null,"Not Applicable","Not Applicable","Repaired by shore staff at Putian berth","2020-11-05",null,"Completed","2019-11-01","No",null,null,"Internal"]
[null,null,null,null,null,"2019-12-03T10:54:26","2019-11-01","Deficiency","Ship Staff","Ship Staff Insp.","Blr feed water salinometer in alarm condition. ","Boiler","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Rectified by ship staff after take over","2020-01-31",null,"Completed","2019-11-17","No",null,null,"Internal"]
[null,null,null,null,null,"2019-03-12T11:29:39","2019-11-01","Deficiency","Ship Staff","Ship Staff Insp.","Vessel has no spare mooring ropes, other than those on drums. ","Mooring Mach.","Mooring","Equipment Related",null,null,"Not Applicable","Not Applicable","Vessel supplied with 02 spare mooring ropes at Xiamen","2020-11-05","012D/19","Completed","2019-11-08","No",null,null,"Internal"]
[null,null,null,null,null,"2019-12-03T11:14:59","2019-11-01","Deficiency","Ship Staff","Ship Staff Insp.","Emergency generator abnormal alarm existing/not in ready to start position. ","Critical Equip.","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Inspected & rectified","2020-01-31",null,"Completed","2019-11-20","No",null,null,"Internal"]

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

{"sheet":"Ship_information","index":19,"n_rows":2,"n_cols":3,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["Ship_ID","Ship_Name","FILE_NAME"]
["93","MOJO","93_1573213188168.xlsm"]