{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Sheet1","data set","Uniform","Triangular","Normal","LogNormal"],"not_rendered":{"charts":32,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":71,"n_cols":22,"rows_kept":71,"cut":false,"hidden":true,"merged":[]}
["Fitting a probability distribution to data"]
[null,null,null,null,null,null,null,null,null,null,null,3.55,null,"min",{"$f":"MIN(L5:L71)","v":527.55469982366492}]
[null,"annual peak flow",null,null,null,null,null,null,null,null,null,0.3,null,"max",{"$f":"MAX(L5:L71)","v":18174.748380621029}]
[1,4293.7156878958767,9500.0831298404191,5857.8845107221614,null,null,0.99,{"$f":"NORMSINV(1-G4)","v":-2.3263478740408408},{"$f":"10^NORMINV(1-G4,$L$2,$L$3)","v":711.37015017487624},null,null,null,null,null,null,null,"random",null,null,"sample 1","sample 2","sample 3"]
[2,992.47615126044946,8277.343605606955,5100.5101643043499,null,null,0.9,{"$f":"NORMSINV(1-G5)","v":-1.2815515655446006},{"$f":"10^NORMINV(1-G5,$L$2,$L$3)","v":1463.9779324009162},1,{"$f":"RAND()","v":4.7209618843633949E-2},{"$f":"10^NORMINV(K5,$L$2,$L$3)","v":1117.4807654397187},null,null,null,null,{"$f":"LARGE($L$5:$L$71,J5)","v":18174.748380621029},{"$f":"J5/68","v":1.4705882352941176E-2},{"$f":"NORMSINV(1-R5)","v":2.1779230690821856},{"$f":"LARGE($B$4:$B$70,$J5)","v":14367.2579913719},{"$f":"LARGE($C$4:$C$70,$J5)","v":18104.639739039601},{"$f":"LARGE($D$4:$D$70,$J5)","v":18769.969790522446}]
[3,2629.0903060841306,4566.7610541338172,4942.7401221843411,null,null,0.75,-0.67448975019608193,2226.6557315616797,2,{"$f":"RAND()","v":0.99098240075710453},{"$f":"10^NORMINV(K6,$L$2,$L$3)","v":18174.748380621029},null,null,null,null,{"$f":"LARGE($L$5:$L$71,J6)","v":14461.24754525585},{"$f":"J6/68","v":2.9411764705882353E-2},{"$f":"NORMSINV(1-R6)","v":1.8895099603334296},{"$f":"LARGE($B$4:$B$70,J6)","v":12006.8578599918},{"$f":"LARGE($C$4:$C$70,$J6)","v":13540.002179953059},{"$f":"LARGE($D$4:$D$70,$J6)","v":16455.375975315554}]
[4,8157.2591280122733,10450.648536545315,4710.8204215415171,1000,{"$f":"FREQUENCY(B4:B70,E7:E22)","v":3},0.5,0,3548.1338923357539,3,0.80629948269343288,6446.1745180333091,null,1000,{"$f":"FREQUENCY(L5:L71,N7:N22)","v":7},null,13367.366310181709,4.4117647058823532E-2,1.7047809048894009,10694.416487324303,12558.604066696216,16161.017787747858]
[5,3315.7693159464166,4635.3303666510747,747.27178009939314,2000,9,0.25,0.67448975019608193,5653.8844058807917,4,2.3988841158108731E-2,905.17006888102969,null,2000,5,null,11238.064772891623,5.8823529411764705E-2,1.5647264713617985,10192.2202856733,11561.389331057913,12183.908338768457]
[6,10192.2202856733,18104.639739039601,4826.9761376119604,3000,15,0.1,1.2815515655446006,8599.34691590287,5,0.38201516987746398,2883.6480636722167,null,3000,11,null,9879.4929527044824,7.3529411764705885E-2,1.4499989087404508,9621.528431097131,11181.531669546139,9510.3338759496619]
[7,3269.7333207136899,5642.7206615873156,3826.9128618637847,4000,9,0.05,1.6448536269514715,11052.387120301484,6,0.65598003991930898,4682.2536703293663,null,4000,13,null,7830.7779962655823,8.8235294117647065E-2,1.3517022399306602,9478.3455132998515,11002.306313688072,8464.6468122878068]
[8,12006.8578599918,2981.4855729256083,12183.908338768457,5000,10,0.02,2.0537489106318221,14659.686170879531,7,0.75875312005875029,5763.5384939765918,null,5000,7,null,7775.63382288103,0.10294117647058823,1.2649692448841479,8273.3120801068799,10450.648536545315,8165.085598451743]
[9,2441.4300121720953,1940.0088184972083,2804.0060335009512,6000,8,0.01,2.3263478740408408,17697.191982045999,8,0.75093077884524695,5665.3468790917705,null,6000,10,null,7312.7449527178997,0.11764705882352941,1.186831432755818,8157.2591280122733,9759.0579054737009,8051.0563670190422]
[10,5056.627677681653,3088.9109354264419,3020.7905587163968,7000,2,5.0000000000000001E-3,2.5758293035488999,21025.619031838607,9,2.8979657711329931E-3,527.55469982366492,null,7000,5,null,7220.4893341806273,0.13235294117647059,1.1153373577337866,7905.4442280584353,9620.3611537459492,7667.2681987750866]
[11,4460.7298806777399,1923.3807026119443,1822.6141324334872,8000,3,null,null,null,10,0.37871313076539037,2866.4297615536461,null,8000,4,null,6907.8751781746105,0.14705882352941177,1.0491313979639725,7391.3420371201801,9500.0831298404191,7638.365182739275]
[12,5555.8378056056426,6370.6292480071997,2954.4137489134559,9000,2,null,null,null,11,0.27563055319004448,2350.923864757252,null,9000,0,null,6874.9765154043871,0.16176470588235295,0.98723099199017461,7093.3718608253212,8797.5745380235803,6986.2417756017521]
[13,3277.9951028663645,9620.3611537459492,4165.729132498388,10000,2,null,{"$f":"MAX(B4:B70)","v":14367.2579913719},null,12,0.75833200521898458,5758.1655783389506,null,10000,1,null,6791.3530258194123,0.17647058823529413,0.92889949164726959,6848.8614042298022,8598.5908455202753,6692.7841826014655]
[14,5281.3331920688088,2738.4803492734,6986.2417756017521,11000,2,null,null,null,13,0.48911256841576112,3481.8636514383561,null,11000,0,null,6446.1745180333091,0.19117647058823528,0.87356913461508812,6609.6035424165802,8277.343605606955,6547.8419220992537]
[15,3176.9040278867401,4523.6581147154684,3474.4868578859805,12000,0,null,null,null,14,0.39300661661556491,2941.3901031076266,null,12000,1,null,6435.0901708405181,0.20588235294117646,0.82079208833238126,5689.2560526270972,8168.4403580618218,6370.9397320605067]
[16,3418.731784204665,3464.7019424160303,4240.804223589108,13000,1,null,null,null,15,0.83086036769164529,6874.9765154043871,null,13000,0,null,5763.5384939765918,0.22058823529411764,0.77020808187547585,5665.0501226769047,7553.590816216989,6138.2104537988307]
[17,746.22123325795906,8168.4403580618218,4500.7076952761172,14000,0,null,null,null,16,0.44120421713890445,3203.5017220881678,null,14000,1,null,5758.1655783389506,0.23529411764705882,0.72152228398234308,5646.4638921203368,7338.8145739678166,6078.5807745732764]
[18,5631.9570395932869,4783.3757203101886,4776.2096422598242,15000,1,null,null,null,17,0.41697165043371365,3069.7707318166854,null,15000,1,null,5701.3252561874915,0.25,0.67448975019608193,5631.9570395932869,7285.2899080289635,5953.3807614683292]
[19,1658.9456232732036,4514.2673430529212,3883.2527758193432,16000,0,null,null,null,18,0.87197693130695542,7775.63382288103,null,16000,0,null,5665.3468790917705,0.26470588235294118,0.62890421763218995,5555.8378056056426,7264.2311065265058,5857.8845107221614]
[20,4538.9149266823442,3568.0794176304967,3403.4293336906617,null,null,null,null,null,19,0.39864838987527118,2971.2955921360799,null,null,null,null,5552.8020899482781,0.27941176470588236,0.58458985705947353,5298.8178018080271,7210.7329842362687,5646.2478790085324]
[21,2985.7793024106077,5318.3794384899611,1085.6198739575873,null,null,null,null,null,20,6.7551492507132882E-2,1263.9113503018918,null,null,null,null,5348.5494245897507,0.29411764705882354,0.54139508512908763,5281.3331920688088,6933.1154481601016,5332.5871359192615]
[22,6848.8614042298022,2807.4887892202714,16455.375975315554,null,null,null,null,null,21,0.23426604839082332,2150.4985374601292,null,null,null,null,5343.5818366401882,0.30882352941176472,0.49918784205087674,5056.627677681653,6749.9011245613219,5100.5101643043499]
[23,1549.1692618242062,5873.771105678632,4430.2451867054615,null,null,null,null,null,22,0.55890084739115664,3930.5643984654444,null,null,null,null,5135.3814326366291,0.3235294117647059,0.45785193101249527,4699.7215570781291,6370.6292480071997,5038.4889264354679]
[24,4051.2913379294378,8797.5745380235803,8464.6468122878068,null,null,null,null,null,23,0.10717908004300347,1504.8695384706498,null,null,null,null,5094.4890609330114,0.33823529411764708,0.41728413938902159,4538.9149266823442,5873.771105678632,4974.8081798716985]
[25,975.29168055548337,4540.6616607395727,6138.2104537988307,null,null,null,null,null,24,5.7334637952479728E-3,618.81182676371225,null,null,null,null,5028.4839729138612,0.35294117647058826,0.37739194382855357,4460.7298806777399,5843.4120150374238,4942.7401221843411]
[26,1260.1361720189918,2603.3696952488403,9510.3338759496619,null,null,null,null,null,25,0.44637308643635543,3232.5924713843656,null,null,null,null,4721.6724559272261,0.36764705882352944,0.33809165680420711,4355.09301186628,5647.0505989329122,4867.4203704868878]
[27,4355.09301186628,7264.2311065265058,3478.994301936511,null,null,null,null,null,26,0.70375885922777937,5135.3814326366291,null,null,null,null,4682.2536703293663,0.38235294117647056,0.29930691046566715,4293.7156878958767,5642.7206615873156,4855.574026427731]
[28,9621.528431097131,3439.5513301112514,2055.4048564544532,null,null,null,null,null,27,0.5337122180895989,3761.6765279258861,null,null,null,null,4520.8507157187296,0.39705882352941174,0.26096740040145311,4214.1058346796763,5318.3794384899611,4826.9761376119604]
[29,5298.8178018080271,11002.306313688072,6692.7841826014655,null,null,null,null,null,28,0.82635386325945825,6791.3530258194123,null,null,null,null,4516.2567759535541,0.41176470588235292,0.22300783094036683,4182.1133002962742,5301.8895513956722,4776.2096422598242]
[30,7093.3718608253212,2190.5253083135058,2968.3904955940343,null,null,null,null,null,29,0.58894393713770676,4144.2769377841723,null,null,null,null,4250.097792423473,0.4264705882352941,0.18536701728959662,4144.8911960115574,5031.4478656605925,4710.8204215415171]
[31,14367.2579913719,3018.4535250685822,2471.2771514086448,null,null,null,null,null,30,0.60308088434944263,4250.097792423473,null,null,null,null,4194.8418570604472,0.44117647058823528,0.14798710972583889,4051.2913379294378,4938.7259003443578,4500.7076952761172]
[32,2625.5386754500691,13540.002179953059,4855.574026427731,null,null,null,null,null,31,0.41713080717610151,3070.6355891886947,null,null,null,null,4144.2769377841723,0.45588235294117646,0.11081291229915714,4042.9287163795802,4783.3757203101886,4430.2451867054615]
[33,1898.4619469820484,2108.6397918245966,5038.4889264354679,null,null,null,null,null,32,0.47100068528354544,3374.2216622819487,null,null,null,null,3930.5643984654444,0.47058823529411764,7.3791273808272689E-2,3913.6939460692215,4710.1122752310885,4240.804223589108]
[34,8273.3120801068799,2710.1168507853868,3449.1232258810301,null,null,null,null,null,33,0.83259773674274751,6907.8751781746105,null,null,null,null,3911.9248662001642,0.48529411764705882,3.6870532662080152E-2,3551.5944190891601,4635.3303666510747,4165.729132498388]
[35,5646.4638921203368,1297.5117482410831,2524.7303803481682,null,null,null,null,null,34,0.87410581120215847,7830.7779962655823,null,null,null,null,3761.6765279258861,0.5,0,3418.731784204665,4624.6633512149301,3883.2527758193432]
[36,3551.5944190891601,7210.7329842362687,3085.6735742813694,null,null,null,null,null,35,0.33569248261610685,2646.8272849808941,null,null,null,null,3728.4094090348408,0.51470588235294112,-3.6870532662080152E-2,3354.0845179039752,4566.7610541338172,3826.9128618637847]
[37,2041.4540880568886,6749.9011245613219,6370.9397320605067,null,null,null,null,null,36,0.59575919180315806,4194.8418570604472,null,null,null,null,3481.8636514383561,0.52941176470588236,-7.3791273808272689E-2,3315.7693159464166,4540.6616607395727,3478.994301936511]
[38,2700.0962081763473,7553.590816216989,5332.5871359192615,null,null,null,null,null,37,0.48696917785772209,3468.9594940568463,null,null,null,null,3468.9594940568463,0.54411764705882348,-0.11081291229915685,3277.9951028663645,4523.6581147154684,3474.4868578859805]
[39,1545.0308266878101,4938.7259003443578,18769.969790522446,null,null,null,null,null,38,0.47484152699924154,3396.7889241330699,null,null,null,null,3396.7889241330699,0.55882352941176472,-0.14798710972583889,3269.7333207136899,4514.2673430529212,3449.1232258810301]
[40,2064.1613979038243,3094.5229218487461,1332.2082569623317,null,null,null,null,null,39,2.3244073205914373E-2,896.84998961265558,null,null,null,null,3374.2216622819487,0.57352941176470584,-0.18536701728959662,3176.9040278867401,4135.1171797943452,3444.3484844526488]
[41,1850.7976898340346,6933.1154481601016,2877.988542674912,null,null,null,null,null,40,0.97902517023528701,14461.24754525585,null,null,null,null,3365.7217563995123,0.58823529411764708,-0.22300783094036683,3164.8283161868385,4095.500359484673,3403.4293336906617]
[42,6609.6035424165802,5031.4478656605925,1638.5015989747797,null,null,null,null,null,41,0.11304935937928495,1537.6556782051216,null,null,null,null,3232.5924713843656,0.6029411764705882,-0.26096740040145278,2985.7793024106077,3763.7989796750294,3320.6316617228376]
[43,1210.892176254489,12558.604066696216,3444.3484844526488,null,null,null,null,null,42,0.55618419005315456,3911.9248662001642,null,null,null,null,3203.5017220881678,0.61764705882352944,-0.29930691046566715,2864.2078938636487,3568.0794176304967,3274.2625073047243]
[44,2712.0635052049061,3394.0143911695868,4974.8081798716985,null,null,null,null,null,43,0.63655372079728723,4516.2567759535541,null,null,null,null,3070.6355891886947,0.63235294117647056,-0.33809165680420711,2844.9709784935867,3464.7019424160303,3272.9871842293787]
[45,2828.0210253905102,4135.1171797943452,1494.1485246305895,null,null,null,null,null,44,0.27521091175929491,2348.8839175643016,null,null,null,null,3069.7707318166854,0.6470588235294118,-0.37739194382855401,2828.0210253905102,3439.5513301112514,3096.4125737270379]
[46,3913.6939460692215,3163.5079609658146,3320.6316617228376,null,null,null,null,null,45,2.6348318464664788E-2,930.63722102874249,null,null,null,null,2971.2955921360799,0.66176470588235292,-0.41728413938902159,2754.6750659989279,3394.0143911695868,3085.6735742813694]
[47,10694.416487324303,1580.6747265477834,3043.2547997117595,null,null,null,null,null,46,0.23380422262707723,2148.2621222828766,null,null,null,null,2941.3901031076266,0.67647058823529416,-0.45785193101249527,2712.0635052049061,3163.5079609658146,3053.7566623113203]
[48,2864.2078938636487,1147.4177641659944,2809.1406986660454,null,null,null,null,null,47,0.95243851266660973,11238.064772891623,null,null,null,null,2883.6480636722167,0.69117647058823528,-0.49918784205087674,2700.0962081763473,3094.5229218487461,3043.2547997117595]
[49,2020.5747228905432,2953.6371828975984,8051.0563670190422,null,null,null,null,null,48,0.93088954829879889,9879.4929527044824,null,null,null,null,2866.4297615536461,0.70588235294117652,-0.54139508512908796,2629.0903060841306,3088.9109354264419,3020.7905587163968]
[50,9478.3455132998515,861.62785622098386,1676.3343719985828,null,null,null,null,null,49,0.52859770459946875,3728.4094090348408,null,null,null,null,2646.8272849808941,0.72058823529411764,-0.58458985705947353,2625.5386754500691,3018.4535250685822,2968.3904955940343]
[51,1555.8828674317101,3763.7989796750294,3096.4125737270379,null,null,null,null,null,50,0.75382819215784069,5701.3252561874915,null,null,null,null,2411.9112279802862,0.73529411764705888,-0.62890421763218995,2488.1904656657616,2981.4855729256083,2954.4137489134559]
[52,3354.0845179039752,7285.2899080289635,4867.4203704868878,null,null,null,null,null,51,9.2241908265093264E-2,1418.6571382576331,null,null,null,null,2350.923864757252,0.75,-0.67448975019608193,2441.4300121720953,2966.2797557365438,2877.988542674912]
[53,2488.1904656657616,5843.4120150374238,7667.2681987750866,null,null,null,null,null,52,0.72378408742120481,5348.5494245897507,null,null,null,null,2348.8839175643016,0.76470588235294112,-0.72152228398234308,2219.9768259333259,2953.6371828975984,2809.1406986660454]
[54,4699.7215570781291,9759.0579054737009,7638.365182739275,null,null,null,null,null,53,6.6924270978832023E-3,642.67505652140858,null,null,null,null,2278.8569657950361,0.77941176470588236,-0.77020808187547585,2064.1613979038243,2807.4887892202714,2804.0060335009512]
[55,7905.4442280584353,11181.531669546139,2118.5767933451357,null,null,null,null,null,54,0.85243516467725222,7312.7449527178997,null,null,null,null,2150.4985374601292,0.79411764705882348,-0.82079208833238049,2041.4540880568886,2738.4803492734,2524.7303803481682]
[56,4144.8911960115574,2563.1761489706714,5953.3807614683292,null,null,null,null,null,55,0.80561463363685104,6435.0901708405181,null,null,null,null,2148.2621222828766,0.80882352941176472,-0.87356913461508812,2020.5747228905432,2710.1168507853868,2471.2771514086448]
[57,5665.0501226769047,2025.7349123845295,1556.2110662203465,null,null,null,null,null,56,0.7233340905239185,5343.5818366401882,null,null,null,null,1537.6556782051216,0.82352941176470584,-0.92889949164726959,1908.4429658954182,2603.3696952488403,2314.2788415218479]
[58,3164.8283161868385,7338.8145739678166,3053.7566623113203,null,null,null,null,null,57,0.28815061200777592,2411.9112279802862,null,null,null,null,1504.8695384706498,0.83823529411764708,-0.98723099199017461,1898.4619469820484,2563.1761489706714,2168.4233972390721]
[59,4042.9287163795802,11561.389331057913,6078.5807745732764,null,null,null,null,null,58,0.74162845320687532,5552.8020899482781,null,null,null,null,1418.6571382576331,0.8529411764705882,-1.0491313979639725,1850.7976898340346,2190.5253083135058,2118.5767933451357]
[60,7391.3420371201801,4710.1122752310885,16161.017787747858,null,null,null,null,null,59,0.69314691215984714,5028.4839729138612,null,null,null,null,1263.9113503018918,0.86764705882352944,-1.1153373577337866,1658.9456232732036,2108.6397918245966,2055.4048564544532]
[61,1908.4429658954182,2966.2797557365438,3272.9871842293787,null,null,null,null,null,60,0.69974553319796318,5094.4890609330114,null,null,null,null,1117.4807654397187,0.88235294117647056,-1.186831432755818,1555.8828674317101,2025.7349123845295,1822.6141324334872]
[62,4182.1133002962742,1435.9797520260897,2314.2788415218479,null,null,null,null,null,61,0.6604358208473311,4721.6724559272261,null,null,null,null,930.63722102874249,0.8970588235294118,-1.2649692448841479,1549.1692618242062,1940.0088184972083,1676.3343719985828]
[63,2844.9709784935867,8598.5908455202753,2168.4233972390721,null,null,null,null,null,62,1.7453312657486952E-2,826.35758711031463,null,null,null,null,905.17006888102969,0.91176470588235292,-1.3517022399306602,1545.0308266878101,1923.3807026119443,1638.5015989747797]
[64,2219.9768259333259,4624.6633512149301,6547.8419220992537,null,null,null,null,null,63,0.46954806148968098,3365.7217563995123,null,null,null,null,896.84998961265558,0.92647058823529416,-1.4499989087404506,1260.1361720189918,1580.6747265477834,1556.2110662203465]
[65,5689.2560526270972,5647.0505989329122,3274.2625073047243,null,null,null,null,null,64,0.26077982299597557,2278.8569657950361,null,null,null,null,826.35758711031463,0.94117647058823528,-1.5647264713617985,1210.892176254489,1435.9797520260897,1494.1485246305895]
[66,4214.1058346796763,5301.8895513956722,8165.085598451743,null,null,null,null,null,65,0.9725807011656814,13367.366310181709,null,null,null,null,642.67505652140858,0.95588235294117652,-1.7047809048894009,992.47615126044946,1297.5117482410831,1332.2082569623317]
[67,2754.6750659989279,4095.500359484673,5646.2478790085324,null,null,null,null,null,66,{"$f":"RAND()","v":0.84815568590887391},{"$f":"10^NORMINV(K70,$L$2,$L$3)","v":7220.4893341806273},null,null,null,null,{"$f":"LARGE($L$5:$L$71,J70)","v":618.81182676371225},{"$f":"J70/68","v":0.97058823529411764},{"$f":"NORMSINV(1-R70)","v":-1.8895099603334296},{"$f":"LARGE($B$4:$B$70,J70)","v":975.29168055548337},{"$f":"LARGE($C$4:$C$70,$J70)","v":1147.4177641659944},{"$f":"LARGE($D$4:$D$70,$J70)","v":1085.6198739575873}]
[null,null,null,null,null,null,null,null,null,67,0.63710600006262819,4520.8507157187296,null,null,null,null,527.55469982366492,0.98529411764705888,-2.1779230690821856,746.22123325795906,861.62785622098386,747.27178009939314]

