{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sheet2","Sheet2 (2)","Sheet1"],"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":"Sheet2","index":0,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,4],[13,2,13,3],[14,2,14,3]]}
[]
[null,"Calculating Sales Bonus"]
[]
[null,"Sales Person","Sales Target (Units)","Sales Achieved","Bonus"]
[null,"Mike",0,55,{"$f":"IFERROR(IF(D5>=C5,$C$15*(D5-C5)/C5,\"Not Applicable\"),\"Sales Target is not Correctly inserted\")","v":"Sales Target is not Correctly inserted"}]
[null,"Teresa",60,45,{"$f":"IFERROR(IF(D6>=C6,$C$15*(D6-C6)/C6,\"Not Applicable\"),\"Sales Target is not Correctly inserted\")","v":"Not Applicable"}]
[null,"Nicolas",40,45,62.5]
[null,"Abigaile",55,60,45.454545454545453]
[null,"Martin",0,50,"Sales Target is not Correctly inserted"]
[null,"Cris",60,50,"Not Applicable"]
[null,"Sarah",70,80,71.428571428571431]
[null,"Dalton",80,75,"Not Applicable"]
[]
[null,null,"Salary of Each Sales Person"]
[null,null,500]

{"sheet":"Sheet2 (2)","index":1,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Determining Achieved Sales"]
[]
[null,"Sales Person","Target Sales ","Achieved Sales"]
[null,"Mike",22000,{"$f":"IFERROR(IF(C5<32500,C5*16%,IF(C5<73500,C5*26%,C5*29%)),0)","v":3520}]
[null,"Teresa",56000,{"$f":"IFERROR(IF(C6<32500,C6*16%,IF(C6<73500,C6*26%,C6*29%)),0)","v":14560}]
[null,"Nicolas",40000,10400]
[null,"Abigaile",10000,1600]
[null,"Martin",12000,1920]
[null,"Cris",5600,896]
[null,"Sarah",67000,17420]
[null,"Dalton",800000,231999.99999999997]

{"sheet":"Sheet1","index":2,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Tracking Project Progress "]
[]
[null," Person"," Target (Units)"," Achieved","Progress"]
[null,"Mike",0,55,{"$f":"IFERROR(IF(D5>=C5,(D5-C5)/C5,\"Completed\"),\"Incorrected value\")","v":"Incorrected value"}]
[null,"Teresa",60,45,{"$f":"IFERROR(IF(D6>=C6,(D6-C6)/C6,\"Completed\"),\"Incorrected value\")","v":"Completed"}]
[null,"Nicolas",40,45,0.125]
[null,"Abigaile",55,60,9.0909090909090912E-2]
[null,"Martin",0,50,"Incorrected value"]
[null,"Cris",51,50,"Completed"]
[null,"Sarah",70,80,0.14285714285714285]
[null,"Dalton",80,75,"Completed"]