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

{"sheet":"Mainsheet","index":0,"n_rows":27,"n_cols":28,"rows_kept":27,"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","2022-02-15",null,null,"Ship Name","PELAGOS (15-02-2022)"]
[]
[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,22867,"123_31/10/2021 9:43:17 pm","2021-11-25","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Some Links of Hatch Cover Chain thin down & wasted","Deck - Machinery","Cargo / Ballast Systems","Equipment Related",null,null,"Not Applicable","Not Applicable","VESSEL IS CHANGING THE HATCH COVER CHAINS","2022-02-25","PELA210022","In progress",null,"No","No","No","Internal","spare parts to be connected to vessel at convenient port, pls monitor and update."]
[null,null,null,null,22893,"123_2/12/2021 10:16:02 pm","2021-11-25","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Isolated heavy rust in hydraulic line and air lines deck branches. Need to derust and paint","Deck - Pipe / Fittings","General Appearance","External Factors","","","","","Derusting and painting","2022-02-25","","In progress",null,"No","No","No","Internal","pls speed up and advise date of completion."]
[null,null,null,null,22868,"123_1/12/2021 10:38:36 pm","2021-11-30","Critical Equipment","Ship Staff","Ship Staff Insp.","broken gear teeth of bilge pump Main gear","E/R - Pumps","MARPOL Related","Equipment Related","","","","","Welde and Build up Broken main gear teeth","2022-02-28","","Waiting spare",null,"No","No","No","Internal","Pls  raise RO for spare parts as necessary."]
[null,null,null,null,null,"123_15/2/2022 10:33:02 pm","2022-01-31","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","vessel is installed with Daihatsu DG engine, as per instruction manual fuel pressure compensating regulator at inlet & outlet has to be changed every 12,000 hrs,if no records available of last change order for new regulator & replace on all 3 DGs.","E/R - Aux. Engine","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","vessel raiseed RO for the same.","2022-02-28","PELA220039","Waiting spare",null,"No",null,null,"Internal"]
[null,null,null,null,null,"123_15/2/2022 10:35:59 pm","2022-01-31","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Vessel has only one AHU & compressor, to keep as contingency back order compressor motor, One AHU blower complete & compressor sufficient spares for ohauling including shaft seal(alternatively can order for recon compressor)","E/R - Aux. Mach.","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","vessel has raised ro and awaiting for the same ","2022-03-30","PELA220031 & PELA220030","Waiting spare",null,"No",null,null,"Internal"]
[null,null,null,null,null,"123_15/2/2022 10:38:17 pm","2022-01-31","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","No oil level seen in the davit hyd system oil block tank, the block is covered with old denso tape so internal condition of block is unknown, SS to remove denso tape, check the condition of block & carry out buffing & fresh paint coating, then apply new denso tape. ","LSA / FFA","Safety / LSA / FFA","Equipment Related",null,null,"Not Applicable","Not Applicable","vessel will carry out the maintenance.","2022-02-28",null,"In progress",null,"No",null,null,"Internal"]
[null,null,null,null,null,"123_15/2/2022 10:40:34 pm","2022-01-31","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Set of hyd hoses for LB davit release device to be checked, raise RO fir required hoses if not available.","LSA / FFA","Safety / LSA / FFA","Equipment Related",null,null,"Not Applicable","Not Applicable","vessel will carry out the maintenance and if required vessel will raise the ro.","2022-02-28",null,"In progress",null,"No",null,null,"Internal"]
[null,null,null,null,null,"123_15/2/2022 10:44:33 pm","2022-01-31","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","PMS is not maintained properly, there are still 400 jobs to be triggered, PMS to be rectified as per briefing carried out","Documentation","Cert. & Docu.","Human Error",null,null,"Not Applicable","Not Applicable","vessel will complete the pms jobs at the earliest","2022-03-15",null,"In progress",null,"No",null,null,"Internal"]
[null,null,null,null,null,"123_15/2/2022 10:46:30 pm","2022-01-31","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Recent cargo hold & ballast tank inspection records to be made in company DNV form & uploaded in PAL.","Documentation","Cert. & Docu.","Inappropriate Procedure",null,null,"Not Applicable","Not Applicable","vessel will carry out the same ","2022-02-28",null,"In progress",null,"No",null,null,"Internal"]
[null,null,null,null,null,"123_15/2/2022 10:50:40 pm","2022-01-31","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Some hyd cylinder for hatch cover were found leaking, same to be rectified at first available opportunity ","Deck - Machinery","General Appearance","Equipment Related",null,null,"Not Applicable","Not Applicable","vessel raied the ro for the same","2022-02-28","PELA220034","Waiting spare",null,"No",null,null,"Internal"]

