Upland Calculator Program
The Upland Cotton Loan Calculator is designed for the evaluation of variety trials. It derives loan values by applying USDA premiums and discounts to sets of HVI classing data. In addition, the program can calculate net returns over harvest costs on a per-acre basis. The program is updated each year with the USDA’s revisions to premium and discount values.
To calculate loan values, the program requires the user to input to HVI classing data including: color and leaf grades, micronaire, length in inches, strength in grams per tex, uniformity index and bark grade.
An update to the program in 2019 is that the Loan Calculator can now import HVI data directly from source files, eliminating the need to cut and paste. This service is available for files with known formatting and exists for HVI output from the USDA, Texas Tech FBRI, and Cotton Incorporated’s Fiber Lab. Traditional data entry, through cut-and-paste is also supported.
Two short instructional videos and a pdf covering the operating instructions are here.
The program is distributed as a macro-enabled Excel workbook. For the program to perform properly, the user must enable Macros. It should be possible to enable macros by simply clicking allow content when you open the file. If that does not work, set macro security by clicking on File (top left corner of Excel), then select Trust Center, then click on Trust Center Settings. In the Trust Center menu, click on Enable all macros, then click Ok. The Enable Macros Before You Do Anything video will guide you through this process.
Questions, comments, and suggestions are welcome. Please send an email to Jon Devine, we are happy to help.
Cotton Loan Calculator Instructions
Ensure that macros are enabled
