{"text_format":"1","workbook":"xlsx","n_sheets":21,"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","Sheet2","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":18,"n_cols":27,"rows_kept":18,"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",{"$f":"TODAY()","v":"2019-09-14"},null,null,"Ship Name","DHT FALCON"]
[]
[]
[]
[]
[]
[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 Flag","Audit Type"]
[null,null,null,null,null,"2019-03-09T16:40:14","2019-06-05","Critical Equipment ","SIRE / CDI Insp.","ISPS Audit","gfhgf","Elect. Mach. & Equip.","Safety Management (ISM)","Industry Issue",5.0999999999999996,"Low","Not Applicable","Not Applicable","ghgfhf","2019-11-05","fhfghhg","Waiting spares",null,"No",null,null,"Internal"]

{"sheet":"Completed","index":1,"n_rows":19,"n_cols":27,"rows_kept":19,"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",{"$f":"TODAY()","v":"2019-09-14"},null,null,"Ship Name","DHT FALCON"]
[]
[]
[]
[]
[]
[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 Flag","Audit Type"]
[null,null,null,null,null,"2019-09-03T16:19:15","2019-05-04","Breakdown,Condn of Class / Memo ","Terminal Insp.,SIRE / CDI Insp.,Others","PSC Inspection","dsfsd","Purifier,Air Comp.","MLC Related","External Factors,Industry Issue",6.1,"Medium","04 - Emergency Systems","The Black Sea region","hgjhgj","2019-06-04","llmm","Completed","2019-08-05","Yes",null,null,"External"]
[null,null,null,null,null,"2019-03-09T17:55:59","2019-05-05","Breakdown","Others","Navigation Audit / Verification","sdfsd","ER Pipe / Fittings","Communication","Human Error",5.0999999999999996,"Low","Not Applicable","Not Applicable","sdfdsfsdf","2019-08-04","dsfsdfsdf","Completed","2019-08-05","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":11,"n_cols":1,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
["Area of Observation"]
["Certification and documentation"]
["Crew Management"]
["MLC Related"]
["Navigation"]
["Communication"]
["Safety Management (ISM)"]
["Life Saving Appliances / Fire Fighting Appliances"]
["Pollution Prevention"]
["Security"]
["Engine Room "]

{"sheet":"Vessel_type","index":4,"n_rows":6,"n_cols":1,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
["Vessel_type"]
["Vessel_type1"]
["Vessel_type2"]
["Vessel_type3"]
["Vessel_type4"]
["Vessel_type5"]

{"sheet":"Deficiency_type","index":5,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
["Type of Deficiency","Type of deficiency_description"]
["Deficiency","DEF = Deficiency ( Any deficiency or upgradation job recorded during an inspection by third party Inspectors ) "]
["Non Conformity ","NC = Non Conformity ( Raised by external Inspectors)"]
["Observation ","OBS = Observations ( Raised by external Inspectors)"]
["Critical Equipment ","CRI = Critical Equipment ( any critical equipment failure) "]
["Breakdown","BKD = Breakdown"]
["Condn of Class / Memo ","COC = Condition of Clss raised by a Class Auditor"]
["SMS","SMS = Improvement to the SMS documentation","Please delete this item"]
["Other","Other "]
["Guarantee Claim       ","GC = Guarantee Claim - Add Item"]

{"sheet":"VIQrefno","index":6,"n_rows":13,"n_cols":2,"rows_kept":13,"cut":false,"hidden":true,"merged":[]}
["VIQ_ref_no","Risk Value of observation"]
[1.1000000000000001,"Low"]
[2.1,"Medium"]
[3.1,"High"]
[4.0999999999999996,"Very High"]
[5.0999999999999996,"Low"]
[6.1,"Medium"]
[7.1,"High"]
[8.1,"Very High"]
[9.1,"Low"]
[10.1,"Medium"]
[11.1,"High"]
[12.1,"Very High"]

{"sheet":"Equipment_list","index":7,"n_rows":21,"n_cols":2,"rows_kept":21,"cut":false,"hidden":true,"merged":[]}
["Equipment_list","Equipment_list_description"]
["Main Engine ","ME = Main Engine "]
["Aux. Engine","AE = Auxiliary Engine"]
[" Boiler","BLR = Boilers"]
["Purifier","PFR = Purifiers"]
["Aux. Mach.","AUX = Auxiliary Machineries (Pumps, MGPS, sanitary system, domestic water system, viscotherm, temperature & pressure controller, heat exchangers etc)"]
["Air Comp.","COMP = Air compressor"]
["ER Pipe / Fittings","ER PIPE / FITGS = Pipes, valves and fittings"]
["Elect. Mach. & Equip.","ELEC - Electrical Machinery & Equipment (Motor, electrical panel, cabling)"]
[" Nav. & Comm. Equip.","NAV = Navigation & communication equipment"]
["Accommodation ","ACM = Accommodation "]
[" Cargo Mach.","CARGO MCRY = Cargo Machineries (Cargo pump, Cargo pump turbines, AUS, Stripping pump, PV Valves, Eductor, COW machine, Cargo Valves etc)"]
[" Inert Gas","IG = Inert Gas System"]
["Mooring Mach.","MRNG MCRY = Windlass & Mooring Machinery"]
["Critical Equip.","CRIT = Critical Equipment"]
["LSA / FFA","LSA/FFA/SFTY = Life Saving, Fire Fighting and Safety Equipment"]
["Deck Mach.","DK MCRY = Deck Machinery (Gangway & drive motor, Pilot ladder, cranes etc.)"]
["Hull & Tanks","HULL = Hull & Tanks"]
[" Deck Pipe / Fittings","DK PIPE / FTGS = Deck Pipe & Fittings"]
["Documentation","DOC = Documentation"]
["Miscellaneous","MISC = Miscellaneous"]

{"sheet":"PSC_MOU","index":8,"n_rows":11,"n_cols":2,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
["PSC_MOU","PSC_MOU_description"]
["Europe and the north Atlantic ","Paris MoU = Europe and the north Atlantic "]
["Asia and the Pacific ","Tokyo MoU = Asia and the Pacific "]
["Latin America","Vina del Mar MoU = Latin America"]
["Caribbean","Caribbean MoU = Caribbean"]
["West and Central Africa","Abuja MoU = West and Central Africa"]
["The Black Sea region","Black Sea MoU = The Black Sea region"]
["The Mediterranean","Mediterranean MoU = The Mediterranean"]
["The Indian Ocean","Indian Ocean MoU = The Indian Ocean"]
["The Riyadh MoU","Riyadh MoU = The Riyadh MoU"]
["The United States Coast Guard","USCG = The United States Coast Guard"]

{"sheet":"Inspection_type","index":9,"n_rows":12,"n_cols":1,"rows_kept":12,"cut":false,"hidden":true,"merged":[]}
["Inspectiontype"]
["ISM Audit"]
["MLC Audit"]
["ISPS Audit"]
["PSC Inspection"]
["Flag State Inspection"]
["OM Inspection (SIRE / CDI etc.)"]
["Navigation Audit / Verification"]
["Ship Staff Inspection"]
["IT Audit"]
["Terminal Inspection"]
["Others (Such as Green Award, Insurance etc.)"]

{"sheet":"Deficiency_Cause","index":10,"n_rows":8,"n_cols":2,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
["Deficiency_Cause","Deficiency_Cause_description"]
["Behaviour Based"]
["Knowledge Based"]
["Equipment Related"]
["External Factors"]
["Industry Issue"]
["Human Error"]
["Inappropriate Procedure  "]

{"sheet":"Observer_code","index":11,"n_rows":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
["Observer_code","Observer_code_description"]
["Class Surveyor","CL = 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)"]
["Flag State Insp.","FSC = Flag State Control (During flag state inspections the inspector might have some observations / remarks.)"]
[" Port State Insp.","PSC = 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 column Description of “Target date.”)"]
["Terminal Insp.","TER = Terminal remarks (Nowadays terminals might also audit your vessel and make some remarks / observations.)"]
["SIRE / CDI Insp.","OM = SIRE / CDI (Oil Majors vetting & CDI inspection remarks )"]
["Others","Others (Such as Green Award, Insurance etc.)"]
["Ships staff","Add this Item to the internal section"]
["Superintendent","Add this Item to the internal section"]
["Owner Superintendent"]

{"sheet":"Status_code","index":12,"n_rows":6,"n_cols":2,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
["Status_code","Status_code_description"]
["Not Started","NS = Not Started (Whenever an observation is made it has to be entered with this code.) Autofill NS for any new deficiency raised with an option so that the user may change the code."]
[" In progress","IP = In-progress (Whenever a job has started then the code has to be changed from “NS” to “IP”. Note that some jobs might take a long time before they are completed i.e. de-rusting and painting of a dedicated area on board. With this code everybody knows that the job has been started and is in progress.)"]
["Waiting spares","WS = Waiting spare parts (For many jobs you might require spare parts before you actually can start the job. If this is the case then the code “WS” has to be used.)"]
["Deferred to DD","DD = Deferred to dry-dock. (Some deficiencies / observations cannot be solved on board and need to be carried out in dry-dock. These deficiencies have to be recorded with the code “DD”. This is also a good tool to continuously update the dry-dock list. It doesn’t mean that the dry-dock requisition has to be made immediately but it will remember us that we don’t forget the job when we are going to start the preparation for the dry-dock specification. Note that during the course of a certain period sometimes a job that was deferred to dry-dock can be solved on board, then this code has to be changed to the status: “CP”)"]
["Completed","CP = Completed (Whenever a job is completed the status code has to be changed to “CP”)"]

{"sheet":"PSC_ref_no","index":13,"n_rows":19,"n_cols":1,"rows_kept":19,"cut":false,"hidden":true,"merged":[]}
["PSC reference number"]
["01 - Certificates & Documentation"]
["02 - Structural condition"]
["03 - Water/Weathertight condition"]
["04 - Emergency Systems"]
["05 - Radio communication"]
["06 - Cargo operations including equipment"]
["07 - Fire safety"]
["08 – Alarms"]
["09 - Working and Living Conditions "]
["10 - Safety of Navigation"]
["11 - Life saving appliances"]
["12 - Dangerous Goods"]
["13 - Propulsion and auxiliary machinery"]
["14 - Pollution Prevention "]
["15 – ISM"]
["16 - ISPS"]
["18 - MLC, 2006"]
["99  – Other"]

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

{"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":"Sheet2","index":19,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Ship_information","index":20,"n_rows":1,"n_cols":3,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["Ship_ID","Ship_Name","FILE_NAME"]