{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Businesses","Reference Lists (DO NOT EDIT)","Housing","Building Improvements","Property Changes","Public Improvements","General Reporting"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Businesses","index":0,"n_rows":36,"n_cols":8,"rows_kept":36,"cut":false,"hidden":false,"merged":[[30,0,30,6]]}
["Business Name","Address","Owner Contact Information","Number of Employees","Business Type","Business Ownership","Business Status"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Totals"]
["Acquired Businesses","Expanded Businesses","New Businesses","Relocated Into District","Relocated Within District","Employees","COBID Businesses"]
[{"$f":"'Reference Lists (DO NOT EDIT)'!A28","v":0},{"$f":"'Reference Lists (DO NOT EDIT)'!B28","v":0},{"$f":"'Reference Lists (DO NOT EDIT)'!C28","v":0},{"$f":"'Reference Lists (DO NOT EDIT)'!D28","v":0},{"$f":"'Reference Lists (DO NOT EDIT)'!E28","v":0},{"$f":"'Reference Lists (DO NOT EDIT)'!F28","v":0},{"$f":"'Reference Lists (DO NOT EDIT)'!G28","v":0}]
["Closed Businesses","Lost Employees"]
[{"$f":"'Reference Lists (DO NOT EDIT)'!A29","v":0},{"$f":"'Reference Lists (DO NOT EDIT)'!B29","v":0},null,"Acquired","Expanded","New","Into","Within"]
[null,null,null,{"$f":"SUMIF(Table1[Business Status], \"Acquired\", Table1[Number of Employees])","v":0},{"$f":"SUMIF(Table1[Business Status], \"Expanded\", Table1[Number of Employees])","v":0},{"$f":"SUMIF(Table1[Business Status], \"New\", Table1[Number of Employees])","v":0},{"$f":"SUMIF(Table1[Business Status], \"Relocated Into District\", Table1[Number of Employees])","v":0},{"$f":"SUMIF(Table1[Business Status], \"Relocated Within District\", Table1[Number of Employees])","v":0}]

{"sheet":"Reference Lists (DO NOT EDIT)","index":1,"n_rows":29,"n_cols":9,"rows_kept":29,"cut":false,"hidden":true,"merged":[]}
["Acquired","Retail ","New","Condo/Townhouse","Women Owned",null,"Awning",null,"Special Assessment"]
["Closed","Restaurant","Closed","Detatched","Minority Owned",null,"Façade",null,"Federal Preservation Tax Credit"]
["Expanded","Service",null,"Apartments ","Veteran Owned",null,"Interior: Commercial",null,"Urban Renewal Funds"]
["New","Religious",null,"Affordable Housing",null,null,"Interior: Residential",null,"Other City Funds"]
["Relocated Into District","Professional",null,"Loft",null,null,"Other Exterior",null,"Grants"]
["Relocated Within District ","Government",null,null,null,null,"Upper Floor",null,"None"]
[null,"Nonprofit"]
[null,"Industrial"]
[null,"Other"]
[]
[null,null,null,null,null,"1-2"]
[null,null,null,null,null,"3-4"]
[null,null,null,null,null,"5+"]
["New Building"]
["Building Addition"]
["Loss: Wildfire "]
["Loss: Other Natural Disaster"]
["Loss: Arson/Crime"]
["Demolition: Safety Concern"]
["Demolition: Other"]
["Other"]
[]
[]
[]
[]
[]
["Formulas for Businesses Sheet:"]
[{"$f":"COUNTIF(Table1[Business Status], \"Acquired\")","v":0},{"$f":"COUNTIF(Table1[Business Status], \"Expanded\")","v":0},{"$f":"COUNTIF(Table1[Business Status], \"New\")","v":0},{"$f":"COUNTIF(Table1[Business Status], \"Relocated Into District\")","v":0},{"$f":"COUNTIF(Table1[Business Status], \"Relocated Within District\")","v":0},{"$f":"SUM(Businesses!D36:H36)","v":0},{"$f":"COUNTIF(Table1[Business Ownership], \"<>\"&\"\")","v":0}]
[{"$f":"COUNTIF(Table1[Business Status], \"Closed\")","v":0},{"$f":"SUMIF(Table1[Business Status], \"Closed\", Table1[Number of Employees])","v":0}]

{"sheet":"Housing","index":2,"n_rows":35,"n_cols":5,"rows_kept":35,"cut":false,"hidden":false,"merged":[[30,0,30,4]]}
["Housing Unit Name","Housing Address","Unit Type","Housing Status","Number of Units"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Totals"]
["New Housing (1-2)","New Housing (3-4)","New Housing (5+)"]
[{"$f":"COUNTIFS(Table2[Housing Status], \"New\", Table2[Number of Units], \"1-2\")","v":0},{"$f":"COUNTIFS(Table2[Housing Status], \"New\", Table2[Number of Units], \"3-4\")","v":0},{"$f":"COUNTIFS(Table2[Housing Status], \"New\", Table2[Number of Units], \"5+\")","v":0}]
["Closed Housing (1-2)","Closed Housing (3-4)","Closed Housing (5+)"]
[{"$f":"COUNTIFS(Table2[Housing Status], \"Closed\", Table2[Number of Units], \"1-2\")","v":0},{"$f":"COUNTIFS(Table2[Housing Status], \"Closed\", Table2[Number of Units], \"3-4\")","v":0},{"$f":"COUNTIFS(Table2[Housing Status], \"Closed\", Table2[Number of Units], \"5+\")","v":0}]

{"sheet":"Building Improvements","index":3,"n_rows":33,"n_cols":4,"rows_kept":33,"cut":false,"hidden":false,"merged":[[30,0,30,3]]}
["Property Address","Scope of Work","Incentives Used","Amount Invested"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Totals"]
["Amount Invested"]
[{"$f":"SUM(Table3[Amount Invested])","v":0}]

{"sheet":"Property Changes","index":4,"n_rows":33,"n_cols":3,"rows_kept":33,"cut":false,"hidden":false,"merged":[[30,0,30,2]]}
["Property Address","Type of Change","Cost of Change"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Totals"]
["Cost of Property Changes"]
[{"$f":"SUM(Table4[Cost of Change])","v":0}]

{"sheet":"Public Improvements","index":5,"n_rows":23,"n_cols":3,"rows_kept":23,"cut":false,"hidden":false,"merged":[[20,0,20,2]]}
["Public Project Description","Public Entity Completing Project","Amount Invested"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Totals"]
["Public Investment "]
[{"$f":"SUM(Table5[Amount Invested])","v":0}]

{"sheet":"General Reporting","index":6,"n_rows":23,"n_cols":1,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["General Reporting Information"]
[]
["Volunteer Hours"]
[]
[]
["Program Commentary"]
["Describe any critical issues, problems, and/or successes during this reporting period. If applicable, provide a list of goals and any challenges anticipated in the future."]
[]
[]
["Outreach Committee Activity"]
["Include any activities recently completed by the committee as well as other information the committee would like to share."]
[]
[]
["Promotion Committee Activity"]
["Include any activities recently completed by the committee as well as other information the committee would like to share."]
[]
[]
["Design Committee Activity"]
["Include any activities recently completed by the committee as well as other information the committee would like to share."]
[]
[]
["Economic Vitality Committee Activity"]
["Include any activities recently completed by the committee as well as other information the committee would like to share."]