{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Terms and conditions","Design","Lookups","Points Table A","Points Table C","Draft calculator","Drop-down, HSR categories"],"not_rendered":{"charts":12,"images":0,"macros":1,"external_links":2,"defined_names":194,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Terms and conditions","index":0,"n_rows":32,"n_cols":1,"rows_kept":32,"cut":false,"hidden":true,"merged":[]}
["Licence"]
["The Health Star Rating Calculator is licensed only on the condition that you agree to the terms and conditions set out below. 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"]
[]
["The Commonwealth grants you a non-exclusive, non-transferable right to access, use and display the calculator, provided that you comply fully with these terms and conditions:"]
["1. you may display, print and reproduce this material in unaltered form only (retaining this notice) for your own personal use or use within your organisation; "]
["2. apart from any other use permitted under the Copyright Act 1968 (Cth), all other rights are reserved; "]
["3. you may not use any part of the calculator to establish, maintain, or provide, or assist in establishing, maintaining or providing your own publications, whether on the internet or otherwise; and "]
["4. in particular, you may not sell access to the calculator or any material derived from the calculator. "]
[]
["Requests for further authorisation should be directed to:"]
["Communications Branch"]
["Department of Health"]
["GPO Box 9848"]
["Canberra ACT 2610"]
["Australia"]
[]
["Email: copyright@health.gov.au "]

{"sheet":"Design","index":1,"n_rows":24,"n_cols":7,"rows_kept":24,"cut":false,"hidden":true,"merged":[[3,1,9,1],[1,3,1,5],[1,1,2,2],[1,6,2,6]]}
[]
[null,"FoPL System Design",null,"NPSC Categories",null,null,"FoPL Calibration Solution"]
[null,null,null,"(1) Beverages","(2) Food","(3) Fats, Cheese"]
[null,"AGHE Categories","Vegetables","Beverages, non-dairy (whole juices, >80% FVNL are considered Core)","Vegetables (potato, broccoli cabbage, legumes, tomatoes, tinned peas, corn, etc - processed & unprocessed. Combinations thereof)","N/A","Calibrate using NPSC Beverages & NPSC Food end points respectively"]
[null,null,"Core Cereals","Beverages, non-dairy (unfortified rice milk, etc)","Core cereals (bread, rice, pasta, breakfast cereals, polenta, grains and their components - processed and unprocessed. Combinations thereof)","N/A","Calibrate using NPSC Beverages & NPSC Food end points respectively"]
[null,null,"Protein","Core dairy - beverages (fortified soy milk, etc)","Protein (meat, fish, poultry, eggs, nuts, legumes, tofu, etc - processed and unprocessed. Combinations thereof)","N/A","Calibrate using FoPL Core Dairy (beverages) & NPSC Food end points respectively"]
[null,null,"Core Dairy","Core dairy - beverages (many variants of milk)","Core dairy - yoghurt, soft cheese (Ca =< 320 mg/100g)","Core dairy - cheese (hard cheese, Ca >320 mg/100g)","Calibrate separately as part of Core Dairy, using FoPL end points from each class"]
[null,null,"Fruit","Beverages, non-dairy (whole juices, => 90% FVNL are considered Core)","Fruit (bananas, grapes, apples, oranges, watermelon, etc - processed and unprocessed. Combinations thereof)","N/A","Calibrate using NPSC Beverages & NPSC Food end points respectively"]
[null,null,"Non-core foods","Beverages, non-dairy (carbonated beverages, alcohol, cordials, juices < 90% FVNL, etc)","Non-core foods (chips, pies, cakes, biscuits, pastry, snacks, meals and meal bases, soups, stocks, sugar, salt, sauces, dressings, condiments, pizza, dips, jelly, icecream, custard, cream, cream cheese, soft drinks, confectionery)","N/A","Calibrate using NPSC Beverages & NPSC Food end points respectively"]
[null,null,"Fats/Oils","N/A","N/A","Fats, oils (butter, margarine, olive oil, canola oil, vegetable oils. Other oils)","Calibrate separately using NPSC end points for Fats/oils"]
[]
[null,"AGHE categories (for reference purposes)"]
[null,"Core Cereals",null,"Core cereals include bread, rice, pasta, breakfast cereals, polenta, grains, components of grains"]
[null,"Core Dairy & Analogues",null,"Core Dairy & Analogues includes milk, cheese, yoghurt & analogues"]
[null,"Protein Foods",null,"Protein foods include meat, fish, poultry, eggs, nuts, legumes, tofu"]
[null,"Fruit",null,"Fruit includes bananas, grapes, apples, oranges, watermelon, etc & whole juices"]
[null,"Vegetables",null,"Vegetables includes processed and unprocessed potato, broccoli cabbage, legumes, tomatoes, corn, chick peas, etc, and whole juices"]
[null,"Fats & Oils",null,"Fats & Oils includes butter, margarine, olive oil, canola oil, vegetable oils. Any other oils."]
[null,"Non-core foods",null,"Off-plate food includes chips, pies, cakes, biscuits, pastry, snacks, meals and meal bases, soups, stocks, sugar, salt, sauces, dressings, "]
[null,null,null,"condiments, pizza, dips, jelly, icecream, custard, cream, cream cheese, soft drinks, confectionery & alcohol"]
[null,null,null,"Also includes \"Other\" foods either not on the plate, or from multiple parts of the plate without a particular dominance."]
[]
[null,"Not in the FoPL System"]
[null,"Water",null,"Water includes; tap water, spring water, carbonated water"]

