{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Equation 6","Equation 7","Equation 8","Accuracy of C"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":1,"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":"Equation 6","index":0,"n_rows":59,"n_cols":13,"rows_kept":59,"cut":false,"hidden":false,"merged":[[1,0,1,5],[1,6,1,10],[1,11,1,12]]}
["For Illustration Purposes - Equation 6 - Made up data for fifty segments of two-lane, two-way rural roads"]
["Data",null,null,null,null,null,"Computations",null,null,null,null,"Results"]
[null,null,null,null,null,"Observed",null,"Cumul Nu",null,"Crashes+","Cum kj*Crashes2","Estimate of","Estimate of"]
["Site j ","RND","Site J ID","L","AADT","Crashes","Nu",0,"kj","kj*Crashes2 ",0,"V{C}","s{C}"]
[1,0.96617380089370886,"R2 023",7.5059081692368856E-2,3715.3118433825875,0,{"$f":"D5*E5*365*EXP(-0.312)/1000000","v":7.4506044048012851E-2},{"$f":"H4+G5","v":7.4506044048012851E-2},{"$f":"0.236/D5","v":3.1441898125965717},{"$f":"F5+I5*F5^2","v":0},{"$f":"K4+J5","v":0},{"$f":"K5/H5^2","v":0}]
[2,0.95642813289705275,"R2 054",1.1412753694061468,219.76236843257624,1,6.7009558665185362E-2,0.14151560271319821,0.2067862028099324,1.2067862028099323,1.2067862028099323,60.258967427829447,{"$f":"SQRT(L6)","v":7.7626649694437697}]
[3,0.95286274012987704,"R2 043",0.94320109142645459,2133.1181673443884,3,0.53754174307927716,0.67905734579247534,0.2502117545719591,5.2519057911476317,6.4586919939575642,14.00656596346446,3.7425346976967977]
[4,0.94992736159855995,"R2 065",0.65778214659432521,2568.5413448295512,0,0.45140007682450395,1.1304574226169792,0.35878140083596488,0,6.4586919939575642,5.0540106711721595,2.2481126909414839]
[5,0.9098392697702522,"R2 032",1.1291507032929111,1450.8772717168163,0,0.43769901866897731,1.5681564412859565,0.20900664482762105,0,6.4586919939575642,2.6264298256017975,1.6206263682915312]
[6,0.89833999132328479,"R2 076",0.9886167121915701,2867.2631294560774,1,0.75733579499476289,2.3254922362807195,0.23871738874091467,1.2387173887409146,7.6974093826984786,1.4233601314669564,1.1930465755648252]
[7,0.88768409965147255,"R2 134",1.3258247486732921,2167.2530817418956,5,0.76769504382012166,3.0931872801008411,0.17800240962175218,9.4500602405438041,17.147469623242284,1.7922046962201701,1.3387324961396023]
[8,0.84235811164233443,"R2 765",0.77823367130530841,2638.7380023746791,2,0.54865491616193407,3.6418421962627754,0.30325082131715547,3.2130032852686217,20.360472908510907,1.5351316084207807,1.2390042810340813]
[9,0.8374991088095145,"R2 333",0.737065882190441,3482.2073788654084,0,0.68573122602493641,4.3275734222877116,0.32018847392399447,0,20.360472908510907,1.0871737837428448,1.0426762602758561]
[10,0.80875512241201886,"R2 099",1.4000726350027382,1816.0682800996374,2,0.67932207316022464,5.0068954954479361,0.16856268317788986,2.6742507327115597,23.034723641222467,0.91885281989481882,0.95856810915803936]
[11,0.78191519846740642,"R2 022",0.39503710025714689,872.42614293417375,0,9.2078776905624757E-2,5.0989742723535612,0.59741224266373283,0,23.034723641222467,0.88596663075144055,0.94125800434920104]
[12,0.77333364655099435,"R2 098",0.87022058718045869,833.96418595155899,0,0.19389639742888265,5.2928706697824435,0.27119560658136943,0,23.034723641222467,0.82224348626891086,0.90677642573509309]
[13,0.75984164082117656,"R2 234",0.4824369963522761,3645.626080086382,1,0.46990029041300679,5.76277096019545,0.48918304728784212,1.4891830472878422,24.523906688510309,0.73845993375480101,0.8593369151588921]
[14,0.72593502959610445,"R2 123",0.93058211059424956,1239.3503584676075,1,0.30813553293421081,6.0709064931296606,0.25360470324246348,1.2536047032424635,25.777511391752771,0.69941332164564718,0.83630934566441806]
[15,0.72441923133796493,"R2 555",1.7824461264888738,1440.8687420436941,0,0.68617330542115218,6.7570797985508131,0.1324023186411144,0,25.777511391752771,0.56457662320824353,0.75138314008782736]
[16,0.71769969495631369,"R2 443",0.85724660479955617,521.5175888719798,0,0.11944492992628436,6.8765247284770972,0.27530001131375981,0,25.777511391752771,0.54513362277551292,0.73833164822829644]
[17,0.68420015345946883,"R2 767",1.1963924363705702,943.06773632033719,0,0.30144600465348859,7.1779707331305858,0.19725968906652416,0,25.777511391752771,0.50030819998051201,0.70732467791001896]
[18,0.64664927944177131,"R2 236",1.1345028443890488,3647.359548587162,1,1.1055468522529361,8.283517585383521,0.20802063314974803,1.2080206331497481,26.985532024902518,0.39327957108474659,0.62712006114040608]
[19,0.6364614421691468,"R2 763",0.31095060765968174,2842.6352474127261,0,0.23615956095415708,8.5196771463376777,0.75896298057178568,0,26.985532024902518,0.37177887572288376,0.60973672656555944]
[20,0.56965422506418673,"R2 584",1.4401852584550467,3283.0074450333518,0,1.2632322801354299,9.7829094264731076,0.16386780701613909,0,26.985532024902518,0.28196481568691301,0.53100359291337473]
[21,0.56467644229097536,"R2 942",0.39308901307232613,3817.1311433446754,0,0.40088607634970541,10.183795502822813,0.60037292356623906,0,26.985532024902518,0.26020260792863209,0.51010058608928499]
[22,0.56407817571381291,"R2 583",1.6194519421487064,3657.0364171293404,5,1.582305493538142,11.766100996360954,0.14572831330016045,8.6432078325040109,35.628739857406529,0.2573566047439923,0.50730326703461348]
[23,0.53771677787917316,"R2 947",0.15307999092601721,1630.9270537991551,0,6.6703089666714552E-2,11.83280408602767,1.5416776456046277,0,35.628739857406529,0.2544632760467096,0.50444353107826612]
[24,0.52813265471446247,"R2 396",1.5616449756195765,1725.1128107172028,0,0.71976843101837762,12.552572517046048,0.15112269669767159,0,35.628739857406529,0.22611792121778379,0.47551858135911346]
[25,0.51371156751149005,"R2 483",0.86198237971439307,3461.3271663601531,1,0.79713894093701965,13.349711457983068,0.27378749908808531,1.2737874990880853,36.902527356494616,0.20706769686021545,0.45504691720768248]
[26,0.50727841616364344,"R2 846",0.28861342328250972,3069.4322553489569,0,0.23668327216058455,13.586394730143653,0.81770278497750604,0,36.902527356494616,0.19991604644922278,0.44711972272448774]
[27,0.49756417178682089,"R2 490",1.0882165523565952,472.22751618008022,0,0.13729654321410392,13.723691273357757,0.21686859981033046,0,36.902527356494616,0.19593599720086552,0.44264658272810092]
[28,0.49710532545909825,"R2 794",0.10583223423463828,3191.1050830122072,0,9.0230228357435993E-2,13.813921501715193,2.2299444182267725,0,36.902527356494616,0.19338471435355226,0.43975528917063894]
[29,0.44789745363877564,"R2 284",0.53142262184078781,3312.7722832131894,0,0.47035374659292684,14.28427524830812,0.44409099330872048,0,36.902527356494616,0.18085881897644213,0.42527499218322506]
[30,0.44069892188561166,"R2 664",1.5015939090362096,1960.0713876635289,0,0.78635268339907638,15.070627931707197,0.15716632744699624,0,36.902527356494616,0.16247756990016526,0.40308506534001637]
[31,0.36038777511894482,"R2 883",1.6726315934226577,1394.7260376765057,0,0.62327856357834355,15.693906495285541,0.14109502709863325,0,36.902527356494616,0.14982834742637952,0.38707666866704782]
[32,0.35496724021442816,"R2 521",0.7361229612480944,2183.5251228756788,2,0.42943906021651512,16.123345555502056,0.32059861249248722,3.2823944499699489,40.184921806464565,0.15457982234281142,0.39316640540973413]
[33,0.32459459697103288,"R2 403",1.6729723500962681,3565.3007564400241,1,{"$f":"D37*E37*365*EXP(-0.312)/1000000","v":1.5935948613602995},{"$f":"H36+G37","v":17.716940416862354},{"$f":"0.236/D37","v":0.1410662883857105},{"$f":"F37+I37*F37^2","v":1.1410662883857106},{"$f":"K36+J37","v":41.325988094850274},{"$f":"K37/H37^2","v":0.13165755846395802},0.36284646679271665]
[34,0.30040046314932733,"R2 720",0.11630364175212371,1546.5271970458225,0,4.8055584254876924E-2,17.764996001117229,2.0291711974332105,0,41.325988094850274,0.13094623564006475,{"$f":"SQRT(L38)","v":0.36186494115908041}]
[35,0.27026834211749873,"R2 522",1.3032447759216637,3004.0357748142974,3,1.0459816826140893,18.81097768373132,0.18108647305576128,4.6297782575018518,45.955766352352128,0.12987252263769611,0.36037830489319983]
[36,0.25045954019389916,"R2 560",1.5705433417421872,995.09209743387214,0,0.41754778997353909,19.22852547370486,0.15026646748774705,0,45.955766352352128,0.12429339447965612,0.35255268326826861]
[37,0.23875426458953264,"R2 110",1.7566996074554018,70.259475158644946,0,3.2975803887547769E-2,19.261501277592409,0.1343428318640365,0,45.955766352352128,0.12386817672904522,0.35194911099340087]
[38,0.23758971719791511,"R2 389",4.9558932842581171E-2,3209.0710917053975,0,4.2490737637040477E-2,19.303992015229451,4.7620073004725425,0,45.955766352352128,0.12332347513296568,0.35117442266339055]
[39,0.22006093659100401,"R2 174",0.86728199541896567,1588.8092505835552,0,0.36815023030639782,19.672142245535849,0.27211449245639346,0,45.955766352352128,0.11875084281738733,0.34460244168808107]
[40,0.19490886276880737,"R2 945",1.0840783110308592,2205.066024716732,0,0.63866812181219423,20.310810367348044,0.21769645015366612,0,45.955766352352128,0.11140008186537177,0.33376650800428098]
[41,0.19086722621960428,"R2 492",0.7989339312855428,2520.7716408292581,1,0.53806823825450911,20.848878605602554,0.29539363739409441,1.2953936373940944,47.25115998974622,0.10870438751968976,0.32970348423953572]
[42,0.16858476621711294,"R2 237",1.2717933666106083,3033.9489798725508,2,1.0309030269613029,21.879781632563855,0.1855647357470904,2.7422589429883617,49.993418932734585,0.1044303831922869,0.3231569018175024]
[43,0.1483320943078148,"R2 999",1.0183390846375016,1044.5161067968929,1,0.28418460021534953,22.163966232779206,0.23174991862755515,1.2317499186275551,51.225168851362142,0.1042769785652102,0.32291946142221006]
[44,0.12287131982973776,"R2 826",7.1920745440064771E-2,3555.4724307356037,0,6.8319468910739076E-2,22.232285701689946,3.2813897931115137,0,51.225168851362142,0.10363708020362628,0.32192713492904923]
[45,7.2658888599892224E-2,"R2 722",1.4049819115607085,2562.0999043556417,0,0.96174465048007463,23.194030352170021,0.16797369279853719,0,51.225168851362142,9.5220609342666365E-2,0.30857836823514762]
[46,3.0682154389359617E-2,"R2 291",0.12644238175345279,3979.5530763886495,0,0.13443735378503807,23.32846770595506,1.8664627850823878,0,51.225168851362142,9.4126296463388423E-2,0.30680009201984998]
[47,2.445263969777578E-2,"R2 440",1.4328884518103733,1176.5556981481175,0,0.45042020109972181,23.778887907054781,0.16470228349026567,0,51.225168851362142,9.0594184370628036E-2,0.30098867814359404]
[48,1.8106819770483895E-2,"R2 204",0.86061336964272606,2541.9710922238046,0,0.58448272820562763,24.363370635260409,0.27422302316541136,0,51.225168851362142,8.6299574498754986E-2,0.29376789221893357]
[49,1.5413493315930005E-2,"R2 185",1.9279566071983454,2218.9079480128316,1,1.1429560394966496,25.506326674757059,0.12240939402829654,1.1224093940282964,52.347578245390437,8.0463840874406098E-2,0.28366148993898715]
[50,1.0747758855175427E-2,"R2 452",0.39599846280214557,3186.1846248420738,0,0.33709896860789396,25.843425643364952,0.59596190937214244,0,52.347578245390437,7.8378407232187364E-2,0.27996143883075642]
["Sum",null,null,{"$f":"AVERAGE(D5:D54)","v":0.93641031160452981},{"$f":"AVERAGE(E5:E54)","v":2284.1700278275403},{"$f":"SUM(F5:F54)","v":34},{"$f":"SUM(G5:G54)","v":25.843425643364952}]
[]
["Possible Approximation",null,null,"Nu bar=",{"$f":"E55*D55*365*EXP(-0.312)/1000000","v":0.57146232277107811}]
[null,null,null,"k bar=",{"$f":"0.236/D55","v":0.25202627211101114}]
[null,null,null,"n=",{"$f":"D3/(0.061*E57)+D3^2*E58/0.061","v":0}]

