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

2013-10-28 00:00:00 | 06:53AM
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 |  |  |  |  | dog
 |  |  | With
 |  |  |  |  | 0.5 | 1 | 0.5 | 0 | 0.5 | 0.0025699
 |  |  |  |  | 0.5 | 1 | 0.4545455 | 0.0454545 | 0.5 | 0.0023363
 |  |  |  |  | 0.5 | 2 | 0.909091 | 0.090909 | 1 | 0.0046726
 |  |  |  |  | 0.5 | 1 | 0.4545455 | 0.0454545 | 0.5 | 0.0023363
 |  |  |  |  | Category Total: | 5 | 2.318182 | 0.181818 | 2.5 | 0.0119151
 |  |  |  |  | Staff Total: | 5 | 2.318182 | 0.181818 | 2.5 | 0.0119151
 |  | Brittany
 |  |  | With
 |  |  |  |  | 0.5 | 4 | 1.818182 | 0.181818 | 2 | 0.0093451
 |  |  |  |  | 0.5 | 2 | 0.909091 | 0.090909 | 1 | 0.0046726
 |  |  |  |  | 0.5 | 11 | 5.0000005 | 0.4999995 | 5.5 | 0.0256991
 |  |  |  |  | 0.5 | 2 | 0.9545455 | 0.0454545 | 1 | 0.0049062
 |  |  |  |  | 0.5 | 1 | 0.4545455 | 0.0454545 | 0.5 | 0.0023363
 |  |  |  |  | 0.5 | 4 | 1.818182 | 0.181818 | 2 | 0.0093451
 |  |  |  |  | Category Total: | 24 | 10.9545465 | 1.0454535 | 12 | 0.0563045
 |  |  |  |  | Staff Total: | 24 | 10.9545465 | 1.0454535 | 12 | 0.0563045
 |  | Cassie
 |  |  | With
 |  |  |  |  | 0.5 | 16 | 7.272728 | 0.727272 | 8 | 0.0373806
 |  |  |  |  | 0.5 | 3 | 1.3636365 | 0.1363635 | 1.5 | 0.0070089
 |  |  |  |  | 0.5 | 2 | 0.909091 | 0.090909 | 1 | 0.0046726
 |  |  |  |  | 0.5 | 1 | 0.4545455 | 0.0454545 | 0.5 | 0.0023363
 |  |  |  |  | 0.5 | 2 | 0.909091 | 0.090909 | 1 | 0.0046726
 |  |  |  |  | 0.5 | 2 | 0.909091 | 0.090909 | 1 | 0.0046726
 |  |  |  |  | 0.5 | 11 | 5.0000005 | 0.4999995 | 5.5 | 0.0256991
 |  |  |  |  | 0.5 | 5 | 2.2727275 | 0.2272725 | 2.5 | 0.0116814
 |  |  |  |  | 0.5 | 3 | 1.3636365 | 0.1363635 | 1.5 | 0.0070089
 |  |  |  |  | 0.5 | 17 | 7.7272734 | 0.7727266 | 8.5 | 0.0397169
 |  |  |  |  | 0.5 | 1 | 0.4545455 | 0.0454545 | 0.5 | 0.0023363
 |  |  |  |  | Category Total: | 63 | 28.6363664 | 2.8636336 | 31.5 | 0.147186
 |  |  |  |  | Staff Total: | 63 | 28.6363664 | 2.8636336 | 31.5 | 0.147186
 |  | Connor
 |  |  | With
 |  |  |  |  | 0.5 | 2 | 0.909091 | 0.090909 | 1 | 0.0046726
 |  |  |  |  | 0.5 | 1 | 0.4545455 | 0.0454545 | 0.5 | 0.0023363
 |  |  |  |  | 0.5 | 1 | 0.4545455 | 0.0454545 | 0.5 | 0.0023363
 |  |  |  |  | 0.5 | 1 | 0.4545455 | 0.0454545 | 0.5 | 0.0023363
 |  |  |  |  | 0.5 | 2 | 0.909091 | 0.090909 | 1 | 0.0046726
 |  |  |  |  | 0.5 | 2 | 0.909091 | 0.090909 | 1 | 0.0046726
 |  |  |  |  | Category Total: | 9 | 4.0909095 | 0.4090905 | 4.5 | 0.0210266
 |  |  |  |  | Staff Total: | 9 | 4.0909095 | 0.4090905 | 4.5 | 0.0210266
 |  | Deven
 |  |  | With
 |  |  |  |  | 0.5 | 9 | 4.0909095 | 0.4090905 | 4.5 | 0.0210266
 |  |  |  |  | 0.5 | 3 | 1.3636365 | 0.1363635 | 1.5 | 0.0070089
 |  |  |  |  | 0.5 | 1 | 0.4545455 | 0.0454545 | 0.5 | 0.0023363
 |  |  |  |  | 0.5 | 6 | 2.7272729 | 0.2727271 | 3 | 0.0140177
 |  |  |  |  | 0.5 | 1 | 0.4545455 | 0.0454545 | 0.5 | 0.0023363
 |  |  |  |  | 0.5 | 2 | 0.909091 | 0.090909 | 1 | 0.0046726
 |  |  |  |  | Category Total: | 22 | 10.0000009 | 0.9999991 | 11 | 0.0513983
 |  |  |  |  | Staff Total: | 22 | 10.0000009 | 0.9999991 | 11 | 0.0513983
 |  | Felicity
 |  |  | With
 |  |  |  |  | 0.5 | 1 | 0.5 | 0 | 0.5 | 0.0025699
 |  |  |  |  | 0.5 | 8 | 3.636364 | 0.363636 | 4 | 0.0186903
 |  |  |  |  | 0.5 | 1 | 0.5 | 0 | 0.5 | 0.0025699
 |  |  |  |  | 0.5 | 1 | 0.4545455 | 0.0454545 | 0.5 | 0.0023363
 |  |  |  |  | 0.5 | 1 | 0.4545455 | 0.0454545 | 0.5 | 0.0023363
 |  |  |  |  | 0.5 | 1 | 0.4545455 | 0.0454545 | 0.5 | 0.0023363
 |  |  |  |  | 0.5 | 2 | 0.9545455 | 0.0454545 | 1 | 0.0049062
 |  |  |  |  | 0.5 | 13 | 5.9090915 | 0.5909085 | 6.5 | 0.0303717
 |  |  |  |  | 0.5 | 1 | 0.4545455 | 0.0454545 | 0.5 | 0.0023363
 |  |  |  |  | 0.5 | 1 | 0.5 | 0 | 0.5 | 0.0025699
 |  |  |  |  | 0.5 | 2 | 0.909091 | 0.090909 | 1 | 0.0046726
 |  |  |  |  | 0.5 | 8 | 3.636364 | 0.363636 | 4 | 0.0186903
 |  |  |  |  | 0.5 | 2 | 0.909091 | 0.090909 | 1 | 0.0046726
 |  |  |  |  | Category Total: | 42 | 19.272729 | 1.727271 | 21 | 0.0990585
 |  |  |  |  | Staff Total: | 42 | 19.272729 | 1.727271 | 21 | 0.0990585
 |  | Jaimee
 |  |  | With
 |  |  |  |  | 0.5 | 29 | 13.2727284 | 1.2272716 | 14.5 | 0.0682195
 |  |  |  |  | 0.5 | 1 | 0.5 | 0 | 0.5 | 0.0025699
 |  |  |  |  | 0.5 | 4 | 1.818182 | 0.181818 | 2 | 0.0093451
 |  |  |  |  | 0.5 | 1 | 0.4545455 | 0.0454545 | 0.5 | 0.0023363
 |  |  |  |  | 0.5 | 1 | 0.5 | 0 | 0.5 | 0.0025699
 |  |  |  |  | 0.5 | 1 | 0.4545455 | 0.0454545 | 0.5 | 0.0023363
 |  |  |  |  | 0.5 | 1 | 0.4545455 | 0.0454545 | 0.5 | 0.0023363
 |  |  |  |  | 0.5 | 17 | 7.7272732 | 0.7727268 | 8.5 | 0.0397169
 |  |  |  |  | 0.5 | 7 | 3.1818183 | 0.3181817 | 3.5 | 0.016354
 |  |  |  |  | 0.5 | 1 | 0.4545455 | 0.0454545 | 0.5 | 0.0023363
 |  |  |  |  | 0.5 | 1 | 0.4545455 | 0.0454545 | 0.5 | 0.0023363
 |  |  |  |  | 0.5 | 1 | 0.5 | 0 | 0.5 | 0.0025699
 |  |  |  |  | 0.5 | 18 | 8.3636369 | 0.6363631 | 9 | 0.0429877
 |  |  |  |  | Category Total: | 83 | 38.1363663 | 3.3636337 | 41.5 | 0.1960144
 |  |  |  |  | Staff Total: | 83 | 38.1363663 | 3.3636337 | 41.5 | 0.1960144
 |  | [NAME]
 |  |  | With
 |  |  |  |  | 0.5 | 31 | 14.0909105 | 1.4090895 | 15.5 | 0.0724249
 |  |  |  |  | 0.5 | 1 | 0.5 | 0 | 0.5 | 0.0025699
 |  |  |  |  | 0.5 | 9 | 4.0909095 | 0.4090905 | 4.5 | 0.0210266
 |  |  |  |  | 0.5 | 31 | 14.0909105 | 1.4090895 | 15.5 | 0.0724249
 |  |  |  |  | 0.5 | 13 | 5.9090915 | 0.5909085 | 6.5 | 0.0303717
 |  |  |  |  | 0.5 | 4 | 1.818182 | 0.181818 | 2 | 0.0093451
 |  |  |  |  | 0.5 | 12 | 5.545455 | 0.454545 | 6 | 0.0285027
 |  |  |  |  | 0.5 | 5 | 2.2727275 | 0.2272725 | 2.5 | 0.0116814
 |  |  |  |  | Category Total: | 106 | 48.3181865 | 4.6818135 | 53 | 0.2483472
 |  |  |  |  | Staff Total: | 106 | 48.3181865 | 4.6818135 | 53 | 0.2483472
 |  | Pearlyn
 |  |  | With
 |  |  |  |  | 0.5 | 2 | 0.9545455 | 0.0454545 | 1 | 0.0049062
 |  |  |  |  | 0.5 | 2 | 0.909091 | 0.090909 | 1 | 0.0046726
 |  |  |  |  | 0.5 | 1 | 0.4545455 | 0.0454545 | 0.5 | 0.0023363
 |  |  |  |  | 0.5 | 2 | 0.909091 | 0.090909 | 1 | 0.0046726
 |  |  |  |  | 0.5 | 3 | 1.3636365 | 0.1363635 | 1.5 | 0.0070089
 |  |  |  |  | 0.5 | 2 | 0.909091 | 0.090909 | 1 | 0.0046726
 |  |  |  |  | 0.5 | 2 | 0.909091 | 0.090909 | 1 | 0.0046726
 |  |  |  |  | Category Total: | 14 | 6.4090915 | 0.5909085 | 7 | 0.0329416
 |  |  |  |  | Staff Total: | 14 | 6.4090915 | 0.5909085 | 7 | 0.0329416
 |  | Taryn
 |  |  | With
 |  |  |  |  | 0.5 | 4 | 1.818182 | 0.181818 | 2 | 0.0093451
 |  |  |  |  | 0.5 | 1 | 0.4545455 | 0.0454545 | 0.5 | 0.0023363
 |  |  |  |  | 0.5 | 1 | 0.4545455 | 0.0454545 | 0.5 | 0.0023363
 |  |  |  |  | 0.5 | 1 | 0.4545455 | 0.0454545 | 0.5 | 0.0023363
 |  |  |  |  | 0.5 | 5 | 2.2727275 | 0.2272725 | 2.5 | 0.0116814
 |  |  |  |  | 0.5 | 1 | 0.4545455 | 0.0454545 | 0.5 | 0.0023363
 |  |  |  |  | 0.5 | 3 | 1.3636365 | 0.1363635 | 1.5 | 0.0070089
 |  |  |  |  | 0.5 | 1 | 0.4545455 | 0.0454545 | 0.5 | 0.0023363
 |  |  |  |  | Category Total: | 17 | 7.7272735 | 0.7727265 | 8.5 | 0.0397169
 |  |  |  |  | Staff Total: | 17 | 7.7272735 | 0.7727265 | 8.5 | 0.0397169
 |  | [NAME]
 |  |  | With
 |  |  |  |  | 0.5 | 3 | 1.5 | 0 | 1.5 | 0.0077097
 |  |  |  |  | 0.5 | 44 | 20.0000019 | 1.9999981 | 22 | 0.1027966
 |  |  |  |  | 0.5 | 12 | 5.454546 | 0.545454 | 6 | 0.0280354
 |  |  |  |  | 0.5 | 1 | 0.5 | 0 | 0.5 | 0.0025699
 |  |  |  |  | 0.5 | 4 | 2 | 0 | 2 | 0.0102797
 |  |  |  |  | 0.5 | 6 | 2.727273 | 0.272727 | 3 | 0.0140177
 |  |  |  |  | 0.5 | 1 | 0.5 | 0 | 0.5 | 0.0025699
 |  |  |  |  | 0.5 | 2 | 0.909091 | 0.090909 | 1 | 0.0046726
 |  |  |  |  | 0.5 | 3 | 1.3636365 | 0.1363635 | 1.5 | 0.0070089
 |  |  |  |  | 0 | 1 | 0 | 0 | 0 | 0
 |  |  |  |  | 0.5 | 3 | 1.409091 | 0.090909 | 1.5 | 0.0072425
 |  |  |  |  | 0.5 | 42 | 19.0909108 | 1.9090892 | 21 | 0.098124
 |  |  |  |  | 0.5 | 5 | 2.5 | 0 | 2.5 | 0.0128496
 |  |  |  |  | 0.5 | 17 | 7.7272734 | 0.7727266 | 8.5 | 0.0397169
 |  |  |  |  | 0.5 | 2 | 0.909091 | 0.090909 | 1 | 0.0046726
 |  |  |  |  | 0.5 | 12 | 5.454546 | 0.545454 | 6 | 0.0280354
 |  |  |  |  | 0.5 | 2 | 1 | 0 | 1 | 0.0051398
 |  |  |  |  | 0.5 | 1 | 0.5 | 0 | 0.5 | 0.0025699
 |  |  |  |  | 0.5 | 41 | 18.68182 | 1.81818 | 20.5 | 0.0960213
 |  |  |  |  | 0.5 | 14 | 6.454546 | 0.545454 | 7 | 0.0331753
 |  |  |  |  | 0.5 | 1 | 0.4545455 | 0.0454545 | 0.5 | 0.0023363
 |  |  |  |  | Category Total: | 217 | 99.1363721 | 8.8636279 | 108 | 0.5095439
 |  |  |  |  | Staff Total: | 217 | 99.1363721 | 8.8636279 | 108 | 0.5095439
 |  |  |  |  | Location Total: | 602 | 275.0000242 | 25.4999758 | 300.5 | 1.4134528
