Happy HolidaySs Giveaway - Last Sponsor Giveaway of the Year!

Come Enter the BrewDeals/FastFerment Giveaway!


Home Brew Forums > Home Brewing Beer > General Beer Discussion > Fun with excel
Reply
 
LinkBack Thread Tools
Old 02-13-2009, 09:55 PM   #1
uwjester
HBT_LIFETIMESUPPORTER.png
Feedback Score: 0 reviews
 
uwjester's Avatar
Recipes 
 
Join Date: Sep 2007
Location: Fort Collins, CO
Posts: 736
Liked 4 Times on 4 Posts
Likes Given: 1

Default Fun with excel

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.
--------------------------------------------------

uwjester is offline
 
Reply With Quote Quick reply to this message
Old 02-13-2009, 09:58 PM   #2
BierMuncher
...My Junk is Ugly...
HBT_MODERATOR.png
Feedback Score: 0 reviews
 
BierMuncher's Avatar
Recipes 
 
Join Date: Jan 2007
Location: St. Louis, MO
Posts: 12,220
Liked 607 Times on 353 Posts
Likes Given: 230

Default

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

BierMuncher is online now
 
Reply With Quote Quick reply to this message
Old 02-13-2009, 10:04 PM   #3
uwjester
HBT_LIFETIMESUPPORTER.png
Feedback Score: 0 reviews
 
uwjester's Avatar
Recipes 
 
Join Date: Sep 2007
Location: Fort Collins, CO
Posts: 736
Liked 4 Times on 4 Posts
Likes Given: 1

Default

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.
--------------------------------------------------


uwjester is offline
 
Reply With Quote Quick reply to this message
Old 02-13-2009, 10:32 PM   #4
JVD_X
HBT_LIFETIMESUPPORTER.png
Feedback Score: 4 reviews
 
JVD_X's Avatar
Recipes 
 
Join Date: Jan 2008
Location: Gainesville, Virginia
Posts: 1,492
Liked 3 Times on 3 Posts

Default

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

JVD_X is offline
 
Reply With Quote Quick reply to this message
Old 02-13-2009, 10:56 PM   #5
Parker36
Feedback Score: 0 reviews
Recipes 
 
Join Date: Sep 2007
Location: Lesotho
Posts: 4,776
Liked 22 Times on 20 Posts
Likes Given: 4

Default

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)
__________________
Parker36 is offline
 
Reply With Quote Quick reply to this message
Old 02-14-2009, 12:14 AM   #6
homebrewer_99
Feedback Score: 0 reviews
 
homebrewer_99's Avatar
Recipes 
 
Join Date: Feb 2005
Location: Atkinson (near the Quad Cities), IL
Posts: 17,951
Liked 87 Times on 77 Posts
Likes Given: 1

Default

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

homebrewer_99 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
Lets see your brewing Excel Spreadsheets LS_Grimmy General Beer Discussion 19 03-22-2011 11:57 PM
Need Some Excel Formatting Help jescholler Brewing Software 7 10-18-2009 11:50 PM
Any Excel genuises out there? RIBeer General Chit Chat 7 09-16-2009 07:43 PM
I use my Excel Spreadsheet LS_Grimmy Brewing Software 15 08-07-2009 08:01 PM



Newest Threads

LATEST SPONSOR DEALS