{"text_format":"1","workbook":"xlsx","n_sheets":49,"sheets":["Dash Board","Information","Risk Register","Actor Register","Risk Analysis Template","R15"," Matrix","Actor Impact Template","Matrix Template","Bow Tie Template","Bow Tie_R1","R1","Bow Tie_R13","R13","Bow Tie_R2","R2","Bow Tie_R3","R3","R4","R5","R6","R7","Sheet29","R8","R9","R10","R11","R12","R14","Jambo Fresh Matrix","Act1","Wintech  Matrix","Act2","Safmarine Matrix","Act3","Act4","Act5","Act6","Act7","Act8","Act9","Act10","Act11","Act12","Act13","Act14","Act15","Act16","Overall View"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":0,"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":"Dash Board","index":0,"n_rows":17,"n_cols":10,"rows_kept":17,"cut":false,"hidden":false,"merged":[[17,2,20,18],[16,9,16,11],[0,0,1,0],[3,4,4,17]]}
[]
[]
[]
[null,null,null,null,"Risk Based Decision Making Tool for Jambo Fresh trade Lane"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Dash Board"]

{"sheet":"Information","index":1,"n_rows":13,"n_cols":8,"rows_kept":13,"cut":false,"hidden":true,"merged":[[17,2,33,13],[5,2,8,18],[12,2,15,18],[1,7,1,13]]}
[]
[null,null,null,null,null,null,null,"Risk Based Decision Making Approach for International Shipping"]
[]
[]
[null,null,"Description"]
[null,null,"This application helps the party operating in the shipping domain to have an overview of thesystem level operational risks which are outside their boundary of control. Thrugh this overview the cost implications of the actons of other actors are made explicit. The party canuse this application to prioritize the risks and thereby develop strategies to treat these financial operational risks. "]
[]
[]
[]
[]
[]
[null,null,"Process "]
[null,null,"Risk Assessment and Actor Analysis form the main blocks behind the functioning of RBDM tool. Through these blocks inputs for the application are obtained. Based on these inputs the application generates an risk-centric bow-tie diagram and actor-centric risk matrix. Though this application consolidates the most proactised risk assessment practises being followed in the industry it operates under the broader framework of Risk Management Process as per ISO 31000:2009.  "]

{"sheet":"Risk Register","index":2,"n_rows":17,"n_cols":15,"rows_kept":17,"cut":false,"hidden":false,"merged":[[3,2,4,2],[3,3,4,3],[3,5,4,5],[3,6,3,7]]}
[]
[null,null,null,"Risk Register"]
[]
[null,null,"Risk Number","Risk Event","Probability","Likelihood","Number of Actors Involved",null,null,null,"Probability Range ",null,"Likelihood"]
[null,null,null,null,null,null,"Cause","Consequence",null,null,"Lower (>)","Upper (<=)"]
[null,null,"R1","Damage due to temperature changes in the container",1,"VL",null,null,null,null,0.8,1,"VH",0.8,1]
[null,null,"R2","Claim by Jambo Fresh ",0.4,"VL",null,null,null,null,0.6,0.8,"H",0.6,0.8]
[null,null,"R3","Growers selling Avacados to other company",null,"L",null,null,null,null,0.4,0.6,"M",0.4,0.6]
[null,null,"R4","Payment of guarantees at import side ",null,"VL",null,null,null,null,0.3,0.4,"L",0.3,0.4]
[null,null,"R5","Scanning takes very long at import side",null,"M",null,null,null,null,0,0.2,"VL",0,0.2]
[null,null,"R6","Long waiting times at the customs",null,"L"]
[null,null,"R7","Breakage of container door seal during the transport",null,"VL"]
[null,null,"R8","Issue with Document Proof for road transport (“bewijs van wegvervoer”) at Belgium customs",null,"VL"]
[null,null,"R9","Sometimes vessels arrive at ports other than Antwerp ",null,"VL"]
[null,null,"R10","Possibility of missing the vessel during trans-shipment",null,"L"]
[null,null,"R11","Missing Container",null,"VL"]
[null,null,"R12","Improper - phyto documentation",null,"L"]

{"sheet":"Actor Register","index":3,"n_rows":27,"n_cols":5,"rows_kept":27,"cut":false,"hidden":false,"merged":[[10,5,10,6]]}
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Actor Register"]
[]
[null,"Actor Number","Name","Name","Role"]
[null,"Act1","Bank","Jambo Fresh","Buyer"]
[null,"Act2","Buyer","Wintech ","Seller"]
[null,"Act3","Cargo-owner","Safmarine","Sea Carrier"]
[null,"Act4","Consignee","KRA","Government Agency"]
[null,"Act5","Customs","GMS","Freight forwarder"]
[null,"Act6","Freight forwarder","KEPHIS","Inspection Agency"]
[null,"Act7","Freight Forwarder Association","Grower","Producer"]
[null,"Act8","Government agency","KPA","Port Authority"]
[null,"Act9","Inland Carrier","van Duijn","Freight forwarder"]
[null,"Act10","Inspection","APM","Terminal Import"]
[null,"Act11","Insurer","Truck Export Side","Interland Carrier"]
[null,"Act12","IT & data company","Truck Import Side","Interland Carrier"]
[null,"Act13","Legislative government","Terminal Export Side","Terminal Export"]
[null,"Act14","Logistic Operator","HTS","Freight forwarder"]
[null,"Act15","Middlemen Export","Customs Kenya","Customs Export"]
[null,"Act16","Middlemen Import","Customs Import","Customs Import"]
[null,null,"Port Association"]

{"sheet":"Risk Analysis Template","index":4,"n_rows":33,"n_cols":16,"rows_kept":33,"cut":false,"hidden":false,"merged":[[9,12,9,13],[22,13,22,15],[22,5,23,6],[16,7,17,9],[15,3,15,8],[11,8,11,11],[12,8,12,11],[13,8,13,11],[14,8,14,11],[16,10,16,12],[18,7,18,9],[19,7,19,9],[20,7,20,9],[9,3,14,3],[9,5,9,7],[9,14,14,15],[8,3,8,8],[16,5,16,6],[21,3,21,8],[16,3,20,3],[9,8,10,11],[16,13,20,15],[29,13,33,15],[31,7,31,9],[32,7,32,9],[22,7,22,12],[28,3,28,8],[29,5,29,6],[29,7,30,9],[29,10,29,12],[24,5,24,6],[22,3,27,3],[29,3,33,3],[27,5,27,6]]}
[]
[null,null,null,"Risk Number","R#"]
[null,null,null,"Risk Event Title","Enter the event "]
[null,null,null,"Risk Description","Description of the event"]
[null,null,null,"Probability of occurance",{"$f":"ProbabiltyGrade(H5)","v":"VL"},null,"Value",{"$f":"MAX(N12:N14)/100","v":0}]
[null,null,null,"Analysis Method","Bow-Tie Analysis"]
[]
[]
[null,null,null,"Causes Details"]
[null," ",null,null,"Number","Agent",null,null,"Cause Description",null,null,null,"Likelihood of Occurrence (%)"]
[null,null,null,null,"C#","External Factor","Actor","Risk Event",null,null,null,null,"Before Preventive Action","After Preventive Action"]
[null,null,null,null,"C1","-","-","-","Enter Cause Details",null,null,null,0,{"$f":"M12*(100-MAX(K19:K21))/100","v":0}]
[null,null,null,null,"C2","-","-","-","Enter Cause Details",null,null,null,0,{"$f":"M13*(100-MAX(L19:L21))/100","v":0}]
[null,null,null,null,"C3","-","-","-","Enter Cause Details",null,null,null,0,{"$f":"M14*(100-MAX(M19:M21))/100","v":0}]
[]
[null,null,null,"Preventive Actions"]
[null,null,null,null,"Number","Agents",null,"Action Description",null,null,"Effectiveness on"]
[null,null,null,null,"PA#","Actor 1","Actor 2",null,null,null,"C1","C2","C3"]
[null,null,null,null,"PA1",null,null,"None",null,null,0,0,0]
[null,null,null,null,"PA2",null,null,"None",null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,"Consequence Details"]
[null,null,null,null,"Number","Consequence Description",null,"Actor Impacts",null,null,null,null,null,"After Corrective action"]
[null,null,null,null,"C#",null,null,"Actor 1","Impact 1","Actor 2 ","Impact 2","Actor 3","Impact 3","Impact 1","Impact 2","Impact 3"]
[null,null,null,null,"Q1",null,null,null,0,null,0,null,0,{"$f":"I25*(100-MAX($K$32:$K$34))/100","v":0},{"$f":"K25*(100-MAX($K$32:$K$34))/100","v":0},{"$f":"M25*(100-MAX($K$32:$K$34))/100","v":0}]
[null,null,null,null,"Q2",null,null,null,0,null,0,null,0,{"$f":"I26*(100-MAX($L$32:$L$34))/100","v":0},{"$f":"K26*(100-MAX($L$32:$L$34))/100","v":0},{"$f":"M26*(100-MAX($L$32:$L$34))/100","v":0}]
[null,null,null,null,"Q3",null,null,null,0,null,0,null,0,{"$f":"I27*(100-MAX($M$32:$M$34))/100","v":0},{"$f":"K27*(100-MAX($M$32:$M$34))/100","v":0},{"$f":"M27*(100-MAX($M$32:$M$34))/100","v":0}]
[]
[null,null,null,"Corretive Actions"]
[null,null,null,null,"Number","Agent",null,"Action Description",null,null,"Effectiveness on"]
[null,null,null,null,"C#","Actor 1","Actor 2",null,null,null,"Q1","Q2","Q3"]
[null,null,null,null,"CA1",null,null,"None",null,null,0,0,0]
[null,null,null,null,"CA2",null,null,"None",null,null,0,0,0]

{"sheet":"R15","index":5,"n_rows":33,"n_cols":16,"rows_kept":33,"cut":false,"hidden":true,"merged":[[16,5,16,6],[16,7,17,9],[16,10,16,12],[29,13,33,15],[31,7,31,9],[32,7,32,9],[21,3,21,8],[22,3,27,3],[22,5,23,6],[22,7,22,12],[22,13,22,15],[24,5,24,6],[27,5,27,6],[28,3,28,8],[29,3,33,3],[29,5,29,6],[29,7,30,9],[29,10,29,12],[16,13,20,15],[18,7,18,9],[19,7,19,9],[20,7,20,9],[8,3,8,8],[9,3,14,3],[9,5,9,7],[9,8,10,11],[9,12,9,13],[9,14,14,15],[11,8,11,11],[12,8,12,11],[13,8,13,11],[14,8,14,11],[15,3,15,8],[16,3,20,3]]}
[]
[null,null,null,"Risk Number","R15"]
[null,null,null,"Risk Event Title","Enter the event "]
[null,null,null,"Risk Description","Description of the event"]
[null,null,null,"Probability of occurance",{"$f":"ProbabiltyGrade(H5)","v":"VL"},null,"Value",{"$f":"MAX(N12:N14)/100","v":0}]
[null,null,null,"Analysis Method","Bow-Tie Analysis"]
[]
[]
[null,null,null,"Causes Details"]
[null," ",null,null,"Number","Agent",null,null,"Cause Description",null,null,null,"Likelihood of Occurrence (%)"]
[null,null,null,null,"C#","External Factor","Actor","Risk Event",null,null,null,null,"Before Preventive Action","After Preventive Action"]
[null,null,null,null,"C1","-","-","-","Enter Cause Details",null,null,null,0,{"$f":"M12*(100-MAX(K19:K21))/100","v":0}]
[null,null,null,null,"C2","-","-","-","Enter Cause Details",null,null,null,0,{"$f":"M13*(100-MAX(L19:L21))/100","v":0}]
[null,null,null,null,"C3","-","-","-","Enter Cause Details",null,null,null,0,{"$f":"M14*(100-MAX(M19:M21))/100","v":0}]
[]
[null,null,null,"Preventive Actions"]
[null,null,null,null,"Number","Agents",null,"Action Description",null,null,"Effectiveness on"]
[null,null,null,null,"PA#","Actor 1","Actor 2",null,null,null,"C1","C2","C3"]
[null,null,null,null,"PA1",null,null,"None",null,null,0,0,0]
[null,null,null,null,"PA2",null,null,"None",null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,"Consequence Details"]
[null,null,null,null,"Number","Consequence Description",null,"Actor Impacts",null,null,null,null,null,"After Corrective action"]
[null,null,null,null,"C#",null,null,"Actor 1","Impact 1","Actor 2 ","Impact 2","Actor 3","Impact 3","Impact 1","Impact 2","Impact 3"]
[null,null,null,null,"Q1",null,null,null,0,null,0,null,0,{"$f":"I25*(100-MAX($K$32:$K$34))/100","v":0},{"$f":"K25*(100-MAX($K$32:$K$34))/100","v":0},{"$f":"M25*(100-MAX($K$32:$K$34))/100","v":0}]
[null,null,null,null,"Q2",null,null,null,0,null,0,null,0,{"$f":"I26*(100-MAX($L$32:$L$34))/100","v":0},{"$f":"K26*(100-MAX($L$32:$L$34))/100","v":0},{"$f":"M26*(100-MAX($L$32:$L$34))/100","v":0}]
[null,null,null,null,"Q3",null,null,null,0,null,0,null,0,{"$f":"I27*(100-MAX($M$32:$M$34))/100","v":0},{"$f":"K27*(100-MAX($M$32:$M$34))/100","v":0},{"$f":"M27*(100-MAX($M$32:$M$34))/100","v":0}]
[]
[null,null,null,"Corretive Actions"]
[null,null,null,null,"Number","Agent",null,"Action Description",null,null,"Effectiveness on"]
[null,null,null,null,"C#","Actor 1","Actor 2",null,null,null,"Q1","Q2","Q3"]
[null,null,null,null,"CA1",null,null,"None",null,null,0,0,0]
[null,null,null,null,"CA2",null,null,"None",null,null,0,0,0]

{"sheet":" Matrix","index":6,"n_rows":11,"n_cols":13,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,2,1,5],[2,10,2,12],[3,2,7,2],[9,4,9,8]]}
[]
[null,"Actor  Name"]
[null,null,null,null,null,null,null,null,null,null,"Prioritization"]
[null,null,"Impact","VH",null,null,null,null,null,null,"Impact Level","Grade","Color Code"]
[null,null,null,"H",null,null,null,null,null,null,"Unacceptable","UA"]
[null,null,null,"M","R7 R6 R4 ",null,"R3 ",null,null,null,"Very High","VH"]
[null,null,null,"L","R2 ",null,null,null,null,null,"High","H"]
[null,null,null,"VL","R5 R1 ",null,null,null,null,null,"Medium","M"]
[null,null,null,null,"VL","L","M","H","VH",null,"Low","L"]
[null,null,null,null,"Probability",null,null,null,null,null,"Very Low","VL"]
[null,null,null,null,null,null,null,null,null,null,"Acceptable","A"]

{"sheet":"Actor Impact Template","index":7,"n_rows":33,"n_cols":15,"rows_kept":33,"cut":false,"hidden":true,"merged":[[32,1,32,4],[1,2,1,6],[3,13,3,14],[4,2,9,6],[25,3,25,4],[25,2,26,2],[25,1,26,1],[1,8,10,11]]}
[]
[null,"Actor Number","Act#"]
[null,"Actor Name"]
[null,"Role","#What function in shipping domain",null,null,null,null,null,null,null,null,null,null,"Impact Range "]
[null,"Description",null,null,null,null,null,null,null,null,null,null,null,"Lower (>)","Upper (<=)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.8,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.6,0.8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.4,0.6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.2,0.4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0.2]
[]
[null,"Impact Evaluation",null,null,null,null,"Risk Evaluation"]
[null,null,"Max","Grade"]
[null,"Enter Maximum Acceptable Damage",10000,"VH",null,null,"Risks","Probability of Occurrence","Impact Value","Impact Grade"]
[null,null,null,null,null,null,{"$f":"'Risk Register'!C6","v":"R1"},{"$f":"Risklikelihood(G15)","v":"VL"},0,"VL"]
[null,"Categorization",null,null,null,null,{"$f":"'Risk Register'!C7","v":"R2"},"VL",0,"VL"]
[null,"Impact Level","Impact Amount","Grade",null,null,{"$f":"'Risk Register'!C8","v":"R3"},"L",350,"M"]
[null,"Very High",{"$f":"C14","v":10000},"VH",null,null,{"$f":"'Risk Register'!C9","v":"R4"},"VL",0,"VL"]
[null,"High",{"$f":"0.8*C18","v":8000},"H",null,null,{"$f":"'Risk Register'!C10","v":"R5"},"M",0,"VL"]
[null,"Medium",{"$f":"0.6*C18","v":6000},"M",null,null,{"$f":"'Risk Register'!C11","v":"R6"},"VL",0,"VL"]
[null,"Low",{"$f":"0.4*C18","v":4000},"L",null,null,{"$f":"'Risk Register'!C12","v":"R7"},"L",0,"VL"]
[null,"Very Low",{"$f":"0.2*C18","v":2000},"VL",null,null,{"$f":"'Risk Register'!C13","v":"R8"},{"$f":"Risklikelihood(G22)","v":"VL"}]
[null,null,null,null,null,null,{"$f":"'Risk Register'!C14","v":"R9"},"VL"]
[null,null,null,null,null,null,{"$f":"'Risk Register'!C15","v":"R10"},"VL"]
[null,"Scaling used for analysis",null,null,null,null,{"$f":"'Risk Register'!C16","v":"R11"},"VL"]
[null,"Impact Level","Grade","Impact Range ",null,null,{"$f":"'Risk Register'!C17","v":"R12"},"M"]
[null,null,null,"Lower (>)","Upper (<=)",null,null," "]
[null,"Very High","VH",0.8,"-"]
[null,"High","H",0.6,0.8]
[null,"Medium","M",0.4,0.6]
[null,"Low","L",0.2,0.4]
[null,"Very Low","VL",0,0.2]
[null,"These values are subjective to actor"]

{"sheet":"Matrix Template","index":8,"n_rows":11,"n_cols":13,"rows_kept":11,"cut":false,"hidden":true,"merged":[[3,2,7,2],[2,10,2,12],[9,4,9,8],[1,2,1,5]]}
[]
[null,"Actor  Name"]
[null,null,null,null,null,null,null,null,null,null,"Prioritization"]
[null,null,"Impact","VH",null,null,null,null,null,null,"Impact Level","Grade","Color Code"]
[null,null,null,"H",null,null,null,null,null,null,"Unacceptable","UA"]
[null,null,null,"M",null,null,null,null,null,null,"Very High","VH"]
[null,null,null,"L",null,null,null,null,null,null,"High","H"]
[null,null,null,"VL",null,null,null,null,null,null,"Medium","M"]
[null,null,null,null,"VL","L","M","H","VH",null,"Low","L"]
[null,null,null,null,"Probability",null,null,null,null,null,"Very Low","VL"]
[null,null,null,null,null,null,null,null,null,null,"Acceptable","A"]

{"sheet":"Bow Tie Template","index":9,"n_rows":14,"n_cols":16,"rows_kept":14,"cut":false,"hidden":false,"merged":[[6,6,6,10],[9,8,16,8],[9,3,9,4],[9,12,9,15],[11,7,13,7],[11,9,13,9]]}
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Bow-Tie Diagram"]
[]
[]
[null,null,null,"Causes",null,null,"Preventive Actions",null,"R#",null,"Corrective Actions",null,"Consequences"]
[null,null,null,"Number","Agent",null,null,null,null,null,null,null,"Number","Actor 1","Actor 2","Actor 3"]
[null,null,null,"C#","-",null,null,null,null,null,null,null,"Q#","-","-","-"]
[null,null,null,null,"-",null,null,null,null,null,null,null,null,"-","-","-"]
[null,null,null,null,"-",null,null,null,null,null,null,null,null,"-","-","-"]

{"sheet":"Bow Tie_R1","index":10,"n_rows":14,"n_cols":16,"rows_kept":14,"cut":false,"hidden":false,"merged":[[9,3,9,4],[9,8,16,8],[9,12,9,15],[11,7,13,7],[11,9,13,9]]}
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Bow-Tie Diagram"]
[]
[]
[null,null,null,"Causes",null,null,"Preventive Actions",null,"R1",null,"Corrective Actions",null,"Consequences"]
[null,null,null,"Number","Agent",null,null,null,null,null,null,null,"Number","Actor 1","Actor 2","Actor 3"]
[null,null,null,"C1","Wintech",null,null,null,null,null," CA1",null,"Q1","Jumbo Fresh"," "," "]
[null,null,null,"C2","Safmarine",null,null,null,null,null,null,null,"Q2"," "," "]
[null,null,null,"C3","Safmarine",null,null,null,null,null,null,null,"Q3",null," "," "]

{"sheet":"R1","index":11,"n_rows":34,"n_cols":16,"rows_kept":34,"cut":false,"hidden":false,"merged":[[20,7,20,9],[16,5,16,6],[16,7,17,9],[8,3,8,8],[9,5,9,7],[9,8,10,11],[15,3,15,8],[14,8,14,11],[11,8,11,11],[12,8,12,11],[13,8,13,11],[16,10,16,12],[18,7,18,9],[19,7,19,9],[9,12,9,13],[32,7,32,9],[22,13,22,15],[31,7,31,9],[21,3,21,8],[22,5,23,6],[22,7,22,12],[28,3,28,8],[29,5,29,6],[29,7,30,9],[29,10,29,12]]}
[]
[null,null,null,"Risk Number","R1"]
[null,null,null,"Risk Event Title","Damage due to temperature changes in the container"]
[null,null,null,"Risk Description","Temperature readings can be very sensitive information, as in case of damage claims can be placed. At the moment if a damage occurs due to temperature deviations it is difficult to find out who is responsible. JamboFresh has very little visibility on that. "]
[null,null,null,"Probability of occurance",{"$f":"ProbabiltyGrade(H5)","v":"VL"},null,"Value",{"$f":"MAX(N12:N14)/100","v":0.15}]
[null,null,null,"Input Method","Bow-Tie Analysis"]
[]
[]
[null,null,null,"Causes Details"]
[null," ",null,null,"Number","Agent",null,null,"Cause Description",null,null,null,"Likelihood of Occurrence (%)"]
[null,14,null,null,"C#","External Factor","Actor","Risk Event",null,null,null,null,"Before Preventive Action","After Preventive Action"]
[null,15,null,null,"C1","-","Wintech","-","Fruits were not precooled before loading onto the container at Nairobi",null,null,null,10,{"$f":"M12*(100-MAX(K19:K21))/100","v":10}]
[null,4,null,null,"C2","-","Safmarine","-","The drivers shuts off the engine to save fuel at the export side especially during transportation from Nairobi to Mombassa and from Mombassa to Salalah",null,null,null,15,{"$f":"M13*(100-MAX(L19:L21))/100","v":15}]
[null,null,null,null,"C3","-","Safmarine","-","The temperature measuring device is not working well. If the damage occurs, JF would put a claim on Safmarine.",null,null,null,10,{"$f":"M14*(100-MAX(M19:M21))/100","v":10}]
[]
[null,null,null,"Preventive Actions"]
[null,null,null,null,"Number","Agents",null,"Action Description",null,null,"Effectiveness on"]
[null,null,null,null,"PA#","Actor 1","Actor 2",null,null,null,"C1","C2","C3"]
[null,null,null,null,"PA1"," ",null,null,null,null,0,0,0]
[null,null,null,null,"PA2",null,null,"What is the preventive action?",null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,"Consequence Details"]
[null,null,null,null,"Number","Consequence Description",null,"Actor Impacts",null,null,null,null,null,"After Corrective action"]
[null,null,null,null,"C#",null,null,"Actor 1","Impact 1","Actor 2 ","Impact 2","Actor 3","Impact 3","Impact 1","Impact 2","Impact 3"]
[null,null,null,null,"Q1","Cargo is damaged due to ripening of goods",null,"Jambo Fresh",50000," ",0," ",0,{"$f":"I25*(100-MAX($K$32:$K$34))/100","v":25000},{"$f":"K25*(100-MAX($K$32:$K$34))/100","v":0},{"$f":"M25*(100-MAX($K$32:$K$34))/100","v":0}]
[null,null,null,null,"Q2",null,null," ",0," ",0,null,0,{"$f":"I26*(100-MAX($L$32:$L$34))/100","v":0},{"$f":"K26*(100-MAX($L$32:$L$34))/100","v":0},{"$f":"M26*(100-MAX($L$32:$L$34))/100","v":0}]
[null,null,null,null,"Q3",null,null,null,null," ",0," ",0,{"$f":"I27*(100-MAX($M$32:$M$34))/100","v":0},{"$f":"K27*(100-MAX($M$32:$M$34))/100","v":0},{"$f":"M27*(100-MAX($M$32:$M$34))/100","v":0}]
[]
[null,null,null,"Corretive Actions"]
[null,null,null,null,"Number","Agent",null,"Action Description",null,null,"Effectiveness on"]
[null,null,null,null,"C#","Actor 1","Actor 2",null,null,null,"Q1","Q2","Q3"]
[null,null,null,null,"CA1","Wintech ","Safmarine","Put a claim on Wintech or Safmarine based on where in the transporttion the damaged has occured.",null,null,50,0,0]
[null,null,null,null,"CA2",null,null,null,null,null,0,0,0]
[null,null,null,null,"CA3",null,null,null,null,null,0,0,0]

{"sheet":"Bow Tie_R13","index":12,"n_rows":14,"n_cols":16,"rows_kept":14,"cut":false,"hidden":true,"merged":[[9,3,9,4],[9,8,16,8],[9,12,9,15],[11,7,13,7],[11,9,13,9]]}
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Bow-Tie Diagram"]
[]
[]
[null,null,null,"Causes",null,null,"Preventive Actions",null,"R13",null,"Corrective Actions",null,"Consequences"]
[null,null,null,"Number","Agent",null,null,null,null,null,null,null,"Number","Actor 1","Actor 2","Actor 3"]
[null,null,null,"C1","-",null,null,null,null,null,null,null,"Q1"]
[null,null,null,"C2","-",null,null,null,null,null,null,null,"Q2"]
[null,null,null,"C3","-",null,null,null,null,null,null,null,"Q3"]

{"sheet":"R13","index":13,"n_rows":33,"n_cols":16,"rows_kept":33,"cut":false,"hidden":true,"merged":[[15,3,15,8],[16,3,20,3],[9,14,14,15],[11,8,11,11],[12,8,12,11],[13,8,13,11],[14,8,14,11],[16,5,16,6],[8,3,8,8],[9,3,14,3],[9,5,9,7],[9,8,10,11],[9,12,9,13],[29,10,29,12],[16,13,20,15],[18,7,18,9],[19,7,19,9],[20,7,20,9],[16,7,17,9],[16,10,16,12],[29,13,33,15],[31,7,31,9],[32,7,32,9],[21,3,21,8],[22,3,27,3],[22,5,23,6],[22,7,22,12],[22,13,22,15],[24,5,24,6],[27,5,27,6],[28,3,28,8],[29,3,33,3],[29,5,29,6],[29,7,30,9]]}
[]
[null,null,null,"Risk Number","R13"]
[null,null,null,"Risk Event Title","Enter the event "]
[null,null,null,"Risk Description","Description of the event"]
[null,null,null,"Probability of occurance",{"$f":"ProbabiltyGrade(H5)","v":"VL"},null,"Value",{"$f":"MAX(N12:N14)/100","v":0}]
[null,null,null,"Analysis Method","Bow-Tie Analysis"]
[]
[]
[null,null,null,"Causes Details"]
[null," ",null,null,"Number","Agent",null,null,"Cause Description",null,null,null,"Likelihood of Occurrence (%)"]
[null,null,null,null,"C#","External Factor","Actor","Risk Event",null,null,null,null,"Before Preventive Action","After Preventive Action"]
[null,null,null,null,"C1","-","-","-","Enter Cause Details",null,null,null,0,{"$f":"M12*(100-MAX(K19:K21))/100","v":0}]
[null,null,null,null,"C2","-","-","-","Enter Cause Details",null,null,null,0,{"$f":"M13*(100-MAX(L19:L21))/100","v":0}]
[null,null,null,null,"C3","-","-","-","Enter Cause Details",null,null,null,0,{"$f":"M14*(100-MAX(M19:M21))/100","v":0}]
[]
[null,null,null,"Preventive Actions"]
[null,null,null,null,"Number","Agents",null,"Action Description",null,null,"Effectiveness on"]
[null,null,null,null,"PA#","Actor 1","Actor 2",null,null,null,"C1","C2","C3"]
[null,null,null,null,"PA1",null,null,"None",null,null,0,0,0]
[null,null,null,null,"PA2",null,null,"None",null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,"Consequence Details"]
[null,null,null,null,"Number","Consequence Description",null,"Actor Impacts",null,null,null,null,null,"After Corrective action"]
[null,null,null,null,"C#",null,null,"Actor 1","Impact 1","Actor 2 ","Impact 2","Actor 3","Impact 3","Impact 1","Impact 2","Impact 3"]
[null,null,null,null,"Q1",null,null,null,0,null,0,null,0,{"$f":"I25*(100-MAX($K$32:$K$34))/100","v":0},{"$f":"K25*(100-MAX($K$32:$K$34))/100","v":0},{"$f":"M25*(100-MAX($K$32:$K$34))/100","v":0}]
[null,null,null,null,"Q2",null,null,null,0,null,0,null,0,{"$f":"I26*(100-MAX($L$32:$L$34))/100","v":0},{"$f":"K26*(100-MAX($L$32:$L$34))/100","v":0},{"$f":"M26*(100-MAX($L$32:$L$34))/100","v":0}]
[null,null,null,null,"Q3",null,null,null,0,null,0,null,0,{"$f":"I27*(100-MAX($M$32:$M$34))/100","v":0},{"$f":"K27*(100-MAX($M$32:$M$34))/100","v":0},{"$f":"M27*(100-MAX($M$32:$M$34))/100","v":0}]
[]
[null,null,null,"Corretive Actions"]
[null,null,null,null,"Number","Agent",null,"Action Description",null,null,"Effectiveness on"]
[null,null,null,null,"C#","Actor 1","Actor 2",null,null,null,"Q1","Q2","Q3"]
[null,null,null,null,"CA1",null,null,"None",null,null,0,0,0]
[null,null,null,null,"CA2",null,null,"None",null,null,0,0,0]

{"sheet":"Bow Tie_R2","index":14,"n_rows":14,"n_cols":16,"rows_kept":14,"cut":false,"hidden":true,"merged":[[9,3,9,4],[9,8,16,8],[9,12,9,15],[11,7,13,7],[11,9,13,9]]}
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Bow-Tie Diagram"]
[]
[]
[null,null,null,"Causes",null,null,"Preventive Actions",null,"R2",null,"Corrective Actions",null,"Consequences"]
[null,null,null,"Number","Agent",null,null,null,null,null,null,null,"Number","Actor 1","Actor 2","Actor 3"]
[null,null,null,"C1","Jumbo Fresh",null,null,null,null,null,null,null,"Q1","Avosell"," "]
[null,null,null,"C2"]
[null,null,null,"C3","-"]

{"sheet":"R2","index":15,"n_rows":33,"n_cols":16,"rows_kept":33,"cut":false,"hidden":false,"merged":[[3,4,3,12],[9,12,9,13],[20,7,20,9],[21,3,21,8],[22,5,23,6],[11,8,11,11],[15,3,15,8],[16,5,16,6],[14,8,14,11],[16,7,17,9],[16,10,16,12],[18,7,18,9],[19,7,19,9],[22,7,22,12],[22,13,22,15],[8,3,8,8],[9,5,9,7],[9,8,10,11],[12,8,12,11],[13,8,13,11],[29,10,29,12],[31,7,31,9],[32,7,32,9],[28,3,28,8],[29,5,29,6],[29,7,30,9]]}
[]
[null,null,null,"Risk Number","R2"]
[null,null,null,"Risk Event Title","Claim by Jambo Fresh "]
[null,null,null,"Risk Description","Mantaining the optimum temperature setting is very important for the stock to be fresh. Any tampering with the temperature can lead to loss for Jumbo Fresh and eventually penalties to the subcontractors"]
[null,null,null,"Probability of occurance",{"$f":"ProbabiltyGrade(H5)","v":"VL"},null,"Value",{"$f":"MAX(N12:N14)/100","v":0.1}]
[null,null,null,"Analysis Method","Bow-Tie Analysis"]
[]
[]
[null,null,null,"Causes Details"]
[null," ",null,null,"Number","Agent",null,null,"Cause Description",null,null,null,"Likelihood of Occurrence (%)"]
[null,null,null,null,"C#","External Factor","Actor","Risk Event",null,null,null,null,"Before Preventive Action","After Preventive Action"]
[null,null,null,null,"C1","-","Jambo Fresh","-","Temperature was not regulated during the transportation",null,null,null,10,{"$f":"M12*(100-MAX(K19:K21))/100","v":10}]
[null,null,null,null,"C2","-",null,"-",null,null,null,null,null,{"$f":"M13*(100-MAX(L19:L21))/100","v":0}]
[null,null,null,null,"C3","-","-","-","Enter Cause Details",null,null,null,0,{"$f":"M14*(100-MAX(M19:M21))/100","v":0}]
[]
[null,null,null,"Preventive Actions"]
[null,null,null,null,"Number","Agents",null,"Action Description",null,null,"Effectiveness on"]
[null,null,null,null,"PA#","Actor 1","Actor 2",null,null,null,"C1","C2","C3"]
[null,null,null,null,"PA1"," ",null,null,null,null,0,0,0]
[null,null,null,null,"PA2",null,null,"What is the preventive action?",null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,"Consequence Details"]
[null,null,null,null,"Number","Consequence Description",null,"Actor Impacts",null,null,null,null,null,"After Corrective action"]
[null,null,null,null,"C#",null,null,"Actor 1","Impact 1","Actor 2 ","Impact 2","Actor 3","Impact 3","Impact 1","Impact 2","Impact 3"]
[null,null,null,null,"Q1","Wintech has to pay for the claim produced if the cargo was not precooled before loading onto the container",null,"Avomarine",50000," ",0,null,0,{"$f":"I25*(100-MAX($K$32:$K$34))/100","v":50000},{"$f":"K25*(100-MAX($K$32:$K$34))/100","v":0},{"$f":"M25*(100-MAX($K$32:$K$34))/100","v":0}]
[null,null,null,null,"Q2",null,null,null,null,null,0,null,0,{"$f":"I26*(100-MAX($L$32:$L$34))/100","v":0},{"$f":"K26*(100-MAX($L$32:$L$34))/100","v":0},{"$f":"M26*(100-MAX($L$32:$L$34))/100","v":0}]
[null,null,null,null,"Q3",null,null,null,null,null,null,null,null,{"$f":"I27*(100-MAX($M$32:$M$34))/100","v":0},{"$f":"K27*(100-MAX($M$32:$M$34))/100","v":0},{"$f":"M27*(100-MAX($M$32:$M$34))/100","v":0}]
[]
[null,null,null,"Corretive Actions"]
[null,null,null,null,"Number","Agent",null,"Action Description",null,null,"Effectiveness on"]
[null,null,null,null,"C#","Actor 1","Actor 2",null,null,null,"Q1","Q2","Q3"]
[null,null,null,null,"CA1"," "," ","None",null,null,0,0,0]
[null,null,null,null,"CA2",null,null,"None",null,null,0,0,0]

{"sheet":"Bow Tie_R3","index":16,"n_rows":14,"n_cols":16,"rows_kept":14,"cut":false,"hidden":true,"merged":[[9,3,9,4],[9,8,16,8],[9,12,9,15],[11,7,13,7],[11,9,13,9]]}
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Bow-Tie Diagram"]
[]
[]
[null,null,null,"Causes",null,null,"Preventive Actions",null,"R3",null,"Corrective Actions",null,"Consequences"]
[null,null,null,"Number","Agent",null,null,null,null,null,null,null,"Number","Actor 1","Actor 2","Actor 3"]
[null,null,null,"C1","Grower",null,null,null,null,null,null,null,"Q1","Wintech "]
[null,null,null,"C2","-",null,null,null,null,null,null,null,"Q2"]
[null,null,null,"C3","-",null,null,null,null,null,null,null,"Q3"]

{"sheet":"R3","index":17,"n_rows":33,"n_cols":16,"rows_kept":33,"cut":false,"hidden":false,"merged":[[9,14,14,15],[11,8,11,11],[12,8,12,11],[13,8,13,11],[14,8,14,11],[29,13,33,15],[31,7,31,9],[32,7,32,9],[21,3,21,8],[22,3,27,3],[22,5,23,6],[22,7,22,12],[22,13,22,15],[24,5,24,6],[18,7,18,9],[19,7,19,9],[20,7,20,9],[16,7,17,9],[16,10,16,12],[3,4,3,12],[27,5,27,6],[28,3,28,8],[29,3,33,3],[29,5,29,6],[29,7,30,9],[29,10,29,12],[8,3,8,8],[9,3,14,3],[9,5,9,7],[9,8,10,11],[9,12,9,13],[15,3,15,8],[16,3,20,3],[16,5,16,6],[16,13,20,15]]}
[]
[null,null,null,"Risk Number","R3"]
[null,null,null,"Risk Event Title","Growers selling Avacados to other company"]
[null,null,null,"Risk Description","When the avocados are harvested even if there have been prior agreements growers it may happen that the grower sells the avocados to a bigger company offering better prices. The bigger companies may also offer additional bonuses to growers at the end of the harvesting period to make it more attractive for growers to work with them. Especially in situations with high demands, it may happen that the growers prefer to work with the bigger exporters who offer better prices."]
[null,null,null,"Probability of occurance",{"$f":"ProbabiltyGrade(H5)","v":"L"},null,"Value",{"$f":"MAX(N12:N14)/100","v":0.4}]
[null,null,null,"Analysis Method","Bow-Tie Analysis"]
[]
[]
[null,null,null,"Causes Details"]
[null," ",null,null,"Number","Agent",null,null,"Cause Description",null,null,null,"Likelihood of Occurrence (%)"]
[null,null,null,null,"C#","External Factor","Actor","Risk Event",null,null,null,null,"Before Preventive Action","After Preventive Action"]
[null,null,null,null,"C1","-","Grower","-","Grower sells the avocados to a bigger company offering better prices. ",null,null,null,40,{"$f":"M12*(100-MAX(K19:K21))/100","v":40}]
[null,null,null,null,"C2","-","-","-","Enter Cause Details",null,null,null,0,{"$f":"M13*(100-MAX(L19:L21))/100","v":0}]
[null,null,null,null,"C3","-","-","-","Enter Cause Details",null,null,null,0,{"$f":"M14*(100-MAX(M19:M21))/100","v":0}]
[]
[null,null,null,"Preventive Actions"]
[null,null,null,null,"Number","Agents",null,"Action Description",null,null,"Effectiveness on"]
[null,null,null,null,"PA#","Actor 1","Actor 2",null,null,null,"C1","C2","C3"]
[null,null,null,null,"PA1",null,null,"What is the preventive action?",null,null,0,0,0]
[null,null,null,null,"PA2",null,null,"None",null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,"Consequence Details"]
[null,null,null,null,"Number","Consequence Description",null,"Actor Impacts",null,null,null,null,null,"After Corrective action"]
[null,null,null,null,"C#",null,null,"Actor 1","Impact 1","Actor 2 ","Impact 2","Actor 3","Impact 3","Impact 1","Impact 2","Impact 3"]
[null,null,null,null,"Q1",null,null,"Wintech ",1000,null,0,null,0,{"$f":"I25*(100-MAX($K$32:$K$34))/100","v":1000},{"$f":"K25*(100-MAX($K$32:$K$34))/100","v":0},{"$f":"M25*(100-MAX($K$32:$K$34))/100","v":0}]
[null,null,null,null,"Q2",null,null,null,0,null,0,null,0,{"$f":"I26*(100-MAX($L$32:$L$34))/100","v":0},{"$f":"K26*(100-MAX($L$32:$L$34))/100","v":0},{"$f":"M26*(100-MAX($L$32:$L$34))/100","v":0}]
[null,null,null,null,"Q3",null,null,null,0,null,0,null,0,{"$f":"I27*(100-MAX($M$32:$M$34))/100","v":0},{"$f":"K27*(100-MAX($M$32:$M$34))/100","v":0},{"$f":"M27*(100-MAX($M$32:$M$34))/100","v":0}]
[]
[null,null,null,"Corretive Actions"]
[null,null,null,null,"Number","Agent",null,"Action Description",null,null,"Effectiveness on"]
[null,null,null,null,"C#","Actor 1","Actor 2",null,null,null,"Q1","Q2","Q3"]
[null,null,null,null,"CA1"," "," ","None",null,null,0,0,0]
[null,null,null,null,"CA2"," "," ","None",null,null,0,0,0]

{"sheet":"R4","index":18,"n_rows":33,"n_cols":16,"rows_kept":33,"cut":false,"hidden":false,"merged":[[15,3,15,8],[16,3,20,3],[9,14,14,15],[11,8,11,11],[12,8,12,11],[13,8,13,11],[14,8,14,11],[16,5,16,6],[8,3,8,8],[9,3,14,3],[9,5,9,7],[9,8,10,11],[9,12,9,13],[29,10,29,12],[16,13,20,15],[18,7,18,9],[19,7,19,9],[20,7,20,9],[16,7,17,9],[16,10,16,12],[29,13,33,15],[31,7,31,9],[32,7,32,9],[21,3,21,8],[22,3,27,3],[22,5,23,6],[22,7,22,12],[22,13,22,15],[24,5,24,6],[27,5,27,6],[28,3,28,8],[29,3,33,3],[29,5,29,6],[29,7,30,9]]}
[]
[null,null,null,"Risk Number","R4"]
[null,null,null,"Risk Event Title","Payment of guarantees at import side "]
[null,null,null,"Risk Description","For the import to the Europe, there is a trade facilitation named EUR1 (or movement certificate) that enables the importers to import goods with reduced (or even free) import duty based on the trade agreement between the EU and the beneficiary countries. Particular to the Netherlands, there is a new regulation that for the selected container for the EUR1 document inspection, importer is required to pay the guarantee of around 1,500-1,600 euros per case (or per container?). This guarantee money will be released back to the importer only after Customs establish that the EUR1 document is not fake."]
[null,null,null,"Probability of occurance",{"$f":"ProbabiltyGrade(H5)","v":"VL"},null,"Value",{"$f":"MAX(N12:N14)/100","v":0.1}]
[null,null,null,"Analysis Method","Bow-Tie Analysis"]
[]
[]
[null,null,null,"Causes Details"]
[null," ",null,null,"Number","Agent",null,null,"Cause Description",null,null,null,"Likelihood of Occurrence (%)"]
[null,null,null,null,"C#","External Factor","Actor","Risk Event",null,null,null,null,"Before Preventive Action","After Preventive Action"]
[null,null,null,null,"C1","-","Customs Import","-","This guarantee money will be released back to the importer only after Customs establish that the EUR1 document is not fake.",null,null,null,10,{"$f":"M12*(100-MAX(K19:K21))/100","v":10}]
[null,null,null,null,"C2","-","-","-","Enter Cause Details",null,null,null,0,{"$f":"M13*(100-MAX(L19:L21))/100","v":0}]
[null,null,null,null,"C3","-","-","-","Enter Cause Details",null,null,null,0,{"$f":"M14*(100-MAX(M19:M21))/100","v":0}]
[]
[null,null,null,"Preventive Actions"]
[null,null,null,null,"Number","Agents",null,"Action Description",null,null,"Effectiveness on"]
[null,null,null,null,"PA#","Actor 1","Actor 2",null,null,null,"C1","C2","C3"]
[null,null,null,null,"PA1",null,null,"None",null,null,0,0,0]
[null,null,null,null,"PA2",null,null,"None",null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,"Consequence Details"]
[null,null,null,null,"Number","Consequence Description",null,"Actor Impacts",null,null,null,null,null,"After Corrective action"]
[null,null,null,null,"C#",null,null,"Actor 1","Impact 1","Actor 2 ","Impact 2","Actor 3","Impact 3","Impact 1","Impact 2","Impact 3"]
[null,null,null,null,"Q1",null,null,"Jambo Fresh",1600," ",0,null,0,{"$f":"I25*(100-MAX($K$32:$K$34))/100","v":1600},25,{"$f":"M25*(100-MAX($K$32:$K$34))/100","v":0}]
[null,null,null,null,"Q2",null,null,null,0,null,0,null,0,{"$f":"I26*(100-MAX($L$32:$L$34))/100","v":0},{"$f":"K26*(100-MAX($L$32:$L$34))/100","v":0},{"$f":"M26*(100-MAX($L$32:$L$34))/100","v":0}]
[null,null,null,null,"Q3",null,null,null,0,null,0,null,0,{"$f":"I27*(100-MAX($M$32:$M$34))/100","v":0},{"$f":"K27*(100-MAX($M$32:$M$34))/100","v":0},{"$f":"M27*(100-MAX($M$32:$M$34))/100","v":0}]
[]
[null,null,null,"Corretive Actions"]
[null,null,null,null,"Number","Agent",null,"Action Description",null,null,"Effectiveness on"]
[null,null,null,null,"C#","Actor 1","Actor 2",null,null,null,"Q1","Q2","Q3"]
[null,null,null,null,"CA1"," "," ","None",null,null,0,0,0]
[null,null,null,null,"CA2"," "," ","None",null,null,0,0,0]

{"sheet":"R5","index":19,"n_rows":33,"n_cols":16,"rows_kept":33,"cut":false,"hidden":false,"merged":[[15,3,15,8],[16,3,20,3],[9,14,14,15],[11,8,11,11],[12,8,12,11],[13,8,13,11],[14,8,14,11],[16,5,16,6],[8,3,8,8],[9,3,14,3],[9,5,9,7],[9,8,10,11],[9,12,9,13],[29,10,29,12],[16,13,20,15],[18,7,18,9],[19,7,19,9],[20,7,20,9],[16,7,17,9],[16,10,16,12],[29,13,33,15],[31,7,31,9],[32,7,32,9],[21,3,21,8],[22,3,27,3],[22,5,23,6],[22,7,22,12],[22,13,22,15],[24,5,24,6],[27,5,27,6],[28,3,28,8],[29,3,33,3],[29,5,29,6],[29,7,30,9]]}
[]
[null,null,null,"Risk Number","R5"]
[null,null,null,"Risk Event Title","Scanning takes very long at import side"]
[null,null,null,"Risk Description","If goods arrive via Rotterdam container scanning is a big issue. It can take up to one week before the container is scanned. For sensitive goods that can affect the quality. For some fruits coming from Columbia the damage of the delay can be so big that the whole cargo is lost.\r\nJamboFresh had a period that 75% of the cargo was selected for a scan – where?. They were very surprised by this high rate. In other periods they have much less scans but in this specific period the scanning rate was very high\r\n"]
[null,null,null,"Probability of occurance",{"$f":"ProbabiltyGrade(H5)","v":"M"},null,"Value",{"$f":"MAX(N12:N14)/100","v":0.6}]
[null,null,null,"Analysis Method","Bow-Tie Analysis"]
[]
[]
[null,null,null,"Causes Details"]
[null," ",null,null,"Number","Agent",null,null,"Cause Description",null,null,null,"Likelihood of Occurrence (%)"]
[null,null,null,null,"C#","External Factor","Actor","Risk Event",null,null,null,null,"Before Preventive Action","After Preventive Action"]
[null,null,null,null,"C1","-","Customs Import","-","JamboFresh had a period that 75% of the cargo was selected for a scan ",null,null,null,60,{"$f":"M12*(100-MAX(K19:K21))/100","v":60}]
[null,null,null,null,"C2","-","Wintech ","-",null,null,null,null,45,{"$f":"M13*(100-MAX(L19:L21))/100","v":45}]
[null,null,null,null,"C3","-","-","-","Enter Cause Details",null,null,null,0,{"$f":"M14*(100-MAX(M19:M21))/100","v":0}]
[]
[null,null,null,"Preventive Actions"]
[null,null,null,null,"Number","Agents",null,"Action Description",null,null,"Effectiveness on"]
[null,null,null,null,"PA#","Actor 1","Actor 2",null,null,null,"C1","C2","C3"]
[null,null,null,null,"PA1",null,null,"None",null,null,0,0,0]
[null,null,null,null,"PA2",null,null,"None",null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,"Consequence Details"]
[null,null,null,null,"Number","Consequence Description",null,"Actor Impacts",null,null,null,null,null,"After Corrective action"]
[null,null,null,null,"C#",null,null,"Actor 1","Impact 1","Actor 2 ","Impact 2","Actor 3","Impact 3","Impact 1","Impact 2","Impact 3"]
[null,null,null,null,"Q1","There can be demurrage costs also which amount to around 300 euros",null,"Jambo Fresh",10000,null,0,null,0,{"$f":"I25*(100-MAX($K$32:$K$34))/100","v":10000},{"$f":"K25*(100-MAX($K$32:$K$34))/100","v":0},{"$f":"M25*(100-MAX($K$32:$K$34))/100","v":0}]
[null,null,null,null,"Q2",null,null,null,0,null,0,null,0,{"$f":"I26*(100-MAX($L$32:$L$34))/100","v":0},{"$f":"K26*(100-MAX($L$32:$L$34))/100","v":0},{"$f":"M26*(100-MAX($L$32:$L$34))/100","v":0}]
[null,null,null,null,"Q3",null,null,null,0,null,0,null,0,{"$f":"I27*(100-MAX($M$32:$M$34))/100","v":0},{"$f":"K27*(100-MAX($M$32:$M$34))/100","v":0},{"$f":"M27*(100-MAX($M$32:$M$34))/100","v":0}]
[]
[null,null,null,"Corretive Actions"]
[null,null,null,null,"Number","Agent",null,"Action Description",null,null,"Effectiveness on"]
[null,null,null,null,"C#","Actor 1","Actor 2",null,null,null,"Q1","Q2","Q3"]
[null,null,null,null,"CA1",null,null,"None",null,null,0,0,0]
[null,null,null,null,"CA2",null,null,"None",null,null,0,0,0]

{"sheet":"R6","index":20,"n_rows":33,"n_cols":16,"rows_kept":33,"cut":false,"hidden":false,"merged":[[15,3,15,8],[16,3,20,3],[9,14,14,15],[11,8,11,11],[12,8,12,11],[13,8,13,11],[14,8,14,11],[16,5,16,6],[8,3,8,8],[9,3,14,3],[9,5,9,7],[9,8,10,11],[9,12,9,13],[29,10,29,12],[16,13,20,15],[18,7,18,9],[19,7,19,9],[20,7,20,9],[16,7,17,9],[16,10,16,12],[29,13,33,15],[31,7,31,9],[32,7,32,9],[21,3,21,8],[22,3,27,3],[22,5,23,6],[22,7,22,12],[22,13,22,15],[24,5,24,6],[27,5,27,6],[28,3,28,8],[29,3,33,3],[29,5,29,6],[29,7,30,9]]}
[]
[null,null,null,"Risk Number","R6"]
[null,null,null,"Risk Event Title","Long waiting times at the customs"]
[null,null,null,"Risk Description","There were some cases of customs declaration system down during the working day (from 9.00 am morning to 15.00 – 16.00 pm). With such process that works out of business expectation, JamboFresh needs to manage the order delivery to the customers"]
[null,null,null,"Probability of occurance",{"$f":"ProbabiltyGrade(H5)","v":"VL"},null,"Value",{"$f":"MAX(N12:N14)/100","v":0.2}]
[null,null,null,"Analysis Method","Bow-Tie Analysis"]
[]
[]
[null,null,null,"Causes Details"]
[null," ",null,null,"Number","Agent",null,null,"Cause Description",null,null,null,"Likelihood of Occurrence (%)"]
[null,null,null,null,"C#","External Factor","Actor","Risk Event",null,null,null,null,"Before Preventive Action","After Preventive Action"]
[null,null,null,null,"C1","-","Customs Import","-","Customs declaration systems go down",null,null,null,5,{"$f":"M12*(100-MAX(K19:K21))/100","v":5}]
[null,null,null,null,"C2","-","Wintech ","-","Original bill of landing not yet received",null,null,null,20,{"$f":"M13*(100-MAX(L19:L21))/100","v":20}]
[null,null,null,null,"C3","-","-","-","Enter Cause Details",null,null,null,0,{"$f":"M14*(100-MAX(M19:M21))/100","v":0}]
[]
[null,null,null,"Preventive Actions"]
[null,null,null,null,"Number","Agents",null,"Action Description",null,null,"Effectiveness on"]
[null,null,null,null,"PA#","Actor 1","Actor 2",null,null,null,"C1","C2","C3"]
[null,null,null,null,"PA1",null,null,"None",null,null,0,0,0]
[null,null,null,null,"PA2",null,null,"None",null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,"Consequence Details"]
[null,null,null,null,"Number","Consequence Description",null,"Actor Impacts",null,null,null,null,null,"After Corrective action"]
[null,null,null,null,"C#",null,null,"Actor 1","Impact 1","Actor 2 ","Impact 2","Actor 3","Impact 3","Impact 1","Impact 2","Impact 3"]
[null,null,null,null,"Q1","There can be demurrage costs also which amount to around 300 euros",null,"Jambo Fresh",10000," ",0,null,0,{"$f":"I25*(100-MAX($K$32:$K$34))/100","v":10000},{"$f":"K25*(100-MAX($K$32:$K$34))/100","v":0},{"$f":"M25*(100-MAX($K$32:$K$34))/100","v":0}]
[null,null,null,null,"Q2",null,null,null,0,null,0,null,0,{"$f":"I26*(100-MAX($L$32:$L$34))/100","v":0},{"$f":"K26*(100-MAX($L$32:$L$34))/100","v":0},{"$f":"M26*(100-MAX($L$32:$L$34))/100","v":0}]
[null,null,null,null,"Q3",null,null,null,0,null,0,null,0,{"$f":"I27*(100-MAX($M$32:$M$34))/100","v":0},{"$f":"K27*(100-MAX($M$32:$M$34))/100","v":0},{"$f":"M27*(100-MAX($M$32:$M$34))/100","v":0}]
[]
[null,null,null,"Corretive Actions"]
[null,null,null,null,"Number","Agent",null,"Action Description",null,null,"Effectiveness on"]
[null,null,null,null,"C#","Actor 1","Actor 2",null,null,null,"Q1","Q2","Q3"]
[null,null,null,null,"CA1",null,null,"None",null,null,0,0,0]
[null,null,null,null,"CA2",null,null,"None",null,null,0,0,0]

{"sheet":"R7","index":21,"n_rows":33,"n_cols":16,"rows_kept":33,"cut":false,"hidden":false,"merged":[[15,3,15,8],[16,3,20,3],[9,14,14,15],[11,8,11,11],[12,8,12,11],[13,8,13,11],[14,8,14,11],[16,5,16,6],[8,3,8,8],[9,3,14,3],[9,5,9,7],[9,8,10,11],[9,12,9,13],[29,10,29,12],[16,13,20,15],[18,7,18,9],[19,7,19,9],[20,7,20,9],[16,7,17,9],[16,10,16,12],[29,13,33,15],[31,7,31,9],[32,7,32,9],[21,3,21,8],[22,3,27,3],[22,5,23,6],[22,7,22,12],[22,13,22,15],[24,5,24,6],[27,5,27,6],[28,3,28,8],[29,3,33,3],[29,5,29,6],[29,7,30,9]]}
[]
[null,null,null,"Risk Number","R7"]
[null,null,null,"Risk Event Title","Breakage of container door seal during the transport"]
[null,null,null,"Risk Description","This is a serious concern for JF. If the temperature is destabilized, fruit ripening begins and Ethylene gas is released. This gas can transiently increase the ripening rate of the fruits. If unattended, the whole cargo can be lost. This is a high risk especially if the temperature is destabilized at the export side and not so much at the import side. The loss can be that the whole cargo is damaged amounting to 30k euros directly. "]
[null,null,null,"Probability of occurance",{"$f":"ProbabiltyGrade(H5)","v":"L"},null,"Value",{"$f":"MAX(N12:N14)/100","v":0.25}]
[null,null,null,"Analysis Method","Bow-Tie Analysis"]
[]
[]
[null,null,null,"Causes Details"]
[null," ",null,null,"Number","Agent",null,null,"Cause Description",null,null,null,"Likelihood of Occurrence (%)"]
[null,null,null,null,"C#","External Factor","Actor","Risk Event",null,null,null,null,"Before Preventive Action","After Preventive Action"]
[null,null,null,null,"C1","-","Customs Import","-","Seal can be broken during inspection ",null,null,null,25,{"$f":"M12*(100-MAX(K19:K21))/100","v":25}]
[null,null,null,null,"C2","-","-","-","Enter Cause Details",null,null,null,0,{"$f":"M13*(100-MAX(L19:L21))/100","v":0}]
[null,null,null,null,"C3","-","Customs Import","-","Enter Cause Details",null,null,null,0,{"$f":"M14*(100-MAX(M19:M21))/100","v":0}]
[]
[null,null,null,"Preventive Actions"]
[null,null,null,null,"Number","Agents",null,"Action Description",null,null,"Effectiveness on"]
[null,null,null,null,"PA#","Actor 1","Actor 2",null,null,null,"C1","C2","C3"]
[null,null,null,null,"PA1",null,null,"What is the preventive action?",null,null,0,0,0]
[null,null,null,null,"PA2",null,null,"What is the preventive action?",null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,"Consequence Details"]
[null,null,null,null,"Number","Consequence Description",null,"Actor Impacts",null,null,null,null,null,"After Corrective action"]
[null,null,null,null,"C#",null,null,"Actor 1","Impact 1","Actor 2 ","Impact 2","Actor 3","Impact 3","Impact 1","Impact 2","Impact 3"]
[null,null,null,null,"Q1","The loss can be that the whole cargo is damaged amounting to 30k euros directly. ",null,"Jambo Fresh",30000," ",0,null,0,{"$f":"I25*(100-MAX($K$32:$K$34))/100","v":30000},{"$f":"K25*(100-MAX($K$32:$K$34))/100","v":0},{"$f":"M25*(100-MAX($K$32:$K$34))/100","v":0}]
[null,null,null,null,"Q2",null,null,null,0,null,0,null,0,{"$f":"I26*(100-MAX($L$32:$L$34))/100","v":0},{"$f":"K26*(100-MAX($L$32:$L$34))/100","v":0},{"$f":"M26*(100-MAX($L$32:$L$34))/100","v":0}]
[null,null,null,null,"Q3",null,null,null,0,null,0,null,0,{"$f":"I27*(100-MAX($M$32:$M$34))/100","v":0},{"$f":"K27*(100-MAX($M$32:$M$34))/100","v":0},{"$f":"M27*(100-MAX($M$32:$M$34))/100","v":0}]
[]
[null,null,null,"Corretive Actions"]
[null,null,null,null,"Number","Agent",null,"Action Description",null,null,"Effectiveness on"]
[null,null,null,null,"C#","Actor 1","Actor 2",null,null,null,"Q1","Q2","Q3"]
[null,null,null,null,"CA1","Shipowner","Shippers","What is the corrective action?",null,null,0,0,0]
[null,null,null,null,"CA2","Logistic Operator","Shippers","What is the corrective action?",null,null,0,0,0]

{"sheet":"Sheet29","index":22,"n_rows":14,"n_cols":14,"rows_kept":14,"cut":false,"hidden":true,"merged":[]}
[25,3,32,33,null,null,null,null,null,14,15,0,0,0]
[]
[]
[]
[null,null,null,null,null,33,3]
[]
[]
[null,null,null,null,null,null,null,null,null,2,33,30]
[]
[null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[]
[null,null,null,102]
[null,null,null,38.25]
[null,null,null,25.5]

{"sheet":"R8","index":23,"n_rows":33,"n_cols":16,"rows_kept":33,"cut":false,"hidden":false,"merged":[[15,3,15,8],[16,3,20,3],[9,14,14,15],[11,8,11,11],[12,8,12,11],[13,8,13,11],[14,8,14,11],[16,5,16,6],[8,3,8,8],[9,3,14,3],[9,5,9,7],[9,8,10,11],[9,12,9,13],[29,10,29,12],[16,13,20,15],[18,7,18,9],[19,7,19,9],[20,7,20,9],[16,7,17,9],[16,10,16,12],[29,13,33,15],[31,7,31,9],[32,7,32,9],[21,3,21,8],[22,3,27,3],[22,5,23,6],[22,7,22,12],[22,13,22,15],[24,5,24,6],[27,5,27,6],[28,3,28,8],[29,3,33,3],[29,5,29,6],[29,7,30,9]]}
[]
[null,null,null,"Risk Number","R8"]
[null,null,null,"Risk Event Title","Issue with Document Proof for road transport (“bewijs van wegvervoer”) at Belgium customs"]
[null,null,null,"Risk Description","Description of the event"]
[null,null,null,"Probability of occurance",{"$f":"ProbabiltyGrade(H5)","v":"VL"},null,"Value",{"$f":"MAX(N12:N14)/100","v":0}]
[null,null,null,"Analysis Method","Bow-Tie Analysis"]
[]
[]
[null,null,null,"Causes Details"]
[null," ",null,null,"Number","Agent",null,null,"Cause Description",null,null,null,"Likelihood of Occurrence (%)"]
[null,null,null,null,"C#","External Factor","Actor","Risk Event",null,null,null,null,"Before Preventive Action","After Preventive Action"]
[null,null,null,null,"C1","-","-","-","Enter Cause Details",null,null,null,0,{"$f":"M12*(100-MAX(K19:K21))/100","v":0}]
[null,null,null,null,"C2","-","-","-","Enter Cause Details",null,null,null,0,{"$f":"M13*(100-MAX(L19:L21))/100","v":0}]
[null,null,null,null,"C3","-","-","-","Enter Cause Details",null,null,null,0,{"$f":"M14*(100-MAX(M19:M21))/100","v":0}]
[]
[null,null,null,"Preventive Actions"]
[null,null,null,null,"Number","Agents",null,"Action Description",null,null,"Effectiveness on"]
[null,null,null,null,"PA#","Actor 1","Actor 2",null,null,null,"C1","C2","C3"]
[null,null,null,null,"PA1",null,null,"What is the preventive action?",null,null,0,0,0]
[null,null,null,null,"PA2",null,null,"What is the preventive action?",null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,"Consequence Details"]
[null,null,null,null,"Number","Consequence Description",null,"Actor Impacts",null,null,null,null,null,"After Corrective action"]
[null,null,null,null,"C#",null,null,"Actor 1","Impact 1","Actor 2 ","Impact 2","Actor 3","Impact 3","Impact 1","Impact 2","Impact 3"]
[null,null,null,null,"Q1",null,null,null,0,null,0,null,0,{"$f":"I25*(100-MAX($K$32:$K$34))/100","v":0},{"$f":"K25*(100-MAX($K$32:$K$34))/100","v":0},{"$f":"M25*(100-MAX($K$32:$K$34))/100","v":0}]
[null,null,null,null,"Q2",null,null,null,0,null,0,null,0,{"$f":"I26*(100-MAX($L$32:$L$34))/100","v":0},{"$f":"K26*(100-MAX($L$32:$L$34))/100","v":0},{"$f":"M26*(100-MAX($L$32:$L$34))/100","v":0}]
[null,null,null,null,"Q3",null,null,null,0,null,0,null,0,{"$f":"I27*(100-MAX($M$32:$M$34))/100","v":0},{"$f":"K27*(100-MAX($M$32:$M$34))/100","v":0},{"$f":"M27*(100-MAX($M$32:$M$34))/100","v":0}]
[]
[null,null,null,"Corretive Actions"]
[null,null,null,null,"Number","Agent",null,"Action Description",null,null,"Effectiveness on"]
[null,null,null,null,"C#","Actor 1","Actor 2",null,null,null,"Q1","Q2","Q3"]
[null,null,null,null,"CA1","Shipowner","Shippers","What is the corrective action?",null,null,0,0,0]
[null,null,null,null,"CA2","Logistic Operator","Shippers","What is the corrective action?",null,null,0,0,0]

{"sheet":"R9","index":24,"n_rows":33,"n_cols":16,"rows_kept":33,"cut":false,"hidden":false,"merged":[[15,3,15,8],[16,3,20,3],[9,14,14,15],[11,8,11,11],[12,8,12,11],[13,8,13,11],[14,8,14,11],[16,5,16,6],[8,3,8,8],[9,3,14,3],[9,5,9,7],[9,8,10,11],[9,12,9,13],[29,10,29,12],[16,13,20,15],[18,7,18,9],[19,7,19,9],[20,7,20,9],[16,7,17,9],[16,10,16,12],[29,13,33,15],[31,7,31,9],[32,7,32,9],[21,3,21,8],[22,3,27,3],[22,5,23,6],[22,7,22,12],[22,13,22,15],[24,5,24,6],[27,5,27,6],[28,3,28,8],[29,3,33,3],[29,5,29,6],[29,7,30,9]]}
[]
[null,null,null,"Risk Number","R9"]
[null,null,null,"Risk Event Title","Sometimes vessels arrive at ports other than Antwerp "]
[null,null,null,"Risk Description","The vessel normally arrives in Antwerp, but sometimes they go via Felixstowe. When the ship arrives in the weekend some ports do not do handling in the weekend, the port of Rotterdam does. So it can happen that the goods arrive at port of Rotterdam as well"]
[null,null,null,"Probability of occurance",{"$f":"ProbabiltyGrade(H5)","v":"VL"},null,"Value",{"$f":"MAX(N12:N14)/100","v":0.2}]
[null,null,null,"Analysis Method","Bow-Tie Analysis"]
[]
[]
[null,null,null,"Causes Details"]
[null," ",null,null,"Number","Agent",null,null,"Cause Description",null,null,null,"Likelihood of Occurrence (%)"]
[null,null,null,null,"C#","External Factor","Actor","Risk Event",null,null,null,null,"Before Preventive Action","After Preventive Action"]
[null,null,null,null,"C1","-","Safmarine","-","Rerouting by the shipper",null,null,null,20,{"$f":"M12*(100-MAX(K19:K21))/100","v":20}]
[null,null,null,null,"C2","-","-","-","Enter Cause Details",null,null,null,0,{"$f":"M13*(100-MAX(L19:L21))/100","v":0}]
[null,null,null,null,"C3","-","-","-","Enter Cause Details",null,null,null,0,{"$f":"M14*(100-MAX(M19:M21))/100","v":0}]
[]
[null,null,null,"Preventive Actions"]
[null,null,null,null,"Number","Agents",null,"Action Description",null,null,"Effectiveness on"]
[null,null,null,null,"PA#","Actor 1","Actor 2",null,null,null,"C1","C2","C3"]
[null,null,null,null,"PA1",null,null,"What is the preventive action?",null,null,0,0,0]
[null,null,null,null,"PA2",null,null,"What is the preventive action?",null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,"Consequence Details"]
[null,null,null,null,"Number","Consequence Description",null,"Actor Impacts",null,null,null,null,null,"After Corrective action"]
[null,null,null,null,"C#",null,null,"Actor 1","Impact 1","Actor 2 ","Impact 2","Actor 3","Impact 3","Impact 1","Impact 2","Impact 3"]
[null,null,null,null,"Q1","Delay of few days ",null,"Jambo Fresh",20000,null,0,null,0,{"$f":"I25*(100-MAX($K$32:$K$34))/100","v":20000},{"$f":"K25*(100-MAX($K$32:$K$34))/100","v":0},{"$f":"M25*(100-MAX($K$32:$K$34))/100","v":0}]
[null,null,null,null,"Q2",null,null,null,0,null,0,null,0,{"$f":"I26*(100-MAX($L$32:$L$34))/100","v":0},{"$f":"K26*(100-MAX($L$32:$L$34))/100","v":0},{"$f":"M26*(100-MAX($L$32:$L$34))/100","v":0}]
[null,null,null,null,"Q3",null,null,null,0,null,0,null,0,{"$f":"I27*(100-MAX($M$32:$M$34))/100","v":0},{"$f":"K27*(100-MAX($M$32:$M$34))/100","v":0},{"$f":"M27*(100-MAX($M$32:$M$34))/100","v":0}]
[]
[null,null,null,"Corretive Actions"]
[null,null,null,null,"Number","Agent",null,"Action Description",null,null,"Effectiveness on"]
[null,null,null,null,"C#","Actor 1","Actor 2",null,null,null,"Q1","Q2","Q3"]
[null,null,null,null,"CA1","Shipowner","Shippers","What is the corrective action?",null,null,0,0,0]
[null,null,null,null,"CA2","Logistic Operator","Shippers","What is the corrective action?",null,null,0,0,0]

{"sheet":"R10","index":25,"n_rows":33,"n_cols":16,"rows_kept":33,"cut":false,"hidden":false,"merged":[[15,3,15,8],[16,3,20,3],[9,14,14,15],[11,8,11,11],[12,8,12,11],[13,8,13,11],[14,8,14,11],[16,5,16,6],[8,3,8,8],[9,3,14,3],[9,5,9,7],[9,8,10,11],[9,12,9,13],[29,10,29,12],[16,13,20,15],[18,7,18,9],[19,7,19,9],[20,7,20,9],[16,7,17,9],[16,10,16,12],[29,13,33,15],[31,7,31,9],[32,7,32,9],[21,3,21,8],[22,3,27,3],[22,5,23,6],[22,7,22,12],[22,13,22,15],[24,5,24,6],[27,5,27,6],[28,3,28,8],[29,3,33,3],[29,5,29,6],[29,7,30,9]]}
[]
[null,null,null,"Risk Number","R10"]
[null,null,null,"Risk Event Title","Possibility of missing the vessel during trans-shipment"]
[null,null,null,"Risk Description","Big problem is when the goods are transferred from a smaller vessel to a bigger ship (there is a transshipment). For goods coming from Mombasa there is always a transshipment, as the big boats do not travel to Mombasa. The transshipment takes place in Salalah and there are big boats coming from China. If you miss the boat then it take a week. So at times it takes 21 days to receive the container but sometimes more than 30 days. The problem with missing the boat is not so much on the Kenyan port but on the transshipment port"]
[null,null,null,"Probability of occurance",{"$f":"ProbabiltyGrade(H5)","v":"VL"},null,"Value",{"$f":"MAX(N12:N14)/100","v":0.05}]
[null,null,null,"Analysis Method","Bow-Tie Analysis"]
[]
[]
[null,null,null,"Causes Details"]
[null," ",null,null,"Number","Agent",null,null,"Cause Description",null,null,null,"Likelihood of Occurrence (%)"]
[null,null,null,null,"C#","External Factor","Actor","Risk Event",null,null,null,null,"Before Preventive Action","After Preventive Action"]
[null,null,null,null,"C1","-","Safmarine","-","Transshipment at Salalah",null,null,null,5,{"$f":"M12*(100-MAX(K19:K21))/100","v":5}]
[null,null,null,null,"C2","-","-","-","Enter Cause Details",null,null,null,0,{"$f":"M13*(100-MAX(L19:L21))/100","v":0}]
[null,null,null,null,"C3","-","-","-","Enter Cause Details",null,null,null,0,{"$f":"M14*(100-MAX(M19:M21))/100","v":0}]
[]
[null,null,null,"Preventive Actions"]
[null,null,null,null,"Number","Agents",null,"Action Description",null,null,"Effectiveness on"]
[null,null,null,null,"PA#","Actor 1","Actor 2",null,null,null,"C1","C2","C3"]
[null,null,null,null,"PA1",null,null,"What is the preventive action?",null,null,0,0,0]
[null,null,null,null,"PA2",null,null,"What is the preventive action?",null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,"Consequence Details"]
[null,null,null,null,"Number","Consequence Description",null,"Actor Impacts",null,null,null,null,null,"After Corrective action"]
[null,null,null,null,"C#",null,null,"Actor 1","Impact 1","Actor 2 ","Impact 2","Actor 3","Impact 3","Impact 1","Impact 2","Impact 3"]
[null,null,null,null,"Q1","Delay of 30 days could mean there is a loss of whole cargo",null,"Jambo Fresh",30000,null,0,null,0,{"$f":"I25*(100-MAX($K$32:$K$34))/100","v":30000},{"$f":"K25*(100-MAX($K$32:$K$34))/100","v":0},{"$f":"M25*(100-MAX($K$32:$K$34))/100","v":0}]
[null,null,null,null,"Q2",null,null,null,0,null,0,null,0,{"$f":"I26*(100-MAX($L$32:$L$34))/100","v":0},{"$f":"K26*(100-MAX($L$32:$L$34))/100","v":0},{"$f":"M26*(100-MAX($L$32:$L$34))/100","v":0}]
[null,null,null,null,"Q3",null,null,null,0,null,0,null,0,{"$f":"I27*(100-MAX($M$32:$M$34))/100","v":0},{"$f":"K27*(100-MAX($M$32:$M$34))/100","v":0},{"$f":"M27*(100-MAX($M$32:$M$34))/100","v":0}]
[]
[null,null,null,"Corretive Actions"]
[null,null,null,null,"Number","Agent",null,"Action Description",null,null,"Effectiveness on"]
[null,null,null,null,"C#","Actor 1","Actor 2",null,null,null,"Q1","Q2","Q3"]
[null,null,null,null,"CA1","Safmarine"," ","Jambo Fresh can put a claim of",null,null,0,0,0]
[null,null,null,null,"CA2","Logistic Operator","Shippers","What is the corrective action?",null,null,0,0,0]

{"sheet":"R11","index":26,"n_rows":33,"n_cols":16,"rows_kept":33,"cut":false,"hidden":false,"merged":[[15,3,15,8],[16,3,20,3],[9,14,14,15],[11,8,11,11],[12,8,12,11],[13,8,13,11],[14,8,14,11],[16,5,16,6],[8,3,8,8],[9,3,14,3],[9,5,9,7],[9,8,10,11],[9,12,9,13],[29,10,29,12],[16,13,20,15],[18,7,18,9],[19,7,19,9],[20,7,20,9],[16,7,17,9],[16,10,16,12],[29,13,33,15],[31,7,31,9],[32,7,32,9],[21,3,21,8],[22,3,27,3],[22,5,23,6],[22,7,22,12],[22,13,22,15],[24,5,24,6],[27,5,27,6],[28,3,28,8],[29,3,33,3],[29,5,29,6],[29,7,30,9]]}
[]
[null,null,null,"Risk Number","R11"]
[null,null,null,"Risk Event Title","Missing Container"]
[null,null,null,"Risk Description","In practice it has happened that a container is lost. From earlier experiences they know of two cases when a container lots and reappears 7-8 months later. So the container is at the end there but the cargo is completely damaged. The value was in the range of 80 000 euros"]
[null,null,null,"Probability of occurance",{"$f":"ProbabiltyGrade(H5)","v":"VL"},null,"Value",{"$f":"MAX(N12:N14)/100","v":0.05}]
[null,null,null,"Analysis Method","Bow-Tie Analysis"]
[]
[]
[null,null,null,"Causes Details"]
[null," ",null,null,"Number","Agent",null,null,"Cause Description",null,null,null,"Likelihood of Occurrence (%)"]
[null,null,null,null,"C#","External Factor","Actor","Risk Event",null,null,null,null,"Before Preventive Action","After Preventive Action"]
[null,null,null,null,"C1","-","-","-","Enter Cause Details",null,null,null,5,{"$f":"M12*(100-MAX(K19:K21))/100","v":5}]
[null,null,null,null,"C2","-","-","-","Enter Cause Details",null,null,null,0,{"$f":"M13*(100-MAX(L19:L21))/100","v":0}]
[null,null,null,null,"C3","-","-","-","Enter Cause Details",null,null,null,0,{"$f":"M14*(100-MAX(M19:M21))/100","v":0}]
[]
[null,null,null,"Preventive Actions"]
[null,null,null,null,"Number","Agents",null,"Action Description",null,null,"Effectiveness on"]
[null,null,null,null,"PA#","Actor 1","Actor 2",null,null,null,"C1","C2","C3"]
[null,null,null,null,"PA1",null,null,"What is the preventive action?",null,null,0,0,0]
[null,null,null,null,"PA2",null,null,"What is the preventive action?",null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,"Consequence Details"]
[null,null,null,null,"Number","Consequence Description",null,"Actor Impacts",null,null,null,null,null,"After Corrective action"]
[null,null,null,null,"C#",null,null,"Actor 1","Impact 1","Actor 2 ","Impact 2","Actor 3","Impact 3","Impact 1","Impact 2","Impact 3"]
[null,null,null,null,"Q1","Whole cargo can be damaged",null,"Jambo Fresh",50000,null,0,null,0,{"$f":"I25*(100-MAX($K$32:$K$34))/100","v":50000},{"$f":"K25*(100-MAX($K$32:$K$34))/100","v":0},{"$f":"M25*(100-MAX($K$32:$K$34))/100","v":0}]
[null,null,null,null,"Q2",null,null,null,0,null,0,null,0,{"$f":"I26*(100-MAX($L$32:$L$34))/100","v":0},{"$f":"K26*(100-MAX($L$32:$L$34))/100","v":0},{"$f":"M26*(100-MAX($L$32:$L$34))/100","v":0}]
[null,null,null,null,"Q3",null,null,null,0,null,0,null,0,{"$f":"I27*(100-MAX($M$32:$M$34))/100","v":0},{"$f":"K27*(100-MAX($M$32:$M$34))/100","v":0},{"$f":"M27*(100-MAX($M$32:$M$34))/100","v":0}]
[]
[null,null,null,"Corretive Actions"]
[null,null,null,null,"Number","Agent",null,"Action Description",null,null,"Effectiveness on"]
[null,null,null,null,"C#","Actor 1","Actor 2",null,null,null,"Q1","Q2","Q3"]
[null,null,null,null,"CA1","Safmarine"," ","Putting a claim on Safmarine",null,null,0,0,0]
[null,null,null,null,"CA2","Logistic Operator","Shippers","What is the corrective action?",null,null,0,0,0]

{"sheet":"R12","index":27,"n_rows":33,"n_cols":16,"rows_kept":33,"cut":false,"hidden":false,"merged":[[15,3,15,8],[16,3,20,3],[9,14,14,15],[11,8,11,11],[12,8,12,11],[13,8,13,11],[14,8,14,11],[16,5,16,6],[8,3,8,8],[9,3,14,3],[9,5,9,7],[9,8,10,11],[9,12,9,13],[29,10,29,12],[16,13,20,15],[18,7,18,9],[19,7,19,9],[20,7,20,9],[16,7,17,9],[16,10,16,12],[29,13,33,15],[31,7,31,9],[32,7,32,9],[21,3,21,8],[22,3,27,3],[22,5,23,6],[22,7,22,12],[22,13,22,15],[24,5,24,6],[27,5,27,6],[28,3,28,8],[29,3,33,3],[29,5,29,6],[29,7,30,9]]}
[]
[null,null,null,"Risk Number","R12"]
[null,null,null,"Risk Event Title","Improper - phyto documentation"]
[null,null,null,"Risk Description","Wintech fails to send the courier containing original bill of landing in time. To save some money, the employees at Wintech wait of different bills of landing to accumulate and send them in one courier. JF has recommended Wintech to use DHL but they cannot enforce."]
[null,null,null,"Probability of occurance",{"$f":"ProbabiltyGrade(H5)","v":"M"},null,"Value",{"$f":"MAX(N12:N14)/100","v":0.45}]
[null,null,null,"Analysis Method","Bow-Tie Analysis"]
[]
[]
[null,null,null,"Causes Details"]
[null," ",null,null,"Number","Agent",null,null,"Cause Description",null,null,null,"Likelihood of Occurrence (%)"]
[null,null,null,null,"C#","External Factor","Actor","Risk Event",null,null,null,null,"Before Preventive Action","After Preventive Action"]
[null,null,null,null,"C1","-","Wintech ","-","Administrative errors at Wintech side",null,null,null,45,{"$f":"M12*(100-MAX(K19:K21))/100","v":45}]
[null,null,null,null,"C2","-","-","-","Enter Cause Details",null,null,null,0,{"$f":"M13*(100-MAX(L19:L21))/100","v":0}]
[null,null,null,null,"C3","-","-","-","Enter Cause Details",null,null,null,0,{"$f":"M14*(100-MAX(M19:M21))/100","v":0}]
[]
[null,null,null,"Preventive Actions"]
[null,null,null,null,"Number","Agents",null,"Action Description",null,null,"Effectiveness on"]
[null,null,null,null,"PA#","Actor 1","Actor 2",null,null,null,"C1","C2","C3"]
[null,null,null,null,"PA1",null,null,"None",null,null,0,0,0]
[null,null,null,null,"PA2",null,null,"None",null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,"Consequence Details"]
[null,null,null,null,"Number","Consequence Description",null,"Actor Impacts",null,null,null,null,null,"After Corrective action"]
[null,null,null,null,"C#",null,null,"Actor 1","Impact 1","Actor 2 ","Impact 2","Actor 3","Impact 3","Impact 1","Impact 2","Impact 3"]
[null,null,null,null,"Q1","Delay of few days ",null,"Jambo Fresh",10000,null,0,null,0,{"$f":"I25*(100-MAX($K$32:$K$34))/100","v":10000},25,{"$f":"M25*(100-MAX($K$32:$K$34))/100","v":0}]
[null,null,null,null,"Q2",null,null,null,0,null,0,null,0,{"$f":"I26*(100-MAX($L$32:$L$34))/100","v":0},{"$f":"K26*(100-MAX($L$32:$L$34))/100","v":0},{"$f":"M26*(100-MAX($L$32:$L$34))/100","v":0}]
[null,null,null,null,"Q3",null,null,null,0,null,0,null,0,{"$f":"I27*(100-MAX($M$32:$M$34))/100","v":0},{"$f":"K27*(100-MAX($M$32:$M$34))/100","v":0},{"$f":"M27*(100-MAX($M$32:$M$34))/100","v":0}]
[]
[null,null,null,"Corretive Actions"]
[null,null,null,null,"Number","Agent",null,"Action Description",null,null,"Effectiveness on"]
[null,null,null,null,"C#","Actor 1","Actor 2",null,null,null,"Q1","Q2","Q3"]
[null,null,null,null,"CA1",null,null,"None",null,null,0,0,0]
[null,null,null,null,"CA2",null,null,"None",null,null,0,0,0]

{"sheet":"R14","index":28,"n_rows":33,"n_cols":16,"rows_kept":33,"cut":false,"hidden":true,"merged":[[15,3,15,8],[16,3,20,3],[9,14,14,15],[11,8,11,11],[12,8,12,11],[13,8,13,11],[14,8,14,11],[8,3,8,8],[9,3,14,3],[9,5,9,7],[9,8,10,11],[9,12,9,13],[29,7,30,9],[29,10,29,12],[16,13,20,15],[18,7,18,9],[19,7,19,9],[20,7,20,9],[16,5,16,6],[16,7,17,9],[16,10,16,12],[29,13,33,15],[31,7,31,9],[32,7,32,9],[21,3,21,8],[22,3,27,3],[22,5,23,6],[22,7,22,12],[22,13,22,15],[24,5,24,6],[27,5,27,6],[28,3,28,8],[29,3,33,3],[29,5,29,6]]}
[]
[null,null,null,"Risk Number","R14"]
[null,null,null,"Risk Event Title","Enter the event "]
[null,null,null,"Risk Description","Description of the event"]
[null,null,null,"Probability of occurance",{"$f":"ProbabiltyGrade(H5)","v":"VL"},null,"Value",{"$f":"MAX(N12:N14)/100","v":0}]
[null,null,null,"Analysis Method","Bow-Tie Analysis"]
[]
[]
[null,null,null,"Causes Details"]
[null," ",null,null,"Number","Agent",null,null,"Cause Description",null,null,null,"Likelihood of Occurrence (%)"]
[null,null,null,null,"C#","External Factor","Actor","Risk Event",null,null,null,null,"Before Preventive Action","After Preventive Action"]
[null,null,null,null,"C1","-","-","-","Enter Cause Details",null,null,null,0,{"$f":"M12*(100-MAX(K19:K21))/100","v":0}]
[null,null,null,null,"C2","-","-","-","Enter Cause Details",null,null,null,0,{"$f":"M13*(100-MAX(L19:L21))/100","v":0}]
[null,null,null,null,"C3","-","-","-","Enter Cause Details",null,null,null,0,{"$f":"M14*(100-MAX(M19:M21))/100","v":0}]
[]
[null,null,null,"Preventive Actions"]
[null,null,null,null,"Number","Agents",null,"Action Description",null,null,"Effectiveness on"]
[null,null,null,null,"PA#","Actor 1","Actor 2",null,null,null,"C1","C2","C3"]
[null,null,null,null,"PA1",null,null,"None",null,null,0,0,0]
[null,null,null,null,"PA2",null,null,"None",null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,"Consequence Details"]
[null,null,null,null,"Number","Consequence Description",null,"Actor Impacts",null,null,null,null,null,"After Corrective action"]
[null,null,null,null,"C#",null,null,"Actor 1","Impact 1","Actor 2 ","Impact 2","Actor 3","Impact 3","Impact 1","Impact 2","Impact 3"]
[null,null,null,null,"Q1",null,null,null,0,null,0,null,0,{"$f":"I25*(100-MAX($K$32:$K$34))/100","v":0},{"$f":"K25*(100-MAX($K$32:$K$34))/100","v":0},{"$f":"M25*(100-MAX($K$32:$K$34))/100","v":0}]
[null,null,null,null,"Q2",null,null,null,0,null,0,null,0,{"$f":"I26*(100-MAX($L$32:$L$34))/100","v":0},{"$f":"K26*(100-MAX($L$32:$L$34))/100","v":0},{"$f":"M26*(100-MAX($L$32:$L$34))/100","v":0}]
[null,null,null,null,"Q3",null,null,null,0,null,0,null,0,{"$f":"I27*(100-MAX($M$32:$M$34))/100","v":0},{"$f":"K27*(100-MAX($M$32:$M$34))/100","v":0},{"$f":"M27*(100-MAX($M$32:$M$34))/100","v":0}]
[]
[null,null,null,"Corretive Actions"]
[null,null,null,null,"Number","Agent",null,"Action Description",null,null,"Effectiveness on"]
[null,null,null,null,"C#","Actor 1","Actor 2",null,null,null,"Q1","Q2","Q3"]
[null,null,null,null,"CA1",null,null,"None",null,null,0,0,0]
[null,null,null,null,"CA2",null,null,"None",null,null,0,0,0]

{"sheet":"Jambo Fresh Matrix","index":29,"n_rows":11,"n_cols":13,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,2,1,5],[2,10,2,12],[3,2,7,2],[9,4,9,8]]}
[]
[null,"Actor  Name","Company X"]
[null,null,null,null,null,null,null,null,null,null,"Prioritization"]
[null,null,"Impact","VH",null,"R7 ","R10 ","R11 ",null,null,"Impact Level","Grade","Color Code"]
[null,null,null,"H","R9 ",null,null,"R1 ",null,null,"Unacceptable","UA"]
[null,null,null,"M","R6 ","R12 ",null,null,"R5 ",null,"Very High","VH"]
[null,null,null,"L",null,null,"R4 ",null,null,null,"High","H"]
[null,null,null,"VL","R8 ",null,"R3 R2 ",null,null,null,"Medium","M"]
[null,null,null,null,"VL","L","M","H","VH",null,"Low","L"]
[null,null,null,null,"Probability",null,null,null,null,null,"Very Low","VL"]
[null,null,null,null,null,null,null,null,null,null,"Acceptable","A"]

{"sheet":"Act1","index":30,"n_rows":33,"n_cols":15,"rows_kept":33,"cut":false,"hidden":false,"merged":[[32,1,32,4],[1,2,1,6],[3,13,3,14],[4,2,9,6],[25,1,26,1],[25,2,26,2],[25,3,25,4]]}
[]
[null,"Actor Number","Act1"]
[null,"Actor Name","Jambo Fresh"]
[null,"Role","Buyer",null,null,null,null,null,null,null,null,null,null,"Impact Range "]
[null,"Description",null,null,null,null,null,null,null,null,null,null,null,"Lower (>)","Upper (<=)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.8,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.6,0.8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.4,0.6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.2,0.4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0.2]
[]
[null,"Impact Evaluation",null,null,null,null,"Risk Evaluation"]
[null,null,"Max","Grade"]
[null,"Enter Maximum  Damage",30000,"VH",null,null,"Risks","Probability of Occurrence","Impact Value","Impact Grade"]
[null,null,null,null,null,null,{"$f":"'Risk Register'!C6","v":"R1"},"H",25000,"H"]
[null,"Categorization",null,null,null,null,{"$f":"'Risk Register'!C7","v":"R2"},"M",0,"VL"]
[null,"Impact Level","Impact Amount","Grade",null,null,{"$f":"'Risk Register'!C8","v":"R3"},"M",0,"VL"]
[null,"Very High",30000,"VH",null,null,{"$f":"'Risk Register'!C9","v":"R4"},"M",1600,"L"]
[null,"High",10000,"H",null,null,{"$f":"'Risk Register'!C10","v":"R5"},"VH",10000,"M"]
[null,"Medium",2500,"M",null,null,{"$f":"'Risk Register'!C11","v":"R6"},{"$f":"Risklikelihood(G20)","v":"VL"},10000,"M"]
[null,"Low",750,"L",null,null,{"$f":"'Risk Register'!C12","v":"R7"},"L",30000,"VH"]
[null,"Very Low",200,"VL",null,null,{"$f":"'Risk Register'!C13","v":"R8"},"VL",0,"VL"]
[null,null,null,null,null,null,{"$f":"'Risk Register'!C14","v":"R9"},"VL",20000,"H"]
[null,null,null,null,null,null,{"$f":"'Risk Register'!C15","v":"R10"},"M",30000,"VH"]
[null,"Scaling used for analysis",null,null,null,null,{"$f":"'Risk Register'!C16","v":"R11"},"H",50000,"VH"]
[null,"Impact Level","Grade","Impact Range ",null,null,{"$f":"'Risk Register'!C17","v":"R12"},"L",10000,"M"]
[null,null,null,"Lower (>)","Upper (<=)",null,null," "]
[null,"Very High","VH",0.8,"-"]
[null,"High","H",0.6,0.8]
[null,"Medium","M",0.4,0.6]
[null,"Low","L",0.2,0.4]
[null,"Very Low","VL",0,0.2]
[null,"These values are subjective to actor"]

{"sheet":"Wintech  Matrix","index":31,"n_rows":11,"n_cols":13,"rows_kept":11,"cut":false,"hidden":true,"merged":[[1,2,1,5],[2,10,2,12],[3,2,7,2],[9,4,9,8]]}
[]
[null,"Actor  Name","Wintech "]
[null,null,null,null,null,null,null,null,null,null,"Prioritization"]
[null,null,"Impact","VH",null,null,null,null,null,null,"Impact Level","Grade","Color Code"]
[null,null,null,"H",null,null,null,null,null,null,"Unacceptable","UA"]
[null,null,null,"M",null,null,null,null,null,null,"Very High","VH"]
[null,null,null,"L",null,null,null,null,null,null,"High","H"]
[null,null,null,"VL","R11 R10 R9 R8 R6 R4 R2 R1 ","R7 R3 ","R12 R5 ",null,null,null,"Medium","M"]
[null,null,null,null,"VL","L","M","H","VH",null,"Low","L"]
[null,null,null,null,"Probability",null,null,null,null,null,"Very Low","VL"]
[null,null,null,null,null,null,null,null,null,null,"Acceptable","A"]

{"sheet":"Act2","index":32,"n_rows":42,"n_cols":15,"rows_kept":42,"cut":false,"hidden":true,"merged":[[3,13,3,14],[4,2,9,6],[25,1,26,1],[25,2,26,2],[25,3,25,4],[35,8,35,9],[35,10,36,10],[35,11,36,11],[32,1,32,4],[1,2,1,6]]}
[]
[null,"Actor Number","Act2"]
[null,"Actor Name","Wintech "]
[null,"Role","Seller",null,null,null,null,null,null,null,null,null,null,"Impact Range "]
[null,"Description",null,null,null,null,null,null,null,null,null,null,null,"Lower (>)","Upper (<=)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.8,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.6,0.8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.4,0.6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.2,0.4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0.2]
[]
[null,"Impact Evaluation",null,null,null,null,"Risk Evaluation"]
[null,null,"Max","Grade"]
[null,"Enter Maximum Acceptable Damage",50000,"VH",null,null,"Risks","Probability of Occurrence","Impact Value","Impact Grade"]
[null,null,null,null,null,null,{"$f":"'Risk Register'!C6","v":"R1"},{"$f":"Risklikelihood(G15)","v":"VL"},0,"VL"]
[null,"Categorization",null,null,null,null,{"$f":"'Risk Register'!C7","v":"R2"},"VL",0,"VL"]
[null,"Impact Level","Impact Amount","Grade",null,null,{"$f":"'Risk Register'!C8","v":"R3"},"L",1000,"VL"]
[null,"Very High",50000,"VH",null,null,{"$f":"'Risk Register'!C9","v":"R4"},"VL",0,"VL"]
[null,"High",{"$f":"0.8*C18","v":40000},"H",null,null,{"$f":"'Risk Register'!C10","v":"R5"},"M",0,"VL"]
[null,"Medium",{"$f":"0.6*C18","v":30000},"M",null,null,{"$f":"'Risk Register'!C11","v":"R6"},"VL",0,"VL"]
[null,"Low",{"$f":"0.4*C18","v":20000},"L",null,null,{"$f":"'Risk Register'!C12","v":"R7"},"L",0,"VL"]
[null,"Very Low",{"$f":"0.2*C18","v":10000},"VL",null,null,{"$f":"'Risk Register'!C13","v":"R8"},{"$f":"Risklikelihood(G22)","v":"VL"},0,"VL"]
[null,null,null,null,null,null,{"$f":"'Risk Register'!C14","v":"R9"},"VL",0,"VL"]
[null,null,null,null,null,null,{"$f":"'Risk Register'!C15","v":"R10"},"VL",0,"VL"]
[null,"Scaling used for analysis",null,null,null,null,{"$f":"'Risk Register'!C16","v":"R11"},"VL",0,"VL"]
[null,"Impact Level","Grade","Impact Range ",null,null,{"$f":"'Risk Register'!C17","v":"R12"},"M",0,"VL"]
[null,null,null,"Lower (>)","Upper (<=)",null,null," "]
[null,"Very High","VH",0.8,"-",null,null," "]
[null,"High","H",0.6,0.8,null,null," "]
[null,"Medium","M",0.4,0.6]
[null,"Low","L",0.2,0.4]
[null,"Very Low","VL",0,0.2]
[null,"These values are subjective to actor"]
[]
[]
[null,null,null,null,null,null,null,null,"Impact Range ",null,"Grade","Scale"]
[null,null,null,null,null,null,null,null,"Lower (>)","Upper (<=)"]
[null,null,null,null,null,null,null,null,{"$f":"$C$14*D28","v":40000}," - ","VH","Very High"]
[null,null,null,null,null,null,null,null,{"$f":"$C$14*D29","v":30000},40000,"H","High"]
[null,null,null,null,null,null,null,null,{"$f":"$C$14*D30","v":20000},{"$f":"$C$14*E30","v":30000},"M","Medium"]
[null,null,null,null,null,null,null,null,10000,20000,"L","Low"]
[null,null,null,null,null,null,null,null,0,10000,"VL","Very Low"]

{"sheet":"Safmarine Matrix","index":33,"n_rows":11,"n_cols":13,"rows_kept":11,"cut":false,"hidden":true,"merged":[[1,2,1,5],[2,10,2,12],[3,2,7,2],[9,4,9,8]]}
[]
[null,"Actor  Name","Safmarine"]
[null,null,null,null,null,null,null,null,null,null,"Prioritization"]
[null,null,"Impact","VH",null,null,null,null,null,null,"Impact Level","Grade","Color Code"]
[null,null,null,"H",null,null,null,null,null,null,"Unacceptable","UA"]
[null,null,null,"M","R6 R5 ",null,null,null,null,null,"Very High","VH"]
[null,null,null,"L","R7 R3 ",null,null,null,null,null,"High","H"]
[null,null,null,"VL","R4 R1 ",null,null,null,"R2 ",null,"Medium","M"]
[null,null,null,null,"VL","L","M","H","VH",null,"Low","L"]
[null,null,null,null,"Probability",null,null,null,null,null,"Very Low","VL"]
[null,null,null,null,null,null,null,null,null,null,"Acceptable","A"]

{"sheet":"Act3","index":34,"n_rows":33,"n_cols":15,"rows_kept":33,"cut":false,"hidden":true,"merged":[[32,1,32,4],[1,2,1,6],[3,13,3,14],[4,2,9,6],[1,8,10,11],[25,1,26,1],[25,2,26,2],[25,3,25,4]]}
[]
[null,"Actor Number","Act3"]
[null,"Actor Name","Safmarine"]
[null,"Role","Sea Carrier",null,null,null,null,null,null,null,null,null,null,"Impact Range "]
[null,"Description",null,null,null,null,null,null,null,null,null,null,null,"Lower (>)","Upper (<=)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.8,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.6,0.8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.4,0.6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.2,0.4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0.2]
[]
[null,"Impact Evaluation",null,null,null,null,"Risk Evaluation"]
[null,null,"Max","Grade"]
[null,"Enter Maximum Acceptable Damage",500,"VH",null,null,"Risks","Probability of Occurrence","Impact Value","Impact Grade"]
[null,null,null,null,null,null,{"$f":"'Risk Register'!C6","v":"R1"},{"$f":"Risklikelihood(G15)","v":"VL"},0,"VL"]
[null,"Categorization",null,null,null,null,{"$f":"'Risk Register'!C7","v":"R2"},"VL",30000,"VH"]
[null,"Impact Level","Impact Amount","Grade",null,null,{"$f":"'Risk Register'!C8","v":"R3"},"L",0,"VL"]
[null,"Very High",{"$f":"C14","v":500},"VH",null,null,{"$f":"'Risk Register'!C9","v":"R4"},"VL",0,"VL"]
[null,"High",{"$f":"0.8*C18","v":400},"H",null,null,{"$f":"'Risk Register'!C10","v":"R5"},"M",0,"VL"]
[null,"Medium",{"$f":"0.6*C18","v":300},"M",null,null,{"$f":"'Risk Register'!C11","v":"R6"},"VL",0,"VL"]
[null,"Low",{"$f":"0.4*C18","v":200},"L",null,null,{"$f":"'Risk Register'!C12","v":"R7"},"L",0,"VL"]
[null,"Very Low",{"$f":"0.2*C18","v":100},"VL",null,null,{"$f":"'Risk Register'!C13","v":"R8"},{"$f":"Risklikelihood(G22)","v":"VL"},0,"VL"]
[null,null,null,null,null,null,{"$f":"'Risk Register'!C14","v":"R9"},"VL",0,"VL"]
[null,null,null,null,null,null,{"$f":"'Risk Register'!C15","v":"R10"},"VL",0,"VL"]
[null,"Scaling used for analysis",null,null,null,null,{"$f":"'Risk Register'!C16","v":"R11"},"VL",0,"VL"]
[null,"Impact Level","Grade","Impact Range ",null,null,{"$f":"'Risk Register'!C17","v":"R12"},"M",0,"VL"]
[null,null,null,"Lower (>)","Upper (<=)",null,null," "]
[null,"Very High","VH",0.8,"-"]
[null,"High","H",0.6,0.8]
[null,"Medium","M",0.4,0.6]
[null,"Low","L",0.2,0.4]
[null,"Very Low","VL",0,0.2]
[null,"These values are subjective to actor"]

{"sheet":"Act4","index":35,"n_rows":33,"n_cols":15,"rows_kept":33,"cut":false,"hidden":true,"merged":[[32,1,32,4],[4,2,9,6],[3,2,3,3],[1,2,1,6],[2,2,2,6],[25,1,26,1],[25,2,26,2],[25,3,25,4]]}
[]
[null,"Actor Number","Act4"]
[null,"Actor Name","KRA"]
[null,"Role","Government Agency"]
[null,"Description",null,null,null,null,null,null,null,null,null,null,null,"Lower (>)","Upper (<=)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.8,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.6,0.8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.4,0.6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.2,0.4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0.2]
[]
[null,"Impact Evaluation",null,null,null,null,"Risk Evaluation"]
[null,null,"Max","Grade"]
[null,"Enter Maximum Acceptable Damage",500,"VH",null,null,"Risks","Probability of Occurrence","Impact Value","Impact Grade"]
[null,null,null,null,null,null,{"$f":"'Risk Register'!C6","v":"R1"},{"$f":"Risklikelihood(G15)","v":"VL"},0,"VL"]
[null,"Categorization",null,null,null,null,{"$f":"'Risk Register'!C7","v":"R2"},"VL",0,"VL"]
[null,"Impact Level","Impact Amount","Grade",null,null,{"$f":"'Risk Register'!C8","v":"R3"},"L",0,"VL"]
[null,"Very High",{"$f":"C14","v":500},"VH",null,null,{"$f":"'Risk Register'!C9","v":"R4"},"VL",0,"VL"]
[null,"High",{"$f":"0.8*C18","v":400},"H",null,null,{"$f":"'Risk Register'!C10","v":"R5"},"M",0,"VL"]
[null,"Medium",{"$f":"0.6*C18","v":300},"M",null,null,{"$f":"'Risk Register'!C11","v":"R6"},"VL",0,"VL"]
[null,"Low",{"$f":"0.4*C18","v":200},"L",null,null,{"$f":"'Risk Register'!C12","v":"R7"},"L",0,"VL"]
[null,"Very Low",{"$f":"0.2*C18","v":100},"VL",null,null,{"$f":"'Risk Register'!C13","v":"R8"},{"$f":"Risklikelihood(G22)","v":"VL"},0,"VL"]
[null,null,null,null,null,null,{"$f":"'Risk Register'!C14","v":"R9"},"VL",0,"VL"]
[null,null,null,null,null,null,{"$f":"'Risk Register'!C15","v":"R10"},"VL",0,"VL"]
[null,"Scaling used for analysis",null,null,null,null,{"$f":"'Risk Register'!C16","v":"R11"},"VL",0,"VL"]
[null,"Impact Level","Grade","Impact Range ",null,null,{"$f":"'Risk Register'!C17","v":"R12"},"M",0,"VL"]
[null,null,null,"Lower (>)","Upper (<=)",null,null," "]
[null,"Very High","VH",0.8,"-"]
[null,"High","H",0.6,0.8]
[null,"Medium","M",0.4,0.6]
[null,"Low","L",0.2,0.4]
[null,"Very Low","VL",0,0.2]
[null,"These values are subjective to actor"]

{"sheet":"Act5","index":36,"n_rows":33,"n_cols":15,"rows_kept":33,"cut":false,"hidden":true,"merged":[[32,1,32,4],[1,2,1,6],[1,8,10,11],[3,13,3,14],[4,2,9,6],[25,1,26,1],[25,2,26,2],[25,3,25,4]]}
[]
[null,"Actor Number","Act5"]
[null,"Actor Name","GMS"]
[null,"Role","Freight forwarder",null,null,null,null,null,null,null,null,null,null,"Impact Range "]
[null,"Description",null,null,null,null,null,null,null,null,null,null,null,"Lower (>)","Upper (<=)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.8,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.6,0.8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.4,0.6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.2,0.4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0.2]
[]
[null,"Impact Evaluation",null,null,null,null,"Risk Evaluation"]
[null,null,"Max","Grade"]
[null,"Enter Maximum Acceptable Damage",500,"VH",null,null,"Risks","Probability of Occurrence","Impact Value","Impact Grade"]
[null,null,null,null,null,null,{"$f":"'Risk Register'!C6","v":"R1"},{"$f":"Risklikelihood(G15)","v":"VL"},0,"VL"]
[null,"Categorization",null,null,null,null,{"$f":"'Risk Register'!C7","v":"R2"},"VL",0,"VL"]
[null,"Impact Level","Impact Amount","Grade",null,null,{"$f":"'Risk Register'!C8","v":"R3"},"L",0,"VL"]
[null,"Very High",{"$f":"C14","v":500},"VH",null,null,{"$f":"'Risk Register'!C9","v":"R4"},"VL",0,"VL"]
[null,"High",{"$f":"0.8*C18","v":400},"H",null,null,{"$f":"'Risk Register'!C10","v":"R5"},"M",0,"VL"]
[null,"Medium",{"$f":"0.6*C18","v":300},"M",null,null,{"$f":"'Risk Register'!C11","v":"R6"},"VL",0,"VL"]
[null,"Low",{"$f":"0.4*C18","v":200},"L",null,null,{"$f":"'Risk Register'!C12","v":"R7"},"L",0,"VL"]
[null,"Very Low",{"$f":"0.2*C18","v":100},"VL",null,null,{"$f":"'Risk Register'!C13","v":"R8"},{"$f":"Risklikelihood(G22)","v":"VL"},0,"VL"]
[null,null,null,null,null,null,{"$f":"'Risk Register'!C14","v":"R9"},"VL",0,"VL"]
[null,null,null,null,null,null,{"$f":"'Risk Register'!C15","v":"R10"},"VL",0,"VL"]
[null,"Scaling used for analysis",null,null,null,null,{"$f":"'Risk Register'!C16","v":"R11"},"VL",0,"VL"]
[null,"Impact Level","Grade","Impact Range ",null,null,{"$f":"'Risk Register'!C17","v":"R12"},"M",0,"VL"]
[null,null,null,"Lower (>)","Upper (<=)",null,null," "]
[null,"Very High","VH",0.8,"-"]
[null,"High","H",0.6,0.8]
[null,"Medium","M",0.4,0.6]
[null,"Low","L",0.2,0.4]
[null,"Very Low","VL",0,0.2]
[null,"These values are subjective to actor"]

{"sheet":"Act6","index":37,"n_rows":33,"n_cols":15,"rows_kept":33,"cut":false,"hidden":true,"merged":[[32,1,32,4],[1,2,1,6],[1,8,10,11],[3,13,3,14],[4,2,9,6],[25,1,26,1],[25,2,26,2],[25,3,25,4]]}
[]
[null,"Actor Number","Act6"]
[null,"Actor Name","KEPHIS"]
[null,"Role","Inspection Agency",null,null,null,null,null,null,null,null,null,null,"Impact Range "]
[null,"Description",null,null,null,null,null,null,null,null,null,null,null,"Lower (>)","Upper (<=)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.8,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.6,0.8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.4,0.6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.2,0.4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0.2]
[]
[null,"Impact Evaluation",null,null,null,null,"Risk Evaluation"]
[null,null,"Max","Grade"]
[null,"Enter Maximum Acceptable Damage",500,"VH",null,null,"Risks","Probability of Occurrence","Impact Value","Impact Grade"]
[null,null,null,null,null,null,{"$f":"'Risk Register'!C6","v":"R1"},{"$f":"Risklikelihood(G15)","v":"VL"},0,"VL"]
[null,"Categorization",null,null,null,null,{"$f":"'Risk Register'!C7","v":"R2"},"VL",0,"VL"]
[null,"Impact Level","Impact Amount","Grade",null,null,{"$f":"'Risk Register'!C8","v":"R3"},"L",0,"VL"]
[null,"Very High",{"$f":"C14","v":500},"VH",null,null,{"$f":"'Risk Register'!C9","v":"R4"},"VL",0,"VL"]
[null,"High",{"$f":"0.8*C18","v":400},"H",null,null,{"$f":"'Risk Register'!C10","v":"R5"},"M",0,"VL"]
[null,"Medium",{"$f":"0.6*C18","v":300},"M",null,null,{"$f":"'Risk Register'!C11","v":"R6"},"VL",0,"VL"]
[null,"Low",{"$f":"0.4*C18","v":200},"L",null,null,{"$f":"'Risk Register'!C12","v":"R7"},"L",0,"VL"]
[null,"Very Low",{"$f":"0.2*C18","v":100},"VL",null,null,{"$f":"'Risk Register'!C13","v":"R8"},{"$f":"Risklikelihood(G22)","v":"VL"},0,"VL"]
[null,null,null,null,null,null,{"$f":"'Risk Register'!C14","v":"R9"},"VL",0,"VL"]
[null,null,null,null,null,null,{"$f":"'Risk Register'!C15","v":"R10"},"VL",0,"VL"]
[null,"Scaling used for analysis",null,null,null,null,{"$f":"'Risk Register'!C16","v":"R11"},"VL",0,"VL"]
[null,"Impact Level","Grade","Impact Range ",null,null,{"$f":"'Risk Register'!C17","v":"R12"},"M",0,"VL"]
[null,null,null,"Lower (>)","Upper (<=)"]
[null,"Very High","VH",0.8,"-"]
[null,"High","H",0.6,0.8]
[null,"Medium","M",0.4,0.6]
[null,"Low","L",0.2,0.4]
[null,"Very Low","VL",0,0.2]
[null,"These values are subjective to actor"]

{"sheet":"Act7","index":38,"n_rows":33,"n_cols":15,"rows_kept":33,"cut":false,"hidden":true,"merged":[[32,1,32,4],[1,2,1,6],[1,8,10,11],[3,13,3,14],[4,2,9,6],[25,1,26,1],[25,2,26,2],[25,3,25,4]]}
[]
[null,"Actor Number","Act7"]
[null,"Actor Name","Grower"]
[null,"Role","Producer",null,null,null,null,null,null,null,null,null,null,"Impact Range "]
[null,"Description",null,null,null,null,null,null,null,null,null,null,null,"Lower (>)","Upper (<=)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.8,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.6,0.8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.4,0.6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.2,0.4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0.2]
[]
[null,"Impact Evaluation",null,null,null,null,"Risk Evaluation"]
[null,null,"Max","Grade"]
[null,"Enter Maximum Acceptable Damage",500,"VH",null,null,"Risks","Probability of Occurrence","Impact Value","Impact Grade"]
[null,null,null,null,null,null,{"$f":"'Risk Register'!C6","v":"R1"},{"$f":"Risklikelihood(G15)","v":"VL"},0,"VL"]
[null,"Categorization",null,null,null,null,{"$f":"'Risk Register'!C7","v":"R2"},"VL",0,"VL"]
[null,"Impact Level","Impact Amount","Grade",null,null,{"$f":"'Risk Register'!C8","v":"R3"},"L",0,"VL"]
[null,"Very High",{"$f":"C14","v":500},"VH",null,null,{"$f":"'Risk Register'!C9","v":"R4"},"VL",0,"VL"]
[null,"High",{"$f":"0.8*C18","v":400},"H",null,null,{"$f":"'Risk Register'!C10","v":"R5"},"M",0,"VL"]
[null,"Medium",{"$f":"0.6*C18","v":300},"M",null,null,{"$f":"'Risk Register'!C11","v":"R6"},"VL",0,"VL"]
[null,"Low",{"$f":"0.4*C18","v":200},"L",null,null,{"$f":"'Risk Register'!C12","v":"R7"},"L",0,"VL"]
[null,"Very Low",{"$f":"0.2*C18","v":100},"VL",null,null,{"$f":"'Risk Register'!C13","v":"R8"},{"$f":"Risklikelihood(G22)","v":"VL"},0,"VL"]
[null,null,null,null,null,null,{"$f":"'Risk Register'!C14","v":"R9"},"VL",0,"VL"]
[null,null,null,null,null,null,{"$f":"'Risk Register'!C15","v":"R10"},"VL",0,"VL"]
[null,"Scaling used for analysis",null,null,null,null,{"$f":"'Risk Register'!C16","v":"R11"},"VL",0,"VL"]
[null,"Impact Level","Grade","Impact Range ",null,null,{"$f":"'Risk Register'!C17","v":"R12"},"M",0,"VL"]
[null,null,null,"Lower (>)","Upper (<=)"]
[null,"Very High","VH",0.8,"-"]
[null,"High","H",0.6,0.8]
[null,"Medium","M",0.4,0.6]
[null,"Low","L",0.2,0.4]
[null,"Very Low","VL",0,0.2]
[null,"These values are subjective to actor"]

{"sheet":"Act8","index":39,"n_rows":33,"n_cols":15,"rows_kept":33,"cut":false,"hidden":true,"merged":[[32,1,32,4],[1,2,1,6],[1,8,10,11],[3,13,3,14],[4,2,9,6],[25,1,26,1],[25,2,26,2],[25,3,25,4]]}
[]
[null,"Actor Number","Act8"]
[null,"Actor Name","KPA"]
[null,"Role","Port Authority",null,null,null,null,null,null,null,null,null,null,"Impact Range "]
[null,"Description",null,null,null,null,null,null,null,null,null,null,null,"Lower (>)","Upper (<=)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.8,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.6,0.8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.4,0.6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.2,0.4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0.2]
[]
[null,"Impact Evaluation",null,null,null,null,"Risk Evaluation"]
[null,null,"Max","Grade"]
[null,"Enter Maximum Acceptable Damage",500,"VH",null,null,"Risks","Probability of Occurrence","Impact Value","Impact Grade"]
[null,null,null,null,null,null,{"$f":"'Risk Register'!C6","v":"R1"},{"$f":"Risklikelihood(G15)","v":"VL"},0,"VL"]
[null,"Categorization",null,null,null,null,{"$f":"'Risk Register'!C7","v":"R2"},"VL",0,"VL"]
[null,"Impact Level","Impact Amount","Grade",null,null,{"$f":"'Risk Register'!C8","v":"R3"},"L",0,"VL"]
[null,"Very High",{"$f":"C14","v":500},"VH",null,null,{"$f":"'Risk Register'!C9","v":"R4"},"VL",0,"VL"]
[null,"High",{"$f":"0.8*C18","v":400},"H",null,null,{"$f":"'Risk Register'!C10","v":"R5"},"M",0,"VL"]
[null,"Medium",{"$f":"0.6*C18","v":300},"M",null,null,{"$f":"'Risk Register'!C11","v":"R6"},"VL",0,"VL"]
[null,"Low",{"$f":"0.4*C18","v":200},"L",null,null,{"$f":"'Risk Register'!C12","v":"R7"},"L",0,"VL"]
[null,"Very Low",{"$f":"0.2*C18","v":100},"VL",null,null,{"$f":"'Risk Register'!C13","v":"R8"},{"$f":"Risklikelihood(G22)","v":"VL"},0,"VL"]
[null,null,null,null,null,null,{"$f":"'Risk Register'!C14","v":"R9"},"VL",0,"VL"]
[null,null,null,null,null,null,{"$f":"'Risk Register'!C15","v":"R10"},"VL",0,"VL"]
[null,"Scaling used for analysis",null,null,null,null,{"$f":"'Risk Register'!C16","v":"R11"},"VL",0,"VL"]
[null,"Impact Level","Grade","Impact Range ",null,null,{"$f":"'Risk Register'!C17","v":"R12"},"M",0,"VL"]
[null,null,null,"Lower (>)","Upper (<=)"]
[null,"Very High","VH",0.8,"-"]
[null,"High","H",0.6,0.8]
[null,"Medium","M",0.4,0.6]
[null,"Low","L",0.2,0.4]
[null,"Very Low","VL",0,0.2]
[null,"These values are subjective to actor"]

{"sheet":"Act9","index":40,"n_rows":33,"n_cols":15,"rows_kept":33,"cut":false,"hidden":true,"merged":[[32,1,32,4],[1,2,1,6],[1,8,10,11],[3,13,3,14],[4,2,9,6],[25,1,26,1],[25,2,26,2],[25,3,25,4]]}
[]
[null,"Actor Number","Act10"]
[null,"Actor Name","van Duijn"]
[null,"Role","Freight forwarder",null,null,null,null,null,null,null,null,null,null,"Impact Range "]
[null,"Description",null,null,null,null,null,null,null,null,null,null,null,"Lower (>)","Upper (<=)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.8,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.6,0.8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.4,0.6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.2,0.4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0.2]
[]
[null,"Impact Evaluation",null,null,null,null,"Risk Evaluation"]
[null,null,"Max","Grade"]
[null,"Enter Maximum Acceptable Damage",500,"VH",null,null,"Risks","Probability of Occurrence","Impact Value","Impact Grade"]
[null,null,null,null,null,null,{"$f":"'Risk Register'!C6","v":"R1"},{"$f":"Risklikelihood(G15)","v":"VL"},0,"VL"]
[null,"Categorization",null,null,null,null,{"$f":"'Risk Register'!C7","v":"R2"},"VL",0,"VL"]
[null,"Impact Level","Impact Amount","Grade",null,null,{"$f":"'Risk Register'!C8","v":"R3"},"L",0,"VL"]
[null,"Very High",{"$f":"C14","v":500},"VH",null,null,{"$f":"'Risk Register'!C9","v":"R4"},"VL",0,"VL"]
[null,"High",{"$f":"0.8*C18","v":400},"H",null,null,{"$f":"'Risk Register'!C10","v":"R5"},"M",0,"VL"]
[null,"Medium",{"$f":"0.6*C18","v":300},"M",null,null,{"$f":"'Risk Register'!C11","v":"R6"},"VL",0,"VL"]
[null,"Low",{"$f":"0.4*C18","v":200},"L",null,null,{"$f":"'Risk Register'!C12","v":"R7"},"L",0,"VL"]
[null,"Very Low",{"$f":"0.2*C18","v":100},"VL",null,null,{"$f":"'Risk Register'!C13","v":"R8"},{"$f":"Risklikelihood(G22)","v":"VL"},0,"VL"]
[null,null,null,null,null,null,{"$f":"'Risk Register'!C14","v":"R9"},"VL",0,"VL"]
[null,null,null,null,null,null,{"$f":"'Risk Register'!C15","v":"R10"},"VL",0,"VL"]
[null,"Scaling used for analysis",null,null,null,null,{"$f":"'Risk Register'!C16","v":"R11"},"VL",0,"VL"]
[null,"Impact Level","Grade","Impact Range ",null,null,{"$f":"'Risk Register'!C17","v":"R12"},"M",0,"VL"]
[null,null,null,"Lower (>)","Upper (<=)"]
[null,"Very High","VH",0.8,"-"]
[null,"High","H",0.6,0.8]
[null,"Medium","M",0.4,0.6]
[null,"Low","L",0.2,0.4]
[null,"Very Low","VL",0,0.2]
[null,"These values are subjective to actor"]

{"sheet":"Act10","index":41,"n_rows":33,"n_cols":15,"rows_kept":33,"cut":false,"hidden":true,"merged":[[32,1,32,4],[1,2,1,6],[1,8,10,11],[3,13,3,14],[4,2,9,6],[25,1,26,1],[25,2,26,2],[25,3,25,4]]}
[]
[null,"Actor Number","Act9"]
[null,"Actor Name","APM"]
[null,"Role","Terminal Import",null,null,null,null,null,null,null,null,null,null,"Impact Range "]
[null,"Description",null,null,null,null,null,null,null,null,null,null,null,"Lower (>)","Upper (<=)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.8,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.6,0.8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.4,0.6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.2,0.4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0.2]
[]
[null,"Impact Evaluation",null,null,null,null,"Risk Evaluation"]
[null,null,"Max","Grade"]
[null,"Enter Maximum Acceptable Damage",500,"VH",null,null,"Risks","Probability of Occurrence","Impact Value","Impact Grade"]
[null,null,null,null,null,null,{"$f":"'Risk Register'!C6","v":"R1"},{"$f":"Risklikelihood(G15)","v":"VL"},0,"VL"]
[null,"Categorization",null,null,null,null,{"$f":"'Risk Register'!C7","v":"R2"},"VL",0,"VL"]
[null,"Impact Level","Impact Amount","Grade",null,null,{"$f":"'Risk Register'!C8","v":"R3"},"L",0,"VL"]
[null,"Very High",{"$f":"C14","v":500},"VH",null,null,{"$f":"'Risk Register'!C9","v":"R4"},"VL",0,"VL"]
[null,"High",{"$f":"0.8*C18","v":400},"H",null,null,{"$f":"'Risk Register'!C10","v":"R5"},"M",0,"VL"]
[null,"Medium",{"$f":"0.6*C18","v":300},"M",null,null,{"$f":"'Risk Register'!C11","v":"R6"},"VL",0,"VL"]
[null,"Low",{"$f":"0.4*C18","v":200},"L",null,null,{"$f":"'Risk Register'!C12","v":"R7"},"L",0,"VL"]
[null,"Very Low",{"$f":"0.2*C18","v":100},"VL",null,null,{"$f":"'Risk Register'!C13","v":"R8"},{"$f":"Risklikelihood(G22)","v":"VL"},0,"VL"]
[null,null,null,null,null,null,{"$f":"'Risk Register'!C14","v":"R9"},"VL",0,"VL"]
[null,null,null,null,null,null,{"$f":"'Risk Register'!C15","v":"R10"},"VL",0,"VL"]
[null,"Scaling used for analysis",null,null,null,null,{"$f":"'Risk Register'!C16","v":"R11"},"VL",0,"VL"]
[null,"Impact Level","Grade","Impact Range ",null,null,{"$f":"'Risk Register'!C17","v":"R12"},"M",0,"VL"]
[null,null,null,"Lower (>)","Upper (<=)",null,null," "]
[null,"Very High","VH",0.8,"-"]
[null,"High","H",0.6,0.8]
[null,"Medium","M",0.4,0.6]
[null,"Low","L",0.2,0.4]
[null,"Very Low","VL",0,0.2]
[null,"These values are subjective to actor"]

{"sheet":"Act11","index":42,"n_rows":33,"n_cols":15,"rows_kept":33,"cut":false,"hidden":true,"merged":[[32,1,32,4],[1,2,1,6],[1,8,10,11],[3,13,3,14],[4,2,9,6],[25,1,26,1],[25,2,26,2],[25,3,25,4]]}
[]
[null,"Actor Number","Act11"]
[null,"Actor Name","Truck Export Side"]
[null,"Role","Interland Carrier",null,null,null,null,null,null,null,null,null,null,"Impact Range "]
[null,"Description",null,null,null,null,null,null,null,null,null,null,null,"Lower (>)","Upper (<=)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.8,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.6,0.8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.4,0.6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.2,0.4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0.2]
[]
[null,"Impact Evaluation",null,null,null,null,"Risk Evaluation"]
[null,null,"Max","Grade"]
[null,"Enter Maximum Acceptable Damage",500,"VH",null,null,"Risks","Probability of Occurrence","Impact Value","Impact Grade"]
[null,null,null,null,null,null,{"$f":"'Risk Register'!C6","v":"R1"},{"$f":"Risklikelihood(G15)","v":"VL"},0,"VL"]
[null,"Categorization",null,null,null,null,{"$f":"'Risk Register'!C7","v":"R2"},"VL",0,"VL"]
[null,"Impact Level","Impact Amount","Grade",null,null,{"$f":"'Risk Register'!C8","v":"R3"},"L",0,"VL"]
[null,"Very High",{"$f":"C14","v":500},"VH",null,null,{"$f":"'Risk Register'!C9","v":"R4"},"VL",0,"VL"]
[null,"High",{"$f":"0.8*C18","v":400},"H",null,null,{"$f":"'Risk Register'!C10","v":"R5"},"M",0,"VL"]
[null,"Medium",{"$f":"0.6*C18","v":300},"M",null,null,{"$f":"'Risk Register'!C11","v":"R6"},"VL",0,"VL"]
[null,"Low",{"$f":"0.4*C18","v":200},"L",null,null,{"$f":"'Risk Register'!C12","v":"R7"},"L",0,"VL"]
[null,"Very Low",{"$f":"0.2*C18","v":100},"VL",null,null,{"$f":"'Risk Register'!C13","v":"R8"},{"$f":"Risklikelihood(G22)","v":"VL"},0,"VL"]
[null,null,null,null,null,null,{"$f":"'Risk Register'!C14","v":"R9"},"VL",0,"VL"]
[null,null,null,null,null,null,{"$f":"'Risk Register'!C15","v":"R10"},"VL",0,"VL"]
[null,"Scaling used for analysis",null,null,null,null,{"$f":"'Risk Register'!C16","v":"R11"},"VL",0,"VL"]
[null,"Impact Level","Grade","Impact Range ",null,null,{"$f":"'Risk Register'!C17","v":"R12"},"M",0,"VL"]
[null,null,null,"Lower (>)","Upper (<=)"]
[null,"Very High","VH",0.8,"-"]
[null,"High","H",0.6,0.8]
[null,"Medium","M",0.4,0.6]
[null,"Low","L",0.2,0.4]
[null,"Very Low","VL",0,0.2]
[null,"These values are subjective to actor"]

{"sheet":"Act12","index":43,"n_rows":33,"n_cols":15,"rows_kept":33,"cut":false,"hidden":true,"merged":[[32,1,32,4],[1,2,1,6],[1,8,10,11],[3,13,3,14],[4,2,9,6],[25,1,26,1],[25,2,26,2],[25,3,25,4]]}
[]
[null,"Actor Number","Act12"]
[null,"Actor Name","Truck Import Side"]
[null,"Role","Interland Carrier",null,null,null,null,null,null,null,null,null,null,"Impact Range "]
[null,"Description",null,null,null,null,null,null,null,null,null,null,null,"Lower (>)","Upper (<=)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.8,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.6,0.8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.4,0.6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.2,0.4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0.2]
[]
[null,"Impact Evaluation",null,null,null,null,"Risk Evaluation"]
[null,null,"Max","Grade"]
[null,"Enter Maximum Acceptable Damage",500,"VH",null,null,"Risks","Probability of Occurrence","Impact Value","Impact Grade"]
[null,null,null,null,null,null,{"$f":"'Risk Register'!C6","v":"R1"},{"$f":"Risklikelihood(G15)","v":"VL"},0,"VL"]
[null,"Categorization",null,null,null,null,{"$f":"'Risk Register'!C7","v":"R2"},"VL",0,"VL"]
[null,"Impact Level","Impact Amount","Grade",null,null,{"$f":"'Risk Register'!C8","v":"R3"},"L",0,"VL"]
[null,"Very High",{"$f":"C14","v":500},"VH",null,null,{"$f":"'Risk Register'!C9","v":"R4"},"VL",0,"VL"]
[null,"High",{"$f":"0.8*C18","v":400},"H",null,null,{"$f":"'Risk Register'!C10","v":"R5"},"M",0,"VL"]
[null,"Medium",{"$f":"0.6*C18","v":300},"M",null,null,{"$f":"'Risk Register'!C11","v":"R6"},"VL",0,"VL"]
[null,"Low",{"$f":"0.4*C18","v":200},"L",null,null,{"$f":"'Risk Register'!C12","v":"R7"},"L",0,"VL"]
[null,"Very Low",{"$f":"0.2*C18","v":100},"VL",null,null,{"$f":"'Risk Register'!C13","v":"R8"},{"$f":"Risklikelihood(G22)","v":"VL"},0,"VL"]
[null,null,null,null,null,null,{"$f":"'Risk Register'!C14","v":"R9"},"VL",0,"VL"]
[null,null,null,null,null,null,{"$f":"'Risk Register'!C15","v":"R10"},"VL",0,"VL"]
[null,"Scaling used for analysis",null,null,null,null,{"$f":"'Risk Register'!C16","v":"R11"},"VL",0,"VL"]
[null,"Impact Level","Grade","Impact Range ",null,null,{"$f":"'Risk Register'!C17","v":"R12"},"M",0,"VL"]
[null,null,null,"Lower (>)","Upper (<=)"]
[null,"Very High","VH",0.8,"-"]
[null,"High","H",0.6,0.8]
[null,"Medium","M",0.4,0.6]
[null,"Low","L",0.2,0.4]
[null,"Very Low","VL",0,0.2]
[null,"These values are subjective to actor"]

{"sheet":"Act13","index":44,"n_rows":33,"n_cols":15,"rows_kept":33,"cut":false,"hidden":true,"merged":[[32,1,32,4],[1,2,1,6],[1,8,10,11],[3,13,3,14],[4,2,9,6],[25,1,26,1],[25,2,26,2],[25,3,25,4]]}
[]
[null,"Actor Number","Act13"]
[null,"Actor Name","Terminal Export Side"]
[null,"Role","Terminal Export",null,null,null,null,null,null,null,null,null,null,"Impact Range "]
[null,"Description",null,null,null,null,null,null,null,null,null,null,null,"Lower (>)","Upper (<=)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.8,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.6,0.8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.4,0.6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.2,0.4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0.2]
[]
[null,"Impact Evaluation",null,null,null,null,"Risk Evaluation"]
[null,null,"Max","Grade"]
[null,"Enter Maximum Acceptable Damage",500,"VH",null,null,"Risks","Probability of Occurrence","Impact Value","Impact Grade"]
[null,null,null,null,null,null,{"$f":"'Risk Register'!C6","v":"R1"},{"$f":"Risklikelihood(G15)","v":"VL"},0,"VL"]
[null,"Categorization",null,null,null,null,{"$f":"'Risk Register'!C7","v":"R2"},"VL",0,"VL"]
[null,"Impact Level","Impact Amount","Grade",null,null,{"$f":"'Risk Register'!C8","v":"R3"},"L",0,"VL"]
[null,"Very High",{"$f":"C14","v":500},"VH",null,null,{"$f":"'Risk Register'!C9","v":"R4"},"VL",0,"VL"]
[null,"High",{"$f":"0.8*C18","v":400},"H",null,null,{"$f":"'Risk Register'!C10","v":"R5"},"M",0,"VL"]
[null,"Medium",{"$f":"0.6*C18","v":300},"M",null,null,{"$f":"'Risk Register'!C11","v":"R6"},"VL",0,"VL"]
[null,"Low",{"$f":"0.4*C18","v":200},"L",null,null,{"$f":"'Risk Register'!C12","v":"R7"},"L",0,"VL"]
[null,"Very Low",{"$f":"0.2*C18","v":100},"VL",null,null,{"$f":"'Risk Register'!C13","v":"R8"},{"$f":"Risklikelihood(G22)","v":"VL"},0,"VL"]
[null,null,null,null,null,null,{"$f":"'Risk Register'!C14","v":"R9"},"VL",0,"VL"]
[null,null,null,null,null,null,{"$f":"'Risk Register'!C15","v":"R10"},"VL",0,"VL"]
[null,"Scaling used for analysis",null,null,null,null,{"$f":"'Risk Register'!C16","v":"R11"},"VL",0,"VL"]
[null,"Impact Level","Grade","Impact Range ",null,null,{"$f":"'Risk Register'!C17","v":"R12"},"M",0,"VL"]
[null,null,null,"Lower (>)","Upper (<=)",null,null," "]
[null,"Very High","VH",0.8,"-"]
[null,"High","H",0.6,0.8]
[null,"Medium","M",0.4,0.6]
[null,"Low","L",0.2,0.4]
[null,"Very Low","VL",0,0.2]
[null,"These values are subjective to actor"]

{"sheet":"Act14","index":45,"n_rows":33,"n_cols":15,"rows_kept":33,"cut":false,"hidden":true,"merged":[[32,1,32,4],[1,2,1,6],[1,8,10,11],[3,13,3,14],[4,2,9,6],[25,1,26,1],[25,2,26,2],[25,3,25,4]]}
[]
[null,"Actor Number","Act14"]
[null,"Actor Name","HTS"]
[null,"Role","Freight forwarder",null,null,null,null,null,null,null,null,null,null,"Impact Range "]
[null,"Description",null,null,null,null,null,null,null,null,null,null,null,"Lower (>)","Upper (<=)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.8,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.6,0.8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.4,0.6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.2,0.4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0.2]
[]
[null,"Impact Evaluation",null,null,null,null,"Risk Evaluation"]
[null,null,"Max","Grade"]
[null,"Enter Maximum Acceptable Damage",500,"VH",null,null,"Risks","Probability of Occurrence","Impact Value","Impact Grade"]
[null,null,null,null,null,null,{"$f":"'Risk Register'!C6","v":"R1"},{"$f":"Risklikelihood(G15)","v":"VL"},0,"VL"]
[null,"Categorization",null,null,null,null,{"$f":"'Risk Register'!C7","v":"R2"},"VL",0,"VL"]
[null,"Impact Level","Impact Amount","Grade",null,null,{"$f":"'Risk Register'!C8","v":"R3"},"L",0,"VL"]
[null,"Very High",{"$f":"C14","v":500},"VH",null,null,{"$f":"'Risk Register'!C9","v":"R4"},"VL",0,"VL"]
[null,"High",{"$f":"0.8*C18","v":400},"H",null,null,{"$f":"'Risk Register'!C10","v":"R5"},"M",0,"VL"]
[null,"Medium",{"$f":"0.6*C18","v":300},"M",null,null,{"$f":"'Risk Register'!C11","v":"R6"},"VL",0,"VL"]
[null,"Low",{"$f":"0.4*C18","v":200},"L",null,null,{"$f":"'Risk Register'!C12","v":"R7"},"L",0,"VL"]
[null,"Very Low",{"$f":"0.2*C18","v":100},"VL",null,null,{"$f":"'Risk Register'!C13","v":"R8"},"VL",0,"VL"]
[null,null,null,null,null,null,{"$f":"'Risk Register'!C14","v":"R9"},"VL",0,"VL"]
[null,null,null,null,null,null,{"$f":"'Risk Register'!C15","v":"R10"},"VL",0,"VL"]
[null,"Scaling used for analysis",null,null,null,null,{"$f":"'Risk Register'!C16","v":"R11"},"VL",0,"VL"]
[null,"Impact Level","Grade","Impact Range ",null,null,{"$f":"'Risk Register'!C17","v":"R12"},"M",0,"VL"]
[null,null,null,"Lower (>)","Upper (<=)",null,null," "]
[null,"Very High","VH",0.8,"-"]
[null,"High","H",0.6,0.8]
[null,"Medium","M",0.4,0.6]
[null,"Low","L",0.2,0.4]
[null,"Very Low","VL",0,0.2]
[null,"These values are subjective to actor"]

{"sheet":"Act15","index":46,"n_rows":33,"n_cols":15,"rows_kept":33,"cut":false,"hidden":true,"merged":[[32,1,32,4],[1,2,1,6],[1,8,10,11],[3,13,3,14],[4,2,9,6],[25,1,26,1],[25,2,26,2],[25,3,25,4]]}
[]
[null,"Actor Number","Act15"]
[null,"Actor Name","Customs Kenya"]
[null,"Role","Customs Export",null,null,null,null,null,null,null,null,null,null,"Impact Range "]
[null,"Description",null,null,null,null,null,null,null,null,null,null,null,"Lower (>)","Upper (<=)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.8,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.6,0.8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.4,0.6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.2,0.4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0.2]
[]
[null,"Impact Evaluation",null,null,null,null,"Risk Evaluation"]
[null,null,"Max","Grade"]
[null,"Enter Maximum Acceptable Damage",500,"VH",null,null,"Risks","Probability of Occurrence","Impact Value","Impact Grade"]
[null,null,null,null,null,null,{"$f":"'Risk Register'!C6","v":"R1"},{"$f":"Risklikelihood(G15)","v":"VL"},0,"VL"]
[null,"Categorization",null,null,null,null,{"$f":"'Risk Register'!C7","v":"R2"},"VL",0,"VL"]
[null,"Impact Level","Impact Amount","Grade",null,null,{"$f":"'Risk Register'!C8","v":"R3"},"L",350,"M"]
[null,"Very High",{"$f":"C14","v":500},"VH",null,null,{"$f":"'Risk Register'!C9","v":"R4"},"VL",0,"VL"]
[null,"High",{"$f":"0.8*C18","v":400},"H",null,null,{"$f":"'Risk Register'!C10","v":"R5"},"M",0,"VL"]
[null,"Medium",{"$f":"0.6*C18","v":300},"M",null,null,{"$f":"'Risk Register'!C11","v":"R6"},"VL",0,"VL"]
[null,"Low",{"$f":"0.4*C18","v":200},"L",null,null,{"$f":"'Risk Register'!C12","v":"R7"},"L",0,"VL"]
[null,"Very Low",{"$f":"0.2*C18","v":100},"VL"]
[]
[]
[null,"Scaling used for analysis"]
[null,"Impact Level","Grade","Impact Range "]
[null,null,null,"Lower (>)","Upper (<=)"]
[null,"Very High","VH",0.8,"-"]
[null,"High","H",0.6,0.8]
[null,"Medium","M",0.4,0.6]
[null,"Low","L",0.2,0.4]
[null,"Very Low","VL",0,0.2]
[null,"These values are subjective to actor"]

{"sheet":"Act16","index":47,"n_rows":33,"n_cols":15,"rows_kept":33,"cut":false,"hidden":true,"merged":[[32,1,32,4],[1,2,1,6],[1,8,10,11],[3,13,3,14],[4,2,9,6],[25,1,26,1],[25,2,26,2],[25,3,25,4]]}
[]
[null,"Actor Number","Act16"]
[null,"Actor Name","Customs Import"]
[null,"Role","Customs Import",null,null,null,null,null,null,null,null,null,null,"Impact Range "]
[null,"Description",null,null,null,null,null,null,null,null,null,null,null,"Lower (>)","Upper (<=)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.8,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.6,0.8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.4,0.6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.2,0.4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0.2]
[]
[null,"Impact Evaluation",null,null,null,null,"Risk Evaluation"]
[null,null,"Max","Grade"]
[null,"Enter Maximum Acceptable Damage",500,"VH",null,null,"Risks","Probability of Occurrence","Impact Value","Impact Grade"]
[null,null,null,null,null,null,{"$f":"'Risk Register'!C6","v":"R1"},{"$f":"Risklikelihood(G15)","v":"VL"},0,"VL"]
[null,"Categorization",null,null,null,null,{"$f":"'Risk Register'!C7","v":"R2"},"VL",0,"VL"]
[null,"Impact Level","Impact Amount","Grade",null,null,{"$f":"'Risk Register'!C8","v":"R3"},"L",350,"M"]
[null,"Very High",{"$f":"C14","v":500},"VH",null,null,{"$f":"'Risk Register'!C9","v":"R4"},"VL",0,"VL"]
[null,"High",{"$f":"0.8*C18","v":400},"H",null,null,{"$f":"'Risk Register'!C10","v":"R5"},"M",0,"VL"]
[null,"Medium",{"$f":"0.6*C18","v":300},"M",null,null,{"$f":"'Risk Register'!C11","v":"R6"},"VL",0,"VL"]
[null,"Low",{"$f":"0.4*C18","v":200},"L",null,null,{"$f":"'Risk Register'!C12","v":"R7"},"L",0,"VL"]
[null,"Very Low",{"$f":"0.2*C18","v":100},"VL"]
[]
[]
[null,"Scaling used for analysis"]
[null,"Impact Level","Grade","Impact Range "]
[null,null,null,"Lower (>)","Upper (<=)"]
[null,"Very High","VH",0.8,"-"]
[null,"High","H",0.6,0.8]
[null,"Medium","M",0.4,0.6]
[null,"Low","L",0.2,0.4]
[null,"Very Low","VL",0,0.2]
[null,"These values are subjective to actor"]

{"sheet":"Overall View","index":48,"n_rows":16,"n_cols":4,"rows_kept":16,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,null,null,"Jumbo Fresh"]
[null,null,null,"Wintech "]
[null,null,null,"MAERSK"]
[null,null,null,"KRA"]
[null,null,null,"GMS"]
[null,null,null,"KEPHIS"]
[null,null,null,"Grower"]
[null,null,null,"KPA"]
[null,null,null,"Opticool"]
[null,null,null,"APM"]
[null,null,null,"Truck Export Side"]
[null,null,null,"Truck Import Side"]
[null,null,null,"Terminal Export Side"]
[null,null,null,"HTS"]