Derren Green Posted May 25, 2017 Report Share Posted May 25, 2017 Hello Brewers, Most of you I am sure will order your components individually rather than as a boxed Brewprint to save some serious money. You will therefore know that the ordering screens are a bit long winded. I have whipped up this spreadsheet with a dozen or so of my favourite brews and made it easier to work out what to buy each time I order in bulk. Just tick the box under the brews you want and it will add it all up for you on the Left hand side. I use bottle/tablets not the liquid primer so I have left that out, but you can add it in. Anyhow, feel free to add more columns, change the brews etc - you need some basic excel skills to do so. It does make it a much quicker process though. Hope it helps. Ordering Spreadsheet Template.xlsx Link to comment Share on other sites More sharing options...
Pursya Posted May 25, 2017 Report Share Posted May 25, 2017 Cheers. Thats going to be a fantastic help. I stuffed up my last order and am short one ingredient for a brew. This will hopefully stop that happening. Must be a free delivery offer coming soon. In fact, there hasn't been any offers for a while from Brewart. Must be focused on the US. Link to comment Share on other sites More sharing options...
Big Pop Posted May 25, 2017 Report Share Posted May 25, 2017 Congratulations on the initiative Derren, it will certainly help when I soon begin to try brewing ingredients outside of the traditional brewprints. ? Link to comment Share on other sites More sharing options...
MattS Posted May 25, 2017 Report Share Posted May 25, 2017 Thanks for the template. Nice design by the way. You've saved me a lot of work as I was going to knock up something similar, but it wouldn't have looked as professional! Link to comment Share on other sites More sharing options...
dcm Posted June 8, 2017 Report Share Posted June 8, 2017 I did something a little different some months ago but couldn't upload it to the forum (stuck in some kind of moderation loop). I'll try again - the purpose was for me to: (a) Be able to understand what I needed to order for Brewprints without the extra stuff of an actual Brewprint (b) Be able to learn the associations between what I liked and the ingredients. Hopefully this time it will post ok.. Don BrewPrints_v2.xlsx Link to comment Share on other sites More sharing options...
Pursya Posted June 8, 2017 Report Share Posted June 8, 2017 That's a massive amount of information! I made up two Excel files. One was the Brewprints ingredients with just the name, brew times and ingredients. The other is an Excel file with the ingredient list at the top and six "boxed" rows below. When choosing a brew to order I simply copy the entire line from the first file into the blank "ordering" file. Then it's an easy process to delete each column that has no ingredients chosen. Then autosum gives me a total for each column in a thick lined box at the bottom, print and you have a list ready to order. Easy! Link to comment Share on other sites More sharing options...
Beard Droid Posted June 9, 2017 Report Share Posted June 9, 2017 Wow! Thanks DCM, That would've taken a some time (and a few beers) to put together. Cheers ? Link to comment Share on other sites More sharing options...
dcm Posted June 11, 2017 Report Share Posted June 11, 2017 Here is a version 2.1 - this version tracks total quantities and order cost. I just used this to calculate my shopping list for my next 5 brews including two DIY experiments (you can create DIY recipes on this). BrewPrints_v2.1.xlsx Link to comment Share on other sites More sharing options...
Shem Mankey Posted June 27, 2017 Report Share Posted June 27, 2017 Hi Guys, Here is a simple, easy to use spreadsheet I created a little while ago for my own use, and have now seen this and thought others might like it. I recently shared it on the Facebook group but maybe not everyone here is on there. This spreadsheet has 3 tabs, one for all the BrewPrint data, one for printing out and keeping with the droid for referencing recipe on brew day and 1 for online ordering - online order helper tab is a very simple process, select all the brew/s you want from the drop down list and it will give you the totals for everything you need at the bottom - making ordering super easy, no excel experience is needed, I believe this is fool proof. Hopefully it helps someone... Cheers, Shem Brew Prints Ingredients List - Jun 17.xlsx Link to comment Share on other sites More sharing options...
TROY SWEETING Posted September 9, 2017 Report Share Posted September 9, 2017 Shem you are awesome... thanks to your spread sheet and the free delivery I have these bad boys ordered today Link to comment Share on other sites More sharing options...
Captain 3 Droids Posted March 3, 2019 Report Share Posted March 3, 2019 Good stuff with the spread sheets. The presentation and packaging of the BrewPrints is excellent however being a ss keg brewer I don’t need the primers nor the cleaning tab so I’ll be buying the required ingredients. Link to comment Share on other sites More sharing options...
Captain 3 Droids Posted March 6, 2019 Report Share Posted March 6, 2019 It is a pity you can’t buy the BrewPrints without the primer as they cater only for BrewFlo, bottling or natural priming in your own kegs. Co2 carbonation doesn’t require them. Of course you can order the ingredients individually however the BrewPrint boxes are a treat. Link to comment Share on other sites More sharing options...
Seth Schramm Posted March 7, 2019 Report Share Posted March 7, 2019 Barrelboy - I'd suggest joining the Facebook group for BrewArt owners. Those forums are much more active than this one and can really get into some stimulating conversations. Hope to see you there! Link to comment Share on other sites More sharing options...
Captain 3 Droids Posted March 7, 2019 Report Share Posted March 7, 2019 1 hour ago, Seth Schramm said: Barrelboy - I'd suggest joining the Facebook group for BrewArt owners. Those forums are much more active than this one and can really get into some stimulating conversations. Hope to see you there! Thanks Seth, as I’m not up to scratch with social media Facebook is a bit daunting. I did join once and got tons of emails from people all over the world wanting to be my friend. Could get rid of it/them so haven’t been back. regards Mark Link to comment Share on other sites More sharing options...
Seth Schramm Posted March 7, 2019 Report Share Posted March 7, 2019 Sorry to hear that. Well if you change your mind 600 BrewArt owners will be there! Link to comment Share on other sites More sharing options...
dcm Posted March 10, 2019 Report Share Posted March 10, 2019 I agree with Barrelboy. There are some very good reasons why some of us can't really afford to open up our lives to Facebook. I won't be joining Facebook and if that's where Brewart choose to hang out then great - their choice, count me out... Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.