Funding and Technical Assistance By:

1. AFOPro Nutrient Management Planning Software February 2004 Funding and Technical Assistance By: Developed By:

2. Import Spatial Data (AFOPro Spatial, CST, SNMP) Import Fertility Recommendations Download State-Controlled Data AFOPro Stand-Alone Or Use as the Core of the System Import Soil Test Data Import AWM Data Calculate and Import Phosphorus Index Data Create and Populate a CNMP Document AFOPro Design

3. 3. Select “Existing Operation” and then select the operation and operation plan to open. Unwanted plans are deleted from this location. 4. Select “Exit” and close AFOPro and Access© 1. View or Update the underlying state data located in the Administration Section. 2. Select “New Operation” and begin a new plan (or open a new plan and import an existing AFOPro Nutrient Management Plan). AFOPro Start The Start Form greets the AFOPro user each time they enter the application. From this point the user has four options:

4. Required Entry Required Entry AFOPro needs the plan duration: To Order the Crop Sequence by Date. To Build the Cumulative Inflow Volume for the On-Farm Storage Systems. Note to user: Plan start date should precede the planting or the beginning of nutrient uptake for any crop that will be receiving nutrients in this plan. AFOPro Lists Existing Plans by Operation Name and Plan Name AFOPro’s Underlying Data is State Specific Required Entry Required Entry Step 1: Define Plan

5. Enter Tract and Field Number and/or Field Name To Add Field Manually Enter Land Use, Acreage, and Buffered Acreage Select to Add Field Soil Symbols Residual Organic N Factor (State Specific) Enter the Field’s Phosphorus Index Risk Rating, Nitrogen Index Risk Rating and Controlling Nutrient (State Specific) Right-clicking on the Field names will allow the user to sort the fields. As the fields are entered, they will be displayed in the All Fields Section. All data appearing on this form refers to the selected field. To view any entered field, select the field in this location. Enter the MU Symbol and the % of the field it occupies To Enter a Lab and Soil Test Data for each Field Select “Add Sample” Then Enter Data. Additional Data can be entered by selecting the ‘More Sample’ button. Step 2: Manually Add Land Application Field Data

6. Or Step 2: Import Land Application Field Data The browse window below will be displayed. Browse to the SNMP file, fields.dbf usually located in C:/SNMP_**(State Abbrev.). Continue on to the folder created for the particular operation being planned and the file will be located in that folder. Once the file is selected, select ‘Open’. AFOPro will import the data. Choose the Import Source: If using SNMP, select the radio button next to Import Spatial Data (SNMP/MapShots) and then select ‘OK’. Choose the Import Source: If using AFOProSpatial (NRCS users), select the radio button next to Import from AFOProSpatial and then select ‘OK’. To Import Fields AFOPro Spatial will import Land Use, Acreage, and Buffered Acreage. All the imported fields will appear in the “All Fields” Section. The browse window below will be displayed. Browse to the AFOPro Spatial export file (.mdb). Once the file is selected, select ‘Open’. AFOPro will import the data.

7. To Delete Field Soils Residual Organic N Factor (State Specific) must be entered for each imported field (If Applicable) Enter each field’s Phosphorus Index Risk Rating, Nitrogen Index Risk Rating and Controlling Nutrient (State Specific) Imported Fields’ Soil MU Symbol and the % of the field it occupies. AFOPro Spatial will import all of the soils in the field.

8. Import Land Application Field’s Soil Test Data Selecting “Yes” will open a browse window. Browse to the previously created and saved Soil Test Template. Note to user: The user may use several combinations for naming the fields; Tract Number and Field Number, Farm Name and Field Name, Field Name (only) or Tract Number, Field Number and Field Name. Fields in the Soil Test Template are check against the fields in AFOPro and matched according to the naming convention the user has indicated in the Soil Test Template. Indicate the required naming convention by placing a checkmark in the appropriate boxes. Additionally, indicate the units of the soil test data. All data where applicable will be assumed to be in either lbs/acre or ppm as indicated. If “Yes”, select or add a Laboratory and then select “Import Sample” Have you prepared the Soil Test Template with the data to import? Select To Import Soil Test Data If “No”, then follow the instructions in the message box and populate the soil test template. Then return to ‘Import Sample’ and follow the procedure Soil Test Data can be imported in lbs/acre or in ppm. All of the Soil Test Data from the Soil Test Template will be imported to the corresponding fields or if no corresponding field, a new field will be created.