{"sheet":"Completed","index":1,"n_rows":63,"n_cols":28,"rows_kept":63,"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","17-Jan-2022",null,null,"Ship Name","PELAGOS (17-01-2022)"]
[]
[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,21116,"123_16/9/2021 9:35:02 pm","2021-08-18","Defect","Ship Staff","Ship Staff Insp.","PORT USE PUMP UN ABLE TO GIIVE SUCTION AND DICHARGE PRESSURE ","E/R - Pumps","ISM Related","Equipment Related","","","","","OVERHAULED PUMP REPLACE DEFECTIVE IMPELLER, WEAR RING , SUBMERGE BUSH BEARING.","2021-09-15","","Completed","2021-09-15","No","No","No","Internal"]
[null,null,null,null,22870,"123_31/10/2021 8:56:30 pm","2021-08-20","Non Conformity","Ship Staff","Ship Staff Insp.","Departing Manilawith in complete ENC permit of the intended passage/voyage","Navigation - ECDIS","Navigation","Knowledge Based","","","","","Inquire assistance to Navtor & Office. Training to responsible officer","2021-08-27","","Completed","2021-08-23","No","No","No","Internal"]
[null,null,null,null,21117,"123_16/9/2021 2:01:49 am","2021-08-20","Observation","Ship Staff","Ship Staff Insp.","Departing Manila with incomplete ENC Permit of the intended passage/voyage.","Navigation - ECDIS","Navigation","Knowledge Based","","","","","Inquire assistance to IT and Navtor Provider to provide missing ENC permit. Training and familiarization carried out to all officers. Advised to Nav. Officer to make an advance inquiry of ENC permit for the next intended voyage as the external internet communication (Data Connection) very slow.","2021-08-25","","Completed","2021-08-23","No","No","No","Internal"]
[null,null,null,null,21118,"123_7/9/2021 12:32:03 pm","2021-08-27","Defect","Ship Staff","Ship Staff Insp.","No. 2 Marine Radar ARPA (X-Band) was 4 Times replace the fuse but same before Fuse Element was busted. We suspected the PCB Electronics Parts of CPU, TB Board, Control Unit, Power Supply Unit & other Electronics Parts was Damage & Broken.","Navigation - RADAR","Navigation","Equipment Related","","","","","Informed Office and Shore's Assistance","2021-09-27","","Completed","2021-09-11","No","No","No","Internal"]
[null,null,null,null,21115,"123_15/9/2021 9:18:22 pm","2021-08-28","Defect","Ship Staff","Ship Staff Insp.","Holed pipe of ME FW cooler seawater outlet sarificial pipe.","E/R - Main Engine","Eng. / Strg. Comp.","Equipment Related","","","","","Replaced with new pipe and flange.","2021-09-07","","Completed","2021-09-07","No","No","No","Internal"]
[null,null,null,null,21119,"123_15/9/2021 9:31:53 pm","2021-08-28","Defect","Ship Staff","Ship Staff Insp.","ME FW cooler seawater sacrificial inlet pipe leak on seam side.","E/R - Pipes/ valves & fittings","Eng. / Strg. Comp.","Equipment Related","","","","","Repair by welding seam portion of the pipe, since the pipe is still in good condition and its thickness.","2021-09-07","","Completed","2021-09-07","No","No","No","Internal"]
[null,null,null,null,21121,"123_15/9/2021 9:48:29 pm","2021-08-28","Defect","Ship Staff","Ship Staff Insp.","Main Cooling SW pump no.2 Sacrificial pipe at suction side leak.","E/R - Pipes/ valves & fittings","Eng. / Strg. Comp.","Equipment Related","","","","","Replaced with new pipe and flange.","2021-09-07","","Completed","2021-09-07","No","No","No","Internal"]
[null,null,null,null,21120,"123_7/9/2021 12:08:59 pm","2021-09-06","Defect","Ship Staff","Ship Staff Insp.","Radar S-Band Observed Poor sensitivity & Echo","Navigation - RADAR","Navigation","Equipment Related","","","","","Inquire Office and Maker Assistance or Shore's Service Technician at Next Port","2021-10-06","","Completed","2021-09-11","No","No","No","Internal"]
[null,null,null,null,21112,"123_16/9/2021 2:14:52 am","2021-09-08","Observation","Ship Staff","Ship Staff Insp.","Both ECDIS unable to save route plan and load new route plan in ECDIS monitor ","Navigation - ECDIS","Navigation","Equipment Related","","","","","Inquires assistance to office and Maker","2021-10-08","","Completed","2021-09-10","No","No","No","Internal"]
[null,null,null,null,22879,"123_31/10/2021 9:00:35 pm","2021-09-22","Non Conformity","Ship Staff","Ship Staff Insp.","Some missing entry in Deck Log Book","Documentation","Cert. & Docu.","Knowledge Based","","","","","Briefing/Training carried out to all OOW.","2021-10-30","","Completed","2021-09-30","No","No","No","Internal"]
[null,null,null,null,22863,"123_20/9/2021 2:38:06 pm","2021-09-28","Defect","Ship Staff","Ship Staff Insp.","Wear down of impeller and leakage on pump body due to mechanical seal damage.","E/R - Boiler,E/R - Pumps","ISM Related","Equipment Related","","","","","Overhauled and checked.Need to replace the damage mechanical seal and impeller as a set. We request  spare  for replacement.","2021-10-31","PELA210059 BOILER FEED PUMP","Completed","2021-12-10","No","No","No","Internal"]
[null,null,null,null,22880,"123_30/9/2021 9:54:24 pm","2021-09-30","Defect","Ship Staff","Ship Staff Insp.","DE-SYNCHRONIZATION OF DG NO.1 WAS NOT ABLE AND WE FOUND OUT THAT THE WOODWARD APM MOTOR CONTROL WAS BURNT LOCATED AT DG NO 1 MAIN CONTROL PANEL AT ER CONTROL ROOM.","E/R - Aux. Engine","ISM Related","Equipment Related","","","","","CARRIED OUT MANUALLY DE-SYNCHRONIZATION AND CHECKED THE APM MOTOR / FOUND BURNT. SECURE DG NO.1 / NEEDED TOTAL REPLACEMENT OF APM MOTOR CONTROL.","2021-12-30","PO Ref No. PELA210063","Completed","2021-10-29","No","No","No","Internal"]
[null,null,null,null,22865,"123_31/10/2021 9:17:53 pm","2021-10-25","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","FPT Water Ingress Alarm Sensor Defective","Miscellaneous","Structural Condn. / WT integrity ","Equipment Related","","","","","replaced with new spare PCB / now in good working condition.","2022-01-25","PELA210085","Completed","2021-12-09","No","No","No","Internal"]
[null,null,null,null,22866,"123_31/10/2021 9:37:01 pm","2021-10-25","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Low insulation found in 440V & 220V on MSB","Elect. Mach. & Equip.","Eng. / Strg. Comp.","Equipment Related","","","","","Informed Office and Identify Caused and rectify","2021-12-25","","Completed","2021-10-27","No","No","No","Internal"]
[null,null,null,null,22871,"123_31/10/2021 9:55:24 pm","2021-10-25","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Rust & Difficult to open the steering mushroom vent head in poop deck","Deck - Pipe / Fittings","General Appearance","Equipment Related","","","","","Derusted, freed and painted","2022-01-25","","Completed","2021-10-26","No","No","No","Internal"]
[null,null,null,null,22872,"123_31/10/2021 9:47:54 pm","2021-10-25","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Heavy rust found in watertight door edges where the gasket in place in steering, CO2 Room and emergency exit watertight door","Miscellaneous","Structural Condn. / WT integrity ","Equipment Related","","","","","Derusted and painted","2022-01-25","","Completed","2021-10-26","No","No","No","Internal"]
[null,null,null,null,22896,"123_2/12/2021 9:04:14 pm","2021-10-25","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","ER Bilge/OWS pipelines not sealed as per Company Policy, same to be carried out & form filled","E/R - Pipes/ valves & fittings","MARPOL Related","Knowledge Based","","","","","ER Bilge/OWS Pipelines Flanges sealed as per Compancy Policy and form filled","2021-10-30","","Completed","2021-10-27","No","No","No","Internal"]
[null,null,null,null,22897,"123_2/12/2021 9:22:48 pm","2021-10-25","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","ER ORB not countersigned by officer incharge","E/R - Pipes/ valves & fittings","MARPOL Related","Knowledge Based","","","","","Briefed and advised to officer incharge to countersigned ER ORB entry not only C/E for strict compliance.","2021-10-28","","Completed","2021-10-25","No","No","No","Internal"]
[null,null,null,null,22898,"123_2/12/2021 9:27:02 pm","2021-10-25","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","One of the ER DB Tank Sounding CAP missing, same to be always fixed","E/R - Pipes/ valves & fittings","MARPOL Related","Knowledge Based","","","","","Put back sounding cap and fixed. Briefed all rating and Eng'r to make sure all sounding CAP to be put back and fixed after used accordingly.","2021-10-26","","Completed","2021-10-25","No","No","No","Internal"]
[null,null,null,null,22899,"123_2/12/2021 9:39:15 pm","2021-10-25","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Fingersavers & impact gloves not placed in ER workshop for quick availability","LSA / FFA","Safety / LSA / FFA","Knowledge Based","","","","","Fingersavers & impact gloves handed over to 2E to place in ER workshop","2021-10-30","","Completed","2021-10-27","No","No","No","Internal"]
[null,null,null,null,22900,"123_2/12/2021 9:51:51 pm","2021-10-25","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Incinerator electrical panel found dirty, same to be soap washed","Elect. Mach. & Equip.","General Appearance","Knowledge Based","","","","","Instructed Engine rating to clean and soap washed Incinerator electrical panel","2021-10-30","","Completed","2021-10-26","No","No","No","Internal"]
[null,null,null,null,22901,"123_2/12/2021 9:56:49 pm","2021-10-25","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Deck walkway and snap back zone yellow mark faded and peel off. need to repaint","Miscellaneous","General Appearance","External Factors","","","","","Repainted faded and peel off yellow mark in Deck walkway and snap back zone ","2021-11-25","","Completed","2021-11-09","No","No","No","Internal"]
[null,null,null,null,22902,"123_2/12/2021 10:03:51 pm","2021-10-25","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Isolated Heavy rust found underneath of deck fire line. Need to derust and paint ore replace new pipe if needed","Deck - Pipe / Fittings","General Appearance","External Factors","","","","","Derusted and painted.","2022-01-25","","Completed","2021-12-01","No","No","No","Internal"]
[null,null,null,null,22903,"123_2/12/2021 10:25:08 pm","2021-10-25","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Some Markings on deck faded, need to redo the stenciling","Miscellaneous","General Appearance","External Factors","","","","","Restenciling deck faded marking","2021-11-04","","Completed","2021-11-03","No","No","No","Internal"]
[null,null,null,null,22904,"123_2/12/2021 10:30:12 pm","2021-10-25","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Steering gear chemical locker to square up and arrange not to mix or close the alkaline and acid","Miscellaneous","Safety / LSA / FFA","Knowledge Based","","","","","Square up neatly and separate alkaline and acid.","2021-10-30","","Completed","2021-10-26","No","No","No","Internal"]
[null,null,null,null,22905,"123_2/12/2021 10:37:42 pm","2021-10-25","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Hook latche defective of general use handling crane, provision crane and hose handling crane. To repair/fabricate hook latche spring","Deck - Machinery","Safety / LSA / FFA","Equipment Related","","","","","Hook lacthe spring fabricated","2021-11-04","","Completed","2021-10-26","No","No","No","Internal"]
[null,null,null,null,21114,"123_15/9/2021 8:15:37 pm","2021-10-25","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Marine Type Packaged Air Conditioner for Galley observed no output air cooling in the Galley even though the Thermostat Knob Controller was in the Maximum Cold Point.","Accommodation","MLC Related","Equipment Related","","","","","We Pump down the system & no collected Refrigerant Gas Freon was seen. We performed leak test by liquid soap mixed with water, Ref. Gas Leak Detector, Vacuum Pump & we found out multiple leakage in the Evaporator Unit. In the Evaporator the Air Suction Grilled was rusted, corroded & eliminated. Create RO for the whole 1 set of Evaporator. Received spare and installed","2021-12-10","","Completed","2021-12-01","No","No","No","Internal"]
[null,null,null,null,22873,"123_31/10/2021 10:50:32 pm","2021-10-28","Non Conformity","FSC Inspector","Flag State Insp.","Cew Rat#17 Mr Porras - STCW VI/2.1 Expired 04 Sep 2021","Documentation","Cert. & Docu.","Knowledge Based","","","","","Inquired confirmation to Manning Office if it is mandatory to renew/have the said National Certificate or not as per STCW and Liberian Flag State requirements. They confirmed is not mandatory of his rank.","2021-11-28","","Completed","2021-10-30","No","No","No","External"]
[null,null,null,null,22874,"123_31/10/2021 10:55:07 pm","2021-10-28","Non Conformity","FSC Inspector","Flag State Insp.","Recovery of Person from water manual section 10 - not filled with ships specific information required by company","Documentation","ISM Related","Knowledge Based","","","","","Immediately inserted the required list of ship specific information in the manual.","2021-11-28","","Completed","2021-10-28","No","No","No","External"]
[null,null,null,null,22875,"123_31/10/2021 10:58:57 pm","2021-10-28","Non Conformity","FSC Inspector","Flag State Insp.","Following Pubs outdated w/no access to electronic: IMDG Code, SOLAS, IMSBC","Documentation","ISM Related","Knowledge Based","","","","","Immediate raised requisition for the new edition ","2021-11-10","PELA215045","Completed","2021-11-03","No","No","No","External"]
[null,null,null,null,22876,"123_31/10/2021 11:03:11 pm","2021-10-28","Observation","FSC Inspector","Flag State Insp.","Poop Dk-S/S; Mooring Winch (Outb)-Brake Lining very poor condition","Deck - Mooring Machinery","Mooring","Equipment Related","","","","","Replace new brake lining","2021-11-08","","Completed","2021-11-06","No","No","No","External"]
[null,null,null,null,22877,"123_31/10/2021 11:07:52 pm","2021-10-29","Non Conformity","Others (Eg. Insurance etc.)","Others (Eg. Insurance etc.)","Vessel's security checkpoint unmanned at time surveyor boarded.","Miscellaneous","ISPS Related","Knowledge Based","","","","","Immediate training/briefing to all officers and deck crew for strict compliance of ISPS requirements. Don't ever left vessel security checkpoint at all times.","2021-10-29","","Completed","2021-10-29","No","No","No","External"]
[null,null,null,null,22878,"123_13/11/2021 11:12:55 pm","2021-11-11","Observation","Ship Staff","Ship Staff Insp.","Freefall lifeboat rudder slight dented","LSA / FFA","Safety / LSA / FFA","Equipment Related","","","","","Remove and straighten the rudder ","2021-11-30","","Completed","2021-11-13","No","No","No","Internal"]
[null,null,null,null,22881,"123_1/12/2021 11:22:03 pm","2021-11-13","Non Conformity","Ship Staff","Ship Staff Insp.","Fire hose that was used during the fire drill found not secure after drill, was observed on the next day when safety rounds/check conducted.","LSA / FFA","Safety / LSA / FFA","Knowledge Based","","","","","Secured back to designated fire box and highlight on upcoming toolbox and safety meeting.","2022-02-13","","Completed","2021-11-27","No","No","No","Internal"]
[null,null,null,null,null,"123_1/12/2021 5:38:10 am","2021-11-21","Observation","Ship Staff","Ship Staff Insp.","INMARSAT-C Printer belt broke/tear off","Navigation - GMDSS & Communication","Communication","Equipment Related",null,null,"Not Applicable","Not Applicable","NEWLY RECIEVED INMERSAT-C PRINTER INSTALLED AND TRIED OUT FOUND IN GOOD WORKING CONDITION.","2022-02-21","PELA210106","Completed","2022-01-04","No",null,null,"Internal"]
[null,null,null,null,null,"123_31/10/2021 9:26:57 pm","2021-11-25","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Few Fire Detectors found not operating properly","LSA / FFA","Safety / LSA / FFA","Equipment Related",null,null,"Not Applicable","Not Applicable","ALL FIRE DETECTORS TESTED AND TRIED OUT  CHANGED FAULTY FIRE DETECTOR. NOW ALL FIRE DETECTORS FOUND IN GOOD WORKING ORDER.","2022-02-25","PELA210076","Completed","2022-01-15","No",null,null,"Internal"]
[null,null,null,null,null,"123_2/12/2021 10:55:44 pm","2021-11-25","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","One side of Galley hot plate out of order. Raise requisition of the requires spare","Accommodation","MLC Related","Equipment Related",null,null,"Not Applicable","Not Applicable","DEFECTIVE HOTPLATE REPLACED WITH THE SPARE RECIEVED AND MADE OPERATIONAL.","2022-02-25","PELA210051","Completed","2022-01-17","No",null,null,"Internal"]
[null,null,null,null,null,"123_2/12/2021 10:33:52 pm","2021-11-25","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","No foot stopping arrangement in lathe and drilling machine. To raise requsition and install once receive","Miscellaneous","Safety / LSA / FFA","Knowledge Based",null,null,"Not Applicable","Not Applicable","Recieved Foot switch connected to the syatem found working in good condition.","2022-02-25",null,"Completed","2022-02-16","No",null,null,"Internal"]
[null,null,null,null,null,"123_7/9/2021 11:34:43 am","2021-12-25","Defect","Ship Staff","Ship Staff Insp.","WBTS JFE Ballast Ace Unit not working due to failure on No. 2 TRO unit and Pneumatic Solenoid Valve Defective","Deck - Machinery","Cargo / Ballast Systems","Equipment Related",null,null,"Not Applicable","Not Applicable","REPLACED FLOW CONTROL REGULATOR OF TRO UNIT NO.1 AND 2. UPDATED THE SYSTEM DATE REPLACED. REPLACED BUFFER SOLUTION AND TOTAL CHLORINE INDICATOR.","2022-02-28","PELA210102","Completed","2022-02-11","No",null,null,"Internal"]
[null,null,null,null,null,"123_14/1/2022 6:45:28 am","2022-01-10","Critical Equipment","Ship Staff","Ship Staff Insp.","Emergency generator no. 1 battery for starting  was defective due to the voltage drop. It need to be replace","LSA / FFA","Safety / LSA / FFA","Equipment Related",null,null,"Not Applicable","Not Applicable","EMERGENCY GENERATOR BATTERY BANK NO.1 REPLACED WITH THE RECIEVED BATTRIES AND TRIED OUT FOUND IN GOOD WORKING CONDITION.","2022-01-30","PELA220013 - EMERGENCY GENERATOR BATTERY","Completed","2022-01-17","No",null,null,"Internal"]
[null,null,null,null,null,"123_2/2/2022 10:32:01 am","2022-01-30","Defect","Ship Staff","Ship Staff Insp.","ENGINE ROOM BLOWER AIR OPERATING PIPE FOR FLAPS FOUND RUSTED AND DETORIATED","E/R - Aux. Mach.","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","REPLACED AIR PIPE FOR FLAP AND MADE OPERATIONAL.","2022-02-11",null,"Completed","2022-02-01","No",null,null,"Internal"]
[null,null,null,null,null,"123_15/2/2022 10:20:09 pm","2022-01-31","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","All the heat exchanger/coolers which are SW cooled like aircon condenser, Atmospheric condenser, reefer etc. anodes have to be checked & replaced if required.","E/R - Aux. Mach.","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","VESSEL CHANGED THE ANODES FOR ALL THE SW COOLED EWUIPMENTS.","2022-02-24",null,"Completed","2022-03-07","No",null,null,"Internal"]
[null,null,null,null,null,"123_15/2/2022 10:25:02 pm","2022-01-31","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","luminance in steering room is very less ,same to be upgraded with LED lights","Elect. Mach. & Equip.","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","STEERING GEAR ROOM ALL LUMINANCE LIGHT UPGRADED TO LED.","2022-02-25",null,"Completed","2022-02-20","No",null,null,"Internal"]
[null,null,null,null,null,"123_15/2/2022 10:27:07 pm","2022-01-31","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","lathe m/c is not provided with protection glass on the check the prevent flying out of particles during cutting, same to be fabricated.","E/R - Aux. Mach.","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","VESSEL FABRICATED THE SAME FOR THE LATHE MACHINE","2022-02-24",null,"Completed","2022-02-21","No",null,null,"Internal"]
[null,null,null,null,null,"123_15/2/2022 10:54:05 pm","2022-01-31","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Old refrigerator & Washing m/c are kept in laundry room, same to be disposed of at next convenient port.","Deck - Pipe / Fittings","General Appearance","Equipment Related",null,null,"Not Applicable","Not Applicable","vessel oflanded the same at convinent port","2022-02-28",null,"Completed","2022-02-20","No",null,null,"Internal"]
[null,null,null,null,null,"123_15/2/2022 10:56:13 pm","2022-01-31","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Ballast water record book was found not filled properly as per required code, same to refill.","Documentation","Cert. & Docu.","Inappropriate Procedure",null,null,"Not Applicable","Not Applicable","SAME WAS FILLED PROPERLY ","2022-02-28",null,"Completed","2022-02-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]
["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"]
["123","PELAGOS (17-01-2022)","123_1642413637456.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"]