{"text_format":"1","workbook":"xlsx","n_sheets":17,"sheets":["ReadMe","Input Data","Output Table","Chart Data","Sec_semi","Tur_semi","TN","TP","Chla","Sec","Tur","wq_para","RUM_para","Chart","Annual Input Data","Annual Output","Annual Value Chart"],"not_rendered":{"charts":4,"images":2,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"Chart","index":13,"reason":"not_a_worksheet"},{"sheet":"Annual Value Chart","index":16,"reason":"not_a_worksheet"}],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"ReadMe","index":0,"n_rows":18,"n_cols":2,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["Water Quality Benefits Spreadsheet "]
["Version","2.3"]
["Date","February  2013"]
[]
[]
[]
["This spreadsheet uses data and results from \"Measuring Nutrient Reduction Benefits for Policy Analysis Using Linked Non-Market Valuation and Environmental Assessment Models\", a research project funded by Grant #X7-83381001-0 from the U.S. Environmental Protection Agency, Office of Water.  Information contained in this spreadsheet is based on reports that represent the opinion of the authors and do not necessarily represent the views and policies of the Agency.  "]
["Macros must be enabled for the workbook function."]
[]
["For instructions on using this spreadsheet tool, please see the user manual. The user manual will be posted on the EPA's website (http://www.epa.gov/nandppolicy/links.html, click on the grants folder once on this webpage) and is also available from the authors."]
[]
["Technical documentation for the spreadsheet can be found in"]
["Phaneuf, D. J., M. Kenney, and K. Reckhow.  Measuring Nutrient Reduction Benefits for Policy Analysis Using Linked Non-Market Valuation and Environmental Assessment Models—An Interim Report on Water Quality Modeling, EPA Project Report, 2010."]
[]
["Phaneuf, D. J., C. Mansfield, G. Van Houtven, and R. von Haefen. Measuring Nutrient Reduction Benefits for Policy Analysis Using Linked Non-market Valuation and Environmental Assessment Models: Final Report on Stated Preference Surveys, EPA Project Report, 2012. "]
[]
[]
["Extrapolating the results from the Water Quality Benefits Spreadsheet beyond recreational use of freshwater lakes in the southeast is not recommended. "]

{"sheet":"Input Data","index":1,"n_rows":3,"n_cols":6,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[]
["Lake Name","Total Nitrogen \n(mg/l)","Total Phosphorous \n(mg/l)","Chlorophyll a \n(ug/l)","Secchi Depth \n(m)","Turbidity  \n(NTU)"]
["Example Lake",0.76,0.05,33,0.7,9.65]

{"sheet":"Output Table","index":2,"n_rows":9,"n_cols":16,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,0,1,0],[0,11,0,12],[0,13,1,13],[0,14,1,14],[0,15,1,15],[0,1,0,2],[0,3,0,4],[0,5,0,6],[0,7,0,8],[0,9,0,10]]}
[null,"Probability of \nCategory 1 \nLake Water Quality",null,"Probability of \nCategory 2 \nLake Water Quality",null,"Probability of \nCategory 3 \nLake Water Quality",null,"Probability of \nCategory 4 \nLake Water Quality",null,"Probability of \nCategory 5 \nLake Water Quality",null,"Water Quality Index",null,"WTP per Trip","Annual Aggregate WTP","Net Present Value (NPV)"]
[null,"Baseline","Counterfactual","Baseline","Counterfactual","Baseline","Counterfactual","Baseline","Counterfactual","Baseline","Counterfactual","Baseline","Counterfactual"]
["Mean (Xbar)",1.5100790776345267E-2,3.221394473936294E-2,5.9140951162026757E-2,0.11612140938028376,0.42338221518347346,0.53458920091914519,0.4638020544757096,0.29896323968959354,3.8573988402444789E-2,1.8112205271614338E-2,3.4516074985658802,3.1546383513738134,15.292719850584611,13763447.865526147,171522982.33876988]
["St. Dev (s)",2.3218155088445152E-3,4.2628645636828789E-3,7.1733923068195539E-3,1.1198586604513941E-2,2.1055760015914658E-2,1.9227333633105852E-2,2.2821505952682782E-2,1.9231818709324937E-2,6.2982665141570089E-3,3.1084527931287036E-3,3.486953945562081E-2,3.3250631933276008E-2,1.0440973578681956,939687.62900586636,11710584.784931133]
["Min",9.7401155229038302E-3,2.1873656287314382E-2,4.3940549901134912E-2,8.966321504296132E-2,0.37563265502487353,0.48794495629142981,0.40118859389332268,0.25124512042511288,2.5738742102382452E-2,1.1947064064284153E-2,3.3480768621738761,3.0717379138714045,13.258477424053943,11932629.681648549,148706941.03234017]
["1st Quartile",1.3338886565127397E-2,2.920202093598831E-2,5.4429549884562833E-2,0.11003795559553511,0.40911217162941127,0.51959103990644495,0.44826393215948318,0.28655670184011545,3.4155559867222837E-2,1.6179124054775611E-2,3.425969493469383,3.1328508365270555,14.580271042974967,13122243.938677471,163532164.12991902]
["Median",1.5146288047832707E-2,3.2176300155623658E-2,5.8807188756880881E-2,0.11539598945168134,0.42376128341636105,0.53416222452899431,0.46500984625719233,0.29763917910590254,3.9137362639085418E-2,1.825957142317769E-2,3.4526116635243902,3.1544327748135004,15.315481431825219,13783933.288642697,171778275.99060422]
["3rd Quartile",1.6659815413378878E-2,3.5203173512691567E-2,6.3670706439662744E-2,0.123493958376344,0.43775188528876774,0.54820804628424358,0.47909699081478857,0.31158742886492646,4.2864807340018733E-2,2.017707823296843E-2,3.4764814782445597,3.1783772614649446,16.032251422118559,14429026.279906705,179817560.53823459]
["Max",2.1030949256403121E-2,4.2950634269977139E-2,7.974334121774046E-2,0.14675108956461744,0.48463405425568945,0.57410377270289104,0.51303188144302914,0.34417068477628943,5.540089500592215E-2,2.6567075243545454E-2,3.5275480779515829,3.2310809308269146,18.099070758587185,16289163.682728468,202998984.11822546]

