BroilerOpt A Broiler Optimization Program Getting Started III Matrix and Diet Transfer From Brill System
Start BroilerOpt then go to Load Least Cost The data for transfer must be set up before starting. A demo file is included in the startup directory. Open it to see how the data should be formatted. The ingredient names will be in column 1 and the nutrient names in Row 1.
Select an Excel Filewith the Data you want • Click on the MatrixKg.xls file and it will be opened into a grid.
Now open the Sheet with the Matrix Data • Once the sheet is selected the data are displayed. You can sort the rows by changing the values in the first row, change the value and click on “Sort by column 1”. When the ingredients are in the order you want, save the data by clicking on “Save Matrix”
Review the data for Accuracy, Order of Ingredients and Nutrients • While you can change any name or value at this point, change the value of column 1 and resort the ingredients to the order you want, it is best to do this in Excel before opening the file. • The first row is the Model name for a Nutrient, such as Lysine, Row 1 is your names for the nutrient. Be sure that the first 14 match. The model uses these values for its calculations in the order given.
Change the value of the ingredient you want moved, as above. You could just change Meat & Bone to 11.5 and the same outcome would result. When the order is numerically what you want, click on “Sort by column 1” Changing Ingredient Order
Handling Missing Amino Acid Values not a Problem • If you do not normally use an amino acid, just leave it blank as in the example above. Do the same for amino acid requirements in the diets section and the model will recognize that this amino acid is not limiting. • Note that the Meat & Bone moved to the lower position.
When the data are in order, click “Save Matrix”. The data will be read into the program and can be stored in the existing Location or in a New Location from the main Program. Save Matrix Command Sends the Data to the Program
You can save the new matrix to the existing Location/Complex name or enter a new name to give the data a unique identity. Click “Save Current” to save the data to a file. Determine the Name for the Matrix Data Set and Save it
Importing Diet Nutrients and Restrictions begins with Open Diets • Entering Diet information from Excel is different as it is first copied into memory of your computer, called the Clipboard, and then into BroilerOpt. Click on Open Diets to get to that form.
First, copy the Diet Info from Excel to the Clipboard • The data are in the same order as the Ingredient sheet. Nutrients in Row 1 and the diets (as many as you like, you can chose which to use later) in rows below that. The values are the Diet Contents, not Restrictions. • Copy only the boxes that are colored green. The other info is not wanted. • Highlight the colored boxes and select Edit, Copy or use Control- C to copy the data.
Open the Feeds Form and then select Import from Clipboard • The data will be read from the “Clipboard” into the program. These can then be used and saved by the program. You can replace the existing diets or add the new diets to them and select between them for the ones to be fed during the growth calculations.
You Add the New Diets to the Existing Ones and Choose which are fed by the Model • The new diets are added to the existing list. You simply enter the number 1 for the first diet you want to use, 2 for the second up to the number of diets you have chosen to use.
Adding Nutrient and Ingredient Restrictions is also available • On the current screen, click on the “Show Least Cost Info” button to start. The information should be set up in Excel and is shown in the Matrixkg.xls file on the diets sheet. • Each diet information is imported individually.
Set up the Information in Excel to Import by Diet • Be sure you have the right tab (Nutrient Requirements by Diet or Ingredient Restrictions) and the correct diet. • Then copy the information from Excel onto the clipboard and then Click on the “Import Restrictions from Clipboard”
Importing Diet Specs for Nutrients can be done if copied in the Proper Format • Importing Nutrient Restrictions and Ingredient restrictions are similar, and prices can be imported in a list as well. Make up your own lists and copy the information in the Green only.
Adding Ingredient Specs and Prices are Similar • Choose the right diet for Ingredient Specs, set the requirements up in Excel, Copy the Excel data with Control-C or Edit-Copy. Click on the Import Button shown above. The prices are displayed and edited here on the Ingredient Restrictions Tab but are diet independent so save them only once for all diets.