{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Planner","Info-Tabellen","Origineel recept"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":150,"comments":2,"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":"Planner","index":0,"n_rows":90,"n_cols":31,"rows_kept":90,"cut":false,"hidden":false,"merged":[[44,5,44,6],[43,9,43,11],[72,1,72,11],[33,6,33,8],[34,6,34,8],[35,6,35,8],[36,6,36,8],[49,7,49,9],[52,10,52,11],[42,3,42,4],[53,1,53,2],[46,4,46,5],[46,6,46,7],[47,10,47,11],[55,4,55,5],[39,6,39,8],[42,26,42,27],[40,6,40,8],[30,6,30,8],[37,26,37,27],[38,26,38,27],[36,26,36,27],[31,6,31,8],[34,26,34,27],[35,26,35,27],[30,26,31,27],[0,0,0,1],[1,0,1,1],[14,26,15,27],[18,26,19,27],[0,10,0,11],[1,10,1,11],[2,6,2,11],[2,3,2,5],[7,9,7,11],[1,26,2,27],[4,26,5,27],[8,9,8,11],[16,9,16,11],[57,4,57,5],[57,6,57,7],[27,4,27,5],[10,26,11,27],[18,34,18,35],[22,26,23,27],[26,26,27,27],[33,26,33,27],[37,6,37,8],[38,6,38,8],[39,26,39,27],[41,6,41,8],[42,6,42,8],[40,26,40,27],[41,26,41,27],[29,6,29,11]]}
["Recept 53",null," < Naam Bier",null,null,"Beslagdikte in L/kg >  ",4,{"$f":"IF(mashfactor>4.5,0,(5-mashfactor)/2.2)","v":0.45454545454545453},null,"Brouwdatum >","2015-09-02",null,null,null,null,null,null,null,"EBC","R","G","B","A",null,"EBC",null,"Info over de gekozen gist:     Naam >",{"$f":"HoofdGist","v":"Danstar Belle Saison"}]
["Saison",null,"< Type bier",null,null,"\"Extract Efficiëntie\" >",0.77,null,null,"Botteldatum  >","2015-09-12",null,null,null,null,null,null,null,0,255,255,255,0,null,{"$f":"$F$26","v":10.621964030407423},null,{"$f":"G3","v":"Belgische Saisongist"}]
["Gewenste liters bier >",10,"Gist >>","Danstar Belle Saison",null,null,{"$f":"VLOOKUP(HoofdGist,'Info-Tabellen'!$X:$AC,5,0)","v":"Belgische Saisongist"},null,null,null,null,null,null,null,null,null,null,null,1,247,249,180,45]
["Vast verlies installatie >",1,null,null,null," ketelinvloed (vaste parameter) > ",99.5,null,null,"Totale kooktijd >",90,{"$f":"IF(Aardbier=\"D\",-0.5,IF(Aardbier=\"M\",-0.3,IF(Aardbier=1,-0.8,2.5)))","v":-0.5},null,null,null,null,null,null,2,245,248,146,61,null,"R",null,"Info over de bottelgist:          Naam >",{"$f":"K53","v":0}]
["Kies een Maischprofiel >","D",null,"eiwitrust J/N ? >","N",null,"% verkoken/uur>",10,{"$f":"VLOOKUP(HoofdGist,'Info-Tabellen'!$X:$AB,2,0)","v":91},{"$f":"SUM($D$8:$D$18)","v":2.4082857142857144},{"$f":"IF(Eiwitrust=\"J\",10,0)","v":0},{"$f":"(totplato-VSPrestextract)/(2.0665-0.010665*(totplato))","v":5.9650297078611878},null,null,null,null,null,null,3,248,249,114,75,null,{"$f":"LOOKUP($Y$2,$S$2:$S$48,T2:T48)","v":224},null,{"$f":"VLOOKUP(bottelgist,'Info-Tabellen'!$X:$AB,5,0)","v":{"$error":"#N/A"}}]
["Geef opslagtemperatuur mout > ",20,null,null,null,"na beslagcorrectie op Extract Effic.>",{"$f":"IF(mashfactor<3.66,$G$2-((mashfactor)/1000)+0.00666,$G$2-((mashfactor)/20)+0.175)","v":0.74500000000000011},null,{"$f":"IF(moutkilos=0,\"\",IF(Aardbier=1,moutkilos*1.6*($B$30-mouttemp)/(mashwater*4.18),moutkilos*1.6*($B$29-mouttemp)/(mashwater*4.18)))","v":3.9403321137067273},null,"â te verwachten na koken â",null,null,null,{"$f":"VLOOKUP(HoofdGist,'Info-Tabellen'!$X:$AB,3,0)","v":107.5},"ter info",null,null,4,248,247,83,90,null,null,null,null,null,null,null,123456789]
["Grondstoffen","Opbrengst","EBC-kleur","kg â","°PLATO","EBC","%Gew.","%Stort","FG",{"$f":"SUM($E$8:$E$18)","v":12.713763315123025},{"$f":"(1+($J$7/(258.6-0.87955*$J$7)))*1000","v":1051.3858465532819},{"$f":"IF(ISNUMBER($J$7),$J$7*1.035,\"\")","v":13.15874503115233},null,"gist factor","SVG","LoviBond","EBC",null,5,245,248,48,121,null,"G"]
["Pilsmout 3",{"$f":"VLOOKUP(A8,'Info-Tabellen'!$H:$K,2,0)","v":80.069999999999993},{"$f":"VLOOKUP(A8,'Info-Tabellen'!$H:$K,3,0)","v":3},{"$f":"3.97/21*Gewenste_liters*112%","v":2.1173333333333333},{"$f":"IF(Gewenste_liters=0,\"0\",IF(D8=0,\"  \",(B8*D8/(Gewenste_liters+hopverlies))*effic))","v":11.232681987041037},{"$f":"IF(Gewenste_liters=0,\"0\",IF(D8=0,\"  \",1.8*(Q8)^0.69))","v":5.2610032610823989},{"$f":"IF(D8=\"\",\"  \",(D8*100/Totaalkg))","v":79.879275653923528},{"$f":"IF(E8=\"  \",\"  \",(E8*100/totplato))","v":75.54249363009113},{"$f":"IF(O8=0,\"\",E8-(E8*O8/100))","v":1.0058356142941296},"    te verwachten  uit suikers en",null,null,null,{"$f":"IF(D8=0,0,VLOOKUP(A8,'Info-Tabellen'!$H:$K,4,0))","v":100},{"$f":"IF(N8=0,0,(SVGopmout*N8/100)-ATNfactor-Aftrokmaische)","v":91.045454545454547},{"$f":"IF(C8=0,0,C8*0.3748+0.6)","v":1.7244000000000002},{"$f":"D8*C8/Gewenste_liters*effic*10","v":4.73224},null,6,245,244,18,137,null,{"$f":"LOOKUP($Y$2,$S$2:$S$48,U2:U48)","v":204}]
["Munich mout 15",{"$f":"VLOOKUP(A9,'Info-Tabellen'!$H:$J,2,0)","v":80.069999999999993},{"$f":"VLOOKUP(A9,'Info-Tabellen'!$H:$J,3,0)","v":15},{"$f":"(0.255+0.051)/21*Gewenste_liters","v":0.14571428571428571},{"$f":"IF(Gewenste_liters=0,\"0\",IF(D9=0,\"  \",(B9*D9/(Gewenste_liters+hopverlies))*effic))","v":0.77303002159827217},2.5198794972617482,5.4972693302673177,5.1988132086199812,6.9221324661299821E-2," â   extracten   â",null,null,null,{"$f":"IF(D9=0,0,VLOOKUP(A9,'Info-Tabellen'!$H:$K,4,0))","v":100},91.045454545454547,{"$f":"IF(C9=0,0,C9*0.3748+0.6)","v":6.2219999999999995},{"$f":"D9*C9/Gewenste_liters*effic*10","v":1.6283571428571431},null,7,238,233,22,135,null,null,null,"Info over de gekozen hopsoorten:   (A) = aroma (B) = Bitter (U) = Universeel"]
["Tarwevlokken",{"$f":"VLOOKUP(A10,'Info-Tabellen'!$H:$J,2,0)","v":73.58},{"$f":"VLOOKUP(A10,'Info-Tabellen'!$H:$J,3,0)","v":4},{"$f":"0.305/21*Gewenste_liters","v":0.14523809523809525},0.70805130648371672,1.0099905332174735,5.4793043978154641,4.7618156885000449,6.340277608058742E-2,{"$f":"SUM($E$19:$E$22)","v":2.1555922585016729},{"$f":"(1+($J$10/(258.6-0.87955*$J$10)))*1000","v":1008.3971883900331},{"$f":"IF(ISNUMBER($J$10),$J$10,\"\")","v":2.1555922585016729},null,{"$f":"IF(D10=0,0,VLOOKUP(A10,'Info-Tabellen'!$H:$K,4,0))","v":100},91.045454545454547,2.0992000000000002,0.43280952380952392,null,8,230,225,24,160,null,"B",null,{"$f":"_hop1","v":"Styrian Golding (A)"}]
["  - - Kies mout of graan - -",{"$f":"VLOOKUP(A11,'Info-Tabellen'!$H:$J,2,0)","v":0},{"$f":"VLOOKUP(A11,'Info-Tabellen'!$H:$J,3,0)","v":0},null,"  ","  ","  ","  ","",null,"â te verwachten totaal â",null,null,{"$f":"IF(D11=0,0,VLOOKUP(A11,'Info-Tabellen'!$H:$K,4,0))","v":0},0,0,0,null,9,229,214,30,163,null,{"$f":"LOOKUP($Y$2,$S$2:$S$48,V2:V48)","v":32},null,{"$f":"VLOOKUP(_hop1,'Info-Tabellen'!$R:$V,3,0)","v":"Delicaat, iets pikant en grasachtig/bloemig. Zeer populair vanwege karakteristieke aroma en gemiddelde alpha waarden"}]
["  - - Kies mout of graan - -",{"$f":"VLOOKUP(A12,'Info-Tabellen'!$H:$J,2,0)","v":0},{"$f":"VLOOKUP(A12,'Info-Tabellen'!$H:$J,3,0)","v":0},null,"  ","  ","  ","  ","",{"$f":"IF(ISNUMBER(totplato),totplato,\"\")","v":14.869355573624699},{"$f":"(1+(totplato/(258.6-0.87955*totplato)))*1000","v":1060.5622969324361},{"$f":"IF(ISNUMBER($J$12),$L$7+$L$10,\"\")","v":15.314337289654002},null,{"$f":"IF(D12=0,0,VLOOKUP(A12,'Info-Tabellen'!$H:$K,4,0))","v":0},0,0,0,null,10,224,204,32,165]
["  - - Kies mout of graan - -",{"$f":"VLOOKUP(A13,'Info-Tabellen'!$H:$J,2,0)","v":0},{"$f":"VLOOKUP(A13,'Info-Tabellen'!$H:$J,3,0)","v":0},null,"  ","  ","  ","  ","",null,"â voorspelling eind SG",null,null,{"$f":"IF(D13=0,0,VLOOKUP(A13,'Info-Tabellen'!$H:$K,4,0))","v":0},0,0,0,null,11,218,196,41,168,null,"A"]
["  - - Kies mout of graan - -",{"$f":"VLOOKUP(A14,'Info-Tabellen'!$H:$J,2,0)","v":0},{"$f":"VLOOKUP(A14,'Info-Tabellen'!$H:$J,3,0)","v":0},null,"  ","  ","  ","  ","",{"$f":"voorsp_eindplato","v":0.97679029564839137},{"$f":"voorsp_eindSG","v":1003.2819339085073}," - - - - ",null,{"$f":"IF(D14=0,0,VLOOKUP(A14,'Info-Tabellen'!$H:$K,4,0))","v":0},0,0,0,null,12,212,184,39,170,null,{"$f":"LOOKUP($Y$2,$S$2:$S$48,W2:W48)","v":165},null,{"$f":"_hop2","v":"Styrian Golding (A)"}]
["  - - Kies mout of graan - -",{"$f":"VLOOKUP(A15,'Info-Tabellen'!$H:$J,2,0)","v":0},{"$f":"VLOOKUP(A15,'Info-Tabellen'!$H:$J,3,0)","v":0},null,"  ","  ","  ","  ","",{"$f":"SUM(I8:I18)","v":1.1384597150360167},"<Gr FG Skr>",{"$f":"SUM(I19:I23)","v":-0.16166941938762536},null,{"$f":"IF(D15=0,0,VLOOKUP(A15,'Info-Tabellen'!$H:$K,4,0))","v":0},0,0,0,null,13,208,176,46,173,null,null,null,{"$f":"VLOOKUP(_hop2,'Info-Tabellen'!$R:$V,3,0)","v":"Delicaat, iets pikant en grasachtig/bloemig. Zeer populair vanwege karakteristieke aroma en gemiddelde alpha waarden"}]
["  - - Kies mout of graan - -",{"$f":"VLOOKUP(A16,'Info-Tabellen'!$H:$J,2,0)","v":0},{"$f":"VLOOKUP(A16,'Info-Tabellen'!$H:$J,3,0)","v":0},null,"  ","  ","  ","  ","",null,"Nodige Gist:",{"$f":"VLOOKUP(HoofdGist,'Info-Tabellen'!$X:$AC,6,0)","v":"k"},null,{"$f":"IF(D16=0,0,VLOOKUP(A16,'Info-Tabellen'!$H:$K,4,0))","v":0},0,0,0,null,14,202,167,52,175,null,"RGB_set"]
["  - - Kies mout of graan - -",{"$f":"VLOOKUP(A17,'Info-Tabellen'!$H:$J,2,0)","v":0},{"$f":"VLOOKUP(A17,'Info-Tabellen'!$H:$J,3,0)","v":0},null,"  ","  ",{"$f":"IF(D17=\"\",\"  \",(D17*100/Totaalkg))","v":"  "},{"$f":"IF(E17=\"  \",\"  \",(E17*100/totplato))","v":"  "},"",{"$f":" IF(L16=\"k\",INT(Gewenste_liters/20*mashplato),\"starter in stappen opkweken:\")","v":6},null,null,null,{"$f":"IF(D17=0,0,VLOOKUP(A17,'Info-Tabellen'!$H:$K,4,0))","v":0},0,0,0,null,15,194,156,54,178,null,{"$f":"SetRGB(Y5,Y8,Y11,Y14)","v":2149600}]
["CaraMunich (Cara 120)",{"$f":"VLOOKUP(A18,'Info-Tabellen'!$H:$J,2,0)","v":75},{"$f":"VLOOKUP(A18,'Info-Tabellen'!$H:$J,3,0)","v":120},null,"  ","  ","  ","  ","",{"$f":"IF(L16=\"k\",\" vooraf  te\",\"maken\")","v":" vooraf  te"},{"$f":"IF(L16=\"k\",\"rehydrateren\",(INT(160*Starter/100))*90)","v":"rehydrateren"},{"$f":"IF(L16=\"k\",\"in water 25°\",\"moutextract \")","v":"in water 25°"},null,{"$f":"IF(D18=0,0,VLOOKUP(A18,'Info-Tabellen'!$H:$K,4,0))","v":0},0,45.576000000000001,0,null,16,190,147,57,180,null,null,null,{"$f":"_hop3","v":"Saaz CZ  (A)"}]
["Kristalsuiker",{"$f":"VLOOKUP(A19,'Info-Tabellen'!$M:$O,2,0)","v":100},{"$f":"VLOOKUP(A19,'Info-Tabellen'!$M:$O,3,0)","v":4.5001013284581759E-3},{"$f":"0.509/21*Gewenste_liters","v":0.24238095238095239},{"$f":"IF(Gewenste_liters=0,\"0\",IF(D19=0,\"  \",(B19*D19/(Gewenste_liters+hopverlies))))","v":2.1555922585016729},{"$f":"IF(Gewenste_liters=0,\"0\",IF(D19=0,\"  \",B19*D19/10/Gewenste_liters*C19))","v":1.0907388458024818E-3},9.1441506179936756,14.496877472788855,-0.16166941938762536,{"$f":"IF(L16=\"k\",\"\",INT(Starter*totplato/4))","v":""},{"$f":"IF(L16=\"k\",\"\",\"gistvoeding,\")","v":""},{"$f":"IF(L16=\"k\",\"\",\"koken in \")","v":""},null,{"$f":"IF(D19=0,0,VLOOKUP(A19,'Info-Tabellen'!$M:$P,4,0))","v":100},{"$f":"IF(N19=0,0,(SVGopsuiker*N19/100))","v":107.5},0.60168663797790611,null,null,17,193,145,59,201,null,null,null,{"$f":"VLOOKUP(_hop3,'Info-Tabellen'!$R:$V,3,0)","v":"Koning van de pilshop. De enige hop die gebruikt wordt in het oorspronkelijke pils ter wereld: Pilsner Urquell. "}]
[" - - Kies suiker of extract - -",{"$f":"VLOOKUP(A20,'Info-Tabellen'!$M:$O,2,0)","v":0},{"$f":"VLOOKUP(A20,'Info-Tabellen'!$M:$O,3,0)","v":0},null,{"$f":"IF(Gewenste_liters=0,\"0\",IF(D20=0,\"  \",(B20*D20/(Gewenste_liters+hopverlies))))","v":"  "},{"$f":"IF(Gewenste_liters=0,\"0\",IF(D20=0,\"  \",B20*D20/10/Gewenste_liters*C20))","v":"  "},"  ","  ","",{"$f":"IF(L16=\"k\",\"\",Starter*1.05)","v":""},{"$f":"IF(L16=\"k\",\"\",\"water    =\")","v":""},{"$f":"IF(L16=\"k\",\"\",mashplato/2.5*Gewenste_liters/100)","v":""},null,{"$f":"IF(D20=0,0,VLOOKUP(A20,'Info-Tabellen'!$M:$P,4,0))","v":0},{"$f":"IF(N20=0,0,(SVGopsuiker*N20/100))","v":0},0,null,null,18,192,140,61,202]
[" - - Kies suiker of extract - -",{"$f":"VLOOKUP(A21,'Info-Tabellen'!$M:$O,2,0)","v":0},{"$f":"VLOOKUP(A21,'Info-Tabellen'!$M:$O,3,0)","v":0},null,{"$f":"IF(Gewenste_liters=0,\"0\",IF(D21=0,\"  \",(B21*D21/(Gewenste_liters+hopverlies))))","v":"  "},{"$f":"IF(Gewenste_liters=0,\"0\",IF(D21=0,\"  \",B21*D21/10/Gewenste_liters*C21))","v":"  "},"  ","  ","",null,"±Nodige liters kookwort @100°Câ",null,null,{"$f":"IF(D21=0,0,VLOOKUP(A21,'Info-Tabellen'!$M:$P,4,0))","v":0},{"$f":"IF(N21=0,0,(SVGopsuiker*N21/100))","v":0},0,null,null,19,191,135,59,204]
[" - - Kies suiker of extract - -",{"$f":"VLOOKUP(A22,'Info-Tabellen'!$M:$O,2,0)","v":0},{"$f":"VLOOKUP(A22,'Info-Tabellen'!$M:$O,3,0)","v":0},null,{"$f":"IF(Gewenste_liters=0,\"0\",IF(D22=0,\"  \",(B22*D22/(Gewenste_liters+hopverlies))))","v":"  "},{"$f":"IF(Gewenste_liters=0,\"0\",IF(D22=0,\"  \",B22*D22/10/Gewenste_liters*C22))","v":"  "},"  ","  ","","@ 75°C >",{"$f":"($L$27+verlieswater)*1.03","v":13.349812221733247},{"$f":"($L$27+verlieswater)*1.04","v":13.479422049128715},null,{"$f":"IF(D22=0,0,VLOOKUP(A22,'Info-Tabellen'!$M:$P,4,0))","v":0},{"$f":"IF(N22=0,0,(SVGopsuiker*N22/100))","v":0},0,null,null,20,191,130,58,205,null,null,null,{"$f":"_hop4","v":" - - Kies hop - -"}]
[" - - Kies suiker of extract - -",{"$f":"VLOOKUP(A23,'Info-Tabellen'!$M:$O,2,0)","v":0},{"$f":"VLOOKUP(A23,'Info-Tabellen'!$M:$O,3,0)","v":0},null,{"$f":"IF(Gewenste_liters=0,\"0\",IF(D23=0,\"  \",(B23*D23/(Gewenste_liters+hopverlies))))","v":"  "},{"$f":"IF(Gewenste_liters=0,\"0\",IF(D23=0,\"  \",B23*D23/10/Gewenste_liters*C23))","v":"  "},"  ","  ","",null,"Totaal aantal L water brouwsel  â",null,null,{"$f":"IF(D23=0,0,VLOOKUP(A23,'Info-Tabellen'!$M:$P,4,0))","v":0},{"$f":"IF(N23=0,0,(SVGopsuiker*N23/100))","v":0},0,null,null,21,191,127,56,206,null,null,null,{"$f":"VLOOKUP(_hop4,'Info-Tabellen'!$R:$V,3,0)","v":0}]
["Clarimalt of Caramelkleur in gram!",100,9000,null," - - - ",{"$f":"IF(Gewenste_liters=0,\"0\",IF(D24=0,\"  \",D24/Gewenste_liters*C24/1000))","v":"  "},{"$f":"IF(D24=\"\",\"  \",(D24*0.1/Totaalkg))","v":"  "},null,null,{"$f":"0.1808*totplato+0.8192*voorsp_eindplato","v":3.4885660979065074},{"$f":"IF($L$10=0,1.035,$L$12/$J$12)","v":1.0299260928845237},{"$f":"IF((Gewenste_liters+(1.7*moutkilos)*1.2)<mashwater,mashwater+verkookwater,($K$22*1.18)+(moutkilos*0.75))","v":17.558992707359515},null,0,0,3373.8,null,null,22,193,120,56,208]
["Voorspellingen > >",null,"Totalen>>",{"$f":"SUM(D8:D23)","v":2.6506666666666669},{"$f":"SUM(E8:E24)","v":14.869355573624699},{"$f":"SUM(F8:F24)","v":8.7919640304074225},"< TOT. EBC Kleur",null,{"$f":" SUM(I8:I23)","v":0.97679029564839137},"<< Voorspelling eind °Plato",null,null,null,null,null,null,null,null,23,190,116,57,209]
[null,null,null,"SG >>",{"$f":"StamwortSG","v":1060.5622969324361},{"$f":"IF(kleur=0,0,kleur+(1.22*Kooktijd/60))","v":10.621964030407423},"< EBC kookkleur",null,{"$f":"IF(voorsp_eindplato=0,1000,259/(259.12955-voorsp_eindplato)*1000)","v":1003.2819339085073},"<< Voorspelling eind S.G.",null,null,null,null,null,null,null,null,24,188,112,57,225,null,null,null,{"$f":"_hop5","v":" - - Kies hop - -"}]
["Maischen ",null,null,null,null,null,"Voorspelling alcohol vóór bottelen ongeveer > ",{"$f":"IF((totplato-VSPrestextract)/(2.0665-0.010665*totplato)=0,0,voorsp_eindSG/1000*VSPalcogewicht/0.794/100)","v":7.5372878351696093E-2},"volume",null,"Nodige wort bij 20°C >",{"$f":"Gewenste_liters*(1+VSPalcvol/4)","v":10.188432195879241},null,null,null,null,null,null,25,186,106,50,225,null,null,null,{"$f":"VLOOKUP(_hop5,'Info-Tabellen'!$R:$V,3,0)","v":0}]
["Storten in >",{"$f":"moutkilos*mashfactor*1.02","v":9.825805714285714},"water van",{"$f":"IF(moutkilos=0,55,IF(Aardbier=1,($B$30+tempverlies)*ketelinvloed/100,($B$29+tempverlies)*ketelinvloed/100))","v":65.610630453138199},"â bierkleur â",null,null,null,"corrigeer pH na 10' (5,4-5,8)",null,null,null,null,null,null,null,null,null,26,186,101,51,226]
[{"$f":"IF(Aardbier=1,\"éénstaps maisch,\",IF(Eiwitrust=\"N\",\"Geen eiwitrust, direct naar \",\"1e fase, Eiwitrust\"))","v":"Geen eiwitrust, direct naar "},{"$f":"IF(Aardbier=1,\"      er is\",IF(Eiwitrust=\"J\",54,$B$30))","v":62},{"$f":"IF(Aardbier=1,\"dus geen \",IF(Eiwitrust=\"J\",\"± 2° C\",\"\"))","v":""},{"$f":"IF(Aardbier=1,\"eiwitrust   \",IF(Eiwitrust=\"J\",K5,\"\"))","v":""},null,null,null,null,null,null,"Beslagketel moet minstens een volume hebben van >",{"$f":"IF(moutkilos=0,\"\",moutkilos+mashwater)","v":12.234091428571428},null,null,null,null,null,null,27,181,100,53,227]
[{"$f":"IF(Aardbier=1,\"éénstaps maisch \",\"β amylase (maltose)\")","v":"β amylase (maltose)"},{"$f":"IF(Aardbier=1,66,IF(Aardbier=\"D\",62,63))","v":62},{"$f":"IF(Aardbier=1,\"± 1,5°C\",IF(Aardbier=\"D\",\"± 1,5°C\",\"± 2°C\"))","v":"± 1,5°C"},{"$f":"IF(Aardbier=1,90,IF(Aardbier=\"Z\",25-($K$5/2),45-($K$5/2)))","v":45},null,null,"Vóór het koken moet het wort (zonder de suiker) een densiteit",null,null,null,null,null,null,null,null,null,null,null,28,177,96,55,227,null,null,null,{"$f":"_hop6","v":" - - Kies hop - -"}]
[{"$f":"IF(Aardbier=\"D\",\"Gemengde amylase \",IF(Aardbier=\"Z\",\"Ga snel naar volgende stap\",\"\"))","v":"Gemengde amylase "},{"$f":"IF(Aardbier=\"D\",\"66,5\",\"\")","v":"66,5"},{"$f":"IF(Aardbier=\"D\",\"± 1,5°C\",\"\")","v":"± 1,5°C"},{"$f":"IF(Aardbier=\"D\",15,\"\")","v":15},null,null," hebben van ±  :   ",null,null,{"$f":"mashplato*($L$27+verkookwater-Vast_verlies)/$L$22","v":10.107966721604349},{"$f":"(1+($J$31/(258.6-0.87955*$J$31)))*1000","v":1040.4788972332569},{"$f":"IF(ISNUMBER($J$31),$J$31*1.035,\"\")","v":10.4617455568605},null,null,null,null,null,null,29,168,92,55,228,null,null,null,{"$f":"VLOOKUP(_hop6,'Info-Tabellen'!$R:$V,3,0)","v":0}]
[{"$f":"IF(Aardbier=1,\"\",\"α amylase (body) \")","v":"α amylase (body) "},{"$f":"IF(Aardbier=1,\"\",72)","v":72},{"$f":"IF(Aardbier=1,\"\",IF(Aardbier=\"D\",\"± 1,5°C\",\"± 2°C\"))","v":"± 1,5°C"},{"$f":"IF(Aardbier=1,\"\",IF(Aardbier=\"Z\",30,20))","v":20},null,null,null,null,null,null,null,"Min.vermogen heater â",null,null,null,null,null,null,30,165,88,54,229]
["Filterspoelen:  ga naar","75..78°",null,"nodige L spoelwater >",{"$f":"IF(mashplato<SUM(E19:E23),Vast_verlies,IF(mashplato=0,0,totaalvolume-mashwater))","v":7.7331869930738009},"Max.80°","< Pas spoelwater aan: pH 5,2 à 5,5",null,null,null,null,{"$f":"$K$22/6.5","v":2.0538172648820381},null,null,null,null,null,null,31,158,86,57,229,null,null,null,"Noteer: FWH= First Wort Hopping = als het gefilterd wort boven 90°zit, tot net vóór koken toevoegen."]
["STOP spoelen bij SG",{"$f":"259/(259.12955-C34)*1000","v":1011.2070239454996},{"$f":"IF(mashplato<13.4,3,mashplato*mashplato/58)","v":3},{"$f":"C34*1.035","v":3.1049999999999995},1043,null,"Kruiden / Kookadditieven",null,null,"aantal","unit","na…min.",null,null,null,null,null,null,32,149,81,56,240,null,null,null,"Adviezen voor de gekozen brouwzouten, kruiden, specerijen en additieven"]
["Koken: Kies Hopsoort â","Type â","aantal gram","% alfazuur","na…min","=IBUâ","Zinksulfaat",null,null,null,{"$f":"VLOOKUP(G35,'Info-Tabellen'!$AE:$AG,2,0)","v":"g "},null,null,null,"water in hop â    ","cor.tijdstip","BitterFactor",null,33,142,77,52,240,null,null,null,{"$f":"VLOOKUP(G35,'Info-Tabellen'!$AE:$AG,3,0)","v":"Sporenelement IN GISTSTARTER TE DOEN!, 0,5 g / hectoliter wort"}]
["Styrian Golding (A)","BLM",{"$f":"23/21*Gewenste_liters","v":10.952380952380953},{"$f":"VLOOKUP(_hop1,'Info-Tabellen'!$R:$T,2,0)","v":3.5},{"$f":"Kooktijd-1","v":89},{"$f":"IF(E36=\"\",\"\",IF(C36=0,\"  \",IF(P36>Kooktijd,0,IF(B36=\"PELL\",TANH(PI()*(Kooktijd-P36)/120)*Q36*C36*D36*10/Gewenste_liters*1.1,TANH(PI()*(Kooktijd-P36)/120)*Q36*C36*D36*10/Gewenste_liters))))","v":0.26203612964824219},"Biersol",null,null,null,{"$f":"VLOOKUP(G36,'Info-Tabellen'!$AE:$AG,2,0)","v":"ml"},null,null,null,{"$f":"IF(B36=\"BLM\",C36*0.006,C36*0.00267)","v":6.5714285714285711E-2},{"$f":"IF(E36=\"\",\"\",IF(E36=\"FWH\",0,IF(E36=\"koud\",Kooktijd,E36)))","v":89},{"$f":"IF(E36=\"\",\"\",IF(E36=\"FWH\",0.398*0.000125^(MaischSG/1000-1),0.398*0.000275^(MaischSG/1000-1)))","v":0.2611651164693185},null,34,135,72,48,240,null,null,null,{"$f":"VLOOKUP(G36,'Info-Tabellen'!$AE:$AG,3,0)","v":"Kiezelsol om trub beter neer te slaan 3ml/10liter direct na koken"}]
["Styrian Golding (A)","BLM",{"$f":"30/21*Gewenste_liters*105%","v":15.000000000000002},{"$f":"VLOOKUP(_hop2,'Info-Tabellen'!$R:$T,2,0)","v":3.5},37,12.101858206406749," - - Kies additief - -",null,null,null,{"$f":"VLOOKUP(G37,'Info-Tabellen'!$AE:$AG,2,0)","v":"-"},null,null,null,9.0000000000000011E-2,37,0.2611651164693185,null,35,130,70,46,241,null,null,null,{"$f":"VLOOKUP(G37,'Info-Tabellen'!$AE:$AG,3,0)","v":"-"}]
["Saaz CZ  (A)","BLM",{"$f":"10/21*Gewenste_liters*310%","v":14.761904761904763},{"$f":"VLOOKUP(_hop3,'Info-Tabellen'!$R:$T,2,0)","v":2.8},37,9.527812175202774," - - Kies additief - -",null,null,null,{"$f":"VLOOKUP(G38,'Info-Tabellen'!$AE:$AG,2,0)","v":"-"},null,null,null,8.8571428571428579E-2,37,0.2611651164693185,null,36,119,64,38,241,null,null,null,{"$f":"VLOOKUP(G38,'Info-Tabellen'!$AE:$AG,3,0)","v":"-"}]
[" - - Kies hop - -","BLM",null,{"$f":"VLOOKUP(_hop4,'Info-Tabellen'!$R:$T,2,0)","v":0},null,""," - - Kies additief - -",null,null,null,{"$f":"VLOOKUP(G39,'Info-Tabellen'!$AE:$AG,2,0)","v":"-"},null,null,null,0,"","",null,37,111,62,36,241,null,null,null,{"$f":"VLOOKUP(G39,'Info-Tabellen'!$AE:$AG,3,0)","v":"-"}]
[" - - Kies hop - -","BLM",null,{"$f":"VLOOKUP(_hop5,'Info-Tabellen'!$R:$T,2,0)","v":0},null,""," - - Kies additief - -",null,null,null,{"$f":"VLOOKUP(G40,'Info-Tabellen'!$AE:$AG,2,0)","v":"-"},null,null,null,0,"","",null,38,105,56,28,242,null,null,null,{"$f":"VLOOKUP(G40,'Info-Tabellen'!$AE:$AG,3,0)","v":"-"}]
[" - - Kies hop - -","PELL",null,{"$f":"VLOOKUP(_hop6,'Info-Tabellen'!$R:$T,2,0)","v":0},null,""," - - Kies additief - -",null,null,null,{"$f":"VLOOKUP(G41,'Info-Tabellen'!$AE:$AG,2,0)","v":"-"},null,null,null,0,"","",null,39,99,52,25,242,null,null,null,{"$f":"VLOOKUP(G41,'Info-Tabellen'!$AE:$AG,3,0)","v":"-"}]
["Geïsomeriseerd Extract  >","- -",null,6,"(Nadien)",{"$f":"IF(C42=0,\"  \",C42*D42/Gewenste_liters)","v":"  "}," - - Kies additief - -",null,null,null,{"$f":"VLOOKUP(G42,'Info-Tabellen'!$AE:$AG,2,0)","v":"-"},null,null,"vast verlies > ",{"$f":"Vast_verlies","v":1},"liter",null,null,40,91,50,20,242,null,null,null,{"$f":"VLOOKUP(G42,'Info-Tabellen'!$AE:$AG,3,0)","v":"-"}]
["Advies: Einde Koken, pH best tussen 5,1 en 5,4.",null,null,"Totaal IBU >>",null,{"$f":"SUM(F36:F42)","v":21.891706511257766}," - - Kies additief - -",null,null,null,{"$f":"VLOOKUP(G43,'Info-Tabellen'!$AE:$AG,2,0)","v":"-"},null,null,"blijft achter > ",{"$f":"SUM(O36:O42)","v":1.2442857142857142},"liter",null,null,41,83,45,15,243,null,null,null,{"$f":"VLOOKUP(G43,'Info-Tabellen'!$AE:$AG,3,0)","v":"-"}]
["Einde koken: De gemeten pH >",null,{"$f":"VLOOKUP(HoofdGist,'Info-Tabellen'!$X:$AB,4,0)","v":"22...30"},"<  Advies Vergistings T°",null,null,null,"Toegepaste T° >",25," â Vóór het koken (@75°C) â",null,null,null,"verkookwater > ",{"$f":"verkookpercent/100*Kooktijd/60*$L$27","v":1.5282648293818861},"< extra water bij te rekenen",null,null,42,74,41,7,243]
["Indien High Gravity  > >","Koudwater>",0,"Spoelwater>",{"$f":"IF(C45=\"\",\"\",$E$33-$C$45)","v":7.7331869930738009},"Stop spoelen bij >",null,{"$f":"IF(C45=\"\",\"\",259/(259.12955-I45)*1000)","v":1011.2070239454996},{"$f":"IF(C45=\"\",\"\",$C$34*Gewenste_liters/(Gewenste_liters-C45))","v":3},{"$f":"IF(C45=\"\",\"\",$K$22/Gewenste_liters*(Gewenste_liters-$C$45))","v":13.349812221733245},{"$f":"IF(C45=\"\",\"\",259/(259.12955-L45)*1000)","v":1040.0704894340381},{"$f":"IF(C45=\"\",\"\",J31/(Gewenste_liters-$C$45)*Gewenste_liters)","v":10.107966721604349}]
["Resultaten na Koelen ",null,"vul meting inâ ",null,"â de omgerekende stamwort âæ",null,null,0,null,{"$f":"IF(Stamplato=\"\",\"\",IF(Eindcijfer=\"\",\"\",0.1808*Stamplato+0.8192*Eindplato))","v":1.6156529513582818},null,{"$f":"IF(Stamwort=\"\",\"\",1+(Stamplato/(258.6-0.87955*Stamplato)))","v":1.0625856513944287},null,null,null,"bij verliezen",null,null,43,76,40,40,243]
["Kies een meetinstrument >","S.G.",{"$f":"54+K10","v":1062.3971883900331},{"$f":"IF(Stamwort=\"\",\"SG\",IF(meter=\"S.G.\",Stamwort,IF(meter=\"°Plato\",259/(259.12955-Stamwort)*1000,IF(meter=\"Brix\",259/(259.12955-Stamplato)*1000))))","v":1062.3971883900331},{"$f":"IF(Stamwort=\"\",\"°Plato\",IF(meter=\"°Plato\",Stamwort,IF(meter=\"S.G.\",(259*Stamwort/1000-259)/(Stamwort/1000-0.0089),IF(meter=\"Brix\",Stamwort/Brixratio))))","v":15.340213501391336},null,{"$f":"IF(Stamwort=\"\",\"Brix\",IF(meter=\"Brix\",Stamwort,IF(meter=\"°Plato\",Stamwort*Brixratio,IF(meter=\"S.G.\",Stamplato*Brixratio))))","v":15.799286155502399},null,"Overschrijf: Bekomen liters>",null,null,9.3000000000000007,null,"verlieswater >",{"$f":"verkookwater+hopverlies","v":2.7725505436676006},"< som water verdamping",null,null,44,66,37,36,243]
[null,null,"NA DE HOOFDGISTING: noteer SG of °P hevelen >","1,6°P",null,null,"noteer de lagertemp >",15,"Heveldatum >",null,"niet geheveld na hoofdgisting",null,null,null,null," en in hop bij 20°C",null,null,45,63,35,32,244]
[null,"De resultaten vóór bottelen meet ik met > ","REFRAC",null,null,null,"De aflezing van dit toestel  is in >","S.G.",null,null,"Het getal dat ik aflees > ",1020]
["Noteer: Het uitgegist bier moet helder zijn voor een Refractometer-meting!",null,null,null,{"$f":"IF(Eindcijfer=\"\",\"- -\",81.92*(Stamplato-Eindplato)/(206.65-1.0665*Stamplato))","v":7.212457252848778},{"$f":"IF(ISNUMBER(alconalager),12-(alconalager*100/1.97),\"\")","v":7.413788788641785},{"$f":"IF(Eindcijfer=\"\",\"°Plato\",IF(meternadien=\"°Plato\",Eindcijfer,IF(meternadien=\"S.G.\",(259*Eindcijfer/1000-259)/(Eindcijfer/1000-0.0089),Eindcijfer/1.03)))","v":5.1231332212441956},{"$f":"IF(Eindcijfer=\"\",\"Brix\",IF(meternadien=\"Brix\",Eindcijfer,IF(meternadien=\"°Plato\",Eindcijfer*Brixratio,IF(meternadien=\"S.G.\",VLeindplato*Brixratio))))","v":5.2764485818829385},null,null,{"$f":"IF(Eindcijfer=\"\",\"SG\",IF(meternadien=\"S.G.\",Eindcijfer,IF(meternadien=\"°Plato\",259/(259.12955-Eindcijfer)*1000,IF(meternadien=\"Brix\",259/(259.12955-Eindcijfer)*1000))))","v":1020}]
[{"$f":"IF(refofhyg=\"HYGRO\",\"°Plato en S.G. conversie > \",\"Met een hygrometer is dit >\")","v":"Met een hygrometer is dit >"},{"$f":"IF(EindSG=\"SG\",\"°Pt\",IF(refofhyg=\"REFRAC\",(259*EindSG/1000-259)/(EindSG/1000-0.0089),VLeindplato))","v":-1.4134004512857317},"OF",{"$f":"IF(Stamplato=\"°Plato\",\"SG\",IF(VLeindplato=\"°Plato\",\"SG\",IF(refofhyg=\"HYGRO\",VLeindSG,(1.001843-(0.002318474*Stamplato)-(0.000007775*Stamplato*Stamplato)-(0.000000034*Stamplato*Stamplato*Stamplato)+(0.00574*VLeindplato)+(0.00003344*VLeindplato*VLeindplato)+(0.000000086*VLeindplato*VLeindplato*VLeindplato))*1000)))","v":994.62077917326167},null,null,null,null,null,"Bekomen echt brouwzaalrendement >",{"$f":"IF(Totaalkg=0,\"\",IF(Bekomenliter=\"\",\"\",IF(Stamwort=\"\",\"\",StamSG/1000*Bekomenliter*Stamplato/(Totaalkg)/100)))","v":0.57180263008016763}]
["Schijnbare Vergistings Graad >",{"$f":"IF(Stamwort=\"\",\"\",IF(Eindcijfer=\"\",\"\",((StamSG-EindSG)/(StamSG-1000))))","v":1.0862093463749334},"  Werkelijke Vergistings Graad >",null,null,{"$f":"IF(Eindcijfer=\"\",\"\",IF(Stamplato=\"\",\"\",(Stamplato-Restextract)/Stamplato))","v":0.89467858767338904},{"$f":"IF(alcogewicht=\"\",\"\",IF(Eindcijfer=\"\",\"\",IF(Bekomenliter=\"\",\"\",EindSG/1000*alcogewicht/0.794/100)))","v":9.0348360863756833E-2},"vol.",{"$f":"IF(Eindcijfer=\"\",\"\",IF(nietvergist>6,\"!!!! >\",IF(nietvergist>5,\"zie na: >>\",\"\")))","v":""},null,{"$f":"IF(nietvergist=\"\",\"\",\"Ev. niet vergist suiker>\")","v":"Ev. niet vergist suiker>"},{"$f":"IF(Stamwort=\"\",\"\",IF(Eindcijfer=\"\",\"\",IF(((Eindplato-voorsp_eindplato)*8.1-2)<0,0,(Eindplato-voorsp_eindplato)*8.1-2)))","v":0}]
["Bottelen:",{"$f":"IF($G$54=\"J\",$K$54,IF(alconalager=\"\",\"\",IF(kleur>50,botsuikervlgskleur,botsuikervlgsalco)))","v":9.4},null,"Temperatuur hergisting >",20,null,"duurtijd >",null,null,"gist hergisting >"]
["Kies suikersoort > >","Kristalsuiker",null,null,null,"Zelf bottelsuiker opgeven? >","J",null,null,"zo ja, geef aantal g/liter>",9.4]
["finaal g suiker/L Bottelen >",{"$f":"IF(Eindcijfer=\"\",\"\",IF(suikersoort=\"Kristalsuiker\",adviessuiker,IF(suikersoort=\"Dextrose\",adviessuiker/0.93,adviessuiker/0.975)))","v":9.4},"Suikergift >",{"$f":"IF(Eindcijfer=\"\",\"\",IF(adviessuiker=\"\",\"\",suikergift*Bekomenliter))","v":87.420000000000016},null,{"$f":"IF(Eindcijfer=\"\",\"\",IF(adviessuiker-nietvergist<0,\"GEEN\",suikergift-nietvergist))","v":9.4},null,"Dan is suikergift >",{"$f":"IF(Eindcijfer=\"\",\"\",IF(adviessuiker-nietvergist<0,\"\",(suikergift-nietvergist)*Bekomenliter))","v":87.420000000000016},{"$f":"IF(Eindcijfer=\"\",\"\",IF(suikergift=corsuiker,\"Suikergift blijft dezelfde: \",\"Indien restsuiker verder kan uitgisten:\"))","v":"Suikergift blijft dezelfde: "}]
["Gebotteld Vol.% >>",{"$f":"IF(ISNUMBER(alconalager),alconalager+(adviessuiker/16.5/100),\"\")","v":9.6045330560726533E-2},null,"Minstens houdbaar tot ± >",{"$f":"IF($B$56=\"\",\"\",IF(Botdatum=\"\",\"\",IF($B$56*100<5,((($B$56*100)-5)*30)+215+Botdatum,((($B$56*100)-5)*130)+215+Botdatum)))","v":"2017-12-03T14:08:35.286"},null,"TIP: Vergelijk uw finaal S.G. met labgisting > restsuikercontrole."]
["Brouwplanner: R. Baert, Reynaert Wijn & Biergilde.",null,null,"versie: 7.testD",null,null,null,null,null,"Tekstbestand voor Forum: Herman H."]
["In bottelvat >>",{"$f":"Bekomenliter","v":9.3000000000000007},null,"Bakken van 33cl >>",{"$f":"ROUNDDOWN(B58/0.33/24,0)","v":1},null,{"$f":"((B58/0.33/24)-E58)*24","v":4.1818181818181834}]
["Nota's: "]
["Schenken: forse sis, bier blijft in fles"]
["Uitzicht: licht geel, troebel, gistvlokjes op bodem glas, mooie fijne shuimkraag, mooi stabiel"]
["Geur: kruidig, peper"]
["Smaak: volle body, behoorlijk restzoet, zeker niet droog genoeg voor een Saison. Wel clean en zonder smaakafwijkingen."]
["Nochtans gistingstemp laten oplopen tot 26°C na een paar dagen... Misschien niet voldoende nageggist? Diacetyl? Volgende keer 2wk laten nagisten."]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Voor overzichtelijkheid: Best kolommen N tot en met Y verbergen!"]
[]
["Overzicht Wijzigingen",null,"Noteer: een testversie heeft een \"test + nr\" achter de versienummer"]
[]
["Versie 6.test.6:"," - Er wordt ondersteld dat giststarter ALTIJD afgegoten wordt, zoals het hoort, formules daartoe aangepast."]
[null," - De voorspelling voor de eindvergisting wordt per grondstofregel berekend"]
[null," - Allerlei kleine verbeteringen om nauwkeuriger te voorspellen."]
[null," - Betere voorspelling te bekomen Stamwort in fie van beslagdikte"]
[null," - Betere voorspelling eindvergisting in functie van beslagdikte en Maischprofiel"]
[null," - Ook nieuw: kleurbalk die ongeveer een idee geeft van de voorspelde kleur."]
["Versie 6.test 10k:"," - Kleurvoorspelling volledig herzien + er zat opnieuw een fout factor 10 in suikerkleuren (nov 2013)"]
[null," - Nog nieuwe gisten toegevoegd."]
[null," - Bitterheid gecorrigeerd volgens data bekomen uit een brouwerij met "]
[null,"   zeer betrouwbare hopgegevens en metingen lijst okt 2013."]
["Versie 7:"," - Nodige Densiteit vóór het koken toegevoegd in cellen J/K/L 31"]
[null," - er is een versie voor oudere Office software (Office 2000/2003) en voor recente (2007 tot 2013)"]
[null," - Giststarter of Korrelgist in de cellen J/K/L 17 tot 20 wordt getoond volgens gistkeuze"]
[null," - Tekstbestand maken wordt door Forumlid Herman H gemaakt!"]
[null," - Hopberekeningsformules gecorrigeerd voor FWH, PELL enz…"]
[null," - Veel nieuwe korrelgisten toegevoegd, o.a. Mangrove Jacks en Gozdawa (vanaf 7testb)"]
[null," - Fout in cel K40 hersteld,"]
[null," - Vanaf test7d: Rij inevoegd voor High Gravity Brewing"]

