{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Input-Output","Calculations","Chart1"],"not_rendered":{"charts":3,"images":0,"macros":1,"external_links":0,"defined_names":58,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"Chart1","index":2,"reason":"not_a_worksheet"}],"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":"Input-Output","index":0,"n_rows":207,"n_cols":9,"rows_kept":207,"cut":false,"hidden":false,"merged":[]}
["Triangular-distribution fitting spreadsheet. Enter you data in column B and click the \"Solve\" button to fit the data using least-squares optimization"]
["Input your data into column B (in any order)  and Click the \"Solve Button\""]
["NOTE: The solver on this spreadsheet is constrained so that the Min & Max are within on the range 1<= X <= 20",null,null,null,null,null,"NOTE: The solver must be installed"]
["The solver minimizes the sum of the squared value of deviations from the input data",null,null,null,null,null,"This can be done using the Add-Ins Menu"]
["The solve-button code uses up to 200 data values"]
[null,"INPUT"]
["Index","Your Data"]
[1,1.7004575980678494,null,null,"Input Data","OUTPUT:","OUTPUT (Rounded):"]
[2,1.863415112485596,null,"Sum:",{"$f":"SUM(B8:B207)","v":50.425617909785252},null,"Min","MPV","Max"]
[3,1.871321727422973,null,"a) Minimum",{"$f":"MIN(B8:B207)","v":1.7004575980678494},1.8298906516604829,{"$f":"ROUND(F10,3)","v":1.83},{"$f":"ROUND(F11,3)","v":1.83},{"$f":"ROUND(F12,3)","v":3.5529999999999999}]
[4,1.9700768774894997,null,"b) Most Probable Value (MPV)",{"$f":"(3*AVERAGE(B8:B207))-(MIN(B8:B207)+MAX(B8:B207))","v":2.3803338443970539},1.8298906516604829]
[5,2.0051658464289566,null,"d) Maximum",{"$f":"MAX(B8:B207)","v":3.1228682589329897},3.5532074034087637]
[6,2.1114442945082232]
[7,2.211734849247931,null,null,"Data","Fit Distribution"]
[8,2.2462374471566422,null,"Average",{"$f":"ROUND(AVERAGE(B8:B207),Calculations!F11)","v":2.4},{"$f":"ROUND(AVERAGE(Calculations!L3:L202),Calculations!F11)","v":2.4}]
[9,2.298336806641915,null,"Standard Deviation",{"$f":"ROUND(STDEV(B8:B207),Calculations!F11)","v":0.42},{"$f":"ROUND(STDEV(Calculations!L3:L202),Calculations!F11)","v":0.41}]
[10,2.3142977826273805,null,"Percentile"]
[11,2.3178478153358619,null,"1st",{"$f":"ROUND(PERCENTILE(B8:B207,0.01),Calculations!F11)","v":1.73},{"$f":"ROUND(PERCENTILE(Calculations!L3:L202,0.01),Calculations!F11)","v":1.86}]
[12,2.3199377886846997,null,"5th",{"$f":"ROUND(PERCENTILE(B8:B207,0.05),Calculations!F11)","v":1.86},{"$f":"ROUND(PERCENTILE(Calculations!L3:L202,0.05),Calculations!F11)","v":1.9}]
[13,2.4686589991851058,null,"10th",{"$f":"ROUND(PERCENTILE(B8:B207,0.1),Calculations!F11)","v":1.87},{"$f":"ROUND(PERCENTILE(Calculations!L3:L202,0.1),Calculations!F11)","v":1.94}]
[14,2.5065307321631249,null,"25th",{"$f":"ROUND(PERCENTILE(B8:B207,0.25),Calculations!F11)","v":2.11},{"$f":"ROUND(PERCENTILE(Calculations!L3:L202,0.25),Calculations!F11)","v":2.0699999999999998}]
[15,2.5238889189982423,null,"50th",{"$f":"ROUND(PERCENTILE(B8:B207,0.5),Calculations!F11)","v":2.3199999999999998},{"$f":"ROUND(PERCENTILE(Calculations!L3:L202,0.5),Calculations!F11)","v":2.33}]
[16,2.8374835366905091,null,"75th",{"$f":"ROUND(PERCENTILE(B8:B207,0.75),Calculations!F11)","v":2.84},{"$f":"ROUND(PERCENTILE(Calculations!L3:L202,0.75),Calculations!F11)","v":2.67}]
[17,2.8958236651949902,null,"90th",{"$f":"ROUND(PERCENTILE(B8:B207,0.9),Calculations!F11)","v":2.93},{"$f":"ROUND(PERCENTILE(Calculations!L3:L202,0.9),Calculations!F11)","v":2.95}]
[18,2.9192992070561092,null,"95th",{"$f":"ROUND(PERCENTILE(B8:B207,0.95),Calculations!F11)","v":2.99},{"$f":"ROUND(PERCENTILE(Calculations!L3:L202,0.95),Calculations!F11)","v":3.08}]
[19,2.9340225361837691,null,"99th",{"$f":"ROUND(PERCENTILE(B8:B207,0.99),Calculations!F11)","v":3.1},{"$f":"ROUND(PERCENTILE(Calculations!L3:L202,0.99),Calculations!F11)","v":3.23}]
[20,2.9867681092828939]
[21,3.1228682589329897]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]
[32]
[33]
[34]
[35]
[36]
[37]
[38]
[39]
[40]
[41]
[42]
[43]
[44]
[45]
[46]
[47]
[48]
[49]
[50]
[51]
[52]
[53]
[54]
[55]
[56]
[57]
[58]
[59]
[60]
[61]
[62]
[63]
[64]
[65]
[66]
[67]
[68]
[69]
[70]
[71]
[72]
[73]
[74]
[75]
[76]
[77]
[78]
[79]
[80]
[81]
[82]
[83]
[84]
[85]
[86]
[87]
[88]
[89]
[90]
[91]
[92]
[93]
[94]
[95]
[96]
[97]
[98]
[99]
[100]
[101]
[102]
[103]
[104]
[105]
[106]
[107]
[108]
[109]
[110]
[111]
[112]
[113]
[114]
[115]
[116]
[117]
[118]
[119]
[120]
[121]
[122]
[123]
[124]
[125]
[126]
[127]
[128]
[129]
[130]
[131]
[132]
[133]
[134]
[135]
[136]
[137]
[138]
[139]
[140]
[141]
[142]
[143]
[144]
[145]
[146]
[147]
[148]
[149]
[150]
[151]
[152]
[153]
[154]
[155]
[156]
[157]
[158]
[159]
[160]
[161]
[162]
[163]
[164]
[165]
[166]
[167]
[168]
[169]
[170]
[171]
[172]
[173]
[174]
[175]
[176]
[177]
[178]
[179]
[180]
[181]
[182]
[183]
[184]
[185]
[186]
[187]
[188]
[189]
[190]
[191]
[192]
[193]
[194]
[195]
[196]
[197]
[198]
[199]
[200]

