Instructions for Downloading and Using
Budgets to Evaluate Soybean Rust Impact

These budgets use macros. The security for your Excel software should be set to medium and you should allow the software to enable macros for this file in order for it to work correctly.

Overview:

This publication contains budgets for production of single and double cropped soybeans in Kentucky. The purpose of these budgets is to serve as a management and decision-making guide for current and prospective producers of these enterprises. These budgets are not intended to replace a producer's own records and estimates. Producers are strongly encouraged to adapt these budgets to their specific situation. In the absence of such data, however, these budgets can serve as a reasonably accurate cost and income guide.

These budget estimates are based on the best and most accurate input cost information and crop price projections available at the time of release. Further, costs and returns are based on production practices and yield levels thought to be representative of typical growers in Kentucky given normal growing conditions. This publication allows producers to change prices and quantities for easy adaptation of the budgets to their own farming situation.

These budgets reside in a Microsoft Excel file "budgets_soybean_rust.xls". The user is able to change the default information in the budgets to reflect their production practices to generate a budget that is representative of their own situation. This file uses macros. The security for your Excel software should be set to medium and you should allow the software to enable macros for this file in order for it to work correctly.

Instructions for using the budgets are included on the introduction page of the spreadsheet.

Downloading and Installing the Soybean Rust Budgets:

This file uses macros. The security for your Excel software should be set to medium and you should allow the software to enable macros for this file in order for it to work correctly.

Click on "Soybean Rust Impact Budgets" download option either here or in the page menu to the left. With most browsers, you will get a choice of saving it to your hard drive or opening it. Save it to a location on your hard drive. Remember the location where you saved the file so you can find it later. If your browser opens the file without asking you whether to open it or to save it, right click on the link and select "Save Target As" to save the file to your hard drive.

Opening the budget file:

This file uses macros. The security for your Excel software should be set to medium and you should allow the software to enable macros for this file in order for it to work correctly.

In the Excel spreadsheet, select "Tools" on the menu bar. Under the Tools menu option, select "Macro". Under the Macro menu item you should see "Security". Click on "Security" and set this to "Medium". This will allow your computer to accept the macros. Close out of the spreadsheet and reopen it remembering to choose "Enable Macros".

Go to the folder/directory in which you saved the file and double-click on the "Soybean Rust Impact Budgets" Excel icon. The file is named "budgets_soybean_rust.xls".

IMPORTANT: When opening the budget spreadsheet, always choose to "Enable Macros".

In the Excel spreadsheet, select "Tools" on the menu bar. Under the Tools menu option, select "Macro". Under the Macro menu item you should see "Security". Click on "Security" and set this to "Medium". This will allow your computer to accept the macros. Close out of the spreadsheet and reopen it remembering to choose "Enable Macros".

To Save Budgets:

Click on "File", then "Save as..." give it a name of your choosing and click "OK". You do not have to save individual budgets. When you save a file, you save all of the budgets in that file.

To Exit the Budgets:

To exit the budget spreadsheet, always be sure to press "Save" to ensure your latest changes are saved to the file. You can press the "X" at the top right corner of the screen or go to "File", "Exit".

For More Information

For additional information about these interactive Soybean Rust Impact budgets, please contact Steve Isaacs.


Link to AEC site navigation. Link to main body of page.