Testwork: Aggregating samples

From SAGMILLING.COM
Revision as of 17:24, 22 April 2015 by Alex Doll (talk | contribs) (Alex Doll moved page Testwork: Queries to Testwork: Aggregating samples)
Jump to: navigation, search

Model Results Table

The list of samples that run through a circuit model is shown in any "model results" table. This is the list of samples that contain all of the necessary test results required to satisfy a particular model. For example, the "results" table for a Bond/Barratt model will show only those samples that have a crushing work index (WiC), Bond rod mill work index (WiRM) and a Bond ball mill work index (WiBM). Any sample that lacks any of these three values can not be run in the model and will not appear in the listing.

The samples that appear in the "results" table can not be directly manipulated. The list is generated automatically by combining individual test results by matching the sample name and program fields. If a default value for a test result has been entered for a Program, then all samples of that program are deemed to have that default value for the test.

Example: Aggregation of data

The example data set from Los Bronces (from published papers by Oestreicher & Spollen, SAG 2006 and Becerra & Amelunxen, Procemin 2012) is summarized below. It contains samples that have been subjected to a variety of tests including the Bond work index series and the drop weight tests.

Sample WiBM WiRM WiC A×b
Los Bronces A 13.3 9.4 8.97 55.4
Los Bronces B 14.9 11.2 8.83 44.4
Los Bronces C 14.5 13.1 9.46 33
LB 25th percentile 15.6 14.7 35.7
LB 75th percentile 17.4 18.5 27.1
LB average 16.5 16.7 32.3
LB maximum 22 24.6 22.8
LB median 16.5 16.7 30
LB minimum 12.2 11.9 50.9

A Bond/Barratt SAG circuit model would generate a query table that returns only samples Los Bronces A, Los Bronces B and Los Bronces C. The other samples are missing one of the required test results (the crushing work index, WiC), so those samples can not be run in the standard Bond/Barratt SAG circuit model.

If the Program settings have a default value for a missing test results, the WiC in this case, the requirement to have a crushing work index value is relaxed and the default value is used in the calculation instead.