{"sheet":"Equation 7","index":1,"n_rows":55,"n_cols":13,"rows_kept":55,"cut":false,"hidden":false,"merged":[[1,10,3,10],[1,11,1,12],[1,0,1,4],[1,5,1,8],[1,9,3,9]]}
["For Illustration Purposes - Equation 7 - Made up data for fifty segments of two-lane, two-way rural roads"]
["Data",null,null,null,null,"Computations",null,null,null,"First term","Second Term","Results"]
[null,null,"C=",1.3,"Observed",null,"Sum Crashes","kj*Crashes2","Sum ",null,null,"Estimate of","Estimate of"]
["Site j","RND","Site J ID","L","Crashes","kj",0,null,0,null,null,"V{C}","s{C}"]
[1,0.96617380089370886,"R2 023",7.5059081692368856E-2,0,{"$f":"0.236/D5","v":3.1441898125965717},{"$f":"G4+E5","v":0},{"$f":"F5*E5^2","v":0},{"$f":"I4+H5","v":0},{"$f":"IF(G5=0,\"\",($D$3)^2/G5)","v":""},{"$f":"IF(G5=0,\"\",$D$3^2*I5/(G5)^2)","v":""},{"$f":"IF(J5=\"\",\"\",K5+J5)","v":""}]
[2,0.95642813289705275,"R2 054",1.1412753694061468,1,0.2067862028099324,1,0.2067862028099324,{"$f":"I5+H6","v":0.2067862028099324},1.6900000000000002,0.34946868274878579,{"$f":"IF(J6=\"\",\"\",K6+J6)","v":2.0394686827487858},{"$f":"SQRT(L6)","v":1.4280996753549053}]
[3,0.95286274012987704,"R2 043",0.94320109142645459,3,0.2502117545719591,4,2.2519057911476317,2.4586919939575642,0.42250000000000004,0.25969934186176774,0.68219934186176778,{"$f":"SQRT(L7)","v":0.82595359546512526}]
[4,0.94992736159855995,"R2 065",0.65778214659432521,0,0.35878140083596488,4,0,2.4586919939575642,0.42250000000000004,0.25969934186176774,0.68219934186176778,0.82595359546512526]
[5,0.9098392697702522,"R2 032",1.1291507032929111,0,0.20900664482762105,4,0,2.4586919939575642,0.42250000000000004,0.25969934186176774,0.68219934186176778,0.82595359546512526]
[6,0.89833999132328479,"R2 076",0.9886167121915701,1,0.23871738874091467,5,0.23871738874091467,2.6974093826984791,0.33800000000000002,0.18234487427041721,0.5203448742704172,0.72134934273929796]
[7,0.88768409965147255,"R2 134",1.3258247486732921,5,0.17800240962175218,10,4.4500602405438041,7.1474696232422836,0.16900000000000001,0.12079223663279461,0.28979223663279463,0.53832354270716665]
[8,0.84235811164233443,"R2 765",0.77823367130530841,2,0.30325082131715547,12,1.2130032852686219,8.3604729085109053,0.14083333333333334,9.8119438995718275E-2,0.2389527723290516,0.48882795780218175]
[9,0.8374991088095145,"R2 333",0.737065882190441,0,0.32018847392399447,12,0,8.3604729085109053,0.14083333333333334,9.8119438995718275E-2,0.2389527723290516,0.48882795780218175]
[10,0.80875512241201886,"R2 099",1.4000726350027382,2,0.16856268317788986,14,0.67425073271155944,9.034723641222465,0.12071428571428573,7.7901443641152895E-2,0.19861572935543864,0.44566324658360446]
[11,0.78191519846740642,"R2 022",0.39503710025714689,0,0.59741224266373283,14,0,9.034723641222465,0.12071428571428573,7.7901443641152895E-2,0.19861572935543864,0.44566324658360446]
[12,0.77333364655099435,"R2 098",0.87022058718045869,0,0.27119560658136943,14,0,9.034723641222465,0.12071428571428573,7.7901443641152895E-2,0.19861572935543864,0.44566324658360446]
[13,0.75984164082117656,"R2 234",0.4824369963522761,1,0.48918304728784212,15,0.48918304728784212,9.5239066885103068,0.11266666666666668,7.1535121349255201E-2,0.18420178801592188,0.42918735770747241]
[14,0.72593502959610445,"R2 123",0.93058211059424956,1,0.25360470324246348,16,0.25360470324246348,9.7775113917527694,0.10562500000000001,6.4546852547117894E-2,0.17017185254711792,0.41251891174480465]
[15,0.72441923133796493,"R2 555",1.7824461264888738,0,0.1324023186411144,16,0,9.7775113917527694,0.10562500000000001,6.4546852547117894E-2,0.17017185254711792,0.41251891174480465]
[16,0.71769969495631369,"R2 443",0.85724660479955617,0,0.27530001131375981,16,0,9.7775113917527694,0.10562500000000001,6.4546852547117894E-2,0.17017185254711792,0.41251891174480465]
[17,0.68420015345946883,"R2 767",1.1963924363705702,0,0.19725968906652416,16,0,9.7775113917527694,0.10562500000000001,6.4546852547117894E-2,0.17017185254711792,0.41251891174480465]
[18,0.64664927944177131,"R2 236",1.1345028443890488,1,0.20802063314974803,17,0.20802063314974803,9.9855320249025166,9.9411764705882366E-2,5.8392903536627176E-2,0.15780466824250955,0.39724635711672618]
[19,0.6364614421691468,"R2 763",0.31095060765968174,0,0.75896298057178568,17,0,9.9855320249025166,9.9411764705882366E-2,5.8392903536627176E-2,0.15780466824250955,0.39724635711672618]
[20,0.56965422506418673,"R2 584",1.4401852584550467,0,0.16386780701613909,17,0,9.9855320249025166,9.9411764705882366E-2,5.8392903536627176E-2,0.15780466824250955,0.39724635711672618]
[21,0.56467644229097536,"R2 942",0.39308901307232613,0,0.60037292356623906,17,0,9.9855320249025166,9.9411764705882366E-2,5.8392903536627176E-2,0.15780466824250955,0.39724635711672618]
[22,0.56407817571381291,"R2 583",1.6194519421487064,5,0.14572831330016045,22,3.6432078325040114,13.628739857406527,7.6818181818181827E-2,4.7587955287225273E-2,0.1244061371054071,0.35271254174668515]
[23,0.53771677787917316,"R2 947",0.15307999092601721,0,1.5416776456046277,22,0,13.628739857406527,7.6818181818181827E-2,4.7587955287225273E-2,0.1244061371054071,0.35271254174668515]
[24,0.52813265471446247,"R2 396",1.5616449756195765,0,0.15112269669767159,22,0,13.628739857406527,7.6818181818181827E-2,4.7587955287225273E-2,0.1244061371054071,0.35271254174668515]
[25,0.51371156751149005,"R2 483",0.86198237971439307,1,0.27378749908808531,23,0.27378749908808531,13.902527356494613,7.3478260869565229E-2,4.4414501384642528E-2,0.11789276225420775,0.34335515469293271]
[26,0.50727841616364344,"R2 846",0.28861342328250972,0,0.81770278497750604,23,0,13.902527356494613,7.3478260869565229E-2,4.4414501384642528E-2,0.11789276225420775,0.34335515469293271]
[27,0.49756417178682089,"R2 490",1.0882165523565952,0,0.21686859981033046,23,0,13.902527356494613,7.3478260869565229E-2,4.4414501384642528E-2,0.11789276225420775,0.34335515469293271]
[28,0.49710532545909825,"R2 794",0.10583223423463828,0,2.2299444182267725,23,0,13.902527356494613,7.3478260869565229E-2,4.4414501384642528E-2,0.11789276225420775,0.34335515469293271]
[29,0.44789745363877564,"R2 284",0.53142262184078781,0,0.44409099330872048,23,0,13.902527356494613,7.3478260869565229E-2,4.4414501384642528E-2,0.11789276225420775,0.34335515469293271]
[30,0.44069892188561166,"R2 664",1.5015939090362096,0,0.15716632744699624,23,0,13.902527356494613,7.3478260869565229E-2,4.4414501384642528E-2,0.11789276225420775,0.34335515469293271]
[31,0.36038777511894482,"R2 883",1.6726315934226577,0,0.14109502709863325,23,0,13.902527356494613,7.3478260869565229E-2,4.4414501384642528E-2,0.11789276225420775,0.34335515469293271]
[32,0.35496724021442816,"R2 521",0.7361229612480944,2,0.32059861249248722,25,1.2823944499699489,15.184921806464562,6.7600000000000007E-2,4.1060028564680183E-2,0.10866002856468018,0.32963620639225932]
[33,0.32459459697103288,"R2 403",1.6729723500962681,1,{"$f":"0.236/D37","v":0.1410662883857105},{"$f":"G36+E37","v":26},{"$f":"F37*E37^2","v":0.1410662883857105},15.325988094850272,{"$f":"IF(G37=0,\"\",($D$3)^2/G37)","v":6.5000000000000002E-2},{"$f":"IF(G37=0,\"\",$D$3^2*I37/(G37)^2)","v":3.8314970237125684E-2},0.10331497023712569,0.32142646163177929]
[34,0.30040046314932733,"R2 720",0.11630364175212371,0,2.0291711974332105,26,0,15.325988094850272,6.5000000000000002E-2,3.8314970237125684E-2,0.10331497023712569,0.32142646163177929]
[35,0.27026834211749873,"R2 522",1.3032447759216637,3,0.18108647305576128,29,1.6297782575018516,16.955766352352125,5.8275862068965525E-2,3.4072824180113072E-2,9.2348686249078604E-2,0.30388926642624053]
[36,0.25045954019389916,"R2 560",1.5705433417421872,0,0.15026646748774705,29,0,16.955766352352125,5.8275862068965525E-2,3.4072824180113072E-2,9.2348686249078604E-2,0.30388926642624053]
[37,0.23875426458953264,"R2 110",1.7566996074554018,0,0.1343428318640365,29,0,16.955766352352125,5.8275862068965525E-2,3.4072824180113072E-2,9.2348686249078604E-2,0.30388926642624053]
[38,0.23758971719791511,"R2 389",4.9558932842581171E-2,0,4.7620073004725425,29,0,16.955766352352125,5.8275862068965525E-2,3.4072824180113072E-2,9.2348686249078604E-2,0.30388926642624053]
[39,0.22006093659100401,"R2 174",0.86728199541896567,0,0.27211449245639346,29,0,16.955766352352125,5.8275862068965525E-2,3.4072824180113072E-2,9.2348686249078604E-2,0.30388926642624053]
[40,0.19490886276880737,"R2 945",1.0840783110308592,0,0.21769645015366612,29,0,16.955766352352125,5.8275862068965525E-2,3.4072824180113072E-2,9.2348686249078604E-2,0.30388926642624053]
[41,0.19086722621960428,"R2 492",0.7989339312855428,1,0.29539363739409441,30,0.29539363739409441,17.25115998974622,5.6333333333333339E-2,3.2393844869634571E-2,8.872717820296791E-2,0.2978710764793519]
[42,0.16858476621711294,"R2 237",1.2717933666106083,2,0.1855647357470904,32,0.74225894298836159,17.993418932734581,5.2812500000000005E-2,2.9696169918282663E-2,8.2508669918282665E-2,0.28724322432092747]
[43,0.1483320943078148,"R2 999",1.0183390846375016,1,0.23174991862755515,33,0.23174991862755515,18.225168851362138,5.1212121212121216E-2,2.8283319888707085E-2,7.9495441100828304E-2,0.281949359106965]
[44,0.12287131982973776,"R2 826",7.1920745440064771E-2,0,3.2813897931115137,33,0,18.225168851362138,5.1212121212121216E-2,2.8283319888707085E-2,7.9495441100828304E-2,0.281949359106965]
[45,7.2658888599892224E-2,"R2 722",1.4049819115607085,0,0.16797369279853719,33,0,18.225168851362138,5.1212121212121216E-2,2.8283319888707085E-2,7.9495441100828304E-2,0.281949359106965]
[46,3.0682154389359617E-2,"R2 291",0.12644238175345279,0,1.8664627850823878,33,0,18.225168851362138,5.1212121212121216E-2,2.8283319888707085E-2,7.9495441100828304E-2,0.281949359106965]
[47,2.445263969777578E-2,"R2 440",1.4328884518103733,0,0.16470228349026567,33,0,18.225168851362138,5.1212121212121216E-2,2.8283319888707085E-2,7.9495441100828304E-2,0.281949359106965]
[48,1.8106819770483895E-2,"R2 204",0.86061336964272606,0,0.27422302316541136,33,0,18.225168851362138,5.1212121212121216E-2,2.8283319888707085E-2,7.9495441100828304E-2,0.281949359106965]
[49,1.5413493315930005E-2,"R2 185",1.9279566071983454,1,0.12240939402829654,34,0.12240939402829654,18.347578245390434,4.9705882352941183E-2,2.6823016639022347E-2,7.6528898991963523E-2,0.27663857104887513]
[50,1.0747758855175427E-2,"R2 452",0.39599846280214557,0,0.59596190937214244,34,0,18.347578245390434,4.9705882352941183E-2,2.6823016639022347E-2,7.6528898991963523E-2,0.27663857104887513]
["Sum",null,null,{"$f":"SUM(D5:D54)","v":46.820515580226491},{"$f":"SUM(E5:E54)","v":34}]

