{"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":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","01-Aug-2022",null,null,"Ship Name","DHT SUNDARBANS (23-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,24353,null,"55_6/3/2022 1:50:14 pm","2022-02-27T08:00:00","Defect","Ship Staff","Ship Staff Insp.","FCV 1211 is not operating by remotely. Drive motor for the same was burnt.Currently FCV 1211 is operated manually.","Deck - Pipe / Fittings","Cargo / Ballast Systems","Equipment Related","6.21","High","","","FC1211V drive motor ordered awaiting spares","2022-05-27T08:00:00","SSUN220035","Waiting spare",null,"No","No","No","Internal","Raise requisition for drive motor ASAP."]
[null,null,null,24454,null,"55_20/3/2022 2:53:05 pm","2022-03-01T23:59:35","Defect","Ship Staff","Ship Staff Insp.","Reported Garbage Compactor not opertional","Deck - Machinery","General Appearance","Equipment Related","6.2","High","","","Starting Interlock door switch was not operating, hence switch was bypassed and made garbage compactor operational, ordered required spares.","2022-06-01T23:59:35","SSUN220040","Waiting spare",null,"No","No","No","Internal"]
[null,null,null,24456,null,"55_20/3/2022 4:17:31 pm","2022-03-05T08:00:00","Defect","Ship Staff","Ship Staff Insp.","Back-up UPS for S-Band RADAR and Fire Fighting CO2 system was operational\t\t\t","LSA / FFA,Navigation - RADAR","Navigation","Equipment Related","","","","","Both UPS was bypassed to make the system online, S band radar spares received and installed. Awaiting spare for Co2 ups.","2022-07-05T08:00:00","SSUN220036","Waiting spare",null,"No","No","No","Internal"]
[null,null,null,24840,null,"55_31/3/2022 11:11:35 am","2022-03-30T08:00:00","Critical Equipment,Defect","Ship Staff","Ship Staff Insp.","Navigational light control panel though all lights were of “ON” indication without alarms in the panel.but, actually in real scenario no navigational lights present in mast head in monkey island,fwd mast, side light and stern lights.","Navigation - Others","Navigation","Equipment Related","4.8","Medium","","","As per latest information from maker we need to replace unit.","2022-07-07T08:00:00","","Waiting spare",null,"No","No","No","Internal"]
[null,null,null,null,61845,"55_Tue May 31 2022 08:24:42 GMT+0800","2022-05-23T08:00:00","Defect","Ship Staff","Ship Staff Insp.","#1 FWG EJECTOR NOZZLE WORN, SHELL TEMP HIGH DUE TO LESS VACUUM","E/R - Aux. Mach.","Eng. / Strg. Comp.","Equipment Related","10.32","Very High","","","PO RAISED","2022-08-23T08:00:00","SSUN220096","Waiting spare",null,"No","No","No","Internal"]
[null,null,null,null,61687,"55_Wed Jun 15 2022 02:20:34 GMT+0800","2022-06-02T08:00:00","Defect","Ship Staff","Ship Staff Insp.","M/E Tachometer no 1 and no 2 showing eratic reading when engine stopped.","E/R - Main Engine","Eng. / Strg. Comp.","Equipment Related","10.32","Very High","","","Spares ordered.","2022-09-02T08:00:00","SSUN220058","Waiting spare",null,"No","No","No","Internal"]
[null,null,null,null,92117,"55_Wed Jun 15 2022 02:29:09 GMT+0800","2022-06-10T08:00:00","Observation","Ship Staff","Ship Staff Insp.","WIO sensor installed along with BWMS is decommissioned. Need to install new type WIO sensor.","E/R - Main Engine","Eng. / Strg. Comp.","Equipment Related","10.32","Very High","","","Office to follow up to supply new type Water in oil sensor. once received same to be installed and an mimic in aconis to be created with aconis engineer.","2022-09-10T08:00:00","","Not Started",null,"No","No","No","Internal"]
[null,null,null,null,29484,"55_Wed Jun 15 2022 02:36:41 GMT+0800","2022-06-10T08:00:00","Defect","Ship Staff","Ship Staff Insp.","CLO pump worn off alarm is appearing while running ICO lube.","E/R - Main Engine","Eng. / Strg. Comp.","Equipment Related","10.32","Very High","","","CHECKS CARRIED OUT AS PER MAKERS RECOMMENDATION. \nCLO WORN OUT ALARM STILL PRESENT.","2022-09-10T08:00:00","","In progress",null,"No","No","No","Internal"]
[null,null,null,null,47889,"0_Wed Jun 15 2022 02:40:16 GMT+0800","2022-06-10T08:00:00","Defect","Ship Staff","Ship Staff Insp.","EGCS gas analyzer has chopper motor failure alarms","E/R - Aux. Mach.","Eng. / Strg. Comp.","Equipment Related","10.32","Very High","","","Communication with maker spare parts ordered.. Gas analyser and service attendance arranged through SSUN225094","2022-09-10T08:00:00","SSUN225094","In progress",null,"No","No","No","Internal"]
[null,null,null,null,81664,"0_Wed Jun 15 2022 02:48:19 GMT+0800","2022-06-10T08:00:00","Defect","Ship Staff","Ship Staff Insp.","WHRS soot blow not possible from ECR panel.","E/R - Boiler","Eng. / Strg. Comp.","Equipment Related","10.32","Very High","","","WHRS soot blow operation and ups battery fail alarm active. communication with maker started and awaiting reply from maker.","2022-09-10T08:00:00","","In progress",null,"No","No","No","Internal"]
[null,null,null,null,49623,"0_Wed Jun 15 2022 02:53:28 GMT+0800","2022-06-10T08:00:00","Defect","Ship Staff","Ship Staff Insp.","We have noticed quantity discrepancy with Bilge guard flowmeter.\nTotal quantity discharged overboard recorded in Bilge guard is less than the actual quantity pumped overboard. We are recording actual quantity in ORB with reference to our manual sounding. ","E/R - Pipes/ valves & fittings","Eng. / Strg. Comp.","Equipment Related","10.32","Very High","","","Informed office and raised requisition for Flowmeter through SSUN220102\n","2022-09-10T08:00:00","SSUN220102","Waiting spare",null,"No","No","No","Internal"]
[null,null,null,null,72855,"55_Wed Jun 15 2022 05:05:16 GMT+0800","2022-06-10T08:00:00","Defect","Ship Staff","Ship Staff Insp.","One of the cargo pressure transmitter local display not visible.\n\n","Deck - Pipe / Fittings","Cargo / Ballast Systems","Equipment Related","8.41","Medium","","","Pressure transmitter for cargo manifold ordered through SSUN220071","2022-09-10T08:00:00","SSUN220071","Waiting spare",null,"No","No","No","Internal"]
[null,null,null,null,11488,"55_Wed Jun 15 2022 05:11:11 GMT+0800","2022-06-10T08:00:00","Defect","Ship Staff","Ship Staff Insp.","Rosemount WSU one of the CPU has failed same ordered and awaiting spare SSUN225084. Communication with maker in progress backup file sent to maker as per request","Cargo Mach.","Cargo / Ballast Systems","Equipment Related","8.70","Medium","","","Tried installation but having issue contacted maker.","2022-09-10T08:00:00","","In progress",null,"No","No","No","Internal"]
[null,null,null,null,95612,"0_Wed Jun 15 2022 05:13:49 GMT+0800","2022-06-10T08:00:00","Defect","Ship Staff","Ship Staff Insp.","IGG firing but having flame failure alarm, flame eye requested, suspect the control valves now, still not succeeded. ","E/R - Aux. Mach.","Cargo / Ballast Systems","Equipment Related","10.32","Very High","","","Spares ordered","2022-09-10T08:00:00","SSUN220098","Waiting spare",null,"No","No","No","Internal"]
[null,null,null,null,74907,"55_Thu Jun 23 2022 21:01:20 GMT+0800","2022-06-15T08:00:00","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Spot rust and weeping marks observed on COT, WBT Tank domes and Hydraulic valve boxes especially near the Butterfly nuts.","Deck - Pipe / Fittings","General Appearance","Equipment Related","11.3","Medium","","","Spot rust and weeping marks observed on COT, WBT Tank domes and Hydraulic valve boxes especially near the Butterfly nuts from fwd to midship completed , midship to aft in progress","2022-09-15T08:00:00","","In progress",null,"No","No","No","Internal"]
[null,null,null,null,86922,"55_Thu Jun 23 2022 21:27:26 GMT+0800","2022-06-15T08:00:00","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Spot rust and weeping marks observed on Deck pipelines near the supports, U Clamps and flanges.","Deck - Pipe / Fittings","General Appearance","Equipment Related","11.4","Very High","","","Spot de rusting and painting on deck pipelines near the supports, U Clamps and flanges completed forward to midship area . Midship area to aft in progress","2022-09-15T08:00:00","","In progress",null,"No","No","No","Internal"]
[null,null,null,null,50895,"55_Tue Jul 12 2022 02:02:45 GMT+0800","2022-02-21T08:00:00","Observation","Ship Staff","Ship Staff Insp.","VDR RCU UNIT PCB Eject button defective, New PCB received & replaced but due to Error in installation, Old one placed back in use again as per Instructions from office. New MCB on board. However New MCB onboard need to be configured for all channels inputs and that only service engineer can do. ","Navigation - Others","Navigation","Equipment Related","4.7","High","","","Awaiting service Engineer attendance. Office to be informed prior convenient port call for attendance of service Engineer.  So that new PCB onboard can be programmed for all input channels and can be fixed.","2022-10-31T08:00:00","N/A - Office to be informed prior convenient port call for attendance of service Engineer. ","Waiting spare",null,"No","No","No","Internal"]
[null,null,null,null,38287,"55_Tue Jul 12 2022 02:08:58 GMT+0800","2022-05-05T08:00:00","Observation","Ship Staff","Ship Staff Insp.","AIS is Unable to switch to LOW TX power (As Required by ISGOTT & Local port requirements)","Navigation - DGPS / EPFS / AIS","Navigation","Equipment Related","4.7","High","","","Office informed,  Office / Maker's to advise settings as the AIS shows error (NG OVERTIME ERR) during power reduction.","2022-10-31T08:00:00","N/A","In progress",null,"No","No","No","Internal"]
[null,null,null,null,34778,"55_Tue Jul 12 2022 02:16:00 GMT+0800","2022-02-21T08:00:00","Critical Equipment","Ship Staff","Ship Staff Insp.","ECDIS fitted onboard 2 x JRC 901-B AND USED AS PRIMARY MEANS OF Navigation SSD last replaced July 2022. \nNo spare Pre-Programmed SSD's onboard as required under critical spare part list of company. ","Navigation - ECDIS","Navigation","Equipment Related","","","","","Spare pre programmed SSD's to be supplied during next convenient call. ","2022-10-31T08:00:00","","Waiting spare",null,"No","No","No","Internal"]
[null,null,null,null,73012,"55_Tue Jul 12 2022 02:26:34 GMT+0800","2022-06-15T08:00:00","Observation","Ship Staff","Ship Staff Insp.","Bridge wing control console speed log repeater not readable with max brilliance in the day light time.","Navigation - Echo Sounder / Speed Log","Navigation","Equipment Related","","","","","New Log display for Bridge wing repeater to be supplied. and to be fitted.","2022-10-31T08:00:00","","Waiting spare",null,"No","No","No","Internal"]
[null,null,null,null,45280,"55_Sat Jul 30 2022 09:01:39 GMT+0800","2022-07-15T08:00:00","Defect","Ship Staff","Ship Staff Insp.","VRCS UNLOADER MECHANISM NOT OPERATIONAL","Deck - Machinery","Cargo / Ballast Systems","Equipment Related","8.31","High","","","SAME OVERHAULED BUT STILL NOT WORKING PO RAISED","2022-10-15T08:00:00","SSUN220141","Waiting spare",null,"No","No","No","Internal"]
[null,null,null,null,97126,"55_Thu Jun 23 2022 19:59:40 GMT+0800","2022-06-15T08:00:00","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Manhole covers on deck to de rust especially areas near the tightening nuts.","Deck - Pipe / Fittings","General Appearance","Equipment Related","11.3","Medium","","","De rusting of Manhole covers on deck to be carried out, especially areas near the tightening nuts completed from fwd to midship area .Midship area to aft in progress","2022-09-15T08:00:00","","In progress","2022-07-06T08:00:00","No","No","No","Internal"]
[null,null,null,null,81857,"55_Mon Aug 01 2022 19:45:51 GMT+0800","2022-06-26T08:00:00","Defect","Ship Staff","Ship Staff Insp.","MAIN ENGINE STBD BRIDGE WING CONSOLE OUT OF ORDER DUE TO BWU09 MODULE NOT OPERATIONAL","E/R - Main Engine","Eng. / Strg. Comp.","Equipment Related","10.31","Very High","","","BWU 09 CONNECTION REMOVED FROM PSS 2B IN BCC IN ORDER TO AVOID CAN B FAILURE ALARM.","2022-09-25T08:00:00","","In progress",null,"No","No","No","Internal"]

{"sheet":"Completed","index":1,"n_rows":67,"n_cols":28,"rows_kept":67,"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","01-Aug-2022",null,null,"Ship Name","DHT SUNDARBANS (23-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,24351,null,"55_1/3/2022 4:26:07 am","2022-02-26T23:59:35","Defect","Ship Staff","Ship Staff Insp.","Engine room skylight mooring wire found to have broken strands.","Deck - Pipe / Fittings","Structural Condn. / WT integrity ","Equipment Related","5.47","Medium","","","Wire replaced.","2022-05-07T23:59:35","","Completed","2022-03-22T23:59:35","No","No","No","Internal"]
[null,null,null,24352,null,"55_5/3/2022 9:43:01 pm","2022-02-26T23:59:35","Defect","Ship Staff","Ship Staff Insp.","Various tap fittings in accomodation found to be leaking as reported by crew in Safety meeting","Accommodation","MLC Related","Equipment Related","11.13","Low","","","Requistion received through SSUN220050 and leaking taps renewed.","2022-05-28T23:59:35","","Completed","2022-04-20T23:59:35","No","No","No","Internal"]
[null,null,null,24350,null,"55_5/3/2022 10:03:02 pm","2022-02-28T23:59:35","Defect","Ship Staff","Ship Staff Insp.","Electrical insulation matt found to be missing at various panels in Engine room.","Elect. Mach. & Equip.","Eng. / Strg. Comp.","Equipment Related","10.24","Low","","","Electrical insulation matt at missing locations installed.","2022-03-30T23:59:35","","Completed","2022-03-18T23:59:35","No","No","No","Internal","Mat supplied at DD. Close defect after putting at missing area."]
[null,null,null,24355,null,"55_5/3/2022 9:33:12 pm","2022-02-28T08:00:00","Observation","Ship Staff","Ship Staff Insp.","Loose items in Engine room not secured.","Miscellaneous","Eng. / Strg. Comp.","External Factors","5.11","Low","","","All loose items have been be shifted to their respective stowage  proper location and secured.","2022-03-28T08:00:00","","Completed","2022-03-10T08:00:00","No","No","No","Internal","Noted."]
[null,null,null,24356,null,"55_5/3/2022 9:47:01 pm","2022-02-28T23:59:35","Defect","Ship Staff","Ship Staff Insp.","Various doors including accomodation and purifier room door the holding latches screw found to be missing.","Accommodation,E/R - Purifier","Safety / LSA / FFA","Equipment Related","5.35","Medium","","","Missing screw for latches installed and door closing function tested for proper closing.","2022-04-28T23:59:35","","Completed","2022-03-14T23:59:35","No","No","No","Internal","Noted."]
[null,null,null,24357,null,"55_5/3/2022 9:50:37 pm","2022-02-28T23:59:35","Critical Equipment,Observation","Ship Staff","Ship Staff Insp.","Critical spare parts found to be missing and also critical spare part inventory to be updated in PAL.","E/R - Main Engine,Elect. Mach. & Equip.","Emgcy. Systems","Equipment Related","10.13","Very High","","","Missing critical spare parts to be requested upon taking complete inventory of critical spare parts. Closing as all spares ordered from vessel as well approved by office","2022-05-30T23:59:35","SSUN220007,SSUN220015,SSUN220016,SSUN220017,SSUN220018,SSUN220019,SSUN220020,SSUN220021,SSUN220022,S","Completed","2022-04-19T23:59:35","No","No","No","Internal"]
[null,null,null,24359,null,"55_5/3/2022 9:59:53 pm","2022-02-28T23:59:35","Observation","Ship Staff","Ship Staff Insp.","EGCS side shell renewal and various stubb piece renewed in Engine room and same area needs to be derusted and painting including funnel top deck plate.","Hull & Tanks","Structural Condn. / WT integrity ","Equipment Related","10.31","Very High","","","Area needs to be derusted and painted.","2022-03-30T23:59:35","","Completed","2022-03-15T23:59:35","No","No","No","Internal","Noted."]
[null,null,null,24360,null,"55_5/3/2022 10:07:37 pm","2022-02-28T23:59:35","Other","Ship Staff","Ship Staff Insp.","ECA Book not available onboard.","Miscellaneous","MARPOL Related","Industry Issue","10.5","Low","","","ECA book received and updated","2022-04-30T23:59:35","","Completed","2022-04-15T23:59:35","No","No","No","Internal"]
[null,null,null,24361,null,"55_5/3/2022 10:25:49 pm","2022-02-28T23:59:35","Defect","Ship Staff","Ship Staff Insp.","WHRS cladding insulation material found to be missing and same needs to be installed.","E/R - Boiler","Eng. / Strg. Comp.","Equipment Related","10.19","Very High","","","yard fabricated insulation cladding cover and given to ship, same installed in place.","2022-04-30T23:59:35","Waiting for the engine to be stopped for enabling installation.","Completed","2022-04-20T23:59:35","No","No","No","Internal"]
[null,null,null,24363,null,"55_5/3/2022 10:42:44 pm","2022-02-28T23:59:35","Defect","Ship Staff","Ship Staff Insp.","High pressure pipe connected upon completion of decarb not secured with antisplash tape.","E/R - Main Engine","Eng. / Strg. Comp.","Equipment Related","10.19","Very High","","","Potential areas of splash to be protected with anti splash tape same installed and completed.","2022-04-29T23:59:35","","Completed","2022-04-20T23:59:35","No","No","No","Internal"]
[null,null,null,24842,null,"55_31/3/2022 11:02:04 am","2022-03-18T23:59:35","Defect","Ship Staff","Ship Staff Insp.","Fault with fire detection system due to faulty short circuit isolator.","Critical Equip.,LSA / FFA","Eng. / Strg. Comp.","Equipment Related","5.39","Very High","","","Informed office and the electrical department provided short circuit isolator in singapore on 27/03/2022 same installed and found fault alarm is clear.","2022-05-12T23:59:35","","Completed","2022-03-29T23:59:35","No","No","No","Internal"]
[null,null,null,24839,null,"55_31/3/2022 12:56:19 pm","2022-03-25T23:59:35","Defect","Ship Staff","Ship Staff Insp.","Topping up generator monthly outines tried out, noticed sw valve not holding as well one of the flame sensor is faulty.","Miscellaneous","Eng. / Strg. Comp.","Equipment Related","8.25","Very High","","","SW valve renewed.","2022-07-27T23:59:35","","Completed","2022-04-17T23:59:35","No","No","No","Internal"]
[null,null,null,null,62197,"55_Sun May 01 2022 14:10:21 GMT+0800","2022-04-15T08:00:00","Observation","Ship Staff","Ship Staff Insp.","No 1 ME Fuel pump high pressure pipe connection found to have minor leaks","E/R - Main Engine,E/R - Pipes/ valves & fittings","Eng. / Strg. Comp.","Equipment Related","10.29","Medium","","","High pressure pipe disconnected and found one O-ring to be damaged.  Same replaced and assembled back observed to find leakage to be stopped.","2022-05-26T08:00:00","","Completed","2022-04-29T08:00:00","No","No","No","Internal"]
[null,null,null,24841,null,"55_31/3/2022 1:00:09 pm","2022-03-30T08:00:00","Defect","Ship Staff","Ship Staff Insp.","Port side provision controller display had no indications, though there is no display indications the functionality of the crane controller is in good order. ","Miscellaneous","Structural Condn. / WT integrity ","Equipment Related","8.5","Very High","","","Controller replaced and job completed.","2022-08-06T08:00:00","","Completed","2022-04-22T08:00:00","No","No","No","Internal"]
[null,null,null,null,83707,"55_Tue May 03 2022 22:23:29 GMT+0800","2022-04-01T08:00:00","Defect","Ship Staff","Ship Staff Insp.","MAIN ENGINE FUEL OIL HEATER #2 FOUND LEAKING ","E/R - Main Engine","Eng. / Strg. Comp.","Equipment Related","10.1","Medium","","","FUEL OIL HEATER STACK REMOVED AND GASKET CHANGED,","2022-05-05T08:00:00","","Completed","2022-05-02T08:00:00","No","No","No","Internal"]
[null,null,null,24362,null,"55_5/3/2022 10:33:34 pm","2022-02-28T08:00:00","Observation","Ship Staff","Ship Staff Insp.","Scrubber room not fitted with engine room alarm extension.","Elect. Mach. & Equip.","Eng. / Strg. Comp.","Equipment Related","10.2","Low","","","Alarm signal light and cable procured in DD and same installed. Tested operation and found satisfactory.","2022-05-05T08:00:00","","Completed","2022-05-05T08:00:00","No","No","No","Internal","Noted."]
[null,null,null,24358,null,"55_5/3/2022 9:55:52 pm","2022-02-28T08:00:00","Defect","Ship Staff","Ship Staff Insp.","Laundry drying room thermostat not cutting off.","Accommodation","MLC Related","Equipment Related","11.14","Medium","","","Thermostat received and installed. job completed.","2022-05-20T08:00:00","SSUN220034","Completed","2022-05-20T08:00:00","No","No","No","Internal","Raise requisition."]
[null,null,null,null,57835,"55_Thu May 26 2022 12:19:35 GMT+0800","2022-05-02T08:00:00","Observation","Ship Staff","Ship Staff Insp.","Doppler log repeater display on Bridge front not clearly readable / visible  in the day-light with maximum brilliance. ","Navigation - Echo Sounder / Speed Log","Navigation","Equipment Related","4.7","High","","","New display ordered and replaced.","2022-05-20T08:00:00","SSUN225078","Completed","2022-05-18T08:00:00","No","No","No","Internal"]
[null,null,null,null,51330,"55_Thu May 26 2022 12:29:39 GMT+0800","2022-05-02T08:00:00","Observation","Ship Staff","Ship Staff Insp.","MF/ HF Ariel securing clamp was observed missing during monthly test/checks of the equipment as per PMS schedule.","Navigation - GMDSS & Communication","Navigation","Equipment Related","4.7","High","","","MF/ HF Ariel securing clamp renewed.","2022-05-05T08:00:00","","Completed","2022-05-03T08:00:00","No","No","No","Internal"]
[null,null,null,null,71133,"55_Fri May 27 2022 02:52:35 GMT+0800","2022-05-15T08:00:00","Defect","Ship Staff","Ship Staff Insp.","Analyze pump internal leakage alarm on Pump room fixed gas detection system.","Cargo Mach.","Cargo / Ballast Systems","Equipment Related","8.46","Very High","","","Analyze Pump overhauled and renewed flow switch. Job completed. \nNo alarm on Pump room fixed gas detection system \n","2022-05-19T08:00:00","","Completed","2022-05-18T08:00:00","No","No","No","Internal"]
[null,null,null,null,66428,"55_Fri May 27 2022 03:16:27 GMT+0800","2022-05-10T08:00:00","Defect","Ship Staff","Ship Staff Insp.","4C COT overfill alarm not operational.","Cargo Mach.","Cargo / Ballast Systems","Equipment Related","8.14","Very High","","","Requisition made for Magnet in float assembly.\nReceived magnet and same has been renewed.\nOverfill alarm operational, job completed.\n","2022-05-21T08:00:00","SSUN220051","Completed","2022-05-19T08:00:00","No","No","No","Internal"]
[null,null,null,24354,null,"55_6/3/2022 2:31:27 pm","2022-02-27T08:00:00","Defect","Ship Staff","Ship Staff Insp.","Port and stbd accommodation ladder lashing guide are not in good condition (rubber guides on which wire lashing is resting).","Deck - Pipe / Fittings","General Appearance","Equipment Related","5.47","Medium","","","Lashing guide ordered and received on board.\nSame has been renewed. Job completed.\n","2022-05-27T08:00:00","","Completed","2022-05-10T08:00:00","No","No","No","Internal","Noted. Close defect after renewing same."]
[null,null,null,null,16952,"55_Tue May 31 2022 08:20:33 GMT+0800","2022-03-01T08:00:00","Defect","Ship Staff","Ship Staff Insp.","AUX DG TC COMPRESSOR WHEEL FOUND CHIPPED , EFFICIENCY OF TC NOT RELIABLE","E/R - Aux. Engine","Eng. / Strg. Comp.","Equipment Related","10.32","Very High","","","SPARE TC CARTRIDGE REQUESTED. SAME INSTALLED","2022-06-01T08:00:00","STAI150016/2","Completed","2022-05-21T08:00:00","No","No","No","Internal"]
[null,null,null,null,13882,"55_Tue May 31 2022 08:22:47 GMT+0800","2022-05-01T08:00:00","Critical Equipment","Ship Staff","Ship Staff Insp.","SCRUBBER ROOM FIRE DAMPER HARD TO OPERATE","LSA / FFA","Eng. / Strg. Comp.","Equipment Related","5.35","Medium","","","DAMPER TO OVERHAUL AND MAKE FREE TO OPERATE","2022-05-31T08:00:00","","Completed","2022-05-30T08:00:00","No","No","No","Internal"]
[null,null,null,24453,null,"55_20/3/2022 4:39:59 pm","2022-02-10T08:00:00","Defect","Ship Staff","Ship Staff Insp.","ME JCW Temperature Control Valve Position Sensor Fail\t\t\t\t","Elect. Mach. & Equip.","Eng. / Strg. Comp.","Equipment Related","10.2","Low","","","We have replaced the valve positioner and alarm has cleared.","2022-06-05T08:00:00","SSUN220038","Completed","2022-06-10T08:00:00","No","No","No","Internal"]
[null,null,null,24455,null,"55_20/3/2022 4:53:22 pm","2022-03-01T08:00:00","Defect","Ship Staff","Ship Staff Insp.","Fault alarm was received on ER OMD Panel for Boiler Area #2","LSA / FFA","Safety / LSA / FFA","Equipment Related","5.35","Medium","","","Spares received and same replaced and job completed.","2022-06-01T08:00:00","SSUN220039","Completed","2022-06-10T08:00:00","No","No","No","Internal"]
[null,null,null,24457,null,"55_20/3/2022 3:10:00 pm","2022-03-02T08:00:00","Defect","Ship Staff","Ship Staff Insp.","Bosun store water mist system repeater panel on bridge showing no indication.\t","LSA / FFA","Safety / LSA / FFA","Equipment Related","5.35","Medium","","","PCB received and renewed.","2022-07-04T08:00:00","SSUN220032","Completed","2022-06-10T08:00:00","No","No","No","Internal"]
[null,null,null,null,18580,"55_Sun May 01 2022 16:40:06 GMT+0800","2022-05-01T08:00:00","Defect","Ship Staff","Ship Staff Insp.","ME DGU CAN A FAILURE","E/R - Main Engine","Eng. / Strg. Comp.","Equipment Related","10.1","Medium","","","Service engineer attended in San Diego.  All CAN A and CAN B connections were swapped in E25 box. DGU AL module was replaced. issue rectified.","2022-08-01T08:00:00","SSUN225090","Completed","2022-06-10T08:00:00","No","No","No","Internal"]
[null,null,null,null,70470,"55_Tue May 31 2022 08:26:30 GMT+0800","2022-05-24T08:00:00","Defect,Observation","Ship Staff","Ship Staff Insp.","WHRS MANHOLE GASKETS HAVE LEAK. THREADS FOR SECURING STUDA DAMGED","E/R - Boiler","Eng. / Strg. Comp.","Equipment Related","10.32","Very High","","","Manhole gaskets renewed on WHRS for 6 no doors.","2022-08-24T08:00:00","","Completed","2022-06-14T08:00:00","No","No","No","Internal"]
[null,null,null,null,89448,"0_Wed Jun 15 2022 02:26:06 GMT+0800","2022-06-02T08:00:00","Defect","Ship Staff","Ship Staff Insp.","Common rail box tested for cracks and found few cracks and action needs to be taken.","E/R - Main Engine","Eng. / Strg. Comp.","Equipment Related","10.32","Very High","","","Crack end punched in order to arrest the cracks.","2022-09-02T08:00:00","","Completed","2022-06-21T08:00:00","No","No","No","Internal"]
[null,null,null,null,81536,"55_Wed Jun 15 2022 02:33:24 GMT+0800","2022-06-10T08:00:00","Observation","Ship Staff","Ship Staff Insp.","M/E ICO lube 440 volt low insulation alarm comes when started.","E/R - Main Engine","Eng. / Strg. Comp.","Equipment Related","10.32","Very High","","","Isolation transformer has been supplied to vessel and pending installation, same needs to be installed to clear alarm// ","2022-09-10T08:00:00","","Completed","2022-06-20T08:00:00","No","No","No","Internal"]
[null,null,null,null,70941,"55_Thu Jun 23 2022 19:08:43 GMT+0800","2022-06-15T08:00:00","Defect","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Railing near WBP 2 on bottom platform in Pump room not secured (Bolts loose and some missing).","Deck - Pipe / Fittings","Structural Condn. / WT integrity ","Equipment Related","5.11","Low","","","Railing near WBP 2 on bottom platform in Pump room secured with Bolts and nuts & tighten.","2022-06-30T08:00:00","","Completed","2022-06-18T08:00:00","No","No","No","Internal"]
[null,null,null,null,16683,"55_Thu Jun 23 2022 19:14:14 GMT+0800","2022-06-15T08:00:00","Defect","Owner / Marine / Tech. Suptd.","Suptd. Insp.","SWL not marked on pad eye in Pump room .","Deck - Pipe / Fittings","General Appearance","Human Error","8.50","Medium","","","SWL marked on pad eyes in pump room.","2022-06-30T08:00:00","","Completed","2022-06-21T08:00:00","No","No","No","Internal"]
[null,null,null,null,62282,"55_Thu Jun 23 2022 19:20:58 GMT+0800","2022-06-15T08:00:00","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","1 no Garbage bin in Hospital and 1 no in Crew Messroom is not color coded as per Garbage management plan ","Accommodation","General Appearance","Human Error","6.20","Medium","","","Garbage bin in Hospital and Crew Messroom color coded and labelled as per Garbage management plan.","2022-06-30T08:00:00","","Completed","2022-06-18T08:00:00","No","No","No","Internal"]
[null,null,null,null,35875,"55_Thu Jun 23 2022 19:25:47 GMT+0800","2022-06-15T08:00:00","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Cleaning equipment’s kept in pipe and duct space to remove.","Accommodation","General Appearance","Human Error","11.8","Low","","","Removed cleaning equipment, which kept in pipe and duct space and Notice posted.","2022-06-21T08:00:00","","Completed","2022-06-18T08:00:00","No","No","No","Internal"]
[null,null,null,null,47274,"55_Thu Jun 23 2022 19:30:52 GMT+0800","2022-06-15T08:00:00","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","All Duty officers to be familiarized with the BWTS and procedures to be posted.","Documentation","Cargo / Ballast Systems","Human Error","6.21","High","","","Familiarisation carried out  regarding BWTS procedure and same has been posted in CCR.","2022-06-30T08:00:00","","Completed","2022-06-19T08:00:00","No","No","No","Internal"]
[null,null,null,null,34729,"55_Thu Jun 23 2022 19:35:45 GMT+0800","2022-06-15T08:00:00","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Locking pin for Lifebuoys on Deck to be checked for free movement as some of them are painted over.","LSA / FFA","Safety / LSA / FFA","Human Error","5.31","High","","","De rusting and painting of Locking pin of life buoys carried out.\nConfirmed free movement of the same.\n","2022-06-22T08:00:00","","Completed","2022-06-21T08:00:00","No","No","No","Internal"]
[null,null,null,null,31362,"55_Thu Jun 23 2022 19:52:11 GMT+0800","2022-06-15T08:00:00","Defect","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Spare Vapor manifold reducers kept in Midship stores to check for compliance with requirements of OCIMF.","Deck - Machinery","Cargo / Ballast Systems","Equipment Related","8.42","Medium","","","12’ o clock stud pcs were missing for spare vapor manifold reducer.\nNew stud pcs fabricated for the same as per OCIMF requirement. \n","2022-06-30T08:00:00","","Completed","2022-06-20T08:00:00","No","No","No","Internal"]
[null,null,null,null,46331,"55_Thu Jun 23 2022 20:39:26 GMT+0800","2022-06-15T08:00:00","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","All PV Valves vacuum side wire mesh having Rust spots and stains.","Cargo Mach.","Cargo / Ballast Systems","Equipment Related","8.21","High","","","PV valve vacuum side wire mesh renewed with new wire mesh. ","2022-07-15T08:00:00","","Completed","2022-06-21T08:00:00","No","No","No","Internal"]
[null,null,null,null,18806,"55_Fri Jun 24 2022 00:30:38 GMT+0800","2022-06-15T08:00:00","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","All lifting gears on Deck to be tagged and marked as per the inventory.","Deck - Machinery","General Appearance","Human Error","8.50","Medium","","","Lifting gear tagged as per the inventory.","2022-07-05T08:00:00","","Completed","2022-06-21T08:00:00","No","No","No","Internal"]
[null,null,null,null,64245,"55_Fri Jun 24 2022 00:45:50 GMT+0800","2022-06-15T08:00:00","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","No wire lashing for Heavy equipment and stores in Port midship store.","Deck - Machinery","General Appearance","Human Error","5.11","Low","","","Wire lashing taken for heavy equipment in Port midship store.","2022-06-30T08:00:00","","Completed","2022-06-20T08:00:00","No","No","No","Internal"]
[null,null,null,null,17680,"55_Fri Jun 24 2022 00:50:26 GMT+0800","2022-06-15T08:00:00","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Max stowage line for Sprinkler not marked in Sample locker.","LSA / FFA","Safety / LSA / FFA","Human Error","5.48","Medium","","","Max stowage line for Sprinkler marked in Sample locker.","2022-06-30T08:00:00","","Completed","2022-06-21T08:00:00","No","No","No","Internal"]
[null,null,null,null,36644,"55_Fri Jun 24 2022 18:34:08 GMT+0800","2022-06-15T08:00:00","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","2 nos Safety harness in Stbd midship store in poor condition.","LSA / FFA","Safety / LSA / FFA","Human Error","5.5","Low","","","2 Safety harness kept in stbd mid ship store were not in use, same has been removed from stbd midship store and discarded. Safety harness with two lanyard, two snap hooks and an energy absorber kept in mid ship store.","2022-06-22T08:00:00","","Completed","2022-06-19T08:00:00","No","No","No","Internal"]
[null,null,null,null,33742,"55_Fri Jun 24 2022 00:00:04 GMT+0800","2022-06-15T08:00:00","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","All portable ladders on Deck not tagged and inventory not maintained.","Deck - Machinery","General Appearance","Human Error","8.50","Medium","","","All portable ladders on Deck tagged and inventory maintained for the same","2022-07-05T08:00:00","","Completed","2022-06-24T08:00:00","No","No","No","Internal"]
[null,null,null,null,83648,"55_Thu Jun 23 2022 19:42:03 GMT+0800","2022-06-15T08:00:00","Defect","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Locking pin for Hook of Stbd davit in Sunken deck and Bosun store davit is frozen.","Deck - Machinery","Safety / LSA / FFA","Equipment Related","8.50","Medium","","","Locking pin for Hook of Stbd davit in Sunken deck and Bosun store davit greased and confirmed free movement.","2022-06-30T08:00:00","","Completed","2022-06-24T08:00:00","No","No","No","Internal"]
[null,null,null,null,28192,"55_Mon Jun 20 2022 21:19:50 GMT+0800","2022-06-06T08:00:00","Defect","Ship Staff","Ship Staff Insp.","During the pressure testing it was observed that the Cargo Line No. 3 to IG Connection T-Piece was leaking. Same was fully tightened up and the leak was stopped.\nHowever suspect the Cargo Line No. 3 Valve to IG Line (OD-339) is suspected to be leaking. The line was re-pressurized to 11.0 bars and confirmed no leaks were observed during the time of inspection.\n","Deck - Pipe / Fittings","Cargo / Ballast Systems","Equipment Related","8.11","Medium","","","Renewed seat ring of valve OD-339, job completed.","2022-06-30T08:00:00","","Completed","2022-06-21T08:00:00","No","No","No","Internal"]
[null,null,null,null,12387,"55_Fri Jun 24 2022 18:46:13 GMT+0800","2022-06-15T08:00:00","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Bilge cover for Aft Bilge well near Propeller shaft on port side is missing.","E/R - Pipes/ valves & fittings","Eng. / Strg. Comp.","Human Error","10.15","Low","","","Bilge cover for Aft Bilge well near Propeller shaft to be put back in position.","2022-07-05T08:00:00","","Completed","2022-06-20T08:00:00","No","No","No","Internal"]
[null,null,null,null,27902,"55_Fri Jun 24 2022 18:51:21 GMT+0800","2022-06-15T08:00:00","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Max stowage line for Sprinkler not marked in Chemical locker.","LSA / FFA","Safety / LSA / FFA","Human Error","5.48","Medium","","","Max stowage line for Sprinkler to be marked in Chemical locker.","2022-06-30T08:00:00","","Completed","2022-06-21T08:00:00","No","No","No","Internal"]
[null,null,null,null,83555,"55_Thu Jun 23 2022 20:31:42 GMT+0800","2022-06-15T08:00:00","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Spot rust and weeping marks observed on Slop P & S Steam manifold.","Deck - Pipe / Fittings","General Appearance","Equipment Related","11.3","Medium","","","De rusting and painting  carried out at Slop P & S Steam manifold.","2022-07-15T08:00:00","","Completed","2022-06-30T08:00:00","No","No","No","Internal"]
[null,null,null,null,73085,"0_Wed Jun 15 2022 02:30:41 GMT+0800","2022-06-10T08:00:00","Defect","Ship Staff","Ship Staff Insp.","M/E top brazing no 4 is leaking.","E/R - Main Engine","Eng. / Strg. Comp.","Equipment Related","10.32","Very High","","","M/E top brazing no 4 needs to be overhauled. Spares are already onboard.","2022-09-10T08:00:00","","Completed","2022-07-28T08: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":427,"n_cols":3,"rows_kept":427,"cut":false,"hidden":true,"merged":[]}
["VIQ_ref_no","Risk Value of observation","ID"]
["1.1","Low",8243]
["1.10","Low",8252]
["1.11","Low",8253]
["1.12","Low",8254]
["1.13","Low",8255]
["1.14","Low",8256]
["1.15","Low",8257]
["1.16","Low",8259]
["1.17","Low",8260]
["1.18","Low",8261]
["1.19","Low",8262]
["1.2","Low",8244]
["1.20","Low",8263]
["1.21","Low",8265]
["1.22","Low",8266]
["1.23","Low",8267]
["1.24","Low",8268]
["1.25","Low",8269]
["1.26","Low",8270]
["1.3","Low",8245]
["1.4","Low",8246]
["1.5","Low",8247]
["1.6","Low",8248]
["1.7","Low",8249]
["1.8","Low",8250]
["1.9","Low",8251]
["1.99","High",11258]
["10.1","Medium",8461]
["10.10","High",8470]
["10.11","Medium",8471]
["10.12","Very High",8472]
["10.13","Very High",8473]
["10.14","Medium",8474]
["10.15","Low",8475]
["10.16","Very High",8476]
["10.17","Very High",8477]
["10.18","High",8478]
["10.19","Very High",8479]
["10.2","Low",8462]
["10.20","High",8480]
["10.21","Medium",8481]
["10.22","Low",8482]
["10.23","Medium",8483]
["10.24","Low",8484]
["10.25","Very High",8485]
["10.26","High",8486]
["10.27","Medium",8487]
["10.28","Low",8488]
["10.29","Medium",8489]
["10.3","Medium",8463]
["10.30","High",8490]
["10.31","Very High",8491]
["10.32","Very High",8492]
["10.33","High",8493]
["10.34","High",8494]
["10.35","Very High",8495]
["10.36","Very High",8496]
["10.37","Medium",8497]
["10.38","Medium",8498]
["10.39","High",8499]
["10.4","High",8464]
["10.40","Medium",8500]
["10.41","Medium",8501]
["10.42","Medium",8502]
["10.43","Medium",8503]
["10.44","Medium",8504]
["10.45","Very High",8505]
["10.46","High",8506]
["10.47","Medium",8507]
["10.48","High",8508]
["10.49","Medium",8509]
["10.5","Low",8465]
["10.50","High",8510]
["10.51","Low",8511]
["10.52","Medium",8512]
["10.53","Medium",8513]
["10.54","High",8514]
["10.55","Low",8515]
["10.6","Very High",8466]
["10.7","Medium",8467]
["10.8","Medium",8468]
["10.9","Medium",8469]
["10.99","High",8516]
["11.1","High",8420]
["11.10","Medium",8429]
["11.11","Very High",8430]
["11.12","Low",8431]
["11.13","Low",8432]
["11.14","Medium",8433]
["11.15","Low",8434]
["11.16","Low",8435]
["11.17","Low",8436]
["11.2","Medium",8421]
["11.3","Medium",8422]
["11.4","Very High",8423]
["11.5","Medium",8424]
["11.6","Medium",8425]
["11.7","High",8426]
["11.8","Low",8427]
["11.9","Low",8428]
["11.99","High",8437]
["12.1","High",8438]
["12.10","High",8448]
["12.11","High",8449]
["12.12","High",8450]
["12.13","High",8451]
["12.14","High",8452]
["12.15","High",8453]
["12.16","High",8454]
["12.17","High",8455]
["12.18","High",8456]
["12.19","High",8457]
["12.2","High",8439]
["12.20","High",8458]
["12.21","High",8459]
["12.3","High",8441]
["12.4","High",8442]
["12.5","High",8443]
["12.6","High",8444]
["12.7","High",8445]
["12.8","High",8446]
["12.9","High",8447]
["12.99","High",8460]
["2.1","Very High",8296]
["2.1.9","Very High",11259]
["2.10","Medium",8304]
["2.11","Medium",8305]
["2.12","Low",8306]
["2.13","Low",8307]
["2.14","Low",8308]
["2.15","Low",8309]
["2.16","Medium",8310]
["2.2","Medium",8297]
["2.3","High",8295]
["2.4","Medium",8298]
["2.5","Medium",8299]
["2.6","Low",8300]
["2.7","High",8301]
["2.8","High",8302]
["2.9","Medium",8303]
["2.99","High",8311]
["3.1","High",8312]
["3.2","Very High",8313]
["3.3","High",8314]
["3.4","Low",8294]
["3.5","Medium",8315]
["3.6","High",8316]
["3.7","Very High",8317]
["3.8","Very High",8318]
["3.99","High",8319]
["4.1","High",8320]
["4.10","High",8329]
["4.11","Medium",8330]
["4.12","Very High",8331]
["4.13","Very High",8332]
["4.14","Very High",8333]
["4.15","Very High",8334]
["4.16","Very High",8335]
["4.17","Very High",8336]
["4.18","Very High",8337]
["4.19","Low",8338]
["4.2","Medium",8321]
["4.20","Very High",8339]
["4.21","High",8340]
["4.22","Low",8341]
["4.23","High",8342]
["4.24","High",8343]
["4.25","Low",8344]
["4.26","Low",8345]
["4.27","High",8346]
["4.3","Medium",8322]
["4.4","High",8323]
["4.5","Very High",8324]
["4.6","Medium",8325]
["4.7","High",8326]
["4.8","Medium",8327]
["4.9","Medium",8328]
["4.99","High",8347]
["5.1","Very High",8517]
["5.10","High",8526]
["5.11","Low",8527]
["5.12","Medium",8528]
["5.13","High",8529]
["5.14","Very High",8530]
["5.15","Medium",8531]
["5.16","Very High",8532]
["5.17","Very High",8533]
["5.18","High",8534]
["5.19","Medium",8535]
["5.2","Very High",8518]
["5.20","Medium",8536]
["5.21","Medium",8537]
["5.22","High",8539]
["5.23","Very High",8540]
["5.24","Very High",8541]
["5.25","Medium",8542]
["5.26","Medium",8543]
["5.27","Medium",8544]
["5.28","Very High",8545]
["5.29","High",8546]
["5.3","Low",8519]
["5.30","High",8547]
["5.31","High",8548]
["5.32","High",8549]
["5.33","High",8550]
["5.34","Low",8551]
["5.35","Medium",8552]
["5.36","Low",8553]
["5.37","Low",8554]
["5.38","High",8555]
["5.39","Very High",8556]
["5.4","High",8520]
["5.40","Very High",8557]
["5.41","Very High",8558]
["5.42","Medium",8559]
["5.43","High",8560]
["5.44","High",8561]
["5.45","Medium",8564]
["5.46","Medium",8565]
["5.47","Medium",8566]
["5.48","Medium",8567]
["5.5","Low",8521]
["5.6","Low",8522]
["5.7","Medium",8523]
["5.8","Medium",8524]
["5.9","Very High",8525]
["5.99","High",8568]
["6.1","Medium",8348]
["6.10","Low",8357]
["6.11","High",8358]
["6.12","Medium",8359]
["6.13","Low",8360]
["6.14","High",8361]
["6.15","High",8362]
["6.16","Very High",8363]
["6.17","Very High",8364]
["6.18","Medium",8365]
["6.19","Low",8366]
["6.2","High",8349]
["6.20","Medium",8367]
["6.21","High",8368]
["6.22","Medium",8369]
["6.3","Low",8350]
["6.4","High",8351]
["6.5","Medium",8352]
["6.6","Medium",8353]
["6.7","High",8354]
["6.8","High",8355]
["6.9","Low",8356]
["6.99","High",8370]
["7.1","High",8371]
["7.10","High",8380]
["7.11","High",8381]
["7.12","High",8382]
["7.13","Medium",8383]
["7.14","Medium",8384]
["7.15","High",8385]
["7.16","High",8386]
["7.17","High",8387]
["7.2","High",8372]
["7.3","Low",8373]
["7.4","Low",8374]
["7.5","Low",8375]
["7.6","Medium",8376]
["7.7","Low",8377]
["7.8","High",8378]
["7.9","High",8379]
["7.99","High",8388]
["8.1","Very High",8569]
["8.10","Very High",8578]
["8.100","Low",11227]
["8.101","Medium",11228]
["8.102","Low",11229]
["8.103","Low",11230]
["8.104","Low",11231]
["8.105","Medium",11232]
["8.106","Medium",11233]
["8.107","Low",11234]
["8.108","High",11235]
["8.109","Very High",11236]
["8.11","Medium",8579]
["8.110","High",11237]
["8.111","Medium",11238]
["8.112","High",11239]
["8.113","Medium",11240]
["8.114","Low",11241]
["8.115","High",11242]
["8.116","Medium",11243]
["8.117","Medium",11244]
["8.118","Medium",11245]
["8.119","High",11246]
["8.12","Medium",8580]
["8.120","High",11247]
["8.121","Medium",11248]
["8.122","High",11249]
["8.123","High",11250]
["8.124","Low",11251]
["8.125","High",11252]
["8.126","Medium",11253]
["8.127","Medium",11254]
["8.13","Medium",8581]
["8.14","Very High",8582]
["8.15","High",8583]
["8.16","Very High",8584]
["8.17","Low",8585]
["8.18","High",8586]
["8.19","High",8587]
["8.199","High",11255]
["8.2","Medium",8570]
["8.20","Medium",8588]
["8.21","High",8589]
["8.22","Very High",8590]
["8.23","Medium",8591]
["8.24","Medium",8592]
["8.25","Very High",8593]
["8.26","High",8594]
["8.27","Medium",8595]
["8.28","Medium",8596]
["8.29","High",8598]
["8.3","Very High",8571]
["8.30","High",8599]
["8.31","High",8600]
["8.32","Low",8601]
["8.33","Medium",8602]
["8.34","High",8603]
["8.35","Medium",8604]
["8.36","Medium",8605]
["8.37","High",8607]
["8.38","Medium",8608]
["8.39","Medium",8609]
["8.4","Medium",8572]
["8.40","High",8610]
["8.41","Medium",8611]
["8.42","Medium",8612]
["8.43","Very High",8613]
["8.44","High",8615]
["8.45","High",8616]
["8.46","Very High",8617]
["8.47","Very High",8618]
["8.48","Medium",8619]
["8.49","High",8620]
["8.5","Very High",8573]
["8.50","Medium",8621]
["8.51","Low",8622]
["8.52","Low",8623]
["8.53","Low",8624]
["8.54","High",8625]
["8.55","Low",11182]
["8.56","Medium",11183]
["8.57","Medium",11184]
["8.58","High",11185]
["8.59","High",11186]
["8.6","Medium",8574]
["8.60","High",11187]
["8.61","Medium",11188]
["8.62","Very High",11189]
["8.63","High",11190]
["8.64","Medium",11191]
["8.65","Low",11192]
["8.66","High",11193]
["8.67","High",11194]
["8.68","High",11195]
["8.69","Medium",11196]
["8.7","High",8575]
["8.70","Medium",11197]
["8.71","Very High",11198]
["8.72","Medium",11199]
["8.73","Medium",11200]
["8.74","High",11201]
["8.75","Medium",11202]
["8.76","Medium",11203]
["8.77","Medium",11204]
["8.78","Medium",11205]
["8.79","Medium",11206]
["8.8","Medium",8576]
["8.80","Medium",11207]
["8.81","Low",11208]
["8.82","Medium",11209]
["8.83","Low",11210]
["8.84","Low",11211]
["8.85","Medium",11212]
["8.86","Medium",11213]
["8.87","Medium",11214]
["8.88","Low",11215]
["8.89","High",11216]
["8.9","High",8577]
["8.90","High",11217]
["8.91","High",11218]
["8.92","Medium",11219]
["8.93","Low",11220]
["8.94","Low",11221]
["8.95","Medium",11222]
["8.96","Medium",11223]
["8.97","Low",11224]
["8.98","High",11225]
["8.99","Medium",11226]
["9.1","Low",8390]
["9.10","Medium",8399]
["9.11","Medium",8400]
["9.12","Medium",8401]
["9.13","Low",8402]
["9.14","Medium",8403]
["9.15","Medium",8404]
["9.16","High",8405]
["9.17","High",8406]
["9.18","Low",8407]
["9.19","Low",8408]
["9.2","Very High",8391]
["9.20","Medium",8409]
["9.21","Medium",8410]
["9.22","Low",8411]
["9.23","Low",8412]
["9.24","Medium",8413]
["9.25","Low",8414]
["9.26","Low",8415]
["9.27","Low",8416]
["9.28","Medium",8417]
["9.29","Low",8418]
["9.3","Very High",8392]
["9.4","High",8393]
["9.5","High",8394]
["9.6","Low",8395]
["9.7","Medium",8396]
["9.8","Medium",8397]
["9.9","Medium",8398]
["9.99","High",8419]

{"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"]
["55","DHT SUNDARBANS (23-04-2022)","55_1650869714964.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"]