{"sheet":"Lookups","index":2,"n_rows":135,"n_cols":14,"rows_kept":135,"cut":false,"hidden":true,"merged":[]}
["Star score","Symbols","Star Conversion Divisor"]
[1,"²",{"$f":"A55","v":"Beverages, non-dairy"},{"$f":"IF(D55<9,D55+0.999,9.999)","v":9.9990000000000006}]
[2,"«","Core Cereals",9.9990000000000006]
[3,"«²","Core Dairy - beverages",8.9990000000000006]
[4,"««","Core Dairy - cheese",9.9990000000000006]
[5,"««²","Core Dairy - yoghurt, soft cheese",9.9990000000000006]
[6,"«««","Fats, oils",9.9990000000000006]
[7,"«««²","Fruit",9.9990000000000006]
[8,"««««","Non-core foods",9.9990000000000006]
[9,"««««²","Protein",9.9990000000000006]
[10,"«««««","Vegetables",9.9990000000000006]
[null,null,"If %Food range < 9 then Range = Range + 0.999, else Range = 9.999"]
[null,null,"Required because not all categories have HSRC range >10"]
["Scaling Criteria:"]
["(1) Healthy reference foods in each category typically achieve at least four stars"]
["(2) Non-healthy reference foods in each category typically achieve half to one star"]
["(3) Foods considered to be Core to score at least 3 stars"]
["(4) The star score range extends from five stars, downwards to least healthy scores in each NPSC category"]
["(5) Foods will score star points within the range of star points so established"]
["(6) Categories with a range of NPSC points <10 (<5 stars) will start at 5 stars and extend downwards"]
["(7) The 'most healthy' food will be set at an NPSC score at or below the 5% quantile of NPSC scores for the category"]
["(8) The 'least healthy' food will be set by an NPSC score at or above the 95% quantile of NPSC scores for the category"]
[]
["More healthy reference foods =>4 stars:"]
[{"$f":"A55","v":"Beverages, non-dairy"},"Whole fruit juices, typically > 67% FVNL, <13.6% total sugars"]
[{"$f":"A56","v":"Core Cereals"},"Whole grain foods, high fibre, protein increased"]
["Core Dairy - beverages","Low fat milks and alternatives (typically <2.1% sat fat and/or > 3.1% protein)"]
["Core Dairy - cheese","Reduced fat cheese, reduced sodium"]
["Core Dairy - yoghurt, soft cheese","Lite yoghurt, cottage cheese"]
["Fats, oils","Extra lite spreads, canola, olive oils"]
["Fruit","Unprocessed fruit"]
["Non-core foods","Typically whole grain biscuits and snacks, occasional foods low in saturated fat, sugar and sodium"]
["Protein","Trimmed meat/fish, whole legumes, raw nuts"]
["Vegetables","Unprocessed vegetables"]
[]
[]
["Less healthy reference foods =<1 star:",null,null,null,null,null,"↓ = more ²","↑ = more «««««",null,null,"↓ = more ²","↑ = more «««««"]
[{"$f":"A55","v":"Beverages, non-dairy"},"Beverages typically 0% FVNL, sugars >13.6%",null,null,null,"Original scaling tables",null,null,null,"TAG mods"]
[{"$f":"A56","v":"Core Cereals"},"Typically highly refined, high sugar, low fibre ceral foods",null,null,null,"Beverages, non-dairy",3,-6,null,"Beverages, non-dairy",3,-6]
["Core Dairy - beverages","Full fat, sweetened, flavoured milks, typically with protein <3.2%, sugar >9.1%",null,null,null,"Core Cereals",29,-15,null,"Core Cereals",29,-15]
["Core Dairy - cheese","High sodium, high saturated fat cheese",null,null,null,"Core Dairy - beverages",6,-2,null,"Core Dairy - beverages",6,-2]
["Core Dairy - yoghurt, soft cheese","Regular fat yoghurt, sugar typically > 9.1%",null,null,null,"Core Dairy - cheese",41,21,null,"Core Dairy - cheese",41,21]
["Fats, oils","Salted butter, copha, coconut oil",null,null,null,"Core Dairy - yoghurt, soft cheese",6,-2,null,"Core Dairy - yoghurt, soft cheese",14,-3]
["Fruit","Jams, 0% FVNL, pastes & spreads",null,null,null,"Fats, oils",45,10,null,"Fats, oils",44,16]
["Non-core foods","White sugar, table salt",null,null,null,"Fruit",29,-15,null,"Fruit",27,-11]
["Protein","Highly seasoned, untrimmed and/or manufactured meats",null,null,null,"Non-core foods",29,-15,null,"Non-core foods",29,-15]
["Vegetables","Salted (in brine, etc), processed vegetables",null,null,null,"Protein",29,-15,null,"Protein",29,-15]
[null,null,null,null,null,"Vegetables",29,-15,null,"Vegetables",29,-15]
[]
["FLEXED END-POINTS CAN BE ENTERED HERE, IN THE BLUE CELLS IMMEDIATELY BELOW!"]
["DO NOT CHANGE ANY OTHER NUMBERS ON THIS SHEET",null,null,null,null,"Weighted Average quantiles at x(Np)"]
["('More healthy' end point set at or below the 5% quantile of NPSC scores, less healthy at or above 95%)",null,null,null,null,"MAX/MIN END-POINTS INCL NEW INDUSTRY DATA (sans anomaly foods)",null,null,null,"QUANTILES - INCL NEW INDUSTRY DATA (sans anomaly foods)"]
["% Foods flexed end points based on new industry data",null,null,null,null,"Actual % Foods maxima/minima based on new industry data",null,null,null,"\"% Foods\" Quantiles based on new industry data"]
["FoPL calibration category","↓ = more ²","↑ = more «««««","Range",null,"FoPL Category","Less healthy","More healthy",null,"FoPL Category",0.99,0.95,0.05,0.01]
["Beverages, non-dairy",3,-6,{"$f":"B55-C55","v":9},null,{"$f":"A55","v":"Beverages, non-dairy"},3,-7,null,{"$f":"A55","v":"Beverages, non-dairy"},2,2,-5,-6]
["Core Cereals",29,-15,44,null,"Core Cereals",19,-21,null,"Core Cereals",15,12,-11,-14]
["Core Dairy - beverages",6,-2,8,null,"Core Dairy - beverages",4,-3,null,"Core Dairy - beverages",4,3,-2,-3]
["Core Dairy - cheese",41,21,20,null,"Core Dairy - cheese",44,14,null,"Core Dairy - cheese",41,37,21,15]
["Core Dairy - yoghurt, soft cheese",14,-3,17,null,"Core Dairy - yoghurt, soft cheese",6,-4,null,"Core Dairy - yoghurt, soft cheese",6,5,-2,-4]
["Fats, oils",44,16,28,null,"Fats, oils",47,9,null,"Fats, oils",46,45,10,10]
["Fruit",29,-15,44,null,"Fruit",17,-14,null,"Fruit",17,14,-9,-13]
["Non-core foods",29,-15,44,null,"Non-core foods",39,-15,null,"Non-core foods",31,27,-2,-6]
["Protein",29,-15,44,null,"Protein",32,-20,null,"Protein",21,15,-12,-18]
["Vegetables",29,-15,44,null,"Vegetables",13,-23,null,"Vegetables",8,3,-16,-19]
["Note: FoPL Categories are indicated in comments",null,null,null,null,"Note: FoPL Categories are indicated in comments",null,null,null,"Note: FoPL Categories are indicated in comments"]
[null,null,null,null,null,"MAX/MIN END-POINTS INCL NEW INDUSTRY DATA (sans anomaly foods)",null,null,null,"QUANTILES - INCL NEW INDUSTRY DATA (sans anomaly foods)"]
["Core Dairy foods","Core dairy uses FoPL category quantiles",null,"End points",null,"Actual % Foods maxima/minima based on new industry data",null,null,null,"\"% Foods\" Quantiles based on new industry data"]
[null,0.99,0.05,"99% - 5%",null,"NPSC Category","Less healthy","More healthy",null,"NPSC category",0.99,0.95,0.05,0.01]
[null,null,null,null,null,"Beverages",4,-7,null,"Beverages",3,3,-5,-6]
["Non-core foods","Other categories use NPSC category quantiles",null,null,null,"Food",39,-23,null,"Food",29,23,-11,-15]
[null,0.99,0.01,"99% - 1%",null,"Oils/cheese",47,9,null,"Oils/cheese",45,41,17,10]
[]
["Core Foods (non-dairy)"]
[null,0.99,0.01,"99% - 1%"]
[]
["Core and non-core beverages (non-dairy)"]
[null,0.99,0.01,"99% - 1%"]
[]
["Data for calculation purposes - do not alter",null,null,"List of HSR categories used for food analysis purposes"]
["Daily Intake References",null,null,"Enter a food type"]
["Energy, kJ",8700,null,"Core Cereals - bread"]
["Protein, g",50,null,"Core Cereals - breakfast"]
["Fat, g",70,null,"Core Cereals - pasta/flour/grains"]
["Saturated fatty acids, g",24,null,"Core Dairy - beverages"]
["Carbohydrate, g",310,null,"Core Dairy - cheese"]
["Sodium, mg",2300,null,"Core Dairy - yoghurt, soft cheese"]
["Sugars, g",90,null,"Dairy Non-core foods - cream"]
["Dietary fibre (if included), g",30,null,"Dairy Non-core foods - cream cheese"]
[null,null,null,"Fats, oils & oil based spreads"]
[null,null,null,"Fruit - other juices"]
["NPSC Food categories","Health claim  eligibility NPSC score",null,"Fruit - processed"]
[1,1,null,"Fruit - unprocessed"]
[2,4,null,"Fruit - whole juices"]
[3,28,null,"Non-core foods - bakery/cake mixes"]
[null,null,null,"Non-core foods - biscuits"]
["Constants used for NPSC purposes:",null,null,"Non-core foods - carbonated beverages"]
["All FVNL Concentrated",null,null,"Non-core foods - confectionery"]
["Yes",null,null,"Non-core foods - cordial"]
["No",null,null,"Non-core foods - custard/deserts"]
[null,null,null,"Non-core foods - dips"]
[null,null,null,"Non-core foods - dressings"]
[null,null,null,"Non-core foods - ice confectionery"]
[null,null,null,"Non-core foods - ice cream"]
[null,null,null,"Non-core foods - jelly"]
[null,null,null,"Non-core foods - lifestyle"]
["Protein tipping point =",null,11,"Non-core foods - meals/meal bases"]
["Max baseline points for inclusion of Protein points, unless V points >5",null,null,"Non-core foods - miscellaneous"]
[null,null,null,"Non-core foods - pizza"]
[null,null,null,"Non-core foods - sauces/condiments"]
[null,null,null,"Non-core foods - snacks"]
[null,null,null,"Non-core foods - soups/stocks"]
[null,null,null,"Non-core foods - yeast spread"]
["Claim","Yes",null,"Protein - meats/fish"]
[null,"Enter the food name here",null,"Protein - nuts"]
["Is all FVNL concentrated? Yes/No",null,null,"Protein - plant"]
[null,null,null,"Vegetables - processed"]
[null,null,null,"Vegetables - unprocessed"]
[null,null,null,"Non-core foods - beverage dry mixes",null,null,"Added this new line to keep the dry sep, as it mught be useful when we deal with as prepared"]
[null,null,null,"Core Dairy - beverages dry mix/milk powder"]
["Fruit/Veg tipping point =",null,5,"Water_Category NA"]
["Min V points for inclusion of Protein points if Baseline > 13",null,null,"flavoured water"]
[null,null,null,"Core Dairy  alternative- beverages"]
[null,null,null,"Protein - meats/fish Raw"]
["Data for category entry validation:"]
["HSR Category","NPSC Category","NPSC Group Number"]
["Beverages, non-dairy","Beverages",1]
["Core Cereals","Food",2]
["Core Dairy - beverages","Beverages",1]
["Core Dairy - cheese","Fats/Oils/Cheese",3]
["Core Dairy - yoghurt, soft cheese","Food",2]
["Fats, oils","Fats/Oils/Cheese",3]
["Fruit","Food",2]
["Non-core foods","Food",2]
["Protein","Food",2]
["Vegetables","Food",2]