{"sheet":"Info-Tabellen","index":1,"n_rows":151,"n_cols":33,"rows_kept":151,"cut":false,"hidden":false,"merged":[]}
["Info: Eigenschappen van gekende bieren.",null,null,null,null,null,null,"Mouten en granen.",null,null,null,null,"Suikers & extracten",null,null,null,null,"Hop",null,null,null,null,null,"Gisten gegevens",null,null,null,null,null,null,"Brouwzouten, Kruiden, Specerijen en extra additieven"]
["Naam","Stam-wort (°Pt)","Stam-wort (SG)","Alc. Vol %","EBC kleur","IBU (EBU)",null,"Naam                                           De kolom \"vergistbaarheid\" is t.o.v.  Pilsmout = 100","% Op-brengst","± Kleur EBC","Vergist ings correc- tie",null,"Naam                                      De kolom \"vergistbaarheid\" is t.o.v. kristalsuiker = 100","% Op-brengst","± Kleur EBC","Vergist-baar-heid(*)",null,"Benaming","Gem. Alfa zuur %","Eigenschappen","Vervangers","Biertype",null,"Naam","SVG op Mout","SVG op Suiker","Advies °C vergis ting","Eigenschappen: de hier vermelde vergistngspercentages zijn benaderingen en niet aan de praktijk getoetst.",null,null,"Naam","unit","advies"]
["Affligem blond",16,{"$f":"IF(ISNUMBER(B3),(1+(B3/(258.6-0.87955*B3)))*1000,\"\")","v":1065.432393615107},6.8,14,24,null,"  - - Kies mout of graan - -",null,null,null,null," - - Kies suiker of extract - -",null,null,null,null," - - Kies hop - -",null,null,null,null,null,"1) KORRELGISTEN",null,null,null,null,null,null," - - Kies additief - -","-","-"]
["Affligem Tripel",18.399999999999999,{"$f":"IF(ISNUMBER(B4),(1+(B4/(258.6-0.87955*B4)))*1000,\"\")","v":1075.902493017383},8.3000000000000007,13,31,null,"Pilsmout 3",80.069999999999993,3,100,null,"Basterdsuiker",99.5,0.1,100,null,"Admiral (B)",14,"Typisch Engels aroma, universele hop. Goede vervanger voor zowel hoge alpha hop als universele hop bij het koken.","Target, Northdown, Challenger","Engelse Ale",null,"Brewferm Blanche korrel",75,107.5,20,"Witbier, banaan/kruidnagelAromas, Hoger eindSG","k",null,"Anijszaad","g ","soms bij Wittekes, Max 1g per 25 liter geplet, einde koken"]
["Grimbergen dubbel",14.5,1058.9798859267992,6.4,18,31,null,"Tarwemout",83.5,2.7,100,null,"Bruine (basterd)suiker",99.55,30,99.5,null,"Amarillo (U)",10,"Citrus, bloemig.","Cascade, Centennial","American ale, IPA.",null,"Brewferm Lager korrel",72,107,20,"Cleane smaak, niet zwavelig, medium eindSG","k",null,"Ascorbinezuur","g ","(Ascorvit,Vit.C) voorkomt oxidatie, dosis 1g/ 30 liter beslag"]
["Leffe Blond",15.6,1063.7049266205001,6.6,15,25,null,"Brewferm Whisky mout",75,4,100,null,"Bruine kandijsuiker",99.55,10.005021607606587,100,null,"Bramling Cross (A)",6.4,"Mild, fruitig aroma met iets van citrus/limoen. Heel licht zurig.","(East) Kent Golding, WGV, evt Fuggles","Engelse Ale, Scotch",null,"Brewferm Top",68,107,20,"Geeftt fruitige esters.Hoger eindSG","k",null,"Biersol","ml","Kiezelsol om trub beter neer te slaan 3ml/10liter direct na koken"]
["Maredsous 8",16.899999999999999,1069.3374281529364,8.1,65,29,null,"Palemout 7 ",80.069999999999993,8,100,null,"Candico donkere stroop",68,100,93,null,"Brewers Gold (A)",6,"Fruitig, zwarte bes, pittig. Universele bitterhop. Heeft een wat hardere bitterheid.","Northdown, Northern brewer","Lambiek, Duitse pils",null,"Danstar Abbaye",77,107.5,21,"Nogal phenolisch, minder geslaagd.","k",null,"Calciumchloride","g ","CaCl2 Geeft zachte en volmondigere smaak Max.0,2g/lit. Verlaagt pH."]
["Sint-Bernardus 12",21.5,1089.6993164181979,10,78,22,null,"Munich mout 15",80.069999999999993,15,100,null,"Dextrosepoeder (Glucose)",92.3,0.1,100,null,"Cascade PELL Brouwland (A)",7,"Medium sterk aroma. Amerika´s meest populaire aromahop. Heeft een kenmerkend citrus- tot grapefruitkarakter.","Centennial, Amarillo","IPA, Am.Ale, witbier",null,"Danstar Belle Saison",91,107.5,"22...30","Belgische Saisongist","k",null,"Calciumsulfaat","g ","CaSO4 Verlaagt pH, verhoogt hopbitter, dosis zie verpakking"]
["St-Feuillin Tripel",18,1074.1448320434192,8.5,14,28,null,"Tarwemout donker",80,31.005141973052183,99.5,null,"Glucosestroop 28 D.E.",69,1,23,null,"Cascade BLM (A)",7.5,"Medium sterk aroma. Amerika´s meest populaire aromahop. Heeft een kenmerkend citrus- tot grapefruitkarakter.","Centennial, Amarillo","IPA, Am.Ale, witbier",null,"Danstar BRY-97 IPA ",82,107.5,"17...20","Voor o.a. IPA's, licht esterachtig, vrijwel neutraal en geeft geen onaangename geuren.","k",null,"Carafa of \"Réglise\"","g ","(Zoethoutdrop) Schuimverbeteraar, 1,5g / 10L tijdens koken"]
["Tripel Karmeliet",19.5,1080.7624722883766,8,12,20,null,"Aromamout (Amber 50)",80.069999999999993,49.057338814674104,99.5,null,"Glucosestroop 50 D.E.",69,1,70,null,"Centennial (U)",9.5,"Medium intens met bloemige en citrusachtige trekjes","Cascade","Am. Ale, Am. Witbier",null,"Danstar CBC-1 BottleYeast",75,107.5,"13…20","Speciale Bottelgist, flinke sedimentatie.","k",null,"Cardemom","pit","bij Wittekes, Binnenste van 1 gepelde pit per 20 liter einde koken"]
["Chimay Rood",14.9,1060.6937734156018,7.1,30,20,null,"Biscuit mout 50",70,58,99.5,null,"Glucosestroop 55 D.E.",69,1,87,null,"Challenger (U)",6,"Mild tot matig intens, behoorlijk pittig. Een alternatief voor East Kent Golding, maar iets bitterder.","(Hallertauer) Perle, Northern Brewer","Eng.ale, stout, bitters.",null,"Danstar Diamond Lager",78,107.5,11,"Lagerbier Weihenstephan stam","k",null,"Curaçaoschil/bitter","g ","geeft sterk  sinaas aroma + bitter tot 1g / 10 liter"]
["Chimay Wit",16.899999999999999,1069.3374281529364,8.1999999999999993,17,35,null,"CaraPils 5",77,5,98,null,"Glucosestroop 63 D.E.",69,1,76,null,"Citra (U)",13,"Zeer fruitig, perzik, abrikoos, passievrucht, grapefruit, limoen, meloen, kruisbes, lychee, ananas, mango, papaya en andere tropische vruchten smaken en aroma's","Simcoe, en andere fruitige citrus „C” hop","Licht & amber gekleurde bieren. American pal ale, IPA, double IPA",null,"Danstar Munich Weizen",78,107.5,20,"Zwavelig: Weizen en Chimay achtig","k",null,"Fosforzuur 85%","ml","Voor aanzuren beslag, spoelwater en gekookt wort."]
["Chimay Blauw",18.7,1077.224090455592,9,80,35,null,"CaraPils (Cara 20)",76,22,97,null,"Glucosestroop 95 D.E.",69,1,97,null,"EastKent Golding (A)",5,"De fijnste aromahop met engels karakter","First Gold, ev. Fuggles.","Eng. En Belg. Ale",null,"Danstar Nottingham Ale",77,107.5,20,"Zuivere Gist, medium eindSG, heeft Rochefort trekjes.","k",null,"Gagel, gedroogd","g ","Natuurlijk bittermiddel dosis=? Gebruik best samen met hop."]
["Orval",13.6,1055.1415166479537,6.2,25,33,null,"CaraBelge 35 (Brouwland)",76,35,95,null,"Honing dik",81,2,90,null,"First Gold (U)",7.5,"Uitgebalanceerde bitterheid, fruitig, iets pikant. Een beetje als Kent Golding (zacht, aangenaam, geurig) maar wat pittiger.","(East) Kent Gold, ev Fuggles.","Eng. En Belg. Ale",null,"Danstar Windsor Ale",68,107,20,"Zuivere Neutrale gist, hoger eind SG goede bottelgist","k",null,"gedroogde citroenschil","g ","geeft citrusaroma tot 1g / 10 liter"]
["Rochefort 6",7.5,1029.7615061703043,7.8,40,18,null,"CaraVienne (Cara 50)",76,66,95,null,"Honing vloeibaar",79,1.5,90,null,"Fuggles (A)",3,"Mild en aangenaam, gronderig, fruitig. Typisch Engelse hopsmaak. Geeft bier een rond en vol karakter.","Styrian Golding, Tettnanger, Willamette","Alle bieren.",null,"Danstar Reserve",null,null,null,null,"k",null,"gedroogde sinaasschil","g ","geeft aangenaam aroma Ongeveer 2g / 10 liter"]
["Rochefort 8",19,1078.5485712324953,9.1999999999999993,63,22,null,"CaraMunich (Cara 120)",75,120,88,null,"Kandijstroop wit",69,0.1,100,null,"Hallertau Hersbrücker (A)",3,"Duitslands meest gebruikte aromahop met een fantastisch en kruidig aroma.","Hallertau Mittelfrüh, Strisselspalt","Bock, Lager, Ale,  Lambiek",null,"Fermentis Safbr Abbaye",80,107.5,21,"Krachtig, gisting kan zwavelig ruiken.","k",null,"Gemberwortel","g ","Max 2g /10 liter"]
["Rochefort 10",23,1096.488510420864,11.3,90,27,null,"Aromamout (Amber 150)",79,150,99.2,null,"Kandijsuiker brokken wit",99.7,0.1,100,null,"Hallertau Spalt Select (A)",6,"Duitse aromahop met licht kruidig karakter. Goed alternatief voor de Franse Spalt","Saaz, Tettnanger, Spalt, Hersbrücker","Duitse lagers, Pils",null,"FermentisSafbrew F2",75,107.5,20,"Speciale Bottelgist, flinke sedimentatie.","k",null,"Hoparoma","ml","Diverse aroma's Max 1ml/10liter vóór bottelen."]
["Westmalle Dubbel",15.6,1063.7049266205001,7.3,74,25,null,"Special B (Cara 400)",76,390,73,null,"Kristalsuiker",100,4.5001013284581759E-3,100,null,"Hallertauer Mittelfrüh (A)",4.5,"Mild en aangenaam. Zacht aroma, gemiddelde bitterheid.","Hallertauer Tradition","Pils, Lager, Witbier, Trappist.",null,"Fermentis S-04",77,107.5,20,"Neutraal, gemiddeld, zeer goede sedimentatie.","k",null,"Iers mos","g ","(Carageen) Bevordert neerslaan trub, 1g op 5 liter, Min. 20' koken."]
["Westmalle Tripel",19.600000000000001,1081.2062206285179,9.6,15,39,null,"Chocolademout (Mout roost 900)",75,900,90,null,"Luikse Appelstroop",90,30,55,null,"Hallertauer Perle (U)",5,"Matig intens goed en hoppig aroma, fruitig, beetje pittig. Goede combinatie van uitgebalanceerde bitterheid en goede aroma eigenschappen.","Northern Brewer, Perle ","Alle bieren.",null,"Fermentis S-33",70,107,21,"Zeer esterig, Zoet.","k",null,"Jeneverbes (Juniperus)","g ","1 g / 10 liter einde koken, voor X-Mass & Scottch like Ales"]
["Westvleteren Blond",12.6,1050.9054565680099,5.6,9,41,null,"Black 1400",64.8,1400,70,null,"Luikse perensiroop",90,30,55,2,"Hallertauer Tradition (A)",5.5,"Zacht aroma, gemiddelde bitterheid. Bekend om zijn aromatische eigenschappen. Lijkt veel op Hallertauer Mittelfrüh.","Hallertauer Mittelfrüh, Hersbrücker","Lager, weizen, trappist, wit.",null,"Fermentis Saflager S-23",72,107.5,11,"Lagerbier, tamelijk fruitig.","k",null,"Kaneelstokje","stuk","Wodt soms in X-Mass ales gedaan 1 medium stok / 30 liter"]
["Westvleteren 8",17.600000000000001,1072.3922581086733,8.3000000000000007,72,35,null,"Boekweitvlokken",73.58,4,100,null,"Maltodextrine 18 D.E.",100,1,14,null,"Hallert.Hersbrücker (A)",3.5,"Mild tot redelijk sterk aroma, aangenaam hoppig en kruidig.","Halllertau Mittelfrüh, Strissenspalt","Zie Hallertau mittelfrüh",null,"Fermentis T-58",70,107.5,20,"Fruitig, kruidig, goede hergister","k",null,"Karwijzaad, gemalen","g ","1 g / 10 liter einde koken, geeft Achouffe aroma's"]
["Westvleteren 12",21.5,1089.6993164181979,10.199999999999999,79,38,null,"Maisvlokken",74.58,1,100,null,"Maltodextrine 8 D.E. (Brewbody)",100,1,4.5,null,"Lublin (Polen) (A)",3.7,"Mild intens aroma, pikant, kruidig.Typische \"edele\" aromahop","Saaz, Tettnanger ev Fuggles","Belgische ales, bitter",null,"Fermentis US-05",80,107.5,20,"Universeel, krachtig, bier verbleekt.","k",null,"Komijnzaad, gemalen","g ","1 g / 10 liter einde koken, geeft Achouffe aroma's"]
["Achouffe",19.2,1079.4331649350238,8.9,25,30,null,"Rijstvlokken",82.8,0.2,100,null,"Moutextract poeder Amber",99.5,18,70,null,"Magnum (Hallertau M.) (B)",13.4,"Aangenaam maar niet uitgesproken aroma voor bieren met een \"clean\" karakter","Columbus, Nugget","Lagerbieren, stout, ales",null,"Fermentis W34-70",77,107.5,11,"Lagerbier, zuvere cultuur","k",null,"Koriander","g ","licht gemalen of gebroken zaden tot Max 15 g / hectoliter"]
["Adelscott au Whisky malt",15.8,1064.5680392047325,6.8,18,18,null,"Havervlokken / havermout",73.58,3.7,100,null,"Moutextract poeder Black",99.5,95,60,null,"Merkur (B)",10.7,"Nieuwe bitterhop, fijner aroma dan Magnum","Magnum","Alle bieren.",null,"Fermentis WB-06",78,107.5,20,"Voor Weizen & Chimay","k",null,"Kruidnagel","stuk","1 per 30 liter einde koken, voor X-Mass & Scottch like Ales"]
["Bass Pale-Ale",10.7,1042.9393269517334,4.5,19,30,null,"Gerstvlokken",74,4,100,null,"Moutextract poeder Donker",99.5,57,65,null,"Millennium (B)",15,"Pikant en kruidig","Nugget, Columbus","Ales, stout, barley wine",null,"Mauribrew Ale",66,107,"?","Australische Ale. Data nog onbekend","k",null,"Magnesiumsulfaat","g ","MgSO4 maakt uw bier harder (zie Burton-onTrent) 1g/10 liter"]
["Bittburger Pils",11.4,1045.8617550497111,4.8,4,38,null,"Roggevlokken",73.58,4,100,null,"Moutextract poeder licht",99.5,8,75,null,"Northern Brewer (B)",9,"Universele hop, gebruikt als bitterhop. Wordt in donkere bieren gebruikt, De hopbellen zijn van nature wat bruiner.","Brewer's Gold.","ESB, bitter, Engelse pale ale..",null,"Mauribrew Lager",66,107,11,"Australische Lager.  Data nog onbekend","k",null,"Melkzuur (Lactol)","ml","Meestal van 80% Voor aanzuren beslag, spoelwater en gekookt wort."]
["Cantillon Geueze",12.8,1051.7502584278532,5.4,9,15,null,"Tarwevlokken",73.58,4,100,null,"Moutextract poeder Tarwe",99.5,79,75,null,"Nugget (Duitsland) (B)",13.6,"Matig sterk, kruidig aroma Als Nugget (USA), maar met iets lagere alpha waarden","Nugget USA, ev. Magnum","ales, stout, barley wine",null,"Mauribrew Weiss",80,107.5,"?","Australische Weizen. Data nog onbekend","k",null,"Steranijs","pit","bij Wittekes, Max 1gemalen pit per 25 liter einde koken"]
["Courage BulldogStrongAle",16.5,1067.5987302500323,7.7,76,26,null,"Bruine rijst",85,0.3,100,null,"Rietsuiker (bijv. Candico)",97.38,6,100,null,"Perle (Duitsland) (A)",6.4,"Matig intens, hoppig aroma, fruitig, pittig. Goede combinatie v. uitgebalanceerde bitterheid & aroma eigenschappen.","Hall. Perle","pale ale, porter, stout, wit",null,"Mauribrew Reserve",null,null,null,null,"k",null,"Vanille lint","cm","stukje van 6 cm / 100 liter geeft houten vat toets"]
["De Koninck Ale",12,1048.378240435017,5,22,24,null,"Geroosterde gerst",64.92,1000,70,null,"Rijstsiroop LIMA of Horizon",77,2,76,null,"Phoenix (B)",10,"Mild tot matig intens, pikant aroma.","(East) Kent Golding, Challenger","ales, stout, porter, ESB, bitter",null,"Muntons premium Gold",73,107.5,19,"Een goed gebalanceerde ale-gist voor 100 % moutrecepten. Zuivere smaak, matige alc. tolerantie","k",null,"Wyeast Nutrient blend","g ","Gistvoeding, 1 g /10 liter gekoeld wort"]
["De Koninck Blond",14,1056.8444123769775,6,10,28,null,"Weyermann Speltmout",80.5,3,100,null,"Gerstemoutsiroop Horizon",77,4,74,null,"Pioneer (U)",9,"Zacht, typisch Engels aroma.","(East) Kent Golding","Engelse ales, ESB, bitter.",null,"Reserve",null,null,null,null,"k",null,"Zinksulfaat","g ","Sporenelement IN GISTSTARTER TE DOEN!, 0,5 g / hectoliter wort"]
["Caledonian Edingburgh strong ale",18.7,1077.224090455592,8.1,35,60,null,"Weyermann Tarwemout licht",84.4,4,100,null,"Stroop (NL)",73.58,30,100,null,"Premiant (U)",7,"Nieuwe bittere Saaz variant","Saaz","Lagers & ales",null,"Reserve",null,null,null,null,"k"]
["Duvel",17,1069.7728872000203,8.5,11,32,null,"Weyermann CaraPils",77,4.0068474916421861,98,null,null,null,null,null,null,"Record (U)",7,"Belgische hop, fruitig","mengsel North Brw met Brewers Gold","Belgische Ales",null,"Gozdawa Bavarian Wheat",70,107.5,23,"Specifieke Duitse giststam voor Weizen bier - banaansmaak: >24°gisten, flauwe floculatie.","k"]
["Einbecker Hell",16.3,1066.731259523661,7.5,15,38,null,"Weyermann Rauchmalz",80.069999999999993,5,99.7,null,null,null,null,null,null,"Saaz CZ  (A)",2.8,"Koning van de pilshop. De enige hop die gebruikt wordt in het oorspronkelijke pils ter wereld: Pilsner Urquell. ","Lublin, ev. Spalt","Pils, Belgische ales,  Lambiek",null,"Gozdawa Belgian Fruit & spicy ale",80,107.5,23,"beroemde Belgische,bovengist stam voor Belgische bieren en abdijbieren. Medium floculatie","k"]
["Erdinger Hefe Weissbier",12.6,1050.9054565680099,5.3,9,18,null,"Weyermann Roggemout",85,6,100,null,null,null,null,null,null,"Simcou (U)",13,"bitterhop+aroma: Passievrucht, abrikoos + intens houtaroma. Fris en complex","Amarillo, Cascade, Centennial (mengsel)","Bittere fruitige bieren",null,"Gozdawa Czech Pilsener 18",81,107.5,13,"Ondergistende giststam met een hoge vergistingsgraad en een puur smaakprofiel","k"]
["Grölsch Lager",11.9,1047.9580828623382,5,3,27,null,"Weyermann Sauermalz pH 3,5",69.25,6,100,null,null,null,null,null,null,"Spalt  (A)",5,"Mild en aangenaam, ietsje pittig. Vergelijkbaar met Tettnanger, \"edele\" aromahop","Saaz, Tettnanger, Strisselspalt.","Ales en Lagers",null,"Gozdawa Fruit Blanche",73,107.5,23,"Bovengist stam voor Witbier met fruitige esters","k"]
["Guinnes draft (vat)",11.9,1047.9580828623382,4.5999999999999996,200,45,null,"Weyermann Viennamout",80.069999999999993,7,100,null,null,null,null,null,null,"Spalt Select (A)",4.5,"Nog intenser dan Spalt","Spalt","Ales en lagers",null,"Gozdawa German Lager W35",72,107,14,"Voor lager bier, zeer hoge flocullatie, eerder lage alcoholtolerantie","k"]
["Guinnes extra stout",17.600000000000001,1072.3922581086733,7.2,200,65,null,"Weyermann Tarwemout donker",84.4,20,99.9,null,null,null,null,null,null,"Strisselspalt (A)",1.5,"Medium intens, zeer aangenaam, fijn en hoppig. Frankrijk.","Hersbrücker, ev. Hallertau Mittelfrûh","Pils, Lager, Witbier.",null,"Gozdawa Old German (Alt)",75,107.5,17.5,"Duitse bovengist voor bieren met weinig esters.Uitstekend geschikt voor Alt en Vlaams bruin.","k"]
["Heller Kölsch",11.9,1047.9580828623382,5,5,28,null,"Weyermann CaraHell",70,25,96,null,null,null,null,null,null,"Styrian Golding (A)",3.5,"Delicaat, iets pikant en grasachtig/bloemig. Zeer populair vanwege karakteristieke aroma en gemiddelde alpha waarden","Fuggles","Ales, Pils, lager.",null,"Gozdawa Porter & Kvas",82,107.5,24,"Universele stam van hoge gisting, voor donker bier en Poolse Kvas, Alc.tolerantie tot 9vol%","k"]
["Hoegaarden Wit",11.9,1047.9580828623382,5,8,18,null,"Weyermann CaraRed",70,40,95,null,null,null,null,null,null,"Target (U)",9.5,"Zeer goede Engelse bitterhop met aangenaam aroma. Redelijk intens aroma, zeer hoge bitterwaarden.","Fuggle met Northern Brewer","Alle bieren.",null,"Gozdawa Pure Ale",82,107.5,"16…32","beste universele giststam voor thuis brouwen! 16 -32 °C smaakprofiel is afhankelijk van de vergistingsT°.","k"]
["Jupiler",12.3,1049.6405028728232,5.2,3,21,null,"Weyermann CaraAmber",70,60,94,null,null,null,null,null,null,"Tettnanger (A)",5,"Zeer nobele Duitse aromahop, veel gebruikt bij lagerbieren. Heeft een mild, kruidig aroma en een fijne, delicate smaak.","Spalt, Spalt Select, Hersbrücker","Pils, Weizen, Wit, Trappist.",null,"Gozdawa US West Coast",80,107.5,18,"Bovengist voor Amerikaanse bieren met laag estergehalte","k"]
["Liefmans Goudenband",12.8,1051.7502584278532,5.3,60,20,null,"Weyermann Melanoidin mout",80.069999999999993,70,99.5,null,null,null,null,null,null,"Tradition (Duits) (A)",5.5,"Zacht aroma, gemiddelde bitterheid. Zeer subtiel, lijkt veel op Mittelfrüh.","Hersbrücker, Hallertauer Mittelfrüh","Pils, weizen, wit.",null,"Gozdawa reserve",null,null,null,null,"k"]
["Liefmans Kriek",12.8,1051.7502584278532,5.3,60,20,null,"Weyermann Chocolate Ontbitterd",65,800,70,null,null,null,null,null,null,"WGV (WhitbreadGoldingVar./U)",6.5,"Aangenaam en hoppig aroma met een gemiddelde intensiteit.","(East) Kent Golding","Engelse ales.",null,"Mangrove Bavarian Wheat M20",72,107.5,"18...30","Duitse tarwe/weizen/witbieren, flauwe floculatie, lage alc. Tolerantie, als bottelgist: flauw.","k"]
["Löwenbräu special export",12.8,1051.7502584278532,5.4,11,24,null,"WeyermannTarwemout Roost 900",65,900,70,null,null,null,null,null,null,"Willamette (A)",5,"Mild en aangenaam, iets pikant, fruitig, bloemig, iets gronderig.","Fuggle, Tettnanger, Styrian Golding.","Engelse ales, APA, brown ale.",null,"Mangrove Belgian Ale M27",85,107.5,"26…32","Belgische bieren inclus hoge alc.%.  Tot 14vol%! Flocculatie medium, matig bottelgeschikt.","k"]
["Lutèce - Bière de Paris",15.3,1062.4125803202487,6.6,50,23,null,"Weyermann Black ontbitterd",69.25,1200,65,null,null,null,null,null,null,"Yeoman (U)",10,"Bitterhop met aangenaam zacht aroma. Ook voor maken van bitterconcentraten/extracten.","Target, Admiral, Phoenix","Lagerbieren",null,"Mangrove Bohemian Lager M84",80,107.5,12.5,"Pils en Co, Flinke flocculatie, zeer bottelgeschikt. Lage alcohol tolerantie.","k"]
["Malheur 10",20,1082.9844528627561,10.1,11,33,null,"Whisky Malt",79,5,100,null,null,null,null,null,null,null,null,null,null,null,null,"Mangrove Britisch Ale M07",80,107.5,19,"Britse Ales, inclusief zwaardere bieren, als bottelgist zeer goed, alcohol tolerantie eerder hoog.","k"]
["Mousel premium pils",11.4,1045.8617550497111,4.8,3,28,null,null,null,null,null,null,null,null,null,null,null,"Hieronder tijdelijke grilletjes",null,"Om op BRWPlanner met 1 regel te kunnen werken bij gelijkmatig gebruik",null,null,null,"Mangrove Burton Union M79",78,107.5,20,"Britse, droge Ales, eerder hoge flocculatie, bottelen: goede plakgist, matig goede alc. Tolerantie.","k"]
["Newcastle Brown Ale",10.9,1043.772831773518,5,24,50,null,null,null,null,null,null,null,null,null,null,null,"CascaCitra",11.5,"Mengsel 50% Citra, 50% Cascade bellen ",null,"citra IPA recepten",null,"Mangrove UK Dark Ale M03",75,107.5,20,"Ook Newcastle dark Ale genoemd, volmondig bier. Alc. Tolerantie, flocculatie en als bottelgist matig, ","k"]
["Oerbier",15.8,1064.5680392047325,7.4,76,26,null,null,null,null,null,null,null,null,null,null,null,"AmarilCascaCitra",10,"Mengsel 1/3 Citra, 1/3 Cascade, 1/3 Amarillo bellen ",null,"citra IPA recepten",null,"Mangrove US West Coast M44",80,107.5,21,"American Ales, IPA's, Pale ales… hoge flocculatie, matig als bottelgist.","k"]
["Oktoberfest Märzen (Spat)",13.5,1054.7165515440556,5.7,32,22,null,null,null,null,null,null,null,null,null,null,null,"Sorachi Ace",12.4,null,null,null,null,"Mangrove Workhorse beer M10",85,107.5,"15…32","Alle soorten bieren inclusief fruibieren, flinke doorgister, flocculatie en als bottelgist matig.","k"]
["Paulaner Salvator Dobbelbock",17.399999999999999,1071.5178718846105,7.5,60,30,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mangrove reserve ",null,null,null,null,"k"]
["Pilsner Urquell",11.9,1047.9580828623382,5,6,40,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2) VLOEIBARE GISTEN"]
["Pinkus Hefe Weizen",12.3,1049.6405028728232,5.2,9,18,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Opkweek Brigand (FL)",82,107.5,20,"Hard, droog","v"]
["Rodenbach",11.9,1047.9580828623382,4.8,60,14,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Opkweek Duvel (FL.)",79,107.5,20,"Zeer geschikt vr hergisting (plakt)","v"]
["Rodenbach Grand Cru",15.8,1064.5680392047325,6.6,60,14,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Opkweek Hopus (FL)",82,107.5,21,"Fruitige gist","v"]
["Saint-Arnould réserve",15.1,1061.5525606181134,6.4,35,25,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Opkweek Orval (FL)",83,107.5,20,"Ver doorgistend (bevat Brettanomyces!)","v"]
["Saint-Silvestre 3m",19,1078.5485712324953,8.5,6,27,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Opkweek Rochefort10 (FL)",82,107.5,21,"Zacht en aangenaam","v"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Opkweek Westmalle(FL)",82,107.5,21,"Gekend, krachtig, gisting kan fruitig ruiken.","v"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Opkweek Hopus (FL)",82,107.5,21,"Fruitige gist","v"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Opkweek Chimay (FL)",82,107.5,21,"Weizenachtig, zwavelig","v"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Schuine Buis Gevallen Engel",82,107.5,23,"Voor Duvel hoofdgist","v"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Schuine Buis Hapkin ",82.5,107.5,23,"Hapkin like, iets volmondiger dan Duvel","v"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Schuine Buis Kabouter",82.5,107.5,24,"Voor Achouffe-like, kruidig","v"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1007 German Ale",75,107,16,"Droog en verfrissend, complex & zacht","v"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1010 American Wheat",76,107,19,"Droog, verfrissend en lichtzurig","v"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1028 London Ale",75,107,18,"Rijk, droge afdronk. Dorstlessend & fruitig","v"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1056 American Ale",75,107,18,"Droog met zachte afdronk, evenwichtig","v"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1084 Irish Ale (Guinness)",73,107,19,"Licht moutig, fruitig, beetje diacetyl.","v"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1098 Britisch Ale",74,107,20,"Droog, verfrissend, lichtzurig, fruitig, evenwichtig","v"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1099 Whitbread Ale         ",70,106.5,21,"Zachtmoutig, lichtfruitig vergistprofiel. Minder zurig en droog dan de 1098","v"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1187 Ringwood Ale",70,106.5,21,"Fruitesters, moutig, hoge uitvlokking, Diacetylrust nodig.","v"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1214 Belgian Abbey       ",80,107.5,21,"Esterig, fruitig, droog zurige afdronk / Chimay","v"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1272 All American Ale",74,107.5,19,"Fruitig, vlokt meer uit dan 1056, zurige afdronk","v"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1275 Thames valey Ale",74,107.5,19,"Voor Britse Bitters","v"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1318 London Ale III",73,107,21,"Tradirionele engelse ale, moutig en hoppig","v"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1335 Britisch Ale II",75,107.5,21,"Britse & Canadese ales, Moutig","v"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1338 European Ale",69,106.5,20,"Munchener ale, zeer moutig, dicht stevig schuim","v"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1388 Belgian Strong Ale    ",79,107.5,20,"Fruitig aroma en palet droog zurige afdronk / Duvel.","v"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1728 Scottish Ale",71,107,18,"Mc Ewans","v"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1762 Belgian Abbey II",81,107.5,22,"Gist voor hoogSG, verwarmend door de ethanol. Lichtfruitig & droog (Rochefort)","v"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1968 London ESB Ale",69,106.5,20,"Zeer moutig, evenwichtig fruitig, zeer hoge uitvlokking voor Cask conditioned ales","v"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2000 Budvar Lager",73,107,11,"Moutig, licht fruitige lager","v"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2001 Pilsner Urquell Lager",73,107,11," DE PILS! Mild fruit & bloemenaroma.","v"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2007 Pilsen Lager",73,107,11,"Zacht moutig palet. Droog/verfrissend (Budweiser)","v"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2035 American Lager",77,107.5,12,"Sterk, complex en aromatisch","v"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2042 Danish Lager (Carlsberg)",75,107.5,11,"Rijk, Dortmundstijl verfrissend droge afdronk.","v"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2112 Californian Lager",69,106.5,17,"Moutige en kristalhelder bier","v"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2124 Bohemian Lager",71,107,11,"Clean en moutig. / Weihenstephan 34/70","v"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2206 Bavarian Lager",75,107.5,11,"Gebruikt in veel Duitse brouwerijen, Weihenstephan 206.","v"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2278 Czech Pils            ",72,107.5,11,"Droog en moutige afdronk / Pilsner Urquel-D","v"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2308 Munich Lager          ",75,107.5,11,"Zeer aangenaam zacht goede stevigheid en vol van smaak","v"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3056 Bavarian Wheat Blend",75,107.5,21,"Voor zachte, esterige en fenolische Weizenbieren","v"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3068 Weihenstephan Weizen",76,107.5,22,"Unieke bovengist: kruidige WEIZEN, karakter maakt rijk met kruidnagel vanille en banaan.","v"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3333 German Wheat          ",74,107.5,22,"Subtiel smaakprofiel voor een tarwebiergist met scherpzurige frisheid fruitig kersachtig palet.","v"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3463 Forbidden Fruit Yeast",77,107.5,21,"Fenolisch profiel met een achtergrond van fruitigheid. / Verboden Vrucht","v"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3522 Belgian Ardennes",82.5,107.5,24,"Fenolen zorgen voor een zachtfruitigheid en een complexe kruidigheid / Achouffe","v"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3538 Leuven Pale Ale",80,107.5,23,"Licht fenolig en kruidig aromatisch karakter. / Corsendonck Bock","v"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3638 Bavarian Wheat",75,107.5,22,"Evenwicht tussen banaan en kauwgom - esters o.a. van litchee appel, pruim. Kruidnagel. / Weihenstephan 175","v"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3655 Schelde Ale",79,107.5,20,"Een fruitig aroma. / Bolleke De Koninck.","v"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3711 French Saison",82,107.5,"20..30","Zeer droog kruidig en licht zurig profiel met esterig aroma. Rijk mondgevoel","v"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3724 Belgian Saison",84,107.5,"21..29","Zeer droog kruidig en licht zurig profiel met esterig aroma. / Saison Dupont / trage vergisting!!","v"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3725 Biere de Garde        ",78,107.5,"z.spec","Laag à gemiddelde esterproductie, lichte kruidigheid.","v"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3763 Roeselare Blend",78,107.5,"20..30","Vlaams oud bruin à la Rodenbach, moet lang rijpen, tot 18 maand","v"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3787 Trappist High Gravity ",79,107.5,21,"Droog, rijk esterig en fenolig profiel / moutig palet. /  Westmalle","v"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3942 Belgian Witbier       ",74,107.5,20,"Esterig en fenolisch, appels & pruimen in de neus. Droog.","v"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3944 Belgian Witbier (Celis)     ",74,107.5,21,"Zurig en licht fenolisch karakter / Hoegaarden / Celis White","v"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5112 Brettan. Bruxellensis ",85,107.5,22,"Produceert klassieke lambic karakteristieken zoals zuur en zweterig paardehaar. / Lambiekcultuur","v"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Champagnegisten",45,107.5,18,"TE troebel als bottelgist, wel OK om zwaar bier na hoofdgisting dmv suiker op te krikken tot 14 vol%.","k"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"  Tip: pas jaarlijks de alfazuren van de hop aan, zodra je de nieuwe hopsoorten binnen hebt"]

{"sheet":"Origineel recept","index":2,"n_rows":89,"n_cols":31,"rows_kept":89,"cut":false,"hidden":false,"merged":[[0,0,0,1],[0,10,0,11],[1,0,1,1],[1,10,1,11],[1,26,2,27],[2,3,2,5],[2,6,2,11],[27,4,27,5],[29,6,29,11],[4,26,5,27],[7,9,7,11],[8,9,8,11],[10,26,11,27],[14,26,15,27],[16,9,16,11],[34,6,34,8],[34,26,34,27],[18,26,19,27],[18,34,18,35],[22,26,23,27],[26,26,27,27],[30,6,30,8],[30,26,31,27],[31,6,31,8],[33,6,33,8],[33,26,33,27],[41,6,41,8],[41,26,41,27],[35,6,35,8],[35,26,35,27],[36,6,36,8],[36,26,36,27],[37,6,37,8],[37,26,37,27],[38,6,38,8],[38,26,38,27],[39,6,39,8],[39,26,39,27],[40,6,40,8],[40,26,40,27],[42,3,42,4],[42,6,42,8],[42,26,42,27],[53,1,53,2],[55,4,55,5],[43,9,43,11],[71,1,71,11],[44,5,44,6],[46,4,46,5],[46,6,46,7],[47,10,47,11],[49,7,49,9],[52,10,52,11]]}
["Saison",null," < Naam Bier",null,null,"Beslagdikte in L/kg >  ",3.6,{"$f":"IF(mashfactor>4.5,0,(5-mashfactor)/2.2)","v":0.63636363636363624},null,"Brouwdatum >",null,null,null,null,null,null,null,null,"EBC","R","G","B","A",null,"EBC",null,"Info over de gekozen gist:     Naam >",{"$f":"HoofdGist","v":"Danstar Belle Saison"}]
["http://www.hobbybrouwen.nl/forum/index.php/topic,12765.msg164212.html#msg164212",null,"< Type bier",null,null,"\"Extract Efficiëntie\" >",0.77,null,null,"Botteldatum  >",null,null,null,null,null,null,null,null,0,255,255,255,0,null,{"$f":"$F$26","v":12.419491158027828},null,{"$f":"G3","v":"Belgische Saisongist"}]
["Gewenste liters bier >",21,"Gist >>","Danstar Belle Saison",null,null,{"$f":"VLOOKUP(HoofdGist,'Info-Tabellen'!$X:$AC,5,0)","v":"Belgische Saisongist"},null,null,null,null,null,null,null,null,null,null,null,1,247,249,180,45]
["Vast verlies installatie >",1,null,null,null," ketelinvloed (vaste parameter) > ",99.5,null,null,"Totale kooktijd >",70,{"$f":"IF(Aardbier=\"D\",-0.5,IF(Aardbier=\"M\",-0.3,IF(Aardbier=1,-0.8,2.5)))","v":-0.5},null,null,null,null,null,null,2,245,248,146,61,null,"R",null,"Info over de bottelgist:          Naam >",{"$f":"K53","v":"FermentisSafbrew F2"}]
["Kies een Maischprofiel >","D",null,"eiwitrust J/N ? >","N",null,"% verkoken/uur>",19,{"$f":"VLOOKUP(HoofdGist,'Info-Tabellen'!$X:$AB,2,0)","v":91},{"$f":"SUM($D$8:$D$18)","v":4.5184999999999995},{"$f":"IF(Eiwitrust=\"J\",10,0)","v":0},{"$f":"(totplato-VSPrestextract)/(2.0665-0.010665*(totplato))","v":4.8174477538147062},null,null,null,null,null,null,3,248,249,114,75,null,{"$f":"LOOKUP($Y$2,$S$2:$S$48,T2:T48)","v":212},null,{"$f":"VLOOKUP(bottelgist,'Info-Tabellen'!$X:$AB,5,0)","v":"Speciale Bottelgist, flinke sedimentatie."}]
["Geef opslagtemperatuur mout > ",14,null,null,null,"na beslagcorrectie op Extract Effic.>",{"$f":"IF(mashfactor<3.66,$G$2-((mashfactor)/1000)+0.00666,$G$2-((mashfactor)/20)+0.175)","v":0.77305999999999997},null,{"$f":"IF(moutkilos=0,\"\",IF(Aardbier=1,moutkilos*1.6*($B$30-mouttemp)/(mashwater*4.18),moutkilos*1.6*($B$29-mouttemp)/(mashwater*4.18)))","v":5.0035963348656853},null,"â te verwachten na koken â",null,null,null,{"$f":"VLOOKUP(HoofdGist,'Info-Tabellen'!$X:$AB,3,0)","v":107.5},"ter info",null,null,4,248,247,83,90,null,null,null,null,null,null,null,123456789]
["Grondstoffen","Opbrengst","EBC-kleur","kg â","°PLATO","EBC","%Gew.","%Stort","FG",{"$f":"SUM($E$8:$E$18)","v":12.525654232169988},{"$f":"(1+($J$7/(258.6-0.87955*$J$7)))*1000","v":1050.5917254220865},{"$f":"IF(ISNUMBER($J$7),$J$7*1.035,\"\")","v":12.964052130295936},null,"gist factor","SVG","LoviBond","EBC",null,5,245,248,48,121,null,"G"]
["Pilsmout 3",{"$f":"VLOOKUP(A8,'Info-Tabellen'!$H:$K,2,0)","v":80.069999999999993},{"$f":"VLOOKUP(A8,'Info-Tabellen'!$H:$K,3,0)","v":3},{"$f":"3/16*21","v":3.9375},{"$f":"IF(Gewenste_liters=0,\"0\",IF(D8=0,\"  \",(B8*D8/(Gewenste_liters+hopverlies))*effic))","v":10.891365388439539},{"$f":"IF(Gewenste_liters=0,\"0\",IF(D8=0,\"  \",1.8*(Q8)^0.69))","v":4.9627701141832476},{"$f":"IF(D8=\"\",\"  \",(D8*100/Totaalkg))","v":87.141750580945015},{"$f":"IF(E8=\"  \",\"  \",(E8*100/totplato))","v":86.952467205001895},{"$f":"IF(O8=0,\"\",E8-(E8*O8/100))","v":0.99507474685288599},"    te verwachten  uit suikers en",null,null,null,{"$f":"IF(D8=0,0,VLOOKUP(A8,'Info-Tabellen'!$H:$K,4,0))","v":100},{"$f":"IF(N8=0,0,(SVGopmout*N8/100)-ATNfactor-Aftrokmaische)","v":90.86363636363636},{"$f":"IF(C8=0,0,C8*0.3748+0.6)","v":1.7244000000000002},{"$f":"D8*C8/Gewenste_liters*effic*10","v":4.3484625000000001},null,6,245,244,18,137,null,{"$f":"LOOKUP($Y$2,$S$2:$S$48,U2:U48)","v":184}]
["Munich mout 15",{"$f":"VLOOKUP(A9,'Info-Tabellen'!$H:$J,2,0)","v":80.069999999999993},{"$f":"VLOOKUP(A9,'Info-Tabellen'!$H:$J,3,0)","v":15},{"$f":"0.225/21*Gewenste_liters","v":0.22500000000000001},{"$f":"IF(Gewenste_liters=0,\"0\",IF(D9=0,\"  \",(B9*D9/(Gewenste_liters+hopverlies))*effic))","v":0.6223637364822594},2.090822705130821,4.979528604625429,4.9687124117143942,5.6861414105879193E-2," â   extracten   â",null,null,null,{"$f":"IF(D9=0,0,VLOOKUP(A9,'Info-Tabellen'!$H:$K,4,0))","v":100},90.86363636363636,{"$f":"IF(C9=0,0,C9*0.3748+0.6)","v":6.2219999999999995},{"$f":"D9*C9/Gewenste_liters*effic*10","v":1.2424178571428572},null,7,238,233,22,135,null,null,null,"Info over de gekozen hopsoorten:   (A) = aroma (B) = Bitter (U) = Universeel"]
["Tarwemout",{"$f":"VLOOKUP(A10,'Info-Tabellen'!$H:$J,2,0)","v":83.5},{"$f":"VLOOKUP(A10,'Info-Tabellen'!$H:$J,3,0)","v":2.7},{"$f":"0.305/21*Gewenste_liters","v":0.30499999999999999},0.87978843283582087,0.78998016636327062,6.7500276640478045,7.0238920580789754,8.0380670454545444E-2,{"$f":"SUM($E$19:$E$22)","v":0},{"$f":"(1+($J$10/(258.6-0.87955*$J$10)))*1000","v":1000},{"$f":"IF(ISNUMBER($J$10),$J$10,\"\")","v":0},null,{"$f":"IF(D10=0,0,VLOOKUP(A10,'Info-Tabellen'!$H:$K,4,0))","v":100},90.86363636363636,1.6119600000000003,0.30314995714285714,null,8,230,225,24,160,null,"B",null,{"$f":"_hop1","v":"Styrian Golding (A)"}]
["CaraMunich (Cara 120)",{"$f":"VLOOKUP(A11,'Info-Tabellen'!$H:$J,2,0)","v":75},{"$f":"VLOOKUP(A11,'Info-Tabellen'!$H:$J,3,0)","v":120},{"$f":"0.051/21*Gewenste_liters","v":5.0999999999999997E-2},0.13213667441236929,3.1525848390171545,1.1286931503817639,1.0549283252047543,2.6501811917142654E-2,null,"â te verwachten totaal â",null,null,{"$f":"IF(D11=0,0,VLOOKUP(A11,'Info-Tabellen'!$H:$K,4,0))","v":88},79.943636363636358,45.576000000000001,2.2529177142857137,null,9,229,214,30,163,null,{"$f":"LOOKUP($Y$2,$S$2:$S$48,V2:V48)","v":39},null,{"$f":"VLOOKUP(_hop1,'Info-Tabellen'!$R:$V,3,0)","v":"Delicaat, iets pikant en grasachtig/bloemig. Zeer populair vanwege karakteristieke aroma en gemiddelde alpha waarden"}]
["  - - Kies mout of graan - -",{"$f":"VLOOKUP(A12,'Info-Tabellen'!$H:$J,2,0)","v":0},{"$f":"VLOOKUP(A12,'Info-Tabellen'!$H:$J,3,0)","v":0},null,"  ","  ","  ","  ","",{"$f":"IF(ISNUMBER(totplato),totplato,\"\")","v":12.525654232169988},{"$f":"(1+(totplato/(258.6-0.87955*totplato)))*1000","v":1050.5917254220865},{"$f":"IF(ISNUMBER($J$12),$L$7+$L$10,\"\")","v":12.964052130295936},null,{"$f":"IF(D12=0,0,VLOOKUP(A12,'Info-Tabellen'!$H:$K,4,0))","v":0},0,0,0,null,10,224,204,32,165]
["  - - Kies mout of graan - -",{"$f":"VLOOKUP(A13,'Info-Tabellen'!$H:$J,2,0)","v":0},{"$f":"VLOOKUP(A13,'Info-Tabellen'!$H:$J,3,0)","v":0},null,"  ","  ","  ","  ","",null,"â voorspelling eind SG",null,null,{"$f":"IF(D13=0,0,VLOOKUP(A13,'Info-Tabellen'!$H:$K,4,0))","v":0},0,0,0,null,11,218,196,41,168,null,"A"]
["  - - Kies mout of graan - -",{"$f":"VLOOKUP(A14,'Info-Tabellen'!$H:$J,2,0)","v":0},{"$f":"VLOOKUP(A14,'Info-Tabellen'!$H:$J,3,0)","v":0},null,"  ","  ","  ","  ","",{"$f":"voorsp_eindplato","v":1.1588186433304533},{"$f":"voorsp_eindSG","v":1003.9898659740101}," - - - - ",null,{"$f":"IF(D14=0,0,VLOOKUP(A14,'Info-Tabellen'!$H:$K,4,0))","v":0},0,0,0,null,12,212,184,39,170,null,{"$f":"LOOKUP($Y$2,$S$2:$S$48,W2:W48)","v":170},null,{"$f":"_hop2","v":"Styrian Golding (A)"}]
["  - - Kies mout of graan - -",{"$f":"VLOOKUP(A15,'Info-Tabellen'!$H:$J,2,0)","v":0},{"$f":"VLOOKUP(A15,'Info-Tabellen'!$H:$J,3,0)","v":0},null,"  ","  ","  ","  ","",{"$f":"SUM(I8:I18)","v":1.1588186433304533},"<Gr FG Skr>",{"$f":"SUM(I19:I23)","v":0},null,{"$f":"IF(D15=0,0,VLOOKUP(A15,'Info-Tabellen'!$H:$K,4,0))","v":0},0,0,0,null,13,208,176,46,173,null,null,null,{"$f":"VLOOKUP(_hop2,'Info-Tabellen'!$R:$V,3,0)","v":"Delicaat, iets pikant en grasachtig/bloemig. Zeer populair vanwege karakteristieke aroma en gemiddelde alpha waarden"}]
["  - - Kies mout of graan - -",{"$f":"VLOOKUP(A16,'Info-Tabellen'!$H:$J,2,0)","v":0},{"$f":"VLOOKUP(A16,'Info-Tabellen'!$H:$J,3,0)","v":0},null,"  ","  ","  ","  ","",null,"Nodige Gist:",{"$f":"VLOOKUP(HoofdGist,'Info-Tabellen'!$X:$AC,6,0)","v":"k"},null,{"$f":"IF(D16=0,0,VLOOKUP(A16,'Info-Tabellen'!$H:$K,4,0))","v":0},0,0,0,null,14,202,167,52,175,null,"RGB_set"]
["  - - Kies mout of graan - -",{"$f":"VLOOKUP(A17,'Info-Tabellen'!$H:$J,2,0)","v":0},{"$f":"VLOOKUP(A17,'Info-Tabellen'!$H:$J,3,0)","v":0},null,"  ","  ",{"$f":"IF(D17=\"\",\"  \",(D17*100/Totaalkg))","v":"  "},{"$f":"IF(E17=\"  \",\"  \",(E17*100/totplato))","v":"  "},"",{"$f":" IF(L16=\"k\",INT(Gewenste_liters/20*mashplato),\"starter in stappen opkweken:\")","v":13},null,null,null,{"$f":"IF(D17=0,0,VLOOKUP(A17,'Info-Tabellen'!$H:$K,4,0))","v":0},0,0,0,null,15,194,156,54,178,null,{"$f":"SetRGB(Y5,Y8,Y11,Y14)","v":2603220}]
["CaraMunich (Cara 120)",{"$f":"VLOOKUP(A18,'Info-Tabellen'!$H:$J,2,0)","v":75},{"$f":"VLOOKUP(A18,'Info-Tabellen'!$H:$J,3,0)","v":120},null,"  ","  ","  ","  ","",{"$f":"IF(L16=\"k\",\" vooraf  te\",\"maken\")","v":" vooraf  te"},{"$f":"IF(L16=\"k\",\"rehydrateren\",(INT(160*Starter/100))*90)","v":"rehydrateren"},{"$f":"IF(L16=\"k\",\"in water 25°\",\"moutextract \")","v":"in water 25°"},null,{"$f":"IF(D18=0,0,VLOOKUP(A18,'Info-Tabellen'!$H:$K,4,0))","v":0},0,45.576000000000001,0,null,16,190,147,57,180,null,null,null,{"$f":"_hop3","v":"Merkur (B)"}]
["Kristalsuiker",{"$f":"VLOOKUP(A19,'Info-Tabellen'!$M:$O,2,0)","v":100},{"$f":"VLOOKUP(A19,'Info-Tabellen'!$M:$O,3,0)","v":4.5001013284581759E-3},null,{"$f":"IF(Gewenste_liters=0,\"0\",IF(D19=0,\"  \",(B19*D19/(Gewenste_liters+hopverlies))))","v":"  "},{"$f":"IF(Gewenste_liters=0,\"0\",IF(D19=0,\"  \",B19*D19/10/Gewenste_liters*C19))","v":"  "},"  ","  ","",{"$f":"IF(L16=\"k\",\"\",INT(Starter*totplato/4))","v":""},{"$f":"IF(L16=\"k\",\"\",\"gistvoeding,\")","v":""},{"$f":"IF(L16=\"k\",\"\",\"koken in \")","v":""},null,{"$f":"IF(D19=0,0,VLOOKUP(A19,'Info-Tabellen'!$M:$P,4,0))","v":0},{"$f":"IF(N19=0,0,(SVGopsuiker*N19/100))","v":0},0.60168663797790611,null,null,17,193,145,59,201,null,null,null,{"$f":"VLOOKUP(_hop3,'Info-Tabellen'!$R:$V,3,0)","v":"Nieuwe bitterhop, fijner aroma dan Magnum"}]
[" - - Kies suiker of extract - -",{"$f":"VLOOKUP(A20,'Info-Tabellen'!$M:$O,2,0)","v":0},{"$f":"VLOOKUP(A20,'Info-Tabellen'!$M:$O,3,0)","v":0},null,{"$f":"IF(Gewenste_liters=0,\"0\",IF(D20=0,\"  \",(B20*D20/(Gewenste_liters+hopverlies))))","v":"  "},{"$f":"IF(Gewenste_liters=0,\"0\",IF(D20=0,\"  \",B20*D20/10/Gewenste_liters*C20))","v":"  "},"  ","  ","",{"$f":"IF(L16=\"k\",\"\",Starter*1.05)","v":""},{"$f":"IF(L16=\"k\",\"\",\"water    =\")","v":""},{"$f":"IF(L16=\"k\",\"\",mashplato/2.5*Gewenste_liters/100)","v":""},null,{"$f":"IF(D20=0,0,VLOOKUP(A20,'Info-Tabellen'!$M:$P,4,0))","v":0},{"$f":"IF(N20=0,0,(SVGopsuiker*N20/100))","v":0},0,null,null,18,192,140,61,202]
[" - - Kies suiker of extract - -",{"$f":"VLOOKUP(A21,'Info-Tabellen'!$M:$O,2,0)","v":0},{"$f":"VLOOKUP(A21,'Info-Tabellen'!$M:$O,3,0)","v":0},null,{"$f":"IF(Gewenste_liters=0,\"0\",IF(D21=0,\"  \",(B21*D21/(Gewenste_liters+hopverlies))))","v":"  "},{"$f":"IF(Gewenste_liters=0,\"0\",IF(D21=0,\"  \",B21*D21/10/Gewenste_liters*C21))","v":"  "},"  ","  ","",null,"±Nodige liters kookwort @100°Câ",null,null,{"$f":"IF(D21=0,0,VLOOKUP(A21,'Info-Tabellen'!$M:$P,4,0))","v":0},{"$f":"IF(N21=0,0,(SVGopsuiker*N21/100))","v":0},0,null,null,19,191,135,59,204]
[" - - Kies suiker of extract - -",{"$f":"VLOOKUP(A22,'Info-Tabellen'!$M:$O,2,0)","v":0},{"$f":"VLOOKUP(A22,'Info-Tabellen'!$M:$O,3,0)","v":0},null,{"$f":"IF(Gewenste_liters=0,\"0\",IF(D22=0,\"  \",(B22*D22/(Gewenste_liters+hopverlies))))","v":"  "},{"$f":"IF(Gewenste_liters=0,\"0\",IF(D22=0,\"  \",B22*D22/10/Gewenste_liters*C22))","v":"  "},"  ","  ","","@ 75°C >",{"$f":"($L$27+verlieswater)*1.03","v":28.246405863400064},{"$f":"($L$27+verlieswater)*1.04","v":28.520642813530163},null,{"$f":"IF(D22=0,0,VLOOKUP(A22,'Info-Tabellen'!$M:$P,4,0))","v":0},{"$f":"IF(N22=0,0,(SVGopsuiker*N22/100))","v":0},0,null,null,20,191,130,58,205,null,null,null,{"$f":"_hop4","v":" - - Kies hop - -"}]
[" - - Kies suiker of extract - -",{"$f":"VLOOKUP(A23,'Info-Tabellen'!$M:$O,2,0)","v":0},{"$f":"VLOOKUP(A23,'Info-Tabellen'!$M:$O,3,0)","v":0},null,{"$f":"IF(Gewenste_liters=0,\"0\",IF(D23=0,\"  \",(B23*D23/(Gewenste_liters+hopverlies))))","v":"  "},{"$f":"IF(Gewenste_liters=0,\"0\",IF(D23=0,\"  \",B23*D23/10/Gewenste_liters*C23))","v":"  "},"  ","  ","",null,"Totaal aantal L water brouwsel  â",null,null,{"$f":"IF(D23=0,0,VLOOKUP(A23,'Info-Tabellen'!$M:$P,4,0))","v":0},{"$f":"IF(N23=0,0,(SVGopsuiker*N23/100))","v":0},0,null,null,21,191,127,56,206,null,null,null,{"$f":"VLOOKUP(_hop4,'Info-Tabellen'!$R:$V,3,0)","v":0}]
["Clarimalt of Caramelkleur in gram!",100,9000,null," - - - ",{"$f":"IF(Gewenste_liters=0,\"0\",IF(D24=0,\"  \",D24/Gewenste_liters*C24/1000))","v":"  "},{"$f":"IF(D24=\"\",\"  \",(D24*0.1/Totaalkg))","v":"  "},null,null,{"$f":"0.1808*totplato+0.8192*voorsp_eindplato","v":3.2139425177926411},{"$f":"IF($L$10=0,1.035,$L$12/$J$12)","v":1.0349999999999999},{"$f":"IF((Gewenste_liters+(1.7*moutkilos)*1.2)<mashwater,mashwater+verkookwater,($K$22*1.18)+(moutkilos*0.75))","v":36.719633918812072},null,0,0,3373.8,null,null,22,193,120,56,208]
["Voorspellingen > >",null,"Totalen>>",{"$f":"SUM(D8:D23)","v":4.5184999999999995},{"$f":"SUM(E8:E24)","v":12.525654232169988},{"$f":"SUM(F8:F24)","v":10.996157824694494},"< TOT. EBC Kleur",null,{"$f":" SUM(I8:I23)","v":1.1588186433304533},"<< Voorspelling eind °Plato",null,null,null,null,null,null,null,null,23,190,116,57,209]
[null,null,null,"SG >>",{"$f":"StamwortSG","v":1050.5917254220865},{"$f":"IF(kleur=0,0,kleur+(1.22*Kooktijd/60))","v":12.419491158027828},"< EBC kookkleur",null,{"$f":"IF(voorsp_eindplato=0,1000,259/(259.12955-voorsp_eindplato)*1000)","v":1003.9898659740101},"<< Voorspelling eind S.G.",null,null,null,null,null,null,null,null,24,188,112,57,225,null,null,null,{"$f":"_hop5","v":" - - Kies hop - -"}]
["Maischen ",null,null,null,null,null,"Voorspelling alcohol vóór bottelen ongeveer > ",{"$f":"IF((totplato-VSPrestextract)/(2.0665-0.010665*totplato)=0,0,voorsp_eindSG/1000*VSPalcogewicht/0.794/100)","v":6.0915223232861741E-2},"volume",null,"Nodige wort bij 20°C >",{"$f":"Gewenste_liters*(1+VSPalcvol/4)","v":21.319804921972526},null,null,null,null,null,null,25,186,106,50,225,null,null,null,{"$f":"VLOOKUP(_hop5,'Info-Tabellen'!$R:$V,3,0)","v":0}]
["Storten in >",{"$f":"moutkilos*mashfactor*1.02","v":16.591932},"water van",{"$f":"IF(moutkilos=0,55,IF(Aardbier=1,($B$30+tempverlies)*ketelinvloed/100,($B$29+tempverlies)*ketelinvloed/100))","v":66.668578353191364},"â bierkleur â",null,null,null,"corrigeer pH na 10' (5,4-5,8)",null,null,null,null,null,null,null,null,null,26,186,101,51,226]
[{"$f":"IF(Aardbier=1,\"éénstaps maisch,\",IF(Eiwitrust=\"N\",\"Geen eiwitrust, direct naar \",\"1e fase, Eiwitrust\"))","v":"Geen eiwitrust, direct naar "},{"$f":"IF(Aardbier=1,\"      er is\",IF(Eiwitrust=\"J\",54,$B$30))","v":62},{"$f":"IF(Aardbier=1,\"dus geen \",IF(Eiwitrust=\"J\",\"± 2° C\",\"\"))","v":""},{"$f":"IF(Aardbier=1,\"eiwitrust   \",IF(Eiwitrust=\"J\",K5,\"\"))","v":""},null,null,null,null,null,null,"Beslagketel moet minstens een volume hebben van >",{"$f":"IF(moutkilos=0,\"\",moutkilos+mashwater)","v":21.110431999999999},null,null,null,null,null,null,27,181,100,53,227]
[{"$f":"IF(Aardbier=1,\"éénstaps maisch \",\"β amylase (maltose)\")","v":"β amylase (maltose)"},{"$f":"IF(Aardbier=1,66,IF(Aardbier=\"D\",62,63))","v":62},{"$f":"IF(Aardbier=1,\"± 1,5°C\",IF(Aardbier=\"D\",\"± 1,5°C\",\"± 2°C\"))","v":"± 1,5°C"},{"$f":"IF(Aardbier=1,90,IF(Aardbier=\"Z\",25-($K$5/2),45-($K$5/2)))","v":45},null,null,"Vóór het koken moet het wort (zonder de suiker) een densiteit",null,null,null,null,null,null,null,null,null,null,null,28,177,96,55,227,null,null,null,{"$f":"_hop6","v":" - - Kies hop - -"}]
[{"$f":"IF(Aardbier=\"D\",\"Gemengde amylase \",IF(Aardbier=\"Z\",\"Ga snel naar volgende stap\",\"\"))","v":"Gemengde amylase "},{"$f":"IF(Aardbier=\"D\",\"66,5\",\"\")","v":"66,5"},{"$f":"IF(Aardbier=\"D\",\"± 1,5°C\",\"\")","v":"± 1,5°C"},{"$f":"IF(Aardbier=\"D\",15,\"\")","v":15},null,null," hebben van ±  :   ",null,null,{"$f":"mashplato*($L$27+verkookwater-Vast_verlies)/$L$22","v":10.999531735256651},{"$f":"(1+($J$31/(258.6-0.87955*$J$31)))*1000","v":1044.1880716893095},{"$f":"IF(ISNUMBER($J$31),$J$31*1.035,\"\")","v":11.384515345990634},null,null,null,null,null,null,29,168,92,55,228,null,null,null,{"$f":"VLOOKUP(_hop6,'Info-Tabellen'!$R:$V,3,0)","v":0}]
[{"$f":"IF(Aardbier=1,\"\",\"α amylase (body) \")","v":"α amylase (body) "},{"$f":"IF(Aardbier=1,\"\",72)","v":72},{"$f":"IF(Aardbier=1,\"\",IF(Aardbier=\"D\",\"± 1,5°C\",\"± 2°C\"))","v":"± 1,5°C"},{"$f":"IF(Aardbier=1,\"\",IF(Aardbier=\"Z\",30,20))","v":20},null,null,null,null,null,null,null,"Min.vermogen heater â",null,null,null,null,null,null,30,165,88,54,229]
["Filterspoelen:  ga naar","75..78°",null,"nodige L spoelwater >",{"$f":"IF(mashplato<SUM(E19:E23),Vast_verlies,IF(mashplato=0,0,totaalvolume-mashwater))","v":20.127701918812072},"Max.80°","< Pas spoelwater aan: pH 5,2 à 5,5",null,null,null,null,{"$f":"$K$22/6.5","v":4.3456009020615483},null,null,null,null,null,null,31,158,86,57,229,null,null,null,"Noteer: FWH= First Wort Hopping = als het gefilterd wort boven 90°zit, tot net vóór koken toevoegen."]
["STOP spoelen bij SG",{"$f":"259/(259.12955-C34)*1000","v":1011.2070239454996},{"$f":"IF(mashplato<13.4,3,mashplato*mashplato/58)","v":3},{"$f":"C34*1.035","v":3.1049999999999995},null,null,"Kruiden / Kookadditieven",null,null,"aantal","unit","na…min.",null,null,null,null,null,null,32,149,81,56,240,null,null,null,"Adviezen voor de gekozen brouwzouten, kruiden, specerijen en additieven"]
["Koken: Kies Hopsoort â","Type â","aantal gram","% alfazuur","na…min","=IBUâ","Zinksulfaat",null,null,null,{"$f":"VLOOKUP(G35,'Info-Tabellen'!$AE:$AG,2,0)","v":"g "},null,null,null,"water in hop â    ","cor.tijdstip","BitterFactor",null,33,142,77,52,240,null,null,null,{"$f":"VLOOKUP(G35,'Info-Tabellen'!$AE:$AG,3,0)","v":"Sporenelement IN GISTSTARTER TE DOEN!, 0,5 g / hectoliter wort"}]
["Styrian Golding (A)","BLM",{"$f":"23/21*Gewenste_liters","v":23.000000000000004},{"$f":"VLOOKUP(_hop1,'Info-Tabellen'!$R:$T,2,0)","v":3.5},{"$f":"Kooktijd-1","v":69},{"$f":"IF(E36=\"\",\"\",IF(C36=0,\"  \",IF(P36>Kooktijd,0,IF(B36=\"PELL\",TANH(PI()*(Kooktijd-P36)/120)*Q36*C36*D36*10/Gewenste_liters*1.1,TANH(PI()*(Kooktijd-P36)/120)*Q36*C36*D36*10/Gewenste_liters))))","v":0.26374775843491816},"Biersol",null,null,null,{"$f":"VLOOKUP(G36,'Info-Tabellen'!$AE:$AG,2,0)","v":"ml"},null,null,null,{"$f":"IF(B36=\"BLM\",C36*0.006,C36*0.00267)","v":0.13800000000000001},{"$f":"IF(E36=\"\",\"\",IF(E36=\"FWH\",0,IF(E36=\"koud\",Kooktijd,E36)))","v":69},{"$f":"IF(E36=\"\",\"\",IF(E36=\"FWH\",0.398*0.000125^(MaischSG/1000-1),0.398*0.000275^(MaischSG/1000-1)))","v":0.26287105576869885},null,34,135,72,48,240,null,null,null,{"$f":"VLOOKUP(G36,'Info-Tabellen'!$AE:$AG,3,0)","v":"Kiezelsol om trub beter neer te slaan 3ml/10liter direct na koken"}]
["Styrian Golding (A)","BLM",{"$f":"30/21*Gewenste_liters","v":30},{"$f":"VLOOKUP(_hop2,'Info-Tabellen'!$R:$T,2,0)","v":3.5},{"$f":"Kooktijd-53","v":17},11.600864714349299," - - Kies additief - -",null,null,null,{"$f":"VLOOKUP(G37,'Info-Tabellen'!$AE:$AG,2,0)","v":"-"},null,null,null,0.18,17,0.26287105576869885,null,35,130,70,46,241,null,null,null,{"$f":"VLOOKUP(G37,'Info-Tabellen'!$AE:$AG,3,0)","v":"-"}]
["Merkur (B)","BLM",{"$f":"10/21*Gewenste_liters","v":10},{"$f":"VLOOKUP(_hop3,'Info-Tabellen'!$R:$T,2,0)","v":10.7},{"$f":"Kooktijd-53","v":17},11.82183356605119," - - Kies additief - -",null,null,null,{"$f":"VLOOKUP(G38,'Info-Tabellen'!$AE:$AG,2,0)","v":"-"},null,null,null,0.06,17,0.26287105576869885,null,36,119,64,38,241,null,null,null,{"$f":"VLOOKUP(G38,'Info-Tabellen'!$AE:$AG,3,0)","v":"-"}]
[" - - Kies hop - -","BLM",null,{"$f":"VLOOKUP(_hop4,'Info-Tabellen'!$R:$T,2,0)","v":0},null,""," - - Kies additief - -",null,null,null,{"$f":"VLOOKUP(G39,'Info-Tabellen'!$AE:$AG,2,0)","v":"-"},null,null,null,0,"","",null,37,111,62,36,241,null,null,null,{"$f":"VLOOKUP(G39,'Info-Tabellen'!$AE:$AG,3,0)","v":"-"}]
[" - - Kies hop - -","BLM",null,{"$f":"VLOOKUP(_hop5,'Info-Tabellen'!$R:$T,2,0)","v":0},null,""," - - Kies additief - -",null,null,null,{"$f":"VLOOKUP(G40,'Info-Tabellen'!$AE:$AG,2,0)","v":"-"},null,null,null,0,"","",null,38,105,56,28,242,null,null,null,{"$f":"VLOOKUP(G40,'Info-Tabellen'!$AE:$AG,3,0)","v":"-"}]
[" - - Kies hop - -","PELL",null,{"$f":"VLOOKUP(_hop6,'Info-Tabellen'!$R:$T,2,0)","v":0},null,""," - - Kies additief - -",null,null,null,{"$f":"VLOOKUP(G41,'Info-Tabellen'!$AE:$AG,2,0)","v":"-"},null,null,null,0,"","",null,39,99,52,25,242,null,null,null,{"$f":"VLOOKUP(G41,'Info-Tabellen'!$AE:$AG,3,0)","v":"-"}]
["Geïsomeriseerd Extract  >","- -",null,6,"(Nadien)",{"$f":"IF(C42=0,\"  \",C42*D42/Gewenste_liters)","v":"  "}," - - Kies additief - -",null,null,null,{"$f":"VLOOKUP(G42,'Info-Tabellen'!$AE:$AG,2,0)","v":"-"},null,null,"vast verlies > ",{"$f":"Vast_verlies","v":1},"liter",null,null,40,91,50,20,242,null,null,null,{"$f":"VLOOKUP(G42,'Info-Tabellen'!$AE:$AG,3,0)","v":"-"}]
["Advies: Einde Koken, pH best tussen 5,1 en 5,4.",null,null,"Totaal IBU >>",null,{"$f":"SUM(F36:F42)","v":23.686446038835406}," - - Kies additief - -",null,null,null,{"$f":"VLOOKUP(G43,'Info-Tabellen'!$AE:$AG,2,0)","v":"-"},null,null,"blijft achter > ",{"$f":"SUM(O36:O42)","v":1.3780000000000001},"liter",null,null,41,83,45,15,243,null,null,null,{"$f":"VLOOKUP(G43,'Info-Tabellen'!$AE:$AG,3,0)","v":"-"}]
["Einde koken: De gemeten pH >",null,{"$f":"VLOOKUP(HoofdGist,'Info-Tabellen'!$X:$AB,4,0)","v":"22...30"},"<  Advies Vergistings T°",null,null,null,"Toegepaste T° >",null," â Vóór het koken (@75°C) â",null,null,null,"verkookwater > ",{"$f":"verkookpercent/100*Kooktijd/60*$L$27","v":4.7258900910372432},"< extra water bij te rekenen",null,null,42,74,41,7,243]
["Indien High Gravity  > >","Koudwater>",null,"Spoelwater>",{"$f":"IF(C45=\"\",\"\",$E$33-$C$45)","v":""},"Stop spoelen bij >",null,{"$f":"IF(C45=\"\",\"\",259/(259.12955-I45)*1000)","v":""},{"$f":"IF(C45=\"\",\"\",$C$34*Gewenste_liters/(Gewenste_liters-C45))","v":""},{"$f":"IF(C45=\"\",\"\",$K$22/Gewenste_liters*(Gewenste_liters-$C$45))","v":""},{"$f":"IF(C45=\"\",\"\",259/(259.12955-L45)*1000)","v":""},{"$f":"IF(C45=\"\",\"\",J31/(Gewenste_liters-$C$45)*Gewenste_liters)","v":""}]
["Resultaten na Koelen ",null,"vul meting inâ ",null,"â de omgerekende stamwort âæ",null,null,0,null,{"$f":"IF(Stamplato=\"\",\"\",IF(Eindcijfer=\"\",\"\",0.1808*Stamplato+0.8192*Eindplato))","v":3.1249695561759081},null,{"$f":"IF(Stamwort=\"\",\"\",1+(Stamplato/(258.6-0.87955*Stamplato)))","v":1.0508160792750669},null,null,null,"bij verliezen",null,null,43,76,40,40,243]
["Kies een meetinstrument >","S.G.",{"$f":"E26","v":1050.5917254220865},{"$f":"IF(Stamwort=\"\",\"SG\",IF(meter=\"S.G.\",Stamwort,IF(meter=\"°Plato\",259/(259.12955-Stamwort)*1000,IF(meter=\"Brix\",259/(259.12955-Stamplato)*1000))))","v":1050.5917254220865},{"$f":"IF(Stamwort=\"\",\"°Plato\",IF(meter=\"°Plato\",Stamwort,IF(meter=\"S.G.\",(259*Stamwort/1000-259)/(Stamwort/1000-0.0089),IF(meter=\"Brix\",Stamwort/Brixratio))))","v":12.578824007660266},null,{"$f":"IF(Stamwort=\"\",\"Brix\",IF(meter=\"Brix\",Stamwort,IF(meter=\"°Plato\",Stamwort*Brixratio,IF(meter=\"S.G.\",Stamplato*Brixratio))))","v":13.019082847928374},null,"Overschrijf: Bekomen liters>",null,null,{"$f":"Gewenste_liters","v":21},null,"verlieswater >",{"$f":"verkookwater+hopverlies","v":6.1038900910372433},"< som water verdamping",null,null,44,66,37,36,243]
[null,null,"NA DE HOOFDGISTING: noteer SG of °P hevelen >","1,6°P",null,null,"noteer de lagertemp >",null,"Heveldatum >",null,null,null,null,null,null," en in hop bij 20°C",null,null,45,63,35,32,244]
[null,"De resultaten vóór bottelen meet ik met > ","HYGRO",null,null,null,"De aflezing van dit toestel  is in >","S.G.",null,null,"Het getal dat ik aflees > ",{"$f":"voorsp_eindSG","v":1003.9898659740101}]
["Noteer: Het uitgegist bier moet helder zijn voor een Refractometer-meting!",null,null,null,{"$f":"IF(Eindcijfer=\"\",\"- -\",81.92*(Stamplato-Eindplato)/(206.65-1.0665*Stamplato))","v":4.8924210944984976},{"$f":"IF(ISNUMBER(alconalager),12-(alconalager*100/1.97),\"\")","v":8.8597340466225329},{"$f":"IF(Eindcijfer=\"\",\"°Plato\",IF(meternadien=\"°Plato\",Eindcijfer,IF(meternadien=\"S.G.\",(259*Eindcijfer/1000-259)/(Eindcijfer/1000-0.0089),Eindcijfer/1.03)))","v":1.0384743354381498},{"$f":"IF(Eindcijfer=\"\",\"Brix\",IF(meternadien=\"Brix\",Eindcijfer,IF(meternadien=\"°Plato\",Eindcijfer*Brixratio,IF(meternadien=\"S.G.\",VLeindplato*Brixratio))))","v":1.0748209371784849},null,null,{"$f":"IF(Eindcijfer=\"\",\"SG\",IF(meternadien=\"S.G.\",Eindcijfer,IF(meternadien=\"°Plato\",259/(259.12955-Eindcijfer)*1000,IF(meternadien=\"Brix\",259/(259.12955-Eindcijfer)*1000))))","v":1003.9898659740101}]
[{"$f":"IF(refofhyg=\"HYGRO\",\"°Plato en S.G. conversie > \",\"Met een hygrometer is dit >\")","v":"°Plato en S.G. conversie > "},{"$f":"IF(EindSG=\"SG\",\"°Pt\",IF(refofhyg=\"REFRAC\",(259*EindSG/1000-259)/(EindSG/1000-0.0089),VLeindplato))","v":1.0384743354381498},"OF",{"$f":"IF(Stamplato=\"°Plato\",\"SG\",IF(VLeindplato=\"°Plato\",\"SG\",IF(refofhyg=\"HYGRO\",VLeindSG,(1.001843-(0.002318474*Stamplato)-(0.000007775*Stamplato*Stamplato)-(0.000000034*Stamplato*Stamplato*Stamplato)+(0.00574*VLeindplato)+(0.00003344*VLeindplato*VLeindplato)+(0.000000086*VLeindplato*VLeindplato*VLeindplato))*1000)))","v":1003.9898659740101},null,null,null,null,null,"Bekomen echt brouwzaalrendement >",{"$f":"IF(Totaalkg=0,\"\",IF(Bekomenliter=\"\",\"\",IF(Stamwort=\"\",\"\",StamSG/1000*Bekomenliter*Stamplato/(Totaalkg)/100)))","v":0.61418474444563431}]
["Schijnbare Vergistings Graad >",{"$f":"IF(Stamwort=\"\",\"\",IF(Eindcijfer=\"\",\"\",((StamSG-EindSG)/(StamSG-1000))))","v":0.92113599722637196},"  Werkelijke Vergistings Graad >",null,null,{"$f":"IF(Eindcijfer=\"\",\"\",IF(Stamplato=\"\",\"\",(Stamplato-Restextract)/Stamplato))","v":0.75156902153390004},{"$f":"IF(alcogewicht=\"\",\"\",IF(Eindcijfer=\"\",\"\",IF(Bekomenliter=\"\",\"\",EindSG/1000*alcogewicht/0.794/100)))","v":6.1863239281536087E-2},"vol.",{"$f":"IF(Eindcijfer=\"\",\"\",IF(nietvergist>6,\"!!!! >\",IF(nietvergist>5,\"zie na: >>\",\"\")))","v":""},null,{"$f":"IF(nietvergist=\"\",\"\",\"Ev. niet vergist suiker>\")","v":"Ev. niet vergist suiker>"},{"$f":"IF(Stamwort=\"\",\"\",IF(Eindcijfer=\"\",\"\",IF(((Eindplato-voorsp_eindplato)*8.1-2)<0,0,(Eindplato-voorsp_eindplato)*8.1-2)))","v":0}]
["Bottelen:",{"$f":"IF($G$54=\"J\",$K$54,IF(alconalager=\"\",\"\",IF(kleur>50,botsuikervlgskleur,botsuikervlgsalco)))","v":8.5},null,"Temperatuur hergisting >",null,null,"duurtijd >",null,null,"gist hergisting >","FermentisSafbrew F2"]
["Kies suikersoort > >","Kristalsuiker",null,null,null,"Zelf bottelsuiker opgeven? >","J",null,null,"zo ja, geef aantal g/liter>",8.5]
["finaal g suiker/L Bottelen >",{"$f":"IF(Eindcijfer=\"\",\"\",IF(suikersoort=\"Kristalsuiker\",adviessuiker,IF(suikersoort=\"Dextrose\",adviessuiker/0.93,adviessuiker/0.975)))","v":8.5},"Suikergift >",{"$f":"IF(Eindcijfer=\"\",\"\",IF(adviessuiker=\"\",\"\",suikergift*Bekomenliter))","v":178.5},null,{"$f":"IF(Eindcijfer=\"\",\"\",IF(adviessuiker-nietvergist<0,\"GEEN\",suikergift-nietvergist))","v":8.5},null,"Dan is suikergift >",{"$f":"IF(Eindcijfer=\"\",\"\",IF(adviessuiker-nietvergist<0,\"\",(suikergift-nietvergist)*Bekomenliter))","v":178.5},{"$f":"IF(Eindcijfer=\"\",\"\",IF(suikergift=corsuiker,\"Suikergift blijft dezelfde: \",\"Indien restsuiker verder kan uitgisten:\"))","v":"Suikergift blijft dezelfde: "}]
["Gebotteld Vol.% >>",{"$f":"IF(ISNUMBER(alconalager),alconalager+(adviessuiker/16.5/100),\"\")","v":6.7014754433051243E-2},null,"Minstens houdbaar tot ± >",{"$f":"IF($B$56=\"\",\"\",IF(Botdatum=\"\",\"\",IF($B$56*100<5,((($B$56*100)-5)*30)+215+Botdatum,((($B$56*100)-5)*130)+215+Botdatum)))","v":""},null,"TIP: Vergelijk uw finaal S.G. met labgisting > restsuikercontrole."]
["Brouwplanner: R. Baert, Reynaert Wijn & Biergilde.",null,null,"versie: 7.testD",null,null,null,null,null,"Tekstbestand voor Forum: Herman H."]
["Nota's: "]
["Wordt Hgravity gebrouwen: 40L in kookvat, nadien Montille bijvoegen, de montille: eerst 5 l in gistvat met beetje gekookt wort  om te hydrateren @ 25°"]
["Voorbeeld: ik bekwam op brouwdag na bijvoegen van de 10 lier water  51,5L wort van 12,3°Pt. Ik tel daarbij dat van de suiker dus + 4,4 geeft 16,7°Pt=SG1068"]
["(In die 51,5 liter zit de pan wort waarin de suiker gekookt is en opzij staat voor brouwdag + 3 of zo toe te dienen)"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Voor overzichtelijkheid: Best kolommen N tot en met Y verbergen!"]
[]
["Overzicht Wijzigingen",null,"Noteer: een testversie heeft een \"test + nr\" achter de versienummer"]
[]
["Versie 6.test.6:"," - Er wordt ondersteld dat giststarter ALTIJD afgegoten wordt, zoals het hoort, formules daartoe aangepast."]
[null," - De voorspelling voor de eindvergisting wordt per grondstofregel berekend"]
[null," - Allerlei kleine verbeteringen om nauwkeuriger te voorspellen."]
[null," - Betere voorspelling te bekomen Stamwort in fie van beslagdikte"]
[null," - Betere voorspelling eindvergisting in functie van beslagdikte en Maischprofiel"]
[null," - Ook nieuw: kleurbalk die ongeveer een idee geeft van de voorspelde kleur."]
["Versie 6.test 10k:"," - Kleurvoorspelling volledig herzien + er zat opnieuw een fout factor 10 in suikerkleuren (nov 2013)"]
[null," - Nog nieuwe gisten toegevoegd."]
[null," - Bitterheid gecorrigeerd volgens data bekomen uit een brouwerij met "]
[null,"   zeer betrouwbare hopgegevens en metingen lijst okt 2013."]
["Versie 7:"," - Nodige Densiteit vóór het koken toegevoegd in cellen J/K/L 31"]
[null," - er is een versie voor oudere Office software (Office 2000/2003) en voor recente (2007 tot 2013)"]
[null," - Giststarter of Korrelgist in de cellen J/K/L 17 tot 20 wordt getoond volgens gistkeuze"]
[null," - Tekstbestand maken wordt door Forumlid Herman H gemaakt!"]
[null," - Hopberekeningsformules gecorrigeerd voor FWH, PELL enz…"]
[null," - Veel nieuwe korrelgisten toegevoegd, o.a. Mangrove Jacks en Gozdawa (vanaf 7testb)"]
[null," - Fout in cel K40 hersteld,"]
[null," - Vanaf test7d: Rij inevoegd voor High Gravity Brewing"]