In this guide
Enter product information
For each product you wish to assess, you will need 3 types of information.
- Product category
- Nutrient data
- Promotional information
The next sections of this guide will introduce you to each in turn, and show you where you can find the information.
Before you move on, here's how you should enter the data into the form.
Entering product information
Completing the form
Enter as many new products on the form as you wish, by adding each product as a new row and completing all the columns as indicated.
When entering a product, first select the category from the dropdown list in column A, then select the sub-category from the dropdown list in column B.
Tip: as you select the category and sub-category, some sections of the form may turn grey, indicating data is not required in that field for that product category.
Try to complete all the white boxes. If you complete a grey box, the value you enter will not be used for the NPPM assessment, as it isn't required.Essential notes for completing the spreadsheet
- Zeros: Enter zero when you know the value is zero, don’t leave it blank as it will be counted as ‘missing information’ e.g. If the product contains no fruit, enter ‘0’ in the ‘total fruit’ and ‘dry fruit’ columns or if no water/stock has been added, enter ‘0’.
- Product weight: ‘Product weight’ column refers to the WEIGHT REFERENCE used on the nutrient panel and NOT PACK WEIGHT. Usually, nutrient data are presented per 100g or per serving size. Be sure to enter nutrient data (energy, fat, sodium etc.) relating to the value you enter in this column.
- Fruit percent: The total fruit column must be completed even if the product only contains dry fruit. The total fruit value is the sum of fresh and dry fruit.
If you don't have the information you need to complete a box, don't worry, just leave it blank. Knowing that information is missing is useful in itself.
Missing information will be summarised on the results page as 'not assessed', helping you to identify areas where companies need to be more transparent with customers.
As there's no overall NPPM score, missing information for one component won't stop you assessing other components of the model.
Some columns in the form have built-in validation. This specifies what type of information you can provide.
For example, where you must enter a number, and the range that number must be within. If you see an error message, check you have entered the correct data format.
Adding more rows
In the form, you will see a black line below row 20. This indicates the end of the table.
If you have lots of product data to enter, you may need to add more rows to the table. Simply right click in the table and add a new row above the black line.