Woolcheque uses worksheets to store all objective (test results) and subjective (AWEX-ID) information about a wool clip. The worksheet is essentially a table with the lines in the wool clip shown horizontally in rows, similar to a wool broker's account sales. Lines of wool or lots can be added, edited or deleted to build a full representation of the clip, and the whole worksheet can be saved and accessed it a later date.
To collect the information needed by Woolcheque, find your brand and wool classer stencil number. The stencil number is on the wool classers' specification, or contact your wool broker for this information.
Otherwise find copy of your account sales or similar document and manually enter the test results and AWEX-ID for each lot.
Follow these simple steps to use Woolcheque.
Collect the information needed by Woolcheque.
When finding your previous lots sold at auction, you will need to know your brand and wool classer stencil number. You can find the stencil number on the wool classers' specification, or else contact your wool broker for this information.
Otherwise you will need a copy of your account sales or similar document so that you can enter the test results and AWEX-ID for each lot.
Create a worksheet
Choose one of the following options to create a worksheet.
- Create a new worksheet by retrieving your lots from the auction database
Create your worksheet by searching the 3 year auction database for one of your previous clips using brand and wool classer stencil number. Then simply edit your lots to reflect any expected changes for your upcoming wool clip.
- Create a new worksheet and enter your clip lines manually
Enter information manually into a worksheet about each line of wool or lot allowing you to calculate prices for your wool.
- Open a previously saved worksheet
Upload a previously saved worksheet from your computer to reprice your wool.
Edit the worksheet (optional).
Once you have created your worksheet, you may add, edit or delete specific lots as required.
Price the worksheet
Choose the daily or historical price period required, then click on the 'Calculate wool price' button to display the clean, greasy and estimated dollar value for each lot. Averages and totals are displayed at the bottom.
Please note in some instances, prices cannot be calculated. These lots will show a zero value in red. Place your mouse value over the red zero to display the reason why that lot cannot be priced.
Analyse your prices further (optional)
Once your prices have been calculated, a variety of tools are available to further analyse your clip. These include:
- Similar lots - for each lot, this tool lets you confirm Woolcheque's estimated prices by showing you a listing of similar lots that have recently sold at auction. The lot listing is filtered to only show wools that have similar specifications to your own wool.
- Price charts - this displays your calculated daily prices in a graph showing historical prices over the previous 12 month period.
- Show Price Calculation - displays any premiums or discounts that apply, allowing you to see how specific wool characteristics affect the price received for your wool.
Save your worksheet for later use (optional)
You may save your worksheet for later use using a special, AWI only, format. This is very useful if you wish to reprice your wool later, or save a partially completed worksheet for further editing.
Alternatively, you can save a worksheet for export to Microsoft Excel or other software products.
Price Your Wool
Woolcheque is brought to you by Australian Wool Innovation in collaboration with Australian Wool Exchange (AWEX). Woolcheque uses a worksheet to store information about each line of wool or lot in your clip. The active worksheet is used when pricing your wool.
Contact UsSupport for Woolcheque is provided by the Australian Wool Exchange (AWEX), under contract to AWI
Requests for assistance or feedback about this website, its content and functionality are welcome via:
- Email to AWEX on email@example.com
- The Woolcheque Help Line at AWEX Sydney. Call 02 9428 6136 between the 8:30 am - 5:30 pm AEST.
- Mail addressed to:
Australian Wool Exchange
PO Box 649
LANE COVE NSW 1595