We really struggle to use the batch schedule in its current format for anything other than assigning ‘today’s’ brew to the brewhouse to communicate to the brewers which recipe to use.
I have a few suggestions:
I would much prefer the batch schedule to be switched from vertical to horizontal i.e. days down the vertical and columns for each tank and equipment (canning line/kegging line). This is much easier to see on any given day which tanks are utilised.
It would be great if each ‘beer’ had a predefined number of days in tank, days fermenting, dry hop / fruit additions, diactyl rest, conditioning and defined number of days in brite rather than having to assign days in FV each time you create a batch (this can always be manually adjusted later if required). At the moment there are no stages to tick off other than ‘chill’ and ‘carbonate’. I would love if we could include these further categories (I’m sure there are more useful ones too).
It would be good if when you plan the batch you enter the desired volume and the system then worked out how many recipe turns are required and it books these in to the brew house (based on your bh volume). That would be much simpler to adjust if we later decide to increase or decrease the volume.
The block in the vertical column could then show key actions planned to be taken on any day (e.g. how many dry hops, when the temp changes are required). This would make summarising the cellar activities much clearer.
As the beer progresses manual adjustments can be made to the time in tank and any other action to be taken +/- days depending on progress.
Calendar settings could be predefined to show working week and available brew and packaging slots.
These adjustments would make the batch schedule a workable tool for me and allow me to move away from a monster spreadsheet.