how to use spreadsheet - Home Brew Forums
Home Brew Forums > Home Brewing Beer > Brew Science > how to use spreadsheet
Cool Brewing Corny 5G & Mini Giveaway
Sign-up To NEW HBT Article Newsletter - Brewing Articles Direct To You!

Thread Tools
Old 08-29-2009, 12:39 PM   #1
Feedback Score: 0 reviews
Join Date: May 2008
Posts: 28
Default how to use spreadsheet

ok i'm stumped. i've been trying to punch numbers into palmers spreadsheet but i can't get it to work. or any of the other spreadsheets for that matter. everyone has been really helpful on here so if anyone could walk me through the process. i have my water profile i just don't know if i'm not doing it correctly on my computer or maybe i don't have the correct program to run the spreadsheets.

thanks for any help.

Stubbs5150 is offline
Reply With Quote
Old 08-30-2009, 07:27 PM   #2
Registered User
Feedback Score: 0 reviews
Join Date: Feb 2009
Location: San Antonio, TX
Posts: 678
Liked 4 Times on 4 Posts
Likes Given: 3


is it the spreadsheet from here: How to Brew - By John Palmer - Residual Alkalinity and Mash pH ?
are you opening them in microsoft excel, open office, or a similar program?

if yes, the spreadsheet is color coded. wherever you see a yellow box is where you input your data, the blue-green boxes will change automatically based on what you input. the spreadsheet is unprotected and unlocked so if you happen to change any fields other than the yellow ones you pretty much need to delete the file and download it again to be sure you're getting correct data.
pizzaman is offline
Reply With Quote
Old 08-30-2009, 08:26 PM   #3
Feedback Score: 0 reviews
Join Date: May 2008
Location: West Georgia
Posts: 728
Liked 6 Times on 6 Posts
Likes Given: 1


This is a cool "interactive" version of it:

Mash pH Nomograph

The numbers at the top represent the range of estimated SRM.
bakins is offline
Reply With Quote

Thread Tools

Similar Threads
Thread Thread Starter Forum Replies Last Post
Brewing Spreadsheet albannach Brewing Software 7 08-22-2013 06:07 AM
I use my Excel Spreadsheet LS_Grimmy Brewing Software 15 08-07-2009 07:01 PM
AG spreadsheet? Does it exist? perkins98 All Grain & Partial Mash Brewing 7 03-31-2009 08:22 PM
Help with Palmer's RA Spreadsheet BigNastyBrew All Grain & Partial Mash Brewing 2 02-09-2009 09:44 PM
spreadsheet shrades Mead Forum 7 01-20-2009 12:57 AM

Forum Jump