Diff for "public/itb files" - Interbull Centre Wiki

Differences between revisions 1 and 2

FILE FORMAT FOR INTERNATIONAL PREDICTED GENETIC MERIT

Field Description	Format
Record type (1)	character 3
Breed of evaluation (2)	character 3
Bull international identification (3)
Breed of bull	character 3
Country of registration of bull (4)	character 3
Sex	character 1
ID number of bull (5)	character 12

EMPTY SPACE	1
Date of international evaluation (YYYYMM)	integer 6
EMPTY SPACE	1
Official publication of proof (6)	character 1

Number of repeated segments for this file
number of countries	integer 3
number of traits (7)	integer 3

International proof in each country (8)
EMPTY SPACE	1
Country code	character 3
EMPTY SPACE	1
Genetic merit (international proof) definition(9)	character 2
Number of herds	integer 8
Number of daughters	integer 8
Effective Daughter Contribution	integer 8
EMPTY SPACE	1
Repeatability/Reliability (%)	integer 2
International proof (x1000) (10)	integer 10

KEY TO: INTERBULL GENETIC EVALUATION FILE FORMAT

1. 030 = Interbull Production File; 035 = Interbull Conformation File; 036 = Interbull Udder health file; 037 = Interbull Longevity File; 038 = Interbull Calving File; 039 = Interbull Female Fertility File; 140 = Interbull Workability File.

2. BSW = Brown Swiss, GUE = Guernsey, HOL = Holsteins, JER = Jersey, RDC = Red Dairy Cattle, SIM = Simmental

3. International identification in the country of first registration as known at the Interbull Centre; this is the first ID in new cross-reference list Xrefmult.*** found on the Interbull ftp site (where *** refer to breed).

4. Country codes of Interbull members (in alphabetical order):

ARG=Argentina; AUS=Australia; AUT=Austria; BEL=Belgium; BUL=Bulgaria;CAN=Canada; HRV=Croatia; CZE=Czech Republic; [DFS:Denmark,Finland,Sweden]; DNK=Denmark; EST=Estonia; FIN=Finland; FRA=France; [DEU=Germany,Austria]; DEU=Germany; GRC=Greece; HUN=Hungary; IRL=Ireland; ISR=Israel; ITA=Italy; JPN=Japan; KOR=Korea; LVA=Lathvia; LTU=Lithuania;LUX=Luxembourg; MEX=Mexico; NLD=Netherlands; NZL=New Zealand; NOR=Norway; POL=Poland; PRT=Portugal; SVK=Slovak Republic; SVN=Slovenia; ZAF=South African Republic; ESP=Spain; SWE=Sweden; CHE=Switzerland; GBR=United Kingdom; USA=United States of America.

5. ID numbers: Registration numbers, right justified, leading blanks as zeros.

6. Y = Bull meets standard for official publication in at least one country.

7. Number of traits:

Production i = 3 (1=mi, 2=fa, 3=pr ) Udder health i = 2 (1=sc, 2=ma ) Longevity i = 1 (1=dl ) Calving i = 4 (1=dc, 2=mc, 3=ds, 4=ms ) Fertility i = 5 (1=ch, 2=cy, 3=c1, 4=c2, 5=it) Workability i = 2 (1=md, 2=te ) Conformation BSW i= 22 (1=sta 2=cwi 3=bde 4=ang 5=ran 6=rwi 7=rls 8=fan 9=hde 10=fua 11=ruh 12=ruw 13=usu 14=ude 15=ftp 16=ftl 17=rtp 18=ocs 19=ous 20=ofl 21=loc 22=bcs) RDC HOL JER GUE i= 21 (1=sta 2=cwi 3=bde 4=ang 5=ran 6=rwi 7=rls 8=rlr 9=fan 10=fua 11=ruh 12=usu 13=ude 14=ftp 15=ftl 16=rtp 17=ocs 18=ous 19=ofl 20=loc 21=bcs)

8. Repeat as necessary depending on number of countries;

9. B+ = Breeding Value, high values desirable; B- = Breeding Value, low values desirable; T+ = Transmitting Ability, high values desirable; T- = Transmitting Ability, low values desirable.

10. International proof expressed as either estimated B+, B-, T+ or T-, in base and unit of each country; proofs are multiplied by 1000 to include 3 decimals; missing values are represented by 999999.

