{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Dataset","IF (True)","IF (False)","MAX","Boolean","VLOOKUP","VBA"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Dataset","index":0,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Daily Sales List"]
[]
[null,"Sales Hurdle",15000]
[null,"Bonus Percentage",0.1]
[]
[null,"Sales Rep","Daily Sales"]
[null,"Jonas",12650]
[null,"Harry",16500]
[null,"Nick",18200]
[null,"Sara",15800]
[null,"John",14550]
[null,"Leon",13750]
[null,"Tom",15300]

{"sheet":"IF (True)","index":1,"n_rows":14,"n_cols":12,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3],[4,9,4,11]]}
[]
[null,"Using IF Function (True Value)"]
[]
[null,"Sales Hurdle",15000]
[null,"Bonus Percentage",0.1,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Sales Rep","Daily Sales","Bonus",null,null,null,null,null,"Sales Rep","Daily Sales","Bonus"]
[null,"Jonas",12650,{"$f":"IF(C8>$C$4,(C8-$C$4)*$C$5,0)","v":0},null,null,null,null,null,"Jonas",12650]
[null,"Harry",16500,{"$f":"IF(C9>$C$4,(C9-$C$4)*$C$5,0)","v":150},null,null,null,null,null,"Harry",16500]
[null,"Nick",18200,320,null,null,null,null,null,"Nick",18200]
[null,"Sara",15800,80,null,null,null,null,null,"Sara",15800]
[null,"John",14550,0,null,null,null,null,null,"John",14550]
[null,"Leon",13750,0,null,null,null,null,null,"Leon",13750]
[null,"Tom",15300,30,null,null,null,null,null,"Tom",15300]

{"sheet":"IF (False)","index":2,"n_rows":14,"n_cols":12,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3],[4,9,4,11]]}
[]
[null,"Using IF Function (False Value)"]
[]
[null,"Sales Hurdle",15000]
[null,"Bonus Percentage",0.1,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Sales Rep","Daily Sales","Bonus",null,null,null,null,null,"Sales Rep","Daily Sales","Bonus"]
[null,"Jonas",12650,{"$f":"IF(C8<$C$4,0,(C8-$C$4)*$C$5)","v":0},null,null,null,null,null,"Jonas",12650]
[null,"Harry",16500,{"$f":"IF(C9<$C$4,0,(C9-$C$4)*$C$5)","v":150},null,null,null,null,null,"Harry",16500]
[null,"Nick",18200,320,null,null,null,null,null,"Nick",18200]
[null,"Sara",15800,80,null,null,null,null,null,"Sara",15800]
[null,"John",14550,0,null,null,null,null,null,"John",14550]
[null,"Leon",13750,0,null,null,null,null,null,"Leon",13750]
[null,"Tom",15300,30,null,null,null,null,null,"Tom",15300]

{"sheet":"MAX","index":3,"n_rows":14,"n_cols":12,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3],[4,9,4,11]]}
[]
[null,"Applying MAX Function"]
[]
[null,"Sales Hurdle",15000]
[null,"Bonus Percentage",0.1,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Sales Rep","Daily Sales","Bonus",null,null,null,null,null,"Sales Rep","Daily Sales","Bonus"]
[null,"Jonas",12650,{"$f":"MAX((C8-$C$4)*$C$5,0)","v":0},null,null,null,null,null,"Jonas",12650]
[null,"Harry",16500,{"$f":"MAX((C9-$C$4)*$C$5,0)","v":150},null,null,null,null,null,"Harry",16500]
[null,"Nick",18200,320,null,null,null,null,null,"Nick",18200]
[null,"Sara",15800,80,null,null,null,null,null,"Sara",15800]
[null,"John",14550,0,null,null,null,null,null,"John",14550]
[null,"Leon",13750,0,null,null,null,null,null,"Leon",13750]
[null,"Tom",15300,30,null,null,null,null,null,"Tom",15300]

{"sheet":"Boolean","index":4,"n_rows":14,"n_cols":12,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3],[4,9,4,11]]}
[]
[null,"Engaging Boolean Logic"]
[]
[null,"Sales Hurdle",15000]
[null,"Bonus Percentage",0.1,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Sales Rep","Daily Sales","Bonus",null,null,null,null,null,"Sales Rep","Daily Sales","Bonus"]
[null,"Jonas",12650,{"$f":"(C8-$C$4)*$C$5*(C8>=$C$4)","v":0},null,null,null,null,null,"Jonas",12650]
[null,"Harry",16500,{"$f":"(C9-$C$4)*$C$5*(C9>=$C$4)","v":150},null,null,null,null,null,"Harry",16500]
[null,"Nick",18200,320,null,null,null,null,null,"Nick",18200]
[null,"Sara",15800,80,null,null,null,null,null,"Sara",15800]
[null,"John",14550,0,null,null,null,null,null,"John",14550]
[null,"Leon",13750,0,null,null,null,null,null,"Leon",13750]
[null,"Tom",15300,30,null,null,null,null,null,"Tom",15300]

{"sheet":"VLOOKUP","index":5,"n_rows":16,"n_cols":12,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,3],[6,9,6,11]]}
[]
[null,"Implementing VLOOKUP Function"]
[]
[null,"Achieved Sales","Bonus Percentage"]
[null,0,0]
[null,10000,0.05]
[null,15000,0.1,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Sales Rep","Daily Sales","Bonus",null,null,null,null,null,"Sales Rep","Daily Sales","Bonus"]
[null,"Jonas",12650,{"$f":"VLOOKUP(C10,$B$5:$C$7,2)*(C10-$B$6)","v":132.5},null,null,null,null,null,"Jonas",12650]
[null,"Harry",16500,650,null,null,null,null,null,"Harry",16500]
[null,"Nick",9800,0,null,null,null,null,null,"Nick",9800]
[null,"Sara",15800,580,null,null,null,null,null,"Sara",15800]
[null,"John",14550,227.5,null,null,null,null,null,"John",14550]
[null,"Leon",7500,0,null,null,null,null,null,"Leon",7500]
[null,"Tom",15300,530,null,null,null,null,null,"Tom",15300]

{"sheet":"VBA","index":6,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Employing VBA Code"]
[]
[null,"Sales Hurdle",15000]
[null,"Bonus Percentage",0.1]
[]
[null,"Sales Rep","Daily Sales","Bonus"]
[null,"Jonas",12650,{"$f":"IF(C8>=$C$4,(C8-$C$4)*0.1,0)","v":0}]
[null,"Harry",16500,150]
[null,"Nick",18200,320]
[null,"Sara",15800,80]
[null,"John",14550,0]
[null,"Leon",13750,0]
[null,"Tom",15300,30]