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 === | | === Possible calculations === |
| * Weight per item | | * Weight per item |
Line 8: |
Line 45: |
| **Useful to fix calorie calculation for some products | | **Useful to fix calorie calculation for some products |
| * Calculate packaging weight by making the difference between actual weight and advertised weight | | * 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) | + | * 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 | | * Some products will have multilingual weights |
| ** we can check that the conversion is well done if we have both values | | ** 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 | | ** 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 == |
Line 80: |
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]] |