{"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":21,"n_cols":28,"rows_kept":21,"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","13-Jul-2021",null,null,"Ship Name","PACIFIST (13-07-2021)"]
[]
[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,17626,"109_31/1/2021 7:02:19 PM","2021-01-03","Defect","Owner / Marine / Tech. Suptd.","Suptd. Insp.","F'CASTLE  DECK /MAIN DECK / POOP DECK / ACCOMMODATION DECK WERE RUST .","Hull & Tanks","General Appearance","External Factors","","","","","ACCOM. DECKS / POOP DECK DE-RUST & PAINT.OTHERS IN PROGRESS .","2021-07-30","","In progress",null,"No","No","No","Internal","please update status"]
[null,null,null,null,17633,"109_31/1/2021 7:40:53 PM","2021-01-03","Defect","Owner / Marine / Tech. Suptd.","Suptd. Insp.","HATCH COVER NO. 1,2,3 WERE IN RUST","Cargo Mach.","Structural Condn. / WT integrity ","Equipment Related","","","","","WILL BE CARRY OUT DE-RUST AND COMESTIC BY CREW DURING VSL AT SEA .","2021-07-30","","Not Started",null,"No","No","No","Internal","please update status"]
[null,null,null,null,17635,"109_31/1/2021 7:46:12 PM","2021-01-03","Defect","Owner / Marine / Tech. Suptd.","Suptd. Insp.","F' MAST WERE RUST","Miscellaneous","General Appearance","Equipment Related","","","","","WILL BE CARRY OUT DE-RUST & COMESTIC BY CREW DURING VSL AT SEA .","2021-07-30","PACI210026","Not Started",null,"No","No","No","Internal","please update status, it should complete within due date"]
[null,null,null,null,17637,"109_28/1/2021 12:26:15 PM","2021-01-12","Defect","Ship Staff","Ship Staff Insp.","engine  room set tank level gauge no working","E/R - Aux. Mach.","Eng. / Strg. Comp.","Equipment Related","","","","","order the spare make sure the level gauge working","2021-04-14","PACI210023","Deferred to D D",null,"Yes","No","No","Internal","please update status"]

