{"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":39,"n_cols":28,"rows_kept":39,"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","16-Nov-2022",null,null,"Ship Name","SUNRISE I (18-04-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,20469,null,"120_8/9/2021 9:50:30 AM","2021-11-08T08:00:00","Observation","Ship Staff","Ship Staff Insp.","letters and numbers on the auto pilot information display sometimes changes and become other number, letter or character","Navigation - Others","General Appearance","Equipment Related","","","","","requested guidance","2022-11-30T08:00:00","","In progress",null,"No","No","No","Internal","Arranged technician to attend vessel at Fujairah. Please close out if rectified."]
[null,null,null,20459,null,"120_7/25/2021 4:54:52 PM","2021-11-20T08:00:00","Defect","Owner / Marine / Tech. Suptd.","Ship Staff Insp.","HOLE IN THE DIFFUSER OF THE BILGE EDUCTOR PUMP","E/R - Pumps","Eng. / Strg. Comp.","Equipment Related","","","","","TEMPORARY COVER THE HOLE WITH PLASTIC STEEL(CORCOBOND)","2022-11-30T08:00:00","SUN1210029","Not Started",null,"No","No","No","Internal","Spare is in order, will be connected at next convenient port."]
[null,null,null,20464,null,"120_7/25/2021 5:41:07 PM","2021-11-29T08:00:00","Defect","Owner / Marine / Tech. Suptd.","Ship Staff Insp.","THE FLOWMETER READING IS NOT ACCURATE","Miscellaneous","Eng. / Strg. Comp.","Equipment Related","","","","","the total flowmeter reading is working but the AE in and out is not functioning, same to be checked","2022-11-30T08:00:00","","In progress",null,"No","No","No","Internal","Vessel to follow up with office on flowmeter issue."]
[null,null,null,24641,null,"120_3/22/2022 9:05:24 PM","2022-03-17T08:00:00","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","all flouroscent light to be replace with LED lights","Miscellaneous","General Appearance","Equipment Related","","","","","replacement of fluorescent lights with LED lights work is in progress. ","2022-12-30T08:00:00","","In progress",null,"No","No","No","Internal"]
[null,null,null,24651,null,"120_3/22/2022 9:58:23 PM","2022-03-17T08:00:00","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","oil leakages from aft seal leakages rectification.","Miscellaneous","Eng. / Strg. Comp.","Equipment Related","","","","","leakages rectification will be carried out with follow up with office. ","2022-12-30T08:00:00","","In progress",null,"No","No","No","Internal"]
[null,null,null,24654,null,"120_3/22/2022 9:39:29 PM","2022-03-25T08:00:00","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","ballast and draft gauges found eratic/ faulty same to check and rectify.","Hull & Tanks","Cargo / Ballast Systems","Equipment Related","","","","","ballast tank no.1 to 5 port stbd both level sensors renewed with new spares, found readings moreover correspond with actual sounding with minor variation. Aft peak tank and Fore peak tank remote level gauge reading need to verify with actual sounding. ","2022-12-30T08:00:00","SUNI220108","In progress",null,"No","No","No","Internal"]
[null,null,null,null,60728,"120_Sat Jul 16 2022 01:26:17 GMT+0800","2022-07-04T08:00:00","Observation","Ship Staff","Ship Staff Insp.","EMBARKATION LADDER ON STBD SIDE LIFEBOAT DECK AND ONE FORWARD EMBARKATION LADDER IN BAD CONDITION.","LSA / FFA","Safety / LSA / FFA","Equipment Related","","","","","TO BE REPLACED WITH NEW ONE. REQUISITION TO BE RAISED FOR SUPPLY AT SINGAPORE","2022-11-30T08:00:00","","Waiting spare",null,"No","No","No","Internal"]
[null,null,null,null,63335,"0_Sat Jul 16 2022 01:30:10 GMT+0800","2022-07-04T08:00:00","Defect","Ship Staff","Ship Staff Insp.","THE BRIDGE FRONT PANEL CLOCK DIMMER NOT WORKING","Miscellaneous","General Appearance","Equipment Related","","","","","REQUISITION FOR THE SPARE HAS BEEN RAISED .","2022-12-30T08:00:00","SUN1220112","Waiting spare",null,"No","No","No","Internal"]
[null,null,null,null,27035,"120_Sat Jul 16 2022 05:30:02 GMT+0800","2022-06-21T08:00:00","Defect","Ship Staff","Ship Staff Insp.","Eductor Remote suction gauge in CCR was showing erratic readings.Found its Pressure transmitter malfunctioning.Steady current of 4.2 mA was measured and no change in readings while calibrating with pressure calibrator.","Cargo Mach.","Cargo / Ballast Systems","Equipment Related","","","","","Requsition raised.","2022-12-30T08:00:00","SUN1220126","Waiting spare",null,"No","No","No","Internal"]
[null,null,null,null,33789,"120_Sat Jul 16 2022 05:51:42 GMT+0800","2022-06-17T08:00:00","Defect","Ship Staff","Ship Staff Insp.","BWTS AFU Outlet pressure transmitter malfunctioning.Steady Current measured.","Cargo Mach.","Cargo / Ballast Systems","Equipment Related","","","","","Requisition raised  the same","2022-12-30T08:00:00","SUN1220126","Waiting spare",null,"No","No","No","Internal"]
[null,null,null,null,61792,"120_Fri Aug 19 2022 14:15:41 GMT+0800","2022-08-16T08:00:00","Defect","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Boiler salinometer defective, showing sensor fail.","E/R - Boiler","Eng. / Strg. Comp.","Equipment Related","","","","","requisition raised for the same.","2022-12-16T08:00:00","SUN1220150","In progress",null,"No","No","No","Internal",""]
[null,null,null,null,14494,"120_Fri Sep 16 2022 12:51:49 GMT+0800","2022-09-16T08:00:00","Defect","Ship Staff","Ship Staff Insp.","Fire and GS pump discharge valve to fire line leaking.\n","E/R - Pipes/ valves & fittings","Eng. / Strg. Comp.","Equipment Related","","","","","Valve to replaced at convenient/earliest opportunity. ","2022-12-16T08:00:00","","Not Started",null,"No","No","No","Internal"]
[null,null,null,null,23734,"120_Tue Sep 27 2022 07:43:12 GMT+0800","2022-09-22T08:00:00","Defect","Ship Staff","Ship Staff Insp.","Air cooler chemical cleaning tank steam coil badly corroded and wasted, has to be renewed.","E/R - Pipes/ valves & fittings","Eng. / Strg. Comp.","Equipment Related","","","","","coil to be repaired/ renewed at the available opportunity","2022-12-27T08:00:00","","Not Started",null,"Yes","No","No","Internal"]
[null,null,null,null,79013,"120_Tue Sep 27 2022 07:47:12 GMT+0800","2022-09-27T08:00:00","Defect","Ship Staff","Ship Staff Insp.","AE in and out flowmeter valves not holding same to be renewed .\n","E/R - Pipes/ valves & fittings","Eng. / Strg. Comp.","Equipment Related","","","","","requisition to be raised for the same.","2022-12-27T08:00:00","","Not Started",null,"No","No","No","Internal"]
[null,null,null,null,23914,"0_Fri Nov 04 2022 03:07:16 GMT+0800","2022-11-01T08:00:00","Defect","Ship Staff","Ship Staff Insp.","Fresh water generator salinometer defective.","E/R - Aux. Mach.","Eng. / Strg. Comp.","Equipment Related","","","","","Fresh water generator Salinometer to be replaced with new spare as soon spares are received.","2023-01-01T08:00:00","SUN1220164","Waiting spare",null,"No","No","No","Internal"]
[null,null,null,null,96254,"0_Fri Nov 04 2022 03:25:01 GMT+0800","2022-11-01T08:00:00","Defect","Ship Staff","Ship Staff Insp.","Incinerator secondary burner blower motor found burnt, same to be replaced with new spare.","E/R - Aux. Engine","Eng. / Strg. Comp.","Equipment Related","","","","","Incinerator secondary burner blower motor to be replaced once new spare recieved.","2023-01-01T08:00:00","SUN1220197","Waiting spare",null,"No","No","No","Internal"]
[null,null,null,null,71632,"120_Tue Nov 15 2022 16:14:16 GMT+0800","2022-11-01T08:00:00","Defect","Ship Staff","Ship Staff Insp.","As informed by makers, both PORT/ST’BD FWD anodes got faulty. So the faulty anodes should be renewed with new ones during ship’s dry dock without fail.","Hull & Tanks","Structural Condn. / WT integrity ","Equipment Related","","","","","Vessel to renew fwd port and stbd anodes for ICCP.","2025-10-01T08:00:00","","Not Started",null,"Yes","No","No","Internal"]
[null,null,null,null,81440,"120_Tue Nov 15 2022 21:29:02 GMT+0800","2022-11-15T08:00:00","Observation","Ship Staff","Ship Staff Insp.","Sewage treatment plant is having a soft patch near the float area/flange in the sterilization tank.","E/R - Aux. Mach.","Eng. / Strg. Comp.","Equipment Related","","","","","Sewage treatment plant sterilization tank to be isolated, a section of the side plate of the tank to be cropped, similar size, thickness plate to be fabricated and welded.","2023-02-15T08:00:00","","Not Started",null,"No","No","No","Internal"]
[null,null,null,null,24591,"0_Tue Nov 15 2022 21:31:32 GMT+0800","2022-11-15T08:00:00","Defect","Ship Staff","Ship Staff Insp.","Fresh water generator high salinity solenoid valve to be replaced with new valve.","E/R - Aux. Mach.","Eng. / Strg. Comp.","Equipment Related","","","","","New solenoid valve to be procured, in the event of high ppm the solenoid valve operates and lead the water back into the shell.","2023-02-15T08:00:00","","Not Started",null,"No","No","No","Internal"]
[null,null,null,null,79095,"120_Tue Nov 15 2022 21:53:32 GMT+0800","2022-11-15T08:00:00","Defect","Ship Staff","Ship Staff Insp.","Fresh water generator ejector pump discharge pipe is holed, need to fabricate new pipe section.","E/R - Aux. Mach.","Eng. / Strg. Comp.","Equipment Related","","","","","Ejector pump discharge pipe is holed, cold work temporary repair is carried out, pipe to be dismantled from location and fabricated new or repair the existing one.","2022-12-15T08:00:00","","Not Started",null,"No","No","No","Internal"]
[null,null,null,null,33093,"0_Tue Nov 15 2022 21:55:22 GMT+0800","2022-11-15T08:00:00","Defect","Ship Staff","Ship Staff Insp.","Sewage treatment plant vacuum pump no.2 is leaking, need to investigate the leak and rectify.","E/R - Aux. Mach.","Eng. / Strg. Comp.","Equipment Related","","","","","Pump to be overhauled , mech seal to be replaced with new spare.","2022-12-15T08:00:00","","Not Started",null,"No","No","No","Internal"]
[null,null,null,null,94153,"0_Tue Nov 15 2022 21:58:16 GMT+0800","2022-11-15T08:00:00","Observation","Ship Staff","Ship Staff Insp.","Bonding cable for pipe trunk laid up on deck is found missing at some location, the securing points for the cable is rusted or sheared off.","Deck - Pipe / Fittings","Structural Condn. / WT integrity ","External Factors","","","","","securing point to be refurbished and new bonding cable to be used.","2022-12-15T08:00:00","","In progress",null,"No","No","No","Internal"]

{"sheet":"Completed","index":1,"n_rows":79,"n_cols":28,"rows_kept":79,"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","16-Nov-2022",null,null,"Ship Name","SUNRISE I (18-04-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,21794,null,"120_10/23/2021 10:36:10 AM","2021-06-10T23:59:35","Observation","Ship Staff","Ship Staff Insp.","Auxilliary Engine turbocharger rpm not indicating on monitor display.","E/R - Aux. Engine","Eng. / Strg. Comp.","Equipment Related","","","","","Speed sensor replaced.","2021-07-11T23:59:35","","Completed","2021-10-27T23:59:35","No","No","No","Internal"]
[null,null,null,20465,null,"120_7/25/2021 5:45:38 PM","2021-07-07T23:59:35","Defect","Owner / Marine / Tech. Suptd.","Ship Staff Insp.","THE F.O. FILTER AUTO BACKWASH IS STUCK UP","Elect. Mach. & Equip.","Eng. / Strg. Comp.","Equipment Related","","","","","REPAIRED BY ELECTRICIAN","2021-09-20T23:59:35","NO REQ. YET","Completed","2021-05-09T23:59:35","No","No","No","Internal"]
[null,null,null,21080,null,"120_8/27/2021 12:28:29 PM","2021-07-13T23:59:35","Critical Equipment","Owner / Marine / Tech. Suptd.","Engineering Audit","G/E#3 Cylinder cover #3&4 leaking","E/R - Aux. Engine","Eng. / Strg. Comp.","Equipment Related","","","","","RE-TIGHTENED BY HYDRAULIC JACK","2021-08-31T23:59:35","FANT210008 D/G SPARES","Completed","2021-08-16T23:59:35","No","No","No","Internal"]
[null,null,null,21081,null,"120_8/27/2021 2:55:40 PM","2021-07-16T23:59:35","Breakdown","Owner / Marine / Tech. Suptd.","Engineering Audit","M/E RPM indicator defective","Critical Equip.","Eng. / Strg. Comp.","Equipment Related","","","","","REPPAIRED BY ELECTRICIAN","2021-08-31T23:59:35","","Completed","2021-08-23T23:59:35","No","No","No","Internal"]
[null,null,null,21082,null,"120_8/27/2021 3:01:12 PM","2021-07-19T23:59:35","Defect","Owner / Marine / Tech. Suptd.","Engineering Audit","Galley griller low insulation","Elect. Mach. & Equip.","Safety / LSA / FFA","Equipment Related","","","","","REPAIRED BY ELECTRICIAN","2021-08-31T23:59:35","","Completed","2021-12-08T23:59:35","No","No","No","Internal"]
[null,null,null,20466,null,"120_7/25/2021 11:00:13 PM","2021-07-25T23:59:35","Defect","Ship Staff","Ship Staff Insp.","FIRE FIGHTING UHF RADIOS NOT WORKING/ DEFECTIVE","LSA / FFA","Safety / LSA / FFA","Equipment Related","","","","","RECEIVED NEW FIRE FIGHTING UHF RADIOS AND REPLACED DEFECTIVE RADIOS","2021-04-09T23:59:35","SUN1210046","Completed","2021-04-09T23:59:35","No","No","No","Internal","UHF radios are in order & will be connected at next convenient port."]
[null,null,null,21077,null,"120_17-08-21 10:36:23 AM","2021-07-28T23:59:35","Defect","Ship Staff","Ship Staff Insp.","Gas sampling point CH no.7 p+s & CH no.6 p/s not properly closing due to rust & deterioration.","Deck - Pipe / Fittings","General Appearance","External Factors","","","","","repaired ","2021-08-12T23:59:35","","Completed","2021-08-12T23:59:35","No","No","No","Internal"]
[null,null,null,20468,null,"120_8/2/2021 1:18:42 PM","2021-07-30T23:59:35","Defect","Ship Staff","Ship Staff Insp.","damaged pilot ladder drum reel bearing housing and chain coupling","Deck - Machinery","General Appearance","External Factors","","","","","Repaired pilot ladder drum reel bearing housing and chain coupling after received spares. tested and working in normal condition","2021-08-29T23:59:35","SUN1210049","Completed","2021-08-29T23:59:35","No","No","No","Internal","Spares are in order, will be connected vessel at convenient port."]
[null,null,null,21795,null,"120_22/10/2021 18:37:42","2021-09-10T23:59:35","Observation","Ship Staff","Ship Staff Insp.","Main cooling sea water pump #2 overload trip","E/R - Aux. Mach.","Eng. / Strg. Comp.","Equipment Related","","","","","Replaced motor bearing ,found working satisfactorily.","2021-10-11T23:59:35","","Completed","2021-10-22T23:59:35","No","No","No","Internal"]
[null,null,null,21790,null,"120_22/10/2021 19:20:43","2021-09-18T23:59:35","Defect","Ship Staff","Ship Staff Insp.","Fish room in Galley found unable to maintain -16° temperature","Accommodation","MLC Related","Equipment Related","","","","","Need to be checked by ETO & repair if necessary.","2021-10-30T23:59:35","","Completed","2021-10-08T23:59:35","No","No","No","Internal"]
[null,null,null,21788,null,"120_10/25/2021 8:50:05 AM","2021-09-23T23:59:35","Defect","Ship Staff","Ship Staff Insp.","Fire & GS pump not operational","E/R - Pumps","Eng. / Strg. Comp.","Equipment Related","","","","","Motor bearing renewed.tried out pump found working satisfctorily.","2021-11-23T23:59:35","","Completed","2021-10-27T23:59:35","No","No","No","Internal"]
[null,null,null,21792,null,"120_24/10/2021 10:56:05","2021-09-25T23:59:35","Non Conformity","Ship Staff","Ship Staff Insp.","Port side Pilot Ladder, bottom two steps found deformed, embarkation ladder for liferaft found in poor shape. ","LSA / FFA","Safety / LSA / FFA","Knowledge Based","","","","","PO raised, awaiting berthing of vessel.","2021-11-15T23:59:35","SUN1210108 - PILOT AND EMBARKATION LADDER","Completed","2021-10-27T23:59:35","No","No","No","Internal"]
[null,null,null,21793,null,"120_24/10/2021 12:08:42","2021-09-25T23:59:35","Defect","Ship Staff","Ship Staff Insp.","VRCS accumulator found empty, due to which hydraulic pump for VRCS was running contniously","Cargo Mach.","Cargo / Ballast Systems","Equipment Related","","","","","Check availability of nitrogen and top up accummulators on main deck.","2021-10-09T23:59:35","","Completed","2021-10-05T23:59:35","No","No","No","Internal"]
[null,null,null,21796,null,"120_10/25/2021 8:59:10 AM","2021-10-11T23:59:35","Observation","Ship Staff","Ship Staff Insp.","Start motor not available for aux. engine","E/R - Aux. Engine","Eng. / Strg. Comp.","Equipment Related","","","","","Start air motor recieved and installed.","2022-09-02T23:59:35","","Completed","2022-03-19T23:59:35","No","No","No","Internal"]
[null,null,null,21797,null,"120_24/10/2021 12:12:41","2021-10-11T23:59:35","Non Conformity","Ship Staff","Ship Staff Insp.","Forcastle water tight door and cargo hold booby hatch cover's found not closing / opening properly.","Hull & Tanks","Structural Condn. / WT integrity ","External Factors","","","","","Derusting/ Renewal of gasket and greasing of all nipples to be carried out.","2021-11-30T23:59:35","","Completed","2021-11-03T23:59:35","No","No","No","Internal","Please try to get this job completed at this anchorage."]
[null,null,null,21799,null,"120_10/22/2021 10:37:55 PM","2021-10-22T23:59:35","Critical Equipment","Ship Staff","Nav Audit / Verification","Ship's whistle air line on Monkey Island leaking air.","Navigation - Others","Navigation","External Factors","","","","","Need to replace new air pipe","2021-11-11T23:59:35","","Completed","2021-10-26T23:59:35","No","No","No","Internal"]
[null,null,null,21800,null,"120_22/10/2021 18:48:37","2021-10-22T23:59:35","Observation","Ship Staff","Ship Staff Insp.","Air line on midship found holed, due to corrosion","Deck - Pipe / Fittings","Structural Condn. / WT integrity ","External Factors","","","","","Need renewal of air line flange to flange.","2021-11-22T23:59:35","","Completed","2021-10-25T23:59:35","No","No","No","Internal"]
[null,null,null,21801,null,"120_22/10/2021 19:16:34","2021-10-22T23:59:35","Observation","Ship Staff","Ship Staff Insp.","Steering compartment boiler platform door found to be lashed with wire in open condition","Miscellaneous","Crew Management","Behaviour Based","","","","","Need to check all doors in Engine room and remove all temporary arrangement made to keep door open all times.","2021-10-25T23:59:35","","Completed","2021-10-24T23:59:35","No","No","No","Internal"]
[null,null,null,21804,null,"120_10/25/2021 8:55:06 AM","2021-11-16T23:59:35","Defect","Ship Staff","Ship Staff Insp.","MEFO Auto back was filter is not working","E/R - Aux. Mach.","Eng. / Strg. Comp.","Equipment Related","","","","","Limit switch replaced , found working satisfactory.","2022-02-15T23:59:35","","Completed","2021-12-31T23:59:35","No","No","No","Internal"]
[null,null,null,20467,null,"120_7/25/2021 5:19:21 PM","2021-11-18T23:59:35","Defect","Ship Staff","Ship Staff Insp.","HIGH TEMP. ALARM ON THE CONTROL AIR DRIER","Elect. Mach. & Equip.","Eng. / Strg. Comp.","Equipment Related","","","","","PRESENTLY NO ALARM","2022-02-17T23:59:35","NO REQ. YET","Completed","2022-03-19T23:59:35","No","No","No","Internal"]
[null,null,null,20463,null,"120_7/25/2021 5:27:08 PM","2021-11-28T23:59:35","Defect","Ship Staff","Ship Staff Insp.","MOTOR AND FAN OVERLOAD ALARM OF DECK AIR COMPRESSOR","Elect. Mach. & Equip.","Eng. / Strg. Comp.","Equipment Related","","","","","Maker attendedance,checked PLC controller, modify phase sequence relay K25 and made compresor operational","2022-02-27T23:59:35","SPARE RECIEVED ON BOARD","Completed","2021-12-30T23:59:35","No","No","No","Internal"]
[null,null,null,23576,null,"120_15/11/2021 11:10:13","2021-11-30T23:59:35","Defect","Ship Staff","Ship Staff Insp.","Found water ingress in # 4 Lower Stool and Lower Stool suction valve un-operational.","Deck - Pipe / Fittings","Structural Condn. / WT integrity ","Equipment Related,External Factors","","","","","All valves over hauled and DB tanks manholes power tooled and painted. Further verified and found no more ingress of water in any stool space.","2022-08-02T23:59:35","","Completed","2022-02-15T23:59:35","No","No","No","Internal"]
[null,null,null,21803,null,"120_10/25/2021 8:38:58 AM","2021-12-11T23:59:35","Defect","Ship Staff","Ship Staff Insp.","Deck compressor not operational, to be investigated","E/R - Air Comp.","Eng. / Strg. Comp.","Equipment Related","","","","","Maker attended,checked PLC controller, modify phase sequence relay K25 and made compressor operational.","2022-09-02T23:59:35","","Completed","2021-12-30T23:59:35","No","No","No","Internal"]
[null,null,null,24642,null,"120_3/22/2022 9:13:05 PM","2022-03-17T23:59:35","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","engine room save all trays to clean paint after leakages rectification.","Miscellaneous","General Appearance","Equipment Related","","","","","engine room save all trays cleaned painted after leakages rectification. ","2022-04-22T23:59:35","","Completed","2022-04-15T23:59:35","No","No","No","Internal"]
[null,null,null,24646,null,"120_3/22/2022 9:30:05 PM","2022-03-17T23:59:35","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","ballast valve BA 102 not holding, seat ring to renew","Cargo Mach.","Cargo / Ballast Systems","Equipment Related","","","","","BA 102 ballast valve seat ring found in good condition, assembled back the same.and changed complete valve with seat ring for BA 101","2022-06-16T23:59:35","","Completed","2022-06-04T23:59:35","No","No","No","Internal"]
[null,null,null,24647,null,"120_3/22/2022 9:33:46 PM","2022-03-17T23:59:35","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","permanent repair by welding insert to be carried out for ballast line ( inlet to ballast pump no.1 ) with temporary repair","E/R - Pipes/ valves & fittings","Structural Condn. / WT integrity ","Equipment Related","","","","","Permanent repair made with welding insert.","2022-06-16T23:59:35","","Completed","2022-09-04T23:59:35","No","No","No","Internal"]
[null,null,null,24652,null,"120_3/22/2022 10:01:13 PM","2022-03-17T23:59:35","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","various pumps leakages in purifier room to be rectified. ","E/R - Pumps","Eng. / Strg. Comp.","Equipment Related","","","","","identification of leakges  carried out and rectified the same.","2022-04-30T23:59:35","","Completed","2022-04-14T23:59:35","No","No","No","Internal"]
[null,null,null,24657,null,"120_3/22/2022 8:38:53 PM","2022-03-17T23:59:35","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","no.2 lub oil purifier op board faulty","E/R - Purifier","Eng. / Strg. Comp.","Equipment Related","","","",""," Faulty op board changed with new one.","2022-04-04T23:59:35","","Completed","2022-03-23T23:59:35","No","No","No","Internal"]
[null,null,null,24658,null,"120_3/22/2022 9:01:07 PM","2022-03-17T23:59:35","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","forward ICCP faulty","Hull & Tanks","Structural Condn. / WT integrity ","Equipment Related","","","","","cofferdam cleanedand made dry, renewed cable found working satisfactorily.","2022-06-16T23:59:35","","Completed","2022-03-19T23:59:35","No","No","No","Internal"]
[null,null,null,24659,null,"120_3/22/2022 9:36:16 PM","2022-03-17T23:59:35","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","hfo service/settling tank cleaning to be carried out. ","Miscellaneous","Eng. / Strg. Comp.","Equipment Related","","","","","hfo service and settling tank cleaning completed.","2022-04-04T23:59:35","","Completed","2022-03-25T23:59:35","No","No","No","Internal"]
[null,null,null,24660,null,"120_3/22/2022 9:22:53 PM","2022-03-17T23:59:35","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","LT cooler various valves gaskets leakages to be rectified.","Miscellaneous","Eng. / Strg. Comp.","Equipment Related","","","","","Leakages was taking place from sacrificial flanges, same renewed and rectified leak.","2022-03-24T23:59:35","","Completed","2022-03-26T23:59:35","No","No","No","Internal"]
[null,null,null,24661,null,"120_3/22/2022 8:28:03 PM","2022-03-17T23:59:35","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","sewage treatment plant low level alarm malfuctioning due to which pump keeps running continuously and do not stop.","Miscellaneous","MARPOL Related","Equipment Related","","","","","High level switch renewed,low level swich rectified,Circuit modification removed. ","2022-04-04T23:59:35","","Completed","2022-03-19T23:59:35","No","No","No","Internal"]
[null,null,null,24662,null,"120_22/03/2022 12:00:38","2022-03-17T23:59:35","Observation","Owner / Marine / Tech. Suptd.","Engineering Audit","Alarm monitoring system repater panel on bridge all LED lights are lit up","Elect. Mach. & Equip.,Navigation - Others","Communication","Equipment Related","","","","","Pressed S3 button on panel, issue resolved","2022-04-17T23:59:35","","Completed","2022-03-19T23:59:35","No","No","No","Internal"]
[null,null,null,24663,null,"120_3/22/2022 9:42:24 PM","2022-03-17T23:59:35","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","oil traces observed on main engine cylinder head.","E/R - Main Engine","Eng. / Strg. Comp.","Equipment Related","","","","","OIl leakage  source located and rectified.","2022-04-16T23:59:35","","Completed","2022-03-31T23:59:35","No","No","No","Internal"]
[null,null,null,24664,null,"120_3/22/2022 8:47:19 PM","2022-03-17T23:59:35","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","no.3 DG jacket cooling f.w. temp. sensor faulty","E/R - Aux. Engine","Eng. / Strg. Comp.","Equipment Related","","","",""," Sensor changed ,working satisfactorily.","2022-04-16T23:59:35","","Completed","2022-03-25T23:59:35","No","No","No","Internal"]
[null,null,null,24645,null,"120_3/22/2022 9:26:11 PM","2022-03-17T08:00:00","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","boiler sampling cock and various valves found wrapped with tape to stop leakges from gasket","E/R - Boiler","Eng. / Strg. Comp.","Equipment Related","","","","","identification and rectification of leakages is done. ","2022-04-30T08:00:00","","Completed","2022-04-26T08:00:00","No","No","No","Internal"]
[null,null,null,24649,null,"120_3/22/2022 9:48:23 PM","2022-03-17T08:00:00","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","several leakages observed on all 3 auxiliary engines, leakaes to be rectify.","E/R - Aux. Engine","Eng. / Strg. Comp.","Equipment Related","","","","","identified and leakage rectification is done .","2022-04-30T08:00:00","","Completed","2022-04-26T08:00:00","No","No","No","Internal"]
[null,null,null,24648,null,"120_3/22/2022 9:45:18 PM","2022-03-17T08:00:00","Observation","Others (Eg. Insurance etc.)","Suptd. Insp.","several gauges broken, same to rectify","Miscellaneous","Eng. / Strg. Comp.","Equipment Related","","","","","identify faulty gauges and replaced with new one.","2022-05-31T08:00:00","","Completed","2022-05-25T08:00:00","No","No","No","Internal"]
[null,null,null,21802,null,"120_22/10/2021 19:26:19","2021-11-22T08:00:00","Observation","Ship Staff","Ship Staff Insp.","MSMP manual found equipment code is wrong, due to which MBL & BHC calculated is wrong. Need to correct on Manual and mooring winches.","Deck - Mooring Machinery","Mooring","Knowledge Based","","","","","MSMP  manual updated with correct equipment code  and  all mooring winches corrected for BHC.","2022-02-21T08:00:00","","Completed","2022-04-06T08:00:00","No","No","No","Internal","Please check & correct asap."]
[null,null,null,24653,null,"120_3/22/2022 8:33:43 PM","2022-03-21T08:00:00","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","manouvering platform auto and sound powered telephone out of operation","Elect. Mach. & Equip.","Eng. / Strg. Comp.","Equipment Related","","","","","Auto telephone rectified, new sound  power telephone install","2022-04-30T08:00:00","","Completed","2022-04-30T08:00:00","No","No","No","Internal"]
[null,null,null,24656,null,"120_3/22/2022 9:50:56 PM","2022-03-17T08:00:00","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","all 3 generators insulation cladding is damaged, same to rectify. ","E/R - Aux. Engine","Eng. / Strg. Comp.","Equipment Related","","","","","insulation cladding replaced for all generators","2022-04-30T08:00:00","","Completed","2022-04-30T08:00:00","No","No","No","Internal"]
[null,null,null,24650,null,"120_3/22/2022 9:54:45 PM","2022-03-17T08:00:00","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","engine room tank top and bilge well found oil traces, same to clean and paint","Miscellaneous","Eng. / Strg. Comp.","Equipment Related","","","","","Engine room tank top cleaned and painted. ","2022-04-30T08:00:00","","Completed","2022-04-30T08:00:00","No","No","No","Internal"]
[null,null,null,20462,null,"120_7/25/2021 5:14:16 PM","2021-11-30T08:00:00","Defect","Owner / Marine / Tech. Suptd.","Ship Staff Insp.","DEFECTIVE CPU OF THE NO. 2  AMS IN ECR","Elect. Mach. & Equip.","Eng. / Strg. Comp.","Equipment Related","","","","","WORKIG SATISFACTORILY.","2022-02-28T08:00:00","SUN1210045","Completed","2022-06-06T08:00:00","No","No","No","Internal","New one will be connected at next convenient port."]
[null,null,null,21798,null,"120_22/10/2021 15:03:27","2021-11-22T08:00:00","Observation","Ship Staff","Ship Staff Insp.","Pressure gauges in Engine room machinary found opaque, unable to read through them.","E/R - Pipes/ valves & fittings","Eng. / Strg. Comp.","Industry Issue","","","","","Identified and renewed pressure gauges as required.","2022-05-30T08:00:00","","Completed","2022-05-25T08:00:00","No","No","No","Internal","Waiting for RO to arrange supply."]
[null,null,null,20461,null,"120_7/25/2021 5:35:09 PM","2021-11-20T08:00:00","Defect","Ship Staff","Ship Staff Insp.","DEIFECTIVE PLC AND SOLENOID VALVE OF THE PACK AIRCON IN ECR.","Elect. Mach. & Equip.","Eng. / Strg. Comp.","Equipment Related","","","","","CIRCUIT HAS BEEN CHANGED FOUND OPERATIONAL.","2022-02-20T08:00:00","NO REQ. YET","Completed","2022-01-26T08:00:00","No","No","No","Internal","Vessel to follow up with Auto Electrical support for trouble shooting & thereafter to raise raise RO if require any."]
[null,null,null,24640,null,"120_3/22/2022 8:55:42 PM","2022-03-17T08:00:00","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","incinerator primary burner firing erratically","Critical Equip.","Eng. / Strg. Comp.","Equipment Related","","","",""," Job double up .Troubleshooting  is in progress. ","2022-06-30T08:00:00","","Completed","2022-06-10T08:00:00","No","No","No","Internal"]
[null,null,null,null,15452,"0_Sat Jul 16 2022 01:35:24 GMT+0800","2022-07-04T08:00:00","Observation","Ship Staff","Ship Staff Insp.","NO 1 HATCH COVER CHAIN IN BAD CONDITION.","Miscellaneous","Cargo / Ballast Systems","Equipment Related","","","","","THE CHAIN TO BE CHIPPED AND MEASURE THE THICKNESS. IF THIN DOWN MORE THAN THE RECOMMENDED LIMIT, WILL BE REPLACING WITH NEW SPARE CHAIN ONBOARD.","2022-07-30T08:00:00","","Completed","2022-08-09T08:00:00","No","No","No","Internal"]
[null,null,null,24644,null,"120_3/22/2022 9:18:28 PM","2022-03-17T08:00:00","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","fresh water generator out of service","Elect. Mach. & Equip.","Eng. / Strg. Comp.","Equipment Related","","","","","Fresh water generator put into service ,all parameters checked found satisfactory","2022-08-31T08:00:00","","Completed","2022-07-10T08:00:00","No","No","No","Internal"]
[null,null,null,24655,null,"120_3/22/2022 9:09:46 PM","2022-03-25T08:00:00","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","boiler damaged fuel oil hose with heater element to replace.","E/R - Boiler","Eng. / Strg. Comp.","Equipment Related","","","","","Hose changed after receiving spares in Singapore.\nboiler tried out on Lsmgo ","2022-08-31T08:00:00","SUN 1220074","Completed","2022-08-19T08:00:00","No","No","No","Internal"]
[null,null,null,21789,null,"120_10/25/2021 9:23:56 AM","2021-11-19T08:00:00","Critical Equipment","Ship Staff","Ship Staff Insp.","Incinerator Opeartion firing in LSMGO but after 25 min after activation of secondary burner , the secondary chamber no reaching to the  temperature of 650deg","Critical Equip.","MARPOL Related","Equipment Related","","","","","Burner nozzle changed and electrodes changed., after receiving spares in Singapore. tried out ,now temperature reaching above 650 deg . in secondary chamber.\n","2022-08-31T08:00:00","","Completed","2022-08-18T08:00:00","No","No","No","Internal","Follow up with maker & vessel being done, incinerator made operation but at full capacity. Further checks & follow up being done."]
[null,null,null,24643,null,"120_3/22/2022 9:15:53 PM","2022-03-17T08:00:00","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","faulty level gauge of fresh water tank.","Hull & Tanks","Eng. / Strg. Comp.","Equipment Related","","","","","level Gauge renewed with spare one received in Singapore","2022-08-31T08:00:00","SUN 1220048","Completed","2022-08-22T08:00:00","No","No","No","Internal"]
[null,null,null,null,87657,"0_Sat Jul 16 2022 01:27:55 GMT+0800","2022-07-04T08:00:00","Observation","Ship Staff","Ship Staff Insp.","ONE OF THE FIREMAN OUTFIT'S PANT WAS FOUND IN BAD / TORN CONDITION.","LSA / FFA","Safety / LSA / FFA","Equipment Related","","","","","TO BE REPLACED WITH NEW ONE. REQUISITION FOR THE SAME TO BE RAISED FOR SUPPLY AT SINGAPORE","2022-08-16T08:00:00","","Completed","2022-08-16T08:00:00","No","No","No","Internal"]
[null,null,null,null,49907,"120_Sat Jul 16 2022 04:57:08 GMT+0800","2022-06-18T08:00:00","Observation,Defect","Ship Staff","Ship Staff Insp.","No.2 Main Air Reservoir pressure transmitter defective.\nSensfail alarm.","E/R - Air Comp.","Eng. / Strg. Comp.","Equipment Related","","","","","TRANSMITTER REPLACED WITH SPARE ONE","2022-08-31T08:00:00","SUN1220099","Completed","2022-08-24T08:00:00","No","No","No","Internal"]
[null,null,null,null,63597,"120_Sat Jul 16 2022 05:47:45 GMT+0800","2022-06-15T08:00:00","Defect","Ship Staff","Ship Staff Insp.","Hydroblaster Timer(on delay) malfunctioning. Not making contacts.","Deck - Machinery","Structural Condn. / WT integrity ","Equipment Related","","","","","vessel received spare hydroblaster in Singapore ","2022-08-31T08:00:00","SUN1220126","Completed","2022-08-20T08:00:00","No","No","No","Internal"]
[null,null,null,21791,null,"120_10/25/2021 9:07:14 AM","2021-11-23T08:00:00","Observation","Ship Staff","Ship Staff Insp.","No sludge evaporation from incinerator waste oil service tank.","Hull & Tanks","MARPOL Related","Equipment Related","","","","","tank already cleaned , steam trap and coil  checked , evaporation rate has improved ","2022-10-31T08:00:00","","Completed","2022-09-01T08:00:00","No","No","No","Internal","Waste oil tank heating coil & tank to clean, return line steam trap to check / overhaul as necessary."]
[null,null,null,null,48649,"120_Tue Sep 27 2022 07:57:32 GMT+0800","2022-09-17T08:00:00","Observation","Ship Staff","Ship Staff Insp.","OWS 15 ppm alarm display damaged., cannot see display ppm value properly.","E/R - Aux. Mach.","Eng. / Strg. Comp.","Equipment Related","","","","","Spare received  CPU card changed, OWS tried out.","2022-12-17T08:00:00","RO no: SUN1220148","Completed","2022-10-07T08:00:00","No","No","No","Internal"]
[null,null,null,null,99507,"120_Fri Sep 16 2022 12:45:22 GMT+0800","2022-09-16T08:00:00","Observation,Defect","Ship Staff","Ship Staff Insp."," Main Fire pump overboard valve leaking from gland.\n","E/R - Pipes/ valves & fittings","Eng. / Strg. Comp.","Equipment Related","","","","","Gland nuts eased up and gland tightened, leak stopped.","2022-12-16T08:00:00","","Completed","2022-10-27T08:00:00","No","No","No","Internal"]
[null,null,null,null,79809,"120_Fri Nov 04 2022 22:56:51 GMT+0800","2022-11-02T08:00:00","Defect","Ship Staff","Ship Staff Insp.","Pneumatic emergency DO pump not working .","E/R - Aux. Mach.","Eng. / Strg. Comp.","Equipment Related","","","","","Pump opened up ,eased up lubricated and turned by hand, .\nput back and tried out on air, now working properly.","2023-02-04T08:00:00","","Completed","2022-11-02T08:00:00","No","No","No","Internal"]
[null,null,null,null,97919,"120_Fri Nov 04 2022 03:01:58 GMT+0800","2022-11-01T08:00:00","Critical Equipment","Ship Staff","Ship Staff Insp.","RESCUE BOAT davit accumulators inefficient, suspect bladder leak, nitrogen gas leak. needs replacement or overhaul.","LSA / FFA","Safety / LSA / FFA","Equipment Related","","","","","Accumulators replaced and charged with Nitrogen, davit tried out on reserve power. ","2022-12-01T08:00:00","","Completed","2022-11-07T08:00:00","No","No","No","Internal"]
[null,null,null,null,50604,"0_Sat Jul 16 2022 01:32:17 GMT+0800","2022-07-04T08:00:00","Critical Equipment","Ship Staff","Ship Staff Insp.","THE LCD AND CCU FAN RUNNING HOURS FOR BOTH ECDIS SHOWING OVERDUE FOR REPLACEMENT.","Navigation - ECDIS","Navigation","Equipment Related","","","","","ECDIS SERVICING CARRIED OUT AND LCD AND CCU FANS CHANGED BY SHORE TECNICIANS AT SINGAPORE.","2022-10-31T08:00:00","SUN1220147","Completed","2022-10-07T08:00:00","No","No","No","Internal"]
[null,null,null,null,75455,"0_Fri Nov 04 2022 03:09:15 GMT+0800","2022-11-01T08:00:00","Defect","Ship Staff","Ship Staff Insp.","Main cooling sea water pump no.2 mech seal leaking","E/R - Pumps","Eng. / Strg. Comp.","Equipment Related","","","","","Main cooling sea water pump  overhauled, mech seal renewed.","2022-11-15T08:00:00","","Completed","2022-11-12T08:00:00","No","No","No","Internal"]
[null,null,null,null,78297,"120_Sat Jul 16 2022 04:48:24 GMT+0800","2022-06-15T08:00:00","Defect","Ship Staff","Ship Staff Insp.","ECR alarm printer malfunctioning. Alarm activating frequently.","Elect. Mach. & Equip.","Cert. & Docu.","Equipment Related","","","","","ALARM PRINTER DATA CABLE CHANGED AND RESTARTED .","2022-12-30T08:00:00","","Completed","2022-11-10T08:00:00","No","No","No","Internal"]

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

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

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

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

{"sheet":"VIQrefno","index":6,"n_rows":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"]
["120","SUNRISE I (18-04-2022)","120_1650855410888.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"]