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

{"sheet":"Mainsheet","index":0,"n_rows":20,"n_cols":28,"rows_kept":20,"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,"2020-11-03","Date of Report","2020-09-01",null,"xx","Ship Name","PROMETHEUS ENERGY (03-11-2020)",null,null,null,"Not Applicable","Not Applicable","xx","2020-11-30",null,"In progress",null,"No",null,null,"Internal"]
[]
[null,null,null,null,null,null,"VERSION : 2.0"]
[]
[]
[]
[null,null,null,null,"ID","UNIQUE ID","Date Recorded","Type of Deficiency","Observer code","Type of Inspection","Description of Deficiency","Equipment Categories","Area of Observation","Deficiency Cause","VIQ Ref Number","Risk Value of Obs","PSC Ref Number","PSC MOU ID","Action Taken or Required","Target Date","PO Ref No.","Status Code","Date Completed","Drydock","Info Sharing","Critical Item","Audit Type","Superintendent Remarks"]
[null,null,null,null,8488,"82_30/11/2019 4:30:16 PM","2019-12-01","Guarantee Claim","Ship Staff","Ship Staff Insp.","2P COT fixed tank radar gauging system showing erratic readings. Sometimes system gets hanged and gives erratic readings.","Cargo Mach.","Cargo / Ballast Systems","Equipment Related",8.1199999999999992,"Medium","Not Applicable","Not Applicable","1. GC claim raised. Maker Musasino has attended on 24th Dec at Livorno, Italy. 2. Log files sent to maker. Maker has agreed to attend the defect on vessel. Update maker with vessel schedule. ","2020-11-30","GC CE-033","In progress",null,"No","No","No","Internal","pls revert the updates for this issue. Because GC period is over and we can push maker to attend only 1 more time.\nWill chase maker through SSK but will take time to travel restrictions. Noted no major trouble."]
[null,null,null,null,13592,"82_1/9/2020 12:30:49 AM","2020-08-23","Breakdown,Defect","Ship Staff","Ship Staff Insp.","BWTS EDU DOSING PUMP PVC casing leaked from drain.","Cargo Mach.","Eng. / Strg. Comp.","Equipment Related","","","","","Silicon applied between PVC casing and metallic casing. Pump tested during ballasting operation, small leak persists.","2020-11-22","","Waiting spare",null,"No","No","No","Internal","pls raise list of spares required and send to maker Sunrui to supply as the BWTS is unde rguarantee"]
[null,null,null,null,null,"82_3/11/2020 1:21:50 AM","2020-11-02","Defect","Ship Staff","Ship Staff Insp.","Hoppe shaft torque meter is not working. ","E/R - Main Engine","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Defect analysis was carried out. Messuring block and cable was supplied by the maker under guaranty period, however measuring block is found previously used and old. Torque meter is still not working.  ","2020-12-01",null,"Waiting spare",null,"No",null,null,"Internal"]

{"sheet":"Completed","index":1,"n_rows":84,"n_cols":28,"rows_kept":84,"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,"2020-09-15","Date of Report","2020-09-01",null,"date","Ship Name","PROMETHEUS ENERGY (30-09-2020)",null,null,null,"Not Applicable","Not Applicable","date","2020-09-30",null,"xyz",null,"No",null,null,"Internal"]
[]
[null,null,null,null,null,null,"VERSION : 2.0"]
[]
[]
[]
[null,null,null,null,"ID","UNIQUE ID","Date Recorded","Type of Deficiency","Observer code","Type of Inspection","Description of Deficiency","Equipment Categories","Area of Observation","Deficiency Cause","VIQ Ref Number","Risk Value of Obs","PSC Ref Number","PSC MOU ID","Action Taken or Required","Target Date","PO Ref No.","Status Code","Date Completed","Drydock","Info Sharing","Critical Item","Audit Type","Superintendent Remarks"]
[null,null,null,null,8697,"82_23/12/2019 12:25:40 AM","2019-03-29","Defect","SIRE / CDI Insp.","OM Insp. (Eg. SIRE / CDI etc.)","The phone in the pump room was not working","Cargo Mach.","Cargo / Ballast Systems","Equipment Related","8.7","High","","","Rectified","2019-03-31","","Completed","2019-03-29","No","No","No","External"]
[null,null,null,null,8698,"82_23/12/2019 12:28:32 AM","2019-03-29","Defect","SIRE / CDI Insp.","OM Insp. (Eg. SIRE / CDI etc.)","The engine room bilge emergency overboard discharge valve had not been posted with a notice warning against accidental opening.\n\nThe overboard discharge valve had been secured with seal.\n\nSimilarly, some markings and warning notices were not in place, such as fore bosun store bilge overboard discharge valve, tank vapour lockers,\n\nbunker line and engine room bilge line to the slop tanks, pump room piping diagram and cargo pump performance curves in CCR etc.","Miscellaneous","MARPOL Related","Inappropriate Procedure","6.15","High","","","Posters and Procedures marked.","2019-03-31","","Completed","2019-03-31","No","No","No","External"]
[null,null,null,null,8699,"82_23/12/2019 12:31:32 AM","2019-03-29","Defect","SIRE / CDI Insp.","OM Insp. (Eg. SIRE / CDI etc.)","The personal protective equipment (PPE) such as a face shield, apron, gloves and an eye-wash had not been provided in the pain\n\nlocker, similarly there was no PPE in the battery locker.","Miscellaneous","ISM Related","Inappropriate Procedure","5.46","Medium","","","PPE placed","2019-03-31","","Completed","2019-03-29","No","No","No","External"]
[null,null,null,null,8700,"82_23/12/2019 12:33:35 AM","2019-03-29","Defect","SIRE / CDI Insp.","OM Insp. (Eg. SIRE / CDI etc.)","The bridge watch levels were ambiguous for several specific circumstances, there were two optional watch levels for one specific\n\ncondition, for example, the bridge watch level 2 or 3 was required under the circumstance of restricted visibility and little or no traffic.","Miscellaneous","Navigation","Inappropriate Procedure","4.6","Medium","","","Nil","2019-03-31","","Completed","2019-03-31","No","No","No","External"]
[null,null,null,null,82,"82_Sat Oct 05 2019 17:45:08 GMT+0000","2019-04-01","Defect","Ship Staff","Ship Staff Insp.","FIRE DETECTOR TO BE INSTALLED IN FOAM ROOM","LSA / FFA","Safety / LSA / FFA","Equipment Related","5.35","Medium","","","REQUIRED SPARES AND OFFICE ADVISE",null,"","Completed","2019-09-02","No","No","No","Internal","Will be done at convenient port as its not a defect and only MESQAC requirement."]
[null,null,null,null,89,"82_Sat Oct 05 2019 15:30:59 GMT+0000","2019-04-01","Defect","Ship Staff","Ship Staff Insp.","LIFTING GEAR NOT IDENTIFIED AND SECURED","E/R - Pipes/ valves & fittings","Eng. / Strg. Comp.","Equipment Related","10.28","Low","","","LIFTING GEAR INDENTIFIED AND SECURED IN ER WORKSHOP ","2019-04-30","","Completed","2019-04-13","No","No","No","Internal"]
[null,null,null,null,91,"82_Sat Oct 05 2019 16:18:45 GMT+0000","2019-04-01","Defect","Ship Staff","Ship Staff Insp.","PIPES AND PLATES ON DECK TO BE TRANSFERED TO ER AND SECURE","Deck - Pipe / Fittings","Eng. / Strg. Comp.","Equipment Related","5.11","Low","","","PIPES AND PLATES ON DECK TRANSFERED TO ER AND SECURED PERMANENTLY","2019-05-30","","Completed","2019-05-16","No","No","No","Internal"]
[null,null,null,null,92,"82_Fri May 10 2019 16:13:48 GMT+0000","2019-04-01","Defect","Ship Staff","Ship Staff Insp.","ME AIRCOOLER /TC AE SAPRE LINER/CON ROD TOOLS TO SECURE","Miscellaneous","Eng. / Strg. Comp.","Equipment Related","5.11","Low","","","ME AIRCOOLER /TC AE SAPRE LINER/CON ROD TOOLS  SECURED PERMANENTLY BY WELDING","2019-04-30","","Completed","2019-04-28","No","No","No","Internal"]
[null,null,null,null,93,"82_Sat Oct 05 2019 16:09:50 GMT+0000","2019-04-01","Defect","Ship Staff","Ship Staff Insp.","ER ALL VALVE SPINDLE AND GREASE POINT LUBRICATION TO BE CARRIED OUT","E/R - Pipes/ valves & fittings","Eng. / Strg. Comp.","Equipment Related","11.7","High","","","ER ALL VALVE SPINDLE AND GREASE POINT LUBRICATION CARRIED OUT AND FREED","2019-04-15","","Completed","2019-04-10","No","No","No","Internal"]
[null,null,null,null,90,"82_Sat Oct 05 2019 16:25:05 GMT+0000","2019-04-08","Defect","Ship Staff","Ship Staff Insp.","BWTS TRO SAMPLE LINE WAS LEFT OPEN  AND NOT CONNECTED.WATER FOUND LEAKING","Miscellaneous","Cargo / Ballast Systems","Equipment Related","8.55","Low","","","BWTS TRO SAMPLE CONNECTED AND WATER LEAK ARRESTED","2019-04-10","","Completed","2019-04-10","No","No","No","Internal"]
[null,null,null,null,94,"82_Fri May 10 2019 16:37:51 GMT+0000","2019-04-11","Defect","Ship Staff","Ship Staff Insp.","COUPLING GAURD FOR PUMP ROOM NO1 FAN NOT IN PLACE","Cargo Mach.,Deck - Machinery","Cargo / Ballast Systems","Equipment Related","10.27","Medium","","","COUPLING GAURD FOR PUMP ROOM NO1 FAN FIXED AND SECURED","2019-04-20","","Completed","2019-04-14","No","No","No","Internal"]
[null,null,null,null,8716,"82_20/12/2019 10:59:31 PM","2019-04-16","Non Conformity","Ship Staff","Ship Staff Insp.","Bilge suction valves in the pump room were noted shut","Cargo Mach.","Cargo / Ballast Systems","Human Error,Inappropriate Procedure,Knowledge Based","6.12","Medium","","","The valves were opened and tagged \" Keep open at All times\"\n\nThe main valve (Remote controlled\" kept shut and tagged\" Open only in event of emergency\"","2019-04-17","","Completed","2019-04-16","No","No","No","Internal"]
[null,null,null,null,95,"82_Sat Oct 05 2019 16:43:10 GMT+0000","2019-04-17","Defect","Ship Staff","Ship Staff Insp.","FORWARD FOG HORN DRAIN VALVE LEAKING","Miscellaneous","Emgcy. Systems","Equipment Related","10.27","Medium","","","FORWARD FOG HORN DRAIN VALVE REPLACED","2019-04-30","","Completed","2019-04-19","No","No","No","Internal"]
[null,null,null,null,107,"82_Sat Oct 05 2019 17:31:50 GMT+0000","2019-04-24","Guarantee Claim","Ship Staff","Ship Staff Insp.","BTWS RECTIFIER FAULTY","Miscellaneous","Eng. / Strg. Comp.","Equipment Related","6.21","High","","","RECEIVED NEW RECTIFIER IN G.CLAIM AND REPLACED","2019-06-30","GC CE001","Completed","2019-06-10","No","No","No","Internal"]
[null,null,null,null,102,"82_Sat Oct 05 2019 17:12:00 GMT+0000","2019-04-25","Guarantee Claim","Ship Staff","Ship Staff Insp.","DRIP PANS NOT PROVIDED FOR STEERING GEAR RAMS","Miscellaneous","Eng. / Strg. Comp.","Equipment Related","","","","","DRIP PANS FOR STEERING GEAR RAMSSUPPLIED BY YARD AND FIXED IN PLACE","2019-06-30","GC CM02","Completed","2019-05-30","No","No","No","Internal"]
[null,null,null,null,8701,"82_23/12/2019 12:40:42 AM","2019-05-01","Defect","Terminal Insp.","Terminal Insp.","Sopep Wilden pump for STBD side main deck not in place","Deck - Pipe / Fittings","ISM Related","Human Error","","","","","Wilden pump placed at correct location.","2019-05-01","","Completed","2019-05-01","No","No","No","External"]
[null,null,null,null,8718,"82_23/12/2019 12:45:41 AM","2019-05-02","Defect","SIRE / CDI Insp.","OM Insp. (Eg. SIRE / CDI etc.)","Auxiliary engine 1 and 3 were in operation at the time of inspection.\n\nNoted high vibration on platform railing of AE 1, however platform railing of AE 3 was noted\n\nsmooth and no vibration\n\n","Miscellaneous","Eng. / Strg. Comp.","Equipment Related","10.32","Very High","","","Platform railing of AE#1 support fabricated.","2019-05-31","","Completed","2019-05-17","No","No","No","External"]
[null,null,null,null,109,"82_Sat Oct 05 2019 17:38:35 GMT+0000","2019-05-06","Defect","Ship Staff","Ship Staff Insp.","ME SHAFT POWER METER DEFECTIVE","E/R - Main Engine","Eng. / Strg. Comp.","Equipment Related","10.21","Medium","","","SERVICE TECH ATTENDED THE VSL AND RECTIFIED DEFECT","2019-07-07","","Completed","2019-07-06","No","No","No","Internal"]
[null,null,null,null,101,"82_Sat Oct 05 2019 17:08:01 GMT+0000","2019-05-09","Defect","SIRE / CDI Insp.","OM Insp. (Eg. SIRE / CDI etc.)","AUXILLARY ENGINE  PLATFORM VIBRATION NOTICED","E/R - Aux. Engine","Eng. / Strg. Comp.","Equipment Related","5.11","Low","","","AUXILLARY ENGINE  PLATFORM VIBRATION ARRESTED BY PROVIDING SUPPORTS TO THE PLATFORM","2019-05-31","","Completed","2019-05-15","No","No","No","Internal"]
[null,null,null,null,100,"82_Sat Oct 05 2019 17:04:02 GMT+0000","2019-05-13","Defect","Ship Staff","Ship Staff Insp.","NO.1 HFO PURIFIER FEEDPUMP SEAL LEAKING","E/R - Purifier","Eng. / Strg. Comp.","Equipment Related","10.2","Low","","","NO.1 HFO PURIFIER FEEDPUMP SEAL RENEWED AND LEAKAGE ARRESTED","2019-08-31","","Completed","2019-08-19","No","No","No","Internal"]
[null,null,null,null,8713,"82_20/12/2019 10:52:38 PM","2019-05-14","Non Conformity","Ship Staff","Ship Staff Insp.","Internal Audit - ISM : Few Risk Assessments created were not using the latest revision of the form","Miscellaneous","ISM Related","Human Error,Inappropriate Procedure,Knowledge Based","","","","","New RAs were made using latest version of RA form.","2019-08-13","","Completed","2019-08-14","No","No","No","Internal"]
[null,null,null,null,8714,"82_20/12/2019 10:54:37 PM","2019-05-14","Defect","Ship Staff","Ship Staff Insp.","Isolation valves in the steering gear toom for the High Expansion Foam were not marked","LSA / FFA","Eng. / Strg. Comp.","Human Error,Inappropriate Procedure,Knowledge Based","","","","","Isolation Valve inside steering gear room for high expansion form marked as per line diagram.","2019-08-13","","Completed","2019-08-12","No","No","No","Internal"]
[null,null,null,null,8715,"82_20/12/2019 10:57:01 PM","2019-05-14","Defect","Ship Staff","Ship Staff Insp.","MSDS for OSD not available at the SOPEP locker","Miscellaneous","ISM Related","Human Error,Inappropriate Procedure,Knowledge Based","5.46","Medium","","","MSDS sheet for OSD was placed inside SOPEP LOCKER","2019-08-13","","Completed","2019-08-13","No","No","No","Internal"]
[null,null,null,null,96,"82_Sat Oct 05 2019 16:47:10 GMT+0000","2019-05-19","Defect","Ship Staff","Ship Staff Insp.","FIREMANS OUTFIT STEEL BOX IN FIRE CONTROL SECURED WITH ROPE","LSA / FFA","Safety / LSA / FFA","Inappropriate Procedure","5.11","Low","","","FIREMANS OUTFIT STEEL BOX IN FIRE CONTROL SECURED WITH WIRE AND TURN BUCLKE ARRANGEMENT","2019-05-26","","Completed","2019-05-26","No","No","No","Internal"]
[null,null,null,null,97,"82_Sat Oct 05 2019 16:51:34 GMT+0000","2019-05-19","Defect","Ship Staff","Ship Staff Insp.","PRESSURE GAUGE WAS NOT FIXED ON MAIN FIRE LINE AT BRIGEWING AND DECK FORWARD","LSA / FFA","Safety / LSA / FFA","Equipment Related","","","","","MISSING PRESSURE GAUGES WERE FIXED ON MAIN FIRE LINE AT BRIDGE WING AND DECK FORWARD","2019-05-30","","Completed","2019-05-20","No","No","No","Internal"]
[null,null,null,null,98,"82_Sat Oct 05 2019 16:55:57 GMT+0000","2019-05-23","Defect","Ship Staff","Ship Staff Insp.","BUNKER FO TANKS OVERFLOW LINE FLANGES NOT TIGHTENED BY YARD SUFFICIENTLY","Hull & Tanks","Structural Condn. / WT integrity ","Equipment Related","","","","","BUNKER FO TANKS OVERFLOW LINE FLANGES FULLY TIGHTENED .","2019-05-28","","Completed","2019-05-24","No","No","No","Internal"]
[null,null,null,null,99,"82_Sat Oct 05 2019 17:00:49 GMT+0000","2019-05-23","Defect","Ship Staff","Ship Staff Insp.","ISOLATION VALVE FLANGE ON THE FIRE LINE IN PUMPROOM FOUND LEAKING","LSA / FFA","Safety / LSA / FFA","Equipment Related","8.55","Low","","","ISOLATION VALVE FLANGE ON THE FIRE LINE IN THE PUMPROOM  LEAKING AND ALL FLANGE BOLTS TIGHTENED AND LEAK ARRESTED","2019-05-31","","Completed","2019-05-24","No","No","No","Internal"]
[null,null,null,null,106,"82_Sat Oct 05 2019 17:29:02 GMT+0000","2019-05-27","Defect","Ship Staff","Ship Staff Insp.","ME SCAV DOX DRAIN  STEAM VALVE SPINDLE BROKEN","E/R - Pipes/ valves & fittings","Eng. / Strg. Comp.","Equipment Related","10.32","Very High","","","ME SCAV DOX DRAIN  STEAM VALVE RECEIVED IN PORVOO AND REPLACED","2019-07-31","GC CM-010","Completed","2019-07-26","No","No","No","Internal"]
[null,null,null,null,8712,"82_20/12/2019 10:49:50 PM","2019-06-01","Defect","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Overwriting of entries were observed in Deck Log Book and Bridge Bell Book","Miscellaneous","Navigation","Human Error,Knowledge Based","4.2","Medium","","","Briefing of all Officers carried out and future entries would be verified","2019-06-10","","Completed","2019-06-09","No","No","No","Internal"]
[null,null,null,null,108,"82_Sat Oct 05 2019 17:34:53 GMT+0000","2019-06-01","Guarantee Claim","Ship Staff","Ship Staff Insp.","SERVICE AIR RESORVIOUR DRAIN VALVE LEAKING","E/R - Air Comp.","Eng. / Strg. Comp.","Equipment Related","10.29","Medium","","","SERVICE AIR RESORVIOUR DRAIN RECEIVED UNDER GC AND REPLACED","2019-06-30","GC CM012","Completed","2019-06-15","No","No","No","Internal"]
[null,null,null,null,105,"82_Sat Oct 05 2019 17:23:53 GMT+0000","2019-06-02","Defect","Ship Staff","Ship Staff Insp.","CARGO MANIFOLD PRESSURE GAUGES VALVE OFFSEC","Deck - Pipe / Fittings","Cargo / Ballast Systems","Equipment Related","","","","","CARGO MANIFOLD PRESSURE GAUGES VALVE SUPPLIED BY YARD AND REPLACED","2019-08-30","GC CD-003","Completed","2019-08-03","No","No","No","Internal"]
[null,null,null,null,103,"82_Sat Oct 05 2019 17:14:48 GMT+0000","2019-06-10","Defect","Ship Staff","Ship Staff Insp.","IG BREATHER VALVE BLANK AND BOLTS RUSTED","Deck - Pipe / Fittings","General Appearance","Equipment Related","","","","","IG BREATHER VALVE BLANK AND BOLTS DERUSTED ADN PAINTED","2019-06-20","","Completed","2019-01-15","No","No","No","Internal"]
[null,null,null,null,104,"82_Sat Oct 05 2019 17:20:39 GMT+0000","2019-06-14","Defect","Ship Staff","Ship Staff Insp.","AFT ETA PICKUP LINE BUOY LIGHT BATTERY EXPIRED","Miscellaneous","Eng. / Strg. Comp.","Equipment Related","9.28","Medium","","","AFT ETA PICKUP LINE BUOY LIGHT BATTERY RENEWED","2019-06-14","","Completed","2019-06-14","No","No","No","Internal"]
[null,null,null,null,8711,"82_20/12/2019 10:46:41 PM","2019-06-19","Defect","Ship Staff","Ship Staff Insp.","Visitor card (No.05) missing","Miscellaneous","ISPS Related","Human Error","","","","","Condition and Count check of all Visitor Cards shall be done prior Arrival/Departure port and logged. Visitor card No. 5 received from office.","2019-06-30","","Completed","2019-07-29","No","No","No","Internal"]
[null,null,null,null,110,"82_Sat Oct 05 2019 17:42:02 GMT+0000","2019-08-10","Guarantee Claim","Ship Staff","Ship Staff Insp.","FCM HIGH VISCOSITY FAULT AFTER SOWTWARE UPDATE BY SERV ENGINIEER","E/R - Aux. Mach.","Eng. / Strg. Comp.","Equipment Related","10.35","Very High","","","FCM HIGH VISCOSITY FAULT RECTIFIED BY SERV ENGINIEER AT CASTELLON-SPAIN","2019-09-30","GC CE10","Completed","2019-09-24","No","No","No","Internal"]
[null,null,null,null,85,"82_Sat Oct 05 2019 17:53:17 GMT+0000","2019-08-21","Defect","Ship Staff","Ship Staff Insp.","BWTS ONE RECTIFIER UNIT FAULTY","Elect. Mach. & Equip.","Eng. / Strg. Comp.","Equipment Related","6.21","High","","","RECTIFIER UNIT REPAIR BY SERVICE ENGINEER ATTAENDED AT TURKEY ON 24NOV2019","2019-11-30","GC CE017","Completed","2019-11-24","No","No","No","Internal","GC STILL OPEN"]
[null,null,null,null,8707,"82_20/12/2019 10:11:45 PM","2019-09-21","Defect","Owner / Marine / Tech. Suptd.","Suptd. Insp.","The drain for the Port and Stbd Manifold drip trays were provided with a double valve, However no threaded cap or blank arrangement was provided.","Deck - Pipe / Fittings","Cargo / Ballast Systems","Equipment Related","6.8","High","","","Immediately drain pipe was opened and bolted flange was welded on the drain pipe inside ER workshop","2019-12-20","","Completed","2019-09-28","No","No","No","Internal"]
[null,null,null,null,8708,"82_20/12/2019 10:16:30 PM","2019-09-21","Defect","Owner / Marine / Tech. Suptd.","Suptd. Insp.","The Non WGS 84 charts for the voyage from Okwori to Castellon were not identified and noted in the passage plan for the voyage.","Navigation - ECDIS","Navigation","Human Error","4.2","Medium","","","Immediately all Non WGS-84 ENC were marked with user added layers and also a list of Non-WGS84 Enc were included in Passage Plan summary.","2019-12-20","","Completed","2019-09-28","No","No","No","Internal"]
[null,null,null,null,8709,"82_20/12/2019 10:19:43 PM","2019-09-21","Defect","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Chemical proof clothing were not availble in the vicinity of the boiler dosing area.","Miscellaneous","Eng. / Strg. Comp.","Human Error,Inappropriate Procedure","5.5","Low","","","Chemical PPE immediately put in place near the boiler","2019-12-20","","Completed","2019-09-28","No","No","No","Internal"]
[null,null,null,null,8710,"82_20/12/2019 10:23:55 PM","2019-09-21","Defect","Owner / Marine / Tech. Suptd.","Suptd. Insp.","The bulldog grips used to make a temporary eye for the wire lashing for the wharf ladder was fitted with the u-clamps on the standing end of the wire rope. ","Miscellaneous","General Appearance","Human Error,Inappropriate Procedure,Knowledge Based","11.8","Low","","","Immediately direction of bulldog grips were corrected as per COSWP. ","2019-12-20","","Completed","2019-09-28","No","No","No","Internal"]
[null,null,null,null,8717,"82_22/12/2019 6:26:32 PM","2019-09-24","Defect","SIRE / CDI Insp.","OM Insp. (Eg. SIRE / CDI etc.)","The aft access ladder fitted on starboard supply engine room fan duct\n\nlocated on funnel deck, was not provided with safe guards for protecting the personal against\n\nfalling. The ladder height was approximate 6 meters.","Deck - Pipe / Fittings","General Appearance","Equipment Related","11.3","Medium","","","Safe guard fabricated","2019-09-30","","Completed","2019-09-30","No","No","No","External"]
[null,null,null,null,87,"82_Fri May 10 2019 17:59:07 GMT+0000","2019-09-24","Defect","Ship Staff","Ship Staff Insp.","PORT SIDE CARGO MANIFOLD DRIP TRAY GRATING DAMAGED AT PORT CASTEELON","Cargo Mach.","Cargo / Ballast Systems","Equipment Related","","","",""," REPAIRED GRATING ONBOARD","2019-11-30","","Completed","2019-10-25","No","No","No","Internal"]
[null,null,null,null,88,"82_Fri May 10 2019 18:01:38 GMT+0000","2019-09-26","Guarantee Claim","Ship Staff","Ship Staff Insp.","ME UNIT 5 PMI ONLINE SENSOR DEFECTIVE","E/R - Main Engine","Eng. / Strg. Comp.","Equipment Related","10.32","Very High","","","SPARES RECEIVED UNDER GC. NOT REQUIRED TO RENEW NOW.PRESENTLY WORKING GOOD","2019-11-30","GC CM021.","Completed","2019-11-26","No","No","No","Internal"]
[null,null,null,null,9929,"82_20/1/2020 11:28:05 PM","2019-10-08","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Few spare garbage drums found without identification stencil. To be identified with type of garbage to BE used and stenciled.","Miscellaneous","MARPOL Related","Human Error","","","","","Garbage drums stencilled","2019-10-15","","Completed","2019-10-09","No","No","No","Internal"]
[null,null,null,null,9930,"82_20/1/2020 11:31:14 PM","2019-10-08","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","All drums stored on open deck weather plastic or metal to be stored on pallets","Miscellaneous","MARPOL Related","Human Error","","","","","Drums stored on wooden pallets","2019-10-15","","Completed","2019-10-09","No","No","No","Internal"]
[null,null,null,null,9931,"82_20/1/2020 11:35:17 PM","2019-10-08","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Snap back warning on deck to be big enough","Miscellaneous","Mooring","Inappropriate Procedure","","","","","Snap Back warning re-stencilled with bigger letters","2019-10-15","","Completed","2019-10-12","No","No","No","Internal","NOTED"]
[null,null,null,null,9932,"82_20/1/2020 11:40:10 PM","2019-10-08","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","A reach rod to be kept for easily operating pumproom bilge valve.","Deck - Pipe / Fittings","MARPOL Related","Equipment Related","","","","","Reach rod kept near bilge valve","2019-10-15","","Completed","2019-10-09","No","No","No","Internal"]
[null,null,null,null,9933,"82_20/1/2020 11:37:58 PM","2019-10-08","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Brake rendering pointer and ring to be highlighted with yellow paint mark.","Miscellaneous","Mooring","Inappropriate Procedure","","","","","Pointer and ring highlighted with yellow colour","2019-10-15","","Completed","2019-10-12","No","No","No","Internal","NOTED"]
[null,null,null,null,9934,"82_20/1/2020 11:46:23 PM","2019-10-08","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Forepeak store pipeline obstructions on floor to be highlighted with hazard marking tapes. ","Miscellaneous","General Appearance","Behaviour Based","","","","","Tripping harzads highlighted with tiger tape","2019-10-15","","Completed","2019-10-13","No","No","No","Internal"]
[null,null,null,null,9935,"82_20/1/2020 11:47:58 PM","2019-10-08","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","All greasing points on winches and lifeboat davit to be highlighted with yellow markings.","Miscellaneous","General Appearance","Inappropriate Procedure","","","","","Grasing points highlighted with yellow colour","2019-10-15","","Completed","2019-10-13","No","No","No","Internal"]
[null,null,null,null,9936,"82_20/1/2020 11:50:18 PM","2019-10-08","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","COP vibration monitor record to add in checklist and record for future comparison.","Miscellaneous","Cargo / Ballast Systems","Inappropriate Procedure","","","","","Checklist ammended to add vibration record","2019-10-15","","Completed","2019-10-15","No","No","No","Internal"]
[null,null,null,null,8704,"82_22/12/2019 6:30:13 PM","2019-10-15","Guarantee Claim","Ship Staff","Ship Staff Insp.","Fixed cargo tank gauging system for COT No.1 Port was found\nunreliable and one portable tape was used as main method of ullaging in 30min interval. While actual ullage reading was 7.34m display in CCR was recording 2.02m.","Cargo Mach.","Cargo / Ballast Systems","Equipment Related","8.12","Medium","","","GC Raised, awiting technician attendance","2020-04-30","","Completed","2019-12-31","No","No","No","Internal","submit the awaited comments as service engr attended in Dec 2019. The other OPEN defect is same and need to close this as maker attedned in Dec 2019."]
[null,null,null,null,83,"82_Sat Oct 05 2019 17:47:43 GMT+0000","2019-10-17","Defect","Ship Staff","Ship Staff Insp.","FLAME DETECTOR TESTOR TO BE SUPPLIED. PRESENT ON BOARD NOT WORKING","LSA / FFA","Safety / LSA / FFA","Equipment Related","5.39","Very High","","","IR TEST LAMP KIT RECIEVED IN GADNASK @27.04.2020","2020-04-27","OFFICE PO","Completed","2020-04-27","No","No","No","Internal","Pls confirm new Flame detector recvd at Poland call."]
[null,null,null,null,8706,"82_20/12/2019 9:49:38 PM","2019-10-24","Critical Equipment","Ship Staff","Ship Staff Insp.","STBD Side Anchor chain got twisted during CBM Mooring at Castellon, Spain.","Deck - Mooring Machinery","Mooring","Equipment Related","","","",""," Twist removed while the Vessel was drifting at Sea on 24-Oct-2019.","2019-10-30","","Completed","2019-10-24","No","No","No","Internal"]
[null,null,null,null,8705,"82_20/12/2019 9:45:07 PM","2019-11-04","Non Conformity","Ship Staff","Ship Staff Insp.","VISITOR CARD NO. 3  MISSING.CARD WAS ISSUED TO IMMIGRATION OFFICER, ZAWIA","Miscellaneous","ISPS Related","Human Error","","","","","VISITOR CARD NO. 3  RECEIVED FROM OFFICE.","2019-12-30","","Completed","2019-11-24","No","No","No","Internal"]
[null,null,null,null,8487,"82_30/11/2019 3:08:05 PM","2019-11-20","Defect","Ship Staff","Ship Staff Insp.","BWTS PRE FILTER ELEMENT AND AUTO BACKFLUSHING UNIT DEFECTIVE","Miscellaneous","Eng. / Strg. Comp.","Equipment Related","6.21","High","","","spares recieved and replaced","2019-11-28","GC CM-028","Completed","2019-11-28","No","No","No","Internal","SUNRUI  ARRANGING SPARES AS BWTS STILL UNDER GC. BUT PLANT IS OPERATIONAL.,  Pls revert if GC spare not received at Poland??"]
[null,null,null,null,8702,"82_20/12/2019 9:38:18 PM","2020-01-14","Non Conformity","Ship Staff","Ship Staff Insp.","During quarterly functional test of paint store sprinkler system,it was observed that water is coming from the sprinkler nozzle in jet form instead of Spray.","LSA / FFA","Safety / LSA / FFA","Equipment Related","","","","","SPRAY NOZZLE TO BE FABRICATED.","2020-04-30","","Completed","2020-04-20","No","No","No","Internal","pls mention the GC number"]
[null,null,null,null,11177,"82_2/3/2020 4:53:15 PM","2020-02-16","Guarantee Claim","Ship Staff","Ship Staff Insp.","HOSE HANDLING CRANE MODE SELECTION ISOLATING VALVE MALFUNCTIONING","Deck - Machinery","Cargo / Ballast Systems","Equipment Related","","","","","SPARE VALVE RECIEVED ABD RENWEWED ON 08.05.2020 .AFTER CHANGE WE TRIED OUT HOSE HANDLING CRANE ON BOTH MODES .WORKING IN GOOD CONDITION","2020-05-15","GC: CD-012","Completed","2020-05-08","No","No","No","Internal","Pls confirm if spare not received in Poland??"]
[null,null,null,null,11178,"82_2/3/2020 5:08:29 PM","2020-02-18","Guarantee Claim","Ship Staff","Ship Staff Insp.","CHART SPACE DIMMER LIGHT VOLTAGE POTENTIOMETER PCB SHORT CIRCUITED","Navigation - Others","Navigation","Equipment Related","","","","","ISOLATED AND GUARANTEE CLAIM RAISED GC: CE-044","2020-04-15","GC: CE-044","Completed","2020-05-01","No","No","No","Internal"]
[null,null,null,null,null,"82_2/5/2020 8:12:15 AM","2020-04-10","Defect","Ship Staff","Ship Staff Insp.","CO 232 V VALVE REMOTE OPERATION FAILURE.","Cargo Mach.","Cargo / Ballast Systems","Equipment Related",null,null,"Not Applicable","Not Applicable","SAME TROUBLESHOOTED FOUND ZENER BARRIER FOR RESPECTED VALVE FAULTY, PO RAISED SUBMITTED FOR THE SAME. ZENER BARRIER RECEIVED ON 28 OCTBER. ZENER BARRIER REPLACED. CO232 & CO231 OPERATION (OPEN/SHUT) CHECKED. SATISFACTORY.  SATISFACTORY.  ","2020-08-15","PO: PENE 200084","Completed","2020-11-03","No",null,null,"Internal"]
[null,null,null,null,13593,"82_15/7/2020 4:58:52 PM","2020-07-01","Defect","Ship Staff","Ship Staff Insp.","Cargo heating main steam glove valve 250A was found not holding pressure while fully shut, issuing steam on deck. Steam line drain had to be kept open on deck to release pressure from deck steam pipe line. There was loss of feed water and loss of energy as well","Cargo Mach.,E/R - Pipes/ valves & fittings","Eng. / Strg. Comp.","Equipment Related","","","","","The valve was dismantled and inspected. It was found that the seat got unscrewed from body, resulting in leak of steam along the threads. The seat was removed and lapping carried out in engine room workshop. A steam gasket was inserted and seat tightened to body. Valve was assembled in order and tested, found holding steam pressure well, not issuing steam on deck any more. Satisfactory.","2020-07-15","","Completed","2020-07-14","No","No","No","Internal"]
[null,null,null,null,13594,"82_15/7/2020 5:17:15 PM","2020-07-01","Defect","Ship Staff","Ship Staff Insp.","1. BWTS power lost to all 5 flowmeters and all three TRO. 2. TRO1 was not comminicating with main PLC. 3. TRO1 showing zero value during operation","Cargo Mach.,Miscellaneous","Cargo / Ballast Systems","Equipment Related","","","","","1. Power was restored by replacing a blown fuse in control cabinet. 2. Address chnged from 1 to 5, TRO1 comminication resolved. 3. OPTIC PCB ASSEMBLY KIT taken from TRO3 and replaced on TRO1. TRO1 tested with ballasting operation, TRO value found withing normal range. Satisfactory. ","2020-07-15","","Completed","2020-07-15","No","No","No","Internal"]
[null,null,null,null,null,"82_15/7/2020 5:25:24 PM","2020-07-14","Defect","Ship Staff","Ship Staff Insp.","1. TRO3 OPTIC PCB ASSEMBLY KIT removed for fitting on TRO1. TRO3 is non operational. 2. There is an ERROR indication on main PLC.","Cargo Mach.,Miscellaneous","Cargo / Ballast Systems","Equipment Related",null,null,"Not Applicable","Not Applicable","OPTIC PCB RECEIVED ON 28 OCTOBER 2020. REPLACED ON 03 NOVEMBER 2020. FUNCTION OF PCB SATISFACTORY. AFT PEAK TANK BWTS RUNNING TEST NOT POSSIBLE DUE TO NON-AVAILABILITY OF TRO REGENTS.   ","2020-09-30",null,"Completed","2020-11-03","No",null,null,"Internal"]
[null,null,null,null,13595,"82_31/7/2020 9:32:08 PM","2020-07-16","Defect,Guarantee Claim","Ship Staff","Ship Staff Insp.","Cooking apparatus (universal cooking machine- mixer) model SS-30, gears were found jammed. GC CD-13 was raised. ","Accommodation","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","The universal cooking machine was dismantled and parts inspected. Found shaft and gears worn and damged. Spares received and fitted. Tried out and machine put in to service. Performance satisfactory. PMS 551.028.00.00 // V-PENE008259/20. ","2020-08-31","SPARES BEING SUPPLIED AGAINST GC CD-13","Completed","2020-08-17","No","No","No","Internal"]
[null,null,null,null,null,"82_19/8/2020 1:21:07 AM","2020-08-07","Breakdown,Defect","Ship Staff","Ship Staff Insp.","Main Engine funnel exhaust pipe flame arrester is found damaged.","E/R - Main Engine","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Replaced full mesh size 5x5 per linear inch material SUS 316L. ","2020-11-06","PENE200127","Completed","2020-10-15","No",null,null,"Internal"]
[null,null,null,null,13596,"82_19/8/2020 1:42:21 AM","2020-08-11","Defect","Ship Staff","Ship Staff Insp.","E/R ventilation flaps for main engine turbocharger and 8 in numbers flaps at various locations found jammed.  ","E/R - Pipes/ valves & fittings","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","6 in number ventilation flaps have been eased up and lubricated, now in good working condition. Ventilation flap for main engine turbo charger and 2 other flaps near M/E cylinder oil tank and one near aux boiler # 1. were repaired by welding on place. Satisfactory. PMS 574.035.00.00 // JO V-PENE008182/20","2020-11-12",null,"Completed","2020-08-28","No","No","No","Internal"]
[null,null,null,null,13597,"82_19/8/2020 1:47:43 AM","2020-08-12","Defect","Ship Staff","Ship Staff Insp.","Main Engine crank case, two in number minor cracks are present in crank case unit # 1 located forward side on A-FRAME. The cracks are drilled to prvent increase but both cracks have propagated further outside the painted red box. ","E/R - Main Engine","Eng. / Strg. Comp.","Equipment Related,Industry Issue",null,null,"Not Applicable","Not Applicable","Maker advised, it is not a crack but a marking for pin gauge. Hence defect is being closed as no further action necessary.  Hence no job order created in PAL. ","2020-11-11",null,"Completed","2020-08-19","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":8,"n_cols":3,"rows_kept":8,"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]
["xyz",null,8]

{"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"]
["82","PROMETHEUS ENERGY (01-09-2020)","82_1598949497225.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"]