{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Overview","Background","High Level Model","Detail Instructions","Detailed Model","Calculations","Threat Libraries","PMTable"],"not_rendered":{"charts":4,"images":12,"macros":1,"external_links":1,"defined_names":142,"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":"Overview","index":0,"n_rows":39,"n_cols":12,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"© Copyright 2013, ProbabilityManagement.org"]

{"sheet":"Background","index":1,"n_rows":31,"n_cols":22,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Potential Aircraft in Portfolio",null,null,null,null,null,null,"Five Global Threat Scenarios"]
[null,null,null,null,null,null,null,null,"Small Aircraft",null,null,null,null,null,null,"Required Tons/Day by Region &  Scenario"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Region","A","B","C","D","E","F"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Scenario 1",20,0,4,3,14,20]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Scenario 2",20,0,5,2,14,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Scenario 3",10,10,3,4,16,11]
[null,null,null,null,null,null,null,null,null,20,"Maximum",null,null,null,null,"Scenario 4",0,20,4,2,14,13]
[null,null,null,null,null,null,null,null,"Medium Aircraft",null,null,null,null,null,null,"Scenario 5",0,20,4,4,17,18]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,15,"Maximum"]
[]
[null,null,null,null,null,null,null,null,"Large Aircraft"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,4,"Maximum"]

