{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Title","Start","Middle","Done","Wrap Up","Seminars"],"not_rendered":{"charts":0,"images":11,"macros":1,"external_links":1,"defined_names":30,"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":"Title","index":0,"n_rows":25,"n_cols":13,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,2065]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Image credit: Foto-Rabe / Pixabay"]

{"sheet":"Start","index":1,"n_rows":40,"n_cols":14,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
["Income Statement"]
[null,"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec","YTD"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Income",{"$f":"B16","v":249531},{"$f":"C16-B16","v":167315},{"$f":"D16-C16","v":194208},9827153,14436701,3489718,24361612,13707548,-66365976,339966,94572,10908520]
["Income YTD",249531,416846,611054,10438207,24874908,28364626,52726238,66433786,67810,407776,502348,11410868]
["Tax YTD",{"$f":"VLOOKUP(B16,$B$33:$D$40,2,TRUE)+VLOOKUP(B16,$B$33:$D$40,3,TRUE)*(B16-VLOOKUP(B16,$B$33:$D$40,1,TRUE))","v":0},{"$f":"VLOOKUP(C16,$B$33:$D$40,2,TRUE)+VLOOKUP(C16,$B$33:$D$40,3,TRUE)*(C16-VLOOKUP(C16,$B$33:$D$40,1,TRUE))","v":1179.22},18105.400000000001,1485231.05,2119481.6,1185656.5,4537271.4000000004,3571325.0999999996,0,544.32000000000005,7234.8,1631130.2]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Amount","Base","+ % over"]
[null,0,0,0]
[null,400000,0,7.0000000000000007E-2]
[null,500000,7000,0.1]
[null,750000,32000,0.15]
[null,15000000,144500,0.2]
[null,25000000,344500,0.25]
[null,40000000,719400,0.3]
[null,60000000,1319500,0.35]

{"sheet":"Middle","index":2,"n_rows":38,"n_cols":14,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
["Income Statement"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"]
["Income",249531,416846,611054,10438207,24874908,28364626,52726238,66433786,67810,407776,502348,11410868]
["Tax",{"$f":"VLOOKUP(B16,$B$31:$D$38,2,TRUE)+VLOOKUP(B16,$B$31:$D$38,3,TRUE)*(B16-VLOOKUP(B16,$B$31:$D$38,1,TRUE))","v":0},1179.22,18105.400000000001,1485231.05,2119481.6,1185656.5,4537271.4000000004,3571325.0999999996,0,544.32000000000005,7234.8,1631130.2]
["One Formula",{"$f":"VLOOKUP(B16,{0,0,0;400000,0,0.07;500000,7000,0.1;750000,32000,0.15;15000000,144500,0.2;25000000,344500,0.25;40000000,719400,0.3;60000000,1319500,0.35},2,TRUE)+VLOOKUP(B16,{0,0,0;400000,0,0.07;500000,7000,0.1;750000,32000,0.15;15000000,144500,0.2;25000000,344500,0.25;40000000,719400,0.3;60000000,1319500,0.35},3,TRUE)*(B16-VLOOKUP(B16,{0,0,0;400000,0,0.07;500000,7000,0.1;750000,32000,0.15;15000000,144500,0.2;25000000,344500,0.25;40000000,719400,0.3;60000000,1319500,0.35},1,TRUE))","v":0},{"$f":"VLOOKUP(C16,{0,0,0;400000,0,0.07;500000,7000,0.1;750000,32000,0.15;15000000,144500,0.2;25000000,344500,0.25;40000000,719400,0.3;60000000,1319500,0.35},2,TRUE)+VLOOKUP(C16,{0,0,0;400000,0,0.07;500000,7000,0.1;750000,32000,0.15;15000000,144500,0.2;25000000,344500,0.25;40000000,719400,0.3;60000000,1319500,0.35},3,TRUE)*(C16-VLOOKUP(C16,{0,0,0;400000,0,0.07;500000,7000,0.1;750000,32000,0.15;15000000,144500,0.2;25000000,344500,0.25;40000000,719400,0.3;60000000,1319500,0.35},1,TRUE))","v":1179.22},{"$f":"VLOOKUP(D16,{0,0,0;400000,0,0.07;500000,7000,0.1;750000,32000,0.15;15000000,144500,0.2;25000000,344500,0.25;40000000,719400,0.3;60000000,1319500,0.35},2,TRUE)+VLOOKUP(D16,{0,0,0;400000,0,0.07;500000,7000,0.1;750000,32000,0.15;15000000,144500,0.2;25000000,344500,0.25;40000000,719400,0.3;60000000,1319500,0.35},3,TRUE)*(D16-VLOOKUP(D16,{0,0,0;400000,0,0.07;500000,7000,0.1;750000,32000,0.15;15000000,144500,0.2;25000000,344500,0.25;40000000,719400,0.3;60000000,1319500,0.35},1,TRUE))","v":18105.400000000001},{"$f":"VLOOKUP(E16,{0,0,0;400000,0,0.07;500000,7000,0.1;750000,32000,0.15;15000000,144500,0.2;25000000,344500,0.25;40000000,719400,0.3;60000000,1319500,0.35},2,TRUE)+VLOOKUP(E16,{0,0,0;400000,0,0.07;500000,7000,0.1;750000,32000,0.15;15000000,144500,0.2;25000000,344500,0.25;40000000,719400,0.3;60000000,1319500,0.35},3,TRUE)*(E16-VLOOKUP(E16,{0,0,0;400000,0,0.07;500000,7000,0.1;750000,32000,0.15;15000000,144500,0.2;25000000,344500,0.25;40000000,719400,0.3;60000000,1319500,0.35},1,TRUE))","v":1485231.05},{"$f":"VLOOKUP(F16,{0,0,0;400000,0,0.07;500000,7000,0.1;750000,32000,0.15;15000000,144500,0.2;25000000,344500,0.25;40000000,719400,0.3;60000000,1319500,0.35},2,TRUE)+VLOOKUP(F16,{0,0,0;400000,0,0.07;500000,7000,0.1;750000,32000,0.15;15000000,144500,0.2;25000000,344500,0.25;40000000,719400,0.3;60000000,1319500,0.35},3,TRUE)*(F16-VLOOKUP(F16,{0,0,0;400000,0,0.07;500000,7000,0.1;750000,32000,0.15;15000000,144500,0.2;25000000,344500,0.25;40000000,719400,0.3;60000000,1319500,0.35},1,TRUE))","v":2119481.6},{"$f":"VLOOKUP(G16,{0,0,0;400000,0,0.07;500000,7000,0.1;750000,32000,0.15;15000000,144500,0.2;25000000,344500,0.25;40000000,719400,0.3;60000000,1319500,0.35},2,TRUE)+VLOOKUP(G16,{0,0,0;400000,0,0.07;500000,7000,0.1;750000,32000,0.15;15000000,144500,0.2;25000000,344500,0.25;40000000,719400,0.3;60000000,1319500,0.35},3,TRUE)*(G16-VLOOKUP(G16,{0,0,0;400000,0,0.07;500000,7000,0.1;750000,32000,0.15;15000000,144500,0.2;25000000,344500,0.25;40000000,719400,0.3;60000000,1319500,0.35},1,TRUE))","v":1185656.5},{"$f":"VLOOKUP(H16,{0,0,0;400000,0,0.07;500000,7000,0.1;750000,32000,0.15;15000000,144500,0.2;25000000,344500,0.25;40000000,719400,0.3;60000000,1319500,0.35},2,TRUE)+VLOOKUP(H16,{0,0,0;400000,0,0.07;500000,7000,0.1;750000,32000,0.15;15000000,144500,0.2;25000000,344500,0.25;40000000,719400,0.3;60000000,1319500,0.35},3,TRUE)*(H16-VLOOKUP(H16,{0,0,0;400000,0,0.07;500000,7000,0.1;750000,32000,0.15;15000000,144500,0.2;25000000,344500,0.25;40000000,719400,0.3;60000000,1319500,0.35},1,TRUE))","v":4537271.4000000004},{"$f":"VLOOKUP(I16,{0,0,0;400000,0,0.07;500000,7000,0.1;750000,32000,0.15;15000000,144500,0.2;25000000,344500,0.25;40000000,719400,0.3;60000000,1319500,0.35},2,TRUE)+VLOOKUP(I16,{0,0,0;400000,0,0.07;500000,7000,0.1;750000,32000,0.15;15000000,144500,0.2;25000000,344500,0.25;40000000,719400,0.3;60000000,1319500,0.35},3,TRUE)*(I16-VLOOKUP(I16,{0,0,0;400000,0,0.07;500000,7000,0.1;750000,32000,0.15;15000000,144500,0.2;25000000,344500,0.25;40000000,719400,0.3;60000000,1319500,0.35},1,TRUE))","v":3571325.0999999996},{"$f":"VLOOKUP(J16,{0,0,0;400000,0,0.07;500000,7000,0.1;750000,32000,0.15;15000000,144500,0.2;25000000,344500,0.25;40000000,719400,0.3;60000000,1319500,0.35},2,TRUE)+VLOOKUP(J16,{0,0,0;400000,0,0.07;500000,7000,0.1;750000,32000,0.15;15000000,144500,0.2;25000000,344500,0.25;40000000,719400,0.3;60000000,1319500,0.35},3,TRUE)*(J16-VLOOKUP(J16,{0,0,0;400000,0,0.07;500000,7000,0.1;750000,32000,0.15;15000000,144500,0.2;25000000,344500,0.25;40000000,719400,0.3;60000000,1319500,0.35},1,TRUE))","v":0},{"$f":"VLOOKUP(K16,{0,0,0;400000,0,0.07;500000,7000,0.1;750000,32000,0.15;15000000,144500,0.2;25000000,344500,0.25;40000000,719400,0.3;60000000,1319500,0.35},2,TRUE)+VLOOKUP(K16,{0,0,0;400000,0,0.07;500000,7000,0.1;750000,32000,0.15;15000000,144500,0.2;25000000,344500,0.25;40000000,719400,0.3;60000000,1319500,0.35},3,TRUE)*(K16-VLOOKUP(K16,{0,0,0;400000,0,0.07;500000,7000,0.1;750000,32000,0.15;15000000,144500,0.2;25000000,344500,0.25;40000000,719400,0.3;60000000,1319500,0.35},1,TRUE))","v":544.32000000000005},{"$f":"VLOOKUP(L16,{0,0,0;400000,0,0.07;500000,7000,0.1;750000,32000,0.15;15000000,144500,0.2;25000000,344500,0.25;40000000,719400,0.3;60000000,1319500,0.35},2,TRUE)+VLOOKUP(L16,{0,0,0;400000,0,0.07;500000,7000,0.1;750000,32000,0.15;15000000,144500,0.2;25000000,344500,0.25;40000000,719400,0.3;60000000,1319500,0.35},3,TRUE)*(L16-VLOOKUP(L16,{0,0,0;400000,0,0.07;500000,7000,0.1;750000,32000,0.15;15000000,144500,0.2;25000000,344500,0.25;40000000,719400,0.3;60000000,1319500,0.35},1,TRUE))","v":7234.8},{"$f":"VLOOKUP(M16,{0,0,0;400000,0,0.07;500000,7000,0.1;750000,32000,0.15;15000000,144500,0.2;25000000,344500,0.25;40000000,719400,0.3;60000000,1319500,0.35},2,TRUE)+VLOOKUP(M16,{0,0,0;400000,0,0.07;500000,7000,0.1;750000,32000,0.15;15000000,144500,0.2;25000000,344500,0.25;40000000,719400,0.3;60000000,1319500,0.35},3,TRUE)*(M16-VLOOKUP(M16,{0,0,0;400000,0,0.07;500000,7000,0.1;750000,32000,0.15;15000000,144500,0.2;25000000,344500,0.25;40000000,719400,0.3;60000000,1319500,0.35},1,TRUE))","v":1631130.2}]
[]
["Check"]
["Base",{"$f":"VLOOKUP(B$16,$B$31:$D$38,2,TRUE)","v":0},0,7000,32000,144500,344500,719400,1319500,0,0,7000,32000,{"$f":"_xlfn.FORMULATEXT(M21)","v":"=VLOOKUP(M$16,$B$31:$D$38,2,TRUE)"}]
["Plus",{"$f":"VLOOKUP(B$16,$B$31:$D$38,3,TRUE)","v":0},7.0000000000000007E-2,0.1,0.15,0.2,0.25,0.3,0.35,0,7.0000000000000007E-2,0.1,0.15,{"$f":"_xlfn.FORMULATEXT(M22)","v":"=VLOOKUP(M$16,$B$31:$D$38,3,TRUE)"}]
["of amt over",{"$f":"VLOOKUP(B$16,$B$31:$D$38,1,TRUE)","v":0},400000,500000,750000,15000000,25000000,40000000,60000000,0,400000,500000,750000,"=VLOOKUP(M$16,$B$31:$D$38,1,TRUE)"]
["Amt over",{"$f":"B16-B23","v":249531},16846,111054,9688207,9874908,3364626,12726238,6433786,67810,7776,2348,10660868,"=M16-M23"]
["Plus",{"$f":"B24*B22","v":0},1179.22,11105.400000000001,1453231.05,1974981.6,841156.5,3817871.4,2251825.0999999996,0,544.32000000000005,234.8,1599130.2,"=M24*M22"]
["Tax",{"$f":"B21+B25","v":0},1179.22,18105.400000000001,1485231.05,2119481.6,1185656.5,4537271.4000000004,3571325.0999999996,0,544.32000000000005,7234.8,1631130.2,"=M21+M25"]
[]
["Check",{"$f":"B26=B17","v":true},{"$f":"C26=C17","v":true},true,true,true,true,true,true,true,true,true,true]
[]
[null,"Amount","Base","+ % over"]
[null,0,0,0]
[null,400000,0,7.0000000000000007E-2]
[null,500000,7000,0.1]
[null,750000,32000,0.15]
[null,15000000,144500,0.2]
[null,25000000,344500,0.25]
[null,40000000,719400,0.3]
[null,60000000,1319500,0.35]

{"sheet":"Done","index":3,"n_rows":38,"n_cols":13,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
["Income Statement"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"]
["Income",249531,416846,611054,10438207,24874908,28364626,52726238,66433786,67810,407776,502348,11410868]
["Tax",{"$f":"VLOOKUP(B16,$B$31:$D$38,2,TRUE)+VLOOKUP(B16,$B$31:$D$38,3,TRUE)*(B16-VLOOKUP(B16,$B$31:$D$38,1,TRUE))","v":0},1179.22,18105.400000000001,1485231.05,2119481.6,1185656.5,4537271.4000000004,3571325.0999999996,0,544.32000000000005,7234.8,1631130.2]
["One Formula",{"$f":"VLOOKUP(B16,{0,0,0;400000,0,0.07;500000,7000,0.1;750000,32000,0.15;15000000,144500,0.2;25000000,344500,0.25;40000000,719400,0.3;60000000,1319500,0.35},2,TRUE)+VLOOKUP(B16,{0,0,0;400000,0,0.07;500000,7000,0.1;750000,32000,0.15;15000000,144500,0.2;25000000,344500,0.25;40000000,719400,0.3;60000000,1319500,0.35},3,TRUE)*(B16-VLOOKUP(B16,{0,0,0;400000,0,0.07;500000,7000,0.1;750000,32000,0.15;15000000,144500,0.2;25000000,344500,0.25;40000000,719400,0.3;60000000,1319500,0.35},1,TRUE))","v":0},{"$f":"VLOOKUP(C16,{0,0,0;400000,0,0.07;500000,7000,0.1;750000,32000,0.15;15000000,144500,0.2;25000000,344500,0.25;40000000,719400,0.3;60000000,1319500,0.35},2,TRUE)+VLOOKUP(C16,{0,0,0;400000,0,0.07;500000,7000,0.1;750000,32000,0.15;15000000,144500,0.2;25000000,344500,0.25;40000000,719400,0.3;60000000,1319500,0.35},3,TRUE)*(C16-VLOOKUP(C16,{0,0,0;400000,0,0.07;500000,7000,0.1;750000,32000,0.15;15000000,144500,0.2;25000000,344500,0.25;40000000,719400,0.3;60000000,1319500,0.35},1,TRUE))","v":1179.22},{"$f":"VLOOKUP(D16,{0,0,0;400000,0,0.07;500000,7000,0.1;750000,32000,0.15;15000000,144500,0.2;25000000,344500,0.25;40000000,719400,0.3;60000000,1319500,0.35},2,TRUE)+VLOOKUP(D16,{0,0,0;400000,0,0.07;500000,7000,0.1;750000,32000,0.15;15000000,144500,0.2;25000000,344500,0.25;40000000,719400,0.3;60000000,1319500,0.35},3,TRUE)*(D16-VLOOKUP(D16,{0,0,0;400000,0,0.07;500000,7000,0.1;750000,32000,0.15;15000000,144500,0.2;25000000,344500,0.25;40000000,719400,0.3;60000000,1319500,0.35},1,TRUE))","v":18105.400000000001},{"$f":"VLOOKUP(E16,{0,0,0;400000,0,0.07;500000,7000,0.1;750000,32000,0.15;15000000,144500,0.2;25000000,344500,0.25;40000000,719400,0.3;60000000,1319500,0.35},2,TRUE)+VLOOKUP(E16,{0,0,0;400000,0,0.07;500000,7000,0.1;750000,32000,0.15;15000000,144500,0.2;25000000,344500,0.25;40000000,719400,0.3;60000000,1319500,0.35},3,TRUE)*(E16-VLOOKUP(E16,{0,0,0;400000,0,0.07;500000,7000,0.1;750000,32000,0.15;15000000,144500,0.2;25000000,344500,0.25;40000000,719400,0.3;60000000,1319500,0.35},1,TRUE))","v":1485231.05},{"$f":"VLOOKUP(F16,{0,0,0;400000,0,0.07;500000,7000,0.1;750000,32000,0.15;15000000,144500,0.2;25000000,344500,0.25;40000000,719400,0.3;60000000,1319500,0.35},2,TRUE)+VLOOKUP(F16,{0,0,0;400000,0,0.07;500000,7000,0.1;750000,32000,0.15;15000000,144500,0.2;25000000,344500,0.25;40000000,719400,0.3;60000000,1319500,0.35},3,TRUE)*(F16-VLOOKUP(F16,{0,0,0;400000,0,0.07;500000,7000,0.1;750000,32000,0.15;15000000,144500,0.2;25000000,344500,0.25;40000000,719400,0.3;60000000,1319500,0.35},1,TRUE))","v":2119481.6},{"$f":"VLOOKUP(G16,{0,0,0;400000,0,0.07;500000,7000,0.1;750000,32000,0.15;15000000,144500,0.2;25000000,344500,0.25;40000000,719400,0.3;60000000,1319500,0.35},2,TRUE)+VLOOKUP(G16,{0,0,0;400000,0,0.07;500000,7000,0.1;750000,32000,0.15;15000000,144500,0.2;25000000,344500,0.25;40000000,719400,0.3;60000000,1319500,0.35},3,TRUE)*(G16-VLOOKUP(G16,{0,0,0;400000,0,0.07;500000,7000,0.1;750000,32000,0.15;15000000,144500,0.2;25000000,344500,0.25;40000000,719400,0.3;60000000,1319500,0.35},1,TRUE))","v":1185656.5},{"$f":"VLOOKUP(H16,{0,0,0;400000,0,0.07;500000,7000,0.1;750000,32000,0.15;15000000,144500,0.2;25000000,344500,0.25;40000000,719400,0.3;60000000,1319500,0.35},2,TRUE)+VLOOKUP(H16,{0,0,0;400000,0,0.07;500000,7000,0.1;750000,32000,0.15;15000000,144500,0.2;25000000,344500,0.25;40000000,719400,0.3;60000000,1319500,0.35},3,TRUE)*(H16-VLOOKUP(H16,{0,0,0;400000,0,0.07;500000,7000,0.1;750000,32000,0.15;15000000,144500,0.2;25000000,344500,0.25;40000000,719400,0.3;60000000,1319500,0.35},1,TRUE))","v":4537271.4000000004},{"$f":"VLOOKUP(I16,{0,0,0;400000,0,0.07;500000,7000,0.1;750000,32000,0.15;15000000,144500,0.2;25000000,344500,0.25;40000000,719400,0.3;60000000,1319500,0.35},2,TRUE)+VLOOKUP(I16,{0,0,0;400000,0,0.07;500000,7000,0.1;750000,32000,0.15;15000000,144500,0.2;25000000,344500,0.25;40000000,719400,0.3;60000000,1319500,0.35},3,TRUE)*(I16-VLOOKUP(I16,{0,0,0;400000,0,0.07;500000,7000,0.1;750000,32000,0.15;15000000,144500,0.2;25000000,344500,0.25;40000000,719400,0.3;60000000,1319500,0.35},1,TRUE))","v":3571325.0999999996},{"$f":"VLOOKUP(J16,{0,0,0;400000,0,0.07;500000,7000,0.1;750000,32000,0.15;15000000,144500,0.2;25000000,344500,0.25;40000000,719400,0.3;60000000,1319500,0.35},2,TRUE)+VLOOKUP(J16,{0,0,0;400000,0,0.07;500000,7000,0.1;750000,32000,0.15;15000000,144500,0.2;25000000,344500,0.25;40000000,719400,0.3;60000000,1319500,0.35},3,TRUE)*(J16-VLOOKUP(J16,{0,0,0;400000,0,0.07;500000,7000,0.1;750000,32000,0.15;15000000,144500,0.2;25000000,344500,0.25;40000000,719400,0.3;60000000,1319500,0.35},1,TRUE))","v":0},{"$f":"VLOOKUP(K16,{0,0,0;400000,0,0.07;500000,7000,0.1;750000,32000,0.15;15000000,144500,0.2;25000000,344500,0.25;40000000,719400,0.3;60000000,1319500,0.35},2,TRUE)+VLOOKUP(K16,{0,0,0;400000,0,0.07;500000,7000,0.1;750000,32000,0.15;15000000,144500,0.2;25000000,344500,0.25;40000000,719400,0.3;60000000,1319500,0.35},3,TRUE)*(K16-VLOOKUP(K16,{0,0,0;400000,0,0.07;500000,7000,0.1;750000,32000,0.15;15000000,144500,0.2;25000000,344500,0.25;40000000,719400,0.3;60000000,1319500,0.35},1,TRUE))","v":544.32000000000005},{"$f":"VLOOKUP(L16,{0,0,0;400000,0,0.07;500000,7000,0.1;750000,32000,0.15;15000000,144500,0.2;25000000,344500,0.25;40000000,719400,0.3;60000000,1319500,0.35},2,TRUE)+VLOOKUP(L16,{0,0,0;400000,0,0.07;500000,7000,0.1;750000,32000,0.15;15000000,144500,0.2;25000000,344500,0.25;40000000,719400,0.3;60000000,1319500,0.35},3,TRUE)*(L16-VLOOKUP(L16,{0,0,0;400000,0,0.07;500000,7000,0.1;750000,32000,0.15;15000000,144500,0.2;25000000,344500,0.25;40000000,719400,0.3;60000000,1319500,0.35},1,TRUE))","v":7234.8},{"$f":"VLOOKUP(M16,{0,0,0;400000,0,0.07;500000,7000,0.1;750000,32000,0.15;15000000,144500,0.2;25000000,344500,0.25;40000000,719400,0.3;60000000,1319500,0.35},2,TRUE)+VLOOKUP(M16,{0,0,0;400000,0,0.07;500000,7000,0.1;750000,32000,0.15;15000000,144500,0.2;25000000,344500,0.25;40000000,719400,0.3;60000000,1319500,0.35},3,TRUE)*(M16-VLOOKUP(M16,{0,0,0;400000,0,0.07;500000,7000,0.1;750000,32000,0.15;15000000,144500,0.2;25000000,344500,0.25;40000000,719400,0.3;60000000,1319500,0.35},1,TRUE))","v":1631130.2}]
[]
["Check"]
["Base",{"$f":"VLOOKUP(B$16,$B$31:$D$38,2,TRUE)","v":0},0,7000,32000,144500,344500,719400,1319500,0,0,7000,32000]
["Plus",{"$f":"VLOOKUP(B$16,$B$31:$D$38,3,TRUE)","v":0},7.0000000000000007E-2,0.1,0.15,0.2,0.25,0.3,0.35,0,7.0000000000000007E-2,0.1,0.15]
["of amt over",{"$f":"VLOOKUP(B$16,$B$31:$D$38,1,TRUE)","v":0},400000,500000,750000,15000000,25000000,40000000,60000000,0,400000,500000,750000]
["Amt over",{"$f":"+B16-B23","v":249531},16846,111054,9688207,9874908,3364626,12726238,6433786,67810,7776,2348,10660868]
["Plus",{"$f":"+B24*B22","v":0},{"$f":"+C24*C22","v":1179.22},11105.400000000001,1453231.05,1974981.6,841156.5,3817871.4,2251825.0999999996,0,544.32000000000005,234.8,1599130.2]
["Tax",{"$f":"+B21+B25","v":0},{"$f":"+C21+C25","v":1179.22},18105.400000000001,1485231.05,2119481.6,1185656.5,4537271.4000000004,3571325.0999999996,0,544.32000000000005,7234.8,1631130.2]
[]
["Check",{"$f":"B26=B17","v":true},true,true,true,true,true,true,true,true,true,true,true]
[]
[null,"Amount","Base","+ % over"]
[null,0,0,0]
[null,400000,0,7.0000000000000007E-2]
[null,500000,7000,0.1]
[null,750000,32000,0.15]
[null,15000000,144500,0.2]
[null,25000000,344500,0.25]
[null,40000000,719400,0.3]
[null,60000000,1319500,0.35]

{"sheet":"Wrap Up","index":4,"n_rows":8,"n_cols":2,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Topics in this Episode"]
[]
[null,"Formula to calculate a progressive tax rate"]
[null,"Set up a table in ascending order with the amounts from your income tax card"]
[null,"You will do three Approximate Match VLOOKUPS to get the base tax, the percentage and the start of the level"]
[null,"Subtract the Start Level from the income for the period. Multiply by the percentage."]
[null,"Used Ctrl+' to copy a formula down one cell without changing the references"]
[null,"Using the F9 trick from Mike Girvin to embed the lookup tables in the formula."]

{"sheet":"Seminars","index":5,"n_rows":22,"n_cols":7,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"http://www.mrexcel.com/pressappearances.shtml"]