{"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 - 2022"]
[]
[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:","Columbia County, WA"]
[null,null,null,"4 Person @ VLI (50%)",{"$f":"VLOOKUP(E23,'County Selection'!A1:B59,2,FALSE)","v":39450}]
[]
[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":11060},{"$f":"F27*$D$26*2","v":16590},{"$f":"F27*$E$26*2","v":22120},{"$f":"+CEILING($E$24*K27,50)","v":27650},{"$f":"F27*$G$26*2","v":33180},{"$f":"F27*$H$26*2","v":38710},{"$f":"F27*$I$26*2","v":44240},{"$f":"F27*$J$26*2","v":77420},0.7]
[null,"2 Person",12640,18960,25280,31600,37920,44240,50560,88480,0.8]
[null,"3 Person",14220,21330,28440,35550,42660,49770,56880,99540,0.9]
[null,"4 Person",15780,23670,31560,39450,47340,55230,63120,110460,1]
[null,"5 Person",17060,25590,34120,42650,51180,59709.999999999993,68240,119419.99999999999,1.08]
[null,"6 Person",18320,27480,36640,45800,54960,64119.999999999993,73280,128239.99999999999,1.1599999999999999]
[null,"7 Person",19580,29370,39160,48950,58740,68530,78320,137060,1.24]
[null,"8 Person",20840,31260,41680,52100,62520,72940,83360,145880,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":276},414,553,691,829,967,1106]
[null,"1 Bedroom",{"$f":"+ROUNDDOWN(((C27+C28)/2)*0.3/12,0)","v":296},444,592,740,888,1036,1185]
[null,"2 Bedroom",{"$f":"+ROUNDDOWN(C29*0.3/12,0)","v":355},533,711,888,1066,1244,1422]
[null,"3 Bedroom",{"$f":"+ROUNDDOWN(((C30+C31)/2)*0.3/12,0)","v":410},615,821,1026,1231,1436,1642]
[null,"4 Bedroom",{"$f":"+ROUNDDOWN(C32*0.3/12,0)","v":458},687,916,1145,1374,1603,1832]
[null,"5 Bedroom",{"$f":"+ROUNDDOWN(((C33+C34)/2)*0.3/12,0)","v":505},757,1010,1263,1515,1768,2021]
[]
[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":-553},-415,-276,-138,null,{"$f":"H37-G37","v":138},{"$f":"I37-G37","v":277}]
[null,"1 Bedroom",-592,-444,-296,-148,null,148,297]
[null,"2 Bedroom",-711,-533,-355,-178,null,178,356]
[null,"3 Bedroom",-821,-616,-410,-205,null,205,411]
[null,"4 Bedroom",-916,-687,-458,-229,null,229,458]
[null,"5 Bedroom",-1010,-758,-505,-252,null,253,506]

{"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",39450]
["Asotin County, WA",40000]
["Benton County, WA",43650]
["Chelan County, WA",39800]
["Clallam County, WA",39450]
["Clark County, WA",53250]
["Columbia County, WA",39450]
["Cowlitz County, WA",39800]
["Douglas County, WA",39800]
["Ferry County, WA",39450]
["Franklin County, WA",43650]
["Garfield County, WA",39450]
["Grant County, WA",39800]
["Grays Harbor County, WA",39450]
["Island County, WA",44600]
["Jefferson County, WA",39800]
["King County, WA",64700]
["Kitsap County, WA",51450]
["Kittitas County, WA",42500]
["Klickitat County, WA",39450]
["Lewis County, WA",39450]
["Lincoln County, WA",39450]
["Mason County, WA",39450]
["Okanogan County, WA",39450]
["Pacific County, WA",39450]
["Pend Oreille County, WA",39450]
["Pierce County, WA",50750]
["San Juan County, WA",43600]
["Skagit County, WA",43050]
["Skamania County, WA",53250]
["Snohomish County, WA",64700]
["Spokane County, WA",42050]
["Stevens County, WA",39450]
["Thurston County, WA",50450]
["Wahkiakum County, WA",39450]
["Walla Walla County, WA",40300]
["Whatcom County, WA",45350]
["Whitman County, WA",39900]
["Yakima County, WA",39450]

{"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]