If you are using alternative metric names in vintrace as compared to the column headers output by your Admeo/Bio systems Y15 you will need to read the following section, otherwise skip ahead to requesting/importing results.

Alternatively you can adjust the metric names on the computer connected to your Admeo/Bio systems Y15 machine or modify the resulting CSV export/report manually.

Mapping metric names between Admeo/Bio systems Y15 to vintrace

Open the Address Book and add a new Organization for Admeo/Bio systems Y15 by clicking Add – Organization.

Assign the Laboratory Role then click Edit to bring up the options to Configure Laboratory Settings.

Click on Configure Metric Names. On the left side are your metrics in the system, the right side Admeo/Bio systems Y15 names for those metrics. When you are done mapping metrics click the OK button to save them.

If your metric names differ from Foss names you can map them here. We recommend that you configure your Lab with the appropriate metric mappings so that the column names from the Admeo/Bio systems Y15 export file match your metric names in vintrace.

Requesting Analysis

Now when you make analysis requests within vintrace you can select Admeo/Bio systems Y15 as your lab.

You may request Lab work can from any single wine from the Product Overview screen by selecting Actions – Print Lab Label.

To request analysis on multiple wines select them from the Bulk wine search, click on Lab Work.

Select Admeo/Bio systems Y15 as the Laboratory from the drop down, select the appropriate Analysis Template; check (tick) the box next to Print Labels, then click OK.

The Lab ID that is generated will need to enter into the Admeo/Bio system Y15 as the Sample ID, will be the barcode (if using a barcode scanner) or “AT” number.

Once the analysis is complete you can export the report from the Admeo/Bio system Y15 software as below.

To upload the results into vintrace, open the Lab Console. On the bottom left of the window, there is an Import format box, select Admeo/Bio system Y15 from the drop down.

Next select Choose File to browse for the report you wish to import then click Load from File.

The completed analysis will automatically be imported into vintrace. Double check the values to ensure they are correct.

Once the results have been uploaded, there are three actions available:

You can View the analysis

Update to temporarily save the analysis without confirming them or saving them against the wine so you can perform other operations first

You can now set how many lab results will appear per page in Lab Console. By default, the number of results per page is set to 50.

Go to Consoles – Lab.

You can change the number of results per page by typing your desired setting in the results per page text box then clicking on the heart icon. In the example below, we entered 20 and then click on the heart icon.

So next time you hit on Search button, the number of results per page will be set to 20. Please note that any actions such as exporting the results to CSV/PDF, updating, confirming, or reversing the lab results will only be applied to the current page you are viewing.

Another way to change the number results per page for a specific user is by going into Winery Setup – Work-flow – Defaults – User tab. Go to Lab Console Settings section. Then change the Records per page field to your desired number of results per page. Then click on Apply button.

To assist you in matching your metrics with ETS for either direct download from their website or importation of their csv file, we are providing tables from which you may copy and paste into the metric mapping dialog box.

The following table represents the most commonly requested ETS analyses:

alcohol at 60F

Allergen-Egg

Allergen-Milk

ammonia

apparent alcohol (at 60F)

basic juice profile

Botrytis Panel

bottled sterility - bacteria only

bottled sterility - yeast and bacteria

brix

Brix (Balling) - densitometer

carbon dioxide

chemistry panel

citric acid

color profile

conductivity test-Davis

copper (AA)

cork sterility (Rankine)

density

dissolved oxygen

ethanol at 20C

ethanol at 20C (GC)

ethylphenols

European Community Export Certificate

fining trial (Pocock & Waters) - control

free sulfur dioxide

glucose + fructose

heat stability (Pocock & Waters)

Japan export analyses

juice yeast culture

L-lactic acid

L-malic acid

pH

potassium

residual sugar

'Scorpion' Juice Bacteria Panel

'Scorpion' Juice Panel

'Scorpion' Juice Yeast Panel

'Scorpion' Wine Bacteria Panel

'Scorpion' Wine Panel

'Scorpion' Wine Yeast Panel

'Smoke Taint' panel

'Smoke Taint' panel- berry sample

specific gravity

tartaric acid

titratable acidity

total acidity

total acidity (as acetic acid)

total sulfur dioxide

turbidity (turbidimeter)

volatile acidity (acetic acid)

volatile acidity(acetic)

wine bacteria culture

These metrics can be used for either the direct connection to ETS via the web or for the downloadable csv file.

Please note that this list is subject to change by ETS without prior notice.

For more information on the analyses available from ETS for mapping against your own metrics, please visit https://www.etslabs.com/analyses

