{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Input"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":19,"n_cols":23,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,null,null,null,null,null,"Current",null,"Mexico",null,"% Change",null,0,1422.3000000000002,2202,2490.84,3209.6,3577.7,4387.32,4615,5827.2,{"$f":"HLOOKUP(J19,O3:V19,17,TRUE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,"Rent - two/three bedroom home",null,null,null,null,null,{"$f":"IF(H4<>0,1-(J4/H4),\"\")","v":""},null,0.21092596498628979,0.21092596498628979,0.20435967302452315,0.1906987201104848,0.18693918245264207,0.17469323867289041,0.18234366310184807,0.18418201516793067,0.21451125755079628]
[null,null,null,null,null,"Electricity",null,null,null,null,null,"",null,1.7577163748857483E-2,1.7577163748857483E-2,1.5894641235240689E-2,1.6058839588251352E-2,2.3367397806580259E-2,2.0963188640746849E-2,2.2792957887731009E-2,2.1668472372697724E-2,2.5741350906095552E-2]
[null,null,null,null,null,"Gas",null,null,null,null,null,"",null,3.5154327497714964E-3,3.5154327497714964E-3,3.6330608537693005E-3,3.2117679176502704E-3,3.1156530408773678E-3,2.7950918187662466E-3,2.7351549465277208E-3,2.6002166847237272E-3,2.7457440966501922E-3]
[null,null,null,null,null,"Water",null,null,null,null,null,"",null,0,0,9.0826521344232521E-3,8.0294197941256761E-3,1.2462612163509471E-2,1.1180367275064986E-2,1.3675774732638604E-2,1.3001083423618635E-2,1.3728720483250962E-2]
[null,null,null,null,null,"Cable/Internet",null,null,null,null,null,"",null,0,0,1.3623978201634877E-2,1.2044129691188513E-2,9.3469591226321043E-3,1.1180367275064986E-2,1.0256831049478953E-2,1.0834236186348862E-2,1.0296540362438222E-2]
[null,null,null,null,null,"Phone (Landline &/or cell)",null,null,null,null,null,"",null,8.4370385994515917E-3,8.4370385994515917E-3,6.8119891008174387E-3,8.0294197941256761E-3,7.78913260219342E-3,8.3852754562987394E-3,7.9775352607058536E-3,8.6673889490790895E-3,8.5804503020318508E-3]
[null,null,null,null,null,"Total Utilities",null,{"$f":"SUM(H4:H9)","v":0},null,{"$f":"SUM(J5:J9)","v":0},null,{"$f":"IF(H10<>0,1-(J10/H10),\"\")","v":""}]
[null,null,null,null,null,"Groceries/Household Supplies",null,null,null,null,null,{"$f":"IF(H11<>0,1-(J11/H11),\"\")","v":""},null,0.28123461998171972,0.28123461998171972,0.22706630336058128,0.2007354948531419,0.18693918245264207,0.16770550912597479,0.15955070521411704,0.15167930660888407,0.13728720483250961]
[null,null,null,null,null,"Eating out/travel/entertainment",null,null,null,null,null,"",null,0,0,2.2706630336058128E-2,3.0110324227971285E-2,4.6734795613160518E-2,5.5901836375324934E-2,6.8378873663193021E-2,7.5839653304442034E-2,8.5804503020318515E-2]
[null,null,null,null,null,"Transportation Expense ",null,null,null,null,null,"",null,1.4061730999085986E-2,1.4061730999085986E-2,1.3623978201634877E-2,1.2044129691188513E-2,2.8040877367896313E-2,2.7950918187662467E-2,2.9630845254050311E-2,2.8169014084507043E-2,2.5741350906095552E-2]
[null,null,null,null,null,"Incidentals",null,null,null,null,null,"",null,3.5154327497714966E-2,3.5154327497714966E-2,3.4059945504087197E-2,3.0110324227971285E-2,3.115653040877368E-2,3.4938647734578082E-2,3.9887676303529261E-2,4.3336944745395449E-2,4.2902251510159257E-2]
[null,null,null,null,null,"Hired help ($15/day x # days)",null,null,null,null,null,"",null,0,0,2.9518619436875566E-2,5.2191228661816892E-2,6.0755234297108676E-2,7.2672387287922413E-2,7.4077113135125772E-2,7.0422535211267609E-2,6.8643602416254806E-2]
[null,null,null,null,null,"Other Expenses",null,null,null,null,null,"",null,3.5154327497714966E-2,3.5154327497714966E-2,8.6285195277020887E-2,0.11241187711775946,0.13864656031904288,0.16351287139782542,0.18234366310184807,0.18959913326110509,0.19735035694673256]
[null,null,null,null,null,"Total Expected Living Expenses",null,{"$f":"SUM(H4,H10,H11,H12,H13,H14,H15,H16,)","v":0},null,{"$f":"SUM(J4,J10,J11:J16,)","v":0},null,{"$f":"IF(H17<>0,1-(J17/H17),\"\")","v":""}]
[null,null,null,null,null,"Allowance for savings/medical/ unexpected expenses",null,null,null,{"$f":"IF(J17>500,(VLOOKUP(J17,N3:V18,2,TRUE))*J17,\"\")","v":""},null,null,null,0.45,0.39393939393939392,0.33333333333333331,0.32432432432432429,0.26470588235294118,0.24812030075187971,0.20634920634920637,0.2,0.16666666666666669]
[null,null,null,null,null,"Net Income required",null,{"$f":"H17","v":0},null,{"$f":"SUM(J17:J18)","v":0},null,{"$f":"IF(H19<>0,1-(J19/H19),\"\")","v":""},null,"D Low","D Low","D High","C Low","C High","B Low","B High","A Low","A High"]