{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Income Average","County Selection"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":2,"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":"Income Average","index":0,"n_rows":51,"n_cols":18,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
[]
["Income Averaging Test"]
[]
[null,"INPUT # OF INCOME DESIGNATED UNITS",null,null,null,null,null,"% OF AMI","AVERAGE"]
[null,null,null,null,null,null,null,null,"AMGI",null,"Revenue"]
[null,"Studio","1BR","2BR","3BR","4BR","Total",null,null,null,"Studio","1BR","2BR","3BR","4BR","Total","All at 60%"]
[null,0,0,0,0,0,{"$f":"SUM(B7:F7)","v":0},0.2,{"$f":"G7*H7","v":0},null,{"$f":"+C37*B7","v":0},{"$f":"+C38*C7","v":0},{"$f":"+C39*D7","v":0},{"$f":"+C40*E7","v":0},{"$f":"+C41*F7","v":0},{"$f":"SUM(K7:O7)","v":0}]
[null,0,0,0,0,0,{"$f":"SUM(B8:F8)","v":0},0.3,0,null,{"$f":"+D37*B8","v":0},{"$f":"+D38*C8","v":0},{"$f":"+D39*D8","v":0},{"$f":"+D40*E8","v":0},{"$f":"+D41*F8","v":0},{"$f":"SUM(K8:O8)","v":0}]
[null,0,0,0,0,0,{"$f":"SUM(B9:F9)","v":0},0.4,{"$f":"G9*H9","v":0},null,{"$f":"+E37*B9","v":0},{"$f":"+E38*C9","v":0},{"$f":"+E39*D9","v":0},{"$f":"+E40*E9","v":0},{"$f":"+E41*F9","v":0},0]
[null,0,0,0,0,0,{"$f":"SUM(B10:F10)","v":0},0.5,0,null,{"$f":"+F37*B10","v":0},{"$f":"+F38*C10","v":0},{"$f":"+F39*D10","v":0},{"$f":"+F40*E10","v":0},{"$f":"+F41*F10","v":0},0]
[null,0,0,0,0,0,{"$f":"SUM(B11:F11)","v":0},0.6,0,null,{"$f":"+G37*B11","v":0},{"$f":"+G38*C11","v":0},{"$f":"+G39*D11","v":0},{"$f":"+G40*E11","v":0},{"$f":"+G41*F11","v":0},0,{"$f":"+B14*G37+C14*G38+D14*G39+E14*G40+F14*G41","v":0}]
[null,0,0,0,0,0,0,0.7,0,null,{"$f":"+B12*H37","v":0},{"$f":"+H38*C12","v":0},{"$f":"+H39*D12","v":0},{"$f":"+E12*H40","v":0},{"$f":"+F12*H41","v":0},0]
[null,0,0,0,0,null,0,0.8,0,null,{"$f":"+I37*B13","v":0},{"$f":"+I38*C13","v":0},{"$f":"+I39*D13","v":0},{"$f":"+I40*E13","v":0},{"$f":"+I41*F13","v":0},0]
[null,{"$f":"SUM(B7:B13)","v":0},{"$f":"SUM(C7:C13)","v":0},{"$f":"SUM(D7:D13)","v":0},0,0,0,null,{"$f":"SUM(I7:I13)/G14","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,{"$f":"SUM(P7:P13)","v":0},{"$f":"SUM(Q7:Q13)","v":0},{"$f":"+P14-Q14","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Annual",{"$f":"+R14*12","v":0}]
[null,"Bond Test"]
[null,"40/60 Test",{"$f":"+IF((SUM($G$7:$G$11)/$G$14)>=0.4,\"Pass\",\"Fail\")","v":{"$error":"#DIV/0!"}}]
[null,"20/50 Test",{"$f":"+IF(SUM($G$7:$G$10)/$G$14>=0.2,\"Pass\",\"Fail\")","v":{"$error":"#DIV/0!"}}]
[]
[]
["Determination of Income and Rent"]
[null,null,null,null,"Select County"]
[null,null,null,"County:","Adams County, WA"]
[null,null,null,"4 Person @ VLI (50%)",{"$f":"VLOOKUP(E23,'County Selection'!A1:B59,2,FALSE)","v":32500}]
[]
[null,"Income",0.2,0.3,0.4,0.5,0.6,0.7,0.8,1.4]
[null,"1 Person",{"$f":"F27*$C$26*2","v":9100},{"$f":"F27*$D$26*2","v":13650},{"$f":"F27*$E$26*2","v":18200},{"$f":"+CEILING($E$24*K27,50)","v":22750},{"$f":"F27*$G$26*2","v":27300},{"$f":"F27*$H$26*2","v":31849.999999999996},{"$f":"F27*$I$26*2","v":36400},{"$f":"F27*$J$26*2","v":63699.999999999993},0.7]
[null,"2 Person",10400,15600,20800,26000,31200,36400,41600,72800,0.8]
[null,"3 Person",11700,17550,23400,29250,35100,40950,46800,81900,0.9]
[null,"4 Person",13000,19500,26000,32500,39000,45500,52000,91000,1]
[null,"5 Person",14040,21060,28080,35100,42120,49140,56160,98280,1.08]
[null,"6 Person",15080,22620,30160,37700,45240,52780,60320,105560,1.1599999999999999]
[null,"7 Person",16120,24180,32240,40300,48360,56420,64480,112840,1.24]
[null,"8 Person",17160,25740,34320,42900,51480,60059.999999999993,68640,120119.99999999999,1.32]
[]
[null,"Rent",{"$f":"C26","v":0.2},0.3,0.4,0.5,0.6,0.7,0.8]
[null,"Efficiency",{"$f":"+ROUNDDOWN(C27*0.3/12,0)","v":227},341,455,568,682,796,910]
[null,"1 Bedroom",{"$f":"+ROUNDDOWN(((C27+C28)/2)*0.3/12,0)","v":243},365,487,609,731,853,975]
[null,"2 Bedroom",{"$f":"+ROUNDDOWN(C29*0.3/12,0)","v":292},438,585,731,877,1023,1170]
[null,"3 Bedroom",{"$f":"+ROUNDDOWN(((C30+C31)/2)*0.3/12,0)","v":338},507,676,845,1014,1183,1352]
[null,"4 Bedroom",{"$f":"+ROUNDDOWN(C32*0.3/12,0)","v":377},565,754,942,1131,1319,1508]
[null,"5 Bedroom",{"$f":"+ROUNDDOWN(((C33+C34)/2)*0.3/12,0)","v":416},624,832,1040,1248,1456,1664]
[]
[null,"Change in Rent (compared to 60%)"]
[null,null,{"$f":"C36","v":0.2},{"$f":"D36","v":0.3},0.4,0.5,0.6,0.7,0.8]
[null,{"$f":"B37","v":"Efficiency"},{"$f":"C37-$G37","v":-455},-341,-227,-114,null,{"$f":"H37-G37","v":114},{"$f":"I37-G37","v":228}]
[null,"1 Bedroom",-488,-366,-244,-122,null,122,244]
[null,"2 Bedroom",-585,-439,-292,-146,null,146,293]
[null,"3 Bedroom",-676,-507,-338,-169,null,169,338]
[null,"4 Bedroom",-754,-566,-377,-189,null,188,377]
[null,"5 Bedroom",-832,-624,-416,-208,null,208,416]

{"sheet":"County Selection","index":1,"n_rows":41,"n_cols":2,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
["County_Name","l50_4"]
["Adams County, WA",32500]
["Asotin County, WA",31450]
["Benton County, WA",36250]
["Chelan County, WA",33550]
["Clallam County, WA",32500]
["Clark County, WA",40700]
["Columbia County, WA",32500]
["Cowlitz County, WA",32500]
["Douglas County, WA",33550]
["Ferry County, WA",32500]
["Franklin County, WA",36250]
["Garfield County, WA",32500]
["Grant County, WA",32500]
["Grays Harbor County, WA",32500]
["Island County, WA",37950]
["Jefferson County, WA",32750]
["King County, WA",53500]
["Kitsap County, WA",41300]
["Kittitas County, WA",34500]
["Klickitat County, WA",32500]
["Lewis County, WA",32500]
["Lincoln County, WA",32500]
["Mason County, WA",32500]
["Okanogan County, WA",32500]
["Pacific County, WA",32500]
["Pend Oreille County, WA",32500]
["Pierce County, WA",37300]
["San Juan County, WA",35200]
["Skagit County, WA",34550]
["Skamania County, WA",40700]
["Snohomish County, WA",53500]
["Spokane County, WA",32600]
["Stevens County, WA",32500]
["Thurston County, WA",38850]
["Wahkiakum County, WA",32500]
["Walla Walla County, WA",32850]
["Whatcom County, WA",38050]
["Whitman County, WA",33750]
["Yakima County, WA",32500]
[", "]