{"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":1,"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":38,"n_cols":28,"rows_kept":38,"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-Jul-2022",null,null,"Ship Name","FANTASEA (21-06-2022)"]
[]
[null,null,null,null,null,null,"VERSION : 2.0"]
[]
[]
[]
[null,null,null,"ID","SHIPSIDE UNIQUEID","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,52768,"0_Thu Jun 16 2022 22:02:35 GMT+0800","2022-05-31T08:00:00","Observation","Ship Staff","Ship Staff Insp.","Oxygen and Acetylene Flash back arrestor renewal date to be checked. Should be less than 5 years","E/R - Aux. Mach.","ISM Related","Equipment Related","","","","","No history found. Checking other records in all possible location","2022-07-29T08:00:00","FANT220203 ","Waiting spare",null,"No","No","No","Internal","Need to check supply history during vessel take over."]
[null,null,null,25753,12541,"0_Thu Jun 16 2022 23:11:17 GMT+0800","2022-05-31T23:59:35","Defect","Ship Staff","Ship Staff Insp.","FWG Distillate pump is incapable of discharging into the filling line.","E/R - Aux. Mach.","Eng. / Strg. Comp.","Equipment Related","","","","","overhauled pump many times to keep the production 'ON'","2022-07-30T23:59:35","FANT220201","Waiting spare",null,"No","No","No","Internal","RO is under process, will arrange supply at the earliest convenirnet t port"]
[null,null,null,null,93094,"0_Fri Jun 17 2022 19:05:00 GMT+0800","2022-05-31T08:00:00","Defect","Ship Staff","Ship Staff Insp.","5P FO Bunker filling line has pin hole.","Deck - Pipe / Fittings","MARPOL Related","Equipment Related","","","","","Temporarily repaired with clamp arrangement. Needs to be done only in DD as it is penetrating the Bulkhead. If the tank is Empty, will try to gas free and do the required Hot work.","2023-03-31T08:00:00","","Deferred to D D",null,"Yes","No","No","Internal","Ship staff to check for feasibility of Permanent repair & report to office in separate message."]
[null,null,null,null,38169,"0_Fri Jun 17 2022 19:07:46 GMT+0800","2022-05-31T08:00:00","Breakdown,Defect","Ship Staff","Ship Staff Insp.","Toilet Flushing valve of most of the cabin is non operational","Accommodation","MLC Related","Equipment Related","","","","","Spares rec'd in Bhosphorus. Will start installing to close the defects as early as possible.","2022-07-31T08:00:00","FANT220188","In progress",null,"No","No","No","Internal","Flush valves will be connected at Suez."]
[null,null,null,null,82810,"0_Fri Jun 17 2022 19:11:31 GMT+0800","2022-05-31T08:00:00","Defect","Ship Staff","Ship Staff Insp.","Bridge Split AC non operational","Accommodation","MLC Related","Equipment Related","","","","","Requirement and technical specifications have been sent to the office.","2022-08-15T08:00:00","Office to arrange","Waiting spare",null,"No","No","No","Internal","Technician attended vessel at at Paradip found Split AC compressor blown off.  110v Split AC not readily available. Will try to arrange supply once vessel will be back to Singapore or China."]
[null,null,null,null,23869,"0_Fri Jun 17 2022 18:59:23 GMT+0800","2022-05-31T08:00:00","Breakdown","Ship Staff","Ship Staff Insp.","Hatch cover Hyd. Jacks 2 nos are non operational.","Deck - Machinery","Cargo / Ballast Systems","Equipment Related","","","","","5 Jacks rec'd in Bhosphorus / Turkey. Planning to install from 8th July onwards.","2022-07-31T08:00:00","FANT220142","In progress",null,"No","No","No","Internal","5 nos electro-jacks will be connected at Suez."]
[null,null,null,null,87028,"0_Fri Jun 17 2022 19:02:12 GMT+0800","2022-05-31T08:00:00","Defect","Ship Staff","Ship Staff Insp.","HATCH COVER CLOSING AND OPENING ELECTRIC MOTOR in Poor condition","Cargo Mach.","Cargo / Ballast Systems","Equipment Related","","","","","Motor rec'd. Will be mounting and close the defect as early as possible","2022-07-31T08:00:00","FANT220141","In progress",null,"No","No","No","Internal","Being connected at Suez around 22nd June 2022."]
[null,null,null,null,96727,"0_Fri Jun 17 2022 18:55:15 GMT+0800","2022-05-31T08:00:00","Observation","Ship Staff","Ship Staff Insp.","Accommodation AC performance is not satisfactory","E/R - Aux. Mach.","Eng. / Strg. Comp.","Equipment Related","","","","","Requisition sent for Evaporator coil","2022-08-31T08:00:00","FANT220185","Waiting spare",null,"No","No","No","Internal","New evaporator coil is being supplied by owner."]
[null,null,null,null,34269,"127_Fri Jul 08 2022 01:07:06 GMT+0800","2022-07-01T08:00:00","Defect","Ship Staff","Ship Staff Insp.","#2 DG LO sump low level alarm non operational","E/R - Aux. Engine","Eng. / Strg. Comp.","Equipment Related","","","","","Spare rec'd. Waiting for suitable opportunity to remove the oil from the sump and then replace the faulty switch.","2022-07-30T08:00:00","FANT220189","In progress",null,"No","No","No","Internal"]
[null,null,null,null,75845,"127_Fri Jul 08 2022 01:26:30 GMT+0800","2022-06-29T08:00:00","Defect","Ship Staff","Ship Staff Insp.","NO 2 DG C.W. BYPASS VALVE BODY FLANGE BROKEN. AND VALVE LEAKING FROM TALE TALE HOLE.","E/R - Aux. Engine","Eng. / Strg. Comp.","Equipment Related","","","","","Temporarily repaired. Waiting for the spare","2022-08-15T08:00:00","FANT220211","Waiting spare",null,"No","No","No","Internal"]
[null,null,null,null,55989,"0_Fri Jul 08 2022 01:36:41 GMT+0800","2022-07-01T08:00:00","Defect","Ship Staff","Ship Staff Insp.","#1 Feed Pump abnormal alarm due to malfunction of the relay. No Electrical spares and Timer.  Also Quick coupling and its o ring on the boiler burner is leaking. \n\n\n\n\n\n\n\n\n\n\n\n\n\n\n ","E/R - Boiler","Eng. / Strg. Comp.","Equipment Related","","","","","All the Electrical problems solved and Boiler is operational on Auto mode. Waiting for spares to rectify the other issues.","2022-08-15T08:00:00","FANT220215","Waiting spare",null,"No","No","No","Internal"]
[null,null,null,null,16959,"127_Fri Jul 08 2022 01:42:07 GMT+0800","2022-06-21T08:00:00","Defect","Ship Staff","Ship Staff Insp.","#2 DG Speed Switch is faulty. ","E/R - Aux. Engine","Eng. / Strg. Comp.","Equipment Related","","","","","New spare rec'd. But it has an issue of not detecting RPM. Msg. has been sent to get the Trouble Shooting.","2022-07-15T08:00:00","FANT220206","In progress",null,"No","No","No","Internal"]
[null,null,null,null,59666,"0_Fri Jul 08 2022 01:46:54 GMT+0800","2022-06-22T08:00:00","Defect","Ship Staff","Ship Staff Insp.","Forward Horn Solenoid valve is faulty. Presently not usable. ","Deck - Machinery","Navigation","Equipment Related","","","","","Solenoid valve not functioning. Spare requisition has been sent.","2022-08-01T08:00:00","FANT220207","Waiting spare",null,"No","No","No","Internal"]
[null,null,null,null,76839,"0_Fri Jul 08 2022 01:56:26 GMT+0800","2022-06-01T08:00:00","Critical Equipment","Ship Staff","Ship Staff Insp.","Emergency Fire Pump Mechanical seal is not in good condition.","Critical Equip.","Eng. / Strg. Comp.","Equipment Related","","","","","Pump overhauled twice by lapping the sealing face.","2022-07-31T08:00:00","FANT220183","Waiting spare",null,"No","No","No","Internal"]
[null,null,null,null,15712,"0_Fri Jul 08 2022 02:05:32 GMT+0800","2022-06-01T08:00:00","Defect","Ship Staff","Ship Staff Insp.","DG FO temp controller not accurate","E/R - Aux. Engine","Eng. / Strg. Comp.","Equipment Related","","","","","Spare controller rec'd. Will install and rectify the issue.","2022-07-31T08:00:00","FANT225033","In progress",null,"No","No","No","Internal"]
[null,null,null,null,93348,"0_Fri Jul 08 2022 02:08:18 GMT+0800","2022-05-30T08:00:00","Observation","Ship Staff","Ship Staff Insp.","Galley AC non operational","Accommodation","MLC Related","Equipment Related","","","","","Will check its operation as there is no any history about its issue. Will raise the spare requisition as required.","2022-08-30T08:00:00","","In progress",null,"No","No","No","Internal"]
[null,null,null,null,81649,"0_Fri Jul 08 2022 02:10:39 GMT+0800","2022-05-30T08:00:00","Defect","Ship Staff","Ship Staff Insp.","ECR alarm Printer fault","E/R - Aux. Mach.","Eng. / Strg. Comp.","Equipment Related","","","","","Planning to check the device and make requisition as required.","2022-08-31T08:00:00","","In progress",null,"No","No","No","Internal"]
[null,null,null,null,59567,"0_Fri Jul 08 2022 02:16:23 GMT+0800","2022-06-15T08:00:00","Defect","Ship Staff","Ship Staff Insp.","FWG JCW Inlet and Bypass valve Frozen.","E/R - Pipes/ valves & fittings","Eng. / Strg. Comp.","Equipment Related","","","","","Tried Easing up. But the valve disc is jammed and spindle is hard to move. Waiting for the suitable opportunity to isolate the ME JCW system and overhaul the valves.","2022-07-31T08:00:00","","In progress",null,"No","No","No","Internal"]
[null,null,null,null,56837,"0_Fri Jul 08 2022 02:21:19 GMT+0800","2022-07-01T08:00:00","Breakdown","Ship Staff","Ship Staff Insp.","DG LO Purifier not working. ","E/R - Aux. Mach.","Eng. / Strg. Comp.","Equipment Related","","","","","Checking the spare availability. After confirmation will raise spare requisition","2022-08-30T08:00:00","","In progress",null,"No","No","No","Internal"]
[null,null,null,null,79910,"0_Fri Jul 08 2022 02:24:23 GMT+0800","2022-07-01T08:00:00","Defect","Ship Staff","Ship Staff Insp.","No. 1 DG Booster Pump Oil seal leaking.","E/R - Pumps","Eng. / Strg. Comp.","Equipment Related","","","","","Checking for spare. Will overhaul if spares available. Otherwise will raise spare requisition.","2022-08-31T08:00:00","","In progress",null,"No","No","No","Internal"]
[null,null,null,null,46593,"0_Fri Jul 08 2022 02:29:37 GMT+0800","2022-06-15T08:00:00","Defect","Ship Staff","Ship Staff Insp.","All FOT Heating steam coil Valves to renew ","E/R - Pipes/ valves & fittings","Eng. / Strg. Comp.","Equipment Related","","","","","All FOT heating coil pressure tested. Most of the valves are found leaking. Checking the spare valves availability.  Store requisition will be sent at the earliest.","2022-08-31T08:00:00","","In progress",null,"No","No","No","Internal"]

{"sheet":"Completed","index":1,"n_rows":40,"n_cols":28,"rows_kept":40,"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-Jul-2022",null,null,"Ship Name","FANTASEA (21-06-2022)"]
[]
[null,null,null,null,null,null,"VERSION : 2.0"]
[]
[]
[]
[null,null,null,"ID","SHIPSIDE UNIQUEID","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,21253,null,"127_9/28/2021 5:59:58 AM","2021-09-23T23:59:35","Defect","Ship Staff","Engineering Audit","Lost of starboard accommodation ladder during Suez Canal Transit due to equipment age.","Accommodation","Structural Condn. / WT integrity ","Equipment Related","","","","","GSM Office arranging very urgent replacement. new accommodation ladder recvd at ROtterdam and fitted by ship's staff on 23-Nov-2021. Load tested in presence of Class on 14-Dec-2021","2021-12-09T23:59:35","","Completed","2021-12-13T23:59:35","No","No","No","Internal","Will be connected at next port."]
[null,null,null,21251,null,"127_9/28/2021 5:20:23 AM","2021-09-25T23:59:35","Defect","Ship Staff","Engineering Audit","Port side Accommodation Ladder found some parts decomposing making it not suited for safe use.","Accommodation","Structural Condn. / WT integrity ","Equipment Related","","","",""," RO FANT210116 raised. GSM Office arranging very urgent replacement. New accommodation ladder recvd at ROtterdam and fitted by shore workshop at Yantai, China on 04-JAN-2022. Load tested in presence of Class on 06-JAN-2022 ","2021-12-25T23:59:35","FANT210116","Completed","2022-01-05T23:59:35","No","No","No","Internal","New ladder will be connected at next port of call."]
[null,null,null,21252,null,"127_9/28/2021 5:29:50 AM","2021-09-25T23:59:35","Defect","Ship Staff","Engineering Audit","Found starboard some parts Pilot Assisting Ladder decomposing. Also found angle bar doubler which is bulging underneath due to decomposing part of the ladder.","Accommodation","Structural Condn. / WT integrity ","Equipment Related","","","","","Raised an urgent RO for replacement.  RO FANT210116 raised. GSM Office arranging very urgent replacement. New Pilot  ladder recvd at Rotterdam and fitted by shore workshop at Yantai, China on 06-JAN-2022. Load tested in presence of Class on 06-JAN-2022. ","2021-12-09T23:59:35","FANT210117","Completed","2022-01-05T23:59:35","No","No","No","Internal","Already in order & to be connected to vessel at next port of call."]
[null,null,null,21250,null,"127_9/28/2021 5:49:44 AM","2021-09-26T23:59:35","Defect","Ship Staff","Engineering Audit","Echo Sounder alarm indicating sea bed not detected when making course alteration in narrow channel such as in Suez Canal, Dardanalles & Bosphorus Straits transits and when giving M/E astern propulsions during anchor operation.","Navigation - Echo Sounder / Speed Log","Navigation","Equipment Related","","","","","Noticed during transits in manuevering during channeling in Suez Canal Transit and while anchoring at Port Said. Found back into normal working condition in deep water. Observed another malfunction during transit inbound to Black Sea. Must be check by certified shore technician.","2021-11-29T23:59:35","","Completed","2021-12-29T23:59:35","No","No","No","Internal","resolved with remote troubleshooting"]
[null,null,null,22597,null,"127_11/16/2021 4:18:11 PM","2021-11-15T23:59:35","Defect","Owner / Marine / Tech. Suptd.","Engineering Audit","Galley griller 440V low insulation","Elect. Mach. & Equip.","Safety / LSA / FFA","Equipment Related","","","","","to raised req","2021-11-24T23:59:35","","Completed","2021-11-29T23:59:35","No","No","No","Internal","replaced with onboard spare"]
[null,null,null,22598,null,"127_11/16/2021 4:11:56 PM","2021-11-15T23:59:35","Critical Equipment","Owner / Marine / Tech. Suptd.","Engineering Audit","Water mist solenoid valve for incinerator supply leaking","LSA / FFA","Safety / LSA / FFA","Equipment Related","","","","","raised requisition","2021-11-24T23:59:35","FANT210040 water mist fire fighting system","Completed","2021-11-29T23:59:35","No","No","No","Internal","rectified with onboard spare"]
[null,null,null,23556,null,"127_13-Jan-22 12:58:54","2021-12-08T23:59:35","Critical Equipment","Ship Staff","Ship Staff Insp.","BILGE PUMP IN-OPERATIONAL SCRATCHED AND OVERSIZED LINER AND DAMAGED PISTON RINGS.","Critical Equip.","MARPOL Related","Equipment Related","","","","","RO FANT210186 RAISED FOR NEW PUMP","2022-01-04T23:59:35","","Completed","2022-01-04T23:59:35","No","No","No","Internal"]
[null,null,null,23555,null,"127_13-Jan-22 13:08:17","2021-12-21T23:59:35","Defect","Ship Staff","Ship Staff Insp.","BOILER NOT WORKING IN AUTOMATIC MODE.  ","E/R - Boiler","Eng. / Strg. Comp.","Equipment Related","","","","","REQUESTED SHORE SERVICE. PILOT CUT OFF VALVE AND NOZZLE REPAIRED. COMBUSTION SETTINGS ADJUSTED BY SHORE TECHNICIAN.","2022-01-21T23:59:35","","Completed","2021-12-30T23:59:35","No","No","No","Internal"]
[null,null,null,23557,null,"127_13-Jan-22 13:13:03","2021-12-21T23:59:35","Breakdown","Ship Staff","Ship Staff Insp.","DM1 ,DM2 AND DM3 MOTORS SHOWING ZERO INSULATION DUE TO WATER INGRESS DURING HEAVY WEATHER. DAMAGED PLANETARY GEAR FOR DM2.","Deck - Mooring Machinery","Mooring","Equipment Related","","","","","OVERHAULED , CLEANED, VARNISHED AND DRIED MOTORS FOR DM1 AND DM3 ON 30-DEC-2021. RENEWED PLANETARY GEAR FOR DM2 ON 05-JAN-2022 NEW MOTOR FITTED IN PACE AND TESTED FOR DM2 ON 10-JAN-2022.","2022-01-05T23:59:35","","Completed","2022-01-09T23:59:35","No","No","No","Internal"]
[null,null,null,23559,null,"127_13-Jan-22 13:16:31","2021-12-21T23:59:35","Breakdown","Ship Staff","Ship Staff Insp.","FOREPEAK TANK AIR VENT HEAD DAMAGED DURING HEAVY WEATHER.","Deck - Pipe / Fittings","Cargo / Ballast Systems","Behaviour Based","","","","","RO FANT 210216 RAISED FOR NEW VENT HEAD. RENEWED BY SHIP STAFF.","2022-01-04T23:59:35","","Completed","2022-01-01T23:59:35","No","No","No","Internal"]
[null,null,null,23560,null,"127_13-Jan-22 13:20:19","2021-12-21T23:59:35","Breakdown","Ship Staff","Ship Staff Insp.","REMOVABLE RAILINGS ( P&S) FOR FORWARD LIFERAFT EMBARKATION WERE LOST DURING HEAVY WEATHER","Deck - Pipe / Fittings","Structural Condn. / WT integrity ","Equipment Related","","","","","RO FANT210219 RAISED FOR STEEL MATERIAL FOR FABRICATION. NEW RAILING FABRICATED AND FITTED BY SHIP STAFF.","2022-01-04T23:59:35","","Completed","2022-01-01T23:59:35","No","No","No","Internal"]
[null,null,null,23561,null,"127_13-Jan-22 13:23:12","2021-12-21T23:59:35","Breakdown","Ship Staff","Ship Staff Insp.","FORWARD LIFERAFT EMBARKATION LADDER DAMAGED DURING HEAVY WEATHER.","LSA / FFA","Safety / LSA / FFA","Equipment Related","","","","","RO FANT210206 RAISED FOR NEW LADDER. LADDER RECEIVED AND SECURED IN PLACE BY SHIP STAFF.","2022-01-04T23:59:35","","Completed","2022-01-04T23:59:35","No","No","No","Internal"]
[null,null,null,23562,null,"127_13-Jan-22 13:27:26","2021-12-21T23:59:35","Breakdown","Ship Staff","Ship Staff Insp.","PORT FWD NATURAL VENT COVER FOR NO1 HATCH COVER MISSING DURING HEAVY WEATHER","Deck - Pipe / Fittings","Cargo / Ballast Systems","Equipment Related","","","","","EXPOSED VENT WAS TEMPORARILTY SECURED BY SHIP STAFF ON 23-DEC-2021. NEW VENT COVER FABRICATED BY SHORE WORKSHOP AND FITTED IN PLACE BY SHIP STAFF ON 05-JAN-2022.","2022-01-04T23:59:35","","Completed","2022-01-04T23:59:35","No","No","No","Internal"]
[null,null,null,23563,null,"127_13-Jan-22 13:38:40","2021-12-21T23:59:35","Defect","Ship Staff","Ship Staff Insp.","FIRE LINE LEAKING ABREAST NO4 AND NO 6 HATCH COVER PORT SIDE AFTER PANTING AND POUNDING MOVEMENTS OF VESSEL DURING HEAVY WEATHER.","LSA / FFA","Safety / LSA / FFA","Equipment Related","","","","","LEAKS REPAIRED BY SHIP STAFF. OLD DAMAGED / WORN OUT SECTION OF FIRE LINE CROPPED AND RENEWED. ","2021-12-29T23:59:35","","Completed","2021-12-21T23:59:35","No","No","No","Internal"]
[null,null,null,23564,null,"127_13-Jan-22 13:45:14","2021-12-23T23:59:35","Breakdown","Ship Staff","Ship Staff Insp.","BALLAST PUMP NO.2 SIEZED. FOUND IMPELLOR AND CASING RINGS JAMMED. ","E/R - Pumps","Cargo / Ballast Systems","Equipment Related","","","","","REQUESTED FOR SHORE SERVICE. SAME ARRANGED BY OFFCIE AT YANTAI, CHINA. NEW CASING RINGS AND BUSH BEARINGS FABRICATED. SHAFT AND IMPELLOR REPAIRED BY MACHINING AND FITTED BACK. PUMP TESTING WORKING SATISFACTORILY. ","2022-01-23T23:59:35","","Completed","2022-01-05T23:59:35","No","No","No","Internal"]
[null,null,null,23558,null,"127_13-Jan-22 13:03:40","2022-02-22T08:00:00","Defect","Ship Staff","Ship Staff Insp.","FISH ROOM TEV DEFECTIVE. SILICA GEL NEEDS REPLACEMENT","Accommodation","MLC Related","Equipment Related","","","","","RO FANT210195 RAISED /PARTLY RECEIVED. RO FANT220021 RAISED FOR TEV","2022-06-29T08:00:00","","Completed","2022-05-30T08:00:00","No","No","No","Internal","Both RO were supplied on board & vessel rectified the problem.  Please check vessel record & close out the defect accordingly."]
[null,null,null,21254,null,"127_9/28/2021 3:10:49 PM","2022-02-24T08:00:00","Breakdown","Owner / Marine / Tech. Suptd.","Engineering Audit","MOTOR OF FIRE AND BILGE PUMP SHORTED","E/R - Aux. Mach.","Eng. / Strg. Comp.","Equipment Related","","","","","Motor replaced","2022-06-29T08:00:00","","Completed","2022-05-30T08:00:00","No","No","No","Internal","Kindly  mention action taken correctly, \"NOT IN USE\" is no action. Vessel can mention RO no if spares are in order. This job already completed, kindly close out."]
[null,null,null,null,43614,"127_Fri Jun 17 2022 18:43:13 GMT+0800","2022-05-31T08:00:00","Defect","Ship Staff","Ship Staff Insp.","ME LO Sump local gauge non operational","Hull & Tanks","Eng. / Strg. Comp.","Equipment Related","","","","","Completed by replacing the broken wire","2022-07-14T08:00:00","","Completed","2022-06-30T08:00:00","No","No","No","Internal","This job need to completed on priority & report to office."]
[null,null,null,null,46427,"127_Thu Jun 16 2022 21:43:47 GMT+0800","2022-05-31T08:00:00","Critical Equipment","Ship Staff","Ship Staff Insp.","Port Anchor Gear assembly back lash has excessive vibration and noise","Deck - Mooring Machinery","Mooring","Equipment Related","","","","","Anchor lower down 1mtr into water and found satisfactory","2022-07-29T08:00:00","","Completed","2022-06-30T08:00:00","No","No","No","Internal","Port anchor to lower till water level & heave up couple of time at suitable & safe anchorage. Report to office once done."]
[null,null,null,null,43709,"0_Fri Jun 17 2022 19:15:56 GMT+0800","2022-06-13T08:00:00","Observation","Ship Staff","Ship Staff Insp.","Waste Oil tank Overflow line choked","E/R - Pipes/ valves & fittings","Eng. / Strg. Comp.","Equipment Related","","","","","Line opened and cleared. ","2022-06-29T08:00:00","","Completed","2022-06-21T08:00:00","No","No","No","Internal","Please clean the line & complete this job asap & report to office & update DDRL."]
[null,null,null,null,14804,"0_Thu Jun 16 2022 21:55:32 GMT+0800","2022-06-09T08:00:00","Critical Equipment","Ship Staff","Ship Staff Insp.","Fwd. Spring Mooring winch controller is not working.","Deck - Mooring Machinery","Mooring","Equipment Related","","","","","New controller installed and working fine","2022-06-29T08:00:00","FANT220202","Completed","2022-07-07T08:00:00","No","No","No","Internal","New controller is in order, will be connected vessel asap."]
[null,null,null,null,29636,"0_Fri Jun 17 2022 18:47:48 GMT+0800","2022-05-31T08:00:00","Critical Equipment","Ship Staff","Ship Staff Insp.","#2 DG L.O. pressure transmitter, JCW HT display sensors, ","E/R - Aux. Engine","Eng. / Strg. Comp.","Equipment Related","","","","","Rectified by with the new spares supplied","2022-07-14T08:00:00","FANT220189, FANT220173","Completed","2022-06-25T08:00:00","No","No","No","Internal","Spares approved by owner & will be connected"]
[null,null,null,null,88423,"0_Fri Jun 17 2022 18:52:12 GMT+0800","2022-05-31T08:00:00","Breakdown","Ship Staff","Ship Staff Insp.","ME LO Purifier non operational due to breakdown and no spares onboard","E/R - Aux. Mach.","Eng. / Strg. Comp.","Equipment Related","","","","","Tried out and found working normal after adjusting operational parameters","2022-07-14T08:00:00","FANT220162","Completed","2022-07-02T08:00:00","No","No","No","Internal","Owner's arranged spares will be connected in Suez."]

{"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"]
["127","FANTASEA (21-06-2022)","127_1656998016464.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"]