{"text_format":"1","workbook":"xlsx","n_sheets":16,"sheets":["Start","Frequency modelling","Severity modelling","Sheet1","MLE","MCAtemplate","MCAexpert","MCAuserexpert","MCAsummary","MCAuserscores","MCAusersensitivity","Simulation Output 1","Simulation Output 1 Graph Data","Simulation Output 2","Simulation Output 2 Graph Data","Simulation Output 3 Graph Data"],"not_rendered":{"charts":11,"images":0,"macros":1,"external_links":0,"defined_names":225,"comments":2,"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":"Start","index":0,"n_rows":9,"n_cols":8,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null," "]

{"sheet":"Frequency modelling","index":1,"n_rows":21,"n_cols":3,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[]
["E[λ]",0.1,"The expected value of λ"]
["Lower Bound",6.6666669999999997E-2,"The lower bound of λ"]
["Upper Bound",0.14285713999999999,"The upper bound of λ"]
["Probability",0.66666667000000002,"The probability that λ will fall between the bounds"]
[]
["Years",10,"Number of years of history"]
["Events",2,"Total number of events in those years"]
[]
[]
[]
[]
["α",6.6605273568850683,"Initial value of α"]
["β",1.5013826481025465E-2,"Initial value of β"]
[]
["Objective",{"$f":"GAMMADIST(B_Upper,alpha,beta,TRUE)-GAMMADIST(A_Lower,alpha,beta,TRUE)","v":0.6666666718857166}]
["λ",{"$f":"alpha*beta","v":0.10000000200839558}]
[]
["α hat",{"$f":"alpha+Events","v":8.6605273568850691},"Value of α taking into account event information"]
["β hat",{"$f":"beta/(1+beta*Years)","v":1.3053931810104924E-2},"Value of β taking into account event information"]
["λ hat",{"$f":"alpha_hat*beta_hat","v":0.11305393355632593},"Updated λ"]

{"sheet":"Severity modelling","index":2,"n_rows":12,"n_cols":11,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[null,"Log Normal",null,null,null,null,null,"Log Normal",null,"Pareto","Weibull"]
["Expected loss",20,null,"Expected loss",20000000,null,"Expected loss",0,null,10]
["95% quantile",100,null,"95% quantile",100000000,null,"Lower bound",null,null,8]
[null,null,null,"Distribution","Lognormal",null,"Upper bound",null,null,12]
["mu",2.9957322735539909,null,null,null,null,"Probability",0.66666667000000002,null,0.66666667000000002]
["sigma",0.97846877208383232,null,"Param 1",16.811242831518264]
[null,null,null,"Param 2",4.1001515620179534,null,"LN Sigma",1,"Par B",2]
["Objective",{"$f":"EXP(mu + sigma * NORMSINV(0.95))","v":99.999999618674408},null,null,null,null,"LN MuZero",1,"Par Alpha",23.085703333338703]
["Loss",{"$f":"EXP(mu)","v":19.999999999999996},null,"Objective",{"$f":"(Distribution(DistName, DistQuantile, DistParam1, DistParam2, TRUE) - 0.95)^2","v":8.8406815668229818E-2},null,"LN SigmaZero",1,"Par Beta",0.43316852020287078]
[null,null,null,"Loss",{"$f":"(Distribution(DistName, DistExpLoss, DistParam1, DistParam2, TRUE) - 0.5)^2","v":0}]
["Alt Objective",{"$f":"(EXP(mu + sigma * NORMSINV(0.95)) - Quantile)^2 + (EXP(mu) - Expected_loss)^2","v":1.4540920676902456E-13},null,null,null,null,"Objective",{"$f":"NORMSDIST((LN(LN_UpperBound) - (LN_Sigma^2)/2 - LN_MuZero) / LN_SigmaZero) - NORMSDIST((LN(LN_LowerBound) - (LN_Sigma^2)/2 - LN_MuZero) / LN_SigmaZero)","v":{"$error":"#NUM!"}},null,{"$f":"(GAMMADIST(Par_UpperBound, Par_Alpha, Par_Beta, TRUE) - GAMMADIST(Par_LowerBound, Par_Alpha, Par_Beta, TRUE)) / (1 - GAMMADIST(Par_B, Par_Alpha, Par_Beta, TRUE))","v":0.66666667940835822}]
[null,null,null,null,null,null,"Loss",{"$f":"EXP(LN_MuZero + (LN_Sigma^2)/2 + (LN_SigmaZero^2)/2)","v":7.3890560989306504},null,{"$f":"Par_Alpha * Par_Beta * ((1 - GAMMADIST(Par_B, Par_Alpha + 1, Par_Beta, TRUE)) / (1 - GAMMADIST(Par_B, Par_Alpha, Par_Beta, TRUE)))","v":9.9999999570871783}]

{"sheet":"Sheet1","index":3,"n_rows":301,"n_cols":18,"rows_kept":301,"cut":false,"hidden":false,"merged":[[0,14,0,17]]}
[null,null,null,null,"Weibull","LogNormal","Burr",null,null,null,null,null,null,null,"Discount Rate"]
[2000,13,null,0.01,{"$f":"_xlfn.WEIBULL.DIST(D2,0.909448950865661,1.49631510724688,FALSE)","v":0.94653795914240535},{"$f":"_xlfn.LOGNORM.DIST(D2,0,0.978468774402127,FALSE)","v":6.313777296719803E-4},{"$f":"BurrDist(D2,1.8,1,FALSE)","v":4.5191249858328925E-2},{"$f":"LogNormPDF(D2,0,0.978468774402127)","v":6.3137772967197911E-4},{"$f":"NORMSDIST(1)","v":0.84134474606854304},null,null,"Capital","Maintenance","Lifetime",0.01,0.03,0.06,0.1]
[2001,49,null,0.02,{"$f":"_xlfn.WEIBULL.DIST(D3,0.909448950865661,1.49631510724688,FALSE)","v":0.8807798748339839},{"$f":"_xlfn.LOGNORM.DIST(D3,0,0.978468774402127,FALSE)","v":6.8907212080287676E-3},{"$f":"BurrDist(D3,1.8,1,FALSE)","v":7.8584535039964917E-2},{"$f":"LogNormPDF(D3,0,0.978468774402127)","v":6.8907212080287703E-3},{"$f":"LOGNORMDIST(1,1,1)","v":0.15865525393145699},null,null,35,3.5,40,{"$f":"dpv($L3,$M3,$N3,O$2)","v":149.9214013988466},{"$f":"dpv($L3,$M3,$N3,P$2)","v":115.90170190972253},87.662039050337128,69.226677514673682]
[2002,36,null,0.03,0.84158139583762726,2.2100877860270696E-2,0.1084912368373073,2.2100877860270721E-2,{"$f":"NORMDIST(LN(1), 0, 1, FALSE)","v":0.3989422804014327},null,null,100,19.5,40,{"$f":"dpv($L4,$M4,$N4,O$2)","v":740.27637922214524},550.73805349702548,393.40278899473532,290.69148901032474]
[2003,31,null,0.04,0.81296681228841372,4.5530028113087852E-2,0.13623193665843075,4.5530028113087907E-2,{"$f":"LogNormPDF(1, 1, 1)","v":0.24197072451914337},null,null,152.5,30,40,1137.5405834186847,845.94315922619307,603.88890614574689,445.87152155434586]
[2004,44,null,0.05,0.79008078087765232,7.5147630012215902E-2,0.16236939519273408,7.5147630012215999E-2,null,null,null,0.5,0.05,40,2.141734305697808,1.6557385987103226,1.2523148435762448,0.98895253592390975]
[null,null,null,0.06,0.77079887211491027,0.1088816668526264,0.18720690364545151,0.10888166685262653]
[null,{"$f":"LN(B2)","v":2.5649493574615367},null,7.0000000000000007E-2,0.75400126810234547,0.14499321960560274,0.21092923301414027,0.1449932196056028]
[null,{"$f":"LN(B3)","v":3.8918202981106265},null,0.08,0.73902509435985098,0.18213314091967547,0.23365793419647837,0.18213314091967533]
[null,3.5835189384561099,null,0.09,0.72544531319107763,0.21929862166725575,0.25547736780605546,0.21929862166725558]
[null,3.4339872044851463,null,0.1,0.71297292061973949,0.2557670745825808,0.2764485067881865,0.25576707458258074]
[null,3.784189633918261,null,0.11,0.70140236299913161,0.29103320810882549,0.29661690287535053,0.29103320810882538]
[null,null,null,0.12,0.69058213221482867,0.32475647324779711,0.31601758594520413,0.32475647324779694]
["mu hat",{"$f":"SUM(B8:B12)/COUNT(B8:B12)","v":3.4516930864863355},null,0.13,0.68039727118085613,0.3567194997153898,0.33467822895614713,0.35671949971538958]
[null,null,null,0.14000000000000001,0.67075843367791643,0.38679607635392566,0.35262127357960005,0.38679607635392577]
[null,{"$f":"(B8-$B$14)^2","v":0.78631444096480585},null,0.15,0.6615947566885767,0.41492681798140574,0.36986540302386917,0.41492681798140568]
[null,{"$f":"(B9-$B$14)^2","v":0.19371196241217337},null,0.16,0.65284905436185192,0.44110080988031225,0.38642658845031874,0.44110080988031214]
[null,1.7378055247556864E-2,null,0.17,0.64447448132875151,0.46534182085323855,0.40231884750014119,0.46534182085323872]
[null,3.1349825744003842E-4,null,0.18,0.6364321570991881,0.48769797767610445,0.4175548028720738,0.48769797767610445]
[null,0.11055395405415067,null,0.19,0.62868943723919057,0.50823405140174494,0.43214609859030823,0.50823405140174505]
[null,null,null,0.2,0.62121863076913952,0.52702571136411713,0.44610371280994277,0.52702571136411724]
["sigma hat",{"$f":"SUM(B16:B20)/COUNT(B16:B20)","v":0.22165438218722536},null,0.21,0.6139960322335164,0.54415526121362257,0.45943819399650115,0.54415526121362257]
[null,null,null,0.22,0.60700118003414461,0.55970849157287472,0.4721598394328233,0.55970849157287461]
[null,null,null,0.23,0.60021628031280438,0.57377237440533546,0.48427882970875819,0.57377237440533535]
[null,null,null,0.24,0.59362575387169891,0.58643339205650491,0.49580532921233306,0.58643339205650491]
[null,null,null,0.25,0.58721587584087176,0.59777634477926223,0.50674956009600913,0.59777634477926223]
[null,null,null,0.26,0.58097448616483072,0.60788351868963431,0.5171218553789364,0.60788351868963431]
[null,null,null,0.27,0.57489075480426899,0.61683412474922494,0.52693269553380928,0.61683412474922505]
[null,null,null,0.28000000000000003,0.56895498966881197,0.62470394094592019,0.53619273194238515,0.62470394094592008]
[null,null,null,0.28999999999999998,0.56315847825410814,0.63156510613538719,0.54491279988459862,0.63156510613538708]
[null,null,null,0.3,0.55749335610793305,0.63748602634038587,0.55310392318277279,0.63748602634038587]
[null,null,null,0.31,0.55195249683432546,0.64253136366909624,0.56077731220644933,0.64253136366909624]
[null,null,null,0.32,0.54652941952494638,0.64676208514106581,0.56794435662100728,0.64676208514106581]
[null,null,null,0.33,0.54121821039525908,0.65023555414702594,0.57461661401046749,0.65023555414702594]
[null,null,null,0.34,0.53601345607854922,0.65300565142594047,0.58080579530440291,0.65300565142594047]
[null,null,null,0.35,0.53091018654899247,0.65512291562635783,0.58652374777816585,0.65512291562635794]
[null,null,null,0.36,0.52590382604599761,0.65663469596067892,0.59178243626542748,0.65663469596067903]
[null,null,null,0.37,0.52099015068488219,0.65758531133509468,0.59659392311552051,0.65758531133509468]
[null,null,null,0.38,0.51616525168482785,0.65801621177716407,0.60097034734012755,0.65801621177716418]
[null,null,null,0.39,0.51142550333972059,0.65796613908805157,0.60492390332061696,0.65796613908805157]
[null,null,null,0.4,0.50676753501260985,0.65747128449423831,0.60846681938586755,0.65747128449423831]
[null,null,null,0.41,0.50218820655894203,0.65656544172289877,0.611611336518468,0.65656544172289866]
[null,null,null,0.42,0.49768458668410109,0.65528015442125542,0.61436968740298192,0.65528015442125553]
[null,null,null,0.43,0.49325393382225363,0.65364485721786669,0.61675407599219834,0.65364485721786658]
[null,null,null,0.44,0.48889367918993298,0.65168701000975549,0.61877665773482216,0.65168701000975549]
[null,null,null,0.45,0.48460141172229881,0.64943222527430255,0.62044952058010039,0.64943222527430244]
[null,null,null,0.46,0.48037486464489476,0.64690438836494202,0.62178466685068878,0.64690438836494202]
[null,null,null,0.47,0.4762119034709032,0.64412577086739864,0.62279399605415753,0.64412577086739864]
[null,null,null,0.48,0.4721105152447897,0.64111713717814445,0.62348928868537923,0.64111713717814445]
[null,null,null,0.49,0.46806879887904218,0.63789784452649989,0.62388219105635867,0.63789784452649989]
[null,null,null,0.5,0.46408495645233766,0.634485936702189,0.62398420117645959,0.634485936702189]
[null,null,null,0.51,0.46015728535567701,0.63089823177578297,0.62380665569426152,0.63089823177578264]
[null,null,null,0.52,0.45628417118840925,0.62715040411386347,0.6233607179021764,0.62715040411386336]
[null,null,null,0.53,0.45246408131910004,0.62325706099670608,0.622657366796316,0.62325706099670608]
[null,null,null,0.54,0.44869555903729286,0.61923181414594741,0.62170738717673046,0.61923181414594763]
[null,null,null,0.55000000000000004,0.44497721823167075,0.61508734646477403,0.620521360766914,0.61508734646477403]
[null,null,null,0.56000000000000005,0.44130773853823013,0.6108354742849168,0.61910965832627229,0.6108354742849168]
[null,null,null,0.56999999999999995,0.43768586090903167,0.60648720540418666,0.61748243272493497,0.60648720540418666]
[null,null,null,0.57999999999999996,0.4341103835580849,0.6020527931861871,0.61564961294679754,0.6020527931861871]
[null,null,null,0.59,0.43058015824609408,0.59754178698081384,0.61362089898389371,0.59754178698081384]
[null,null,null,0.6,0.42709408687027134,0.59296307911061386,0.61140575758304394,0.59296307911061386]
[null,null,null,0.61,0.42365111832931202,0.58832494865439566,0.60901341880414461,0.58832494865439577]
[null,null,null,0.62,0.42025024563700902,0.58363510224588366,0.60645287334836573,0.58363510224588366]
[null,null,null,0.63,0.41689050326093524,0.57890071209190053,0.6037328706138676,0.57890071209190064]
[null,null,null,0.64,0.41357096466520393,0.57412845140165403,0.60086191743639406,0.57412845140165403]
[null,null,null,0.65,0.41029074003858046,0.56932452740629758,0.59784827747213609,0.56932452740629746]
[null,null,null,0.66,{"$f":"_xlfn.WEIBULL.DIST(D67,0.909448950865661,1.49631510724688,FALSE)","v":0.40704897419120145},{"$f":"_xlfn.LOGNORM.DIST(D67,0,0.978468774402127,FALSE)","v":0.56449471213609403},{"$f":"BurrDist(D67,1.8,1,FALSE)","v":0.59469997118064077},{"$f":"LogNormPDF(D67,0,0.978468774402127)","v":0.56449471213609403}]
[null,null,null,0.67,0.40384484460491138,0.55964437111125376,0.59142477636612145,0.55964437111125376]
[null,null,null,0.68,0.40067755962376489,0.55477849009187641,0.58803022923635273,0.5547784900918763]
[null,null,null,0.69,0.39754635677260697,0.5499017000224028,0.58452362593932172,0.54990170002240268]
[null,null,null,0.7,0.39445050119285269,0.54501830029655385,0.58091202453894908,0.54501830029655374]
[null,null,null,0.71,0.39138928418565416,0.54013228045990502,0.5772022473924604,0.54013228045990513]
[null,null,null,0.72,0.38836202185359653,0.53524734045898525,0.57340088389334831,0.53524734045898525]
[null,null,null,0.73,0.38536805383291411,0.5303669095380722,0.56951429354530247,0.53036690953807208]
[null,null,null,0.74,0.38240674210896575,0.52549416387767012,0.56554860933397932,0.52549416387767012]
[null,null,null,0.75,0.3794774699083926,0.52063204306195487,0.56150974136501253,0.52063204306195487]
[null,null,null,0.76,0.37657964066197702,0.51578326545624154,0.55740338073822693,0.51578326545624154]
[null,null,null,0.77,0.37371267703276767,0.51095034256974026,0.55323500362957512,0.51095034256974015]
[null,null,null,0.78,0.37087602000451786,0.50613559247348638,0.54900987555388803,0.5061355924734865]
[null,null,null,0.79,0.36806912802592362,0.50134115233833598,0.54473305578307918,0.50134115233833598]
[null,null,null,0.8,0.36529147620653762,0.49656899015328099,0.5404094018959702,0.49656899015328099]
[null,null,null,0.81,0.36254255556059106,0.49182091568004993,0.53604357443741446,0.49182091568004987]
[null,null,null,0.82,0.35982187229527507,0.48709859069595979,0.53164004166585888,0.48709859069595979]
[null,null,null,0.83,0.35712894714032067,0.48240353857330015,0.52720308436991181,0.48240353857330009]
[null,null,null,0.84,0.35446331471597958,0.4777371532400993,0.52273680073587303,0.47773715324009935]
[null,null,null,0.85,0.3518245229367431,0.47310070756394879,0.51824511124951034,0.47310070756394879]
[null,null,null,0.86,0.3492121324483517,0.46849536119761609,0.51373176361666129,0.46849536119761603]
[null,null,null,0.87,0.34662571609584431,0.46392216792245305,0.50920033768846662,0.46392216792245305]
[null,null,null,0.88,0.34406485842057299,0.45938208252307339,0.50465425037821876,0.45938208252307333]
[null,null,null,0.89,0.34152915518426807,0.45487596722443002,0.50009676055794183,0.45487596722443008]
[null,null,null,0.9,0.33901821291839035,0.45040459772025387,0.49553097392387968,0.45040459772025393]
[null,null,null,0.91,0.33653164849713846,0.44596866881979391,0.49095984782109026,0.44596866881979391]
[null,null,null,0.92,0.33406908873260155,0.44156879973793794,0.48638619601829952,0.44156879973793794]
[null,null,null,0.93,0.33163016999066386,0.43720553905205511,0.4818126934250771,0.43720553905205506]
[null,null,null,0.94,0.32921453782636434,0.4328793693472956,0.47724188074425039,0.43287936934729554]
[null,null,null,0.95,0.32682184663751496,0.42859071157059409,0.4726761690532682,0.42859071157059403]
[null,null,null,0.96,0.32445175933546239,0.42433992911223584,0.46811784430898817,0.42433992911223578]
[null,null,null,0.97,0.32210394703196144,0.42012733163256316,0.46356907177105067,0.42012733163256327]
[null,null,null,0.98,0.31977808874119706,0.41595317865020598,0.45903190033967023,0.41595317865020592]
[null,null,null,0.99,0.31747387109606373,0.41181768290711152,0.45450826680427531,0.41181768290711146]
[null,null,null,1,0.31519098807786677,0.40772101352462475,0.45,0.40772101352462475]
[null,null,null,1.01,0.31292914075867356,0.40366329896390818,0.44550882486955173,0.40366329896390818]
[null,null,null,1.02,0.31068803705558984,0.39964462980310678,0.44103636642846689,0.39964462980310678]
[null,null,null,1.03,0.3084673914962856,0.39566506134283752,0.43658415363220954,0.39566506134283747]
[null,null,null,1.04,0.30626692499514369,0.39172461605081249,0.43215362314398381,0.39172461605081244]
[null,null,null,1.05,0.30408636463943967,0.38782328585569442,0.42774612300249898,0.38782328585569442]
[null,null,null,1.06,0.30192544348500283,0.38396103429961581,0.42336291618928312,0.38396103429961581]
[null,null,null,1.07,0.2997839003608464,0.3801377985581762,0.41900518409543686,0.3801377985581762]
[null,null,null,1.08,0.29766147968227996,0.37635349133615781,0.41467402988802365,0.37635349133615781]
[null,null,null,1.0900000000000001,0.29555793127205621,0.37260800264666055,0.41037048177653196,0.37260800264666055]
[null,null,null,1.1000000000000001,0.2934730101891268,0.36890120148086197,0.40609549618009155,0.36890120148086203]
[null,null,null,1.1100000000000001,0.29140647656460972,0.36523293737514073,0.40184996079632468,0.36523293737514068]
[null,null,null,1.1200000000000001,0.28935809544459634,0.36160304188186804,0.39763469757290471,0.36160304188186798]
[null,null,null,1.1299999999999999,0.28732763663944622,0.3580113299497712,0.39345046558305841,0.35801132994977114]
[null,null,null,1.1399999999999999,0.28531487457924193,0.35445760121939124,0.38929796380639431,0.35445760121939135]
[null,null,null,1.1499999999999999,0.28331958817509323,0.35094164123881144,0.38517783381656712,0.3509416412388115]
[null,null,null,1.1599999999999999,0.28134156068599936,0.34746322260449919,0.38109066237740324,0.34746322260449913]
[null,null,null,1.17,0.27938057959099594,0.344022106031804,0.37703698394920293,0.344022106031804]
[null,null,null,1.18,0.27743643646632704,0.34061804135936519,0.37301728310702337,0.34061804135936519]
[null,null,null,1.19,0.27550892686739942,0.33725076849141566,0.36903199687280841,0.33725076849141561]
[null,null,null,1.2,0.27359785021528937,0.33392001828172202,0.36508151696329805,0.33392001828172208]
[null,null,null,1.21,0.27170300968758565,0.33062551336266688,0.36116619195568217,0.33062551336266693]
[null,null,null,1.22,0.26982421211336305,0.32736696892276007,0.35728632937301374,0.32736696892276002]
[null,null,null,1.23,0.26796126787209512,0.3241440934356658,0.35344219769141261,0.3241440934356658]
[null,null,null,1.24,0.26611399079632175,0.32095658934364102,0.3496340282711134,0.32095658934364102]
[null,null,null,1.25,0.2642821980779001,0.31780415369809989,0.34586201721342091,0.31780415369809983]
[null,null,null,1.26,0.26246571017767589,0.31468647875985806,0.34212632714563923,0.31468647875985811]
[null,null,null,1.27,0.26066435073841931,0.31160325256145111,0.33842708893603868,0.31160325256145111]
[null,null,null,1.28,0.25887794650088114,0.30855415943377534,0.33476440334091495,0.3085541594337754]
[null,null,null,1.29,0.25710632722282906,0.3055388804991675,0.33113834258578329,0.30553888049916744]
[null,null,null,1.3,{"$f":"_xlfn.WEIBULL.DIST(D131,0.909448950865661,1.49631510724688,FALSE)","v":0.25534932560093365},{"$f":"_xlfn.LOGNORM.DIST(D131,0,0.978468774402127,FALSE)","v":0.30255709413290477},{"$f":"BurrDist(D131,1.8,1,FALSE)","v":0.32754895188272976},{"$f":"LogNormPDF(D131,0,0.978468774402127)","v":0.30255709413290488}]
[null,null,null,1.31,0.25360677719537972,0.29960847639499572,0.32399625088592315,0.29960847639499572]
[null,null,null,1.32,0.25187852035708447,0.29669270143401072,0.32048023508726092,0.29669270143401061]
[null,null,null,1.33,0.25016439615741132,0.29380944186460467,0.31700087715409958,0.29380944186460467]
[null,null,null,1.34,0.24846424832027203,0.29095836912028145,0.31355812821098172,0.29095836912028139]
[null,null,null,1.35,0.24677792315651745,0.28813915378285515,0.31015191906724543,0.28813915378285504]
[null,null,null,1.36,0.24510526950052003,0.28535146588998295,0.30678216139235942,0.285351465889983]
[null,null,null,1.37,0.24344613864885731,0.28259497522205845,0.30344874884079409,0.28259497522205856]
[null,null,null,1.38,0.24180038430100995,0.27986935156967729,0.30015155812819827,0.2798693515696774]
[null,null,null,1.39,0.24016786250199146,0.27717426498282011,0.29689045006061138,0.27717426498282005]
[null,null,null,1.4,0.23854843158683131,0.27450938600282587,0.29366527051840047,0.27450938600282593]
[null,null,null,1.41,0.23694195212683761,0.27187438587817003,0.2904758513965674,0.27187438587816998]
[null,null,null,1.42,0.23534828687756609,0.26926893676499525,0.2873220115030346,0.26926893676499525]
[null,null,null,1.43,0.23376730072843088,0.26669271191329891,0.28420355741646813,0.26669271191329891]
[null,null,null,1.44,0.23219886065388909,0.26414538583961572,0.28112028430516117,0.26414538583961578]
[null,null,null,1.45,0.23064283566614036,0.26162663448699525,0.27807197670845279,0.2616266344869953]
[null,null,null,1.46,0.22909909676928142,0.2591361353730226,0.27505840928211794,0.2591361353730226]
[null,null,null,1.47,0.22756751691485971,0.256673567726588,0.2720793475091195,0.256673567726588]
[null,null,null,1.48,0.22604797095877299,0.25423861261407193,0.2691345483770744,0.25423861261407193]
[null,null,null,1.49,0.22454033561946388,0.25183095305557174,0.26622376102373957,0.25183095305557174]
[null,null,null,1.5,0.22304448943736011,0.24945027413176091,0.26334672735178782,0.24945027413176091]
[null,null,null,1.51,0.22156031273551516,0.24709626308193847,0.26050318261409761,0.24709626308193844]
[null,null,null,1.52,0.22008768758140304,0.24476860939379261,0.25769285597074593,0.24476860939379266]
[null,null,null,1.53,0.21862649774982626,0.24246700488537487,0.2549154710188487,0.2424670048853749]
[null,null,null,1.54,0.21717662868689627,0.24019114377974948,0.25217074629636133,0.24019114377974937]
[null,null,null,1.55,0.21573796747504537,0.23794072277275927,0.24945839576090656,0.23794072277275932]
[null,null,null,1.56,0.21431040279903654,0.23571544109432405,0.24677812924466572,0.23571544109432405]
[null,null,null,1.57,0.2128938249129316,0.23351500056365873,0.24412965288633165,0.23351500056365873]
[null,null,null,1.58,0.21148812560798741,0.2313391056387849,0.24151266954108383,0.23133910563878493]
[null,null,null,1.59,0.21009319818144401,0.22918746346068058,0.23892687916951563,0.22918746346068056]
[null,null,null,1.6,0.2087089374061758,0.22705978389239731,0.23637197920640676,0.22705978389239737]
[null,null,null,1.61,0.20733523950117502,0.22495577955345503,0.23384766491020348,0.22495577955345505]
[null,null,null,1.62,0.20597200210283836,0.2228751658498046,0.23135362969403606,0.2228751658498046]
[null,null,null,1.63,0.2046191242370301,0.22081766099963587,0.2288895654390718,0.2208176609996359]
[null,null,null,1.64,0.20327650629189412,0.21878298605528956,0.22645516279097386,0.21878298605528954]
[null,null,null,1.65,0.20194404999139084,0.21677086492151815,0.22405011144020417,0.21677086492151812]
[null,null,null,1.66,0.20062165836953352,0.21478102437032809,0.22167410038688279,0.21478102437032809]
[null,null,null,1.67,0.19930923574530138,0.21281319405262014,0.21932681819088631,0.21281319405262014]
[null,null,null,1.68,0.19800668769820656,0.21086710650683446,0.21700795320784488,0.21086710650683443]
[null,null,null,1.69,0.19671392104449417,0.20894249716479416,0.21471719381166654,0.20894249716479421]
[null,null,null,1.7,0.1954308438139534,0.20703910435493147,0.2124542286041986,0.20703910435493147]
[null,null,null,1.71,0.19415736522732147,0.20515666930306703,0.21021874661260637,0.20515666930306709]
[null,null,null,1.72,0.19289339567426025,0.2032949361309086,0.20801043747502984,0.20329493613090857]
[null,null,null,1.73,0.19163884669188685,0.20145365185241909,0.20582899161505469,0.20145365185241912]
[null,null,null,1.74,0.19039363094384207,0.19963256636820298,0.20367410040551345,0.1996325663682029]
[null,null,null,1.75,0.18915766219987779,0.19783143245804366,0.20154545632210985,0.19783143245804363]
[null,null,null,1.76,0.18793085531594853,0.19605000577172518,0.19944275308734169,0.19605000577172516]
[null,null,null,1.77,0.18671312621479078,0.19428804481825565,0.19736568580517613,0.19428804481825571]
[null,null,null,1.78,0.18550439186697434,0.19254531095361047,0.19531395108691268,0.19254531095361052]
[null,null,null,1.79,0.1843045702724127,0.19082156836710157,0.19328724716865245,0.19082156836710149]
[null,null,null,1.8,0.18311358044231674,0.18911658406647502,0.19128527402077289,0.18911658406647505]
[null,null,null,1.81,0.18193134238157913,0.18743012786183486,0.18930773344979185,0.18743012786183486]
[null,null,null,1.82,0.18075777707157686,0.1857619723484798,0.18735432919298819,0.18576197234847977]
[null,null,null,1.83,0.17959280645337722,0.18411189288874286,0.18542476700613031,0.18411189288874288]
[null,null,null,1.84,0.17843635341133829,0.18247966759291129,0.18351875474464888,0.18247966759291129]
[null,null,null,1.85,0.17728834175708949,0.18086507729930326,0.18163600243857694,0.18086507729930326]
[null,null,null,1.86,0.17614869621388252,0.17926790555357364,0.1797762223615644,0.17926790555357361]
[null,null,null,1.87,0.17501734240130107,0.17768793858731477,0.17793912909426388,0.17768793858731483]
[null,null,null,1.88,0.17389420682031931,0.17612496529601721,0.17612443958236754,0.17612496529601723]
[null,null,null,1.89,0.17277921683869876,0.17457877721644757,0.17433187318956681,0.17457877721644757]
[null,null,null,1.9,0.17167230067671424,0.17304916850350263,0.17256115174569339,0.17304916850350266]
[null,null,null,1.91,0.17057338739319824,0.17153593590659025,0.17081199959028631,0.17153593590659016]
[null,null,null,1.92,0.16948240687189658,0.17003887874558676,0.16908414361182247,0.17003887874558676]
[null,null,null,1.93,0.16839928980812491,0.16855779888642003,0.16737731328283659,0.16855779888642]
[null,null,null,1.94,{"$f":"_xlfn.WEIBULL.DIST(D195,0.909448950865661,1.49631510724688,FALSE)","v":0.16732396769571797},{"$f":"_xlfn.LOGNORM.DIST(D195,0,0.978468774402127,FALSE)","v":0.16709250071631795},{"$f":"BurrDist(D195,1.8,1,FALSE)","v":0.1656912406911443},{"$f":"LogNormPDF(D195,0,0.978468774402127)","v":0.16709250071631795}]
[null,null,null,1.95,0.16625637281426445,0.16564279111876781,0.16402566056737525,0.16564279111876781]
[null,null,null,1.96,0.1651964382166177,0.16420847944822212,0.16238031030901337,0.16420847944822212]
[null,null,null,1.97,0.16414409771667646,0.16278937750458924,0.16075493000113011,0.16278937750458922]
[null,null,null,1.98,0.16309928587742695,0.16138529950754163,0.15914926243399244,0.16138529950754163]
[null,null,null,1.99,0.16206193799923965,0.15999606207067507,0.15756305311771399,0.15999606207067507]
[null,null,null,2,0.16103199010841421,0.15862148417554731,0.15599605029411492,0.15862148417554725]
[null,null,null,2.0099999999999998,0.16000937894596454,0.15726138714562557,0.15444800494594557,0.15726138714562554]
[null,null,null,2.02,0.15899404195663946,0.15591559462016893,0.15291867080362129,0.15591559462016893]
[null,null,null,2.0299999999999998,0.15798591727817146,0.15458393252806998,0.15140780434961265,0.15458393252806998]
[null,null,null,2.04,0.15698494373074659,0.15326622906167858,0.14991516482062428,0.15326622906167858]
[null,null,null,2.0499999999999998,0.15599106080669273,0.15196231465063056,0.14844051420769236,0.15196231465063054]
[null,null,null,2.06,0.15500420866037676,0.15067202193569984,0.14698361725432241,0.15067202193569981]
[null,null,null,2.0699999999999998,0.15402432809830796,0.14939518574269414,0.14554424145278752,0.1493951857426942]
[null,null,null,2.08,0.15305136056944085,0.14813164305641116,0.14412215703869363,0.14813164305641119]
[null,null,null,2.09,0.15208524815567312,0.1468812329946714,0.14271713698392408,0.14688123299467143]
[null,null,null,2.1,0.15112593356253279,0.14564379678244335,0.14132895698805931,0.14564379678244338]
[null,null,null,2.11,0.15017336011005092,0.14441917772607521,0.13995739546837266,0.14441917772607521]
[null,null,null,2.12,0.14922747172381359,0.14320722118764528,0.13860223354849008,0.14320722118764523]
[null,null,null,2.13,0.14828821292619102,0.1420077745594448,0.13726325504580489,0.1420077745594448]
[null,null,null,2.14,0.14735552882773581,0.14082068723860297,0.13594024645772754,0.14082068723860297]
[null,null,null,2.15,0.14642936511875029,0.13964581060186554,0.13463299694685191,0.13964581060186559]
[null,null,null,2.16,0.14550966806101523,0.13848299798053632,0.13334129832511146,0.13848299798053632]
[null,null,null,2.17,0.14459638447967796,0.13733210463559006,0.13206494503699845,0.13733210463559006]
[null,null,null,2.1800000000000002,0.14368946175529523,0.13619298773296562,0.1308037341419126,0.13619298773296562]
[null,null,null,2.19,0.1427888478160273,0.13506550631904662,0.1295574652957055,0.13506550631904671]
[null,null,null,2.2000000000000002,0.14189449112997918,0.13394952129633586,0.12832594073148043,0.13394952129633581]
[null,null,null,2.21,0.14100634069768614,0.13284489539933003,0.12710896523970741,0.13284489539933009]
[null,null,null,2.2200000000000002,0.14012434604473925,0.13175149317060175,0.12590634614770738,0.13175149317060164]
[null,null,null,2.23,0.13924845721454834,0.13066918093709082,0.12471789329855977,0.13066918093709082]
[null,null,null,2.2400000000000002,0.13837862476123824,0.12959782678661377,0.12354341902948125,0.12959782678661383]
[null,null,null,2.25,0.1375147997426763,0.12853730054459156,0.12238273814972492,0.12853730054459156]
[null,null,null,2.2599999999999998,0.13665693371362694,0.12748747375100147,0.12123566791804299,0.1274874737510015]
[null,null,null,2.27,0.13580497871903088,0.12644821963755695,0.12010202801975715,0.12644821963755701]
[null,null,null,2.2799999999999998,0.13495888728740615,0.12541941310511676,0.11898164054347525,0.12541941310511673]
[null,null,null,2.29,0.1341186124243679,0.12440093070132598,0.11787432995749331,0.12440093070132596]
[null,null,null,2.2999999999999998,0.13328410760626416,0.12339265059849368,0.11677992308591936,0.12339265059849362]
[null,null,null,2.31,0.13245532677392519,0.12239445257170464,0.11569824908455151,0.1223944525717047]
[null,null,null,2.3199999999999998,0.13163222432652361,0.12140621797717203,0.11462913941654476,0.12140621797717203]
[null,null,null,2.33,0.1308147551155428,0.12042782973082637,0.11357242782789519,0.12042782973082636]
[null,null,null,2.34,0.13000287443885131,0.1194591722871476,0.11252795032277173,0.11945917228714763]
[null,null,null,2.35,0.12919653803488043,0.1185001316182368,0.11149554513872141,0.1185001316182368]
[null,null,null,2.36,0.12839570207690354,0.11755059519312976,0.11047505272177549,0.11755059519312976]
[null,null,null,2.37,0.12760032316741371,0.11661045195735291,0.10946631570147854,0.11661045195735283]
[null,null,null,2.38,0.12681035833259846,0.11567959231272046,0.10846917886586567,0.11567959231272042]
[null,null,null,2.39,0.12602576501690888,0.11475790809737431,0.10748348913640711,0.11475790809737427]
[null,null,null,2.4,0.12524650107772151,0.11384529256606472,0.10650909554294263,0.11384529256606475]
[null,null,null,2.41,0.12447252478009038,0.11294164037067252,0.10554584919862273,0.1129416403706725]
[null,null,null,2.42,0.12370379479158811,0.11204684754097134,0.10459360327487627,0.11204684754097134]
[null,null,null,2.4300000000000002,0.12294027017723295,0.11116081146562985,0.10365221297642017,0.11116081146562988]
[null,null,null,2.44,0.12218191039450121,0.11028343087345276,0.10272153551632772,0.11028343087345271]
[null,null,null,2.4500000000000002,0.12142867528842208,0.1094146058148585,0.1018014300911694,0.10941460581485851]
[null,null,null,2.46,0.12068052508675431,0.10855423764359547,0.10089175785624142,0.10855423764359541]
[null,null,null,2.4700000000000002,0.11993742039524138,0.10770222899869067,9.9992381900893323E-2,0.10770222899869066]
[null,null,null,2.48,0.11919932219294549,0.10685848378663494,9.9103167223968183E-2,0.10685848378663494]
[null,null,null,2.4900000000000002,0.11846619182765694,0.10602290716379845,9.8223980709365596E-2,0.10602290716379845]
[null,null,null,2.5,0.1177379910113783,0.10519540551907816,9.7354691101738819E-2,0.10519540551907812]
[null,null,null,2.5099999999999998,0.11701468181588176,{"$f":"_xlfn.LOGNORM.DIST(D252,0,0.978468774402127,FALSE)","v":0.10437588645677362},{"$f":"BurrDist(D252,1.8,1,FALSE)","v":9.6495168982335136E-2},0.10437588645677365]
[null,null,null,2.52,0.11629622666833769,0.10356425877969108,9.5645286744989289E-2,0.10356425877969111]
[null,null,null,2.5299999999999998,0.11558258834701327,0.1027604324724723,9.4804918572277713E-2,0.10276043247247223]
[null,null,null,2.54,0.11487372997703989,0.10196431868514715,9.3973940411841678E-2,0.10196431868514721]
[null,null,null,2.5499999999999998,0.11416961502624758,0.10117582971690961,9.3152229952886911E-2,0.1011758297169096]
[null,null,null,2.56,0.11347020730106502,0.10039487900011096,9.233966660286555E-2,0.1003948790001109]
[null,null,null,2.57,0.11277547094248469,9.9621381084473284E-2,9.1536131464347373E-2,9.9621381084473243E-2]
[null,null,null,2.58,{"$f":"_xlfn.WEIBULL.DIST(D259,0.909448950865661,1.49631510724688,FALSE)","v":0.1120853704220903},9.8855251621517592E-2,9.0741507312085232E-2,{"$f":"LogNormPDF(D259,0,0.978468774402127)","v":9.8855251621517592E-2}]
[null,null,null,2.59,0.11139987053814711,9.8096407349206133E-2,8.9955678570280334E-2,9.8096407349206119E-2]
[null,null,null,2.6,0.11071893641175207,9.7344766076795763E-2,8.9178531290051627E-2,9.7344766076795763E-2]
[null,null,null,2.61,0.11004253348304387,9.6600246669901677E-2,8.8409953127113944E-2,9.6600246669901621E-2]
[null,null,null,2.62,0.10937062750747131,9.5862769035767487E-2,8.7649833319668052E-2,9.5862769035767431E-2]
[null,null,null,2.63,0.10870318455211873,9.5132254108741349E-2,8.6898062666507084E-2,9.5132254108741335E-2]
[null,null,null,2.64,0.10804017099208732,9.4408623835954303E-2,8.6154533505341135E-2,9.4408623835954261E-2]
[null,null,null,2.65,0.1073815535069317,9.3691801163199362E-2,8.5419139691344001E-2,9.3691801163199362E-2]
[null,null,null,2.66,0.10672729907715002,9.2981710021009398E-2,8.4691776575923347E-2,9.2981710021009356E-2]
[null,null,null,2.67,0.10607737498072718,9.2278275310930663E-2,8.3972340985717236E-2,9.2278275310930663E-2]
[null,null,null,2.68,0.10543174878972959,9.1581422891990755E-2,8.3260731201818122E-2,9.1581422891990713E-2]
[null,null,null,2.69,0.10479038836695115,9.0891079567357494E-2,8.2556846939226616E-2,9.0891079567357494E-2]
[null,null,null,2.7,0.10415326186260836,9.0207173071187932E-2,8.186058932653506E-2,9.0207173071187918E-2]
[null,null,null,2.71,0.10352033771108538,8.9529632055663777E-2,8.1171860885843244E-2,8.9529632055663777E-2]
[null,null,null,2.72,0.10289158462772592,8.885838607821199E-2,8.0490565512905995E-2,8.8858386078211948E-2]
[null,null,null,2.7299999999999902,0.10226697160567377,8.8193365588908113E-2,7.9816608457514565E-2,8.819336558890814E-2]
[null,null,null,2.73999999999999,0.10164646791275585,8.7534501918057422E-2,7.914989630410732E-2,8.753450191805745E-2]
[null,null,null,2.7499999999999898,0.101030043088417,8.6881727263959388E-2,7.8490336952620893E-2,8.6881727263959402E-2]
[null,null,null,2.75999999999999,0.10041766694069294,8.6234974680842208E-2,7.7837839599567554E-2,8.6234974680842222E-2]
[null,null,null,2.7699999999999898,9.9809309543230404E-2,8.5594178066973975E-2,7.7192314719349037E-2,8.5594178066973933E-2]
[null,null,null,2.77999999999999,9.9204941232348645E-2,8.4959272152943591E-2,7.6553674045802197E-2,8.4959272152943563E-2]
[null,null,null,2.7899999999999898,9.8604532604144077E-2,8.433019249011206E-2,7.5921830553976929E-2,8.4330192490112074E-2]
[null,null,null,2.7999999999999901,9.8008054511635259E-2,8.3706875439229139E-2,7.5296698442145232E-2,8.3706875439229181E-2]
[null,null,null,2.8099999999999898,9.7415478061949237E-2,8.308925815921557E-2,7.4678193114041141E-2,8.308925815921557E-2]
[null,null,null,2.8199999999999901,9.6826774613546968E-2,8.247727859610661E-2,7.4066231161330001E-2,8.2477278596106623E-2]
[null,null,null,2.8299999999999899,9.6241915773488479E-2,8.1870875472157281E-2,7.3460730346306694E-2,8.1870875472157295E-2]
[null,null,null,2.8399999999999901,9.5660873394735946E-2,8.1269988275103788E-2,7.2861609584821019E-2,8.1269988275103844E-2]
[null,null,null,2.8499999999999899,9.5083619573494829E-2,8.0674557247582449E-2,7.2268788929429395E-2,8.0674557247582504E-2]
[null,null,null,2.8599999999999901,9.4510126646591641E-2,8.0084523376701189E-2,7.1682189552771336E-2,8.0084523376701175E-2]
[null,null,null,2.8699999999999899,9.3940367188888749E-2,7.9499828383762947E-2,7.1101733731169403E-2,7.9499828383762974E-2]
[null,null,null,2.8799999999999901,9.3374314010733969E-2,7.8920414714139284E-2,7.0527344828450925E-2,7.8920414714139325E-2]
[null,null,null,2.8899999999999899,9.2811940155446235E-2,7.8346225527290383E-2,6.9958947279990052E-2,7.8346225527290439E-2]
[null,null,null,2.8999999999999901,9.225321889683509E-2,7.7777204686931015E-2,6.9396466576968296E-2,7.7777204686931029E-2]
[null,null,null,2.9099999999999899,9.1698123736754428E-2,7.7213296751339852E-2,6.8839829250852275E-2,7.7213296751339797E-2]
[null,null,null,2.9199999999999902,9.1146628402689112E-2,7.6654446963809519E-2,6.8288962858086E-2,7.6654446963809519E-2]
[null,null,null,2.9299999999999899,9.0598706845375132E-2,7.6100601243237212E-2,6.7743795964997022E-2,7.610060124323724E-2]
[null,null,null,2.9399999999999902,9.0054333236450748E-2,7.5551706174851088E-2,6.7204258132913364E-2,7.5551706174851088E-2]
[null,null,null,2.94999999999999,8.9513481966140493E-2,7.5007709001073106E-2,6.6670279903490365E-2,7.5007709001073078E-2]
[null,null,null,2.9599999999999902,8.8976127640969099E-2,7.4468557612514766E-2,6.6141792784244521E-2,7.4468557612514738E-2]
[null,null,null,2.96999999999999,8.8442245081506818E-2,7.3934200539104836E-2,6.5618729234293308E-2,7.3934200539104863E-2]
[null,null,null,2.9799999999999902,8.7911809320144377E-2,7.3404586941346342E-2,6.5101022650297644E-2,7.3404586941346384E-2]
[null,null,null,2.98999999999999,8.7384795598897391E-2,7.287966660170131E-2,6.4588607352606492E-2,7.287966660170131E-2]
[null,null,null,2.9999999999999898,8.6861179367239985E-2,7.2359389916101288E-2,6.4081418571599907E-2,7.2359389916101288E-2]

{"sheet":"MLE","index":4,"n_rows":22,"n_cols":6,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,1,0,2],[0,4,0,5]]}
[null,"Log normal",null,null,"Weibull"]
[null,"Log(x)","(Log(x) - muhat)^2",null,"x^beta","x^beta * log(x)"]
[50,{"$f":"LN(A3)","v":3.912023005428146},{"$f":"(B3-$B$14)^2","v":0.18329949832820494},null,{"$f":"A3^MLEbeta","v":32.655739127967706},{"$f":"E3*B3","v":127.75000272786973}]
[30,3.4011973816621555,6.8377546902035199E-3,null,20.714246394408732,{"$f":"E4*B4","v":70.453240599767724}]
[300,5.7037824746562009,4.9279310402416838,null,161.20312713438739,919.46757140889429]
[20,2.9957322735539909,0.23829610965922812,null,14.43289510886693,43.2370896784522]
[10,2.3025850929940459,1.3954767913752169,null,7.782234702870972,17.919257617011649]
[15,2.7080502011022101,0.60192444340497786,null,11.169147001931119,30.246610784719714]
[25,3.2188758248682006,7.0231505300635738E-2,null,17.608014495542381,56.678012183630216]
[40,3.6888794541139363,4.202145577964142E-2,null,26.767177960683611,98.740892823777145]
[10,2.3025850929940459,1.3954767913752169,null,7.782234702870972,17.919257617011649]
[100,4.6051701859880918,1.2572735191921782,null,60.563176970569238,278.90373695358608]
[]
[null,{"$f":"SUM(B3:B12)/COUNT(B3:B12)","v":3.4838880987361023},{"$f":"SUM(C3:C12)/COUNT(C3:C12)","v":1.0118768909347189},null,{"$f":"SUM(E3:E12)","v":360.67799360009911},{"$f":"SUM(F3:F12)","v":1661.3156723947202}]
[null,"mu hat","sigma^2 hat"]
[null,null,{"$f":"SQRT(C14)","v":1.0059209168392509},null,"Objective",{"$f":"(1/MLEbeta)+B14-(F14/E14)","v":1.2532150428512523E-7}]
[null,null,"sigma hat",null,"beta",0.89110432446627008]
[null,null,null,null,"theta",{"$f":"(E14/COUNT(A3:A12))^(1/MLEbeta)","v":55.899050501001007}]
[]
[]
[]
[null,null," "]

{"sheet":"MCAtemplate","index":5,"n_rows":21,"n_cols":38,"rows_kept":21,"cut":false,"hidden":false,"merged":[[0,34,0,37],[0,10,0,15],[0,18,0,23],[0,26,0,31],[3,0,12,0],[0,2,0,7]]}
[null,null,"Economic",null,null,null,null,null,"Weight",100,"Environmental",null,null,null,null,null,"Weight",100,"Social",null,null,null,null,null,"Weight",100,"Co-Benefits",null,null,null,null,null,"Weight",100,"Final"]
[null,null,"Expert 1","Expert 2","Expert 3","Expert 4","Expert 5","Expert 6","Score","Rank","Expert 1","Expert 2","Expert 3","Expert 4","Expert 5","Expert 6","Score","Rank","Expert 1","Expert 2","Expert 3","Expert 4","Expert 5","Expert 6","Score","Rank","Expert 1","Expert 2","Expert 3","Expert 4","Expert 5","Expert 6","Score","Rank","Score","Rank","Borda votes","Borda rank"]
[null,"Weight",100,100,100,100,100,100,null,null,100,100,100,100,100,100,null,null,100,100,100,100,100,100,null,null,100,100,100,100,100,100]
["Options","Project 1",null,null,null,null,null,null,{"$f":"IF(COUNT(C4:H4)>0,C4*(C$3/Expert1SumWeight)+D4*(D$3/Expert2SumWeight)+E4*(E$3/Expert3SumWeight)+F4*(F$3/Expert4SumWeight)+G4*(G$3/Expert5SumWeight)+H4*(H$3/Expert6SumWeight), \"\")","v":""},{"$f":"IF(ISNUMBER(I4), RANK(I4,I$4:I$13), \"\")","v":""},null,null,null,null,null,null,{"$f":"IF(COUNT(K4:P4)>0,K4*(K$3/Expert1SumWeight)+L4*(L$3/Expert2SumWeight)+M4*(M$3/Expert3SumWeight)+N4*(N$3/Expert4SumWeight)+O4*(O$3/Expert5SumWeight)+P4*(P$3/Expert6SumWeight), \"\")","v":""},{"$f":"IF(ISNUMBER(Q4), RANK(Q4,Q$4:Q$13), \"\")","v":""},null,null,null,null,null,null,{"$f":"IF(COUNT(S4:X4)>0,S4*(S$3/Expert1SumWeight)+T4*(T$3/Expert2SumWeight)+U4*(U$3/Expert3SumWeight)+V4*(V$3/Expert4SumWeight)+W4*(W$3/Expert5SumWeight)+X4*(X$3/Expert6SumWeight), \"\")","v":""},{"$f":"IF(ISNUMBER(Y4), RANK(Y4,Y$4:Y$13), \"\")","v":""},null,null,null,null,null,null,{"$f":"IF(COUNT(AA4:AF4)>0,AA4*(AA$3/Expert1SumWeight)+AB4*(AB$3/Expert2SumWeight)+AC4*(AC$3/Expert3SumWeight)+AD4*(AD$3/Expert4SumWeight)+AE4*(AE$3/Expert5SumWeight)+AF4*(AF$3/Expert6SumWeight), \"\")","v":""},{"$f":"IF(ISNUMBER(AG4), RANK(AG4,AG$4:AG$13), \"\")","v":""},{"$f":"IF(OR(ISNUMBER(I4),ISNUMBER(Q4),ISNUMBER(Y4),ISNUMBER(AG4)), IF(ISNUMBER(I4),I4*J$1/$AI$19,0) +IF(ISNUMBER(Q4),Q4*R$1/$AI$19,0)+IF(ISNUMBER(Y4),Y4*Z$1/$AI$19,0)+IF(ISNUMBER(AG4),AG4*AH$1/$AI$19,0), \"\")","v":""},{"$f":"IF(ISNUMBER(AI4), RANK(AI4,AI$4:AI$13), \"\")","v":""},{"$f":"IF(AND(ISNUMBER(J4),ISNUMBER(R4),ISNUMBER(Z4),ISNUMBER(AH4)),(NumOpts-J4)*J$1/$AI$19+(NumOpts-R4)*R$1/$AI$19+(NumOpts-Z4)*Z$1/$AI$19+(NumOpts-AH4)*AH$1/$AI$19,\"\")","v":""},{"$f":"IF(ISNUMBER(AK4), RANK(AK4,AK$4:AK$13), \"\")","v":""}]
[null,"Project 2",null,null,null,null,null,null,"",{"$f":"IF(ISNUMBER(I5), RANK(I5,I$4:I$13), \"\")","v":""},null,null,null,null,null,null,"",{"$f":"IF(ISNUMBER(Q5), RANK(Q5,Q$4:Q$13), \"\")","v":""},null,null,null,null,null,null,"",{"$f":"IF(ISNUMBER(Y5), RANK(Y5,Y$4:Y$13), \"\")","v":""},null,null,null,null,null,null,"",{"$f":"IF(ISNUMBER(AG5), RANK(AG5,AG$4:AG$13), \"\")","v":""},{"$f":"IF(OR(ISNUMBER(I5),ISNUMBER(Q5),ISNUMBER(Y5),ISNUMBER(AG5)), IF(ISNUMBER(I5),I5*J$1/$AI$19,0) +IF(ISNUMBER(Q5),Q5*R$1/$AI$19,0)+IF(ISNUMBER(Y5),Y5*Z$1/$AI$19,0)+IF(ISNUMBER(AG5),AG5*AH$1/$AI$19,0), \"\")","v":""},{"$f":"IF(ISNUMBER(AI5), RANK(AI5,AI$4:AI$13), \"\")","v":""},"",{"$f":"IF(ISNUMBER(AK5), RANK(AK5,AK$4:AK$13), \"\")","v":""}]
[null,"Project 3",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,"Project 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,"Project 5",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,"Project 6",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,"Project 7",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,"Project 8",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,"Project 9",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,"Project 10",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,"Everything below this line is used for internal calculations and should not be changed."]
[]
[null,null,"Expert Weight Sums",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 Weight",null,"Num Opts"]
[null,null,"Expert 1","Expert 2","Expert 3","Expert 4","Expert 5","Expert 6",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":"SUM(J1,R1,Z1,AH1)","v":400},null,{"$f":"COUNTA(B4:B13)","v":10}]
[null,null,{"$f":"IF(SUM(C3,K3,S3,AA3)=0,1,SUM(C3,K3,S3,AA3))","v":400},{"$f":"IF(SUM(D3,L3,T3,AB3)=0,1,SUM(D3,L3,T3,AB3))","v":400},400,400,400,400]
[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,"Temp ->","IF(OR(ISNUMBER(I21),ISNUMBER(Q21),ISNUMBER(Y21),ISNUMBER(AG21)), I21*J$1/$AI$19 +Q21*R$1/$AI$19+Y21*Z$1/$AI$19+AG21*AH$1/$AI$19, \"\")"]

{"sheet":"MCAexpert","index":6,"n_rows":12,"n_cols":10,"rows_kept":12,"cut":false,"hidden":false,"merged":[[2,0,11,0],[0,2,0,3],[0,4,0,5],[0,6,0,7],[0,8,0,9]]}
[null,null,"Economic",null,"Enviromental",null,"Social",null,"Co-Benefit"]
[null,"Expertise",100,"Comment",100,"Comment",100,"Comment",100,"Comment"]
["Options","Option 1"]
[null,"Option 2"]
[null,"Option 3"]
[null,"Option 4"]
[null,"Option 5"]
[null,"Option 6"]
[null,"Option 7"]
[null,"Option 8"]
[null,"Option 9"]
[null,"Option 10"]

{"sheet":"MCAuserexpert","index":7,"n_rows":12,"n_cols":52,"rows_kept":12,"cut":false,"hidden":false,"merged":[[2,0,11,0],[0,34,0,35],[0,12,0,13],[0,14,0,15],[0,16,0,17],[0,18,0,19],[0,20,0,21],[0,22,0,23],[0,24,0,25],[0,26,0,27],[0,28,0,29],[0,30,0,31],[0,32,0,33],[0,10,0,11],[0,2,0,3],[0,4,0,5],[0,6,0,7],[0,8,0,9],[0,48,0,49],[0,50,0,51],[0,36,0,37],[0,38,0,39],[0,40,0,41],[0,42,0,43],[0,44,0,45],[0,46,0,47]]}
[null,null,"Criterion 1",null,"Criterion 2",null,"Criterion 3",null,"Criterion 4",null,"Criterion 5",null,"Criterion 6",null,"Criterion 7",null,"Criterion 8",null,"Criterion 9",null,"Criterion 10",null,"Criterion 11",null,"Criterion 12",null,"Criterion 13",null,"Criterion 14",null,"Criterion 15",null,"Criterion 16",null,"Criterion 17",null,"Criterion 18",null,"Criterion 19",null,"Criterion 20",null,"Criterion 21",null,"Criterion 22",null,"Criterion 23",null,"Criterion 24",null,"Criterion 25"]
[null,"Expertise",100,"Comment",100,"Comment",100,"Comment",100,"Comment",100,"Comment",100,"Comment",100,"Comment",100,"Comment",100,"Comment",100,"Comment",100,"Comment",100,"Comment",100,"Comment",100,"Comment",100,"Comment",100,"Comment",100,"Comment",100,"Comment",100,"Comment",100,"Comment",100,"Comment",100,"Comment",100,"Comment",100,"Comment",100,"Comment"]
["Options","Option 1"]
[null,"Option 2"]
[null,"Option 3"]
[null,"Option 4"]
[null,"Option 5"]
[null,"Option 6"]
[null,"Option 7"]
[null,"Option 8"]
[null,"Option 9"]
[null,"Option 10"]

{"sheet":"MCAsummary","index":8,"n_rows":22,"n_cols":26,"rows_kept":22,"cut":false,"hidden":false,"merged":[[4,8,4,9],[6,0,15,0],[4,2,4,3],[4,4,4,5],[4,6,4,7]]}
[null,null,null,null,null,null,null,null,null,null,null,null,"Weight",null,"Weight",null,"Weight",null,"Weight",null,"Weight",null,"Weight",null,"Weight"]
[null,null,null,null,null,null,null,null,null,null,null,"Economic",100]
[null,null,null,null,null,null,null,null,null,null,null,"Environmental",100]
[null,null,null,null,null,null,null,null,null,null,null,"Social",100]
[null,null,"Economic",null,"Environmental",null,"Social",null,"Co-Benefit",null,null,"Co-Benefit",100]
[null,null,"Score","Rank","Score","Rank","Score","Rank","Score","Rank",null,null,"Score","Rank","Score","Rank","Score","Rank","Score","Rank","Score","Rank","Score","Rank","Score","Rank"]
["Options","Option 1",null,{"$f":"IF(ISNUMBER(C7), RANK(C7,C$7:C$16), \"\")","v":""},null,{"$f":"IF(ISNUMBER(E7), RANK(E7,E$7:E$16), \"\")","v":""},null,{"$f":"IF(ISNUMBER(G7), RANK(G7,G$7:G$16), \"\")","v":""},null,{"$f":"IF(ISNUMBER(I7), RANK(I7,I$7:I$16), \"\")","v":""},null,null,{"$f":"IF(AND(M$21,OR(ISNUMBER($C7),ISNUMBER($E7),ISNUMBER($G7),ISNUMBER($I7))), IF(ISNUMBER($C7),$C7*M$2/M$19,0) +IF(ISNUMBER($E7),$E7*M$3/M$19,0)+IF(ISNUMBER($G7),$G7*M$4/M$19,0)+IF(ISNUMBER($I7),$I7*M$5/M$19,0), \"\")","v":""},{"$f":"IF(ISNUMBER(M7), RANK(M7,M$7:M$16), \"\")","v":""},{"$f":"IF(AND(O$21,OR(ISNUMBER($C7),ISNUMBER($E7),ISNUMBER($G7),ISNUMBER($I7))), IF(ISNUMBER($C7),$C7*O$2/O$19,0) +IF(ISNUMBER($E7),$E7*O$3/O$19,0)+IF(ISNUMBER($G7),$G7*O$4/O$19,0)+IF(ISNUMBER($I7),$I7*O$5/O$19,0), \"\")","v":""},{"$f":"IF(ISNUMBER(O7), RANK(O7,O$7:O$16), \"\")","v":""},{"$f":"IF(AND(Q$21,OR(ISNUMBER($C7),ISNUMBER($E7),ISNUMBER($G7),ISNUMBER($I7))), IF(ISNUMBER($C7),$C7*Q$2/Q$19,0) +IF(ISNUMBER($E7),$E7*Q$3/Q$19,0)+IF(ISNUMBER($G7),$G7*Q$4/Q$19,0)+IF(ISNUMBER($I7),$I7*Q$5/Q$19,0), \"\")","v":""},{"$f":"IF(ISNUMBER(Q7), RANK(Q7,Q$7:Q$16), \"\")","v":""},{"$f":"IF(AND(S$21,OR(ISNUMBER($C7),ISNUMBER($E7),ISNUMBER($G7),ISNUMBER($I7))), IF(ISNUMBER($C7),$C7*S$2/S$19,0) +IF(ISNUMBER($E7),$E7*S$3/S$19,0)+IF(ISNUMBER($G7),$G7*S$4/S$19,0)+IF(ISNUMBER($I7),$I7*S$5/S$19,0), \"\")","v":""},{"$f":"IF(ISNUMBER(S7), RANK(S7,S$7:S$16), \"\")","v":""},{"$f":"IF(AND(U$21,OR(ISNUMBER($C7),ISNUMBER($E7),ISNUMBER($G7),ISNUMBER($I7))), IF(ISNUMBER($C7),$C7*U$2/U$19,0) +IF(ISNUMBER($E7),$E7*U$3/U$19,0)+IF(ISNUMBER($G7),$G7*U$4/U$19,0)+IF(ISNUMBER($I7),$I7*U$5/U$19,0), \"\")","v":""},{"$f":"IF(ISNUMBER(U7), RANK(U7,U$7:U$16), \"\")","v":""},{"$f":"IF(AND(W$21,OR(ISNUMBER($C7),ISNUMBER($E7),ISNUMBER($G7),ISNUMBER($I7))), IF(ISNUMBER($C7),$C7*W$2/W$19,0) +IF(ISNUMBER($E7),$E7*W$3/W$19,0)+IF(ISNUMBER($G7),$G7*W$4/W$19,0)+IF(ISNUMBER($I7),$I7*W$5/W$19,0), \"\")","v":""},{"$f":"IF(ISNUMBER(W7), RANK(W7,W$7:W$16), \"\")","v":""},{"$f":"IF(AND(Y$21,OR(ISNUMBER($C7),ISNUMBER($E7),ISNUMBER($G7),ISNUMBER($I7))), IF(ISNUMBER($C7),$C7*Y$2/Y$19,0) +IF(ISNUMBER($E7),$E7*Y$3/Y$19,0)+IF(ISNUMBER($G7),$G7*Y$4/Y$19,0)+IF(ISNUMBER($I7),$I7*Y$5/Y$19,0), \"\")","v":""},{"$f":"IF(ISNUMBER(Y7), RANK(Y7,Y$7:Y$16), \"\")","v":""}]
[null,"Option 2",null,{"$f":"IF(ISNUMBER(C8), RANK(C8,C$7:C$16), \"\")","v":""},null,"",null,{"$f":"IF(ISNUMBER(G8), RANK(G8,G$7:G$16), \"\")","v":""},null,{"$f":"IF(ISNUMBER(I8), RANK(I8,I$7:I$16), \"\")","v":""},null,null,{"$f":"IF(AND(M$21,OR(ISNUMBER($C8),ISNUMBER($E8),ISNUMBER($G8),ISNUMBER($I8))), IF(ISNUMBER($C8),$C8*M$2/M$19,0) +IF(ISNUMBER($E8),$E8*M$3/M$19,0)+IF(ISNUMBER($G8),$G8*M$4/M$19,0)+IF(ISNUMBER($I8),$I8*M$5/M$19,0), \"\")","v":""},{"$f":"IF(ISNUMBER(M8), RANK(M8,M$7:M$16), \"\")","v":""},"","","",{"$f":"IF(ISNUMBER(Q8), RANK(Q8,Q$7:Q$16), \"\")","v":""},"",{"$f":"IF(ISNUMBER(S8), RANK(S8,S$7:S$16), \"\")","v":""},"",{"$f":"IF(ISNUMBER(U8), RANK(U8,U$7:U$16), \"\")","v":""},"",{"$f":"IF(ISNUMBER(W8), RANK(W8,W$7:W$16), \"\")","v":""},"",{"$f":"IF(ISNUMBER(Y8), RANK(Y8,Y$7:Y$16), \"\")","v":""}]
[null,"Option 3",null,"",null,"",null,{"$f":"IF(ISNUMBER(G9), RANK(G9,G$7:G$16), \"\")","v":""},null,{"$f":"IF(ISNUMBER(I9), RANK(I9,I$7:I$16), \"\")","v":""},null,null,"","","","","",{"$f":"IF(ISNUMBER(Q9), RANK(Q9,Q$7:Q$16), \"\")","v":""},"",{"$f":"IF(ISNUMBER(S9), RANK(S9,S$7:S$16), \"\")","v":""},"",{"$f":"IF(ISNUMBER(U9), RANK(U9,U$7:U$16), \"\")","v":""},"",{"$f":"IF(ISNUMBER(W9), RANK(W9,W$7:W$16), \"\")","v":""},"",{"$f":"IF(ISNUMBER(Y9), RANK(Y9,Y$7:Y$16), \"\")","v":""}]
[null,"Option 4",null,"",null,"",null,{"$f":"IF(ISNUMBER(G10), RANK(G10,G$7:G$16), \"\")","v":""},null,{"$f":"IF(ISNUMBER(I10), RANK(I10,I$7:I$16), \"\")","v":""},null,null,"","","","","",{"$f":"IF(ISNUMBER(Q10), RANK(Q10,Q$7:Q$16), \"\")","v":""},"",{"$f":"IF(ISNUMBER(S10), RANK(S10,S$7:S$16), \"\")","v":""},"",{"$f":"IF(ISNUMBER(U10), RANK(U10,U$7:U$16), \"\")","v":""},"",{"$f":"IF(ISNUMBER(W10), RANK(W10,W$7:W$16), \"\")","v":""},"",{"$f":"IF(ISNUMBER(Y10), RANK(Y10,Y$7:Y$16), \"\")","v":""}]
[null,"Option 5",null,"",null,"",null,{"$f":"IF(ISNUMBER(G11), RANK(G11,G$7:G$16), \"\")","v":""},null,{"$f":"IF(ISNUMBER(I11), RANK(I11,I$7:I$16), \"\")","v":""},null,null,"","","","","",{"$f":"IF(ISNUMBER(Q11), RANK(Q11,Q$7:Q$16), \"\")","v":""},"",{"$f":"IF(ISNUMBER(S11), RANK(S11,S$7:S$16), \"\")","v":""},"",{"$f":"IF(ISNUMBER(U11), RANK(U11,U$7:U$16), \"\")","v":""},"",{"$f":"IF(ISNUMBER(W11), RANK(W11,W$7:W$16), \"\")","v":""},"",{"$f":"IF(ISNUMBER(Y11), RANK(Y11,Y$7:Y$16), \"\")","v":""}]
[null,"Option 6",null,"",null,"",null,{"$f":"IF(ISNUMBER(G12), RANK(G12,G$7:G$16), \"\")","v":""},null,{"$f":"IF(ISNUMBER(I12), RANK(I12,I$7:I$16), \"\")","v":""},null,null,"","","","","",{"$f":"IF(ISNUMBER(Q12), RANK(Q12,Q$7:Q$16), \"\")","v":""},"",{"$f":"IF(ISNUMBER(S12), RANK(S12,S$7:S$16), \"\")","v":""},"",{"$f":"IF(ISNUMBER(U12), RANK(U12,U$7:U$16), \"\")","v":""},"",{"$f":"IF(ISNUMBER(W12), RANK(W12,W$7:W$16), \"\")","v":""},"",{"$f":"IF(ISNUMBER(Y12), RANK(Y12,Y$7:Y$16), \"\")","v":""}]
[null,"Option 7",null,"",null,"",null,{"$f":"IF(ISNUMBER(G13), RANK(G13,G$7:G$16), \"\")","v":""},null,{"$f":"IF(ISNUMBER(I13), RANK(I13,I$7:I$16), \"\")","v":""},null,null,"","","","","",{"$f":"IF(ISNUMBER(Q13), RANK(Q13,Q$7:Q$16), \"\")","v":""},"",{"$f":"IF(ISNUMBER(S13), RANK(S13,S$7:S$16), \"\")","v":""},"",{"$f":"IF(ISNUMBER(U13), RANK(U13,U$7:U$16), \"\")","v":""},"",{"$f":"IF(ISNUMBER(W13), RANK(W13,W$7:W$16), \"\")","v":""},"",{"$f":"IF(ISNUMBER(Y13), RANK(Y13,Y$7:Y$16), \"\")","v":""}]
[null,"Option 8",null,"",null,"",null,{"$f":"IF(ISNUMBER(G14), RANK(G14,G$7:G$16), \"\")","v":""},null,{"$f":"IF(ISNUMBER(I14), RANK(I14,I$7:I$16), \"\")","v":""},null,null,"","","","","",{"$f":"IF(ISNUMBER(Q14), RANK(Q14,Q$7:Q$16), \"\")","v":""},"",{"$f":"IF(ISNUMBER(S14), RANK(S14,S$7:S$16), \"\")","v":""},"",{"$f":"IF(ISNUMBER(U14), RANK(U14,U$7:U$16), \"\")","v":""},"",{"$f":"IF(ISNUMBER(W14), RANK(W14,W$7:W$16), \"\")","v":""},"",{"$f":"IF(ISNUMBER(Y14), RANK(Y14,Y$7:Y$16), \"\")","v":""}]
[null,"Option 9",null,"",null,"",null,{"$f":"IF(ISNUMBER(G15), RANK(G15,G$7:G$16), \"\")","v":""},null,{"$f":"IF(ISNUMBER(I15), RANK(I15,I$7:I$16), \"\")","v":""},null,null,"","","","","",{"$f":"IF(ISNUMBER(Q15), RANK(Q15,Q$7:Q$16), \"\")","v":""},"",{"$f":"IF(ISNUMBER(S15), RANK(S15,S$7:S$16), \"\")","v":""},"",{"$f":"IF(ISNUMBER(U15), RANK(U15,U$7:U$16), \"\")","v":""},"",{"$f":"IF(ISNUMBER(W15), RANK(W15,W$7:W$16), \"\")","v":""},"",{"$f":"IF(ISNUMBER(Y15), RANK(Y15,Y$7:Y$16), \"\")","v":""}]
[null,"Option 10",null,"",null,"",null,{"$f":"IF(ISNUMBER(G16), RANK(G16,G$7:G$16), \"\")","v":""},null,{"$f":"IF(ISNUMBER(I16), RANK(I16,I$7:I$16), \"\")","v":""},null,null,"","","","","",{"$f":"IF(ISNUMBER(Q16), RANK(Q16,Q$7:Q$16), \"\")","v":""},"",{"$f":"IF(ISNUMBER(S16), RANK(S16,S$7:S$16), \"\")","v":""},"",{"$f":"IF(ISNUMBER(U16), RANK(U16,U$7:U$16), \"\")","v":""},"",{"$f":"IF(ISNUMBER(W16), RANK(W16,W$7:W$16), \"\")","v":""},"",{"$f":"IF(ISNUMBER(Y16), RANK(Y16,Y$7:Y$16), \"\")","v":""}]
[]
[null,null,"Everything below this line is used for internal calculations and should not be changed.",null,null,null,null,null,null,null,null,null,"Sum",null,"Sum",null,"Sum",null,"Sum",null,"Sum",null,"Sum",null,"Sum"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M2:M5)","v":400},null,{"$f":"SUM(O2:O5)","v":0},null,{"$f":"SUM(Q2:Q5)","v":0},null,{"$f":"SUM(S2:S5)","v":0},null,{"$f":"SUM(U2:U5)","v":0},null,{"$f":"SUM(W2:W5)","v":0},null,{"$f":"SUM(Y2:Y5)","v":0}]
[null,null,"Expert 1","Expert 2","Expert 3","Expert 4","Expert 5","Expert 6",null,"Expert Sum",null,null,"Is Number",null,"Is Number",null,"Is Number",null,"Is Number",null,"Is Number",null,"Is Number",null,"Is Number"]
[null,null,1,1,1,1,1,1,null,{"$f":"SUM(C3:H3)","v":0},null,null,{"$f":"AND(ISNUMBER(M2),ISNUMBER(M3),ISNUMBER(M4),ISNUMBER(M5))","v":true},null,{"$f":"AND(ISNUMBER(O2),ISNUMBER(O3),ISNUMBER(O4),ISNUMBER(O5))","v":false},null,{"$f":"AND(ISNUMBER(Q2),ISNUMBER(Q3),ISNUMBER(Q4),ISNUMBER(Q5))","v":false},null,{"$f":"AND(ISNUMBER(S2),ISNUMBER(S3),ISNUMBER(S4),ISNUMBER(S5))","v":false},null,{"$f":"AND(ISNUMBER(U2),ISNUMBER(U3),ISNUMBER(U4),ISNUMBER(U5))","v":false},null,{"$f":"AND(ISNUMBER(W2),ISNUMBER(W3),ISNUMBER(W4),ISNUMBER(W5))","v":false},null,{"$f":"AND(ISNUMBER(Y2),ISNUMBER(Y3),ISNUMBER(Y4),ISNUMBER(Y5))","v":false}]
[null,null,"Total Economic Weight",null,"Total Environmental Weight",null,"Total Social Weight",null,"Total Co-Benefit Weight"]

{"sheet":"MCAuserscores","index":9,"n_rows":18,"n_cols":52,"rows_kept":18,"cut":false,"hidden":false,"merged":[[2,0,11,0],[0,34,0,35],[0,12,0,13],[0,14,0,15],[0,16,0,17],[0,18,0,19],[0,20,0,21],[0,22,0,23],[0,24,0,25],[0,26,0,27],[0,28,0,29],[0,30,0,31],[0,32,0,33],[0,10,0,11],[0,2,0,3],[0,4,0,5],[0,6,0,7],[0,8,0,9],[0,48,0,49],[0,50,0,51],[0,36,0,37],[0,38,0,39],[0,40,0,41],[0,42,0,43],[0,44,0,45],[0,46,0,47]]}
[null,null,"Criterion 1",null,"Criterion 2",null,"Criterion 3",null,"Criterion 4",null,"Criterion 5",null,"Criterion 6",null,"Criterion 7",null,"Criterion 8",null,"Criterion 9",null,"Criterion 10",null,"Criterion 11",null,"Criterion 12",null,"Criterion 13",null,"Criterion 14",null,"Criterion 15",null,"Criterion 16",null,"Criterion 17",null,"Criterion 18",null,"Criterion 19",null,"Criterion 20",null,"Criterion 21",null,"Criterion 22",null,"Criterion 23",null,"Criterion 24",null,"Criterion 25"]
[null,null,"Score","Rank","Score","Rank","Score","Rank","Score","Rank","Score","Rank","Score","Rank","Score","Rank","Score","Rank","Score","Rank","Score","Rank","Score","Rank","Score","Rank","Score","Rank","Score","Rank","Score","Rank","Score","Rank","Score","Rank","Score","Rank","Score","Rank","Score","Rank","Score","Rank","Score","Rank","Score","Rank","Score","Rank","Score","Rank"]
["Options","Option 1",null,{"$f":"IF(ISNUMBER(C3), RANK(C3,C$3:C$12), \"\")","v":""},null,{"$f":"IF(ISNUMBER(E3), RANK(E3,E$3:E$12), \"\")","v":""},null,{"$f":"IF(ISNUMBER(G3), RANK(G3,G$3:G$12), \"\")","v":""},null,{"$f":"IF(ISNUMBER(I3), RANK(I3,I$3:I$12), \"\")","v":""}]
[null,"Option 2",null,{"$f":"IF(ISNUMBER(C4), RANK(C4,C$3:C$12), \"\")","v":""},null,"",null,{"$f":"IF(ISNUMBER(G4), RANK(G4,G$3:G$12), \"\")","v":""},null,{"$f":"IF(ISNUMBER(I4), RANK(I4,I$3:I$12), \"\")","v":""}]
[null,"Option 3",null,"",null,"",null,"",null,""]
[null,"Option 4",null,"",null,"",null,"",null,""]
[null,"Option 5",null,"",null,"",null,"",null,""]
[null,"Option 6",null,"",null,"",null,"",null,""]
[null,"Option 7",null,"",null,"",null,"",null,""]
[null,"Option 8",null,"",null,"",null,"",null,""]
[null,"Option 9",null,"",null,"",null,"",null,""]
[null,"Option 10",null,"",null,"",null,"",null,""]
[]
[null,null,"Everything below this line is used for internal calculations and should not be changed."]
[]
[null,null,"Expert 1","Expert 2","Expert 3","Expert 4","Expert 5","Expert 6",null,"Expert Sum"]
[null,null,1,1,1,1,1,1,null,1]
[null,null,"Total Crit 1 Weight",null,"Total Crit 2 Weight",null,"Total Crit 3 Weight",null,"Total Crit 4 Weight",null,"Total Crit 5 Weight",null,"Total Crit 6 Weight",null,"Total Crit 7 Weight",null,"Total Crit 8 Weight",null,"Total Crit 9 Weight",null,"Total Crit 10 Weight",null,"Total Crit 11 Weight",null,"Total Crit 12 Weight",null,"Total Crit 13 Weight",null,"Total Crit 14 Weight",null,"Total Crit 15 Weight",null,"Total Crit 16 Weight",null,"Total Crit 17 Weight",null,"Total Crit 18 Weight",null,"Total Crit 19 Weight",null,"Total Crit 20 Weight",null,"Total Crit 21 Weight",null,"Total Crit 22 Weight",null,"Total Crit 23 Weight",null,"Total Crit 24 Weight",null,"Total Crit 25 Weight"]

{"sheet":"MCAusersensitivity","index":10,"n_rows":42,"n_cols":16,"rows_kept":42,"cut":false,"hidden":false,"merged":[[27,0,36,0],[1,0,25,0]]}
[null,null,"Weight",null,"Weight",null,"Weight",null,"Weight",null,"Weight",null,"Weight",null,"Weight"]
["Criteria","Criterion 1",100]
[null,"Criterion 2",100]
[null,"Criterion 3",100]
[null,"Criterion 4",100]
[null,"Criterion 5",100]
[null,"Criterion 6",100]
[null,"Criterion 7",100]
[null,"Criterion 8",100]
[null,"Criterion 9",100]
[null,"Criterion 10",100]
[null,"Criterion 11",100]
[null,"Criterion 12",100]
[null,"Criterion 13",100]
[null,"Criterion 14",100]
[null,"Criterion 15",100]
[null,"Criterion 16",100]
[null,"Criterion 17",100]
[null,"Criterion 18",100]
[null,"Criterion 19",100]
[null,"Criterion 20",100]
[null,"Criterion 21",100]
[null,"Criterion 22",100]
[null,"Criterion 23",100]
[null,"Criterion 24",100]
[null,"Criterion 25",100]
[null,null,"Score","Rank","Score","Rank","Score","Rank","Score","Rank","Score","Rank","Score","Rank","Score","Rank"]
["Options","Option 1",{"$f":"IF(AND(C$42,OR(ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!))), IF(ISNUMBER(#REF!),#REF!*C$2/C$40,0) +IF(ISNUMBER(#REF!),#REF!*C$3/C$40,0)+IF(ISNUMBER(#REF!),#REF!*C$4/C$40,0)+IF(ISNUMBER(#REF!),#REF!*C$26/C$40,0), \"\")","v":""},{"$f":"IF(ISNUMBER(C28), RANK(C28,C$28:C$37), \"\")","v":""},{"$f":"IF(AND(E$42,OR(ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!))), IF(ISNUMBER(#REF!),#REF!*E$2/E$40,0) +IF(ISNUMBER(#REF!),#REF!*E$3/E$40,0)+IF(ISNUMBER(#REF!),#REF!*E$4/E$40,0)+IF(ISNUMBER(#REF!),#REF!*E$26/E$40,0), \"\")","v":""},{"$f":"IF(ISNUMBER(E28), RANK(E28,E$28:E$37), \"\")","v":""},{"$f":"IF(AND(G$42,OR(ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!))), IF(ISNUMBER(#REF!),#REF!*G$2/G$40,0) +IF(ISNUMBER(#REF!),#REF!*G$3/G$40,0)+IF(ISNUMBER(#REF!),#REF!*G$4/G$40,0)+IF(ISNUMBER(#REF!),#REF!*G$26/G$40,0), \"\")","v":""},{"$f":"IF(ISNUMBER(G28), RANK(G28,G$28:G$37), \"\")","v":""},{"$f":"IF(AND(I$42,OR(ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!))), IF(ISNUMBER(#REF!),#REF!*I$2/I$40,0) +IF(ISNUMBER(#REF!),#REF!*I$3/I$40,0)+IF(ISNUMBER(#REF!),#REF!*I$4/I$40,0)+IF(ISNUMBER(#REF!),#REF!*I$26/I$40,0), \"\")","v":""},{"$f":"IF(ISNUMBER(I28), RANK(I28,I$28:I$37), \"\")","v":""},{"$f":"IF(AND(K$42,OR(ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!))), IF(ISNUMBER(#REF!),#REF!*K$2/K$40,0) +IF(ISNUMBER(#REF!),#REF!*K$3/K$40,0)+IF(ISNUMBER(#REF!),#REF!*K$4/K$40,0)+IF(ISNUMBER(#REF!),#REF!*K$26/K$40,0), \"\")","v":""},{"$f":"IF(ISNUMBER(K28), RANK(K28,K$28:K$37), \"\")","v":""},{"$f":"IF(AND(M$42,OR(ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!))), IF(ISNUMBER(#REF!),#REF!*M$2/M$40,0) +IF(ISNUMBER(#REF!),#REF!*M$3/M$40,0)+IF(ISNUMBER(#REF!),#REF!*M$4/M$40,0)+IF(ISNUMBER(#REF!),#REF!*M$26/M$40,0), \"\")","v":""},{"$f":"IF(ISNUMBER(M28), RANK(M28,M$28:M$37), \"\")","v":""},{"$f":"IF(AND(O$42,OR(ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!))), IF(ISNUMBER(#REF!),#REF!*O$2/O$40,0) +IF(ISNUMBER(#REF!),#REF!*O$3/O$40,0)+IF(ISNUMBER(#REF!),#REF!*O$4/O$40,0)+IF(ISNUMBER(#REF!),#REF!*O$26/O$40,0), \"\")","v":""},{"$f":"IF(ISNUMBER(O28), RANK(O28,O$28:O$37), \"\")","v":""}]
[null,"Option 2",{"$f":"IF(AND(C$42,OR(ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!))), IF(ISNUMBER(#REF!),#REF!*C$2/C$40,0) +IF(ISNUMBER(#REF!),#REF!*C$3/C$40,0)+IF(ISNUMBER(#REF!),#REF!*C$4/C$40,0)+IF(ISNUMBER(#REF!),#REF!*C$26/C$40,0), \"\")","v":""},{"$f":"IF(ISNUMBER(C29), RANK(C29,C$28:C$37), \"\")","v":""},{"$f":"IF(AND(E$42,OR(ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!))), IF(ISNUMBER(#REF!),#REF!*E$2/E$40,0) +IF(ISNUMBER(#REF!),#REF!*E$3/E$40,0)+IF(ISNUMBER(#REF!),#REF!*E$4/E$40,0)+IF(ISNUMBER(#REF!),#REF!*E$26/E$40,0), \"\")","v":""},"",{"$f":"IF(AND(G$42,OR(ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!))), IF(ISNUMBER(#REF!),#REF!*G$2/G$40,0) +IF(ISNUMBER(#REF!),#REF!*G$3/G$40,0)+IF(ISNUMBER(#REF!),#REF!*G$4/G$40,0)+IF(ISNUMBER(#REF!),#REF!*G$26/G$40,0), \"\")","v":""},{"$f":"IF(ISNUMBER(G29), RANK(G29,G$28:G$37), \"\")","v":""},{"$f":"IF(AND(I$42,OR(ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!))), IF(ISNUMBER(#REF!),#REF!*I$2/I$40,0) +IF(ISNUMBER(#REF!),#REF!*I$3/I$40,0)+IF(ISNUMBER(#REF!),#REF!*I$4/I$40,0)+IF(ISNUMBER(#REF!),#REF!*I$26/I$40,0), \"\")","v":""},{"$f":"IF(ISNUMBER(I29), RANK(I29,I$28:I$37), \"\")","v":""},{"$f":"IF(AND(K$42,OR(ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!))), IF(ISNUMBER(#REF!),#REF!*K$2/K$40,0) +IF(ISNUMBER(#REF!),#REF!*K$3/K$40,0)+IF(ISNUMBER(#REF!),#REF!*K$4/K$40,0)+IF(ISNUMBER(#REF!),#REF!*K$26/K$40,0), \"\")","v":""},{"$f":"IF(ISNUMBER(K29), RANK(K29,K$28:K$37), \"\")","v":""},{"$f":"IF(AND(M$42,OR(ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!))), IF(ISNUMBER(#REF!),#REF!*M$2/M$40,0) +IF(ISNUMBER(#REF!),#REF!*M$3/M$40,0)+IF(ISNUMBER(#REF!),#REF!*M$4/M$40,0)+IF(ISNUMBER(#REF!),#REF!*M$26/M$40,0), \"\")","v":""},{"$f":"IF(ISNUMBER(M29), RANK(M29,M$28:M$37), \"\")","v":""},{"$f":"IF(AND(O$42,OR(ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!))), IF(ISNUMBER(#REF!),#REF!*O$2/O$40,0) +IF(ISNUMBER(#REF!),#REF!*O$3/O$40,0)+IF(ISNUMBER(#REF!),#REF!*O$4/O$40,0)+IF(ISNUMBER(#REF!),#REF!*O$26/O$40,0), \"\")","v":""},{"$f":"IF(ISNUMBER(O29), RANK(O29,O$28:O$37), \"\")","v":""}]
[null,"Option 3",{"$f":"IF(AND(C$42,OR(ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!))), IF(ISNUMBER(#REF!),#REF!*C$2/C$40,0) +IF(ISNUMBER(#REF!),#REF!*C$3/C$40,0)+IF(ISNUMBER(#REF!),#REF!*C$4/C$40,0)+IF(ISNUMBER(#REF!),#REF!*C$26/C$40,0), \"\")","v":""},"",{"$f":"IF(AND(E$42,OR(ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!))), IF(ISNUMBER(#REF!),#REF!*E$2/E$40,0) +IF(ISNUMBER(#REF!),#REF!*E$3/E$40,0)+IF(ISNUMBER(#REF!),#REF!*E$4/E$40,0)+IF(ISNUMBER(#REF!),#REF!*E$26/E$40,0), \"\")","v":""},"",{"$f":"IF(AND(G$42,OR(ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!))), IF(ISNUMBER(#REF!),#REF!*G$2/G$40,0) +IF(ISNUMBER(#REF!),#REF!*G$3/G$40,0)+IF(ISNUMBER(#REF!),#REF!*G$4/G$40,0)+IF(ISNUMBER(#REF!),#REF!*G$26/G$40,0), \"\")","v":""},"",{"$f":"IF(AND(I$42,OR(ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!))), IF(ISNUMBER(#REF!),#REF!*I$2/I$40,0) +IF(ISNUMBER(#REF!),#REF!*I$3/I$40,0)+IF(ISNUMBER(#REF!),#REF!*I$4/I$40,0)+IF(ISNUMBER(#REF!),#REF!*I$26/I$40,0), \"\")","v":""},"",{"$f":"IF(AND(K$42,OR(ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!))), IF(ISNUMBER(#REF!),#REF!*K$2/K$40,0) +IF(ISNUMBER(#REF!),#REF!*K$3/K$40,0)+IF(ISNUMBER(#REF!),#REF!*K$4/K$40,0)+IF(ISNUMBER(#REF!),#REF!*K$26/K$40,0), \"\")","v":""},"",{"$f":"IF(AND(M$42,OR(ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!))), IF(ISNUMBER(#REF!),#REF!*M$2/M$40,0) +IF(ISNUMBER(#REF!),#REF!*M$3/M$40,0)+IF(ISNUMBER(#REF!),#REF!*M$4/M$40,0)+IF(ISNUMBER(#REF!),#REF!*M$26/M$40,0), \"\")","v":""},"",{"$f":"IF(AND(O$42,OR(ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!))), IF(ISNUMBER(#REF!),#REF!*O$2/O$40,0) +IF(ISNUMBER(#REF!),#REF!*O$3/O$40,0)+IF(ISNUMBER(#REF!),#REF!*O$4/O$40,0)+IF(ISNUMBER(#REF!),#REF!*O$26/O$40,0), \"\")","v":""},""]
[null,"Option 4",{"$f":"IF(AND(C$42,OR(ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!))), IF(ISNUMBER(#REF!),#REF!*C$2/C$40,0) +IF(ISNUMBER(#REF!),#REF!*C$3/C$40,0)+IF(ISNUMBER(#REF!),#REF!*C$4/C$40,0)+IF(ISNUMBER(#REF!),#REF!*C$26/C$40,0), \"\")","v":""},"",{"$f":"IF(AND(E$42,OR(ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!))), IF(ISNUMBER(#REF!),#REF!*E$2/E$40,0) +IF(ISNUMBER(#REF!),#REF!*E$3/E$40,0)+IF(ISNUMBER(#REF!),#REF!*E$4/E$40,0)+IF(ISNUMBER(#REF!),#REF!*E$26/E$40,0), \"\")","v":""},"",{"$f":"IF(AND(G$42,OR(ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!))), IF(ISNUMBER(#REF!),#REF!*G$2/G$40,0) +IF(ISNUMBER(#REF!),#REF!*G$3/G$40,0)+IF(ISNUMBER(#REF!),#REF!*G$4/G$40,0)+IF(ISNUMBER(#REF!),#REF!*G$26/G$40,0), \"\")","v":""},"",{"$f":"IF(AND(I$42,OR(ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!))), IF(ISNUMBER(#REF!),#REF!*I$2/I$40,0) +IF(ISNUMBER(#REF!),#REF!*I$3/I$40,0)+IF(ISNUMBER(#REF!),#REF!*I$4/I$40,0)+IF(ISNUMBER(#REF!),#REF!*I$26/I$40,0), \"\")","v":""},"",{"$f":"IF(AND(K$42,OR(ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!))), IF(ISNUMBER(#REF!),#REF!*K$2/K$40,0) +IF(ISNUMBER(#REF!),#REF!*K$3/K$40,0)+IF(ISNUMBER(#REF!),#REF!*K$4/K$40,0)+IF(ISNUMBER(#REF!),#REF!*K$26/K$40,0), \"\")","v":""},"",{"$f":"IF(AND(M$42,OR(ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!))), IF(ISNUMBER(#REF!),#REF!*M$2/M$40,0) +IF(ISNUMBER(#REF!),#REF!*M$3/M$40,0)+IF(ISNUMBER(#REF!),#REF!*M$4/M$40,0)+IF(ISNUMBER(#REF!),#REF!*M$26/M$40,0), \"\")","v":""},"",{"$f":"IF(AND(O$42,OR(ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!))), IF(ISNUMBER(#REF!),#REF!*O$2/O$40,0) +IF(ISNUMBER(#REF!),#REF!*O$3/O$40,0)+IF(ISNUMBER(#REF!),#REF!*O$4/O$40,0)+IF(ISNUMBER(#REF!),#REF!*O$26/O$40,0), \"\")","v":""},""]
[null,"Option 5",{"$f":"IF(AND(C$42,OR(ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!))), IF(ISNUMBER(#REF!),#REF!*C$2/C$40,0) +IF(ISNUMBER(#REF!),#REF!*C$3/C$40,0)+IF(ISNUMBER(#REF!),#REF!*C$4/C$40,0)+IF(ISNUMBER(#REF!),#REF!*C$26/C$40,0), \"\")","v":""},"",{"$f":"IF(AND(E$42,OR(ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!))), IF(ISNUMBER(#REF!),#REF!*E$2/E$40,0) +IF(ISNUMBER(#REF!),#REF!*E$3/E$40,0)+IF(ISNUMBER(#REF!),#REF!*E$4/E$40,0)+IF(ISNUMBER(#REF!),#REF!*E$26/E$40,0), \"\")","v":""},"",{"$f":"IF(AND(G$42,OR(ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!))), IF(ISNUMBER(#REF!),#REF!*G$2/G$40,0) +IF(ISNUMBER(#REF!),#REF!*G$3/G$40,0)+IF(ISNUMBER(#REF!),#REF!*G$4/G$40,0)+IF(ISNUMBER(#REF!),#REF!*G$26/G$40,0), \"\")","v":""},"",{"$f":"IF(AND(I$42,OR(ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!))), IF(ISNUMBER(#REF!),#REF!*I$2/I$40,0) +IF(ISNUMBER(#REF!),#REF!*I$3/I$40,0)+IF(ISNUMBER(#REF!),#REF!*I$4/I$40,0)+IF(ISNUMBER(#REF!),#REF!*I$26/I$40,0), \"\")","v":""},"",{"$f":"IF(AND(K$42,OR(ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!))), IF(ISNUMBER(#REF!),#REF!*K$2/K$40,0) +IF(ISNUMBER(#REF!),#REF!*K$3/K$40,0)+IF(ISNUMBER(#REF!),#REF!*K$4/K$40,0)+IF(ISNUMBER(#REF!),#REF!*K$26/K$40,0), \"\")","v":""},"",{"$f":"IF(AND(M$42,OR(ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!))), IF(ISNUMBER(#REF!),#REF!*M$2/M$40,0) +IF(ISNUMBER(#REF!),#REF!*M$3/M$40,0)+IF(ISNUMBER(#REF!),#REF!*M$4/M$40,0)+IF(ISNUMBER(#REF!),#REF!*M$26/M$40,0), \"\")","v":""},"",{"$f":"IF(AND(O$42,OR(ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!))), IF(ISNUMBER(#REF!),#REF!*O$2/O$40,0) +IF(ISNUMBER(#REF!),#REF!*O$3/O$40,0)+IF(ISNUMBER(#REF!),#REF!*O$4/O$40,0)+IF(ISNUMBER(#REF!),#REF!*O$26/O$40,0), \"\")","v":""},""]
[null,"Option 6",{"$f":"IF(AND(C$42,OR(ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!))), IF(ISNUMBER(#REF!),#REF!*C$2/C$40,0) +IF(ISNUMBER(#REF!),#REF!*C$3/C$40,0)+IF(ISNUMBER(#REF!),#REF!*C$4/C$40,0)+IF(ISNUMBER(#REF!),#REF!*C$26/C$40,0), \"\")","v":""},"",{"$f":"IF(AND(E$42,OR(ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!))), IF(ISNUMBER(#REF!),#REF!*E$2/E$40,0) +IF(ISNUMBER(#REF!),#REF!*E$3/E$40,0)+IF(ISNUMBER(#REF!),#REF!*E$4/E$40,0)+IF(ISNUMBER(#REF!),#REF!*E$26/E$40,0), \"\")","v":""},"",{"$f":"IF(AND(G$42,OR(ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!))), IF(ISNUMBER(#REF!),#REF!*G$2/G$40,0) +IF(ISNUMBER(#REF!),#REF!*G$3/G$40,0)+IF(ISNUMBER(#REF!),#REF!*G$4/G$40,0)+IF(ISNUMBER(#REF!),#REF!*G$26/G$40,0), \"\")","v":""},"",{"$f":"IF(AND(I$42,OR(ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!))), IF(ISNUMBER(#REF!),#REF!*I$2/I$40,0) +IF(ISNUMBER(#REF!),#REF!*I$3/I$40,0)+IF(ISNUMBER(#REF!),#REF!*I$4/I$40,0)+IF(ISNUMBER(#REF!),#REF!*I$26/I$40,0), \"\")","v":""},"",{"$f":"IF(AND(K$42,OR(ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!))), IF(ISNUMBER(#REF!),#REF!*K$2/K$40,0) +IF(ISNUMBER(#REF!),#REF!*K$3/K$40,0)+IF(ISNUMBER(#REF!),#REF!*K$4/K$40,0)+IF(ISNUMBER(#REF!),#REF!*K$26/K$40,0), \"\")","v":""},"",{"$f":"IF(AND(M$42,OR(ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!))), IF(ISNUMBER(#REF!),#REF!*M$2/M$40,0) +IF(ISNUMBER(#REF!),#REF!*M$3/M$40,0)+IF(ISNUMBER(#REF!),#REF!*M$4/M$40,0)+IF(ISNUMBER(#REF!),#REF!*M$26/M$40,0), \"\")","v":""},"",{"$f":"IF(AND(O$42,OR(ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!))), IF(ISNUMBER(#REF!),#REF!*O$2/O$40,0) +IF(ISNUMBER(#REF!),#REF!*O$3/O$40,0)+IF(ISNUMBER(#REF!),#REF!*O$4/O$40,0)+IF(ISNUMBER(#REF!),#REF!*O$26/O$40,0), \"\")","v":""},""]
[null,"Option 7",{"$f":"IF(AND(C$42,OR(ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!))), IF(ISNUMBER(#REF!),#REF!*C$2/C$40,0) +IF(ISNUMBER(#REF!),#REF!*C$3/C$40,0)+IF(ISNUMBER(#REF!),#REF!*C$4/C$40,0)+IF(ISNUMBER(#REF!),#REF!*C$26/C$40,0), \"\")","v":""},"",{"$f":"IF(AND(E$42,OR(ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!))), IF(ISNUMBER(#REF!),#REF!*E$2/E$40,0) +IF(ISNUMBER(#REF!),#REF!*E$3/E$40,0)+IF(ISNUMBER(#REF!),#REF!*E$4/E$40,0)+IF(ISNUMBER(#REF!),#REF!*E$26/E$40,0), \"\")","v":""},"",{"$f":"IF(AND(G$42,OR(ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!))), IF(ISNUMBER(#REF!),#REF!*G$2/G$40,0) +IF(ISNUMBER(#REF!),#REF!*G$3/G$40,0)+IF(ISNUMBER(#REF!),#REF!*G$4/G$40,0)+IF(ISNUMBER(#REF!),#REF!*G$26/G$40,0), \"\")","v":""},"",{"$f":"IF(AND(I$42,OR(ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!))), IF(ISNUMBER(#REF!),#REF!*I$2/I$40,0) +IF(ISNUMBER(#REF!),#REF!*I$3/I$40,0)+IF(ISNUMBER(#REF!),#REF!*I$4/I$40,0)+IF(ISNUMBER(#REF!),#REF!*I$26/I$40,0), \"\")","v":""},"",{"$f":"IF(AND(K$42,OR(ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!))), IF(ISNUMBER(#REF!),#REF!*K$2/K$40,0) +IF(ISNUMBER(#REF!),#REF!*K$3/K$40,0)+IF(ISNUMBER(#REF!),#REF!*K$4/K$40,0)+IF(ISNUMBER(#REF!),#REF!*K$26/K$40,0), \"\")","v":""},"",{"$f":"IF(AND(M$42,OR(ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!))), IF(ISNUMBER(#REF!),#REF!*M$2/M$40,0) +IF(ISNUMBER(#REF!),#REF!*M$3/M$40,0)+IF(ISNUMBER(#REF!),#REF!*M$4/M$40,0)+IF(ISNUMBER(#REF!),#REF!*M$26/M$40,0), \"\")","v":""},"",{"$f":"IF(AND(O$42,OR(ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!))), IF(ISNUMBER(#REF!),#REF!*O$2/O$40,0) +IF(ISNUMBER(#REF!),#REF!*O$3/O$40,0)+IF(ISNUMBER(#REF!),#REF!*O$4/O$40,0)+IF(ISNUMBER(#REF!),#REF!*O$26/O$40,0), \"\")","v":""},""]
[null,"Option 8",{"$f":"IF(AND(C$42,OR(ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!))), IF(ISNUMBER(#REF!),#REF!*C$2/C$40,0) +IF(ISNUMBER(#REF!),#REF!*C$3/C$40,0)+IF(ISNUMBER(#REF!),#REF!*C$4/C$40,0)+IF(ISNUMBER(#REF!),#REF!*C$26/C$40,0), \"\")","v":""},"",{"$f":"IF(AND(E$42,OR(ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!))), IF(ISNUMBER(#REF!),#REF!*E$2/E$40,0) +IF(ISNUMBER(#REF!),#REF!*E$3/E$40,0)+IF(ISNUMBER(#REF!),#REF!*E$4/E$40,0)+IF(ISNUMBER(#REF!),#REF!*E$26/E$40,0), \"\")","v":""},"",{"$f":"IF(AND(G$42,OR(ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!))), IF(ISNUMBER(#REF!),#REF!*G$2/G$40,0) +IF(ISNUMBER(#REF!),#REF!*G$3/G$40,0)+IF(ISNUMBER(#REF!),#REF!*G$4/G$40,0)+IF(ISNUMBER(#REF!),#REF!*G$26/G$40,0), \"\")","v":""},"",{"$f":"IF(AND(I$42,OR(ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!))), IF(ISNUMBER(#REF!),#REF!*I$2/I$40,0) +IF(ISNUMBER(#REF!),#REF!*I$3/I$40,0)+IF(ISNUMBER(#REF!),#REF!*I$4/I$40,0)+IF(ISNUMBER(#REF!),#REF!*I$26/I$40,0), \"\")","v":""},"",{"$f":"IF(AND(K$42,OR(ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!))), IF(ISNUMBER(#REF!),#REF!*K$2/K$40,0) +IF(ISNUMBER(#REF!),#REF!*K$3/K$40,0)+IF(ISNUMBER(#REF!),#REF!*K$4/K$40,0)+IF(ISNUMBER(#REF!),#REF!*K$26/K$40,0), \"\")","v":""},"",{"$f":"IF(AND(M$42,OR(ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!))), IF(ISNUMBER(#REF!),#REF!*M$2/M$40,0) +IF(ISNUMBER(#REF!),#REF!*M$3/M$40,0)+IF(ISNUMBER(#REF!),#REF!*M$4/M$40,0)+IF(ISNUMBER(#REF!),#REF!*M$26/M$40,0), \"\")","v":""},"",{"$f":"IF(AND(O$42,OR(ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!))), IF(ISNUMBER(#REF!),#REF!*O$2/O$40,0) +IF(ISNUMBER(#REF!),#REF!*O$3/O$40,0)+IF(ISNUMBER(#REF!),#REF!*O$4/O$40,0)+IF(ISNUMBER(#REF!),#REF!*O$26/O$40,0), \"\")","v":""},""]
[null,"Option 9",{"$f":"IF(AND(C$42,OR(ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!))), IF(ISNUMBER(#REF!),#REF!*C$2/C$40,0) +IF(ISNUMBER(#REF!),#REF!*C$3/C$40,0)+IF(ISNUMBER(#REF!),#REF!*C$4/C$40,0)+IF(ISNUMBER(#REF!),#REF!*C$26/C$40,0), \"\")","v":""},"",{"$f":"IF(AND(E$42,OR(ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!))), IF(ISNUMBER(#REF!),#REF!*E$2/E$40,0) +IF(ISNUMBER(#REF!),#REF!*E$3/E$40,0)+IF(ISNUMBER(#REF!),#REF!*E$4/E$40,0)+IF(ISNUMBER(#REF!),#REF!*E$26/E$40,0), \"\")","v":""},"",{"$f":"IF(AND(G$42,OR(ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!))), IF(ISNUMBER(#REF!),#REF!*G$2/G$40,0) +IF(ISNUMBER(#REF!),#REF!*G$3/G$40,0)+IF(ISNUMBER(#REF!),#REF!*G$4/G$40,0)+IF(ISNUMBER(#REF!),#REF!*G$26/G$40,0), \"\")","v":""},"",{"$f":"IF(AND(I$42,OR(ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!))), IF(ISNUMBER(#REF!),#REF!*I$2/I$40,0) +IF(ISNUMBER(#REF!),#REF!*I$3/I$40,0)+IF(ISNUMBER(#REF!),#REF!*I$4/I$40,0)+IF(ISNUMBER(#REF!),#REF!*I$26/I$40,0), \"\")","v":""},"",{"$f":"IF(AND(K$42,OR(ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!))), IF(ISNUMBER(#REF!),#REF!*K$2/K$40,0) +IF(ISNUMBER(#REF!),#REF!*K$3/K$40,0)+IF(ISNUMBER(#REF!),#REF!*K$4/K$40,0)+IF(ISNUMBER(#REF!),#REF!*K$26/K$40,0), \"\")","v":""},"",{"$f":"IF(AND(M$42,OR(ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!))), IF(ISNUMBER(#REF!),#REF!*M$2/M$40,0) +IF(ISNUMBER(#REF!),#REF!*M$3/M$40,0)+IF(ISNUMBER(#REF!),#REF!*M$4/M$40,0)+IF(ISNUMBER(#REF!),#REF!*M$26/M$40,0), \"\")","v":""},"",{"$f":"IF(AND(O$42,OR(ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!))), IF(ISNUMBER(#REF!),#REF!*O$2/O$40,0) +IF(ISNUMBER(#REF!),#REF!*O$3/O$40,0)+IF(ISNUMBER(#REF!),#REF!*O$4/O$40,0)+IF(ISNUMBER(#REF!),#REF!*O$26/O$40,0), \"\")","v":""},""]
[null,"Option 10",{"$f":"IF(AND(C$42,OR(ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!))), IF(ISNUMBER(#REF!),#REF!*C$2/C$40,0) +IF(ISNUMBER(#REF!),#REF!*C$3/C$40,0)+IF(ISNUMBER(#REF!),#REF!*C$4/C$40,0)+IF(ISNUMBER(#REF!),#REF!*C$26/C$40,0), \"\")","v":""},"",{"$f":"IF(AND(E$42,OR(ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!))), IF(ISNUMBER(#REF!),#REF!*E$2/E$40,0) +IF(ISNUMBER(#REF!),#REF!*E$3/E$40,0)+IF(ISNUMBER(#REF!),#REF!*E$4/E$40,0)+IF(ISNUMBER(#REF!),#REF!*E$26/E$40,0), \"\")","v":""},"",{"$f":"IF(AND(G$42,OR(ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!))), IF(ISNUMBER(#REF!),#REF!*G$2/G$40,0) +IF(ISNUMBER(#REF!),#REF!*G$3/G$40,0)+IF(ISNUMBER(#REF!),#REF!*G$4/G$40,0)+IF(ISNUMBER(#REF!),#REF!*G$26/G$40,0), \"\")","v":""},"",{"$f":"IF(AND(I$42,OR(ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!))), IF(ISNUMBER(#REF!),#REF!*I$2/I$40,0) +IF(ISNUMBER(#REF!),#REF!*I$3/I$40,0)+IF(ISNUMBER(#REF!),#REF!*I$4/I$40,0)+IF(ISNUMBER(#REF!),#REF!*I$26/I$40,0), \"\")","v":""},"",{"$f":"IF(AND(K$42,OR(ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!))), IF(ISNUMBER(#REF!),#REF!*K$2/K$40,0) +IF(ISNUMBER(#REF!),#REF!*K$3/K$40,0)+IF(ISNUMBER(#REF!),#REF!*K$4/K$40,0)+IF(ISNUMBER(#REF!),#REF!*K$26/K$40,0), \"\")","v":""},"",{"$f":"IF(AND(M$42,OR(ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!))), IF(ISNUMBER(#REF!),#REF!*M$2/M$40,0) +IF(ISNUMBER(#REF!),#REF!*M$3/M$40,0)+IF(ISNUMBER(#REF!),#REF!*M$4/M$40,0)+IF(ISNUMBER(#REF!),#REF!*M$26/M$40,0), \"\")","v":""},"",{"$f":"IF(AND(O$42,OR(ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!),ISNUMBER(#REF!))), IF(ISNUMBER(#REF!),#REF!*O$2/O$40,0) +IF(ISNUMBER(#REF!),#REF!*O$3/O$40,0)+IF(ISNUMBER(#REF!),#REF!*O$4/O$40,0)+IF(ISNUMBER(#REF!),#REF!*O$26/O$40,0), \"\")","v":""},""]
[]
[null,null,"Sum",null,"Sum",null,"Sum",null,"Sum",null,"Sum",null,"Sum",null,"Sum"]
[null,null,{"$f":"SUM(C2:C26)","v":2500},null,{"$f":"SUM(E2:E26)","v":0},null,{"$f":"SUM(G2:G26)","v":0},null,{"$f":"SUM(I2:I26)","v":0},null,{"$f":"SUM(K2:K26)","v":0},null,{"$f":"SUM(M2:M26)","v":0},null,{"$f":"SUM(O2:O26)","v":0}]
[null,null,"Is Number",null,"Is Number",null,"Is Number",null,"Is Number",null,"Is Number",null,"Is Number",null,"Is Number"]
[null,null,{"$f":"AND(ISNUMBER(C2), ISNUMBER(C3), ISNUMBER(C4), ISNUMBER(C5), ISNUMBER(C6), ISNUMBER(C7), ISNUMBER(C8), ISNUMBER(C9), ISNUMBER(C10), ISNUMBER(C11), ISNUMBER(C12), ISNUMBER(C13), ISNUMBER(C14), ISNUMBER(C15), ISNUMBER(C16), ISNUMBER(C17), ISNUMBER(C18), ISNUMBER(C19), ISNUMBER(C20), ISNUMBER(C21), ISNUMBER(C22), ISNUMBER(C23), ISNUMBER(C24), ISNUMBER(C25), ISNUMBER(C26))","v":true},null,{"$f":"AND(ISNUMBER(E2), ISNUMBER(E3), ISNUMBER(E4), ISNUMBER(E5), ISNUMBER(E6), ISNUMBER(E7), ISNUMBER(E8), ISNUMBER(E9), ISNUMBER(E10), ISNUMBER(E11), ISNUMBER(E12), ISNUMBER(E13), ISNUMBER(E14), ISNUMBER(E15), ISNUMBER(E16), ISNUMBER(E17), ISNUMBER(E18), ISNUMBER(E19), ISNUMBER(E20), ISNUMBER(E21), ISNUMBER(E22), ISNUMBER(E23), ISNUMBER(E24), ISNUMBER(E25), ISNUMBER(E26))","v":false},null,{"$f":"AND(ISNUMBER(G2), ISNUMBER(G3), ISNUMBER(G4), ISNUMBER(G5), ISNUMBER(G6), ISNUMBER(G7), ISNUMBER(G8), ISNUMBER(G9), ISNUMBER(G10), ISNUMBER(G11), ISNUMBER(G12), ISNUMBER(G13), ISNUMBER(G14), ISNUMBER(G15), ISNUMBER(G16), ISNUMBER(G17), ISNUMBER(G18), ISNUMBER(G19), ISNUMBER(G20), ISNUMBER(G21), ISNUMBER(G22), ISNUMBER(G23), ISNUMBER(G24), ISNUMBER(G25), ISNUMBER(G26))","v":false},null,{"$f":"AND(ISNUMBER(I2), ISNUMBER(I3), ISNUMBER(I4), ISNUMBER(I5), ISNUMBER(I6), ISNUMBER(I7), ISNUMBER(I8), ISNUMBER(I9), ISNUMBER(I10), ISNUMBER(I11), ISNUMBER(I12), ISNUMBER(I13), ISNUMBER(I14), ISNUMBER(I15), ISNUMBER(I16), ISNUMBER(I17), ISNUMBER(I18), ISNUMBER(I19), ISNUMBER(I20), ISNUMBER(I21), ISNUMBER(I22), ISNUMBER(I23), ISNUMBER(I24), ISNUMBER(I25), ISNUMBER(I26))","v":false},null,{"$f":"AND(ISNUMBER(K2), ISNUMBER(K3), ISNUMBER(K4), ISNUMBER(K5), ISNUMBER(K6), ISNUMBER(K7), ISNUMBER(K8), ISNUMBER(K9), ISNUMBER(K10), ISNUMBER(K11), ISNUMBER(K12), ISNUMBER(K13), ISNUMBER(K14), ISNUMBER(K15), ISNUMBER(K16), ISNUMBER(K17), ISNUMBER(K18), ISNUMBER(K19), ISNUMBER(K20), ISNUMBER(K21), ISNUMBER(K22), ISNUMBER(K23), ISNUMBER(K24), ISNUMBER(K25), ISNUMBER(K26))","v":false},null,{"$f":"AND(ISNUMBER(M2), ISNUMBER(M3), ISNUMBER(M4), ISNUMBER(M5), ISNUMBER(M6), ISNUMBER(M7), ISNUMBER(M8), ISNUMBER(M9), ISNUMBER(M10), ISNUMBER(M11), ISNUMBER(M12), ISNUMBER(M13), ISNUMBER(M14), ISNUMBER(M15), ISNUMBER(M16), ISNUMBER(M17), ISNUMBER(M18), ISNUMBER(M19), ISNUMBER(M20), ISNUMBER(M21), ISNUMBER(M22), ISNUMBER(M23), ISNUMBER(M24), ISNUMBER(M25), ISNUMBER(M26))","v":false},null,{"$f":"AND(ISNUMBER(O2), ISNUMBER(O3), ISNUMBER(O4), ISNUMBER(O5), ISNUMBER(O6), ISNUMBER(O7), ISNUMBER(O8), ISNUMBER(O9), ISNUMBER(O10), ISNUMBER(O11), ISNUMBER(O12), ISNUMBER(O13), ISNUMBER(O14), ISNUMBER(O15), ISNUMBER(O16), ISNUMBER(O17), ISNUMBER(O18), ISNUMBER(O19), ISNUMBER(O20), ISNUMBER(O21), ISNUMBER(O22), ISNUMBER(O23), ISNUMBER(O24), ISNUMBER(O25), ISNUMBER(O26))","v":false}]

{"sheet":"Simulation Output 1","index":11,"n_rows":45,"n_cols":10,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
[]
["Loss Distribution","Base Case Scenario","ST1 Ignore Future","ST2 Protect Future","ST3 More Growth","ST4 More Fires","Fire Trails","Fire Control Towers","Rezone Land","Prescribed Burning"]
["Mean",75302528.888433874,47757455.819240399,121502717.10302095,103301948.04380693,90065977.556244835,52435980.841915682,52017155.618728869,25589023.883643098,12996385.629185067]
["Median",61055766.08729285,35193449.657227762,102115752.29147436,85345084.477850333,75757039.129290685,44891721.704219207,44369761.959672034,23616256.448149852,11149130.864392165]
["Standard Deviation",62489090.153535716,45966158.527505621,90809508.349598959,80371271.288216099,66622284.653092168,37110008.88333901,36876273.9889329,14409394.125388192,10344270.777327133]
["90% of loss",152129536.80543154,100751423.97259073,236691255.84295705,204229713.65272161,170037384.92139131,99966077.695017979,99862794.00046283,44606320.979885109,26836609.570459131]
["95% of loss",190715051.35691604,133803649.3999965,290855699.96613276,252388429.57138801,213527195.62328178,123812908.04606363,122412449.33598614,52005558.940959379,32148475.87747043]
["99% of loss",286634801.56316328,221317911.46780321,424577110.40820068,375763878.51640862,316703015.5168364,174243849.89357594,169617869.31194669,66825578.946081445,45438635.931602284]
[]
["Benefit"]
["Benefit (Mean)",null,null,null,null,null,{"$f":"$B$3 - $G$3","v":22866548.046518192},{"$f":"$B$3 - $H$3","v":23285373.269705005},{"$f":"$B$3 - $I$3","v":49713505.004790775},{"$f":"$B$3 - $J$3","v":62306143.259248808}]
["Benefit (95%)",null,null,null,null,null,{"$f":"$B$7 - $G$7","v":66902143.310852408},{"$f":"$B$7 - $H$7","v":68302602.020929903},{"$f":"$B$7 - $I$7","v":138709492.41595668},{"$f":"$B$7 - $J$7","v":158566575.47944561}]
["Costs"]
["Option Cost",null,null,null,null,null,3104056.1658196975,13486739.898363747,71622.46632787917,25973479.796727493]
["Net Benefit"]
["Net Benefit (Mean)",null,null,null,null,null,{"$f":"$G$11 - $G$14","v":19762491.880698495},{"$f":"$H$11 - $H$14","v":9798633.3713412583},{"$f":"$I$11 - $I$14","v":49641882.5384629},{"$f":"$J$11 - $J$14","v":36332663.462521315}]
["Net Benefit (95%)",null,null,null,null,null,{"$f":"$G$12 - $G$14","v":63798087.145032711},{"$f":"$H$12 - $H$14","v":54815862.122566156},{"$f":"$I$12 - $I$14","v":138637869.9496288},{"$f":"$J$12 - $J$14","v":132593095.68271811}]
[]
["Input parameters"]
["Simulation"]
["Years",40,40,40,40,40,40,40,40,40]
["Discount Rate",0.06,0.1,0.03,0.06,0.06,0.06,0.06,0.06,0.06]
["Growth Rate",0.02,0.02,0.02,0.04,0.02,0.02,0.02,0.02,0.02]
["Change in Frequency",0,0,0,0,0.5]
["Number of Simulations",10000,10000,10000,10000,10000,10000,10000,10000,10000]
["Frequency"]
["Events per Year",0.1]
["Lower Bound",6.6666669999999997E-2]
["Upper Bound",0.14285713999999999]
["Probability",0.66666667000000002]
["Observed No. of Years",10]
["Observed No. of Events",2]
["Estimated Frequency",0.11305393355632594,0.11305393355632594,0.11305393355632594,0.11305393355632594,0.11305393355632594,0.11305393355632594,0.11305393355632594,0.11305393355632594,5.6526966778162969E-2]
["Frequency Reduction",null,null,null,null,null,0,0,0,0.5]
["Severity"]
["Median",20000000,20000000,20000000,20000000,20000000,16000000,16000000,10000000,10000000]
["Worst Case (95%)",100000000,100000000,100000000,100000000,100000000,60000000,60000000,19999999.999999996,19999999.999999996]
["Change in Median",null,0,0,0,0,-0.2,-0.2,-0.5,-0.5]
["Change in Worst Case",null,0,0,0,0,-0.4,-0.4,-0.8,-0.8]
["Distribution","Lognormal","Lognormal","Lognormal","Lognormal","Lognormal","Lognormal","Lognormal","Lognormal","Lognormal"]
["Mu",16.811242831518264,16.811242831518264,16.811242831518264,16.811242831518264,16.811242831518264,16.588099280204055,16.588099280204055,16.11809565095832,16.11809565095832]
["Sigma",0.97846877440212909,0.97846877440212909,0.97846877440212909,0.97846877440212909,0.97846877440212909,0.80357049303653072,0.80357049303653072,0.42140356394179851,0.42140356394179851]
["Costs"]
["Capital",null,null,null,null,null,3000000,1000000,30000,1000000]
["Maintenance",null,null,null,null,null,5000,600000,2000,1200000]

{"sheet":"Simulation Output 1 Graph Data","index":12,"n_rows":102,"n_cols":36,"rows_kept":102,"cut":false,"hidden":true,"merged":[]}
[{"$f":"'Simulation Output 1'!$B$2","v":"Base Case Scenario"},"Loss Distribution",{"$f":"'Simulation Output 1'!$B$2","v":"Base Case Scenario"},"Cumulative Loss",{"$f":"'Simulation Output 1'!$C$2","v":"ST1 Ignore Future"},"Loss Distribution",{"$f":"'Simulation Output 1'!$C$2","v":"ST1 Ignore Future"},"Cumulative Loss",{"$f":"'Simulation Output 1'!$D$2","v":"ST2 Protect Future"},"Loss Distribution",{"$f":"'Simulation Output 1'!$D$2","v":"ST2 Protect Future"},"Cumulative Loss",{"$f":"'Simulation Output 1'!$E$2","v":"ST3 More Growth"},"Loss Distribution",{"$f":"'Simulation Output 1'!$E$2","v":"ST3 More Growth"},"Cumulative Loss",{"$f":"'Simulation Output 1'!$F$2","v":"ST4 More Fires"},"Loss Distribution",{"$f":"'Simulation Output 1'!$F$2","v":"ST4 More Fires"},"Cumulative Loss",{"$f":"'Simulation Output 1'!$G$2","v":"Fire Trails"},"Loss Distribution",{"$f":"'Simulation Output 1'!$G$2","v":"Fire Trails"},"Cumulative Loss",{"$f":"'Simulation Output 1'!$H$2","v":"Fire Control Towers"},"Loss Distribution",{"$f":"'Simulation Output 1'!$H$2","v":"Fire Control Towers"},"Cumulative Loss",{"$f":"'Simulation Output 1'!$I$2","v":"Rezone Land"},"Loss Distribution",{"$f":"'Simulation Output 1'!$I$2","v":"Rezone Land"},"Cumulative Loss",{"$f":"'Simulation Output 1'!$J$2","v":"Prescribed Burning"},"Loss Distribution",{"$f":"'Simulation Output 1'!$J$2","v":"Prescribed Burning"},"Cumulative Loss"]
["Bins","Frequency","Year","Yearly Loss","Bins","Frequency","Year","Yearly Loss","Bins","Frequency","Year","Yearly Loss","Bins","Frequency","Year","Yearly Loss","Bins","Frequency","Year","Yearly Loss","Bins","Frequency","Year","Yearly Loss","Bins","Frequency","Year","Yearly Loss","Bins","Frequency","Year","Yearly Loss","Bins","Frequency","Year","Yearly Loss"]
[0,113,1,3561776.0958888088,0,114,1,3512015.2586311069,0,109,1,3701580.2314573643,0,97,1,3668957.9594391701,0,37,1,3899488.2671438698,0,119,1,5594938.2401850987,0,100,1,4191042.4445780693,0,108,1,1181123.1358680835,0,1059,1,2858561.5320723802]
[12660575.628496915,644,2,6769844.1132436208,5877405.9989429014,674,2,7153037.1083554775,9997411.110606676,177,2,7286325.3896337459,11935563.088366089,335,2,7206708.4096421897,9840292.9804499466,232,2,7495603.9705734905,3553674.1973502245,86,2,8028523.1904669506,5320983.7247224012,214,2,7080160.0582391126,986645.5080646656,2,2,2394935.2706329073,780733.77661533724,3,2,4652790.4816739261]
[25321151.25699383,1050,3,10439499.388523167,11754811.997885803,858,3,10135101.059023365,19994822.221213352,341,3,11017423.489199704,23871126.176732179,568,3,10813662.598599266,19680585.960899893,467,3,11271525.827965599,7107348.394700449,222,3,10310276.103618,10641967.449444802,411,3,9907923.0115161799,1973291.0161293312,43,3,3489213.4160260293,1561467.5532306745,78,3,6328955.9211123437]
[37981726.885490745,1211,4,13563983.625758391,17632217.996828705,915,4,12966689.416287931,29992233.331820026,410,4,14505049.903257636,35806689.265098266,735,4,14311598.85891746,29520878.941349842,630,4,14575720.103931166,10661022.592050673,300,4,12463802.887768503,15962951.174167205,530,4,12900656.1135008,2959936.5241939966,69,4,4609025.9386126148,2342201.3298460115,227,4,7986605.8379761353]
[50642302.51398766,1158,5,16424539.336294455,23509623.995771606,865,5,15746962.098562755,39989644.442426704,492,5,17775860.2148173,47742252.353464358,769,5,17581425.240692817,39361171.921799786,718,5,17955510.184871837,14214696.789400898,385,5,14625730.556209639,21283934.898889605,680,5,15606332.655532744,3946582.0322586624,108,5,5654460.3910472486,3122935.1064613489,280,5,9506399.7378730755]
[63302878.142484576,975,6,19313066.520176757,29387029.994714506,819,6,18472206.837803129,49987055.553033382,533,6,21190715.32122552,59677815.441830449,785,6,20944587.260523111,49201464.902249731,835,6,21197037.665839866,17768370.986751124,431,6,16893699.880556133,26604918.623612005,694,6,18113648.98597559,4933227.5403233282,98,6,6619693.3491038196,3903668.8830766864,300,6,11065794.270088894]
[75963453.770981491,943,7,22106744.787112802,35264435.99365741,760,7,20583028.791972388,59984466.66364006,564,7,24558615.275124054,71613378.530196533,820,7,24422803.106266998,59041757.882699676,733,7,24193487.023161545,21322045.184101351,417,7,18851134.822685227,31925902.348334406,753,7,20442389.662019014,5919873.0483879941,124,7,7620611.174078743,4684402.6596920239,328,7,12512740.16391913]
[88624029.399478406,822,8,24977286.945654593,41141841.992600314,626,8,22681337.953644734,69981877.774246737,596,8,27725927.499311399,83548941.618562624,780,8,27663084.028295174,68882050.863149628,830,8,27131554.538897358,24875719.381451577,443,8,20855191.407381836,37246886.07305681,727,8,22837495.735493556,6906518.5564526599,152,8,8557063.5806659944,5465136.4363073613,337,8,13882618.806927985]
[101284605.02797532,623,9,27636260.529847674,47019247.991543218,584,9,24613181.353319194,79979288.884853408,548,9,31314985.751143403,95484504.706928715,688,9,30700728.784683682,78722343.843599573,754,9,29928382.291357618,28429393.578801803,449,9,22712416.024503868,42567869.79777921,674,9,25064011.501543086,7893164.0645173257,152,9,9479113.9213375207,6245870.2129226988,330,9,15227498.86179436]
[113945180.65647224,496,10,30120019.624257453,52896653.990486123,535,10,26502928.078538306,89976699.995460078,572,10,34409167.850881517,107420067.79529481,654,10,33825480.997401923,88562636.824049518,649,10,32557332.864254132,31983067.77615203,486,10,24476403.146858688,47888853.52250161,632,10,27227658.684703004,8879809.5725819916,193,10,10318121.465674872,7026603.9895380363,348,10,16532106.973137513]
[126605756.28496915,402,11,32680081.627462931,58774059.989429027,465,11,28303763.777375087,99974111.106066748,534,11,38011894.871839851,119355630.8836609,538,11,37103571.389960766,98402929.804499462,610,11,35160880.145963535,35536741.973502256,450,11,26198102.237411037,53209837.247224011,597,11,29299779.423274875,9866455.0806466565,197,11,11158619.777188001,7807337.7661533738,353,11,17770231.615710095]
[139266331.91346607,326,12,35101869.363128416,64651465.988371931,388,12,30032629.610012583,109971522.21667342,541,12,41158582.5185939,131291193.97202699,480,12,40253704.002723031,108243222.78494941,512,12,37926976.751449063,39090416.170852482,448,12,27902831.61436189,58530820.971946411,527,12,31398852.131712556,10853100.588711321,214,12,11960708.055477316,8588071.5427687112,311,12,18965432.132946685]
[151926907.54196298,231,13,37628015.619580552,70528871.987314835,328,13,31448559.374454126,119968933.32728009,483,13,44467381.184473775,143226757.06039307,422,13,42961909.018248267,118083515.76539935,479,13,40667129.317429647,42644090.368202709,505,13,29462918.59188661,63851804.696668811,464,13,33276624.698077179,11839746.096775986,248,13,12721721.948760489,9368805.3193840478,301,13,20092617.110930324]
[164587483.1704599,232,14,39693422.565747671,76406277.986257732,266,14,33009612.920855105,129966344.43788676,444,14,47611544.547141194,155162320.14875916,397,14,45863115.119027041,127923808.7458493,400,14,43101651.946444422,46197764.565552935,409,14,30976989.085489459,69172788.421391219,455,14,35163633.041603684,12826391.604840651,212,14,13524411.55038902,10149539.095999384,323,14,21180230.419745412]
[177248058.79895681,158,15,41800350.526655525,82283683.985200629,240,15,34295497.815948516,139963755.54849344,417,15,51018221.642705128,167097883.23712525,286,15,48478629.404708467,137764101.72629926,332,15,45576223.70708999,49751438.762903161,394,15,32481946.70453601,74493772.146113619,361,15,37015256.483394407,13813037.112905316,271,15,14264756.657124415,10930272.872614721,344,15,22244018.30993953]
[189908634.42745373,100,16,43906489.107059732,88161089.984143525,212,16,35514527.974851616,149961166.65910012,351,16,54055547.860844992,179033446.32549134,251,16,51036653.099393703,147604394.7067492,266,16,47905866.375245392,53305112.960253388,392,16,33819984.992475055,79814755.87083602,317,16,38736227.328575738,14799682.620969981,250,16,14959944.672108045,11711006.649230057,295,16,23245426.251600597]
[202569210.05595064,103,17,45753220.902111635,94038495.983086422,175,17,36606742.364318021,159958577.76970679,285,17,57095654.39448119,190969009.41385743,212,17,53478985.425285451,157444687.68719915,249,17,50289331.26589039,56858787.157603614,385,17,35160849.386982381,85135739.59555842,271,17,40464779.032453336,15786328.129034646,278,17,15659464.221962806,12491740.425845394,304,17,24241360.784421992]
[215229785.68444756,90,18,47736050.545704752,99915901.982029319,155,18,37558278.660099335,169955988.88031346,310,18,60045560.574158326,202904572.50222352,173,18,56067601.599236108,167284980.66764909,218,18,52541534.173105672,60412461.35495384,310,18,36441315.480639599,90456723.32028082,222,18,42004636.759757154,16772973.637099311,282,18,16268839.773761384,13272474.20246073,286,18,25187524.774171315]
[227890361.31294447,55,19,49562467.12080583,105793307.98097222,126,19,38498976.800025947,179953399.99092013,261,19,63216088.870896228,214840135.59058961,145,19,58825972.924917221,177125273.64809904,149,19,54766329.591029666,63966135.552304067,303,19,37681951.552884124,95777707.04500322,226,19,43570716.75388211,17759619.145163976,269,19,16904729.677875672,14053207.979076067,284,19,26120308.516480993]
[240550936.94144139,52,20,51298000.535354376,111670713.97991511,107,20,39273032.970167339,189950811.1015268,237,20,66028006.550676674,226775698.6789557,141,20,61361391.67661538,186965566.62854898,125,20,56970346.118616387,67519809.749654293,316,20,38900881.152094528,101098690.76972562,183,20,45087951.502588734,18746264.653228641,295,20,17497582.550790586,14833941.755691404,280,20,26980054.547064818]
[253211512.5699383,38,21,52984382.795952402,117548119.97885801,96,21,40068917.711212933,199948222.21213347,215,21,69122007.900851637,238711261.7673218,113,21,63923065.236031599,196805859.60899892,123,21,59236742.139305532,71073483.947004512,304,21,40060972.132323727,106419674.49444802,148,21,46609919.362284951,19732910.161293305,292,21,18054306.240209322,15614675.53230674,245,21,27821363.780905984]
[265872088.19843522,36,22,54713172.921095148,123425525.97780091,80,22,40787017.185410678,209945633.32274014,171,22,72357060.610968411,250646824.85568789,97,22,66411502.465968244,206646152.58944887,80,22,61374638.019250631,74627158.144354731,239,22,41212245.120133407,111740658.21917042,110,22,48024102.850808345,20719555.66935797,286,22,18602432.390609939,16395409.308922077,233,22,28645748.952850219]
[278532663.82693213,27,23,56299019.933227837,129302931.9767438,66,23,41525956.154382728,219943044.43334681,170,23,75459106.428057522,262582387.94405398,85,23,68837697.898055717,216486445.56989881,88,23,63275032.981382281,78180832.34170495,243,23,42283291.181522503,117061641.94389282,104,23,49360954.84585052,21706201.177422635,302,23,19125886.072401404,17176143.085537415,224,23,29398693.204035915]
[291193239.45542908,19,24,57742107.588254116,135180337.9756867,53,24,42177078.547803409,229940455.54395348,141,24,78293731.36427097,274517951.03242004,71,24,71103770.298937619,226326738.55034876,76,24,65391603.443420582,81734506.539055169,207,24,43259951.818764023,122382625.66861522,96,24,50612490.47516147,22692846.6854873,303,24,19645212.662133049,17956876.862152752,219,24,30143772.433384739]
[303853815.08392596,21,25,59131622.160075061,141057743.97462961,52,25,42745620.384988107,239937866.65456015,142,25,81030128.963885561,286453514.12078613,57,25,73359316.743228778,236167031.5307987,70,25,67284250.686280578,85288180.736405388,195,25,44288193.562304504,127703609.39333762,82,25,51832087.631274715,23679492.193551965,274,25,20148825.224726975,18737610.638768088,213,25,30874174.054696485]
[316514390.71242285,7,26,60644517.98447042,146935149.97357252,53,26,43268724.924934611,249935277.76516682,117,26,84064099.236662686,298389077.20915222,39,26,75692545.690027446,246007324.51124865,46,26,69077884.017490253,88841854.933755606,157,26,45207036.498833731,133024593.11806002,70,26,53062809.619900592,24666137.70161663,256,26,20614579.517102148,19518344.415383425,188,26,31578248.764785647]
[329174966.34091973,6,27,61966663.518677793,152812555.97251543,36,27,43740260.947320879,259932688.87577349,84,27,86938368.799399868,310324640.29751831,35,27,77764332.462586358,255847617.49169859,43,27,70933432.073873386,92395529.131105825,140,27,46204842.847897388,138345576.84278244,59,27,54183723.528948359,25652783.209681295,272,27,21061705.83601341,20299078.191998761,216,27,32253936.286126897]
[341835541.96941662,16,28,63203537.402970746,158689961.97145835,47,28,44194507.833268739,269930099.98638016,96,28,90122209.801032633,322260203.3858844,37,28,80063227.288569659,265687910.47214854,34,28,72701394.163468555,95949203.328456044,142,28,47051642.410249949,143666560.56750485,55,28,55221671.034884065,26639428.71774596,236,28,21503400.87217208,21079811.968614098,183,28,32893582.292483278]
[354496117.5979135,9,29,64440224.501526318,164567367.97040126,20,29,44615963.621393591,279927511.09698683,80,29,92908429.222575963,334195766.4742505,33,29,82278006.935774714,275528203.45259851,21,29,74395158.017832205,99502877.525806263,108,29,47959048.379942611,148987544.29222727,47,29,56267513.138776183,27626074.225810625,264,29,21925978.32422471,21860545.745229434,156,29,33504729.060786016]
[367156693.22641039,3,30,65663383.264375061,170444773.96934417,37,30,45038274.560264274,289924922.2075935,72,30,95597757.755209088,346131329.56261659,20,30,84386322.487227619,285368496.43304849,30,30,76017613.757490858,103056551.72315648,102,30,48792934.858116247,154308528.01694968,31,30,57322776.354719609,28612719.73387529,257,30,22344141.370446719,22641279.521844771,125,30,34105880.535236277]
[379817268.85490727,4,31,66674201.266408443,176322179.96828708,27,31,45403692.785925604,299922333.31820017,70,31,98444241.687058046,358066892.65098268,13,31,86768543.944568664,295208789.41349846,22,31,77584519.187496156,106610225.9205067,98,31,49620679.923700534,159629511.7416721,25,31,58322767.015996784,29599365.241939954,231,31,22741291.676462181,23422013.298460107,152,31,34695047.488780156]
[392477844.48340416,2,32,67713141.788853884,182199585.96722999,25,32,45745279.734389126,309919744.42880684,41,32,101020360.71677043,370002455.73934877,18,32,88824336.14796178,305049082.39394844,20,32,79083511.690564275,110163900.11785692,82,32,50369384.532184027,164950495.46639451,20,32,59221822.696878374,30586010.750004619,235,32,23106556.801895447,24202747.075075444,114,32,35239312.156962082]
[405138420.11190104,5,33,68831217.858470172,188076991.9661729,23,33,46072347.346230157,319917155.53941351,53,33,103780380.35158174,381938018.82771486,11,33,90755691.09183909,314889375.37439841,20,33,80636866.79428421,113717574.31520714,71,33,51126145.523498967,170271479.19111693,17,33,60140138.745458253,31572656.258069284,218,33,23473624.176634789,24983480.85169078,126,33,35781265.749072239]
[417798995.74039793,6,34,69923050.992672801,193954397.96511582,14,34,46359853.209996082,329914566.65002018,45,34,106237648.48655224,393873581.91608095,11,34,92699009.573129207,324729668.35484838,12,34,82178369.205638856,117271248.51255736,61,34,51831641.538600542,175592462.91583934,12,34,60971424.343976311,32559301.766133949,191,34,23831568.265255947,25764214.628306117,106,34,36284658.454606026]
[430459571.36889482,4,35,70891643.725315601,199831803.96405873,9,35,46650754.767373741,339911977.76062685,41,35,108639002.89301206,405809145.00444704,14,35,94680753.519694448,334569961.33529836,7,35,83604057.232688427,120824922.70990758,55,35,52484986.176848046,180913446.64056176,14,35,61810404.726493306,33545947.274198614,206,35,24163275.283057068,26544948.404921453,97,35,36775300.587009378]
[443120146.9973917,3,36,71851761.168386638,205709209.96300164,18,36,46890850.567323364,349909388.87123352,16,36,111171149.27240875,417744708.09281313,11,36,96401438.98892878,344410254.31574833,9,36,85030458.627634257,124378596.9072578,56,36,53116904.778645873,186234430.36528417,9,36,62547862.306366213,34532592.782263279,182,36,24505942.476787128,27325682.18153679,93,36,37255275.367955029]
[455780722.62588859,0,37,72776443.970248818,211586615.96194455,14,37,47120961.900785513,359906799.98184019,34,37,113709151.65132499,429680271.18117923,6,37,98109984.318862006,354250547.29619831,10,37,86337753.952960223,127932271.10460801,60,37,53790864.733164743,191555414.09000659,5,37,63315616.663484976,35519238.290327944,170,37,24825316.399794582,28106415.958152127,95,37,37719382.199498206]
[468441298.25438547,0,38,73723741.738516197,217464021.96088746,11,38,47353100.590864062,369904211.09244686,27,38,116034760.17480001,441615834.26954532,8,38,99794978.671077505,364090840.27664828,8,38,87623196.379616037,131485945.30195823,53,38,54436121.008986592,196876397.81472901,6,38,64045822.986190259,36505883.798392609,173,38,25135057.893133953,28887149.734767463,74,38,38151143.557975635]
[481101873.88288236,0,39,74548600.509349376,223341427.95983037,9,39,47555758.426473156,379901622.20305353,18,39,118700698.72937372,453551397.35791141,3,39,101493804.75830466,373931133.25709826,8,39,88846372.534941807,135039619.49930847,31,39,54989058.758797184,202197381.53945142,10,39,64760285.515059061,37492529.306457274,144,39,25399689.505271044,29667883.5113828,79,39,38570505.670220762]
[493762449.51137924,1,40,75302528.88843374,229218833.95877329,7,40,47757455.819240429,389899033.3136602,14,40,121502717.10302143,465486960.4462775,6,40,103301948.04380667,383771426.23754823,7,40,90065977.55624485,138593293.6966587,34,40,55540037.007735349,207518365.26417384,11,40,65503895.517092615,38479174.814521939,152,40,25660646.3499709,30448617.287998136,63,40,38969865.425912566]
[506423025.13987613,3,null,null,235096239.9577162,10,null,null,399896444.42426687,14,null,null,477422523.53464359,3,null,null,393611719.21799821,7,null,null,142146967.89400893,37,null,null,212839348.98889625,8,null,null,39465820.322586603,129,null,null,31229351.064613473,61]
[519083600.76837301,1,null,null,240973645.95665911,8,null,null,409893855.53487355,14,null,null,489358086.62300968,2,null,null,403452012.19844818,2,null,null,145700642.09135917,31,null,null,218160332.71361867,4,null,null,40452465.830651268,147,null,null,32010084.841228809,57]
[531744176.3968699,1,null,null,246851051.95560202,5,null,null,419891266.64548022,14,null,null,501293649.71137577,1,null,null,413292305.17889816,5,null,null,149254316.2887094,25,null,null,223481316.43834108,5,null,null,41439111.338715933,157,null,null,32790818.617844146,41]
[544404752.02536678,1,null,null,252728457.95454493,8,null,null,429888677.75608689,18,null,null,513229212.79974186,4,null,null,423132598.15934813,4,null,null,152807990.48605964,22,null,null,228802300.1630635,0,null,null,42425756.846780598,97,null,null,33571552.394459486,43]
[557065327.65386367,0,null,null,258605863.95348784,5,null,null,439886088.86669356,9,null,null,525164775.88810796,0,null,null,432972891.1397981,3,null,null,156361664.68340987,20,null,null,234123283.88778591,1,null,null,43412402.354845263,113,null,null,34352286.171074823,30]
[569725903.28236055,0,null,null,264483269.95243075,6,null,null,449883499.97730023,10,null,null,537100338.97647405,6,null,null,442813184.12024808,3,null,null,159915338.8807601,19,null,null,239444267.61250833,2,null,null,44399047.862909928,127,null,null,35133019.947690159,31]
[582386478.91085744,1,null,null,270360675.95137364,3,null,null,459880911.0879069,5,null,null,549035902.06484008,2,null,null,452653477.10069805,2,null,null,163469013.07811034,16,null,null,244765251.33723074,2,null,null,45385693.370974593,81,null,null,35913753.724305496,34]
[595047054.53935432,0,null,null,276238081.95031655,2,null,null,469878322.19851357,5,null,null,560971465.15320611,0,null,null,462493770.08114803,1,null,null,167022687.27546057,13,null,null,250086235.06195316,1,null,null,46372338.879039258,74,null,null,36694487.500920832,28]
[607707630.16785121,0,null,null,282115487.94925946,5,null,null,479875733.30912024,2,null,null,572907028.24157214,2,null,null,472334063.061598,2,null,null,170576361.4728108,10,null,null,255407218.78667557,2,null,null,47358984.387103923,88,null,null,37475221.277536169,23]
[620368205.79634809,0,null,null,287992893.94820237,1,null,null,489873144.41972691,5,null,null,584842591.32993817,1,null,null,482174356.04204798,0,null,null,174130035.67016104,18,null,null,260728202.51139799,0,null,null,48345629.895168588,60,null,null,38255955.054151505,29]
[633028781.42484498,0,null,null,293870299.94714528,2,null,null,499870555.53033358,2,null,null,596778154.4183042,0,null,null,492014649.02249795,0,null,null,177683709.86751127,17,null,null,266049186.2361204,0,null,null,49332275.403233252,68,null,null,39036688.830766842,24]
[645689357.05334187,0,null,null,299747705.94608819,3,null,null,509867966.64094025,6,null,null,608713717.50667024,2,null,null,501854942.00294793,0,null,null,181237384.06486151,10,null,null,271370169.96084279,1,null,null,50318920.911297917,51,null,null,39817422.607382178,24]
[658349932.68183875,0,null,null,305625111.94503111,6,null,null,519865377.75154692,2,null,null,620649280.59503627,1,null,null,511695234.9833979,1,null,null,184791058.26221174,7,null,null,276691153.68556517,1,null,null,51305566.419362582,50,null,null,40598156.383997515,16]
[671010508.31033564,0,null,null,311502517.94397402,3,null,null,529862788.86215359,1,null,null,632584843.6834023,3,null,null,521535527.96384788,0,null,null,188344732.45956197,6,null,null,282012137.41028756,1,null,null,52292211.927427247,63,null,null,41378890.160612851,21]
[683671083.93883252,0,null,null,317379923.94291693,2,null,null,539860199.97276032,3,null,null,644520406.77176833,0,null,null,531375820.94429785,0,null,null,191898406.65691221,5,null,null,287333121.13500994,0,null,null,53278857.435491912,40,null,null,42159623.937228188,17]
[696331659.56732941,0,null,null,323257329.94185984,2,null,null,549857611.08336699,0,null,null,656455969.86013436,0,null,null,541216113.92474782,2,null,null,195452080.85426244,10,null,null,292654104.85973233,0,null,null,54265502.943556577,43,null,null,42940357.713843524,13]
[708992235.19582629,0,null,null,329134735.94080275,4,null,null,559855022.19397366,4,null,null,668391532.94850039,0,null,null,551056406.90519774,1,null,null,199005755.05161268,0,null,null,297975088.58445472,0,null,null,55252148.451621242,31,null,null,43721091.490458861,11]
[721652810.82432318,0,null,null,335012141.93974566,1,null,null,569852433.30458033,5,null,null,680327096.03686643,0,null,null,560896699.88564765,1,null,null,202559429.24896291,1,null,null,303296072.3091771,0,null,null,56238793.959685907,41,null,null,44501825.267074198,12]
[734313386.45282006,0,null,null,340889547.93868858,1,null,null,579849844.415187,3,null,null,692262659.12523246,1,null,null,570736992.86609757,0,null,null,206113103.44631314,3,null,null,308617056.03389949,0,null,null,57225439.467750572,35,null,null,45282559.043689534,10]
[746973962.08131695,0,null,null,346766953.93763149,1,null,null,589847255.52579367,0,null,null,704198222.21359849,2,null,null,580577285.84654748,2,null,null,209666777.64366338,3,null,null,313938039.75862187,0,null,null,58212084.975815237,21,null,null,46063292.820304871,13]
[759634537.70981383,0,null,null,352644359.9365744,2,null,null,599844666.63640034,2,null,null,716133785.30196452,0,null,null,590417578.8269974,0,null,null,213220451.84101361,4,null,null,319259023.48334426,0,null,null,59198730.483879901,29,null,null,46844026.596920207,9]
[772295113.33831072,0,null,null,358521765.93551731,1,null,null,609842077.74700701,2,null,null,728069348.39033055,2,null,null,600257871.80744731,1,null,null,216774126.03836384,2,null,null,324580007.20806664,0,null,null,60185375.991944566,28,null,null,47624760.373535544,10]
[784955688.9668076,0,null,null,364399171.93446022,1,null,null,619839488.85761368,1,null,null,740004911.47869658,0,null,null,610098164.78789723,0,null,null,220327800.23571408,3,null,null,329900990.93278903,0,null,null,61172021.500009231,23,null,null,48405494.15015088,3]
[797616264.59530449,0,null,null,370276577.93340313,0,null,null,629836899.96822035,2,null,null,751940474.56706262,0,null,null,619938457.76834714,0,null,null,223881474.43306431,2,null,null,335221974.65751141,0,null,null,62158667.008073896,26,null,null,49186227.926766217,9]
[810276840.22380137,0,null,null,376153983.93234605,0,null,null,639834311.07882702,3,null,null,763876037.65542865,1,null,null,629778750.74879706,0,null,null,227435148.63041455,4,null,null,340542958.3822338,0,null,null,63145312.516138561,18,null,null,49966961.703381553,1]
[822937415.85229826,0,null,null,382031389.93128896,0,null,null,649831722.18943369,2,null,null,775811600.74379468,0,null,null,639619043.72924697,0,null,null,230988822.82776478,3,null,null,345863942.10695618,0,null,null,64131958.024203226,15,null,null,50747695.47999689,5]
[835597991.48079515,0,null,null,387908795.93023187,0,null,null,659829133.30004036,3,null,null,787747163.83216071,0,null,null,649459336.70969689,0,null,null,234542497.02511501,1,null,null,351184925.83167857,0,null,null,65118603.532267891,16,null,null,51528429.256612226,8]
[848258567.10929203,0,null,null,393786201.92917478,0,null,null,669826544.41064703,2,null,null,799682726.92052674,0,null,null,659299629.6901468,0,null,null,238096171.22246525,0,null,null,356505909.55640095,0,null,null,66105249.040332556,10,null,null,52309163.033227563,3]
[860919142.73778892,0,null,null,399663607.92811769,0,null,null,679823955.52125371,0,null,null,811618290.00889277,0,null,null,669139922.67059672,0,null,null,241649845.41981548,2,null,null,361826893.28112334,1,null,null,67091894.548397221,12,null,null,53089896.809842899,6]
[873579718.3662858,0,null,null,405541013.9270606,0,null,null,689821366.63186038,0,null,null,823553853.09725881,0,null,null,678980215.65104663,0,null,null,245203519.61716571,2,null,null,367147877.00584573,0,null,null,68078540.056461886,16,null,null,53870630.586458236,1]
[886240293.99478269,0,null,null,411418419.92600352,2,null,null,699818777.74246705,1,null,null,835489416.18562484,0,null,null,688820508.63149655,0,null,null,248757193.81451595,2,null,null,372468860.73056811,0,null,null,69065185.564526558,11,null,null,54651364.363073573,3]
[898900869.62327957,0,null,null,417295825.92494643,1,null,null,709816188.85307372,0,null,null,847424979.27399087,0,null,null,698660801.61194646,0,null,null,252310868.01186618,2,null,null,377789844.4552905,0,null,null,70051831.07259123,7,null,null,55432098.139688909,5]
[911561445.25177646,0,null,null,423173231.92388934,0,null,null,719813599.96368039,0,null,null,859360542.3623569,0,null,null,708501094.59239638,0,null,null,255864542.20921642,1,null,null,383110828.18001288,0,null,null,71038476.580655903,7,null,null,56212831.916304246,2]
[924222020.88027334,0,null,null,429050637.92283225,0,null,null,729811011.07428706,0,null,null,871296105.45072293,0,null,null,718341387.57284629,0,null,null,259418216.40656665,2,null,null,388431811.90473527,0,null,null,72025122.088720575,3,null,null,56993565.692919582,2]
[936882596.50877023,0,null,null,434928043.92177516,2,null,null,739808422.18489373,2,null,null,883231668.53908896,0,null,null,728181680.55329621,0,null,null,262971890.60391688,0,null,null,393752795.62945765,0,null,null,73011767.596785247,3,null,null,57774299.469534919,5]
[949543172.13726711,0,null,null,440805449.92071807,0,null,null,749805833.2955004,0,null,null,895167231.627455,0,null,null,738021973.53374612,0,null,null,266525564.80126712,0,null,null,399073779.35418004,0,null,null,73998413.10484992,6,null,null,58555033.246150255,3]
[962203747.765764,0,null,null,446682855.91966099,0,null,null,759803244.40610707,0,null,null,907102794.71582103,1,null,null,747862266.51419604,0,null,null,270079238.99861735,0,null,null,404394763.07890242,0,null,null,74985058.612914592,3,null,null,59335767.022765592,2]
[974864323.39426088,0,null,null,452560261.9186039,0,null,null,769800655.51671374,0,null,null,919038357.80418706,0,null,null,757702559.49464595,0,null,null,273632913.19596756,2,null,null,409715746.80362481,0,null,null,75971704.120979264,3,null,null,60116500.799380928,4]
[987524899.02275777,0,null,null,458437667.91754681,0,null,null,779798066.62732041,0,null,null,930973920.89255309,0,null,null,767542852.47509587,0,null,null,277186587.39331776,0,null,null,415036730.52834719,0,null,null,76958349.629043937,4,null,null,60897234.575996265,0]
[1000185474.6512547,0,null,null,464315073.91648972,0,null,null,789795477.73792708,0,null,null,942909483.98091912,0,null,null,777383145.45554578,1,null,null,280740261.59066796,2,null,null,420357714.25306958,0,null,null,77944995.137108609,4,null,null,61677968.352611601,0]
[1012846050.2797515,0,null,null,470192479.91543263,0,null,null,799792888.84853375,1,null,null,954845047.06928515,0,null,null,787223438.4359957,1,null,null,284293935.78801817,0,null,null,425678697.97779197,0,null,null,78931640.645173281,2,null,null,62458702.129226938,0]
[1025506625.9082484,0,null,null,476069885.91437554,2,null,null,809790299.95914042,0,null,null,966780610.15765119,1,null,null,797063731.41644561,0,null,null,287847609.98536837,0,null,null,430999681.70251435,0,null,null,79918286.153237954,2,null,null,63239435.905842274,1]
[1038167201.5367453,0,null,null,481947291.91331846,0,null,null,819787711.06974709,0,null,null,978716173.24601722,0,null,null,806904024.39689553,0,null,null,291401284.18271858,1,null,null,436320665.42723674,0,null,null,80904931.661302626,4,null,null,64020169.682457611,1]
[1050827777.1652422,0,null,null,487824697.91226137,0,null,null,829785122.18035376,1,null,null,990651736.33438325,0,null,null,816744317.37734544,0,null,null,294954958.38006878,0,null,null,441641649.15195912,1,null,null,81891577.169367298,1,null,null,64800903.459072948,1]
[1063488352.7937391,0,null,null,493702103.91120428,0,null,null,839782533.29096043,0,null,null,1002587299.4227493,0,null,null,826584610.35779536,1,null,null,298508632.57741898,1,null,null,446962632.87668151,0,null,null,82878222.677431971,7,null,null,65581637.235688284,1]
[1076148928.422236,0,null,null,499579509.91014719,0,null,null,849779944.4015671,1,null,null,1014522862.5111153,0,null,null,836424903.33824527,0,null,null,302062306.77476919,2,null,null,452283616.60140389,0,null,null,83864868.185496643,3,null,null,66362371.012303621,1]
[1088809504.0507329,0,null,null,505456915.9090901,0,null,null,859777355.51217377,0,null,null,1026458425.5994813,0,null,null,846265196.31869519,0,null,null,305615980.97211939,0,null,null,457604600.32612628,0,null,null,84851513.693561316,4,null,null,67143104.788918957,0]
[1101470079.6792297,0,null,null,511334321.90803301,0,null,null,869774766.62278044,0,null,null,1038393988.6878474,0,null,null,856105489.2991451,0,null,null,309169655.16946959,0,null,null,462925584.05084866,0,null,null,85838159.201625988,1,null,null,67923838.565534294,0]
[1114130655.3077266,0,null,null,517211727.90697592,0,null,null,879772177.73338711,0,null,null,1050329551.7762134,0,null,null,865945782.27959502,0,null,null,312723329.3668198,0,null,null,468246567.77557105,0,null,null,86824804.70969066,2,null,null,68704572.34214963,0]
[1126791230.9362235,1,null,null,523089133.90591884,0,null,null,889769588.84399378,0,null,null,1062265114.8645794,0,null,null,875786075.26004493,0,null,null,316277003.56417,0,null,null,473567551.50029343,0,null,null,87811450.217755333,0,null,null,69485306.118764967,0]
[1139451806.5647204,0,null,null,528966539.90486175,0,null,null,899766999.95460045,1,null,null,1074200677.9529455,0,null,null,885626368.24049485,0,null,null,319830677.76152021,0,null,null,478888535.22501582,0,null,null,88798095.725820005,1,null,null,70266039.895380303,0]
[1152112382.1932173,0,null,null,534843945.90380466,1,null,null,909764411.06520712,1,null,null,1086136241.0413115,0,null,null,895466661.22094476,0,null,null,323384351.95887041,0,null,null,484209518.9497382,0,null,null,89784741.233884677,2,null,null,71046773.67199564,1]
[1164772957.8217142,0,null,null,540721351.90274751,0,null,null,919761822.17581379,0,null,null,1098071804.1296775,0,null,null,905306954.20139468,0,null,null,326938026.15622061,0,null,null,489530502.67446059,0,null,null,90771386.74194935,0,null,null,71827507.448610976,0]
[1177433533.450211,0,null,null,546598757.90169036,0,null,null,929759233.28642046,0,null,null,1110007367.2180436,0,null,null,915147247.18184459,0,null,null,330491700.35357082,0,null,null,494851486.39918298,0,null,null,91758032.250014022,0,null,null,72608241.225226313,0]
[1190094109.0787079,0,null,null,552476163.90063322,0,null,null,939756644.39702713,0,null,null,1121942930.3064096,0,null,null,924987540.16229451,0,null,null,334045374.55092102,0,null,null,500172470.12390536,0,null,null,92744677.758078694,0,null,null,73388975.001841649,1]
[1202754684.7072048,0,null,null,558353569.89957607,0,null,null,949754055.50763381,0,null,null,1133878493.3947756,0,null,null,934827833.14274442,0,null,null,337599048.74827123,0,null,null,505493453.84862775,0,null,null,93731323.266143367,0,null,null,74169708.778456986,1]
[1215415260.3357017,0,null,null,564230975.89851892,0,null,null,959751466.61824048,0,null,null,1145814056.4831417,0,null,null,944668126.12319434,0,null,null,341152722.94562143,0,null,null,510814437.57335013,0,null,null,94717968.774208039,0,null,null,74950442.555072322,0]
[1228075835.9641986,0,null,null,570108381.89746177,0,null,null,969748877.72884715,0,null,null,1157749619.5715077,0,null,null,954508419.10364425,0,null,null,344706397.14297163,0,null,null,516135421.29807252,0,null,null,95704614.282272711,0,null,null,75731176.331687659,0]
[1240736411.5926955,0,null,null,575985787.89640462,0,null,null,979746288.83945382,0,null,null,1169685182.6598737,0,null,null,964348712.08409417,0,null,null,348260071.34032184,0,null,null,521456405.0227949,0,null,null,96691259.790337384,0,null,null,76511910.108302996,0]
[1253396987.2211945,1,null,null,581863193.89534724,1,null,null,989743699.95006084,1,null,null,1181620745.7482429,1,null,null,974189005.06454468,1,null,null,351813745.53767222,1,null,null,526777388.74751776,1,null,null,97677905.298401892,2,null,null,77292643.884918392,1]

{"sheet":"Simulation Output 2","index":13,"n_rows":45,"n_cols":10,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
[]
["Loss Distribution","Base Case Scenario","ST1 Ignore Future","ST2 Protect Future","ST3 More Growth","ST4 More Fires","Fire Trail","Fire Control Tower","Rezone Land","Prescribed Burning"]
["Mean",75559826.096516326,47668002.87721362,120411753.50329809,103637781.32385445,89448358.803314388,51590905.254892781,51908492.431469552,25958105.440104097,12684067.57608914]
["Median",61254661.920802854,34740851.082482338,99636505.473408937,86050689.089317411,74842849.431319654,44286972.008320265,44687810.105679959,23899330.342254326,10869311.447637372]
["Standard Deviation",61584777.117283583,47340847.091868497,91887684.616618723,83366435.899804696,66674199.753330588,36289635.071674474,36297314.634564079,14585905.100323666,10119169.02081541]
["90% of loss",153860186.74246386,101545433.82526977,237699091.96187654,201876314.12151051,170324698.3707979,98470416.665094003,98835146.633544624,45456212.577669457,26403765.214031398]
["95% of loss",192775740.82866418,132466406.97383252,293803766.55438131,252099939.4273932,214883818.72359696,120945506.97856481,119681609.65046753,53050721.328026511,32102202.815234412]
["99% of loss",293292705.36291546,219803376.82483539,424399099.06348258,377849401.13759422,319977268.53755754,170133999.77260506,172362546.37496787,67153972.487204984,43265296.920782745]
[]
["Benefit"]
["Benefit (Mean)",null,null,null,null,null,{"$f":"$B$3 - $G$3","v":23968920.841623545},{"$f":"$B$3 - $H$3","v":23651333.665046774},{"$f":"$B$3 - $I$3","v":49601720.656412229},{"$f":"$B$3 - $J$3","v":62875758.520427182}]
["Benefit (95%)",null,null,null,null,null,{"$f":"$B$7 - $G$7","v":71830233.85009937},{"$f":"$B$7 - $H$7","v":73094131.178196654},{"$f":"$B$7 - $I$7","v":139725019.50063768},{"$f":"$B$7 - $J$7","v":160673538.01342976}]
["Costs"]
["Option Cost",null,null,null,null,null,3104056.1658196975,13486739.898363747,71622.46632787917,25973479.796727493]
["Net Benefit"]
["Net Benefit (Mean)",null,null,null,null,null,{"$f":"$G$11 - $G$14","v":20864864.675803848},{"$f":"$H$11 - $H$14","v":10164593.766683027},{"$f":"$I$11 - $I$14","v":49530098.190084353},{"$f":"$J$11 - $J$14","v":36902278.723699689}]
["Net Benefit (95%)",null,null,null,null,null,{"$f":"$G$12 - $G$14","v":68726177.684279665},{"$f":"$H$12 - $H$14","v":59607391.279832907},{"$f":"$I$12 - $I$14","v":139653397.0343098},{"$f":"$J$12 - $J$14","v":134700058.21670228}]
[]
["Input parameters"]
["Simulation"]
["Years",40,40,40,40,40,40,40,40,40]
["Discount Rate",0.06,0.1,0.03,0.06,0.06,0.06,0.06,0.06,0.06]
["Growth Rate",0.02,0.02,0.02,0.04,0.02,0.02,0.02,0.02,0.02]
["Change in Frequency",0,0,0,0,0.5]
["Number of Simulations",10000,10000,10000,10000,10000,10000,10000,10000,10000]
["Frequency"]
["Events per Year",0.1]
["Lower Bound",6.6666669999999997E-2]
["Upper Bound",0.14285713999999999]
["Probability",0.66666667000000002]
["Observed No. of Years",10]
["Observed No. of Events",2]
["Estimated Frequency",0.11305393355632594,0.11305393355632594,0.11305393355632594,0.11305393355632594,0.11305393355632594,0.11305393355632594,0.11305393355632594,0.11305393355632594,5.6526966778162969E-2]
["Frequency Reduction",null,null,null,null,null,0,0,0,0.5]
["Severity"]
["Median",20000000,20000000,20000000,20000000,20000000,16000000,16000000,10000000,10000000]
["Worst Case (95%)",100000000,100000000,100000000,100000000,100000000,60000000,60000000,19999999.999999996,19999999.999999996]
["Change in Median",null,0,0,0,0,-0.2,-0.2,-0.5,-0.5]
["Change in Worst Case",null,0,0,0,0,-0.4,-0.4,-0.8,-0.8]
["Distribution","Lognormal","Lognormal","Lognormal","Lognormal","Lognormal","Lognormal","Lognormal","Lognormal","Lognormal"]
["Mu",16.811242831518264,16.811242831518264,16.811242831518264,16.811242831518264,16.811242831518264,16.588099280204055,16.588099280204055,16.11809565095832,16.11809565095832]
["Sigma",0.97846877440212909,0.97846877440212909,0.97846877440212909,0.97846877440212909,0.97846877440212909,0.80357049303653072,0.80357049303653072,0.42140356394179851,0.42140356394179851]
["Costs"]
["Capital",null,null,null,null,null,3000000,1000000,30000,1000000]
["Maintenance",null,null,null,null,null,5000,600000,2000,1200000]

{"sheet":"Simulation Output 2 Graph Data","index":14,"n_rows":102,"n_cols":36,"rows_kept":102,"cut":false,"hidden":true,"merged":[]}
[{"$f":"'Simulation Output 2'!$B$2","v":"Base Case Scenario"},"Loss Distribution",{"$f":"'Simulation Output 2'!$B$2","v":"Base Case Scenario"},"Cumulative Loss",{"$f":"'Simulation Output 2'!$C$2","v":"ST1 Ignore Future"},"Loss Distribution",{"$f":"'Simulation Output 2'!$C$2","v":"ST1 Ignore Future"},"Cumulative Loss",{"$f":"'Simulation Output 2'!$D$2","v":"ST2 Protect Future"},"Loss Distribution",{"$f":"'Simulation Output 2'!$D$2","v":"ST2 Protect Future"},"Cumulative Loss",{"$f":"'Simulation Output 2'!$E$2","v":"ST3 More Growth"},"Loss Distribution",{"$f":"'Simulation Output 2'!$E$2","v":"ST3 More Growth"},"Cumulative Loss",{"$f":"'Simulation Output 2'!$F$2","v":"ST4 More Fires"},"Loss Distribution",{"$f":"'Simulation Output 2'!$F$2","v":"ST4 More Fires"},"Cumulative Loss",{"$f":"'Simulation Output 2'!$G$2","v":"Fire Trail"},"Loss Distribution",{"$f":"'Simulation Output 2'!$G$2","v":"Fire Trail"},"Cumulative Loss",{"$f":"'Simulation Output 2'!$H$2","v":"Fire Control Tower"},"Loss Distribution",{"$f":"'Simulation Output 2'!$H$2","v":"Fire Control Tower"},"Cumulative Loss",{"$f":"'Simulation Output 2'!$I$2","v":"Rezone Land"},"Loss Distribution",{"$f":"'Simulation Output 2'!$I$2","v":"Rezone Land"},"Cumulative Loss",{"$f":"'Simulation Output 2'!$J$2","v":"Prescribed Burning"},"Loss Distribution",{"$f":"'Simulation Output 2'!$J$2","v":"Prescribed Burning"},"Cumulative Loss"]
["Bins","Frequency","Year","Yearly Loss","Bins","Frequency","Year","Yearly Loss","Bins","Frequency","Year","Yearly Loss","Bins","Frequency","Year","Yearly Loss","Bins","Frequency","Year","Yearly Loss","Bins","Frequency","Year","Yearly Loss","Bins","Frequency","Year","Yearly Loss","Bins","Frequency","Year","Yearly Loss","Bins","Frequency","Year","Yearly Loss"]
[0,117,1,3774420.2117441772,0,89,1,3728256.6496093334,0,122,1,3632330.1203128113,0,102,1,3639845.5885988683,0,27,1,3582563.9018056188,0,124,1,5364091.8749997672,0,103,1,4183528.6870720312,0,112,1,1250254.0770169564,0,1019,1,2872413.2284009308]
[8021807.9897150099,344,2,7075237.2804395072,8021807.9897150099,998,2,7041833.761778214,8021807.9897150099,132,2,7169853.740613386,8021807.9897150099,193,2,7166555.7599565713,8021807.9897150099,149,2,7102041.9617962297,8021807.9897150099,411,2,7737882.9027294936,8021807.9897150099,409,2,7023422.3366555292,8021807.9897150099,742,2,2492211.9999162513,8021807.9897150099,2828,2,4582103.8322092108]
[16043615.97943002,565,3,10432033.55876825,16043615.97943002,1235,3,10186798.839516373,16043615.97943002,269,3,10635173.242957849,16043615.97943002,339,3,10717579.227940487,16043615.97943002,342,3,10437574.441935448,16043615.97943002,762,3,10054078.596032396,16043615.97943002,788,3,10011795.31771072,16043615.97943002,1861,3,3611792.559656857,16043615.97943002,3029,3,6265007.1735196598]
[24065423.96914503,680,4,13762561.098311357,24065423.96914503,1255,4,13327069.969765203,24065423.96914503,295,4,13985288.897405075,24065423.96914503,395,4,13925444.233973559,24065423.96914503,486,4,13890026.502117895,24065423.96914503,988,4,12169453.511568982,24065423.96914503,1024,4,12886732.977690905,24065423.96914503,2325,4,4738110.1363222077,24065423.96914503,1810,4,7879726.5345324399]
[32087231.95886004,697,5,17165869.131026562,32087231.95886004,1121,5,15918771.230720835,32087231.95886004,394,5,17682596.999199912,32087231.95886004,456,5,17462400.579193041,32087231.95886004,568,5,16841057.137445651,32087231.95886004,1091,5,14309982.154381797,32087231.95886004,1057,5,15533884.856906531,32087231.95886004,1941,5,5818247.0665492974,32087231.95886004,812,5,9428590.1586254574]
[40109039.94857505,759,6,20273329.396558113,40109039.94857505,860,6,18468897.229297459,40109039.94857505,396,6,20817155.695759062,40109039.94857505,536,6,20757228.544549741,40109039.94857505,628,6,19705699.967206612,40109039.94857505,1080,6,16501416.948488723,40109039.94857505,1057,6,18215876.3440587,40109039.94857505,1388,6,6856792.463093658,40109039.94857505,347,6,10913718.496927653]
[48130847.93829006,738,7,23145363.516587332,48130847.93829006,793,7,20707270.824619997,48130847.93829006,440,7,24255559.068354573,48130847.93829006,508,7,24282850.063698199,48130847.93829006,618,7,22686714.05558411,48130847.93829006,970,7,18460508.572845414,48130847.93829006,963,7,20652695.73955936,48130847.93829006,841,7,7870420.0222077854,48130847.93829006,107,7,12337262.862739798]
[56152655.928005069,711,8,25788411.704674121,56152655.928005069,645,8,22833130.494828388,56152655.928005069,459,8,27562570.804975506,56152655.928005069,581,8,27593362.745109454,56152655.928005069,633,8,25731810.493059829,56152655.928005069,893,8,20334362.398341995,56152655.928005069,863,8,23087033.961283371,56152655.928005069,426,8,8774934.3790219445,56152655.928005069,32,8,13689011.215159878]
[64174463.917720079,611,9,28463779.47285321,64174463.917720079,520,9,24732660.368898507,64174463.917720079,469,9,30890796.647998348,64174463.917720079,497,9,30865874.643970534,64174463.917720079,685,9,28807661.792675961,64174463.917720079,803,9,22159263.054528423,64174463.917720079,754,9,25284982.042934496,64174463.917720079,218,9,9672209.6574425884,64174463.917720079,8,9,15016120.271741319]
[72196271.907435089,644,10,30935695.893325791,72196271.907435089,493,10,26513441.236108467,72196271.907435089,474,10,34367969.280165844,72196271.907435089,528,10,33890720.035232812,72196271.907435089,670,10,31979781.582504164,72196271.907435089,629,10,24056108.993085209,72196271.907435089,608,10,27414173.595728271,72196271.907435089,95,10,10530078.681958031,72196271.907435089,5,10,16282226.406624654]
[80218079.897150099,510,11,33525827.415848259,80218079.897150099,332,11,28243630.364673533,80218079.897150099,463,11,37641992.231053196,80218079.897150099,498,11,36833177.622584499,80218079.897150099,599,11,34826672.639427915,80218079.897150099,504,11,25777852.771910653,80218079.897150099,532,11,29486347.147146434,80218079.897150099,35,11,11393745.645629922,80218079.897150099,3,11,17500307.100183431]
[88239887.886865109,504,12,35783610.793753795,88239887.886865109,261,12,29798784.43834608,88239887.886865109,482,12,40635437.551435113,88239887.886865109,505,12,39497232.363278195,88239887.886865109,544,12,37610378.043774292,88239887.886865109,363,12,27463974.987481564,88239887.886865109,448,12,31442631.848974004,88239887.886865109,12,12,12215551.621047163,88239887.886865109,0,12,18686948.254420269]
[96261695.876580119,435,13,38138593.450702682,96261695.876580119,255,13,31256258.354910493,96261695.876580119,429,13,43866650.318210326,96261695.876580119,465,13,42289545.014489442,96261695.876580119,528,13,40238093.844532922,96261695.876580119,316,13,28982263.123448219,96261695.876580119,310,13,33384885.757315826,96261695.876580119,2,13,13026383.412842307,96261695.876580119,0,13,19812807.853912268]
[104283503.86629513,353,14,40323767.029858053,104283503.86629513,217,14,32677525.501087867,104283503.86629513,414,14,46955080.572667636,104283503.86629513,409,14,44825856.265803322,104283503.86629513,447,14,42857980.74584455,104283503.86629513,241,14,30548641.917863391,104283503.86629513,249,14,35312058.246686332,104283503.86629513,1,14,13822279.650207829,104283503.86629513,0,14,20918424.551025175]
[112305311.85601014,326,15,42369018.999221288,112305311.85601014,166,15,33896284.643506296,112305311.85601014,410,15,50188721.997952551,112305311.85601014,382,15,47916611.169351712,112305311.85601014,376,15,45259519.556546047,112305311.85601014,184,15,32027270.946424238,112305311.85601014,199,15,36982480.417860828,112305311.85601014,1,15,14564139.321323186,112305311.85601014,0,15,21985949.52960068]
[120327119.84572515,260,16,44369931.95163615,120327119.84572515,110,16,35102420.845365427,120327119.84572515,377,16,53534211.319180638,120327119.84572515,401,16,50567037.518412121,120327119.84572515,322,16,47669830.511191636,120327119.84572515,132,16,33456908.211825315,120327119.84572515,148,16,38702187.127129726,120327119.84572515,0,16,15232106.99984291,120327119.84572515,0,16,22984808.312570892]
[128348927.83544016,208,17,46318259.455731325,128348927.83544016,102,17,36195553.817762971,128348927.83544016,335,17,56604971.509714425,128348927.83544016,345,17,53101197.196919203,128348927.83544016,320,17,50072810.402620502,128348927.83544016,118,17,34827197.535039231,128348927.83544016,106,17,40400967.182010956,128348927.83544016,0,17,15894995.853924638,128348927.83544016,0,17,23967507.929087669]
[136370735.82515517,191,18,48113222.530325949,136370735.82515517,86,18,37281568.946163572,136370735.82515517,294,18,59779077.339275822,136370735.82515517,308,18,55784754.95178704,136370735.82515517,264,18,52432226.974552244,136370735.82515517,88,18,36083119.811528914,136370735.82515517,80,18,42002115.014143057,136370735.82515517,0,18,16511873.446778867,136370735.82515517,0,18,24906884.90818689]
[144392543.81487018,173,19,49895847.096543029,144392543.81487018,80,19,38180566.759722352,144392543.81487018,298,19,63005102.57710211,144392543.81487018,278,19,58420087.909741774,144392543.81487018,252,19,54787619.766628079,144392543.81487018,54,19,37323268.342034765,144392543.81487018,55,19,43557080.155749574,144392543.81487018,0,19,17159629.488301795,144392543.81487018,0,19,25809560.914456438]
[152414351.80458519,152,20,51690342.686695464,152414351.80458519,73,20,39028641.748916559,152414351.80458519,265,20,66095423.555506475,152414351.80458519,240,20,61028261.110269085,152414351.80458519,205,20,56898769.177646481,152414351.80458519,60,20,38479075.233506136,152414351.80458519,51,20,45005675.375530414,152414351.80458519,0,20,17761858.858802501,152414351.80458519,0,20,26678600.869381495]
[160436159.7943002,147,21,53248423.356311291,160436159.7943002,45,21,39804114.816230394,160436159.7943002,254,21,68958325.28072004,160436159.7943002,230,21,63528861.661916211,160436159.7943002,166,21,59044224.580367096,160436159.7943002,46,21,39698013.98034279,160436159.7943002,50,21,46388059.930318698,160436159.7943002,0,21,18336217.686806832,160436159.7943002,0,21,27511748.503098525]
[168457967.78401521,120,22,54867118.611850657,168457967.78401521,38,22,40617124.48353868,168457967.78401521,253,22,72025484.588896766,168457967.78401521,183,22,66213138.498876072,168457967.78401521,148,22,61095367.181153022,168457967.78401521,32,22,40812012.776921131,168457967.78401521,31,22,47738437.197708674,168457967.78401521,0,22,18876546.362929642,168457967.78401521,0,22,28318299.72733197]
[176479775.77373022,113,23,56459020.960208252,176479775.77373022,38,23,41283877.247437678,176479775.77373022,194,23,74695276.241417378,176479775.77373022,187,23,68638775.108461127,176479775.77373022,110,23,63023339.62636847,176479775.77373022,29,23,41968564.793691352,176479775.77373022,30,23,49081204.729722753,176479775.77373022,0,23,19409874.716630161,176479775.77373022,0,23,29092033.190644488]
[184501583.76344523,76,24,57748857.251429759,184501583.76344523,25,24,41906517.263154648,184501583.76344523,182,24,78005737.947626084,184501583.76344523,168,24,71002205.580652341,184501583.76344523,109,24,65015123.788411975,184501583.76344523,17,24,42898440.272443824,184501583.76344523,20,24,50274743.628201433,184501583.76344523,0,24,19905877.325527765,184501583.76344523,0,24,29842881.151352227]
[192523391.75316024,63,25,59177563.638410464,192523391.75316024,20,25,42525181.389985301,192523391.75316024,167,25,80810827.641130328,192523391.75316024,134,25,73448905.117343768,192523391.75316024,79,25,66896451.365951225,192523391.75316024,17,25,43844495.276619874,192523391.75316024,20,25,51529283.704508238,192523391.75316024,0,25,20407140.15893035,192523391.75316024,0,25,30560763.039558321]
[200545199.74287525,66,26,60726217.032252371,200545199.74287525,12,26,43058590.186642557,200545199.74287525,164,26,83805840.481867909,200545199.74287525,107,26,75692326.139369994,200545199.74287525,89,26,68717599.18969132,200545199.74287525,6,26,44806885.836593032,200545199.74287525,13,26,52729228.341391623,200545199.74287525,0,26,20900302.503158197,200545199.74287525,0,26,31265584.475831021]
[208567007.73259026,49,27,62063497.430444486,208567007.73259026,19,27,43548649.7266597,208567007.73259026,129,27,86618989.953822553,208567007.73259026,124,27,77909037.666342556,208567007.73259026,79,27,70578245.71863994,208567007.73259026,9,27,45694059.871493369,208567007.73259026,8,27,53881115.736188553,208567007.73259026,0,27,21381138.623994384,208567007.73259026,0,27,31936090.033933815]
[216588815.72230527,57,28,63357826.141516224,216588815.72230527,8,28,44063085.283590503,216588815.72230527,133,28,89489945.123556346,216588815.72230527,82,28,80271382.28816776,216588815.72230527,69,28,72535232.141055033,216588815.72230527,8,28,46558689.843759343,216588815.72230527,5,28,54946101.430937186,216588815.72230527,0,28,21816668.345835861,216588815.72230527,0,28,32568415.781933859]
[224610623.71202028,37,29,64613438.562728256,224610623.71202028,8,29,44490901.562021323,224610623.71202028,124,29,92019210.10361369,224610623.71202028,92,29,82435244.814620897,224610623.71202028,64,29,74309685.568323135,224610623.71202028,3,29,47418723.904404506,224610623.71202028,2,29,56012504.937063515,224610623.71202028,0,29,22241103.282272991,224610623.71202028,0,29,33182959.803997666]
[232632431.70173529,41,30,65854857.59878733,232632431.70173529,10,30,44926117.508289233,232632431.70173529,110,30,94772486.559611455,232632431.70173529,89,30,84500550.925672263,232632431.70173529,61,30,75725387.827738181,232632431.70173529,7,30,48208643.911996774,232632431.70173529,2,30,57043744.958009526,232632431.70173529,0,30,22654790.829726622,232632431.70173529,0,30,33780226.205581315]
[240654239.6914503,33,31,67030501.737954907,240654239.6914503,9,31,45300660.070147738,240654239.6914503,117,31,97376978.647659048,240654239.6914503,60,31,86480996.065063968,240654239.6914503,46,31,77280987.807210162,240654239.6914503,3,31,48981901.267921478,240654239.6914503,4,31,58044789.566891894,240654239.6914503,0,31,23073420.843454339,240654239.6914503,0,31,34363682.298538156]
[248676047.68116531,34,32,68200732.502919555,248676047.68116531,7,32,45646342.881330237,248676047.68116531,80,32,100077751.95973271,248676047.68116531,53,32,88560915.254113704,248676047.68116531,34,32,78847358.028612077,248676047.68116531,3,32,49725844.40614792,248676047.68116531,1,32,58922175.098132126,248676047.68116531,0,32,23459855.49611089,248676047.68116531,0,32,34919389.977147885]
[256697855.67088032,17,33,69265088.226119056,256697855.67088032,6,33,45961735.827570312,256697855.67088032,94,33,102715135.09289946,256697855.67088032,58,33,90601568.817512453,256697855.67088032,28,33,80441167.153477564,256697855.67088032,2,33,50414464.801890492,256697855.67088032,2,33,59861586.996449657,256697855.67088032,0,33,23848933.299542855,256697855.67088032,0,33,35450395.882372081]
[264719663.66059533,24,34,70238269.439451322,264719663.66059533,6,34,46242080.528612442,264719663.66059533,70,34,105261329.46434446,264719663.66059533,44,34,92614174.575528711,264719663.66059533,39,34,81853596.183122635,264719663.66059533,1,34,51102155.822575867,264719663.66059533,0,34,60754514.296436921,264719663.66059533,0,34,24196957.255328316,264719663.66059533,0,34,35979180.230330192]
[272741471.65031034,17,35,71159043.2238691,272741471.65031034,6,35,46528198.406417631,272741471.65031034,69,35,107740255.85310218,272741471.65031034,36,35,94489676.109400973,272741471.65031034,23,35,83285035.283889502,272741471.65031034,1,35,51749968.488351844,272741471.65031034,1,35,61562704.409066379,272741471.65031034,0,35,24536728.060033862,272741471.65031034,0,35,36474116.746591635]
[280763279.64002538,10,36,72047777.024758205,280763279.64002538,8,36,46789378.360262848,280763279.64002538,45,36,110382467.07121852,280763279.64002538,36,36,96355289.505082712,280763279.64002538,20,36,84628249.355339661,280763279.64002538,1,36,52365341.793833703,280763279.64002538,2,36,62411617.097616792,280763279.64002538,0,36,24842497.20453788,280763279.64002538,0,36,36949090.447020479]
[288785087.62974036,12,37,73056575.321915329,288785087.62974036,3,37,47046412.149601378,288785087.62974036,57,37,112697796.73282868,288785087.62974036,27,37,98341579.279464528,288785087.62974036,14,37,85870480.05163382,288785087.62974036,0,37,52986380.881293379,288785087.62974036,1,37,63196630.728352927,288785087.62974036,0,37,25147887.811569892,288785087.62974036,0,37,37411243.963287234]
[296806895.61945534,14,38,73930979.292491019,296806895.61945534,6,38,47263196.331093289,296806895.61945534,53,38,115290938.66776502,296806895.61945534,35,38,100134391.14209163,296806895.61945534,17,38,87089197.32043016,296806895.61945534,0,38,53587426.593387336,296806895.61945534,1,38,63953685.584393658,296806895.61945534,0,38,25461600.10774523,296806895.61945534,0,38,37846751.007458553]
[304828703.60917032,9,39,74788488.055054069,304828703.60917032,0,39,47470968.420521066,304828703.60917032,43,39,117779516.38056351,304828703.60917032,30,39,101907699.02562216,304828703.60917032,12,39,88285423.727235079,304828703.60917032,1,39,54138943.388993889,304828703.60917032,1,39,64672405.875640817,304828703.60917032,0,39,25739351.309129577,304828703.60917032,0,39,38263903.017874651]
[312850511.5988853,8,40,75559826.096516058,312850511.5988853,4,40,47668002.877213627,312850511.5988853,48,40,120411753.50329819,312850511.5988853,27,40,103637781.32385452,312850511.5988853,14,40,89448358.803314269,312850511.5988853,1,40,54694961.4207123,312850511.5988853,2,40,65395232.329832979,312850511.5988853,0,40,26029727.906431977,312850511.5988853,0,40,38657547.372816563]
[320872319.58860028,9,null,null,320872319.58860028,2,null,null,320872319.58860028,30,null,null,320872319.58860028,29,null,null,320872319.58860028,17,null,null,320872319.58860028,0,null,null,320872319.58860028,0,null,null,320872319.58860028,0,null,null,320872319.58860028,0]
[328894127.57831526,7,null,null,328894127.57831526,3,null,null,328894127.57831526,33,null,null,328894127.57831526,18,null,null,328894127.57831526,10,null,null,328894127.57831526,1,null,null,328894127.57831526,0,null,null,328894127.57831526,0,null,null,328894127.57831526,0]
[336915935.56803024,4,null,null,336915935.56803024,1,null,null,336915935.56803024,32,null,null,336915935.56803024,12,null,null,336915935.56803024,10,null,null,336915935.56803024,0,null,null,336915935.56803024,0,null,null,336915935.56803024,0,null,null,336915935.56803024,0]
[344937743.55774522,13,null,null,344937743.55774522,2,null,null,344937743.55774522,20,null,null,344937743.55774522,16,null,null,344937743.55774522,9,null,null,344937743.55774522,1,null,null,344937743.55774522,0,null,null,344937743.55774522,0,null,null,344937743.55774522,0]
[352959551.5474602,5,null,null,352959551.5474602,3,null,null,352959551.5474602,33,null,null,352959551.5474602,23,null,null,352959551.5474602,3,null,null,352959551.5474602,0,null,null,352959551.5474602,0,null,null,352959551.5474602,0,null,null,352959551.5474602,0]
[360981359.53717518,0,null,null,360981359.53717518,1,null,null,360981359.53717518,28,null,null,360981359.53717518,14,null,null,360981359.53717518,5,null,null,360981359.53717518,0,null,null,360981359.53717518,0,null,null,360981359.53717518,0,null,null,360981359.53717518,0]
[369003167.52689016,3,null,null,369003167.52689016,3,null,null,369003167.52689016,22,null,null,369003167.52689016,10,null,null,369003167.52689016,10,null,null,369003167.52689016,0,null,null,369003167.52689016,0,null,null,369003167.52689016,0,null,null,369003167.52689016,0]
[377024975.51660514,5,null,null,377024975.51660514,1,null,null,377024975.51660514,15,null,null,377024975.51660514,7,null,null,377024975.51660514,3,null,null,377024975.51660514,0,null,null,377024975.51660514,0,null,null,377024975.51660514,0,null,null,377024975.51660514,0]
[385046783.50632012,3,null,null,385046783.50632012,2,null,null,385046783.50632012,16,null,null,385046783.50632012,11,null,null,385046783.50632012,8,null,null,385046783.50632012,0,null,null,385046783.50632012,0,null,null,385046783.50632012,0,null,null,385046783.50632012,0]
[393068591.4960351,2,null,null,393068591.4960351,0,null,null,393068591.4960351,13,null,null,393068591.4960351,6,null,null,393068591.4960351,5,null,null,393068591.4960351,0,null,null,393068591.4960351,0,null,null,393068591.4960351,0,null,null,393068591.4960351,0]
[401090399.48575008,3,null,null,401090399.48575008,1,null,null,401090399.48575008,7,null,null,401090399.48575008,4,null,null,401090399.48575008,3,null,null,401090399.48575008,0,null,null,401090399.48575008,0,null,null,401090399.48575008,0,null,null,401090399.48575008,0]
[409112207.47546506,3,null,null,409112207.47546506,2,null,null,409112207.47546506,24,null,null,409112207.47546506,5,null,null,409112207.47546506,4,null,null,409112207.47546506,0,null,null,409112207.47546506,0,null,null,409112207.47546506,0,null,null,409112207.47546506,0]
[417134015.46518004,2,null,null,417134015.46518004,0,null,null,417134015.46518004,13,null,null,417134015.46518004,5,null,null,417134015.46518004,2,null,null,417134015.46518004,0,null,null,417134015.46518004,0,null,null,417134015.46518004,0,null,null,417134015.46518004,0]
[425155823.45489502,2,null,null,425155823.45489502,1,null,null,425155823.45489502,12,null,null,425155823.45489502,9,null,null,425155823.45489502,2,null,null,425155823.45489502,0,null,null,425155823.45489502,0,null,null,425155823.45489502,0,null,null,425155823.45489502,0]
[433177631.44461,2,null,null,433177631.44461,0,null,null,433177631.44461,2,null,null,433177631.44461,5,null,null,433177631.44461,2,null,null,433177631.44461,0,null,null,433177631.44461,0,null,null,433177631.44461,0,null,null,433177631.44461,0]
[441199439.43432498,0,null,null,441199439.43432498,1,null,null,441199439.43432498,7,null,null,441199439.43432498,2,null,null,441199439.43432498,3,null,null,441199439.43432498,0,null,null,441199439.43432498,0,null,null,441199439.43432498,0,null,null,441199439.43432498,0]
[449221247.42403996,2,null,null,449221247.42403996,2,null,null,449221247.42403996,6,null,null,449221247.42403996,4,null,null,449221247.42403996,2,null,null,449221247.42403996,0,null,null,449221247.42403996,0,null,null,449221247.42403996,0,null,null,449221247.42403996,0]
[457243055.41375494,1,null,null,457243055.41375494,1,null,null,457243055.41375494,13,null,null,457243055.41375494,4,null,null,457243055.41375494,0,null,null,457243055.41375494,0,null,null,457243055.41375494,0,null,null,457243055.41375494,0,null,null,457243055.41375494,0]
[465264863.40346992,1,null,null,465264863.40346992,0,null,null,465264863.40346992,4,null,null,465264863.40346992,3,null,null,465264863.40346992,1,null,null,465264863.40346992,0,null,null,465264863.40346992,0,null,null,465264863.40346992,0,null,null,465264863.40346992,0]
[473286671.3931849,0,null,null,473286671.3931849,0,null,null,473286671.3931849,7,null,null,473286671.3931849,5,null,null,473286671.3931849,2,null,null,473286671.3931849,0,null,null,473286671.3931849,0,null,null,473286671.3931849,0,null,null,473286671.3931849,0]
[481308479.38289988,0,null,null,481308479.38289988,0,null,null,481308479.38289988,3,null,null,481308479.38289988,6,null,null,481308479.38289988,0,null,null,481308479.38289988,0,null,null,481308479.38289988,0,null,null,481308479.38289988,0,null,null,481308479.38289988,0]
[489330287.37261486,0,null,null,489330287.37261486,2,null,null,489330287.37261486,4,null,null,489330287.37261486,1,null,null,489330287.37261486,2,null,null,489330287.37261486,0,null,null,489330287.37261486,0,null,null,489330287.37261486,0,null,null,489330287.37261486,0]
[497352095.36232984,0,null,null,497352095.36232984,0,null,null,497352095.36232984,4,null,null,497352095.36232984,1,null,null,497352095.36232984,2,null,null,497352095.36232984,0,null,null,497352095.36232984,0,null,null,497352095.36232984,0,null,null,497352095.36232984,0]
[505373903.35204482,0,null,null,505373903.35204482,1,null,null,505373903.35204482,3,null,null,505373903.35204482,1,null,null,505373903.35204482,0,null,null,505373903.35204482,0,null,null,505373903.35204482,0,null,null,505373903.35204482,0,null,null,505373903.35204482,0]
[513395711.3417598,1,null,null,513395711.3417598,0,null,null,513395711.3417598,2,null,null,513395711.3417598,2,null,null,513395711.3417598,1,null,null,513395711.3417598,0,null,null,513395711.3417598,0,null,null,513395711.3417598,0,null,null,513395711.3417598,0]
[521417519.33147478,0,null,null,521417519.33147478,1,null,null,521417519.33147478,3,null,null,521417519.33147478,2,null,null,521417519.33147478,0,null,null,521417519.33147478,0,null,null,521417519.33147478,0,null,null,521417519.33147478,0,null,null,521417519.33147478,0]
[529439327.32118976,0,null,null,529439327.32118976,0,null,null,529439327.32118976,3,null,null,529439327.32118976,2,null,null,529439327.32118976,1,null,null,529439327.32118976,0,null,null,529439327.32118976,0,null,null,529439327.32118976,0,null,null,529439327.32118976,0]
[537461135.31090474,1,null,null,537461135.31090474,0,null,null,537461135.31090474,4,null,null,537461135.31090474,2,null,null,537461135.31090474,1,null,null,537461135.31090474,0,null,null,537461135.31090474,0,null,null,537461135.31090474,0,null,null,537461135.31090474,0]
[545482943.30061972,0,null,null,545482943.30061972,0,null,null,545482943.30061972,3,null,null,545482943.30061972,2,null,null,545482943.30061972,1,null,null,545482943.30061972,0,null,null,545482943.30061972,0,null,null,545482943.30061972,0,null,null,545482943.30061972,0]
[553504751.2903347,0,null,null,553504751.2903347,0,null,null,553504751.2903347,0,null,null,553504751.2903347,1,null,null,553504751.2903347,0,null,null,553504751.2903347,0,null,null,553504751.2903347,0,null,null,553504751.2903347,0,null,null,553504751.2903347,0]
[561526559.28004968,1,null,null,561526559.28004968,0,null,null,561526559.28004968,0,null,null,561526559.28004968,0,null,null,561526559.28004968,0,null,null,561526559.28004968,0,null,null,561526559.28004968,0,null,null,561526559.28004968,0,null,null,561526559.28004968,0]
[569548367.26976466,1,null,null,569548367.26976466,0,null,null,569548367.26976466,2,null,null,569548367.26976466,3,null,null,569548367.26976466,0,null,null,569548367.26976466,0,null,null,569548367.26976466,0,null,null,569548367.26976466,0,null,null,569548367.26976466,0]
[577570175.25947964,0,null,null,577570175.25947964,0,null,null,577570175.25947964,0,null,null,577570175.25947964,0,null,null,577570175.25947964,1,null,null,577570175.25947964,0,null,null,577570175.25947964,0,null,null,577570175.25947964,0,null,null,577570175.25947964,0]
[585591983.24919462,1,null,null,585591983.24919462,0,null,null,585591983.24919462,3,null,null,585591983.24919462,0,null,null,585591983.24919462,0,null,null,585591983.24919462,0,null,null,585591983.24919462,0,null,null,585591983.24919462,0,null,null,585591983.24919462,0]
[593613791.2389096,0,null,null,593613791.2389096,0,null,null,593613791.2389096,4,null,null,593613791.2389096,1,null,null,593613791.2389096,1,null,null,593613791.2389096,0,null,null,593613791.2389096,0,null,null,593613791.2389096,0,null,null,593613791.2389096,0]
[601635599.22862458,0,null,null,601635599.22862458,0,null,null,601635599.22862458,0,null,null,601635599.22862458,2,null,null,601635599.22862458,0,null,null,601635599.22862458,0,null,null,601635599.22862458,0,null,null,601635599.22862458,0,null,null,601635599.22862458,0]
[609657407.21833956,1,null,null,609657407.21833956,0,null,null,609657407.21833956,4,null,null,609657407.21833956,0,null,null,609657407.21833956,0,null,null,609657407.21833956,0,null,null,609657407.21833956,0,null,null,609657407.21833956,0,null,null,609657407.21833956,0]
[617679215.20805454,0,null,null,617679215.20805454,0,null,null,617679215.20805454,0,null,null,617679215.20805454,1,null,null,617679215.20805454,0,null,null,617679215.20805454,0,null,null,617679215.20805454,0,null,null,617679215.20805454,0,null,null,617679215.20805454,0]
[625701023.19776952,1,null,null,625701023.19776952,0,null,null,625701023.19776952,1,null,null,625701023.19776952,1,null,null,625701023.19776952,0,null,null,625701023.19776952,0,null,null,625701023.19776952,0,null,null,625701023.19776952,0,null,null,625701023.19776952,0]
[633722831.1874845,0,null,null,633722831.1874845,0,null,null,633722831.1874845,0,null,null,633722831.1874845,0,null,null,633722831.1874845,0,null,null,633722831.1874845,0,null,null,633722831.1874845,0,null,null,633722831.1874845,0,null,null,633722831.1874845,0]
[641744639.17719948,0,null,null,641744639.17719948,0,null,null,641744639.17719948,0,null,null,641744639.17719948,3,null,null,641744639.17719948,0,null,null,641744639.17719948,0,null,null,641744639.17719948,0,null,null,641744639.17719948,0,null,null,641744639.17719948,0]
[649766447.16691446,0,null,null,649766447.16691446,0,null,null,649766447.16691446,2,null,null,649766447.16691446,0,null,null,649766447.16691446,0,null,null,649766447.16691446,0,null,null,649766447.16691446,0,null,null,649766447.16691446,0,null,null,649766447.16691446,0]
[657788255.15662944,0,null,null,657788255.15662944,0,null,null,657788255.15662944,4,null,null,657788255.15662944,0,null,null,657788255.15662944,1,null,null,657788255.15662944,0,null,null,657788255.15662944,0,null,null,657788255.15662944,0,null,null,657788255.15662944,0]
[665810063.14634442,0,null,null,665810063.14634442,0,null,null,665810063.14634442,2,null,null,665810063.14634442,0,null,null,665810063.14634442,0,null,null,665810063.14634442,0,null,null,665810063.14634442,0,null,null,665810063.14634442,0,null,null,665810063.14634442,0]
[673831871.1360594,0,null,null,673831871.1360594,0,null,null,673831871.1360594,1,null,null,673831871.1360594,0,null,null,673831871.1360594,1,null,null,673831871.1360594,0,null,null,673831871.1360594,0,null,null,673831871.1360594,0,null,null,673831871.1360594,0]
[681853679.12577438,0,null,null,681853679.12577438,0,null,null,681853679.12577438,0,null,null,681853679.12577438,0,null,null,681853679.12577438,0,null,null,681853679.12577438,0,null,null,681853679.12577438,0,null,null,681853679.12577438,0,null,null,681853679.12577438,0]
[689875487.11548936,0,null,null,689875487.11548936,0,null,null,689875487.11548936,0,null,null,689875487.11548936,0,null,null,689875487.11548936,0,null,null,689875487.11548936,0,null,null,689875487.11548936,0,null,null,689875487.11548936,0,null,null,689875487.11548936,0]
[697897295.10520434,0,null,null,697897295.10520434,0,null,null,697897295.10520434,1,null,null,697897295.10520434,0,null,null,697897295.10520434,0,null,null,697897295.10520434,0,null,null,697897295.10520434,0,null,null,697897295.10520434,0,null,null,697897295.10520434,0]
[705919103.09491932,0,null,null,705919103.09491932,0,null,null,705919103.09491932,0,null,null,705919103.09491932,2,null,null,705919103.09491932,0,null,null,705919103.09491932,0,null,null,705919103.09491932,0,null,null,705919103.09491932,0,null,null,705919103.09491932,0]
[713940911.0846343,0,null,null,713940911.0846343,0,null,null,713940911.0846343,1,null,null,713940911.0846343,0,null,null,713940911.0846343,0,null,null,713940911.0846343,0,null,null,713940911.0846343,0,null,null,713940911.0846343,0,null,null,713940911.0846343,0]
[721962719.07434928,0,null,null,721962719.07434928,0,null,null,721962719.07434928,0,null,null,721962719.07434928,0,null,null,721962719.07434928,0,null,null,721962719.07434928,0,null,null,721962719.07434928,0,null,null,721962719.07434928,0,null,null,721962719.07434928,0]
[729984527.06406426,0,null,null,729984527.06406426,0,null,null,729984527.06406426,0,null,null,729984527.06406426,0,null,null,729984527.06406426,0,null,null,729984527.06406426,0,null,null,729984527.06406426,0,null,null,729984527.06406426,0,null,null,729984527.06406426,0]
[738006335.05377924,0,null,null,738006335.05377924,0,null,null,738006335.05377924,0,null,null,738006335.05377924,1,null,null,738006335.05377924,1,null,null,738006335.05377924,0,null,null,738006335.05377924,0,null,null,738006335.05377924,0,null,null,738006335.05377924,0]
[746028143.04349422,0,null,null,746028143.04349422,0,null,null,746028143.04349422,0,null,null,746028143.04349422,0,null,null,746028143.04349422,0,null,null,746028143.04349422,0,null,null,746028143.04349422,0,null,null,746028143.04349422,0,null,null,746028143.04349422,0]
[754049951.0332092,0,null,null,754049951.0332092,0,null,null,754049951.0332092,0,null,null,754049951.0332092,0,null,null,754049951.0332092,0,null,null,754049951.0332092,0,null,null,754049951.0332092,0,null,null,754049951.0332092,0,null,null,754049951.0332092,0]
[762071759.02292418,0,null,null,762071759.02292418,0,null,null,762071759.02292418,0,null,null,762071759.02292418,0,null,null,762071759.02292418,0,null,null,762071759.02292418,0,null,null,762071759.02292418,0,null,null,762071759.02292418,0,null,null,762071759.02292418,0]
[770093567.01263916,0,null,null,770093567.01263916,0,null,null,770093567.01263916,1,null,null,770093567.01263916,0,null,null,770093567.01263916,0,null,null,770093567.01263916,0,null,null,770093567.01263916,0,null,null,770093567.01263916,0,null,null,770093567.01263916,0]
[778115375.00235415,0,null,null,778115375.00235415,0,null,null,778115375.00235415,0,null,null,778115375.00235415,0,null,null,778115375.00235415,1,null,null,778115375.00235415,0,null,null,778115375.00235415,0,null,null,778115375.00235415,0,null,null,778115375.00235415,0]
[786137182.99206913,0,null,null,786137182.99206913,0,null,null,786137182.99206913,1,null,null,786137182.99206913,0,null,null,786137182.99206913,0,null,null,786137182.99206913,0,null,null,786137182.99206913,0,null,null,786137182.99206913,0,null,null,786137182.99206913,0]
[794158990.98178601,1,null,null,794158990.98178601,1,null,null,794158990.98178601,4,null,null,794158990.98178601,6,null,null,794158990.98178601,1,null,null,794158990.98178601,0,null,null,794158990.98178601,0,null,null,794158990.98178601,0,null,null,794158990.98178601,0]

{"sheet":"Simulation Output 3 Graph Data","index":15,"n_rows":102,"n_cols":16,"rows_kept":102,"cut":false,"hidden":true,"merged":[]}
[{"$f":"#REF!","v":{"$error":"#REF!"}},"Loss Distribution",{"$f":"#REF!","v":{"$error":"#REF!"}},"Cumulative Loss",{"$f":"#REF!","v":{"$error":"#REF!"}},"Loss Distribution",{"$f":"#REF!","v":{"$error":"#REF!"}},"Cumulative Loss",{"$f":"#REF!","v":{"$error":"#REF!"}},"Loss Distribution",{"$f":"#REF!","v":{"$error":"#REF!"}},"Cumulative Loss",{"$f":"#REF!","v":{"$error":"#REF!"}},"Loss Distribution",{"$f":"#REF!","v":{"$error":"#REF!"}},"Cumulative Loss"]
["Bins","Frequency","Year","Yearly Loss","Bins","Frequency","Year","Yearly Loss","Bins","Frequency","Year","Yearly Loss","Bins","Frequency","Year","Yearly Loss"]
[0,109,1,3623581.5613303692,0,108,1,5611276.017051585,0,98,1,5484899.7337234793,0,111,1,5304777.7015680727]
[8172407.0352985216,349,2,7124071.4224305525,8172407.0352985216,427,2,8033505.5019041561,8172407.0352985216,180,2,8095163.4218827616,8172407.0352985216,230,2,7648917.6240386628]
[16344814.070597043,535,3,10343733.591855545,16344814.070597043,762,3,10356799.239496375,16344814.070597043,418,3,10436011.72704985,16344814.070597043,472,3,9947942.3466015086]
[24517221.105895564,719,4,13359379.796630239,24517221.105895564,979,4,12749541.219206285,24517221.105895564,608,4,12790843.310816258,24517221.105895564,631,4,12291053.305037869]
[32689628.141194087,748,5,16557225.709353987,32689628.141194087,1133,5,14893500.090717064,32689628.141194087,715,5,14987315.050297055,32689628.141194087,779,5,14570205.986170132]
[40862035.176492609,798,6,19640047.763697997,40862035.176492609,1103,6,16998456.669815041,40862035.176492609,776,6,17299540.344026159,40862035.176492609,804,6,16821128.061565995]
[49034442.211791128,768,7,22597211.0654152,49034442.211791128,1007,7,19078642.33682017,49034442.211791128,852,7,19470830.200372964,49034442.211791128,802,7,19042991.305836882]
[57206849.247089647,700,8,25346707.808689013,57206849.247089647,851,8,20970445.370187264,57206849.247089647,841,8,21685865.058606587,57206849.247089647,780,8,21325896.461015105]
[65379256.282388166,630,9,28117454.394492581,65379256.282388166,753,9,22823701.877511118,65379256.282388166,816,9,24020512.025638677,65379256.282388166,821,9,23523696.018644806]
[73551663.317686692,598,10,30667000.833812837,73551663.317686692,605,10,24753084.628998592,73551663.317686692,734,10,26151994.28400737,73551663.317686692,690,10,25463776.531883679]
[81724070.352985218,478,11,33082043.565453898,81724070.352985218,473,11,26480361.66007825,81724070.352985218,633,11,28129568.446280077,81724070.352985218,601,11,27495904.142164107]
[89896477.388283744,457,12,35545371.373235002,89896477.388283744,404,12,28091902.734110884,89896477.388283744,548,12,30087397.121389899,89896477.388283744,508,12,29541936.16563715]
[98068884.423582271,424,13,37993940.446341962,98068884.423582271,303,13,29626677.378650591,98068884.423582271,487,13,32180824.879837707,98068884.423582271,472,13,31538958.465857174]
[106241291.4588808,376,14,40146168.16903083,106241291.4588808,240,14,31157620.425947327,106241291.4588808,396,14,34182825.55257193,106241291.4588808,411,14,33562226.477293126]
[114413698.49417932,325,15,42254991.74652826,114413698.49417932,213,15,32632241.317701407,114413698.49417932,343,15,36346523.784911767,114413698.49417932,339,15,35408175.588618606]
[122586105.52947785,291,16,44195010.041064218,122586105.52947785,122,16,34112129.044529602,122586105.52947785,280,16,38288326.178083748,122586105.52947785,301,16,37294487.979655534]
[130758512.56477638,247,17,46079400.714013807,130758512.56477638,123,17,35417097.341609463,130758512.56477638,246,17,40129301.526070148,130758512.56477638,229,17,39177372.905829571]
[138930919.60007489,193,18,47864370.797663815,138930919.60007489,92,18,36711751.577687293,138930919.60007489,198,18,42000040.319573522,138930919.60007489,183,18,41092396.890010022]
[147103326.63537341,168,19,49696256.007405482,147103326.63537341,60,19,38015055.272056393,147103326.63537341,168,19,43722897.817610778,147103326.63537341,161,19,42829784.477474332]
[155275733.67067194,153,20,51790408.178292543,155275733.67067194,61,20,39229358.282497749,155275733.67067194,137,20,45525509.845686063,155275733.67067194,158,20,44592826.80002635]
[163448140.70597047,118,21,53567802.531686015,163448140.70597047,43,21,40407240.783496201,163448140.70597047,108,21,47136763.861760467,163448140.70597047,84,21,46273330.28300903]
[171620547.74126899,94,22,55141525.727156319,171620547.74126899,27,22,41515503.304067083,171620547.74126899,76,22,48785309.631565273,171620547.74126899,79,22,47991311.705484457]
[179792954.77656752,87,23,56661687.098459296,179792954.77656752,19,23,42623693.431796201,179792954.77656752,77,23,50404677.632599637,179792954.77656752,72,23,49562642.294223458]
[187965361.81186604,75,24,58307146.824628726,187965361.81186604,23,24,43650062.686526872,187965361.81186604,53,24,52030342.26610665,187965361.81186604,49,24,51239858.144080989]
[196137768.84716457,60,25,59626980.270588771,196137768.84716457,10,25,44639441.734761544,196137768.84716457,41,25,53530260.885355406,196137768.84716457,44,25,52830551.167048037]
[204310175.8824631,64,26,61049205.397700638,204310175.8824631,14,26,45561335.979665034,204310175.8824631,25,26,55176991.60496974,204310175.8824631,37,26,54404861.582673065]
[212482582.91776162,47,27,62556840.633321814,212482582.91776162,7,27,46495612.649476677,212482582.91776162,27,27,56841566.105532803,212482582.91776162,36,27,55888973.487416536]
[220654989.95306015,54,28,63842236.885927342,220654989.95306015,9,28,47377828.841175847,220654989.95306015,26,28,58362614.854767822,220654989.95306015,24,28,57377333.531755865]
[228827396.98835868,49,29,65047240.034329869,228827396.98835868,4,29,48295380.352551505,228827396.98835868,15,29,59859239.58778403,228827396.98835868,13,29,58870548.269666709]
[236999804.0236572,38,30,66200327.407713316,236999804.0236572,4,30,49147291.875724569,236999804.0236572,12,30,61340312.056856066,236999804.0236572,22,30,60322668.053098574]
[245172211.05895573,34,31,67335390.547883794,245172211.05895573,1,31,49965128.844265558,245172211.05895573,7,31,62744356.93177335,245172211.05895573,11,31,61744634.601516612]
[253344618.09425426,25,32,68447384.671694875,253344618.09425426,3,32,50711180.263589695,253344618.09425426,13,32,64048697.510400355,253344618.09425426,8,32,63045788.360904917]
[261517025.12955278,31,33,69580927.269371301,261517025.12955278,1,33,51412188.352117203,261517025.12955278,10,33,65403174.770571128,261517025.12955278,9,33,64428501.692180604]
[269689432.16485131,22,34,70579918.729128718,269689432.16485131,3,34,52054147.359174758,269689432.16485131,10,34,66704272.722901732,269689432.16485131,7,34,65706699.673626386]
[277861839.20014983,17,35,71529245.262573302,277861839.20014983,5,35,52698633.864395447,277861839.20014983,1,35,67914825.575176701,277861839.20014983,5,35,66959226.583053984]
[286034246.23544836,11,36,72555127.158402756,286034246.23544836,2,36,53275065.832790494,286034246.23544836,6,36,69245166.320841491,286034246.23544836,4,36,68246655.300763562]
[294206653.27074689,10,37,73479529.58105135,294206653.27074689,0,37,53950023.75251478,294206653.27074689,2,37,70415232.862876475,294206653.27074689,1,37,69453218.823010862]
[302379060.30604541,7,38,74344397.690709651,302379060.30604541,2,38,54537928.958068937,302379060.30604541,0,38,71736323.297149733,302379060.30604541,2,38,70619304.204180136]
[310551467.34134394,11,39,75250715.526877597,310551467.34134394,0,39,55098501.80073759,310551467.34134394,1,39,72886975.517617717,310551467.34134394,0,39,71853803.93551591]
[318723874.37664247,10,40,76107421.190874055,318723874.37664247,0,40,55660530.957107581,318723874.37664247,3,40,74101383.811698824,318723874.37664247,0,40,73015852.118840978]
[326896281.41194099,4,null,null,326896281.41194099,1,null,null,326896281.41194099,2,null,null,326896281.41194099,0]
[335068688.44723952,5,null,null,335068688.44723952,0,null,null,335068688.44723952,3,null,null,335068688.44723952,4]
[343241095.48253804,6,null,null,343241095.48253804,0,null,null,343241095.48253804,2,null,null,343241095.48253804,0]
[351413502.51783657,3,null,null,351413502.51783657,1,null,null,351413502.51783657,0,null,null,351413502.51783657,0]
[359585909.5531351,6,null,null,359585909.5531351,0,null,null,359585909.5531351,0,null,null,359585909.5531351,0]
[367758316.58843362,7,null,null,367758316.58843362,1,null,null,367758316.58843362,0,null,null,367758316.58843362,0]
[375930723.62373215,2,null,null,375930723.62373215,0,null,null,375930723.62373215,1,null,null,375930723.62373215,1]
[384103130.65903068,3,null,null,384103130.65903068,0,null,null,384103130.65903068,0,null,null,384103130.65903068,0]
[392275537.6943292,1,null,null,392275537.6943292,0,null,null,392275537.6943292,2,null,null,392275537.6943292,1]
[400447944.72962773,0,null,null,400447944.72962773,0,null,null,400447944.72962773,1,null,null,400447944.72962773,0]
[408620351.76492625,2,null,null,408620351.76492625,0,null,null,408620351.76492625,1,null,null,408620351.76492625,0]
[416792758.80022478,3,null,null,416792758.80022478,0,null,null,416792758.80022478,0,null,null,416792758.80022478,1]
[424965165.83552331,2,null,null,424965165.83552331,0,null,null,424965165.83552331,0,null,null,424965165.83552331,1]
[433137572.87082183,0,null,null,433137572.87082183,0,null,null,433137572.87082183,0,null,null,433137572.87082183,0]
[441309979.90612036,1,null,null,441309979.90612036,0,null,null,441309979.90612036,0,null,null,441309979.90612036,0]
[449482386.94141889,4,null,null,449482386.94141889,0,null,null,449482386.94141889,1,null,null,449482386.94141889,0]
[457654793.97671741,1,null,null,457654793.97671741,0,null,null,457654793.97671741,0,null,null,457654793.97671741,1]
[465827201.01201594,1,null,null,465827201.01201594,0,null,null,465827201.01201594,0,null,null,465827201.01201594,0]
[473999608.04731447,4,null,null,473999608.04731447,0,null,null,473999608.04731447,0,null,null,473999608.04731447,0]
[482172015.08261299,0,null,null,482172015.08261299,0,null,null,482172015.08261299,0,null,null,482172015.08261299,0]
[490344422.11791152,1,null,null,490344422.11791152,0,null,null,490344422.11791152,0,null,null,490344422.11791152,1]
[498516829.15321004,2,null,null,498516829.15321004,0,null,null,498516829.15321004,0,null,null,498516829.15321004,0]
[506689236.18850857,1,null,null,506689236.18850857,0,null,null,506689236.18850857,0,null,null,506689236.18850857,0]
[514861643.2238071,0,null,null,514861643.2238071,0,null,null,514861643.2238071,0,null,null,514861643.2238071,0]
[523034050.25910562,2,null,null,523034050.25910562,0,null,null,523034050.25910562,0,null,null,523034050.25910562,0]
[531206457.29440415,1,null,null,531206457.29440415,0,null,null,531206457.29440415,0,null,null,531206457.29440415,0]
[539378864.32970262,1,null,null,539378864.32970262,0,null,null,539378864.32970262,0,null,null,539378864.32970262,0]
[547551271.36500108,2,null,null,547551271.36500108,0,null,null,547551271.36500108,0,null,null,547551271.36500108,0]
[555723678.40029955,1,null,null,555723678.40029955,0,null,null,555723678.40029955,0,null,null,555723678.40029955,0]
[563896085.43559802,0,null,null,563896085.43559802,0,null,null,563896085.43559802,0,null,null,563896085.43559802,0]
[572068492.47089648,0,null,null,572068492.47089648,0,null,null,572068492.47089648,0,null,null,572068492.47089648,0]
[580240899.50619495,0,null,null,580240899.50619495,0,null,null,580240899.50619495,0,null,null,580240899.50619495,0]
[588413306.54149342,0,null,null,588413306.54149342,0,null,null,588413306.54149342,0,null,null,588413306.54149342,0]
[596585713.57679188,0,null,null,596585713.57679188,0,null,null,596585713.57679188,0,null,null,596585713.57679188,0]
[604758120.61209035,0,null,null,604758120.61209035,0,null,null,604758120.61209035,0,null,null,604758120.61209035,0]
[612930527.64738882,0,null,null,612930527.64738882,1,null,null,612930527.64738882,0,null,null,612930527.64738882,0]
[621102934.68268728,0,null,null,621102934.68268728,0,null,null,621102934.68268728,0,null,null,621102934.68268728,0]
[629275341.71798575,0,null,null,629275341.71798575,0,null,null,629275341.71798575,0,null,null,629275341.71798575,0]
[637447748.75328422,0,null,null,637447748.75328422,0,null,null,637447748.75328422,0,null,null,637447748.75328422,0]
[645620155.78858268,0,null,null,645620155.78858268,0,null,null,645620155.78858268,0,null,null,645620155.78858268,0]
[653792562.82388115,1,null,null,653792562.82388115,0,null,null,653792562.82388115,0,null,null,653792562.82388115,0]
[661964969.85917962,0,null,null,661964969.85917962,0,null,null,661964969.85917962,0,null,null,661964969.85917962,0]
[670137376.89447808,0,null,null,670137376.89447808,0,null,null,670137376.89447808,0,null,null,670137376.89447808,0]
[678309783.92977655,0,null,null,678309783.92977655,0,null,null,678309783.92977655,0,null,null,678309783.92977655,0]
[686482190.96507502,0,null,null,686482190.96507502,0,null,null,686482190.96507502,0,null,null,686482190.96507502,0]
[694654598.00037348,0,null,null,694654598.00037348,0,null,null,694654598.00037348,0,null,null,694654598.00037348,0]
[702827005.03567195,0,null,null,702827005.03567195,0,null,null,702827005.03567195,0,null,null,702827005.03567195,0]
[710999412.07097042,0,null,null,710999412.07097042,0,null,null,710999412.07097042,0,null,null,710999412.07097042,0]
[719171819.10626888,0,null,null,719171819.10626888,0,null,null,719171819.10626888,0,null,null,719171819.10626888,0]
[727344226.14156735,0,null,null,727344226.14156735,0,null,null,727344226.14156735,0,null,null,727344226.14156735,0]
[735516633.17686582,1,null,null,735516633.17686582,0,null,null,735516633.17686582,0,null,null,735516633.17686582,0]
[743689040.21216428,0,null,null,743689040.21216428,0,null,null,743689040.21216428,0,null,null,743689040.21216428,0]
[751861447.24746275,0,null,null,751861447.24746275,0,null,null,751861447.24746275,0,null,null,751861447.24746275,0]
[760033854.28276122,0,null,null,760033854.28276122,0,null,null,760033854.28276122,0,null,null,760033854.28276122,0]
[768206261.31805968,0,null,null,768206261.31805968,0,null,null,768206261.31805968,0,null,null,768206261.31805968,0]
[776378668.35335815,1,null,null,776378668.35335815,0,null,null,776378668.35335815,0,null,null,776378668.35335815,0]
[784551075.38865662,0,null,null,784551075.38865662,0,null,null,784551075.38865662,0,null,null,784551075.38865662,0]
[792723482.42395508,0,null,null,792723482.42395508,0,null,null,792723482.42395508,0,null,null,792723482.42395508,0]
[800895889.45925355,0,null,null,800895889.45925355,0,null,null,800895889.45925355,0,null,null,800895889.45925355,0]
[809068296.49455369,1,null,null,809068296.49455369,0,null,null,809068296.49455369,0,null,null,809068296.49455369,0]