{"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":37,"n_cols":28,"rows_kept":37,"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","22-Nov-2020",null,null,"Ship Name","ANTWERP"]
[]
[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,14665,"107_Mon Nov 16 2020 10:54:32 GMT+0000","2020-01-12","Observation","Ship Staff","Ship Staff Insp.","Four (4) nos of valves  are not working from the Ballast control panel.","Deck - Pipe / Fittings","Cargo / Ballast Systems","Equipment Related",null,null,"Not Applicable","Not Applicable","the valves renew by dry dock","2020-12-31",null,"Not Started",null,"Yes","No","No","Internal","Pls do check and find the  cause ."]
[null,null,null,null,14673,"107_Mon Nov 16 2020 11:11:18 GMT+0000","2020-01-12","Observation","Ship Staff","Ship Staff Insp.","Port side windlass brake lining not good condition, required renewal","Deck - Mooring Machinery","General Appearance","Equipment Related",null,null,"Not Applicable","Not Applicable","REPLACE BY D-D","2020-12-30","ANTW200013","Deferred to D D",null,"Yes","No","No","Internal","Pls submit requisition for brake lining based on the spare stock onboard."]
[null,null,null,null,14674,"107_Mon Nov 16 2020 11:12:57 GMT+0000","2020-07-12","Defect,Observation","Ship Staff","Ship Staff Insp.","Three (3) mooring winches brake linings are not good, required renewal","Deck - Mooring Machinery","Mooring","Equipment Related",null,null,"Not Applicable","Not Applicable","Action required","2020-12-30",null,"In progress",null,"No","No","No","Internal"]
[null,null,null,null,14666,"107_Mon Nov 16 2020 10:56:19 GMT+0000","2020-11-16","Observation","Ship Staff","Ship Staff Insp.","Main engine Alpha lub station pump no.1 pipe connection leaking","E/R - Pipes/ valves & fittings","Eng. / Strg. Comp.","Equipment Related","","","","","Action required","2020-11-30","","Not Started",null,"No","No","No","Internal","Pls  do rectify as soon as possible."]
[null,null,null,null,14667,"107_Mon Nov 16 2020 10:58:32 GMT+0000","2020-11-16","Defect","Ship Staff","Ship Staff Insp.","Main engine Total  running hrs 98251.3  which recorded manually and  M/E tachometer is  not working.","Elect. Mach. & Equip.","Eng. / Strg. Comp.","Equipment Related","","","","","Action required","2020-12-31","","Waiting spare",null,"No","No","No","Internal","PLs submit requisition if not yet submitted."]
[null,null,null,null,14669,"107_Mon Nov 16 2020 11:02:47 GMT+0000","2020-11-16","Defect","Ship Staff","Ship Staff Insp.","Aux engine no.1 & 2 Rhrs  tachometers are  not working","E/R - Aux. Engine,E/R - Pipes/ valves & fittings","Eng. / Strg. Comp.","Equipment Related","","","","","Action required","2020-12-31","","Waiting spare",null,"No","No","No","Internal"]
[null,null,null,null,14670,"107_Mon Nov 16 2020 11:04:36 GMT+0000","2020-11-16","Defect","Ship Staff","Ship Staff Insp.","Steering gear no. 1& 2 hyd pump oil seal  found leaking excessively","E/R - Aux. Mach.","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Shore service engineers on board for repair @ Sgp 2020-11-27~30","2020-12-31","ANTW205043","Not Started",null,"No","No","No","Internal","Pls submit requisition for spare parts"]
[null,null,null,null,14671,"107_Mon Nov 16 2020 11:06:02 GMT+0000","2020-11-16","Defect","Ship Staff","Ship Staff Insp.","No.1 HFO purifier temp control valve malfunctioning","E/R - Purifier","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","\"UMS\" personals come on board for check & adjust. After sailing, found problem continuous.","2020-12-15",null,"Not Started",null,"No","No","No","Internal","Pls do check cause of malfunction and order  necessary spare if required"]
[null,null,null,null,14672,"107_Mon Nov 16 2020 11:07:50 GMT+0000","2020-11-16","Defect","Ship Staff","Ship Staff Insp.","Hatch cover no.3  & 8  hydraulic motor  oil leaking","Cargo Mach.","Cargo / Ballast Systems","Equipment Related",null,null,"Not Applicable","Not Applicable","No any hyd.motor leaking. The workshop personals who welding the pipes of OWS that they bring 3pcs hyd.pipes only.","2020-12-30","ANTW205044","Not Started",null,"No","No","No","Internal","Pls  do check and submit requisition of necessary spare parts to overhaul the hydraulic motor."]
[null,null,null,null,14675,"107_Mon Nov 16 2020 11:14:20 GMT+0000","2020-11-16","Defect","Ship Staff","Ship Staff Insp.","Hatch covers hydraulic pipes corroded and leaking in various locations, required renewal and press test","Deck - Pipe / Fittings","Cargo / Ballast Systems","Equipment Related",null,null,"Not Applicable","Not Applicable","Some pipe renewed by crew already.","2020-12-30",null,"Not Started",null,"No","No","No","Internal","Pls  submit RO of the  required pipes & fittings"]
[null,null,null,null,14676,"107_Mon Nov 16 2020 11:15:46 GMT+0000","2020-11-16","Defect","Ship Staff","Ship Staff Insp.","ME Lub oil purifier supply pump  are  not working","E/R - Pumps","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Will raised the spare requisition soon.","2020-12-23",null,"Not Started",null,"No","No","No","Internal","Pls do check and plan to overhaul pump if required."]
[null,null,null,null,14677,"107_Mon Nov 16 2020 11:18:05 GMT+0000","2020-11-16","Defect","Ship Staff","Ship Staff Insp.","M/E lube oil stand by  pump  found starting auto but no alert alarm activated in ECR panel","Elect. Mach. & Equip.","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","\"cyclect\" engineers on board for check, test, later supplied 3+7pcs contactor & renewed by crew. Test & found normal, but found some problem after sail again.","2020-12-15","ANWT205042, 205054.","Not Started",null,"No","No","No","Internal","Pls do check and troubleshooting"]
[null,null,null,null,14678,"107_Mon Nov 16 2020 11:19:28 GMT+0000","2020-11-16","Defect","Ship Staff","Ship Staff Insp.","M/E JCFW  stand by  pump  found starting auto but no alert alarm activated in ECR panel","E/R - Pumps","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Same than ME LO pump","2020-12-15","ANWT205042, 205054","Not Started",null,"No","No","No","Internal","Pls do check and troubleshooting"]
[null,null,null,null,14679,"107_Mon Nov 16 2020 11:20:54 GMT+0000","2020-11-16","Defect,Observation","Ship Staff","Ship Staff Insp.","Provision crane hydraulic piping  condition not good, required renewal","Deck - Machinery","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Renewed many soft hose by workshop personal & some can't renewed due to old connector welding by previous crew. these hose stay on board for spare.","2020-12-15","ANTW205043","Not Started",null,"No","No","No","Internal","Pls renew if spare pipe available or submit requisition."]
[null,null,null,null,14680,"107_Mon Nov 16 2020 11:22:28 GMT+0000","2020-11-16","Defect","Ship Staff","Ship Staff Insp.","Hypermist HP pump press gauge  is not working","Miscellaneous","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Will raised spare soon.","2020-12-23",null,"Not Started",null,"No","No","No","Internal","Pls order new press gauge if not available onboard."]
[null,null,null,null,14681,"107_Mon Nov 16 2020 11:24:05 GMT+0000","2020-11-16","Other","Ship Staff","Ship Staff Insp.","There was no ODS & Suphur content record book found on board","Documentation","Cert. & Docu.","Equipment Related",null,null,"Not Applicable","Not Applicable","SI bring 2books - Bunker sample & SECA FCO record book on board 20-Nov-2020 ( Incluclinding S%). Re ODS office have standard \"word\" file.","2020-12-16",null,"Not Started",null,"No","No","No","Internal"]
[null,null,null,null,14682,"107_Mon Nov 16 2020 11:25:29 GMT+0000","2020-11-16","Defect","Ship Staff","Ship Staff Insp.","Aux boiler feed water automatic  control valve  not working","E/R - Pipes/ valves & fittings","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Crew adjusted already. Service on board when call SIN 27-Nov also.","2020-12-16","ANTW205033","Not Started",null,"No","No","No","Internal","Pls check and submit requisition of necessary spare parts"]
[null,null,null,null,14683,"107_Mon Nov 16 2020 11:26:38 GMT+0000","2020-11-16","Defect","Ship Staff","Ship Staff Insp.","A/E & M/E FO  back wash  filters are  leaking thru the gland","E/R - Pipes/ valves & fittings","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Will raised spare soon.","2020-12-15",null,"Not Started",null,"No","No","No","Internal",""]
[null,null,null,null,14684,"107_Mon Nov 16 2020 11:28:17 GMT+0000","2020-11-16","Defect","Ship Staff","Ship Staff Insp.","Many pumps in ER   auto exchange function  are out of order. Testing in progress","Elect. Mach. & Equip.","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Detail same as MELO pump etc.","2020-12-23",null,"Not Started",null,"No","No","No","Internal","Pls do test all pumps and make require R.O."]
[null,null,null,null,null,"107_7/12/2020 9:10:02 PM","2020-12-03","Defect","Ship Staff","Ship Staff Insp.","Steam pipe connected to EGE soot blowier damaged & broken","E/R - Pipes/ valves & fittings","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Will renewed pipe by crew when ME stopped.","2021-01-05",null,"Not Started",null,"No",null,null,"Internal"]