This feature allows you to select an analysis template to be used to sort the metrics when you export the CSV or PDF from Lab Console, generate the Analysis data export, or generate the Lab job worksheet. You also have the option to exclude metrics not on the selected analysis sort template and to include columns for metrics in the sort template even if there are no requests present.

Using analysis sort template in Lab Console

Firstly, you need to request lab work for some wines you want to run through the lab. Please refer to this post on how to request, export, and import lab jobs.

For our example below, we have requested a lab sample with the following metrics selected: Alcohol, Amino, and Baume.

Go to Console – Lab Console. You can see the lab work you have requested with the three metrics Alcohol, Amino, and Baume.

Let’s say you want to export the lab request to a CSV file but you want the metrics to be sorted according to an analysis template that you already have. For this example we have an analysis template, ‘Brix and Alcohol’ where Brix is listed first then Alcohol.

Click on the menu icon beside the CSV button on the lower part of the Lab Console screen.

In Analysis Sort Template field, click on the magnifying glass icon to search for the analysis template you want to use. In the example below, we have selected ‘Brix and Alcohol’ analysis template, which lists the Brix first then the Alcohol metric.

We also ticked the Exclude metrics not on the selected analysis sort template and Include columns for metrics in the sort template even if there are no requests present checkboxes. Then click on Save button to save the selection. You can also click on the heart icon beside the options so that vintrace will remember your selection.

Click on CSV button to generate the CSV output.

In the CSV output, the metrics are sorted according to how the metrics appear in the Brix and Alcohol analysis template, where Brix is listed first. Amino and Baume is not in the CSV since we have Exclude metrics not on the selected analysis sort template and Include columns for metrics in the sort template even if there are no requests present option selected. Brix is included in the CSV output even though there was no lab request for it because we have selected the Include columns for metrics in the sort template even if there are no requests present option.

Using analysis sort template in Lab job worksheet

Go to Winery Reports – Product analysis – Lab job worksheet. We want to see the lab work requested in the previous section. Under Metrics, select Alcohol, Amino, and Baume.

In the Advanced Report Options – Analysis Sort Template, select ‘Brix and Alcohol’. Let’s assume we want to see all the metrics requested plus any metrics that are in the analysis template even though there are no requests for it, so tick on Include columns for metrics in the sort template even if there are no requests present checkbox.

Click on Generate button.

In the generated results, the metrics is sorted in the following order: Brix, Alcohol, Amino, and Baume. If there are metrics included that are not in the analysis template, it will be added to the end of the list. In this case, Amino and Baume are added after Brix and Alcohol.

Using analysis sort template in Analysis data export

Go to Winery Reports – Product analysis – Analysis data export. Assuming that the lab requests from the previous sections have been completed and we want to export the analysis data and sort the metrics according to the ‘Brix and Alcohol’ analysis template. In Advanced Report Options, select ‘Brix and Alcohol’ in the Analysis Sort Template. Then click on Generate button.

In the CSV output, the metrics are sorted in the following order: Alcohol, Amino, and Baume. Brix is not included in the output since we did not have the Include columns for metrics in the sort template even if there are no requests present option selected

If you are using alternative metric names in vintrace as compared to the metric names output by your Chemwell equipment, you will need to read the following section, otherwise skip ahead to Requesting Analysis section.

Mapping metric names between vintrace and Chemwell

Open the Address Book and add a new Organization for Chemwell by clicking Add – Organization.

Enter Company Name, assign the Laboratory Role, and then click Edit to bring up the options to Configure Laboratory Settings.

Click on Configure metric names.

Click on Add line button to add metric mappings. On the left side are your metrics in vintrace, the right side are the Chemwell names for those metrics. When you are done mapping metrics click the Ok button to save them.

If you would like to keep your Chemwell results separate from other analysis results you can also create new metrics and map them on the mapping screen.
E.g. Acetic acid [Chemwell] -> VIN AA Assay to 1.0

Requesting Analysis

Make analysis requests within vintrace and select Chemwell as your lab.

You can request Lab work from any single wine from the Product Overview screen by selecting Actions – Print lab label.

Alternatively, you can request analysis on multiple wines by selecting them from Search – Product Search and then click on Lab Work button.

Select Chemwell as the Laboratory from the drop down, select the appropriate Analysis Template; tick the Print Labels checkbox, then click OK button.

The Lab ID that is generated will need to be entered into the Chemwell software as the Name/ID.

When you run your analysis make sure to register it with the Lab ID from vintrace; this is important for importing the results back into vintrace.

Uploading Chemwell results into vintrace

Once the analysis is complete you can export the report from the Chemwell software as a CSV and import it into vintrace. The following column headers in the CSV are important as they will be mandatory in vintrace when you upload the file:

Name/ID

Test

