{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Income Averaging","County 50% (2021)"],"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 Averaging","index":0,"n_rows":51,"n_cols":18,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
[]
["INCOME AVERAGING TEST WORKSHEET"]
[]
[null,"In each bedroom size column, enter number of units at each AMI:",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,null,{"$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,null,null,null,{"$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,null,null,null,{"$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,null,null,null,{"$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,null,null,null,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,null,null,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 from drop-down list below:"]
[null,null,null,"County:","King County, WA"]
[null,null,null,"4 Person @ VLI (50%)",{"$f":"VLOOKUP(E23,'County 50% (2021)'!A1:B59,2,FALSE)","v":57850}]
[]
[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":16200},{"$f":"F27*$D$26*2","v":24300},{"$f":"F27*$E$26*2","v":32400},{"$f":"+CEILING($E$24*K27,50)","v":40500},{"$f":"F27*$G$26*2","v":48600},{"$f":"F27*$H$26*2","v":56700},{"$f":"F27*$I$26*2","v":64800},{"$f":"F27*$J$26*2","v":113400},0.7]
[null,"2 Person",18520,27780,37040,46300,55560,64819.999999999993,74080,129639.99999999999,0.8]
[null,"3 Person",20840,31260,41680,52100,62520,72940,83360,145880,0.9]
[null,"4 Person",23140,34710,46280,57850,69420,80990,92560,161980,1]
[null,"5 Person",25000,37500,50000,62500,75000,87500,100000,175000,1.08]
[null,"6 Person",26860,40290,53720,67150,80580,94010,107440,188020,1.1599999999999999]
[null,"7 Person",28700,43050,57400,71750,86100,100450,114800,200900,1.24]
[null,"8 Person",30560,45840,61120,76400,91680,106960,122240,213920,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":405},607,810,1012,1215,1417,1620]
[null,"1 Bedroom",{"$f":"+ROUNDDOWN(((C27+C28)/2)*0.3/12,0)","v":434},651,868,1085,1302,1519,1736]
[null,"2 Bedroom",{"$f":"+ROUNDDOWN(C29*0.3/12,0)","v":521},781,1042,1302,1563,1823,2084]
[null,"3 Bedroom",{"$f":"+ROUNDDOWN(((C30+C31)/2)*0.3/12,0)","v":601},902,1203,1504,1805,2106,2407]
[null,"4 Bedroom",{"$f":"+ROUNDDOWN(C32*0.3/12,0)","v":671},1007,1343,1678,2014,2350,2686]
[null,"5 Bedroom",{"$f":"+ROUNDDOWN(((C33+C34)/2)*0.3/12,0)","v":740},1111,1481,1851,2222,2592,2963]
[]
[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":-810},-608,-405,-203,"N/A",{"$f":"H37-G37","v":202},{"$f":"I37-G37","v":405}]
[null,"1 Bedroom",-868,-651,-434,-217,"N/A",217,434]
[null,"2 Bedroom",-1042,-782,-521,-261,"N/A",260,521]
[null,"3 Bedroom",-1204,-903,-602,-301,"N/A",301,602]
[null,"4 Bedroom",-1343,-1007,-671,-336,"N/A",336,672]
[null,"5 Bedroom",-1482,-1111,-741,-371,"N/A",370,741]

{"sheet":"County 50% (2021)","index":1,"n_rows":41,"n_cols":2,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
["County_Name","lim50_21p4"]
["Adams County, WA",35300]
["Asotin County, WA",35750]
["Benton County, WA",39050]
["Chelan County, WA",35650]
["Clallam County, WA",35300]
["Clark County, WA",48350]
["Columbia County, WA",35300]
["Cowlitz County, WA",35650]
["Douglas County, WA",35650]
["Ferry County, WA",35300]
["Franklin County, WA",39050]
["Garfield County, WA",35300]
["Grant County, WA",35650]
["Grays Harbor County, WA",35300]
["Island County, WA",39900]
["Jefferson County, WA",35650]
["King County, WA",57850]
["Kitsap County, WA",47050]
["Kittitas County, WA",38000]
["Klickitat County, WA",35300]
["Lewis County, WA",35300]
["Lincoln County, WA",35300]
["Mason County, WA",35300]
["Okanogan County, WA",35300]
["Pacific County, WA",35300]
["Pend Oreille County, WA",35300]
["Pierce County, WA",45400]
["San Juan County, WA",39000]
["Skagit County, WA",41150]
["Skamania County, WA",48350]
["Snohomish County, WA",57850]
["Spokane County, WA",38550]
["Stevens County, WA",35300]
["Thurston County, WA",45100]
["Wahkiakum County, WA",35300]
["Walla Walla County, WA",36550]
["Whatcom County, WA",40550]
["Whitman County, WA",36950]
["Yakima County, WA",35300]
[", "]