This Excel Spreadsheet TOOL was designed by Maribel Hurtado, Bob Griffin and Steve Hong for use in a recent workshop on Best Practices for Risk Management and Risk-Based Sampling held in Lima, Peru in late September, 2018. The event was sponsored by the Interamerican Institute for Cooperation in Agriculture - IICA, the cooperatively delivered by IICA, USDA-APHIS-PPQ and NAPPO. The workshop was hosted by the General Secretariat of the Andean Community – CAN.
The tool can be used to organize data derived from inspections conducted at ports, airports and border points. The formulae can be used to estimate sample sizes based on Risk-Based Sampling concepts.