TABLE OF CONTENTS These spreadsheets are accessible by going to the Minerals Engineering International website at http://www.min-eng.com and following the prompts. The following notes describe the functionality of each spreadsheet. The spreadsheet names are the same as those used for the equivalent basic computer programs in previous editions of the book.
The function GYMass() calculates the minimum practical sampling weights required at each stage of sampling. The mass given is that obtained by Gy's formula multiplied by a safety factor of 2. For routine sampling, a confidence interval of 95% in the results would be acceptable; but for research purposes, or where greater sampling accuracy is required, 99% level of confidence would be required.
The function GYError() will calculate the maximum relative error for a sample mass from each stage of sampling, ie the fundamental errors incurred after a sample has been taken. The calculated relative error is that obtained by Gy's formula.
RecVar calculates the error associated with the two-product recovery formula for the assay recovery. Enter the Feed, Concentrate, and Tail assays and the relative error for the Feed, Concentrate, and Tail assays in the highlighted cells. The spreadsheet returns the calculated assay recovery, and the variance and standard deviation of the calculated assay recovery.
MassVar calculates the error associated with the two-product recovery formula for the mass recovery. Enter the Feed, Concentrate,...
