{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Summary","1. Sites Inventory","2. Planned Projects","3. Development on Other Sites","4. Rezoned Sites","5. 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":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[null,"Lower","Moderate","Above Moderate","Total"]
["RHNA",1000,1000,1000,{"$f":"SUM(B2:D2)","v":3000}]
["1. Remaining Capacity on HE Sites",{"$f":"SUM('1. Sites Inventory'!B:B,'1. Sites Inventory'!K:K)","v":1167},{"$f":"SUM('1. Sites Inventory'!C:C,'1. Sites Inventory'!L:L)","v":727},{"$f":"SUM('1. Sites Inventory'!D:D,'1. Sites Inventory'!M:M)","v":2014},3908]
["2. Planned and Approved Projects from HE",{"$f":"SUM('2. Planned Projects'!I:I)","v":1},{"$f":"SUM('2. Planned Projects'!J:J)","v":1},{"$f":"SUM('2. Planned Projects'!K:K)","v":1},{"$f":"SUM(B4:D4)","v":3}]
["3. Development Activity on Sites Not in HE",{"$f":"SUM('3. Development on Other Sites'!D:D)","v":1},{"$f":"SUM('3. Development on Other Sites'!E:E)","v":1},{"$f":"SUM('3. Development on Other Sites'!F:F)","v":1},3]
["4. Rezoned Sites (if applicable)",{"$f":"SUM('4. Rezoned Sites'!B:B,'4. Rezoned Sites'!K:K)","v":1},{"$f":"SUM('4. Rezoned Sites'!C:C,'4. Rezoned Sites'!L:L)","v":1},{"$f":"SUM('4. Rezoned Sites'!D:D,'4. Rezoned Sites'!M:M)","v":1},{"$f":"SUM(B6:D6)","v":3}]
["5a. ADU Projection",{"$f":"'5. ADUs'!B3","v":0},{"$f":"'5. ADUs'!C3","v":0},{"$f":"'5. ADUs'!D3","v":0},0]
["5b. ADU Production Above Projection",{"$f":"IF('5. ADUs'!B16=\"\",0,'5. ADUs'!B16)","v":1},{"$f":"IF('5. ADUs'!C16=\"\",0,'5. ADUs'!C16)","v":1},{"$f":"IF('5. ADUs'!D16=\"\",0,'5. ADUs'!D16)","v":1},3]
["Total Capacity",{"$f":"SUM(B3:B8)","v":1171},{"$f":"SUM(C3:C8)","v":731},2018,3920]
["Surplus/Deficit",{"$f":"B9-B2","v":171},{"$f":"C9-C2","v":-269},{"$f":"D9-D2","v":1018},{"$f":"E9-E2","v":920}]
[]
["Progress Toward Meeting RHNA (Completed Projects)",{"$f":"SUMIF('1. Sites Inventory'!F:F,\"Completed Project\",'1. Sites Inventory'!G:G)+SUMIF('2. Planned Projects'!H:H,\"Completed Project\",'2. Planned Projects'!I:I)+SUM('3. Development on Other Sites'!D:D)+SUMIF('4. Rezoned Sites'!F:F,\"Completed Project\",'4. Rezoned Sites'!G:G)+'5. ADUs'!B15","v":5},{"$f":"SUMIF('1. Sites Inventory'!F:F,\"Completed Project\",'1. Sites Inventory'!H:H)+SUMIF('2. Planned Projects'!H:H,\"Completed Project\",'2. Planned Projects'!J:J)+SUM('3. Development on Other Sites'!E:E)+SUMIF('4. Rezoned Sites'!F:F,\"Completed Project\",'4. Rezoned Sites'!H:H)+'5. ADUs'!C15","v":5},{"$f":"SUMIF('1. Sites Inventory'!F:F,\"Completed Project\",'1. Sites Inventory'!I:I)+SUMIF('2. Planned Projects'!H:H,\"Completed Project\",'2. Planned Projects'!K:K)+SUM('3. Development on Other Sites'!F:F)+SUMIF('4. Rezoned Sites'!F:F,\"Completed Project\",'4. Rezoned Sites'!I:I)+'5. ADUs'!D15","v":5},{"$f":"SUM(B12:D12)","v":15}]
["Remaining RHNA",{"$f":"SUM(B7:B12)","v":1348},{"$f":"SUM(C7:C12)","v":468},3042,4858]

{"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.)"]
["068-051-015-3",0,3,3,{"$f":"SUM(B3:D3)","v":6},"Pending Project",0,0,0,0,{"$f":"IF($F3<>\"Available\", G3-B3, \"\")","v":0},{"$f":"IF($F3<>\"Available\", H3-C3, \"\")","v":-3},{"$f":"IF($F3<>\"Available\", I3-D3, \"\")","v":-3},{"$f":"IF($F3<>\"Available\", J3-E3, \"\")","v":-6}]
["068-051-049-2",0,3,3,{"$f":"SUM(B4:D4)","v":6},"Completed Project",1,1,1,0,1,-2,-2,-6]
["068-051-050-0",0,0,0,0,"Available",0,0,0,{"$f":"G5+H5+I5","v":0},"","","",""]
["068-252-041-6",15,6,16,37,"Available",0,0,0,0,"","","",""]
["068-252-043-2",0,0,0,0,"Available",0,0,0,0,"","","",""]
["068-252-042-4",0,0,0,0,"Available",0,0,0,0,"","","",""]
["068-252-045-7",0,0,0,0,"Available",0,0,0,0,"","","",""]
["072-400-039-3",20,8,21,49,"Available",0,0,0,0,"","","",""]
["072-400-040-1",0,2,2,4,"Available",0,0,0,0,"","","",""]
["072-400-036-9",20,8,21,49,"Available",0,0,0,0,"","","",""]
["065-122-023-8",16,6,16,38,"Available",0,0,0,0,"","","",""]
["065-122-028-7",5,2,6,13,"Available",0,0,0,0,"","","",""]
["065-122-029-5",17,6,17,40,"Available",0,0,0,0,"","","",""]
["065-122-030-3",20,8,22,50,"Available",0,0,0,0,"","","",""]
["051-390-001-9",0,0,0,0,"Available",0,0,0,0,"","","",""]
["051-390-002-7",0,0,0,0,"Available",0,0,0,0,"","","",""]
["051-390-003-5",0,0,0,0,"Available",0,0,0,0,"","","",""]
["051-390-004-3",0,0,0,0,"Available",0,0,0,0,"","","",""]
["051-390-005-0",0,0,0,0,"Available",0,0,0,0,"","","",""]
["051-390-006-8",30,12,31,73,"Available",0,0,0,0,"","","",""]
["051-390-009-2",0,0,0,0,"Available",0,0,0,0,"","","",""]
["051-390-010-0",0,0,0,0,"Available",0,0,0,0,"","","",""]
["051-390-011-8",0,0,0,0,"Available",0,0,0,0,"","","",""]
["051-390-016-7",0,0,0,0,"Available",0,0,0,0,"","","",""]
["051-120-021-4",0,0,7,7,"Available",0,0,0,0,"","","",""]
["051-200-065-4",41,16,42,99,"Available",0,0,0,0,"","","",""]
["056-130-014-6",19,7,20,46,"Available",0,0,0,0,"","","",""]
["068-251-012",8,3,9,20,"Available",0,0,0,0,"","","",""]
["071-130-026-9",29,11,30,70,"Available",0,0,0,0,"","","",""]
["071-370-026-8",0,8,8,16,"Available",0,0,0,0,"","","",""]
["076-231-007-6",14,6,15,35,"Available",0,0,0,0,"","","",""]
["051-130-002-2",0,0,6,6,"Available",0,0,0,0,"","","",""]
["065-161-025-5",0,1,1,2,"Available",0,0,0,0,{"$f":"IF($F35<>\"Available\", G35-B35, \"\")","v":""},{"$f":"IF($F35<>\"Available\", H35-C35, \"\")","v":""},{"$f":"IF($F35<>\"Available\", I35-D35, \"\")","v":""},{"$f":"IF($F35<>\"Available\", J35-E35, \"\")","v":""}]
["051-120-020-6",0,0,8,8,"Available",0,0,0,0,"","","",""]
["051-120-024-8",0,0,6,6,"Available",0,0,0,0,"","","",""]
["051-120-025-5",0,0,6,6,"Available",0,0,0,0,"","","",""]
["051-130-001-4",0,0,6,6,"Available",0,0,0,0,"","","",""]
["051-140-001-2",0,0,10,10,"Available",0,0,0,0,"","","",""]
["051-140-003-8",0,0,7,7,"Available",0,0,0,0,"","","",""]
["051-140-006-1",0,0,5,5,"Available",0,0,0,0,"","","",""]
["051-140-007-9",0,0,5,5,"Available",0,0,0,0,"","","",""]
["051-140-012-9",0,0,6,6,"Available",0,0,0,0,"","","",""]
["051-140-013-7",0,0,6,6,"Available",0,0,0,0,"","","",""]
["051-140-014-5",0,0,3,3,"Available",0,0,0,0,"","","",""]
["051-140-015-2",0,0,5,5,"Available",0,0,0,0,"","","",""]
["051-140-019-4",0,0,2,2,"Available",0,0,0,0,"","","",""]
["051-140-020-2",0,0,2,2,"Available",0,0,0,0,"","","",""]
["051-140-025-1",0,0,6,6,"Available",0,0,0,0,"","","",""]
["051-140-026-9",0,0,11,11,"Available",0,0,0,0,"","","",""]
["051-140-027-7",0,0,2,2,"Available",0,0,0,0,"","","",""]
["051-140-028-5",0,0,2,2,"Available",0,0,0,0,"","","",""]
["051-140-035-0",0,0,5,5,"Available",0,0,0,0,"","","",""]
["051-200-037-3",44,17,46,107,"Available",0,0,0,0,"","","",""]
["052-042-037-3",44,17,46,107,"Available",0,0,0,0,"","","",""]
["052-042-044-9",16,6,17,39,"Available",0,0,0,0,"","","",""]
["052-061-014-8",9,4,10,23,"Available",0,0,0,0,"","","",""]
["052-061-053-6",50,20,52,122,"Available",0,0,0,0,"","","",""]
["056-120-096-5",33,13,34,80,"Available",0,0,0,0,"","","",""]
["056-130-011-2",52,20,53,125,"Available",0,0,0,0,"","","",""]
["065-071-020-5",0,1,1,2,"Available",0,0,0,0,"","","",""]
["065-110-007-5",25,10,26,61,"Available",0,0,0,0,"","","",""]
["068-091-043-7",8,3,8,19,"Available",0,0,0,0,"","","",""]
["072-011-067-5",42,17,44,103,"Available",0,0,0,0,"","","",""]
["051-100-022-6",0,24,24,48,"Available",0,0,0,0,"","","",""]
["051-200-038-1",50,20,52,122,"Available",0,0,0,0,{"$f":"IF($F67<>\"Available\", G67-B67, \"\")","v":""},{"$f":"IF($F67<>\"Available\", H67-C67, \"\")","v":""},{"$f":"IF($F67<>\"Available\", I67-D67, \"\")","v":""},{"$f":"IF($F67<>\"Available\", J67-E67, \"\")","v":""}]
["051-200-039-9",58,23,60,{"$f":"SUM(B68:D68)","v":141},"Available",0,0,0,{"$f":"G68+H68+I68","v":0},"","","",""]
["051-200-076-1",11,4,11,26,"Available",0,0,0,0,"","","",""]
["051-230-028-6",12,5,13,30,"Available",0,0,0,0,"","","",""]
["052-140-013-5",0,41,41,82,"Available",0,0,0,0,"","","",""]
["052-140-014-3",0,39,39,78,"Available",0,0,0,0,"","","",""]
["052-140-015-0",0,9,9,18,"Available",0,0,0,0,"","","",""]
["052-140-016-8",0,13,13,26,"Available",0,0,0,0,"","","",""]
["052-342-010-7",38,15,39,92,"Available",0,0,0,0,"","","",""]
["052-370-009-4",21,8,22,51,"Available",0,0,0,0,"","","",""]
["053-060-063-4",0,0,216,216,"Available",0,0,0,0,"","","",""]
["055-071-106-3",36,14,38,88,"Available",0,0,0,0,"","","",""]
["055-071-107-1",23,9,24,56,"Available",0,0,0,0,"","","",""]
["055-071-108-9",98,38,100,236,"Available",0,0,0,0,"","","",""]
["055-071-113-9",0,5,5,10,"Available",0,0,0,0,"","","",""]
["056-120-098-1",0,0,134,134,"Available",0,0,0,0,"","","",""]
["065-110-006-7",4,0,70,74,"Available",0,0,0,0,"","","",""]
["065-262-026-1",0,10,10,20,"Available",0,0,0,0,"","","",""]
["065-262-035-2",0,5,5,10,"Available",0,0,0,0,"","","",""]
["067-103-017-9",0,10,10,20,"Available",0,0,0,0,"","","",""]
["068-082-057-8",0,3,3,6,"Available",0,0,0,0,"","","",""]
["072-450-013-7",14,6,15,35,"Available",0,0,0,0,"","","",""]
["074-080-026-3",126,50,129,305,"Available",0,0,0,0,"","","",""]
["074-080-028-9",0,6,6,12,"Available",0,0,0,0,"","","",""]
["074-080-029-7",11,4,11,26,"Available",0,0,0,0,"","","",""]
["074-080-030-5",56,22,58,136,"Available",0,0,0,0,"","","",""]
["074-122-016-4",0,4,4,8,"Available",0,0,0,0,"","","",""]
["074-123-004-9",17,7,18,42,"Available",0,0,0,0,"","","",""]
["074-123-005-6",14,5,15,34,"Available",0,0,0,0,"","","",""]
["074-343-034-0",0,9,9,18,"Available",0,0,0,0,"","","",""]
["075-460-001-3",0,31,31,62,"Available",0,0,0,0,"","","",""]
["076-010-039-6",0,38,38,76,"Available",0,0,0,0,"","","",""]
["051-400-027-2",0,9,9,18,"Available",0,0,0,0,"","","",""]
["053-060-055-0",0,0,0,0,"Available",0,0,0,0,"","","",""]
["053-060-056-8",0,0,0,0,"Available",0,0,0,0,"","","",""]
["053-060-057-6",0,0,0,0,"Available",0,0,0,0,"","","",""]
["067-093-022-1",0,2,2,4,"Available",0,0,0,0,"","","",""]

{"sheet":"2. Planned Projects","index":2,"n_rows":27,"n_cols":17,"rows_kept":27,"cut":false,"hidden":false,"merged":[[1,3,1,6],[1,8,1,11],[1,12,1,15]]}
["PLANNED AND APPROVED PROJECT LIST FROM HOUSING ELEMENT"]
[null,null,null,"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","Address","Project Name","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, Changes in Entitlement)"]
["XXX-XXX-XXX-X",null,null,0,0,0,{"$f":"SUM(D4:F4)","v":0},"Completed Project",0,0,0,{"$f":"I4+J4+K4","v":0},{"$f":"IF($H4<>\"Available\", I4-D4, \"\")","v":0},{"$f":"IF($H4<>\"Available\", J4-E4, \"\")","v":0},{"$f":"IF($H4<>\"Available\", K4-F4, \"\")","v":0},{"$f":"IF($H4<>\"Available\", L4-G4, \"\")","v":0},"The calculation is backwards."]
["XXX-XXX-XXX-X",null,null,0,0,0,{"$f":"SUM(D5:F5)","v":0},"Completed Project",1,1,1,{"$f":"I5+J5+K5","v":3},1,1,1,3]
["XXX-XXX-XXX-X",null,null,0,0,0,0,"Pending Project",0,0,0,0,0,0,0,0]
["XXX-XXX-XXX-X",null,null,0,0,0,0,"Pending Project",0,0,0,0,0,0,0,0]
["XXX-XXX-XXX-X",null,null,0,0,0,0,"Pending Project",0,0,0,0,0,0,0,0]
["XXX-XXX-XXX-X",null,null,0,0,0,0,"Pending Project",0,0,0,0,0,0,0,0]
["XXX-XXX-XXX-X",null,null,0,0,0,0,"Pending Project",0,0,0,0,0,0,0,0]
["XXX-XXX-XXX-X",null,null,0,0,0,0,"Pending Project",0,0,0,0,0,0,0,0]
["XXX-XXX-XXX-X",null,null,0,0,0,0,"Pending Project",0,0,0,0,0,0,0,0]
["XXX-XXX-XXX-X",null,null,0,0,0,0,"Pending Project",0,0,0,0,0,0,0,0]
["XXX-XXX-XXX-X",null,null,0,0,0,0,"Pending Project",0,0,0,0,0,0,0,0]
["XXX-XXX-XXX-X",null,null,0,0,0,0,"Pending Project",0,0,0,0,0,0,0,0]
["XXX-XXX-XXX-X",null,null,0,0,0,0,"Pending Project",0,0,0,0,0,0,0,0]
["XXX-XXX-XXX-X",null,null,0,0,0,0,"Pending Project",0,0,0,0,0,0,0,0]
["XXX-XXX-XXX-X",null,null,0,0,0,0,"Pending Project",0,0,0,0,0,0,0,0]
["XXX-XXX-XXX-X",null,null,0,0,0,0,"Pending Project",0,0,0,0,0,0,0,0]
["XXX-XXX-XXX-X",null,null,0,0,0,0,"Pending Project",0,0,0,0,0,0,0,0]
["XXX-XXX-XXX-X",null,null,0,0,0,0,"Pending Project",0,0,0,0,0,0,0,0]
["XXX-XXX-XXX-X",null,null,0,0,0,0,"Pending Project",0,0,0,0,0,0,0,0]
["XXX-XXX-XXX-X",null,null,0,0,0,0,"Pending Project",0,0,0,0,0,0,0,0]
["XXX-XXX-XXX-X",null,null,0,0,0,0,"Pending Project",0,0,0,0,0,0,0,0]
["XXX-XXX-XXX-X",null,null,0,0,0,0,"Pending Project",0,0,0,0,0,0,0,0]
["XXX-XXX-XXX-X",null,null,0,0,0,0,"Pending Project",0,0,0,0,0,0,0,0]
["XXX-XXX-XXX-X",null,null,0,0,0,0,"Pending Project",0,0,0,0,0,0,0,0]

{"sheet":"3. Development on Other Sites","index":3,"n_rows":22,"n_cols":9,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,3,0,6]]}
["PROJECTS ON OTHER SITES",null,null,"Current Entitlement"]
["Assessor Parcel Number","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,0,0,0,{"$f":"SUM(D3:F3)","v":0},"Pending Project"]
["XXX-XXX-XXX-X",null,null,0,0,0,{"$f":"SUM(D4:F4)","v":0},"Pending Project"]
["XXX-XXX-XXX-X",null,null,0,0,0,0,"Pending Project"]
["XXX-XXX-XXX-X",null,null,0,0,0,0,"Pending Project"]
["XXX-XXX-XXX-X",null,null,1,1,1,3,"Completed Project"]
["XXX-XXX-XXX-X",null,null,0,0,0,0]
["XXX-XXX-XXX-X",null,null,0,0,0,0]
["XXX-XXX-XXX-X",null,null,0,0,0,0]
["XXX-XXX-XXX-X",null,null,0,0,0,0]
["XXX-XXX-XXX-X",null,null,0,0,0,0]
["XXX-XXX-XXX-X",null,null,0,0,0,0]
["XXX-XXX-XXX-X",null,null,0,0,0,0]
["XXX-XXX-XXX-X",null,null,0,0,0,0]
["XXX-XXX-XXX-X",null,null,0,0,0,0]
["XXX-XXX-XXX-X",null,null,0,0,0,0]
["XXX-XXX-XXX-X",null,null,0,0,0,0]
["XXX-XXX-XXX-X",null,null,0,0,0,0]
["XXX-XXX-XXX-X",null,null,0,0,0,0]
["XXX-XXX-XXX-X",null,null,0,0,0,0]
["XXX-XXX-XXX-X",null,null,0,0,0,0]

{"sheet":"4. Rezoned Sites","index":4,"n_rows":22,"n_cols":16,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,6,0,9],[0,1,0,4]]}
["REZONED SITES","Capacity Counted in Housing Element",null,null,null,null,"Current Entitlement"]
["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","Date of Rezone ","Notes"]
["XXX-XXX-XXX-X",1,1,0,{"$f":"SUM(B3:D3)","v":2},"Completed Project",1,1,1,{"$f":"G3+H3+I3","v":3},{"$f":"IF($H3<>\"Available\", G3-B3, \"\")","v":0},{"$f":"IF($H3<>\"Available\", H3-C3, \"\")","v":0},{"$f":"IF($H3<>\"Available\", I3-D3, \"\")","v":1},{"$f":"IF($H3<>\"Available\", J3-E3, \"\")","v":1}]
["XXX-XXX-XXX-X",0,0,0,{"$f":"SUM(B4:D4)","v":0},"Available",0,0,0,{"$f":"G4+H4+I4","v":0},0,0,0,0]
["XXX-XXX-XXX-X",0,0,0,0,"Available",0,0,0,0,0,0,0,0]
["XXX-XXX-XXX-X",0,0,0,0,"Available",0,0,0,0,0,0,0,0]
["XXX-XXX-XXX-X",0,0,0,0,"Available",0,0,0,0,0,0,0,0]
["XXX-XXX-XXX-X",0,0,0,0,"Available",0,0,0,0,0,0,0,0]
["XXX-XXX-XXX-X",0,0,0,0,"Available",0,0,0,0,0,0,0,0]
["XXX-XXX-XXX-X",0,0,0,0,"Available",0,0,0,0,0,0,0,0]
["XXX-XXX-XXX-X",0,0,0,0,"Available",0,0,0,0,0,0,0,0]
["XXX-XXX-XXX-X",0,0,0,0,"Available",0,0,0,0,0,0,0,0]
["XXX-XXX-XXX-X",0,0,0,0,"Available",0,0,0,0,0,0,0,0]
["XXX-XXX-XXX-X",0,0,0,0,"Available",0,0,0,0,0,0,0,0]
["XXX-XXX-XXX-X",0,0,0,0,"Available",0,0,0,0,0,0,0,0]
["XXX-XXX-XXX-X",0,0,0,0,"Available",0,0,0,0,0,0,0,0]
["XXX-XXX-XXX-X",0,0,0,0,"Available",0,0,0,0,0,0,0,0]
["XXX-XXX-XXX-X",0,0,0,0,"Available",0,0,0,0,0,0,0,0]
["XXX-XXX-XXX-X",0,0,0,0,"Available",0,0,0,0,0,0,0,0]
["XXX-XXX-XXX-X",0,0,0,0,"Available",0,0,0,0,0,0,0,0]
["XXX-XXX-XXX-X",0,0,0,0,"Available",0,0,0,0,0,0,0,0]
["XXX-XXX-XXX-X",0,0,0,0,"Available",0,0,0,0,0,0,0,0]

{"sheet":"5. ADUs","index":5,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["ADU Production"]
[null,"Lower Income Capacity","Moderate Income Capacity","Above Moderate Income Capacity","Total Capacity"]
["ADU Projection",0,0,0,{"$f":"SUM(B3:D3)","v":0}]
["ADU Production from APR"]
["June 30, 2020-End of 2020",0,0,0,{"$f":"SUM(B5:D5)","v":0}]
[2021,0,0,0,0]
[2022,0,0,0,0]
[2023,0,0,0,0]
[2024,1,1,1,3]
[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":1},{"$f":"SUM(C5:C14)","v":1},1,{"$f":"SUM(B15:D15)","v":3}]
["ADU Production in Excess of Projection",{"$f":"IF(B15-B3>0,B15-B3,\"\")","v":1},{"$f":"IF(C15-C3>0,C15-C3,\"\")","v":1},{"$f":"IF(D15-D3>0,D15-D3,\"\")","v":1},{"$f":"IF(E15-E3>0,E15-E3,\"\")","v":3}]