Over the past two years, I spent some of my idle time creating my own software, the Recipe Builder, for my brewing process. This free homebrew software was created in Excel 2010.
Do you like the software? You can buy me a beer! I like beer.
Like this page on Facebook, Twitter and any other network that you belong to! Get the word out!
- Create, save, scale recipes to your equipment profile and batch sizes;
- Provide auto calculations on just about everything;
- Complete water volume numbers for the entire brewing process. All of your volumes are calculated and adjusted for temperature expansion;
- IBU calculations factor in hop age and cohumulone percentages;
- Switch between U.S. Customary Units and Metric / SRM and EBC colour systems / Celcius and Fehrenheit;
- Estimate batch cost taking into considerations ingredients, energy and even CO2 costs
- Inventory tracking that includes fermentables, hops, yeast and adjuncts;
- Complete statistical analysis and efficiency tracking;
- Recipe based mash performance estimates
- Yeast attenuation estimation and yeast substitution suggestions
- In sheet calculator tools;
- Graphical beer style guides;
- Graphical water chart representation of your calculated water profile and ideal ranges;
- Unique graphical representation of Gravity and IBU balance;
- Unique graphical representation of the mash saccrification on a potential curve;
- Complex beer colour calculations based on standard CIE illuminate constants;
- Export and import recipe and log data into an excel sheet (great for migrating to new versions of this software);
- An Events Calendar to keep track of brew days and other beer related events;
- Information and tips about many aspects of brewing throughout
November 16, 2016 – v 4.2.4 – Bug Fix
- Corrected an issue where the Power, MCU and beer colour would not caculate properly when using U.S. units.
May 4, 2016 – v 4.2.3 – More Bug Fixes
- Again, with the assistance of Michael Rhodes of New Zealand, I found additional issues with water adjustment calculations. The alkalinity of the water are now the same on the Recipe and Batch sheets. Other water refinements were made.
- **Note that I am aware that the pH won’t match on both pages. It will get you close, but it won’t be identical. This is because pH is affected by both the grain bill and the amount of water used in the mash. Scalling mineral content is not simply linear, as it has to take into account those two variables making it difficult. But, I’m working on a solution.
May 3, 2016 – v 4.2.2 – Bug Fixes
- Corrected a problem where the recipe water effective alkalinity would never go below zero causing the water pH estimates to be off.
- Corrected the auto completion for the beer style on the recipe page.
April 28, 2016 – v 4.2.1 – Bug Fixes
- Corrected a saving issue with the saving of grains where the diastatic power was not saved and where the description and pH of the grain was inputting incorrectly.
- Corrected an issue where the grain percentage was not calculating properly.
- Ensured that the water calculations never show a negative bicarbonate value.
April 22, 2016 – v 4.2 – Enhancements – Thanks to Michael Rhodes of New Zealand for his ongoing assistance.
- Separated the water additions from the mash, sparge and boil additions. They now have values for each point.
- Refined some of the math for the water additions for greater accuracy.
- Added additional city water profiles (mostly in Europe) that reflect the traditional water numbers from those areas.
January 13, 2016 – v 4.0 – Major Revision
- Complete overhaul the look of the application
- Complete overhaul of the statistics to make it easier to use
- Introduced optional empirical data usage to put the log data into use and use that to calculate and apply things like mash efficiency, evaporation rates, etc.
November 24, 2015 -v 3.3.1 – Bug Fixes
- Corrected yeast calculator. Once again, thanks to Michael Rhoads from New Zealand.
- Simplified the yeast degradation rates in the Brewhouse sheet to show degradation rates per day.
November 20, 2015 – v 3.3 – New Features
- Added new style charts on the Style Table Sheet.
- Added style range information directly under the items under the Details of both the Create Batch and Create Recipe sheets.
- Added BJCP codes for 2015. You can now toggle between 2008 and 2015 in the Brewhouse sheet.
- Added a CO2 graph on both the Create Batch and Create Recipe sheets that changes corresponding to the selected style.
- Corrected the yeast calculator growth factor so that it is now influenced by the amount of sugar in the wort. Again, thanks to Michael Rhoads from New Zealand for the discussion on this.
November 13, 2015 – v 3.2 – Enhancement
- Changed the Create Recipe sheet so that the malts are added by percentage and not amounts. I find this much easier myself, but if you don’t, let me know.
November 12, 2015 – v 3.1.2 – Bug Fixes
- Fixed the Recipe Clear function. It would break the recipe sheet. (Another issue from implementing U.S. Units… still finding bugs because of this very difficult upgrade.)
November 10, 2015 – v 3.1.1 – Bug Fixes
- Corrected an issue with the Yeast Calculator – my numbers – where the 2, 3, 4 steps would show values of #N/A. Thanks to Michael Rhoads from New Zealand for his time in pointing this out for me.
November 9, 2015 – v 3.1 – New Features and Enhancements
- Ensured that the styles adhered to the BJCP guide
- Added the BJCP codes to the software
- Added a style balance guide (in yellow) the the balance bar chart in both the Create New Batch and Create Recipe sheets.
November 8, 2015 – v 3.0.3 – Bug Fixes
- Corrected another issue with the Statistics sheet (Sorry for the errors guys. This was the hardest to implement, and it’s complex. I think I have it whipped this time.)
- Corrected an issue where the Create Batch sheet showed the wrong Original Gravity
- Corrected an issue where the Brewhouse mash efficiency had to be set way too high to lower the amount of grain used.
- Note: All the issues are above are legacy problems from implementing U.S. Customary Units. It was a huge task to complete and introduced many bugs that I’m still working out.
November 5, 2015 – v 3.0.1 – Bug Fixes
- Corrected an issue where the Original Gravity on the Create Batch page was low by about 0.002 -0.003 degree points.
- Eliminated a circular reference error.
November 4, 2015 – v 3.0 – Major Revision
- The export and import functions now include log data as well as the receipes (I could not include the data on the Brewhouse at this time, but will plan on making this upgrade in the future)
- Upgraded the inventory page to include hop AAs, yeasts, and adjuncts. Removed the place where you bought them (abandoned comparative pricing as the scope of the project was over-ambitious for a world-wide audience)
- Hop IBU calculations use the AA rating of your hops in your inventory.
- Reworked the Statistics sheet considerably. Made several corrections.
- Brewhouse Sheet
- Added cost estimates to the brewhouse values, such as estimated utility and water costs
- Added a strike temperature deferential to get more accurate strike temps
- Added Mash Tun and Fermenter Deadspace values
- Added beer CO2 methods to help calculate costs
- Reworked costs significantly to reflect more closely your real overall costs, including water consumption, fuel, CO2, adjuncts, etc
- Hop oil and age factors were added to the “Create Batch” AA profiles (for some reason, I forgot to implement these factors on this page)
- Reduced the file size and launch times significantly (from 28MB down to 1.7MB. Loads in a second.)
- Added beer styles to yeasts to distinguish from ale and lager yeasts
- Brought to you by popular demand, I added a yeast calculator with inspiration from Homebrewdad’s Yeast Calculator. The calculator uses a unique function that provides growth rate that I believe are more accurate than others, however, I also provide numbers developed by Troester, which is what Homebrewdad uses. You can choose the one you like best.
- Added a calendar where brew log events are added automatically and you can add your own events.
- Many bug fixes throughout the software.
August 12, 2015 – v 2.1.1 – Bug Fixes
- Corrected issue where hop costs were not being factored into the cost of the brew. Again, thanks to Austin Rood for the help.
July 22, 2015 – v 2.1 – Major Bug Fixes
- Addressed a major bug where water additions in the Create Recipe page would not adjust the water chemistry. Thanks to Austin Rood for pointing this out.
June 18, 2015 – v 2.0.3 – Bug Fixes
- Corrected an issue that prohibited users from inputting batch sizes smaller than 4 gallons (thanks to Ryan Wagner for that).
- Corrected an issue where residual data from other recipes wasn’t being deleted when new recipes were loaded. (v 2.0.2)
June 17, 2015 – v 2.0.1 – Bug Fixes
- Small issue with minimum sparge amounts not converting to U.S. Customary units.
- Corrected volumes to account for minimum sparge amounts.
- Corrected a problem where the Recipe Mash Volume was not converting to U.S. Units.
June 16, 2015 – v 2.0 – Major Revision
- Switch between U.S. Customary Units and Metric.
- Export and import your recipes to support future upgrades. You won’t have to tediously input all of your recipes from a previous version. Unfortunately, however, this is not backward compatible, and it will only work from this version onward.
- Supports selecting between Celcius and Fehrenheit.
- When using U.S. Customary units, select which unit you want as your small unit. You can default to the U.S. grains / minims (as is the proper small units), drams, or grams.
- Selecting between SRM or EBC colour system.
- The volumes now account for thermal expansion.
- You can now calculate your evaporation rate or simply input one.
- Brewhouse efficiency now works. It combines your calculated mash and kettle efficiencies to give you a brewhouse value.
- Hop uses now support First Wort and various types of Hop Rest (and the accompanying bittering values to go with it).
May 27, 2015 – v 1.4 – New Features
- Added detailed descriptions and information about hop oils: cohumulone, myrcene, humulene, caryophyllene, farnescene.
- Hop cohumulone percentage and hop age are now factored into the bittering power of hops provided that the cohumulone levels are known and that a hop is present in the inventory tab.
May 19, 2015 – v 1.3.3 – Bug Fixes
- Changed the sheet recipe inputs to allow decimals in grams (up to 1/10 of a gram).
May 15, 2015 – v 1.3.2 – Bug Fixes
- Corrected a bug where values for Sodium Bicarbonate would display in the Calcium Hydroxide row. – Thanks Scott Shailer from Whitehorse, Yukon.
May 8, 2015 – v 1.3.1 – Bug Fixes
- Corrected an issue where the recipes would not order themselves in alphabetical order after adding a new recipe.
April 29, 2015 – v 1.3 – New Feature
- Corrected beer colour calculations and added complex beer colour grid based on A.J. Delange’s expert work and knowledge of colour theory. See Homebrewtalk.com for details on the conversation. The SRM colour now accurately translates accurately to RGB display colours. (Mind you, it will never be accurate – See: Estimating Beer Colour – Not So Straight-Forward.)
April 17, 2015 – v. 1.2 – First Release
- Add/Edit/Delete existing fermentables and hop ingredients
- Add/Edit yeast ingredients
- Editing of hop AA values right in the recipe builder
- Added more hop data to the sheet such as oil types and amounts
- Offering an SRM equation toggle switch to choose from like Moyer (the most popular) and mine. This is an attempt to get a colour estimation of beer that is somewhat close to what your beer actually is.
- Completing the print out sheet to allow printing on a standard page
- Adding some contact information right in the sheet
- Clearing statistical data
- Corrected statistical data calculations
- Correcting scalling calculations and eliminated brewhouse efficiency statistics (as it’s virtually the same as mash efficiency)
- Option to ignore kettle losses (for those who put everything into their fermenter)
- Enabled calculated mash efficiency on Brewhouse sheet
- Periodic table of beer styles