Jump to content


Photo
- - - - -

Brewhouse Supply Spreadsheet


  • Please log in to reply
8 replies to this topic

#1 Hentai

Hentai

    Member

  • Members
  • PipPip
  • 37 posts
  • LocationBrookfield,IL

Posted 05 March 2010 - 01:10 PM

Does anyone have a spread sheet of the ingredients they keep on hand?You know to keep track of malt, hops, yeast, extras.Would you like to share? Too lazy and inept to do it myself.Thanks

#2 CaptRon

CaptRon

    Comptroller of jokes about violence against women

  • Patron
  • PipPipPipPipPip
  • 31546 posts
  • LocationRight behind you!

Posted 05 March 2010 - 02:08 PM

Check out the one that diesel put together: Check it

#3 Deerslyr

Deerslyr

    Disliker of Nut Kicking

  • Patron
  • PipPipPipPipPip
  • 23807 posts
  • LocationGod's Country!

Posted 05 March 2010 - 02:42 PM

Check out the one that diesel put together: Check it

Yeah, Chuck has a very comprehensive and detailed worksheet. I'd like to be able to use it, but I'm just a simple caveman lawyer and these things confuse me. :rolf: I use BeerSmith software. It has a function to keep track of your stores, including prices. I don't use it because I don't necessarily keep that much on hand. I use it more for formulating my recipes, determining my boiloff and gravities, etc.

#4 zymot

zymot

    Comptroller of Small Amounts of Money

  • Patron
  • PipPipPipPipPip
  • 25633 posts
  • LocationMortville

Posted 06 March 2010 - 11:17 AM

Does anyone have a spread sheet of the ingredients they keep on hand?You know to keep track of malt, hops, yeast, extras.Would you like to share? Too lazy and inept to do it myself.Thanks

I know it is not exactly what you are asking for.Beersmith has an integrated inventory feature. Plus you can create recipes and calcualtions and all kinds of stuff the homebrew would like.

#5 Hentai

Hentai

    Member

  • Members
  • PipPip
  • 37 posts
  • LocationBrookfield,IL

Posted 06 March 2010 - 06:44 PM

Check out the one that diesel put together: Check it

Wowza! Thats serious. I have been using beertools forever. I should suggest they create an inventory list as well. Access anywhere any time.Thanks

#6 ChefLamont

ChefLamont

    Comptroller of Fear

  • Members
  • PipPipPipPip
  • 9734 posts
  • LocationAtlanta

Posted 06 March 2010 - 08:02 PM

Promash has an inventory feature that I use for hops. I dont really use it for anything else, but if you stuck with it, it would be pretty helpful.

#7 MyaCullen

MyaCullen

    Cheap Blue Meanie

  • Patron
  • PipPipPipPipPipPip
  • 68759 posts
  • LocationSpokane, WA

Posted 07 March 2010 - 02:14 PM

Promash has an inventory feature that I use for hops. I dont really use it for anything else, but if you stuck with it, it would be pretty helpful.

I am still using Promash also, it works great for all the inventory items IF you pay strict attention to the details, as the inventory item must be exactly the item used in the brew session for the software to track it.

#8 chuck_d

chuck_d

    Frequent Member

  • Members
  • PipPipPipPip
  • 1022 posts
  • LocationAtlanta, GA

Posted 08 March 2010 - 06:04 PM

Yeah, Chuck has a very comprehensive and detailed worksheet. I'd like to be able to use it, but I'm just a simple caveman lawyer and these things confuse me. :smilielol: I use BeerSmith software. It has a function to keep track of your stores, including prices. I don't use it because I don't necessarily keep that much on hand. I use it more for formulating my recipes, determining my boiloff and gravities, etc.

Holla if you got questions. After giving guys a demo in Munich I decided I need to make a video demo, there's just so much that the learning curve makes it hard to adopt I think. Such a long TODO list... ugh.But yeah, if you use the purchasing and financial sheets too, you can use it to plan your purchases. Build a recipe then add items to purchasing that are missing from inventory, add items from purchasing to inventory when they arrive, and subtract a recipe's components from inventory when you brew it all through clicking buttons. I need to work on making this all more transparent, which I think a few videos could really help to do.

#9 ChefLamont

ChefLamont

    Comptroller of Fear

  • Members
  • PipPipPipPip
  • 9734 posts
  • LocationAtlanta

Posted 08 March 2010 - 06:49 PM

I am still using Promash also, it works great for all the inventory items IF you pay strict attention to the details, as the inventory item must be exactly the item used in the brew session for the software to track it.

Agreed. And like any inventory I guess it is an all-or-nothing proposal if it is going to work out. That is why I only use it for hops, but I really should use it for specialty grains as well because lately it seems like I have a ton of specialties but never the ones I need. :smilielol:


0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users