Mean (in Conc)

To upload the results into vintrace, open the Lab Console. On the bottom left of the window, select Chemwell under Import Format dropdown menu.

Click on Choose File to browse for the report you wish to import then click Load from File.

The completed analysis will automatically be imported into vintrace. Double check the values to ensure they are correct.

Once the results have been uploaded, there are three actions available:

You can View the analysis.

Update to temporarily save the analysis without confirming them or saving them against the wine so you can perform other operations first.

The Lab tab in Product Overview shows the latest lab analyses for the bulk product and has been enhanced to show more useful data such as the current value, last value, the dates they were taken, and the rate of change of the metrics.

You have the option to show the exact date and time the lab analysis was done by ticking on the Show dates checkbox.

There are several options to filter the data to be shown on the table. You can use the Filter button to select which metrics you want to be displayed. You can also filter by Metric validity and the date range the lab work was done.

A chart to show metrics data over time can be displayed by ticking on the checkbox beside the metric in the table.

Clicking on the chart icon at the line entry for each metric will show a line graph for that specific metric only. And in the metric history chart, you can select a date range you want to show the chart in.

You can also request for lab work from the Lab tab by either selecting an Analysis template or selecting the metrics from the table and then click on the beaker icon.

The Lab tab in the Block Overview shows fruit maturity data as recorded into the system for this block each season and has also been enhanced to show data such as the current value, last value, the dates they were taken, and the rate of change of the metrics for analysis entered against this block for a selected vintage.

There are few ways to go about removing analysis jobs scheduled in the lab console. Once these are deleted there is no getting them back. So please make sure you delete the correct tasks.

The first method is from the lab console itself. You can locate the job you no longer need click the View button and then select Cancel Job.

For analysis jobs that are not on a work order, the alternative method is via the Consoles – Classic Scheduled Tasks and is a much better way to remove multiple jobs. Select Incomplete from the Status drop down list and select Analysis from the Operation Type list. You should then be presented with the list of all scheduled analyses that haven’t been assigned to a work order. Then you can simple click the Delete button to remove an individual task or highlight multiple tasks and use the Delete selected button.

For analysis jobs on a work order, go to Consoles – Job management. Select the status of the work order you want to delete (in this case Draft and Ready statuses were selected) and select Analysis from the Operation type. Then click on Search button.

This will bring up a list of all your analysis jobs. Select the work orders you want to delete then click on Actions button then Cancel selected.

This allows you to reverse the analysis for all completed lab entries in view within the lab console. You can use the status filter at the top to find those completed entries you wish to reverse. Please take care using this function as it cannot be undone.

The following support article is to help you set up metric weightings for additions, this allows the additive calculator to work out how much of a addition is required to reach the desired metric level.
Click on images to view a larger version, if you would like to view them in a second window simple click on them with the middle mouse button.

This is commonly used for KMBS or PMS, CUSO4 and a variety of other sulfur additions/solutions.

If you have a demo database available you can set this up in your demo first and test it out before doing the same in your production database.

I’ll be splitting the article into two parts, first setting up the Metric and the Addition, next is using the addition calculator.
Setting up the Metric,
Head into the Winery setup as shown below, into the Production folder and then into the Metrics category.
In this example I am using Free SO2, the important thing on this form is the ppm to g/L factor.
If you know your ppm to g/L factor you can enter it here, otherwise 0.001 will generally do.

Once this is entered save the metric.

Next is the addition,
Head into the Additive category now and select the addition you want to tie to the metric.
In this case I have used PMS/KMBS.
In the screenshot you’ll notice I have outlined three areas in red.
The right hand side is where you select a metric and assign a weighting to it, this weighting is the percentage of this addition that will contribute to the metric.
Clicking the Add button on the centre box will add it to the metric weighting list.
In this case 57% of the PMS addition will contribute to the Free SO2 metric.

Finally the Rate unit field is important as the rate of addition will be set to PPM.

In theory everything is ready to be used now, so next is using the addition calculator.

Now for the Additive calculator.
Exit the winery setup and head into the operations menu, select additive to start a new addition operation.
In the screenshot below I have marked out several areas in red, on the left you’ll see I have selected PMS as the addition.
On the right is the addition calculator, you will need to select the metric you want to use in the calculation (in this case Free SO2).
You will also need to select the additive if there is more than one additive that has a metric weighting for this metric.
Next you will need to fill in the current rate if this metric has not been tested or has been invalidated in the system (via blending for example).
After this fill in the desired rate and press the calculator button.

Double check that the required amount looks right, if you are happy with the amount click the [< < Use this value] button to drop the amount into the left hand side.
Remember if you have any questions or come across any problems feel free to contact support.