Standard Table Data Import
- Amanda Thomas
Below is an example of importing the Percent Hen Day Production table. Then you will use the standard table data import process to bring in to Aeros Live. Use the attached import spreadsheet.
You can only do one Table Type per file. You can import all files at once though.
Table Type must match the below list appropriately.
Must start at Week or Day 1, if no value for that time enter 0
For Mortality Table, it is not cumulative but the difference from one week to the next (rate of change) (see example below)
**If you want to overwrite the existing tables, then you will give them the same code and description as in the table. If you do not want to overwrite the existing tables with the new ones the code and description you provide in the table should be unique. Updating existing tables will change past data in the system.
TableTypeName
Percent Mortality
Percent Livability
Pounds per 100 per Day
Accumulated Pounds Per Head
Pounds per head by period
Calorie Consumption
Density per Square Foot
Density per Square Meter
Body Weight in Pounds
Body Weight in Grams
Percent Hen Day Production
Percent Cull Eggs Production
Case Weight (Lbs)
Case Weight (Kgs)
Body Weight in Kilograms
Egg Type Schedule
Depreciation Percentage
Calorie Consumption in Kilograms
Kilograms per 100 per Day
Water Consumed, gallons per 100 per day
Inside Average (F)
Inside High (F)
Inside Low (F)
Outside Average (F)
Outside High (F)
Outside Low (F)
Inside Average (C)
Inside High (C)
Inside Low (C)
Outside Average (C)
Outside High (C)
Outside Low (C)
If you get an import error – “Invalid Spreadsheet”
Try changing your excel format to .xls instead of .xlsx or visa versa
Make sure that the spreadsheet tab says Sheet1
Make sure that the 2nd row in the spreadsheet has the CONTROL line.
Mortality example
