{"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":28,"n_cols":28,"rows_kept":28,"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","15-Nov-2021",null,null,"Ship Name","NN TENACITY (01-11-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,21100,"125_21/9/2021 3:10:06 pm","2021-09-15","Defect","Ship Staff","Ship Staff Insp.","Draft gauges are showing erratic reading.","Hull & Tanks","Cargo / Ballast Systems","Equipment Related","","","","","Gauges need to be re-calibrated.","2021-12-15","","In progress",null,"No","No","No","Internal","Kindly carry out troubleshooting at earliest opportunity & report to office for any assistance iwo of spars or assistance require from office."]
[null,null,null,null,22173,"125_30/10/2021 11:12:31 am","2021-10-24","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Ship fitted with non LED lights need to be replaced with LED lights","Accommodation,Elect. Mach. & Equip.","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","RO raised for additional LED lights, awaiting for spares.","2022-02-28","NTEN210078","In progress",null,"No","No","No","Internal","Please complete asap & report to office."]
[null,null,null,null,22172,"125_31/10/2021 12:42:03","2021-10-26","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Hatch cover 1,2,4,8, & 9 to de-rust and paint full coat, Hatch cover 3,5,6,7 to  spot de-rust and upgrade the cosmetic appearance.","Deck - Machinery","General Appearance","Equipment Related","","","","","Derust and paint the hatch covers and assosiated fitting.","2022-01-25","","In progress",null,"No","No","No","Internal"]
[null,null,null,null,22174,"125_30/10/2021 11:34:49 am","2021-10-26","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","E/R bottom platform - Local signal light column alarm rotatory lamp not working. To be investigated and rectified.","Elect. Mach. & Equip.,Miscellaneous","Emgcy. Systems","Equipment Related","","","","","Spares requisition raised , awaiting for spares.","2021-12-31","NTEN210067","Waiting spare",null,"No","No","No","Internal"]
[null,null,null,null,22175,"125_30/10/2021 12:47:07 pm","2021-10-26","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Flame proof light near Oxy-Acetylene room fitting to be renewed","Miscellaneous","Eng. / Strg. Comp.","Equipment Related","","","","","Flame proof Light to be replaced , awaiting for spares.","2022-12-31","NTEN210066","Waiting spare",null,"No","No","No","Internal"]
[null,null,null,null,null,"125_15/11/2021 8:23:58 pm","2021-11-02","Defect","Ship Staff","Ship Staff Insp.","ME & AE FO CIRCULATING PUMP NO. 2 SEAL LEAKAGE ","E/R - Pumps","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","LIP SEAL TO BE RENEWED, RO RAISED FOR SPARE LIP SEAL.  AWIATING SPARES SUPPLY.","2021-12-15","NTEN210043/2","Waiting spare",null,"No",null,null,"Internal"]
[null,null,null,null,null,"125_15/11/2021 8:34:05 pm","2021-11-03","Observation","Ship Staff","Ship Staff Insp.","ENGINE ROOM OVERHEAD CRANE REMOTE CONTROL CABLE CONDITION  NOT GOOD DUE AGEING","Miscellaneous","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","CONTROL CALBE REQUIRE TO BE RENEWED,AWAITING SPARE SUPPLY","2022-01-15","NTEN210073","Waiting spare",null,"No",null,null,"Internal"]
[null,null,null,null,null,"125_30/11/2021 12:01:45 am","2021-11-07","Breakdown","Ship Staff","Ship Staff Insp.","Refrigeration compressor no. 2 connecting rod & piston along with mechanical seal damaged.\t","E/R - Aux. Mach.","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Requisistion for complete ref. compressor raised, awaiting for spares.","2021-12-15","NTEN210089","Waiting spare",null,"No",null,null,"Internal"]
[null,null,null,null,null,"125_30/11/2021 12:15:34 am","2021-11-16","Observation","Ship Staff","Ship Staff Insp.","Low sea chest copper anode of MGPS system observed 80% consumed,need replaceme ","Miscellaneous","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Copper anode need to be replaced with new spare one. RO raised awaiting for spares.","2022-01-15","NTEN210093","Waiting spare",null,"No",null,null,"Internal"]
[null,null,null,null,null,"125_24/11/2021 11:46:02 pm","2021-11-20","Critical Equipment","Ship Staff","Ship Staff Insp.","Emergency generator battery start method in operational due to defective Aux magnet Switch (AMS).\t","Critical Equip.","Emgcy. Systems","Equipment Related",null,null,"Not Applicable","Not Applicable","Defective Aux Magnet Switch (AMS) to be replaced with new spare ones, awaiting for spares.","2021-12-20","NTEN210095 ","Waiting spare",null,"No",null,null,"Internal"]
[null,null,null,null,null,"125_30/11/2021 12:36:07 am","2021-11-27","Critical Equipment","Ship Staff","Ship Staff Insp.","Main engine Bearing Wear monitoring system fault alarm on system.","E/R - Main Engine","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Bearing wear monitoring system fault alarm to be rectify, maker service engineer consulting in progress.","2021-12-15",null,"In progress",null,"No",null,null,"Internal"]

{"sheet":"Completed","index":1,"n_rows":42,"n_cols":28,"rows_kept":42,"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","15-Nov-2021",null,null,"Ship Name","NN TENACITY (01-11-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,21092,"125_21/9/2021 2:01:00 pm","2021-08-14","Non Conformity","FSC Inspector","Flag State Insp.","Emcy generator panel is showing low resistance of 0.1 onms","Elect. Mach. & Equip.","Emgcy. Systems","Equipment Related","","","","","Low insulation source identified and same rectified. ","2021-09-15","","Completed","2021-08-20","No","No","No","External"]
[null,null,null,null,21093,"125_21/9/2021 2:10:56 pm","2021-08-14","Non Conformity","FSC Inspector","Flag State Insp.","Hatch cover cleats of all holds frozen, required to be free & greased.","Hull & Tanks","Cargo / Ballast Systems","Equipment Related","","","","","All cargo holds auto cleats made free moving and greased and covered with denso tape to protect nut/thread.","2021-09-15","","Completed","2021-08-20","No","No","No","External"]
[null,null,null,null,21094,"125_21/9/2021 2:23:08 pm","2021-08-14","Observation","FSC Inspector","Flag State Insp.","Generators insulation around exhaust not in good condition","E/R - Aux. Engine","Eng. / Strg. Comp.","Human Error","","","","","Insulation lagging around generator exhaust renewed with new one.","2021-09-15","","Completed","2021-08-14","No","No","No","External"]
[null,null,null,null,21095,"125_21/9/2021 2:32:10 pm","2021-08-14","Observation","FSC Inspector","Flag State Insp.","Publication AHP 20 not updated","Navigation - Others","Navigation","Human Error,Inappropriate Procedure","","","","","Vessel downloaded latest AHP 20 from www.hydro.gov.au/prodserv/publications/ash.htm","2021-09-15","","Completed","2021-08-20","No","No","No","External"]
[null,null,null,null,21096,"125_21/9/2021 2:40:07 pm","2021-08-14","Observation","FSC Inspector","Flag State Insp.","MSDS sheet for some e/room chemicals not available","Documentation","Cert. & Docu.","External Factors","","","","","MSDS for chemical requested and same  recvd from office.","2021-09-15","","Completed","2021-08-22","No","No","No","External"]
[null,null,null,null,21097,"125_21/9/2021 2:59:59 pm","2021-08-14","Observation","FSC Inspector","Flag State Insp.","AS PER CIC NO. 3 PART 1 , VESSEL SMS DOES NOT HAVE ADDED REQUIREMENTS TO SUBMIT PSC REPORTS TO ADMINISTRATION.","Miscellaneous","ISM Related","External Factors","","","","","Reference to Liberian Marine Notice PSC-001, Rev 01/21 has been added to Company Management System on 19th Aug 2021. Additionally, the Marine Notice has been included under HSQEEn Misc Docs.","2021-09-14","","Completed","2021-08-19","No","No","No","External"]
[null,null,null,null,21099,"125_21/9/2021 13:26:03","2021-08-14","Non Conformity","FSC Inspector","Flag State Insp.","Rescue boat search light not in working condition","LSA / FFA","Safety / LSA / FFA","Equipment Related","","","","","Damaged wire renewed and hole covered with silicon.","2021-09-15","","Completed","2021-08-14","No","No","No","External"]
[null,null,null,null,21285,"125_29/9/2021 14:01:16","2021-09-06","Non Conformity","PSC Insp.","PSC Inspection","Safety Management System was not ensured proper implementation as following evidence: Gasket on outlet piping line situated between no. 2 cylinder head & exhaust v/v misaligned  (due to insufficient  maintenance) result in M/E out of order ( Jacket cooling water going high due to insufficient water flow through outlet piping line)    ","E/R - Main Engine","ISM Related","Equipment Related,Inappropriate Procedure","","","Propulsion and auxiliary machinery","","Maintenance procedure modified as per makers manual and included in Chief Engineer's standing orders.","2021-12-05","","Completed","2021-09-25","No","No","No","External"]
[null,null,null,null,21098,"125_21/9/2021 3:39:29 pm","2021-09-06","Non Conformity","PSC Insp.","PSC Inspection","Responsible crew not familiar with immersion suit wearing operation","LSA / FFA","Safety / LSA / FFA","Knowledge Based","","","Other","","Crew mustered and training was given in proper doning of immersion suit within 2 mintues.","2021-09-06","","Completed","2021-09-06","No","No","No","External"]
[null,null,null,null,21286,"125_30/9/2021 10:19:04 pm","2021-09-17","Defect","Ship Staff","Ship Staff Insp.","ME & AE FUEL OIL CIRCULATING PUMP LIP SEAL LEAKING.","E/R - Pumps","Eng. / Strg. Comp.","Equipment Related","","","","","LIP SEAL REPLACED WITH SPARE SUPPLIED FROM LOCAL WORKSHOP","2021-09-29","NTEN215035","Completed","2021-09-25","No","No","No","Internal"]
[null,null,null,null,null,"125_16/10/2021 19:08:31","2021-09-20","Breakdown","Ship Staff","Ship Staff Insp.","S - band radar stopped transmitting and painting radar target echoes.","Navigation - RADAR","Navigation","Equipment Related",null,null,"Not Applicable","Not Applicable","Office informed and shore service engineer arranged for repair","2021-11-30","NTEN215037","Completed","2021-11-05","No",null,null,"Internal"]
[null,null,null,null,21284,"125_1/10/2021 11:35:25","2021-09-25","Defect","Ship Staff","Ship Staff Insp.","Ballast tank valve indicatornot showing proper indications.","Miscellaneous","Cargo / Ballast Systems","Equipment Related","","","","","Valve indicators adjusted to show proper indication cross checked from local and remote indication found satisfactory.","2021-11-30","","Completed","2021-10-07","No","No","No","Internal","Kindly complete this job at this anchorage."]
[null,null,null,null,21614,"125_16/10/2021 5:20:29 pm","2021-10-03","Critical Equipment,Observation","Ship Staff","Ship Staff Insp.","OWS BOTH CHAMBERS PRESSURE WAS SHOWING HIGHER THAN NORMAL AND PPM WAS SHOWING MORE THAN 15PPM.","Critical Equip.","MARPOL Related","Behaviour Based","","","","","BOTH FIRST AND SECOND STAGE FILTERS REMOVED AND CLEANING OF BOTH FILTERS CARRIED OUT, FIRST AND SECOND STAGE CHAMBERS INTERNALLY CLEANED AND INSPECTED,OIL SENSOR CLEANED AND TRIED OUT.","2021-10-05","","Completed","2021-10-04","No","No","No","Internal"]
[null,null,null,null,21615,"125_16/10/2021 5:31:01 pm","2021-10-06","Defect","Ship Staff","Ship Staff Insp.","Fore peak tank valve BA-01 not operating from local station at forepeak and remote station in CCR.","Deck - Machinery","Cargo / Ballast Systems","Equipment Related","","","","","Forepeak tank valve BA-01 hard to operate, same freed by removing actuator,tested from local as well remote operation found satisfactory working.","2021-10-15","","Completed","2021-10-07","No","No","No","Internal"]
[null,null,null,null,null,"125_16/10/2021 5:42:55 pm","2021-10-08","Breakdown","Ship Staff","Ship Staff Insp.","Main cooling sea water pump no. 1 tripped, Electrical motor burnt.","Elect. Mach. & Equip.","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Electrical motor to be replaced with new spare motor,no spare motor onboard, RO raised.Awaiting spares","2021-11-30","NTEN210064","Completed","2021-11-07","No",null,null,"Internal"]
[null,null,null,null,21616,"125_16/10/2021 6:35:07 pm","2021-10-10","Defect","Ship Staff","Ship Staff Insp.","MAIN ENGINE LUB OIL PP NO. 1 FOUND DRAWING HIGH CURRENT THAN NORMAL.\t","E/R - Main Engine","Eng. / Strg. Comp.","Equipment Related","","","","","MAIN ENGINE LUB OIL PUMP NO. 1 OVERHAULING CARRIED OUT, PUMP CASING RING OF SECOND STAGE BOTTOM SIDE REPLACED, BEARINGS REPLACED WITH SPARE ONES.","2021-10-30","NTEN210065","Completed","2021-10-11","No","No","No","Internal"]
[null,null,null,null,22180,"125_30/10/2021 8:40:47 am","2021-10-24","Defect","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Incinerator sluice door operating air hoses leaking. (2 no’s) to be renewed","E/R - Aux. Mach.","Eng. / Strg. Comp.","Equipment Related","","","","","Incinerator sluice door both operating air hoses renewed with spare ones. No air leakage working satisfatory.","2021-11-05","","Completed","2021-10-28","No","No","No","Internal"]
[null,null,null,null,22181,"125_30/10/2021 11:19:45 am","2021-10-24","Defect","Owner / Marine / Tech. Suptd.","Suptd. Insp.","AE-2 starting air line air reducer leaking from tell-tale hole to be rectified.","E/R - Aux. Engine","Eng. / Strg. Comp.","Equipment Related","","","","","AE-2 starting air line air reducer leakage from tale hole rectified.Working satisfactory.","2021-11-15","","Completed","2021-10-25","No","No","No","Internal"]
[null,null,null,null,22182,"125_31/10/2021 10:58:54","2021-10-24","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Fire hydrant port side accommodation entrance leaking, same to be lapped and fixed.","Deck - Pipe / Fittings","Safety / LSA / FFA","Equipment Related","","","","","Fire hydrant lapped and leakage rectified.","2021-11-05","","Completed","2021-10-25","No","No","No","Internal"]
[null,null,null,null,null,"125_31/10/2021 12:36:56","2021-10-26","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Accommodation/ Pilot assist ladder stowing davit hook/ lock found frozen.","Deck - Machinery","ISM Related","Equipment Related",null,null,"Not Applicable","Not Applicable","Same to be made free and operational.","2021-11-15",null,"Completed","2021-11-14","No",null,null,"Internal"]
[null,null,null,null,null,"125_31/10/2021 12:47:52","2021-10-26","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Suez davit found rusted and frozen.","Deck - Machinery","General Appearance","Equipment Related",null,null,"Not Applicable","Not Applicable","Suez davit to be de-rusted, greased, free moving and upgrade cosmetic appearance.","2021-11-15",null,"Completed","2021-11-14","No",null,null,"Internal"]
[null,null,null,null,null,"125_31/10/2021 12:28:30","2021-10-26","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Checker plate step wasted near the Stbdside PILOT assist ladder. to cropped and renew","Miscellaneous","General Appearance","Equipment Related",null,null,"Not Applicable","Not Applicable","Same to cropped and renew.","2021-11-25",null,"Completed","2021-11-18","No",null,null,"Internal"]
[null,null,null,null,null,"125_31/10/2021 12:23:42","2021-10-26","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Manhole cover lifting handle broken at 3 places.","Miscellaneous","General Appearance","Equipment Related",null,null,"Not Applicable","Not Applicable","Fabricate new handle and fit.","2021-11-30",null,"Completed","2021-11-19","No",null,null,"Internal"]
[null,null,null,null,null,"125_15/11/2021 16:32:57","2021-11-10","Other","Ship Staff","ISM Audit","SCBA sets to be mounted on hooks - internal audit recommadation","Miscellaneous","Safety / LSA / FFA","External Factors",null,null,"Not Applicable","Not Applicable","New hooks to be fabricated.","2021-11-20",null,"Completed","2021-11-20","No",null,null,"Internal"]
[null,null,null,null,null,"125_30/11/2021 12:05:59 am","2021-11-27","Defect","Ship Staff","Ship Staff Insp.","Aux engine no.3 lub oil priming pump making abnormal noise due to defective bearing.","E/R - Aux. Engine","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Aux engine no.3 bearing renewed with spare ones, flexible coupling repaired and fitted back, lub oil priming pump working satisfatory.","2021-12-05",null,"Completed","2021-11-29","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"]
["125","NN TENACITY (01-11-2021)","125_1636962714929.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"]