www.NALF.org

North American
   Limousin Foundation
Suite 100
7383 S. Alton Way
Centennial, CO  80112

(303) 220-1693
fax: (303) 220-1884

 Please follow these instructions as stated. Failure to do so may result in processing delays.

1. Make sure that all letters are capitalized and that all dates are in the format MM/DD/YY.

2. Submit spreadsheets for weaning and yearling separate from spreadsheets with birth data. Do not include any comments or extra information in the spreadsheet. They will be ignored by our computer system.
If you are submitting weaning and/or yearling data on an animal that is already recorded, Please do not resubmit birth data. The only fields that should be submitted for updates are: herd prefix, tattoo number, year code, sex, weigh date and weight (Plus any other measurements). Also note in the e-mail that these are performance updates only (Weaning updates and/or yearling updates).

3. Save the data in a comma-delimited file using your member number as the file name (e.g., N123456.csv).

4. Save a copy of the file for your own records.

5. Send the file to edata@nalf.org.

Column Column Name	Column Format
A Dam Tag	Enter up to six characters of dam’s ear tag number (e.g., 0104X). Make sure that the cells in this column are formatted as text cells or leading zeros will be eliminated. For foundation cows, leave blank.
B Dam Herd Prefix	Enter herd prefix in capital letters (e.g., ABCD). For foundation cows, leave blank.
C Dam ID	Enter up four characters of dam’s tattoo (e.g., 0104 or 104). Make sure that the cells in this column are formatted as text cells or leading zeros will be eliminated. For foundation cows, leave blank.
D Dam Year Code	1990 = Y 1991 = A 1992 = B 1993 = C 1994 = D 1995 = E 1996 = F 1997 = G 1998 = H 1999 = J 2000 = K 2001 = L For foundation cows, leave blank.
E Dam Registration	Enter complete registration number, separating three-letter prefix and number by a hyphen (e.g., NPF-123456). For foundation cows, enter FC#, followed by a hyphen and the dam’s ear tag number (e.g., FC#-0104X).
F Dam Breed	For foundation cows only— Enter 8 character description of the dam’s breed composition, where each character represents 12.5% of the breed composition. For example, the breed composition of a halfblood Simmental-Angus dam would be entered as AAAA1111. If the dam’s breed composition is unknown, enter XXXXXXXX. See page D-4 of the Member’s Manual for list of valid breed codes.

G Dam Birth Date	For foundation cows only— Enter month, day and year of dam’s birth as MM/DD/YY (e.g., 03/04/01). If only the year of birth is known, leave blank.
H Dam Status	Valid options are the letters A through O. See pages D-5 and D-6 of the Member’s Manual for more information.
I Sire Registration	Enter complete registration number, separating three-letter prefix and number by a hyphen (e.g., NPM-123456).
J AI	Enter Y if dam was AI serviced. Otherwise leave blank.
K Breeding Date	Enter month, day and year of AI or observed breeding date as MM/DD/YY (e.g., 03/04/01). Required if calf is the result of AI.
L Calf Herd Prefix	Enter herd prefix in capital letters (e.g., ABCD).
M Calf ID	Enter up four characters of calf’s tattoo (e.g., 0104). Make sure that the cells in this column are formatted as text cells or leading zeros will be eliminated.
N Calf Year Code	2001 = L 2002 = M 2003 = N 2004 = P 2005 = R
O LOC (Location of Tattoo)	L = Left ear R = Right ear B = Both ears
P Calf Tag	Enter up to six characters of calf’s ear tag number (e.g., 0104X). Make sure that the cells in this column are formatted as text cells or leading zeros will be eliminated.
Q Birth Date	Enter month, day and year of calf’s birth date as MM/DD/YY (e.g., 03/04/01).
R Birth Group	Enter up to two characters to designate birth contemporary group (e.g., 1 or H1).
S Sex	B = Bull H = Heifer S = Steer If form is filled out at weaning time, bull calves that are castrated at weaning should be listed as bulls. Bull calves castrated at weaning should be recorded as steers when yearling information is submitted. Bull calves castrated before 3 months of age should be listed as steers at weaning.

T Type	S = Single birth T = Twin, triplet or other multiple birth
U HPS	H = Horned P = Polled or smooth polled S = Polled with scurs Horned, polled and scurred status may be reported when weaning or yearling data are submitted.
V Color	1 = Red, no white other than underline 2 = Black, no white other than underline 3 = Red with white on face or body 4 = Black with white on face or body 5 = Cream 6 = Other colors not listed above
W Birth Weight	Enter in pounds as a whole number without any decimal places (e.g., 87).
X Calving Ease	A = Unassisted B = Some assistance C = Mechanical assistance D = Cesarean E = Abnormal presentation
Y Calf Name	Enter up to 25 characters for calf’s name. Do not include any commas. If left blank, NALF will use herd prefix and tattoo.
Z Register	Enter N if you do not want animal to be registered. Otherwise leave blank.
AA Weaning Date	Enter month, day and year the calf’s weaning weight was taken as MM/DD/YY (e.g., 10/04/01).
AB Weaning Group	Enter up to two characters to designate weaning contemporary group (e.g., 1 or H1).
AC Foster/Creep	F = Fostered C = Creep fed for 6 weeks or more
AD Weaning Weight	Enter in pounds as a whole number without any decimal places (e.g., 585).
AE Weaning Hip Height	Enter in inches with one decimal place (e.g., 46.5).
AF Calf Docility	1 = Docile 2 = Restless 3 = Nervous 4 = Flighty (wild) 5 = Aggressive 6 = Very aggressive
AG Dam Weight at Weaning	Enter in pounds as a whole number without any decimal places (e.g., 1225).

AH Dam Condition	1 = Emaciated 2 = Poor 3 = Thin 4 = Borderline 5 = Moderate 6 = High moderate 7 = Good 8 = Fat 9 = Extremely fat
AI Yearling Date	Enter month, day and year the calf’s yearling weight was taken as MM/DD/YY (e.g., 03/04/01).
AJ Yearling Group	Enter up to two characters to designate yearling contemporary group (e.g., 1 or H1).
AK Yearling Weight	Enter in pounds as a whole number without any decimal places (e.g., 855).
AL Yearling Hip Height	Enter in inches with one decimal place (e.g., 49.5).
AM Scrotal	Enter in centimeters with two decimal places (e.g., 32.25).
AN Pelvic Height	Enter in centimeters with one decimal place (e.g., 14.1).
AO Pelvic Width	Enter in centimeters with one decimal place (e.g., 14.1).