Thagomizer Posted April 24, 2022 Report Share Posted April 24, 2022 I usually buy my BrewPrint ingredients separately since I do not use all the items in the BrewPrint. Therefore, I created a spreadsheet to organize the inventory since an order for several recipes can get complicated. To use it, you only edit cells E39 through AN52. (This is bordered for easy access.) Aussies will also need to edit column C since the current prices are USA amounts. Also, the prices on column C can be subject to change. Cells B37 and B39 are checksums to assure agreement between the recipe items and the grand total of items. These cells should not be modified. I hope this spreadsheet will be useful. It is currently loaded with my latest pending order. You will need to edit cells E39 through AN52 for your own use. Happy brewing. 🙂 Pending BrewArt Order.xlsx 1 3 Link to comment Share on other sites More sharing options...
Thagomizer Posted August 5, 2022 Author Report Share Posted August 5, 2022 (edited) Please use this update. Corrections have been made and there is a better layout . This still needs an edit for Ausie prices - especially now. Pending BrewArt Order_2.xlsx Edited August 5, 2022 by Thagomizer 2 Link to comment Share on other sites More sharing options...
Thagomizer Posted August 5, 2022 Author Report Share Posted August 5, 2022 Obviously, column C of the spreadsheet needs updating for prices. The current content of E2 through AO20 is my current order status waiting for the next "free shipping beyond $200" opportunity. The columns to the right are personal notes on potential substitutions of ingredients. The contents of cells E2 through AO20 are subject to my daily whims and desires. When the next free-shipping opportunity arises, it will be launched. Just order everything on your column "B." Cheers. 🙂 1 1 Link to comment Share on other sites More sharing options...
Thagomizer Posted August 7, 2022 Author Report Share Posted August 7, 2022 I just discovered that Shem has a spreadsheet that does essentially the same thing as mine. Had I known that I would not have posted my own as a new benefit. I had no intension of competing with an already established effective system. However, I will continue to use my own. Viva Shem. And thanks for all that effective work. Link to comment Share on other sites More sharing options...
Captain 3 Droids Posted August 7, 2022 Report Share Posted August 7, 2022 33 minutes ago, Thagomizer said: I just discovered that Shem has a spreadsheet that does essentially the same thing as mine. Had I known that I would not have posted my own as a new benefit. I had no intension of competing with an already established effective system. However, I will continue to use my own. Viva Shem. And thanks for all that effective work. I have the Shem setup however I’m also using yours not for ordering purposes but check expenditure on brews I do. It is a helpful tool so thanks. 1 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now