{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["User interface","Sugar types","Formulas priming sugar addition"],"not_rendered":{"charts":3,"images":3,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"User interface","index":0,"n_rows":17,"n_cols":11,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[null,"PRIMING SUGAR/WATER SOLUTION' CALCULATOR - PER BOTTLE (Or full batch)"]
[null,"Includes different priming sugars."]
[null,"Please note that the values are based on the priciples publicly available on: ",null,null,"https://www.brewersfriend.com/beer-priming-calculator/"]
[null,"However, this tool allows you to quickly show how much sugar-water solution goes into each bottle, which can be easily added via a 10ml syringe which can be bough online relatively cheap. (see the image above as an example)."]
[]
[null,"Beer Style","Recommended CO2 Vol.",null,"Total volume per bottle (L)",null,"Beer temperature (C)","Required Vols. CO2","Bottling Sugar Type Used","Req. 'TABLE SUGAR' per bottle (g)","Required sugar PER BOTTLE (g)"]
[null,"British Style Ales","1.5 - 2.0 volumes",null,0.5,null,20,2.5,"Table Sugar",{"$f":"(IF(G8=20,(4.0081*H8-3.4161),IF(G8=19,(4.0119*H8-3.5237),IF(G8=18,(3.9961*H8-3.6923),\"\"))))*E8","v":3.3020749999999994},{"$f":"IF(I8='Sugar types'!A38,J8*'Sugar types'!D38,IF(I8='Sugar types'!A39,J8*'Sugar types'!D39,IF(I8='Sugar types'!A40,J8*'Sugar types'!D40,IF(I8='Sugar types'!A41,J8*'Sugar types'!D41,IF(I8='Sugar types'!A42,J8*'Sugar types'!D42,IF(I8='Sugar types'!A43,J8*'Sugar types'!D43,IF(I8='Sugar types'!A44,J8*'Sugar types'!D44,IF(I8='Sugar types'!A45,J8*'Sugar types'!D45,IF(I8='Sugar types'!A46,J8*'Sugar types'!D46,IF(I8='Sugar types'!A47,J8*'Sugar types'!D47,IF(I8='Sugar types'!A48,J8*'Sugar types'!D48,IF(I8='Sugar types'!A49,J8*'Sugar types'!D49,IF(I8='Sugar types'!A50,J8*'Sugar types'!D50,IF(I8='Sugar types'!A51,J8*'Sugar types'!D51,IF(I8='Sugar types'!A52,J8*'Sugar types'!D52,IF(I8='Sugar types'!A53,J8*'Sugar types'!D53,IF(I8='Sugar types'!A54,J8*'Sugar types'!D54,\"\")))))))))))))))))","v":3.3020749999999994}]
[null,"Belgian Ales","1.9 - 2.4 volumes"]
[null,"American Ales and Lager","2.2 - 2.7 volumes",null,"Amount of bottles",null,"Total sugar required (g)","Vol. Water for sollution (ml)","Required (ml) sugar solution per bottle","grams sugar/ml water","% priming sol. tot vol. Bottle"]
[null,"Fruit Lambic","3.0 - 4.5 volumes",null,60,null,{"$f":"K8*E11","v":198.12449999999995},300,{"$f":"IF(ISBLANK(H11),\"\",K8/J11)","v":5},{"$f":"G11/H11","v":0.66041499999999986},{"$f":"IF(ISBLANK(H11),\"\",I11/(E8*1000))","v":0.01}]
[null,"Porter, Stout","1.7 - 2.3 volumes"]
[null,"European Lagers","2.2 - 2.7 volumes",null,"True solution vol. after short boil (ml)",null,"The true volume of the solution will change due to evaporation and/or",null,"Sugar/Water Ratio",null,"The 'Sugar/Water Ratio' should always"]
[null,"Lambic","2.4 - 2.8 volumes",null,330,null,"impurities of the sugar. Measure the total solution volume AFTER it has",null,{"$f":"IF(ISBLANK(H11),\"\",G11/H11)","v":0.66041499999999986},null,"be below 1.8. If the ratio is above 1.8,"]
[null,"German Wheat Beer","3.3 - 4.5 volumes",null,null,null,"cooled down to room temp. The 'True solution vol. After short boil (ml)'",null,null,null,"not all sugar can be dissolved in the water."]
[null,null,null,null,"True required (ml) sugar solution per bottle","True grams sugar/ml water","will now be used to calculate 'Required (ml) sugar solution per bottle'."]
[null,null,null,null,{"$f":"IF(ISBLANK(E14),\"\",K8/F17)","v":5.5},{"$f":"G11/E14","v":0.60037727272727259},"This ensures that the correct amount of sugar is distributed per bottle."]

{"sheet":"Sugar types","index":1,"n_rows":54,"n_cols":12,"rows_kept":54,"cut":false,"hidden":false,"merged":[]}
["Different sugar type amount variations specifications per 1L of packaged beer at 20C"]
[null,null,null,null,null,"Bottle/Can Volumes"]
[null,null,null,null,null,0.15]
[null,null,null,null,null,0.25]
[null,null,null,null,null,0.3]
[null,null,null,null,null,0.33]
[null,null,null,null,null,0.35499999999999998]
[null,null,null,null,null,0.375]
[null,null,null,null,null,0.44]
[null,null,null,null,null,0.47299999999999998]
[null,null,null,null,null,0.5]
[null,null,null,null,null,0.75]
[null,null,null,null,null,1]
[]
[]
["Sugar type","1,5 Vol. CO2 req sugar (g)","1,6 Vol. CO2 req sugar (g)","1,7 Vol. CO2 req sugar ()","1,8 Vol. CO2 req sugar ()","1,9 Vol. CO2 req sugar (g)","2,0 Vol. CO2 req sugar (g)","2,1 Vol. CO2 req sugar (g)","2,2 Vol. CO2 req sugar (g)","2,3 Vol. CO2 req sugar (g)","2,4 Vol. CO2 req sugar (g)","2.5 Vol. CO2 req sugar (g)"]
["Table sugar",2.6,3,3.4,3.8,4.2,4.5999999999999996,5,5.4,5.8,6.2,6.6]
["Corn sugar",2.8,3.2,3.7,4.0999999999999996,4.5999999999999996,5,5.4,5.9,6.3,6.8,7.2]
["DME - All Varieties",3.8,4.3,4.9000000000000004,5.5,6.1,6.7,7.3,7.9,8.5,9.1,9.6]
["Belian Candy Syrup",4.0999999999999996,4.7,5.3,6,6.6,7.2,7.9,8.5,9.1,9.8000000000000007,10.4]
["Belian Candy sugar",3.4,3.9,4.5,5,5.5,6.1,6.6,7.1,7.7,8.1999999999999993,8.6999999999999993]
["Black Treacle",2.9,3.4,3.9,4.3,4.8,5.2,5.7,6.2,6.6,7.1,7.5]
["Brown sugar",2.9,3.3,3.8,4.2,4.7,5.0999999999999996,5.6,6,6.5,6.9,7.4]
["Corn Syrup",3.7,4.3,4.9000000000000004,5.4,6,6.6,7.2,7.8,8.3000000000000007,8.9,9.5]
["Demarara",2.6,3,3.4,3.8,4.2,4.5999999999999996,5,5.4,5.8,6.2,6.6]
["DME - Laalander",5.0999999999999996,5.9,6.7,7.5,8.3000000000000007,9.1,9.9,10.7,11.5,12.3,11.1]
["Honey",3.5,4,4.5,5.0999999999999996,5.6,6.2,6.7,7.2,7.8,8.3000000000000007,8.9]
["Invert sugar Syrup",2.8,3.2,3.7,4.0999999999999996,4.5999999999999996,5,5.4,5.9,6.3,6.8,7.2]
["Maple Syrup",3.3,3.8,4.4000000000000004,4.9000000000000004,5.4,5.9,6.4,7,7.5,8,8.5]
["Molasses",3.6,4.2,4.7,5.3,5.9,6.4,7,7.5,8.1,8.6999999999999993,9.1999999999999993]
["Rice Solids",3.2,3.7,4.2,4.8,5.3,5.8,6.3,6.8,7.3,7.8,8.3000000000000007]
["Sorhum Syrup",3.7,4.3,4.9000000000000004,5.4,6,6.6,7.2,7.8,8.3000000000000007,8.9,9.5]
["Turbinado",2.6,3,3.4,3.8,4.2,4.5999999999999996,5,5.4,5.8,6.2,6.6]
[]
[]
["Based on 1L being pakcaged"]
["Sugar type","Averae inrease per 0.1 vol. CO2 in (g)","1,5 Vol. CO2 req sugar (g)","Rate compared to 'table sugar'"]
["Table Sugar",{"$f":"(L17-K17)+(K17-J17)+(J17-I17)+(I17-H17)+(H17-G17)+(G17-F17)+(F17-E17)+(E17-D17)+(D17-C17)+(C17-B17)","v":3.9999999999999996},2.6,{"$f":"C38/$C$38","v":1}]
["Corn sugar",4.4000000000000004,2.8,1.0769230769230769]
["DME - All Varieties",5.8,3.8,1.4615384615384615]
["Belian Candy Syrup",6.3000000000000007,4.0999999999999996,1.5769230769230766]
["Belian Candy sugar",5.2999999999999989,3.4,1.3076923076923077]
["Black Treacle",4.5999999999999996,2.9,1.1153846153846154]
["Brown sugar",4.5,2.9,1.1153846153846154]
["Corn Syrup",5.8,3.7,1.4230769230769231]
["Demarara",3.9999999999999996,2.6,1]
["DME - Laalander",6,5.0999999999999996,1.9615384615384612]
["Honey",5.4,3.5,1.346153846153846]
["Invert sugar Syrup",4.4000000000000004,2.8,1.0769230769230769]
["Maple Syrup",5.2,3.3,1.2692307692307692]
["Molasses",5.6,3.6,1.3846153846153846]
["Rice Solids",5.1000000000000005,3.2,1.2307692307692308]
["Sorhum Syrup",5.8,3.7,1.4230769230769231]
["Turbinado",3.9999999999999996,2.6,1]

{"sheet":"Formulas priming sugar addition","index":2,"n_rows":62,"n_cols":2,"rows_kept":62,"cut":false,"hidden":false,"merged":[]}
["Beer Temp (C)","Package volume (L)"]
[20,1]
["Vol CO2","Sugar (g)"]
[0.86,0]
[1,0.6]
[1.1000000000000001,1]
[1.2,1.4]
[1.3,1.8]
[1.4,2.2000000000000002]
[1.5,2.6]
[1.6,3]
[1.7,3.4]
[1.8,3.8]
[1.9,4.2]
[2,4.5999999999999996]
[2.1,5]
[2.2000000000000002,5.4]
[2.2999999999999998,5.8]
[2.4,6.2]
[2.5,6.6]
[]
["Beer Temp (C)","Package volume (L)"]
[19,1]
["Vol CO2","Sugar (g)"]
[0.89,0]
[1,0.5]
[1.1000000000000001,0.9]
[1.2,1.3]
[1.3,1.7]
[1.4,2.1]
[1.5,2.5]
[1.6,2.9]
[1.7,3.3]
[1.8,3.7]
[1.9,4.0999999999999996]
[2,4.5]
[2.1,4.9000000000000004]
[2.2000000000000002,5.3]
[2.2999999999999998,5.7]
[2.4,6.1]
[2.5,6.5]
[]
["Beer Temp (C)","Package volume (L)"]
[18,1]
["Vol CO2","Sugar (g)"]
[0.92,0]
[1,0.3]
[1.1000000000000001,0.7]
[1.2,1.1000000000000001]
[1.3,1.5]
[1.4,1.9]
[1.5,2.2999999999999998]
[1.6,2.7]
[1.7,3.1]
[1.8,3.5]
[1.9,3.9]
[2,4.3]
[2.1,4.7]
[2.2000000000000002,5.0999999999999996]
[2.2999999999999998,5.5]
[2.4,5.9]
[2.5,6.3]