{"sheet":"High Level Model","index":2,"n_rows":54,"n_cols":35,"rows_kept":54,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Red"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Orange"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Cost in $MM",null,"Avg. Shortfall Tons/Day"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"'Detailed Model'!T7","v":1300},null,{"$f":"'Detailed Model'!V7","v":13.6}]
[]
[null,"Small Aircraft"]
[]
[]
[]
[]
[null,null,"Planes Used",null,{"$f":"'Detailed Model'!E13","v":6}]
[]
[null,"Medium Aircraft",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Global Threat Library:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Potential Tons/Day Required by Region"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Region","A","B","C","D","E","F"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Scenario 1",{"$f":"INDEX('Threat Libraries'!C6:I6,,(6*Threat-5))","v":20},{"$f":"INDEX('Threat Libraries'!D6:J6,,(6*Threat-5))","v":0},{"$f":"INDEX('Threat Libraries'!E6:K6,,(6*Threat-5))","v":4},{"$f":"INDEX('Threat Libraries'!F6:L6,,(6*Threat-5))","v":3},{"$f":"INDEX('Threat Libraries'!G6:M6,,(6*Threat-5))","v":14},{"$f":"INDEX('Threat Libraries'!H6:N6,,(6*Threat-5))","v":20}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Scenario 2",{"$f":"INDEX('Threat Libraries'!C7:I7,,(6*Threat-5))","v":20},{"$f":"INDEX('Threat Libraries'!D7:J7,,(6*Threat-5))","v":0},{"$f":"INDEX('Threat Libraries'!E7:K7,,(6*Threat-5))","v":5},{"$f":"INDEX('Threat Libraries'!F7:L7,,(6*Threat-5))","v":2},{"$f":"INDEX('Threat Libraries'!G7:M7,,(6*Threat-5))","v":14},{"$f":"INDEX('Threat Libraries'!H7:N7,,(6*Threat-5))","v":8}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Scenario 3",{"$f":"INDEX('Threat Libraries'!C8:I8,,(6*Threat-5))","v":10},{"$f":"INDEX('Threat Libraries'!D8:J8,,(6*Threat-5))","v":10},{"$f":"INDEX('Threat Libraries'!E8:K8,,(6*Threat-5))","v":3},{"$f":"INDEX('Threat Libraries'!F8:L8,,(6*Threat-5))","v":4},{"$f":"INDEX('Threat Libraries'!G8:M8,,(6*Threat-5))","v":16},{"$f":"INDEX('Threat Libraries'!H8:N8,,(6*Threat-5))","v":11}]
[null,null,"Planes Used",null,{"$f":"'Detailed Model'!E19","v":15},null,null,null,null,null,null,null,null,null,null,null,null,"Scenario 4",{"$f":"INDEX('Threat Libraries'!C9:I9,,(6*Threat-5))","v":0},{"$f":"INDEX('Threat Libraries'!D9:J9,,(6*Threat-5))","v":20},{"$f":"INDEX('Threat Libraries'!E9:K9,,(6*Threat-5))","v":4},{"$f":"INDEX('Threat Libraries'!F9:L9,,(6*Threat-5))","v":2},{"$f":"INDEX('Threat Libraries'!G9:M9,,(6*Threat-5))","v":14},{"$f":"INDEX('Threat Libraries'!H9:N9,,(6*Threat-5))","v":13}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Scenario 5",{"$f":"INDEX('Threat Libraries'!C10:I10,,(6*Threat-5))","v":0},{"$f":"INDEX('Threat Libraries'!D10:J10,,(6*Threat-5))","v":20},{"$f":"INDEX('Threat Libraries'!E10:K10,,(6*Threat-5))","v":4},{"$f":"INDEX('Threat Libraries'!F10:L10,,(6*Threat-5))","v":4},{"$f":"INDEX('Threat Libraries'!G10:M10,,(6*Threat-5))","v":17},{"$f":"INDEX('Threat Libraries'!H10:N10,,(6*Threat-5))","v":18}]
[null,"Large Aircraft"]
[]
[]
[]
[]
[]
[]
[null,null,"Planes Used",null,{"$f":"'Detailed Model'!E30","v":4}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]

{"sheet":"Detail Instructions","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Detailed Model","index":4,"n_rows":80,"n_cols":42,"rows_kept":80,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,null,null,null,null,"Requirements by Location",null,null,null,null,null,null,"Global Threat Library:"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Tons/Day"]
[null,null,null,null,null,null,null,0,null,null,"A","B","C","D","E","F"]
[null,null,null,null,null,null,null,{"$f":"IF(H4=0,\"Average\",\"Scenario \"&$H$4)","v":"Average"},"Required",null,{"$f":"INDEX('Threat Libraries'!C6:I11,PM_Index,(6*Threat-5))","v":10},{"$f":"INDEX('Threat Libraries'!D6:J11,PM_Index,(6*Threat-5))","v":10},{"$f":"INDEX('Threat Libraries'!E6:K11,PM_Index,(6*Threat-5))","v":4},{"$f":"INDEX('Threat Libraries'!F6:L11,PM_Index,(6*Threat-5))","v":3},{"$f":"INDEX('Threat Libraries'!G6:M11,PM_Index,(6*Threat-5))","v":15},{"$f":"INDEX('Threat Libraries'!H6:N11,PM_Index,(6*Threat-5))","v":14},null,null,null,null,null,null,null," "," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'High Level Model'!AA54","v":1}]
[null,null,null,null,null,null,null,null,"Delivered",null,{"$f":"SUMPRODUCT(Assignments,G10:G36)","v":10},6,4,4,14,14,null,null,null,"Cost",null,"Avg. Shortfall"]
[null,null,null,null,null,null,null,null,"Delta",null,{"$f":"K5-K6","v":0},4,0,-1,1,0,"Total_Shortfall",null,null,{"$f":"SUMPRODUCT(Assignments,Costs)","v":1300},null,{"$f":"AVERAGE(Total_Shortfall)","v":13.6}]
[null,null,null,null,null,null,null,null,"Shortfall",null,{"$f":"IF(K7>0,K7,0)","v":0},4,0,0,1,0,{"$f":"SUM(K8:P8)","v":5}]
[null,null,null,"Cost in $000s",null,"Number Assigned","A","B","C","D","E","F"]
[null,"Small Aircraft",1,40,"Available",0,1]
[null,null,2,60,20,0,null,1]
[null,null,3,40,"Used",0,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bins","Frequency"]
[null,null,4,50,{"$f":"SUM(F10:F15)","v":6},0,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Shortfal"]
[null,null,5,30,null,6,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"FREQUENCY(Total_Shortfall,$AO$15:$AO$23)/5","v":0}]
[null,null,6,40,null,0,null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AO14 + ( $AO$24 - $AO$14 ) / 10","v":5},0.2]
[null,"Medium Aircraft ",7,70,"Available",0,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,0.4]
[null,null,8,70,15,0,null,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,0.2]
[null,null,9,60,"Used",0,null,null,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,0.2]
[null,null,10,50,{"$f":"SUM(F16:F26)","v":15},0,null,null,null,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25,0]
[null,null,11,80,null,0,null,null,null,null,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,0]
[null,null,12,50,null,5,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,35,0]
[null,null,13,60,null,3,null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,40,0]
[null,null,14,50,null,0,null,null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,45,0]
[null,null,15,60,null,0,null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50]
[null,null,16,50,null,0,null,null,null,null,2]
[null,null,17,50,null,7,null,null,null,null,null,2]
[null,"Large Aircraft",18,120,"Available",0,null,null,null,null,null,2]
[null,null,19,100,4,0,0,null,2,null,2]
[null,null,20,90,"Used",0,null,null,2,2]
[null,null,21,110,{"$f":"SUM(F27:F36)","v":4},0,null,null,null,2,2]
[null,null,22,130,null,0,null,null,null,null,2,2]
[null,null,23,100,null,0,4]
[null,null,24,90,null,1,null,null,4]
[null,null,25,90,null,1,null,null,null,4]
[null,null,26,80,null,2,null,null,null,null,4]
[null,null,27,100,null,0,null,null,null,null,null,4]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"T7","v":1300},{"$f":"V7","v":13.6}]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'High Level Model'!S29","v":0},{"$f":"'High Level Model'!T29","v":0},{"$f":"'High Level Model'!U29","v":0},{"$f":"'High Level Model'!V29","v":0},{"$f":"'High Level Model'!W29","v":0},{"$f":"'High Level Model'!X29","v":0}," "]

{"sheet":"Calculations","index":5,"n_rows":78,"n_cols":22,"rows_kept":78,"cut":false,"hidden":true,"merged":[]}
[null,null,null,"Assignment","Assignment","Assignment","Assignment","Assignment","Assignment","Assignment","Assignment","Assignment","Assignment","Assignment","Assignment","Assignment","Assignment","Assignment","Assignment","Assignment","Assignment","Assignment"]
[null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,1,4]
[null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,0,0,1,0,2,2,0,2,0,1,2,0,2,6,6,11,14,16,16]
[null,null,null,0,0,0,0,0,0,0,0,0,1,0,0,1,0,1,0,0,0,0]
[null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,0,0,0,1,0,0,0,0,2,1,0,2,0,0,0,0,0,0,0]
[null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,0,0,0,0,0,0,0,0,1,3,5,5,5,5,4,5,5,5,5]
[null,null,null,0,0,0,0,0,0,0,0,0,0,0,2,2,3,5,5,5,5,5]
[null,null,null,0,0,0,0,0,0,0,1,0,1,1,0,2,0,0,0,0,0,0]
[null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,0,0,0,0,0,0,3,0,2,0,0,0,0,0,0,0,1,0,0]
[null,null,null,0,0,0,0,0,2,4,5,6,5,6,6,6,7,6,5,4,5,5]
[null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,0,0,0,0,1,1,1,1,0,1,1,0,0,0,0,0,0,0,0]
[null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"'Detailed Model'!H4","v":0},null,0,0,0,0,0,0,0,0,1,0,0,1,0,1,1,1,1,1,1]
[null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,1,1,1,1,1,1,1]
[null,null,null,0,1,2,3,3,3,2,3,2,3,3,3,3,2,2,1,0,0,0]
[null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,2,2,2]
[null,null,null,{"$f":"SUMPRODUCT(D2:D28,Costs)","v":0},80,190,290,390,490,600,690,800,900,990,1100,1200,1300,1400,1490,1600,1700,1820]
[null,null,null,{"$f":"AVERAGE(Shortfall01)","v":56},{"$f":"AVERAGE(Shortfall02)","v":52},{"$f":"AVERAGE(Shortfall03)","v":47},{"$f":"AVERAGE(Shortfall04)","v":42},{"$f":"AVERAGE(Shortfall05)","v":38},{"$f":"AVERAGE(Shortfall06)","v":34},{"$f":"AVERAGE(Shortfall07)","v":30},{"$f":"AVERAGE(Shortfall08)","v":26.6},{"$f":"AVERAGE(Shortfall09)","v":24},{"$f":"AVERAGE(Shortfall10)","v":21.6},{"$f":"AVERAGE(Shortfall11)","v":19.2},{"$f":"AVERAGE(Shortfall12)","v":16.8},{"$f":"AVERAGE(Shortfall13)","v":15.2},{"$f":"AVERAGE(Shortfall14)","v":13.6},{"$f":"AVERAGE(Shortfall15)","v":12.2},{"$f":"AVERAGE(Shortfall16)","v":10.8},{"$f":"AVERAGE(Shortfall17)","v":9.6},{"$f":"AVERAGE(Shortfall18)","v":8.4},{"$f":"AVERAGE(Shortfall19)","v":7.2}]
[{"$f":"'Detailed Model'!K$5","v":10},"A",{"$f":"A31","v":10},{"$f":"SUMPRODUCT(D$2:D$28,LocA)","v":0},0,0,0,0,0,0,0,2,6,10,10,10,10,9,10,10,11,14]
[{"$f":"'Detailed Model'!L$5","v":10},"B",{"$f":"A32","v":10},{"$f":"SUMPRODUCT(D$2:D$28,LocB)","v":0},0,0,0,0,0,0,0,0,0,0,4,4,6,10,10,10,10,10]
[{"$f":"'Detailed Model'!M$5","v":4},"C",4,{"$f":"SUMPRODUCT(D$2:D$28,LocC)","v":0},0,0,0,2,2,2,4,4,4,4,4,4,4,4,4,4,4,4]
[{"$f":"'Detailed Model'!N$5","v":3},"D",3,{"$f":"SUMPRODUCT(D$2:D$28,LocD)","v":0},0,0,1,2,2,2,2,2,3,2,2,4,4,4,4,4,4,4]
[{"$f":"'Detailed Model'!O$5","v":15},"E",15,{"$f":"SUMPRODUCT(D$2:D$28,LocE)","v":0},4,9,13,14,14,14,14,14,14,14,14,14,14,14,15,16,16,16]
[{"$f":"'Detailed Model'!P$5","v":14},"F",14,{"$f":"SUMPRODUCT(D$2:D$28,LocF)","v":0},0,0,0,0,4,8,10,12,11,12,12,13,14,13,14,16,18,18]
[null,null,"Delta",{"$f":"$C31-D31","v":10},{"$f":"$C31-E31","v":10},10,10,10,10,{"$f":"$C31-J31","v":10},10,8,{"$f":"$C31-M31","v":4},0,0,0,0,1,0,0,-1,-4]
[null,null,null,{"$f":"$C32-D32","v":10},10,10,10,10,10,{"$f":"$C32-J32","v":10},10,10,{"$f":"$C32-M32","v":10},10,6,6,4,0,0,0,0,0]
[null,null,null,4,4,4,4,2,2,{"$f":"$C33-J33","v":2},0,0,{"$f":"$C33-M33","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,3,3,3,2,1,1,{"$f":"$C34-J34","v":1},1,1,{"$f":"$C34-M34","v":0},1,1,-1,-1,-1,-1,-1,-1,-1]
[null,null,null,15,11,6,2,1,1,{"$f":"$C35-J35","v":1},1,1,{"$f":"$C35-M35","v":1},1,1,1,1,1,0,-1,-1,-1]
[null,null,null,14,14,14,14,14,10,{"$f":"$C36-J36","v":6},4,2,{"$f":"$C36-M36","v":3},2,2,1,0,1,0,-2,-4,-4]
[null,null,"Shortfall",{"$f":"IF(D37>0,D37,0)","v":10},10,10,10,10,{"$f":"IF(I37>0,I37,0)","v":10},10,{"$f":"IF(K37>0,K37,0)","v":10},8,{"$f":"IF(M37>0,M37,0)","v":4},0,0,0,0,1,0,0,0,0]
[null,null,null,{"$f":"IF(D38>0,D38,0)","v":10},10,10,10,10,{"$f":"IF(I38>0,I38,0)","v":10},10,{"$f":"IF(K38>0,K38,0)","v":10},10,{"$f":"IF(M38>0,M38,0)","v":10},10,6,6,4,0,0,0,0,0]
[null,null,null,{"$f":"IF(D39>0,D39,0)","v":4},4,4,4,2,{"$f":"IF(I39>0,I39,0)","v":2},2,0,0,{"$f":"IF(M39>0,M39,0)","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"IF(D40>0,D40,0)","v":3},3,3,2,1,{"$f":"IF(I40>0,I40,0)","v":1},1,1,1,{"$f":"IF(M40>0,M40,0)","v":0},1,1,0,0,0,0,0,0,0]
[null,null,null,{"$f":"IF(D41>0,D41,0)","v":15},11,6,2,1,{"$f":"IF(I41>0,I41,0)","v":1},1,1,1,{"$f":"IF(M41>0,M41,0)","v":1},1,1,1,1,1,0,0,0,0]
[null,null,null,{"$f":"IF(D42>0,D42,0)","v":14},14,14,14,14,{"$f":"IF(I42>0,I42,0)","v":10},6,4,2,{"$f":"IF(M42>0,M42,0)","v":3},2,2,1,0,1,0,0,0,0]
[null,null,null,{"$f":"SUM(D43:D48)","v":56},{"$f":"SUM(E43:E48)","v":52},{"$f":"SUM(F43:F48)","v":47},42,38,34,30,26,22,18,14,10,8,5,3,0,0,0,0]
[null,null,null,"Shortfall01","Shortfall02","Shortfall03","Shortfall04","Shortfall05","Shortfall06","Shortfall07","Shortfall08","Shortfall09","Shortfall10","Shortfall11","Shortfall12","Shortfall13","Shortfall14","Shortfall15","Shortfall16","Shortfall17","Shortfall18","Shortfall19"]
[{"$f":"'Detailed Model'!G9","v":"A"},{"$f":"'Detailed Model'!H9","v":"B"},{"$f":"'Detailed Model'!I9","v":"C"},{"$f":"'Detailed Model'!J9","v":"D"},{"$f":"'Detailed Model'!K9","v":"E"},{"$f":"'Detailed Model'!L9","v":"F"}]
[{"$f":"'Detailed Model'!G10","v":1},{"$f":"'Detailed Model'!H10","v":0},{"$f":"'Detailed Model'!I10","v":0},{"$f":"'Detailed Model'!J10","v":0},{"$f":"'Detailed Model'!K10","v":0},{"$f":"'Detailed Model'!L10","v":0}]
[{"$f":"'Detailed Model'!G11","v":0},{"$f":"'Detailed Model'!H11","v":1},{"$f":"'Detailed Model'!I11","v":0},{"$f":"'Detailed Model'!J11","v":0},{"$f":"'Detailed Model'!K11","v":0},{"$f":"'Detailed Model'!L11","v":0}]
[{"$f":"'Detailed Model'!G12","v":0},{"$f":"'Detailed Model'!H12","v":0},{"$f":"'Detailed Model'!I12","v":1},{"$f":"'Detailed Model'!J12","v":0},{"$f":"'Detailed Model'!K12","v":0},{"$f":"'Detailed Model'!L12","v":0}]
[{"$f":"'Detailed Model'!G13","v":0},{"$f":"'Detailed Model'!H13","v":0},{"$f":"'Detailed Model'!I13","v":0},{"$f":"'Detailed Model'!J13","v":1},{"$f":"'Detailed Model'!K13","v":0},{"$f":"'Detailed Model'!L13","v":0}]
[{"$f":"'Detailed Model'!G14","v":0},{"$f":"'Detailed Model'!H14","v":0},{"$f":"'Detailed Model'!I14","v":0},{"$f":"'Detailed Model'!J14","v":0},{"$f":"'Detailed Model'!K14","v":1},{"$f":"'Detailed Model'!L14","v":0}]
[{"$f":"'Detailed Model'!G15","v":0},{"$f":"'Detailed Model'!H15","v":0},{"$f":"'Detailed Model'!I15","v":0},{"$f":"'Detailed Model'!J15","v":0},{"$f":"'Detailed Model'!K15","v":0},{"$f":"'Detailed Model'!L15","v":1}]
[{"$f":"'Detailed Model'!G16","v":1},{"$f":"'Detailed Model'!H16","v":1},{"$f":"'Detailed Model'!I16","v":0},{"$f":"'Detailed Model'!J16","v":0},{"$f":"'Detailed Model'!K16","v":0},{"$f":"'Detailed Model'!L16","v":0}]
[{"$f":"'Detailed Model'!G17","v":0},{"$f":"'Detailed Model'!H17","v":1},{"$f":"'Detailed Model'!I17","v":1},{"$f":"'Detailed Model'!J17","v":0},{"$f":"'Detailed Model'!K17","v":0},{"$f":"'Detailed Model'!L17","v":0}]
[{"$f":"'Detailed Model'!G18","v":0},{"$f":"'Detailed Model'!H18","v":0},{"$f":"'Detailed Model'!I18","v":1},{"$f":"'Detailed Model'!J18","v":1},{"$f":"'Detailed Model'!K18","v":0},{"$f":"'Detailed Model'!L18","v":0}]
[{"$f":"'Detailed Model'!G19","v":0},{"$f":"'Detailed Model'!H19","v":0},{"$f":"'Detailed Model'!I19","v":0},{"$f":"'Detailed Model'!J19","v":1},{"$f":"'Detailed Model'!K19","v":1},{"$f":"'Detailed Model'!L19","v":0}]
[{"$f":"'Detailed Model'!G20","v":0},{"$f":"'Detailed Model'!H20","v":0},{"$f":"'Detailed Model'!I20","v":0},{"$f":"'Detailed Model'!J20","v":0},{"$f":"'Detailed Model'!K20","v":1},{"$f":"'Detailed Model'!L20","v":1}]
[{"$f":"'Detailed Model'!G21","v":2},{"$f":"'Detailed Model'!H21","v":0},{"$f":"'Detailed Model'!I21","v":0},{"$f":"'Detailed Model'!J21","v":0},{"$f":"'Detailed Model'!K21","v":0},{"$f":"'Detailed Model'!L21","v":0}]
[{"$f":"'Detailed Model'!G22","v":0},{"$f":"'Detailed Model'!H22","v":2},{"$f":"'Detailed Model'!I22","v":0},{"$f":"'Detailed Model'!J22","v":0},{"$f":"'Detailed Model'!K22","v":0},{"$f":"'Detailed Model'!L22","v":0}]
[{"$f":"'Detailed Model'!G23","v":0},{"$f":"'Detailed Model'!H23","v":0},{"$f":"'Detailed Model'!I23","v":2},{"$f":"'Detailed Model'!J23","v":0},{"$f":"'Detailed Model'!K23","v":0},{"$f":"'Detailed Model'!L23","v":0}]
[{"$f":"'Detailed Model'!G24","v":0},{"$f":"'Detailed Model'!H24","v":0},{"$f":"'Detailed Model'!I24","v":0},{"$f":"'Detailed Model'!J24","v":2},{"$f":"'Detailed Model'!K24","v":0},{"$f":"'Detailed Model'!L24","v":0}]
[{"$f":"'Detailed Model'!G25","v":0},{"$f":"'Detailed Model'!H25","v":0},{"$f":"'Detailed Model'!I25","v":0},{"$f":"'Detailed Model'!J25","v":0},{"$f":"'Detailed Model'!K25","v":2},{"$f":"'Detailed Model'!L25","v":0}]
[{"$f":"'Detailed Model'!G26","v":0},{"$f":"'Detailed Model'!H26","v":0},{"$f":"'Detailed Model'!I26","v":0},{"$f":"'Detailed Model'!J26","v":0},{"$f":"'Detailed Model'!K26","v":0},{"$f":"'Detailed Model'!L26","v":2}]
[{"$f":"'Detailed Model'!G27","v":0},{"$f":"'Detailed Model'!H27","v":0},{"$f":"'Detailed Model'!I27","v":0},{"$f":"'Detailed Model'!J27","v":0},{"$f":"'Detailed Model'!K27","v":0},{"$f":"'Detailed Model'!L27","v":2}]
[{"$f":"'Detailed Model'!G28","v":0},{"$f":"'Detailed Model'!H28","v":0},{"$f":"'Detailed Model'!I28","v":2},{"$f":"'Detailed Model'!J28","v":0},{"$f":"'Detailed Model'!K28","v":2},{"$f":"'Detailed Model'!L28","v":0}]
[{"$f":"'Detailed Model'!G29","v":0},{"$f":"'Detailed Model'!H29","v":0},{"$f":"'Detailed Model'!I29","v":2},{"$f":"'Detailed Model'!J29","v":2},{"$f":"'Detailed Model'!K29","v":0},{"$f":"'Detailed Model'!L29","v":0}]
[{"$f":"'Detailed Model'!G30","v":0},{"$f":"'Detailed Model'!H30","v":0},{"$f":"'Detailed Model'!I30","v":0},{"$f":"'Detailed Model'!J30","v":2},{"$f":"'Detailed Model'!K30","v":2},{"$f":"'Detailed Model'!L30","v":0}]
[{"$f":"'Detailed Model'!G31","v":0},{"$f":"'Detailed Model'!H31","v":0},{"$f":"'Detailed Model'!I31","v":0},{"$f":"'Detailed Model'!J31","v":0},{"$f":"'Detailed Model'!K31","v":2},{"$f":"'Detailed Model'!L31","v":2}]
[{"$f":"'Detailed Model'!G32","v":4},{"$f":"'Detailed Model'!H32","v":0},{"$f":"'Detailed Model'!I32","v":0},{"$f":"'Detailed Model'!J32","v":0},{"$f":"'Detailed Model'!K32","v":0},{"$f":"'Detailed Model'!L32","v":0}]
[{"$f":"'Detailed Model'!G33","v":0},{"$f":"'Detailed Model'!H33","v":0},{"$f":"'Detailed Model'!I33","v":4},{"$f":"'Detailed Model'!J33","v":0},{"$f":"'Detailed Model'!K33","v":0},{"$f":"'Detailed Model'!L33","v":0}]
[{"$f":"'Detailed Model'!G34","v":0},{"$f":"'Detailed Model'!H34","v":0},{"$f":"'Detailed Model'!I34","v":0},{"$f":"'Detailed Model'!J34","v":4},{"$f":"'Detailed Model'!K34","v":0},{"$f":"'Detailed Model'!L34","v":0}]
[{"$f":"'Detailed Model'!G35","v":0},{"$f":"'Detailed Model'!H35","v":0},{"$f":"'Detailed Model'!I35","v":0},{"$f":"'Detailed Model'!J35","v":0},{"$f":"'Detailed Model'!K35","v":4},{"$f":"'Detailed Model'!L35","v":0}]
[{"$f":"'Detailed Model'!G36","v":0},{"$f":"'Detailed Model'!H36","v":0},{"$f":"'Detailed Model'!I36","v":0},{"$f":"'Detailed Model'!J36","v":0},{"$f":"'Detailed Model'!K36","v":0},{"$f":"'Detailed Model'!L36","v":4}]

{"sheet":"Threat Libraries","index":6,"n_rows":11,"n_cols":19,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Average",6]
[]
[]
[]
[null,null,"Req_Red_A","Req_Red_B","Req_Red_C","Req_Red_D","Req_Red_E","Req_Red_F","Req_Orange_A","Req_Orange_B","Req_Orange_C","Req_Orange_D","Req_Orange_E","Req_Orange_F"]
[null,1,20,0,4,3,14,20,25,0,4,3,14,20]
[null,2,20,0,5,2,14,8,25,0,5,2,14,8]
[null,3,10,10,3,4,16,11,10,0,3,4,16,11]
[null,4,0,20,4,2,14,13,0,0,4,2,14,13]
[null,5,0,20,4,4,17,18,0,0,4,4,17,18]
[null,"Average",10,10,4,3,15,14,12,0,4,3,15,14]

{"sheet":"PMTable","index":7,"n_rows":8,"n_cols":22,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[{"$f":"IF('Detailed Model'!H4=0,6,'Detailed Model'!H4)","v":6},"Generated with the SIPmath™ Modeler Tools from ProbabilityManagement.org"]
[null,"Index","Shortfall01","Shortfall02","Shortfall03","Shortfall04","Shortfall05","Shortfall06","Shortfall07","Shortfall08","Shortfall09","Shortfall10","Shortfall11","Shortfall12","Shortfall13","Shortfall14","Shortfall15","Shortfall16","Shortfall17","Shortfall18","Shortfall19","Total_Shortfall"]
[null,"Values",{"$f":"Calculations!$D$49","v":56},{"$f":"Calculations!$E$49","v":52},{"$f":"Calculations!$F$49","v":47},{"$f":"Calculations!$G$49","v":42},{"$f":"Calculations!$H$49","v":38},{"$f":"Calculations!$I$49","v":34},{"$f":"Calculations!$J$49","v":30},{"$f":"Calculations!$K$49","v":26},{"$f":"Calculations!$L$49","v":22},{"$f":"Calculations!$M$49","v":18},{"$f":"Calculations!$N$49","v":14},{"$f":"Calculations!$O$49","v":10},{"$f":"Calculations!$P$49","v":8},{"$f":"Calculations!$Q$49","v":5},{"$f":"Calculations!$R$49","v":3},{"$f":"Calculations!$S$49","v":0},{"$f":"Calculations!$T$49","v":0},{"$f":"Calculations!$U$49","v":0},{"$f":"Calculations!$V$49","v":0},{"$f":"'Detailed Model'!$Q$8","v":5}]
[null,1,61,57,52,47,43,39,35,31,27,23,19,19,17,16,18,16,14,11,8,16]
[null,2,49,45,40,35,31,27,23,21,19,15,11,11,11,11,12,11,11,10,7,11]
[null,3,54,50,45,40,36,32,28,25,22,17,14,10,8,6,3,1,0,0,0,6]
[null,4,53,49,44,39,35,31,27,23,21,22,21,17,16,14,10,10,10,10,10,14]
[null,5,63,59,54,49,45,41,37,33,31,31,31,27,24,21,18,16,13,11,11,21]