Wine

The largest private reference database in wine

Agroisolab offers a wide range analysis to suit the needs of authenticity, quality and safety testing.

Not only does Agroisolab have access to the ever-growing database for the EU, but also the largest SIRA reference database of wines with more than 3900 reference samples.

Agroisolab currently has samples mainly from:

  •     Argentina

  •     Australia

  •     Austria

  •     Bulgaria

  •     Chile

  •     France

  •     Germany

  •     Greece

  •     Hungary

  •     Italy

  •     Portugal

  •     South Africa

  •     Spain

  •     USA (California)

Agroisolab's global wine database

Our wine reference database can be viewed below. Please click on each country to view the amount of reference samples we have from each country.

What tests do Agroisolab offer?

Many of the common types of wine fraud can be detected by isotopic testing. Here are the current tests that Agroisolab offers:

Origin/Authenticity - Using stable isotope analysis, Agroisolab are able verify claims of geographic origin, determine whether water has been added to wine, and detect chaptalisation (addition of sugar) using D/H(I) with Isotope Ratio Mass Spectrometry (IRMS) and carbon isotope ratio analysis.

Additionally, Agroisolab are able to determine whether the source of carbon dioxide in sparkling wines is natural or not. We are also able to determine the sources of fermentation in spirits and wine vinegars.

For a brief overview of the science involved in these tests, please see below.

Módulo 1 - Pasos Previos, Entorno y Primera Macro


1 Ficha desarrollador y entorno de visual basic
1.1 Ficha desarrollador y entorno del vba macros
2 Mi primera macro con msgbox
2.1 Mi primera macro con msgbox. Macros video
2.2 Mi primera macro en msgbox.zip
3 Formas distintas de ejecutar una macro
3.1 Formas distintas de ejecutar una macro. Video
3.2 Formas distintas de ejecutar una macro




Módulo 2 - Guardando Y Protegiendo Archivos De Macros


1 Guardar archivo con macros
1.2 Guardar archivo con macros. Video
1.3 Como guardar con macros
2 Proteger archivo con macros
2.1 proteger archivo con macros. Video
2.2 tips para proteger archivos que tienen macros.xlsm




Módulo 3 - Operaciones Básicas de Visual Basic para Aplicaciones


1 Como escribir datos en una celda
1.1 Leeres.video
1.2 Cmolee
2 Como procesar datos en vertical
2.1 Copiar
2.2 Como procesar datos
3 Como copiar datos en forma horizontal
3.1 Como copiar. Video
3.2 Como copiar. Xls
4 Sentencia if-then. Ejemplo simple
4.1 Sentencia if-then.video
4.2 Sentencia if-then.xlsm
5 If then. Ejemplo avanzado
5.1 If then.video
5.2 If then-ejemplo avanzado con else.xlsm
6 Sentencia inputbox
6.1 Inputbox.video
6.2 Función input box.xlsm




Módulo 4 - Grabadora de Macros en Profundidad


1 Grabadora de macros. Ejemplo simple
1.1 Macros.video
1.2 Ejemplo simple macros.xlsm
2 Optimizando el código de la grabadora
2.1 Optimizando el código. Video
2.2 Optimizando el código de la grabadora.xlsm
3 Grabadora de macros ejemplo complejo
3.1 Grabadora de macros ejemplo.video
3.2 Grabadora de macros ejemplo.xls
4 Cuando usar una macro
4.1 Cuando usar la grabadora.video
4.2 Cuando usar la grabadora.xlsm




Módulo 5 - Caso Práctico 1- Reporte con Filtros a Partir de Filtros Avanzados


1 Que es un filtro avanzado
1.1 Filtro.video
1.2 Report.xls
2 Ver resultados en otra hoja
2.1 Resultados.video
2.2 Report.xls
3 Terminando el informe
3.1 Terminando el informe.video
3.2 Report.xls




Módulo 6 - Caso Práctico 2- Reporte con Filtros con Controles de Formularios