{"sheet":"Equation 8","index":2,"n_rows":59,"n_cols":14,"rows_kept":59,"cut":false,"hidden":false,"merged":[[1,0,1,4],[1,5,1,9],[1,10,3,10],[1,11,3,11],[1,12,1,13]]}
["For Illustration Purposes - Equation 8 - Made up data for fifty segments of two-lane, two-way rural roads"]
["Data",null,null,null,null,"Computations",null,null,null,null,"First term","Second Term","Results"]
[null,null,"C=",1.3,null,null,null,"Cum Nu","kj*Nu2","Cum kj*Nu2",null,null,"Estimate of","Estimate of"]
["Site j","RND","Site J ID","L","AADT","Nu","kj",0,null,0,null,null,"V{C}","s{C}"]
[1,0.96617380089370886,"R2 023",7.5059081692368856E-2,3715.3118433825875,{"$f":"D5*E5*365*EXP(-0.312)/1000000","v":7.4506044048012851E-2},{"$f":"0.236/D5","v":3.1441898125965717},{"$f":"H4+F5","v":7.4506044048012851E-2},{"$f":"G5*F5^2","v":1.7453871163717136E-2},{"$f":"J4+I5","v":1.7453871163717136E-2},{"$f":"IF(H5=0,\"\",$D$3/H5)","v":17.448248885181179},{"$f":"IF(H5=0,\"\",$D$3^2*J5/(H5)^2)","v":5.3136807832882065},{"$f":"IF(K5=\"\",\"\",L5+K5)","v":22.761929668469385},{"$f":"SQRT(M5)","v":4.7709464122403835}]
[2,0.95642813289705275,"R2 054",1.1412753694061468,219.76236843257624,{"$f":"D6*E6*365*EXP(-0.312)/1000000","v":6.7009558665185362E-2},{"$f":"0.236/D6","v":0.2067862028099324},{"$f":"H5+F6","v":0.14151560271319821},{"$f":"G6*F6^2","v":9.2852814771784498E-4},{"$f":"J5+I6","v":1.8382399311434983E-2},{"$f":"IF(H6=0,\"\",$D$3/H6)","v":9.1862662142960847},{"$f":"IF(H6=0,\"\",$D$3^2*J6/(H6)^2)","v":1.5512444821857201},{"$f":"IF(K6=\"\",\"\",L6+K6)","v":10.737510696481804},{"$f":"SQRT(M6)","v":3.2768141077091637}]
[3,0.95286274012987704,"R2 043",0.94320109142645459,2133.1181673443884,0.53754174307927716,0.2502117545719591,0.67905734579247534,7.2298968110085418E-2,9.0681367421520401E-2,1.9144185804850848,0.33234707569629884,2.2467656561813838,{"$f":"SQRT(M7)","v":1.4989214976713703}]
[4,0.94992736159855995,"R2 065",0.65778214659432521,2568.5413448295512,0.45140007682450395,0.35878140083596488,1.1304574226169792,7.3106026329943757E-2,0.16378739375146417,1.149976968606685,0.21660015214385489,1.3665771207505399,1.1690068950825483]
[5,0.9098392697702522,"R2 032",1.1291507032929111,1450.8772717168163,0.43769901866897731,0.20900664482762105,1.5681564412859565,4.0041583086190408E-2,0.20382897683765458,0.8289989224123222,0.14007926570204471,0.96907818811436686,0.98441768986257394]
[6,0.89833999132328479,"R2 076",0.9886167121915701,2867.2631294560774,0.75733579499476289,0.23871738874091467,2.3254922362807195,0.13691815021586753,0.34074712705352211,0.55902143198687149,0.1064851677940591,0.66550659978093063,0.81578587863539942]
[7,0.88768409965147255,"R2 134",1.3258247486732921,2167.2530817418956,0.76769504382012166,0.17800240962175218,3.0931872801008411,0.10490673121873122,0.44565385827225334,0.42027846434103361,7.8717618070987636E-2,0.49899608241202126,0.7063965475651911]
[8,0.84235811164233443,"R2 765",0.77823367130530841,2638.7380023746791,0.54865491616193407,0.30325082131715547,3.6418421962627754,9.1285234548651839E-2,0.53693909282090524,0.35696219933253781,6.8417859395706743E-2,0.42538005872824458,0.65221166712060941]
[9,0.8374991088095145,"R2 333",0.737065882190441,3482.2073788654084,0.68573122602493641,0.32018847392399447,4.3275734222877116,0.15056136617771609,0.68750045899862133,0.30039929381782116,6.2039859731708155E-2,0.36243915354952932,0.60202919659226606]
[10,0.80875512241201886,"R2 099",1.4000726350027382,1816.0682800996374,0.67932207316022464,0.16856268317788986,5.0068954954479361,7.7788050663032585E-2,0.76528850966165396,0.25964192805340292,5.1591106634882485E-2,0.31123303468828539,0.55788263522741532]
[11,0.78191519846740642,"R2 022",0.39503710025714689,872.42614293417375,9.2078776905624757E-2,0.59741224266373283,5.0989742723535612,5.0651603902933722E-3,0.77035367005194733,0.25495323776167084,5.0073877114088068E-2,0.3050271148757589,0.55229259896884264]
[12,0.77333364655099435,"R2 098",0.87022058718045869,833.96418595155899,0.19389639742888265,0.27119560658136943,5.2928706697824435,1.0195819294070882E-2,0.7805494893460182,0.24561340737491227,4.70873862527562E-2,0.29270079362766849,0.54101829324678896]
[13,0.75984164082117656,"R2 234",0.4824369963522761,3645.626080086382,0.46990029041300679,0.48918304728784212,5.76277096019545,0.10801469034411043,0.88856417969012869,0.22558592194264637,4.5218149807563029E-2,0.27080407175020937,0.5203883854874255]
[14,0.72593502959610445,"R2 123",0.93058211059424956,1239.3503584676075,0.30813553293421081,0.25360470324246348,6.0709064931296606,2.4079134249271578E-2,0.91264331393940024,0.21413606048309053,4.1848576867835829E-2,0.25598463735092636,0.50594924384855677]
[15,0.72441923133796493,"R2 555",1.7824461264888738,1440.8687420436941,0.68617330542115218,0.1324023186411144,6.7570797985508131,6.2339487486229382E-2,0.97498280142562965,0.19239080176007545,3.6088228495011754E-2,0.2284790302550872,0.47799480149378948]
[16,0.71769969495631369,"R2 443",0.85724660479955617,521.5175888719798,0.11944492992628436,0.27530001131375981,6.8765247284770972,3.9277303922010927E-3,0.97891053181783072,0.18904898205578086,3.4985790196711344E-2,0.22403477225249219,0.47332311611888572]
[17,0.68420015345946883,"R2 767",1.1963924363705702,943.06773632033719,0.30144600465348859,0.19725968906652416,7.1779707331305858,1.7924927529083444E-2,0.9968354593469142,0.18110968243430281,3.2696917868831027E-2,0.21380660030313384,0.46239225804843859]
[18,0.64664927944177131,"R2 236",1.1345028443890488,3647.359548587162,1.1055468522529361,0.20802063314974803,8.283517585383521,0.25424985777938608,1.2510853171263003,0.15693815901277053,3.0813713104129906E-2,0.18775187211690042,0.43330344115515679]
[19,0.6364614421691468,"R2 763",0.31095060765968174,2842.6352474127261,0.23615956095415708,0.75896298057178568,8.5196771463376777,4.232838109356369E-2,1.2934136982198641,0.15258794173425061,3.0114654560498229E-2,0.18270259629474883,0.42743724252192722]
[20,0.56965422506418673,"R2 584",1.4401852584550467,3283.0074450333518,1.2632322801354299,0.16386780701613909,9.7829094264731076,0.26149300242662366,1.5549067006464878,0.1328848038275941,2.7457119527697037E-2,0.16034192335529113,0.40042717609484391]
[21,0.56467644229097536,"R2 942",0.39308901307232613,3817.1311433446754,0.40088607634970541,0.60037292356623906,10.183795502822813,9.6485720141031156E-2,1.651392420787519,0.12765378091495036,2.691024501603579E-2,0.15456402593098614,0.39314631618646273]
[22,0.56407817571381291,"R2 583",1.6194519421487064,3657.0364171293404,1.582305493538142,0.14572831330016045,11.766100996360954,0.36485861907574607,2.0162510398632651,0.11048689794538283,2.4613091441702404E-2,0.13509998938708523,0.36755950455278019]
[23,0.53771677787917316,"R2 947",0.15307999092601721,1630.9270537991551,6.6703089666714552E-2,1.5416776456046277,11.83280408602767,6.8593896957030555E-3,2.0231104295589684,0.10986406861371575,2.4419172654201241E-2,0.13428324126791699,0.36644677822013527]
[24,0.52813265471446247,"R2 396",1.5616449756195765,1725.1128107172028,0.71976843101837762,0.15112269669767159,12.552572517046048,7.8291620798182637E-2,2.1014020503571511,0.10356442858502796,2.2538778641608383E-2,0.12610320722663634,0.35511013393965024]
[25,0.51371156751149005,"R2 483",0.86198237971439307,3461.3271663601531,0.79713894093701965,0.27378749908808531,13.349711457983068,0.17397292501851544,2.2753749753756667,9.7380381897513288E-2,2.1577241589630987E-2,0.11895762348714428,0.34490233905722395]
[26,0.50727841616364344,"R2 846",0.28861342328250972,3069.4322553489569,0.23668327216058455,0.81770278497750604,13.586394730143653,4.5806868860463458E-2,2.3211818442361301,9.568395632696701E-2,2.1251393516007275E-2,0.11693534984297428,0.34195811124021358]
[27,0.49756417178682089,"R2 490",1.0882165523565952,472.22751618008022,0.13729654321410392,0.21686859981033046,13.723691273357757,4.0880470105900445E-3,2.32526989124672,9.4726701009642492E-2,2.0864990604765186E-2,0.11559169161440767,0.33998778156634935]
[28,0.49710532545909825,"R2 794",0.10583223423463828,3191.1050830122072,9.0230228357435993E-2,2.2299444182267725,13.813921501715193,1.8155079345360831E-2,2.3434249705920807,9.4107962017779434E-2,2.0754094521645918E-2,0.11486205653942536,0.33891305159203494]
[29,0.44789745363877564,"R2 284",0.53142262184078781,3312.7722832131894,0.47035374659292684,0.44409099330872048,14.28427524830812,9.8247425929238949E-2,2.4416723965213194,9.1009167591752801E-2,2.0223563255344787E-2,0.11123273084709759,0.33351571304377486]
[30,0.44069892188561166,"R2 664",1.5015939090362096,1960.0713876635289,0.78635268339907638,0.15716632744699624,15.070627931707197,9.71838838692759E-2,2.5388562803905952,8.6260506588774655E-2,1.8891312217613029E-2,0.10515181880638769,0.32427121180639468]
[31,0.36038777511894482,"R2 883",1.6726315934226577,1394.7260376765057,0.62327856357834355,0.14109502709863325,15.693906495285541,5.4812055425211684E-2,2.5936683358158068,8.283469768285677E-2,1.7796681299004333E-2,0.1006313789818611,0.31722449303586425]
[32,0.35496724021442816,"R2 521",0.7361229612480944,2183.5251228756788,0.42943906021651512,0.32059861249248722,16.123345555502056,5.9124124923319095E-2,2.6527924607391258,8.0628427612926643E-2,1.724565347827469E-2,9.7874081091201326E-2,0.31284833560561148]
[33,0.32459459697103288,"R2 403",1.6729723500962681,3565.3007564400241,1.5935948613602995,0.1410662883857105,17.716940416862354,0.35824412839449804,3.0110365891336239,7.3376100467251459E-2,1.6211577930460571E-2,8.9587678397712034E-2,0.29931200844221406]
[34,0.30040046314932733,"R2 720",0.11630364175212371,1546.5271970458225,4.8055584254876924E-2,2.0291711974332105,17.764996001117229,4.6860445452590986E-3,3.0157226336788829,7.3177612869614148E-2,1.6149083197896031E-2,8.9326696067510175E-2,0.29887572010370828]
[35,0.27026834211749873,"R2 522",1.3032447759216637,3004.0357748142974,1.0459816826140893,0.18108647305576128,18.81097768373132,0.19812266838618176,3.2138453020650646,6.9108582331917037E-2,1.534931279555256E-2,8.4457895127469595E-2,0.29061640546856538]
[36,0.25045954019389916,"R2 560",1.5705433417421872,995.09209743387214,0.41754778997353909,0.15026646748774705,19.22852547370486,2.6198381119198644E-2,3.2400436831842634,6.7607888175188424E-2,1.4809677669226589E-2,8.2417565844415008E-2,0.28708459701700301]
[37,0.23875426458953264,"R2 110",1.7566996074554018,70.259475158644946,3.2975803887547769E-2,0.1343428318640365,19.261501277592409,1.4608488464957865E-4,3.2401897680689129,6.7492143071544289E-2,1.4759678008994456E-2,8.2251821080538745E-2,0.28679578288485824]
[38,0.23758971719791511,"R2 389",4.9558932842581171E-2,3209.0710917053975,4.2490737637040477E-2,4.7620073004725425,19.303992015229451,8.5976269626148547E-3,3.2487873950315276,6.73435835952685E-2,1.4733764961793456E-2,8.207734855706196E-2,0.28649144587066111]
[39,0.22006093659100401,"R2 174",0.86728199541896567,1588.8092505835552,0.36815023030639782,0.27211449245639346,19.672142245535849,3.6880926732678738E-2,3.2856683217642062,6.6083296052569254E-2,1.4348520188900838E-2,8.0431816241470097E-2,0.28360503564194711]
[40,0.19490886276880737,"R2 945",1.0840783110308592,2205.066024716732,0.63866812181219423,0.21769645015366612,20.310810367348044,8.8797722358058592E-2,3.3744660441222649,6.4005324085438714E-2,1.3824112653404731E-2,7.7829436738843447E-2,0.27897927654011051]
[41,0.19086722621960428,"R2 492",0.7989339312855428,2520.7716408292581,0.53806823825450911,0.29539363739409441,20.848878605602554,8.5521606446705478E-2,3.4599876505689702,6.2353473517307606E-2,1.3452278568430325E-2,7.5805752085737935E-2,0.2753284440186628]
[42,0.16858476621711294,"R2 237",1.2717933666106083,3033.9489798725508,1.0309030269613029,0.1855647357470904,21.879781632563855,0.19721097359073964,3.6571986241597099,5.941558384043466E-2,1.2910685017848941E-2,7.2326268858283596E-2,0.26893543622639915]
[43,0.1483320943078148,"R2 999",1.0183390846375016,1044.5161067968929,0.28418460021534953,0.23174991862755515,22.163966232779206,1.8716328990436751E-2,3.6759149531501465,5.8653761982247393E-2,1.2646117125608997E-2,7.1299879107856387E-2,0.2670203720839599]
[44,0.12287131982973776,"R2 826",7.1920745440064771E-2,3555.4724307356037,6.8319468910739076E-2,3.2813897931115137,22.232285701689946,1.5316050378369554E-2,3.6912310035285159,5.847351988199679E-2,1.2620881814895863E-2,7.1094401696892656E-2,0.26663533467433131]
[45,7.2658888599892224E-2,"R2 722",1.4049819115607085,2562.0999043556417,0.96174465048007463,0.16797369279853719,23.194030352170021,0.15536773289920716,3.846598736427723,5.604890483720406E-2,1.2084011973201905E-2,6.8132916810405966E-2,0.26102282814038691]
[46,3.0682154389359617E-2,"R2 291",0.12644238175345279,3979.5530763886495,0.13443735378503807,1.8664627850823878,23.32846770595506,3.3733332405898542E-2,3.8803320688336216,5.5725906064038183E-2,1.2049892432620798E-2,6.7775798496658976E-2,0.26033785452111835]
[47,2.445263969777578E-2,"R2 440",1.4328884518103733,1176.5556981481175,0.45042020109972181,0.16470228349026567,23.778887907054781,3.3414528760674765E-2,3.9137465975942964,5.467034476470671E-2,1.1697588198534196E-2,6.6367932963240908E-2,0.25761974490174644]
[48,1.8106819770483895E-2,"R2 204",0.86061336964272606,2541.9710922238046,0.58448272820562763,0.27422302316541136,24.363370635260409,9.3680085509423514E-2,4.00742668310372,5.33587909268411E-2,1.1409787235990027E-2,6.4768578162831131E-2,0.25449671542641006]
[49,1.5413493315930005E-2,"R2 185",1.9279566071983454,2218.9079480128316,1.1429560394966496,0.12240939402829654,25.506326674757059,0.15990932928120788,4.1673360123849275,5.0967746809522985E-2,1.0825535495377432E-2,6.1793282304900415E-2,0.24858254625958842]
[50,1.0747758855175427E-2,"R2 452",0.39599846280214557,3186.1846248420738,0.33709896860789396,0.59596190937214244,25.843425643364952,6.7722557467639957E-2,4.2350585698525673,5.0302928796661379E-2,1.0716327178041234E-2,6.1019255974702612E-2,0.24702076020995201]
["Sum",null,null,{"$f":"AVERAGE(D5:D54)","v":0.93641031160452981},{"$f":"AVERAGE(E5:E54)","v":2284.1700278275403},{"$f":"SUM(F5:F54)","v":25.843425643364952}]
[]
[null,null,null,"Nu bar=",{"$f":"E55*D55*365*EXP(-0.312)/1000000","v":0.57146232277107811}]
[null,null,null,"k bar=",{"$f":"0.236/D55","v":0.25202627211101114}]
[null,null,null,"n=",{"$f":"D3/(M54*E57)+D3^2*E58/M54","v":44.261274447383848}]

