Skip to main content
ARS Home » Midwest Area » Bowling Green, Kentucky » Food Animal Environmental Systems Research » Research » Software » Download

headline bar
Modified Arcsine Log Calibration Curve (ALCC)

Welcome to the software download area! Please contact us if you have problems or questions.

Download Available

Soil test correlation data are often used to identify a critical soil test value (CSTV), above which crop response to added fertilizer is not expected. Estimating CSTVs from soil test correlation data helps farmers determine what fields are expected to respond to fertilizer application. Oftentimes models are used to determine the CSTV from soil test correlation data, yet most commonly used models have inherent assumptions which are not valid for these data. The arcsine-log calibration curve (ALCC) was developed by Dyson and Conyers (2013) in response to the statistical limitations of other commonly used models. The modified-ALCC model using standardized major axis regression developed by Correndo et al. (2017) further improves this model’s applicability to soil test correlation data. This method, however, requires additional calculations that may be challenging to those without the proper experience or background. Here we provide an easy-to-use spreadsheet capable of performing the necessary calculations for using the modified ALCC model to provide a tool that will encourage greater adoption of this method among those involved in research, teaching, and extension with limited access to more sophisticated software packages (Bolster et al. 2022).

Download Form

Please complete the form below to track the use of the service we are providing and to help improve our product.
OMB 0518 - 0032 (01/2025)
First Name   
Last Name   

According to the Paperwork Reduction Act of 1995, an agency cannot conduct or sponsor, and a person is not required to respond to, a collection of information unless it displays a valid OMB control number. The valid OMB control number for this information collection is 0518-0032. The time required to complete this information is estimated to vary from one to five minutes with an average of three minutes per response, including time for reviewing instructions, and completing and reviewing the collection of information. Send comments regarding this burden estimate or any other aspect of this collection of information, including suggestions for reducing this burden, to Department of Agriculture, Clearance Officer, OIRM, Room 404-W, Washington, DC 20250, and to the Office of Information and Regulatory Affairs, Office of Management and Budget.