Using the Fermentation Worksheets (aka Ferm Gen)

The Fermentation Worksheets (aka Ferm Gen) are tools in InnoVint to help you create multiple tasks and work orders for fermentation management during harvest.

The Fermentation Worksheets allow you to quickly view the current status of your must lots and assign analysis, addition, and fermentation management tasks to your crew all from a single page.

There are 2 available Fermentation Worksheets for different vessel types in InnoVint: one for Tanks and Bins and one for smaller vessels (ie Barrels, Steel Drums, Kegs, and Carboys). The worksheets are very similar in look and function, with just a few small differences. Continue reading for a more in depth look!

This article covers:

• Navigating the Fermentation Worksheets
  • View
    • Columns and Sorting 
    • Vessel/Lot details and Brix/Temps data
    • Hoverable data: actions, work orders, additions
  • Selections
    • Work Order Title
    • Show recent analysis values/graphs
    • Saving Drafts & Loading Previous Data
    • Clear Fields
    • Assigning a due date
• Creating tasks
  • Analysis
  • Additives
  • Fermentation Management tasks
• Assigning and creating work orders
• Printing the Ferm Gen
• Tips for using the Ferm Gen for multiple owners
• FAQs

Navigating the Ferm Gen

What can I view in a Fermentation Worksheet?

• Tanks and Bins

This worksheet populates with a list of tanks and bins which contain lots that are currently in the Processed, Fermenting, Settling, and Cold Soak stages.

• Barrels, Steel Drums, Kegs, and Carboys

This worksheet populates with a list of lots currently in barrels, steel drums, kegs, and carboys. Only lots in the Processed, Fermenting, Settling, and Cold Soak stages are listed.

Columns and Sorting

You can sort your list by clicking on the header of any of the following columns:

• Vessel - by vessel code.

The Barrels, Steel Drum, etc. worksheet will display the number of each vessel type (including tanks and bins), or the vessel code if there is only one

• Lot - by lot code
• Owners - by owner tag (for accounts with Owner-based Permissions activated)
• Stage - by current stage (Click here for instructions on how to change the stage of a lot)
• Contents - by weight, then by volume 

The Tanks and Bins worksheet displays the volume or weight in the vessel for each row.

The Barrels, Steel Drum, etc. worksheet displays the total lot volume or weight, including any tanks and/or bins. 

• Processed date - by date the lot was Processed to Gallons or Tons
• Brix - by most recent Brix reading for that vessel or lot composite
• Temperature - by most recent Temperature reading for that vessel or lot composite

You can also manually drag and drop rows by clicking and dragging the gray horizontal bars at the ends of each row.

View: Vessel/Lot details and Brix/Temps data

• Vessels - click on the vessel code to open the Vessel details page in a new tab (Tanks and Bins Worksheet only)
• Lots - click on the lot code to open the Lot details dashboard in a new tab
• Recent Brix/Temperature readings - Click on the Brix or Temperature value to open the Brix/Temp graph in the Lot details > Analysis tab. Make sure to select a vessel or lot composite to view the appropriate graph.

Tanks and Bins: The worksheet shows the most recent recorded analysis on the lot or vessel. 

Barrels, Steel Drums, etc.: The worksheet shows the most recent recorded analysis on the lot composite.

Hoverable data

•  - displays up to 3 of the most recent actions recorded to that lot and/or vessel
•  - displays up to 3 of the most recent work orders completed or assigned to that lot and/or vessel
•  - displays up to 3 of the most recent Addition actions or tasks recorded to that lot and/or vessel
•  - warning icon alerts you if there have not been any recent actions on a vessel. This warning will only show for red ferments.

Selections

1. Work Order Title

The Work Order title pre-populates with the current date, followed by 'Ferm. Management'. This field can be edited at any time. Choose 'AM', 'Mid', or 'PM' to add the time of day to precede the Work Order title, or choose 'None' to leave it out. 

2. Show recent analysis values/graph

Click this option to toggle between the graphs and 3 most recent data points.

3. Drafts & Previous Work Orders

Save as draft:

If you are in the middle of creating work orders in the Ferm Gen and need to navigate away from the page before you are finished, make sure to save your work as a draft to save your selections.

Load draft or previous generator data:

Drafts and previously created work orders will be saved to and accessed from the dropdown list.

4. Clear Fields