{"sheet":"Accuracy of C","index":3,"n_rows":55,"n_cols":18,"rows_kept":55,"cut":false,"hidden":false,"merged":[[1,5,1,11],[1,14,1,16],[1,0,1,4]]}
["For Illustration Purposes -Coeficient of Variation - Made up data for fifty segments of two-lane, two-way rural roads"]
["Data",null,null,null,null,"Computations",null,null,null,null,null,null,null,null,"Results"]
["C=",1.3,null,null,null,null,"Na",null,"Sum Na","(Sum Na)2","kj*Na2","Sum kj*Na2","First term","Second Term","Estimate of","Estimate of","Estimate of"]
["Site ID","RND","Site J ID","L","AADT","Nu","Crashes","kj",0,null,null,0,null,null,"V{C}","s{C}","s{C}/C","Site j"]
[1,0.96617380089370886,"R2 023",7.5059081692368856E-2,3715.3118433825875,{"$f":"D5*E5*365*EXP(-0.312)/1000000","v":7.4506044048012851E-2},0,{"$f":"0.236/D5","v":3.1441898125965717},{"$f":"I4+G5","v":0},{"$f":"I5^2","v":0},{"$f":"H5*G5^2","v":0},{"$f":"L4+K5","v":0},{"$f":"IF(I5=0,\"\",$B$3/I5)","v":""},{"$f":"IF(I5=0,\"\",$B$3^2*L5/(I5)^2)","v":""},{"$f":"IF(M5=\"\",\"\",N5+M5)","v":""},null,{"$f":"IF(P5=\"\",\"\",P5/$B$3)","v":""},1]
[2,0.95642813289705275,"R2 054",1.1412753694061468,219.76236843257624,6.7009558665185362E-2,1,0.2067862028099324,1,1,0.2067862028099324,0.2067862028099324,{"$f":"IF(I6=0,\"\",$B$3^2/I6)","v":1.6900000000000002},0.34946868274878579,2.0394686827487858,{"$f":"SQRT(O6)","v":1.4280996753549053},{"$f":"P6/$B$3","v":1.0985382118114657},2]
[3,0.95286274012987704,"R2 043",0.94320109142645459,2133.1181673443884,0.53754174307927716,3,0.2502117545719591,4,16,2.2519057911476317,2.4586919939575642,0.42250000000000004,0.25969934186176774,0.68219934186176778,0.82595359546512526,0.63534891958855788,3]
[4,0.94992736159855995,"R2 065",0.65778214659432521,2568.5413448295512,0.45140007682450395,0,0.35878140083596488,4,16,0,2.4586919939575642,0.42250000000000004,0.25969934186176774,0.68219934186176778,0.82595359546512526,0.63534891958855788,4]
[5,0.9098392697702522,"R2 032",1.1291507032929111,1450.8772717168163,0.43769901866897731,0,0.20900664482762105,4,16,0,2.4586919939575642,0.42250000000000004,0.25969934186176774,0.68219934186176778,0.82595359546512526,0.63534891958855788,5]
[6,0.89833999132328479,"R2 076",0.9886167121915701,2867.2631294560774,0.75733579499476289,1,0.23871738874091467,5,25,0.23871738874091467,2.6974093826984791,0.33800000000000002,0.18234487427041721,0.5203448742704172,0.72134934273929796,0.5548841097994599,6]
[7,0.88768409965147255,"R2 134",1.3258247486732921,2167.2530817418956,0.76769504382012166,5,0.17800240962175218,10,100,4.4500602405438041,7.1474696232422836,0.16900000000000001,0.12079223663279461,0.28979223663279463,0.53832354270716665,0.41409503285166666,7]
[8,0.84235811164233443,"R2 765",0.77823367130530841,2638.7380023746791,0.54865491616193407,2,0.30325082131715547,12,144,1.2130032852686219,8.3604729085109053,0.14083333333333334,9.8119438995718275E-2,0.2389527723290516,0.48882795780218175,0.37602150600167827,8]
[9,0.8374991088095145,"R2 333",0.737065882190441,3482.2073788654084,0.68573122602493641,0,0.32018847392399447,12,144,0,8.3604729085109053,0.14083333333333334,9.8119438995718275E-2,0.2389527723290516,0.48882795780218175,0.37602150600167827,9]
[10,0.80875512241201886,"R2 099",1.4000726350027382,1816.0682800996374,0.67932207316022464,2,0.16856268317788986,14,196,0.67425073271155944,9.034723641222465,0.12071428571428573,7.7901443641152895E-2,0.19861572935543864,0.44566324658360446,0.34281788198738805,10]
[11,0.78191519846740642,"R2 022",0.39503710025714689,872.42614293417375,9.2078776905624757E-2,0,0.59741224266373283,14,196,0,9.034723641222465,0.12071428571428573,7.7901443641152895E-2,0.19861572935543864,0.44566324658360446,0.34281788198738805,11]
[12,0.77333364655099435,"R2 098",0.87022058718045869,833.96418595155899,0.19389639742888265,0,0.27119560658136943,14,196,0,9.034723641222465,0.12071428571428573,7.7901443641152895E-2,0.19861572935543864,0.44566324658360446,0.34281788198738805,12]
[13,0.75984164082117656,"R2 234",0.4824369963522761,3645.626080086382,0.46990029041300679,1,0.48918304728784212,15,225,0.48918304728784212,9.5239066885103068,0.11266666666666668,7.1535121349255201E-2,0.18420178801592188,0.42918735770747241,0.33014412131344029,13]
[14,0.72593502959610445,"R2 123",0.93058211059424956,1239.3503584676075,0.30813553293421081,1,0.25360470324246348,16,256,0.25360470324246348,9.7775113917527694,0.10562500000000001,6.4546852547117894E-2,0.17017185254711792,0.41251891174480465,0.31732223980369589,14]
[15,0.72441923133796493,"R2 555",1.7824461264888738,1440.8687420436941,0.68617330542115218,0,0.1324023186411144,16,256,0,9.7775113917527694,0.10562500000000001,6.4546852547117894E-2,0.17017185254711792,0.41251891174480465,0.31732223980369589,15]
[16,0.71769969495631369,"R2 443",0.85724660479955617,521.5175888719798,0.11944492992628436,0,0.27530001131375981,16,256,0,9.7775113917527694,0.10562500000000001,6.4546852547117894E-2,0.17017185254711792,0.41251891174480465,0.31732223980369589,16]
[17,0.68420015345946883,"R2 767",1.1963924363705702,943.06773632033719,0.30144600465348859,0,0.19725968906652416,16,256,0,9.7775113917527694,0.10562500000000001,6.4546852547117894E-2,0.17017185254711792,0.41251891174480465,0.31732223980369589,17]
[18,0.64664927944177131,"R2 236",1.1345028443890488,3647.359548587162,1.1055468522529361,1,0.20802063314974803,17,289,0.20802063314974803,9.9855320249025166,9.9411764705882366E-2,5.8392903536627176E-2,0.15780466824250955,0.39724635711672618,0.30557412085902014,18]
[19,0.6364614421691468,"R2 763",0.31095060765968174,2842.6352474127261,0.23615956095415708,0,0.75896298057178568,17,289,0,9.9855320249025166,9.9411764705882366E-2,5.8392903536627176E-2,0.15780466824250955,0.39724635711672618,0.30557412085902014,19]
[20,0.56965422506418673,"R2 584",1.4401852584550467,3283.0074450333518,1.2632322801354299,0,0.16386780701613909,17,289,0,9.9855320249025166,9.9411764705882366E-2,5.8392903536627176E-2,0.15780466824250955,0.39724635711672618,0.30557412085902014,20]
[21,0.56467644229097536,"R2 942",0.39308901307232613,3817.1311433446754,0.40088607634970541,0,0.60037292356623906,17,289,0,9.9855320249025166,9.9411764705882366E-2,5.8392903536627176E-2,0.15780466824250955,0.39724635711672618,0.30557412085902014,21]
[22,0.56407817571381291,"R2 583",1.6194519421487064,3657.0364171293404,1.582305493538142,5,0.14572831330016045,22,484,3.6432078325040114,13.628739857406527,7.6818181818181827E-2,4.7587955287225273E-2,0.1244061371054071,0.35271254174668515,0.27131733980514239,22]
[23,0.53771677787917316,"R2 947",0.15307999092601721,1630.9270537991551,6.6703089666714552E-2,0,1.5416776456046277,22,484,0,13.628739857406527,7.6818181818181827E-2,4.7587955287225273E-2,0.1244061371054071,0.35271254174668515,0.27131733980514239,23]
[24,0.52813265471446247,"R2 396",1.5616449756195765,1725.1128107172028,0.71976843101837762,0,0.15112269669767159,22,484,0,13.628739857406527,7.6818181818181827E-2,4.7587955287225273E-2,0.1244061371054071,0.35271254174668515,0.27131733980514239,24]
[25,0.51371156751149005,"R2 483",0.86198237971439307,3461.3271663601531,0.79713894093701965,1,0.27378749908808531,23,529,0.27378749908808531,13.902527356494613,7.3478260869565229E-2,4.4414501384642528E-2,0.11789276225420775,0.34335515469293271,0.26411934976379436,25]
[26,0.50727841616364344,"R2 846",0.28861342328250972,3069.4322553489569,0.23668327216058455,0,0.81770278497750604,23,529,0,13.902527356494613,7.3478260869565229E-2,4.4414501384642528E-2,0.11789276225420775,0.34335515469293271,0.26411934976379436,26]
[27,0.49756417178682089,"R2 490",1.0882165523565952,472.22751618008022,0.13729654321410392,0,0.21686859981033046,23,529,0,13.902527356494613,7.3478260869565229E-2,4.4414501384642528E-2,0.11789276225420775,0.34335515469293271,0.26411934976379436,27]
[28,0.49710532545909825,"R2 794",0.10583223423463828,3191.1050830122072,9.0230228357435993E-2,0,2.2299444182267725,23,529,0,13.902527356494613,7.3478260869565229E-2,4.4414501384642528E-2,0.11789276225420775,0.34335515469293271,0.26411934976379436,28]
[29,0.44789745363877564,"R2 284",0.53142262184078781,3312.7722832131894,0.47035374659292684,0,0.44409099330872048,23,529,0,13.902527356494613,7.3478260869565229E-2,4.4414501384642528E-2,0.11789276225420775,0.34335515469293271,0.26411934976379436,29]
[30,0.44069892188561166,"R2 664",1.5015939090362096,1960.0713876635289,0.78635268339907638,0,0.15716632744699624,23,529,0,13.902527356494613,7.3478260869565229E-2,4.4414501384642528E-2,0.11789276225420775,0.34335515469293271,0.26411934976379436,30]
[31,0.36038777511894482,"R2 883",1.6726315934226577,1394.7260376765057,0.62327856357834355,0,0.14109502709863325,23,529,0,13.902527356494613,7.3478260869565229E-2,4.4414501384642528E-2,0.11789276225420775,0.34335515469293271,0.26411934976379436,31]
[32,0.35496724021442816,"R2 521",0.7361229612480944,2183.5251228756788,0.42943906021651512,2,0.32059861249248722,25,625,1.2823944499699489,15.184921806464562,6.7600000000000007E-2,4.1060028564680183E-2,0.10866002856468018,0.32963620639225932,0.25356631260943024,32]
[33,0.32459459697103288,"R2 403",1.6729723500962681,3565.3007564400241,{"$f":"D37*E37*365*EXP(-0.312)/1000000","v":1.5935948613602995},1,{"$f":"0.236/D37","v":0.1410662883857105},{"$f":"I36+G37","v":26},{"$f":"I37^2","v":676},{"$f":"H37*G37^2","v":0.1410662883857105},{"$f":"L36+K37","v":15.325988094850272},6.5000000000000002E-2,{"$f":"IF(I37=0,\"\",$B$3^2*L37/(I37)^2)","v":3.8314970237125684E-2},{"$f":"IF(M37=\"\",\"\",N37+M37)","v":0.10331497023712569},0.32142646163177929,0.24725112433213792,33]
[34,0.30040046314932733,"R2 720",0.11630364175212371,1546.5271970458225,4.8055584254876924E-2,0,2.0291711974332105,26,676,0,15.325988094850272,{"$f":"IF(I38=0,\"\",$B$3^2/I38)","v":6.5000000000000002E-2},3.8314970237125684E-2,0.10331497023712569,{"$f":"SQRT(O38)","v":0.32142646163177929},{"$f":"P38/$B$3","v":0.24725112433213792},34]
[35,0.27026834211749873,"R2 522",1.3032447759216637,3004.0357748142974,1.0459816826140893,3,0.18108647305576128,29,841,1.6297782575018516,16.955766352352125,5.8275862068965525E-2,3.4072824180113072E-2,9.2348686249078604E-2,0.30388926642624053,0.23376097417403116,35]
[36,0.25045954019389916,"R2 560",1.5705433417421872,995.09209743387214,0.41754778997353909,0,0.15026646748774705,29,841,0,16.955766352352125,5.8275862068965525E-2,3.4072824180113072E-2,9.2348686249078604E-2,0.30388926642624053,0.23376097417403116,36]
[37,0.23875426458953264,"R2 110",1.7566996074554018,70.259475158644946,3.2975803887547769E-2,0,0.1343428318640365,29,841,0,16.955766352352125,5.8275862068965525E-2,3.4072824180113072E-2,9.2348686249078604E-2,0.30388926642624053,0.23376097417403116,37]
[38,0.23758971719791511,"R2 389",4.9558932842581171E-2,3209.0710917053975,4.2490737637040477E-2,0,4.7620073004725425,29,841,0,16.955766352352125,5.8275862068965525E-2,3.4072824180113072E-2,9.2348686249078604E-2,0.30388926642624053,0.23376097417403116,38]
[39,0.22006093659100401,"R2 174",0.86728199541896567,1588.8092505835552,0.36815023030639782,0,0.27211449245639346,29,841,0,16.955766352352125,5.8275862068965525E-2,3.4072824180113072E-2,9.2348686249078604E-2,0.30388926642624053,0.23376097417403116,39]
[40,0.19490886276880737,"R2 945",1.0840783110308592,2205.066024716732,0.63866812181219423,0,0.21769645015366612,29,841,0,16.955766352352125,5.8275862068965525E-2,3.4072824180113072E-2,9.2348686249078604E-2,0.30388926642624053,0.23376097417403116,40]
[41,0.19086722621960428,"R2 492",0.7989339312855428,2520.7716408292581,0.53806823825450911,1,0.29539363739409441,30,900,0.29539363739409441,17.25115998974622,5.6333333333333339E-2,3.2393844869634571E-2,8.872717820296791E-2,0.2978710764793519,0.22913159729180915,41]
[42,0.16858476621711294,"R2 237",1.2717933666106083,3033.9489798725508,1.0309030269613029,2,0.1855647357470904,32,1024,0.74225894298836159,17.993418932734581,5.2812500000000005E-2,2.9696169918282663E-2,8.2508669918282665E-2,0.28724322432092747,0.22095632640071344,42]
[43,0.1483320943078148,"R2 999",1.0183390846375016,1044.5161067968929,0.28418460021534953,1,0.23174991862755515,33,1089,0.23174991862755515,18.225168851362138,5.1212121212121216E-2,2.8283319888707085E-2,7.9495441100828304E-2,0.281949359106965,0.21688412238997307,43]
[44,0.12287131982973776,"R2 826",7.1920745440064771E-2,3555.4724307356037,6.8319468910739076E-2,0,3.2813897931115137,33,1089,0,18.225168851362138,5.1212121212121216E-2,2.8283319888707085E-2,7.9495441100828304E-2,0.281949359106965,0.21688412238997307,44]
[45,7.2658888599892224E-2,"R2 722",1.4049819115607085,2562.0999043556417,0.96174465048007463,0,0.16797369279853719,33,1089,0,18.225168851362138,5.1212121212121216E-2,2.8283319888707085E-2,7.9495441100828304E-2,0.281949359106965,0.21688412238997307,45]
[46,3.0682154389359617E-2,"R2 291",0.12644238175345279,3979.5530763886495,0.13443735378503807,0,1.8664627850823878,33,1089,0,18.225168851362138,5.1212121212121216E-2,2.8283319888707085E-2,7.9495441100828304E-2,0.281949359106965,0.21688412238997307,46]
[47,2.445263969777578E-2,"R2 440",1.4328884518103733,1176.5556981481175,0.45042020109972181,0,0.16470228349026567,33,1089,0,18.225168851362138,5.1212121212121216E-2,2.8283319888707085E-2,7.9495441100828304E-2,0.281949359106965,0.21688412238997307,47]
[48,1.8106819770483895E-2,"R2 204",0.86061336964272606,2541.9710922238046,0.58448272820562763,0,0.27422302316541136,33,1089,0,18.225168851362138,5.1212121212121216E-2,2.8283319888707085E-2,7.9495441100828304E-2,0.281949359106965,0.21688412238997307,48]
[49,1.5413493315930005E-2,"R2 185",1.9279566071983454,2218.9079480128316,1.1429560394966496,1,0.12240939402829654,34,1156,0.12240939402829654,18.347578245390434,4.9705882352941183E-2,2.6823016639022347E-2,7.6528898991963523E-2,0.27663857104887513,0.21279890080682701,49]
[50,1.0747758855175427E-2,"R2 452",0.39599846280214557,3186.1846248420738,0.33709896860789396,0,0.59596190937214244,34,1156,0,18.347578245390434,4.9705882352941183E-2,2.6823016639022347E-2,7.6528898991963523E-2,0.27663857104887513,0.21279890080682701,50]
["Sum",null,null,null,null,{"$f":"SUM(F5:F54)","v":25.843425643364952},{"$f":"SUM(G5:G54)","v":34}]