Clip worksheets

Woolcheque uses worksheets to store all objective (test results) and subjective (AWEX-ID) information about your wool clip. The worksheet is essentially a table with the lines in your 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 your clip, and the whole worksheet can be saved so that you can access it a later date.

Navigating through this web site

Clicking on any underlined words will take you to another page or function within Woolcheque. You may also use the links on the left hand side or bottom to go to a specific page.

To go back to a previous page, either use the Back button on your browser, or click on one of the 'You are here' links. If you go back too far, you may lose the information entered on your worksheet. If so, use the Forward button on your browser to return to your worksheet.

Using Woolcheque

Follow these simple steps to use Woolcheque. Click on the underlined links for more detailed information on each step.

Step 1. 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.

Step 2. 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. More information.
• 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. More information.
• Open a previously saved worksheet
  Upload a previously saved worksheet from your computer to reprice your wool. More information.

Step 3. Edit the worksheet (optional).

Once you have created your worksheet, you may add, edit or delete specific lots as required. More information.

Step 4. 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. More information.

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.

Step 5. 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.

Step 6. 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. More information.

Alternatively, you can save a worksheet for export to Microsoft Excel or other software products. More information.

Commence creating your worksheet and pricing your wool.