9. Buffer Assumes Field’s Land Use and Buffered Acreage. The remainder of the data for each buffer area needs to be completed by the user. To copy the soil test data from the parent field to the buffer area, select the ‘Tool’ menu at the top of the screen. Then select ‘Copy Soil Test to Buffer Area(s). At this point, only the data for the selected field can be copied (Selected Fields) or if all buffers have been created, all of the soil test data from the parent fields can be copied to the corresponding buffers at the same time by selecting ‘All Fields’. If the Buffer will receive nutrients, place a checkmark in the box. To view or attribute buffered areas, select the radio button next to ‘Buffer Area’ to display the list and then select the desired Buffer Area. Step 2 continued: Land Application Field Buffers

10. To Edit Crop Data Enter Plant Date Enter Harvest Date Enter Default Yield For a crop to appear on the choice list when planning the sequence, a checkmark must be placed in the corresponding checkbox. Enter Default N Rec., if applicable. This value is not calculated by AFOPro. This entry allows the user who does not have access to an AFOPro Fertility Recommendation module to enter a value from the soil test report or their state’s Fertility Recommendation publication that is common to more than one field. Step 3: Crop Sequence for Land Application Fields The data in the crop defaults is to be operation specific. Your state’s gatekeeper may have entered some data. This data is additionally meant to save the user some key strokes by populating fields on the crop form with data that may need to replicated many times. With the exception of the crop name, all of this data may be edited on the crop form. (e.g. all fields may not be experiencing the same yield for a particular crop and would therefore need to be edited for any field that differs with the default that the user has entered)

11. AFOPro uses Fertility Recommendation modules to return a state’s fertility recommendations. These modules are specific to a state and are strictly lookups. An interface has been developed to allow the planner to enter any required data not captured by AFOPro necessary to returning the recommendation. The module then writes the recommendations on to the crop page. Recommendations are returned one field at a time. To open the module, select the ‘Fertility Recm.’ button. Soil Test Data for the Selected Field Select Crops by using the Combo Box AFOPro will sequence the crops by selecting the first plant date available after the Plan Start Date, then subsequent crops will look at the previous Harvest Date. The Data displayed is that entered by the user in Crop Defaults. Any of the values may be overwritten Select a field to plan Will the residue be removed for Grain or Oil Crops? Enter Fertilizer Recommendations Default N can be overwritten User has the option to enter Nitrogen Credits or Pasture Recycling Credits Step 3: Crop Sequence for Land Application Fields

12. To Enter an Applicator Select Applicator System All entered Applicators will be listed here. Enter a “Name” for the Applicator or accept “Default Name”. Select Applicator Category Enter the Minimum Application Rate AFOPro will always offer the user this rate of application Step 4: Enter Operation’s Applicators (Don’t Forget the Commercial Applicator) Many States associate NH4-N losses with method of application, time of year, and days to incorporation. Therefore, AFOPro needs to know how the nutrients will be applied.

13. Step 5: Enter All Nutrient Sources (On-Farm Storage Systems) Enter a “Given Name” or accept “Default Name”, and indicate if Solid System. Enter the system’s capacity and initial volume. AFOPro will indicate when system exceeds capacity. Entered On-Farm Storage Systems. Select system to display attributes. To Add Source The calculation can be for one storage system or for all of the systems. First Year Organic N Availability for each system (State Specific) Selection of the radio button will display a list of all sources of that type entered. Solid Systems require an established bulk density to convert inflow into tons. Select to edit the defaults. AFOPro requires that allocations be made in 1000 gallons or Tons. If inflow entered in CuFt, this will convert the values. Select a Nutrient Source Type Required Selection Calculates each system’s monthly storage level for the duration of the plan. Enter Monthly Inflow values for the storage system. Enter Manure Analysis Data Select to Enter Analysis Data for system. Exports made on Allocation Page are displayed for the system selected.

