{"text_format":"1","workbook":"xlsx","n_sheets":15,"sheets":["Read Me","User Interface","ProjAdjust&Defaults","Counties","CapConstr","FacMaint","EquipServ","DayTrips","Overnights","CountyHealth","HealthCycl","HealthPed","ProdCycl","ProdPed","Raw"],"not_rendered":{"charts":3,"images":0,"macros":1,"external_links":0,"defined_names":12,"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":"Read Me","index":0,"n_rows":31,"n_cols":4,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Welcome to the Active Transportation Infrastructure Economic Benefits Calculator"]
[]
[null,"Description:",null,"This tool calculates the monetary direct, indirect, and induced benefits of investment in active transportation infrastructure given a set of user inputs on costs and facility use."]
[]
[null,"Analysis Framework:",null,"The analysis uses economic and demographic characteristics for counties in Utah and a list of six (6) generalized project types."]
[]
[null,"Source:",null,"Economic Impacts of Active Transportation - Utah Active Transportation Benefits Study (UATBS) - March 2017 - Prepared by Urban Design 4 Health with Fehr & Peers and HDR Engineering, Inc. for Utah Transit Authority"]
[]
[null,"Funding Partners for Study:",null,"Utah Department of Transportation, Wasatch Front Regional Council, Mountainland Association of Governments, Utah Department of Health, Bike Utah, Weber-Morgan Health Department, Salt Lake County Health Department, Salt Lake County Office of Regional Development, Salt lake County Bicycle Advisory Committee, Tooele County Department of Health, Park City, Intermountain Healthcare, and the Governor's Office of Energy Development"]
[]
[null,"Study Results:",null,"The UATBS employed a software called IMPLAN. IMPLAN was used to calculate multipliers for each county and each benefit factor using \"an input-output based regional economic assessment modeling system.\" The software uses transaction information and data on 20 other economic variables. These multipliers are used and included in this calculator. They can be viewed in the supporting tabs of the spreadsheet."]
[]
[null,"Instructions:"]
[null,1,null,"Users can input data in shaded cells only"]
[null,2,null,"You must choose a county. If the project crosses county lines you may choose to analyze the benefits for the whole project in the county with the majority of the length or perform an analysis in each county using only the length and user-miles that would occur in each county and add them to determine the total benefit. "]
[null,3,null,"Choose the project type from the drop down list that best describes the infrastructure improvement you are analyzing. Similarly to County, if the project type changes along its length you can choose whether to assume the same project type for it's entirety as a good approximation or split the analysis into parts based on each project type and its corresponding length. Be careful to also split the usage so as not to double count."]
[null,4,null,"Input the project length in miles. Use a decimal amount for less than one mile. "]
[null,5,null,"If the project is completely new to an area and has independent utility, then the connected miles will equal the project length. If the project is filling a gap in an existing linear path, then the connected miles are those that a user can now travel because the project has connected adjacent paths. Include the length of the project and only those miles directly connected to the project."]
[null,6,null,"Input a capital cost. This number should be the total dollar amount that you want figured into the economic benefit analysis. Hard and soft costs can be included as long as there is money exchanged. "]
[null,7,null,"Input an annual incremental maintenance cost. Some care should be taken to determine a discrete maintenance cost due to the project, in other words, costs above and beyond any current maintenance costs."]
[null,8,null,"Use the \"buttons\" to choose the method for project usage data input. Putting in your own values gives you the most accurate data. Go to the \"ProjAdjust&Defaults\" tab for an explanation of the default values to determine whether they might work for your analysis."]
[null,9,null,"Local users are those people who live in the area and are more likely to use the facility often and spontaneously. The economic impact of an active transportation project is created from new user-miles due to the existence of the project. It includes new users, additional miles from existing users, or induced use on connecting facilities. Input low, medium, and high estimates for users per day, miles per user, and days per year. The tool calculates the annual number based on the averages you put in, and uses only that total in the analysis. If you know an annual number, you can input any values that arrive at that number."]
[null,10,null,"Visitors, tourists and event-goers are people who make a special trip (either day or overnight) to use the facility. They are in addition to local users. In order to assess the visitor impact of the project, be sure to only include those day or overnight trips that would be added to your current visitation rates because of the existence of the project you are considering. These should be input as annual estimates. The analysis is very sensitive to these data, take care to use realistic values for visitor and event estimates."]
[]
[null,"Notes:"]
[null,null,null,"Users are encouraged to familiarize themselves with the Utah Active Transportation Benefits Study for greater understanding of their results."]
[null,null,null,"Output can be displayed on two sides of 11x17 paper in landscape format."]
[null,null,null,"Equipment and Services benefits are only calculated for cyclists and only occur in counties where cycling equipment related businesses are located."]
[null,null,null,"Health and Productivity benefits are only calculated for those local users, assuming a county-specific percentage of the population, that are not getting the recommended amount of exercise of 150 minutes per week."]
[null,null,null,"The Utah Active Transportation Infrastructure Economic Benefits Calculator is a newly developed spreadsheet tool that has not been widely distributed. If you find bugs or have suggestions to improve its usefulness, please submit them to kdoane@rideuta.com with reference to AT Benefits Calculator."]

{"sheet":"User Interface","index":1,"n_rows":69,"n_cols":10,"rows_kept":69,"cut":false,"hidden":false,"merged":[]}
["Read me reference"]
[null,null,"User input in shaded cells",null,null,null,null,"Some factors from Utah Active Transportation Benefits Study Report"]
[null,null,null,null,null,null,null,"Avg Cycling speed (mph)",12]
[1,"Project Name",null,null,null,null,null,"Avg Walking speed (mph)",3]
[null,"Scenario Description",null,null,null,null,null,"Cycling equipment spending per rider mile",0.85]
[null,"Tool user",null,null,null,null,null,"Day Trip spending per person per trip",35,"$35 dollars default value "]
[null,"Run Date",{"$f":"TODAY()","v":"2018-11-08"},null,null,null,null,"Overnight spending per person per trip",182,"$182 dollars default value"]
[null,null,null,null,null,null,null,"% of Trips that are Day trips",0.28000000000000003,"28% is default"]
[2,"In what County is the project located? (use drop down list)","Beaver",null,null,null,null,"Typical Capital cost of multi-use trail per mile",750000]
[3,"Choose the project type that best fits the scenario you are analyzing (use drop down list)","Base - road infrastructure with no bike/ped facilities",{"$f":"IF(C10='ProjAdjust&Defaults'!A6,\"None\",IF(C10='ProjAdjust&Defaults'!A7,\"Cyclists Only\",IF(OR(C10='ProjAdjust&Defaults'!A10,C10='ProjAdjust&Defaults'!A12)=TRUE,\"Pedestrians Only\",\"Both\")))","v":"None"},null,null,null,"Annual cost to maintain a multi-use trail per mile",6300]
[4,"How many miles long is the project?",0,null,null,null,null,"Average mile per year per cyclist",547]
[5,"How many connected miles might a user now travel because of the existence of the project that they couldn't before?",0]
[6,"What is the total estimated capital cost of the project?",0,{"$f":"C13/C11","v":{"$error":"#DIV/0!"}},"per mile"]
[7,"Also, estimate what it will cost to maintain this project only, each year.",0,{"$f":"C14/C11","v":{"$error":"#DIV/0!"}},"per mile"]
[]
[8,"Estimate use of project - you must select one of the two options. "]
[]
[null,null,null,"Less than Hoped For","Estimated Use","More than Hoped For"]
[9,"Local users ","Average Cyclist per day"]
[null,null,"Average Miles per rider"]
[null,null,"Average Days per Year"]
[null,null,"Rider-miles per year",{"$f":"D19*D20*D21","v":0},{"$f":"E19*E20*E21","v":0},0]
[]
[null,null,"Average Walkers per day"]
[null,null,"Average Miles per walker"]
[null,null,"Average Days per Year"]
[null,null,"Pedestrian-miles per year",{"$f":"D24*D25*D26","v":0},{"$f":"E24*E25*E26","v":0},0]
[]
[10,"Tourism or Events - Visitors that use the Project","Day trips per year (count each person as a trip)"]
[null,null,"Overnight trips per year (count each person-night as a trip, e.g. 2 people for 2 nights = 4 trips)"]
[]
[]
[null,null,"Results"]
[null,null,null,"One-time Total Economic Output","# of jobs-years, not necessarily permanent or full-time","Labor Income"]
[null,null,"Capital Construction",{"$f":"ROUND($C$13*INDEX(TblCapConstr[$ Total Output ],MATCH(MyCountySelection,TblCapConstr[[County]:[County]],0)),-2)","v":0},{"$f":"ROUND($C$13/1000000*INDEX(TblCapConstr['# of Jobs Per $Million],MATCH($C$9,TblCapConstr[County],0))*INDEX(TblProjAdjDefaults[Job and Income Adjustment Factor],MATCH($C$10,TblProjAdjDefaults[Project Types],0)),1)","v":0},{"$f":"ROUND($C$13*INDEX(TblCapConstr[$ Income],MATCH(MyCountySelection,TblCapConstr[[County]:[County]],0))*INDEX(TblProjAdjDefaults[Job and Income Adjustment Factor],MATCH($C$10,TblProjAdjDefaults[Project Types],0)),-2)","v":0}]
[]
[]
[null,null,"Annual Economic Output","Less than Hoped For","Estimated Use","More than Hoped For"]
[null,null,"Total Annual Economic Output - sum of below",{"$f":"SUM(D40:D47)","v":0},{"$f":"SUM(E40:E47)","v":0},0]
[null,null,"Annual Facility Maintenance",{"$f":"ROUND($C$14*INDEX(TblFacMaint[$ Total Output ],MATCH(MyCountySelection,TblFacMaint[County],0)),-2)","v":0},{"$f":"ROUND($C$14*INDEX(TblFacMaint[$ Total Output ],MATCH(MyCountySelection,TblFacMaint[County],0)),-2)","v":0},{"$f":"ROUND($C$14*INDEX(TblFacMaint[$ Total Output ],MATCH(MyCountySelection,TblFacMaint[County],0)),-2)","v":0}]
[null,null,"Equipment and Services",{"$f":"IF(UserGroup=\"Pedestrians Only\",0,ROUND($I$5*D$22*INDEX(TblEquipServ[[$ Total Output ]:[$ Total Output ]],MATCH(MyCountySelection,TblEquipServ[[County]:[County]],0)),-2))","v":0},{"$f":"IF(UserGroup=\"Pedestrians Only\",0,ROUND($I$5*E$22*INDEX(TblEquipServ[[$ Total Output ]:[$ Total Output ]],MATCH(MyCountySelection,TblEquipServ[[County]:[County]],0)),-2))","v":0},{"$f":"IF(UserGroup=\"Pedestrians Only\",0,ROUND($I$5*F$22*INDEX(TblEquipServ[[$ Total Output ]:[$ Total Output ]],MATCH(MyCountySelection,TblEquipServ[[County]:[County]],0)),-2))","v":0}]
[null,null,"Day Trips",{"$f":"ROUND($I$6*D$29*INDEX(TblDayTrips[[$ Total Output ]:[$ Total Output ]],MATCH(MyCountySelection,TblDayTrips[[County]:[County]],0)),-2)","v":0},{"$f":"ROUND($I$6*E$29*INDEX(TblDayTrips[[$ Total Output ]:[$ Total Output ]],MATCH(MyCountySelection,TblDayTrips[[County]:[County]],0)),-2)","v":0},{"$f":"ROUND($I$6*F$29*INDEX(TblDayTrips[[$ Total Output ]:[$ Total Output ]],MATCH(MyCountySelection,TblDayTrips[[County]:[County]],0)),-2)","v":0}]
[null,null,"Overnight trips",{"$f":"ROUND($I$7*D$30*INDEX(TblOvernights[[$ Total Output ]:[$ Total Output ]],MATCH(MyCountySelection,TblOvernights[[County]:[County]],0)),-2)","v":0},{"$f":"ROUND($I$7*E$30*INDEX(TblOvernights[[$ Total Output ]:[$ Total Output ]],MATCH(MyCountySelection,TblOvernights[[County]:[County]],0)),-2)","v":0},{"$f":"ROUND($I$7*F$30*INDEX(TblOvernights[[$ Total Output ]:[$ Total Output ]],MATCH(MyCountySelection,TblOvernights[[County]:[County]],0)),-2)","v":0}]
[null,null,"Annual Healthcare Savings - Cyclist",{"$f":"IF($D$10=\"pedestrians only\",0,ROUND(D$22*INDEX(TblCountyHealth[[% Insufficiently active]:[% Insufficiently active]],MATCH(MyCountySelection,TblHealthCycl[[County]:[County]],0))*INDEX(TblHealthCycl[[$ Total Output ]:[$ Total Output ]],MATCH(MyCountySelection,TblHealthCycl[[County]:[County]],0))*INDEX(TblHealthCycl[[Annual Expenditures ($2016) avoided per Rider-Mile]:[Annual Expenditures ($2016) avoided per Rider-Mile]],MATCH(MyCountySelection,TblHealthCycl[[County]:[County]],0)),-2))","v":0},{"$f":"IF($D$10=\"pedestrians only\",0,ROUND(E$22*INDEX(TblCountyHealth[[% Insufficiently active]:[% Insufficiently active]],MATCH(MyCountySelection,TblHealthCycl[[County]:[County]],0))*INDEX(TblHealthCycl[[$ Total Output ]:[$ Total Output ]],MATCH(MyCountySelection,TblHealthCycl[[County]:[County]],0))*INDEX(TblHealthCycl[[Annual Expenditures ($2016) avoided per Rider-Mile]:[Annual Expenditures ($2016) avoided per Rider-Mile]],MATCH(MyCountySelection,TblHealthCycl[[County]:[County]],0)),-2))","v":0},{"$f":"IF($D$10=\"pedestrians only\",0,ROUND(F$22*INDEX(TblCountyHealth[[% Insufficiently active]:[% Insufficiently active]],MATCH(MyCountySelection,TblHealthCycl[[County]:[County]],0))*INDEX(TblHealthCycl[[$ Total Output ]:[$ Total Output ]],MATCH(MyCountySelection,TblHealthCycl[[County]:[County]],0))*INDEX(TblHealthCycl[[Annual Expenditures ($2016) avoided per Rider-Mile]:[Annual Expenditures ($2016) avoided per Rider-Mile]],MATCH(MyCountySelection,TblHealthCycl[[County]:[County]],0)),-2))","v":0}]
[null,null,"Annual Healthcare Savings - Pedestrians",{"$f":"IF($D$10=\"cylcists only\",0,ROUND(D$27*INDEX(TblCountyHealth[[% Insufficiently active]:[% Insufficiently active]],MATCH(MyCountySelection,TblHealthCycl[[County]:[County]],0))*INDEX(TblHealthPed[[$ Total Output ]:[$ Total Output ]],MATCH(MyCountySelection,TblHealthPed[[County]:[County]],0))*INDEX(TblHealthPed[[Annual Expenditures ($2016) avoided per Person-Mile*]:[Annual Expenditures ($2016) avoided per Person-Mile*]],MATCH(MyCountySelection,TblHealthPed[[County]:[County]],0)),-2))","v":0},{"$f":"IF($D$10=\"cylcists only\",0,ROUND(E$27*INDEX(TblCountyHealth[[% Insufficiently active]:[% Insufficiently active]],MATCH(MyCountySelection,TblHealthCycl[[County]:[County]],0))*INDEX(TblHealthPed[[$ Total Output ]:[$ Total Output ]],MATCH(MyCountySelection,TblHealthPed[[County]:[County]],0))*INDEX(TblHealthPed[[Annual Expenditures ($2016) avoided per Person-Mile*]:[Annual Expenditures ($2016) avoided per Person-Mile*]],MATCH(MyCountySelection,TblHealthPed[[County]:[County]],0)),-2))","v":0},{"$f":"IF($D$10=\"cylcists only\",0,ROUND(F$27*INDEX(TblCountyHealth[[% Insufficiently active]:[% Insufficiently active]],MATCH(MyCountySelection,TblHealthCycl[[County]:[County]],0))*INDEX(TblHealthPed[[$ Total Output ]:[$ Total Output ]],MATCH(MyCountySelection,TblHealthPed[[County]:[County]],0))*INDEX(TblHealthPed[[Annual Expenditures ($2016) avoided per Person-Mile*]:[Annual Expenditures ($2016) avoided per Person-Mile*]],MATCH(MyCountySelection,TblHealthPed[[County]:[County]],0)),-2))","v":0}]
[null,null,"Annual Reduced Absenteeism - Cyclist",{"$f":"IF($D$10=\"Pedestrians Only\",0,ROUND(D$22*INDEX(TblCountyHealth[[% Insufficiently active]:[% Insufficiently active]],MATCH(MyCountySelection,TblProdCycl[[County]:[County]],0))*INDEX(TblProdCycl[[$ Total Output ]:[$ Total Output ]],MATCH(MyCountySelection,TblProdCycl[[County]:[County]],0))*INDEX(TblProdCycl[[Annual absentee days not taken per mile ridden]:[Annual absentee days not taken per mile ridden]],MATCH(MyCountySelection,TblProdCycl[[County]:[County]],0))*INDEX(TblProdCycl[[Output per Employee per day ($)]:[Output per Employee per day ($)]],MATCH(MyCountySelection,TblProdCycl[[County]:[County]],0)),-2))","v":0},{"$f":"IF($D$10=\"Pedestrians Only\",0,ROUND(E$22*INDEX(TblCountyHealth[[% Insufficiently active]:[% Insufficiently active]],MATCH(MyCountySelection,TblProdCycl[[County]:[County]],0))*INDEX(TblProdCycl[[$ Total Output ]:[$ Total Output ]],MATCH(MyCountySelection,TblProdCycl[[County]:[County]],0))*INDEX(TblProdCycl[[Annual absentee days not taken per mile ridden]:[Annual absentee days not taken per mile ridden]],MATCH(MyCountySelection,TblProdCycl[[County]:[County]],0))*INDEX(TblProdCycl[[Output per Employee per day ($)]:[Output per Employee per day ($)]],MATCH(MyCountySelection,TblProdCycl[[County]:[County]],0)),-2))","v":0},{"$f":"IF($D$10=\"Pedestrians Only\",0,ROUND(F$22*INDEX(TblCountyHealth[[% Insufficiently active]:[% Insufficiently active]],MATCH(MyCountySelection,TblProdCycl[[County]:[County]],0))*INDEX(TblProdCycl[[$ Total Output ]:[$ Total Output ]],MATCH(MyCountySelection,TblProdCycl[[County]:[County]],0))*INDEX(TblProdCycl[[Annual absentee days not taken per mile ridden]:[Annual absentee days not taken per mile ridden]],MATCH(MyCountySelection,TblProdCycl[[County]:[County]],0))*INDEX(TblProdCycl[[Output per Employee per day ($)]:[Output per Employee per day ($)]],MATCH(MyCountySelection,TblProdCycl[[County]:[County]],0)),-2))","v":0}]
[null,null,"Annual Reduced Absenteeism - Pedestrians",{"$f":"IF($D$10=\"Pedestrians Only\",0,ROUND(D$27*INDEX(TblCountyHealth[[% Insufficiently active]:[% Insufficiently active]],MATCH(MyCountySelection,TblProdPed[[County]:[County]],0))*INDEX(TblProdPed[[$ Total Output ]:[$ Total Output ]],MATCH(MyCountySelection,TblProdPed[[County]:[County]],0))*INDEX(TblProdPed[[Annual absentee days not taken per mile walked]:[Annual absentee days not taken per mile walked]],MATCH(MyCountySelection,TblProdPed[[County]:[County]],0))*INDEX(TblProdPed[[Output per Employee per day ($)]:[Output per Employee per day ($)]],MATCH(MyCountySelection,TblProdPed[[County]:[County]],0)),-2))","v":0},{"$f":"IF($D$10=\"Pedestrians Only\",0,ROUND(E$27*INDEX(TblCountyHealth[[% Insufficiently active]:[% Insufficiently active]],MATCH(MyCountySelection,TblProdPed[[County]:[County]],0))*INDEX(TblProdPed[[$ Total Output ]:[$ Total Output ]],MATCH(MyCountySelection,TblProdPed[[County]:[County]],0))*INDEX(TblProdPed[[Annual absentee days not taken per mile walked]:[Annual absentee days not taken per mile walked]],MATCH(MyCountySelection,TblProdPed[[County]:[County]],0))*INDEX(TblProdPed[[Output per Employee per day ($)]:[Output per Employee per day ($)]],MATCH(MyCountySelection,TblProdPed[[County]:[County]],0)),-2))","v":0},{"$f":"IF($D$10=\"Pedestrians Only\",0,ROUND(F$27*INDEX(TblCountyHealth[[% Insufficiently active]:[% Insufficiently active]],MATCH(MyCountySelection,TblProdPed[[County]:[County]],0))*INDEX(TblProdPed[[$ Total Output ]:[$ Total Output ]],MATCH(MyCountySelection,TblProdPed[[County]:[County]],0))*INDEX(TblProdPed[[Annual absentee days not taken per mile walked]:[Annual absentee days not taken per mile walked]],MATCH(MyCountySelection,TblProdPed[[County]:[County]],0))*INDEX(TblProdPed[[Output per Employee per day ($)]:[Output per Employee per day ($)]],MATCH(MyCountySelection,TblProdPed[[County]:[County]],0)),-2))","v":0}]
[]
[null,null,"Number of Job-years"]
[null,null,"Total Job-years  - sum of below",{"$f":"SUM(D51:D58)","v":0},{"$f":"SUM(E51:E58)","v":0},0]
[null,null,"Annual Facility Maintenance",{"$f":"ROUND($C$14/1000000*INDEX(TblFacMaint[['# of Jobs Per $Million]:['# of Jobs Per $Million]],MATCH(MyCountySelection,TblFacMaint[[County]:[County]],0))*INDEX(TblProjAdjDefaults[[Job and Income Adjustment Factor]:[Job and Income Adjustment Factor]],MATCH(ProjectSelect,TblProjAdjDefaults[[Project Types]:[Project Types]],0)),1)","v":0},{"$f":"ROUND($C$14/1000000*INDEX(TblFacMaint[['# of Jobs Per $Million]:['# of Jobs Per $Million]],MATCH(MyCountySelection,TblFacMaint[[County]:[County]],0))*INDEX(TblProjAdjDefaults[[Job and Income Adjustment Factor]:[Job and Income Adjustment Factor]],MATCH(ProjectSelect,TblProjAdjDefaults[[Project Types]:[Project Types]],0)),1)","v":0},{"$f":"ROUND($C$14/1000000*INDEX(TblFacMaint[['# of Jobs Per $Million]:['# of Jobs Per $Million]],MATCH(MyCountySelection,TblFacMaint[[County]:[County]],0))*INDEX(TblProjAdjDefaults[[Job and Income Adjustment Factor]:[Job and Income Adjustment Factor]],MATCH(ProjectSelect,TblProjAdjDefaults[[Project Types]:[Project Types]],0)),1)","v":0}]
[null,null,"Equipment and Services",{"$f":"IF($D$10=\"Pedestrians Only\",0,ROUND($I$5*D$22/1000000*INDEX(TblEquipServ[['# of Jobs Per $Million]:['# of Jobs Per $Million]],MATCH(MyCountySelection,TblEquipServ[[County]:[County]],0)),1))","v":0},{"$f":"IF($D$10=\"Pedestrians Only\",0,ROUND($I$5*E$22/1000000*VLOOKUP($C$9,EquipServ!$A$8:$D$36,3),1))","v":0},{"$f":"IF($D$10=\"Pedestrians Only\",0,ROUND($I$5*F$22/1000000*VLOOKUP($C$9,EquipServ!$A$8:$D$36,3),1))","v":0}]
[null,null,"Day Trips",{"$f":"ROUND($I$6*D$29/1000000*INDEX(TblDayTrips[['# of Jobs Per $Million]:['# of Jobs Per $Million]],MATCH(MyCountySelection,TblDayTrips[[County]:[County]],0)),1)","v":0},{"$f":"ROUND($I$6*E$29/1000000*INDEX(TblDayTrips[['# of Jobs Per $Million]:['# of Jobs Per $Million]],MATCH(MyCountySelection,TblDayTrips[[County]:[County]],0)),1)","v":0},{"$f":"ROUND($I$6*F$29/1000000*INDEX(TblDayTrips[['# of Jobs Per $Million]:['# of Jobs Per $Million]],MATCH(MyCountySelection,TblDayTrips[[County]:[County]],0)),1)","v":0}]
[null,null,"Overnight trips",{"$f":"ROUND($I$7*D$30/1000000*INDEX(TblOvernights[['# of Jobs Per $Million]:['# of Jobs Per $Million]],MATCH(MyCountySelection,TblDayTrips[[County]:[County]],0)),1)","v":0},{"$f":"ROUND($I$7*E$30/1000000*INDEX(TblOvernights[['# of Jobs Per $Million]:['# of Jobs Per $Million]],MATCH(MyCountySelection,TblDayTrips[[County]:[County]],0)),1)","v":0},{"$f":"ROUND($I$7*F$30/1000000*INDEX(TblOvernights[['# of Jobs Per $Million]:['# of Jobs Per $Million]],MATCH(MyCountySelection,TblDayTrips[[County]:[County]],0)),1)","v":0}]
[null,null,"Annual Healthcare Savings - Cyclist",{"$f":"IF($D$10=\"pedestrians only\",0,ROUND(D$22/1000000*INDEX(TblCountyHealth[[% Insufficiently active]:[% Insufficiently active]],MATCH(MyCountySelection,TblHealthCycl[[County]:[County]],0))*INDEX(TblHealthCycl[['# of Jobs Per $Million]:['# of Jobs Per $Million]],MATCH(MyCountySelection,TblHealthCycl[[County]:[County]],0))*INDEX(TblHealthCycl[[Annual Expenditures ($2016) avoided per Rider-Mile]:[Annual Expenditures ($2016) avoided per Rider-Mile]],MATCH(MyCountySelection,TblHealthCycl[[County]:[County]],0)),1))","v":0},{"$f":"IF($D$10=\"pedestrians only\",0,ROUND(E$22/1000000*INDEX(TblCountyHealth[[% Insufficiently active]:[% Insufficiently active]],MATCH(MyCountySelection,TblHealthCycl[[County]:[County]],0))*INDEX(TblHealthCycl[['# of Jobs Per $Million]:['# of Jobs Per $Million]],MATCH(MyCountySelection,TblHealthCycl[[County]:[County]],0))*INDEX(TblHealthCycl[[Annual Expenditures ($2016) avoided per Rider-Mile]:[Annual Expenditures ($2016) avoided per Rider-Mile]],MATCH(MyCountySelection,TblHealthCycl[[County]:[County]],0)),1))","v":0},{"$f":"IF($D$10=\"pedestrians only\",0,ROUND(F$22/1000000*INDEX(TblCountyHealth[[% Insufficiently active]:[% Insufficiently active]],MATCH(MyCountySelection,TblHealthCycl[[County]:[County]],0))*INDEX(TblHealthCycl[['# of Jobs Per $Million]:['# of Jobs Per $Million]],MATCH(MyCountySelection,TblHealthCycl[[County]:[County]],0))*INDEX(TblHealthCycl[[Annual Expenditures ($2016) avoided per Rider-Mile]:[Annual Expenditures ($2016) avoided per Rider-Mile]],MATCH(MyCountySelection,TblHealthCycl[[County]:[County]],0)),1))","v":0}]
[null,null,"Annual Healthcare Savings - Pedestrians",{"$f":"IF($D$10=\"pedestrians only\",0,ROUND(D$27/1000000*INDEX(TblCountyHealth[[% Insufficiently active]:[% Insufficiently active]],MATCH(MyCountySelection,TblHealthCycl[[County]:[County]],0))*INDEX(TblHealthPed[['# of Jobs Per $Million]:['# of Jobs Per $Million]],MATCH(MyCountySelection,TblHealthPed[[County]:[County]],0))*INDEX(TblHealthPed[[Annual Expenditures ($2016) avoided per Person-Mile*]:[Annual Expenditures ($2016) avoided per Person-Mile*]],MATCH(MyCountySelection,TblHealthPed[[County]:[County]],0)),1))","v":0},{"$f":"IF($D$10=\"pedestrians only\",0,ROUND(E$27/1000000*INDEX(TblCountyHealth[[% Insufficiently active]:[% Insufficiently active]],MATCH(MyCountySelection,TblHealthCycl[[County]:[County]],0))*INDEX(TblHealthPed[['# of Jobs Per $Million]:['# of Jobs Per $Million]],MATCH(MyCountySelection,TblHealthPed[[County]:[County]],0))*INDEX(TblHealthPed[[Annual Expenditures ($2016) avoided per Person-Mile*]:[Annual Expenditures ($2016) avoided per Person-Mile*]],MATCH(MyCountySelection,TblHealthPed[[County]:[County]],0)),1))","v":0},{"$f":"IF($D$10=\"pedestrians only\",0,ROUND(F$27/1000000*INDEX(TblCountyHealth[[% Insufficiently active]:[% Insufficiently active]],MATCH(MyCountySelection,TblHealthCycl[[County]:[County]],0))*INDEX(TblHealthPed[['# of Jobs Per $Million]:['# of Jobs Per $Million]],MATCH(MyCountySelection,TblHealthPed[[County]:[County]],0))*INDEX(TblHealthPed[[Annual Expenditures ($2016) avoided per Person-Mile*]:[Annual Expenditures ($2016) avoided per Person-Mile*]],MATCH(MyCountySelection,TblHealthPed[[County]:[County]],0)),1))","v":0}]
[null,null,"Annual Reduced Absenteeism - Cyclist",{"$f":"IF($D$10=\"pedestrians only\",0,ROUND(D$22/1000000*INDEX(TblCountyHealth[[% Insufficiently active]:[% Insufficiently active]],MATCH(MyCountySelection,TblHealthCycl[[County]:[County]],0))*INDEX(TblProdCycl[['# of Jobs Per $Million]:['# of Jobs Per $Million]],MATCH(MyCountySelection,TblProdCycl[[County]:[County]],0))*INDEX(TblProdCycl[[Annual absentee days not taken per mile ridden]:[Annual absentee days not taken per mile ridden]],MATCH(MyCountySelection,TblProdCycl[[County]:[County]],0))*INDEX(TblProdCycl[[Output per Employee per day ($)]:[Output per Employee per day ($)]],MATCH(MyCountySelection,TblProdCycl[[County]:[County]],0)),1))","v":0},{"$f":"IF($D$10=\"pedestrians only\",0,ROUND(E$22/1000000*INDEX(TblCountyHealth[[% Insufficiently active]:[% Insufficiently active]],MATCH(MyCountySelection,TblHealthCycl[[County]:[County]],0))*INDEX(TblProdCycl[['# of Jobs Per $Million]:['# of Jobs Per $Million]],MATCH(MyCountySelection,TblProdCycl[[County]:[County]],0))*INDEX(TblProdCycl[[Annual absentee days not taken per mile ridden]:[Annual absentee days not taken per mile ridden]],MATCH(MyCountySelection,TblProdCycl[[County]:[County]],0))*INDEX(TblProdCycl[[Output per Employee per day ($)]:[Output per Employee per day ($)]],MATCH(MyCountySelection,TblProdCycl[[County]:[County]],0)),1))","v":0},{"$f":"IF($D$10=\"pedestrians only\",0,ROUND(F$22/1000000*INDEX(TblCountyHealth[[% Insufficiently active]:[% Insufficiently active]],MATCH(MyCountySelection,TblHealthCycl[[County]:[County]],0))*INDEX(TblProdCycl[['# of Jobs Per $Million]:['# of Jobs Per $Million]],MATCH(MyCountySelection,TblProdCycl[[County]:[County]],0))*INDEX(TblProdCycl[[Annual absentee days not taken per mile ridden]:[Annual absentee days not taken per mile ridden]],MATCH(MyCountySelection,TblProdCycl[[County]:[County]],0))*INDEX(TblProdCycl[[Output per Employee per day ($)]:[Output per Employee per day ($)]],MATCH(MyCountySelection,TblProdCycl[[County]:[County]],0)),1))","v":0}]
[null,null,"Annual Reduced Absenteeism - Pedestrians",{"$f":"IF($D$10=\"pedestrians only\",0,ROUND(D$27/1000000*INDEX(TblCountyHealth[[% Insufficiently active]:[% Insufficiently active]],MATCH(MyCountySelection,TblHealthCycl[[County]:[County]],0))*INDEX(TblProdPed[['# of Jobs Per $Million]:['# of Jobs Per $Million]],MATCH(MyCountySelection,TblProdPed[[County]:[County]],0))*INDEX(TblProdPed[[Annual absentee days not taken per mile walked]:[Annual absentee days not taken per mile walked]],MATCH(MyCountySelection,TblProdPed[[County]:[County]],0))*INDEX(TblProdPed[[Output per Employee per day ($)]:[Output per Employee per day ($)]],MATCH(MyCountySelection,TblProdPed[[County]:[County]],0)),1))","v":0},{"$f":"IF($D$10=\"pedestrians only\",0,ROUND(E$27/1000000*INDEX(TblCountyHealth[[% Insufficiently active]:[% Insufficiently active]],MATCH(MyCountySelection,TblHealthCycl[[County]:[County]],0))*INDEX(TblProdPed[['# of Jobs Per $Million]:['# of Jobs Per $Million]],MATCH(MyCountySelection,TblProdPed[[County]:[County]],0))*INDEX(TblProdPed[[Annual absentee days not taken per mile walked]:[Annual absentee days not taken per mile walked]],MATCH(MyCountySelection,TblProdPed[[County]:[County]],0))*INDEX(TblProdPed[[Output per Employee per day ($)]:[Output per Employee per day ($)]],MATCH(MyCountySelection,TblProdPed[[County]:[County]],0)),1))","v":0},{"$f":"IF($D$10=\"pedestrians only\",0,ROUND(F$27/1000000*INDEX(TblCountyHealth[[% Insufficiently active]:[% Insufficiently active]],MATCH(MyCountySelection,TblHealthCycl[[County]:[County]],0))*INDEX(TblProdPed[['# of Jobs Per $Million]:['# of Jobs Per $Million]],MATCH(MyCountySelection,TblProdPed[[County]:[County]],0))*INDEX(TblProdPed[[Annual absentee days not taken per mile walked]:[Annual absentee days not taken per mile walked]],MATCH(MyCountySelection,TblProdPed[[County]:[County]],0))*INDEX(TblProdPed[[Output per Employee per day ($)]:[Output per Employee per day ($)]],MATCH(MyCountySelection,TblProdPed[[County]:[County]],0)),1))","v":0}]
[]
[null,null,"Annual Labor Income"]
[null,null,"Total Annual Labor Income - sum of below",{"$f":"SUM(D62:D69)","v":0},{"$f":"SUM(E62:E69)","v":0},0]
[null,null,"Annual Facility Maintenance",{"$f":"ROUND($C$14*INDEX(TblFacMaint[[$ Income]:[$ Income]],MATCH(MyCountySelection,TblFacMaint[[County]:[County]],0))*INDEX(TblProjAdjDefaults[[Job and Income Adjustment Factor]:[Job and Income Adjustment Factor]],MATCH(ProjectSelect,TblProjAdjDefaults[[Project Types]:[Project Types]],0)),-2)","v":0},{"$f":"ROUND($C$14*INDEX(TblFacMaint[[$ Income]:[$ Income]],MATCH(MyCountySelection,TblFacMaint[[County]:[County]],0))*INDEX(TblProjAdjDefaults[[Job and Income Adjustment Factor]:[Job and Income Adjustment Factor]],MATCH(ProjectSelect,TblProjAdjDefaults[[Project Types]:[Project Types]],0)),-2)","v":0},{"$f":"ROUND($C$14*INDEX(TblFacMaint[[$ Income]:[$ Income]],MATCH(MyCountySelection,TblFacMaint[[County]:[County]],0))*INDEX(TblProjAdjDefaults[[Job and Income Adjustment Factor]:[Job and Income Adjustment Factor]],MATCH(ProjectSelect,TblProjAdjDefaults[[Project Types]:[Project Types]],0)),-2)","v":0}]
[null,null,"Equipment and Services",{"$f":"IF(UserGroup=\"Pedestrians Only\",0,ROUND($I$5*D$22*INDEX(TblEquipServ[[$ Income]:[$ Income]],MATCH(MyCountySelection,TblEquipServ[[County]:[County]],0)),-2))","v":0},{"$f":"IF(UserGroup=\"Pedestrians Only\",0,ROUND($I$5*E$22*INDEX(TblEquipServ[[$ Income]:[$ Income]],MATCH(MyCountySelection,TblEquipServ[[County]:[County]],0)),-2))","v":0},{"$f":"IF(UserGroup=\"Pedestrians Only\",0,ROUND($I$5*F$22*INDEX(TblEquipServ[[$ Income]:[$ Income]],MATCH(MyCountySelection,TblEquipServ[[County]:[County]],0)),-2))","v":0}]
[null,null,"Day Trips",{"$f":"ROUND($I$6*D$29*INDEX(TblDayTrips[[$ Income]:[$ Income]],MATCH(MyCountySelection,TblDayTrips[[County]:[County]],0)),-2)","v":0},{"$f":"ROUND($I$6*E$29*INDEX(TblDayTrips[[$ Income]:[$ Income]],MATCH(MyCountySelection,TblDayTrips[[County]:[County]],0)),-2)","v":0},{"$f":"ROUND($I$6*F$29*INDEX(TblDayTrips[[$ Income]:[$ Income]],MATCH(MyCountySelection,TblDayTrips[[County]:[County]],0)),-2)","v":0}]
[null,null,"Overnight trips",{"$f":"ROUND($I$7*D$30*INDEX(TblOvernights[[$ Income]:[$ Income]],MATCH(MyCountySelection,TblOvernights[[County]:[County]],0)),-2)","v":0},{"$f":"ROUND($I$7*E$30*INDEX(TblOvernights[[$ Income]:[$ Income]],MATCH(MyCountySelection,TblOvernights[[County]:[County]],0)),-2)","v":0},{"$f":"ROUND($I$7*F$30*INDEX(TblOvernights[[$ Income]:[$ Income]],MATCH(MyCountySelection,TblOvernights[[County]:[County]],0)),-2)","v":0}]
[null,null,"Annual Healthcare Savings - Cyclist",{"$f":"IF($D$10=\"pedestrians only\",0,ROUND(D$22*INDEX(TblCountyHealth[[% Insufficiently active]:[% Insufficiently active]],MATCH(MyCountySelection,TblHealthCycl[[County]:[County]],0))*INDEX(TblHealthCycl[[$ Income]:[$ Income]],MATCH(MyCountySelection,TblHealthCycl[[County]:[County]],0))*INDEX(TblHealthCycl[[Annual Expenditures ($2016) avoided per Rider-Mile]:[Annual Expenditures ($2016) avoided per Rider-Mile]],MATCH(MyCountySelection,TblHealthCycl[[County]:[County]],0)),-2))","v":0},{"$f":"IF($D$10=\"pedestrians only\",0,ROUND(E$22*INDEX(TblCountyHealth[[% Insufficiently active]:[% Insufficiently active]],MATCH(MyCountySelection,TblHealthCycl[[County]:[County]],0))*INDEX(TblHealthCycl[[$ Income]:[$ Income]],MATCH(MyCountySelection,TblHealthCycl[[County]:[County]],0))*INDEX(TblHealthCycl[[Annual Expenditures ($2016) avoided per Rider-Mile]:[Annual Expenditures ($2016) avoided per Rider-Mile]],MATCH(MyCountySelection,TblHealthCycl[[County]:[County]],0)),-2))","v":0},{"$f":"IF($D$10=\"pedestrians only\",0,ROUND(F$22*INDEX(TblCountyHealth[[% Insufficiently active]:[% Insufficiently active]],MATCH(MyCountySelection,TblHealthCycl[[County]:[County]],0))*INDEX(TblHealthCycl[[$ Income]:[$ Income]],MATCH(MyCountySelection,TblHealthCycl[[County]:[County]],0))*INDEX(TblHealthCycl[[Annual Expenditures ($2016) avoided per Rider-Mile]:[Annual Expenditures ($2016) avoided per Rider-Mile]],MATCH(MyCountySelection,TblHealthCycl[[County]:[County]],0)),-2))","v":0}]
[null,null,"Annual Healthcare Savings - Pedestrians",{"$f":"IF($D$10=\"cylcists only\",0,ROUND(D$27*INDEX(TblCountyHealth[[% Insufficiently active]:[% Insufficiently active]],MATCH(MyCountySelection,TblHealthCycl[[County]:[County]],0))*INDEX(TblHealthPed[[$ Income]:[$ Income]],MATCH(MyCountySelection,TblHealthPed[[County]:[County]],0))*INDEX(TblHealthPed[[Annual Expenditures ($2016) avoided per Person-Mile*]:[Annual Expenditures ($2016) avoided per Person-Mile*]],MATCH(MyCountySelection,TblHealthPed[[County]:[County]],0)),-2))","v":0},{"$f":"IF($D$10=\"cylcists only\",0,ROUND(E$27*INDEX(TblCountyHealth[[% Insufficiently active]:[% Insufficiently active]],MATCH(MyCountySelection,TblHealthCycl[[County]:[County]],0))*INDEX(TblHealthPed[[$ Income]:[$ Income]],MATCH(MyCountySelection,TblHealthPed[[County]:[County]],0))*INDEX(TblHealthPed[[Annual Expenditures ($2016) avoided per Person-Mile*]:[Annual Expenditures ($2016) avoided per Person-Mile*]],MATCH(MyCountySelection,TblHealthPed[[County]:[County]],0)),-2))","v":0},{"$f":"IF($D$10=\"cylcists only\",0,ROUND(F$27*INDEX(TblCountyHealth[[% Insufficiently active]:[% Insufficiently active]],MATCH(MyCountySelection,TblHealthCycl[[County]:[County]],0))*INDEX(TblHealthPed[[$ Income]:[$ Income]],MATCH(MyCountySelection,TblHealthPed[[County]:[County]],0))*INDEX(TblHealthPed[[Annual Expenditures ($2016) avoided per Person-Mile*]:[Annual Expenditures ($2016) avoided per Person-Mile*]],MATCH(MyCountySelection,TblHealthPed[[County]:[County]],0)),-2))","v":0}]
[null,null,"Annual Reduced Absenteeism - Cyclist",{"$f":"IF($D$10=\"Pedestrians Only\",0,ROUND(D$22*INDEX(TblCountyHealth[[% Insufficiently active]:[% Insufficiently active]],MATCH(MyCountySelection,TblProdCycl[[County]:[County]],0))*INDEX(TblProdCycl[[$ Income]:[$ Income]],MATCH(MyCountySelection,TblProdCycl[[County]:[County]],0))*INDEX(TblProdCycl[[Annual absentee days not taken per mile ridden]:[Annual absentee days not taken per mile ridden]],MATCH(MyCountySelection,TblProdCycl[[County]:[County]],0))*INDEX(TblProdCycl[[Output per Employee per day ($)]:[Output per Employee per day ($)]],MATCH(MyCountySelection,TblProdCycl[[County]:[County]],0)),-2))","v":0},{"$f":"IF($D$10=\"Pedestrians Only\",0,ROUND(E$22*INDEX(TblCountyHealth[[% Insufficiently active]:[% Insufficiently active]],MATCH(MyCountySelection,TblProdCycl[[County]:[County]],0))*INDEX(TblProdCycl[[$ Income]:[$ Income]],MATCH(MyCountySelection,TblProdCycl[[County]:[County]],0))*INDEX(TblProdCycl[[Annual absentee days not taken per mile ridden]:[Annual absentee days not taken per mile ridden]],MATCH(MyCountySelection,TblProdCycl[[County]:[County]],0))*INDEX(TblProdCycl[[Output per Employee per day ($)]:[Output per Employee per day ($)]],MATCH(MyCountySelection,TblProdCycl[[County]:[County]],0)),-2))","v":0},{"$f":"IF($D$10=\"Pedestrians Only\",0,ROUND(F$22*INDEX(TblCountyHealth[[% Insufficiently active]:[% Insufficiently active]],MATCH(MyCountySelection,TblProdCycl[[County]:[County]],0))*INDEX(TblProdCycl[[$ Income]:[$ Income]],MATCH(MyCountySelection,TblProdCycl[[County]:[County]],0))*INDEX(TblProdCycl[[Annual absentee days not taken per mile ridden]:[Annual absentee days not taken per mile ridden]],MATCH(MyCountySelection,TblProdCycl[[County]:[County]],0))*INDEX(TblProdCycl[[Output per Employee per day ($)]:[Output per Employee per day ($)]],MATCH(MyCountySelection,TblProdCycl[[County]:[County]],0)),-2))","v":0}]
[null,null,"Annual Reduced Absenteeism - Pedestrians",{"$f":"IF($D$10=\"Pedestrians Only\",0,ROUND(D$27*INDEX(TblCountyHealth[[% Insufficiently active]:[% Insufficiently active]],MATCH(MyCountySelection,TblProdPed[[County]:[County]],0))*INDEX(TblProdPed[[$ Income]:[$ Income]],MATCH(MyCountySelection,TblProdPed[[County]:[County]],0))*INDEX(TblProdPed[[Annual absentee days not taken per mile walked]:[Annual absentee days not taken per mile walked]],MATCH(MyCountySelection,TblProdPed[[County]:[County]],0))*INDEX(TblProdPed[[Output per Employee per day ($)]:[Output per Employee per day ($)]],MATCH(MyCountySelection,TblProdPed[[County]:[County]],0)),-2))","v":0},{"$f":"IF($D$10=\"Pedestrians Only\",0,ROUND(E$27*INDEX(TblCountyHealth[[% Insufficiently active]:[% Insufficiently active]],MATCH(MyCountySelection,TblProdPed[[County]:[County]],0))*INDEX(TblProdPed[[$ Income]:[$ Income]],MATCH(MyCountySelection,TblProdPed[[County]:[County]],0))*INDEX(TblProdPed[[Annual absentee days not taken per mile walked]:[Annual absentee days not taken per mile walked]],MATCH(MyCountySelection,TblProdPed[[County]:[County]],0))*INDEX(TblProdPed[[Output per Employee per day ($)]:[Output per Employee per day ($)]],MATCH(MyCountySelection,TblProdPed[[County]:[County]],0)),-2))","v":0},{"$f":"IF($D$10=\"Pedestrians Only\",0,ROUND(F$27*INDEX(TblCountyHealth[[% Insufficiently active]:[% Insufficiently active]],MATCH(MyCountySelection,TblProdPed[[County]:[County]],0))*INDEX(TblProdPed[[$ Income]:[$ Income]],MATCH(MyCountySelection,TblProdPed[[County]:[County]],0))*INDEX(TblProdPed[[Annual absentee days not taken per mile walked]:[Annual absentee days not taken per mile walked]],MATCH(MyCountySelection,TblProdPed[[County]:[County]],0))*INDEX(TblProdPed[[Output per Employee per day ($)]:[Output per Employee per day ($)]],MATCH(MyCountySelection,TblProdPed[[County]:[County]],0)),-2))","v":0}]

{"sheet":"ProjAdjust&Defaults","index":2,"n_rows":21,"n_cols":14,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["Source, Job and Income Factor only: ","Economic Impacts of Active Transportation: Utah Active Transportation Benefits Study, Table 8.  See UATBS_Final_Report_20170428.pdf"]
["Default typical calculation (annual user-miles)","=trip length x number of users x days per year"]
["Default typical calculation (visitor/event trips)","=(people per group x groups per instance x average days per trip x  times per year) + (number of events per year x participants per event x day/overnight trip factor)"]
[]
["Project Types","Job and Income Adjustment Factor","Default Low Cyclist Rider-miles","Default Estimated Cyclist Rider-miles","Default High Cyclist Rider-miles","Default Low Pedestrian person-miles","Default Estimated Pedestrian person-miles","Default High Pedestrian person-miles","Default Low Day trips","Default Estimated Day trips","Default High Day trips","Default Low Overnight trips","Default Estimated Overnight trips","Default High Overnight trips"]
["Base - road infrastructure with no bike/ped facilities",1,0,0,0,0,0,0,0,0,0,0,0,0]
["Bicycle infrastructure only",1.47,{"$f":"MaxUserMiles*10*100","v":0},{"$f":"MaxUserMiles*15*150","v":0},{"$f":"MaxUserMiles*20*250","v":0},0,0,0,{"$f":"(2*2*1*10)+(0*0*PercDayTrips)","v":40},{"$f":"(2*10*1*20)+(0*100*PercDayTrips)","v":400},{"$f":"(4*10*1*30)+(1*300*PercDayTrips)","v":1284},{"$f":"(2*2*1*0)+(0*0*(1-PercDayTrips))","v":0},{"$f":"(2*4*2*10)+(0*300*(1-PercDayTrips))","v":160},{"$f":"(4*10*2*20)+(1*300*(1-PercDayTrips))","v":1816}]
["Off-street multi-use trails ",1.23,{"$f":"MaxUserMiles*10*100","v":0},{"$f":"MaxUserMiles*20*150","v":0},{"$f":"MaxUserMiles*25*300","v":0},{"$f":"1*10*100","v":1000},{"$f":"3*10*150","v":4500},{"$f":"5*20*250","v":25000},{"$f":"(2*2*1*20)+(0*0*PercDayTrips)","v":80},{"$f":"(2*10*1*30)+(1*300*PercDayTrips)","v":684},{"$f":"(4*10*1*30)+(2*500*PercDayTrips)","v":1480},0,{"$f":"(4*4*2*10)+(1*300*(1-PercDayTrips))","v":536},{"$f":"(4*20*2*20)+(2*500*(1-PercDayTrips))","v":3920}]
["On-street bicycle and pedestrian facilities (no road construction)",1.0900000000000001,{"$f":"MaxUserMiles*10*100","v":0},{"$f":"MaxUserMiles*15*150","v":0},{"$f":"MaxUserMiles*20*250","v":0},{"$f":"1*5*100","v":500},{"$f":"3*10*100","v":3000},{"$f":"5*20*150","v":15000},{"$f":"(2*2*1*10)+(0*0*PercDayTrips)","v":40},{"$f":"(2*10*1*20)+(0*100*PercDayTrips)","v":400},{"$f":"(4*10*1*30)+(1*300*PercDayTrips)","v":1284},0,{"$f":"(2*4*2*10)+(0*300*(1-PercDayTrips))","v":160},{"$f":"(4*10*2*20)+(1*300*(1-PercDayTrips))","v":1816}]
["Pedestrian infrastructure only",1.28,0,0,0,{"$f":"1*5*100","v":500},{"$f":"3*10*100","v":3000},{"$f":"5*20*150","v":15000},{"$f":"(2*2*1*0)+(0*0*PercDayTrips)","v":0},{"$f":"(2*2*1*20)+(0*0*PercDayTrips)","v":80},{"$f":"(2*2*1*50)+(1*300*PercDayTrips)","v":284},0,{"$f":"(0*2*1*20)+(0*0*(1-PercDayTrips))","v":0},{"$f":"(0*2*1*20)+(1*300*(1-PercDayTrips))","v":216}]
["Road infrastructure with bicycle and pedestrian facilities",1.1000000000000001,{"$f":"MaxUserMiles*10*100","v":0},{"$f":"MaxUserMiles*15*150","v":0},{"$f":"MaxUserMiles*20*250","v":0},500,3000,15000,{"$f":"(2*2*1*10)+(0*0*PercDayTrips)","v":40},{"$f":"(2*10*1*20)+(0*100*PercDayTrips)","v":400},{"$f":"(4*10*1*30)+(1*300*PercDayTrips)","v":1284},0,{"$f":"(2*4*2*10)+(0*300*(1-PercDayTrips))","v":160},{"$f":"(4*10*2*20)+(1*300*(1-PercDayTrips))","v":1816}]
["Road infrastructure with pedestrian facilities",1.0900000000000001,0,0,0,500,3000,15000,{"$f":"(2*2*1*0)+(0*0*PercDayTrips)","v":0},{"$f":"(2*2*1*20)+(0*0*PercDayTrips)","v":80},{"$f":"(2*2*1*50)+(1*300*PercDayTrips)","v":284},0,{"$f":"(0*2*1*20)+(0*0*(1-PercDayTrips))","v":0},{"$f":"(0*2*1*20)+(1*300*(1-PercDayTrips))","v":216}]
[]
["Notes on Defaults"]
["Bicycle infrastructure only, On-street bicycle and pedestrian facilities (no road construction), and Road infrastructure with bicycle and pedestrian facilities are considered the same for Bicycle user-miles and Trips"]
["On-street bicycle and pedestrian facilities (no road construction) and Road infrastructure with bicycle and pedestrian facilities are considered the same for Pedestrian user-miles and trips"]
["Pedestrian infrastructure only and Road infrastructure with pedestrian facilities are considered the same for Pedestrian user-miles and trips"]
["100 days implies 2 days per week, 150 days implies 3 days per week, 250 days implies commuting 5 days per week"]
["Trip length for pedestrian are hard-coded as 1, 3, and 5 miles based on realistic distances that people walk as opposed to project lengths."]
["Cyclist are assumed to travel the entire length of the connected network. NOTE: This may not be a realistic assumption if that mileage is more than 25 miles."]
["Events are assumed to have the same number of participants (within project type and estimate level) in order to calculate a split between day trips and overnight trips"]

{"sheet":"Counties","index":3,"n_rows":30,"n_cols":2,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Beaver"]
[null,"Box Elder"]
[null,"Cache"]
[null,"Carbon"]
[null,"Daggett"]
[null,"Davis"]
[null,"Duchesne"]
[null,"Emery"]
[null,"Garfield"]
[null,"Grand"]
[null,"Iron"]
[null,"Juab"]
[null,"Kane"]
[null,"Millard"]
[null,"Morgan"]
[null,"Piute"]
[null,"Rich"]
[null,"Salt Lake"]
[null,"San Juan"]
[null,"Sanpete"]
[null,"Sevier"]
[null,"Summit"]
[null,"Tooele"]
[null,"Uintah"]
[null,"Utah"]
[null,"Wasatch"]
[null,"Washington"]
[null,"Wayne"]
[null,"Weber"]

{"sheet":"CapConstr","index":4,"n_rows":35,"n_cols":4,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
["Source:","Economic Impacts of Active Transportation: Utah Active Transportation Benefits Study.  See UATBS_Final_Report_20170428.pdf"]
["Table 25"]
[]
["Total Multipliers per $ of Capital Construction Spending"]
[]
["County","$ Total Output ","# of Jobs Per $Million","$ Income"]
["Beaver",1.2116407373561198,8.1170335139840137,0.3066412753539699]
["Box Elder",1.2952966457041795,8.74903969888096,0.34014011717062004]
["Cache",1.4519260465727464,10.331352149069064,0.36731427896779378]
["Carbon",1.3953244316071813,8.6147518320199499,0.41836852116178369]
["Daggett",1.2007691329454886,5.4976047770552823,0.55295876209072437]
["Davis",1.4579725877251433,8.8608059110314681,0.44588718554138163]
["Duchesne",1.4359606188479614,8.8368255372820279,0.41197088593494802]
["Emery",1.2132846029673856,7.550571502223888,0.32552059539155948]
["Garfield",1.3171103051809214,10.250176457994966,0.23196682384566747]
["Grand",1.3634866865257222,9.464621926202522,0.36324632452610128]
["Iron",1.3852754146502944,10.495323702156538,0.31877242233655578]
["Juab",1.2188242405496745,8.2090355540829254,0.31293297945303183]
["Kane",1.2573314578893648,10.388895451029466,0.1781959848357918]
["Millard",1.3257997053484001,9.817313543500493,0.30213589096946475]
["Morgan",1.3330129186448394,8.5140829481316924,0.40945534382438181]
["Piute",1.1251171898677716,9.8672114177259154,0.11568040081206049]
["Rich",1.2952086255297832,9.441210270740287,0.29801140475833615]
["Salt lake",1.7835537483352906,10.137711475519133,0.57407091308155278]
["San Juan",1.2554756312296278,8.4413708972218444,0.30298657837090309]
["Sanpete",1.3425205942617817,10.136005081267644,0.29316247990625299]
["Sevier",1.4961038056409632,10.680132248949491,0.32911575552875416]
["Summit",1.4067745835354981,8.3470389495441086,0.45764383067525954]
["Tooele",1.2723473891635182,8.3071670985339505,0.33346451012130973]
["Uintah",1.4525006832357112,8.965339857040755,0.4147538412334435]
["Utah",1.4899387710008969,9.5860003883341491,0.44953246614232945]
["Wasatch",1.3077959366057859,8.3580096707448348,0.37030982769087406]
["Washington",1.6201565175187995,11.357925204065666,0.4109902151035974]
["Wayne",1.1921358946576595,8.7230290243425195,0.25831210978145414]
["Weber",1.4062970308381566,9.269735601781095,0.41410418302067792]

{"sheet":"FacMaint","index":5,"n_rows":35,"n_cols":4,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
["Source:","Economic Impacts of Active Transportation: Utah Active Transportation Benefits Study.  See UATBS_Final_Report_20170428.pdf"]
["Table 26"]
[]
["Total Multipliers per $ of Annual Facility Maintenance Spending"]
[]
["County","$ Total Output ","# of Jobs Per $Million","$ Income"]
["Beaver",1.2284998731924497,10.244379242873183,0.35075343464277586]
["Box Elder",1.3118231238758828,11.193333802322758,0.373891680172659]
["Cache",1.4817864178210278,13.226203867818816,0.42304574519670296]
["Carbon",1.4038570040869254,10.605548972980458,0.44965667950340393]
["Daggett",1.1757316541090093,5.7394120366130865,0.61579187921482981]
["Davis",1.5814522155499291,11.360662423206891,0.52979379056072784]
["Duchesne",1.4114582754718679,10.645007830510067,0.45487960652935305]
["Emery",1.2535885761274959,9.6441744321944913,0.36004975956963153]
["Garfield",1.2909449691761559,12.990698536729001,0.25425136605249249]
["Grand",1.4167536161189762,12.149314564035235,0.41802550358676138]
["Iron",1.4348744649545266,13.557185760356619,0.3657880237657628]
["Juab",1.3181624386979609,11.029578902141326,0.37128488662399239]
["Kane",1.315103454283876,14.188247085247683,0.20134170180849137]
["Millard",1.4414606849687925,13.530662166563483,0.37009230477008365]
["Morgan",1.3515950733092923,10.358893156227811,0.4688140177473285]
["Piute",1.0934110063156606,12.510473077054753,0.11828895322241789]
["Rich",1.365669786231507,12.89241338844427,0.35278317271892451]
["Salt lake",1.8546516611927018,12.444490795989671,0.64398197057136408]
["San Juan",1.267496968254813,10.556125880184153,0.33751231364061457]
["Sanpete",1.4163836303493293,13.741930794218819,0.33852484168529884]
["Sevier",1.5491205325445019,13.998354022928755,0.39074434262051971]
["Summit",1.4266264251676961,10.416855091921226,0.52049511217377042]
["Tooele",1.381560960232769,11.297715183270734,0.40165871329007652]
["Uintah",1.4538147960534888,11.082587212396914,0.4561635949971089]
["Utah",1.5514723328803548,12.121209788072218,0.50995344287277611]
["Wasatch",1.3620118140969604,10.651451995240755,0.41642231006928127]
["Washington",1.5893406298971819,13.813167918156967,0.45395021743523856]
["Wayne",1.2877910437662803,12.168789570784353,0.28762268122875778]
["Weber",1.5082520696385084,12.105913048224741,0.49235963630958546]

{"sheet":"EquipServ","index":6,"n_rows":36,"n_cols":4,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
["Source:","Economic Impacts of Active Transportation: Utah Active Transportation Benefits Study.  See UATBS_Final_Report_20170428.pdf"]
["Table 27"]
[]
["Note that Multipliers are only provided for Counties in which there was sales data from InfoUSA"]
["Total Multipliers per $ of Equipment and Service Spending"]
[]
["County","$ Total Output ","# of Jobs Per $Million","$ Income"]
["Beaver",0,0,0]
["Box Elder",1.5485619495284251,13.494777162019444,0.27400568201197956]
["Cache",1.8066777305959678,14.085928030662007,0.33363681464346046]
["Carbon",1.7575976962316422,13.221836576036473,0.3308560551872976]
["Daggett",0,0,0]
["Davis",1.9190648440416558,14.36732870334766,0.39497240648291343]
["Duchesne",0,0,0]
["Emery",0,0,0]
["Garfield",0,0,0]
["Grand",1.7589443688379565,12.649627364556641,0.30685029196399721]
["Iron",1.9205273780028171,17.253561988755699,0.31013933394608773]
["Juab",0,0,0]
["Kane",0,0,0]
["Millard",0,0,0]
["Morgan",1.7795467787925165,19.313421477230108,0.20214395525699344]
["Piute",0,0,0]
["Rich",2.2074717577421721,12.916442293990926,0.55757947067744862]
["Salt Lake",0,0,0]
["San Juan",0,0,0]
["Sanpete",0,0,0]
["Sevier",0,0,0]
["Summit",1.7866776556124118,10.437982917924238,0.38927332747045407]
["Tooele",0,0,0]
["Uintah",1.6719040304541726,12.186834697758249,0.30003372545460993]
["Utah",2.0658452931562126,14.984663320875562,0.42517123602288254]
["Wasatch",1.8725952213338792,14.303227514314237,0.32036955498743436]
["Washington",2.1123394197236371,16.966835514684952,0.40010891345513139]
["Wayne",0,0,0]
["Weber",1.8417141269183797,14.402574528916857,0.36942850697829221]

{"sheet":"DayTrips","index":7,"n_rows":35,"n_cols":4,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
["Source:","Economic Impacts of Active Transportation: Utah Active Transportation Benefits Study.  See UATBS_Final_Report_20170428.pdf"]
["Table 28"]
[]
["Total Multipliers per $ of Direct Spending - Day Trips"]
[]
["County","$ Total Output ","# of Jobs Per $Million","$ Income"]
["Beaver",0.6650790995081004,11.783415911494622,0.27401437343140189]
["Box Elder",0.73380024452422499,12.015321250178399,0.32308574048458527]
["Cache",1.6860793451367793,19.651100743738454,0.51074984072836205]
["Carbon",0.82574606858169608,10.832153859583265,0.38766818999025393]
["Daggett",0.65460022939420837,14.035547123554728,0.23374901323194142]
["Davis",1.5967580333970832,17.978250279074729,0.56294412729444421]
["Duchesne",1.3819163775656871,18.495597241009008,0.39223394944689549]
["Emery",0.71240345414823336,12.050327983054766,0.28706272111331876]
["Garfield",0.75073084162742698,14.045772281204639,0.25425174522882599]
["Grand",1.5805640602036342,19.112683730841873,0.45872462750592108]
["Iron",1.6029202777775544,20.158566541839427,0.46962031095352763]
["Juab",0.70289617082362121,13.968833136310437,0.2357854804794666]
["Kane",1.4434354228447566,17.982049132212495,0.41227251304569074]
["Millard",0.73144092159944951,12.59844099084134,0.29482841481879762]
["Morgan",1.4111100544814206,19.878116708779995,0.34482129464111866]
["Piute",0.62993861517784255,12.879237545009605,0.23320840476527738]
["Rich",0.74466833112654107,13.588917790865946,0.2626040684674848]
["Salt lake",2.0563967509362033,19.085820382431727,0.74938800369475467]
["San Juan",1.3321127727848503,18.131131414889779,0.36098805893004349]
["Sanpete",0.75287838441478816,13.098683866413596,0.29573771284366501]
["Sevier",0.7707191910418949,12.780854755759625,0.32056794383629422]
["Summit",1.6182062088834592,15.896680688069267,0.60529409015534807]
["Tooele",1.3812444240402117,15.889025960771797,0.50909752823005605]
["Uintah",1.4524883703950027,17.520633120734999,0.46593422665506434]
["Utah",1.8366663559827954,19.345870386587301,0.61827728744556021]
["Wasatch",1.6086751454232919,20.052397770522337,0.43739298210038935]
["Washington",1.8084426120033572,21.313400255780142,0.53499624540338897]
["Wayne",0.65879242927709503,13.287965978543756,0.23558201108144308]
["Weber",1.5960511498080683,18.756634826139969,0.54706964313659556]

{"sheet":"Overnights","index":8,"n_rows":35,"n_cols":4,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
["Source:","Economic Impacts of Active Transportation: Utah Active Transportation Benefits Study.  See UATBS_Final_Report_20170428.pdf"]
["Table 29"]
[]
["Total Multipliers per $ of Direct Spending - Overnight Trips"]
[]
["County","$ Total Output ","# of Jobs Per $Million","$ Income"]
["Beaver",1.0854504634540412,19.215339727167418,0.42411563510482431]
["Box Elder",1.1877424965586949,20.077503833036644,0.48773618187410628]
["Cache",1.6119970441171445,22.976773735206439,0.59162937335573962]
["Carbon",1.1627265682005146,15.260111785666005,0.50133748421054125]
["Daggett",1.0673765135506832,22.09685374203929,0.37877685866146005]
["Davis",1.5878341813279486,23.591426816629841,0.58015877971079066]
["Duchesne",1.3885833959606684,22.326539614751979,0.49328377246291072]
["Emery",1.1696583982946784,19.146610551613051,0.45776478037483115]
["Garfield",1.2228307993461449,21.862821171729635,0.41978812026824658]
["Grand",1.5519272239566113,21.798157041788794,0.57531420047856174]
["Iron",1.5895948028023401,24.642118364656206,0.53701553442123096]
["Juab",1.1522086256427877,22.399905021681736,0.37583556598228296]
["Kane",1.4285311599494745,20.886629025494571,0.53199627287898077]
["Millard",1.2001292832517971,20.257560968283912,0.46281094081904484]
["Morgan",1.2182576909249834,20.047779191800114,0.38869864347487482]
["Piute",1.0273839885145732,20.283251230848691,0.37342213591652162]
["Rich",1.1964017537601062,21.870396559826357,0.41020983760907548]
["Salt lake",1.9549726483554988,22.399853355735129,0.79266208368467217]
["San Juan",1.3081058139697295,22.777493750797429,0.43252409927401358]
["Sanpete",1.2312181258751917,21.046561603072092,0.46500982083287823]
["Sevier",1.2581429583749246,20.708319276712718,0.50026149005889586]
["Summit",1.5330896457809891,18.452571354148862,0.66841380120817839]
["Tooele",1.2205303518127495,17.631700380779101,0.47093091918201796]
["Uintah",1.4802586300347997,22.162063394884779,0.53831815966140406]
["Utah",1.7384017287697613,21.843917769316079,0.68599587538068396]
["Wasatch",1.546884982267769,22.731583301271836,0.53656843123931253]
["Washington",1.7616043957555341,24.856475231764051,0.61575490704394731]
["Wayne",1.0860529909355519,20.808187783258624,0.38824476218897475]
["Weber",1.5851320905958384,23.078075576025139,0.60346348235146063]

{"sheet":"CountyHealth","index":9,"n_rows":33,"n_cols":5,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
["Source:","Economic Impacts of Active Transportation: Utah Active Transportation Benefits Study.  See UATBS_Final_Report_20170428.pdf"]
["* Table 14"]
[]
[null,"Utah Health District","County","% of 18+ yo adults getting Recommended Aerobic Activity*","% Insufficiently active"]
[null,"Southeast","Beaver",0.69299999999999995,{"$f":"1-D5","v":0.30700000000000005}]
[null,"Bear River","Box Elder",0.54800000000000004,{"$f":"1-D6","v":0.45199999999999996}]
[null,"Bear River","Cache",0.54800000000000004,0.45199999999999996]
[null,"Use State","Carbon",0.55600000000000005,0.44399999999999995]
[null,"TriCounty","Daggett",0.51500000000000001,0.48499999999999999]
[null,"Davis County","Davis",0.57599999999999996,0.42400000000000004]
[null,"TriCounty","Duchesne",0.51500000000000001,0.48499999999999999]
[null,"Use State","Emery",0.55600000000000005,0.44399999999999995]
[null,"Southeast","Garfield",0.69299999999999995,0.30700000000000005]
[null,"Use State","Grand",0.55600000000000005,0.44399999999999995]
[null,"Southeast","Iron",0.69299999999999995,0.30700000000000005]
[null,"Use State","Juab",0.55600000000000005,0.44399999999999995]
[null,"Southeast","Kane",0.69299999999999995,0.30700000000000005]
[null,"Central","Millard",0.49399999999999999,0.50600000000000001]
[null,"Weber-Morgan","Morgan",0.53600000000000003,0.46399999999999997]
[null,"Central","Piute",0.49399999999999999,0.50600000000000001]
[null,"Bear Rive","Rich",0.54800000000000004,0.45199999999999996]
[null,"Salt Lake County","Salt lake",0.55300000000000005,0.44699999999999995]
[null,"San Juan","San Juan",0.68400000000000005,0.31599999999999995]
[null,"Central","Sanpete",0.49399999999999999,0.50600000000000001]
[null,"Central","Sevier",0.49399999999999999,0.50600000000000001]
[null,"Summit","Summit",0.69899999999999995,0.30100000000000005]
[null,"Tooele","Tooele",0.46,0.54]
[null,"TriCounty","Uintah",0.51500000000000001,0.48499999999999999]
[null,"Utah County","Utah",0.58199999999999996,0.41800000000000004]
[null,"Wasatch County","Wasatch",0.56200000000000006,0.43799999999999994]
[null,"Southeast","Washington",0.69299999999999995,0.30700000000000005]
[null,"Central","Wayne",0.49399999999999999,0.50600000000000001]
[null,"Weber-Morgan","Weber",0.53600000000000003,0.46399999999999997]

{"sheet":"HealthCycl","index":10,"n_rows":35,"n_cols":5,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
["Source:","Economic Impacts of Active Transportation: Utah Active Transportation Benefits Study.  See UATBS_Final_Report_20170428.pdf"]
["Table 30"]
[]
["Total Multipliers per $ reduction in Healthcare Spending - Cyclists"]
[null,null,null,null,"* Table 14 in Final Report"]
["County","$ Total Output ","# of Jobs Per $Million","$ Income","Annual Expenditures ($2016) avoided per Rider-Mile"]
["Beaver",0.82976516786427013,2.2105459289416278,0.58005982462545413,0.73399999999999999]
["Box Elder",0.90747684273219398,2.1551891169744559,0.58605413282253316,0.748]
["Cache",1.035427831855865,2.5715351472299992,0.62605642963905739,0.748]
["Carbon",0.96269943346822007,2.0179753665358859,0.60850940664264996,0.749]
["Daggett",0.83892393461925707,2.9483225729591633,0.59634045528605339,0.73799999999999999]
["Davis",0.99911278588696417,2.5993283086919847,0.63587247173531325,0.749]
["Duchesne",0.92375993848436,2.7569118132369019,0.62335935450729618,0.73799999999999999]
["Emery",0.87384468507966939,1.555815517078919,0.55590428883580045,0.749]
["Garfield",0.928307349507833,3.2128837909673247,0.58927399418860782,0.73399999999999999]
["Grand",0.99055314804817352,3.1447554987218274,0.63097826588146189,0.749]
["Iron",1.0303777760329791,3.210883025839856,0.62891558237171463,0.73399999999999999]
["Juab",0.88174676057060442,2.2350437979801967,0.57669084097088963,0.747]
["Kane",0.92351494620096042,2.9080909392784617,0.59729469090203191,0.73399999999999999]
["Millard",0.88140617699205692,1.6347202969788606,0.56709401671683135,0.747]
["Morgan",0.89282746071598251,2.8641644405711695,0.57773431260445485,0.747]
["Piute",0.83514351272841736,3.508295768205647,0.54712080707060429,0.747]
["Rich",0.91433955933879352,2.9869867967429742,0.58085003960785231,0.748]
["Salt lake",1.2047303646823957,2.8222502220153785,0.72667508313478046,0.751]
["San Juan",0.88007234279140523,2.7401431089624051,0.58910860334395043,0.749]
["Sanpete",0.94592299476352626,3.0808348990842114,0.60362285885270894,0.747]
["Sevier",0.96248049574250316,2.6324300302769981,0.61038253026861633,0.747]
["Summit",0.98196426861936059,2.7021938074665552,0.64170140429481692,0.73399999999999999]
["Tooele",0.88411829086007943,2.0470918896886841,0.57994010166308052,0.747]
["Uintah",0.97525963880660971,2.6041261760601353,0.63028954850951391,0.73799999999999999]
["Utah",1.1015982568731841,2.953197861516065,0.67541453011979424,0.753]
["Wasatch",0.96608128367313784,3.0702848681056234,0.60978759358552581,0.748]
["Washington",1.1176906144052867,3.5509559818655454,0.66145878496219113,0.73399999999999999]
["Wayne",0.86158579157561144,3.1024460514553911,0.56539223493411939,0.747]
["Weber",1.0292498478393113,2.5780254110069256,0.65070389408650431,0.747]

{"sheet":"HealthPed","index":11,"n_rows":35,"n_cols":5,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
["Source:","Economic Impacts of Active Transportation: Utah Active Transportation Benefits Study.  See UATBS_Final_Report_20170428.pdf"]
["Table 31"]
[]
["Total Multipliers per $ reduction in Healthcare Spending - Pedestrians"]
[null,null,null,null,"* Table 14 in Final Report"]
["County","$ Total Output ","# of Jobs Per $Million","$ Income","Annual Expenditures ($2016) avoided per Person-Mile*"]
["Beaver",0.82976516786427013,2.2105459289416278,0.58005982462545413,3.04]
["Box Elder",0.90747684273219398,2.1551891169744559,0.58605413282253316,2.99]
["Cache",1.035427831855865,2.5715351472299992,0.62605642963905739,2.99]
["Carbon",0.96269943346822007,2.0179753665358859,0.60850940664264996,3.07]
["Daggett",0.83892393461925707,2.9483225729591633,0.59634045528605339,3.05]
["Davis",0.99911278588696417,2.5993283086919847,0.63587247173531325,3]
["Duchesne",0.92375993848436,2.7569118132369019,0.62335935450729618,3.05]
["Emery",0.87384468507966939,1.555815517078919,0.55590428883580045,3.07]
["Garfield",0.928307349507833,3.2128837909673247,0.58927399418860782,3.04]
["Grand",0.99055314804817352,3.1447554987218274,0.63097826588146189,3.07]
["Iron",1.0303777760329791,3.210883025839856,0.62891558237171463,3.04]
["Juab",0.88174676057060442,2.2350437979801967,0.57669084097088963,2.99]
["Kane",0.92351494620096042,2.9080909392784617,0.59729469090203191,3.04]
["Millard",0.88140617699205692,1.6347202969788606,0.56709401671683135,2.99]
["Morgan",0.89282746071598251,2.8641644405711695,0.57773431260445485,3.07]
["Piute",0.83514351272841736,3.508295768205647,0.54712080707060429,2.99]
["Rich",0.91433955933879352,2.9869867967429742,0.58085003960785231,2.99]
["Salt lake",1.2047303646823957,2.8222502220153785,0.72667508313478046,3.01]
["San Juan",0.88007234279140523,2.7401431089624051,0.58910860334395043,3.07]
["Sanpete",0.94592299476352626,3.0808348990842114,0.60362285885270894,2.99]
["Sevier",0.96248049574250316,2.6324300302769981,0.61038253026861633,2.99]
["Summit",0.98196426861936059,2.7021938074665552,0.64170140429481692,3.04]
["Tooele",0.88411829086007943,2.0470918896886841,0.57994010166308052,3.07]
["Uintah",0.97525963880660971,2.6041261760601353,0.63028954850951391,3.05]
["Utah",1.1015982568731841,2.953197861516065,0.67541453011979424,3.08]
["Wasatch",0.96608128367313784,3.0702848681056234,0.60978759358552581,3.07]
["Washington",1.1176906144052867,3.5509559818655454,0.66145878496219113,3.04]
["Wayne",0.86158579157561144,3.1024460514553911,0.56539223493411939,2.99]
["Weber",1.0292498478393113,2.5780254110069256,0.65070389408650431,3.07]

{"sheet":"ProdCycl","index":12,"n_rows":35,"n_cols":6,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
["Source:","Economic Impacts of Active Transportation: Utah Active Transportation Benefits Study.  See UATBS_Final_Report_20170428.pdf"]
["Table 32"]
[]
["Total Multipliers per $ increase in Production Output - Cyclists"]
[]
["County","$ Total Output ","# of Jobs Per $Million","$ Income","Annual absentee days not taken per mile ridden","Output per Employee per day ($)"]
["Beaver",1.2108236564965242,8.1930724235315608,0.34843487916882943,5.9029999999999998E-4,617.40494768733868]
["Box Elder",1.2503663939628289,7.9294646998783618,0.27440348963111028,5.5060000000000005E-4,726.56600697907948]
["Cache",1.4550125326469763,9.9120612725238058,0.34183776018598755,5.5060000000000005E-4,659.06441766801265]
["Carbon",1.3433253974677148,7.2760656025518378,0.31264907925071417,6.1280000000000004E-4,829.36510613122869]
["Daggett",1.2163611172345579,11.706294680757921,0.40545312040977777,5.9630000000000002E-4,396.83008247655778]
["Davis",1.4315937423188769,10.044411946152307,0.41780653207291985,5.4239999999999996E-4,622.77625212687838]
["Duchesne",1.378153516592191,10.794812015413818,0.45898597384426781,5.9630000000000002E-4,519.49857932545081]
["Emery",1.2787175479984256,5.0753078432329479,0.21311994683714502,6.1280000000000004E-4,1075.4160139587902]
["Garfield",1.364074997656348,12.96610657603488,0.32962616280289414,5.9029999999999998E-4,424.13172448963729]
["Grand",1.4398564192770171,12.641684136770605,0.42600364705458077,6.1280000000000004E-4,453.03394622577957]
["Iron",1.4825403620618056,12.95657498018979,0.39237848748435544,5.9029999999999998E-4,480.66951505813665]
["Juab",1.2263436217647836,8.3097266570485555,0.27791638557566484,5.4779999999999998E-4,627.3029701445123]
["Kane",1.3065826009569543,11.514711901326008,0.34396567096205721,5.9029999999999998E-4,463.49716588172885]
["Millard",1.2067046523431288,5.4510430332326703,0.21682293674681602,5.4779999999999998E-4,1075.8645013248395]
["Morgan",1.3566102891237271,11.305539812243662,0.31778244097359432,6.1019999999999998E-4,505.48289362058904]
["Piute",1.2570533939448452,14.372833562884033,0.2225709860504963,5.4779999999999998E-4,333.6804226430105]
["Rich",1.4051602825656837,11.890407317823687,0.32376923622786807,5.5060000000000005E-4,478.47786660997645]
["Salt lake",1.7939879270590282,11.105942152454183,0.60122277683228786,5.597E-4,674.57641450475876]
["San Juan",1.2603273466257394,10.714961471249548,0.33624287306643047,6.1280000000000004E-4,500.17692486065067]
["Sanpete",1.3976704512548872,12.337301328972435,0.36809980406051845,5.4779999999999998E-4,468.91407084025997]
["Sevier",1.3659971225833492,10.202038477509513,0.3436358584219828,5.4779999999999998E-4,571.29039098072008]
["Summit",1.4602498505683836,10.534249511745502,0.45838049664198538,5.9060000000000004E-4,549.56926908173682]
["Tooele",1.2358951945718071,7.4147175699461148,0.27793191268133594,6.0990000000000003E-4,755.5959318449203]
["Uintah",1.4317030419362373,10.067260362191119,0.44124404052149502,5.9630000000000002E-4,596.47867278226079]
["Utah",1.6249112232056389,11.729503197695546,0.49531919104663952,6.198E-4,583.89536326421853]
["Wasatch",1.4291551603482755,12.287063514788683,0.36934996945488496,6.11E-4,469.2212199820969]
["Washington",1.6552243543108898,14.575968580312122,0.45061469029614809,5.9029999999999998E-4,464.04777223488861]
["Wayne",1.2597175789314836,12.440213435501862,0.27406492825771123,5.4779999999999998E-4,406.45575866114956]
["Weber",1.4370992754252916,9.9429682905091692,0.41699378136430693,6.1019999999999998E-4,636.58091398019474]

{"sheet":"ProdPed","index":13,"n_rows":35,"n_cols":6,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
["Source:","Economic Impacts of Active Transportation: Utah Active Transportation Benefits Study.  See UATBS_Final_Report_20170428.pdf"]
["Table 33"]
[]
["Total Multipliers per $ increase in Production Output - Pedestrians"]
[]
["County","$ Total Output ","# of Jobs Per $Million","$ Income","Annual absentee days not taken per mile walked","Output per Employee per day ($)"]
["Beaver",1.2108236564965242,8.1930724235315608,0.34843487916882943,2.3609999999999998E-3,617.40494768733868]
["Box Elder",1.2503663939628289,7.9294646998783618,0.27440348963111028,2.2025999999999999E-3,726.56600697907948]
["Cache",1.4550125326469763,9.9120612725238058,0.34183776018598755,2.2025999999999999E-3,659.06441766801265]
["Carbon",1.3433253974677148,7.2760656025518378,0.31264907925071417,2.4510000000000001E-3,829.36510613122869]
["Daggett",1.2163611172345579,11.706294680757921,0.40545312040977777,2.385E-3,396.83008247655778]
["Davis",1.4315937423188769,10.044411946152307,0.41780653207291985,2.2093999999999998E-3,622.77625212687838]
["Duchesne",1.378153516592191,10.794812015413818,0.45898597384426781,2.385E-3,519.49857932545081]
["Emery",1.2787175479984256,5.0753078432329479,0.21311994683714502,2.4510000000000001E-3,1075.4160139587902]
["Garfield",1.364074997656348,12.96610657603488,0.32962616280289414,2.3609999999999998E-3,424.13172448963729]
["Grand",1.4398564192770171,12.641684136770605,0.42600364705458077,2.4510000000000001E-3,453.03394622577957]
["Iron",1.4825403620618056,12.95657498018979,0.39237848748435544,2.3609999999999998E-3,480.66951505813665]
["Juab",1.2263436217647836,8.3097266570485555,0.27791638557566484,2.1914E-3,627.3029701445123]
["Kane",1.3065826009569543,11.514711901326008,0.34396567096205721,2.3609999999999998E-3,463.49716588172885]
["Millard",1.2067046523431288,5.4510430332326703,0.21682293674681602,2.1914E-3,1075.8645013248395]
["Morgan",1.3566102891237271,11.305539812243662,0.31778244097359432,2.441E-3,505.48289362058904]
["Piute",1.2570533939448452,14.372833562884033,0.2225709860504963,2.1914E-3,333.6804226430105]
["Rich",1.4051602825656837,11.890407317823687,0.32376923622786807,2.2025999999999999E-3,478.47786660997645]
["Salt lake",1.7939879270590282,11.105942152454183,0.60122277683228786,2.2390000000000001E-3,674.57641450475876]
["San Juan",1.2603273466257394,10.714961471249548,0.33624287306643047,2.4510000000000001E-3,500.17692486065067]
["Sanpete",1.3976704512548872,12.337301328972435,0.36809980406051845,2.1914E-3,468.91407084025997]
["Sevier",1.3659971225833492,10.202038477509513,0.3436358584219828,2.1914E-3,571.29039098072008]
["Summit",1.4602498505683836,10.534249511745502,0.45838049664198538,2.362E-3,549.56926908173682]
["Tooele",1.2358951945718071,7.4147175699461148,0.27793191268133594,2.4399999999999999E-3,755.5959318449203]
["Uintah",1.4317030419362373,10.067260362191119,0.44124404052149502,2.385E-3,596.47867278226079]
["Utah",1.6249112232056389,11.729503197695546,0.49531919104663952,2.4789999999999999E-3,583.89536326421853]
["Wasatch",1.4291551603482755,12.287063514788683,0.36934996945488496,2.444E-3,469.2212199820969]
["Washington",1.6552243543108898,14.575968580312122,0.45061469029614809,2.3609999999999998E-3,464.04777223488861]
["Wayne",1.2597175789314836,12.440213435501862,0.27406492825771123,2.1914E-3,406.45575866114956]
["Weber",1.4370992754252916,9.9429682905091692,0.41699378136430693,2.441E-3,636.58091398019474]

{"sheet":"Raw","index":14,"n_rows":34,"n_cols":73,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
["Source:","Economic Impacts of Active Transportation: Utah Active Transportation Benefits Study.  See UATBS_Final_Report_20170428.pdf"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Note that Multipliers are only provided for Counties in which there was sales data from InfoUSA"]
[]
[null,"Total Multipliers per $ of Capital Construction Spending",null,null,"Sample Analysis Assumptions: $0.75 Million per mile in Construction Costs; 10% Multiplier Adjustment",null,null,null,null,"Total Multipliers per $ of Annual Facility Maintenance Spending",null,null,"Sample Analysis Assumptions: $6,300 per mile in Maint. Costs; 10% Multiplier Adjustment",null,null,null,null,"Total Multipliers per $ of Equipment and Service Spending",null,null,"Sample Analysis Assumptions: $0.85 in Spending per Mile, and 1 Thousand Miles",null,null,null,null,"Total Multipliers per $ of Direct Spending - Day Trips",null,null,"Sample Analysis Assumptions: $35 in Spending per Day trip, and 1,000 Day Trips",null,null,null,null,"Total Multipliers per $ of Direct Spending - Overnight Trips",null,null,"Sample Analysis Assumptions: $182 in Spending per Overnight Trip, and 1,000 Overnight Trips",null,null,null,null,"Total Multipliers per $ reduction in Healthcare Spending - Cyclists",null,null,"Sample Analysis Assumptions: Cyclist - Healthcare Cost Savings per Mile, and 1 Thous. Miles",null,null,null,null,"Total Multipliers per $ reduction in Healthcare Spending - Pedestrians",null,null,"Sample Analysis Assumptions: Pedestrian Healthcare Cost Savings per Mile, and 1 Thous. Miles",null,null,null,null,"Total Multipliers per $ increase in Production Output - Cyclists",null,null,"Sample Analysis Assumptions: Cyclist - Reduction in Sick Days per Mile, and 1 Thous. Miles",null,null,"Output per Employee per day",null,null,"Total Multipliers per $ increase in Production Output - Pedestrians",null,null,"Sample Analysis Assumptions: Pedestrian - Reduction in Sick Days per Mile, and 1 Thous. Miles",null,null,"Output per Employee per day"]
["County","$ Total Output ","# of Jobs Per $Million","$ Income","$Total Output ($Thous.) per Mile","# of Jobs per Mile","$Income ($Thous.) per Mile",null,"County","$ Total Output ","# of Jobs Per $Million","$ Income","$Total Output ($Thous.) per Mile","# of Jobs per Mile","$Income ($Thous.) per Mile",null,"County","$ Total Output ","# of Jobs Per $Million","$ Income","$Total Output ($Thous.) per Thous. Rider-Miles","# of Jobs per Thous. Rider-Miles","$Income ($Thous.) per Thous. Rider-Miles",null,"County","$ Total Output ","# of Jobs Per $Million","$ Income","$ Total Output  ($Thous.) per Thousand Day trips","# of Jobs per Thousand Day trips","$ Income  ($Thous.) per Thousand Day trips",null,"County","$ Total Output ","# of Jobs \nPer $Million","$ Income","$ Total Output  ($Thous.) per Thousand Overnight trips","# of Jobs per Thousand Overnight trips","$ Income  ($Thous.) per Thousand Overnight trips",null,"County","$ Total Output ","# of Jobs \nPer $Million","$ Income","$Total Output ($Thous.) per Thousand User-Miles","# of Jobs per Thousand User-Miles","$Income ($Thous.) per Thousand User-Miles",null,"County","$ Total Output ","# of Jobs \nPer $Million","$ Income","$Total Output ($Thous.) per Thousand User-Miles","# of Jobs per Thousand User-Miles","$Income ($Thous.) per Thousand User-Miles",null,"County","$ Total Output ","# of Jobs \nPer $Million","$ Income","$Total Output ($Thous.) per Thousand User-Miles","# of Jobs per Thousand User-Miles","$Income ($Thous.) per Thousand User-Miles",null,null,"County","$ Total Output ","# of Jobs \nPer $Million","$ Income","$Total Output ($Thous.) per Thousand User-Miles","# of Jobs per Thousand User-Miles","$Income ($Thous.) per Thousand User-Miles"]
["Beaver",1.2116407373561198,8.1170335139840137,0.3066412753539699,908.73055301708985,6.7004802458984161,253.1274269776803,null,"Beaver",1.2284998731924497,10.244379242873183,0.35075343464277586,7.7395492011124327,6.4539589230101058E-2,2.2097466382494879,null,null,"--","--","--","--","--","--",null,"Beaver",0.6650790995081004,11.783415911494622,0.27401437343140189,23.096948539600042,0.40921591300912741,9.516004768360272,null,"Beaver",1.0854504634540412,19.215339727167418,0.42411563510482431,197.34947609156052,3.4936068993980411,77.109919990117007,null,"Beaver",0.82976516786427013,2.2105459289416278,0.58005982462545413,0.60904763321237421,1.6225407118431547E-3,0.42576391127508334,null,"Beaver",0.82976516786427013,2.2105459289416278,0.58005982462545413,2.5224861103073812,6.7200596239825484E-3,1.7633818668613805,null,"Beaver",1.2108236564965242,8.1930724235315608,0.34843487916882943,0.44128969517060823,2.9859991691542718E-3,0.12698853444945213,617.40494768733868,null,"Beaver",1.2108236564965242,8.1930724235315608,0.34843487916882943,1.7650092669791735,1.1942984987926879E-2,0.50791111271413936,617.40494768733868]
["Box Elder",1.2952966457041795,8.74903969888096,0.34014011717062004,971.47248427813463,7.2221911578827021,280.78018059342469,null,"Box Elder",1.3118231238758828,11.193333802322758,0.373891680172659,8.264485680418062,7.0518002954633369E-2,2.3555175850877514,null,"Box Elder",1.5485619495284251,13.494777162019444,0.27400568201197956,1.3101237211661299,1.1416932772496806E-2,0.23181593984503915,null,"Box Elder",0.73380024452422499,12.015321250178399,0.32308574048458527,25.483504892361342,0.41726955005410343,11.220161221981314,null,"Box Elder",1.1877424965586949,20.077503833036644,0.48773618187410628,215.94754189117839,3.6503599160735414,88.676990064990136,null,"Box Elder",0.90747684273219398,2.1551891169744559,0.58605413282253316,0.67879267836368107,1.612081459496893E-3,0.43836849135125477,null,"Box Elder",0.90747684273219398,2.1551891169744559,0.58605413282253316,2.7133557597692604,6.444015459753624E-3,1.7523018571393743,null,"Box Elder",1.2503663939628289,7.9294646998783618,0.27440348963111028,0.45570120957164612,3.1721604951623857E-3,0.109774359617978,726.56600697907948,null,"Box Elder",1.2503663939628289,7.9294646998783618,0.27440348963111028,1.8226504418069736,1.2689794236550436E-2,0.43913731292146452,726.56600697907948]
["Cache",1.4519260465727464,10.331352149069064,0.36731427896779378,1088.9445349295597,8.5283645643444288,303.21201286405943,null,"Cache",1.4817864178210278,13.226203867818816,0.42304574519670296,9.3352544322724746,8.3325084367258537E-2,2.6651881947392284,null,"Cache",1.8066777305959678,14.085928030662007,0.33363681464346046,1.5284963911693481,1.191706179609346E-2,0.28226543035738028,null,"Cache",1.6860793451367793,19.651100743738454,0.51074984072836205,58.554370295367278,0.68244583683402171,17.737383112229669,null,"Cache",1.6119970441171445,22.976773735206439,0.59162937335573962,293.0827180315008,4.1774861327969868,107.56616796734832,null,"Cache",1.035427831855865,2.5715351472299992,0.62605642963905739,0.77450001822818704,1.9235082901280394E-3,0.46829020937001492,null,"Cache",1.035427831855865,2.5715351472299992,0.62605642963905739,3.0959292172490365,7.6888900902176982E-3,1.8719087246207817,null,"Cache",1.4550125326469763,9.9120612725238058,0.34183776018598755,0.53028534217694479,3.5968974018903391E-3,0.12404638325726597,659.06441766801265,null,"Cache",1.4550125326469763,9.9120612725238058,0.34183776018598755,2.1209617023204586,1.4388896144939446E-2,0.49623059164993455,659.06441766801265]
["Carbon",1.3953244316071813,8.6147518320199499,0.41836852116178369,1046.493323705386,7.1113386897222748,345.35646633967883,null,"Carbon",1.4038570040869254,10.605548972980458,0.44965667950340393,8.8442991257476304,6.6814958529776883E-2,2.8328370808714447,null,"Carbon",1.7575976962316422,13.221836576036473,0.3308560551872976,1.4869734044551692,1.1186017931618681E-2,0.27991283546927426,null,"Carbon",0.82574606858169608,10.832153859583265,0.38766818999025393,28.676610747375005,0.37618036779815761,13.462988449444925,null,"Carbon",1.1627265682005146,15.260111785666005,0.50133748421054125,211.39931005412052,2.7744933254868402,91.149889548322491,null,"Carbon",0.96269943346822007,2.0179753665358859,0.60850940664264996,0.72009917623422859,1.5094455741688426E-3,0.45516503616870219,null,"Carbon",0.96269943346822007,2.0179753665358859,0.60850940664264996,2.8784713060699785,6.0337463459422995E-3,1.8194431258615236,null,"Carbon",1.3433253974677148,7.2760656025518378,0.31264907925071417,0.48958050330689562,3.32260391532541E-3,0.14277071037910649,829.36510613122869,null,"Carbon",1.3433253974677148,7.2760656025518378,0.31264907925071417,1.9581561380782324,1.3291622564285774E-2,0.57113470156378476,829.36510613122869]
["Daggett",1.2007691329454886,5.4976047770552823,0.55295876209072437,900.57684970911646,4.5381840724143441,456.45853941618179,null,"Daggett",1.1757316541090093,5.7394120366130865,0.61579187921482981,7.4071094208867585,3.6158295830662449E-2,3.8794888390534279,null,null,"--","--","--","--","--","--",null,"Daggett",0.65460022939420837,14.035547123554728,0.23374901323194142,22.733037053052467,0.48742820196521092,8.1176644008111456,null,"Daggett",1.0673765135506832,22.09685374203929,0.37877685866146005,194.06338919545055,4.0175048572798664,68.866721356014466,null,"Daggett",0.83892393461925707,2.9483225729591633,0.59634045528605339,0.61912586374901168,2.1758620588438627E-3,0.44009925600110739,null,"Daggett",0.83892393461925707,2.9483225729591633,0.59634045528605339,2.5587180005887338,8.992383847525447E-3,1.8188383886224628,null,"Daggett",1.2163611172345579,11.706294680757921,0.40545312040977777,0.44330784566510439,2.7700579136264907E-3,9.5942281945267313E-2,396.83008247655778,null,"Daggett",1.2163611172345579,11.706294680757921,0.40545312040977777,1.7730811851860266,1.1079302572529232E-2,0.38373694858202673,396.83008247655778]
["Davis",1.4579725877251433,8.8608059110314681,0.44588718554138163,1093.4794407938575,7.314452363332105,368.07267993561146,null,"Davis",1.5814522155499291,11.360662423206891,0.52979379056072784,9.9631489579645525,7.1572173266203409E-2,3.3377008805325854,null,"Davis",1.9190648440416558,14.36732870334766,0.39497240648291343,1.6235788147839947,1.2155134090553394E-2,0.33415693772981819,null,"Davis",1.5967580333970832,17.978250279074729,0.56294412729444421,55.452408826021468,0.62435088072224343,19.549992697720416,null,"Davis",1.5878341813279486,23.591426816629841,0.58015877971079066,288.68958497488393,4.2892383201892832,105.48065994786079,null,"Davis",0.99911278588696417,2.5993283086919847,0.63587247173531325,0.74833547662933619,1.9468969032102965E-3,0.47626848132974964,null,"Davis",0.99911278588696417,2.5993283086919847,0.63587247173531325,2.9973383576608925,7.7979849260759538E-3,1.9076174152059397,null,"Davis",1.4315937423188769,10.044411946152307,0.41780653207291985,0.5217502670735612,3.4554946855976914E-3,0.14373447235395617,622.77625212687838,null,"Davis",1.4315937423188769,10.044411946152307,0.41780653207291985,2.0868242936823278,1.3820727658145437E-2,0.574885849418593,622.77625212687838]
["Duchesne",1.4359606188479614,8.8368255372820279,0.41197088593494802,1076.970464135971,7.294656951582164,340.07532164759095,null,"Duchesne",1.4114582754718679,10.645007830510067,0.45487960652935305,8.8921871354727671,6.7063549332213424E-2,2.865741521134924,null,null,"--","--","--","--","--","--",null,"Duchesne",1.3819163775656871,18.495597241009008,0.39223394944689549,47.99136145200189,0.64231736946884854,13.621548703845098,null,"Duchesne",1.3885833959606684,22.326539614751979,0.49328377246291072,252.46311547950319,4.059264834516636,89.685616559825462,null,"Duchesne",0.92375993848436,2.7569118132369019,0.62335935450729618,0.68173483460145767,2.0346009181688336E-3,0.46003920362638456,null,"Duchesne",0.92375993848436,2.7569118132369019,0.62335935450729618,2.817467812377298,8.40858103037255E-3,1.9012460312472532,null,"Duchesne",1.378153516592191,10.794812015413818,0.45898597384426781,0.50227375553181186,3.3439845124831279E-3,0.14218329932847651,519.49857932545081,null,"Duchesne",1.378153516592191,10.794812015413818,0.45898597384426781,2.0089248463672842,1.3374816472031292E-2,0.56868550880163737,519.49857932545081]
["Emery",1.2132846029673856,7.550571502223888,0.32552059539155948,909.96345222553919,6.2328749916744925,268.71200116354862,null,"Emery",1.2535885761274959,9.6441744321944913,0.36004975956963153,7.8976080296032238,6.0758298922825298E-2,2.2683134852886786,null,null,"--","--","--","--","--","--",null,"Emery",0.71240345414823336,12.050327983054766,0.28706272111331876,24.740434531869781,0.41848526816700604,9.9691493870363725,null,"Emery",1.1696583982946784,19.146610551613051,0.45776478037483115,212.65960988676864,3.4811110119812185,83.227786639538564,null,"Emery",0.87384468507966939,1.555815517078919,0.55590428883580045,0.64489737758879595,1.1481918516042422E-3,0.41025736516082073,null,"Emery",0.87384468507966939,1.555815517078919,0.55590428883580045,2.6652262894929915,4.7452373270907029E-3,1.6955080809491911,null,"Emery",1.2787175479984256,5.0753078432329479,0.21311994683714502,0.46603390505127018,3.2546455491075988E-3,0.13666754959985306,1075.4160139587902,null,"Emery",1.2787175479984256,5.0753078432329479,0.21311994683714502,1.8639777228969145,1.3017490582964317E-2,0.54662435987866764,1075.4160139587902]
["Garfield",1.3171103051809214,10.250176457994966,0.23196682384566747,987.83272888569104,8.4613553406481028,191.48487168421389,null,"Garfield",1.2909449691761559,12.990698536729001,0.25425136605249249,8.1329533058097816,8.1841400781392709E-2,1.6017836061307027,null,null,"--","--","--","--","--","--",null,"Garfield",0.75073084162742698,14.045772281204639,0.25425174522882599,26.071472745097324,0.48778330249419155,8.8296857922569103,null,"Garfield",1.2228307993461449,21.862821171729635,0.41978812026824658,222.32706671077281,3.9749545920268572,76.323119657415106,null,"Garfield",0.928307349507833,3.2128837909673247,0.58927399418860782,0.68137759453874946,2.3582567025700165E-3,0.43252711173443814,null,"Garfield",0.928307349507833,3.2128837909673247,0.58927399418860782,2.8220543425038125,9.7671667245406678E-3,1.7913929423333679,null,"Garfield",1.364074997656348,12.96610657603488,0.32962616280289414,0.49714278101184911,3.2462587149285622E-3,8.2526840065091076E-2,424.13172448963729,null,"Garfield",1.364074997656348,12.96610657603488,0.32962616280289414,1.9884026867168827,1.2983934992285846E-2,0.33007939927779095,424.13172448963729]
["Grand",1.3634866865257222,9.464621926202522,0.36324632452610128,1022.6150148942917,7.812892744887824,299.85398208461066,null,"Grand",1.4167536161189762,12.149314564035235,0.41802550358676138,8.9255477815495503,7.6540681753421977E-2,2.6335606725965968,null,"Grand",1.7589443688379565,12.649627364556641,0.30685029196399721,1.4881127245364318,1.0701914043067251E-2,0.25960333486897819,null,"Grand",1.5805640602036342,19.112683730841873,0.45872462750592108,54.890022538770232,0.66374762477335825,15.930645126553722,null,"Grand",1.5519272239566113,21.798157041788794,0.57531420047856174,282.161217754213,3.9631977845120003,104.59985036183686,null,"Grand",0.99055314804817352,3.1447554987218274,0.63097826588146189,0.72706601066735932,2.3082505360618212E-3,0.46313804715699303,null,"Grand",0.99055314804817352,3.1447554987218274,0.63097826588146189,3.0112815700664477,9.5600567161143544E-3,1.9181739282796442,null,"Grand",1.4398564192770171,12.641684136770605,0.42600364705458077,0.52476163390355957,3.380714243953831E-3,0.11392442509970896,453.03394622577957,null,"Grand",1.4398564192770171,12.641684136770605,0.42600364705458077,2.0988687407187943,1.3521711553405039E-2,0.45565910157616946,453.03394622577957]
["Iron",1.3852754146502944,10.495323702156538,0.31877242233655578,1038.9565609877209,8.6637204367156695,263.14149314814392,null,"Iron",1.4348744649545266,13.557185760356619,0.3657880237657628,9.0397091292135183,8.5410270290246698E-2,2.3044645497243055,null,"Iron",1.9205273780028171,17.253561988755699,0.31013933394608773,1.6248161565875385,1.4596962583875104E-2,0.26238595000553133,null,"Iron",1.6029202777775544,20.158566541839427,0.46962031095352763,55.666412004665105,0.70006917131109991,16.309031757676649,null,"Iron",1.5895948028023401,24.642118364656206,0.53701553442123096,289.00968961094543,4.4802681585082134,97.636638372071218,null,"Iron",1.0303777760329791,3.210883025839856,0.62891558237171463,0.75629728760820658,2.3567881409664545E-3,0.46162403746083852,null,"Iron",1.0303777760329791,3.210883025839856,0.62891558237171463,3.1323484391402565,9.7610843985531624E-3,1.9119033704100126,null,"Iron",1.4825403620618056,12.95657498018979,0.39237848748435544,0.54031797358945588,3.6762884105836684E-3,0.11133316391921617,480.66951505813665,null,"Iron",1.4825403620618056,12.95657498018979,0.39237848748435544,2.1610888288068866,1.4703908076212165E-2,0.44529493480140497,480.66951505813665]
["Juab",1.2188242405496745,8.2090355540829254,0.31293297945303183,914.11818041225592,6.7764264460961963,258.32112723235753,null,"Juab",1.3181624386979609,11.029578902141326,0.37128488662399239,8.3044233637971541,6.9486347083490357E-2,2.3390947857311519,null,null,"--","--","--","--","--","--",null,"Juab",0.70289617082362121,13.968833136310437,0.2357854804794666,24.410264430505332,0.48511135043372755,8.1883870851556981,null,"Juab",1.1522086256427877,22.399905021681736,0.37583556598228296,209.48700680011171,4.0726036510801844,68.331954833901207,null,"Juab",0.88174676057060442,2.2350437979801967,0.57669084097088963,0.65866483014624144,1.6695777170912069E-3,0.43078805820525456,null,"Juab",0.88174676057060442,2.2350437979801967,0.57669084097088963,2.6364228141061075,6.682780955960789E-3,1.72430561450296,null,"Juab",1.2263436217647836,8.3097266570485555,0.27791638557566484,0.44694601077490143,2.8555259415118509E-3,9.5502232664821551E-2,627.3029701445123,null,"Juab",1.2263436217647836,8.3097266570485555,0.27791638557566484,1.7876326129756772,1.1423146309290018E-2,0.38204379821411094,627.3029701445123]
["Kane",1.2573314578893648,10.388895451029466,0.1781959848357918,942.99859341702359,8.5758656319949687,147.09791135315842,null,"Kane",1.315103454283876,14.188247085247683,0.20134170180849137,8.2851517619884181,8.9385956637060407E-2,1.2684527213934955,null,null,"--","--","--","--","--","--",null,"Kane",1.4434354228447566,17.982049132212495,0.41227251304569074,50.127802401757954,0.62448280775994069,14.317450398231811,null,"Kane",1.4285311599494745,20.886629025494571,0.53199627287898077,259.72615562703174,3.7974697457712789,96.724069195420313,null,"Kane",0.92351494620096042,2.9080909392784617,0.59729469090203191,0.67785997051150493,2.1345387494303906E-3,0.4384143031220914,null,"Kane",0.92351494620096042,2.9080909392784617,0.59729469090203191,2.8074854364509196,8.8405964554065242E-3,1.815775860342177,null,"Kane",1.3065826009569543,11.514711901326008,0.34396567096205721,0.4761894389805969,3.1504525469031011E-3,9.4109825188492716E-2,463.49716588172885,null,"Kane",1.3065826009569543,11.514711901326008,0.34396567096205721,1.9045964178099091,1.2600742780345961E-2,0.37640741533124056,463.49716588172885]
["Millard",1.3257997053484001,9.817313543500493,0.30213589096946475,994.34977901130003,8.1040339863928263,249.40830483576138,null,"Millard",1.4414606849687925,13.530662166563483,0.37009230477008365,9.0812023153033934,8.5243171649349928E-2,2.3315815200515271,null,null,"--","--","--","--","--","--",null,"Millard",0.73144092159944951,12.59844099084134,0.29482841481879762,25.401570036459027,0.43752020392742186,10.238837350501772,null,"Millard",1.2001292832517971,20.257560968283912,0.46281094081904484,218.19962611486821,3.6830967221314803,84.145246397923657,null,"Millard",0.88140617699205692,1.6347202969788606,0.56709401671683135,0.65841041421306656,1.2211360618432088E-3,0.42361923048747302,null,"Millard",0.88140617699205692,1.6347202969788606,0.56709401671683135,2.6354044692062506,4.8878136879667933E-3,1.6956111099833258,null,"Millard",1.2067046523431288,5.4510430332326703,0.21682293674681602,0.43978850705167299,3.2126189479287806E-3,0.12778645677381364,1075.8645013248395,null,"Millard",1.2067046523431288,5.4510430332326703,0.21682293674681602,1.7590050231221412,1.2851648708454054E-2,0.51119248151539842,1075.8645013248395]
["Morgan",1.3330129186448394,8.5140829481316924,0.40945534382438181,999.75968898362953,7.0282381497641939,337.9987822085784,null,"Morgan",1.3515950733092923,10.358893156227811,0.4688140177473285,8.5150489618485405,6.5261026884235213E-2,2.9535283118081694,null,"Morgan",1.7795467787925165,19.313421477230108,0.20214395525699344,1.5055428996759399,1.6339657332988155E-2,0.17101904831975254,null,"Morgan",1.4111100544814206,19.878116708779995,0.34482129464111866,49.005203044532934,0.69032967511146892,11.974996212592874,null,"Morgan",1.2182576909249834,20.047779191800114,0.38869864347487482,221.49561416511332,3.6449555769788096,70.670635123382354,null,"Morgan",0.89282746071598251,2.8641644405711695,0.57773431260445485,0.66694211315483909,2.1395308371066637E-3,0.43156753151552779,null,"Morgan",0.89282746071598251,2.8641644405711695,0.57773431260445485,2.7409803043980663,8.7929848325534899E-3,1.7736443396956763,null,"Morgan",1.3566102891237271,11.305539812243662,0.31778244097359432,0.49442223707861521,3.4871447081194227E-3,9.8018615278700386E-2,505.48289362058904,null,"Morgan",1.3566102891237271,11.305539812243662,0.31778244097359432,1.9775214327335431,1.3949721783873336E-2,0.39210658783236257,505.48289362058904]
["Piute",1.1251171898677716,9.8672114177259154,0.11568040081206049,843.83789240082876,8.1452238767614897,95.492305057439609,null,"Piute",1.0934110063156606,12.510473077054753,0.11828895322241789,6.8884893397886611,7.8815980385444948E-2,0.74522040530123268,null,null,"--","--","--","--","--","--",null,"Piute",0.62993861517784255,12.879237545009605,0.23320840476527738,21.876585489802082,0.44727174110024576,8.0988900836752649,null,"Piute",1.0273839885145732,20.283251230848691,0.37342213591652162,186.79221088820663,3.687767556986238,67.893160826161775,null,"Piute",0.83514351272841736,3.508295768205647,0.54712080707060429,0.6238522040081278,2.6206969388496183E-3,0.40869924288174142,null,"Piute",0.83514351272841736,3.508295768205647,0.54712080707060429,2.4970791030579682,1.0489804346934885E-2,1.635891213141107,null,"Piute",1.2570533939448452,14.372833562884033,0.2225709860504963,0.45813831440341668,2.6272121948211851E-3,4.0683780703845179E-2,333.6804226430105,null,"Piute",1.2570533939448452,14.372833562884033,0.2225709860504963,1.8323980354166811,1.0509807965920308E-2,0.16274997633151939,333.6804226430105]
["Rich",1.2952086255297832,9.441210270740287,0.29801140475833615,971.40646914733736,7.793566800911095,246.00360799244586,null,"Rich",1.365669786231507,12.89241338844427,0.35278317271892451,8.6037196532584943,8.1222204347198901E-2,2.2225339881292245,null,"Salt Lake",2.2074717577421721,12.916442293990926,0.55757947067744862,1.8675785715276132,1.092764641904328E-2,0.47172674699403178,null,"Rich",0.74466833112654107,13.588917790865946,0.2626040684674848,25.860933136856271,0.47191760372055341,9.119746298100635,null,"Rich",1.1964017537601062,21.870396559826357,0.41020983760907548,217.52191117801129,3.9763318993498653,74.581659196263132,null,"Rich",0.91433955933879352,2.9869867967429742,0.58085003960785231,0.68392599038541757,2.2342661239637446E-3,0.43447582962667353,null,"Rich",0.91433955933879352,2.9869867967429742,0.58085003960785231,2.7338752824229928,8.9310905222614936E-3,1.7367416184274784,null,"Rich",1.4051602825656837,11.890407317823687,0.32376923622786807,0.51211648321560221,3.132526777641695E-3,8.5296977231393054E-2,478.47786660997645,null,"Rich",1.4051602825656837,11.890407317823687,0.32376923622786807,2.0482924222802588,1.253124496991209E-2,0.34121889220825713,478.47786660997645]
["Salt lake",1.7835537483352906,10.137711475519133,0.57407091308155278,1337.665311251468,8.3685173115656326,473.8862795405463,null,"Salt lake",1.8546516611927018,12.444490795989671,0.64398197057136408,11.68430546551402,7.8400292014734932E-2,4.0570864145995937,null,null,"--","--","--","--","--","--",null,"Salt lake",2.0563967509362033,19.085820382431727,0.74938800369475467,71.414798583361176,0.66281471111498391,26.024838504672545,null,"Salt lake",1.9549726483554988,22.399853355735129,0.79266208368467217,355.44029038283594,4.0725942575170153,144.11661535896354,null,"Salt lake",1.2047303646823957,2.8222502220153785,0.72667508313478046,0.90475250387647921,2.1195099167335492E-3,0.54573298743422016,null,"Salt lake",1.2047303646823957,2.8222502220153785,0.72667508313478046,3.6262383976940109,8.4949731682662875E-3,2.187292000235689,null,"Salt lake",1.7939879270590282,11.105942152454183,0.60122277683228786,0.65382632823865916,4.1931641746728214E-3,0.22699792365237267,674.57641450475876,null,"Salt lake",1.7939879270590282,11.105942152454183,0.60122277683228786,2.6150837895501851,1.6774155060018666E-2,0.90807280875051355,674.57641450475876]
["San Juan",1.2554756312296278,8.4413708972218444,0.30298657837090309,941.60672342222085,6.9682155245131288,250.11053356488418,null,"San Juan",1.267496968254813,10.556125880184153,0.33751231364061457,7.9852309000053214,6.6503593045160153E-2,2.1263275759358717,null,null,"--","--","--","--","--","--",null,"San Juan",1.3321127727848503,18.131131414889779,0.36098805893004349,46.261775756766014,0.62966015555768418,12.536437585670622,null,"San Juan",1.3081058139697295,22.777493750797429,0.43252409927401358,237.83120994556643,4.1412543545235625,78.638691734562826,null,"San Juan",0.88007234279140523,2.7401431089624051,0.58910860334395043,0.66093432943634534,2.0578474748307661E-3,0.44242056111130679,null,"San Juan",0.88007234279140523,2.7401431089624051,0.58910860334395043,2.6490177518021296,8.2478307579768387E-3,1.7732168960652908,null,"San Juan",1.2603273466257394,10.714961471249548,0.33624287306643047,0.459331520014162,2.9996430151227665E-3,9.4130864425862285E-2,500.17692486065067,null,"San Juan",1.2603273466257394,10.714961471249548,0.33624287306643047,1.8371704535887456,1.1999643935786805E-2,0.37655709388870051,500.17692486065067]
["Sanpete",1.3425205942617817,10.136005081267644,0.29316247990625299,1006.8904456963363,8.3671087106335165,242.00089873551659,null,"Sanpete",1.4163836303493293,13.741930794218819,0.33852484168529884,8.9232168712007738,8.6574164003578563E-2,2.1327065026173826,null,null,"--","--","--","--","--","--",null,"Sanpete",0.75287838441478816,13.098683866413596,0.29573771284366501,26.146052874412703,0.45489269986503211,10.270415563834677,null,"Sanpete",1.2312181258751917,21.046561603072092,0.46500982083287823,223.85199534827973,3.8265476368935145,84.54503232397812,null,"Sanpete",0.94592299476352626,3.0808348990842114,0.60362285885270894,0.70660447708835417,2.3013836696159059E-3,0.45090627556297358,null,"Sanpete",0.94592299476352626,3.0808348990842114,0.60362285885270894,2.8283097543429436,9.2116963482617928E-3,1.8048323479695998,null,"Sanpete",1.3976704512548872,12.337301328972435,0.36809980406051845,0.50938678318183828,3.1690965089267043E-3,9.4554211887921333E-2,468.91407084025997,null,"Sanpete",1.3976704512548872,12.337301328972435,0.36809980406051845,2.0373745469969848,1.2677543062544689E-2,0.37825136898720479,468.91407084025997]
["Sevier",1.4961038056409632,10.680132248949491,0.32911575552875416,1122.0778542307223,8.8162769113102399,271.67974787034899,null,"Sevier",1.5491205325445019,13.998354022928755,0.39074434262051971,9.7594593550303621,8.8189630344451167E-2,2.4616893585092741,null,null,"--","--","--","--","--","--",null,"Sevier",0.7707191910418949,12.780854755759625,0.32056794383629422,26.765630595131952,0.44385509152853353,11.132722871171964,null,"Sevier",1.2581429583749246,20.708319276712718,0.50026149005889586,228.74729160230385,3.7650506380469717,90.954259356752914,null,"Sevier",0.96248049574250316,2.6324300302769981,0.61038253026861633,0.71897293031964982,1.9664252326169174E-3,0.45595575011065642,null,"Sevier",0.96248049574250316,2.6324300302769981,0.61038253026861633,2.8778166822700846,7.8709657905282251E-3,1.8250437655031631,null,"Sevier",1.3659971225833492,10.202038477509513,0.3436358584219828,0.49784330740028326,3.1927572844278607E-3,0.10754183025148109,571.29039098072008,null,"Sevier",1.3659971225833492,10.202038477509513,0.3436358584219828,1.9912045549247313,1.2772194803021567E-2,0.43020658417870694,571.29039098072008]
["Summit",1.4067745835354981,8.3470389495441086,0.45764383067525954,1055.0809376516236,6.8903460231881848,377.77760087031908,null,"Summit",1.4266264251676961,10.416855091921226,0.52049511217377042,8.9877464785564847,6.5626187079103726E-2,3.2791192066947534,null,"Summit",1.7866776556124118,10.437982917924238,0.38927332747045407,1.511575807095177,8.8308052681158721E-3,0.32933536852795525,null,"Summit",1.6182062088834592,15.896680688069267,0.60529409015534807,56.197263694928836,0.55206187666151096,21.020727402172451,null,"Summit",1.5330896457809891,18.452571354148862,0.66841380120817839,278.73629297969774,3.35492536222737,121.5266084654334,null,"Summit",0.98196426861936059,2.7021938074665552,0.64170140429481692,0.72076177316661061,1.9834102546804513E-3,0.47100883075239564,null,"Summit",0.98196426861936059,2.7021938074665552,0.64170140429481692,2.9851713766028563,8.2146691746983278E-3,1.9507722690562435,null,"Summit",1.4602498505683836,10.534249511745502,0.45838049664198538,0.53219410437914416,3.419160464534522E-3,0.14877912945620758,549.56926908173682,null,"Summit",1.4602498505683836,10.534249511745502,0.45838049664198538,2.1285961044200565,1.367432613821629E-2,0.59501575309102994,549.56926908173682]
["Tooele",1.2723473891635182,8.3071670985339505,0.33346451012130973,954.26054187263867,6.8574324532736703,275.26957464530051,null,"Tooele",1.381560960232769,11.297715183270734,0.40165871329007652,8.7038340494664439,7.1175605654605623E-2,2.5304498937274822,null,null,"--","--","--","--","--","--",null,"Tooele",1.3812444240402117,15.889025960771797,0.50909752823005605,47.968025767554153,0.55179604235307289,17.680001401132543,null,"Tooele",1.2205303518127495,17.631700380779101,0.47093091918201796,221.90881444521381,3.2056799917681853,85.621567547309212,null,"Tooele",0.88411829086007943,2.0470918896886841,0.57994010166308052,0.66043636327247934,1.5291776415974469E-3,0.43321525594232113,null,"Tooele",0.88411829086007943,2.0470918896886841,0.57994010166308052,2.7142431529404436,6.2845721013442598E-3,1.7804161121056572,null,"Tooele",1.2358951945718071,7.4147175699461148,0.27793191268133594,0.45042712103385296,3.416983310251343E-3,0.12808157533440079,755.5959318449203,null,"Tooele",1.2358951945718071,7.4147175699461148,0.27793191268133594,1.8015558745738216,1.3670174253178022E-2,0.51241030302662383,755.5959318449203]
["Uintah",1.4525006832357112,8.965339857040755,0.4147538412334435,1089.3755124267834,7.400743449731384,342.3726063601232,null,"Uintah",1.4538147960534888,11.082587212396914,0.4561635949971089,9.1590332151369793,6.9820299438100558E-2,2.8738306484817859,null,"Uintah",1.6719040304541726,12.186834697758249,0.30003372545460993,1.414474332446501,1.0310379399626641E-2,0.25383634215449591,null,"Uintah",1.4524883703950027,17.520633120734999,0.46593422665506434,50.442194274625976,0.60845869592072421,16.181020970061759,null,"Uintah",1.4802586300347997,22.162063394884779,0.53831815966140406,269.13090459032981,4.0293608481872898,97.873473140075063,null,"Uintah",0.97525963880660971,2.6041261760601353,0.63028954850951391,0.71974161343927801,1.9218451179323799E-3,0.46515368680002128,null,"Uintah",0.97525963880660971,2.6041261760601353,0.63028954850951391,2.9745418983601595,7.9425848369834122E-3,1.9223831229540174,null,"Uintah",1.4317030419362373,10.067260362191119,0.44124404052149502,0.5217901017716764,3.5807255070681773E-3,0.1569417829572517,596.47867278226079,null,"Uintah",1.4317030419362373,10.067260362191119,0.44124404052149502,2.0869836189783637,1.4321701047052831E-2,0.62771449329707418,596.47867278226079]
["Utah",1.4899387710008969,9.5860003883341491,0.44953246614232945,1117.4540782506726,7.91308870766035,371.08180027684546,null,"Utah",1.5514723328803548,12.121209788072218,0.50995344287277611,9.7742756971462352,7.6363621664854969E-2,3.2127066900984893,null,"Utah",2.0658452931562126,14.984663320875562,0.42517123602288254,1.7477588956951648,1.2677415247317331E-2,0.35970593365072029,null,"Utah",1.8366663559827954,19.345870386587301,0.61827728744556021,63.78397447750902,0.67184575955440484,21.471609470054741,null,"Utah",1.7384017287697613,21.843917769316079,0.68599587538068396,316.06478780954654,3.9715176995216086,124.72326574586383,null,"Utah",1.1015982568731841,2.953197861516065,0.67541453011979424,0.82950348742550761,2.223757989721597E-3,0.50858714118020509,null,"Utah",1.1015982568731841,2.953197861516065,0.67541453011979424,3.3929226311694074,9.0958494134694805E-3,2.0802767527689663,null,"Utah",1.6249112232056389,11.729503197695546,0.49531919104663952,0.59220562343693761,4.2448878084207923E-3,0.17925519605671059,583.89536326421853,null,"Utah",1.6249112232056389,11.729503197695546,0.49531919104663952,2.3686218481019985,1.6978181473177062E-2,0.71696294131104477,583.89536326421853]
["Wasatch",1.3077959366057859,8.3580096707448348,0.37030982769087406,980.84695245433943,6.8994021765922682,305.68479001966023,null,"Wasatch",1.3620118140969604,10.651451995240755,0.41642231006928127,8.5806744288108501,6.7104147570016759E-2,2.6234605534364719,null,"Wasatch",1.8725952213338792,14.303227514314237,0.32036955498743436,1.5842643042849875,1.2100902815961366E-2,0.27104098331764559,null,"Wasatch",1.6086751454232919,20.052397770522337,0.43739298210038935,55.8662677541002,0.69638212919921127,15.189837128586314,null,"Wasatch",1.546884982267769,22.731583301271836,0.53656843123931253,281.24447047819865,4.13290721804331,97.555349007257917,null,"Wasatch",0.96608128367313784,3.0702848681056234,0.60978759358552581,0.72262880018750708,2.2965730813430062E-3,0.4561211200019733,null,"Wasatch",0.96608128367313784,3.0702848681056234,0.60978759358552581,2.965869540876533,9.4257745450842621E-3,1.8720479123075642,null,"Wasatch",1.4291551603482755,12.287063514788683,0.36934996945488496,0.52086151577713469,3.5226294197004677E-3,0.1058904812367305,469.2212199820969,null,"Wasatch",1.4291551603482755,12.287063514788683,0.36934996945488496,2.0832695896151363,1.4090517678801871E-2,0.42356192494692202,469.2212199820969]
["Washington",1.6201565175187995,11.357925204065666,0.4109902151035974,1215.1173881390996,9.3757840636142049,339.26579369358245,null,"Washington",1.5893406298971819,13.813167918156967,0.45395021743523856,10.012845968352247,8.7022957884388893E-2,2.8598863698420027,null,"Washington",2.1123394197236371,16.966835514684952,0.40010891345513139,1.7870941370973139,1.4354384522803149E-2,0.33850255634087034,null,"Washington",1.8084426120033572,21.313400255780142,0.53499624540338897,62.80381683495181,0.74017437816906861,18.579415227603029,null,"Washington",1.7616043957555341,24.856475231764051,0.61575490704394731,320.28334436992441,4.5192411165976569,111.95251409193006,null,"Washington",1.1176906144052867,3.5509559818655454,0.66145878496219113,0.82038491097348032,2.6064016906893099E-3,0.48551074816224826,null,"Washington",1.1176906144052867,3.5509559818655454,0.66145878496219113,3.3977794677920716,1.0794906184871259E-2,2.0108347062850611,null,"Washington",1.6552243543108898,14.575968580312122,0.45061469029614809,0.60325336958339826,3.9927571749615049E-3,0.12343571049221312,464.04777223488861,null,"Washington",1.6552243543108898,14.575968580312122,0.45061469029614809,2.4128090895924164,1.5969675910696448E-2,0.49370102062021881,464.04777223488861]
["Wayne",1.1921358946576595,8.7230290243425195,0.25831210978145414,894.10192099324456,7.2007197655782287,213.23248030023908,null,"Wayne",1.2877910437662803,12.168789570784353,0.28762268122875778,8.1130835757275648,7.6663374295941417E-2,1.812022891741174,null,null,"--","--","--","--","--","--",null,"Wayne",0.65879242927709503,13.287965978543756,0.23558201108144308,22.878624284758235,0.46146611227051976,8.1813209749456366,null,"Wayne",1.0860529909355519,20.808187783258624,0.38824476218897475,197.45902368199455,3.7832080741607896,70.588113408208812,null,"Wayne",0.86158579157561144,3.1024460514553911,0.56539223493411939,0.6436045863069817,2.3175272004371771E-3,0.42234799949578716,null,"Wayne",0.86158579157561144,3.1024460514553911,0.56539223493411939,2.5761415168110782,9.2763136938516198E-3,1.6905227824530171,null,"Wayne",1.2597175789314836,12.440213435501862,0.27406492825771123,0.45910928765317427,2.7698939423508105E-3,6.102232799522856E-2,406.45575866114956,null,"Wayne",1.2597175789314836,12.440213435501862,0.27406492825771123,1.836281599439513,1.1080587048681209E-2,0.24411159103458174,406.45575866114956]
["Weber",1.4062970308381566,9.269735601781095,0.41410418302067792,1054.7227731286175,7.6520172274057483,341.83632398384344,null,"Weber",1.5082520696385084,12.105913048224741,0.49235963630958546,9.5019880387226028,7.6267252203815875E-2,3.1018657087503883,null,"Weber",1.8417141269183797,14.402574528916857,0.36942850697829221,1.5581380945187995,1.2184952976497448E-2,0.31254613379505847,null,"Weber",1.5960511498080683,18.756634826139969,0.54706964313659556,55.427860086042962,0.65138271474150933,18.998701664882809,null,"Weber",1.5851320905958384,23.078075576025139,0.60346348235146063,288.19830858016303,4.1959041683368712,109.71776796103596,null,"Weber",1.0292498478393113,2.5780254110069256,0.65070389408650431,0.76884963633596548,1.9257849820221735E-3,0.4860758088826187,null,"Weber",1.0292498478393113,2.5780254110069256,0.65070389408650431,3.1597970328666856,7.9145380117912612E-3,1.9976609548455682,null,"Weber",1.4370992754252916,9.9429682905091692,0.41699378136430693,0.52375678141051363,3.8622632444179463E-3,0.16197776236011127,636.58091398019474,null,"Weber",1.4370992754252916,9.9429682905091692,0.41699378136430693,2.0948496712014615,1.5450318878440197E-2,0.6479641394969381,636.58091398019474]