{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Summary","1. Sites Inventory","2. Development on Other Sites","3. ADUs"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Summary","index":0,"n_rows":17,"n_cols":5,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[null,"Lower","Moderate","Above Moderate","Total"]
["RHNA",1000,1500,2000,{"$f":"SUM(B2:D2)","v":4500}]
["Housing Element Sites Inventory"]
["Original Housing Element Capacity (Calculated)",{"$f":"SUM('1. Sites Inventory'!B:B)","v":1166},{"$f":"SUM('1. Sites Inventory'!C:C)","v":732},{"$f":"SUM('1. Sites Inventory'!D:D)","v":2019},{"$f":"SUM(B4:D4)","v":3917}]
["Entitled",{"$f":"SUM('1. Sites Inventory'!G:G)","v":2},{"$f":"SUM('1. Sites Inventory'!H:H)","v":5},{"$f":"SUM('1. Sites Inventory'!I:I)","v":7},14]
["Difference in Units for Entitled Projects (Capacity - Entitled)",{"$f":"SUM('1. Sites Inventory'!K:K)","v":2},{"$f":"SUM('1. Sites Inventory'!L:L)","v":-1},{"$f":"SUM('1. Sites Inventory'!M:M)","v":1},2]
["Remaining Capacity",{"$f":"B4-B5+B6","v":1166},{"$f":"C4-C5+C6","v":726},{"$f":"D4-D5+D6","v":2013},{"$f":"E4-E5","v":3903}]
["Total Capacity (Adjusted)",{"$f":"SUM(B7,B5)","v":1168},{"$f":"SUM(C7,C5)","v":731},2020,{"$f":"SUM(B8:D8)","v":3919}]
["2. Development Activity on Sites Not in HE",{"$f":"SUM('2. Development on Other Sites'!E:E)","v":11},{"$f":"SUM('2. Development on Other Sites'!F:F)","v":16},{"$f":"SUM('2. Development on Other Sites'!G:G)","v":201},{"$f":"SUM(B9:D9)","v":228}]
["3. ADU Projection",{"$f":"'3. ADUs'!B3","v":150},{"$f":"'3. ADUs'!C3","v":250},{"$f":"'3. ADUs'!D3","v":100},500]
["Total Housing Capacity",{"$f":"SUM(B9:B10)","v":161},{"$f":"SUM(C9:C10)","v":266},{"$f":"SUM(D9:D10)","v":301},728]
[]
["Progress Toward Meeting RHNA (Completed Projects)",{"$f":"SUM(B5,B9,'3. ADUs'!B15)","v":63},{"$f":"SUM(C5,C9,'3. ADUs'!C15)","v":111},{"$f":"SUM(D5,D9,'3. ADUs'!D15)","v":258},{"$f":"SUM(E5,E9,'3. ADUs'!E15)","v":432}]
["Remaining RHNA",{"$f":"B13-B2","v":-937},{"$f":"C13-C2","v":-1389},{"$f":"D13-D2","v":-1742},{"$f":"E13-E2","v":-4068}]
[]
[]
["Surplus/Deficit Capacity to Meet Unmet RHNA",{"$f":"B14+B11","v":-776},{"$f":"C14+C11","v":-1123},-1441,{"$f":"E14+E11","v":-3340}]

{"sheet":"1. Sites Inventory","index":1,"n_rows":103,"n_cols":15,"rows_kept":103,"cut":false,"hidden":false,"merged":[[0,1,0,4],[0,6,0,9],[0,10,0,13]]}
["ORIGINAL SITES INVENTORY","Capacity Counted in Housing Element (DO NOT EDIT)",null,null,null,null,"Current Entitlement",null,null,null,"Difference From Original Inventoried Capacity"]
["Assessor Parcel Number","Lower Income Capacity","Moderate Income Capacity","Above Moderate Income Capacity","Total Capacity","Site Status","Planned and Approved Lower Income","Planned and Approved Moderate Income","Planned and Approved Above Moderate Income","Total Planned and Approved","Net Capacity Lower Income","Net Capacity Moderate Income","Net Capacity Above Moderate Income","Total Net Capacity","Notes (APN Change, Project Name, etc.)"]
["XXX-XXX-XXX-X",0,3,3,{"$f":"SUM(B3:D3)","v":6},"Pending Project",1,4,6,0,{"$f":"IF($F3<>\"Available\", G3-B3, \"\")","v":1},{"$f":"IF($F3<>\"Available\", H3-C3, \"\")","v":1},{"$f":"IF($F3<>\"Available\", I3-D3, \"\")","v":3},{"$f":"SUM(K3:M3)","v":5}]
["XXX-XXX-XXX-X",0,3,3,{"$f":"SUM(B4:D4)","v":6},"Completed Project",1,1,1,0,{"$f":"IF($F4<>\"Available\", G4-B4, \"\")","v":1},-2,{"$f":"IF($F4<>\"Available\", I4-D4, \"\")","v":-2},{"$f":"SUM(K4:M4)","v":-3}]
["XXX-XXX-XXX-X",0,0,0,0,"Available",0,0,0,{"$f":"G5+H5+I5","v":0},{"$f":"IF($F5<>\"Available\", G5-B5, \"\")","v":""},{"$f":"IF($F5<>\"Available\", H5-C5, \"\")","v":""},{"$f":"IF($F5<>\"Available\", I5-D5, \"\")","v":""},{"$f":"IF($F5<>\"Available\", J5-E5, \"\")","v":""}]
["XXX-XXX-XXX-X",15,6,16,37,"Available",0,0,0,0,"","","",""]
["XXX-XXX-XXX-X",0,0,0,0,"Available",0,0,0,0,"","","",""]
["XXX-XXX-XXX-X",0,0,0,0,"Available",0,0,0,0,"","","",""]
["XXX-XXX-XXX-X",0,0,0,0,"Available",0,0,0,0,"","","",""]
["XXX-XXX-XXX-X",20,8,21,49,"Available",0,0,0,0,"","","",""]
["XXX-XXX-XXX-X",0,2,2,4,"Available",0,0,0,0,"","","",""]
["XXX-XXX-XXX-X",20,8,21,49,"Available",0,0,0,0,"","","",""]
["XXX-XXX-XXX-X",16,6,16,38,"Available",0,0,0,0,"","","",""]
["XXX-XXX-XXX-X",5,2,6,13,"Available",0,0,0,0,"","","",""]
["XXX-XXX-XXX-X",17,6,17,40,"Available",0,0,0,0,"","","",""]
["XXX-XXX-XXX-X",20,8,22,50,"Available",0,0,0,0,"","","",""]
["XXX-XXX-XXX-X",0,0,0,0,"Available",0,0,0,0,"","","",""]
["XXX-XXX-XXX-X",0,0,0,0,"Available",0,0,0,0,"","","",""]
["XXX-XXX-XXX-X",0,0,0,0,"Available",0,0,0,0,"","","",""]
["XXX-XXX-XXX-X",0,0,0,0,"Available",0,0,0,0,"","","",""]
["XXX-XXX-XXX-X",0,0,0,0,"Available",0,0,0,0,"","","",""]
["XXX-XXX-XXX-X",30,12,31,73,"Available",0,0,0,0,"","","",""]
["XXX-XXX-XXX-X",0,0,0,0,"Available",0,0,0,0,"","","",""]
["XXX-XXX-XXX-X",0,0,0,0,"Available",0,0,0,0,"","","",""]
["XXX-XXX-XXX-X",0,0,0,0,"Available",0,0,0,0,"","","",""]
["XXX-XXX-XXX-X",0,0,0,0,"Available",0,0,0,0,"","","",""]
["XXX-XXX-XXX-X",0,0,7,7,"Available",0,0,0,0,"","","",""]
["XXX-XXX-XXX-X",41,16,42,99,"Available",0,0,0,0,"","","",""]
["XXX-XXX-XXX-X",19,7,20,46,"Available",0,0,0,0,"","","",""]
["XXX-XXX-XXX-X",8,3,9,20,"Available",0,0,0,0,"","","",""]
["XXX-XXX-XXX-X",29,11,30,70,"Available",0,0,0,0,"","","",""]
["XXX-XXX-XXX-X",0,8,8,16,"Available",0,0,0,0,"","","",""]
["XXX-XXX-XXX-X",14,6,15,35,"Available",0,0,0,0,"","","",""]
["XXX-XXX-XXX-X",0,0,6,6,"Available",0,0,0,0,"","","",""]
["XXX-XXX-XXX-X",0,1,1,2,"Available",0,0,0,0,"","","",""]
["XXX-XXX-XXX-X",0,0,8,8,"Available",0,0,0,0,"","","",""]
["XXX-XXX-XXX-X",0,0,6,6,"Available",0,0,0,0,"","","",""]
["XXX-XXX-XXX-X",0,0,6,6,"Available",0,0,0,0,"","","",""]
["XXX-XXX-XXX-X",0,0,6,6,"Available",0,0,0,0,"","","",""]
["XXX-XXX-XXX-X",0,0,10,10,"Available",0,0,0,0,"","","",""]
["XXX-XXX-XXX-X",0,0,7,7,"Available",0,0,0,0,"","","",""]
["XXX-XXX-XXX-X",0,0,5,5,"Available",0,0,0,0,"","","",""]
["XXX-XXX-XXX-X",0,0,5,5,"Available",0,0,0,0,"","","",""]
["XXX-XXX-XXX-X",0,0,6,6,"Available",0,0,0,0,"","","",""]
["XXX-XXX-XXX-X",0,0,6,6,"Available",0,0,0,0,"","","",""]
["XXX-XXX-XXX-X",0,0,3,3,"Available",0,0,0,0,"","","",""]
["XXX-XXX-XXX-X",0,0,5,5,"Available",0,0,0,0,"","","",""]
["XXX-XXX-XXX-X",0,0,2,2,"Available",0,0,0,0,"","","",""]
["XXX-XXX-XXX-X",0,0,2,2,"Available",0,0,0,0,"","","",""]
["XXX-XXX-XXX-X",0,0,6,6,"Available",0,0,0,0,"","","",""]
["XXX-XXX-XXX-X",0,0,11,11,"Available",0,0,0,0,"","","",""]
["XXX-XXX-XXX-X",0,0,2,2,"Available",0,0,0,0,"","","",""]
["XXX-XXX-XXX-X",0,0,2,2,"Available",0,0,0,0,"","","",""]
["XXX-XXX-XXX-X",0,0,5,5,"Available",0,0,0,0,"","","",""]
["XXX-XXX-XXX-X",44,17,46,107,"Available",0,0,0,0,"","","",""]
["XXX-XXX-XXX-X",44,17,46,107,"Available",0,0,0,0,"","","",""]
["XXX-XXX-XXX-X",16,6,17,39,"Available",0,0,0,0,"","","",""]
["XXX-XXX-XXX-X",9,4,10,23,"Available",0,0,0,0,"","","",""]
["XXX-XXX-XXX-X",50,20,52,122,"Available",0,0,0,0,"","","",""]
["XXX-XXX-XXX-X",33,13,34,80,"Available",0,0,0,0,"","","",""]
["XXX-XXX-XXX-X",52,20,53,125,"Available",0,0,0,0,"","","",""]
["XXX-XXX-XXX-X",0,1,1,2,"Available",0,0,0,0,"","","",""]
["XXX-XXX-XXX-X",25,10,26,61,"Available",0,0,0,0,"","","",""]
["XXX-XXX-XXX-X",8,3,8,19,"Available",0,0,0,0,"","","",""]
["XXX-XXX-XXX-X",42,17,44,103,"Available",0,0,0,0,"","","",""]
["XXX-XXX-XXX-X",0,24,24,48,"Available",0,0,0,0,"","","",""]
["XXX-XXX-XXX-X",50,20,52,122,"Available",0,0,0,0,"","","",""]
["XXX-XXX-XXX-X",58,23,60,{"$f":"SUM(B68:D68)","v":141},"Available",0,0,0,0,"","","",""]
["XXX-XXX-XXX-X",11,4,11,26,"Available",0,0,0,{"$f":"G69+H69+I69","v":0},{"$f":"IF($F69<>\"Available\", G69-B69, \"\")","v":""},{"$f":"IF($F69<>\"Available\", H69-C69, \"\")","v":""},{"$f":"IF($F69<>\"Available\", I69-D69, \"\")","v":""},{"$f":"IF($F69<>\"Available\", J69-E69, \"\")","v":""}]
["XXX-XXX-XXX-X",12,5,13,30,"Available",0,0,0,0,"","","",""]
["XXX-XXX-XXX-X",0,41,41,82,"Available",0,0,0,0,"","","",""]
["XXX-XXX-XXX-X",0,39,39,78,"Available",0,0,0,0,"","","",""]
["XXX-XXX-XXX-X",0,9,9,18,"Available",0,0,0,0,"","","",""]
["XXX-XXX-XXX-X",0,13,13,26,"Available",0,0,0,0,"","","",""]
["XXX-XXX-XXX-X",38,15,39,92,"Available",0,0,0,0,"","","",""]
["XXX-XXX-XXX-X",21,8,22,51,"Available",0,0,0,0,"","","",""]
["XXX-XXX-XXX-X",0,0,216,216,"Available",0,0,0,0,"","","",""]
["XXX-XXX-XXX-X",36,14,38,88,"Available",0,0,0,0,"","","",""]
["XXX-XXX-XXX-X",23,9,24,56,"Available",0,0,0,0,"","","",""]
["XXX-XXX-XXX-X",98,38,100,236,"Available",0,0,0,0,"","","",""]
["XXX-XXX-XXX-X",0,5,5,10,"Available",0,0,0,0,"","","",""]
["XXX-XXX-XXX-X",0,0,134,134,"Available",0,0,0,0,"","","",""]
["XXX-XXX-XXX-X",4,0,70,74,"Available",0,0,0,0,"","","",""]
["XXX-XXX-XXX-X",0,10,10,20,"Available",0,0,0,0,"","","",""]
["XXX-XXX-XXX-X",0,5,5,10,"Available",0,0,0,0,"","","",""]
["XXX-XXX-XXX-X",0,10,10,20,"Available",0,0,0,0,"","","",""]
["XXX-XXX-XXX-X",0,3,3,6,"Available",0,0,0,0,"","","",""]
["XXX-XXX-XXX-X",14,6,15,35,"Available",0,0,0,0,"","","",""]
["XXX-XXX-XXX-X",126,50,129,305,"Available",0,0,0,0,"","","",""]
["XXX-XXX-XXX-X",0,6,6,12,"Available",0,0,0,0,"","","",""]
["XXX-XXX-XXX-X",11,4,11,26,"Available",0,0,0,0,"","","",""]
["XXX-XXX-XXX-X",56,22,58,136,"Available",0,0,0,0,"","","",""]
["XXX-XXX-XXX-X",0,4,4,8,"Available",0,0,0,0,"","","",""]
["XXX-XXX-XXX-X",17,7,18,42,"Available",0,0,0,0,"","","",""]
["XXX-XXX-XXX-X",14,5,15,34,"Available",0,0,0,0,"","","",""]
["XXX-XXX-XXX-X",0,9,9,18,"Available",0,0,0,0,"","","",""]
["XXX-XXX-XXX-X",0,31,31,62,"Available",0,0,0,0,"","","",""]
["XXX-XXX-XXX-X",0,38,38,76,"Available",0,0,0,0,"","","",""]
["XXX-XXX-XXX-X",0,9,9,18,"Available",0,0,0,0,"","","",""]
["XXX-XXX-XXX-X",0,0,0,0,"Available",0,0,0,0,"","","",""]
["XXX-XXX-XXX-X",0,0,0,0,"Available",0,0,0,0,"","","",""]
["XXX-XXX-XXX-X",0,0,0,0,"Available",0,0,0,0,"","","",""]
["XXX-XXX-XXX-X",0,2,2,4,"Available",0,0,0,0,"","","",""]

{"sheet":"2. Development on Other Sites","index":2,"n_rows":22,"n_cols":10,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,4,0,7]]}
["PROJECTS ON OTHER SITES",null,null,null,"Current Entitlement"]
["Assessor Parcel Number","JURS_TRACKING_ID","Project Name","Address","Lower Income Capacity","Moderate Income Capacity","Above Moderate Income Capacity","Total Capacity","Site Status","Notes (Approval Date, Status, etc.)"]
["XXX-XXX-XXX-X",null,null,null,0,0,0,{"$f":"SUM(E3:G3)","v":0},"Pending Project"]
["XXX-XXX-XXX-X",null,null,null,0,0,0,{"$f":"SUM(E4:G4)","v":0},"Pending Project"]
["XXX-XXX-XXX-X",null,null,null,0,0,0,0,"Pending Project"]
["XXX-XXX-XXX-X",null,null,null,0,0,0,0,"Pending Project"]
["XXX-XXX-XXX-X",null,null,null,1,1,1,3,"Completed Project"]
["XXX-XXX-XXX-X",null,null,null,0,0,0,0]
["XXX-XXX-XXX-X",null,null,null,0,0,0,0]
["XXX-XXX-XXX-X",null,null,null,10,15,200,225]
["XXX-XXX-XXX-X",null,null,null,0,0,0,0]
["XXX-XXX-XXX-X",null,null,null,0,0,0,0]
["XXX-XXX-XXX-X",null,null,null,0,0,0,0]
["XXX-XXX-XXX-X",null,null,null,0,0,0,0]
["XXX-XXX-XXX-X",null,null,null,0,0,0,0]
["XXX-XXX-XXX-X",null,null,null,0,0,0,0]
["XXX-XXX-XXX-X",null,null,null,0,0,0,0]
["XXX-XXX-XXX-X",null,null,null,0,0,0,0]
["XXX-XXX-XXX-X",null,null,null,0,0,0,0]
["XXX-XXX-XXX-X",null,null,null,0,0,0,0]
["XXX-XXX-XXX-X",null,null,null,0,0,0,0]
["XXX-XXX-XXX-X",null,null,null,0,0,0,0]

{"sheet":"3. ADUs","index":3,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["ADU Production"]
[null,"Lower Income Capacity","Moderate Income Capacity","Above Moderate Income Capacity","Total Capacity"]
["ADU Projection",150,250,100,{"$f":"SUM(B3:D3)","v":500}]
["ADU Production from APR"]
["June 30, 2020-End of 2020",5,15,5,{"$f":"SUM(B5:D5)","v":25}]
[2021,10,20,10,40]
[2022,15,25,15,55]
[2023,20,30,20,{"$f":"SUM(B8:D8)","v":70}]
[2024,0,0,0,{"$f":"SUM(B9:D9)","v":0}]
[2025,0,0,0,0]
[2026,0,0,0,0]
[2027,0,0,0,0]
[2028,0,0,0,0]
["Jan 1, 2029-April 15, 2029",0,0,0,0]
["Total Production",{"$f":"SUM(B5:B14)","v":50},{"$f":"SUM(C5:C14)","v":90},50,{"$f":"SUM(B15:D15)","v":190}]