{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Main","GrainBill","HopSchedule","Adjuncts","Refractometer","BatchAnalytics","Catalog","Constants","Scratch","Mash"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":30,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Main","index":0,"n_rows":61,"n_cols":6,"rows_kept":61,"cut":false,"hidden":false,"merged":[[52,0,53,0],[56,0,56,5],[57,0,58,0],[38,0,38,1],[38,3,38,5],[42,3,42,4],[46,0,46,5],[47,0,48,0],[51,0,51,5],[32,0,32,5],[7,1,7,5],[9,2,9,3],[26,4,26,5],[27,4,27,5],[28,4,28,5],[29,4,29,5],[13,0,13,1],[9,0,9,1],[10,0,10,1],[11,0,11,1],[12,0,12,1],[10,2,10,3],[11,2,11,3],[12,2,12,3],[13,2,13,3],[0,0,0,5],[8,0,8,5],[1,1,1,5],[2,1,2,5],[5,1,5,5],[6,1,6,5],[3,0,4,0],[3,1,3,2],[4,1,4,2],[14,2,14,3],[17,1,17,2],[18,1,18,2],[19,1,19,2],[14,0,14,1],[15,0,15,1],[15,2,15,3],[16,0,16,2],[16,3,16,5],[30,4,30,5],[31,4,31,5],[21,1,21,2],[17,3,17,4],[18,3,18,4],[19,3,19,4],[20,3,20,4],[21,3,21,4],[20,1,20,2],[23,4,23,5],[24,4,24,5],[25,4,25,5],[22,0,22,5]]}
["Batch Description"]
["Beer Type","Double IPA"]
["Beer Recipe Name","Wicked Angel DIPA"]
["Yeast Type","California Ale Yeast",null,{"$f":"IF(ISBLANK(B4),\"\",VLOOKUP(B4,Yeast_Table,2,FALSE))","v":"WLP001"},{"$f":"IF(ISBLANK(B4),\"\",VLOOKUP(B4,Yeast_Table,5,FALSE) &\" : \" & VLOOKUP(B4,Yeast_Table,4,FALSE))","v":"Liquid : ALE"},{"$f":"IF(ISBLANK(B4),\"\",VLOOKUP(B4,Yeast_Table,6,FALSE))","v":5.65}]
[null,"Dry English Ale Yeast",null,{"$f":"IF(ISBLANK(B5),\"\",VLOOKUP(B5,Yeast_Table,2,FALSE))","v":"WLP007"},{"$f":"IF(ISBLANK(B5),\"\",VLOOKUP(B5,Yeast_Table,5,FALSE) &\" : \" & VLOOKUP(B5,Yeast_Table,4,FALSE))","v":"Liquid : ALE"},{"$f":"IF(ISBLANK(B5),\"\",VLOOKUP(B5,Yeast_Table,6,FALSE))","v":5.65}]
["Boil Size (gal)",12]
["Batch Size (gal)",10]
["Mash temperature (F)",150]
["Primary Grains, Malts and Boil Adjuncts"]
["Name",null,"Amount (lbs)",null,"Bill %","SRMg (Grain)"]
[{"$f":"IF(ISBLANK(GrainBill!B3),\"\",GrainBill!B3)","v":"American 2-Row Barley"},null,{"$f":"IF(ISBLANK(GrainBill!B3),\"\",GrainBill!C3)","v":23},null,{"$f":"IF(ISBLANK(GrainBill!B3),\"\",GrainBill!D3)","v":0.92929292929292928},{"$f":"IF(ISBLANK(GrainBill!B3),\"\",GrainBill!E3)","v":3}]
[{"$f":"IF(ISBLANK(GrainBill!B4),\"\",GrainBill!B4)","v":"Carastan (Crystal), 15"},null,{"$f":"IF(ISBLANK(GrainBill!B4),\"\",GrainBill!C4)","v":1.5},null,{"$f":"IF(ISBLANK(GrainBill!B4),\"\",GrainBill!D4)","v":6.0606060606060608E-2},{"$f":"IF(ISBLANK(GrainBill!B4),\"\",GrainBill!E4)","v":15}]
[{"$f":"IF(ISBLANK(GrainBill!B5),\"\",GrainBill!B5)","v":"Wheat Malt (GWM)"},null,{"$f":"IF(ISBLANK(GrainBill!B5),\"\",GrainBill!C5)","v":0.25},null,{"$f":"IF(ISBLANK(GrainBill!B5),\"\",GrainBill!D5)","v":1.0101010101010102E-2},{"$f":"IF(ISBLANK(GrainBill!B5),\"\",GrainBill!E5)","v":3}]
[{"$f":"IF(ISBLANK(GrainBill!B6),\"\",GrainBill!B6)","v":"American 2-Row Barley"},null,{"$f":"IF(ISBLANK(GrainBill!B6),\"\",GrainBill!C6)","v":0},null,{"$f":"IF(ISBLANK(GrainBill!B6),\"\",GrainBill!D6)","v":0},{"$f":"IF(ISBLANK(GrainBill!B6),\"\",GrainBill!E6)","v":3}]
[{"$f":"IF(ISBLANK(GrainBill!B7),\"\",GrainBill!B7)","v":""},null,{"$f":"IF(ISBLANK(GrainBill!B7),\"\",GrainBill!C7)","v":""},null,{"$f":"IF(ISBLANK(GrainBill!B7),\"\",GrainBill!D7)","v":""},{"$f":"IF(ISBLANK(GrainBill!B7),\"\",GrainBill!E7)","v":""}]
[{"$f":"IF(ISBLANK(GrainBill!B8),\"\",GrainBill!B8)","v":""},null,{"$f":"IF(ISBLANK(GrainBill!B8),\"\",GrainBill!C8)","v":""},null,{"$f":"IF(ISBLANK(GrainBill!B8),\"\",GrainBill!D8)","v":""},{"$f":"IF(ISBLANK(GrainBill!B8),\"\",GrainBill!E8)","v":""}]
["Post Boil Fermentable Sugar Adjuncts",null,null,"Non-Fermentable Sugar Adjuncts"]
["Name","Amount (lbs)",null,"Name",null,"Amount (lbs)"]
[{"$f":"IF(ISBLANK(Adjuncts!A3),\"\",Adjuncts!A3)","v":"Corn Sugar"},{"$f":"IF(ISBLANK(Adjuncts!A3),\"\",Adjuncts!C3)","v":1.5},null,{"$f":"IF(ISBLANK(Adjuncts!A9),\"\",Adjuncts!A9)","v":""},null,{"$f":"IF(ISBLANK(Adjuncts!A9),\"\",Adjuncts!C9)","v":""}]
[{"$f":"IF(ISBLANK(Adjuncts!A4),\"\",Adjuncts!A4)","v":""},{"$f":"IF(ISBLANK(Adjuncts!A4),\"\",Adjuncts!C4)","v":""},null,{"$f":"IF(ISBLANK(Adjuncts!A10),\"\",Adjuncts!A10)","v":""},null,{"$f":"IF(ISBLANK(Adjuncts!A10),\"\",Adjuncts!C10)","v":""}]
[{"$f":"IF(ISBLANK(Adjuncts!A5),\"\",Adjuncts!A5)","v":""},{"$f":"IF(ISBLANK(Adjuncts!A5),\"\",Adjuncts!C5)","v":""},null,{"$f":"IF(ISBLANK(Adjuncts!A11),\"\",Adjuncts!A11)","v":""},null,{"$f":"IF(ISBLANK(Adjuncts!A11),\"\",Adjuncts!C11)","v":""}]
[{"$f":"IF(ISBLANK(Adjuncts!A6),\"\",Adjuncts!A6)","v":""},{"$f":"IF(ISBLANK(Adjuncts!A6),\"\",Adjuncts!C6)","v":""},null,{"$f":"IF(ISBLANK(Adjuncts!A12),\"\",Adjuncts!A12)","v":""},null,{"$f":"IF(ISBLANK(Adjuncts!A12),\"\",Adjuncts!C12)","v":""}]
["Boil Additions"]
["Name","Alpha Acid Content","Amount (oz)","Boil Time","IBU Contribution"]
[{"$f":"IF( ISBLANK(HopSchedule!B3),\"\",HopSchedule!B3)","v":"Centennial"},{"$f":"IF(ISBLANK(HopSchedule!B3),\"\",HopSchedule!C3)","v":0.08},{"$f":"IF(ISBLANK(HopSchedule!B3),\"\",HopSchedule!D3)","v":0},{"$f":"IF(ISBLANK(HopSchedule!B3),\"\",HopSchedule!E3)","v":60},{"$f":"IF(ISBLANK(HopSchedule!F3),\"\",HopSchedule!F3)","v":0}]
[{"$f":"IF( ISBLANK(HopSchedule!B4),\"\",HopSchedule!B4)","v":"Palisade"},{"$f":"IF(ISBLANK(HopSchedule!B4),\"\",HopSchedule!C4)","v":7.2999999999999995E-2},{"$f":"IF(ISBLANK(HopSchedule!B4),\"\",HopSchedule!D4)","v":4},{"$f":"IF(ISBLANK(HopSchedule!B4),\"\",HopSchedule!E4)","v":60},{"$f":"IF(ISBLANK(HopSchedule!F4),\"\",HopSchedule!F4)","v":47.344988837262306}]
[{"$f":"IF( ISBLANK(HopSchedule!B5),\"\",HopSchedule!B5)","v":"Palisade"},{"$f":"IF(ISBLANK(HopSchedule!B5),\"\",HopSchedule!C5)","v":7.2999999999999995E-2},{"$f":"IF(ISBLANK(HopSchedule!B5),\"\",HopSchedule!D5)","v":1},{"$f":"IF(ISBLANK(HopSchedule!B5),\"\",HopSchedule!E5)","v":30},{"$f":"IF(ISBLANK(HopSchedule!F5),\"\",HopSchedule!F5)","v":9.096449323980103}]
[{"$f":"IF( ISBLANK(HopSchedule!B6),\"\",HopSchedule!B6)","v":"Cascade (U.S.)"},{"$f":"IF(ISBLANK(HopSchedule!B6),\"\",HopSchedule!C6)","v":5.4000000000000006E-2},{"$f":"IF(ISBLANK(HopSchedule!B6),\"\",HopSchedule!D6)","v":1},{"$f":"IF(ISBLANK(HopSchedule!B6),\"\",HopSchedule!E6)","v":30},{"$f":"IF(ISBLANK(HopSchedule!F6),\"\",HopSchedule!F6)","v":6.7288803218482967}]
[{"$f":"IF( ISBLANK(HopSchedule!B7),\"\",HopSchedule!B7)","v":"Cascade (U.S.)"},{"$f":"IF(ISBLANK(HopSchedule!B7),\"\",HopSchedule!C7)","v":5.4000000000000006E-2},{"$f":"IF(ISBLANK(HopSchedule!B7),\"\",HopSchedule!D7)","v":2},{"$f":"IF(ISBLANK(HopSchedule!B7),\"\",HopSchedule!E7)","v":2},{"$f":"IF(ISBLANK(HopSchedule!F7),\"\",HopSchedule!F7)","v":1.4806428701353824}]
[{"$f":"IF( ISBLANK(HopSchedule!B8),\"\",HopSchedule!B8)","v":"Palisade"},{"$f":"IF(ISBLANK(HopSchedule!B8),\"\",HopSchedule!C8)","v":7.2999999999999995E-2},{"$f":"IF(ISBLANK(HopSchedule!B8),\"\",HopSchedule!D8)","v":3},{"$f":"IF(ISBLANK(HopSchedule!B8),\"\",HopSchedule!E8)","v":2},{"$f":"IF(ISBLANK(HopSchedule!F8),\"\",HopSchedule!F8)","v":3.0024147088856363}]
[{"$f":"IF( ISBLANK(HopSchedule!B9),\"\",HopSchedule!B9)","v":"Cascade (U.S.)"},{"$f":"IF(ISBLANK(HopSchedule!B9),\"\",HopSchedule!C9)","v":5.4000000000000006E-2},{"$f":"IF(ISBLANK(HopSchedule!B9),\"\",HopSchedule!D9)","v":0.66},{"$f":"IF(ISBLANK(HopSchedule!B9),\"\",HopSchedule!E9)","v":1},{"$f":"IF(ISBLANK(HopSchedule!F9),\"\",HopSchedule!F9)","v":0.24919154366514248}]
[{"$f":"IF( ISBLANK(HopSchedule!B10),\"\",HopSchedule!B10)","v":""},{"$f":"IF(ISBLANK(HopSchedule!B10),\"\",HopSchedule!C10)","v":""},{"$f":"IF(ISBLANK(HopSchedule!B10),\"\",HopSchedule!D10)","v":""},{"$f":"IF(ISBLANK(HopSchedule!B10),\"\",HopSchedule!E10)","v":""},{"$f":"IF(ISBLANK(HopSchedule!F10),\"\",HopSchedule!F10)","v":0}]
["Other Adjuncts"]
["Name of Adjunct",null,"Amount (oz)","Boil Time"]
[]
[]
[]
[]
["Key Parameters",null,"Measured","Est. Sugar Composition"]
["Boil Gravity",{"$f":"SUM(GrainGravity)/B7 + 1","v":1.0619046999999999},{"$f":"Refractometer!A3","v":1.0671533914434481},"Dextrose",null,{"$f":"(1-((Constants!B2-B8)/(Constants!B2-Constants!B3)))*(1-F42)","v":0.41584094752435008}]
["SGs",{"$f":"1+SUM(GrainGravity,Adjuncts!F3:F6)/B7","v":1.0686547},{"$f":"Refractometer!A9","v":1.0671533914434481},"Maltose",null,{"$f":"((Constants!B2-B8)/(Constants!B2-Constants!B3))*(1-F42)","v":0.41584094752435008}]
["SGf",1.012,{"$f":"IF(MIN(Refractometer!C13:C18)>0,MIN(Refractometer!C13:C18),Refractometer!C12)","v":1.0097396453760001},"Simple Sugars",null,{"$f":"SUM(Adjuncts!F3:F6)/SUM(Adjuncts!F3:F6,Adjuncts!F9:F11,GrainGravity)+0.07","v":0.16831810495129979}]
["SRMb",{"$f":"1.4922* (SUM(GrainBill!F3:F8)/B7)^0.6859","v":6.8501088429244907},null,"Other Non-Fermentable Sugars",null,{"$f":"SUM(Adjuncts!F9:F11)/SUM(Adjuncts!F3:F6,Adjuncts!F9:F11,GrainGravity)","v":0}]
["IBU",{"$f":"SUM(HopSchedule!F3:F9)","v":67.902567605776866}]
["% ABV (Miller)",{"$f":"(B41-B42)/0.75","v":7.5539599999999929E-2},{"$f":"IF(ISNUMBER(C42),(C41-C42)/0.75,\"TBD\")","v":7.6551661423263972E-2}]
[]
["Malt Character"]
[null,"Dry","Semi-Dry","Natural","Semi-Sweet","Sweet"]
[null,0.1,0.2,0.30000000000000004,0.4,0.5]
["Expected / Calculated",{"$f":"IF(F40+F43<B49,\"X\",\"\")","v":""},{"$f":"IF($F40+$F43<=C49,IF($F40+$F43>B49,\"X\",\"\"),\"\")","v":""},{"$f":"IF($F40+$F43<=D49,IF($F40+$F43>C49,\"X\",\"\"),\"\")","v":""},{"$f":"IF($F40+$F43<=E49,IF($F40+$F43>D49,\"X\",\"\"),\"\")","v":""},{"$f":"IF(F40+F43>=F49,\"X\",\"\")","v":""}]
["Actual"]
["Color"]
[null,"Clear","Light","Amber","Brown/Red","Dark"]
[null,0,5,15,20,30]
["Expected / Calculated",{"$f":"IF(B43<C54,\"X\",\"\")","v":""},{"$f":"IF($B43<=D54,IF($B43>C54,\"X\",\"\"),\"\")","v":"X"},{"$f":"IF($B43<=E54,IF($B43>D54,\"X\",\"\"),\"\")","v":""},{"$f":"IF($B43<=F54,IF($B43>E54,\"X\",\"\"),\"\")","v":""},{"$f":"IF(B43>=F54,\"X\",\"\")","v":""}]
["Actual",{"$f":"IF(ISNUMBER(C43),IF(C43<C54,\"X\",\"\"),\"\")","v":""},{"$f":"IF($C43<=D54,IF($C43>C54,\"X\",\"\"),\"\")","v":""},{"$f":"IF($C43<=E54,IF($C43>D54,\"X\",\"\"),\"\")","v":""},{"$f":"IF($C43<=F54,IF($C43>E54,\"X\",\"\"),\"\")","v":""},{"$f":"IF(C43>=F54,\"X\",\"\")","v":""}]
["Alcohol Content"]
[null,"Very Light","Light","Normal","Strong","Very Strong"]
[null,0.03,3.5000000000000003E-2,4.4999999999999998E-2,7.0000000000000007E-2,8.5000000000000006E-2]
["Expected / Calculated",{"$f":"IF(B45<C59,\"X\",\"\")","v":""},{"$f":"IF($B45<=D59,IF($B45>C59,\"X\",\"\"),\"\")","v":""},{"$f":"IF($B45<=E59,IF($B45>D59,\"X\",\"\"),\"\")","v":""},{"$f":"IF($B45<=F59,IF($B45>E59,\"X\",\"\"),\"\")","v":"X"},{"$f":"IF($B45>=F59,\"X\",\"\")","v":""}]
["Actual",{"$f":"IF(C45<C59,\"X\",\"\")","v":""},{"$f":"IF($C45<=D59,IF($C45>C59,\"X\",\"\"),\"\")","v":""},{"$f":"IF($C45<=E59,IF($C45>D59,\"X\",\"\"),\"\")","v":""},{"$f":"IF($C45<=F59,IF($C45>E59,\"X\",\"\"),\"\")","v":"X"},{"$f":"IF(ISNUMBER(C45),IF($C45>=F59,\"X\",\"\"),\"\")","v":""}]

{"sheet":"GrainBill","index":1,"n_rows":31,"n_cols":17,"rows_kept":31,"cut":false,"hidden":false,"merged":[[0,0,0,10],[1,12,1,13],[1,14,1,16],[5,14,5,15]]}
["Grains and Malts"]
["Line","Name","Amount (lbs)","Bill %","SRMg (Grain)","SRMext","Unit Gravity","Gravity Yield","Gravity","price / lb","ext",null,{"$f":"Main!A39","v":"Key Parameters"},{"$f":"Main!B39","v":0},{"$f":"Main!D39","v":"Est. Sugar Composition"},{"$f":"Main!E39","v":0},{"$f":"Main!F39","v":0}]
[1,"American 2-Row Barley",23,{"$f":"IF(ISBLANK(B3),\"\",C3/$C$31)","v":0.92929292929292928},{"$f":"IF(ISBLANK(B3)=FALSE,VLOOKUP(B3,GrainsAndMalts_Table,4,0),0)","v":3},{"$f":"C3*E3","v":69},{"$f":"IF(ISBLANK(B3)=FALSE,VLOOKUP(B3,GrainsAndMalts_Table,3,0),0)","v":1.0369999999999999},{"$f":"IF(G3>1,(G3-1)*BrewhouseEfficiency,0)","v":2.5011999999999954E-2},{"$f":"C3*(H3)","v":0.5752759999999989},{"$f":"IF(ISBLANK(B3)=FALSE,VLOOKUP(B3,GrainsAndMalts_Table,2,0),0)","v":1.0900000000000001},{"$f":"C3*J3","v":25.07},null,{"$f":"Main!A40","v":"Boil Gravity"},{"$f":"Main!B40","v":1.0619046999999999},{"$f":"Main!D40","v":"Dextrose"},null,{"$f":"Main!F40","v":0.41584094752435008}]
[2,"Carastan (Crystal), 15",1.5,{"$f":"IF(ISBLANK(B4),\"\",C4/$C$31)","v":6.0606060606060608E-2},15,{"$f":"C4*E4","v":22.5},1.0369999999999999,2.5011999999999954E-2,{"$f":"C4*(H4)","v":3.7517999999999933E-2},1.61,{"$f":"C4*J4","v":2.415},null,{"$f":"Main!A41","v":"SGs"},{"$f":"Main!B41","v":1.0686547},{"$f":"Main!D41","v":"Maltose"},null,{"$f":"Main!F41","v":0.41584094752435008}]
[3,"Wheat Malt (GWM)",0.25,1.0101010101010102E-2,3,0.75,1.0369999999999999,2.5011999999999954E-2,6.2529999999999886E-3,1.0900000000000001,0.27250000000000002,null,{"$f":"Main!A42","v":"SGf"},{"$f":"Main!B42","v":1.012},{"$f":"Main!D42","v":"Simple Sugars"},null,{"$f":"Main!F42","v":0.16831810495129979}]
[4,"American 2-Row Barley",0,0,3,0,1.0369999999999999,2.5011999999999954E-2,0,1.0900000000000001,0,null,{"$f":"Main!A43","v":"SRMb"},{"$f":"Main!B43","v":6.8501088429244907},{"$f":"Main!D43","v":"Other Non-Fermentable Sugars"},{"$f":"Main!E43","v":0},{"$f":"Main!F43","v":0}]
[5,null,null,"",0,0,0,0,0,0,0,null,{"$f":"Main!A44","v":"IBU"},{"$f":"Main!B44","v":67.902567605776866}]
[6,null,null,"",0,0,0,0,0,0,0,null,{"$f":"Main!A45","v":"% ABV (Miller)"},{"$f":"Main!B45","v":7.5539599999999929E-2}]
[7,null,null,"",0,0,0,0,0,0,0]
[8,null,null,"",0,0,0,0,0,0,0]
[9,null,null,"",0,0,0,0,0,0,0]
[10,null,null,"",0,0,0,0,0,0,0]
[11,null,null,"",0,0,0,0,0,0,0]
[12,null,null,"",0,0,0,0,0,0,0]
[13,null,null,"",0,0,0,0,0,0,0]
[14,null,null,"",0,0,0,0,0,0,0]
[15,null,null,"",0,0,0,0,0,0,0]
[16,null,null,"",0,0,0,0,0,0,0]
[17,null,null,"",0,0,0,0,0,0,0]
[18,null,null,"",0,0,0,0,0,0,0]
[19,null,null,"",0,0,0,0,0,0,0]
[20,null,null,"",0,0,0,0,0,0,0]
[21,null,null,"",0,0,0,0,0,0,0]
[22,null,null,"",0,0,0,0,0,0,0]
[23,null,null,"",0,0,0,0,0,0,0]
[24,null,null,"",0,0,0,0,0,0,0]
[25,null,null,"",0,0,0,0,0,0,0]
[26,null,null,"",0,0,0,0,0,0,0]
[27,null,null,"",0,0,0,0,0,0,0]
[28,null,null,"",0,0,0,0,0,0,0]
[null,"Total Grain Wieght",{"$f":"SUM(C3:C9)","v":24.75},1,null,null,null,null,null,"Total",{"$f":"SUM(K3:K30)","v":27.7575}]

{"sheet":"HopSchedule","index":2,"n_rows":19,"n_cols":14,"rows_kept":19,"cut":false,"hidden":false,"merged":[[0,0,0,13],[18,0,18,4],[18,6,18,11]]}
["Boil Additions"]
["Line","Hops Type","Alpha Acid Content","Amount (oz)","Boil Time","IBU Contribution","AAU","Utilization","Scheduled Addition Time","Action","Completed","Status","price / oz","ext"]
[1,"Centennial",{"$f":"IF(ISBLANK(B3)=FALSE,VLOOKUP(B3,Hops_Table,3,FALSE),0)","v":0.08},0,60,{"$f":"G3*H3*75/Main!$B$7","v":0},{"$f":"D3*C3*100","v":0},{"$f":"(1.65*0.000125^((Main!$B$41-1)*(Main!$B$7/Main!$B$6)))*((1-EXP(-0.04*E3))/4.15)","v":0.21618716364046717},"2011-12-31T16:03:18",{"$f":"IF(ISBLANK(B3)=FALSE,IF(NOW()>I3, \"Add\", \"Wait\"),\"\")","v":"Add"},"x",{"$f":"IF(ISBLANK(B3)=FALSE,IF(J3=\"Add\",IF(ISBLANK(K3)=TRUE, 2,0),1),\"\")","v":0},{"$f":"IF(ISBLANK(B3)=FALSE,VLOOKUP(B3,Hops_Table,2,0),0)","v":0.671875},{"$f":"M3*D3","v":0}]
[2,"Palisade",7.2999999999999995E-2,4,60,{"$f":"G4*H4*75/Main!$B$7","v":47.344988837262306},29.2,{"$f":"(1.65*0.000125^((Main!$B$41-1)*(Main!$B$7/Main!$B$6)))*((1-EXP(-0.04*E4))/4.15)","v":0.21618716364046717},{"$f":"IF(ISBLANK(B4),\"\",$I$3+($E$3-E4)/24/60)","v":40908.668958333335},{"$f":"IF(ISBLANK(B4)=FALSE,IF(NOW()>I4, \"Add\", \"Wait\"),\"\")","v":"Add"},"x",{"$f":"IF(ISBLANK(B4)=FALSE,IF(J4=\"Add\",IF(ISBLANK(K4)=TRUE, 2,0),1),\"\")","v":0},0.55000000000000004,2.2000000000000002]
[3,"Palisade",{"$f":"IF(ISBLANK(B5)=FALSE,VLOOKUP(B5,Hops_Table,3,FALSE),0)","v":7.2999999999999995E-2},1,30,{"$f":"G5*H5*75/Main!$B$7","v":9.096449323980103},7.3,{"$f":"(1.65*0.000125^((Main!$B$41-1)*(Main!$B$7/Main!$B$6)))*((1-EXP(-0.04*E5))/4.15)","v":0.1661451931320567},{"$f":"IF(ISBLANK(B5),\"\",$I$3+($E$3-E5)/24/60)","v":40908.689791666671},{"$f":"IF(ISBLANK(B5)=FALSE,IF(NOW()>I5, \"Add\", \"Wait\"),\"\")","v":"Add"},"x",0,0.55000000000000004,0.55000000000000004]
[4,"Cascade (U.S.)",{"$f":"IF(ISBLANK(B6)=FALSE,VLOOKUP(B6,Hops_Table,3,FALSE),0)","v":5.4000000000000006E-2},1,30,{"$f":"G6*H6*75/Main!$B$7","v":6.7288803218482967},5.4,{"$f":"(1.65*0.000125^((Main!$B$41-1)*(Main!$B$7/Main!$B$6)))*((1-EXP(-0.04*E6))/4.15)","v":0.1661451931320567},40908.689791666671,"Add","x",0,0.546875,0.546875]
[5,"Cascade (U.S.)",5.4000000000000006E-2,2,2,{"$f":"G7*H7*75/Main!$B$7","v":1.4806428701353824},10.8,{"$f":"(1.65*0.000125^((Main!$B$41-1)*(Main!$B$7/Main!$B$6)))*((1-EXP(-0.04*E7))/4.15)","v":1.8279541606609658E-2},40908.709236111114,"Add",null,2,0.546875,1.09375]
[6,"Palisade",7.2999999999999995E-2,3,2,{"$f":"G8*H8*75/Main!$B$7","v":3.0024147088856363},21.9,{"$f":"(1.65*0.000125^((Main!$B$41-1)*(Main!$B$7/Main!$B$6)))*((1-EXP(-0.04*E8))/4.15)","v":1.8279541606609658E-2},40908.709236111114,"Add",null,2,0.55000000000000004,1.6500000000000001]
[7,"Cascade (U.S.)",5.4000000000000006E-2,0.66,1,{"$f":"G9*H9*75/Main!$B$7","v":0.24919154366514248},3.5640000000000005,{"$f":"(1.65*0.000125^((Main!$B$41-1)*(Main!$B$7/Main!$B$6)))*((1-EXP(-0.04*E9))/4.15)","v":9.3225418505477921E-3},40908.70993055556,"Add",null,2,0.546875,0.36093750000000002]
[8,null,0,null,null,{"$f":"G10*H10*75/Main!$B$7","v":0},0,{"$f":"(1.65*0.000125^((Main!$B$41-1)*(Main!$B$7/Main!$B$6)))*((1-EXP(-0.04*E10))/4.15)","v":0},"","",null,"",0,0]
[9,null,0,null,null,{"$f":"G11*H11*75/Main!$B$7","v":0},0,{"$f":"(1.65*0.000125^((Main!$B$41-1)*(Main!$B$7/Main!$B$6)))*((1-EXP(-0.04*E11))/4.15)","v":0},"","",null,"",0,0]
[10,null,0,null,null,{"$f":"G12*H12*75/Main!$B$7","v":0},0,{"$f":"(1.65*0.000125^((Main!$B$41-1)*(Main!$B$7/Main!$B$6)))*((1-EXP(-0.04*E12))/4.15)","v":0},"","",null,"",0,0]
[11,null,0,null,null,{"$f":"G13*H13*75/Main!$B$7","v":0},0,{"$f":"(1.65*0.000125^((Main!$B$41-1)*(Main!$B$7/Main!$B$6)))*((1-EXP(-0.04*E13))/4.15)","v":0},"","",null,"",0,0]
[12,null,0,null,null,{"$f":"G14*H14*75/Main!$B$7","v":0},0,{"$f":"(1.65*0.000125^((Main!$B$41-1)*(Main!$B$7/Main!$B$6)))*((1-EXP(-0.04*E14))/4.15)","v":0},"","",null,"",0,0]
[13,null,0,null,null,{"$f":"G15*H15*75/Main!$B$7","v":0},0,{"$f":"(1.65*0.000125^((Main!$B$41-1)*(Main!$B$7/Main!$B$6)))*((1-EXP(-0.04*E15))/4.15)","v":0},"","",null,"",0,0]
[14,null,0,null,null,{"$f":"G16*H16*75/Main!$B$7","v":0},0,{"$f":"(1.65*0.000125^((Main!$B$41-1)*(Main!$B$7/Main!$B$6)))*((1-EXP(-0.04*E16))/4.15)","v":0},"","",null,"",0,0]
[15,null,0,null,null,{"$f":"G17*H17*75/Main!$B$7","v":0},0,{"$f":"(1.65*0.000125^((Main!$B$41-1)*(Main!$B$7/Main!$B$6)))*((1-EXP(-0.04*E17))/4.15)","v":0},"","",null,"",0,0]
[16,null,0,null,null,{"$f":"G18*H18*75/Main!$B$7","v":0},0,{"$f":"(1.65*0.000125^((Main!$B$41-1)*(Main!$B$7/Main!$B$6)))*((1-EXP(-0.04*E18))/4.15)","v":0},"","",null,"",0,0]
["Total IBU",null,null,null,null,{"$f":"SUM(F3:F18)","v":67.902567605776866},null,null,null,null,null,null,"Total",{"$f":"SUM(N3:N18)","v":6.4015625000000007}]

{"sheet":"Adjuncts","index":3,"n_rows":14,"n_cols":16,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,0,0,7],[1,11,1,12],[1,13,1,15],[5,13,5,14],[6,0,6,7]]}
["Post Boil Fermentable Sugar Adjuncts"]
["Name","Unit Gravity","Amount (lbs)","SRMg","SRMext","Gravity","price / lb","ext",null,null,null,{"$f":"Main!A39","v":"Key Parameters"},{"$f":"Main!B39","v":0},{"$f":"Main!D39","v":"Est. Sugar Composition"},{"$f":"Main!E39","v":0},{"$f":"Main!F39","v":0}]
["Corn Sugar",{"$f":"IF(ISBLANK(A3)=FALSE,VLOOKUP(A3,Adjunct_Table,3,FALSE),0)","v":1.0449999999999999},1.5,{"$f":"IF(ISBLANK(A3)=FALSE,VLOOKUP(A3,Adjunct_Table,4,FALSE),0)","v":1},{"$f":"IF(ISBLANK(A3),0,C3*D3)","v":1.5},{"$f":"IF(ISBLANK(A3),0,C3*(B3-1))","v":6.7499999999999893E-2},{"$f":"IF(ISBLANK(A3)=FALSE,VLOOKUP(A3,Adjunct_Table,2,FALSE),0)","v":1.18},{"$f":"C3*G3","v":1.77},null,null,null,{"$f":"Main!A40","v":"Boil Gravity"},{"$f":"Main!B40","v":1.0619046999999999},{"$f":"Main!D40","v":"Dextrose"},null,{"$f":"Main!F40","v":0.41584094752435008}]
[null,{"$f":"IF(ISBLANK(A4)=FALSE,VLOOKUP(A4,Adjunct_Table,3,FALSE),0)","v":0},null,{"$f":"IF(ISBLANK(A4)=FALSE,VLOOKUP(A4,Adjunct_Table,4,FALSE),0)","v":0},{"$f":"IF(ISBLANK(A4),0,C4*D4)","v":0},{"$f":"IF(ISBLANK(A4),0,C4*(B4-1))","v":0},{"$f":"IF(ISBLANK(A4)=FALSE,VLOOKUP(A4,Adjunct_Table,2,FALSE),0)","v":0},{"$f":"C4*G4","v":0},null,null,null,{"$f":"Main!A41","v":"SGs"},{"$f":"Main!B41","v":1.0686547},{"$f":"Main!D41","v":"Maltose"},null,{"$f":"Main!F41","v":0.41584094752435008}]
[null,{"$f":"IF(ISBLANK(A5)=FALSE,VLOOKUP(A5,Adjunct_Table,3,FALSE),0)","v":0},null,{"$f":"IF(ISBLANK(A5)=FALSE,VLOOKUP(A5,Adjunct_Table,4,FALSE),0)","v":0},0,0,{"$f":"IF(ISBLANK(A5)=FALSE,VLOOKUP(A5,Adjunct_Table,2,FALSE),0)","v":0},0,null,null,null,{"$f":"Main!A42","v":"SGf"},{"$f":"Main!B42","v":1.012},{"$f":"Main!D42","v":"Simple Sugars"},null,{"$f":"Main!F42","v":0.16831810495129979}]
[null,{"$f":"IF(ISBLANK(A6)=FALSE,VLOOKUP(A6,Adjunct_Table,3,FALSE),0)","v":0},null,{"$f":"IF(ISBLANK(A6)=FALSE,VLOOKUP(A6,Adjunct_Table,4,FALSE),0)","v":0},0,0,{"$f":"IF(ISBLANK(A6)=FALSE,VLOOKUP(A6,Adjunct_Table,2,FALSE),0)","v":0},0,null,null,null,{"$f":"Main!A43","v":"SRMb"},{"$f":"Main!B43","v":6.8501088429244907},{"$f":"Main!D43","v":"Other Non-Fermentable Sugars"},{"$f":"Main!E43","v":0},{"$f":"Main!F43","v":0}]
["Non-Fermentable Sugar Adjuncts",null,null,null,null,null,null,null,null,null,null,{"$f":"Main!A44","v":"IBU"},{"$f":"Main!B44","v":67.902567605776866}]
["Name","Unit Gravity","Amount (lbs)","SRMg","SRMext","Gravity","price / lb","ext",null,null,null,{"$f":"Main!A45","v":"% ABV (Miller)"},{"$f":"Main!B45","v":7.5539599999999929E-2}]
[null,{"$f":"IF(ISBLANK(A9)=FALSE,VLOOKUP(A9,Adjunct_Table,3,FALSE),0)","v":0},null,{"$f":"IF(ISBLANK(A9)=FALSE,VLOOKUP(A9,Adjunct_Table,4,FALSE),0)","v":0},{"$f":"IF(ISBLANK(A9),0,C9*D9)","v":0},{"$f":"IF(ISBLANK(A9),0,C9*(B9-1))","v":0},{"$f":"IF(ISBLANK(A9)=FALSE,VLOOKUP(A9,Adjunct_Table,2,FALSE),0)","v":0},{"$f":"C9*G9","v":0}]
[null,{"$f":"IF(ISBLANK(A10)=FALSE,VLOOKUP(A10,Adjunct_Table,3,FALSE),0)","v":0},null,{"$f":"IF(ISBLANK(A10)=FALSE,VLOOKUP(A10,Adjunct_Table,4,FALSE),0)","v":0},{"$f":"IF(ISBLANK(A10),0,C10*D10)","v":0},{"$f":"IF(ISBLANK(A10),0,C10*(B10-1))","v":0},{"$f":"IF(ISBLANK(A10)=FALSE,VLOOKUP(A10,Adjunct_Table,2,FALSE),0)","v":0},{"$f":"C10*G10","v":0}]
[null,{"$f":"IF(ISBLANK(A11)=FALSE,VLOOKUP(A11,Adjunct_Table,3,FALSE),0)","v":0},null,{"$f":"IF(ISBLANK(A11)=FALSE,VLOOKUP(A11,Adjunct_Table,4,FALSE),0)","v":0},0,0,{"$f":"IF(ISBLANK(A11)=FALSE,VLOOKUP(A11,Adjunct_Table,2,FALSE),0)","v":0},0]
[null,{"$f":"IF(ISBLANK(A12)=FALSE,VLOOKUP(A12,Adjunct_Table,3,FALSE),0)","v":0},null,{"$f":"IF(ISBLANK(A12)=FALSE,VLOOKUP(A12,Adjunct_Table,4,FALSE),0)","v":0},0,0,{"$f":"IF(ISBLANK(A12)=FALSE,VLOOKUP(A12,Adjunct_Table,2,FALSE),0)","v":0},0]
[null,{"$f":"IF(ISBLANK(A13)=FALSE,VLOOKUP(A13,Adjunct_Table,3,FALSE),0)","v":0},null,{"$f":"IF(ISBLANK(A13)=FALSE,VLOOKUP(A13,Adjunct_Table,4,FALSE),0)","v":0},{"$f":"IF(ISBLANK(A13),0,C13*D13)","v":0},{"$f":"IF(ISBLANK(A13),0,C13*(B13-1))","v":0},{"$f":"IF(ISBLANK(A13)=FALSE,VLOOKUP(A13,Adjunct_Table,2,FALSE),0)","v":0},{"$f":"C13*G13","v":0}]
[null,null,null,null,null,null,"Total",{"$f":"SUM(H9:H12,H3:H6)","v":1.77}]

