piaf

1. piaf piafPlanning-, information- and evaluation - system for field trials Gregor Zink, proPlant GmbH

2. piaf History of development • 1995-1997 • piaf started as a research project • Involved parties:German Federal Office of Plant Varieties (BSA) , Advisory services of the Federal States of Germany, Plant breeders and the University of Münster • The aim of the project was the development of an evaluation system based on SAS and a relational database • Since 1998 • In cooperation with the advisory services and the chemical industry in Germany a complete planning-, information and evaluation system has been developed based on the results of the research project • Today, piaf supports the whole workflow beginning with the planning phase up to the evaluation of single trial and trial series

3. piaf Main objective • Support of various trial types and application areas • Variety trials • Efficacy trials for plant protection products • Fertilizer trials et al. • Support of various trial designs • Arbitrary number of trial factors • Evaluation of single trials and trial series depending on the trial design • Optimization of data exchange • Federal state - Federal state (Germany) • Fedaral state - German Federal Office of Plant Varieties (BSA) • Trial station – Chemical industry • Chemical industry - German Federal Biological Research Centre for Agriculture and Forestry (BBA) • Support of the whole workflow depending on the application area • Management of large amounts of data Trial types based on EPPO guidelines

4. piaf User of piaf • Officials of the Federal States of Germany • All trial types from the planning up to the evaluation • Private trial stations • Data entry and report of single trial results (various trial types) • Chemical industry • Order Management (efficacy trials) • In some cases piaf is used as central database for all trials • German Federal Office of Plant Varieties (BSA • Interface to the federal states of Germany and the plant breeders • Planning and data entry system for their own trials • German Federal Biological Research Centre for Agriculture and Forestry (BBA) • Central database for the validation of efficacy trials • Planning and data entry system for their own trials

5. piaf • piaf • Protocol • Trial • Report • Query • Summary PIAFStat Statistical analyse of single trial and trial series expert.trial Weather data and plant protection advice system Mobile data collection Database(Oracle, Firebird) Main structure

6. piaf information system Query • The query module is the basis for further functions like reporting, summaries, data exchange and PIAFStat • Query conditions can be defined for every item of a trial; for instance searching active ingredients or plant protection products combined with targets and crops or assessment values is possible.

7. piaf information system Reporting • piaf contains a reporting tool which allows advanced users to create new or adapted versions of existing reports, which can be included as menu items for other users • All reports and summaries are based on Excel, this gives a user the possibility to use the output for further work • Nevertheless, the piaf reporting tool allows the definition of printable Excel–files, which contain format specifications like fonts, colours, frames, page breaks, repeated header et al. • All trial data is available in the trial reports

8. piaf information system Reporting • Example of a single trial report

9. piaf information system Summaries • Summaries in piaf are not restricted to treatment mean values, an overview about the conducted trials belonging to several crops, targets and years is possible as well as an overview about the conducted assessments of a number of trials which can be used as check function • Similar to the reporting tool advanced users can define their own summaries, which can be included as menu items for other users • A second summary tool is used more in the context of variety trials and gives a number of additional features like the calculation of relative values

10. piaf information system Summaries • Overview about the no. of trials belonging to crops and targets

11. piaf information system Summaries • Efficacy summary of herbicide trials using the last assessment value of every trial

12. piaf information system • piaf • Protocol • Trial • Report • Query • Summary PIAFStat Statistical analyse of single trial and trial series expert.trial Weather data and plant protection advice system Mobile data coll. • A large number of weather stations (DWD, meteomedia) in Europe is available • Other Weather stations can be included expert.trial Weather data of a referenced weather station by a click on a button Database(Oracle, Firebird)

13. piaf information system Application timing Efficacy • The base of expert.trial is the plant protection advisory system expert. which performs infestation data of diseases or migration and oviposition data of pests expert.trial Weather data, treatment mean values and the application timings in one diagram

14. piaf piaf Fed. Statepiaf Chem. Ind.piaf BBApiaf piaf data format proprietary interfaces to the piaf data format Chem. Ind.other fts1 BSApiaf Trial Station piaf Trial Stationother fts1 EDE A converter.ede EDE B piaf EDE2 format converter.ede Mapping info other EDE2 format piaf EDE2 format converter.ede Data flow and interfaces Plant breederother fts1 1: fts-> field trial system 2: EDE-> electronic data exchange

15. piaf additional tools EDE A converter.ede EDE B Mapping info converter.ede • Conversion of EDE-files in the EDE-structur of a destination system • Examples • piaf -> ARM • ARM -> piaf • Proprietary data structure -> ARM • Proprietary data structures -> piaf (e.g. „Lückenindikationsversuche“)

16. PIAFStat • piaf • Protocol • Trial • Report • Query • Summary PIAFStat Statistical analyse of single trial and trial series expert.trial Weather data and plant protection advice system Mobile data coll. For more details see procuct presentation Tuesday, 18:10-19:20 Euroform Katharinensaal And now PIAFStat Jörg Schmidtke, BioMath GmbH Database(Oracle, Firebird)