{"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":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","12-Jun-2021",null,null,"Ship Name","BLACK SWAN"]
[]
[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,null,"119_8/4/2021 1:42:34 PM","2021-07-21","Defect","Ship Staff","Ship Staff Insp.","3S COT STRIP V/V NO. 332 VCO NOT HOLDING. CCR INDICATOR IS SHOWING V/V SHUT AND DECK BOX NO. 2 INDICATOR ALSO SHOWING SHUT","Deck - Pipe / Fittings","Cargo / Ballast Systems","Equipment Related",null,null,"Not Applicable","Not Applicable","INSPECT VALVE/ RENEW SEAT","2021-01-10",null,"Deferred to D D",null,"Yes",null,null,"Internal"]
[null,null,null,null,null,"119_8/7/2021 4:45:11 PM","2021-06-06","Defect","Ship Staff","Ship Staff Insp.","BRIDGE SPLIT TYPE AC NOT OPERATIONAL","Miscellaneous","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Raised RO for Capacitor on 25-June-2021","2022-11-01",null,"Waiting spare",null,"No",null,null,"Internal"]
[null,null,null,null,null,"119_8/8/2021 12:43:54 PM","2021-06-06","Observation","Ship Staff","Ship Staff Insp.","AE UNABLE TO AUTO LOAD SHARE AND AUTO ACB CLOSE","E/R - Aux. Engine","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Further inspection by shore personnel","2021-01-11",null,"Deferred to D D",null,"Yes",null,null,"Internal"]
[null,null,null,null,null,"119_8/8/2021 1:00:22 PM","2021-06-14","Observation","Ship Staff","Ship Staff Insp.","AE NO.1 FREQUENCY GOING DOWN TO 59.5 AT 85% LOAD. AE NO.2 TC SURGING AT 85% LOAD. LO LEAK ON AE1 & AE 2 CRANKSHAFT END COVER","E/R - Aux. Engine","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","AE NO.1 SCHEDULED FOR OVERHAUL. AE NO.2 TC TO BE OVERHAULED. COVER TO REPLACE WITH NEW GASKET","2022-01-11",null,"Deferred to D D",null,"Yes",null,null,"Internal"]
[null,null,null,null,null,"119_8/8/2021 1:22:12 PM","2021-06-15","Defect","Ship Staff","Ship Staff Insp.","Reefer System Freon Leak","Miscellaneous","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Leak checked whole system using sopa suds but leak location cannot be identified. Requested for Freon Leak Detector Equipment.","2021-01-11",null,"Waiting spare",null,"No",null,null,"Internal"]
[null,null,null,null,null,"119_8/7/2021 4:58:16 PM","2021-07-07","Defect","Ship Staff","Ship Staff Insp.","AC COMPRESSOR SOLENOID VALVE DEFECTIVE","Miscellaneous","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Raised Requisition order on 06-July-2021","2022-01-02",null,"Waiting spare",null,"No",null,null,"Internal"]
[null,null,null,null,null,"119_8/7/2021 1:37:09 PM","2021-07-07","Defect","Ship Staff","Ship Staff Insp.","Main Engine Fuel Valve Test Equipment Defective","E/R - Main Engine","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Raised Requistion order","2021-10-10",null,"Waiting spare",null,"No",null,null,"Internal"]
[null,null,null,null,null,"119_8/7/2021 1:08:49 PM","2021-07-16","Breakdown","Ship Staff","Ship Staff Insp.","Breakdown of Inert Gas Blower Fan No.2","Inert Gas","Cargo / Ballast Systems","Equipment Related",null,null,"Not Applicable","Not Applicable","Requisition Raised for new parts, or repair of damaged parts","2021-01-11",null,"Waiting spare",null,"No",null,null,"Internal"]
[null,null,null,null,null,"119_8/4/2021 1:52:03 PM","2021-07-21","Defect","Ship Staff","Ship Staff Insp.","5P COT strip V/V no.154 VCO on CCR not \r\nworking, 5S COT strip V/V no. 152 VCO on CCR indicator not on full open, 4P/S COT strip V/V no. 444 VCO & no. 442 VCO on CCR not working, 3P/S COT strip V/V no. 334 VCO & no. 332 VCO on CCR not working, 2S COT strip V/V no. 222 VCO opening full but on shut position indicator approximately 10% open, SLOP P V/V no. 012 VCS open position indicator up to  approximately 25% only, Slop S V/V no. 192 VCO open position indicator up to 25% only.","Deck - Pipe / Fittings","Cargo / Ballast Systems","Equipment Related",null,null,"Not Applicable","Not Applicable","SOLENOIDS VALVES WERE INSPECTED AND FOUND NOT WORKING PO RAISED","2021-01-10",null,"Waiting spare",null,"No",null,null,"Internal"]
[null,null,null,null,null,"119_8/4/2021 1:55:21 PM","2021-07-21","Defect","Ship Staff","Ship Staff Insp.","Overboard ballast V/V no. 020 VWB Not opening and closing from remote and local (with hand pump)","Deck - Pipe / Fittings","Cargo / Ballast Systems","Equipment Related",null,null,"Not Applicable","Not Applicable","INSPECTED AND FOUND NOT OPENING AND CLOSING","2021-01-10",null,"Deferred to D D",null,"Yes",null,null,"Internal"]
[null,null,null,null,null,"119_8/4/2021 1:58:56 PM","2021-07-21","Defect","Ship Staff","Ship Staff Insp.","I.G branch V/V 5S & 8S, ROT VALVE, SLOP STBD, 2STBD passing.\r\n","Inert Gas","Cargo / Ballast Systems","Equipment Related",null,null,"Not Applicable","Not Applicable","Valaves were inspected and found defective /not holding.","2021-01-10",null,"Waiting spare",null,"No",null,null,"Internal"]
[null,null,null,null,null,"119_8/7/2021 5:13:31 PM","2021-07-26","Defect","Ship Staff","Ship Staff Insp.","CARGO STRIPPING PUMP STEAM LEAK ON SHAFT","Cargo Mach.","Cargo / Ballast Systems","Equipment Related",null,null,"Not Applicable","Not Applicable","Raised requisition order on 26-July-2021","2021-01-11",null,"Waiting spare",null,"Yes",null,null,"Internal"]
[null,null,null,null,null,"119_8/7/2021 5:23:23 PM","2021-07-26","Defect","Ship Staff","Ship Staff Insp.","AE AIR START VALVE PISTON ASSEMBLY LEAK","E/R - Aux. Engine","Eng. / Strg. Comp.","Equipment Related",null,null,"Not Applicable","Not Applicable","Raised requisition on 26-July-2021","2021-01-11",null,"Waiting spare",null,"No",null,null,"Internal"]
[null,null,null,null,null,"119_8/4/2021 2:01:55 PM","2021-07-31","Defect","Ship Staff","Ship Staff Insp.","DEFECTIVE DRAFT READING ","Elect. Mach. & Equip.","Navigation","Equipment Related",null,null,"Not Applicable","Not Applicable","SHORE CALIBRATION","2021-01-10",null,"Deferred to D D",null,"Yes",null,null,"Internal"]
[null,null,null,null,null,"119_8/4/2021 2:04:15 PM","2021-07-31","Defect","Ship Staff","Ship Staff Insp.","1S FWD, 2S FWD & AFT, 3S FWD, 3P, 4P, 5P & 6P COW MACHINE NOT WORKING","Deck - Machinery","Cargo / Ballast Systems","Equipment Related",null,null,"Not Applicable","Not Applicable","TO BE OVERHAULED","2021-01-10",null,"Deferred to D D",null,"Yes",null,null,"Internal"]
[null,null,null,null,null,"119_8/4/2021 2:14:01 PM","2021-07-31","Defect","Ship Staff","Ship Staff Insp.","PORTABLE GAS METRE LCD BROKEN SHOWING BLUE COLOR","Miscellaneous","Cargo / Ballast Systems","Equipment Related",null,null,"Not Applicable","Not Applicable","PO RAISED","2021-09-30",null,"Waiting spare",null,"No",null,null,"Internal"]

{"sheet":"Completed","index":1,"n_rows":17,"n_cols":28,"rows_kept":17,"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","12-Jun-2021",null,null,"Ship Name","BLACK SWAN"]
[]
[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"]

{"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"]
["119","BLACK SWAN","119_1623477348989.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"]