{"sheet":"Refractometer","index":4,"n_rows":18,"n_cols":5,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["Actual Post Boil Reading"]
[16.399999999999999,"Enter Post Boil Reading"]
[{"$f":"1.000019+0.003865613*(A2)+0.00001296425*(A2*A2)+0.00000005701128*(A2*A2*A2)","v":1.0671533914434481},"Post Boil O.G",null,null,"1.000019+0.003865613*(A8)+0.00001296425*(A8*A8)+0.00000005701128*(A8*A8*A8)"]
[{"$f":"A3+SUM(Adjuncts!F3:F6)/Main!B7","v":1.0739033914434482},"Synthetic O.G. based on adjunct addition post boil."]
[]
[]
["Corrected for After Pitch Sugar Addition"]
[16.399999999999999,"Synthetic Refractometer Reading"]
[{"$f":"1.000019+0.003865613*(A8)+0.00001296425*(A8*A8)+0.00000005701128*(A8*A8*A8)","v":1.0671533914434481},"O.G. (Original Specific Gravity)"]
[]
["Refract Reading","Temp  (in F) If NON ATC","F.G. (Adjusted for Alc and Temp)","Date","Notes"]
[8,68,{"$f":"IF(A12>0,(1.001843-0.002318474*(A$8)-0.000007775*(A$8^2)-0.000000034*(A$8^3)+0.00574*($A12)+0.00003344*($A12^2)+0.000000086*($A12^3))+(1.313454-0.132674*B12+0.002057793*(B12^2)-0.000002627634*(B12^3))*0.001,\"\")","v":1.0106637269221119},null,"Target Reading"]
[7.8,null,1.0097396453760001,"2011-01-06","Primary Ferm Complete"]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]

