{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Administration","Calculator","Sheet2","Change Order","Calculation Worksheet Page 1","Calculation Worksheet Page 2","Change Tenant Payment Form"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":4,"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":"Administration","index":0,"n_rows":170,"n_cols":12,"rows_kept":170,"cut":false,"hidden":false,"merged":[[165,3,165,6],[168,3,168,6],[132,8,132,9],[33,7,33,12],[134,2,134,4],[159,3,159,4],[161,3,161,7],[163,4,163,5],[169,3,169,7],[135,2,135,4],[138,0,138,12],[141,1,141,2],[143,2,143,6],[145,3,145,4],[147,3,147,4],[149,2,149,7],[151,4,151,5],[155,3,155,4],[157,3,157,4],[128,8,128,9],[125,3,125,4],[126,3,126,4],[127,3,127,4],[128,3,128,4],[121,5,121,6],[122,5,122,6],[123,5,123,6],[124,5,124,6],[125,5,125,6],[126,5,126,6],[127,5,127,6],[128,5,128,6],[121,8,121,9],[122,8,122,9],[123,8,123,9],[124,8,124,9],[125,8,125,9],[126,8,126,9],[127,8,127,9],[0,0,0,2],[2,0,2,8],[3,4,3,6],[4,2,4,4],[16,0,16,2],[16,3,16,4],[14,0,14,8],[6,0,6,8],[8,0,8,1],[9,2,9,8],[10,1,10,3],[13,0,13,1],[13,2,13,3],[1,5,1,6],[1,2,1,4],[7,1,7,8],[8,2,8,8],[15,1,15,8],[17,0,17,12],[19,2,19,4],[19,8,19,10],[21,2,21,5],[21,7,21,12],[24,0,24,12],[25,0,25,12],[26,0,26,12],[53,2,53,5],[53,9,53,10],[28,10,28,12],[29,0,29,2],[30,0,30,2],[30,8,30,10],[31,0,31,2],[31,9,31,11],[32,3,32,4],[32,9,32,11],[29,10,29,12],[105,2,105,4],[106,0,106,1],[60,8,60,12],[61,8,61,12],[35,0,35,2],[35,3,35,4],[37,3,37,4],[37,5,37,6],[37,7,37,8],[37,9,37,10],[38,3,38,4],[38,5,38,6],[38,7,38,8],[38,9,38,10],[39,3,39,4],[39,5,39,6],[39,7,39,8],[39,9,39,10],[51,2,51,3],[54,9,54,10],[43,0,49,12],[131,0,131,1],[131,8,131,9],[23,2,23,5],[113,0,114,3],[116,4,116,5],[102,0,102,12],[68,9,68,10],[71,8,71,12],[72,8,72,12],[77,9,77,10],[81,8,81,12],[82,8,82,12],[57,0,57,12],[58,0,58,12],[110,0,111,3],[111,4,111,5],[89,9,89,10],[92,8,92,12],[93,8,93,12],[98,9,98,10],[101,0,101,12],[59,0,59,12],[104,2,104,3],[105,0,105,1]]}
["Fill in the highlighted areas",null,null,null,"Pre-populated fields will be highlighted in light gray"]
["Version 2.1",null,null,null,null,"Todays Date:",null,{"$f":"TEXT(TODAY(), \"dddd\") &\", \" & TEXT(TODAY(), \"mm/dd/yyyy\")","v":"Monday, 04/01/2024"}]
["Grant Information"]
["Federal Grant I.D./HUD Award No"]
["Contract No.:"]
[]
["Tenant"]
["Name"]
["Street Address"]
["Apt #"]
["City"]
["State"]
["Zip"]
[]
["Owner"]
["Name"]
[]
["Change Order"]
[]
["Contract #",null,{"$f":"C5","v":0},null,null,null,"HUD AWARD #",null,{"$f":"E4","v":0}]
[]
["Tenant Name:",null,{"$f":"B8","v":0},null,null,null,"Address:",{"$f":"C9&\" \"&Sheet2!J2&\" \"&B10&\" \"&B11&\" \"&B12&\" \"&B13","v":"     "}]
[]
["Owner Name:",null,{"$f":"B16","v":0}]
[]
[]
["NATURE OF TRANSACTION (PLEASE CHECK ALL ITEMS THAT APPLY)"]
[]
["1. TERMINATION OF PAYMENT:",null,null,null,null,"2. CHANGE HUD AWARD#",null,null,null,"FROM:"]
["Same Owner, New Unit",null,null,null,null,null,null,null,null,"TO:"]
["New Owner, Same Unit",null,null,null,null,"3. ISSUE CHECK - MONTH:"]
["New Owner, New Unit",null,null,null,null,"4. SUSPEND CHECK - MONTH:"]
["Suspend Check - Month:",null,null,null,null,"5. CLAIM FOR DAMAGES - AMOUNT:   "]
[null,null,null,null,null,null,null,"*Not to exceed one month current contract rent"]
["6. TERMINATION FROM CoC RA PROGRAM"]
["    Suspend Check - Month:"]
[]
["7. CHANGE IN SUBSIDY:",null,null,"CONTRACT RENT",null,"HAP PAYMENT",null,"TENANT PAYMENT"]
[null,null,"FROM"]
[null,null,"TO"]
[]
[]
["REASON FOR CHANGE:"]
[]
[]
[]
[]
[]
[]
[]
[]
["Effective Date:"]
[]
["Prepared by:"]
[null,null,null,null,null,null,null,"Initials",null,"Date"]
[]
[]
[" Calculation Worksheet           "]
["Page 1"]
[]
["Household Member #1"]
[null,null,null,null,null,null,"Monthly"]
["SSDI"]
["SSI",null,null,null,null,null,null,null,null,"Week 1 Pay"]
["TANF",null,null,null,null,null,null,null,null,"Week 2 Pay"]
["Earned Income",null,null,null,null,null,{"$f":"L70+L79","v":0},null,null,"Week 3 Pay"]
["SAGA",null,null,null,null,null,null,null,null,"Week 4 Pay"]
["Unemployment"]
["Child Support",null,null,null,null,null,null,null,null,"Total",null,{"$f":"SUM(L64:L67)","v":0}]
["Alimony",null,null,null,null,null,null,null,null,"Monthly Average",null,{"$f":"FLOOR(L69/4*52/12,1)","v":0}]
["VA Service- Connected Disability Compensation Income"]
["VA Non-Service Connected Disability Pension"]
["Private Disability Insurance Income",null,null,null,null,null,null,null,"Bi-Weekly Pay"]
["Retirement Income from Social Security Income"]
["Pension/ Retirement Income from a former job",null,null,null,null,null,null,null,null,"Bi-Weekly 1st"]
["Worker's Compensation",null,null,null,null,null,null,null,null,"Bi-Weekly 2nd"]
["Other sources of Income"]
[null,null,null,null,null,null,null,null,null,"Total",null,{"$f":"SUM(L75:L76)","v":0}]
[null,null,null,null,null,"Total",{"$f":"SUM(G63:G77)","v":0}," ",null,"Monthly Average",null,{"$f":"FLOOR(L78/2*26/12,1)","v":0}]
[]
[]
["Household Member #2"]
[null,null,null,null,null,null,"Monthly"]
["SSDI"]
["SSI",null,null,null,null,null,null,null,null,"Week 1 Pay"]
["TANF",null,null,null,null,null,null,null,null,"Week 2 Pay"]
["Earned Income",null,null,null,null,null,{"$f":"L91+L100","v":0},null,null,"Week 3 Pay"]
["SAGA",null,null,null,null,null,null,null,null,"Week 4 Pay"]
["Unemployment"]
["Child Support",null,null,null,null,null,null,null,null,"Total",null,{"$f":"SUM(L85:L88)","v":0}]
["Alimony",null,null,null,null,null,null,null,null,"Monthly Average",null,{"$f":"FLOOR(L90/4*52/12,1)","v":0}]
["VA Service- Connected Disability Compensation Income"]
["VA Non-Service Connected Disability Pension"]
["Private Disability Insurance Income",null,null,null,null,null,null,null,"Bi-Weekly Pay"]
["Retirement Income from Social Security Income"]
["Pension/ Retirement Income from a former job",null,null,null,null,null,null,null,null,"Bi-Weekly 1st"]
["Worker's Compensation",null,null,null,null,null,null,null,null,"Bi-Weekly 2nd"]
["Other sources of Income"]
[null,null,null,null,null,null,null,null,null,"Total",null,{"$f":"SUM(L96:L97)","v":0}]
[null,null,null,null,null,"Total",{"$f":"SUM(G84:G98)","v":0},null,null,"Monthly Average",null,{"$f":"FLOOR(L99/2*26/12,1)","v":0}]
[]
["Calculation Worksheet"]
["Page 2"]
[]
["Date"]
["Certificate Number"]
["# of bedrooms"]
["# of Dependents:"]
["# in Household:"]
[]
["For Child Care: (Costs which enable one or both parents to be gainfully employed)"]
[null,null,null,null,null,null,null,"Enter numerical values only."]
[]
["Non-reimbursed Medical Expenses in excess of 3% of Gross Income:"]
[]
[]
["Non-reimbursed Medical Expenses",null,null,null,null,null,null,"Enter numerical values only."]
[]
[]
["Allowance for Utilities and Other Services",null,null,null,null,"Indicate Type of allowance",null,null,"Indicate amount of allowance"]
[]
["Heating:      Natural Gas/Bottle Gas/Oil/Electric"]
["Water Heat: Natural Gas/Bottle Gas/Oil/Electric"]
["Cooking:      Natural Gas/Bottle Gas/Oil/Electric"]
["Other Electric: Lighting, refrigeration, etc."]
[null,null,"Appliances:   ","Range       "]
[null,null,"Misc.:         ","Refrigerator"]
[null,null,null,"Water"]
[null,null,null,"Trash Collection"]
[]
[]
["Fair Market Rent",null,null,null,null,null,"Family Contribution",null,{"$f":"'Calculation Worksheet Page 2'!H42","v":0}]
["Contract Rent",null,null,null,null,null,"Subsidy Payment",null,{"$f":"'Calculation Worksheet Page 2'!H43","v":0}]
[]
["Preparer's Name:"]
["Preparer's Signature:"]
[]
[]
["Change tenant payment"]
[]
[]
["Date"]
[]
["Tenant Name",null,{"$f":"B8&\",\"","v":","}]
[]
["Indicate Increase or Decrease"]
[]
["Enter new income amount"]
[]
["Tenant Address",null,{"$f":"Administration!C9&\" \"&Sheet2!J2&\" \"&Administration!B10&\" \"&Administration!B11&\" \"&Administration!B12&\" \"&B13","v":"     "}]
[]
["Date of income change"]
[]
["Effective date of change in tenant portion"]
[]
["Tenant Portion of rent"]
[]
["Housing Assistance Payment"]
[]
["Contract rent to Owner"]
[]
["Name and title of housing staff"]
[]
["Phone number of staff filling out the form"]
[]
["Name of housing office"]
[]
["CC:"]
["Name of Case manager"]
["Name of Owner/Property manager)"]

