Membership questions? Log in issues? Email info@brewersassociation.org

Author Topic: Feedback on New Water Spreadsheet  (Read 8425 times)

Big Monk

  • Guest
Re: Feedback on New Water Spreadsheet
« Reply #60 on: January 18, 2017, 04:22:53 pm »
  • Fermenter Trub Loss is liters vs gallons/etc for other fields (mentioned already)
  • Kettle Trub Loss does not seem to affect fermenter volume

Try using the g/oz dropdown next to kettle trub loss.

This may be a candidate for a free form entry.

I mistyped - it's the 'Kettle Equipment Loss' that does not seem to affect anything, and is already a free form entry field.

Also, the 'Fermenter Trub Loss' does not appear to have the drop-down you speak of.

Both of these fields are under the VOLUME heading, if that helps.

1.) good catch. Kettle equip loss is not accounted for.

2.) drop down is next to kettle trub loss

Big Monk

  • Guest
Re: Feedback on New Water Spreadsheet
« Reply #61 on: January 18, 2017, 04:57:35 pm »
It also appears that color is ignored on base grains. Shouldn't it use color unless an override pH is entered?

Hopefully people always use the distilled pH bit your point is valid. It should default to color based if no pH is entered or throw an error.

I see no harm in having it default to a color based calc with no pH entered.

Big Monk

  • Guest
Re: Feedback on New Water Spreadsheet
« Reply #62 on: January 18, 2017, 06:03:18 pm »

It also appears that color is ignored on base grains. Shouldn't it use color unless an override pH is entered?

You feedback got me thinking about another way to approach this:

Obviously the preferred method is to enter actual DI pH values but in lieu of that, I'll reinstate the color based base Malt acidity and allow the user to change the arbitrary DI pH value (Kai = 5.6, BW = 5.75) used in the pH calc to a user custom.

Big Monk

  • Guest
Re: Feedback on New Water Spreadsheet
« Reply #63 on: January 19, 2017, 05:19:46 am »
All comments from yesterday have been incorporated:

1.) Volume issues corrected
2.) Low Oxygen yes/no dropdown provided for color estimation
3.) Color based pH estimations restored as follows:
      - If user leaves DI pH user input blank or 0, sheet defaults to color based calculations for base malts
      - User can select a custom DI pH default for use in the color based estimations
4.) Issues with mineral salt amounts corrected
5.) Kettle trub loss made a user input
6.) Data validation issues with grain selection and water profile selection corrected

Link in original spot in thread or find it in my signature.

Thanks for all the feedback!

Offline natebriscoe

  • Assistant Brewer
  • ***
  • Posts: 195
Re: Feedback on New Water Spreadsheet
« Reply #64 on: January 19, 2017, 07:23:45 am »
On the beta 1 the water profile table don't seem to work right anymore.

Offline stpug

  • Brewmaster
  • *****
  • Posts: 742
Re: Feedback on New Water Spreadsheet
« Reply #65 on: January 19, 2017, 08:12:30 am »
-The 'Low Oxygen?' field is not a drop-down or is protected (i.e. it's not toggleable).
-The 'Kettle Trub (gal)' field is protected (i.e. does not accept focus from cursor).
-The 'Fermenter Trub Loss (l)' is still the only metric field under the VOLUME heading.
-There is a long list of red-font water profile names way out in the right margin of of the MAIN sheet
« Last Edit: January 19, 2017, 08:35:00 am by stpug »

Big Monk

  • Guest
Re: Feedback on New Water Spreadsheet
« Reply #66 on: January 19, 2017, 08:40:16 am »
All set. Updated and accessible through the link in my signature.

Offline natebriscoe

  • Assistant Brewer
  • ***
  • Posts: 195
Re: Feedback on New Water Spreadsheet
« Reply #67 on: January 19, 2017, 01:22:11 pm »
I don't feel like acid malt is contributing to the ph adjustment.

Big Monk

  • Guest
Re: Feedback on New Water Spreadsheet
« Reply #68 on: January 19, 2017, 01:49:47 pm »
I don't feel like acid malt is contributing to the ph adjustment.

You are correct! It's a logic error.

I don't have time fix it today but I will sort it out in the morning and re-upload a corrected sheet.

Thanks!

Big Monk

  • Guest
Re: Feedback on New Water Spreadsheet
« Reply #69 on: January 20, 2017, 08:43:33 am »
I don't feel like acid malt is contributing to the ph adjustment.

All set. I fixed it this morning and Version BETA1.1 is here:

http://www.lowoxygenbrewing.com/uncategorized/water-a-new-water-chemistry-spreadsheet/

Big Monk

  • Guest
Re: Feedback on New Water Spreadsheet
« Reply #70 on: January 23, 2017, 05:09:01 am »
I don't feel like acid malt is contributing to the ph adjustment.

All set. I fixed it this morning and Version BETA1.1 is here:

http://www.lowoxygenbrewing.com/uncategorized/water-a-new-water-chemistry-spreadsheet/

Version β1.2 is up with some fixes spotted by users at HBT.

Big Monk

  • Guest
Re: Feedback on New Water Spreadsheet
« Reply #71 on: January 24, 2017, 05:46:10 am »
Version BETA.1.4 is up at the post in my signature.

I did some work on correcting the mineral additions this morning.

Big Monk

  • Guest
Re: Feedback on New Water Spreadsheet
« Reply #72 on: February 03, 2017, 01:15:02 pm »
I have pulled the sheet from LOB.com to do some maintenance and bug fixing. I will hopefully have it back up early this week.


Sent from my iPhone using Tapatalk

Big Monk

  • Guest
Re: Feedback on New Water Spreadsheet
« Reply #73 on: February 03, 2017, 01:45:28 pm »
Glad to hear you're make some UI adjustments. The amount of information is too much for one sheet.

Some troubleshooting and maintenance had now prompted me to work on the long promised full revision. Expect some good things.