{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Quick Start Guide","Project Dashboard","1. Employment Access","2. VulnerableAffordableHousing","3. Development Pressure"],"not_rendered":{"charts":7,"images":5,"macros":0,"external_links":0,"defined_names":33,"comments":1,"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":48,"n_cols":4,"rows_kept":48,"cut":false,"hidden":false,"merged":[[33,1,33,6],[34,1,34,5],[22,1,22,5],[12,1,12,5],[17,1,17,5],[20,1,20,5],[21,1,21,5],[25,1,25,5],[26,1,26,3],[27,1,27,4],[30,1,30,5],[14,1,14,2]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Envision Tomorrow™ Corridor Housing Preservation Index Tool"]
[null,"Version 1.2, Updated 9/15/2016"]
[]
[null,"What is the Corridor Housing Preservation Index? "]
[null,"The Corridor Housing Preservation Index was developed by researchers at the University of Texas at Austin to help cities align goals for social inclusion with compact, transit-oriented development.  The index tracks three separate metrics: employment accessibility via transit, the vulnerability of existing affordable housing to redevelopment, and real estate development activity.  Separately, these metrics provide insight into trends that impact each corridor.  Together, these three factors can help target corridors where affordable housing preservation strategies may have the greatest impact."]
[]
[null,"For a complete user guide, click here."]
[]
[null,"Quick Start Guide"]
[null,"A few quick and easy steps will get you started assessing the housing preservation need in your study corridors."]
[]
[null,"Project Dashboard Tab"]
[null,"- Enter basic project info: base year, location, state"]
[null,"- Enter the names of your corridor study areas.  This table can be expanded if more rows are required."]
[null,"- Revisit this tab once you have completed your analysis for an overview of all three metrics"]
[]
[null,"1. Employment Access Tab"]
[null,"- Calculate employment within your corridor study areas"]
[null,"- Calculate low and medium wage jobs within study areas"]
[null,"- Calculate jobs accessible within a 45 minute transit trip"]
[]
[null,"2. Vulnerable Affordable Housing Tab"]
[null,"- Calculate the number of unprotected affordable units within each corridor study area"]
[]
[null,"3. Development Pressure Tab"]
[null,"- Use the Envision Tomorrow Redevelopment Timing App to calculate the development horizon for multifamily parcels"]
[null,"- Summarize recent annual investment using building permit data"]
[]
[]
[null,null,"TAB Color Definition"]
[null,null,"Input Tab"]
[null,null,"Output Tab"]
[null,null,"Reference Tab"]
[]
[null,null,"CELL Color Definition"]
[null,null,"Input Cell"]
[null,null,"Header Cell"]
[null,null,"Subheader Cell"]
[null,null,"Information cell","[Click for info ◊]"]
[null,null,"Output Cell","[white]"]

