{"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":2,"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":22,"n_cols":28,"rows_kept":22,"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","2022-09-30",null,null,"Ship Name","DHT JAGUAR (30-09-2022)"]
[]
[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,10751,"58_23/02/2020 6:45:34 PM","2022-09-16","Defect","Ship Staff","Ship Staff Insp.","ME WATER IN SENSOR MALFUNCTIONING","E/R - Main Engine","Eng. / Strg. Comp.","Equipment Related",10.32," High",null,null,"Communication with the Office is in Progress","2022-10-20",null,"In Progress",null,"No","No ","No","Internal"]
[null,null,null,null,15437,"58_Thu Dec 03 2020 05:59:00 GMT+0000","2022-09-20","Defect","Ship Staff","Ship Staff Insp.","#2 P COT SAAB RADAR unit TGE unit Malfunctioning","Cargo Mach.","Cargo / Ballast Systems","Equipment Related","8.26"," High",null,null,"Triouble shooting carried out in consulation with Office and Req has been raised for TGE Unit","2022-10-20","DJAG225059","Waiting  Spare",null,"No","No ","No","Internal"]
[null,null,null,null,14722,"58_14/11/2020 6:44:58 AM","2022-09-25","Defect","Ship Staff","Ship Staff Insp.","SEWAGE Treatment Plant Circulation Pump Not working","E/R - Main Engine","Eng. / Strg. Comp.","Equipment Related",10.32," High",null,null,"Dismantled the Pump and noted that impeller and shaft were eroded . Req raised for spare Pump .","2022-10-20","DJAG-220195 ","Waiting  Spare",null,"No","No ","No","Internal"]
[null,null,null,null,15438,"58_Thu Dec 03 2020 06:05:58 GMT+0000"]
[null,null,null,null,null,"58_24/12/2020 10:46:51 AM"]