1 Control de formulario
1.1 Formularios y controles.video
1.2 Report.xls
2 Generando el reporte
2.1 Generando el reporte.video
2.2 Report.xls




Módulo 7 - Caso Practico 3 - Reporte con Filtros a Partir de Validación de Datos


1 Preparación de archivo
1.1 Preparación de archivo.video
1.2 Report.xls
2 Escribiendo el for next
2.1 Escribiendo.video
2.2 Report.xls
3 Afinando la macro
3.1 Afinando.video
3.2 Report.xls
4 Dando formato
4.1 Dando formato.video
4.2 Report.xls




Módulo 8 - Caso Práctico 4- Limpieza de un Reporte de Contabilidad


1 Definición de variables
1.1 Definición de variables.video
1.2 Limpiar reporte.xlsm
2 Copiado de columnas
2.1 Copiado de columnas.video
2.2 Limpiar reporte.xlsm
3 Verificación macro
3.1 Macro paso a paso.video
3.2 Limpiar reporte.xlsm




Módulo 9 - Caso Práctico 5 - Formulario para Ingreso Controlado de Registros


1 Formularios y control
1.1 Formularios y controles.video
1.2 Macros con formularios.xlsm
2 Parte 1
2.1 Parte 1.video
2.2 Macros con formularios.xlsm
3 Parte 2
3.1 Parte 2.video
3.2 Macros.xls
4 Parte 3
4.1 Parte 3.video
4.2 Macros.xls
5 VALIDACIÓN 1
5.1 Validación 1.Video
5.2 Macros.XLS
6 Validación 2
6.1 Validación 2.Video
6.2 Macros.XLS




Módulo 10 - Variables, Constantes, Objeto Application,Procedimientos, Matrices, Formularios y Condicionales.


1 Variables y constantes
1.1 Variables-objeto
1.2 Variables y constantes
2 Objeto application
2.1 Objeto application
3 Procedimientos
3.1 4 procedimientos sub. Argumentos vba
3.2 Procedimiento function
3.3 Procedientos sub
3.4 Alculo_comision.xlsm
4 Matrices, formularios, condicionales y bucles y ejemplo
4.1 Matrices
4.2 Formularios
4.3 Condicionales bucles
4.4 Cambiar color fila activa





Quality testing - Agroisolab are able to offer wine quality testing using Oenological Standard analysis that covering all requirements for determining wine quality.

Safety/Residues/Contaminants - Agroisolab are able to access an extensive suite of analytical services for determining residues and contaminants in wine ranging from pesticides to allergens.

Interested in testing wine with us? For more information, contact us.

What is the EU wine databank?

The EU wine databank was established in 1991 to protect the reputation of EU wine and minimise fraud, such as the additions of sugar and extra water in wine, by enabling laboratories to perform authenticity analyses. It has played a fundamental role in helping the EU Member States to develop the scientific and technical competences needed to carry out isotopic analysis of wine.

Agroisolab founder Professor Förstel originally developed the stable isotope method to determine the origin of wine, and played a crucial role in creating the EU wine databank.

Participating wine producers submit samples of their produce annually to the databank. As a result, it is possible for stable isotope laboratories to authenticate claims of geographic origin on bottles of wine sold at retail to a high level of accuracy.

How does origin analyses of wine work with isotopes?

In Europe, there are distinct regions that can be defined by the isotopic composition of their groundwater. The groundwater in some of these regions has more heavy oxygen present (18O), and some has less heavy oxygen.

As a result, grapes grown in the regional groundwater will absorb the oxygen isotope signature of their region.

Since wine is made from fermented grapes, it is possible to determine the geographic origin of a wine by examining the oxygen isotope ratios in the water fraction of the wine.

Further work has been carried out to isolate and analyse the isotope ratios of other components of wine. Analysing the isotopic composition of the alcohol (ethanol) in wine can help determine if sugar has been added to the wine, or can further enhance geographic origin interpretation.