{"sheet":"Project Dashboard","index":1,"n_rows":22,"n_cols":9,"rows_kept":22,"cut":false,"hidden":false,"merged":[[20,2,20,4],[20,5,20,7],[20,8,20,10],[21,2,21,4],[21,5,21,7],[21,8,21,10],[18,2,18,4],[18,5,18,7],[18,8,18,10],[19,2,19,4],[19,5,19,7],[19,8,19,10],[16,2,16,4],[16,5,16,7],[16,8,16,10],[17,2,17,4],[17,5,17,7],[17,8,17,10],[14,8,14,10],[14,5,14,7],[14,2,14,4],[15,2,15,4],[15,5,15,7],[15,8,15,10],[12,8,12,10],[12,5,12,7],[12,2,12,4],[13,8,13,10],[13,5,13,7],[13,2,13,4],[10,8,10,10],[10,5,10,7],[10,2,10,4],[11,8,11,10],[11,5,11,7],[11,2,11,4],[0,0,0,13],[6,8,6,10],[6,5,6,7],[6,2,6,4],[7,8,7,10],[7,5,7,7],[7,2,7,4],[8,8,8,10],[8,5,8,7],[8,2,8,4],[9,8,9,10],[9,5,9,7],[9,2,9,4]]}
["Project Dashboard"]
["Project Info"]
["Geography"]
["State"]
["Base Year"]
[]
["Corridor Study Areas","Buildable Acres ◊","Part 1. Transit Access to Low Wage Jobs",null,null,"Part 2. Affordable Housing Vulnerability",null,null,"Part 3. Development Pressure"]
[null,null,{"$f":"'1. Employment Access'!C23","v":"-"},null,null,{"$f":"'2. VulnerableAffordableHousing'!E4","v":"-"},null,null,{"$f":"'3. Development Pressure'!F59","v":"-"}]
[null,null,{"$f":"'1. Employment Access'!C24","v":"-"},null,null,{"$f":"'2. VulnerableAffordableHousing'!E5","v":"-"},null,null,{"$f":"'3. Development Pressure'!F60","v":"-"}]
[null,null,{"$f":"'1. Employment Access'!C25","v":"-"},null,null,{"$f":"'2. VulnerableAffordableHousing'!E6","v":"-"},null,null,{"$f":"'3. Development Pressure'!F61","v":"-"}]
[null,null,{"$f":"'1. Employment Access'!C26","v":"-"},null,null,{"$f":"'2. VulnerableAffordableHousing'!E7","v":"-"},null,null,{"$f":"'3. Development Pressure'!F62","v":"-"}]
[null,null,{"$f":"'1. Employment Access'!C27","v":"-"},null,null,{"$f":"'2. VulnerableAffordableHousing'!E8","v":"-"},null,null,{"$f":"'3. Development Pressure'!F63","v":"-"}]
[null,null,{"$f":"'1. Employment Access'!C28","v":"-"},null,null,{"$f":"'2. VulnerableAffordableHousing'!E9","v":"-"},null,null,{"$f":"'3. Development Pressure'!F64","v":"-"}]
[null,null,{"$f":"'1. Employment Access'!C29","v":"-"},null,null,{"$f":"'2. VulnerableAffordableHousing'!E10","v":"-"},null,null,{"$f":"'3. Development Pressure'!F65","v":"-"}]
[null,null,{"$f":"'1. Employment Access'!C30","v":"-"},null,null,{"$f":"'2. VulnerableAffordableHousing'!E11","v":"-"},null,null,{"$f":"'3. Development Pressure'!F66","v":"-"}]
[null,null,{"$f":"'1. Employment Access'!C31","v":"-"},null,null,{"$f":"'2. VulnerableAffordableHousing'!E12","v":"-"},null,null,{"$f":"'3. Development Pressure'!F67","v":"-"}]
[null,null,{"$f":"'1. Employment Access'!C32","v":"-"},null,null,{"$f":"'2. VulnerableAffordableHousing'!E13","v":"-"},null,null,{"$f":"'3. Development Pressure'!F68","v":"-"}]
[null,null,{"$f":"'1. Employment Access'!C33","v":"-"},null,null,{"$f":"'2. VulnerableAffordableHousing'!E14","v":"-"},null,null,{"$f":"'3. Development Pressure'!F69","v":"-"}]
[null,null,{"$f":"'1. Employment Access'!C34","v":"-"},null,null,{"$f":"'2. VulnerableAffordableHousing'!E15","v":"-"},null,null,{"$f":"'3. Development Pressure'!F70","v":"-"}]
[null,null,{"$f":"'1. Employment Access'!C35","v":"-"},null,null,{"$f":"'2. VulnerableAffordableHousing'!E16","v":"-"},null,null,{"$f":"'3. Development Pressure'!F71","v":"-"}]
[null,null,{"$f":"'1. Employment Access'!C36","v":"-"},null,null,{"$f":"'2. VulnerableAffordableHousing'!E17","v":"-"},null,null,{"$f":"'3. Development Pressure'!F72","v":"-"}]
[null,null,{"$f":"'1. Employment Access'!C37","v":"-"},null,null,{"$f":"'2. VulnerableAffordableHousing'!E18","v":"-"},null,null,{"$f":"'3. Development Pressure'!F73","v":"-"}]

