{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Instructions","Mariya Sergienko","Jan Kotas","Andrew Cencini","Nancy Freehafer","Michael Neipper","Anne Larsen","Laura Giussani","John Smith","Robert Zare","talal","mhsen"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":11,"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":"Instructions","index":0,"n_rows":4,"n_cols":1,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Open the VB Editor to view the macro code."]
["You can copy/paste or move the code module into your Personal Macro Workbook or any other macro enabled file."]
["Post & Videos on Personal Macro Workbook"]
["The macro runs on the active workbook.  You can change the reference for the wb variable if you want to run it on a specific workbook."]

{"sheet":"Mariya Sergienko","index":1,"n_rows":38,"n_cols":11,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
["Order Details for Mariya Sergienko"]
[]
["Order ID","Order Date","Region","Payment Type","Product Name","Category","Unit Price","Quantity","Revenue","Shipping Fee","Rep"]
[1001,"2019-01-27","West","Check","Beer","Beverages",14,49,686,66.542000000000002,"Mariya Sergienko"]
[1002,"2019-01-27","West","Check","Dried Plums","Dried Fruit & Nuts",3.5,47,164.5,16.6145,"Mariya Sergienko"]
[1006,"2019-01-12","West","Credit Card","Chai","Beverages",18,81,1458,141.42600000000002,"Mariya Sergienko"]
[1007,"2019-01-12","West","Credit Card","Coffee","Beverages",46,44,2024,198.352,"Mariya Sergienko"]
[1011,"2019-01-03","West","Cash","Clam Chowder","Soups",9.65,91,878.15,92.205749999999995,"Mariya Sergienko"]
[1031,"2019-02-03","West","Cash","Syrup","Condiments",10,63,630,65.52,"Mariya Sergienko"]
[1032,"2019-02-03","West","Cash","Curry Sauce","Sauces",40,30,1200,120,"Mariya Sergienko"]
[1051,"2019-02-03","West",null,"Green Tea","Beverages",2.99,75,224.25000000000003,23.097750000000005,"Mariya Sergienko"]
[1070,"2019-03-03","West","Cash","Syrup","Condiments",10,48,480,48,"Mariya Sergienko"]
[1071,"2019-03-03","West","Cash","Curry Sauce","Sauces",40,71,2840,295.36,"Mariya Sergienko"]
[1082,"2019-04-12","West","Credit Card","Chai","Beverages",18,74,1332,137.19600000000003,"Mariya Sergienko"]
[1083,"2019-04-12","West","Credit Card","Coffee","Beverages",46,96,4416,428.35200000000003,"Mariya Sergienko"]
[1087,"2019-04-03","West","Cash","Clam Chowder","Soups",9.65,95,916.75,91.675000000000011,"Mariya Sergienko"]
[1100,"2019-05-03","West","Cash","Clam Chowder","Soups",9.65,43,414.95,42.324900000000007,"Mariya Sergienko"]
[1134,"2019-05-03","West","Cash","Syrup","Condiments",10,82,820,85.28,"Mariya Sergienko"]
[1135,"2019-05-03","West","Cash","Curry Sauce","Sauces",40,98,3920,411.6,"Mariya Sergienko"]
[1167,"2019-06-03","West","Cash","Syrup","Condiments",10,24,240,25.200000000000003,"Mariya Sergienko"]
[1168,"2019-06-03","West","Cash","Curry Sauce","Sauces",40,28,1120,109.75999999999999,"Mariya Sergienko"]
[1187,"2019-06-03","West",null,"Green Tea","Beverages",2.99,88,263.12,25.522639999999999,"Mariya Sergienko"]
[1209,"2019-07-03","West","Cash","Syrup","Condiments",10,99,990,95.039999999999992,"Mariya Sergienko"]
[1210,"2019-07-03","West","Cash","Curry Sauce","Sauces",40,10,400,40,"Mariya Sergienko"]
[1276,"2019-09-03","West","Cash","Syrup","Condiments",10,71,710,73.13,"Mariya Sergienko"]
[1277,"2019-09-03","West","Cash","Curry Sauce","Sauces",40,88,3520,366.08000000000004,"Mariya Sergienko"]
[1315,"2019-10-03","West","Cash","Syrup","Condiments",10,11,110,11.440000000000001,"Mariya Sergienko"]
[1316,"2019-10-03","West","Cash","Curry Sauce","Sauces",40,91,3640,364,"Mariya Sergienko"]
[1356,"2019-11-03","West","Cash","Syrup","Condiments",10,36,360,37.08,"Mariya Sergienko"]
[1357,"2019-11-03","West","Cash","Curry Sauce","Sauces",40,24,960,96,"Mariya Sergienko"]
[1368,"2019-12-27","West","Check","Beer","Beverages",14,14,196,19.796000000000003,"Mariya Sergienko"]
[1369,"2019-12-27","West","Check","Dried Plums","Dried Fruit & Nuts",3.5,70,245,25.234999999999999,"Mariya Sergienko"]
[1373,"2019-12-12","West","Credit Card","Chai","Beverages",18,57,1026,102.60000000000001,"Mariya Sergienko"]
[1374,"2019-12-12","West","Credit Card","Coffee","Beverages",46,83,3818,374.16399999999999,"Mariya Sergienko"]
[1378,"2019-12-03","West","Cash","Clam Chowder","Soups",9.65,96,926.40000000000009,94.492800000000017,"Mariya Sergienko"]
[1412,"2019-12-03","West","Cash","Syrup","Condiments",10,89,890,87.22,"Mariya Sergienko"]
[1413,"2019-12-03","West","Cash","Curry Sauce","Sauces",40,12,480,46.56,"Mariya Sergienko"]
[1432,"2019-12-03","West",null,"Green Tea","Beverages",2.99,24,71.760000000000005,7.1042400000000008,"Mariya Sergienko"]

{"sheet":"Jan Kotas","index":2,"n_rows":19,"n_cols":11,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Order Details for Jan Kotas"]
[]
["Order ID","Order Date","Region","Payment Type","Product Name","Category","Unit Price","Quantity","Revenue","Shipping Fee","Rep"]
[1010,"2019-01-29","West","Check","Chocolate","Candy",12.75,94,1198.5,122.24700000000001,"Jan Kotas"]
[1047,"2019-03-01","West","Check","Fruit Cocktail","Fruit & Veg",39,26,1014,106.47000000000001,"Jan Kotas"]
[1061,"2019-03-29","West","Check","Beer","Beverages",14,72,1008,100.80000000000001,"Jan Kotas"]
[1086,"2019-04-29","West","Check","Chocolate","Candy",12.75,35,446.25,45.963750000000005,"Jan Kotas"]
[1099,"2019-05-29","West","Check","Chocolate","Candy",12.75,14,178.5,16.9575,"Jan Kotas"]
[1125,"2019-05-29","West","Check","Beer","Beverages",14,21,294,30.870000000000005,"Jan Kotas"]
[1158,"2019-06-29","West","Check","Beer","Beverages",14,79,1106,113.91800000000001,"Jan Kotas"]
[1183,"2019-06-29","West","Check","Fruit Cocktail","Fruit & Veg",39,98,3822,397.48800000000006,"Jan Kotas"]
[1200,"2019-07-29","West","Check","Beer","Beverages",14,23,322,30.912000000000003,"Jan Kotas"]
[1245,"2019-08-29","West","Check","Beer","Beverages",14,42,588,59.388000000000005,"Jan Kotas"]
[1267,"2019-09-29","West","Check","Beer","Beverages",14,50,700,67.2,"Jan Kotas"]
[1306,"2019-10-29","West","Check","Beer","Beverages",14,78,1092,112.476,"Jan Kotas"]
[1347,"2019-11-29","West","Check","Beer","Beverages",14,38,532,55.328000000000003,"Jan Kotas"]
[1377,"2019-12-29","West","Check","Chocolate","Candy",12.75,47,599.25,59.325750000000006,"Jan Kotas"]
[1403,"2019-12-29","West","Check","Beer","Beverages",14,96,1344,141.12,"Jan Kotas"]
[1428,"2019-12-29","West","Check","Fruit Cocktail","Fruit & Veg",39,54,2106,214.81200000000004,"Jan Kotas"]

{"sheet":"Andrew Cencini","index":3,"n_rows":34,"n_cols":11,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
["Order Details for Andrew Cencini"]
[]
["Order ID","Order Date","Region","Payment Type","Product Name","Category","Unit Price","Quantity","Revenue","Shipping Fee","Rep"]
[1003,"2019-01-04","East","Credit Card","Dried Pears","Dried Fruit & Nuts",30,69,2070,198.72,"Andrew Cencini"]
[1004,"2019-01-04","East","Credit Card","Dried Apples","Dried Fruit & Nuts",53,89,4717,448.11500000000001,"Andrew Cencini"]
[1005,"2019-01-04","East","Credit Card","Dried Plums","Dried Fruit & Nuts",3.5,11,38.5,3.7345000000000002,"Andrew Cencini"]
[1009,"2019-01-04","East","Check","Chocolate Biscuits Mix","Baked Goods & Mixes",9.1999999999999993,88,809.59999999999991,79.340799999999987,"Andrew Cencini"]
[1050,"2019-02-04","East",null,"Gnocchi","Pasta",38,96,3648,346.56,"Andrew Cencini"]
[1064,"2019-03-04","East","Credit Card","Marmalade","Jams, Preserves",81,77,6237,642.41100000000006,"Andrew Cencini"]
[1065,"2019-03-04","East","Credit Card","Long Grain Rice","Grains",7,37,259,24.605,"Andrew Cencini"]
[1081,"2019-04-04","East","Credit Card","Dried Plums","Dried Fruit & Nuts",3.5,48,168,16.295999999999999,"Andrew Cencini"]
[1085,"2019-04-04","East","Check","Chocolate Biscuits Mix","Baked Goods & Mixes",9.1999999999999993,62,570.4,58.751199999999997,"Andrew Cencini"]
[1128,"2019-05-04","East","Credit Card","Marmalade","Jams, Preserves",81,23,1863,195.61500000000001,"Andrew Cencini"]
[1129,"2019-05-04","East","Credit Card","Long Grain Rice","Grains",7,72,504,51.912000000000006,"Andrew Cencini"]
[1161,"2019-06-04","East","Credit Card","Marmalade","Jams, Preserves",81,98,7938,769.98599999999999,"Andrew Cencini"]
[1162,"2019-06-04","East","Credit Card","Long Grain Rice","Grains",7,61,427,42.273000000000003,"Andrew Cencini"]
[1186,"2019-06-04","East",null,"Gnocchi","Pasta",38,85,3230,319.77,"Andrew Cencini"]
[1203,"2019-07-04","East","Credit Card","Marmalade","Jams, Preserves",81,55,4455,445.5,"Andrew Cencini"]
[1204,"2019-07-04","East","Credit Card","Long Grain Rice","Grains",7,19,133,12.901,"Andrew Cencini"]
[1248,"2019-08-04","East","Credit Card","Marmalade","Jams, Preserves",81,32,2592,251.42399999999998,"Andrew Cencini"]
[1249,"2019-08-04","East","Credit Card","Long Grain Rice","Grains",7,76,532,53.732000000000006,"Andrew Cencini"]
[1270,"2019-09-04","East","Credit Card","Marmalade","Jams, Preserves",81,54,4374,437.40000000000003,"Andrew Cencini"]
[1271,"2019-09-04","East","Credit Card","Long Grain Rice","Grains",7,39,273,27.3,"Andrew Cencini"]
[1309,"2019-10-04","East","Credit Card","Marmalade","Jams, Preserves",81,82,6642,697.41000000000008,"Andrew Cencini"]
[1310,"2019-10-04","East","Credit Card","Long Grain Rice","Grains",7,29,203,20.3,"Andrew Cencini"]
[1350,"2019-11-04","East","Credit Card","Marmalade","Jams, Preserves",81,52,4212,412.77600000000001,"Andrew Cencini"]
[1351,"2019-11-04","East","Credit Card","Long Grain Rice","Grains",7,37,259,25.382000000000001,"Andrew Cencini"]
[1370,"2019-12-04","East","Credit Card","Dried Pears","Dried Fruit & Nuts",30,100,3000,291,"Andrew Cencini"]
[1371,"2019-12-04","East","Credit Card","Dried Apples","Dried Fruit & Nuts",53,27,1431,143.1,"Andrew Cencini"]
[1372,"2019-12-04","East","Credit Card","Dried Plums","Dried Fruit & Nuts",3.5,70,245,24.009999999999998,"Andrew Cencini"]
[1376,"2019-12-04","East","Check","Chocolate Biscuits Mix","Baked Goods & Mixes",9.1999999999999993,80,736,72.864000000000004,"Andrew Cencini"]
[1406,"2019-12-04","East","Credit Card","Marmalade","Jams, Preserves",81,38,3078,292.41000000000003,"Andrew Cencini"]
[1407,"2019-12-04","East","Credit Card","Long Grain Rice","Grains",7,42,294,29.106000000000002,"Andrew Cencini"]
[1431,"2019-12-04","East",null,"Gnocchi","Pasta",38,59,2242,226.44200000000001,"Andrew Cencini"]

{"sheet":"Nancy Freehafer","index":4,"n_rows":84,"n_cols":11,"rows_kept":84,"cut":false,"hidden":false,"merged":[]}
["Order Details for Nancy Freehafer"]
[]
["Order ID","Order Date","Region","Payment Type","Product Name","Category","Unit Price","Quantity","Revenue","Shipping Fee","Rep"]
[1008,"2019-01-08","North","Credit Card","Chocolate Biscuits Mix","Baked Goods & Mixes",9.1999999999999993,38,349.59999999999997,36.008800000000001,"Nancy Freehafer"]
[1014,"2019-01-08","North","Check","Chocolate","Candy",12.75,47,599.25,61.722750000000005,"Nancy Freehafer"]
[1016,"2019-01-07","North",null,"Coffee","Beverages",46,24,1104,110.4,"Nancy Freehafer"]
[1022,"2019-01-01","North",null,"Chai","Beverages",18,42,756,75.600000000000009,"Nancy Freehafer"]
[1023,"2019-01-01","North",null,"Coffee","Beverages",46,58,2668,269.46800000000002,"Nancy Freehafer"]
[1024,"2019-01-01","North",null,"Green Tea","Beverages",2.99,67,200.33,20.033000000000001,"Nancy Freehafer"]
[1030,"2019-02-08","North","Check","Curry Sauce","Sauces",40,32,1280,129.28,"Nancy Freehafer"]
[1035,"2019-02-08","North","Check",null,null,null,null,0,46,"Nancy Freehafer"]
[1040,"2019-02-01","North",null,"Crab Meat","Canned Meat",18.399999999999999,13,239.2,23.680800000000001,"Nancy Freehafer"]
[1044,"2019-02-08","North","Check","Chocolate","Candy",12.75,13,165.75,15.746249999999998,"Nancy Freehafer"]
[1055,"2019-03-08","North","Check","Curry Sauce","Sauces",40,85,3400,357,"Nancy Freehafer"]
[1056,"2019-03-08","North","Check","Chocolate Biscuits Mix","Baked Goods & Mixes",9.1999999999999993,97,892.4,91.024800000000013,"Nancy Freehafer"]
[1067,"2019-03-08","North","Credit Card","Mozzarella","Dairy Products",34.799999999999997,63,2192.3999999999996,217.04759999999999,"Nancy Freehafer"]
[1079,"2019-03-01","North",null,"Crab Meat","Canned Meat",18.399999999999999,75,1380,138,"Nancy Freehafer"]
[1084,"2019-04-08","North","Credit Card","Chocolate Biscuits Mix","Baked Goods & Mixes",9.1999999999999993,12,110.39999999999999,11.3712,"Nancy Freehafer"]
[1090,"2019-04-08","North","Check","Chocolate","Candy",12.75,83,1058.25,102.65025,"Nancy Freehafer"]
[1092,"2019-04-07","North",null,"Coffee","Beverages",46,59,2714,284.97000000000003,"Nancy Freehafer"]
[1098,"2019-04-01","North",null,"Chai","Beverages",18,55,990,97.02,"Nancy Freehafer"]
[1103,"2019-05-08","North","Check","Chocolate","Candy",12.75,41,522.75,54.366000000000007,"Nancy Freehafer"]
[1105,"2019-05-07","North",null,"Coffee","Beverages",46,31,1426,136.89599999999999,"Nancy Freehafer"]
[1111,"2019-05-01","North",null,"Chai","Beverages",18,29,522,52.722000000000001,"Nancy Freehafer"]
[1112,"2019-05-01","North",null,"Coffee","Beverages",46,77,3542,368.36800000000005,"Nancy Freehafer"]
[1113,"2019-05-01","North",null,"Green Tea","Beverages",2.99,73,218.27,21.827000000000002,"Nancy Freehafer"]
[1119,"2019-05-08","North","Check","Curry Sauce","Sauces",40,73,2920,283.24,"Nancy Freehafer"]
[1120,"2019-05-08","North","Check","Chocolate Biscuits Mix","Baked Goods & Mixes",9.1999999999999993,51,469.2,44.573999999999998,"Nancy Freehafer"]
[1131,"2019-05-08","North","Credit Card","Mozzarella","Dairy Products",34.799999999999997,22,765.59999999999991,75.02879999999999,"Nancy Freehafer"]
[1138,"2019-06-07","North",null,"Coffee","Beverages",46,71,3266,310.27,"Nancy Freehafer"]
[1144,"2019-06-01","North",null,"Chai","Beverages",18,33,594,58.212000000000003,"Nancy Freehafer"]
[1145,"2019-06-01","North",null,"Coffee","Beverages",46,22,1012,101.2,"Nancy Freehafer"]
[1146,"2019-06-01","North",null,"Green Tea","Beverages",2.99,51,152.49,14.944020000000002,"Nancy Freehafer"]
[1152,"2019-06-08","North","Check","Curry Sauce","Sauces",40,38,1520,148.96,"Nancy Freehafer"]
[1153,"2019-06-08","North","Check","Chocolate Biscuits Mix","Baked Goods & Mixes",9.1999999999999993,80,736,70.656000000000006,"Nancy Freehafer"]
[1164,"2019-06-08","North","Credit Card","Mozzarella","Dairy Products",34.799999999999997,30,1044,109.62,"Nancy Freehafer"]
[1176,"2019-06-01","North",null,"Crab Meat","Canned Meat",18.399999999999999,71,1306.3999999999999,137.172,"Nancy Freehafer"]
[1180,"2019-06-08","North","Check","Chocolate","Candy",12.75,92,1173,116.12700000000001,"Nancy Freehafer"]
[1188,"2019-07-01","North",null,"Green Tea","Beverages",2.99,81,242.19000000000003,23.976810000000004,"Nancy Freehafer"]
[1194,"2019-07-08","North","Check","Curry Sauce","Sauces",40,91,3640,360.36,"Nancy Freehafer"]
[1195,"2019-07-08","North","Check","Chocolate Biscuits Mix","Baked Goods & Mixes",9.1999999999999993,36,331.2,34.444800000000001,"Nancy Freehafer"]
[1206,"2019-07-08","North","Credit Card","Mozzarella","Dairy Products",34.799999999999997,27,939.59999999999991,89.261999999999986,"Nancy Freehafer"]
[1218,"2019-07-01","North",null,"Crab Meat","Canned Meat",18.399999999999999,42,772.8,80.371200000000002,"Nancy Freehafer"]
[1223,"2019-08-08","North","Check","Chocolate","Candy",12.75,57,726.75,69.768000000000001,"Nancy Freehafer"]
[1225,"2019-08-07","North",null,"Coffee","Beverages",46,86,3956,399.55600000000004,"Nancy Freehafer"]
[1231,"2019-08-01","North",null,"Chai","Beverages",18,91,1638,158.886,"Nancy Freehafer"]
[1232,"2019-08-01","North",null,"Coffee","Beverages",46,14,644,63.756000000000007,"Nancy Freehafer"]
[1233,"2019-08-01","North",null,"Green Tea","Beverages",2.99,44,131.56,13.287560000000001,"Nancy Freehafer"]
[1239,"2019-08-08","North","Check","Curry Sauce","Sauces",40,78,3120,318.24,"Nancy Freehafer"]
[1240,"2019-08-08","North","Check","Chocolate Biscuits Mix","Baked Goods & Mixes",9.1999999999999993,54,496.79999999999995,49.183199999999999,"Nancy Freehafer"]
[1253,"2019-09-01","North",null,"Chai","Beverages",18,58,1044,103.35600000000001,"Nancy Freehafer"]
[1254,"2019-09-01","North",null,"Coffee","Beverages",46,97,4462,464.04800000000006,"Nancy Freehafer"]
[1255,"2019-09-01","North",null,"Green Tea","Beverages",2.99,14,41.86,4.35344,"Nancy Freehafer"]
[1261,"2019-09-08","North","Check","Curry Sauce","Sauces",40,48,1920,188.16,"Nancy Freehafer"]
[1262,"2019-09-08","North","Check","Chocolate Biscuits Mix","Baked Goods & Mixes",9.1999999999999993,77,708.4,72.256799999999998,"Nancy Freehafer"]
[1273,"2019-09-08","North","Credit Card","Mozzarella","Dairy Products",34.799999999999997,63,2192.3999999999996,230.202,"Nancy Freehafer"]
[1284,"2019-10-08","North","Check","Chocolate","Candy",12.75,61,777.75,78.552750000000003,"Nancy Freehafer"]
[1286,"2019-10-07","North",null,"Coffee","Beverages",46,62,2852,290.904,"Nancy Freehafer"]
[1292,"2019-10-01","North",null,"Chai","Beverages",18,22,396,38.015999999999998,"Nancy Freehafer"]
[1293,"2019-10-01","North",null,"Coffee","Beverages",46,73,3358,339.15800000000002,"Nancy Freehafer"]
[1294,"2019-10-01","North",null,"Green Tea","Beverages",2.99,85,254.15,24.652550000000002,"Nancy Freehafer"]
[1300,"2019-10-08","North","Check","Curry Sauce","Sauces",40,48,1920,188.16,"Nancy Freehafer"]
[1301,"2019-10-08","North","Check","Chocolate Biscuits Mix","Baked Goods & Mixes",9.1999999999999993,100,919.99999999999989,91.08,"Nancy Freehafer"]
[1312,"2019-10-08","North","Credit Card","Mozzarella","Dairy Products",34.799999999999997,93,3236.3999999999996,313.93079999999998,"Nancy Freehafer"]
[1324,"2019-10-01","North",null,"Crab Meat","Canned Meat",18.399999999999999,23,423.2,43.589600000000004,"Nancy Freehafer"]
[1328,"2019-10-08","North","Check","Chocolate","Candy",12.75,43,548.25,52.631999999999998,"Nancy Freehafer"]
[1333,"2019-11-01","North",null,"Chai","Beverages",18,42,756,76.356000000000009,"Nancy Freehafer"]
[1334,"2019-11-01","North",null,"Coffee","Beverages",46,16,736,70.656000000000006,"Nancy Freehafer"]
[1335,"2019-11-01","North",null,"Green Tea","Beverages",2.99,22,65.78,6.3806599999999998,"Nancy Freehafer"]
[1341,"2019-11-08","North","Check","Curry Sauce","Sauces",40,28,1120,110.88,"Nancy Freehafer"]
[1342,"2019-11-08","North","Check","Chocolate Biscuits Mix","Baked Goods & Mixes",9.1999999999999993,19,174.79999999999998,17.130400000000002,"Nancy Freehafer"]
[1353,"2019-11-08","North","Credit Card","Mozzarella","Dairy Products",34.799999999999997,24,835.19999999999993,80.179199999999994,"Nancy Freehafer"]
[1365,"2019-11-01","North",null,"Crab Meat","Canned Meat",18.399999999999999,76,1398.3999999999999,144.0352,"Nancy Freehafer"]
[1375,"2019-12-08","North","Credit Card","Chocolate Biscuits Mix","Baked Goods & Mixes",9.1999999999999993,76,699.19999999999993,67.123199999999997,"Nancy Freehafer"]
[1381,"2019-12-08","North","Check","Chocolate","Candy",12.75,41,522.75,51.229500000000002,"Nancy Freehafer"]
[1383,"2019-12-07","North",null,"Coffee","Beverages",46,41,1886,194.25800000000004,"Nancy Freehafer"]
[1389,"2019-12-01","North",null,"Chai","Beverages",18,99,1782,174.63600000000002,"Nancy Freehafer"]
[1390,"2019-12-01","North",null,"Coffee","Beverages",46,89,4094,388.93,"Nancy Freehafer"]
[1391,"2019-12-01","North",null,"Green Tea","Beverages",2.99,64,191.36,19.518720000000002,"Nancy Freehafer"]
[1397,"2019-12-08","North","Check","Curry Sauce","Sauces",40,52,2080,203.84,"Nancy Freehafer"]
[1398,"2019-12-08","North","Check","Chocolate Biscuits Mix","Baked Goods & Mixes",9.1999999999999993,40,368,38.640000000000008,"Nancy Freehafer"]
[1409,"2019-12-08","North","Credit Card","Mozzarella","Dairy Products",34.799999999999997,100,3479.9999999999995,344.52,"Nancy Freehafer"]
[1421,"2019-12-01","North",null,"Crab Meat","Canned Meat",18.399999999999999,45,827.99999999999989,81.143999999999991,"Nancy Freehafer"]
[1425,"2019-12-08","North","Check","Chocolate","Candy",12.75,19,242.25,23.982750000000003,"Nancy Freehafer"]

{"sheet":"Michael Neipper","index":5,"n_rows":39,"n_cols":11,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
["Order Details for Michael Neipper"]
[]
["Order ID","Order Date","Region","Payment Type","Product Name","Category","Unit Price","Quantity","Revenue","Shipping Fee","Rep"]
[1012,"2019-01-06","North","Credit Card","Curry Sauce","Sauces",40,32,1280,133.12,"Michael Neipper"]
[1029,"2019-01-06","North","Credit Card","Beer","Beverages",14,71,994,95.424000000000007,"Michael Neipper"]
[1033,"2019-02-06","North","Credit Card",null,null,null,null,0,43,"Michael Neipper"]
[1043,"2019-02-06","North","Credit Card","Chocolate","Candy",12.75,71,905.25,91.430250000000001,"Michael Neipper"]
[1048,"2019-02-06","North","Check","Dried Pears","Dried Fruit & Nuts",30,96,2880,296.64,"Michael Neipper"]
[1049,"2019-02-06","North","Check","Dried Apples","Dried Fruit & Nuts",53,16,848,88.192000000000021,"Michael Neipper"]
[1054,"2019-03-06","North","Credit Card","Beer","Beverages",14,53,742,71.974000000000004,"Michael Neipper"]
[1062,"2019-03-06","North","Check","Chocolate","Candy",12.75,16,204,20.196000000000002,"Michael Neipper"]
[1088,"2019-04-06","North","Credit Card","Curry Sauce","Sauces",40,17,680,68.680000000000007,"Michael Neipper"]
[1101,"2019-05-06","North","Credit Card","Curry Sauce","Sauces",40,63,2520,254.52,"Michael Neipper"]
[1118,"2019-05-06","North","Credit Card","Beer","Beverages",14,84,1176,112.896,"Michael Neipper"]
[1126,"2019-05-06","North","Check","Chocolate","Candy",12.75,19,242.25,24.46725,"Michael Neipper"]
[1151,"2019-06-06","North","Credit Card","Beer","Beverages",14,65,910,95.55,"Michael Neipper"]
[1159,"2019-06-06","North","Check","Chocolate","Candy",12.75,44,561,57.222000000000001,"Michael Neipper"]
[1179,"2019-06-06","North","Credit Card","Chocolate","Candy",12.75,96,1224,123.62400000000001,"Michael Neipper"]
[1184,"2019-06-06","North","Check","Dried Pears","Dried Fruit & Nuts",30,46,1380,135.24,"Michael Neipper"]
[1185,"2019-06-06","North","Check","Dried Apples","Dried Fruit & Nuts",53,14,742,74.2,"Michael Neipper"]
[1193,"2019-07-06","North","Credit Card","Beer","Beverages",14,84,1176,118.77600000000001,"Michael Neipper"]
[1201,"2019-07-06","North","Check","Chocolate","Candy",12.75,76,969,97.869,"Michael Neipper"]
[1221,"2019-07-06","North","Credit Card","Chocolate","Candy",12.75,28,357,35.700000000000003,"Michael Neipper"]
[1238,"2019-08-06","North","Credit Card","Beer","Beverages",14,52,728,72.8,"Michael Neipper"]
[1246,"2019-08-06","North","Check","Chocolate","Candy",12.75,72,918,89.046000000000006,"Michael Neipper"]
[1260,"2019-09-06","North","Credit Card","Beer","Beverages",14,67,938,98.490000000000009,"Michael Neipper"]
[1268,"2019-09-06","North","Check","Chocolate","Candy",12.75,96,1224,119.952,"Michael Neipper"]
[1282,"2019-10-06","North","Credit Card","Curry Sauce","Sauces",40,94,3760,376,"Michael Neipper"]
[1299,"2019-10-06","North","Credit Card","Beer","Beverages",14,98,1372,138.57200000000003,"Michael Neipper"]
[1307,"2019-10-06","North","Check","Chocolate","Candy",12.75,44,561,53.856000000000002,"Michael Neipper"]
[1327,"2019-10-06","North","Credit Card","Chocolate","Candy",12.75,82,1045.5,103.50450000000001,"Michael Neipper"]
[1340,"2019-11-06","North","Credit Card","Beer","Beverages",14,85,1190,120.19,"Michael Neipper"]
[1348,"2019-11-06","North","Check","Chocolate","Candy",12.75,15,191.25,18.55125,"Michael Neipper"]
[1379,"2019-12-06","North","Credit Card","Curry Sauce","Sauces",40,32,1280,134.4,"Michael Neipper"]
[1396,"2019-12-06","North","Credit Card","Beer","Beverages",14,68,952,91.391999999999996,"Michael Neipper"]
[1404,"2019-12-06","North","Check","Chocolate","Candy",12.75,12,153,16.065000000000001,"Michael Neipper"]
[1424,"2019-12-06","North","Credit Card","Chocolate","Candy",12.75,41,522.75,50.706750000000007,"Michael Neipper"]
[1429,"2019-12-06","North","Check","Dried Pears","Dried Fruit & Nuts",30,33,990,95.039999999999992,"Michael Neipper"]
[1430,"2019-12-06","North","Check","Dried Apples","Dried Fruit & Nuts",53,34,1802,185.60600000000002,"Michael Neipper"]

{"sheet":"Anne Larsen","index":6,"n_rows":90,"n_cols":11,"rows_kept":90,"cut":false,"hidden":false,"merged":[]}
["Order Details for Anne Larsen"]
[]
["Order ID","Order Date","Region","Payment Type","Product Name","Category","Unit Price","Quantity","Revenue","Shipping Fee","Rep"]
[1013,"2019-01-28","South","Check","Coffee","Beverages",46,55,2530,253,"Anne Larsen"]
[1020,"2019-01-11","South",null,"Dried Plums","Dried Fruit & Nuts",3.5,81,283.5,27.499500000000001,"Anne Larsen"]
[1021,"2019-01-11","South",null,"Green Tea","Beverages",2.99,49,146.51000000000002,15.090530000000005,"Anne Larsen"]
[1025,"2019-01-28","South","Credit Card","Clam Chowder","Soups",9.65,100,965,93.605000000000004,"Anne Larsen"]
[1026,"2019-01-28","South","Credit Card","Crab Meat","Canned Meat",18.399999999999999,63,1159.1999999999998,114.76079999999999,"Anne Larsen"]
[1034,"2019-02-28","South","Check",null,null,null,null,0,31,"Anne Larsen"]
[1039,"2019-02-11","South",null,"Curry Sauce","Sauces",40,72,2880,285.12,"Anne Larsen"]
[1041,"2019-02-28","South","Credit Card","Coffee","Beverages",46,32,1472,148.67200000000003,"Anne Larsen"]
[1046,"2019-02-26","South","Credit Card","Boysenberry Spread","Jams, Preserves",25,21,525,53.550000000000004,"Anne Larsen"]
[1058,"2019-03-26","South","Credit Card","Olive Oil","Oil",21.35,97,2070.9500000000003,196.74025,"Anne Larsen"]
[1059,"2019-03-26","South","Credit Card","Clam Chowder","Soups",9.65,97,936.05000000000007,95.477100000000021,"Anne Larsen"]
[1060,"2019-03-26","South","Credit Card","Crab Meat","Canned Meat",18.399999999999999,65,1196,123.18800000000002,"Anne Larsen"]
[1078,"2019-03-11","South",null,"Curry Sauce","Sauces",40,67,2680,270.68,"Anne Larsen"]
[1080,"2019-03-28","South","Credit Card","Coffee","Beverages",46,17,782,80.546000000000006,"Anne Larsen"]
[1089,"2019-04-28","South","Check","Coffee","Beverages",46,96,4416,463.68000000000006,"Anne Larsen"]
[1096,"2019-04-11","South",null,"Dried Plums","Dried Fruit & Nuts",3.5,71,248.5,24.104500000000002,"Anne Larsen"]
[1097,"2019-04-11","South",null,"Green Tea","Beverages",2.99,88,263.12,26.04888,"Anne Larsen"]
[1102,"2019-05-28","South","Check","Coffee","Beverages",46,36,1656,165.60000000000002,"Anne Larsen"]
[1109,"2019-05-11","South",null,"Dried Plums","Dried Fruit & Nuts",3.5,44,154,15.246,"Anne Larsen"]
[1110,"2019-05-11","South",null,"Green Tea","Beverages",2.99,77,230.23000000000002,23.023000000000003,"Anne Larsen"]
[1114,"2019-05-28","South","Credit Card","Clam Chowder","Soups",9.65,74,714.1,67.839500000000001,"Anne Larsen"]
[1115,"2019-05-28","South","Credit Card","Crab Meat","Canned Meat",18.399999999999999,25,459.99999999999994,46.46,"Anne Larsen"]
[1122,"2019-05-26","South","Credit Card","Olive Oil","Oil",21.35,36,768.6,74.554200000000009,"Anne Larsen"]
[1123,"2019-05-26","South","Credit Card","Clam Chowder","Soups",9.65,87,839.55000000000007,87.313200000000009,"Anne Larsen"]
[1124,"2019-05-26","South","Credit Card","Crab Meat","Canned Meat",18.399999999999999,64,1177.5999999999999,115.40479999999999,"Anne Larsen"]
[1142,"2019-06-11","South",null,"Dried Plums","Dried Fruit & Nuts",3.5,28,98,10.290000000000001,"Anne Larsen"]
[1143,"2019-06-11","South",null,"Green Tea","Beverages",2.99,60,179.4,17.581200000000003,"Anne Larsen"]
[1147,"2019-06-28","South","Credit Card","Clam Chowder","Soups",9.65,60,579,57.321000000000005,"Anne Larsen"]
[1148,"2019-06-28","South","Credit Card","Crab Meat","Canned Meat",18.399999999999999,98,1803.1999999999998,183.9264,"Anne Larsen"]
[1155,"2019-06-26","South","Credit Card","Olive Oil","Oil",21.35,90,1921.5000000000002,186.38550000000004,"Anne Larsen"]
[1156,"2019-06-26","South","Credit Card","Clam Chowder","Soups",9.65,60,579,59.637000000000008,"Anne Larsen"]
[1157,"2019-06-26","South","Credit Card","Crab Meat","Canned Meat",18.399999999999999,39,717.59999999999991,71.759999999999991,"Anne Larsen"]
[1175,"2019-06-11","South",null,"Curry Sauce","Sauces",40,27,1080,111.24000000000001,"Anne Larsen"]
[1177,"2019-06-28","South","Credit Card","Coffee","Beverages",46,74,3404,340.40000000000003,"Anne Larsen"]
[1182,"2019-06-26","South","Credit Card","Boysenberry Spread","Jams, Preserves",25,18,450,42.75,"Anne Larsen"]
[1189,"2019-07-28","South","Credit Card","Clam Chowder","Soups",9.65,33,318.45,30.252749999999999,"Anne Larsen"]
[1190,"2019-07-28","South","Credit Card","Crab Meat","Canned Meat",18.399999999999999,47,864.8,90.804000000000002,"Anne Larsen"]
[1197,"2019-07-26","South","Credit Card","Olive Oil","Oil",21.35,81,1729.3500000000001,178.12305000000003,"Anne Larsen"]
[1198,"2019-07-26","South","Credit Card","Clam Chowder","Soups",9.65,25,241.25,23.401250000000001,"Anne Larsen"]
[1199,"2019-07-26","South","Credit Card","Crab Meat","Canned Meat",18.399999999999999,12,220.79999999999998,22.08,"Anne Larsen"]
[1217,"2019-07-11","South",null,"Curry Sauce","Sauces",40,97,3880,380.24,"Anne Larsen"]
[1219,"2019-07-28","South","Credit Card","Coffee","Beverages",46,24,1104,105.98399999999999,"Anne Larsen"]
[1222,"2019-08-28","South","Check","Coffee","Beverages",46,28,1288,133.95200000000003,"Anne Larsen"]
[1229,"2019-08-11","South",null,"Dried Plums","Dried Fruit & Nuts",3.5,31,108.5,10.850000000000001,"Anne Larsen"]
[1230,"2019-08-11","South",null,"Green Tea","Beverages",2.99,52,155.48000000000002,16.014440000000004,"Anne Larsen"]
[1234,"2019-08-28","South","Credit Card","Clam Chowder","Soups",9.65,97,936.05000000000007,95.477100000000021,"Anne Larsen"]
[1235,"2019-08-28","South","Credit Card","Crab Meat","Canned Meat",18.399999999999999,80,1472,150.14400000000003,"Anne Larsen"]
[1242,"2019-08-26","South","Credit Card","Olive Oil","Oil",21.35,60,1281,129.381,"Anne Larsen"]
[1243,"2019-08-26","South","Credit Card","Clam Chowder","Soups",9.65,19,183.35,17.41825,"Anne Larsen"]
[1244,"2019-08-26","South","Credit Card","Crab Meat","Canned Meat",18.399999999999999,66,1214.3999999999999,125.08320000000001,"Anne Larsen"]
[1251,"2019-09-11","South",null,"Dried Plums","Dried Fruit & Nuts",3.5,91,318.5,31.213000000000001,"Anne Larsen"]
[1252,"2019-09-11","South",null,"Green Tea","Beverages",2.99,64,191.36,19.518720000000002,"Anne Larsen"]
[1256,"2019-09-28","South","Credit Card","Clam Chowder","Soups",9.65,68,656.2,64.307600000000008,"Anne Larsen"]
[1257,"2019-09-28","South","Credit Card","Crab Meat","Canned Meat",18.399999999999999,32,588.79999999999995,58.879999999999995,"Anne Larsen"]
[1264,"2019-09-26","South","Credit Card","Olive Oil","Oil",21.35,54,1152.9000000000001,121.05450000000003,"Anne Larsen"]
[1265,"2019-09-26","South","Credit Card","Clam Chowder","Soups",9.65,43,414.95,40.250150000000005,"Anne Larsen"]
[1266,"2019-09-26","South","Credit Card","Crab Meat","Canned Meat",18.399999999999999,71,1306.3999999999999,134.55919999999998,"Anne Larsen"]
[1283,"2019-10-28","South","Check","Coffee","Beverages",46,86,3956,379.77600000000001,"Anne Larsen"]
[1290,"2019-10-11","South",null,"Dried Plums","Dried Fruit & Nuts",3.5,20,70,6.93,"Anne Larsen"]
[1291,"2019-10-11","South",null,"Green Tea","Beverages",2.99,49,146.51000000000002,14.651000000000003,"Anne Larsen"]
[1295,"2019-10-28","South","Credit Card","Clam Chowder","Soups",9.65,44,424.6,44.158400000000007,"Anne Larsen"]
[1296,"2019-10-28","South","Credit Card","Crab Meat","Canned Meat",18.399999999999999,24,441.59999999999997,42.835199999999993,"Anne Larsen"]
[1303,"2019-10-26","South","Credit Card","Olive Oil","Oil",21.35,49,1046.1500000000001,102.5227,"Anne Larsen"]
[1304,"2019-10-26","South","Credit Card","Clam Chowder","Soups",9.65,71,685.15,65.7744,"Anne Larsen"]
[1305,"2019-10-26","South","Credit Card","Crab Meat","Canned Meat",18.399999999999999,10,184,19.136000000000003,"Anne Larsen"]
[1323,"2019-10-11","South",null,"Curry Sauce","Sauces",40,60,2400,228,"Anne Larsen"]
[1325,"2019-10-28","South","Credit Card","Coffee","Beverages",46,34,1564,157.964,"Anne Larsen"]
[1331,"2019-11-11","South",null,"Dried Plums","Dried Fruit & Nuts",3.5,42,147,15.141000000000002,"Anne Larsen"]
[1332,"2019-11-11","South",null,"Green Tea","Beverages",2.99,100,299,30.498000000000001,"Anne Larsen"]
[1336,"2019-11-28","South","Credit Card","Clam Chowder","Soups",9.65,46,443.90000000000003,45.721700000000006,"Anne Larsen"]
[1337,"2019-11-28","South","Credit Card","Crab Meat","Canned Meat",18.399999999999999,100,1839.9999999999998,184,"Anne Larsen"]
[1344,"2019-11-26","South","Credit Card","Olive Oil","Oil",21.35,69,1473.15,153.20760000000004,"Anne Larsen"]
[1345,"2019-11-26","South","Credit Card","Clam Chowder","Soups",9.65,37,357.05,33.919750000000001,"Anne Larsen"]
[1346,"2019-11-26","South","Credit Card","Crab Meat","Canned Meat",18.399999999999999,64,1177.5999999999999,118.93759999999999,"Anne Larsen"]
[1364,"2019-11-11","South",null,"Curry Sauce","Sauces",40,78,3120,299.52,"Anne Larsen"]
[1366,"2019-11-28","South","Credit Card","Coffee","Beverages",46,57,2622,272.68799999999999,"Anne Larsen"]
[1380,"2019-12-28","South","Check","Coffee","Beverages",46,16,736,73.600000000000009,"Anne Larsen"]
[1387,"2019-12-11","South",null,"Dried Plums","Dried Fruit & Nuts",3.5,74,259,26.936000000000003,"Anne Larsen"]
[1388,"2019-12-11","South",null,"Green Tea","Beverages",2.99,53,158.47,16.005470000000003,"Anne Larsen"]
[1392,"2019-12-28","South","Credit Card","Clam Chowder","Soups",9.65,98,945.7,96.461400000000012,"Anne Larsen"]
[1393,"2019-12-28","South","Credit Card","Crab Meat","Canned Meat",18.399999999999999,86,1582.3999999999999,155.0752,"Anne Larsen"]
[1400,"2019-12-26","South","Credit Card","Olive Oil","Oil",21.35,88,1878.8000000000002,184.12240000000003,"Anne Larsen"]
[1401,"2019-12-26","South","Credit Card","Clam Chowder","Soups",9.65,46,443.90000000000003,42.614400000000003,"Anne Larsen"]
[1402,"2019-12-26","South","Credit Card","Crab Meat","Canned Meat",18.399999999999999,93,1711.1999999999998,167.69759999999999,"Anne Larsen"]
[1420,"2019-12-11","South",null,"Curry Sauce","Sauces",40,61,2440,248.88,"Anne Larsen"]
[1422,"2019-12-28","South","Credit Card","Coffee","Beverages",46,43,1978,197.8,"Anne Larsen"]
[1427,"2019-12-26","South","Credit Card","Boysenberry Spread","Jams, Preserves",25,13,325,32.174999999999997,"Anne Larsen"]

{"sheet":"Laura Giussani","index":7,"n_rows":60,"n_cols":11,"rows_kept":60,"cut":false,"hidden":false,"merged":[]}
["Order Details for Laura Giussani"]
[]
["Order ID","Order Date","Region","Payment Type","Product Name","Category","Unit Price","Quantity","Revenue","Shipping Fee","Rep"]
[1015,"2019-01-10","East","Credit Card","Green Tea","Beverages",2.99,90,269.10000000000002,27.717300000000005,"Laura Giussani"]
[1017,"2019-01-10","East",null,"Boysenberry Spread","Jams, Preserves",25,34,850,80.75,"Laura Giussani"]
[1018,"2019-01-10","East",null,"Cajun Seasoning","Condiments",22,17,374,35.903999999999996,"Laura Giussani"]
[1019,"2019-01-10","East",null,"Chocolate Biscuits Mix","Baked Goods & Mixes",9.1999999999999993,44,404.79999999999995,42.099199999999996,"Laura Giussani"]
[1036,"2019-02-10","East","Credit Card","Almonds","Dried Fruit & Nuts",10,47,470,48.88,"Laura Giussani"]
[1038,"2019-02-10","East",null,"Dried Plums","Dried Fruit & Nuts",3.5,49,171.5,16.464000000000002,"Laura Giussani"]
[1045,"2019-02-25","East","Cash","Cajun Seasoning","Condiments",22,98,2156,204.82000000000002,"Laura Giussani"]
[1057,"2019-03-25","East","Cash","Scones","Baked Goods & Mixes",10,46,460,46.46,"Laura Giussani"]
[1075,"2019-03-10","East","Credit Card","Almonds","Dried Fruit & Nuts",10,55,550,55,"Laura Giussani"]
[1077,"2019-03-10","East",null,"Dried Plums","Dried Fruit & Nuts",3.5,21,73.5,7.3500000000000005,"Laura Giussani"]
[1091,"2019-04-10","East","Credit Card","Green Tea","Beverages",2.99,88,263.12,26.04888,"Laura Giussani"]
[1093,"2019-04-10","East",null,"Boysenberry Spread","Jams, Preserves",25,27,675,68.849999999999994,"Laura Giussani"]
[1094,"2019-04-10","East",null,"Cajun Seasoning","Condiments",22,37,814,85.470000000000013,"Laura Giussani"]
[1095,"2019-04-10","East",null,"Chocolate Biscuits Mix","Baked Goods & Mixes",9.1999999999999993,75,690,69,"Laura Giussani"]
[1104,"2019-05-10","East","Credit Card","Green Tea","Beverages",2.99,35,104.65,10.255700000000001,"Laura Giussani"]
[1106,"2019-05-10","East",null,"Boysenberry Spread","Jams, Preserves",25,52,1300,123.5,"Laura Giussani"]
[1107,"2019-05-10","East",null,"Cajun Seasoning","Condiments",22,30,660,67.320000000000007,"Laura Giussani"]
[1108,"2019-05-10","East",null,"Chocolate Biscuits Mix","Baked Goods & Mixes",9.1999999999999993,41,377.2,38.474400000000003,"Laura Giussani"]
[1121,"2019-05-25","East","Cash","Scones","Baked Goods & Mixes",10,66,660,68.64,"Laura Giussani"]
[1139,"2019-06-10","East",null,"Boysenberry Spread","Jams, Preserves",25,40,1000,105,"Laura Giussani"]
[1140,"2019-06-10","East",null,"Cajun Seasoning","Condiments",22,80,1760,172.48,"Laura Giussani"]
[1141,"2019-06-10","East",null,"Chocolate Biscuits Mix","Baked Goods & Mixes",9.1999999999999993,38,349.59999999999997,33.211999999999996,"Laura Giussani"]
[1154,"2019-06-25","East","Cash","Scones","Baked Goods & Mixes",10,49,490,47.04,"Laura Giussani"]
[1172,"2019-06-10","East","Credit Card","Almonds","Dried Fruit & Nuts",10,74,740,71.78,"Laura Giussani"]
[1174,"2019-06-10","East",null,"Dried Plums","Dried Fruit & Nuts",3.5,90,315,30.24,"Laura Giussani"]
[1181,"2019-06-25","East","Cash","Cajun Seasoning","Condiments",22,93,2046,200.50800000000001,"Laura Giussani"]
[1196,"2019-07-25","East","Cash","Scones","Baked Goods & Mixes",10,34,340,34.340000000000003,"Laura Giussani"]
[1214,"2019-07-10","East","Credit Card","Almonds","Dried Fruit & Nuts",10,80,800,77.599999999999994,"Laura Giussani"]
[1216,"2019-07-10","East",null,"Dried Plums","Dried Fruit & Nuts",3.5,27,94.5,9.072000000000001,"Laura Giussani"]
[1224,"2019-08-10","East","Credit Card","Green Tea","Beverages",2.99,23,68.77000000000001,6.6706900000000013,"Laura Giussani"]
[1226,"2019-08-10","East",null,"Boysenberry Spread","Jams, Preserves",25,47,1175,116.325,"Laura Giussani"]
[1227,"2019-08-10","East",null,"Cajun Seasoning","Condiments",22,97,2134,221.93600000000001,"Laura Giussani"]
[1228,"2019-08-10","East",null,"Chocolate Biscuits Mix","Baked Goods & Mixes",9.1999999999999993,96,883.19999999999993,86.553599999999989,"Laura Giussani"]
[1241,"2019-08-25","East","Cash","Scones","Baked Goods & Mixes",10,55,550,52.25,"Laura Giussani"]
[1250,"2019-09-10","East",null,"Chocolate Biscuits Mix","Baked Goods & Mixes",9.1999999999999993,83,763.59999999999991,74.832799999999992,"Laura Giussani"]
[1263,"2019-09-25","East","Cash","Scones","Baked Goods & Mixes",10,94,940,97.76,"Laura Giussani"]
[1281,"2019-09-10","East","Credit Card","Almonds","Dried Fruit & Nuts",10,59,590,59.59,"Laura Giussani"]
[1285,"2019-10-10","East","Credit Card","Green Tea","Beverages",2.99,32,95.68,9.7593600000000009,"Laura Giussani"]
[1287,"2019-10-10","East",null,"Boysenberry Spread","Jams, Preserves",25,60,1500,154.5,"Laura Giussani"]
[1288,"2019-10-10","East",null,"Cajun Seasoning","Condiments",22,51,1122,109.956,"Laura Giussani"]
[1289,"2019-10-10","East",null,"Chocolate Biscuits Mix","Baked Goods & Mixes",9.1999999999999993,49,450.79999999999995,44.629199999999997,"Laura Giussani"]
[1302,"2019-10-25","East","Cash","Scones","Baked Goods & Mixes",10,90,900,87.3,"Laura Giussani"]
[1320,"2019-10-10","East","Credit Card","Almonds","Dried Fruit & Nuts",10,12,120,12.36,"Laura Giussani"]
[1322,"2019-10-10","East",null,"Dried Plums","Dried Fruit & Nuts",3.5,78,273,27.3,"Laura Giussani"]
[1329,"2019-11-10","East",null,"Cajun Seasoning","Condiments",22,96,2112,221.76000000000002,"Laura Giussani"]
[1330,"2019-11-10","East",null,"Chocolate Biscuits Mix","Baked Goods & Mixes",9.1999999999999993,34,312.79999999999995,31.279999999999998,"Laura Giussani"]
[1343,"2019-11-25","East","Cash","Scones","Baked Goods & Mixes",10,99,990,102.96000000000001,"Laura Giussani"]
[1361,"2019-11-10","East","Credit Card","Almonds","Dried Fruit & Nuts",10,20,200,20,"Laura Giussani"]
[1363,"2019-11-10","East",null,"Dried Plums","Dried Fruit & Nuts",3.5,11,38.5,3.7345000000000002,"Laura Giussani"]
[1382,"2019-12-10","East","Credit Card","Green Tea","Beverages",2.99,41,122.59,12.871950000000002,"Laura Giussani"]
[1384,"2019-12-10","East",null,"Boysenberry Spread","Jams, Preserves",25,94,2350,235,"Laura Giussani"]
[1385,"2019-12-10","East",null,"Cajun Seasoning","Condiments",22,20,440,46.2,"Laura Giussani"]
[1386,"2019-12-10","East",null,"Chocolate Biscuits Mix","Baked Goods & Mixes",9.1999999999999993,13,119.6,12.438400000000001,"Laura Giussani"]
[1399,"2019-12-25","East","Cash","Scones","Baked Goods & Mixes",10,100,1000,98,"Laura Giussani"]
[1417,"2019-12-10","East","Credit Card","Almonds","Dried Fruit & Nuts",10,97,970,100.88000000000001,"Laura Giussani"]
[1419,"2019-12-10","East",null,"Dried Plums","Dried Fruit & Nuts",3.5,53,185.5,17.622499999999999,"Laura Giussani"]
[1426,"2019-12-25","East","Cash","Cajun Seasoning","Condiments",22,65,1430,138.71,"Laura Giussani"]

{"sheet":"John Smith","index":8,"n_rows":60,"n_cols":11,"rows_kept":60,"cut":false,"hidden":false,"merged":[]}
["Order Details for Laura Giussani"]
[]
["Order ID","Order Date","Region","Payment Type","Product Name","Category","Unit Price","Quantity","Revenue","Shipping Fee","Rep"]
[1015,"2019-01-10","East","Credit Card","Green Tea","Beverages",2.99,90,269.10000000000002,27.717300000000005,"John Smith"]
[1017,"2019-01-10","East",null,"Boysenberry Spread","Jams, Preserves",25,34,850,80.75,"John Smith"]
[1018,"2019-01-10","East",null,"Cajun Seasoning","Condiments",22,17,374,35.903999999999996,"John Smith"]
[1019,"2019-01-10","East",null,"Chocolate Biscuits Mix","Baked Goods & Mixes",9.1999999999999993,44,404.79999999999995,42.099199999999996,"John Smith"]
[1036,"2019-02-10","East","Credit Card","Almonds","Dried Fruit & Nuts",10,47,470,48.88,"John Smith"]
[1038,"2019-02-10","East",null,"Dried Plums","Dried Fruit & Nuts",3.5,49,171.5,16.464000000000002,"John Smith"]
[1045,"2019-02-25","East","Cash","Cajun Seasoning","Condiments",22,98,2156,204.82000000000002,"John Smith"]
[1057,"2019-03-25","East","Cash","Scones","Baked Goods & Mixes",10,46,460,46.46,"John Smith"]
[1075,"2019-03-10","East","Credit Card","Almonds","Dried Fruit & Nuts",10,55,550,55,"John Smith"]
[1077,"2019-03-10","East",null,"Dried Plums","Dried Fruit & Nuts",3.5,21,73.5,7.3500000000000005,"John Smith"]
[1091,"2019-04-10","East","Credit Card","Green Tea","Beverages",2.99,88,263.12,26.04888,"John Smith"]
[1093,"2019-04-10","East",null,"Boysenberry Spread","Jams, Preserves",25,27,675,68.849999999999994,"John Smith"]
[1094,"2019-04-10","East",null,"Cajun Seasoning","Condiments",22,37,814,85.470000000000013,"John Smith"]
[1095,"2019-04-10","East",null,"Chocolate Biscuits Mix","Baked Goods & Mixes",9.1999999999999993,75,690,69,"John Smith"]
[1104,"2019-05-10","East","Credit Card","Green Tea","Beverages",2.99,35,104.65,10.255700000000001,"John Smith"]
[1106,"2019-05-10","East",null,"Boysenberry Spread","Jams, Preserves",25,52,1300,123.5,"John Smith"]
[1107,"2019-05-10","East",null,"Cajun Seasoning","Condiments",22,30,660,67.320000000000007,"John Smith"]
[1108,"2019-05-10","East",null,"Chocolate Biscuits Mix","Baked Goods & Mixes",9.1999999999999993,41,377.2,38.474400000000003,"John Smith"]
[1121,"2019-05-25","East","Cash","Scones","Baked Goods & Mixes",10,66,660,68.64,"John Smith"]
[1139,"2019-06-10","East",null,"Boysenberry Spread","Jams, Preserves",25,40,1000,105,"John Smith"]
[1140,"2019-06-10","East",null,"Cajun Seasoning","Condiments",22,80,1760,172.48,"John Smith"]
[1141,"2019-06-10","East",null,"Chocolate Biscuits Mix","Baked Goods & Mixes",9.1999999999999993,38,349.59999999999997,33.211999999999996,"John Smith"]
[1154,"2019-06-25","East","Cash","Scones","Baked Goods & Mixes",10,49,490,47.04,"John Smith"]
[1172,"2019-06-10","East","Credit Card","Almonds","Dried Fruit & Nuts",10,74,740,71.78,"John Smith"]
[1174,"2019-06-10","East",null,"Dried Plums","Dried Fruit & Nuts",3.5,90,315,30.24,"John Smith"]
[1181,"2019-06-25","East","Cash","Cajun Seasoning","Condiments",22,93,2046,200.50800000000001,"John Smith"]
[1196,"2019-07-25","East","Cash","Scones","Baked Goods & Mixes",10,34,340,34.340000000000003,"John Smith"]
[1214,"2019-07-10","East","Credit Card","Almonds","Dried Fruit & Nuts",10,80,800,77.599999999999994,"John Smith"]
[1216,"2019-07-10","East",null,"Dried Plums","Dried Fruit & Nuts",3.5,27,94.5,9.072000000000001,"John Smith"]
[1224,"2019-08-10","East","Credit Card","Green Tea","Beverages",2.99,23,68.77000000000001,6.6706900000000013,"John Smith"]
[1226,"2019-08-10","East",null,"Boysenberry Spread","Jams, Preserves",25,47,1175,116.325,"John Smith"]
[1227,"2019-08-10","East",null,"Cajun Seasoning","Condiments",22,97,2134,221.93600000000001,"John Smith"]
[1228,"2019-08-10","East",null,"Chocolate Biscuits Mix","Baked Goods & Mixes",9.1999999999999993,96,883.19999999999993,86.553599999999989,"John Smith"]
[1241,"2019-08-25","East","Cash","Scones","Baked Goods & Mixes",10,55,550,52.25,"John Smith"]
[1250,"2019-09-10","East",null,"Chocolate Biscuits Mix","Baked Goods & Mixes",9.1999999999999993,83,763.59999999999991,74.832799999999992,"John Smith"]
[1263,"2019-09-25","East","Cash","Scones","Baked Goods & Mixes",10,94,940,97.76,"John Smith"]
[1281,"2019-09-10","East","Credit Card","Almonds","Dried Fruit & Nuts",10,59,590,59.59,"John Smith"]
[1285,"2019-10-10","East","Credit Card","Green Tea","Beverages",2.99,32,95.68,9.7593600000000009,"John Smith"]
[1287,"2019-10-10","East",null,"Boysenberry Spread","Jams, Preserves",25,60,1500,154.5,"John Smith"]
[1288,"2019-10-10","East",null,"Cajun Seasoning","Condiments",22,51,1122,109.956,"John Smith"]
[1289,"2019-10-10","East",null,"Chocolate Biscuits Mix","Baked Goods & Mixes",9.1999999999999993,49,450.79999999999995,44.629199999999997,"John Smith"]
[1302,"2019-10-25","East","Cash","Scones","Baked Goods & Mixes",10,90,900,87.3,"John Smith"]
[1320,"2019-10-10","East","Credit Card","Almonds","Dried Fruit & Nuts",10,12,120,12.36,"John Smith"]
[1322,"2019-10-10","East",null,"Dried Plums","Dried Fruit & Nuts",3.5,78,273,27.3,"John Smith"]
[1329,"2019-11-10","East",null,"Cajun Seasoning","Condiments",22,96,2112,221.76000000000002,"John Smith"]
[1330,"2019-11-10","East",null,"Chocolate Biscuits Mix","Baked Goods & Mixes",9.1999999999999993,34,312.79999999999995,31.279999999999998,"John Smith"]
[1343,"2019-11-25","East","Cash","Scones","Baked Goods & Mixes",10,99,990,102.96000000000001,"John Smith"]
[1361,"2019-11-10","East","Credit Card","Almonds","Dried Fruit & Nuts",10,20,200,20,"John Smith"]
[1363,"2019-11-10","East",null,"Dried Plums","Dried Fruit & Nuts",3.5,11,38.5,3.7345000000000002,"John Smith"]
[1382,"2019-12-10","East","Credit Card","Green Tea","Beverages",2.99,41,122.59,12.871950000000002,"John Smith"]
[1384,"2019-12-10","East",null,"Boysenberry Spread","Jams, Preserves",25,94,2350,235,"John Smith"]
[1385,"2019-12-10","East",null,"Cajun Seasoning","Condiments",22,20,440,46.2,"John Smith"]
[1386,"2019-12-10","East",null,"Chocolate Biscuits Mix","Baked Goods & Mixes",9.1999999999999993,13,119.6,12.438400000000001,"John Smith"]
[1399,"2019-12-25","East","Cash","Scones","Baked Goods & Mixes",10,100,1000,98,"John Smith"]
[1417,"2019-12-10","East","Credit Card","Almonds","Dried Fruit & Nuts",10,97,970,100.88000000000001,"John Smith"]
[1419,"2019-12-10","East",null,"Dried Plums","Dried Fruit & Nuts",3.5,53,185.5,17.622499999999999,"John Smith"]
[1426,"2019-12-25","East","Cash","Cajun Seasoning","Condiments",22,65,1430,138.71,"John Smith"]

{"sheet":"Robert Zare","index":9,"n_rows":29,"n_cols":11,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
["Order Details for Robert Zare"]
[]
["Order ID","Order Date","Region","Payment Type","Product Name","Category","Unit Price","Quantity","Revenue","Shipping Fee","Rep"]
[1027,"2019-01-09","West","Check","Ravioli","Pasta",19.5,57,1111.5,110.0385,"Robert Zare"]
[1028,"2019-01-09","West","Check","Mozzarella","Dairy Products",34.799999999999997,81,2818.7999999999997,295.97399999999999,"Robert Zare"]
[1042,"2019-02-09","West","Check","Clam Chowder","Soups",9.65,27,260.55,24.752250000000004,"Robert Zare"]
[1052,"2019-03-09","West","Check","Ravioli","Pasta",19.5,55,1072.5,108.32250000000001,"Robert Zare"]
[1053,"2019-03-09","West","Check","Mozzarella","Dairy Products",34.799999999999997,11,382.79999999999995,36.748799999999996,"Robert Zare"]
[1116,"2019-05-09","West","Check","Ravioli","Pasta",19.5,82,1599,153.50399999999999,"Robert Zare"]
[1117,"2019-05-09","West","Check","Mozzarella","Dairy Products",34.799999999999997,37,1287.5999999999999,132.62279999999998,"Robert Zare"]
[1149,"2019-06-09","West","Check","Ravioli","Pasta",19.5,27,526.5,51.070500000000003,"Robert Zare"]
[1150,"2019-06-09","West","Check","Mozzarella","Dairy Products",34.799999999999997,88,3062.3999999999996,303.17759999999993,"Robert Zare"]
[1178,"2019-06-09","West","Check","Clam Chowder","Soups",9.65,76,733.4,72.6066,"Robert Zare"]
[1191,"2019-07-09","West","Check","Ravioli","Pasta",19.5,61,1189.5,123.70800000000001,"Robert Zare"]
[1192,"2019-07-09","West","Check","Mozzarella","Dairy Products",34.799999999999997,27,939.59999999999991,95.839199999999991,"Robert Zare"]
[1220,"2019-07-09","West","Check","Clam Chowder","Soups",9.65,90,868.5,83.376000000000005,"Robert Zare"]
[1236,"2019-08-09","West","Check","Ravioli","Pasta",19.5,66,1287,132.56100000000001,"Robert Zare"]
[1237,"2019-08-09","West","Check","Mozzarella","Dairy Products",34.799999999999997,32,1113.5999999999999,111.36,"Robert Zare"]
[1258,"2019-09-09","West","Check","Ravioli","Pasta",19.5,48,936,94.536000000000016,"Robert Zare"]
[1259,"2019-09-09","West","Check","Mozzarella","Dairy Products",34.799999999999997,57,1983.6,194.39280000000002,"Robert Zare"]
[1297,"2019-10-09","West","Check","Ravioli","Pasta",19.5,64,1248,119.80800000000001,"Robert Zare"]
[1298,"2019-10-09","West","Check","Mozzarella","Dairy Products",34.799999999999997,70,2436,246.03600000000003,"Robert Zare"]
[1326,"2019-10-09","West","Check","Clam Chowder","Soups",9.65,89,858.85,86.743850000000009,"Robert Zare"]
[1338,"2019-11-09","West","Check","Ravioli","Pasta",19.5,87,1696.5,174.73950000000002,"Robert Zare"]
[1339,"2019-11-09","West","Check","Mozzarella","Dairy Products",34.799999999999997,58,2018.3999999999999,205.8768,"Robert Zare"]
[1367,"2019-11-09","West","Check","Clam Chowder","Soups",9.65,14,135.1,12.9696,"Robert Zare"]
[1394,"2019-12-09","West","Check","Ravioli","Pasta",19.5,20,390,40.950000000000003,"Robert Zare"]
[1395,"2019-12-09","West","Check","Mozzarella","Dairy Products",34.799999999999997,69,2401.1999999999998,240.12,"Robert Zare"]
[1423,"2019-12-09","West","Check","Clam Chowder","Soups",9.65,18,173.70000000000002,16.5015,"Robert Zare"]

{"sheet":"talal","index":10,"n_rows":29,"n_cols":11,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
["Order Details for Robert Zare"]
[]
["Order ID","Order Date","Region","Payment Type","Product Name","Category","Unit Price","Quantity","Revenue","Shipping Fee","Rep"]
[1027,"2019-01-09","West","Check","Ravioli","Pasta",19.5,57,1111.5,110.0385,"talal"]
[1028,"2019-01-09","West","Check","Mozzarella","Dairy Products",34.799999999999997,81,2818.7999999999997,295.97399999999999,"talal"]
[1042,"2019-02-09","West","Check","Clam Chowder","Soups",9.65,27,260.55,24.752250000000004,"talal"]
[1052,"2019-03-09","West","Check","Ravioli","Pasta",19.5,55,1072.5,108.32250000000001,"talal"]
[1053,"2019-03-09","West","Check","Mozzarella","Dairy Products",34.799999999999997,11,382.79999999999995,36.748799999999996,"talal"]
[1116,"2019-05-09","West","Check","Ravioli","Pasta",19.5,82,1599,153.50399999999999,"talal"]
[1117,"2019-05-09","West","Check","Mozzarella","Dairy Products",34.799999999999997,37,1287.5999999999999,132.62279999999998,"talal"]
[1149,"2019-06-09","West","Check","Ravioli","Pasta",19.5,27,526.5,51.070500000000003,"talal"]
[1150,"2019-06-09","West","Check","Mozzarella","Dairy Products",34.799999999999997,88,3062.3999999999996,303.17759999999993,"talal"]
[1178,"2019-06-09","West","Check","Clam Chowder","Soups",9.65,76,733.4,72.6066,"talal"]
[1191,"2019-07-09","West","Check","Ravioli","Pasta",19.5,61,1189.5,123.70800000000001,"talal"]
[1192,"2019-07-09","West","Check","Mozzarella","Dairy Products",34.799999999999997,27,939.59999999999991,95.839199999999991,"talal"]
[1220,"2019-07-09","West","Check","Clam Chowder","Soups",9.65,90,868.5,83.376000000000005,"talal"]
[1236,"2019-08-09","West","Check","Ravioli","Pasta",19.5,66,1287,132.56100000000001,"talal"]
[1237,"2019-08-09","West","Check","Mozzarella","Dairy Products",34.799999999999997,32,1113.5999999999999,111.36,"talal"]
[1258,"2019-09-09","West","Check","Ravioli","Pasta",19.5,48,936,94.536000000000016,"talal"]
[1259,"2019-09-09","West","Check","Mozzarella","Dairy Products",34.799999999999997,57,1983.6,194.39280000000002,"talal"]
[1297,"2019-10-09","West","Check","Ravioli","Pasta",19.5,64,1248,119.80800000000001,"talal"]
[1298,"2019-10-09","West","Check","Mozzarella","Dairy Products",34.799999999999997,70,2436,246.03600000000003,"talal"]
[1326,"2019-10-09","West","Check","Clam Chowder","Soups",9.65,89,858.85,86.743850000000009,"talal"]
[1338,"2019-11-09","West","Check","Ravioli","Pasta",19.5,87,1696.5,174.73950000000002,"talal"]
[1339,"2019-11-09","West","Check","Mozzarella","Dairy Products",34.799999999999997,58,2018.3999999999999,205.8768,"talal"]
[1367,"2019-11-09","West","Check","Clam Chowder","Soups",9.65,14,135.1,12.9696,"talal"]
[1394,"2019-12-09","West","Check","Ravioli","Pasta",19.5,20,390,40.950000000000003,"talal"]
[1395,"2019-12-09","West","Check","Mozzarella","Dairy Products",34.799999999999997,69,2401.1999999999998,240.12,"talal"]
[1423,"2019-12-09","West","Check","Clam Chowder","Soups",9.65,18,173.70000000000002,16.5015,"talal"]

{"sheet":"mhsen","index":11,"n_rows":29,"n_cols":11,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
["Order Details for Robert Zare"]
[]
["Order ID","Order Date","Region","Payment Type","Product Name","Category","Unit Price","Quantity","Revenue","Shipping Fee","Rep"]
[1027,"2019-01-09","West","Check","Ravioli","Pasta",19.5,57,1111.5,110.0385,"mhsen"]
[1028,"2019-01-09","West","Check","Mozzarella","Dairy Products",34.799999999999997,81,2818.7999999999997,295.97399999999999,"mhsen"]
[1042,"2019-02-09","West","Check","Clam Chowder","Soups",9.65,27,260.55,24.752250000000004,"mhsen"]
[1052,"2019-03-09","West","Check","Ravioli","Pasta",19.5,55,1072.5,108.32250000000001,"mhsen"]
[1053,"2019-03-09","West","Check","Mozzarella","Dairy Products",34.799999999999997,11,382.79999999999995,36.748799999999996,"mhsen"]
[1116,"2019-05-09","West","Check","Ravioli","Pasta",19.5,82,1599,153.50399999999999,"mhsen"]
[1117,"2019-05-09","West","Check","Mozzarella","Dairy Products",34.799999999999997,37,1287.5999999999999,132.62279999999998,"mhsen"]
[1149,"2019-06-09","West","Check","Ravioli","Pasta",19.5,27,526.5,51.070500000000003,"mhsen"]
[1150,"2019-06-09","West","Check","Mozzarella","Dairy Products",34.799999999999997,88,3062.3999999999996,303.17759999999993,"mhsen"]
[1178,"2019-06-09","West","Check","Clam Chowder","Soups",9.65,76,733.4,72.6066,"mhsen"]
[1191,"2019-07-09","West","Check","Ravioli","Pasta",19.5,61,1189.5,123.70800000000001,"mhsen"]
[1192,"2019-07-09","West","Check","Mozzarella","Dairy Products",34.799999999999997,27,939.59999999999991,95.839199999999991,"mhsen"]
[1220,"2019-07-09","West","Check","Clam Chowder","Soups",9.65,90,868.5,83.376000000000005,"mhsen"]
[1236,"2019-08-09","West","Check","Ravioli","Pasta",19.5,66,1287,132.56100000000001,"mhsen"]
[1237,"2019-08-09","West","Check","Mozzarella","Dairy Products",34.799999999999997,32,1113.5999999999999,111.36,"mhsen"]
[1258,"2019-09-09","West","Check","Ravioli","Pasta",19.5,48,936,94.536000000000016,"mhsen"]
[1259,"2019-09-09","West","Check","Mozzarella","Dairy Products",34.799999999999997,57,1983.6,194.39280000000002,"mhsen"]
[1297,"2019-10-09","West","Check","Ravioli","Pasta",19.5,64,1248,119.80800000000001,"mhsen"]
[1298,"2019-10-09","West","Check","Mozzarella","Dairy Products",34.799999999999997,70,2436,246.03600000000003,"mhsen"]
[1326,"2019-10-09","West","Check","Clam Chowder","Soups",9.65,89,858.85,86.743850000000009,"mhsen"]
[1338,"2019-11-09","West","Check","Ravioli","Pasta",19.5,87,1696.5,174.73950000000002,"mhsen"]
[1339,"2019-11-09","West","Check","Mozzarella","Dairy Products",34.799999999999997,58,2018.3999999999999,205.8768,"mhsen"]
[1367,"2019-11-09","West","Check","Clam Chowder","Soups",9.65,14,135.1,12.9696,"mhsen"]
[1394,"2019-12-09","West","Check","Ravioli","Pasta",19.5,20,390,40.950000000000003,"mhsen"]
[1395,"2019-12-09","West","Check","Mozzarella","Dairy Products",34.799999999999997,69,2401.1999999999998,240.12,"mhsen"]
[1423,"2019-12-09","West","Check","Clam Chowder","Soups",9.65,18,173.70000000000002,16.5015,"mhsen"]