The macadamia sorting calculator is a tool that has been developed to assist you as a grower to make decisions regarding whether it is financially worth sorting macadamia nut in shell (NIS) or consigning directly to a processor. This version of the calculator has a price table embedded, so the price pre sort and post sort are automatically generated.
There are 2 files that need to be downloaded below:
1. The instruction file that outlines the method that is used and the factors impacting upon the accuracy of the results. CLICK HERE TO DOWNLOAD
2. The macadamia sorting calculator which is an excel® based spreadsheet which is used to calculate the estimated quality and value of sorting. CLICK HERE TO DOWNLOAD
The information required to use the calculator is the total estimated kernel recovery of the nut sample to be sorted, the average time taken to sort a tonne of NIS, a payment table from your processor and a sample of NIS that you will simulate a sorting with.
Technical Requirements
The macadamia sorting calculator requires Microsoft Excel® (testing has been performed on Excel version 97 and up on various Microsoft operating systems).
The software has calculated cells which are locked. Before carrying out any calculations it is best to check that the input information cells are clear and you are entering new figures. If previous figures are left in the input cells the calculations will not be accurate for the new sample analysed.
The original sorting calculator software has kindly been provided by Industry and Investment NSW (formerly the NSW Department of Primary Industries) and MPC acknowledges their assistance in this regard.
