Data File Formats used in Fleece Measurement
As part of our standard Fleece Measurement Testing service, AWTA Ltd can provide the test data via Email as a file attachment. This is provided free of charge to all customers who write their Email address details on the Fleece Measurement Service Request form.
When the testing is completed, a paper copy of the results is posted and a data file emailed to the requestor. The email will have an attachment file name similar to MELFT6000195807.CSV. The first 3 characters indicate the AWTA Laboratory that conducted the testing, either “MEL" for Melbourne, “SYD” for Sydney or “FRE” for Fremantle. The next two numbers represent the type of testing requested, such that “60” contains Laserscan data (and Yield if requested) and “05” contains Length/Strength and Colour data. The last 8 numbers represent the unique AWTA Ltd Test Number under which the measurements were collated and reported (The Test Number should be quoted when making any inquiries).
The content of theses files is dependent on the type of testing requested. Normally the data file will contain all the raw test results that are printed on the accompanying paper report. Other measurements such as Length and Strength or Clean Colour are included in a second file. The data is provided as a simple ASCII text file in Comma Separated (CSV) format which can be easily imported into a spreadsheet program such as Microsoft Excel, most database applications including Ms Access or dBase, and commercial sheep breeding programs such as "Top Stud".
|
Field |
Description |
Size |
Data Type |
|
TAG-ID |
Tag Identification |
15 |
alpha numeric |
|
GN |
Group Number |
6 |
numeric |
|
MICRON |
Laserscan Fibre Diameter |
3 |
numeric-1 decimal |
|
SD |
Standard Deviation of Diameter |
4 |
numeric-1 decimal |
|
CV |
Coefficient of Variation of Diameter |
3 |
numeric-1 decimal |
|
COMF.FACTOR |
Comfort Factor |
4 |
numeric-1 decimal |
|
CURV |
Fibre Curvature |
3 |
numeric |
|
S/FINENESS |
Spinning Fineness |
2 |
numeric-1 decimal |
In addition, where Yield measurement is also requested the file will contain a YIELD category between “GN” and “MICRON” with the following definition:
|
YIELD |
Washing Yield @ 16% regain |
3 |
numeric-1 decimal |
Where Length and Strength measurements are requested (which must be done in conjunction with a Yield test in order to arrive at the correct Staple Strength result), this data is provided in the following format:
|
Field |
Description |
Size |
Data Type |
|
TAG-ID |
Tag Identification |
15 |
alpha numeric |
|
GN |
Group Number |
6 |
numeric |
|
YIELD |
Washing Yield @ 16% regain |
3 |
numeric-1 decimal |
|
MICRON |
Laserscan Mean Fibre Diameter |
3 |
numeric-1 decimal |
|
DEV |
Deviation from the Group’s Average Micron |
3 |
numeric-1 decimal |
|
SL |
Mean Staple Length |
3 |
numeric |
|
SS |
Mean Staple Strength |
3 |
numeric |
|
TIP |
% of Staples Broken at the Tip |
3 |
numeric |
|
MID |
% of Staples Broken in the Middle |
3 |
numeric |
|
BSE |
% of Staples Broken at the Base |
3 |
numeric |
|
SD |
Standard Deviation of Fibre Diameter |
4 |
numeric-1 decimal |
|
CV |
Coefficient of Variation of Fibre Diameter |
3 |
numeric-1 decimal |
|
COMF.FACTOR |
Comfort Factor |
4 |
numeric-1 decimal |
|
CURV |
Fibre Curvature |
3 |
numeric |
|
S/FINENESS |
Spinning Fineness |
2 |
numeric-1 decimal |
|
AVERAGES |
Average Yield, Micron, SS,SL,
Tip,Mid,Base of the Group |
|
|
Further information on this service can be found on our website at
http://www.awta.com.au/Our Services/Fleece Measurement .
Alternatively contact one of our Raw Wool Laboratories to find out more (see here).