{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"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":"Sheet1","index":0,"n_rows":32,"n_cols":12,"rows_kept":32,"cut":false,"hidden":false,"merged":[[0,2,0,8],[1,3,1,4],[3,2,3,7],[5,2,5,6],[14,2,14,3],[19,2,20,2]]}
[null,null,"Income Calculation Worksheet"]
[null,null,"Household Member Name:"]
[]
[null,null,"Definition of earned income -- The full amount, before any payroll deductions of wages and salaries, overtime pay, commissions, fees, tips and bonuses, and other compensation for personal services.  Earned income is always calculated using the GROSS amount before any deductions including taxes. You must obtain a minimum of 4 consecutive paystubs for ample verification.  "]
[]
[null,null,"How earned income is annualized -- First determine how often they are paid.  Do they receive their checks weekly, every other week, twice a month or monthly?"]
[]
[null,null,"If the individual is working day labor, or reports sporadic income, the individual's income over the previous 12 months can be used to calculate annual income."]
[null,null,"Calculate monthly average from previous 12 month total and impute average in Monthly Pay Dates category below."]
[null,null,"Section 1"]
[null,null,"Unearned Income Type","Monthly Amount","Total"]
[null,null,null,null,{"$f":"D12*12","v":0}]
[null,null,null,null,0]
[null,null,null,null,0,null,null,null,null,null,null,"Social Security"]
[null,null,"Total Annual Unearned Income",null,{"$f":"SUM(E12:E14)","v":0},null,null,null,null,null,null,"SSI"]
[null,null,null,null,null,null,null,null,null,null,null,"VA Benefits"]
[null,null,"Section 2",null,null,null,null,null,null,null,null,"AND"]
[null,null,null,null,null,null,null,null,null,null,null,"Unemployment"]
[null,null,"Employer Name:","Weekly","Bi-Weekly","Twice a month","Monthly",null,"Third Party",null,null,"Family & Friends"]
[null,null,null,"Pay Dates","Pay Dates","Pay Dates","Pay Dates","Year to Date","wage/hour",null,null,"TANF"]
[null,null,null,null,null,null,null,null,null,null,null,"OAP"]
[null,null,"Gross Amount of check #1",null,null,null,null,"Year to Date","Wage",null,null,"Child Support"]
[null,null,"Gross Amount of check #2",null,null,null,null,"Total",null,null,null,"Alimony"]
[null,null,"Gross Amount of check #3",null,null,null,null,null,"Hours",null,null,"Trust Disbursements"]
[null,null,"Gross Amount of check #4",null,null,null,null,"# of weeks in Year",null,null,null,"Other"]
[null,null,"  Total",{"$f":"SUM(D22:D25)","v":0},0,0,0,"to Date","Weekly Tips"]
[null,null,"    Divide by ",{"$f":"COUNTA(D22:D25)","v":0},0,0,0]
[null,null,"This is the average check amount",{"$f":"IF(D26>0,SUM(D26/D27),0)","v":0},0,{"$f":"IF(F27>0,SUM(F26/F27),0)","v":0},0,{"$f":"IF(H27>0,SUM(H24/H27),0)","v":0},{"$f":"IF(I25>0,SUM(I23*I25)+I27,0)","v":0}]
[null,null,"Annualize the income by multiplying the average check amount by:","   x52","    x26","    x24","    x12","   x52","   x52"]
[null,null,"Total Annual Earned Income",{"$f":"SUM(D28*52)","v":0},{"$f":"SUM(E28*26)","v":0},{"$f":"SUM(F28*24)","v":0},{"$f":"SUM(G28*12)","v":0},{"$f":"SUM(H28*52)","v":0},0]
[null,null,"Monthly Amount entered into Elite",{"$f":"D30/12","v":0},0,0,0,0,0]
[null,null,"Total Annual Income",{"$f":"IF(D30>0,SUM(D30+$E$15),\"0\")","v":"0"},"0","0","0","0","0"]

{"sheet":"Sheet2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}