{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Question","Try","MrExcel","Excelisfun","Sheet4"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":5,"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":"Question","index":0,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Days","Amount"]
[41]
[7]
[14]
[50]
[3]
[15]
[0]
[8]

{"sheet":"Try","index":1,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Days","Amount"]
[41]
[7]
[14]
[50]
[3]
[15]
[0]
[8]

{"sheet":"MrExcel","index":2,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Days","Amount"]
[41,{"$f":"rent(A2)","v":575}]
[7,35]
[14,105]
[50,755]
[3,15]
[15,115]
[0,0]
[8,45]

{"sheet":"Excelisfun","index":3,"n_rows":23,"n_cols":10,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["Days","Rent VBA","Rent IF","Rent VLOOKUP","Bill Szysz Formula:"]
[41,{"$f":"rent(A2)","v":575},{"$f":"IF(A2<8,A2*5,IF(A2<22,35+(A2-7)*10,175+(A2-21)*20))","v":575},{"$f":"VLOOKUP(A2,$B$12:$F$14,5)+(A2-VLOOKUP(A2,$B$12:$F$14,4))*VLOOKUP(A2,$B$12:$F$14,3)","v":575},{"$f":"LOOKUP(2,1/(A2>$E$12:$E$14),(A2-$E$12:$E$14)*$D$12:$D$14+$F$12:$F$14)","v":575}]
[7,35,{"$f":"IF(A3<8,A3*5,IF(A3<22,35+(A3-7)*10,175+(A3-21)*20))","v":35},{"$f":"VLOOKUP(A3,$B$12:$F$14,5)+(A3-VLOOKUP(A3,$B$12:$F$14,4))*VLOOKUP(A3,$B$12:$F$14,3)","v":35},{"$f":"LOOKUP(2,1/(A3>$E$12:$E$14),(A3-$E$12:$E$14)*$D$12:$D$14+$F$12:$F$14)","v":35},"175+(41-21)*20"]
[14,105,105,105,105,"V5+(cell-V4)*V3"]
[50,755,755,755,755]
[3,15,15,15,15]
[15,115,115,115,115]
[0,0,0,0,{"$error":"#N/A"}]
[8,45,45,45,45]
[]
[null,"Lower","Upper","$ Amount","Number Made Through Previous Category","Cumulative Rent Through Previous Categories"]
[null,0,7,5,0,null,null,null,"Time:"]
[null,8,21,10,{"$f":"C12","v":7},{"$f":"C12*D12","v":35},null,null,"Array","4 lookup"]
[null,22,null,20,{"$f":"C13","v":21},{"$f":"(B14-B13)*D13+F13","v":175},null,null,2.4599999999999999E-3,2.3999999999999998E-3]
[null,null,null,null,null,null,null,null,2.5000000000000001E-3,2.4599999999999999E-3]
[null,null,null,null,null,null,null,null,2.5100000000000001E-3,2.4499999999999999E-3]
[]
[]
["Excel Magic Trick 825: Variable Rate Tables: Commission, Piecework & Tax Examples "]
["https://www.youtube.com/watch?v=lNiXtfJ6pJw"]
[]
["Excel Magic Trick 453: VLOOKUP for Commission Brackets Calculation (LOOKUP function also) "]
["https://www.youtube.com/watch?v=fvSnFEsn_NI"]

{"sheet":"Sheet4","index":4,"n_rows":22,"n_cols":8,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["Days","Amount"]
[41,{"$f":"SUMPRODUCT(CHOOSE({1,2,3},IF(A2<8,A2,7),IF(AND(A2>7,A2<15),A2-7,IF(A2>14,14,0)),IF(A2>21,A2-21,IF(AND(A2>14,A2<22),A2-7,0))),{5,10,20})","v":575},{"$f":"IF(A2<8,A2*5,IF(AND(A2>7,A2<22),35+(A2-7)*10,175+(A2-21)*20))","v":575}]
[7,{"$f":"SUMPRODUCT(CHOOSE({1,2,3},IF(A3<8,A3,7),IF(AND(A3>7,A3<15),A3-7,IF(A3>14,14,0)),IF(A3>21,A3-21,IF(AND(A3>14,A3<22),A3-7,0))),{5,10,20})","v":35},{"$f":"IF(A3<8,A3*5,IF(AND(A3>7,A3<22),35+(A3-7)*10,175+(A3-21)*20))","v":35}]
[14,{"$f":"SUMPRODUCT(CHOOSE({1,2,3},IF(A4<8,A4,7),IF(AND(A4>7,A4<15),A4-7,IF(A4>14,14,0)),IF(A4>21,A4-21,IF(AND(A4>14,A4<22),A4-7,0))),{5,10,20})","v":105},105]
[50,{"$f":"SUMPRODUCT(CHOOSE({1,2,3},IF(A5<8,A5,7),IF(AND(A5>7,A5<15),A5-7,IF(A5>14,14,0)),IF(A5>21,A5-21,IF(AND(A5>14,A5<22),A5-7,0))),{5,10,20})","v":755},755]
[3,{"$f":"SUMPRODUCT(CHOOSE({1,2,3},IF(A6<8,A6,7),IF(AND(A6>7,A6<15),A6-7,IF(A6>14,14,0)),IF(A6>21,A6-21,IF(AND(A6>14,A6<22),A6-7,0))),{5,10,20})","v":15},15]
[15,{"$f":"SUMPRODUCT(CHOOSE({1,2,3},IF(A7<8,A7,7),IF(AND(A7>7,A7<15),A7-7,IF(A7>14,14,0)),IF(A7>21,A7-21,IF(AND(A7>14,A7<22),A7-7,0))),{5,10,20})","v":335},115,{"$f":"7*5+14*10+1*20","v":195}]
[0,{"$f":"SUMPRODUCT(CHOOSE({1,2,3},IF(A8<8,A8,7),IF(AND(A8>7,A8<15),A8-7,IF(A8>14,14,0)),IF(A8>21,A8-21,IF(AND(A8>14,A8<22),A8-7,0))),{5,10,20})","v":0},0]
[15,{"$f":"SUMPRODUCT(CHOOSE({1,2,3},IF(A9<8,A9,7),IF(AND(A9>7,A9<15),A9-7,IF(A9>14,14,0)),IF(A9>21,A9-21,IF(AND(A9>14,A9<22),A9-7,0))),{5,10,20})","v":335},115]
[null,{"$f":"SUMPRODUCT(CHOOSE({1,2,3},IF(A10<8,A10,7),IF(AND(A10>7,A10<15),A10-7,IF(A10>14,14,0)),IF(A10>21,A10-21,IF(AND(A10>14,A10<22),A10-7,0))),{5,10,20})","v":0},0]
[null,{"$f":"SUMPRODUCT(CHOOSE({1,2,3},IF(A11<8,A11,7),IF(AND(A11>7,A11<15),A11-7,IF(A11>14,14,0)),IF(A11>21,A11-21,IF(AND(A11>14,A11<22),A11-7,0))),{5,10,20})","v":0},0]
[8,{"$f":"SUMPRODUCT(CHOOSE({1,2,3},IF(A12<8,A12,7),IF(AND(A12>7,A12<15),A12-7,IF(A12>14,14,0)),IF(A12>21,A12-21,IF(AND(A12>14,A12<22),A12-7,0))),{5,10,20})","v":45},{"$f":"IF(A12<8,A12*5,IF(AND(A12>7,A12<22),35+(A12-7)*10,175+(A12-21)*20))","v":45}]
[]
[]
[]
[]
[]
[]
[null,"Days",0,5,null,7]
[null,"Days",8,10,null,14]
[null,"Days",15,20,null,20,null,{"$f":"SUMPRODUCT(D19:D21,F19:F21)","v":575}]
[null,null,null,null,null,{"$f":"SUM(F19:F21)","v":41}]