{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Income Average","County 50% (2020)"],"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 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:","Adams County, WA"]
[null,null,null,"4 Person @ VLI (50%)",{"$f":"VLOOKUP(E23,'County 50% (2020)'!A1:B59,2,FALSE)","v":33650}]
[]
[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":9440},{"$f":"F27*$D$26*2","v":14160},{"$f":"F27*$E$26*2","v":18880},{"$f":"+CEILING($E$24*K27,50)","v":23600},{"$f":"F27*$G$26*2","v":28320},{"$f":"F27*$H$26*2","v":33040},{"$f":"F27*$I$26*2","v":37760},{"$f":"F27*$J$26*2","v":66080},0.7]
[null,"2 Person",10780,16170,21560,26950,32340,37730,43120,75460,0.8]
[null,"3 Person",12120,18180,24240,30300,36360,42420,48480,84840,0.9]
[null,"4 Person",13460,20190,26920,33650,40380,47110,53840,94220,1]
[null,"5 Person",14540,21810,29080,36350,43620,50890,58160,101780,1.08]
[null,"6 Person",15620,23430,31240,39050,46860,54670,62480,109340,1.1599999999999999]
[null,"7 Person",16700,25050,33400,41750,50100,58449.999999999993,66800,116899.99999999999,1.24]
[null,"8 Person",17780,26670,35560,44450,53340,62229.999999999993,71120,124459.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":236},354,472,590,708,826,944]
[null,"1 Bedroom",{"$f":"+ROUNDDOWN(((C27+C28)/2)*0.3/12,0)","v":252},379,505,631,758,884,1011]
[null,"2 Bedroom",{"$f":"+ROUNDDOWN(C29*0.3/12,0)","v":303},454,606,757,909,1060,1212]
[null,"3 Bedroom",{"$f":"+ROUNDDOWN(((C30+C31)/2)*0.3/12,0)","v":350},525,700,875,1050,1225,1400]
[null,"4 Bedroom",{"$f":"+ROUNDDOWN(C32*0.3/12,0)","v":390},585,781,976,1171,1366,1562]
[null,"5 Bedroom",{"$f":"+ROUNDDOWN(((C33+C34)/2)*0.3/12,0)","v":431},646,862,1077,1293,1508,1724]
[]
[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":-472},-354,-236,-118,"N/A",{"$f":"H37-G37","v":118},{"$f":"I37-G37","v":236}]
[null,"1 Bedroom",-506,-379,-253,-127,"N/A",126,253]
[null,"2 Bedroom",-606,-455,-303,-152,"N/A",151,303]
[null,"3 Bedroom",-700,-525,-350,-175,"N/A",175,350]
[null,"4 Bedroom",-781,-586,-390,-195,"N/A",195,391]
[null,"5 Bedroom",-862,-647,-431,-216,"N/A",215,431]

{"sheet":"County 50% (2020)","index":1,"n_rows":41,"n_cols":2,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
["County_Name","l50_4"]
["Adams County, WA",33650]
["Asotin County, WA",34050]
["Benton County, WA",38750]
["Chelan County, WA",34700]
["Clallam County, WA",33650]
["Clark County, WA",46050]
["Columbia County, WA",33650]
["Cowlitz County, WA",34600]
["Douglas County, WA",34700]
["Ferry County, WA",33650]
["Franklin County, WA",38750]
["Garfield County, WA",33650]
["Grant County, WA",34700]
["Grays Harbor County, WA",33650]
["Island County, WA",38000]
["Jefferson County, WA",34300]
["King County, WA",59700]
["Kitsap County, WA",45850]
["Kittitas County, WA",37450]
["Klickitat County, WA",33650]
["Lewis County, WA",33650]
["Lincoln County, WA",33650]
["Mason County, WA",33650]
["Okanogan County, WA",33650]
["Pacific County, WA",33650]
["Pend Oreille County, WA",33650]
["Pierce County, WA",43250]
["San Juan County, WA",39200]
["Skagit County, WA",39200]
["Skamania County, WA",46050]
["Snohomish County, WA",59700]
["Spokane County, WA",38700]
["Stevens County, WA",33650]
["Thurston County, WA",43350]
["Wahkiakum County, WA",33650]
["Walla Walla County, WA",34950]
["Whatcom County, WA",42650]
["Whitman County, WA",36150]
["Yakima County, WA",33650]
[", "]