Membership questions? Log in issues? Email info@brewersassociation.org

« previous next »
Pages: 1 [2] 3   Go Down

Author Topic: Expense calculator  (Read 3775 times)

Offline breWglug

  • 1st Kit
  • *
  • Posts: 2
Re: Expense calculator
« Reply #15 on: January 21, 2015, 05:47:36 am »
flbrewer (and original poster):
Not unexpectedly it has been covered before. Should build on what is there already....
Can't make tapatalk work to paste link now. Strange.  but Google "homebrew excel". There is an old thread on homebrewtalk forum.
« Last Edit: January 21, 2015, 05:55:16 am by breWglug »
Logged

Offline flbrewer

  • Brewmaster General
  • *******
  • Posts: 2161
Re: Expense calculator
« Reply #16 on: January 21, 2015, 06:06:33 am »
OK, you can find something online I'm sure. If you know very basic Excel stuff, I would just simply make a column with all cost related stuff. Malt, Hops, Water, etc. going down the left hand side. Make the rows running from left to right your various beers you brew.

Add some simple sum functions and you've got a really simple calculator you can play with!  ;D
Logged

Offline ranchovillabrew

  • Brewer
  • ****
  • Posts: 321
Re: Expense calculator
« Reply #17 on: January 21, 2015, 07:08:38 am »
The cost feature for ingredients is already in beersmith.  You could then add your other items to the miscellaneous ingredients. (Time,  equipment,  fuel,  water, etc. )
Logged
- Charles

Offline TMX

  • Assistant Brewer
  • ***
  • Posts: 160
  • Evolution of the next Revolution
    • TxBrewing
Re: Expense calculator
« Reply #18 on: January 21, 2015, 07:44:23 am »
Thanks for all the hlp guys!
Logged
"The ART of brewing Beer, is the ACT of brewing Beer"
https://txbrewing.wordpress.com

Ferm 1: Irish Red Ale
Ferm 2:

On Deck: American Wheat

Keg 1: Un-Common
Keg 2: Switchback Stout

Total Gallons brewed (2015) - 10

Offline Jimmy K

  • Official Poobah of No Life. (I Got Ban Hammered by Drew)
  • *********
  • Posts: 3643
  • Delaware
Re: Expense calculator
« Reply #19 on: January 21, 2015, 08:51:01 am »
Quote from: ranchovillabrew on January 21, 2015, 07:08:38 am
The cost feature for ingredients is already in beersmith.  You could then add your other items to the miscellaneous ingredients. (Time,  equipment,  fuel,  water, etc. )
Great idea! For time one could add an hour to ingredients and the cost, then add X hours to each recipe. Equipment is tricky, but fuel, water, etc could be done the same way.
Logged
Delmarva United Homebrewers - President by inverse coup - former president ousted himself.
AHA Member since 2006
BJCP Certified: B0958

Offline hopfenundmalz

  • Global Moderator
  • I must live here
  • *****
  • Posts: 10687
  • Milford, MI
Re: Expense calculator
« Reply #20 on: January 21, 2015, 10:04:07 am »
Some time ago I came to the conclusion that I don't want to know. 
Logged
Jeff Rankert
AHA Lifetime Member
BJCP National
Ann Arbor Brewers Guild
Home-brewing, not just a hobby, it is a lifestyle!

Offline HoosierBrew

  • I must live here
  • **********
  • Posts: 13031
  • Indianapolis,IN
Re: Expense calculator
« Reply #21 on: January 21, 2015, 10:12:41 am »
Quote from: hopfenundmalz on January 21, 2015, 10:04:07 am
Some time ago I came to the conclusion that I don't want to know. 

Yeah.  It would be pretty substantial.
Logged
Jon H.

Offline flbrewer

  • Brewmaster General
  • *******
  • Posts: 2161
Re: Expense calculator
« Reply #22 on: January 21, 2015, 10:26:50 am »
Yeah I was about to say that. At first glance it seems cheaper but until you plug in the equipment cost and water, I think it'll take a bit to equal out.
Logged

Offline brewday

  • Brewer
  • ****
  • Posts: 453
Re: Expense calculator
« Reply #23 on: January 21, 2015, 10:41:41 am »
With some local 6-packs hitting $14-$16 here, my costs are actually looking pretty good!
Logged

Offline Pinski

  • Senior Brewmaster
  • ******
  • Posts: 1943
  • Portland, Oregon
Re: Expense calculator
« Reply #24 on: January 21, 2015, 10:48:46 am »
More rabbit hole...

Energy (propane, natural gas, electricity)
cleaning and waste water
Misc. ingredients (water adjustment)
Logged
Steve Carper
Green Dragon Brewers
Clubs: Oregon Brew Crew & Strange Brew
BJCP Certified

Offline hopfenundmalz

  • Global Moderator
  • I must live here
  • *****
  • Posts: 10687
  • Milford, MI
Re: Expense calculator
« Reply #25 on: January 21, 2015, 11:22:28 am »
pH meter and solutions.
Refractometer
A second pump, well you need a back up.
A 5 gallon system for smaller batches.
and so on.
Logged
Jeff Rankert
AHA Lifetime Member
BJCP National
Ann Arbor Brewers Guild
Home-brewing, not just a hobby, it is a lifestyle!

S. cerevisiae

  • Guest
Re: Expense calculator
« Reply #26 on: January 21, 2015, 11:27:57 am »
Quote from: hopfenundmalz on January 21, 2015, 10:04:07 am
Some time ago I came to the conclusion that I don't want to know.

+1
Logged

Offline erockrph

  • I must live here
  • **********
  • Posts: 7795
  • Chepachet, RI
    • The Hop WHisperer
Re: Expense calculator
« Reply #27 on: January 21, 2015, 01:49:47 pm »
If I didn't homebrew I'd be spending my time on other hobbies, which are generally way more expensive. So homebrewing saves me money in that respect. That's good enough for me.
Logged
Eric B.

Finally got around to starting a homebrewing blog: The Hop Whisperer

Offline dak0415

  • Brewmaster
  • *****
  • Posts: 558
  • Winston-Salem, NC
Re: Expense calculator
« Reply #28 on: January 21, 2015, 02:14:31 pm »
Quote from: erockrph on January 21, 2015, 01:49:47 pm
If I didn't homebrew I'd be spending my time on other hobbies, which are generally way more expensive. So homebrewing saves me money in that respect. That's good enough for me.
Me too! Keeps me off the golf course!
Logged
Dave Koenig
Anything worth doing - is worth overdoing!

Offline dak0415

  • Brewmaster
  • *****
  • Posts: 558
  • Winston-Salem, NC
Re: Expense calculator
« Reply #29 on: January 21, 2015, 02:15:29 pm »
Followed closely by - I don't want to know ;)
Logged
Dave Koenig
Anything worth doing - is worth overdoing!
Pages: 1 [2] 3   Go Up
« previous next »