Get your HBT Growlers, Shirts and Membership before the Rush!


Home Brew Forums > Home Brewing Beer > Brew Science > how to use spreadsheet
Reply
 
LinkBack Thread Tools
Old 08-29-2009, 01:39 PM   #1
Stubbs5150
Feedback Score: 0 reviews
Recipes 
 
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 Quick reply to this message
Old 08-30-2009, 08:27 PM   #2
pizzaman
Registered User
Feedback Score: 0 reviews
Recipes 
 
Join Date: Feb 2009
Location: San Antonio, TX
Posts: 852
Liked 3 Times on 3 Posts
Likes Given: 3

Default

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 Quick reply to this message
Old 08-30-2009, 09:26 PM   #3
bakins
Feedback Score: 0 reviews
Recipes 
 
Join Date: May 2008
Location: West Georgia
Posts: 731
Liked 4 Times on 4 Posts
Likes Given: 1

Default

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 Quick reply to this message
Reply



Quick Reply
Message:
Options
Thread Tools


Similar Threads
Thread Thread Starter Forum Replies Last Post
Brewing Spreadsheet albannach Brewing Software 7 08-22-2013 07:07 AM
I use my Excel Spreadsheet LS_Grimmy Brewing Software 15 08-07-2009 08:01 PM
AG spreadsheet? Does it exist? perkins98 All Grain & Partial Mash Brewing 7 03-31-2009 09: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



Newest Threads

LATEST SPONSOR DEALS