{"sheet":"Points Table A","index":3,"n_rows":108,"n_cols":22,"rows_kept":108,"cut":false,"hidden":true,"merged":[[38,12,39,12],[38,0,38,4],[38,5,38,8],[38,9,39,9],[38,10,39,10],[38,11,39,11]]}
["For HC calcs","Extended HSR tables, category 1&2 foods",null,null,null,null,null,"Extended tables, category 3 foods, as per 1.2.7"]
["NPSC sugar table","Energy, kj","Sat fat g","Tot Sug g","Na, mg","NPSC/HSR Points",null,"Energy, kj","Sat fat g","Tot Sug g","Na, mg","NPSC/HSR Points",null,"Graph for Cat 1&2 foods - all Cat 3 tables are linear",null,null,null,null,null,null,null,"Graph for Cat 3 Foods"]
[0,0,0,0,0,0,null,0,0,0,0,0]
[5.01,335.01,1.01,5.01,90.01,1,null,335.01,1.01,5.01,90.01,1]
[9.01,670.01,2.0100000000000002,8.93,180.01,2,null,670.01,2.0100000000000002,9.01,180.01,2]
[13.51,1005.01,3.0100000000000002,12.84,270.01,3,null,1005.01,3.0100000000000002,13.51,270.01,3]
[18.010000000000002,1340.01,4.01,16.760000000000002,360.01,4,null,1340.01,4.01,18.010000000000002,360.01,4]
[22.51,1675.01,5.01,20.68,450.01,5,null,1675.01,5.01,22.51,450.01,5]
[27.01,2010.01,6.01,24.59,540.01,6,null,2010.01,6.01,27.01,540.01,6]
[31.01,2345.0100000000002,7.01,28.51,630.01,7,null,2345.0100000000002,7.01,31.01,630.01,7]
[36.01,2680.01,8.01,32.43,720.01,8,null,2680.01,8.01,36.01,720.01,8]
[40.01,3015.01,9.01,36.340000000000003,810.01,9,null,3015.01,9.01,40.01,810.01,9]
[45.01,3350.01,10.01,40.26,900.01,10,null,3350.01,10.01,45.01,900.01,10]
[null,3685.01,11.209999999999999,44.18,990.01,11,null,3685.01,11.01,null,990.01,11]
[null,null,12.51,48.09,1080.01,12,null,null,12.01,null,1080.01,12]
[null,null,13.91,52.01,1170.01,13,null,null,13.01,null,1170.01,13]
[null,null,15.51,55.93,1260.01,14,null,null,14.01,null,1260.01,14]
[null,null,17.310000000000002,59.84,1350.01,15,null,null,15.01,null,1350.01,15]
[null,null,19.310000000000002,63.76,1440.01,16,null,null,16.010000000000002,null,1440.01,16]
[null,null,21.610000000000003,67.680000000000007,1530.01,17,null,null,17.010000000000002,null,1530.01,17]
[null,null,24.110000000000003,71.59,1620.01,18,null,null,18.010000000000002,null,1620.01,18]
[null,null,26.91,75.510000000000005,1710.01,19,null,null,19.010000000000002,null,1710.01,19]
[null,null,30.01,79.430000000000007,1800.01,20,null,null,20.010000000000002,null,1800.01,20]
[null,null,33.51,83.34,1890.01,21,null,null,21.01,null,1890.01,21]
[null,null,37.409999999999997,87.26,1980.01,22,null,null,22.01,null,1980.01,22]
[null,null,41.71,91.18,2070.0100000000002,23,null,null,23.01,null,2070.0100000000002,23]
[null,null,46.61,95.09,2160.0100000000002,24,null,null,24.01,null,2160.0100000000002,24]
[null,null,52.01,99.01,2250.0100000000002,25,null,null,25.01,null,2250.0100000000002,25]
[null,null,58.01,null,2340.0100000000002,26,null,null,26.01,null,2340.0100000000002,26]
[null,null,64.710000000000008,null,2430.0100000000002,27,null,null,27.01,null,2430.0100000000002,27]
[null,null,72.31,null,2520.0100000000002,28,null,null,28.01,null,2520.0100000000002,28]
[null,null,80.61,null,2610.0100000000002,29,null,null,29.01,null,2610.0100000000002,29]
[null,null,90.01,null,2700.01,30,null,null,30.01,null,2700.01,30]
[]
[null,null,null,null,null,null,null,"The above tables are all linear, as per HC Standard 1.2.7 for Cat 3 foods"]
[]
[null,"Note: All values have been inflated by 0.01 (one reportable increment) to match the 'greater than' requirements of the tables provided by FSANZ"]
[]
["Total sugar points tables for various table options, commencing at 5% sugar",null,null,null,null,"Reduction required to maintain existing sugar points",null,null,null,"Profiler points","% reduction of total sugar (via added) to maintain same points (24 point table)","% reduction of total sugar (via added) to maintain same points (25 point table)","% reduction of total sugar (via added) to maintain same points (30 point table)"]
["22 point table","23 point table","24 point table","25 point table","30 pt sugar table","23 point","24 point","25 point","30 point"]
[0,0,0,0,0,0,0,0,0,0,0,0,0]
[5.01,5.01,5.01,5.01,5.01,0,0,0,0,1,0,0,0]
[9.01,9.2827272727272714,9.0969565217391306,8.9266666666666659,8.2513793103448272,0,0.18577075098814078,0.35606060606060552,1.0313479623824442,2,2.0421198072586331E-2,3.9887297168850512E-2,0.1249909770951184]
[13.51,13.555454545454541,13.183913043478261,12.843333333333332,11.492758620689655,0,0.37154150197627978,0.71212121212120927,2.0626959247648866,3,2.8181428438658559E-2,5.5446759313875632E-2,0.17947787757863037]
[18.010000000000002,17.828181818181811,17.270869565217392,16.759999999999998,14.734137931034482,0,0.55731225296441878,1.068181818181813,3.094043887147329,4,3.2268916794254289E-2,6.3733998698198874E-2,0.20999151098147054]
[22.51,22.100909090909081,21.357826086956521,20.676666666666666,17.975517241379308,0,0.74308300395255955,1.424242424242415,4.1253918495297732,5,3.4792071109070843E-2,6.8881626192604309E-2,0.22950059206269724]
[27.01,26.373636363636351,25.444782608695654,24.593333333333334,21.216896551724133,0,0.92885375494069677,1.780303030303017,5.1567398119122174,6,3.6504684250014567E-2,7.2389659676186643E-2,0.24304873237896657]
[31.01,30.64636363636362,29.531739130434786,28.51,24.458275862068959,0,1.114624505928834,2.1363636363636189,6.1880877742946616,7,3.7743273466076553E-2,7.4933835018015385E-2,0.2530058868087034]
[36.01,34.91909090909089,33.618695652173919,32.426666666666669,27.699655172413784,0,1.3003952569169712,2.4924242424242209,7.2194357366771058,8,3.8680717133440672E-2,7.6863412081339039E-2,0.26063269350251606]
[40.01,39.191818181818164,37.705652173913052,36.343333333333334,30.94103448275861,0,1.486166007905112,2.84848484848483,8.2507836990595536,9,3.9414939729734408E-2,7.8377093877414386E-2,0.2666615333646058]
[45.01,43.464545454545437,41.792608695652184,40.26,34.182413793103436,0,1.6719367588932528,3.204545454545439,9.2821316614420013,10,4.0005561056713587E-2,7.9596260669285629E-2,0.27154699248637448]
[49.01,47.73727272727271,45.879565217391317,44.176666666666662,37.423793103448261,0,1.8577075098813935,3.5606060606060481,10.313479623824449,11,4.0490957163151202E-2,8.0599246825761306E-2,0.27558616507192468]
[54.01,52.009999999999984,49.966521739130449,48.093333333333327,40.665172413793087,0,2.0434782608695343,3.9166666666666572,11.344827586206897,12,4.0896948391531088E-2,8.1438868866093528E-2,0.27898142102451484]
[58.01,56.282727272727257,54.053478260869582,52.009999999999991,43.906551724137913,0,2.2292490118576751,4.2727272727272663,12.376175548589345,13,4.1241546031487747E-2,8.215203369981286E-2,0.28187537081818842]
[63.01,60.555454545454531,58.140434782608715,55.926666666666655,47.147931034482738,0,2.4150197628458159,4.6287878787878753,13.407523510971792,14,4.1537696989638093E-2,8.2765309550385205E-2,0.2843714075420592]
[67.009999999999991,64.828181818181804,62.227391304347847,59.84333333333332,50.389310344827564,0,2.6007905138339567,4.9848484848484844,14.43887147335424,15,4.1794946876589356E-2,8.3298309221553263E-2,0.28654632052999279]
[72.009999999999991,69.10090909090907,66.314347826086973,63.759999999999984,53.63068965517239,0,2.7865612648220974,5.3409090909090864,15.470219435736681,16,4.2020488117141826E-2,8.3765826394433626E-2,0.28845833486768635]
[76.009999999999991,73.373636363636336,70.401304347826098,67.676666666666648,56.872068965517215,0,2.9723320158102382,5.6969696969696884,16.501567398119121,17,4.2219842989343989E-2,8.4179230118253803E-2,0.29015240166705353]
[81.009999999999991,77.646363636363603,74.488260869565224,71.59333333333332,60.113448275862041,0,3.158102766798379,6.0530303030302832,17.532915360501562,18,4.2397321805223299E-2,8.454740156947041E-2,0.2916637767982066]
[85.009999999999991,81.919090909090869,78.575217391304349,75.509999999999991,63.354827586206866,0,3.3438735177865198,6.4090909090908781,18.564263322884003,19,4.2556338102560244E-2,8.4877379275471843E-2,0.29302050104427518]
[90.009999999999991,86.191818181818135,82.662173913043475,79.426666666666662,66.596206896551692,0,3.5296442687746605,6.7651515151514729,19.595611285266443,20,4.2699630335002708E-2,8.5174813435682478E-2,0.29424515596970269]
[94.009999999999991,90.464545454545402,86.7491304347826,83.343333333333334,69.837586206896518,0,3.7154150197628013,7.1212121212120678,20.626959247648884,21,4.2829420896109444E-2,8.5444292139488079E-2,0.2953561308167314]
[99.009999999999991,94.737272727272668,90.836086956521726,87.26,73.078965517241343,0,3.9011857707509421,7.4772727272726627,21.658307210031325,22,4.2947532213912148E-2,8.5689579730376608E-2,0.29636855224669995]
[null,99.009999999999962,94.923043478260851,91.176666666666677,76.320344827586169,">4.27",">8.17",">11.75",">25.93",23,">9.0%",">13.5%",">35.5%"]
[null,null,99.01,95.093333333333348,79.561724137930995,null,">8.18",">11.76",">25.93",24,">9.0%",">13.5%",">35.5%"]
[null,null,null,99.01,82.80310344827582,null,null,">11.77",">25.93",25,null,">13.5%",">35.5%"]
[null,null,null,null,86.044482758620646,null,null,null,">25.93",26,null,null,">35.5%"]
[null,null,null,null,89.285862068965471,null,null,null,">25.93",27,null,null,">35.5%"]
[null,null,null,null,92.527241379310297,null,null,null,">25.93",28,null,null,">35.5%"]
[null,null,null,null,95.768620689655123,null,null,null,">25.93",29,null,null,">35.5%"]
[null,null,null,null,99.01,null,null,null,">25.93",30,null,null,">35.5%"]
[]
["Note: all tables other than the 22 point table are linear, they do not zig-zag like the 22 point table"]
["If any of the non-22pt tables are used in the manual method of calculating profiler points each value above will need to be reduced by 0.01 to maintain consistencey with FSANZ \">\" NPSC rules"]
[]
[]
["26 point table","23 point table","24 point table","Profiler points",null,"Current Category 3 foods Na 2700mg","Original HSR Na table","Agressive Na 2000mg (same as NPSC up to 900mg)","Profiler points","Compressed sugar table"]
[0,0,0,0,null,0,0,0,0,0]
[5.01,5.01,5.01,1,null,90.01,90.01,90.01,1,5.01]
[8.77,9.2827272727272714,9.0969565217391306,2,null,180.01,180.01,180.01,2,9.01]
[12.53,13.555454545454545,13.183913043478261,3,null,270.01,270.01,270.01,3,13.51]
[16.29,17.828181818181818,17.270869565217392,4,null,360.01,360.01,360.01,4,18.010000000000002]
[20.049999999999997,22.100909090909092,21.357826086956521,5,null,450.01,450.01,450.01,5,22.51]
[23.809999999999995,26.373636363636365,25.444782608695654,6,null,540.01,540.01,540.01,6,27.01]
[27.569999999999993,30.646363636363638,29.531739130434786,7,null,630.01,630.01,630.01,7,31.01]
[31.329999999999991,34.919090909090912,33.618695652173919,8,null,720.01,720.01,720.01,8,36.01]
[35.089999999999989,39.191818181818185,37.705652173913052,9,null,810.01,810.01,810.01,9,40.01]
[38.849999999999987,43.464545454545458,41.792608695652184,10,null,900.01,900.01,900.01,10,45.01]
[42.609999999999985,47.737272727272732,45.879565217391317,11,null,990.01,1005.01,955.01,11,46.26]
[46.369999999999983,52.010000000000005,49.966521739130449,12,null,1080.01,1121.01,1010.01,12,47.51]
[50.129999999999981,56.282727272727278,54.053478260869582,13,null,1170.01,1251.01,1065.01,13,48.76]
[53.889999999999979,60.555454545454552,58.140434782608715,14,null,1260.01,1397.01,1120.01,14,50.01]
[57.649999999999977,64.828181818181818,62.227391304347847,15,null,1350.01,1559.01,1175.01,15,51.26]
[61.409999999999975,69.100909090909084,66.314347826086973,16,null,1440.01,1740.01,1230.01,16,52.51]
[65.169999999999973,73.373636363636351,70.401304347826098,17,null,1530.01,1942.01,1285.01,17,53.76]
[68.929999999999978,77.646363636363617,74.488260869565224,18,null,1620.01,2168.0100000000002,1340.01,18,55.01]
[72.689999999999984,81.919090909090883,78.575217391304349,19,null,1710.01,2420.0100000000002,1395.01,19,56.26]
[76.449999999999989,86.191818181818149,82.662173913043475,20,null,1800.01,2701.01,1450.01,20,57.51]
[80.209999999999994,90.464545454545416,86.7491304347826,21,null,1890.01,3015.01,1505.01,21,58.76]
[83.97,94.737272727272682,90.836086956521726,22,null,1980.01,3365.01,1560.01,22,60.01]
[87.73,99.009999999999948,94.923043478260851,23,null,2070.0100000000002,3756.01,1615.01,23]
[91.490000000000009,null,99.009999999999977,24,null,2160.0100000000002,4192.01,1670.01,24]
[95.250000000000014,null,null,25,null,2250.0100000000002,4679.01,1725.01,25]
[99.01,null,null,26,null,2340.0100000000002,5223.01,1780.01,26]
[null,null,null,27,null,2430.0100000000002,5829.01,1835.01,27]
[null,null,null,28,null,2520.0100000000002,6506.01,1890.01,28]
[null,null,null,29,null,2610.0100000000002,7262.01,1945.01,29]
[null,null,null,30,null,2700.01,8106.01,2000.01,30]

