2. Important Note about Supplied Examples
WinFeed comes with few examples of Feed Store and readymade formulae. Please note that these examples are just for understanding of the programme. They should not be used for real life feeding practice. The nutrient composition has been selected to be reasonable but there is no guarantee for their accuracy. It is recommended to prepare your own nutrient composition database and formulas for real life feed formulation.
3. Opening Window
This window provides the following options.
Open an already saved formula
This option will let you open a previously saved formula. Few example formulas have been provided with WinFeed. These formulas can be open through this option.
Select Animal Requirement Set and an appropriate Feed Store
This is one of the most important functions of this software. WinFeed allows you to save animal’s nutrient requirement in one file and the Feed Store (Ingredient Composition Database) in another file. For example, you can have various requirement files like “Nutrient Requirement for Broiler”, “Nutrient Requirement for Layer Finisher”, Nutrient Requirement for Lamb”, Nutrient Requirement for Dairy Cow” etc. in separate files. Similarly you can save various Feed Stores such as “Feed Store for Summer Season”, “Feed Store for Poultry”, “Feed Store for Region 1”, “Feed Store for Cattle Region 2”, etc. Once you have these files ready, you can use this option to select one requirement set such as “Nutrient Requirement for Broiler” and an appropriate Feed Store such as “Feed Store for Summer Season”, and then start formulation. Few example requirement sets and Feed Store have been provided with WinFeed. Please try them to understand this function.
Start a new formula using an existing Feed Store
By selecting this option you can start a new formula with a selected Feed Store. When you click on this option, you will be asked to select a Feed Store file. After selecting Feed Store, you will be taken to the Main Window where you can select ingredients to be used in formulation. You will also be required to enter nutrient requirements manually in the Main Window.
Start a brand new formula with a new Feed Store
Probably this is the option you will be using very first time. When you select this option a blank Feed Store and a blank formula will be opened. You will have to enter Ingredients and their price and nutrient composition in the Feed Store Window. The Feed Store Window can be accessed from the Main Window. You will also be required to enter nutrient requirement values in the Main Window.
Import Animal Nutrient Requirements from MS Excel file
This function lets you import Animal Requirements from an Excel file into WinFeed. Many organisations publish Feeding Standards in MS Excel format. After changing data order in these files according to WinFeed required pattern, these files can be directly import into WinFeed. Thus this function not only saves your time but also prevents data entry typo errors.
This function is very sensitive. It will not work if any of the instructions given below is not followed. The data must be exactly in a specific order. An example Excel files “Example 28 Requirements.xls” has been provided with WinFeed. This file should be examined thoroughly to understand required format. This example Excel file can be found in “Animal Requirements” folder. Carefully examine this file to understand required format.
The first three rows are for any reference and column heading. The file contains names of nutrients in the first column, nutrients requirements or minimum limits in the second column and maximum limits in the third column. The following instructions must be followed when preparing Excel file.
Import Feed Store from MS Excel file
This function lets you convert data from an Excel file into WinFeed Feed Store. This function is very sensitive and it will not work if any of the instructions given below is not followed.
If you are importing data for Stochastic Formulation then two Excel files are required to perform this task. If you are importing data for Linear Formulation then only one file containing Mean values is required. These Excel files must be is a specific format. Two example Excel files are provided with WinFeed. These files should be examined thoroughly to understand the required format. The names of these files are
Example 28 for Means.xls
Registering WinFeed as a Full Version
An “Unblocking Key” is required to register and convert the demo version as a full version. This key can be found on the Licence Certificate. If it has been lost a duplicate key can be obtained from WinFeed Sales Department. A proof of purchase will be required.
8. Shadow Price Window
Shadow Prices indicate that how much a formula price could potentially be reduced if a particular limit is relaxed up to one unit. It is an over all analysis of the formula. For example, consider a formulation problem in which minimum limit for protein is set at 23%. When this problem is solved the formula price comes as 160 dollars and the shadow price of minimum limit of protein is appears as 5.0. It means if minimum limit of protein is set at 22% and the problem is solved again the formula price will be reduced to 155 dollars. Similarly consider another situation in which maximum limit of inclusion of soybean is set at 40%. When the problem is solved, the formula price comes as 80 dollars and the shadow price of maximum limit of soybean appears as 1.75. It shows that if maximum limit of inclusion of soybean is set at 41% and the problem is solved again the formula price will be reduced to 78.25 dollars.
Remember that shadow price indicates only potential reduction in the formula price. This reduction will only happen if the relaxed unit is actually utilised. For example, in the above situation the formula price will be reduced to 78.25, only if 41% soybean is used in the formula. If for some reason soybean is still being used only 40%, the formula price will not be reduced.
Shadow Price Window also shows competitive prices for those ingredients that have not been included in the formula. A competitive price shows at what price that ingredient could be used in the formula.
9. Batch Sheet Window
This window helps in preparation of different batchs from a calculated formula. You can prepare any batch size. This window also shows formula on Dry matter basis and As-Fed basis separately.
Enter amount of total batch size here. By default it calculates for 1000 Kg. TO make a batch of different size, change this value to required value and press “Enter” key. A batch for new value will be calculated and displayed immediately.
This shows the total size of the batch after rounding “As Fed” batch quantities.
This is the number of decimal digit for rounding. By default all values are rounded up to two decimal digits. The default value can be changed under Digit column. An individual value can be selected for each ingredient.
Date and Time
This box shows date and time when actual batch was prepared.
Cost per Bag
This filed shows price of one feed bag if current formula is used. The bag size is same as selected in Main Window.
Save Batch as a Text File
By selecting this command under File menu you can save a Batch in a text file. This text file can be opened in Microsoft Word or Microsoft Excel for further processing.
Save Batch as a CSV file
A CSV file is a “Comma Separated Values” text file. These files are also known as “Comma Delimited” files. This is a common format to exchange data between different worksheet and database applications. If you intend to transfer your Batch into MS Excel or any other database, you can save your Batch as a CSV file. In these files each value is separated by a comma. MS Excel puts every value separated by a comma into a separate cell. Once you have opened a CSV file in MS Excel, save it as an Excel file (.xls) for further use.
Print function lets you to print final batch on a paper.
Print Batch Only
This function lets you print only ingredient names and rounded batch values. This function is useful if you give batch sheet to feed mill operator and wish to keep formula analysis and formula price secret.