{"sheet":"Completed","index":1,"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","13-Jul-2021",null,null,"Ship Name","PACIFIST (13-07-2021)"]
[]
[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,16261,"109_20/12/2020 2:45:45 PM","2020-12-11","Defect","Ship Staff","Ship Staff Insp.","Main  SW Pump no.2 sea water discharge line pipe leakage","E/R - Pipes/ valves & fittings","Eng. / Strg. Comp.","Equipment Related","","","","","Pipe renewed  by the shore workshop  and tried out found satisfactory.","2021-01-20","","Completed","2020-12-14","No","No","No","Internal",""]
[null,null,null,null,16262,"109_20/12/2020 2:52:28 PM","2020-12-11","Defect","Ship Staff","Ship Staff Insp.","Sea water non return v/v to main cooling sea water pump and port cooling sea water pump no holding","E/R - Pipes/ valves & fittings","Eng. / Strg. Comp.","Equipment Related","","","","","Change the valve at shipyard","2020-12-20","","Completed","2020-12-14","No","No","No","Internal","."]
[null,null,null,null,16263,"109_20/12/2020 2:58:11 PM","2020-12-11","Defect","Ship Staff","Ship Staff Insp.","Sea water  pipe line to auxiliary engine put clip","E/R - Pipes/ valves & fittings","Eng. / Strg. Comp.","Equipment Related","","","","","Damage pipe renewed by shore workshop and tried out, found satisfactory","2020-12-20","","Completed","2020-12-14","No","No","No","Internal",""]
[null,null,null,null,16264,"109_20/12/2020 3:02:29 PM","2020-12-11","Defect","Ship Staff","Ship Staff Insp.","Sea water pipe to auxiliary boiler condenser suction line leakages","E/R - Pipes/ valves & fittings","General Appearance","Equipment Related","","","","","Leaky pipe renewed.","2020-12-20","","Completed","2020-12-14","No","No","No","Internal",""]
[null,null,null,null,16265,"109_20/12/2020 3:10:00 PM","2020-12-12","Defect","Ship Staff","Ship Staff Insp.","life boat battery charger no working","LSA / FFA","Safety / LSA / FFA","Equipment Related","","","","","Emergency spare  order no: 008-2020 and waiting the spare battery charger","2021-01-14","","Completed","2021-01-05","No","No","No","Internal","New battery charger installed and tried out, found satisfactory."]
[null,null,null,null,16266,"109_20/12/2020 3:14:34 PM","2020-12-12","Defect","Ship Staff","Ship Staff Insp.","F.W.G start and stop switch no working","Elect. Mach. & Equip.","Eng. / Strg. Comp.","Equipment Related","","","","","Start & stop switch  renewed from Engine Room Exhaust fan, tried out-found satisfactory","2020-12-31","","Completed","2020-12-23","No","No","No","Internal",""]
[null,null,null,null,16260,"109_21/12/2020 7:22:22 PM","2020-12-16","Defect","Ship Staff","Ship Staff Insp.","NO.6 H/C CANT'T CLOSED AT LAST END DUE TO THE H/C CHAINS NOT  LENGTH NOT EQUAL AT F'&A' PARTY .","Deck - Machinery","Structural Condn. / WT integrity ","Equipment Related","","","","","ADJUST THE CHAIN LENGTH BY DECK HANDS","2020-12-31","","Completed","2021-01-31","No","No","No","Internal","Chain length adjusted  and tried out found satisfactory by shipstaffs."]
[null,null,null,null,16268,"109_21/12/2020 6:59:11 PM","2020-12-16","Defect","Ship Staff","Ship Staff Insp.","No.1-9 H/C HATCH COVER QUICKLY ACTING CLEATS  ALL SERIOUS RUST AND CAUSED ALL ADJUST SCREW NUTS  CAN'T MOVE FREELY.","Miscellaneous","Cargo / Ballast Systems","External Factors","","","","","ALL DISASSEMBLY , DERUST/PAINT/GREASE/RE-FIT .","2021-03-31","PACI210006","Completed","2021-05-08","No","No","No","Internal","Pls   update the progress of  de-rusting  and upgrading of HC cleats."]
[null,null,null,null,null,"109_21/12/2020 7:09:19 PM","2020-12-16","Breakdown","Owner / Marine / Tech. Suptd.","Ship Staff Insp.","ALL WATER LEVEL DETECT SENSORS OF BW TKS WERE OUT OF WORKING AND OR MISTAKE READ .","Hull & Tanks","Cargo / Ballast Systems","Equipment Related",null,null,"Not Applicable","Not Applicable","carried out inspection by shore service , waitting spare for renewal the malfunction sensors .","2021-04-30",null,"Completed","2021-06-28","Yes",null,null,"Internal"]
[null,null,null,null,17623,"109_31/1/2021 7:29:58 PM","2021-01-03","Defect","Owner / Marine / Tech. Suptd.","Suptd. Insp.","ALL HATCH COVER CHAINS WERE RUST","Miscellaneous","Cargo / Ballast Systems","Equipment Related","","","","","no. 1,6 hatch cover chains were renewal by shipyard in dd . ","2021-04-27","PACI210019","Completed","2021-05-20","Yes","No","No","Internal","please update status vessel already in dock"]
[null,null,null,null,17624,"109_31/1/2021 5:17:38 PM","2021-01-03","Defect","Ship Staff","Ship Staff Insp.","NO.1-9 HATCH  H/C RUBBER PACKING CRACKS AND OLD","Cargo Mach.","Structural Condn. / WT integrity ","Equipment Related","","","","","Hold no.1-9 all hatch cover rubber packing are renewal by ship yard .","2021-04-30","PACI210004","Completed","2021-05-20","Yes","No","No","Internal","please update status vessel already in dock"]
[null,null,null,null,17625,"109_31/1/2021 6:56:16 PM","2021-01-03","Defect","Owner / Marine / Tech. Suptd.","Suptd. Insp.","ALL WINDLASS & MOORING WINCHES BRAKE LINING WERE WEAR OUT OF LIMIT.","Deck - Mooring Machinery","Mooring","Equipment Related","","","","","all mooring winches & anchor windlass brake lining checked , and renewal both anchor windlass brake lining , both stern line winches' brake lining .","2021-04-27","PACI215059","Completed","2021-05-20","Yes","No","No","Internal","please update status vessel already in dock"]
[null,null,null,null,17627,"109_31/1/2021 7:11:04 PM","2021-01-03","Defect","Owner / Marine / Tech. Suptd.","Suptd. Insp.","ALL THE MUSHROOM VENT HOUSING AND AIR INTAKE MESH WERE RUST STAIN .","Miscellaneous","General Appearance","Equipment Related","","","","","all mushroom vent housing carried out repair and mentenace and mesh  renewal  by shipyard in DD .","2021-02-28","","Completed","2021-05-31","No","No","No","Internal","please update status vessel already in dock"]
[null,null,null,null,17628,"109_31/1/2021 7:17:55 PM","2021-01-03","Defect","Owner / Marine / Tech. Suptd.","Suptd. Insp.","ALL WEATHER TIGHT DOOR GREASE POINT NEED GREASE .","Accommodation,Miscellaneous","General Appearance","Behaviour Based,Equipment Related","","","","","CARRY OUT GREASE AND MATENANCE FOR ALL WEATHER TIGHT DOOR GREASE POINT .","2021-02-28","","Completed","2021-04-30","No","No","No","Internal","to expedite the job after docking"]
[null,null,null,null,17629,"109_31/1/2021 7:22:20 PM","2021-01-03","Defect","Owner / Marine / Tech. Suptd.","Suptd. Insp.","ALL DECK AIR PIPE , ELECTRIC CONDUIT PIPE U-CLAMS CORRODED AND NEED RENEWAL .","Deck - Pipe / Fittings","General Appearance","Equipment Related","","","","","ALL DECK PIPES' U-CLAMS ARE CARRIED OUT  INSPECTION AND RENEWAL BY SHIPYARD IN DD.","2021-04-27","","Completed","2021-05-31","Yes","No","No","Internal","please update status vessel already in dock"]
[null,null,null,null,17630,"109_31/1/2021 7:26:52 PM","2021-01-03","Defect","Owner / Marine / Tech. Suptd.","Suptd. Insp.","ALL CARGO HOLD BULKHEAD WERE IN RUST CONDITION .","Hull & Tanks","Structural Condn. / WT integrity ","Equipment Related","","","","","ALL CARGO HOLD CARRIED OUT SAND BLLAST AND MADE PAINT BY SHIP YARD IN DD.","2021-04-27","","Completed","2021-05-30","Yes","No","No","Internal","please update status vessel already in dock"]
[null,null,null,null,17631,"109_31/1/2021 7:34:35 PM","2021-01-03","Defect","Owner / Marine / Tech. Suptd.","Suptd. Insp.","RESCUE BOAT DAVIT WERE RUST","LSA / FFA","Safety / LSA / FFA","Equipment Related","","","","","DE-RUST & MADE PAINT","2021-02-28","","Completed","2021-04-30","No","No","No","Internal","to expedite the job within due date"]
[null,null,null,null,17632,"109_31/1/2021 7:37:56 PM","2021-01-03","Defect","Owner / Marine / Tech. Suptd.","Suptd. Insp.","LIFE BOAT DAVIT WERE RUST","LSA / FFA","Safety / LSA / FFA","Equipment Related","","","","","CARRIED OUT DE-RUST AND MADE PAINT BY SHIP YARD IN DD .","2021-04-27","","Completed","2021-05-31","Yes","No","No","Internal","please update status"]
[null,null,null,null,17634,"109_31/1/2021 7:43:36 PM","2021-01-03","Defect","Owner / Marine / Tech. Suptd.","Suptd. Insp.","BOTH  PILOT GANGWAY LADDER LACK OF MAINTENANCE","Deck - Pipe / Fittings","General Appearance","Equipment Related","","","","","BOTH PILOT GANGWAY LADDER DISMANTLED AND SHIFT TO SHORE CARRID OUT  MAINTENANCE BY SHIP YARD . AND ALL WIRE ROPES CARRIED OUT  RENEWAL BY CREW .","2021-02-28","PACI210013 , PACI210015 , PACI210021","Completed","2021-05-31","No","No","No","Internal","please update status vessel already in dock"]
[null,null,null,null,null,"109_31/1/2021 7:50:13 PM","2021-01-03","Defect","Owner / Marine / Tech. Suptd.","Suptd. Insp.","F' BSN. STORE WERE DITY AND NEED TIDE UP .","Miscellaneous","General Appearance","Equipment Related",null,null,"Not Applicable","Not Applicable","WILL BE CARRY OUT CLEAN AND TIDE UP AFTER DD .","2021-06-30",null,"Completed","2021-07-11","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"]
["109","PACIFIST (13-07-2021)","109_1626165337051.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"]