Fun with excel - Home Brew Forums
Home Brew Forums > Home Brewing Beer > General Beer Discussion > Fun with excel
Cool Brewing Giveaway - Supporting Membership Drive & Discount

Reply
 
Thread Tools
Old 02-13-2009, 09:55 PM   #1
uwjester
HBT_LIFETIMESUPPORTER.png
 
uwjester's Avatar
Recipes 
 
Sep 2007
Fort Collins, CO
Posts: 683
Liked 5 Times on 5 Posts



I have a bunch of interesting things going on in my brew-life lately. 10 gallon batches, bulk grain/hops buys, double brewing sessions with a friend. Given all of that, I decided I really needed to plan everything out. I put everything into an excel book, but what was really fun was the container scheduling. Kegerator, fermenters, and cornies. I thought I'd share and maybe inspire someone else to plan out their year.

Calendar

Notes:
BY is my friend. Any containers with his initials are for him.
Anything that is blue means it is lagering.
The calendar is by week.
There is more to the workbook, but this is the part worth sharing.


__________________
--------------------------------------------------
This space intentionally left blank.
--------------------------------------------------

 
Reply With Quote
Old 02-13-2009, 09:58 PM   #2
BierMuncher
...My Junk is Ugly...
HBT_MODERATOR.png
 
BierMuncher's Avatar
Recipes 
 
Jan 2007
St. Louis, MO
Posts: 12,374
Liked 775 Times on 432 Posts


I like how you're going to plow through your IIPA in three weeks.



 
Reply With Quote
Old 02-13-2009, 10:04 PM   #3
uwjester
HBT_LIFETIMESUPPORTER.png
 
uwjester's Avatar
Recipes 
 
Sep 2007
Fort Collins, CO
Posts: 683
Liked 5 Times on 5 Posts


Yeah, that's the weak point in the schedule. That's why I put one there that I know I'll be hitting pretty hard. I will (hopefully) be finishing off a couple of commercial kegs about that time, so I may use one of them if I need to.

Actually, I just noticed there was room in another column. Now I can relax and enjoy
__________________
--------------------------------------------------
This space intentionally left blank.
--------------------------------------------------


 
Reply With Quote
Old 02-13-2009, 10:32 PM   #4
JVD_X
HBT_LIFETIMESUPPORTER.png
 
JVD_X's Avatar
Recipes 
 
Jan 2008
Gainesville, Virginia
Posts: 1,467
Liked 4 Times on 4 Posts


Actually I was wondering if anyone had a "traditional" brewing schedule you could share... you know maibock brewed in october and tapped in May sort of thing.
__________________
- JVD_X

 
Reply With Quote
Old 02-13-2009, 10:56 PM   #5
Parker36
Recipes 
 
Sep 2007
Lesotho
Posts: 4,738
Liked 22 Times on 20 Posts


Quote:
Originally Posted by JVD_X View Post
Actually I was wondering if anyone had a "traditional" brewing schedule you could share... you know maibock brewed in october and tapped in May sort of thing.
There is one (actually saw it pop up on New Posts today)

 
Reply With Quote
Old 02-14-2009, 12:14 AM   #6
homebrewer_99
 
homebrewer_99's Avatar
Recipes 
 
Feb 2005
Atkinson (near the Quad Cities), IL
Posts: 17,781
Liked 123 Times on 95 Posts


Looks pretty good.

Question: Why so many white boxes???

There's been a few "schedules"...here's just one...I'm certain the format will go flat. Just cut and paste into a word doc and tab some columns in...the column seperation is easy to figure out.


<SPAN style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Verdana">Style When to%


__________________
HB Bill


 
Reply With Quote
Reply
Thread Tools


Similar Threads
Thread Thread Starter Forum Replies Last Post
Lets see your brewing Excel Spreadsheets LS_Grimmy General Beer Discussion 19 03-22-2011 10:57 PM
Need Some Excel Formatting Help jescholler Brewing Software 7 10-18-2009 10:50 PM
I use my Excel Spreadsheet LS_Grimmy Brewing Software 15 08-07-2009 07:01 PM


Forum Jump