Changes

Jump to navigation Jump to search
9,326 bytes added ,  09:09, 23 June 2021
Delete wrong mention
Line 1: Line 1:  +
== Quantities ==
 +
Collecting quantity isn't so simple:
 +
* we can see various units
 +
* we can see various ways of dealing with net weight and drained weight
 +
* sometimes portions are well specified and sometimes not
 +
* we can see many ways of ordering printed data on the packages
 +
* ...
 +
 +
=== Units ===
 +
...
 +
 +
=== e sign ===
 +
The ℮ sign (for "[https://en.wikipedia.org/wiki/Estimated_sign estimated sign]") is used in Europe and other countries, at least Australia: https://www.industry.gov.au/sites/default/files/2019-04/guide-to-the-average-quantity-system.pdf (p. 12)
 +
 +
It seems to refer to the Average Quantity System (AQS) which is in use in Australia, Canada, European Union, India, Japan, New Zealand, South Africa and Switzerland -- source: https://www.sfa.gov.sg/docs/default-source/tools-and-resources/resources-for-businesses/avabriefingonaqsslides1 (slide 3).
 +
 +
 +
== How to enter the data ==
 +
For the moment, the best is to enter the data as it is printed on the product.
 +
 +
 
== How to handle it ==
 
== How to handle it ==
 +
 +
=== Logic to handle it ===
 +
...
 +
 +
=== Existing libraries to parse weights and quantities ===
 +
* https://github.com/iancanderson/ingreedy
 +
 +
=== Using Wikidata ===
 +
* Translations and aliases of units
 +
