{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["USR Instructions v1-1-15","USR Reference Sheet","USR Pg 1 (1-30)","USR Pg 2 (31-60)","USR Pg 3 (61-90) ","USR Pg 4 (91-120)","USR Pg 5 (121-150)","USR Pg 6 (151-180)","USR Pg 7 (181-210)","USR Pg 8 (211-240)","USR Pg 9 (241-270)","USR Pg 10 (271-300)","USR Pg 11 (301-330) ","USR Pg 12 (331-360)"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":38,"comments":12,"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":"USR Instructions v1-1-15","index":0,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,0,1,3],[3,0,3,3],[4,3,5,3]]}
[]
["                           Unit Status Report Instructions"]
[]
["Please complete this form in its entirety for all Sacramento Housing and Redevelopment Agency (\"SHRA\" or \"Agency\") assisted units (\"Unit” or “Units\") in the property, including vacant Agency assisted units. A separate Unit Status Report (“USR\") must be completed for each property. Please do not list the management staff and exempt unit(s). Please make certain the household (HH) gross annual income is consistent with the TIC/ICC/HCS (do not round-up to the nearest dollar). Funding Sources: Please only indicate one (1) funding source per column, (example: If half of the units are HOME and the other half Bond, then only use the first column to indicate HOME and second column indicating Bond)\n\nFor your assistance, please note the USR Reference and USR Sample sheets.  \nTo view cell comments, place the mouse cursor over a cell with a comment indicator.\n\nPlease list Units in ascending order. All fields are required for occupied SHRA Units. For all vacant SHRA Units - Do not complete the following fields with an asterisk (*) symbol:"]
["Move-In Date*","Race/Ethnicity*","HH Type*","Source(s) of Income*"]
["HH Gross Annual Income*","HH Size*","100% AMI*"]
[]
["SUBMITTING THE USR TO THE AGENCY:"]
["Prior to emailing the USR to the Agency, please make certain you have formatted "]
["the report in the following manner:"]
["  1) Delete the following Worksheets: Instructions, USR Reference Sheet, "]
["      USR Sample Sheet and any USR Pg # (#-#) sheets that do not list Agency "]
["      assisted units in the Property; and"]
["   2) Save the USR file type as Microsoft Excel Workbook 2003 or 2010(.xls); thank you."]

{"sheet":"USR Reference Sheet","index":1,"n_rows":43,"n_cols":5,"rows_kept":43,"cut":false,"hidden":false,"merged":[[42,0,42,1],[22,3,22,4],[1,0,1,4],[3,3,3,4],[3,0,3,1],[16,0,16,1],[23,0,24,1],[25,0,25,1],[11,0,11,1],[39,0,39,1],[34,3,34,4]]}
[]
["                   Unit Status Report Reference Sheet"]
[]
["Race/Ethnicity Codes*",null,null,"Source(s) of Income Codes*"]
["AIAN","American Indian/Alaska Native",null,"PA","Public Assitance( TANF, CALWorks, CALFresh, GA, Etc)"]
["AS","Asian",null,"AS","Asset(s)"]
["BA","Black/African American",null,"CS","Child Support "]
["HWOPI","Hawaiian/Other Pacific Islander",null,"EMP","Employment"]
["WHT","White",null,"NIC","No Income Certification"]
["OTH","Other",null,"ONI","Other Non-wage Income"]
[null,null,null,"OPA","Other  Public Assistance "]
["Smoking Codes*",null,null,"PR","Pension/Retirement"]
["Y","Yes",null,"RG","Recurring Gift"]
["N","No",null,"SDI","State Disability Insurance"]
[null,null,null,"SELF","Self-Employment"]
[null,null,null,"SFA","Student Financial Assistance"]
["HH Type - Household Type Codes*",null,null,"SS","Social Security Benefits"]
["ELD","Elderly",null,"SSI","Supplemental  Security Income "]
["OTH","Other",null,"UB","Unemployment Benefits"]
["SNE","Single/Non-Elderly",null,"VA","Veterans Benefits"]
["SP","Single Parent"]
["TP","Two Parents"]
[null,null,null,"SHRA Funding Program(s) Codes"]
["Household (HH) Size and \n100% Annual Median Income (AMI)*",null,null,"BOND","Bond"]
[null,null,null,"CDBG","Community Development Block Grant "]
["Note: Select 100% AMI for occupied units ",null,null,"CII","City Inclusionary"]
[1,58500,null,"COI","County Inclusionary"]
[2,66900,null,"DRL","Deferred Rehabilitation Loan"]
[3,75250,null,"HOME","HOME Investment Partnership"]
[4,83600,null,"HTF","Housing Trust Fund"]
[5,90300,null,"MHSA","Mental Health Services Act"]
[6,97000,null,"NSP","Neighborhood Stabilization Program"]
[7,103650,null,"TI","Tax Increment"]
[8,110350]
[9,117050,null,"SHRA Unit Mix Abbreviations"]
[10,123750,null,"EL","Extremely Low"]
[11,130450,null,"VL","Very Low"]
[12,{"$f":"B30*1.64","v":137104},null,"LW","Low"]
[null,null,null,"MD","Moderate"]
["Hispanic Code*"]
["Y","Yes"]
["N","No"]
["*Field is not required for Vacant Units"]

{"sheet":"USR Pg 1 (1-30)","index":2,"n_rows":67,"n_cols":29,"rows_kept":67,"cut":false,"hidden":false,"merged":[[32,10,32,11],[32,12,32,15],[31,21,31,26],[29,25,29,27],[29,4,29,6],[29,7,29,11],[29,12,29,15],[29,21,29,23],[31,27,31,28],[30,12,30,15],[32,27,32,28],[32,21,32,26],[30,21,30,23],[30,24,30,28],[32,1,32,6],[32,7,32,9],[33,27,33,28],[35,8,36,8],[35,23,35,28],[33,1,33,6],[33,7,33,9],[33,10,33,11],[33,12,33,15],[33,21,33,26],[35,22,36,22],[35,21,36,21],[35,20,36,20],[35,19,36,19],[35,12,35,15],[30,1,30,3],[30,4,30,6],[30,7,30,9],[30,10,30,11],[31,1,31,3],[31,4,31,6],[31,7,31,9],[31,10,31,11],[13,1,13,3],[26,1,27,28],[28,1,28,3],[28,7,28,11],[28,12,28,15],[28,18,29,19],[28,20,29,20],[28,21,28,23],[28,25,28,27],[29,1,29,3]]}
[null,"Race/Ethnicity Codes",null,null,null,null,null,null,null,null,null,"Source(s) of Income Codes",null,null,null,null,null,null,null,null,"SHRA Funding Program(s) Codes"]
[null,"AIAN",null,"American Indian/Alaska Native",null,null,null,"100% AMI",null,null,null,"PA","Public Assitance( TANF, CALWorks, CALFresh, GA, Etc)",null,null,null,null,null,null,null,"BOND","Bond"]
[null,"AS",null,"Asian",null,null,null,1,63750,null,null,"AS","Asset(s)",null,null,null,null,null,null,null,"CDBG","Community Development Block Grant "]
[null,"BA",null,"Black/African American",null,null,null,2,72900,null,null,"CS","Child Support ",null,null,null,null,"Smoking Codes",null,null,"CII","City Inclusionary"]
[null,"HWOPI",null,"Hawaiian/Other Pacific Islander",null,null,null,3,82000,null,null,"EMP","Employment",null,null,null,null,"Y","Yes",null,"COI","County Inclusionary"]
[null,"WHT",null,"White",null,null,null,4,91100,null,null,"NIC","No Income Certification",null,null,null,null,"N","No",null,"DRL","Deferred Rehabilitation Loan"]
[null,"OTH",null,"Other",null,null,null,5,98400,null,null,"ONI","Other Non-wage Income",null,null,null,null,null,null,null,"HOME","HOME Investment Partnership"]
[null,null,null,null,null,null,null,6,105700,null,null,"OPA","Other  Public Assistance ",null,null,null,null,null,null,null,"HTF","Housing Trust Fund"]
[null,null,null,null,null,null,null,7,112950,null,null,"PR","Pension/Retirement",null,null,null,null,null,null,null,"MHSA","Mental Health Services Act"]
[null,null,null,null,null,null,null,8,120250,null,null,"RG","Recurring Gift",null,null,null,null,null,null,null,"NSP","Neighborhood Stabilization Program"]
[null,null,null,null,null,null,null,9,127550,null,null,"SDI","State Disability Insurance",null,null,null,null,null,null,null,"TI","Tax Increment"]
[null,null,null,null,null,null,null,10,134850,null,null,"SELF","Self-Employment"]
[null,null,null,null,null,null,null,11,142150,null,null,"SFA","Student Financial Assistance",null,null,null,null,null,null,null,"Unit Size",null,null,"Select Utility Allowance"]
[null,"H Type - Household Type Codes",null,null,null,null,null,12,{"$f":"I6*1.64","v":149404},null,null,"SS","Social Security Benefits",null,null,null,null,null,null,null,"SRO",null,null,"1) Apartment/Walk-Up"]
[null,"ELD",null,"Elderly",null,null,null,null,null,null,null,"SSI","Supplemental  Security Income ",null,null,null,null,null,null,null,"Studio",null,null,"2) RH, TH, SD & DX"]
[null,"OTH",null,"Other",null,"Unit Designation Codes",null,null,null,null,null,"UB","Unemployment Benefits",null,null,null,null,null,null,null,1,null,null,"3) CUAC (PROVIDE to SHRA)"]
[null,"SNE",null,"Single/Non-Elderly",null,0.3,null,null,null,null,null,"VA","Veterans Benefits",null,null,null,null,null,null,null,2,null,null,"4) HUSM (PROVIDE to SHRA)"]
[null,"SP",null,"Single Parent",null,0.35,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,null,null,"5) Other"]
[null,"TP",null,"Two Parents",null,0.4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,null,null,null,null,0.45,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[null,"Hispanic Code",null,null,null,0.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Shared"]
[null,"Y","Yes",null,null,0.6]
[null,"N","No",null,null,0.7]
[null,null,null,null,null,0.8]
[null,null,null,null,null,1.1000000000000001]
[null,null,null,null,null,1.2]
[null,"Unit Status Report (USR)\n(Current as of 8-11-2021)"]
[]
[null,"Property Name:",null,null,"Street Address, City & Zip Code:",null,null,"Management Company Name:",null,null,null,null,"Total SHRA Units:",null,null,null,null,null," SHRA \nUnit Mix",null,"Percent\nof Total","Property Total Children age 0-5 ",null,null,null,"Property Total Children age 13-17"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Total other assisted units:",null,null,null,null,null,null,null,null,"Property Total Children age 6-12",null,null,null,"Property Total Children/Minors:",null,null,{"$f":"Y29+Y30+AC29","v":0}]
[null,"Unit Status Report Completed By:",null,null,"Position Title:",null,null,"Property Phone Number:",null,null,"Other Phone Number:",null,"Total market rate units:",null,null,null,null,null,"EL:",null,{"$f":"IF(T31>0,T31/R33,0)","v":0},"Utility Allowance Schedule (1-10)",null,null,"Select Utility Allowance"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Total exempt units",null,null,null,null,null,"VL :",null,{"$f":"IF(T32>0,T32/R33,0)","v":0},"Property Total Housing Choice Voucher (HCV) Tenants:"]
[null,"Email address:",null,null,null,null,null,"Reporting Period From:",null,null,"Reporting Period To:",null,"Property Total units:",null,null,null,null,{"$f":"SUM(R29:R32)","v":0},"LW:",null,{"$f":"IF(T33>0,T33/R33,0)","v":0},"Property Total Wheelchair Accessible units:"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Property Total Vacant units:",null,null,null,null,null,"MD:",null,{"$f":"IF(T34>0,T34/R33,0)","v":0},"Property Total ADA Compliant units "]
[]
[null,"Building","Unit #","HOH Last Name","Move-In","Hispanic","Race","HH","HH Gross  \nAnnual \nIncome*","HH\nSize",1,"% ","Source(s) of Income*",null,null,null,"Smoking","Unit","Unit","Tenant Monthly\nRent","Utility\nAllowance","Rent \nSubsidy","Gross\nMonthly\nRent","SHRA Funding Program(s)"]
[null,"No.","(include vacant SHRA Units)","or indicate \nVacant","Date*","Y / N",null,"Type*",null,"Size*","AMI*","AMI",1,2,3,4,"Y / N ","Size","Designation",null,null,null,null,1,2,3,4,5,6]
[1,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I38>0,I38/K38,\"0\")","v":"0"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(V38>0,T38+V38,T38+U38)","v":0}]
[2,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I39>0,I39/K39,\"0\")","v":"0"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(V39>0,T39+V39,T39+U39)","v":0}]
[3,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[4,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[5,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[6,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[7,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[8,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[9,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[10,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[11,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[12,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[13,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[14,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[15,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[16,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[17,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[18,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[19,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[20,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[21,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[22,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[23,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[24,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[25,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[26,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[27,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[28,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[29,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[30,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]

{"sheet":"USR Pg 2 (31-60)","index":3,"n_rows":67,"n_cols":29,"rows_kept":67,"cut":false,"hidden":false,"merged":[[35,23,35,28],[35,8,36,8],[35,12,35,15],[35,19,36,19],[35,20,36,20],[35,21,36,21],[35,22,36,22],[33,1,33,6],[33,7,33,9],[33,10,33,11],[33,12,33,15],[33,21,33,26],[33,27,33,28],[32,1,32,6],[32,7,32,9],[32,10,32,11],[32,12,32,15],[32,21,32,26],[32,27,32,28],[30,21,30,23],[30,24,30,28],[31,1,31,3],[31,4,31,6],[31,7,31,9],[31,10,31,11],[31,21,31,26],[31,27,31,28],[29,4,29,6],[29,7,29,11],[29,12,29,15],[29,21,29,23],[29,25,29,27],[30,1,30,3],[30,4,30,6],[30,7,30,9],[30,10,30,11],[30,12,30,15],[13,1,13,3],[26,1,27,28],[28,1,28,3],[28,7,28,11],[28,12,28,15],[28,18,29,19],[28,20,29,20],[28,21,28,23],[28,25,28,27],[29,1,29,3]]}
[null,"Race/Ethnicity Codes",null,null,null,null,null,null,null,null,null,"Source(s) of Income Codes",null,null,null,null,null,null,null,null,"SHRA Funding Program(s) Codes"]
[null,"AIAN",null,"American Indian/Alaska Native",null,null,null,"100% AMI",null,null,null,"PA","Public Assitance( TANF, CALWorks, CALFresh, GA, Etc)",null,null,null,null,null,null,null,"BOND","Bond"]
[null,"AS",null,"Asian",null,null,null,1,63750,null,null,"AS","Asset(s)",null,null,null,null,null,null,null,"CDBG","Community Development Block Grant "]
[null,"BA",null,"Black/African American",null,null,null,2,72900,null,null,"CS","Child Support ",null,null,null,null,"Smoking Codes",null,null,"CII","City Inclusionary"]
[null,"HWOPI",null,"Hawaiian/Other Pacific Islander",null,null,null,3,82000,null,null,"EMP","Employment",null,null,null,null,"Y","Yes",null,"COI","County Inclusionary"]
[null,"WHT",null,"White",null,null,null,4,91100,null,null,"NIC","No Income Certification",null,null,null,null,"N","No",null,"DRL","Deferred Rehabilitation Loan"]
[null,"OTH",null,"Other",null,null,null,5,98400,null,null,"ONI","Other Non-wage Income",null,null,null,null,null,null,null,"HOME","HOME Investment Partnership"]
[null,null,null,null,null,null,null,6,105700,null,null,"OPA","Other  Public Assistance ",null,null,null,null,null,null,null,"HTF","Housing Trust Fund"]
[null,null,null,null,null,null,null,7,112950,null,null,"PR","Pension/Retirement",null,null,null,null,null,null,null,"MHSA","Mental Health Services Act"]
[null,null,null,null,null,null,null,8,120250,null,null,"RG","Recurring Gift",null,null,null,null,null,null,null,"NSP","Neighborhood Stabilization Program"]
[null,null,null,null,null,null,null,9,127550,null,null,"SDI","State Disability Insurance",null,null,null,null,null,null,null,"TI","Tax Increment"]
[null,null,null,null,null,null,null,10,134850,null,null,"SELF","Self-Employment"]
[null,null,null,null,null,null,null,11,142150,null,null,"SFA","Student Financial Assistance",null,null,null,null,null,null,null,"Unit Size",null,null,"Select Utility Allowance"]
[null,"H Type - Household Type Codes",null,null,null,null,null,12,{"$f":"I6*1.64","v":149404},null,null,"SS","Social Security Benefits",null,null,null,null,null,null,null,"SRO",null,null,"1) Apartment/Walk-Up"]
[null,"ELD",null,"Elderly",null,null,null,null,null,null,null,"SSI","Supplemental  Security Income ",null,null,null,null,null,null,null,"Studio",null,null,"2) RH, TH, SD & DX"]
[null,"OTH",null,"Other",null,"Unit Designation Codes",null,null,null,null,null,"UB","Unemployment Benefits",null,null,null,null,null,null,null,1,null,null,"3) CUAC (PROVIDE to SHRA)"]
[null,"SNE",null,"Single/Non-Elderly",null,0.3,null,null,null,null,null,"VA","Veterans Benefits",null,null,null,null,null,null,null,2,null,null,"4) HUSM (PROVIDE to SHRA)"]
[null,"SP",null,"Single Parent",null,0.35,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,null,null,"5) Other"]
[null,"TP",null,"Two Parents",null,0.4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,null,null,null,null,0.45,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[null,"Hispanic Code",null,null,null,0.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Shared"]
[null,"Y","Yes",null,null,0.6]
[null,"N","No",null,null,0.7]
[null,null,null,null,null,0.8]
[null,null,null,null,null,1.1000000000000001]
[null,null,null,null,null,1.2]
[null,"Unit Status Report (USR)\n(Current as of 8-11-2021)"]
[]
[null,"Property Name:",null,null,"Street Address, City & Zip Code:",null,null,"Management Company Name:",null,null,null,null,"Total SHRA Units:",null,null,null,null,null," SHRA \nUnit Mix",null,"Percent\nof Total","Property Total Children age 0-5 ",null,null,null,"Property Total Children age 13-17"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Total other assisted units:",null,null,null,null,null,null,null,null,"Property Total Children age 6-12",null,null,null,"Property Total Children/Minors:",null,null,{"$f":"Y29+Y30+AC29","v":0}]
[null,"Unit Status Report Completed By:",null,null,"Position Title:",null,null,"Property Phone Number:",null,null,"Other Phone Number:",null,"Total market rate units:",null,null,null,null,null,"EL:",null,{"$f":"IF(T31>0,T31/R33,0)","v":0},"Utility Allowance Schedule (1-10)",null,null,"Select Utility Allowance"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Total exempt units",null,null,null,null,null,"VL :",null,{"$f":"IF(T32>0,T32/R33,0)","v":0},"Property Total Housing Choice Voucher (HCV) Tenants:"]
[null,"Email address:",null,null,null,null,null,"Reporting Period From:",null,null,"Reporting Period To:",null,"Property Total units:",null,null,null,null,{"$f":"SUM(R29:R32)","v":0},"LW:",null,{"$f":"IF(T33>0,T33/R33,0)","v":0},"Property Total Wheelchair Accessible units:"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Property Total Vacant units:",null,null,null,null,null,"MD:",null,{"$f":"IF(T34>0,T34/R33,0)","v":0},"Property Total ADA Compliant units "]
[]
[null,"Building","Unit #","HOH Last Name","Move-In","Hispanic","Race","HH","HH Gross  \nAnnual \nIncome*","HH\nSize",1,"% ","Source(s) of Income*",null,null,null,"Smoking","Unit","Unit","Tenant Monthly\nRent","Utility\nAllowance","Rent \nSubsidy","Gross\nMonthly\nRent","SHRA Funding Program(s)"]
[null,"No.","(include vacant SHRA Units)","or indicate \nVacant","Date*","Y / N",null,"Type*",null,"Size*","AMI*","AMI",1,2,3,4,"Y / N ","Size","Designation",null,null,null,null,1,2,3,4,5,6]
[1,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I38>0,I38/K38,\"0\")","v":"0"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(V38>0,T38+V38,T38+U38)","v":0}]
[2,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I39>0,I39/K39,\"0\")","v":"0"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(V39>0,T39+V39,T39+U39)","v":0}]
[3,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[4,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[5,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[6,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[7,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[8,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[9,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[10,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[11,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[12,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[13,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[14,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[15,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[16,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[17,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[18,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[19,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[20,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[21,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[22,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[23,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[24,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[25,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[26,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[27,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[28,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[29,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[30,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]

{"sheet":"USR Pg 3 (61-90) ","index":4,"n_rows":67,"n_cols":29,"rows_kept":67,"cut":false,"hidden":false,"merged":[[35,23,35,28],[35,8,36,8],[35,12,35,15],[35,19,36,19],[35,20,36,20],[35,21,36,21],[35,22,36,22],[33,1,33,6],[33,7,33,9],[33,10,33,11],[33,12,33,15],[33,21,33,26],[33,27,33,28],[32,1,32,6],[32,7,32,9],[32,10,32,11],[32,12,32,15],[32,21,32,26],[32,27,32,28],[30,21,30,23],[30,24,30,28],[31,1,31,3],[31,4,31,6],[31,7,31,9],[31,10,31,11],[31,21,31,26],[31,27,31,28],[29,4,29,6],[29,7,29,11],[29,12,29,15],[29,21,29,23],[29,25,29,27],[30,1,30,3],[30,4,30,6],[30,7,30,9],[30,10,30,11],[30,12,30,15],[13,1,13,3],[26,1,27,28],[28,1,28,3],[28,7,28,11],[28,12,28,15],[28,18,29,19],[28,20,29,20],[28,21,28,23],[28,25,28,27],[29,1,29,3]]}
[null,"Race/Ethnicity Codes",null,null,null,null,null,null,null,null,null,"Source(s) of Income Codes",null,null,null,null,null,null,null,null,"SHRA Funding Program(s) Codes"]
[null,"AIAN",null,"American Indian/Alaska Native",null,null,null,"100% AMI",null,null,null,"PA","Public Assitance( TANF, CALWorks, CALFresh, GA, Etc)",null,null,null,null,null,null,null,"BOND","Bond"]
[null,"AS",null,"Asian",null,null,null,1,63750,null,null,"AS","Asset(s)",null,null,null,null,null,null,null,"CDBG","Community Development Block Grant "]
[null,"BA",null,"Black/African American",null,null,null,2,72900,null,null,"CS","Child Support ",null,null,null,null,"Smoking Codes",null,null,"CII","City Inclusionary"]
[null,"HWOPI",null,"Hawaiian/Other Pacific Islander",null,null,null,3,82000,null,null,"EMP","Employment",null,null,null,null,"Y","Yes",null,"COI","County Inclusionary"]
[null,"WHT",null,"White",null,null,null,4,91100,null,null,"NIC","No Income Certification",null,null,null,null,"N","No",null,"DRL","Deferred Rehabilitation Loan"]
[null,"OTH",null,"Other",null,null,null,5,98400,null,null,"ONI","Other Non-wage Income",null,null,null,null,null,null,null,"HOME","HOME Investment Partnership"]
[null,null,null,null,null,null,null,6,105700,null,null,"OPA","Other  Public Assistance ",null,null,null,null,null,null,null,"HTF","Housing Trust Fund"]
[null,null,null,null,null,null,null,7,112950,null,null,"PR","Pension/Retirement",null,null,null,null,null,null,null,"MHSA","Mental Health Services Act"]
[null,null,null,null,null,null,null,8,120250,null,null,"RG","Recurring Gift",null,null,null,null,null,null,null,"NSP","Neighborhood Stabilization Program"]
[null,null,null,null,null,null,null,9,127550,null,null,"SDI","State Disability Insurance",null,null,null,null,null,null,null,"TI","Tax Increment"]
[null,null,null,null,null,null,null,10,134850,null,null,"SELF","Self-Employment"]
[null,null,null,null,null,null,null,11,142150,null,null,"SFA","Student Financial Assistance",null,null,null,null,null,null,null,"Unit Size",null,null,"Select Utility Allowance"]
[null,"H Type - Household Type Codes",null,null,null,null,null,12,{"$f":"I6*1.64","v":149404},null,null,"SS","Social Security Benefits",null,null,null,null,null,null,null,"SRO",null,null,"1) Apartment/Walk-Up"]
[null,"ELD",null,"Elderly",null,null,null,null,null,null,null,"SSI","Supplemental  Security Income ",null,null,null,null,null,null,null,"Studio",null,null,"2) RH, TH, SD & DX"]
[null,"OTH",null,"Other",null,"Unit Designation Codes",null,null,null,null,null,"UB","Unemployment Benefits",null,null,null,null,null,null,null,1,null,null,"3) CUAC (PROVIDE to SHRA)"]
[null,"SNE",null,"Single/Non-Elderly",null,0.3,null,null,null,null,null,"VA","Veterans Benefits",null,null,null,null,null,null,null,2,null,null,"4) HUSM (PROVIDE to SHRA)"]
[null,"SP",null,"Single Parent",null,0.35,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,null,null,"5) Other"]
[null,"TP",null,"Two Parents",null,0.4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,null,null,null,null,0.45,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[null,"Hispanic Code",null,null,null,0.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Shared"]
[null,"Y","Yes",null,null,0.6]
[null,"N","No",null,null,0.7]
[null,null,null,null,null,0.8]
[null,null,null,null,null,1.1000000000000001]
[null,null,null,null,null,1.2]
[null,"Unit Status Report (USR)\n(Current as of 8-11-2021)"]
[]
[null,"Property Name:",null,null,"Street Address, City & Zip Code:",null,null,"Management Company Name:",null,null,null,null,"Total SHRA Units:",null,null,null,null,null," SHRA \nUnit Mix",null,"Percent\nof Total","Property Total Children age 0-5 ",null,null,null,"Property Total Children age 13-17"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Total other assisted units:",null,null,null,null,null,null,null,null,"Property Total Children age 6-12",null,null,null,"Property Total Children/Minors:",null,null,{"$f":"Y29+Y30+AC29","v":0}]
[null,"Unit Status Report Completed By:",null,null,"Position Title:",null,null,"Property Phone Number:",null,null,"Other Phone Number:",null,"Total market rate units:",null,null,null,null,null,"EL:",null,{"$f":"IF(T31>0,T31/R33,0)","v":0},"Utility Allowance Schedule (1-10)",null,null,"Select Utility Allowance"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Total exempt units",null,null,null,null,null,"VL :",null,{"$f":"IF(T32>0,T32/R33,0)","v":0},"Property Total Housing Choice Voucher (HCV) Tenants:"]
[null,"Email address:",null,null,null,null,null,"Reporting Period From:",null,null,"Reporting Period To:",null,"Property Total units:",null,null,null,null,{"$f":"SUM(R29:R32)","v":0},"LW:",null,{"$f":"IF(T33>0,T33/R33,0)","v":0},"Property Total Wheelchair Accessible units:"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Property Total Vacant units:",null,null,null,null,null,"MD:",null,{"$f":"IF(T34>0,T34/R33,0)","v":0},"Property Total ADA Compliant units "]
[]
[null,"Building","Unit #","HOH Last Name","Move-In","Hispanic","Race","HH","HH Gross  \nAnnual \nIncome*","HH\nSize",1,"% ","Source(s) of Income*",null,null,null,"Smoking","Unit","Unit","Tenant Monthly\nRent","Utility\nAllowance","Rent \nSubsidy","Gross\nMonthly\nRent","SHRA Funding Program(s)"]
[null,"No.","(include vacant SHRA Units)","or indicate \nVacant","Date*","Y / N",null,"Type*",null,"Size*","AMI*","AMI",1,2,3,4,"Y / N ","Size","Designation",null,null,null,null,1,2,3,4,5,6]
[1,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I38>0,I38/K38,\"0\")","v":"0"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(V38>0,T38+V38,T38+U38)","v":0}]
[2,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I39>0,I39/K39,\"0\")","v":"0"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(V39>0,T39+V39,T39+U39)","v":0}]
[3,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[4,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[5,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[6,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[7,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[8,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[9,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[10,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[11,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[12,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[13,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[14,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[15,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[16,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[17,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[18,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[19,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[20,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[21,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[22,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[23,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[24,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[25,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[26,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[27,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[28,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[29,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[30,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]

{"sheet":"USR Pg 4 (91-120)","index":5,"n_rows":67,"n_cols":29,"rows_kept":67,"cut":false,"hidden":false,"merged":[[35,23,35,28],[35,8,36,8],[35,12,35,15],[35,19,36,19],[35,20,36,20],[35,21,36,21],[35,22,36,22],[33,1,33,6],[33,7,33,9],[33,10,33,11],[33,12,33,15],[33,21,33,26],[33,27,33,28],[32,1,32,6],[32,7,32,9],[32,10,32,11],[32,12,32,15],[32,21,32,26],[32,27,32,28],[30,21,30,23],[30,24,30,28],[31,1,31,3],[31,4,31,6],[31,7,31,9],[31,10,31,11],[31,21,31,26],[31,27,31,28],[29,4,29,6],[29,7,29,11],[29,12,29,15],[29,21,29,23],[29,25,29,27],[30,1,30,3],[30,4,30,6],[30,7,30,9],[30,10,30,11],[30,12,30,15],[13,1,13,3],[26,1,27,28],[28,1,28,3],[28,7,28,11],[28,12,28,15],[28,18,29,19],[28,20,29,20],[28,21,28,23],[28,25,28,27],[29,1,29,3]]}
[null,"Race/Ethnicity Codes",null,null,null,null,null,null,null,null,null,"Source(s) of Income Codes",null,null,null,null,null,null,null,null,"SHRA Funding Program(s) Codes"]
[null,"AIAN",null,"American Indian/Alaska Native",null,null,null,"100% AMI",null,null,null,"PA","Public Assitance( TANF, CALWorks, CALFresh, GA, Etc)",null,null,null,null,null,null,null,"BOND","Bond"]
[null,"AS",null,"Asian",null,null,null,1,63750,null,null,"AS","Asset(s)",null,null,null,null,null,null,null,"CDBG","Community Development Block Grant "]
[null,"BA",null,"Black/African American",null,null,null,2,72900,null,null,"CS","Child Support ",null,null,null,null,"Smoking Codes",null,null,"CII","City Inclusionary"]
[null,"HWOPI",null,"Hawaiian/Other Pacific Islander",null,null,null,3,82000,null,null,"EMP","Employment",null,null,null,null,"Y","Yes",null,"COI","County Inclusionary"]
[null,"WHT",null,"White",null,null,null,4,91100,null,null,"NIC","No Income Certification",null,null,null,null,"N","No",null,"DRL","Deferred Rehabilitation Loan"]
[null,"OTH",null,"Other",null,null,null,5,98400,null,null,"ONI","Other Non-wage Income",null,null,null,null,null,null,null,"HOME","HOME Investment Partnership"]
[null,null,null,null,null,null,null,6,105700,null,null,"OPA","Other  Public Assistance ",null,null,null,null,null,null,null,"HTF","Housing Trust Fund"]
[null,null,null,null,null,null,null,7,112950,null,null,"PR","Pension/Retirement",null,null,null,null,null,null,null,"MHSA","Mental Health Services Act"]
[null,null,null,null,null,null,null,8,120250,null,null,"RG","Recurring Gift",null,null,null,null,null,null,null,"NSP","Neighborhood Stabilization Program"]
[null,null,null,null,null,null,null,9,127550,null,null,"SDI","State Disability Insurance",null,null,null,null,null,null,null,"TI","Tax Increment"]
[null,null,null,null,null,null,null,10,134850,null,null,"SELF","Self-Employment"]
[null,null,null,null,null,null,null,11,142150,null,null,"SFA","Student Financial Assistance",null,null,null,null,null,null,null,"Unit Size",null,null,"Select Utility Allowance"]
[null,"H Type - Household Type Codes",null,null,null,null,null,12,{"$f":"I6*1.64","v":149404},null,null,"SS","Social Security Benefits",null,null,null,null,null,null,null,"SRO",null,null,"1) Apartment/Walk-Up"]
[null,"ELD",null,"Elderly",null,null,null,null,null,null,null,"SSI","Supplemental  Security Income ",null,null,null,null,null,null,null,"Studio",null,null,"2) RH, TH, SD & DX"]
[null,"OTH",null,"Other",null,"Unit Designation Codes",null,null,null,null,null,"UB","Unemployment Benefits",null,null,null,null,null,null,null,1,null,null,"3) CUAC (PROVIDE to SHRA)"]
[null,"SNE",null,"Single/Non-Elderly",null,0.3,null,null,null,null,null,"VA","Veterans Benefits",null,null,null,null,null,null,null,2,null,null,"4) HUSM (PROVIDE to SHRA)"]
[null,"SP",null,"Single Parent",null,0.35,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,null,null,"5) Other"]
[null,"TP",null,"Two Parents",null,0.4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,null,null,null,null,0.45,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[null,"Hispanic Code",null,null,null,0.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Shared"]
[null,"Y","Yes",null,null,0.6]
[null,"N","No",null,null,0.7]
[null,null,null,null,null,0.8]
[null,null,null,null,null,1.1000000000000001]
[null,null,null,null,null,1.2]
[null,"Unit Status Report (USR)\n(Current as of 8-11-2021)"]
[]
[null,"Property Name:",null,null,"Street Address, City & Zip Code:",null,null,"Management Company Name:",null,null,null,null,"Total SHRA Units:",null,null,null,null,null," SHRA \nUnit Mix",null,"Percent\nof Total","Property Total Children age 0-5 ",null,null,null,"Property Total Children age 13-17"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Total other assisted units:",null,null,null,null,null,null,null,null,"Property Total Children age 6-12",null,null,null,"Property Total Children/Minors:",null,null,{"$f":"Y29+Y30+AC29","v":0}]
[null,"Unit Status Report Completed By:",null,null,"Position Title:",null,null,"Property Phone Number:",null,null,"Other Phone Number:",null,"Total market rate units:",null,null,null,null,null,"EL:",null,{"$f":"IF(T31>0,T31/R33,0)","v":0},"Utility Allowance Schedule (1-10)",null,null,"Select Utility Allowance"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Total exempt units",null,null,null,null,null,"VL :",null,{"$f":"IF(T32>0,T32/R33,0)","v":0},"Property Total Housing Choice Voucher (HCV) Tenants:"]
[null,"Email address:",null,null,null,null,null,"Reporting Period From:",null,null,"Reporting Period To:",null,"Property Total units:",null,null,null,null,{"$f":"SUM(R29:R32)","v":0},"LW:",null,{"$f":"IF(T33>0,T33/R33,0)","v":0},"Property Total Wheelchair Accessible units:"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Property Total Vacant units:",null,null,null,null,null,"MD:",null,{"$f":"IF(T34>0,T34/R33,0)","v":0},"Property Total ADA Compliant units "]
[]
[null,"Building","Unit #","HOH Last Name","Move-In","Hispanic","Race","HH","HH Gross  \nAnnual \nIncome*","HH\nSize",1,"% ","Source(s) of Income*",null,null,null,"Smoking","Unit","Unit","Tenant Monthly\nRent","Utility\nAllowance","Rent \nSubsidy","Gross\nMonthly\nRent","SHRA Funding Program(s)"]
[null,"No.","(include vacant SHRA Units)","or indicate \nVacant","Date*","Y / N",null,"Type*",null,"Size*","AMI*","AMI",1,2,3,4,"Y / N ","Size","Designation",null,null,null,null,1,2,3,4,5,6]
[1,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I38>0,I38/K38,\"0\")","v":"0"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(V38>0,T38+V38,T38+U38)","v":0}]
[2,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I39>0,I39/K39,\"0\")","v":"0"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(V39>0,T39+V39,T39+U39)","v":0}]
[3,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[4,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[5,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[6,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[7,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[8,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[9,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[10,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[11,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[12,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[13,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[14,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[15,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[16,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[17,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[18,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[19,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[20,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[21,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[22,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[23,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[24,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[25,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[26,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[27,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[28,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[29,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[30,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]

{"sheet":"USR Pg 5 (121-150)","index":6,"n_rows":67,"n_cols":29,"rows_kept":67,"cut":false,"hidden":false,"merged":[[35,23,35,28],[35,8,36,8],[35,12,35,15],[35,19,36,19],[35,20,36,20],[35,21,36,21],[35,22,36,22],[33,1,33,6],[33,7,33,9],[33,10,33,11],[33,12,33,15],[33,21,33,26],[33,27,33,28],[32,1,32,6],[32,7,32,9],[32,10,32,11],[32,12,32,15],[32,21,32,26],[32,27,32,28],[30,21,30,23],[30,24,30,28],[31,1,31,3],[31,4,31,6],[31,7,31,9],[31,10,31,11],[31,21,31,26],[31,27,31,28],[29,4,29,6],[29,7,29,11],[29,12,29,15],[29,21,29,23],[29,25,29,27],[30,1,30,3],[30,4,30,6],[30,7,30,9],[30,10,30,11],[30,12,30,15],[13,1,13,3],[26,1,27,28],[28,1,28,3],[28,7,28,11],[28,12,28,15],[28,18,29,19],[28,20,29,20],[28,21,28,23],[28,25,28,27],[29,1,29,3]]}
[null,"Race/Ethnicity Codes",null,null,null,null,null,null,null,null,null,"Source(s) of Income Codes",null,null,null,null,null,null,null,null,"SHRA Funding Program(s) Codes"]
[null,"AIAN",null,"American Indian/Alaska Native",null,null,null,"100% AMI",null,null,null,"PA","Public Assitance( TANF, CALWorks, CALFresh, GA, Etc)",null,null,null,null,null,null,null,"BOND","Bond"]
[null,"AS",null,"Asian",null,null,null,1,63750,null,null,"AS","Asset(s)",null,null,null,null,null,null,null,"CDBG","Community Development Block Grant "]
[null,"BA",null,"Black/African American",null,null,null,2,72900,null,null,"CS","Child Support ",null,null,null,null,"Smoking Codes",null,null,"CII","City Inclusionary"]
[null,"HWOPI",null,"Hawaiian/Other Pacific Islander",null,null,null,3,82000,null,null,"EMP","Employment",null,null,null,null,"Y","Yes",null,"COI","County Inclusionary"]
[null,"WHT",null,"White",null,null,null,4,91100,null,null,"NIC","No Income Certification",null,null,null,null,"N","No",null,"DRL","Deferred Rehabilitation Loan"]
[null,"OTH",null,"Other",null,null,null,5,98400,null,null,"ONI","Other Non-wage Income",null,null,null,null,null,null,null,"HOME","HOME Investment Partnership"]
[null,null,null,null,null,null,null,6,105700,null,null,"OPA","Other  Public Assistance ",null,null,null,null,null,null,null,"HTF","Housing Trust Fund"]
[null,null,null,null,null,null,null,7,112950,null,null,"PR","Pension/Retirement",null,null,null,null,null,null,null,"MHSA","Mental Health Services Act"]
[null,null,null,null,null,null,null,8,120250,null,null,"RG","Recurring Gift",null,null,null,null,null,null,null,"NSP","Neighborhood Stabilization Program"]
[null,null,null,null,null,null,null,9,127550,null,null,"SDI","State Disability Insurance",null,null,null,null,null,null,null,"TI","Tax Increment"]
[null,null,null,null,null,null,null,10,134850,null,null,"SELF","Self-Employment"]
[null,null,null,null,null,null,null,11,142150,null,null,"SFA","Student Financial Assistance",null,null,null,null,null,null,null,"Unit Size",null,null,"Select Utility Allowance"]
[null,"H Type - Household Type Codes",null,null,null,null,null,12,{"$f":"I6*1.64","v":149404},null,null,"SS","Social Security Benefits",null,null,null,null,null,null,null,"SRO",null,null,"1) Apartment/Walk-Up"]
[null,"ELD",null,"Elderly",null,null,null,null,null,null,null,"SSI","Supplemental  Security Income ",null,null,null,null,null,null,null,"Studio",null,null,"2) RH, TH, SD & DX"]
[null,"OTH",null,"Other",null,"Unit Designation Codes",null,null,null,null,null,"UB","Unemployment Benefits",null,null,null,null,null,null,null,1,null,null,"3) CUAC (PROVIDE to SHRA)"]
[null,"SNE",null,"Single/Non-Elderly",null,0.3,null,null,null,null,null,"VA","Veterans Benefits",null,null,null,null,null,null,null,2,null,null,"4) HUSM (PROVIDE to SHRA)"]
[null,"SP",null,"Single Parent",null,0.35,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,null,null,"5) Other"]
[null,"TP",null,"Two Parents",null,0.4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,null,null,null,null,0.45,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[null,"Hispanic Code",null,null,null,0.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Shared"]
[null,"Y","Yes",null,null,0.6]
[null,"N","No",null,null,0.7]
[null,null,null,null,null,0.8]
[null,null,null,null,null,1.1000000000000001]
[null,null,null,null,null,1.2]
[null,"Unit Status Report (USR)\n(Current as of 8-11-2021)"]
[]
[null,"Property Name:",null,null,"Street Address, City & Zip Code:",null,null,"Management Company Name:",null,null,null,null,"Total SHRA Units:",null,null,null,null,null," SHRA \nUnit Mix",null,"Percent\nof Total","Property Total Children age 0-5 ",null,null,null,"Property Total Children age 13-17"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Total other assisted units:",null,null,null,null,null,null,null,null,"Property Total Children age 6-12",null,null,null,"Property Total Children/Minors:",null,null,{"$f":"Y29+Y30+AC29","v":0}]
[null,"Unit Status Report Completed By:",null,null,"Position Title:",null,null,"Property Phone Number:",null,null,"Other Phone Number:",null,"Total market rate units:",null,null,null,null,null,"EL:",null,{"$f":"IF(T31>0,T31/R33,0)","v":0},"Utility Allowance Schedule (1-10)",null,null,"Select Utility Allowance"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Total exempt units",null,null,null,null,null,"VL :",null,{"$f":"IF(T32>0,T32/R33,0)","v":0},"Property Total Housing Choice Voucher (HCV) Tenants:"]
[null,"Email address:",null,null,null,null,null,"Reporting Period From:",null,null,"Reporting Period To:",null,"Property Total units:",null,null,null,null,{"$f":"SUM(R29:R32)","v":0},"LW:",null,{"$f":"IF(T33>0,T33/R33,0)","v":0},"Property Total Wheelchair Accessible units:"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Property Total Vacant units:",null,null,null,null,null,"MD:",null,{"$f":"IF(T34>0,T34/R33,0)","v":0},"Property Total ADA Compliant units "]
[]
[null,"Building","Unit #","HOH Last Name","Move-In","Hispanic","Race","HH","HH Gross  \nAnnual \nIncome*","HH\nSize",1,"% ","Source(s) of Income*",null,null,null,"Smoking","Unit","Unit","Tenant Monthly\nRent","Utility\nAllowance","Rent \nSubsidy","Gross\nMonthly\nRent","SHRA Funding Program(s)"]
[null,"No.","(include vacant SHRA Units)","or indicate \nVacant","Date*","Y / N",null,"Type*",null,"Size*","AMI*","AMI",1,2,3,4,"Y / N ","Size","Designation",null,null,null,null,1,2,3,4,5,6]
[1,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I38>0,I38/K38,\"0\")","v":"0"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(V38>0,T38+V38,T38+U38)","v":0}]
[2,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I39>0,I39/K39,\"0\")","v":"0"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(V39>0,T39+V39,T39+U39)","v":0}]
[3,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[4,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[5,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[6,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[7,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[8,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[9,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[10,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[11,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[12,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[13,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[14,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[15,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[16,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[17,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[18,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[19,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[20,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[21,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[22,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[23,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[24,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[25,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[26,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[27,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[28,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[29,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[30,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]

{"sheet":"USR Pg 6 (151-180)","index":7,"n_rows":67,"n_cols":29,"rows_kept":67,"cut":false,"hidden":false,"merged":[[35,23,35,28],[35,8,36,8],[35,12,35,15],[35,19,36,19],[35,20,36,20],[35,21,36,21],[35,22,36,22],[33,1,33,6],[33,7,33,9],[33,10,33,11],[33,12,33,15],[33,21,33,26],[33,27,33,28],[32,1,32,6],[32,7,32,9],[32,10,32,11],[32,12,32,15],[32,21,32,26],[32,27,32,28],[30,21,30,23],[30,24,30,28],[31,1,31,3],[31,4,31,6],[31,7,31,9],[31,10,31,11],[31,21,31,26],[31,27,31,28],[29,4,29,6],[29,7,29,11],[29,12,29,15],[29,21,29,23],[29,25,29,27],[30,1,30,3],[30,4,30,6],[30,7,30,9],[30,10,30,11],[30,12,30,15],[13,1,13,3],[26,1,27,28],[28,1,28,3],[28,7,28,11],[28,12,28,15],[28,18,29,19],[28,20,29,20],[28,21,28,23],[28,25,28,27],[29,1,29,3]]}
[null,"Race/Ethnicity Codes",null,null,null,null,null,null,null,null,null,"Source(s) of Income Codes",null,null,null,null,null,null,null,null,"SHRA Funding Program(s) Codes"]
[null,"AIAN",null,"American Indian/Alaska Native",null,null,null,"100% AMI",null,null,null,"PA","Public Assitance( TANF, CALWorks, CALFresh, GA, Etc)",null,null,null,null,null,null,null,"BOND","Bond"]
[null,"AS",null,"Asian",null,null,null,1,63750,null,null,"AS","Asset(s)",null,null,null,null,null,null,null,"CDBG","Community Development Block Grant "]
[null,"BA",null,"Black/African American",null,null,null,2,72900,null,null,"CS","Child Support ",null,null,null,null,"Smoking Codes",null,null,"CII","City Inclusionary"]
[null,"HWOPI",null,"Hawaiian/Other Pacific Islander",null,null,null,3,82000,null,null,"EMP","Employment",null,null,null,null,"Y","Yes",null,"COI","County Inclusionary"]
[null,"WHT",null,"White",null,null,null,4,91100,null,null,"NIC","No Income Certification",null,null,null,null,"N","No",null,"DRL","Deferred Rehabilitation Loan"]
[null,"OTH",null,"Other",null,null,null,5,98400,null,null,"ONI","Other Non-wage Income",null,null,null,null,null,null,null,"HOME","HOME Investment Partnership"]
[null,null,null,null,null,null,null,6,105700,null,null,"OPA","Other  Public Assistance ",null,null,null,null,null,null,null,"HTF","Housing Trust Fund"]
[null,null,null,null,null,null,null,7,112950,null,null,"PR","Pension/Retirement",null,null,null,null,null,null,null,"MHSA","Mental Health Services Act"]
[null,null,null,null,null,null,null,8,120250,null,null,"RG","Recurring Gift",null,null,null,null,null,null,null,"NSP","Neighborhood Stabilization Program"]
[null,null,null,null,null,null,null,9,127550,null,null,"SDI","State Disability Insurance",null,null,null,null,null,null,null,"TI","Tax Increment"]
[null,null,null,null,null,null,null,10,134850,null,null,"SELF","Self-Employment"]
[null,null,null,null,null,null,null,11,142150,null,null,"SFA","Student Financial Assistance",null,null,null,null,null,null,null,"Unit Size",null,null,"Select Utility Allowance"]
[null,"H Type - Household Type Codes",null,null,null,null,null,12,{"$f":"I6*1.64","v":149404},null,null,"SS","Social Security Benefits",null,null,null,null,null,null,null,"SRO",null,null,"1) Apartment/Walk-Up"]
[null,"ELD",null,"Elderly",null,null,null,null,null,null,null,"SSI","Supplemental  Security Income ",null,null,null,null,null,null,null,"Studio",null,null,"2) RH, TH, SD & DX"]
[null,"OTH",null,"Other",null,"Unit Designation Codes",null,null,null,null,null,"UB","Unemployment Benefits",null,null,null,null,null,null,null,1,null,null,"3) CUAC (PROVIDE to SHRA)"]
[null,"SNE",null,"Single/Non-Elderly",null,0.3,null,null,null,null,null,"VA","Veterans Benefits",null,null,null,null,null,null,null,2,null,null,"4) HUSM (PROVIDE to SHRA)"]
[null,"SP",null,"Single Parent",null,0.35,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,null,null,"5) Other"]
[null,"TP",null,"Two Parents",null,0.4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,null,null,null,null,0.45,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[null,"Hispanic Code",null,null,null,0.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Shared"]
[null,"Y","Yes",null,null,0.6]
[null,"N","No",null,null,0.7]
[null,null,null,null,null,0.8]
[null,null,null,null,null,1.1000000000000001]
[null,null,null,null,null,1.2]
[null,"Unit Status Report (USR)\n(Current as of 8-11-2021)"]
[]
[null,"Property Name:",null,null,"Street Address, City & Zip Code:",null,null,"Management Company Name:",null,null,null,null,"Total SHRA Units:",null,null,null,null,null," SHRA \nUnit Mix",null,"Percent\nof Total","Property Total Children age 0-5 ",null,null,null,"Property Total Children age 13-17"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Total other assisted units:",null,null,null,null,null,null,null,null,"Property Total Children age 6-12",null,null,null,"Property Total Children/Minors:",null,null,{"$f":"Y29+Y30+AC29","v":0}]
[null,"Unit Status Report Completed By:",null,null,"Position Title:",null,null,"Property Phone Number:",null,null,"Other Phone Number:",null,"Total market rate units:",null,null,null,null,null,"EL:",null,{"$f":"IF(T31>0,T31/R33,0)","v":0},"Utility Allowance Schedule (1-10)",null,null,"Select Utility Allowance"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Total exempt units",null,null,null,null,null,"VL :",null,{"$f":"IF(T32>0,T32/R33,0)","v":0},"Property Total Housing Choice Voucher (HCV) Tenants:"]
[null,"Email address:",null,null,null,null,null,"Reporting Period From:",null,null,"Reporting Period To:",null,"Property Total units:",null,null,null,null,{"$f":"SUM(R29:R32)","v":0},"LW:",null,{"$f":"IF(T33>0,T33/R33,0)","v":0},"Property Total Wheelchair Accessible units:"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Property Total Vacant units:",null,null,null,null,null,"MD:",null,{"$f":"IF(T34>0,T34/R33,0)","v":0},"Property Total ADA Compliant units "]
[]
[null,"Building","Unit #","HOH Last Name","Move-In","Hispanic","Race","HH","HH Gross  \nAnnual \nIncome*","HH\nSize",1,"% ","Source(s) of Income*",null,null,null,"Smoking","Unit","Unit","Tenant Monthly\nRent","Utility\nAllowance","Rent \nSubsidy","Gross\nMonthly\nRent","SHRA Funding Program(s)"]
[null,"No.","(include vacant SHRA Units)","or indicate \nVacant","Date*","Y / N",null,"Type*",null,"Size*","AMI*","AMI",1,2,3,4,"Y / N ","Size","Designation",null,null,null,null,1,2,3,4,5,6]
[1,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I38>0,I38/K38,\"0\")","v":"0"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(V38>0,T38+V38,T38+U38)","v":0}]
[2,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I39>0,I39/K39,\"0\")","v":"0"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(V39>0,T39+V39,T39+U39)","v":0}]
[3,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[4,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[5,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[6,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[7,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[8,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[9,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[10,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[11,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[12,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[13,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[14,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[15,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[16,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[17,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[18,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[19,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[20,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[21,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[22,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[23,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[24,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[25,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[26,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[27,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[28,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[29,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[30,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]

{"sheet":"USR Pg 7 (181-210)","index":8,"n_rows":67,"n_cols":29,"rows_kept":67,"cut":false,"hidden":false,"merged":[[35,23,35,28],[35,8,36,8],[35,12,35,15],[35,19,36,19],[35,20,36,20],[35,21,36,21],[35,22,36,22],[33,1,33,6],[33,7,33,9],[33,10,33,11],[33,12,33,15],[33,21,33,26],[33,27,33,28],[32,1,32,6],[32,7,32,9],[32,10,32,11],[32,12,32,15],[32,21,32,26],[32,27,32,28],[30,21,30,23],[30,24,30,28],[31,1,31,3],[31,4,31,6],[31,7,31,9],[31,10,31,11],[31,21,31,26],[31,27,31,28],[29,4,29,6],[29,7,29,11],[29,12,29,15],[29,21,29,23],[29,25,29,27],[30,1,30,3],[30,4,30,6],[30,7,30,9],[30,10,30,11],[30,12,30,15],[13,1,13,3],[26,1,27,28],[28,1,28,3],[28,7,28,11],[28,12,28,15],[28,18,29,19],[28,20,29,20],[28,21,28,23],[28,25,28,27],[29,1,29,3]]}
[null,"Race/Ethnicity Codes",null,null,null,null,null,null,null,null,null,"Source(s) of Income Codes",null,null,null,null,null,null,null,null,"SHRA Funding Program(s) Codes"]
[null,"AIAN",null,"American Indian/Alaska Native",null,null,null,"100% AMI",null,null,null,"PA","Public Assitance( TANF, CALWorks, CALFresh, GA, Etc)",null,null,null,null,null,null,null,"BOND","Bond"]
[null,"AS",null,"Asian",null,null,null,1,63750,null,null,"AS","Asset(s)",null,null,null,null,null,null,null,"CDBG","Community Development Block Grant "]
[null,"BA",null,"Black/African American",null,null,null,2,72900,null,null,"CS","Child Support ",null,null,null,null,"Smoking Codes",null,null,"CII","City Inclusionary"]
[null,"HWOPI",null,"Hawaiian/Other Pacific Islander",null,null,null,3,82000,null,null,"EMP","Employment",null,null,null,null,"Y","Yes",null,"COI","County Inclusionary"]
[null,"WHT",null,"White",null,null,null,4,91100,null,null,"NIC","No Income Certification",null,null,null,null,"N","No",null,"DRL","Deferred Rehabilitation Loan"]
[null,"OTH",null,"Other",null,null,null,5,98400,null,null,"ONI","Other Non-wage Income",null,null,null,null,null,null,null,"HOME","HOME Investment Partnership"]
[null,null,null,null,null,null,null,6,105700,null,null,"OPA","Other  Public Assistance ",null,null,null,null,null,null,null,"HTF","Housing Trust Fund"]
[null,null,null,null,null,null,null,7,112950,null,null,"PR","Pension/Retirement",null,null,null,null,null,null,null,"MHSA","Mental Health Services Act"]
[null,null,null,null,null,null,null,8,120250,null,null,"RG","Recurring Gift",null,null,null,null,null,null,null,"NSP","Neighborhood Stabilization Program"]
[null,null,null,null,null,null,null,9,127550,null,null,"SDI","State Disability Insurance",null,null,null,null,null,null,null,"TI","Tax Increment"]
[null,null,null,null,null,null,null,10,134850,null,null,"SELF","Self-Employment"]
[null,null,null,null,null,null,null,11,142150,null,null,"SFA","Student Financial Assistance",null,null,null,null,null,null,null,"Unit Size",null,null,"Select Utility Allowance"]
[null,"H Type - Household Type Codes",null,null,null,null,null,12,{"$f":"I6*1.64","v":149404},null,null,"SS","Social Security Benefits",null,null,null,null,null,null,null,"SRO",null,null,"1) Apartment/Walk-Up"]
[null,"ELD",null,"Elderly",null,null,null,null,null,null,null,"SSI","Supplemental  Security Income ",null,null,null,null,null,null,null,"Studio",null,null,"2) RH, TH, SD & DX"]
[null,"OTH",null,"Other",null,"Unit Designation Codes",null,null,null,null,null,"UB","Unemployment Benefits",null,null,null,null,null,null,null,1,null,null,"3) CUAC (PROVIDE to SHRA)"]
[null,"SNE",null,"Single/Non-Elderly",null,0.3,null,null,null,null,null,"VA","Veterans Benefits",null,null,null,null,null,null,null,2,null,null,"4) HUSM (PROVIDE to SHRA)"]
[null,"SP",null,"Single Parent",null,0.35,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,null,null,"5) Other"]
[null,"TP",null,"Two Parents",null,0.4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,null,null,null,null,0.45,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[null,"Hispanic Code",null,null,null,0.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Shared"]
[null,"Y","Yes",null,null,0.6]
[null,"N","No",null,null,0.7]
[null,null,null,null,null,0.8]
[null,null,null,null,null,1.1000000000000001]
[null,null,null,null,null,1.2]
[null,"Unit Status Report (USR)\n(Current as of 8-11-2021)"]
[]
[null,"Property Name:",null,null,"Street Address, City & Zip Code:",null,null,"Management Company Name:",null,null,null,null,"Total SHRA Units:",null,null,null,null,null," SHRA \nUnit Mix",null,"Percent\nof Total","Property Total Children age 0-5 ",null,null,null,"Property Total Children age 13-17"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Total other assisted units:",null,null,null,null,null,null,null,null,"Property Total Children age 6-12",null,null,null,"Property Total Children/Minors:",null,null,{"$f":"Y29+Y30+AC29","v":0}]
[null,"Unit Status Report Completed By:",null,null,"Position Title:",null,null,"Property Phone Number:",null,null,"Other Phone Number:",null,"Total market rate units:",null,null,null,null,null,"EL:",null,{"$f":"IF(T31>0,T31/R33,0)","v":0},"Utility Allowance Schedule (1-10)",null,null,"Select Utility Allowance"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Total exempt units",null,null,null,null,null,"VL :",null,{"$f":"IF(T32>0,T32/R33,0)","v":0},"Property Total Housing Choice Voucher (HCV) Tenants:"]
[null,"Email address:",null,null,null,null,null,"Reporting Period From:",null,null,"Reporting Period To:",null,"Property Total units:",null,null,null,null,{"$f":"SUM(R29:R32)","v":0},"LW:",null,{"$f":"IF(T33>0,T33/R33,0)","v":0},"Property Total Wheelchair Accessible units:"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Property Total Vacant units:",null,null,null,null,null,"MD:",null,{"$f":"IF(T34>0,T34/R33,0)","v":0},"Property Total ADA Compliant units "]
[]
[null,"Building","Unit #","HOH Last Name","Move-In","Hispanic","Race","HH","HH Gross  \nAnnual \nIncome*","HH\nSize",1,"% ","Source(s) of Income*",null,null,null,"Smoking","Unit","Unit","Tenant Monthly\nRent","Utility\nAllowance","Rent \nSubsidy","Gross\nMonthly\nRent","SHRA Funding Program(s)"]
[null,"No.","(include vacant SHRA Units)","or indicate \nVacant","Date*","Y / N",null,"Type*",null,"Size*","AMI*","AMI",1,2,3,4,"Y / N ","Size","Designation",null,null,null,null,1,2,3,4,5,6]
[1,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I38>0,I38/K38,\"0\")","v":"0"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(V38>0,T38+V38,T38+U38)","v":0}]
[2,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I39>0,I39/K39,\"0\")","v":"0"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(V39>0,T39+V39,T39+U39)","v":0}]
[3,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[4,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[5,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[6,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[7,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[8,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[9,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[10,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[11,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[12,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[13,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[14,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[15,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[16,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[17,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[18,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[19,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[20,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[21,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[22,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[23,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[24,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[25,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[26,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[27,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[28,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[29,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[30,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]

{"sheet":"USR Pg 8 (211-240)","index":9,"n_rows":67,"n_cols":29,"rows_kept":67,"cut":false,"hidden":false,"merged":[[35,23,35,28],[35,8,36,8],[35,12,35,15],[35,19,36,19],[35,20,36,20],[35,21,36,21],[35,22,36,22],[33,1,33,6],[33,7,33,9],[33,10,33,11],[33,12,33,15],[33,21,33,26],[33,27,33,28],[32,1,32,6],[32,7,32,9],[32,10,32,11],[32,12,32,15],[32,21,32,26],[32,27,32,28],[30,21,30,23],[30,24,30,28],[31,1,31,3],[31,4,31,6],[31,7,31,9],[31,10,31,11],[31,21,31,26],[31,27,31,28],[29,4,29,6],[29,7,29,11],[29,12,29,15],[29,21,29,23],[29,25,29,27],[30,1,30,3],[30,4,30,6],[30,7,30,9],[30,10,30,11],[30,12,30,15],[13,1,13,3],[26,1,27,28],[28,1,28,3],[28,7,28,11],[28,12,28,15],[28,18,29,19],[28,20,29,20],[28,21,28,23],[28,25,28,27],[29,1,29,3]]}
[null,"Race/Ethnicity Codes",null,null,null,null,null,null,null,null,null,"Source(s) of Income Codes",null,null,null,null,null,null,null,null,"SHRA Funding Program(s) Codes"]
[null,"AIAN",null,"American Indian/Alaska Native",null,null,null,"100% AMI",null,null,null,"PA","Public Assitance( TANF, CALWorks, CALFresh, GA, Etc)",null,null,null,null,null,null,null,"BOND","Bond"]
[null,"AS",null,"Asian",null,null,null,1,63750,null,null,"AS","Asset(s)",null,null,null,null,null,null,null,"CDBG","Community Development Block Grant "]
[null,"BA",null,"Black/African American",null,null,null,2,72900,null,null,"CS","Child Support ",null,null,null,null,"Smoking Codes",null,null,"CII","City Inclusionary"]
[null,"HWOPI",null,"Hawaiian/Other Pacific Islander",null,null,null,3,82000,null,null,"EMP","Employment",null,null,null,null,"Y","Yes",null,"COI","County Inclusionary"]
[null,"WHT",null,"White",null,null,null,4,91100,null,null,"NIC","No Income Certification",null,null,null,null,"N","No",null,"DRL","Deferred Rehabilitation Loan"]
[null,"OTH",null,"Other",null,null,null,5,98400,null,null,"ONI","Other Non-wage Income",null,null,null,null,null,null,null,"HOME","HOME Investment Partnership"]
[null,null,null,null,null,null,null,6,105700,null,null,"OPA","Other  Public Assistance ",null,null,null,null,null,null,null,"HTF","Housing Trust Fund"]
[null,null,null,null,null,null,null,7,112950,null,null,"PR","Pension/Retirement",null,null,null,null,null,null,null,"MHSA","Mental Health Services Act"]
[null,null,null,null,null,null,null,8,120250,null,null,"RG","Recurring Gift",null,null,null,null,null,null,null,"NSP","Neighborhood Stabilization Program"]
[null,null,null,null,null,null,null,9,127550,null,null,"SDI","State Disability Insurance",null,null,null,null,null,null,null,"TI","Tax Increment"]
[null,null,null,null,null,null,null,10,134850,null,null,"SELF","Self-Employment"]
[null,null,null,null,null,null,null,11,142150,null,null,"SFA","Student Financial Assistance",null,null,null,null,null,null,null,"Unit Size",null,null,"Select Utility Allowance"]
[null,"H Type - Household Type Codes",null,null,null,null,null,12,{"$f":"I6*1.64","v":149404},null,null,"SS","Social Security Benefits",null,null,null,null,null,null,null,"SRO",null,null,"1) Apartment/Walk-Up"]
[null,"ELD",null,"Elderly",null,null,null,null,null,null,null,"SSI","Supplemental  Security Income ",null,null,null,null,null,null,null,"Studio",null,null,"2) RH, TH, SD & DX"]
[null,"OTH",null,"Other",null,"Unit Designation Codes",null,null,null,null,null,"UB","Unemployment Benefits",null,null,null,null,null,null,null,1,null,null,"3) CUAC (PROVIDE to SHRA)"]
[null,"SNE",null,"Single/Non-Elderly",null,0.3,null,null,null,null,null,"VA","Veterans Benefits",null,null,null,null,null,null,null,2,null,null,"4) HUSM (PROVIDE to SHRA)"]
[null,"SP",null,"Single Parent",null,0.35,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,null,null,"5) Other"]
[null,"TP",null,"Two Parents",null,0.4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,null,null,null,null,0.45,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[null,"Hispanic Code",null,null,null,0.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Shared"]
[null,"Y","Yes",null,null,0.6]
[null,"N","No",null,null,0.7]
[null,null,null,null,null,0.8]
[null,null,null,null,null,1.1000000000000001]
[null,null,null,null,null,1.2]
[null,"Unit Status Report (USR)\n(Current as of 8-11-2021)"]
[]
[null,"Property Name:",null,null,"Street Address, City & Zip Code:",null,null,"Management Company Name:",null,null,null,null,"Total SHRA Units:",null,null,null,null,null," SHRA \nUnit Mix",null,"Percent\nof Total","Property Total Children age 0-5 ",null,null,null,"Property Total Children age 13-17"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Total other assisted units:",null,null,null,null,null,null,null,null,"Property Total Children age 6-12",null,null,null,"Property Total Children/Minors:",null,null,{"$f":"Y29+Y30+AC29","v":0}]
[null,"Unit Status Report Completed By:",null,null,"Position Title:",null,null,"Property Phone Number:",null,null,"Other Phone Number:",null,"Total market rate units:",null,null,null,null,null,"EL:",null,{"$f":"IF(T31>0,T31/R33,0)","v":0},"Utility Allowance Schedule (1-10)",null,null,"Select Utility Allowance"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Total exempt units",null,null,null,null,null,"VL :",null,{"$f":"IF(T32>0,T32/R33,0)","v":0},"Property Total Housing Choice Voucher (HCV) Tenants:"]
[null,"Email address:",null,null,null,null,null,"Reporting Period From:",null,null,"Reporting Period To:",null,"Property Total units:",null,null,null,null,{"$f":"SUM(R29:R32)","v":0},"LW:",null,{"$f":"IF(T33>0,T33/R33,0)","v":0},"Property Total Wheelchair Accessible units:"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Property Total Vacant units:",null,null,null,null,null,"MD:",null,{"$f":"IF(T34>0,T34/R33,0)","v":0},"Property Total ADA Compliant units "]
[]
[null,"Building","Unit #","HOH Last Name","Move-In","Hispanic","Race","HH","HH Gross  \nAnnual \nIncome*","HH\nSize",1,"% ","Source(s) of Income*",null,null,null,"Smoking","Unit","Unit","Tenant Monthly\nRent","Utility\nAllowance","Rent \nSubsidy","Gross\nMonthly\nRent","SHRA Funding Program(s)"]
[null,"No.","(include vacant SHRA Units)","or indicate \nVacant","Date*","Y / N",null,"Type*",null,"Size*","AMI*","AMI",1,2,3,4,"Y / N ","Size","Designation",null,null,null,null,1,2,3,4,5,6]
[1,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I38>0,I38/K38,\"0\")","v":"0"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(V38>0,T38+V38,T38+U38)","v":0}]
[2,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I39>0,I39/K39,\"0\")","v":"0"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(V39>0,T39+V39,T39+U39)","v":0}]
[3,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[4,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[5,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[6,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[7,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[8,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[9,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[10,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[11,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[12,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[13,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[14,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[15,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[16,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[17,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[18,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[19,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[20,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[21,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[22,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[23,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[24,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[25,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[26,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[27,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[28,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[29,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[30,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]

{"sheet":"USR Pg 9 (241-270)","index":10,"n_rows":67,"n_cols":29,"rows_kept":67,"cut":false,"hidden":false,"merged":[[35,23,35,28],[35,8,36,8],[35,12,35,15],[35,19,36,19],[35,20,36,20],[35,21,36,21],[35,22,36,22],[33,1,33,6],[33,7,33,9],[33,10,33,11],[33,12,33,15],[33,21,33,26],[33,27,33,28],[32,1,32,6],[32,7,32,9],[32,10,32,11],[32,12,32,15],[32,21,32,26],[32,27,32,28],[30,21,30,23],[30,24,30,28],[31,1,31,3],[31,4,31,6],[31,7,31,9],[31,10,31,11],[31,21,31,26],[31,27,31,28],[29,4,29,6],[29,7,29,11],[29,12,29,15],[29,21,29,23],[29,25,29,27],[30,1,30,3],[30,4,30,6],[30,7,30,9],[30,10,30,11],[30,12,30,15],[13,1,13,3],[26,1,27,28],[28,1,28,3],[28,7,28,11],[28,12,28,15],[28,18,29,19],[28,20,29,20],[28,21,28,23],[28,25,28,27],[29,1,29,3]]}
[null,"Race/Ethnicity Codes",null,null,null,null,null,null,null,null,null,"Source(s) of Income Codes",null,null,null,null,null,null,null,null,"SHRA Funding Program(s) Codes"]
[null,"AIAN",null,"American Indian/Alaska Native",null,null,null,"100% AMI",null,null,null,"PA","Public Assitance( TANF, CALWorks, CALFresh, GA, Etc)",null,null,null,null,null,null,null,"BOND","Bond"]
[null,"AS",null,"Asian",null,null,null,1,63750,null,null,"AS","Asset(s)",null,null,null,null,null,null,null,"CDBG","Community Development Block Grant "]
[null,"BA",null,"Black/African American",null,null,null,2,72900,null,null,"CS","Child Support ",null,null,null,null,"Smoking Codes",null,null,"CII","City Inclusionary"]
[null,"HWOPI",null,"Hawaiian/Other Pacific Islander",null,null,null,3,82000,null,null,"EMP","Employment",null,null,null,null,"Y","Yes",null,"COI","County Inclusionary"]
[null,"WHT",null,"White",null,null,null,4,91100,null,null,"NIC","No Income Certification",null,null,null,null,"N","No",null,"DRL","Deferred Rehabilitation Loan"]
[null,"OTH",null,"Other",null,null,null,5,98400,null,null,"ONI","Other Non-wage Income",null,null,null,null,null,null,null,"HOME","HOME Investment Partnership"]
[null,null,null,null,null,null,null,6,105700,null,null,"OPA","Other  Public Assistance ",null,null,null,null,null,null,null,"HTF","Housing Trust Fund"]
[null,null,null,null,null,null,null,7,112950,null,null,"PR","Pension/Retirement",null,null,null,null,null,null,null,"MHSA","Mental Health Services Act"]
[null,null,null,null,null,null,null,8,120250,null,null,"RG","Recurring Gift",null,null,null,null,null,null,null,"NSP","Neighborhood Stabilization Program"]
[null,null,null,null,null,null,null,9,127550,null,null,"SDI","State Disability Insurance",null,null,null,null,null,null,null,"TI","Tax Increment"]
[null,null,null,null,null,null,null,10,134850,null,null,"SELF","Self-Employment"]
[null,null,null,null,null,null,null,11,142150,null,null,"SFA","Student Financial Assistance",null,null,null,null,null,null,null,"Unit Size",null,null,"Select Utility Allowance"]
[null,"H Type - Household Type Codes",null,null,null,null,null,12,{"$f":"I6*1.64","v":149404},null,null,"SS","Social Security Benefits",null,null,null,null,null,null,null,"SRO",null,null,"1) Apartment/Walk-Up"]
[null,"ELD",null,"Elderly",null,null,null,null,null,null,null,"SSI","Supplemental  Security Income ",null,null,null,null,null,null,null,"Studio",null,null,"2) RH, TH, SD & DX"]
[null,"OTH",null,"Other",null,"Unit Designation Codes",null,null,null,null,null,"UB","Unemployment Benefits",null,null,null,null,null,null,null,1,null,null,"3) CUAC (PROVIDE to SHRA)"]
[null,"SNE",null,"Single/Non-Elderly",null,0.3,null,null,null,null,null,"VA","Veterans Benefits",null,null,null,null,null,null,null,2,null,null,"4) HUSM (PROVIDE to SHRA)"]
[null,"SP",null,"Single Parent",null,0.35,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,null,null,"5) Other"]
[null,"TP",null,"Two Parents",null,0.4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,null,null,null,null,0.45,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[null,"Hispanic Code",null,null,null,0.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Shared"]
[null,"Y","Yes",null,null,0.6]
[null,"N","No",null,null,0.7]
[null,null,null,null,null,0.8]
[null,null,null,null,null,1.1000000000000001]
[null,null,null,null,null,1.2]
[null,"Unit Status Report (USR)\n(Current as of 8-11-2021)"]
[]
[null,"Property Name:",null,null,"Street Address, City & Zip Code:",null,null,"Management Company Name:",null,null,null,null,"Total SHRA Units:",null,null,null,null,null," SHRA \nUnit Mix",null,"Percent\nof Total","Property Total Children age 0-5 ",null,null,null,"Property Total Children age 13-17"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Total other assisted units:",null,null,null,null,null,null,null,null,"Property Total Children age 6-12",null,null,null,"Property Total Children/Minors:",null,null,{"$f":"Y29+Y30+AC29","v":0}]
[null,"Unit Status Report Completed By:",null,null,"Position Title:",null,null,"Property Phone Number:",null,null,"Other Phone Number:",null,"Total market rate units:",null,null,null,null,null,"EL:",null,{"$f":"IF(T31>0,T31/R33,0)","v":0},"Utility Allowance Schedule (1-10)",null,null,"Select Utility Allowance"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Total exempt units",null,null,null,null,null,"VL :",null,{"$f":"IF(T32>0,T32/R33,0)","v":0},"Property Total Housing Choice Voucher (HCV) Tenants:"]
[null,"Email address:",null,null,null,null,null,"Reporting Period From:",null,null,"Reporting Period To:",null,"Property Total units:",null,null,null,null,{"$f":"SUM(R29:R32)","v":0},"LW:",null,{"$f":"IF(T33>0,T33/R33,0)","v":0},"Property Total Wheelchair Accessible units:"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Property Total Vacant units:",null,null,null,null,null,"MD:",null,{"$f":"IF(T34>0,T34/R33,0)","v":0},"Property Total ADA Compliant units "]
[]
[null,"Building","Unit #","HOH Last Name","Move-In","Hispanic","Race","HH","HH Gross  \nAnnual \nIncome*","HH\nSize",1,"% ","Source(s) of Income*",null,null,null,"Smoking","Unit","Unit","Tenant Monthly\nRent","Utility\nAllowance","Rent \nSubsidy","Gross\nMonthly\nRent","SHRA Funding Program(s)"]
[null,"No.","(include vacant SHRA Units)","or indicate \nVacant","Date*","Y / N",null,"Type*",null,"Size*","AMI*","AMI",1,2,3,4,"Y / N ","Size","Designation",null,null,null,null,1,2,3,4,5,6]
[1,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I38>0,I38/K38,\"0\")","v":"0"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(V38>0,T38+V38,T38+U38)","v":0}]
[2,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I39>0,I39/K39,\"0\")","v":"0"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(V39>0,T39+V39,T39+U39)","v":0}]
[3,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[4,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[5,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[6,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[7,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[8,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[9,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[10,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[11,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[12,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[13,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[14,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[15,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[16,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[17,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[18,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[19,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[20,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[21,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[22,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[23,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[24,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[25,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[26,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[27,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[28,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[29,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[30,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]

{"sheet":"USR Pg 10 (271-300)","index":11,"n_rows":67,"n_cols":29,"rows_kept":67,"cut":false,"hidden":false,"merged":[[35,23,35,28],[35,8,36,8],[35,12,35,15],[35,19,36,19],[35,20,36,20],[35,21,36,21],[35,22,36,22],[33,1,33,6],[33,7,33,9],[33,10,33,11],[33,12,33,15],[33,21,33,26],[33,27,33,28],[32,1,32,6],[32,7,32,9],[32,10,32,11],[32,12,32,15],[32,21,32,26],[32,27,32,28],[30,21,30,23],[30,24,30,28],[31,1,31,3],[31,4,31,6],[31,7,31,9],[31,10,31,11],[31,21,31,26],[31,27,31,28],[29,4,29,6],[29,7,29,11],[29,12,29,15],[29,21,29,23],[29,25,29,27],[30,1,30,3],[30,4,30,6],[30,7,30,9],[30,10,30,11],[30,12,30,15],[13,1,13,3],[26,1,27,28],[28,1,28,3],[28,7,28,11],[28,12,28,15],[28,18,29,19],[28,20,29,20],[28,21,28,23],[28,25,28,27],[29,1,29,3]]}
[null,"Race/Ethnicity Codes",null,null,null,null,null,null,null,null,null,"Source(s) of Income Codes",null,null,null,null,null,null,null,null,"SHRA Funding Program(s) Codes"]
[null,"AIAN",null,"American Indian/Alaska Native",null,null,null,"100% AMI",null,null,null,"PA","Public Assitance( TANF, CALWorks, CALFresh, GA, Etc)",null,null,null,null,null,null,null,"BOND","Bond"]
[null,"AS",null,"Asian",null,null,null,1,63750,null,null,"AS","Asset(s)",null,null,null,null,null,null,null,"CDBG","Community Development Block Grant "]
[null,"BA",null,"Black/African American",null,null,null,2,72900,null,null,"CS","Child Support ",null,null,null,null,"Smoking Codes",null,null,"CII","City Inclusionary"]
[null,"HWOPI",null,"Hawaiian/Other Pacific Islander",null,null,null,3,82000,null,null,"EMP","Employment",null,null,null,null,"Y","Yes",null,"COI","County Inclusionary"]
[null,"WHT",null,"White",null,null,null,4,91100,null,null,"NIC","No Income Certification",null,null,null,null,"N","No",null,"DRL","Deferred Rehabilitation Loan"]
[null,"OTH",null,"Other",null,null,null,5,98400,null,null,"ONI","Other Non-wage Income",null,null,null,null,null,null,null,"HOME","HOME Investment Partnership"]
[null,null,null,null,null,null,null,6,105700,null,null,"OPA","Other  Public Assistance ",null,null,null,null,null,null,null,"HTF","Housing Trust Fund"]
[null,null,null,null,null,null,null,7,112950,null,null,"PR","Pension/Retirement",null,null,null,null,null,null,null,"MHSA","Mental Health Services Act"]
[null,null,null,null,null,null,null,8,120250,null,null,"RG","Recurring Gift",null,null,null,null,null,null,null,"NSP","Neighborhood Stabilization Program"]
[null,null,null,null,null,null,null,9,127550,null,null,"SDI","State Disability Insurance",null,null,null,null,null,null,null,"TI","Tax Increment"]
[null,null,null,null,null,null,null,10,134850,null,null,"SELF","Self-Employment"]
[null,null,null,null,null,null,null,11,142150,null,null,"SFA","Student Financial Assistance",null,null,null,null,null,null,null,"Unit Size",null,null,"Select Utility Allowance"]
[null,"H Type - Household Type Codes",null,null,null,null,null,12,{"$f":"I6*1.64","v":149404},null,null,"SS","Social Security Benefits",null,null,null,null,null,null,null,"SRO",null,null,"1) Apartment/Walk-Up"]
[null,"ELD",null,"Elderly",null,null,null,null,null,null,null,"SSI","Supplemental  Security Income ",null,null,null,null,null,null,null,"Studio",null,null,"2) RH, TH, SD & DX"]
[null,"OTH",null,"Other",null,"Unit Designation Codes",null,null,null,null,null,"UB","Unemployment Benefits",null,null,null,null,null,null,null,1,null,null,"3) CUAC (PROVIDE to SHRA)"]
[null,"SNE",null,"Single/Non-Elderly",null,0.3,null,null,null,null,null,"VA","Veterans Benefits",null,null,null,null,null,null,null,2,null,null,"4) HUSM (PROVIDE to SHRA)"]
[null,"SP",null,"Single Parent",null,0.35,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,null,null,"5) Other"]
[null,"TP",null,"Two Parents",null,0.4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,null,null,null,null,0.45,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[null,"Hispanic Code",null,null,null,0.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Shared"]
[null,"Y","Yes",null,null,0.6]
[null,"N","No",null,null,0.7]
[null,null,null,null,null,0.8]
[null,null,null,null,null,1.1000000000000001]
[null,null,null,null,null,1.2]
[null,"Unit Status Report (USR)\n(Current as of 8-11-2021)"]
[]
[null,"Property Name:",null,null,"Street Address, City & Zip Code:",null,null,"Management Company Name:",null,null,null,null,"Total SHRA Units:",null,null,null,null,null," SHRA \nUnit Mix",null,"Percent\nof Total","Property Total Children age 0-5 ",null,null,null,"Property Total Children age 13-17"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Total other assisted units:",null,null,null,null,null,null,null,null,"Property Total Children age 6-12",null,null,null,"Property Total Children/Minors:",null,null,{"$f":"Y29+Y30+AC29","v":0}]
[null,"Unit Status Report Completed By:",null,null,"Position Title:",null,null,"Property Phone Number:",null,null,"Other Phone Number:",null,"Total market rate units:",null,null,null,null,null,"EL:",null,{"$f":"IF(T31>0,T31/R33,0)","v":0},"Utility Allowance Schedule (1-10)",null,null,"Select Utility Allowance"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Total exempt units",null,null,null,null,null,"VL :",null,{"$f":"IF(T32>0,T32/R33,0)","v":0},"Property Total Housing Choice Voucher (HCV) Tenants:"]
[null,"Email address:",null,null,null,null,null,"Reporting Period From:",null,null,"Reporting Period To:",null,"Property Total units:",null,null,null,null,{"$f":"SUM(R29:R32)","v":0},"LW:",null,{"$f":"IF(T33>0,T33/R33,0)","v":0},"Property Total Wheelchair Accessible units:"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Property Total Vacant units:",null,null,null,null,null,"MD:",null,{"$f":"IF(T34>0,T34/R33,0)","v":0},"Property Total ADA Compliant units "]
[]
[null,"Building","Unit #","HOH Last Name","Move-In","Hispanic","Race","HH","HH Gross  \nAnnual \nIncome*","HH\nSize",1,"% ","Source(s) of Income*",null,null,null,"Smoking","Unit","Unit","Tenant Monthly\nRent","Utility\nAllowance","Rent \nSubsidy","Gross\nMonthly\nRent","SHRA Funding Program(s)"]
[null,"No.","(include vacant SHRA Units)","or indicate \nVacant","Date*","Y / N",null,"Type*",null,"Size*","AMI*","AMI",1,2,3,4,"Y / N ","Size","Designation",null,null,null,null,1,2,3,4,5,6]
[1,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I38>0,I38/K38,\"0\")","v":"0"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(V38>0,T38+V38,T38+U38)","v":0}]
[2,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I39>0,I39/K39,\"0\")","v":"0"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(V39>0,T39+V39,T39+U39)","v":0}]
[3,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[4,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[5,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[6,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[7,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[8,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[9,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[10,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[11,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[12,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[13,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[14,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[15,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[16,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[17,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[18,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[19,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[20,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[21,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[22,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[23,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[24,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[25,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[26,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[27,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[28,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[29,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[30,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]

{"sheet":"USR Pg 11 (301-330) ","index":12,"n_rows":67,"n_cols":29,"rows_kept":67,"cut":false,"hidden":false,"merged":[[35,23,35,28],[35,8,36,8],[35,12,35,15],[35,19,36,19],[35,20,36,20],[35,21,36,21],[35,22,36,22],[33,1,33,6],[33,7,33,9],[33,10,33,11],[33,12,33,15],[33,21,33,26],[33,27,33,28],[32,1,32,6],[32,7,32,9],[32,10,32,11],[32,12,32,15],[32,21,32,26],[32,27,32,28],[30,21,30,23],[30,24,30,28],[31,1,31,3],[31,4,31,6],[31,7,31,9],[31,10,31,11],[31,21,31,26],[31,27,31,28],[29,4,29,6],[29,7,29,11],[29,12,29,15],[29,21,29,23],[29,25,29,27],[30,1,30,3],[30,4,30,6],[30,7,30,9],[30,10,30,11],[30,12,30,15],[13,1,13,3],[26,1,27,28],[28,1,28,3],[28,7,28,11],[28,12,28,15],[28,18,29,19],[28,20,29,20],[28,21,28,23],[28,25,28,27],[29,1,29,3]]}
[null,"Race/Ethnicity Codes",null,null,null,null,null,null,null,null,null,"Source(s) of Income Codes",null,null,null,null,null,null,null,null,"SHRA Funding Program(s) Codes"]
[null,"AIAN",null,"American Indian/Alaska Native",null,null,null,"100% AMI",null,null,null,"PA","Public Assitance( TANF, CALWorks, CALFresh, GA, Etc)",null,null,null,null,null,null,null,"BOND","Bond"]
[null,"AS",null,"Asian",null,null,null,1,63750,null,null,"AS","Asset(s)",null,null,null,null,null,null,null,"CDBG","Community Development Block Grant "]
[null,"BA",null,"Black/African American",null,null,null,2,72900,null,null,"CS","Child Support ",null,null,null,null,"Smoking Codes",null,null,"CII","City Inclusionary"]
[null,"HWOPI",null,"Hawaiian/Other Pacific Islander",null,null,null,3,82000,null,null,"EMP","Employment",null,null,null,null,"Y","Yes",null,"COI","County Inclusionary"]
[null,"WHT",null,"White",null,null,null,4,91100,null,null,"NIC","No Income Certification",null,null,null,null,"N","No",null,"DRL","Deferred Rehabilitation Loan"]
[null,"OTH",null,"Other",null,null,null,5,98400,null,null,"ONI","Other Non-wage Income",null,null,null,null,null,null,null,"HOME","HOME Investment Partnership"]
[null,null,null,null,null,null,null,6,105700,null,null,"OPA","Other  Public Assistance ",null,null,null,null,null,null,null,"HTF","Housing Trust Fund"]
[null,null,null,null,null,null,null,7,112950,null,null,"PR","Pension/Retirement",null,null,null,null,null,null,null,"MHSA","Mental Health Services Act"]
[null,null,null,null,null,null,null,8,120250,null,null,"RG","Recurring Gift",null,null,null,null,null,null,null,"NSP","Neighborhood Stabilization Program"]
[null,null,null,null,null,null,null,9,127550,null,null,"SDI","State Disability Insurance",null,null,null,null,null,null,null,"TI","Tax Increment"]
[null,null,null,null,null,null,null,10,134850,null,null,"SELF","Self-Employment"]
[null,null,null,null,null,null,null,11,142150,null,null,"SFA","Student Financial Assistance",null,null,null,null,null,null,null,"Unit Size",null,null,"Select Utility Allowance"]
[null,"H Type - Household Type Codes",null,null,null,null,null,12,{"$f":"I6*1.64","v":149404},null,null,"SS","Social Security Benefits",null,null,null,null,null,null,null,"SRO",null,null,"1) Apartment/Walk-Up"]
[null,"ELD",null,"Elderly",null,null,null,null,null,null,null,"SSI","Supplemental  Security Income ",null,null,null,null,null,null,null,"Studio",null,null,"2) RH, TH, SD & DX"]
[null,"OTH",null,"Other",null,"Unit Designation Codes",null,null,null,null,null,"UB","Unemployment Benefits",null,null,null,null,null,null,null,1,null,null,"3) CUAC (PROVIDE to SHRA)"]
[null,"SNE",null,"Single/Non-Elderly",null,0.3,null,null,null,null,null,"VA","Veterans Benefits",null,null,null,null,null,null,null,2,null,null,"4) HUSM (PROVIDE to SHRA)"]
[null,"SP",null,"Single Parent",null,0.35,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,null,null,"5) Other"]
[null,"TP",null,"Two Parents",null,0.4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,null,null,null,null,0.45,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[null,"Hispanic Code",null,null,null,0.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Shared"]
[null,"Y","Yes",null,null,0.6]
[null,"N","No",null,null,0.7]
[null,null,null,null,null,0.8]
[null,null,null,null,null,1.1000000000000001]
[null,null,null,null,null,1.2]
[null,"Unit Status Report (USR)\n(Current as of 8-11-2021)"]
[]
[null,"Property Name:",null,null,"Street Address, City & Zip Code:",null,null,"Management Company Name:",null,null,null,null,"Total SHRA Units:",null,null,null,null,null," SHRA \nUnit Mix",null,"Percent\nof Total","Property Total Children age 0-5 ",null,null,null,"Property Total Children age 13-17"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Total other assisted units:",null,null,null,null,null,null,null,null,"Property Total Children age 6-12",null,null,null,"Property Total Children/Minors:",null,null,{"$f":"Y29+Y30+AC29","v":0}]
[null,"Unit Status Report Completed By:",null,null,"Position Title:",null,null,"Property Phone Number:",null,null,"Other Phone Number:",null,"Total market rate units:",null,null,null,null,null,"EL:",null,{"$f":"IF(T31>0,T31/R33,0)","v":0},"Utility Allowance Schedule (1-10)",null,null,"Select Utility Allowance"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Total exempt units",null,null,null,null,null,"VL :",null,{"$f":"IF(T32>0,T32/R33,0)","v":0},"Property Total Housing Choice Voucher (HCV) Tenants:"]
[null,"Email address:",null,null,null,null,null,"Reporting Period From:",null,null,"Reporting Period To:",null,"Property Total units:",null,null,null,null,{"$f":"SUM(R29:R32)","v":0},"LW:",null,{"$f":"IF(T33>0,T33/R33,0)","v":0},"Property Total Wheelchair Accessible units:"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Property Total Vacant units:",null,null,null,null,null,"MD:",null,{"$f":"IF(T34>0,T34/R33,0)","v":0},"Property Total ADA Compliant units "]
[]
[null,"Building","Unit #","HOH Last Name","Move-In","Hispanic","Race","HH","HH Gross  \nAnnual \nIncome*","HH\nSize",1,"% ","Source(s) of Income*",null,null,null,"Smoking","Unit","Unit","Tenant Monthly\nRent","Utility\nAllowance","Rent \nSubsidy","Gross\nMonthly\nRent","SHRA Funding Program(s)"]
[null,"No.","(include vacant SHRA Units)","or indicate \nVacant","Date*","Y / N",null,"Type*",null,"Size*","AMI*","AMI",1,2,3,4,"Y / N ","Size","Designation",null,null,null,null,1,2,3,4,5,6]
[1,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I38>0,I38/K38,\"0\")","v":"0"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(V38>0,T38+V38,T38+U38)","v":0}]
[2,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I39>0,I39/K39,\"0\")","v":"0"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(V39>0,T39+V39,T39+U39)","v":0}]
[3,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[4,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[5,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[6,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[7,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[8,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[9,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[10,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[11,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[12,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[13,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[14,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[15,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[16,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[17,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[18,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[19,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[20,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[21,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[22,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[23,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[24,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[25,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[26,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[27,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[28,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[29,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[30,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]

{"sheet":"USR Pg 12 (331-360)","index":13,"n_rows":67,"n_cols":29,"rows_kept":67,"cut":false,"hidden":false,"merged":[[35,23,35,28],[35,8,36,8],[35,12,35,15],[35,19,36,19],[35,20,36,20],[35,21,36,21],[35,22,36,22],[33,1,33,6],[33,7,33,9],[33,10,33,11],[33,12,33,15],[33,21,33,26],[33,27,33,28],[32,1,32,6],[32,7,32,9],[32,10,32,11],[32,12,32,15],[32,21,32,26],[32,27,32,28],[30,21,30,23],[30,24,30,28],[31,1,31,3],[31,4,31,6],[31,7,31,9],[31,10,31,11],[31,21,31,26],[31,27,31,28],[29,4,29,6],[29,7,29,11],[29,12,29,15],[29,21,29,23],[29,25,29,27],[30,1,30,3],[30,4,30,6],[30,7,30,9],[30,10,30,11],[30,12,30,15],[13,1,13,3],[26,1,27,28],[28,1,28,3],[28,7,28,11],[28,12,28,15],[28,18,29,19],[28,20,29,20],[28,21,28,23],[28,25,28,27],[29,1,29,3]]}
[null,"Race/Ethnicity Codes",null,null,null,null,null,null,null,null,null,"Source(s) of Income Codes",null,null,null,null,null,null,null,null,"SHRA Funding Program(s) Codes"]
[null,"AIAN",null,"American Indian/Alaska Native",null,null,null,"100% AMI",null,null,null,"PA","Public Assitance( TANF, CALWorks, CALFresh, GA, Etc)",null,null,null,null,null,null,null,"BOND","Bond"]
[null,"AS",null,"Asian",null,null,null,1,63750,null,null,"AS","Asset(s)",null,null,null,null,null,null,null,"CDBG","Community Development Block Grant "]
[null,"BA",null,"Black/African American",null,null,null,2,72900,null,null,"CS","Child Support ",null,null,null,null,"Smoking Codes",null,null,"CII","City Inclusionary"]
[null,"HWOPI",null,"Hawaiian/Other Pacific Islander",null,null,null,3,82000,null,null,"EMP","Employment",null,null,null,null,"Y","Yes",null,"COI","County Inclusionary"]
[null,"WHT",null,"White",null,null,null,4,91100,null,null,"NIC","No Income Certification",null,null,null,null,"N","No",null,"DRL","Deferred Rehabilitation Loan"]
[null,"OTH",null,"Other",null,null,null,5,98400,null,null,"ONI","Other Non-wage Income",null,null,null,null,null,null,null,"HOME","HOME Investment Partnership"]
[null,null,null,null,null,null,null,6,105700,null,null,"OPA","Other  Public Assistance ",null,null,null,null,null,null,null,"HTF","Housing Trust Fund"]
[null,null,null,null,null,null,null,7,112950,null,null,"PR","Pension/Retirement",null,null,null,null,null,null,null,"MHSA","Mental Health Services Act"]
[null,null,null,null,null,null,null,8,120250,null,null,"RG","Recurring Gift",null,null,null,null,null,null,null,"NSP","Neighborhood Stabilization Program"]
[null,null,null,null,null,null,null,9,127550,null,null,"SDI","State Disability Insurance",null,null,null,null,null,null,null,"TI","Tax Increment"]
[null,null,null,null,null,null,null,10,134850,null,null,"SELF","Self-Employment"]
[null,null,null,null,null,null,null,11,142150,null,null,"SFA","Student Financial Assistance",null,null,null,null,null,null,null,"Unit Size",null,null,"Select Utility Allowance"]
[null,"H Type - Household Type Codes",null,null,null,null,null,12,{"$f":"I6*1.64","v":149404},null,null,"SS","Social Security Benefits",null,null,null,null,null,null,null,"SRO",null,null,"1) Apartment/Walk-Up"]
[null,"ELD",null,"Elderly",null,null,null,null,null,null,null,"SSI","Supplemental  Security Income ",null,null,null,null,null,null,null,"Studio",null,null,"2) RH, TH, SD & DX"]
[null,"OTH",null,"Other",null,"Unit Designation Codes",null,null,null,null,null,"UB","Unemployment Benefits",null,null,null,null,null,null,null,1,null,null,"3) CUAC (PROVIDE to SHRA)"]
[null,"SNE",null,"Single/Non-Elderly",null,0.3,null,null,null,null,null,"VA","Veterans Benefits",null,null,null,null,null,null,null,2,null,null,"4) HUSM (PROVIDE to SHRA)"]
[null,"SP",null,"Single Parent",null,0.35,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,null,null,"5) Other"]
[null,"TP",null,"Two Parents",null,0.4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,null,null,null,null,0.45,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[null,"Hispanic Code",null,null,null,0.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Shared"]
[null,"Y","Yes",null,null,0.6]
[null,"N","No",null,null,0.7]
[null,null,null,null,null,0.8]
[null,null,null,null,null,1.1000000000000001]
[null,null,null,null,null,1.2]
[null,"Unit Status Report (USR)\n(Current as of 8-11-2021)"]
[]
[null,"Property Name:",null,null,"Street Address, City & Zip Code:",null,null,"Management Company Name:",null,null,null,null,"Total SHRA Units:",null,null,null,null,null," SHRA \nUnit Mix",null,"Percent\nof Total","Property Total Children age 0-5 ",null,null,null,"Property Total Children age 13-17"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Total other assisted units:",null,null,null,null,null,null,null,null,"Property Total Children age 6-12",null,null,null,"Property Total Children/Minors:",null,null,{"$f":"Y29+Y30+AC29","v":0}]
[null,"Unit Status Report Completed By:",null,null,"Position Title:",null,null,"Property Phone Number:",null,null,"Other Phone Number:",null,"Total market rate units:",null,null,null,null,null,"EL:",null,{"$f":"IF(T31>0,T31/R33,0)","v":0},"Utility Allowance Schedule (1-10)",null,null,"Select Utility Allowance"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Total exempt units",null,null,null,null,null,"VL :",null,{"$f":"IF(T32>0,T32/R33,0)","v":0},"Property Total Housing Choice Voucher (HCV) Tenants:"]
[null,"Email address:",null,null,null,null,null,"Reporting Period From:",null,null,"Reporting Period To:",null,"Property Total units:",null,null,null,null,{"$f":"SUM(R29:R32)","v":0},"LW:",null,{"$f":"IF(T33>0,T33/R33,0)","v":0},"Property Total Wheelchair Accessible units:"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Property Total Vacant units:",null,null,null,null,null,"MD:",null,{"$f":"IF(T34>0,T34/R33,0)","v":0},"Property Total ADA Compliant units "]
[]
[null,"Building","Unit #","HOH Last Name","Move-In","Hispanic","Race","HH","HH Gross  \nAnnual \nIncome*","HH\nSize",1,"% ","Source(s) of Income*",null,null,null,"Smoking","Unit","Unit","Tenant Monthly\nRent","Utility\nAllowance","Rent \nSubsidy","Gross\nMonthly\nRent","SHRA Funding Program(s)"]
[null,"No.","(include vacant SHRA Units)","or indicate \nVacant","Date*","Y / N",null,"Type*",null,"Size*","AMI*","AMI",1,2,3,4,"Y / N ","Size","Designation",null,null,null,null,1,2,3,4,5,6]
[1,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I38>0,I38/K38,\"0\")","v":"0"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(V38>0,T38+V38,T38+U38)","v":0}]
[2,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I39>0,I39/K39,\"0\")","v":"0"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(V39>0,T39+V39,T39+U39)","v":0}]
[3,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[4,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[5,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[6,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[7,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[8,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[9,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[10,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[11,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[12,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[13,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[14,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[15,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[16,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[17,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[18,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[19,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[20,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[21,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[22,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[23,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[24,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[25,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[26,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[27,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[28,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[29,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]
[30,null,null,null,null,null,null,null,null,null,null,"0",null,null,null,null,null,null,null,null,null,null,0]