Rmrubin: /* Formulae Overview */

2014-06-11T17:45:02Z

‎Formulae Overview

Rmrubin: /* Formulae Overview */

2014-06-11T17:43:43Z

‎Formulae Overview

Rmrubin at 02:41, 27 March 2014

2014-03-27T02:41:11Z

Rmrubin: /* Batch Weight */

2014-03-27T02:38:35Z

‎Batch Weight

Rmrubin: copy from old wiki

2013-10-11T21:24:16Z

copy from old wiki

Show changes

Rmrubin: Created page with "'''Workbench Help''' All fields are listed alphabetically. The section of the Workbench containing the field is in parenthesis following the field name. ..."

2013-10-11T21:13:11Z

Created page with "'''Workbench Help''' All fields are listed alphabetically. The section of the Workbench containing the field is in parenthesis following the field name. ..."

New page

'''Workbench Help'''

All fields are listed alphabetically. The section of the Workbench containing the field is in parenthesis following the field name.

'''Actual''' (Formula Nutrient)
Actual is the amount of the nutrient that is actually in the formula solution after Solve.

'''Actual Pct''' (Formula Ingredient)
Actual Pct is the percent of the ingredient that is actually in the formula solution after Solve.

'''Actual Wgt''' (Formula Ingredient)
Actual Wgt is the weight of the ingredient that is actually in the formula solution after Solve.

'''Batch Weight''' (Formula)
Batch Weight is the target weight for the least-cost solution. Typically, it is a standard size of 1000 for metric system users and 2000 for English system users. Batch Weight is required.

It also could be the size of the batch mixer (say 5000) or even an individual daily intake size for an animal (say 30).

Its interpretation is affected by Dry Matter.

Reports such as Batch Mixer reports and the Formula Solution Report prompt for their own batch weight, so specifying a standard batch weight here does not limit the user later on in the system.

'''Code''' (Formula Nutrient)
Code is an alias for the nutrient that ensures compatibility with other systems.

'''Cost''' (Formula Ingredient)
Formula Ingredient Cost is derived from the Ingredient Cost. However, the Formula Ingredient Cost depends on the selected Cost Type for the Formula.

'''Cost''' (Formula Nutrient)
Formula Nutrient Cost is the savings to the Total Cost that can be realized if the nutrient constraint is changed by one unit.

If cost is positive, then if the maximum is increased by one unit, the total cost will decrease by approximately the cost. Also, if the maximum is increased by one tenth of a unit, the total cost will decrease by approximately one tenth of the cost.

If cost is negative, then if the minimum is decreased by one unit, the Total Cost will decrease by approximately the cost (regardless of the sign). Also, if the minimum is decreased by one tenth of a unit, the total cost will decrease by approximately one tenth of the cost (regardless of the sign).

'''Cost Type''' (Formula)
Ingredient Cost Type determines how cost will be calculated.

Enter one of the following:

Market for replacement cost. If zero, Cost will be used.

Market Only for replacement cost. If zero, zero will be used.

Cost for a second cost. It might contain a “cushion”, or it could be the actual cost, or it may be an artificially lower cost in order to use up an ingredient. If zero, Market will be used.

Cost Only for a second cost. If zero, zero will be used.

High for the higher of Market or Cost

Low for the lower of Market or Cost

Average for average Inventory cost.

Zero for zero cost. Can be used to "hide" costs on a report

On Farm is the sum of Cost plus ingredient margin. Used to price producer feeds that are mixed at the mill for the producer.

'''Dry Matter''' (Formula)
This is a one character field that determines if the solution nutrients and the Batch Weight will be considered as 100% dry matter. Solution ingredients will be printed “as is.”

Enter one of the following:

Y Solution Nutrients and Batch Weight as 100% dry matter.

N (default) Solution Nutrients and Batch Weight “as is.”

'''High Cost''' (Formula Ingredient)
This is the ingredient cost at which some of the ingredient will leave the solution, all other things kept the same.

'''Infeasible Solution''' (Formula)
A common tendency for the novice is to put restrictions on everything in sight, the tighter the better, compounding the mistake with the thought that every minimum needs a maximum, and vice versa!

Actually, the maxim "Less is More" should be followed by the user in setting up restrictions. Unnecessary restrictions not only limit the "trade-offs" available to the least-cost algorithm, thereby resulting in a solution that is more costly, but also can cause infeasibilites.

If you have no clues in "debugging" an infeasible solution, remove half the constraints and solve again, repeating until you have a feasible solution.

Then add back half of the constraints that you most recently discarded, repeating until you have isolated the culprit(s).

'''Ingredients''' (tab)

For ingredients, the minimum and maximum values are expressed in percent or in units of weight. Typical units are kg (kilograms), or lb (pounds).

In general, a nutrient restriction on salt is better than a restriction on a salt ingredient.

'''Log ''' (Formula)
This is a one character field which permits the LP solution statistics to be logged on the screen.

Enter one of the following:

N (default) Do not Log LP statistics.

S Log LP statistics.

D Debug LP

'''Low Cost''' (Formula Ingredient)
This is the ingredient cost at which more of the ingredient will enter the solution, all other things kept the same.

'''Margin ''' (Formula)
This is a one character field that permits margins to be printed on the solution.

Enter one of the following:

Y Print margins.

N (default) Do not print margins.

'''Max''' (Formula Nutrient)
Max is the maximum units of the nutrient that is desired in the formula solution.

'''Max Pct''' (Formula Ingredient)
Max Pct is the maximum percent of the ingredient that is desired in the formula solution.

