Help Support Aussie Homebrewer by donating:

  1. We have implemented the ability to gift someone a Supporting Membership now! When you access the Upgrade page there is now a 'Gift' button. Once you click that you can enter a username to gift an account Upgrade to. Great way to help support this forum plus give some kudos to anyone who has helped you.
    Dismiss Notice

Biab Beer Designer Spreadsheet

Discussion in 'All Grain Brewing' started by ianh, 27/6/11.

 

  1. Drover's dog

    Well-Known Member

    Joined:
    10/1/18
    Messages:
    60
    Likes Received:
    9
    Gender:
    Male
    Occupation:
    Retired and loving it...
    Posted 27/1/18
    Sheer genius...
     
    gezzanet likes this.
  2. Beannoir

    New Member

    Joined:
    3/9/17
    Messages:
    4
    Likes Received:
    1
    Gender:
    Male
    Posted 12/2/18
    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
     
    Yuz likes this.
  3. opercularia

    New Member

    Joined:
    5/10/13
    Messages:
    3
    Likes Received:
    0
    Posted 27/8/18
    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
     
  4. Hangover68

    Well-Known Member

    Joined:
    12/7/17
    Messages:
    118
    Likes Received:
    42
    Gender:
    Male
    Location:
    St Helena, Melbourne NE.
    Posted 28/8/18
    Is anyone using the spreadsheet in openoffice instead of Excel ?
     
  5. ianh

    Well-Known Member

    Joined:
    24/10/08
    Messages:
    685
    Likes Received:
    89
    Gender:
    Male
    Occupation:
    Retired
    Location:
    Wynyard Tassie
    Posted 28/8/18
    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
     
  6. Hangover68

    Well-Known Member

    Joined:
    12/7/17
    Messages:
    118
    Likes Received:
    42
    Gender:
    Male
    Location:
    St Helena, Melbourne NE.
    Posted 29/8/18
    Thanks, i assumed that would be the case.
     
  7. ianh

    Well-Known Member

    Joined:
    24/10/08
    Messages:
    685
    Likes Received:
    89
    Gender:
    Male
    Occupation:
    Retired
    Location:
    Wynyard Tassie
    Posted 31/8/18
    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
     
  8. opercularia

    New Member

    Joined:
    5/10/13
    Messages:
    3
    Likes Received:
    0
    Posted 1/9/18
    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!
     
  9. TONY VAN DER ZANDEN

    New Member

    Joined:
    20/6/18
    Messages:
    3
    Likes Received:
    0
    Gender:
    Male
    Location:
    MAROOCHYDORE
    Posted 13/3/19 at 3:16 AM
    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
     
  10. ianh

    Well-Known Member

    Joined:
    24/10/08
    Messages:
    685
    Likes Received:
    89
    Gender:
    Male
    Occupation:
    Retired
    Location:
    Wynyard Tassie
    Posted 13/3/19 at 5:52 AM
    Hi Tony
    The link in the first post in this thread is the current one.
    Cheers
    Ian
     

Share This Page