The Health Star Rating Calculator allows you to enter data specific to your products to calculate their star rating.
The Health Star Rating Calculator can be downloaded as an Excel Spreadsheet embedded with the algorithm and lookup tables.
The Health Star Rating system Calculator and Style Guide provides detailed information about how the Health Star Rating is calculated. The Health Star Rating Calculator should be used in conjunction with this Guide.
Downloading the Health Star Rating Calculator
Licence
The Health Star Rating Calculator is licensed only on the condition that you agree to the terms and conditions set out on the terms and conditions page. Please read these terms and conditions carefully. If you agree to be bound by the terms and conditions, you should continue to use this calculator. If you do not agree to be bound by the terms and conditions, you should close this calculator.
Disclaimer
The Commonwealth does not warrant that the results generated by the calculator will be free from error, or if used will ensure compliance with the relevant requirements of the Australia New Zealand Food Standards Code.
Note that the accuracy of the final score calculated by the calculator will be dependent on the accuracy of the data entered into the calculator.
Consequently, before relying on the results generated by the calculator, you should carefully evaluate the accuracy, completeness and relevance of the results for your purposes, and should obtain appropriate expert advice relevant to your own particular circumstances.
The Commonwealth makes this calculator available on the understanding that users exercise their own skill, care and judgement; and seek independent expert advice with respect to its use.
By accessing this calculator, you acknowledge that the Commonwealth will not be liable for any incidental or consequential damages resulting from its use.
Copyright
This work is copyright.
© Commonwealth of Australia 2014
Requests for further authorisation should be directed to:
Communication BranchEmail the Department of Health copyright inbox
Department of Health
GPO Box 9848
Canberra ACT 2610
Australia
Instructions to using the Health Star Rating Calculator (HSRC) spreadsheet
Values should be entered in all of the orange fields only. The blue fields will autopopulate. All nutrient and energy values are for the food product, per 100g / 100mL.
Row number
Optional.
Health Star Rating Category
Select from the drop down list.Food
Enter the name and appropriate descriptors (such as pack size, flavour) for the food product.
Company name
Optional.
Nutrient information fields
Energy, Saturated Fat, Total Sugars, Sodium, Fibre, Protein, Conc(entrated) FVNL%, FVNL%.
For each field, enter the amount of each nutrient per 100g /100mL for the food product.
Star rating
This will be generated automatically. Coloured icons represent full stars. Open/uncoloured icons represent half stars. If you believe that your health star rating is incorrect, consider the following points.
In the Health Star Rating Calculator:
- Have you chosen the correct category for the food product?
- Have all nutrient values been entered correctly?
- Have you entered values (or zero values) in all of the orange spreadsheet fields?
- Has FVNL (fruit, vegetable, nut and legume) content been calculated correctly?
