{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["BrewReport","Labels","Data","Omregninger","Malt","Tilsætninger","Gær","Humle","Typer","Malt X-ref.","Indkøb","Links"],"not_rendered":{"charts":0,"images":6,"macros":1,"external_links":0,"defined_names":5,"comments":5,"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":"BrewReport","index":0,"n_rows":78,"n_cols":12,"rows_kept":78,"cut":false,"hidden":false,"merged":[[48,6,48,7],[48,8,48,11],[51,6,51,7],[1,2,1,11],[0,0,0,1],[0,2,0,11],[71,6,71,8],[71,9,71,11],[72,6,72,8],[72,9,72,11],[39,6,39,7],[66,8,66,9],[57,8,57,9],[5,8,5,9],[3,8,3,9],[7,10,7,11],[31,8,31,9],[30,8,30,9],[29,8,29,9],[3,5,3,6],[21,6,21,7],[22,6,22,7],[23,6,23,7],[24,6,24,7],[25,6,25,7],[47,6,47,11],[37,8,37,9],[25,8,25,9],[26,8,26,9],[38,6,38,7],[32,6,32,7],[33,6,33,7],[43,6,43,9],[37,6,37,7],[34,6,34,7],[26,6,26,7],[27,8,27,9],[29,6,29,7],[30,6,30,7],[31,6,31,7],[45,10,45,11],[2,2,2,3],[5,5,5,6],[7,8,7,9],[33,8,33,9],[11,6,11,7],[10,6,10,7],[9,6,9,7],[8,6,8,7],[6,6,6,11],[16,6,16,7],[15,6,15,7],[23,8,23,9],[22,8,22,9],[2,9,2,11],[20,8,20,9],[21,8,21,9],[32,8,32,9],[2,5,2,6],[7,6,7,7],[18,6,18,7],[14,6,14,7],[13,6,13,7],[12,6,12,7],[24,8,24,9],[68,8,68,9],[28,8,28,9],[57,6,57,7],[68,6,68,7],[67,8,67,9],[49,6,49,7],[52,8,52,9],[50,8,50,9],[50,10,50,11],[58,8,58,9],[53,6,53,7],[52,6,52,7],[62,6,62,11],[57,10,57,11],[65,10,65,11],[65,8,65,9],[56,7,56,11],[59,8,59,9],[49,8,49,11],[67,6,67,7],[66,6,66,7],[65,6,65,7],[64,6,64,7],[63,6,63,7],[66,10,66,11],[36,6,36,7],[39,8,39,9],[38,8,38,9],[56,1,56,4],[55,0,55,4],[27,6,27,7],[76,9,76,11],[77,6,77,8],[77,9,77,11],[75,6,75,8],[75,9,75,11],[74,6,74,8],[74,9,74,11],[73,6,73,8],[73,9,73,11],[76,6,76,8],[67,10,68,11],[69,6,69,7],[69,8,69,9],[69,10,69,11],[64,10,64,11],[64,8,64,9],[63,8,63,11],[60,6,60,7],[45,6,45,7],[28,6,28,7],[40,6,40,7],[55,6,55,11],[53,8,53,9],[51,8,51,9],[44,6,44,7],[58,10,59,11],[59,6,59,7],[58,6,58,7],[60,8,60,9],[60,10,60,11],[35,6,35,7],[35,8,35,9],[51,10,52,11],[42,6,42,11],[44,10,44,11],[44,8,44,9],[45,8,45,9],[53,10,53,11],[34,8,34,9],[36,8,36,9],[40,8,40,9],[5,0,5,1],[3,0,3,1],[2,0,2,1],[1,0,1,1],[53,0,53,1],[52,0,52,1],[51,0,51,1],[50,0,50,1],[49,0,49,1],[48,0,48,1],[47,0,47,1],[46,0,46,1],[45,0,45,1],[44,0,44,1],[39,0,39,1],[38,0,38,1],[37,0,37,1],[36,0,36,1],[35,0,35,1],[17,0,17,1],[16,0,16,1],[15,0,15,1],[14,0,14,1],[6,0,6,2],[40,0,40,1],[8,0,8,1],[13,0,13,1],[12,0,12,1],[11,0,11,1],[10,0,10,1],[9,0,9,1],[66,0,69,4],[76,1,76,2],[75,1,75,2],[74,1,74,2],[73,1,73,2],[72,1,72,2],[71,1,71,2],[71,3,71,5],[76,3,76,5],[75,3,75,5],[42,0,42,4],[73,3,73,5],[74,3,74,5],[72,3,72,5],[65,1,65,4]]}
["Bryggeri:",null,{"$f":"IF(Data!B2=\"\",\"\",Data!B2)","v":"eyeT Brewery"}]
["Bryg navn:"]
["Bryg nr.:",null,73,null,"Type:","Cream Ale",null,null,"Dato:"]
["Typiske data:",null,"EBC",{"$f":"IF($F$3=\"\",\"\",CONCATENATE(VLOOKUP($F$3,Typer!$C$4:$N$102,8,FALSE),\" - \",VLOOKUP($F$3,Typer!$C$4:$N$102,9,FALSE)))","v":"10 - 5"},"OG",{"$f":"IF($F$3=\"\",\"\",CONCATENATE(VLOOKUP($F$3,Typer!$C$4:$N$102,2,FALSE),\" - \",VLOOKUP($F$3,Typer!$C$4:$N$102,3,FALSE)))","v":"1055 - 1042"},null,"IBU",{"$f":"IF($F$3=\"\",\"\",CONCATENATE(VLOOKUP($F$3,Typer!$C$4:$N$102,10,FALSE),\" - \",VLOOKUP($F$3,Typer!$C$4:$N$102,11,FALSE)))","v":"20 - 15"},null,"RBR",{"$f":"IF($F$3=\"\",\"\",VLOOKUP($F$3,Typer!$C$4:$N$102,12,FALSE))","v":0.38}]
[]
["Dette brygs data:",null,null,{"$f":"IF(Data!D26=0,\"\",Data!D26)","v":10},"OG",{"$f":"IF(C19=0,\"\",IF(C50=\"\",IF(J3=\"\",Data!F26,C49),IF(J3=\"\",Data!F26,C50)))","v":1055},null,"IBU",{"$f":"IF(Data!F54=0,\"\",Data!F54)","v":23.730840000000001},null,"RBR",{"$f":"IF(I50=\"\",\"\",IF(C52=\"\",IF(I6=\"\",\"\",(Data!F54/(F6-1000)*(1+((Data!E30/100)-0.7655)))),(Data!F54/(F6-1000)*(1+((C53/100)-0.7655)))))","v":0.44204082872727279}]
["Ingredienser",null,null,"fra:","Hjemmebryggeren",null,"Mæskning"]
["Malttype",null,"Mængde","Enhed","Priser",null,"Proces",null,"Tid",null,"Temperatur"]
["Pale Ale",null,5.5,"kg",{"$f":"IFERROR(VLOOKUP($A9,Malt!$A$3:$K$75,COLUMN(INDIRECT(CONCATENATE(HLOOKUP($E$7,Malt!$G$1:$K$2,2,FALSE),2))),FALSE),\"\")","v":104.5}]
[null,null,null,"kg",{"$f":"IFERROR(VLOOKUP($A10,Malt!$A$3:$K$75,COLUMN(INDIRECT(CONCATENATE(HLOOKUP($E$7,Malt!$G$1:$K$2,2,FALSE),2))),FALSE),\"\")","v":""},null,"Indmæskning",null,20,"min",{"$f":"CONCATENATE(\"35 - \",K11)","v":"35 - 65"},"°C"]
[null,null,null,"kg",{"$f":"IFERROR(VLOOKUP($A11,Malt!$A$3:$K$75,COLUMN(INDIRECT(CONCATENATE(HLOOKUP($E$7,Malt!$G$1:$K$2,2,FALSE),2))),FALSE),\"\")","v":""},null,"Mæskning 1",null,75,"min",65,"°C"]
[null,null,null,"kg",{"$f":"IFERROR(VLOOKUP($A12,Malt!$A$3:$K$75,COLUMN(INDIRECT(CONCATENATE(HLOOKUP($E$7,Malt!$G$1:$K$2,2,FALSE),2))),FALSE),\"\")","v":""},null,"Mæskning 2",null,null,"min",null,"°C"]
[null,null,null,"kg",{"$f":"IFERROR(VLOOKUP($A13,Malt!$A$3:$K$75,COLUMN(INDIRECT(CONCATENATE(HLOOKUP($E$7,Malt!$G$1:$K$2,2,FALSE),2))),FALSE),\"\")","v":""},null,"Mæskning 3",null,null,"min",null,"°C"]
[null,null,null,"kg",{"$f":"IFERROR(VLOOKUP($A14,Malt!$A$3:$K$75,COLUMN(INDIRECT(CONCATENATE(HLOOKUP($E$7,Malt!$G$1:$K$2,2,FALSE),2))),FALSE),\"\")","v":""},null,"Mæskning 4",null,null,"min",null,"°C"]
[null,null,null,"kg",{"$f":"IFERROR(VLOOKUP($A15,Malt!$A$3:$K$75,COLUMN(INDIRECT(CONCATENATE(HLOOKUP($E$7,Malt!$G$1:$K$2,2,FALSE),2))),FALSE),\"\")","v":""}]
[null,null,null,"kg",{"$f":"IFERROR(VLOOKUP($A16,Malt!$A$3:$K$75,COLUMN(INDIRECT(CONCATENATE(HLOOKUP($E$7,Malt!$G$1:$K$2,2,FALSE),2))),FALSE),\"\")","v":""},null,"Forsukring",null,15,"min",72,"°C"]
[null,null,null,"kg",{"$f":"IFERROR(VLOOKUP($A17,Malt!$A$3:$K$75,COLUMN(INDIRECT(CONCATENATE(HLOOKUP($E$7,Malt!$G$1:$K$2,2,FALSE),2))),FALSE),\"\")","v":""},null,"Afmæskning",null,10,"min",78,"°C"]
[null,null,null,"kg",{"$f":"IFERROR(VLOOKUP($A18,Malt!$A$3:$K$75,COLUMN(INDIRECT(CONCATENATE(HLOOKUP($E$7,Malt!$G$1:$K$2,2,FALSE),2))),FALSE),\"\")","v":""}]
["Total",null,{"$f":"SUM(C9:C18)","v":5.5},"kg",{"$f":"IF(SUM(E9:E15)=0,\"\",SUM(E9:E15))","v":104.5},null,"Fraløb",null,15,"min",78,"°C"]
[]
["Humletype","Anv.","Mængde","Enhed",null,null,"Kogning",null,"Tid før slut",null,"Enhed"]
["Bitterhumle",null,null,null,null,null,"I alt",null,90,null,"min"]
["Cascade",{"$f":"IF(A23=\"\",\"\",VLOOKUP(A23,Humle!$A$2:$H$37,7,FALSE))","v":"BA"},37,"gram","Justeres evt.",null,{"$f":"IF(A23=\"\",\"\",A23)","v":"Cascade"},null,60,null,"min."]
[null,{"$f":"IF(A24=\"\",\"\",VLOOKUP(A24,Humle!$A$2:$H$37,7,FALSE))","v":""},null,"gram",null,null,{"$f":"IF(A24=\"\",\"\",A24)","v":""},null,null,null,"min."]
[null,{"$f":"IF(A25=\"\",\"\",VLOOKUP(A25,Humle!$A$2:$H$37,7,FALSE))","v":""},null,"gram",null,null,{"$f":"IF(A25=\"\",\"\",A25)","v":""},null,null,null,"min."]
["Smagshumle"]
[null,{"$f":"IF(A27=\"\",\"\",VLOOKUP(A27,Humle!$A$2:$H$37,7,FALSE))","v":""},null,"gram",null,null,{"$f":"IF(A27=\"\",\"\",A27)","v":""},null,null,null,"min"]
[null,{"$f":"IF(A28=\"\",\"\",VLOOKUP(A28,Humle!$A$2:$H$37,7,FALSE))","v":""},null,"gram",null,null,{"$f":"IF(A28=\"\",\"\",A28)","v":""},null,null,null,"min"]
[null,{"$f":"IF(A29=\"\",\"\",VLOOKUP(A29,Humle!$A$2:$H$37,7,FALSE))","v":""},null,"gram",null,null,{"$f":"IF(A29=\"\",\"\",A29)","v":""},null,null,null,"min"]
["Aromahumle"]
["Cascade",{"$f":"IF(A31=\"\",\"\",VLOOKUP(A31,Humle!$A$2:$H$37,7,FALSE))","v":"BA"},30,"gram",null,null,{"$f":"IF(A31=\"\",\"\",A31)","v":"Cascade"},null,5,null,"min"]
[null,{"$f":"IF(A32=\"\",\"\",VLOOKUP(A32,Humle!$A$2:$H$37,7,FALSE))","v":""},null,"gram",null,null,{"$f":"IF(A32=\"\",\"\",A32)","v":""},null,null,null,"min"]
[null,{"$f":"IF(A33=\"\",\"\",VLOOKUP(A33,Humle!$A$2:$H$37,7,FALSE))","v":""},null,"gram",null,null,{"$f":"IF(A33=\"\",\"\",A33)","v":""},null,null,null,"min"]
["Andet",null,null,null,"Manuel indtast"]
[null,null,null,"gram",null,null,{"$f":"IF($A$35=\"\",\"\",$A$35)","v":""},null,null,null,"min"]
["Rørsukker",null,440,"gram",null,null,{"$f":"IF($A$36=\"\",\"\",$A$36)","v":"Rørsukker"},null,60,null,"min"]
[null,null,null,"gram",null,null,{"$f":"IF($A$37=\"\",\"\",$A$37)","v":""},null,null,null,"min"]
[null,null,null,"gram",null,null,{"$f":"IF($A$38=\"\",\"\",$A$38)","v":""},null,null,null,"min"]
[null,null,null,"gram",null,null,{"$f":"IF($A$39=\"\",\"\",$A$39)","v":""},null,null,null,"min"]
[null,null,null,"gram",null,null,{"$f":"IF($A$40=\"\",\"\",$A$40)","v":""},null,null,null,"min"]
["Klar Urt",null,7,"gram",null,null,{"$f":"IF($A$41=\"\",\"\",$A$41)","v":"Klar Urt"},null,15,null,"min"]
[]
["Målinger",null,null,null,null,null,"Køling"]
[null,null,"Målt","Enhed",null,null,null,null,null,null,"Enhed"]
["Udbytte efter mæskning",null,null,"liter",null,null,"Tid",null,15,null,"min"]
["Udbytte til gæring",null,null,"liter",null,null,"Nedkøling til",null,25,null,"°C"]
["Udbytte til tapning",null,null,"liter"]
["Bryggedato:",null,{"$f":"IF(J3=\"\",\"\",J3)","v":""},null,null,null,"Gæring - 1. ferm."]
["Vægtfylde efter mæskning",null,null,"Oeschle",{"$f":"IF(C49=\"\",\"\",CONCATENATE(\"Effektivitet: \",ROUND((Data!A24*100),0),\" %\"))","v":""},null,"Anvend 2 slags gær:",null,"Mangrove Jack's California Lager M54"]
["Vægtfylde før gæring",null,null,"Oeschle",{"$f":"IF(C50=\"\",\"\",CONCATENATE(\"Effektivitet: \",ROUND((Data!A25*100),0),\" %\"))","v":""},null,"Tilsat gær type:",null,"Mangrove Jack´s New World Strong Ale M42"]
["Flaskedato:",null,{"$f":"IF(I68=\"\",\"\",I68)","v":""},null,null,null,"Gæringstemperatur                      °C",18,"Dato",null,"Gærer i spand"]
["Vægtfylde efter gæring",null,null,"Oeschle",null,null,"Gæring i gang",null,null,null,5]
["Forgæringsgrad",null,{"$f":"IF(C50=\"\",\"\",IF(C52=\"\",\"\",ROUND(((C50-C52)/(C50-1000))*100,0)))","v":""},"%",{"$f":"IF(Data!F30=\"\",\"\",CONCATENATE(\"Estimeret: \",ROUND((Data!F30),1),\" %\"))","v":"Estimeret: 5,7 %"},null,"Gæring færdig"]
["Alkohol indhold",null,{"$f":"IF(C50=0,\"\",IF(C52=0,\"\",ROUND(((C50-C52)/7.5)+(IF(I66=0,0,(((ROUND(I66/(IF(C46=0,C45,C46)),1))-2)/10))),1)))","v":""},"% Vol.",{"$f":"IF(C54=\"\",CONCATENATE(\"Genstande: \",Data!F35),CONCATENATE(\"Genstande: \",Data!F36))","v":"Genstande: 1,9"},null,"Tid ",null,{"$f":"IF(I53=0,0,(I53-I52))","v":0},null,"dage"]
[]
["Tapning - fordelt på flaskestørrelse",null,null,null,null,null,"Modning - 2. ferm."]
["Label Farve / Kapsel",null,null,null,null,null,"Kommentar"]
["Flasker","à","2 liter",null,null,null,null,null,"Dato",null,"Modner i spand"]
["Flasker","à","1 liter",null,null,null,"Modning fra",null,null,null,"?"]
["Flasker","à","¾ liter",2,"0,66 liter",null,"Modning til"]
["Flasker","à","½ liter",39,null,null,"Tid ",null,{"$f":"IF(I60=0,0,(I60-I59))","v":0},null,"dage"]
["Flasker","à","⅓ liter",2]
["Flasker","à","¼ liter",null,null,null,"Karbonering - 3. ferm."]
["Antal flasker i alt",null,null,{"$f":"SUM(D58:D63)","v":43},null,null,"Tilsat gær type:"]
[null,null,null,null,null,null,"Anbefalet mængde sukker til karbonering:",null,{"$f":"IF(F3=\"\",\"\",ROUND((((VLOOKUP(F3,Typer!C3:T102,15,FALSE)-VLOOKUP(H51,Gær!I2:J29,2,FALSE))*4)*C47),0))","v":0},null,{"$f":"CONCATENATE(\"gram = \",IF(C47=0,\"?\",IF(I65=\"\",0,(ROUND(I65/C47,1)))),\" g/ltr.\")","v":"gram = ? g/ltr."}]
["Brygnoter:","Inspiration: Horst Dornbusch",null,null,null,null,"Tilsat sukker",null,null,null,{"$f":"CONCATENATE(\"gram = \",IF(C47=0,\"?\",(ROUND(I66/C47,1))),\" g/ltr.\")","v":"gram = ? g/ltr."}]
[null,null,null,null,null,null,null,null,"Dato",null,"Karbonerer i"]
[null,null,null,null,null,null,"Karbonering fra",null,null,null,"Flaske"]
[null,null,null,null,null,null,"Karbonering til"]
[null,null,null,null,null,null,"Tid ",null,{"$f":"IF(I69=0,0,(I69-I68))","v":0},null,"dage"]
[]
["Vurderinger:","Skumkrone",null,"Duft",null,null,"Smag",null,null,"Farve"]
["Ved brygning","-"]
["Ved omstikning","-"]
["Ved flaskning","-"]
["Ved første åbning"]
["Efter nogen tid"]
["Brygget af:",{"$f":"IF(Data!B3=\"\",\"\",Data!B3)","v":"André"},null,null,null,null,"Godkendt til servering d.:"]

{"sheet":"Labels","index":1,"n_rows":84,"n_cols":22,"rows_kept":84,"cut":false,"hidden":false,"merged":[[0,1,0,23],[1,3,1,9],[5,3,6,9],[5,10,9,11],[5,15,6,21],[5,22,9,23],[8,4,8,5],[8,16,8,17],[2,13,4,23],[2,1,4,11],[19,3,19,9],[14,4,14,8],[16,4,16,8],[26,3,27,9],[26,15,27,21],[10,22,20,23],[10,4,10,8],[10,10,20,11],[10,16,10,20],[14,16,14,20],[16,16,16,20],[11,4,11,5],[11,16,11,17],[12,16,12,20],[12,4,12,8],[19,15,19,21],[23,13,25,23],[26,22,30,23],[29,16,29,17],[20,4,20,5],[29,4,29,5],[20,6,20,9],[20,18,20,21],[31,22,41,23],[33,16,33,20],[26,10,30,11],[23,1,25,11],[47,10,51,11],[40,3,40,9],[40,15,40,21],[56,16,56,20],[61,3,61,9],[50,4,50,5],[43,4,43,9],[43,15,43,18],[44,1,46,11],[44,13,46,23],[32,4,32,5],[31,4,31,8],[31,16,31,20],[35,4,35,8],[37,4,37,8],[35,16,35,20],[37,16,37,20],[33,4,33,8],[31,10,41,11],[32,16,32,17],[56,4,56,8],[68,22,72,23],[65,13,67,23],[82,15,82,21],[68,3,69,9],[61,15,61,21],[58,4,58,8],[58,16,58,20],[68,15,69,21],[71,16,71,17],[77,4,77,8],[79,4,79,8],[73,4,73,8],[73,16,73,20],[74,4,74,5],[74,16,74,17],[75,4,75,8],[75,16,75,20],[73,10,83,11],[82,3,82,9],[41,6,41,9],[41,18,41,21],[62,6,62,9],[62,18,62,21],[83,6,83,9],[83,18,83,21],[73,22,83,23],[47,22,51,23],[50,16,50,17],[52,22,62,23],[65,1,67,11],[68,10,72,11],[71,4,71,5],[77,16,77,20],[79,16,79,20],[47,3,48,9],[47,15,48,21],[52,4,52,8],[52,16,52,20],[52,10,62,11],[53,4,53,5],[53,16,53,17],[54,4,54,8],[54,16,54,20]]}
[null,"FLASKE-ETIKETTER"]
[null,null,null,"Udfyldes automatisk fra BrewReport til denne Label "]
[null,{"$f":"IF(BrewReport!C1=\"\",\"\",BrewReport!C1)","v":"eyeT Brewery"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"$B$3","v":"eyeT Brewery"}]
[]
[]
[null,null,null,{"$f":"IF(BrewReport!C2<>\"\",CONCATENATE(BrewReport!C2,\" - \",BrewReport!F3),IF(BrewReport!F3=\"\",\"\",BrewReport!F3))","v":"Cream Ale"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"$D$6","v":"Cream Ale"}]
[]
[]
[null,null,null,"Brygget:",{"$f":"IF(BrewReport!J3=\"\",\"\",BrewReport!J3)","v":""},null,"Tappet:",{"$f":"IF(BrewReport!C51=\"\",\"\",BrewReport!C51)","v":""},"Bryg #",{"$f":"IF(BrewReport!C3=\"\",\"\",BrewReport!C3)","v":73},null,null,null,null,null,"Brygget:",{"$f":"$E$9","v":""},null,"Tappet:",{"$f":"$H$9","v":""},{"$f":"$I$9","v":"Bryg #"},{"$f":"$J$9","v":73}]
[]
[null,null,null,"Malt:",{"$f":"CONCATENATE(IF(BrewReport!A9=\"\",\"\",BrewReport!A9),IF(BrewReport!A10=\"\",\"\",CONCATENATE(\", \",BrewReport!A10)),IF(BrewReport!A11=\"\",\"\",CONCATENATE(\", \",BrewReport!A11)),IF(BrewReport!A12=\"\",\"\",CONCATENATE(\", \",BrewReport!A12)),IF(BrewReport!A13=\"\",\"\",CONCATENATE(\", \",BrewReport!A13)),IF(BrewReport!A14=\"\",\"\",CONCATENATE(\", \",BrewReport!A14)),IF(BrewReport!A15=\"\",\"\",CONCATENATE(\", \",BrewReport!A15)))","v":"Pale Ale"},null,null,null,null,null,null,null,null,null,null,{"$f":"$D$11","v":"Malt:"},{"$f":"$E$11","v":"Pale Ale"}]
[]
[null,null,null,"Humle:",{"$f":"CONCATENATE(IF(BrewReport!A23=\"\",\"\",BrewReport!A23),IF(BrewReport!A24=\"\",\"\",CONCATENATE(\", \",BrewReport!A24)),IF(BrewReport!A25=\"\",\"\",CONCATENATE(\", \",BrewReport!A25)),IF(BrewReport!A27=\"\",\"\",CONCATENATE(\", \",BrewReport!A27)),IF(BrewReport!A28=\"\",\"\",CONCATENATE(\", \",BrewReport!A28)),IF(BrewReport!A29=\"\",\"\",CONCATENATE(\", \",BrewReport!A29)),IF(BrewReport!A32=\"\",\"\",CONCATENATE(\", \",BrewReport!A31)),IF(BrewReport!A32=\"\",\"\",CONCATENATE(\", \",BrewReport!A32)),IF(BrewReport!A33=\"\",\"\",CONCATENATE(\", \",BrewReport!A33)))","v":"Cascade"},null,null,null,null,null,null,null,null,null,null,{"$f":"$D$13","v":"Humle:"},{"$f":"$E$13","v":"Cascade"}]
[]
[null,null,null,"Gær:",{"$f":"IF(BrewReport!I50=\"\",\"\",CONCATENATE(BrewReport!I49,\", og \",RIGHT(BrewReport!I50,24)))","v":"Mangrove Jack's California Lager M54, og New World Strong Ale M42"},null,null,null,null,null,null,null,null,null,null,{"$f":"$D$15","v":"Gær:"},{"$f":"$E$15","v":"Mangrove Jack's California Lager M54, og New World Strong Ale M42"}]
[]
[null,null,null,"Tilsætning:",{"$f":"CONCATENATE(IF(BrewReport!A36=\"\",\"\",BrewReport!A36),IF(BrewReport!A37=\"\",\"\",CONCATENATE(\", \",BrewReport!A37)),IF(BrewReport!A38=\"\",\"\",CONCATENATE(\", \",BrewReport!A38)),IF(BrewReport!A39=\"\",\"\",CONCATENATE(\", \",BrewReport!A39)),IF(BrewReport!A40=\"\",\"\",CONCATENATE(\", \",BrewReport!A40)),IF(OR((BrewReport!A41=\"Klar Urt\"),(BrewReport!A41=\"\")),\"\",CONCATENATE(\", \",BrewReport!A41)),IF(BrewReport!A35=\"\",\"\",CONCATENATE(\", \",BrewReport!A35)))","v":"Rørsukker"},null,null,null,null,null,null,null,null,null,null,{"$f":"$D$17","v":"Tilsætning:"},{"$f":"$E$17","v":"Rørsukker"}]
[]
[null,null,null,"Alc. Vol.:",{"$f":"IF(BrewReport!$C$54=\"\",\"\",BrewReport!$C$54/100)","v":""},null,"EBC:",{"$f":"BrewReport!$D$6","v":10},"IBU:",{"$f":"BrewReport!$I$6","v":23.730840000000001},null,null,null,null,null,{"$f":"$D$19","v":"Alc. Vol.:"},{"$f":"$E$19","v":""},null,{"$f":"$G$19","v":"EBC:"},{"$f":"$H$19","v":10},{"$f":"$I$19","v":"IBU:"},{"$f":"$J$19","v":23.730840000000001}]
[]
[null,null,null,"Brygget af:",{"$f":"IF(BrewReport!B78=\"\",\"\",BrewReport!B78)","v":"André"},null,{"$f":"IF(Data!F35=\"\",\"\",CONCATENATE(\"Indhold: \",Data!B6,\" liter; svarer til \",IF(Data!F36=\"\",Data!F35,Data!F36),\" genstande\"))","v":"Indhold: 0,5 liter; svarer til 1,9 genstande"},null,null,null,null,null,null,null,null,{"$f":"$D$21","v":"Brygget af:"},{"$f":"$E$21","v":"André"},null,{"$f":"$G$21","v":"Indhold: 0,5 liter; svarer til 1,9 genstande"}]
[]
[]
[null,{"$f":"$B$3","v":"eyeT Brewery"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"$B$3","v":"eyeT Brewery"}]
[]
[]
[null,null,null,{"$f":"$D$6","v":"Cream Ale"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"$D$6","v":"Cream Ale"}]
[]
[]
[null,null,null,"Brygget:",{"$f":"$E$9","v":""},null,"Tappet:",{"$f":"$H$9","v":""},{"$f":"$I$9","v":"Bryg #"},{"$f":"$J$9","v":73},null,null,null,null,null,"Brygget:",{"$f":"$E$9","v":""},null,"Tappet:",{"$f":"$H$9","v":""},{"$f":"$I$9","v":"Bryg #"},{"$f":"$J$9","v":73}]
[]
[null,null,null,{"$f":"$D$11","v":"Malt:"},{"$f":"$E$11","v":"Pale Ale"},null,null,null,null,null,null,null,null,null,null,{"$f":"$D$11","v":"Malt:"},{"$f":"$E$11","v":"Pale Ale"}]
[]
[null,null,null,{"$f":"$D$13","v":"Humle:"},{"$f":"$E$13","v":"Cascade"},null,null,null,null,null,null,null,null,null,null,{"$f":"$D$13","v":"Humle:"},{"$f":"$E$13","v":"Cascade"}]
[]
[null,null,null,{"$f":"$D$15","v":"Gær:"},{"$f":"$E$15","v":"Mangrove Jack's California Lager M54, og New World Strong Ale M42"},null,null,null,null,null,null,null,null,null,null,{"$f":"$D$15","v":"Gær:"},{"$f":"$E$15","v":"Mangrove Jack's California Lager M54, og New World Strong Ale M42"}]
[]
[null,null,null,{"$f":"$D$17","v":"Tilsætning:"},{"$f":"$E$17","v":"Rørsukker"},null,null,null,null,null,null,null,null,null,null,{"$f":"$D$17","v":"Tilsætning:"},{"$f":"$E$17","v":"Rørsukker"}]
[]
[null,null,null,{"$f":"$D$19","v":"Alc. Vol.:"},{"$f":"$E$19","v":""},null,{"$f":"$G$19","v":"EBC:"},{"$f":"$H$19","v":10},{"$f":"$I$19","v":"IBU:"},{"$f":"$J$19","v":23.730840000000001},null,null,null,null,null,{"$f":"$D$19","v":"Alc. Vol.:"},{"$f":"$E$19","v":""},null,{"$f":"$G$19","v":"EBC:"},{"$f":"$H$19","v":10},{"$f":"$I$19","v":"IBU:"},{"$f":"$J$19","v":23.730840000000001}]
[]
[null,null,null,{"$f":"$D$21","v":"Brygget af:"},{"$f":"$E$21","v":"André"},null,{"$f":"$G$21","v":"Indhold: 0,5 liter; svarer til 1,9 genstande"},null,null,null,null,null,null,null,null,{"$f":"$D$21","v":"Brygget af:"},{"$f":"$E$21","v":"André"},null,{"$f":"$G$21","v":"Indhold: 0,5 liter; svarer til 1,9 genstande"}]
[]
[]
[null,{"$f":"$B$3","v":"eyeT Brewery"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"$B$3","v":"eyeT Brewery"}]
[]
[]
[null,null,null,{"$f":"$D$6","v":"Cream Ale"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"$D$6","v":"Cream Ale"}]
[]
[]
[null,null,null,"Brygget:",{"$f":"$E$9","v":""},null,"Tappet:",{"$f":"$H$9","v":""},{"$f":"$I$9","v":"Bryg #"},{"$f":"$J$9","v":73},null,null,null,null,null,"Brygget:",{"$f":"$E$9","v":""},null,"Tappet:",{"$f":"$H$9","v":""},{"$f":"$I$9","v":"Bryg #"},{"$f":"$J$9","v":73}]
[]
[null,null,null,{"$f":"$D$11","v":"Malt:"},{"$f":"$E$11","v":"Pale Ale"},null,null,null,null,null,null,null,null,null,null,{"$f":"$D$11","v":"Malt:"},{"$f":"$E$11","v":"Pale Ale"}]
[]
[null,null,null,{"$f":"$D$13","v":"Humle:"},{"$f":"$E$13","v":"Cascade"},null,null,null,null,null,null,null,null,null,null,{"$f":"$D$13","v":"Humle:"},{"$f":"$E$13","v":"Cascade"}]
[]
[null,null,null,{"$f":"$D$15","v":"Gær:"},{"$f":"$E$15","v":"Mangrove Jack's California Lager M54, og New World Strong Ale M42"},null,null,null,null,null,null,null,null,null,null,{"$f":"$D$15","v":"Gær:"},{"$f":"$E$15","v":"Mangrove Jack's California Lager M54, og New World Strong Ale M42"}]
[]
[null,null,null,{"$f":"$D$17","v":"Tilsætning:"},{"$f":"$E$17","v":"Rørsukker"},null,null,null,null,null,null,null,null,null,null,{"$f":"$D$17","v":"Tilsætning:"},{"$f":"$E$17","v":"Rørsukker"}]
[]
[null,null,null,{"$f":"$D$19","v":"Alc. Vol.:"},{"$f":"$E$19","v":""},null,{"$f":"$G$19","v":"EBC:"},{"$f":"$H$19","v":10},{"$f":"$I$19","v":"IBU:"},{"$f":"$J$19","v":23.730840000000001},null,null,null,null,null,{"$f":"$D$19","v":"Alc. Vol.:"},{"$f":"$E$19","v":""},null,{"$f":"$G$19","v":"EBC:"},{"$f":"$H$19","v":10},{"$f":"$I$19","v":"IBU:"},{"$f":"$J$19","v":23.730840000000001}]
[]
[null,null,null,{"$f":"$D$21","v":"Brygget af:"},{"$f":"$E$21","v":"André"},null,{"$f":"$G$21","v":"Indhold: 0,5 liter; svarer til 1,9 genstande"},null,null,null,null,null,null,null,null,{"$f":"$D$21","v":"Brygget af:"},{"$f":"$E$21","v":"André"},null,{"$f":"$G$21","v":"Indhold: 0,5 liter; svarer til 1,9 genstande"}]
[]
[]
[null,{"$f":"$B$3","v":"eyeT Brewery"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"$B$3","v":"eyeT Brewery"}]
[]
[]
[null,null,null,{"$f":"$D$6","v":"Cream Ale"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"$D$6","v":"Cream Ale"}]
[]
[]
[null,null,null,"Brygget:",{"$f":"$E$9","v":""},null,"Tappet:",{"$f":"$H$9","v":""},{"$f":"$I$9","v":"Bryg #"},{"$f":"$J$9","v":73},null,null,null,null,null,"Brygget:",{"$f":"$E$9","v":""},null,"Tappet:",{"$f":"$H$9","v":""},{"$f":"$I$9","v":"Bryg #"},{"$f":"$J$9","v":73}]
[]
[null,null,null,{"$f":"$D$11","v":"Malt:"},{"$f":"$E$11","v":"Pale Ale"},null,null,null,null,null,null,null,null,null,null,{"$f":"$D$11","v":"Malt:"},{"$f":"$E$11","v":"Pale Ale"}]
[]
[null,null,null,{"$f":"$D$13","v":"Humle:"},{"$f":"$E$13","v":"Cascade"},null,null,null,null,null,null,null,null,null,null,{"$f":"$D$13","v":"Humle:"},{"$f":"$E$13","v":"Cascade"}]
[]
[null,null,null,{"$f":"$D$15","v":"Gær:"},{"$f":"$E$15","v":"Mangrove Jack's California Lager M54, og New World Strong Ale M42"},null,null,null,null,null,null,null,null,null,null,{"$f":"$D$15","v":"Gær:"},{"$f":"$E$15","v":"Mangrove Jack's California Lager M54, og New World Strong Ale M42"}]
[]
[null,null,null,{"$f":"$D$17","v":"Tilsætning:"},{"$f":"$E$17","v":"Rørsukker"},null,null,null,null,null,null,null,null,null,null,{"$f":"$D$17","v":"Tilsætning:"},{"$f":"$E$17","v":"Rørsukker"}]
[]
[null,null,null,{"$f":"$D$19","v":"Alc. Vol.:"},{"$f":"$E$19","v":""},null,{"$f":"$G$19","v":"EBC:"},{"$f":"$H$19","v":10},{"$f":"$I$19","v":"IBU:"},{"$f":"$J$19","v":23.730840000000001},null,null,null,null,null,{"$f":"$D$19","v":"Alc. Vol.:"},{"$f":"$E$19","v":""},null,{"$f":"$G$19","v":"EBC:"},{"$f":"$H$19","v":10},{"$f":"$I$19","v":"IBU:"},{"$f":"$J$19","v":23.730840000000001}]
[]
[null,null,null,{"$f":"$D$21","v":"Brygget af:"},{"$f":"$E$21","v":"André"},null,{"$f":"$G$21","v":"Indhold: 0,5 liter; svarer til 1,9 genstande"},null,null,null,null,null,null,null,null,{"$f":"$D$21","v":"Brygget af:"},{"$f":"$E$21","v":"André"},null,{"$f":"$G$21","v":"Indhold: 0,5 liter; svarer til 1,9 genstande"}]

{"sheet":"Data","index":2,"n_rows":333,"n_cols":13,"rows_kept":333,"cut":false,"hidden":false,"merged":[[0,0,0,5],[33,4,33,5],[32,4,32,5],[53,2,53,4],[1,1,1,5],[2,1,2,5],[5,2,5,5],[4,2,4,5],[3,2,3,5],[15,8,15,10],[20,8,20,10],[19,8,19,10],[18,8,18,10],[26,2,26,3],[17,8,17,10],[16,8,16,10],[21,8,21,10],[22,8,22,10],[55,1,55,5],[29,0,29,1],[31,7,32,7],[30,7,30,10],[23,8,23,10],[31,10,32,10],[31,9,32,9],[31,8,32,8],[28,8,28,10],[29,2,29,3],[27,8,27,10],[26,8,26,10],[25,8,25,10],[24,8,24,10]]}
["STAMDATA"]
["Bryggeri","eyeT Brewery"]
["Brygmester","André"]
["Mæskeeffektivitet",0.75,"Anvendes til at estimere Original Gravity"]
["Urtmængde i liter",25,"Anvendes til at beregne Effektivitet og Original Gravity"]
["Flaskestørrelse i liter",0.5,"Anvendes til at beregne og vise antal genstande"]
[]
["Beregninger","Malt","%","EBC","Ekstraktudbytte","OG"]
[null,{"$f":"IF(BrewReport!A9=\"\",\"\",BrewReport!A9)","v":"Pale Ale"},{"$f":"IF(B9=\"\",\"\",ROUND(((BrewReport!C9/BrewReport!$C$19)*100),1))","v":100},{"$f":"IF(B9=\"\",\"\",IF(BrewReport!C9=\"\",\"\",ROUND((VLOOKUP(B9,Malt!$A$3:$D$75,3,)*(Data!C9/100)),1)))","v":8},{"$f":"IF(B9=\"\",\"\",(VLOOKUP(B9,Malt!$A$2:$D$75,4,)*C9/100))","v":300},"|"]
[null,{"$f":"IF(BrewReport!A10=\"\",\"\",BrewReport!A10)","v":""},{"$f":"IF(B10=\"\",\"\",ROUND(((BrewReport!C10/BrewReport!$C$19)*100),1))","v":""},{"$f":"IF(B10=\"\",\"\",IF(BrewReport!C10=\"\",\"\",ROUND((VLOOKUP(B10,Malt!$A$3:$D$75,3,)*(Data!C10/100)),1)))","v":""},{"$f":"IF(B10=\"\",\"\",(VLOOKUP(B10,Malt!$A$2:$D$75,4,)*C10/100))","v":""},"|"]
[null,{"$f":"IF(BrewReport!A11=\"\",\"\",BrewReport!A11)","v":""},{"$f":"IF(B11=\"\",\"\",ROUND(((BrewReport!C11/BrewReport!$C$19)*100),1))","v":""},{"$f":"IF(B11=\"\",\"\",IF(BrewReport!C11=\"\",\"\",ROUND((VLOOKUP(B11,Malt!$A$3:$D$75,3,)*(Data!C11/100)),1)))","v":""},{"$f":"IF(B11=\"\",\"\",(VLOOKUP(B11,Malt!$A$2:$D$75,4,)*C11/100))","v":""},"|"]
[null,{"$f":"IF(BrewReport!A12=\"\",\"\",BrewReport!A12)","v":""},{"$f":"IF(B12=\"\",\"\",ROUND(((BrewReport!C12/BrewReport!$C$19)*100),1))","v":""},{"$f":"IF(B12=\"\",\"\",IF(BrewReport!C12=\"\",\"\",ROUND((VLOOKUP(B12,Malt!$A$3:$D$75,3,)*(Data!C12/100)),1)))","v":""},{"$f":"IF(B12=\"\",\"\",(VLOOKUP(B12,Malt!$A$2:$D$75,4,)*C12/100))","v":""},"|"]
[null,{"$f":"IF(BrewReport!A13=\"\",\"\",BrewReport!A13)","v":""},{"$f":"IF(B13=\"\",\"\",ROUND(((BrewReport!C13/BrewReport!$C$19)*100),1))","v":""},{"$f":"IF(B13=\"\",\"\",IF(BrewReport!C13=\"\",\"\",ROUND((VLOOKUP(B13,Malt!$A$3:$D$75,3,)*(Data!C13/100)),1)))","v":""},{"$f":"IF(B13=\"\",\"\",(VLOOKUP(B13,Malt!$A$2:$D$75,4,)*C13/100))","v":""},"|"]
["Estimeret effektivitet",{"$f":"IF(BrewReport!A14=\"\",\"\",BrewReport!A14)","v":""},{"$f":"IF(B14=\"\",\"\",ROUND(((BrewReport!C14/BrewReport!$C$19)*100),1))","v":""},{"$f":"IF(B14=\"\",\"\",IF(BrewReport!C14=\"\",\"\",ROUND((VLOOKUP(B14,Malt!$A$3:$D$75,3,)*(Data!C14/100)),1)))","v":""},{"$f":"IF(B14=\"\",\"\",(VLOOKUP(B14,Malt!$A$2:$D$75,4,)*C14/100))","v":""},"|"]
[{"$f":"IF(BrewReport!C19=0,\"\",((F26-1000)*B5)/(BrewReport!C19*E26))","v":0.74940047961630685},{"$f":"IF(BrewReport!A15=\"\",\"\",BrewReport!A15)","v":""},{"$f":"IF(B15=\"\",\"\",ROUND(((BrewReport!C15/BrewReport!$C$19)*100),1))","v":""},{"$f":"IF(B15=\"\",\"\",IF(BrewReport!C15=\"\",\"\",ROUND((VLOOKUP(B15,Malt!$A$3:$D$75,3,)*(Data!C15/100)),1)))","v":""},{"$f":"IF(B15=\"\",\"\",(VLOOKUP(B15,Malt!$A$2:$D$75,4,)*C15/100))","v":""},"|"]
[null,{"$f":"IF(BrewReport!A16=\"\",\"\",BrewReport!A16)","v":""},{"$f":"IF(B16=\"\",\"\",ROUND(((BrewReport!C16/BrewReport!$C$19)*100),1))","v":""},{"$f":"IF(B16=\"\",\"\",IF(BrewReport!C16=\"\",\"\",ROUND((VLOOKUP(B16,Malt!$A$3:$D$75,3,)*(Data!C16/100)),1)))","v":""},{"$f":"IF(B16=\"\",\"\",(VLOOKUP(B16,Malt!$A$2:$D$75,4,)*C16/100))","v":""},"|",null,"EBC","Example",null,null,"Beer color","SRM"]
[null,{"$f":"IF(BrewReport!A17=\"\",\"\",BrewReport!A17)","v":""},{"$f":"IF(B17=\"\",\"\",ROUND(((BrewReport!C17/BrewReport!$C$19)*100),1))","v":""},{"$f":"IF(B17=\"\",\"\",IF(BrewReport!C17=\"\",\"\",ROUND((VLOOKUP(B17,Malt!$A$3:$D$75,3,)*(Data!C17/100)),1)))","v":""},{"$f":"IF(B17=\"\",\"\",(VLOOKUP(B17,Malt!$A$2:$D$75,4,)*C17/100))","v":""},"|",null,4,"Pale lager, Witbier, Pilsener, Berliner Weisse",null,null,null,2]
[null,{"$f":"IF(BrewReport!A18=\"\",\"\",BrewReport!A18)","v":""},{"$f":"IF(B18=\"\",\"\",ROUND(((BrewReport!C18/BrewReport!$C$19)*100),1))","v":""},{"$f":"IF(B18=\"\",\"\",IF(BrewReport!C18=\"\",\"\",ROUND((VLOOKUP(B18,Malt!$A$3:$D$75,3,)*(Data!C18/100)),1)))","v":""},{"$f":"IF(B18=\"\",\"\",(VLOOKUP(B18,Malt!$A$2:$D$75,4,)*C18/100))","v":""},"|",null,6,"Maibock, Blonde Ale",null,null,null,3]
[null,null,null,null,null,"|",null,8,"Weissbier",null,null,null,4]
[null,{"$f":"IF(OR((BrewReport!A36=\"Klar Urt\"),(BrewReport!A36=\"Appelsinskal\"),(BrewReport!A36=\"Koriander\"),(BrewReport!A36=\"\")),\"\",BrewReport!A36)","v":"Rørsukker"},{"$f":"IF(B20=\"\",\"\",ROUND((((BrewReport!C36/1000)/BrewReport!$C$19)*100),1))","v":8},{"$f":"IF(B20=\"\",\"\",IF(BrewReport!C36=\"\",\"\",ROUND((VLOOKUP(B20,Tilsætninger!$A$2:$D$17,3,)*(Data!C20/100)),1)))","v":2},{"$f":"IF(B20=\"\",\"\",(VLOOKUP(B20,Tilsætninger!$A$2:$D$17,4,)*C20/100))","v":33.6},"|",null,12,"American Pale Ale, India Pale Ale",null,null,null,6]
[null,{"$f":"IF(OR((BrewReport!A37=\"Klar Urt\"),(BrewReport!A37=\"Appelsinskal\"),(BrewReport!A37=\"Koriander\"),(BrewReport!A37=\"\")),\"\",BrewReport!A37)","v":""},{"$f":"IF(B21=\"\",\"\",ROUND((((BrewReport!C37/1000)/BrewReport!$C$19)*100),1))","v":""},{"$f":"IF(B21=\"\",\"\",IF(BrewReport!C37=\"\",\"\",ROUND((VLOOKUP(B21,Tilsætninger!$A$2:$D$17,3,)*(Data!C21/100)),1)))","v":""},{"$f":"IF(B21=\"\",\"\",(VLOOKUP(B21,Tilsætninger!$A$2:$D$17,4,)*C21/100))","v":""},"|",null,16,"Weissbier, Saison",null,null,null,8]
[null,{"$f":"IF(OR((BrewReport!A38=\"Klar Urt\"),(BrewReport!A38=\"Appelsinskal\"),(BrewReport!A38=\"Koriander\"),(BrewReport!A38=\"\")),\"\",BrewReport!A38)","v":""},{"$f":"IF(B22=\"\",\"\",ROUND((((BrewReport!C38/1000)/BrewReport!$C$19)*100),1))","v":""},{"$f":"IF(B22=\"\",\"\",IF(BrewReport!C38=\"\",\"\",ROUND((VLOOKUP(B22,Tilsætninger!$A$2:$D$17,3,)*(Data!C22/100)),1)))","v":""},{"$f":"IF(B22=\"\",\"\",(VLOOKUP(B22,Tilsætninger!$A$2:$D$17,4,)*C22/100))","v":""},"|",null,20,"English Bitter, ESB",null,null,null,10]
["Faktisk effektivitet",{"$f":"IF(OR((BrewReport!A39=\"Klar Urt\"),(BrewReport!A39=\"Appelsinskal\"),(BrewReport!A39=\"Koriander\"),(BrewReport!A39=\"\")),\"\",BrewReport!A39)","v":""},{"$f":"IF(B23=\"\",\"\",ROUND((((BrewReport!C39/1000)/BrewReport!$C$19)*100),1))","v":""},{"$f":"IF(B23=\"\",\"\",IF(BrewReport!C39=\"\",\"\",ROUND((VLOOKUP(B23,Tilsætninger!$A$2:$D$17,3,)*(Data!C23/100)),1)))","v":""},{"$f":"IF(B23=\"\",\"\",(VLOOKUP(B23,Tilsætninger!$A$2:$D$17,4,)*C23/100))","v":""},"|",null,26,"Biere de Garde, Double IPA",null,null,null,13]
[{"$f":"IF(BrewReport!$C$19=0,\"\",((BrewReport!$C$49-1000)*BrewReport!$C$45)/(BrewReport!$C$19*$E$26))","v":0},{"$f":"IF(OR((BrewReport!A40=\"Klar Urt\"),(BrewReport!A40=\"Appelsinskal\"),(BrewReport!A40=\"Koriander\"),(BrewReport!A40=\"\")),\"\",BrewReport!A40)","v":""},{"$f":"IF(B24=\"\",\"\",ROUND((((BrewReport!C40/1000)/BrewReport!$C$19)*100),1))","v":""},{"$f":"IF(B24=\"\",\"\",IF(BrewReport!C40=\"\",\"\",ROUND((VLOOKUP(B24,Tilsætninger!$A$2:$D$17,3,)*(Data!C24/100)),1)))","v":""},{"$f":"IF(B24=\"\",\"\",(VLOOKUP(B24,Tilsætninger!$A$2:$D$17,4,)*C24/100))","v":""},"|",null,33,"Dark lager, Vienna lager, Marzen, Amber Ale",null,null,null,17]
[{"$f":"IF(BrewReport!$C$19=0,\"\",((BrewReport!$C$50-1000)*BrewReport!$C$45)/(BrewReport!$C$19*$E$26))","v":0},{"$f":"IF(OR((BrewReport!A41=\"Klar Urt\"),(BrewReport!A41=\"Appelsinskal\"),(BrewReport!A41=\"Koriander\"),(BrewReport!A41=\"\")),\"\",BrewReport!A41)","v":""},{"$f":"IF(B25=\"\",\"\",ROUND((((BrewReport!C41/1000)/BrewReport!$C$19)*100),1))","v":""},{"$f":"IF(B25=\"\",\"\",IF(BrewReport!C41=\"\",\"\",ROUND((VLOOKUP(B25,Tilsætninger!$A$2:$D$17,3,)*(Data!C25/100)),1)))","v":""},{"$f":"IF(B25=\"\",\"\",(VLOOKUP(B25,Tilsætninger!$A$2:$D$17,4,)*C25/100))","v":""},"|",null,39,"Brown Ale, Bock, Dunkel, Dunkelweizen",null,null,null,20]
[null,null,{"$f":"ROUND(SUM(C9:C14),0)","v":100},{"$f":"ROUND(SUM(D9:D25),1)","v":10},{"$f":"ROUND(SUM(E9:E25),1)","v":333.6},{"$f":"ROUND(((BrewReport!C19*E26*(B4))/B5),0)+1000","v":1055},null,47,"Irish Dry Stout, Doppelbock, Porter",null,null,null,24]
["Gær navn og nummer",null,"Alc.Tolerance %",null,"Attenuation %","ALC.%",null,57,"Stout",null,null,null,29]
[null,null,null,null,null,null,null,69,"Foreign Stout, Baltic Porter",null,null,null,35]
[null,null,null,null,null,null,null,79,"Imperial Stout",null,null,null,"40+"]
[{"$f":"IF(BrewReport!I50=\"\",\"\",BrewReport!I50)","v":"Mangrove Jack´s New World Strong Ale M42"},null,{"$f":"IF(A30=\"\",\"\",(VLOOKUP(A30,Gær!A2:G65,7,FALSE)))","v":0},null,{"$f":"IF(A30=\"\",\"\",(VLOOKUP(A30,Gær!A2:G65,5,FALSE)))","v":79},{"$f":"IF(A30=\"\",\"\",((F26-E32)/7.5))","v":5.7333333333333334}]
[null,null,null,null,null,null,null,"This is EBC to RGB"]
[null,null,null,"FG:",{"$f":"IF(E30=\"\",\"\",ROUND((F26-((F26-1000)*(E30/100))),0))","v":1012},null,null,null,{"$f":"IF(D26=0,\"\",VLOOKUP(D26, H34:K333,2,TRUE))","v":224},{"$f":"IF(D26=0,\"\",VLOOKUP(D26, H34:K333,3,TRUE))","v":206},{"$f":"IF(D26=0,\"\",VLOOKUP(D26, H34:K333,4,TRUE))","v":50},null,"This is SRM to RGB"]
[null,null,null,null,"Flaskeindhold"]
[null,null,null,null,"Svarer til i genstande:",null,null,0.2,250,250,210,null,"0,1 250 250 210"]
[null,null,null,null,"Estimat",{"$f":"IF(F30=\"\",\"\",ROUND((((B6*1000)*0.79*(F30/100))/12),1))","v":1.9},null,0.4,250,250,204,null,"0,2 250 250 204"]
[null,null,null,null,"Brygget",{"$f":"IF(BrewReport!C54=\"\",\"\",ROUND((((B6*1000)*0.79*(BrewReport!C54/100))/12),1))","v":""},null,0.6,250,250,199,null,"0,3 250 250 199"]
[null,null,null,null,null,null,null,0.8,250,250,193,null,"0,4 250 250 193"]
[null,null,null,null,null,null,null,1,250,250,188,null,"0,5 250 250 188"]
[null,null,null,null,null,null,null,1.2,250,250,182,null,"0,6 250 250 182"]
[null,"Humle","Gram","IBU Avg.","Udnyttelsesgrad","IBU i urten",null,1.4,250,250,177,null,"0,7 250 250 177"]
[null,{"$f":"IF(BrewReport!A23=\"\",\"\",BrewReport!A23)","v":"Cascade"},{"$f":"IF(BrewReport!C23=\"\",\"\",BrewReport!C23)","v":37},{"$f":"IF(B41=\"\",\"\",VLOOKUP(B41,Humle!$A$3:$I$34,4,FALSE))","v":6.3},{"$f":"IF(B41=\"\",\"\",VLOOKUP(BrewReport!$I23,Humle!$M$7:$X$32,((ROUNDDOWN(($F$26/10),0)*10)-1000)/10-1,TRUE)*100)","v":23.1},{"$f":"IF(B41=\"\",\"\",IF(BrewReport!I23=\"\",\"\",(C41*D41*E41)/($B$5*10)))","v":21.538440000000001},null,1.6,250,250,171,null,"0,8 250 250 171"]
[null,{"$f":"IF(BrewReport!A24=\"\",\"\",BrewReport!A24)","v":""},{"$f":"IF(BrewReport!C24=\"\",\"\",BrewReport!C24)","v":""},{"$f":"IF(B42=\"\",\"\",VLOOKUP(B42,Humle!$A$3:$I$34,4,FALSE))","v":""},{"$f":"IF(B42=\"\",\"\",VLOOKUP(BrewReport!$I24,Humle!$M$7:$X$32,((ROUNDDOWN(($F$26/10),0)*10)-1000)/10-1,TRUE)*100)","v":""},{"$f":"IF(B42=\"\",\"\",IF(BrewReport!I24=\"\",\"\",(C42*D42*E42)/($B$5*10)))","v":""},null,1.8,250,250,166,null,"0,9 250 250 166"]
[null,{"$f":"IF(BrewReport!A25=\"\",\"\",BrewReport!A25)","v":""},{"$f":"IF(BrewReport!C25=\"\",\"\",BrewReport!C25)","v":""},{"$f":"IF(B43=\"\",\"\",VLOOKUP(B43,Humle!$A$3:$I$34,4,FALSE))","v":""},{"$f":"IF(B43=\"\",\"\",VLOOKUP(BrewReport!$I25,Humle!$M$7:$X$32,((ROUNDDOWN(($F$26/10),0)*10)-1000)/10-1,TRUE)*100)","v":""},{"$f":"IF(B43=\"\",\"\",IF(BrewReport!I25=\"\",\"\",(C43*D43*E43)/($B$5*10)))","v":""},null,2,250,250,160,null,"1 250 250 160"]
[null,null,null,null,null,"-",null,2.2000000000000002,250,250,155,null,"1,1 250 250 155"]
[null,{"$f":"IF(BrewReport!A27=\"\",\"\",BrewReport!A27)","v":""},{"$f":"IF(BrewReport!C27=\"\",\"\",BrewReport!C27)","v":""},{"$f":"IF(B45=\"\",\"\",VLOOKUP(B45,Humle!$A$3:$I$34,4,FALSE))","v":""},{"$f":"IF(B45=\"\",\"\",VLOOKUP(BrewReport!$I27,Humle!$M$7:$X$32,((ROUNDDOWN(($F$26/10),0)*10)-1000)/10-1,TRUE)*100)","v":""},{"$f":"IF(B45=\"\",\"\",IF(BrewReport!I27=\"\",\"\",(C45*D45*E45)/($B$5*10)))","v":""},null,2.4,250,250,149,null,"1,2 250 250 149"]
[null,{"$f":"IF(BrewReport!A28=\"\",\"\",BrewReport!A28)","v":""},{"$f":"IF(BrewReport!C28=\"\",\"\",BrewReport!C28)","v":""},{"$f":"IF(B46=\"\",\"\",VLOOKUP(B46,Humle!$A$3:$I$34,4,FALSE))","v":""},{"$f":"IF(B46=\"\",\"\",VLOOKUP(BrewReport!$I28,Humle!$M$7:$X$32,((ROUNDDOWN(($F$26/10),0)*10)-1000)/10-1,TRUE)*100)","v":""},{"$f":"IF(B46=\"\",\"\",IF(BrewReport!I28=\"\",\"\",(C46*D46*E46)/($B$5*10)))","v":""},null,2.6,250,250,144,null,"1,3 250 250 144"]
[null,{"$f":"IF(BrewReport!A29=\"\",\"\",BrewReport!A29)","v":""},{"$f":"IF(BrewReport!C29=\"\",\"\",BrewReport!C29)","v":""},{"$f":"IF(B47=\"\",\"\",VLOOKUP(B47,Humle!$A$3:$I$34,4,FALSE))","v":""},{"$f":"IF(B47=\"\",\"\",VLOOKUP(BrewReport!$I29,Humle!$M$7:$X$32,((ROUNDDOWN(($F$26/10),0)*10)-1000)/10-1,TRUE)*100)","v":""},{"$f":"IF(B47=\"\",\"\",IF(BrewReport!I29=\"\",\"\",(C47*D47*E47)/($B$5*10)))","v":""},null,2.8,250,250,138,null,"1,4 250 250 138"]
[null,null,null,null,null,"-",null,3,250,250,133,null,"1,5 250 250 133"]
[null,{"$f":"IF(BrewReport!A31=\"\",\"\",BrewReport!A31)","v":"Cascade"},{"$f":"IF(BrewReport!C31=\"\",\"\",BrewReport!C31)","v":30},{"$f":"IF(B49=\"\",\"\",VLOOKUP(B49,Humle!$A$3:$I$34,4,FALSE))","v":6.3},{"$f":"IF(B49=\"\",\"\",VLOOKUP(BrewReport!$I31,Humle!$M$7:$X$32,((ROUNDDOWN(($F$26/10),0)*10)-1000)/10-1,TRUE)*100)","v":2.9000000000000004},{"$f":"IF(B49=\"\",\"\",IF(BrewReport!I31=\"\",\"\",(C49*D49*E49)/($B$5*10)))","v":2.1924000000000001},null,3.2,250,250,127,null,"1,6 250 250 127"]
[null,{"$f":"IF(BrewReport!A32=\"\",\"\",BrewReport!A32)","v":""},{"$f":"IF(BrewReport!C32=\"\",\"\",BrewReport!C32)","v":""},{"$f":"IF(B50=\"\",\"\",VLOOKUP(B50,Humle!$A$3:$I$34,4,FALSE))","v":""},{"$f":"IF(B50=\"\",\"\",VLOOKUP(BrewReport!$I32,Humle!$M$7:$X$32,((ROUNDDOWN(($F$26/10),0)*10)-1000)/10-1,TRUE)*100)","v":""},{"$f":"IF(B50=\"\",\"\",IF(BrewReport!I32=\"\",\"\",(C50*D50*E50)/($B$5*10)))","v":""},null,3.3,250,250,122,null,"1,7 250 250 122"]
[null,{"$f":"IF(BrewReport!A33=\"\",\"\",BrewReport!A33)","v":""},{"$f":"IF(BrewReport!C33=\"\",\"\",BrewReport!C33)","v":""},{"$f":"IF(B51=\"\",\"\",VLOOKUP(B51,Humle!$A$3:$I$34,4,FALSE))","v":""},{"$f":"IF(B51=\"\",\"\",VLOOKUP(BrewReport!$I33,Humle!$M$7:$X$32,((ROUNDDOWN(($F$26/10),0)*10)-1000)/10-1,TRUE)*100)","v":""},{"$f":"IF(B51=\"\",\"\",IF(BrewReport!I33=\"\",\"\",(C51*D51*E51)/($B$5*10)))","v":""},null,3.5,250,250,116,null,"1,8 250 250 116"]
[null,{"$f":"IF(BrewReport!A34=\"\",\"\",BrewReport!A34)","v":"Andet"},null,null,null,"-",null,3.7,250,250,111,null,"1,9 250 250 111"]
[null,null,null,null,null,null,null,3.9,250,250,105,null,"2 250 250 105"]
[null,null,"Total IBU:",null,null,{"$f":"SUM(F41:F52)","v":23.730840000000001},null,4.0999999999999996,250,250,100,null,"2,1 250 250 100"]
[null,null,null,null,null,null,null,4.3,250,250,94,null,"2,2 250 250 94"]
["BU:GU and RBR:","http://www.madalchemist.com/chart_bitterness_corrected.html",null,null,null,null,null,4.5,250,250,89,null,"2,3 250 250 89"]
[null,null,null,null,null,null,null,4.7,250,250,83,null,"2,4 250 250 83"]
[null,null,null,null,null,null,null,4.9000000000000004,250,250,78,null,"2,5 250 250 78"]
[null,null,null,null,null,null,null,5.0999999999999996,249,250,72,null,"2,6 249 250 72"]
[null,null,null,null,null,null,null,5.3,248,249,67,null,"2,7 248 249 67"]
[null,null,null,null,null,null,null,5.5,247,248,61,null,"2,8 247 248 61"]
[null,null,null,null,null,null,null,5.7,246,247,56,null,"2,9 246 247 56"]
[null,null,null,null,null,null,null,5.9,245,246,50,null,"3 245 246 50"]
[null,null,null,null,null,null,null,6.1,244,245,45,null,"3,1 244 245 45"]
[null,null,null,null,null,null,null,6.3,243,244,45,null,"3,2 243 244 45"]
[null,null,null,null,null,null,null,6.5,242,242,45,null,"3,3 242 242 45"]
[null,null,null,null,null,null,null,6.7,241,240,46,null,"3,4 241 240 46"]
[null,null,null,null,null,null,null,6.9,240,238,46,null,"3,5 240 238 46"]
[null,null,null,null,null,null,null,7.1,239,236,46,null,"3,6 239 236 46"]
[null,null,null,null,null,null,null,7.3,238,234,46,null,"3,7 238 234 46"]
[null,null,null,null,null,null,null,7.5,237,232,47,null,"3,8 237 232 47"]
[null,null,null,null,null,null,null,7.7,236,230,47,null,"3,9 236 230 47"]
[null,null,null,null,null,null,null,7.9,235,228,47,null,"4 235 228 47"]
[null,null,null,null,null,null,null,8.1,234,226,47,null,"4,1 234 226 47"]
[null,null,null,null,null,null,null,8.3000000000000007,233,224,48,null,"4,2 233 224 48"]
[null,null,null,null,null,null,null,8.5,232,222,48,null,"4,3 232 222 48"]
[null,null,null,null,null,null,null,8.6999999999999993,231,220,48,null,"4,4 231 220 48"]
[null,null,null,null,null,null,null,8.9,230,218,48,null,"4,5 230 218 48"]
[null,null,null,null,null,null,null,9.1,229,216,49,null,"4,6 229 216 49"]
[null,null,null,null,null,null,null,9.3000000000000007,228,214,49,null,"4,7 228 214 49"]
[null,null,null,null,null,null,null,9.5,227,212,49,null,"4,8 227 212 49"]
[null,null,null,null,null,null,null,9.6999999999999993,226,210,49,null,"4,9 226 210 49"]
[null,null,null,null,null,null,null,9.9,225,208,50,null,"5 225 208 50"]
[null,null,null,null,null,null,null,10,224,206,50,null,"5,1 224 206 50"]
[null,null,null,null,null,null,null,10.199999999999999,223,204,50,null,"5,2 223 204 50"]
[null,null,null,null,null,null,null,10.4,222,202,50,null,"5,3 222 202 50"]
[null,null,null,null,null,null,null,10.6,221,200,51,null,"5,4 221 200 51"]
[null,null,null,null,null,null,null,10.8,220,198,51,null,"5,5 220 198 51"]
[null,null,null,null,null,null,null,11,219,196,51,null,"5,6 219 196 51"]
[null,null,null,null,null,null,null,11.2,218,194,51,null,"5,7 218 194 51"]
[null,null,null,null,null,null,null,11.4,217,192,52,null,"5,8 217 192 52"]
[null,null,null,null,null,null,null,11.6,216,190,52,null,"5,9 216 190 52"]
[null,null,null,null,null,null,null,11.8,215,188,52,null,"6 215 188 52"]
[null,null,null,null,null,null,null,12,214,186,52,null,"6,1 214 186 52"]
[null,null,null,null,null,null,null,12.2,213,184,53,null,"6,2 213 184 53"]
[null,null,null,null,null,null,null,12.4,212,182,53,null,"6,3 212 182 53"]
[null,null,null,null,null,null,null,12.6,211,180,53,null,"6,4 211 180 53"]
[null,null,null,null,null,null,null,12.8,210,178,53,null,"6,5 210 178 53"]
[null,null,null,null,null,null,null,13,209,176,54,null,"6,6 209 176 54"]
[null,null,null,null,null,null,null,13.2,208,174,54,null,"6,7 208 174 54"]
[null,null,null,null,null,null,null,13.4,207,172,54,null,"6,8 207 172 54"]
[null,null,null,null,null,null,null,13.6,206,170,54,null,"6,9 206 170 54"]
[null,null,null,null,null,null,null,13.8,205,168,55,null,"7 205 168 55"]
[null,null,null,null,null,null,null,14,204,166,55,null,"7,1 204 166 55"]
[null,null,null,null,null,null,null,14.2,203,164,55,null,"7,2 203 164 55"]
[null,null,null,null,null,null,null,14.4,202,162,55,null,"7,3 202 162 55"]
[null,null,null,null,null,null,null,14.6,201,160,56,null,"7,4 201 160 56"]
[null,null,null,null,null,null,null,14.8,200,158,56,null,"7,5 200 158 56"]
[null,null,null,null,null,null,null,15,200,156,56,null,"7,6 200 156 56"]
[null,null,null,null,null,null,null,15.2,199,154,56,null,"7,7 199 154 56"]
[null,null,null,null,null,null,null,15.4,199,152,56,null,"7,8 199 152 56"]
[null,null,null,null,null,null,null,15.6,198,150,56,null,"7,9 198 150 56"]
[null,null,null,null,null,null,null,15.8,198,148,56,null,"8 198 148 56"]
[null,null,null,null,null,null,null,16,197,146,56,null,"8,1 197 146 56"]
[null,null,null,null,null,null,null,16.2,197,144,56,null,"8,2 197 144 56"]
[null,null,null,null,null,null,null,16.399999999999999,196,142,56,null,"8,3 196 142 56"]
[null,null,null,null,null,null,null,16.5,196,141,56,null,"8,4 196 141 56"]
[null,null,null,null,null,null,null,16.7,195,140,56,null,"8,5 195 140 56"]
[null,null,null,null,null,null,null,16.899999999999999,195,139,56,null,"8,6 195 139 56"]
[null,null,null,null,null,null,null,17.100000000000001,194,139,56,null,"8,7 194 139 56"]
[null,null,null,null,null,null,null,17.3,194,138,56,null,"8,8 194 138 56"]
[null,null,null,null,null,null,null,17.5,193,137,56,null,"8,9 193 137 56"]
[null,null,null,null,null,null,null,17.7,193,136,56,null,"9 193 136 56"]
[null,null,null,null,null,null,null,17.899999999999999,192,136,56,null,"9,1 192 136 56"]
[null,null,null,null,null,null,null,18.100000000000001,192,135,56,null,"9,2 192 135 56"]
[null,null,null,null,null,null,null,18.3,192,134,56,null,"9,3 192 134 56"]
[null,null,null,null,null,null,null,18.5,192,133,56,null,"9,4 192 133 56"]
[null,null,null,null,null,null,null,18.7,192,133,56,null,"9,5 192 133 56"]
[null,null,null,null,null,null,null,18.899999999999999,192,132,56,null,"9,6 192 132 56"]
[null,null,null,null,null,null,null,19.100000000000001,192,131,56,null,"9,7 192 131 56"]
[null,null,null,null,null,null,null,19.3,192,130,56,null,"9,8 192 130 56"]
[null,null,null,null,null,null,null,19.5,192,130,56,null,"9,9 192 130 56"]
[null,null,null,null,null,null,null,19.7,192,129,56,null,"10 192 129 56"]
[null,null,null,null,null,null,null,19.899999999999999,192,128,56,null,"10,1 192 128 56"]
[null,null,null,null,null,null,null,20.100000000000001,192,127,56,null,"10,2 192 127 56"]
[null,null,null,null,null,null,null,20.3,192,127,56,null,"10,3 192 127 56"]
[null,null,null,null,null,null,null,20.5,192,126,56,null,"10,4 192 126 56"]
[null,null,null,null,null,null,null,20.7,192,125,56,null,"10,5 192 125 56"]
[null,null,null,null,null,null,null,20.9,192,124,56,null,"10,6 192 124 56"]
[null,null,null,null,null,null,null,21.1,192,124,56,null,"10,7 192 124 56"]
[null,null,null,null,null,null,null,21.3,192,123,56,null,"10,8 192 123 56"]
[null,null,null,null,null,null,null,21.5,192,122,56,null,"10,9 192 122 56"]
[null,null,null,null,null,null,null,21.7,192,121,56,null,"11 192 121 56"]
[null,null,null,null,null,null,null,21.9,192,121,56,null,"11,1 192 121 56"]
[null,null,null,null,null,null,null,22.1,192,120,56,null,"11,2 192 120 56"]
[null,null,null,null,null,null,null,22.3,192,119,56,null,"11,3 192 119 56"]
[null,null,null,null,null,null,null,22.5,192,118,56,null,"11,4 192 118 56"]
[null,null,null,null,null,null,null,22.7,192,118,56,null,"11,5 192 118 56"]
[null,null,null,null,null,null,null,22.9,192,117,56,null,"11,6 192 117 56"]
[null,null,null,null,null,null,null,23,192,116,56,null,"11,7 192 116 56"]
[null,null,null,null,null,null,null,23.2,192,115,56,null,"11,8 192 115 56"]
[null,null,null,null,null,null,null,23.4,192,115,56,null,"11,9 192 115 56"]
[null,null,null,null,null,null,null,23.6,192,114,56,null,"12 192 114 56"]
[null,null,null,null,null,null,null,23.8,192,113,56,null,"12,1 192 113 56"]
[null,null,null,null,null,null,null,24,192,112,56,null,"12,2 192 112 56"]
[null,null,null,null,null,null,null,24.2,192,112,56,null,"12,3 192 112 56"]
[null,null,null,null,null,null,null,24.4,192,111,56,null,"12,4 192 111 56"]
[null,null,null,null,null,null,null,24.6,192,110,56,null,"12,5 192 110 56"]
[null,null,null,null,null,null,null,24.8,192,109,56,null,"12,6 192 109 56"]
[null,null,null,null,null,null,null,25,192,109,56,null,"12,7 192 109 56"]
[null,null,null,null,null,null,null,25.2,192,108,56,null,"12,8 192 108 56"]
[null,null,null,null,null,null,null,25.4,191,107,56,null,"12,9 191 107 56"]
[null,null,null,null,null,null,null,25.6,190,106,56,null,"13 190 106 56"]
[null,null,null,null,null,null,null,25.8,189,106,56,null,"13,1 189 106 56"]
[null,null,null,null,null,null,null,26,188,105,56,null,"13,2 188 105 56"]
[null,null,null,null,null,null,null,26.2,187,104,56,null,"13,3 187 104 56"]
[null,null,null,null,null,null,null,26.4,186,103,56,null,"13,4 186 103 56"]
[null,null,null,null,null,null,null,26.6,185,103,56,null,"13,5 185 103 56"]
[null,null,null,null,null,null,null,26.8,184,102,56,null,"13,6 184 102 56"]
[null,null,null,null,null,null,null,27,183,101,56,null,"13,7 183 101 56"]
[null,null,null,null,null,null,null,27.2,182,100,56,null,"13,8 182 100 56"]
[null,null,null,null,null,null,null,27.4,181,100,56,null,"13,9 181 100 56"]
[null,null,null,null,null,null,null,27.6,180,99,56,null,"14 180 99 56"]
[null,null,null,null,null,null,null,27.8,179,98,56,null,"14,1 179 98 56"]
[null,null,null,null,null,null,null,28,178,97,56,null,"14,2 178 97 56"]
[null,null,null,null,null,null,null,28.2,177,97,56,null,"14,3 177 97 56"]
[null,null,null,null,null,null,null,28.4,175,96,55,null,"14,4 175 96 55"]
[null,null,null,null,null,null,null,28.6,174,95,55,null,"14,5 174 95 55"]
[null,null,null,null,null,null,null,28.8,172,94,55,null,"14,6 172 94 55"]
[null,null,null,null,null,null,null,29,171,94,55,null,"14,7 171 94 55"]
[null,null,null,null,null,null,null,29.2,169,93,54,null,"14,8 169 93 54"]
[null,null,null,null,null,null,null,29.4,168,92,54,null,"14,9 168 92 54"]
[null,null,null,null,null,null,null,29.6,167,91,54,null,"15 167 91 54"]
[null,null,null,null,null,null,null,29.7,165,91,54,null,"15,1 165 91 54"]
[null,null,null,null,null,null,null,29.9,164,90,53,null,"15,2 164 90 53"]
[null,null,null,null,null,null,null,30.1,162,89,53,null,"15,3 162 89 53"]
[null,null,null,null,null,null,null,30.3,161,88,53,null,"15,4 161 88 53"]
[null,null,null,null,null,null,null,30.5,159,88,53,null,"15,5 159 88 53"]
[null,null,null,null,null,null,null,30.7,158,87,52,null,"15,6 158 87 52"]
[null,null,null,null,null,null,null,30.9,157,86,52,null,"15,7 157 86 52"]
[null,null,null,null,null,null,null,31.1,155,85,52,null,"15,8 155 85 52"]
[null,null,null,null,null,null,null,31.3,154,85,52,null,"15,9 154 85 52"]
[null,null,null,null,null,null,null,31.5,152,84,51,null,"16 152 84 51"]
[null,null,null,null,null,null,null,31.7,151,83,51,null,"16,1 151 83 51"]
[null,null,null,null,null,null,null,31.9,149,82,51,null,"16,2 149 82 51"]
[null,null,null,null,null,null,null,32.1,148,82,51,null,"16,3 148 82 51"]
[null,null,null,null,null,null,null,32.299999999999997,147,81,50,null,"16,4 147 81 50"]
[null,null,null,null,null,null,null,32.5,145,80,50,null,"16,5 145 80 50"]
[null,null,null,null,null,null,null,32.700000000000003,144,79,50,null,"16,6 144 79 50"]
[null,null,null,null,null,null,null,32.9,142,78,50,null,"16,7 142 78 50"]
[null,null,null,null,null,null,null,33.1,141,77,49,null,"16,8 141 77 49"]
[null,null,null,null,null,null,null,33.299999999999997,139,76,49,null,"16,9 139 76 49"]
[null,null,null,null,null,null,null,33.5,138,75,48,null,"17 138 75 48"]
[null,null,null,null,null,null,null,33.700000000000003,137,75,47,null,"17,1 137 75 47"]
[null,null,null,null,null,null,null,33.9,135,74,47,null,"17,2 135 74 47"]
[null,null,null,null,null,null,null,34.1,134,73,46,null,"17,3 134 73 46"]
[null,null,null,null,null,null,null,34.299999999999997,132,72,45,null,"17,4 132 72 45"]
[null,null,null,null,null,null,null,34.5,131,72,45,null,"17,5 131 72 45"]
[null,null,null,null,null,null,null,34.700000000000003,129,71,44,null,"17,6 129 71 44"]
[null,null,null,null,null,null,null,34.9,128,70,43,null,"17,7 128 70 43"]
[null,null,null,null,null,null,null,35.1,127,69,43,null,"17,8 127 69 43"]
[null,null,null,null,null,null,null,35.299999999999997,125,69,42,null,"17,9 125 69 42"]
[null,null,null,null,null,null,null,35.5,124,68,41,null,"18 124 68 41"]
[null,null,null,null,null,null,null,35.700000000000003,122,67,41,null,"18,1 122 67 41"]
[null,null,null,null,null,null,null,35.9,121,66,40,null,"18,2 121 66 40"]
[null,null,null,null,null,null,null,36.1,119,66,39,null,"18,3 119 66 39"]
[null,null,null,null,null,null,null,36.200000000000003,118,65,39,null,"18,4 118 65 39"]
[null,null,null,null,null,null,null,36.4,117,64,38,null,"18,5 117 64 38"]
[null,null,null,null,null,null,null,36.6,115,63,37,null,"18,6 115 63 37"]
[null,null,null,null,null,null,null,36.799999999999997,114,63,37,null,"18,7 114 63 37"]
[null,null,null,null,null,null,null,37,112,62,36,null,"18,8 112 62 36"]
[null,null,null,null,null,null,null,37.200000000000003,111,61,35,null,"18,9 111 61 35"]
[null,null,null,null,null,null,null,37.4,109,60,34,null,"19 109 60 34"]
[null,null,null,null,null,null,null,37.6,108,60,33,null,"19,1 108 60 33"]
[null,null,null,null,null,null,null,37.799999999999997,107,59,32,null,"19,2 107 59 32"]
[null,null,null,null,null,null,null,38,105,58,31,null,"19,3 105 58 31"]
[null,null,null,null,null,null,null,38.200000000000003,104,57,29,null,"19,4 104 57 29"]
[null,null,null,null,null,null,null,38.4,102,57,28,null,"19,5 102 57 28"]
[null,null,null,null,null,null,null,38.6,101,56,27,null,"19,6 101 56 27"]
[null,null,null,null,null,null,null,38.799999999999997,99,55,26,null,"19,7 99 55 26"]
[null,null,null,null,null,null,null,39,98,54,25,null,"19,8 98 54 25"]
[null,null,null,null,null,null,null,39.200000000000003,97,54,24,null,"19,9 97 54 24"]
[null,null,null,null,null,null,null,39.4,95,53,23,null,"20 95 53 23"]
[null,null,null,null,null,null,null,39.6,94,52,21,null,"20,1 94 52 21"]
[null,null,null,null,null,null,null,39.799999999999997,92,51,20,null,"20,2 92 51 20"]
[null,null,null,null,null,null,null,40,91,51,19,null,"20,3 91 51 19"]
[null,null,null,null,null,null,null,40.200000000000003,89,50,18,null,"20,4 89 50 18"]
[null,null,null,null,null,null,null,40.4,88,49,17,null,"20,5 88 49 17"]
[null,null,null,null,null,null,null,40.6,87,48,16,null,"20,6 87 48 16"]
[null,null,null,null,null,null,null,40.799999999999997,85,48,15,null,"20,7 85 48 15"]
[null,null,null,null,null,null,null,41,84,47,13,null,"20,8 84 47 13"]
[null,null,null,null,null,null,null,41.2,82,46,12,null,"20,9 82 46 12"]
[null,null,null,null,null,null,null,41.4,81,45,11,null,"21 81 45 11"]
[null,null,null,null,null,null,null,41.6,79,45,10,null,"21,1 79 45 10"]
[null,null,null,null,null,null,null,41.8,78,44,9,null,"21,2 78 44 9"]
[null,null,null,null,null,null,null,42,77,43,8,null,"21,3 77 43 8"]
[null,null,null,null,null,null,null,42.2,75,42,9,null,"21,4 75 42 9"]
[null,null,null,null,null,null,null,42.4,74,42,9,null,"21,5 74 42 9"]
[null,null,null,null,null,null,null,42.6,72,41,10,null,"21,6 72 41 10"]
[null,null,null,null,null,null,null,42.7,71,40,10,null,"21,7 71 40 10"]
[null,null,null,null,null,null,null,42.9,69,39,11,null,"21,8 69 39 11"]
[null,null,null,null,null,null,null,43.1,68,39,11,null,"21,9 68 39 11"]
[null,null,null,null,null,null,null,43.3,67,38,12,null,"22 67 38 12"]
[null,null,null,null,null,null,null,43.5,65,37,12,null,"22,1 65 37 12"]
[null,null,null,null,null,null,null,43.7,64,36,13,null,"22,2 64 36 13"]
[null,null,null,null,null,null,null,43.9,62,36,13,null,"22,3 62 36 13"]
[null,null,null,null,null,null,null,44.1,61,35,14,null,"22,4 61 35 14"]
[null,null,null,null,null,null,null,44.3,59,34,14,null,"22,5 59 34 14"]
[null,null,null,null,null,null,null,44.5,58,33,15,null,"22,6 58 33 15"]
[null,null,null,null,null,null,null,44.7,57,33,15,null,"22,7 57 33 15"]
[null,null,null,null,null,null,null,44.9,55,32,16,null,"22,8 55 32 16"]
[null,null,null,null,null,null,null,45.1,54,31,16,null,"22,9 54 31 16"]
[null,null,null,null,null,null,null,45.3,52,30,17,null,"23 52 30 17"]
[null,null,null,null,null,null,null,45.5,51,30,17,null,"23,1 51 30 17"]
[null,null,null,null,null,null,null,45.7,49,29,18,null,"23,2 49 29 18"]
[null,null,null,null,null,null,null,45.9,48,28,18,null,"23,3 48 28 18"]
[null,null,null,null,null,null,null,46.1,47,27,19,null,"23,4 47 27 19"]
[null,null,null,null,null,null,null,46.3,45,27,19,null,"23,5 45 27 19"]
[null,null,null,null,null,null,null,46.5,44,26,20,null,"23,6 44 26 20"]
[null,null,null,null,null,null,null,46.7,42,25,20,null,"23,7 42 25 20"]
[null,null,null,null,null,null,null,46.9,41,24,21,null,"23,8 41 24 21"]
[null,null,null,null,null,null,null,47.1,39,24,21,null,"23,9 39 24 21"]
[null,null,null,null,null,null,null,47.3,38,23,22,null,"24 38 23 22"]
[null,null,null,null,null,null,null,47.5,37,22,21,null,"24,1 37 22 21"]
[null,null,null,null,null,null,null,47.7,37,22,21,null,"24,2 37 22 21"]
[null,null,null,null,null,null,null,47.9,36,22,21,null,"24,3 36 22 21"]
[null,null,null,null,null,null,null,48.1,36,21,20,null,"24,4 36 21 20"]
[null,null,null,null,null,null,null,48.3,35,21,20,null,"24,5 35 21 20"]
[null,null,null,null,null,null,null,48.5,35,21,20,null,"24,6 35 21 20"]
[null,null,null,null,null,null,null,48.7,34,20,19,null,"24,7 34 20 19"]
[null,null,null,null,null,null,null,48.9,34,20,19,null,"24,8 34 20 19"]
[null,null,null,null,null,null,null,49.1,33,20,19,null,"24,9 33 20 19"]
[null,null,null,null,null,null,null,49.3,33,19,18,null,"25 33 19 18"]
[null,null,null,null,null,null,null,49.4,32,19,18,null,"25,1 32 19 18"]
[null,null,null,null,null,null,null,49.6,32,19,18,null,"25,2 32 19 18"]
[null,null,null,null,null,null,null,49.8,31,18,17,null,"25,3 31 18 17"]
[null,null,null,null,null,null,null,50,31,18,17,null,"25,4 31 18 17"]
[null,null,null,null,null,null,null,50.2,30,18,17,null,"25,5 30 18 17"]
[null,null,null,null,null,null,null,50.4,30,17,16,null,"25,6 30 17 16"]
[null,null,null,null,null,null,null,50.6,29,17,16,null,"25,7 29 17 16"]
[null,null,null,null,null,null,null,50.8,29,17,16,null,"25,8 29 17 16"]
[null,null,null,null,null,null,null,51,28,16,15,null,"25,9 28 16 15"]
[null,null,null,null,null,null,null,51.2,28,16,15,null,"26 28 16 15"]
[null,null,null,null,null,null,null,51.4,27,16,15,null,"26,1 27 16 15"]
[null,null,null,null,null,null,null,51.6,27,15,14,null,"26,2 27 15 14"]
[null,null,null,null,null,null,null,51.8,26,15,14,null,"26,3 26 15 14"]
[null,null,null,null,null,null,null,52,26,15,14,null,"26,4 26 15 14"]
[null,null,null,null,null,null,null,52.2,25,14,13,null,"26,5 25 14 13"]
[null,null,null,null,null,null,null,52.4,25,14,13,null,"26,6 25 14 13"]
[null,null,null,null,null,null,null,52.6,24,14,13,null,"26,7 24 14 13"]
[null,null,null,null,null,null,null,52.8,24,13,12,null,"26,8 24 13 12"]
[null,null,null,null,null,null,null,53,23,13,12,null,"26,9 23 13 12"]
[null,null,null,null,null,null,null,53.2,23,13,12,null,"27 23 13 12"]
[null,null,null,null,null,null,null,53.4,22,12,11,null,"27,1 22 12 11"]
[null,null,null,null,null,null,null,53.6,22,12,11,null,"27,2 22 12 11"]
[null,null,null,null,null,null,null,53.8,21,12,11,null,"27,3 21 12 11"]
[null,null,null,null,null,null,null,54,21,11,10,null,"27,4 21 11 10"]
[null,null,null,null,null,null,null,54.2,20,11,10,null,"27,5 20 11 10"]
[null,null,null,null,null,null,null,54.4,20,11,10,null,"27,6 20 11 10"]
[null,null,null,null,null,null,null,54.6,19,10,9,null,"27,7 19 10 9"]
[null,null,null,null,null,null,null,54.8,19,10,9,null,"27,8 19 10 9"]
[null,null,null,null,null,null,null,55,18,10,9,null,"27,9 18 10 9"]
[null,null,null,null,null,null,null,55.2,18,9,8,null,"28 18 9 8"]
[null,null,null,null,null,null,null,55.4,17,9,8,null,"28,1 17 9 8"]
[null,null,null,null,null,null,null,55.6,17,9,8,null,"28,2 17 9 8"]
[null,null,null,null,null,null,null,55.8,16,8,7,null,"28,3 16 8 7"]
[null,null,null,null,null,null,null,55.9,16,8,7,null,"28,4 16 8 7"]
[null,null,null,null,null,null,null,56.1,15,8,7,null,"28,5 15 8 7"]
[null,null,null,null,null,null,null,56.3,15,7,6,null,"28,6 15 7 6"]
[null,null,null,null,null,null,null,56.5,14,7,6,null,"28,7 14 7 6"]
[null,null,null,null,null,null,null,56.7,14,7,6,null,"28,8 14 7 6"]
[null,null,null,null,null,null,null,56.9,13,6,5,null,"28,9 13 6 5"]
[null,null,null,null,null,null,null,57.1,13,6,5,null,"29 13 6 5"]
[null,null,null,null,null,null,null,57.3,12,6,5,null,"29,1 12 6 5"]
[null,null,null,null,null,null,null,57.5,12,5,4,null,"29,2 12 5 4"]
[null,null,null,null,null,null,null,57.7,11,5,4,null,"29,3 11 5 4"]
[null,null,null,null,null,null,null,57.9,11,5,4,null,"29,4 11 5 4"]
[null,null,null,null,null,null,null,58.1,10,4,3,null,"29,5 10 4 3"]
[null,null,null,null,null,null,null,58.3,10,4,3,null,"29,6 10 4 3"]
[null,null,null,null,null,null,null,58.5,9,4,3,null,"29,7 9 4 3"]
[null,null,null,null,null,null,null,58.7,9,3,2,null,"29,8 9 3 2"]
[null,null,null,null,null,null,null,58.9,8,3,2,null,"29,9 8 3 2"]
[null,null,null,null,null,null,null,59.1,8,3,2,null,"30 8 3 2"]

{"sheet":"Omregninger","index":3,"n_rows":167,"n_cols":6,"rows_kept":167,"cut":false,"hidden":false,"merged":[[24,1,24,2],[11,1,11,4],[22,1,22,3],[12,1,12,6]]}
[]
["Farver:"]
[]
[null,"Formål","Formel","Indtast","Beregn","Resultat"]
[null,"EBC to SRM:","SRM = EBC × 0,508","Indtast EBC",null,{"$f":"IF(E5=\"\",\"\",ROUND((E5*0.508),0))","v":""}]
[null,"SRM to EBC:","EBC = SRM × 1,97","Indtast SRM",null,{"$f":"IF(E6=\"\",\"\",ROUND((E6*1.97),0))","v":""}]
[null,"Lovibond to SRM:","SRM = (1,3546 × °L) - 0,76","Indtast °L",null,{"$f":"IF(E7=\"\",\"\",ROUND(((1.3546*E7)-0.76),0))","v":""}]
[null,"SRM to Lovibond:","°L = (SRM + 0,76) ÷ 1,3546","Indtast SRM",null,{"$f":"IF(E8=\"\",\"\",ROUND(((E8+0.76)/1.3546),0))","v":""}]
[]
["Refraktometer:"]
[]
[null,"Udregning af Final Gravity med Refraktometer måling - med kompensation for fejlvisning grundet alkohol"]
[null,"Input er i Oechsle, hvor gravity 1080 eller 1,080 = 80 oe"]
[null,"Indtast Original Gravity","Oe","Indtast Final Gravity","Oe"]
[null,"Refrektometer Input  -  OG",59,"Refrektometer INPUT - FG",29]
[null,"Brix mellemregning",{"$f":"VLOOKUP((C15/1000)+1,$B$26:$C$167,2,FALSE)","v":14.49},"Brix mellemregning",{"$f":"VLOOKUP((E15/1000)+1,$B$26:$C$167,2,FALSE)","v":7.3}]
[null,"Mellemregning",-2.3184740000000001E-3,{"$f":"1.001843+C17*C16","v":0.96824831174000003}]
[null,"Mellemregning",-7.7750000000000009E-6,{"$f":"C18*C16*C16","v":-1.6324397775000002E-3}]
[null,"Mellemregning",-3.4E-8,{"$f":"C19*C16*C16*C16","v":-1.0343894286600001E-4}]
[null,"Mellemregning",5.7400000000000003E-3,{"$f":"C20*E16","v":4.1902000000000002E-2}]
[null,"Mellemregning",3.3439999999999998E-5,{"$f":"C21*E16*E16","v":1.7820175999999997E-3}]
[null,"Mellemregning",8.6000000000000002E-8,{"$f":"C22*E16*E16*E16","v":3.3455462000000001E-5}]
[null,"Udregnet  Final Gravity  ( kompenseret for alkohol )  =",null,null,{"$f":"SUM(D17:D22)","v":1.0102299060816342}]
[]
[null,"Specific Gravity-Brix Conversion Table"]
[null,"Specific Gravity","Brix"]
[null,0.99,0]
[null,0.99099999999999999,0]
[null,0.99199999999999999,0]
[null,0.99299999999999999,0]
[null,0.99399999999999999,0]
[null,0.995,0]
[null,0.996,0]
[null,0.997,0]
[null,0.998,0]
[null,0.999,0]
[null,1,0]
[null,1.0009999999999999,0.26]
[null,1.002,0.51]
[null,1.0029999999999999,0.77]
[null,1.004,1.03]
[null,1.0049999999999999,1.28]
[null,1.006,1.54]
[null,1.0069999999999999,1.8]
[null,1.008,2.0499999999999998]
[null,1.0089999999999999,2.31]
[null,1.01,2.56]
[null,1.0109999999999999,2.81]
[null,1.012,3.07]
[null,1.0129999999999999,3.32]
[null,1.014,3.57]
[null,1.0149999999999999,3.82]
[null,1.016,4.08]
[null,1.0169999999999999,4.33]
[null,1.018,4.58]
[null,1.0189999999999999,4.83]
[null,1.02,5.08]
[null,1.0209999999999999,5.33]
[null,1.022,5.57]
[null,1.0229999999999999,5.82]
[null,1.024,6.07]
[null,1.0249999999999999,6.32]
[null,1.026,6.57]
[null,1.0269999999999999,6.81]
[null,1.028,7.06]
[null,1.0289999999999999,7.3]
[null,1.03,7.55]
[null,1.0309999999999999,7.8]
[null,1.032,8.0399999999999991]
[null,1.0329999999999999,8.2799999999999994]
[null,1.034,8.5299999999999994]
[null,1.0349999999999999,8.77]
[null,1.036,9.01]
[null,1.0369999999999999,9.26]
[null,1.038,9.5]
[null,1.0389999999999999,9.74]
[null,1.04,9.98]
[null,1.0409999999999999,10.220000000000001]
[null,1.042,10.46]
[null,1.0429999999999999,10.7]
[null,1.044,10.94]
[null,1.0449999999999999,11.18]
[null,1.046,11.42]
[null,1.0469999999999999,11.66]
[null,1.048,11.9]
[null,1.0489999999999999,12.14]
[null,1.05,12.37]
[null,1.0509999999999999,12.61]
[null,1.052,12.85]
[null,1.0529999999999999,13.08]
[null,1.054,13.32]
[null,1.0549999999999999,13.55]
[null,1.056,13.79]
[null,1.0569999999999999,14.02]
[null,1.0580000000000001,14.26]
[null,1.0589999999999999,14.49]
[null,1.06,14.72]
[null,1.0609999999999999,14.96]
[null,1.0620000000000001,15.19]
[null,1.0629999999999999,15.42]
[null,1.0640000000000001,15.65]
[null,1.0649999999999999,15.88]
[null,1.0660000000000001,16.11]
[null,1.0669999999999999,16.34]
[null,1.0680000000000001,16.57]
[null,1.069,16.8]
[null,1.07,17.03]
[null,1.071,17.260000000000002]
[null,1.0720000000000001,17.489999999999998]
[null,1.073,17.72]
[null,1.0740000000000001,17.95]
[null,1.075,18.18]
[null,1.0760000000000001,18.399999999999999]
[null,1.077,18.63]
[null,1.0780000000000001,18.86]
[null,1.079,19.079999999999998]
[null,1.08,19.309999999999999]
[null,1.081,19.53]
[null,1.0820000000000001,19.760000000000002]
[null,1.083,19.98]
[null,1.0840000000000001,20.21]
[null,1.085,20.43]
[null,1.0860000000000001,20.65]
[null,1.087,20.88]
[null,1.0880000000000001,21.1]
[null,1.089,21.32]
[null,1.0900000000000001,21.54]
[null,1.091,21.77]
[null,1.0920000000000001,21.99]
[null,1.093,22.21]
[null,1.0940000000000001,22.43]
[null,1.095,22.65]
[null,1.0960000000000001,22.87]
[null,1.097,23.09]
[null,1.0980000000000001,23.31]
[null,1.099,23.53]
[null,1.1000000000000001,23.75]
[null,1.101,23.96]
[null,1.1020000000000001,24.18]
[null,1.103,24.4]
[null,1.1040000000000001,24.62]
[null,1.105,24.83]
[null,1.1060000000000001,25.05]
[null,1.107,25.27]
[null,1.1080000000000001,25.48]
[null,1.109,25.7]
[null,1.1100000000000001,25.91]
[null,1.111,26.13]
[null,1.1120000000000001,26.34]
[null,1.113,26.56]
[null,1.1140000000000001,26.77]
[null,1.115,26.98]
[null,1.1160000000000001,27.2]
[null,1.117,27.41]
[null,1.1180000000000001,27.62]
[null,1.119,27.83]
[null,1.1200000000000001,28.05]
[null,1.121,28.26]
[null,1.1220000000000001,28.47]
[null,1.123,28.68]
[null,1.1240000000000001,28.89]
[null,1.125,29.1]
[null,1.1259999999999999,29.31]
[null,1.127,29.52]
[null,1.1279999999999999,29.73]
[null,1.129,29.94]
[null,1.1299999999999999,30.15]

{"sheet":"Malt","index":4,"n_rows":82,"n_cols":16,"rows_kept":82,"cut":false,"hidden":false,"merged":[[77,1,77,2]]}
["Malttyper","EBC Range","EBC Avg.","Ekstraktudbytte","Karakteristik","Malt i kg","Brygladen","Hjemmebryggeren","Albryg (10g interval)","Bryglageret","Brygforretningen",null,"Malt Pris\nGrupper","Priser\nkr./kg",null,"DropDown Menu"]
["Basis Malt",null,null,null,null,null,"G","H","I","J","K",null,null,15]
["Pilsner","2,5 - 3,5",3,"300","Høj enzymaktivitet",{"$f":"IFERROR(VLOOKUP(Malt!$A3,BrewReport!$A$9:$C$18,3,FALSE),0)","v":0},{"$f":"F3*N5","v":0},{"$f":"F3*N7","v":0},{"$f":"F3*N7","v":0},{"$f":"F3*N7","v":0},{"$f":"F3*N5","v":0},null,null,16,null,{"$f":"IFERROR(INDEX($A$3:$A$75, SMALL(IF(ISBLANK(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))), \"\", ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\")))-MIN(ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))))+1), ROW(A1))),\"\")","v":"Pilsner"}]
["Fuglsang Pilsner","3,7","3,7","320","Dansk, Høj enzymaktivitet",{"$f":"IFERROR(VLOOKUP(Malt!$A4,BrewReport!$A$9:$C$18,3,FALSE),0)","v":0},null,null,{"$f":"F4*N2","v":0},null,null,null,null,17,null,{"$f":"IFERROR(INDEX($A$3:$A$75, SMALL(IF(ISBLANK(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))), \"\", ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\")))-MIN(ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))))+1), ROW(A2))),\"\")","v":"Vienna"}]
["Pilsner Bohemian","2,5 - 3,5",3,"300","Høj enzymaktivitet",{"$f":"IFERROR(VLOOKUP(Malt!$A5,BrewReport!$A$9:$C$18,3,FALSE),0)","v":0},{"$f":"F5*N5","v":0},null,{"$f":"F5*N3","v":0},{"$f":"F5*N7","v":0},null,null,"Grp 1 ",18,null,{"$f":"IFERROR(INDEX($A$3:$A$75, SMALL(IF(ISBLANK(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))), \"\", ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\")))-MIN(ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))))+1), ROW(A3))),\"\")","v":"Pale Ale"}]
["Vienna","5 - 7","6","300","Farve, sødme og fylde",{"$f":"IFERROR(VLOOKUP(Malt!$A6,BrewReport!$A$9:$C$18,3,FALSE),0)","v":0},{"$f":"F6*N5","v":0},{"$f":"F6*N7","v":0},{"$f":"F6*N3","v":0},null,{"$f":"F6*N5","v":0},null,"Grp 2",19,null,{"$f":"IFERROR(INDEX($A$3:$A$75, SMALL(IF(ISBLANK(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))), \"\", ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\")))-MIN(ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))))+1), ROW(A4))),\"\")","v":"Munich (Type 2)"}]
["Pale Ale","7,0 - 9,0",8,"300","Mørkere og mere maltet end Pilsner",{"$f":"IFERROR(VLOOKUP(Malt!$A7,BrewReport!$A$9:$C$18,3,FALSE),0)","v":5.5},{"$f":"F7*N7","v":110},{"$f":"F7*N6","v":104.5},{"$f":"F7*N3","v":88},{"$f":"F7*N6","v":104.5},{"$f":"F7*N5","v":99},null,"Grp 3",20,null,{"$f":"IFERROR(INDEX($A$3:$A$75, SMALL(IF(ISBLANK(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))), \"\", ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\")))-MIN(ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))))+1), ROW(A5))),\"\")","v":"Munich Light (Type 1)"}]
["Munich (Type 2)","20 - 25","25","290","Sødme og fylde",{"$f":"IFERROR(VLOOKUP(Malt!$A8,BrewReport!$A$9:$C$18,3,FALSE),0)","v":0},{"$f":"F8*N5","v":0},{"$f":"F8*N7","v":0},{"$f":"F8*N7","v":0},{"$f":"F8*N16","v":0},{"$f":"F8*N5","v":0},null,"Grp 4",21,null,{"$f":"IFERROR(INDEX($A$3:$A$75, SMALL(IF(ISBLANK(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))), \"\", ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\")))-MIN(ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))))+1), ROW(A6))),\"\")","v":"Maris Otter Ale"}]
["Munich Light (Type 1)","13 - 17","15","290","Sødme og fylde",{"$f":"IFERROR(VLOOKUP(Malt!$A9,BrewReport!$A$9:$C$18,3,FALSE),0)","v":0},{"$f":"F9*N5","v":0},{"$f":"F9*N7","v":0},{"$f":"F9*N7","v":0},{"$f":"F9*N16","v":0},{"$f":"F9*N5","v":0},null,"Grp 5",22,null,{"$f":"IFERROR(INDEX($A$3:$A$75, SMALL(IF(ISBLANK(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))), \"\", ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\")))-MIN(ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))))+1), ROW(A7))),\"\")","v":"Cara 20 (Blond)"}]
["Maris Otter Ale",8,8,"320","Fyldig, nødder, let orange farve",{"$f":"IFERROR(VLOOKUP(Malt!$A10,BrewReport!$A$9:$C$18,3,FALSE),0)","v":0},{"$f":"F10*N6","v":0},{"$f":"F10*N7","v":0},null,null,{"$f":"F10*N12","v":0},null,"Grp 6",23,null,{"$f":"IFERROR(INDEX($A$3:$A$75, SMALL(IF(ISBLANK(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))), \"\", ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\")))-MIN(ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))))+1), ROW(A8))),\"\")","v":"Cara Crystal (Gold)"}]
["Red X",30,30,"290","Fyldig, intens rødlig farve",{"$f":"IFERROR(VLOOKUP(Malt!$A11,BrewReport!$A$9:$C$18,3,FALSE),0)","v":0},{"$f":"F11*N6","v":0},null,null,null,null,null,"Grp 7",24,null,{"$f":"IFERROR(INDEX($A$3:$A$75, SMALL(IF(ISBLANK(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))), \"\", ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\")))-MIN(ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))))+1), ROW(A9))),\"\")","v":"Cara Ruby"}]
["Karamel Malt",null,null,null,null,null,null,null,null,null,null,null,"Grp 8",25,null,{"$f":"IFERROR(INDEX($A$3:$A$75, SMALL(IF(ISBLANK(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))), \"\", ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\")))-MIN(ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))))+1), ROW(A10))),\"\")","v":"Crystal"}]
["Cara Pils",5,5,"275",null,{"$f":"IFERROR(VLOOKUP(Malt!$A13,BrewReport!$A$9:$C$18,3,FALSE),0)","v":0},{"$f":"F13*N8","v":0},null,{"$f":"F13*N7","v":0},{"$f":"F13*N16","v":0},{"$f":"F13*N9","v":0},null,"Grp 9",26,null,{"$f":"IFERROR(INDEX($A$3:$A$75, SMALL(IF(ISBLANK(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))), \"\", ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\")))-MIN(ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))))+1), ROW(A11))),\"\")","v":"Special B"}]
["Cara 20 (Blond)","20",20,"280","Mild karamel smag og gylden farve",{"$f":"IFERROR(VLOOKUP(Malt!$A14,BrewReport!$A$9:$C$18,3,FALSE),0)","v":0},{"$f":"F14*N8","v":0},{"$f":"F14*N16","v":0},null,{"$f":"F14*N16","v":0},{"$f":"F14*N9","v":0},null,"Grp 10",27,null,{"$f":"IFERROR(INDEX($A$3:$A$75, SMALL(IF(ISBLANK(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))), \"\", ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\")))-MIN(ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))))+1), ROW(A12))),\"\")","v":"Coffee / Café Light"}]
["Carabelge","30 - 35","33","280",null,{"$f":"IFERROR(VLOOKUP(Malt!$A15,BrewReport!$A$9:$C$18,3,FALSE),0)","v":0},null,null,{"$f":"F15*N7","v":0},null,null,null,"Grp 11",28,null,{"$f":"IFERROR(INDEX($A$3:$A$75, SMALL(IF(ISBLANK(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))), \"\", ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\")))-MIN(ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))))+1), ROW(A13))),\"\")","v":"Coffee / Café"}]
["Cara Vienna",50,50,"280",null,{"$f":"IFERROR(VLOOKUP(Malt!$A16,BrewReport!$A$9:$C$18,3,FALSE),0)","v":0},{"$f":"F16*N8","v":0},null,null,{"$f":"F16*N16","v":0},null,null,"Grp 12",30,null,{"$f":"IFERROR(INDEX($A$3:$A$75, SMALL(IF(ISBLANK(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))), \"\", ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\")))-MIN(ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))))+1), ROW(A14))),\"\")","v":"Roasted Barley"}]
["Cara Crystal (Gold)","110 - 130",120,"280","Stor karamel- og toffee smag, bedre skum og fylde",{"$f":"IFERROR(VLOOKUP(Malt!$A17,BrewReport!$A$9:$C$18,3,FALSE),0)","v":0},{"$f":"F17*N8","v":0},{"$f":"F17*N16","v":0},{"$f":"F17*N7","v":0},null,{"$f":"F17*N9","v":0},null,"Grp 13",40,null,{"$f":"IFERROR(INDEX($A$3:$A$75, SMALL(IF(ISBLANK(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))), \"\", ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\")))-MIN(ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))))+1), ROW(A15))),\"\")","v":"Chocolate / carafa Type I"}]
["Chateau Cara ",150,150,"280",null,{"$f":"IFERROR(VLOOKUP(Malt!$A18,BrewReport!$A$9:$C$18,3,FALSE),0)","v":0},null,null,{"$f":"F18*N7","v":0},null,{"$f":"F18*N9","v":0},null,null,null,null,{"$f":"IFERROR(INDEX($A$3:$A$75, SMALL(IF(ISBLANK(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))), \"\", ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\")))-MIN(ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))))+1), ROW(A16))),\"\")","v":"Black / carafa Type III"}]
["Cara Hell",25,25,"280",null,{"$f":"IFERROR(VLOOKUP(Malt!$A19,BrewReport!$A$9:$C$18,3,FALSE),0)","v":0},{"$f":"F19*N8","v":0},null,{"$f":"F19*N7","v":0},{"$f":"F19*N16","v":0},null,null,null,null,null,{"$f":"IFERROR(INDEX($A$3:$A$75, SMALL(IF(ISBLANK(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))), \"\", ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\")))-MIN(ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))))+1), ROW(A17))),\"\")","v":"Wheat"}]
["Cara Munich Type I","80 - 100","90","275",null,{"$f":"IFERROR(VLOOKUP(Malt!$A20,BrewReport!$A$9:$C$18,3,FALSE),0)","v":0},{"$f":"F20*N7","v":0},null,{"$f":"F20*N7","v":0},{"$f":"F20*N15","v":0},null,null,null,null,null,{"$f":"IFERROR(INDEX($A$3:$A$75, SMALL(IF(ISBLANK(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))), \"\", ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\")))-MIN(ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))))+1), ROW(A18))),\"\")","v":"Wheat Spelt"}]
["Cara Munich Type II","110 - 130","120","275",null,{"$f":"IFERROR(VLOOKUP(Malt!$A21,BrewReport!$A$9:$C$18,3,FALSE),0)","v":0},{"$f":"F21*N7","v":0},null,{"$f":"F21*N7","v":0},{"$f":"F21*N15","v":0},null,null,null,null,null,{"$f":"IFERROR(INDEX($A$3:$A$75, SMALL(IF(ISBLANK(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))), \"\", ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\")))-MIN(ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))))+1), ROW(A19))),\"\")","v":"Biscuit"}]
["Cara Munich Type III","140 - 160","150","275",null,{"$f":"IFERROR(VLOOKUP(Malt!$A22,BrewReport!$A$9:$C$18,3,FALSE),0)","v":0},{"$f":"F22*N8","v":0},null,null,{"$f":"F22*N16","v":0},null,null,null,null,null,{"$f":"IFERROR(INDEX($A$3:$A$75, SMALL(IF(ISBLANK(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))), \"\", ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\")))-MIN(ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))))+1), ROW(A20))),\"\")","v":"Arome"}]
["Cara Red",40,40,"290",null,{"$f":"IFERROR(VLOOKUP(Malt!$A23,BrewReport!$A$9:$C$18,3,FALSE),0)","v":0},{"$f":"F23*N8","v":0},null,{"$f":"F23*N7","v":0},{"$f":"F23*N16","v":0},null,null,null,null,null,{"$f":"IFERROR(INDEX($A$3:$A$75, SMALL(IF(ISBLANK(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))), \"\", ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\")))-MIN(ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))))+1), ROW(A21))),\"\")","v":"Melano Light"}]
["Cara Aroma","350 - 450","400","290",null,{"$f":"IFERROR(VLOOKUP(Malt!$A24,BrewReport!$A$9:$C$18,3,FALSE),0)","v":0},{"$f":"F24*N9","v":0},null,null,{"$f":"F24*N16","v":0},null,null,null,null,null,{"$f":"IFERROR(INDEX($A$3:$A$75, SMALL(IF(ISBLANK(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))), \"\", ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\")))-MIN(ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))))+1), ROW(A22))),\"\")","v":"Melano"}]
["Cara Amber",60,60,"290",null,{"$f":"IFERROR(VLOOKUP(Malt!$A25,BrewReport!$A$9:$C$18,3,FALSE),0)","v":0},{"$f":"F25*N9","v":0},null,null,{"$f":"F25*N16","v":0},null,null,null,null,null,{"$f":"IFERROR(INDEX($A$3:$A$75, SMALL(IF(ISBLANK(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))), \"\", ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\")))-MIN(ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))))+1), ROW(A23))),\"\")","v":"Boghvede / Buckwheat"}]
["Cara Rye",90,90,"260",null,{"$f":"IFERROR(VLOOKUP(Malt!$A26,BrewReport!$A$9:$C$18,3,FALSE),0)","v":0},{"$f":"F26*N9","v":0},null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($A$3:$A$75, SMALL(IF(ISBLANK(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))), \"\", ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\")))-MIN(ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))))+1), ROW(A24))),\"\")","v":"Sauer / Acid"}]
["Cara Ruby",50,50,"290","Rig karamelsmag og toffee aroma",{"$f":"IFERROR(VLOOKUP(Malt!$A27,BrewReport!$A$9:$C$18,3,FALSE),0)","v":0},null,{"$f":"F27*N16","v":0},{"$f":"F27*N3","v":0},null,{"$f":"F27*N9","v":0},null,null,null,null,{"$f":"IFERROR(INDEX($A$3:$A$75, SMALL(IF(ISBLANK(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))), \"\", ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\")))-MIN(ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))))+1), ROW(A25))),\"\")","v":"Abbey"}]
["Cara Wheat","100 - 140",120,"290",null,{"$f":"IFERROR(VLOOKUP(Malt!$A28,BrewReport!$A$9:$C$18,3,FALSE),0)","v":0},{"$f":"F28*N9","v":0},null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($A$3:$A$75, SMALL(IF(ISBLANK(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))), \"\", ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\")))-MIN(ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))))+1), ROW(A26))),\"\")","v":"Peated / Røg"}]
["Crystal",150,150,"280","Rig malt smag og aroma. Blød bitterhed",{"$f":"IFERROR(VLOOKUP(Malt!$A29,BrewReport!$A$9:$C$18,3,FALSE),0)","v":0},null,{"$f":"F29*N16","v":0},null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($A$3:$A$75, SMALL(IF(ISBLANK(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))), \"\", ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\")))-MIN(ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))))+1), ROW(A27))),\"\")","v":"Oat"}]
["Special B",300,300,"250","Rosinagtig smag, strejf af nødder og blommer",{"$f":"IFERROR(VLOOKUP(Malt!$A30,BrewReport!$A$9:$C$18,3,FALSE),0)","v":0},{"$f":"F30*N9","v":0},{"$f":"F30*N16","v":0},{"$f":"F30*N7","v":0},{"$f":"F30*N16","v":0},null,null,null,null,null,{"$f":"IFERROR(INDEX($A$3:$A$75, SMALL(IF(ISBLANK(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))), \"\", ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\")))-MIN(ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))))+1), ROW(A28))),\"\")","v":"Rye"}]
["Coffee / Café Light","250","250","280","Mild nøddeagtig og kaffesmag",{"$f":"IFERROR(VLOOKUP(Malt!$A31,BrewReport!$A$9:$C$18,3,FALSE),0)","v":0},{"$f":"F31*N10","v":0},{"$f":"F31*N16","v":0},null,null,{"$f":"F31*N10","v":0},null,null,null,null,{"$f":"IFERROR(INDEX($A$3:$A$75, SMALL(IF(ISBLANK(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))), \"\", ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\")))-MIN(ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))))+1), ROW(A29))),\"\")","v":"Barley Flaked"}]
["Coffee / Café",500,500,"280","Mild nøddeagtig og kaffesmag",{"$f":"IFERROR(VLOOKUP(Malt!$A32,BrewReport!$A$9:$C$18,3,FALSE),0)","v":0},{"$f":"F32*N10","v":0},{"$f":"F32*N16","v":0},null,null,{"$f":"F32*N10","v":0},null,null,null,null,{"$f":"IFERROR(INDEX($A$3:$A$75, SMALL(IF(ISBLANK(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))), \"\", ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\")))-MIN(ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))))+1), ROW(A30))),\"\")","v":"Corn Flaked"}]
["Cara Clair","3 - 7",5,"275",null,{"$f":"IFERROR(VLOOKUP(Malt!$A33,BrewReport!$A$9:$C$18,3,FALSE),0)","v":0},{"$f":"F33*N8","v":0},null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($A$3:$A$75, SMALL(IF(ISBLANK(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))), \"\", ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\")))-MIN(ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))))+1), ROW(A31))),\"\")","v":"Oat Flaked"}]
["Ristet Malt",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($A$3:$A$75, SMALL(IF(ISBLANK(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))), \"\", ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\")))-MIN(ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))))+1), ROW(A32))),\"\")","v":"Torrefied Oat Flakes"}]
["Roasted Barley","1200 - 1400",1300,"210","Kaffeagtig smag, kraftigt ristet smag. Sødme",{"$f":"IFERROR(VLOOKUP(Malt!$A35,BrewReport!$A$9:$C$18,3,FALSE),0)","v":0},{"$f":"F35*N10","v":0},{"$f":"F35*N16","v":0},null,{"$f":"F35*N15","v":0},{"$f":"F35*N7","v":0},null,null,null,null,{"$f":"IFERROR(INDEX($A$3:$A$75, SMALL(IF(ISBLANK(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))), \"\", ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\")))-MIN(ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))))+1), ROW(A33))),\"\")","v":"Wheat Flaked"}]
["Roasted Wheat","950 - 1050","1000","210",null,{"$f":"IFERROR(VLOOKUP(Malt!$A36,BrewReport!$A$9:$C$18,3,FALSE),0)","v":0},{"$f":"F36*N10","v":0},null,null,{"$f":"F36*N15","v":0},null,null,null,null,null,{"$f":"IFERROR(INDEX($A$3:$A$75, SMALL(IF(ISBLANK(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))), \"\", ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\")))-MIN(ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))))+1), ROW(A34))),\"\")","v":"Rice Flaked"}]
["Roasted Rye","500 - 800","650","260",null,{"$f":"IFERROR(VLOOKUP(Malt!$A37,BrewReport!$A$9:$C$18,3,FALSE),0)","v":0},{"$f":"F37*N10","v":0},null,{"$f":"F37*N4","v":0},null,null,null,null,null,null,{"$f":"IFERROR(INDEX($A$3:$A$75, SMALL(IF(ISBLANK(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))), \"\", ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\")))-MIN(ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))))+1), ROW(A35))),\"\")","v":"Whisky            30 - 45 ppm"}]
["Chokolate Rye",800,800,"260",null,{"$f":"IFERROR(VLOOKUP(Malt!$A38,BrewReport!$A$9:$C$18,3,FALSE),0)","v":0},null,null,{"$f":"F38*N7","v":0},null,null,null,null,null,null,{"$f":"IFERROR(INDEX($A$3:$A$75, SMALL(IF(ISBLANK(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))), \"\", ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\")))-MIN(ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))))+1), ROW(A36))),\"\")","v":"Whisky Light    15 - 25 ppm"}]
["Chocolate / carafa Type I","800 - 900","850","275","Nøddeagtig og ristet smag",{"$f":"IFERROR(VLOOKUP(Malt!$A39,BrewReport!$A$9:$C$18,3,FALSE),0)","v":0},{"$f":"F39*N10","v":0},{"$f":"F39*N16","v":0},{"$f":"F39*N7","v":0},{"$f":"F39*N16","v":0},{"$f":"F39*N9","v":0},null,null,null,null,{"$f":"IFERROR(INDEX($A$3:$A$75, SMALL(IF(ISBLANK(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))), \"\", ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\")))-MIN(ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))))+1), ROW(A37))),\"\")","v":""}]
["Dehusked Chocolate","800",800,"275",null,{"$f":"IFERROR(VLOOKUP(Malt!$A40,BrewReport!$A$9:$C$18,3,FALSE),0)","v":0},{"$f":"F40*N10","v":0},null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($A$3:$A$75, SMALL(IF(ISBLANK(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))), \"\", ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\")))-MIN(ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))))+1), ROW(A38))),\"\")","v":""}]
["Black / carafa Type III","1300","1300","210","Let brændt smag",{"$f":"IFERROR(VLOOKUP(Malt!$A41,BrewReport!$A$9:$C$18,3,FALSE),0)","v":0},{"$f":"F41*N10","v":0},{"$f":"F41*N16","v":0},{"$f":"F41*N7","v":0},{"$f":"F41*N16","v":0},{"$f":"F41*N10","v":0},null,null,null,null,{"$f":"IFERROR(INDEX($A$3:$A$75, SMALL(IF(ISBLANK(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))), \"\", ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\")))-MIN(ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))))+1), ROW(A39))),\"\")","v":""}]
["Dehusked Black / carafa Special type II",1400,1400,"210",null,{"$f":"IFERROR(VLOOKUP(Malt!$A42,BrewReport!$A$9:$C$18,3,FALSE),0)","v":0},{"$f":"F42*N10","v":0},null,null,{"$f":"F42*N16","v":0},null,null,null,null,null,{"$f":"IFERROR(INDEX($A$3:$A$75, SMALL(IF(ISBLANK(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))), \"\", ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\")))-MIN(ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))))+1), ROW(A40))),\"\")","v":""}]
["Wheat Chocolate","900 - 1200","1050","275",null,{"$f":"IFERROR(VLOOKUP(Malt!$A43,BrewReport!$A$9:$C$18,3,FALSE),0)","v":0},{"$f":"F43*N10","v":0},null,{"$f":"F43*N7","v":0},{"$f":"F43*N16","v":0},null,null,null,null,null,{"$f":"IFERROR(INDEX($A$3:$A$75, SMALL(IF(ISBLANK(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))), \"\", ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\")))-MIN(ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))))+1), ROW(A41))),\"\")","v":""}]
["Chocolate Spelt","450 - 650",550,"250",null,{"$f":"IFERROR(VLOOKUP(Malt!$A44,BrewReport!$A$9:$C$18,3,FALSE),0)","v":0},null,null,{"$f":"F44*N16","v":0},null,null,null,null,null,null,{"$f":"IFERROR(INDEX($A$3:$A$75, SMALL(IF(ISBLANK(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))), \"\", ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\")))-MIN(ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))))+1), ROW(A42))),\"\")","v":""}]
["Black of Black","400 - 600",500,"250",null,{"$f":"IFERROR(VLOOKUP(Malt!$A45,BrewReport!$A$9:$C$18,3,FALSE),0)","v":0},{"$f":"F45*N10","v":0},null,null,null,{"$f":"F45*N10","v":0},null,null,null,null,{"$f":"IFERROR(INDEX($A$3:$A$75, SMALL(IF(ISBLANK(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))), \"\", ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\")))-MIN(ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))))+1), ROW(A43))),\"\")","v":""}]
["Hvede Malt",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($A$3:$A$75, SMALL(IF(ISBLANK(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))), \"\", ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\")))-MIN(ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))))+1), ROW(A44))),\"\")","v":""}]
["Wheat",3,3,"310","Fylde og skumstabilitet",{"$f":"IFERROR(VLOOKUP(Malt!$A47,BrewReport!$A$9:$C$18,3,FALSE),0)","v":0},{"$f":"F47*N5","v":0},{"$f":"F47*N5","v":0},null,{"$f":"F47*N16","v":0},{"$f":"F47*N5","v":0},null,null,null,null,{"$f":"IFERROR(INDEX($A$3:$A$75, SMALL(IF(ISBLANK(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))), \"\", ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\")))-MIN(ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))))+1), ROW(A45))),\"\")","v":""}]
["CaraWheat","3 - 5","4","310",null,{"$f":"IFERROR(VLOOKUP(Malt!$A48,BrewReport!$A$9:$C$18,3,FALSE),0)","v":0},{"$f":"F48*N6","v":0},null,null,{"$f":"F48*N15","v":0},null,null,null,null,null,{"$f":"IFERROR(INDEX($A$3:$A$75, SMALL(IF(ISBLANK(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))), \"\", ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\")))-MIN(ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))))+1), ROW(A46))),\"\")","v":""}]
["Wheat Light","15 - 20","17","325",null,{"$f":"IFERROR(VLOOKUP(Malt!$A49,BrewReport!$A$9:$C$18,3,FALSE),0)","v":0},{"$f":"F49*N7","v":0},null,{"$f":"F49*N2","v":0},{"$f":"F49*N16","v":0},null,null,null,null,null,{"$f":"IFERROR(INDEX($A$3:$A$75, SMALL(IF(ISBLANK(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))), \"\", ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\")))-MIN(ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))))+1), ROW(A47))),\"\")","v":""}]
["Wheat Dark",15,15,325,null,{"$f":"IFERROR(VLOOKUP(Malt!$A50,BrewReport!$A$9:$C$18,3,FALSE),0)","v":0},{"$f":"F50*N8","v":0},null,{"$f":"F50*N3","v":0},null,null,null,null,null,null,{"$f":"IFERROR(INDEX($A$3:$A$75, SMALL(IF(ISBLANK(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))), \"\", ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\")))-MIN(ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))))+1), ROW(A48))),\"\")","v":""}]
["Wheat Munich","20 - 30",25,325,null,{"$f":"IFERROR(VLOOKUP(Malt!$A51,BrewReport!$A$9:$C$18,3,FALSE),0)","v":0},{"$f":"F51*N5","v":0},null,{"$f":"F51*N4","v":0},null,{"$f":"F51*N5","v":0},null,null,null,null,{"$f":"IFERROR(INDEX($A$3:$A$75, SMALL(IF(ISBLANK(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))), \"\", ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\")))-MIN(ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))))+1), ROW(A49))),\"\")","v":""}]
["Wheat Chit","3 - 7",5,"325",null,{"$f":"IFERROR(VLOOKUP(Malt!$A52,BrewReport!$A$9:$C$18,3,FALSE),0)","v":0},{"$f":"F52*N7","v":0},null,null,null,{"$f":"F52*N12","v":0},null,null,null,null,{"$f":"IFERROR(INDEX($A$3:$A$75, SMALL(IF(ISBLANK(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))), \"\", ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\")))-MIN(ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))))+1), ROW(A50))),\"\")","v":""}]
["Wheat Spelt","3 - 7",5,"300","Sødlig nøddeagtig og krydret, jordagtig smag",{"$f":"IFERROR(VLOOKUP(Malt!$A53,BrewReport!$A$9:$C$18,3,FALSE),0)","v":0},{"$f":"F53*N15","v":0},{"$f":"F53*N16","v":0},{"$f":"F53*N16","v":0},null,null,null,null,null,null,{"$f":"IFERROR(INDEX($A$3:$A$75, SMALL(IF(ISBLANK(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))), \"\", ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\")))-MIN(ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))))+1), ROW(A51))),\"\")","v":""}]
["Special Malt",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($A$3:$A$75, SMALL(IF(ISBLANK(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))), \"\", ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\")))-MIN(ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))))+1), ROW(A52))),\"\")","v":""}]
["Amber","80 - 110","95","290",null,{"$f":"IFERROR(VLOOKUP(Malt!$A55,BrewReport!$A$9:$C$18,3,FALSE),0)","v":0},{"$f":"F55*N10","v":0},null,{"$f":"F55*N7","v":0},{"$f":"F55*N16","v":0},null,null,null,null,null,{"$f":"IFERROR(INDEX($A$3:$A$75, SMALL(IF(ISBLANK(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))), \"\", ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\")))-MIN(ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))))+1), ROW(A53))),\"\")","v":""}]
["Biscuit","45 - 70","55","300","Kiksesmag, svag smag af black og chokolade",{"$f":"IFERROR(VLOOKUP(Malt!$A56,BrewReport!$A$9:$C$18,3,FALSE),0)","v":0},{"$f":"F56*N10","v":0},{"$f":"F56*N16","v":0},null,{"$f":"F56*N16","v":0},{"$f":"F56*N9","v":0},null,null,null,null,{"$f":"IFERROR(INDEX($A$3:$A$75, SMALL(IF(ISBLANK(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))), \"\", ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\")))-MIN(ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))))+1), ROW(A54))),\"\")","v":""}]
["Arome",100,100,"300","Blød bitterhed",{"$f":"IFERROR(VLOOKUP(Malt!$A57,BrewReport!$A$9:$C$18,3,FALSE),0)","v":0},{"$f":"F57*N10","v":0},{"$f":"F57*N16","v":0},{"$f":"F57*N7","v":0},null,{"$f":"F57*N7","v":0},null,null,null,null,{"$f":"IFERROR(INDEX($A$3:$A$75, SMALL(IF(ISBLANK(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))), \"\", ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\")))-MIN(ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))))+1), ROW(A55))),\"\")","v":""}]
["Melano Light",40,40,"310","Intens maltsmag og fylde",{"$f":"IFERROR(VLOOKUP(Malt!$A58,BrewReport!$A$9:$C$18,3,FALSE),0)","v":0},{"$f":"F58*N10","v":0},{"$f":"F58*N16","v":0},null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($A$3:$A$75, SMALL(IF(ISBLANK(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))), \"\", ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\")))-MIN(ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))))+1), ROW(A56))),\"\")","v":""}]
["Melano",80,80,"310","Intens maltsmag og fylde",{"$f":"IFERROR(VLOOKUP(Malt!$A59,BrewReport!$A$9:$C$18,3,FALSE),0)","v":0},{"$f":"F59*N10","v":0},{"$f":"F59*N17","v":0},{"$f":"F59*N7","v":0},{"$f":"F59*N16","v":0},{"$f":"F59*N9","v":0},null,null,null,null,{"$f":"IFERROR(INDEX($A$3:$A$75, SMALL(IF(ISBLANK(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))), \"\", ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\")))-MIN(ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))))+1), ROW(A57))),\"\")","v":""}]
["Boghvede / Buckwheat","4 - 6","5","275","Malt og nøddeagtig smag. Glutenfri",{"$f":"IFERROR(VLOOKUP(Malt!$A60,BrewReport!$A$9:$C$18,3,FALSE),0)","v":0},null,{"$f":"F60*N17","v":0},{"$f":"F60*N13","v":0},null,{"$f":"F60*42","v":0},null,null,null,null,{"$f":"IFERROR(INDEX($A$3:$A$75, SMALL(IF(ISBLANK(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))), \"\", ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\")))-MIN(ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))))+1), ROW(A58))),\"\")","v":""}]
["Sauer / Acid","3.0 - 7",5,"220","Rund og stabil smag",{"$f":"IFERROR(VLOOKUP(Malt!$A61,BrewReport!$A$9:$C$18,3,FALSE),0)","v":0},{"$f":"F61*N10","v":0},{"$f":"F61*N17","v":0},{"$f":"F61*N9","v":0},{"$f":"F61*N7","v":0},{"$f":"F61*32","v":0},null,null,null,null,{"$f":"IFERROR(INDEX($A$3:$A$75, SMALL(IF(ISBLANK(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))), \"\", ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\")))-MIN(ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))))+1), ROW(A59))),\"\")","v":""}]
["Chateau Diastatic","3,5 - 4,5","4","275","Enzymer. Hæver udbyttet",{"$f":"IFERROR(VLOOKUP(Malt!$A62,BrewReport!$A$9:$C$18,3,FALSE),0)","v":0},null,null,null,null,{"$f":"F62*N9","v":0},null,null,null,null,{"$f":"IFERROR(INDEX($A$3:$A$75, SMALL(IF(ISBLANK(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))), \"\", ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\")))-MIN(ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))))+1), ROW(A60))),\"\")","v":""}]
["Abbey",45,45,"280","Stærkere smag af kogt brød, nødder og frugt",{"$f":"IFERROR(VLOOKUP(Malt!$A63,BrewReport!$A$9:$C$18,3,FALSE),0)","v":0},{"$f":"F63*N10","v":0},{"$f":"F63*N16","v":0},{"$f":"F63*N2","v":0},null,{"$f":"F63*N7","v":0},null,null,null,null,{"$f":"IFERROR(INDEX($A$3:$A$75, SMALL(IF(ISBLANK(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))), \"\", ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\")))-MIN(ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))))+1), ROW(A61))),\"\")","v":""}]
["Peated / Røg","5 - 10","7","310",null,{"$f":"IFERROR(VLOOKUP(Malt!$A64,BrewReport!$A$9:$C$18,3,FALSE),0)","v":0},{"$f":"F64*N10","v":0},{"$f":"F64*N16","v":0},{"$f":"F64*N5","v":0},{"$f":"F64*N15","v":0},{"$f":"F64*N9","v":0},null,null,null,null,{"$f":"IFERROR(INDEX($A$3:$A$75, SMALL(IF(ISBLANK(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))), \"\", ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\")))-MIN(ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))))+1), ROW(A62))),\"\")","v":""}]
["Oat","2 - 4","3","310","Brødsmag, blødhed og fylde. Husk at koge det inden mæskning.",{"$f":"IFERROR(VLOOKUP(Malt!$A65,BrewReport!$A$9:$C$18,3,FALSE),0)","v":0},null,{"$f":"F65*N17","v":0},null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($A$3:$A$75, SMALL(IF(ISBLANK(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))), \"\", ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\")))-MIN(ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))))+1), ROW(A63))),\"\")","v":""}]
["Rye","4 - 10","7","240","Lidt rug smag og kompleksitet",{"$f":"IFERROR(VLOOKUP(Malt!$A66,BrewReport!$A$9:$C$18,3,FALSE),0)","v":0},{"$f":"F66*N9","v":0},{"$f":"F66*N15","v":0},{"$f":"F66*N8","v":0},null,{"$f":"F66*N10","v":0},null,null,null,null,{"$f":"IFERROR(INDEX($A$3:$A$75, SMALL(IF(ISBLANK(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))), \"\", ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\")))-MIN(ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))))+1), ROW(A64))),\"\")","v":""}]
["Barley Chit","3 - 7",5,"270","Rig og tør kornagtig smag, Stabilt skum",{"$f":"IFERROR(VLOOKUP(Malt!$A67,BrewReport!$A$9:$C$18,3,FALSE),0)","v":0},{"$f":"F67*N7","v":0},null,null,null,{"$f":"F67*N12","v":0},null,null,null,null,{"$f":"IFERROR(INDEX($A$3:$A$75, SMALL(IF(ISBLANK(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))), \"\", ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\")))-MIN(ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))))+1), ROW(A65))),\"\")","v":""}]
["Barley Flaked","3 - 7",5,270,"Rig og tør kornagtig smag, Stabilt skum",{"$f":"IFERROR(VLOOKUP(Malt!$A68,BrewReport!$A$9:$C$18,3,FALSE),0)","v":0},{"$f":"F68*N8","v":0},{"$f":"F68*N16","v":0},null,{"$f":"F68*N16","v":0},null,null,null,null,null,{"$f":"IFERROR(INDEX($A$3:$A$75, SMALL(IF(ISBLANK(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))), \"\", ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\")))-MIN(ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))))+1), ROW(A66))),\"\")","v":""}]
["Corn Flaked","1,5","1,5","310","Let smag",{"$f":"IFERROR(VLOOKUP(Malt!$A69,BrewReport!$A$9:$C$18,3,FALSE),0)","v":0},{"$f":"F69*N8","v":0},{"$f":"F69*N16","v":0},null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($A$3:$A$75, SMALL(IF(ISBLANK(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))), \"\", ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\")))-MIN(ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))))+1), ROW(A67))),\"\")","v":""}]
["Oat Flaked","3 - 7",5,"310","Brødsmag, blødhed og fylde. Husk pause i mæskningen.",{"$f":"IFERROR(VLOOKUP(Malt!$A70,BrewReport!$A$9:$C$18,3,FALSE),0)","v":0},{"$f":"F70*N8","v":0},{"$f":"F70*N16","v":0},{"$f":"F70*N16","v":0},null,{"$f":"F70*32","v":0},null,null,null,null,{"$f":"IFERROR(INDEX($A$3:$A$75, SMALL(IF(ISBLANK(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))), \"\", ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\")))-MIN(ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))))+1), ROW(A68))),\"\")","v":""}]
["Torrefied Oat Flakes","2,8 - 5","4","300","Forbedrer mundfylden og skummet",{"$f":"IFERROR(VLOOKUP(Malt!$A71,BrewReport!$A$9:$C$18,3,FALSE),0)","v":0},null,{"$f":"F71*N16","v":0},null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($A$3:$A$75, SMALL(IF(ISBLANK(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))), \"\", ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\")))-MIN(ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))))+1), ROW(A69))),\"\")","v":""}]
["Wheat Flaked","3,0 - 7,0",5,"290","Stabilt skum",{"$f":"IFERROR(VLOOKUP(Malt!$A72,BrewReport!$A$9:$C$18,3,FALSE),0)","v":0},{"$f":"F72*N8","v":0},{"$f":"F72*N7","v":0},{"$f":"F72*N12","v":0},null,null,null,null,null,null,{"$f":"IFERROR(INDEX($A$3:$A$75, SMALL(IF(ISBLANK(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))), \"\", ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\")))-MIN(ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))))+1), ROW(A70))),\"\")","v":""}]
["Rice Flaked","0","0","270","Masser af stivelse, øger alkohol%",{"$f":"IFERROR(VLOOKUP(Malt!$A73,BrewReport!$A$9:$C$18,3,FALSE),0)","v":0},{"$f":"F73*N8","v":0},{"$f":"F73*N16","v":0},{"$f":"F73*38","v":0},{"$f":"F73*N7","v":0},null,null,null,null,null,{"$f":"IFERROR(INDEX($A$3:$A$75, SMALL(IF(ISBLANK(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))), \"\", ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\")))-MIN(ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))))+1), ROW(A71))),\"\")","v":""}]
["Whisky            30 - 45 ppm","30 - 45",38,"300","Tørv- og røgsmag",{"$f":"IFERROR(VLOOKUP(Malt!$A74,BrewReport!$A$9:$C$18,3,FALSE),0)","v":0},null,{"$f":"F74*N16","v":0},{"$f":"F74*N7","v":0},null,null,null,null,null,null,{"$f":"IFERROR(INDEX($A$3:$A$75, SMALL(IF(ISBLANK(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))), \"\", ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\")))-MIN(ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))))+1), ROW(A72))),\"\")","v":""}]
["Whisky Light    15 - 25 ppm","15 - 25",20,"300","Tørv- og røgsmag",{"$f":"IFERROR(VLOOKUP(Malt!$A75,BrewReport!$A$9:$C$18,3,FALSE),0)","v":0},null,{"$f":"F75*N16","v":0},null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($A$3:$A$75, SMALL(IF(ISBLANK(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))), \"\", ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\")))-MIN(ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))))+1), ROW(A73))),\"\")","v":""}]
["Ialt",null,null,null,null,{"$f":"SUM(F3:F75)","v":5.5},110,104.5,88,104.5,99,null,null,null,null,{"$f":"IFERROR(INDEX($A$3:$A$75, SMALL(IF(ISBLANK(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))), \"\", ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\")))-MIN(ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))))+1), ROW(A69))),\"\")","v":""}]
["Valsning og håndtering",null,null,null,null,null,28,0,20,{"$f":"2 * (F77/1000)","v":0},25,null,null,null,null,{"$f":"IFERROR(INDEX($A$3:$A$75, SMALL(IF(ISBLANK(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))), \"\", ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\")))-MIN(ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))))+1), ROW(A70))),\"\")","v":""}]
["Forsendelse uden omdeling (Post dk) (<=10kg)","Tast 1 for at vælge fragt >",null,1,null,null,{"$f":"IF(D78=1,59,0)","v":59},{"$f":"IF(D78=1,30,0)","v":30},{"$f":"IF(D78=1,55,0)","v":55},{"$f":"IF(D78=1,49,0)","v":49},{"$f":"IF(D78=1,60,0)","v":60},null,null,null,null,{"$f":"IFERROR(INDEX($A$3:$A$75, SMALL(IF(ISBLANK(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))), \"\", ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\")))-MIN(ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))))+1), ROW(A71))),\"\")","v":""}]
["Ialt",null,null,null,null,null,{"$f":"SUM(G76:G78)","v":197},{"$f":"SUM(H76:H78)","v":134.5},163,153.5,184,null,null,null,null,{"$f":"IFERROR(INDEX($A$3:$A$75, SMALL(IF(ISBLANK(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))), \"\", ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\")))-MIN(ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))))+1), ROW(A72))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($A$3:$A$75, SMALL(IF(ISBLANK(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))), \"\", ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\")))-MIN(ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$80\"))))+1), ROW(A73))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($A$3:$A$75, SMALL(IF(ISBLANK(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$79\"))), \"\", ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$79\")))-MIN(ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$79\"))))+1), ROW(A74))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(#REF!, SMALL(IF(ISBLANK(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$79\"))), \"\", ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$79\")))-MIN(ROW(INDIRECT(CONCATENATE(\"$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$3:$\",HLOOKUP(BrewReport!$E$7,$G$1:$K$2,2,FALSE),\"$79\"))))+1), ROW(#REF!))),\"\")","v":""}]

{"sheet":"Tilsætninger","index":5,"n_rows":17,"n_cols":5,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["Tilsætninger","EBC","EBC Avg.","Udbytte"]
["Sukker",0,0,440]
["Rørsukker","20 - 30",25,420]
["Farin","50 - 75",65,420]
["Muscovado Sukker","80 - 120",100,400]
["Mørk Kandis","80 - 120",80,375]
["Lys Kandis",0,0,375]
["Dansk Honning",40,40,375]
["Appelsinskal",0,0,0]
["Koriander",0,0,0]
["Stjerneanis",0,0,0]
["Kanel",0,0,0]
["Lakrids",0,100,0,"Estimat"]
["Lakridsrod",0,0,0]
["Chili Flakes",0,0,0]
["Ege Chips",0,0,0]
["Klar Urt",0,0,0]

{"sheet":"Gær","index":6,"n_rows":64,"n_cols":10,"rows_kept":64,"cut":false,"hidden":false,"merged":[[61,2,61,5],[63,2,63,5]]}
["Gær Navn","Beskrivelse","Flocculation","Attenuation %","Attenuation Avg.","Temp. Range °C","Alc. Tolerance %",null,"Temp.(°C)","CO2"]
[null,null,null,null,null,null,null,null,0,1.71]
["Wyeast XL1007 German Ale",null,"Low","73 - 77",75,"13 - 20",11,null,1,1.66]
["Wyeast XL1010 American Wheat",null,"Low","74 - 78",76,"14 - 23",10,null,2,1.61]
["Wyeast XL1028 London Ale",null,"Low - Medium","73 - 77",75,"15 - 22",11,null,3,1.56]
["Wyeast XL1056 American Ale","Well balanced. Ferments dry, finishes soft.","Low - Medium","73 - 77",75,"15 - 22",11,null,4,1.51]
["Wyeast XL1084 Irish Ale",null,"Medium","71 - 75",73,"16 - 22",12,null,5,1.46]
["Wyeast XL1098 British Ale",null,"Medium","73 - 75",74,"18 - 22",10,null,6,1.39]
["Wyeast XL1099 Whitbread Ale",null,"Medium - High","68 - 72",70,"18 - 24",10,null,7,1.32]
["Wyeast XL1187 Ringwood Ale","A malty, complex profile that clears well.","High","68 - 72",70,"18 - 23",10,null,8,1.28]
["Wyeast XL1214 Belgian Abbey",null,"Low - Medium","74 - 78",76,"20 - 24",12,null,9,1.24]
["Wyeast XL1272 American Ale II","Slightly nutty, soft, clean and tart finish.","Medium","72 - 76",74,"15 - 22",10,null,10,1.2]
["Wyeast XL1275 Thames Valley Ale",null,"Low - Medium","72 - 76",74,"16 - 22",10,null,11,1.17]
["Wyeast XL1318 London Ale III",null,"High","71 - 75",73,"18 - 23",10,null,12,1.1299999999999999]
["Wyeast XL1332 Northwest Ale","Malty, mildly fruity, good depth and complexity.","High","67 - 71",69,"18 - 24",10,null,13,1.0900000000000001]
["Wyeast XL1335 British Ale II",null,"High","73 - 76",74,"17 - 24",10,null,14,1.05]
["Wyeast XL1388 Belgian Strong Ale",null,"Low","74 - 78",76,"18 - 27",13,null,15,1.02]
["Wyeast XL1450 Denny's Favorite 50","Accentuates malt, caramel, or fruit character.","Low","74 - 76",75,"15 - 21",10,null,16,0.99]
["Wyeast XL1469 West Yorkshire Ale",null,"High","67 - 71",69,"18 - 22",9,null,17,0.95]
["Wyeast XL1728 Scottish Ale",null,"High","69 - 73",71,"13 - 24",12,null,18,0.91]
["Wyeast XL1762 Belgian Abbey II",null,"Medium","73 - 77",75,"18 - 24",12,null,19,0.89]
["Wyeast XL1968 London ESB Ale",null,"Very High","67 - 71",69,"18 - 22",9,null,20,0.88]
["Wyeast XL2000 Budvar Lager",null,"Medium - High","71 - 75",73,"9 - 13",9,null,21,0.85]
["Wyeast XL2001 Urquell Lager",null,"Medium - High","72 - 76",74,"9 - 13",9,null,22,0.83]
["Wyeast XL2007 Pilsen Lager",null,"Medium","71 - 75",73,"9 - 13",9,null,23,0.81]
["Wyeast XL2035 American Lager",null,"Medium","73 - 77",75,"9 - 14",9,null,24,0.78]
["Wyeast XL2042 Danish Lager",null,"Low","73 - 77",75,"8 - 13",9,null,25,0.76]
["Wyeast XL2112 California Lager",null,"High","67 - 71",69,"14 - 20",9,null,26,0.74]
["Wyeast XL2124 Bohemian Lager",null,"Low - Medium","73 - 77",75,"8 - 22",9,null,27,0.73]
["Wyeast XL2206 Bavarian Lager",null,"Medium - High","73 - 77",75,"8 - 14",9]
["Wyeast XL2278 Czech Pils",null,"Medium - High","70 - 74",72,"10 - 14",9]
["Wyeast XL2308 Munich Lager",null,"Medium","70 - 74",72,"9 - 13",9]
["Wyeast XL2565 Kölsch",null,"Low","73 - 77",75,"13 - 21",10]
["Wyeast XL2633 Octoberfest Lager Blend",null,"Low - Medium","73 - 77",75,"9 - 14",9]
["Wyeast XL3056 Bavarian Wheat Blend",null,"Medium","73 - 77",75,"18 - 23",10]
["Wyeast XL3068 Weihenstephan Weizen",null,"Low","73 - 77",75,"18 - 24",10]
["Wyeast XL3278 Belgian Lambic Blend",null,"Variable","70 - 80",75,"17 - 24",11]
["Wyeast XL3333 German Wheat",null,"High","70 - 76",73,"17 - 24",10]
["Wyeast XL3463 Forbidden Fruit",null,"Low","72 - 76",74,"17 - 24",12]
["Wyeast XL3522 Belgian Ardennes",null,"High","72 - 76",74,"18 - 24",12]
["Wyeast XL3638 Bavarian Wheat",null,"Low","70 - 76",73,"18 - 24",10]
["Wyeast XL3711 French Saison",null,"Low","77 - 83",80,"18 - 25",12]
["Wyeast XL3724 Belgian Saison",null,"Low","76 - 80",78,"21 - 35",12]
["Wyeast XL3763 Roeselare Ale Blend",null,"Variable",80,80,"18 - 30",11]
["Wyeast XL3787 Trappist High Gravity",null,"Medium","74 - 78",76,"18 - 25",12]
["Wyeast XL3942 Belgian Wheat",null,"Medium","72 - 76",74,"18 - 23",12]
["Wyeast XL3944 Belgian Witbier",null,"Medium","72 - 76",74,"16 - 24",12]
["Mangrove Jack's Bohemian Lager M84","Denne gær giver en blød, delikat og velafbalanceret øl, med en tør og ren smag.","High","High",77,"10 - 15"]
["Mangrove Jack's California Lager M54","Producer en ren og klar pilsneraroma, uden de frygtede bismage. Gæren er perfekt til de fleste undergærede øltyper.","Medium - High","77 - 82",80,"18 - 20",8.5]
["Mangrove Jack's Belgian Abbey Ale M47","Den har en fantastisk og kraftig frugtaroma, balanceret perfekt med en mild og let krydret aroma, og komplekse og lækre krydrede phenoler.","Medium - High","73 - 77",75,"18 - 25",12]
["Mangrove Jack's Bavarian Wheat M20","Giver fine velafbalancerede estere med krydrede aromaer.","Low","Medium",74,"18 - 30"]
["Mangrove Jack's Belgian Ale M27","Meget karakterfuld ølgær med krydrede, frugtige og pebrede noter.","Medium","Very High",90,"26 - 32",14]
["Mangrove Jack's Liberty Bell Ale M36","Ren, neutral og rund I smagen, let pæreagtig aroma, med lidt jordbær eller kiwi blandet i. Rene klare maltaromaer, og med en evne til at fremhæve humlearomaerne","Medium - High","74 - 78",76,"18 - 23",10]
["Mangrove Jack´s French Saison M29","Meget karakterfuld ølgær med krydrede, frugtige og pebrede noter.","Medium","Very High",83,"26 - 32",14]
["Mangrove Jack´s New World Strong Ale M42","Gæren har en neutral gæraroma for at sikre, den fulde karakter af malt og humle er fremtrædende i hver øl. Giver en meget klar øl, da gærrester lægger sig fast i bunden og blander sig ikke ved uro i væsken.","Very High","High\n77 - 82",79,"16 - 22"]
["Mangrove Jack's Newcastle Dark Ale M03","Fremmer krop og smag. Gæren giver en fyldig mørk frugt variation.","Medium","Medium",74,"18 - 22"]
["Mangrove Jack's US West Coast M44","Denne gær giver en usædvanlig ren smag, ideel til at humlekarakteren kommer tydelig frem. Citrus og fyrresmag i humle vil blive fremhævet.","High","High",77,"18 - 23"]
["Mangrove Jack's Workhorse M10","Neutral og ren aroma, der er velegnet til alle øltyper. Imiterer lagerøl karakteristika.","Medium","High",75,"15 - 32"]
[]
[]
[]
[null,null,"https://www.wyeastlab.com/hb_yeaststrain.cfm"]
[]
[null,null,"http://mangrovejacks.com/collections/craft-series-yeasts"]

{"sheet":"Humle","index":7,"n_rows":38,"n_cols":24,"rows_kept":38,"cut":false,"hidden":false,"merged":[[37,0,37,3],[36,12,36,18],[36,19,36,28],[2,13,2,23],[2,12,5,12],[34,12,34,18],[0,15,1,23],[0,12,1,14],[34,19,34,28],[3,13,5,13],[3,14,5,14],[3,15,5,15],[3,16,5,16],[3,17,5,17],[3,18,5,18],[3,19,5,19],[3,20,5,20],[3,21,5,21],[3,22,5,22],[3,23,5,23]]}
["Humletyper","Blomst / Pellet","Alfa Range %","IBU Avg.","Beta Range %","Co-humulione %","Usage","Brewing usage","Used in","Aroma","Substitutes",null,"Glenn Tinseth's website",null,null,"Decimal Alpha Acid Utilization vs. Boil Time and Wort Original Gravity"]
[null,null,null,null,null,null,"B/A"]
["Admiral","B / P","13,0 - 16,0",14,"4,0 - 6,0","37 - 45","Ba","A high alpha hop with balanced bitterness and an acceptable aroma profile; mainly bittering, but a versatile replacement for both high alpha and dual purpose varieties","English-style Ale","Pleasant, resinous hop aroma with hints of citrus (orange) and herbal flavors","Target, Northdown, Challenger",null,"Boil Time (min)","Original Gravity"]
["Amarillo","P","8,0 - 11,0",8.5,"6,0 - 7,0","21 - 24","BA","Unknown origin, but character similar to Cascade. Used for both bitterness and aroma","IPAs, Ales","Floral, tropical, and citrus (lemon, orange and grapefruit)","Cascade, Centennial, Simcoe",null,null,1.03,1.04,1.05,1.06,1.07,1.08,1.0900000000000001,1.1000000000000001,1.1100000000000001,1.1200000000000001,1.1299999999999999]
["Bobek","P","3,5 - 7,0",5,"4 - 6,1","27 - 31","A","Bobek is a diploid hybrid between Northern Brewer and a TG seedling of unknown origin.","Belgian Ales and Lagers, ESBs, and Pilsners.","Noble aroma of delicate spicy, floral, and piney notes.","Styrian Golding, UK or US Fuggle, Willamette"]
["Bramling X","B","5,0 - 7,8",4.3,"2,3 - 3,5",34,"A","Developed in 1927 from commercial Goldings and wild hop variety.","ESB, Bitters, Pale Ale","Mild, fruity, currant aroma.","East Kent Goldings, Progress, Whitbred"]
["Brewer's Gold","B / P","5,5 - 10,0",5.8,"3,5 - 4,5","37 - 40","B","Traditional bittering hop. An English variety and sibling of Bullion","English ales and heavy German lagers.","Spicy, fruity characteristics, black currant","Northern Brewer, Galena, Chinook, Eroica, Nugget",null,0,0,0,0,0,0,0,0,0,0,0,0]
["Cascade","B / P","4,5 - 7,0",6.3,"4,5 - 7,0","33 - 40","BA","A hop with Northern Brewers Heritage","American ales and lagers","Strong spicy, floral, grapefruit character","Centennial",null,3,3.4000000000000002E-2,3.1E-2,2.9000000000000001E-2,2.5999999999999999E-2,2.4E-2,2.1999999999999999E-2,0.02,1.7999999999999999E-2,1.7000000000000001E-2,1.4999999999999999E-2,1.4E-2]
["Centennial","B / P","9,5 - 11,5",9.1999999999999993,"3,5 - 4,5","28 - 30","BA","General purpose bittering, aroma. Derived from 3/4 Brewer's Gold and contributions of Fuggle, East Kent Golding and others","American ales and Wheats","Floral, citrus aroma, spicy, clean bittering flavor","Cascade, Chinook, Columbus, Galena, Eroica, Nugget, Bullion",null,6,6.5000000000000002E-2,5.8999999999999997E-2,5.3999999999999999E-2,4.9000000000000002E-2,4.4999999999999998E-2,4.1000000000000002E-2,3.7999999999999999E-2,3.5000000000000003E-2,3.2000000000000001E-2,2.9000000000000001E-2,2.5999999999999999E-2]
["Challenger","P","6,5 - 9,0",6.9,"3,2 - 4,2","20 - 25","BA","Variant of Northern Brewers heritage \nUsed for: Both aroma and bittering","Ales and lagers","Fruity in flavor, spicy aroma, blends well",null,null,9,9.1999999999999998E-2,8.4000000000000005E-2,7.6999999999999999E-2,7.0000000000000007E-2,6.4000000000000001E-2,5.8999999999999997E-2,5.3999999999999999E-2,4.9000000000000002E-2,4.4999999999999998E-2,4.1000000000000002E-2,3.6999999999999998E-2]
["Chinook","P","12,0 - 14,0",13,"3,0 - 4,0","29 - 34","Ba","Strong versatile bittering hop, but also acceptable aroma","Ales, porters, stouts","Heavy and spicy aroma. Distinct, medium intensity spice and pine characteristics with subtle notes of grapefruit","Columbus, Northern Brewer, Galena, Eroica, Nugget, Bullion",null,12,0.11600000000000001,0.106,9.7000000000000003E-2,8.7999999999999995E-2,8.1000000000000003E-2,7.3999999999999996E-2,6.8000000000000005E-2,6.2E-2,5.6000000000000001E-2,5.1999999999999998E-2,4.7E-2]
["Citra","P","9,0 - 13,0",9.5,"3,5 - 4,5","22 - 24","A","Special aroma hops.\nComprised of Hallertau Mittelfrüh, US Tettnang, Brewer's Gold and East Kent Golding. Released in 2007","IPAs","Strong citrus and tropical tones of grapefruit, melon, lime, gooseberry, passion fruit and lychee",null,null,15,0.13700000000000001,0.125,0.114,0.105,9.6000000000000002E-2,8.6999999999999994E-2,0.08,7.2999999999999995E-2,6.7000000000000004E-2,6.0999999999999999E-2,5.6000000000000001E-2]
["Columbus","P","14,0 - 16,0",13.8,"4,0 - 5,0","30 - 35","B","High alpha bittering hops. Engineered Centennial Substitute, a descendant of Nugget","Pale Ale","Pungent, black pepper, licorice characteristics with subtle citrus overtones","Chinook, Northern Brewer, Nugget, Galena\nU.K. Target",null,18,0.156,0.14199999999999999,0.13,0.11899999999999999,0.109,9.9000000000000005E-2,9.0999999999999998E-2,8.3000000000000004E-2,7.5999999999999998E-2,6.9000000000000006E-2,6.3E-2]
["Crystal","P","3,5 - 5,5",4.7,"4,5 - 6,7","20 - 26","A","Aroma and finishing hops","IPAs and Lagers","Clean, mild, floral, pleasant and slightly spicy","Hallertauer, Mount Hood, Hersbrucker",null,21,0.17299999999999999,0.158,0.14399999999999999,0.13200000000000001,0.12,0.11,0.10100000000000001,9.1999999999999998E-2,8.4000000000000005E-2,7.6999999999999999E-2,7.0000000000000007E-2]
["East Kent Golding","P","4,0 - 6,0",5.8,"1,9 - 3,0","25 - 30","A","Defines the English Pale Ales and Ales produced by the region, it is quintessentially English.","English Ale, Porter, Scottish and Irish Ale, Stout, Strong Ale, ESB, Saison, Barleywine","Floral, aromatic, earthy, slightly sweet spicy flavo","First Gold, Fuggles, other Golding varieties, Progress, Target, and Whitbread Golding",null,24,0.187,0.17100000000000001,0.157,0.14299999999999999,0.13100000000000001,0.12,0.109,0.1,9.0999999999999998E-2,8.3000000000000004E-2,7.5999999999999998E-2]
["First Gold","B",null,6.2]
["Fuggles","B / P","3,5 - 6,5",4.9000000000000004,"2,0 - 4,0","27 - 33","BA","General purpose bittering/aroma.\nSelected in 1861 by Richard Fuggle","English Ales, Dark Lagers","Mild wood, soft, grassy, floral aroma","East Kent Goldings, Williamette",null,27,0.20100000000000001,0.183,0.16800000000000001,0.153,0.14000000000000001,0.128,0.11700000000000001,0.107,9.8000000000000004E-2,8.8999999999999996E-2,8.2000000000000003E-2]
["Galena",null,"12,0 - 14,0",13,"7,0 - 9,0","37 - 42","B","General bittering hops. Strong, clean, balanced bittering. ","All beers","Spicy, blackcurrant and citrus (grapefruit) tones","Brewer's Gold, Eroica, Northern Brewer, Nugget, Columbus, Chinook",null,30,0.21199999999999999,0.19400000000000001,0.17699999999999999,0.16200000000000001,0.14799999999999999,0.13500000000000001,0.124,0.113,0.10299999999999999,9.4E-2,8.5999999999999993E-2]
["Golding","P","4,0 - 6,0",5.9,"2,0 - 3,0","20 - 25","BA","Bittering, aroma and finishing.\nEast Kent Golding","British ales, bitters, porters and stouts.","Mild and delicate with sweet floral characteristics","East Kent Goldings, Fuggles, Willamette, Styrian Golding",null,33,0.223,0.20300000000000001,0.186,0.17,0.155,0.14199999999999999,0.13,0.11899999999999999,0.108,9.9000000000000005E-2,9.0999999999999998E-2]
["Hallertau Hersbrucker","B / P","2,0 - 5,0",3.8,"2,5 - 6,0","18 - 25","A","Very good aroma hop","Lager, Pilsner, Bock, Weizen Bock, Wheat, Belgian-Style Ales, Kölsch, Munich Helles","A mild aroma and a low co-humulone content","Strisselspalt, Hallertauter Mittelfruh",null,36,0.23200000000000001,0.21199999999999999,0.19400000000000001,0.17699999999999999,0.16200000000000001,0.14799999999999999,0.13500000000000001,0.124,0.113,0.10299999999999999,9.4E-2]
["Hallertau Mittelfrüh","B / P","3,0 - 5,5",4.0999999999999996,"3,0 - 5,0","18 - 28","A","Mittelfrüh has a traditional\nEuropean aroma and is one of the Noble Hops","German Pilsner, German Style Lagers","A pleasant herbal, grassy and floral aroma","Hersbrucker",null,39,0.24,0.219,0.2,0.183,0.16700000000000001,0.153,0.14000000000000001,0.128,0.11700000000000001,0.107,9.8000000000000004E-2]
["Magnum","B / P","11,0 - 16,0",13.9,"5,0 - 7,0","21 - 29","B","Bittering, no distinct aroma","Ales and Lagers","No distinct aroma","Columbus, Horizon, Nugget, German Magnum",null,42,0.247,0.22600000000000001,0.20599999999999999,0.189,0.17199999999999999,0.158,0.14399999999999999,0.13200000000000001,0.12,0.11,0.10100000000000001]
["Mosaic","P","11,5 - 13,5",11.4,"3,2 - 3,9","24 - 26","A","An excellent aroma variety. Daughter of Simcoe","IPAs","A complex array of tropical fruit, citrus, berry, herbal, earthy and pine characteristics",null,null,45,0.253,0.23200000000000001,0.21199999999999999,0.19400000000000001,0.17699999999999999,0.16200000000000001,0.14799999999999999,0.13500000000000001,0.123,0.113,0.10299999999999999]
["Mount Hood","P","4,0 - 8,0",5.2,"5,0 - 7,5","22 - 27","A","An aroma hop variety with similarities to the German Hallertau and Hersbrucker varieties","Lagers","Mild, herbal and somewhat pungent or spicy","Hallertau Mittelfrüh and Hersbrucker",null,48,0.25900000000000001,0.23699999999999999,0.216,0.19800000000000001,0.18099999999999999,0.16500000000000001,0.151,0.13800000000000001,0.126,0.115,0.105]
["Northern Brewer","B / P","7,0 - 10,0",8.4,"3,5 - 5,0","27 - 33","BA","A true dual purpose hop variety","Ales","Medium intensity, pine and mint characteristics","Chinook, US Northern Brewer, Galena",null,51,0.26400000000000001,0.24099999999999999,0.221,0.20200000000000001,0.184,0.16900000000000001,0.154,0.14099999999999999,0.129,0.11799999999999999,0.108]
["Nugget","B / P","12,0 - 14,5",11.9,"4,0 - 6,0","22 - 26","Ba","Bittering, but gaining acceptance as a dual purpose variety","Barley Wine","Mild and pleasant with spicy, herbal tones","Columbus, Galena, Magnum",null,54,0.26900000000000002,0.246,0.224,0.20499999999999999,0.188,0.17100000000000001,0.157,0.14299999999999999,0.13100000000000001,0.12,0.109]
["Perle","B / P","6,0 - 10,0",7.2,"2,5 - 5,0","28 - 32","BA","Bred from English Northern Brewer. Often used as a dual purpose hop in a variety of applications","Stout","Slightly spicy with herbal and floral characteristics","Northern Brewer, German Northern Brewer, German Perle",null,57,0.27300000000000002,0.249,0.22800000000000001,0.20799999999999999,0.19,0.17399999999999999,0.159,0.14499999999999999,0.13300000000000001,0.121,0.111]
["Saaz","B / P","3,0 - 4,5",3,"3,0 - 4,5","24 - 28","A","The classic \"noble\" aroma hop with long and strong traditions, associated with the renowned pilsner lager","Lagers","Very mild, with pleasant earthy, herbal and floral overtones","US Saaz, Sterling, Polish Lublin",null,60,0.27600000000000002,0.252,0.23100000000000001,0.21099999999999999,0.193,0.17599999999999999,0.161,0.14699999999999999,0.13500000000000001,0.123,0.112]
["Simcoe","P","12,0 - 14,0",11.7,"4,0 - 5,0","15 - 20","BA","Known as a bittering hop with a good aroma. Dual Purpose","IPAs","Unique passionfruit, pine, earth and citrus characteristics","Magnum, Summit",null,70,0.28499999999999998,0.26100000000000001,0.23799999999999999,0.218,0.19900000000000001,0.182,0.16600000000000001,0.152,0.13900000000000001,0.127,0.11600000000000001]
["Styrian Golding","P","2,8 - 5,5",5.3,"2,0 - 3,0","25 - 30","A","A world-renowned aroma hop with widespread usage in both ale and lager brewing","Belgian-style Ales","Very mild, noble hop flavor","Fuggle, Styrian Bobek",null,80,0.29099999999999998,0.26600000000000001,0.24299999999999999,0.222,0.20300000000000001,0.186,0.17,0.155,0.14199999999999999,0.13,0.11899999999999999]
["Target","B / P","8,5 - 13,5",12.2,"4,0 - 5,7",37,"B","An excellent bittering hop that tends to be too harsh for aroma purposes late in the boil","Ale","An intense English hop aroma with distinct spicy, floral, sage and citrus characteristics","Fuggle, Willamette",null,90,0.29499999999999998,0.27,0.247,0.22600000000000001,0.20599999999999999,0.188,0.17199999999999999,0.157,0.14399999999999999,0.13200000000000001,0.12]
["Tettnanger","B / P","3,0 - 6,0",3.5,"3,0 - 5,0","22 - 29","A","Traditional noble aroma hop","Belgian-style Ales","Mild and pleasant with balanced earthy, herbal and floral aroma impressions","Saaz, Hersbrucker, Spalt, Select",null,120,0.30099999999999999,0.27500000000000002,0.252,0.23,0.21,0.192,0.17599999999999999,0.161,0.14699999999999999,0.13400000000000001,0.123]
["Tradition","P","5,0 - 7,0",4.5999999999999996,"4,0 - 5,0","26 - 29","A","Aroma Hop. Imparts beer with a harmonic bitterness","Bock","Medium intense floral and herbal (grassy) tones","Liberty, Hallertau Mittelfrüh"]
["Willamette","P","4,0 - 6,0",5.4,"3,0 - 4,5","30 - 35","A","A quality aroma hop with low alpha content. Triploid seedling of the English Fuggle variety","English-style Ale","Mild and pleasant, with slightly spicy and floral tones","Fuggle, Glacier, Tettnanger, Styrian Golding"]
[null,null,null,null,null,null,null,null,null,null,null,null,"To calculate IBUs, the formula is simple:",null,null,null,null,null,null,"IBUs = decimal alpha acid utilization * mg/l of added alpha acids"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"To calculate the concentration of alpha acids you add to the wort:",null,null,null,null,null,null,"(mg/l of added alpha acids = decimal AA rating * grams hops * 1000) / volume of finished beer in liters"]
["https://www.hopunion.com/hop-varieties/"]

{"sheet":"Typer","index":8,"n_rows":102,"n_cols":19,"rows_kept":102,"cut":false,"hidden":false,"merged":[[1,0,1,1],[0,3,0,18],[0,0,0,2]]}
["Ref.: Beer Judge Certification Program",null,null,"2008 BJCP Style Guidelines"]
["Style #",null,"Style Name","OG high","OG low","FG high","FG low","ABV high","ABV low","EBC high","EBC low","IBU high","IBU low","RBR","CO2 High","CO2 Low","CO2 Avg.","Yeast Type","Brief"]
[]
[1,"A","Lite American Lager",1040,1028,1008,998,4.2,2.8,6,4,12,8,0.34,2.73,2.57,{"$f":"(P4+O4)/2","v":2.65},"Lager"]
[1,"B","Standard American Lager",1050,1040,1010,1004,5.3,4.2,8,4,15,8,0.27,2.73,2.57,2.65,"Lager"]
[1,"C","Premium American Lager",1056,1046,1012,1008,6,4.5999999999999996,12,4,25,15,0.4,2.73,2.57,2.65,"Lager"]
[1,"D","Munich Helles",1051,1045,1012,1008,5.4,4.7,10,6,22,16,0.4,2.68,2.2599999999999998,2.4699999999999998,"Lager"]
[1,"E","Dortmunder Export",1056,1048,1015,1010,6,4.8,12,8,30,23,0.5,2.57,2.57,2.57,"Lager"]
[2,"A","German Pilsner",1050,1044,1013,1008,5.2,4.4000000000000004,10,4,45,25,0.75,2.52,2.52,2.52,"Lager"]
[2,"B","Bohemian Pilsner",1056,1044,1017,1013,5.4,4.2,12,7,45,35,0.74,2.5,2.2999999999999998,2.4,"Lager"]
[2,"C","Classic American Pilsner",1060,1044,1015,1010,6,4.5,12,6,40,25,0.62,2.5,2.2999999999999998,2.4,"Lager"]
[3,"A","Vienna Lager",1052,1046,1014,1010,5.5,4.5,32,20,30,18,0.48,2.6,2.4,2.5,"Lager"]
[3,"B","Oktoberfest",1057,1050,1016,1012,5.7,4.8,28,14,28,20,0.43,2.73,2.57,2.65,"Lager"]
[4,"A","Dark American Lager",1056,1044,1012,1008,6,4.2,43,28,20,8,0.28999999999999998,2.7,2.5,2.6,"Lager"]
[4,"B","Munich Dunkel",1056,1048,1016,1010,5.6,4.5,55,28,28,18,0.43,2.66,2.21,2.4350000000000001,"Lager"]
[4,"C","Schwarzbier",1052,1046,1016,1010,5.4,4.4000000000000004,59,33,32,22,0.53,2.6,2.2000000000000002,2.4000000000000004,"Lager"]
[5,"A","Maibock / Helles Bock",1072,1064,1018,1011,7.4,6.3,22,12,35,23,0.43,2.73,2.16,2.4450000000000003,"Lager"]
[5,"B","Bock",1072,1064,1019,1013,7.2,6.3,43,28,27,20,0.34,2.7,2.2000000000000002,2.4500000000000002,"Lager"]
[5,"C","Doppelbock",1112,1072,1024,1016,10,7,49,12,26,16,0.23,2.62,2.2599999999999998,2.44,"Lager"]
[5,"D","Eisbock",1120,1078,1035,1020,"14+",9,59,35,35,25,0.28000000000000003,2.37,2.37,2.37,"Lager"]
[6,"A","Cream Ale",1055,1042,1012,1006,5.6,4.2,10,5,20,15,0.38,2.7,2.6,2.6500000000000004,"Ale"]
[6,"B","Blonde Ale",1054,1038,1013,1008,5.5,3.8,12,6,28,15,0.47,2.6,2.2999999999999998,2.4500000000000002,"Ale"]
[6,"C","Kölsch",1050,1044,1011,1007,5.2,4.4000000000000004,10,7,30,20,0.55000000000000004,2.73,2.42,2.5750000000000002,"Kölsch"]
[6,"D","American Wheat / Rye",1055,1040,1013,1008,5.5,4,12,6,30,15,0.48,2.6,2.2999999999999998,2.4500000000000002,"Ale"]
[7,"A","Northern German Altbier",1054,1046,1015,1010,5.2,4.5,37,26,40,25,0.63,3.09,2.16,2.625,"Ale"]
[7,"B","California Common",1054,1048,1014,1011,5.5,4.5,28,20,45,30,0.72,2.8,2.4,2.5999999999999996,"Lager"]
[7,"C","Düsseldorf Altbier",1054,1046,1015,1010,5.2,4.5,33,22,50,35,0.83,3.09,2.16,2.625,"Ale"]
[8,"A","Standard Bitter",1040,1032,1011,1007,3.8,3.2,28,8,35,25,0.81,1.3,0.75,1.0249999999999999,"Ale"]
[8,"B","Best Bitter",1048,1040,1012,1008,4.5999999999999996,3.8,32,10,40,25,0.74,1.3,0.75,1.0249999999999999,"Ale"]
[8,"C","Strong Bitter",1060,1048,1015,1010,6.2,4.5999999999999996,35,12,50,30,0.73,1.3,0.75,1.0249999999999999,"Ale"]
[9,"A","Scottish Light",1035,1030,1013,1010,3.2,2.5,33,18,20,10,0.4,1.3,0.75,1.0249999999999999,"Ale"]
[9,"B","Scottish Heavy",1040,1035,1015,1010,3.9,3.2,33,18,25,10,0.42,1.3,0.75,1.0249999999999999,"Ale"]
[9,"C","Scottish Export",1054,1040,1016,1010,5,3.9,33,18,30,15,0.45,1.3,0.75,1.0249999999999999,"Ale"]
[9,"D","Irish Red Ale",1060,1044,1014,1010,6,4,35,18,28,17,0.43,2.2999999999999998,1.5,1.9,"Ale"]
[9,"E","Strong Scotch Ale",1130,1070,1056,1018,10,6.5,49,28,35,17,0.22,2.2999999999999998,1.5,1.9,"Ale"]
[10,"A","American Pale Ale",1060,1045,1015,1010,6.2,4.5,28,10,45,30,0.71,2.78,2.2599999999999998,{"$f":"(P36+O36)/2","v":2.5199999999999996},"Ale"]
[10,"B","American Amber Ale",1060,1045,1015,1010,6.2,4.5,33,20,40,25,0.61,2.78,2.2599999999999998,2.5199999999999996,"Ale"]
[10,"C","American Brown Ale",1060,1045,1016,1010,6.2,4.3,69,35,40,20,0.56000000000000005,2.5,1.5,2,"Ale"]
[11,"A","Mild Ale",1038,1030,1013,1008,4.5,2.8,49,24,25,10,0.47,2,1.3,1.65,"Ale"]
[11,"B","Southern English Brown Ale",1042,1033,1014,1011,4.0999999999999996,2.8,69,37,20,12,0.38,2.2999999999999998,1.5,1.9,"Ale"]
[11,"C","Northern English Brown Ale",1052,1040,1013,1008,5.4,4.2,43,24,30,20,0.54,2.2999999999999998,1.5,1.9,"Ale"]
[12,"A","Brown Porter",1052,1040,1014,1008,5.4,4,59,39,35,18,0.56999999999999995,2.5,1.7,2.1,"Ale"]
[12,"B","Robust Porter",1065,1048,1016,1012,6.5,4.8,69,43,50,25,0.65,2.5,1.8,2.15,"Ale"]
[12,"C","Baltic Porter",1090,1060,1024,1016,9.5,5.5,59,33,40,20,0.38,2.5,1.8,2.15,"Ale"]
[13,"A","Dry Stout",1050,1036,1011,1007,5,4,79,49,45,30,0.89,2,1.6,1.8,"Ale"]
[13,"B","Sweet Stout",1060,1044,1024,1012,6,4,79,59,40,20,0.51,2.4,2,2.2000000000000002,"Ale"]
[13,"C","Oatmeal Stout",1065,1048,1018,1010,5.9,4.2,79,43,40,25,0.56000000000000005,2.4,2,2.2000000000000002,"Ale"]
[13,"D","Foreign Extra Stout",1075,1056,1018,1010,8,5.5,79,59,70,30,0.77,2.6,2.2999999999999998,2.4500000000000002,"Ale"]
[13,"E","American Stout",1075,1050,1022,1010,7,5,79,59,75,35,0.85,2.6,2.2999999999999998,2.4500000000000002,"Ale"]
[13,"F","Russian Imperial Stout",1115,1075,1030,1018,12,8,79,59,90,50,0.71,2.2999999999999998,1.5,1.9,"Ale"]
[14,"A","English IPA",1075,1050,1018,1010,7.5,5,28,16,60,40,0.8,2.2999999999999998,1.5,1.9,"Ale"]
[14,"B","American IPA",1075,1056,1018,1010,7.5,5.5,30,12,70,40,0.85,2.2999999999999998,1.5,1.9,"Ale"]
[14,"C","Imperial IPA",1090,1070,1020,1010,10,7.5,30,16,120,60,1.1399999999999999,2.2999999999999998,1.5,1.9,"Ale"]
[15,"A","Weizen",1052,1044,1014,1010,5.6,4.3,16,4,15,8,0.23,4.4800000000000004,3.6,4.04,"Wheat Ale"]
[15,"B","Dunkelweizen",1056,1044,1014,1010,5.6,4.3,45,28,18,10,0.28000000000000003,4.4800000000000004,3.6,4.04,"Wheat Ale"]
[15,"C","Weizenbock",1090,1064,1022,1015,8,6.5,49,24,30,15,0.28999999999999998,4.74,3.71,4.2249999999999996,"Wheat Ale"]
[15,"D","Roggenbier",1056,1046,1014,1010,6,4.5,37,28,20,10,0.28999999999999998,4.74,3.71,4.2249999999999996,"Wheat Ale"]
[16,"A","Witbier",1052,1044,1012,1008,5.5,4.5,8,4,20,10,0.32,2.6,2.1,2.35,"Ale"]
[16,"B","Belgian Pale Ale",1054,1048,1014,1010,5.5,4.8,28,16,30,20,0.49,2.5,1.9,2.2000000000000002,"Ale"]
[16,"C","Saison",1065,1048,1012,1002,7,5,28,10,35,20,0.54,2.4,1.9,2.15,"Ale"]
[16,"D","Bière de Garde",1080,1060,1016,1008,8.5,6,37,12,28,18,0.35,2.5,1.9,2.2000000000000002,"Ale"]
[16,"E","Belgian Specialty Ale","-","-","-","-","-","-","-","-","-","-","-",2.4,1.9,2.15,"Ale"]
[17,"A","Berliner Weisse",1032,1028,1006,1003,3.8,2.8,6,4,8,3,0.2,3.45,3.45,3.45,"Ale w. Lactic"]
[17,"B","Flanders Red Ale",1057,1048,1012,1002,6.5,4.5999999999999996,32,20,25,10,0.37,2.5,1.9,2.2000000000000002,"Ale w. Lactic"]
[17,"C","Flanders Oud Bruin",1074,1040,1012,1008,8,4,43,30,25,20,0.41,2.5,1.9,2.2000000000000002,"Ale w. Lactic"]
[17,"D","Lambic",1054,1040,1010,1001,6.5,5,14,6,10,0,0.12,4.5,3,3.75,"Ale w. Lactic"]
[17,"E","Gueuze",1060,1040,1006,1000,8,5,14,6,10,0,0.12,4.5,3,3.75,"Ale w. Lactic"]
[17,"F","Fruit Lambic",1060,1040,1010,1000,7,5,"-","-",10,0,0.11,4.5,2.6,{"$f":"(P68+O68)/2","v":3.55},"Ale w. Lactic"]
[18,"A","Belgian Blond Ale",1075,1062,1018,1008,7.5,6,14,8,30,15,0.34,2.4,1.9,2.15,"Ale"]
[18,"B","Belgian Dubbel",1075,1062,1018,1008,7.6,6,33,20,25,15,0.3,2.4,1.9,2.15,"Ale"]
[18,"C","Belgian Tripel",1085,1075,1014,1008,9.5,7.5,14,9,40,20,0.41,2.4,1.9,2.15,"Ale"]
[18,"D","Belgian Golden Strong Ale",1095,1070,1016,1005,10.5,7.5,12,6,35,22,0.38,2.4,1.9,2.15,"Ale"]
[18,"E","Belgian Dark Strong Ale",1110,1075,1024,1010,11,8,43,24,35,20,0.31,2.5,1.9,2.2000000000000002,"Ale"]
[19,"A","Old Ale",1090,1060,1022,1015,9,6,43,20,60,30,0.57999999999999996,2.2999999999999998,1.5,1.9,"Ale"]
[19,"B","English Barleywine",1120,1060,1030,1018,12,8,43,16,70,35,0.51,2.2999999999999998,1.3,1.7999999999999998,"Ale"]
[19,"C","American Barleywine",1120,1080,1030,1016,12,8,37,20,120,50,0.84,2.2999999999999998,1.3,1.7999999999999998,"Ale"]
[20,"A","Fruit Beer","-","-","-","-","-","-","-","-","-","-","-",3,2,2.5,"Ale"]
[21,"A","Spice, Herb and Vegetable Beer","-","-","-","-","-","-","-","-","-","-","-",3,2,2.5,"Ale"]
[21,"B","Christmas / Winter Beer","-","-","-","-","6+","-","-","-","-","-","-",2.2999999999999998,1.9,2.0999999999999996,"Ale or Lager"]
[22,"A","Classic Rauchbier",1057,1050,1016,1012,6,4.8,43,24,30,20,0.45,2.57,2.16,2.3650000000000002,"Ale"]
[22,"B","Smoked Beer","-","-","-","-","-","-","-","-","-","-","-",2.57,2.16,2.3650000000000002,"Ale or Lager"]
[22,"C","Wood-Aged Beer","-","-","-","-","-","-","-","-","-","-","-",2.57,2.16,2.3650000000000002,"Ale"]
[23,"A","Specialty Beer","-","-","-","-","-","-","-","-","-","-","-",2.5,2.2000000000000002,2.35,"-"]
[null,null,"· Honey Beers (not Braggots)","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
[null,null,"· Wiess (cloudy, young Kölsch)","-","-","-","-","-","-","-","-","-","-","-",2.73,2.42,{"$f":"(P85+O85)/2","v":2.5750000000000002},"Kölsch"]
[null,null,"· Sticke Altbier","-","-","-","-",5.5,"-","-","-","-","-","-",3.09,2.16,2.625,"Ale"]
[null,null,"· Münster Altbier",1049,"-","-","-",5.0999999999999996,"-","-","-",20,"-","-",3.09,2.16,2.625,"Ale"]
[null,null,"· Imperial Porter","-","-","-","-","-","-","-","-","-","-","-",3.09,2.16,2.625,"Ale"]
[null,null,"· Classic American Cream Ale","-","-","-","-","-","-","-","-","-","-","-",2.7,2.6,2.6500000000000004,"Ale"]
[null,null,"· Czech Dark Lager","-","-","-","-","-","-","-","-","-","-","-",2.6,2.2000000000000002,2.4000000000000004,"Lager"]
[null,null,"· English Pale Mild","-","-","-","-","-","-","-","-","-","-","-",2,1.3,1.65,"Ale"]
[null,null,"· Scottish 90/-","-","-","-","-","-","-","-","-","-","-","-",2.2999999999999998,1.5,1.9,"Ale"]
[null,null,"· American Stock Ale","-","-","-","-","-","-","-","-","-","-","-",2.78,2.2599999999999998,2.5199999999999996,"Ale"]
[null,null,"· English Strong Ale","-","-","-","-","-","-","-","-","-","-","-",2.2999999999999998,1.5,1.9,"Ale"]
[null,null,"· Non-alcoholic “Beer”","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
[null,null,"· Kellerbier",1056,"-",1014,"-",5.5,5,39,20,35,"-","-",1.3,0.75,{"$f":"(P96+O96)/2","v":1.0249999999999999},"Lager"]
[null,null,"· Malt Liquor","-","-","-","-","-","-","-","-","-","-","-","-","-","-","Lager"]
[null,null,"· Australian Sparkling Ale","-","-","-","-","-","-","-","-","-","-","-","-","-","-","Ale"]
[null,null,"· Imperial/Double Red Ale","-","-","-","-","-","-","-","-","-","-","-",2.2999999999999998,1.5,{"$f":"(P99+O99)/2","v":1.9},"Ale"]
[null,null,"· Imperial/Double Brown Ale","-","-","-","-","-","-","-","-","-","-","-",2.2999999999999998,1.5,{"$f":"(P100+O100)/2","v":1.9},"Ale"]
[null,null,"· Rye IPA","-","-","-","-","-","-","-","-","-","-","-",2.2999999999999998,1.5,{"$f":"(P101+O101)/2","v":1.9},"Ale"]
[null,null,"· Dark American Wheat/Rye","-","-","-","-","-","-","-","-","-","-","-",2.6,2.2999999999999998,{"$f":"(P102+O102)/2","v":2.4500000000000002},"Ale"]

{"sheet":"Malt X-ref.","index":9,"n_rows":39,"n_cols":10,"rows_kept":39,"cut":false,"hidden":false,"merged":[[0,0,0,9]]}
[]
[null,"WEYERMANN","Castle Malting","MUNTONS","BRIESS","FAWCETT","BAIRDS","CRISP","GAMBRINUS","DINGEMANS"]
[null,"(German)","(Belgian)","(British)","(American)","(British)","(British)","(British)","(Canadian)","(Belgian)"]
[null,"Bohemian Pilsner","Pilsner","Lager","Pilsner","Lager",null,"Lager",null,"Pilsen"]
[null,"Pale","Pale Ale","Pale","Brewers 2-Row","Pale Ale","Pale Ale","Pale","Pale","Pale Ale"]
[null,null,"Maris Otter Ale","Maris Otter",null,"Maris Otter",null,null,"ESB"]
[null,"Vienna","Vienna","Mild","Vienna","Vienna","Vienna","Ashburne/Vienna"]
[null,"Abbey","Abbey"]
[null,"Munich Type I, Light","Munich Light",null,"Bonlander",null,null,null,null,"Munich"]
[null,"Munich Type II, Dark","Munich",null,"Munich 10L",null,null,null,"Munich 10L"]
[null,"Carafoam/Dextrin",null,"Caramalt","Carapils/Dextrin","Caramalt",null,"Carapils",null,"Cara 8/Carapils"]
[null,"Melanoidin","Melanoidin/ Melano",null,"Victory","Amber",null,"Amber",null,"Aromatic/Biscuit"]
[null,"CaraHell","Cara Blond","Carapils","Crystal 10L"]
[null,"CaraBelge","Melano Light",null,null,null,"Light Carastan (10-15L)"]
[null,"CaraRed","Cara Ruby",null,"Crystal 20L",null,null,null,null,"Cara 20/CaraVienne"]
[null,"CaraAmber","Aroma",null,"Victory",null,null,null,"Munich 30","Biscuit"]
[null,null,null,null,"Crystal 30L","Pale Crystal","Carastan"]
[null,"CaraMunich I","Cara Gold",null,"Crystal 40L","Crystal Malt (40 - 50)",null,null,null,"Cara 45"]
[null,"CaraMunich II","Cara Gold","Medium Crystal"]
[null,"CaraMunich III","Café Light",null,"Crystal 60L","Crystal Malt II (60 - 70)"]
[null,"CaraBohemian",null,null,"Crystal 80L","Dark Crystal (85 - 95)","Crystal"]
[null,null,null,null,"Crystal 90L"]
[null,"CaraAroma","Café","Dark Crystal","Crystal 120L","Dark Crystal II (118 - 124)","Dark Crystal"]
[null,null,null,null,"Special Roast","Brown Malt","Brown Malt"]
[null,null,null,null,"Extra Special Roast",null,null,null,null,"Special B"]
[null,"Carafa I, dehusked","Chocolate",null,null,"Pale Chocolate"]
[null,"Carafa II, dehusked","Black","Chocolate","Chocolate","Chocolate","Chocolate","Chocolate",null,"Chocolate"]
[null,"Carafa III, dehusked","Black","Black Patent","Black Patent","Black Malt","Black Malt","Black","De-Bittered Black"]
[null,"Roasted Barley","Roasted Barley","Roasted Barley","Roasted Barley","Roasted Barley","Roasted Barley"]
[null,"Chocolate Wheat",null,null,null,"Roasted Wheat",null,null,null,"Roasted Wheat"]
[null,"Pale Wheat, Light","Wheat","Wheat","Wheat","Wheat",null,"Wheat",null,"Pale Wheat"]
[null,"Dark Wheat","Munich Wheat"]
[null,"Caramel Wheat",null,null,null,"Crystal Wheat"]
[null,"Chocolate Rye"]
[null,"Rye Malt",null,null,"Rye Malt","Rye Malt"]
[null,"Caramel Rye"]
[null,null,null,null,null,null,null,null,"Honey"]
[null,"Acidulated Malt","Acid"]
[null,"Smoked Malt, Beechwood","Smoked",null,null,"Peated Malt (Peat Smoked)"]

{"sheet":"Indkøb","index":10,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[7,2,7,3]]}
[]
[null,"Varenavn","Antal","Pris pr. stk.","Pris i alt DKK"]
[null,"Pale Ale Malt EBC 7-9: 1 gram","+ 5.500,00 -",0.02,110]
[null,"Cascade, Alpha: 6,3%: 1 gram","+ 65,00 -",0.5,32.5]
[null,"Mangrove Jack's Californian Lager M54","+ 1,00 -",20,20]
[null,"Mangrove Jack´s New World Strong Ale M42","+ 1,00 -",20,20]
[null,"Fragt",null,null,25]
[null,"Vareværdi i alt DKK",null,null,{"$f":"SUM(E3:E7)","v":207.5}]
[]
[]
[null,null,"Pris ved 40 flasker",null,{"$f":"E8/40","v":5.1875}]

{"sheet":"Links","index":11,"n_rows":29,"n_cols":2,"rows_kept":29,"cut":false,"hidden":false,"merged":[[24,1,24,5]]}
[]
["Shopping:","http://brygladen.com/"]
[null,"http://www.hjemmebryggeren.dk/"]
[null,"http://www.albryg.dk/"]
[null,"http://www.bryglageret.dk/"]
[null,"https://brygforretningen.dk/"]
[]
["Opskrifter:","http://www.candisyrup.com/recipes.html"]
[null,"http://www.castlemalting.com/CastleMaltingBeerRecipes.asp?P=94&Language=Danish"]
[]
["Ressource Guides:","https://byo.com/resources"]
[]
["Hops","https://www.hopunion.com/hop-varieties/"]
[null,"http://www.castlemalting.com/CastleMaltingHops.asp?P=105&Language=Danish"]
[]
["Malt","http://www.castlemalting.com/CastleMaltingMalts.asp?P=105&Language=Danish"]
[]
["Malt Descriptions","http://www.beercolor.com/malt_descriptions.htm"]
[]
["Yeast","https://www.wyeastlab.com/hb_yeaststrain.cfm"]
[null,"http://mangrovejacks.com/collections/craft-series-yeasts"]
[null,"https://www.whitelabs.com/beer/homebrew/listings"]
[null,"http://www.fermentis.com/brewing/homebrewing/product-range/"]
[]
["BU:GU / RBR","http://www.madalchemist.com/chart_bitterness_corrected.html"]
[]
["Glenn Tinseth's Website","http://www.realbeer.com/hops/"]
[]
["Beer Judge Certification Program","http://bjcp.org/"]