{"sheet":"Completed","index":1,"n_rows":182,"n_cols":28,"rows_kept":182,"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","2022-09-30",null,null,"Ship Name","DHT JAGUAR (30-09-2022)"]
[]
[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,9250,"58_25/12/2019 7:14:42 AM","2022-05-31","Defect","Ship Staff","Ship Staff Insp.","NO.2 Steering Gear Janney Pump has a minor leak from by-pass valve flange, transfer valve spindle and pump end flange.","E/R - Aux. Mach.","Eng. / Strg. Comp.","Equipment Related","10.32","Very High",null,null,"Ivestigation report sent to Office, and planned to carry out this job in dry dock","2022-10-31",null,"Completed","2022-09-26","YES","No","No"]
[null,null,null,null,9251,"58_25/12/2019 7:20:51 AM","2022-06-15","Observation","Owner / Marine / Tech. Suptd.","Suptd. Insp.","Many Cargo Oil Tanks’ opening, their hatch cover & coaming are rusting.","Deck - Pipe / Fittings","General Appearance","Equipment Related","11.6","Medium","",""," Cargo Oil Tanks’ opening, their hatch cover & coaming  derusting and painting carried out.","2022-09-30",null,"Completed","2022-09-29","No","No","No"]
[null,null,null,null,9266,"58_26/12/2019 4:45:20 AM","2022-08-22","Observation","SIRE / CDI Insp.","OM Insp. (Eg. SIRE / CDI etc.)","Around 50 % of Grating on midship manifold (Both side) were Observed with paint peeled off and rusted.","Deck - Pipe / Fittings","General Appearance","Equipment Related","11.6","Medium",null,null,"Gratings on both the sides derusting carrie out and painted.","2022-09-30",null,"Completed","2022-09-18","No","No","No"]
[null,null,null,null,9267,"58_26/12/2019 4:48:56 AM"]
[null,null,null,null,9268,"58_26/12/2019 4:51:34 AM"]
[null,null,null,null,511,"58_Thu Oct 10 2019 13:59:43 GMT+0000"]
[null,null,null,null,9258,"58_26/12/2019 4:12:30 AM"]
[null,null,null,null,9259,"58_26/12/2019 4:17:05 AM"]
[null,null,null,null,9260,"58_26/12/2019 4:23:09 AM"]
[null,null,null,null,9261,"58_26/12/2019 4:26:30 AM"]
[null,null,null,null,9262,"58_26/12/2019 4:29:21 AM"]
[null,null,null,null,9263,"58_26/12/2019 4:32:20 AM"]
[null,null,null,null,9264,"58_26/12/2019 4:36:04 AM"]
[null,null,null,null,9265,"58_26/12/2019 4:40:24 AM"]
[null,null,null,null,9249,"58_25/12/2019 7:11:02 AM"]
[null,null,null,null,9252,"58_25/12/2019 7:27:49 AM"]
[null,null,null,null,481,"58_Tue Sep 10 2019 18:48:30 GMT+0000"]
[null,null,null,null,482,"58_Wed Oct 09 2019 18:55:26 GMT+0000"]
[null,null,null,null,492,"58_Thu Oct 10 2019 05:07:32 GMT+0000"]
[null,null,null,null,498,"58_Thu Oct 10 2019 11:37:18 GMT+0000"]
[null,null,null,null,499,"58_Thu Oct 10 2019 12:32:46 GMT+0000"]
[null,null,null,null,500,"58_Thu Oct 10 2019 12:37:30 GMT+0000"]
[null,null,null,null,501,"58_Thu Oct 10 2019 12:42:38 GMT+0000"]
[null,null,null,null,483,"58_Tue Sep 10 2019 19:09:00 GMT+0000"]
[null,null,null,null,502,"58_Thu Oct 10 2019 12:47:05 GMT+0000"]
[null,null,null,null,505,"58_Thu Oct 10 2019 12:58:35 GMT+0000"]
[null,null,null,null,516,"58_Thu Oct 10 2019 14:15:52 GMT+0000"]
[null,null,null,null,503,"58_Thu Oct 10 2019 12:51:25 GMT+0000"]
[null,null,null,null,504,"58_Thu Oct 10 2019 12:54:50 GMT+0000"]
[null,null,null,null,506,"58_Thu Oct 10 2019 13:02:02 GMT+0000"]
[null,null,null,null,507,"58_Thu Oct 10 2019 13:05:55 GMT+0000"]
[null,null,null,null,508,"58_Thu Oct 10 2019 13:48:45 GMT+0000"]
[null,null,null,null,484,"58_Tue Sep 10 2019 19:13:05 GMT+0000"]
[null,null,null,null,495,"58_Thu Oct 10 2019 05:42:45 GMT+0000"]
[null,null,null,null,9246,"58_25/12/2019 6:53:04 AM"]
[null,null,null,null,9247,"58_25/12/2019 6:58:56 AM"]
[null,null,null,null,9248,"58_25/12/2019 7:05:29 AM"]
[null,null,null,null,474,"58_Thu Oct 10 2019 06:12:35 GMT+0000"]
[null,null,null,null,485,"58_Tue Sep 10 2019 19:20:05 GMT+0000"]
[null,null,null,null,486,"58_Tue Sep 10 2019 19:24:22 GMT+0000"]
[null,null,null,null,487,"58_Wed Oct 09 2019 19:29:41 GMT+0000"]
[null,null,null,null,491,"58_Thu Oct 10 2019 05:01:00 GMT+0000"]
[null,null,null,null,509,"58_Thu Oct 10 2019 13:52:45 GMT+0000"]
[null,null,null,null,510,"58_Thu Oct 10 2019 13:55:47 GMT+0000"]
[null,null,null,null,489,"58_Tue Sep 10 2019 19:42:55 GMT+0000"]
[null,null,null,null,488,"58_Tue Sep 10 2019 19:37:53 GMT+0000"]
[null,null,null,null,512,"58_Thu Oct 10 2019 14:02:48 GMT+0000"]
[null,null,null,null,513,"58_Thu Oct 10 2019 14:05:46 GMT+0000"]
[null,null,null,null,514,"58_Thu Oct 10 2019 14:08:25 GMT+0000"]
[null,null,null,null,493,"58_Thu Oct 10 2019 05:16:51 GMT+0000"]
[null,null,null,null,515,"58_Thu Oct 10 2019 14:11:55 GMT+0000"]
[null,null,null,null,494,"58_Thu Oct 10 2019 05:27:02 GMT+0000"]
[null,null,null,null,490,"58_Thu Oct 10 2019 04:51:16 GMT+0000"]
[null,null,null,null,9341,"58_Thu Jan 02 2020 05:02:52 GMT+0000"]
[null,null,null,null,9342,"58_Thu Jan 02 2020 05:06:00 GMT+0000"]
[null,null,null,null,9343,"58_Thu Jan 02 2020 05:10:15 GMT+0000"]
[null,null,null,null,9344,"58_Thu Jan 02 2020 05:12:34 GMT+0000"]
[null,null,null,null,9345,"58_Thu Jan 02 2020 05:14:30 GMT+0000"]
[null,null,null,null,9346,"58_Thu Jan 02 2020 05:17:35 GMT+0000"]
[null,null,null,null,9347,"58_Thu Jan 02 2020 05:19:28 GMT+0000"]
[null,null,null,null,9348,"58_Thu Jan 02 2020 05:22:47 GMT+0000"]
[null,null,null,null,9349,"58_Thu Jan 02 2020 05:25:28 GMT+0000"]
[null,null,null,null,475,"58_Thu Oct 10 2019 10:44:16 GMT+0000"]
[null,null,null,null,476,"58_Thu Oct 10 2019 10:49:57 GMT+0000"]
[null,null,null,null,9245,"58_25/12/2019 6:45:09 AM"]
[null,null,null,null,5714,"58_2019-11-04 11:59:51.999"]
[null,null,null,null,477,"58_Thu Oct 10 2019 10:52:56 GMT+0000"]
[null,null,null,null,9257,"58_26/12/2019 4:06:50 AM"]
[null,null,null,null,478,"58_Thu Oct 10 2019 10:56:21 GMT+0000"]
[null,null,null,null,479,"58_Thu Oct 10 2019 11:00:54 GMT+0000"]
[null,null,null,null,496,"58_Thu Oct 10 2019 05:48:54 GMT+0000"]
[null,null,null,null,497,"58_Thu Oct 10 2019 11:31:14 GMT+0000"]
[null,null,null,null,480,"58_Thu Oct 10 2019 11:03:34 GMT+0000"]
[null,null,null,null,7268,"58_43770.4895023032"]
[null,null,null,null,6716,"58_15/11/2019 5:26:40 PM"]
[null,null,null,null,6719,"58_20/11/2019 9:18:20 AM"]
[null,null,null,null,6720,"58_20/11/2019 9:04:11 AM"]
[null,null,null,null,6721,"58_20/11/2019 9:25:47 AM"]
[null,null,null,null,6722,"58_21/11/2019 3:41:16 PM"]
[null,null,null,null,6723,"58_21/11/2019 5:51:08 PM"]
[null,null,null,null,6724,"58_21/11/2019 5:56:03 PM"]
[null,null,null,null,6725,"58_21/11/2019 6:00:33 PM"]
[null,null,null,null,6726,"58_21/11/2019 6:04:22 PM"]
[null,null,null,null,6727,"58_21/11/2019 6:08:22 PM"]
[null,null,null,null,6728,"58_21/11/2019 6:12:38 PM"]
[null,null,null,null,6729,"58_21/11/2019 6:15:41 PM"]
[null,null,null,null,6718,"58_20/11/2019 9:12:59 AM"]
[null,null,null,null,6717,"58_20/11/2019 9:08:26 AM"]
[null,null,null,null,9253,"58_26/12/2019 3:44:29 AM"]
[null,null,null,null,9254,"58_26/12/2019 3:48:39 AM"]
[null,null,null,null,9255,"58_26/12/2019 3:56:35 AM"]
[null,null,null,null,9256,"58_26/12/2019 4:02:08 AM"]
[null,null,null,null,7025,"58_26/11/2019 4:08:26 PM"]
[null,null,null,null,7027,"58_28/11/2019 4:24:50 PM"]
[null,null,null,null,9244,"58_26/12/2019 5:05:47 AM"]
[null,null,null,null,9269,"58_26/12/2019 4:57:18 AM"]
[null,null,null,null,9270,"58_26/12/2019 5:00:18 AM"]
[null,null,null,null,9271,"58_26/12/2019 5:02:31 AM"]
[null,null,null,null,9460,"58_08/01/2020 5:26:43 AM"]
[null,null,null,null,9242,"58_25/12/2019 3:45:27 AM"]
[null,null,null,null,9243,"58_25/12/2019 3:50:33 AM"]
[null,null,null,null,9456,"58_08/01/2020 3:40:06 AM"]
[null,null,null,null,9457,"58_08/01/2020 4:13:34 AM"]
[null,null,null,null,9455,"58_08/01/2020 3:51:40 AM"]
[null,null,null,null,9458,"58_07/01/2020 4:51:11 PM"]
[null,null,null,null,9459,"58_07/01/2020 5:05:51 PM"]
[null,null,null,null,9669,"58_14/01/2020 5:32:13 AM"]
[null,null,null,null,9670,"58_15/01/2020 11:29:21 AM"]
[null,null,null,null,10334,"58_01/02/2020 11:28:52 PM"]
[null,null,null,null,10547,"58_08/02/2020 5:29:07 PM"]
[null,null,null,null,11588,"58_30/04/2020 7:57:38 PM"]
[null,null,null,null,10752,"58_07/03/2020 2:19:39 PM"]
[null,null,null,null,10986,"58_17/03/2020 2:04:26 PM"]
[null,null,null,null,10987,"58_28/03/2020 11:49:50 AM"]
[null,null,null,null,10988,"58_28/03/2020 1:25:53 PM"]
[null,null,null,null,10989,"58_28/03/2020 1:39:22 PM"]
[null,null,null,null,10990,"58_28/03/2020 1:58:02 PM"]
[null,null,null,null,11409,"58_14/04/2020 5:46:41 PM"]
[null,null,null,null,11410,"58_14/04/2020 6:12:04 PM"]
[null,null,null,null,11586,"58_20/04/2020 5:01:34 PM"]
[null,null,null,null,11587,"58_29/04/2020 1:44:39 AM"]
[null,null,null,null,11590,"58_28/04/2020 9:18:50 PM"]
[null,null,null,null,11591,"58_28/04/2020 9:11:47 PM"]
[null,null,null,null,11592,"58_30/04/2020 8:10:11 PM"]
[null,null,null,null,11952,"58_30/05/2020 11:16:36 AM"]
[null,null,null,null,11828,"58_09/05/2020 8:12:24 AM"]
[null,null,null,null,11829,"58_15/05/2020 6:11:59 AM"]
[null,null,null,null,11830,"58_14/05/2020 2:18:16 PM"]
[null,null,null,null,11951,"58_31/05/2020 8:55:13 AM"]
[null,null,null,null,12715,"58_15/06/2020 9:34:11 AM"]
[null,null,null,null,12716,"58_14/06/2020 9:37:46 AM"]
[null,null,null,null,13200,"58_Wed Jul 22 2020 01:10:25 GMT+0000"]
[null,null,null,null,13243,"58_22/07/2020 7:41:30 AM"]
[null,null,null,null,13241,"58_22/07/2020 7:37:43 AM"]
[null,null,null,null,13242,"58_28/07/2020 11:54:03 AM"]
[null,null,null,null,14723,"58_19/10/2020 12:45:38 AM"]
[null,null,null,null,13881,"58_02/09/2020 5:06:43 PM"]
[null,null,null,null,13882,"58_02/09/2020 5:09:48 PM"]
[null,null,null,null,13883,"58_02/09/2020 6:27:06 PM"]
[null,null,null,null,13884,"58_02/09/2020 6:37:31 PM"]
[null,null,null,null,13885,"58_02/09/2020 6:30:57 PM"]
[null,null,null,null,13886,"58_02/09/2020 6:33:57 PM"]
[null,null,null,null,13887,"58_02/09/2020 6:48:16 PM"]
[null,null,null,null,13888,"58_02/09/2020 6:40:41 PM"]
[null,null,null,null,13889,"58_02/09/2020 6:22:52 PM"]
[null,null,null,null,14026,"58_16/09/2020 12:07:18 AM"]
[null,null,null,null,null,"58_24/12/2020 10:39:59 AM"]
[null,null,null,null,14027,"58_20/09/2020 4:22:37 AM"]
[null,null,null,null,14028,"58_20/09/2020 4:25:28 AM"]
[null,null,null,null,14029,"58_16/09/2020 12:17:17 AM"]
[null,null,null,null,14025,"58_16/09/2020 5:56:08 PM"]
[null,null,null,null,14151,"58_04/10/2020 5:03:03 PM"]
[null,null,null,null,14724,"58_08/10/2020 10:27:03 PM"]
[null,null,null,null,14725,"58_23/10/2020 12:52:10 PM"]
[null,null,null,null,14726,"58_09/11/2020 5:30:55 PM"]
[null,null,null,null,14727,"58_09/11/2020 5:34:35 PM"]
[null,null,null,null,14728,"58_09/11/2020 5:37:34 PM"]
[null,null,null,null,14729,"58_14/11/2020 6:51:03 AM"]
[null,null,null,null,15439,"58_Thu Dec 03 2020 06:13:17 GMT+0000"]
[null,null,null,null,15619,"58_06/12/2020 5:25:06 PM"]
[null,null,null,null,15620,"58_06/12/2020 5:18:33 PM"]
[null,null,null,null,15621,"58_12/12/2020 6:52:36 AM"]
[null,null,null,null,null,"58_24/12/2020 10:51:56 AM"]
[null,null,null,null,null,"58_24/12/2020 10:57:26 AM"]
[null,null,null,null,null,"58_30/12/2020 11:46:58 AM"]

