Skip to content

Instantly share code, notes, and snippets.

@nicksellen
Last active November 13, 2024 10:45
Show Gist options
  • Save nicksellen/cb939faab408e6f3e48e59f3780dbc62 to your computer and use it in GitHub Desktop.
Save nicksellen/cb939faab408e6f3e48e59f3780dbc62 to your computer and use it in GitHub Desktop.
karrot weight saved
# ran on 2022-02-15
# weights in kg
PER GROUP
54 Foodfighters 114.0
2019 1.0
2021 113.0
148 RoBIN FooDS 8702.8
2021 8112.6
2022 590.2
136 DLC Vendée ( littoral nord vendéen) 81911.643
2021 74647.543
2022 7264.1
233 Team Manfred 1945.0
2021 1520.0
2022 425.0
240 Solidarecup Cornouaille 20.0
2021 20.0
329 Wir retten Essen 1904.0
2021 1232.0
2022 672.0
76 Food Saving Leuven 1830.7
2019 477.0
2020 427.7
2021 835.0
2022 91.0
53 Gemüse-Netzwerk e.V. 370.0
2019 286.0
2020 3.5
103 Fællesskabet KBH - Free Fridge Copenhagen 999.5
2020 7.5
2021 984.0
2022 8.0
37 Foodsharing i Östersund 8779.0
2019 2886.0
2020 2418.5
2021 2763.5
2022 234.0
218 Berria Foodsharing Bilbao 1337.4
2021 943.7
2022 393.7
145 Foodsharing Copenhagen (Bread collection) 282.0
2021 182.0
2022 100.0
75 Foodsharing Stockholm 16699.425
2020 4833.5
2021 10878.925
2022 987.0
78 Arnhem Foodsharing 52.5
2021 52.5
104 DLC Bocage Vendéen 231362.8594
2020 3925.63
2021 198399.2294
2022 29038.0
29 Essen für Alle (EfA) 442808.616666666
2019 61848.0
2020 140038.5
2021 189856.3
2022 23952.0
86 DLC LSDO 204269.892
2020 49271.445
2021 134595.447
2022 20403.0
351 DLC Monts Marais Vie 2605.5
2021 468.3
2022 2137.2
32 Food Saving Lund 1985.53333333333
2019 679.833333333333
2020 546.0
2021 723.5
2022 12.2
38 Foodsharing Maastricht 72.4
2019 20.9
2020 1.0
2021 15.5
317 Foodsharing Västerås 2.0
2022 2.0
10 Solikyl Göteborg 81892.0666666667
2019 15111.6666666667
2020 15136.0
2021 41364.0
2022 6734.9
39 Foodsharing Warszawa 209323.4525
2019 47807.4123
2020 38440.8677
2021 90766.732
2022 18251.3
33 Foodsaving by Foodsharing Luxembourg 257766.887
2019 135.0
2020 10538.5
2021 223281.487
2022 23811.9
65 Association DLC La Rochelle 9461.0
2019 1924.5
2020 3240.5
2021 3784.0
2022 512.0
TOTALS
2019 132939.6623
2020 271041.6427
2021 985973.763399999
2022 135628.5
PER GROUP
54 Foodfighters 114.0
2019 1.0
2021 113.0
104 DLC Bocage Vendéen 366105.7594
2020 3925.63
2021 198399.2294
2022 163780.9
136 DLC Vendée ( littoral nord vendéen) 106981.643
2021 74647.543
2022 32334.1
240 Solidarecup Cornouaille 20.0
2021 20.0
37 Foodsharing i Östersund 10148.5
2018 477.0
2019 2886.0
2020 2418.5
2021 2763.5
2022 1603.5
329 Wir retten Essen 7685.0
2021 1232.0
2022 6453.0
218 Berria Foodsharing Bilbao 3109.4
2021 943.7
2022 2165.7
461 Foodsavers West 558.0
2022 558.0
145 Foodsharing Copenhagen (Bread collection) 587.0
2021 182.0
2022 405.0
29 Essen für Alle (EfA) 560125.316666666
2018 27113.8166666667
2019 61848.0
2020 140038.5
2021 189856.3
2022 141268.7
388 -IgeL- 3.5
2022 3.5
86 DLC LSDO 311365.992
2020 49271.445
2021 134595.447
2022 127499.1
351 DLC Monts Marais Vie 34668.8
2021 468.3
2022 34200.5
317 Foodsharing Västerås 103.0
2022 103.0
76 Food Saving Leuven 2447.3
2019 477.0
2020 427.7
2021 835.0
2022 707.6
39 Foodsharing Warszawa 318532.2525
2018 14057.1405
2019 47807.4123
2020 38440.8677
2021 90766.732
2022 127460.1
53 Gemüse-Netzwerk e.V. 370.0
2018 80.5
2019 286.0
2020 3.5
148 RoBIN FooDS 17892.4
2021 8112.6
2022 9779.8
233 Team Manfred 3575.0
2021 1520.0
2022 2055.0
78 Arnhem Foodsharing 69.5
2021 52.5
2022 17.0
75 Foodsharing Stockholm 19974.425
2020 4833.5
2021 10878.925
2022 4262.0
32 Food Saving Lund 2519.73333333333
2018 24.0
2019 679.833333333333
2020 546.0
2021 723.5
2022 546.4
65 Association DLC La Rochelle 10743.4
2019 1924.5
2020 3240.5
2021 3784.0
2022 1794.4
479 TestGroup 120.0
2022 120.0
10 Solikyl Göteborg 110818.566666667
2018 3533.5
2019 15111.6666666667
2020 15136.0
2021 41364.0
2022 35661.4
33 Foodsaving by Foodsharing Luxembourg 421408.387
2019 135.0
2020 10538.5
2021 223281.487
2022 187453.4
103 Fællesskabet KBH - Free Fridge Copenhagen 1186.7
2020 7.5
2021 984.0
2022 195.2
TOTALS
2018 46424.9571666667
2019 132939.6623
2020 271041.6427
2021 985973.763399999
2022 880436.800000005
PER GROUP
10 Solikyl Göteborg 143606.766666667
2018 3533.5
2019 15111.6666666667
2020 15136.0
2021 41364.0
2022 53551.4
2023 14898.2
240 Solidarecup Cornouaille 20.0
2021 20.0
329 Wir retten Essen 11155.0
2021 1232.0
2022 8808.0
2023 1115.0
136 DLC Vendée ( littoral nord vendéen) 126215.043
2021 74647.543
2022 42560.7
2023 9006.8
60 Foodsharing Borås 57.5
2020 57.5
218 Berria Foodsharing Bilbao 4982.4
2021 943.7
2022 3187.7
2023 851.0
145 Foodsharing Copenhagen (Bread collection) 1736.0
2021 182.0
2022 1133.0
2023 421.0
452 stop gâchis 105.0
2023 105.0
461 Foodsavers West 618.0
2022 618.0
75 Foodsharing Stockholm 19981.425
2020 4833.5
2021 10878.925
2022 4269.0
104 DLC Bocage Vendéen 477813.6594
2020 3925.63
2021 198399.2294
2022 223685.0
2023 51803.8
495 Solikyl Handels 2028.2
2022 998.0
2023 1030.2
351 DLC Monts Marais Vie 62166.6
2021 468.3
2022 49067.0
2023 12631.3
86 DLC LSDO 386298.792
2020 49271.445
2021 134595.447
2022 169621.1
2023 32810.8
78 Arnhem Foodsharing 91.5
2021 52.5
2022 26.0
2023 13.0
479 Lebensmittelretten & mehr Fürth 4659.0
2022 1921.0
2023 2738.0
53 Gemüse-Netzwerk e.V. 370.0
2018 80.5
2019 286.0
2020 3.5
233 Team Manfred 5205.0
2021 1520.0
2022 3010.0
2023 675.0
515 Recup Roma 336.3
2023 336.3
65 Association DLC La Rochelle 12289.4
2019 1924.5
2020 3240.5
2021 3784.0
2022 2605.4
2023 735.0
528 Foodie 1.9
2023 1.9
148 RoBIN FooDS 22411.7
2021 8112.6
2022 12203.3
2023 2095.8
103 Fællesskabet KBH - Free Fridge Copenhagen 1709.7
2020 7.5
2021 984.0
2022 390.2
2023 328.0
39 Foodsharing Warszawa 406006.2525
2018 14057.1405
2019 47807.4123
2020 38440.8677
2021 90766.732
2022 172330.0
2023 42604.1
527 Pick Food Asbl Dahlem 7528.1
2023 7528.1
37 Foodsharing i Östersund 10261.0
2018 477.0
2019 2886.0
2020 2418.5
2021 2763.5
2022 1679.0
2023 37.0
33 Foodsaving by Foodsharing Luxembourg 559848.686999999
2019 135.0
2020 10538.5
2021 223281.487
2022 255882.6
2023 70011.1
29 Essen für Alle (EfA) 651196.316666666
2018 27113.8166666667
2019 61848.0
2020 140038.5
2021 189856.3
2022 190605.0
2023 41734.7
76 Food Saving Leuven 4115.9
2019 477.0
2020 427.7
2021 835.0
2022 1673.5
2023 702.7
32 Food Saving Lund 3754.43333333333
2018 24.0
2019 679.833333333333
2020 546.0
2021 723.5
2022 1327.9
2023 453.2
TOTALS
2018 46424.9571666667
2019 132939.6623
2020 271041.6427
2021 985973.763399999
2022 1201268.8
2023 294682.0
PER GROUP
240 Solidarecup Cornouaille 20.0
2021 20.0
136 DLC Vendée ( littoral nord vendéen) 139375.64299999998
2021 74647.54299999999
2022 42560.69999999999
2023 22167.40000000001
218 Berria Foodsharing Bilbao 5782.9
2021 943.7
2022 3187.7
2023 1651.5
461 Foodsavers West 618.0
2022 618.0
145 Foodsharing Copenhagen (Bread collection) 2261.0
2021 182.0
2022 1133.0
2023 946.0
351 DLC Monts Marais Vie 76517.20000000003
2021 468.29999999999995
2022 49066.99999999999
2023 26981.89999999998
233 Team Manfred 5465.0
2021 1520.0
2022 3010.0
2023 935.0
53 Gemüse-Netzwerk e.V. 370.0
2018 80.5
2019 286.0
2020 3.5
37 Foodsharing i Östersund 10293.0
2018 477.0
2019 2886.0
2020 2418.5
2021 2763.5
2022 1679.0
2023 69.0
527 Pick Food Asbl Dahlem 43165.5
2023 43165.49999999999
10 Solikyl Göteborg 159507.46666666667
2018 3533.5
2019 15111.666666666668
2020 15136.0
2021 41364.0
2022 53551.399999999994
2023 30798.9
39 Foodsharing Warszawa 453772.15249999997
2018 14057.1405
2019 47807.41230000002
2020 38440.8677
2021 90766.73200000002
2022 172330.00000000006
2023 90370.00000000003
86 DLC LSDO 431768.9919999999
2020 49271.44500000001
2021 134595.44699999996
2022 169621.1
2023 78281.0
329 Wir retten Essen 11780.0
2021 1232.0
2022 8808.0
2023 1740.0
103 Fællesskabet KBH - Free Fridge Copenhagen 2014.6999999999998
2020 7.5
2021 984.0
2022 390.20000000000005
2023 633.0
479 Lebensmittelretten & mehr Fürth 6917.0
2022 1921.0
2023 4996.0
65 Association DLC La Rochelle 12984.4
2019 1924.5
2020 3240.5
2021 3784.0
2022 2605.4
2023 1430.0
104 DLC Bocage Vendéen 546774.7593999995
2020 3925.6299999999997
2021 198399.22940000007
2022 223685.0
2023 120764.9
75 Foodsharing Stockholm 19981.425
2020 4833.5
2021 10878.925
2022 4269.0
32 Food Saving Lund 4058.4333333333334
2018 24.0
2019 679.8333333333333
2020 546.0
2021 723.5
2022 1327.9
2023 757.2
33 Foodsaving by Foodsharing Luxembourg 635541.086999999
2019 135.0
2020 10538.5
2021 223281.48700000002
2022 255882.6000000001
2023 145703.5000000001
515 Recup Roma 336.29999999999995
2023 336.29999999999995
76 Food Saving Leuven 4798.700000000001
2019 477.0
2020 427.7
2021 835.0
2022 1673.5
2023 1385.5
452 stop gâchis 530.0
2023 530.0
555 Stowarzyszenie 539.0
2023 539.0
148 RoBIN FooDS 25397.2
2021 8112.6
2022 12203.3
2023 5081.3
29 Essen für Alle (EfA) 702802.3166666663
2018 27113.816666666662
2019 61848.0
2020 140038.5
2021 189856.3
2022 190605.0
2023 93340.70000000001
TOTALS
2018 46424.95716666665
2019 132939.66229999997
2020 271041.64269999997
2021 985973.7633999994
2022 1201268.8000000028
2023 673888.7000000019
PER GROUP
39 Foodsharing Warszawa 487227.9524999999
2018 14057.140500000001
2019 47807.412300000025
2020 38440.8677
2021 90766.732
2022 172330.00000000003
2023 123825.80000000005
104 DLC Bocage Vendéen 595988.3593999993
2020 3925.63
2021 198399.22940000013
2022 223685.0
2023 169978.49999999994
527 Pick Food Asbl Dahlem 75261.0
2023 75260.99999999999
136 DLC Vendée ( littoral nord vendéen) 147783.543
2021 74647.54299999999
2022 42560.69999999999
2023 30575.30000000001
33 Foodsaving by Foodsharing Luxembourg 675427.8869999992
2019 135.0
2020 10538.5
2021 223281.48700000002
2022 255882.60000000006
2023 185590.30000000002
351 DLC Monts Marais Vie 84110.1
2021 468.29999999999995
2022 49066.99999999996
2023 34574.79999999999
148 RoBIN FooDS 26398.4
2021 8112.6
2022 12203.300000000001
2023 6082.5
53 Gemüse-Netzwerk e.V. 370.0
2018 80.5
2019 286.0
2020 3.5
10 Solikyl Göteborg 171570.36666666664
2018 3533.5
2019 15111.666666666666
2020 15136.0
2021 41364.0
2022 53551.4
2023 42861.799999999996
479 Lebensmittelretten & mehr Fürth 7637.2
2022 1921.0
2023 5716.2
103 Fællesskabet KBH - Free Fridge Copenhagen 2014.6999999999998
2020 7.5
2021 984.0
2022 390.20000000000005
2023 633.0
29 Essen für Alle (EfA) 733562.2166666663
2018 27113.816666666666
2019 61848.0
2020 140038.5
2021 189856.3
2022 190605.0
2023 124100.6
495 Solikyl Handels 2269.7
2022 998.0
2023 1271.6999999999998
76 Food Saving Leuven 5305.5
2019 477.0
2020 427.7
2021 835.0
2022 1673.5
2023 1892.3
329 Wir retten Essen 12273.0
2021 1232.0
2022 8808.0
2023 2233.0
240 Solidarecup Cornouaille 20.0
2021 20.0
218 Berria Foodsharing Bilbao 6160.9
2021 943.7
2022 3187.7
2023 2029.5
515 Recup Roma 336.29999999999995
2023 336.29999999999995
452 stop gâchis 1342.0999999999997
2023 1342.0999999999997
555 Stowarzyszenie 1532.0
2023 1532.0
461 Foodsavers West 618.0
2022 618.0
145 Foodsharing Copenhagen (Bread collection) 2271.0
2021 182.0
2022 1133.0
2023 956.0
86 DLC LSDO 467321.09200000006
2020 49271.445
2021 134595.447
2022 169621.1
2023 113833.09999999998
233 Team Manfred 5770.0
2021 1520.0
2022 3010.0
2023 1240.0
37 Foodsharing i Östersund 10304.0
2018 477.0
2019 2886.0
2020 2418.5
2021 2763.5
2022 1679.0
2023 80.0
75 Foodsharing Stockholm 19981.425
2020 4833.5
2021 10878.925000000001
2022 4269.0
65 Association DLC La Rochelle 13273.4
2019 1924.5
2020 3240.5
2021 3784.0
2022 2605.4
2023 1719.0
32 Food Saving Lund 4271.933333333333
2018 24.0
2019 679.8333333333333
2020 546.0
2021 723.5
2022 1327.9
2023 970.7
TOTALS
2018 46424.95716666665
2019 132939.66229999997
2020 271041.64269999997
2021 985973.7633999994
2022 1201268.8000000012
2023 928687.3000000024
PER GROUP
86 DLC LSDO 653971.4920000003
2020 49271.44499999999
2021 134595.44699999996
2022 169621.1
2023 161297.9
2024 139185.60000000006
104 DLC Bocage Vendéen 833220.6593999986
2020 3925.6299999999997
2021 198399.22940000013
2022 223685.00000000023
2023 232212.99999999994
2024 174997.80000000013
527 Pick Food Asbl Dahlem 419503.69999999995
2023 138844.40000000002
2024 280659.30000000005
136 DLC Vendée ( littoral nord vendéen) 193415.14299999995
2021 74647.54299999996
2022 42560.7
2023 41557.30000000001
2024 34649.60000000001
461 Foodsavers West 718.0
2022 618.0
2024 100.0
32 Food Saving Lund 5194.433333333333
2018 24.0
2019 679.8333333333333
2020 546.0
2021 723.5
2022 1327.9
2023 1441.1
2024 452.1
351 DLC Monts Marais Vie 148426.10000000015
2021 468.30000000000007
2022 49067.0
2023 46854.600000000006
2024 52036.200000000004
148 Robin Foods 62163.1
2021 8112.6
2022 12203.300000000001
2023 8877.7
2024 32969.5
39 Foodsharing Warszawa 721291.6524999996
2018 14057.140500000001
2019 47807.41230000002
2020 38440.8677
2021 90766.732
2022 172330.0
2023 175854.6
2024 182034.90000000008
29 Essen für Alle (EfA) 942548.1166666667
2018 27113.816666666666
2019 61848.0
2020 140038.5
2021 189856.3
2022 190605.0
2023 198579.59999999998
2024 134506.90000000002
37 Foodsharing i Östersund 10555.0
2018 477.0
2019 2886.0
2020 2418.5
2021 2763.5
2022 1679.0
2023 170.0
2024 161.0
479 Lebensmittelretten & mehr Fürth 9076.7
2022 1921.0
2023 7155.7
597 Aalto Foodsharing 379.2
2024 379.2
329 Wir retten Essen 17281.5
2021 1232.0
2022 8808.0
2023 3098.0
2024 4143.5
218 Berria Foodsharing Bilbao 8938.9
2021 943.7
2022 3187.7
2023 2794.5
2024 2013.0
452 stop gâchis 4027.3000000000006
2023 2412.7
2024 1614.6
103 Fællesskabet KBH - Free Fridge Copenhagen 2014.7
2020 7.5
2021 984.0
2022 390.2
2023 633.0
145 Foodsharing Copenhagen (Bread collection) 2866.0
2021 182.0
2022 1133.0
2023 1206.0
2024 345.0
75 Foodsharing Stockholm 20108.925
2020 4833.5
2021 10878.925
2022 4269.0
2024 127.5
65 Association DLC La Rochelle 14523.4
2019 1924.5
2020 3240.5
2021 3784.0
2022 2605.4
2023 2089.0
2024 880.0
76 Food Saving Leuven 9787.400000000001
2019 477.0
2020 427.7
2021 835.0
2022 1673.4999999999998
2023 2848.6000000000004
2024 3525.6
10 Solikyl Göteborg 258121.26666666666
2018 3533.5
2019 15111.666666666666
2020 15136.0
2021 41364.0
2022 53551.4
2023 61752.100000000006
2024 67660.6
TOTALS
2018 46424.95716666667
2019 132939.6623
2020 271041.64269999997
2021 985973.7633999998
2022 1201268.7999999998
2023 1339705.7999999982
2024 1152909.4999999993
print('PER GROUP')
print()
for g in Group.objects.filter(status='active'):
fs = Feedback.objects.filter(about__place__group=g)
w_2018 = fs.filter(created_at__year__gte=2018, created_at__year__lt=2019).aggregate(Sum('weight'))['weight__sum']
w_2019 = fs.filter(created_at__year__gte=2019, created_at__year__lt=2020).aggregate(Sum('weight'))['weight__sum']
w_2020 = fs.filter(created_at__year__gte=2020, created_at__year__lt=2021).aggregate(Sum('weight'))['weight__sum']
w_2021 = fs.filter(created_at__year__gte=2021, created_at__year__lt=2022).aggregate(Sum('weight'))['weight__sum']
w_2022 = fs.filter(created_at__year__gte=2022, created_at__year__lt=2023).aggregate(Sum('weight'))['weight__sum']
w_2023 = fs.filter(created_at__year__gte=2023, created_at__year__lt=2024).aggregate(Sum('weight'))['weight__sum']
w_2024 = fs.filter(created_at__year__gte=2024, created_at__year__lt=2025).aggregate(Sum('weight'))['weight__sum']
if w_2019 or w_2020 or w_2021 or w_2022 or w_2023 or w_2024:
print(g.id, g.name, fs.aggregate(Sum('weight'))['weight__sum'])
if w_2018:
print(' 2018', w_2018)
if w_2019:
print(' 2019', w_2019)
if w_2020:
print(' 2020', w_2020)
if w_2021:
print(' 2021', w_2021)
if w_2022:
print(' 2022', w_2022)
if w_2023:
print(' 2023', w_2023)
if w_2024:
print(' 2024', w_2024)
print()
print('TOTALS')
print()
fs = Feedback.objects
w_2018 = fs.filter(created_at__year__gte=2018, created_at__year__lt=2019).aggregate(Sum('weight'))['weight__sum']
w_2019 = fs.filter(created_at__year__gte=2019, created_at__year__lt=2020).aggregate(Sum('weight'))['weight__sum']
w_2020 = fs.filter(created_at__year__gte=2020, created_at__year__lt=2021).aggregate(Sum('weight'))['weight__sum']
w_2021 = fs.filter(created_at__year__gte=2021, created_at__year__lt=2022).aggregate(Sum('weight'))['weight__sum']
w_2022 = fs.filter(created_at__year__gte=2022, created_at__year__lt=2023).aggregate(Sum('weight'))['weight__sum']
w_2023 = fs.filter(created_at__year__gte=2023, created_at__year__lt=2024).aggregate(Sum('weight'))['weight__sum']
w_2024 = fs.filter(created_at__year__gte=2024, created_at__year__lt=2025).aggregate(Sum('weight'))['weight__sum']
print(' 2018', w_2018)
print(' 2019', w_2019)
print(' 2020', w_2020)
print(' 2021', w_2021)
print(' 2022', w_2022)
print(' 2023', w_2023)
print(' 2024', w_2024)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment