With any type of worksheet you have created, the clip lines or lots can be changed, added or deleted. 

To change a lot, click on the 'Edit' button, and the following is displayed for that lot.

Once you have made changes to the lot, click on the 'Apply' button. The worksheet is then ready to be priced.

Please note that if the 'Apply' button is not pressed then the 'Calculate wool price' function will not work.

To add a lot, click on the 'Add another lot' button, and a blank lot will be added to the top of the worksheet.

To delete a lot, click on the 'Delete' button and that lot will be removed from the worksheet.

To price the worksheet:

• Choose the region in which your sale centre resides.
• Choose your price period for your price calculation, e.g. daily, 1 month, 3 months, 12 months or longer.
• Click on the 'Calculate wool price' button to price your lots. More information.

Start a blank worksheet.

Note that placing your mouse over any heading or data will give you information about that field.

Allowable data ranges

Any data entered outside these ranges will be regarded as an error, and will prevent your worksheet from being priced correctly.

• Brand - minimum of 3 characters
• Description - at least 1 character
• Bales - 1 to 999
• Greasy net kg - 1 kg to 99,999 kg
• Micron - 10 to 40 micron
• Vegetable Matter - 0.1% to 30%.  Note that the leading zero must be specified.
• Yield - 30% to 95%
• Length (mm) - 0 mm to 200 mm. Should be specified unless a lock (MZ) or crutching (MC) type.
• Staple Strength (Nkt) - 0 Nkt to 70 Nkt. Should be specified unless a lock (MZ) or crutching (MC) type.
• Position of break (POB) % of mid-breaks - 0% to 100%. Should be specified unless a lock (MZ) or crutching (MC) type.
• AWEX ID - mandatory from any on the drop-down list
• Qualifier 1 and 2 - optional from any on the drop-down list

Errors

If a lot has missing (blank) or incorrect data entered, an error message box will be displayed, along with a question mark next to the incorrect item. Place your mouse over the question mark to view details of the error.

Note that a zero value for a wool characteristic is not shown as an error on a new worksheet but may result in a wrong price if not valid for that wool type.