{"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":18,"n_cols":28,"rows_kept":18,"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","09-Nov-2019",null,null,"Ship Name","CHATTANOOGA"]
[]
[]
[]
[]
[]
[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,null,null,"2019-04-01","Deficiency","Ship Staff","Ship Staff Insp.","defective /corroded stanchion post","Miscellaneous","General Appearance","Equipment Related",null,null,"Not Applicable","Not Applicable","completed 60%","2019-11-15","chat190063","In progress",null,"No",null,null,"Internal"]

{"sheet":"Completed","index":1,"n_rows":88,"n_cols":714,"rows_kept":88,"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","9-10-2019",null,null,"Ship Name","CHATTANOOGA"]
[]
[]
[]
[]
[]
[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,null,"2019-09-11T19:39:45","2019-01-01","Observation","Ship Staff","Ship Staff Insp.","ICU LEAKAGE UNIT NO.1","Main Engine ","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","REPLACE NEW SPARE","2019-02-28","CHAT195004","Completed","2019-01-08","No",null,null,"Internal"]
[null,null,null,null,null,"2019-09-11T19:46:15","2019-01-14","Deficiency","Ship Staff","Ship Staff Insp.","LEAKING MECHANICAL SEAL OF BILGE,FIREPUMP & GEN.SERVICE PUMP NO.2","Aux. Mach.","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","REPLACE WITH NEW MECHANICAL SEAL SPARE","2019-01-16",null,"Completed","2019-01-15","No",null,null,"Internal"]
[null,null,null,null,null,"2019-09-11T19:52:31","2019-01-03","Deficiency","Ship Staff","Ship Staff Insp.","WO INCENERATOR TEMPERATURE SENSOR","Elect. Mach. & Equip.","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","REPLACE WITH NEW SPARE TEMP.SENSOR","2019-01-30","CHAT190007","Completed","2019-01-31","No",null,null,"Internal"]
[null,null,null,null,null,"2019-09-11T19:58:17","2019-01-09","Deficiency","Ship Staff","Ship Staff Insp.","LAUNDRY MACHINE DEFECTIVE","Elect. Mach. & Equip.","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","REPLACE WITH NEW SUPPLIED WACHING MACHINE","2019-01-20","CHAT190017","Completed","2019-01-31","No",null,null,"Internal"]
[null,null,null,null,null,"2019-09-11T20:07:28","2019-01-12","Deficiency","Ship Staff","Ship Staff Insp.","BROKEN DRIVE BELT OF GALLEY AIRCONDITION UNIT","Elect. Mach. & Equip.","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","RENEWED 2 PCS DRIVE BELT","2019-01-20","CHAT190020","Completed","2019-02-08","No",null,null,"Internal"]
[null,null,null,null,null,"2019-09-11T20:16:15","2019-01-12","Deficiency","Ship Staff","Ship Staff Insp.","CORRODED LIMIT SWITCHES OF MIDSHIP ACCOMODATION LADDER PORTSIDE","Elect. Mach. & Equip.","ISM Related","Equipment Related",null,null,"Not Applicable","Not Applicable","RENEWED LIMIT SWITCHES WITH SUPPLIED SPARE","2019-01-20","CHAT190019","Completed","2019-02-09","No",null,null,"Internal"]
[null,null,null,null,null,"2019-09-11T20:22:00","2019-01-31","Deficiency","Ship Staff","Ship Staff Insp.","UV STERILIZER QUARTZ TUBE LEAKING","Elect. Mach. & Equip.","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","REPLACED WITH NEW UV LAMP WIRE HARNESS QUARTZ JACKET O RING","2019-02-28","CHAT190037","Completed","2019-02-22","No",null,null,"Internal"]
[null,null,null,null,null,"2019-09-11T20:26:03","2019-01-16","Deficiency","Ship Staff","Ship Staff Insp.","ME OIL MIST EEPROM NEED TO REPLCED","Main Engine ","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","REPLCED WITH NEW EEPROM","2019-02-28","CHAT195006","Completed","2019-02-23","No",null,null,"Internal"]
[null,null,null,null,null,"2019-09-11T20:38:24","2019-01-31","Deficiency","Ship Staff","Ship Staff Insp.","ICU LEAKAGE ,UNIT NO.4","Main Engine ","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","REPLCED WITH NEW SUPPLIED SPARE","2019-02-28","CHAT195004","Completed","2019-02-26","No",null,null,"Internal"]
[null,null,null,null,null,"2019-09-11T20:43:31","2019-01-16","Deficiency","Ship Staff","Ship Staff Insp.","BROKEN LEVEL SWITCH OF AUX.NO.3 LUBOIL SUMP","Aux. Engine","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","REPLACED WITH NEW SUPPLIED  FLOAT SWITCH","2019-02-28","CHAT190021","Completed","2019-02-27","No",null,null,"Internal"]
[null,null,null,null,null,"2019-09-11T20:52:34","2019-01-22","Deficiency","Ship Staff","Ship Staff Insp.","WASHOUT AND MISSING FORWARD ANCHOR LIGHT","Nav & comm. equip.","Navigation","Equipment Related",null,null,"Not Applicable","Not Applicable","INSTALLD NEW SUPPLIED FORWARD ANCHOR LIGHT","2019-03-02","CHAT190033","Completed","2019-03-02","No",null,null,"Internal"]
[null,null,null,null,null,"2019-09-11T20:57:32","2019-01-25","Deficiency","Ship Staff","Ship Staff Insp.","BROKEN AND DEFECTIVE TEMP SWITCH OF HT FW COOLING A.E. NO.2","Aux. Engine","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","RENEWED WITH NEW SUPPLIED SPARE PART","2019-03-30","CHAT190034","Completed","2019-03-04","No",null,null,"Internal"]
[null,null,null,null,null,"2019-09-11T21:04:08","2019-03-04","Critical Equipment","Ship Staff","Ship Staff Insp.","RESCUE BOAT UNABLE TO SWING 115 DEG. FROM STOWED POSITION","LSA / FFA","LSA / FFA Appliances","Equipment Related",null,null,"Not Applicable","Not Applicable","CHECKED AND FOUND NOT ENOUGH PRESSURE . PUMP PRESSURE TO 190 MB. AND DEF.RECTIFIED","2019-03-30",null,"Completed","2019-03-04","No",null,null,"Internal"]
[null,null,null,null,null,"2019-09-11T21:09:28","2019-01-25","Deficiency","Ship Staff","Ship Staff Insp.","BROKEN AND DEFECTIVE TEMP SWITCH OF A.E. NO.1 HT FW COOLING.","Aux. Engine","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","RENEWED WITH SUPPLIED NEW SPARE","2019-03-30","CHAT190034","Completed","2019-03-07","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-11T00:59:30","2019-01-19","Deficiency","Ship Staff","Ship Staff Insp.","BROKEN AND DEFECTIVE TEMP. SWITCH OF A.E.NO.2 HT COOLING","Aux. Engine","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","RENEWED WITH SUPPLIED NEW SPARE","2019-03-30","CHAT190034","Completed","2019-03-11","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-11T01:03:34","2019-03-13","Critical Equipment","Ship Staff","Ship Staff Insp.","GENERAL FAULT IN LOOP 10 MAIN DECK","LSA / FFA","LSA / FFA Appliances","Equipment Related",null,null,"Not Applicable","Not Applicable","REPLACED DEFECTIVE MCP IN CO2 ROOM","2019-03-13",null,"Completed","2019-03-13","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-11T01:06:54","2019-03-13","Deficiency","Ship Staff","Ship Staff Insp.","ABNORMAL NOISE IN CIRCULATING PUMP NO.2","Elect. Mach. & Equip.","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","REPLACE NEW BEARINGS IN CURCULATING PUMP MOTOR","2019-03-13",null,"Completed","2019-03-13","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-11T01:11:15","2019-03-13","Deficiency","Ship Staff","Ship Staff Insp.","DAMAGE LIGHTING FIXTURE IN THE POOP DECK","Accommodation ","ISM Related","Equipment Related",null,null,"Not Applicable","Not Applicable","REPLACED WITH NEW SPARE","2019-03-30",null,"Completed","2019-03-15","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-11T01:15:37","2019-01-31","Deficiency","Ship Staff","Ship Staff Insp.","M.E. FUEL PUMP NO.1 LEAKAGE","Main Engine ","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","GRIND HIGH PRESSURE PIPE","2019-03-30","CHAT190011","Completed","2019-03-16","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-11T01:19:45","2019-03-25","Deficiency","Ship Staff","Ship Staff Insp.","FIRE ALARM GENRAL AND POWER SUPPLY FAULT","Accommodation ","Emgcy. Systems","Equipment Related",null,null,"Not Applicable","Not Applicable","CHANGE 9V BATTERY AND RESET THE WHOLE SYSTEM","2019-03-25",null,"Completed","2019-03-25","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-11T01:23:01","2019-03-25","Deficiency","Ship Staff","Ship Staff Insp.","DEFECTIVE TELEPHONE HANDSET OF INMARSAT ON BRIDGE","Accommodation ","Communication","Equipment Related",null,null,"Not Applicable","Not Applicable","RENEWED WITH SPARE","2019-03-25",null,"Completed","2019-03-25","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-11T01:27:41","2019-02-04","Deficiency","Ship Staff","Ship Staff Insp.","AUTO SERVO OIL BACKWASH FILTER LEAKING ON SHAFT.BACK FLUSHING AND PIVOTIC SOLENOID VALVE DEFECTIVE","Main Engine ","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","REPLACED O-RING AND SOLENOID VALVE","2019-05-30","CHAT190041","Completed","2019-03-25","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-11T01:32:03","2019-03-20","Deficiency","Ship Staff","Ship Staff Insp.","UNSYNC OF INMARSAT C NO.2","Nav & comm. equip.","Communication","Equipment Related",null,null,"Not Applicable","Not Applicable","REPAIRED BY SHORE TECHNICIAN","2019-03-30","CHAT195011","Completed","2019-03-26","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-11T01:35:23","2019-03-26","Deficiency","Ship Staff","Ship Staff Insp.","DEFECTIVE HANDSET OF VHF IN THE BRIDGE","Nav & comm. equip.","Communication","Equipment Related",null,null,"Not Applicable","Not Applicable","RENEWED WITH NEW SUPPLIED SPARE","2019-04-30","CHATCHAT190057","Completed","2019-04-02","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-11T01:39:20","2019-03-19","Deficiency","Ship Staff","Ship Staff Insp.","RESCUEBOAT HOISTING UP AND DOWN DELAY WHEN STOPPING","LSA / FFA","LSA / FFA Appliances","Equipment Related",null,null,"Not Applicable","Not Applicable","RENEWED BREAK LINING","2019-04-30",null,"Completed","2019-04-22","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-11T01:44:41","2019-01-31","Deficiency","Ship Staff","Ship Staff Insp.","MAIN VALVE AIR BOTTLE OUTLET PASSING","ER Pipes, valves & fittings","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","THOROUGH CHECKED BOTH MAIN VALVE NO PASSING THE LEAKAGE IS RECTIFIED","2019-04-30",null,"Completed","2019-04-30","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-11T01:47:58","2019-04-03","Deficiency","Ship Staff","Ship Staff Insp.","DEFECTIVE BATTERY OF ALDIS LAMP","Nav & comm. equip.","Navigation","Equipment Related",null,null,"Not Applicable","Not Applicable","REPLACED WITH NEW SUPPLIED BATTERY","2019-05-30","CHAT190064","Completed","2019-05-01","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-11T01:58:18","2019-01-31","Deficiency","Ship Staff","Ship Staff Insp.","PROV.REF.PLANT CONDENSER NO.2 SUSPECTED LEAKING","Accommodation ","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","REPLACED WITH NEW SUPPLIED SPARE","2019-05-30","CHAT190036","Completed","2019-05-02","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-11T02:01:22","2019-04-05","Deficiency","Ship Staff","Ship Staff Insp.","BATTERY FAULT ON LOCAL WATER MIST SYATEM","Critical Equip.","Emgcy. Systems","Equipment Related",null,null,"Not Applicable","Not Applicable","REPLACED WITH NEW SUPPLIED BATTERY","2019-05-30","CHAT190070","Completed","2019-05-02","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-11T02:04:35","2019-04-22","Deficiency","Ship Staff","Ship Staff Insp.","INACCURATE READING OF ANEMOMETER","Nav & comm. equip.","Navigation","Equipment Related",null,null,"Not Applicable","Not Applicable","INSTALLED NEW SUPPLIED ANENOMETER","2019-05-30","CHAT195013","Completed","2019-05-09","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-11T02:08:09","2019-04-05","Deficiency","Ship Staff","Ship Staff Insp.","DEFECTIVE REFRIGERATOR IN THE HOSPITAL","Elect. Mach. & Equip.","ISM Related","Equipment Related",null,null,"Not Applicable","Not Applicable","INSTALLED NEW SUPPLIED REF.","2019-05-30","CHAT190069","Completed","2019-05-22","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-11T02:12:11","2019-04-14","Deficiency","Ship Staff","Ship Staff Insp.","DEFECTIVE FO PURIFIER NO.1,BURNT BEARINGS,BROKEN NECK BEARING COVER AND LUBRICATION OIL ORIFICE","Aux. Mach.","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","REPLACE WITH NEW SUPPLIED SPARE","2019-05-30","CHAT190081","Completed","2019-05-22","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-11T02:15:07","2019-04-08","Deficiency","Ship Staff","Ship Staff Insp.","WECS POWER SUPPLY FAIL","Elect. Mach. & Equip.","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","REPLACED POWER SUPPLY WITH SUPPLIED SPARE","2019-05-30","CHAT190075","Completed","2019-05-24","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-11T02:19:25","2019-04-01","Deficiency","Ship Staff","Ship Staff Insp.","DEFECTIVE 24V SEALED LAMP ON FORWARD STBD EMBARKATION LADDER","Elect. Mach. & Equip.","Emgcy. Systems","Equipment Related",null,null,"Not Applicable","Not Applicable","REPLACED WITH NEW SUPPLIED SEALED LAMP","2019-05-30","CHAT190052","Completed","2019-05-24","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-11T02:22:25","2019-04-30","Deficiency","Ship Staff","Ship Staff Insp.","FILLING VALVE OF MAIN AIR BOTTLE PASSING","ER Pipes, valves & fittings","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","GRINDED","2019-05-30",null,"Completed","2019-05-30","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-11T02:25:49","2019-06-03","Deficiency","Ship Staff","Ship Staff Insp.","ABNORMAL NOISE ON DC FAN BLOWER OF MARINE RADAR PROCESSOR UNIT","Nav & comm. equip.","Navigation","Equipment Related",null,null,"Not Applicable","Not Applicable","REPLACED WITH NEW SUPPLIED DC FAN BLOWER","2019-06-30","CHAT190101","Completed","2019-06-10","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-11T02:28:55","2019-03-19","Deficiency","Ship Staff","Ship Staff Insp.","DEFECTIVE SALINITY SENSOR","Aux. Mach.","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","REPLACED WITH NEW SUPPLIED SALINITY SENSOR","2019-06-30","CHAT190056","Completed","2019-06-12","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-11T02:34:17","2019-03-29","Deficiency","Ship Staff","Ship Staff Insp.","DEFECTIVE 220VAC SOCKETS ON MAIN DECK","Elect. Mach. & Equip.","ISM Related","Equipment Related",null,null,"Not Applicable","Not Applicable","REPLACED WITH NEW SUPPLIED SOCKETS,FUSES AND LAMP INDICATORS","2019-06-30","CHAT190059","Completed","2019-06-17","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-11T02:38:00","2019-05-30","Deficiency","Ship Staff","Ship Staff Insp.","DEFECTIVE IN LCD DISPLAY OF ACP IN BRIDGE","Nav & comm. equip.","Navigation","Equipment Related",null,null,"Not Applicable","Not Applicable","RENEWED WITH NEW SUPPLIED LSCD DISPLAY","2019-06-30","CHAT195025","Completed","2019-06-23","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-11T02:41:00","2019-06-27","Deficiency","Ship Staff","Ship Staff Insp.","DEFECTIVE BRDIGE WINDOW WIPER","Nav & comm. equip.","Navigation","Equipment Related",null,null,"Not Applicable","Not Applicable","RECTIFIED","2019-07-31",null,"Completed","2019-06-28","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-11T02:43:41","2019-06-30","Deficiency","Ship Staff","Ship Staff Insp.","LOW INSULATION OF AHU MOTOR","Elect. Mach. & Equip.","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","RE-INSULATE AHU MOTOIR","2019-06-30",null,"Completed","2019-06-30","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-11T02:47:50","2019-05-10","Deficiency","Ship Staff","Ship Staff Insp.","PMS ALARM IN AMS HAS INVALID DATA.ALL PMS ALARMS ARE NOT OPERATIONAL","Elect. Mach. & Equip.","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","KONSBERG SERVICE ASSISTANCE","2019-06-30","CHAT190117","Completed","2019-07-08","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-11T02:51:10","2019-06-29","Deficiency","Ship Staff","Ship Staff Insp.","DEFECTIVE CONTACTOR AND OVERLOAD RELAY OF AHU FAN","Elect. Mach. & Equip.","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","REPLACED WITH NEW SUPPLIED CONTACTOR AND OVERLOAD RELAY","2019-07-31","CHAT190122","Completed","2019-07-15","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-11T02:54:38","2019-06-24","Deficiency","Ship Staff","Ship Staff Insp.","DAMAGE LIMIT SWITCH OF PROVISION CRANE","Deck Mach.","ISM Related","Equipment Related",null,null,"Not Applicable","Not Applicable","REPLACED WITH NEW SUPPLIED SPARE","2019-07-31","CHAT190114","Completed","2019-07-15","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-11T02:58:10","2019-07-10","Deficiency","Ship Staff","Ship Staff Insp.","PROVISION CHAMBER-ICE ACCUMULATION IN THE MEAT ROOM FLOORING","Miscellaneous","ISM Related","Equipment Related",null,null,"Not Applicable","Not Applicable","INSTALLED VALVE IN THE DRAIN PIPE","2019-07-31",null,"Completed","2019-07-31","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-11T03:01:16","2019-06-27","Breakdown","Ship Staff","Ship Staff Insp.","DEFCTIVE WASHING MACHINE","Elect. Mach. & Equip.","ISM Related","Equipment Related",null,null,"Not Applicable","Not Applicable","RENEWED WITH NEW SUPPLIED WASHING MACHINE","2019-07-31","CHAT190118","Completed","2019-07-31","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-11T03:04:37","2019-06-24","Deficiency","Ship Staff","Ship Staff Insp.","DAMAGE LIMIT SWITCH OF RESCUEBOAT","Elect. Mach. & Equip.","LSA / FFA Appliances","Equipment Related",null,null,"Not Applicable","Not Applicable","REPLACE WITH NEW SUPPLIED LIMIT SWICTH","2019-07-31","CHAT190114","Completed","2019-08-08","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-11T03:07:25","2019-08-08","Breakdown","Ship Staff","Ship Staff Insp.","PROVISION COMPRESSOR NO.1 BREAKDOWN","Elect. Mach. & Equip.","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","OVERHAULED","2019-08-08",null,"Completed","2019-08-09","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-11T03:12:37","2019-06-27","Deficiency","Ship Staff","Ship Staff Insp.","DEFECTIVE SWITCH OF BOILER BURNER OPERATION.BURNER MOTOR PURGING NOT WORKING","Boiler","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","REPLACE WITH NEW SWITCH OF CONTROL PANEL.TEMPORARY BRIDGE BURNER MOTOR","2019-08-31","CHAT190119","Completed","2019-08-04","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-11T04:15:46","2019-08-13","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","2p cARGO TANK HIGH LEVEL ALARM STUCK IN ALARM POSITION SAME TO BE REMOVED AND FREED","Deck Pipe / Fittings","Cargo / Ballast Systems","Equipment Related",null,null,"Not Applicable","Not Applicable","REMOVED ,CLEANED,REINSTALLED AND TESTED IN WORKING CONDITION","2019-08-18",null,"Completed","2019-08-16","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-11T04:18:46","2019-08-15","Deficiency","Ship Staff","Ship Staff Insp.","ANENOMETER NOT SHOWING RELATIVE SPEED","Nav & comm. equip.","Navigation","Equipment Related",null,null,"Not Applicable","Not Applicable","ETO FOUND LOOSE CONNECTION","2019-08-20",null,"Completed","2019-08-17","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-11T04:22:25","2019-08-16","Deficiency","Ship Staff","Ship Staff Insp.","BRIDGE WINDOW WIPER FRON RIGHT SIDE NOT WORKING","Nav & comm. equip.","Navigation","Equipment Related",null,null,"Not Applicable","Not Applicable","RENEWED WITH NEW SPARE","2019-08-20",null,"Completed","2019-08-17","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-11T04:26:30","2019-08-17","Deficiency","Ship Staff","Ship Staff Insp.","rUDDER INDICATOR AT WING P/S AND WING CONSOLE P/S ARE NOT SYNCHRONISED WITH MAIN CONSOLE RUDDER INDICATOR","Nav & comm. equip.","Navigation","Equipment Related",null,null,"Not Applicable","Not Applicable","ETO CHECKED AND ADJUSTED","2019-08-20",null,"Completed","2019-08-18","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-11T04:31:32","2019-08-13","Deficiency","Ship Staff","Ship Staff Insp.","ONE PANEL OF BRIDGE WINDOW WIPER STBD FRONT NOT WORKING","Nav & comm. equip.","Navigation","Equipment Related",null,null,"Not Applicable","Not Applicable","ETO REPAIRED","2019-08-31",null,"Completed","2019-08-16","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-11T04:35:19","2019-08-13","Deficiency","Ship Staff","Ship Staff Insp.","SOME EMERG.LIGHT IN PASSAGE WAY AND RESCUE BOAT ARE NOT WORKING","Elect. Mach. & Equip.","Emgcy. Systems","Equipment Related",null,null,"Not Applicable","Not Applicable","ETO CHANGE BUSTED BULB AND RECTIFIED ","2019-08-17",null,"Completed","2019-08-17","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-11T04:38:12","2019-01-31","Deficiency","Ship Staff","Ship Staff Insp.","M.E. ICU LEAKAGE IN UNIT NO.2","Main Engine ","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","REPLACED WITH NEW SUPPLIED SPARE","2019-07-31","CHAT195004","Completed","2019-08-09","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-11T04:42:49","2019-01-10","Deficiency","Ship Staff","Ship Staff Insp.","NO.4B(P) DWBT TK SENSOR FAULTY","Elect. Mach. & Equip.","Cargo / Ballast Systems","Equipment Related",null,null,"Not Applicable","Not Applicable","REPLACED WITH NEW SUPPLIED SPARE","2019-07-31","CHAT190040","Completed","2019-08-24","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-11T04:45:21","2019-01-10","Deficiency","Ship Staff","Ship Staff Insp.","NO.4A(P) SWBT SENSOR FAULTY","Elect. Mach. & Equip.","Cargo / Ballast Systems","Equipment Related",null,null,"Not Applicable","Not Applicable","REPLCED WITH NEW SUPPLIED SPARE","2019-07-31","CHAT1900040","Completed","2019-08-24","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-11T04:47:54","2019-01-10","Deficiency","Ship Staff","Ship Staff Insp.","NO.4B(P) SWBT SENSOR FAULTY","Elect. Mach. & Equip.","Cargo / Ballast Systems","Equipment Related",null,null,"Not Applicable","Not Applicable","REPLACED WITH NEW SUPPLIED SPARE","2019-07-31","CHAT190040","Completed","2019-08-24","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-11T04:52:00","2019-01-31","Deficiency","Ship Staff","Ship Staff Insp.","HFO NO.1 OVERFLOW TK FAULTY LEVEL SENSOR","Elect. Mach. & Equip.","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","REPLACED WITH NEW SUPPLIED SPARE","2019-07-31","CHAT190040","Completed","2019-08-24","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-11T04:57:07","2019-03-28","Deficiency","Ship Staff","Ship Staff Insp.","LOW INSULATIONON NO.1 REEFER POWER SOCKETS IN IRP7 AND IRP8","Elect. Mach. & Equip.","ISM Related","Equipment Related",null,null,"Not Applicable","Not Applicable","RENEWED DEFECTIVE SOCKETS,CIRCUIT BREAKER, AND TERMINAL BLOCKS SOCKETS","2019-07-31","CHAT190065","Completed","2019-08-22","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-11T05:00:46","2019-03-28","Deficiency","Ship Staff","Ship Staff Insp.","LOW INSULATION ON NO.3 REEFER POWER SOCKETS","Elect. Mach. & Equip.","ISM Related","Equipment Related",null,null,"Not Applicable","Not Applicable","RENEWED DEFECTIVE SOCKETS,CIRCUIT BREAKER AND TERMINAL BLOCKS SOCKET","2019-07-31","CHAT190065","Completed","2019-08-22","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-11T05:05:26","2019-08-16","Breakdown","Ship Staff","Ship Staff Insp.","ELECTROTYPHONE MOTOR BREAKDOWN","Nav & comm. equip.","Navigation","Equipment Related",null,null,"Not Applicable","Not Applicable","RENEWED WITH SUPPLIED MOTOR","2019-08-31","CHAT190144","Completed","2019-08-28","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-11T05:08:39","2019-08-13","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","NO.2 FEED WATER PUMP DISCHARGE PRESSURE GUAGE FAULTY","ER Pipes, valves & fittings","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","DECLOGGED AND CLEANED","2019-08-23",null,"Completed","2019-08-14","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-11T05:13:27","2019-08-13","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","ME SUMP TK & DRAIN TK SOUNDING PIPE OPENING LEVER STUCK .SAME TO FREED","ER Pipes, valves & fittings","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","REPAIRED OPENING LEVER","2019-08-23",null,"Completed","2019-08-14","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-11T05:16:34","2019-08-13","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","ME VISCOTHERM HAS AN ERROR,SENSOR TO BE TAKEN OUT AND CLEANED","Aux. Mach.","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","CHECKED AND CLEANED","2019-08-16",null,"Completed","2019-08-15","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-11T05:29:05","2019-08-13","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","BUNKER CHECKLIST 12.04.744.01 WAS NOT FILLED FOR LAST BUNKER OPERATION","Miscellaneous","Cert. & Docu.","Behaviour Based",null,null,"Not Applicable","Not Applicable","FILLED UP","2019-08-14",null,"Completed","2019-08-14","No",null,null,"Internal",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-08-13",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Observation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Owner / Marine / Tech. Suptd.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Suptd. Insp.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BUNKER CHECKLIST 12.04.744.01 WAS NOT FILLED FOR LAST BUNKER OPERATION",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Documentation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cert. & Docu.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Human Error",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Not Applicable",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Not Applicable",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FILLED UP",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-08-14",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Completed",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-08-14",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Internal"]
[null,null,null,null,null,"2019-10-11T05:33:07","2019-08-13","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","ENGINE CONTROL BOOK NOT FILLED ALL EVENTS AS PER REQUIREMENTS IN THE INITIAL PAGE.","Documentation","Cert. & Docu.","Behaviour Based",null,null,"Not Applicable","Not Applicable","FILLED UP","2019-08-15",null,"Completed","2019-08-15","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-11T05:39:42","2019-08-13","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","LOGBOOK WAS FILLED ONLY ONCE AND MANY PARAMETERS WERE LEFT BLANK","Documentation","Cert. & Docu.","Human Error",null,null,"Not Applicable","Not Applicable","FILLED UP","2019-08-15",null,"Completed","2019-08-15","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-11T05:44:29","2019-08-13","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","ORB ENTRIES ON TANDOM CHECKED FOR INCENERATOR TANK NOT MATCHING AS EVAPORATION WAS NOT SHOWN.ALSO ONLY C/E WAS SIGNING ALL ENTRIES,DUTY ENGINEER WAS SIGNING ANY ENTRIES","Documentation","Cert. & Docu.","Human Error",null,null,"Not Applicable","Not Applicable","ORB CORRECTED AND DUTY ENGINEER SIGNED","2019-08-15",null,"Completed","2019-08-15","No",null,null,"Internal"]
[null,null,null,null,null,"2019-10-11T13:16:53","2019-04-01","Deficiency","Ship Staff","Ship Staff Insp.","defective/corroded stanchion post","Miscellaneous","General Appearance","Equipment Related",null,null,"Not Applicable","Not Applicable","new 22 pcs stnachion post installed in various cross deck.13 pcs are under fabrocation.60% completed","2019-11-15","chat190063","In progress",null,"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":1,"n_cols":3,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["VIQ_ref_no","Risk Value of observation","ID"]

{"sheet":"Equipment_list","index":7,"n_rows":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"]
["95","CHATTANOOGA","95_1573291842562.xlsm"]