{"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":427,"n_cols":3,"rows_kept":427,"cut":false,"hidden":true,"merged":[]}
["VIQ_ref_no","Risk Value of observation","ID"]
["1.1","Low",8243]
["1.10","Low",8252]
["1.11","Low",8253]
["1.12","Low",8254]
["1.13","Low",8255]
["1.14","Low",8256]
["1.15","Low",8257]
["1.16","Low",8259]
["1.17","Low",8260]
["1.18","Low",8261]
["1.19","Low",8262]
["1.2","Low",8244]
["1.20","Low",8263]
["1.21","Low",8265]
["1.22","Low",8266]
["1.23","Low",8267]
["1.24","Low",8268]
["1.25","Low",8269]
["1.26","Low",8270]
["1.3","Low",8245]
["1.4","Low",8246]
["1.5","Low",8247]
["1.6","Low",8248]
["1.7","Low",8249]
["1.8","Low",8250]
["1.9","Low",8251]
["1.99","High",11258]
["10.1","Medium",8461]
["10.10","High",8470]
["10.11","Medium",8471]
["10.12","Very High",8472]
["10.13","Very High",8473]
["10.14","Medium",8474]
["10.15","Low",8475]
["10.16","Very High",8476]
["10.17","Very High",8477]
["10.18","High",8478]
["10.19","Very High",8479]
["10.2","Low",8462]
["10.20","High",8480]
["10.21","Medium",8481]
["10.22","Low",8482]
["10.23","Medium",8483]
["10.24","Low",8484]
["10.25","Very High",8485]
["10.26","High",8486]
["10.27","Medium",8487]
["10.28","Low",8488]
["10.29","Medium",8489]
["10.3","Medium",8463]
["10.30","High",8490]
["10.31","Very High",8491]
["10.32","Very High",8492]
["10.33","High",8493]
["10.34","High",8494]
["10.35","Very High",8495]
["10.36","Very High",8496]
["10.37","Medium",8497]
["10.38","Medium",8498]
["10.39","High",8499]
["10.4","High",8464]
["10.40","Medium",8500]
["10.41","Medium",8501]
["10.42","Medium",8502]
["10.43","Medium",8503]
["10.44","Medium",8504]
["10.45","Very High",8505]
["10.46","High",8506]
["10.47","Medium",8507]
["10.48","High",8508]
["10.49","Medium",8509]
["10.5","Low",8465]
["10.50","High",8510]
["10.51","Low",8511]
["10.52","Medium",8512]
["10.53","Medium",8513]
["10.54","High",8514]
["10.55","Low",8515]
["10.6","Very High",8466]
["10.7","Medium",8467]
["10.8","Medium",8468]
["10.9","Medium",8469]
["10.99","High",8516]
["11.1","High",8420]
["11.10","Medium",8429]
["11.11","Very High",8430]
["11.12","Low",8431]
["11.13","Low",8432]
["11.14","Medium",8433]
["11.15","Low",8434]
["11.16","Low",8435]
["11.17","Low",8436]
["11.2","Medium",8421]
["11.3","Medium",8422]
["11.4","Very High",8423]
["11.5","Medium",8424]
["11.6","Medium",8425]
["11.7","High",8426]
["11.8","Low",8427]
["11.9","Low",8428]
["11.99","High",8437]
["12.1","High",8438]
["12.10","High",8448]
["12.11","High",8449]
["12.12","High",8450]
["12.13","High",8451]
["12.14","High",8452]
["12.15","High",8453]
["12.16","High",8454]
["12.17","High",8455]
["12.18","High",8456]
["12.19","High",8457]
["12.2","High",8439]
["12.20","High",8458]
["12.21","High",8459]
["12.3","High",8441]
["12.4","High",8442]
["12.5","High",8443]
["12.6","High",8444]
["12.7","High",8445]
["12.8","High",8446]
["12.9","High",8447]
["12.99","High",8460]
["2.1","Very High",8296]
["2.1.9","Very High",11259]
["2.10","Medium",8304]
["2.11","Medium",8305]
["2.12","Low",8306]
["2.13","Low",8307]
["2.14","Low",8308]
["2.15","Low",8309]
["2.16","Medium",8310]
["2.2","Medium",8297]
["2.3","High",8295]
["2.4","Medium",8298]
["2.5","Medium",8299]
["2.6","Low",8300]
["2.7","High",8301]
["2.8","High",8302]
["2.9","Medium",8303]
["2.99","High",8311]
["3.1","High",8312]
["3.2","Very High",8313]
["3.3","High",8314]
["3.4","Low",8294]
["3.5","Medium",8315]
["3.6","High",8316]
["3.7","Very High",8317]
["3.8","Very High",8318]
["3.99","High",8319]
["4.1","High",8320]
["4.10","High",8329]
["4.11","Medium",8330]
["4.12","Very High",8331]
["4.13","Very High",8332]
["4.14","Very High",8333]
["4.15","Very High",8334]
["4.16","Very High",8335]
["4.17","Very High",8336]
["4.18","Very High",8337]
["4.19","Low",8338]
["4.2","Medium",8321]
["4.20","Very High",8339]
["4.21","High",8340]
["4.22","Low",8341]
["4.23","High",8342]
["4.24","High",8343]
["4.25","Low",8344]
["4.26","Low",8345]
["4.27","High",8346]
["4.3","Medium",8322]
["4.4","High",8323]
["4.5","Very High",8324]
["4.6","Medium",8325]
["4.7","High",8326]
["4.8","Medium",8327]
["4.9","Medium",8328]
["4.99","High",8347]
["5.1","Very High",8517]
["5.10","High",8526]
["5.11","Low",8527]
["5.12","Medium",8528]
["5.13","High",8529]
["5.14","Very High",8530]
["5.15","Medium",8531]
["5.16","Very High",8532]
["5.17","Very High",8533]
["5.18","High",8534]
["5.19","Medium",8535]
["5.2","Very High",8518]
["5.20","Medium",8536]
["5.21","Medium",8537]
["5.22","High",8539]
["5.23","Very High",8540]
["5.24","Very High",8541]
["5.25","Medium",8542]
["5.26","Medium",8543]
["5.27","Medium",8544]
["5.28","Very High",8545]
["5.29","High",8546]
["5.3","Low",8519]
["5.30","High",8547]
["5.31","High",8548]
["5.32","High",8549]
["5.33","High",8550]
["5.34","Low",8551]
["5.35","Medium",8552]
["5.36","Low",8553]
["5.37","Low",8554]
["5.38","High",8555]
["5.39","Very High",8556]
["5.4","High",8520]
["5.40","Very High",8557]
["5.41","Very High",8558]
["5.42","Medium",8559]
["5.43","High",8560]
["5.44","High",8561]
["5.45","Medium",8564]
["5.46","Medium",8565]
["5.47","Medium",8566]
["5.48","Medium",8567]
["5.5","Low",8521]
["5.6","Low",8522]
["5.7","Medium",8523]
["5.8","Medium",8524]
["5.9","Very High",8525]
["5.99","High",8568]
["6.1","Medium",8348]
["6.10","Low",8357]
["6.11","High",8358]
["6.12","Medium",8359]
["6.13","Low",8360]
["6.14","High",8361]
["6.15","High",8362]
["6.16","Very High",8363]
["6.17","Very High",8364]
["6.18","Medium",8365]
["6.19","Low",8366]
["6.2","High",8349]
["6.20","Medium",8367]
["6.21","High",8368]
["6.22","Medium",8369]
["6.3","Low",8350]
["6.4","High",8351]
["6.5","Medium",8352]
["6.6","Medium",8353]
["6.7","High",8354]
["6.8","High",8355]
["6.9","Low",8356]
["6.99","High",8370]
["7.1","High",8371]
["7.10","High",8380]
["7.11","High",8381]
["7.12","High",8382]
["7.13","Medium",8383]
["7.14","Medium",8384]
["7.15","High",8385]
["7.16","High",8386]
["7.17","High",8387]
["7.2","High",8372]
["7.3","Low",8373]
["7.4","Low",8374]
["7.5","Low",8375]
["7.6","Medium",8376]
["7.7","Low",8377]
["7.8","High",8378]
["7.9","High",8379]
["7.99","High",8388]
["8.1","Very High",8569]
["8.10","Very High",8578]
["8.100","Low",11227]
["8.101","Medium",11228]
["8.102","Low",11229]
["8.103","Low",11230]
["8.104","Low",11231]
["8.105","Medium",11232]
["8.106","Medium",11233]
["8.107","Low",11234]
["8.108","High",11235]
["8.109","Very High",11236]
["8.11","Medium",8579]
["8.110","High",11237]
["8.111","Medium",11238]
["8.112","High",11239]
["8.113","Medium",11240]
["8.114","Low",11241]
["8.115","High",11242]
["8.116","Medium",11243]
["8.117","Medium",11244]
["8.118","Medium",11245]
["8.119","High",11246]
["8.12","Medium",8580]
["8.120","High",11247]
["8.121","Medium",11248]
["8.122","High",11249]
["8.123","High",11250]
["8.124","Low",11251]
["8.125","High",11252]
["8.126","Medium",11253]
["8.127","Medium",11254]
["8.13","Medium",8581]
["8.14","Very High",8582]
["8.15","High",8583]
["8.16","Very High",8584]
["8.17","Low",8585]
["8.18","High",8586]
["8.19","High",8587]
["8.199","High",11255]
["8.2","Medium",8570]
["8.20","Medium",8588]
["8.21","High",8589]
["8.22","Very High",8590]
["8.23","Medium",8591]
["8.24","Medium",8592]
["8.25","Very High",8593]
["8.26","High",8594]
["8.27","Medium",8595]
["8.28","Medium",8596]
["8.29","High",8598]
["8.3","Very High",8571]
["8.30","High",8599]
["8.31","High",8600]
["8.32","Low",8601]
["8.33","Medium",8602]
["8.34","High",8603]
["8.35","Medium",8604]
["8.36","Medium",8605]
["8.37","High",8607]
["8.38","Medium",8608]
["8.39","Medium",8609]
["8.4","Medium",8572]
["8.40","High",8610]
["8.41","Medium",8611]
["8.42","Medium",8612]
["8.43","Very High",8613]
["8.44","High",8615]
["8.45","High",8616]
["8.46","Very High",8617]
["8.47","Very High",8618]
["8.48","Medium",8619]
["8.49","High",8620]
["8.5","Very High",8573]
["8.50","Medium",8621]
["8.51","Low",8622]
["8.52","Low",8623]
["8.53","Low",8624]
["8.54","High",8625]
["8.55","Low",11182]
["8.56","Medium",11183]
["8.57","Medium",11184]
["8.58","High",11185]
["8.59","High",11186]
["8.6","Medium",8574]
["8.60","High",11187]
["8.61","Medium",11188]
["8.62","Very High",11189]
["8.63","High",11190]
["8.64","Medium",11191]
["8.65","Low",11192]
["8.66","High",11193]
["8.67","High",11194]
["8.68","High",11195]
["8.69","Medium",11196]
["8.7","High",8575]
["8.70","Medium",11197]
["8.71","Very High",11198]
["8.72","Medium",11199]
["8.73","Medium",11200]
["8.74","High",11201]
["8.75","Medium",11202]
["8.76","Medium",11203]
["8.77","Medium",11204]
["8.78","Medium",11205]
["8.79","Medium",11206]
["8.8","Medium",8576]
["8.80","Medium",11207]
["8.81","Low",11208]
["8.82","Medium",11209]
["8.83","Low",11210]
["8.84","Low",11211]
["8.85","Medium",11212]
["8.86","Medium",11213]
["8.87","Medium",11214]
["8.88","Low",11215]
["8.89","High",11216]
["8.9","High",8577]
["8.90","High",11217]
["8.91","High",11218]
["8.92","Medium",11219]
["8.93","Low",11220]
["8.94","Low",11221]
["8.95","Medium",11222]
["8.96","Medium",11223]
["8.97","Low",11224]
["8.98","High",11225]
["8.99","Medium",11226]
["9.1","Low",8390]
["9.10","Medium",8399]
["9.11","Medium",8400]
["9.12","Medium",8401]
["9.13","Low",8402]
["9.14","Medium",8403]
["9.15","Medium",8404]
["9.16","High",8405]
["9.17","High",8406]
["9.18","Low",8407]
["9.19","Low",8408]
["9.2","Very High",8391]
["9.20","Medium",8409]
["9.21","Medium",8410]
["9.22","Low",8411]
["9.23","Low",8412]
["9.24","Medium",8413]
["9.25","Low",8414]
["9.26","Low",8415]
["9.27","Low",8416]
["9.28","Medium",8417]
["9.29","Low",8418]
["9.3","Very High",8392]
["9.4","High",8393]
["9.5","High",8394]
["9.6","Low",8395]
["9.7","Medium",8396]
["9.8","Medium",8397]
["9.9","Medium",8398]
["9.99","High",8419]

{"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"]
["58","DHT TIGER (15-12-2020)","58_1608077920791.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"]