{"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":818.99882293050587}]
[null,"annual peak flow",null,null,null,null,null,null,null,null,null,0.3,null,"max",{"$f":"MAX(L5:L71)","v":20265.343551667796}]
[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":0.4279816133788702},{"$f":"10^NORMINV(K5,$L$2,$L$3)","v":3130.0080097149716},null,null,null,null,{"$f":"LARGE($L$5:$L$71,J5)","v":20265.343551667796},{"$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.57380272522418807},{"$f":"10^NORMINV(K6,$L$2,$L$3)","v":4034.7739562280349},null,null,null,null,{"$f":"LARGE($L$5:$L$71,J6)","v":17406.228362391048},{"$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.11513594691698903,1549.1817442938536,null,1000,{"$f":"FREQUENCY(L5:L71,N7:N22)","v":2},null,14446.896849206778,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,0.39107714186431375,2931.2049208734911,null,2000,15,null,8833.5942429627794,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.56594818302327998,3979.4250075834111,null,3000,15,null,7690.8545184633831,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.51479924546527001,3640.2517206802395,null,4000,14,null,7498.7136722144542,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,9.230727777550507E-2,1419.0444397444419,null,5000,8,null,7155.2495053354869,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.53186805559101347,3749.6432866132582,null,6000,1,null,6854.6651159481034,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,0.78579866351999861,6131.6646283639529,null,7000,5,null,6776.7001254234056,0.13235294117647059,1.1153373577337866,7905.4442280584353,9620.3611537459492,7667.2681987750866]
[11,4460.7298806777399,1923.3807026119443,1822.6141324334872,8000,3,null,null,null,10,0.20252350004408259,1996.2162129435308,null,8000,3,null,6700.9837166223379,0.14705882352941177,1.0491313979639725,7391.3420371201801,9500.0831298404191,7638.365182739275]
[12,5555.8378056056426,6370.6292480071997,2954.4137489134559,9000,2,null,null,null,11,0.99417402173562219,20265.343551667796,null,9000,1,null,6345.3211783206543,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.50308886620455007,3567.161852744227,null,10000,0,null,6131.6646283639529,0.17647058823529413,0.92889949164726959,6848.8614042298022,8598.5908455202753,6692.7841826014655]
[14,5281.3331920688088,2738.4803492734,6986.2417756017521,11000,2,null,null,null,13,0.39220161960081068,2937.1381463838911,null,11000,0,null,5514.4922398843291,0.19117647058823528,0.87356913461508812,6609.6035424165802,8277.343605606955,6547.8419220992537]
[15,3176.9040278867401,4523.6581147154684,3474.4868578859805,12000,0,null,null,null,14,0.67953852516006685,4896.9156683929295,null,12000,0,null,4896.9156683929295,0.20588235294117646,0.82079208833238126,5689.2560526270972,8168.4403580618218,6370.9397320605067]
[16,3418.731784204665,3464.7019424160303,4240.804223589108,13000,1,null,null,null,15,0.409779222575271,3030.8617003073923,null,13000,0,null,4840.8870793364176,0.22058823529411764,0.77020808187547585,5665.0501226769047,7553.590816216989,6138.2104537988307]
[17,746.22123325795906,8168.4403580618218,4500.7076952761172,14000,0,null,null,null,16,0.34771053009523223,2707.368110957148,null,14000,0,null,4781.8548976860211,0.23529411764705882,0.72152228398234308,5646.4638921203368,7338.8145739678166,6078.5807745732764]
[18,5631.9570395932869,4783.3757203101886,4776.2096422598242,15000,1,null,null,null,17,0.20794913184432007,2022.7053806951321,null,15000,1,null,4507.6221265848271,0.25,0.67448975019608193,5631.9570395932869,7285.2899080289635,5953.3807614683292]
[19,1658.9456232732036,4514.2673430529212,3883.2527758193432,16000,0,null,null,null,18,1.6902539444468845E-2,818.99882293050587,null,16000,0,null,4383.3763331203827,0.26470588235294118,0.62890421763218995,5555.8378056056426,7264.2311065265058,5857.8845107221614]
[20,4538.9149266823442,3568.0794176304967,3403.4293336906617,null,null,null,null,null,19,0.97895260948513951,14446.896849206778,null,null,null,null,4253.3593097405901,0.27941176470588236,0.58458985705947353,5298.8178018080271,7210.7329842362687,5646.2478790085324]
[21,2985.7793024106077,5318.3794384899611,1085.6198739575873,null,null,null,null,null,20,0.9893422485424197,17406.228362391048,null,null,null,null,4148.2050486263315,0.29411764705882354,0.54139508512908763,5281.3331920688088,6933.1154481601016,5332.5871359192615]
[22,6848.8614042298022,2807.4887892202714,16455.375975315554,null,null,null,null,null,21,0.58947734431795074,4148.2050486263315,null,null,null,null,4034.7739562280349,0.30882352941176472,0.49918784205087674,5056.627677681653,6749.9011245613219,5100.5101643043499]
[23,1549.1692618242062,5873.771105678632,4430.2451867054615,null,null,null,null,null,22,0.84504620130909092,7155.2495053354869,null,null,null,null,3979.4250075834111,0.3235294117647059,0.45785193101249527,4699.7215570781291,6370.6292480071997,5038.4889264354679]
[24,4051.2913379294378,8797.5745380235803,8464.6468122878068,null,null,null,null,null,23,0.15386718678109623,1753.8956064824158,null,null,null,null,3959.6001367423705,0.33823529411764708,0.41728413938902159,4538.9149266823442,5873.771105678632,4974.8081798716985]
[25,975.29168055548337,4540.6616607395727,6138.2104537988307,null,null,null,null,null,24,0.3704510175050767,2823.5942194155987,null,null,null,null,3918.4873136041183,0.35294117647058826,0.37739194382855357,4460.7298806777399,5843.4120150374238,4942.7401221843411]
[26,1260.1361720189918,2603.3696952488403,9510.3338759496619,null,null,null,null,null,25,0.41420072261746554,3054.7405665737647,null,null,null,null,3803.4673450951541,0.36764705882352944,0.33809165680420711,4355.09301186628,5647.0505989329122,4867.4203704868878]
[27,4355.09301186628,7264.2311065265058,3478.994301936511,null,null,null,null,null,26,0.39448826613165022,2949.2258825386334,null,null,null,null,3749.6432866132582,0.38235294117647056,0.29930691046566715,4293.7156878958767,5642.7206615873156,4855.574026427731]
[28,9621.528431097131,3439.5513301112514,2055.4048564544532,null,null,null,null,null,27,0.10808968504147132,1509.9917134731013,null,null,null,null,3720.2162586307513,0.39705882352941174,0.26096740040145311,4214.1058346796763,5318.3794384899611,4826.9761376119604]
[29,5298.8178018080271,11002.306313688072,6692.7841826014655,null,null,null,null,null,28,0.54006559405977961,3803.4673450951541,null,null,null,null,3640.2517206802395,0.41176470588235292,0.22300783094036683,4182.1133002962742,5301.8895513956722,4776.2096422598242]
[30,7093.3718608253212,2190.5253083135058,2968.3904955940343,null,null,null,null,null,29,0.42062752460593111,3089.6798871802521,null,null,null,null,3567.161852744227,0.4264705882352941,0.18536701728959662,4144.8911960115574,5031.4478656605925,4710.8204215415171]
[31,14367.2579913719,3018.4535250685822,2471.2771514086448,null,null,null,null,null,30,0.52733031770541794,3720.2162586307513,null,null,null,null,3299.5593948722239,0.44117647058823528,0.14798710972583889,4051.2913379294378,4938.7259003443578,4500.7076952761172]
[32,2625.5386754500691,13540.002179953059,4855.574026427731,null,null,null,null,null,31,0.14675638041304795,1717.3783145575399,null,null,null,null,3256.4560068492556,0.45588235294117646,0.11081291229915714,4042.9287163795802,4783.3757203101886,4430.2451867054615]
[33,1898.4619469820484,2108.6397918245966,5038.4889264354679,null,null,null,null,null,32,0.45812964938713174,3299.5593948722239,null,null,null,null,3130.0080097149716,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.60350897378495005,4253.3593097405901,null,null,null,null,3089.6798871802521,0.48529411764705882,3.6870532662080152E-2,3551.5944190891601,4635.3303666510747,4165.729132498388]
[35,5646.4638921203368,1297.5117482410831,2524.7303803481682,null,null,null,null,null,34,8.8505831078111941E-2,1396.3553681696592,null,null,null,null,3054.7405665737647,0.5,0,3418.731784204665,4624.6633512149301,3883.2527758193432]
[36,3551.5944190891601,7210.7329842362687,3085.6735742813694,null,null,null,null,null,35,0.13256505701380905,1643.2200831763357,null,null,null,null,3030.8617003073923,0.51470588235294112,-3.6870532662080152E-2,3354.0845179039752,4566.7610541338172,3826.9128618637847]
[37,2041.4540880568886,6749.9011245613219,6370.9397320605067,null,null,null,null,null,36,6.7780423370019993E-2,1265.4403359598346,null,null,null,null,2975.8413859139714,0.52941176470588236,-7.3791273808272689E-2,3315.7693159464166,4540.6616607395727,3478.994301936511]
[38,2700.0962081763473,7553.590816216989,5332.5871359192615,null,null,null,null,null,37,5.036071389428276E-2,1141.8002894245537,null,null,null,null,2949.2258825386334,0.54411764705882348,-0.11081291229915685,3277.9951028663645,4523.6581147154684,3474.4868578859805]
[39,1545.0308266878101,4938.7259003443578,18769.969790522446,null,null,null,null,null,38,0.82977778188531881,6854.6651159481034,null,null,null,null,2937.1381463838911,0.55882352941176472,-0.14798710972583889,3269.7333207136899,4514.2673430529212,3449.1232258810301]
[40,2064.1613979038243,3094.5229218487461,1332.2082569623317,null,null,null,null,null,39,0.15902125705204218,1780.1370329588674,null,null,null,null,2931.2049208734911,0.57352941176470584,-0.18536701728959662,3176.9040278867401,4135.1171797943452,3444.3484844526488]
[41,1850.7976898340346,6933.1154481601016,2877.988542674912,null,null,null,null,null,40,2.7928217774594422E-2,947.00828736433311,null,null,null,null,2847.2385586168739,0.58823529411764708,-0.22300783094036683,3164.8283161868385,4095.500359484673,3403.4293336906617]
[42,6609.6035424165802,5031.4478656605925,1638.5015989747797,null,null,null,null,null,41,7.6700665974540838E-2,1323.4699076191525,null,null,null,null,2823.5942194155987,0.6029411764705882,-0.26096740040145278,2985.7793024106077,3763.7989796750294,3320.6316617228376]
[43,1210.892176254489,12558.604066696216,3444.3484844526488,null,null,null,null,null,42,0.56310165425007941,3959.6001367423705,null,null,null,null,2804.0447624334197,0.61764705882352944,-0.29930691046566715,2864.2078938636487,3568.0794176304967,3274.2625073047243]
[44,2712.0635052049061,3394.0143911695868,4974.8081798716985,null,null,null,null,null,43,0.45058534337299372,3256.4560068492556,null,null,null,null,2761.8067288393117,0.63235294117647056,-0.33809165680420711,2844.9709784935867,3464.7019424160303,3272.9871842293787]
[45,2828.0210253905102,4135.1171797943452,1494.1485246305895,null,null,null,null,null,44,0.8686250755789211,7690.8545184633831,null,null,null,null,2707.368110957148,0.6470588235294118,-0.37739194382855401,2828.0210253905102,3439.5513301112514,3096.4125737270379]
[46,3913.6939460692215,3163.5079609658146,3320.6316617228376,null,null,null,null,null,45,0.67355458546957625,4840.8870793364176,null,null,null,null,2683.7293532593658,0.66176470588235292,-0.41728413938902159,2754.6750659989279,3394.0143911695868,3085.6735742813694]
[47,10694.416487324303,1580.6747265477834,3043.2547997117595,null,null,null,null,null,46,0.35841858819142647,2761.8067288393117,null,null,null,null,2594.7286879501657,0.67647058823529416,-0.45785193101249527,2712.0635052049061,3163.5079609658146,3053.7566623113203]
[48,2864.2078938636487,1147.4177641659944,2809.1406986660454,null,null,null,null,null,47,0.37501980128647205,2847.2385586168739,null,null,null,null,2528.2525789573406,0.69117647058823528,-0.49918784205087674,2700.0962081763473,3094.5229218487461,3043.2547997117595]
[49,2020.5747228905432,2953.6371828975984,8051.0563670190422,null,null,null,null,null,48,0.90665895106490291,8833.5942429627794,null,null,null,null,2335.8498948243505,0.70588235294117652,-0.54139508512908796,2629.0903060841306,3088.9109354264419,3020.7905587163968]
[50,9478.3455132998515,861.62785622098386,1676.3343719985828,null,null,null,null,null,49,5.5508090030982449E-2,1180.068770833348,null,null,null,null,2150.6180959040316,0.72058823529411764,-0.58458985705947353,2625.5386754500691,3018.4535250685822,2968.3904955940343]
[51,1555.8828674317101,3763.7989796750294,3096.4125737270379,null,null,null,null,null,50,0.39950287158591313,2975.8413859139714,null,null,null,null,2022.7053806951321,0.73529411764705888,-0.62890421763218995,2488.1904656657616,2981.4855729256083,2954.4137489134559]
[52,3354.0845179039752,7285.2899080289635,4867.4203704868878,null,null,null,null,null,51,0.8213342764442203,6700.9837166223379,null,null,null,null,1997.5325406110026,0.75,-0.67448975019608193,2441.4300121720953,2966.2797557365438,2877.988542674912]
[53,2488.1904656657616,5843.4120150374238,7667.2681987750866,null,null,null,null,null,52,0.63551337963672239,4507.6221265848271,null,null,null,null,1996.2162129435308,0.76470588235294112,-0.72152228398234308,2219.9768259333259,2953.6371828975984,2809.1406986660454]
[54,4699.7215570781291,9759.0579054737009,7638.365182739275,null,null,null,null,null,53,0.34303125370249221,2683.7293532593658,null,null,null,null,1823.2226019142565,0.77941176470588236,-0.77020808187547585,2064.1613979038243,2807.4887892202714,2804.0060335009512]
[55,7905.4442280584353,11181.531669546139,2118.5767933451357,null,null,null,null,null,54,0.73837763930545686,5514.4922398843291,null,null,null,null,1780.1370329588674,0.79411764705882348,-0.82079208833238049,2041.4540880568886,2738.4803492734,2524.7303803481682]
[56,4144.8911960115574,2563.1761489706714,5953.3807614683292,null,null,null,null,null,55,0.36665837272526236,2804.0447624334197,null,null,null,null,1753.8956064824158,0.80882352941176472,-0.87356913461508812,2020.5747228905432,2710.1168507853868,2471.2771514086448]
[57,5665.0501226769047,2025.7349123845295,1556.2110662203465,null,null,null,null,null,56,0.8255506422036033,6776.7001254234056,null,null,null,null,1717.3783145575399,0.82352941176470584,-0.92889949164726959,1908.4429658954182,2603.3696952488403,2314.2788415218479]
[58,3164.8283161868385,7338.8145739678166,3053.7566623113203,null,null,null,null,null,57,0.31185523428738005,2528.2525789573406,null,null,null,null,1643.2200831763357,0.83823529411764708,-0.98723099199017461,1898.4619469820484,2563.1761489706714,2168.4233972390721]
[59,4042.9287163795802,11561.389331057913,6078.5807745732764,null,null,null,null,null,58,0.16755613476219477,1823.2226019142565,null,null,null,null,1549.1817442938536,0.8529411764705882,-1.0491313979639725,1850.7976898340346,2190.5253083135058,2118.5767933451357]
[60,7391.3420371201801,4710.1122752310885,16161.017787747858,null,null,null,null,null,59,0.27252851783038934,2335.8498948243505,null,null,null,null,1509.9917134731013,0.86764705882352944,-1.1153373577337866,1658.9456232732036,2108.6397918245966,2055.4048564544532]
[61,1908.4429658954182,2966.2797557365438,3272.9871842293787,null,null,null,null,null,60,0.3252647139967958,2594.7286879501657,null,null,null,null,1419.0444397444419,0.88235294117647056,-1.186831432755818,1555.8828674317101,2025.7349123845295,1822.6141324334872]
[62,4182.1133002962742,1435.9797520260897,2314.2788415218479,null,null,null,null,null,61,0.20279278525750766,1997.5325406110026,null,null,null,null,1396.3553681696592,0.8970588235294118,-1.2649692448841479,1549.1692618242062,1940.0088184972083,1676.3343719985828]
[63,2844.9709784935867,8598.5908455202753,2168.4233972390721,null,null,null,null,null,62,0.79996942620025546,6345.3211783206543,null,null,null,null,1323.4699076191525,0.91176470588235292,-1.3517022399306602,1545.0308266878101,1923.3807026119443,1638.5015989747797]
[64,2219.9768259333259,4624.6633512149301,6547.8419220992537,null,null,null,null,null,63,0.55714242930905489,3918.4873136041183,null,null,null,null,1265.4403359598346,0.92647058823529416,-1.4499989087404506,1260.1361720189918,1580.6747265477834,1556.2110662203465]
[65,5689.2560526270972,5647.0505989329122,3274.2625073047243,null,null,null,null,null,64,0.62020879138280316,4383.3763331203827,null,null,null,null,1180.068770833348,0.94117647058823528,-1.5647264713617985,1210.892176254489,1435.9797520260897,1494.1485246305895]
[66,4214.1058346796763,5301.8895513956722,8165.085598451743,null,null,null,null,null,65,0.23429073820886048,2150.6180959040316,null,null,null,null,1141.8002894245537,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.66712492484134023},{"$f":"10^NORMINV(K70,$L$2,$L$3)","v":4781.8548976860211},null,null,null,null,{"$f":"LARGE($L$5:$L$71,J70)","v":947.00828736433311},{"$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.86065996937287426,7498.7136722144542,null,null,null,null,818.99882293050587,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/($T$70+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/($T$70+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,{"$f":"FREQUENCY(C4:C70,G21:G36)","v":3},{"$f":"H21/$H$38","v":4.4776119402985072E-2},{"$f":"I21+J20","v":4.4776119402985072E-2},{"$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,9,{"$f":"H22/$H$38","v":0.13432835820895522},{"$f":"I22+J21","v":0.17910447761194029},1500,null,null,null,null,null,null,null,null,19,0.27941176470588236,0.58458985705947353,5299]
[20,1955,4539,null,null,null,3000,15,0.22388059701492538,0.40298507462686567,2500,null,null,null,null,null,null,null,null,20,0.29411764705882354,0.54139508512908763,5281]
[21,1956,2986,null,null,null,4000,9,0.13432835820895522,0.53731343283582089,3500,null,null,null,null,null,null,null,null,21,0.30882352941176472,0.49918784205087674,5057]
[22,1957,6849,null,null,null,5000,10,0.14925373134328357,0.68656716417910446,4500,null,null,null,null,null,null,null,null,22,0.3235294117647059,0.45785193101249527,4700]
[23,1958,1549,null,null,null,6000,8,0.11940298507462686,0.80597014925373134,5500,null,null,null,null,null,null,null,null,23,0.33823529411764708,0.41728413938902159,4539]
[24,1959,4051,null,null,null,7000,2,2.9850746268656716E-2,0.83582089552238803,6500,null,null,null,null,null,null,null,null,24,0.35294117647058826,0.37739194382855357,4461]
[25,1960,975,null,null,null,8000,3,4.4776119402985072E-2,0.88059701492537312,7500,null,null,null,null,null,null,null,null,25,0.36764705882352944,0.33809165680420711,4355]
[26,1961,1260,null,null,null,9000,2,2.9850746268656716E-2,0.91044776119402981,8500,null,null,null,null,null,null,null,null,26,0.38235294117647056,0.29930691046566715,4294]
[27,1962,4355,null,null,null,10000,2,2.9850746268656716E-2,0.94029850746268651,9500,null,null,null,null,null,null,null,null,27,0.39705882352941174,0.26096740040145311,4214]
[28,1963,9622,null,null,null,11000,2,2.9850746268656716E-2,0.9701492537313432,10500,null,null,null,null,null,null,null,null,28,0.41176470588235292,0.22300783094036683,4182]
[29,1964,5299,null,null,null,12000,0,0,0.9701492537313432,11500,null,null,null,null,null,null,null,null,29,0.4264705882352941,0.18536701728959662,4145]
[30,1965,7093,null,null,null,13000,1,1.4925373134328358E-2,0.9850746268656716,12500,null,null,null,null,null,null,null,null,30,0.44117647058823528,0.14798710972583889,4051]
[31,1966,14367,null,null,null,14000,0,0,0.9850746268656716,13500,null,null,null,null,null,null,null,null,31,0.45588235294117646,0.11081291229915714,4043]
[32,1967,2626,null,null,null,15000,1,1.4925373134328358E-2,1,14500,null,null,null,null,null,null,null,null,32,0.47058823529411764,7.3791273808272689E-2,3914]
[33,1968,1898,null,null,null,16000,0,0,1,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":67},{"$f":"SUM(I21:I36)","v":1},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/($T$70+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":0.91180947739869289},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":4.2200000000000015E-2},{"$f":"$G$9+($G$10-$G$9)*(1-W4)","v":14779.411764705883},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},0.19953333333333334,14558.823529411764,null,null,null,null,null,null,null,null,null,0.95,-1.6448536269514715,{"$f":"AU5","v":750.00000000000057},null,{"$f":"MATCH(1-AK5,$K$17:$K$32,1)","v":1},2,{"$f":"IF(AO5<>AP5,INDEX($I$17:$I$32,AO5),INDEX($I$17:$I$32,AO5-1))","v":500},{"$f":"INDEX($I$17:$I$32,AP5)","v":1500},{"$f":"IF(AO5<>AP5,INDEX($K$17:$K$32,AO5),INDEX($K$17:$K$32,AO5-1))","v":3.3333333333333333E-2},{"$f":"INDEX($K$17:$K$32,AP5)","v":0.1},{"$f":"AQ5+(AR5-AQ5)*(1-AK5-AS5)/(AT5-AS5)","v":750.00000000000057}]
[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,0.28706666666666669,14338.235294117647,null,null,null,null,null,null,null,null,null,0.9,-1.2815515655446006,1499.9999999999995,null,1,2,500,1500,3.3333333333333333E-2,0.1,1499.9999999999995]
[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,0.32053333333333334,14117.64705882353,null,null,null,null,null,null,null,null,null,0.85,-1.0364333894937898,2250.0000000000005,null,2,3,1500,2500,0.1,0.16666666666666666,2250.0000000000005]
[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,0.35853333333333337,13897.058823529413,null,null,null,null,null,null,null,null,null,0.8,-0.84162123357291474,2999.9999999999995,null,3,4,2500,3500,0.16666666666666666,0.23333333333333334,2999.9999999999995]
[6,1941,10192,null,null,"min =",0,"a",null,null,null,null,null,null,null,null,null,null,null,null,null,6,8.8235294117647065E-2,1.3517022399306602,9478,0.36813333333333331,13676.470588235294,null,null,null,null,null,null,null,null,null,0.75,-0.67448975019608193,3750,null,4,5,3500,4500,0.23333333333333334,0.3,3750]
[7,1942,3270,null,null,"max =",15000,"b",null,null,null,null,null,null,null,null,null,null,null,null,null,7,0.10294117647058823,1.2649692448841479,8273,0.44846666666666668,13455.882352941177,null,null,null,null,null,null,null,null,null,0.7,-0.52440051270804078,4500.0000000000009,null,5,6,4500,5500,0.3,0.36666666666666664,4500.0000000000009]
[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,0.45620000000000005,13235.294117647058,null,null,null,null,null,null,null,null,null,0.65,-0.38532046640756784,5250,null,5,6,4500,5500,0.3,0.36666666666666664,5250]
[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,0.47299999999999998,13014.705882352942,null,null,null,null,null,null,null,null,null,0.6,-0.25334710313579978,6000,null,6,7,5500,6500,0.36666666666666664,0.43333333333333335,6000]
[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,0.50726666666666664,12794.117647058823,null,null,null,null,null,null,null,null,null,0.55000000000000104,-0.12566134685507668,6749.9999999999845,null,7,8,6500,7500,0.43333333333333335,0.5,6749.9999999999845]
[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,0.52713333333333334,12573.529411764706,null,null,null,null,null,null,null,null,null,0.500000000000001,-2.5046247822045905E-15,7499.9999999999854,null,7,8,6500,7500,0.43333333333333335,0.5,7499.9999999999854]
[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,0.54339999999999999,12352.941176470587,null,null,null,null,null,null,null,null,null,0.45000000000000101,0.12566134685507138,8249.9999999999836,null,8,9,7500,8500,0.5,0.56666666666666665,8249.9999999999836]
[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,0.55933333333333335,12132.35294117647,null,null,null,null,null,null,null,null,null,0.40000000000000102,0.25334710313579717,8999.9999999999854,null,9,10,8500,9500,0.56666666666666665,0.6333333333333333,8999.9999999999854]
[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":6.6666666666666666E-2},{"$f":"IF(I17<$G$9,0,IF(I17>$G$10,1,(I17-$G$9)/($G$10-$G$9)))","v":3.3333333333333333E-2},null,null,null,null,null,null,null,null,null,null,14,0.20588235294117646,0.82079208833238126,5689,0.62073333333333336,11911.764705882353,null,null,null,null,null,null,null,null,null,0.35000000000000098,0.38532046640756507,9749.9999999999854,null,10,11,9500,10500,0.6333333333333333,0.7,9749.9999999999854]
[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},6.6666666666666666E-2,{"$f":"IF(I18<$G$9,0,IF(I18>$G$10,1,(I18-$G$9)/($G$10-$G$9)))","v":0.1},null,null,null,null,null,null,null,null,null,null,15,0.22058823529411764,0.77020808187547585,5665,0.6223333333333334,11691.176470588236,null,null,null,null,null,null,null,null,null,0.30000000000000099,0.52440051270803822,10499.999999999987,null,10,{"$f":"IF(AO18<16,AO18+1,AO18)","v":11},9500,10500,0.6333333333333333,0.7,10499.999999999987]
[16,1951,3419,null,3000,15,0.22388059701492538,{"$f":"H18+G19","v":0.40298507462686567},{"$f":"AVERAGE(E18:E19)","v":2500},6.6666666666666666E-2,0.16666666666666666,null,null,null,null,null,null,null,null,null,null,16,0.23529411764705882,0.72152228398234308,5646,0.62359999999999993,11470.588235294117,null,null,null,null,null,null,null,null,null,0.250000000000001,0.6744897501960786,11249.999999999985,null,11,{"$f":"IF(AO19<16,AO19+1,AO19)","v":12},10500,11500,0.7,0.76666666666666672,11249.999999999985]
[17,1952,746,null,4000,9,0.13432835820895522,0.53731343283582089,3500,6.6666666666666666E-2,0.23333333333333334,null,null,null,null,null,null,null,null,null,null,17,0.25,0.67448975019608193,5632,0.62453333333333338,11250,null,null,null,null,null,null,null,null,null,0.20000000000000101,0.84162123357291074,11999.999999999984,null,12,{"$f":"IF(AO20<16,AO20+1,AO20)","v":13},11500,12500,0.76666666666666672,0.83333333333333337,11999.999999999984]
[18,1953,5632,null,5000,10,0.14925373134328357,0.68656716417910446,4500,6.6666666666666666E-2,0.3,null,null,null,null,null,null,null,null,null,null,18,0.26470588235294118,0.62890421763218995,5556,0.62959999999999994,11029.411764705883,null,null,null,null,null,null,null,null,null,0.15000000000000099,1.0364333894937861,12749.999999999984,null,13,14,12500,13500,0.83333333333333337,0.9,12749.999999999984]
[19,1954,1659,null,6000,8,0.11940298507462686,0.80597014925373134,5500,6.6666666666666666E-2,0.36666666666666664,null,null,null,null,null,null,null,null,null,null,19,0.27941176470588236,0.58458985705947353,5299,0.64673333333333338,10808.823529411764,null,null,null,null,null,null,null,null,null,0.100000000000001,1.2815515655445955,13499.999999999985,null,13,14,12500,13500,0.83333333333333337,0.9,13499.999999999985]
[20,1955,4539,null,7000,2,2.9850746268656716E-2,0.83582089552238803,6500,6.6666666666666666E-2,0.43333333333333335,null,null,null,null,null,null,null,null,null,null,20,0.29411764705882354,0.54139508512908763,5281,0.64793333333333325,10588.235294117647,null,null,null,null,null,null,null,null,null,5.0000000000000898E-2,1.6448536269514629,14249.999999999985,null,14,15,13500,14500,0.9,0.96666666666666667,14249.999999999985]
[21,1956,2986,null,8000,3,4.4776119402985072E-2,0.88059701492537312,7500,6.6666666666666666E-2,0.5,null,null,null,null,null,null,null,null,null,null,21,0.30882352941176472,0.49918784205087674,5057,0.66286666666666672,10367.64705882353,null,null,null,null,null,null,null,null,null,0.02,2.0537489106318221,14900,null,15,16,14500,15500,0.96666666666666667,1,14900]
[22,1957,6849,null,9000,2,2.9850746268656716E-2,0.91044776119402981,8500,6.6666666666666666E-2,0.56666666666666665,null,null,null,null,null,null,null,null,null,null,22,0.3235294117647059,0.45785193101249527,4700,0.68666666666666665,10147.058823529413,null,null,null,null,null,null,null,null,null,0.01,2.3263478740408408,15200,null,15,16,14500,15500,0.96666666666666667,1,15200]
[23,1958,1549,null,10000,2,2.9850746268656716E-2,0.94029850746268651,9500,6.6666666666666666E-2,0.6333333333333333,null,null,null,null,null,null,null,null,null,null,23,0.33823529411764708,0.41728413938902159,4539,0.69740000000000002,9926.4705882352937]
[24,1959,4051,null,11000,2,2.9850746268656716E-2,0.9701492537313432,10500,6.6666666666666666E-2,0.7,null,null,null,null,null,null,null,null,null,null,24,0.35294117647058826,0.37739194382855357,4461,0.7026,9705.8823529411748]
[25,1960,975,null,12000,0,0,0.9701492537313432,11500,6.6666666666666666E-2,0.76666666666666672,null,null,null,null,null,null,null,null,null,null,25,0.36764705882352944,0.33809165680420711,4355,0.70966666666666667,9485.2941176470576]
[26,1961,1260,null,13000,1,1.4925373134328358E-2,0.9850746268656716,12500,6.6666666666666666E-2,0.83333333333333337,null,null,null,null,null,null,null,null,null,null,26,0.38235294117647056,0.29930691046566715,4294,0.71373333333333333,9264.7058823529424]
[27,1962,4355,null,14000,0,0,0.9850746268656716,13500,6.6666666666666666E-2,0.9,null,null,null,null,null,null,null,null,null,null,27,0.39705882352941174,0.26096740040145311,4214,0.71906666666666674,9044.1176470588252]
[28,1963,9622,null,15000,1,1.4925373134328358E-2,1,14500,6.6666666666666666E-2,0.96666666666666667,null,null,null,null,null,null,null,null,null,null,28,0.41176470588235292,0.22300783094036683,4182,0.72120000000000006,8823.5294117647063]
[29,1964,5299,null,16000,0,0,1,15500,6.6666666666666666E-2,1,null,null,null,null,null,null,null,null,null,null,29,0.4264705882352941,0.18536701728959662,4145,0.72366666666666668,8602.9411764705874,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,0.72993333333333332,8382.3529411764703,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,0.7304666666666666,8161.7647058823541,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,0.73906666666666665,7941.1764705882351,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,0.76319999999999999,7720.5882352941171,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,0.77206666666666668,7500,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,0.77639999999999998,7279.4117647058829,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,0.77893333333333337,7058.8235294117649,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,0.78146666666666664,6838.2352941176478,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,0.78200000000000003,6617.6470588235288,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,0.78820000000000001,6397.0588235294126]
[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,0.78900000000000003,6176.4705882352937]
[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,0.80093333333333327,5955.8823529411766]
[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,0.8090666666666666,5735.2941176470586]
[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,0.81033333333333335,5514.7058823529414]
[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,0.81146666666666667,5294.1176470588234]
[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,0.81633333333333336,5073.5294117647063]
[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,0.81920000000000004,4852.9411764705874]
[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,0.82000000000000006,4632.3529411764712]
[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,0.82473333333333332,4411.7647058823522]
[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,0.8249333333333333,4191.1764705882351]
[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,0.83413333333333339,3970.5882352941167]
[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,0.8372666666666666,3750]
[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,0.85199999999999998,3529.4117647058833]
[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,0.86240000000000006,3308.8235294117644]
[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,0.86393333333333333,3088.2352941176478]
[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,0.86526666666666663,2867.6470588235293]
[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,0.87280000000000002,2647.0588235294122]
[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,0.87346666666666661,2426.4705882352937]
[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,0.87660000000000005,2205.882352941177]
[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,0.88939999999999997,1985.2941176470583]
[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,0.89626666666666666,1764.7058823529417]
[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,0.89673333333333338,1544.117647058823]
[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,0.89700000000000002,1323.5294117647061]
[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,0.91600000000000004,1102.9411764705876]
[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,0.91926666666666668,882.35294117647084]
[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":0.93386666666666662},{"$f":"$G$9+($G$10-$G$9)*(1-W68)","v":661.76470588235225}]
[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},0.93500000000000005,441.17647058823542]
[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,0.9502666666666667,220.58823529411686]

{"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":0.9665885887722615},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":2.1370080000000513E-3},{"$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":13339.472089612322},null,null,null,null,null,null,null,null,null,0.98,{"$f":"NORMSINV(1-AK4)","v":-2.0537489106318221},{"$f":"AU4","v":750.00000000000034},null,{"$f":"MATCH(1-AK4,$K$17:$K$32,1)","v":1},{"$f":"IF(AO4<16,AO4+1,AO4)","v":2},{"$f":"IF(AO4<>AP4,INDEX($I$17:$I$32,AO4),INDEX($I$17:$I$32,AO4-1))","v":500},{"$f":"INDEX($I$17:$I$32,AP4)","v":1500},{"$f":"IF(AO4<>AP4,INDEX($K$17:$K$32,AO4),INDEX($K$17:$K$32,AO4-1))","v":6.6666666666666671E-3},{"$f":"INDEX($K$17:$K$32,AP4)","v":0.06},{"$f":"AQ4+(AR4-AQ4)*(1-AK4-AS4)/(AT4-AS4)","v":750.00000000000034}]
[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":4.7776261333333347E-2},12651.658908430689,null,null,null,null,null,null,null,null,null,0.95,-1.6448536269514715,{"$f":"AU5","v":1312.5000000000009},null,{"$f":"MATCH(1-AK5,$K$17:$K$32,1)","v":1},2,{"$f":"IF(AO5<>AP5,INDEX($I$17:$I$32,AO5),INDEX($I$17:$I$32,AO5-1))","v":500},{"$f":"INDEX($I$17:$I$32,AP5)","v":1500},{"$f":"IF(AO5<>AP5,INDEX($K$17:$K$32,AO5),INDEX($K$17:$K$32,AO5-1))","v":6.6666666666666671E-3},{"$f":"INDEX($K$17:$K$32,AP5)","v":0.06},{"$f":"AQ5+(AR5-AQ5)*(1-AK5-AS5)/(AT5-AS5)","v":1312.5000000000009}]
[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,9.8888725333333372E-2,12123.881291822361,null,null,null,null,null,null,null,null,null,0.9,-1.2815515655446006,1874.9999999999998,null,2,3,1500,2500,0.06,0.16666666666666669,1874.9999999999998]
[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,0.12328994133333337,11678.944179224643,null,null,null,null,null,null,null,null,null,0.85,-1.0364333894937898,2343.75,null,2,3,1500,2500,0.06,0.16666666666666669,2343.75]
[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,0.15425538133333339,11286.946713837471,null,null,null,null,null,null,null,null,null,0.8,-0.84162123357291474,2760.4166666666661,null,3,4,2500,3500,0.16666666666666669,0.29466666666666674,2760.4166666666661]
[6,1941,10192,null,null,"min =",0,"a",null,null,null,null,null,null,null,null,null,null,null,null,null,6,8.8235294117647065E-2,1.3517022399306602,9478,0.1626265813333333,10932.553915900196,null,null,null,null,null,null,null,null,null,0.75,-0.67448975019608193,3151.0416666666661,null,3,4,2500,3500,0.16666666666666669,0.29466666666666674,3151.0416666666661]
[7,1942,3270,null,null,"mode =",2500,"c",null,null,null,null,null,null,null,null,null,null,null,null,null,7,0.10294117647058823,1.2649692448841479,8273,0.24134682133333329,10606.656104032454,null,null,null,null,null,null,null,null,null,0.7,-0.52440051270804078,3545.454545454545,null,4,5,3500,4500,0.29466666666666674,0.41200000000000003,3545.454545454545]
[8,1943,12007,null,null,"max =",15000,"b",null,null,null,null,null,null,null,null,null,null,null,null,null,8,0.11764705882352941,1.186831432755818,8157,0.24974212800000006,10303.317816861378,null,null,null,null,null,null,null,null,null,0.65,-0.38532046640756784,3971.5909090909086,null,4,5,3500,4500,0.29466666666666674,0.41200000000000003,3971.5909090909086]
[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,0.26847480000000001,10018.416268836965,null,null,null,null,null,null,null,null,null,0.6,-0.25334710313579978,4397.727272727273,null,4,5,3500,4500,0.29466666666666674,0.41200000000000003,4397.727272727273]
[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,0.30878336533333339,9748.9496848949639,null,null,null,null,null,null,null,null,null,0.55000000000000104,-0.12566134685507668,4856.24999999999,null,5,6,4500,5500,0.41200000000000003,0.51866666666666661,4856.24999999999]
[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,0.33344346133333325,9492.6519673311741,null,null,null,null,null,null,null,null,null,0.500000000000001,-2.5046247822045905E-15,5324.9999999999909,null,5,6,4500,5500,0.41200000000000003,0.51866666666666661,5324.9999999999909]
[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,0.35434027199999996,9247.7625836447223,null,null,null,null,null,null,null,null,null,0.45000000000000101,0.12566134685507138,5826.3888888888778,null,6,7,5500,6500,0.51866666666666661,0.61466666666666669,5826.3888888888778]
[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,0.37542453333333325,9012.8814747581528,null,null,null,null,null,null,null,null,null,0.40000000000000102,0.25334710313579717,6347.2222222222117,null,6,7,5500,6500,0.51866666666666661,0.61466666666666669,6347.2222222222117]
[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":2.6666666666666665E-2},{"$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":6.6666666666666671E-3},null,null,null,null,null,null,null,null,null,null,14,0.20588235294117646,0.82079208833238126,5689,0.46237184533333331,8786.8734781536441,null,null,null,null,null,null,null,null,null,0.35000000000000098,0.38532046640756507,6914.0624999999882,null,7,8,6500,7500,0.61466666666666669,0.7,6914.0624999999882]
[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":0.08},{"$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":0.06},null,null,null,null,null,null,null,null,null,null,15,0.22058823529411764,0.77020808187547585,5665,0.46475853333333328,8568.8030571559193,null,null,null,null,null,null,null,null,null,0.30000000000000099,0.52440051270803822,7499.99999999999,null,7,{"$f":"IF(AO18<16,AO18+1,AO18)","v":8},6500,7500,0.61466666666666669,0.7,7499.99999999999]
[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":0.1333333333333333},{"$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":0.16666666666666669},null,null,null,null,null,null,null,null,null,null,16,0.23529411764705882,0.72152228398234308,5646,0.4666523520000001,8357.8883584492851,null,null,null,null,null,null,null,null,null,0.250000000000001,0.6744897501960786,8169.6428571428442,null,8,{"$f":"IF(AO19<16,AO19+1,AO19)","v":9},7500,8500,0.7,0.77466666666666661,8169.6428571428442]
[17,1952,746,null,4000,9,0.13432835820895522,0.53731343283582089,3500,0.12266666666666667,0.29466666666666674,null,null,null,null,null,null,null,null,null,null,17,0.25,0.67448975019608193,5632,0.46805026133333327,8153.4680311854236,null,null,null,null,null,null,null,null,null,0.20000000000000101,0.84162123357291074,8895.8333333333176,null,{"$f":"MATCH(1-AK20,$K$17:$K$32,1)","v":9},{"$f":"IF(AO20<16,AO20+1,AO20)","v":10},8500,9500,0.77466666666666661,0.83866666666666667,8895.8333333333176]
[18,1953,5632,null,5000,10,0.14925373134328357,0.68656716417910446,4500,0.112,0.41200000000000003,null,null,null,null,null,null,null,null,null,null,18,0.26470588235294118,0.62890421763218995,5556,0.47567539199999997,7954.9767252920683,null,null,null,null,null,null,null,null,null,0.15000000000000099,1.0364333894937861,9712.49999999998,null,10,11,9500,10500,0.83866666666666667,0.89200000000000002,9712.49999999998]
[19,1954,1659,null,6000,8,0.11940298507462686,0.80597014925373134,5500,0.10133333333333333,0.51866666666666661,null,null,null,null,null,null,null,null,null,null,19,0.27941176470588236,0.58458985705947353,5299,0.50191680533333327,7761.9266456913456,null,null,null,null,null,null,null,null,null,0.100000000000001,1.2815515655445955,10687.499999999976,null,11,12,10500,11500,0.89200000000000002,0.93466666666666665,10687.499999999976]
[20,1955,4539,null,7000,2,2.9850746268656716E-2,0.83582089552238803,6500,9.0666666666666673E-2,0.61466666666666669,null,null,null,null,null,null,null,null,null,null,20,0.29411764705882354,0.54139508512908763,5281,0.5037811253333333,7573.8934276749424,null,null,null,null,null,null,null,null,null,5.0000000000000898E-2,1.6448536269514629,11979.166666666637,null,12,13,11500,12500,0.93466666666666665,0.96666666666666667,11979.166666666637]
[21,1956,2986,null,8000,3,4.4776119402985072E-2,0.88059701492537312,7500,0.08,0.7,null,null,null,null,null,null,null,null,null,null,21,0.30882352941176472,0.49918784205087674,5057,0.52727066133333333,7390.5051570616142,null,null,null,null,null,null,null,null,null,0.02,2.0537489106318221,13125,null,13,14,12500,13500,0.96666666666666667,0.98799999999999999,13125]
[22,1957,6849,null,9000,2,2.9850746268656716E-2,0.91044776119402981,8500,6.933333333333333E-2,0.77466666666666661,null,null,null,null,null,null,null,null,null,null,22,0.3235294117647059,0.45785193101249527,4700,0.56581333333333339,7211.433719490964,null,null,null,null,null,null,null,null,null,0.01,2.3263478740408408,13687.5,null,14,15,13500,14500,0.98799999999999999,0.9986666666666667,13687.5]
[23,1958,1549,null,10000,2,2.9850746268656716E-2,0.94029850746268651,9500,5.8666666666666666E-2,0.83866666666666667,null,null,null,null,null,null,null,null,null,null,23,0.33823529411764708,0.41728413938902159,4539,0.58364011199999999,7036.3879020221711]
[24,1959,4051,null,11000,2,2.9850746268656716E-2,0.9701492537313432,10500,4.8000000000000001E-2,0.89200000000000002,null,null,null,null,null,null,null,null,null,null,24,0.35294117647058826,0.37739194382855357,4461,0.59237611199999995,6865.1078318003938]
[25,1960,975,null,12000,0,0,0.9701492537313432,11500,3.7333333333333336E-2,0.93466666666666665,null,null,null,null,null,null,null,null,null,null,25,0.36764705882352944,0.33809165680420711,4355,0.60435213333333337,6697.3604480616068]
[26,1961,1260,null,13000,1,1.4925373134328358E-2,0.9850746268656716,12500,2.6666666666666665E-2,0.96666666666666667,null,null,null,null,null,null,null,null,null,null,26,0.38235294117647056,0.29930691046566715,4294,0.61129832533333339,6532.935782067776]
[27,1962,4355,null,14000,0,0,0.9850746268656716,13500,1.6E-2,0.98799999999999999,null,null,null,null,null,null,null,null,null,null,27,0.39705882352941174,0.26096740040145311,4214,0.62046824533333333,6371.6438754670817]
[28,1963,9622,null,15000,1,1.4925373134328358E-2,1,14500,5.333333333333334E-3,0.9986666666666667,null,null,null,null,null,null,null,null,null,null,28,0.41176470588235292,0.22300783094036683,4182,0.62415532799999995,6213.3122080649082]
[29,1964,5299,null,16000,0,0,1,15500,-5.333333333333334E-3,0.9986666666666667,null,null,null,null,null,null,null,null,null,null,29,0.4264705882352941,0.18536701728959662,4145,0.62843213333333336,6057.7835357156764]
[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,0.63936320533333335,5904.9140611375151,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,0.64029786133333333,5754.5718770588792,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,0.65546344533333334,5606.6356337227571,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,0.69896908800000002,5460.9933924530942,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,0.71530432533333344,5317.5416344814585,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,0.72335635200000004,5176.1844000828041,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,0.72808456533333332,5036.8325376739285,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,0.73282818133333338,4899.4030461794282,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,0.73382880000000006,4763.8184968853802,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,0.74551108799999999,4630.0065233442729,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,0.74702520000000006,4497.8993697899259]
[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,0.76979304533333326,4367.4334900629328]
[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,0.78550664533333325,4238.5491903084094]
[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,0.78796813333333338,4111.1903097451359]
[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,0.79017378133333327,3985.30393466235]
[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,0.79968013333333332,3860.8401415124135]
[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,0.80530636799999988,3737.7517655612974]
[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,0.80688000000000004,3615.9941920563779]
[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,0.8162220853333334,3495.5251672894428]
[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,0.81661800533333329,3376.3046272862503]
[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,0.83492949333333333,3258.2945421534478]
[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,0.84110717333333329,3141.458774368577]
[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,0.86857600000000001,3025.7629495163037]
[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,0.88639743999999998,2911.1743381603465]
[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,0.88891517333333336,2797.6617477005893]
[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,0.89108157333333338,2685.1954232027747]
[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,0.90292095999999999,2573.74695630729]
[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,0.90393589333333335,2463.2892014269219]
[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,0.90863464000000005,2353.796198533124]
[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,0.92660584000000001,2245.2431019085361]
[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,0.93543637333333329,2137.6061143118386]
[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,0.93601597333333331,2030.8624260606794]
[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,0.93634600000000001,1924.9901585910393]
[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,0.95766399999999996,1819.9683120973623]
[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,0.96089277333333334,1715.7767168985702]
[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,0.9737582933333333,{"$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":1612.3959882109375}]
[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":0.97465000000000002},1509.8074840405989]
[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,0.98515957333333337,1407.9932659366477]

{"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":0.9714098372129929}]
[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":2.0879838273490936E-4},{"$f":"_xlfn.NORM.INV(1-W4,$G$9,$G$10)","v":10531.434510429877},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":-1484.4523356138407}]
[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":3.4923009748434319E-3},{"$f":"_xlfn.NORM.INV(1-W5,$G$9,$G$10)","v":9712.4817900266826},null,null,null,null,null,null,null,null,null,0.95,-1.6448536269514715,{"$f":"NORMINV(1-AK5,$G$9,$G$10)","v":-323.38893463726163}]
[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,1.2702955335638588E-2,9187.9412684473136,null,null,null,null,null,null,null,null,null,0.9,-1.2815515655446006,708.2119270851108]
[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,1.977667345261036E-2,8790.2549086297568,null,null,null,null,null,null,null,null,null,0.85,-1.0364333894937898,1404.2281309531195]
[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,3.1609742533993179E-2,8464.4845234985169,null,null,null,null,null,null,null,null,null,0.8,-0.84162123357291474,1957.3997456247425]
[6,1941,10192,null,null,"mean =",{"$f":"AVERAGE(C4:C70)","v":4347.1940298507461},null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,8.8235294117647065E-2,1.3517022399306602,9478,3.5386458014234123E-2,8185.3698720265702,null,null,null,null,null,null,null,null,null,0.75,-0.67448975019608193,2431.9717356784668]
[7,1942,3270,null,null,"stdev =",{"$f":"STDEV(C4:C70)","v":2839.5128222712092},null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,0.10294117647058823,1.2649692448841479,8273,8.3399417715403157E-2,7939.0904204780127,null,null,null,null,null,null,null,null,null,0.7,-0.52440051270804078,2858.1520500106681,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,8.9844837687901524E-2,7717.2171010354014,null,null,null,null,null,null,null,null,null,0.65,-0.38532046640756784,3253.0716248029348,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,0.10510949225679511,7514.2087582939239,null,null,null,null,null,null,null,null,null,0.6,-0.25334710313579978,3627.8116820113764,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,0.14187202039394209,7326.2160866167651,null,null,null,null,null,null,null,null,null,0.55000000000000104,-0.12566134685507668,3990.377024191886,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,0.16677227466079758,7150.4490901503723,null,null,null,null,null,null,null,null,null,0.500000000000001,-2.5046247822045905E-15,4347.1940298507388,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,0.18914030912680502,6984.816046984376,null,null,null,null,null,null,null,null,null,0.45000000000000101,0.12566134685507138,4704.0110355095912,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,0.21275473933247768,6827.7047887306526,null,null,null,null,null,null,null,null,null,0.40000000000000102,0.25334710313579717,5066.5763776901085,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":5.6111275260997635E-2},{"$f":"NORMDIST(I17,$G$9,$G$10,TRUE)","v":8.7728182679569916E-2},null,null,null,null,null,null,null,null,null,null,14,0.20588235294117646,0.82079208833238126,5689,0.31826786139798802,6677.8436890893063,null,null,null,null,null,null,null,null,null,0.35000000000000098,0.38532046640756507,5441.3164348985501,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":8.4985060001623772E-2},0.15800158071973397,null,null,null,null,null,null,null,null,null,null,15,0.22058823529411764,0.77020808187547585,5665,0.32128955596183806,6534.2097541530729,null,null,null,null,null,null,null,null,null,0.30000000000000099,0.52440051270803822,5836.2360096908169,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":0.11370283007648549},0.25767431074621361,null,null,null,null,null,null,null,null,null,null,16,0.23529411764705882,0.72152228398234308,5646,0.32369016177640386,6395.9658067730179,null,null,null,null,null,null,null,null,null,0.250000000000001,0.6744897501960786,6262.4163240230164,null,0.01,2.3263478740408408,2.3263478740408408,0]
[17,1952,746,null,4000,9,0.13432835820895522,0.53731343283582089,3500,0.13438048569910965,0.38271461270514245,null,null,null,null,null,null,null,null,null,null,17,0.25,0.67448975019608193,5632,0.32546374268439693,6262.4163240230255,null,null,null,null,null,null,null,null,null,0.20000000000000101,0.84162123357291074,6736.9883140767379]
[18,1953,5632,null,5000,10,0.14925373134328357,0.68656716417910446,4500,0.14029344551553083,0.52145838227584052,null,null,null,null,null,null,null,null,null,null,18,0.26470588235294118,0.62890421763218995,5556,0.3351599764704406,6132.9756197977931,null,null,null,null,null,null,null,null,null,0.15000000000000099,1.0364333894937861,7290.1599287483623]
[19,1954,1659,null,6000,8,0.11940298507462686,0.80597014925373134,5500,0.12938227971348229,0.65762401154888117,null,null,null,null,null,null,null,null,null,null,19,0.27941176470588236,0.58458985705947353,5299,0.36873694205018481,6007.1444247408144,null,null,null,null,null,null,null,null,null,0.100000000000001,1.2815515655445955,7986.1761326163669]
[20,1955,4539,null,7000,2,2.9850746268656716E-2,0.83582089552238803,6500,0.10540190489755896,0.77582249585838969,null,null,null,null,null,null,null,null,null,null,20,0.29411764705882354,0.54139508512908763,5281,0.37113025118346632,5884.4923159894033,null,null,null,null,null,null,null,null,null,5.0000000000000898E-2,1.6448536269514629,9017.7769943387284]
[21,1956,2986,null,8000,3,4.4776119402985072E-2,0.88059701492537312,7500,7.5850485233178694E-2,0.86657231054308581,null,null,null,null,null,null,null,null,null,null,21,0.30882352941176472,0.49918784205087674,5057,0.4013035109418146,5764.6443080761055,null,null,null,null,null,null,null,null,null,0.02,2.0537489106318221,10178.840395315332]
[22,1957,6849,null,9000,2,2.9850746268656716E-2,0.91044776119402981,8500,4.8217480099013818E-2,0.92819876828887471,null,null,null,null,null,null,null,null,null,null,22,0.3235294117647059,0.45785193101249527,4700,0.45055915500501009,5647.2704586623595,null,null,null,null,null,null,null,null,null,0.01,2.3263478740408408,10952.888647253081]
[23,1958,1549,null,10000,2,2.9850746268656716E-2,0.94029850746268651,9500,2.7076149245801068E-2,0.96521341847529085,null,null,null,null,null,null,null,null,null,null,23,0.33823529411764708,0.41728413938902159,4539,0.47307236681377862,5532.0776941762797]
[24,1959,4051,null,11000,2,2.9850746268656716E-2,0.9701492537313432,10500,1.343091286572852E-2,0.98487695547414411,null,null,null,null,null,null,null,null,null,null,24,0.35294117647058826,0.37739194382855357,4461,0.48401491251945838,5418.8032933737795]
[25,1960,975,null,12000,0,0,0.9701492537313432,11500,5.8851888945396147E-3,0.99411599780287108,null,null,null,null,null,null,null,null,null,null,25,0.36764705882352944,0.33809165680420711,4355,0.49890328806220952,5307.2096244492095]
[26,1961,1260,null,13000,1,1.4925373134328358E-2,0.9850746268656716,12500,2.2779884872839939E-3,0.99795540902549984,null,null,null,null,null,null,null,null,null,null,26,0.38235294117647056,0.29930691046566715,4294,0.50747315040090335,5197.0798399123887]
[27,1962,4355,null,14000,0,0,0.9850746268656716,13500,7.7889494601840665E-4,0.99936654534993308,null,null,null,null,null,null,null,null,null,null,27,0.39705882352941174,0.26096740040145311,4214,0.51870646608644067,5088.2143094854573]
[28,1963,9622,null,15000,1,1.4925373134328358E-2,1,14500,2.3525696487711892E-4,0.99982525049778193,null,null,null,null,null,null,null,null,null,null,28,0.41176470588235292,0.22300783094036683,4182,0.52319613634118545,4980.4276252728077]
[29,1964,5299,null,16000,0,0,1,15500,6.2768584730807522E-5,0.99995712218257704,null,null,null,null,null,null,null,null,null,null,29,0.4264705882352941,0.18536701728959662,4145,0.52838361257918365,4873.5460522707244]
[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,0.541538950272346,4767.4053254481223]
[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,0.54265666010421898,4661.8487151974177]
[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,0.56062708031072339,4556.7252980010617]
[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,0.61027886928822095,4451.8883801086922]
[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,0.62812255080265222,4347.1940298507461]
[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,0.63674667240492555,4242.4996795928]
[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,0.64175686360543871,4137.6627617004306]
[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,0.6467427647092383,4032.5393445040754]
[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,0.6477892603596852,3926.9827342533704]
[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,0.65987091013004373,3820.8420074307678]
[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,0.66141826090485156,3713.9604344286845]
[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,0.68416438430141857,3606.1737502160363]
[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,0.6992835440170021,3497.3082197891035]
[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,0.701608481999074,3387.1784352522827]
[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,0.70368172806690876,3275.5847663277109]
[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,0.71250847392731442,3162.3103655252125]
[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,0.7176489227429701,3047.1176010391328]
[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,0.71907553439569105,2929.7437516253867]
[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,0.72744428690544372,2809.895743712088]
[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,0.72779515230970593,2687.2436349606778]
[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,0.74368824532936839,2561.4124399036996]
[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,0.74898854319216712,2431.9717356784668]
[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,0.77311373387599625,2298.4222529284743]
[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,0.78932446638937648,2160.1783055484193]
[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,0.79165567210309362,2016.5443706121887]
[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,0.79367038423973169,1866.6832709708392]
[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,0.80483484377600067,1709.5720127171162]
[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,0.80580484628257931,1543.93896955112]
[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,0.81032440023315222,1368.1719730847276]
[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,0.8281066097287646,1180.1793014075683]
[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,0.83719220097436486,977.17095866609043]
[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,0.83779812450833813,755.29763922347911]
[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,0.83814370644162228,509.01818767492205]
[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,0.86153167338017578,229.90353620297628]
[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,0.86530819275232274,-95.866848928264517]
[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,0.88131956823532753,-493.5532087458223]
[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":0.88250368998251894},{"$f":"_xlfn.NORM.INV(1-W69,$G$9,$G$10)","v":-1018.0937303251912}]
[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,0.89764451849138804,-1837.0464507283841]

{"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":0.99854642546145933}]
[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,{"$f":"LOG(C4)","v":3.6328620401002301},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":1.5247671937148266E-2},{"$f":"10^_xlfn.NORM.INV(1-W4,$G$9,$G$10)","v":14500.080316263548},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":951.9645337470248}]
[2,1937,992,{"$f":"LOG(C5)","v":2.9965116721541785},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":2.9730400131814827E-2},{"$f":"10^_xlfn.NORM.INV(1-W5,$G$9,$G$10)","v":12043.677745569612},null,null,null,null,null,null,null,null,null,0.95,-1.6448536269514715,{"$f":"10^NORMINV(1-AK5,$G$9,$G$10)","v":1238.5306015459089}]
[3,1938,2629,3.4197905861063629,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,4.4113405992768029E-2,10693.687102293829,null,null,null,null,null,null,null,null,null,0.9,-1.2815515655446006,{"$f":"10^NORMINV(1-AK6,$G$9,$G$10)","v":1564.7661323789289}]
[4,1939,8157,3.9115304623071627,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,5.8823529411764705E-2,1.5647264713617985,10192,5.1538213090375207E-2,9771.9749943016323,null,null,null,null,null,null,null,null,null,0.85,-1.0364333894937898,1832.1448777568464]
[5,1940,3316,3.5206145218782359,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,6.1695610090734654E-2,9076.4509674905967,null,null,null,null,null,null,null,null,null,0.8,-0.84162123357291474,2076.8717880751287]
[6,1941,10192,4.0082594149912749,null,"mean of logs =",{"$f":"AVERAGE(D4:D70)","v":3.5526422889065978},null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,8.8235294117647065E-2,1.3517022399306602,9478,6.4599981982683685E-2,8520.0512894859894,null,null,null,null,null,null,null,null,null,0.75,-0.67448975019608193,2312.7187999900184]
[7,1942,3270,3.514547752660286,null,"stdev of logs =",{"$f":"STDEV(D4:D70)","v":0.27949936687077193},null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,0.10294117647058823,1.2649692448841479,8273,9.5779586872251188E-2,8057.5014430279252,null,null,null,null,null,null,null,null,null,0.7,-0.52440051270804078,2547.2564911224194]
[8,1943,12007,4.0794345106337433,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,0.11764705882352941,1.186831432755818,8157,9.9564101167402219E-2,7662.3312485932029,null,null,null,null,null,null,null,null,null,0.65,-0.38532046640756784,2785.7713172269296]
[9,1944,2441,3.3875677794171888,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,0.13235294117647059,1.1153373577337866,7905,0.10836341850191311,7317.7635785265311,null,null,null,null,null,null,null,null,null,0.6,-0.25334710313579978,3032.7173369902157]
[10,1945,5057,3.7038929536325447,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,0.14705882352941177,1.0491313979639725,7391,0.12906735856994866,7012.5157615917442,null,null,null,null,null,null,null,null,null,0.55000000000000104,-0.12566134685507668,3292.4563199927757,null,null,"Interpolation"]
[11,1946,4461,3.6494322232416168,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,0.16176470588235295,0.98723099199017461,7093,0.1430167410204094,6738.6473012126398,null,null,null,null,null,null,null,null,null,0.500000000000001,-2.5046247822045905E-15,3569.7868788000137,null,null,null,"D",null,null,"A","B","C","E"]
[12,1947,5556,3.744762237065578,"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,0.15565656075808265,6490.3648163719718,null,null,null,null,null,null,null,null,null,0.45000000000000101,0.12566134685507138,3870.4775770816314,null,null,"Normal Distribution PDF and CDF",null,null,null,"first",null,"second"]
[13,1948,3278,3.5156089492344802,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,0.16921295861503316,6263.3157901555905,null,null,null,null,null,null,null,null,null,0.40000000000000102,0.25334710313579717,4201.9670625485187,null,null,"index",null,"lower","upper","lower","upper","lower","upper","interp"]
[14,1949,5281,3.7227161674884948,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":1.5275235449302758E-3},{"$f":"NORMDIST(LOG(I17),$G$9,$G$10,TRUE)","v":1.1279672648286433E-3},null,null,null,null,null,null,null,null,null,null,14,0.20588235294117646,0.82079208833238126,5689,0.23449321857477523,6054.1497340684282,null,null,null,null,null,null,null,null,null,0.35000000000000098,0.38532046640756507,4574.4524258861475,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":7.7581775983134209E-4},{"$f":"INDEX($J$36:$J$53,AS17)","v":2.3108508791689218E-3},{"$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":1.5275235449302758E-3}]
[15,1950,3177,3.5020172148271476,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":5.8097008668366562E-2},8.8952452067375024E-2,null,null,null,null,null,null,null,null,null,null,15,0.22058823529411764,0.77020808187547585,5665,0.23651424854932779,5860.2340316169903,null,null,null,null,null,null,null,null,null,0.30000000000000099,0.52440051270803822,5002.7857047240468,null,null,{"$f":"AVERAGE(E17:E18)","v":1500},{"$f":"LOG(AP18)","v":3.1760912590556813},{"$f":"MATCH(AQ18,$I$36:$I$53,1)","v":6},7,{"$f":"IF(AR18<>AS18,INDEX($J$36:$J$53,AR18),INDEX($J$36:$J$53,AR18-1))","v":5.0569362722227722E-2},{"$f":"INDEX($J$36:$J$53,AS18)","v":7.9420580404265098E-2},{"$f":"IF(AR18<>AS18,INDEX($I$36:$I$53,AR18),INDEX($I$36:$I$53,AR18-1))","v":3.1500000000000004},{"$f":"INDEX($I$36:$I$53,AS18)","v":3.25},{"$f":"AT18+(AU18-AT18)*(AQ18-AV18)/(AW18-AV18)","v":5.8097008668366562E-2}]
[16,1951,3419,3.5338991007965945,3000,15,0.22388059701492538,{"$f":"H18+G19","v":0.40298507462686567},{"$f":"AVERAGE(E18:E19)","v":2500},0.12109830218920695,0.28996129874023246,null,null,null,null,null,null,null,null,null,null,16,0.23529411764705882,0.72152228398234308,5646,0.2381271235154796,5679.4634691121628,null,null,null,null,null,null,null,null,null,0.250000000000001,0.6744897501960786,5510.1287541346373,null,null,2500,3.3979400086720375,{"$f":"MATCH(AQ19,$I$36:$I$53,1)","v":8},9,{"$f":"IF(AR19<>AS19,INDEX($J$36:$J$53,AR19),INDEX($J$36:$J$53,AR19-1))","v":0.10974514252257073},{"$f":"INDEX($J$36:$J$53,AS19)","v":0.13342715673392461},{"$f":"IF(AR19<>AS19,INDEX($I$36:$I$53,AR19),INDEX($I$36:$I$53,AR19-1))","v":3.3499999999999996},{"$f":"INDEX($I$36:$I$53,AS19)","v":3.45},0.12109830218920695]
[17,1952,746,2.8727388274726686,4000,9,0.13432835820895522,0.53731343283582089,3500,0.14217647917004694,0.48776350633109289,null,null,null,null,null,null,null,null,null,null,17,0.25,0.67448975019608193,5632,0.23932289677139795,5510.1287541346464,null,null,null,null,null,null,null,null,null,0.20000000000000101,0.84162123357291074,6135.8522144804519,null,null,3500,3.5440680443502757,{"$f":"MATCH(AQ20,$I$36:$I$53,1)","v":9},10,{"$f":"IF(AR20<>AS20,INDEX($J$36:$J$53,AR20),INDEX($J$36:$J$53,AR20-1))","v":0.13342715673392461},{"$f":"INDEX($J$36:$J$53,AS20)","v":0.14272821374701927},{"$f":"IF(AR20<>AS20,INDEX($I$36:$I$53,AR20),INDEX($I$36:$I$53,AR20-1))","v":3.45},{"$f":"INDEX($I$36:$I$53,AS20)","v":3.55},0.14217647917004694]
[18,1953,5632,3.7506626461340558,5000,10,0.14925373134328357,0.68656716417910446,4500,0.13359095225730697,0.64051014749938995,null,null,null,null,null,null,null,null,null,null,18,0.26470588235294118,0.62890421763218995,5556,0.24592427092617486,5350.8234236196786,null,null,null,null,null,null,null,null,null,0.15000000000000099,1.0364333894937861,6955.4425060832837,null,null,4500,3.6532125137753435,{"$f":"MATCH(AQ21,$I$36:$I$53,1)","v":11},12,{"$f":"IF(AR21<>AS21,INDEX($J$36:$J$53,AR21),INDEX($J$36:$J$53,AR21-1))","v":0.13433281141470796},{"$f":"INDEX($J$36:$J$53,AS21)","v":0.11124001837845852},{"$f":"IF(AR21<>AS21,INDEX($I$36:$I$53,AR21),INDEX($I$36:$I$53,AR21-1))","v":3.6500000000000004},{"$f":"INDEX($I$36:$I$53,AS21)","v":3.75},0.13359095225730697]
[19,1954,1659,3.2198463860243609,6000,8,0.11940298507462686,0.80597014925373134,5500,0.11346554254781357,0.7490906369413598,null,null,null,null,null,null,null,null,null,null,19,0.27941176470588236,0.58458985705947353,5299,0.26967975554680435,5200.3764610409053,null,null,null,null,null,null,null,null,null,0.100000000000001,1.2815515655445955,8143.9507772825291,null,null,5500,3.7403626894942437,{"$f":"MATCH(AQ22,$I$36:$I$53,1)","v":11},12,{"$f":"IF(AR22<>AS22,INDEX($J$36:$J$53,AR22),INDEX($J$36:$J$53,AR22-1))","v":0.13433281141470796},{"$f":"INDEX($J$36:$J$53,AS22)","v":0.11124001837845852},{"$f":"IF(AR22<>AS22,INDEX($I$36:$I$53,AR22),INDEX($I$36:$I$53,AR22-1))","v":3.6500000000000004},{"$f":"INDEX($I$36:$I$53,AS22)","v":3.75},0.11346554254781357]
[20,1955,4539,3.6569601827428491,7000,2,2.9850746268656716E-2,0.83582089552238803,6500,9.2245719476085647E-2,0.82412610430621969,null,null,null,null,null,null,null,null,null,null,20,0.29411764705882354,0.54139508512908763,5281,0.27142971573586616,5057.8025660328021,null,null,null,null,null,null,null,null,null,5.0000000000000898E-2,1.6448536269514629,10289.110615552559,null,null,6500,3.8129133566428557,{"$f":"MATCH(AQ23,$I$36:$I$53,1)","v":12},13,{"$f":"IF(AR23<>AS23,INDEX($J$36:$J$53,AR23),INDEX($J$36:$J$53,AR23-1))","v":0.11124001837845852},{"$f":"INDEX($J$36:$J$53,AS23)","v":8.104881588039603E-2},{"$f":"IF(AR23<>AS23,INDEX($I$36:$I$53,AR23),INDEX($I$36:$I$53,AR23-1))","v":3.75},{"$f":"INDEX($I$36:$I$53,AS23)","v":3.8499999999999996},9.2245719476085647E-2]
[21,1956,2986,3.4750898033890065,8000,3,4.4776119402985072E-2,0.88059701492537312,7500,7.375788648693847E-2,0.87565946599522848,null,null,null,null,null,null,null,null,null,null,21,0.30882352941176472,0.49918784205087674,5057,0.29420261364366995,4922.2648141177997,null,null,null,null,null,null,null,null,null,0.02,2.0537489106318221,13386.400341926223,null,null,7500,3.8750612633917001,{"$f":"MATCH(AQ24,$I$36:$I$53,1)","v":13},14,{"$f":"IF(AR24<>AS24,INDEX($J$36:$J$53,AR24),INDEX($J$36:$J$53,AR24-1))","v":8.104881588039603E-2},{"$f":"INDEX($J$36:$J$53,AS24)","v":5.1956390333038574E-2},{"$f":"IF(AR24<>AS24,INDEX($I$36:$I$53,AR24),INDEX($I$36:$I$53,AR24-1))","v":3.8499999999999996},{"$f":"INDEX($I$36:$I$53,AS24)","v":3.95},7.375788648693847E-2]
[22,1957,6849,3.8356271662098975,9000,2,2.9850746268656716E-2,0.91044776119402981,8500,5.7943924046454279E-2,0.91117741971251542,null,null,null,null,null,null,null,null,null,null,22,0.3235294117647059,0.45785193101249527,4700,0.33454720897600954,4793.0461843756693,null,null,null,null,null,null,null,null,null,0.01,2.3263478740408408,15953.465842801388,null,null,8500,3.9294189257142929,{"$f":"MATCH(AQ25,$I$36:$I$53,1)","v":13},14,{"$f":"IF(AR25<>AS25,INDEX($J$36:$J$53,AR25),INDEX($J$36:$J$53,AR25-1))","v":8.104881588039603E-2},{"$f":"INDEX($J$36:$J$53,AS25)","v":5.1956390333038574E-2},{"$f":"IF(AR25<>AS25,INDEX($I$36:$I$53,AR25),INDEX($I$36:$I$53,AR25-1))","v":3.8499999999999996},{"$f":"INDEX($I$36:$I$53,AS25)","v":3.95},5.7943924046454279E-2]
[23,1958,1549,3.1900514177592059,10000,2,2.9850746268656716E-2,0.94029850746268651,9500,4.5676537501029325E-2,0.93585337044987327,null,null,null,null,null,null,null,null,null,null,23,0.33823529411764708,0.41728413938902159,4539,0.35448817549421163,4669.5275457810721,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9500,3.9777236052888476,{"$f":"MATCH(AQ26,$I$36:$I$53,1)","v":14},15,{"$f":"IF(AR26<>AS26,INDEX($J$36:$J$53,AR26),INDEX($J$36:$J$53,AR26-1))","v":5.1956390333038574E-2},{"$f":"INDEX($J$36:$J$53,AS26)","v":2.930474468096508E-2},{"$f":"IF(AR26<>AS26,INDEX($I$36:$I$53,AR26),INDEX($I$36:$I$53,AR26-1))","v":3.95},{"$f":"INDEX($I$36:$I$53,AS26)","v":4.05},4.5676537501029325E-2]
[24,1959,4051,3.6075622431835881,11000,2,2.9850746268656716E-2,0.9701492537313432,10500,3.5830842565521284E-2,0.95316805957622242,null,null,null,null,null,null,null,null,null,null,24,0.35294117647058826,0.37739194382855357,4461,0.36455957047743215,4551.170421731319,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10500,4.0211892990699383,{"$f":"MATCH(AQ27,$I$36:$I$53,1)","v":14},15,{"$f":"IF(AR27<>AS27,INDEX($J$36:$J$53,AR27),INDEX($J$36:$J$53,AR27-1))","v":5.1956390333038574E-2},{"$f":"INDEX($J$36:$J$53,AS27)","v":2.930474468096508E-2},{"$f":"IF(AR27<>AS27,INDEX($I$36:$I$53,AR27),INDEX($I$36:$I$53,AR27-1))","v":3.95},{"$f":"INDEX($I$36:$I$53,AS27)","v":4.05},3.5830842565521284E-2]
[25,1960,975,2.989004615698537,12000,0,0,0.9701492537313432,11500,2.7725519485790447E-2,0.96544761425342873,null,null,null,null,null,null,null,null,null,null,25,0.36764705882352944,0.33809165680420711,4355,0.37868720947248191,4437.5033398117776,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11500,4.0606978403536118,{"$f":"MATCH(AQ28,$I$36:$I$53,1)","v":15},16,{"$f":"IF(AR28<>AS28,INDEX($J$36:$J$53,AR28),INDEX($J$36:$J$53,AR28-1))","v":2.930474468096508E-2},{"$f":"INDEX($J$36:$J$53,AS28)","v":1.4542651183828173E-2},{"$f":"IF(AR28<>AS28,INDEX($I$36:$I$53,AR28),INDEX($I$36:$I$53,AR28-1))","v":4.05},{"$f":"INDEX($I$36:$I$53,AS28)","v":4.1500000000000004},2.7725519485790447E-2]
[26,1961,1260,3.1003705451175629,13000,1,1.4925373134328358E-2,0.9850746268656716,12500,2.2379844701196742E-2,0.97425031205533763,null,null,null,null,null,null,null,null,null,null,26,0.38235294117647056,0.29930691046566715,4294,0.38705145788943884,4328.1109062932883,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12500,4.0969100130080562,{"$f":"MATCH(AQ29,$I$36:$I$53,1)","v":15},16,{"$f":"IF(AR29<>AS29,INDEX($J$36:$J$53,AR29),INDEX($J$36:$J$53,AR29-1))","v":2.930474468096508E-2},{"$f":"INDEX($J$36:$J$53,AS29)","v":1.4542651183828173E-2},{"$f":"IF(AR29<>AS29,INDEX($I$36:$I$53,AR29),INDEX($I$36:$I$53,AR29-1))","v":4.05},{"$f":"INDEX($I$36:$I$53,AS29)","v":4.1500000000000004},2.2379844701196742E-2]
[27,1962,4355,3.6389881593436821,14000,0,0,0.9850746268656716,13500,1.7445798665958738E-2,0.98062723966000931,null,null,null,null,null,null,null,null,null,null,27,0.39705882352941174,0.26096740040145311,4214,0.39828435240965365,4222.6249755308763,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13500,4.1303337684950066,{"$f":"MATCH(AQ30,$I$36:$I$53,1)","v":15},16,{"$f":"IF(AR30<>AS30,INDEX($J$36:$J$53,AR30),INDEX($J$36:$J$53,AR30-1))","v":2.930474468096508E-2},{"$f":"INDEX($J$36:$J$53,AS30)","v":1.4542651183828173E-2},{"$f":"IF(AR30<>AS30,INDEX($I$36:$I$53,AR30),INDEX($I$36:$I$53,AR30-1))","v":4.05},{"$f":"INDEX($I$36:$I$53,AS30)","v":4.1500000000000004},1.7445798665958738E-2]
[28,1963,9622,3.9832653525665456,15000,1,1.4925373134328358E-2,1,14500,1.2864496065144573E-2,0.98529379720701338,null,null,null,null,null,null,null,null,null,null,28,0.41176470588235292,0.22300783094036683,4182,0.40286203340661875,4120.7174470423315,null,null,0.98,null,null,null,null,null,null,null,null,null,null,null,14500,4.1613680022349753,{"$f":"MATCH(AQ31,$I$36:$I$53,1)","v":16},{"$f":"IF(AR31<16,AR31+1,AR31)","v":16},{"$f":"IF(AR31<>AS31,INDEX($J$36:$J$53,AR31),INDEX($J$36:$J$53,AR31-1))","v":2.930474468096508E-2},{"$f":"INDEX($J$36:$J$53,AS31)","v":1.4542651183828173E-2},{"$f":"IF(AR31<>AS31,INDEX($I$36:$I$53,AR31),INDEX($I$36:$I$53,AR31-1))","v":4.05},{"$f":"INDEX($I$36:$I$53,AS31)","v":4.1500000000000004},1.2864496065144573E-2]
[29,1964,5299,3.7241939195143297,16000,0,0,1,15500,8.5888481909467233E-3,0.98874178852719252,null,null,null,null,null,null,null,null,null,null,29,0.4264705882352941,0.18536701728959662,4145,0.40821566295819367,4022.094339338722,null,null,0.95,null,null,null,null,null,null,null,null,null,null,null,15500,4.1903316981702918,{"$f":"MATCH(AQ32,$I$36:$I$53,1)","v":16},{"$f":"IF(AR32<16,AR32+1,AR32)","v":16},{"$f":"IF(AR32<>AS32,INDEX($J$36:$J$53,AR32),INDEX($J$36:$J$53,AR32-1))","v":2.930474468096508E-2},{"$f":"INDEX($J$36:$J$53,AS32)","v":1.4542651183828173E-2},{"$f":"IF(AR32<>AS32,INDEX($I$36:$I$53,AR32),INDEX($I$36:$I$53,AR32-1))","v":4.05},{"$f":"INDEX($I$36:$I$53,AS32)","v":4.1500000000000004},8.5888481909467233E-3]
[30,1965,7093,3.8508299598485309,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,0.44117647058823528,0.14798710972583889,4051,0.42211175626260367,3926.490873848531,null,null,0.9]
[31,1966,14367,4.1573660917622703,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,0.42331406726447718,3833.667364076874,null,null,0.85]
[32,1967,2626,3.4192947217534604,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,0.44313078865876965,3743.4057509551726,null,null,0.8]
[33,1968,1898,3.2782962080912736,2.7,{"$f":"FREQUENCY(D4:D70,E36:E53)","v":0},{"$f":"F36/SUM($F$36:$F$53)","v":0},{"$f":"G36","v":0},{"$f":"AVERAGE(E35:E36)","v":2.6500000000000004},{"$f":"NORMDIST(I36,$G$9,$G$10,FALSE)*0.1","v":7.7581775983134209E-4},{"$f":"NORMDIST(I36,$G$9,$G$10,TRUE)","v":6.2004151642305676E-4},{"$f":"10^I36","v":446.6835921509637},null,null,null,null,null,null,null,null,null,33,0.48529411764705882,3.6870532662080152E-2,3552,0.50309635580185597,3655.506659627491,null,null,0.75]
[34,1969,8273,3.9176630243273749,2.8,0,{"$f":"F37/SUM($F$36:$F$53)","v":0},{"$f":"H36+G37","v":0},{"$f":"AVERAGE(E36:E37)","v":2.75},{"$f":"NORMDIST(I37,$G$9,$G$10,FALSE)*0.1","v":2.3108508791689218E-3},{"$f":"NORMDIST(I37,$G$9,$G$10,TRUE)","v":2.0412602807524964E-3},{"$f":"10^I37","v":562.34132519034927},null,null,null,null,null,null,null,null,null,34,0.5,0,3419,0.52673297506537731,3569.7868788000201,null,null,0.7]
[35,1970,5646,3.7517408738109004,2.9,1,{"$f":"F38/SUM($F$36:$F$53)","v":1.4925373134328358E-2},{"$f":"H37+G38","v":1.4925373134328358E-2},2.8499999999999996,6.0560687866104716E-3,5.9696794794941947E-3,707.94578438413748,null,null,null,null,null,null,null,null,null,35,0.51470588235294112,-3.6870532662080152E-2,3354,0.53859104640008315,3486.0771834433981,null,null,0.65,null,null,null,null,null,null,null,null,null,0,16000]
[36,1971,3552,3.5504729571065634,3,2,{"$f":"F39/SUM($F$36:$F$53)","v":2.9850746268656716E-2},4.4776119402985072E-2,2.95,1.3964209381503513E-2,1.55360150008368E-2,891.25093813374656,null,null,null,null,null,null,null,null,null,36,0.52941176470588236,-7.3791273808272689E-2,3316,0.54561485406310584,3404.2204366441301,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,3.3098430047160705,3.1,1,{"$f":"F40/SUM($F$36:$F$53)","v":1.4925373134328358E-2},5.9701492537313432E-2,3.05,2.8330130768037306E-2,3.6059476542132415E-2,1122.0184543019636,null,null,null,null,null,null,null,null,null,37,0.54411764705882348,-0.11081291229915685,3278,0.5527051266193983,3324.0699178712712,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,3.4313637641589874,3.2,4,{"$f":"F41/SUM($F$36:$F$53)","v":5.9701492537313432E-2},0.11940298507462686,3.1500000000000004,5.0569362722227722E-2,7.4851135309157893E-2,1412.537544622757,null,null,null,null,null,null,null,null,null,38,0.55882352941176472,-0.14798710972583889,3270,0.55420620224858119,3245.4878336600914,null,null,0.500000000000001,null,null,null,null,null,null,null,null,0.75,-0.67448975019608193,-0.67448975019608193,0]
[39,1974,1545,3.1889284837608534,3.3,4,{"$f":"F42/SUM($F$36:$F$53)","v":5.9701492537313432E-2},0.17910447761194029,3.25,7.9420580404265098E-2,0.13944830538376798,1778.2794100389244,null,null,null,null,null,null,null,null,null,39,0.57352941176470584,-0.18536701728959662,3177,0.57186632387236047,3168.3439732912684,null,null,0.45000000000000101,null,null,null,null,null,null,null,null,0.5,0,0,0]
[40,1975,2064,3.3147096929551738,3.4,6,{"$f":"F43/SUM($F$36:$F$53)","v":8.9552238805970144E-2},0.26865671641791045,3.3499999999999996,0.10974514252257073,0.23422025583040657,2238.7211385683395,null,null,null,null,null,null,null,null,null,40,0.58823529411764708,-0.22300783094036683,3165,0.57417275936854861,3092.5144768660175,null,null,0.40000000000000102,null,null,null,null,null,null,null,null,0.25,0.67448975019608193,0.67448975019608193,0]
[41,1976,1851,3.2674064187529042,3.5,9,{"$f":"F44/SUM($F$36:$F$53)","v":0.13432835820895522},0.40298507462686567,3.45,0.13342715673392461,0.35672141488537423,2818.3829312644561,null,null,null,null,null,null,null,null,null,41,0.6029411764705882,-0.26096740040145278,2986,0.60929010091271929,3017.8806865155402,null,null,0.35000000000000098,null,null,null,null,null,null,null,null,0.1,1.2815515655446006,1.2815515655446006,0]
[42,1977,6610,3.8202014594856402,3.6,9,{"$f":"F45/SUM($F$36:$F$53)","v":0.13432835820895522},0.53731343283582089,3.55,0.14272821374701927,0.49622859589092788,3548.1338923357539,null,null,null,null,null,null,null,null,null,42,0.61764705882352944,-0.29930691046566715,2864,0.63393291189529899,2944.3280534986461,null,null,0.30000000000000099,null,null,null,null,null,null,null,null,0.05,1.6448536269514715,1.6448536269514715,0]
[43,1978,1211,3.0831441431430524,3.7,10,{"$f":"F46/SUM($F$36:$F$53)","v":0.14925373134328357},0.68656716417910446,3.6500000000000004,0.13433281141470796,0.63620340938950315,4466.8359215096425,null,null,null,null,null,null,null,null,null,43,0.63235294117647056,-0.33809165680420711,2845,0.63781728790608183,2871.7450746962822,null,null,0.250000000000001,null,null,null,null,null,null,null,null,0.02,2.0537489106318221,2.0537489106318221,0]
[44,1979,2712,3.4332896851950259,3.8,8,{"$f":"F47/SUM($F$36:$F$53)","v":0.11940298507462686},0.80597014925373134,3.75,0.11124001837845852,0.75994059289519178,5623.4132519034993,null,null,null,null,null,null,null,null,null,44,0.6470588235294118,-0.37739194382855401,2828,0.64130274644503105,2800.022231469206,null,null,0.20000000000000101,null,null,null,null,null,null,null,null,0.01,2.3263478740408408,2.3263478740408408,0]
[45,1980,2828,3.4514794051248616,3.9,5,{"$f":"F48/SUM($F$36:$F$53)","v":7.4626865671641784E-2},0.88059701492537312,3.8499999999999996,8.104881588039603E-2,0.85631164876584731,7079.4578438413828,null,null,null,null,null,null,null,null,null,45,0.66176470588235292,-0.41728413938902159,2755,0.65637116445061494,2729.0509018554685,null,null,0.15000000000000099]
[46,1981,3914,3.5926208213219826,4,4,{"$f":"F49/SUM($F$36:$F$53)","v":5.9701492537313432E-2},{"$f":"H48+G49","v":0.94029850746268651},{"$f":"AVERAGE(E48:E49)","v":3.95},{"$f":"NORMDIST(I49,$G$9,$G$10,FALSE)*0.1","v":5.1956390333038574E-2},{"$f":"NORMDIST(I49,$G$9,$G$10,TRUE)","v":0.9224399226716139},{"$f":"10^I49","v":8912.5093813374679},null,null,null,null,null,null,null,null,null,46,0.67647058823529416,-0.45785193101249527,2712,0.66531864136813257,2658.7222133584969,null,null,0.100000000000001]
[47,1982,10694,4.0291401797643216,4.0999999999999996,3,4.4776119402985072E-2,0.9850746268656716,4.05,2.930474468096508E-2,0.96241774334295915,11220.184543019639,null,null,null,null,null,null,null,null,null,47,0.69117647058823528,-0.49918784205087674,2700,0.66782434108428279,2588.925797633407,null,null,5.0000000000000898E-2]
[48,1983,2864,3.4569730136358179,4.2,1,1.4925373134328358E-2,1,4.1500000000000004,1.4542651183828173E-2,0.98371083233848067,14125.375446227561,null,null,null,null,null,null,null,null,null,48,0.70588235294117652,-0.54139508512908796,2629,0.68272062831036195,2519.548399463984,null,null,0.02]
[49,1984,2021,3.3055663135153042,4.3,0,0,1,4.25,6.3497394798855316E-3,0.9937025746995527,17782.794100389234,null,null,null,null,null,null,null,null,null,49,0.72058823529411764,-0.58458985705947353,2626,0.68335252905651189,2450.4722793668802,null,null,0.01]
[50,1985,9478,3.9767167043633824,4.4000000000000004,0,0,1,4.3499999999999996,2.4393544020978233E-3,0.99783325245793131,22387.211385683382,null,null,null,null,null,null,null,null,null,50,0.73529411764705888,-0.62890421763218995,2488,0.71259241187442657,2381.5733301534096]
[51,1986,1556,3.1920095926536702,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,51,0.75,-0.67448975019608193,2441,0.72260838527068461,2312.7187999900184]
[52,1987,3354,3.525563058270067,null,{"$f":"SUM(F36:F53)","v":67},{"$f":"SUM(G36:G53)","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,52,0.76470588235294112,-0.72152228398234308,2220,0.76976319213500333,2243.7644734151072]
[53,1988,2488,3.3958503760187813,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,53,0.77941176470588236,-0.77020808187547585,2064,0.80269345642235745,2174.5511000584661]
[54,1989,4700,3.6720978579357175,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,54,0.79411764705882348,-0.82079208833238049,2041,0.80749260209857221,2104.8997662449892]
[55,1990,7905,3.8979018742682277,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,55,0.80882352941176472,-0.87356913461508812,2021,0.81165047891612041,2034.6057562804481]
[56,1991,4145,3.6175245348862926,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,56,0.82352941176470584,-0.92889949164726959,1908,0.83482205049107505,1963.4302108731335]
[57,1992,5665,3.7531999141994161,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,57,0.83823529411764708,-0.98723099199017461,1898,0.83684227071058226,1891.0884915670804]
[58,1993,3165,3.500373714353374,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,58,0.8529411764705882,-1.0491313979639725,1851,0.84626004298085444,1817.2334713099051]
[59,1994,4043,3.6067037413336744,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,59,0.86764705882352944,-1.1153373577337866,1659,0.88311150563106477,1741.4307285694988]
[60,1995,7391,3.8687032022785366,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,60,0.88235294117647056,-1.186831432755818,1556,0.90152342799090246,1663.1202628302515]
[61,1996,1908,3.2805783703680764,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,61,0.8970588235294118,-1.2649692448841479,1549,0.90273375739445316,1581.5545861402861]
[62,1997,4182,3.621384028481653,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,62,0.91176470588235292,-1.3517022399306602,1545,0.90342288926372094,1495.6926815427164]
[63,1998,2845,3.4540822707310901,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,63,0.92647058823529416,-1.4499989087404506,1260,0.94718480196655308,1404.0045394059998]
[64,1999,2220,3.3463529744506388,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,64,0.94117647058823528,-1.5647264713617985,1211,0.95350017956222988,1304.0739837631472]
[65,2000,5689,3.7550359337677714,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,65,0.95588235294117652,-1.7047809048894009,992,0.97669011861859745,1191.6730158786211]
[66,2001,4214,{"$f":"LOG(C69)","v":3.6246945312720813},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":0.97813122335389224},{"$f":"10^_xlfn.NORM.INV(1-W69,$G$9,$G$10)","v":1058.0969226564168}]
[67,2002,2755,3.4401216031878037,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,67,0.98529411764705888,-2.1779230690821856,746,0.99250407825047759,878.84881201379119]