Spreadsheet: 873434d1719932941-weighting-different-filters-construction-test-v2
Sheet: Data

Date | Shop | Produce | Category | Percentage of product | Weighted %
2024-06-01 00:00:00 | Asda | [NAME] | Fruit | 0.04612011081934639
2024-06-01 00:00:00 | Asda | Pear | Fruit | 0.1197856291533211
2024-06-01 00:00:00 | Asda | Plum | Fruit | 0.09824048919533705
2024-06-01 00:00:00 | Asda | Salad | Vegetable | 0.1079904652978737
2024-06-01 00:00:00 | Asda | Spaghetti | Carbs | 0.09025744057615466
2024-06-01 00:00:00 | Asda | Tea | Drink | 0.03641455852598764
2024-06-01 00:00:00 | Asda | Bread | Carbs | 0.03673879806928632
2024-06-01 00:00:00 | Asda | Milk | Dairy | 0.08525437798090461
2024-06-01 00:00:00 | Asda | Coffee | Drink | 0.1714014053531208
2024-06-01 00:00:00 | Asda | Chicken | Meat | 0.1559028251725089
2024-06-01 00:00:00 | Asda | Steak | Meat | 0.05189389985615864
2024-03-01 00:00:00 | Asda | [NAME] | Fruit | 0.1419016030104553
2024-03-01 00:00:00 | Asda | Pear | Fruit | 0.1239257352865187
2024-03-01 00:00:00 | Asda | Plum | Fruit | 0.04975979316166113
2024-03-01 00:00:00 | Asda | Salad | Vegetable | 0.03830879376652747
2024-03-01 00:00:00 | Asda | Spaghetti | Carbs | 0.01615642775208847
2024-03-01 00:00:00 | Asda | Tea | Drink | 0.1191239213097002
2024-03-01 00:00:00 | Asda | Bread | Carbs | 0.1256778542332655
2024-03-01 00:00:00 | Asda | Milk | Dairy | 0.007072956951361123
2024-03-01 00:00:00 | Asda | Beef | Meat | 0.0554547646941292
2024-03-01 00:00:00 | Asda | Chicken | Meat | 0.091341300182554
2024-03-01 00:00:00 | Asda | Steak | Meat | 0.02050060981077584
2024-03-01 00:00:00 | Asda | Cola | Drink | 0.1294169067675243
2024-03-01 00:00:00 | Asda | Coffee | Drink | 0.002463011252002904
2024-03-01 00:00:00 | Asda | Onions | Vegetable | 0.07889632182143559
2024-12-01 00:00:00 | Asda | [NAME] | Fruit | 0.07960682844573341
2024-12-01 00:00:00 | Asda | Pear | Fruit | 0.1367769119972624
2024-12-01 00:00:00 | Asda | Raisins | Fruit | 0.04177780169734446
2024-12-01 00:00:00 | Asda | Salad | Vegetable | 0.11179626741578
2024-12-01 00:00:00 | Asda | Spaghetti | Carbs | 0.0653338747202897
2024-12-01 00:00:00 | Asda | Milk | Dairy | 0.1192402358377256
2024-12-01 00:00:00 | Asda | Beef | Meat | 0.1204887961895204
2024-12-01 00:00:00 | Asda | Chicken | Meat | 0.02691840594225245
2024-12-01 00:00:00 | Asda | Steak | Meat | 0.01620563040703672
2024-12-01 00:00:00 | Asda | Cola | Drink | 0.02408665055057532
2024-12-01 00:00:00 | Asda | Coffee | Drink | 0.02983983138173319
2024-12-01 00:00:00 | Asda | Onions | Vegetable | 0.1281600493972724
2024-12-01 00:00:00 | Asda | Beans | Vegetable | 0.09976871601747389
2024-06-01 00:00:00 | M&S | Bread | Carbs | 0.2203463341506864
2024-06-01 00:00:00 | M&S | Milk | Dairy | 0.07100676871077059
2024-06-01 00:00:00 | M&S | [NAME] | Vegetable | 0.1907263874711826
2024-06-01 00:00:00 | M&S | [NAME] | Condiment | 0.1792531610646791
2024-06-01 00:00:00 | M&S | Bacon | Meat | 0.01149190011262901
2024-06-01 00:00:00 | M&S | Tomatoes | Vegetable | 0.12667230758595
2024-06-01 00:00:00 | M&S | Peas | Vegetable | 0.07182162916546177
2024-06-01 00:00:00 | M&S | Strawberries | Fruit | 0.1286815117386406
2024-03-01 00:00:00 | M&S | Bread | Carbs | 0.08139242359887154
2024-03-01 00:00:00 | M&S | Milk | Dairy | 0.01305193198915156
2024-03-01 00:00:00 | M&S | [NAME] | Vegetable | 0.1193053194205795
2024-03-01 00:00:00 | M&S | [NAME] | Condiment | 0.1486197461472263
2024-03-01 00:00:00 | M&S | Carrots | Vegetable | 0.109581917023795
2024-03-01 00:00:00 | M&S | Tomatoes | Vegetable | 0.04730676573385792
2024-03-01 00:00:00 | M&S | Peas | Vegetable | 0.05130785252064799
2024-03-01 00:00:00 | M&S | Strawberries | Vegetable | 0.1064812198270964
2024-03-01 00:00:00 | M&S | Tuna | Fish | 0.1082149152328731
2024-03-01 00:00:00 | M&S | Salmon | Fish | 0.1443697412249129
2024-03-01 00:00:00 | M&S | Yoghurt | Dairy | 0.07036816728098762
2024-12-01 00:00:00 | M&S | Bread | Carbs | 0.06401272769630734
2024-12-01 00:00:00 | M&S | Milk | Dairy | 0.1284742290805651
2024-12-01 00:00:00 | M&S | Eggs | Other | 0.1389780008827274
2024-12-01 00:00:00 | M&S | Juice | Drink | 0.09874913480970822
2024-12-01 00:00:00 | M&S | Carrots | Vegetable | 0.03426966815253651
2024-12-01 00:00:00 | M&S | Tomatoes | Vegetable | 0.06885895946405118
2024-12-01 00:00:00 | M&S | Peas | Vegetable | 0.03080541512309803
2024-12-01 00:00:00 | M&S | Strawberries | Fruit | 0.08401394100852476
2024-12-01 00:00:00 | M&S | Tuna | Fish | 0.1432937672961147
2024-12-01 00:00:00 | M&S | Salmon | Fish | 0.04571898133841967
2024-12-01 00:00:00 | M&S | Yoghurt | Dairy | 0.01178259480085817
2024-12-01 00:00:00 | M&S | Prawns | Fish | 0.04600504571791464
2024-12-01 00:00:00 | M&S | Grapes | Fruit | 0.1050375346291742
2024-06-01 00:00:00 | Tesco | Bread | Carbs | 0.03007726130255337
2024-06-01 00:00:00 | Tesco | Milk | Dairy | 0.03047353174303532
2024-06-01 00:00:00 | Tesco | Tea | Drink | 0.1782492142841241
2024-06-01 00:00:00 | Tesco | [NAME] | Condiment | 0.06206501303216789
2024-06-01 00:00:00 | Tesco | Coffee | Drink | 0.1967361935844199
2024-06-01 00:00:00 | Tesco | Tomatoes | Vegetable | 0.1630694970006236
2024-06-01 00:00:00 | Tesco | Peas | Vegetable | 0.1508163951069908
2024-06-01 00:00:00 | Tesco | Biscuits | Carbs | 0.188512893946085
2024-03-01 00:00:00 | Tesco | Bread | Carbs | 0.07522749913079488
2024-03-01 00:00:00 | Tesco | Milk | Dairy | 0.08030562160998218
2024-03-01 00:00:00 | Tesco | Onions | Vegetable | 0.05503557666134448
2024-03-01 00:00:00 | Tesco | [NAME] | Condiment | 0.01314235243193456
2024-03-01 00:00:00 | Tesco | Beans | Vegetable | 0.03756730176305682
2024-03-01 00:00:00 | Tesco | Tomatoes | Vegetable | 0.1279059573682955
2024-03-01 00:00:00 | Tesco | Peas | Vegetable | 0.06214077910438678
2024-03-01 00:00:00 | Tesco | Chocolate | Other | 0.1340190813642667
2024-03-01 00:00:00 | Tesco | Tuna | fish | 0.155768216220604
2024-03-01 00:00:00 | Tesco | Mellon | Vegetable | 0.1394815805535941
2024-03-01 00:00:00 | Tesco | Yoghurt | Dairy | 0.1194060337917401
2024-12-01 00:00:00 | Tesco | Sugar | Other | 0.04393851166694678
2024-12-01 00:00:00 | Tesco | Milk | Dairy | 0.03099517177095139
2024-12-01 00:00:00 | Tesco | Eggs | Other | 0.04633974028455593
2024-12-01 00:00:00 | Tesco | Juice | Drink | 0.033406069858169
2024-12-01 00:00:00 | Tesco | Carrots | Vegetable | 0.101275933957177
2024-12-01 00:00:00 | Tesco | Tomatoes | Vegetable | 0.0722109956239654
2024-12-01 00:00:00 | Tesco | Peas | Vegetable | 0.04344079618585977
2024-12-01 00:00:00 | Tesco | Strawberries | Fruit | 0.1376888927192313
2024-12-01 00:00:00 | Tesco | Tuna | Fish | 0.07592808682633201
2024-12-01 00:00:00 | Tesco | Apricots | Fruit | 0.1525455337730135
2024-12-01 00:00:00 | Tesco | Donuts | Other | 0.1014487717373795
2024-12-01 00:00:00 | Tesco | Peanuts | Other | 0.1399449898849946
2024-12-01 00:00:00 | Tesco | Grapes | Fruit | 0.02083650571142383