-  ⇤ ← Revision 1 as of 2012-02-29 17:38:43 → 
  Size: 17847
  Editor: Valentina
  Comment:
+   ← Revision 2 as of 2012-02-29 17:43:39 → ⇥
  Size: 19028
  Editor: Valentina
  Comment:
-Deletions are marked like this.
+Additions are marked like this.
 Line 1:
+== FILE FORMAT FOR INTERNATIONAL PREDICTED GENETIC MERIT ==
||<tablestyle="border-collapse:collapse;mso-table-layout-alt:fixed;border:none;mso-border-alt:solid windowtext .5pt;mso-yfti-tbllook:1184;mso-padding-alt:0pt 5.4pt 0pt 5.4pt" tableclass="MsoTableGrid"rowstyle="mso-yfti-irow:0;mso-yfti-firstrow:yes"width="487px" style="border:solid windowtext 1.0pt;mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">'''Field   Description''' ||<width="151px" style="border-width:1pt 1pt 1pt medium;border-style:solid solid solid none;border-color:windowtext windowtext windowtext -moz-use-text-color;-moz-border-top-colors:none;-moz-border-right-colors:none;-moz-border-bottom-colors:none;-moz-border-left-colors:none;-moz-border-image:none;padding:0pt 5.4pt;font-weight:bold;    ;vertical-align:top">Format ||
||<rowstyle="mso-yfti-irow:1"width="487px" style="border:solid windowtext 1.0pt;border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">Record type   (1) ||<width="151px" style="border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">character 3 ||
||<rowstyle="mso-yfti-irow:2"width="487px" style="border:solid windowtext 1.0pt;border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">Breed of   evaluation (2) ||<width="151px" style="border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">character 3 ||
||<rowstyle="mso-yfti-irow:3"width="487px" style="border:solid windowtext 1.0pt;border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">Bull   international identification (3) ||<width="151px" style="border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top"> ||
||<rowstyle="mso-yfti-irow:4"width="487px" style="border:solid windowtext 1.0pt;border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">Breed of bull ||<width="151px" style="border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">character 3 ||
||<rowstyle="mso-yfti-irow:5"width="487px" style="border:solid windowtext 1.0pt;border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">Country of registration of bull (4) ||<width="151px" style="border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">character 3 ||
||<rowstyle="mso-yfti-irow:6"width="487px" style="border:solid windowtext 1.0pt;border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">Sex ||<width="151px" style="border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">character 1 ||
||<rowstyle="mso-yfti-irow:7"width="487px" style="border:solid windowtext 1.0pt;border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">ID number of bull (5) ||<width="151px" style="border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">character 12 ||
||<rowstyle="mso-yfti-irow:8"width="487px" style="border:solid windowtext 1.0pt;border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top"> ||<width="151px" style="border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top"> ||
||<rowstyle="mso-yfti-irow:9"width="487px" style="border:solid windowtext 1.0pt;border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">EMPTY SPACE ||<width="151px" style="border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">1 ||
||<rowstyle="mso-yfti-irow:10"width="487px" style="border:solid windowtext 1.0pt;border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">Date of   international evaluation (YYYYMM) ||<width="151px" style="border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">integer   6 ||
||<rowstyle="mso-yfti-irow:11"width="487px" style="border:solid windowtext 1.0pt;border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">EMPTY SPACE ||<width="151px" style="border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">1 ||
||<rowstyle="mso-yfti-irow:12"width="487px" style="border:solid windowtext 1.0pt;border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">Official   publication of proof (6) ||<width="151px" style="border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">character 1 ||
||<rowstyle="mso-yfti-irow:13"width="487px" style="border:solid windowtext 1.0pt;border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top"> ||<width="151px" style="border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top"> ||
||<rowstyle="mso-yfti-irow:14"width="487px" style="border:solid windowtext 1.0pt;border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">Number of   repeated segments for this file ||<width="151px" style="border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top"> ||
||<rowstyle="mso-yfti-irow:15"width="487px" style="border:solid windowtext 1.0pt;border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">number of countries ||<width="151px" style="border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">integer   3 ||
||<rowstyle="mso-yfti-irow:16"width="487px" style="border:solid windowtext 1.0pt;border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">number of traits (7) ||<width="151px" style="border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">integer   3 ||
||<rowstyle="mso-yfti-irow:17"width="487px" style="border:solid windowtext 1.0pt;border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top"> ||<width="151px" style="border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top"> ||
||<rowstyle="mso-yfti-irow:18"width="487px" style="border:solid windowtext 1.0pt;border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">International proof   in each country (8) ||<width="151px" style="border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top"> ||
||<rowstyle="mso-yfti-irow:19"width="487px" style="border:solid windowtext 1.0pt;border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">EMPTY SPACE ||<width="151px" style="border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">1 ||
||<rowstyle="mso-yfti-irow:20"width="487px" style="border:solid windowtext 1.0pt;border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">Country code ||<width="151px" style="border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">character 3 ||
||<rowstyle="mso-yfti-irow:21"width="487px" style="border:solid windowtext 1.0pt;border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">EMPTY SPACE ||<width="151px" style="border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">1 ||
||<rowstyle="mso-yfti-irow:22"width="487px" style="border:solid windowtext 1.0pt;border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">Genetic merit (international proof) definition(9) ||<width="151px" style="border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">character 2 ||
||<rowstyle="mso-yfti-irow:23"width="487px" style="border:solid windowtext 1.0pt;border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">Number of herds ||<width="151px" style="border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">integer   8 ||
||<rowstyle="mso-yfti-irow:24"width="487px" style="border:solid windowtext 1.0pt;border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">Number of daughters ||<width="151px" style="border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">integer   8 ||
||<rowstyle="mso-yfti-irow:25"width="487px" style="border:solid windowtext 1.0pt;border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">Effective Daughter   Contribution ||<width="151px" style="border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">integer   8 ||
||<rowstyle="mso-yfti-irow:26"width="487px" style="border:solid windowtext 1.0pt;border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">EMPTY SPACE ||<width="151px" style="border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">1 ||
||<rowstyle="mso-yfti-irow:27"width="487px" style="border:solid windowtext 1.0pt;border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">Repeatability/Reliability (%) ||<width="151px" style="border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">integer   2 ||
||<rowstyle="mso-yfti-irow:28;mso-yfti-lastrow:yes"width="487px" style="border:solid windowtext 1.0pt;border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">International proof (x1000)  (10) ||<width="151px" style="border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt;vertical-align:top">integer   10 ||
-Line 3:
+Line 33:
-== FILE FORMAT FOR INTERNATIONAL PREDICTED GENETIC MERIT ==
+=== KEY TO: INTERBULL GENETIC EVALUATION FILE FORMAT ===
1.   030 = Interbull Production File; 035 = Interbull Conformation File; 036 = Interbull Udder health file; 037 = Interbull Longevity File; 038 = Interbull Calving File; 039 = Interbull Female Fertility File; 140 = Interbull Workability File.
-Line 5:
+Line 36:
-||<tablestyle="border-collapse:collapse;mso-table-layout-alt:fixed;border:none;  mso-border-alt:solid windowtext .5pt;mso-yfti-tbllook:1184;mso-padding-alt:  0pt 5.4pt 0pt 5.4pt" tableclass="MsoTableGrid"rowstyle="mso-yfti-irow:0;mso-yfti-firstrow:yes"^  width="487px" style="width:365.4pt;border:solid windowtext 1.0pt;   mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt">'''Field   Description'''                                                  ||<^  width="151px" style="width: 113.4pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; -moz-border-image: none; padding: 0pt 5.4pt; font-weight: bold;">Format ||
||<rowstyle="mso-yfti-irow:1"^  width="487px" style="width:365.4pt;border:solid windowtext 1.0pt;   border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;   padding:0pt 5.4pt 0pt 5.4pt">Record type   (1)                                                    ||<^  width="151px" style="width:113.4pt;border-top:none;border-left:   none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;   mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;   mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt">character 3 ||
||<rowstyle="mso-yfti-irow:2"^  width="487px" style="width:365.4pt;border:solid windowtext 1.0pt;   border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;   padding:0pt 5.4pt 0pt 5.4pt">Breed of   evaluation (2)                                          ||<^  width="151px" style="width:113.4pt;border-top:none;border-left:   none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;   mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;   mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt">character 3 ||
||<rowstyle="mso-yfti-irow:3"^  width="487px" style="width:365.4pt;border:solid windowtext 1.0pt;   border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;   padding:0pt 5.4pt 0pt 5.4pt">Bull   international identification (3) ||<^  width="151px" style="width:113.4pt;border-top:none;border-left:   none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;   mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;   mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt"> ||
||<rowstyle="mso-yfti-irow:4"^  width="487px" style="width:365.4pt;border:solid windowtext 1.0pt;   border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;   padding:0pt 5.4pt 0pt 5.4pt">     Breed of bull                                                 ||<^  width="151px" style="width:113.4pt;border-top:none;border-left:   none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;   mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;   mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt">character 3 ||
||<rowstyle="mso-yfti-irow:5"^  width="487px" style="width:365.4pt;border:solid windowtext 1.0pt;   border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;   padding:0pt 5.4pt 0pt 5.4pt">     Country of registration of bull (4)                         ||<^  width="151px" style="width:113.4pt;border-top:none;border-left:   none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;   mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;   mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt">character 3 ||
||<rowstyle="mso-yfti-irow:6"^  width="487px" style="width:365.4pt;border:solid windowtext 1.0pt;   border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;   padding:0pt 5.4pt 0pt 5.4pt">     Sex                                                           ||<^  width="151px" style="width:113.4pt;border-top:none;border-left:   none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;   mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;   mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt">character 1 ||
||<rowstyle="mso-yfti-irow:7"^  width="487px" style="width:365.4pt;border:solid windowtext 1.0pt;   border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;   padding:0pt 5.4pt 0pt 5.4pt">     ID number of bull (5)                                       ||<^  width="151px" style="width:113.4pt;border-top:none;border-left:   none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;   mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;   mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt">character 12 ||
||<rowstyle="mso-yfti-irow:8"^  width="487px" style="width:365.4pt;border:solid windowtext 1.0pt;   border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;   padding:0pt 5.4pt 0pt 5.4pt"> ||<^  width="151px" style="width:113.4pt;border-top:none;border-left:   none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;   mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;   mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt"> ||
||<rowstyle="mso-yfti-irow:9"^  width="487px" style="width:365.4pt;border:solid windowtext 1.0pt;   border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;   padding:0pt 5.4pt 0pt 5.4pt">EMPTY SPACE                                                                  ||<^  width="151px" style="width:113.4pt;border-top:none;border-left:   none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;   mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;   mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt">1 ||
||<rowstyle="mso-yfti-irow:10"^  width="487px" style="width:365.4pt;border:solid windowtext 1.0pt;   border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;   padding:0pt 5.4pt 0pt 5.4pt">Date of   international evaluation (YYYYMM)                        ||<^  width="151px" style="width:113.4pt;border-top:none;border-left:   none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;   mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;   mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt">integer   6 ||
||<rowstyle="mso-yfti-irow:11"^  width="487px" style="width:365.4pt;border:solid windowtext 1.0pt;   border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;   padding:0pt 5.4pt 0pt 5.4pt">EMPTY SPACE                                                                  ||<^  width="151px" style="width:113.4pt;border-top:none;border-left:   none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;   mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;   mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt">1 ||
||<rowstyle="mso-yfti-irow:12"^  width="487px" style="width:365.4pt;border:solid windowtext 1.0pt;   border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;   padding:0pt 5.4pt 0pt 5.4pt">Official   publication of proof (6)                                ||<^  width="151px" style="width:113.4pt;border-top:none;border-left:   none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;   mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;   mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt">character 1 ||
||<rowstyle="mso-yfti-irow:13"^  width="487px" style="width:365.4pt;border:solid windowtext 1.0pt;   border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;   padding:0pt 5.4pt 0pt 5.4pt"> ||<^  width="151px" style="width:113.4pt;border-top:none;border-left:   none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;   mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;   mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt"> ||
||<rowstyle="mso-yfti-irow:14"^  width="487px" style="width:365.4pt;border:solid windowtext 1.0pt;   border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;   padding:0pt 5.4pt 0pt 5.4pt">Number of   repeated segments for this file ||<^  width="151px" style="width:113.4pt;border-top:none;border-left:   none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;   mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;   mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt"> ||
||<rowstyle="mso-yfti-irow:15"^  width="487px" style="width:365.4pt;border:solid windowtext 1.0pt;   border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;   padding:0pt 5.4pt 0pt 5.4pt">     number of countries                                         ||<^  width="151px" style="width:113.4pt;border-top:none;border-left:   none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;   mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;   mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt">integer   3 ||
||<rowstyle="mso-yfti-irow:16"^  width="487px" style="width:365.4pt;border:solid windowtext 1.0pt;   border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;   padding:0pt 5.4pt 0pt 5.4pt">     number of traits (7)                                       ||<^  width="151px" style="width:113.4pt;border-top:none;border-left:   none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;   mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;   mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt">integer   3 ||
||<rowstyle="mso-yfti-irow:17"^  width="487px" style="width:365.4pt;border:solid windowtext 1.0pt;   border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;   padding:0pt 5.4pt 0pt 5.4pt"> ||<^  width="151px" style="width:113.4pt;border-top:none;border-left:   none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;   mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;   mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt"> ||
||<rowstyle="mso-yfti-irow:18"^  width="487px" style="width:365.4pt;border:solid windowtext 1.0pt;   border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;   padding:0pt 5.4pt 0pt 5.4pt">International proof   in each country (8) ||<^  width="151px" style="width:113.4pt;border-top:none;border-left:   none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;   mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;   mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt"> ||
||<rowstyle="mso-yfti-irow:19"^  width="487px" style="width:365.4pt;border:solid windowtext 1.0pt;   border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;   padding:0pt 5.4pt 0pt 5.4pt">     EMPTY SPACE                                                             ||<^  width="151px" style="width:113.4pt;border-top:none;border-left:   none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;   mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;   mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt">1 ||
||<rowstyle="mso-yfti-irow:20"^  width="487px" style="width:365.4pt;border:solid windowtext 1.0pt;   border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;   padding:0pt 5.4pt 0pt 5.4pt">     Country code                                                  ||<^  width="151px" style="width:113.4pt;border-top:none;border-left:   none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;   mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;   mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt">character 3 ||
||<rowstyle="mso-yfti-irow:21"^  width="487px" style="width:365.4pt;border:solid windowtext 1.0pt;   border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;   padding:0pt 5.4pt 0pt 5.4pt">          EMPTY SPACE                                                        ||<^  width="151px" style="width:113.4pt;border-top:none;border-left:   none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;   mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;   mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt">1 ||
||<rowstyle="mso-yfti-irow:22"^  width="487px" style="width:365.4pt;border:solid windowtext 1.0pt;   border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;   padding:0pt 5.4pt 0pt 5.4pt">            Genetic merit (international proof) definition(9)     ||<^  width="151px" style="width:113.4pt;border-top:none;border-left:   none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;   mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;   mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt">character 2 ||
||<rowstyle="mso-yfti-irow:23"^  width="487px" style="width:365.4pt;border:solid windowtext 1.0pt;   border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;   padding:0pt 5.4pt 0pt 5.4pt">          Number of herds                                        ||<^  width="151px" style="width:113.4pt;border-top:none;border-left:   none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;   mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;   mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt">integer   8 ||
||<rowstyle="mso-yfti-irow:24"^  width="487px" style="width:365.4pt;border:solid windowtext 1.0pt;   border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;   padding:0pt 5.4pt 0pt 5.4pt">          Number of daughters                                   ||<^  width="151px" style="width:113.4pt;border-top:none;border-left:   none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;   mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;   mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt">integer   8 ||
||<rowstyle="mso-yfti-irow:25"^  width="487px" style="width:365.4pt;border:solid windowtext 1.0pt;   border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;   padding:0pt 5.4pt 0pt 5.4pt">          Effective Daughter   Contribution                        ||<^  width="151px" style="width:113.4pt;border-top:none;border-left:   none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;   mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;   mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt">integer   8 ||
||<rowstyle="mso-yfti-irow:26"^  width="487px" style="width:365.4pt;border:solid windowtext 1.0pt;   border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;   padding:0pt 5.4pt 0pt 5.4pt">          EMPTY SPACE                                                        ||<^  width="151px" style="width:113.4pt;border-top:none;border-left:   none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;   mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;   mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt">1 ||
||<rowstyle="mso-yfti-irow:27"^  width="487px" style="width:365.4pt;border:solid windowtext 1.0pt;   border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;   padding:0pt 5.4pt 0pt 5.4pt">          Repeatability/Reliability (%)                          ||<^  width="151px" style="width:113.4pt;border-top:none;border-left:   none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;   mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;   mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt">integer   2 ||
||<rowstyle="mso-yfti-irow:28;mso-yfti-lastrow:yes"^  width="487px" style="width:365.4pt;border:solid windowtext 1.0pt;   border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;   padding:0pt 5.4pt 0pt 5.4pt">          International proof (x1000)  (10)                      ||<^  width="151px" style="width:113.4pt;border-top:none;border-left:   none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;   mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;   mso-border-alt:solid windowtext .5pt;padding:0pt 5.4pt 0pt 5.4pt">integer   10 ||
+.   BSW = Brown Swiss, GUE = Guernsey, HOL = Holsteins, JER = Jersey, RDC = Red Dairy Cattle, SIM = Simmental
-Line 35:
+Line 38:
+.   International identification in the country of first registration as known at the Interbull Centre; this is the first ID in new cross-reference list Xrefmult.*** found on the Interbull ftp site (where *** refer to breed).
-Line 36:
+Line 40:
+.   Country codes of Interbull members (in alphabetical order):
-Line 37:
+Line 42:
+ . ARG=Argentina; AUS=Australia; AUT=Austria; BEL=Belgium; BUL=Bulgaria;CAN=Canada;  HRV=Croatia; CZE=Czech Republic; [DFS:Denmark,Finland,Sweden]; DNK=Denmark; EST=Estonia; FIN=Finland; FRA=France;  [DEU=Germany,Austria]; DEU=Germany; GRC=Greece; HUN=Hungary; IRL=Ireland; ISR=Israel;  ITA=Italy; JPN=Japan; KOR=Korea; LVA=Lathvia; LTU=Lithuania;LUX=Luxembourg; MEX=Mexico; NLD=Netherlands; NZL=New Zealand;  NOR=Norway; POL=Poland; PRT=Portugal; SVK=Slovak Republic; SVN=Slovenia; ZAF=South African Republic; ESP=Spain; SWE=Sweden; CHE=Switzerland; GBR=United Kingdom; USA=United States of America.
-Line 38:
+Line 44:
+.   ID numbers:  Registration numbers, right justified, leading blanks as zeros.
-Line 39:
+Line 46:
+.   Y = Bull meets standard for official publication in at least one country.
-Line 40:
+Line 48:
+.   Number of traits:
-Line 41:
+Line 50:
+ . Production   i = 3 (1=mi, 2=fa, 3=pr            ) Udder health i = 2 (1=sc, 2=ma                  ) Longevity    i = 1 (1=dl                        ) Calving      i = 4 (1=dc, 2=mc, 3=ds, 4=ms      ) Fertility    i = 5 (1=ch, 2=cy, 3=c1, 4=c2, 5=it) Workability  i = 2 (1=md, 2=te                  ) Conformation BSW             i= 22 (1=sta 2=cwi 3=bde 4=ang 5=ran 6=rwi 7=rls 8=fan 9=hde 10=fua 11=ruh 12=ruw 13=usu 14=ude 15=ftp 16=ftl 17=rtp 18=ocs 19=ous 20=ofl 21=loc 22=bcs) RDC HOL JER GUE i= 21 (1=sta 2=cwi 3=bde 4=ang 5=ran 6=rwi 7=rls 8=rlr 9=fan 10=fua 11=ruh 12=usu 13=ude 14=ftp 15=ftl 16=rtp 17=ocs 18=ous 19=ofl 20=loc 21=bcs)
-Line 42:
+Line 52:
+.   Repeat as necessary depending on number of countries;
-Line 43:
+Line 54:
+.   B+ = Breeding Value, high values desirable; B- = Breeding Value, low values desirable; T+ = Transmitting Ability, high values desirable; T- = Transmitting Ability, low values desirable.
-Line 44:
+Line 56:
-Describe public/itb files here.
+.  International proof expressed as either estimated B+, B-, T+ or T-, in base and unit of each country; proofs are multiplied by 1000 to include 3 decimals; missing values are represented by 999999.