{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["charts","test","data","calc","config","guide"],"not_rendered":{"charts":6,"images":0,"macros":1,"external_links":0,"defined_names":9,"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":"charts","index":0,"n_rows":21,"n_cols":14,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[]
[null,"TAB: CHARTS"]
[]
[null,{"$f":"calc!D10 & \" probability distribution function (pdf)\"","v":"Normal probability distribution function (pdf)"},null,null,null,null,null,{"$f":"calc!D10 & \" cumulative probability distribution function (cdf)\"","v":"Normal cumulative probability distribution function (cdf)"},null,null,null,null,null,"Historical sample"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Histogram",null,null,null,null,null,{"$f":"\"Transformation of \" & IF(calc!K23=1, calc!D16, calc!D10) & \"-distributed sample into uniform sample\"","v":"Transformation of Normal-distributed sample into uniform sample"},null,null,null,null,null,"Histogram and pdf fit"]

{"sheet":"test","index":1,"n_rows":63,"n_cols":27,"rows_kept":63,"cut":false,"hidden":false,"merged":[[8,2,8,4],[8,21,8,23],[8,24,8,26],[29,3,29,4]]}
[]
[null,"TAB: DISTRIBUTION TESTS AND SAMPLE HISTOGRAM"]
[]
[null,"Selected distribution",null,null,null,null,"Histogram",null,null,null,null,null,null,null,null,null,null,"Distribution tests"]
[]
[null,"Sample size",{"$f":"calc!D23","v":175},null,null,null,{"$f":"calc!I8","v":"Matched or alternative distribution based on generated sampe"},null,null,null,null,null,{"$f":"calc!I14","v":"Matched distribution based on historical sample"},null,null,null,null,null,"Test",{"$f":"calc!K24","v":"Kolmogorov-Smirnov"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sample",{"$f":"IF(calc!K23=1, \"Historical\", \"Generated\")","v":"Historical"}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I11:I34)","v":0.67428571428571404},null,{"$f":"SUM(K11:K34)","v":0.74141203050473259},null,null,{"$f":"SUM(N11:N34)","v":0.75428571428571412},null,{"$f":"SUM(P11:P34)","v":0.71132059605026188}]
[null,"Name","Parameters",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Parameters",null,null,"Statistics"]
[null,null,"p1","p2","p3",null,"#","x","histogram - matched distribution","normal fit - matched distribution",{"$f":"\"pdf - \" & calc!$D$10","v":"pdf - Normal"},null,{"$f":"H10","v":"x"},"histogram","normal fit - actual distribution",{"$f":"calc!$D$16 & \" distribution\"","v":"Normal distribution"},null,"#","Distribution","statistics","p-value","p1","p2","p3","mean","stdev","mode"]
[null,{"$f":"IF(calc!K23=1, calc!D16, calc!D10)","v":"Normal"},{"$f":"IF(calc!$K$23=1, IF(config!T17=\"\", \"\", config!T17), IF(config!T8=\"\", \"\", config!T8))","v":"mean"},{"$f":"IF(calc!$K$23=1, IF(config!U17=\"\", \"\", config!U17), IF(config!U8=\"\", \"\", config!U8))","v":"stdev"},{"$f":"IF(calc!$K$23=1, IF(config!V17=\"\", \"\", config!V17), IF(config!V8=\"\", \"\", config!V8))","v":""},null,1,{"$f":"_xll.AC.data._get(calc!K11, \"\", 0)","v":7.48293464837156E-2},5.7142857142857134E-3,1.0731493673897736E-3,{"$f":"_xll.AC.data._get(calc!K13, \"\", 0)","v":8.9710036273984517E-4},null,{"$f":"_xll.AC.data._get(calc!K17, \"\", 0)","v":6.5595637847907964E-2},1.1428571428571427E-2,7.5154584035611418E-4,{"$f":"_xll.AC.data._get(calc!K19, \"\", 0)","v":7.515458403561157E-4},null,1,{"$f":"B11","v":"Normal"},null,{"$f":"_xll.AC.stats.distrib.get(calc!K26, config!N27)","v":0.25307618412590038},{"$f":"IF(C12=\"\", \"\", C12)","v":0.45746052873075166},{"$f":"IF(D12=\"\", \"\", D12)","v":0.14596581623061439},{"$f":"IF(E12=\"\", \"\", E12)","v":""}]
[null,null,{"$f":"IF(calc!$K$23=1, IF(config!T18=\"\", \"\", config!T18), IF(config!T9=\"\", \"\", config!T9))","v":0.45746052873075166},{"$f":"IF(calc!$K$23=1, IF(config!U18=\"\", \"\", config!U18), IF(config!U9=\"\", \"\", config!U9))","v":0.14596581623061439},{"$f":"IF(calc!$K$23=1, IF(config!V18=\"\", \"\", config!V18), IF(config!V9=\"\", \"\", config!V9))","v":""},null,{"$f":"G11+1","v":2},9.5216796867698017E-2,0,2.9601387254624299E-3,2.5623893375289093E-3,null,8.579622106441856E-2,5.7142857142857134E-3,2.1586463292416762E-3,2.158646329241684E-3]
[null,null,null,null,null,null,{"$f":"IF(G12>=$D$34, \"\", G12+1)","v":3},0.11560424725168043,0,4.0134659826570832E-3,3.5887795562207061E-3,null,0.10599680428092915,1.1428571428571427E-2,3.0413030034001278E-3,3.0413030034001339E-3,null,1,{"$f":"config!C8","v":"Beta"},null,{"$f":"_xll.AC.data._get(calc!K32, \"\", 0)","v":1.7070789226636407E-12},{"$f":"_xll.AC.data._get(calc!K31, \"X\", 0)","v":1.0000000000000001E-5},1.1859809474154039E-5,"",{"$f":"V13/(V13+W13)","v":0.45746052873075166},null,{"$f":"(V13-1)/(V13+W13-2)","v":0.50000046495745054}]
[null,"Matching between generated and theoretical statistics",null,null,null,null,4,0.13599169763566285,1.714285714285714E-2,5.3494943720393991E-3,4.9291952262110134E-3,null,0.12619738749743975,0,4.2035872140150357E-3,4.2035872140150435E-3,null,{"$f":"R13+1","v":2},{"$f":"config!C9","v":"Chi-squred "},null,4.0731862327447743E-12,0.45746052873075166,"","",{"$f":"V14","v":0.45746052873075166}]
[null,null,null,null,null,null,5,0.15637914801964525,1.1428571428571427E-2,7.009572151106775E-3,6.6394610787477984E-3,null,0.14639797071395033,1.1428571428571427E-2,5.6998392598824089E-3,5.6998392598824211E-3,null,{"$f":"R14+1","v":3},{"$f":"config!C10","v":"Exponential"},null,1.063815702195825E-12,2.1859809474154037,"","",{"$f":"1/V15","v":0.45746052873075166}]
[null,{"$f":"calc!B8","v":"Matched or alternative distribution based on generated sampe"},null,null,null,null,6,0.17676659840362768,5.7142857142857134E-3,9.0293380447354875E-3,8.7703558067234923E-3,null,0.16659855393046091,0,7.5820619551258909E-3,7.5820619551259065E-3,null,4,{"$f":"config!C11","v":"Fisher"},null,1.0700329511337259E-12,1,1,"",{"$f":"V16/(V16-2)","v":-1},null,{"$f":"V16*(W16-2) / (W16*(V16+2))","v":-0.33333333333333331}]
[null,"Statistics","Generated","Theoretical","Sample",null,7,0.19715404878761009,5.7142857142857134E-3,1.1434204143531046E-2,1.1361329863652606E-2,null,0.18679913714697149,1.714285714285714E-2,9.8945084505863562E-3,9.8945084505863753E-3,null,5,{"$f":"config!C12","v":"Gamma"},null,0,9.8221131952556355,21.470952308186249,"",{"$f":"V17/W17","v":0.45746052873075171},{"$f":"SQRT(V17/(W17*W17))","v":0.14596581623061439}]
[null,"Mean",{"$f":"data!E4","v":0.46752569919855319},{"$f":"IF(OFFSET(config!M7, calc!$D$9, 0)=\"\", \"\", OFFSET(config!M7, calc!$D$9, 0))","v":0.45746052873075166},{"$f":"_xll.AC.stats.sample.moment.mean(calc!D26)","v":0.46894419185177938},null,8,0.21754149917159249,1.714285714285714E-2,1.4234479707787382E-2,1.4433401709487174E-2,null,0.20699972036348213,1.1428571428571427E-2,1.2667277746460624E-2,1.2667277746460648E-2,null,6,{"$f":"config!C13","v":"Geometric"},null,0,1,"","",{"$f":"1/V18","v":1}]
[null,"Standard deviation",{"$f":"data!E5","v":0.13781207708240079},{"$f":"IF(OFFSET(config!N7, calc!$D$9, 0)=\"\", \"\", OFFSET(config!N7, calc!$D$9, 0))","v":0.14596581623061439},{"$f":"_xll.AC.stats.sample.moment.stdev(calc!D26)","v":0.15603350069368488},null,9,0.23792894955557492,2.8571428571428567E-2,1.7420590833121041E-2,1.7981909268456345E-2,null,0.22720030357999271,1.1428571428571427E-2,1.5909426953386409E-2,1.5909426953386437E-2,null,7,{"$f":"config!C14","v":"Laplace"},null,0.3612333069305802,0.45746052873075166,0.10321341847809684,"",{"$f":"V19","v":0.45746052873075166},{"$f":"SQRT(2*W19*W19)","v":0.14596581623061436}]
[null,"Mode",{"$f":"data!E6","v":0.4576392363983029},{"$f":"IF(OFFSET(config!O7, calc!$D$9, 0)=\"\", \"\", OFFSET(config!O7, calc!$D$9, 0))","v":""},{"$f":"_xll.AC.stats.sample.moment.mode(calc!D27)","v":0.51264991961555673},null,10,0.25831639993955735,1.714285714285714E-2,2.0958962948294021E-2,2.1970021310357902E-2,null,0.24740088679650329,2.2857142857142854E-2,1.9602341692866475E-2,1.960234169286651E-2,null,8,{"$f":"config!C15","v":"Logistic"},null,0.33719793505033391,0.45746052873075166,8.047517223176491E-2,"",{"$f":"V20","v":0.45746052873075166},{"$f":"SQRT(PI()*PI()*W20*W20/3)","v":0.14596581623061439}]
[null,null,null,null,null,null,11,0.27870385032353973,1.1428571428571427E-2,2.4789189433497873E-2,2.6324051243366429E-2,null,0.26760147001301388,5.7142857142857134E-3,2.3694281726229498E-2,2.3694281726229532E-2,null,9,{"$f":"config!C16","v":"Log-Normal"},null,2.7247073515882514E-3,-0.83054230732986767,0.3113764067586422,"",{"$f":"EXP(V21+W21*W21/2)","v":0.45746052873075171},{"$f":"SQRT((EXP(W21*W21)-1)*EXP(2*V21+W21*W21))","v":0.14596581623061441}]
[null,{"$f":"calc!B14","v":"Matched distribution based on historical sample"},null,null,null,null,12,0.29909130070752216,1.714285714285714E-2,2.8823086789920103E-2,3.0931611734680592E-2,null,0.28780205322952446,1.714285714285714E-2,2.8097088221868613E-2,2.8097088221868651E-2,null,10,{"$f":"config!C17","v":"Normal"},null,0.25307618412590038,0.45746052873075166,0.14596581623061439,"",0.45746052873075166,{"$f":"W22","v":0.14596581623061439}]
[null,"Statistics","Generated","Theoretical","Sample",null,13,0.31947875109150459,3.9999999999999994E-2,3.2946120267903514E-2,3.5643467420683375E-2,null,0.30800263644603509,1.714285714285714E-2,3.2685960891545088E-2,3.2685960891545122E-2,null,11,{"$f":"config!C18","v":"Poisson"},null,1.3508570199008973E-3,9.8221131952556338,21.470952308186249,"",{"$f":"V23/W23","v":0.45746052873075166},{"$f":"SQRT(V23)/W23","v":0.14596581623061439}]
[null,"Mean",{"$f":"data!M4","v":0.46487001578006271},{"$f":"IF(OFFSET(config!M7, calc!$D$15, 0)=\"\", \"\", OFFSET(config!M7, calc!$D$15, 0))","v":0.45746052873075166},{"$f":"_xll.AC.stats.sample.moment.mean(calc!D31)","v":0.45746052873075166},null,14,0.33986620147548696,4.5714285714285707E-2,3.7021473165533725E-2,4.0279578273895882E-2,null,0.32820321966254568,5.1428571428571414E-2,3.7302966722298457E-2,3.7302966722298492E-2,null,12,{"$f":"config!C19","v":"Student T"},null,1.6076029396572267E-13,1,"","",null,{"$f":"IF(V24>2, SQRT(V24/(V24-2)), \"\")","v":""}]
[null,"Standard deviation",{"$f":"data!M5","v":0.1398713546786689},{"$f":"IF(OFFSET(config!N7, calc!$D$15, 0)=\"\", \"\", OFFSET(config!N7, calc!$D$15, 0))","v":0.14596581623061439},{"$f":"_xll.AC.stats.sample.moment.stdev(calc!D31)","v":0.14596581623061439},null,15,0.36025365185946939,3.9999999999999994E-2,4.0896744656330836E-2,4.4639308359033701E-2,null,0.34840380287905626,3.428571428571428E-2,4.1764536246366293E-2,4.1764536246366321E-2,null,13,{"$f":"config!C20","v":"Triangular"},null,0.11756671375819139,6.0483144564717019E-2,0.85853087657501204,0.45336756505252607,{"$f":"(V25+W25+X25)/3","v":0.45746052873075166}]
[null,"Mode",{"$f":"data!M6","v":0.4574966955772134},{"$f":"IF(OFFSET(config!O7, calc!$D$15, 0)=\"\", \"\", OFFSET(config!O7, calc!$D$15, 0))","v":""},{"$f":"_xll.AC.stats.sample.moment.mode(calc!D32)","v":0.45802673354483159},null,16,0.38064110224345182,6.2857142857142848E-2,4.4412928477032119E-2,4.8515171663400275E-2,null,0.36860438609556684,2.2857142857142854E-2,4.5872681571193195E-2,4.5872681571193223E-2,null,14,{"$f":"config!C21","v":"Uniform"},null,3.866594625145936E-6,6.0483144564717019E-2,0.85853087657501204,"",{"$f":"(V26+W26)/2","v":0.45950701056986454}]
[null,null,null,null,null,null,17,0.4010285526274342,5.1428571428571421E-2,4.7414994846830018E-2,5.1708895455024967E-2,null,0.38880496931207748,5.1428571428571414E-2,4.9429107380673486E-2,4.9429107380673513E-2]
[null,"Histogram parameters",null,null,null,null,18,0.42141600301141663,4.5714285714285707E-2,4.9763123471095634E-2,5.4048111366540939E-2,null,0.40900555252858806,3.428571428571428E-2,5.2250876695209322E-2,5.2250876695209343E-2]
[null,null,null,null,null,null,19,0.44180345339539906,3.9999999999999994E-2,5.1343465983447314E-2,5.540173399529312E-2,null,0.42920613574509864,3.9999999999999994E-2,5.418593479299267E-2,5.418593479299267E-2,null,null,null,null,null,null,null,null,{"$f":"3*Y21","v":1.372381586192255}]
[null,"Parameter","Key","Value",null,null,20,0.46219090377938143,3.428571428571428E-2,5.2077288102022536E-2,5.5692122010470906E-2,null,0.44940671896160922,0.10857142857142854,5.5126666661777741E-2,5.5126666661777741E-2]
[null,null,null,"generated","historical",null,21,0.48257835416336387,4.5714285714285707E-2,5.1927470186469579E-2,5.490245280697769E-2,null,0.4696073021781198,6.2857142857142834E-2,5.501980794551916E-2,5.5019807945519146E-2]
[null,"Minimum value","x-min",{"$f":"OFFSET(config!P7, calc!D9, 0)","v":1.9563080038908498E-2},{"$f":"OFFSET(config!P7, calc!D15, 0)","v":1.9563080038908498E-2},null,22,0.5029658045473463,6.8571428571428561E-2,5.0901619061960439E-2,5.3078336313970673E-2,null,0.48980788539463044,7.9999999999999988E-2,5.3871439661572935E-2,5.3871439661572915E-2]
[null,"Maximum value","x-max",{"$f":"OFFSET(config!Q7, calc!D9, 0)","v":0.89535797742259482},{"$f":"OFFSET(config!Q7, calc!D15, 0)","v":0.89535797742259482},null,23,0.52335325493132867,6.2857142857142848E-2,4.9051427938331914E-2,5.032345260792765E-2,null,0.51000846861114102,5.1428571428571414E-2,5.174641509263711E-2,5.1746415092637083E-2]
[null,"Number of bins","bin-count",40,{"$f":"D34","v":40},null,24,0.54374070531531116,0,4.6468359404385082E-2,4.6789793733340648E-2,null,0.53020905182765155,7.428571428571426E-2,4.8762293995056688E-2,4.8762293995056667E-2]
[null,null,null,null,null,null,25,0.56412815569929353,5.1428571428571421E-2,4.3276153399801592E-2,4.2663787235981937E-2,null,0.55040963504416218,5.7142857142857134E-2,4.5078573415187326E-2,4.5078573415187291E-2]
[null,null,null,null,null,null,26,0.58451560608327591,3.9999999999999994E-2,3.962101438448587E-2,3.8150062365305847E-2,null,0.57061021826067282,2.2857142857142854E-2,4.088258733289394E-2,4.0882587332893891E-2]
[null,null,null,null,null,null,27,0.60490305646725839,5.7142857142857134E-2,3.5660559740433403E-2,3.3454818096870967E-2,null,0.59081080147718334,2.2857142857142854E-2,3.6373806918918498E-2,3.6373806918918457E-2]
[null,null,null,null,null,null,28,0.62529050685124077,3.9999999999999994E-2,3.155268690862334E-2,2.8770649526472746E-2,null,0.61101138469369398,3.428571428571428E-2,3.1748361414739815E-2,3.174836141473978E-2]
[null,null,null,null,null,null,29,0.64567795723522314,3.428571428571428E-2,2.7445438071627238E-2,2.4264326077618501E-2,null,0.63121196791020451,1.714285714285714E-2,2.7185420089308632E-2,2.718542008930859E-2]
[null,null,null,null,null,null,30,0.66606540761920563,3.9999999999999994E-2,2.3468731327394358E-2,2.0068475094990622E-2,null,0.65141255112671514,5.7142857142857134E-3,2.2836679442433581E-2,2.283667944243355E-2]
[null,null,null,null,null,null,31,0.686452858003188,1.1428571428571427E-2,1.9728528153255882E-2,1.6277514363014688E-2,null,0.67161313434322578,2.8571428571428567E-2,1.8819671459247133E-2,1.8819671459247095E-2]
[null,null,null,null,null,null,32,0.70684030838717038,1.1428571428571427E-2,1.6303670347552295E-2,1.2947602977884899E-2,null,0.69181371755973631,0,1.5215046843425256E-2,1.5215046843425228E-2]
[null,null,null,null,null,null,33,0.72722775877115287,0,1.3245297335302709E-2,1.0099926972741631E-2,null,0.71201430077624694,2.2857142857142854E-2,1.2067483800033712E-2,1.2067483800033684E-2]
[null,null,null,null,null,null,34,0.74761520915513524,1.1428571428571427E-2,1.0578489642894507E-2,7.7263551424635668E-3,null,0.73221488399275747,2.2857142857142854E-2,9.389497045353818E-3,9.389497045353799E-3]
[null,null,null,null,null,null,35,0.76800265953911762,0,8.3056044696446125E-3,5.7964043386466123E-3,null,0.75241546720926811,0,7.1672096647141708E-3,7.1672096647141482E-3]
[null,null,null,null,null,null,36,0.7883901099231001,0,6.4106852144662635E-3,4.2645209498210074E-3,null,0.77261605042577874,0,5.3671046480402605E-3,5.3671046480402431E-3]
[null,null,null,null,null,null,37,0.80877756030708248,0,4.8643328638824394E-3,3.0768718242781784E-3,null,0.79281663364228927,5.7142857142857134E-3,3.9428675808501424E-3,3.9428675808501294E-3]
[null,null,null,null,null,null,38,0.82916501069106485,1.1428571428571427E-2,3.628505171243438E-3,2.1770887353149042E-3,null,0.81301721685879991,0,2.841623231902742E-3,2.841623231902732E-3]
[null,null,null,null,null,null,39,0.84955246107504734,5.7142857142857134E-3,2.6608343210721194E-3,1.5106728695139793E-3,null,0.83321780007531043,0,2.0091065620398063E-3,2.0091065620397989E-3]
[null,null,null,null,null,null,40,0.86993991145902971,1.1428571428571427E-2,9.5909925183354538E-4,5.1399903808969363E-4,null,0.85341838329182107,5.7142857142857134E-3,6.9677350528338385E-4,6.9677350528338136E-4]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]

{"sheet":"data","index":2,"n_rows":240,"n_cols":16,"rows_kept":240,"cut":false,"hidden":false,"merged":[]}
[]
[null,"TAB: GENERATED AND HISTORICAL SAMPLES AND DISTRIBUTIONS"]
[]
[null,null,"Mean",{"$f":"AVERAGE(D9:D500)","v":0.46894419185177938},{"$f":"SUMPRODUCT(E9:E502, F9:F502, G9:G502)","v":0.46752569919855319},null,null,null,null,null,null,{"$f":"AVERAGE(L9:L500)","v":0.45746052873075166},{"$f":"SUMPRODUCT(M9:M502, N9:N502, O9:O502)","v":0.46487001578006271}]
[null,null,"Stdev",{"$f":"STDEV(D9:D500)","v":0.15603350069368413},{"$f":"SQRT(SUMPRODUCT(E9:E502, E9:E502, F9:F502, G9:G502) - E4*E4)","v":0.13781207708240079},null,null,null,null,null,null,{"$f":"STDEV(L9:L500)","v":0.14596581623061591},{"$f":"SQRT(SUMPRODUCT(M9:M502, M9:M502, N9:N502, O9:O502) - M4*M4)","v":0.1398713546786689}]
[null,null,"Mode",null,{"$f":"OFFSET(E8, F6, 0)","v":0.4576392363983029},{"$f":"MATCH(MAX(G9:G500), G9:G500, 0)","v":82},null,"Generated",null,null,null,null,{"$f":"OFFSET(M8, N6, 0)","v":0.4574966955772134},{"$f":"MATCH(MAX(O9:O500), O9:O500, 0)","v":81},null,"Historical"]
[null,null,"Generated sample",null,null,{"$f":"calc!D23","v":175},null,"u*=F*(β)",null,"Historical sample",null,null,null,null,null,"u=F(x)"]
[null,"#","cdf - uniform","sample","sorted sample","sample increment",{"$f":"test!K10","v":"pdf - Normal"},{"$f":"\"cdf - \" & calc!$D$10","v":"cdf - Normal"},null,"#","Date","Value","sorted sample","sample increment",{"$f":"test!P10","v":"Normal distribution"},{"$f":"\"cdf - \" & calc!$D$16","v":"cdf - Normal"}]
[null,1,{"$f":"1/calc!D23","v":5.7142857142857143E-3},{"$f":"_xll.AC.data._get(calc!D26, \"\", 0)","v":0.37887514897993374},{"$f":"_xll.AC.data._get(calc!D27, \"\", 0)","v":6.9669559658139812E-2},{"$f":"IF($B10=\"\", \"\", E10-E9)","v":6.3289484853194022E-2},{"$f":"_xll.AC.data._get(calc!D28, \"\", 0)","v":8.016659195175288E-2},{"$f":"_xll.AC.data._get(calc!D29, \"\", 0)","v":3.9451940423096583E-3},null,1,"     AARON",0.18168982755953747,{"$f":"_xll.AC.data._get(calc!D32, \"\", 0)","v":6.0483144564717019E-2},{"$f":"IF($B10=\"\", \"\", M10-M9)","v":6.1056041094838878E-3},{"$f":"_xll.AC.data._get(calc!D33, \"\", 0)","v":6.7689051752678739E-2},{"$f":"_xll.AC.data._get(calc!D34, \"\", 0)","v":3.2674540751870757E-3}]
[null,{"$f":"IF(B9=\"\", \"\", IF(B9<$F$7, B9+1, \"\"))","v":2},{"$f":"IF(B10=\"\", \"\", C9+$C$9)","v":1.1428571428571429E-2},0.345988271612095,0.13295904451133383,{"$f":"IF($B11=\"\", \"\", E11-E10)","v":9.1031914203421604E-3},0.23091241080731356,1.310340236057383E-2,null,{"$f":"IF(K10=\"\", \"\", J9+1)","v":2},"     ACADI",0.41179261986816906,6.6588748674200907E-2,{"$f":"IF($B11=\"\", \"\", M11-M10)","v":2.5588801168252462E-2},7.5778171236395922E-2,3.7050303812414956E-3]
[null,3,1.7142857142857144E-2,0.28920468858820053,0.142062235931676,2.9852134178542933E-4,0.26473781968208798,1.5356625153251518E-2,null,{"$f":"IF(K11=\"\", \"\", J10+1)","v":3},"     AGELL",0.51791755388169347,9.2177549842453368E-2,9.9208857427697944E-3,0.11932919609653928,6.1655607734921458E-3]
[null,4,2.2857142857142857E-2,0.47203866949252554,0.14236075727346142,1.2861677919053627E-2,0.26590975139205431,1.5435829864552058E-2,null,4,"     AGREE",0.36365250328138771,0.10209843558522316,9.6807203707417744E-4,0.14112778851852492,7.4550165760055888E-3]
[null,5,2.8571428571428571E-2,0.25518292764552419,0.15522243519251505,6.1866403018259186E-3,0.32037407809230029,1.91976877821326E-2,null,5,"     ALEXA",0.28020380398538158,0.10306650762229734,4.2854175456572538E-2,0.14342183978779313,7.5927463659193799E-3]
[null,6,3.4285714285714287E-2,0.48205452980440383,0.16140907549434097,1.4438213954970025E-2,0.34944708046917478,2.1268667244834807E-2,null,6,"     ALEXA02",0.73236762370161335,0.14592068307886988,6.7032918226244964E-3,0.28020126574304843,1.6407713442035066E-2]
[null,7,0.04,6.9669559658139812E-2,0.175847289449311,1.8374492725066749E-2,0.42499693118856141,2.6846224115209313E-2,null,7,"     ALEXA03",0.41743274866967711,0.15262397490149437,2.9065852658043095E-2,0.30873095639733816,1.8380407303734247E-2]
[null,8,4.5714285714285714E-2,0.27899031754481796,0.19422178217437774,1.8135557147963E-2,0.53755143325377575,3.5660562013732522E-2,null,8,"     ALGOM",0.24394988628677991,0.18168982755953747,5.0368426367485841E-3,0.4587497613208053,2.9426974713982965E-2]
[null,9,5.1428571428571428E-2,0.55646439581265883,0.21235733932234074,1.160965860666191E-3,0.66738911871003792,4.655827732284451E-2,null,9,"     ALGOM02",0.25257020720852813,0.18672667019628605,9.4971738602814271E-4,0.48936224167214704,3.1814127064870634E-2]
[null,10,5.7142857142857141E-2,0.56478041006194224,0.21351830518300693,2.5800451873839447E-3,0.67634095101694891,4.7338282263819587E-2,null,10,"     ALLEG",6.6588748674200907E-2,0.1876763875823142,2.2426429561899774E-2,0.49529315051484524,3.2281695232311163E-2]
[null,11,6.2857142857142861E-2,0.51557475800266905,0.21609835037039088,1.8735686714811434E-2,0.69650933793092429,4.9109208845782404E-2,null,11,"     ALLIE",0.380430422789788,0.21010281714421397,5.4167253275274885E-3,0.6502247613276535,4.5073036960229629E-2]
[null,12,6.8571428571428575E-2,0.55911729121414688,0.23483403708520231,2.2575549125458394E-3,0.85413393587656938,6.3605098242295988E-2,null,12,"     AMERC",0.33024991097082107,0.21551954247174146,4.7293877790954009E-3,0.6919518663840265,4.870738360634802E-2]
[null,13,7.4285714285714288E-2,0.61610401840771567,0.23709159199774815,5.3025115284862645E-3,0.87441718616516384,6.5556197117038251E-2,null,13,"     AMERI",0.55545996113174956,0.22024893025083686,1.5290632387974068E-2,0.7297457345603886,5.2068765193897693E-2]
[null,14,0.08,0.69436782552088627,0.24239410352623442,1.8399884436759717E-3,0.92310393454204032,7.0321243683872103E-2,null,14,"     AMERI02",0.51952165083502766,0.23553956263881093,1.9428276092015584E-3,0.86044385511742472,6.4209935911874738E-2]
[null,15,8.5714285714285715E-2,0.51266333111794715,0.24423409196991039,1.047209596935772E-4,0.94033437030255562,7.2035569997825177E-2,null,15,"     AMERI03",0.72173137083318717,0.23748239024801249,6.467496038767423E-3,0.87795562204652522,6.5898608969835015E-2]
[null,16,9.1428571428571428E-2,0.16140907549434097,0.24433881292960397,1.0431186929677816E-2,0.94132014015811027,7.2134094326111342E-2,null,16,"     AMERI04",0.6405986668193745,0.24394988628677991,8.6203209217482202E-3,0.9376618239800828,7.1768701498010512E-2]
[null,17,9.7142857142857142E-2,0.3265786154743387,0.25476999985928178,4.1292778624241189E-4,1.0421819131430394,8.247471111776894E-2,null,17,"     ARMAD",0.54908286527290062,0.25257020720852813,2.7241781608688398E-3,1.0204826101908036,8.020603474596083E-2]
[null,18,0.10285714285714286,0.4579792248350143,0.25518292764552419,1.330079005341761E-2,1.0462797871431591,8.2905902785240904E-2,null,18,"     ARTIS",0.49332408671368611,0.25529438536939697,1.9790520476830997E-2,1.0473872101647013,8.3022580459062467E-2]
[null,19,0.10857142857142857,0.5740120403542408,0.2684837176989418,4.2727472496491004E-3,1.1821865766560795,9.7717935928592514E-2,null,19,"     BOSTO",0.52655469835963642,0.27508490584622797,5.1188981391536159E-3,1.2521891382357526,0.10575197593558944]
[null,20,0.11428571428571428,0.59785796092220367,0.2727564649485909,6.2338525962270519E-3,1.2273226262030172,0.10286531320517434,null,20,"     BRAEM",0.61172445952368992,0.28020380398538158,1.2830283965368228E-3,1.3074716542136511,0.11230294995016554]
[null,21,0.12,0.34789814415403808,0.27899031754481796,1.0214371043382575E-2,1.2942935253236076,0.11072435097454042,null,21,"     BRAND",0.51071347757688079,0.28148683238191841,8.6800053544570654E-3,1.3214516123898097,0.1139894365130974]
[null,22,0.12571428571428572,0.33093879795625825,0.28920468858820053,1.4121476746941808E-2,1.4064620955891622,0.12451530269226407,null,22,"     BRESE",0.73367963438303929,0.29016683773637547,1.3298694657798427E-2,1.4171585784578844,0.12587367322592291]
[null,23,0.13142857142857145,0.38812708931432854,0.30332616533514234,4.7056367201377958E-3,1.5650477820022679,0.14549277534351013,null,23,"     BRIXM",0.61739787053178352,0.3034655323941739,2.8226159973885334E-3,1.5666257832963355,0.14571100140894061]
[null,24,0.13714285714285718,0.436372826503306,0.30803180205528014,3.5148116569837518E-3,1.6184012036885542,0.15298279988333263,null,24,"     BROOK02",0.43046228644191287,0.30628814839156243,7.8390958322835935E-3,1.5986161868791315,0.15017811981372237]
[null,25,0.1428571428571429,0.50179684906971378,0.31154661371226389,7.7013945306142473E-4,1.6583112987703883,0.15874130700167849,null,25,"     BROOK03",0.72147818982800171,0.31412724422384602,5.0833099748602284E-3,1.6876160528360857,0.1630586101685596]
[null,26,0.14857142857142863,0.53136328130846333,0.31231675316532531,1.1911650286560882E-2,1.667057610865204,0.16002180591608872,null,26,"     BTBRE",0.6741556147501121,0.31921055419870625,5.4740345065534823E-3,1.745267383594383,0.171783876932664]
[null,27,0.15428571428571436,0.24239410352623442,0.32422840345188619,1.3172954896287781E-3,1.8019629239770061,0.18068372893595352,null,27,"     CANAD",0.37919423702635607,0.32468458870525974,3.5363393527999554E-3,1.8071017996669474,0.18150693010236912]
[null,28,0.16000000000000009,0.33689870050912696,0.32554569894151497,1.0329165328237244E-3,1.8167937207655833,0.18306721767137113,null,28,"     CAPIT",0.57424066038734256,0.32822092805805969,5.8961886492547855E-4,1.8468265881333863,0.18796775693339868]
[null,29,0.16571428571428581,0.63076889428016081,0.3265786154743387,1.3854958347843671E-3,1.8284039960352472,0.1849498116547551,null,29,"     CARET",0.54646794793412667,0.32881054692298517,3.1288960757586137E-4,1.853428566078537,0.18905862738114693]
[null,30,0.17142857142857154,0.21609835037039088,0.32796411130912306,9.3823441722373779E-4,1.843948954714395,0.18749383041919104,null,30,"     CBLAS",0.72462958687396761,0.32912343653056103,1.1264744402600391E-3,1.8569292731684921,0.18963909363531767]
[null,31,0.17714285714285727,0.43600629695104126,0.3289023457263468,2.0364522299114451E-3,1.8544558385123553,0.18922881705807443,null,31,"     CBREG",0.33672096612007635,0.33024991097082107,3.9879871090886532E-5,1.8695163289843302,0.19173796893204248]
[null,32,0.182857142857143,0.86605330371004174,0.33093879795625825,4.7950915404982863E-3,1.8772007614840791,0.19302850183878117,null,32,"     CEDAR",0.50930670661131439,0.33028979084191196,3.3931804160893253E-3,1.869961459806905,0.19181253387823616]
[null,33,0.18857142857142872,0.49504478308921274,0.33573388949675653,1.1648110123704258E-3,1.9303799707662022,0.20215757825429553,null,33,"     CHATH",0.43433017976738869,0.33368297125800128,3.0379948620750663E-3,1.9077045976057174,0.19822176047466866]
[null,{"$f":"IF(B41=\"\", \"\", IF(B41<$F$7, B41+1, \"\"))","v":34},{"$f":"IF(B42=\"\", \"\", C41+$C$9)","v":0.19428571428571445},0.62096581888654656,0.33689870050912696,2.9978530442362761E-3,1.9432073419279128,0.20441358055941089,null,34,"     CHESA",0.36534444827566354,0.33672096612007635,3.3284446234218001E-3,1.9412525542868631,0.20406837949267698]
[null,35,0.20000000000000018,0.25476999985928178,0.33989655355336323,1.7727675038584079E-3,1.976035499029825,0.21028830670777682,null,35,"     CHINA",0.21551954247174146,0.34004941074349815,0,1.9777017989548524,0.21059048530445212]
[null,36,0.2057142857142859,0.75039127736344802,0.34166932105722164,3.4771378863990288E-3,1.9953125885946952,0.21380846074808646,null,36,"     CHOIC",0.85853087657501204,0.34004941074349815,9.1867888668878406E-4,1.9777017989548524,0.21059048530445212]
[null,37,0.21142857142857163,0.50002389638393896,0.34514645894362067,8.4181266847432878E-4,2.0327998731998735,0.22081174095978312,null,37,"     CIMCO",0.38007835408488233,0.34096808963018693,3.0449372632183058E-3,1.9877000614795703,0.21241195294040122]
[null,38,0.21714285714285736,0.3289023457263468,0.345988271612095,1.9098725419430806E-3,2.04180669701354,0.22252677063493231,null,38,"     CINEP",0.23748239024801249,0.34401302689340524,9.5799485138665097E-3,2.0206294830550644,0.21851459294747577]
[null,39,0.22285714285714309,0.35407417011721021,0.34789814415403808,2.3077567126169041E-3,2.0621349493123473,0.22644579722635977,null,39,"     CITYO",0.61473649706873834,0.35359297540727175,2.7143780660812689E-3,2.1218013034570187,0.23835990620068137]
[null,40,0.22857142857142881,0.38042122167291703,0.35020590086665498,5.1752540463412267E-4,2.0864917608787237,0.2312328525085085,null,40,"     COLER",0.47758849859955382,0.35630735347335302,7.34514980803469E-3,2.1496932925550185,0.24415721648754757]
[null,41,0.23428571428571454,0.35072342627128911,0.35072342627128911,3.3507438459211003E-3,2.0919214816625282,0.23231407053459907,null,41,"     COLON",0.41604857308710907,0.36365250328138771,1.6919449942758291E-3,2.223163440728483,0.26021873803343987]
[null,42,0.24000000000000027,0.51238414616093153,0.35407417011721021,3.1238760467138249E-3,2.1267729962894952,0.23938210239874763,null,42,"     COLUM",0.37572960819532697,0.36534444827566354,4.8733327948307092E-3,2.2396361503250417,0.26399416887387861]
[null,43,0.245714285714286,0.66347487125969695,0.35719804616392403,4.9131940365277904E-3,2.1587627190960097,0.24607597474582654,null,43,"     COMIN",0.54396187157083542,0.37021778107049425,5.5118271248327244E-3,2.2860508779023596,0.27502239610013074]
[null,44,0.25142857142857172,0.50219098723634348,0.36211124020045182,5.5577542397367008E-4,2.208005012614477,0.2568039214550899,null,44,"     COREC",0.42707636144655853,0.37572960819532697,3.464628831029104E-3,2.3365661779745199,0.28776293582187068]
[null,45,0.25714285714285745,0.5697659053623737,0.36266701562442549,6.2940431585012946E-3,2.2134876004337363,0.25803260077558049,null,45,"     COREN",0.27508490584622797,0.37919423702635607,8.8411705852625699E-4,2.3671606374852945,0.29591153724551056]
[null,46,0.26285714285714318,0.61694973921506757,0.36896105878292679,2.2802914639533101E-3,2.2742328774495424,0.2721568796975119,null,46,"     CORES",0.41228794323694573,0.38007835408488233,3.5206870490567255E-4,2.3748175110394918,0.29800777371862308]
[null,47,0.26857142857142891,0.50301919160640574,0.3712413502468801,5.9080719891311806E-3,2.2955959680490876,0.27736721856064472,null,47,"     CORPO",0.52239428420330991,0.380430422789788,2.0554725978427224E-3,2.3778491972538136,0.29884440661717238]
[null,48,0.27428571428571463,0.43319226030686447,0.37714942223601128,1.7257267439224622E-3,2.3492158086471431,0.29108942349707168,null,48,"     COUSI",0.29016683773637547,0.38248589538763073,1.0392593929818283E-3,2.3953482266402411,0.3037500539589188]
[null,49,0.28000000000000036,0.42251137579579112,0.37887514897993374,9.1293624817728736E-4,2.3643819476157413,0.2951566476916499,null,49,"     CROMB",0.6118484909750832,0.38352515478061255,1.8369227819919898E-4,2.4040633401543143,0.30624397852886565]
[null,50,0.28571428571428609,0.59592443510452486,0.37978808522811103,6.3313644480600395E-4,2.3723105144646741,0.29731880184317039,null,50,"     CROSS",0.52811307020945741,0.38370884705881175,9.5392337682588257E-3,2.4055943753581523,0.30668572706380576]
[null,51,0.29142857142857181,0.554411796828019,0.38042122167291703,3.5557033836830509E-4,2.377770092653003,0.29882252811272697,null,51,"     CROWN",0.5400729104012586,0.39324808082707058,1.2737496395502368E-3,2.4810503460473678,0.32999959408618429]
[null,52,0.29714285714285754,0.39098005756481125,0.38077679201128534,1.2684388049244433E-4,2.3808220651345606,0.29966853552692951,null,52,"     CSWIN",0.15262397490149437,0.39452183046662082,3.5114983888557272E-3,2.4904982007048608,0.33316586445167412]
[null,53,0.30285714285714327,0.35020590086665498,0.38090363589177778,7.8602411929812321E-4,2.3819083334858862,0.29997059714345065,null,53,"     CYRUS",0.48993046075770474,0.39803332885547654,4.8091453698572151E-3,2.5157387198291103,0.34195591033330286]
[null,54,0.308571428571429,0.44994687065451239,0.3816896600110759,1.0913363906185358E-3,2.3886105422917643,0.30184547188951361,null,54,"     DCTIN",0.42761345274331092,0.40284247422533376,8.9501456428353054E-3,2.5483281108091145,0.35413376056070023]
[null,55,0.31428571428571472,0.37714942223601128,0.38278099640169444,6.7254134882571703E-4,2.3978320512463016,0.30445729031680313,null,55,"     DIAMO",0.32912343653056103,0.41179261986816906,4.9532336877666783E-4,2.6025750538889709,0.37719079816616774]
[null,56,0.32000000000000045,0.87509969828460554,0.38345353775052016,4.6735515638083869E-3,2.4034656605129108,0.3060718280517436,null,56,"     DIGIT",0.47290905999242738,0.41228794323694573,3.4059304147077141E-3,2.6053246478582093,0.37848059649628601]
[null,57,0.32571428571428618,0.58566585219550693,0.38812708931432854,2.8529682504827014E-3,2.4415494028458888,0.31739427597696479,null,57,"     DOUGL",0.55587544143738488,0.41569387365165344,3.5469943545562987E-4,2.6234919719909118,0.38738545746781056]
[null,58,0.33142857142857191,0.15522243519251505,0.39098005756481125,1.1009945443193336E-3,2.4638517420561801,0.32439192739386036,null,58,"     DREAM",0.49848090465547451,0.41604857308710907,1.3841755825680369E-3,2.6253090347963983,0.38831633126565313]
[null,59,0.33714285714285763,0.34514645894362067,0.39208105210913058,3.240794599111696E-3,2.4722602771596147,0.32710925385043899,null,59,"     DREAM02",0.44657323822892547,0.41743274866967711,3.2406332142483896E-3,2.6322632836831064,0.39195505802461561]
[null,60,0.34285714285714336,0.39532184670824227,0.39532184670824227,3.1346561594406963E-3,2.4963533977320012,0.33516064966522885,null,60,"     DUKER",0.47508536613766322,0.4206733818839255,5.7161360224749491E-3,2.6476853174129915,0.40051057350893954]
[null,61,0.34857142857142909,0.59622015803830974,0.39845650286768297,2.6998848169773604E-4,2.5186992797011714,0.34302113262034084,null,61,"     EASTG",0.59671576262768189,0.42638951790640045,6.8684354015807747E-4,2.6718965447385896,0.41571613840904548]
[null,62,0.35428571428571481,0.47609164747372551,0.39872649134938071,4.3802423828865344E-3,2.5205788913359788,0.34370140631386936,null,62,"     EMPIR",0.45889315182392282,0.42707636144655853,5.3709129675238998E-4,2.6745445493601938,0.41755222591092744]
[null,63,0.36000000000000054,0.2684837176989418,0.40310673373226724,4.582577380880748E-3,2.5500508309283125,0.35480740827171142,null,63,"     EPRPR",0.47721947964206762,0.42761345274331092,2.8488336986019491E-3,2.6765757476611132,0.41898924753295919]
[null,64,0.36571428571428627,0.42940795156792544,0.40768931111314799,3.7641577971814222E-6,2.5787662550549655,0.36655985133312896,null,64,"     EQUIN",0.56523011888692465,0.43046228644191287,1.2671092304614162E-3,2.6867671637005848,0.42662911686024346]
[null,65,0.371428571428572,0.46695623386350904,0.40769307527094517,5.6188938974366387E-4,2.5787889297383382,0.36656955825891102,null,65,"     EQUIT",0.32468458870525974,0.43172939567237428,2.6007840950144079E-3,2.6909832056097871,0.43003623612416231]
[null,{"$f":"IF(B73=\"\", \"\", IF(B73<$F$7, B73+1, \"\"))","v":66},{"$f":"IF(B74=\"\", \"\", C73+$C$9)","v":0.37714285714285772},0.46069453885332928,0.40825496466068883,{"$f":"IF($B75=\"\", \"\", E75-E74)","v":9.1702030949792346E-3},2.5821566386650789,0.36801950012155482,null,66,"     FEDER",0.5302901177042576,0.43433017976738869,{"$f":"IF($B75=\"\", \"\", M75-M74)","v":5.7042511625307601E-3},2.6990202681464819,0.4370455340191487]
[null,67,0.38285714285714345,0.49433831379724269,0.41742516775566807,3.8143258948217795E-3,2.6322257908626758,0.39193510320512365,null,{"$f":"IF(K75=\"\", \"\", J74+1)","v":67},"     FIRST",0.4542235440627197,0.44003443092991945,2.2972428713549653E-3,2.7137133132264553,0.45248525686904267]
[null,68,0.38857142857142918,0.3712413502468801,0.42123949365048985,1.271882145301273E-3,2.6502546386203338,0.40201018834495561,null,68,"     FIRST02",0.49392684692596706,0.44233167380127442,4.6815336988781375E-4,2.7184802214739943,0.45872491799578252]
[null,69,0.39428571428571491,0.23483403708520231,0.42251137579579112,1.7000734376239612E-3,2.6558905172950515,0.40538460406859117,null,69,"     FORES",0.28148683238191841,0.44279982717116223,2.6858854116351694E-4,2.7193700721257956,0.45999779304550259]
[null,70,0.40000000000000063,0.51776005940889458,0.42421144923341508,1.8584371345921058E-3,2.6631267015581179,0.4099060123353242,null,70,"     FORTI",0.45154246705593032,0.44306841571232575,1.4134737332535674E-3,2.7198680974830007,0.46072825177207366]
[null,71,0.40571428571428636,0.175847289449311,0.42606988636800719,2.3772909592929548E-3,2.6706449933466616,0.41486231569811044,null,71,"     FRANK",0.4820740815256887,0.44448188944557931,4.1784972791780728E-5,2.7223386106258345,0.46457448967998571]
[null,72,0.41142857142857209,0.42606988636800719,0.42844717732730014,9.6077424062529504E-4,2.6796599533873566,0.42122206604735024,null,72,"     FRPHO",0.21010281714421397,0.4445236744183711,2.0495638105543779E-3,2.7224077929190647,0.46468824397092151]
[null,73,0.41714285714285781,0.44395793385119947,0.42940795156792544,1.1366527775682478E-3,2.6831100005739317,0.42379828060825475,null,73,"     GAMEH",0.1876763875823142,0.44657323822892547,4.9692288270048457E-3,2.7255291861212516,0.47027128232631221]
[null,74,0.42285714285714354,0.67089315045913911,0.43054460434549369,2.6476559613707873E-3,2.6870470086870748,0.42685029742435754,null,74,"     GENER",0.48254156037575408,0.45154246705593032,1.5484746057797816E-4,2.7308758238955706,0.48382964995933242]
[null,75,0.42857142857142927,0.35719804616392403,0.43319226030686447,2.8140366441767872E-3,2.6956061684029904,0.43397619368197893,null,75,"     GEOGR",0.59545106503966239,0.4516973145165083,2.5262295462114004E-3,2.7309917478595067,0.48425252816067754]
[null,76,0.434285714285715,0.62963273642105988,0.43600629695104126,2.3353978903728478E-4,2.7037577085921201,0.44157342711485914,null,76,"     GETTY",0.3034655323941739,0.4542235440627197,1.2395849957040905E-3,2.7324493159673882,0.49115365337396033]
[null,77,0.44000000000000072,0.21235733932234074,0.43623983674007855,1.3298976322745348E-4,2.7043901493939124,0.44220493610161421,null,77,"     GGPIN",0.59567119154570791,0.45546312905842379,6.8500941564186846E-4,2.7328654131573424,0.49454103479278677]
[null,78,0.44571428571428645,0.60197521792128561,0.436372826503306,7.5851073478934716E-3,2.7047472663386731,0.44256461607806419,null,78,"     GLADS",0.64718926975830171,0.45614813847406566,5.0628251301682026E-4,2.7330108232171897,0.49641312657153686]
[null,79,0.45142857142857218,0.42123949365048985,0.44395793385119947,2.6897471103621839E-3,2.7214523288354413,0.4631483358025637,null,79,"     GOVER",0.52432762373902819,0.45665442098708248,4.5993032423319313E-4,2.733079614829248,0.49779682096034977]
[null,80,0.45714285714285791,0.44664768096156165,0.44664768096156165,3.2991896929507325E-3,2.7256325125837306,0.47047418201713243,null,80,"     GRAME",0.42638951790640045,0.45711435131131567,3.8234426589772719E-4,2.7331136066698893,0.49905385601071078]
[null,81,0.46285714285714363,0.5931616091354468,0.44994687065451239,7.692365743790508E-3,2.7295026830127784,0.47947332652402225,null,81,"     GRANI",0.22024893025083686,0.4574966955772134,9.0840867343511267E-5,2.7331212091809287,0.50009884837715668]
[null,82,0.46857142857142936,0.57634559899387494,0.4576392363983029,3.3998843671140255E-4,2.7331192446874848,0.50048842960939954,null,82,"     GRIFF",0.44279982717116223,0.45758753644455691,4.1222966254200744E-4,2.7331202584443051,0.5003471274431841]
[null,83,0.47428571428571509,0.14236075727346142,0.4579792248350143,2.7153140183149849E-3,2.7331040366387933,0.50141765638357727,null,83,"     HRREA",0.45805370098256426,0.45799976610709892,5.3934875465344589E-5,2.7331026428099938,0.50147379780300649]
[null,84,0.48000000000000081,0.5982927532891672,0.46069453885332928,3.172751660088402E-3,2.732450550241321,0.50883821882951163,null,84,"     HCIGR",0.23553956263881093,0.45805370098256426,8.3945084135855774E-4,2.7330987254223569,0.50162120724971571]
[null,85,0.48571428571428654,0.32796411130912306,0.46386729051341768,3.0889433500913555E-3,2.7304898463095424,0.51750483628101585,null,85,"     HCPIN",0.49782019502638203,0.45889315182392282,3.4754996815742345E-3,2.7329896554569593,0.50391546981793067]
[null,86,0.49142857142857227,0.64202184285120323,0.46695623386350904,5.0824356290165018E-3,2.7273440369680015,0.52593461977833389,null,86,"     HEALT",0.4574966955772134,0.46236865150549705,1.6575938175133476E-3,2.7315766267755754,0.5134119674416775]
[null,87,0.497142857142858,0.31154661371226389,0.47203866949252554,4.1927066984637218E-4,2.7195241294510732,0.53977768722631336,null,87,"     HIGHW",0.49046911108615932,0.4640262453230104,1.0166382996038559E-3,2.7303577184588166,0.51793885031625853]
[null,88,0.50285714285714367,0.39872649134938071,0.47245794016237191,3.6337073113535956E-3,2.7187328593493358,0.54091773882735805,null,88,"     HOSPI",0.4976289200815523,0.46504288362261426,2.061094538410857E-4,2.7294362559895022,0.52071417934032538]
[null,89,0.50857142857142934,0.36896105878292679,0.47609164747372551,5.6359278213216624E-3,2.7109476643300567,0.55078317645159591,null,89,"     HOSTH",0.34004941074349815,0.46524899307645534,6.6340756612727203E-3,2.7292333385265537,0.52127672113794743]
[null,90,0.51428571428571501,0.31231675316532531,0.48172757529504717,3.2695450935665837E-4,2.6956099198911718,0.56602051266347697,null,90,"     HOSTH02",0.34004941074349815,0.47188306873772806,1.0259912546993211E-3,2.7198121367461088,0.5393545047723256]
[null,91,0.52000000000000068,0.30803180205528014,0.48205452980440383,3.2556566293008293E-3,2.6945995196770709,0.5669016896629071,null,91,"     HUDSO",0.38370884705881175,0.47290905999242738,2.1763061452358401E-3,2.717856695007022,0.54214401647075072]
[null,92,0.52571428571428636,0.51263650811316641,0.48531018643370466,5.0437355767066205E-3,2.683824360095433,0.57565719159644313,null,92,"     INGLE",0.53453487738027938,0.47508536613766322,2.064283917759091E-3,2.71326972482071,0.548054021448657]
[null,93,0.53142857142857203,0.49603632653780683,0.49035392201041128,5.4930174945255761E-4,2.6645974109618367,0.58914648820069382,null,93,"     INOVA",0.47188306873772806,0.47714965005542231,6.9829586645309139E-5,2.7083695796429135,0.55365001460431373]
[null,94,0.5371428571428577,0.55490988130834018,0.49090322375986384,1.2009677394415053E-3,2.6623198267060997,0.5906095323170768,null,94,"     INTER",0.51405496557565278,0.47721947964206762,3.6901895748620017E-4,2.7081945035565473,0.55383913282333852]
[null,95,0.54285714285714337,0.56685999016527022,0.49210419149930534,2.2341222979373465E-3,2.6572159199581202,0.59380384476718762,null,95,"     IRONM",0.67382637722910332,0.47758849859955382,1.9894063846212506E-3,2.7072592018649519,0.55483833588593923]
[null,96,0.54857142857142904,0.24433881292960397,0.49433831379724269,7.064692919700466E-4,2.6472704854753411,0.59972938918186913,null,96,"     JONES",0.14592068307886988,0.47957790498417507,1.3272194888597211E-4,2.7019249723705228,0.56021895019764534]
[null,97,0.55428571428571471,0.19422178217437774,0.49504478308921274,9.9154344859408994E-4,2.6440044103196998,0.60159845420772695,null,97,"     KBSRE",0.45758753644455691,0.47971062693306105,2.3634545926276562E-3,2.7015516204236634,0.56057753019385748]
[null,{"$f":"IF(B105=\"\", \"\", IF(B105<$F$7, B105+1, \"\"))","v":98},{"$f":"IF(B106=\"\", \"\", C105+$C$9)","v":0.56000000000000039},0.46386729051341768,0.49603632653780683,3.9875698461321329E-3,2.6393229205860234,0.60421778789540714,null,98,"     KILRO",0.38352515478061255,0.4820740815256887,4.674788500653726E-4,2.694538681837471,0.56695437312702457]
[null,99,0.56571428571428606,0.51388698741614014,0.50002389638393896,1.7729526857748201E-3,2.619358747639795,0.61470306983084411,null,99,"     KIMCO",0.45614813847406566,0.48254156037575408,5.1527007066605734E-3,2.6930700776632874,0.56821367074596807]
[null,100,0.57142857142857173,0.34166932105722164,0.50179684906971378,3.9413816662969836E-4,2.6099052364039244,0.61933874058634708,null,100,"     KITER",0.45711435131131567,0.48769426108241465,2.2361996752900959E-3,2.6751169677410327,0.58204538607029899]
[null,101,0.5771428571428574,0.66991725152198045,0.50219098723634348,8.2820437006225767E-4,2.6077560316965935,0.62036698087609787,null,101,"     LADDE",0.70878839267119131,0.48993046075770474,5.3865032845457073E-4,2.6663287740668822,0.58801776710853582]
[null,102,0.58285714285714307,0.52217315292131117,0.50301919160640574,5.6547792465948543E-3,2.6031838173552568,0.62252484768905447,null,102,"     LEXIN",0.5598570702192236,0.49046911108615932,2.8549756275267901E-3,2.6641227644102492,0.58945339339177005]
[null,103,0.58857142857142875,0.21351830518300693,0.50867397085300059,3.7101753079309407E-3,2.569967403941825,0.63715299018351612,null,103,"     LIBER",0.4640262453230104,0.49332408671368611,6.0276021228095056E-4,2.6518578001486413,0.59704211932809281]
[null,104,0.59428571428571442,0.49210419149930534,0.51238414616093153,2.5236195223488078E-4,2.54632717805231,0.64664460856888872,null,104,"     MACER",0.49594915949406942,0.49392684692596706,4.7655921900152665E-4,2.6491459975997049,0.59863973854622077]
[null,105,0.60000000000000009,0.65861483633417861,0.51263650811316641,2.6823004780740511E-5,2.5446674003937662,0.64728699537146084,null,105,"     MARCU",0.33368297125800128,0.49440340614496858,1.5457533491008424E-3,2.6469719820016562,0.59990169652036107]
[null,106,0.60571428571428576,0.63754532407890352,0.51266333111794715,2.5960784968004358E-4,2.5444906026793377,0.64735524862634863,null,106,"     MAYSJ",0.10306650762229734,0.49594915949406942,1.6797605874828703E-3,2.639739023469275,0.60398770777736099]
[null,107,0.61142857142857143,0.65033888791778538,0.5129229389676272,9.6404844851294413E-4,2.5427756541784463,0.64801559590225111,null,107,"     MEDIC",0.53262963382670248,0.4976289200815523,1.9127494482973351E-4,2.6315667961061111,0.60841501897005246]
[null,108,0.6171428571428571,0.36211124020045182,0.51388698741614014,3.7706876890386543E-4,2.5363471206844554,0.65046386371002396,null,108,"     MELCO",0.33028979084191196,0.49782019502638203,6.6070962909248188E-4,2.6306157339490173,0.60891828087314848]
[null,109,0.62285714285714278,0.13295904451133383,0.51426405618504401,1.3107018176250484E-3,2.533807079040006,0.65141976256275569,null,109,"     MELCO02",0.51472413429362085,0.49848090465547451,9.1729651988514682E-4,2.6272984727173725,0.61065526088106081]
[null,110,0.62857142857142845,0.50867397085300059,0.51557475800266905,2.185301406225526E-3,2.5248665146488181,0.65473498772389926,null,110,"     MONMO",0.47957790498417507,0.49939820117535966,9.9085054359547287E-3,2.622610796109206,0.61306312991658274]
[null,111,0.63428571428571412,0.42844717732730014,0.51776005940889458,7.6850115799231844E-4,2.5095802412640054,0.66023596535512952,null,111,"     MORGU",0.47971062693306105,0.50930670661131439,1.4067709655664062E-3,2.5660375722104045,0.63877785941242693]
[null,112,0.63999999999999979,0.59446752961738369,0.5185285605668869,2.7191145864935429E-3,2.5040931685972172,0.66216247594677113,null,112,"     MORGU02",0.45546312905842379,0.51071347757688079,6.2072146928759953E-4,2.5571496553401794,0.64238145921186751]
[null,113,0.64571428571428546,0.40769307527094517,0.52124767515338044,9.2547776793072689E-4,2.4842220028881821,0.66894453646850782,null,113,"     NATIO",0.44306841571232575,0.51133419904616839,1.9183215898819217E-3,2.5531623528603915,0.64396750146928561]
[null,114,0.65142857142857113,0.33573388949675653,0.52217315292131117,9.5811825417346785E-4,2.4772985849791187,0.67124043116921994,null,114,"     NATIO02",9.2177549842453368E-2,0.51325252063605031,8.0244493960246466E-4,2.5405885516620064,0.64885328803454279]
[null,115,0.65714285714285681,0.48172757529504717,0.52313127117548464,6.6546070806738911E-4,2.470046700049338,0.67361050889515495,null,115,"     NATIO03",0.51133419904616839,0.51405496557565278,6.6916871796807165E-4,2.5352173476771274,0.65088981978261007]
[null,116,0.66285714285714248,0.39208105210913058,0.52379673188355202,7.5665494249113063E-3,2.4649599022734705,0.67525253765165316,null,116,"     NEWJE",0.31921055419870625,0.51472413429362085,2.6381848301277877E-3,2.530688434196505,0.65258479513834544]
[null,117,0.66857142857142815,0.68965155359840913,0.53136328130846333,1.1900735336951573E-3,2.4043354390911711,0.693677593187213,null,117,"     NORTH",0.52210563687128653,0.51736231912374864,5.5523475794483357E-4,2.5123974643897955,0.65923724341961343]
[null,118,0.67428571428571382,0.85593716230267303,0.53255335484215849,2.1858441985860511E-2,2.3943513913722088,0.69653299998101559,null,118,"     ONELI",0.53672950115332718,0.51791755388169347,1.6040969533341887E-3,2.508460422108616,0.6606311222212875]
[null,119,0.67999999999999949,0.40310673373226724,0.554411796828019,4.9808448032118147E-4,2.1920999148253695,0.74672053766472335,null,119,"     PARAM",0.35630735347335302,0.51952165083502766,2.5839860362588674E-3,2.4969177900494661,0.66464571147851914]
[null,120,0.68571428571428517,0.42421144923341508,0.55490988130834018,1.5545145043186492E-3,2.1871244306076312,0.74781115009486365,null,120,"     PARTN",0.67018046022226629,0.52210563687128653,2.88647332023384E-4,2.4778063817860043,0.67107315660941635]
[null,121,0.69142857142857084,0.49090322375986384,0.55646439581265883,2.6528954014880535E-3,2.1715059135258272,0.75119894465908288,null,121,"     PEBBL",0.32881054692298517,0.52239428420330991,1.9333395357182814E-3,2.4756324486647512,0.67178805524786056]
[null,122,0.69714285714285651,0.573749687757796,0.55911729121414688,5.6631188477953565E-3,2.1445470794308585,0.75692404636567479,null,122,"     PHYSI",0.32822092805805969,0.52432762373902819,3.384417015683816E-4,2.4608725857732279,0.67656008096763465]
[null,123,{"$f":"IF(B131=\"\", \"\", C130+$C$9)","v":0.70285714285714218},0.3816896600110759,0.56478041006194224,2.0795801033279826E-3,2.0858062809732623,0.76890327594902386,null,123,"     PIEDM",0.4516973145165083,0.52466606544059657,1.8886329190398454E-3,2.4582535006970607,0.67739249996337259]
[null,124,0.70857142857142785,0.36266701562442549,0.56685999016527022,2.9059151971034813E-3,2.0638620505449636,0.77321809256042406,null,124,"     PLAZA",0.55587248462769834,0.52655469835963642,1.5583718498209942E-3,2.4434479114837822,0.68202130778683412]
[null,125,0.71428571428571352,0.5185285605668869,0.5697659053623737,3.9837823954222973E-3,2.0328930262459499,0.77917058718990151,null,125,"     PRORE",0.64116483443872707,0.52811307020945741,2.1770474948001883E-3,2.4309920388743675,0.68581943059766148]
[null,126,0.7199999999999992,0.142062235931676,0.573749687757796,2.6235259644480369E-4,1.989908590701347,0.7871837627461773,null,126,"     PROLO",0.35359297540727175,0.5302901177042576,1.0792783392221672E-3,2.4132368164914277,0.69109256288197995]
[null,127,0.72571428571428487,0.63587259821676767,0.5740120403542408,1.671214879045535E-3,1.9870580072106927,0.78770544655374597,null,127,"     PSBUS",0.10209843558522316,0.53136939604347977,1.2602377832227063E-3,2.4042844421234104,0.69369229490539885]
[null,128,0.73142857142857054,0.32554569894151497,0.57568325523328634,6.6234376058860178E-4,1.968845779411533,0.79101104194380067,null,128,"     PUBLI",6.0483144564717019E-2,0.53262963382670248,1.9052435535769074E-3,2.3937074430246166,0.69671561411698268]
[null,129,0.73714285714285621,0.66488069274757911,0.57634559899387494,9.3202532016319894E-3,1.9616029440017391,0.79231269679804095,null,129,"     PUREI",0.44448188944557931,0.53453487738027938,2.1946237730477991E-3,2.3774687677871258,0.70126078745683706]
[null,130,0.74285714285714188,0.59751352543756342,0.58566585219550693,{"$f":"IF($B139=\"\", \"\", E139-E138)","v":2.1356855286889243E-3},1.8584029656898224,0.81011612404547817,null,130,"     QTSRE",0.49440340614496858,0.53672950115332718,{"$f":"IF($B139=\"\", \"\", M139-M138)","v":2.4843027799945627E-3},2.3584021084507332,0.70645758468159814]
[null,131,0.74857142857142756,0.62817855976736447,0.58780153772419586,3.3724253008642346E-3,1.8344768350370779,0.81405955419115561,null,{"$f":"IF(K139=\"\", \"\", J138+1)","v":131},"     READI",0.37021778107049425,0.53921380393332174,8.591064679368543E-4,2.3363657902428345,0.71228929509757066]
[null,132,0.75428571428571323,0.48531018643370466,0.59117396302506009,1.9876461103867094E-3,1.7965378500901954,0.82018226662493299,null,132,"     REALT",0.43172939567237428,0.5400729104012586,6.633124886658015E-4,2.3286363648771715,0.71429316581071089]
[null,133,0.7599999999999989,0.38077679201128534,0.5931616091354468,1.3059204819368952E-3,1.7741022287746251,0.82373085919011468,null,133,"     REGEN",0.39324808082707058,0.5407362228899244,3.2256486809110196E-3,2.3226309627728545,0.7158357894614733]
[null,134,0.76571428571428457,0.49035392201041128,0.59446752961738369,1.4569054871411691E-3,1.7593367512348981,0.82603805631809124,null,134,"     RETAI",0.44233167380127442,0.54396187157083542,4.1432950470432495E-5,2.2929719857534039,0.72328014673169005]
[null,135,0.77142857142857024,0.32422840345188619,0.59592443510452486,2.9572293378488101E-4,1.7428444896786,0.8285892321727184,null,135,"     RETAI02",0.46504288362261426,0.54400330452130585,2.4646434128208217E-3,2.2925862120670675,0.72337514333494857]
[null,136,0.77714285714285591,0.33989655355336323,0.59622015803830974,1.2933673992536754E-3,1.7394946523095611,0.82910413596376942,null,136,"     REXFO",0.34096808963018693,0.54646794793412667,2.6149173387739477E-3,2.2694258260112949,0.72899709506442578]
[null,137,0.78285714285714159,0.38090363589177778,0.59751352543756342,3.4443548464024865E-4,1.7248361769295288,0.83134446352901115,null,137,"     RIOCA",0.41569387365165344,0.54908286527290062,1.535265753723758E-3,2.2444093462331436,0.73489884540409711]
[null,138,0.78857142857142726,0.6692642818573673,0.59785796092220367,4.347923669635323E-4,1.7209305804104955,0.83193788572175498,null,138,"     RLJLO",0.39803332885547654,0.55061813102662438,4.8418301051251778E-3,2.2295169941462158,0.73833319732832059]
[null,139,0.79428571428571293,0.30332616533514234,0.5982927532891672,4.1018610370679998E-4,1.7159993976075241,0.83268506122163344,null,139,"     RPTRE",0.48769426108241465,0.55545996113174956,4.1252349594878002E-4,2.1816131552822142,0.74901272807939723]
[null,140,0.7999999999999986,0.47245794016237191,0.598702939392874,1.8585198183489471E-3,1.7113463198079908,0.83338798604528552,null,140,"     RYMAN",0.58033893177973073,0.55587248462769834,2.9568096865384419E-6,2.1774688861099887,0.74991184028837488]
[null,141,0.80571428571428427,0.40768931111314799,0.60056145921122295,1.4137587100626625E-3,1.6902539364288036,0.83654895898196013,null,141,"     SABRA",0.51736231912374864,0.55587544143738488,3.9816287818387197E-3,2.1774391472420835,0.74991827860550342]
[null,142,{"$f":"IF(B150=\"\", \"\", C149+$C$9)","v":0.81142857142856994},0.7033029342003746,0.60197521792128561,1.6608268760828215E-3,1.6742016480331501,0.83892722372129636,null,142,"     SAULC",0.67504472644188074,0.5598570702192236,5.3730486677010525E-3,2.1369634015369106,0.75850773388130877]
[null,143,0.81714285714285562,0.83683217502657814,0.60363604479736843,5.9696214057504138E-3,1.6553403186817843,0.84169212036632601,null,143,"     SELEC",0.47714965005542231,0.56523011888692465,9.0105415004179124E-3,2.0810769534108253,0.76984021836942018]
[null,144,0.82285714285714129,0.37978808522811103,0.60960566620311885,6.4983522045968245E-3,1.5875852828986898,0.85137157983390988,null,144,"     SHERW",0.40284247422533376,0.57424066038734256,3.8030963696461528E-3,1.9845720460286445,0.78815944368438595]
[null,145,0.82857142857142696,0.60960566620311885,0.61610401840771567,8.457208073519018E-4,1.5140963428889507,0.86144926788132525,null,145,"     SIMON",0.730248900044142,0.57804375675698871,2.2951750227420131E-3,1.9429720274216558,0.79562800118020915]
[null,146,0.83428571428571263,0.43054460434549369,0.61694973921506757,4.0160796714789893E-3,1.5045664903534151,0.86272574019580772,null,146,"     SLGRE",0.46524899307645534,0.58033893177973073,6.1102068088777495E-3,1.9176594627559977,0.80005844146057936]
[null,147,0.8399999999999983,0.52379673188355202,0.62096581888654656,7.2127408808179139E-3,1.4594554324621001,0.86867753015840132,null,147,"     SLATE",0.58644913858860848,0.58644913858860848,9.0019264510539099E-3,1.8496377486168023,0.81156835374378811]
[null,148,0.84571428571428398,0.38345353775052016,0.62817855976736447,1.4541766536954048E-3,1.3791825293999804,0.87891406340654155,null,148,"     SMART",0.44003443092991945,0.59545106503966239,2.2012650604552597E-4,1.7482051431523635,0.82776295290240143]
[null,149,0.85142857142856965,0.53255335484215849,0.62963273642105988,1.136157859100928E-3,1.3631381375756841,0.88090796649229952,null,149,"     SOTHE",0.79185625350122713,0.59567119154570791,1.0445710819739773E-3,1.74571256842678,0.82814750485917421]
[null,150,0.85714285714285532,0.39845650286768297,0.63076889428016081,3.468017798869516E-3,1.3506392561977523,0.88244960313189202,null,150,"     SPIRI",0.51325252063605031,0.59671576262768189,1.5008696896008034E-2,1.7338791040661894,0.82996484602786014]
[null,151,0.86285714285714099,0.63423691207903032,0.63423691207903032,1.6356861377373466E-3,1.3126999571523712,0.88706776187093184,null,151,"     STAGI",0.4445236744183711,0.61172445952368992,1.2403145139328053E-4,1.5635808858169,0.8547099087917952]
[null,152,0.86857142857142666,0.63735210097555073,0.63587259821676767,1.4795027587830578E-3,1.294923929260589,0.88920037827381881,null,152,"     STORE",0.46236865150549705,0.6118484909750832,9.5982982934150751E-4,1.5621767997248708,0.85490375492164161]
[null,153,0.87428571428571233,0.598702939392874,0.63735210097555073,1.9322310335279091E-4,1.2789143343967884,0.89110437042506996,null,153,"     STRAT",0.55061813102662438,0.61280832080442471,1.9281762643136302E-3,1.5513158113256131,0.85639796578566152]
[null,154,0.87999999999999801,0.58780153772419586,0.63754532407890352,4.4765187722997091E-3,1.2768284617903527,0.89135128468352809,null,154,"     SUMMI",0.39452183046662082,0.61473649706873834,2.6613734630451802E-3,1.529525248138293,0.85936816174886599]
[null,155,0.88571428571428368,0.52313127117548464,0.64202184285120323,8.3170450665821516E-3,1.2288418045049057,0.89695937848241591,null,155,"     SUMMI02",0.53921380393332174,0.61739787053178352,1.0803096060419959E-3,1.499520735725109,0.86339885287360429]
[null,156,0.89142857142856935,0.24423409196991039,0.65033888791778538,1.8117223501858959E-3,1.1415684912159849,0.9068149933773495,null,156,"     SUNOC",0.45665442098708248,0.61847818013782552,2.012409655616787E-2,1.4873687619850298,0.86501223404476724]
[null,157,0.89714285714285502,0.59117396302506009,0.65215061026797128,6.4642260662073348E-3,1.1229117219948634,0.9088662780041582,null,157,"     SUNST",0.31412724422384602,0.63860227669399339,1.9963901253811089E-3,1.265439313481475,0.89269480985255378]
[null,158,0.90285714285714069,0.83552460198540646,0.65861483633417861,1.5802076684789945E-4,1.0574661879757816,0.91591254044906956,null,158,"     TANGE",0.67726100973615877,0.6405986668193745,5.6616761935257554E-4,1.2440257519162949,0.89519972373911438]
[null,159,0.90857142857142636,0.57568325523328634,0.65877285710102651,4.7020141586704423E-3,1.0558891063474751,0.91607951744649774,null,159,"     TERRE",0.30628814839156243,0.64116483443872707,6.0244353195746392E-3,1.2379770289028176,0.89590233803185293]
[null,160,0.91428571428571204,0.65215061026797128,0.66347487125969695,1.4058214878821529E-3,1.0094814803447703,0.92093482086300371,null,160,"     TOLLB",0.38248589538763073,0.64718926975830171,2.2991190463964584E-2,1.1743128109895244,0.90316802402084417]
[null,161,0.91999999999999771,0.60056145921122295,0.66488069274757911,4.3835891097881996E-3,0.99580594036771908,0.92234434797894727,null,161,"     TRANS",0.18672667019628605,0.67018046022226629,3.6459170068370295E-3,0.94510734089713688,0.92748693746217681]
[null,{"$f":"IF(B169=\"\", \"\", IF(B169<$F$7, B169+1, \"\"))","v":162},0.92571428571428338,0.23709159199774815,0.6692642818573673,6.5296966461314554E-4,0.95377325313154049,0.92661708398649034,null,162,"     TRANS02",0.70276036410073828,0.67382637722910332,3.292375210087739E-4,0.9110389197150861,0.93087041097242162]
[null,163,0.93142857142856905,0.51426405618504401,0.66991725152198045,9.7589893715865905E-4,0.94759269847224414,0.92723784997915337,null,163,"     TRIBU",0.34401302689340524,0.6741556147501121,8.8911169176864036E-4,0.9079956771193417,0.93116985804064667]
[null,164,0.93714285714285472,0.5129229389676272,0.67089315045913911,1.8758403139270019E-2,0.93839509373470209,0.92815811285237548,null,164,"     TRUEN",0.57804375675698871,0.67504472644188074,2.2162832942780319E-3,0.89980517104628954,0.93197352346182882]
[null,165,0.9428571428571404,0.40825496466068883,0.68965155359840913,4.7162719224771443E-3,0.77124140971479949,0.94416391530986266,null,165,"     UNIVE",0.54400330452130585,0.67726100973615877,2.5499354364579507E-2,0.87956684653951633,0.93394527255056725]
[null,166,0.94857142857142607,0.41742516775566807,0.69436782552088627,6.2345564790328156E-3,0.73222068381163707,0.9477087955122776,null,166,"     URBAN",0.63860227669399339,0.70276036410073828,6.0280285704530367E-3,0.66588045083737968,0.95357281367930402]
[null,167,0.95428571428571174,0.43623983674007855,0.70060238199991909,2.7005522004555083E-3,0.68255702818448238,0.95211790938961949,null,167,"     URSTA",0.25529438536939697,0.70878839267119131,1.2689797156810401E-2,0.62070485003023179,0.95744955688067479]
[null,168,0.95999999999999741,0.60363604479736843,0.7033029342003746,4.5085073954087229E-2,0.6617292872678795,0.95393297359418594,null,168,"     VORNA",0.53136939604347977,0.72147818982800171,2.5318100518545439E-4,0.53239548870368725,0.96475613435733243]
[null,169,0.96571428571428308,0.52124767515338044,0.74838800815446183,2.0032692089861914E-3,0.37500323232565985,0.97687588018791538,null,169,"     WPCAR",0.49939820117535966,0.72173137083318717,2.8982160407804436E-3,0.5307270013598393,0.96489071549091365]
[null,170,0.97142857142856875,0.74838800815446183,0.75039127736344802,8.5133324621958439E-2,0.36485003700724222,0.97761690793262213,null,170,"     WASHI",0.61847818013782552,0.72462958687396761,5.6193131701743892E-3,0.51188623532103705,0.96640145985372727]
[null,171,0.97714285714285443,0.2727564649485909,0.83552460198540646,1.3075730411716835E-3,9.5480861636807343E-2,0.99520240747650779,null,171,"     WASHI02",0.5407362228899244,0.730248900044142,2.1187236574713442E-3,0.47670479064952104,0.96917823106097478]
[null,172,0.9828571428571401,0.65877285710102651,0.83683217502657814,1.9104987276094887E-2,9.3287256150351577E-2,0.99532581679725063,null,172,"     WEING",0.52466606544059657,0.73236762370161335,1.3120106814259458E-3,0.4638982832111902,0.97017462597306492]
[null,173,0.98857142857142577,0.4576392363983029,0.85593716230267303,1.0116141407368717E-2,6.5820900871967736E-2,0.99683262263106021,null,173,"     WHITE",0.61280832080442471,0.73367963438303929,5.8176619118187833E-2,0.45609280855055473,0.97077813462453511]
[null,174,0.99428571428571144,0.38278099640169444,0.86605330371004174,9.0463945745637986E-3,5.4344223891948158E-2,0.99743881619531305,null,174,"     WPTIN",0.45799976610709892,0.79185625350122713,6.6674623073784911E-2,0.1981544512688547,0.98901592342207689]
[null,175,0.99999999999999711,0.70060238199991909,0.87509969828460554,"",4.5601108702588315E-2,0.99788987740386037,null,175,"     XENIA",0.4206733818839255,0.85853087657501204,"",6.2694298896766046E-2,0.99699925998195249]
[null,"","",null,null,"",null,null,null,"",null,null,null,""]
[null,"","",null,null,"",null,null,null,"",null,null,null,""]
[null,"","",null,null,"",null,null,null,"",null,null,null,""]
[null,"","",null,null,"",null,null,null,"",null,null,null,""]
[null,"","",null,null,"",null,null,null,"",null,null,null,""]
[null,"","",null,null,"",null,null,null,"",null,null,null,""]
[null,"","",null,null,"",null,null,null,"",null,null,null,""]
[null,"","",null,null,"",null,null,null,"",null,null,null,""]
[null,"","",null,null,"",null,null,null,"",null,null,null,""]
[null,"","",null,null,"",null,null,null,"",null,null,null,""]
[null,"","",null,null,"",null,null,null,"",null,null,null,""]
[null,"","",null,null,"",null,null,null,"",null,null,null,""]
[null,"","",null,null,"",null,null,null,"",null,null,null,""]
[null,"","",null,null,"",null,null,null,"",null,null,null,""]
[null,"","",null,null,"",null,null,null,"",null,null,null,""]
[null,"","",null,null,"",null,null,null,"",null,null,null,""]
[null,"","",null,null,"",null,null,null,"",null,null,null,""]
[null,"","",null,null,"",null,null,null,"",null,null,null,""]
[null,"","",null,null,{"$f":"IF($B203=\"\", \"\", E203-E202)","v":""},null,null,null,"",null,null,null,{"$f":"IF($B203=\"\", \"\", M203-M202)","v":""}]
[null,"","",null,null,"",null,null,null,{"$f":"IF(K203=\"\", \"\", J202+1)","v":""},null,null,null,""]
[null,"","",null,null,"",null,null,null,"",null,null,null,""]
[null,"","",null,null,"",null,null,null,"",null,null,null,""]
[null,"","",null,null,"",null,null,null,"",null,null,null,""]
[null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,""]

{"sheet":"calc","index":3,"n_rows":35,"n_cols":16,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
[]
[null,"TAB: DISTRIBUTION CALCULATOR"]
[]
[]
[null,"Distribution Object",null,null,null,null,null,null,"Distribution Histogram"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,"Object Description","Abbr","Object value","Parameters",null,null,null,"Object Description","Abbr","Object value",null,null,null,null," "]
[null,"Matched or alternative distribution based on generated sampe",null,null,null,null,null,null,{"$f":"B8","v":"Matched or alternative distribution based on generated sampe"}]
[null,"Distribution index",null,{"$f":"D15","v":10},{"$f":"IF(OFFSET(config!E7, $D$9,0)=\"\", \"\", OFFSET(config!E7, $D$9,0))","v":"mean"},{"$f":"IF(OFFSET(config!F7, $D$9,0)=\"\", \"\", OFFSET(config!F7, $D$9,0))","v":"stdev"},{"$f":"IF(OFFSET(config!G7, $D$9,0)=\"\", \"\", OFFSET(config!G7, $D$9,0))","v":""}," ","Histogram parameters",null,{"$f":"_xll.AC.data.map(test!C32:C34, test!D32:D34)","v":"java.util.LinkedHashMap@Mon, 3 Dec 2018 14:12:30:350..8127087316467667413"},null,null,null,{"$f":"_xll.AC.data.size(K9, 1)","v":3}," "]
[null,"Distribution",null,{"$f":"config!C17","v":"Normal"},{"$f":"IF(OFFSET(test!V12, $D$9,0)=\"\", \"\", OFFSET(test!V12, $D$9,0))","v":0.45746052873075166},{"$f":"IF(OFFSET(test!W12, $D$9,0)=\"\", \"\", OFFSET(test!W12, $D$9,0))","v":0.14596581623061439},{"$f":"IF(OFFSET(test!X12, $D$9,0)=\"\", \"\", OFFSET(test!X12, $D$9,0))","v":""}," ","Histogram object","H(x)",{"$f":"_xll.AC.stats.sample.calc.hist(D27, K9)","v":"jmathkr.lib.stats.basic.calc.Histogram@Mon, 3 Dec 2018 14:23:36:629..2347371617678546836"},null,null,null," "," "]
[null,"Distribution object parameters",null,{"$f":"_xll.AC.data.map(E9:F9, E10:F10)","v":"java.util.LinkedHashMap@Mon, 3 Dec 2018 14:05:25:827..6594279504195519501"},null,null,null," ","Histogram output object",null,{"$f":"_xll.AC.stats.sample.calc.get(calc!K10, \"\")","v":"java.util.ArrayList@Mon, 3 Dec 2018 14:23:36:629..5817613651396862894"},null,null,null,{"$f":"_xll.AC.data.size(K11, 1)","v":40}," "]
[null,"Distribution object","D",{"$f":"_xll.AC.stats.distrib.fn(D10, D11)","v":"jmathkr.lib.stats.distribution.R1.standard.apache.DistributionNormalR1Apache@Mon, 3 Dec 2018 14:23:36:629..8386079392809813382"},null,null,null," ","Histogram domain",null,{"$f":"_xll.AC.data.list_x(OFFSET(test!H11, 0, 0, O11, 1), 1, 1)","v":"java.util.ArrayList@Mon, 3 Dec 2018 14:23:36:629..311239986441632745"},null,null,null,{"$f":"_xll.AC.data.size(K12, 1)","v":40}," "]
[null,null,null,null,null,null,null,null,"Sample pdf values","pdf(x)",{"$f":"_xll.AC.stats.distrib.pdf(D12, K12, 1)","v":"java.util.ArrayList@Mon, 3 Dec 2018 14:23:36:629..483255320158721075"},null,null,null,{"$f":"_xll.AC.data.size(K13, 1)","v":40}," "]
[null,"Matched distribution based on historical sample",null,null,null,null,null," ",{"$f":"B14","v":"Matched distribution based on historical sample"},null,null,null,null,null,null," "]
[null,{"$f":"B9","v":"Distribution index"},null,10,{"$f":"IF(OFFSET(config!E7, $D$15,0)=\"\", \"\", OFFSET(config!E7, $D$15,0))","v":"mean"},{"$f":"IF(OFFSET(config!F7, $D$15,0)=\"\", \"\", OFFSET(config!F7, $D$15,0))","v":"stdev"},{"$f":"IF(OFFSET(config!G7, $D$15,0)=\"\", \"\", OFFSET(config!G7, $D$15,0))","v":""}," ",{"$f":"I9","v":"Histogram parameters"},null,{"$f":"_xll.AC.data.map(test!C32:C34, test!E32:E34)","v":"java.util.LinkedHashMap@Mon, 3 Dec 2018 14:12:30:350..8127087316467667413"},null,null,null,{"$f":"_xll.AC.data.size(K15, 1)","v":3}," "]
[null,{"$f":"B10","v":"Distribution"},null,{"$f":"D10","v":"Normal"},{"$f":"IF(OFFSET(test!V12, $D$15,0)=\"\", \"\", OFFSET(test!V12, $D$15,0))","v":0.45746052873075166},{"$f":"IF(OFFSET(test!W12, $D$15,0)=\"\", \"\", OFFSET(test!W12, $D$15,0))","v":0.14596581623061439},{"$f":"IF(OFFSET(test!X12, $D$15,0)=\"\", \"\", OFFSET(test!X12, $D$15,0))","v":""}," ",{"$f":"I10","v":"Histogram object"},{"$f":"J10","v":"H(x)"},{"$f":"_xll.AC.stats.sample.calc.hist(D32, K15)","v":"jmathkr.lib.stats.basic.calc.Histogram@Mon, 3 Dec 2018 14:23:36:629..8837194665079754400"},null,null,null," "," "]
[null,{"$f":"B11","v":"Distribution object parameters"},null,{"$f":"_xll.AC.stats.distrib.get(D18, config!N25)","v":"java.util.ArrayList@Mon, 3 Dec 2018 14:05:23:210..7990039091190993303"},null,null,null," ",{"$f":"I11","v":"Histogram output object"},null,{"$f":"_xll.AC.stats.sample.calc.get(calc!K16, \"\")","v":"java.util.ArrayList@Mon, 3 Dec 2018 14:12:30:350..4966281083386062117"},null,null,null,{"$f":"_xll.AC.data.size(K17, 1)","v":40}," "]
[null,{"$f":"B12","v":"Distribution object"},null,{"$f":"_xll.AC.stats.distrib.fn(D16, D31)","v":"jmathkr.lib.stats.distribution.R1.standard.apache.DistributionNormalR1Apache@Mon, 3 Dec 2018 14:21:13:693..5945545458206773632"},null,null,null," ",{"$f":"I12","v":"Histogram domain"},null,{"$f":"_xll.AC.data.list_x(OFFSET(test!M11,0, 0, O11, 1), 1, 1)","v":"java.util.ArrayList@Mon, 3 Dec 2018 14:14:04:085..2772695393865934484"},null,null,null,{"$f":"_xll.AC.data.size(K18, 1)","v":40}," "]
[null,null,null,null,null,null,null,null,{"$f":"I13","v":"Sample pdf values"},{"$f":"J13","v":"pdf(x)"},{"$f":"_xll.AC.stats.distrib.pdf(D18, K18, 1)","v":"java.util.ArrayList@Mon, 3 Dec 2018 14:14:04:085..6841351965175992875"},null,null,null,{"$f":"_xll.AC.data.size(K19, 1)","v":40}," "]
[null,null,null,null,null,null,null," ",null,null,null,null,null,null,null," "]
[null,"Distribution Sample",null,null,null,null,null," ","Distribution Testing",null,null,null,null,null,null," "]
[null,null,null,null,null,null,null," ",null,null,null,null,null,null,null," "]
[null,"Sample size","#x",{"$f":"_xll.AC.data.size(D31, 1)","v":175},null,null,null," ","Test historical sample",null,1,null,null,null,null," "]
[null,null,null,null,null,null,null," ","Test name",null,{"$f":"config!J25","v":"Kolmogorov-Smirnov"},null,null,null,null," "]
[null,"Generated sample",null,null,null,null,null," ",null,null,null,null,null,null,null," "]
[null,"Sample object","x",{"$f":"_xll.AC.stats.distrib.sample(D12, D23)","v":"java.util.ArrayList@Mon, 3 Dec 2018 14:23:36:629..1396116517647908919"},null,null,null," ","Distribution test object","T(D, x)",{"$f":"_xll.AC.stats.distrib.test(K24, IF(K23=1, D18, D12), IF(K23=1, D32, D27))","v":"jmathkr.lib.stats.testing.distribution.TestKolmogorovSmirnov@Mon, 3 Dec 2018 14:21:13:693..3767332949092719882"},null,null,null,null," "]
[null,"Sorted sample object","x-sorted",{"$f":"_xll.AC.data.sort(D26)","v":"java.util.ArrayList@Mon, 3 Dec 2018 14:23:36:629..5037156489196331460"},null,null,null," ",null,null,null,null,null,null,null," "]
[null,"Sample pdf values","pdf(x)",{"$f":"_xll.AC.stats.distrib.pdf(D12, D27, 0)","v":"java.util.ArrayList@Mon, 3 Dec 2018 14:23:36:629..4937623635342669637"},null,null,null," ","Test against multiple distributions",null,null,null,null,null,null," "]
[null,"Sample cdf values","cdf(x)",{"$f":"_xll.AC.stats.distrib.cdf(D12, D27)","v":"java.util.ArrayList@Mon, 3 Dec 2018 14:23:36:629..5433752167123387836"},null,null,null," ","List of distributions",null,{"$f":"_xll.AC.data.list_x(config!D8:D21, 0, 1)","v":"java.util.ArrayList@Mon, 3 Dec 2018 14:05:25:730..2230462459768513354"},null,null,null,null," "]
[null,"Historical sample",null,null,null,null,null," ","List of distribution test objects",null,{"$f":"_xll.AC.stats.distrib.test(K24, K29, IF(K23=1, D31, D26))","v":"java.util.ArrayList@Mon, 3 Dec 2018 14:07:22:928..3492220052363887442"},null,null,null,null," "]
[null,{"$f":"B26","v":"Sample object"},{"$f":"C26","v":"x"},{"$f":"_xll.AC.data.list_x(data!L9:L500, 1, 1)","v":"java.util.ArrayList@Mon, 3 Dec 2018 14:05:23:093..7998275976663790045"},null,null,null," ","Estimated distribution parameters ","D-params",{"$f":"_xll.AC.stats.distrib.get(K30, config!N25)","v":"java.util.ArrayList@Mon, 3 Dec 2018 14:05:25:815..4554001326695000499"},null,null,null,null," "]
[null,{"$f":"B27","v":"Sorted sample object"},"x-sorted",{"$f":"_xll.AC.data.sort(D31)","v":"java.util.ArrayList@Mon, 3 Dec 2018 14:05:23:143..5193277344128936534"},null,null,null," ","Estimated tests p-values","P-value",{"$f":"_xll.AC.stats.distrib.get(K30, config!N27)","v":"java.util.ArrayList@Mon, 3 Dec 2018 14:05:25:810..1904297952569768451"},null,null,null,null," "]
[null,{"$f":"B27","v":"Sorted sample object"},"pdf(x)",{"$f":"_xll.AC.stats.distrib.pdf(D18, D32, 0)","v":"java.util.ArrayList@Mon, 3 Dec 2018 14:05:23:210..624569471975776218"},null,null,null," ",null,null,null,null,null,null,null," "]
[null,"Sample cdf values","cdf(x)",{"$f":"_xll.AC.stats.distrib.cdf(D18, D32)","v":"java.util.ArrayList@Mon, 3 Dec 2018 14:05:23:210..8264033431382009645"},null,null,null," ",null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null," "]

{"sheet":"config","index":4,"n_rows":41,"n_cols":22,"rows_kept":41,"cut":false,"hidden":false,"merged":[[2,18,3,21],[14,19,14,21],[11,18,12,21],[5,4,5,6],[5,9,5,11],[5,12,5,14],[5,19,5,21],[5,15,5,16]]}
[]
[null,"TAB: CONFIGURATION FILE",null,null,null,"Calculation enabled",null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"calc!B8","v":"Matched or alternative distribution based on generated sampe"}]
[null,"Standard distributions"]
[]
[null,"#","Distribution name","Notation","Parameters",null,null,"Default values",null,"Parameter values",null,null,"Statistics",null,null,"Distribution support",null,null,"Name","Parameters"]
[null,null,null,null,"p1","p2","p3",null,null,"v1","v2","v3","mean","stdev","mode","min","max",null,null,"p1","p2","p3"]
[null,1,"Beta","Beta","alpha","beta",null,null,null,{"$f":"IF($S$8=$C8, IF(T$9=\"\", \"\", T$9), IF($S$17=$C8, IF(T$18=\"\", \"\", T$18), \"\"))","v":""},{"$f":"IF($S$8=$C8, IF(U$9=\"\", \"\", U$9), IF($S$17=$C8, IF(U$18=\"\", \"\", U$18), \"\"))","v":""},{"$f":"IF($S$8=$C8, IF(V$9=\"\", \"\", V$9), IF($S$17=$C8, IF(V$18=\"\", \"\", V$18), \"\"))","v":""},{"$f":"IF(OR($S$8=C8, $S$17=C8), J8/(J8+K8), \"\")","v":""},null,{"$f":"IF(OR($S$8=C8, $S$17=C8), (J8-1)/(J8+K8-2), \"\")","v":""},0,1,null,{"$f":"calc!D10","v":"Normal"},{"$f":"IF(calc!E9=\"\", \"\", calc!E9)","v":"mean"},{"$f":"IF(calc!F9=\"\", \"\", calc!F9)","v":"stdev"},{"$f":"IF(calc!G9=\"\", \"\", calc!G9)","v":""}]
[null,{"$f":"B8+1","v":2},"Chi-squred ","Chi2","mu",null,null,null,null,"","","",{"$f":"IF(OR($S$8=C9, $S$17=C9), J9, \"\")","v":""},null,null,0,{"$f":"IF(M9=\"\", \"\", M9+$Q$22*N9)","v":""},null,null,{"$f":"IF(calc!E10=\"\", \"\", calc!E10)","v":0.45746052873075166},{"$f":"IF(calc!F10=\"\", \"\", calc!F10)","v":0.14596581623061439},{"$f":"IF(calc!G10=\"\", \"\", calc!G10)","v":""}]
[null,{"$f":"B9+1","v":3},"Exponential","Exponential","mu",null,null,null,null,"","","",{"$f":"IF(OR($S$8=C10, $S$17=C10), 1/J9, \"\")","v":""},null,null,0,""]
[null,4,"Fisher","F","df1","df2",null,null,null,"","","",{"$f":"IF(OR($S$8=C11, $S$17=C11), J11/(J11-2), \"\")","v":""},null,{"$f":"IF(OR($S$8=C11, $S$17=C11), J11*(K11-2)/((J11+2)*K11), \"\")","v":""},0,""]
[null,5,"Gamma","Gamma","alpha","beta",null,null,null,"","","",{"$f":"IF(OR($S$8=C12, $S$17=C12), J12/K12, \"\")","v":""},{"$f":"IF(OR($S$8=C12, $S$17=C12), SQRT(J12/(K12*K12)), \"\")","v":""},null,0,"",null,{"$f":"calc!B14","v":"Matched distribution based on historical sample"}]
[null,6,"Geometric","Geometric","mu",null,null,null,null,"","","",{"$f":"IF(OR($S$8=C13, $S$17=C13), 1/J13, \"\")","v":""},null,null,0,""]
[null,7,"Laplace","Laplace","mu","b",null,null,null,"","","",{"$f":"IF(OR($S$8=C14, $S$17=C14), J14, \"\")","v":""},{"$f":"IF(OR($S$8=C14, $S$17=C14), SQRT(2*K14*K14), \"\")","v":""},null,{"$f":"IF(M14=\"\", \"\", M14-$Q$22*N14)","v":""},""]
[null,8,"Logistic","Logistic","mu","s",null,null,null,"","","",{"$f":"IF(OR($S$8=C15, $S$17=C15), J15, \"\")","v":""},{"$f":"IF(OR($S$8=C15, $S$17=C15), SQRT(K15*K15*PI()*PI()/3), \"\")","v":""},null,{"$f":"IF(M15=\"\", \"\", M15-$Q$22*N15)","v":""},"",null,"Name","Parameters"]
[null,9,"Log-Normal","Log-Normal","mean","stdev",null,"μ = 0; σ = 1",null,"","","",{"$f":"IF(OR($S$8=C16, $S$17=C16), EXP(J16+K16*K16/2), \"\")","v":""},{"$f":"IF(OR($S$8=C16, $S$17=C16), SQRT((EXP(K16*K16)-1)*EXP(2*J16+K16*K16)), \"\")","v":""},null,{"$f":"IF(M16=\"\", \"\", M16-$Q$22*N16)","v":""},"",null,null,"p1","p2","p3"]
[null,10,"Normal","Normal","mean","stdev",null,"μ = 0; σ = 1",null,0.45746052873075166,0.14596581623061439,"",{"$f":"IF(OR($S$8=C17, $S$17=C17), J17, \"\")","v":0.45746052873075166},{"$f":"IF(OR($S$8=C17, $S$17=C17), K17, \"\")","v":0.14596581623061439},null,{"$f":"IF(M17=\"\", \"\", M17-$Q$22*N17)","v":1.9563080038908498E-2},0.89535797742259482,null,{"$f":"calc!D16","v":"Normal"},{"$f":"IF(calc!E15=\"\", \"\", calc!E15)","v":"mean"},{"$f":"IF(calc!F15=\"\", \"\", calc!F15)","v":"stdev"},{"$f":"IF(calc!G15=\"\", \"\", calc!G15)","v":""}]
[null,11,"Poisson","Poisson","lambda","scale",null,null,null,"","","",{"$f":"IF(OR($S$8=C18, $S$17=C18), J18/K18, \"\")","v":""},{"$f":"IF(OR($S$8=C18, $S$17=C18), SQRT(J18)/K18, \"\")","v":""},null,0,"",null,null,{"$f":"_xll.AC.data._get(calc!D17, \"X\", 1)","v":0.45746052873075166},0.14596581623061439,{"$f":"IF(calc!G16=\"\", \"\", calc!G16)","v":""}]
[null,12,"Student T","T","nu",null,null,null,null,"","","",null,{"$f":"IF(OR($S$8=C19, $S$17=C19), IF(J19>2, SQRT(J19/(J19-2)), \"\"), \"\")","v":""},null,{"$f":"IF(M19=\"\", \"\", M19-$Q$22*N19)","v":""},""]
[null,13,"Triangular","Triangular","a","b","c",null,null,"","","",{"$f":"IF(OR($S$8=C20, $S$17=C20), (J20+K20+L20)/3, \"\")","v":""},null,null,{"$f":"IF(J20=\"\", \"\", J20)","v":""},{"$f":"IF(K20=\"\", \"\", K20)","v":""}]
[null,14,"Uniform","Uniform","a","b",null,"a = 0; b = 1",null,"","","",{"$f":"IF(OR($S$8=C21, $S$17=C21), (J21+K21)/2, \"\")","v":""},null,null,{"$f":"IF(J21=\"\", \"\", J21)","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"deviation from mean",null,3]
[null,"Array parameters",null,null,null,null,null,null,null,"Distribution tests",null,null,null,"Output keys"]
[null,"#","Cell address","Row count","Col count","Comment",null,null,null,"Name",null,"Description",null,"Key","Description"]
[null,1,{"$f":"addressFla(data!D9)","v":"'data'!$D$9"},{"$f":"calc!D23","v":175},1,"generated sample",null,null,null,"Kolmogorov-Smirnov",null,null,null,"distrib-params","Parameters of tested distributions"]
[null,{"$f":"B25+1","v":2},{"$f":"addressFla(data!E9)","v":"'data'!$E$9"},{"$f":"D25","v":175},1,"sorted generated sample",null,null,null,"Pearson-Chi2",null,null,null,"stats-value","Estimated statistics"]
[null,{"$f":"B26+1","v":3},{"$f":"addressFla(data!G9)","v":"'data'!$G$9"},{"$f":"D26","v":175},{"$f":"E26","v":1},"pdf of generated sample",null,null,null,null,null,null,null,"p-value","Estimated statistics p-values"]
[null,4,{"$f":"addressFla(test!K11)","v":"'test'!$K$11"},{"$f":"test!D34","v":40},{"$f":"E26","v":1},"pdf of generated sample"]
[null,5,{"$f":"addressFla(data!H9)","v":"'data'!$H$9"},{"$f":"D26","v":175},1,"cdf of generated sample",null,null,null,"Test connection",null,{"$f":"_xll.AC.test.connection()","v":"host: CA2013466W3; user: Konstantin.Rybakov; key: null"}]
[null,6,{"$f":"addressFla(test!H11)","v":"'test'!$H$11"},{"$f":"test!D34","v":40},3,"histogram of generated sample"]
[null,7,{"$f":"addressFla(data!M9)","v":"'data'!$M$9"},{"$f":"D26","v":175},{"$f":"E26","v":1},"sorted historical sample"]
[null,8,{"$f":"addressFla(data!O9)","v":"'data'!$O$9"},{"$f":"D31","v":175},{"$f":"E31","v":1},"pdf of historical sample",null,null,null,"Graph configuration"]
[null,9,{"$f":"addressFla(test!P11)","v":"'test'!$P$11"},{"$f":"test!E34","v":40},{"$f":"E28","v":1},"pdf of historical sample"]
[null,10,{"$f":"addressFla(data!P9)","v":"'data'!$P$9"},175,1,"cdf of historical sample",null,null,null,"line","yes",null,"Set to yes/no to set line visible or non-visible"]
[null,11,{"$f":"addressFla(test!M11)","v":"'test'!$M$11"},{"$f":"test!E34","v":40},3,"histogram of historical sample",null,null,null,"line-size",1.5,null,"Set line size"]
[null,null,null,null,null,null,null,null,null,"marker","no",null,"Set to yes/no to set markers visible or non-visible"]
[null,null,null,null,null,null,null,null,null,"marker-size",3,null,"Set markers size"]
[null,null,null,null,null,null,null,null,null,"exclude-series","sample",null,"List of series names that are not modified"]
[null,null,null,null,null,null,null,null,null,"exclude-charts",null,null,"List of charts that are not modified"]
[null,null,null,null,null,null,null,null,null,"reference-chart",1,null,"Chart index used for series colors mar]tching"]
[null,null,null,null,null,null,null,null,null,"match-colors","yes",null,"Set yes if colors of each series is matched to the series color in the reference chart"]

{"sheet":"guide","index":5,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":false,"merged":[[1,1,32,8]]}
[]
[null,"Package: AC.stats.distrib\n\nAvailable functions:\n\n1.     \n"]