{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Summary","Sites Inventory"],"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":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[null,"Lower","Moderate","Above Moderate","Total"]
["RHNA",1500,2000,2500,{"$f":"SUM(B2:D2)","v":6000}]
["Housing Element Sites Inventory"]
["Original Housing Element Capacity (Calculated)",{"$f":"SUM('Sites Inventory'!B:B)","v":1500},{"$f":"SUM('Sites Inventory'!C:C)","v":250},{"$f":"SUM('Sites Inventory'!D:D)","v":250},{"$f":"SUM(B4:D4)","v":2000}]
["Entitled",{"$f":"SUM('Sites Inventory'!G:G)","v":500},{"$f":"SUM('Sites Inventory'!H:H)","v":0},{"$f":"SUM('Sites Inventory'!I:I)","v":250},{"$f":"SUM(B5:D5)","v":750}]
["Difference in Units for Entitled Projects (Capacity - Entitled)",{"$f":"SUM('Sites Inventory'!K:K)","v":-500},{"$f":"SUM('Sites Inventory'!L:L)","v":0},{"$f":"SUM('Sites Inventory'!M:M)","v":250},-250]
["Remaining Capacity",{"$f":"B4-B5+B6","v":500},{"$f":"C4-C5+C6","v":250},{"$f":"D4-D5+D6","v":250},1000]
["Total Housing Capacity (Adjusted)",{"$f":"SUM(B7,B5)","v":1000},{"$f":"SUM(C7,C5)","v":250},500,{"$f":"SUM(B8:D8)","v":1750}]
[]
["Surplus/Deficit Capacity to Meet Unmet RHNA",{"$f":"B8-B2","v":-500},{"$f":"C8-C2","v":-1750},{"$f":"D8-D2","v":-2000},{"$f":"E8-E2","v":-4250}]

{"sheet":"Sites Inventory","index":1,"n_rows":4,"n_cols":15,"rows_kept":4,"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",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.)"]
["PLACEHOLDER",1000,0,0,{"$f":"SUM(B3:D3)","v":1000},"Completed Project",500,0,250,{"$f":"SUM(G3:I3)","v":750},{"$f":"IF($F3<>\"Available\", G3-B3, \"\")","v":-500},{"$f":"IF($F3<>\"Available\", H3-C3, \"\")","v":0},{"$f":"IF($F3<>\"Available\", I3-D3, \"\")","v":250},{"$f":"SUM(K3:M3)","v":-250}]
["PLACEHOLDER",500,250,250,{"$f":"SUM(B4:D4)","v":1000},"Available",0,0,0,{"$f":"SUM(G4:I4)","v":0},{"$f":"IF($F4<>\"Available\", G4-B4, \"\")","v":""},{"$f":"IF($F4<>\"Available\", H4-C4, \"\")","v":""},{"$f":"IF($F4<>\"Available\", I4-D4, \"\")","v":""},{"$f":"SUM(K4:M4)","v":0}]