14. Step 5: Import from AWM (On-Farm Storage Systems) Enter a “Given Name” or accept “Default Name”, and indicate if Solid System. Imported AWM or entered On-Farm Storage Systems. Select system to display attributes. To Import AWM Data Monthly Inflow values from AWM’s Water Budget Table. AWM always imports in 1000 CuFt. Select CuFt to Gal or CuFt to Ton to convert. First Year Organic N Availability for each system (State Specific) Browse to the exported AWM dbf file, then Select “Open”. AFOPro will import all of the systems in that file along with their monthly inflow values. Select Type of Nutrient Source, displays entered sources of that type. Solid Systems require an established bulk density to convert inflow into tons. Select to edit the defaults. AFOPro requires that allocations be made in 1000 gallons or Tons. If inflow entered in CuFt, this will convert the values. Required selection, computes each system’s monthly storage level for the duration of the plan. Enter Manure Analysis Data Select to Enter Analysis Data for system.

15. Step 5: Enter All Nutrient Sources (Imported Manure) Enter “Date”, “From”, and “Name”. To Add Source First Year Organic N Availability for imported manure. (State Specific) Select Type of Nutrient Source, displays all entered sources of that type. Solid Systems require an established bulk density to convert import into tons. Select to edit the defaults. AFOPro requires that allocations be made in 1000 gallons or Tons. If import entered in CuFt, this will convert the values. Once converted, source becomes available for allocation. Indicate if Solid System, if Poultry, and imported quantity. Edit Bulk Density as needed. Default units are in CuFt, if quantity in tons or 1000 gallons is known, select the ‘CuFt to Ton’ or ‘CuFt to Th Gal’ button prior to entering the value. Otherwise, if value is entered in CuFt, it must be converted by selecting the ‘CuFt to Ton’ or ‘CuFt to Th Gal’. Select a Nutrient Source Type Enter Manure Analysis Data

16. Step 5: Enter All Nutrient Sources (Commercial Fertilizers) Select Fertilizer Grade or Custom. Accept “Default Name” or rename. Grades selected from list will populate automatically. Custom Fertilizers need to have the percentages added. To Add Source Select Type of Nutrient Source, displays all entered sources of that type. Select a Nutrient Source Type

17. To Sort Fields or Buffer Areas: • Right Click on a Field or Buffer Area Record • Choose Basis for Sort The Basis of the Sort will be displayed next to the “Select Field” Section. The Field’s Attributes will be displayed for the Planner’s reference. Select Field or Buffer Area to receive nutrients. Step 6:Nutrient Allocation

18. On-Farm or Imported Manure Nutrient Source Levels and Activity can be viewed graphically. On-Farm or Imported Manure Nutrient Sources activity and levels can be viewed in tabular form. On-Farm or Imported Manure Nutrient Sources activity and levels can be viewed in tabular form. Select Applicator and Incorporation Timing for specific nutrient allocation. “X” = Exceeds Capacity Year Cumulative Level Select Nutrient Source for Specific Allocation. Procedure is the same for all Nutrient Sources. Month Inflow Allocations and Exports Select Crop Specific Allocation Rates or Stockpiling Rates. Select date for specific allocation.

19. After selecting “Type of Allocation” and “Date” of the specific allocation, Select “Calculate Application Rate”

20. After selecting “Calculate Application Rate”, AFOPro will indicate which crop in the rotation is receiving the nutrients.

21. Select Allocation Rate Crop Specific Rates always in ascending order and include: N Rec. N Removed P205 Rec. P205 Removed K20 Rec. K20 Removed Minimum Applicator Rate

22. Allocation Rates for stockpiling P205 (based on removal) includes the rates to meet a subsequent crop’s need in the rotation up to the maximum N rate for the receiving crop.

23. Custom Rates can be used by selecting “Enter” and then entering the rate. (i.e. split applications (divide calculated rate by number of applications))

24. To change any variable (field, applicator, source) prior to allocating; • Select “Reset” • Make changes • Select “Calc App Rate” • Select Rate AFOPro Calculated Rates Custom Rates After rate has been selected, Select “Allocate” to initiate the application.

25. Enter Data and then Select “Export” 2. To Export Manure 1. Select Source Exporting Nutrients Off the Operation The Export Event that has taken place is displayed in three places. 1. On the Export Page (Displayed) AFOPro will use the correct units based upon the system selected. 2. In the Table or Graph displaying the system’s level and activity.

26. 3. On the Nutrient Source Page for the selected system.

27. Allocation History records all nutrient allocations for the selected field. Each data record includes: • Receiving Crop • % of Field Covered • Source • Method of Application • Timing • Rate per Acre • Quantity per Field • N, P205, and K20 in Pounds per Acre • Nutrient Balance is always for the entire field or buffer area selected. (note: for partial allocation) • Crop Rotation displayed • Harvest Date • N, P205, and K20 Recommended (If user has selected to view Balance based on Removal, then Crop Removal Displayed) • N, P205, and K20 Applied as Manure • N, P205, and K20 Applied as Commercial Fertilizer • N, P205, and K20 Balance for Crop (After Rec or Removal, whichever the user has selected to view) • Field Nutrient Balance Totals are always for the entire field or buffer area selected, for the duration of the plan. (note: for partial allocation) • Totals for N, P205, and K20 Recommended (If user has selected to view Balance based on Removal, then Crop Removal Displayed) • Totals for N, P205, and K20 Applied as Manure • Totals for N, P205, and K20 Applied as Commercial Fertilizer • Totals for N, P205, and K20 Balance for Field (After Rec or Removal, whichever the user has selected to view) Nutrient Balance defaults to Balance “Based on Recommendation”. To view Balance “Based on Crop Removal” select corresponding radio button. Any single nutrient allocation or all the nutrient allocations for a field may be deleted. The Nutrient Balance and Nutrient Source will reflect all De-allocation activity.

28. Operation Specific Reports AFOPro established reports designed to be printed from AFOPro or exported to Word©. Step 7: Plan Reports

29. Step 7: Plan Reports State Specific Data Reports AFOPro established data tables displaying the underlying data used in the current plan. Designed to be printed from AFOPro or exported to Word©.

30. Super Set Reports AFOPro established data tables designed to be printed from AFOPro or to be exported to Excel©. These tables include all data pertaining to each category listed enabling the user to produce custom reports. Step 7: Plan Reports

31. Record Keeping Templates Hard-copy templates to be used by the Producer to keep records. Designed to be printed from AFOPro or to be exported to Word© for the Producer. Step 7: Plan Reports

32. Operation Reports (Queries) The Queries behind the Operation Reports to allow the planner to customize each report. Designed to be exported to and customized in Excel©. Step 7: Plan Reports

33. To Export Reports to Word© or to Excel©; • Go to “Tools” • Select “Export Reports to MS Office” • Select “Publish with Word” or “Analyze with Excel” Step 7: Plan Reports Exported

34. File: Exit Closes AFOPro and Access© File: Open Displays the Start Menu File: Close Closes AFOPro Forms, Leaves Access© Open File: Import Operation Must have Operation Form open, Imports an Operation’s data that was exported from AFOPro Version 1.0.2 or Version 2.0 User must browse to location of exported mdb file. File: Export Operation At any point in the planning process the planner may export the operation’s data to an mdb (Microsoft Database). The planner can use this feature to share the data with other planners, to create a backup, or to save certain management strategies to be compared with another plan for the same operation. File: New Operation Displays a blank AFOPro Form File: Existing Operation Displays the List of Existing Operations Page Setup: Allows the user to input specifications for the reports page setup. Print: Allows the user to Print reports directly from AFOPro™. Menu: File

