{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["What If Calculations","Currently Working","Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":1,"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":"What If Calculations","index":0,"n_rows":21,"n_cols":7,"rows_kept":21,"cut":false,"hidden":false,"merged":[[10,4,10,7],[16,4,16,7],[3,4,3,6]]}
[]
[]
[]
[null,null,null,null,"What if I start working?"]
[null,null,null,null,"If I earn",0,"/hr"]
[null,null,null,null,"and I work",0,"hours a week"]
[null,"Does the client receive a service Rate?","Yes",null,"I will earn",{"$f":"F5*F6*52/12","v":0},"a month"]
[null,null,null,null,"and my monthly contribution will be",{"$f":"IF($C$7=\"No\",IF($F$7<=277,0,IF($F$7>2183,\"Over Income\",($F$7-65)/2-105)),IF($C$7=\"Yes\",IF($F$7<=277,0,IF($F$7>3148,\"Over Income\",IF($F$7>2183,954,(($F$7-65)/2-105))))))","v":0},"a month towards my housing."]
[null,null,null,null,"My provider will receive",{"$f":"IF($C$7=\"yes\",482.84,0)","v":482.84},"a month to provide me with services."]
[]
[null,null,null,null,"What if my wage changes?"]
[null,null,null,null,"If my hourly wage changes to",0,"/hr"]
[null,null,null,null,"I will earn",{"$f":"F12*F6*52/12","v":0},"a month"]
[null,null,null,null,"and my contribution will be",{"$f":"IF($C$7=\"No\",IF($F$13<=277,0,IF($F$13>2183,\"Over Income\",($F$13-65)/2-105)),IF($C$7=\"Yes\",IF($F$13<=277,0,IF($F$13>3148,\"Over Income\",IF($F$13>2183,954,(($F$13-65)/2-105))))))","v":0},"a month at my next review or when I submit new paystubs."]
[null,null,null,null,"My provider will receive",{"$f":"IF($C$7=\"yes\",482.84,0)","v":482.84},"a month to provide me with services."]
[]
[null,null,null,null,"What if my hours change?"]
[null,null,null,null,"If my hours change to",0,"/week"]
[null,null,null,null,"I will earn",0,"a month"]
[null,null,null,null,"and my contribution will be",{"$f":"IF($C$7=\"No\",IF($F$19<=277,0,IF($F$19>2183,\"Over Income\",($F$19-65)/2-105)),IF($C$7=\"Yes\",IF($F$19<=277,0,IF($F$19>3184,\"Over Income\",IF($F$19>2183,954,(($F$19-65)/2-105))))))","v":0},"a month at my next review or when I submit new paystubs."]
[null,null,null,null,"My provider will receive",{"$f":"IF($C$7=\"yes\",482.84,0)","v":482.84},"a month to provide me with services."]

{"sheet":"Currently Working","index":1,"n_rows":18,"n_cols":6,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,1,1,3],[2,2,2,3],[7,2,7,3],[3,2,3,3],[4,2,4,3],[5,2,5,3],[6,2,6,3],[9,2,9,3],[10,2,10,3],[11,2,11,3],[12,2,12,3],[13,2,13,3],[3,5,3,11],[6,5,6,10],[2,5,2,10],[8,5,8,15],[8,2,8,3],[5,5,5,10]]}
[]
[null,"New Earned Income Disregard (10/1/2015)"]
[null,null,"Earned Income (Gross)",null,null,"Individual will start having an obligation when reach $277.00/mo, gross"]
[null,"Paycheck 1",0,null,null,"Individual will owe the full base rate of $954 when they reach $2183.00/mo, gross"]
[null,"Paycheck 2",0]
[null,"Paycheck 3",0,null,null,"Rate 1 Individuals will be over income when they reach $2183.00/mo, gross"]
[null,"Paycheck 4",0,null,null,"Rate 2 Individuals will be over income when they reach $3148.00/mo, gross"]
[null,"Paycheck 5",0]
[null,"Paycheck 6",0,null,null,"These numbers/calculations are all approximations - Eligibility will determine the exact amount of a Individual's obligation"]
[null,"Paycheck 7",0]
[null,"Paycheck 8",0,null,null,"1) Total gross minus $65 - Individual keeps that $65"]
[null,"Paycheck 9",0,null,null,"2) Divide the remainder in half, the Individual keeps half"]
[null,"Paycheck 10",0,null,null,"3) Subtract $105 from the remaining half, Individual keeps that $105"]
[null,"Total:",{"$f":"SUM(C4:D13)","v":0},null,null,"4) Remainder is the Individual's obligation"]
[null,"Individual Keeps (before tax):",{"$f":"IF(C16=\"Over Income\", \"Over Income\",C14-C16)","v":0},{"$f":"$C$15/$C$14","v":{"$error":"#DIV/0!"}}]
[null,"Individual Owes:",{"$f":"IF($C$14<277,0,IF($C$14>3148,\"Over Income\",IF($C$14>2183,954,($C$14-65)/2-105)))","v":0},{"$f":"$C$16/$C$14","v":{"$error":"#DIV/0!"}}]
[null,"HS Rate 1 Grant:",{"$f":"IF(C16=\"Over Income\", \"Over Income\",954-C16)","v":954},{"$f":"$C$17/954","v":1}]
[null,"Revised 7/2021"]

{"sheet":"Sheet1","index":2,"n_rows":3,"n_cols":1,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
["Select One"]
["Yes"]
["No"]