{"sheet":"Calculator","index":1,"n_rows":71,"n_cols":30,"rows_kept":71,"cut":false,"hidden":false,"merged":[[62,0,62,3],[62,4,62,11],[62,12,62,18],[62,19,62,23],[62,24,62,29],[60,24,61,29],[60,0,61,3],[60,4,61,11],[60,12,61,18],[60,19,61,23],[70,0,70,3],[70,4,70,11],[70,12,70,18],[70,19,70,23],[70,24,70,29],[53,24,54,28],[68,12,69,18],[68,19,69,23],[68,24,69,29],[68,0,69,3],[68,4,69,11],[66,24,66,29],[64,0,65,3],[64,4,65,11],[64,12,65,18],[64,19,65,23],[64,24,65,29],[66,0,66,3],[66,4,66,11],[66,12,66,18],[66,19,66,23],[45,29,46,34],[49,24,50,28],[49,29,50,34],[47,29,47,34],[45,24,46,28],[47,24,47,28],[51,0,51,3],[51,4,51,11],[51,12,51,16],[53,29,54,34],[55,29,55,34],[51,24,51,28],[51,29,51,34],[55,0,55,3],[55,4,55,11],[55,12,55,16],[55,17,55,23],[55,24,55,28],[53,0,54,3],[53,4,54,11],[53,12,54,16],[53,17,54,23],[51,17,51,23],[47,4,47,11],[45,12,46,16],[47,17,47,23],[49,4,50,11],[49,12,50,16],[49,17,50,23],[49,0,50,3],[47,12,47,16],[9,13,9,18],[28,20,28,22],[30,20,30,22],[45,4,46,11],[45,0,46,3],[45,17,46,23],[47,0,47,3],[42,36,42,38],[32,10,32,12],[26,7,26,10],[28,7,28,10],[30,14,30,17],[26,23,26,25],[28,23,28,25],[30,23,30,25],[32,23,32,25],[26,20,26,22],[32,13,32,16],[32,19,32,22],[0,22,0,30],[22,22,22,30],[1,0,2,27],[23,0,24,27],[16,0,16,6],[14,8,14,10],[0,19,0,20],[5,0,5,6],[4,0,4,6],[4,7,4,10],[16,8,16,10],[12,8,12,10],[5,7,5,10],[22,19,22,20],[7,11,7,16],[9,19,9,20]]}
["Pro-rate calculator:  move-in mid-month",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Todays Date:",{"$f":"TODAY()","v":"2024-04-01"}]
["Please Note: The #VALUE! error will be displayed in certain cells when the sections highlighted in yellow are left empty. This error will disappear, and the cells will show the appropriate values as soon as all necessary inputs are provided and calculations are completed."]
[]
[]
["Enter full contract rent:"]
["Enter full HAP amount:"]
[]
["The month and year the contract started is:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(N10),\"\",DATE(YEAR(N10),MONTH(N10),1))","v":""}]
[]
["Enter full numerical date that the contract started:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N10=\"\", \"\", IF(ISNUMBER(N10), IF(OR(DAY(N10)>31, MONTH(N10)>12, YEAR(N10)<1900, YEAR(N10)>9999), \"Invalid Date\", \"\"), \"Invalid Date\"))","v":""}]
["Example:  2/20/2024"]
[]
["Pro-Rated Contract Rent:",null,null,null,null,null,null,null,{"$f":"CEILING(Calculator!AD56,1)","v":{"$error":"#VALUE!"}}]
[]
["Pro-Rated Tenant Portion is: ",null,null,null,null,null,null,null,{"$f":"FLOOR(Calculator!AD52,1)","v":{"$error":"#VALUE!"}}]
[]
["Pro-Rated HAP amount is:",null,null,null,null,null,null,null,{"$f":"I13-I15","v":{"$error":"#VALUE!"}}]
[]
["Number of days the unit is occupied",null,null,null,null,null,null,null,null,null,{"$f":"Calculator!Y48","v":""}]
[]
[]
[]
["Pro-rate calculator:  move-out mid-month",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Todays Date:",{"$f":"TODAY()","v":"2024-04-01"}]
["Please Note: The #VALUE! error will be displayed in certain cells when the sections highlighted in yellow are left empty. This error will disappear, and the cells will show the appropriate values as soon as all necessary inputs are provided and calculations are completed."]
[]
[]
["Enter full contract rent:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pro-Rated Contract Rent is:",null,null,{"$f":"CEILING(Calculator!Y71,1)","v":{"$error":"#VALUE!"}}]
[]
["Enter full HAP amount:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pro-Rated Tenant Portion is:",null,null,{"$f":"FLOOR(Calculator!Y67,1)","v":{"$error":"#VALUE!"}}]
[]
["The move out date's corresponding month's first day is:",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(K33),\"\",DATE(YEAR(K33),MONTH(K33),1))","v":""},null,null,null,null,null,"Pro-Rated HAP amount is:",null,null,{"$f":"X27-X29","v":{"$error":"#VALUE!"}}]
[]
["Enter full numerical move out date:",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K33=\"\", \"\", IF(ISNUMBER(K33), IF(OR(DAY(K33)>31, MONTH(K33)>12, YEAR(K33)<1900, YEAR(K33)>9999), \"Invalid Date\", \"\"), \"Invalid Date\"))","v":""},null,null,null,null,null,"Number of days the unit is occupied",null,null,null,{"$f":"Calculator!T63","v":{"$error":"#VALUE!"}}]
["Example: 2/15/2024",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(O31),ISNUMBER(K33)),IF(OR(MONTH(O31)<>MONTH(K33),YEAR(O31)<>YEAR(K33)),\"Date Error\",\"\"),\"\")","v":""}]
[]
[]
[]
[{"$f":"Administration!A2","v":"Version 2.1"}]
[]
[]
[]
[]
[]
[]
[]
["HAP amount",null,null,null,"Month and year the contract started",null,null,null,null,null,null,null,"Days in month",null,null,null,null,"Date the lease and contract started ",null,null,null,null,null,null,"Number of days the unit is occupied",null,null,null,null,"Pro-Rated HAP amount"]
[]
[{"$f":"Calculator!H6","v":0},null,null,null,{"$f":"IF(Calculator!L8<>\"\",Calculator!L8,\"\")","v":""},null,null,null,null,null,null,null,{"$f":"DAY(EOMONTH(E48,0))","v":{"$error":"#VALUE!"}},null,null,null,null,{"$f":"IF(Calculator!N10<>\"\",Calculator!N10,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(ISNUMBER(R48), EOMONTH(R48,0)-R48+1, \"\")","v":""},null,null,null,null,{"$f":"IF(OR(ISBLANK(A48), ISBLANK(M48), ISBLANK(Y48), NOT(ISNUMBER(A48)), NOT(ISNUMBER(M48)), NOT(ISNUMBER(Y48)), M48=0), \"\", IFERROR(A48/M48*Y48, \"\"))","v":{"$error":"#VALUE!"}}]
[]
["Tenant Portion ",null,null,null,"Month and year the contract started",null,null,null,null,null,null,null,"Days in month",null,null,null,null,"Date the lease and contract started ",null,null,null,null,null,null,"Number of days the unit is occupied",null,null,null,null,"Pro-Rated Tenant Portion"]
[]
[{"$f":"Calculator!H5-Calculator!H6","v":0},null,null,null,{"$f":"IF(Calculator!L8<>\"\",Calculator!L8,\"\")","v":""},null,null,null,null,null,null,null,{"$f":"DAY(EOMONTH(E52,0))","v":{"$error":"#VALUE!"}},null,null,null,null,{"$f":"IF(Calculator!N10<>\"\",Calculator!N10,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(ISNUMBER(R52), EOMONTH(R52,0)-R52+1, \"\")","v":""},null,null,null,null,{"$f":"IF(OR(ISBLANK(A52), ISBLANK(M52), ISBLANK(Y52), NOT(ISNUMBER(A52)), NOT(ISNUMBER(M52)), NOT(ISNUMBER(Y52)), M52=0), \"\", IFERROR(A52/M52*Y52, \"\"))","v":{"$error":"#VALUE!"}}]
[]
["Contract Rent",null,null,null,"Month and year the contract started",null,null,null,null,null,null,null,"Days in month",null,null,null,null,"Date the lease and contract started ",null,null,null,null,null,null,"Number of days the unit is occupied",null,null,null,null,"Pro-Rated Contract Rent"]
[]
[{"$f":"Calculator!H5","v":0},null,null,null,{"$f":"Calculator!L8","v":""},null,null,null,null,null,null,null,{"$f":"DAY(EOMONTH(E56,0))","v":{"$error":"#VALUE!"}},null,null,null,null,{"$f":"Calculator!N10","v":"00:00:00"},null,null,null,null,null,null,{"$f":"IF(ISNUMBER(R56), EOMONTH(R56,0)-R56+1, \"\")","v":32},null,null,null,null,{"$f":"IF(OR(ISBLANK(A56), ISBLANK(M56), ISBLANK(Y56), NOT(ISNUMBER(A56)), NOT(ISNUMBER(M56)), NOT(ISNUMBER(Y56)), M56=0), \"\", IFERROR(A56/M56*Y56, \"\"))","v":{"$error":"#VALUE!"}}]
[]
[]
[]
[]
["HAP amount",null,null,null,"Move in date",null,null,null,null,null,null,null,"Move out date",null,null,null,null,null,null,"Number of days the unit is occupied",null,null,null,null,"Pro-Rated Contract Rent"]
[]
[{"$f":"Calculator!H29","v":0},null,null,null,{"$f":"IF(Calculator!O31<>\"\",Calculator!O31,\"\")","v":""},null,null,null,null,null,null,null,{"$f":"IF(Calculator!K33<>\"\",Calculator!K33,\"\")","v":""},null,null,null,null,null,null,{"$f":"(M63-E63)+1","v":{"$error":"#VALUE!"}},null,null,null,null,{"$f":"(A63/DAY(EOMONTH(E63,0)))*T63","v":{"$error":"#VALUE!"}}]
[]
["Tenant portion",null,null,null,"Move in date",null,null,null,null,null,null,null,"Move out date",null,null,null,null,null,null,"Number of days the unit is occupied",null,null,null,null,"Pro-Rated Tenant Portion"]
[]
[{"$f":"Calculator!H27-Calculator!H29","v":0},null,null,null,{"$f":"IF(Calculator!O31<>\"\",Calculator!O31,\"\")","v":""},null,null,null,null,null,null,null,{"$f":"IF(Calculator!K33<>\"\",Calculator!K33,\"\")","v":""},null,null,null,null,null,null,{"$f":"(M67-E67)+1","v":{"$error":"#VALUE!"}},null,null,null,null,{"$f":"(A67/DAY(EOMONTH(E67,0)))*T67","v":{"$error":"#VALUE!"}}]
[]
["Contract Rent",null,null,null,"Move in date",null,null,null,null,null,null,null,"Move out date",null,null,null,null,null,null,"Number of days the unit is occupied",null,null,null,null,"Pro-Rated Contract Rent"]
[]
[{"$f":"Calculator!H27","v":0},null,null,null,{"$f":"IF(Calculator!O31<>\"\",Calculator!O31,\"\")","v":""},null,null,null,null,null,null,null,{"$f":"IF(Calculator!K33<>\"\",Calculator!K33,\"\")","v":""},null,null,null,null,null,null,{"$f":"(M71-E71)+1","v":{"$error":"#VALUE!"}},null,null,null,null,{"$f":"(A71/DAY(EOMONTH(E71,0)))*T71","v":{"$error":"#VALUE!"}}]