{"sheet":"Chart Data","index":3,"n_rows":6,"n_cols":2,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
[null,"NPV"]
["Max",{"$f":"('Output Table'!P9-'Output Table'!P8)/1000","v":23181.423579990864}]
["Q3",{"$f":"('Output Table'!P8-'Output Table'!P7)/1000","v":8039.2845476303701}]
["Median",{"$f":"('Output Table'!P7-'Output Table'!P6)/1000","v":8246.1118606851996}]
["Q1",{"$f":"'Output Table'!P6/1000","v":163532.16412991902}]
["Min",{"$f":"('Output Table'!P6-'Output Table'!P5)/1000","v":14825.223097578853}]

{"sheet":"Sec_semi","index":4,"n_rows":7,"n_cols":16,"rows_kept":7,"cut":false,"hidden":true,"merged":[]}
[null,"TP","Chla","TN","Tur","TPChla","TPTN","TPTur","ChlaTN","ChlaTur","TNTur","TPChlaTN","TPChlaTur","TPTNTur","ChlaTNTur","TPChlaTNTur"]
[null,"b","b","b","b","b","b","b","b","b","b","b","b","b","b","b"]
["ltp",-0.7850104,null,null,null,-0.54482450000000004,-0.47198770000000001,-0.31299729999999998,null,null,null,-0.33252530000000002,-0.2524361,-0.15309919999999999,null,-0.1123049]
["lchla",null,-0.51012539999999995,null,null,-0.28449600000000003,null,null,-0.29823230000000001,-0.23962349999999999,null,-0.23158599999999999,-0.19310540000000001,null,-0.17363980000000001,-0.16011619999999999]
["ltn",null,null,-1.044009,null,null,-0.60770519999999995,null,-0.71940020000000005,null,-0.55849409999999999,-0.47631230000000002,null,-0.48260459999999999,-0.4872686,-0.434004]
["ltur",null,null,null,-0.87345030000000001,null,null,-0.69681139999999997,null,-0.66789920000000003,-0.65550160000000002,null,-0.56463430000000003,-0.59765749999999995,-0.52154140000000004,-0.49122310000000002]
["_cons",-1.231989,2.5459960000000001,0.56913720000000001,2.8289490000000002,0.22423799999999999,-0.66499149999999996,1.454664,1.4892319999999999,3.003816,1.978777,0.42717159999999998,1.862217,1.419225,2.1784430000000001,1.759439]

{"sheet":"Tur_semi","index":5,"n_rows":7,"n_cols":16,"rows_kept":7,"cut":false,"hidden":true,"merged":[]}
[null,"TP","Chla","Sec","TN","TPChla","TPSec","TPTN","ChlaSec","ChlaTN","SecTN","TPChlaSec","TPChlaTN","TPSecTN","ChlaSecTN","TPChlaSecTN"]
[null,"b","b","b","b","b","b","b","b","b","b","b","b","b","b","b"]
["ltp",6.4037649999999999,null,null,null,5.4929259999999998,2.729263,5.1065490000000002,null,null,null,2.4332980000000002,4.3803190000000001,2.7842359999999999,null,2.4307780000000001]
["lchla",null,2.2439819999999999,null,null,0.34251019999999999,null,null,-0.1598919,0.82521670000000003,null,-0.56016030000000006,6.177E-4,null,-0.28102539999999998,-0.59721279999999999]
["lsec",null,null,-8.3528710000000004,null,null,-6.2906940000000002,null,-8.1523319999999995,null,-7.7218730000000004,-6.6452309999999999,null,-6.2932370000000004,-7.5771119999999996,-6.5678780000000003]
["ltn",null,null,null,6.9502410000000001,null,null,2.838578,null,5.6826179999999997,1.1462939999999999,null,2.9158490000000001,-1.6135300000000002E-2,1.189465,0.2588316]
["_cons",29.80744,2.076918,8.5806179999999994,13.53908,25.57433,17.967880000000001,27.93909,8.7145270000000004,10.64514,9.5802619999999994,17.910489999999999,25.22784,18.167750000000002,10.0426,18.236979999999999]

{"sheet":"TN","index":6,"n_rows":7,"n_cols":16,"rows_kept":7,"cut":false,"hidden":true,"merged":[]}
[null,"TP","Chla","Sec","Tur","TPChla","TPSec","TPTur","ChlaSec","ChlaTur","SecTur","TPChlaSec","TPChlaTur","TPSecTur","ChlaSecTur","TPChlaSecTur"]
[null,"b","b","b","b","b","b","b","b","b","b","b","b","b","b","b"]
["ltp",0.51670369999999999,null,null,null,0.4484128,0.30872050000000001,0.32987349999999999,null,null,null,0.28867860000000001,0.32255899999999998,0.24284549999999999,null,0.23621239999999999]
["lchla",null,0.2932476,null,null,0.10787239999999999,null,null,0.11763,0.129413,null,7.0571999999999996E-2,7.1877899999999995E-2,null,9.48687E-2,6.1309700000000002E-2]
["lsec",null,null,-0.60188649999999999,null,null,-0.33305170000000001,null,-0.51575550000000003,null,-0.45125680000000001,-0.30318780000000001,null,-0.33560279999999998,-0.4410367,-0.33102389999999998]
["ltur",null,null,null,0.39004460000000002,null,null,0.20430029999999999,null,0.30148540000000001,0.12094480000000001,null,0.16855419999999999,5.3180699999999997E-2,7.2031700000000004E-2,3.1884500000000003E-2]
["_cons",0.93798179999999998,-1.466642,-0.76434040000000003,-1.5248520000000001,0.44398359999999998,0.2558184,-7.7121700000000001E-2,-1.0498959999999999,-1.685235,-1.0486660000000001,8.7208000000000008E-3,-0.22774530000000001,-0.1055396,-1.1986589999999999,-0.2525075]

{"sheet":"TP","index":7,"n_rows":7,"n_cols":16,"rows_kept":7,"cut":false,"hidden":true,"merged":[]}
[null,"TN","Chla","Sec","Tur","TNChla","TNSec","TNTur","ChlaSec","ChlaTur","SecTur","TNChlaSec","TNChlaTur","TNSecTur","ChlaSecTur","TNChlaSecTur"]
[null,"b","b","b","b","b","b","b","b","b","b","b","b","b","b","b"]
["ltn",0.91926680000000005,null,null,null,0.73235510000000004,0.46863280000000002,0.49419560000000001,null,null,null,0.41985650000000002,0.48025950000000001,0.38043519999999997,null,0.3669887]
["lchla",null,0.41419519999999999,null,null,0.19895180000000001,null,null,0.16405629999999999,0.17919309999999999,null,0.1146277,0.11669119999999999,null,0.1431067,0.1080411]
["lsec",null,null,-0.87288759999999999,null,null,-0.59079950000000003,null,-0.73583379999999998,null,-0.48161409999999999,-0.51933269999999998,null,-0.30657630000000002,-0.47060800000000003,-0.30501030000000001]
["ltur",null,null,null,0.5635675,null,null,0.3703169,null,0.41293829999999998,0.27682050000000002,null,0.26742880000000002,0.23253370000000001,0.1677999,0.14313139999999999]
["_cons",-2.614528,-4.2631730000000001,-3.3087209999999998,-4.3920810000000001,-3.1877089999999999,-2.9501200000000001,-3.6389740000000002,-3.6700840000000001,-4.5203230000000003,-3.8850790000000002,-3.2292320000000001,-3.7108089999999998,-3.4903050000000002,-4.0030609999999998,-3.5673949999999999]

{"sheet":"Chla","index":8,"n_rows":7,"n_cols":16,"rows_kept":7,"cut":false,"hidden":true,"merged":[]}
[null,"TP","TN","Sec","Tur","TPTN","TPSec","TPTur","TNSec","TNTur","SecTur","TPTNSec","TPTNTur","TPSecTur","TNSecTur","TPTNSecTur"]
[null,"b","b","b","b","b","b","b","b","b","b","b","b","b","b","b"]
["ltp",0.7377013,null,null,null,0.50415659999999995,0.44559090000000001,0.4182226,null,null,null,0.34801379999999998,0.31867570000000001,0.37643389999999999,null,0.3086528]
["ltn",null,0.90798769999999995,null,null,0.44644879999999998,null,null,0.47629929999999998,0.4619375,null,0.31162010000000001,0.29226220000000003,null,0.39775129999999997,0.27211980000000002]
["lsec",null,null,-0.86503050000000004,null,null,-0.47372779999999998,null,-0.57447420000000005,null,-0.366199,-0.36880459999999998,null,-0.16918040000000001,-0.18042440000000001,-7.9235600000000003E-2]
["ltur",null,null,null,0.67986590000000002,null,null,0.45913660000000001,null,0.503826,0.46790330000000002,null,0.39929569999999998,0.38255630000000002,0.42373260000000001,0.36533019999999999]
["_cons",4.7762250000000002,3.055418,2.358406,1.0676380000000001,4.355181,3.822247,2.8749720000000001,2.7272159999999999,1.7755289999999999,1.447244,3.742569,2.8938470000000001,2.8731260000000001,1.8662939999999999,2.9063759999999998]

{"sheet":"Sec","index":9,"n_rows":8,"n_cols":16,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
[null,"TP","Chla","TN","Tur","TPChla","TPTN","TPTur","ChlaTN","ChlaTur","TNTur","TPChlaTN","TPChlaTur","TPTNTur","ChlaTNTur","TPChlaTNTur"]
[null,"b","b","b","b","b","b","b","b","b","b","b","b","b","b","b"]
["ltp",-0.62296280000000004,null,null,null,-0.52416989999999997,-0.43221609999999999,-0.25887539999999998,null,null,null,-0.37997350000000002,-0.25721090000000002,-0.16540099999999999,null,-0.16671800000000001]
["lchla",null,-0.3418929,null,null,-0.1242447,null,null,-0.16524510000000001,-8.1983799999999996E-2,null,-8.8878600000000002E-2,-3.5152099999999999E-2,null,-3.51565E-2,-1.51603E-2]
["ltn",null,null,-0.76862640000000004,null,null,-0.36986190000000002,null,-0.60070849999999998,null,-0.36345169999999999,-0.32263069999999999,null,-0.28364539999999999,-0.36030810000000002,-0.28111069999999999]
["ltur",null,null,null,-0.59896510000000003,null,null,-0.45251089999999999,null,-0.52219510000000002,-0.45653519999999997,null,-0.41580060000000002,-0.3939357,-0.41231309999999999,-0.36735689999999999]
["_cons",-2.0476380000000001,0.81137990000000004,-0.5707854,1.059687,-1.4243650000000001,-1.701608,-7.8216900000000006E-2,-7.0499099999999995E-2,1.115607,0.50545430000000002,-1.2842119999999999,-4.8563200000000001E-2,-0.1015175,0.5069245,-0.1146615]
["residual",0.26934237799999999,0.40859000200000001,0.31635727299999999,0.211197569,0.25127996400000002,0.23552029899999999,0.51722503900000005,0.28131164800000003,0.214697847,0.17615065199999999,0.57917352700000002,0.18865791000000001,0.16773814100000001,0.180030683,0.170958363]

{"sheet":"Tur","index":10,"n_rows":8,"n_cols":16,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
[null,"TP","Chla","Sec","TN","TPChla","TPSec","TPTN","ChlaSec","ChlaTN","SecTN","TPChlaSec","TPChlaTN","TPSecTN","ChlaSecTN","TPChlaSecTN"]
[null,"b","b","b","b","b","b","b","b","b","b","b","b","b","b","b"]
["ltp",0.72229989999999999,null,null,null,0.49553649999999999,0.25981700000000002,0.52117579999999997,null,null,null,0.1601378,0.3616741,0.24117450000000001,null,0.1507696]
["lchla",null,0.40793849999999998,null,null,0.2360729,null,null,0.16543340000000001,0.26584419999999997,null,0.13879340000000001,0.19773940000000001,null,0.15429180000000001,0.13470480000000001]
["lsec",null,null,-0.98659560000000002,null,null,-0.79014499999999999,null,-0.82468710000000001,null,-0.88148870000000001,-0.72603410000000002,null,-0.75730580000000003,-0.77049029999999996,-0.70794409999999997]
["ltn",null,null,null,0.8518213,null,null,0.43075580000000002,null,0.56782980000000005,0.18808430000000001,null,0.33940300000000001,8.6407300000000006E-2,0.1099671,5.2180600000000001E-2]
["_cons",4.00068,0.57669939999999997,1.6182589999999999,2.2328429999999999,2.6968999999999999,2.511126,3.700758,1.2468840000000001,1.4338219999999999,1.780843,1.8527149999999999,2.6379589999999999,2.5231859999999999,1.3697539999999999,1.877885]
["residual",0.50594505999999995,0.59626331600000004,0.34787765300000001,0.57018720700000003,0.47296607400000001,0.32391308099999999,0.46117140899999998,0.33906584699999998,0.49383992100000002,0.34011575300000002,0.32941770500000001,0.446424828,0.32246144300000001,0.33642371399999998,0.32945879]

{"sheet":"wq_para","index":11,"n_rows":101,"n_cols":9,"rows_kept":101,"cut":false,"hidden":true,"merged":[]}
["loutcome_b_tn","loutcome_b_tp","loutcome_b_chla","loutcome_b_secchi","loutcome_b_turbid","cut1_b_cons","cut2_b_cons","cut3_b_cons","cut4_b_cons"]
[0.67092439999999998,10.476929999999999,7.0234000000000005E-2,-0.73606380000000005,1.27221E-2,-0.94003930000000002,0.49659189999999998,3.038977,6.3955590000000004]
[0.71458010000000005,10.22011,7.8497200000000003E-2,-0.70342249999999995,2.1426299999999999E-2,-0.90784069999999994,0.81275960000000003,3.3905409999999998,6.4644849999999998]
[1.08683,11.241,7.6358999999999996E-2,-0.65926790000000002,3.3441800000000001E-2,-0.85260080000000005,0.98979010000000001,3.7048649999999999,7.207281]
[0.67145630000000001,10.970190000000001,7.6559299999999997E-2,-0.70434280000000005,2.7564499999999999E-2,-0.81849430000000001,0.65858749999999999,3.2157079999999998,6.54488]
[0.8839572,11.207280000000001,7.9091300000000003E-2,-0.57688669999999997,4.0124000000000002E-3,-0.52711010000000003,1.0662799999999999,3.629448,6.753349]
[0.8231115,11.35971,7.7483200000000002E-2,-0.60733579999999998,2.56201E-2,-0.50529120000000005,1.013719,3.467816,6.921856]
[1.2069799999999999,9.2914379999999994,7.0677100000000007E-2,-0.6039641,3.0271099999999999E-2,-0.47357529999999998,0.99293739999999997,3.4990039999999998,6.5322789999999999]
[0.52226410000000001,10.112769999999999,7.3419999999999999E-2,-0.63906070000000004,4.1419299999999999E-2,-0.73921610000000004,0.90135770000000004,3.3574579999999998,6.3753880000000001]
[0.84910249999999998,10.612690000000001,7.3251700000000003E-2,-0.70144600000000001,2.2989200000000001E-2,-0.80745080000000002,0.78248209999999996,3.3281700000000001,6.4828229999999998]
[0.81062129999999999,9.2688749999999995,7.4091299999999999E-2,-0.73342470000000004,3.07446E-2,-0.92286579999999996,0.69502070000000005,3.0826790000000002,6.4100299999999999]
[0.60755420000000004,11.75019,6.8990099999999999E-2,-0.7278152,8.1025000000000003E-3,-1.183522,0.45303729999999998,3.007002,6.1916739999999999]
[0.439189,9.2460979999999999,6.6647100000000001E-2,-0.67634479999999997,2.4631E-2,-1.26959,0.4036111,2.9605860000000002,6.2082199999999998]
[0.68323449999999997,8.8354119999999998,7.9172800000000002E-2,-0.67751709999999998,2.1752500000000001E-2,-0.96795310000000001,0.58551540000000002,3.1499060000000001,6.4184530000000004]
[0.4600455,10.61598,7.3901300000000003E-2,-0.68228929999999999,3.1683000000000003E-2,-0.90894819999999998,0.620587,3.1654650000000002,6.3439620000000003]
[1.3170040000000001,10.246090000000001,6.8709500000000007E-2,-0.44431100000000001,2.5558999999999998E-2,-0.4995521,1.2080919999999999,3.6538219999999999,6.7806680000000004]
[0.76830019999999999,9.4410539999999994,7.8106900000000007E-2,-0.52528350000000001,2.0125000000000001E-2,-0.70926789999999995,0.93981749999999997,3.4266719999999999,6.5255369999999999]
[0.24281150000000001,9.8269540000000006,7.4044100000000002E-2,-0.79095230000000005,2.2796E-2,-1.276796,0.30781750000000002,2.7856649999999998,5.8838290000000004]
[0.5929856,9.6971220000000002,7.4938900000000003E-2,-0.70004310000000003,2.8853699999999999E-2,-0.95397759999999998,0.77310939999999995,3.222594,6.3874950000000004]
[0.78187709999999999,10.682790000000001,7.8050999999999995E-2,-0.71172760000000002,1.5629000000000001E-2,-1.023264,0.71948029999999996,3.3227829999999998,6.6117749999999997]
[1.245967,8.0335529999999995,7.0772299999999996E-2,-0.70236200000000004,2.7410500000000001E-2,-0.86890049999999996,0.71057800000000004,3.2639999999999998,6.4893340000000004]
[0.37378689999999998,11.19633,7.7810900000000002E-2,-0.81552259999999999,2.1514399999999999E-2,-1.1780520000000001,0.51992309999999997,2.9688479999999999,6.168596]
[0.66130440000000001,9.5770569999999999,7.4142E-2,-0.76684339999999995,1.16434E-2,-1.1637770000000001,0.47940070000000001,2.890377,6.0074730000000001]
[0.63808100000000001,11.70374,7.7194299999999993E-2,-0.66248450000000003,8.4635999999999999E-3,-0.79566029999999999,0.7641734,3.3151540000000002,6.415959]
[0.47744560000000003,10.81165,7.8997899999999996E-2,-0.62511539999999999,3.1759299999999997E-2,-0.79348580000000002,0.9926045,3.3543409999999998,6.6704249999999998]
[0.15936210000000001,11.604509999999999,8.6026900000000003E-2,-0.83703709999999998,2.2694800000000001E-2,-1.24536,0.51170400000000005,3.1402619999999999,6.6799520000000001]
[0.4832958,11.85331,7.4069700000000002E-2,-0.62131119999999995,1.9033499999999998E-2,-0.78667690000000001,0.8659905,3.2467549999999998,6.5608199999999997]
[0.69617039999999997,9.7313209999999994,7.6478199999999996E-2,-0.67874999999999996,2.6000100000000002E-2,-0.87639210000000001,0.75943689999999997,3.2076730000000002,6.3481839999999998]
[0.91635880000000003,8.7862919999999995,7.4138800000000005E-2,-0.70914829999999995,3.9949800000000001E-2,-0.97157380000000004,0.63839270000000004,3.333002,6.4627720000000002]
[0.75686100000000001,10.713329999999999,7.4094499999999994E-2,-0.56895569999999995,1.5696000000000002E-2,-0.70530000000000004,0.9057229,3.5135830000000001,6.5857619999999999]
[0.40272019999999997,8.9254840000000009,7.0760000000000003E-2,-0.73787130000000001,2.0879700000000001E-2,-1.31968,0.40192299999999997,2.7286920000000001,5.8777090000000003]
[0.43073879999999998,13.07302,7.6065599999999997E-2,-0.8286618,6.0432000000000003E-3,-1.137213,0.42523119999999998,3.1382629999999998,6.4583940000000002]
[0.73748740000000002,10.79819,7.7802899999999994E-2,-0.67753439999999998,1.7409299999999999E-2,-1.006877,0.72779870000000002,3.3398349999999999,6.7178279999999999]
[0.97672859999999995,8.4858619999999991,7.4152700000000002E-2,-0.67009370000000001,1.1862899999999999E-2,-0.97321369999999996,0.71106930000000002,3.166255,6.2704890000000004]
[0.62276089999999995,10.51507,7.1660199999999993E-2,-0.63330920000000002,1.53253E-2,-1.035563,0.6814228,3.0848040000000001,6.4105220000000003]
[0.45793309999999998,12.448399999999999,7.7685799999999999E-2,-0.72559799999999997,1.7315299999999999E-2,-0.87604499999999996,0.75757490000000005,3.2987890000000002,6.4464889999999997]
[0.63017330000000005,9.3135410000000007,6.7815299999999995E-2,-0.81833449999999996,1.15476E-2,-1.3903080000000001,0.23517669999999999,2.6163569999999998,5.8941020000000002]
[0.41804980000000003,8.654928,7.4683299999999994E-2,-0.75908869999999995,2.2913300000000001E-2,-1.0679320000000001,0.41528530000000002,2.9637159999999998,6.0906820000000002]
[0.74678529999999999,11.303599999999999,7.7387700000000004E-2,-0.65322420000000003,1.0045999999999999E-2,-0.85214659999999998,0.83507290000000001,3.315016,6.6153060000000004]
[0.82567670000000004,10.328749999999999,7.0940100000000006E-2,-0.75219639999999999,1.10682E-2,-1.105699,0.3761969,3.030208,6.3032459999999997]
[0.5237347,12.332710000000001,8.2126500000000005E-2,-0.79493510000000001,2.46561E-2,-1.0619860000000001,0.69908110000000001,3.2970290000000002,6.8512700000000004]
[0.2240067,10.214840000000001,8.2542199999999996E-2,-0.72299060000000004,2.7890600000000002E-2,-1.1549389999999999,0.57869389999999998,3.1561849999999998,6.2279619999999998]
[0.77840810000000005,8.1496220000000008,7.6514399999999996E-2,-0.89688630000000003,3.6488199999999998E-2,-1.3173870000000001,0.45758409999999999,3.035345,6.3601749999999999]
[0.75147459999999999,11.79147,7.1194800000000003E-2,-0.50126110000000001,1.7804899999999999E-2,-0.65283919999999995,1.070586,3.410342,6.794613]
[0.57818599999999998,11.37467,7.5942300000000004E-2,-0.76011359999999994,1.3024000000000001E-2,-1.121432,0.5980664,3.1043530000000001,6.4085700000000001]
[0.30797170000000001,9.3990130000000001,7.3370199999999997E-2,-0.66926640000000004,2.05376E-2,-0.98557779999999995,0.66627630000000004,3.0099309999999999,6.196904]
[0.61390480000000003,10.901859999999999,8.7080299999999999E-2,-0.71193150000000005,3.0865199999999999E-2,-0.90173510000000001,0.86705209999999999,3.6338439999999999,6.8733700000000004]
[1.0666580000000001,8.7556379999999994,6.3002299999999997E-2,-0.67811410000000005,2.1718000000000002E-3,-1.068192,0.51763809999999999,2.909376,6.0280209999999999]
[0.76181160000000003,9.6253170000000008,7.5489500000000001E-2,-0.80365399999999998,1.81365E-2,-1.1416930000000001,0.54591679999999998,3.2720359999999999,6.3151380000000001]
[0.44882820000000001,11.34191,7.5970999999999997E-2,-0.65892479999999998,1.5622199999999999E-2,-1.062235,0.69732709999999998,3.1238269999999999,6.6898569999999999]
[0.84322640000000004,9.0015970000000003,7.6501799999999995E-2,-0.68058940000000001,2.1928300000000001E-2,-0.8611666,0.78480380000000005,3.3222489999999998,6.4675339999999997]
[0.50195140000000005,9.7766649999999995,8.0740400000000004E-2,-0.77885280000000001,3.2096E-2,-1.040022,0.63839860000000004,3.17347,6.552791]
[0.94081870000000001,10.31944,7.5505100000000006E-2,-0.69913789999999998,1.38783E-2,-0.93075600000000003,0.71563339999999998,3.328592,6.6473490000000002]
[1.0617259999999999,9.8096029999999992,8.0374200000000007E-2,-0.74350830000000001,9.2841E-3,-0.87985760000000002,0.86753769999999997,3.4883190000000002,6.9331579999999997]
[0.53301529999999997,10.620609999999999,6.87976E-2,-0.69750489999999998,3.8103199999999997E-2,-1.2386349999999999,0.47952860000000003,3.1571820000000002,6.2700170000000002]
[0.64426819999999996,11.278969999999999,7.5507500000000005E-2,-0.53122899999999995,3.8574799999999999E-2,-0.48097689999999999,1.0645500000000001,3.6164749999999999,6.9955379999999998]
[0.72779890000000003,9.0013100000000001,7.6041800000000007E-2,-0.81766399999999995,2.0826799999999999E-2,-1.097526,0.46723179999999997,3.0640960000000002,6.2244549999999998]
[1.0401229999999999,8.2613839999999996,7.2888999999999995E-2,-0.78654829999999998,1.3232799999999999E-2,-1.122498,0.58475109999999997,3.037417,6.4945880000000002]
[4.39108E-2,10.81282,7.9072600000000007E-2,-0.80722989999999994,1.04604E-2,-1.4106810000000001,0.32647939999999998,2.8989769999999999,6.0440659999999999]
[0.56642199999999998,10.529719999999999,8.3257899999999996E-2,-0.80595830000000002,1.2218100000000001E-2,-1.1037650000000001,0.59947399999999995,3.3035000000000001,6.4747070000000004]
[0.98922810000000005,11.48475,7.2970199999999999E-2,-0.71830179999999999,4.8494999999999996E-3,-0.9845545,0.59431480000000003,3.3493909999999998,6.5740860000000003]
[0.99466589999999999,8.6416789999999999,7.1299500000000002E-2,-0.75965450000000001,4.2674000000000002E-3,-1.149672,0.53469789999999995,2.9865789999999999,6.0204319999999996]
[-0.14266480000000001,12.97073,7.9286899999999993E-2,-0.90680780000000005,2.3887599999999998E-2,-1.4419169999999999,0.26797989999999999,2.9051459999999998,6.3860109999999999]
[0.82729330000000001,11.114929999999999,7.4898599999999996E-2,-0.67605190000000004,1.48941E-2,-0.83199809999999996,0.88396370000000002,3.3141780000000001,6.3773470000000003]
[1.124698,10.142110000000001,7.3100700000000005E-2,-0.62765409999999999,2.1291399999999999E-2,-0.73473759999999999,0.95205660000000003,3.4710719999999999,6.5267080000000002]
[0.61664589999999997,11.102220000000001,7.3790700000000001E-2,-0.70351249999999999,1.8258900000000002E-2,-0.95625749999999998,0.7234218,3.2265739999999998,6.2820999999999998]
[0.72858650000000003,12.131030000000001,7.3227100000000003E-2,-0.72430589999999995,2.7374599999999999E-2,-1.0397149999999999,0.66069730000000004,3.3076620000000001,6.8963530000000004]
[0.48053869999999999,7.8074339999999998,8.2757499999999998E-2,-0.65286109999999997,3.2559200000000003E-2,-0.90432389999999996,0.91524150000000004,3.417135,6.4803069999999998]
[0.34892279999999998,12.2676,7.9442600000000002E-2,-0.69440979999999997,3.1518200000000003E-2,-0.82817450000000004,0.75459209999999999,3.4338090000000001,6.7295579999999999]
[0.84573220000000005,9.2216740000000001,7.4942900000000007E-2,-0.67832859999999995,2.89149E-2,-0.96479250000000005,0.7646461,3.301955,6.8110030000000004]
[0.82884939999999996,11.623659999999999,7.0353700000000005E-2,-0.69094250000000001,1.8620899999999999E-2,-0.8883491,0.80172719999999997,3.2218450000000001,6.0849970000000004]
[0.3876773,9.7269410000000001,6.8271200000000004E-2,-0.82698970000000005,4.47737E-2,-1.300384,0.4251741,2.8785750000000001,5.9529560000000004]
[0.92629980000000001,9.1434650000000008,8.0240500000000006E-2,-0.7368439,2.7230299999999999E-2,-0.8855537,0.77673570000000003,3.490437,6.9181489999999997]
[0.42828670000000002,9.9931769999999993,7.8601799999999999E-2,-0.69571919999999998,8.8614999999999996E-3,-0.9514956,0.59429379999999998,3.0257670000000001,6.286435]
[0.75153760000000003,8.8410460000000004,7.6358499999999996E-2,-0.67981899999999995,1.8107600000000001E-2,-0.99350050000000001,0.68011779999999999,3.2259699999999998,6.1066719999999997]
[0.70280679999999995,12.091480000000001,7.3439400000000002E-2,-0.67934760000000005,1.9146400000000001E-2,-0.88400440000000002,0.76504839999999996,3.1143269999999998,6.4500380000000002]
[0.87864149999999996,10.02876,7.5173599999999993E-2,-0.63720980000000005,2.5670999999999999E-2,-0.64749350000000006,0.83649770000000001,3.45966,6.6779580000000003]
[0.82404849999999996,10.66507,7.1715699999999993E-2,-0.62501039999999997,1.7440299999999999E-2,-0.78446139999999998,0.74236729999999995,3.3324199999999999,6.5218509999999998]
[0.1049876,8.5356860000000001,7.7616699999999997E-2,-0.77451910000000002,3.1074500000000001E-2,-1.3125370000000001,0.33664850000000002,2.8536600000000001,5.9323370000000004]
[0.58098099999999997,10.17062,6.8808400000000006E-2,-0.63572919999999999,2.6441599999999999E-2,-0.87829659999999998,0.8175384,3.0266199999999999,6.2346490000000001]
[0.77466930000000001,9.6811100000000003,7.8694100000000003E-2,-0.61943170000000003,2.9745299999999999E-2,-0.64882810000000002,1.0225679999999999,3.5881500000000002,6.9166470000000002]
[0.60005209999999998,10.09282,8.2487500000000005E-2,-0.75940189999999996,1.9415499999999999E-2,-1.078314,0.60594570000000003,3.2102119999999998,6.5274260000000002]
[0.61865689999999995,10.173159999999999,6.7558400000000005E-2,-0.63889989999999997,1.6531299999999999E-2,-1.231932,0.56116129999999997,2.9519359999999999,6.170223]
[0.59481329999999999,11.545109999999999,7.6542100000000002E-2,-0.63621150000000004,1.7614500000000002E-2,-0.93559809999999999,0.71080189999999999,3.357472,6.3811220000000004]
[0.25403239999999999,8.173387,7.7677899999999994E-2,-0.73890199999999995,3.2146099999999997E-2,-1.0718920000000001,0.56747340000000002,2.866546,5.7942479999999996]
[0.32800390000000001,11.25079,7.9973000000000002E-2,-0.73346389999999995,3.1898200000000002E-2,-1.2400420000000001,0.69830080000000005,3.206356,6.6761049999999997]
[0.30457329999999999,9.6564250000000005,7.6282699999999995E-2,-0.77640569999999998,2.8643100000000001E-2,-1.2140550000000001,0.48803469999999999,2.8347220000000002,6.1243670000000003]
[1.0203789999999999,9.3529119999999999,7.2684899999999997E-2,-0.73353780000000002,1.09005E-2,-0.98803750000000001,0.63750010000000001,3.1648049999999999,6.38849]
[0.1844596,13.59502,7.2288599999999995E-2,-0.72053940000000005,2.6639400000000001E-2,-0.97241630000000001,0.61240459999999997,3.2483279999999999,6.5513669999999999]
[0.45365270000000002,13.50389,7.2901999999999995E-2,-0.80774919999999995,5.9629000000000001E-3,-1.229932,0.32109539999999998,2.9798260000000001,6.5401800000000003]
[0.68095760000000005,9.3807200000000002,7.5396199999999997E-2,-0.71497719999999998,1.8059499999999999E-2,-0.99216680000000002,0.62778520000000004,3.0502259999999999,6.393351]
[0.58151540000000002,11.57973,7.4871999999999994E-2,-0.64865620000000002,2.2343600000000002E-2,-0.7726866,0.77296779999999998,3.3164509999999998,6.5925799999999999]
[0.92335509999999998,10.3536,7.7198600000000006E-2,-0.68789239999999996,1.10417E-2,-0.69614330000000002,0.94423100000000004,3.3604029999999998,6.5576350000000003]
[0.79354919999999995,9.8138539999999992,7.4809500000000001E-2,-0.70998620000000001,1.4947200000000001E-2,-0.97207429999999995,0.64967169999999996,3.0266579999999998,6.1976649999999998]
[0.49730580000000002,10.280950000000001,7.8328700000000001E-2,-0.60716939999999997,3.4227300000000002E-2,-0.89369829999999995,0.84102080000000001,3.3685179999999999,6.4518849999999999]
[0.78846550000000004,9.6627340000000004,7.9151899999999997E-2,-0.68567750000000005,3.2799500000000002E-2,-0.94648750000000004,0.81142190000000003,3.3879280000000001,6.7321859999999996]
[0.1301823,11.675829999999999,7.6016200000000006E-2,-0.68281840000000005,1.43559E-2,-1.1285320000000001,0.52142840000000001,2.8679380000000001,6.3518249999999998]
[1.0772969999999999,11.923069999999999,7.40672E-2,-0.66348689999999999,8.3940999999999998E-3,-0.8307812,0.94485960000000002,3.4698549999999999,6.7621919999999998]
[0.62789969999999995,9.4355860000000007,7.0957699999999999E-2,-0.67970660000000005,1.8440499999999999E-2,-0.97753060000000003,0.60074649999999996,3.0405669999999998,6.1447500000000002]
[0.77325829999999995,10.37857,7.5704900000000006E-2,-0.7088295,1.4654199999999999E-2,-1.1064290000000001,0.67411560000000004,3.1045959999999999,6.4503450000000004]
[0.68452020000000002,10.562709999999999,7.0610500000000007E-2,-0.7452377,2.8797699999999999E-2,-1.217411,0.5583555,3.0419999999999998,6.6106040000000004]

{"sheet":"RUM_para","index":12,"n_rows":101,"n_cols":6,"rows_kept":101,"cut":false,"hidden":true,"merged":[]}
["Quality A","Quality B","Quality C","Quality D","Quality E","cost"]
[2.6133055686950684,1.9535431861877441,1.0110306739807129,0.21486355364322662,-0.12863759696483612,-1.5813326463103294E-2]
[2.4695706367492676,1.9216153621673584,0.94524568319320679,5.9655953198671341E-2,-0.13419681787490845,-1.5569405630230904E-2]
[2.6636309623718262,1.9174635410308838,1.0286768674850464,0.18524964153766632,-0.14027705788612366,-1.5370877459645271E-2]
[2.5319902896881104,1.9277571439743042,1.0443706512451172,0.20789915323257446,-0.11603754013776779,-1.553534809499979E-2]
[2.4871852397918701,1.8231496810913086,0.9175649881362915,0.12283848226070404,-0.14881142973899841,-1.4942340552806854E-2]
[2.5236847400665283,1.9413386583328247,0.96213966608047485,4.2782489210367203E-2,-6.9125145673751831E-3,-1.4740810729563236E-2]
[2.643791675567627,1.9986451864242554,1.0194664001464844,0.19172194600105286,-0.23898747563362122,-1.605951227247715E-2]
[2.4787075519561768,1.8741468191146851,0.9543609619140625,0.18814978003501892,-0.12250062078237534,-1.4926228672266006E-2]
[2.5474014282226562,1.9350841045379639,0.9328378438949585,0.11259244382381439,-0.10776188224554062,-1.518250722438097E-2]
[2.4559566974639893,1.8986300230026245,0.92249602079391479,0.22127586603164673,-0.18146747350692749,-1.5656014904379845E-2]
[2.4789462089538574,1.9180512428283691,0.99448388814926147,0.14311374723911285,-0.13982592523097992,-1.5167794190347195E-2]
[2.6158361434936523,1.9687424898147583,0.97378659248352051,0.1523142009973526,-9.0748243033885956E-2,-1.6107840463519096E-2]
[2.4537949562072754,1.7914732694625854,0.93123084306716919,9.1912053525447845E-2,-0.1553676426410675,-1.4110746793448925E-2]
[2.5979001522064209,1.9779225587844849,1.0397803783416748,0.14081467688083649,-0.1235249936580658,-1.5329004265367985E-2]
[2.5808966159820557,1.9551740884780884,0.95695620775222778,0.22323627769947052,-1.4258319512009621E-2,-1.4670593664050102E-2]
[2.4660413265228271,1.8619273900985718,0.95511269569396973,0.24136872589588165,-0.1572919487953186,-1.4578287489712238E-2]
[2.6654002666473389,1.9590872526168823,1.0190261602401733,0.2265695333480835,-7.3993176221847534E-2,-1.5918664634227753E-2]
[2.5906739234924316,2.0253477096557617,1.0658732652664185,0.13531747460365295,-8.1452243030071259E-2,-1.641320064663887E-2]
[2.5223677158355713,1.9208297729492187,1.0618355274200439,0.21064290404319763,-5.5472724139690399E-2,-1.4741459861397743E-2]
[2.6019010543823242,1.9164383411407471,0.89213269948959351,0.14818795025348663,-0.11692771315574646,-1.5369946137070656E-2]
[2.5269818305969238,1.929227352142334,0.92791658639907837,0.14439550042152405,-4.8632543534040451E-2,-1.459198072552681E-2]
[2.5970652103424072,2.0143425464630127,1.077589750289917,0.25525203347206116,-3.1396102160215378E-2,-1.6081864014267921E-2]
[2.3098852634429932,1.7134793996810913,0.87687724828720093,0.10947725921869278,-0.1978752464056015,-1.396496407687664E-2]
[2.632932186126709,1.9648383855819702,1.0316892862319946,0.28608393669128418,-4.7806289047002792E-2,-1.5628093853592873E-2]
[2.6120531558990479,1.8458913564682007,1.0801280736923218,0.1134871318936348,-0.11852330714464188,-1.5593841671943665E-2]
[2.3847024440765381,1.8244489431381226,0.93123352527618408,0.13639360666275024,-0.1513686329126358,-1.4101879671216011E-2]
[2.6441116333007812,1.9143282175064087,1.0074694156646729,0.21202188730239868,-0.10467099398374557,-1.5264649875462055E-2]
[2.5965933799743652,2.0373692512512207,1.0717071294784546,0.26155859231948853,-0.11985843628644943,-1.739661768078804E-2]
[2.5336940288543701,1.8871402740478516,1.0096570253372192,0.12887020409107208,-0.20806355774402618,-1.5458701178431511E-2]
[2.5322933197021484,1.8618221282958984,0.96048372983932495,0.13274270296096802,-0.16675911843776703,-1.5629317611455917E-2]
[2.5826611518859863,1.8577463626861572,0.9305034875869751,0.17033901810646057,-8.2023449242115021E-2,-1.4799686148762703E-2]
[2.6322734355926514,1.9284336566925049,1.003914475440979,0.20338673889636993,-0.15369004011154175,-1.6158135607838631E-2]
[2.6805157661437988,2.0586843490600586,0.97178500890731812,0.10041479021310806,-2.4801634252071381E-2,-1.6402995213866234E-2]
[2.6317577362060547,2.0760672092437744,1.0464138984680176,0.30739399790763855,-0.11131804436445236,-1.6841195523738861E-2]
[2.6239414215087891,1.9110966920852661,1.0365856885910034,0.1700851172208786,-0.14774791896343231,-1.5974031761288643E-2]
[2.7328102588653564,2.0147669315338135,1.0391963720321655,0.22534939646720886,-1.1231809854507446E-2,-1.6410507261753082E-2]
[2.654278039932251,1.9925130605697632,1.0080944299697876,0.19518445432186127,-0.23416836559772491,-1.6407925635576248E-2]
[2.4335753917694092,1.9483011960983276,0.93131768703460693,0.21152980625629425,-5.4363317787647247E-2,-1.5469521284103394E-2]
[2.477663516998291,1.8780384063720703,0.91207683086395264,0.16295212507247925,-9.3963891267776489E-2,-1.4924364164471626E-2]
[2.551440954208374,1.8960945606231689,0.9544525146484375,9.8580963909626007E-2,-0.13950364291667938,-1.5450062230229378E-2]
[2.4796576499938965,1.8295791149139404,0.99176299571990967,0.19564417004585266,-0.1238768994808197,-1.5565847977995872E-2]
[2.644371509552002,1.9839707612991333,1.0457147359848022,0.20247632265090942,-2.6955731213092804E-2,-1.5007385984063148E-2]
[2.6290867328643799,2.0026016235351562,1.0060437917709351,0.19802796840667725,-0.11692041158676147,-1.5688488259911537E-2]
[2.5808203220367432,1.9867713451385498,1.1030091047286987,0.26982006430625916,-9.1849446296691895E-2,-1.6270210966467857E-2]
[2.6329727172851562,1.9111510515213013,1.0421006679534912,0.18815092742443085,-0.10213875770568848,-1.5602673403918743E-2]
[2.4163322448730469,1.9356843233108521,0.98390525579452515,0.17400786280632019,-0.14830866456031799,-1.5182963572442532E-2]
[2.7141375541687012,1.9777858257293701,1.0304110050201416,0.17911341786384583,-9.6358172595500946E-2,-1.6777630895376205E-2]
[2.4886476993560791,1.8466521501541138,0.94591045379638672,0.15025517344474792,-0.12984125316143036,-1.5175525099039078E-2]
[2.4891707897186279,1.8857971429824829,0.87591487169265747,0.16187244653701782,-0.19295458495616913,-1.5561035834252834E-2]
[2.5866611003875732,2.0004384517669678,0.99744480848312378,0.18910183012485504,-0.11087282001972198,-1.5854565426707268E-2]
[2.5317509174346924,1.9056715965270996,0.94166851043701172,0.11095594614744186,-0.13748401403427124,-1.5390587039291859E-2]
[2.5469858646392822,1.9601378440856934,0.99897581338882446,0.2910473644733429,-8.1626936793327332E-2,-1.5934018418192863E-2]
[2.4332315921783447,1.8234260082244873,0.99488192796707153,0.15343901515007019,-0.1905265748500824,-1.4863114804029465E-2]
[2.6097335815429687,1.9055670499801636,0.9481157660484314,0.11628051102161407,-9.6203170716762543E-2,-1.5943938866257668E-2]
[2.4672274589538574,1.9258753061294556,0.92772799730300903,0.1540534645318985,-0.10288513451814651,-1.5123941004276276E-2]
[2.6809537410736084,2.0047264099121094,1.0789852142333984,0.21479414403438568,-8.0750949680805206E-2,-1.6760276630520821E-2]
[2.6815929412841797,2.0891990661621094,1.1165293455123901,0.23437945544719696,-2.1983448415994644E-2,-1.6945153474807739E-2]
[2.4065287113189697,1.7966786623001099,0.92557913064956665,0.20643578469753265,-0.16370542347431183,-1.4762324281036854E-2]
[2.7174866199493408,2.0481352806091309,1.0810556411743164,0.19090470671653748,-0.11642327159643173,-1.5702199190855026E-2]
[2.5452010631561279,1.9442421197891235,1.0527803897857666,0.216973677277565,-0.12051980197429657,-1.6469120979309082E-2]
[2.6552684307098389,1.9823216199874878,1.0658936500549316,0.25304687023162842,-4.2052667587995529E-2,-1.6012838110327721E-2]
[2.492236852645874,1.8810757398605347,1.012441873550415,0.13381880521774292,-4.3332871049642563E-2,-1.4870409853756428E-2]
[2.5499963760375977,1.8207551240921021,0.91858911514282227,7.4587799608707428E-2,-9.833238273859024E-2,-1.4659963548183441E-2]
[2.512223482131958,1.8700059652328491,0.87191915512084961,0.12764592468738556,-6.0255128890275955E-2,-1.4821702614426613E-2]
[2.5862674713134766,2.0000665187835693,1.0191668272018433,0.14477773010730743,-8.705776184797287E-2,-1.5969011932611465E-2]
[2.618558406829834,1.9791512489318848,0.95554864406585693,0.1712261289358139,-9.7132101655006409E-2,-1.5764178708195686E-2]
[2.5405223369598389,1.9013009071350098,0.91885226964950562,0.1432482898235321,-5.2993886172771454E-2,-1.5099547803401947E-2]
[2.4796175956726074,1.8291620016098022,0.97909945249557495,0.15391793847084045,-5.1841847598552704E-2,-1.4397229067981243E-2]
[2.6790106296539307,1.9933826923370361,1.1132661104202271,0.33651235699653625,-0.18758560717105865,-1.6902463510632515E-2]
[2.5397076606750488,1.9118984937667847,1.0364711284637451,0.19010536372661591,-7.4238024652004242E-2,-1.5864405781030655E-2]
[2.5305805206298828,1.957782506942749,0.96622705459594727,0.15955632925033569,-0.22375735640525818,-1.5829002484679222E-2]
[2.4480035305023193,1.9075096845626831,1.0025292634963989,0.1411074697971344,-8.7908633053302765E-2,-1.482847984880209E-2]
[2.8596427440643311,2.0857264995574951,1.0968968868255615,0.19231429696083069,-9.957219660282135E-2,-1.754075288772583E-2]
[2.511014461517334,1.8359277248382568,0.99215400218963623,0.17596684396266937,9.7091672942042351E-3,-1.4493904076516628E-2]
[2.5176076889038086,1.8880554437637329,0.99096345901489258,0.16992945969104767,-8.6205512285232544E-2,-1.5328768640756607E-2]
[2.4933261871337891,1.9604346752166748,1.0140302181243896,0.28101447224617004,-9.0753428637981415E-2,-1.5325102023780346E-2]
[2.7028155326843262,2.0392611026763916,1.0684527158737183,0.2047058641910553,-0.12858936190605164,-1.6709212213754654E-2]
[2.5224883556365967,1.9208084344863892,1.0192883014678955,0.20688442885875702,-0.26647534966468811,-1.5400263480842113E-2]
[2.6676814556121826,1.944817066192627,0.97153490781784058,0.25157618522644043,-1.3828419148921967E-2,-1.6109209507703781E-2]
[2.6265389919281006,1.946662425994873,1.0551236867904663,0.20655858516693115,-3.9711050689220428E-2,-1.6494536772370338E-2]
[2.6232008934020996,1.9731802940368652,0.95951849222183228,0.19120696187019348,-0.1224265918135643,-1.5383865684270859E-2]
[2.5000615119934082,1.8901757001876831,0.89865368604660034,0.19676719605922699,-9.0420760214328766E-2,-1.4096124097704887E-2]
[2.7170517444610596,2.0538370609283447,1.0030514001846313,0.23045435547828674,-0.12460803240537643,-1.7191279679536819E-2]
[2.5410647392272949,1.9065203666687012,0.93864095211029053,5.7715483009815216E-2,-1.6186034306883812E-2,-1.5186541713774204E-2]
[2.6117024421691895,1.9700479507446289,1.0948541164398193,0.19116075336933136,-9.4152957201004028E-2,-1.5848768875002861E-2]
[2.6205313205718994,1.9144582748413086,1.0241376161575317,0.19889248907566071,-3.9694957435131073E-2,-1.5367751941084862E-2]
[2.4968078136444092,1.994330883026123,0.87878352403640747,0.16609656810760498,-8.705274760723114E-2,-1.5700206160545349E-2]
[2.489365816116333,1.8923083543777466,0.90390646457672119,0.11704908311367035,-0.10825632512569427,-1.4718925580382347E-2]
[2.5077531337738037,1.7739295959472656,0.82272595167160034,5.6463386863470078E-2,-0.17751938104629517,-1.448330283164978E-2]
[2.4041564464569092,1.8760708570480347,0.9661669135093689,0.13075341284275055,-0.10111741721630096,-1.3682650402188301E-2]
[2.4806034564971924,1.9165946245193481,0.95530247688293457,7.3816530406475067E-2,-0.16901123523712158,-1.5491592697799206E-2]
[2.5089616775512695,1.9534728527069092,1.0644437074661255,0.14866088330745697,-0.1145520880818367,-1.588255912065506E-2]
[2.630833625793457,1.9358316659927368,1.0017516613006592,0.18619421124458313,-9.4955012202262878E-2,-1.6337346285581589E-2]
[2.6151955127716064,1.9388657808303833,0.9960932731628418,0.19373877346515656,-0.1464662104845047,-1.5678822994232178E-2]
[2.5527877807617187,1.8859148025512695,0.99992281198501587,0.24644671380519867,-3.355691209435463E-2,-1.5134077519178391E-2]
[2.6332082748413086,2.0084242820739746,0.96494448184967041,0.29427307844161987,-6.0442149639129639E-2,-1.5701664611697197E-2]
[2.5243618488311768,1.8899482488632202,0.92088836431503296,0.16043691337108612,-0.15750938653945923,-1.5178820118308067E-2]
[2.59564208984375,1.9313619136810303,1.0105224847793579,0.14674170315265656,-0.13370776176452637,-1.5709001570940018E-2]
[2.6875250339508057,2.0026395320892334,1.0281522274017334,0.11122731119394302,-0.12906548380851746,-1.5897205099463463E-2]
[2.5149540901184082,1.8791069984436035,1.0570436716079712,0.16305315494537354,-0.14738288521766663,-1.533209253102541E-2]

{"sheet":"Annual Input Data","index":14,"n_rows":22,"n_cols":12,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,2,0,6],[0,7,0,11],[0,0,1,0],[0,1,1,1]]}
["Year","Trips","Baseline",null,null,null,null,"Counterfactual"]
[null,null,"Total Nitrogen (mg/l)","Total Phosphorus (mg/l)","Chlorophyll a (ug/l)","Secchi Depth (m)","Turbidity  (NTU)","Total Nitrogen (mg/l)","Total Phosphorus (mg/l)","Chlorophyll a (ug/l)","Secchi Depth (m)","Turbidity  (NTU)"]
[1,900000,0.76,0.05,33,0.7,9.6499999999999986,0.76,0.05,33,0.7,9.65]
[2,900000,0.76,0.05,33,0.7,9.6499999999999986,0.76,0.05,33,0.7,9.65]
[3,900000,0.76,0.05,33,0.7,9.6499999999999986,0.76,0.05,33,0.7,9.65]
[4,900000,0.76,0.05,33,0.7,9.6499999999999986,0.76,0.05,33,0.7,9.65]
[5,900000,0.76,0.05,33,0.7,9.6499999999999986,0.76,0.05,33,0.7,9.65]
[6,900000,0.76,0.05,33,0.7,9.6499999999999986,0.7,0.05,24,0.74,9.0500000000000007]
[7,900000,0.76,0.05,33,0.7,9.6499999999999986,0.7,0.05,24,0.74,9.0500000000000007]
[8,900000,0.76,0.05,33,0.7,9.6499999999999986,0.7,0.05,24,0.74,9.0500000000000007]
[9,900000,0.76,0.05,33,0.7,9.6499999999999986,0.7,0.05,24,0.74,9.0500000000000007]
[10,900000,0.76,0.05,33,0.7,9.6499999999999986,0.7,0.05,24,0.74,9.0500000000000007]
[11,900000,0.76,0.05,33,0.7,9.6499999999999986,0.7,0.05,24,0.74,9.0500000000000007]
[12,900000,0.76,0.05,33,0.7,9.6499999999999986,0.7,0.05,24,0.74,9.0500000000000007]
[13,900000,0.76,0.05,33,0.7,9.6499999999999986,0.7,0.05,24,0.74,9.0500000000000007]
[14,900000,0.76,0.05,33,0.7,9.6499999999999986,0.7,0.05,24,0.74,9.0500000000000007]
[15,900000,0.76,0.05,33,0.7,9.6499999999999986,0.7,0.05,24,0.74,9.0500000000000007]
[16,900000,0.76,0.05,33,0.7,9.6499999999999986,0.7,0.05,24,0.74,9.0500000000000007]
[17,900000,0.76,0.05,33,0.7,9.6499999999999986,0.7,0.05,24,0.74,9.0500000000000007]
[18,900000,0.76,0.05,33,0.7,9.6499999999999986,0.7,0.05,24,0.74,9.0500000000000007]
[19,900000,0.76,0.05,33,0.7,9.6499999999999986,0.7,0.05,24,0.74,9.0500000000000007]
[20,900000,0.76,0.05,33,0.7,9.6499999999999986,0.7,0.05,24,0.74,9.0500000000000007]

{"sheet":"Annual Output","index":15,"n_rows":22,"n_cols":16,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,1,0,7],[0,10,0,14]]}
[null,"Annual Value",null,null,null,null,null,null,null,null,"NPV"]
["Year","Mean (Xbar)","St. Dev (s)","Min","1st Quartile","Median","3rd Quartile","Max",null,"Discount Rate","Mean (Xbar)","Min","1st Quartile","Median","3rd Quartile","Max"]
[1,0,0,0,0,0,0,0,null,0,{"$f":"NPV($J3,OFFSET(B$2,0,0,COUNTA(B:B)))","v":200699790},{"$f":"NPV($J3,OFFSET(C$2,0,0,COUNTA(C:C)))","v":13842360},{"$f":"NPV($J3,OFFSET(D$2,0,0,COUNTA(D:D)))","v":174864405},{"$f":"NPV($J3,OFFSET(E$2,0,0,COUNTA(E:E)))","v":190710180},{"$f":"NPV($J3,OFFSET(F$2,0,0,COUNTA(F:F)))","v":200974785},{"$f":"NPV($J3,OFFSET(G$2,0,0,COUNTA(G:G)))","v":211098540}]
[2,0,0,0,0,0,0,0,null,0.03,{"$f":"NPV($J4,OFFSET(B$2,0,0,COUNTA(B:B)))","v":137783987.29948434},{"$f":"NPV($J4,OFFSET(C$2,0,0,COUNTA(C:C)))","v":9503027.155309381},120047534.46753427,130925941.77105206,137972776.27423823,144922914.73897249]
[3,0,0,0,0,0,0,0,null,0.05,{"$f":"NPV($J5,OFFSET(B$2,0,0,COUNTA(B:B)))","v":108815862.6718732},{"$f":"NPV($J5,OFFSET(C$2,0,0,COUNTA(C:C)))","v":7505081.8180459011},{"$f":"NPV($J5,OFFSET(D$2,0,0,COUNTA(D:D)))","v":94808375.637457386},{"$f":"NPV($J5,OFFSET(E$2,0,0,COUNTA(E:E)))","v":103399673.49745716},{"$f":"NPV($J5,OFFSET(F$2,0,0,COUNTA(F:F)))","v":108964960.07828031},114453880.28992422]
[4,0,0,0,0,0,0,0,null,7.0000000000000007E-2,86887177.998592049,5992650.0034733005,75702494.172280326,82562464.842656404,87006229.142161861,91389016.501825437]
[5,0,0,0,0,0,0,0]
[6,13379986,922824,11657627,12714012,13398319,14073236,15806490]
[7,13379986,922824,11657627,12714012,13398319,14073236,15806490]
[8,13379986,922824,11657627,12714012,13398319,14073236,15806490]
[9,13379986,922824,11657627,12714012,13398319,14073236,15806490]
[10,13379986,922824,11657627,12714012,13398319,14073236,15806490]
[11,13379986,922824,11657627,12714012,13398319,14073236,15806490]
[12,13379986,922824,11657627,12714012,13398319,14073236,15806490]
[13,13379986,922824,11657627,12714012,13398319,14073236,15806490]
[14,13379986,922824,11657627,12714012,13398319,14073236,15806490]
[15,13379986,922824,11657627,12714012,13398319,14073236,15806490]
[16,13379986,922824,11657627,12714012,13398319,14073236,15806490]
[17,13379986,922824,11657627,12714012,13398319,14073236,15806490]
[18,13379986,922824,11657627,12714012,13398319,14073236,15806490]
[19,13379986,922824,11657627,12714012,13398319,14073236,15806490]
[20,13379986,922824,11657627,12714012,13398319,14073236,15806490]