script that displays coffees sold by hour at lca2015. Currently it opens a .json file and converts it into a python dict.
It's missing monday data.
sale by hour is: key - the hour (24hr). Value is total paid sales (people who ran out of vouchers). Number in brackets is total number of coffees sold.
Number in brackets - Number not in brackets = amount of coffees sold with vouchers.
Each sale[day].json file contains a json objects. Important keys/values are:
Product : cappuccino/flat white etc...
Tags : These are taged with coffee followed by ; and if its free ;.
count : amount of these coffees sold.
SKU : ? guess its a ID?
Sales ($) : Amount of dollars from selling coffee
Tax ($) : Amount of tax paid from selling the coffee
Revenue : This is Sales + Tax
Costs ($) : Cost to make the coffees.
Revenue ($) : Amount of revenue made from selling the coffee
Margin ($) : Percent of money made from selling coffee.
There are other keys but the value of them is empty. No point dealing with them.
Open up all the sale[day].json files and create a all salesfile. Append all together.
In [80]:
import json
import os
import pandas
import getpass
In [81]:
theuser = getpass.getuser()
Need to open all the sale[day].json files and append data.
In [117]:
jsonfold = ('/home/' + theuser + '/github/lcacoffee/')
alldata = ('salebyhour.json')
tueda = ('saletues.json')
weda = ('saleweds.json')
thura = ('salethurs.json')
fria = ('salefri.json')
salhr = (jsonfold + alldata)
salajs = ('/home/wcmckee/cofres/salesall.json')
In [83]:
lisz = [tueda, weda, thura, fria]
opaz = open('/home/wcmckee/cofres/salesall.json', 'w')
filza = ('/home/' + theuser + '/github/lcacoffee/' + lis)
In [118]:
for lis in lisz:
opaz = open(salajs, 'a')
print ('/home/' + theuser + '/github/lcacoffee/' + lis)
opdayz = open(filza, 'r')
opaz.write(str(opdayz.read()))
opaz.close()
opdayz.close()
/home/wcmckee/github/lcacoffee/saletues.json
/home/wcmckee/github/lcacoffee/saleweds.json
/home/wcmckee/github/lcacoffee/salethurs.json
/home/wcmckee/github/lcacoffee/salefri.json
In [85]:
opaz.close()
In [119]:
opzall = open(salajs, 'r')
The daysales appended into the allsales file are in fact lists.
Options include removing the lists and turning it all into one big json object
Appending all the data into one day.
eg: Product: "cappuccino" Count: 450 (total of week).
File needs steriozie removing the \n
In [120]:
opzall.read()
Out[120]:
'[\r\n {\r\n "Outlet":"LCA",\r\n "Product":"Cappuccino",\r\n "SKU": 10001,\r\n "Brand":" ",\r\n "Supplier":" ",\r\n "Type":" ",\r\n "Tags":" coffee",\r\n "Supplier Code":" ",\r\n "Count": 13,\r\n "Sales ($)": 45.2173800000,\r\n "Tax ($)": 6.7826200000,\r\n "Sales incl. tax ($)": 52.00,\r\n "Discount ($)": 0,\r\n "Cost ($)": 13.0000000000,\r\n "Revenue ($)": 32.2173800000,\r\n "Margin (%)": 71.24\r\n },\r\n {\r\n "Outlet":"",\r\n "Product":"Cappuccino FREE",\r\n "SKU": 10009,\r\n "Brand":" ",\r\n "Supplier":" ",\r\n "Type":" ",\r\n "Tags":" coffee; free",\r\n "Supplier Code":" ",\r\n "Count": 63,\r\n "Sales ($)": 0.0000000000,\r\n "Tax ($)": 0.0000000000,\r\n "Sales incl. tax ($)": 0.00,\r\n "Discount ($)": 0,\r\n "Cost ($)": 0.0000000000,\r\n "Revenue ($)": 0.0000000000,\r\n "Margin (%)": 0.00\r\n },\r\n {\r\n "Outlet":"",\r\n "Product":"Chai Latte",\r\n "SKU": 10003,\r\n "Brand":" ",\r\n "Supplier":" ",\r\n "Type":" ",\r\n "Tags":" coffee",\r\n "Supplier Code":" ",\r\n "Count": 1,\r\n "Sales ($)": 3.4782600000,\r\n "Tax ($)": 0.5217400000,\r\n "Sales incl. tax ($)": 4.00,\r\n "Discount ($)": 0,\r\n "Cost ($)": 1.0000000000,\r\n "Revenue ($)": 2.4782600000,\r\n "Margin (%)": 71.24\r\n },\r\n {\r\n "Outlet":"",\r\n "Product":"Chai Latte FREE",\r\n "SKU": 10010,\r\n "Brand":" ",\r\n "Supplier":" ",\r\n "Type":" ",\r\n "Tags":" coffee; free",\r\n "Supplier Code":" ",\r\n "Count": 9,\r\n "Sales ($)": 0.0000000000,\r\n "Tax ($)": 0.0000000000,\r\n "Sales incl. tax ($)": 0.00,\r\n "Discount ($)": 0,\r\n "Cost ($)": 0.0000000000,\r\n "Revenue ($)": 0.0000000000,\r\n "Margin (%)": 0.00\r\n },\r\n {\r\n "Outlet":"",\r\n "Product":"Espresso FREE",\r\n "SKU": 10032,\r\n "Brand":" ",\r\n "Supplier":" ",\r\n "Type":" ",\r\n "Tags":" ",\r\n "Supplier Code":" ",\r\n "Count": 14,\r\n "Sales ($)": 0.0000000000,\r\n "Tax ($)": 0.0000000000,\r\n "Sales incl. tax ($)": 0.00,\r\n "Discount ($)": 0,\r\n "Cost ($)": 0.0000000000,\r\n "Revenue ($)": 0.0000000000,\r\n "Margin (%)": 0.00\r\n },\r\n {\r\n "Outlet":"",\r\n "Product":"Flat White",\r\n "SKU": 10000,\r\n "Brand":" ",\r\n "Supplier":" ",\r\n "Type":" ",\r\n "Tags":" coffee",\r\n "Supplier Code":" ",\r\n "Count": 57,\r\n "Sales ($)": 198.2608200000,\r\n "Tax ($)": 29.7391800000,\r\n "Sales incl. tax ($)": 228.00,\r\n "Discount ($)": 0,\r\n "Cost ($)": 57.0000000000,\r\n "Revenue ($)": 141.2608200000,\r\n "Margin (%)": 71.24\r\n },\r\n {\r\n "Outlet":"",\r\n "Product":"Flat White FREE",\r\n "SKU": 10011,\r\n "Brand":" ",\r\n "Supplier":" ",\r\n "Type":" ",\r\n "Tags":" coffee; free",\r\n "Supplier Code":" ",\r\n "Count": 249,\r\n "Sales ($)": 0.0000000000,\r\n "Tax ($)": 0.0000000000,\r\n "Sales incl. tax ($)": 0.00,\r\n "Discount ($)": 0,\r\n "Cost ($)": 0.0000000000,\r\n "Revenue ($)": 0.0000000000,\r\n "Margin (%)": 0.00\r\n },\r\n {\r\n "Outlet":"",\r\n "Product":"Hot Chocolate",\r\n "SKU": 10005,\r\n "Brand":" ",\r\n "Supplier":" ",\r\n "Type":" ",\r\n "Tags":" coffee",\r\n "Supplier Code":" ",\r\n "Count": 7,\r\n "Sales ($)": 24.3478200000,\r\n "Tax ($)": 3.6521800000,\r\n "Sales incl. tax ($)": 28.00,\r\n "Discount ($)": 0,\r\n "Cost ($)": 7.0000000000,\r\n "Revenue ($)": 17.3478200000,\r\n "Margin (%)": 71.24\r\n },\r\n {\r\n "Outlet":"",\r\n "Product":"Hot Chocolate FREE",\r\n "SKU": 10012,\r\n "Brand":" ",\r\n "Supplier":" ",\r\n "Type":" ",\r\n "Tags":" coffee; free",\r\n "Supplier Code":" ",\r\n "Count": 121,\r\n "Sales ($)": 0.0000000000,\r\n "Tax ($)": 0.0000000000,\r\n "Sales incl. tax ($)": 0.00,\r\n "Discount ($)": 0,\r\n "Cost ($)": 0.0000000000,\r\n "Revenue ($)": 0.0000000000,\r\n "Margin (%)": 0.00\r\n },\r\n {\r\n "Outlet":"",\r\n "Product":"Long Black",\r\n "SKU": 10006,\r\n "Brand":" ",\r\n "Supplier":" ",\r\n "Type":" ",\r\n "Tags":" coffee",\r\n "Supplier Code":" ",\r\n "Count": 25,\r\n "Sales ($)": 86.9565000000,\r\n "Tax ($)": 13.0435000000,\r\n "Sales incl. tax ($)": 100.00,\r\n "Discount ($)": 0,\r\n "Cost ($)": 25.0000000000,\r\n "Revenue ($)": 61.9565000000,\r\n "Margin (%)": 71.24\r\n },\r\n {\r\n "Outlet":"",\r\n "Product":"Long Black FREE",\r\n "SKU": 10014,\r\n "Brand":" ",\r\n "Supplier":" ",\r\n "Type":" ",\r\n "Tags":" coffee; free",\r\n "Supplier Code":" ",\r\n "Count": 62,\r\n "Sales ($)": 0.0000000000,\r\n "Tax ($)": 0.0000000000,\r\n "Sales incl. tax ($)": 0.00,\r\n "Discount ($)": 0,\r\n "Cost ($)": 0.0000000000,\r\n "Revenue ($)": 0.0000000000,\r\n "Margin (%)": 0.00\r\n },\r\n {\r\n "Outlet":"",\r\n "Product":"Mocha",\r\n "SKU": 10004,\r\n "Brand":" ",\r\n "Supplier":" ",\r\n "Type":" ",\r\n "Tags":" coffee",\r\n "Supplier Code":" ",\r\n "Count": 13,\r\n "Sales ($)": 45.2173800000,\r\n "Tax ($)": 6.7826200000,\r\n "Sales incl. tax ($)": 52.00,\r\n "Discount ($)": 0,\r\n "Cost ($)": 13.0000000000,\r\n "Revenue ($)": 32.2173800000,\r\n "Margin (%)": 71.24\r\n },\r\n {\r\n "Outlet":"",\r\n "Product":"Mocha FREE",\r\n "SKU": 10015,\r\n "Brand":" ",\r\n "Supplier":" ",\r\n "Type":" ",\r\n "Tags":" coffee; free",\r\n "Supplier Code":" ",\r\n "Count": 81,\r\n "Sales ($)": 0.0000000000,\r\n "Tax ($)": 0.0000000000,\r\n "Sales incl. tax ($)": 0.00,\r\n "Discount ($)": 0,\r\n "Cost ($)": 0.0000000000,\r\n "Revenue ($)": 0.0000000000,\r\n "Margin (%)": 0.00\r\n },\r\n {\r\n "Outlet":"",\r\n "Product":"Total",\r\n "SKU":null,\r\n "Brand":"",\r\n "Supplier":"",\r\n "Type":"",\r\n "Tags":"",\r\n "Supplier Code":"",\r\n "Count":715.00,\r\n "Sales ($)": 403.44,\r\n "Tax ($)": 60.50,\r\n "Sales incl. tax ($)": 463.94,\r\n "Discount ($)": 0.00,\r\n "Cost ($)": 116.00,\r\n "Revenue ($)": 287.44,\r\n "Margin (%)": 71.24727\r\n },\r\n {\r\n "Outlet":"",\r\n "Product":"Grand Total",\r\n "SKU":null,\r\n "Brand":"",\r\n "Supplier":"",\r\n "Type":"",\r\n "Tags":"",\r\n "Supplier Code":"",\r\n "Count":715.00,\r\n "Sales ($)": 403.44,\r\n "Tax ($)": 60.50,\r\n "Sales incl. tax ($)": 463.94,\r\n "Discount ($)": 0.00,\r\n "Cost ($)": 116.00,\r\n "Revenue ($)": 287.44,\r\n "Margin (%)": 71.24727\r\n }\r\n][\r\n {\r\n "Outlet":"LCA",\r\n "Product":"Cappuccino",\r\n "SKU": 10001,\r\n "Brand":" ",\r\n "Supplier":" ",\r\n "Type":" ",\r\n "Tags":" coffee",\r\n "Supplier Code":" ",\r\n "Count": 13,\r\n "Sales ($)": 45.2173800000,\r\n "Tax ($)": 6.7826200000,\r\n "Sales incl. tax ($)": 52.00,\r\n "Discount ($)": 0,\r\n "Cost ($)": 13.0000000000,\r\n "Revenue ($)": 32.2173800000,\r\n "Margin (%)": 71.24\r\n },\r\n {\r\n "Outlet":"",\r\n "Product":"Cappuccino FREE",\r\n "SKU": 10009,\r\n "Brand":" ",\r\n "Supplier":" ",\r\n "Type":" ",\r\n "Tags":" coffee; free",\r\n "Supplier Code":" ",\r\n "Count": 63,\r\n "Sales ($)": 0.0000000000,\r\n "Tax ($)": 0.0000000000,\r\n "Sales incl. tax ($)": 0.00,\r\n "Discount ($)": 0,\r\n "Cost ($)": 0.0000000000,\r\n "Revenue ($)": 0.0000000000,\r\n "Margin (%)": 0.00\r\n },\r\n {\r\n "Outlet":"",\r\n "Product":"Chai Latte",\r\n "SKU": 10003,\r\n "Brand":" ",\r\n "Supplier":" ",\r\n "Type":" ",\r\n "Tags":" coffee",\r\n "Supplier Code":" ",\r\n "Count": 1,\r\n "Sales ($)": 3.4782600000,\r\n "Tax ($)": 0.5217400000,\r\n "Sales incl. tax ($)": 4.00,\r\n "Discount ($)": 0,\r\n "Cost ($)": 1.0000000000,\r\n "Revenue ($)": 2.4782600000,\r\n "Margin (%)": 71.24\r\n },\r\n {\r\n "Outlet":"",\r\n "Product":"Chai Latte FREE",\r\n "SKU": 10010,\r\n "Brand":" ",\r\n "Supplier":" ",\r\n "Type":" ",\r\n "Tags":" coffee; free",\r\n "Supplier Code":" ",\r\n "Count": 9,\r\n "Sales ($)": 0.0000000000,\r\n "Tax ($)": 0.0000000000,\r\n "Sales incl. tax ($)": 0.00,\r\n "Discount ($)": 0,\r\n "Cost ($)": 0.0000000000,\r\n "Revenue ($)": 0.0000000000,\r\n "Margin (%)": 0.00\r\n },\r\n {\r\n "Outlet":"",\r\n "Product":"Espresso FREE",\r\n "SKU": 10032,\r\n "Brand":" ",\r\n "Supplier":" ",\r\n "Type":" ",\r\n "Tags":" ",\r\n "Supplier Code":" ",\r\n "Count": 14,\r\n "Sales ($)": 0.0000000000,\r\n "Tax ($)": 0.0000000000,\r\n "Sales incl. tax ($)": 0.00,\r\n "Discount ($)": 0,\r\n "Cost ($)": 0.0000000000,\r\n "Revenue ($)": 0.0000000000,\r\n "Margin (%)": 0.00\r\n },\r\n {\r\n "Outlet":"",\r\n "Product":"Flat White",\r\n "SKU": 10000,\r\n "Brand":" ",\r\n "Supplier":" ",\r\n "Type":" ",\r\n "Tags":" coffee",\r\n "Supplier Code":" ",\r\n "Count": 57,\r\n "Sales ($)": 198.2608200000,\r\n "Tax ($)": 29.7391800000,\r\n "Sales incl. tax ($)": 228.00,\r\n "Discount ($)": 0,\r\n "Cost ($)": 57.0000000000,\r\n "Revenue ($)": 141.2608200000,\r\n "Margin (%)": 71.24\r\n },\r\n {\r\n "Outlet":"",\r\n "Product":"Flat White FREE",\r\n "SKU": 10011,\r\n "Brand":" ",\r\n "Supplier":" ",\r\n "Type":" ",\r\n "Tags":" coffee; free",\r\n "Supplier Code":" ",\r\n "Count": 249,\r\n "Sales ($)": 0.0000000000,\r\n "Tax ($)": 0.0000000000,\r\n "Sales incl. tax ($)": 0.00,\r\n "Discount ($)": 0,\r\n "Cost ($)": 0.0000000000,\r\n "Revenue ($)": 0.0000000000,\r\n "Margin (%)": 0.00\r\n },\r\n {\r\n "Outlet":"",\r\n "Product":"Hot Chocolate",\r\n "SKU": 10005,\r\n "Brand":" ",\r\n "Supplier":" ",\r\n "Type":" ",\r\n "Tags":" coffee",\r\n "Supplier Code":" ",\r\n "Count": 7,\r\n "Sales ($)": 24.3478200000,\r\n "Tax ($)": 3.6521800000,\r\n "Sales incl. tax ($)": 28.00,\r\n "Discount ($)": 0,\r\n "Cost ($)": 7.0000000000,\r\n "Revenue ($)": 17.3478200000,\r\n "Margin (%)": 71.24\r\n },\r\n {\r\n "Outlet":"",\r\n "Product":"Hot Chocolate FREE",\r\n "SKU": 10012,\r\n "Brand":" ",\r\n "Supplier":" ",\r\n "Type":" ",\r\n "Tags":" coffee; free",\r\n "Supplier Code":" ",\r\n "Count": 121,\r\n "Sales ($)": 0.0000000000,\r\n "Tax ($)": 0.0000000000,\r\n "Sales incl. tax ($)": 0.00,\r\n "Discount ($)": 0,\r\n "Cost ($)": 0.0000000000,\r\n "Revenue ($)": 0.0000000000,\r\n "Margin (%)": 0.00\r\n },\r\n {\r\n "Outlet":"",\r\n "Product":"Long Black",\r\n "SKU": 10006,\r\n "Brand":" ",\r\n "Supplier":" ",\r\n "Type":" ",\r\n "Tags":" coffee",\r\n "Supplier Code":" ",\r\n "Count": 25,\r\n "Sales ($)": 86.9565000000,\r\n "Tax ($)": 13.0435000000,\r\n "Sales incl. tax ($)": 100.00,\r\n "Discount ($)": 0,\r\n "Cost ($)": 25.0000000000,\r\n "Revenue ($)": 61.9565000000,\r\n "Margin (%)": 71.24\r\n },\r\n {\r\n "Outlet":"",\r\n "Product":"Long Black FREE",\r\n "SKU": 10014,\r\n "Brand":" ",\r\n "Supplier":" ",\r\n "Type":" ",\r\n "Tags":" coffee; free",\r\n "Supplier Code":" ",\r\n "Count": 62,\r\n "Sales ($)": 0.0000000000,\r\n "Tax ($)": 0.0000000000,\r\n "Sales incl. tax ($)": 0.00,\r\n "Discount ($)": 0,\r\n "Cost ($)": 0.0000000000,\r\n "Revenue ($)": 0.0000000000,\r\n "Margin (%)": 0.00\r\n },\r\n {\r\n "Outlet":"",\r\n "Product":"Mocha",\r\n "SKU": 10004,\r\n "Brand":" ",\r\n "Supplier":" ",\r\n "Type":" ",\r\n "Tags":" coffee",\r\n "Supplier Code":" ",\r\n "Count": 13,\r\n "Sales ($)": 45.2173800000,\r\n "Tax ($)": 6.7826200000,\r\n "Sales incl. tax ($)": 52.00,\r\n "Discount ($)": 0,\r\n "Cost ($)": 13.0000000000,\r\n "Revenue ($)": 32.2173800000,\r\n "Margin (%)": 71.24\r\n },\r\n {\r\n "Outlet":"",\r\n "Product":"Mocha FREE",\r\n "SKU": 10015,\r\n "Brand":" ",\r\n "Supplier":" ",\r\n "Type":" ",\r\n "Tags":" coffee; free",\r\n "Supplier Code":" ",\r\n "Count": 81,\r\n "Sales ($)": 0.0000000000,\r\n "Tax ($)": 0.0000000000,\r\n "Sales incl. tax ($)": 0.00,\r\n "Discount ($)": 0,\r\n "Cost ($)": 0.0000000000,\r\n "Revenue ($)": 0.0000000000,\r\n "Margin (%)": 0.00\r\n },\r\n {\r\n "Outlet":"",\r\n "Product":"Total",\r\n "SKU":null,\r\n "Brand":"",\r\n "Supplier":"",\r\n "Type":"",\r\n "Tags":"",\r\n "Supplier Code":"",\r\n "Count":715.00,\r\n "Sales ($)": 403.44,\r\n "Tax ($)": 60.50,\r\n "Sales incl. tax ($)": 463.94,\r\n "Discount ($)": 0.00,\r\n "Cost ($)": 116.00,\r\n "Revenue ($)": 287.44,\r\n "Margin (%)": 71.24727\r\n },\r\n {\r\n "Outlet":"",\r\n "Product":"Grand Total",\r\n "SKU":null,\r\n "Brand":"",\r\n "Supplier":"",\r\n "Type":"",\r\n "Tags":"",\r\n "Supplier Code":"",\r\n "Count":715.00,\r\n "Sales ($)": 403.44,\r\n "Tax ($)": 60.50,\r\n "Sales incl. tax ($)": 463.94,\r\n "Discount ($)": 0.00,\r\n "Cost ($)": 116.00,\r\n "Revenue ($)": 287.44,\r\n "Margin (%)": 71.24727\r\n }\r\n][\r\n {\r\n "Outlet":"LCA",\r\n "Product":"Cappuccino",\r\n "SKU": 10001,\r\n "Brand":" ",\r\n "Supplier":" ",\r\n "Type":" ",\r\n "Tags":" coffee",\r\n "Supplier Code":" ",\r\n "Count": 13,\r\n "Sales ($)": 45.2173800000,\r\n "Tax ($)": 6.7826200000,\r\n "Sales incl. tax ($)": 52.00,\r\n "Discount ($)": 0,\r\n "Cost ($)": 13.0000000000,\r\n "Revenue ($)": 32.2173800000,\r\n "Margin (%)": 71.24\r\n },\r\n {\r\n "Outlet":"",\r\n "Product":"Cappuccino FREE",\r\n "SKU": 10009,\r\n "Brand":" ",\r\n "Supplier":" ",\r\n "Type":" ",\r\n "Tags":" coffee; free",\r\n "Supplier Code":" ",\r\n "Count": 63,\r\n "Sales ($)": 0.0000000000,\r\n "Tax ($)": 0.0000000000,\r\n "Sales incl. tax ($)": 0.00,\r\n "Discount ($)": 0,\r\n "Cost ($)": 0.0000000000,\r\n "Revenue ($)": 0.0000000000,\r\n "Margin (%)": 0.00\r\n },\r\n {\r\n "Outlet":"",\r\n "Product":"Chai Latte",\r\n "SKU": 10003,\r\n "Brand":" ",\r\n "Supplier":" ",\r\n "Type":" ",\r\n "Tags":" coffee",\r\n "Supplier Code":" ",\r\n "Count": 1,\r\n "Sales ($)": 3.4782600000,\r\n "Tax ($)": 0.5217400000,\r\n "Sales incl. tax ($)": 4.00,\r\n "Discount ($)": 0,\r\n "Cost ($)": 1.0000000000,\r\n "Revenue ($)": 2.4782600000,\r\n "Margin (%)": 71.24\r\n },\r\n {\r\n "Outlet":"",\r\n "Product":"Chai Latte FREE",\r\n "SKU": 10010,\r\n "Brand":" ",\r\n "Supplier":" ",\r\n "Type":" ",\r\n "Tags":" coffee; free",\r\n "Supplier Code":" ",\r\n "Count": 9,\r\n "Sales ($)": 0.0000000000,\r\n "Tax ($)": 0.0000000000,\r\n "Sales incl. tax ($)": 0.00,\r\n "Discount ($)": 0,\r\n "Cost ($)": 0.0000000000,\r\n "Revenue ($)": 0.0000000000,\r\n "Margin (%)": 0.00\r\n },\r\n {\r\n "Outlet":"",\r\n "Product":"Espresso FREE",\r\n "SKU": 10032,\r\n "Brand":" ",\r\n "Supplier":" ",\r\n "Type":" ",\r\n "Tags":" ",\r\n "Supplier Code":" ",\r\n "Count": 14,\r\n "Sales ($)": 0.0000000000,\r\n "Tax ($)": 0.0000000000,\r\n "Sales incl. tax ($)": 0.00,\r\n "Discount ($)": 0,\r\n "Cost ($)": 0.0000000000,\r\n "Revenue ($)": 0.0000000000,\r\n "Margin (%)": 0.00\r\n },\r\n {\r\n "Outlet":"",\r\n "Product":"Flat White",\r\n "SKU": 10000,\r\n "Brand":" ",\r\n "Supplier":" ",\r\n "Type":" ",\r\n "Tags":" coffee",\r\n "Supplier Code":" ",\r\n "Count": 57,\r\n "Sales ($)": 198.2608200000,\r\n "Tax ($)": 29.7391800000,\r\n "Sales incl. tax ($)": 228.00,\r\n "Discount ($)": 0,\r\n "Cost ($)": 57.0000000000,\r\n "Revenue ($)": 141.2608200000,\r\n "Margin (%)": 71.24\r\n },\r\n {\r\n "Outlet":"",\r\n "Product":"Flat White FREE",\r\n "SKU": 10011,\r\n "Brand":" ",\r\n "Supplier":" ",\r\n "Type":" ",\r\n "Tags":" coffee; free",\r\n "Supplier Code":" ",\r\n "Count": 249,\r\n "Sales ($)": 0.0000000000,\r\n "Tax ($)": 0.0000000000,\r\n "Sales incl. tax ($)": 0.00,\r\n "Discount ($)": 0,\r\n "Cost ($)": 0.0000000000,\r\n "Revenue ($)": 0.0000000000,\r\n "Margin (%)": 0.00\r\n },\r\n {\r\n "Outlet":"",\r\n "Product":"Hot Chocolate",\r\n "SKU": 10005,\r\n "Brand":" ",\r\n "Supplier":" ",\r\n "Type":" ",\r\n "Tags":" coffee",\r\n "Supplier Code":" ",\r\n "Count": 7,\r\n "Sales ($)": 24.3478200000,\r\n "Tax ($)": 3.6521800000,\r\n "Sales incl. tax ($)": 28.00,\r\n "Discount ($)": 0,\r\n "Cost ($)": 7.0000000000,\r\n "Revenue ($)": 17.3478200000,\r\n "Margin (%)": 71.24\r\n },\r\n {\r\n "Outlet":"",\r\n "Product":"Hot Chocolate FREE",\r\n "SKU": 10012,\r\n "Brand":" ",\r\n "Supplier":" ",\r\n "Type":" ",\r\n "Tags":" coffee; free",\r\n "Supplier Code":" ",\r\n "Count": 121,\r\n "Sales ($)": 0.0000000000,\r\n "Tax ($)": 0.0000000000,\r\n "Sales incl. tax ($)": 0.00,\r\n "Discount ($)": 0,\r\n "Cost ($)": 0.0000000000,\r\n "Revenue ($)": 0.0000000000,\r\n "Margin (%)": 0.00\r\n },\r\n {\r\n "Outlet":"",\r\n "Product":"Long Black",\r\n "SKU": 10006,\r\n "Brand":" ",\r\n "Supplier":" ",\r\n "Type":" ",\r\n "Tags":" coffee",\r\n "Supplier Code":" ",\r\n "Count": 25,\r\n "Sales ($)": 86.9565000000,\r\n "Tax ($)": 13.0435000000,\r\n "Sales incl. tax ($)": 100.00,\r\n "Discount ($)": 0,\r\n "Cost ($)": 25.0000000000,\r\n "Revenue ($)": 61.9565000000,\r\n "Margin (%)": 71.24\r\n },\r\n {\r\n "Outlet":"",\r\n "Product":"Long Black FREE",\r\n "SKU": 10014,\r\n "Brand":" ",\r\n "Supplier":" ",\r\n "Type":" ",\r\n "Tags":" coffee; free",\r\n "Supplier Code":" ",\r\n "Count": 62,\r\n "Sales ($)": 0.0000000000,\r\n "Tax ($)": 0.0000000000,\r\n "Sales incl. tax ($)": 0.00,\r\n "Discount ($)": 0,\r\n "Cost ($)": 0.0000000000,\r\n "Revenue ($)": 0.0000000000,\r\n "Margin (%)": 0.00\r\n },\r\n {\r\n "Outlet":"",\r\n "Product":"Mocha",\r\n "SKU": 10004,\r\n "Brand":" ",\r\n "Supplier":" ",\r\n "Type":" ",\r\n "Tags":" coffee",\r\n "Supplier Code":" ",\r\n "Count": 13,\r\n "Sales ($)": 45.2173800000,\r\n "Tax ($)": 6.7826200000,\r\n "Sales incl. tax ($)": 52.00,\r\n "Discount ($)": 0,\r\n "Cost ($)": 13.0000000000,\r\n "Revenue ($)": 32.2173800000,\r\n "Margin (%)": 71.24\r\n },\r\n {\r\n "Outlet":"",\r\n "Product":"Mocha FREE",\r\n "SKU": 10015,\r\n "Brand":" ",\r\n "Supplier":" ",\r\n "Type":" ",\r\n "Tags":" coffee; free",\r\n "Supplier Code":" ",\r\n "Count": 81,\r\n "Sales ($)": 0.0000000000,\r\n "Tax ($)": 0.0000000000,\r\n "Sales incl. tax ($)": 0.00,\r\n "Discount ($)": 0,\r\n "Cost ($)": 0.0000000000,\r\n "Revenue ($)": 0.0000000000,\r\n "Margin (%)": 0.00\r\n },\r\n {\r\n "Outlet":"",\r\n "Product":"Total",\r\n "SKU":null,\r\n "Brand":"",\r\n "Supplier":"",\r\n "Type":"",\r\n "Tags":"",\r\n "Supplier Code":"",\r\n "Count":715.00,\r\n "Sales ($)": 403.44,\r\n "Tax ($)": 60.50,\r\n "Sales incl. tax ($)": 463.94,\r\n "Discount ($)": 0.00,\r\n "Cost ($)": 116.00,\r\n "Revenue ($)": 287.44,\r\n "Margin (%)": 71.24727\r\n },\r\n {\r\n "Outlet":"",\r\n "Product":"Grand Total",\r\n "SKU":null,\r\n "Brand":"",\r\n "Supplier":"",\r\n "Type":"",\r\n "Tags":"",\r\n "Supplier Code":"",\r\n "Count":715.00,\r\n "Sales ($)": 403.44,\r\n "Tax ($)": 60.50,\r\n "Sales incl. tax ($)": 463.94,\r\n "Discount ($)": 0.00,\r\n "Cost ($)": 116.00,\r\n "Revenue ($)": 287.44,\r\n "Margin (%)": 71.24727\r\n }\r\n][\r\n {\r\n "Outlet":"LCA",\r\n "Product":"Cappuccino",\r\n "SKU": 10001,\r\n "Brand":" ",\r\n "Supplier":" ",\r\n "Type":" ",\r\n "Tags":" coffee",\r\n "Supplier Code":" ",\r\n "Count": 13,\r\n "Sales ($)": 45.2173800000,\r\n "Tax ($)": 6.7826200000,\r\n "Sales incl. tax ($)": 52.00,\r\n "Discount ($)": 0,\r\n "Cost ($)": 13.0000000000,\r\n "Revenue ($)": 32.2173800000,\r\n "Margin (%)": 71.24\r\n },\r\n {\r\n "Outlet":"",\r\n "Product":"Cappuccino FREE",\r\n "SKU": 10009,\r\n "Brand":" ",\r\n "Supplier":" ",\r\n "Type":" ",\r\n "Tags":" coffee; free",\r\n "Supplier Code":" ",\r\n "Count": 63,\r\n "Sales ($)": 0.0000000000,\r\n "Tax ($)": 0.0000000000,\r\n "Sales incl. tax ($)": 0.00,\r\n "Discount ($)": 0,\r\n "Cost ($)": 0.0000000000,\r\n "Revenue ($)": 0.0000000000,\r\n "Margin (%)": 0.00\r\n },\r\n {\r\n "Outlet":"",\r\n "Product":"Chai Latte",\r\n "SKU": 10003,\r\n "Brand":" ",\r\n "Supplier":" ",\r\n "Type":" ",\r\n "Tags":" coffee",\r\n "Supplier Code":" ",\r\n "Count": 1,\r\n "Sales ($)": 3.4782600000,\r\n "Tax ($)": 0.5217400000,\r\n "Sales incl. tax ($)": 4.00,\r\n "Discount ($)": 0,\r\n "Cost ($)": 1.0000000000,\r\n "Revenue ($)": 2.4782600000,\r\n "Margin (%)": 71.24\r\n },\r\n {\r\n "Outlet":"",\r\n "Product":"Chai Latte FREE",\r\n "SKU": 10010,\r\n "Brand":" ",\r\n "Supplier":" ",\r\n "Type":" ",\r\n "Tags":" coffee; free",\r\n "Supplier Code":" ",\r\n "Count": 9,\r\n "Sales ($)": 0.0000000000,\r\n "Tax ($)": 0.0000000000,\r\n "Sales incl. tax ($)": 0.00,\r\n "Discount ($)": 0,\r\n "Cost ($)": 0.0000000000,\r\n "Revenue ($)": 0.0000000000,\r\n "Margin (%)": 0.00\r\n },\r\n {\r\n "Outlet":"",\r\n "Product":"Espresso FREE",\r\n "SKU": 10032,\r\n "Brand":" ",\r\n "Supplier":" ",\r\n "Type":" ",\r\n "Tags":" ",\r\n "Supplier Code":" ",\r\n "Count": 14,\r\n "Sales ($)": 0.0000000000,\r\n "Tax ($)": 0.0000000000,\r\n "Sales incl. tax ($)": 0.00,\r\n "Discount ($)": 0,\r\n "Cost ($)": 0.0000000000,\r\n "Revenue ($)": 0.0000000000,\r\n "Margin (%)": 0.00\r\n },\r\n {\r\n "Outlet":"",\r\n "Product":"Flat White",\r\n "SKU": 10000,\r\n "Brand":" ",\r\n "Supplier":" ",\r\n "Type":" ",\r\n "Tags":" coffee",\r\n "Supplier Code":" ",\r\n "Count": 57,\r\n "Sales ($)": 198.2608200000,\r\n "Tax ($)": 29.7391800000,\r\n "Sales incl. tax ($)": 228.00,\r\n "Discount ($)": 0,\r\n "Cost ($)": 57.0000000000,\r\n "Revenue ($)": 141.2608200000,\r\n "Margin (%)": 71.24\r\n },\r\n {\r\n "Outlet":"",\r\n "Product":"Flat White FREE",\r\n "SKU": 10011,\r\n "Brand":" ",\r\n "Supplier":" ",\r\n "Type":" ",\r\n "Tags":" coffee; free",\r\n "Supplier Code":" ",\r\n "Count": 249,\r\n "Sales ($)": 0.0000000000,\r\n "Tax ($)": 0.0000000000,\r\n "Sales incl. tax ($)": 0.00,\r\n "Discount ($)": 0,\r\n "Cost ($)": 0.0000000000,\r\n "Revenue ($)": 0.0000000000,\r\n "Margin (%)": 0.00\r\n },\r\n {\r\n "Outlet":"",\r\n "Product":"Hot Chocolate",\r\n "SKU": 10005,\r\n "Brand":" ",\r\n "Supplier":" ",\r\n "Type":" ",\r\n "Tags":" coffee",\r\n "Supplier Code":" ",\r\n "Count": 7,\r\n "Sales ($)": 24.3478200000,\r\n "Tax ($)": 3.6521800000,\r\n "Sales incl. tax ($)": 28.00,\r\n "Discount ($)": 0,\r\n "Cost ($)": 7.0000000000,\r\n "Revenue ($)": 17.3478200000,\r\n "Margin (%)": 71.24\r\n },\r\n {\r\n "Outlet":"",\r\n "Product":"Hot Chocolate FREE",\r\n "SKU": 10012,\r\n "Brand":" ",\r\n "Supplier":" ",\r\n "Type":" ",\r\n "Tags":" coffee; free",\r\n "Supplier Code":" ",\r\n "Count": 121,\r\n "Sales ($)": 0.0000000000,\r\n "Tax ($)": 0.0000000000,\r\n "Sales incl. tax ($)": 0.00,\r\n "Discount ($)": 0,\r\n "Cost ($)": 0.0000000000,\r\n "Revenue ($)": 0.0000000000,\r\n "Margin (%)": 0.00\r\n },\r\n {\r\n "Outlet":"",\r\n "Product":"Long Black",\r\n "SKU": 10006,\r\n "Brand":" ",\r\n "Supplier":" ",\r\n "Type":" ",\r\n "Tags":" coffee",\r\n "Supplier Code":" ",\r\n "Count": 25,\r\n "Sales ($)": 86.9565000000,\r\n "Tax ($)": 13.0435000000,\r\n "Sales incl. tax ($)": 100.00,\r\n "Discount ($)": 0,\r\n "Cost ($)": 25.0000000000,\r\n "Revenue ($)": 61.9565000000,\r\n "Margin (%)": 71.24\r\n },\r\n {\r\n "Outlet":"",\r\n "Product":"Long Black FREE",\r\n "SKU": 10014,\r\n "Brand":" ",\r\n "Supplier":" ",\r\n "Type":" ",\r\n "Tags":" coffee; free",\r\n "Supplier Code":" ",\r\n "Count": 62,\r\n "Sales ($)": 0.0000000000,\r\n "Tax ($)": 0.0000000000,\r\n "Sales incl. tax ($)": 0.00,\r\n "Discount ($)": 0,\r\n "Cost ($)": 0.0000000000,\r\n "Revenue ($)": 0.0000000000,\r\n "Margin (%)": 0.00\r\n },\r\n {\r\n "Outlet":"",\r\n "Product":"Mocha",\r\n "SKU": 10004,\r\n "Brand":" ",\r\n "Supplier":" ",\r\n "Type":" ",\r\n "Tags":" coffee",\r\n "Supplier Code":" ",\r\n "Count": 13,\r\n "Sales ($)": 45.2173800000,\r\n "Tax ($)": 6.7826200000,\r\n "Sales incl. tax ($)": 52.00,\r\n "Discount ($)": 0,\r\n "Cost ($)": 13.0000000000,\r\n "Revenue ($)": 32.2173800000,\r\n "Margin (%)": 71.24\r\n },\r\n {\r\n "Outlet":"",\r\n "Product":"Mocha FREE",\r\n "SKU": 10015,\r\n "Brand":" ",\r\n "Supplier":" ",\r\n "Type":" ",\r\n "Tags":" coffee; free",\r\n "Supplier Code":" ",\r\n "Count": 81,\r\n "Sales ($)": 0.0000000000,\r\n "Tax ($)": 0.0000000000,\r\n "Sales incl. tax ($)": 0.00,\r\n "Discount ($)": 0,\r\n "Cost ($)": 0.0000000000,\r\n "Revenue ($)": 0.0000000000,\r\n "Margin (%)": 0.00\r\n },\r\n {\r\n "Outlet":"",\r\n "Product":"Total",\r\n "SKU":null,\r\n "Brand":"",\r\n "Supplier":"",\r\n "Type":"",\r\n "Tags":"",\r\n "Supplier Code":"",\r\n "Count":715.00,\r\n "Sales ($)": 403.44,\r\n "Tax ($)": 60.50,\r\n "Sales incl. tax ($)": 463.94,\r\n "Discount ($)": 0.00,\r\n "Cost ($)": 116.00,\r\n "Revenue ($)": 287.44,\r\n "Margin (%)": 71.24727\r\n },\r\n {\r\n "Outlet":"",\r\n "Product":"Grand Total",\r\n "SKU":null,\r\n "Brand":"",\r\n "Supplier":"",\r\n "Type":"",\r\n "Tags":"",\r\n "Supplier Code":"",\r\n "Count":715.00,\r\n "Sales ($)": 403.44,\r\n "Tax ($)": 60.50,\r\n "Sales incl. tax ($)": 463.94,\r\n "Discount ($)": 0.00,\r\n "Cost ($)": 116.00,\r\n "Revenue ($)": 287.44,\r\n "Margin (%)": 71.24727\r\n }\r\n][\r\n {\r\n "Outlet":"LCA",\r\n "Product":"Cappuccino",\r\n "SKU": 10001,\r\n "Brand":" ",\r\n "Supplier":" ",\r\n "Type":" ",\r\n "Tags":" coffee",\r\n "Supplier Code":" ",\r\n "Count": 13,\r\n "Sales ($)": 45.2173800000,\r\n "Tax ($)": 6.7826200000,\r\n "Sales incl. tax ($)": 52.00,\r\n "Discount ($)": 0,\r\n "Cost ($)": 13.0000000000,\r\n "Revenue ($)": 32.2173800000,\r\n "Margin (%)": 71.24\r\n },\r\n {\r\n "Outlet":"",\r\n "Product":"Cappuccino FREE",\r\n "SKU": 10009,\r\n "Brand":" ",\r\n "Supplier":" ",\r\n "Type":" ",\r\n "Tags":" coffee; free",\r\n "Supplier Code":" ",\r\n "Count": 63,\r\n "Sales ($)": 0.0000000000,\r\n "Tax ($)": 0.0000000000,\r\n "Sales incl. tax ($)": 0.00,\r\n "Discount ($)": 0,\r\n "Cost ($)": 0.0000000000,\r\n "Revenue ($)": 0.0000000000,\r\n "Margin (%)": 0.00\r\n },\r\n {\r\n "Outlet":"",\r\n "Product":"Chai Latte",\r\n "SKU": 10003,\r\n "Brand":" ",\r\n "Supplier":" ",\r\n "Type":" ",\r\n "Tags":" coffee",\r\n "Supplier Code":" ",\r\n "Count": 1,\r\n "Sales ($)": 3.4782600000,\r\n "Tax ($)": 0.5217400000,\r\n "Sales incl. tax ($)": 4.00,\r\n "Discount ($)": 0,\r\n "Cost ($)": 1.0000000000,\r\n "Revenue ($)": 2.4782600000,\r\n "Margin (%)": 71.24\r\n },\r\n {\r\n "Outlet":"",\r\n "Product":"Chai Latte FREE",\r\n "SKU": 10010,\r\n "Brand":" ",\r\n "Supplier":" ",\r\n "Type":" ",\r\n "Tags":" coffee; free",\r\n "Supplier Code":" ",\r\n "Count": 9,\r\n "Sales ($)": 0.0000000000,\r\n "Tax ($)": 0.0000000000,\r\n "Sales incl. tax ($)": 0.00,\r\n "Discount ($)": 0,\r\n "Cost ($)": 0.0000000000,\r\n "Revenue ($)": 0.0000000000,\r\n "Margin (%)": 0.00\r\n },\r\n {\r\n "Outlet":"",\r\n "Product":"Espresso FREE",\r\n "SKU": 10032,\r\n "Brand":" ",\r\n "Supplier":" ",\r\n "Type":" ",\r\n "Tags":" ",\r\n "Supplier Code":" ",\r\n "Count": 14,\r\n "Sales ($)": 0.0000000000,\r\n "Tax ($)": 0.0000000000,\r\n "Sales incl. tax ($)": 0.00,\r\n "Discount ($)": 0,\r\n "Cost ($)": 0.0000000000,\r\n "Revenue ($)": 0.0000000000,\r\n "Margin (%)": 0.00\r\n },\r\n {\r\n "Outlet":"",\r\n "Product":"Flat White",\r\n "SKU": 10000,\r\n "Brand":" ",\r\n "Supplier":" ",\r\n "Type":" ",\r\n "Tags":" coffee",\r\n "Supplier Code":" ",\r\n "Count": 57,\r\n "Sales ($)": 198.2608200000,\r\n "Tax ($)": 29.7391800000,\r\n "Sales incl. tax ($)": 228.00,\r\n "Discount ($)": 0,\r\n "Cost ($)": 57.0000000000,\r\n "Revenue ($)": 141.2608200000,\r\n "Margin (%)": 71.24\r\n },\r\n {\r\n "Outlet":"",\r\n "Product":"Flat White FREE",\r\n "SKU": 10011,\r\n "Brand":" ",\r\n "Supplier":" ",\r\n "Type":" ",\r\n "Tags":" coffee; free",\r\n "Supplier Code":" ",\r\n "Count": 249,\r\n "Sales ($)": 0.0000000000,\r\n "Tax ($)": 0.0000000000,\r\n "Sales incl. tax ($)": 0.00,\r\n "Discount ($)": 0,\r\n "Cost ($)": 0.0000000000,\r\n "Revenue ($)": 0.0000000000,\r\n "Margin (%)": 0.00\r\n },\r\n {\r\n "Outlet":"",\r\n "Product":"Hot Chocolate",\r\n "SKU": 10005,\r\n "Brand":" ",\r\n "Supplier":" ",\r\n "Type":" ",\r\n "Tags":" coffee",\r\n "Supplier Code":" ",\r\n "Count": 7,\r\n "Sales ($)": 24.3478200000,\r\n "Tax ($)": 3.6521800000,\r\n "Sales incl. tax ($)": 28.00,\r\n "Discount ($)": 0,\r\n "Cost ($)": 7.0000000000,\r\n "Revenue ($)": 17.3478200000,\r\n "Margin (%)": 71.24\r\n },\r\n {\r\n "Outlet":"",\r\n "Product":"Hot Chocolate FREE",\r\n "SKU": 10012,\r\n "Brand":" ",\r\n "Supplier":" ",\r\n "Type":" ",\r\n "Tags":" coffee; free",\r\n "Supplier Code":" ",\r\n "Count": 121,\r\n "Sales ($)": 0.0000000000,\r\n "Tax ($)": 0.0000000000,\r\n "Sales incl. tax ($)": 0.00,\r\n "Discount ($)": 0,\r\n "Cost ($)": 0.0000000000,\r\n "Revenue ($)": 0.0000000000,\r\n "Margin (%)": 0.00\r\n },\r\n {\r\n "Outlet":"",\r\n "Product":"Long Black",\r\n "SKU": 10006,\r\n "Brand":" ",\r\n "Supplier":" ",\r\n "Type":" ",\r\n "Tags":" coffee",\r\n "Supplier Code":" ",\r\n "Count": 25,\r\n "Sales ($)": 86.9565000000,\r\n "Tax ($)": 13.0435000000,\r\n "Sales incl. tax ($)": 100.00,\r\n "Discount ($)": 0,\r\n "Cost ($)": 25.0000000000,\r\n "Revenue ($)": 61.9565000000,\r\n "Margin (%)": 71.24\r\n },\r\n {\r\n "Outlet":"",\r\n "Product":"Long Black FREE",\r\n "SKU": 10014,\r\n "Brand":" ",\r\n "Supplier":" ",\r\n "Type":" ",\r\n "Tags":" coffee; free",\r\n "Supplier Code":" ",\r\n "Count": 62,\r\n "Sales ($)": 0.0000000000,\r\n "Tax ($)": 0.0000000000,\r\n "Sales incl. tax ($)": 0.00,\r\n "Discount ($)": 0,\r\n "Cost ($)": 0.0000000000,\r\n "Revenue ($)": 0.0000000000,\r\n "Margin (%)": 0.00\r\n },\r\n {\r\n "Outlet":"",\r\n "Product":"Mocha",\r\n "SKU": 10004,\r\n "Brand":" ",\r\n "Supplier":" ",\r\n "Type":" ",\r\n "Tags":" coffee",\r\n "Supplier Code":" ",\r\n "Count": 13,\r\n "Sales ($)": 45.2173800000,\r\n "Tax ($)": 6.7826200000,\r\n "Sales incl. tax ($)": 52.00,\r\n "Discount ($)": 0,\r\n "Cost ($)": 13.0000000000,\r\n "Revenue ($)": 32.2173800000,\r\n "Margin (%)": 71.24\r\n },\r\n {\r\n "Outlet":"",\r\n "Product":"Mocha FREE",\r\n "SKU": 10015,\r\n "Brand":" ",\r\n "Supplier":" ",\r\n "Type":" ",\r\n "Tags":" coffee; free",\r\n "Supplier Code":" ",\r\n "Count": 81,\r\n "Sales ($)": 0.0000000000,\r\n "Tax ($)": 0.0000000000,\r\n "Sales incl. tax ($)": 0.00,\r\n "Discount ($)": 0,\r\n "Cost ($)": 0.0000000000,\r\n "Revenue ($)": 0.0000000000,\r\n "Margin (%)": 0.00\r\n },\r\n {\r\n "Outlet":"",\r\n "Product":"Total",\r\n "SKU":null,\r\n "Brand":"",\r\n "Supplier":"",\r\n "Type":"",\r\n "Tags":"",\r\n "Supplier Code":"",\r\n "Count":715.00,\r\n "Sales ($)": 403.44,\r\n "Tax ($)": 60.50,\r\n "Sales incl. tax ($)": 463.94,\r\n "Discount ($)": 0.00,\r\n "Cost ($)": 116.00,\r\n "Revenue ($)": 287.44,\r\n "Margin (%)": 71.24727\r\n },\r\n {\r\n "Outlet":"",\r\n "Product":"Grand Total",\r\n "SKU":null,\r\n "Brand":"",\r\n "Supplier":"",\r\n "Type":"",\r\n "Tags":"",\r\n "Supplier Code":"",\r\n "Count":715.00,\r\n "Sales ($)": 403.44,\r\n "Tax ($)": 60.50,\r\n "Sales incl. tax ($)": 463.94,\r\n "Discount ($)": 0.00,\r\n "Cost ($)": 116.00,\r\n "Revenue ($)": 287.44,\r\n "Margin (%)": 71.24727\r\n }\r\n][\r\n {\r\n "Outlet":"LCA",\r\n "Product":"Cappuccino",\r\n "SKU": 10001,\r\n "Brand":" ",\r\n "Supplier":" ",\r\n "Type":" ",\r\n "Tags":" coffee",\r\n "Supplier Code":" ",\r\n "Count": 13,\r\n "Sales ($)": 45.2173800000,\r\n "Tax ($)": 6.7826200000,\r\n "Sales incl. tax ($)": 52.00,\r\n "Discount ($)": 0,\r\n "Cost ($)": 13.0000000000,\r\n "Revenue ($)": 32.2173800000,\r\n "Margin (%)": 71.24\r\n },\r\n {\r\n "Outlet":"",\r\n "Product":"Cappuccino FREE",\r\n "SKU": 10009,\r\n "Brand":" ",\r\n "Supplier":" ",\r\n "Type":" ",\r\n "Tags":" coffee; free",\r\n "Supplier Code":" ",\r\n "Count": 63,\r\n "Sales ($)": 0.0000000000,\r\n "Tax ($)": 0.0000000000,\r\n "Sales incl. tax ($)": 0.00,\r\n "Discount ($)": 0,\r\n "Cost ($)": 0.0000000000,\r\n "Revenue ($)": 0.0000000000,\r\n "Margin (%)": 0.00\r\n },\r\n {\r\n "Outlet":"",\r\n "Product":"Chai Latte",\r\n "SKU": 10003,\r\n "Brand":" ",\r\n "Supplier":" ",\r\n "Type":" ",\r\n "Tags":" coffee",\r\n "Supplier Code":" ",\r\n "Count": 1,\r\n "Sales ($)": 3.4782600000,\r\n "Tax ($)": 0.5217400000,\r\n "Sales incl. tax ($)": 4.00,\r\n "Discount ($)": 0,\r\n "Cost ($)": 1.0000000000,\r\n "Revenue ($)": 2.4782600000,\r\n "Margin (%)": 71.24\r\n },\r\n {\r\n "Outlet":"",\r\n "Product":"Chai Latte FREE",\r\n "SKU": 10010,\r\n "Brand":" ",\r\n "Supplier":" ",\r\n "Type":" ",\r\n "Tags":" coffee; free",\r\n "Supplier Code":" ",\r\n "Count": 9,\r\n "Sales ($)": 0.0000000000,\r\n "Tax ($)": 0.0000000000,\r\n "Sales incl. tax ($)": 0.00,\r\n "Discount ($)": 0,\r\n "Cost ($)": 0.0000000000,\r\n "Revenue ($)": 0.0000000000,\r\n "Margin (%)": 0.00\r\n },\r\n {\r\n "Outlet":"",\r\n "Product":"Espresso FREE",\r\n "SKU": 10032,\r\n "Brand":" ",\r\n "Supplier":" ",\r\n "Type":" ",\r\n "Tags":" ",\r\n "Supplier Code":" ",\r\n "Count": 14,\r\n "Sales ($)": 0.0000000000,\r\n "Tax ($)": 0.0000000000,\r\n "Sales incl. tax ($)": 0.00,\r\n "Discount ($)": 0,\r\n "Cost ($)": 0.0000000000,\r\n "Revenue ($)": 0.0000000000,\r\n "Margin (%)": 0.00\r\n },\r\n {\r\n "Outlet":"",\r\n "Product":"Flat White",\r\n "SKU": 10000,\r\n "Brand":" ",\r\n "Supplier":" ",\r\n "Type":" ",\r\n "Tags":" coffee",\r\n "Supplier Code":" ",\r\n "Count": 57,\r\n "Sales ($)": 198.2608200000,\r\n "Tax ($)": 29.7391800000,\r\n "Sales incl. tax ($)": 228.00,\r\n "Discount ($)": 0,\r\n "Cost ($)": 57.0000000000,\r\n "Revenue ($)": 141.2608200000,\r\n "Margin (%)": 71.24\r\n },\r\n {\r\n "Outlet":"",\r\n "Product":"Flat White FREE",\r\n "SKU": 10011,\r\n "Brand":" ",\r\n "Supplier":" ",\r\n "Type":" ",\r\n "Tags":" coffee; free",\r\n "Supplier Code":" ",\r\n "Count": 249,\r\n "Sales ($)": 0.0000000000,\r\n "Tax ($)": 0.0000000000,\r\n "Sales incl. tax ($)": 0.00,\r\n "Discount ($)": 0,\r\n "Cost ($)": 0.0000000000,\r\n "Revenue ($)": 0.0000000000,\r\n "Margin (%)": 0.00\r\n },\r\n {\r\n "Outlet":"",\r\n "Product":"Hot Chocolate",\r\n "SKU": 10005,\r\n "Brand":" ",\r\n "Supplier":" ",\r\n "Type":" ",\r\n "Tags":" coffee",\r\n "Supplier Code":" ",\r\n "Count": 7,\r\n "Sales ($)": 24.3478200000,\r\n "Tax ($)": 3.6521800000,\r\n "Sales incl. tax ($)": 28.00,\r\n "Discount ($)": 0,\r\n "Cost ($)": 7.0000000000,\r\n "Revenue ($)": 17.3478200000,\r\n "Margin (%)": 71.24\r\n },\r\n {\r\n "Outlet":"",\r\n "Product":"Hot Chocolate FREE",\r\n "SKU": 10012,\r\n "Brand":" ",\r\n "Supplier":" ",\r\n "Type":" ",\r\n "Tags":" coffee; free",\r\n "Supplier Code":" ",\r\n "Count": 121,\r\n "Sales ($)": 0.0000000000,\r\n "Tax ($)": 0.0000000000,\r\n "Sales incl. tax ($)": 0.00,\r\n "Discount ($)": 0,\r\n "Cost ($)": 0.0000000000,\r\n "Revenue ($)": 0.0000000000,\r\n "Margin (%)": 0.00\r\n },\r\n {\r\n "Outlet":"",\r\n "Product":"Long Black",\r\n "SKU": 10006,\r\n "Brand":" ",\r\n "Supplier":" ",\r\n "Type":" ",\r\n "Tags":" coffee",\r\n "Supplier Code":" ",\r\n "Count": 25,\r\n "Sales ($)": 86.9565000000,\r\n "Tax ($)": 13.0435000000,\r\n "Sales incl. tax ($)": 100.00,\r\n "Discount ($)": 0,\r\n "Cost ($)": 25.0000000000,\r\n "Revenue ($)": 61.9565000000,\r\n "Margin (%)": 71.24\r\n },\r\n {\r\n "Outlet":"",\r\n "Product":"Long Black FREE",\r\n "SKU": 10014,\r\n "Brand":" ",\r\n "Supplier":" ",\r\n "Type":" ",\r\n "Tags":" coffee; free",\r\n "Supplier Code":" ",\r\n "Count": 62,\r\n "Sales ($)": 0.0000000000,\r\n "Tax ($)": 0.0000000000,\r\n "Sales incl. tax ($)": 0.00,\r\n "Discount ($)": 0,\r\n "Cost ($)": 0.0000000000,\r\n "Revenue ($)": 0.0000000000,\r\n "Margin (%)": 0.00\r\n },\r\n {\r\n "Outlet":"",\r\n "Product":"Mocha",\r\n "SKU": 10004,\r\n "Brand":" ",\r\n "Supplier":" ",\r\n "Type":" ",\r\n "Tags":" coffee",\r\n "Supplier Code":" ",\r\n "Count": 13,\r\n "Sales ($)": 45.2173800000,\r\n "Tax ($)": 6.7826200000,\r\n "Sales incl. tax ($)": 52.00,\r\n "Discount ($)": 0,\r\n "Cost ($)": 13.0000000000,\r\n "Revenue ($)": 32.2173800000,\r\n "Margin (%)": 71.24\r\n },\r\n {\r\n "Outlet":"",\r\n "Product":"Mocha FREE",\r\n "SKU": 10015,\r\n "Brand":" ",\r\n "Supplier":" ",\r\n "Type":" ",\r\n "Tags":" coffee; free",\r\n "Supplier Code":" ",\r\n "Count": 81,\r\n "Sales ($)": 0.0000000000,\r\n "Tax ($)": 0.0000000000,\r\n "Sales incl. tax ($)": 0.00,\r\n "Discount ($)": 0,\r\n "Cost ($)": 0.0000000000,\r\n "Revenue ($)": 0.0000000000,\r\n "Margin (%)": 0.00\r\n },\r\n {\r\n "Outlet":"",\r\n "Product":"Total",\r\n "SKU":null,\r\n "Brand":"",\r\n "Supplier":"",\r\n "Type":"",\r\n "Tags":"",\r\n "Supplier Code":"",\r\n "Count":715.00,\r\n "Sales ($)": 403.44,\r\n "Tax ($)": 60.50,\r\n "Sales incl. tax ($)": 463.94,\r\n "Discount ($)": 0.00,\r\n "Cost ($)": 116.00,\r\n "Revenue ($)": 287.44,\r\n "Margin (%)": 71.24727\r\n },\r\n {\r\n "Outlet":"",\r\n "Product":"Grand Total",\r\n "SKU":null,\r\n "Brand":"",\r\n "Supplier":"",\r\n "Type":"",\r\n "Tags":"",\r\n "Supplier Code":"",\r\n "Count":715.00,\r\n "Sales ($)": 403.44,\r\n "Tax ($)": 60.50,\r\n "Sales incl. tax ($)": 463.94,\r\n "Discount ($)": 0.00,\r\n "Cost ($)": 116.00,\r\n "Revenue ($)": 287.44,\r\n "Margin (%)": 71.24727\r\n }\r\n][\r\n {\r\n "Outlet":"LCA",\r\n "Product":"Cappuccino",\r\n "SKU": 10001,\r\n "Brand":" ",\r\n "Supplier":" ",\r\n "Type":" ",\r\n "Tags":" coffee",\r\n "Supplier Code":" ",\r\n "Count": 13,\r\n "Sales ($)": 45.2173800000,\r\n "Tax ($)": 6.7826200000,\r\n "Sales incl. tax ($)": 52.00,\r\n "Discount ($)": 0,\r\n "Cost ($)": 13.0000000000,\r\n "Revenue ($)": 32.2173800000,\r\n "Margin (%)": 71.24\r\n },\r\n {\r\n "Outlet":"",\r\n "Product":"Cappuccino FREE",\r\n "SKU": 10009,\r\n "Brand":" ",\r\n "Supplier":" ",\r\n "Type":" ",\r\n "Tags":" coffee; free",\r\n "Supplier Code":" ",\r\n "Count": 63,\r\n "Sales ($)": 0.0000000000,\r\n "Tax ($)": 0.0000000000,\r\n "Sales incl. tax ($)": 0.00,\r\n "Discount ($)": 0,\r\n "Cost ($)": 0.0000000000,\r\n "Revenue ($)": 0.0000000000,\r\n "Margin (%)": 0.00\r\n },\r\n {\r\n "Outlet":"",\r\n "Product":"Chai Latte",\r\n "SKU": 10003,\r\n "Brand":" ",\r\n "Supplier":" ",\r\n "Type":" ",\r\n "Tags":" coffee",\r\n "Supplier Code":" ",\r\n "Count": 1,\r\n "Sales ($)": 3.4782600000,\r\n "Tax ($)": 0.5217400000,\r\n "Sales incl. tax ($)": 4.00,\r\n "Discount ($)": 0,\r\n "Cost ($)": 1.0000000000,\r\n "Revenue ($)": 2.4782600000,\r\n "Margin (%)": 71.24\r\n },\r\n {\r\n "Outlet":"",\r\n "Product":"Chai Latte FREE",\r\n "SKU": 10010,\r\n "Brand":" ",\r\n "Supplier":" ",\r\n "Type":" ",\r\n "Tags":" coffee; free",\r\n "Supplier Code":" ",\r\n "Count": 9,\r\n "Sales ($)": 0.0000000000,\r\n "Tax ($)": 0.0000000000,\r\n "Sales incl. tax ($)": 0.00,\r\n "Discount ($)": 0,\r\n "Cost ($)": 0.0000000000,\r\n "Revenue ($)": 0.0000000000,\r\n "Margin (%)": 0.00\r\n },\r\n {\r\n "Outlet":"",\r\n "Product":"Espresso FREE",\r\n "SKU": 10032,\r\n "Brand":" ",\r\n "Supplier":" ",\r\n "Type":" ",\r\n "Tags":" ",\r\n "Supplier Code":" ",\r\n "Count": 14,\r\n "Sales ($)": 0.0000000000,\r\n "Tax ($)": 0.0000000000,\r\n "Sales incl. tax ($)": 0.00,\r\n "Discount ($)": 0,\r\n "Cost ($)": 0.0000000000,\r\n "Revenue ($)": 0.0000000000,\r\n "Margin (%)": 0.00\r\n },\r\n {\r\n "Outlet":"",\r\n "Product":"Flat White",\r\n "SKU": 10000,\r\n "Brand":" ",\r\n "Supplier":" ",\r\n "Type":" ",\r\n "Tags":" coffee",\r\n "Supplier Code":" ",\r\n "Count": 57,\r\n "Sales ($)": 198.2608200000,\r\n "Tax ($)": 29.7391800000,\r\n "Sales incl. tax ($)": 228.00,\r\n "Discount ($)": 0,\r\n "Cost ($)": 57.0000000000,\r\n "Revenue ($)": 141.2608200000,\r\n "Margin (%)": 71.24\r\n },\r\n {\r\n "Outlet":"",\r\n "Product":"Flat White FREE",\r\n "SKU": 10011,\r\n "Brand":" ",\r\n "Supplier":" ",\r\n "Type":" ",\r\n "Tags":" coffee; free",\r\n "Supplier Code":" ",\r\n "Count": 249,\r\n "Sales ($)": 0.0000000000,\r\n "Tax ($)": 0.0000000000,\r\n "Sales incl. tax ($)": 0.00,\r\n "Discount ($)": 0,\r\n "Cost ($)": 0.0000000000,\r\n "Revenue ($)": 0.0000000000,\r\n "Margin (%)": 0.00\r\n },\r\n {\r\n "Outlet":"",\r\n "Product":"Hot Chocolate",\r\n "SKU": 10005,\r\n "Brand":" ",\r\n "Supplier":" ",\r\n "Type":" ",\r\n "Tags":" coffee",\r\n "Supplier Code":" ",\r\n "Count": 7,\r\n "Sales ($)": 24.3478200000,\r\n "Tax ($)": 3.6521800000,\r\n "Sales incl. tax ($)": 28.00,\r\n "Discount ($)": 0,\r\n "Cost ($)": 7.0000000000,\r\n "Revenue ($)": 17.3478200000,\r\n "Margin (%)": 71.24\r\n },\r\n {\r\n "Outlet":"",\r\n "Product":"Hot Chocolate FREE",\r\n "SKU": 10012,\r\n "Brand":" ",\r\n "Supplier":" ",\r\n "Type":" ",\r\n "Tags":" coffee; free",\r\n "Supplier Code":" ",\r\n "Count": 121,\r\n "Sales ($)": 0.0000000000,\r\n "Tax ($)": 0.0000000000,\r\n "Sales incl. tax ($)": 0.00,\r\n "Discount ($)": 0,\r\n "Cost ($)": 0.0000000000,\r\n "Revenue ($)": 0.0000000000,\r\n "Margin (%)": 0.00\r\n },\r\n {\r\n "Outlet":"",\r\n "Product":"Long Black",\r\n "SKU": 10006,\r\n "Brand":" ",\r\n "Supplier":" ",\r\n "Type":" ",\r\n "Tags":" coffee",\r\n "Supplier Code":" ",\r\n "Count": 25,\r\n "Sales ($)": 86.9565000000,\r\n "Tax ($)": 13.0435000000,\r\n "Sales incl. tax ($)": 100.00,\r\n "Discount ($)": 0,\r\n "Cost ($)": 25.0000000000,\r\n "Revenue ($)": 61.9565000000,\r\n "Margin (%)": 71.24\r\n },\r\n {\r\n "Outlet":"",\r\n "Product":"Long Black FREE",\r\n "SKU": 10014,\r\n "Brand":" ",\r\n "Supplier":" ",\r\n "Type":" ",\r\n "Tags":" coffee; free",\r\n "Supplier Code":" ",\r\n "Count": 62,\r\n "Sales ($)": 0.0000000000,\r\n "Tax ($)": 0.0000000000,\r\n "Sales incl. tax ($)": 0.00,\r\n "Discount ($)": 0,\r\n "Cost ($)": 0.0000000000,\r\n "Revenue ($)": 0.0000000000,\r\n "Margin (%)": 0.00\r\n },\r\n {\r\n "Outlet":"",\r\n "Product":"Mocha",\r\n "SKU": 10004,\r\n "Brand":" ",\r\n "Supplier":" ",\r\n "Type":" ",\r\n "Tags":" coffee",\r\n "Supplier Code":" ",\r\n "Count": 13,\r\n "Sales ($)": 45.2173800000,\r\n "Tax ($)": 6.7826200000,\r\n "Sales incl. tax ($)": 52.00,\r\n "Discount ($)": 0,\r\n "Cost ($)": 13.0000000000,\r\n "Revenue ($)": 32.2173800000,\r\n "Margin (%)": 71.24\r\n },\r\n {\r\n "Outlet":"",\r\n "Product":"Mocha FREE",\r\n "SKU": 10015,\r\n "Brand":" ",\r\n "Supplier":" ",\r\n "Type":" ",\r\n "Tags":" coffee; free",\r\n "Supplier Code":" ",\r\n "Count": 81,\r\n "Sales ($)": 0.0000000000,\r\n "Tax ($)": 0.0000000000,\r\n "Sales incl. tax ($)": 0.00,\r\n "Discount ($)": 0,\r\n "Cost ($)": 0.0000000000,\r\n "Revenue ($)": 0.0000000000,\r\n "Margin (%)": 0.00\r\n },\r\n {\r\n "Outlet":"",\r\n "Product":"Total",\r\n "SKU":null,\r\n "Brand":"",\r\n "Supplier":"",\r\n "Type":"",\r\n "Tags":"",\r\n "Supplier Code":"",\r\n "Count":715.00,\r\n "Sales ($)": 403.44,\r\n "Tax ($)": 60.50,\r\n "Sales incl. tax ($)": 463.94,\r\n "Discount ($)": 0.00,\r\n "Cost ($)": 116.00,\r\n "Revenue ($)": 287.44,\r\n "Margin (%)": 71.24727\r\n },\r\n {\r\n "Outlet":"",\r\n "Product":"Grand Total",\r\n "SKU":null,\r\n "Brand":"",\r\n "Supplier":"",\r\n "Type":"",\r\n "Tags":"",\r\n "Supplier Code":"",\r\n "Count":715.00,\r\n "Sales ($)": 403.44,\r\n "Tax ($)": 60.50,\r\n "Sales incl. tax ($)": 463.94,\r\n "Discount ($)": 0.00,\r\n "Cost ($)": 116.00,\r\n "Revenue ($)": 287.44,\r\n "Margin (%)": 71.24727\r\n }\r\n][\r\n {\r\n "Outlet":"LCA",\r\n "Product":"Cappuccino",\r\n "SKU": 10001,\r\n "Brand":" ",\r\n "Supplier":" ",\r\n "Type":" ",\r\n "Tags":" coffee",\r\n "Supplier Code":" ",\r\n "Count": 13,\r\n "Sales ($)": 45.2173800000,\r\n "Tax ($)": 6.7826200000,\r\n "Sales incl. tax ($)": 52.00,\r\n "Discount ($)": 0,\r\n "Cost ($)": 13.0000000000,\r\n "Revenue ($)": 32.2173800000,\r\n "Margin (%)": 71.24\r\n },\r\n {\r\n "Outlet":"",\r\n "Product":"Cappuccino FREE",\r\n "SKU": 10009,\r\n "Brand":" ",\r\n "Supplier":" ",\r\n "Type":" ",\r\n "Tags":" coffee; free",\r\n "Supplier Code":" ",\r\n "Count": 63,\r\n "Sales ($)": 0.0000000000,\r\n "Tax ($)": 0.0000000000,\r\n "Sales incl. tax ($)": 0.00,\r\n "Discount ($)": 0,\r\n "Cost ($)": 0.0000000000,\r\n "Revenue ($)": 0.0000000000,\r\n "Margin (%)": 0.00\r\n },\r\n {\r\n "Outlet":"",\r\n "Product":"Chai Latte",\r\n "SKU": 10003,\r\n "Brand":" ",\r\n "Supplier":" ",\r\n "Type":" ",\r\n "Tags":" coffee",\r\n "Supplier Code":" ",\r\n "Count": 1,\r\n "Sales ($)": 3.4782600000,\r\n "Tax ($)": 0.5217400000,\r\n "Sales incl. tax ($)": 4.00,\r\n "Discount ($)": 0,\r\n "Cost ($)": 1.0000000000,\r\n "Revenue ($)": 2.4782600000,\r\n "Margin (%)": 71.24\r\n },\r\n {\r\n "Outlet":"",\r\n "Product":"Chai Latte FREE",\r\n "SKU": 10010,\r\n "Brand":" ",\r\n "Supplier":" ",\r\n "Type":" ",\r\n "Tags":" coffee; free",\r\n "Supplier Code":" ",\r\n "Count": 9,\r\n "Sales ($)": 0.0000000000,\r\n "Tax ($)": 0.0000000000,\r\n "Sales incl. tax ($)": 0.00,\r\n "Discount ($)": 0,\r\n "Cost ($)": 0.0000000000,\r\n "Revenue ($)": 0.0000000000,\r\n "Margin (%)": 0.00\r\n },\r\n {\r\n "Outlet":"",\r\n "Product":"Espresso FREE",\r\n "SKU": 10032,\r\n "Brand":" ",\r\n "Supplier":" ",\r\n "Type":" ",\r\n "Tags":" ",\r\n "Supplier Code":" ",\r\n "Count": 14,\r\n "Sales ($)": 0.0000000000,\r\n "Tax ($)": 0.0000000000,\r\n "Sales incl. tax ($)": 0.00,\r\n "Discount ($)": 0,\r\n "Cost ($)": 0.0000000000,\r\n "Revenue ($)": 0.0000000000,\r\n "Margin (%)": 0.00\r\n },\r\n {\r\n "Outlet":"",\r\n "Product":"Flat White",\r\n "SKU": 10000,\r\n "Brand":" ",\r\n "Supplier":" ",\r\n "Type":" ",\r\n "Tags":" coffee",\r\n "Supplier Code":" ",\r\n "Count": 57,\r\n "Sales ($)": 198.2608200000,\r\n "Tax ($)": 29.7391800000,\r\n "Sales incl. tax ($)": 228.00,\r\n "Discount ($)": 0,\r\n "Cost ($)": 57.0000000000,\r\n "Revenue ($)": 141.2608200000,\r\n "Margin (%)": 71.24\r\n },\r\n {\r\n "Outlet":"",\r\n "Product":"Flat White FREE",\r\n "SKU": 10011,\r\n "Brand":" ",\r\n "Supplier":" ",\r\n "Type":" ",\r\n "Tags":" coffee; free",\r\n "Supplier Code":" ",\r\n "Count": 249,\r\n "Sales ($)": 0.0000000000,\r\n "Tax ($)": 0.0000000000,\r\n "Sales incl. tax ($)": 0.00,\r\n "Discount ($)": 0,\r\n "Cost ($)": 0.0000000000,\r\n "Revenue ($)": 0.0000000000,\r\n "Margin (%)": 0.00\r\n },\r\n {\r\n "Outlet":"",\r\n "Product":"Hot Chocolate",\r\n "SKU": 10005,\r\n "Brand":" ",\r\n "Supplier":" ",\r\n "Type":" ",\r\n "Tags":" coffee",\r\n "Supplier Code":" ",\r\n "Count": 7,\r\n "Sales ($)": 24.3478200000,\r\n "Tax ($)": 3.6521800000,\r\n "Sales incl. tax ($)": 28.00,\r\n "Discount ($)": 0,\r\n "Cost ($)": 7.0000000000,\r\n "Revenue ($)": 17.3478200000,\r\n "Margin (%)": 71.24\r\n },\r\n {\r\n "Outlet":"",\r\n "Product":"Hot Chocolate FREE",\r\n "SKU": 10012,\r\n "Brand":" ",\r\n "Supplier":" ",\r\n "Type":" ",\r\n "Tags":" coffee; free",\r\n "Supplier Code":" ",\r\n "Count": 121,\r\n "Sales ($)": 0.0000000000,\r\n "Tax ($)": 0.0000000000,\r\n "Sales incl. tax ($)": 0.00,\r\n "Discount ($)": 0,\r\n "Cost ($)": 0.0000000000,\r\n "Revenue ($)": 0.0000000000,\r\n "Margin (%)": 0.00\r\n },\r\n {\r\n "Outlet":"",\r\n "Product":"Long Black",\r\n "SKU": 10006,\r\n "Brand":" ",\r\n "Supplier":" ",\r\n "Type":" ",\r\n "Tags":" coffee",\r\n "Supplier Code":" ",\r\n "Count": 25,\r\n "Sales ($)": 86.9565000000,\r\n "Tax ($)": 13.0435000000,\r\n "Sales incl. tax ($)": 100.00,\r\n "Discount ($)": 0,\r\n "Cost ($)": 25.0000000000,\r\n "Revenue ($)": 61.9565000000,\r\n "Margin (%)": 71.24\r\n },\r\n {\r\n "Outlet":"",\r\n "Product":"Long Black FREE",\r\n "SKU": 10014,\r\n "Brand":" ",\r\n "Supplier":" ",\r\n "Type":" ",\r\n "Tags":" coffee; free",\r\n "Supplier Code":" ",\r\n "Count": 62,\r\n "Sales ($)": 0.0000000000,\r\n "Tax ($)": 0.0000000000,\r\n "Sales incl. tax ($)": 0.00,\r\n "Discount ($)": 0,\r\n "Cost ($)": 0.0000000000,\r\n "Revenue ($)": 0.0000000000,\r\n "Margin (%)": 0.00\r\n },\r\n {\r\n "Outlet":"",\r\n "Product":"Mocha",\r\n "SKU": 10004,\r\n "Brand":" ",\r\n "Supplier":" ",\r\n "Type":" ",\r\n "Tags":" coffee",\r\n "Supplier Code":" ",\r\n "Count": 13,\r\n "Sales ($)": 45.2173800000,\r\n "Tax ($)": 6.7826200000,\r\n "Sales incl. tax ($)": 52.00,\r\n "Discount ($)": 0,\r\n "Cost ($)": 13.0000000000,\r\n "Revenue ($)": 32.2173800000,\r\n "Margin (%)": 71.24\r\n },\r\n {\r\n "Outlet":"",\r\n "Product":"Mocha FREE",\r\n "SKU": 10015,\r\n "Brand":" ",\r\n "Supplier":" ",\r\n "Type":" ",\r\n "Tags":" coffee; free",\r\n "Supplier Code":" ",\r\n "Count": 81,\r\n "Sales ($)": 0.0000000000,\r\n "Tax ($)": 0.0000000000,\r\n "Sales incl. tax ($)": 0.00,\r\n "Discount ($)": 0,\r\n "Cost ($)": 0.0000000000,\r\n "Revenue ($)": 0.0000000000,\r\n "Margin (%)": 0.00\r\n },\r\n {\r\n "Outlet":"",\r\n "Product":"Total",\r\n "SKU":null,\r\n "Brand":"",\r\n "Supplier":"",\r\n "Type":"",\r\n "Tags":"",\r\n "Supplier Code":"",\r\n "Count":715.00,\r\n "Sales ($)": 403.44,\r\n "Tax ($)": 60.50,\r\n "Sales incl. tax ($)": 463.94,\r\n "Discount ($)": 0.00,\r\n "Cost ($)": 116.00,\r\n "Revenue ($)": 287.44,\r\n "Margin (%)": 71.24727\r\n },\r\n {\r\n "Outlet":"",\r\n "Product":"Grand Total",\r\n "SKU":null,\r\n "Brand":"",\r\n "Supplier":"",\r\n "Type":"",\r\n "Tags":"",\r\n "Supplier Code":"",\r\n "Count":715.00,\r\n "Sales ($)": 403.44,\r\n "Tax ($)": 60.50,\r\n "Sales incl. tax ($)": 463.94,\r\n "Discount ($)": 0.00,\r\n "Cost ($)": 116.00,\r\n "Revenue ($)": 287.44,\r\n "Margin (%)": 71.24727\r\n }\r\n]'
In [86]:
opcvs = open(salhr, 'r')
In [87]:
opzrd = opcvs.read()
In [88]:
jdunp = json.loads(opzrd)
In [89]:
valia = []
In [90]:
#pandas.read_json(jdunp)
In [91]:
jdunp.count(int)
Out[91]:
0
In [92]:
len(jdunp)
Out[92]:
6
ok if i cycle through jdunp between 0 and 23 i get the results.
cycle through ints but as a string. must add ' '
Break down coffee sales by hour.
Ignore/delete hours with zero sales. Need to create new dict with this data.
How would it look?
In [93]:
for numtwn in range(0,24):
print "'" + str(numtwn) + "'"
'0'
'1'
'2'
'3'
'4'
'5'
'6'
'7'
'8'
'9'
'10'
'11'
'12'
'13'
'14'
'15'
'16'
'17'
'18'
'19'
'20'
'21'
'22'
'23'
In [94]:
for jdr in jdunp:
print jdr['0']
- -
- -
- -
- -
- -
- -
In [95]:
for numtwn in range(0,24):
print "'" + str(numtwn) + "'"
'0'
'1'
'2'
'3'
'4'
'5'
'6'
'7'
'8'
'9'
'10'
'11'
'12'
'13'
'14'
'15'
'16'
'17'
'18'
'19'
'20'
'21'
'22'
'23'
In [96]:
for dej in jdunp:
print dej.values()
valia.append(dej.values())
[u'- -', u'- -', u'- -', u'- -', u'- -', u'- -', u'- -', u'- -', u'- -', u'- -', u'- -', u'- -', u'- -', u'- -', u' 11 Jan 2015', u'', u'Sun', u'- -', u'- -', u'- -', u'4 (1)', u'0 (9)', u'12 (30)', u'0 (3)', u'8 (9)', u'- -', u'- -']
[u'- -', u'- -', u'- -', u'- -', u'- -', u'- -', u'- -', u'- -', u'- -', u'- -', u'8 (9)', u'- -', u'40 (31)', u'44 (123)', u' 12 Jan 2015', u'', u'Mon', u'4 (13)', u'20 (118)', u'8 (52)', u'12 (34)', u'12 (46)', u'4 (33)', u'- -', u'0 (1)', u'- -', u'- -']
[u'- -', u'- -', u'- -', u'- -', u'- -', u'- -', u'- -', u'- -', u'- -', u'- -', u'4 (17)', u'- -', u'0 (23)', u'24 (109)', u' 13 Jan 2015', u'', u'Tue', u'8 (25)', u'32 (101)', u'12 (55)', u'16 (43)', u'20 (100)', u'12 (43)', u'- -', u'4 (3)', u'- -', u'- -']
[u'- -', u'- -', u'- -', u'- -', u'- -', u'- -', u'- -', u'- -', u'- -', u'- -', u'4 (19)', u'- -', u'8 (24)', u'20 (132)', u' 14 Jan 2015', u'', u'Wed', u'12 (39)', u'32 (133)', u'56 (64)', u'16 (36)', u'52 (83)', u'44 (38)', u'- -', u'- -', u'- -', u'- -']
[u'- -', u'- -', u'- -', u'- -', u'- -', u'- -', u'- -', u'- -', u'- -', u'- -', u'8 (20)', u'- -', u'20 (25)', u'68 (115)', u' 15 Jan 2015', u'', u'Thu', u'40 (40)', u'132 (136)', u'52 (55)', u'36 (50)', u'72 (103)', u'32 (49)', u'- -', u'4 (6)', u'- -', u'- -']
[u'- -', u'- -', u'- -', u'- -', u'- -', u'- -', u'- -', u'- -', u'- -', u'- -', u'12 (21)', u'- -', u'8 (15)', u'104 (128)', u' 16 Jan 2015', u'', u'Fri', u'28 (41)', u'112 (131)', u'40 (76)', u'40 (54)', u'92 (102)', u'28 (64)', u'- -', u'- -', u'- -', u'- -']
In [96]:
In [97]:
dezrand = len(valia)
In [98]:
azlis = []
In [99]:
for vals in valia:
print vals
azlis.append(vals)
[u'- -', u'- -', u'- -', u'- -', u'- -', u'- -', u'- -', u'- -', u'- -', u'- -', u'- -', u'- -', u'- -', u'- -', u' 11 Jan 2015', u'', u'Sun', u'- -', u'- -', u'- -', u'4 (1)', u'0 (9)', u'12 (30)', u'0 (3)', u'8 (9)', u'- -', u'- -']
[u'- -', u'- -', u'- -', u'- -', u'- -', u'- -', u'- -', u'- -', u'- -', u'- -', u'8 (9)', u'- -', u'40 (31)', u'44 (123)', u' 12 Jan 2015', u'', u'Mon', u'4 (13)', u'20 (118)', u'8 (52)', u'12 (34)', u'12 (46)', u'4 (33)', u'- -', u'0 (1)', u'- -', u'- -']
[u'- -', u'- -', u'- -', u'- -', u'- -', u'- -', u'- -', u'- -', u'- -', u'- -', u'4 (17)', u'- -', u'0 (23)', u'24 (109)', u' 13 Jan 2015', u'', u'Tue', u'8 (25)', u'32 (101)', u'12 (55)', u'16 (43)', u'20 (100)', u'12 (43)', u'- -', u'4 (3)', u'- -', u'- -']
[u'- -', u'- -', u'- -', u'- -', u'- -', u'- -', u'- -', u'- -', u'- -', u'- -', u'4 (19)', u'- -', u'8 (24)', u'20 (132)', u' 14 Jan 2015', u'', u'Wed', u'12 (39)', u'32 (133)', u'56 (64)', u'16 (36)', u'52 (83)', u'44 (38)', u'- -', u'- -', u'- -', u'- -']
[u'- -', u'- -', u'- -', u'- -', u'- -', u'- -', u'- -', u'- -', u'- -', u'- -', u'8 (20)', u'- -', u'20 (25)', u'68 (115)', u' 15 Jan 2015', u'', u'Thu', u'40 (40)', u'132 (136)', u'52 (55)', u'36 (50)', u'72 (103)', u'32 (49)', u'- -', u'4 (6)', u'- -', u'- -']
[u'- -', u'- -', u'- -', u'- -', u'- -', u'- -', u'- -', u'- -', u'- -', u'- -', u'12 (21)', u'- -', u'8 (15)', u'104 (128)', u' 16 Jan 2015', u'', u'Fri', u'28 (41)', u'112 (131)', u'40 (76)', u'40 (54)', u'92 (102)', u'28 (64)', u'- -', u'- -', u'- -', u'- -']
I need to filter the - - from the results. I really only need the values that have numbers.
Take number in brackets away from number not in brackets. The number in brackets is total amount of coffees sold. The number not in brackets is amount of volchers used. The number that I get when i take away is the coffee sold without volchers.
New dict that shows only the times that coffee were sold and the amount of coffgfges that were solf. Maybe that would works.
In [100]:
betra = []
In [101]:
for azl in azlis:
betra.append(azl)
In [102]:
anoe = []
anez = []
In [103]:
for betr in betra:
betr.append(anoe)
In [104]:
for deta in betr:
#print deta
if '- -' in deta:
print deta
else:
anez.append(deta)
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
In [105]:
fdic = []
In [105]:
In [106]:
for resut in anez:
print resut
fdic.append(resut)
12 (21)
8 (15)
104 (128)
16 Jan 2015
Fri
28 (41)
112 (131)
40 (76)
40 (54)
92 (102)
28 (64)
[]
How come it is only adding the wednesday data in the results. It needs to have all the datas.
Needs to take the number in brackets away from the number not in brackets.
In [107]:
fdic
Out[107]:
[u'12 (21)',
u'8 (15)',
u'104 (128)',
u' 16 Jan 2015',
u'',
u'Fri',
u'28 (41)',
u'112 (131)',
u'40 (76)',
u'40 (54)',
u'92 (102)',
u'28 (64)',
[]]
In [108]:
optue = open('/home/wcmckee/Downloads/saletues.json', 'r')
In [109]:
rdtue = optue.read()
In [110]:
tuejs = json.loads(rdtue)
In [111]:
tuejs
Out[111]:
[{u'Brand': u' ',
u'Cost ($)': 2.0,
u'Count': 2,
u'Discount ($)': 0,
u'Margin (%)': 71.24,
u'Outlet': u'LCA',
u'Product': u'Cappuccino',
u'Revenue ($)': 4.95652,
u'SKU': 10001,
u'Sales ($)': 6.95652,
u'Sales incl. tax ($)': 8.0,
u'Supplier': u' ',
u'Supplier Code': u' ',
u'Tags': u' coffee',
u'Tax ($)': 1.04348,
u'Type': u' '},
{u'Brand': u' ',
u'Cost ($)': 0.0,
u'Count': 69,
u'Discount ($)': 0,
u'Margin (%)': 0.0,
u'Outlet': u'',
u'Product': u'Cappuccino FREE',
u'Revenue ($)': 0.0,
u'SKU': 10009,
u'Sales ($)': 0.0,
u'Sales incl. tax ($)': 0.0,
u'Supplier': u' ',
u'Supplier Code': u' ',
u'Tags': u' coffee; free',
u'Tax ($)': 0.0,
u'Type': u' '},
{u'Brand': u' ',
u'Cost ($)': 0.0,
u'Count': 15,
u'Discount ($)': 0,
u'Margin (%)': 0.0,
u'Outlet': u'',
u'Product': u'Chai Latte FREE',
u'Revenue ($)': 0.0,
u'SKU': 10010,
u'Sales ($)': 0.0,
u'Sales incl. tax ($)': 0.0,
u'Supplier': u' ',
u'Supplier Code': u' ',
u'Tags': u' coffee; free',
u'Tax ($)': 0.0,
u'Type': u' '},
{u'Brand': u' ',
u'Cost ($)': 0.0,
u'Count': 7,
u'Discount ($)': 0,
u'Margin (%)': 0.0,
u'Outlet': u'',
u'Product': u'Espresso FREE',
u'Revenue ($)': 0.0,
u'SKU': 10032,
u'Sales ($)': 0.0,
u'Sales incl. tax ($)': 0.0,
u'Supplier': u' ',
u'Supplier Code': u' ',
u'Tags': u' ',
u'Tax ($)': 0.0,
u'Type': u' '},
{u'Brand': u' ',
u'Cost ($)': 17.0,
u'Count': 17,
u'Discount ($)': 0,
u'Margin (%)': 71.24,
u'Outlet': u'',
u'Product': u'Flat White',
u'Revenue ($)': 42.13042,
u'SKU': 10000,
u'Sales ($)': 59.13042,
u'Sales incl. tax ($)': 68.0,
u'Supplier': u' ',
u'Supplier Code': u' ',
u'Tags': u' coffee',
u'Tax ($)': 8.86958,
u'Type': u' '},
{u'Brand': u' ',
u'Cost ($)': 0.0,
u'Count': 242,
u'Discount ($)': 0,
u'Margin (%)': 0.0,
u'Outlet': u'',
u'Product': u'Flat White FREE',
u'Revenue ($)': 0.0,
u'SKU': 10011,
u'Sales ($)': 0.0,
u'Sales incl. tax ($)': 0.0,
u'Supplier': u' ',
u'Supplier Code': u' ',
u'Tags': u' coffee; free',
u'Tax ($)': 0.0,
u'Type': u' '},
{u'Brand': u' ',
u'Cost ($)': 5.0,
u'Count': 5,
u'Discount ($)': 0,
u'Margin (%)': 71.24,
u'Outlet': u'',
u'Product': u'Hot Chocolate',
u'Revenue ($)': 12.3913,
u'SKU': 10005,
u'Sales ($)': 17.3913,
u'Sales incl. tax ($)': 20.0,
u'Supplier': u' ',
u'Supplier Code': u' ',
u'Tags': u' coffee',
u'Tax ($)': 2.6087,
u'Type': u' '},
{u'Brand': u' ',
u'Cost ($)': 0.0,
u'Count': 68,
u'Discount ($)': 0,
u'Margin (%)': 0.0,
u'Outlet': u'',
u'Product': u'Hot Chocolate FREE',
u'Revenue ($)': 0.0,
u'SKU': 10012,
u'Sales ($)': 0.0,
u'Sales incl. tax ($)': 0.0,
u'Supplier': u' ',
u'Supplier Code': u' ',
u'Tags': u' coffee; free',
u'Tax ($)': 0.0,
u'Type': u' '},
{u'Brand': u' ',
u'Cost ($)': 6.0,
u'Count': 6,
u'Discount ($)': 0,
u'Margin (%)': 71.24,
u'Outlet': u'',
u'Product': u'Long Black',
u'Revenue ($)': 14.86956,
u'SKU': 10006,
u'Sales ($)': 20.86956,
u'Sales incl. tax ($)': 24.0,
u'Supplier': u' ',
u'Supplier Code': u' ',
u'Tags': u' coffee',
u'Tax ($)': 3.13044,
u'Type': u' '},
{u'Brand': u' ',
u'Cost ($)': 0.0,
u'Count': 73,
u'Discount ($)': 0,
u'Margin (%)': 0.0,
u'Outlet': u'',
u'Product': u'Long Black FREE',
u'Revenue ($)': 0.0,
u'SKU': 10014,
u'Sales ($)': 0.0,
u'Sales incl. tax ($)': 0.0,
u'Supplier': u' ',
u'Supplier Code': u' ',
u'Tags': u' coffee; free',
u'Tax ($)': 0.0,
u'Type': u' '},
{u'Brand': u' ',
u'Cost ($)': 0.0,
u'Count': 4,
u'Discount ($)': 0,
u'Margin (%)': 0.0,
u'Outlet': u'',
u'Product': u'Macchiato FREE',
u'Revenue ($)': 0.0,
u'SKU': 10030,
u'Sales ($)': 0.0,
u'Sales incl. tax ($)': 0.0,
u'Supplier': u' ',
u'Supplier Code': u' ',
u'Tags': u' ',
u'Tax ($)': 0.0,
u'Type': u' '},
{u'Brand': u' ',
u'Cost ($)': 3.0,
u'Count': 3,
u'Discount ($)': 0,
u'Margin (%)': 71.24,
u'Outlet': u'',
u'Product': u'Mocha',
u'Revenue ($)': 7.43478,
u'SKU': 10004,
u'Sales ($)': 10.43478,
u'Sales incl. tax ($)': 12.0,
u'Supplier': u' ',
u'Supplier Code': u' ',
u'Tags': u' coffee',
u'Tax ($)': 1.56522,
u'Type': u' '},
{u'Brand': u' ',
u'Cost ($)': 0.0,
u'Count': 61,
u'Discount ($)': 0,
u'Margin (%)': 0.0,
u'Outlet': u'',
u'Product': u'Mocha FREE',
u'Revenue ($)': 0.0,
u'SKU': 10015,
u'Sales ($)': 0.0,
u'Sales incl. tax ($)': 0.0,
u'Supplier': u' ',
u'Supplier Code': u' ',
u'Tags': u' coffee; free',
u'Tax ($)': 0.0,
u'Type': u' '},
{u'Brand': u'',
u'Cost ($)': 33.0,
u'Count': 572.0,
u'Discount ($)': 0.0,
u'Margin (%)': 71.24433,
u'Outlet': u'',
u'Product': u'Total',
u'Revenue ($)': 81.76,
u'SKU': None,
u'Sales ($)': 114.76,
u'Sales incl. tax ($)': 131.95,
u'Supplier': u'',
u'Supplier Code': u'',
u'Tags': u'',
u'Tax ($)': 17.19,
u'Type': u''},
{u'Brand': u'',
u'Cost ($)': 33.0,
u'Count': 572.0,
u'Discount ($)': 0.0,
u'Margin (%)': 71.24433,
u'Outlet': u'',
u'Product': u'Grand Total',
u'Revenue ($)': 81.76,
u'SKU': None,
u'Sales ($)': 114.76,
u'Sales incl. tax ($)': 131.95,
u'Supplier': u'',
u'Supplier Code': u'',
u'Tags': u'',
u'Tax ($)': 17.19,
u'Type': u''}]
In [112]:
saltax = []
In [113]:
for bran in tuejs:
#print bran['Revenue ($)']
print bran['Sales incl. tax ($)']
saltax.append(bran['Sales incl. tax ($)'])
8.0
0.0
0.0
0.0
68.0
0.0
20.0
0.0
24.0
0.0
0.0
12.0
0.0
131.95
131.95
In [114]:
satxtot = sum(saltax)
In [115]:
satxtot
Out[115]:
395.9
In [116]:
for bran in tuejs:
#print bran['Revenue ($)']
print bran['Product']
Cappuccino
Cappuccino FREE
Chai Latte FREE
Espresso FREE
Flat White
Flat White FREE
Hot Chocolate
Hot Chocolate FREE
Long Black
Long Black FREE
Macchiato FREE
Mocha
Mocha FREE
Total
Grand Total
In [116]:
In [116]:
In [ ]:
Content source: wcmckee/wcmckee.com
Similar notebooks: