{"text_format":"1","workbook":"xlsx","n_sheets":20,"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"],"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":39,"n_cols":28,"rows_kept":39,"cut":false,"hidden":false,"merged":[[10,8,10,9],[10,12,10,13],[12,6,12,27],[8,6,8,27]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Defect - Damage Monitoring Sheet"]
[]
[null,null,null,null,null,null,null,"Date of Report","18-Dec-2019",null,null,"Ship Name","EVAGORAS"]
[]
[]
[]
[]
[]
[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,7694,"Sun May 12 2019 19:10:39 GMT+0000 (Coordinated Universal Time)","2019-12-13","Deficiency","Ship Staff","Ship Staff Insp.","MAIN ENGINE FO LEAK OFF ALARM SENSOR FOUND BROKEN AND DISCONNECTED","Main Engine ","Eng. / Strg. Comp.","Behaviour Based,Equipment Related","","","","","SENSOR TO BE REPLACED","2019-12-30","","Waiting spare",null,"No","No","No","Internal"]
[null,null,null,null,7695,"16/12/2019 2:32:07 PM","2019-12-13","Deficiency","Ship Staff","Ship Staff Insp.","MAIN ENGINE FLOWMETER FOUND INOPERATIONAL","Main Engine ","Eng. / Strg. Comp.","Equipment Related","","","","","FLOWMETER NEEDS TO BE REPLACED","2019-12-30","","Waiting spare",null,"No","No","No","Internal"]
[null,null,null,null,7696,"16/12/2019 2:40:35 PM","2019-12-13","Deficiency","Ship Staff","Ship Staff Insp.","ONE HOT PLATE FOUND INOPERATIONAL\t\t\t\t\t","Miscellaneous","MLC Related","Behaviour Based,Equipment Related","","","","","HOT PLATE NEEDS TO BE REPLACED","2020-01-10","","Waiting spare",null,"No","No","No","Internal"]
[null,null,null,null,7697,"16/12/2019 2:43:21 PM","2019-12-13","Deficiency","Ship Staff","Ship Staff Insp.","STARTER FOR CONDENSATE PUMP NO.1 FOUND INOPERATIONAL","Boiler","Eng. / Strg. Comp.","Behaviour Based,Equipment Related","","","","","REPLACE THE STARTER WITH SPARE ONBOARD OR NEED TO ORDER.","2019-12-30","","In progress",null,"No","No","No","Internal"]
[null,null,null,null,7698,"16/12/2019 2:46:29 PM","2019-12-14","Deficiency","Ship Staff","Ship Staff Insp.","VARIOUS STEAM LAGGINGS TO BE RENEWED IN THE ENGINE ROOM","ER Pipes, valves & fittings","Eng. / Strg. Comp.","Behaviour Based,Equipment Related","","","","","LAGGINGS TO BE REPLACED + ORDER NEW ONES.","2020-01-10","","In progress",null,"No","No","No","Internal"]
[null,null,null,null,7700,"16/12/2019 3:00:33 PM","2019-12-14","Deficiency","Ship Staff","Ship Staff Insp.","MAST RISER AUTOMATIC PNUEMATIC VALVE OPERATION  IS NOT OPERATIONAL. CURRENTLY OPERATING MANUALLY","Inert Gas","Cargo / Ballast Systems","Behaviour Based,Equipment Related","","","","","THE PNUEMATIC SOLENOID TO BE REPLCAED","2020-01-15","","Not Started",null,"No","No","No","Internal"]
[null,null,null,null,7701,"16/12/2019 3:17:11 PM","2019-12-14","Deficiency","Ship Staff","Ship Staff Insp.","DG NO.3 RUNNING HOUR COUNTER FOUND INOPERATIONAL","Aux. Engine","Eng. / Strg. Comp.","Behaviour Based,Equipment Related","","","","","NEED TO BE ORDERD AND REPLACED","2019-12-30","","Waiting spare",null,"No","No","No","Internal"]
[null,null,null,null,7704,"16/12/2019 3:36:46 PM","2019-12-14","Deficiency","Ship Staff","Ship Staff Insp.","DECK SEAL PUMP NO.1 MOTOR TO BE OVERHAULED","Inert Gas","Eng. / Strg. Comp.","Behaviour Based,Equipment Related","","","","","MOTOR BEARINGS TO BE RENEWED","2019-12-28","","Not Started",null,"No","No","No","Internal"]
[null,null,null,null,7705,"16/12/2019 7:34:57 PM","2019-12-14","Deficiency","Ship Staff","Ship Staff Insp.","ALL 3 DGS SUMP OIL TO BE RENEWED","Aux. Engine","Eng. / Strg. Comp.","Behaviour Based,Equipment Related","","","","","RUNNING HOUR BASED JOB BUT ALREADY DUE FOR ALL 3","2019-12-25","","Not Started",null,"No","No","No","Internal"]
[null,null,null,null,7707,"16/12/2019 7:39:37 PM","2019-12-14","Deficiency","Ship Staff","Ship Staff Insp.","LT COOLER FILTER TO BE CLEANED","Main Engine ","Eng. / Strg. Comp.","Behaviour Based,Equipment Related","","","","","NO RECORDS FOR LAST CLEANING","2019-12-29","","Not Started",null,"No","No","No","Internal"]
[null,null,null,null,7708,"16/12/2019 7:42:08 PM","2019-12-15","Deficiency","Ship Staff","Ship Staff Insp.","BOTH SEACHEST FILTERS TO BE CLEANED","ER Pipes, valves & fittings","Eng. / Strg. Comp.","Behaviour Based,Equipment Related","","","","","NO RECORDS AVAILABLE","2019-12-27","","Not Started",null,"No","No","No","Internal"]
[null,null,null,null,7710,"16/12/2019 8:08:16 PM","2019-12-15","Critical Equipment","Ship Staff","Ship Staff Insp.","DEAD MAN ALARM STOP BUTTON SWITCH IN THE E/R ENTRANCE BROKEN","Elect. Mach. & Equip.","Eng. / Strg. Comp.","Equipment Related","","","","","SWITCH NEEDS TO BE REPLACED OR REPAIRED","2019-12-20","","In progress",null,"No","No","No","Internal"]
[null,null,null,null,7711,"16/12/2019 8:15:05 PM","2019-12-16","Deficiency","Ship Staff","Ship Staff Insp.","FEW VALVE INDICATOR LIGHTS IN THE CCR PANEL NOT WORKING","Elect. Mach. & Equip.","Cargo / Ballast Systems","Equipment Related","","","","","INDICATOR LIGHTS TO BE REPLACED","2019-12-30","","Not Started",null,"No","No","No","Internal"]
[null,null,null,null,7712,"16/12/2019 8:18:00 PM","2019-12-16","Observation","Ship Staff","Ship Staff Insp.","LOTS OF BATHROOM TILES IN ACCOMMODATION CABINS CRACKED/BROKEN","Accommodation ","General Appearance","Behaviour Based","","","","","BROKEN TILES NEEDS TO BE REPLACED","2020-01-30","","Waiting spare",null,"No","No","No","Internal"]
[null,null,null,null,7713,"16/12/2019 8:30:13 PM","2019-12-16","Deficiency","Ship Staff","Ship Staff Insp.","HAWSE PIPE COVERS NOT GETTING PLACED ON THE HAWSE PIPES.","Mooring Mach.","Mooring","Behaviour Based,Equipment Related","","","","","COVERS NEEDS TO BE REPAIRED AND FIXED.","2020-01-01","","Not Started",null,"No","No","No","Internal"]
[null,null,null,null,null,"18/12/2019 2:22:41 PM","2019-12-17","Deficiency","Ship Staff","Ship Staff Insp.","ANGLE BAR ON THE CRADLE FOR LIFERAFT WHERE HRU IS SECURED FOUND RUSTED. ","LSA / FFA","LSA / FFA Appliances","Behaviour Based",null,null,"Not Applicable","Not Applicable","DE-RUST AND PAINT THE CRADLE","2020-01-15",null,"Not Started",null,"No",null,null,"Internal"]
[null,null,null,null,null,"18/12/2019 3:06:00 PM","2019-12-18","Deficiency","Ship Staff","Ship Staff Insp.","LEAK OBSERVED IN THE HYDRAULIC VRCS SYSTEM; PRESUMEBLY INSIDE BALLAST TANK. ","Deck Pipe / Fittings","Cargo / Ballast Systems","Equipment Related",null,null,"Not Applicable","Not Applicable","TO BE RECTIFIED DURING THE NEXT LADEN PASSAGE WHILE CARRYING OUT BALLAST TANK INSPECTION /// WILL BE ORDERING HYDRAULIC OIL FOR LOADING OPERATIONS.","2020-01-15",null,"Not Started",null,"No",null,null,"Internal"]
[null,null,null,null,null,"21/12/2019 2:16:33 PM","2019-12-19","Deficiency","Ship Staff","Ship Staff Insp.","INCINERATOR VARIOUS MECHANICAL AND ELECTRICAL PARTS  FOUND TO BE DEFECTIVE AND REMAINS INOPERATIONAL","Aux. Mach.","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","SPARES ORDERED ","2020-01-06",null,"Waiting spare",null,"No",null,null,"Internal"]
[null,null,null,null,null,"21/12/2019 2:23:01 PM","2019-12-19","Observation","Ship Staff","Ship Staff Insp.","16K/6K STEAM CONTROLLER VALVE AND PNEUMATIC CONTROLLER FOUND DEFECTIVE","Boiler","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","TO ORDER NEW CONTROLLER AND VALVE","2020-01-10",null,"Waiting spare",null,"No",null,null,"Internal"]
[null,null,null,null,null,"21/12/2019 2:29:45 PM","2019-12-19","Deficiency,Observation","Ship Staff","Ship Staff Insp.","IG FAN NO.1 IMPELLER BVLADES FOUND TO BE CRACKED\t","Inert Gas","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","IMPELLER TO RENEW. SPARE IMPELLER TO OFFLAND FOR REPAIRS AND BALANCING","2020-01-10",null,"Waiting spare",null,"No",null,null,"Internal"]
[null,null,null,null,null,"23/12/2019 8:47:47 AM","2019-12-20","Deficiency,Observation","Ship Staff","Ship Staff Insp.","REF. COMP NO.2  TO BE OVERHAULED ","Aux. Mach.","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","OVERHAUL TO BE CARRIED OUT / REPLACE WITH SPARE COMPRESSOR","2019-12-30",null,"Not Started",null,"No",null,null,"Internal"]
[null,null,null,null,null,"24/12/2019 5:29:23 PM","2019-12-23","Observation","Ship Staff","Ship Staff Insp.","BOILER WATER CIRCULATING PUMP NO.1 GLAND PACKING TO RENEW","Aux. Mach.","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","RENEW GLAND PACKING","2019-12-30",null,"Not Started",null,"No",null,null,"Internal"]

{"sheet":"Completed","index":1,"n_rows":32,"n_cols":28,"rows_kept":32,"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","18-11-2019",null,null,"Ship Name","EVAGORAS"]
[]
[]
[]
[]
[]
[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,7714,"16/12/2019 7:49:09 PM","2019-12-15","Deficiency","Ship Staff","Ship Staff Insp.","SEWAGE HOLDING TANK LEVEL GAUGE (FLEXIBLE PIPE) NEED TO BE CLEANED","Miscellaneous","Eng. / Strg. Comp.","Behaviour Based,Equipment Related","","","","","REPLACE WITH NEW FLEXIBLE PIPE/CLEAN THE FLEXIBLE TRANSPARENT PIPE","2019-12-22","","Completed","2019-12-15","No","No","No","Internal"]
[null,null,null,null,7715,"16/12/2019 3:11:03 PM","2019-12-14","Deficiency","Ship Staff","Ship Staff Insp.","CASCADE TANK FW FILLING VALVE FOUND BROKEN","ER Pipes, valves & fittings","Eng. / Strg. Comp.","Behaviour Based,Equipment Related","","","","","RECTIFIED / REPLACED WITH NEW VALVE","2019-12-20","","Completed","2019-12-16","No","No","No","Internal"]
[null,null,null,null,7716,"16/12/2019 7:52:47 PM","2019-12-15","Breakdown","Ship Staff","Ship Staff Insp.","INSTALLATION OF NEW LAUNDRY MACHINES WITH DRYER","Miscellaneous","Eng. / Strg. Comp.","Equipment Related","","","","","NEW MACHINES TO BE INSTALLED AND DAMAGED ONES TO BE REMOVED","2019-12-21","","Completed","2019-12-15","No","No","No","Internal"]
[null,null,null,null,7717,"16/12/2019 8:12:33 PM","2019-12-15","Deficiency","Ship Staff","Ship Staff Insp.","FWD HYDRAULIC MOTOR COOLER FILTER CLOGGED","Mooring Mach.","Mooring","Behaviour Based,Equipment Related","","","","","CLEANED THE FILTER AND OVERHAULED","2019-12-16","","Completed","2019-12-16","No","No","No","Internal"]
[null,null,null,null,null,"16/12/2019 3:27:41 PM","2019-12-14","Deficiency","Ship Staff","Ship Staff Insp.","STEERING GEAR COUPLING GREASE RENEWAL AND CLEARANCES TO BE TAKEN","Critical Equip.","Eng. / Strg. Comp.","Behaviour Based,Equipment Related",null,null,"Not Applicable","Not Applicable","GREASE NEEDS TO BE REPLACED","2019-12-28",null,"Completed","2019-12-16","No",null,null,"Internal"]
[null,null,null,null,null,"16/12/2019 8:04:46 PM","2019-12-15","Deficiency","Ship Staff","Ship Staff Insp.","ELEVATOR DOOR SWITCH TO BE ADJUSTED FOR UPPER DECK","Accommodation ","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","DOOR NEEDS TO BE ADJUSTED","2019-12-25",null,"Completed","2019-12-16","No",null,null,"Internal"]
[null,null,null,null,null,"21/12/2019 1:42:48 PM","2019-12-16","Observation","Ship Staff","Ship Staff Insp.","STERILIZER ROUTINES TO BE CARRIED OUT. FILTER NEEDS TO BE RENEWED","Aux. Mach.","Eng. / Strg. Comp.","Behaviour Based,Equipment Related",null,null,"Not Applicable","Not Applicable","FILTER RENEWED. LAMP FOUND TO BE WORKING SATISFACTORY","2019-12-20",null,"Completed","2019-12-16","No",null,null,"Internal"]
[null,null,null,null,null,"21/12/2019 1:57:24 PM","2019-12-16","Observation","Ship Staff","Ship Staff Insp.","MINERALIZER ROUTINES TO BE CARRIED OUT. DOLOMITE TO RENEW","Aux. Mach.","Eng. / Strg. Comp.","Behaviour Based,Equipment Related",null,null,"Not Applicable","Not Applicable","DOLOMITE TO RENEW AND MINERALIZER TO CLEAN","2019-12-20",null,"Completed","2019-12-16","No",null,null,"Internal"]
[null,null,null,null,null,"21/12/2019 2:02:56 PM","2019-12-17","Observation","Ship Staff","Ship Staff Insp.","SERVICE AIR COMPRESSOR SUMPOIL AND AIR FILTER TO RENEW","Aux. Mach.","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","SUMP OIL TO RENEW AND INSPECT. AIR FILTER TO CHANGE","2019-12-20",null,"Completed","2019-12-17","No",null,null,"Internal"]
[null,null,null,null,null,"21/12/2019 2:20:15 PM","2019-12-19","Observation","Ship Staff","Ship Staff Insp.","HFO BUNKER TANK NO.2 CLEANING","Hull & Tanks","Eng. / Strg. Comp.","Industry Issue",null,null,"Not Applicable","Not Applicable","BUNKER TANK TO BE CLEANED AND INSPECTED","2019-12-25",null,"Completed","2019-12-20","No",null,null,"Internal"]
[null,null,null,null,null,"16/12/2019 2:55:04 PM","2019-12-14","Deficiency","Ship Staff","Ship Staff Insp.","IG MAIN ISOLATION VAVLE SPINDLE KEEPS TURNING ON CLOSING/OPENING","Inert Gas","Cargo / Ballast Systems","Behaviour Based,Equipment Related",null,null,"Not Applicable","Not Applicable","GEARS CLEANED AND REPLACED WITH NEW GREASE.","2019-12-31",null,"Completed","2019-12-21","No",null,null,"Internal"]
[null,null,null,null,null,"16/12/2019 3:22:20 PM","2019-12-14","Deficiency","Ship Staff","Ship Staff Insp.","OIL LEAK IN PORT WINDLASS ENGAGING BLOCK VALVE LEVER SIDE","Deck Mach.","Eng. / Strg. Comp.","Behaviour Based,Equipment Related",null,null,"Not Applicable","Not Applicable","NEW SPARE LEVER BLOCK WAS INSTALLED, CHECKED AND TRIED OUT. NO LEAKS OBSERVED.","2019-12-30",null,"Completed","2019-12-20","No",null,null,"Internal"]
[null,null,null,null,null,"16/12/2019 7:37:37 PM","2019-12-14","Deficiency","Ship Staff","Ship Staff Insp.","SCRUBBER TOWER INSPECTION & NOZZLES TO BE CLEANED","Boiler","Eng. / Strg. Comp.","Behaviour Based,Equipment Related",null,null,"Not Applicable","Not Applicable","NO INSPECTION RECORDS AVAILABLE","2019-12-30",null,"Completed","2019-12-22","No",null,null,"Internal"]
[null,null,null,null,null,"24/12/2019 5:18:53 PM","2019-12-22","Deficiency,Observation","Ship Staff","Ship Staff Insp.","FUNNEL SOFT PATCHES TO REPAIR","Hull & Tanks","Eng. / Strg. Comp.","External Factors",null,null,"Not Applicable","Not Applicable","SOFT PATCHES TO BE SCRAPPED AND REPAIRED","2019-12-25",null,"Completed","2019-12-23","No",null,null,"Internal"]
[null,null,null,null,null,"2019-12-25T20:10:47","2019-12-24","Breakdown","Ship Staff","Ship Staff Insp.","REF COMP NO.1 DISCHARGE PIPELINE CRACKED","Aux. Mach.","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","DISCHARGE PIPE TO BE BRAZED","2019-12-25",null,"Completed","2019-12-25","No",null,null,"Internal"]

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

{"sheet":"Areaofobs","index":3,"n_rows":17,"n_cols":2,"rows_kept":17,"cut":false,"hidden":true,"merged":[]}
["TITLE","ID"]
["Cargo / Ballast Systems",11]
["Cert. & Docu.",2]
["Communication",6]
["Crew Management",3]
["Emgcy. Systems",13]
["Eng. / Strg. Comp.",14]
["General Appearance",15]
["Ice Opns.",17]
["LSA / FFA Appliances",8]
["MLC Related",4]
["Mooring",12]
["Navigation",5]
["MARPOL Related",9]
["ISM Related",7]
["ISPS Related",10]
["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":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":true,"merged":[]}
["TITLE","Type of deficiency_description","ID"]
["Breakdown",null,6]
["Condn of Class / Memo",null,5]
["Critical Equipment",null,4]
["Deficiency",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":21,"n_cols":3,"rows_kept":21,"cut":false,"hidden":true,"merged":[]}
["TITLE","Equipment_list_description","ID"]
["Accommodation ",null,12]
["Air Comp.",null,8]
["Aux. Engine",null,4]
["Aux. Mach.",null,7]
["Boiler",null,5]
["Cargo Mach.",null,13]
["Critical Equip.",null,16]
["Deck Mach.",null,18]
["Deck Pipe / Fittings",null,20]
["Documentation",null,21]
["Elect. Mach. & Equip.",null,10]
["Hull & Tanks",null,19]
["Inert Gas",null,14]
["LSA / FFA",null,17]
["Main Engine ",null,3]
["Miscellaneous",null,22]
["Nav & comm. equip.",null,11]
["ER Pipes, valves & fittings",null,9]
["Purifier",null,6]
["Mooring Mach.",null,15]

{"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":16,"n_cols":2,"rows_kept":16,"cut":false,"hidden":true,"merged":[]}
["TITLE","ID"]
["Bunkering Audit",14]
["Others (Eg. Insurance etc.)",12]
["Engineering Audit",16]
["Flag State Insp.",5]
["Ship Staff Insp.",15]
["IT Audit",10]
["OM Insp. (Eg. SIRE, CDI etc.)",6]
["ISM Audit",2]
["ISPS Audit",3]
["MLC Audit",1]
["Mooring Audit",9]
["Nav Audit / Verification",8]
["PSC Inspection",4]
["Suptd. Insp.",13]
["Terminal Insp.",11]

{"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":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":true,"merged":[]}
["TITLE","Observer_code_description","ID"]
["Class Surveyor",null,4]
["Others (Eg. Insurance etc.)",null,9]
["FSC Inspector",null,5]
["Owner / Marine / Tech. Suptd.",null,3]
["PSC Insp.",null,6]
["Ship Staff",null,2]
["SIRE / CDI Insp.",null,8]
["Terminal Insp.",null,7]

{"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"]
["102","EVAGORAS","102_1576639768677.xlsm"]