'''Max Wgt''' (Formula Ingredient)
Max Wgt is the maximum weight of the ingredient that is desired in the formula solution.

'''Min''' (Formula Nutrient)
Min is the minimum units of the nutrient that is desired in the formula solution.

'''Min Pct''' (Formula Ingredient)
Min Pct is the minimum percent of the ingredient that is desired in the formula solution.

'''Min Wgt''' (Formula Ingredient)
Min Wgt is the minimum weight of the ingredient that is desired in the formula solution.

'''Number''' (Formula)
Number is an alias for the formula that ensures compatibility with other systems

'''Nutrients''' (tab)

'''Opt Den'''
{{Optimum Density}}

'''Rng%'''
{{Optimum Density Range Percent}}

'''Prev Cost'''
Previous Cost (Formula)
Total ingredient cost of the formula before current Solve Formula.

'''Ratios'''
Ratio Specifications consist of a nutrient pair, an ingredient pair, or a nutrient and an ingredient. These are followed by an optional minimum ratio or a maximum ratio (or both).

For example, for a Calcium/Phos ratio of from between 1:1 and 2:1, the following Ratio Specification was entered:

No Name No Name Min Max
32 Calcium % 33 Phos % 1.00 2.00

Ratios can be between nutrients and ingredients, "mix 'em or match 'em".

'''Round ''' (Formula)
Round Code is a one character field that determines how the solution will be rounded.

Enter one of the following:

N (default) does NOT round the ingredients.

R rounds the ingredients exactly to the batch weight (the largest ingredient will have any leftover amounts from rounding the other ingredients).

Y rounds the ingredients without regard to the batch weight.

U rounds the ingredients UP without regard to the batch weight.

'''Solve Formula'''
The Solve Formula button creates a new least-cost solution. It updates the Actual (Nutrient amount), Actual Pct (Ingredient), Actual Wgt (Ingredient), Previous Cost (Formula), Total Cost (Formula), Cost (Nutrient), High Cost (Ingredient), Low Cost (Ingredient), and Yield (Formula).

If the Solve Formula calculation is successful, an Optimal Solution message is displayed above the Solve Formula button.

If the Solve Formula calculation is unsuccessful, various Infeasible Solution messages will be displayed above the Solve Formula button.

'''Species'''
Formula Species is a MANDATORY field.

The following Species codes are pre-loaded:
Beef
Dairy
Poultry
Swine
Sheep

'''Total Cost''' (Formula)
Total ingredient cost of the formula after Solve Formula.

'''Type '''
{{Formula Type}}

'''Unit ''' (Formula Nutrient)
The units in which the nutrient minimum and maximum values are expressed are determined by the user in the setup area, where nutrients are added or modified. Typical units are ppm (parts per million), mg/kg ( a synonym for parts per million), % (percent -- meaning percent of total weight). % occurs most frequently

Unit expresses a ratio and is often a compound consisting of a fundamental unit of measure or a derived unit of measure divided by another one.
Examples of compounds are: mg/kg, IU/lb, mcal/kg.

Examples of fundamental units of measure are lb, g, IU.

Examples of derived units of measure are kg, mcal, mg.

'''UoM''' (Formula)
Unit of measure is kg for metric system users and lb for English system users. It is inherited from the setup.

'''Yield ''' (Formula)
The actual weight of the least-cost solution. The Solve Formula button creates the Yield. It should be the same or very nearly the same as the Batch Weight. If not, the least-cost solution may be infeasible.

When Optimum Density is enabled, the yield may differ greatly from the Batch Weight.

@@ Line 10: / Line 10: @@
 Many of the formulas are inherited from the System control level as model formulas.
-You can also restrict formulas to those you have changed or created (and thereby hide formulas from a higher level. Simply check the box that says "Show changed formulas only." Note that this box remains in effect if you change levels. So while you may see many formulas at a higher level, you will see no formulas at a lower level until you at least solve a formula at that level or otherwise make changes.
+You can restrict formulas to those you have changed or created (and thereby hide formulas from a higher level). Simply check the box that says "Show changed formulas only." Note that this box remains in effect if you change levels. So while you may see many formulas at a higher level, you will see no formulas at a lower level until you at least solve a formula at that level or otherwise make changes.
 Another option in the header area is to select a report in the '''Report name''' drop down box.  When the '''Report''' button is clicked for a specific formula, a prompt for the selected report appears.

@@ Line 6: / Line 6: @@
 You may limit the formulas that are listed by using the [[Contains]] feature and/or selecting a specific species using the '''Species''' drop down box.
-You can further change the number of formulas shown on the page by changing the [[Max lines]] value.
+You can create a new formula based on an existing one by going into the [[Workbench]] and clicking the "Copy" button. Copy the formula with a new name (and code, if you use codes).
 Another option in the header area is to select a report in the '''Report name''' drop down box.  When the '''Report''' button is clicked for a specific formula, a prompt for the selected report appears.
 ==Formulae Page Fields==

@@ Line 18: / Line 18: @@
 ===Batch Weight===
 {{Batch weight - general}}
 {{Status}}

@@ Line 18: / Line 18: @@
 ===Batch Weight===
 {{Batch weight - general}}
-{Status}}
+{{Status}}
 ===Species===
 {{Formula Species}}

Formulae - Revision history

Rmrubin: /* Formulae Overview */

Rmrubin: /* Formulae Overview */

Rmrubin at 02:41, 27 March 2014

Rmrubin: /* Batch Weight */

Rmrubin: copy from old wiki

Rmrubin: Created page with "'''Workbench Help''' All fields are listed alphabetically. The section of the Workbench containing the field is in parenthesis following the field name. ..."