Egg Size Types

First step is to configure the egg size names you will be using.

System > System Settings > System Types > Egg Size Types.

In here you will see the list of available egg size type codes and descriptions. The code and description of any of the existing ones can be changed to suit your needs.  Important: Only the existing code that have ‘Is system’ checkbox are available in the AeLive reports. That means if you use the ‘add’ button to create a new code, it will not appear in any of your reports. So, if you need a size category that is not in the list REUSE one of the other codes so you can get report results for it.

Egg Size Matrix Configuration

Once you have your system type list of egg sizes, you will then use them to create an Egg Size Matrix Configuration.

System > Egg Size Matrix Config.

Use the ‘Add New’ button to create a new matrix. Give it a code, description and set it to ‘Active’. The left column will show you all the Egg Size Categories. Select a size category and hit the right arrow button to add it to the right side listing to add it to this configuration. In the right side you can also set the order of the list by clicking and draging a code up and down the list. The order in this configuration controls the order that will appear in the rest of the system. 

You can make as many configurations as you need or just use one. One table does not have to use all the categories.  One table might have Jumbo to Undergrade while other has Super Jumbo to Pee Wee, you decide.

Case Weight Standards

You can add case weight standards in the system which can be applied to the egg Matrix Tables for Egg Size Percents based on that Case Weight.

Select ‘Add New’ Enter Code and Description for the table.  Select the Ages UOM you want to enter the standards for. By Day or By Week.

Go to Table Tab.  Here is where you will enter your Case weight standards by day or by week.  The age will fill in automatically in order as you enter values.

Percent HD Production and Percent Mortality Standard Tables

Percent HD Production and Percent Mortality Standard Tables are also utilized in the projection and should be set up and applied to Flocks/Contracts

Open

Egg Matrix Standard Table

System > System Table > Egg Matrix Table

Once in there you will ‘Add New’ to create a new table.  You will have an option to select a Configuration. This configuration is the list and order of egg sizes that you have configured in the egg size matrix.

The configuration will set the column headers with the egg sizes from the configuration.

Then go to the Table tab

Determine the percent value for each size by age. The values for each row must total to 100.00%

Open

Load Case Weight to standard

If you already have a system table for case weights that you want to use for the Egg Size Matrix, you can apply it using the Load Case Weights. Just fill in all your egg size percentages first and save the table. Then hit the Load Case Weights button at the top of the table. You will be asked to select a case weight system table and when you hit accept, all the ages that exist in the egg size matrix will get the same case weight for the corresponding age from the selected case weight table.

Load the case weight standard table you want to use.

It then fills in from your standard table into Average Lbs.

Egg Size by Age or Case Weight/Age

System → Settings = System Settings

 Configuration for egg sizes to be determined by Age or by Case Weight/Age.

Apply tables to Flocks/Contracts

You must apply the created standard tables to the flock and/or add to the contracts.  You can use your standard system tables or create system tables specific to projections.  If you do not have projection tables assigned to a flock it will use your standard system tables assigned to your flock.

Default Egg Types

Default egg types (Flock Form) or Egg Type Schedules (Needed for flocks that will change Egg Types during life of flock) should be applied.

The values in the drop down come from system types.  You can set up additional egg types by going to

System → Settings (Ribbon Bar) → System Types Tab and selecting Egg Type from the drop down.

Default Egg Type on Flock Form

To Set up an Egg Type Schedule see instructions here: Default Egg Type Scheduler    (This is a new Feature that will be available in build 1.46+)

Report

Set your parameters, dates and run.

When the report is finished running and you bring it up, you will have to set the parameters on the left side.

For the following example, I ran for three weeks and three flocks.

Show Flocks: No

This is what the report looks like in summary, it breaks it out by egg type and gives the total for the week.

Show Flocks: Yes

This is what the report looks like in detail, it breaks it out by egg type and gives the totals for each flock and each week.

Calculations

When calculating egg size projections, we must first identify the standard distribution that we would like to use. The software will do this by using a combination of the flock's age, as well as actual and standard case weights. Before determining egg size distribution. projected case weights will have already been calculated for the flock. The actuals will be reported and when they are a trend is established that will either increase or decrease the standard value. Once we have run out of actual case weights the projected value will be reported in place of actuals, with this value being the standard adjusted by the trend percent.

Now that we have our case weight, we'll use the flock's age to return the egg size distributions for that age. If the value is within .5 pounds of our projected case weight, we will use those distributions. If it is not we will find the case weight nearest to the flock's age that is an approximate of our projected value. Once we find that, we'll use those distributions. If we cannot find anything that approximates, we'll use the distributions for the flock's age. This approximation will only happen for distributions in the same table.

With our distributions in hand, the calculation can now determine how many eggs of our egg productions belong to which egg sizes.

Note that when the "Projected Egg Size By Age" configuration is set in the System Settings, that the calculation will always return the egg size distributions by age.