{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Quick Start Guide","EPAP Outputs","Summary","ChangeLog"],"not_rendered":{"charts":10,"images":4,"macros":1,"external_links":0,"defined_names":21,"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":"Quick Start Guide","index":0,"n_rows":41,"n_cols":4,"rows_kept":41,"cut":false,"hidden":false,"merged":[[27,1,27,5],[46,1,47,5],[16,1,16,5],[23,1,23,5],[24,1,24,5],[25,1,25,5],[17,1,17,3],[18,1,18,3],[12,1,13,5]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Envision Tomorrow™ Health Assessment Model"]
[null,{"$f":"\"Version \"&ChangeLog!B2","v":"Version 1.0.1"}]
[]
[null,"What is the Health Assessment Model?"]
[null,"The Health Assessment Model is used to analyze health outcomes for a community based on a variety of demographic and built environment characteristics.  With the Health Assessment Model, users can explore health outcomes based on existing conditions within their study area.  In addition to baseline analyses, the Health Assessment Model can also respond to the core scenario functionality of Envision Tomorrow to test how land use and demographic shifts may impact health outcomes.  "]
[]
[]
[null,"Quick Start Guide"]
[null,"Once you have preprocessed your scenario data, a few quick and easy steps will get you started testing health outcomes of different land use scenarios."]
[null,"A step-by-step guide to pre-processing scenario data for this app can be found here: "]
[null,"http://www.envisiontomorrow.org/health-assessment-model"]
[]
[null,"1. Save this file with a new name. "]
[]
[null,"2.  Close the file and run the Health Assessment Model GIS Tool "]
[null,"Available as part of the Envision Tomorrow core install"]
[null,"www.EnvisionTomorrow.org/downloads"]
[]
[null,"4. View results in \"Summary\" tab"]
[null,"Once the \"Health Assessment Model App\" has completed it will write output totals to the \"EPAP Outputs\" tab.  View results in the \"Summary Tab\""]
[]
[null,null,"TAB Color Definition"]
[null,null,"Input Tab"]
[null,null,"Output Tab"]
[null,null,"Reference and Parameter Tab"]
[]
[null,null,"CELL Color Definition"]
[null,null,"Input Cell"]
[null,null,"Header Cell"]
[null,null,"Scenario Macro Input Cell"]
[null,null,"Subheader Cell"]
[null,null,"Information cell","[Click for info ◊]"]
[null,null,"Output Cell","[white]"]

{"sheet":"EPAP Outputs","index":1,"n_rows":31,"n_cols":9,"rows_kept":31,"cut":false,"hidden":false,"merged":[[1,0,13,0],[14,0,30,0]]}
["Variable Type","Variable Name","Description","Existing","Scenario 1","Scenario 2","Scenario 3","Scenario 4","Scenario 5"]
["Input Variables","totpop2010"]
[null,"tothhs2010"]
[null,"totemp2010"]
[null,"totwrk2010"]
[null,"popdens_ac"]
[null,"empdens_ac"]
[null,"retailempl"]
[null,"empentropy"]
[null,"intrsndens"]
[null,"avg_hhsize"]
[null,"pct_lowinc"]
[null,"pct_medinc"]
[null,"pct_higinc"]
["Output Variables","walktr_p_t"]
[null,"walktr_d_t"]
[null,"walktr_p_h"]
[null,"walktr_d_h"]
[null,"walkle_p_h"]
[null,"walkle_d_h"]
[null,"biketr_p_t"]
[null,"bmi"]
[null,"biketr_d_t"]
[null,"overweight"]
[null,"obese"]
[null,"recrpa_p_t"]
[null,"gen_health"]
[null,"recrpa_d_t"]
[null,"autotr_p_t"]
[null,"mnt_health"]
[null,"autotr_d_t"]

