Spreadsheet: 275455d1383522253-looking-up-a-name-in-another-sheet-and-displaying-a-value-under-it-kpicalculatorver2
Sheet: Boosters

2013-10-27 00:00:00 | 10:34AM
Boost Juice - Cockburn Gateways (F235)
Sales by Staff Member [category]
From 21/10/13- 8:00AM to 25/10/13- 9:00PM
Location | Area | Staff | Category | Item | Price | Qty | Net Sales | GST | Gross Sales | Net Sales %
Boost Gateways
 | <Consolidated>
 |  | Blessing
 |  |  | Boosters
 |  |  |  | $1 Power Pack | 0 | 5 | 0 | 0 | 0 | 0
 |  |  |  | c  [NAME] | 0.6 | 3 | 1.6363635 | 0.1636365 | 1.8 | 0.0084106
 |  |  |  | c  Energiser Booster | 0.6 | 3 | 1.6363635 | 0.1636365 | 1.8 | 0.0084106
 |  |  |  | c  Immunity Booster | 0.6 | 2 | 1.090909 | 0.109091 | 1.2 | 0.0056071
 |  |  |  | c  [NAME] | 0.6 | 5 | 2.7272725 | 0.2727275 | 3 | 0.0140177
 |  |  |  | c  [NAME] | 0.6 | 1 | 0.5454545 | 0.0545455 | 0.6 | 0.0028035
 |  |  |  |  | Category Total: | 19 | 7.636363 | 0.763637 | 8.4 | 0.0392496
 |  |  |  |  | Staff Total: | 19 | 7.636363 | 0.763637 | 8.4 | 0.0392496
 |  | Brittany
 |  |  | Boosters
 |  |  |  | $1 Power Pack | 0 | 4 | 0 | 0 | 0 | 0
 |  |  |  | [NAME] | 0.6 | 1 | 0.5454545 | 0.0545455 | 0.6 | 0.0028035
 |  |  |  | c  [NAME] | 0.6 | 1 | 0.5454545 | 0.0545455 | 0.6 | 0.0028035
 |  |  |  | c  Energiser Booster | 0.6 | 6 | 3.272727 | 0.327273 | 3.6 | 0.0168213
 |  |  |  | c  Immunity Booster | 0.6 | 3 | 1.6363635 | 0.1636365 | 1.8 | 0.0084106
 |  |  |  | c  [NAME] | 0.6 | 1 | 0.5454545 | 0.0545455 | 0.6 | 0.0028035
 |  |  |  | c  Superfruit Booste | 0.6 | 1 | 0.5454545 | 0.0545455 | 0.6 | 0.0028035
 |  |  |  |  | Category Total: | 17 | 7.0909085 | 0.7090915 | 7.8 | 0.036446
 |  |  |  |  | Staff Total: | 17 | 7.0909085 | 0.7090915 | 7.8 | 0.036446
 |  | Cassie
 |  |  | Boosters
 |  |  |  | $1 Power Pack | 0 | 31 | 0 | 0 | 0 | 0
 |  |  |  | c  [NAME] | 0.6 | 4 | 2.1818181 | 0.2181819 | 2.4 | 0.0112142
 |  |  |  | c  Energiser Booster | 0.6 | 26 | 14.1818171 | 1.4181829 | 15.6 | 0.0728921
 |  |  |  | c  Immunity Booster | 0.6 | 12 | 6.545454 | 0.654546 | 7.2 | 0.0336425
 |  |  |  | c  [NAME] | 0.6 | 33 | 17.9999991 | 1.8000009 | 19.8 | 0.0925169
 |  |  |  | c  Superfruit Booste | 0.6 | 1 | 0.5454545 | 0.0545455 | 0.6 | 0.0028035
 |  |  |  | c  Vita Booster | 0.6 | 1 | 0.5454545 | 0.0545455 | 0.6 | 0.0028035
 |  |  |  | c  [NAME] | 0.6 | 12 | 6.5454541 | 0.6545459 | 7.2 | 0.0336425
 |  |  |  |  | Category Total: | 120 | 48.5454514 | 4.8545486 | 53.4 | 0.2495153
 |  |  |  |  | Staff Total: | 120 | 48.5454514 | 4.8545486 | 53.4 | 0.2495153
 |  | Chloe
 |  |  | Boosters
 |  |  |  | $1 Power Pack | 0 | 1 | 0 | 0 | 0 | 0
 |  |  |  | c  Energiser Booster | 0.6 | 3 | 1.6363635 | 0.1636365 | 1.8 | 0.0084106
 |  |  |  |  | Category Total: | 4 | 1.6363635 | 0.1636365 | 1.8 | 0.0084106
 |  |  |  |  | Staff Total: | 4 | 1.6363635 | 0.1636365 | 1.8 | 0.0084106
 |  | Deven
 |  |  | Boosters
 |  |  |  | $1 Power Pack | 0 | 1 | 0 | 0 | 0 | 0
 |  |  |  | c  Energiser Booster | 0.6 | 1 | 0.5454545 | 0.0545455 | 0.6 | 0.0028035
 |  |  |  | c  Immunity Booster | 0.6 | 1 | 0.5454545 | 0.0545455 | 0.6 | 0.0028035
 |  |  |  |  | Category Total: | 3 | 1.090909 | 0.109091 | 1.2 | 0.0056071
 |  |  |  |  | Staff Total: | 3 | 1.090909 | 0.109091 | 1.2 | 0.0056071
 |  | Felicity
 |  |  | Boosters
 |  |  |  | $1 Power Pack | 0 | 9 | 0 | 0 | 0 | 0
 |  |  |  | [NAME] | 0.6 | 2 | 1.090909 | 0.109091 | 1.2 | 0.0056071
 |  |  |  | c  [NAME] | 0.6 | 8 | 4.363636 | 0.436364 | 4.8 | 0.0224283
 |  |  |  | c  Energiser Booster | 0.6 | 5 | 2.7272725 | 0.2727275 | 3 | 0.0140177
 |  |  |  | c  Immunity Booster | 0.6 | 3 | 1.6363635 | 0.1636365 | 1.8 | 0.0084106
 |  |  |  | c  [NAME] | 0.6 | 8 | 4.363636 | 0.436364 | 4.8 | 0.0224283
 |  |  |  | c  Superfruit Booste | 0.6 | 1 | 0.5454545 | 0.0545455 | 0.6 | 0.0028035
 |  |  |  | c  Vita Booster | 0.6 | 1 | 0.5454545 | 0.0545455 | 0.6 | 0.0028035
 |  |  |  |  | Category Total: | 37 | 15.272726 | 1.527274 | 16.8 | 0.0784992
 |  |  |  |  | Staff Total: | 37 | 15.272726 | 1.527274 | 16.8 | 0.0784992
 |  | Jaimee
 |  |  | Boosters
 |  |  |  | $1 Power Pack | 0 | 27 | 0 | 0 | 0 | 0
 |  |  |  | c  [NAME] | 0.6 | 7 | 3.8181815 | 0.3818185 | 4.2 | 0.0196248
 |  |  |  | c  Energiser Booster | 0.6 | 18 | 9.818181 | 0.981819 | 10.8 | 0.0504638
 |  |  |  | c  Immunity Booster | 0.6 | 8 | 4.363636 | 0.436364 | 4.8 | 0.0224283
 |  |  |  | c  [NAME] | 0.6 | 42 | 22.909089 | 2.290911 | 25.2 | 0.1177488
 |  |  |  | c  Superfruit Booste | 0.6 | 1 | 0.5454545 | 0.0545455 | 0.6 | 0.0028035
 |  |  |  | c  Vita Booster | 0.6 | 2 | 1.090909 | 0.109091 | 1.2 | 0.0056071
 |  |  |  | c  [NAME] | 0.6 | 1 | 0.5454545 | 0.0545455 | 0.6 | 0.0028035
 |  |  |  |  | Category Total: | 106 | 43.0909055 | 4.3090945 | 47.4 | 0.2214798
 |  |  |  |  | Staff Total: | 106 | 43.0909055 | 4.3090945 | 47.4 | 0.2214798
 |  | [NAME]
 |  |  | Boosters
 |  |  |  | $1 Power Pack | 0 | 16 | 0 | 0 | 0 | 0
 |  |  |  | c  [NAME] | 0.6 | 4 | 2.181818 | 0.218182 | 2.4 | 0.0112142
 |  |  |  | c  Energiser Booster | 0.6 | 10 | 5.454545 | 0.545455 | 6 | 0.0280354
 |  |  |  | c  Immunity Booster | 0.6 | 8 | 4.363636 | 0.436364 | 4.8 | 0.0224283
 |  |  |  | c  [NAME] | 0.6 | 8 | 4.363636 | 0.436364 | 4.8 | 0.0224283
 |  |  |  | c  Superfruit Booste | 0.6 | 1 | 0.5454545 | 0.0545455 | 0.6 | 0.0028035
 |  |  |  | c  Vita Booster | 0.6 | 2 | 1.090909 | 0.109091 | 1.2 | 0.0056071
 |  |  |  | c  [NAME] | 0.6 | 3 | 1.6363635 | 0.1636365 | 1.8 | 0.0084106
 |  |  |  |  | Category Total: | 52 | 19.636362 | 1.963638 | 21.6 | 0.1009275
 |  |  |  |  | Staff Total: | 52 | 19.636362 | 1.963638 | 21.6 | 0.1009275
 |  | Pearlyn
 |  |  | Boosters
 |  |  |  | $1 Power Pack | 0 | 3 | 0 | 0 | 0 | 0
 |  |  |  | [NAME] | 0.6 | 1 | 0.5454545 | 0.0545455 | 0.6 | 0.0028035
 |  |  |  | [NAME] | 0.6 | 1 | 0.5454545 | 0.0545455 | 0.6 | 0.0028035
 |  |  |  | Immunity Booster | 0.6 | 1 | 0.5454545 | 0.0545455 | 0.6 | 0.0028035
 |  |  |  | [NAME] | 0.6 | 1 | 0.5454545 | 0.0545455 | 0.6 | 0.0028035
 |  |  |  | c  Energiser Booster | 0.6 | 3 | 1.6363635 | 0.1636365 | 1.8 | 0.0084106
 |  |  |  | c  [NAME] | 0.6 | 4 | 2.181818 | 0.218182 | 2.4 | 0.0112142
 |  |  |  | c  Superfruit Booste | 0.6 | 1 | 0.5454545 | 0.0545455 | 0.6 | 0.0028035
 |  |  |  | c  [NAME] | 0.6 | 1 | 0.5454545 | 0.0545455 | 0.6 | 0.0028035
 |  |  |  |  | Category Total: | 16 | 7.0909085 | 0.7090915 | 7.8 | 0.036446
 |  |  |  |  | Staff Total: | 16 | 7.0909085 | 0.7090915 | 7.8 | 0.036446
 |  | Taryn
 |  |  | Boosters
 |  |  |  | $1 Power Pack | 0 | 2 | 0 | 0 | 0 | 0
 |  |  |  | c  Energiser Booster | 0.6 | 2 | 1.090909 | 0.109091 | 1.2 | 0.0056071
 |  |  |  | c  [NAME] | 0.6 | 4 | 2.181818 | 0.218182 | 2.4 | 0.0112142
 |  |  |  |  | Category Total: | 8 | 3.272727 | 0.327273 | 3.6 | 0.0168213
 |  |  |  |  | Staff Total: | 8 | 3.272727 | 0.327273 | 3.6 | 0.0168213
 |  | [NAME]
 |  |  | Boosters
 |  |  |  | $1 Power Pack | 0 | 24 | 0 | 0 | 0 | 0
 |  |  |  | [NAME] | 0.6 | 1 | 0.5454545 | 0.0545455 | 0.6 | 0.0028035
 |  |  |  | Wheatgrass Powder | 0.6 | 1 | 0.5454545 | 0.0545455 | 0.6 | 0.0028035
 |  |  |  | c  [NAME] | 0.6 | 4 | 2.181818 | 0.218182 | 2.4 | 0.0112142
 |  |  |  | c  Energiser Booster | 0.6 | 20 | 10.90909 | 1.09091 | 12 | 0.0560708
 |  |  |  | c  Green Tea Booster | 0.6 | 1 | 0.5454545 | 0.0545455 | 0.6 | 0.0028035
 |  |  |  | c  Immunity Booster | 0.6 | 13 | 7.0909085 | 0.7090915 | 7.8 | 0.036446
 |  |  |  | c  [NAME] | 0.6 | 19 | 10.3636355 | 1.0363645 | 11.4 | 0.0532673
 |  |  |  | c  Superfruit Booste | 0.6 | 6 | 3.272727 | 0.327273 | 3.6 | 0.0168213
 |  |  |  | c  Vita Booster | 0.6 | 5 | 2.7272725 | 0.2727275 | 3 | 0.0140177
 |  |  |  | c  [NAME] | 0.6 | 4 | 2.181818 | 0.218182 | 2.4 | 0.0112142
 |  |  |  |  | Category Total: | 98 | 40.363633 | 4.036367 | 44.4 | 0.2074621
 |  |  |  |  | Staff Total: | 98 | 40.363633 | 4.036367 | 44.4 | 0.2074621
 |  |  |  |  | Location Total: | 480 | 194.7272574 | 19.4727426 | 214.2 | 1.0008646
