{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Inc_Asset_TAB","CountyData","Instructions","TIC Example","Page 3 Example","EnterCounty&Defaults","TIC","Page 3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":30,"comments":1,"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":"Inc_Asset_TAB","index":0,"n_rows":47,"n_cols":7,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
["List used for Income & Asset Identification."]
["Do not add new items to the ends of the lists. Insert a blank line in the middle to add to the list."]
[]
[]
[]
["Income_Description",null,null,null,null,"Household Relationship"]
["SS - Gross Federal",12,null,null,null,"Head of Household"]
["SSI - Gross Federal",12,null,null,null,"Adult co-tenant"]
["State SSI",12,83.78,null,null,"Child"]
["Pension",12,null,null,null,"Live-in caretaker"]
["W-2",12,null,null,null,"Spouse"]
["Child Support",12,null,null,null,"Foster child(ren)/adults(s)"]
["Alimony",12,null,null,null,"Unborn child"]
["Employment",52,null,null,null,"Other"]
["Emp. Overtime",52]
["Bonus/Commision/Tips",1]
["Self employment",12]
["Monitary Gifts",12]
["Scholarships less exp.",1]
["Unemployement",52]
["Military",12]
["Housing Auth Verified",1]
["Other",12]
["Additional from page 3",1]
[null,null,null,null,"Effective Date","HUD Asset Threshold","HUD Rate"]
["Default Period",52,null,null,"1994-01-01",5000,0.02]
[null,null,null,null,"2016-01-01",5000,5.9999999999999995E-4]
[null,null,null,null,"2024-01-01",50000,4.0000000000000001E-3]
[null,null,null,null,"2025-01-01",51600,4.4999999999999997E-3]
["Asset_Descriptons",null,null,null,"2026-01-01",52787,4.0000000000000001E-3]
["Checking Acct","NNPP",null,null,null,50004]
["Savings Acct","NNPP",null,null,null,50005]
["CD","NNPP",null,null,null,50006]
["Money Market","NNPP",null,null,null,50007]
["Stocks & Bonds","NNPP",null,null,null,50008]
["Treasury Bills","NNPP",null,null,null,50009]
["Other","NNPP",null,null,null,50010]
["Invest. Personal Pro.","NNPP",null,null,null,50011]
["Cash on Hand","NNPP",null,null,null,50012]
["Trusts - Revocable","NNPP",null,null,null,50013]
["Real Estate","RE",null,null,null,50014]
["Mortgages (Neg. value)","RE",null,null,null,50015]
["Life Insurance (Acc. value)","NNPP",null,null,null,50016]
["Lump sum receipts","NNPP"]
["Safe Deposit Box","NNPP"]
["Recreation Vehicle","NNPP"]
["Add'l from pg 3"]

{"sheet":"CountyData","index":1,"n_rows":40,"n_cols":73,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
[null,"ADAMS","ASHLAND","BARRON","BAYFIELD","BROWN","BUFFALO","BURNETT","CALUMET","CHIPPEWA","CLARK","COLUMBIA","CRAWFORD","DANE","DODGE","DOOR","DOUGLAS","DUNN","EAU CLAIRE","FLORENCE","FOND DU LAC","FOREST","GRANT","GREEN","GREEN LAKE","IOWA","IRON","JACKSON","JEFFERSON","JUNEAU","KENOSHA","KEWAUNEE","LA CROSSE","LAFAYETTE","LANGLADE","LINCOLN","MANITOWOC","MARATHON","MARINETTE","MARQUETTE","MENOMINEE","MILWAUKEE","MONROE","OCONTO","ONEIDA","OUTAGAMIE","OZAUKEE","PEPIN","PIERCE","POLK","PORTAGE","PRICE","RACINE","RICHLAND","ROCK","RUSK","SAUK","SAWYER","SHAWANO","SHEBOYGAN","ST. CROIX","TAYLOR","TREMPEALEAU","VERNON","VILAS","WALWORTH","WASHBURN","WASHINGTON","WAUKESHA","WAUPACA","WAUSHARA","WINNEBAGO","WOOD"]
["1/1/1987",16400,16400,16400,16400,19900,16400,16400,20200,17050,16400,16800,16400,22100,18250,16400,16250,15100,17050,16400,19300,16400,16500,18250,16400,16400,16400,16400,18450,16400,20500,16700,18550,16400,16400,16400,17900,18400,16400,16400,16400,20900,16400,16400,16400,20200,20900,16400,18400,16400,19150,16400,20900,16400,19250,16400,16400,16400,16400,19400,25500,16400,16400,16400,16400,18350,16400,20900,20900,17650,16400,20200,19450]
["5/1/1991",16400,16400,16400,16400,19500,16400,16400,19600,17050,16400,16800,16400,21900,18150,16400,15900,16400,17050,16400,19300,16400,16500,18150,16400,16400,16400,16400,18450,16400,20500,16700,18300,16400,16400,16400,17750,18400,16400,16400,16400,20900,16400,16400,16400,19600,20900,16400,18000,16400,19150,16400,20900,16400,19150,16400,16400,16400,16400,18950,24000,16400,16400,16400,16400,18350,16400,20900,20900,17450,16400,19600,19450]
["4/16/1992",16400,16400,16400,16400,19900,16400,16400,20200,17050,16400,16800,16400,22100,18250,16400,16250,16400,17050,16400,19300,16400,16500,18250,16400,16400,16400,16400,18450,16400,20500,16700,18550,16400,16400,16400,17900,18400,16400,16400,16400,20900,16400,16400,16400,20200,20900,16400,18400,16400,19150,16400,20900,16400,19250,16400,16400,16400,16400,19400,25500,16400,16400,16400,16400,18350,16400,20900,20900,17650,16400,20200,19450]
["5/5/1993",17300,17300,17300,17300,20850,17300,17300,20750,18000,17300,18900,17300,23650,19050,17600,17500,17300,18000,17300,19500,17300,17300,18600,17300,17300,17300,17300,20350,17300,20300,18600,19250,17300,17300,17300,18650,19950,17300,17300,17300,22200,17300,17300,17300,20750,22200,17300,18900,17300,19900,17300,21650,17300,20300,17300,17900,17300,17300,20900,24800,17300,17300,17300,17300,20600,17300,22200,22200,18050,17300,20750,19900]
["5/31/1994",17950,17950,17950,17950,21350,17950,17950,21650,18700,17950,19650,17950,25200,19900,17950,18150,17950,18700,17950,19650,17950,17950,18050,17950,18150,17950,17950,21450,17950,20300,17950,19300,17950,17950,17950,17950,20750,17950,17950,17950,23200,18000,17950,17950,21650,23200,17950,25500,17950,20700,17950,22650,17950,20750,17950,18900,17950,17950,20800,25500,17950,17950,17950,17950,21550,17950,23200,23200,18300,17950,21650,19450]
["1/18/1995",17950,17950,17950,17950,22000,17950,17950,21750,18700,17950,19900,17950,25200,19900,17950,18150,17950,18700,17950,19650,17950,17950,18300,17950,18400,17950,17950,21450,17950,20300,17950,19300,17950,17950,17950,17950,20750,17950,17950,17950,23200,18000,17950,17950,21750,23200,17950,25500,17950,20850,17950,22650,17950,20900,17950,18900,17950,17950,21350,25500,17950,17950,17950,17950,21550,17950,23200,23200,18550,17950,21750,19750]
["12/7/1995",18850,18850,18850,18850,22000,18850,18850,22250,19350,18850,19900,18850,26450,20700,18850,19300,18850,19350,18850,20200,18850,18850,18850,18850,18850,18850,18850,21450,18850,21350,18850,20050,18850,18850,18850,18850,21600,18850,18850,18850,24350,18850,18850,18850,22250,24350,18850,27300,18850,20850,18850,23350,18850,22300,18850,19800,18850,18850,21400,27300,18850,18850,18850,18850,22100,18850,24350,24350,18850,18850,22250,19750]
["12/27/1996",19800,19800,19800,19800,22500,19800,19800,22750,20050,19800,19900,19800,27300,21400,19800,20300,19800,20050,19800,20600,19800,19800,19800,19800,19800,19800,19800,21850,19800,22250,19800,20900,19800,19800,19800,19800,22100,19800,19800,19800,25350,19800,19800,19800,22750,25350,19800,28650,19800,21100,19800,24550,19800,23650,19800,20450,19800,19800,21900,28650,19800,19800,19800,19800,23400,19800,25350,25350,19800,19800,22750,19800]
["1/7/1998",20900,20900,20900,20900,23100,20900,20900,23350,21050,20900,20900,20900,29000,21900,20900,21300,20900,21050,20900,23100,20900,20900,20900,20900,20900,20900,20900,22300,20900,23700,20900,21750,20900,20900,20900,20900,22650,20900,20900,20900,26950,20900,20900,20900,23350,26950,20900,30400,20900,21600,20900,25150,20900,25200,20900,20950,20900,20900,22400,30400,20900,20900,20900,20900,24700,20900,26950,26950,20900,20900,23350,20900]
["1/27/1999",22200,22200,22200,22200,25450,22200,22200,23750,22200,22200,22200,22200,30700,22250,22200,21900,22200,22200,22200,24350,22200,22200,22200,22200,22200,22200,22200,22700,22200,25600,22200,22200,22200,22200,22200,22200,23050,22200,22200,22200,28800,22200,22200,22200,23750,28800,22200,31800,22200,22200,22200,25700,22200,26150,22200,22200,22200,22200,22800,31800,22200,22200,22200,22200,25150,22200,28800,28800,22200,22200,23750,22200]
["3/9/2000",23350,23350,23350,23350,25800,23350,23350,24100,23400,23350,23350,23350,32000,23350,23350,22300,23350,23400,23350,24650,23350,23350,23350,23350,23350,23350,23350,23350,23350,26850,23350,23350,23350,23350,23350,23350,23350,23350,23350,23350,29700,23350,23350,23350,24100,29700,23350,32850,23350,23350,23350,26300,23350,26500,23350,23350,23350,23350,23350,32850,23350,23350,23350,23350,25250,23350,29700,29700,23350,23350,24100,23350]
["4/6/2001",24200,24200,24200,24200,29550,26650,24200,29000,24550,24200,26550,24200,33550,27150,24200,24900,24200,24550,24200,26750,24200,24300,26100,24200,30250,24200,24200,28500,24200,28150,26050,25450,24200,24200,24200,28150,27400,24200,24200,24200,31750,24200,24200,24200,29000,31750,24200,37350,24200,27300,24200,30550,24200,28700,24200,24700,24200,24200,29250,37350,24200,24200,24200,24200,29400,24200,31750,31750,26750,24200,29000,28200]
["1/31/2002",25400,25400,25400,25400,30950,27300,25400,30950,25750,25400,27900,25400,35650,28400,25400,25400,25400,25750,25400,27950,25400,25400,28000,25400,33250,25400,25400,29850,25400,29850,26800,27000,25400,25400,25400,30050,28850,25400,25400,25400,33600,25400,25400,25400,30950,33600,25400,38350,25850,28800,25400,32500,25400,29850,25400,26300,25400,25400,31350,38350,25400,25400,25400,25400,30750,25400,33600,33600,27450,25400,30950,30250]
["2/20/2003",26000,26000,26000,26000,30950,27300,26000,30950,27300,26000,29050,26000,35650,29000,26350,26050,26150,27300,26000,28950,26000,26000,28000,26000,33250,26000,26000,29850,26000,31400,28650,27450,26000,26000,26000,30050,29000,26000,26000,26000,33600,26000,26000,26000,30950,33600,26000,38350,27000,29350,26000,32500,26000,29850,26000,26800,26000,26000,31350,38350,26000,26000,26000,26000,30750,26000,33600,33600,27450,26000,30950,30250]
["1/28/2004",26450,26450,26450,26450,31500,27300,26450,31350,28100,26450,29300,26450,36600,29150,26600,26600,26600,28100,26450,29100,26450,26450,28100,26600,33250,26450,26450,29850,26450,31400,29100,28100,26450,26450,26800,30050,29250,26450,26450,26450,33600,26450,26550,26450,31350,33600,26450,38350,27350,30900,26450,32500,26450,29850,26450,27200,26450,26450,31350,38350,26450,26450,26450,26450,31100,26450,33600,33600,27450,26450,31350,30250]
["2/11/2005",27200,27200,27200,27200,32300,27300,27200,32150,28250,27200,30200,27200,36600,29900,27750,27300,27200,28250,27200,30500,27200,27200,29050,27200,33250,27200,27200,30850,27200,32400,29250,28950,27200,27200,27300,30050,30200,27200,27200,27200,33600,27200,27200,27200,32150,33600,27200,38500,27950,30900,27200,32500,27200,30600,27200,28200,27200,27200,31350,38500,27200,27200,27200,27200,31700,27200,33600,33600,28050,27200,32150,30250]
["3/8/2006",27450,27450,27450,27450,32300,27450,27450,33800,28900,27450,30950,27450,36600,30650,28350,27850,27850,28900,27450,31250,27450,27450,29700,27650,33250,27450,27450,31450,27450,33050,32300,29600,27450,27450,28050,30450,30950,27450,27450,27450,33600,27450,27600,27450,33800,33600,27450,39250,28600,31400,27450,32950,27450,31350,27450,28800,27450,27450,31700,39250,27450,27450,27450,27450,32400,27450,33600,33600,28700,27450,32150,30250]
["3/20/2007",27450,27450,27450,27450,32300,27450,27450,33950,28900,27450,30950,27450,36850,30650,28350,27850,27850,28900,27450,31250,27450,27450,29700,27650,33250,27450,27450,32300,27450,33050,32300,30200,27450,27450,28050,30650,31450,27450,27450,27450,33600,27450,27600,27450,33950,33600,27450,39250,28600,31400,27450,32950,27450,31350,27450,28800,27450,27450,32350,39250,27450,27450,27450,27450,32400,27450,33600,33600,28750,27450,32150,30250]
["2/13/2008",28100,28100,28100,28100,32300,28100,28100,34300,29950,28100,31800,28100,38800,30650,29100,29450,28500,29950,28100,31250,28100,28100,30300,28350,33250,28100,28100,32300,28100,34350,32300,31700,28100,28100,28750,31000,32000,28100,28100,28100,33850,28100,28100,28100,34300,33850,28100,40450,29150,32550,28100,32950,28100,31750,28100,29450,28100,28100,32350,40450,28100,28100,28100,28100,32400,28100,33850,33850,29300,28100,32200,30250]
["3/19/2009",29250,29250,29250,29250,32950,29250,29250,36000,31000,29250,33850,29250,40000,32450,29950,29950,30950,31000,29250,32800,29250,29250,32350,29450,33250,29250,29250,33750,29250,35450,32950,31700,29250,29250,30100,32050,33400,29250,29250,29250,35350,29250,29250,29250,36000,35350,29250,41950,31250,33750,29250,33950,29250,32500,29250,30750,29250,29250,33850,41950,29250,29250,29250,29250,34750,29250,35350,35350,30150,29250,33450,31400]
["5/14/2010",29300,29300,29300,29300,32950,29300,29300,35650,31850,29300,33350,29300,40000,32300,30250,30000,30350,31850,29300,33000,29300,29300,32000,29500,33050,29300,29300,33350,29300,35500,32950,31750,29300,29300,29900,31900,33600,29300,29300,29300,35550,29300,29300,29300,35650,35550,29300,42000,30650,33800,29300,33950,29300,32500,29300,30800,29300,29300,33500,42000,29300,29300,29300,29300,35150,29300,35550,35550,29850,29300,34200,30900]
["5/31/2011",29550,29550,29550,29550,33800,29950,29550,36300,31850,29550,34550,29550,40900,32850,31000,30750,31850,31850,29550,33450,29550,29550,33200,30950,34700,29550,29550,34950,29550,35550,33800,33300,30100,29550,30800,32400,34100,29550,29550,29550,36150,30350,29550,30650,36300,36150,29900,41350,31450,34450,29550,34350,29550,32250,29550,32050,29550,29550,34850,41350,29550,30200,29550,29550,36050,29550,36150,36150,30800,29550,32500,30900]
["12/1/2011",29950,29950,29950,29950,34250,30350,29950,36800,32250,29950,35000,29950,41450,33300,31450,31150,32800,32250,29950,33900,29950,29950,33650,32150,35350,29950,29950,35450,29950,36050,34250,34200,30500,29950,31200,32850,34600,29950,29950,29950,36600,30800,29950,31050,36800,36600,30300,41950,31900,34900,29950,34850,29950,32700,29950,32500,29950,29950,35300,41950,29950,30600,29950,29950,36550,29950,36600,36600,31200,29950,31000,31300]
["12/4/2012",29300,29300,29300,29300,32750,29300,29300,36100,32650,29300,34900,29300,40450,31650,31950,30850,32400,32650,29300,32800,29300,29300,34050,32550,35650,29300,29300,33700,29300,34800,32750,34600,30850,29300,31450,32450,32900,29300,29300,29300,35100,31200,29400,29800,36100,35100,30700,41150,31500,33800,29300,33150,29300,31100,29300,33050,29300,29300,33550,41150,29300,30500,29300,29300,34750,29300,35100,35100,31150,29300,32550,30250]
["12/18/2013",29450,29450,29450,29450,34100,29450,29450,35600,32400,29450,35400,29450,40400,33150,31750,32150,31950,32400,29450,33400,29450,29450,33600,32900,35950,29450,29450,34350,29450,33100,34100,33150,31000,29450,31200,30850,32700,29450,29450,29450,35150,31400,30200,29450,35600,35150,30750,41450,30950,32150,29450,34300,29450,30500,29450,33700,29450,29450,32550,41450,29450,30800,29450,29450,35350,29450,35150,35150,31350,29450,34150,30150]
["3/6/2015",30500,30500,30500,30500,34250,30600,30500,37700,32950,30500,36850,30500,41300,32700,32100,31900,32250,32950,30500,32350,30500,30500,35100,32250,36850,30500,30500,36350,30500,35050,34250,35100,31600,30500,31750,32650,31650,30500,30500,30500,36650,32350,31650,30500,37700,36650,31700,43300,31100,31750,30500,32750,30500,30500,30500,34400,30500,30500,34450,43300,30500,31450,30500,30500,33700,30500,36650,36650,31750,30500,35050,31250]
["3/28/2016",30100,30100,30100,30100,33300,30150,30100,36900,34400,30100,36050,30100,41950,32550,32500,31900,31850,34400,30100,33050,30100,30200,35150,30950,35950,30100,30100,34550,30100,34000,33300,33850,30600,30100,31500,31600,32700,30100,30100,30100,35100,31750,32100,30100,36900,35100,30150,42900,30200,33200,30100,34350,30100,30100,30100,33650,30100,30100,32750,42900,30100,31400,30100,30100,35250,30100,35100,35100,31600,30100,33400,32100]
["4/14/2017",31300,31300,31300,31300,34950,31300,31300,37350,33700,31300,37000,31300,42600,34400,32400,33600,32150,33700,31300,32650,31300,31300,34650,31300,35250,31300,31300,35150,31300,34850,34950,36000,31800,31300,31750,31900,34950,31300,31300,31300,36200,31300,32550,31300,37350,36200,31350,45200,31300,35500,31300,33650,31300,31600,31300,33300,31300,31300,34500,45200,31300,32000,31300,31300,33500,31300,36200,36200,32250,31300,33850,34000]
["4/1/2018",33900,33900,33900,33900,38750,33900,33900,38950,36000,33900,37950,33900,45850,37350,34150,35700,33900,36000,33900,36350,33900,33900,36300,33900,36800,33900,33900,38150,33900,37150,38750,36200,33900,33900,33900,33900,36350,33900,33900,33900,38650,33900,33900,33900,38950,38650,33900,47150,33900,38300,33900,37500,33900,33900,33900,34100,33900,33900,37350,47150,33900,34000,33900,33900,37300,33900,38650,38650,33900,33900,35550,34200]
["4/24/2019",34200,34200,34200,34200,40900,34200,34200,41900,36650,34200,39150,34200,50200,36400,35800,36200,34550,36650,34200,37650,34200,34200,38450,34200,37300,34200,34200,38650,34200,40800,40900,39300,34200,34200,34200,34450,36600,34200,34200,34200,41150,34600,34600,34200,41900,41150,34800,50000,34200,36400,34200,35650,34200,34200,34200,35250,34200,34200,38450,50000,34200,35150,34200,34200,39150,34200,41150,41150,34250,34200,39100,35300]
["4/1/2020",35400,35400,35400,35400,41150,35400,35400,43200,38350,35400,40900,35400,50050,38750,37250,38400,35750,38350,35400,39600,35400,35400,39500,35400,39250,35400,35400,38300,35400,38850,41150,38400,35400,35400,35850,37150,39500,35400,35400,35400,41900,36050,35400,35400,43200,41900,35400,51700,35400,39250,35400,38450,35400,35400,35400,36250,35400,35400,36700,51700,35400,35950,35400,35400,39500,35400,41900,41900,35900,35400,40400,36800]
["4/1/2021",35900,35900,35900,35900,40350,35900,35900,42800,40000,35900,41600,35900,51550,38950,37000,38150,36900,40000,35900,37650,35900,35900,40350,35900,40750,35900,35900,39400,35900,40750,40350,40300,35900,35900,36600,36100,39650,35900,35900,35900,42200,36600,35900,36200,42800,42200,36350,52450,35900,40200,35900,38600,35900,36500,35900,37550,35900,35900,38500,52450,35900,36650,35900,35900,39350,35900,42200,42200,37150,35900,38750,35900]
["4/18/2022",40150,40150,40150,40150,45100,40150,40150,47850,44750,40150,46250,40150,57650,40750,41150,42650,41050,44750,40150,42100,40150,40150,44400,40150,45250,40150,40150,44050,40150,44750,45100,45050,40150,40150,40750,40350,43800,40150,40150,40150,47200,40750,40150,40500,47850,47200,40650,58650,40150,44950,40150,43150,40150,40750,40150,41100,40150,40150,42300,58650,40150,40750,40150,40150,44000,40150,47200,47200,40750,40150,42500,40150]
["5/15/2023",42500,42500,42500,42500,47750,42500,42500,50650,45650,42500,48950,42500,61050,43150,43550,45150,43450,45650,42500,44550,42500,42500,47000,42500,47900,42500,42500,46650,42500,47350,47750,46700,42500,42500,43150,42700,46350,42500,42500,42500,49950,43000,42500,42850,50650,49950,43000,62100,42500,45950,42500,45700,42500,43150,42500,43500,42500,42500,44800,62100,42500,43150,42500,42500,46600,42500,49950,49950,43150,42500,45000,42500]
["4/1/2024",43300,43300,43300,43300,49000,43300,43300,52000,49700,43300,49800,43300,62950,45850,46150,47600,47200,49700,43300,47850,43300,44150,49000,43300,52650,43300,43300,50200,43300,48900,49000,49200,43750,43300,45300,43300,47400,43300,43300,43300,51050,43300,46750,44600,52000,51050,44500,62100,46000,49550,43300,48650,43300,43300,43300,47850,43300,43300,43400,62100,43300,45550,44150,43300,50600,43300,51050,51050,44750,43300,49500,43300]
["4/1/2025",46400,46400,46400,46400,53500,46400,46400,55750,51600,46400,53050,46400,64900,49250,50400,50300,49400,51600,46400,48900,46400,46400,52900,46400,56700,46400,46400,54800,46400,53400,53500,53700,46650,46400,47500,47250,49400,46400,46400,46400,55350,46400,48950,48150,55750,55350,46900,66200,48750,48900,46400,49300,46400,47250,46400,51300,46400,46400,47400,66200,46400,48850,47700,46400,54800,46400,55350,55350,47400,46400,51800,46400]
["5/1/2026",48000,48000,48000,48000,53150,48000,48000,55600,50650,48000,53650,48000,67650,50850,52400,50550,50350,50650,48000,52900,48000,48000,55000,48000,55450,48000,48000,55850,48000,58650,53150,52900,48400,48000,48000,48000,51800,48000,48000,48000,54200,48000,49750,48000,55600,54200,48000,65750,48900,53150,48000,52150,48000,48000,48000,51550,48000,48000,51600,65750,48000,50350,48000,48000,59450,48000,54200,54200,48150,48000,50250,48000]
[]
[null,{"$f":"IF(B39<>\"\",B38,\"\")","v":""},{"$f":"IF(C39<>\"\",C38,\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BO39<>\"\",BO38,\"\")","v":""},"","","","","",""]

{"sheet":"Instructions","index":2,"n_rows":52,"n_cols":1,"rows_kept":52,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
["EnterCounty&Defaults Tab"]
["Enter Project information"]
["Enter the Date of the Award Letter. This will establish the Rent Floor. In the event Income/Rents Limits decrease before the Project is Placed-in-Service, the Rent will never fall below the Rent on this date."]
["Enter the Date the Loan closes. This will establish the the Floor for the Income Limits in the event future Income/Rent Limits decrease."]
["Once this information is entered, there is no further need to update this Tab for this project."]
[]
[]
[]
["TIC"]
["Part I, enter Date of Move-in, Unit number and number of bedrooms."]
[]
["Part II, enter all household member names, Relationship to Head of Household from Dropdown and Date of Birth"]
["If entering an unborn child to count toward eligibility, enter a last name and select \"Unborn child\" from the dropdown."]
["Names entered and relationship will determine eligible household members for Income Limit."]
[]
["Part III"]
["Enter Income Source from Dropdown List"]
["Enter Pay Rate, Period and Hour per Period, as appropriate. If entering annual amount, then enter 1 for period."]
["If there are not enough rows, enter additional Income on Page 3 Tab"]
[]
["Part IV"]
["Enter asset Type, Balance"]
["Enter Interest rate or Annual Earnings. If left blank, asset will be treated as an asset that does not have any earnings and will be imputed if Total Assets are above the Imputed Asset Threshold."]
["If there are not enough rows, enter additional Assets on Page 3 Tab"]
[]
["HOUSEHOLD CERTIFICATION & SIGNATURES"]
["Have all adult household members sign and date the TIC"]
[]
["Part V"]
["Enter the tenant paid rent, Utility Allowance, Rental Assistance and Non-optional charges."]
["Verify the household qualifies under the Income and Rent Restrictions."]
[]
["SIGNATURE OF OWNER REPRESENTATIVE"]
["Owner or owner representative signs and dates the form."]
[]
["Clearing the TIC and Page 3 forms"]
["After printing the form, delete all cells in the appropriate white areas. Note: all columns that can not be deleted are protected."]
[]
[]
["Admin Notes"]
["WHEDA will update the form as necessary."]
["There are 2 hidden tabs for updating the income/rent and HUD Imputed Assets/Passbook Rate."]
["Right click on any tab to update these tabs."]
["Click on Formulas, Name Manager to update the definition range for Income/Rent"]
[]
["Updates"]
["11/20/25 - Updated Income Limits; HOTMA changes to asset calculation"]

{"sheet":"TIC Example","index":3,"n_rows":90,"n_cols":26,"rows_kept":90,"cut":false,"hidden":false,"merged":[[86,0,86,7],[14,3,14,4],[14,16,14,17],[15,0,15,7],[15,13,15,20],[31,0,31,7],[31,13,31,20],[56,0,56,7],[57,0,57,7],[58,0,58,7],[67,0,67,7],[85,0,85,7],[11,3,11,4],[11,16,11,17],[12,3,12,4],[12,16,12,17],[13,3,13,4],[13,16,13,17],[8,3,8,4],[8,16,8,17],[9,3,9,4],[9,16,9,17],[10,3,10,4],[10,16,10,17],[7,3,7,4],[7,16,7,17],[0,0,0,3],[0,13,0,16],[1,0,1,7],[1,13,1,20],[2,1,2,2],[2,14,2,15],[3,1,3,2],[3,14,3,15],[5,0,5,7],[5,13,5,20],[6,16,6,17]]}
["TENANT INCOME CERTIFICATION AFFIDAVIT",null,null,null,null,"Move-In Date","2024-08-01",null,null,null,null,null,null,"TENANT INCOME CERTIFICATION AFFIDAVIT",null,null,null,null,"Move-In Date"]
["PART I. DEVELOPMENT DATA",null,null,null,null,null,null,null,null,null,null,null,null,"PART I. DEVELOPMENT DATA"]
["Property:",{"$f":"ProjectName","v":0},null,null,"County:",{"$f":"CountyName","v":0},null,null,null,null,null,null,null,"Property:",{"$f":"ProjectName","v":0},null,null,"County:",{"$f":"CountyName","v":0}]
["Address:",{"$f":"PropertyAddress","v":0},null,null,"Unit No.",205,"#Bedrooms:",2,null,null,null,null,null,"Address:",{"$f":"PropertyAddress","v":0},null,null,"Unit No.",null,"#Bedrooms:"]
[]
["PART II. HOUSEHOLD COMPOSITION",null,null,null,null,null,null,null,null,null,null,null,null,"PART II. HOUSEHOLD COMPOSITION"]
["HH Mbr #","Last Name","First Name / Initial","Relationship to Head of Household",null,"Date of Birth",null,null,null,null,null,null,null,"HH Mbr #","Last Name","First Name / Initial","Relationship to Head of Household",null,"Date of Birth"]
[1,"Smith","Frank","Head of Household",null,"1901-01-15",{"$f":"IF(AND(B8<>\"\",D8<>\"Live-in caretaker\"),1,\"\")","v":1},null,null,null,null,null,null,1,null,null,null,null,null,{"$f":"IF(AND(O8<>\"\",Q8<>\"Live-in caretaker\"),1,\"\")","v":""}]
[2,"Smith","Mildred","Spouse",null,"1968-10-05",{"$f":"IF(AND(B9<>\"\",D9<>\"Live-in caretaker\"),1,\"\")","v":1},null,null,null,null,null,null,2,null,null,null,null,null,{"$f":"IF(AND(O9<>\"\",Q9<>\"Live-in caretaker\"),1,\"\")","v":""}]
[3,"Smith","Harry","Child",null,"2010-04-05",1,null,null,null,null,null,null,3,null,null,null,null,null,""]
[4,"Martin","Lois","Live-in caretaker",null,"2001-03-15","",null,null,null,null,null,null,4,null,null,null,null,null,""]
[5,"Smith",null,"Unborn child",null,null,1,null,null,null,null,null,null,5,null,null,null,null,null,""]
[6,null,null,null,null,null,"",null,null,null,null,null,null,6,null,null,null,null,null,""]
[7,null,null,null,null,null,"",null,null,null,null,null,null,7,null,null,null,null,null,""]
[8,null,null,null,null,null,"",null,null,null,null,null,null,8,null,null,null,null,null,""]
["PART III. GROSS ANNUAL INCOME",null,null,null,null,null,null,null,null,null,null,null,null,"PART III. GROSS ANNUAL INCOME"]
[null,null,"(A)","(B)",null,null,null,null,null,null,null,null,null,null,null,"(A)","(B)"]
[null,{"$f":"A7","v":"HH Mbr #"},"Income Type","Pay","Period","Hours","Annual Amt",null,null,null,null,null,null,null,{"$f":"N7","v":"HH Mbr #"},"Income Type","Pay","Period","Hours","Annual Amt"]
[null,1,"Employment",25,52,40,{"$f":"IFERROR(IF(F19<>0,+D19*F19*E19,+D19*E19),0)","v":52000},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Q19<>\"\",IF(P19<>\"\",VLOOKUP(P19,Income_Defaults,2,0),DefaultPeriod),\"\")","v":""},{"$f":"IF(R19=52,40,0)","v":0},{"$f":"IFERROR(IF(S19<>0,+Q19*S19*R19,+Q19*R19),0)","v":0}]
[null,1,"SS - Gross Federal",1500,12,0,{"$f":"IFERROR(IF(F20<>0,+D20*F20*E20,+D20*E20),0)","v":18000},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Q20<>\"\",IF(P20<>\"\",VLOOKUP(P20,Income_Defaults,2,0),DefaultPeriod),\"\")","v":""},{"$f":"IF(R20=52,40,0)","v":0},{"$f":"IFERROR(IF(S20<>0,+Q20*S20*R20,+Q20*R20),0)","v":0}]
[null,2,"SSI - Gross Federal",450,12,0,5400,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Q21<>\"\",IF(P21<>\"\",VLOOKUP(P21,Income_Defaults,2,0),DefaultPeriod),\"\")","v":""},0,0]
[null,2,"State SSI",83.78,12,0,1005.36,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Q22<>\"\",IF(P22<>\"\",VLOOKUP(P22,Income_Defaults,2,0),DefaultPeriod),\"\")","v":""},0,0]
[null,null,null,null,"",{"$f":"IF(E23=52,40,0)","v":0},0,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,"",0,0,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,"",0,0,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,"",0,0,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,"",0,0,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,"",0,0,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,"",0,0,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,{"$f":"IF('Page 3 Example'!G22>0,\"Additional from Page 3\",\"\")","v":"Additional from Page 3"},null,null,null,{"$f":"IF(C30<>\"\",'Page 3 Example'!G22,\"\")","v":41600},null,null,null,null,null,null,null,null,{"$f":"IF(#REF!>0,\"Additional from Page 3\",\"\")","v":{"$error":"#REF!"}},null,null,null,{"$f":"IF(P30<>\"\",#REF!,\"\")","v":{"$error":"#REF!"}}]
[null,"TOTALS",null,null,null,null,{"$f":"SUM(G19:G30)","v":118005.36},null,null,null,null,null,null,null,"TOTALS",null,null,null,null,{"$f":"SUM(T19:T30)","v":{"$error":"#REF!"}}]
["PART IV. INCOME FROM ASSETS",null,null,null,null,null,null,null,null,null,null,null,null,"PART IV. INCOME FROM ASSETS"]
[null,{"$f":"A7","v":"HH Mbr #"},"Asset Type","Cash Value","Int. rate","or Actual $","Income",null,null,null,null,null,null,null,{"$f":"N7","v":"HH Mbr #"},"Asset Type","Cash Value","Int. rate","or Actual $","Income",null,null,"NNPP Bal","RE Bal","NNPP Inc.","RE Inc."]
[null,1,"Checking Acct",5000,4.0000000000000002E-4,null,{"$f":"SUM(Y34:Z34)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND($D$54>VLOOKUP($G$1,HUDAssetThreshold,2,1),AND(R34=\"\",S34=\"\")),Q34*VLOOKUP($G$1,HUDImputedRate,3,1),IF(S34=0,Q34*R34,S34))","v":{"$error":"#N/A"}},null,null,{"$f":"IFERROR(IF(VLOOKUP($C34,Asset_Description_Type,2,0)=\"NNPP\",$D34,0),0)","v":5000},{"$f":"IFERROR(IF(VLOOKUP($C34,Asset_Description_Type,2,0)=\"RE\",$D34,0),0)","v":0},{"$f":"IF(AND(NNPP_Total>VLOOKUP(MI_Date,HUDAssetThreshold,2,1),AND($E34=\"\",$F34=\"\")),W34*VLOOKUP(MI_Date,HUDImputedRate,3,1),IF($F34=0,W34*$E34,$F34))","v":{"$error":"#N/A"}},{"$f":"IF(AND(Net_Family_Assets_Total>VLOOKUP(MI_Date,HUDAssetThreshold,2,1),AND($E34=\"\",$F34=\"\")),X34*VLOOKUP(MI_Date,HUDImputedRate,3,1),IF($F34=0,X34*$E34,$F34))","v":{"$error":"#N/A"}}]
[null,1,"Savings Acct",5000,5.0000000000000001E-4,null,{"$f":"SUM(Y35:Z35)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND($D$54>VLOOKUP($G$1,HUDAssetThreshold,2,1),AND(R35=\"\",S35=\"\")),Q35*VLOOKUP($G$1,HUDImputedRate,3,1),IF(S35=0,Q35*R35,S35))","v":{"$error":"#N/A"}},null,null,{"$f":"IFERROR(IF(VLOOKUP($C35,Asset_Description_Type,2,0)=\"NNPP\",$D35,0),0)","v":5000},{"$f":"IFERROR(IF(VLOOKUP($C35,Asset_Description_Type,2,0)=\"RE\",$D35,0),0)","v":0},{"$f":"IF(AND(NNPP_Total>VLOOKUP(MI_Date,HUDAssetThreshold,2,1),AND($E35=\"\",$F35=\"\")),W35*VLOOKUP(MI_Date,HUDImputedRate,3,1),IF($F35=0,W35*$E35,$F35))","v":{"$error":"#N/A"}},{"$f":"IF(AND(Net_Family_Assets_Total>VLOOKUP(MI_Date,HUDAssetThreshold,2,1),AND($E35=\"\",$F35=\"\")),X35*VLOOKUP(MI_Date,HUDImputedRate,3,1),IF($F35=0,X35*$E35,$F35))","v":{"$error":"#N/A"}}]
[null,1,"Real Estate",150000,null,null,{"$f":"SUM(Y36:Z36)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND($D$54>VLOOKUP($G$1,HUDAssetThreshold,2,1),AND(R36=\"\",S36=\"\")),Q36*VLOOKUP($G$1,HUDImputedRate,3,1),IF(S36=0,Q36*R36,S36))","v":{"$error":"#N/A"}},null,null,{"$f":"IFERROR(IF(VLOOKUP($C36,Asset_Description_Type,2,0)=\"NNPP\",$D36,0),0)","v":0},{"$f":"IFERROR(IF(VLOOKUP($C36,Asset_Description_Type,2,0)=\"RE\",$D36,0),0)","v":150000},{"$f":"IF(AND(NNPP_Total>VLOOKUP(MI_Date,HUDAssetThreshold,2,1),AND($E36=\"\",$F36=\"\")),W36*VLOOKUP(MI_Date,HUDImputedRate,3,1),IF($F36=0,W36*$E36,$F36))","v":{"$error":"#N/A"}},{"$f":"IF(AND(Net_Family_Assets_Total>VLOOKUP(MI_Date,HUDAssetThreshold,2,1),AND($E36=\"\",$F36=\"\")),X36*VLOOKUP(MI_Date,HUDImputedRate,3,1),IF($F36=0,X36*$E36,$F36))","v":{"$error":"#N/A"}}]
[null,2,"Savings Acct",1000,5.0000000000000001E-4,null,{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND($D$54>VLOOKUP($G$1,HUDAssetThreshold,2,1),AND(R37=\"\",S37=\"\")),Q37*VLOOKUP($G$1,HUDImputedRate,3,1),IF(S37=0,Q37*R37,S37))","v":{"$error":"#N/A"}},null,null,{"$f":"IFERROR(IF(VLOOKUP($C37,Asset_Description_Type,2,0)=\"NNPP\",$D37,0),0)","v":1000},{"$f":"IFERROR(IF(VLOOKUP($C37,Asset_Description_Type,2,0)=\"RE\",$D37,0),0)","v":0},{"$f":"IF(AND(NNPP_Total>VLOOKUP(MI_Date,HUDAssetThreshold,2,1),AND($E37=\"\",$F37=\"\")),W37*VLOOKUP(MI_Date,HUDImputedRate,3,1),IF($F37=0,W37*$E37,$F37))","v":{"$error":"#N/A"}},{"$f":"IF(AND(Net_Family_Assets_Total>VLOOKUP(MI_Date,HUDAssetThreshold,2,1),AND($E37=\"\",$F37=\"\")),X37*VLOOKUP(MI_Date,HUDImputedRate,3,1),IF($F37=0,X37*$E37,$F37))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,{"$f":"IF(AND($D$54>50000,AND(E38=\"\",F38=\"\")),D38*0.4%,IF(F38=0,D38*E38,F38))","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND($D$54>50000,AND(R38=\"\",S38=\"\")),Q38*0.4%,IF(S38=0,Q38*R38,S38))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,{"$f":"IF('Page 3 Example'!D45>0,\"Add'l from Pg 3\",\"\")","v":"Add'l from Pg 3"},{"$f":"IF(C51<>\"\",'Page 3 Example'!D45,\"\")","v":5000},null,null,{"$f":"IF(C51<>\"\",'Page 3 Example'!G45,\"\")","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(W34:W37)","v":11000},{"$f":"SUM(X34:X37)","v":150000},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"NNPP Total",null,{"$f":"IF(W51+'Page 3 Example'!W45>VLOOKUP(MI_Date,HUDAssetThreshold,2,1),'TIC Example'!W51+'Page 3 Example'!W45,0)","v":{"$error":"#N/A"}}]
[null,"RE Total",null,{"$f":"X51+'Page 3 Example'!X45","v":150000}]
[null,"NET FAMILY ASSETS TOTAL",null,{"$f":"D52+D53","v":{"$error":"#N/A"}},null,null,{"$f":"SUM(G34:G51)","v":{"$error":"#N/A"}}]
[null,"TOTAL ANNUAL INCOME",null,null,null,null,{"$f":"G31+G54","v":{"$error":"#N/A"}}]
[null,"HUD Threshold",{"$f":"VLOOKUP($G$1,HUDAssetThreshold,2,1)","v":50000},"HUD Passbook",{"$f":"VLOOKUP($G$1,HUDImputedRate,3,1)","v":4.0000000000000001E-3}]
["HOUSEHOLD CERTIFICATION & SIGNATURES"]
["The information on this form will be used to determine maximum income eligibility. I/we have provided for each person(s) set forth in Part II acceptable verification of current anticipated annual income. I/we agree to notify the landlord immediately upon any member of the household moving out of the unit or any new member moving in."]
["Under penalties of perjury, I/we certify that the information presented in this Certification is true and accurate to the best of my/our knowledge and belief. The undersigned further understands that providing false representations herein constitutes an act of fraud. False, misleading or incomplete information may result in the termination of the lease agreement. "]
[]
["__________________________________",null,null,"________","__________________________________",null,null,"________"]
["Signature",null,null,"Date","Signature",null,null,"Date"]
[]
["__________________________________",null,null,"________","__________________________________",null,null,"________"]
["Signature",null,null,"Date","Signature",null,null,"Date"]
[]
[]
["PART V. DETERMINATION OF INCOME ELIGIBILITY"]
["TOTAL ANNUAL HOUSEHOLD INCOME FR4OM ALL SOURCES",null,null,null,null,{"$f":"G55","v":{"$error":"#N/A"}}]
[]
["Current Income Limit per Family Size:",null,null,{"$f":"SUM(G8:G15)","v":4},null,{"$f":"VLOOKUP($G$1,IncomeLimit,D71+1)/0.5*ProjectSetAside","v":{"$error":"#N/A"}},{"$f":"ProjectSetAside","v":1}]
["Household Income Qualified",null,null,null,null,{"$f":"IF(F69<=F71,\"Yes\",\"No\")","v":{"$error":"#N/A"}}]
[]
["Tenant Paid Rent",null,null,null,null,800]
["Utility Allowance",null,null,null,null,100]
["Rental Assistance"]
["Other non-optional charges and mandatory fees"]
["Gross Rent",null,null,null,null,{"$f":"F74+F75+F77","v":900}]
[]
["Maximum Rent Limit",null,null,null,null,{"$f":"TRUNC(IF(NOT(ISBLANK($H$4)),MAX(VLOOKUP(MI_Date,RentLimit,$H$4+2),VLOOKUP(DateGrossRentFloor,RentLimit,$H$4+2)),\"\")/0.5*ProjectSetAside)","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP(MI_Date,RentLimit,$H$4+2)<=VLOOKUP(DateGrossRentFloor,RentLimit,$H$4+2),\"Rent Floor\",\"\")","v":{"$error":"#N/A"}}]
["Household Rent Qualified",null,null,null,null,{"$f":"IF(F78<=F80,\"Yes\",\"No\")","v":{"$error":"#N/A"}}]
[]
["Household Qualified to Move-in",null,null,null,null,{"$f":"IF(AND(F69<=F71,F78<=F80),\"Qualified\",\"Not Qualified\")","v":{"$error":"#N/A"}}]
[]
[]
["SIGNATURE OF OWNER REPRESENTATIVE"]
["Based on the representations herein and upon the proofs and documentation required to be submitted, the individual(s) named in Part II of this Tenant Income Certification is/are eligible under the provisions of Act 15 or Act 18, as amended, and the Land Use Restriction Agreement (if applicable), to live in a unit in this Project. "]
[]
["___________________________________",null,null,null,"________________"]
["SIGNATURE OF OWNER REPRESENTATIVE",null,null,null,"DATE"]

{"sheet":"Page 3 Example","index":4,"n_rows":45,"n_cols":26,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
["TIC-Additional Income / Asset Page"]
[]
[null,"Additional Income "]
[null,"HH Mbr #","Income Type","Pay","Period","Hours","Annual Amt",null,null,null,null,null,null,{"$f":"B4","v":"HH Mbr #"},"Income Type","Pay","Period","Hours","Annual Amt"]
[null,2,"Employment",20,52,40,{"$f":"IFERROR(IF(F5<>0,+D5*F5*E5,+D5*E5),0)","v":41600},null,null,null,null,null,null,null,null,null,{"$f":"IF(P5<>\"\",IF(O5<>\"\",VLOOKUP(O5,Income_Defaults,2,0),DefaultPeriod),\"\")","v":""},{"$f":"IF(Q5=52,40,0)","v":0},{"$f":"IFERROR(IF(R5<>0,+P5*R5*Q5,+P5*Q5),0)","v":0}]
[null,null,null,null,null,null,{"$f":"IFERROR(IF(F6<>0,+D6*F6*E6,+D6*E6),0)","v":0},null,null,null,null,null,null,null,null,null,"",{"$f":"IF(Q6=52,40,0)","v":0},{"$f":"IFERROR(IF(R6<>0,+P6*R6*Q6,+P6*Q6),0)","v":0}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,"",0,0]
[null,"TOTALS",null,null,null,null,{"$f":"SUM(G5:G21)","v":41600},null,null,null,null,null,null,"TOTALS",null,null,null,null,{"$f":"SUM(S5:S21)","v":0}]
[]
[null,"Additional Assets",null,null,null,null,null,null,null,null,null,null,null,"Additional Assets"]
[null,{"$f":"B4","v":"HH Mbr #"},"Asset Type","Cash Value","Int. rate","or Actual $","Income",null,null,null,null,null,null,{"$f":"N4","v":"HH Mbr #"},"Asset Type","Cash Value","Int. rate","or Actual $","Income",null,null,null,"NNPP Bal","RE Bal","NNPP Inc.","RE Inc."]
[null,2,"Savings Acct",5000,0.03,null,{"$f":"SUM(Y26:Z26)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(#REF!>VLOOKUP(#REF!,HUDAssetThreshold,2,1),AND(Q26=\"\",R26=\"\")),P26*0.4%,IF(R26=0,P26*Q26,R26))","v":{"$error":"#REF!"}},null,null,null,{"$f":"IFERROR(IF(VLOOKUP($C26,Asset_Description_Type,2,0)=\"NNPP\",$D26,0),0)","v":5000},{"$f":"IFERROR(IF(VLOOKUP($C26,Asset_Description_Type,2,0)=\"RE\",$D26,0),0)","v":0},{"$f":"IF(AND(NNPP_Total>VLOOKUP(MI_Date,HUDAssetThreshold,2,1),AND($E26=\"\",$F26=\"\")),W26*VLOOKUP(MI_Date,HUDImputedRate,3,1),IF($F26=0,W26*$E26,$F26))","v":{"$error":"#N/A"}},{"$f":"IF(AND(Net_Family_Assets_Total>VLOOKUP(MI_Date,HUDAssetThreshold,2,1),AND($E26=\"\",$F26=\"\")),X26*VLOOKUP(MI_Date,HUDImputedRate,3,1),IF($F26=0,X26*$E26,$F26))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,{"$f":"SUM(Y27:Z27)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(#REF!>VLOOKUP(#REF!,HUDAssetThreshold,2,1),AND(Q27=\"\",R27=\"\")),P27*0.4%,IF(R27=0,P27*Q27,R27))","v":{"$error":"#REF!"}},null,null,null,0,0,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,{"$f":"SUM(Y28:Z28)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(#REF!>VLOOKUP(#REF!,HUDAssetThreshold,2,1),AND(Q28=\"\",R28=\"\")),P28*0.4%,IF(R28=0,P28*Q28,R28))","v":{"$error":"#REF!"}},null,null,null,0,0,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(#REF!>VLOOKUP(#REF!,HUDAssetThreshold,2,1),AND(Q29=\"\",R29=\"\")),P29*0.4%,IF(R29=0,P29*Q29,R29))","v":{"$error":"#REF!"}},null,null,null,0,0,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(#REF!>VLOOKUP(#REF!,HUDAssetThreshold,2,1),AND(Q30=\"\",R30=\"\")),P30*0.4%,IF(R30=0,P30*Q30,R30))","v":{"$error":"#REF!"}},null,null,null,0,0,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(#REF!>VLOOKUP(#REF!,HUDAssetThreshold,2,1),AND(Q31=\"\",R31=\"\")),P31*0.4%,IF(R31=0,P31*Q31,R31))","v":{"$error":"#REF!"}},null,null,null,0,0,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(#REF!>VLOOKUP(#REF!,HUDAssetThreshold,2,1),AND(Q32=\"\",R32=\"\")),P32*0.4%,IF(R32=0,P32*Q32,R32))","v":{"$error":"#REF!"}},null,null,null,0,0,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(#REF!>VLOOKUP(#REF!,HUDAssetThreshold,2,1),AND(Q33=\"\",R33=\"\")),P33*0.4%,IF(R33=0,P33*Q33,R33))","v":{"$error":"#REF!"}},null,null,null,0,0,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(#REF!>VLOOKUP(#REF!,HUDAssetThreshold,2,1),AND(Q34=\"\",R34=\"\")),P34*0.4%,IF(R34=0,P34*Q34,R34))","v":{"$error":"#REF!"}},null,null,null,0,0,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(#REF!>VLOOKUP(#REF!,HUDAssetThreshold,2,1),AND(Q35=\"\",R35=\"\")),P35*0.4%,IF(R35=0,P35*Q35,R35))","v":{"$error":"#REF!"}},null,null,null,0,0,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(#REF!>VLOOKUP(#REF!,HUDAssetThreshold,2,1),AND(Q36=\"\",R36=\"\")),P36*0.4%,IF(R36=0,P36*Q36,R36))","v":{"$error":"#REF!"}},null,null,null,0,0,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(#REF!>VLOOKUP(#REF!,HUDAssetThreshold,2,1),AND(Q37=\"\",R37=\"\")),P37*0.4%,IF(R37=0,P37*Q37,R37))","v":{"$error":"#REF!"}},null,null,null,0,0,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(#REF!>VLOOKUP(#REF!,HUDAssetThreshold,2,1),AND(Q38=\"\",R38=\"\")),P38*0.4%,IF(R38=0,P38*Q38,R38))","v":{"$error":"#REF!"}},null,null,null,0,0,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(#REF!>VLOOKUP(#REF!,HUDAssetThreshold,2,1),AND(Q39=\"\",R39=\"\")),P39*0.4%,IF(R39=0,P39*Q39,R39))","v":{"$error":"#REF!"}},null,null,null,0,0,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(#REF!>VLOOKUP(#REF!,HUDAssetThreshold,2,1),AND(Q40=\"\",R40=\"\")),P40*0.4%,IF(R40=0,P40*Q40,R40))","v":{"$error":"#REF!"}},null,null,null,0,0,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(#REF!>VLOOKUP(#REF!,HUDAssetThreshold,2,1),AND(Q41=\"\",R41=\"\")),P41*0.4%,IF(R41=0,P41*Q41,R41))","v":{"$error":"#REF!"}},null,null,null,0,0,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(#REF!>VLOOKUP(#REF!,HUDAssetThreshold,2,1),AND(Q42=\"\",R42=\"\")),P42*0.4%,IF(R42=0,P42*Q42,R42))","v":{"$error":"#REF!"}},null,null,null,0,0,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(#REF!>VLOOKUP(#REF!,HUDAssetThreshold,2,1),AND(Q43=\"\",R43=\"\")),P43*0.4%,IF(R43=0,P43*Q43,R43))","v":{"$error":"#REF!"}},null,null,null,0,0,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,{"$f":"SUM(Y44:Z44)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(#REF!>VLOOKUP(#REF!,HUDAssetThreshold,2,1),AND(Q44=\"\",R44=\"\")),P44*0.4%,IF(R44=0,P44*Q44,R44))","v":{"$error":"#REF!"}},null,null,null,0,0,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"ASSETS TOTAL",null,{"$f":"SUM(D26:D44)","v":5000},null,null,{"$f":"SUM(G26:G44)","v":{"$error":"#N/A"}},null,null,null,null,null,null,"ASSETS TOTAL",null,{"$f":"SUM(P26:P44)","v":0},null,null,{"$f":"SUM(S26:S44)","v":{"$error":"#REF!"}},null,null,null,{"$f":"SUM(W26:W44)","v":5000},{"$f":"SUM(X26:X44)","v":0},{"$error":"#N/A"},{"$error":"#N/A"}]

{"sheet":"EnterCounty&Defaults","index":5,"n_rows":119,"n_cols":77,"rows_kept":119,"cut":false,"hidden":false,"merged":[[19,0,19,8],[8,1,8,3],[0,0,0,6],[7,26,8,26],[17,0,17,8],[7,1,7,3],[18,0,18,8]]}
["Project Information"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J2=\"Word Macro\",\"**PARAGRAPH\",\"\")","v":""}]
[]
[]
["Dt Award Ltr",null,"Enter Date of Award Letter to establish Rent Floor."]
["Dt Loan Closed",null,"Enter Date Placed-in-Service Date for Program"]
["HERA Project","N","Enter Y if project uses the HERA Limit",null,null,null,{"$f":"IF(PISD>DATE(2008,12,31),\"NOT HERA!\",\"\")","v":""}]
["Project Name",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eligible Basis:","Garage","Cable","Washer/Dryer"]
["Address",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N","N","N",null,null,null,"Default",52,"Enter default period for calculation of income"]
["Set Aside %",1,"Enter Set Aside for project (100%)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Usually 12 months or 52 weeks"]
["County",null,"Enter county"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"CONCATENATE(CountyName,\" County 50% Table\")","v":" County 50% Table"}]
[null,0.7,0.8,0.9,null,1.08,1.1599999999999999,1.24,1.32,1.4]
[null,1,2,3,4,5,6,7,8,9,"Hold Harmless"]
["1987-01-01",{"$f":"INT(ROUND($E25*B$23/50,0)*50)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(ISNA(HLOOKUP(CountyName,CountyData,ROW($A25)-23,FALSE))=FALSE,HLOOKUP(CountyName,CountyData,ROW(A25)-23,FALSE),HLOOKUP(\"Counties\",CountyName,ROW($A25)-23,FALSE))","v":{"$error":"#N/A"}},{"$f":"INT(ROUND($E25*F$23/50,0)*50)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["1991-05-01",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(A26>PISD,1,0)","v":1}]
["1992-04-16",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},1]
["1993-05-05",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},1]
["1994-05-31",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},1]
["1995-01-18",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},1]
["1995-12-07",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},1]
["1996-12-27",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},1]
["1998-01-07",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},1]
["1999-01-27",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},1]
["2000-03-09",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},1]
["2001-04-06",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},1]
["2002-01-31",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(ISNA(HLOOKUP(CountyName,CountyData,ROW($A37)-23,FALSE))=FALSE,HLOOKUP(CountyName,CountyData,ROW(A37)-23,FALSE),HLOOKUP(\"Counties\",CountyName,ROW($A37)-23,FALSE))","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},1]
["2003-02-20",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},1]
["2004-01-28",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},1]
["2005-02-11",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},1]
["2006-03-08",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},1]
["2007-03-20",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},1]
["2008-02-13",{"$error":"#N/A"},{"$f":"INT(ROUND($E43*C$23/50,0)*50)","v":{"$error":"#N/A"}},{"$f":"INT(ROUND($E43*D$23/50,0)*50)","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(HLOOKUP(CountyName,CountyData,ROW($A43)-23,FALSE))=FALSE,HLOOKUP(CountyName,CountyData,ROW(A43)-23,FALSE),HLOOKUP(\"Counties\",CountyName,ROW($A43)-23,FALSE))","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},1]
["2009-03-19",{"$error":"#N/A"},{"$f":"INT(ROUND($E44*C$23/50,0)*50)","v":{"$error":"#N/A"}},{"$f":"INT(ROUND($E44*D$23/50,0)*50)","v":{"$error":"#N/A"}},{"$f":"IF(_xlfn.SINGLE(HERA)=\"Y\",HLOOKUP(CountyName,HERAData,ROW(A44)-23,FALSE),IF(AND(K44=1,HLOOKUP(CountyName,CountyData,ROW(A44)-23,FALSE)<E43),E43,HLOOKUP(CountyName,CountyData,ROW(A44)-23,FALSE)))","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},1]
["2010-05-14",{"$f":"INT(CEILING($E45*B$23/50,1)*50)","v":{"$error":"#N/A"}},{"$f":"INT(CEILING($E45*C$23/50,1)*50)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"INT(CEILING($E45*F$23/50,1)*50)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},1]
["2011-05-31",{"$f":"INT(CEILING($E46*B$23/50,1)*50)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},1]
["2011-12-01",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},1]
["2012-12-04",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},1]
["2013-12-18",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},1]
["2015-03-06",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(_xlfn.SINGLE(HERA)=\"Y\",HLOOKUP(CountyName,HERAData,ROW(A50)-23,FALSE),IF(AND(K50=1,HLOOKUP(CountyName,CountyData,ROW(A50)-23,FALSE)<E49),E49,HLOOKUP(CountyName,CountyData,ROW(A50)-23,FALSE)))","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(A50>PISD,1,0)","v":1}]
["2016-03-28",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(_xlfn.SINGLE(HERA)=\"Y\",HLOOKUP(CountyName,HERAData,ROW(A51)-23,FALSE),IF(AND(K51=1,HLOOKUP(CountyName,CountyData,ROW(A51)-23,FALSE)<E50),E50,HLOOKUP(CountyName,CountyData,ROW(A51)-23,FALSE)))","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(A51>PISD,1,0)","v":1}]
["2017-04-14",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(_xlfn.SINGLE(HERA)=\"Y\",HLOOKUP(CountyName,HERAData,ROW(A52)-23,FALSE),IF(AND(K52=1,HLOOKUP(CountyName,CountyData,ROW(A52)-23,FALSE)<E51),E51,HLOOKUP(CountyName,CountyData,ROW(A52)-23,FALSE)))","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(A52>PISD,1,0)","v":1}]
["2018-04-01",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(_xlfn.SINGLE(HERA)=\"Y\",HLOOKUP(CountyName,HERAData,ROW(A53)-23,FALSE),IF(AND(K53=1,HLOOKUP(CountyName,CountyData,ROW(A53)-23,FALSE)<E52),E52,HLOOKUP(CountyName,CountyData,ROW(A53)-23,FALSE)))","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(A53>PISD,1,0)","v":1}]
["2019-04-24",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(_xlfn.SINGLE(HERA)=\"Y\",HLOOKUP(CountyName,HERAData,ROW(A54)-23,FALSE),IF(AND(K54=1,HLOOKUP(CountyName,CountyData,ROW(A54)-23,FALSE)<E53),E53,HLOOKUP(CountyName,CountyData,ROW(A54)-23,FALSE)))","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(A54>PISD,1,0)","v":1}]
["2020-04-01",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(_xlfn.SINGLE(HERA)=\"Y\",HLOOKUP(CountyName,HERAData,ROW(A55)-23,FALSE),IF(AND(K55=1,HLOOKUP(CountyName,CountyData,ROW(A55)-23,FALSE)<E54),E54,HLOOKUP(CountyName,CountyData,ROW(A55)-23,FALSE)))","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(A55>PISD,1,0)","v":1}]
["2021-04-01",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},1]
["2022-04-18",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(_xlfn.SINGLE(HERA)=\"Y\",HLOOKUP(CountyName,HERAData,ROW(A57)-23,FALSE),IF(AND(K57=1,HLOOKUP(CountyName,CountyData,ROW(A57)-23,FALSE)<E56),E56,HLOOKUP(CountyName,CountyData,ROW(A57)-23,FALSE)))","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(A57>PISD,1,0)","v":1}]
["2023-05-15",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(_xlfn.SINGLE(HERA)=\"Y\",HLOOKUP(CountyName,HERAData,ROW(A58)-23,FALSE),IF(AND(K58=1,HLOOKUP(CountyName,CountyData,ROW(A58)-23,FALSE)<E57),E57,HLOOKUP(CountyName,CountyData,ROW(A58)-23,FALSE)))","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(A58>PISD,1,0)","v":1}]
["2024-04-01",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(_xlfn.SINGLE(HERA)=\"Y\",HLOOKUP(CountyName,HERAData,ROW(A59)-23,FALSE),IF(AND(K59=1,HLOOKUP(CountyName,CountyData,ROW(A59)-23,FALSE)<E58),E58,HLOOKUP(CountyName,CountyData,ROW(A59)-23,FALSE)))","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(A59>PISD,1,0)","v":1}]
["2025-04-01",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(_xlfn.SINGLE(HERA)=\"Y\",HLOOKUP(CountyName,HERAData,ROW(A60)-23,FALSE),IF(AND(K60=1,HLOOKUP(CountyName,CountyData,ROW(A60)-23,FALSE)<E59),E59,HLOOKUP(CountyName,CountyData,ROW(A60)-23,FALSE)))","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(A60>PISD,1,0)","v":1}]
["2026-05-01",{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"INT(CEILING($E61*D$23/50,1)*50)","v":{"$error":"#N/A"}},{"$f":"IF(_xlfn.SINGLE(HERA)=\"Y\",HLOOKUP(CountyName,HERAData,ROW(A61)-23,FALSE),IF(AND(K61=1,HLOOKUP(CountyName,CountyData,ROW(A61)-23,FALSE)<E60),E60,HLOOKUP(CountyName,CountyData,ROW(A61)-23,FALSE)))","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(A61>PISD,1,0)","v":1}]
[]
[]
["Bedroom","Eff",1,2,3,4,5,6]
[{"$f":"A25","v":"1987-01-01"},{"$f":"(B25*0.3/12)","v":{"$error":"#N/A"}},{"$f":"((B25+C25)/2/12*0.3)","v":{"$error":"#N/A"}},{"$f":"(D25*0.3/12)","v":{"$error":"#N/A"}},{"$f":"((E25+F25)/2/12*0.3)","v":{"$error":"#N/A"}},{"$f":"(G25*0.3/12)","v":{"$error":"#N/A"}},{"$f":"((H25+I25)/2/12*0.3)","v":{"$error":"#N/A"}},{"$f":"(J25*0.3/12)","v":{"$error":"#N/A"}}]
["1991-05-01",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["1992-04-16",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["1993-05-05",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["1994-05-31",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["1995-01-18",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["1995-12-07",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["1996-12-27",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["1998-01-07",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["1999-01-27",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["2000-03-09",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["2001-04-06",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["2002-01-31",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["2003-02-20",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["2004-01-28",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["2005-02-11",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["2006-03-08",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["2007-03-20",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["2008-02-13",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["2009-03-19",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["2010-05-14",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["2011-05-31",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["2011-12-01",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["2012-12-04",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["2013-12-18",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["2015-03-06",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["2016-03-28",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["2017-04-14",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["2018-04-01",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["2019-04-24",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["2020-04-01",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["2021-04-01",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["2022-04-18",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["2023-05-15",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["2024-04-01",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["2025-04-01",{"$error":"#N/A"},{"$f":"((B60+C60)/2/12*0.3)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"((E60+F60)/2/12*0.3)","v":{"$error":"#N/A"}},{"$f":"(G60*0.3/12)","v":{"$error":"#N/A"}},{"$f":"((H60+I60)/2/12*0.3)","v":{"$error":"#N/A"}},{"$f":"(J60*0.3/12)","v":{"$error":"#N/A"}}]
[{"$f":"A61","v":"2026-05-01"},{"$f":"(B61*0.3/12)","v":{"$error":"#N/A"}},{"$f":"((B61+C61)/2/12*0.3)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"((E61+F61)/2/12*0.3)","v":{"$error":"#N/A"}},{"$f":"(G61*0.3/12)","v":{"$error":"#N/A"}},{"$f":"((H61+I61)/2/12*0.3)","v":{"$error":"#N/A"}},{"$f":"(J61*0.3/12)","v":{"$error":"#N/A"}}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Automatic County Input",null,"SA",{"$f":"VLOOKUP(Project,ProjectInfo,5,0)","v":{"$error":"#NAME?"}}]
[null,"ADAMS","ASHLAND","BARRON","BAYFIELD","BROWN","BUFFALO","BURNETT","CALUMET","CHIPPEWA","CLARK","COLUMBIA","CRAWFORD","DANE","DODGE","DOOR","DOUGLAS","DUNN","EAU CLAIRE","FLORENCE","FOND DU LAC","FOREST","GRANT","GREEN","GREEN LAKE","IOWA","IRON","JACKSON","JEFFERSON","JUNEAU","KENOSHA","KEWAUNEE","LA CROSSE","LAFAYETTE","LANGLADE","LINCOLN","MANITOWOC","MARATHON","MARINETTE","MARQUETTE","MENOMINEE","MILWAUKEE","MONROE","OCONTO","ONEIDA","OUTAGAMIE","OZAUKEE","PEPIN","PIERCE","POLK","PORTAGE","PRICE","RACINE","RICHLAND","ROCK","RUSK","SAUK","SAWYER","SHAWANO","SHEBOYGAN","ST. CROIX","TAYLOR","TREMPEALEAU","VERNON","VILAS","WALWORTH","WASHBURN","WASHINGTON","WAUKESHA","WAUPACA","WAUSHARA","WINNEBAGO","WOOD",{"$f":"VLOOKUP(Project,ProjectInfo,3,0)","v":{"$error":"#NAME?"}},null,null,{"$f":"RIGHT(BY118,2)*0.01","v":{"$error":"#NAME?"}}]

{"sheet":"TIC","index":6,"n_rows":92,"n_cols":26,"rows_kept":92,"cut":false,"hidden":false,"merged":[[85,0,85,7],[86,0,86,7],[31,0,31,7],[31,13,31,20],[56,0,56,7],[57,0,57,7],[58,0,58,7],[67,0,67,7],[13,3,13,4],[13,16,13,17],[14,3,14,4],[14,16,14,17],[15,0,15,7],[15,13,15,20],[10,3,10,4],[10,16,10,17],[11,3,11,4],[11,16,11,17],[12,3,12,4],[12,16,12,17],[7,3,7,4],[7,16,7,17],[8,3,8,4],[8,16,8,17],[9,3,9,4],[9,16,9,17],[3,1,3,2],[3,14,3,15],[5,0,5,7],[5,13,5,20],[6,16,6,17],[0,0,0,3],[0,13,0,16],[1,0,1,7],[1,13,1,20],[2,1,2,2],[2,14,2,15]]}
["TENANT INCOME CERTIFICATION AFFIDAVIT",null,null,null,null,"Move-In Date",null,null,null,null,null,null,null,"TENANT INCOME CERTIFICATION AFFIDAVIT",null,null,null,null,"Move-In Date"]
["PART I. DEVELOPMENT DATA",null,null,null,null,null,null,null,null,null,null,null,null,"PART I. DEVELOPMENT DATA"]
["Property:",{"$f":"ProjectName","v":0},null,null,"County:",{"$f":"CountyName","v":0},null,null,null,null,null,null,null,"Property:",{"$f":"ProjectName","v":0},null,null,"County:",{"$f":"CountyName","v":0}]
["Address:",{"$f":"PropertyAddress","v":0},null,null,"Unit No.",null,"#Bedrooms:",null,null,null,null,null,null,"Address:",{"$f":"PropertyAddress","v":0},null,null,"Unit No.",null,"#Bedrooms:"]
[]
["PART II. HOUSEHOLD COMPOSITION",null,null,null,null,null,null,null,null,null,null,null,null,"PART II. HOUSEHOLD COMPOSITION"]
["HH Mbr #","Last Name","First Name / Initial","Relationship to Head of Household",null,"Date of Birth",null,null,null,null,null,null,null,"HH Mbr #","Last Name","First Name / Initial","Relationship to Head of Household",null,"Date of Birth"]
[1,null,null,null,null,null,{"$f":"IF(AND(B8<>\"\",D8<>\"Live-in caretaker\"),1,\"\")","v":""},null,null,null,null,null,null,1,null,null,null,null,null,{"$f":"IF(AND(O8<>\"\",Q8<>\"Live-in caretaker\"),1,\"\")","v":""}]
[2,null,null,null,null,null,{"$f":"IF(AND(B9<>\"\",D9<>\"Live-in caretaker\"),1,\"\")","v":""},null,null,null,null,null,null,2,null,null,null,null,null,{"$f":"IF(AND(O9<>\"\",Q9<>\"Live-in caretaker\"),1,\"\")","v":""}]
[3,null,null,null,null,null,"",null,null,null,null,null,null,3,null,null,null,null,null,""]
[4,null,null,null,null,null,"",null,null,null,null,null,null,4,null,null,null,null,null,""]
[5,null,null,null,null,null,"",null,null,null,null,null,null,5,null,null,null,null,null,""]
[6,null,null,null,null,null,"",null,null,null,null,null,null,6,null,null,null,null,null,""]
[7,null,null,null,null,null,"",null,null,null,null,null,null,7,null,null,null,null,null,""]
[8,null,null,null,null,null,"",null,null,null,null,null,null,8,null,null,null,null,null,""]
["PART III. GROSS ANNUAL INCOME",null,null,null,null,null,null,null,null,null,null,null,null,"PART III. GROSS ANNUAL INCOME"]
[null,null,"(A)","(B)",null,null,null,null,null,null,null,null,null,null,null,"(A)","(B)"]
[null,{"$f":"A7","v":"HH Mbr #"},"Income Type","Pay","Period","Hours","Annual Amt",null,null,null,null,null,null,null,{"$f":"N7","v":"HH Mbr #"},"Income Type","Pay","Period","Hours","Annual Amt"]
[null,null,null,null,null,null,{"$f":"IFERROR(IF(F19<>0,+D19*F19*E19,+D19*E19),0)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Q19<>\"\",IF(P19<>\"\",VLOOKUP(P19,Income_Defaults,2,0),DefaultPeriod),\"\")","v":""},{"$f":"IF(R19=52,40,0)","v":0},{"$f":"IFERROR(IF(S19<>0,+Q19*S19*R19,+Q19*R19),0)","v":0}]
[null,null,null,null,null,null,{"$f":"IFERROR(IF(F20<>0,+D20*F20*E20,+D20*E20),0)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Q20<>\"\",IF(P20<>\"\",VLOOKUP(P20,Income_Defaults,2,0),DefaultPeriod),\"\")","v":""},{"$f":"IF(R20=52,40,0)","v":0},{"$f":"IFERROR(IF(S20<>0,+Q20*S20*R20,+Q20*R20),0)","v":0}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Q21<>\"\",IF(P21<>\"\",VLOOKUP(P21,Income_Defaults,2,0),DefaultPeriod),\"\")","v":""},0,0]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Q22<>\"\",IF(P22<>\"\",VLOOKUP(P22,Income_Defaults,2,0),DefaultPeriod),\"\")","v":""},0,0]
[null,null,null,null,"",{"$f":"IF(E23=52,40,0)","v":0},0,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,"",0,0,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,"",0,0,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,"",0,0,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,"",0,0,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,"",0,0,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,"",0,0,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,{"$f":"IF('Page 3'!G22>0,\"Additional from Page 3\",\"\")","v":""},null,null,null,{"$f":"IF(C30<>\"\",'Page 3'!G22,\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(#REF!>0,\"Additional from Page 3\",\"\")","v":{"$error":"#REF!"}},null,null,null,{"$f":"IF(P30<>\"\",#REF!,\"\")","v":{"$error":"#REF!"}}]
[null,"TOTALS",null,null,null,null,{"$f":"SUM(G19:G30)","v":0},null,null,null,null,null,null,null,"TOTALS",null,null,null,null,{"$f":"SUM(T19:T30)","v":{"$error":"#REF!"}}]
["PART IV. INCOME FROM ASSETS",null,null,null,null,null,null,null,null,null,null,null,null,"PART IV. INCOME FROM ASSETS"]
[null,{"$f":"A7","v":"HH Mbr #"},"Asset Type","Cash Value","Int. rate","or Actual $","Income",null,null,null,null,null,null,null,{"$f":"N7","v":"HH Mbr #"},"Asset Type","Cash Value","Int. rate","or Actual $","Income",null,null,"NNPP Bal","RE Bal","NNPP Inc.","RE Inc."]
[null,null,null,null,null,null,{"$f":"IFERROR(SUM(Y34:Z34),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND($D$54>VLOOKUP($G$1,HUDAssetThreshold,2,1),AND(R34=\"\",S34=\"\")),Q34*VLOOKUP($G$1,HUDImputedRate,3,1),IF(S34=0,Q34*R34,S34))","v":{"$error":"#N/A"}},null,null,{"$f":"IFERROR(IF(VLOOKUP($C34,Asset_Description_Type,2,0)=\"NNPP\",$D34,0),0)","v":0},{"$f":"IFERROR(IF(VLOOKUP($C34,Asset_Description_Type,2,0)=\"RE\",$D34,0),0)","v":0},{"$f":"IF(AND(NNPP_Total>VLOOKUP(MI_Date,HUDAssetThreshold,2,1),AND($E34=\"\",$F34=\"\")),W34*VLOOKUP(MI_Date,HUDImputedRate,3,1),IF($F34=0,W34*$E34,$F34))","v":{"$error":"#N/A"}},{"$f":"IF(AND(Net_Family_Assets_Total>VLOOKUP(MI_Date,HUDAssetThreshold,2,1),AND($E34=\"\",$F34=\"\")),X34*VLOOKUP(MI_Date,HUDImputedRate,3,1),IF($F34=0,X34*$E34,$F34))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,{"$f":"IFERROR(SUM(Y35:Z35),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND($D$54>VLOOKUP($G$1,HUDAssetThreshold,2,1),AND(R35=\"\",S35=\"\")),Q35*VLOOKUP($G$1,HUDImputedRate,3,1),IF(S35=0,Q35*R35,S35))","v":{"$error":"#N/A"}},null,null,{"$f":"IFERROR(IF(VLOOKUP($C35,Asset_Description_Type,2,0)=\"NNPP\",$D35,0),0)","v":0},{"$f":"IFERROR(IF(VLOOKUP($C35,Asset_Description_Type,2,0)=\"RE\",$D35,0),0)","v":0},{"$f":"IF(AND(NNPP_Total>VLOOKUP(MI_Date,HUDAssetThreshold,2,1),AND($E35=\"\",$F35=\"\")),W35*VLOOKUP(MI_Date,HUDImputedRate,3,1),IF($F35=0,W35*$E35,$F35))","v":{"$error":"#N/A"}},{"$f":"IF(AND(Net_Family_Assets_Total>VLOOKUP(MI_Date,HUDAssetThreshold,2,1),AND($E35=\"\",$F35=\"\")),X35*VLOOKUP(MI_Date,HUDImputedRate,3,1),IF($F35=0,X35*$E35,$F35))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,{"$f":"IFERROR(SUM(Y36:Z36),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND($D$54>VLOOKUP($G$1,HUDAssetThreshold,2,1),AND(R36=\"\",S36=\"\")),Q36*VLOOKUP($G$1,HUDImputedRate,3,1),IF(S36=0,Q36*R36,S36))","v":{"$error":"#N/A"}},null,null,{"$f":"IFERROR(IF(VLOOKUP($C36,Asset_Description_Type,2,0)=\"NNPP\",$D36,0),0)","v":0},{"$f":"IFERROR(IF(VLOOKUP($C36,Asset_Description_Type,2,0)=\"RE\",$D36,0),0)","v":0},{"$f":"IF(AND(NNPP_Total>VLOOKUP(MI_Date,HUDAssetThreshold,2,1),AND($E36=\"\",$F36=\"\")),W36*VLOOKUP(MI_Date,HUDImputedRate,3,1),IF($F36=0,W36*$E36,$F36))","v":{"$error":"#N/A"}},{"$f":"IF(AND(Net_Family_Assets_Total>VLOOKUP(MI_Date,HUDAssetThreshold,2,1),AND($E36=\"\",$F36=\"\")),X36*VLOOKUP(MI_Date,HUDImputedRate,3,1),IF($F36=0,X36*$E36,$F36))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND($D$54>VLOOKUP($G$1,HUDAssetThreshold,2,1),AND(R37=\"\",S37=\"\")),Q37*VLOOKUP($G$1,HUDImputedRate,3,1),IF(S37=0,Q37*R37,S37))","v":{"$error":"#N/A"}},null,null,{"$f":"IFERROR(IF(VLOOKUP($C37,Asset_Description_Type,2,0)=\"NNPP\",$D37,0),0)","v":0},{"$f":"IFERROR(IF(VLOOKUP($C37,Asset_Description_Type,2,0)=\"RE\",$D37,0),0)","v":0},{"$f":"IF(AND(NNPP_Total>VLOOKUP(MI_Date,HUDAssetThreshold,2,1),AND($E37=\"\",$F37=\"\")),W37*VLOOKUP(MI_Date,HUDImputedRate,3,1),IF($F37=0,W37*$E37,$F37))","v":{"$error":"#N/A"}},{"$f":"IF(AND(Net_Family_Assets_Total>VLOOKUP(MI_Date,HUDAssetThreshold,2,1),AND($E37=\"\",$F37=\"\")),X37*VLOOKUP(MI_Date,HUDImputedRate,3,1),IF($F37=0,X37*$E37,$F37))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,{"$f":"IF(AND($D$54>50000,AND(E38=\"\",F38=\"\")),D38*0.4%,IF(F38=0,D38*E38,F38))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND($D$54>50000,AND(R38=\"\",S38=\"\")),Q38*0.4%,IF(S38=0,Q38*R38,S38))","v":0}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF('Page 3'!D45>0,\"Add'l from Pg 3\",\"\")","v":""},{"$f":"IF(C51<>\"\",'Page 3'!D45,\"\")","v":""},null,null,{"$f":"IF(C51<>\"\",'Page 3'!G45,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(W34:W37)","v":0},{"$f":"SUM(X34:X37)","v":0},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"NNPP Total",null,{"$f":"IFERROR(IF(W51+'Page 3'!W45>VLOOKUP(MI_Date,HUDAssetThreshold,2,1),TIC!W51+'Page 3'!W45,0),0)","v":0}]
[null,"RE Total",null,{"$f":"X51+'Page 3'!X45","v":0}]
[null,"NET FAMILY ASSETS TOTAL",null,{"$f":"D52+D53","v":0},null,null,{"$f":"SUM(G34:G51)","v":0}]
[null,"TOTAL ANNUAL INCOME",null,null,null,null,{"$f":"G31+G54","v":0}]
[null,"HUD Threshold",{"$f":"VLOOKUP($G$1,HUDAssetThreshold,2,1)","v":{"$error":"#N/A"}},"HUD Passbook",{"$f":"VLOOKUP($G$1,HUDImputedRate,3,1)","v":{"$error":"#N/A"}}]
["HOUSEHOLD CERTIFICATION & SIGNATURES"]
["The information on this form will be used to determine maximum income eligibility. I/we have provided for each person(s) set forth in Part II acceptable verification of current anticipated annual income. I/we agree to notify the landlord immediately upon any member of the household moving out of the unit or any new member moving in."]
["Under penalties of perjury, I/we certify that the information presented in this Certification is true and accurate to the best of my/our knowledge and belief. The undersigned further understands that providing false representations herein constitutes an act of fraud. False, misleading or incomplete information may result in the termination of the lease agreement. "]
[]
["__________________________________",null,null,"________","__________________________________",null,null,"________"]
["Signature",null,null,"Date","Signature",null,null,"Date"]
[]
["__________________________________",null,null,"________","__________________________________",null,null,"________"]
["Signature",null,null,"Date","Signature",null,null,"Date"]
[]
[]
["PART V. DETERMINATION OF INCOME ELIGIBILITY"]
["TOTAL ANNUAL HOUSEHOLD INCOME FR4OM ALL SOURCES",null,null,null,null,{"$f":"G55","v":0}]
[]
["Current Income Limit per Family Size:",null,null,{"$f":"SUM(G8:G15)","v":0},null,{"$f":"VLOOKUP($G$1,IncomeLimit,D71+1)/0.5*ProjectSetAside","v":{"$error":"#N/A"}},{"$f":"ProjectSetAside","v":1}]
["Household Income Qualified",null,null,null,null,{"$f":"IF(F69<=F71,\"Yes\",\"No\")","v":{"$error":"#N/A"}}]
[]
["Tenant Paid Rent"]
["Utility Allowance"]
["Rental Assistance"]
["Other non-optional charges and mandatory fees"]
["Gross Rent",null,null,null,null,{"$f":"F74+F75+F77","v":0}]
[]
["Maximum Rent Limit",null,null,null,null,{"$f":"TRUNC(IF(NOT(ISBLANK($H$4)),MAX(VLOOKUP(MI_Date,RentLimit,$H$4+2),VLOOKUP(DateGrossRentFloor,RentLimit,$H$4+2)),\"\")/0.5*ProjectSetAside)","v":{"$error":"#VALUE!"}},{"$f":"IF(VLOOKUP(MI_Date,RentLimit,$H$4+2)<=VLOOKUP(DateGrossRentFloor,RentLimit,$H$4+2),\"Rent Floor\",\"\")","v":{"$error":"#N/A"}}]
["Household Rent Qualified",null,null,null,null,{"$f":"IF(F78<=F80,\"Yes\",\"No\")","v":{"$error":"#VALUE!"}}]
[]
["Household Qualified to Move-in",null,null,null,null,{"$f":"IF(AND(F69<=F71,F78<=F80),\"Qualified\",\"Not Qualified\")","v":{"$error":"#N/A"}}]
[]
[]
["SIGNATURE OF OWNER REPRESENTATIVE"]
["Based on the representations herein and upon the proofs and documentation required to be submitted, the individual(s) named in Part II of this Tenant Income Certification is/are eligible under the provisions of Act 15 or Act 18, as amended, and the Land Use Restriction Agreement (if applicable), to live in a unit in this Project. "]
[]
["___________________________________",null,null,null,"________________"]
["SIGNATURE OF OWNER REPRESENTATIVE",null,null,null,"DATE"]
[]
[null,null,null,"WHEDA Restore Main St/Vacancy to Vitality Form 300"]

{"sheet":"Page 3","index":7,"n_rows":45,"n_cols":26,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
["TIC-Additional Income / Asset Page"]
[]
[null,"Additional Income "]
[null,"HH Mbr #","Income Type","Pay","Period","Hours","Annual Amt",null,null,null,null,null,null,{"$f":"B4","v":"HH Mbr #"},"Income Type","Pay","Period","Hours","Annual Amt"]
[null,null,null,null,null,null,{"$f":"IFERROR(IF(F5<>0,+D5*F5*E5,+D5*E5),0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(P5<>\"\",IF(O5<>\"\",VLOOKUP(O5,Income_Defaults,2,0),DefaultPeriod),\"\")","v":""},{"$f":"IF(Q5=52,40,0)","v":0},{"$f":"IFERROR(IF(R5<>0,+P5*R5*Q5,+P5*Q5),0)","v":0}]
[null,null,null,null,null,null,{"$f":"IFERROR(IF(F6<>0,+D6*F6*E6,+D6*E6),0)","v":0},null,null,null,null,null,null,null,null,null,"",{"$f":"IF(Q6=52,40,0)","v":0},{"$f":"IFERROR(IF(R6<>0,+P6*R6*Q6,+P6*Q6),0)","v":0}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,"",0,0]
[null,"TOTALS",null,null,null,null,{"$f":"SUM(G5:G21)","v":0},null,null,null,null,null,null,"TOTALS",null,null,null,null,{"$f":"SUM(S5:S21)","v":0}]
[]
[null,"Additional Assets",null,null,null,null,null,null,null,null,null,null,null,"Additional Assets"]
[null,{"$f":"B4","v":"HH Mbr #"},"Asset Type","Cash Value","Int. rate","or Actual $","Income",null,null,null,null,null,null,{"$f":"N4","v":"HH Mbr #"},"Asset Type","Cash Value","Int. rate","or Actual $","Income",null,null,null,"NNPP Bal","RE Bal","NNPP Inc.","RE Inc."]
[null,null,null,null,null,null,{"$f":"IFERROR(SUM(Y26:Z26),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(#REF!>VLOOKUP(#REF!,HUDAssetThreshold,2,1),AND(Q26=\"\",R26=\"\")),P26*0.4%,IF(R26=0,P26*Q26,R26))","v":{"$error":"#REF!"}},null,null,null,{"$f":"IFERROR(IF(VLOOKUP($C26,Asset_Description_Type,2,0)=\"NNPP\",$D26,0),0)","v":0},{"$f":"IFERROR(IF(VLOOKUP($C26,Asset_Description_Type,2,0)=\"RE\",$D26,0),0)","v":0},{"$f":"IF(AND(NNPP_Total>VLOOKUP(MI_Date,HUDAssetThreshold,2,1),AND($E26=\"\",$F26=\"\")),W26*VLOOKUP(MI_Date,HUDImputedRate,3,1),IF($F26=0,W26*$E26,$F26))","v":{"$error":"#N/A"}},{"$f":"IF(AND(Net_Family_Assets_Total>VLOOKUP(MI_Date,HUDAssetThreshold,2,1),AND($E26=\"\",$F26=\"\")),X26*VLOOKUP(MI_Date,HUDImputedRate,3,1),IF($F26=0,X26*$E26,$F26))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,{"$f":"IFERROR(SUM(Y27:Z27),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(#REF!>VLOOKUP(#REF!,HUDAssetThreshold,2,1),AND(Q27=\"\",R27=\"\")),P27*0.4%,IF(R27=0,P27*Q27,R27))","v":{"$error":"#REF!"}},null,null,null,0,0,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,{"$f":"IFERROR(SUM(Y28:Z28),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(#REF!>VLOOKUP(#REF!,HUDAssetThreshold,2,1),AND(Q28=\"\",R28=\"\")),P28*0.4%,IF(R28=0,P28*Q28,R28))","v":{"$error":"#REF!"}},null,null,null,0,0,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(#REF!>VLOOKUP(#REF!,HUDAssetThreshold,2,1),AND(Q29=\"\",R29=\"\")),P29*0.4%,IF(R29=0,P29*Q29,R29))","v":{"$error":"#REF!"}},null,null,null,0,0,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(#REF!>VLOOKUP(#REF!,HUDAssetThreshold,2,1),AND(Q30=\"\",R30=\"\")),P30*0.4%,IF(R30=0,P30*Q30,R30))","v":{"$error":"#REF!"}},null,null,null,0,0,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(#REF!>VLOOKUP(#REF!,HUDAssetThreshold,2,1),AND(Q31=\"\",R31=\"\")),P31*0.4%,IF(R31=0,P31*Q31,R31))","v":{"$error":"#REF!"}},null,null,null,0,0,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(#REF!>VLOOKUP(#REF!,HUDAssetThreshold,2,1),AND(Q32=\"\",R32=\"\")),P32*0.4%,IF(R32=0,P32*Q32,R32))","v":{"$error":"#REF!"}},null,null,null,0,0,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(#REF!>VLOOKUP(#REF!,HUDAssetThreshold,2,1),AND(Q33=\"\",R33=\"\")),P33*0.4%,IF(R33=0,P33*Q33,R33))","v":{"$error":"#REF!"}},null,null,null,0,0,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(#REF!>VLOOKUP(#REF!,HUDAssetThreshold,2,1),AND(Q34=\"\",R34=\"\")),P34*0.4%,IF(R34=0,P34*Q34,R34))","v":{"$error":"#REF!"}},null,null,null,0,0,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(#REF!>VLOOKUP(#REF!,HUDAssetThreshold,2,1),AND(Q35=\"\",R35=\"\")),P35*0.4%,IF(R35=0,P35*Q35,R35))","v":{"$error":"#REF!"}},null,null,null,0,0,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(#REF!>VLOOKUP(#REF!,HUDAssetThreshold,2,1),AND(Q36=\"\",R36=\"\")),P36*0.4%,IF(R36=0,P36*Q36,R36))","v":{"$error":"#REF!"}},null,null,null,0,0,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(#REF!>VLOOKUP(#REF!,HUDAssetThreshold,2,1),AND(Q37=\"\",R37=\"\")),P37*0.4%,IF(R37=0,P37*Q37,R37))","v":{"$error":"#REF!"}},null,null,null,0,0,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(#REF!>VLOOKUP(#REF!,HUDAssetThreshold,2,1),AND(Q38=\"\",R38=\"\")),P38*0.4%,IF(R38=0,P38*Q38,R38))","v":{"$error":"#REF!"}},null,null,null,0,0,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(#REF!>VLOOKUP(#REF!,HUDAssetThreshold,2,1),AND(Q39=\"\",R39=\"\")),P39*0.4%,IF(R39=0,P39*Q39,R39))","v":{"$error":"#REF!"}},null,null,null,0,0,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(#REF!>VLOOKUP(#REF!,HUDAssetThreshold,2,1),AND(Q40=\"\",R40=\"\")),P40*0.4%,IF(R40=0,P40*Q40,R40))","v":{"$error":"#REF!"}},null,null,null,0,0,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(#REF!>VLOOKUP(#REF!,HUDAssetThreshold,2,1),AND(Q41=\"\",R41=\"\")),P41*0.4%,IF(R41=0,P41*Q41,R41))","v":{"$error":"#REF!"}},null,null,null,0,0,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(#REF!>VLOOKUP(#REF!,HUDAssetThreshold,2,1),AND(Q42=\"\",R42=\"\")),P42*0.4%,IF(R42=0,P42*Q42,R42))","v":{"$error":"#REF!"}},null,null,null,0,0,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(#REF!>VLOOKUP(#REF!,HUDAssetThreshold,2,1),AND(Q43=\"\",R43=\"\")),P43*0.4%,IF(R43=0,P43*Q43,R43))","v":{"$error":"#REF!"}},null,null,null,0,0,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,{"$f":"IFERROR(SUM(Y44:Z44),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(#REF!>VLOOKUP(#REF!,HUDAssetThreshold,2,1),AND(Q44=\"\",R44=\"\")),P44*0.4%,IF(R44=0,P44*Q44,R44))","v":{"$error":"#REF!"}},null,null,null,0,0,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"ASSETS TOTAL",null,{"$f":"SUM(D26:D44)","v":0},null,null,{"$f":"SUM(G26:G44)","v":0},null,null,null,null,null,null,"ASSETS TOTAL",null,{"$f":"SUM(P26:P44)","v":0},null,null,{"$f":"SUM(S26:S44)","v":{"$error":"#REF!"}},null,null,null,{"$f":"SUM(W26:W44)","v":0},{"$f":"SUM(X26:X44)","v":0},{"$error":"#N/A"},{"$error":"#N/A"}]