{"sheet":"Summary","index":2,"n_rows":141,"n_cols":13,"rows_kept":141,"cut":false,"hidden":false,"merged":[[0,1,0,2],[0,11,0,12],[0,3,0,4],[0,5,0,6],[0,7,0,8],[0,9,0,10]]}
[null,"Existing",null,"Scenario 1",null,"Scenario 2",null,"Scenario 3",null,"Scenario 4",null,"Scenario 5"]
["Population and Employment","Total",null,"Total","% Change","Total","% Change","Total","% Change","Total","% Change","Total","% Change"]
["Total Population",{"$f":"'EPAP Outputs'!D2","v":0},null,{"$f":"'EPAP Outputs'!E2","v":0},{"$f":"IFERROR(IF(D3=0,0,(D3-$B3)/$B3),0)","v":0},{"$f":"'EPAP Outputs'!F2","v":0},{"$f":"IFERROR(IF(F3=0,0,(F3-$B3)/$B3),0)","v":0},{"$f":"'EPAP Outputs'!G2","v":0},{"$f":"IFERROR(IF(H3=0,0,(H3-$B3)/$B3),0)","v":0},{"$f":"'EPAP Outputs'!H2","v":0},{"$f":"IFERROR(IF(J3=0,0,(J3-$B3)/$B3),0)","v":0},{"$f":"'EPAP Outputs'!I2","v":0},{"$f":"IFERROR(IF(L3=0,0,(L3-$B3)/$B3),0)","v":0}]
["Total Households",{"$f":"'EPAP Outputs'!D3","v":0},null,{"$f":"'EPAP Outputs'!E3","v":0},{"$f":"IFERROR(IF(D4=0,0,(D4-$B4)/$B4),0)","v":0},{"$f":"'EPAP Outputs'!F3","v":0},0,{"$f":"'EPAP Outputs'!G3","v":0},{"$f":"IFERROR(IF(H4=0,0,(H4-$B4)/$B4),0)","v":0},{"$f":"'EPAP Outputs'!H3","v":0},{"$f":"IFERROR(IF(J4=0,0,(J4-$B4)/$B4),0)","v":0},{"$f":"'EPAP Outputs'!I3","v":0},{"$f":"IFERROR(IF(L4=0,0,(L4-$B4)/$B4),0)","v":0}]
["Average Household Size",{"$f":"IFERROR(B3/B4,0)","v":0},null,{"$f":"IFERROR(D3/D4,0)","v":0},0,{"$f":"IFERROR(F3/F4,0)","v":0},0,{"$f":"IFERROR(H3/H4,0)","v":0},{"$f":"IFERROR(IF(H5=0,0,(H5-$B5)/$B5),0)","v":0},{"$f":"IFERROR(J3/J4,0)","v":0},{"$f":"IFERROR(IF(J5=0,0,(J5-$B5)/$B5),0)","v":0},{"$f":"IFERROR(L3/L4,0)","v":0},{"$f":"IFERROR(IF(L5=0,0,(L5-$B5)/$B5),0)","v":0}]
["Total Employment",{"$f":"'EPAP Outputs'!D4","v":0},null,{"$f":"'EPAP Outputs'!E4","v":0},{"$f":"IFERROR(IF(D6=0,0,(D6-$B6)/$B6),0)","v":0},{"$f":"'EPAP Outputs'!F4","v":0},{"$f":"IFERROR(IF(F6=0,0,(F6-$B6)/$B6),0)","v":0},{"$f":"'EPAP Outputs'!G4","v":0},0,{"$f":"'EPAP Outputs'!H4","v":0},0,{"$f":"'EPAP Outputs'!I4","v":0},0]
["Total Workers",{"$f":"'EPAP Outputs'!D5","v":0},null,{"$f":"'EPAP Outputs'!E5","v":0},{"$f":"IFERROR(IF(D7=0,0,(D7-$B7)/$B7),0)","v":0},{"$f":"'EPAP Outputs'!F5","v":0},{"$f":"IFERROR(IF(F7=0,0,(F7-$B7)/$B7),0)","v":0},{"$f":"'EPAP Outputs'!G5","v":0},{"$f":"IFERROR(IF(H7=0,0,(H7-$B7)/$B7),0)","v":0},{"$f":"'EPAP Outputs'!H5","v":0},{"$f":"IFERROR(IF(J7=0,0,(J7-$B7)/$B7),0)","v":0},{"$f":"'EPAP Outputs'!I5","v":0},{"$f":"IFERROR(IF(L7=0,0,(L7-$B7)/$B7),0)","v":0}]
["Employment Mix",{"$f":"'EPAP Outputs'!D9","v":0},null,{"$f":"'EPAP Outputs'!E9","v":0},{"$f":"IFERROR(IF(D8=0,0,(D8-$B8)/$B8),0)","v":0},{"$f":"'EPAP Outputs'!F9","v":0},{"$f":"IFERROR(IF(F8=0,0,(F8-$B8)/$B8),0)","v":0},{"$f":"'EPAP Outputs'!G9","v":0},{"$f":"IFERROR(IF(H8=0,0,(H8-$B8)/$B8),0)","v":0},{"$f":"'EPAP Outputs'!H9","v":0},{"$f":"IFERROR(IF(J8=0,0,(J8-$B8)/$B8),0)","v":0},{"$f":"'EPAP Outputs'!I9","v":0},{"$f":"IFERROR(IF(L8=0,0,(L8-$B8)/$B8),0)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Transportation","Total",null,"Total","% Change","Total","% Change","Total","% Change","Total","% Change","Total","% Change"]
["Percent of Population Engaging in Walking for Transportation (Day) ◊",{"$f":"'EPAP Outputs'!D15","v":0},null,{"$f":"'EPAP Outputs'!E15","v":0},{"$f":"IF(D37=0,0,IFERROR((D37-$B37)/$B37,0))","v":0},{"$f":"'EPAP Outputs'!F15","v":0},{"$f":"IF(F37=0,0,IFERROR((F37-$B37)/$B37,0))","v":0},{"$f":"'EPAP Outputs'!G15","v":0},{"$f":"IF(H37=0,0,IFERROR((H37-$B37)/$B37,0))","v":0},{"$f":"'EPAP Outputs'!H15","v":0},{"$f":"IF(J37=0,0,IFERROR((J37-$B37)/$B37,0))","v":0},{"$f":"'EPAP Outputs'!I15","v":0},{"$f":"IF(L37=0,0,IFERROR((L37-$B37)/$B37,0))","v":0}]
["Percent of Population Engaging in Walking for Transportation (Week) ◊",{"$f":"'EPAP Outputs'!D17","v":0},null,{"$f":"'EPAP Outputs'!E17","v":0},{"$f":"IF(D38=0,0,IFERROR((D38-$B38)/$B38,0))","v":0},{"$f":"'EPAP Outputs'!F17","v":0},{"$f":"IF(F38=0,0,IFERROR((F38-$B38)/$B38,0))","v":0},{"$f":"'EPAP Outputs'!G17","v":0},{"$f":"IF(H38=0,0,IFERROR((H38-$B38)/$B38,0))","v":0},{"$f":"'EPAP Outputs'!H17","v":0},{"$f":"IF(J38=0,0,IFERROR((J38-$B38)/$B38,0))","v":0},{"$f":"'EPAP Outputs'!I17","v":0},{"$f":"IF(L38=0,0,IFERROR((L38-$B38)/$B38,0))","v":0}]
["Percent of Population Engaging in Cycling for Transportation (Day) ◊",{"$f":"'EPAP Outputs'!D21","v":0},null,{"$f":"'EPAP Outputs'!E21","v":0},{"$f":"IF(D39=0,0,IFERROR((D39-$B39)/$B39,0))","v":0},{"$f":"'EPAP Outputs'!F21","v":0},{"$f":"IF(F39=0,0,IFERROR((F39-$B39)/$B39,0))","v":0},{"$f":"'EPAP Outputs'!G21","v":0},{"$f":"IF(H39=0,0,IFERROR((H39-$B39)/$B39,0))","v":0},{"$f":"'EPAP Outputs'!H21","v":0},{"$f":"IF(J39=0,0,IFERROR((J39-$B39)/$B39,0))","v":0},{"$f":"'EPAP Outputs'!I21","v":0},{"$f":"IF(L39=0,0,IFERROR((L39-$B39)/$B39,0))","v":0}]
["Percent of Population Engaging in Auto Travel for Transportation (Day) ◊",{"$f":"'EPAP Outputs'!D29","v":0},null,{"$f":"'EPAP Outputs'!E29","v":0},{"$f":"IF(D40=0,0,IFERROR((D40-$B40)/$B40,0))","v":0},{"$f":"'EPAP Outputs'!F29","v":0},{"$f":"IF(F40=0,0,IFERROR((F40-$B40)/$B40,0))","v":0},{"$f":"'EPAP Outputs'!G29","v":0},{"$f":"IF(H40=0,0,IFERROR((H40-$B40)/$B40,0))","v":0},{"$f":"'EPAP Outputs'!H29","v":0},{"$f":"IF(J40=0,0,IFERROR((J40-$B40)/$B40,0))","v":0},{"$f":"'EPAP Outputs'!I29","v":0},{"$f":"IF(L40=0,0,IFERROR((L40-$B40)/$B40,0))","v":0}]
["Cumulative Total Minutes of Walking for Transportation (Day)  ◊",{"$f":"'EPAP Outputs'!D16","v":0},null,{"$f":"'EPAP Outputs'!E16","v":0},{"$f":"IF(D41=0,0,IFERROR((D41-$B41)/$B41,0))","v":0},{"$f":"'EPAP Outputs'!F16","v":0},{"$f":"IF(F41=0,0,IFERROR((F41-$B41)/$B41,0))","v":0},{"$f":"'EPAP Outputs'!G16","v":0},{"$f":"IF(H41=0,0,IFERROR((H41-$B41)/$B41,0))","v":0},{"$f":"'EPAP Outputs'!H16","v":0},{"$f":"IF(J41=0,0,IFERROR((J41-$B41)/$B41,0))","v":0},{"$f":"'EPAP Outputs'!I16","v":0},{"$f":"IF(L41=0,0,IFERROR((L41-$B41)/$B41,0))","v":0}]
["Cumulative Total Minutes of Walking for Transportation (Week)  ◊",{"$f":"'EPAP Outputs'!D18","v":0},null,{"$f":"'EPAP Outputs'!E18","v":0},{"$f":"IF(D42=0,0,IFERROR((D42-$B42)/$B42,0))","v":0},{"$f":"'EPAP Outputs'!F18","v":0},{"$f":"IF(F42=0,0,IFERROR((F42-$B42)/$B42,0))","v":0},{"$f":"'EPAP Outputs'!G18","v":0},{"$f":"IF(H42=0,0,IFERROR((H42-$B42)/$B42,0))","v":0},{"$f":"'EPAP Outputs'!H18","v":0},{"$f":"IF(J42=0,0,IFERROR((J42-$B42)/$B42,0))","v":0},{"$f":"'EPAP Outputs'!I18","v":0},{"$f":"IF(L42=0,0,IFERROR((L42-$B42)/$B42,0))","v":0}]
["Cumulative Total Minutes of Cycling for Transportation (Day)  ◊",{"$f":"'EPAP Outputs'!D23","v":0},null,{"$f":"'EPAP Outputs'!E23","v":0},{"$f":"IF(D43=0,0,IFERROR((D43-$B43)/$B43,0))","v":0},{"$f":"'EPAP Outputs'!F23","v":0},{"$f":"IF(F43=0,0,IFERROR((F43-$B43)/$B43,0))","v":0},{"$f":"'EPAP Outputs'!G23","v":0},{"$f":"IF(H43=0,0,IFERROR((H43-$B43)/$B43,0))","v":0},{"$f":"'EPAP Outputs'!H23","v":0},{"$f":"IF(J43=0,0,IFERROR((J43-$B43)/$B43,0))","v":0},{"$f":"'EPAP Outputs'!I23","v":0},{"$f":"IF(L43=0,0,IFERROR((L43-$B43)/$B43,0))","v":0}]
["Cumulative Total Minutes of Auto Travel for Transportation (Day)  ◊",{"$f":"'EPAP Outputs'!D31","v":0},null,{"$f":"'EPAP Outputs'!E31","v":0},{"$f":"IF(D44=0,0,IFERROR((D44-$B44)/$B44,0))","v":0},{"$f":"'EPAP Outputs'!F31","v":0},{"$f":"IF(F44=0,0,IFERROR((F44-$B44)/$B44,0))","v":0},{"$f":"'EPAP Outputs'!G31","v":0},{"$f":"IF(H44=0,0,IFERROR((H44-$B44)/$B44,0))","v":0},{"$f":"'EPAP Outputs'!H31","v":0},{"$f":"IF(J44=0,0,IFERROR((J44-$B44)/$B44,0))","v":0},{"$f":"'EPAP Outputs'!I31","v":0},{"$f":"IF(L44=0,0,IFERROR((L44-$B44)/$B44,0))","v":0}]
["Minutes of Walking for Transportation per Resident (Per Day)",{"$f":"IFERROR(B41/B3,0)","v":0},null,{"$f":"IFERROR(D41/D3,0)","v":0},{"$f":"IF(D45=0,0,IFERROR((D45-$B45)/$B45,0))","v":0},{"$f":"IFERROR(F41/F3,0)","v":0},{"$f":"IF(F45=0,0,IFERROR((F45-$B45)/$B45,0))","v":0},{"$f":"IFERROR(H41/H3,0)","v":0},{"$f":"IF(H45=0,0,IFERROR((H45-$B45)/$B45,0))","v":0},{"$f":"IFERROR(J41/J3,0)","v":0},{"$f":"IF(J45=0,0,IFERROR((J45-$B45)/$B45,0))","v":0},{"$f":"IFERROR(L41/L3,0)","v":0},{"$f":"IF(L45=0,0,IFERROR((L45-$B45)/$B45,0))","v":0}]
["Minutes of Cycling for Transportation per Resident (Per Day)",{"$f":"IFERROR(B43/B3,0)","v":0},null,{"$f":"IFERROR(D43/D3,0)","v":0},{"$f":"IF(D46=0,0,IFERROR((D46-$B46)/$B46,0))","v":0},{"$f":"IFERROR(F43/F3,0)","v":0},{"$f":"IF(F46=0,0,IFERROR((F46-$B46)/$B46,0))","v":0},{"$f":"IFERROR(H43/H3,0)","v":0},{"$f":"IF(H46=0,0,IFERROR((H46-$B46)/$B46,0))","v":0},{"$f":"IFERROR(J43/J3,0)","v":0},{"$f":"IF(J46=0,0,IFERROR((J46-$B46)/$B46,0))","v":0},{"$f":"IFERROR(L43/L3,0)","v":0},{"$f":"IF(L46=0,0,IFERROR((L46-$B46)/$B46,0))","v":0}]
["Minutes of Auto Travel for Transportation per Resident (Per Day)",{"$f":"IFERROR(B44/B3,0)","v":0},null,{"$f":"IFERROR(D44/D3,0)","v":0},{"$f":"IF(D47=0,0,IFERROR((D47-$B47)/$B47,0))","v":0},{"$f":"IFERROR(F44/F3,0)","v":0},{"$f":"IF(F47=0,0,IFERROR((F47-$B47)/$B47,0))","v":0},{"$f":"IFERROR(H44/H3,0)","v":0},{"$f":"IF(H47=0,0,IFERROR((H47-$B47)/$B47,0))","v":0},{"$f":"IFERROR(J44/J3,0)","v":0},{"$f":"IF(J47=0,0,IFERROR((J47-$B47)/$B47,0))","v":0},{"$f":"IFERROR(L44/L3,0)","v":0},{"$f":"IF(L47=0,0,IFERROR((L47-$B47)/$B47,0))","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Physical Activity","Total",null,"Total","% Change","Total","% Change","Total","% Change","Total","% Change","Total","% Change"]
["Percent of Population Engaging in Walking for Leisure (Week) ◊",{"$f":"'EPAP Outputs'!D19","v":0},null,{"$f":"'EPAP Outputs'!E19","v":0},{"$f":"IF(D117=0,0,IFERROR((D117-$B117)/$B117,0))","v":0},{"$f":"'EPAP Outputs'!F19","v":0},{"$f":"IF(F117=0,0,IFERROR((F117-$B117)/$B117,0))","v":0},{"$f":"'EPAP Outputs'!G19","v":0},{"$f":"IF(H117=0,0,IFERROR((H117-$B117)/$B117,0))","v":0},{"$f":"'EPAP Outputs'!H19","v":0},{"$f":"IF(J117=0,0,IFERROR((J117-$B117)/$B117,0))","v":0},{"$f":"'EPAP Outputs'!I19","v":0},{"$f":"IF(L117=0,0,IFERROR((L117-$B117)/$B117,0))","v":0}]
["Cumulative Total Minutes of Walking for Leisure (Week)  ◊",{"$f":"'EPAP Outputs'!D20","v":0},null,{"$f":"'EPAP Outputs'!E20","v":0},{"$f":"IF(D118=0,0,IFERROR((D118-$B118)/$B118,0))","v":0},{"$f":"'EPAP Outputs'!F20","v":0},{"$f":"IF(F118=0,0,IFERROR((F118-$B118)/$B118,0))","v":0},{"$f":"'EPAP Outputs'!G20","v":0},{"$f":"IF(H118=0,0,IFERROR((H118-$B118)/$B118,0))","v":0},{"$f":"'EPAP Outputs'!H20","v":0},{"$f":"IF(J118=0,0,IFERROR((J118-$B118)/$B118,0))","v":0},{"$f":"'EPAP Outputs'!I20","v":0},{"$f":"IF(L118=0,0,IFERROR((L118-$B118)/$B118,0))","v":0}]
["Minutes of Walking for Leisure per Resident (Per Day)",{"$f":"IFERROR(B118/B3,0)/7","v":0},null,{"$f":"IFERROR(D118/D3,0)/7","v":0},{"$f":"IF(D119=0,0,IFERROR((D119-$B119)/$B119,0))","v":0},{"$f":"IFERROR(F118/F3,0)/7","v":0},{"$f":"IF(F119=0,0,IFERROR((F119-$B119)/$B119,0))","v":0},{"$f":"IFERROR(H118/H3,0)/7","v":0},{"$f":"IF(H119=0,0,IFERROR((H119-$B119)/$B119,0))","v":0},{"$f":"IFERROR(J118/J3,0)/7","v":0},{"$f":"IF(J119=0,0,IFERROR((J119-$B119)/$B119,0))","v":0},{"$f":"IFERROR(L118/L3,0)/7","v":0},{"$f":"IF(L119=0,0,IFERROR((L119-$B119)/$B119,0))","v":0}]
["Percent of Population Engaging in Recreational Activity (Day) ◊",{"$f":"'EPAP Outputs'!D26","v":0},null,{"$f":"'EPAP Outputs'!E26","v":0},{"$f":"IF(D120=0,0,IFERROR((D120-$B120)/$B120,0))","v":0},{"$f":"'EPAP Outputs'!F26","v":0},{"$f":"IF(F120=0,0,IFERROR((F120-$B120)/$B120,0))","v":0},{"$f":"'EPAP Outputs'!G26","v":0},{"$f":"IF(H120=0,0,IFERROR((H120-$B120)/$B120,0))","v":0},{"$f":"'EPAP Outputs'!H26","v":0},{"$f":"IF(J120=0,0,IFERROR((J120-$B120)/$B120,0))","v":0},{"$f":"'EPAP Outputs'!I26","v":0},{"$f":"IF(L120=0,0,IFERROR((L120-$B120)/$B120,0))","v":0}]
["Cumulative Total Minutes of Recreational Activity (Day) ◊",{"$f":"'EPAP Outputs'!D28","v":0},null,{"$f":"'EPAP Outputs'!E28","v":0},{"$f":"IF(D121=0,0,IFERROR((D121-$B121)/$B121,0))","v":0},{"$f":"'EPAP Outputs'!F28","v":0},{"$f":"IF(F121=0,0,IFERROR((F121-$B121)/$B121,0))","v":0},{"$f":"'EPAP Outputs'!G28","v":0},{"$f":"IF(H121=0,0,IFERROR((H121-$B121)/$B121,0))","v":0},{"$f":"'EPAP Outputs'!H28","v":0},{"$f":"IF(J121=0,0,IFERROR((J121-$B121)/$B121,0))","v":0},{"$f":"'EPAP Outputs'!I28","v":0},{"$f":"IF(L121=0,0,IFERROR((L121-$B121)/$B121,0))","v":0}]
["Minutes of Recreational Physical Activity per Resident (Per Day)",{"$f":"IFERROR(B121/B3,0)/7","v":0},null,{"$f":"IFERROR(D121/D3,0)/7","v":0},{"$f":"IF(D122=0,0,IFERROR((D122-$B122)/$B122,0))","v":0},{"$f":"IFERROR(F121/F3,0)/7","v":0},{"$f":"IF(F122=0,0,IFERROR((F122-$B122)/$B122,0))","v":0},{"$f":"IFERROR(H121/H3,0)/7","v":0},{"$f":"IF(H122=0,0,IFERROR((H122-$B122)/$B122,0))","v":0},{"$f":"IFERROR(J121/J3,0)/7","v":0},{"$f":"IF(J122=0,0,IFERROR((J122-$B122)/$B122,0))","v":0},{"$f":"IFERROR(L121/L3,0)/7","v":0},{"$f":"IF(L122=0,0,IFERROR((L122-$B122)/$B122,0))","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Health","Total",null,"Total","% Change","Total","% Change","Total","% Change","Total","% Change","Total","% Change"]
["Average Body Mass Index (BMI) ◊",{"$f":"'EPAP Outputs'!D22","v":0},null,{"$f":"'EPAP Outputs'!E22","v":0},{"$f":"IF(D137=0,0,IFERROR((D137-$B137)/$B137,0))","v":0},{"$f":"'EPAP Outputs'!F22","v":0},{"$f":"IF(F137=0,0,IFERROR((F137-$B137)/$B137,0))","v":0},{"$f":"'EPAP Outputs'!G22","v":0},{"$f":"IF(H137=0,0,IFERROR((H137-$B137)/$B137,0))","v":0},{"$f":"'EPAP Outputs'!H22","v":0},{"$f":"IF(J137=0,0,IFERROR((J137-$B137)/$B137,0))","v":0},{"$f":"'EPAP Outputs'!I22","v":0},{"$f":"IF(L137=0,0,IFERROR((L137-$B137)/$B137,0))","v":0}]
["Percent of Population Classified as Overweight ◊",{"$f":"IFERROR('EPAP Outputs'!D24,0)","v":0},null,{"$f":"IFERROR('EPAP Outputs'!E24,0)","v":0},{"$f":"IF(D138=0,0,IFERROR((D138-$B138)/$B138,0))","v":0},{"$f":"IFERROR('EPAP Outputs'!F24,0)","v":0},{"$f":"IF(F138=0,0,IFERROR((F138-$B138)/$B138,0))","v":0},{"$f":"IFERROR('EPAP Outputs'!G24,0)","v":0},{"$f":"IF(H138=0,0,IFERROR((H138-$B138)/$B138,0))","v":0},{"$f":"IFERROR('EPAP Outputs'!H24,0)","v":0},{"$f":"IF(J138=0,0,IFERROR((J138-$B138)/$B138,0))","v":0},{"$f":"IFERROR('EPAP Outputs'!I24,0)","v":0},{"$f":"IF(L138=0,0,IFERROR((L138-$B138)/$B138,0))","v":0}]
["Percent of Population Classified as Obese ◊",{"$f":"IFERROR('EPAP Outputs'!D25,0)","v":0},null,{"$f":"IFERROR('EPAP Outputs'!E25,0)","v":0},{"$f":"IF(D139=0,0,IFERROR((D139-$B139)/$B139,0))","v":0},{"$f":"IFERROR('EPAP Outputs'!F25,0)","v":0},{"$f":"IF(F139=0,0,IFERROR((F139-$B139)/$B139,0))","v":0},{"$f":"IFERROR('EPAP Outputs'!G25,0)","v":0},{"$f":"IF(H139=0,0,IFERROR((H139-$B139)/$B139,0))","v":0},{"$f":"IFERROR('EPAP Outputs'!H25,0)","v":0},{"$f":"IF(J139=0,0,IFERROR((J139-$B139)/$B139,0))","v":0},{"$f":"IFERROR('EPAP Outputs'!I25,0)","v":0},{"$f":"IF(L139=0,0,IFERROR((L139-$B139)/$B139,0))","v":0}]
["Percent of Population With Poor General Health ◊",{"$f":"IFERROR('EPAP Outputs'!D27,0)","v":0},null,{"$f":"IFERROR('EPAP Outputs'!E27,0)","v":0},{"$f":"IF(D140=0,0,IFERROR((D140-$B140)/$B140,0))","v":0},{"$f":"IFERROR('EPAP Outputs'!F27,0)","v":0},{"$f":"IF(F140=0,0,IFERROR((F140-$B140)/$B140,0))","v":0},{"$f":"IFERROR('EPAP Outputs'!G27,0)","v":0},{"$f":"IF(H140=0,0,IFERROR((H140-$B140)/$B140,0))","v":0},{"$f":"IFERROR('EPAP Outputs'!H27,0)","v":0},{"$f":"IF(J140=0,0,IFERROR((J140-$B140)/$B140,0))","v":0},{"$f":"IFERROR('EPAP Outputs'!I27,0)","v":0},{"$f":"IF(L140=0,0,IFERROR((L140-$B140)/$B140,0))","v":0}]
["Percent of Population Experiencing Psychological Distress ◊",{"$f":"IFERROR('EPAP Outputs'!D30,0)","v":0},null,{"$f":"IFERROR('EPAP Outputs'!E30,0)","v":0},{"$f":"IF(D141=0,0,IFERROR((D141-$B141)/$B141,0))","v":0},{"$f":"IFERROR('EPAP Outputs'!F30,0)","v":0},{"$f":"IF(F141=0,0,IFERROR((F141-$B141)/$B141,0))","v":0},{"$f":"IFERROR('EPAP Outputs'!G30,0)","v":0},{"$f":"IF(H141=0,0,IFERROR((H141-$B141)/$B141,0))","v":0},{"$f":"IFERROR('EPAP Outputs'!H30,0)","v":0},{"$f":"IF(J141=0,0,IFERROR((J141-$B141)/$B141,0))","v":0},{"$f":"IFERROR('EPAP Outputs'!I30,0)","v":0},{"$f":"IF(L141=0,0,IFERROR((L141-$B141)/$B141,0))","v":0}]

{"sheet":"ChangeLog","index":3,"n_rows":23,"n_cols":5,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["Date","Version","ET Version","Tab","Note"]
["2016-07-08","1.0.1",3.4,"Summary","added grpahs"]
["2016-07-20","1.1.0","3.4","Summary, EPAP Outputs","added graphs, removed old variables"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Latest:",{"$f":"INDEX(B2:B22, COUNTA(B2:B22), 1)","v":"1.1.0"}]