{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Intervention description","Calc-benefits Aus Pop  ","Calc-costs Aus pop ","Intervention costs inputs"],"not_rendered":{"images":3,"defined_names":52,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Intervention description","index":0,"n_rows":17,"n_cols":30,"rows_kept":17}
["Intervention description"]
["Change the names of the scenarios in cells A4 to A9 as required"]
["Scenario name","Scenario description"]
["20% tax total pop","20% tax "]
[]
[]
[]
[]
[]
[]
["Scenario for analysis",{"$nulls":18},"Controls",null,1,null,"Change in BMI.  ",{"$nulls":3},"Scenarios ",null,1]
[{"$nulls":23},"Change in Weight.  "]
[{"$nulls":20},1,"BMI (kg/m2)",{"$nulls":6},1,{"$f":"A4","v":"20% tax total pop"}]
[{"$nulls":20},2,"Weight (kg)",{"$nulls":6},2,{"$f":"A5","v":0}]
["Intervention Major Assumptions",{"$nulls":27},3,{"$f":"A6","v":0}]
[{"$nulls":28},4,{"$f":"A7","v":0}]
["Benfits of Intervention",{"$nulls":27},5,{"$f":"A8","v":0}]

{"sheet":"Calc-benefits Aus Pop  ","index":1,"n_rows":242,"n_cols":22,"rows_kept":242,"merged":[[1,0,33,0],[35,0,70,0],[72,0,99,0],[102,0,130,0],[146,0,146,4],[166,0,166,3],[168,10,177,10],[168,13,177,13],[205,4,205,5],[205,6,205,15]]}
["Whole of population calculation of effect size using direct and indirect effects (own and cross price elasticities)"]
["Consumption SSBs","Consumption of SSB","Males 2-9","10-14 yrs","15-19"," 20-24"," 25-34","35-44"," 45-54"," 55-64"," 65-74","75+","Females 2-9","10-14 yrs","15-19"," 20-24"," 25-34","35-44"," 45-54"," 55-64"," 65-74","75+"]
[null,"Mean intake carbonated drinks (g/day)",{"v":41.91572,"d":"41.9"},{"v":143.3468,"d":"143.3"},{"v":293.6017,"d":"293.6"},{"v":201.6575,"d":"201.7"},{"v":219.2039,"d":"219.2"},{"v":131.9031,"d":"131.9"},{"v":125.9065,"d":"125.9"},{"v":85.8689,"d":"85.9"},{"v":44.66946,"d":"44.7"},{"v":35.67866,"d":"35.7"},{"v":45.55673,"d":"45.6"},{"v":120.2773,"d":"120.3"},{"v":155.0059,"d":"155.0"},{"v":118.0174,"d":"118.0"},{"v":91.41971,"d":"91.42"},{"v":74.19511,"d":"74.20"},{"v":67.47028,"d":"67.47"},{"v":38.36585,"d":"38.37"},{"v":34.55788,"d":"34.56"},{"v":29.18351,"d":"29.18"}]
[null,"Relative standard error of estimate (%)",{"v":5.074562,"d":"5.1"},{"v":16.72333,"d":"16.7"},{"v":31.88381,"d":"31.9"},{"v":24.22157,"d":"24.2"},{"v":22.14553,"d":"22.1"},{"v":10.02002,"d":"10.0"},{"v":12.23295,"d":"12.2"},{"v":10.2253,"d":"10.2"},{"v":6.639619,"d":"6.6"},{"v":7.130782,"d":"7.1"},{"v":5.37504,"d":"5.4"},{"v":13.95712,"d":"14.0"},{"v":18.84774,"d":"18.8"},{"v":14.79486,"d":"14.8"},{"v":8.140944,"d":"8.14"},{"v":8.690117,"d":"8.69"},{"v":10.38529,"d":"10.39"},{"v":5.076492,"d":"5.08"},{"v":6.256783,"d":"6.26"},{"v":4.871578,"d":"4.87"}]
[null,"Lower 95% confidence interval of the mean",{"v":31.76154,"d":"31.8"},{"v":109.8835,"d":"109.9"},{"v":229.8024,"d":"229.8"},{"v":153.1902,"d":"153.2"},{"v":174.8907,"d":"174.9"},{"v":111.8531,"d":"111.9"},{"v":101.4284,"d":"101.4"},{"v":65.40812,"d":"65.4"},{"v":31.38362,"d":"31.4"},{"v":21.41,"d":"21.4"},{"v":34.8013,"d":"34.8"},{"v":92.34916,"d":"92.3"},{"v":117.2917,"d":"117.3"},{"v":88.41299,"d":"88.4"},{"v":75.12972,"d":"75.13"},{"v":56.80623,"d":"56.81"},{"v":46.68935,"d":"46.69"},{"v":28.20782,"d":"28.21"},{"v":22.03809,"d":"22.04"},{"v":19.43551,"d":"19.44"}]
[null,"Upper 95% confidence interval of the mean",{"v":52.06989,"d":"52.1"},{"v":176.8101,"d":"176.8"},{"v":357.4011,"d":"357.4"},{"v":250.1247,"d":"250.1"},{"v":263.517,"d":"263.5"},{"v":151.9531,"d":"152.0"},{"v":150.3845,"d":"150.4"},{"v":106.3297,"d":"106.3"},{"v":57.95531,"d":"58.0"},{"v":49.94732,"d":"49.9"},{"v":56.31216,"d":"56.3"},{"v":148.2054,"d":"148.2"},{"v":192.7202,"d":"192.7"},{"v":147.6219,"d":"147.6"},{"v":107.7097,"d":"107.71"},{"v":91.584,"d":"91.58"},{"v":88.25121,"d":"88.25"},{"v":48.52389,"d":"48.52"},{"v":47.07768,"d":"47.08"},{"v":38.93152,"d":"38.93"}]
[null,"Ersatz",{"$f":"_xll.ErLognormal(C3,C4)","v":{"v":41.91572,"d":"41.9"}},{"$f":"_xll.ErLognormal(D3,D4)","v":{"v":143.3468,"d":"143.3"}},{"$f":"_xll.ErLognormal(E3,E4)","v":{"v":293.6017,"d":"293.6"}},{"$f":"_xll.ErLognormal(F3,F4)","v":{"v":201.6575,"d":"201.7"}},{"$f":"_xll.ErLognormal(G3,G4)","v":{"v":219.2039,"d":"219.2"}},{"$f":"_xll.ErLognormal(H3,H4)","v":{"v":131.9031,"d":"131.9"}},{"$f":"_xll.ErLognormal(I3,I4)","v":{"v":125.9065,"d":"125.9"}},{"$f":"_xll.ErLognormal(J3,J4)","v":{"v":85.8689,"d":"85.9"}},{"$f":"_xll.ErLognormal(K3,K4)","v":{"v":44.66946,"d":"44.7"}},{"$f":"_xll.ErLognormal(L3,L4)","v":{"v":35.67866,"d":"35.7"}},{"$f":"_xll.ErLognormal(M3,M4)","v":{"v":45.55673,"d":"45.6"}},{"$f":"_xll.ErLognormal(N3,N4)","v":{"v":120.2773,"d":"120.3"}},{"$f":"_xll.ErLognormal(O3,O4)","v":{"v":155.0059,"d":"155.0"}},{"$f":"_xll.ErLognormal(P3,P4)","v":{"v":118.0174,"d":"118.0"}},{"$f":"_xll.ErLognormal(Q3,Q4)","v":{"v":91.41971,"d":"91.42"}},{"$f":"_xll.ErLognormal(R3,R4)","v":{"v":74.19511,"d":"74.20"}},{"$f":"_xll.ErLognormal(S3,S4)","v":{"v":67.47028,"d":"67.47"}},{"$f":"_xll.ErLognormal(T3,T4)","v":{"v":38.36585,"d":"38.37"}},{"$f":"_xll.ErLognormal(U3,U4)","v":{"v":34.55788,"d":"34.56"}},{"$f":"_xll.ErLognormal(V3,V4)","v":{"v":29.18351,"d":"29.18"}}]
[]
[null,"Mean intake sports drinks (g/day)",{"v":12.00146,"d":"12.0"},{"v":12.00146,"d":"12.0"},{"v":12.00146,"d":"12.0"},{"v":12.00146,"d":"12.0"},{"v":12.00146,"d":"12.0"},{"v":12.00146,"d":"12.0"},{"v":12.00146,"d":"12.0"},{"v":12.00146,"d":"12.0"},{"v":12.00146,"d":"12.0"},{"v":12.00146,"d":"12.0"},{"v":3.40252,"d":"3.4"},{"v":3.40252,"d":"3.4"},{"v":3.40252,"d":"3.4"},{"v":3.40252,"d":"3.4"},{"v":3.40252,"d":"3.40"},{"v":3.40252,"d":"3.40"},{"v":3.40252,"d":"3.40"},{"v":3.40252,"d":"3.40"},{"v":3.40252,"d":"3.40"},{"v":3.40252,"d":"3.40"}]
[null,"Relative standard error of estimate (%)",{"v":1.421353,"d":"1.4"},{"v":1.421353,"d":"1.4"},{"v":1.421353,"d":"1.4"},{"v":1.421353,"d":"1.4"},{"v":1.421353,"d":"1.4"},{"v":1.421353,"d":"1.4"},{"v":1.421353,"d":"1.4"},{"v":1.421353,"d":"1.4"},{"v":1.421353,"d":"1.4"},{"v":1.421353,"d":"1.4"},{"v":0.7402483,"d":"0.7"},{"v":0.7402483,"d":"0.7"},{"v":0.7402483,"d":"0.7"},{"v":0.7402483,"d":"0.7"},{"v":0.7402483,"d":"0.74"},{"v":0.7402483,"d":"0.74"},{"v":0.7402483,"d":"0.74"},{"v":0.7402483,"d":"0.74"},{"v":0.7402483,"d":"0.74"},{"v":0.7402483,"d":"0.74"}]
[null,"Lower 95% confidence interval of the mean",{"v":9.157339,"d":"9.2"},{"v":9.157339,"d":"9.2"},{"v":9.157339,"d":"9.2"},{"v":9.157339,"d":"9.2"},{"v":9.157339,"d":"9.2"},{"v":9.157339,"d":"9.2"},{"v":9.157339,"d":"9.2"},{"v":9.157339,"d":"9.2"},{"v":9.157339,"d":"9.2"},{"v":9.157339,"d":"9.2"},{"v":1.921286,"d":"1.9"},{"v":1.921286,"d":"1.9"},{"v":1.921286,"d":"1.9"},{"v":1.921286,"d":"1.9"},{"v":1.921286,"d":"1.92"},{"v":1.921286,"d":"1.92"},{"v":1.921286,"d":"1.92"},{"v":1.921286,"d":"1.92"},{"v":1.921286,"d":"1.92"},{"v":1.921286,"d":"1.92"}]
[null,"Upper 95% confidence interval of the mean",{"v":14.84558,"d":"14.8"},{"v":14.84558,"d":"14.8"},{"v":14.84558,"d":"14.8"},{"v":14.84558,"d":"14.8"},{"v":14.84558,"d":"14.8"},{"v":14.84558,"d":"14.8"},{"v":14.84558,"d":"14.8"},{"v":14.84558,"d":"14.8"},{"v":14.84558,"d":"14.8"},{"v":14.84558,"d":"14.8"},{"v":4.883753,"d":"4.9"},{"v":4.883753,"d":"4.9"},{"v":4.883753,"d":"4.9"},{"v":4.883753,"d":"4.9"},{"v":4.883753,"d":"4.88"},{"v":4.883753,"d":"4.88"},{"v":4.883753,"d":"4.88"},{"v":4.883753,"d":"4.88"},{"v":4.883753,"d":"4.88"},{"v":4.883753,"d":"4.88"}]
[null,"Ersatz",{"$f":"_xll.ErLognormal(C9,C10)","v":{"v":12.00146,"d":"12.0"}},{"$f":"_xll.ErLognormal(D9,D10)","v":{"v":12.00146,"d":"12.0"}},{"$f":"_xll.ErLognormal(E9,E10)","v":{"v":12.00146,"d":"12.0"}},{"$f":"_xll.ErLognormal(F9,F10)","v":{"v":12.00146,"d":"12.0"}},{"$f":"_xll.ErLognormal(G9,G10)","v":{"v":12.00146,"d":"12.0"}},{"$f":"_xll.ErLognormal(H9,H10)","v":{"v":12.00146,"d":"12.0"}},{"$f":"_xll.ErLognormal(I9,I10)","v":{"v":12.00146,"d":"12.0"}},{"$f":"_xll.ErLognormal(J9,J10)","v":{"v":12.00146,"d":"12.0"}},{"$f":"_xll.ErLognormal(K9,K10)","v":{"v":12.00146,"d":"12.0"}},{"$f":"_xll.ErLognormal(L9,L10)","v":{"v":12.00146,"d":"12.0"}},{"$f":"_xll.ErLognormal(M9,M10)","v":{"v":3.40252,"d":"3.4"}},{"$f":"_xll.ErLognormal(N9,N10)","v":{"v":3.40252,"d":"3.4"}},{"$f":"_xll.ErLognormal(O9,O10)","v":{"v":3.40252,"d":"3.4"}},{"$f":"_xll.ErLognormal(P9,P10)","v":{"v":3.40252,"d":"3.4"}},{"$f":"_xll.ErLognormal(Q9,Q10)","v":{"v":3.40252,"d":"3.40"}},{"$f":"_xll.ErLognormal(R9,R10)","v":{"v":3.40252,"d":"3.40"}},{"$f":"_xll.ErLognormal(S9,S10)","v":{"v":3.40252,"d":"3.40"}},{"$f":"_xll.ErLognormal(T9,T10)","v":{"v":3.40252,"d":"3.40"}},{"$f":"_xll.ErLognormal(U9,U10)","v":{"v":3.40252,"d":"3.40"}},{"$f":"_xll.ErLognormal(V9,V10)","v":{"v":3.40252,"d":"3.40"}}]
[]
[null,"Mean intake energy drinks (g/day)",{"v":7.317772,"d":"7.3"},{"v":7.317772,"d":"7.3"},{"v":7.317772,"d":"7.3"},{"v":7.317772,"d":"7.3"},{"v":7.317772,"d":"7.3"},{"v":7.317772,"d":"7.3"},{"v":7.317772,"d":"7.3"},{"v":7.317772,"d":"7.3"},{"v":7.317772,"d":"7.3"},{"v":7.317772,"d":"7.3"},{"v":1.99523,"d":"2.0"},{"v":1.99523,"d":"2.0"},{"v":1.99523,"d":"2.0"},{"v":1.99523,"d":"2.0"},{"v":1.99523,"d":"2.00"},{"v":1.99523,"d":"2.00"},{"v":1.99523,"d":"2.00"},{"v":1.99523,"d":"2.00"},{"v":1.99523,"d":"2.00"},{"v":1.99523,"d":"2.00"}]
[null,"Relative standard error of estimate (%)",{"v":0.954372,"d":"1.0"},{"v":0.954372,"d":"1.0"},{"v":0.954372,"d":"1.0"},{"v":0.954372,"d":"1.0"},{"v":0.954372,"d":"1.0"},{"v":0.954372,"d":"1.0"},{"v":0.954372,"d":"1.0"},{"v":0.954372,"d":"1.0"},{"v":0.954372,"d":"1.0"},{"v":0.954372,"d":"1.0"},{"v":0.4239212,"d":"0.4"},{"v":0.4239212,"d":"0.4"},{"v":0.4239212,"d":"0.4"},{"v":0.4239212,"d":"0.4"},{"v":0.4239212,"d":"0.42"},{"v":0.4239212,"d":"0.42"},{"v":0.4239212,"d":"0.42"},{"v":0.4239212,"d":"0.42"},{"v":0.4239212,"d":"0.42"},{"v":0.4239212,"d":"0.42"}]
[null,"Lower 95% confidence interval of the mean",{"v":5.408078,"d":"5.4"},{"v":5.408078,"d":"5.4"},{"v":5.408078,"d":"5.4"},{"v":5.408078,"d":"5.4"},{"v":5.408078,"d":"5.4"},{"v":5.408078,"d":"5.4"},{"v":5.408078,"d":"5.4"},{"v":5.408078,"d":"5.4"},{"v":5.408078,"d":"5.4"},{"v":5.408078,"d":"5.4"},{"v":1.146966,"d":"1.1"},{"v":1.146966,"d":"1.1"},{"v":1.146966,"d":"1.1"},{"v":1.146966,"d":"1.1"},{"v":1.146966,"d":"1.15"},{"v":1.146966,"d":"1.15"},{"v":1.146966,"d":"1.15"},{"v":1.146966,"d":"1.15"},{"v":1.146966,"d":"1.15"},{"v":1.146966,"d":"1.15"}]
[null,"Upper 95% confidence interval of the mean",{"v":9.227466,"d":"9.2"},{"v":9.227466,"d":"9.2"},{"v":9.227466,"d":"9.2"},{"v":9.227466,"d":"9.2"},{"v":9.227466,"d":"9.2"},{"v":9.227466,"d":"9.2"},{"v":9.227466,"d":"9.2"},{"v":9.227466,"d":"9.2"},{"v":9.227466,"d":"9.2"},{"v":9.227466,"d":"9.2"},{"v":2.843495,"d":"2.8"},{"v":2.843495,"d":"2.8"},{"v":2.843495,"d":"2.8"},{"v":2.843495,"d":"2.8"},{"v":2.843495,"d":"2.84"},{"v":2.843495,"d":"2.84"},{"v":2.843495,"d":"2.84"},{"v":2.843495,"d":"2.84"},{"v":2.843495,"d":"2.84"},{"v":2.843495,"d":"2.84"}]
[null,"Ersatz",{"$f":"_xll.ErLognormal(C15,C16)","v":{"v":7.317772,"d":"7.3"}},{"$f":"_xll.ErLognormal(D15,D16)","v":{"v":7.317772,"d":"7.3"}},{"$f":"_xll.ErLognormal(E15,E16)","v":{"v":7.317772,"d":"7.3"}},{"$f":"_xll.ErLognormal(F15,F16)","v":{"v":7.317772,"d":"7.3"}},{"$f":"_xll.ErLognormal(G15,G16)","v":{"v":7.317772,"d":"7.3"}},{"$f":"_xll.ErLognormal(H15,H16)","v":{"v":7.317772,"d":"7.3"}},{"$f":"_xll.ErLognormal(I15,I16)","v":{"v":7.317772,"d":"7.3"}},{"$f":"_xll.ErLognormal(J15,J16)","v":{"v":7.317772,"d":"7.3"}},{"$f":"_xll.ErLognormal(K15,K16)","v":{"v":7.317772,"d":"7.3"}},{"$f":"_xll.ErLognormal(L15,L16)","v":{"v":7.317772,"d":"7.3"}},{"$f":"_xll.ErLognormal(M15,M16)","v":{"v":1.99523,"d":"2.0"}},{"$f":"_xll.ErLognormal(N15,N16)","v":{"v":1.99523,"d":"2.0"}},{"$f":"_xll.ErLognormal(O15,O16)","v":{"v":1.99523,"d":"2.0"}},{"$f":"_xll.ErLognormal(P15,P16)","v":{"v":1.99523,"d":"2.0"}},{"$f":"_xll.ErLognormal(Q15,Q16)","v":{"v":1.99523,"d":"2.00"}},{"$f":"_xll.ErLognormal(R15,R16)","v":{"v":1.99523,"d":"2.00"}},{"$f":"_xll.ErLognormal(S15,S16)","v":{"v":1.99523,"d":"2.00"}},{"$f":"_xll.ErLognormal(T15,T16)","v":{"v":1.99523,"d":"2.00"}},{"$f":"_xll.ErLognormal(U15,U16)","v":{"v":1.99523,"d":"2.00"}},{"$f":"_xll.ErLognormal(V15,V16)","v":{"v":1.99523,"d":"2.00"}}]
[]
[null,"Mean intake fruit drink (g/day)",{"v":59.93003,"d":"59.9"},{"v":56.18708,"d":"56.2"},{"v":46.9881,"d":"47.0"},{"v":91.56171,"d":"91.6"},{"v":48.79162,"d":"48.8"},{"v":42.65799,"d":"42.7"},{"v":20.58244,"d":"20.6"},{"v":25.27242,"d":"25.3"},{"v":19.18552,"d":"19.2"},{"v":19.8552,"d":"19.9"},{"v":59.28377,"d":"59.3"},{"v":57.64484,"d":"57.6"},{"v":44.18925,"d":"44.2"},{"v":53.81237,"d":"53.8"},{"v":36.6346,"d":"36.63"},{"v":18.62869,"d":"18.63"},{"v":11.07481,"d":"11.07"},{"v":22.41615,"d":"22.42"},{"v":23.76684,"d":"23.77"},{"v":30.40405,"d":"30.40"}]
[null,"Relative standard error of estimate (%)",{"v":8.891251,"d":"8.9"},{"v":13.53439,"d":"13.5"},{"v":10.44624,"d":"10.4"},{"v":22.7314,"d":"22.7"},{"v":8.146874,"d":"8.1"},{"v":7.703955,"d":"7.7"},{"v":3.28817,"d":"3.3"},{"v":5.247515,"d":"5.2"},{"v":3.918888,"d":"3.9"},{"v":4.575848,"d":"4.6"},{"v":6.870686,"d":"6.9"},{"v":11.03936,"d":"11.0"},{"v":7.922936,"d":"7.9"},{"v":11.04223,"d":"11.0"},{"v":4.795748,"d":"4.80"},{"v":3.421297,"d":"3.42"},{"v":2.407269,"d":"2.41"},{"v":5.408232,"d":"5.41"},{"v":4.215995,"d":"4.22"},{"v":11.24131,"d":"11.24"}]
[null,"Lower 95% confidence interval of the mean",{"v":42.13868,"d":"42.1"},{"v":29.10483,"d":"29.1"},{"v":26.08523,"d":"26.1"},{"v":46.07628,"d":"46.1"},{"v":32.48977,"d":"32.5"},{"v":27.24241,"d":"27.2"},{"v":14.00283,"d":"14.0"},{"v":14.77217,"d":"14.8"},{"v":11.34384,"d":"11.3"},{"v":10.69895,"d":"10.7"},{"v":45.53555,"d":"45.5"},{"v":35.55513,"d":"35.6"},{"v":28.3355,"d":"28.3"},{"v":31.71692,"d":"31.7"},{"v":27.03833,"d":"27.04"},{"v":11.78269,"d":"11.78"},{"v":6.257877,"d":"6.26"},{"v":11.5943,"d":"11.59"},{"v":15.33066,"d":"15.33"},{"v":7.910233,"d":"7.91"}]
[null,"Upper 95% confidence interval of the mean",{"v":77.72139,"d":"77.7"},{"v":83.26932,"d":"83.3"},{"v":67.89097,"d":"67.9"},{"v":137.0471,"d":"137.0"},{"v":65.09348,"d":"65.1"},{"v":58.07357,"d":"58.1"},{"v":27.16205,"d":"27.2"},{"v":35.77268,"d":"35.8"},{"v":27.02719,"d":"27.0"},{"v":29.01145,"d":"29.0"},{"v":73.03198,"d":"73.0"},{"v":79.73455,"d":"79.7"},{"v":60.04301,"d":"60.0"},{"v":75.90781,"d":"75.9"},{"v":46.23087,"d":"46.23"},{"v":25.47469,"d":"25.47"},{"v":15.89175,"d":"15.89"},{"v":33.238,"d":"33.24"},{"v":32.20303,"d":"32.20"},{"v":52.89787,"d":"52.90"}]
[null,"Ersatz",{"$f":"_xll.ErLognormal(C21,C22)","v":{"v":59.93003,"d":"59.9"}},{"$f":"_xll.ErLognormal(D21,D22)","v":{"v":56.18708,"d":"56.2"}},{"$f":"_xll.ErLognormal(E21,E22)","v":{"v":46.9881,"d":"47.0"}},{"$f":"_xll.ErLognormal(F21,F22)","v":{"v":91.56171,"d":"91.6"}},{"$f":"_xll.ErLognormal(G21,G22)","v":{"v":48.79162,"d":"48.8"}},{"$f":"_xll.ErLognormal(H21,H22)","v":{"v":42.65799,"d":"42.7"}},{"$f":"_xll.ErLognormal(I21,I22)","v":{"v":20.58244,"d":"20.6"}},{"$f":"_xll.ErLognormal(J21,J22)","v":{"v":25.27242,"d":"25.3"}},{"$f":"_xll.ErLognormal(K21,K22)","v":{"v":19.18552,"d":"19.2"}},{"$f":"_xll.ErLognormal(L21,L22)","v":{"v":19.8552,"d":"19.9"}},{"$f":"_xll.ErLognormal(M21,M22)","v":{"v":59.28377,"d":"59.3"}},{"$f":"_xll.ErLognormal(N21,N22)","v":{"v":57.64484,"d":"57.6"}},{"$f":"_xll.ErLognormal(O21,O22)","v":{"v":44.18925,"d":"44.2"}},{"$f":"_xll.ErLognormal(P21,P22)","v":{"v":53.81237,"d":"53.8"}},{"$f":"_xll.ErLognormal(Q21,Q22)","v":{"v":36.6346,"d":"36.63"}},{"$f":"_xll.ErLognormal(R21,R22)","v":{"v":18.62869,"d":"18.63"}},{"$f":"_xll.ErLognormal(S21,S22)","v":{"v":11.07481,"d":"11.07"}},{"$f":"_xll.ErLognormal(T21,T22)","v":{"v":22.41615,"d":"22.42"}},{"$f":"_xll.ErLognormal(U21,U22)","v":{"v":23.76684,"d":"23.77"}},{"$f":"_xll.ErLognormal(V21,V22)","v":{"v":30.40405,"d":"30.40"}}]
[]
[null,"Mean intake cordial diluted (g/day)",{"v":51.80318,"d":"51.8"},{"v":75.96415,"d":"76.0"},{"v":40.18575,"d":"40.2"},{"v":55.87547,"d":"55.9"},{"v":42.33235,"d":"42.3"},{"v":41.39289,"d":"41.4"},{"v":55.03871,"d":"55.0"},{"v":12.43138,"d":"12.4"},{"v":16.71469,"d":"16.7"},{"v":30.6327,"d":"30.6"},{"v":36.88208,"d":"36.9"},{"v":33.96987,"d":"34.0"},{"v":31.88075,"d":"31.9"},{"v":17.36636,"d":"17.4"},{"v":29.82471,"d":"29.82"},{"v":21.80878,"d":"21.81"},{"v":13.7206,"d":"13.72"},{"v":15.85612,"d":"15.86"},{"v":14.26769,"d":"14.27"},{"v":5.23377,"d":"5.23"}]
[null,"Relative standard error of estimate (%)",{"v":8.186783,"d":"8.2"},{"v":15.14424,"d":"15.1"},{"v":9.196217,"d":"9.2"},{"v":18.49109,"d":"18.5"},{"v":11.49745,"d":"11.5"},{"v":9.597655,"d":"9.6"},{"v":12.48298,"d":"12.5"},{"v":2.91933,"d":"2.9"},{"v":4.354729,"d":"4.4"},{"v":8.65441,"d":"8.7"},{"v":6.75313,"d":"6.8"},{"v":8.381312,"d":"8.4"},{"v":11.76616,"d":"11.8"},{"v":4.93893,"d":"4.9"},{"v":5.741979,"d":"5.74"},{"v":3.965681,"d":"3.97"},{"v":2.793595,"d":"2.79"},{"v":4.194956,"d":"4.19"},{"v":4.108434,"d":"4.11"},{"v":1.56709,"d":"1.57"}]
[null,"Lower 95% confidence interval of the mean",{"v":35.42146,"d":"35.4"},{"v":45.66059,"d":"45.7"},{"v":21.78416,"d":"21.8"},{"v":18.87487,"d":"18.9"},{"v":19.326,"d":"19.3"},{"v":22.18803,"d":"22.2"},{"v":30.06032,"d":"30.1"},{"v":6.58981,"d":"6.6"},{"v":8.000894,"d":"8.0"},{"v":13.31527,"d":"13.3"},{"v":23.3691,"d":"23.4"},{"v":17.19891,"d":"17.2"},{"v":8.336721,"d":"8.3"},{"v":7.483579,"d":"7.5"},{"v":18.33504,"d":"18.34"},{"v":13.87347,"d":"13.87"},{"v":8.130634,"d":"8.13"},{"v":7.46203,"d":"7.46"},{"v":6.046728,"d":"6.05"},{"v":2.09803,"d":"2.10"}]
[null,"Upper 95% confidence interval of the mean",{"v":68.18489,"d":"68.2"},{"v":106.2677,"d":"106.3"},{"v":58.58734,"d":"58.6"},{"v":92.87606,"d":"92.9"},{"v":65.3387,"d":"65.3"},{"v":60.59775,"d":"60.6"},{"v":80.0171,"d":"80.0"},{"v":18.27294,"d":"18.3"},{"v":25.42848,"d":"25.4"},{"v":47.95014,"d":"48.0"},{"v":50.39506,"d":"50.4"},{"v":50.74084,"d":"50.7"},{"v":55.42479,"d":"55.4"},{"v":27.24913,"d":"27.2"},{"v":41.31438,"d":"41.31"},{"v":29.74409,"d":"29.74"},{"v":19.31057,"d":"19.31"},{"v":24.25021,"d":"24.25"},{"v":22.48864,"d":"22.49"},{"v":8.369509,"d":"8.37"}]
[null,"Ersatz",{"$f":"_xll.ErLognormal(C27,C28)","v":{"v":51.80318,"d":"51.8"}},{"$f":"_xll.ErLognormal(D27,D28)","v":{"v":75.96415,"d":"76.0"}},{"$f":"_xll.ErLognormal(E27,E28)","v":{"v":40.18575,"d":"40.2"}},{"$f":"_xll.ErLognormal(F27,F28)","v":{"v":55.87547,"d":"55.9"}},{"$f":"_xll.ErLognormal(G27,G28)","v":{"v":42.33235,"d":"42.3"}},{"$f":"_xll.ErLognormal(H27,H28)","v":{"v":41.39289,"d":"41.4"}},{"$f":"_xll.ErLognormal(I27,I28)","v":{"v":55.03871,"d":"55.0"}},{"$f":"_xll.ErLognormal(J27,J28)","v":{"v":12.43138,"d":"12.4"}},{"$f":"_xll.ErLognormal(K27,K28)","v":{"v":16.71469,"d":"16.7"}},{"$f":"_xll.ErLognormal(L27,L28)","v":{"v":30.6327,"d":"30.6"}},{"$f":"_xll.ErLognormal(M27,M28)","v":{"v":36.88208,"d":"36.9"}},{"$f":"_xll.ErLognormal(N27,N28)","v":{"v":33.96987,"d":"34.0"}},{"$f":"_xll.ErLognormal(O27,O28)","v":{"v":31.88075,"d":"31.9"}},{"$f":"_xll.ErLognormal(P27,P28)","v":{"v":17.36636,"d":"17.4"}},{"$f":"_xll.ErLognormal(Q27,Q28)","v":{"v":29.82471,"d":"29.82"}},{"$f":"_xll.ErLognormal(R27,R28)","v":{"v":21.80878,"d":"21.81"}},{"$f":"_xll.ErLognormal(S27,S28)","v":{"v":13.7206,"d":"13.72"}},{"$f":"_xll.ErLognormal(T27,T28)","v":{"v":15.85612,"d":"15.86"}},{"$f":"_xll.ErLognormal(U27,U28)","v":{"v":14.26769,"d":"14.27"}},{"$f":"_xll.ErLognormal(V27,V28)","v":{"v":5.23377,"d":"5.23"}}]
[null,null,"base ml males 2-9","base ml male 10-14 yrs","base ml male 15-19","base ml male  20-24","base ml male 25-34","base ml male 35-44","base ml male  45-54","base ml male 55-64"," base ml male 65-74","base ml male 75+","Base ml Female 2-9","Base ml Female 10-14 yrs","Base ml Female 15-19","Base ml Female 20-24"," Base ml Female 25-34","Base ml Female 35-44","Base ml Female 45-54"," Base ml Female 55-64","Base ml Female 65-74","Base ml Female 75+"]
[null,"baseline consumption total",{"$f":"C7+C13+C19+C25+C31","v":{"v":172.968162,"d":"173.0"}},{"$f":"D7+D13+D19+D25+D31","v":{"v":294.817262,"d":"294.8"}},{"v":400.094782,"d":"400.1"},{"v":368.41391200000004,"d":"368.4"},{"v":329.647102,"d":"329.6"},{"v":235.27321199999997,"d":"235.3"},{"v":220.846882,"d":"220.8"},{"v":142.891932,"d":"142.9"},{"v":99.888902,"d":"99.9"},{"v":105.485792,"d":"105.5"},{"v":147.12033,"d":"147.1"},{"v":217.28976,"d":"217.3"},{"v":236.47365,"d":"236.5"},{"v":194.59388,"d":"194.6"},{"v":163.27677,"d":"163.28"},{"v":120.03033,"d":"120.03"},{"v":97.66344000000001,"d":"97.66"},{"v":82.03587,"d":"82.04"},{"v":77.99016,"d":"77.99"},{"v":70.21907999999999,"d":"70.22"}]
[null,"Ersatz baseline consumption total ",{"$f":"_xll.ErRunOutput(C32,C33)","v":{"v":172.968162,"d":"173.0"}},{"$f":"_xll.ErRunOutput(D32,D33)","v":{"v":294.817262,"d":"294.8"}},{"$f":"_xll.ErRunOutput(E32,E33)","v":{"v":400.094782,"d":"400.1"}},{"$f":"_xll.ErRunOutput(F32,F33)","v":{"v":368.41391200000004,"d":"368.4"}},{"$f":"_xll.ErRunOutput(G32,G33)","v":{"v":329.647102,"d":"329.6"}},{"$f":"_xll.ErRunOutput(H32,H33)","v":{"v":235.27321199999997,"d":"235.3"}},{"$f":"_xll.ErRunOutput(I32,I33)","v":{"v":220.846882,"d":"220.8"}},{"$f":"_xll.ErRunOutput(J32,J33)","v":{"v":142.891932,"d":"142.9"}},{"$f":"_xll.ErRunOutput(K32,K33)","v":{"v":99.888902,"d":"99.9"}},{"$f":"_xll.ErRunOutput(L32,L33)","v":{"v":105.485792,"d":"105.5"}},{"$f":"_xll.ErRunOutput(M32,M33)","v":{"v":147.12033,"d":"147.1"}},{"$f":"_xll.ErRunOutput(N32,N33)","v":{"v":217.28976,"d":"217.3"}},{"$f":"_xll.ErRunOutput(O32,O33)","v":{"v":236.47365,"d":"236.5"}},{"$f":"_xll.ErRunOutput(P32,P33)","v":{"v":194.59388,"d":"194.6"}},{"$f":"_xll.ErRunOutput(Q32,Q33)","v":{"v":163.27677,"d":"163.28"}},{"$f":"_xll.ErRunOutput(R32,R33)","v":{"v":120.03033,"d":"120.03"}},{"$f":"_xll.ErRunOutput(S32,S33)","v":{"v":97.66344000000001,"d":"97.66"}},{"$f":"_xll.ErRunOutput(T32,T33)","v":{"v":82.03587,"d":"82.04"}},{"$f":"_xll.ErRunOutput(U32,U33)","v":{"v":77.99016,"d":"77.99"}},{"$f":"_xll.ErRunOutput(V32,V33)","v":{"v":70.21907999999999,"d":"70.22"}}]
[]
["Consumption of substitutes","Consumption of substitutes"]
[null,"Mean intake fruit juice (g/day)",{"v":55.64001,"d":"55.6"},{"v":55.64001,"d":"55.6"},{"v":55.64001,"d":"55.6"},{"v":55.64001,"d":"55.6"},{"v":55.64001,"d":"55.6"},{"v":55.64001,"d":"55.6"},{"v":55.64001,"d":"55.6"},{"v":55.64001,"d":"55.6"},{"v":55.64001,"d":"55.6"},{"v":55.64001,"d":"55.6"},{"v":44.81085,"d":"44.8"},{"v":44.81085,"d":"44.8"},{"v":44.81085,"d":"44.8"},{"v":44.81085,"d":"44.8"},44.81085,44.81085,44.81085,44.81085,44.81085,44.81085]
[null,"Relative standard error of estimate (%)",{"v":2.764436,"d":"2.8"},{"v":2.764436,"d":"2.8"},{"v":2.764436,"d":"2.8"},{"v":2.764436,"d":"2.8"},{"v":2.764436,"d":"2.8"},{"v":2.764436,"d":"2.8"},{"v":2.764436,"d":"2.8"},{"v":2.764436,"d":"2.8"},{"v":2.764436,"d":"2.8"},{"v":2.764436,"d":"2.8"},{"v":2.08599,"d":"2.1"},{"v":2.08599,"d":"2.1"},{"v":2.08599,"d":"2.1"},{"v":2.08599,"d":"2.1"},2.08599,2.08599,2.08599,2.08599,2.08599,2.08599]
[null,"Lower 95% confidence interval of the mean",{"v":50.10838,"d":"50.1"},{"v":50.10838,"d":"50.1"},{"v":50.10838,"d":"50.1"},{"v":50.10838,"d":"50.1"},{"v":50.10838,"d":"50.1"},{"v":50.10838,"d":"50.1"},{"v":50.10838,"d":"50.1"},{"v":50.10838,"d":"50.1"},{"v":50.10838,"d":"50.1"},{"v":50.10838,"d":"50.1"},{"v":40.63679,"d":"40.6"},{"v":40.63679,"d":"40.6"},{"v":40.63679,"d":"40.6"},{"v":40.63679,"d":"40.6"},40.63679,40.63679,40.63679,40.63679,40.63679,40.63679]
[null,"Upper 95% confidence interval of the mean",{"v":61.17163,"d":"61.2"},{"v":61.17163,"d":"61.2"},{"v":61.17163,"d":"61.2"},{"v":61.17163,"d":"61.2"},{"v":61.17163,"d":"61.2"},{"v":61.17163,"d":"61.2"},{"v":61.17163,"d":"61.2"},{"v":61.17163,"d":"61.2"},{"v":61.17163,"d":"61.2"},{"v":61.17163,"d":"61.2"},{"v":48.9849,"d":"49.0"},{"v":48.9849,"d":"49.0"},{"v":48.9849,"d":"49.0"},{"v":48.9849,"d":"49.0"},48.9849,48.9849,48.9849,48.9849,48.9849,48.9849]
[null,"Ersatz",{"$f":"_xll.ErLognormal(C37,C38)","v":{"v":55.64001,"d":"55.6"}},{"$f":"_xll.ErLognormal(D37,D38)","v":{"v":55.64001,"d":"55.6"}},{"$f":"_xll.ErLognormal(E37,E38)","v":{"v":55.64001,"d":"55.6"}},{"$f":"_xll.ErLognormal(F37,F38)","v":{"v":55.64001,"d":"55.6"}},{"$f":"_xll.ErLognormal(G37,G38)","v":{"v":55.64001,"d":"55.6"}},{"$f":"_xll.ErLognormal(H37,H38)","v":{"v":55.64001,"d":"55.6"}},{"$f":"_xll.ErLognormal(I37,I38)","v":{"v":55.64001,"d":"55.6"}},{"$f":"_xll.ErLognormal(J37,J38)","v":{"v":55.64001,"d":"55.6"}},{"$f":"_xll.ErLognormal(K37,K38)","v":{"v":55.64001,"d":"55.6"}},{"$f":"_xll.ErLognormal(L37,L38)","v":{"v":55.64001,"d":"55.6"}},{"$f":"_xll.ErLognormal(M37,M38)","v":{"v":44.81085,"d":"44.8"}},{"$f":"_xll.ErLognormal(N37,N38)","v":{"v":44.81085,"d":"44.8"}},{"$f":"_xll.ErLognormal(O37,O38)","v":{"v":44.81085,"d":"44.8"}},{"$f":"_xll.ErLognormal(P37,P38)","v":{"v":44.81085,"d":"44.8"}},{"$f":"_xll.ErLognormal(Q37,Q38)","v":{"v":44.81085,"d":"44.81"}},{"$f":"_xll.ErLognormal(R37,R38)","v":{"v":44.81085,"d":"44.81"}},{"$f":"_xll.ErLognormal(S37,S38)","v":{"v":44.81085,"d":"44.81"}},{"$f":"_xll.ErLognormal(T37,T38)","v":{"v":44.81085,"d":"44.81"}},{"$f":"_xll.ErLognormal(U37,U38)","v":{"v":44.81085,"d":"44.81"}},{"$f":"_xll.ErLognormal(V37,V38)","v":{"v":44.81085,"d":"44.81"}}]
[]
[null,"Mean intake low fat milk (g/day)",{"v":60.65228,"d":"60.7"},{"v":60.65228,"d":"60.7"},{"v":60.65228,"d":"60.7"},{"v":60.65228,"d":"60.7"},{"v":60.65228,"d":"60.7"},{"v":60.65228,"d":"60.7"},{"v":60.65228,"d":"60.7"},{"v":60.65228,"d":"60.7"},{"v":60.65228,"d":"60.7"},{"v":60.65228,"d":"60.7"},{"v":63.97512,"d":"64.0"},{"v":63.97512,"d":"64.0"},{"v":63.97512,"d":"64.0"},{"v":63.97512,"d":"64.0"},63.97512,63.97512,63.97512,63.97512,63.97512,63.97512]
[null,"Relative standard error of estimate (%)",{"v":2.584004,"d":"2.6"},{"v":2.584004,"d":"2.6"},{"v":2.584004,"d":"2.6"},{"v":2.584004,"d":"2.6"},{"v":2.584004,"d":"2.6"},{"v":2.584004,"d":"2.6"},{"v":2.584004,"d":"2.6"},{"v":2.584004,"d":"2.6"},{"v":2.584004,"d":"2.6"},{"v":2.584004,"d":"2.6"},{"v":2.18813,"d":"2.2"},{"v":2.18813,"d":"2.2"},{"v":2.18813,"d":"2.2"},{"v":2.18813,"d":"2.2"},2.18813,2.18813,2.18813,2.18813,2.18813,2.18813]
[null,"Lower 95% confidence interval of the mean",{"v":55.4817,"d":"55.5"},{"v":55.4817,"d":"55.5"},{"v":55.4817,"d":"55.5"},{"v":55.4817,"d":"55.5"},{"v":55.4817,"d":"55.5"},{"v":55.4817,"d":"55.5"},{"v":55.4817,"d":"55.5"},{"v":55.4817,"d":"55.5"},{"v":55.4817,"d":"55.5"},{"v":55.4817,"d":"55.5"},{"v":59.59668,"d":"59.6"},{"v":59.59668,"d":"59.6"},{"v":59.59668,"d":"59.6"},{"v":59.59668,"d":"59.6"},59.59668,59.59668,59.59668,59.59668,59.59668,59.59668]
[null,"Upper 95% confidence interval of the mean",{"v":65.82286,"d":"65.8"},{"v":65.82286,"d":"65.8"},{"v":65.82286,"d":"65.8"},{"v":65.82286,"d":"65.8"},{"v":65.82286,"d":"65.8"},{"v":65.82286,"d":"65.8"},{"v":65.82286,"d":"65.8"},{"v":65.82286,"d":"65.8"},{"v":65.82286,"d":"65.8"},{"v":65.82286,"d":"65.8"},{"v":68.35356,"d":"68.4"},{"v":68.35356,"d":"68.4"},{"v":68.35356,"d":"68.4"},{"v":68.35356,"d":"68.4"},68.35356,68.35356,68.35356,68.35356,68.35356,68.35356]
[null,"Ersatz",{"$f":"_xll.ErLognormal(C43,C44)","v":{"v":60.65228,"d":"60.7"}},{"$f":"_xll.ErLognormal(D43,D44)","v":{"v":60.65228,"d":"60.7"}},{"$f":"_xll.ErLognormal(E43,E44)","v":{"v":60.65228,"d":"60.7"}},{"$f":"_xll.ErLognormal(F43,F44)","v":{"v":60.65228,"d":"60.7"}},{"$f":"_xll.ErLognormal(G43,G44)","v":{"v":60.65228,"d":"60.7"}},{"$f":"_xll.ErLognormal(H43,H44)","v":{"v":60.65228,"d":"60.7"}},{"$f":"_xll.ErLognormal(I43,I44)","v":{"v":60.65228,"d":"60.7"}},{"$f":"_xll.ErLognormal(J43,J44)","v":{"v":60.65228,"d":"60.7"}},{"$f":"_xll.ErLognormal(K43,K44)","v":{"v":60.65228,"d":"60.7"}},{"$f":"_xll.ErLognormal(L43,L44)","v":{"v":60.65228,"d":"60.7"}},{"$f":"_xll.ErLognormal(M43,M44)","v":{"v":63.97512,"d":"64.0"}},{"$f":"_xll.ErLognormal(N43,N44)","v":{"v":63.97512,"d":"64.0"}},{"$f":"_xll.ErLognormal(O43,O44)","v":{"v":63.97512,"d":"64.0"}},{"$f":"_xll.ErLognormal(P43,P44)","v":{"v":63.97512,"d":"64.0"}},{"$f":"_xll.ErLognormal(Q43,Q44)","v":{"v":63.97512,"d":"63.98"}},{"$f":"_xll.ErLognormal(R43,R44)","v":{"v":63.97512,"d":"63.98"}},{"$f":"_xll.ErLognormal(S43,S44)","v":{"v":63.97512,"d":"63.98"}},{"$f":"_xll.ErLognormal(T43,T44)","v":{"v":63.97512,"d":"63.98"}},{"$f":"_xll.ErLognormal(U43,U44)","v":{"v":63.97512,"d":"63.98"}},{"$f":"_xll.ErLognormal(V43,V44)","v":{"v":63.97512,"d":"63.98"}}]
[]
[null,"Mean intake tea black (g/day)",{"v":148.2815,"d":"148.3"},{"v":148.2815,"d":"148.3"},{"v":148.2815,"d":"148.3"},{"v":148.2815,"d":"148.3"},{"v":148.2815,"d":"148.3"},{"v":148.2815,"d":"148.3"},{"v":148.2815,"d":"148.3"},{"v":148.2815,"d":"148.3"},{"v":148.2815,"d":"148.3"},{"v":148.2815,"d":"148.3"},{"v":205.7128,"d":"205.7"},{"v":205.7128,"d":"205.7"},{"v":205.7128,"d":"205.7"},{"v":205.7128,"d":"205.7"},205.7128,205.7128,205.7128,205.7128,205.7128,205.7128]
[null,"Relative standard error of estimate (%)",{"v":5.558553,"d":"5.6"},{"v":5.558553,"d":"5.6"},{"v":5.558553,"d":"5.6"},{"v":5.558553,"d":"5.6"},{"v":5.558553,"d":"5.6"},{"v":5.558553,"d":"5.6"},{"v":5.558553,"d":"5.6"},{"v":5.558553,"d":"5.6"},{"v":5.558553,"d":"5.6"},{"v":5.558553,"d":"5.6"},{"v":5.180459,"d":"5.2"},{"v":5.180459,"d":"5.2"},{"v":5.180459,"d":"5.2"},{"v":5.180459,"d":"5.2"},5.180459,5.180459,5.180459,5.180459,5.180459,5.180459]
[null,"Lower 95% confidence interval of the mean",{"v":137.1589,"d":"137.2"},{"v":137.1589,"d":"137.2"},{"v":137.1589,"d":"137.2"},{"v":137.1589,"d":"137.2"},{"v":137.1589,"d":"137.2"},{"v":137.1589,"d":"137.2"},{"v":137.1589,"d":"137.2"},{"v":137.1589,"d":"137.2"},{"v":137.1589,"d":"137.2"},{"v":137.1589,"d":"137.2"},{"v":195.3468,"d":"195.3"},{"v":195.3468,"d":"195.3"},{"v":195.3468,"d":"195.3"},{"v":195.3468,"d":"195.3"},195.3468,195.3468,195.3468,195.3468,195.3468,195.3468]
[null,"Upper 95% confidence interval of the mean",{"v":159.4042,"d":"159.4"},{"v":159.4042,"d":"159.4"},{"v":159.4042,"d":"159.4"},{"v":159.4042,"d":"159.4"},{"v":159.4042,"d":"159.4"},{"v":159.4042,"d":"159.4"},{"v":159.4042,"d":"159.4"},{"v":159.4042,"d":"159.4"},{"v":159.4042,"d":"159.4"},{"v":159.4042,"d":"159.4"},{"v":216.0789,"d":"216.1"},{"v":216.0789,"d":"216.1"},{"v":216.0789,"d":"216.1"},{"v":216.0789,"d":"216.1"},216.0789,216.0789,216.0789,216.0789,216.0789,216.0789]
[null,"Ersatz",{"$f":"_xll.ErLognormal(C49,C50)","v":{"v":148.2815,"d":"148.3"}},{"$f":"_xll.ErLognormal(D49,D50)","v":{"v":148.2815,"d":"148.3"}},{"$f":"_xll.ErLognormal(E49,E50)","v":{"v":148.2815,"d":"148.3"}},{"$f":"_xll.ErLognormal(F49,F50)","v":{"v":148.2815,"d":"148.3"}},{"$f":"_xll.ErLognormal(G49,G50)","v":{"v":148.2815,"d":"148.3"}},{"$f":"_xll.ErLognormal(H49,H50)","v":{"v":148.2815,"d":"148.3"}},{"$f":"_xll.ErLognormal(I49,I50)","v":{"v":148.2815,"d":"148.3"}},{"$f":"_xll.ErLognormal(J49,J50)","v":{"v":148.2815,"d":"148.3"}},{"$f":"_xll.ErLognormal(K49,K50)","v":{"v":148.2815,"d":"148.3"}},{"$f":"_xll.ErLognormal(L49,L50)","v":{"v":148.2815,"d":"148.3"}},{"$f":"_xll.ErLognormal(M49,M50)","v":{"v":205.7128,"d":"205.7"}},{"$f":"_xll.ErLognormal(N49,N50)","v":{"v":205.7128,"d":"205.7"}},{"$f":"_xll.ErLognormal(O49,O50)","v":{"v":205.7128,"d":"205.7"}},{"$f":"_xll.ErLognormal(P49,P50)","v":{"v":205.7128,"d":"205.7"}},{"$f":"_xll.ErLognormal(Q49,Q50)","v":{"v":205.7128,"d":"205.71"}},{"$f":"_xll.ErLognormal(R49,R50)","v":{"v":205.7128,"d":"205.71"}},{"$f":"_xll.ErLognormal(S49,S50)","v":{"v":205.7128,"d":"205.71"}},{"$f":"_xll.ErLognormal(T49,T50)","v":{"v":205.7128,"d":"205.71"}},{"$f":"_xll.ErLognormal(U49,U50)","v":{"v":205.7128,"d":"205.71"}},{"$f":"_xll.ErLognormal(V49,V50)","v":{"v":205.7128,"d":"205.71"}}]
[]
[null,"Mean intake tea milk  (g/day)",{"v":3.797644,"d":"3.8"},{"v":3.797644,"d":"3.8"},{"v":3.797644,"d":"3.8"},{"v":3.797644,"d":"3.8"},{"v":3.797644,"d":"3.8"},{"v":3.797644,"d":"3.8"},{"v":3.797644,"d":"3.8"},{"v":3.797644,"d":"3.8"},{"v":3.797644,"d":"3.8"},{"v":3.797644,"d":"3.8"},{"v":3.797644,"d":"3.8"},{"v":3.797644,"d":"3.8"},{"v":3.797644,"d":"3.8"},{"v":3.797644,"d":"3.8"},3.797644,3.797644,3.797644,3.797644,3.797644,3.797644]
[null,"Relative standard error of estimate (%)",{"v":0.5128867,"d":"0.5"},{"v":0.5128867,"d":"0.5"},{"v":0.5128867,"d":"0.5"},{"v":0.5128867,"d":"0.5"},{"v":0.5128867,"d":"0.5"},{"v":0.5128867,"d":"0.5"},{"v":0.5128867,"d":"0.5"},{"v":0.5128867,"d":"0.5"},{"v":0.5128867,"d":"0.5"},{"v":0.5128867,"d":"0.5"},{"v":0.5128867,"d":"0.5"},{"v":0.5128867,"d":"0.5"},{"v":0.5128867,"d":"0.5"},{"v":0.5128867,"d":"0.5"},0.5128867,0.5128867,0.5128867,0.5128867,0.5128867,0.5128867]
[null,"Lower 95% confidence interval of the mean",{"v":2.77136,"d":"2.8"},{"v":2.77136,"d":"2.8"},{"v":2.77136,"d":"2.8"},{"v":2.77136,"d":"2.8"},{"v":2.77136,"d":"2.8"},{"v":2.77136,"d":"2.8"},{"v":2.77136,"d":"2.8"},{"v":2.77136,"d":"2.8"},{"v":2.77136,"d":"2.8"},{"v":2.77136,"d":"2.8"},{"v":2.77136,"d":"2.8"},{"v":2.77136,"d":"2.8"},{"v":2.77136,"d":"2.8"},{"v":2.77136,"d":"2.8"},2.77136,2.77136,2.77136,2.77136,2.77136,2.77136]
[null,"Upper 95% confidence interval of the mean",{"v":4.823928,"d":"4.8"},{"v":4.823928,"d":"4.8"},{"v":4.823928,"d":"4.8"},{"v":4.823928,"d":"4.8"},{"v":4.823928,"d":"4.8"},{"v":4.823928,"d":"4.8"},{"v":4.823928,"d":"4.8"},{"v":4.823928,"d":"4.8"},{"v":4.823928,"d":"4.8"},{"v":4.823928,"d":"4.8"},{"v":4.823928,"d":"4.8"},{"v":4.823928,"d":"4.8"},{"v":4.823928,"d":"4.8"},{"v":4.823928,"d":"4.8"},4.823928,4.823928,4.823928,4.823928,4.823928,4.823928]
[null,"Ersatz",{"$f":"_xll.ErLognormal(C55,C56)","v":{"v":3.797644,"d":"3.8"}},{"$f":"_xll.ErLognormal(D55,D56)","v":{"v":3.797644,"d":"3.8"}},{"$f":"_xll.ErLognormal(E55,E56)","v":{"v":3.797644,"d":"3.8"}},{"$f":"_xll.ErLognormal(F55,F56)","v":{"v":3.797644,"d":"3.8"}},{"$f":"_xll.ErLognormal(G55,G56)","v":{"v":3.797644,"d":"3.8"}},{"$f":"_xll.ErLognormal(H55,H56)","v":{"v":3.797644,"d":"3.8"}},{"$f":"_xll.ErLognormal(I55,I56)","v":{"v":3.797644,"d":"3.8"}},{"$f":"_xll.ErLognormal(J55,J56)","v":{"v":3.797644,"d":"3.8"}},{"$f":"_xll.ErLognormal(K55,K56)","v":{"v":3.797644,"d":"3.8"}},{"$f":"_xll.ErLognormal(L55,L56)","v":{"v":3.797644,"d":"3.8"}},{"$f":"_xll.ErLognormal(M55,M56)","v":{"v":3.797644,"d":"3.8"}},{"$f":"_xll.ErLognormal(N55,N56)","v":{"v":3.797644,"d":"3.8"}},{"$f":"_xll.ErLognormal(O55,O56)","v":{"v":3.797644,"d":"3.8"}},{"$f":"_xll.ErLognormal(P55,P56)","v":{"v":3.797644,"d":"3.8"}},{"$f":"_xll.ErLognormal(Q55,Q56)","v":{"v":3.797644,"d":"3.80"}},{"$f":"_xll.ErLognormal(R55,R56)","v":{"v":3.797644,"d":"3.80"}},{"$f":"_xll.ErLognormal(S55,S56)","v":{"v":3.797644,"d":"3.80"}},{"$f":"_xll.ErLognormal(T55,T56)","v":{"v":3.797644,"d":"3.80"}},{"$f":"_xll.ErLognormal(U55,U56)","v":{"v":3.797644,"d":"3.80"}},{"$f":"_xll.ErLognormal(V55,V56)","v":{"v":3.797644,"d":"3.80"}}]
[]
[null,"Mean intake coffee black(g/day)",{"v":138.4501,"d":"138.5"},{"v":138.4501,"d":"138.5"},{"v":138.4501,"d":"138.5"},{"v":138.4501,"d":"138.5"},{"v":138.4501,"d":"138.5"},{"v":138.4501,"d":"138.5"},{"v":138.4501,"d":"138.5"},{"v":138.4501,"d":"138.5"},{"v":138.4501,"d":"138.5"},{"v":138.4501,"d":"138.5"},{"v":126.4924,"d":"126.5"},{"v":126.4924,"d":"126.5"},{"v":126.4924,"d":"126.5"},{"v":126.4924,"d":"126.5"},126.4924,126.4924,126.4924,126.4924,126.4924,126.4924]
[null,"Relative standard error of estimate (%)",{"v":5.383608,"d":"5.4"},{"v":5.383608,"d":"5.4"},{"v":5.383608,"d":"5.4"},{"v":5.383608,"d":"5.4"},{"v":5.383608,"d":"5.4"},{"v":5.383608,"d":"5.4"},{"v":5.383608,"d":"5.4"},{"v":5.383608,"d":"5.4"},{"v":5.383608,"d":"5.4"},{"v":5.383608,"d":"5.4"},{"v":3.172091,"d":"3.2"},{"v":3.172091,"d":"3.2"},{"v":3.172091,"d":"3.2"},{"v":3.172091,"d":"3.2"},3.172091,3.172091,3.172091,3.172091,3.172091,3.172091]
[null,"Lower 95% confidence interval of the mean",{"v":127.6775,"d":"127.7"},{"v":127.6775,"d":"127.7"},{"v":127.6775,"d":"127.7"},{"v":127.6775,"d":"127.7"},{"v":127.6775,"d":"127.7"},{"v":127.6775,"d":"127.7"},{"v":127.6775,"d":"127.7"},{"v":127.6775,"d":"127.7"},{"v":127.6775,"d":"127.7"},{"v":127.6775,"d":"127.7"},{"v":120.145,"d":"120.1"},{"v":120.145,"d":"120.1"},{"v":120.145,"d":"120.1"},{"v":120.145,"d":"120.1"},120.145,120.145,120.145,120.145,120.145,120.145]
[null,"Upper 95% confidence interval of the mean",{"v":149.2227,"d":"149.2"},{"v":149.2227,"d":"149.2"},{"v":149.2227,"d":"149.2"},{"v":149.2227,"d":"149.2"},{"v":149.2227,"d":"149.2"},{"v":149.2227,"d":"149.2"},{"v":149.2227,"d":"149.2"},{"v":149.2227,"d":"149.2"},{"v":149.2227,"d":"149.2"},{"v":149.2227,"d":"149.2"},{"v":132.8397,"d":"132.8"},{"v":132.8397,"d":"132.8"},{"v":132.8397,"d":"132.8"},{"v":132.8397,"d":"132.8"},132.8397,132.8397,132.8397,132.8397,132.8397,132.8397]
[null,"Ersatz",{"$f":"_xll.ErLognormal(C61,C62)","v":{"v":138.4501,"d":"138.5"}},{"$f":"_xll.ErLognormal(D61,D62)","v":{"v":138.4501,"d":"138.5"}},{"$f":"_xll.ErLognormal(E61,E62)","v":{"v":138.4501,"d":"138.5"}},{"$f":"_xll.ErLognormal(F61,F62)","v":{"v":138.4501,"d":"138.5"}},{"$f":"_xll.ErLognormal(G61,G62)","v":{"v":138.4501,"d":"138.5"}},{"$f":"_xll.ErLognormal(H61,H62)","v":{"v":138.4501,"d":"138.5"}},{"$f":"_xll.ErLognormal(I61,I62)","v":{"v":138.4501,"d":"138.5"}},{"$f":"_xll.ErLognormal(J61,J62)","v":{"v":138.4501,"d":"138.5"}},{"$f":"_xll.ErLognormal(K61,K62)","v":{"v":138.4501,"d":"138.5"}},{"$f":"_xll.ErLognormal(L61,L62)","v":{"v":138.4501,"d":"138.5"}},{"$f":"_xll.ErLognormal(M61,M62)","v":{"v":126.4924,"d":"126.5"}},{"$f":"_xll.ErLognormal(N61,N62)","v":{"v":126.4924,"d":"126.5"}},{"$f":"_xll.ErLognormal(O61,O62)","v":{"v":126.4924,"d":"126.5"}},{"$f":"_xll.ErLognormal(P61,P62)","v":{"v":126.4924,"d":"126.5"}},{"$f":"_xll.ErLognormal(Q61,Q62)","v":{"v":126.4924,"d":"126.49"}},{"$f":"_xll.ErLognormal(R61,R62)","v":{"v":126.4924,"d":"126.49"}},{"$f":"_xll.ErLognormal(S61,S62)","v":{"v":126.4924,"d":"126.49"}},{"$f":"_xll.ErLognormal(T61,T62)","v":{"v":126.4924,"d":"126.49"}},{"$f":"_xll.ErLognormal(U61,U62)","v":{"v":126.4924,"d":"126.49"}},{"$f":"_xll.ErLognormal(V61,V62)","v":{"v":126.4924,"d":"126.49"}}]
[]
[null,"Mean intake coffee white (g/day)",{"v":53.6665,"d":"53.7"},{"v":53.6665,"d":"53.7"},{"v":53.6665,"d":"53.7"},{"v":53.6665,"d":"53.7"},{"v":53.6665,"d":"53.7"},{"v":53.6665,"d":"53.7"},{"v":53.6665,"d":"53.7"},{"v":53.6665,"d":"53.7"},{"v":53.6665,"d":"53.7"},{"v":53.6665,"d":"53.7"},{"v":52.96699,"d":"53.0"},{"v":52.96699,"d":"53.0"},{"v":52.96699,"d":"53.0"},{"v":52.96699,"d":"53.0"},52.96699,52.96699,52.96699,52.96699,52.96699,52.96699]
[null,"Relative standard error of estimate (%)",{"v":2.256387,"d":"2.3"},{"v":2.256387,"d":"2.3"},{"v":2.256387,"d":"2.3"},{"v":2.256387,"d":"2.3"},{"v":2.256387,"d":"2.3"},{"v":2.256387,"d":"2.3"},{"v":2.256387,"d":"2.3"},{"v":2.256387,"d":"2.3"},{"v":2.256387,"d":"2.3"},{"v":2.256387,"d":"2.3"},{"v":2.742485,"d":"2.7"},{"v":2.742485,"d":"2.7"},{"v":2.742485,"d":"2.7"},{"v":2.742485,"d":"2.7"},2.742485,2.742485,2.742485,2.742485,2.742485,2.742485]
[null,"Lower 95% confidence interval of the mean",{"v":49.15149,"d":"49.2"},{"v":49.15149,"d":"49.2"},{"v":49.15149,"d":"49.2"},{"v":49.15149,"d":"49.2"},{"v":49.15149,"d":"49.2"},{"v":49.15149,"d":"49.2"},{"v":49.15149,"d":"49.2"},{"v":49.15149,"d":"49.2"},{"v":49.15149,"d":"49.2"},{"v":49.15149,"d":"49.2"},{"v":47.47929,"d":"47.5"},{"v":47.47929,"d":"47.5"},{"v":47.47929,"d":"47.5"},{"v":47.47929,"d":"47.5"},47.47929,47.47929,47.47929,47.47929,47.47929,47.47929]
[null,"Upper 95% confidence interval of the mean",{"v":58.18152,"d":"58.2"},{"v":58.18152,"d":"58.2"},{"v":58.18152,"d":"58.2"},{"v":58.18152,"d":"58.2"},{"v":58.18152,"d":"58.2"},{"v":58.18152,"d":"58.2"},{"v":58.18152,"d":"58.2"},{"v":58.18152,"d":"58.2"},{"v":58.18152,"d":"58.2"},{"v":58.18152,"d":"58.2"},{"v":58.45469,"d":"58.5"},{"v":58.45469,"d":"58.5"},{"v":58.45469,"d":"58.5"},{"v":58.45469,"d":"58.5"},58.45469,58.45469,58.45469,58.45469,58.45469,58.45469]
[null,"Ersatz",{"$f":"_xll.ErLognormal(C67,C68)","v":{"v":53.6665,"d":"53.7"}},{"$f":"_xll.ErLognormal(D67,D68)","v":{"v":53.6665,"d":"53.7"}},{"$f":"_xll.ErLognormal(E67,E68)","v":{"v":53.6665,"d":"53.7"}},{"$f":"_xll.ErLognormal(F67,F68)","v":{"v":53.6665,"d":"53.7"}},{"$f":"_xll.ErLognormal(G67,G68)","v":{"v":53.6665,"d":"53.7"}},{"$f":"_xll.ErLognormal(H67,H68)","v":{"v":53.6665,"d":"53.7"}},{"$f":"_xll.ErLognormal(I67,I68)","v":{"v":53.6665,"d":"53.7"}},{"$f":"_xll.ErLognormal(J67,J68)","v":{"v":53.6665,"d":"53.7"}},{"$f":"_xll.ErLognormal(K67,K68)","v":{"v":53.6665,"d":"53.7"}},{"$f":"_xll.ErLognormal(L67,L68)","v":{"v":53.6665,"d":"53.7"}},{"$f":"_xll.ErLognormal(M67,M68)","v":{"v":52.96699,"d":"53.0"}},{"$f":"_xll.ErLognormal(N67,N68)","v":{"v":52.96699,"d":"53.0"}},{"$f":"_xll.ErLognormal(O67,O68)","v":{"v":52.96699,"d":"53.0"}},{"$f":"_xll.ErLognormal(P67,P68)","v":{"v":52.96699,"d":"53.0"}},{"$f":"_xll.ErLognormal(Q67,Q68)","v":{"v":52.96699,"d":"52.97"}},{"$f":"_xll.ErLognormal(R67,R68)","v":{"v":52.96699,"d":"52.97"}},{"$f":"_xll.ErLognormal(S67,S68)","v":{"v":52.96699,"d":"52.97"}},{"$f":"_xll.ErLognormal(T67,T68)","v":{"v":52.96699,"d":"52.97"}},{"$f":"_xll.ErLognormal(U67,U68)","v":{"v":52.96699,"d":"52.97"}},{"$f":"_xll.ErLognormal(V67,V68)","v":{"v":52.96699,"d":"52.97"}}]
[]
["Change SSB consumption","20% tax on sugar-sweetened drinks",{"v":20,"d":"20.0"}]
[null,"Adjusted mean intake of carbonated drink (g/day)",{"$f":"(C7*($G$169^$C$73))","v":{"v":37.087029055999984,"d":"37.1"}},{"v":126.83324863999994,"d":"126.8"},{"v":259.7787841599999,"d":"259.8"},{"v":178.42655599999992,"d":"178.4"},{"v":193.9516107199999,"d":"194.0"},{"v":116.70786287999994,"d":"116.7"},{"v":111.40207119999994,"d":"111.4"},{"v":75.97680271999997,"d":"76.0"},{"v":39.523538207999984,"d":"39.5"},{"v":31.568478367999987,"d":"31.6"},{"v":40.30859470399998,"d":"40.3"},{"v":106.42135503999995,"d":"106.4"},{"v":137.14922031999993,"d":"137.1"},{"v":104.42179551999995,"d":"104.4"},{"v":80.88815940799996,"d":"80.89"},{"v":65.64783332799998,"d":"65.65"},{"v":59.69770374399997,"d":"59.70"},{"v":33.946104079999984,"d":"33.95"},{"v":30.576812223999983,"d":"30.58"},{"v":25.821569647999986,"d":"25.82"}]
[null,"Change in soft drink consumption (g/day)",{"$f":"C74-C7","v":{"v":-4.828690944000016,"d":"-4.8"}},{"$f":"D74-D7","v":{"v":-16.513551360000065,"d":"-16.5"}},{"v":-33.82291584000012,"d":"-33.8"},{"v":-23.23094400000008,"d":"-23.2"},{"v":-25.2522892800001,"d":"-25.3"},{"v":-15.195237120000058,"d":"-15.2"},{"v":-14.504428800000056,"d":"-14.5"},{"v":-9.89209728000003,"d":"-9.9"},{"v":-5.145921792000017,"d":"-5.1"},{"v":-4.110181632000014,"d":"-4.1"},{"v":-5.248135296000022,"d":"-5.2"},{"v":-13.855944960000045,"d":"-13.9"},{"v":-17.85667968000007,"d":"-17.9"},{"v":-13.595604480000048,"d":"-13.6"},{"v":-10.53155059200003,"d":"-10.53"},{"v":-8.547276672000024,"d":"-8.55"},{"v":-7.772576256000029,"d":"-7.77"},{"v":-4.419745920000018,"d":"-4.42"},{"v":-3.981067776000014,"d":"-3.98"},{"v":-3.361940352000012,"d":"-3.36"}]
[null,"Change in kJ",{"$f":"C75*$C$149","v":{"v":-8.401922242560028,"d":"-8.4"}},{"v":-28.733579366400114,"d":"-28.7"},{"v":-58.85187356160021,"d":"-58.9"},{"v":-40.42184256000014,"d":"-40.4"},{"v":-43.93898334720017,"d":"-43.9"},{"v":-26.439712588800102,"d":"-26.4"},{"v":-25.237706112000097,"d":"-25.2"},{"v":-17.21224926720005,"d":"-17.2"},{"v":-8.95390391808003,"d":"-9.0"},{"v":-7.151716039680024,"d":"-7.2"},{"v":-9.131755415040038,"d":"-9.1"},{"v":-24.10934423040008,"d":"-24.1"},{"v":-31.07062264320012,"d":"-31.1"},{"v":-23.656351795200084,"d":"-23.7"},{"v":-18.324898030080053,"d":"-18.32"},{"v":-14.872261409280041,"d":"-14.87"},{"v":-13.52428268544005,"d":"-13.52"},{"v":-7.690357900800032,"d":"-7.69"},{"v":-6.927057930240024,"d":"-6.93"},{"v":-5.8497762124800206,"d":"-5.85"}]
[null,"Change in weight (kg) ",{"$f":"C76/$C$140","v":{"v":-0.03618211910909009,"d":"-0.0"}},{"$f":"D76/C141","v":{"v":-0.18072342864043545,"d":"-0.2"}},{"$f":"E76/C142","v":{"v":-0.5516053083792618,"d":"-0.6"}},{"$f":"F76/100","v":{"v":-0.4042184256000014,"d":"-0.4"}},{"v":-0.4393898334720017,"d":"-0.4"},{"v":-0.264397125888001,"d":"-0.3"},{"v":-0.25237706112000097,"d":"-0.3"},{"v":-0.1721224926720005,"d":"-0.2"},{"v":-0.0895390391808003,"d":"-0.1"},{"v":-0.07151716039680024,"d":"-0.1"},{"$f":"M76/$C$143","v":{"v":-0.042794939709819096,"d":"-0.0"}},{"$f":"N76/$C$144","v":{"v":-0.1618615608309886,"d":"-0.2"}},{"$f":"O76/$C$145","v":{"v":-0.30187223728023255,"d":"-0.3"}},{"v":-0.23656351795200084,"d":"-0.2"},{"v":-0.18324898030080053,"d":"-0.18"},{"v":-0.1487226140928004,"d":"-0.15"},{"v":-0.1352428268544005,"d":"-0.14"},{"v":-0.07690357900800032,"d":"-0.08"},{"v":-0.06927057930240024,"d":"-0.07"},{"v":-0.05849776212480021,"d":"-0.06"}]
[]
[null,"Adjusted mean intake of sports drink (g/day)",{"$f":"C13*$G$169^$C$73","v":{"v":10.618891807999995,"d":"10.6"}},{"v":10.618891807999995,"d":"10.6"},{"v":10.618891807999995,"d":"10.6"},{"v":10.618891807999995,"d":"10.6"},{"v":10.618891807999995,"d":"10.6"},{"v":10.618891807999995,"d":"10.6"},{"v":10.618891807999995,"d":"10.6"},{"v":10.618891807999995,"d":"10.6"},{"v":10.618891807999995,"d":"10.6"},{"v":10.618891807999995,"d":"10.6"},{"v":3.0105496959999987,"d":"3.0"},{"v":3.0105496959999987,"d":"3.0"},{"v":3.0105496959999987,"d":"3.0"},{"v":3.0105496959999987,"d":"3.0"},{"v":3.0105496959999987,"d":"3.01"},{"v":3.0105496959999987,"d":"3.01"},{"v":3.0105496959999987,"d":"3.01"},{"v":3.0105496959999987,"d":"3.01"},{"v":3.0105496959999987,"d":"3.01"},{"v":3.0105496959999987,"d":"3.01"}]
[null,"Change in sports drink consumption (g/day)",{"$f":"C79-C13","v":{"v":-1.3825681920000044,"d":"-1.4"}},{"$f":"D79-D13","v":{"v":-1.3825681920000044,"d":"-1.4"}},{"v":-1.3825681920000044,"d":"-1.4"},{"v":-1.3825681920000044,"d":"-1.4"},{"v":-1.3825681920000044,"d":"-1.4"},{"v":-1.3825681920000044,"d":"-1.4"},{"v":-1.3825681920000044,"d":"-1.4"},{"v":-1.3825681920000044,"d":"-1.4"},{"v":-1.3825681920000044,"d":"-1.4"},{"v":-1.3825681920000044,"d":"-1.4"},{"v":-0.3919703040000013,"d":"-0.4"},{"v":-0.3919703040000013,"d":"-0.4"},{"v":-0.3919703040000013,"d":"-0.4"},{"v":-0.3919703040000013,"d":"-0.4"},{"v":-0.3919703040000013,"d":"-0.39"},{"v":-0.3919703040000013,"d":"-0.39"},{"v":-0.3919703040000013,"d":"-0.39"},{"v":-0.3919703040000013,"d":"-0.39"},{"v":-0.3919703040000013,"d":"-0.39"},{"v":-0.3919703040000013,"d":"-0.39"}]
[null,"Change in kJ",{"$f":"C80*$C$150","v":{"v":-1.5623020569600048,"d":"-1.6"}},{"v":-1.5623020569600048,"d":"-1.6"},{"v":-1.5623020569600048,"d":"-1.6"},{"v":-1.5623020569600048,"d":"-1.6"},{"v":-1.5623020569600048,"d":"-1.6"},{"v":-1.5623020569600048,"d":"-1.6"},{"v":-1.5623020569600048,"d":"-1.6"},{"v":-1.5623020569600048,"d":"-1.6"},{"v":-1.5623020569600048,"d":"-1.6"},{"v":-1.5623020569600048,"d":"-1.6"},{"v":-0.44292644352000143,"d":"-0.4"},{"v":-0.44292644352000143,"d":"-0.4"},{"v":-0.44292644352000143,"d":"-0.4"},{"v":-0.44292644352000143,"d":"-0.4"},{"v":-0.44292644352000143,"d":"-0.44"},{"v":-0.44292644352000143,"d":"-0.44"},{"v":-0.44292644352000143,"d":"-0.44"},{"v":-0.44292644352000143,"d":"-0.44"},{"v":-0.44292644352000143,"d":"-0.44"},{"v":-0.44292644352000143,"d":"-0.44"}]
[null,"Change in weight (kg) ",{"$f":"C81/C140","v":{"v":-0.006727912670146266,"d":"-0.0"}},{"$f":"D81/C141","v":{"v":-0.009826293505082045,"d":"-0.0"}},{"$f":"E81/C142","v":{"v":-0.014643104046788931,"d":"-0.0"}},{"$f":"F81/100","v":{"v":-0.015623020569600047,"d":"-0.0"}},{"v":-0.015623020569600047,"d":"-0.0"},{"v":-0.015623020569600047,"d":"-0.0"},{"v":-0.015623020569600047,"d":"-0.0"},{"v":-0.015623020569600047,"d":"-0.0"},{"v":-0.015623020569600047,"d":"-0.0"},{"v":-0.015623020569600047,"d":"-0.0"},{"$f":"M81/$C$143","v":{"v":-2.075724719379154E-3,"d":"-0.0"}},{"$f":"N81/$C$144","v":{"v":-2.9736505811330583E-3,"d":"-0.0"}},{"$f":"O81/$C$145","v":{"v":-0.004303331735298247,"d":"-0.0"}},{"v":-4.4292644352000145E-3,"d":"-0.0"},{"v":-4.4292644352000145E-3,"d":"-0.00"},{"v":-4.4292644352000145E-3,"d":"-0.00"},{"v":-4.4292644352000145E-3,"d":"-0.00"},{"v":-4.4292644352000145E-3,"d":"-0.00"},{"v":-4.4292644352000145E-3,"d":"-0.00"},{"v":-4.4292644352000145E-3,"d":"-0.00"}]
[]
[null,"Adjusted mean intake of energy drinks (g/day)",{"$f":"C19*$G$169^$C73","v":{"v":6.474764665599997,"d":"6.5"}},{"v":6.474764665599997,"d":"6.5"},{"v":6.474764665599997,"d":"6.5"},{"v":6.474764665599997,"d":"6.5"},{"v":6.474764665599997,"d":"6.5"},{"v":6.474764665599997,"d":"6.5"},{"v":6.474764665599997,"d":"6.5"},{"v":6.474764665599997,"d":"6.5"},{"v":6.474764665599997,"d":"6.5"},{"v":6.474764665599997,"d":"6.5"},{"v":1.7653795039999993,"d":"1.8"},{"v":1.7653795039999993,"d":"1.8"},{"v":1.7653795039999993,"d":"1.8"},{"v":1.7653795039999993,"d":"1.8"},{"v":1.7653795039999993,"d":"1.77"},{"v":1.7653795039999993,"d":"1.77"},{"v":1.7653795039999993,"d":"1.77"},{"v":1.7653795039999993,"d":"1.77"},{"v":1.7653795039999993,"d":"1.77"},{"v":1.7653795039999993,"d":"1.77"}]
[null,"Change in energy drink consumption (g/day)",{"$f":"C84-C19","v":{"v":-0.8430073344000029,"d":"-0.8"}},{"$f":"D84-D19","v":{"v":-0.8430073344000029,"d":"-0.8"}},{"v":-0.8430073344000029,"d":"-0.8"},{"v":-0.8430073344000029,"d":"-0.8"},{"v":-0.8430073344000029,"d":"-0.8"},{"v":-0.8430073344000029,"d":"-0.8"},{"v":-0.8430073344000029,"d":"-0.8"},{"v":-0.8430073344000029,"d":"-0.8"},{"v":-0.8430073344000029,"d":"-0.8"},{"v":-0.8430073344000029,"d":"-0.8"},{"v":-0.22985049600000074,"d":"-0.2"},{"v":-0.22985049600000074,"d":"-0.2"},{"v":-0.22985049600000074,"d":"-0.2"},{"v":-0.22985049600000074,"d":"-0.2"},{"v":-0.22985049600000074,"d":"-0.23"},{"v":-0.22985049600000074,"d":"-0.23"},{"v":-0.22985049600000074,"d":"-0.23"},{"v":-0.22985049600000074,"d":"-0.23"},{"v":-0.22985049600000074,"d":"-0.23"},{"v":-0.22985049600000074,"d":"-0.23"}]
[null,"Change in kJ",{"$f":"C85*$C$151","v":{"v":-1.6101440087040053,"d":"-1.6"}},{"v":-1.6101440087040053,"d":"-1.6"},{"v":-1.6101440087040053,"d":"-1.6"},{"v":-1.6101440087040053,"d":"-1.6"},{"v":-1.6101440087040053,"d":"-1.6"},{"v":-1.6101440087040053,"d":"-1.6"},{"v":-1.6101440087040053,"d":"-1.6"},{"v":-1.6101440087040053,"d":"-1.6"},{"v":-1.6101440087040053,"d":"-1.6"},{"v":-1.6101440087040053,"d":"-1.6"},{"v":-0.4390144473600014,"d":"-0.4"},{"v":-0.4390144473600014,"d":"-0.4"},{"v":-0.4390144473600014,"d":"-0.4"},{"v":-0.4390144473600014,"d":"-0.4"},{"v":-0.4390144473600014,"d":"-0.44"},{"v":-0.4390144473600014,"d":"-0.44"},{"v":-0.4390144473600014,"d":"-0.44"},{"v":-0.4390144473600014,"d":"-0.44"},{"v":-0.4390144473600014,"d":"-0.44"},{"v":-0.4390144473600014,"d":"-0.44"}]
[null,"Change in weight (kg) ",{"$f":"C86/C140","v":{"v":-0.006933939713296493,"d":"-0.0"}},{"$f":"D86/C141","v":{"v":-0.010127201423367246,"d":"-0.0"}},{"$f":"E86/C142","v":{"v":-0.015091515846586485,"d":"-0.0"}},{"$f":"F86/100","v":{"v":-0.016101440087040054,"d":"-0.0"}},{"v":-0.016101440087040054,"d":"-0.0"},{"v":-0.016101440087040054,"d":"-0.0"},{"v":-0.016101440087040054,"d":"-0.0"},{"v":-0.016101440087040054,"d":"-0.0"},{"v":-0.016101440087040054,"d":"-0.0"},{"v":-0.016101440087040054,"d":"-0.0"},{"$f":"M86/$C$143","v":{"v":-0.002057391591497026,"d":"-0.0"}},{"$f":"N86/$C$144","v":{"v":-2.9473868305154027E-3,"d":"-0.0"}},{"$f":"O86/$C$145","v":{"v":-4.2653240311523715E-3,"d":"-0.0"}},{"v":-0.004390144473600014,"d":"-0.0"},{"v":-0.004390144473600014,"d":"-0.00"},{"v":-0.004390144473600014,"d":"-0.00"},{"v":-0.004390144473600014,"d":"-0.00"},{"v":-0.004390144473600014,"d":"-0.00"},{"v":-0.004390144473600014,"d":"-0.00"},{"v":-0.004390144473600014,"d":"-0.00"}]
[]
[null,"Adjusted mean intake of fruit drink (g/day)",{"$f":"C25*$G$171^$C$73","v":{"v":44.64787235000007,"d":"44.6"}},{"v":41.859374600000066,"d":"41.9"},{"v":35.00613450000005,"d":"35.0"},{"v":68.21347395000011,"d":"68.2"},{"v":36.34975690000005,"d":"36.3"},{"v":31.780202550000045,"d":"31.8"},{"v":15.333917800000021,"d":"15.3"},{"v":18.827952900000028,"d":"18.8"},{"v":14.293212400000021,"d":"14.3"},{"v":14.792124000000022,"d":"14.8"},{"v":44.166408650000065,"d":"44.2"},{"v":42.94540580000007,"d":"42.9"},{"v":32.92099125000005,"d":"32.9"},{"v":40.09021565000006,"d":"40.1"},{"v":27.29277700000004,"d":"27.29"},{"v":13.87837405000002,"d":"13.88"},{"v":8.250733450000011,"d":"8.25"},{"v":16.700031750000022,"d":"16.70"},{"v":17.706295800000024,"d":"17.71"},{"v":22.651017250000034,"d":"22.65"}]
[null,"Change in fruit drink consumption (g/day)",{"$f":"C89-C25","v":{"v":-15.282157649999931,"d":"-15.3"}},{"$f":"D89-D25","v":{"v":-14.327705399999935,"d":"-14.3"}},{"v":-11.981965499999951,"d":"-12.0"},{"v":-23.348236049999898,"d":"-23.3"},{"v":-12.44186309999995,"d":"-12.4"},{"v":-10.877787449999953,"d":"-10.9"},{"v":-5.248522199999977,"d":"-5.2"},{"v":-6.444467099999972,"d":"-6.4"},{"v":-4.892307599999979,"d":"-4.9"},{"v":-5.0630759999999775,"d":"-5.1"},{"v":-15.117361349999932,"d":"-15.1"},{"v":-14.699434199999935,"d":"-14.7"},{"v":-11.268258749999951,"d":"-11.3"},{"v":-13.72215434999994,"d":"-13.7"},{"v":-9.341822999999959,"d":"-9.34"},{"v":-4.75031594999998,"d":"-4.75"},{"v":-2.8240765499999885,"d":"-2.82"},{"v":-5.716118249999976,"d":"-5.72"},{"v":-6.060544199999974,"d":"-6.06"},{"v":-7.753032749999967,"d":"-7.75"}]
[null,"Change in kJ",{"$f":"C90*$C$152","v":{"v":-28.119170075999875,"d":"-28.1"}},{"v":-26.362977935999883,"d":"-26.4"},{"v":-22.04681651999991,"d":"-22.0"},{"v":-42.960754331999816,"d":"-43.0"},{"v":-22.893028103999907,"d":"-22.9"},{"v":-20.015128907999916,"d":"-20.0"},{"v":-9.657280847999958,"d":"-9.7"},{"v":-11.857819463999949,"d":"-11.9"},{"v":-9.001845983999962,"d":"-9.0"},{"v":-9.316059839999959,"d":"-9.3"},{"v":-27.815944883999876,"d":"-27.8"},{"v":-27.04695892799988,"d":"-27.0"},{"v":-20.73359609999991,"d":"-20.7"},{"v":-25.24876400399989,"d":"-25.2"},{"v":-17.188954319999926,"d":"-17.19"},{"v":-8.740581347999964,"d":"-8.74"},{"v":-5.196300851999979,"d":"-5.20"},{"v":-10.517657579999957,"d":"-10.52"},{"v":-11.151401327999952,"d":"-11.15"},{"v":-14.26558025999994,"d":"-14.27"}]
[null,"Change in weight (kg) ",{"$f":"C91/C140","v":{"v":-0.12109266565035344,"d":"-0.1"}},{"$f":"D91/C141","v":{"v":-0.1658132354835456,"d":"-0.2"}},{"$f":"E91/C142","v":{"v":-0.20663982791586913,"d":"-0.2"}},{"$f":"F91/100","v":{"v":-0.4296075433199982,"d":"-0.4"}},{"v":-0.22893028103999907,"d":"-0.2"},{"v":-0.20015128907999916,"d":"-0.2"},{"v":-0.09657280847999958,"d":"-0.1"},{"v":-0.11857819463999948,"d":"-0.1"},{"v":-0.09001845983999962,"d":"-0.1"},{"v":-0.09316059839999959,"d":"-0.1"},{"$f":"M91/$C$143","v":{"v":-0.13035628202676805,"d":"-0.1"}},{"$f":"N91/$C$144","v":{"v":-0.181583660923367,"d":"-0.2"}},{"$f":"O91/$C$145","v":{"v":-0.20144099181551006,"d":"-0.2"}},{"v":-0.2524876400399989,"d":"-0.3"},{"v":-0.17188954319999927,"d":"-0.17"},{"v":-0.08740581347999964,"d":"-0.09"},{"v":-0.05196300851999979,"d":"-0.05"},{"v":-0.10517657579999957,"d":"-0.11"},{"v":-0.11151401327999952,"d":"-0.11"},{"v":-0.1426558025999994,"d":"-0.14"}]
[]
[null,"Adjusted mean intake of cordial made (g/day)",{"$f":"C31*$G$170^$C$73","v":{"v":34.58898328599997,"d":"34.6"}},{"v":50.721262954999965,"d":"50.7"},{"v":26.832025274999978,"d":"26.8"},{"v":37.30805131899997,"d":"37.3"},{"v":28.26531009499998,"d":"28.3"},{"v":27.638032652999982,"d":"27.6"},{"v":36.749346666999976,"d":"36.7"},{"v":8.300432425999995,"d":"8.3"},{"v":11.160398512999993,"d":"11.2"},{"v":20.453453789999983,"d":"20.5"},{"v":24.626164815999985,"d":"24.6"},{"v":22.681682198999983,"d":"22.7"},{"v":21.286776774999986,"d":"21.3"},{"v":11.595518571999992,"d":"11.6"},{"v":19.913958866999984,"d":"19.91"},{"v":14.561722405999989,"d":"14.56"},{"v":9.161244619999993,"d":"9.16"},{"v":10.587131323999992,"d":"10.59"},{"v":9.526536612999992,"d":"9.53"},{"v":3.4945882289999974,"d":"3.49"}]
[null,"Change in cordial consumption (g/day)",{"$f":"C94-C31","v":{"v":-17.214196714000025,"d":"-17.2"}},{"$f":"D94-D31","v":{"v":-25.24288704500004,"d":"-25.2"}},{"v":-13.35372472500002,"d":"-13.4"},{"v":-18.567418681000028,"d":"-18.6"},{"v":-14.06703990500002,"d":"-14.1"},{"v":-13.75485734700002,"d":"-13.8"},{"v":-18.289363333000026,"d":"-18.3"},{"v":-4.130947574000006,"d":"-4.1"},{"v":-5.5542914870000075,"d":"-5.6"},{"v":-10.179246210000017,"d":"-10.2"},{"v":-12.255915184000017,"d":"-12.3"},{"v":-11.288187801000017,"d":"-11.3"},{"v":-10.593973225000013,"d":"-10.6"},{"v":-5.770841428000008,"d":"-5.8"},{"v":-9.910751133000016,"d":"-9.91"},{"v":-7.24705759400001,"d":"-7.25"},{"v":-4.559355380000007,"d":"-4.56"},{"v":-5.268988676000008,"d":"-5.27"},{"v":-4.741153387000008,"d":"-4.74"},{"v":-1.7391817710000024,"d":"-1.74"}]
[null,"Change in kJ",{"$f":"C95*$C$154","v":{"v":-25.477011136720037,"d":"-25.5"}},{"v":-37.359472826600054,"d":"-37.4"},{"v":-19.76351259300003,"d":"-19.8"},{"v":-27.47977964788004,"d":"-27.5"},{"v":-20.819219059400027,"d":"-20.8"},{"v":-20.357188873560027,"d":"-20.4"},{"v":-27.06825773284004,"d":"-27.1"},{"v":-6.113802409520009,"d":"-6.1"},{"v":-8.220351400760011,"d":"-8.2"},{"v":-15.065284390800024,"d":"-15.1"},{"v":-18.138754472320024,"d":"-18.1"},{"v":-16.706517945480027,"d":"-16.7"},{"v":-15.67908037300002,"d":"-15.7"},{"v":-8.54084531344001,"d":"-8.5"},{"v":-14.667911676840022,"d":"-14.67"},{"v":-10.725645239120015,"d":"-10.73"},{"v":-6.747845962400009,"d":"-6.75"},{"v":-7.798103240480012,"d":"-7.80"},{"v":-7.0169070127600115,"d":"-7.02"},{"v":-2.5739890210800036,"d":"-2.57"}]
[null,"Change in weight (kg) ",{"$f":"C96/C140","v":{"v":-0.10971444687061838,"d":"-0.1"}},{"$f":"D96/C141","v":{"v":-0.23497706064833482,"d":"-0.2"}},{"$f":"E96/C142","v":{"v":-0.18523893631200117,"d":"-0.2"}},{"$f":"F96/100","v":{"v":-0.2747977964788004,"d":"-0.3"}},{"v":-0.20819219059400026,"d":"-0.2"},{"v":-0.20357188873560028,"d":"-0.2"},{"v":-0.2706825773284004,"d":"-0.3"},{"v":-0.06113802409520009,"d":"-0.1"},{"v":-0.0822035140076001,"d":"-0.1"},{"v":-0.15065284390800024,"d":"-0.2"},{"$f":"M96/$C$143","v":{"v":-0.08500522284857356,"d":"-0.1"}},{"$f":"N96/$C$144","v":{"v":-0.11216161853529785,"d":"-0.1"}},{"$f":"O96/$C$145","v":{"v":-0.15233293278498053,"d":"-0.2"}},{"v":-0.08540845313440011,"d":"-0.1"},{"v":-0.14667911676840023,"d":"-0.15"},{"v":-0.10725645239120014,"d":"-0.11"},{"v":-0.06747845962400009,"d":"-0.07"},{"v":-0.07798103240480012,"d":"-0.08"},{"v":-0.07016907012760011,"d":"-0.07"},{"v":-0.025739890210800035,"d":"-0.03"}]
[null,null,"Change ml males 2-9","Change ml male 10-14 yrs","Change ml male 15-19","Changeml male  20-24","Change ml male 25-34","Change ml male 35-44","Change ml male  45-54"," Change ml male 55-64"," Change ml male 65-74","change ml male 75+","Change ml females 2-9","Change ml female 10-14 yrs","Change ml female 15-19","Changeml female  20-24","Change ml female 25-34","Change ml female 35-44","Change ml female  45-54"," Change ml female 55-64"," Change ml female 65-74","change ml female 75+"]
[null,"change in consumption total",{"$f":"C75+C80+C85+C90+C95","v":{"v":-39.55062083439998,"d":"-39.6"}},{"$f":"D75+D80+D85+D90+D95","v":{"v":-58.309719331400046,"d":"-58.3"}},{"v":-61.3841815914001,"d":"-61.4"},{"v":-67.37217425740002,"d":"-67.4"},{"v":-53.98676781140007,"d":"-54.0"},{"v":-42.053457443400035,"d":"-42.1"},{"v":-40.267889859400064,"d":"-40.3"},{"v":-22.693087480400017,"d":"-22.7"},{"v":-17.818096405400013,"d":"-17.8"},{"v":-21.578079368400015,"d":"-21.6"},{"v":-33.24323262999997,"d":"-33.2"},{"v":-40.465387761,"d":"-40.5"},{"v":-40.34073245500004,"d":"-40.3"},{"v":-33.710421057999994,"d":"-33.7"},{"v":-30.405945525000007,"d":"-30.41"},{"v":-21.166471016000017,"d":"-21.17"},{"v":-15.777828986000026,"d":"-15.78"},{"v":-16.026673646000006,"d":"-16.03"},{"v":-15.404586162999998,"d":"-15.40"},{"v":-13.475975672999983,"d":"-13.48"}]
[null,"Ersatz change in consumption total ",{"$f":"_xll.ErRunOutput(C98,C99)","v":{"v":-39.55062083439998,"d":"-39.6"}},{"$f":"_xll.ErRunOutput(D98,D99)","v":{"v":-58.309719331400046,"d":"-58.3"}},{"$f":"_xll.ErRunOutput(E98,E99)","v":{"v":-61.3841815914001,"d":"-61.4"}},{"$f":"_xll.ErRunOutput(F98,F99)","v":{"v":-67.37217425740002,"d":"-67.4"}},{"$f":"_xll.ErRunOutput(G98,G99)","v":{"v":-53.98676781140007,"d":"-54.0"}},{"$f":"_xll.ErRunOutput(H98,H99)","v":{"v":-42.053457443400035,"d":"-42.1"}},{"$f":"_xll.ErRunOutput(I98,I99)","v":{"v":-40.267889859400064,"d":"-40.3"}},{"$f":"_xll.ErRunOutput(J98,J99)","v":{"v":-22.693087480400017,"d":"-22.7"}},{"$f":"_xll.ErRunOutput(K98,K99)","v":{"v":-17.818096405400013,"d":"-17.8"}},{"$f":"_xll.ErRunOutput(L98,L99)","v":{"v":-21.578079368400015,"d":"-21.6"}},{"$f":"_xll.ErRunOutput(M98,M99)","v":{"v":-33.24323262999997,"d":"-33.2"}},{"$f":"_xll.ErRunOutput(N98,N99)","v":{"v":-40.465387761,"d":"-40.5"}},{"$f":"_xll.ErRunOutput(O98,O99)","v":{"v":-40.34073245500004,"d":"-40.3"}},{"$f":"_xll.ErRunOutput(P98,P99)","v":{"v":-33.710421057999994,"d":"-33.7"}},{"$f":"_xll.ErRunOutput(Q98,Q99)","v":{"v":-30.405945525000007,"d":"-30.41"}},{"$f":"_xll.ErRunOutput(R98,R99)","v":{"v":-21.166471016000017,"d":"-21.17"}},{"$f":"_xll.ErRunOutput(S98,S99)","v":{"v":-15.777828986000026,"d":"-15.78"}},{"$f":"_xll.ErRunOutput(T98,T99)","v":{"v":-16.026673646000006,"d":"-16.03"}},{"$f":"_xll.ErRunOutput(U98,U99)","v":{"v":-15.404586162999998,"d":"-15.40"}},{"$f":"_xll.ErRunOutput(V98,V99)","v":{"v":-13.475975672999983,"d":"-13.48"}}]
[]
[]
["Change substitutes","Adjusted intake of fruit juice (g/day)",{"$f":"C41+(C41*$K$174*$C$73)","v":{"v":55.64001,"d":"55.6"}},{"v":55.64001,"d":"55.6"},{"v":55.64001,"d":"55.6"},{"v":55.64001,"d":"55.6"},{"v":55.64001,"d":"55.6"},{"v":55.64001,"d":"55.6"},{"v":55.64001,"d":"55.6"},{"v":55.64001,"d":"55.6"},{"v":55.64001,"d":"55.6"},{"v":55.64001,"d":"55.6"},{"v":44.81085,"d":"44.8"},{"v":44.81085,"d":"44.8"},{"v":44.81085,"d":"44.8"},{"v":44.81085,"d":"44.8"},{"v":44.81085,"d":"44.81"},{"v":44.81085,"d":"44.81"},{"v":44.81085,"d":"44.81"},{"v":44.81085,"d":"44.81"},{"v":44.81085,"d":"44.81"},{"v":44.81085,"d":"44.81"}]
[null,"Change in fruit juice consumption (g/day)",{"$f":"C103-C41","v":{"v":0,"d":"0.0"}},{"$f":"D103-D41","v":{"v":0,"d":"0.0"}},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"Change in kJ",{"$f":"C104*$C$157","v":{"v":0,"d":"0.0"}},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"Change in weight (kg) ",{"$f":"C105/C140","v":{"v":0,"d":"0.0"}},{"$f":"D105/C141","v":{"v":0,"d":"0.0"}},{"$f":"E105/C142","v":{"v":0,"d":"0.0"}},{"$f":"F105/100","v":{"v":0,"d":"0.0"}},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"$f":"M105/$C$143","v":{"v":0,"d":"0.0"}},{"$f":"N105/$C$144","v":{"v":0,"d":"0.0"}},{"$f":"O105/$C$145","v":{"v":0,"d":"0.0"}},{"v":0,"d":"0.0"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[]
[null,"Adjusted intake low fat milk (g/day)",{"$f":"C47+(C47*$K$176*$C$73)","v":{"v":60.65228,"d":"60.7"}},{"v":60.65228,"d":"60.7"},{"v":60.65228,"d":"60.7"},{"v":60.65228,"d":"60.7"},{"v":60.65228,"d":"60.7"},{"v":60.65228,"d":"60.7"},{"v":60.65228,"d":"60.7"},{"v":60.65228,"d":"60.7"},{"v":60.65228,"d":"60.7"},{"v":60.65228,"d":"60.7"},{"v":63.97512,"d":"64.0"},{"v":63.97512,"d":"64.0"},{"v":63.97512,"d":"64.0"},{"v":63.97512,"d":"64.0"},{"v":63.97512,"d":"63.98"},{"v":63.97512,"d":"63.98"},{"v":63.97512,"d":"63.98"},{"v":63.97512,"d":"63.98"},{"v":63.97512,"d":"63.98"},{"v":63.97512,"d":"63.98"}]
[null,"Change in milk consumption (g/day)",{"$f":"C108-C47","v":{"v":0,"d":"0.0"}},{"$f":"D108-D47","v":{"v":0,"d":"0.0"}},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"Change in kJ",{"$f":"C109*$C$158","v":{"v":0,"d":"0.0"}},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"Change in weight (kg) ",{"$f":"C110/C140","v":{"v":0,"d":"0.0"}},{"$f":"D110/C141","v":{"v":0,"d":"0.0"}},{"$f":"E110/C142","v":{"v":0,"d":"0.0"}},{"$f":"F110/100","v":{"v":0,"d":"0.0"}},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"$f":"M110/$C$143","v":{"v":0,"d":"0.0"}},{"$f":"N110/$C$144","v":{"v":0,"d":"0.0"}},{"$f":"O110/$C$145","v":{"v":0,"d":"0.0"}},{"v":0,"d":"0.0"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[]
[null,"Adjusted intake black tea (g/day)",{"$f":"C53+(C53*$K$177*$C$73)","v":{"v":148.2815,"d":"148.3"}},{"v":148.2815,"d":"148.3"},{"v":148.2815,"d":"148.3"},{"v":148.2815,"d":"148.3"},{"v":148.2815,"d":"148.3"},{"v":148.2815,"d":"148.3"},{"v":148.2815,"d":"148.3"},{"v":148.2815,"d":"148.3"},{"v":148.2815,"d":"148.3"},{"v":148.2815,"d":"148.3"},{"v":205.7128,"d":"205.7"},{"v":205.7128,"d":"205.7"},{"v":205.7128,"d":"205.7"},{"v":205.7128,"d":"205.7"},{"v":205.7128,"d":"205.71"},{"v":205.7128,"d":"205.71"},{"v":205.7128,"d":"205.71"},{"v":205.7128,"d":"205.71"},{"v":205.7128,"d":"205.71"},{"v":205.7128,"d":"205.71"}]
[null,"Change in tea consumption (g/day)",{"$f":"C113-C53","v":{"v":0,"d":"0.0"}},{"$f":"D113-D53","v":{"v":0,"d":"0.0"}},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"Change in kJ",{"$f":"C114*$C$159","v":{"v":0,"d":"0.0"}},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"Change in weight (kg) ",{"$f":"C115/C140","v":{"v":0,"d":"0.0"}},{"$f":"D115/C141","v":{"v":0,"d":"0.0"}},{"$f":"E115/C142","v":{"v":0,"d":"0.0"}},{"$f":"F115/100","v":{"v":0,"d":"0.0"}},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"$f":"M115/$C$143","v":{"v":0,"d":"0.0"}},{"$f":"N115/$C$144","v":{"v":0,"d":"0.0"}},{"$f":"O115/$C$145","v":{"v":0,"d":"0.0"}},{"v":0,"d":"0.0"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[]
[null,"Adjusted intake tea with milk (g/day)",{"$f":"C59+(C59*$K$177*$C$73)","v":{"v":3.797644,"d":"3.8"}},{"v":3.797644,"d":"3.8"},{"v":3.797644,"d":"3.8"},{"v":3.797644,"d":"3.8"},{"v":3.797644,"d":"3.8"},{"v":3.797644,"d":"3.8"},{"v":3.797644,"d":"3.8"},{"v":3.797644,"d":"3.8"},{"v":3.797644,"d":"3.8"},{"v":3.797644,"d":"3.8"},{"v":3.797644,"d":"3.8"},{"v":3.797644,"d":"3.8"},{"v":3.797644,"d":"3.8"},{"v":3.797644,"d":"3.8"},{"v":3.797644,"d":"3.80"},{"v":3.797644,"d":"3.80"},{"v":3.797644,"d":"3.80"},{"v":3.797644,"d":"3.80"},{"v":3.797644,"d":"3.80"},{"v":3.797644,"d":"3.80"}]
[null,"Change in tea consumption (g/day)",{"$f":"C118-C59","v":{"v":0,"d":"0.0"}},{"$f":"D118-D59","v":{"v":0,"d":"0.0"}},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"Change in kJ",{"$f":"C119*$C$160","v":{"v":0,"d":"0.0"}},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"Change in weight (kg) ",{"$f":"C120/C140","v":{"v":0,"d":"0.0"}},{"$f":"D120/C141","v":{"v":0,"d":"0.0"}},{"$f":"E120/C142","v":{"v":0,"d":"0.0"}},{"$f":"F120/100","v":{"v":0,"d":"0.0"}},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"$f":"M120/$C$143","v":{"v":0,"d":"0.0"}},{"$f":"N120/$C$144","v":{"v":0,"d":"0.0"}},{"$f":"O120/$C$145","v":{"v":0,"d":"0.0"}},{"v":0,"d":"0.0"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[]
[null,"Adjusted intake coffee black  (g/day)",{"$f":"C65+(C65*$K$178*$C$73)","v":{"v":138.4501,"d":"138.5"}},{"v":138.4501,"d":"138.5"},{"v":138.4501,"d":"138.5"},{"v":138.4501,"d":"138.5"},{"v":138.4501,"d":"138.5"},{"v":138.4501,"d":"138.5"},{"v":138.4501,"d":"138.5"},{"v":138.4501,"d":"138.5"},{"v":138.4501,"d":"138.5"},{"v":138.4501,"d":"138.5"},{"v":126.4924,"d":"126.5"},{"v":126.4924,"d":"126.5"},{"v":126.4924,"d":"126.5"},{"v":126.4924,"d":"126.5"},{"v":126.4924,"d":"126.49"},{"v":126.4924,"d":"126.49"},{"v":126.4924,"d":"126.49"},{"v":126.4924,"d":"126.49"},{"v":126.4924,"d":"126.49"},{"v":126.4924,"d":"126.49"}]
[null,"Change in coffee black consumption (g/day)",{"$f":"C123-C65","v":{"v":0,"d":"0.0"}},{"$f":"D123-D65","v":{"v":0,"d":"0.0"}},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"Change in kJ",{"$f":"C124*$C$164","v":{"v":0,"d":"0.0"}},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"Change in weight (kg) ",{"$f":"C125/C140","v":{"v":0,"d":"0.0"}},{"$f":"D125/C141","v":{"v":0,"d":"0.0"}},{"$f":"E125/C142","v":{"v":0,"d":"0.0"}},{"$f":"F125/100","v":{"v":0,"d":"0.0"}},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"$f":"M125/$C$143","v":{"v":0,"d":"0.0"}},{"$f":"N125/$C$144","v":{"v":0,"d":"0.0"}},{"$f":"O125/$C$145","v":{"v":0,"d":"0.0"}},{"v":0,"d":"0.0"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[]
[null,"Adjusted intake coffee white  (g/day)",{"$f":"C71+(C71*$K$178*$C$73)","v":{"v":53.6665,"d":"53.7"}},{"v":53.6665,"d":"53.7"},{"v":53.6665,"d":"53.7"},{"v":53.6665,"d":"53.7"},{"v":53.6665,"d":"53.7"},{"v":53.6665,"d":"53.7"},{"v":53.6665,"d":"53.7"},{"v":53.6665,"d":"53.7"},{"v":53.6665,"d":"53.7"},{"v":53.6665,"d":"53.7"},{"v":52.96699,"d":"53.0"},{"v":52.96699,"d":"53.0"},{"v":52.96699,"d":"53.0"},{"v":52.96699,"d":"53.0"},{"v":52.96699,"d":"52.97"},{"v":52.96699,"d":"52.97"},{"v":52.96699,"d":"52.97"},{"v":52.96699,"d":"52.97"},{"v":52.96699,"d":"52.97"},{"v":52.96699,"d":"52.97"}]
[null,"Change in coffee white consumption (g/day)",{"$f":"C128-C71","v":{"v":0,"d":"0.0"}},{"$f":"D128-D71","v":{"v":0,"d":"0.0"}},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"Change in kJ",{"$f":"C129*$C$164","v":{"v":0,"d":"0.0"}},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"Change in weight (kg) ",{"$f":"C130/C140","v":{"v":0,"d":"0.0"}},{"$f":"D130/C141","v":{"v":0,"d":"0.0"}},{"$f":"E130/C142","v":{"v":0,"d":"0.0"}},{"$f":"F130/100","v":{"v":0,"d":"0.0"}},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"$f":"M130/$C$143","v":{"v":0,"d":"0.0"}},{"$f":"N130/$C$144","v":{"v":0,"d":"0.0"}},{"$f":"O130/$C$145","v":{"v":0,"d":"0.0"}},{"v":0,"d":"0.0"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[]
[null,"change in overall weight ",{"$f":"C77+C82+C87+C92+C97+C106+C111+C116+C121+C126+C131","v":{"v":-0.2806510840135047,"d":"-0.28"}},{"$f":"D77+D82+D87+D92+D97+D106+D111+D116+D121+D126+D131","v":{"v":-0.6014672197007651,"d":"-0.60"}},{"v":-0.9732186925005075,"d":"-0.97"},{"v":-1.14034822605544,"d":"-1.14"},{"v":-0.9082367657626411,"d":"-0.91"},{"v":-0.6998447643602406,"d":"-0.70"},{"v":-0.6513569075850411,"d":"-0.65"},{"v":-0.38356317206384016,"d":"-0.38"},{"v":-0.29348547368504013,"d":"-0.29"},{"v":-0.3470550633614402,"d":"-0.35"},{"v":-0.2622895608960369,"d":"-0.26"},{"v":-0.4615278777013019,"d":"-0.46"},{"v":-0.6642148176471737,"d":"-0.66"},{"v":-0.5832790200351999,"d":"-0.58"},{"v":-0.5106370491780001,"d":"-0.51"},{"v":-0.3522042888728002,"d":"-0.35"},{"v":-0.2635037039072004,"d":"-0.26"},{"v":-0.2688805961216001,"d":"-0.27"},{"v":-0.2597730716187999,"d":"-0.26"},{"v":-0.23571286384439968,"d":"-0.24"}]
[]
[]
[]
[]
[null,"Energy balance Equations","Kj per kg"]
[null,"Adults",{"v":100,"d":"100.0"}]
[null,"boy (age 2-9, av age 5)",{"$f":"(68-2.5*5)*4.184","v":{"v":232.21200000000002,"d":"232.2"}}]
[null,"boy (age 10-14, av age 12)",{"$f":"(68-2.5*12)*4.184","v":{"v":158.99200000000002,"d":"159.0"}}]
[null,"boy (age 15-18, av age 17)",{"$f":"(68-2.5*17)*4.184","v":{"v":106.69200000000001,"d":"106.7"}}]
[null,"girl (age 2-9, av age 5)",{"$f":"(62-2.2*5)*4.184","v":{"v":213.38400000000001,"d":"213.4"}}]
[null,"girl (age 10-14, av age 12)",{"$f":"(62-2.2*12)*4.184","v":{"v":148.95039999999997,"d":"149.0"}}]
[null,"girl (age 15-18, av age 17)",{"$f":"(62-2.2*17)*4.184","v":{"v":102.92639999999999,"d":"102.9"}}]
[]
["Kilojoules per drink"]
["Drink type","kj/100ml","KJ/g","notes ","source"]
["soft drink, ",174,{"$f":"B149/100","v":1.74},"cola","Nutrient tables (NUTTAB 2010)  http://www.foodstandards.gov.au/science/monitoringnutrients/nutrientables/nuttab/Pages/default.aspx"]
["sports drink",113,1.13,"gatorade"]
["Energy drink",191,1.91,"energy drink"]
["fruit drink ",184,1.84,"orange 25%"]
["cordial concentrate ",740,7.4,"Cordial, 25% citrus fruit juice "]
["diluted cordial kj/g",148,1.48,"Cordial, 25% citrus fruit juice"]
["Diet soft drinks",0,0]
["bottled water ",0,0]
["Fruit juice ",116,1.16]
["low fat milk",212,2.12]
["tea ",6,0.06]
["         tea with milk",{"$f":"(B159+$B$157*0.31)","v":41.96},{"v":0.41960000000000003,"d":"0.42"}]
["Coffee instant",5,0.05,"instant"]
["         cappuccino",146,1.46,"cappuccino"]
["       coffee with milk",{"$f":"(B161+$C$158*31)","v":70.72},{"v":0.7071999999999999,"d":"0.71"},"with average milk 31g","http://www.foodstandards.gov.au/science/monitoringnutrients/ausnut/foodmeasures/Pages/2011-Dash-and-splash-measures-program.aspx"]
["           average coffee",{"$f":"AVERAGE(B162:B163)","v":{"v":108.36,"d":"108"}},{"$f":"AVERAGE(C162:C163)","v":{"v":1.0836,"d":"1.08"}},"average of instant and cappucino"]
[]
[]
["Price Elasticities: Impact of 20% valoric (flat) tax on consumption: all households (Sharma)",{"$nulls":3},"impact of 1% tax calculations"]
["% Change per capita Quantities of ","Direct effect","Indirect effect","Total effect (%)","Total effect ","SE","ersatz for ages","ersatz for tax","Z score 10% CI","Z score 5% CI","Notes"]
["Soft drinks",-12.63,1.1,-11.52,{"$f":"(1+D169/100)^0.05","v":{"v":0.9938990047065276,"d":"0.994"}},{"$f":"ABS((1-E169)/J169)","v":{"v":0.003112809874810155,"d":"0.00"}},{"v":0.9938990047065276,"d":"0.994"},{"$f":"_xll.ErNormal(E169,F169)","v":{"v":0.9938990047065276,"d":"0.994"}},{"v":1.6448536,"d":"1.64"},1.959964,"Z score with alpha 0.1 two tailed (probability .05) https://www.fourmilab.ch/rpkp/experiments/analysis/zCalc.html"]
["Cordial",-19.68,-13.54,-33.23,{"$f":"(1+D170/100)^0.05","v":{"v":0.980006754096646,"d":"0.980"}},{"$f":"ABS((1-E170)/J170)","v":{"v":0.010200823027032156,"d":"0.01"}},{"v":0.980006754096646,"d":"0.980"},{"$f":"_xll.ErNormal(E170,F170)","v":{"v":0.980006754096646,"d":"0.980"}},{"v":1.6448536,"d":"1.64"},1.959964]
["Fruit drink",-21.04,-4.25,-25.5,{"v":0.9853892353936474,"d":"0.985"},{"v":0.007454608659318527,"d":"0.01"},{"v":0.9853892353936474,"d":"0.985"},{"$f":"_xll.ErNormal(E171,F171)","v":{"v":0.9853892353936474,"d":"0.985"}},{"v":1.6448536,"d":"1.64"},1.959964]
["Diet soft drinks",0,3.17,3.17,{"v":1.0015616144080695,"d":"1.002"},{"v":7.9675667923974933E-4,"d":"0.00"},{"v":1.0015616144080695,"d":"1.002"},{"$f":"_xll.ErNormal(E172,F172)","v":{"v":1.0015616144080695,"d":"1.002"}},{"v":1.6448536,"d":"1.64"},1.959964]
["Bottled water",0,1.58,1.58,{"v":1.0007841312395345,"d":"1.001"},{"v":4.0007430724976024E-4,"d":"0.00"},{"v":1.0007841312395345,"d":"1.001"},{"$f":"_xll.ErNormal(E173,F173)","v":{"v":1.0007841312395345,"d":"1.001"}},{"v":1.6448536,"d":"1.64"},1.959964]
["Fruit juice",0,0.67,0.67,{"v":1.0003339384827072,"d":"1.000"},{"v":1.7037990631830029E-4,"d":"0.00"},{"v":1.0003339384827072,"d":"1.000"},{"$f":"_xll.ErNormal(E174,F174)","v":{"v":1.0003339384827072,"d":"1.000"}},{"v":1.6448536,"d":"1.64"},1.959964]
["High-fat milk",0,0,0]
["Low-fat milk",0,1.13,1.13,{"v":1.0005619894532323,"d":"1.001"},{"v":2.8673457942710685E-4,"d":"0.00"},{"v":1.0005619894532323,"d":"1.001"},{"$f":"_xll.ErNormal(E176,F176)","v":{"v":1.0005619894532323,"d":"1.001"}},{"v":1.6448536,"d":"1.64"},1.959964]
["Tea",0,1.88,1.88,{"v":1.0009317069756927,"d":"1.001"},{"v":4.7536943315931816E-4,"d":"0.00"},{"v":1.0009317069756927,"d":"1.001"},{"$f":"_xll.ErNormal(E177,F177)","v":{"v":1.0009317069756927,"d":"1.001"}},{"v":1.6448536,"d":"1.64"},1.959964]
["Coffee",0,-0.13,-0.13,{"v":0.9999349598285513,"d":"1.000"},{"v":3.318437045206176E-5,"d":"0.00"},{"v":0.9999349598285513,"d":"1.000"},{"$f":"_xll.ErNormal(E178,F178)","v":{"v":0.9999349598285513,"d":"1.000"}},{"v":1.6448536,"d":"1.64"},1.959964]
{"$rows_empty":27}
[{"$nulls":4},"Age multiplier effect for quintile data ",null,"Fractions of totals"]
[null,"For calculation of tax on sport and energy drinks","total ",null,null,"mean intake "," 2-9","10-14 yrs","15-19"," 20-24"," 25-34","35-44"," 45-54"," 55-64"," 65-74","75+"]
[null,"Mean intake fizzy drinks (g/day)",{"v":101.6559,"d":"101.66"},null,"males soft drinks",{"v":130.1861,"d":"130.2"},{"$f":"C3/$F$208","v":{"v":0.3219677062297741,"d":"0.32"}},{"$f":"D3/$F$208","v":{"v":1.101091437565147,"d":"1.10"}},{"v":2.255246143789544,"d":"2.26"},{"v":1.5489940938395113,"d":"1.55"},{"v":1.683773459685788,"d":"1.68"},{"v":1.0131888120160293,"d":"1.01"},{"v":0.9671270588795576,"d":"0.97"},{"v":0.659585777590695,"d":"0.66"},{"v":0.34312004123328066,"d":"0.34"},{"v":0.2740589049061305,"d":"0.27"}]
[null,"Relative standard error of estimate (%)",{"v":2.947407,"d":"2.95"},null,"females soft drinks",{"v":72.67741,"d":"72.7"},{"$f":"M3/$F$209","v":{"v":0.6268348032765615,"d":"0.63"}},{"$f":"N3/$F$209","v":{"v":1.6549475277118435,"d":"1.65"}},{"v":2.1327933948114004,"d":"2.13"},{"v":1.6238525836294937,"d":"1.62"},{"v":1.25788343310528,"d":"1.26"},{"v":1.0208826924349672,"d":"1.02"},{"v":0.9283528403117284,"d":"0.93"},{"v":0.5278923671055422,"d":"0.53"},{"v":0.4754968565885878,"d":"0.48"},{"v":0.40154856921841325,"d":"0.40"}]
[null,"Lower 95% confidence interval of the mean",{"v":95.75812,"d":"95.76"},null,"males fruit drink",{"v":41.25635,"d":"41.3"},{"$f":"C21/$F$210","v":{"v":1.4526255958173713,"d":"1.45"}},{"$f":"D21/$F$210","v":{"v":1.3619013800299833,"d":"1.36"}},{"v":1.1389301283317599,"d":"1.14"},{"v":2.219336174916104,"d":"2.22"},{"v":1.1826450958458516,"d":"1.18"},{"v":1.0339739215902521,"d":"1.03"},{"v":0.4988914433778073,"d":"0.50"},{"v":0.6125704285522108,"d":"0.61"},{"v":0.465031928418292,"d":"0.47"},{"v":0.4812640963148703,"d":"0.48"}]
[null,"Upper 95% confidence interval of the mean",{"v":107.5536,"d":"107.55"},null,"females fruit drink",{"v":32.45382,"d":"32.5"},{"$f":"M21/$F$211","v":{"v":1.8267116166910395,"d":"1.83"}},{"$f":"N21/$F$211","v":{"v":1.7762112441617042,"d":"1.78"}},{"v":1.361603965265106,"d":"1.36"},{"v":1.6581212935796157,"d":"1.66"},{"v":1.1288224313809592,"d":"1.13"},{"v":0.5740060800238616,"d":"0.57"},{"v":0.3412482721602572,"d":"0.34"},{"v":0.6907091368596978,"d":"0.69"},{"v":0.7323279663226085,"d":"0.73"},{"v":0.9368404089256673,"d":"0.94"}]
[null,"ersatz",{"$f":"_xll.ErLognormal(C208,C209)","v":{"v":101.6559,"d":"101.66"}},null,"males cordial",{"v":42.13393,"d":"42.1"},{"$f":"C27/$F$212","v":{"v":1.2294884431620785,"d":"1.23"}},{"$f":"D27/$F$212","v":{"v":1.8029210662285717,"d":"1.80"}},{"v":0.9537622054244643,"d":"0.95"},{"v":1.3261395269798,"d":"1.33"},{"v":1.0047092687532353,"d":"1.00"},{"v":0.9824122743831397,"d":"0.98"},{"v":1.3062799980917992,"d":"1.31"},{"v":0.29504439770987423,"d":"0.30"},{"v":0.3967037966788287,"d":"0.40"},{"v":0.7270316345994784,"d":"0.73"}]
[null,"Adjusted mean intake of fizzy drink (g/day)",{"$f":"C212*($H$169^$C$73)","v":{"v":89.94514031999996,"d":"89.95"}},null,"females cordial",{"v":22.12166,"d":"22.1"},{"$f":"M27/$F$213","v":{"v":1.6672383537220987,"d":"1.67"}},{"$f":"N27/$F$213","v":{"v":1.5355931697711656,"d":"1.54"}},{"v":1.4411554105794955,"d":"1.44"},{"v":0.7850387357910754,"d":"0.79"},{"v":1.348213018372039,"d":"1.35"},{"v":0.9858563959485861,"d":"0.99"},{"v":0.62023374376064,"d":"0.62"},{"v":0.7167689947318602,"d":"0.72"},{"v":0.6449647087967179,"d":"0.64"},{"v":0.23659029204860757,"d":"0.24"}]
[{"$nulls":4},"total means male ",{"$f":"F208+F210+F212","v":{"v":213.57638,"d":"213.6"}},{"$f":"(C3+C21+C27)/$F$214","v":{"v":0.7194097493365137,"d":"0.72"}},{"$f":"(D3+D21+D27)/$F$214","v":{"v":1.2899274254952726,"d":"1.29"}},{"v":1.7828542182426725,"d":"1.78"},{"v":1.634519135496163,"d":"1.63"},{"v":1.4530065075548149,"d":"1.45"},{"v":1.0111323171597906,"d":"1.01"},{"v":0.9435858497086616,"d":"0.94"},{"v":0.5785878569530957,"d":"0.58"},{"v":0.37724054504529014,"d":"0.38"},{"v":0.40344611140988534,"d":"0.40"}]
[null,"Mean intake sports drinks (g/day)",{"v":7.735497,"d":"7.74"},null,"total means female",{"$f":"F209+F211+F213","v":{"v":127.25288999999998,"d":"127.3"}},{"$f":"(M3+M21+M27)/($F$215)","v":{"v":1.113708144467289,"d":"1.11"}},{"$f":"(N3+N21+N27)/($F$215)","v":{"v":1.6651253264267716,"d":"1.67"}},{"v":1.8158793878865938,"d":"1.82"},{"v":1.4867727562022364,"d":"1.49"},{"v":1.2406713906458235,"d":"1.24"},{"v":0.9008249635823596,"d":"0.90"},{"v":0.7250577177461355,"d":"0.73"},{"v":0.6022505264909899,"d":"0.60"},{"v":0.5704578497195625,"d":"0.57"},{"v":0.5093898456844477,"d":"0.51"}]
[null,"Relative standard error of estimate (%)",{"v":0.8580187,"d":"0.86"}]
[null,"Lower 95% confidence interval of the mean",{"v":6.018605,"d":"6.02"}]
[null,"Upper 95% confidence interval of the mean",{"v":9.452388,"d":"9.45"}]
[null,"ersatz",{"$f":"_xll.ErLognormal(C215,C216)","v":{"v":7.735497,"d":"7.74"}}]
[null,"Adjusted mean intake of sports drink (g/day)",{"$f":"C219*($H$169^$C$73)","v":{"v":6.844367745599996,"d":"6.84"}}]
[]
[null,"Mean intake energy drinks (g/day)",{"v":4.677241,"d":"4.68"}]
[null,"Relative standard error of estimate (%)",{"v":0.4835224,"d":"0.48"}]
[null,"Lower 95% confidence interval of the mean",{"v":3.709715,"d":"3.71"}]
[null,"Upper 95% confidence interval of the mean",{"v":5.644767,"d":"5.64"}]
[null,"ersatz",{"$f":"_xll.ErLognormal(C222,C223)","v":{"v":4.677241,"d":"4.68"}}]
[null,"Adjusted mean intake of energy drink (g/day)",{"$f":"C226*($H$169^$C$73)","v":{"v":4.1384228367999984,"d":"4.14"}}]
[]
[null,"Mean intake cordial made (g/day)",{"v":32.06597,"d":"32.07"}]
[null,"Relative standard error of estimate (%)",{"v":2.207605,"d":"2.21"}]
[null,"Lower 95% confidence interval of the mean",{"v":27.64857,"d":"27.65"}]
[null,"Upper 95% confidence interval of the mean",{"v":36.48338,"d":"36.48"}]
[null,"ersatz",{"$f":"_xll.ErLognormal(C229,C230)","v":{"v":32.06597,"d":"32.07"}}]
[null,"Adjusted mean intake of cordial (g/day)",{"$f":"C233*($H$170^$C$73)","v":{"v":21.410448168999984,"d":"21.41"}}]
[]
[]
[null,"Mean intake fruit drink(g/day)",{"v":36.84169,"d":"36.84"}]
[null,"Relative standard error of estimate (%)",{"v":1.805232,"d":"1.81"}]
[null,"Lower 95% confidence interval of the mean",{"v":33.22942,"d":"33.23"}]
[null,"Upper 95% confidence interval of the mean",{"v":40.45395,"d":"40.45"}]
[null,"ersatz",{"$f":"_xll.ErLognormal(C237,C238)","v":{"v":36.84169,"d":"36.84"}}]
[null,"Adjusted mean intake of fruit drink (g/day)",{"$f":"C241*($H$171^$C$73)","v":{"v":27.44705905000004,"d":"27.45"}}]

{"sheet":"Calc-costs Aus pop ","index":2,"n_rows":135,"n_cols":41,"rows_kept":135,"merged":[[2,1,2,31],[2,32,2,40],[11,1,11,31],[11,32,11,40],[25,1,25,31],[25,32,25,40],[37,1,37,31],[37,32,37,40],[52,10,57,10],[91,2,91,3],[92,5,92,7],[93,5,93,7],[94,5,94,7],[95,5,95,7],[96,5,96,7],[98,5,98,7],[99,5,99,7],[100,5,100,7],[101,5,101,7],[102,5,102,7],[103,5,103,7],[108,9,108,11],[109,5,109,8],[110,5,110,8]]}
["Cost Calculations "]
["C1 costs (Healthcare sector)"]
[null,"Base case",{"$nulls":30},"Sensitivity Analysis values"]
["Cost item","Mean unit cost","SD","SE","Upper CI","Lower CI","Distribution used in Ersatz","min","max","n","a","B","ersatz distrubution calculation","ersatz output calculation","Source","Assumptions/ comments","Resouce use","SD","SE","Upper CI","Lower CI","Distribution used in Ersatz","min","max","n","a","B","ersatz distrubution calculation","ersatz output calculation","Source ","Assumptions/ comments","Cost","Lowest value found","Highest value found","SD","Distribution used in Ersatz","Calculated upper CI","Calculated Lower CI","Source","Comments","Assumptions"]
[{"$nulls":31},"=N4*AC4"]
[]
["Total C1 cost",{"$nulls":30},"=sum(N4,N5)"]
["C1 cost Upper CI",{"$nulls":30},"based on AF6"]
["C1 cost Lower CI",{"$nulls":30},"based on AF6"]
[]
["C2a costs (Government, cost of legislation"]
[null,"Base case",{"$nulls":30},"Sensitivity Analysis values"]
["Cost item","Mean unit cost","SD","SE","Upper CI","Lower CI","Distribution used in Ersatz","min","max","n","a","B","ersatz distrubution calculation","ersatz output calculation","Source","Assumptions/ comments","Resouce use","SD","SE","Upper CI","Lower CI","Distribution used in Ersatz","min","max","n","a","B","ersatz distrubution calculation","ersatz output calculation","Source ","Assumptions/ comments","Cost","Lowest value found","Highest value found","SD","Distribution used in Ersatz","Calculated upper CI","Calculated Lower CI","Source","Comments","Assumptions"]
["G Tax department accountant salary",{"$f":"B100","v":{"v":84888.95999999999,"d":"84,889"}},null,{"$f":"$E$100","v":{"v":3250,"d":"3,250"}},{"$f":"B14+(1.96*D14)","v":{"v":91258.95999999999,"d":"91,259"}},{"$f":"B14-(1.96*D14)","v":{"v":78518.95999999999,"d":"78,519"}},"Gamma",{"$nulls":3},{"$f":"(B14*B14)/(D14*D14)","v":{"v":682.2376833023999,"d":"682"}},{"$f":"(D14*D14)/B14","v":{"v":124.42725178868962,"d":"124"}},{"$f":"_xll.ErGamma(K14,L14)","v":{"v":84888.95999999999,"d":"84,889"}},{"$f":"_xll.ErRunOutput(A14,M14)","v":{"v":84888.95999999999,"d":"84,889"}},"ABS G93",null,{"$f":"B93","v":{"v":0.32,"d":"0"}},null,{"$f":"(T14-Q14)/1.96","v":{"v":0.11224489795918369,"d":"0"}},{"$f":"D93","v":{"v":0.54,"d":"1"}},{"$f":"C93","v":{"v":0.1,"d":"0"}},"gamma",{"v":0.09,"d":"0"},{"v":0.55,"d":"1"},null,{"$f":"(Q14*Q14)/(U14*U14)","v":{"v":10.239999999999998,"d":"10"}},{"$f":"(U14*U14)/Q14","v":{"v":0.03125000000000001,"d":"0"}},{"$f":"_xll.ErGamma(Z14,AA14)","v":{"v":0.32,"d":"0"}},null,"Samples drawn from a uniform distribution (min=0.09, max=0.55) data from personal communications with Washington and West Virginia State Departments of Revenue; (Long 2015)","Government administration and compliance time costs per million people per year (FTE)",{"$f":"AB14*M14*B66","v":{"v":564797.7888264192,"d":"564,798"}}]
["G Field audit salary ",{"$f":"B100","v":{"v":84888.95999999999,"d":"84,889"}},null,{"$f":"$E$100","v":{"v":3250,"d":"3,250"}},{"$f":"B15+(1.96*D15)","v":{"v":91258.95999999999,"d":"91,259"}},{"$f":"B15-(1.96*D15)","v":{"v":78518.95999999999,"d":"78,519"}},"Gamma",{"$nulls":3},{"$f":"(B15*B15)/(D15*D15)","v":{"v":682.2376833023999,"d":"682"}},{"$f":"(D15*D15)/B15","v":{"v":124.42725178868962,"d":"124"}},{"$f":"_xll.ErGamma(K15,L15)","v":{"v":84888.95999999999,"d":"84,889"}},{"$f":"_xll.ErRunOutput(A15,M15)","v":{"v":84888.95999999999,"d":"84,889"}},"ABS G93",null,{"$f":"B94","v":{"v":0.3,"d":"0"}},null,{"$f":"(T15-Q15)/1.96","v":{"v":0.025510204081632647,"d":"0"}},{"$f":"D94","v":{"v":0.35,"d":"0"}},{"$f":"C94","v":{"v":0.24,"d":"0"}},"gamma",{"v":0.223,"d":"0"},{"v":0.371,"d":"0"},null,{"$f":"(Q15*Q15)/(S15*S15)","v":{"v":138.29760000000007,"d":"138"}},{"$f":"(S15*S15)/Q15","v":{"v":2.1692350409551566E-3,"d":"0"}},{"$f":"_xll.ErGamma(Z15,AA15)","v":{"v":0.30000000000000004,"d":"0"}},null," based on an estimate of field audit time ( +or-25%) from a personal communication with West Virginia State Department of Revenue (Long 2015)","Government administration and compliance time costs per million people per year (FTE)",{"$f":"AB15*M15*B66","v":{"v":529497.927024768,"d":"529,498"}}]
["G Field audit direct costs",{"$f":"B96","v":{"v":13780.28169,"d":"13,780"}},null,{"$f":"(E16-B16)/1.96","v":{"v":1755.772209183673,"d":"1,756"}},{"$f":"D96","v":{"v":17221.59522,"d":"17,222"}},{"$f":"I95","v":{"v":10325.443346999999,"d":"10,325"}},"Gamma",{"$nulls":3},{"$f":"(B16*B16)/(D16*D16)","v":{"v":61.599877622470984,"d":"62"}},{"$f":"(D16*D16)/B16","v":{"v":223.70631601665875,"d":"224"}},{"$f":"_xll.ErGamma(K16,L16)","v":{"v":13780.28169,"d":"13,780"}},{"$f":"_xll.ErRunOutput(A16,M16)","v":{"v":13780.28169,"d":"13,780"}},"Long F89",null,{"$f":"B66","v":{"v":20.791786,"d":"21"}},{"$nulls":12},"ABS census 2011","Australian population millions",{"$f":"M16*Q16","v":{"v":286516.66791819833,"d":"286,517"}}]
["G Tax certification system operating costs",{"$f":"B98","v":{"v":17882.8083,"d":"17,883"}},null,{"$f":"(E17-B17)/1.96","v":{"v":2683.4946428571425,"d":"2,683"}},{"$f":"D98","v":{"v":23142.4578,"d":"23,142"}},{"$f":"C98","v":{"v":12563.048519999998,"d":"12,563"}},"Gamma",{"$nulls":3},{"$f":"(B17*B17)/(D17*D17)","v":{"v":44.40889600000001,"d":"44"}},{"$f":"(D17*D17)/B17","v":{"v":402.685270536786,"d":"403"}},{"$f":"_xll.ErGamma(K17,L17)","v":{"v":17882.808299999997,"d":"17,883"}},{"$f":"_xll.ErRunOutput(A17,M17)","v":{"v":17882.808299999997,"d":"17,883"}},"Long F92",null,{"$f":"B66","v":{"v":20.791786,"d":"21"}},{"$nulls":12},"ABS census 2012","Australian population millions",{"$f":"M17*Q17","v":{"v":371815.5232526237,"d":"371,816"}}]
["Passing Legislation in parliament ",{"$f":"H135","v":{"v":1089686.8553756794,"d":"1,089,687"}},null,{"$f":"(F18-B18)/1.96","v":{"v":-68621.86828659075,"d":"-68,622"}},{"$f":"C135","v":{"v":1241580.3111841986,"d":"1,241,580.31"}},{"$f":"E135","v":{"v":955187.9935339616,"d":"955,188"}},"Gamma",{"$nulls":3},{"$f":"(B18*B18)/(D18*D18)","v":{"v":252.16124988289317,"d":"252"}},{"$f":"(D18*D18)/B18","v":{"v":4321.38901548808,"d":"4,321"}},{"$f":"_xll.ErGamma(K18,L18)","v":{"v":1089686.8553756794,"d":"1,089,687"}},{"$f":"_xll.ErRunOutput(A18,M18)","v":{"v":1089686.8553756794,"d":"1,089,687"}},"see below","average cost 2010-2015",{"$nulls":13},"Various","One off cost in first year",{"$f":"M18","v":{"v":1089686.8553756794,"d":"1,089,687"}}]
["Total C2a cost year 1",{"$f":"SUM(AF14:AF18)","v":{"v":2842314.762397689,"d":"2,842,315"}},{"$nulls":11},{"$f":"_xll.ErRunOutput(A19,B19)","v":{"v":2842314.762397689,"d":"2,842,315"}}]
["C2a cost year 1 Upper CI"]
["C2a cost year 1 Lower CI"]
["Total C2a cost year 2-10",{"$f":"B19-M18","v":{"v":1752627.9070220094,"d":"1,752,628"}},{"$nulls":11},{"$f":"_xll.ErRunOutput(A22,B19-AF18)","v":{"v":1752627.9070220094,"d":"1,752,628"}}]
["C2a cost Upper CI"]
["C2a cost Lower CI"]
["C2b costs Industry"]
[null,"Base case",{"$nulls":30},"Sensitivity Analysis values"]
["Cost item","Mean unit cost","SD","SE","Upper CI","Lower CI","Distribution used in Ersatz","min","max","n","a","B","ersatz distrubution calculation","ersatz output calculation","Source","Assumptions/ comments","Resouce use","SD","SE","Upper CI","Lower CI","Distribution used in Ersatz","min","max","n","a","B","ersatz distrubution calculation","ersatz output calculation","Source ","Assumptions/ comments","Cost","Lowest value found","Highest value found","SD","Distribution used in Ersatz","Calculated upper CI","Calculated Lower CI","Source","Comments","Assumptions"]
["Tax department accountant salary",{"$f":"$B$102","v":{"v":98422.58399999999,"d":"98,423"}},null,{"$f":"$E$102","v":{"v":5044,"d":"5,044"}},{"$f":"B28+(1.96*D28)","v":{"v":108308.824,"d":"108,309"}},{"$f":"B28-(1.96*D28)","v":{"v":88536.34399999998,"d":"88,536"}},"Gamma",{"$nulls":3},{"$f":"(B28*B28)/(D28*D28)","v":{"v":380.74952477032616,"d":"381"}},{"$f":"(D28*D28)/B28","v":{"v":258.49693196431423,"d":"258"}},{"$f":"_xll.ErGamma(K28,L28)","v":{"v":98422.58399999997,"d":"98,423"}},{"$f":"_xll.ErRunOutput(A28,M28)","v":{"v":98422.58399999997,"d":"98,423"}},null,null,{"$f":"Q14","v":{"v":0.32,"d":"0"}},{"$nulls":3},{"$f":"U14","v":{"v":0.1,"d":"0"}},"gamma",{"$f":"W14","v":{"v":0.09,"d":"0"}},{"$f":"X14","v":{"v":0.55,"d":"1"}},null,{"$f":"(Q28*Q28)/(U28*U28)","v":{"v":10.239999999999998,"d":"10"}},{"$f":"(U28*U28)/Q28","v":{"v":0.03125000000000001,"d":"0"}},{"$f":"_xll.ErGamma(Z28,AA28)","v":{"v":0.32,"d":"0"}},null,"as above","Government administration and compliance time costs per million people per year (FTE)",{"$f":"AB28*M28*B66","v":{"v":654842.0173104075,"d":"654,842"}}]
["Field audit salary ",{"$f":"$B$102","v":{"v":98422.58399999999,"d":"98,423"}},null,{"$f":"$E$102","v":{"v":5044,"d":"5,044"}},{"$f":"B29+(1.96*D29)","v":{"v":108308.824,"d":"108,309"}},{"$f":"B29-(1.96*D29)","v":{"v":88536.34399999998,"d":"88,536"}},"Gamma",{"$nulls":3},{"$f":"(B29*B29)/(D29*D29)","v":{"v":380.74952477032616,"d":"381"}},{"$f":"(D29*D29)/B29","v":{"v":258.49693196431423,"d":"258"}},{"$f":"_xll.ErGamma(K29,L29)","v":{"v":98422.58399999997,"d":"98,423"}},{"$f":"_xll.ErRunOutput(A29,M29)","v":{"v":98422.58399999997,"d":"98,423"}},null,null,{"$f":"Q15","v":{"v":0.3,"d":"0"}},null,{"$f":"S15","v":{"v":0.025510204081632647,"d":"0"}},null,{"$f":"U15","v":{"v":0.24,"d":"0"}},"gamma",{"$f":"W15","v":{"v":0.223,"d":"0"}},{"$f":"X15","v":{"v":0.371,"d":"0"}},null,{"$f":"(Q29*Q29)/(U29*U29)","v":{"v":1.5625,"d":"2"}},{"$f":"(U29*U29)/Q29","v":{"v":0.192,"d":"0"}},{"$f":"_xll.ErGamma(Z29,AA29)","v":{"v":0.3,"d":"0"}},null,"as above","Government administration and compliance time costs per million people per year (FTE)",{"$f":"AB29*M29*B66","v":{"v":613914.3912285069,"d":"613,914"}}]
["Field audit direct costs",{"v":13780.28169,"d":"13,780"},null,{"v":1755.772209183673,"d":"1,756"},{"$f":"K95","v":{"v":17221.59522,"d":"17,222"}},{"v":10325.443346999999,"d":"10,325"},"Gamma",{"$nulls":3},{"$f":"(B30*B30)/(D30*D30)","v":{"v":61.599877622470984,"d":"62"}},{"$f":"(D30*D30)/B30","v":{"v":223.70631601665875,"d":"224"}},{"$f":"_xll.ErGamma(K30,L30)","v":{"v":13780.28169,"d":"13,780"}},{"$f":"_xll.ErRunOutput(A30,M30)","v":{"v":13780.28169,"d":"13,780"}},"Long F89",null,{"$f":"B66","v":{"v":20.791786,"d":"21"}},{"$nulls":12},"as above",null,{"$f":"M30*Q30","v":{"v":286516.66791819833,"d":"286,517"}}]
["Tax certification system operating costs",{"v":17882.8083,"d":"17,883"},null,{"v":2683.4946428571425,"d":"2,683"},{"v":23142.4578,"d":"23,142"},{"v":12563.048519999998,"d":"12,563"},"Gamma",{"$nulls":3},{"$f":"(B31*B31)/(D31*D31)","v":{"v":44.40889600000001,"d":"44"}},{"$f":"(D31*D31)/B31","v":{"v":402.685270536786,"d":"403"}},{"$f":"_xll.ErGamma(K31,L31)","v":{"v":17882.808299999997,"d":"17,883"}},{"$f":"_xll.ErRunOutput(A31,M31)","v":{"v":17882.808299999997,"d":"17,883"}},"Long F92",null,{"$f":"B66","v":{"v":20.791786,"d":"21"}},{"$nulls":12},"ABS census 2012","Australian population millions",{"$f":"M31*Q31","v":{"v":371815.5232526237,"d":"371,816"}}]
["Total C2b cost",{"$f":"SUM(AF28:AF31)","v":{"v":1927088.5997097362,"d":"1,927,089"}},{"$nulls":11},{"$f":"_xll.ErRunOutput(A32,B32)","v":{"v":1927088.5997097362,"d":"1,927,089"}}]
["C2b cost Upper CI"]
["C2b cost Lower CI"]
["Total costs C2 10 years",{"$f":"N19+N32+N22*9","v":{"v":20543054.52530551,"d":"20,543,055"}},{"$nulls":11},{"$f":"_xll.ErRunOutput(A36,B35)","v":{"v":20543054.52530551,"d":"20,543,055"}}]
["Total costs 10 years"]
["C3 costs  (patient and family)"]
[null,"Base case",{"$nulls":30},"Sensitivity Analysis values"]
["Cost item","Mean unit cost","SD","SE","Upper CI","Lower CI","Distribution used in Ersatz","min","max","n","a","B","ersatz distrubution calculation","ersatz output calculation","Source","Assumptions/ comments","Resouce use","SD","SE","Upper CI","Lower CI","Distribution used in Ersatz","min","max","n","a","B","ersatz distrubution calculation","ersatz output calculation","Source ","Assumptions/ comments","Cost","Lowest value found","Highest value found","SD","Distribution used in Ersatz","Calculated upper CI","Calculated Lower CI","Source","Comments","Assumptions"]
["Tax per fizzy drinks",{"$f":"B60","v":{"v":0.5823333333333334,"d":"$0.58"}},null,{"$f":"(I40-B40)/1.96","v":{"v":0.2855442176870749,"d":"0.29"}},null,null,"Gamma",{"$f":"B61","v":{"v":0.15000000000000002,"d":"$0.15"}},{"$f":"B62","v":{"v":1.1420000000000001,"d":"$1.14"}},null,{"$f":"(B40*B40)/(D40*D40)","v":{"v":4.159073165094086,"d":"4.16"}},{"$f":"(D40*D40)/B40","v":{"v":0.14001516929797986,"d":"0.14"}},{"$f":"_xll.ErGamma(K40,L40)","v":{"v":0.5823333333333334,"d":"0.58"}},{"$f":"_xll.ErRunOutput(A40,M40)","v":{"v":0.5823333333333334,"d":"0.58"}},"coles online","20% of price per litre",{"$f":"C69*M40*365*$A$66","v":{"v":397497146.0929123,"d":"397,497,146"}},{"$nulls":12},"Sharma 2014","Tax burden - the additional cost of beverage attributed to SSB tax. ",{"$f":"Q40","v":{"v":397497146.0929123,"d":"397,497,146"}},{"$f":"B61","v":{"v":0.15000000000000002,"d":"$0.15"}},{"$f":"B62","v":{"v":1.1420000000000001,"d":"$1.14"}}]
["Tax per Sports drinks",{"$f":"D60","v":{"v":1.1133333333333335,"d":"$1.11"}},null,{"$f":"(I41-B41)/1.96","v":{"v":0.05952380952380954,"d":"0.06"}},null,null,"Gamma",{"$f":"D61","v":{"v":0.8800000000000001,"d":"$0.88"}},{"$f":"D62","v":{"v":1.2300000000000002,"d":"$1.23"}},null,{"$f":"(B41*B41)/(D41*D41)","v":{"v":349.8396159999999,"d":"349.84"}},{"$f":"(D41*D41)/B41","v":{"v":3.18241068882643E-3,"d":"0.00"}},{"$f":"_xll.ErGamma(K41,L41)","v":{"v":1.1133333333333335,"d":"1.11"}},{"$f":"_xll.ErRunOutput(A41,M41)","v":{"v":1.1133333333333335,"d":"1.11"}},"coles online","20% of price per litre",{"$f":"C70*M41*365*$A$66","v":{"v":57828670.66303094,"d":"57,828,671"}},{"$nulls":13},"Tax burden - the additional cost of beverage attributed to SSB tax. ",{"$f":"Q41","v":{"v":57828670.66303094,"d":"57,828,671"}}]
["Tax per Energy Drinks",{"$f":"F60","v":{"v":2.1013333333333333,"d":"$2.10"}},null,{"$f":"(I42-B42)/1.96","v":{"v":0.2748299319727892,"d":"0.27"}},null,null,"Gamma",{"$f":"F61","v":{"v":1.4000000000000001,"d":"$1.40"}},{"$f":"F62","v":{"v":2.64,"d":"$2.64"}},null,{"$f":"(B42*B42)/(D42*D42)","v":{"v":58.46040756788546,"d":"58.46"}},{"$f":"(D42*D42)/B42","v":{"v":0.03594455496898855,"d":"0.04"}},{"$f":"_xll.ErGamma(K42,L42)","v":{"v":2.1013333333333333,"d":"2.10"}},{"$f":"_xll.ErRunOutput(A42,M42)","v":{"v":2.1013333333333333,"d":"2.10"}},"coles online","20% of price per litre",{"$f":"C71*M42*365*$A$66","v":{"v":65995522.66483826,"d":"65,995,523"}},{"$nulls":13},"Tax burden - the additional cost of beverage attributed to SSB tax. ",{"$f":"Q42","v":{"v":65995522.66483826,"d":"65,995,523"}}]
["Tax per Cordial",{"$f":"J60","v":{"v":1.0955000000000001,"d":"$1.10"}},null,{"$f":"(I43-B43)/1.96","v":{"v":0.33801020408163257,"d":"0.34"}},null,null,"Gamma",{"$f":"J61","v":{"v":1.054,"d":"$1.05"}},{"$f":"J62","v":{"v":1.758,"d":"$1.76"}},null,{"$f":"(B43*B43)/(D43*D43)","v":{"v":10.504252223339273,"d":"10.50"}},{"$f":"(D43*D43)/B43","v":{"v":0.10429109818649648,"d":"0.10"}},{"$f":"_xll.ErGamma(K43,L43)","v":{"v":1.0955000000000001,"d":"1.10"}},{"$f":"_xll.ErRunOutput(A43,M43)","v":{"v":1.0955000000000001,"d":"1.10"}},"coles online","20% of price per litre",{"$f":"C72*M43*365*$A$66","v":{"v":17800114.709002543,"d":"17,800,115"}},{"$nulls":13},"Tax burden - the additional cost of beverage attributed to SSB tax. ",{"$f":"Q43","v":{"v":17800114.709002543,"d":"17,800,115"}}]
["Tax per Fruit drink",{"$f":"H60","v":{"v":0.5086666666666666,"d":"$0.51"}},null,{"$f":"(I44-B44)/1.96","v":{"v":0.06360544217687077,"d":"0.06"}},null,null,"Gamma",{"$f":"H61","v":{"v":0.384,"d":"$0.38"}},{"$f":"H62","v":{"v":0.6333333333333333,"d":"$0.63"}},null,{"$f":"(B44*B44)/(D44*D44)","v":{"v":63.95551575395346,"d":"63.96"}},{"$f":"(D44*D44)/B44","v":{"v":0.00795344483849656,"d":"0.01"}},{"$f":"_xll.ErGamma(K44,L44)","v":{"v":0.5086666666666667,"d":"0.51"}},{"$f":"_xll.ErRunOutput(A44,M44)","v":{"v":0.5086666666666667,"d":"0.51"}},"coles online","20% of price per litre",{"$f":"C73*M44*365*$A$66","v":{"v":105953121.622076,"d":"105,953,122"}},{"$nulls":13},"Tax burden - the additional cost of beverage attributed to SSB tax. ",{"$f":"Q44","v":{"v":105953121.622076,"d":"105,953,122"}}]
["Total C3 cost",{"$f":"SUM(AF40:AF44)","v":{"v":645074575.75186,"d":"645,074,576"}}]
["total tax per person",{"$f":"B45/A66","v":{"v":31.025452827951387,"d":"31"}}]
["population tax per person",{"$nulls":12},{"$f":"_xll.ErRunOutput(A47,B46)","v":{"v":31.025452827951387,"d":"31.0255"}}]
["population tax total output",{"$nulls":12},{"$f":"_xll.ErRunOutput(A48,B45)","v":{"v":645074575.75186,"d":"645,074,576"}}]
[]
["Amount of tax paid"]
["Soft drinks taxes",{"v":0.2,"d":"20%"}]
["Soft drinks prices","Soft drinks per litre","Sports drinks","Sports drinks per litre","energy drinks","energy drinks per litre","Fruit drinks","Fruit drinks per litre","Cordial ","Cordial per litre","Source"]
["Coke 375ml",{"v":3.36,"d":"$3.36"},"Gatorade 600ml",{"v":6.15,"d":"$6.15"},"red bull 355ml can",{"v":11.32,"d":"$11.32"},"mildura 1 litre",{"v":1.92,"d":"$1.92"},"Cottees ",{"$f":"5.27","v":{"v":5.27,"d":"$5.27"}},"Coles online http://shop.coles.com.au/online/national"]
["2litre",{"v":2.2,"d":"$2.20"},"Gatorade 1l",{"v":4.4,"d":"$4.40"},"red bull 250ml 6 pack",{"v":13.2,"d":"$13.20"},"prima 6x200",{"$f":"3.8/1200*1000","v":{"v":3.1666666666666665,"d":"$3.17"}},"Bickfords",{"$f":"5.65","v":{"v":5.65,"d":"$5.65"}}]
["mini can",{"v":5.71,"d":"$5.71"},"powerade 600ml",{"v":6.15,"d":"$6.15"},"monster 550ml",{"v":7,"d":"$7.00"},null,null,"ribena",{"$f":"8.79","v":{"v":8.79,"d":"$8.79"}}]
["1.25 litre",{"v":2.45,"d":"$2.45"},{"$nulls":6},"golden circle",{"v":2.2,"d":"$2.20"}]
["600ml",{"v":3,"d":"$3.00"}]
["LA cola",{"v":0.75,"d":"$0.75"}]
[" average/ litre",{"$f":"AVERAGE(B53:B58)","v":{"v":2.9116666666666666,"d":"$2.91"}},null,{"$f":"AVERAGE(D53:D57)","v":{"v":5.566666666666667,"d":"$5.57"}},null,{"$f":"AVERAGE(F53:F57)","v":{"v":10.506666666666666,"d":"$10.51"}},null,{"$f":"AVERAGE(H53:H57)","v":{"v":2.543333333333333,"d":"$2.54"}},null,{"$f":"AVERAGE(J53:J57)","v":{"v":5.4775,"d":"$5.48"}}]
["Tax amount ",{"$f":"B59*$B$51","v":{"v":0.5823333333333334,"d":"$0.58"}},null,{"$f":"D59*$B$51","v":{"v":1.1133333333333335,"d":"$1.11"}},null,{"$f":"F59*$B$51","v":{"v":2.1013333333333333,"d":"$2.10"}},null,{"$f":"H59*$B$51","v":{"v":0.5086666666666666,"d":"$0.51"}},null,{"$f":"J59*$B$51","v":{"v":1.0955000000000001,"d":"$1.10"}}]
["Low value",{"$f":"B58*B51","v":{"v":0.15000000000000002,"d":"$0.15"}},null,{"$f":"D54*B51","v":{"v":0.8800000000000001,"d":"$0.88"}},null,{"$f":"F55*B51","v":{"v":1.4000000000000001,"d":"$1.40"}},null,{"$f":"H53*B51","v":{"v":0.384,"d":"$0.38"}},null,{"$f":"J53*B51","v":{"v":1.054,"d":"$1.05"}}]
["High value",{"$f":"B55*B51","v":{"v":1.1420000000000001,"d":"$1.14"}},null,{"$f":"D55*B51","v":{"v":1.2300000000000002,"d":"$1.23"}},null,{"$f":"F54*B51","v":{"v":2.64,"d":"$2.64"}},null,{"$f":"H54*B51","v":{"v":0.6333333333333333,"d":"$0.63"}},null,{"$f":"J55*B51","v":{"v":1.758,"d":"$1.76"}}]
[]
[]
["Population nos. age 2+ ","millions","Source"]
[{"v":20791786,"d":"20,791,786"},{"$f":"A66/1000000","v":{"v":20.791786,"d":"20.79"}},"3101.0 - Australian Demographic Statistics, Dec 2010"]
[]
["Consumption pre-tax","Pretax person daily consumption/litre","Post tax person daily consumption/litre"]
["Soft drinks",{"$f":"'Calc-benefits Aus Pop  '!C212/$B$75","v":{"v":0.10165590000000001,"d":"0.102"}},{"$f":"'Calc-benefits Aus Pop  '!C213/$B$75","v":{"v":0.08994514031999996,"d":"0.090"}}]
["Sports drinks",{"$f":"'Calc-benefits Aus Pop  '!C219/$B$75","v":{"v":7.735497E-3,"d":"0.008"}},{"$f":"'Calc-benefits Aus Pop  '!C220/$B$75","v":{"v":0.006844367745599996,"d":"0.007"}}]
["Energy Drinks",{"$f":"'Calc-benefits Aus Pop  '!C226/$B$75","v":{"v":0.004677241,"d":"0.005"}},{"$f":"'Calc-benefits Aus Pop  '!C227/$B$75","v":{"v":0.004138422836799998,"d":"0.004"}}]
["Cordial",{"$f":"'Calc-benefits Aus Pop  '!C233/$B$75/10","v":{"v":0.003206597,"d":"0.003"}},{"$f":"'Calc-benefits Aus Pop  '!C234/$B$75/10","v":{"v":0.002141044816899998,"d":"0.002"}}]
["Fruit drink",{"$f":"'Calc-benefits Aus Pop  '!C241/$B$75","v":{"v":0.036841689999999996,"d":"0.037"}},{"$f":"'Calc-benefits Aus Pop  '!C242/$B$75","v":{"v":0.027447059050000038,"d":"0.027"}}]
["total ",{"$f":"SUM(B69:B73)","v":{"v":0.15411692500000002,"d":"0.15"}},{"$f":"'Calc-benefits Aus Pop  '!C248/$B$75","v":{"v":0,"d":"0.000"}}]
["conversion to litres",1000]
[]
[]
[]
["Dead weight loss calculcations","DWL =0.5 * (PostTaxPrice—PreTaxPrice)*(PreTaxQuantity—PostTaxQuantity)"]
[null,"PreTaxPrice","PostTaxPrice","PreTaxQuantity","PostTaxQuantity","DWL","ersatz"]
[" fizzy drinks",{"$f":"B59","v":{"v":2.9116666666666666,"d":"$2.91"}},{"$f":"B81*1.2","v":{"v":3.4939999999999998,"d":"$3.49"}},{"$f":"B69*365*$A$66","v":{"v":771466817.2296511,"d":"771,466,817"}},{"$f":"C69*365*$A$66","v":{"v":682593839.8847948,"d":"682,593,840"}},{"$f":"0.5*(C81-B81)*(D81-E81)","v":{"v":25876848.570243973,"d":"25,876,848.57"}}]
["Sports drinks",{"$f":"D59","v":{"v":5.566666666666667,"d":"$5.57"}},{"$f":"B82*1.2","v":{"v":6.680000000000001,"d":"$6.68"}},{"$f":"B70*365*$A$66","v":{"v":58704701.35308933,"d":"58,704,701"}},{"$f":"C70*365*$A$66","v":{"v":51941919.757213406,"d":"51,941,920"}},{"$f":"0.5*(C82-B82)*(D82-E82)","v":{"v":3764615.0883709323,"d":"3,764,615.09"}}]
["Energy Drinks",{"$f":"F59","v":{"v":10.506666666666666,"d":"$10.51"}},{"$f":"B83*1.2","v":{"v":12.607999999999999,"d":"$12.61"}},{"v":35495590.78898549,"d":"35,495,591"},{"$f":"C71*365*$A$66","v":{"v":31406498.73009435,"d":"31,406,499"}},{"v":4296272.72320829,"d":"4,296,272.72"}]
["Cordial",{"$f":"J59","v":{"v":5.4775,"d":"$5.48"}},{"$f":"B84*1.2","v":{"v":6.5729999999999995,"d":"$6.57"}},{"v":24334870.693468332,"d":"24,334,871"},{"$f":"C72*365*$A$66","v":{"v":16248393.16202879,"d":"16,248,393"}},{"v":4429368.067846008,"d":"4,429,368.07"}]
["Fruit drink",{"$f":"H59","v":{"v":2.543333333333333,"d":"$2.54"}},{"$f":"B85*1.2","v":{"v":3.0519999999999996,"d":"$3.05"}},{"v":279591655.0407941,"d":"279,591,655"},{"$f":"C73*365*$A$66","v":{"v":208295783.0053919,"d":"208,295,783"}},{"v":18132916.78767062,"d":"18,132,916.79"}]
["total ",{"$nulls":4},{"$f":"SUM(F81:F85)","v":{"v":56500021.237339824,"d":"56,500,021"}},{"$f":"_xll.ErRunOutput(F80,F86)","v":{"v":56500021.237339824,"d":"56,500,021"}}]
[]
[]
[]
["Administration costs  (Long 2015)"]
[]
["Resource",null,"uncertainty range",null,"Standard error","Source",null,null,"AUD conversions"]
["Government/industry administration and compliance time costs per million people per year (FTE)",0.32,0.1,0.54,null,"based on data from personal communications with Washington and West Virginia State Departments of Revenue;"]
["Government/industry field audit time costs per million people per year (FTE)",0.3,0.24,0.35,null,"based on an estimate of field audit time ( 25%) from a personal communication with West Virginia State Department of Revenue"]
["Fied audit direct costs per million people per year ($)",{"v":9170,"d":"$9,170"},6450,11900,null,"Samples drawn from a gamma distribution. (5th Percentile 6871, 50th percentile $9161, 95th percentile $11,460 )based on an estimate of field audit direct cost ( 25%) from a personal communication with West Virginia State Department of Revenue",null,null,{"$f":"6871*B104","v":{"v":10325.443346999999,"d":"$10,325.44"}},{"$f":"9161*B104","v":{"v":13766.756877,"d":"$13,766.76"}},{"$f":"11460*B104","v":{"v":17221.59522,"d":"$17,221.60"}}]
["Fied audit direct costs per million people per year ($) AUD ",{"$f":"B95*$B$104","v":{"v":13780.28169,"d":"$13,780.28"}},{"$f":"I95","v":{"v":10325.443346999999,"d":"$10,325.44"}},{"$f":"K95","v":{"v":17221.59522,"d":"$17,221.60"}},null,"AUD conversion "]
["Tax certification system operating costs per million people per year ($)",11900,8360,15400,null,"Samples drawn from a gamma distribution. (5th percentile = $6,871; 50th Percentile 9,161, 95th Percentile $11,460) based on an estimate of field audit direct cost ( 25%) from a personal communication with West Virginia State Department of Revenue"]
["Tax certification system operating costs per million people per year ($) AUD",{"$f":"B97*$B$104","v":{"v":17882.8083,"d":"$17,883"}},{"$f":"C97*$B$104","v":{"v":12563.048519999998,"d":"$12,563"}},{"$f":"D97*$B$104","v":{"v":23142.4578,"d":"$23,142"}},null,"AUD conversion"]
["Accountant (govt) weekly",{"v":1432,"d":"1,432.00"},null,null,62.5,"ABS 6306 employee earnings and hours, 2211 Accountant (all methods of setting pay) CI individual agreement, collective agreement "]
["Accountant (govt) yearly inc oncosts",{"$f":"B99*$B$103*52","v":{"v":84888.95999999999,"d":"84,889"}},{"$f":"C99*$B$103*52","v":0},{"$f":"D99*$B$103*52","v":0},{"$f":"E99*52","v":3250},"Per capita FTE data from Long et al 2015, ABS mean salary for accountants and auditors code 2211, 2212. Assume 14% non-salary benefits",null,null,{"$f":"B99*52","v":74464},{"$f":"1016*52","v":52832},{"$f":"1759*52","v":91468}]
["Auditor salary (industry) weekly",{"v":1660.3,"d":"1,660.30"},null,null,97,"ABS 6306 employee earnings and hours, 2212 Auditors, company secretaries and corporate treasurers. (all methods of setting pay) CI  individual agreement, collective agreement "]
["Auditor salary (industry) yearly inc oncosts",{"$f":"B101*$B$103*52","v":{"v":98422.58399999999,"d":"98,423"}},{"$f":"C101*$B$103*52","v":0},{"$f":"D101*$B$103*52","v":0},{"$f":"97*52","v":5044},"Per capita FTE data from Long et al 2015, ABS mean salary for accountants and auditors code 2211, 2212. Assume 14% non-salary benefits",null,null,{"$f":"B101*52","v":86335.59999999999},{"$f":"1593*52","v":82836},{"$f":"1758*52","v":91416}]
["Oncosts ",1.14,{"$nulls":3},"ABS labour costs 6348.0 Australia. professional scientific and technical services. Include superannuation and payroll tax"]
["Purchasing power parities",1.502757,{"$nulls":3},"Organization for Economic Co-operation and Development (OECD) purchasing power parity rate per US dollar as at 31 December 2010 for   http://stats.oecd.org/Index.aspx?datasetcode=SNA_TABLE4"]
[]
[]
["Government"]
[null,"Number of Items per Million People","Cost per Item (dollars)","Total Cost per Million People ($)","Total National Annual Cost annual cost (dollars)"]
["Govt tax auditor",0.32,{"$f":"$B$100","v":{"v":84888.95999999999,"d":"$84,889"}},{"$f":"B109*C109","v":{"v":27164.4672,"d":"$27,164"}},{"$f":"D109*$B$66","v":{"v":564797.7888264192,"d":"$564,798"}}]
["Field audit compliance salary costs",{"v":0.295,"d":"0.30"},{"$f":"$B$100","v":{"v":84888.95999999999,"d":"$84,889"}},{"$f":"B110*C110","v":{"v":25042.243199999997,"d":"$25,042"}},{"$f":"D110*$B$66","v":{"v":520672.9615743551,"d":"$520,673"}},"Average per capita FTE data from Long et al 2015, ABS mean salary for accountants and auditors code 2211, 2212. Assume 30% non-salary benefits"]
["Field audit direct costs",1,null,{"v":13800,"d":"$13,800"},{"$f":"D111*$B$66","v":{"v":286926.6468,"d":"$286,927"}},"Per capita FTE data from Long et al 2015, ABS mean salary for accountants and auditors code 2211, 2212. Assume 14% non-salary benefits"]
["Tax certification system operating costs",1,null,{"v":17900,"d":"$17,900"},{"$f":"D112*$B$66","v":{"v":372172.96939999994,"d":"$372,173"}},"Long et al Per capita direct field audit costs from WV State Department of Revenue converted to AUD 2010"]
["Subtotal ",{"$nulls":3},{"$f":"SUM(E109:E112)","v":{"v":1744570.3666007742,"d":"$1,744,570"}},"Long et al Per capita tax certification system operating costs from WV State Department of Revenue converted to AUD 2010"]
[]
[]
["Industry"]
[null,"Number of Items per Million People","Cost per Item (dollars)","Total Cost per Million People ($)","Total National Annual Cost annual cost (dollars)"]
["Govt tax auditor",0.32,{"$f":"$B$102","v":{"v":98422.58399999999,"d":"$98,423"}},{"$f":"B118*C118","v":{"v":31495.22688,"d":"$31,495"}},{"$f":"D118*$B$66","v":{"v":654842.0173104076,"d":"$654,842"}}]
["Field audit compliance salary costs",{"v":0.295,"d":"0.30"},{"$f":"$B$102","v":{"v":98422.58399999999,"d":"$98,423"}},{"$f":"B119*C119","v":{"v":29034.662279999993,"d":"$29,035"}},{"$f":"D119*$B$66","v":{"v":603682.4847080319,"d":"$603,682"}}]
["Field audit direct costs",1,null,{"v":13800,"d":"$13,800"},{"$f":"D120*$B$66","v":{"v":286926.6468,"d":"$286,927"}}]
["Tax certification system operating costs",1,null,{"v":17900,"d":"$17,900"},{"$f":"D121*$B$66","v":{"v":372172.96939999994,"d":"$372,173"}}]
["Subtotal ",{"$nulls":3},{"$f":"SUM(E118:E121)","v":{"v":1917624.1182184396,"d":"$1,917,624"}}]
[]
[]
["Total cost legislation ",2015,2014,2013,2012,2011,2010,"average","Source","notes"]
["Cost of Parliamentarians",{"v":4424834.367484367,"d":"4,424,834"},{"v":4103662.1572871576,"d":"4,103,662"},{"v":4026366.8350168355,"d":"4,026,367"},{"v":3344913.5642135646,"d":"3,344,914"},{"v":2894792.8330928334,"d":"2,894,793"},{"v":2807535.8225108227,"d":"2,807,536"},{"v":3600350.9299342637,"d":"3,600,351"},"Assume 19% of time","time spent considering legislation/yearly total working hours"]
["Senate annual expenses",{"v":23909000,"d":"23,909,000"},{"v":22096000,"d":"22,096,000"},{"v":22283000,"d":"22,283,000"},{"v":25192000,"d":"25,192,000"},{"v":24132000,"d":"24,132,000"},{"v":23962000,"d":"23,962,000"},{"v":23595666.666666668,"d":"23,595,667"},"http://www.aph.gov.au/About_Parliament/Parliamentary_Departments/Department_of_the_Senate/Annual_Reports","*Provide advisory and administrative support services to enable the Senate and senators to fulfil their representative and legislative duties."]
["House of representatives annual expenses ",{"v":25667000,"d":"25,667,000"},{"v":24409000,"d":"24,409,000"},{"v":25219000,"d":"25,219,000"},{"v":26871000,"d":"26,871,000"},{"v":24617000,"d":"24,617,000"},{"v":28019000,"d":"28,019,000"},{"v":25800333.333333332,"d":"25,800,333"},"Annual report appendix outcome1 http://www.aph.gov.au/About_Parliament/Parliamentary_Departments/Department_of_the_House_of_Representatives/Annual_Report","About half of the total sitting time of the House is spent considering bills, that is, proposed laws."]
["Office of parliamenary counsel -legislation drafting and publication",{"v":21598000,"d":"21,598,000"},{"v":21368000,"d":"21,368,000"},{"v":19029000,"d":"19,029,000"},{"v":11793000,"d":"11,793,000"},{"v":10548000,"d":"10,548,000"},{"v":9804000,"d":"9,804,000"},{"v":15690000,"d":"15,690,000"},"https://www.ag.gov.au/Publications/Budgets/Pages/default.aspx","2010 p470. 2015 p 487"]
["Parliamentary input to law-making total",{"v":75598834.36748436,"d":"75,598,834"},{"v":71976662.15728715,"d":"71,976,662"},{"v":70557366.83501683,"d":"70,557,367"},{"v":67200913.56421357,"d":"67,200,914"},{"v":62191792.83309284,"d":"62,191,793"},{"v":64592535.82251082,"d":"64,592,536"},{"v":68686350.92993426,"d":"68,686,351"}]
["Policy advice relating to laws",{"v":39443001.097316466,"d":"39,443,001"},{"v":39443001.097316466,"d":"39,443,001"},{"v":39443001.097316466,"d":"39,443,001"},{"v":39443001.097316466,"d":"39,443,001"},{"v":39443001.097316466,"d":"39,443,001"},{"v":39443001.097316466,"d":"39,443,001"},{"v":39443001.097316466,"d":"39,443,001"},"http://www.who.int/bulletin/volumes/90/7/BLT-11-097584-table-T3.html"]
["total cost all legislation ",{"v":115041835.46480083,"d":"115,041,835"},{"v":111419663.25460362,"d":"111,419,663"},{"v":110000367.93233329,"d":"110,000,368"},{"v":106643914.66153005,"d":"106,643,915"},{"v":101634793.93040931,"d":"101,634,794"},{"v":104035536.91982728,"d":"104,035,537"},{"v":108129352.02725074,"d":"108,129,352"},"sum of parliamentarians, senate, reps,OPC"]
["no. bills passed by senate",181,139,149,207,188,156,170,"http://www.aph.gov.au/Parliamentary_Business/Statistics/Senate_StatsNet/legislation/timespent/2013"]
["total cost/no. of bills passed",{"v":635590.2511867449,"d":"635,590"},{"v":801580.3111841987,"d":"801,580"},{"v":738257.5029015657,"d":"738,258"},{"v":515187.9935339616,"d":"515,188"},{"v":540610.6060128155,"d":"540,611"},{"v":666894.4674347902,"d":"666,894"},{"v":649686.8553756793,"d":"649,687"},"total cost/no. of bills passed"]
["With cost of Regulatory Impact statement",{"v":1075590.2511867448,"d":"1,075,590"},{"v":1241580.3111841986,"d":"1,241,580"},{"v":1178257.5029015657,"d":"1,178,258"},{"v":955187.9935339616,"d":"955,188"},{"v":980610.6060128155,"d":"980,611"},{"v":1106894.4674347902,"d":"1,106,894"},{"v":1089686.8553756794,"d":"1,089,687"}]

{"sheet":"Intervention costs inputs","index":3,"n_rows":108,"n_cols":16,"rows_kept":108}
["20% tax total pop",null,null,0.03,"Discount rate "]
[]
[null,"Total discounted C1 cost",{"$f":"SUM(C9:C108)","v":0},null,"Total discounted C2a cost",{"$f":"SUM(F9:F108)","v":{"v":57941565.914651245,"d":"57,941,566"}},null,"Total discounted C2b cost",{"$f":"SUM(I9:I108)","v":{"v":62511048.448021084,"d":"62,511,048"}},null,"Total discounted C3 cost",{"$f":"SUM(L9:L108)","v":{"v":5667695485.290795,"d":"5,667,695,485"}},null,"Total intervention costs",null,{"$f":"SUM(I3,F3,C3)","v":{"v":120452614.36267233,"d":"120,452,614"}}]
[{"$nulls":4},"10 year discounted C2a cost",{"$f":"SUM(F9:F18)","v":{"v":16488466.54599606,"d":"16,488,467"}},null,"10 year discounted C2b cost",{"$f":"SUM(I9:I18)","v":{"v":16931610.339161225,"d":"16,931,610"}},{"$nulls":4},"10 year intervention costs",null,{"$f":"F4+I4","v":{"v":33420076.885157287,"d":"33,420,077"}}]
[{"$nulls":13},"10 year ersatz",null,{"$f":"_xll.ErRunOutput(N4,P4)","v":{"v":33420076.885157287,"d":"33,420,077"}}]
[{"$nulls":13},"Total Ersatz output ",null,{"$f":"_xll.ErRunOutput(N3, P3)","v":120452614.36267233}]
["Year","C1 costs ",null,null,"C2a costs ",null,null,"C2b costs ",null,null,"C3 costs ",null,null,"10 year taxation",null,{"$f":"_xll.ErOutput(N7,L3)","v":{"v":5667695485.290795,"d":"5,667,695,485"}}]
[null,"Mean ","Discounted costs",null,"Mean ","Discounted costs",null,"Mean ","Discounted cost",null,"Mean ","Discounted cost",null,"Discount factor"]
[1,null,{"$f":"B9*N9","v":0},null,{"$f":"'Calc-costs Aus pop '!B19","v":{"v":2842314.762397689,"d":"2,842,315"}},{"$f":"E9*N9","v":{"v":2842314.762397689,"d":"2,842,315"}},null,{"$f":"'Calc-costs Aus pop '!$B$32","v":{"v":1927088.5997097362,"d":"1,927,089"}},{"$f":"H9*N9","v":{"v":1927088.5997097362,"d":"1,927,089"}},null,{"$f":"'Calc-costs Aus pop '!$N$48","v":{"v":645074575.75186,"d":"645,074,576"}},{"$f":"K9*N9","v":{"v":645074575.75186,"d":"645,074,576"}},null,{"$f":"1/((1+$D$1)^(A9-1))","v":{"v":1,"d":"1.00"}}]
[2,null,{"$f":"B10*N10","v":0},null,{"$f":"'Calc-costs Aus pop '!$B$22","v":{"v":1752627.9070220094,"d":"1,752,628"}},{"$f":"E10*N10","v":{"v":1701580.492254378,"d":"1,701,580"}},null,{"$f":"'Calc-costs Aus pop '!$B$32","v":{"v":1927088.5997097362,"d":"1,927,089"}},{"$f":"H10*N10","v":{"v":1870959.8055434332,"d":"1,870,960"}},null,{"$f":"'Calc-costs Aus pop '!$N$48","v":{"v":645074575.75186,"d":"645,074,576"}},{"$f":"K10*N10","v":{"v":626285995.8755922,"d":"626,285,996"}},null,{"v":0.970873786407767,"d":"0.97"}]
[3,null,0,null,{"$f":"'Calc-costs Aus pop '!$B$22","v":{"v":1752627.9070220094,"d":"1,752,628"}},{"v":1652019.8953926,"d":"1,652,020"},null,{"$f":"'Calc-costs Aus pop '!$B$32","v":{"v":1927088.5997097362,"d":"1,927,089"}},{"v":1816465.8306246924,"d":"1,816,466"},null,{"$f":"'Calc-costs Aus pop '!$N$48","v":{"v":645074575.75186,"d":"645,074,576"}},{"v":608044656.1898954,"d":"608,044,656"},null,{"v":0.9425959091337544,"d":"0.94"}]
[4,null,0,null,{"$f":"'Calc-costs Aus pop '!$B$22","v":{"v":1752627.9070220094,"d":"1,752,628"}},{"v":1603902.8110607767,"d":"1,603,903"},null,{"$f":"'Calc-costs Aus pop '!$B$32","v":{"v":1927088.5997097362,"d":"1,927,089"}},{"v":1763559.0588589248,"d":"1,763,559"},null,{"$f":"'Calc-costs Aus pop '!$N$48","v":{"v":645074575.75186,"d":"645,074,576"}},{"v":590334617.6600926,"d":"590,334,618"},null,{"v":0.9151416593531596,"d":"0.92"}]
[5,null,0,null,{"$f":"'Calc-costs Aus pop '!$B$22","v":{"v":1752627.9070220094,"d":"1,752,628"}},{"v":1557187.1952046377,"d":"1,557,187"},null,{"$f":"'Calc-costs Aus pop '!$B$32","v":{"v":1927088.5997097362,"d":"1,927,089"}},{"v":1712193.2610280823,"d":"1,712,193"},null,{"$f":"'Calc-costs Aus pop '!$N$48","v":{"v":645074575.75186,"d":"645,074,576"}},{"v":573140405.4952356,"d":"573,140,405"},null,{"v":0.888487047915689,"d":"0.89"}]
[6,null,0,null,{"$f":"'Calc-costs Aus pop '!$B$22","v":{"v":1752627.9070220094,"d":"1,752,628"}},{"v":1511832.2283540173,"d":"1,511,832"},null,{"$f":"'Calc-costs Aus pop '!$B$32","v":{"v":1927088.5997097362,"d":"1,927,089"}},{"v":1662323.5543961965,"d":"1,662,324"},null,{"$f":"'Calc-costs Aus pop '!$N$48","v":{"v":645074575.75186,"d":"645,074,576"}},{"v":556446995.6264423,"d":"556,446,996"},null,{"v":0.8626087843841641,"d":"0.86"}]
[7,null,0,null,{"$f":"'Calc-costs Aus pop '!$B$22","v":{"v":1752627.9070220094,"d":"1,752,628"}},{"v":1467798.2799553566,"d":"1,467,798"},null,{"$f":"'Calc-costs Aus pop '!$B$32","v":{"v":1927088.5997097362,"d":"1,927,089"}},{"v":1613906.363491453,"d":"1,613,906"},null,{"$f":"'Calc-costs Aus pop '!$N$48","v":{"v":645074575.75186,"d":"645,074,576"}},{"v":540239801.5790702,"d":"540,239,802"},null,{"v":0.8374842566836544,"d":"0.84"}]
[8,null,0,null,{"$f":"'Calc-costs Aus pop '!$B$22","v":{"v":1752627.9070220094,"d":"1,752,628"}},{"v":1425046.8737430645,"d":"1,425,047"},null,{"$f":"'Calc-costs Aus pop '!$B$32","v":{"v":1927088.5997097362,"d":"1,927,089"}},{"v":1566899.3820305367,"d":"1,566,899"},null,{"$f":"'Calc-costs Aus pop '!$N$48","v":{"v":645074575.75186,"d":"645,074,576"}},{"v":524504661.7272526,"d":"524,504,662"},null,{"v":0.8130915113433538,"d":"0.81"}]
[9,null,0,null,{"$f":"'Calc-costs Aus pop '!$B$22","v":{"v":1752627.9070220094,"d":"1,752,628"}},{"v":1383540.6541194802,"d":"1,383,541"},null,{"$f":"'Calc-costs Aus pop '!$B$32","v":{"v":1927088.5997097362,"d":"1,927,089"}},{"v":1521261.5359519774,"d":"1,521,262"},null,{"$f":"'Calc-costs Aus pop '!$N$48","v":{"v":645074575.75186,"d":"645,074,576"}},{"v":509227826.9196628,"d":"509,227,827"},null,{"v":0.7894092343139357,"d":"0.79"}]
[10,null,0,null,{"$f":"'Calc-costs Aus pop '!$B$22","v":{"v":1752627.9070220094,"d":"1,752,628"}},{"v":1343243.3535140585,"d":"1,343,243"},null,{"$f":"'Calc-costs Aus pop '!$B$32","v":{"v":1927088.5997097362,"d":"1,927,089"}},{"v":1476952.9475261918,"d":"1,476,953"},null,{"$f":"'Calc-costs Aus pop '!$N$48","v":{"v":645074575.75186,"d":"645,074,576"}},{"v":494395948.465692,"d":"494,395,948"},null,{"v":0.766416732343627,"d":"0.77"}]
[11,null,0,null,{"$f":"'Calc-costs Aus pop '!$B$22","v":{"v":1752627.9070220094,"d":"1,752,628"}},{"v":1304119.7606932605,"d":"1,304,120"},null,{"$f":"'Calc-costs Aus pop '!$B$32","v":{"v":1927088.5997097362,"d":"1,927,089"}},{"v":1433934.9005108657,"d":"1,433,935"},null,null,0,null,{"v":0.7440939148967252,"d":"0.74"}]
[12,null,0,null,{"$f":"'Calc-costs Aus pop '!$B$22","v":{"v":1752627.9070220094,"d":"1,752,628"}},{"v":1266135.689993457,"d":"1,266,136"},null,{"$f":"'Calc-costs Aus pop '!$B$32","v":{"v":1927088.5997097362,"d":"1,927,089"}},{"v":1392169.8063212289,"d":"1,392,170"},null,null,0,null,{"v":0.7224212765987623,"d":"0.72"}]
[13,null,0,null,{"$f":"'Calc-costs Aus pop '!$B$22","v":{"v":1752627.9070220094,"d":"1,752,628"}},{"v":1229257.9514499584,"d":"1,229,258"},null,{"$f":"'Calc-costs Aus pop '!$B$32","v":{"v":1927088.5997097362,"d":"1,927,089"}},{"v":1351621.1711856595,"d":"1,351,621"},null,null,0,null,{"v":0.7013798801929733,"d":"0.70"}]
[14,null,0,null,{"$f":"'Calc-costs Aus pop '!$B$22","v":{"v":1752627.9070220094,"d":"1,752,628"}},{"v":1193454.3217960761,"d":"1,193,454"},null,{"$f":"'Calc-costs Aus pop '!$B$32","v":{"v":1927088.5997097362,"d":"1,927,089"}},{"v":1312253.5642579217,"d":"1,312,254"},null,null,0,null,{"v":0.6809513399931779,"d":"0.68"}]
[15,null,0,null,{"$f":"'Calc-costs Aus pop '!$B$22","v":{"v":1752627.9070220094,"d":"1,752,628"}},{"v":1158693.51630687,"d":"1,158,694"},null,{"$f":"'Calc-costs Aus pop '!$B$32","v":{"v":1927088.5997097362,"d":"1,927,089"}},{"v":1274032.5866581763,"d":"1,274,033"},null,null,0,null,{"v":0.6611178058186192,"d":"0.66"}]
[16,null,0,null,{"$f":"'Calc-costs Aus pop '!$B$22","v":{"v":1752627.9070220094,"d":"1,752,628"}},{"v":1124945.1614629803,"d":"1,124,945"},null,{"$f":"'Calc-costs Aus pop '!$B$32","v":{"v":1927088.5997097362,"d":"1,927,089"}},{"v":1236924.841415705,"d":"1,236,925"},null,null,0,null,{"v":0.6418619473967176,"d":"0.64"}]
[17,null,0,null,{"$f":"'Calc-costs Aus pop '!$B$22","v":{"v":1752627.9070220094,"d":"1,752,628"}},{"v":1092179.7684106608,"d":"1,092,180"},null,{"$f":"'Calc-costs Aus pop '!$B$32","v":{"v":1927088.5997097362,"d":"1,927,089"}},{"v":1200897.9042870924,"d":"1,200,898"},null,null,0,null,{"v":0.6231669392201143,"d":"0.62"}]
[18,null,0,null,{"$f":"'Calc-costs Aus pop '!$B$22","v":{"v":1752627.9070220094,"d":"1,752,628"}},{"v":1060368.7071948163,"d":"1,060,369"},null,{"$f":"'Calc-costs Aus pop '!$B$32","v":{"v":1927088.5997097362,"d":"1,927,089"}},{"v":1165920.2954243615,"d":"1,165,920"},null,null,0,null,{"v":0.6050164458447712,"d":"0.61"}]
[19,null,0,null,{"$f":"'Calc-costs Aus pop '!$B$22","v":{"v":1752627.9070220094,"d":"1,752,628"}},{"v":1029484.18174254,"d":"1,029,484"},null,{"$f":"'Calc-costs Aus pop '!$B$32","v":{"v":1927088.5997097362,"d":"1,927,089"}},{"v":1131961.4518683122,"d":"1,131,961"},null,null,0,null,{"v":0.5873946076162827,"d":"0.59"}]
[20,null,0,null,{"$f":"'Calc-costs Aus pop '!$B$22","v":{"v":1752627.9070220094,"d":"1,752,628"}},{"v":999499.2055752816,"d":"999,499"},null,{"$f":"'Calc-costs Aus pop '!$B$32","v":{"v":1927088.5997097362,"d":"1,927,089"}},{"v":1098991.7008430215,"d":"1,098,992"},null,null,0,null,{"v":0.570286026811925,"d":"0.57"}]
[21,null,0,null,{"$f":"'Calc-costs Aus pop '!$B$22","v":{"v":1752627.9070220094,"d":"1,752,628"}},{"v":970387.5782284288,"d":"970,388"},null,{"$f":"'Calc-costs Aus pop '!$B$32","v":{"v":1927088.5997097362,"d":"1,927,089"}},{"v":1066982.2338281763,"d":"1,066,982"},null,null,0,null,{"v":0.553675754186335,"d":"0.55"}]
[22,null,0,null,{"$f":"'Calc-costs Aus pop '!$B$22","v":{"v":1752627.9070220094,"d":"1,752,628"}},{"v":942123.8623576979,"d":"942,124"},null,{"$f":"'Calc-costs Aus pop '!$B$32","v":{"v":1927088.5997097362,"d":"1,927,089"}},{"v":1035905.081386579,"d":"1,035,905"},null,null,0,null,{"v":0.5375492759090631,"d":"0.54"}]
[23,null,0,null,{"$f":"'Calc-costs Aus pop '!$B$22","v":{"v":1752627.9070220094,"d":"1,752,628"}},{"v":914683.361512328,"d":"914,683"},null,{"$f":"'Calc-costs Aus pop '!$B$32","v":{"v":1927088.5997097362,"d":"1,927,089"}},{"v":1005733.088724834,"d":"1,005,733"},null,null,0,null,{"v":0.5218925008825855,"d":"0.52"}]
[24,null,0,null,{"$f":"'Calc-costs Aus pop '!$B$22","v":{"v":1752627.9070220094,"d":"1,752,628"}},{"v":888042.0985556582,"d":"888,042"},null,{"$f":"'Calc-costs Aus pop '!$B$32","v":{"v":1927088.5997097362,"d":"1,927,089"}},{"v":976439.8919658582,"d":"976,440"},null,null,0,null,{"v":0.5066917484296947,"d":"0.51"}]
[25,null,0,null,{"$f":"'Calc-costs Aus pop '!$B$22","v":{"v":1752627.9070220094,"d":"1,752,628"}},{"v":862176.7947142314,"d":"862,177"},null,{"$f":"'Calc-costs Aus pop '!$B$32","v":{"v":1927088.5997097362,"d":"1,927,089"}},{"v":947999.8951124838,"d":"948,000"},null,null,0,null,{"v":0.49193373633950943,"d":"0.49"}]
[26,null,0,null,{"$f":"'Calc-costs Aus pop '!$B$22","v":{"v":1752627.9070220094,"d":"1,752,628"}},{"v":837064.8492371179,"d":"837,065"},null,{"$f":"'Calc-costs Aus pop '!$B$32","v":{"v":1927088.5997097362,"d":"1,927,089"}},{"v":920388.2476820231,"d":"920,388"},null,null,0,null,{"v":0.47760556926165965,"d":"0.48"}]
[27,null,0,null,{"$f":"'Calc-costs Aus pop '!$B$22","v":{"v":1752627.9070220094,"d":"1,752,628"}},{"v":812684.3196476873,"d":"812,684"},null,{"$f":"'Calc-costs Aus pop '!$B$32","v":{"v":1927088.5997097362,"d":"1,927,089"}},{"v":893580.8229922554,"d":"893,581"},null,null,0,null,{"v":0.4636947274385045,"d":"0.46"}]
[28,null,0,null,{"$f":"'Calc-costs Aus pop '!$B$22","v":{"v":1752627.9070220094,"d":"1,752,628"}},{"v":789013.9025705701,"d":"789,014"},null,{"$f":"'Calc-costs Aus pop '!$B$32","v":{"v":1927088.5997097362,"d":"1,927,089"}},{"v":867554.1970798597,"d":"867,554"},null,null,0,null,{"v":0.45018905576553836,"d":"0.45"}]
[29,null,0,null,{"$f":"'Calc-costs Aus pop '!$B$22","v":{"v":1752627.9070220094,"d":"1,752,628"}},{"v":766032.9151170584,"d":"766,033"},null,{"$f":"'Calc-costs Aus pop '!$B$32","v":{"v":1927088.5997097362,"d":"1,927,089"}},{"v":842285.6282328735,"d":"842,286"},null,null,0,null,{"v":0.4370767531704256,"d":"0.44"}]
[30,null,0,null,{"$f":"'Calc-costs Aus pop '!$B$22","v":{"v":1752627.9070220094,"d":"1,752,628"}},{"v":743721.2768126781,"d":"743,721"},null,{"$f":"'Calc-costs Aus pop '!$B$32","v":{"v":1927088.5997097362,"d":"1,927,089"}},{"v":817753.0371192947,"d":"817,753"},null,null,0,null,{"v":0.4243463623013841,"d":"0.42"}]
[31,null,0,null,{"$f":"'Calc-costs Aus pop '!$B$22","v":{"v":1752627.9070220094,"d":"1,752,628"}},{"v":722059.4920511438,"d":"722,059"},null,{"$f":"'Calc-costs Aus pop '!$B$32","v":{"v":1927088.5997097362,"d":"1,927,089"}},{"v":793934.9874944609,"d":"793,935"},null,null,0,null,{"v":0.4119867595159069,"d":"0.41"}]
[32,null,0,null,{"$f":"'Calc-costs Aus pop '!$B$22","v":{"v":1752627.9070220094,"d":"1,752,628"}},{"v":701028.6330593628,"d":"701,029"},null,{"$f":"'Calc-costs Aus pop '!$B$32","v":{"v":1927088.5997097362,"d":"1,927,089"}},{"v":770810.6674703502,"d":"770,811"},null,null,0,null,{"v":0.3999871451610746,"d":"0.40"}]
[33,null,0,null,{"$f":"'Calc-costs Aus pop '!$B$22","v":{"v":1752627.9070220094,"d":"1,752,628"}},{"v":680610.3233586048,"d":"680,610"},null,{"$f":"'Calc-costs Aus pop '!$B$32","v":{"v":1927088.5997097362,"d":"1,927,089"}},{"v":748359.8713304373,"d":"748,360"},null,null,0,null,{"v":0.3883370341369657,"d":"0.39"}]
[34,null,0,null,{"$f":"'Calc-costs Aus pop '!$B$22","v":{"v":1752627.9070220094,"d":"1,752,628"}},{"v":660786.7217073833,"d":"660,787"},null,{"$f":"'Calc-costs Aus pop '!$B$32","v":{"v":1927088.5997097362,"d":"1,927,089"}},{"v":726562.9818742109,"d":"726,563"},null,null,0,null,{"v":0.37702624673491814,"d":"0.38"}]
[35,null,0,null,{"$f":"'Calc-costs Aus pop '!$B$22","v":{"v":1752627.9070220094,"d":"1,752,628"}},{"v":641540.5065120227,"d":"641,541"},null,{"$f":"'Calc-costs Aus pop '!$B$32","v":{"v":1927088.5997097362,"d":"1,927,089"}},{"v":705400.953275933,"d":"705,401"},null,null,0,null,{"v":0.36604489974263904,"d":"0.37"}]
[36,null,0,null,{"$f":"'Calc-costs Aus pop '!$B$22","v":{"v":1752627.9070220094,"d":"1,752,628"}},{"v":622854.8606912841,"d":"622,855"},null,{"$f":"'Calc-costs Aus pop '!$B$32","v":{"v":1927088.5997097362,"d":"1,927,089"}},{"v":684855.2944426533,"d":"684,855"},null,null,0,null,{"v":0.35538339780838735,"d":"0.36"}]
[37,null,0,null,{"$f":"'Calc-costs Aus pop '!$B$22","v":{"v":1752627.9070220094,"d":"1,752,628"}},{"v":604713.4569818291,"d":"604,713"},null,{"$f":"'Calc-costs Aus pop '!$B$32","v":{"v":1927088.5997097362,"d":"1,927,089"}},{"v":664908.052856945,"d":"664,908"},null,null,0,null,{"v":0.34503242505668674,"d":"0.35"}]
[38,null,0,null,{"$f":"'Calc-costs Aus pop '!$B$22","v":{"v":1752627.9070220094,"d":"1,752,628"}},{"v":587100.4436716789,"d":"587,100"},null,{"$f":"'Calc-costs Aus pop '!$B$32","v":{"v":1927088.5997097362,"d":"1,927,089"}},{"v":645541.7988902379,"d":"645,542"},null,null,0,null,{"v":0.3349829369482396,"d":"0.33"}]
[39,null,0,null,{"$f":"'Calc-costs Aus pop '!$B$22","v":{"v":1752627.9070220094,"d":"1,752,628"}},{"v":570000.4307492028,"d":"570,000"},null,{"$f":"'Calc-costs Aus pop '!$B$32","v":{"v":1927088.5997097362,"d":"1,927,089"}},{"v":626739.6105730466,"d":"626,740"},null,null,0,null,{"v":0.3252261523769317,"d":"0.33"}]
[40,null,0,null,{"$f":"'Calc-costs Aus pop '!$B$22","v":{"v":1752627.9070220094,"d":"1,752,628"}},{"v":553398.4764555367,"d":"553,398"},null,{"$f":"'Calc-costs Aus pop '!$B$32","v":{"v":1927088.5997097362,"d":"1,927,089"}},{"v":608485.058808783,"d":"608,485"},null,null,0,null,{"v":0.315753545997021,"d":"0.32"}]
[41,null,0,null,{"$f":"'Calc-costs Aus pop '!$B$22","v":{"v":1752627.9070220094,"d":"1,752,628"}},{"v":537280.0742286765,"d":"537,280"},null,{"$f":"'Calc-costs Aus pop '!$B$32","v":{"v":1927088.5997097362,"d":"1,927,089"}},{"v":590762.193018236,"d":"590,762"},null,null,0,null,{"v":0.30655684077380685,"d":"0.31"}]
[42,null,0,null,{"$f":"'Calc-costs Aus pop '!$B$22","v":{"v":1752627.9070220094,"d":"1,752,628"}},{"v":521631.1400278412,"d":"521,631"},null,{"$f":"'Calc-costs Aus pop '!$B$32","v":{"v":1927088.5997097362,"d":"1,927,089"}},{"v":573555.5272021708,"d":"573,556"},null,null,0,null,{"v":0.2976280007512688,"d":"0.30"}]
[43,null,0,null,{"$f":"'Calc-costs Aus pop '!$B$22","v":{"v":1752627.9070220094,"d":"1,752,628"}},{"v":506438.0000270303,"d":"506,438"},null,{"$f":"'Calc-costs Aus pop '!$B$32","v":{"v":1927088.5997097362,"d":"1,927,089"}},{"v":556850.0264098746,"d":"556,850"},null,null,0,null,{"v":0.288959224030358,"d":"0.29"}]
[44,null,0,null,{"$f":"'Calc-costs Aus pop '!$B$22","v":{"v":1752627.9070220094,"d":"1,752,628"}},{"v":491687.3786670197,"d":"491,687"},null,{"$f":"'Calc-costs Aus pop '!$B$32","v":{"v":1927088.5997097362,"d":"1,927,089"}},{"v":540631.09360182,"d":"540,631"},null,null,0,null,{"v":0.2805429359518039,"d":"0.28"}]
[45,null,0,null,{"$f":"'Calc-costs Aus pop '!$B$22","v":{"v":1752627.9070220094,"d":"1,752,628"}},{"v":477366.387055359,"d":"477,366"},null,{"$f":"'Calc-costs Aus pop '!$B$32","v":{"v":1927088.5997097362,"d":"1,927,089"}},{"v":524884.5568949709,"d":"524,885"},null,null,0,null,{"v":0.27237178247747956,"d":"0.27"}]
[46,null,0,null,{"$f":"'Calc-costs Aus pop '!$B$22","v":{"v":1752627.9070220094,"d":"1,752,628"}},{"v":463462.511704232,"d":"463,463"},null,{"$f":"'Calc-costs Aus pop '!$B$32","v":{"v":1927088.5997097362,"d":"1,927,089"}},{"v":509596.6571795834,"d":"509,597"},null,null,0,null,{"v":0.26443862376454325,"d":"0.26"}]
[47,null,0,null,{"$f":"'Calc-costs Aus pop '!$B$22","v":{"v":1752627.9070220094,"d":"1,752,628"}},{"v":449963.60359634174,"d":"449,964"},null,{"$f":"'Calc-costs Aus pop '!$B$32","v":{"v":1927088.5997097362,"d":"1,927,089"}},{"v":494754.0360966829,"d":"494,754"},null,null,0,null,{"v":0.256736527926741,"d":"0.26"}]
[48,null,0,null,{"$f":"'Calc-costs Aus pop '!$B$22","v":{"v":1752627.9070220094,"d":"1,752,628"}},{"v":436857.86756926385,"d":"436,858"},null,{"$f":"'Calc-costs Aus pop '!$B$32","v":{"v":1927088.5997097362,"d":"1,927,089"}},{"v":480343.72436571156,"d":"480,344"},null,null,0,null,{"v":0.24925876497741845,"d":"0.25"}]
[49,null,0,null,{"$f":"'Calc-costs Aus pop '!$B$22","v":{"v":1752627.9070220094,"d":"1,752,628"}},{"v":424133.852008994,"d":"424,134"},null,{"$f":"'Calc-costs Aus pop '!$B$32","v":{"v":1927088.5997097362,"d":"1,927,089"}},{"v":466353.13045214716,"d":"466,353"},null,null,0,null,{"v":0.24199880094894996,"d":"0.24"}]
[50,null,0,null,{"$f":"'Calc-costs Aus pop '!$B$22","v":{"v":1752627.9070220094,"d":"1,752,628"}},{"v":411780.4388436836,"d":"411,780"},null,{"$f":"'Calc-costs Aus pop '!$B$32","v":{"v":1927088.5997097362,"d":"1,927,089"}},{"v":452770.0295651915,"d":"452,770"},null,null,0,null,{"v":0.2349502921834466,"d":"0.23"}]
[51,null,0,null,{"$f":"'Calc-costs Aus pop '!$B$22","v":{"v":1752627.9070220094,"d":"1,752,628"}},{"v":399786.833828819,"d":"399,787"},null,{"$f":"'Calc-costs Aus pop '!$B$32","v":{"v":1927088.5997097362,"d":"1,927,089"}},{"v":439582.55297591403,"d":"439,583"},null,null,0,null,{"v":0.22810707978975397,"d":"0.23"}]
[52,null,0,null,{"$f":"'Calc-costs Aus pop '!$B$22","v":{"v":1752627.9070220094,"d":"1,752,628"}},{"v":388142.55711535824,"d":"388,143"},null,{"$f":"'Calc-costs Aus pop '!$B$32","v":{"v":1927088.5997097362,"d":"1,927,089"}},{"v":426779.1776465185,"d":"426,779"},null,null,0,null,{"v":0.22146318426189707,"d":"0.22"}]
[53,null,0,null,{"$f":"'Calc-costs Aus pop '!$B$22","v":{"v":1752627.9070220094,"d":"1,752,628"}},{"v":376837.43409258086,"d":"376,837"},null,{"$f":"'Calc-costs Aus pop '!$B$32","v":{"v":1927088.5997097362,"d":"1,927,089"}},{"v":414348.7161616685,"d":"414,349"},null,null,0,null,{"v":0.215012800254269,"d":"0.22"}]
[54,null,0,null,{"$f":"'Calc-costs Aus pop '!$B$22","v":{"v":1752627.9070220094,"d":"1,752,628"}},{"v":365861.58649765135,"d":"365,862"},null,{"$f":"'Calc-costs Aus pop '!$B$32","v":{"v":1927088.5997097362,"d":"1,927,089"}},{"v":402280.3069530763,"d":"402,280"},null,null,0,null,{"v":0.20875029150899907,"d":"0.21"}]
[55,null,0,null,{"$f":"'Calc-costs Aus pop '!$B$22","v":{"v":1752627.9070220094,"d":"1,752,628"}},{"v":355205.4237841275,"d":"355,205"},null,{"$f":"'Calc-costs Aus pop '!$B$32","v":{"v":1927088.5997097362,"d":"1,927,089"}},{"v":390563.40480881184,"d":"390,563"},null,null,0,null,{"v":0.20267018593106703,"d":"0.20"}]
[56,null,0,null,{"$f":"'Calc-costs Aus pop '!$B$22","v":{"v":1752627.9070220094,"d":"1,752,628"}},{"v":344859.6347418713,"d":"344,860"},null,{"$f":"'Calc-costs Aus pop '!$B$32","v":{"v":1927088.5997097362,"d":"1,927,089"}},{"v":379187.7716590406,"d":"379,188"},null,null,0,null,{"v":0.19676717080686118,"d":"0.20"}]
[57,null,0,null,{"$f":"'Calc-costs Aus pop '!$B$22","v":{"v":1752627.9070220094,"d":"1,752,628"}},{"v":334815.1793610402,"d":"334,815"},null,{"$f":"'Calc-costs Aus pop '!$B$32","v":{"v":1927088.5997097362,"d":"1,927,089"}},{"v":368143.4676301366,"d":"368,143"},null,null,0,null,{"v":0.19103608816200118,"d":"0.19"}]
[58,null,0,null,{"$f":"'Calc-costs Aus pop '!$B$22","v":{"v":1752627.9070220094,"d":"1,752,628"}},{"v":325063.2809330487,"d":"325,063"},null,{"$f":"'Calc-costs Aus pop '!$B$32","v":{"v":1927088.5997097362,"d":"1,927,089"}},{"v":357420.8423593558,"d":"357,421"},null,null,0,null,{"v":0.18547193025437006,"d":"0.19"}]
[59,null,0,null,{"$f":"'Calc-costs Aus pop '!$B$22","v":{"v":1752627.9070220094,"d":"1,752,628"}},{"v":315595.4183816007,"d":"315,595"},null,{"$f":"'Calc-costs Aus pop '!$B$32","v":{"v":1927088.5997097362,"d":"1,927,089"}},{"v":347010.5265624814,"d":"347,011"},null,null,0,null,{"v":0.18006983519841754,"d":"0.18"}]
[60,null,0,null,{"$f":"'Calc-costs Aus pop '!$B$22","v":{"v":1752627.9070220094,"d":"1,752,628"}},{"v":306403.31881708803,"d":"306,403"},null,{"$f":"'Calc-costs Aus pop '!$B$32","v":{"v":1927088.5997097362,"d":"1,927,089"}},{"v":336903.4238470693,"d":"336,903"},null,null,0,null,{"v":0.17482508271691022,"d":"0.17"}]
[61,null,0,null,{"$f":"'Calc-costs Aus pop '!$B$22","v":{"v":1752627.9070220094,"d":"1,752,628"}},{"v":297478.9503078525,"d":"297,479"},null,{"$f":"'Calc-costs Aus pop '!$B$32","v":{"v":1927088.5997097362,"d":"1,927,089"}},{"v":327090.702764145,"d":"327,091"},null,null,0,null,{"v":0.1697330900164177,"d":"0.17"}]
[62,null,0,null,{"$f":"'Calc-costs Aus pop '!$B$22","v":{"v":1752627.9070220094,"d":"1,752,628"}},{"v":288814.51486199273,"d":"288,815"},null,{"$f":"'Calc-costs Aus pop '!$B$32","v":{"v":1927088.5997097362,"d":"1,927,089"}},{"v":317563.78909140296,"d":"317,564"},null,null,0,null,{"v":0.16478940778292983,"d":"0.16"}]
[63,null,0,null,{"$f":"'Calc-costs Aus pop '!$B$22","v":{"v":1752627.9070220094,"d":"1,752,628"}},{"v":280402.44161358516,"d":"280,402"},null,{"$f":"'Calc-costs Aus pop '!$B$32","v":{"v":1927088.5997097362,"d":"1,927,089"}},{"v":308314.3583411679,"d":"308,314"},null,null,0,null,{"v":0.15998971629410663,"d":"0.16"}]
[64,null,0,null,{"$f":"'Calc-costs Aus pop '!$B$22","v":{"v":1752627.9070220094,"d":"1,752,628"}},{"v":272235.3802073642,"d":"272,235"},null,{"$f":"'Calc-costs Aus pop '!$B$32","v":{"v":1927088.5997097362,"d":"1,927,089"}},{"v":299334.32848657074,"d":"299,334"},null,null,0,null,{"v":0.1553298216447637,"d":"0.16"}]
[65,null,0,null,{"$f":"'Calc-costs Aus pop '!$B$22","v":{"v":1752627.9070220094,"d":"1,752,628"}},{"v":264306.1943760818,"d":"264,306"},null,{"$f":"'Calc-costs Aus pop '!$B$32","v":{"v":1927088.5997097362,"d":"1,927,089"}},{"v":290615.8528995833,"d":"290,616"},null,null,0,null,{"$f":"1/((1+$D$1)^(A73-1))","v":{"v":0.15080565208229488,"d":"0.15"}}]
[66,null,{"$f":"B74*N74","v":0},null,{"$f":"'Calc-costs Aus pop '!$B$22","v":{"v":1752627.9070220094,"d":"1,752,628"}},{"$f":"E74*N74","v":{"v":256607.95570493382,"d":"256,608"}},null,{"$f":"'Calc-costs Aus pop '!$B$32","v":{"v":1927088.5997097362,"d":"1,927,089"}},{"$f":"H74*N74","v":{"v":282151.3134947411,"d":"282,151"}},null,null,{"$f":"K74*N74","v":0},null,{"v":0.14641325444883,"d":"0.15"}]
[67,null,0,null,{"$f":"'Calc-costs Aus pop '!$B$22","v":{"v":1752627.9070220094,"d":"1,752,628"}},{"v":249133.93757760565,"d":"249,134"},null,{"$f":"'Calc-costs Aus pop '!$B$32","v":{"v":1927088.5997097362,"d":"1,927,089"}},{"v":273933.3140725642,"d":"273,933"},null,null,0,null,{"v":0.14214879072701941,"d":"0.14"}]
[68,null,0,null,{"$f":"'Calc-costs Aus pop '!$B$22","v":{"v":1752627.9070220094,"d":"1,752,628"}},{"v":241877.60929864622,"d":"241,878"},null,{"$f":"'Calc-costs Aus pop '!$B$32","v":{"v":1927088.5997097362,"d":"1,927,089"}},{"v":265954.6738568584,"d":"265,955"},null,null,0,null,{"v":0.1380085346864266,"d":"0.14"}]
[69,null,0,null,{"$f":"'Calc-costs Aus pop '!$B$22","v":{"v":1752627.9070220094,"d":"1,752,628"}},{"v":234832.6303870352,"d":"234,833"},null,{"$f":"'Calc-costs Aus pop '!$B$32","v":{"v":1927088.5997097362,"d":"1,927,089"}},{"v":258208.4212202509,"d":"258,208"},null,null,0,null,{"v":0.13398886862759865,"d":"0.13"}]
[70,null,0,null,{"$f":"'Calc-costs Aus pop '!$B$22","v":{"v":1752627.9070220094,"d":"1,752,628"}},{"v":227992.84503595653,"d":"227,993"},null,{"$f":"'Calc-costs Aus pop '!$B$32","v":{"v":1927088.5997097362,"d":"1,927,089"}},{"v":250687.7875924766,"d":"250,688"},null,null,0,null,{"v":0.13008628022096957,"d":"0.13"}]
[71,null,0,null,{"$f":"'Calc-costs Aus pop '!$B$22","v":{"v":1752627.9070220094,"d":"1,752,628"}},{"v":221352.27673393837,"d":"221,352"},null,{"$f":"'Calc-costs Aus pop '!$B$32","v":{"v":1927088.5997097362,"d":"1,927,089"}},{"v":243386.2015460938,"d":"243,386"},null,null,0,null,{"v":0.12629735943783454,"d":"0.13"}]
[72,null,0,null,{"$f":"'Calc-costs Aus pop '!$B$22","v":{"v":1752627.9070220094,"d":"1,752,628"}},{"v":214905.12304265858,"d":"214,905"},null,{"$f":"'Calc-costs Aus pop '!$B$32","v":{"v":1927088.5997097362,"d":"1,927,089"}},{"v":236297.28305446,"d":"236,297"},null,null,0,null,{"v":0.12261879557071313,"d":"0.12"}]
[73,null,0,null,{"$f":"'Calc-costs Aus pop '!$B$22","v":{"v":1752627.9070220094,"d":"1,752,628"}},{"v":208645.75052685302,"d":"208,646"},null,{"$f":"'Calc-costs Aus pop '!$B$32","v":{"v":1927088.5997097362,"d":"1,927,089"}},{"v":229414.83791695145,"d":"229,415"},null,null,0,null,{"v":0.1190473743404982,"d":"0.12"}]
[74,null,0,null,{"$f":"'Calc-costs Aus pop '!$B$22","v":{"v":1752627.9070220094,"d":"1,752,628"}},{"v":202568.6898318961,"d":"202,569"},null,{"$f":"'Calc-costs Aus pop '!$B$32","v":{"v":1927088.5997097362,"d":"1,927,089"}},{"v":222732.85234655478,"d":"222,733"},null,null,0,null,{"v":0.11557997508786232,"d":"0.12"}]
[75,null,0,null,{"$f":"'Calc-costs Aus pop '!$B$22","v":{"v":1752627.9070220094,"d":"1,752,628"}},{"v":196668.63090475355,"d":"196,669"},null,{"$f":"'Calc-costs Aus pop '!$B$32","v":{"v":1927088.5997097362,"d":"1,927,089"}},{"v":216245.48771510177,"d":"216,245"},null,null,0,null,{"v":0.11221356804646829,"d":"0.11"}]
[76,null,0,null,{"$f":"'Calc-costs Aus pop '!$B$22","v":{"v":1752627.9070220094,"d":"1,752,628"}},{"v":190940.41835412962,"d":"190,940"},null,{"$f":"'Calc-costs Aus pop '!$B$32","v":{"v":1927088.5997097362,"d":"1,927,089"}},{"v":209947.07545155508,"d":"209,947"},null,null,0,null,{"v":0.10894521169560026,"d":"0.11"}]
[77,null,0,null,{"$f":"'Calc-costs Aus pop '!$B$22","v":{"v":1752627.9070220094,"d":"1,752,628"}},{"v":185379.04694575694,"d":"185,379"},null,{"$f":"'Calc-costs Aus pop '!$B$32","v":{"v":1927088.5997097362,"d":"1,927,089"}},{"v":203832.11208888845,"d":"203,832"},null,null,0,null,{"v":0.10577205018990318,"d":"0.11"}]
[78,null,0,null,{"$f":"'Calc-costs Aus pop '!$B$22","v":{"v":1752627.9070220094,"d":"1,752,628"}},{"v":179979.65722889025,"d":"179,980"},null,{"$f":"'Calc-costs Aus pop '!$B$32","v":{"v":1927088.5997097362,"d":"1,927,089"}},{"v":197895.25445523154,"d":"197,895"},null,null,0,null,{"v":0.10269131086398368,"d":"0.10"}]
[79,null,0,null,{"$f":"'Calc-costs Aus pop '!$B$22","v":{"v":1752627.9070220094,"d":"1,752,628"}},{"v":174737.53129018468,"d":"174,738"},null,{"$f":"'Calc-costs Aus pop '!$B$32","v":{"v":1927088.5997097362,"d":"1,927,089"}},{"v":192131.31500507912,"d":"192,131"},null,null,0,null,{"v":0.09970030180969287,"d":"0.10"}]
[80,null,0,null,{"$f":"'Calc-costs Aus pop '!$B$22","v":{"v":1752627.9070220094,"d":"1,752,628"}},{"v":169648.08863124726,"d":"169,648"},null,{"$f":"'Calc-costs Aus pop '!$B$32","v":{"v":1927088.5997097362,"d":"1,927,089"}},{"v":186535.2572864846,"d":"186,535"},null,null,0,null,{"v":0.09679640952397367,"d":"0.10"}]
[81,null,0,null,{"$f":"'Calc-costs Aus pop '!$B$22","v":{"v":1752627.9070220094,"d":"1,752,628"}},{"v":164706.88216625951,"d":"164,707"},null,{"$f":"'Calc-costs Aus pop '!$B$32","v":{"v":1927088.5997097362,"d":"1,927,089"}},{"v":181102.1915402763,"d":"181,102"},null,null,0,null,{"v":0.09397709662521717,"d":"0.09"}]
[82,null,0,null,{"$f":"'Calc-costs Aus pop '!$B$22","v":{"v":1752627.9070220094,"d":"1,752,628"}},{"v":159909.59433617428,"d":"159,910"},null,{"$f":"'Calc-costs Aus pop '!$B$32","v":{"v":1927088.5997097362,"d":"1,927,089"}},{"v":175827.37042745276,"d":"175,827"},null,null,0,null,{"v":0.09123989963613317,"d":"0.09"}]
[83,null,0,null,{"$f":"'Calc-costs Aus pop '!$B$22","v":{"v":1752627.9070220094,"d":"1,752,628"}},{"v":155252.0333360915,"d":"155,252"},null,{"$f":"'Calc-costs Aus pop '!$B$32","v":{"v":1927088.5997097362,"d":"1,927,089"}},{"v":170706.18488102205,"d":"170,706"},null,null,0,null,{"v":0.08858242683119724,"d":"0.09"}]
[84,null,0,null,{"$f":"'Calc-costs Aus pop '!$B$22","v":{"v":1752627.9070220094,"d":"1,752,628"}},{"v":150730.12945251606,"d":"150,730"},null,{"$f":"'Calc-costs Aus pop '!$B$32","v":{"v":1927088.5997097362,"d":"1,927,089"}},{"v":165734.16007866221,"d":"165,734"},null,null,0,null,{"v":0.08600235614679345,"d":"0.09"}]
[85,null,0,null,{"$f":"'Calc-costs Aus pop '!$B$22","v":{"v":1752627.9070220094,"d":"1,752,628"}},{"v":146339.93150729712,"d":"146,340"},null,{"$f":"'Calc-costs Aus pop '!$B$32","v":{"v":1927088.5997097362,"d":"1,927,089"}},{"v":160906.95153268173,"d":"160,907"},null,null,0,null,{"v":0.08349743315222664,"d":"0.08"}]
[86,null,0,null,{"$f":"'Calc-costs Aus pop '!$B$22","v":{"v":1752627.9070220094,"d":"1,752,628"}},{"v":142077.60340514287,"d":"142,078"},null,{"$f":"'Calc-costs Aus pop '!$B$32","v":{"v":1927088.5997097362,"d":"1,927,089"}},{"v":156220.34129386581,"d":"156,220"},null,null,0,null,{"v":0.08106546907983171,"d":"0.08"}]
[87,null,0,null,{"$f":"'Calc-costs Aus pop '!$B$22","v":{"v":1752627.9070220094,"d":"1,752,628"}},{"v":137939.4207816921,"d":"137,939"},null,{"$f":"'Calc-costs Aus pop '!$B$32","v":{"v":1927088.5997097362,"d":"1,927,089"}},{"v":151670.23426588913,"d":"151,670"},null,null,0,null,{"v":0.07870433891245797,"d":"0.08"}]
[88,null,0,null,{"$f":"'Calc-costs Aus pop '!$B$22","v":{"v":1752627.9070220094,"d":"1,752,628"}},{"v":133921.7677492156,"d":"133,922"},null,{"$f":"'Calc-costs Aus pop '!$B$32","v":{"v":1927088.5997097362,"d":"1,927,089"}},{"v":147252.6546270768,"d":"147,253"},null,null,0,null,{"v":0.07641197952665821,"d":"0.08"}]
[89,null,0,null,{"$f":"'Calc-costs Aus pop '!$B$22","v":{"v":1752627.9070220094,"d":"1,752,628"}},{"v":130021.13373710257,"d":"130,021"},null,{"$f":"'Calc-costs Aus pop '!$B$32","v":{"v":1927088.5997097362,"d":"1,927,089"}},{"v":142963.74235638528,"d":"142,964"},null,null,0,null,{"v":0.07418638788995945,"d":"0.07"}]
[90,null,0,null,{"$f":"'Calc-costs Aus pop '!$B$22","v":{"v":1752627.9070220094,"d":"1,752,628"}},{"v":126234.11042437142,"d":"126,234"},null,{"$f":"'Calc-costs Aus pop '!$B$32","v":{"v":1927088.5997097362,"d":"1,927,089"}},{"v":138799.74986056823,"d":"138,800"},null,null,0,null,{"v":0.07202561931064023,"d":"0.07"}]
[91,null,0,null,{"$f":"'Calc-costs Aus pop '!$B$22","v":{"v":1752627.9070220094,"d":"1,752,628"}},{"v":122557.38876152562,"d":"122,557"},null,{"$f":"'Calc-costs Aus pop '!$B$32","v":{"v":1927088.5997097362,"d":"1,927,089"}},{"v":134757.0386995808,"d":"134,757"},null,null,0,null,{"v":0.06992778573848565,"d":"0.07"}]
[92,null,0,null,{"$f":"'Calc-costs Aus pop '!$B$22","v":{"v":1752627.9070220094,"d":"1,752,628"}},{"v":118987.75607915112,"d":"118,988"},null,{"$f":"'Calc-costs Aus pop '!$B$32","v":{"v":1927088.5997097362,"d":"1,927,089"}},{"v":130832.07640736,"d":"130,832"},null,null,0,null,{"v":0.06789105411503463,"d":"0.07"}]
[93,null,0,null,{"$f":"'Calc-costs Aus pop '!$B$22","v":{"v":1752627.9070220094,"d":"1,752,628"}},{"v":115522.09328072924,"d":"115,522"},null,{"$f":"'Calc-costs Aus pop '!$B$32","v":{"v":1927088.5997097362,"d":"1,927,089"}},{"v":127021.43340520388,"d":"127,021"},null,null,0,null,{"v":0.06591364477187828,"d":"0.07"}]
[94,null,0,null,{"$f":"'Calc-costs Aus pop '!$B$22","v":{"v":1752627.9070220094,"d":"1,752,628"}},{"v":112157.37211721287,"d":"112,157"},null,{"$f":"'Calc-costs Aus pop '!$B$32","v":{"v":1927088.5997097362,"d":"1,927,089"}},{"v":123321.78000505234,"d":"123,322"},null,null,0,null,{"v":0.06399382987560999,"d":"0.06"}]
[95,null,0,null,{"$f":"'Calc-costs Aus pop '!$B$22","v":{"v":1752627.9070220094,"d":"1,752,628"}},{"v":108890.65254098336,"d":"108,891"},null,{"$f":"'Calc-costs Aus pop '!$B$32","v":{"v":1927088.5997097362,"d":"1,927,089"}},{"v":119729.8835000508,"d":"119,730"},null,null,0,null,{"v":0.06212993191806794,"d":"0.06"}]
[96,null,0,null,{"$f":"'Calc-costs Aus pop '!$B$22","v":{"v":1752627.9070220094,"d":"1,752,628"}},{"v":105719.08013687703,"d":"105,719"},null,{"$f":"'Calc-costs Aus pop '!$B$32","v":{"v":1927088.5997097362,"d":"1,927,089"}},{"v":116242.60533985513,"d":"116,243"},null,null,0,null,{"v":0.060320322250551395,"d":"0.06"}]
[97,null,0,null,{"$f":"'Calc-costs Aus pop '!$B$22","v":{"v":1752627.9070220094,"d":"1,752,628"}},{"v":102639.88362803597,"d":"102,640"},null,{"$f":"'Calc-costs Aus pop '!$B$32","v":{"v":1927088.5997097362,"d":"1,927,089"}},{"v":112856.89838820888,"d":"112,857"},null,null,0,null,{"v":0.05856341966072952,"d":"0.06"}]
[98,null,0,null,{"$f":"'Calc-costs Aus pop '!$B$22","v":{"v":1752627.9070220094,"d":"1,752,628"}},{"v":99650.37245440384,"d":"99,650"},null,{"$f":"'Calc-costs Aus pop '!$B$32","v":{"v":1927088.5997097362,"d":"1,927,089"}},{"v":109569.80426039697,"d":"109,570"},null,null,0,null,{"v":0.05685768899099953,"d":"0.06"}]
[99,null,0,null,null,0,null,null,0,null,null,0,null,{"v":0.055201639797086935,"d":"0.06"}]
[100,null,0,null,null,0,null,null,0,null,null,0,null,{"v":0.05359382504571546,"d":"0.05"}]