Add/Edit Formulas

Add/Edit Formulas is where we can set up formulas to create Rx's and other calculated layers as well as products that can be set up to run with Soil Nutrient recommendations.

Access the Add/Edit Formulas tool by clicking the 'Add/Edit Formulas' button in the Right-Click Menu in View. 

Begin by selecting a Dealer and Grower and clicking the '+' button to add a new formula from scratch.  

You can also import formulas from files by clicking the 'Import formulas from file' button.

All text boxes and dropdowns with an '*', as well as any pertinent units need to be filled out for the formula to run properly.  

Details:

Formula Name - This can be whatever you want the formula to be called.

Group Name - Formulas with the same group name will be grouped together when editing and running formulas.

Layer Type - A layer can be named anything available in the dropdown. When running an Rx that has product conversion in the formula you will want to choose 'Rx Solid' or 'Rx Liquid'. If the formula will be run as a nutrient recommendation and applying a product conversion with components, you will want to make sure you choose a soil nutrient rec layer type such as 'Soil P2O5 Rec'.

Unit - Unit the layer uses.

Auto Type (at Import) - The formula will be run as soon as all layers and/or datasets in the formula are available. This can be done with 'Samples' so each point in a soil sampling dataset has an associated rec or with 'Layers'.

Preferences:

Min - Any calculated value below the entered number will be rounded up to that number.

Switch Rate - Any value equal to or below Rate 1 will be rounded to 0.  Any value between rate 1 and 2 will round to rate 2 and so on.

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

Split By Max – Creates a second prescription for the following season for anywhere over the number entered.

Split By % - Will split the Rx up by the entered percentage as many as 4 times (must equal 100%).

Cost $ - Cost per unit of product.

Also Run Formula - Will also run the selected formula. 

Expression:

Expression Specification - Where the actual formula is entered. 

Insert Layer Type - This allows you to look through our list of layers to use as arguments in the formula. 

Insert Crop - This allows you to select a crop yield layer or flat yield goal for the formula. 

Insert operator/snippet - This allows you to select operators such as an if statement.
 

Copy formula to clipboard - This allows you to copy the formula. 

Variables and Units:

Name - Shows the layer or yield argument from the entered formula.

Unit - Must be filled out to match the layer or argument being used.

Crop/Product - This will show the crop or applied product used in the formula.

Default Value - If there is no layer and you want a constant flat yield goal or layer result, it can be entered here. Note, if there are more than two crops in a formula, you can set the default to 0 and choose the crops you would like to use in FormulaRx.

Value (for testing) - Allows you to enter likely numbers to see if the formula is working properly and to compare to a spreadsheet or similar calculator.

Test the formula! - Once everything is filled out properly you can see if the formula is running properly.

Components: 

Components are used with Soil Nutrient Recs and Nutrient Removal Layers to apply a product to a nutrient requirement using the % of the nutrient in the applied fertilizer. 11-52-00 MAP is used as an example below. Note, components need to be saved separately from an expression. In FormulaRx you can run the nutrient rec expression and then apply the component product in a subsequent step.

Once Everything is saved you can move on to Formula Rx.