¡Perdonen las molestias ocasionadas, la traducción será disponible muy pronto!

Agrowin

Agrowin® is a software to render the access to computerized analysis, data developed by market research agencies around the world or available from governmental and other official departments and services.

Thus, AGROBASE is not in competition with the market research agencies: its services are complementary, for only an independent company, not supplying data itself, can offer such a confidential type of data-processing service.

In addition to standardizing the primary data obtained from the panel companies, the AGROCODE coding procedure also adds considerable value to the basic data, which enables the international user, looking at data from several different markets, better to exploit its total potential. The AGROCODE data set, as delivered contains the following dimensions or sorting keys, any combination of which can be analyzed in the AGROACCESS computer program:

YEAR - COUNTRY – PROVINE - CROP - METHOD OF APPLICATION - CROP STAGE- MONTH (IF AVAILABLE) - PEST-COMPLEX - TREATMENT – PRODUCT -ACTIVE INGREDIENT (S) - COMPANY – DISTRIBUTOR - MANUFACTURER

Additionally, several of the above primary keys can be grouped to give higher levels of aggregation as follows:

PRIMARY LEVEL  HIGHER LEVEL
COUNTRY REGION
PROVINCE PROVINCE GROUP
CROP CROP GROUP - CROP MAIN GROUP
CROP STAGE STAGE GROUP
PEST COMPLEX PEST - PEST-GROUP - PEST-MAINGROUP
TREATMENT (TANKMIX) ACTIVE COMBINATION IN TANKMIX
PRODUCT PRODUCT GROUP - PRODUCT TYPE - ACTIVE-COMBINATION
ACTIVE INGREDIENT  CHEMICAL GROUP

Attached to the above keys are the following numerical data:

PRODUCT AREA TREATED   ACTIVE AREA
PRODUCT DISTRIBUTOR PRICE   ACTIVE DISTRIBUTOR PRICE
PRODUCT USER PRICE  ACTIVE USER PRICE 
PRODUCT DOSE RATE  ACTIVE DOSE RATE
PRODUCT HA. TREATMENT COST ACTIVE HA. TREATMENT COST
PRODUCT VOLUME  ACTIVE VOLUME
PRODUCT DISTRIBUTOR VALUE  ACTIVE DISTRIBUTOR VALUE
PRODUCT USER VALUE ACTIVE USER VALUE

MARKET SHARES FOR AREAS, VOLUMES OR VALUES PRICES AND VALUES IN LOCAL- AND THE FOLLOWING TARGET CURRENCIES: US$, EURO.

Thus, the value added in the formatting and coding procedure to produce the standardized AGROCODE data set is considerable, for no panel data allows the user access to such a large number of related variables. Additionally, the AGROCODE data-set contains all the relationships allowing branded product information to be converted directly into active ingredients, which is a very important feature when making analyses across different countries, where the same active ingredient is often sold under quite different product names.

The AGROCODE data set is delivered by AGROBASE to the users on a country-by-country basis, which ensures that electronic access is given to the data as soon as possible. Generally speaking, the great bulk of the farm panel data is delivered before December of the harvest year in question. Additionally, key markets in Europe, such as cereal herbicides and fungicides are delivered earlier than the other crops in order to give users the earliest possible access to this data. This access is best obtained by use of the main database management program, AGROWIN®, which is outlined in the following section.

Design of Data-Base Management Software: AGROWIN®

Availability of a standardized data set is the first step towards building a dynamic database, for unless data in the appropriate input format is available on a regular basis, no database can be maintained without enormous internal effort. However, the data set in itself does not give easy access to the data without a database program into which it can be fed.

AGROWIN® contains several modules:

  • The Analysis Module, which allows to interrogate the database
  • The Input Module, which allows to enter data directly into the system. This module can be used to modify existing data or to enter new data.

AGROWIN® is the key component, for it allows the central market research department of international pesticide companies to build, maintain and interrogate a data-base which contains all the pesticide usage data which that company has bought from the various suppliers around the world.

AGROWIN® can be installed on any PC, local area network or on a Citrix platform to be used via the internet.  Basically, AGROWIN® allows any user, with no prior knowledge of computing:

  • To load the data supplied by AGROBASE as and when it becomes available, thus maintaining the database in an up-to-date condition.
  • To question the data base in every conceivable manner, by means of one simple interrogation program, which allows access to all of the data.

AGROWIN® contains no restrictions on the types of analyses, which can be made:

  • Literally any arrangement of the basic data, which makes sense, can be produced in one simple dialogue. The basic data, which is held at country level in terms of crops, application segments, branded products and local currency, can looked at in terms of actives, a target currency, crop groups, regions and so on.
  • The user may select in terms of products and print as actives, or vice-versa, select in terms of countries and print as regions, or vice versa and so on.  The system is unbelievably flexible and easy to use.  It is the easiest and most satisfactory way of accessing the pesticide usage data.