Home Brew Forums > Wine, Mead, Cider, Sake & Soda > Mead Forum > My Mead making checklist
Reply
 
Thread Tools
Old 09-01-2013, 03:16 AM   #1
PCChazter
Feedback Score: 0 reviews
Recipes 
 
Join Date: Jan 2013
Posts: 23
Default My Mead making checklist

Template.xlsx

This is what I have been using to record my mead making. Feel free to use it, edit it, copy it, delete it, etc. Some of the sheets are protected, to avoid accidental editing, but there is no password protecting them (pink-ish boxes are still editable).

There are 7 pages:

Worksheet: Information on the type of brew, and batch number (I used the format of "M00", replacing 00 with an incrementing number)

Ingredient info: Fill in the ingredients you used here. Use the drop downs on the ingredient and unit, fill in the other pink boxes, and it will do the rest. The OG is just a calculation, and does not take the place of an actual measurement. The ABV is calculated from the OG and the FG on this sheet (which you can change). You can also fill in what you use for backsweetening, and it will calculate the SG after backsweetening, and the new diluted ABV.

Routine Checks: Every time you take a SG or pH reading, put it here with the date, and a few notes. It will use the numbers you put here to display the correct OG, FG, pH levels and ABV on the Worksheet, as well as graphs on sheets "Specific Gravity" and "pH"

Densities: This is where the Ingredient Info sheet gets its info for the density of each ingredient. Add to this list if you have an ingredient that is not on the list, and it will show up on the list.

Units: This is the conversion table for the Ingredient Info sheet. All the common unit conversions should be on here, but if it isn't, add it here.


If you end up changing something that could help out, or make this sheet better (like adding ingredients), post it in the comments!


PCChazter is offline
 
Reply With Quote
Old 09-05-2013, 01:16 AM   #2
PCChazter
Feedback Score: 0 reviews
Recipes 
 
Join Date: Jan 2013
Posts: 23
Default

Any thoughts?


PCChazter is offline
 
Reply With Quote
Old 09-05-2013, 02:30 AM   #3
Elgran
Feedback Score: 0 reviews
Recipes 
 
Join Date: Aug 2013
Location: Blaine, MN
Posts: 21
Liked 1 Times on 1 Posts

Default Nice

Nice Spreadsheet, I am using it right now to track my 4 one gallon batches of Hard Cider. It's Handy.
Elgran is offline
 
Reply With Quote
Old 12-10-2013, 06:39 AM   #4
PCChazter
Feedback Score: 0 reviews
Recipes 
 
Join Date: Jan 2013
Posts: 23
Default

I have made a few updates to the mead making checklist.

-better ingredient page that displays 1/3 and 2/3 marks
-multiple racking addition options
-current ABV uses info from the ingredient info page instead of routine checks page

Just thought I would share this, in case anyone else is using this.

here
PCChazter is offline
 
Reply With Quote
Old 09-24-2014, 03:35 AM   #5
Leopardfish
Feedback Score: 0 reviews
Recipes 
 
Join Date: Sep 2014
Posts: 1
Default software needed to download?

Quote:
Originally Posted by PCChazter View Post
Template.xlsx

This is what I have been using to record my mead making. Feel free to use it, edit it, copy it, delete it, etc. Some of the sheets are protected, to avoid accidental editing, but there is no password protecting them (pink-ish boxes are still editable!
Where did you upload this to? I keep getting a page that wants to install software to download the file and I'm not really interested in download software... :-(

The spreadsheet 'sounds' pretty cool.
Leopardfish is offline
 
Reply With Quote
Old 09-24-2014, 05:14 AM   #6
PCChazter
Feedback Score: 0 reviews
Recipes 
 
Join Date: Jan 2013
Posts: 23
Default

Quote:
Originally Posted by Leopardfish View Post
Where did you upload this to? I keep getting a page that wants to install software to download the file and I'm not really interested in download software... :-(

The spreadsheet 'sounds' pretty cool.
The link should take you to an adf.ly link. Just wait for the yellow button at the top right to say "SKIP AD", and click it.

Alternatively, I have been slowly changing the format of the checklist as I use it, and have incorporated some VBA macros. The link for that is here

If you still can't download the first one, let me know
PCChazter is offline
 
Reply With Quote
Old 02-17-2015, 01:36 AM   #7
wc1376c
Feedback Score: 0 reviews
Recipes 
 
Join Date: Oct 2014
Posts: 61
Liked 12 Times on 10 Posts

Default Please repost

Please repost the checklist?!?!?!
wc1376c is offline
 
Reply With Quote
Old 02-17-2015, 03:10 AM   #8
PCChazter
Feedback Score: 0 reviews
Recipes 
 
Join Date: Jan 2013
Posts: 23
Default

Quote:
Originally Posted by wc1376c View Post
Please repost the checklist?!?!?!
I seem to be able to download it just fine. Are you still having problems?
PCChazter is offline
 
Reply With Quote
Old 02-17-2015, 03:53 PM   #9
phil74501
Feedback Score: 0 reviews
Recipes 
 
Join Date: Oct 2014
Posts: 127
Liked 8 Times on 5 Posts

Default

I just downloaded it, and it works for me.
phil74501 is offline
 
Reply With Quote
Old 02-17-2015, 04:36 PM   #10
SnakeRidge
Super Rad
HBT_SUPPORTER.png
Feedback Score: 0 reviews
Recipes 
 
Join Date: Feb 2012
Location: East Nashville, Tennessee
Posts: 1,296
Liked 726 Times on 423 Posts
Likes Given: 554

Default

I'll check it out. I made 2 1 gallon batches over the weekend so I've got some data


SnakeRidge is offline
 
Reply With Quote
Reply


Thread Tools


Similar Threads
Thread Thread Starter Forum Replies Last Post
first try at mead making richlindks Mead Forum 3 06-21-2013 03:22 AM
The act of making mead??? dummkauf Mead Forum 10 09-21-2010 09:09 PM
Making mead right now, need help please! Schnitzengiggle Mead Forum 10 07-19-2010 06:04 PM
So I want to try making some mead, what else do I need to know? humann_brewing Mead Forum 24 04-25-2010 03:02 AM


Forum Jump

Newest Threads

LATEST SPONSOR DEALS