My Mead making checklist - Home Brew Forums
Home Brew Forums > Wine, Mead, Cider, Sake & Soda > Mead Forum > My Mead making checklist
Cool Brewing Giveaway - Supporting Membership Drive & Discount

Reply
 
Thread Tools
Old 09-01-2013, 03:16 AM   #1
PCChazter
Recipes 
 
Jan 2013
Posts: 23


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!



 
Reply With Quote
Old 09-05-2013, 01:16 AM   #2
PCChazter
Recipes 
 
Jan 2013
Posts: 23

Any thoughts?



 
Reply With Quote
Old 09-05-2013, 02:30 AM   #3
Elgran
Recipes 
 
Aug 2013
Centerview, MO
Posts: 22
Liked 1 Times on 1 Posts


Nice Spreadsheet, I am using it right now to track my 4 one gallon batches of Hard Cider. It's Handy.

 
Reply With Quote
Old 12-10-2013, 06:39 AM   #4
PCChazter
Recipes 
 
Jan 2013
Posts: 23

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

 
Reply With Quote
Old 09-24-2014, 03:35 AM   #5
Leopardfish
Recipes 
 
Sep 2014
Posts: 1

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.

 
Reply With Quote
Old 09-24-2014, 05:14 AM   #6
PCChazter
Recipes 
 
Jan 2013
Posts: 23

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

 
Reply With Quote
Old 02-17-2015, 01:36 AM   #7
wc1376c
Recipes 
 
Oct 2014
Posts: 72
Liked 19 Times on 16 Posts


Please repost the checklist?!?!?!

 
Reply With Quote
Old 02-17-2015, 03:10 AM   #8
PCChazter
Recipes 
 
Jan 2013
Posts: 23

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?

 
Reply With Quote
Old 02-17-2015, 03:53 PM   #9
phil74501
Recipes 
 
Oct 2014
Posts: 173
Liked 10 Times on 6 Posts


I just downloaded it, and it works for me.

 
Reply With Quote
Old 02-17-2015, 04:36 PM   #10
SnakeRidge
Super Rad
HBT_SUPPORTER.png
 
SnakeRidge's Avatar
Recipes 
 
Feb 2012
East Nashville, Tennessee
Posts: 1,291
Liked 729 Times on 424 Posts


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



 
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