{"sheet":"1. Employment Access","index":2,"n_rows":37,"n_cols":8,"rows_kept":37,"cut":false,"hidden":false,"merged":[[0,0,0,13],[2,0,3,0],[2,7,3,7],[2,1,2,6]]}
["Transit Access to Low Wage Jobs"]
["Part 1a. Transit Access to Low Wage Jobs"]
["Corridor Study Areas","Within Corridor \"Transit Sheds\"",null,null,null,null,null,"Jobs Accessible Within a 45 Minute Transit Trip (Avg. Block Group) ◊"]
[null,"Total Employment ◊","Low Wage Employment (less than $1250/month) ◊","Medium Wage Employment ($1251 - $3333/month) ◊","% Low wage jobs","% medium wage jobs","% low/medium wage jobs"]
[{"$f":"IF('Project Dashboard'!A8=\"\",\"\",'Project Dashboard'!A8)","v":""},null,null,null,{"$f":"IFERROR(C5/$B5,\"-\")","v":"-"},"-",{"$f":"SUM(E5:F5)","v":0}]
[{"$f":"IF('Project Dashboard'!A9=\"\",\"\",'Project Dashboard'!A9)","v":""},null,null,null,"-","-",0]
[{"$f":"IF('Project Dashboard'!A10=\"\",\"\",'Project Dashboard'!A10)","v":""},null,null,null,"-","-",0]
[{"$f":"IF('Project Dashboard'!A11=\"\",\"\",'Project Dashboard'!A11)","v":""},null,null,null,"-","-",0]
[{"$f":"IF('Project Dashboard'!A12=\"\",\"\",'Project Dashboard'!A12)","v":""},null,null,null,"-","-",0]
[{"$f":"IF('Project Dashboard'!A13=\"\",\"\",'Project Dashboard'!A13)","v":""},null,null,null,"-","-",0]
[{"$f":"IF('Project Dashboard'!A14=\"\",\"\",'Project Dashboard'!A14)","v":""},null,null,null,"-","-",0]
[{"$f":"IF('Project Dashboard'!A15=\"\",\"\",'Project Dashboard'!A15)","v":""},null,null,null,"-","-",0]
[{"$f":"IF('Project Dashboard'!A16=\"\",\"\",'Project Dashboard'!A16)","v":""},null,null,null,{"$f":"IFERROR(C13/$B13,\"-\")","v":"-"},"-",{"$f":"SUM(E13:F13)","v":0}]
[{"$f":"IF('Project Dashboard'!A17=\"\",\"\",'Project Dashboard'!A17)","v":""},null,null,null,"-","-",0]
[{"$f":"IF('Project Dashboard'!A18=\"\",\"\",'Project Dashboard'!A18)","v":""},null,null,null,"-","-",0]
[{"$f":"IF('Project Dashboard'!A19=\"\",\"\",'Project Dashboard'!A19)","v":""},null,null,null,"-","-",0]
[{"$f":"IF('Project Dashboard'!A20=\"\",\"\",'Project Dashboard'!A20)","v":""},null,null,null,"-","-",0]
[{"$f":"IF('Project Dashboard'!A21=\"\",\"\",'Project Dashboard'!A21)","v":""},null,null,null,"-","-",0]
[{"$f":"IF('Project Dashboard'!A22=\"\",\"\",'Project Dashboard'!A22)","v":""},null,null,null,"-","-",0]
[]
["Part 1b. Transit Access to Low Wage Jobs Index"]
["Corridor Study Areas","Part 3 Index","Part 3 Index Reclassified"]
[{"$f":"IF('Project Dashboard'!A8=\"\",\"\",'Project Dashboard'!A8)","v":""},{"$f":"H5*G5","v":0},{"$f":"IFERROR((B23/MAX($B$23:$B$37))*10,\"-\")","v":"-"}]
[{"$f":"IF('Project Dashboard'!A9=\"\",\"\",'Project Dashboard'!A9)","v":""},{"$f":"H6*G6","v":0},"-"]
[{"$f":"IF('Project Dashboard'!A10=\"\",\"\",'Project Dashboard'!A10)","v":""},0,"-"]
[{"$f":"IF('Project Dashboard'!A11=\"\",\"\",'Project Dashboard'!A11)","v":""},0,"-"]
[{"$f":"IF('Project Dashboard'!A12=\"\",\"\",'Project Dashboard'!A12)","v":""},0,"-"]
[{"$f":"IF('Project Dashboard'!A13=\"\",\"\",'Project Dashboard'!A13)","v":""},0,"-"]
[{"$f":"IF('Project Dashboard'!A14=\"\",\"\",'Project Dashboard'!A14)","v":""},0,"-"]
[{"$f":"IF('Project Dashboard'!A15=\"\",\"\",'Project Dashboard'!A15)","v":""},0,"-"]
[{"$f":"IF('Project Dashboard'!A16=\"\",\"\",'Project Dashboard'!A16)","v":""},0,"-"]
[{"$f":"IF('Project Dashboard'!A17=\"\",\"\",'Project Dashboard'!A17)","v":""},0,"-"]
[{"$f":"IF('Project Dashboard'!A18=\"\",\"\",'Project Dashboard'!A18)","v":""},0,"-"]
[{"$f":"IF('Project Dashboard'!A19=\"\",\"\",'Project Dashboard'!A19)","v":""},0,"-"]
[{"$f":"IF('Project Dashboard'!A20=\"\",\"\",'Project Dashboard'!A20)","v":""},0,"-"]
[{"$f":"IF('Project Dashboard'!A21=\"\",\"\",'Project Dashboard'!A21)","v":""},0,"-"]
[{"$f":"IF('Project Dashboard'!A22=\"\",\"\",'Project Dashboard'!A22)","v":""},0,"-"]