{"sheet":"Sheet2","index":2,"n_rows":170,"n_cols":12,"rows_kept":170,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Grant info",null,null,null,null,null,null,null,{"$f":"IF(Administration!B10<>\"\",\"Apt #\",\"\")","v":""}]
[]
[null,null,null,null,"2024-03-14T08:28:14"]
[null,null,"2024-03-14T08:28:14"]
[]
[null,"Tenant info"]
[null,"2024-03-14T08:27:48"]
[null,null,"2024-03-14T08:27:48"]
[null,"2024-03-14T08:27:48"]
[null,"2024-03-14T08:27:48"]
[null,"2024-03-14T08:27:49"]
[null,"2024-03-14T08:27:49"]
[]
[null,"Owner INFO"]
[null,"2024-03-14T08:27:49"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["CO"]
[{"$f":"E4","v":"2024-03-14T08:28:14"},{"$f":"C5","v":"2024-03-14T08:28:14"}]
[{"$f":"B8","v":"2024-03-14T08:27:48"},null,null,null,null,null,null,null,null,null,"2024-03-14T08:27:49"]
[{"$f":"B9","v":"00:00:00"},null,null,null,null,null,null,null,null,null,"2024-03-14T08:27:50"]
["2024-03-14T08:27:48",null,null,null,null,null,null,null,"2024-03-14T08:27:50"]
["2024-03-14T08:27:48",{"$f":"C9","v":"2024-03-14T08:27:48"},null,null,null,null,null,null,null,"2024-03-14T08:27:50"]
["2024-03-14T08:27:49",null,null,"2024-03-14T08:27:50",null,null,null,null,null,"2024-03-14T08:27:50"]
["2024-03-14T08:27:49"]
["00:00:00"]
[null,null,null,"2024-03-14T08:27:51"]
["2024-03-14T08:27:49"]
[]
[null,null,null,"2024-03-14T08:27:51",null,"2024-03-14T08:27:51",null,"2024-03-14T08:27:51"]
[null,null,null,"2024-03-14T08:27:52",null,"2024-03-14T08:27:52",null,"2024-03-14T08:27:52"]
[]
[]
[]
["2024-03-14T08:27:53"]
[]
[]
[]
[]
[]
[]
[]
[null,null,"2024-03-14T08:27:53"]
[]
[null,null,"2024-03-14T08:27:53",null,null,null,null,"2024-03-14T08:27:53",null,"2024-03-14T08:27:54"]
[]
[]
[]
[]
[]
[]
[]
["Calculation worksheet page 1"]
[null,null,null,null,null,null,"2024-03-14T08:27:54"]
[null,null,null,null,null,null,"2024-03-14T08:27:54",null,null,null,null,"2024-03-14T08:27:54"]
[null,null,null,null,null,null,"2024-03-14T08:27:55",null,null,null,null,"2024-03-14T08:27:55"]
[null,null,null,null,null,null,null,null,null,null,null,"2024-03-14T08:27:55"]
[null,null,null,null,null,null,"2024-03-14T08:27:55",null,null,null,null,"2024-03-14T08:27:56"]
[null,null,null,null,null,null,"2024-03-14T08:27:56"]
[null,null,null,null,null,null,"2024-03-14T08:27:56"]
[null,null,null,null,null,null,"2024-03-14T08:27:56"]
[null,null,null,null,null,null,"2024-03-14T08:27:56"]
[null,null,null,null,null,null,"2024-03-14T08:27:57"]
[null,null,null,null,null,null,"2024-03-14T08:27:57"]
[null,null,null,null,null,null,"2024-03-14T08:27:57"]
[null,null,null,null,null,null,"2024-03-14T08:27:57",null,null,null,null,"2024-03-14T08:27:58"]
[null,null,null,null,null,null,"2024-03-14T08:27:58",null,null,null,null,"2024-03-14T08:27:58"]
[null,null,null,null,null,null,"2024-03-14T08:27:58"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"2024-03-14T08:27:59"]
[null,null,null,null,null,null,"2024-03-14T08:27:59",null,null,null,null,"2024-03-14T08:27:59"]
[null,null,null,null,null,null,"2024-03-14T08:27:59",null,null,null,null,"2024-03-14T08:28:00"]
[null,null,null,null,null,null,null,null,null,null,null,"2024-03-14T08:28:00"]
[null,null,null,null,null,null,"2024-03-14T08:28:00",null,null,null,null,"2024-03-14T08:28:00"]
[null,null,null,null,null,null,"2024-03-14T08:28:01"]
[null,null,null,null,null,null,"2024-03-14T08:28:01"]
[null,null,null,null,null,null,"2024-03-14T08:28:01"]
[null,null,null,null,null,null,"2024-03-14T08:28:01"]
[null,null,null,null,null,null,"2024-03-14T08:28:02"]
[null,null,null,null,null,null,"2024-03-14T08:28:02"]
[null,null,null,null,null,null,"2024-03-14T08:28:02"]
[null,null,null,null,null,null,"2024-03-14T08:28:02",null,null,null,null,"2024-03-14T08:28:03"]
[null,null,null,null,null,null,"2024-03-14T08:28:03",null,null,null,null,"2024-03-14T08:28:03"]
[null,null,null,null,null,null,"2024-03-14T08:28:03"]
[]
[]
[]
[]
["Calculation worksheet page 2"]
[]
[null,null,"2024-03-14T08:28:04"]
[null,null,"2024-03-14T08:28:04"]
[null,null,"2024-03-14T08:28:04"]
[null,null,"2024-03-14T08:28:04"]
[null,null,"2024-03-14T08:28:05"]
[]
[]
[null,null,null,null,"2024-03-14T08:28:05"]
[]
[]
[]
[]
[null,null,null,null,"2024-03-14T08:28:05"]
[]
[]
[]
[]
[null,null,null,null,null,"2024-03-14T08:28:05",null,null,"2024-03-14T08:28:05"]
[null,null,null,null,null,"2024-03-14T08:28:06",null,null,"2024-03-14T08:28:06"]
[null,null,null,null,null,"2024-03-14T08:28:06",null,null,"2024-03-14T08:28:06"]
[null,null,null,null,null,"2024-03-14T08:28:07",null,null,"2024-03-14T08:28:07"]
[null,null,null,null,null,"2024-03-14T08:28:07",null,null,"2024-03-14T08:28:07"]
[null,null,null,null,null,"2024-03-14T08:28:08",null,null,"2024-03-14T08:28:08"]
[null,null,null,null,null,"2024-03-14T08:28:08",null,null,"2024-03-14T08:28:08"]
[null,null,null,null,null,"2024-03-14T08:28:09",null,null,"2024-03-14T08:28:09"]
[]
[]
[null,null,"2024-03-14T08:28:09"]
[null,null,"2024-03-14T08:28:10"]
[]
[null,null,"2024-03-14T08:28:10"]
[null,null,"2024-03-14T08:28:10"]
[]
[]
["Change payment info"]
[]
[]
[null,"2024-03-14T08:28:10"]
[]
[{"$f":"C9","v":"2024-03-14T08:27:48"}]
[{"$f":"B10","v":"2024-03-14T08:27:48"}]
[{"$f":"B11","v":"2024-03-14T08:27:48"},null,null,"2024-03-14T08:32:26"]
["2024-03-14T08:27:49"]
["2024-03-14T08:27:49",null,null,"2024-03-14T08:28:11"]
[]
[]
[]
[null,null,null,null,"2024-03-14T08:28:11"]
[]
[null,null,null,null,"2024-03-14T08:28:11"]
[]
[null,null,null,"2024-03-14T08:28:12"]
[]
[null,null,null,"2024-03-14T08:28:12"]
[]
[null,null,null,"2024-03-14T08:28:12"]
[]
[null,null,null,"2024-03-14T08:28:13"]
[]
[null,null,null,null,"2024-03-14T08:28:13"]
[]
[null,null,null,"2024-03-14T08:28:13"]
[]
[]
[null,null,null,"2024-03-14T08:28:13"]
[null,null,null,"2024-03-14T08:28:14"]

{"sheet":"Change Order","index":3,"n_rows":51,"n_cols":13,"rows_kept":51,"cut":false,"hidden":false,"merged":[[27,4,27,6],[27,7,27,9],[1,0,1,10],[2,0,2,10],[13,0,13,10],[4,2,4,3],[25,4,25,6],[25,7,25,9],[4,7,4,10],[6,0,6,1],[19,7,19,8],[10,2,10,9],[8,2,8,6],[6,2,6,10],[18,6,18,8],[19,3,19,6],[48,9,48,10],[50,1,50,2],[45,6,45,7],[45,9,45,10],[47,2,47,4],[47,6,47,7],[47,9,47,10],[46,9,46,10],[45,2,45,4],[50,8,50,11],[48,2,48,4],[48,6,48,7],[29,4,29,6],[30,4,30,6],[46,2,46,4],[46,6,46,7],[29,7,29,9],[31,0,41,10],[30,7,30,9],[43,2,43,3],[26,4,26,6],[26,7,26,9],[18,3,18,5],[15,3,15,5],[17,3,17,5],[15,6,15,7],[15,8,15,9],[16,6,16,7],[16,8,16,9],[17,6,17,8]]}
[]
["CoC Rental Assistance Program",null,null,null,null,null,null,null,null,null,null,null,false]
["Change Order Form",null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,false]
["CONTRACT #    ",null,{"$f":"Administration!C20","v":0},null,null,"  HUD AWARD #:",null,{"$f":"Administration!I20","v":0},null,null,null,null,false]
[]
["ADDRESS:",null,{"$f":"Administration!H22","v":"     "}]
[]
["TENANT NAME:",null,{"$f":"Administration!C22","v":0}]
[]
["OWNER NAME:",null,{"$f":"Administration!C24","v":0}]
[]
[]
["NATURE OF TRANSACTION (PLEASE CHECK ALL ITEMS THAT APPLY)"]
[]
["1. TERMINATION OF HOUSING:",null,null,"2. CHANGE HUD AWARD #",null,null,"FROM:",null,{"$f":"Administration!K29","v":0}]
["Same Owner, New Unit",null,null,null,null,null,"    TO:",null,{"$f":"Administration!K30","v":0}]
["New Owner, Same Unit",null,null,"3. ISSUE CHECK - MONTH:",null,null,{"$f":"Administration!I31","v":0}]
["New Owner, New Unit",null,null,"      4. SUSPEND CHECK - MONTH:",null,null,{"$f":"Administration!J32","v":0}]
["Suspend Check - Month:",null,{"$f":"Administration!D33","v":0},"         5. CLAIM FOR DAMAGES - AMOUNT:   ",null,null,null,{"$f":"Administration!J33","v":0}]
[null,null,null,"      *Not to exceed one month current contract rent"]
["6.  TERMINATION FROM CoC RA PROGRAM: "]
["Suspend Check - Month:",null,{"$f":"Administration!D36","v":0}]
[]
[]
["7. CHANGE IN SUBSIDY:",null,null,"CONTRACT RENT","HAP PAYMENT",null,null,"TENANT PAYMENT"]
[null,null,"FROM",{"$f":"IF(Administration!D39<>\"\", Administration!D39, \"\")","v":""},{"$f":"IF(Administration!F39<>\"\", Administration!F39, \"\")","v":""},null,null,{"$f":"IF(Administration!H39<>\"\", Administration!H39, \"\")","v":""}]
[null,null,"TO",{"$f":"IF(Administration!D40<>\"\", Administration!D40, \"\")","v":""},{"$f":"IF(Administration!F40<>\"\", Administration!F40, \"\")","v":""},null,null,{"$f":"IF(Administration!H40<>\"\", Administration!H40, \"\")","v":""}]
[]
[]
["REASON FOR CHANGE: "]
[{"$f":"Administration!A44","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["EFFECTIVE DATE:",null,{"$f":"IF(Administration!C52<>\"\", Administration!C52, \"\")","v":""}]
[]
["PREPARED BY:",null,{"$f":"IF(Administration!C54<>\"\", Administration!C54, \"\")","v":""},null,null,null,{"$f":"IF(Administration!H54<>\"\", Administration!H54, \"\")","v":""},null,null,{"$f":"IF(Administration!J54<>\"\", Administration!J54, \"\")","v":""}]
[null,null,"Printed/Typed Name",null,null,null,"Initials",null,null,"Date"]
["APPROVED BY:"]
[null,null,"Printed/Typed Name",null,null,null,"Initials",null,null,"Date"]
["Rev. 8.23"]
["Last edited",{"$f":"LARGE(Sheet2!A28:K54,1)","v":"2024-03-14T08:28:14"},null,null,null,null,null,null,{"$f":"Administration!A2","v":"Version 2.1"}]

{"sheet":"Calculation Worksheet Page 1","index":4,"n_rows":43,"n_cols":4,"rows_kept":43,"cut":false,"hidden":false,"merged":[[2,2,2,3],[11,2,11,3],[22,2,22,3],[30,2,30,3],[31,2,31,3]]}
[]
["Household Member #1",null,"Household Member #1"]
[null,"Monthly","Weekly Pay"]
["SSDI",{"$f":"Administration!G63","v":0},"Week 1 Pay",{"$f":"Administration!L64","v":0}]
["SSI",{"$f":"Administration!G64","v":0},"Week 2 Pay",{"$f":"Administration!L65","v":0}]
["TANF",{"$f":"Administration!G65","v":0},"Week 3 Pay",{"$f":"Administration!L66","v":0}]
["Earned Income",{"$f":"Administration!G66","v":0},"Week 4 Pay",{"$f":"Administration!L67","v":0}]
["SAGA",{"$f":"Administration!G67","v":0},"Total",{"$f":"Administration!L69","v":0}]
["Unemployment",{"$f":"Administration!G68","v":0},"Monthly Average",{"$f":"Administration!L70","v":0}]
["Child Support",{"$f":"Administration!G69","v":0}]
["Alimony",{"$f":"Administration!G70","v":0},"Household Member #1"]
["VA Service- Connected Disability Compensation Income",{"$f":"Administration!G71","v":0},"Bi-Weekly Pay"]
["VA Non-Service Connected Disability Pension",{"$f":"Administration!G72","v":0},"Bi-Weekly 1st",{"$f":"Administration!L75","v":0}]
["Private Disability Insurance Income",{"$f":"Administration!G73","v":0},"Bi-Weekly 2nd",{"$f":"Administration!L76","v":0}]
["Retirement Income from Social Security Income",{"$f":"Administration!G74","v":0},"Total",{"$f":"SUM(D13,D14)","v":0}]
["Pension/ Retirement Income from a former job",{"$f":"Administration!G75","v":0},"Monthly Average",{"$f":"FLOOR(D15/2*26/12,1)","v":0}]
["Worker's Compensation",{"$f":"Administration!G76","v":0}]
["Other sources of Income",{"$f":"Administration!G77","v":0}]
[null,{"$f":"SUM(B4:B18)","v":0}]
[]
[]
["Household Member #2",null,"Household Member #2"]
[null,"Monthly","Weekly Pay"]
["SSDI",{"$f":"Administration!G84","v":0},"Week 1 Pay",{"$f":"Administration!L85","v":0}]
["SSI",{"$f":"Administration!G85","v":0},"Week 2 Pay",{"$f":"Administration!L86","v":0}]
["TANF",{"$f":"Administration!G86","v":0},"Week 3 Pay",{"$f":"Administration!L87","v":0}]
["Earned Income",{"$f":"Administration!G87","v":0},"Week 4 Pay",{"$f":"Administration!L88","v":0}]
["SAGA",{"$f":"Administration!G88","v":0},"Total",{"$f":"SUM(D24:D27)","v":0}]
["Unemployment",{"$f":"Administration!G89","v":0},"Monthly Average",{"$f":"FLOOR(D28/4*52/12,1)","v":0}]
["Child Support",{"$f":"Administration!G90","v":0}]
["Alimony",{"$f":"Administration!G91","v":0},"Household Member #2"]
["VA Service- Connected Disability Compensation Income",{"$f":"Administration!G92","v":0},"Bi-Weekly Pay"]
["VA Non-Service Connected Disability Pension",{"$f":"Administration!G93","v":0},"Bi-Weekly 1st",{"$f":"Administration!L96","v":0}]
["Private Disability Insurance Income",{"$f":"Administration!G94","v":0},"Bi-Weekly 2nd",{"$f":"Administration!L97","v":0}]
["Retirement Income from Social Security Income",{"$f":"Administration!G95","v":0},"Total",{"$f":"SUM(D33,D34)","v":0}]
["Pension/ Retirement Income from a former job",{"$f":"Administration!G96","v":0},"Monthly Average",{"$f":"FLOOR(D35/2*26/12,1)","v":0}]
["Worker's Compensation",{"$f":"Administration!G97","v":0}]
["Other sources of Income",{"$f":"Administration!G98","v":0}]
[null,{"$f":"SUM(B24:B38)","v":0}]
[]
["Last Edited"]
[{"$f":"LARGE(Sheet2!A63:L98,1)","v":"2024-03-14T08:28:03"}]
[{"$f":"Administration!A2","v":"Version 2.1"}]

{"sheet":"Calculation Worksheet Page 2","index":5,"n_rows":47,"n_cols":17,"rows_kept":47,"cut":false,"hidden":false,"merged":[[19,0,20,4],[0,6,0,7],[10,0,10,1],[3,3,3,5],[4,3,4,5],[6,1,6,5],[7,1,7,5],[0,4,0,5],[1,4,1,5],[1,6,1,7],[32,1,32,4],[33,1,33,4],[34,1,34,4],[35,1,35,4],[45,0,45,1],[45,2,45,4]]}
["Date:",{"$f":"Administration!C105","v":"00:00:00"},null,null,"Certificate Number:",null,{"$f":"Administration!C106","v":0}]
[null,null,null,null,"Contract Number:",null,{"$f":"Administration!C5","v":0}]
[]
[null,null,null,"Rental Assistance Payments"]
[null,null,null,"Calculation Worksheet"]
[]
["Name:  ",{"$f":"Administration!B8","v":0},null,null,null,null,"# of Bedrooms:",{"$f":"Administration!C107","v":0}]
["Address: ",{"$f":"Administration!H22","v":"     "},null,null,null,null,"# of Dependents:",{"$f":"Administration!C108","v":0}]
[null,null,null,null,null,null,"# in Household:",{"$f":"Administration!C109","v":0}]
[]
["1. Gross Annual Income: ",null,null,null,null,null,null,{"$f":"+ROUNDDOWN(E12+E13,0)","v":0}]
["  Household Member #1:",null,{"$f":"'Calculation Worksheet Page 1'!B19","v":0},"Monthly",{"$f":"+C12*12","v":0},"Yearly"]
["  Household Member #2:",null,{"$f":"'Calculation Worksheet Page 1'!B39","v":0},"Monthly",{"$f":"+C13*12","v":0},"Yearly"]
[]
["    A. 10% of Gross Annual Income divided by 12 months",null,null,null,null,null,null,{"$f":"+ROUNDDOWN(H11*0.1/12,0)","v":0}]
["    B. Total Utility Allowance from #6",null,null,null,null,null,null,{"$f":"H39","v":0}]
["    C. 10 % of Gross Monthly Income (line 1A) minus Total utility allowance",null,null,null,null,null,null,{"$f":"+H15-H16","v":0}]
["2. Annual Allowances"]
["    A. Each Dependent ",null,480,null,null,null,null,{"$f":"IF(H8=0,0,H8*C19)","v":0}]
["    B. For Child Care: (Costs which enable one or both parents to be gainfully employed)",null,null,null,null,null,null,{"$f":"Administration!E112","v":0}]
[]
["    C. Non-reimbursed Medical Expenses in excess of 3% of Gross Income:"]
[null,"a. Non-reimbursed Medical Expenses",null,null,null,null,null,{"$f":"Administration!E117","v":0}]
[null,"b. Less 3% of Annual Income",null,null,null,null,null,{"$f":"IF(H23>0,+H11*0.03,0)","v":0}]
[null,"c. Deduction (greater than zero) a - b = #2c",null,null,null,null,null,{"$f":"IF(H23-H24>0,(H23-H24),0)","v":0}]
["    D. Allowances for Elderly and Disabled ",null,null,null,400,null,null,{"$f":"+E26","v":400}," "]
["    E. Total Allowances",null,null,null,null,null,null,{"$f":"ROUNDDOWN(H20+H19+H25+H26,0)","v":400}]
["3. Annual Income After Allowances",null,null,null,null,null,null,{"$f":"+ROUNDDOWN(H11-H27,0)","v":-400}]
["    A. Monthly income after allowances",null,null,null,null,null,null,{"$f":"+ROUNDDOWN(H28/12,0)","v":-33}]
["4. 30% of Monthly Income After Allowances",null,null,null,null,null,null,{"$f":"ROUNDDOWN(H29*0.3,0)","v":-9}]
["5. Contract Rent",null,null,null,null,null,null,{"$f":"Administration!C133","v":0}]
["6. Allowance for Utilities and Other Services"]
[null,"Heating:      Natural Gas/Bottle Gas/Oil/Electric",null,null,null,{"$f":"Administration!F122","v":0},null,{"$f":"Administration!I122","v":0}]
[null,"Water Heat: Natural Gas/Bottle Gas/Oil/Electric",null,null,null,{"$f":"Administration!F123","v":0},null,{"$f":"Administration!I123","v":0}]
[null,"Cooking:      Natural Gas/Bottle Gas/Oil/Electric",null,null,null,{"$f":"Administration!F124","v":0},null,{"$f":"Administration!I124","v":0}]
[null,"Other Electric: Lighting, refrigeration, etc.",null,null,null,{"$f":"Administration!F125","v":0},null,{"$f":"Administration!I125","v":0}]
["Appliances:     ","Range   Refrigerator",null,{"$f":"Administration!F126","v":0},null,{"$f":"Administration!F127","v":0},null,{"$f":"Administration!I126+Administration!I127","v":0}]
["Misc:  ","Water    Trash Collection",null,{"$f":"Administration!F128","v":0},null,{"$f":"Administration!F129","v":0},null,{"$f":"Administration!I128+Administration!I129","v":0},null,null,null,null,null,null,null,null," "]
[null,"Total Utility Allowance",null,null,null,null,null,{"$f":"SUM(H33:H38)","v":0}]
["7. Gross Rent",null,null,null,null,null,null,{"$f":"H31+H39","v":0}]
["8. Fair Market Rent",null,null,null,null,null,null,{"$f":"Administration!C132","v":0}]
["9. Family Contribution",null,"The greater of either #1C",null,{"$f":"H17","v":0},"or #4-#6",{"$f":"H30-H39","v":-9},{"$f":"IF(G42 > H31, H31, MAX(E42, G42, 0))","v":0}]
["10. Subsidy Payment",null,null,null,null,null,null,{"$f":"IF(H42>0,H31-H42,H31)","v":0}]
[]
[]
["Preparer's Typed Name:",null,{"$f":"IF(Administration!C135<>\"\", Administration!C135, \"\")","v":""},null,null,null,"Last edited"]
["rev.9/25/23"," ",null,null,null,null,{"$f":"LARGE(Sheet2!A104:L136,1)","v":"2024-03-14T08:28:10"},{"$f":"Administration!A2","v":"Version 2.1"}]

{"sheet":"Change Tenant Payment Form","index":6,"n_rows":46,"n_cols":66,"rows_kept":46,"cut":false,"hidden":false,"merged":[[13,50,13,59],[17,55,17,64],[18,55,18,64],[19,55,19,64],[4,1,4,12],[6,1,6,35],[7,1,7,39],[13,10,13,17],[13,28,13,35],[15,8,15,15],[44,0,44,12],[21,65,21,76],[29,1,29,48],[30,1,30,46],[32,6,32,39],[33,6,33,38],[43,0,43,7],[21,1,21,64]]}
[]
[]
[]
[]
[null,{"$f":"IF(Administration!B142<>\"\", Administration!B142, \"\")","v":""}]
[]
[null,{"$f":"Administration!C144","v":","}]
[null,{"$f":"Administration!C9&\" \"&Sheet2!J2&\" \"&Administration!B10","v":"  "}]
[null,{"$f":"Administration!B11&\"  \"&Administration!B12&\"  \"&Administration!B13","v":"    "}]
[]
[null,"Dear",null,null,null,{"$f":"B7","v":","}]
[]
[null,"Upon recent income re-determination your tenant portion towards your rent has changed.  The change "]
[null,"reflects your ",null,null,null,null,null,null,null,null,{"$f":"Administration!D146","v":0},null,null,null,null,null,null,null,"in income to ",null,null,null,null,null,null,null,null,null,{"$f":"Administration!D148","v":0},null,null,null,null,null,null,null,"a month, effective ",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Administration!E154<>\"\", Administration!E154, \"\")","v":""}]
[]
[null,"Beginning ",null,null,null,null,null,null,{"$f":"IF(Administration!E152<>\"\", Administration!E152, \"\")","v":""},null,null,null,null,null,null,null,"and every month thereafter, the payments will be as follows:"]
[]
[null,null,null,"Tenant Portion of Rent:  (the portion you will pay)",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,{"$f":"Administration!D156","v":0}]
[null,null,null,"Housing Assistance Payment:  (the portion CoC RA Program pays)",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,{"$f":"Administration!D158","v":0}]
[null,null,null,"Contract Rent to Owner:",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,{"$f":"Administration!D160","v":0}]
[]
[null,"If you have any questions, please do not hesitate to contact me at this telephone number:",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,{"$f":"Administration!E164","v":0}]
[]
[null,"Please report (Within 10 days) any changes in family composition and/or income changes of more "]
[null,"than $40 per month.  (Income change should be expected to be ongoing)."]
[]
[null,"Sincerely,"]
[]
[]
[null,{"$f":"Administration!D162","v":0}]
[null,{"$f":"Administration!D166","v":0}]
[]
[null,"Cc:",null,null,null,null,{"$f":"Administration!D169","v":0}]
[null,null,null,null,null,null,{"$f":"Administration!D170","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Last edited"]
[{"$f":"LARGE(Sheet2!A140:F170,1)","v":"2024-03-14T08:32:26"}]
[{"$f":"Administration!A2","v":"Version 2.1"}]