Formula Rx

Once formulas have been set up and saved in Add/Edit Formulas, you can run the formulas in Formula Rx by selecting the desired fields and formulas.  

The Formula Rx tool can be accessed from the Right-Click Menu in View.

Below are explanations for the settings and dropdowns within the Formula Rx tool.

TABLE OF CONTENTS

• Settings:
• Select Formula(s):
• Field Selection:
• Review:
• Export:

Settings:

Resample cell size - Allows you to change the pixel size used to create the Rx. Either meters (left line) or feet (right line) can be entered. Typically, the default of 20m is used for grid sampling. If you are using zone sampling, you may want to set this to 2m because that is the resolution in which layers are stored in PCT. You can also choose to set the resolution to the width of the equipment used in the application of the Rx. 

Apply Cell size to shapefile only  - When checked, the layer will be saved with the default cell size, but the shapefile will be saved with the entered resample cell size.

Target Activity Date - Desired activity/application date. This will be the date that the layer is saved under.

-Note: If the formula is recreated with the same date, the previous formula will be overwritten. To ensure that both formulas are saved, change the Target Activity Date. 

Formula Group - Selects a Formula Group. Formula Groups are set up in Add/Edit Formulas.

Edit Formulas - Takes you to the Add/Edit Formulas page.

Products - When selected, you'll be taken to products to be used with Soil Rec Layers.

Select Formula(s):

Product - Set up in Add/Edit Formulas. If no product is listed for the formula, a product can be assigned to the created Nutrient Rec layer after clicking 'Create Rx' (see end of article for example).

Formula Name - Denotes the specific formula. Set up in Add/Edit Formulas.

Season - Allows you to select the desired soil sample layer by selecting the season it is saved under. Click the three dots next to the Season header to select the "Use field's latest season" option. This will automatically choose the most recent layer for each field. 

Depth - If depth is saved with soil sampling data, you can select the depth. If multiple depths are selected, a weighted average will be calculated.

Units - Units the resulting layer will be saved in.

-Note: Any values entered in the Formula Rx tool need to be in the coresponding units of the selected formula.

Min - Any calculated value below the entered number will be rounded up to that number. Can be adjusted in the Formula Rx tool or set up as a default within the Add/Edit Formulas tool. 

-Note: Switch Rates can be entered in the Min column by inserting a comma between the two values. A switch rate of 20,50 will take any value between 0 and 20 to 0, any value between 20 and 50 to 20, and any value 50 and above will be the calculated rate. 

Max - Any calculated value above the entered number will be rounded down to that number.

Split - Will split the calculated result into multiple applications based on the % separated by commas entered in the Max Column. When entering a split, the values must equal 100% (ex. 25,25,50).

Available Product - Enter the amount of total product available to be spread over field/fields so the resulting variable rate maps totals equal the available product.

Set Average Rate - This allows you to set a desired average rate per variable rate Rx.

Cost - Price per unit of product.

Flat Credit - Will subtract the entered value from the Rx.

Credit Layer - Will subtract the layer selected from the Rx. Units of layer and selected formula must match. Operates on the field level. 

User Variable - Set up in Add/Edit Formulas. Typically used for variables such as product conversions or crop removal values. 

Field Selection:

-Note: Fields selected in View will populate the Field Selection list in Formula Rx. 

Name - Field name.

Crop - Selects the crop for which the formula is to be run. Determines the seasons available in the Season column. 

Type/Season - 

• Flat - Enter a flat yield goal in the grey column to the right.
• Mean - Will use a flat yield goal that is automatically determined from the average of the selected season(s) in the Season column.
• Grid - Will vary the yield goal based on the actual yield layer(s) selected in the 'Season' dropdown. If multiple are selected, an average of all layers will be used. 

-Note: Yield Potential and Yield Average layers can also be selected under the Season Dropdown. A Yield Layer entered into a formula (ex. [Yield, Corn]) will be filled with yield goal type/value/season that is configured under the Field Selection area in the Formula Rx tool. 

-Note: The Crop, Type, and Season selections can all be made by field or in bulk with the top dropdowns. 

Second Crop -  A second crop can be selected to create a two-year recommendation. Both crops will be used to calculate one Rx layer.

Create Rx - Click 'Create Rx' to run the selected formula(s) for the selected field(s). 

Review:

After the Rx's have been created, a breakdown of the Rx's and the layers used to create them will be displayed, along with a summary per product. Rx's can be selected or unselected. 

Export:

Shapefiles and reports of the selected Rx's can be downloaded. A character limit can be selected for the filename. The default naming format for the files contained within the ZIP file is DealerGrowerFarmFieldProduct. If needed, the filename will be abbreviated in that order. A custom name can be entered for either the individual files or the ZIP file that will be applied to all, or a template of sorts can be made by using the @ sign to specify which components should be included in the filename. This template will be saved for the next time the tool is opened. When multiple Rx's have been created, you can choose to combine all the fields and/or products into a single shapefile; this will combine the reports as well. 

Rx's are automatically saved as layers after they have been created. To delete the layers, select the 'Delete Rx layers' option and click 'Run'. 

If the field(s) that the Rx's were created for are linked to Agworld, they will be sent to Agworld automatically after clicking 'Create Rx'.

Rx's can be sent to Operations Center in multiple ways. For Rx's or any other layers to be sent to Operations Center, both the grower and individual fields must be linked to an Ops Center organization. To send Rx's to the Files page or directly to a machine, check the 'Send shapefiles to Operations Center' option and make the desired selection under the 'Machine(s)' dropdown. Rx's can also be attached to Workplans. For this option to be available, the formula used must be under the grower level in Add/Edit Formulas and the grower must be linked to an Operations Center organization. 

Rx's can be sent to other integration partners from the layers tab in View. 

When the export settings have been configured, click 'Run'. 

If the Rx has no product and is creating a Soil Nutrient Rec, click the 'Select Layers and switch to product' button. This will take you to the same place as clicking the 'Products' slider described above.

Products - Here we can convert Soil Nutrient Recs and Nutrient Crop Removal layers to actual products.