{"text_format":"1","workbook":"xlsx","n_sheets":20,"sheets":["Mainsheet","Completed","Calc","Areaofobs","Vessel_type","Deficiency_type","VIQrefno","Equipment_list","PSC_MOU","Inspection_type","Deficiency_Cause","Observer_code","Status_code","PSC_ref_no","Risk_value_of_obs","Year","Month","Date_","Sheet1","Ship_information"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":0,"defined_names":12,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Mainsheet","index":0,"n_rows":20,"n_cols":27,"rows_kept":20,"cut":false,"hidden":false,"merged":[[12,6,12,26],[8,6,8,26],[10,8,10,9],[10,12,10,13]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Defect - Damage Monitoring Sheet"]
[]
[null,null,null,null,null,null,null,"Date of Report","28-8-2019",null,null,"Ship Name","DHT BRONCO"]
[]
[]
[]
[]
[]
[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"]
[null,null,null,null,1,"2019-09-28 11:14:48.000","2019-09-01","td desc,sdfsdf","","Flag State Inspection","test 1","Main Engine \n\n","Navigation","Behaviour Based,Equipment Related","1","","ddw","","Action test 1","2019-09-06","PO 1","Not Started","2019-09-30","No","Yes","No",0]
[null,null,null,null,2,"2019-08-23 14:58:03.000","2019-07-31","sdfsdf,td desc","","Flag State Inspection","add from excelasd\n\nasdmknasjddyf\nasda\ncdnjdsad ajsdhasd asjdb d","Purifiers\n","Navigation","Behaviour Based","1","","","","add from excel action\nasdka\n\nasdkmasd\n\n\nasdasd","2019-08-09","add from excel PO ref","In-progress","2019-08-29","No","No","No",0]
[null,null,null,null,3,43736.468599537038,"2019-08-28","td2,td3"," Flag State Control (During flag state inspections the inspector might have some observations / remarks.)\n","ISM Audit","Description of Deficiency","Accommodation \n,Air compressor\n","Certification and documentation","Behaviour Based,Equipment Related",1,"Medium","Not Applicable","Not Applicable","Action Taken or Required","19-10-2019","PO Ref No.","In-progress",null,"No","No","No",1]

{"sheet":"Completed","index":1,"n_rows":17,"n_cols":27,"rows_kept":17,"cut":false,"hidden":false,"merged":[[8,6,8,26],[10,8,10,9],[10,12,10,13],[12,6,12,26]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Defect - Damage Monitoring Sheet"]
[]
[null,null,null,null,null,null,null,"Date of Report","28-8-2019",null,null,"Ship Name","DHT BRONCO"]
[]
[]
[]
[]
[]
[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"]

{"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":11,"n_cols":2,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
["TITLE","ID"]
["Certification and documentation",5]
["Communication",9]
["Crew Management",6]
["Engine Room ",14]
["Life Saving Appliances / Fire Fighting Appliances",11]
["MLC Related",7]
["Navigation",8]
["Pollution Prevention",12]
["Safety Management (ISM)",10]
["Security",13]

{"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":3,"n_cols":3,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
["TITLE","Type of deficiency_description","ID"]
["td2",null,5]
["td3",null,6]

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

{"sheet":"Equipment_list","index":7,"n_rows":21,"n_cols":3,"rows_kept":21,"cut":false,"hidden":true,"merged":[]}
["TITLE","Equipment_list_description","ID"]
["Accommodation ",null,14]
["Air compressor",null,10]
["Auxiliary Engine",null,6]
["Auxiliary Machineries (Pumps, MGPS, sanitary system, domestic water system, viscotherm, temperature & pressure controller, heat exchangers etc)",null,9]
["Boilers",null,7]
["Cargo Machineries (Cargo pump, Cargo pump turbines, AUS, Stripping pump, PV Valves, Eductor, COW machine, Cargo Valves etc)",null,15]
["Critical Equipment",null,18]
["Deck Machinery (Gangway & drive motor, Pilot ladder, cranes etc.)",null,20]
["Deck Pipe & Fittings",null,22]
["Documentation",null,23]
["Electrical Machinery & Equipment (Motor, electrical panel, cabling)",null,12]
["Hull & Tanks",null,21]
["Inert Gas System",null,16]
["Life Saving, Fire Fighting and Safety Equipment",null,19]
["Main Engine ",null,5]
["Miscellaneous",null,24]
["Navigation & communication equipment",null,13]
["Pipes, valves and fittings",null,11]
["Purifiers",null,8]
["Windlass & Mooring Machinery",null,17]

{"sheet":"PSC_MOU","index":8,"n_rows":5,"n_cols":3,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
["TITLE","PSC_MOU_description","ID"]
["cxvdfs",null,12]
["test",null,6]
["viken",null,1]
["werr23",null,13]

{"sheet":"Inspection_type","index":9,"n_rows":12,"n_cols":2,"rows_kept":12,"cut":false,"hidden":true,"merged":[]}
["TITLE","ID"]
["Flag State Inspection",8]
["ISM Audit",4]
["ISPS Audit",6]
["IT Audit",12]
["MLC Audit",5]
["Navigation Audit / Verification",10]
["OM Inspection (SIRE / CDI etc.)",9]
["Others (Such as Green Award, Insurance etc.)",14]
["PSC Inspection",7]
["Ship Staff Inspection",11]
["Terminal Inspection",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,4]
["Equipment Related",null,6]
["External Factors",null,7]
["Human Error",null,9]
["Inappropriate Procedure  ",null,10]
["Industry Issue",null,8]
["Knowledge Based",null,5]

{"sheet":"Observer_code","index":11,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":true,"merged":[]}
["TITLE","Observer_code_description","ID"]
[" Flag State Control (During flag state inspections the inspector might have some observations / remarks.)",null,4]
["Class Surveyor During annual, intermediate or renewal survey class surveyors might give observations / remarks. (All Conditions of Class / Imp Memos / Non conformities and observation recorded during an ISM / ISPS Audit should be recorded here)",null,3]
["Others (Such as Green Award, Insurance etc.)",null,8]
["Port State Control (During port state inspections the inspector might have some observations / remarks.Normally port state inspectors will give you also a date when the deficiency has to be completed. This completion date needs to be reported in the colum",null,5]
["Ships staff",null,9]
["SIRE / CDI (Oil Majors vetting & CDI inspection remarks )",null,7]
["Superintendent",null,10]
["Terminal remarks (Nowadays terminals might also audit your vessel and make some remarks / observations.)",null,6]

{"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 dry-dock.",null,5]
["In-progress",null,3]
["Not Started",null,2]
["Waiting spare parts",null,4]

{"sheet":"PSC_ref_no","index":13,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["TITLE","ID"]
["ddw",1]

{"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"]
["104","DHT BRONCO","104_1569652284618.xlsm"]