Varimixer Recipe Manager (VRM)

Recipe Manager for the ERGO Series

The Recipe Manager is based on an Excel sheet with macro enabled.
It’s required to have Windows and Excel installed to make the Varimixer Recipe Manager for ERGO to work.

SIMPLIFIED STEP BY STEP USER GUIDE FOR VARIMIXER RECIPE MANAGER

The Varimixer Recipe Manager (VRM) is a tool that makes it possible to write new or edit existing recipes in the control panel for the ERGO mixer on PC. Recipes are written or edited in the VRM program. The finished recipe is saved on a USB stick, which is then connected to the machine for transfer using the control panel on the mixer. Recipes can now be included in the mixer’s operation.

See below on the page for detailed instructions. (After STEP 8)

STEP 1:

Download
Varimixer Recipe Manager

Download here

STEP 2:

Open
Varimixer Recipe Manager

Filename of what you downloaded:

varimixer_RecipeManager_v110.xlsm

Enable Excel to work with macros!

Excel must be set to work with macros to enable the Varimixer Recipe Manager.

1. File > 2. Options > 3. Trust centre > 4. Trust centre settings > 5. Macro settings > 6. Enable trust VBA projects

STEP 3:

Download the template recipe file from the ERGO machine
Export the recipe file from the menu on the ERGO touch panel to a FAT-32 formatted USB stick

STEP 4:

Insert the USB stick to your computer and export a recipe file

Connect the USB Flash drive to the post located on the back of the machine.

1.2 Select on the machine’s control panel:
1.2.1 Menu
1.2.2 Recipe
1.2.3 USB (PIN code 2345) USB button on control panel lights up green)
1.2.4 Recipe -> USB

The Back panel of the ERGO Serie

The USB input has a IP65 protection to gain a waterproof workflow

STEP 5:

Import the downloaded recipe file inside Varimixer Recipe Manager

STEP 6:

Make your recipe settings in Varimixer Recipe Manager

STEP 7:

Export the recipe file to the USB stick via Varimixer Recipe Manager

STEP 8:

Import the recipe file from the USB stick into the ERGO Mixer via the VL-5 control panel menu

Connect the USB Flash drive to the post located on the back of the machine.

2.3.4 Insert the USB stick into the USB port located at the back of the mixer
2.3.5 Press on the mixer’s control panel:
2.3.5.1 Menu
2.3.5.2 Recipe
2.3.5.3 USB (PIN code 2345 is entered. USB button lights up green)
2.3.5.5 Press recipe -> USB for transfer
2.3.5.6 Receipt shows that the recipe file has been transferred
The new recipes can now be checked in the recipe overview on the machine.

Varimixer Recipe Manager (VRM) – Detailed from the User manual

VRM is a tool that makes it possible to write new or edit existing recipes on a computer.

The finished recipe is saved on a USB Flash drive, which is then connected to the machine for transfer using the control panel on the mixer.

VRM program is downloaded from varimixer.com.

1. Transfer from mixer to USB Flash drive

When a new recipe for the mixer is written or an existing recipe needs to be adapted, start by transferring the recipe file from the mixer to a USB Flash drive.

1.1 Connect the USB Flash drive to the post located on the back of the machine.
1.2 Select on the machine’s control panel:
1.2.1 Menu
1.2.2 Recipe
1.2.3 USB (PIN code 2345) USB button on control panel lights up green
1.2.4 Recipe -> USB see also 3.2.

PIN code protection can be selected or unselected, see menu 5.1.

2. Work with recipe file in Varimixer Recipe Manager (VRM)

2.1 Open recipe file from USB Flash drive in VRM
2.1.1 Open the Varimixer Recipe Manager in Excel, see 3 enable macros
2.1.2 Press Import file to transfer recipe file from USB Flash drive to VRM. File name is 00003_Recipelist
2.1.3 Mark mixer size in the checkbox. 60 or 100/140
2.1.4 To correct the transferred recipe file, press Edit recipe. User interface for changing recipe steps opens.
2.1.5 After the recipe change is completed, the recipe is transferred to the USB Flash drive by pressing Export file
2.2 Editing the transferred recipe file.
2.2.1 Editing a recipe line is started by doubleclick on the recipe line, alternatively highlight the line and press Edit.
2.2.2 Other editing functions can be read in Figure 1
2.2.3 After finishing editing, press the Save button and then Close
2.2.4 The edited recipe file is now ready for transfer to the USB Flash drive
2.3 Transferring recipe from USB Flash drive to mixer
2.3.1 After finished editing recipe file, transfer the file to USB Flash drive, and then to the machine
2.3.2 Insert the USB Flash drive into the PC’s USB port
2.3.3 Press Export file in VRM. Accept overwriting of the the existing file. The edited recipe file is now saved on
USB Flash drive
2.3.4 Insert USB Flash drive into the port located at the back of the mixer.
2.3.5 Select on the mixer’s control panel:
2.3.5.1 Menu
2.3.5.2 Recipe
2.3.5.3 USB (PIN code 2345) USB button on control panel lights up green)
2.3.5.5 Press recipe -> USB for transfer
2.3.5.6 Receipt shows that the recipe file has been transferred

The new recipes can now be checked in the recipe overview on the machine. See Menu overview 3.0 in operating instructions.

3. Enable Excel to work with macros. Excel must be set to work with macros to enable the Varimixer Recipe Manager and require Windows.