** [https://tools.wmflabs.org/wikidata-todo/translate_items_with_property.php?prop=558 List of Units in multiple languages on Wikidata]
 +
 +
* weight unit list
 +
** [http://tools.wmflabs.org/wikidata-todo/tree.html?q=3647172&rp=31 Units of weight list on Wikidata]
 +
* units of volume
 +
** [http://tools.wmflabs.org/wikidata-todo/tree.html?q=1302471&rp=31 Units of volume list on Wikidata]
 +
 +
=== Possible calculations ===
 +
* Weight per item
 +
** Is the same item always the same weight (ham slices)
 +
**Useful if you eat one of the cakes in the packaging, and want to know how many calories you ate without having to weight the cake
 +
* Percentage of water
 +
**Useful to calculate actual cost if we know the price
 +
**Useful to fix calorie calculation for some products
 +
* Calculate packaging weight by making the difference between actual weight and advertised weight
 +
* Calculate weight per volume for products (1dL of water is 1kg, but this changes for various products that also have a mention of their volume, e.g. milk)
 +
* Some products will have multilingual weights
 +
** we can check that the conversion is well done if we have both values
 +
** we can display the value in several metrics if we have a sanitized value in one metric
 +
 +
=== Canonical approach ===
 +
The real-world quantities for products as used by the user (and printed on the packages) is not ideal. It is often impossible to parse the quantities and understand what is indicated.
 +
However it is possible to find some common approach. This is a first attempt.
 +
 +
Some remarks:
 +
* product central - any quantity that is indicated is about the product and not the packaging;
 +
* product unit - reference may be made to a product unit, eg a cookie, a chocolate egg, etc.
 +
* equivalents - one or more equivalents might be available, i.e. in grams, oz or liters, 24 cookies / 6 cookies in 4 packages;
 +
* containers - the generic toplevel package is a container;
 +
* subcontainers - a container might comprise multiple subcontainers (or even subsubcontainers) [hierarchy?/taxonomy?]
 +
* (sub-)container synonyms - a user might container other words to describe a container, such as bottle, can, bag, etc.  [hierarchy?/taxonomy?]
 +
* defaults - in indicating the quantity some parts are assumed to be understood. If it states 33cl it is assumed to be about the container (the bottle) and the product (beer);
 +
* components - a product might consist of multiple components, which must be combined to get the product. Cf Creme brulee = vanilla cream + caramel flakes (to be heated).
 +
* subproduct - sometimes a subproduct quantity is indicated (net/brut, egoutté/drained);
 +
* verbosity - the language used in specifying quantity must be translated to a parsable format;
 +
* scattered - all information necessary to fill the entire quantity formula might be scattered over the package.
 +
* detail quantities - sometimes a detailed quantity might be present (1 biscuit weighs 23g) and a multiplier is needed to get the total weight of the package;
 +
* marketing - some quantities are added for marketing purposes, extra 25g;
 +
* subsubcontainers - an extra subdivision, eg 1 carton of yoghurt with 2 layers and 8 pots per layer;
 +
* servings - a quantity might contain a number of servings
 +
 +
=== Generic formula ===
 +
Any generic quantity formula should reference the product(-name), the container and a volume or weight measure. The productname and container should (?) reference the corresponding fields.
 +
 +
The quantity formula is:<br \><br \>
 +
 +
<big>container_multiplier x container_name x product_multiplier x (sub_)product_name x quantity_value x quantity_unit</big>
 +
 +
This formula should be valid for each container/subcontainer/subsubcontainer level, but should reflect the entire package. So one has to add multipliers and brackets where appropriate.
 +
 +
For example:
 +
* 1 bottle of red wine comprising 70 cl (on the bottle indicated as "70 cl");
 +
* 1 package of granola cookies with a total weight of 276 g (just printed as 276g), which is equivalent to:
 +
** 1 package of 12 biscuits with a total weight of 276g, which is equivalent to:
 +
** 1 package of 12 biscuits with an individual weight of 23g per biscuit.
 +
 +
=== Practical usage ===
 +
In practice however other indications are used by users. There is no best practice defined.
 +
 +
* to indicate times, either a "*" or a "x" is used;
 +
* equivalent formulas are distinguished by a ";" or brackets "(,)"
 +
** multiplier indicates how often a quantity unit is used, i.e. 6 (25 cl bottles). This is a number.
 +
** quantity the size of the units in size_units, i.e. 25 (size) cl (size_unit) bottles (units). This is a number.
 +
** size_units is the unit for the size parameter, i.e. kg, ml or cl. This is an enumerated?
 +
** unit is the element the numbers and sizes refer to, i.e. pot, bottle, sack, etc.
 +
 +
=== Test approach ===
 +
To test this approach the examples found in France have translated to this formal approach:
 +
{| class="wikitable sortable"
 +
|-
 +
! Quantity as stated by user !! Container multiplier !! Container name !! Product multiplier !! Product name !! Quantity value !! Quantity unit
 +
|-
 +
| 1 kg (8 pots) - [2 x (4 x 125 g)] || 8 || pots || - || - || 1 || kg
 +
|-
 +
| or || 2 x 4 || pots || - || - || 125 || g
 +
|-
 +
| 275 g [250 g + 25 g (10 %) gratuit] || - || - || - || - || 275 || g
 +
|-
 +
| or || - || - || - || - || 275 + 25 || g
 +
|-
 +
| 2 * 400 g (800 g) ||  2 || - || - || - || 400 || g
 +
|-
 +
| or || - || - || - || - || 800 || g
 +
|-
 +
| 4X100g || 4 || - || - || - || 100 || g
 +
|-
 +
| 2*25g || 2 || - || - || - || 25 || g
 +
|-
 +
| 200 g [160 g (2 x 8 pièces) mini-nems + 40 g sauce nuoc mâm] || - || - || - || - || 200 || g
 +
|-
 +
| or || - || - || 2x8 || mini-nems || 160 || g
 +
|-
 +
| + || - || - || - || sauce nuoc mâm || 40 || g
 +
|-
 +
| 211,5 g (9x23,5g) || - || - || -  || - || 211,5 || g
 +
|-
 +
| or || 9 || - || -  || - || 23,5 || g
 +
|-
 +
| 220g (2 unités, 2 x (60 g + 50 g)) || - || - || -  || - || 220 || g
 +
|-
 +
| or || - || - || 2  || unités || 60 + 50 || g
 +
|-
 +
| 2 x 21.5 g = 43 g || - || - || -  || - || 43 || g
 +
|-
 +
| or || 2 || - || -  || - || 21.5 || g
 +
|-
 +
|  300 g (15 biscuits de 20 g) || - || - || -  || - || 300 || g
 +
|-
 +
|  or || - || - || 15  || biscuits || 20 || g
 +
|-
 +
| 1 Litre || - || - || -  || - || 1 || litre
 +
|-
 +
| 18tranche || - || - ||  18 || tranches || - || -
 +
|-
 +
| 375 g, 30 pièces || - || - || - || - || 375 || g
 +
|-
 +
| or || - || - || 30 || pièces || - || -
 +
|-
 +
| 240 g (12 Portions) || -  || - || - || - || 240 || g
 +
|-
 +
| or || - || - || 12 || portions|| - || -
 +
|-
 +
| 400 g (12 à 18 bouchées )|| -  || - || - || - || 400 || g
 +
|-
 +
| or || -  || - || 12 à 18 || bouchées || - || -
 +
|-
 +
| Poids net 190 g, poids net égoutté 140 g || -  || - || - || net || 190 || g
 +
|-
 +
| Poids net 190 g, poids net égoutté 140 g || -  || - || - || net égoutté || 140 || g
 +
|-
 +
| contenance : 4250ml, poids net total : 4000g, poids net égoutté : 2210g ||-  || - || - || - || 4250 || ml
 +
|-
 +
| or ||-  || - || - || net || 4000 || g
 +
|-
 +
| or  ||-  || - || - || net égoutté || 2210 || g
 +
|-
 +
| 3 x [200 g (130 g net égoutté), 212 ml] || 3 || - || - || - || 200 || g
 +
|-
 +
| or || 3 || - || - || - || 212 || ml
 +
|-
 +
| or || 3 || - || - || net egoutté || 130 || g
 +
|-
 +
|  330 g (dont 180 g net), 370 mL ||-  || - || - || - || 330 || g
 +
|-
 +
|  or ||-  || - || - || - || 370 || mL
 +
|-
 +
|        or ||-  || - || - || net || 180 || g
 +
|-
 +
| 28 g - 20 dragées || -  || - || 20 || dragées || 28 || g
 +
|-
 +
| 260 g (26 portions de 10 g) || -  || - || - || - || 260 || g
 +
|-
 +
| 130 g pour 20 galettes || - || - || 20 || galettes || 130 || g
 +
|-
 +
| 280 ml - 310 g || -  || - || - ||- || 280 || ml
 +
|-
 +
| or || - -  || - || - ||- || 310 || g
 +
|-
 +
| 25 sachets || 25 || sachets || - || - || - || -
 +
|-
 +
| 220 g (1 personne) || - || - || - || - || 220 || g
 +
|-
 +
| 128 g (16 bâtonnets de 2 cubes) || -  || - || 16 || bâtonnets || 128 || g
 +
|-
 +
| or || - || - || 16x2 || cubes || 128 || g
 +
|-
 +
| 12 (calibre Moyen => 53 à 63 g) || - || - || 12 || calibre moyen || 53 à 63 || g
 +
|-
 +
| 8 sachets de 4 || 8 || sachets || 4 || - || - || -
 +
|-
 +
| 400 g, 425 ml (3 douzaines) || - || - || 3x12 || - || 400 || g
 +
|-
 +
| 400 g, 425 ml (3 douzaines) || - || - || 3x12 || - || 425 || ml
 +
|-
 +
| 228g (4x57g) / 48 cl (4x12cl)
 +
|}
 +
 +
[[Category:ProductOpener]]
 +
 
== Countries ==
 
== Countries ==
 
=== France ===
 
=== France ===
Line 67: Line 276:  
| nestle || 228g (4x57g) / 48 cl (4x12cl) || [http://fr.openfoodfacts.org/produit/2000000003897 (link)]
 
| nestle || 228g (4x57g) / 48 cl (4x12cl) || [http://fr.openfoodfacts.org/produit/2000000003897 (link)]
 
|}
 
|}
 +
[[Category:OCR]]
 +
[[Category:ProductOpener]]

Navigation menu