Electric Brewing Supply 30A BCS Giveaway!


Home Brew Forums > Home Brewing Beer > DIY Projects > Prioritizing Homebrew Projects / Brewery Additions
Reply
 
LinkBack Thread Tools
Old 10-03-2014, 03:28 PM   #1
TheGAC
Beer GOOOOD! Napster BAD!
HBT_LIFETIMESUPPORTER.png
Feedback Score: 0 reviews
 
TheGAC's Avatar
Recipes 
 
Join Date: Dec 2007
Location: Keizer, Oregon
Posts: 168
Liked 3 Times on 3 Posts
Likes Given: 33

Default Prioritizing Homebrew Projects / Brewery Additions

So I’m scrolling through HomeBrewTalk the other day, and of course I’m in my favorite section of the forums, the DIY Projects area… I came across a thread started by LandoLincoln called, “How to prioritize projects for your brewery”. The light bulb finally clicked on! I’ve been spending years just picking this or that to do, and there hasn’t been any real rhyme or reason as to why I went with this choice or that choice.

There have been a few projects that I did where the result was great, the item is great, I’m totally glad to have this item for the brewery, but in the back of my head I wished that I picked something else to add instead. Why did I choose to build this instead of that?

Well, now thanks to LandoLincoln’s idea, I now am able to answer why I should build this, and not that. I now have a way to quantify my brewery projects, instead of just running with the wild hairs that decide to tickle every now and then.

I approached this task in the same way that Lando did… I made a list of all the things I have been logging into the brain-housing-group as cool projects:

  • Filter my own water
  • Get a grain mill
  • Get a keg washer
  • Rebuild my stirplate (doesn’t work as well as I’d like it to)
  • Install better lighting in my garage
  • Add a thermometer to the Keggle
  • Add a sightglass to the Keggle
  • Get a chest freezer to make a Keezer
  • Add taps in the Keezer (versus just opening it and using the picnic tap)
  • Add a temperature controller to the fridge
  • BrewNanny Pro
  • GrowlerWerks uKeg

I created this spreadsheet using Google Docs, that way all I need is an internet connection and I can update this spreadsheet with new projects as needed. I laid it out in the same fashion that LandoLincoln did… list the project, and the criteria that I believe should be deciding factors:
  • Do I already have the equipment needed for this build?
  • Does this make better beer?
  • Is this just for brewing purposes, or does this project benefit the garage also?
  • Save time
  • Save money
  • How much does this cost?

I have more factors involved here, but I just wanted to list a few so you get the idea. A lot of the criteria I used I stole straight from Lando’s post. (hope you don’t mind, brother)

Once I laid it all out, it started to look like this:



Here’s where I started to make this project a little different from Lando’s. Lando went through and x’d out the boxes he thought this project should be categorized:



After he x’d out the boxes, he replaced the x’s with a value he thought that column deserved. I’m lazy, once I x out the box, I don’t want to have to go back and replace it… how do I get this spreadsheet to recognize the x, and assign a value to it automatically? Time to send an email to my co-worker’s husband who is a database guy.

I explained to Joe what I was wanting to accomplish, and he told me to do this:

The first column, the score, has several "if" statements wrapped up in a sum.

=SUM((IF(C2="x",8,0))+(IF(D2="x",7,0))+(IF(E2="x",6,0))+(IF(F2="x",5,0))+(IF(G2="x",4,0 ))+(IF(M2="x",-3,0))

It evaluates like this...

Take the sum of the following:

if cell C2 has an x, then assign 8 points, else assign 0 points
then add that to
if cell D2 has an x, then assign 7 points, else assign 0 points
then add that to
...
etc...
...
then add that to
if cell G2 has an x, then assign -3 points, else assign 0 points

(IF(G2="x",-3,0))
(IF(CELL="string",true,false)

You can add any number of columns and have any number of rows simply by modifying the top formula, then using the "Fill Down" functionality of Excel.


After that, I formatted the Priority column to take any score below Zero and turn that text Red, any score above 15 and turn that text Green. I haven’t filled it all out yet, so these scores aren’t final, but hopefully you get the gist as to what is going on:



Once I have the scores for the projects, I can evaluate which ones I should do first, and hopefully get rid of that feeling of I should have maybe done a different project first.

Hopefully this makes sense, if there’s anything I can help out with, please let me know.
__________________
Blackened Brew
Keizer, Oregon

Primary: WTF, it's empty!
Secondary: WTF, it's empty!
On-tap: WTF, it's empty!
On-deck: Raging Red Irish Ale
TheGAC is offline
CptMidway Likes This 
Reply With Quote Quick reply to this message
Old 10-04-2014, 02:55 AM   #2
LandoLincoln
HBT_SUPPORTER.png
Feedback Score: 0 reviews
 
LandoLincoln's Avatar
Recipes 
 
Join Date: Feb 2011
Location: Joliet, IL
Posts: 2,157
Liked 539 Times on 317 Posts
Likes Given: 13

Default

Nice work! I like the cell formulas. Now you need to get a macro button on the spreadsheet to sort the projects by their score and you'll be all set!

I don't know if Google Sheets does macro buttons though.

__________________
www.jolietbrewersguild.org
LandoLincoln 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
How to prioritize projects for your brewery LandoLincoln DIY Projects 9 10-03-2014 09:45 PM