Statistics about the amount of saved food

to mzpawlowshi: I share your opinion completely!

E.g. for us (EfA - in Germany) the feetback feature, with detaild and realistic amounts for each shop and each foodsaver, is crucial and we use it all the time.

Especially if so many foodsaving groups are working in a different manner
an algorithm to built an everage or what ever will confuse people, would make the system less detailed and correct but more complicated.

In our group we often pickup the staff with several persons and in most cases, about 90% will be carried e.g. to varous Kindergarden and so on. Only about 10% is for private use.

For example 3 foodaver are picking up the total amount of about 50 kg net weight of goods (excluding the rubish) in one market.
1 foodsaver is carrying 45 kg fruits and vegetable for Kindergarden No1,
1 is taking 5 kg chocolate for Kindergarden No2, the other foodsaver helped but carried 0 kg.
We would prefere, if everyone can state the real amount and may give comments.
Statistic should show 50 kg as tolal amount, and nothing else (not a total of 25kg and not a total of 15kg fruit-vege-late).

1 Like

Oh, what a heated discussion! I’d like to take a step back and would be interested why the pickup weight is useful and/or important to you. That would help me a lot to implement good statistics :smiley:

Why the pickup weight is important for us:

Pickup weights are quite importtant for us,
because we report exactly

  • how much and what we received from each market in total,
  • how much and what everyone of us has taken,
  • and how much and what we have given to each institution.

Since we are a registered non-profit organisation we are obliged to report that we spend most of the stuff we received.
A well working statistic-tool in karrot is the best instrument to proof our obligations.

I’m definitely not making a big deal of how the feature should be and how statistics should be collected, but I’m making a big deal of the following points:

  • Not every group works the same and we should take that into account when designing and changing this feature. Maybe we should ask for more input from other groups? If most groups would like amounts to be set individually then I see no problem; But, more importantly:
  • If you don’t get the semantics correctly, there’s no point in having this feature if people are not understanding and using it accordingly. It became clear that people were misled by some bad translation, and if the feature changes it should be clear on what exactly it is asking for when you set an amount and how it calculates. If changed, it should state “How much food did you individually carry home or to a sharing spot?”. That should do the work fine in groups where you require foodsavers to always give feedback (since one feedback missing might already affect considerably the outcome) and not so much on groups that like to use this feature just to have a rough estimate.

There are no explanations for the user in karrots.
The use is intuitive.
Therefore the rule for every feature should be “what you see is what you get”.

If every person of the pickup-team is asked for feedback by the system and all feedbacks of the members of a pickup-team are shown, the user must assume, that his feedback will be used “pure”, without any hidden or additional algorithm.

I guess the phrase @bruno is refering to is this one:
The German version is equally clear stating ‘Menge des insgesamt geretteten Essens’, whereas the Polish version indicates that it’s just about the amount that you yourself saved. Just for context…

(And I’d like to point out that intuition works differently from one person to the other. The use of this feature is the perfect example to illustrate that imho… :wink: )

1 Like

I’m revisiting this topic just now and I thought a feedback export feature might be useful to you. You would be able to download a CSV file that you can import in LibreOffice or Excel. This would be per place or for the whole group.

You could use this file to calculate all kinds of statistics, e.g. weekly weight, average weight per pickup or weight per user.

Here’s how an example export looks like:

Do you think that would be useful to you? Especially @mzpawlowski @karolina @sylviaschneider


It’s great! Very helpful indeed!

Would it be also possible to extract CSV files with data other than feedbacks? E.g. history of pickups in a place or a history of user’s actions, etc.?

1 Like

Sure, we just need to figure out what columns the file should contain and which types to include. History data is a bit hard to work with because every type has its own payload/context.

1 Like

Great! I think the CSV file will do.
Best regards

Hey you statistics people! I released the first version of the CSV feedback export. It’s just a URL for now; there is no clickable link in Karrot (yet).

You can export all feedback with this:

If you want it just for one group, pass the group id like this (16 is the playground group):

And the same for just one place:

You can find the group and place ids in your browser, e.g. Karrot means group 16 with place 72.

Some more filtering examples:

1 Like

I’ve extracted a file for Foodsharing Warsaw (group=39) and successfully imported it into Excel which is great :slight_smile: The only comment which I have is that a file doesn’t have CSV extension after downloading it. It’s an uknown format but it still works.

Great job!

Glad that it works!

That depends on the browser. I noticed that it has a CSV ending in Firefox, but not in Chrome.

I find extract with feedbacks very useful but I don’t hide I’m really waiting for the extracts with history. Have you already had a chance to work on this? Maybe you have something which works to some extent but could already be used/tested?

Hey @mzpawlowski - I have a code branch that implements the basics, however I still need to rewrite old history entries to contain the same data as new ones and implement a fallback where this isn’t possible.

Chances are good that I will get around to do it in the next weeks, now that I’m almost done with upgrading Quasar, our user interface library. That took more than a month already and I’m looking forward to code something more fulfilling :wink: But it made pretty clear to me how much the Karrot grew in the last years…

1 Like

Coming back to this thread - I implemented, which means these things will change once I do the release (probably in the next days):

  • multiple feedback entries per pickup will be summed, not averaged
  • calculations for historical feedback will not change
  • a new clarification text on the feedback form: “For place statistics, we will add together the amount of all feedback.”

Does this sound alright?

In case you already want to translate the new text before the release, visit Log in · Transifex