An Automated Data Analysis Tool for Livestock Market Data

This article describes an automated data analysis tool that allows Oklahoma Cooperative Extension Service educators to disseminate results in a timely manner. Primary data collected at Oklahoma Quality Beef Network (OQBN) certified calf auctions across the state results in a large amount of data per sale site. Sale summaries for an individual sale need to be quickly dispensed to program coordinators, auction barn owners, and program participants. Data entered into a Microsoft Excel spreadsheet at sales is summarized using Excel database commands. A link to Microsoft Publisher then generates the sale summary for an individual OQBN sale. (Contains 3 figures.)