{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["2019","2020","2021","2022"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":1,"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":"2019","index":0,"n_rows":20,"n_cols":8,"rows_kept":20,"cut":false,"hidden":false,"merged":[[0,0,0,7],[1,0,1,3],[1,5,1,7],[16,0,16,7]]}
["90-Day Reassessment\nFamily AMI Calculator"]
["Kenyatta Hordge ",null,null,null,null,"June 12 2020"]
["HoH Name: ",null,null,null,null,"Date:"]
[]
[]
[]
[]
["Family Monthly Income:",0]
["Family Size:",3,"AMI:",{"$f":"LOOKUP(B9,B14:H16)","v":5733.333333333333}]
["% AMI:",{"$f":"B8/D9","v":0}]
[]
[]
[]
["Family Size",2,3,4,5,6,7,8]
["Annual AMI",61100,68800,76400,82500,88600,94700,100800]
["Monthly AMI",{"$f":"B15/12","v":5091.666666666667},5733.333333333333,6366.666666666667,6875,7383.333333333333,7891.666666666667,8400]
["Effective for 2019"]
[]
[]
["Staff Signature"]

{"sheet":"2020","index":1,"n_rows":20,"n_cols":8,"rows_kept":20,"cut":false,"hidden":false,"merged":[[0,0,0,7],[1,0,1,3],[1,5,1,7],[16,0,16,7]]}
["90-Day Reassessment\nFamily AMI Calculator"]
[]
["HoH Name: ",null,null,null,null,"Date:"]
[]
[]
[]
[]
["Family Monthly Income:",0]
["Family Size:",5,"AMI:",{"$f":"LOOKUP(B9,B14:H16)","v":7500}]
["% AMI:",{"$f":"B8/D9","v":0}]
[]
[]
[]
["Family Size",2,3,4,5,6,7,8]
["Annual AMI",67400,75800,84200,90000,97700,104500,111200]
["Monthly AMI",{"$f":"B15/12","v":5616.666666666667},6316.666666666667,7016.666666666667,7500,8141.666666666667,8708.3333333333339,9266.6666666666661]
["Effective July 2020"]
[]
[]
["Staff Signature"]

{"sheet":"2021","index":2,"n_rows":20,"n_cols":8,"rows_kept":20,"cut":false,"hidden":false,"merged":[[0,0,0,7],[1,0,1,3],[1,5,1,7],[16,0,16,7]]}
["90-Day Reassessment\nFamily AMI Calculator"]
[]
["HoH Name: ",null,null,null,null,"Date:"]
[]
[]
[]
[]
["Family Monthly Income:",3400]
["Family Size:",7,"AMI:",{"$f":"LOOKUP(B9,B14:H16)","v":8666.6666666666661}]
["% AMI:",{"$f":"B8/D9","v":0.39230769230769236}]
[]
[]
[]
["Family Size",2,3,4,5,6,7,8]
["Annual AMI",67100,75500,83800,90600,97300,104000,110700]
["Monthly AMI",{"$f":"B15/12","v":5591.666666666667},6291.666666666667,6983.333333333333,7550,8108.333333333333,8666.6666666666661,9225]
["Effective June 2021"]
[]
[]
["Staff Signature"]

{"sheet":"2022","index":3,"n_rows":25,"n_cols":9,"rows_kept":25,"cut":false,"hidden":false,"merged":[[0,0,0,7],[2,0,2,3],[2,5,2,7],[16,0,16,7]]}
["RRH Annual Income Certification\nFamily AMI Calculator"]
[]
[]
["HoH Name: ",null,null,null,null,"Date:"]
[]
[]
[]
["Family Monthly Income:"]
["Family Size:",null,"AMI:",{"$f":"LOOKUP(B9,B14:I16)","v":{"$error":"#N/A"}}]
["% AMI:",{"$f":"B8/D9","v":{"$error":"#N/A"}}]
[]
[]
[]
["Family Size",1,2,3,4,5,6,7,8]
["Annual AMI",65600,75000,84400,93700,101200,108700,116200,123700]
["Monthly AMI",{"$f":"B15/12","v":5466.666666666667},6250,7033.333333333333,7808.333333333333,8433.3333333333339,9058.3333333333339,9683.3333333333339,10308.333333333334]
[]
[]
[]
["Staff Signature"]
[]
[]
["* Households above 30% AMI at the time of the annual reassessment must be exited from the program."]
["* Households in CoC funded programs with income at the time of the annual reassessment must contribute 30% of their monthly "]
["    adjusted income or 10% of their monthly gross income to rent."]