Author Topic: Incorporating Bru'n Water  (Read 587 times)

RPIScotty

  • Guest
Incorporating Bru'n Water
« on: November 14, 2015, 07:04:24 PM »
Does the upgraded version of Bru'n Water allow editing of the structure and function of the spreadsheet?

I know the free version is protected, and while unprotecting excel sheets is extremely easy, it seems rather unethical to do so.

I would really like to incorporate it into my brewing spreadsheet, i.e. have my recipe section input to the mash acidification tab, have all my volumes, malt colors, etc input as well.

Offline Stevie

  • Official Poobah of No Life.
  • *
  • Posts: 6858
    • View Profile
Re: Incorporating Bru'n Water
« Reply #1 on: November 14, 2015, 07:23:41 PM »
Mine is locked. I haven't tried unlocking it

RPIScotty

  • Guest
Re: Incorporating Bru'n Water
« Reply #2 on: November 14, 2015, 07:34:47 PM »

Mine is locked. I haven't tried unlocking it

Dang! It  would be great to integrate it into my Excel brewing sheet.

Offline AmandaK

  • Senior Brewmaster
  • ******
  • Posts: 1850
  • Redbird Brewhouse
    • View Profile
Re: Incorporating Bru'n Water
« Reply #3 on: November 14, 2015, 07:53:23 PM »

Mine is locked. I haven't tried unlocking it

Dang! It  would be great to integrate it into my Excel brewing sheet.
I just use the snipping tool on the summary tab and then put that in my normal brewday notes.
Amanda Burkemper
KC Bier Meisters Education Director
BJCP Assistant Education Director
BJCP Master/Mead

Redbird Brewhouse - There's Always a Project
Our Homebrewed Wedding, AHA Article

RPIScotty

  • Guest
Re: Incorporating Bru'n Water
« Reply #4 on: November 14, 2015, 07:57:14 PM »


Mine is locked. I haven't tried unlocking it

Dang! It  would be great to integrate it into my Excel brewing sheet.
I just use the snipping tool on the summary tab and then put that in my normal brewday notes.

I was thinking more along the lines of my recipe input section, volumes, malt colors, etc. inputting directly into Bru'n Water.

Offline Stevie

  • Official Poobah of No Life.
  • *
  • Posts: 6858
    • View Profile
Incorporating Bru'n Water
« Reply #5 on: November 14, 2015, 07:59:37 PM »
You could use vlookup to pull that data into your sheet and then paste as values to lock them in. It would be more of a hassle then typing them in, but it could be worth it if you are playing with your recipe constantly.

Edit - never mind. This would only be useful if you could add the vlookup to the Bru'n water sheet as well.
« Last Edit: November 14, 2015, 08:02:23 PM by Steve in TX »

RPIScotty

  • Guest
Re: Incorporating Bru'n Water
« Reply #6 on: November 14, 2015, 08:08:45 PM »

You could use vlookup to pull that data into your sheet and then paste as values to lock them in. It would be more of a hassle then typing them in, but it could be worth it if you are playing with your recipe constantly.

Edit - never mind. This would only be useful if you could add the vlookup to the Bru'n water sheet as well.

It's tough because your faced with a dilemma: Excel sheets are not tough to unprotect but doing so is unethical. I would only be using it for my personal benefit but I'm not sure the legality given Martin's copyright.

Offline Stevie

  • Official Poobah of No Life.
  • *
  • Posts: 6858
    • View Profile
Re: Incorporating Bru'n Water
« Reply #7 on: November 14, 2015, 09:12:43 PM »
I agree 100%. Email Martin and see if he could help you out for a bit of an extra donation.

RPIScotty

  • Guest
Re: Incorporating Bru'n Water
« Reply #8 on: November 14, 2015, 09:56:17 PM »
I agree 100%. Email Martin and see if he could help you out for a bit of an extra donation.

That was my next step.