{"sheet":"BatchAnalytics","index":5,"n_rows":13,"n_cols":7,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Grainbill Expense",{"$f":"Grainbill_Total","v":27.7575},null,null,null,"batch price]","Batch Profit"]
["Adjunct Expense",{"$f":"Adjunct_Total","v":1.77}]
["Yeast Expense",{"$f":"SUM(Main!F4:F5)","v":11.3},null,null,null,{"$f":"C13*Main!B7/5","v":160},{"$f":"F3-B5","v":112.7709375}]
["Hops Expense",{"$f":"Hop_Total","v":6.4015625000000007}]
["Batch Total Cost",{"$f":"SUM(B1:B4)","v":47.229062499999998}]
[]
["Gallon Cost",{"$f":"B5/Main!B7","v":4.7229062499999994}]
["Bottle Cost (12oz)",{"$f":"B7/CONVERT(1,\"gal\",\"oz\")*12","v":0.44277246093749995}]
[]
["Package","Cost","Price","Profit / Gal"]
["6pack",{"$f":"B8*6","v":2.6566347656249998},9,{"$f":"(C11-B11)/CONVERT(6*12,\"oz\",\"gal\")","v":11.277093749999999}]
["keg 2.5gal",{"$f":"B7*2.5","v":11.807265624999999},40,{"$f":"(C12-B12)/2.5","v":11.277093750000001}]
["Keg 5gal",{"$f":"B7*5","v":23.614531249999999},80,{"$f":"(C13-B13)/5","v":11.277093750000001}]