By clicking on 'Clear Fields' (bottom left corner) you will remove all current selections, including all requested analysis panels, additives, other tasks, and assigned persons. It will, however, retain the order of you lots in the list.

5. Due date

The current date will pre-populate the due date of the work order. Make sure to edit this field to assign it to a different day.

Creating tasks in the Ferm Gen

 Analysis tasks

Analysis tasks can be assigned by selecting an analysis panel from a dropdown list.

An analysis panel can be applied to all vessels/lots in the worksheet, or to specific vessels/lots only. To remove assigned analysis panels in bulk, click on the Analysis column header and select Clear all. To remove or change an analysis panel for an individual vessel or lot, click on the panel name in the vessel row and select Remove or an alternative panel. You will only be able to select one panel per vessel row.

Analysis requested in the Tanks and Bins worksheet are for individual vessels.

Analysis requested in the Barrels, Steel Drums, etc. worksheet are for lot composites, including any tanks or bins if the lot is split between large and small vessels. To request analyses for individual barrels, etc., we recommend creating recurring work orders with an analysis task.

 

Addition tasks

Addition tasks can be assigned through the Fermentation Worksheet by clicking on    in each vessel/lot row. This will open a slideover of the Addition task where you can add one or multiple additives to vessels.

To edit additive tasks, click on the additive(s) in the vessel row. This will automatically remove your previous additive selection and you can start over. 

Fermentation Management tasks

Other fermentation management tasks can be assigned by clicking on   in each vessel row.

Select a task from the dropdown list and include instructions (optional).

To remove a task, click on the task name in the vessel row and select Remove task.

To add additional tasks, click on the  and follow the same instructions as above.

 

Assigning and Creating Work Orders

Assigning Work Orders

A winery member must be assigned to a vessel to create the work order for that vessel. Unassigned vessels will be left out.

To assign a single Ferm Gen work order to one person, click on   in the column header. Select a winery member from the drop down to assign all tasks to one person. Assigned vessels are highlighted green. Unassigned vessel rows will not have a work order created.

To change or remove the assigned party, click on their name in the vessel row and select Remove or another winery member name from the list.

Each winery member with assigned tasks will receive one work order each.

When a vessel has an analysis, addition, or other task applied to it and a person has been assigned the work, the row will highlight in green. Work orders will only be created for highlighted rows. 

Create work orders

Double check your Work Order title and due date before creating your work order(s). The number of work orders created will correspond to the number of parties assigned, and only for rows highlighted in green. If a vessel has no assigned parties and/or tasks, the work order(s) will NOT be created.

Once a work order is created it will be saved to your previously created work order list.

Printing the Ferm Gen

At the bottom right corner of the Ferm Gen you will see the  button.

The default option will print the current page as-is (even without selections) and will not create work orders in InnoVint or save it as a draft.

 

If you click on the caret to the right, you will see that there is another option: Print separate pages per assignee.

This will split the worksheet into multiple pages for each assignee in the order in which they are assigned, from top to bottom. In the example below on the left, 4 different worksheets will be printed.

To avoid printing multiple pages per assignee, drag and drop the vessels in the list using the gray horizontal bars at the far left or right of the row, ordered by assignee. (See the example below on the right.)

Tips for using the Ferm Gen for multiple owners

The Ferm Gen requires you to choose an owner for the created work order. We do not recommend creating a single, Global work order for all clients as this allows all owners to view the details of the entire work order, including analysis data and additives.

There are 2 ways we recommend using the Ferm Gen for multiple owners.

1. Allow owners to create their own work orders, or
2. Create separate work orders for each owner

Start by sorting the Ferm Gen by the Owner column. Create tasks for each vessel/lot, but only assign a winery member to one ownership. Create the work order, selecting the corresponding ownership tag. Next, unassign those vessels that you just created a work order for, and assign a winery member to the vessels for the next ownership. Repeat the same steps as above until you have created a separate work order for each ownership tag.

Each created work order - one for each owner - will be saved separately in the "Load previous work orders" dropdown.

FAQs

Q: Why can't I see my individual barrel analysis in the barrel fermentation worksheet? 

A: This worksheet shows the most recent analyses by lot composite only. Individual barrels, drums, kegs, and carboys are not tracked in this report. If you want to see analyses by individual barrel, we recommend creating a unique lot code for each barrel and running a lot composite reading on each lot code.