Calculations on brew sheets with ingredients specifications

Hi Luke,
I feel like for us an many brewers this is a very important feature that could save us hours every week.
At the moment we have to do enter into our brewing software Promash all our recipes and batches and copy the results into Breww. And we need to do double entries in both softwares for inventory. It is very time consuming.
The whole idea of having an integrated system like Breww is to gain time and have seamless communication between inventory, production, distribution, accounting etc…
But on the production side, Breww allows us to record most informations but doesn’t have the essential functionalities. Promash was developed decades ago, it is simple, complete and overall the best stock, recipe and batch management software for pro brewers you can find (apart from the looks). It is not getting developped anymore but it shouldn’t be hard to copy. Particularly when you already have so much infos in Breww.

Again if you need help to understand how promash works I am happy to spend some time with you on it.

Because it is not sustainable for us to continue with Breww while this is missing.

3 Likes

Thanks, Vincent. We know how important this project is, and don’t worry, it’s tagged as a “key project” for us, so it will certainly be done before too long, but we don’t have a date yet for when this will be built.

It’s useful to know about Promash (I must admit that it’s not one we have heard of before). I think we’re fairly clear on what’s needed, but it may be useful to have a call; thank you. We may be in touch when we’re ready to start work on this project. We also have three people in our team who used to work as brewers before they joined the team, so there’s quite a bit of hands-on knowledge in-house already, which we’ll also be calling on to help plan this project.

1 Like

I’m just linking this with Recipe-level variables for Calculated Fields as the two are related and may be built in conjunction.

1 Like

@vincent-de-soyres ,

Great points.

@luke ,

The mash, sparge and liquor back volume calculators would be really useful, however the volumes calculated must then be available in the ‘Add’ action in the recipe - at the moment you can only add a pre-determined volume in the recipe, but these will change from brew to brew.

All the best,

Pat

4 Likes

Thanks Pat, it’s great to have your input on this.

Could you also give Recipe-level variables for Calculated Fields, e.g. allow "Add ingredient" quantity to be the result of a calculation a vote? I think you’d find this useful too :+1:

1 Like

Hi Luke,

Could you add a few custom fields (as in fields we could name ourselves) for ingredients in the inventory receipt, in the same way you added the alpha acids for hops?
If we could add to breww all the specs of the hops (alpha acids, Beta acids and Oil level), malt (EBC, coarse dry extract, moisture etc…) and sugars (dry extrac,t moisture levels, colour) when we receive them, we could use this data either in calculation fields in the brewing schedule or in a googlesheet that I am happy to develop and integrate via the API.
In the same way if you could add custom fields to our equipment especially to the brewhouse, we could have: Thermal mass of the mash tun, Grain absoption rae in L/kg, wort cooling shrinkage in %, Malt Heat Capacity, Evaporation rate in L/ hour. This is not needed if we use a googlesheet, as we could have those constant figures in the googlesheet.
With those infos we could run everything simply of breww and a googlesheet.
Is that possible?

1 Like

Yes, absolutely; these are the kinds of fields and options that we’re going to be adding as part of this project.

It may be possible to expose these via the API too, but the primary aim will be for you to do all the calculations you need directly within Breww, rather than building something that requires specialist knowledge (APIs) and having to take data out of Breww and into spreadsheets. We will have built-in calculations, like the current alpha-acid calculations, as well as allowing you to write your own formulas.

1 Like

Hi Luke,

Do you have a rouch idea of when those will be available?

CHeers

2 Likes

One of our dev team is finishing up a few projects and then we expect them to start on this and some other production-related improvements. I’d expect this to be done in early 2024 :smile:

1 Like

Any updates on this? It would be really useful to enter malt data and get the brewhouse efficiency. This is a key parameter for brewers.

We know this is very important and it’s a high priority for us, but its not been started yet, I’m sorry. We’ll let you know when we know more.

October 2021 was when this feature request was first requested.

Is there any update on any of the suggestions in this thread?

If BREWW was able to recognise ‘Grain/Malt’ on a recipe sheet to then be able to add up your total ‘Grain Bill’, this may be really useful.

We could then build our own calculated fields for automatically work out Liquor ratios and volumes etc.

2 Likes

Thanks for the suggestion on a total grain bill variable that can be used in calculated fields. I can see how this could be really useful.

I’m sorry, but there’s no update to report on this yet. We’ve been busy working on other requests, but do hope to get to this soon. Please make sure you have voted for it (if you haven’t already).

Please see How do I know if there’s been an update on a feature request?

Thank you :smile:

1 Like

Good news, we’ve also now added the ability to record Extract and Colour on grain stock items :tada:

Just like with alpha acid on hops, you can record their expected values on a stock item and in the recipe, as well as select if you’d like Breww to automatically adjust the quantity added based on the values of the batch used.

This feature request obviously covers much more than this, but rather than delay introducing everything until it is all complete, we’ll be launching the improvements incrementally to allow you to take advantage of each part as they’re completed :muscle:

Hi Max and team
This is a good step forward but couple of quick things. Is the LDK being recorded “as is” or “dry” as this has an impact on the calculations. It would be useful to know how the data is being used to change the recipe. Is it possible to see the calculation being made. Also the EBC needs to be four digits before the decimal not three as things like chocolate malt could be 1200.
Cheers
John

1 Like

Hi,

I also would like to be able to calculate Mash and Brewhouse efficiency from the data we add into each brew. If this were done automatically that would be great, but in the mean time, is there any way to extract the relevant data (pre-boil vol and SG etc) across a selected number of Gyles (ie by style or fermenter etc)?
Cheers
Simon

1 Like

Hi John - thanks for the feedback! The extract was intended for an “as-is” basis, so we’ve renamed it to clarify. We’ve also updated the maximum digits for EBC colour :ok_hand:

In terms of the calculation, Breww calculates the total expected litre degrees for that malt addition by multiplying the expected LDK by the total quantity in the recipe. Then, it is divided by the batch’s LDK used to get the adjusted quantity.

So, as a formula:

AdjustedQuantity = \frac{ExpectedQuantity\times ExpectedLDK}{ActualLDK}

Hi Simon! The plan is for Breww to start doing this automatically, but we also have this feature request here to support exporting all this data: Recipe Reporting Tags and custom reports. I’d recommend voting and subscribing to that thread, and if you have any specific requirements for it to also please let us know there :+1: Thanks!

Just to be awkward… we have a (malt) supplier who gives only “dry basis” on their CoA (for some products). They also give “moisture” so I guess we could convert this to “as is”. It would be nice if there was the option to enter Extract (LDK dry) and moisture, so that Breww would do this conversion for us.

And another thing, at least one of our malts is specified with %extract (coarse, dry), so we could really do with this conversion built in also.

4 Likes