{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Income Average","County Selection","Sheet1"],"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 - 2023"]
[]
[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":41750}]
[]
[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":11700},{"$f":"F27*$D$26*2","v":17550},{"$f":"F27*$E$26*2","v":23400},{"$f":"+CEILING($E$24*K27,50)","v":29250},{"$f":"F27*$G$26*2","v":35100},{"$f":"F27*$H$26*2","v":40950},{"$f":"F27*$I$26*2","v":46800},{"$f":"F27*$J$26*2","v":81900},0.7]
[null,"2 Person",13360,20040,26720,33400,40080,46760,53440,93520,0.8]
[null,"3 Person",15040,22560,30080,37600,45120,52640,60160,105280,0.9]
[null,"4 Person",16700,25050,33400,41750,50100,58449.999999999993,66800,116899.99999999999,1]
[null,"5 Person",18040,27060,36080,45100,54120,63139.999999999993,72160,126279.99999999999,1.08]
[null,"6 Person",19380,29070,38760,48450,58140,67830,77520,135660,1.1599999999999999]
[null,"7 Person",20720,31080,41440,51800,62160,72520,82880,145040,1.24]
[null,"8 Person",22060,33090,44120,55150,66180,77210,88240,154420,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":292},438,585,731,877,1023,1170]
[null,"1 Bedroom",{"$f":"+ROUNDDOWN(((C27+C28)/2)*0.3/12,0)","v":313},469,626,783,939,1096,1253]
[null,"2 Bedroom",{"$f":"+ROUNDDOWN(C29*0.3/12,0)","v":376},564,752,940,1128,1316,1504]
[null,"3 Bedroom",{"$f":"+ROUNDDOWN(((C30+C31)/2)*0.3/12,0)","v":434},651,868,1085,1302,1519,1737]
[null,"4 Bedroom",{"$f":"+ROUNDDOWN(C32*0.3/12,0)","v":484},726,969,1211,1453,1695,1938]
[null,"5 Bedroom",{"$f":"+ROUNDDOWN(((C33+C34)/2)*0.3/12,0)","v":534},802,1069,1336,1604,1871,2139]
[]
[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":-585},-439,-292,-146,null,{"$f":"H37-G37","v":146},{"$f":"I37-G37","v":293}]
[null,"1 Bedroom",-626,-470,-313,-156,null,157,314]
[null,"2 Bedroom",-752,-564,-376,-188,null,188,376]
[null,"3 Bedroom",-868,-651,-434,-217,null,217,435]
[null,"4 Bedroom",-969,-727,-484,-242,null,242,485]
[null,"5 Bedroom",-1070,-802,-535,-268,null,267,535]

{"sheet":"County Selection","index":1,"n_rows":40,"n_cols":2,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
["County_Name","l50_4"]
["Adams County, WA",41750]
["Asotin County, WA",42350]
["Benton County, WA",46200]
["Chelan County, WA",42150]
["Clallam County, WA",41750]
["Clark County, WA",56400]
["Columbia County, WA",41750]
["Cowlitz County, WA",42150]
["Douglas County, WA",42150]
["Ferry County, WA",41750]
["Franklin County, WA",46200]
["Garfield County, WA",41750]
["Grant County, WA",42150]
["Grays Harbor County, WA",41750]
["Island County, WA",47200]
["Jefferson County, WA",42150]
["King County, WA",68500]
["Kitsap County, WA",54450]
["Kittitas County, WA",45000]
["Klickitat County, WA",41750]
["Lewis County, WA",41750]
["Lincoln County, WA",41750]
["Mason County, WA",41750]
["Okanogan County, WA",41750]
["Pacific County, WA",41750]
["Pend Oreille County, WA",41750]
["Pierce County, WA",53750]
["San Juan County, WA",46150]
["Skagit County, WA",45550]
["Skamania County, WA",56400]
["Snohomish County, WA",68500]
["Spokane County, WA",44500]
["Stevens County, WA",41750]
["Thurston County, WA",51250]
["Wahkiakum County, WA",41750]
["Walla Walla County, WA",42650]
["Whatcom County, WA",48000]
["Whitman County, WA",42250]
["Yakima County, WA",41750]

{"sheet":"Sheet1","index":2,"n_rows":39,"n_cols":8,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
["WA","5300199999",53,1,"NCNTY53001N53001","Adams County, WA","Adams County",32150]
["WA","5300399999",53,3,"METRO30300M30300","Lewiston, ID-WA MSA","Asotin County",31550]
["WA","5300599999",53,5,"METRO28420M28420","Kennewick-Richland, WA MSA","Benton County",39000]
["WA","5300799999",53,7,"METRO48300M48300","Wenatchee, WA MSA","Chelan County",34200]
["WA","5300999999",53,9,"NCNTY53009N53009","Clallam County, WA","Clallam County",33250]
["WA","5301199999",53,11,"METRO38900M38900","Portland-Vancouver-Hillsboro, OR-WA MSA","Clark County",43950]
["WA","5301399999",53,13,"METRO47460N53013","Columbia County, WA HUD Metro FMR Area","Columbia County",32150]
["WA","5301599999",53,15,"METRO31020M31020","Longview, WA MSA","Cowlitz County",34150]
["WA","5301799999",53,17,"METRO48300M48300","Wenatchee, WA MSA","Douglas County",34200]
["WA","5301999999",53,19,"NCNTY53019N53019","Ferry County, WA","Ferry County",32150]
["WA","5302199999",53,21,"METRO28420M28420","Kennewick-Richland, WA MSA","Franklin County",39000]
["WA","5302399999",53,23,"NCNTY53023N53023","Garfield County, WA","Garfield County",32150]
["WA","5302599999",53,25,"NCNTY53025N53025","Grant County, WA","Grant County",32150]
["WA","5302799999",53,27,"NCNTY53027N53027","Grays Harbor County, WA","Grays Harbor County",32150]
["WA","5302999999",53,29,"NCNTY53029N53029","Island County, WA","Island County",36950]
["WA","5303199999",53,31,"NCNTY53031N53031","Jefferson County, WA","Jefferson County",34650]
["WA","5303399999",53,33,"METRO42660MM7600","Seattle-Bellevue, WA HUD Metro FMR Area","King County",55350]
["WA","5303599999",53,35,"METRO14740M14740","Bremerton-Silverdale, WA MSA","Kitsap County",42750]
["WA","5303799999",53,37,"NCNTY53037N53037","Kittitas County, WA","Kittitas County",36150]
["WA","5303999999",53,39,"NCNTY53039N53039","Klickitat County, WA","Klickitat County",32150]
["WA","5304199999",53,41,"NCNTY53041N53041","Lewis County, WA","Lewis County",32150]
["WA","5304399999",53,43,"NCNTY53043N53043","Lincoln County, WA","Lincoln County",32150]
["WA","5304599999",53,45,"NCNTY53045N53045","Mason County, WA","Mason County",32250]
["WA","5304799999",53,47,"NCNTY53047N53047","Okanogan County, WA","Okanogan County",32150]
["WA","5304999999",53,49,"NCNTY53049N53049","Pacific County, WA","Pacific County",32150]
["WA","5305199999",53,51,"METRO44060N53051","Pend Oreille County, WA HUD Metro FMR Area","Pend Oreille County",32150]
["WA","5305399999",53,53,"METRO42660MM8200","Tacoma, WA HUD Metro FMR Area","Pierce County",40100]
["WA","5305599999",53,55,"NCNTY53055N53055","San Juan County, WA","San Juan County",38450]
["WA","5305799999",53,57,"METRO34580M34580","Mount Vernon-Anacortes, WA MSA","Skagit County",38000]
["WA","5305999999",53,59,"METRO38900M38900","Portland-Vancouver-Hillsboro, OR-WA MSA","Skamania County",43950]
["WA","5306199999",53,61,"METRO42660MM7600","Seattle-Bellevue, WA HUD Metro FMR Area","Snohomish County",55350]
["WA","5306399999",53,63,"METRO44060M44060","Spokane, WA HUD Metro FMR Area","Spokane County",35850]
["WA","5306599999",53,65,"METRO44060N53065","Stevens County, WA HUD Metro FMR Area","Stevens County",32150]
["WA","5306799999",53,67,"METRO36500M36500","Olympia-Tumwater, WA MSA","Thurston County",41850]
["WA","5306999999",53,69,"NCNTY53069N53069","Wahkiakum County, WA","Wahkiakum County",32150]
["WA","5307199999",53,71,"METRO47460N53071","Walla Walla County, WA HUD Metro FMR Area","Walla Walla County",33550]
["WA","5307399999",53,73,"METRO13380M13380","Bellingham, WA MSA","Whatcom County",39550]
["WA","5307599999",53,75,"NCNTY53075N53075","Whitman County, WA","Whitman County",35800]
["WA","5307799999",53,77,"METRO49420M49420","Yakima, WA MSA","Yakima County",32150]