{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Input"],"not_rendered":{"charts":0,"images":0,"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":"Input","index":0,"n_rows":20,"n_cols":20,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,5,1,9]]}
[]
[null,null,null,null,null,"Estimate your monthly living expenses!"]
[null,null,null,null,null,null,null,null,{"$f":"\"Estimated Lifestyle Level is \" & T3","v":"Estimated Lifestyle Level is "},0,1500.2517044933559,1750,2299.9404999999997,2500,3099.7080000000001,3300,3900,4100,null,{"$f":"IF(S3<>\"\",HLOOKUP(S3,$J$3:$R$19,17, TRUE),\"\")","v":""}]
[null,null,null,null,null,null,"Rent - two/three bedroom home",null,{"$f":"IF(S3<>\"\",S3*S4,\"\")","v":""},0.3,0.26015634498599466,0.22494542823910918,0.20650000276057898,0.22224074228407922,0.20965983498158217,0.23524491258949612,0.2297471373909076,0.28734046857184892,{"$f":"IF(S3<>\"\",HLOOKUP(S3,$J$3:$R$19,2, TRUE),\"\")","v":""}]
[null,null,null,null,null,null,"Electricity",null,{"$f":"IF(S3<>\"\",S3*S5,\"\")","v":""},2.4E-2,2.0812507598879572E-2,1.8995391717969219E-2,1.8693684460431362E-2,2.2224074228407921E-2,2.5804287382348575E-2,2.9998004872008481E-2,3.2050739256343629E-2,3.1032770605759683E-2,{"$f":"IF(S3<>\"\",HLOOKUP(S3,$J$3:$R$19,3, TRUE),\"\")","v":""}]
[null,null,null,null,null,null,"Gas",null,{"$f":"IF(S3<>\"\",S3*S6,\"\")","v":""},1.4999999999999999E-2,1.3007817249299733E-2,9.997574588404853E-3,1.0868421197925211E-2,9.260030928503301E-3,1.1289375729777501E-2,9.9993349573361603E-3,1.0256236562029961E-2,1.0344256868586562E-2,{"$f":"IF(S3<>\"\",HLOOKUP(S3,$J$3:$R$19,4, TRUE),\"\")","v":""}]
[null,null,null,null,null,null,"Water",null,{"$f":"IF(S3<>\"\",S3*S7,\"\")","v":""},0,0,7.4981809413036393E-3,8.6947369583401674E-3,9.260030928503301E-3,9.6766077683807152E-3,8.5708585348595653E-3,1.0256236562029961E-2,1.0344256868586562E-2,{"$f":"IF(S3<>\"\",HLOOKUP(S3,$J$3:$R$19,5, TRUE),\"\")","v":""}]
[null,null,null,null,null,null,"Cable/Internet",null,{"$f":"IF(S3<>\"\",S3*S8,\"\")","v":""},1.9E-2,1.6476568515779659E-2,1.7495755529708491E-2,1.7389473916680335E-2,1.6668055671305942E-2,1.935321553676143E-2,1.8570193492195724E-2,1.7948413983552434E-2,1.7240428114310934E-2,{"$f":"IF(S3<>\"\",HLOOKUP(S3,$J$3:$R$19,6, TRUE),\"\")","v":""}]
[null,null,null,null,null,null,"Phone (Landline &/or cell)",null,{"$f":"IF(S3<>\"\",S3*S9,\"\")","v":""},1.4999999999999999E-2,1.3007817249299733E-2,1.2496968235506065E-2,1.3042105437510252E-2,1.111203711420396E-2,1.1289375729777501E-2,1.0856420810822116E-2,1.0811629994866239E-2,1.1493618742873957E-2,{"$f":"IF(S3<>\"\",HLOOKUP(S3,$J$3:$R$19,7, TRUE),\"\")","v":""}]
[null,null,null,null,null,null,"Total Utilities",null,{"$f":"SUM(I5:I9)","v":0}]
[null,null,null,null,null,null,"Groceries/Household Supplies",null,{"$f":"IF(S3<>\"\",S3*S11,\"\")","v":""},0.31,0.26882822315219446,0.24993936471012132,0.26084210875020503,0.24076080414108583,0.22578751459555005,0.21427146337148914,0.20512473124059924,0.1896447092574203,{"$f":"IF(S3<>\"\",HLOOKUP(S3,$J$3:$R$19,9, TRUE),\"\")","v":""}]
[null,null,null,null,null,null,"Eating out/travel/entertainment",null,{"$f":"IF(S3<>\"\",S3*S12,\"\")","v":""},0,0,2.499393647101213E-2,3.477894783336067E-2,3.7040123714013204E-2,5.6446878648887512E-2,5.7139056899063768E-2,6.4101478512687257E-2,6.8961712457243737E-2,{"$f":"IF(S3<>\"\",HLOOKUP(S3,$J$3:$R$19,10, TRUE),\"\")","v":""}]
[null,null,null,null,null,null,"Transportation Expense ",null,{"$f":"IF(S3<>\"\",S3*S13,\"\")","v":""},1.4999999999999999E-2,1.3007817249299733E-2,1.4996361882607279E-2,2.1736842395850421E-2,3.3336111342611885E-2,3.2255359227935716E-2,3.7140386984391448E-2,3.8460887107612356E-2,4.597447497149583E-2,{"$f":"IF(S3<>\"\",HLOOKUP(S3,$J$3:$R$19,11,TRUE),\"\")","v":""}]
[null,null,null,null,null,null,"Incidentals",null,{"$f":"IF(S3<>\"\",S3*S14,\"\")","v":""},2.5000000000000001E-2,2.1679695415499554E-2,2.499393647101213E-2,3.2605263593775628E-2,4.6300154642516501E-2,4.8383038841903578E-2,4.9996674786680802E-2,5.128118281014981E-2,4.597447497149583E-2,{"$f":"IF(S3<>\"\",HLOOKUP(S3,$J$3:$R$19,12, TRUE),\"\")","v":""}]
[null,null,null,null,null,null,"Hired help ($15/day x # days)",null,{"$f":"IF(S3<>\"\",S3*S15,\"\")","v":""},0,0,3.2492117412315773E-2,2.8257895114605545E-2,4.8152160828217168E-2,4.1931966996316433E-2,5.5710580476587175E-2,6.6665537653194745E-2,7.4708521828680721E-2,{"$f":"IF(S3<>\"\",HLOOKUP(S3,$J$3:$R$19,13, TRUE),\"\")","v":""}]
[null,null,null,null,null,null,"Other Expenses",null,{"$f":"IF(S3<>\"\",S3*S16,\"\")","v":""},3.5154327497714966E-2,3.0485404507487244E-2,7.4981809413036393E-2,8.6947369583401685E-2,9.2600309285033003E-2,9.6766077683807156E-2,8.5708585348595656E-2,8.9742069917762166E-2,8.0455331200117705E-2,{"$f":"IF(S3<>\"\",HLOOKUP(S3,$J$3:$R$19,14, TRUE),\"\")","v":""}]
[null,null,null,null,null,null,"Total Expected Living Expenses",null,{"$f":"SUM(I4,I10:I16,)","v":0}]
[null,null,null,null,null,null,"Allowance for savings/medical/ unexpected expenses",null,{"$f":"IF(S3<>\"\",S3*S18,\"\")","v":""},0.24149999999999999,0.34253780407626561,0.28617317438789347,0.25964314799733473,0.21104536489151873,0.2113564668769716,0.18679352687647394,0.17355371900826444,0.12648497554157934,{"$f":"IF(S3<>\"\",HLOOKUP(S3,$J$3:$R$19,16, TRUE),\"\")","v":""}]
[null,null,null,null,null,null,"Net Income",null,{"$f":"SUM(I17:I18)","v":0},"D - Low","D - Low","D - High","C - Low","C - High","B - Low","B - High","A - Low","A - High"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K4:K18)","v":1},1,1,{"$f":"SUM(N4:N18)","v":1},{"$f":"SUM(O4:O18)","v":1},1.0000000000000002,0.99999999999999967,1.0000000000000002]