INTRODUCTION: RECIPES GENERATOR BY AMRITA Algorithm
“Overall idea of AMRITA”
In this study, we describe a mobile service, whose name (AMRITA), which recalls the Sanskrit name of the food of gods and that is a pseudonymous for Autonomous Management of Recipes Integrating Touristic Associates.
AMRITA is aimed at cooking chefs and that generates list of ingredients for recipes made of local products. We focus on a specific type of cooking recipes based on plants, which are used in cultural food practices worldwide to support wellbeing (“phytonutrition”).
Researchers in food technology have been successfully developing food recommenders but there is a gap concerning the notion of phytonutrition changes the set of required functions and the theoretical framework to assess the software.
These are the steps done by the AMRITA algorithm:
117 food items and season are collected from the BioSuisse database
999 food values items are gathered from the Food Compendium (source: link)
- 2543 EU nutritional claims come from the EU database (link)
- 23 information concerning daily Intakes refer from the Swiss regulation (link)
Example of food list for phytonutrition
| Ingredients | Qte..gr. | folate | iron..Fe. | magnesium..Mg. | niacin |
|---|---|---|---|---|---|
| Sugar.pea..steamed..without.addition.of.salt. | 69 | 15.87 | 1.242 | 21.39 | 1.7250 |
| Spinach..steamed..without.addition.of.salt. | 31 | 46.50 | 0.868 | 21.39 | 0.2294 |
| Beer..five.grain | 375 | 18.75 | 0.000 | 41.25 | 2.8875 |
| TOT | : | 81.12 | 2.110 | 84.03 | 4.8419 |
| GOAL (reduction of tiredness and fatigue) | : | 30.00 | 2.100 | 56.25 | 2.4000 |
| CHECK (reduction of tiredness and fatigue) | : | 1.00 | 1.000 | 1.00 | 1.0000 |
The table shows the amount for each ingredient, and how the dish allows to make a nutritional claim.
We create a list of 23 Food Data Conversion keys Across collected Tables
We extract data of the seasonal products from the excel files with raw data, coming from Swiss and European databases.
We obtain a list of 26 seasonal foods for the month Jun, by combining the Swiss Food Compendium and the BioSuisse datasets. The dataset has 18 rows.
We select only the relevant nutriments for reduction of tiredness and fatigue, according to the European database of medical claims.
We pass from 18 rows to 9 rows. Then, we analyze data of our 26 food ingredients, by using the European Food database.
We set the target function as the nutriment intake level according to Gender and Age. The current level is set for Adult (817.022.16:49) . This is the amount required by the Swiss law 817.022.16:49
We present a solution that uses food ingredients in different amounts, while reaching the required intake and illustrating in details how the food ingredients allow to address the individual claim reduction of tiredness and fatigue.
Assessing an existing recipe
| Recipe | Nutrient | blood coagulation | energy-yielding metabolism | function of digestive enzymes | maintenance of normal bones and teeth | muscle function and neurotransmission | regulation of cell division and differentiation | "cell membrane permeability" | contribution to the maintenance or achievement of a normal body weight | maintenance of normal blood pressure | reduction of tiredness and fatigue | contribution to normal psychological functions | maintenance of normal acid-base balance | contribution to normal digestion by production of hydrochloric acid in the stomach | blood formation | cell division | contribution to normal amino acid synthesis | function of the immune system | homocysteine metabolism | maternal tissue growth during pregnancy | contribution to normal cognitive and neurological function | contribution to normal energy-yielding metabolism | contribution to normal thyroid function and production of thyroid hormones | maintenance of skin | maintenance of vision | maintenance of hair | maintenance of nails | cognitive function | formation of red blood cells and haemoglobin | oxygen transport | “activity of heart, liver and muscles” | biotransformation of xenobiotic substances | electrolyte balance | maintenance of bones | maintenance of teeth | neurotransmission and muscle contraction including heart muscle | protein synthesis | Maintenance of normal blood pressure | Maintenance of normal blood pressure during pregnancy | “Hormonal health” | protection of DNA, proteins and lipids from oxidative damage | maintenance of the normal function of the immune system | Maintenance of normal blood glucose concentrations | function of the nervous system | maintenance of normal skin and mucous membranes | Maintenance of normal blood flow | function of cell membranes | maintenance of bone and teeth | blood pressure | muscular and neurological function | Maintenance of normal muscle function | cell differentiation | maintenance of normal vision | metabolism of iron | maintenance of bone | "energy and vitality" | contribution to neurological and psychological function | contribution to normal homocysteine metabolism | red blood cell formation | maintenance of normal bone | maintenance of normal hair | maintenance of normal nails | maintenance of normal skin | maintenance of normal teeth | contribution to normal cysteine synthesis | protein and glycogen metabolism | regulation of hormonal activity | Mental performance | collagen formation | function of the immune system during and after extreme physical exercise | non-haem iron absorption | regeneration of the reduced form of vitamin E | antioxidant function of lutein | absorption and utilisation of calcium and phosphorus and maintenance of normal blood calcium concentrations | maintenance of bones and teeth | normal function of immune system and inflammation response | normal muscle function | thyroid function | maintenance of normal cardiac function | contribution to normal cognitive function | maintenance of normal vision by protection of the lens of the eye | regeneration of the reduced form of vitamin C | maintenance of normal blood circulation | acid-base metabolism | contribution to normal carbohydrate metabolism | contribution to normal macronutrient metabolism | contribution to normal protein synthesis | DNA synthesis and cell division | fertility and reproduction | maintenance of normal serum testosterone concentrations | vitamin A metabolism | muscle function | function of the heart and blood vessels | prostate function | maintenance of joints |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Dents de lion en salade cuite | calcium (Ca) | 1 | 1 | 1 | 1, 1 | 1, 1 | 1 | 1 | 1 | 1, 1 | 1 | 1 | 1 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
| Dents de lion en salade cuite | chloride (Cl) | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
| Dents de lion en salade cuite | folate | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
| Dents de lion en salade cuite | iodide (I) | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1, 1 | 1 | 1 | 1 | 1 | 1 | 1 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
| Dents de lion en salade cuite | iron (Fe) | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | NULL | NULL | NULL | NULL | 1 | NULL | 1 | NULL | NULL | NULL | 1 | NULL | NULL | NULL | NULL | NULL | 1 | 1 | 1 | 1 | 1 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
| Dents de lion en salade cuite | magnesium (Mg) | 1 | 1 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | 1 | NULL | NULL | NULL | 1 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | 1 | 1 | 1, 1 | 1 | 1, 1 | 1 | 1 | 1 | 1 | 1 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
| Dents de lion en salade cuite | niacin | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0, 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
| Dents de lion en salade cuite | phosphorus (P) | NULL | 1 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | 1, 1 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
| Dents de lion en salade cuite | potassium (K) | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | 1, 1 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
| Dents de lion en salade cuite | sodium (Na) | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
| Dents de lion en salade cuite | vitamin A activity | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | 1 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1, 1 | NULL | NULL | NULL | NULL | NULL | 1 | 1 | NULL | NULL | 1, 1 | NULL | NULL | NULL | NULL | NULL | NULL | 1 | 1 | 1 | 1, 1 | 1 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
| Dents de lion en salade cuite | vitamin B12 (cobalamin) | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | 0 | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0, 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
| Dents de lion en salade cuite | vitamin B6 (pyridoxine) | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | NULL | NULL | NULL | NULL | NULL | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
| Dents de lion en salade cuite | vitamin C (ascorbic acid) | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | NULL | NULL | 0, 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0, 0, 0, 0, 0, 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
| Dents de lion en salade cuite | vitamin D (calciferol) | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0, 0 | 0, 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
| Dents de lion en salade cuite | vitamin E activity | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | 1, 1 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | NULL | NULL | NULL | 1 | 1 | 1 | 1 | 1 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | 1, 1 | 1 | 1 | 1 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
| Dents de lion en salade cuite | zinc (Zn) | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | NULL | NULL | NULL | NULL | NULL | NULL | 1 | NULL | NULL | NULL | NULL | NULL | NULL | 1 | NULL | NULL | 1 | NULL | NULL | NULL | NULL | NULL | 1 | NULL | NULL | NULL | NULL | NULL | NULL | 1 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | 1 | 1 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | NULL | NULL | NULL | NULL | NULL | 1 | 1 | 1 | 1 | 1, 1 | 1, 1 | 1 | 1 | 1 | 1 | 1 | 1 |
| Gaspacho aux herbes | calcium (Ca) | 1 | 1 | 1 | 1, 1 | 1, 1 | 1 | 1 | 1 | 1, 1 | 1 | 1 | 1 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
| Gaspacho aux herbes | chloride (Cl) | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
| Gaspacho aux herbes | folate | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | 1 | NULL | NULL | 1 | 1 | 1 | 1 | 1 | 1 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
| Gaspacho aux herbes | iodide (I) | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1, 1 | 1 | 1 | 1 | 1 | 1 | 1 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
| Gaspacho aux herbes | iron (Fe) | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | NULL | NULL | NULL | NULL | 1 | NULL | 1 | NULL | NULL | NULL | 1 | NULL | NULL | NULL | NULL | NULL | 1 | 1 | 1 | 1 | 1 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
| Gaspacho aux herbes | magnesium (Mg) | 1 | 1 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | 1 | NULL | NULL | NULL | 1 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | 1 | 1 | 1, 1 | 1 | 1, 1 | 1 | 1 | 1 | 1 | 1 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
| Gaspacho aux herbes | niacin | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | 1 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | 1, 1 | 1 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
| Gaspacho aux herbes | phosphorus (P) | NULL | 1 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | 1, 1 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
| Gaspacho aux herbes | potassium (K) | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | 1, 1 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
| Gaspacho aux herbes | sodium (Na) | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
| Gaspacho aux herbes | vitamin A activity | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | 1 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1, 1 | NULL | NULL | NULL | NULL | NULL | 1 | 1 | NULL | NULL | 1, 1 | NULL | NULL | NULL | NULL | NULL | NULL | 1 | 1 | 1 | 1, 1 | 1 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
| Gaspacho aux herbes | vitamin B12 (cobalamin) | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | 0 | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0, 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
| Gaspacho aux herbes | vitamin B6 (pyridoxine) | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | 1 | NULL | NULL | NULL | NULL | NULL | 1 | NULL | NULL | NULL | 1 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
| Gaspacho aux herbes | vitamin C (ascorbic acid) | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | 1 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | NULL | NULL | 1, 1 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | 1 | NULL | 1 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1, 1, 1, 1, 1, 1 | 1 | 1 | 1 | 1 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
| Gaspacho aux herbes | vitamin D (calciferol) | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0, 0 | 0, 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
| Gaspacho aux herbes | vitamin E activity | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | 1, 1 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | NULL | NULL | NULL | 1 | 1 | 1 | 1 | 1 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | 1, 1 | 1 | 1 | 1 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
| Gaspacho aux herbes | zinc (Zn) | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | NULL | NULL | NULL | NULL | NULL | NULL | 1 | NULL | NULL | NULL | NULL | NULL | NULL | 1 | NULL | NULL | 1 | NULL | NULL | NULL | NULL | NULL | 1 | NULL | NULL | NULL | NULL | NULL | NULL | 1 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | 1 | 1 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | NULL | NULL | NULL | NULL | NULL | 1 | 1 | 1 | 1 | 1, 1 | 1, 1 | 1 | 1 | 1 | 1 | 1 | 1 |
| Purée de panais aux herbes | calcium (Ca) | 1 | 1 | 1 | 1, 1 | 1, 1 | 1 | 1 | 1 | 1, 1 | 1 | 1 | 1 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
| Purée de panais aux herbes | chloride (Cl) | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
| Purée de panais aux herbes | folate | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | 1 | NULL | NULL | 1 | 1 | 1 | 1 | 1 | 1 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
| Purée de panais aux herbes | iodide (I) | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1, 1 | 1 | 1 | 1 | 1 | 1 | 1 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
| Purée de panais aux herbes | iron (Fe) | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | NULL | NULL | NULL | NULL | 1 | NULL | 1 | NULL | NULL | NULL | 1 | NULL | NULL | NULL | NULL | NULL | 1 | 1 | 1 | 1 | 1 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
| Purée de panais aux herbes | magnesium (Mg) | 1 | 1 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | 1 | NULL | NULL | NULL | 1 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | 1 | 1 | 1, 1 | 1 | 1, 1 | 1 | 1 | 1 | 1 | 1 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
| Purée de panais aux herbes | niacin | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | 1 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | 1, 1 | 1 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
| Purée de panais aux herbes | phosphorus (P) | NULL | 1 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | 1, 1 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
| Purée de panais aux herbes | potassium (K) | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | 1, 1 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
| Purée de panais aux herbes | sodium (Na) | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
| Purée de panais aux herbes | vitamin A activity | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | 1 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1, 1 | NULL | NULL | NULL | NULL | NULL | 1 | 1 | NULL | NULL | 1, 1 | NULL | NULL | NULL | NULL | NULL | NULL | 1 | 1 | 1 | 1, 1 | 1 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
| Purée de panais aux herbes | vitamin B12 (cobalamin) | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | 0 | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0, 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
| Purée de panais aux herbes | vitamin B6 (pyridoxine) | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | 1 | NULL | NULL | NULL | NULL | NULL | 1 | NULL | NULL | NULL | 1 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
| Purée de panais aux herbes | vitamin C (ascorbic acid) | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | 1 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | NULL | NULL | 1, 1 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | 1 | NULL | 1 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1, 1, 1, 1, 1, 1 | 1 | 1 | 1 | 1 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
| Purée de panais aux herbes | vitamin D (calciferol) | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0, 0 | 0, 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
| Purée de panais aux herbes | vitamin E activity | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | 1, 1 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | NULL | NULL | NULL | 1 | 1 | 1 | 1 | 1 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | 1, 1 | 1 | 1 | 1 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
| Purée de panais aux herbes | zinc (Zn) | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | NULL | NULL | NULL | NULL | NULL | NULL | 1 | NULL | NULL | NULL | NULL | NULL | NULL | 1 | NULL | NULL | 1 | NULL | NULL | NULL | NULL | NULL | 1 | NULL | NULL | NULL | NULL | NULL | NULL | 1 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | 1 | 1 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | NULL | NULL | NULL | NULL | NULL | 1 | 1 | 1 | 1 | 1, 1 | 1, 1 | 1 | 1 | 1 | 1 | 1 | 1 |
| Salade de trévise caramelisée | calcium (Ca) | 1 | 1 | 1 | 1, 1 | 1, 1 | 1 | 1 | 1 | 1, 1 | 1 | 1 | 1 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
| Salade de trévise caramelisée | chloride (Cl) | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
| Salade de trévise caramelisée | folate | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
| Salade de trévise caramelisée | iodide (I) | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1, 1 | 1 | 1 | 1 | 1 | 1 | 1 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
| Salade de trévise caramelisée | iron (Fe) | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | NULL | NULL | NULL | NULL | 1 | NULL | 1 | NULL | NULL | NULL | 1 | NULL | NULL | NULL | NULL | NULL | 1 | 1 | 1 | 1 | 1 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
| Salade de trévise caramelisée | magnesium (Mg) | 1 | 1 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | 1 | NULL | NULL | NULL | 1 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | 1 | 1 | 1, 1 | 1 | 1, 1 | 1 | 1 | 1 | 1 | 1 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
| Salade de trévise caramelisée | niacin | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0, 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
| Salade de trévise caramelisée | phosphorus (P) | NULL | 1 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | 1, 1 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
| Salade de trévise caramelisée | potassium (K) | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | 1, 1 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
| Salade de trévise caramelisée | sodium (Na) | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
| Salade de trévise caramelisée | vitamin A activity | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | 1 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1, 1 | NULL | NULL | NULL | NULL | NULL | 1 | 1 | NULL | NULL | 1, 1 | NULL | NULL | NULL | NULL | NULL | NULL | 1 | 1 | 1 | 1, 1 | 1 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
| Salade de trévise caramelisée | vitamin B12 (cobalamin) | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | 0 | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0, 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
| Salade de trévise caramelisée | vitamin B6 (pyridoxine) | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | NULL | NULL | NULL | NULL | NULL | 0 | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
| Salade de trévise caramelisée | vitamin C (ascorbic acid) | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | NULL | NULL | 0, 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0, 0, 0, 0, 0, 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
| Salade de trévise caramelisée | vitamin D (calciferol) | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0, 0 | 0, 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
| Salade de trévise caramelisée | vitamin E activity | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | 1, 1 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | NULL | NULL | NULL | 1 | 1 | 1 | 1 | 1 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | 1, 1 | 1 | 1 | 1 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
| Salade de trévise caramelisée | zinc (Zn) | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | NULL | NULL | NULL | NULL | NULL | NULL | 1 | NULL | NULL | NULL | NULL | NULL | NULL | 1 | NULL | NULL | 1 | NULL | NULL | NULL | NULL | NULL | 1 | NULL | NULL | NULL | NULL | NULL | NULL | 1 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | 1 | 1 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | NULL | NULL | NULL | NULL | NULL | 1 | 1 | 1 | 1 | 1, 1 | 1, 1 | 1 | 1 | 1 | 1 | 1 | 1 |
Evaluation of the performance of AMRITA: Results from a satisfaction survey
The Excel file has 37 rows.
There are four performance indicators that allow to assess the performance of the service:
- WTP_Dish: The willingness to pay for a dish
- WTP_Menu: The willingness to pay for the menu
- Freq: The willingness to pay for a menu multiple times over one year
- NPS: The willingness to recommend the service to other people
The customer lifetime value (CLV) over one year can be obtained from WPT_Menu * Freq
The customer referral value (CRV) can be derived from the the willingness to recommend the service to other people (the so-called net promoter score).
Segmentation of the participants
We created a definition of Champion by using * the median of the customer lifetime value over one year * the cutoff of 8/10 for the Net Promoter Score to assess the customer referral value
Source of the image: Kumar, V., Petersen, J. A., & Leone, R. P. (2007). How valuable is word of mouth?. Harvard business review, 85(10), p. 139.
In our dataset, we have 13 Champions (35%)
A dataset for mixed analysis
| ID | Athmosphere | Employees | Menu1 | Taste | Senses | Age | Gender | Dish | Well.being | Menu2 | WTP.Dish | WTP.Menu | Freq | NPS | CLV | Champion | santé | intéress | saveur | incroy | découvert | plaisir | originalité | goûteux | bien.êtr | couleur | gustat | expérienc | savoureux | origin |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 3 | 4 | 4 | 4 | 3 | 55 | 0 | 3 | 4 | 3 | 0 | 50 | 12 | 8 | 600 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 2 | 5 | 5 | 5 | 5 | 5 | 45 | 0 | 5 | 5 | 5 | 0 | 35 | 24 | 10 | 840 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 3 | 5 | 5 | 5 | 5 | 5 | 45 | 0 | 5 | 5 | 5 | 26 | 40 | 24 | 10 | 960 | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
In the end, we obtain a dataset with feedback about the service quality, the customer lifetime value and referral value (CLV/CRV), and the columns for text analysis of the comments
Polarized wordcloud
NULL
We obtain a polarized wordcloud, which shows the frequency of words used by Champions (=1) and the other customer segments (=0).
Detailed analysis of the comments:
Once we add the words (tokens) to the survey table, we obtain the following dataset
The word network shows 3 clusters of words: * Tasty: the words Tasty and Original appears often in the same phrase * Discovery: the word discovery is central to a set of other words such as colors, taste experience, interesting and health * Pleasure: the word pleasure is connected to incredible, well-being and original
On the one hand, tasty suggests a functional job to be done: Participants expects the phyto-nutrition to do for them a job that has a function, that is to feed them. The focus here is on the food.
On the other hand, pleasure suggests an emotional job to be done: participants associates phyto-nutrition with a positive feeling. The focus here is on the overall experience.
Data mining: Rules to classify Champions
| len | freq | err | condition | pred |
|---|---|---|---|---|
| 5 | 0.421 | 0 | Dish>4.5 & Well.being>4.5 & découvert<=0.5 & expérienc<=0.5 & savoureux<=0.5 | 1 |
| 2 | 0.263 | 0 | Dish<=4.5 & originalité<=0.5 | 0 |
| 1 | 0.158 | 0 | Well.being<=4.5 | 0 |
| 3 | 0.105 | 0 | Dish>4.5 & découvert>0.5 & couleur<=0.5 | 0 |
| 3 | 0.053 | 0 | Dish>4.5 & découvert>0.5 & couleur>0.5 | 1 |
| 5 | 0.053 | 0 | Taste>4.5 & Dish>4.5 & saveur>0.5 & découvert>0.5 & plaisir<=0.5 | 0 |
| 5 | 0.579 | 0.182 | Menu1>4.5 & Taste>4.5 & découvert<=0.5 & bien.êtr<=0.5 & expérienc<=0.5 | 1 |
| 6 | 0.263 | 0.2 | Menu1>4.5 & Taste>4.5 & Senses>4.5 & intéress<=0.5 & incroy<=0.5 & expérienc<=0.5 | 1 |
| 1 | 0.895 | 0.471 | plaisir<=0.5 | 0 |
| 5 | 0.105 | 0.5 | Taste>4.5 & Dish>4.5 & saveur<=0.5 & découvert>0.5 & plaisir<=0.5 | 0 |
| 1 | 0.105 | 0.5 | couleur>0.5 | 0 |
Performance of the RF algorithm
| .metric | .estimate |
|---|---|
| roc_auc | 1.0000000 |
| accuracy | 0.9444444 |
Data mining: A linear model to predict the emergence of a “Champion”
In this sub-section, we compare two different models. For each model, we present the results of the logarithmic function to predict whether the participant is a champion or not (1 or 0).
The first model Takes into account the fact the well-being effect of the dish (Well.being), the overall setting (_-Athmosphere) and the importance of delivering exactly what has beeen promised in the menu (Dish). The first model shows that all these elements have a positive effect on the likelihood of having a Champion, and it controls for Gender: men are more likely to be Champions, but the distribution of the coefficient is very large and that means that such estimate is not statistically significant.
The second model takes into account the comments of the participants, and identify the positive and negative effects associated to the two jobs to be done (functional and sentimental). Moreover, the second model shows that the combined effects of the other variables is also important (e.g. A good dish in a good setting). In the end, the simple effect of gender becomes not relevant anymore, since it has been decomposed into precise variables.
In-depth analysis of each dependent variables with structual equation modelling
All previous models used Champion as one single variable.
This model allows to predict all three performance indicators at once, by using three variables: * The frequency of purchase
The Willingess to pay (WTP) of a menu
The Net Promoter score (NPS) of each participant
To perform the diagnostic of the model we follow the guidelines of Klein link (the detailed results are in the appendix)
The model chi-square >0.05 shos that the model is different than any other random model with the same variables.
The Root Mean Square Error of Approximation (RMSEA) < 0.08 tells that the model is parsimonious (no other variable can be removed)
The Tucker Lewis index > 0.95 indicates the model of interest improves the fit by 95% relative to the null model (This measure is preferred to the Comparative Fit Index, when using small size - here we use 37 answers)
The Standardized Root Mean Square Residual (SRMR) < 0.08 confirms that we have a small square-root of the difference between the residuals of the sample covariance matrix and the hypothesized model. The SRMR is also preferred when assessing a model across different SEM fit indexes source
Extra 01: The detailed coefficient of the linear regression
| Model 1 | Model 2 | |
|---|---|---|
| (Intercept) | 0.29 ** | 0.40 *** |
| (3.52, p = 0.00) | (4.43, p = 0.00) | |
| `log(Well.being)` | 0.12 | 0.25 ** |
| (1.54, p = 0.13) | (3.09, p = 0.00) | |
| `log(Athmosphere)` | 0.05 | 0.22 * |
| (0.53, p = 0.60) | (2.22, p = 0.04) | |
| `log(Dish)` | 0.10 | 0.11 |
| (1.10, p = 0.28) | (1.21, p = 0.24) | |
| Gender | 0.30 | 0.02 |
| (1.59, p = 0.12) | (0.09, p = 0.93) | |
| goûteux | -0.75 ** | |
| (-2.99, p = 0.01) | ||
| gustat | -0.44 | |
| (-1.42, p = 0.17) | ||
| incroy | 0.32 | |
| (1.14, p = 0.26) | ||
| `log(Well.being)`:`log(Athmosphere)` | 0.23 | |
| (1.90, p = 0.07) | ||
| `log(Well.being)`:`log(Dish)` | -0.01 | |
| (-0.04, p = 0.96) | ||
| `log(Athmosphere)`:`log(Dish)` | -0.24 * | |
| (-2.51, p = 0.02) | ||
| `log(Well.being)`:`log(Athmosphere)`:`log(Dish)` | -0.17 | |
| (-2.00, p = 0.06) | ||
| N | 37 | 37 |
| R2 | 0.29 | 0.61 |
| All continuous predictors are mean-centered and scaled by 1 standard deviation. *** p < 0.001; ** p < 0.01; * p < 0.05. | ||
For each item, the coefficient is shown, together with the standard error and the p-value (between parentheses).
Comments about Logit
Extra: Decision tree
Truth
Prediction 0 1
0 6 1
1 6 5| .metric | .estimator | .estimate |
|---|---|---|
| roc_auc | binary | 0.6875000 |
| accuracy | binary | 0.6111111 |
The gender might not be statistically significant because the model is linear.
A non-linear model generates a decision tree, which uses gender to classify participants into Champions (=1), not Champions (=0) and everything in between (>0.5 implies a participant that is likely to be a Champion)
The performance of the classification algorithm has been tested with a combination of (70% training set, 30% testing set).
The detailed outcome of tests done with a Random Forest algorithm are in the appendixes.
Extra: Detailed analysis of the structural equation model
Chi2, RMSEA, CTI/TLI and SRMR
lavaan 0.6-7 ended normally after 129 iterations
Estimator ML
Optimization method NLMINB
Number of free parameters 17
Number of observations 37
Model Test User Model:
Test statistic 2.049
Degrees of freedom 4
P-value (Chi-square) 0.727
Model Test Baseline Model:
Test statistic 39.536
Degrees of freedom 15
P-value 0.001
User Model versus Baseline Model:
Comparative Fit Index (CFI) 1.000
Tucker-Lewis Index (TLI) 1.298
Loglikelihood and Information Criteria:
Loglikelihood user model (H0) -491.603
Loglikelihood unrestricted model (H1) -490.579
Akaike (AIC) 1017.206
Bayesian (BIC) 1044.592
Sample-size adjusted Bayesian (BIC) 991.460
Root Mean Square Error of Approximation:
RMSEA 0.000
90 Percent confidence interval - lower 0.000
90 Percent confidence interval - upper 0.180
P-value RMSEA <= 0.05 0.760
Standardized Root Mean Square Residual:
SRMR 0.049
Parameter Estimates:
Standard errors Standard
Information Expected
Information saturated (h1) model Structured
Regressions:
Estimate Std.Err z-value P(>|z|) Std.lv Std.all
Freq ~
Dish 23.134 21.082 1.097 0.272 23.134 0.160
Well.being 27.096 23.642 1.146 0.252 27.096 0.167
Gender 90.823 26.485 3.429 0.001 90.823 0.472
WTP.Menu ~
Well.being -12.077 5.741 -2.104 0.035 -12.077 -0.339
Dish 9.026 5.119 1.763 0.078 9.026 0.284
NPS ~
Well.being 1.089 0.375 2.903 0.004 1.089 0.409
Dish 0.721 0.334 2.157 0.031 0.721 0.304
Covariances:
Estimate Std.Err z-value P(>|z|) Std.lv Std.all
Dish ~~
Well.being 0.084 0.046 1.825 0.068 0.084 0.315
.Freq ~~
.WTP.Menu -57.903 177.397 -0.326 0.744 -57.903 -0.054
.NPS -5.542 11.611 -0.477 0.633 -5.542 -0.079
.WTP.Menu ~~
.NPS 0.501 2.812 0.178 0.859 0.501 0.029
Variances:
Estimate Std.Err z-value P(>|z|) Std.lv Std.all
.Freq 4437.481 1031.693 4.301 0.000 4437.481 0.707
.WTP.Menu 261.639 60.830 4.301 0.000 261.639 0.865
.NPS 1.117 0.260 4.301 0.000 1.117 0.662
Dish 0.299 0.070 4.301 0.000 0.299 1.000
Well.being 0.238 0.055 4.301 0.000 0.238 1.000
Gender 0.169 0.039 4.301 0.000 0.169 1.000Comments
Extra: The same Structual equation model with categorical dependent variables
Chi2, RMSEA, CTI/TLI and SRMR
lavaan 0.6-7 ended normally after 122 iterations
Estimator DWLS
Optimization method NLMINB
Number of free parameters 16
Number of observations 37
Model Test User Model:
Standard Robust
Test Statistic 2.282 2.281
Degrees of freedom 2 2
P-value (Chi-square) 0.319 0.320
Scaling correction factor 1.004
Shift parameter 0.008
simple second-order correction
Model Test Baseline Model:
Test statistic 0.331 0.597
Degrees of freedom 3 3
P-value 0.954 0.897
Scaling correction factor 1.111
User Model versus Baseline Model:
Comparative Fit Index (CFI) 0.000 0.000
Tucker-Lewis Index (TLI) 1.159 1.176
Robust Comparative Fit Index (CFI) NA
Robust Tucker-Lewis Index (TLI) NA
Root Mean Square Error of Approximation:
RMSEA 0.063 0.062
90 Percent confidence interval - lower 0.000 0.000
90 Percent confidence interval - upper 0.343 0.343
P-value RMSEA <= 0.05 0.352 0.352
Robust RMSEA NA
90 Percent confidence interval - lower 0.000
90 Percent confidence interval - upper NA
Standardized Root Mean Square Residual:
SRMR 0.000 0.000
Parameter Estimates:
Standard errors Robust.sem
Information Expected
Information saturated (h1) model Unstructured
Regressions:
Estimate Std.Err z-value P(>|z|) Std.lv Std.all
Freq ~
Dish 23.251 16.078 1.446 0.148 23.251 0.161
Well.being 27.039 18.373 1.472 0.141 27.039 0.167
Gender 88.374 48.487 1.823 0.068 88.374 0.460
WTP.Menu ~
Well.being -12.110 7.928 -1.527 0.127 -12.110 -0.340
Dish 9.096 4.409 2.063 0.039 9.096 0.286
NPS ~
Well.being 1.102 0.466 2.364 0.018 1.102 0.422
Dish 0.694 0.347 1.999 0.046 0.694 0.298
Covariances:
Estimate Std.Err z-value P(>|z|) Std.lv Std.all
.Freq ~~
.WTP.Menu -60.127 227.550 -0.264 0.792 -60.127 -0.054
.NPS -5.455 12.228 -0.446 0.656 -5.455 -0.077
.WTP.Menu ~~
.NPS 0.657 2.629 0.250 0.803 0.657 0.038
Intercepts:
Estimate Std.Err z-value P(>|z|) Std.lv Std.all
.Freq -214.849 113.200 -1.898 0.058 -214.849 -2.682
.WTP.Menu 68.778 36.271 1.896 0.058 68.778 3.901
.NPS 0.113 2.476 0.046 0.964 0.113 0.087
Variances:
Estimate Std.Err z-value P(>|z|) Std.lv Std.all
.Freq 4559.704 2065.573 2.207 0.027 4559.704 0.710
.WTP.Menu 268.543 56.258 4.773 0.000 268.543 0.864
.NPS 1.092 0.202 5.416 0.000 1.092 0.654Plot
Comments