{"sheet":"Completed","index":1,"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","22-Nov-2020",null,null,"Ship Name","ANTWERP"]
[]
[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,null,"107_Mon Nov 16 2020 10:52:14 GMT+0000","2020-01-12","Observation","Ship Staff","Ship Staff Insp.","VDR display shows radar alert alarm sometimes.","Navigation - VDR / BNWAS","Communication","Equipment Related",null,null,"Not Applicable","Not Applicable","already completed ","2020-12-15",null,"Completed","2020-01-12","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]
["ISM Related",7]
["ISPS Related",10]
["MARPOL Related",9]
["MLC Related",4]
["Mooring",12]
["Navigation",5]
["Safety / LSA / FFA",8]
["Structural Condn. / WT integrity ",16]

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

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

{"sheet":"VIQrefno","index":6,"n_rows":1,"n_cols":3,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["VIQ_ref_no","Risk Value of observation","ID"]

{"sheet":"Equipment_list","index":7,"n_rows":28,"n_cols":3,"rows_kept":28,"cut":false,"hidden":true,"merged":[]}
["TITLE","Equipment_list_description","ID"]
["Accommodation",null,12]
["Cargo Mach.",null,13]
["Critical Equip.",null,16]
["Deck - Machinery",null,18]
["Deck - Mooring Machinery",null,15]
["Deck - Pipe / Fittings",null,20]
["Documentation",null,21]
["E/R - Air Comp.",null,8]
["E/R - Aux. Engine",null,4]
["E/R - Aux. Mach.",null,7]
["E/R - Boiler",null,5]
["E/R - Main Engine",null,3]
["E/R - Pipes/ valves & fittings",null,9]
["E/R - Pumps",null,32]
["E/R - Purifier",null,6]
["Elect. Mach. & Equip.",null,10]
["Hull & Tanks",null,19]
["Inert Gas",null,14]
["LSA / FFA",null,17]
["Miscellaneous",null,22]
["Navigation - DGPS / EPFS / AIS",null,28]
["Navigation - ECDIS",null,25]
["Navigation - Echo Sounder / Speed Log",null,26]
["Navigation - GMDSS & Communication",null,23]
["Navigation - Others",null,11]
["Navigation - RADAR",null,24]
["Navigation - VDR / BNWAS",null,30]

{"sheet":"PSC_MOU","index":8,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
["TITLE","PSC_MOU_description","ID"]
["Asia and the Pacific",null,2]
["Caribbean",null,4]
["Europe and the North Atlantic",null,1]
["Latin America",null,3]
["The Black Sea region",null,6]
["The Indian Ocean",null,8]
["The Mediterranean",null,7]
["The Riyadh MoU",null,9]
["USCG",null,10]
["West and Central Africa",null,5]

{"sheet":"Inspection_type","index":9,"n_rows":13,"n_cols":2,"rows_kept":13,"cut":false,"hidden":true,"merged":[]}
["TITLE","ID"]
["Bunkering Audit",14]
["Cargo Audit",17]
["Engineering Audit",16]
["ISM Audit",2]
["ISPS Audit",3]
["IT Audit",10]
["MLC Audit",1]
["Mooring Audit",9]
["Nav Audit / Verification",8]
["Onboard Training",18]
["Ship Staff Insp.",15]
["Suptd. Insp.",13]

{"sheet":"Deficiency_Cause","index":10,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
["TITLE","Deficiency_Cause_description","ID"]
["Behaviour Based",null,1]
["Equipment Related",null,4]
["External Factors",null,5]
["Human Error",null,7]
["Inappropriate Procedure",null,8]
["Industry Issue",null,6]
["Knowledge Based",null,3]

{"sheet":"Observer_code","index":11,"n_rows":3,"n_cols":3,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
["TITLE","Observer_code_description","ID"]
["Owner / Marine / Tech. Suptd.",null,3]
["Ship Staff",null,2]

{"sheet":"Status_code","index":12,"n_rows":6,"n_cols":3,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
["TITLE","Status_code_description","ID"]
["Completed",null,6]
["Deferred to D D",null,5]
["In progress",null,3]
["Not Started",null,2]
["Waiting spare",null,4]

{"sheet":"PSC_ref_no","index":13,"n_rows":19,"n_cols":2,"rows_kept":19,"cut":false,"hidden":true,"merged":[]}
["TITLE","ID"]
["Alarms",9]
["Cargo operations including equipment",7]
["Certificates & Documentation",2]
["Dangerous Goods",13]
["Emergency Systems",5]
["Fire safety",8]
["ISM",16]
["ISPS",17]
["Life saving appliances",12]
["MLC, 2006",18]
["Other",19]
["Pollution Prevention",15]
["Propulsion and auxiliary machinery",14]
["Radio communication",6]
["Safety of Navigation",11]
["Structural condition",3]
["Water/Weathertight condition",4]
["Working and Living Conditions",10]

{"sheet":"Risk_value_of_obs","index":14,"n_rows":1,"n_cols":2,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["Risk Value of observation","ID"]

{"sheet":"Year","index":15,"n_rows":18,"n_cols":1,"rows_kept":18,"cut":false,"hidden":true,"merged":[]}
["Year"]
[2014]
[2015]
[2016]
[2017]
[2018]
[2019]
[2020]
[2021]
[2022]
[2023]
[2024]
[2025]
[2026]
[2027]
[2028]
[2029]
[2030]

{"sheet":"Month","index":16,"n_rows":13,"n_cols":1,"rows_kept":13,"cut":false,"hidden":true,"merged":[]}
["Month"]
["Jan"]
["Feb"]
["Mar"]
["Apr"]
["May"]
["Jun"]
["Jul"]
["Aug"]
["Sep"]
["Oct"]
["Nov"]
["Dec"]

{"sheet":"Date_","index":17,"n_rows":32,"n_cols":1,"rows_kept":32,"cut":false,"hidden":true,"merged":[]}
["Date"]
["01"]
["02"]
["03"]
["04"]
["05"]
["06"]
["07"]
["08"]
["09"]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]

{"sheet":"Sheet1","index":18,"n_rows":24,"n_cols":6,"rows_kept":24,"cut":false,"hidden":true,"merged":[]}
[]
[null,"ID","E",null,"Date Recorded",1]
[null,"UNIQUE ID","F",null,"Type of Deficiency",2]
[1,"Date Recorded","G",null,"Observer code",3]
["ignore","Vessel Type","H",null,"Type of Inspection",4]
[null,"Internal / External","I",null,"Description of Deficiency",5]
[null,"Drydock","J",null,"Equipment Categories",6]
[null,"Information Sharing","K",null,"Area of Observation",7]
[null,"Critical_item","L",null,"Deficiency Cause",8]
[null,"Deficiency Type","M",null,"VIQ Ref Number",9]
[null,"Deficiency Cause","N",null,"Risk Value of Obs",10]
[null,"Inspection Type","O",null,"PSC Ref Number",11]
[null,"Equipments","P",null,"PSC MOU ID",12]
[null,"VIQ Reference Number","Q",null,"Action Taken or Required",13]
[null,"Risk Value of the observation","R",null,"Target Date",14]
[null,"PSC Reference Number","S",null,"PO Ref No.",15]
[null,"PSC MOU","T",null,"Status Code",16]
[null,"Observer Code","U",null,"Date Completed",17]
[null,"Target Date","V",null,"Drydock",18]
[null,"Status Code","W",null,"Info Sharing",19]
[null,"Description of Deficiency","X",null,"Critical Item Flag",20]
[null,"Action taken / required","Y",null,"Audit Type",21]
[null,"PO ref no","Z"]
[null,"Date completed","AA"]

{"sheet":"Ship_information","index":19,"n_rows":2,"n_cols":3,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["Ship_ID","Ship_Name","FILE_NAME"]
["107","ANTWERP","107_1606061599267.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"]