{"sheet":"Catalog","index":6,"n_rows":218,"n_cols":6,"rows_kept":218,"cut":false,"hidden":false,"merged":[]}
["Grains and Malts","Price / lb","Unit Gravity","SRMg (Grain)","http://www.homebrewtalk.com/wiki/index.php/Malts_Ch"]
["Pale Malt, Belgian",1.0900000000000001,1.0369999999999999,1.5]
["Carastan (Crystal), 15",1.61,1.0369999999999999,15]
["Wheat Malt (GWM)",1.0900000000000001,1.0369999999999999,3]
["American 2-Row Barley",1.0900000000000001,1.0369999999999999,3]
["Ale Malt, NW (GWM)",1.0900000000000001]
["Munich Malt (GWM)",1.0900000000000001,1.0369999999999999,9]
["Pilsner Malt, Belgian",1.0900000000000001]
["Pilsner Malt, German",1.0900000000000001]
["Vienna Malt (GWM)",1.0900000000000001]
["Pale Malt, Maris Otter",1.0900000000000001]
["6 Row (Briess)",1.0900000000000001,1.0349999999999999,2]
["Acid Malt",1.6]
["Aromatic Malt",1.6,1.036,20]
["Biscuit Malt",1.6]
["Black Patent Malt",1.6]
["Brown Malt (HB)",1.6]
["Caramunich Malt",1.6]
["Caravienne Malt",1.6]
["Chocolate Malt",1.6]
["Carapils Malt (Dextrine)",1.6,1.0329999999999999,2]
["Crytstal 35",1.6,null,35]
["Crystal 60",1.6,null,60]
["Crystal 75",1.6,null,75]
["Crystal 120",1.6,null,120]
["Crystal 150",1.6,null,150]
["Flaked Barley",1.6,1.032,1.7]
["Flaked Corn (Maize)",1.6,1.0369999999999999,1.3]
["Flaked Oat",1.6,1.0369999999999999,1]
["Flaked Rice",1.6,1.032,1]
["Flaked Rye",1.6,1.036,2]
["Flaked Wheat",1.6,1.0349999999999999,1.6]
["Honey Malt",1.6]
["Peated (Smoked) Malt (HB)",1.6,1.034,3]
["Rauch (Smoked) Malt",1.6,1.0369999999999999,9]
["Roasted Barley",1.6]
["Rye Malt",1.6]
["Special B Malt",1.6]
["Special Roast (Briess)",1.6]
["Torrified Wheat",1.6,1.036,1.7]
["Victory Malt(Briess)",1.6]
["HullsRice/Oat/Barley",1,1,1]
["DME",3,1.0449999999999999,1.5]
[]
[]
["Adjuncts","Price / lb","Unit Gravity","SRMg (Grain)"]
["Corn Sugar",1.18,1.0449999999999999,1]
["Molasses"]
["Candi (Beet) Sugar"]
[]
[]
["Hops","Price / oz","AAU (%)","Usage","Description"]
["Admiral (U.K.)"]
["Ahtanum"]
["Amarillo"]
["Apollo"]
["Aurora (Slovenia)"]
["Bramling Cross (U.K.)"]
["Bravo"]
["Brewer's Gold (German)"]
["Brewer's Gold (U.S.)"]
["Bullion (U.K.)"]
["Cascade (Argentina)"]
["Cascade (New Zealand)"]
["Cascade (U.S.)",{"$f":"8.75/16","v":0.546875},5.4000000000000006E-2,"Dual","Aroma - flowery & citrusy. Very versatile."]
["Centennial",{"$f":"10.75/16","v":0.671875},0.08,"Dual","Aroma - floral & citrusy"]
["Challenger (U.K.)"]
["Chinook"]
["Cluster"]
["Columbus"]
["Crystal"]
["Eroica (German)"]
["First Gold (U.K."]
["Fuggle (U.K.)"]
["Fuggle (U.S.)"]
["Galena"]
["Glacier (U.S."]
["Golding (U.S."]
["Green Bullet (New Zealand)"]
["Hallertau Aroma (New Zealand)"]
["Hallertauer (U.S.)",null,4.3999999999999997E-2,"Aroma","Aroma - mild, slightly flowery"]
["Hallertauer Gold (German)"]
["Hallertauer Gold (German)"]
["Hallertauer Mittelfroh (German"]
["Hallertauer Tradition (German)"]
["Herald (U.K.)"]
["Hersbrucker (German"]
["Horizon"]
["Kent Golding (U.K.)"]
["Liberty"]
["Lublin (Poland)"]
["Magnum"]
["Marynka (Poland)"]
["Millenium"]
["Motueka (New Zealand)"]
["Mt. Hood",null,5.1999999999999998E-2]
["Nelson Sauvin (New Zealand)"]
["Newport"]
["Northdown (U.K.)"]
["Northern Brewer (German)"]
["Northern Brewer (U.S.)"]
["Northwest Golding"]
["Nugget"]
["Olympic"]
["Opal (German)"]
["Pacific Gem (New Zealand)"]
["Pacific Jade (New Zealand)"]
["Pacifica (New Zealand)"]
["Palisade",0.55000000000000004,7.2999999999999995E-2,"Dual"]
["Perle (German)"]
["Perle (U.S.)"]
["Phoenix (U.K.)"]
["Pioneer (U.K."]
["Premiant (Czech)"]
["Pride of Ringwood (Australia)"]
["Progress (U.K."]
["Riwaka (New Zealand)"]
["Saaz (Czech)"]
["Saaz (U.S.)",{"$f":"8.75/16","v":0.546875},5.800000000000001E-2]
["Santiam"]
["Saphir (German)"]
["Satus"]
["Select (German)"]
["Simcoe"]
["Sladek (Czech)"]
["Sorachi Ace (Japan)"]
["Southern Cross (New Zealand)"]
["Spalt (German)"]
["Spalt Select (German)"]
["Spalt Select (U.S.)"]
["Sterling"]
["Strisslespalt (France"]
["Styrian Golding (Slovenia)",null,4.8000000000000001E-2]
["Summit"]
["Sun"]
["Super Alpha (New Zealand)"]
["Super Pride (Australia)"]
["Target (U.K.)"]
["Tettnanger (German"]
["Tettnanger (U.S.)"]
["Tomahawk"]
["Tradition (German)"]
["Ultra"]
["Vanguard"]
["Warrior"]
["WGV (Whitbread Golding Variety) (U.K.)"]
["Willamette"]
["Yakima Cluster"]
["Zeus "]
["---=== Adjuncts ===---"]
["Corriander"]
["Bitter Orange (Dry)"]
["Sweet Orange Peel (Dry)"]
["Fresh Orange Peel"]
["Pumpkin Pie Spice"]
[]
[]
[]
[]
[]
[]
["Yeast","Item #","Lab","Type","Form","Price / ea."]
["California Ale Yeast","WLP001","White labs","ALE","Liquid",5.65]
["English Ale Yeast","WLP002","White labs","ALE","Liquid",5.65]
["Irish Ale Yeast","WLP004","White labs","ALE","Liquid",5.65]
["British Ale Yeast","WLP005","White labs","ALE","Liquid",5.65]
["Dry English Ale Yeast","WLP007","White labs","ALE","Liquid",5.65]
["East Coast Ale Yeast","WLP008","White labs","ALE","Liquid",5.65]
["European Ale Yeast","WLP011","White labs","ALE","Liquid",5.65]
["London Ale Yeast","WLP013","White labs","ALE","Liquid",5.65]
["California V Ale Yeast","WLP051","White labs","ALE","Liquid",5.65]
["Burton Ale Yeast","WLP023","White labs","ALE","Liquid",5.65]
["Edinburgh Scottish Ale Yeast","WLP028","White labs","ALE","Liquid",5.65]
["German/Kolsch Ale Yeast","WLP029","White labs","ALE","Liquid",5.65]
["Hefeweizen Ale Yeast","WLP300","White labs","Specialty Ale","Liquid",5.65]
["American Hefeweizen Ale Yeast","WLP320","White labs","Specialty Ale","Liquid",5.65]
["Hefeweizen IV Ale Yeast","WLP380","White labs","Specialty Ale","Liquid",5.65]
["Belgian Wit Ale Yeast","WLP400","White labs","Specialty Ale","Liquid",5.65]
["Trappist Ale Yeast","WLP500","White labs","Specialty Ale","Liquid",5.65]
["Abbey Ale Yeast","WLP530","White labs","Specialty Ale","Liquid",5.65]
["Belgian Ale Yeast","WLP550","White labs","Specialty Ale","Liquid",5.65]
["Saison Ale Yeast","WLP565","White labs","Specialty Ale","Liquid",5.65]
["Belgian Golden Ale Yeast","WLP570","White labs","Specialty Ale","Liquid",5.65]
["Champagne Yeast","WLP715","White labs","Wine/Mead","Liquid",5.65]
["Avize Yeast","WLP718","White labs","Wine/Mead","Liquid",5.65]
["Sweet Mead/Wine Yeast","WLP720","White labs","Wine/Mead","Liquid",5.65]
["SteingbergGeisenheim Yeast","WLP727","White labs","Wine/Mead","Liquid",5.65]
["French White Yeast","WLP735","White labs","Wine/Mead","Liquid",5.65]
["Merlot Red Wine Yeast","WLP740","White labs","Wine/Mead","Liquid",5.65]
["French Red Yeast","WLP750","White labs","Wine/Mead","Liquid",5.65]
["Cabernet Red Wine Yeast","WLP760","White labs","Wine/Mead","Liquid",5.65]
["Suremain Burgundy Yeast","WLP770","White labs","Wine/Mead","Liquid",5.65]
["English Cider Yeast","WLP775","White labs","Wine/Mead","Liquid",5.65]
["Malolactic Bacteria","WLP675","White labs","Wine/Mead","Liquid",5.65]
["Pilsner Lager Yeast","WLP800","White labs","Lager","Liquid",5.65]
["Czech Budejovice Lager Yeast","WLP802","White labs","Lager","Liquid",5.65]
["Oktoberfest Lager Yeast","WLP820","White labs","Lager","Liquid",5.65]
["German Lager Yeast","WLP830","White labs","Lager","Liquid",5.65]
["Southern German Lager Yeast","WLP838","White labs","Lager","Liquid",5.65]
["American Pilsner Lager Yeast","WLP840","White labs","Lager","Liquid",5.65]
["German Bock Yeast","WLP833","White labs","Lager","Liquid",5.65]
["Klassic Ale Yeast","WLP033","White labs","Seasonal","Liquid",5.65]
["Belgian Bastogne Ale Yeast","WLP510","White labs","Seasonal","Liquid",5.65]
["Mexican Lager Yeast","WLP940","White labs","Seasonal","Liquid",5.65]
["Essex Ale Yeast","WLP022","White labs","Seasonal","Liquid",5.65]
["German Ale II Yeast","WLP003","White labs","Seasonal","Liquid",5.65]
["Premium Bitter Yeast","WLP026","White labs","Seasonal","Liquid",5.65]
["Belgian Wit II Yeast","WLP410","White labs","Seasonal","Liquid",5.65]
["Zurich Lager Yeast","WLP885","White labs","Seasonal","Liquid",5.65]
["Bedford British Yeast","WLP006","White labs","Seasonal","Liquid",5.65]
["Old Bavarian Lager Yeast","WLP920","White labs","Seasonal","Liquid",5.65]
["Southwold Ale Yeast","WLP025","White labs","Seasonal","Liquid",5.65]
["Super High Gravity Ale Yeast","WLP099","White labs","Seasonal","Liquid",5.65]
["Weihenstephan (Weizen)",3068,"WYEAST","Specialty Ale","Liquid",5.65]
["Witbier",3944,"WYEAST","Specialty Ale","Liquid",5.65]
["Lambic Blend",3278,"WYEAST","Specialty Ale","Liquid",5.65]
["Brettanomyces Bruxellensis",3112,"WYEAST","Specialty Ale","Liquid",5.65]
["House Propagation","XXXX","ICB","Repitch","Liquid",-5.65]