Armadale
 | <Consolidated>
 |  | Breanna
 |  |  | With
 |  |  |  |  | 0.5 | 3 | 1.3636365 | 0.1363635 | 1.5 | 0.0070089
 |  |  |  |  | 0.5 | 1 | 0.4545455 | 0.0454545 | 0.5 | 0.0023363
 |  |  |  |  | 0.5 | 1 | 0.5 | 0 | 0.5 | 0.0025699
 |  |  |  |  | 0.5 | 3 | 1.3636365 | 0.1363635 | 1.5 | 0.0070089
 |  |  |  |  | 0.5 | 1 | 0.4545455 | 0.0454545 | 0.5 | 0.0023363
 |  |  |  |  | 0.5 | 14 | 6.363637 | 0.636363 | 7 | 0.032708
 |  |  |  |  | 0.5 | 1 | 0.4545455 | 0.0454545 | 0.5 | 0.0023363
 |  |  |  |  | 0.5 | 1 | 0.4545455 | 0.0454545 | 0.5 | 0.0023363
 |  |  |  |  | 0.5 | 5 | 2.2727275 | 0.2272725 | 2.5 | 0.0116814
 |  |  |  |  | 0.5 | 22 | 10.000001 | 0.999999 | 11 | 0.0513983
 |  |  |  |  | Category Total: | 52 | 23.6818205 | 2.3181795 | 26 | 0.1217205
 |  |  |  |  | Staff Total: | 52 | 23.6818205 | 2.3181795 | 26 | 0.1217205
 |  | [NAME]
 |  |  | With
 |  |  |  |  | 0.5 | 1 | 0.4545455 | 0.0454545 | 0.5 | 0.0023363
 |  |  |  |  | 0 | 1 | 0 | 0 | 0 | 0
 |  |  |  |  | 0.5 | 2 | 0.909091 | 0.090909 | 1 | 0.0046726
 |  |  |  |  | 0.5 | 5 | 2.2727275 | 0.2272725 | 2.5 | 0.0116814
 |  |  |  |  | Category Total: | 9 | 3.636364 | 0.363636 | 4 | 0.0186903
 |  |  |  |  | Staff Total: | 9 | 3.636364 | 0.363636 | 4 | 0.0186903
 |  | Curtis
 |  |  | With
 |  |  |  |  | 0.5 | 6 | 2.7272729 | 0.2727271 | 3 | 0.0140177
 |  |  |  |  | 0.5 | 1 | 0.5 | 0 | 0.5 | 0.0025699
 |  |  |  |  | 0.5 | 2 | 0.909091 | 0.090909 | 1 | 0.0046726
 |  |  |  |  | 0.5 | 1 | 0.4545455 | 0.0454545 | 0.5 | 0.0023363
 |  |  |  |  | 0.5 | 16 | 7.2727279 | 0.7272721 | 8 | 0.0373806
 |  |  |  |  | 0.5 | 1 | 0.5 | 0 | 0.5 | 0.0025699
 |  |  |  |  | 0.5 | 3 | 1.3636365 | 0.1363635 | 1.5 | 0.0070089
 |  |  |  |  | 0 | 1 | 0 | 0 | 0 | 0
 |  |  |  |  | 0.5 | 17 | 7.7272732 | 0.7727268 | 8.5 | 0.0397169
 |  |  |  |  | 0.5 | 1 | 0.4545455 | 0.0454545 | 0.5 | 0.0023363
 |  |  |  |  | 0.5 | 8 | 3.6363638 | 0.3636362 | 4 | 0.0186903
 |  |  |  |  | 0.5 | 2 | 0.909091 | 0.090909 | 1 | 0.0046726
 |  |  |  |  | 0.5 | 8 | 3.636364 | 0.363636 | 4 | 0.0186903
 |  |  |  |  | 0.5 | 1 | 0.5 | 0 | 0.5 | 0.0025699
 |  |  |  |  | Category Total: | 68 | 30.5909113 | 2.9090887 | 33.5 | 0.157232
 |  |  |  |  | Staff Total: | 68 | 30.5909113 | 2.9090887 | 33.5 | 0.157232
 |  | Danielle |  |  | cat |  | dog
 |  |  | With
 |  |  |  |  | 0.5 | 4 | 1.818182 | 0.181818 | 2 | 0.0093451
 |  |  |  |  | 0.5 | 1 | 0.4545455 | 0.0454545 | 0.5 | 0.0023363
 |  |  |  |  | 0.5 | 2 | 0.909091 | 0.090909 | 1 | 0.0046726
 |  |  |  |  | 0.5 | 1 | 0.4545455 | 0.0454545 | 0.5 | 0.0023363
 |  |  |  |  | 0.5 | 1 | 0.4545455 | 0.0454545 | 0.5 | 0.0023363
 |  |  |  |  | 0.5 | 14 | 6.363637 | 0.636363 | 7 | 0.032708
 |  |  |  |  | 0.5 | 1 | 0.4545455 | 0.0454545 | 0.5 | 0.0023363
 |  |  |  |  | 0.5 | 2 | 0.909091 | 0.090909 | 1 | 0.0046726
 |  |  |  |  | 0.5 | 2 | 0.909091 | 0.090909 | 1 | 0.0046726
 |  |  |  |  | 0.5 | 11 | 5.0000005 | 0.4999995 | 5.5 | 0.0256991
 |  |  |  |  | Category Total: | 39 | 17.7272745 | 1.7727255 | 19.5 | 0.0911151
 |  |  |  |  | Staff Total: | 39 | 17.7272745 | 1.7727255 | 19.5 | 0.0911151
 |  | Jaimee
 |  |  | With
 |  |  |  |  | 0.5 | 1 | 0.4545455 | 0.0454545 | 0.5 | 0.0023363
 |  |  |  |  | 0.5 | 1 | 0.4545455 | 0.0454545 | 0.5 | 0.0023363
 |  |  |  |  | 0.5 | 1 | 0.4545455 | 0.0454545 | 0.5 | 0.0023363
 |  |  |  |  | Category Total: | 3 | 1.3636365 | 0.1363635 | 1.5 | 0.0070089
 |  |  |  |  | Staff Total: | 3 | 1.3636365 | 0.1363635 | 1.5 | 0.0070089
 |  | [NAME]
 |  |  | With
 |  |  |  |  | 0.5 | 1 | 0.4545455 | 0.0454545 | 0.5 | 0.0023363
 |  |  |  |  | 0.5 | 1 | 0.4545455 | 0.0454545 | 0.5 | 0.0023363
 |  |  |  |  | 0.5 | 1 | 0.4545455 | 0.0454545 | 0.5 | 0.0023363
 |  |  |  |  | 0.5 | 3 | 1.3636365 | 0.1363635 | 1.5 | 0.0070089
 |  |  |  |  | 0.5 | 1 | 0.4545455 | 0.0454545 | 0.5 | 0.0023363
 |  |  |  |  | Category Total: | 7 | 3.1818185 | 0.3181815 | 3.5 | 0.016354
 |  |  |  |  | Staff Total: | 7 | 3.1818185 | 0.3181815 | 3.5 | 0.016354
 |  | Rebecca
 |  |  | With
 |  |  |  |  | 0.5 | 1 | 0.4545455 | 0.0454545 | 0.5 | 0.0023363
 |  |  |  |  | 0.5 | 1 | 0.4545455 | 0.0454545 | 0.5 | 0.0023363
 |  |  |  |  | 0.5 | 1 | 0.4545455 | 0.0454545 | 0.5 | 0.0023363
 |  |  |  |  | Category Total: | 3 | 1.3636365 | 0.1363635 | 1.5 | 0.0070089
 |  |  |  |  | Staff Total: | 3 | 1.3636365 | 0.1363635 | 1.5 | 0.0070089
 |  | Sophie.D
 |  |  | With
 |  |  |  |  | 0.5 | 1 | 0.4545455 | 0.0454545 | 0.5 | 0.0023363
 |  |  |  |  | 0.5 | 11 | 5.0000004 | 0.4999996 | 5.5 | 0.0256991
 |  |  |  |  | 0 | 1 | 0 | 0 | 0 | 0
 |  |  |  |  | 0.5 | 2 | 0.909091 | 0.090909 | 1 | 0.0046726
 |  |  |  |  | Category Total: | 15 | 6.3636369 | 0.6363631 | 7 | 0.032708
 |  |  |  |  | Staff Total: | 15 | 6.3636369 | 0.6363631 | 7 | 0.032708
 |  |  |  |  | Location Total: | 196 | 87.9090987 | 8.5909013 | 96.5 | 0.4518376
 |  |  |  |  | Grand Total: | 798 | 362.9091229 | 34.0908771 | 397 | 1.8652904
***End Of File*** | RedCat [NAME]