{"sheet":"data set","index":1,"n_rows":70,"n_cols":23,"rows_kept":70,"cut":false,"hidden":false,"merged":[]}
["Fitting a probability distribution to data",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Weibull"]
[null,null,"annual",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"plotting","deviate of","ranked"]
[null,"year","peak flow",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"position","plot pos","flows"]
[1,1936,4294,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"T4/($F$10+1)","v":1.4705882352941176E-2},{"$f":"NORMSINV(1-U4)","v":2.1779230690821856},{"$f":"LARGE($C$4:$C$70,T4)","v":14367}]
[2,1937,992,null,"min flow =",{"$f":"MIN(C4:C70)","v":746},null,null,null,null,null,null,null,null,null,null,null,null,null,2,{"$f":"T5/($F$10+1)","v":2.9411764705882353E-2},{"$f":"NORMSINV(1-U5)","v":1.8895099603334296},{"$f":"LARGE($C$4:$C$70,T5)","v":12007}]
[3,1938,2629,null,"max flow =",{"$f":"MAX(C4:C70)","v":14367},null,null,null,null,null,null,null,null,null,null,null,null,null,3,4.4117647058823532E-2,1.7047809048894009,10694]
[4,1939,8157,null,"average =",{"$f":"AVERAGE(C4:C70)","v":4347.1940298507461},null,null,null,null,null,null,null,null,null,null,null,null,null,4,5.8823529411764705E-2,1.5647264713617985,10192]
[5,1940,3316,null,"std. dev =",{"$f":"STDEV(C4:C70)","v":2839.5128222712092},null,null,null,null,null,null,null,null,null,null,null,null,null,5,7.3529411764705885E-2,1.4499989087404508,9622]
[6,1941,10192,null,"skew =",{"$f":"SKEW(C4:C70)","v":1.3811947534601574},null,null,null,null,null,null,null,null,null,null,null,null,null,6,8.8235294117647065E-2,1.3517022399306602,9478]
[7,1942,3270,null,"sample size =",{"$f":"COUNT(C4:C70)","v":67},null,null,null,null,null,null,null,null,null,null,null,null,null,7,0.10294117647058823,1.2649692448841479,8273]
[8,1943,12007,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,0.11764705882352941,1.186831432755818,8157]
[9,1944,2441,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,0.13235294117647059,1.1153373577337866,7905]
[10,1945,5057,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,0.14705882352941177,1.0491313979639725,7391]
[11,1946,4461,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,0.16176470588235295,0.98723099199017461,7093]
[12,1947,5556,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,0.17647058823529413,0.92889949164726959,6849]
[13,1948,3278,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,0.19117647058823528,0.87356913461508812,6610]
[14,1949,5281,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,0.20588235294117646,0.82079208833238126,5689]
[15,1950,3177,null,null,null,"histogram",null,"relative","cumulative",null,null,null,null,null,null,null,null,null,15,0.22058823529411764,0.77020808187547585,5665]
[16,1951,3419,null,null,null,null,"frequency()","frequency","frequency","index value",null,null,null,null,null,null,null,null,16,0.23529411764705882,0.72152228398234308,5646]
[17,1952,746,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,17,0.25,0.67448975019608193,5632]
[18,1953,5632,null,null,null,1000,null,null,null,{"$f":"AVERAGE(G20:G21)","v":500},null,null,null,null,null,null,null,null,18,0.26470588235294118,0.62890421763218995,5556]
[19,1954,1659,null,null,null,2000,null,null,null,1500,null,null,null,null,null,null,null,null,19,0.27941176470588236,0.58458985705947353,5299]
[20,1955,4539,null,null,null,3000,null,null,null,2500,null,null,null,null,null,null,null,null,20,0.29411764705882354,0.54139508512908763,5281]
[21,1956,2986,null,null,null,4000,null,null,null,3500,null,null,null,null,null,null,null,null,21,0.30882352941176472,0.49918784205087674,5057]
[22,1957,6849,null,null,null,5000,null,null,null,4500,null,null,null,null,null,null,null,null,22,0.3235294117647059,0.45785193101249527,4700]
[23,1958,1549,null,null,null,6000,null,null,null,5500,null,null,null,null,null,null,null,null,23,0.33823529411764708,0.41728413938902159,4539]
[24,1959,4051,null,null,null,7000,null,null,null,6500,null,null,null,null,null,null,null,null,24,0.35294117647058826,0.37739194382855357,4461]
[25,1960,975,null,null,null,8000,null,null,null,7500,null,null,null,null,null,null,null,null,25,0.36764705882352944,0.33809165680420711,4355]
[26,1961,1260,null,null,null,9000,null,null,null,8500,null,null,null,null,null,null,null,null,26,0.38235294117647056,0.29930691046566715,4294]
[27,1962,4355,null,null,null,10000,null,null,null,9500,null,null,null,null,null,null,null,null,27,0.39705882352941174,0.26096740040145311,4214]
[28,1963,9622,null,null,null,11000,null,null,null,10500,null,null,null,null,null,null,null,null,28,0.41176470588235292,0.22300783094036683,4182]
[29,1964,5299,null,null,null,12000,null,null,null,11500,null,null,null,null,null,null,null,null,29,0.4264705882352941,0.18536701728959662,4145]
[30,1965,7093,null,null,null,13000,null,null,null,12500,null,null,null,null,null,null,null,null,30,0.44117647058823528,0.14798710972583889,4051]
[31,1966,14367,null,null,null,14000,null,null,null,13500,null,null,null,null,null,null,null,null,31,0.45588235294117646,0.11081291229915714,4043]
[32,1967,2626,null,null,null,15000,null,null,null,14500,null,null,null,null,null,null,null,null,32,0.47058823529411764,7.3791273808272689E-2,3914]
[33,1968,1898,null,null,null,16000,null,null,null,15500,null,null,null,null,null,null,null,null,33,0.48529411764705882,3.6870532662080152E-2,3552]
[34,1969,8273,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,34,0.5,0,3419]
[35,1970,5646,null,null,null,"sample size:",{"$f":"SUM(H21:H36)","v":0},{"$f":"SUM(I21:I36)","v":0},null,null,null,null,null,null,null,null,null,null,35,0.51470588235294112,-3.6870532662080152E-2,3354]
[36,1971,3552,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,36,0.52941176470588236,-7.3791273808272689E-2,3316]
[37,1972,2041,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,37,0.54411764705882348,-0.11081291229915685,3278]
[38,1973,2700,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,38,0.55882352941176472,-0.14798710972583889,3270]
[39,1974,1545,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,39,0.57352941176470584,-0.18536701728959662,3177]
[40,1975,2064,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,40,0.58823529411764708,-0.22300783094036683,3165]
[41,1976,1851,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,41,0.6029411764705882,-0.26096740040145278,2986]
[42,1977,6610,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,42,0.61764705882352944,-0.29930691046566715,2864]
[43,1978,1211,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,43,0.63235294117647056,-0.33809165680420711,2845]
[44,1979,2712,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,44,0.6470588235294118,-0.37739194382855401,2828]
[45,1980,2828,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,45,0.66176470588235292,-0.41728413938902159,2755]
[46,1981,3914,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,46,0.67647058823529416,-0.45785193101249527,2712]
[47,1982,10694,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,47,0.69117647058823528,-0.49918784205087674,2700]
[48,1983,2864,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,48,0.70588235294117652,-0.54139508512908796,2629]
[49,1984,2021,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,49,0.72058823529411764,-0.58458985705947353,2626]
[50,1985,9478,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50,0.73529411764705888,-0.62890421763218995,2488]
[51,1986,1556,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,51,0.75,-0.67448975019608193,2441]
[52,1987,3354,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,52,0.76470588235294112,-0.72152228398234308,2220]
[53,1988,2488,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,53,0.77941176470588236,-0.77020808187547585,2064]
[54,1989,4700,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,54,0.79411764705882348,-0.82079208833238049,2041]
[55,1990,7905,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,55,0.80882352941176472,-0.87356913461508812,2021]
[56,1991,4145,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,56,0.82352941176470584,-0.92889949164726959,1908]
[57,1992,5665,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,57,0.83823529411764708,-0.98723099199017461,1898]
[58,1993,3165,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,58,0.8529411764705882,-1.0491313979639725,1851]
[59,1994,4043,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,59,0.86764705882352944,-1.1153373577337866,1659]
[60,1995,7391,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,60,0.88235294117647056,-1.186831432755818,1556]
[61,1996,1908,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,61,0.8970588235294118,-1.2649692448841479,1549]
[62,1997,4182,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,62,0.91176470588235292,-1.3517022399306602,1545]
[63,1998,2845,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,63,0.92647058823529416,-1.4499989087404506,1260]
[64,1999,2220,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,64,0.94117647058823528,-1.5647264713617985,1211]
[65,2000,5689,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,65,0.95588235294117652,-1.7047809048894009,992]
[66,2001,4214,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,66,{"$f":"T69/($F$10+1)","v":0.97058823529411764},{"$f":"NORMSINV(1-U69)","v":-1.8895099603334296},{"$f":"LARGE($C$4:$C$70,T69)","v":975}]
[67,2002,2755,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,67,0.98529411764705888,-2.1779230690821856,746]