{"sheet":"Points Table C","index":4,"n_rows":62,"n_cols":6,"rows_kept":62,"cut":false,"hidden":true,"merged":[]}
["Original NPSC profiler points table C, all per 100g",null,"Extended FoPL Profiler points table C, all per 100g"]
["Conc FVNL%","FVNL%","% Foods Fibre","%Foods Protein","NPSC/HSR Points","NPSC Points"]
[0,0,0,0,0,0]
[25,40.01,0.91,1.61,1,1]
[43,60.01,1.91,3.2,2,2]
[52,67.009999999999991,2.81,4.8099999999999996,3,2]
[63,75.009999999999991,3.71,6.41,4,2]
[67,80.009999999999991,4.71,8.01,5,5]
[80,90.009999999999991,5.41,9.61,6,5]
[90,95.009999999999991,6.31,11.61,7,5]
[99.5,99.51,7.31,13.91,8,5]
[100,100,8.41,16.71,9,8]
[null,null,9.7099999999999991,20.010000000000002,10]
[null,null,11.209999999999999,24.01,11]
[null,null,13.01,28.91,12]
[null,null,15.01,34.71,13]
[null,null,17.310000000000002,41.61,14]
[null,null,20.010000000000002,50.01,15]
[]
[]
["Red typeface refers to interpolated values"]
[]
["Note: All values have been inflated by 0.01 (one reportable increment) to match the 'greater than' requirements of the tables provided by FSANZ"]
[]
[]
["Original",null,"Proposal 1"]
["% Foods Fibre","NPSC/HSR Points","% Foods Fibre","NPSC/HSR Points"]
[0,0,0,0]
[0.91,1,3.71,1]
[1.91,2,4.71,2]
[2.81,3,5.41,3]
[3.71,4,6.31,4]
[4.71,5,7.31,5]
[5.41,6,8.41,6]
[6.31,7,9.7099999999999991,7]
[7.31,8,11.209999999999999,8]
[8.41,9,13.01,9]
[9.7099999999999991,10,15.01,10]
[11.209999999999999,11,17.310000000000002,11]
[13.01,12,20.010000000000002,12]
[15.01,13,22.91,13]
[17.310000000000002,14,26.01,14]
[20.010000000000002,15,30.01,15]
[]
["New HSRAC option",null,"Proposal 2"]
["% Foods Fibre","NPSC/HSR Points","% Foods Fibre","NPSC/HSR Points"]
[0,0,0,0]
[3.71,1,3.71,1]
[4.71,2,{"$f":"C48+(1/14*($C$62-$C$48))","v":4.8742857142857146},2]
[5.41,3,{"$f":"C49+(1/14*($C$62-$C$48))","v":6.0385714285714291},3]
[6.31,4,7.2028571428571437,4]
[7.31,5,8.3671428571428574,5]
[8.41,6,9.531428571428572,6]
[9.7099999999999991,7,10.695714285714287,7]
[11.209999999999999,8,11.860000000000001,8]
[13.01,9,13.024285714285716,9]
[15.01,10,14.18857142857143,10]
[17.310000000000002,11,15.352857142857145,11]
[20.010000000000002,12,16.517142857142858,12]
[null,13,17.681428571428572,13]
[null,14,18.845714285714287,14]
[null,15,20.010000000000002,15]