{"sheet":"Calculations","index":1,"n_rows":202,"n_cols":25,"rows_kept":202,"cut":false,"hidden":false,"merged":[]}
[null,"Count",{"$f":"COUNT(B3:B202)","v":21},null,"Data Min:",{"$f":"MIN('Input-Output'!B8:B207)","v":1.7004575980678494},null,null,null,null,null,null,"Sum",{"$f":"AVERAGE(O2:O202)","v":6.7872090205755006E-2},{"$f":"ABS(AVERAGE(O3:O202))","v":6.7872090205755006E-2},null,{"$f":"SUM(Q3:Q23)","v":0.14649156916223882},null,"Graph Line:","Percentile","P","Trapeziodal Value","A","B","C"]
["Index","Your Data","Percentile",null,"Calculate",null,null,null,"A","B","C","Value",null,"Residual","Abs Residual",null,"Squared Residual",null,null,0.1,{"$f":"T2/100","v":1E-3},{"$f":"IF((F$8*(F$4-F$3))>=U2,W2,IF((1-((F$8)*(F$6-F$5)))>=U2,X2,Y2))","v":1.8307525255587256},{"$f":"IF(ISNUMBER(U2)=TRUE,(F$3+SQRT((2*(F$4-F$3))/F$7)*SQRT(U2)),\"\")","v":1.8298906516604829},{"$f":"IF(ISNUMBER(U2)=TRUE,(((F$3+F$4)/2)+(U2/F$7)),\"\")","v":1.830752310036357},{"$f":"IF(ISNUMBER(U2)=TRUE,(F$6-SQRT((2*(F$6-F$5))/F$7)*SQRT(1-U2)),\"\")","v":1.8307525255587256}]
[1,1.7004575980678494,{"$f":"IF(ISBLANK(B3)=FALSE,(((RANK(B3,B$3:B$207,1)+((COUNT(B$3:B$207)+1-RANK(B3,B$3:B$207,1)-RANK(B3,B$3:B$207,0))/2))-0.4)/(C$1+0.2)),\"\")","v":2.8301886792452831E-2},{"$f":"IF(ISNUMBER(C3)=TRUE,C3*100,\"\")","v":2.8301886792452833},"a) Minimum",1.8298906516604829,{"$f":"F3","v":1.8298906516604829},null,{"$f":"IF(ISNUMBER(C3)=TRUE,(F$3+SQRT((2*(F$4-F$3))/F$7)*SQRT(C3)),\"\")","v":1.8298906516604829},{"$f":"IF(ISNUMBER(C3)=TRUE,(((F$3+F$4)/2)+(C3/F$7)),\"\")","v":1.8542772094682416},{"$f":"IF(ISNUMBER(C3)=TRUE,(F$6-SQRT((2*(F$6-F$5))/F$7)*SQRT(1-C3)),\"\")","v":1.8544522416267402},{"$f":"IF((F$8*(F$4-F$3))>=C3,I3,IF((1-((F$8)*(F$6-F$5)))>=C3,J3,K3))","v":1.8544522416267402},null,{"$f":"IF(ISNUMBER(B3)=TRUE,L3-B3,\"\")","v":0.15399464355889081},{"$f":"IF(ISNUMBER(B3)=TRUE,ABS(N3),\"\")","v":0.15399464355889081},null,{"$f":"IF(ISNUMBER(N3)=TRUE,N3^2,\"\")","v":2.3714350244829832E-2},null,null,0.5,5.0000000000000001E-3,{"$f":"IF((F$8*(F$4-F$3))>=U3,W3,IF((1-((F$8)*(F$6-F$5)))>=U3,X3,Y3))","v":1.834204342410336},{"$f":"IF(ISNUMBER(U3)=TRUE,(F$3+SQRT((2*(F$4-F$3))/F$7)*SQRT(U3)),\"\")","v":1.8298906516604829},{"$f":"IF(ISNUMBER(U3)=TRUE,(((F$3+F$4)/2)+(U3/F$7)),\"\")","v":1.8341989435398536},{"$f":"IF(ISNUMBER(U3)=TRUE,(F$6-SQRT((2*(F$6-F$5))/F$7)*SQRT(1-U3)),\"\")","v":1.834204342410336}]
[2,1.863415112485596,{"$f":"IF(ISBLANK(B4)=FALSE,(((RANK(B4,B$3:B$207,1)+((COUNT(B$3:B$207)+1-RANK(B4,B$3:B$207,1)-RANK(B4,B$3:B$207,0))/2))-0.4)/(C$1+0.2)),\"\")","v":7.5471698113207558E-2},7.5471698113207557,"b) Lower Bound of the Most Probable Value",1.8298906516604829,{"$f":"F4","v":1.8298906516604829},null,1.8298906516604829,1.8949214724811727,1.8961970772321963,1.8961970772321963,null,3.2781964746600334E-2,3.2781964746600334E-2,null,{"$f":"IF(ISNUMBER(N4)=TRUE,N4^2,\"\")","v":1.0746572126473471E-3},null,null,1,0.01,1.8385288852638366,{"$f":"IF(ISNUMBER(U4)=TRUE,(F$3+SQRT((2*(F$4-F$3))/F$7)*SQRT(U4)),\"\")","v":1.8298906516604829},{"$f":"IF(ISNUMBER(U4)=TRUE,(((F$3+F$4)/2)+(U4/F$7)),\"\")","v":1.8385072354192242},{"$f":"IF(ISNUMBER(U4)=TRUE,(F$6-SQRT((2*(F$6-F$5))/F$7)*SQRT(1-U4)),\"\")","v":1.8385288852638366}]
[3,1.871321727422973,0.12264150943396228,12.264150943396228,"c) Upper Bound of the Most Probable Value",1.8298906516604831,{"$f":"F6","v":3.5532074034087637},null,1.8298906516604829,1.9355657354941038,1.9390211246817763,1.9390211246817763,null,6.7699397258803362E-2,6.7699397258803362E-2,null,4.5832083892052723E-3,null,null,2,0.02,1.8472108575977468,1.8298906516604829,1.8471238191779658,1.8472108575977468]
[4,1.9700768774894997,0.169811320754717,16.981132075471699,"d) Maximum",3.5532074034087637,null,null,1.8298906516604829,1.9762099985070352,1.9830126817881664,1.9830126817881664,null,1.2935804298666698E-2,1.2935804298666698E-2,null,1.6733503285340382E-4,null,null,3,0.03,1.8559372398665661,1.8298906516604829,1.8557404029367071,1.8559372398665661]
[5,2.0051658464289566,0.21698113207547168,21.698113207547166,"dh",{"$f":"2/((F6-F3)+(F5-F4))","v":1.1605527526910115},null,null,1.8298906516604829,2.0168542615199661,2.0282727867186283,2.0282727867186283,null,2.3106940289671751E-2,2.3106940289671751E-2,null,5.3393068955045564E-4,null,null,4,0.04,1.8647087206192285,1.8298906516604829,1.8643569866954486,1.8647087206192285]
[6,2.1114442945082232,0.26415094339622641,26.415094339622641,"dh/2",{"$f":"F7/2","v":0.58027637634550577},null,null,1.8298906516604829,2.0574985245328974,2.0749179505090294,2.0749179505090294,null,-3.6526343999193855E-2,3.6526343999193855E-2,null,1.334173805947445E-3,null,null,5,0.05,1.8735260063832941,1.8298906516604829,1.8729735704541899,1.8735260063832941]
[7,2.211734849247931,0.31132075471698112,31.132075471698112,null,null,null,null,1.8298906516604829,2.0981427875458287,2.1230836927007353,2.1230836927007353,null,-8.8651156547195686E-2,8.8651156547195686E-2,null,7.8590275571553958E-3,null,null,6,0.06,1.8823898223291085,1.8298906516604829,1.8815901542129314,1.8823898223291085]
[8,2.2462374471566422,0.35849056603773582,35.849056603773583,null,null,null,null,1.8298906516604829,2.1387870505587596,2.1729291889519802,2.1729291889519802,null,-7.3308258204662025E-2,7.3308258204662025E-2,null,5.3741007210013972E-3,null,null,7,7.0000000000000007E-2,1.8913009129658422,1.8298906516604829,1.8902067379716727,1.8913009129658422]
[9,2.298336806641915,0.40566037735849059,40.566037735849058,"Calculated Rounding Factor",{"$f":"IF(F6=0,3,IF(F3=0,(IF((INT((LOG(ABS(F6/10))*-1))+3)>0,(INT((LOG(ABS(F6/10))*-1))+3),0)),IF((INT((LOG(ABS(F3))*-1))+3)>0,(INT((LOG(ABS(F3))*-1))+3),0)))","v":2},null,null,1.8298906516604829,2.179431313571691,2.2246434905017813,2.2246434905017813,null,-7.3693316140133636E-2,7.3693316140133636E-2,null,5.4307048437296805E-3,null,null,8,0.08,1.9002600428713066,1.8298906516604829,1.8988233217304142,1.9002600428713066]
[10,2.3142977826273805,0.45283018867924529,45.283018867924532,null,null,null,null,{"$f":"IF(ISNUMBER(C12)=TRUE,(F$3+SQRT((2*(F$4-F$3))/F$7)*SQRT(C12)),\"\")","v":1.8298906516604829},{"$f":"IF(ISNUMBER(C12)=TRUE,(((F$3+F$4)/2)+(C12/F$7)),\"\")","v":2.2200755765846218},{"$f":"IF(ISNUMBER(C12)=TRUE,(F$6-SQRT((2*(F$6-F$5))/F$7)*SQRT(1-C12)),\"\")","v":2.2784540186109759},{"$f":"IF((F$8*(F$4-F$3))>=C12,I12,IF((1-((F$8)*(F$6-F$5)))>=C12,J12,K12))","v":2.2784540186109759},null,{"$f":"IF(ISNUMBER(B12)=TRUE,L12-B12,\"\")","v":-3.5843764016404656E-2},{"$f":"IF(ISNUMBER(B12)=TRUE,ABS(N12),\"\")","v":3.5843764016404656E-2},null,1.2847754188637052E-3,null,null,9,0.09,1.9092679974575639,1.8298906516604829,1.9074399054891555,1.9092679974575639]
[11,2.3178478153358619,0.5,50,"1st",{"$f":"'Input-Output'!E18","v":1.73},{"$f":"'Input-Output'!F18","v":1.86},{"$f":"ABS(F13-G13)","v":0.13000000000000012},1.8298906516604829,2.2607198395975532,2.33463844211518,2.33463844211518,null,1.6790626779318085E-2,1.6790626779318085E-2,null,2.8192514764235362E-4,null,null,10,0.1,1.9183255837745061,1.8298906516604829,1.9160564892478971,1.9183255837745061]
[12,2.3199377886846997,0.54716981132075471,54.716981132075468,"5th",{"$f":"'Input-Output'!E19","v":1.86},{"$f":"'Input-Output'!F19","v":1.9},{"$f":"ABS(F14-G14)","v":3.9999999999999813E-2},1.8298906516604829,2.3013641026104841,2.393541746935818,2.393541746935818,null,7.3603958251118318E-2,7.3603958251118318E-2,null,5.4175426702323679E-3,null,null,11,0.11,1.9274336313537281,1.8298906516604829,1.9246730730066384,1.9274336313537281]
[13,2.4686589991851058,0.59433962264150941,59.433962264150942,"10th",{"$f":"'Input-Output'!E20","v":1.87},{"$f":"'Input-Output'!F20","v":1.94},6.999999999999984E-2,1.8298906516604829,2.3420083656234154,2.4556015742617361,2.4556015742617361,null,-1.3057424923369698E-2,1.3057424923369698E-2,null,1.7049634562943617E-4,null,null,12,0.12,1.9365929930951922,1.8298906516604829,1.9332896567653797,1.9365929930951922]
[14,2.5065307321631249,0.64150943396226412,64.15094339622641,"25th",{"$f":"'Input-Output'!E21","v":2.11},{"$f":"'Input-Output'!F21","v":2.0699999999999998},4.0000000000000036E-2,1.8298906516604829,2.3826526286363467,2.5213873233791881,2.5213873233791881,null,1.4856591216063197E-2,1.4856591216063197E-2,null,2.2071830256120616E-4,null,null,13,0.13,1.9458045461993667,1.8298906516604829,1.9419062405241212,1.9458045461993667]
[15,2.5238889189982423,0.68867924528301883,68.867924528301884,"50th",{"$f":"'Input-Output'!E22","v":2.3199999999999998},{"$f":"'Input-Output'!F22","v":2.33},1.0000000000000231E-2,1.8298906516604829,2.4232968916492776,2.5916634372132785,2.5916634372132785,null,6.7774518215036217E-2,6.7774518215036217E-2,null,4.593385319280276E-3,null,null,14,0.14000000000000001,1.9550691931477202,1.8298906516604829,1.9505228242828625,1.9550691931477202]
[16,2.8374835366905091,0.73584905660377364,73.584905660377359,"75th",{"$f":"'Input-Output'!E23","v":2.84},{"$f":"'Input-Output'!F23","v":2.67},0.16999999999999993,1.8298906516604829,2.463941154662209,2.6674981281374421,2.6674981281374421,null,-0.16998540855306699,0.16998540855306699,null,2.8895039120953099E-2,null,null,15,0.15,1.9643878627346791,1.8298906516604829,1.959139408041604,1.9643878627346791]
[17,2.8958236651949902,0.78301886792452835,78.301886792452834,"90th",{"$f":"'Input-Output'!E24","v":2.93},{"$f":"'Input-Output'!F24","v":2.95},2.0000000000000018E-2,1.8298906516604829,2.5045854176751403,2.7504652021533698,2.7504652021533698,null,-0.14535846304162048,0.14535846304162048,null,2.1129082777822147E-2,null,null,16,0.16,1.97376151115438,1.8298906516604829,1.9677559918003453,1.97376151115438]
[18,2.9192992070561092,0.83018867924528317,83.018867924528323,"95th",{"$f":"'Input-Output'!E25","v":2.99},{"$f":"'Input-Output'!F25","v":3.08},8.9999999999999858E-2,1.8298906516604829,2.5452296806880712,2.8430601207616637,2.8430601207616637,null,-7.6239086294445535E-2,7.6239086294445535E-2,null,5.8123982790119133E-3,null,null,17,0.17,1.9831911231458219,1.8298906516604829,1.9763725755590869,1.9831911231458219]
[19,2.9340225361837691,0.87735849056603787,87.735849056603783,"99th",{"$f":"'Input-Output'!E26","v":3.1},{"$f":"'Input-Output'!F26","v":3.23},0.12999999999999989,1.8298906516604829,2.5858739437010025,2.9496982614516885,2.9496982614516885,null,1.5675725267919383E-2,1.5675725267919383E-2,null,2.457283626752862E-4,null,null,18,0.18,1.9926777132003006,1.8298906516604829,1.9849891593178282,1.9926777132003006]
[20,2.9867681092828939,0.92452830188679258,92.452830188679258,null,null,null,null,1.8298906516604829,2.6265182067139339,3.0797758816440304,3.0797758816440304,null,9.3007772361136443E-2,9.3007772361136443E-2,null,8.6504457195809761E-3,null,null,19,0.19,2.002222326835311,1.8298906516604829,1.9936057430765697,2.002222326835311]
[21,3.1228682589329897,0.97169811320754729,97.169811320754732,null,null,null,{"$f":"MAX(H13:H21)","v":0.16999999999999993},1.8298906516604829,2.6671624697268648,3.2632909892905277,3.2632909892905277,null,0.14042273035753805,0.14042273035753805,null,1.9718543201065839E-2,null,null,20,0.2,2.0118260419394494,1.8298906516604829,2.002222326835311,2.0118260419394494]
[22,null,"","",null,null,null,null,"","","","",null,"","",null,null,null,null,21,0.21,2.0214899701932132,1.8298906516604829,2.0108389105940523,2.0214899701932132]
[23,null,"","",null,null,null,null,"","","","",null,"","",null,null,null,null,22,0.22,2.0312152585709953,1.8298906516604829,2.019455494352794,2.0312152585709953]
[24,null,"","",null,null,null,null,"","","","",null,"","",null,null,null,null,23,0.23,2.0410030909300203,1.8298906516604829,2.0280720781115353,2.0410030909300203]
[25,null,"","",null,null,null,null,"","","","",null,"","",null,null,null,null,24,0.24,2.0508546896924584,1.8298906516604829,2.0366886618702766,2.0508546896924584]
[26,null,"","",null,null,null,null,"","","","",null,"","",null,null,null,null,25,0.25,2.0607713176274718,1.8298906516604829,2.0453052456290179,2.0607713176274718]
[27,null,"","",null,null,null,null,"","","","",null,"","",null,null,null,null,26,0.26,2.0707542797405578,1.8298906516604829,2.0539218293877592,2.0707542797405578]
[28,null,"","",null,null,null,null,"","","","",null,"","",null,null,null,null,27,0.27,2.0808049252781884,1.8298906516604829,2.062538413146501,2.0808049252781884]
[29,null,"","",null,null,null,null,"","","","",null,"","",null,null,null,null,28,0.28000000000000003,2.0909246498564635,1.8298906516604829,2.0711549969052423,2.0909246498564635]
[30,null,"","",null,null,null,null,"","","","",null,"","",null,null,null,null,29,0.28999999999999998,2.1011148977232841,1.8298906516604829,2.0797715806639836,2.1011148977232841]
[31,null,"","",null,null,null,null,"","","","",null,"","",null,null,null,null,30,0.3,2.1113771641644301,1.8298906516604829,2.0883881644227249,2.1113771641644301]
[32,null,"","",null,null,null,null,"","","","",null,"","",null,null,null,null,31,0.31,2.1217129980648908,1.8298906516604829,2.0970047481814666,2.1217129980648908]
[33,null,"","",null,null,null,null,"","","","",null,"","",null,null,null,null,32,0.32,2.1321240046378658,1.8298906516604829,2.105621331940208,2.1321240046378658]
[34,null,"","",null,null,null,null,"","","","",null,"","",null,null,null,null,33,0.33,2.1426118483350622,1.8298906516604829,2.1142379156989493,2.1426118483350622]
[35,null,"","",null,null,null,null,"","","","",null,"","",null,null,null,null,34,0.34,2.1531782559532111,1.8298906516604829,2.1228544994576906,2.1531782559532111]
[36,null,"","",null,null,null,null,"","","","",null,"","",null,null,null,null,35,0.35,2.1638250199532374,1.8298906516604829,2.1314710832164323,2.1638250199532374]
[37,null,"","",null,null,null,null,"","","","",null,"","",null,null,null,null,36,0.36,2.1745540020101393,1.8298906516604829,2.1400876669751736,2.1745540020101393]
[38,null,"","",null,null,null,null,"","","","",null,"","",null,null,null,null,37,0.37,2.1853671368134879,1.8298906516604829,2.1487042507339149,2.1853671368134879]
[39,null,"","",null,null,null,null,"","","","",null,"","",null,null,null,null,38,0.38,2.1962664361405215,1.8298906516604829,2.1573208344926562,2.1962664361405215]
[40,null,"","",null,null,null,null,"","","","",null,"","",null,null,null,null,39,0.39,2.2072539932261117,1.8298906516604829,2.1659374182513975,2.2072539932261117]
[41,null,"","",null,null,null,null,"","","","",null,"","",null,null,null,null,40,0.4,2.2183319874564931,1.8298906516604829,2.1745540020101393,2.2183319874564931]
[42,null,"","",null,null,null,null,"","","","",null,"","",null,null,null,null,41,0.41,2.2295026894165586,1.8298906516604829,2.1831705857688806,2.2295026894165586]
[43,null,"","",null,null,null,null,"","","","",null,"","",null,null,null,null,42,0.42,2.240768466323833,1.8298906516604829,2.1917871695276219,2.240768466323833]
[44,null,"","",null,null,null,null,"","","","",null,"","",null,null,null,null,43,0.43,2.2521317878859533,1.8298906516604829,2.2004037532863632,2.2521317878859533]
[45,null,"","",null,null,null,null,"","","","",null,"","",null,null,null,null,44,0.44,2.263595232622718,1.8298906516604829,2.2090203370451049,2.263595232622718]
[46,null,"","",null,null,null,null,"","","","",null,"","",null,null,null,null,45,0.45,2.2751614946985423,1.8298906516604829,2.2176369208038462,2.2751614946985423]
[47,null,"","",null,null,null,null,"","","","",null,"","",null,null,null,null,46,0.46,2.2868333913166121,1.8298906516604829,2.2262535045625875,2.2868333913166121]
[48,null,"","",null,null,null,null,"","","","",null,"","",null,null,null,null,47,0.47,2.2986138707322201,1.8298906516604829,2.2348700883213288,2.2986138707322201]
[49,null,"","",null,null,null,null,"","","","",null,"","",null,null,null,null,48,0.48,2.3105060209498691,1.8298906516604829,2.2434866720800706,2.3105060209498691]
[50,null,"","",null,null,null,null,"","","","",null,"","",null,null,null,null,49,0.49,2.3225130791768347,1.8298906516604829,2.2521032558388119,2.3225130791768347]
[51,null,"","",null,null,null,null,"","","","",null,"","",null,null,null,null,50,0.5,2.33463844211518,1.8298906516604829,2.2607198395975532,2.33463844211518]
[52,null,"","",null,null,null,null,"","","","",null,"","",null,null,null,null,51,0.51,2.3468856771849671,1.8298906516604829,2.2693364233562945,2.3468856771849671]
[53,null,"","",null,null,null,null,"","","","",null,"","",null,null,null,null,52,0.52,2.3592585347837298,1.8298906516604829,2.2779530071150358,2.3592585347837298]
[54,null,"","",null,null,null,null,"","","","",null,"","",null,null,null,null,53,0.53,2.3717609617016349,1.8298906516604829,2.2865695908737775,2.3717609617016349]
[55,null,"","",null,null,null,null,"","","","",null,"","",null,null,null,null,54,0.54,2.3843971158283228,1.8298906516604829,2.2951861746325188,2.3843971158283228]
[56,null,"","",null,null,null,null,"","","","",null,"","",null,null,null,null,55,0.55000000000000004,2.3971713823067784,1.8298906516604829,2.3038027583912601,2.3971713823067784]
[57,null,"","",null,null,null,null,"","","","",null,"","",null,null,null,null,56,0.56000000000000005,2.4100883913121454,1.8298906516604829,2.3124193421500014,2.4100883913121454]
[58,null,"","",null,null,null,null,"","","","",null,"","",null,null,null,null,57,0.56999999999999995,2.4231530376598474,1.8298906516604829,2.3210359259087427,2.4231530376598474]
[59,null,"","",null,null,null,null,"","","","",null,"","",null,null,null,null,58,0.57999999999999996,2.4363705024784519,1.8298906516604829,2.3296525096674845,2.4363705024784519]
[60,null,"","",null,null,null,null,"","","","",null,"","",null,null,null,null,59,0.59,2.4497462772194174,1.8298906516604829,2.3382690934262258,2.4497462772194174]
[61,null,"","",null,null,null,null,"","","","",null,"","",null,null,null,null,60,0.6,2.4632861903192587,1.8298906516604829,2.3468856771849671,2.4632861903192587]
[62,null,"","",null,null,null,null,"","","","",null,"","",null,null,null,null,61,0.61,2.4769964368813193,1.8298906516604829,2.3555022609437088,2.4769964368813193]
[63,null,"","",null,null,null,null,"","","","",null,"","",null,null,null,null,62,0.62,2.4908836118059523,1.8298906516604829,2.3641188447024502,2.4908836118059523]
[64,null,"","",null,null,null,null,"","","","",null,"","",null,null,null,null,63,{"$f":"T66/100","v":0.63},2.5049547468717956,1.8298906516604829,2.3727354284611915,2.5049547468717956]
[65,null,"",{"$f":"IF(ISNUMBER(C67)=TRUE,C67*100,\"\")","v":""},null,null,null,null,"","","","",null,"","",null,null,null,null,64,0.64,{"$f":"IF((F$8*(F$4-F$3))>=U67,W67,IF((1-((F$8)*(F$6-F$5)))>=U67,X67,Y67))","v":2.5192173523597954},1.8298906516604829,2.3813520122199328,2.5192173523597954]
[66,null,{"$f":"IF(ISBLANK(B68)=FALSE,(((RANK(B68,B$3:B$207,1)+((COUNT(B$3:B$207)+1-RANK(B68,B$3:B$207,1)-RANK(B68,B$3:B$207,0))/2))-0.4)/(C$1+0.2)),\"\")","v":""},"",null,null,null,null,"","","","",null,"","",null,null,null,null,65,0.65,2.5336794639192735,{"$f":"IF(ISNUMBER(U68)=TRUE,(F$3+SQRT((2*(F$4-F$3))/F$7)*SQRT(U68)),\"\")","v":1.8298906516604829},{"$f":"IF(ISNUMBER(U68)=TRUE,(((F$3+F$4)/2)+(U68/F$7)),\"\")","v":2.3899685959786741},{"$f":"IF(ISNUMBER(U68)=TRUE,(F$6-SQRT((2*(F$6-F$5))/F$7)*SQRT(1-U68)),\"\")","v":2.5336794639192735}]
[67,null,"","",null,null,null,null,"","","","",null,"","",null,null,null,null,66,0.66,2.5483496955062352,1.8298906516604829,2.3985851797374158,2.5483496955062352]
[68,null,"","",null,null,null,null,"","","","",null,"","",null,null,null,null,67,0.67,2.5632372993841215,1.8298906516604829,2.4072017634961571,2.5632372993841215]
[69,null,"","",null,null,null,null,"","","","",null,"","",null,null,null,null,68,0.68,2.5783522343738969,1.8298906516604829,2.4158183472548984,2.5783522343738969]
[70,null,"","",null,null,null,null,"","","","",null,"","",null,null,null,null,69,0.69,2.5937052437835568,1.8298906516604829,2.4244349310136397,2.5937052437835568]
[71,null,"","",null,null,null,null,"","","","",null,"","",null,null,null,null,70,0.7,2.6093079447497001,1.8298906516604829,2.433051514772381,2.6093079447497001]
[72,null,"","",null,null,null,null,"","","","",null,"","",null,null,null,null,71,0.71,2.6251729311027443,1.8298906516604829,2.4416680985311228,2.6251729311027443]
[73,null,"","",null,null,null,null,"","","","",null,"","",null,null,null,null,72,0.72,2.6413138923452464,1.8298906516604829,2.4502846822898641,2.6413138923452464]
[74,null,"","",null,null,null,null,{"$f":"IF(ISNUMBER(C76)=TRUE,(F$3+SQRT((2*(F$4-F$3))/F$7)*SQRT(C76)),\"\")","v":""},{"$f":"IF(ISNUMBER(C76)=TRUE,(((F$3+F$4)/2)+(C76/F$7)),\"\")","v":""},{"$f":"IF(ISNUMBER(C76)=TRUE,(F$6-SQRT((2*(F$6-F$5))/F$7)*SQRT(1-C76)),\"\")","v":""},{"$f":"IF((F$8*(F$4-F$3))>=C76,I76,IF((1-((F$8)*(F$6-F$5)))>=C76,J76,K76))","v":""},null,{"$f":"IF(ISNUMBER(B76)=TRUE,L76-B76,\"\")","v":""},{"$f":"IF(ISNUMBER(B76)=TRUE,ABS(N76),\"\")","v":""},null,null,null,null,73,0.73,2.6577457519399883,1.8298906516604829,2.4589012660486054,2.6577457519399883]
[75,null,"","",null,null,null,null,"","","","",null,"","",null,null,null,null,74,0.74,2.6744848288821821,1.8298906516604829,2.4675178498073471,2.6744848288821821]
[76,null,"","",null,null,null,null,"","","","",null,"","",null,null,null,null,75,0.75,2.6915490275346232,1.8298906516604829,2.4761344335660884,2.6915490275346232]
[77,null,"","",null,null,null,null,"","","","",null,"","",null,null,null,null,76,0.76,2.7089580620139961,1.8298906516604829,2.4847510173248297,2.7089580620139961]
[78,null,"","",null,null,null,null,"","","","",null,"","",null,null,null,null,77,0.77,2.7267337231400353,1.8298906516604829,2.493367601083571,2.7267337231400353]
[79,null,"","",null,null,null,null,"","","","",null,"","",null,null,null,null,78,0.78,2.7449001982519778,1.8298906516604829,2.5019841848423123,2.7449001982519778]
[80,null,"","",null,null,null,null,"","","","",null,"","",null,null,null,null,79,0.79,2.7634844572815718,1.8298906516604829,2.5106007686010541,2.7634844572815718]
[81,null,"","",null,null,null,null,"","","","",null,"","",null,null,null,null,80,0.8,2.7825167226741065,1.8298906516604829,2.5192173523597954,2.7825167226741065]
[82,null,"","",null,null,null,null,"","","","",null,"","",null,null,null,null,81,0.81,2.8020310465506113,1.8298906516604829,2.5278339361185367,2.8020310465506113]
[83,null,"","",null,null,null,null,"","","","",null,"","",null,null,null,null,82,0.82,2.8220660266326139,1.8298906516604829,2.536450519877278,2.8220660266326139]
[84,null,"","",null,null,null,null,"","","","",null,"","",null,null,null,null,83,0.83,2.8426657040233145,1.8298906516604829,2.5450671036360193,2.8426657040233145]
[85,null,"","",null,null,null,null,"","","","",null,"","",null,null,null,null,84,0.84,2.8638807027094515,1.8298906516604829,2.553683687394761,2.8638807027094515]
[86,null,"","",null,null,null,null,"","","","",null,"","",null,null,null,null,85,0.85,2.8857696954326286,1.8298906516604829,2.5623002711535023,2.8857696954326286]
[87,null,"","",null,null,null,null,"","","","",null,"","",null,null,null,null,86,0.86,2.9084013180157409,1.8298906516604829,2.5709168549122436,2.9084013180157409]
[88,null,"","",null,null,null,null,"","","","",null,"","",null,null,null,null,87,0.87,2.9318567121793162,1.8298906516604829,2.5795334386709854,2.9318567121793162]
[89,null,"","",null,null,null,null,"","","","",null,"","",null,null,null,null,88,0.88,2.9562329690962468,1.8298906516604829,2.5881500224297267,2.9562329690962468]
[90,null,"","",null,null,null,null,"","","","",null,"","",null,null,null,null,89,0.89,2.9816478973604545,1.8298906516604829,2.596766606188468,2.9816478973604545]
[91,null,"","",null,null,null,null,"","","","",null,"","",null,null,null,null,90,0.9,3.0082467968640114,1.8298906516604829,2.6053831899472093,3.0082467968640114]
[92,null,"","",null,null,null,null,"","","","",null,"","",null,null,null,null,91,0.91,3.0362123778842793,1.8298906516604829,2.6139997737059506,3.0362123778842793]
[93,null,"","",null,null,null,null,"","","","",null,"","",null,null,null,null,92,0.92,3.0657798188913303,1.8298906516604829,2.6226163574646923,3.0657798188913303]
[94,null,"","",null,null,null,null,"","","","",null,"","",null,null,null,null,93,0.93,3.0972606478770053,1.8298906516604829,2.6312329412234337,3.0972606478770053]
[95,null,"","",null,null,null,null,"","","","",null,"","",null,null,null,null,94,0.94,3.1310827327113797,1.8298906516604829,2.639849524982175,3.1310827327113797]
[96,null,"","",null,null,null,null,"","","","",null,"","",null,null,null,null,95,0.95,3.1678620630414351,1.8298906516604829,2.6484661087409163,3.1678620630414351]
[97,null,"","",null,null,null,null,"","","","",null,"","",null,null,null,null,96,0.96,3.2085440530591072,1.8298906516604829,2.6570826924996576,3.2085440530591072]
[98,null,"","",null,null,null,null,"","","","",null,"","",null,null,null,null,97,0.97,3.2547201862525053,1.8298906516604829,2.6656992762583993,3.2547201862525053]
[99,null,"","",null,null,null,null,"","","","",null,"","",null,null,null,null,98,0.98,3.3094936111500468,1.8298906516604829,2.6743158600171406,3.3094936111500468]
[100,null,"","",null,null,null,null,"","","","",null,"","",null,null,null,null,99,0.99,3.3808757282339355,1.8298906516604829,2.6829324437758819,3.3808757282339355]
[101,null,"","",null,null,null,null,"","","","",null,"","",null,null,null,null,99.5,0.995,3.4313505072794053,1.8298906516604829,2.6872407356552528,3.4313505072794053]
[102,null,"","",null,null,null,null,"","","","",null,"","",null,null,null,null,99.9,{"$f":"T104/100","v":0.99900000000000011},3.4987113427542913,1.8298906516604829,2.6906873691587494,3.4987113427542913]
[103,null,"","",null,null,null,null,"","","","",null,"",""]
[104,null,"","",null,null,null,null,"","","","",null,"",""]
[105,null,"","",null,null,null,null,"","","","",null,"",""]
[106,null,"","",null,null,null,null,"","","","",null,"",""]
[107,null,"","",null,null,null,null,"","","","",null,"",""]
[108,null,"","",null,null,null,null,"","","","",null,"",""]
[109,null,"","",null,null,null,null,"","","","",null,"",""]
[110,null,"","",null,null,null,null,"","","","",null,"",""]
[111,null,"","",null,null,null,null,"","","","",null,"",""]
[112,null,"","",null,null,null,null,"","","","",null,"",""]
[113,null,"","",null,null,null,null,"","","","",null,"",""]
[114,null,"","",null,null,null,null,"","","","",null,"",""]
[115,null,"","",null,null,null,null,"","","","",null,"",""]
[116,null,"","",null,null,null,null,"","","","",null,"",""]
[117,null,"","",null,null,null,null,"","","","",null,"",""]
[118,null,"","",null,null,null,null,"","","","",null,"",""]
[119,null,"","",null,null,null,null,"","","","",null,"",""]
[120,null,"","",null,null,null,null,"","","","",null,"",""]
[121,null,"","",null,null,null,null,"","","","",null,"",""]
[122,null,"","",null,null,null,null,"","","","",null,"",""]
[123,null,"","",null,null,null,null,"","","","",null,"",""]
[124,null,"","",null,null,null,null,"","","","",null,"",""]
[125,null,"","",null,null,null,null,"","","","",null,"",""]
[126,null,"","",null,null,null,null,"","","","",null,"",""]
[127,null,"","",null,null,null,null,"","","","",null,"",""]
[128,null,"","",null,null,null,null,"","","","",null,"",""]
[129,null,"",{"$f":"IF(ISNUMBER(C131)=TRUE,C131*100,\"\")","v":""},null,null,null,null,"","","","",null,"",""]
[130,null,{"$f":"IF(ISBLANK(B132)=FALSE,(((RANK(B132,B$3:B$207,1)+((COUNT(B$3:B$207)+1-RANK(B132,B$3:B$207,1)-RANK(B132,B$3:B$207,0))/2))-0.4)/(C$1+0.2)),\"\")","v":""},"",null,null,null,null,"","","","",null,"",""]
[131,null,"","",null,null,null,null,"","","","",null,"",""]
[132,null,"","",null,null,null,null,"","","","",null,"",""]
[133,null,"","",null,null,null,null,"","","","",null,"",""]
[134,null,"","",null,null,null,null,"","","","",null,"",""]
[135,null,"","",null,null,null,null,"","","","",null,"",""]
[136,null,"","",null,null,null,null,"","","","",null,"",""]
[137,null,"","",null,null,null,null,"","","","",null,"",""]
[138,null,"","",null,null,null,null,{"$f":"IF(ISNUMBER(C140)=TRUE,(F$3+SQRT((2*(F$4-F$3))/F$7)*SQRT(C140)),\"\")","v":""},{"$f":"IF(ISNUMBER(C140)=TRUE,(((F$3+F$4)/2)+(C140/F$7)),\"\")","v":""},{"$f":"IF(ISNUMBER(C140)=TRUE,(F$6-SQRT((2*(F$6-F$5))/F$7)*SQRT(1-C140)),\"\")","v":""},{"$f":"IF((F$8*(F$4-F$3))>=C140,I140,IF((1-((F$8)*(F$6-F$5)))>=C140,J140,K140))","v":""},null,{"$f":"IF(ISNUMBER(B140)=TRUE,L140-B140,\"\")","v":""},{"$f":"IF(ISNUMBER(B140)=TRUE,ABS(N140),\"\")","v":""}]
[139,null,"","",null,null,null,null,"","","","",null,"",""]
[140,null,"","",null,null,null,null,"","","","",null,"",""]
[141,null,"","",null,null,null,null,"","","","",null,"",""]
[142,null,"","",null,null,null,null,"","","","",null,"",""]
[143,null,"","",null,null,null,null,"","","","",null,"",""]
[144,null,"","",null,null,null,null,"","","","",null,"",""]
[145,null,"","",null,null,null,null,"","","","",null,"",""]
[146,null,"","",null,null,null,null,"","","","",null,"",""]
[147,null,"","",null,null,null,null,"","","","",null,"",""]
[148,null,"","",null,null,null,null,"","","","",null,"",""]
[149,null,"","",null,null,null,null,"","","","",null,"",""]
[150,null,"","",null,null,null,null,"","","","",null,"",""]
[151,null,"","",null,null,null,null,"","","","",null,"",""]
[152,null,"","",null,null,null,null,"","","","",null,"",""]
[153,null,"","",null,null,null,null,"","","","",null,"",""]
[154,null,"","",null,null,null,null,"","","","",null,"",""]
[155,null,"","",null,null,null,null,"","","","",null,"",""]
[156,null,"","",null,null,null,null,"","","","",null,"",""]
[157,null,"","",null,null,null,null,"","","","",null,"",""]
[158,null,"","",null,null,null,null,"","","","",null,"",""]
[159,null,"","",null,null,null,null,"","","","",null,"",""]
[160,null,"","",null,null,null,null,"","","","",null,"",""]
[161,null,"","",null,null,null,null,"","","","",null,"",""]
[162,null,"","",null,null,null,null,"","","","",null,"",""]
[163,null,"","",null,null,null,null,"","","","",null,"",""]
[164,null,"","",null,null,null,null,"","","","",null,"",""]
[165,null,"","",null,null,null,null,"","","","",null,"",""]
[166,null,"","",null,null,null,null,"","","","",null,"",""]
[167,null,"","",null,null,null,null,"","","","",null,"",""]
[168,null,"","",null,null,null,null,"","","","",null,"",""]
[169,null,"","",null,null,null,null,"","","","",null,"",""]
[170,null,"","",null,null,null,null,"","","","",null,"",""]
[171,null,"","",null,null,null,null,"","","","",null,"",""]
[172,null,"","",null,null,null,null,"","","","",null,"",""]
[173,null,"","",null,null,null,null,"","","","",null,"",""]
[174,null,"","",null,null,null,null,"","","","",null,"",""]
[175,null,"","",null,null,null,null,"","","","",null,"",""]
[176,null,"","",null,null,null,null,"","","","",null,"",""]
[177,null,"","",null,null,null,null,"","","","",null,"",""]
[178,null,"","",null,null,null,null,"","","","",null,"",""]
[179,null,"","",null,null,null,null,"","","","",null,"",""]
[180,null,"","",null,null,null,null,"","","","",null,"",""]
[181,null,"","",null,null,null,null,"","","","",null,"",""]
[182,null,"","",null,null,null,null,"","","","",null,"",""]
[183,null,"","",null,null,null,null,"","","","",null,"",""]
[184,null,"","",null,null,null,null,"","","","",null,"",""]
[185,null,"","",null,null,null,null,"","","","",null,"",""]
[186,null,"","",null,null,null,null,"","","","",null,"",""]
[187,null,"","",null,null,null,null,"","","","",null,"",""]
[188,null,"","",null,null,null,null,"","","","",null,"",""]
[189,null,"","",null,null,null,null,"","","","",null,"",""]
[190,null,"","",null,null,null,null,"","","","",null,"",""]
[191,null,"","",null,null,null,null,"","","","",null,"",""]
[192,null,"","",null,null,null,null,"","","","",null,"",""]
[193,null,"",{"$f":"IF(ISNUMBER(C195)=TRUE,C195*100,\"\")","v":""},null,null,null,null,"","","","",null,"",""]
[194,null,{"$f":"IF(ISBLANK(B196)=FALSE,(((RANK(B196,B$3:B$207,1)+((COUNT(B$3:B$207)+1-RANK(B196,B$3:B$207,1)-RANK(B196,B$3:B$207,0))/2))-0.4)/(C$1+0.2)),\"\")","v":""},"",null,null,null,null,"","","","",null,"",""]
[195,null,"","",null,null,null,null,"","","","",null,"",""]
[196,null,"","",null,null,null,null,"","","","",null,"",""]
[197,null,"","",null,null,null,null,"","","","",null,"",""]
[198,null,"","",null,null,null,null,"","","","",null,"",""]
[199,null,"","",null,null,null,null,"","","","",null,"",""]
[200,null,"",{"$f":"IF(ISNUMBER(C202)=TRUE,C202*100,\"\")","v":""},null,null,null,null,"","","","",null,"",""]