{"sheet":"Uniform","index":2,"n_rows":70,"n_cols":47,"rows_kept":70,"cut":false,"hidden":false,"merged":[]}
["Fitting a probability distribution to data",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Weibull",null,null,{"$f":"CORREL(Z4:Z70,W4:W70)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"interpolation",null,"A","B","C","E"]
[null,null,"annual",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"plotting","deviate of","ranked","uniform distribution",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"first",null,"second"]
[null,"year","peak flow",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"position","plot pos","flows","p","quantile",null,null,null,null,null,null,null,null,null,"exc prob","dev ","CDF",null,"lower","upper","lower","upper","lower","upper","interp"]
[1,1936,4294,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"V4/($V$70+1)","v":1.4705882352941176E-2},{"$f":"NORMSINV(1-W4)","v":2.1779230690821856},{"$f":"LARGE($C$4:$C$70,V4)","v":14367},{"$f":"1-(Y4-$G$9)/($G$10-$G$9)","v":{"$error":"#DIV/0!"}},{"$f":"$G$9+($G$10-$G$9)*(1-W4)","v":0},null,null,null,null,null,null,null,null,null,0.98,{"$f":"NORMSINV(1-AK4)","v":-2.0537489106318221},{"$f":"AU4","v":{"$error":"#N/A"}},null,{"$f":"MATCH(1-AK4,$K$17:$K$32,1)","v":{"$error":"#N/A"}},{"$f":"IF(AO4<16,AO4+1,AO4)","v":{"$error":"#N/A"}},{"$f":"IF(AO4<>AP4,INDEX($I$17:$I$32,AO4),INDEX($I$17:$I$32,AO4-1))","v":{"$error":"#N/A"}},{"$f":"INDEX($I$17:$I$32,AP4)","v":{"$error":"#N/A"}},{"$f":"IF(AO4<>AP4,INDEX($K$17:$K$32,AO4),INDEX($K$17:$K$32,AO4-1))","v":{"$error":"#N/A"}},{"$f":"INDEX($K$17:$K$32,AP4)","v":{"$error":"#N/A"}},{"$f":"AQ4+(AR4-AQ4)*(1-AK4-AS4)/(AT4-AS4)","v":{"$error":"#N/A"}}]
[2,1937,992,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,{"$f":"V5/($V$70+1)","v":2.9411764705882353E-2},{"$f":"NORMSINV(1-W5)","v":1.8895099603334296},{"$f":"LARGE($C$4:$C$70,V5)","v":12007},{"$error":"#DIV/0!"},0,null,null,null,null,null,null,null,null,null,0.95,-1.6448536269514715,{"$f":"AU5","v":{"$error":"#N/A"}},null,{"$f":"MATCH(1-AK5,$K$17:$K$32,1)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"IF(AO5<>AP5,INDEX($I$17:$I$32,AO5),INDEX($I$17:$I$32,AO5-1))","v":{"$error":"#N/A"}},{"$f":"INDEX($I$17:$I$32,AP5)","v":{"$error":"#N/A"}},{"$f":"IF(AO5<>AP5,INDEX($K$17:$K$32,AO5),INDEX($K$17:$K$32,AO5-1))","v":{"$error":"#N/A"}},{"$f":"INDEX($K$17:$K$32,AP5)","v":{"$error":"#N/A"}},{"$f":"AQ5+(AR5-AQ5)*(1-AK5-AS5)/(AT5-AS5)","v":{"$error":"#N/A"}}]
[3,1938,2629,null,null,"fit a uniform distribution",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,4.4117647058823532E-2,1.7047809048894009,10694,{"$error":"#DIV/0!"},0,null,null,null,null,null,null,null,null,null,0.9,-1.2815515655446006,{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[4,1939,8157,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,5.8823529411764705E-2,1.5647264713617985,10192,{"$error":"#DIV/0!"},0,null,null,null,null,null,null,null,null,null,0.85,-1.0364333894937898,{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[5,1940,3316,null,null,"parameters are:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,7.3529411764705885E-2,1.4499989087404508,9622,{"$error":"#DIV/0!"},0,null,null,null,null,null,null,null,null,null,0.8,-0.84162123357291474,{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[6,1941,10192,null,null,"min =",null,"a",null,null,null,null,null,null,null,null,null,null,null,null,null,6,8.8235294117647065E-2,1.3517022399306602,9478,{"$error":"#DIV/0!"},0,null,null,null,null,null,null,null,null,null,0.75,-0.67448975019608193,{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[7,1942,3270,null,null,"max =",null,"b",null,null,null,null,null,null,null,null,null,null,null,null,null,7,0.10294117647058823,1.2649692448841479,8273,{"$error":"#DIV/0!"},0,null,null,null,null,null,null,null,null,null,0.7,-0.52440051270804078,{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[8,1943,12007,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,0.11764705882352941,1.186831432755818,8157,{"$error":"#DIV/0!"},0,null,null,null,null,null,null,null,null,null,0.65,-0.38532046640756784,{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[9,1944,2441,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,0.13235294117647059,1.1153373577337866,7905,{"$error":"#DIV/0!"},0,null,null,null,null,null,null,null,null,null,0.6,-0.25334710313579978,{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[10,1945,5057,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,0.14705882352941177,1.0491313979639725,7391,{"$error":"#DIV/0!"},0,null,null,null,null,null,null,null,null,null,0.55000000000000104,-0.12566134685507668,{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[11,1946,4461,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,0.16176470588235295,0.98723099199017461,7093,{"$error":"#DIV/0!"},0,null,null,null,null,null,null,null,null,null,0.500000000000001,-2.5046247822045905E-15,{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[12,1947,5556,null,"histogram",null,null,null,"Uniform Distribution PDF and CDF",null,null,null,null,null,null,null,null,null,null,null,null,12,0.17647058823529413,0.92889949164726959,6849,{"$error":"#DIV/0!"},0,null,null,null,null,null,null,null,null,null,0.45000000000000101,0.12566134685507138,{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[13,1948,3278,null,0,"frequency()","rel freq.","cum. freq","index","PDF","CDF",null,null,null,null,null,null,null,null,null,null,13,0.19117647058823528,0.87356913461508812,6610,{"$error":"#DIV/0!"},0,null,null,null,null,null,null,null,null,null,0.40000000000000102,0.25334710313579717,{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[14,1949,5281,null,1000,{"$f":"FREQUENCY(C4:C70,E17:E32)","v":3},{"$f":"F17/SUM($F$17:$F$32)","v":4.4776119402985072E-2},{"$f":"G17","v":4.4776119402985072E-2},{"$f":"AVERAGE(E16:E17)","v":500},{"$f":"1/($G$10-$G$9)*1000","v":{"$error":"#DIV/0!"}},{"$f":"IF(I17<$G$9,0,IF(I17>$G$10,1,(I17-$G$9)/($G$10-$G$9)))","v":1},null,null,null,null,null,null,null,null,null,null,14,0.20588235294117646,0.82079208833238126,5689,{"$error":"#DIV/0!"},0,null,null,null,null,null,null,null,null,null,0.35000000000000098,0.38532046640756507,{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[15,1950,3177,null,2000,9,{"$f":"F18/SUM($F$17:$F$32)","v":0.13432835820895522},{"$f":"H17+G18","v":0.17910447761194029},{"$f":"AVERAGE(E17:E18)","v":1500},{"$error":"#DIV/0!"},{"$f":"IF(I18<$G$9,0,IF(I18>$G$10,1,(I18-$G$9)/($G$10-$G$9)))","v":1},null,null,null,null,null,null,null,null,null,null,15,0.22058823529411764,0.77020808187547585,5665,{"$error":"#DIV/0!"},0,null,null,null,null,null,null,null,null,null,0.30000000000000099,0.52440051270803822,{"$error":"#N/A"},null,{"$error":"#N/A"},{"$f":"IF(AO18<16,AO18+1,AO18)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[16,1951,3419,null,3000,15,0.22388059701492538,{"$f":"H18+G19","v":0.40298507462686567},{"$f":"AVERAGE(E18:E19)","v":2500},{"$error":"#DIV/0!"},1,null,null,null,null,null,null,null,null,null,null,16,0.23529411764705882,0.72152228398234308,5646,{"$error":"#DIV/0!"},0,null,null,null,null,null,null,null,null,null,0.250000000000001,0.6744897501960786,{"$error":"#N/A"},null,{"$error":"#N/A"},{"$f":"IF(AO19<16,AO19+1,AO19)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[17,1952,746,null,4000,9,0.13432835820895522,0.53731343283582089,3500,{"$error":"#DIV/0!"},1,null,null,null,null,null,null,null,null,null,null,17,0.25,0.67448975019608193,5632,{"$error":"#DIV/0!"},0,null,null,null,null,null,null,null,null,null,0.20000000000000101,0.84162123357291074,{"$error":"#N/A"},null,{"$error":"#N/A"},{"$f":"IF(AO20<16,AO20+1,AO20)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[18,1953,5632,null,5000,10,0.14925373134328357,0.68656716417910446,4500,{"$error":"#DIV/0!"},1,null,null,null,null,null,null,null,null,null,null,18,0.26470588235294118,0.62890421763218995,5556,{"$error":"#DIV/0!"},0,null,null,null,null,null,null,null,null,null,0.15000000000000099,1.0364333894937861,{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[19,1954,1659,null,6000,8,0.11940298507462686,0.80597014925373134,5500,{"$error":"#DIV/0!"},1,null,null,null,null,null,null,null,null,null,null,19,0.27941176470588236,0.58458985705947353,5299,{"$error":"#DIV/0!"},0,null,null,null,null,null,null,null,null,null,0.100000000000001,1.2815515655445955,{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[20,1955,4539,null,7000,2,2.9850746268656716E-2,0.83582089552238803,6500,{"$error":"#DIV/0!"},1,null,null,null,null,null,null,null,null,null,null,20,0.29411764705882354,0.54139508512908763,5281,{"$error":"#DIV/0!"},0,null,null,null,null,null,null,null,null,null,5.0000000000000898E-2,1.6448536269514629,{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[21,1956,2986,null,8000,3,4.4776119402985072E-2,0.88059701492537312,7500,{"$error":"#DIV/0!"},1,null,null,null,null,null,null,null,null,null,null,21,0.30882352941176472,0.49918784205087674,5057,{"$error":"#DIV/0!"},0,null,null,null,null,null,null,null,null,null,0.02,2.0537489106318221,{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[22,1957,6849,null,9000,2,2.9850746268656716E-2,0.91044776119402981,8500,{"$error":"#DIV/0!"},1,null,null,null,null,null,null,null,null,null,null,22,0.3235294117647059,0.45785193101249527,4700,{"$error":"#DIV/0!"},0,null,null,null,null,null,null,null,null,null,0.01,2.3263478740408408,{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[23,1958,1549,null,10000,2,2.9850746268656716E-2,0.94029850746268651,9500,{"$error":"#DIV/0!"},1,null,null,null,null,null,null,null,null,null,null,23,0.33823529411764708,0.41728413938902159,4539,{"$error":"#DIV/0!"},0]
[24,1959,4051,null,11000,2,2.9850746268656716E-2,0.9701492537313432,10500,{"$error":"#DIV/0!"},1,null,null,null,null,null,null,null,null,null,null,24,0.35294117647058826,0.37739194382855357,4461,{"$error":"#DIV/0!"},0]
[25,1960,975,null,12000,0,0,0.9701492537313432,11500,{"$error":"#DIV/0!"},1,null,null,null,null,null,null,null,null,null,null,25,0.36764705882352944,0.33809165680420711,4355,{"$error":"#DIV/0!"},0]
[26,1961,1260,null,13000,1,1.4925373134328358E-2,0.9850746268656716,12500,{"$error":"#DIV/0!"},1,null,null,null,null,null,null,null,null,null,null,26,0.38235294117647056,0.29930691046566715,4294,{"$error":"#DIV/0!"},0,null,null,null,null,null,null,null,null,null,null,0,0]
[27,1962,4355,null,14000,0,0,0.9850746268656716,13500,{"$error":"#DIV/0!"},1,null,null,null,null,null,null,null,null,null,null,27,0.39705882352941174,0.26096740040145311,4214,{"$error":"#DIV/0!"},0,null,null,null,null,null,null,null,null,null,null,1,16000]
[28,1963,9622,null,15000,1,1.4925373134328358E-2,1,14500,{"$error":"#DIV/0!"},1,null,null,null,null,null,null,null,null,null,null,28,0.41176470588235292,0.22300783094036683,4182,{"$error":"#DIV/0!"},0]
[29,1964,5299,null,16000,0,0,1,15500,{"$error":"#DIV/0!"},1,null,null,null,null,null,null,null,null,null,null,29,0.4264705882352941,0.18536701728959662,4145,{"$error":"#DIV/0!"},0,null,null,null,null,null,null,null,null,null,null,1.0000000000000001E-5,100000]
[30,1965,7093,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,0.44117647058823528,0.14798710972583889,4051,{"$error":"#DIV/0!"},0,null,null,null,null,null,null,null,null,null,0.95,{"$f":"NORMSINV(1-AK33)","v":-1.6448536269514715},{"$f":"AL33","v":-1.6448536269514715},0,100]
[31,1966,14367,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,31,0.45588235294117646,0.11081291229915714,4043,{"$error":"#DIV/0!"},0,null,null,null,null,null,null,null,null,null,0.9,{"$f":"NORMSINV(1-AK34)","v":-1.2815515655446006},{"$f":"AL34","v":-1.2815515655446006},0,100]
[32,1967,2626,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,32,0.47058823529411764,7.3791273808272689E-2,3914,{"$error":"#DIV/0!"},0,null,null,null,null,null,null,null,null,null,0.75,-0.67448975019608193,-0.67448975019608193,0,100]
[33,1968,1898,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,33,0.48529411764705882,3.6870532662080152E-2,3552,{"$error":"#DIV/0!"},0,null,null,null,null,null,null,null,null,null,0.5,0,0,0,100]
[34,1969,8273,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,34,0.5,0,3419,{"$error":"#DIV/0!"},0,null,null,null,null,null,null,null,null,null,0.25,0.67448975019608193,0.67448975019608193,0,100]
[35,1970,5646,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,35,0.51470588235294112,-3.6870532662080152E-2,3354,{"$error":"#DIV/0!"},0,null,null,null,null,null,null,null,null,null,0.1,1.2815515655446006,1.2815515655446006,0,100]
[36,1971,3552,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,36,0.52941176470588236,-7.3791273808272689E-2,3316,{"$error":"#DIV/0!"},0,null,null,null,null,null,null,null,null,null,0.05,1.6448536269514715,1.6448536269514715,0,100]
[37,1972,2041,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,37,0.54411764705882348,-0.11081291229915685,3278,{"$error":"#DIV/0!"},0,null,null,null,null,null,null,null,null,null,0.02,2.0537489106318221,2.0537489106318221,0,100]
[38,1973,2700,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,38,0.55882352941176472,-0.14798710972583889,3270,{"$error":"#DIV/0!"},0,null,null,null,null,null,null,null,null,null,0.01,2.3263478740408408,2.3263478740408408,0,100]
[39,1974,1545,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,39,0.57352941176470584,-0.18536701728959662,3177,{"$error":"#DIV/0!"},0]
[40,1975,2064,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,40,0.58823529411764708,-0.22300783094036683,3165,{"$error":"#DIV/0!"},0]
[41,1976,1851,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,41,0.6029411764705882,-0.26096740040145278,2986,{"$error":"#DIV/0!"},0]
[42,1977,6610,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,42,0.61764705882352944,-0.29930691046566715,2864,{"$error":"#DIV/0!"},0]
[43,1978,1211,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,43,0.63235294117647056,-0.33809165680420711,2845,{"$error":"#DIV/0!"},0]
[44,1979,2712,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,44,0.6470588235294118,-0.37739194382855401,2828,{"$error":"#DIV/0!"},0]
[45,1980,2828,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,45,0.66176470588235292,-0.41728413938902159,2755,{"$error":"#DIV/0!"},0]
[46,1981,3914,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,46,0.67647058823529416,-0.45785193101249527,2712,{"$error":"#DIV/0!"},0]
[47,1982,10694,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,47,0.69117647058823528,-0.49918784205087674,2700,{"$error":"#DIV/0!"},0]
[48,1983,2864,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,48,0.70588235294117652,-0.54139508512908796,2629,{"$error":"#DIV/0!"},0]
[49,1984,2021,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,49,0.72058823529411764,-0.58458985705947353,2626,{"$error":"#DIV/0!"},0]
[50,1985,9478,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50,0.73529411764705888,-0.62890421763218995,2488,{"$error":"#DIV/0!"},0]
[51,1986,1556,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,51,0.75,-0.67448975019608193,2441,{"$error":"#DIV/0!"},0]
[52,1987,3354,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,52,0.76470588235294112,-0.72152228398234308,2220,{"$error":"#DIV/0!"},0]
[53,1988,2488,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,53,0.77941176470588236,-0.77020808187547585,2064,{"$error":"#DIV/0!"},0]
[54,1989,4700,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,54,0.79411764705882348,-0.82079208833238049,2041,{"$error":"#DIV/0!"},0]
[55,1990,7905,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,55,0.80882352941176472,-0.87356913461508812,2021,{"$error":"#DIV/0!"},0]
[56,1991,4145,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,56,0.82352941176470584,-0.92889949164726959,1908,{"$error":"#DIV/0!"},0]
[57,1992,5665,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,57,0.83823529411764708,-0.98723099199017461,1898,{"$error":"#DIV/0!"},0]
[58,1993,3165,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,58,0.8529411764705882,-1.0491313979639725,1851,{"$error":"#DIV/0!"},0]
[59,1994,4043,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,59,0.86764705882352944,-1.1153373577337866,1659,{"$error":"#DIV/0!"},0]
[60,1995,7391,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,60,0.88235294117647056,-1.186831432755818,1556,{"$error":"#DIV/0!"},0]
[61,1996,1908,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,61,0.8970588235294118,-1.2649692448841479,1549,{"$error":"#DIV/0!"},0]
[62,1997,4182,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,62,0.91176470588235292,-1.3517022399306602,1545,{"$error":"#DIV/0!"},0]
[63,1998,2845,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,63,0.92647058823529416,-1.4499989087404506,1260,{"$error":"#DIV/0!"},0]
[64,1999,2220,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,64,0.94117647058823528,-1.5647264713617985,1211,{"$error":"#DIV/0!"},0]
[65,2000,5689,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,65,0.95588235294117652,-1.7047809048894009,992,{"$f":"1-(Y68-$G$9)/($G$10-$G$9)","v":{"$error":"#DIV/0!"}},{"$f":"$G$9+($G$10-$G$9)*(1-W68)","v":0}]
[66,2001,4214,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,66,{"$f":"V69/($V$70+1)","v":0.97058823529411764},{"$f":"NORMSINV(1-W69)","v":-1.8895099603334296},{"$f":"LARGE($C$4:$C$70,V69)","v":975},{"$error":"#DIV/0!"},0]
[67,2002,2755,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,67,0.98529411764705888,-2.1779230690821856,746,{"$error":"#DIV/0!"},0]

{"sheet":"Triangular","index":3,"n_rows":70,"n_cols":49,"rows_kept":70,"cut":false,"hidden":false,"merged":[]}
["Fitting a probability distribution to data",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Weibull",null,null,{"$f":"CORREL(Z4:Z70,W4:W70)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"interpolation",null,"A","B","C","E"]
[null,null,"annual",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"plotting","deviate of","ranked","triangular distribution",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"first",null,"second"]
[null,"year","peak flow",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"position","plot pos","flows","p","quantile",null,null,null,null,null,null,null,null,null,"exc prob","dev ","CDF",null,"lower","upper","lower","upper","lower","upper","interp"]
[1,1936,4294,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"V4/($V$70+1)","v":1.4705882352941176E-2},{"$f":"NORMSINV(1-W4)","v":2.1779230690821856},{"$f":"LARGE($C$4:$C$70,V4)","v":14367},{"$f":"1-IF(Y4<=$G$10,(Y4-$G$9)^2/($G$11-$G$9)/($G$10-$G$9),1-($G$11-Y4)^2/($G$11-$G$9)/($G$11-$G$10))","v":{"$error":"#DIV/0!"}},{"$f":"IF((1-W4)<$AK$1,$G$9+SQRT((1-W4)*($G$11-$G$9)*($G$10-$G$9)),$G$11-SQRT(W4*($G$11-$G$9)*($G$11-$G$10)))","v":0},null,null,null,null,null,null,null,null,null,0.98,{"$f":"NORMSINV(1-AK4)","v":-2.0537489106318221},{"$f":"AU4","v":{"$error":"#N/A"}},null,{"$f":"MATCH(1-AK4,$K$17:$K$32,1)","v":{"$error":"#N/A"}},{"$f":"IF(AO4<16,AO4+1,AO4)","v":{"$error":"#N/A"}},{"$f":"IF(AO4<>AP4,INDEX($I$17:$I$32,AO4),INDEX($I$17:$I$32,AO4-1))","v":{"$error":"#N/A"}},{"$f":"INDEX($I$17:$I$32,AP4)","v":{"$error":"#N/A"}},{"$f":"IF(AO4<>AP4,INDEX($K$17:$K$32,AO4),INDEX($K$17:$K$32,AO4-1))","v":{"$error":"#N/A"}},{"$f":"INDEX($K$17:$K$32,AP4)","v":{"$error":"#N/A"}},{"$f":"AQ4+(AR4-AQ4)*(1-AK4-AS4)/(AT4-AS4)","v":{"$error":"#N/A"}}]
[2,1937,992,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,{"$f":"V5/($V$70+1)","v":2.9411764705882353E-2},{"$f":"NORMSINV(1-W5)","v":1.8895099603334296},{"$f":"LARGE($C$4:$C$70,V5)","v":12007},{"$f":"1-IF(Y5<=$G$10,(Y5-$G$9)^2/($G$11-$G$9)/($G$10-$G$9),1-($G$11-Y5)^2/($G$11-$G$9)/($G$11-$G$10))","v":{"$error":"#DIV/0!"}},0,null,null,null,null,null,null,null,null,null,0.95,-1.6448536269514715,{"$f":"AU5","v":{"$error":"#N/A"}},null,{"$f":"MATCH(1-AK5,$K$17:$K$32,1)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"IF(AO5<>AP5,INDEX($I$17:$I$32,AO5),INDEX($I$17:$I$32,AO5-1))","v":{"$error":"#N/A"}},{"$f":"INDEX($I$17:$I$32,AP5)","v":{"$error":"#N/A"}},{"$f":"IF(AO5<>AP5,INDEX($K$17:$K$32,AO5),INDEX($K$17:$K$32,AO5-1))","v":{"$error":"#N/A"}},{"$f":"INDEX($K$17:$K$32,AP5)","v":{"$error":"#N/A"}},{"$f":"AQ5+(AR5-AQ5)*(1-AK5-AS5)/(AT5-AS5)","v":{"$error":"#N/A"}}]
[3,1938,2629,null,null,"fit a triangular distribution",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,4.4117647058823532E-2,1.7047809048894009,10694,{"$error":"#DIV/0!"},0,null,null,null,null,null,null,null,null,null,0.9,-1.2815515655446006,{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[4,1939,8157,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,5.8823529411764705E-2,1.5647264713617985,10192,{"$error":"#DIV/0!"},0,null,null,null,null,null,null,null,null,null,0.85,-1.0364333894937898,{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[5,1940,3316,null,null,"parameters are:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,7.3529411764705885E-2,1.4499989087404508,9622,{"$error":"#DIV/0!"},0,null,null,null,null,null,null,null,null,null,0.8,-0.84162123357291474,{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[6,1941,10192,null,null,"min =",null,"a",null,null,null,null,null,null,null,null,null,null,null,null,null,6,8.8235294117647065E-2,1.3517022399306602,9478,{"$error":"#DIV/0!"},0,null,null,null,null,null,null,null,null,null,0.75,-0.67448975019608193,{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[7,1942,3270,null,null,"mode =",null,"c",null,null,null,null,null,null,null,null,null,null,null,null,null,7,0.10294117647058823,1.2649692448841479,8273,{"$error":"#DIV/0!"},0,null,null,null,null,null,null,null,null,null,0.7,-0.52440051270804078,{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[8,1943,12007,null,null,"max =",null,"b",null,null,null,null,null,null,null,null,null,null,null,null,null,8,0.11764705882352941,1.186831432755818,8157,{"$error":"#DIV/0!"},0,null,null,null,null,null,null,null,null,null,0.65,-0.38532046640756784,{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[9,1944,2441,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,0.13235294117647059,1.1153373577337866,7905,{"$error":"#DIV/0!"},0,null,null,null,null,null,null,null,null,null,0.6,-0.25334710313579978,{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[10,1945,5057,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,0.14705882352941177,1.0491313979639725,7391,{"$error":"#DIV/0!"},0,null,null,null,null,null,null,null,null,null,0.55000000000000104,-0.12566134685507668,{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[11,1946,4461,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,0.16176470588235295,0.98723099199017461,7093,{"$error":"#DIV/0!"},0,null,null,null,null,null,null,null,null,null,0.500000000000001,-2.5046247822045905E-15,{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[12,1947,5556,null,"histogram",null,null,null,"Triangular Distribution PDF and CDF",null,null,null,null,null,null,null,null,null,null,null,null,12,0.17647058823529413,0.92889949164726959,6849,{"$error":"#DIV/0!"},0,null,null,null,null,null,null,null,null,null,0.45000000000000101,0.12566134685507138,{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[13,1948,3278,null,0,"frequency()","rel freq.","cum. freq","index","PDF","CDF",null,null,null,null,null,null,null,null,null,null,13,0.19117647058823528,0.87356913461508812,6610,{"$error":"#DIV/0!"},0,null,null,null,null,null,null,null,null,null,0.40000000000000102,0.25334710313579717,{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[14,1949,5281,null,1000,{"$f":"FREQUENCY(C4:C70,E17:E32)","v":3},{"$f":"F17/SUM($F$17:$F$32)","v":4.4776119402985072E-2},{"$f":"G17","v":4.4776119402985072E-2},{"$f":"AVERAGE(E16:E17)","v":500},{"$f":"IF(I17<=$G$10,2*(I17-$G$9)/($G$11-$G$9)/($G$10-$G$9),2*($G$11-I17)/($G$11-$G$9)/($G$11-$G$10))*1000","v":{"$error":"#DIV/0!"}},{"$f":"IF(I17<=$G$10,(I17-$G$9)^2/($G$11-$G$9)/($G$10-$G$9),1-($G$11-I17)^2/($G$11-$G$9)/($G$11-$G$10))","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,14,0.20588235294117646,0.82079208833238126,5689,{"$error":"#DIV/0!"},0,null,null,null,null,null,null,null,null,null,0.35000000000000098,0.38532046640756507,{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[15,1950,3177,null,2000,9,{"$f":"F18/SUM($F$17:$F$32)","v":0.13432835820895522},{"$f":"H17+G18","v":0.17910447761194029},{"$f":"AVERAGE(E17:E18)","v":1500},{"$f":"IF(I18<=$G$10,2*(I18-$G$9)/($G$11-$G$9)/($G$10-$G$9),2*($G$11-I18)/($G$11-$G$9)/($G$11-$G$10))*1000","v":{"$error":"#DIV/0!"}},{"$f":"IF(I18<=$G$10,(I18-$G$9)^2/($G$11-$G$9)/($G$10-$G$9),1-($G$11-I18)^2/($G$11-$G$9)/($G$11-$G$10))","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,15,0.22058823529411764,0.77020808187547585,5665,{"$error":"#DIV/0!"},0,null,null,null,null,null,null,null,null,null,0.30000000000000099,0.52440051270803822,{"$error":"#N/A"},null,{"$error":"#N/A"},{"$f":"IF(AO18<16,AO18+1,AO18)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[16,1951,3419,null,3000,15,0.22388059701492538,{"$f":"H18+G19","v":0.40298507462686567},{"$f":"AVERAGE(E18:E19)","v":2500},{"$f":"IF(I19<=$G$10,2*(I19-$G$9)/($G$11-$G$9)/($G$10-$G$9),2*($G$11-I19)/($G$11-$G$9)/($G$11-$G$10))*1000","v":{"$error":"#DIV/0!"}},{"$f":"IF(I19<=$G$10,(I19-$G$9)^2/($G$11-$G$9)/($G$10-$G$9),1-($G$11-I19)^2/($G$11-$G$9)/($G$11-$G$10))","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,16,0.23529411764705882,0.72152228398234308,5646,{"$error":"#DIV/0!"},0,null,null,null,null,null,null,null,null,null,0.250000000000001,0.6744897501960786,{"$error":"#N/A"},null,{"$error":"#N/A"},{"$f":"IF(AO19<16,AO19+1,AO19)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[17,1952,746,null,4000,9,0.13432835820895522,0.53731343283582089,3500,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,null,null,17,0.25,0.67448975019608193,5632,{"$error":"#DIV/0!"},0,null,null,null,null,null,null,null,null,null,0.20000000000000101,0.84162123357291074,{"$error":"#N/A"},null,{"$f":"MATCH(1-AK20,$K$17:$K$32,1)","v":{"$error":"#N/A"}},{"$f":"IF(AO20<16,AO20+1,AO20)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[18,1953,5632,null,5000,10,0.14925373134328357,0.68656716417910446,4500,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,null,null,18,0.26470588235294118,0.62890421763218995,5556,{"$error":"#DIV/0!"},0,null,null,null,null,null,null,null,null,null,0.15000000000000099,1.0364333894937861,{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[19,1954,1659,null,6000,8,0.11940298507462686,0.80597014925373134,5500,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,null,null,19,0.27941176470588236,0.58458985705947353,5299,{"$error":"#DIV/0!"},0,null,null,null,null,null,null,null,null,null,0.100000000000001,1.2815515655445955,{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[20,1955,4539,null,7000,2,2.9850746268656716E-2,0.83582089552238803,6500,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,null,null,20,0.29411764705882354,0.54139508512908763,5281,{"$error":"#DIV/0!"},0,null,null,null,null,null,null,null,null,null,5.0000000000000898E-2,1.6448536269514629,{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[21,1956,2986,null,8000,3,4.4776119402985072E-2,0.88059701492537312,7500,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,null,null,21,0.30882352941176472,0.49918784205087674,5057,{"$error":"#DIV/0!"},0,null,null,null,null,null,null,null,null,null,0.02,2.0537489106318221,{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[22,1957,6849,null,9000,2,2.9850746268656716E-2,0.91044776119402981,8500,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,null,null,22,0.3235294117647059,0.45785193101249527,4700,{"$error":"#DIV/0!"},0,null,null,null,null,null,null,null,null,null,0.01,2.3263478740408408,{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[23,1958,1549,null,10000,2,2.9850746268656716E-2,0.94029850746268651,9500,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,null,null,23,0.33823529411764708,0.41728413938902159,4539,{"$error":"#DIV/0!"},0]
[24,1959,4051,null,11000,2,2.9850746268656716E-2,0.9701492537313432,10500,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,null,null,24,0.35294117647058826,0.37739194382855357,4461,{"$error":"#DIV/0!"},0]
[25,1960,975,null,12000,0,0,0.9701492537313432,11500,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,null,null,25,0.36764705882352944,0.33809165680420711,4355,{"$error":"#DIV/0!"},0]
[26,1961,1260,null,13000,1,1.4925373134328358E-2,0.9850746268656716,12500,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,null,null,26,0.38235294117647056,0.29930691046566715,4294,{"$error":"#DIV/0!"},0]
[27,1962,4355,null,14000,0,0,0.9850746268656716,13500,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,null,null,27,0.39705882352941174,0.26096740040145311,4214,{"$error":"#DIV/0!"},0]
[28,1963,9622,null,15000,1,1.4925373134328358E-2,1,14500,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,null,null,28,0.41176470588235292,0.22300783094036683,4182,{"$error":"#DIV/0!"},0]
[29,1964,5299,null,16000,0,0,1,15500,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,null,null,29,0.4264705882352941,0.18536701728959662,4145,{"$error":"#DIV/0!"},0]
[30,1965,7093,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,0.44117647058823528,0.14798710972583889,4051,{"$error":"#DIV/0!"},0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,16000]
[31,1966,14367,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,31,0.45588235294117646,0.11081291229915714,4043,{"$error":"#DIV/0!"},0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.95,{"$f":"NORMSINV(1-AT34)","v":-1.6448536269514715},{"$f":"AU34","v":-1.6448536269514715},0]
[32,1967,2626,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,32,0.47058823529411764,7.3791273808272689E-2,3914,{"$error":"#DIV/0!"},0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.9,{"$f":"NORMSINV(1-AT35)","v":-1.2815515655446006},{"$f":"AU35","v":-1.2815515655446006},0]
[33,1968,1898,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,33,0.48529411764705882,3.6870532662080152E-2,3552,{"$error":"#DIV/0!"},0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.75,-0.67448975019608193,-0.67448975019608193,0]
[34,1969,8273,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,34,0.5,0,3419,{"$error":"#DIV/0!"},0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.5,0,0,0]
[35,1970,5646,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,35,0.51470588235294112,-3.6870532662080152E-2,3354,{"$error":"#DIV/0!"},0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.25,0.67448975019608193,0.67448975019608193,0]
[36,1971,3552,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,36,0.52941176470588236,-7.3791273808272689E-2,3316,{"$error":"#DIV/0!"},0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.1,1.2815515655446006,1.2815515655446006,0]
[37,1972,2041,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,37,0.54411764705882348,-0.11081291229915685,3278,{"$error":"#DIV/0!"},0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.05,1.6448536269514715,1.6448536269514715,0]
[38,1973,2700,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,38,0.55882352941176472,-0.14798710972583889,3270,{"$error":"#DIV/0!"},0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.02,2.0537489106318221,2.0537489106318221,0]
[39,1974,1545,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,39,0.57352941176470584,-0.18536701728959662,3177,{"$error":"#DIV/0!"},0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.01,2.3263478740408408,2.3263478740408408,0]
[40,1975,2064,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,40,0.58823529411764708,-0.22300783094036683,3165,{"$error":"#DIV/0!"},0]
[41,1976,1851,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,41,0.6029411764705882,-0.26096740040145278,2986,{"$error":"#DIV/0!"},0]
[42,1977,6610,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,42,0.61764705882352944,-0.29930691046566715,2864,{"$error":"#DIV/0!"},0]
[43,1978,1211,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,43,0.63235294117647056,-0.33809165680420711,2845,{"$error":"#DIV/0!"},0]
[44,1979,2712,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,44,0.6470588235294118,-0.37739194382855401,2828,{"$error":"#DIV/0!"},0]
[45,1980,2828,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,45,0.66176470588235292,-0.41728413938902159,2755,{"$error":"#DIV/0!"},0]
[46,1981,3914,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,46,0.67647058823529416,-0.45785193101249527,2712,{"$error":"#DIV/0!"},0]
[47,1982,10694,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,47,0.69117647058823528,-0.49918784205087674,2700,{"$error":"#DIV/0!"},0]
[48,1983,2864,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,48,0.70588235294117652,-0.54139508512908796,2629,{"$error":"#DIV/0!"},0]
[49,1984,2021,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,49,0.72058823529411764,-0.58458985705947353,2626,{"$error":"#DIV/0!"},0]
[50,1985,9478,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50,0.73529411764705888,-0.62890421763218995,2488,{"$error":"#DIV/0!"},0]
[51,1986,1556,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,51,0.75,-0.67448975019608193,2441,{"$error":"#DIV/0!"},0]
[52,1987,3354,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,52,0.76470588235294112,-0.72152228398234308,2220,{"$error":"#DIV/0!"},0]
[53,1988,2488,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,53,0.77941176470588236,-0.77020808187547585,2064,{"$error":"#DIV/0!"},0]
[54,1989,4700,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,54,0.79411764705882348,-0.82079208833238049,2041,{"$error":"#DIV/0!"},0]
[55,1990,7905,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,55,0.80882352941176472,-0.87356913461508812,2021,{"$error":"#DIV/0!"},0]
[56,1991,4145,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,56,0.82352941176470584,-0.92889949164726959,1908,{"$error":"#DIV/0!"},0]
[57,1992,5665,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,57,0.83823529411764708,-0.98723099199017461,1898,{"$error":"#DIV/0!"},0]
[58,1993,3165,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,58,0.8529411764705882,-1.0491313979639725,1851,{"$error":"#DIV/0!"},0]
[59,1994,4043,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,59,0.86764705882352944,-1.1153373577337866,1659,{"$error":"#DIV/0!"},0]
[60,1995,7391,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,60,0.88235294117647056,-1.186831432755818,1556,{"$error":"#DIV/0!"},0]
[61,1996,1908,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,61,0.8970588235294118,-1.2649692448841479,1549,{"$error":"#DIV/0!"},0]
[62,1997,4182,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,62,0.91176470588235292,-1.3517022399306602,1545,{"$error":"#DIV/0!"},0]
[63,1998,2845,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,63,0.92647058823529416,-1.4499989087404506,1260,{"$error":"#DIV/0!"},0]
[64,1999,2220,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,64,0.94117647058823528,-1.5647264713617985,1211,{"$error":"#DIV/0!"},0]
[65,2000,5689,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,65,0.95588235294117652,-1.7047809048894009,992,{"$error":"#DIV/0!"},{"$f":"IF((1-W68)<$AK$1,$G$9+SQRT((1-W68)*($G$11-$G$9)*($G$10-$G$9)),$G$11-SQRT(W68*($G$11-$G$9)*($G$11-$G$10)))","v":0}]
[66,2001,4214,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,66,{"$f":"V69/($V$70+1)","v":0.97058823529411764},{"$f":"NORMSINV(1-W69)","v":-1.8895099603334296},{"$f":"LARGE($C$4:$C$70,V69)","v":975},{"$f":"1-IF(Y69<=$G$10,(Y69-$G$9)^2/($G$11-$G$9)/($G$10-$G$9),1-($G$11-Y69)^2/($G$11-$G$9)/($G$11-$G$10))","v":{"$error":"#DIV/0!"}},0]
[67,2002,2755,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,67,0.98529411764705888,-2.1779230690821856,746,{"$error":"#DIV/0!"},0]

{"sheet":"Normal","index":4,"n_rows":70,"n_cols":44,"rows_kept":70,"cut":false,"hidden":false,"merged":[]}
["Fitting a probability distribution to data",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Weibull",null,null,{"$f":"CORREL(Z4:Z70,W4:W70)","v":{"$error":"#NUM!"}}]
[null,null,"annual",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"plotting","deviate of","ranked","Normal Distribution"]
[null,"year","peak flow",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"position","plot pos","flows","p","quantile",null,null,null,null,null,null,null,null,null,"exc prob","dev ","CDF"]
[1,1936,4294,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"V4/($V$70+1)","v":1.4705882352941176E-2},{"$f":"NORMSINV(1-W4)","v":2.1779230690821856},{"$f":"LARGE($C$4:$C$70,V4)","v":14367},{"$f":"1-_xlfn.NORM.DIST(Y4,$G$9,$G$10,TRUE)","v":{"$error":"#NUM!"}},{"$f":"_xlfn.NORM.INV(1-W4,$G$9,$G$10)","v":{"$error":"#NUM!"}},null,null,null,null,null,null,null,null,null,0.98,{"$f":"NORMSINV(1-AK4)","v":-2.0537489106318221},{"$f":"NORMINV(1-AK4,$G$9,$G$10)","v":{"$error":"#NUM!"}}]
[2,1937,992,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,{"$f":"V5/($V$70+1)","v":2.9411764705882353E-2},{"$f":"NORMSINV(1-W5)","v":1.8895099603334296},{"$f":"LARGE($C$4:$C$70,V5)","v":12007},{"$f":"1-_xlfn.NORM.DIST(Y5,$G$9,$G$10,TRUE)","v":{"$error":"#NUM!"}},{"$f":"_xlfn.NORM.INV(1-W5,$G$9,$G$10)","v":{"$error":"#NUM!"}},null,null,null,null,null,null,null,null,null,0.95,-1.6448536269514715,{"$f":"NORMINV(1-AK5,$G$9,$G$10)","v":{"$error":"#NUM!"}}]
[3,1938,2629,null,null,"fit a Normal distribution",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,4.4117647058823532E-2,1.7047809048894009,10694,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,null,null,0.9,-1.2815515655446006,{"$error":"#NUM!"}]
[4,1939,8157,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,5.8823529411764705E-2,1.5647264713617985,10192,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,null,null,0.85,-1.0364333894937898,{"$error":"#NUM!"}]
[5,1940,3316,null,null,"parameters are:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,7.3529411764705885E-2,1.4499989087404508,9622,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,null,null,0.8,-0.84162123357291474,{"$error":"#NUM!"}]
[6,1941,10192,null,null,"mean =",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,8.8235294117647065E-2,1.3517022399306602,9478,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,null,null,0.75,-0.67448975019608193,{"$error":"#NUM!"}]
[7,1942,3270,null,null,"stdev =",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,0.10294117647058823,1.2649692448841479,8273,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,null,null,0.7,-0.52440051270804078,{"$error":"#NUM!"},null,null,0,16000]
[8,1943,12007,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,0.11764705882352941,1.186831432755818,8157,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,null,null,0.65,-0.38532046640756784,{"$error":"#NUM!"},null,0.95,{"$f":"NORMSINV(1-AO11)","v":-1.6448536269514715},{"$f":"AP11","v":-1.6448536269514715},0]
[9,1944,2441,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,0.13235294117647059,1.1153373577337866,7905,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,null,null,0.6,-0.25334710313579978,{"$error":"#NUM!"},null,0.9,{"$f":"NORMSINV(1-AO12)","v":-1.2815515655446006},{"$f":"AP12","v":-1.2815515655446006},0]
[10,1945,5057,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,0.14705882352941177,1.0491313979639725,7391,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,null,null,0.55000000000000104,-0.12566134685507668,{"$error":"#NUM!"},null,0.75,-0.67448975019608193,-0.67448975019608193,0]
[11,1946,4461,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,0.16176470588235295,0.98723099199017461,7093,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,null,null,0.500000000000001,-2.5046247822045905E-15,{"$error":"#NUM!"},null,0.5,0,0,0]
[12,1947,5556,null,"histogram",null,null,null,"Normal Distribution PDF and CDF",null,null,null,null,null,null,null,null,null,null,null,null,12,0.17647058823529413,0.92889949164726959,6849,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,null,null,0.45000000000000101,0.12566134685507138,{"$error":"#NUM!"},null,0.25,0.67448975019608193,0.67448975019608193,0]
[13,1948,3278,null,0,"frequency()","rel freq.","cum. freq","index","PDF","CDF",null,null,null,null,null,null,null,null,null,null,13,0.19117647058823528,0.87356913461508812,6610,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,null,null,0.40000000000000102,0.25334710313579717,{"$error":"#NUM!"},null,0.1,1.2815515655446006,1.2815515655446006,0]
[14,1949,5281,null,1000,{"$f":"FREQUENCY(C4:C70,E17:E32)","v":3},{"$f":"F17/SUM($F$17:$F$32)","v":4.4776119402985072E-2},{"$f":"G17","v":4.4776119402985072E-2},{"$f":"AVERAGE(E16:E17)","v":500},{"$f":"NORMDIST(I17,$G$9,$G$10,FALSE)*1000","v":{"$error":"#NUM!"}},{"$f":"NORMDIST(I17,$G$9,$G$10,TRUE)","v":{"$error":"#NUM!"}},null,null,null,null,null,null,null,null,null,null,14,0.20588235294117646,0.82079208833238126,5689,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,null,null,0.35000000000000098,0.38532046640756507,{"$error":"#NUM!"},null,0.05,1.6448536269514715,1.6448536269514715,0]
[15,1950,3177,null,2000,9,{"$f":"F18/SUM($F$17:$F$32)","v":0.13432835820895522},{"$f":"H17+G18","v":0.17910447761194029},{"$f":"AVERAGE(E17:E18)","v":1500},{"$f":"NORMDIST(I18,$G$9,$G$10,FALSE)*1000","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},null,null,null,null,null,null,null,null,null,null,15,0.22058823529411764,0.77020808187547585,5665,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,null,null,0.30000000000000099,0.52440051270803822,{"$error":"#NUM!"},null,0.02,2.0537489106318221,2.0537489106318221,0]
[16,1951,3419,null,3000,15,0.22388059701492538,{"$f":"H18+G19","v":0.40298507462686567},{"$f":"AVERAGE(E18:E19)","v":2500},{"$f":"NORMDIST(I19,$G$9,$G$10,FALSE)*1000","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},null,null,null,null,null,null,null,null,null,null,16,0.23529411764705882,0.72152228398234308,5646,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,null,null,0.250000000000001,0.6744897501960786,{"$error":"#NUM!"},null,0.01,2.3263478740408408,2.3263478740408408,0]
[17,1952,746,null,4000,9,0.13432835820895522,0.53731343283582089,3500,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,null,null,null,17,0.25,0.67448975019608193,5632,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,null,null,0.20000000000000101,0.84162123357291074,{"$error":"#NUM!"}]
[18,1953,5632,null,5000,10,0.14925373134328357,0.68656716417910446,4500,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,null,null,null,18,0.26470588235294118,0.62890421763218995,5556,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,null,null,0.15000000000000099,1.0364333894937861,{"$error":"#NUM!"}]
[19,1954,1659,null,6000,8,0.11940298507462686,0.80597014925373134,5500,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,null,null,null,19,0.27941176470588236,0.58458985705947353,5299,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,null,null,0.100000000000001,1.2815515655445955,{"$error":"#NUM!"}]
[20,1955,4539,null,7000,2,2.9850746268656716E-2,0.83582089552238803,6500,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,null,null,null,20,0.29411764705882354,0.54139508512908763,5281,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,null,null,5.0000000000000898E-2,1.6448536269514629,{"$error":"#NUM!"}]
[21,1956,2986,null,8000,3,4.4776119402985072E-2,0.88059701492537312,7500,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,null,null,null,21,0.30882352941176472,0.49918784205087674,5057,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,null,null,0.02,2.0537489106318221,{"$error":"#NUM!"}]
[22,1957,6849,null,9000,2,2.9850746268656716E-2,0.91044776119402981,8500,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,null,null,null,22,0.3235294117647059,0.45785193101249527,4700,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,null,null,0.01,2.3263478740408408,{"$error":"#NUM!"}]
[23,1958,1549,null,10000,2,2.9850746268656716E-2,0.94029850746268651,9500,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,null,null,null,23,0.33823529411764708,0.41728413938902159,4539,{"$error":"#NUM!"},{"$error":"#NUM!"}]
[24,1959,4051,null,11000,2,2.9850746268656716E-2,0.9701492537313432,10500,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,null,null,null,24,0.35294117647058826,0.37739194382855357,4461,{"$error":"#NUM!"},{"$error":"#NUM!"}]
[25,1960,975,null,12000,0,0,0.9701492537313432,11500,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,null,null,null,25,0.36764705882352944,0.33809165680420711,4355,{"$error":"#NUM!"},{"$error":"#NUM!"}]
[26,1961,1260,null,13000,1,1.4925373134328358E-2,0.9850746268656716,12500,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,null,null,null,26,0.38235294117647056,0.29930691046566715,4294,{"$error":"#NUM!"},{"$error":"#NUM!"}]
[27,1962,4355,null,14000,0,0,0.9850746268656716,13500,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,null,null,null,27,0.39705882352941174,0.26096740040145311,4214,{"$error":"#NUM!"},{"$error":"#NUM!"}]
[28,1963,9622,null,15000,1,1.4925373134328358E-2,1,14500,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,null,null,null,28,0.41176470588235292,0.22300783094036683,4182,{"$error":"#NUM!"},{"$error":"#NUM!"}]
[29,1964,5299,null,16000,0,0,1,15500,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,null,null,null,29,0.4264705882352941,0.18536701728959662,4145,{"$error":"#NUM!"},{"$error":"#NUM!"}]
[30,1965,7093,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,0.44117647058823528,0.14798710972583889,4051,{"$error":"#NUM!"},{"$error":"#NUM!"}]
[31,1966,14367,null,null,null,{"$f":"SUM(G17:G32)","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,31,0.45588235294117646,0.11081291229915714,4043,{"$error":"#NUM!"},{"$error":"#NUM!"}]
[32,1967,2626,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,32,0.47058823529411764,7.3791273808272689E-2,3914,{"$error":"#NUM!"},{"$error":"#NUM!"}]
[33,1968,1898,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,33,0.48529411764705882,3.6870532662080152E-2,3552,{"$error":"#NUM!"},{"$error":"#NUM!"}]
[34,1969,8273,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,34,0.5,0,3419,{"$error":"#NUM!"},{"$error":"#NUM!"}]
[35,1970,5646,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,35,0.51470588235294112,-3.6870532662080152E-2,3354,{"$error":"#NUM!"},{"$error":"#NUM!"}]
[36,1971,3552,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,36,0.52941176470588236,-7.3791273808272689E-2,3316,{"$error":"#NUM!"},{"$error":"#NUM!"}]
[37,1972,2041,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,37,0.54411764705882348,-0.11081291229915685,3278,{"$error":"#NUM!"},{"$error":"#NUM!"}]
[38,1973,2700,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,38,0.55882352941176472,-0.14798710972583889,3270,{"$error":"#NUM!"},{"$error":"#NUM!"}]
[39,1974,1545,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,39,0.57352941176470584,-0.18536701728959662,3177,{"$error":"#NUM!"},{"$error":"#NUM!"}]
[40,1975,2064,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,40,0.58823529411764708,-0.22300783094036683,3165,{"$error":"#NUM!"},{"$error":"#NUM!"}]
[41,1976,1851,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,41,0.6029411764705882,-0.26096740040145278,2986,{"$error":"#NUM!"},{"$error":"#NUM!"}]
[42,1977,6610,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,42,0.61764705882352944,-0.29930691046566715,2864,{"$error":"#NUM!"},{"$error":"#NUM!"}]
[43,1978,1211,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,43,0.63235294117647056,-0.33809165680420711,2845,{"$error":"#NUM!"},{"$error":"#NUM!"}]
[44,1979,2712,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,44,0.6470588235294118,-0.37739194382855401,2828,{"$error":"#NUM!"},{"$error":"#NUM!"}]
[45,1980,2828,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,45,0.66176470588235292,-0.41728413938902159,2755,{"$error":"#NUM!"},{"$error":"#NUM!"}]
[46,1981,3914,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,46,0.67647058823529416,-0.45785193101249527,2712,{"$error":"#NUM!"},{"$error":"#NUM!"}]
[47,1982,10694,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,47,0.69117647058823528,-0.49918784205087674,2700,{"$error":"#NUM!"},{"$error":"#NUM!"}]
[48,1983,2864,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,48,0.70588235294117652,-0.54139508512908796,2629,{"$error":"#NUM!"},{"$error":"#NUM!"}]
[49,1984,2021,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,49,0.72058823529411764,-0.58458985705947353,2626,{"$error":"#NUM!"},{"$error":"#NUM!"}]
[50,1985,9478,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50,0.73529411764705888,-0.62890421763218995,2488,{"$error":"#NUM!"},{"$error":"#NUM!"}]
[51,1986,1556,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,51,0.75,-0.67448975019608193,2441,{"$error":"#NUM!"},{"$error":"#NUM!"}]
[52,1987,3354,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,52,0.76470588235294112,-0.72152228398234308,2220,{"$error":"#NUM!"},{"$error":"#NUM!"}]
[53,1988,2488,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,53,0.77941176470588236,-0.77020808187547585,2064,{"$error":"#NUM!"},{"$error":"#NUM!"}]
[54,1989,4700,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,54,0.79411764705882348,-0.82079208833238049,2041,{"$error":"#NUM!"},{"$error":"#NUM!"}]
[55,1990,7905,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,55,0.80882352941176472,-0.87356913461508812,2021,{"$error":"#NUM!"},{"$error":"#NUM!"}]
[56,1991,4145,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,56,0.82352941176470584,-0.92889949164726959,1908,{"$error":"#NUM!"},{"$error":"#NUM!"}]
[57,1992,5665,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,57,0.83823529411764708,-0.98723099199017461,1898,{"$error":"#NUM!"},{"$error":"#NUM!"}]
[58,1993,3165,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,58,0.8529411764705882,-1.0491313979639725,1851,{"$error":"#NUM!"},{"$error":"#NUM!"}]
[59,1994,4043,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,59,0.86764705882352944,-1.1153373577337866,1659,{"$error":"#NUM!"},{"$error":"#NUM!"}]
[60,1995,7391,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,60,0.88235294117647056,-1.186831432755818,1556,{"$error":"#NUM!"},{"$error":"#NUM!"}]
[61,1996,1908,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,61,0.8970588235294118,-1.2649692448841479,1549,{"$error":"#NUM!"},{"$error":"#NUM!"}]
[62,1997,4182,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,62,0.91176470588235292,-1.3517022399306602,1545,{"$error":"#NUM!"},{"$error":"#NUM!"}]
[63,1998,2845,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,63,0.92647058823529416,-1.4499989087404506,1260,{"$error":"#NUM!"},{"$error":"#NUM!"}]
[64,1999,2220,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,64,0.94117647058823528,-1.5647264713617985,1211,{"$error":"#NUM!"},{"$error":"#NUM!"}]
[65,2000,5689,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,65,0.95588235294117652,-1.7047809048894009,992,{"$error":"#NUM!"},{"$error":"#NUM!"}]
[66,2001,4214,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,66,{"$f":"V69/($V$70+1)","v":0.97058823529411764},{"$f":"NORMSINV(1-W69)","v":-1.8895099603334296},{"$f":"LARGE($C$4:$C$70,V69)","v":975},{"$f":"1-_xlfn.NORM.DIST(Y69,$G$9,$G$10,TRUE)","v":{"$error":"#NUM!"}},{"$f":"_xlfn.NORM.INV(1-W69,$G$9,$G$10)","v":{"$error":"#NUM!"}}]
[67,2002,2755,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,67,0.98529411764705888,-2.1779230690821856,746,{"$error":"#NUM!"},{"$error":"#NUM!"}]

{"sheet":"LogNormal","index":5,"n_rows":70,"n_cols":50,"rows_kept":70,"cut":false,"hidden":false,"merged":[]}
["Fitting a probability distribution to data",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Weibull",null,null,{"$f":"CORREL(Z4:Z70,W4:W70)","v":{"$error":"#NUM!"}}]
[null,null,"annual",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"plotting","deviate of","ranked","logNormal Distrib."]
[null,"year","peak flow","log flow",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"position","plot pos","flows","p","quantile",null,null,null,null,null,null,null,null,null,"exc prob","dev ","CDF"]
[1,1936,4294,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"V4/($V$70+1)","v":1.4705882352941176E-2},{"$f":"NORMSINV(1-W4)","v":2.1779230690821856},{"$f":"LARGE($C$4:$C$70,V4)","v":14367},{"$f":"1-_xlfn.NORM.DIST(LOG(Y4),$G$9,$G$10,TRUE)","v":{"$error":"#NUM!"}},{"$f":"10^_xlfn.NORM.INV(1-W4,$G$9,$G$10)","v":{"$error":"#NUM!"}},null,null,null,null,null,null,null,null,null,0.98,{"$f":"NORMSINV(1-AD31)","v":-2.0537489106318221},{"$f":"10^NORMINV(1-AK4,$G$9,$G$10)","v":{"$error":"#NUM!"}}]
[2,1937,992,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,{"$f":"V5/($V$70+1)","v":2.9411764705882353E-2},{"$f":"NORMSINV(1-W5)","v":1.8895099603334296},{"$f":"LARGE($C$4:$C$70,V5)","v":12007},{"$f":"1-_xlfn.NORM.DIST(LOG(Y5),$G$9,$G$10,TRUE)","v":{"$error":"#NUM!"}},{"$f":"10^_xlfn.NORM.INV(1-W5,$G$9,$G$10)","v":{"$error":"#NUM!"}},null,null,null,null,null,null,null,null,null,0.95,-1.6448536269514715,{"$f":"10^NORMINV(1-AK5,$G$9,$G$10)","v":{"$error":"#NUM!"}}]
[3,1938,2629,null,null,"fit a logNormal distribution",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,4.4117647058823532E-2,1.7047809048894009,10694,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,null,null,0.9,-1.2815515655446006,{"$f":"10^NORMINV(1-AK6,$G$9,$G$10)","v":{"$error":"#NUM!"}}]
[4,1939,8157,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,5.8823529411764705E-2,1.5647264713617985,10192,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,null,null,0.85,-1.0364333894937898,{"$error":"#NUM!"}]
[5,1940,3316,null,null,"parameters are:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,7.3529411764705885E-2,1.4499989087404508,9622,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,null,null,0.8,-0.84162123357291474,{"$error":"#NUM!"}]
[6,1941,10192,null,null,"mean of logs =",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,8.8235294117647065E-2,1.3517022399306602,9478,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,null,null,0.75,-0.67448975019608193,{"$error":"#NUM!"}]
[7,1942,3270,null,null,"stdev of logs =",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,0.10294117647058823,1.2649692448841479,8273,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,null,null,0.7,-0.52440051270804078,{"$error":"#NUM!"}]
[8,1943,12007,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,0.11764705882352941,1.186831432755818,8157,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,null,null,0.65,-0.38532046640756784,{"$error":"#NUM!"}]
[9,1944,2441,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,0.13235294117647059,1.1153373577337866,7905,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,null,null,0.6,-0.25334710313579978,{"$error":"#NUM!"}]
[10,1945,5057,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,0.14705882352941177,1.0491313979639725,7391,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,null,null,0.55000000000000104,-0.12566134685507668,{"$error":"#NUM!"},null,null,"Interpolation"]
[11,1946,4461,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,0.16176470588235295,0.98723099199017461,7093,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,null,null,0.500000000000001,-2.5046247822045905E-15,{"$error":"#NUM!"},null,null,null,"D",null,null,"A","B","C","E"]
[12,1947,5556,null,"histogram",null,null,null,"Normal Distribution PDF and CDF",null,null,null,null,null,null,null,null,null,null,null,null,12,0.17647058823529413,0.92889949164726959,6849,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,null,null,0.45000000000000101,0.12566134685507138,{"$error":"#NUM!"},null,null,"Normal Distribution PDF and CDF",null,null,null,"first",null,"second"]
[13,1948,3278,null,0,"frequency()","rel freq.","cum. freq","index","PDF","CDF",null,null,null,null,null,null,null,null,null,null,13,0.19117647058823528,0.87356913461508812,6610,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,null,null,0.40000000000000102,0.25334710313579717,{"$error":"#NUM!"},null,null,"index",null,"lower","upper","lower","upper","lower","upper","interp"]
[14,1949,5281,null,1000,{"$f":"FREQUENCY(C4:C70,E17:E32)","v":3},{"$f":"F17/SUM($F$17:$F$32)","v":4.4776119402985072E-2},{"$f":"G17","v":4.4776119402985072E-2},{"$f":"AVERAGE(E16:E17)","v":500},{"$f":"AX17","v":{"$error":"#NUM!"}},{"$f":"NORMDIST(LOG(I17),$G$9,$G$10,TRUE)","v":{"$error":"#NUM!"}},null,null,null,null,null,null,null,null,null,null,14,0.20588235294117646,0.82079208833238126,5689,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,null,null,0.35000000000000098,0.38532046640756507,{"$error":"#NUM!"},null,null,{"$f":"AVERAGE(E16:E17)","v":500},{"$f":"LOG(AP17)","v":2.6989700043360187},{"$f":"MATCH(AQ17,$I$36:$I$53,1)","v":1},{"$f":"IF(AR17<16,AR17+1,AR17)","v":2},{"$f":"IF(AR17<>AS17,INDEX($J$36:$J$53,AR17),INDEX($J$36:$J$53,AR17-1))","v":{"$error":"#NUM!"}},{"$f":"INDEX($J$36:$J$53,AS17)","v":{"$error":"#NUM!"}},{"$f":"IF(AR17<>AS17,INDEX($I$36:$I$53,AR17),INDEX($I$36:$I$53,AR17-1))","v":2.6500000000000004},{"$f":"INDEX($I$36:$I$53,AS17)","v":2.75},{"$f":"AT17+(AU17-AT17)*(AQ17-AV17)/(AW17-AV17)","v":{"$error":"#NUM!"}}]
[15,1950,3177,null,2000,9,{"$f":"F18/SUM($F$17:$F$32)","v":0.13432835820895522},{"$f":"H17+G18","v":0.17910447761194029},{"$f":"AVERAGE(E17:E18)","v":1500},{"$f":"AX18","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},null,null,null,null,null,null,null,null,null,null,15,0.22058823529411764,0.77020808187547585,5665,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,null,null,0.30000000000000099,0.52440051270803822,{"$error":"#NUM!"},null,null,{"$f":"AVERAGE(E17:E18)","v":1500},{"$f":"LOG(AP18)","v":3.1760912590556813},6,7,{"$error":"#NUM!"},{"$error":"#NUM!"},3.1500000000000004,3.25,{"$f":"AT18+(AU18-AT18)*(AQ18-AV18)/(AW18-AV18)","v":{"$error":"#NUM!"}}]
[16,1951,3419,null,3000,15,0.22388059701492538,{"$f":"H18+G19","v":0.40298507462686567},{"$f":"AVERAGE(E18:E19)","v":2500},{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,null,null,null,16,0.23529411764705882,0.72152228398234308,5646,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,null,null,0.250000000000001,0.6744897501960786,{"$error":"#NUM!"},null,null,2500,3.3979400086720375,8,9,{"$error":"#NUM!"},{"$error":"#NUM!"},3.3499999999999996,3.45,{"$error":"#NUM!"}]
[17,1952,746,null,4000,9,0.13432835820895522,0.53731343283582089,3500,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,null,null,null,17,0.25,0.67448975019608193,5632,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,null,null,0.20000000000000101,0.84162123357291074,{"$error":"#NUM!"},null,null,3500,3.5440680443502757,9,10,{"$error":"#NUM!"},{"$error":"#NUM!"},3.45,3.55,{"$error":"#NUM!"}]
[18,1953,5632,null,5000,10,0.14925373134328357,0.68656716417910446,4500,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,null,null,null,18,0.26470588235294118,0.62890421763218995,5556,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,null,null,0.15000000000000099,1.0364333894937861,{"$error":"#NUM!"},null,null,4500,3.6532125137753435,11,12,{"$error":"#NUM!"},{"$error":"#NUM!"},3.6500000000000004,3.75,{"$error":"#NUM!"}]
[19,1954,1659,null,6000,8,0.11940298507462686,0.80597014925373134,5500,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,null,null,null,19,0.27941176470588236,0.58458985705947353,5299,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,null,null,0.100000000000001,1.2815515655445955,{"$error":"#NUM!"},null,null,5500,3.7403626894942437,11,12,{"$error":"#NUM!"},{"$error":"#NUM!"},3.6500000000000004,3.75,{"$error":"#NUM!"}]
[20,1955,4539,null,7000,2,2.9850746268656716E-2,0.83582089552238803,6500,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,null,null,null,20,0.29411764705882354,0.54139508512908763,5281,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,null,null,5.0000000000000898E-2,1.6448536269514629,{"$error":"#NUM!"},null,null,6500,3.8129133566428557,12,13,{"$error":"#NUM!"},{"$error":"#NUM!"},3.75,3.8499999999999996,{"$error":"#NUM!"}]
[21,1956,2986,null,8000,3,4.4776119402985072E-2,0.88059701492537312,7500,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,null,null,null,21,0.30882352941176472,0.49918784205087674,5057,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,null,null,0.02,2.0537489106318221,{"$error":"#NUM!"},null,null,7500,3.8750612633917001,13,14,{"$error":"#NUM!"},{"$error":"#NUM!"},3.8499999999999996,3.95,{"$error":"#NUM!"}]
[22,1957,6849,null,9000,2,2.9850746268656716E-2,0.91044776119402981,8500,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,null,null,null,22,0.3235294117647059,0.45785193101249527,4700,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,null,null,0.01,2.3263478740408408,{"$error":"#NUM!"},null,null,8500,3.9294189257142929,13,14,{"$error":"#NUM!"},{"$error":"#NUM!"},3.8499999999999996,3.95,{"$error":"#NUM!"}]
[23,1958,1549,null,10000,2,2.9850746268656716E-2,0.94029850746268651,9500,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,null,null,null,23,0.33823529411764708,0.41728413938902159,4539,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,9500,3.9777236052888476,14,15,{"$error":"#NUM!"},{"$error":"#NUM!"},3.95,4.05,{"$error":"#NUM!"}]
[24,1959,4051,null,11000,2,2.9850746268656716E-2,0.9701492537313432,10500,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,null,null,null,24,0.35294117647058826,0.37739194382855357,4461,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,10500,4.0211892990699383,14,15,{"$error":"#NUM!"},{"$error":"#NUM!"},3.95,4.05,{"$error":"#NUM!"}]
[25,1960,975,null,12000,0,0,0.9701492537313432,11500,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,null,null,null,25,0.36764705882352944,0.33809165680420711,4355,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,11500,4.0606978403536118,15,16,{"$error":"#NUM!"},{"$error":"#NUM!"},4.05,4.1500000000000004,{"$error":"#NUM!"}]
[26,1961,1260,null,13000,1,1.4925373134328358E-2,0.9850746268656716,12500,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,null,null,null,26,0.38235294117647056,0.29930691046566715,4294,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,12500,4.0969100130080562,15,16,{"$error":"#NUM!"},{"$error":"#NUM!"},4.05,4.1500000000000004,{"$error":"#NUM!"}]
[27,1962,4355,null,14000,0,0,0.9850746268656716,13500,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,null,null,null,27,0.39705882352941174,0.26096740040145311,4214,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,13500,4.1303337684950066,15,16,{"$error":"#NUM!"},{"$error":"#NUM!"},4.05,4.1500000000000004,{"$error":"#NUM!"}]
[28,1963,9622,null,15000,1,1.4925373134328358E-2,1,14500,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,null,null,null,28,0.41176470588235292,0.22300783094036683,4182,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,0.98,null,null,null,null,null,null,null,null,null,null,null,14500,4.1613680022349753,16,{"$f":"IF(AR31<16,AR31+1,AR31)","v":16},{"$error":"#NUM!"},{"$error":"#NUM!"},4.05,4.1500000000000004,{"$error":"#NUM!"}]
[29,1964,5299,null,16000,0,0,1,15500,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,null,null,null,null,null,null,null,null,29,0.4264705882352941,0.18536701728959662,4145,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,0.95,null,null,null,null,null,null,null,null,null,null,null,15500,4.1903316981702918,16,{"$f":"IF(AR32<16,AR32+1,AR32)","v":16},{"$error":"#NUM!"},{"$error":"#NUM!"},4.05,4.1500000000000004,{"$error":"#NUM!"}]
[30,1965,7093,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,0.44117647058823528,0.14798710972583889,4051,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,0.9]
[31,1966,14367,null,null,"working in log space…",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,31,0.45588235294117646,0.11081291229915714,4043,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,0.85]
[32,1967,2626,null,2.6,null,"rel freq","cum. freq","index","pdf","cdf",null,null,null,null,null,null,null,null,null,null,32,0.47058823529411764,7.3791273808272689E-2,3914,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,0.8]
[33,1968,1898,null,2.7,{"$f":"FREQUENCY(D4:D70,E36:E53)","v":0},{"$f":"F36/SUM($F$36:$F$53)","v":{"$error":"#DIV/0!"}},{"$f":"G36","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(E35:E36)","v":2.6500000000000004},{"$f":"NORMDIST(I36,$G$9,$G$10,FALSE)*0.1","v":{"$error":"#NUM!"}},{"$f":"NORMDIST(I36,$G$9,$G$10,TRUE)","v":{"$error":"#NUM!"}},{"$f":"10^I36","v":446.6835921509637},null,null,null,null,null,null,null,null,null,33,0.48529411764705882,3.6870532662080152E-2,3552,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,0.75]
[34,1969,8273,null,2.8,0,{"$error":"#DIV/0!"},{"$f":"H36+G37","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(E36:E37)","v":2.75},{"$f":"NORMDIST(I37,$G$9,$G$10,FALSE)*0.1","v":{"$error":"#NUM!"}},{"$f":"NORMDIST(I37,$G$9,$G$10,TRUE)","v":{"$error":"#NUM!"}},{"$f":"10^I37","v":562.34132519034927},null,null,null,null,null,null,null,null,null,34,0.5,0,3419,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,0.7]
[35,1970,5646,null,2.9,0,{"$error":"#DIV/0!"},{"$f":"H37+G38","v":{"$error":"#DIV/0!"}},2.8499999999999996,{"$error":"#NUM!"},{"$error":"#NUM!"},707.94578438413748,null,null,null,null,null,null,null,null,null,35,0.51470588235294112,-3.6870532662080152E-2,3354,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,0.65,null,null,null,null,null,null,null,null,null,0,16000]
[36,1971,3552,null,3,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},2.95,{"$error":"#NUM!"},{"$error":"#NUM!"},891.25093813374656,null,null,null,null,null,null,null,null,null,36,0.52941176470588236,-7.3791273808272689E-2,3316,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,0.6,null,null,null,null,null,null,null,null,0.95,{"$f":"NORMSINV(1-AM39)","v":-1.6448536269514715},{"$f":"AN39","v":-1.6448536269514715},0]
[37,1972,2041,null,3.1,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},3.05,{"$error":"#NUM!"},{"$error":"#NUM!"},1122.0184543019636,null,null,null,null,null,null,null,null,null,37,0.54411764705882348,-0.11081291229915685,3278,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,0.55000000000000104,null,null,null,null,null,null,null,null,0.9,{"$f":"NORMSINV(1-AM40)","v":-1.2815515655446006},{"$f":"AN40","v":-1.2815515655446006},0]
[38,1973,2700,null,3.2,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},3.1500000000000004,{"$error":"#NUM!"},{"$error":"#NUM!"},1412.537544622757,null,null,null,null,null,null,null,null,null,38,0.55882352941176472,-0.14798710972583889,3270,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,0.500000000000001,null,null,null,null,null,null,null,null,0.75,-0.67448975019608193,-0.67448975019608193,0]
[39,1974,1545,null,3.3,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},3.25,{"$error":"#NUM!"},{"$error":"#NUM!"},1778.2794100389244,null,null,null,null,null,null,null,null,null,39,0.57352941176470584,-0.18536701728959662,3177,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,0.45000000000000101,null,null,null,null,null,null,null,null,0.5,0,0,0]
[40,1975,2064,null,3.4,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},3.3499999999999996,{"$error":"#NUM!"},{"$error":"#NUM!"},2238.7211385683395,null,null,null,null,null,null,null,null,null,40,0.58823529411764708,-0.22300783094036683,3165,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,0.40000000000000102,null,null,null,null,null,null,null,null,0.25,0.67448975019608193,0.67448975019608193,0]
[41,1976,1851,null,3.5,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},3.45,{"$error":"#NUM!"},{"$error":"#NUM!"},2818.3829312644561,null,null,null,null,null,null,null,null,null,41,0.6029411764705882,-0.26096740040145278,2986,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,0.35000000000000098,null,null,null,null,null,null,null,null,0.1,1.2815515655446006,1.2815515655446006,0]
[42,1977,6610,null,3.6,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},3.55,{"$error":"#NUM!"},{"$error":"#NUM!"},3548.1338923357539,null,null,null,null,null,null,null,null,null,42,0.61764705882352944,-0.29930691046566715,2864,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,0.30000000000000099,null,null,null,null,null,null,null,null,0.05,1.6448536269514715,1.6448536269514715,0]
[43,1978,1211,null,3.7,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},3.6500000000000004,{"$error":"#NUM!"},{"$error":"#NUM!"},4466.8359215096425,null,null,null,null,null,null,null,null,null,43,0.63235294117647056,-0.33809165680420711,2845,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,0.250000000000001,null,null,null,null,null,null,null,null,0.02,2.0537489106318221,2.0537489106318221,0]
[44,1979,2712,null,3.8,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},3.75,{"$error":"#NUM!"},{"$error":"#NUM!"},5623.4132519034993,null,null,null,null,null,null,null,null,null,44,0.6470588235294118,-0.37739194382855401,2828,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,0.20000000000000101,null,null,null,null,null,null,null,null,0.01,2.3263478740408408,2.3263478740408408,0]
[45,1980,2828,null,3.9,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},3.8499999999999996,{"$error":"#NUM!"},{"$error":"#NUM!"},7079.4578438413828,null,null,null,null,null,null,null,null,null,45,0.66176470588235292,-0.41728413938902159,2755,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,0.15000000000000099]
[46,1981,3914,null,4,0,{"$f":"F49/SUM($F$36:$F$53)","v":{"$error":"#DIV/0!"}},{"$f":"H48+G49","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(E48:E49)","v":3.95},{"$f":"NORMDIST(I49,$G$9,$G$10,FALSE)*0.1","v":{"$error":"#NUM!"}},{"$f":"NORMDIST(I49,$G$9,$G$10,TRUE)","v":{"$error":"#NUM!"}},{"$f":"10^I49","v":8912.5093813374679},null,null,null,null,null,null,null,null,null,46,0.67647058823529416,-0.45785193101249527,2712,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,0.100000000000001]
[47,1982,10694,null,4.0999999999999996,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},4.05,{"$error":"#NUM!"},{"$error":"#NUM!"},11220.184543019639,null,null,null,null,null,null,null,null,null,47,0.69117647058823528,-0.49918784205087674,2700,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,5.0000000000000898E-2]
[48,1983,2864,null,4.2,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},4.1500000000000004,{"$error":"#NUM!"},{"$error":"#NUM!"},14125.375446227561,null,null,null,null,null,null,null,null,null,48,0.70588235294117652,-0.54139508512908796,2629,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,0.02]
[49,1984,2021,null,4.3,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},4.25,{"$error":"#NUM!"},{"$error":"#NUM!"},17782.794100389234,null,null,null,null,null,null,null,null,null,49,0.72058823529411764,-0.58458985705947353,2626,{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,0.01]
[50,1985,9478,null,4.4000000000000004,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},4.3499999999999996,{"$error":"#NUM!"},{"$error":"#NUM!"},22387.211385683382,null,null,null,null,null,null,null,null,null,50,0.73529411764705888,-0.62890421763218995,2488,{"$error":"#NUM!"},{"$error":"#NUM!"}]
[51,1986,1556,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,51,0.75,-0.67448975019608193,2441,{"$error":"#NUM!"},{"$error":"#NUM!"}]
[52,1987,3354,null,null,{"$f":"SUM(F36:F53)","v":0},{"$f":"SUM(G36:G53)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,52,0.76470588235294112,-0.72152228398234308,2220,{"$error":"#NUM!"},{"$error":"#NUM!"}]
[53,1988,2488,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,53,0.77941176470588236,-0.77020808187547585,2064,{"$error":"#NUM!"},{"$error":"#NUM!"}]
[54,1989,4700,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,54,0.79411764705882348,-0.82079208833238049,2041,{"$error":"#NUM!"},{"$error":"#NUM!"}]
[55,1990,7905,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,55,0.80882352941176472,-0.87356913461508812,2021,{"$error":"#NUM!"},{"$error":"#NUM!"}]
[56,1991,4145,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,56,0.82352941176470584,-0.92889949164726959,1908,{"$error":"#NUM!"},{"$error":"#NUM!"}]
[57,1992,5665,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,57,0.83823529411764708,-0.98723099199017461,1898,{"$error":"#NUM!"},{"$error":"#NUM!"}]
[58,1993,3165,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,58,0.8529411764705882,-1.0491313979639725,1851,{"$error":"#NUM!"},{"$error":"#NUM!"}]
[59,1994,4043,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,59,0.86764705882352944,-1.1153373577337866,1659,{"$error":"#NUM!"},{"$error":"#NUM!"}]
[60,1995,7391,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,60,0.88235294117647056,-1.186831432755818,1556,{"$error":"#NUM!"},{"$error":"#NUM!"}]
[61,1996,1908,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,61,0.8970588235294118,-1.2649692448841479,1549,{"$error":"#NUM!"},{"$error":"#NUM!"}]
[62,1997,4182,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,62,0.91176470588235292,-1.3517022399306602,1545,{"$error":"#NUM!"},{"$error":"#NUM!"}]
[63,1998,2845,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,63,0.92647058823529416,-1.4499989087404506,1260,{"$error":"#NUM!"},{"$error":"#NUM!"}]
[64,1999,2220,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,64,0.94117647058823528,-1.5647264713617985,1211,{"$error":"#NUM!"},{"$error":"#NUM!"}]
[65,2000,5689,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,65,0.95588235294117652,-1.7047809048894009,992,{"$error":"#NUM!"},{"$error":"#NUM!"}]
[66,2001,4214,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,66,{"$f":"V69/($V$70+1)","v":0.97058823529411764},{"$f":"NORMSINV(1-W69)","v":-1.8895099603334296},{"$f":"LARGE($C$4:$C$70,V69)","v":975},{"$f":"1-_xlfn.NORM.DIST(LOG(Y69),$G$9,$G$10,TRUE)","v":{"$error":"#NUM!"}},{"$f":"10^_xlfn.NORM.INV(1-W69,$G$9,$G$10)","v":{"$error":"#NUM!"}}]
[67,2002,2755,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,67,0.98529411764705888,-2.1779230690821856,746,{"$error":"#NUM!"},{"$error":"#NUM!"}]