how to use spreadsheet - Home Brew Forums
Register Now For Free!

Home Brew Forums > Home Brewing Beer > Brew Science > how to use spreadsheet

Thread Tools
Old 08-29-2009, 12:39 PM   #1
May 2008
Posts: 28

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.

Reply With Quote
Old 08-30-2009, 07:27 PM   #2
Registered User
Feb 2009
San Antonio, TX
Posts: 680
Liked 4 Times on 4 Posts

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.

Reply With Quote
Old 08-30-2009, 08:26 PM   #3
bakins's Avatar
May 2008
West Georgia
Posts: 728
Liked 6 Times on 6 Posts

This is a cool "interactive" version of it:

Mash pH Nomograph

The numbers at the top represent the range of estimated SRM.

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