{"sheet":"Draft calculator","index":5,"n_rows":5,"n_cols":28,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["HSR Category (select from drop down)","Product","Company","Energy (kj/100g)","Saturated fat (g/100g)","Total sugars (g/100g)","Sodium (mg/100g)","Fibre (g/100g)","Protein (g/100g)","Concentrated FVNL (%)","FVNL (%)","Wholegrain (%)","Adjusted fibre","HSR Profiler Score (Live)","HSR Star Points (Live)","Health Star Rating (live)","NPSC Category","All FVNL concentrated?","Total FVNL %","HSR Energy Points","HSR Sat Fat Points","HSR Tot Sug Points","HSR Na Points","HSR Total A points","HSR FVNL Points","HSR Fibre Points","HSR Protein Points","HSR Total C Points"]
[null,"Enter product name","Enter company name",0,0,0,0,0,0,0,0,0,{"$f":"H2+(L2*0.2*H2/100)","v":0},{"$f":"$X2-$AB2","v":{"$error":"#N/A"}},{"$f":"IF(ROUND(10.499-(((N2-VLOOKUP($A2,Lookups!$A$55:$D$64,3))/(VLOOKUP($A2,Lookups!$A$55:$D$64,4))*VLOOKUP($A2,Lookups!$C$2:$D$11,2))),0)<1,1,IF(ROUND(10.499-(((N2-VLOOKUP($A2,Lookups!$A$55:$D$64,3))/(VLOOKUP($A2,Lookups!$A$55:$D$64,4))*VLOOKUP($A2,Lookups!$C$2:$D$11,2))),0)<11,ROUND(10.499-(((N2-VLOOKUP($A2,Lookups!$A$55:$D$64,3))/(VLOOKUP($A2,Lookups!$A$55:$D$64,4))*VLOOKUP($A2,Lookups!$C$2:$D$11,2))),0),10))","v":{"$error":"#N/A"}},{"$f":"IF((SUM(D2:L2)=0),\"J\",VLOOKUP(O2,Lookups!$A$1:$B$11,2))","v":"J"},{"$f":"VLOOKUP(A2,Lookups!$A$126:$C$135,3)","v":{"$error":"#N/A"}},{"$f":"IF(AND(J2>0,K2=0),\"Yes\",\"No\")","v":"No"},{"$f":"ROUND(100*(K2+2*J2)/(K2+2*J2+(100-J2-K2)),2)","v":0},{"$f":"IF($Q2<>3,VLOOKUP($D2,'Points Table A'!$B$3:$F$33,5),VLOOKUP($D2,'Points Table A'!$H$3:$L$33,5))","v":{"$error":"#N/A"}},{"$f":"IF($Q2<>3,VLOOKUP($E2,'Points Table A'!$C$3:$F$33,4),VLOOKUP($E2,'Points Table A'!$I$3:$L$33,4))","v":{"$error":"#N/A"}},{"$f":"IF($Q2<>3,VLOOKUP($F2,'Points Table A'!$D$3:$F$33,3),VLOOKUP($F2,'Points Table A'!$J$3:$L$33,3))","v":{"$error":"#N/A"}},{"$f":"IF($Q2<>3,VLOOKUP($G2,'Points Table A'!$E$3:$F$33,2),VLOOKUP($G2,'Points Table A'!$K$3:$L$33,2))","v":{"$error":"#N/A"}},{"$f":"SUM(T2:W2)","v":{"$error":"#N/A"}},{"$f":"IF($R2=Lookups!$B$113,VLOOKUP($J2,'Points Table C'!$A$3:$F$11,5),VLOOKUP($S2,'Points Table C'!$B$3:$F$11,4))","v":0},{"$f":"IF($Q2=1,0,VLOOKUP($M2,'Points Table C'!$C$3:$E$18,3))","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($I2,'Points Table C'!$D$3:$E$18,2)","v":0},{"$f":"IF($X2<Lookups!$C$106,(Y2+Z2+AA2),IF(Y2>=Lookups!$C$120,(Y2+Z2+AA2),Y2+Z2))","v":{"$error":"#N/A"}}]
[null,"Enter product name","Enter company name",0,0,0,0,0,0,0,0,0,{"$f":"H3+(L3*0.2*H3/100)","v":0},{"$error":"#N/A"},{"$f":"IF(ROUND(10.499-(((N3-VLOOKUP($A3,Lookups!$A$55:$D$64,3))/(VLOOKUP($A3,Lookups!$A$55:$D$64,4))*VLOOKUP($A3,Lookups!$C$2:$D$11,2))),0)<1,1,IF(ROUND(10.499-(((N3-VLOOKUP($A3,Lookups!$A$55:$D$64,3))/(VLOOKUP($A3,Lookups!$A$55:$D$64,4))*VLOOKUP($A3,Lookups!$C$2:$D$11,2))),0)<11,ROUND(10.499-(((N3-VLOOKUP($A3,Lookups!$A$55:$D$64,3))/(VLOOKUP($A3,Lookups!$A$55:$D$64,4))*VLOOKUP($A3,Lookups!$C$2:$D$11,2))),0),10))","v":{"$error":"#N/A"}},{"$f":"IF((SUM(D3:L3)=0),\"J\",VLOOKUP(O3,Lookups!$A$1:$B$11,2))","v":"J"},{"$f":"VLOOKUP(A3,Lookups!$A$126:$C$135,3)","v":{"$error":"#N/A"}},{"$f":"IF(AND(J3>0,K3=0),\"Yes\",\"No\")","v":"No"},{"$f":"ROUND(100*(K3+2*J3)/(K3+2*J3+(100-J3-K3)),2)","v":0},{"$f":"IF($Q3<>3,VLOOKUP($D3,'Points Table A'!$B$3:$F$33,5),VLOOKUP($D3,'Points Table A'!$H$3:$L$33,5))","v":{"$error":"#N/A"}},{"$f":"IF($Q3<>3,VLOOKUP($E3,'Points Table A'!$C$3:$F$33,4),VLOOKUP($E3,'Points Table A'!$I$3:$L$33,4))","v":{"$error":"#N/A"}},{"$f":"IF($Q3<>3,VLOOKUP($F3,'Points Table A'!$D$3:$F$33,3),VLOOKUP($F3,'Points Table A'!$J$3:$L$33,3))","v":{"$error":"#N/A"}},{"$f":"IF($Q3<>3,VLOOKUP($G3,'Points Table A'!$E$3:$F$33,2),VLOOKUP($G3,'Points Table A'!$K$3:$L$33,2))","v":{"$error":"#N/A"}},{"$f":"SUM(T3:W3)","v":{"$error":"#N/A"}},{"$f":"IF($R3=Lookups!$B$113,VLOOKUP($J3,'Points Table C'!$A$3:$F$11,5),VLOOKUP($S3,'Points Table C'!$B$3:$F$11,4))","v":0},{"$f":"IF($Q3=1,0,VLOOKUP($M3,'Points Table C'!$C$3:$E$18,3))","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($I3,'Points Table C'!$D$3:$E$18,2)","v":0},{"$f":"IF($X3<Lookups!$C$106,(Y3+Z3+AA3),IF(Y3>=Lookups!$C$120,(Y3+Z3+AA3),Y3+Z3))","v":{"$error":"#N/A"}}]
[null,"Enter product name","Enter company name",0,0,0,0,0,0,0,0,0,0,{"$error":"#N/A"},{"$f":"IF(ROUND(10.499-(((N4-VLOOKUP($A4,Lookups!$A$55:$D$64,3))/(VLOOKUP($A4,Lookups!$A$55:$D$64,4))*VLOOKUP($A4,Lookups!$C$2:$D$11,2))),0)<1,1,IF(ROUND(10.499-(((N4-VLOOKUP($A4,Lookups!$A$55:$D$64,3))/(VLOOKUP($A4,Lookups!$A$55:$D$64,4))*VLOOKUP($A4,Lookups!$C$2:$D$11,2))),0)<11,ROUND(10.499-(((N4-VLOOKUP($A4,Lookups!$A$55:$D$64,3))/(VLOOKUP($A4,Lookups!$A$55:$D$64,4))*VLOOKUP($A4,Lookups!$C$2:$D$11,2))),0),10))","v":{"$error":"#N/A"}},{"$f":"IF((SUM(D4:L4)=0),\"J\",VLOOKUP(O4,Lookups!$A$1:$B$11,2))","v":"J"},{"$f":"VLOOKUP(A4,Lookups!$A$126:$C$135,3)","v":{"$error":"#N/A"}},"No",0,{"$f":"IF($Q4<>3,VLOOKUP($D4,'Points Table A'!$B$3:$F$33,5),VLOOKUP($D4,'Points Table A'!$H$3:$L$33,5))","v":{"$error":"#N/A"}},{"$f":"IF($Q4<>3,VLOOKUP($E4,'Points Table A'!$C$3:$F$33,4),VLOOKUP($E4,'Points Table A'!$I$3:$L$33,4))","v":{"$error":"#N/A"}},{"$f":"IF($Q4<>3,VLOOKUP($F4,'Points Table A'!$D$3:$F$33,3),VLOOKUP($F4,'Points Table A'!$J$3:$L$33,3))","v":{"$error":"#N/A"}},{"$f":"IF($Q4<>3,VLOOKUP($G4,'Points Table A'!$E$3:$F$33,2),VLOOKUP($G4,'Points Table A'!$K$3:$L$33,2))","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"IF($R4=Lookups!$B$113,VLOOKUP($J4,'Points Table C'!$A$3:$F$11,5),VLOOKUP($S4,'Points Table C'!$B$3:$F$11,4))","v":0},{"$f":"IF($Q4=1,0,VLOOKUP($M4,'Points Table C'!$C$3:$E$18,3))","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($I4,'Points Table C'!$D$3:$E$18,2)","v":0},{"$f":"IF($X4<Lookups!$C$106,(Y4+Z4+AA4),IF(Y4>=Lookups!$C$120,(Y4+Z4+AA4),Y4+Z4))","v":{"$error":"#N/A"}}]
[null,"Enter product name","Enter company name",0,0,0,0,0,0,0,0,0,0,{"$error":"#N/A"},{"$f":"IF(ROUND(10.499-(((N5-VLOOKUP($A5,Lookups!$A$55:$D$64,3))/(VLOOKUP($A5,Lookups!$A$55:$D$64,4))*VLOOKUP($A5,Lookups!$C$2:$D$11,2))),0)<1,1,IF(ROUND(10.499-(((N5-VLOOKUP($A5,Lookups!$A$55:$D$64,3))/(VLOOKUP($A5,Lookups!$A$55:$D$64,4))*VLOOKUP($A5,Lookups!$C$2:$D$11,2))),0)<11,ROUND(10.499-(((N5-VLOOKUP($A5,Lookups!$A$55:$D$64,3))/(VLOOKUP($A5,Lookups!$A$55:$D$64,4))*VLOOKUP($A5,Lookups!$C$2:$D$11,2))),0),10))","v":{"$error":"#N/A"}},{"$f":"IF((SUM(D5:L5)=0),\"J\",VLOOKUP(O5,Lookups!$A$1:$B$11,2))","v":"J"},{"$f":"VLOOKUP(A5,Lookups!$A$126:$C$135,3)","v":{"$error":"#N/A"}},"No",0,{"$f":"IF($Q5<>3,VLOOKUP($D5,'Points Table A'!$B$3:$F$33,5),VLOOKUP($D5,'Points Table A'!$H$3:$L$33,5))","v":{"$error":"#N/A"}},{"$f":"IF($Q5<>3,VLOOKUP($E5,'Points Table A'!$C$3:$F$33,4),VLOOKUP($E5,'Points Table A'!$I$3:$L$33,4))","v":{"$error":"#N/A"}},{"$f":"IF($Q5<>3,VLOOKUP($F5,'Points Table A'!$D$3:$F$33,3),VLOOKUP($F5,'Points Table A'!$J$3:$L$33,3))","v":{"$error":"#N/A"}},{"$f":"IF($Q5<>3,VLOOKUP($G5,'Points Table A'!$E$3:$F$33,2),VLOOKUP($G5,'Points Table A'!$K$3:$L$33,2))","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"IF($R5=Lookups!$B$113,VLOOKUP($J5,'Points Table C'!$A$3:$F$11,5),VLOOKUP($S5,'Points Table C'!$B$3:$F$11,4))","v":0},{"$f":"IF($Q5=1,0,VLOOKUP($M5,'Points Table C'!$C$3:$E$18,3))","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($I5,'Points Table C'!$D$3:$E$18,2)","v":0},{"$f":"IF($X5<Lookups!$C$106,(Y5+Z5+AA5),IF(Y5>=Lookups!$C$120,(Y5+Z5+AA5),Y5+Z5))","v":{"$error":"#N/A"}}]

{"sheet":"Drop-down, HSR categories","index":6,"n_rows":10,"n_cols":1,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
["Beverages, non-dairy"]
["Core Cereals"]
["Core Dairy - beverages"]
["Core Dairy - cheese"]
["Core Dairy - yoghurt, soft cheese"]
["Fats, oils"]
["Fruit"]
["Non-core foods"]
["Protein"]
["Vegetables"]