Biab Beer Designer Spreadsheet

Aussie Home Brewer

Help Support Aussie Home Brewer:

Beannoir

New Member
Joined
3/9/17
Messages
4
Reaction score
1
Ian,

I would just like to say thanks for your hard work, knocked over 4 brews now and spot on for my urn hasn't missed a beat.

Huge thanks you

Ben
 
  • Like
Reactions: Yuz

opercularia

New Member
Joined
6/10/13
Messages
3
Reaction score
0
Thank-you so much Ian, I have been using this spreadsheet for many years now and it has helped me produce many satisfying beers. Unfortunately, mostly due to my own stupidity, it has produced many duds. It is time to delete all of the duds, but I am having problems. As I delete recipes, I am losing information on the hops for other recipes.

The first picture shows you what has happened after a deletion. The yellow boxes show unaffected recipes. The red boxes show what is missing in some recipes after a recipe has been deleted. The blue box shows missing information that is shown in a capture taken before a deletion (shown in red in picture 2).

It appears that the information is being deleted as the page is being compacted (recipe moved to fill right-hand column from left-hand column below). It appears to affect all of the recipes in the right hand column. Each deletion corrupts more recipes.

Has anybody else had this problem, or has my copy become corrupt?
Capture.JPG

Capture2.JPG
 

ianh

Well-Known Member
Joined
24/10/08
Messages
690
Reaction score
99
Location
Wynyard Tassie
Hi opercularia I am not at home atm, should be back in a few days and will look at the problem.

Hangover68 the spreadsheet cannot be used in openoffice as the macros will not run.

cheers
Ian
 

ianh

Well-Known Member
Joined
24/10/08
Messages
690
Reaction score
99
Location
Wynyard Tassie
Hi opercularia. Had a chance to look at the recipe deletion problem.The recipes are grouped in sets of 10, it appears not to move recipe 11 to 10 correctly.
To fix the problem you need to get access to the "deleterecipe" macro how to do this depends on the Excel version.
You need to edit the deleterecipe macro, near the end of the macro you will see the following line

Range(ActiveCell.Offset(24, -36), ActiveCell.Offset(39, -34)).Cut Range(ActiveCell, ActiveCell.Offset(23, 2))

The 39 value needs to be changed to 46

Range(ActiveCell.Offset(24, -36), ActiveCell.Offset(46, -34)).Cut Range(ActiveCell, ActiveCell.Offset(23, 2))

then save the spreadsheet.
Hope that fixes trhe problem.
Cheers
Ian
 

opercularia

New Member
Joined
6/10/13
Messages
3
Reaction score
0
Hi opercularia. Had a chance to look at the recipe deletion problem.The recipes are grouped in sets of 10, it appears not to move recipe 11 to 10 correctly.
To fix the problem you need to get access to the "deleterecipe" macro how to do this depends on the Excel version.
You need to edit the deleterecipe macro, near the end of the macro you will see the following line

Range(ActiveCell.Offset(24, -36), ActiveCell.Offset(39, -34)).Cut Range(ActiveCell, ActiveCell.Offset(23, 2))

The 39 value needs to be changed to 46

Range(ActiveCell.Offset(24, -36), ActiveCell.Offset(46, -34)).Cut Range(ActiveCell, ActiveCell.Offset(23, 2))

then save the spreadsheet.
Hope that fixes trhe problem.
Cheers
Ian
Thanks for your quick reply Ian. I think it did the trick. I only tried one deletion and it worked correctly. Now to repair my recipes and finish deleting the duds.

Thanks again, you're a champ!
 
Joined
20/6/18
Messages
18
Reaction score
5
Location
MAROOCHYDORE
Hi opercularia I am not at home atm, should be back in a few days and will look at the problem.

Hangover68 the spreadsheet cannot be used in openoffice as the macros will not run.

cheers
Ian
G'day Ian,
Would love to try your spread sheet, I was sent a link by a member on this site, but the link went to a error page.
Could you please send me a more current link so I have a crack.
Many thanks,

Tony
 

ianh

Well-Known Member
Joined
24/10/08
Messages
690
Reaction score
99
Location
Wynyard Tassie
Hi Tony
The link in the first post in this thread is the current one.
Cheers
Ian
 

NicolasZA

New Member
Joined
27/5/20
Messages
4
Reaction score
1
Location
South Africa
Raising this thread from the dead.. Not sure if anybody is still using the spreadsheet, but I need some advice here.
If I change the ferment volume, should the grain weight not change?
 

NicolasZA

New Member
Joined
27/5/20
Messages
4
Reaction score
1
Location
South Africa
Thanks for your answer ianh. Second question then. Is there a way to modify the batch size with the spreadsheet? My current recipe is for 20 liters, I want to change the batch to 10 liters. Is this something the spreadsheet can handle?
 

ianh

Well-Known Member
Joined
24/10/08
Messages
690
Reaction score
99
Location
Wynyard Tassie
No you cannot just change the batch size saved in recipes. When you save recipe it just saves the value thats in the Ferment Volume cell.
 

mattoo

Member
Joined
5/10/16
Messages
6
Reaction score
1
Does anyone use brewmate ? It’s all I have used and found it excellent (and was a free download)
 

gezzanet

Well-Known Member
Joined
10/8/14
Messages
233
Reaction score
82
I’m still using Ian’s spreadsheet. Tweaked it for my biab setup and it’s very accurate and repeatable. Thanks Ian
 

Hangover68

Well-Known Member
Joined
12/7/17
Messages
272
Reaction score
74
Location
St Helena, Melbourne NE.
Since working from home i have now a full office suite thanks to work on my pc so opened the spreadsheet to have a look, i was thinking earlier today that some kind of inventory spreadsheet would be good and there it is right on the main page.
Excellent work and now i have all my on hand ingredients listed so i can keep track of it, i even made some additions to the yeasts and hops.

Anyone using this on an android device, would be handy to use on my tablet, i know there is Excel for Android but would prefer a free option.
 
Last edited:

NicolasZA

New Member
Joined
27/5/20
Messages
4
Reaction score
1
Location
South Africa
Thanks again for the spread sheet! Just finished my third brew and its starting to make sense now. Everything worked out exactly as planned.
:drinkingbeer:
 

Hangover68

Well-Known Member
Joined
12/7/17
Messages
272
Reaction score
74
Location
St Helena, Melbourne NE.
Just started my 2nd brew and i've noticed the 2 things that dont seem correct (could be me) , the mash temp and time stays the same regardless of the style and the strike water temp isn't high enough ? I may just need to do some tweaks but otherwise i love it, makes it easy to repeat a recipe.
 

Latest posts

Top