Armadale
 | <Consolidated>
 |  | Breanna
 |  |  | Boosters
 |  |  |  | $1 Power Pack | 0 | 28 | 0 | 0 | 0 | 0
 |  |  |  | [NAME] | 0.6 | 2 | 1.090909 | 0.109091 | 1.2 | 0.0056071
 |  |  |  | Immunity Booster | 0.6 | 3 | 1.6363635 | 0.1636365 | 1.8 | 0.0084106
 |  |  |  | c  [NAME] | 0.6 | 12 | 6.545454 | 0.654546 | 7.2 | 0.0336425
 |  |  |  | c  Energiser Booster | 0.6 | 24 | 13.090908 | 1.309092 | 14.4 | 0.067285
 |  |  |  | c  Immunity Booster | 0.6 | 12 | 6.545454 | 0.654546 | 7.2 | 0.0336425
 |  |  |  | c  [NAME] | 0.6 | 17 | 9.2727265 | 0.9272735 | 10.2 | 0.0476602
 |  |  |  | c  Superfruit Booste | 0.6 | 4 | 2.181818 | 0.218182 | 2.4 | 0.0112142
 |  |  |  | c  Vita Booster | 0.6 | 6 | 3.272727 | 0.327273 | 3.6 | 0.0168213
 |  |  |  | c  [NAME] | 0.6 | 5 | 2.7272725 | 0.2727275 | 3 | 0.0140177
 |  |  |  |  | Category Total: | 113 | 46.3636325 | 4.6363675 | 51 | 0.2383011
 |  |  |  |  | Staff Total: | 113 | 46.3636325 | 4.6363675 | 51 | 0.2383011
 |  | [NAME]
 |  |  | Boosters
 |  |  |  | $1 Power Pack | 0 | 11 | 0 | 0 | 0 | 0
 |  |  |  | [NAME] | 0.6 | 1 | 0.5454545 | 0.0545455 | 0.6 | 0.0028035
 |  |  |  | c  Energiser Booster | 0.6 | 4 | 2.181818 | 0.218182 | 2.4 | 0.0112142
 |  |  |  | c  Immunity Booster | 0.6 | 4 | 2.181818 | 0.218182 | 2.4 | 0.0112142
 |  |  |  | c  [NAME] | 0.6 | 19 | 10.3636355 | 1.0363645 | 11.4 | 0.0532673
 |  |  |  | c  Superfruit Booste | 0.6 | 3 | 1.6363635 | 0.1636365 | 1.8 | 0.0084106
 |  |  |  | c  Vita Booster | 0.6 | 3 | 1.6363635 | 0.1636365 | 1.8 | 0.0084106
 |  |  |  |  | Category Total: | 45 | 18.545453 | 1.854547 | 20.4 | 0.0953204
 |  |  |  |  | Staff Total: | 45 | 18.545453 | 1.854547 | 20.4 | 0.0953204
 |  | Curtis
 |  |  | Boosters
 |  |  |  | $1 Power Pack | 0 | 27 | 0 | 0 | 0 | 0
 |  |  |  | Immunity Booster | 0.6 | 1 | 0.5454545 | 0.0545455 | 0.6 | 0.0028035
 |  |  |  | c  [NAME] | 0.6 | 10 | 5.454545 | 0.545455 | 6 | 0.0280354
 |  |  |  | c  Energiser Booster | 0.6 | 26 | 14.181817 | 1.418183 | 15.6 | 0.0728921
 |  |  |  | c  Immunity Booster | 0.6 | 12 | 6.545454 | 0.654546 | 7.2 | 0.0336425
 |  |  |  | c  [NAME] | 0.6 | 25 | 13.6363625 | 1.3636375 | 15 | 0.0700886
 |  |  |  | c  Superfruit Booste | 0.6 | 2 | 1.090909 | 0.109091 | 1.2 | 0.0056071
 |  |  |  | c  Vita Booster | 0.6 | 4 | 2.181818 | 0.218182 | 2.4 | 0.0112142
 |  |  |  | c  [NAME] | 0.6 | 1 | 0.5454545 | 0.0545455 | 0.6 | 0.0028035
 |  |  |  |  | Category Total: | 108 | 44.1818145 | 4.4181855 | 48.6 | 0.2270869
 |  |  |  |  | Staff Total: | 108 | 44.1818145 | 4.4181855 | 48.6 | 0.2270869
 |  | Danielle
 |  |  | Boosters
 |  |  |  | $1 Power Pack | 0 | 19 | 0 | 0 | 0 | 0
 |  |  |  | [NAME] | 0.6 | 1 | 0.5454545 | 0.0545455 | 0.6 | 0.0028035
 |  |  |  | [NAME] | 0.6 | 1 | 0.5454545 | 0.0545455 | 0.6 | 0.0028035
 |  |  |  | Vita Booster | 0.6 | 1 | 0.5454545 | 0.0545455 | 0.6 | 0.0028035
 |  |  |  | c  [NAME] | 0.6 | 8 | 4.363636 | 0.436364 | 4.8 | 0.0224283
 |  |  |  | c  Energiser Booster | 0.6 | 21 | 11.4545445 | 1.1454555 | 12.6 | 0.0588744
 |  |  |  | c  Immunity Booster | 0.6 | 4 | 2.181818 | 0.218182 | 2.4 | 0.0112142
 |  |  |  | c  [NAME] | 0.6 | 8 | 4.363636 | 0.436364 | 4.8 | 0.0224283
 |  |  |  | c  Superfruit Booste | 0.6 | 2 | 1.090909 | 0.109091 | 1.2 | 0.0056071
 |  |  |  | c  Vita Booster | 0.6 | 9 | 4.9090905 | 0.4909095 | 5.4 | 0.0252319
 |  |  |  | c  [NAME] | 0.6 | 5 | 2.7272725 | 0.2727275 | 3 | 0.0140177
 |  |  |  |  | Category Total: | 79 | 32.72727 | 3.27273 | 36 | 0.1682125
 |  |  |  |  | Staff Total: | 79 | 32.72727 | 3.27273 | 36 | 0.1682125
 |  | Jaimee
 |  |  | Boosters
 |  |  |  | $1 Power Pack | 0 | 16 | 0 | 0 | 0 | 0
 |  |  |  | c  [NAME] | 0.6 | 6 | 3.272727 | 0.327273 | 3.6 | 0.0168213
 |  |  |  | c  Energiser Booster | 0.6 | 22 | 11.999999 | 1.200001 | 13.2 | 0.0616779
 |  |  |  | c  Immunity Booster | 0.6 | 7 | 3.8181815 | 0.3818185 | 4.2 | 0.0196248
 |  |  |  | c  [NAME] | 0.6 | 10 | 5.454545 | 0.545455 | 6 | 0.0280354
 |  |  |  | c  Superfruit Booste | 0.6 | 1 | 0.5454545 | 0.0545455 | 0.6 | 0.0028035
 |  |  |  | c  Vita Booster | 0.6 | 1 | 0.5454545 | 0.0545455 | 0.6 | 0.0028035
 |  |  |  |  | Category Total: | 63 | 25.6363615 | 2.5636385 | 28.2 | 0.1317665
 |  |  |  |  | Staff Total: | 63 | 25.6363615 | 2.5636385 | 28.2 | 0.1317665
 |  | [NAME]
 |  |  | Boosters
 |  |  |  | $1 Power Pack | 0 | 2 | 0 | 0 | 0 | 0
 |  |  |  | c  [NAME] | 0.6 | 6 | 3.272727 | 0.327273 | 3.6 | 0.0168213
 |  |  |  |  | Category Total: | 8 | 3.272727 | 0.327273 | 3.6 | 0.0168213
 |  |  |  |  | Staff Total: | 8 | 3.272727 | 0.327273 | 3.6 | 0.0168213
 |  | Rebecca
 |  |  | Boosters
 |  |  |  | $1 Power Pack | 0 | 3 | 0 | 0 | 0 | 0
 |  |  |  | [NAME] | 0.6 | 1 | 0.5454545 | 0.0545455 | 0.6 | 0.0028035
 |  |  |  | Immunity Booster | 0.6 | 1 | 0.5454545 | 0.0545455 | 0.6 | 0.0028035
 |  |  |  | [NAME] | 0.6 | 1 | 0.5454545 | 0.0545455 | 0.6 | 0.0028035
 |  |  |  | c  Energiser Booster | 0.6 | 4 | 2.181818 | 0.218182 | 2.4 | 0.0112142
 |  |  |  | c  Immunity Booster | 0.6 | 2 | 1.090909 | 0.109091 | 1.2 | 0.0056071
 |  |  |  | c  [NAME] | 0.6 | 1 | 0.5454545 | 0.0545455 | 0.6 | 0.0028035
 |  |  |  | c  Vita Booster | 0.6 | 2 | 1.090909 | 0.109091 | 1.2 | 0.0056071
 |  |  |  |  | Category Total: | 15 | 6.545454 | 0.654546 | 7.2 | 0.0336425
 |  |  |  |  | Staff Total: | 15 | 6.545454 | 0.654546 | 7.2 | 0.0336425
 |  | Sophie.D
 |  |  | Boosters
 |  |  |  | $1 Power Pack | 0 | 2 | 0 | 0 | 0 | 0
 |  |  |  | [NAME] | 0.6 | 1 | 0.5454545 | 0.0545455 | 0.6 | 0.0028035
 |  |  |  | Wheatgrass Powder | 0.6 | 1 | 0.5454545 | 0.0545455 | 0.6 | 0.0028035
 |  |  |  | c  Energiser Booster | 0.6 | 4 | 2.181818 | 0.218182 | 2.4 | 0.0112142
 |  |  |  | c  Immunity Booster | 0.6 | 2 | 1.090909 | 0.109091 | 1.2 | 0.0056071
 |  |  |  |  | Category Total: | 10 | 4.363636 | 0.436364 | 4.8 | 0.0224283
 |  |  |  |  | Staff Total: | 10 | 4.363636 | 0.436364 | 4.8 | 0.0224283
 |  |  |  |  | Location Total: | 441 | 181.6363485 | 18.1636515 | 199.8 | 0.9335796
 |  |  |  |  | Grand Total: | 921 | 376.3636059 | 37.6363941 | 414 | 1.9344442
***End Of File*** | RedCat [NAME]