Difference between revisions of "Testwork: Aggregating samples"
m (→Queries Table) |
(→Example: Aggregation of data) |
||
| (8 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
| − | == |
+ | ==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 [[Testwork: Crushing work index|crushing work index]] (Wi<sub>C</sub>), [[Testwork: Bond rod mill work index|Bond rod mill work index]] (Wi<sub>RM</sub>) and a [[Testwork: Bond ball mill work index|Bond ball mill work index]] (Wi<sub>BM</sub>). Any sample that lacks any of these three values can not be run in the model and will not appear in the listing. |
||
| − | [[file:Testwork-queries.png|thumb|Screenshot showing portion of a large queries table]] |
||
| − | The list of samples that run through a circuit model is shown in the "Queries" table. This is the list of samples that contain all of the necessary test results required to satisfy a particular model. For example, the "queries" table for a Bond/Barratt model will show only those samples that have a [[Testwork: Crushing work index|crushing work index]] (WiC), [[Testwork: Bond rod mill work index|Bond rod mill work index]] (WiRM) and a [[Testwork: Bond ball mill work index|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 " |
+ | 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. |
| + | |||
| + | [[file:Testwork_defaults.png|Testwork program editing dialogue|frame|alt=Screenshot]] |
||
| + | A default value can be entered in the testwork program editing dialogue box (see screenshot). If a sample is missing a particular test, then any default value specified for that program will be given for that test. This allows data sets that are missing a required test to be used in models with the default test value. |
||
| + | |||
| + | ===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. |
||
| + | {| |
||
| + | | align="center" style="background:#f0f0f0;"|'''Sample''' |
||
| + | | align="center" style="background:#f0f0f0;"|'''Wi<sub>BM</sub>''' |
||
| + | | align="center" style="background:#f0f0f0;"|'''Wi<sub>RM</sub>''' |
||
| + | | align="center" style="background:#f0f0f0;"|'''Wi<sub>C</sub>''' |
||
| + | | align="center" style="background:#f0f0f0;"|'''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 [[Model:BondModel|Bond/Barratt SAG circuit model]] would generate a result 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, Wi<sub>C</sub>), so these are not available to the model. |
||
| + | |||
| + | In order to use those samples missing the Wi<sub>C</sub> in the standard Bond/Barratt SAG circuit model, the testwork program can be edited to include a default Wi<sub>C</sub> value (10 is used in the example screenshot). This gives a default value for a missing test results, the Wi<sub>C</sub> in this case. This will satisfy the requirement to have a crushing work index value for the remaining samples, ''LB 25th'' to ''LB minimum'', so all may now be used in the calculation. |
||
Latest revision as of 20:55, 19 August 2017
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.
A default value can be entered in the testwork program editing dialogue box (see screenshot). If a sample is missing a particular test, then any default value specified for that program will be given for that test. This allows data sets that are missing a required test to be used in models with the default test value.
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 result 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 these are not available to the model.
In order to use those samples missing the WiC in the standard Bond/Barratt SAG circuit model, the testwork program can be edited to include a default WiC value (10 is used in the example screenshot). This gives a default value for a missing test results, the WiC in this case. This will satisfy the requirement to have a crushing work index value for the remaining samples, LB 25th to LB minimum, so all may now be used in the calculation.