{"sheet":"2. VulnerableAffordableHousing","index":3,"n_rows":18,"n_cols":5,"rows_kept":18,"cut":false,"hidden":false,"merged":[[0,0,0,13]]}
["Affordable Housing Vulnerability"]
["Part 2. Rental Units Vulnerable to Redevelopment"]
["Corridor Study Areas","Vulnerable (Unprotected) Rental Units ◊","Buildable Area (Acres) ◊","Part 2 Index","Part 2 Index Reclassified"]
[{"$f":"IF('Project Dashboard'!A8=\"\",\"\",'Project Dashboard'!A8)","v":""},null,{"$f":"'Project Dashboard'!B8","v":0},{"$f":"IFERROR(B4/C4,\"-\")","v":"-"},{"$f":"IFERROR((D4/MAX($D$4:$D$18))*10,\"-\")","v":"-"}]
[{"$f":"IF('Project Dashboard'!A9=\"\",\"\",'Project Dashboard'!A9)","v":""},null,{"$f":"'Project Dashboard'!B9","v":0},{"$f":"IFERROR(B5/C5,\"-\")","v":"-"},{"$f":"IFERROR((D5/MAX($D$4:$D$18))*10,\"-\")","v":"-"}]
[{"$f":"IF('Project Dashboard'!A10=\"\",\"\",'Project Dashboard'!A10)","v":""},null,{"$f":"'Project Dashboard'!B10","v":0},"-","-"]
[{"$f":"IF('Project Dashboard'!A11=\"\",\"\",'Project Dashboard'!A11)","v":""},null,{"$f":"'Project Dashboard'!B11","v":0},"-","-"]
[{"$f":"IF('Project Dashboard'!A12=\"\",\"\",'Project Dashboard'!A12)","v":""},null,{"$f":"'Project Dashboard'!B12","v":0},"-","-"]
[{"$f":"IF('Project Dashboard'!A13=\"\",\"\",'Project Dashboard'!A13)","v":""},null,{"$f":"'Project Dashboard'!B13","v":0},"-","-"]
[{"$f":"IF('Project Dashboard'!A14=\"\",\"\",'Project Dashboard'!A14)","v":""},null,{"$f":"'Project Dashboard'!B14","v":0},"-","-"]
[{"$f":"IF('Project Dashboard'!A15=\"\",\"\",'Project Dashboard'!A15)","v":""},null,{"$f":"'Project Dashboard'!B15","v":0},"-","-"]
[{"$f":"IF('Project Dashboard'!A16=\"\",\"\",'Project Dashboard'!A16)","v":""},null,{"$f":"'Project Dashboard'!B16","v":0},"-","-"]
[{"$f":"IF('Project Dashboard'!A17=\"\",\"\",'Project Dashboard'!A17)","v":""},null,{"$f":"'Project Dashboard'!B17","v":0},"-","-"]
[{"$f":"IF('Project Dashboard'!A18=\"\",\"\",'Project Dashboard'!A18)","v":""},null,{"$f":"'Project Dashboard'!B18","v":0},"-","-"]
[{"$f":"IF('Project Dashboard'!A19=\"\",\"\",'Project Dashboard'!A19)","v":""},null,{"$f":"'Project Dashboard'!B19","v":0},"-","-"]
[{"$f":"IF('Project Dashboard'!A20=\"\",\"\",'Project Dashboard'!A20)","v":""},null,{"$f":"'Project Dashboard'!B20","v":0},"-","-"]
[{"$f":"IF('Project Dashboard'!A21=\"\",\"\",'Project Dashboard'!A21)","v":""},null,{"$f":"'Project Dashboard'!B21","v":0},"-","-"]
[{"$f":"IF('Project Dashboard'!A22=\"\",\"\",'Project Dashboard'!A22)","v":""},null,{"$f":"'Project Dashboard'!B22","v":0},"-","-"]