{"sheet":"Constants","index":7,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":true,"merged":[]}
[]
["Mash Tmax-crit",155,"deg F"]
["Mash Tmin-crit",145,"deg F"]
[]
["Approximate Brewhouse Efficiency",0.67600000000000016]
[]
[]
[]
[]
["Hops Usages","Bittering"]
[null,"Aroma"]
[null,"Dual"]

{"sheet":"Scratch","index":8,"n_rows":31,"n_cols":16,"rows_kept":31,"cut":false,"hidden":true,"merged":[]}
[null,"modified from Tom M's Acid Addition Calculation Sheet (palmer 10/2006)"]
[]
[null,null,null,null,null,null,null,null,null,"ppm as CaCO3"]
["Carbonate Ratio at (_) pH",null,null,null,"H2CO3","HCO3-","CO3--",null,null,"HCO3 ppm (if pH<8.4)"]
["ph","r1","r2","d","f1","f2","f3"]
[{"$f":"Mash!B43","v":8},{"$f":"10^(A6-6.38)","v":41.686938347033561},{"$f":"10^(A6-10.33)","v":4.6773514128719777E-3},{"$f":"1+B6+B6*C6","v":42.881922807009367},{"$f":"1/D6","v":2.3319849823444545E-2},{"$f":"B6/D6","v":0.97213314185201416},{"$f":"B6*C6/D6","v":4.5470083245411934E-3}]
[{"$f":"Mash!C43","v":6},{"$f":"10^(Mash!C44-6.38)","v":4.1686938347033493E-7},{"$f":"10^(Mash!C44-10.33)","v":4.6773514128719782E-11},{"$f":"1+B7+B7*C7","v":1.0000004168693835},{"$f":"1/D7","v":0.99999958313079029},{"$f":"B7/D7","v":4.1686920969032448E-7},{"$f":"B7*C7/D7","v":1.9498437869278643E-17},null,null,"Alkalinity as CaCO3"]
[4.3,{"$f":"10^(4.3-6.38)","v":8.3176377110267055E-3},{"$f":"10^(4.3-10.33)","v":9.3325430079699009E-7},{"$f":"1+B8+B8*C8","v":1.0083176454734979},{"$f":"1/D8","v":0.9917509670580128},{"$f":"B8/D8","v":8.2490252435489311E-3},{"$f":"B8*C8/D8","v":7.6984382859249789E-9},null,null,"Bicarbonate (ppm)"]
[]
[null,null,null,null,null,null,null,"ct"]
[null,"Calculated values"]
[null,"Total Alkalinity",null,{"$f":"IF(Mash!E14=\"Alkalinity as CaCO3\",Mash!E19,Mash!E19*50/61)","v":0}]
[null,"    converted to mEq/L",null,{"$f":"D12/50","v":0},"mEq/L"]
[null,"Carbo system at pH =",null,{"$f":"Mash!B43","v":8}]
[null,"% of Carbo as H2CO3",null,{"$f":"E6","v":2.3319849823444545E-2}]
[null,"% of Carbo as HCO3-",null,{"$f":"F6","v":0.97213314185201416}]
[null,"% of Carbo as CO3--",null,{"$f":"G6","v":4.5470083245411934E-3}]
[null,"Carbo system at pH =",null,{"$f":"Mash!C43","v":6}]
[null,"% of Carbo as H2CO3",null,{"$f":"E7","v":0.99999958313079029}]
[null,"% of Carbo as HCO3-",null,{"$f":"F7","v":4.1686920969032448E-7}]
[null,"% of Carbo as CO3--",null,{"$f":"G7","v":1.9498437869278643E-17}]
[null,"Adjusted Total Alk",null,{"$f":"D13/((E8-E6)+(G6-G8))","v":0},"mEq/L"]
[null,"E (rough)",null,{"$f":"D22*((D19-E6)+(G6-D21))+10^(-Mash!C43)-10^(-A6)","v":9.9000000000000005E-7},"mEq/l"]
[]
["acid",null,"pk1","pk2","pk3","pH","r1d","r2d","r3d","dd","f1d","f2d","f3d","f4d","frac/ H ions"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Adjusted mEq Acid"]
["hydrochloric",36.46,-10,20,20,{"$f":"Mash!C$43","v":6},{"$f":"10^($F28-C28)","v":1E+16},1E-14,1E-14,{"$f":"1/(1+G28+G28*H28+G28*H28*I28)","v":9.9999999999999E-17},{"$f":"J28","v":9.9999999999999E-17},{"$f":"K28*G28","v":0.99999999999999001},{"$f":"G28*H28*J28","v":9.9999999999999006E-15},{"$f":"G28*H28*I28*J28","v":9.9999999999998999E-29},{"$f":"L28+2*M28+3*N28","v":1.00000000000001},{"$f":"D$23/O28","v":9.899999999999901E-7}]
["phosphoric",98,2.12,7.2,12.44,{"$f":"Mash!C$43","v":6},7585.7757502918394,6.3095734448019289E-2,3.630780547701011E-7,{"$f":"1/(1+G29+G29*H29+G29*H29*I29)","v":1.2398631860160528E-4},{"$f":"J29","v":1.2398631860160528E-4},{"$f":"K29*G29","v":0.94053240901601531},{"$f":"G29*H29*J29","v":5.9343583119030367E-2},{"$f":"G29*H29*I29*J29","v":2.1546352721945355E-8},{"$f":"L29+2*M29+3*N29","v":1.0592196398931342},{"$f":"D$23/O29","v":9.3465034324692302E-7}]
["lactic",90.08,3.08,20,20,{"$f":"Mash!C$43","v":6},831.7637711026714,1E-14,1E-14,{"$f":"1/(1+G30+G30*H30+G30*H30*I30)","v":1.2008207305606959E-3},{"$f":"J30","v":1.2008207305606959E-3},{"$f":"K30*G30","v":0.99879917926942929},{"$f":"G30*H30*J30","v":9.9879917926942934E-15},{"$f":"G30*H30*I30*J30","v":9.987991792694293E-29},{"$f":"L30+2*M30+3*N30","v":0.99879917926944928},{"$f":"D$23/O30","v":9.9119024179026141E-7}]
["sulfuric",98.07,-10,1.92,20,{"$f":"Mash!C$43","v":6},1E+16,12022.644346174151,1E-14,{"$f":"1/(1+G31+G31*H31+G31*H31*I31)","v":8.3169459375949008E-21},{"$f":"J31","v":8.3169459375949008E-21},{"$f":"K31*G31","v":8.3169459375949013E-5},{"$f":"G31*H31*J31","v":0.99991683054061409},{"$f":"G31*H31*I31*J31","v":9.9991683054061409E-15},{"$f":"L31+2*M31+3*N31","v":1.9999168305406341},{"$f":"D$23/O31","v":4.9502058529722709E-7}]

{"sheet":"Mash","index":9,"n_rows":47,"n_cols":21,"rows_kept":47,"cut":false,"hidden":false,"merged":[[30,1,30,7],[35,1,35,8],[19,1,19,11],[4,1,4,14],[0,1,0,8],[11,1,11,7],[15,1,15,7],[23,1,23,7]]}
[null,"Mash Residual Alkalinity Adjustment Worksheet Version 2.4 (US Units)"]
[null,null,null,"User Input",null,null,"by John Palmer All Rights Reserved 2008"]
[null,null,null,"Calc. Output",null,"Units are grams, gallons, and milliliters. "]
[]
[null,"Step 1: Enter Target Beer Color to see range of suggested Residual Alkalinity, Or Enter a Target Water Profile to see its calculated Residual Alkalinity value and a range of suggested Beer Color. (Choose either \"Bicarbonate\" or \"Total Alkalinity\" in E10 and enter the appropriate value in E11.)"]
[null,"Target Color (SRM)","Est. RA (Low)","Est. RA (High)"]
[null,3,{"$f":"B7*12.2-122.4","v":-85.800000000000011},{"$f":"(B7-5.2)*12.2","v":-26.84}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ratio","Balance"]
[null,"Target Water","Calcium (ppm)","Magnesium (ppm)","Alkalinity as CaCO3","Sodium (ppm)","Chloride (ppm)","Sulfate (ppm)",null,null,"(Effective Hardness)","Residual Alkalinity as CaCO3","Est. SRM (Low)","Est. SRM (High)","Chloride to Sulfate Balance",null,null,null,null,0,"Very Bitter"]
[null,"(ppm)",0,0,0,0,0,0,null,null,{"$f":"(C10/1.4)+(D10/1.7)","v":0},{"$f":"IF(E9=\"Bicarbonate (ppm)\", (50*E10/61)-K10, E10-K10)","v":0},{"$f":"IF(L10<-69,0,L10*0.082+5.2)","v":5.2},{"$f":"IF(L10<-128,0,(L10+122.4)/12.2)","v":10.032786885245903},{"$f":"VLOOKUP(G10/H10,T9:U13, 2, TRUE)","v":{"$error":"#DIV/0!"}},null,null,null,null,0.501,"Bitter"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.76800000000000002,"Balanced"]
[null,"Step 2: Enter Source Water Profile. (Choose \"Bicarbonate\" or \"Alkalinity\" in E14.)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.3,"Malty"]
[null,"Source Water","Calcium (ppm)","Magnesium (ppm)","Alkalinity as CaCO3","Sodium (ppm)","Chloride (ppm)","Sulfate (ppm)","Water pH",null,"(Effective Hardness)","Residual Alkalinity as CaCO3","Est. SRM (Low)","Est. SRM (High)","Chloride to Sulfate Ratio",null,null,null,null,2.0099999999999998,"Very Malty"]
[null,"(ppm)",51,16,190,66,63,120,8.1,null,{"$f":"(C14/1.4)+(D14/1.7)","v":45.840336134453786},{"$f":"IF(E13=\"Bicarbonate (ppm)\", (50*E14/61)-K14, E14-K14)","v":144.15966386554621},{"$f":"IF(L14<-69,0,L14*0.082+5.2)","v":17.02109243697479},{"$f":"IF(L14<-128,0,(L14+122.4)/12.2)","v":21.849152775864447},{"$f":"VLOOKUP(G14/H14,T9:U13, 2, TRUE)","v":"Bitter"}]
[]
[null,"Step 3: Optional: Dilute Source Water with Distilled Water (Enter Zero if not diluting.) "]
[null,"Dilution Rate","Calcium (ppm)","Magnesium (ppm)",{"$f":"E13","v":"Alkalinity as CaCO3"},"Sodium (ppm)","Chloride (ppm)","Sulfate (ppm)",null,null,"(Effective Hardness)","Residual Alkalinity as CaCO3","Est. SRM (Low)","Est. SRM (High)","Chloride to Sulfate Ratio"]
[null,0,{"$f":"(1-$B18)*C14","v":51},16,190,66,63,120,null,null,{"$f":"(C18/1.4)+(D18/1.7)","v":45.840336134453786},{"$f":"IF(E17=\"Bicarbonate (ppm)\", (50*E18/61)-K18, E18-K18)","v":144.15966386554621},{"$f":"IF(L18<-69,0,L18*0.082+5.2)","v":17.02109243697479},{"$f":"IF(L18<-128,0,(L18+122.4)/12.2)","v":21.849152775864447},{"$f":"VLOOKUP(G18/H18,T9:U13, 2, TRUE)","v":"Bitter"}]
[]
[null,"Step 4: Enter a Target Residual Alkalinity Value, based on Step 1, and the total volume of mash water."]
[null,"Target Residual Alkalinity","Mash Water Volume (gal)","Volume of Source Water (gal.)","Volume of Distilled Water (gal.)","Additional Eff. Hardness Needed","Additional Alkalinity Needed","Target RA Est. SRM (Low)","Target RA Est. SRM (High)"]
[null,{"$f":"IF(AVERAGE(C7:D7)>=0, AVERAGE(C7:D7),0)","v":0},3,{"$f":"(1-B18)*C22","v":3},{"$f":"(B18)*C22","v":0},{"$f":"IF(L18>B22,(IF(E17=\"Bicarbonate (ppm)\", (50*E18/61), E18)-B22)-K18,0)","v":144.15966386554621},{"$f":"IF(L18<B22,B22-L18,0)","v":0},{"$f":"IF(B22<-69,0,B22*0.082+5.2)","v":5.2},{"$f":"IF(B22<-128,0,(B22+122.4)/12.2)","v":10.032786885245903}]
[]
[null,"Step 5: Optional: Add salts to Mash Water. (Enter Zeros if not adding salt.)"]
[null,"Salt Additions","Chalk       CaCO3","Gypsum  CaSO4 *2H2O","Calcium Chloride  CaCl2*2H2O","Epsom Salt  MgSO4 *7H2O","Baking Soda  NaHCO3"]
[null,"(grams)",0,0,4,0,0]
[]
[null,"Salt Contributions","Calcium (ppm)","Magnesium (ppm)","HCO3  (ppm)","Sodium (ppm)","Chloride (ppm)","Sulfate (ppm)",null,null,"Contributed Hardness","Contributed Alkalinity"]
[null,"(ppm)",{"$f":"(C26*105.89+D26*60+E26*72)/C22","v":96},{"$f":"F26*24.6/C22","v":0},{"$f":"(C26*158+G26*191.88)/C22","v":0},{"$f":"G26*72.3/C22","v":0},{"$f":"E26*127.47/C22","v":169.96},{"$f":"(D26*147.4+F26*103)/C22","v":0},null,null,{"$f":"(C29/1.4)+(D29/1.7)","v":68.571428571428569},{"$f":"(E29)*50/61","v":0}]
[]
[null,"Step 6: Optional: Add Acid to Mash Water. (Enter Zero if not adding acid.)"]
[null,"Acid Adjustment","Bottle Conc.","Est. Acid-Only Mash Addition (ml)","Mash Water Addition (ml)"]
[null,"Hydrochloric",0.37,{"$f":"IF(L18>B22,3.785*C22*F22/50/((13.927*C33*C33)+(27.319*C33)),0)","v":2.7248981031465389},0]
[null,"Lactic",0.88,{"$f":"IF(L14>B22,0.88/C34*3.785*C22*F22/50/11.8,0)","v":2.7744626833784363},0]
[]
[null,"Step 7: Result: Adjusted Mash Chemistry and Final Residual Alkalinity and Beer Color Range"]
[null,"Adjusted Mash","Calcium (ppm)","Magnesium (ppm)","Alkalinity as CaCO3","Sodium (ppm)","Chloride (ppm)","Sulfate (ppm)",null,null,"(Effective Hardness)","Residual Alkalinity as CaCO3","Est. SRM (Low)","Est. SRM (High)","Chloride to Sulfate Ratio"]
[null,"(ppm)",{"$f":"C18+C29","v":147},{"$f":"D18+D29","v":16},{"$f":"IF(E13=\"Bicarbonate (ppm)\", 50/61*E18+L29, E18+L29)","v":190},{"$f":"F18+F29","v":66},{"$f":"IF(D33=0,G18+G29,G18+G29+(E33*12*C33/0.37*35.4/(C22*3.785)))","v":232.96},{"$f":"H18+H29","v":120},null,null,{"$f":"(C38/1.4)+(D38/1.7)","v":114.41176470588235},{"$f":"E38-K38-(50*E33*((13.927*C33*C33)+(27.319*C33))/(C22*3.785))- (50*E34*C34/0.88*11.8/(C22*3.785))","v":75.588235294117652},{"$f":"IF(L38<-69,0,L38*0.082+5.2)","v":11.398235294117647},{"$f":"IF(L38<-128,0,(L38+122.4)/12.2)","v":16.228543876567024},{"$f":"VLOOKUP(G38/H38,T9:U13, 2, TRUE)","v":"Malty"}]
[]
[]
[null,"Step 8: Optional: Sparge Water pH Adjustment"]
[null,"Measure Sparge Water pH @ 20C","Target Sparge Water pH @ 20C","Sparge Water Volume (gal)"]
[null,8,6,5]
[]
[null,"Acid Adjustment","Bottle Conc.","Est. Sparge Water Addition (ml)"]
[null,"Hydrochloric",0.37,{"$f":"IF(B43>C43,3.785*D43*Scratch!P28/((13.927*C46*C46)+(27.319*C46)),0)","v":1.5594105000082122E-6}]
[null,"Lactic",0.88,{"$f":"IF(B43>C43,0.88/C47*3.785*D43*Scratch!P30/11.8,0)","v":1.5896843496509066E-6}]