{"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":32,"n_cols":28,"rows_kept":32,"cut":false,"hidden":false,"merged":[[10,8,10,9],[10,12,10,13],[12,6,12,27],[8,6,8,27]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Defect - Damage Monitoring Sheet"]
[]
[null,null,null,null,null,null,null,"Date of Report","25-Oct-2021",null,null,"Ship Name","SUNRISE I (21-09-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,21789,"120_10/25/2021 9:23:56 AM","2021-10-19","Critical Equipment","Ship Staff","Ship Staff Insp.","Incinerator Opeartion firing in LSMGO but after 25 min after activation of secondary burner , the secondary chamber no reaching to the  temperature of 650deg","Critical Equip.","MARPOL Related","Equipment Related",null,null,"Not Applicable","Not Applicable","Informed office,connected with maker for trobleshooting.","2021-12-31",null,"In progress",null,"No","No","No","Internal"]
[null,null,null,null,20459,"120_7/25/2021 4:54:52 PM","2021-07-20","Defect","Owner / Marine / Tech. Suptd.","Ship Staff Insp.","HOLE IN THE DIFFUSER OF THE BILGE EDUCTOR PUMP","E/R - Pumps","Eng. / Strg. Comp.","Equipment Related","","","","","TEMPORARY COVER THE HOLE WITH PLASTIC STEEL(CORCOBOND)","2021-11-20","SUN1210029","Waiting spare",null,"No","No","No","Internal","Spare is in order, will be connected at next convenient port."]
[null,null,null,null,20461,"120_7/25/2021 5:35:09 PM","2021-07-20","Defect","Ship Staff","Ship Staff Insp.","DEIFECTIVE PLC AND SOLENOID VALVE OF THE PACK AIRCON IN ECR","Elect. Mach. & Equip.","Eng. / Strg. Comp.","Equipment Related","","","","","TEMPORARY MANUAL OPERATED THE SYSTEM","2021-11-20","NO REQ. YET","Not Started",null,"No","No","No","Internal","Vessel to raise requisition of PLC."]
[null,null,null,null,20462,"120_7/25/2021 5:14:16 PM","2021-07-21","Defect","Owner / Marine / Tech. Suptd.","Ship Staff Insp.","DEFECTIVE CPU OF THE NO. 2  AMS IN ECR","Elect. Mach. & Equip.","Eng. / Strg. Comp.","Equipment Related","","","","","USING THE NO. 1 AMS","2021-10-26","SUN1210045","Not Started",null,"No","No","No","Internal","New one will be connected at next convenient port."]
[null,null,null,null,20463,"120_7/25/2021 5:27:08 PM","2021-07-28","Defect","Ship Staff","Ship Staff Insp.","MOTOR AND FAN OVERLOAD ALARM OF DECK AIR COMPRESSOR","Elect. Mach. & Equip.","Eng. / Strg. Comp.","Equipment Related","","","","","EQUIPMENT NOT IN USE","2021-10-30","SPARE RECIEVED ON BOARD","In progress",null,"No","No","No","Internal","PLC supplied & renewed but still problem persist. Troubleshooting revealed grounding of cooling fan. Spare is in order & will be connected at next port."]
[null,null,null,null,20464,"120_7/25/2021 5:41:07 PM","2021-07-29","Defect","Owner / Marine / Tech. Suptd.","Ship Staff Insp.","THE FLOWMETER READING IS NOT ACCURATE","Miscellaneous","Eng. / Strg. Comp.","Equipment Related","","","","","CONSUMPTION READING IS TEMPORARY TAKEN FROM THE TANKS","2021-10-30","NO REQ. YET","Not Started",null,"No","No","No","Internal","Vessel to follow up with office on flowmeter issue."]
[null,null,null,null,20469,"120_8/9/2021 9:50:30 AM","2021-08-08","Observation","Ship Staff","Ship Staff Insp.","letters and numbers on the auto pilot information display sometimes changes and become other number, letter or character","Navigation - Others","General Appearance","Equipment Related","","","","","requested guidance","2021-10-30","","In progress",null,"No","No","No","Internal","Arranged technician to attend vessel at Fujairah. Please close out if rectified."]
[null,null,null,null,20467,"120_7/25/2021 5:19:21 PM","2021-08-18","Defect","Ship Staff","Ship Staff Insp.","HIGH TEMP. ALARM ON THE CONTROL AIR DRIER","Elect. Mach. & Equip.","Eng. / Strg. Comp.","Equipment Related","","","","","TEMPORARY COOLED BY PORTABLE AIR BLOWER","2021-11-23","NO REQ. YET","In progress",null,"No","No","No","Internal","Vessel to carry out troubleshooting & report to office."]
[null,null,null,null,21791,"120_10/25/2021 9:07:14 AM","2021-09-23","Observation","Ship Staff","Ship Staff Insp.","No sludge evaporation from incinerator waste oil service tank.","Hull & Tanks","MARPOL Related","Equipment Related","","","","","Suspected heating coil is of lesser capacity informed office if  any modifcation needed.","2021-12-23","","Not Started",null,"No","No","No","Internal"]
[null,null,null,null,21796,"120_10/25/2021 8:59:10 AM","2021-10-10","Observation","Ship Staff","Ship Staff Insp.","Start motor not available for aux. engine","E/R - Aux. Engine","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Requisition SUN1210118  raised.","2021-10-30",null,"Not Started",null,"No","No","No","Internal"]
[null,null,null,null,21797,"120_24/10/2021 12:12:41","2021-10-11","Non Conformity","Ship Staff","Ship Staff Insp.","Forcastle water tight door and cargo hold booby hatch cover's found not closing / opening properly.","Hull & Tanks","Structural Condn. / WT integrity ","External Factors","","","","","Derusting/ Renewal of gasket and greasing of all nipples to be carried out.","2021-11-30","","In progress",null,"No","No","No","Internal"]
[null,null,null,null,21798,"120_22/10/2021 15:03:27","2021-10-22","Observation","Ship Staff","Ship Staff Insp.","Pressure gauges in Engine room machinary found opaque, unable to read through them.","E/R - Pipes/ valves & fittings","Eng. / Strg. Comp.","Industry Issue","","","","","Identify and raise requisition and renew pressure gauges as required.","2021-12-26","","In progress",null,"No","No","No","Internal"]
[null,null,null,null,21802,"120_22/10/2021 19:26:19","2021-10-22","Observation","Ship Staff","Ship Staff Insp.","MSMP manual found equipment code is wrong, due to which MBL & BHC calculated is wrong. Need to correct on Manual and mooring winches.","Deck - Mooring Machinery","Mooring","Knowledge Based","","","","","Need to check thoroughly ship's manual and correct all mooring winches for BHC.","2021-11-30","","In progress",null,"No","No","No","Internal"]
[null,null,null,null,21803,"120_10/25/2021 8:38:58 AM","2021-10-25","Defect","Ship Staff","Ship Staff Insp.","Deck compressor not operational, to be investigated","E/R - Air Comp.","Eng. / Strg. Comp.","Equipment Related","","","","","Maker advice","2021-12-30","","In progress",null,"No","No","No","Internal"]
[null,null,null,null,21804,"120_10/25/2021 8:55:06 AM","2021-10-25","Defect","Ship Staff","Ship Staff Insp.","MEFO Auto back was filter is not working","E/R - Aux. Mach.","Eng. / Strg. Comp.","Equipment Related","","","","","Suspected control unit malfuntioning","2021-12-31","","Not Started",null,"No","No","No","Internal"]

{"sheet":"Completed","index":1,"n_rows":33,"n_cols":28,"rows_kept":33,"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","25-Oct-2021",null,null,"Ship Name","SUNRISE I (21-09-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,20465,"120_7/25/2021 5:45:38 PM","2021-07-07","Defect","Owner / Marine / Tech. Suptd.","Ship Staff Insp.","THE F.O. FILTER AUTO BACKWASH IS STUCK UP","Elect. Mach. & Equip.","Eng. / Strg. Comp.","Equipment Related","","","","","REPAIRED BY ELECTRICIAN","2021-09-20","NO REQ. YET","Completed","2021-05-09","No","No","No","Internal"]
[null,null,null,null,null,"120_10/23/2021 10:36:10 AM","2021-06-10","Observation","Ship Staff","Ship Staff Insp.","Auxilliary Engine turbocharger rpm not indicating on monitor display.","E/R - Aux. Engine","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Speed sensor replaced.","2021-07-11",null,"Completed","2021-10-27","No",null,null,"Internal"]
[null,null,null,null,21080,"120_8/27/2021 12:28:29 PM","2021-07-13","Critical Equipment","Owner / Marine / Tech. Suptd.","Engineering Audit","G/E#3 Cylinder cover #3&4 leaking","E/R - Aux. Engine","Eng. / Strg. Comp.","Equipment Related","","","","","RE-TIGHTENED BY HYDRAULIC JACK","2021-08-31","FANT210008 D/G SPARES","Completed","2021-08-16","No","No","No","Internal"]
[null,null,null,null,21081,"120_8/27/2021 2:55:40 PM","2021-07-16","Breakdown","Owner / Marine / Tech. Suptd.","Engineering Audit","M/E RPM indicator defective","Critical Equip.","Eng. / Strg. Comp.","Equipment Related","","","","","REPPAIRED BY ELECTRICIAN","2021-08-31","","Completed","2021-08-23","No","No","No","Internal"]
[null,null,null,null,21082,"120_8/27/2021 3:01:12 PM","2021-07-19","Defect","Owner / Marine / Tech. Suptd.","Engineering Audit","Galley griller low insulation","Elect. Mach. & Equip.","Safety / LSA / FFA","Equipment Related","","","","","REPAIRED BY ELECTRICIAN","2021-08-31","","Completed","2021-12-08","No","No","No","Internal"]
[null,null,null,null,20466,"120_7/25/2021 11:00:13 PM","2021-07-25","Defect","Ship Staff","Ship Staff Insp.","FIRE FIGHTING UHF RADIOS NOT WORKING/ DEFECTIVE","LSA / FFA","Safety / LSA / FFA","Equipment Related","","","","","RECEIVED NEW FIRE FIGHTING UHF RADIOS AND REPLACED DEFECTIVE RADIOS","2021-04-09","SUN1210046","Completed","2021-04-09","No","No","No","Internal","UHF radios are in order & will be connected at next convenient port."]
[null,null,null,null,21077,"120_17-08-21 10:36:23 AM","2021-07-28","Defect","Ship Staff","Ship Staff Insp.","Gas sampling point CH no.7 p+s & CH no.6 p/s not properly closing due to rust & deterioration.","Deck - Pipe / Fittings","General Appearance","External Factors","","","","","repaired ","2021-08-12","","Completed","2021-08-12","No","No","No","Internal"]
[null,null,null,null,20468,"120_8/2/2021 1:18:42 PM","2021-07-30","Defect","Ship Staff","Ship Staff Insp.","damaged pilot ladder drum reel bearing housing and chain coupling","Deck - Machinery","General Appearance","External Factors","","","","","Repaired pilot ladder drum reel bearing housing and chain coupling after received spares. tested and working in normal condition","2021-08-29","SUN1210049","Completed","2021-08-29","No","No","No","Internal","Spares are in order, will be connected vessel at convenient port."]
[null,null,null,null,null,"120_22/10/2021 18:37:42","2021-09-10","Observation","Ship Staff","Ship Staff Insp.","Main cooling sea water pump #2 overload trip","E/R - Aux. Mach.","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Replaced motor bearing ,found working satisfactorily.","2021-10-11",null,"Completed","2021-10-22","No",null,null,"Internal"]
[null,null,null,null,null,"120_22/10/2021 19:20:43","2021-09-18","Defect","Ship Staff","Ship Staff Insp.","Fish room in Galley found unable to maintain -16° temperature","Accommodation","MLC Related","Equipment Related",null,null,"Not Applicable","Not Applicable","Need to be checked by ETO & repair if necessary.","2021-10-30",null,"Completed","2021-10-08","No",null,null,"Internal"]
[null,null,null,null,null,"120_10/25/2021 8:50:05 AM","2021-09-23","Defect","Ship Staff","Ship Staff Insp.","Fire & GS pump not operational","E/R - Pumps","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Motor bearing renewed.tried out pump found working satisfctorily.","2021-11-23",null,"Completed","2021-10-27","No",null,null,"Internal"]
[null,null,null,null,null,"120_24/10/2021 12:08:42","2021-09-25","Defect","Ship Staff","Ship Staff Insp.","VRCS accumulator found empty, due to which hydraulic pump for VRCS was running contniously","Cargo Mach.","Cargo / Ballast Systems","Equipment Related",null,null,"Not Applicable","Not Applicable","Check availability of nitrogen and top up accummulators on main deck.","2021-10-09",null,"Completed","2021-10-05","No",null,null,"Internal"]
[null,null,null,null,null,"120_24/10/2021 10:56:05","2021-09-25","Non Conformity","Ship Staff","Ship Staff Insp.","Port side Pilot Ladder, bottom two steps found deformed, embarkation ladder for liferaft found in poor shape. ","LSA / FFA","Safety / LSA / FFA","Knowledge Based",null,null,"Not Applicable","Not Applicable","PO raised, awaiting berthing of vessel.","2021-11-15","SUN1210108 - PILOT AND EMBARKATION LADDER","Completed","2021-10-27","No",null,null,"Internal"]
[null,null,null,null,null,"120_22/10/2021 19:16:34","2021-10-22","Observation","Ship Staff","Ship Staff Insp.","Steering compartment boiler platform door found to be lashed with wire in open condition","Miscellaneous","Crew Management","Behaviour Based",null,null,"Not Applicable","Not Applicable","Need to check all doors in Engine room and remove all temporary arrangement made to keep door open all times.","2021-10-25",null,"Completed","2021-10-24","No",null,null,"Internal"]
[null,null,null,null,null,"120_22/10/2021 18:48:37","2021-10-22","Observation","Ship Staff","Ship Staff Insp.","Air line on midship found holed, due to corrosion","Deck - Pipe / Fittings","Structural Condn. / WT integrity ","External Factors",null,null,"Not Applicable","Not Applicable","Need renewal of air line flange to flange.","2021-11-22",null,"Completed","2021-10-25","No",null,null,"Internal"]
[null,null,null,null,null,"120_10/22/2021 10:37:55 PM","2021-10-22","Critical Equipment","Ship Staff","Nav Audit / Verification","Ship's whistle air line on Monkey Island leaking air.","Navigation - Others","Navigation","External Factors",null,null,"Not Applicable","Not Applicable","Need to replace new air pipe","2021-11-11",null,"Completed","2021-10-26","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"]
["120","SUNRISE I (21-09-2021)","120_1635146772351.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"]