{"sheet":"3. Development Pressure","index":4,"n_rows":73,"n_cols":14,"rows_kept":73,"cut":false,"hidden":false,"merged":[[0,0,0,13],[56,0,57,0],[56,3,57,3],[56,4,57,4],[56,5,57,5],[2,0,3,0],[2,2,2,3],[2,4,2,5],[2,6,2,7],[2,8,2,9],[2,10,2,11],[2,12,2,13]]}
["Development Pressure"]
["Part 3A. Percentage of Multifamily Parcels Expected to be Redeveloped in the Next Five Years -- ET Redevelopment Candidate App"]
["Corridor Study Areas","MF Acreage","Ready Now",null,"Next 5 years",null,"5-10 years",null,"10+ years",null,"Zero values or other errors",null,"Total in Next 5 Years"]
[null,"Total","Acreage","Percent","Acreage","Percent","Acreage","Percent","Acreage","Percent","Acreage","Percent","Acreage","Percent"]
[{"$f":"IF('Project Dashboard'!A8=\"\",\"\",'Project Dashboard'!A8)","v":""},null,null,{"$f":"IFERROR(C5/$B5,\"-\")","v":"-"},null,{"$f":"IFERROR(E5/$B5,\"-\")","v":"-"},null,{"$f":"IFERROR(G5/$B5,\"-\")","v":"-"},null,{"$f":"IFERROR(I5/$B5,\"-\")","v":"-"},null,{"$f":"IFERROR(K5/$B5,\"-\")","v":"-"},{"$f":"IFERROR(C5+E5,\"-\")","v":0},{"$f":"IFERROR(M5/$B5,\"-\")","v":"-"}]
[{"$f":"IF('Project Dashboard'!A9=\"\",\"\",'Project Dashboard'!A9)","v":""},null,null,"-",null,"-",null,"-",null,"-",null,"-",{"$f":"IFERROR(C6+E6,\"-\")","v":0},"-"]
[{"$f":"IF('Project Dashboard'!A10=\"\",\"\",'Project Dashboard'!A10)","v":""},null,null,"-",null,"-",null,"-",null,"-",null,"-",0,"-"]
[{"$f":"IF('Project Dashboard'!A11=\"\",\"\",'Project Dashboard'!A11)","v":""},null,null,"-",null,"-",null,"-",null,"-",null,"-",0,"-"]
[{"$f":"IF('Project Dashboard'!A12=\"\",\"\",'Project Dashboard'!A12)","v":""},null,null,"-",null,"-",null,"-",null,"-",null,"-",0,"-"]
[{"$f":"IF('Project Dashboard'!A13=\"\",\"\",'Project Dashboard'!A13)","v":""},null,null,"-",null,"-",null,"-",null,"-",null,"-",0,"-"]
[{"$f":"IF('Project Dashboard'!A14=\"\",\"\",'Project Dashboard'!A14)","v":""},null,null,"-",null,"-",null,"-",null,"-",null,"-",0,"-"]
[{"$f":"IF('Project Dashboard'!A15=\"\",\"\",'Project Dashboard'!A15)","v":""},null,null,"-",null,"-",null,"-",null,"-",null,"-",0,"-"]
[{"$f":"IF('Project Dashboard'!A16=\"\",\"\",'Project Dashboard'!A16)","v":""},null,null,"-",null,"-",null,"-",null,"-",null,"-",0,"-"]
[{"$f":"IF('Project Dashboard'!A17=\"\",\"\",'Project Dashboard'!A17)","v":""},null,null,"-",null,"-",null,"-",null,"-",null,"-",0,"-"]
[{"$f":"IF('Project Dashboard'!A18=\"\",\"\",'Project Dashboard'!A18)","v":""},null,null,"-",null,"-",null,"-",null,"-",null,"-",0,"-"]
[{"$f":"IF('Project Dashboard'!A19=\"\",\"\",'Project Dashboard'!A19)","v":""},null,null,"-",null,"-",null,"-",null,"-",null,"-",0,"-"]
[{"$f":"IF('Project Dashboard'!A20=\"\",\"\",'Project Dashboard'!A20)","v":""},null,null,"-",null,"-",null,"-",null,"-",null,"-",0,"-"]
[{"$f":"IF('Project Dashboard'!A21=\"\",\"\",'Project Dashboard'!A21)","v":""},null,null,"-",null,"-",null,"-",null,"-",null,"-",0,"-"]
[{"$f":"IF('Project Dashboard'!A22=\"\",\"\",'Project Dashboard'!A22)","v":""},null,null,"-",null,"-",null,"-",null,"-",null,"-",0,"-"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Part 3B. Total Permit Value by Year - 5 Year Aggregate"]
["Corridor Study Areas",2011,2012,2013,2014,2015,"Total"]
[{"$f":"IF('Project Dashboard'!A8=\"\",\"\",'Project Dashboard'!A8)","v":""},null,null,null,null,null,{"$f":"SUM(B40:F40)","v":0}]
[{"$f":"IF('Project Dashboard'!A9=\"\",\"\",'Project Dashboard'!A9)","v":""},null,null,null,null,null,{"$f":"SUM(B41:F41)","v":0}]
[{"$f":"IF('Project Dashboard'!A10=\"\",\"\",'Project Dashboard'!A10)","v":""},null,null,null,null,null,0]
[{"$f":"IF('Project Dashboard'!A11=\"\",\"\",'Project Dashboard'!A11)","v":""},null,null,null,null,null,0]
[{"$f":"IF('Project Dashboard'!A12=\"\",\"\",'Project Dashboard'!A12)","v":""},null,null,null,null,null,0]
[{"$f":"IF('Project Dashboard'!A13=\"\",\"\",'Project Dashboard'!A13)","v":""},null,null,null,null,null,0]
[{"$f":"IF('Project Dashboard'!A14=\"\",\"\",'Project Dashboard'!A14)","v":""},null,null,null,null,null,0]
[{"$f":"IF('Project Dashboard'!A15=\"\",\"\",'Project Dashboard'!A15)","v":""},null,null,null,null,null,0]
[{"$f":"IF('Project Dashboard'!A16=\"\",\"\",'Project Dashboard'!A16)","v":""},null,null,null,null,null,0]
[{"$f":"IF('Project Dashboard'!A17=\"\",\"\",'Project Dashboard'!A17)","v":""},null,null,null,null,null,0]
[{"$f":"IF('Project Dashboard'!A18=\"\",\"\",'Project Dashboard'!A18)","v":""},null,null,null,null,null,0]
[{"$f":"IF('Project Dashboard'!A19=\"\",\"\",'Project Dashboard'!A19)","v":""},null,null,null,null,null,0]
[{"$f":"IF('Project Dashboard'!A20=\"\",\"\",'Project Dashboard'!A20)","v":""},null,null,null,null,null,0]
[{"$f":"IF('Project Dashboard'!A21=\"\",\"\",'Project Dashboard'!A21)","v":""},null,null,null,null,null,0]
[{"$f":"IF('Project Dashboard'!A22=\"\",\"\",'Project Dashboard'!A22)","v":""},null,null,null,null,null,0]
[]
["Part 3C: Development Pressure Index"]
["Corridor Study Areas","Part 1A","Part 1B","Buildable Acres","Part 1 Index","Part 1 Index Reclassified"]
[null,"% Redev Parcels: 0-5 Years","Aggregate Permit Value"]
[{"$f":"IF('Project Dashboard'!A8=\"\",\"\",'Project Dashboard'!A8)","v":""},{"$f":"N5","v":"-"},{"$f":"G40","v":0},{"$f":"'Project Dashboard'!B8","v":0},{"$f":"IFERROR(B59*C59/D59,\"-\")","v":"-"},{"$f":"IFERROR((E59/MAX($E$59:$E$73))*10,\"-\")","v":"-"}]
[{"$f":"IF('Project Dashboard'!A9=\"\",\"\",'Project Dashboard'!A9)","v":""},{"$f":"N6","v":"-"},{"$f":"G41","v":0},{"$f":"'Project Dashboard'!B9","v":0},{"$f":"IFERROR(B60*C60/D60,\"-\")","v":"-"},{"$f":"IFERROR((E60/MAX($E$59:$E$73))*10,\"-\")","v":"-"}]
[{"$f":"IF('Project Dashboard'!A10=\"\",\"\",'Project Dashboard'!A10)","v":""},"-",0,{"$f":"'Project Dashboard'!B10","v":0},"-","-"]
[{"$f":"IF('Project Dashboard'!A11=\"\",\"\",'Project Dashboard'!A11)","v":""},"-",0,{"$f":"'Project Dashboard'!B11","v":0},"-","-"]
[{"$f":"IF('Project Dashboard'!A12=\"\",\"\",'Project Dashboard'!A12)","v":""},"-",0,{"$f":"'Project Dashboard'!B12","v":0},"-","-"]
[{"$f":"IF('Project Dashboard'!A13=\"\",\"\",'Project Dashboard'!A13)","v":""},"-",0,{"$f":"'Project Dashboard'!B13","v":0},"-","-"]
[{"$f":"IF('Project Dashboard'!A14=\"\",\"\",'Project Dashboard'!A14)","v":""},"-",0,{"$f":"'Project Dashboard'!B14","v":0},"-","-"]
[{"$f":"IF('Project Dashboard'!A15=\"\",\"\",'Project Dashboard'!A15)","v":""},"-",0,{"$f":"'Project Dashboard'!B15","v":0},"-","-"]
[{"$f":"IF('Project Dashboard'!A16=\"\",\"\",'Project Dashboard'!A16)","v":""},"-",0,{"$f":"'Project Dashboard'!B16","v":0},"-","-"]
[{"$f":"IF('Project Dashboard'!A17=\"\",\"\",'Project Dashboard'!A17)","v":""},"-",0,{"$f":"'Project Dashboard'!B17","v":0},"-","-"]
[{"$f":"IF('Project Dashboard'!A18=\"\",\"\",'Project Dashboard'!A18)","v":""},"-",0,{"$f":"'Project Dashboard'!B18","v":0},"-","-"]
[{"$f":"IF('Project Dashboard'!A19=\"\",\"\",'Project Dashboard'!A19)","v":""},"-",0,{"$f":"'Project Dashboard'!B19","v":0},"-","-"]
[{"$f":"IF('Project Dashboard'!A20=\"\",\"\",'Project Dashboard'!A20)","v":""},"-",0,{"$f":"'Project Dashboard'!B20","v":0},"-","-"]
[{"$f":"IF('Project Dashboard'!A21=\"\",\"\",'Project Dashboard'!A21)","v":""},"-",0,{"$f":"'Project Dashboard'!B21","v":0},"-","-"]
[{"$f":"IF('Project Dashboard'!A22=\"\",\"\",'Project Dashboard'!A22)","v":""},"-",0,{"$f":"'Project Dashboard'!B22","v":0},"-","-"]