View previous topic :: View next topic |
Author |
Message |
ddc69
Joined: 13 Jan 2012 Posts: 118 Location: Parkersburg, WV
|
Link Posted: Mon Apr 15, 2013 11:48 pm Post subject: Brew Sheet |
|
|
I have been working on this sheet for a while to do my own calculations and design beers without using a software package. I thought I would post it for others to check out. Very Geeky, I admit, but I wanted to understand how the calcs were done and validate software programs such as Beersmith. There are instructions and in-document hyperlinks in the instructions on how to use the sheets. Again, maybe a little too Geekish and no-one may care, but I thought I would share my work for others to play around with.
I had to save this as a macro free file to attach to site so sort and print macro will not work from download but you can get the "jist" of it.
Description: |
|
Download |
Filename: |
Copy of BATCH NOTES v4 wo macros.xlsx |
Filesize: |
97.24 KB |
Downloaded: |
1030 Time(s) |
|
|
Back to top |
|
|
huaco
Joined: 05 Apr 2012 Posts: 1506 Location: Burleson Texas
|
Link Posted: Tue Apr 16, 2013 1:48 am Post subject: |
|
|
So you are basically formulating your own version of BeerSmith?
That is a crazy spreadsheet man! I'm impressed. (this coming from a 'non-spreadsheet guy'...)
|
|
Back to top |
|
|
g8tors
Joined: 05 Oct 2011 Posts: 211
|
Link Posted: Tue Apr 16, 2013 2:14 am Post subject: |
|
|
Looks great. I love doing things like this with Excel. Have you done any visual basic programming in Excel? Some pretty cool thing you can do I'm learning.
Scott
|
|
Back to top |
|
|
huaco
Joined: 05 Apr 2012 Posts: 1506 Location: Burleson Texas
|
Link Posted: Tue Apr 16, 2013 2:40 am Post subject: |
|
|
Oh good grief! You can program in excel??
|
|
Back to top |
|
|
ddc69
Joined: 13 Jan 2012 Posts: 118 Location: Parkersburg, WV
|
Link Posted: Tue Apr 16, 2013 10:35 am Post subject: |
|
|
I still use beersmith for a lot of things but wanted something I could use on my own and fully understand what was going on behind the scenes. I learned a lot researching the data while building it.
I'm not the best vb programmer so I haven't tried too much on that end yet.
|
|
Back to top |
|
|
|
|