35. Tools: Export Reports to MS Office Displays selections to “Publish with Word” and “Analyze with Excel”. This feature allows the user to export all of AFOPro’s Reports and Queries. Tools: Unit Conversion Displays Conversion Calculator containing conversion factors required for nutrient management planning. Tools: Phosphorus Index Displays Modular Phosphorus Index developed for the state of the current plan. Tools: Administration Displays Administration Forms within AFOPro. The user cannot edit the data contained in this section, but has the ability to update the underlying data for a state from AFOPro’s FTP site. This feature is automated and requires the user to be connected to the Internet and to select two command buttons only. Tools: De-allocate All (Entire Operation) This command will De-allocate all of the plans nutrient allocations. The planner might use this feature to run scenarios for an operation based on a different set of management activities or decisions. The planner should export the scenario prior to removing all allocations. There is no way to retrieve the data once it is deleted unless the user has exported it. Tools: Copy Soil Test to Buffer Areas Copies the soil test data from the parent field to the buffer area. Either for the selected field only or for all fields that have a buffered area where nutrients are to be applied. If the buffered area is tested separately, then that soil test data should be entered. Tools: Soil test P Trends Displays AFOPro’s Soil Test P Trends tool. This tool looks at each field in the plan, uses the soil test P level entered for the field, looks at all the P205 allocations over the life of the plan, and calculates the soil test P level annually. Menu: Tools

36. Help: Quick Start AFOPro Opens AFOPro’s Quick Start Document. This document is intended to assist the user in the basic operation of AFOPro. Help: AFOPro Help Files Opens AFOPro’s Help File Documents. This document is an exhaustive instruction detailing for the user the operation and functionality of AFOPro. Help: About Getting Started AFOProSpatial Opens AFOProSpatial’s Quick Start Document. This document is intended to assist the user in the basic operation of AFOProSpatial. Help: About Menu: Help

37. Select Starting Soil Test P Select Nominal Soil Texture From Tools Menu Option to Overwrite P- Availability Fraction Soil Test P Trend Values – These values consider all of the P205 allocations planned, the crop’s P205 removal and the availability fraction in calculating the Predicted Soil Test P. Soil Test P Trend Graph Soil Test P Trends

38. The “Administrative Section” can be entered either by selecting “Administration” from the “Start Form” or by selecting “Administration” from the “Tools” Menu. To view a State’s data, select the state. Select a tab to view the selected state’s underlying data for that category. Any concerns or omissions should be referred to that state’s “Data Gatekeeper” listed on the “Supported States” tab next to the State name. It is intended that the NRCS designate a “Data Gatekeeper” and that that individual is responsible for the edits to that state’s underlying data. AFOPro will indicate that the list has been updated successfully. The “Administrative Section” will open as displayed above. The list of states displayed above is the list of available states the last time the user selected “Update State List” To download the reference data for an available state, place a checkmark in the box next to the State’s name. Once the desired States have been indicated and while still connected to the Internet, select “Download Reference Data”. AFOPro will indicate when the data has been successfully downloaded. Administration To view the current list of available states, Connect to the Internet and then Select “Update State List”. AFOPro will connect with AFOPro’s FTP site and query for the all available states.

39. For Additional Information, Interest in AFOPro for your State, or Technical Assistance • Contact • Mark Evans • 803-777-7600 • mevans@esri.sc.edu • Wes Standish • 803-777-7600 • standish@esri.sc.edu • Visit • http://www.esri.sc.edu/Projects/usda/application_development/afopro.asp • To Download AFOPro • State Phosphorus Index • State CNMP Template • State Fertility Recommendation Module • Documentation and User Guides