Difference between revisions of "Entering test results"
(→Entering a batch of test results) |
|||
| (6 intermediate revisions by the same user not shown) | |||
| Line 2: | Line 2: | ||
[[Category:Testwork]] |
[[Category:Testwork]] |
||
==Access Level== |
==Access Level== |
||
| − | Anyone with 'user' access level <u>and</u> who has been set by an administrator to have 'read/write' access to a project will be able to enter test results for that project. |
+ | Anyone with 'user' access level (privileges) <u>and</u> who has been set by an administrator to have 'read/write' access to a project will be able to enter test results for that project. |
Users with 'read' access will be able to view test results, but not edit them or add new results. Contact your administrator if you need access to edit or add test results. |
Users with 'read' access will be able to view test results, but not edit them or add new results. Contact your administrator if you need access to edit or add test results. |
||
| − | |||
==Entering Test Results== |
==Entering Test Results== |
||
| Line 12: | Line 11: | ||
A newly created project will require entry of test results before circuit models may be created and run. To enter test results, click the "Testwork" link. |
A newly created project will require entry of test results before circuit models may be created and run. To enter test results, click the "Testwork" link. |
||
| − | The testwork page consists of a series of links to the test pages for storing different types of test results. It will first show a summary of all the test programs and available types of test results that have been entered — but since no test results are entered, the list will be blank |
+ | The testwork page consists of a series of links to the test pages for storing different types of test results. It will first show a summary of all the test programs and available types of test results that have been entered — but since no test results are entered, the list will be blank. |
===General Concepts=== |
===General Concepts=== |
||
The testing program should collect a series of samples corresponding to a particular interval of drill core, mine bench or some other reasonably uniform composite. Each sample will then have a series of tests conducted on it depending on which model (or models) are intended to be run. In order to properly index and organize the databases, each sample must have the following: |
The testing program should collect a series of samples corresponding to a particular interval of drill core, mine bench or some other reasonably uniform composite. Each sample will then have a series of tests conducted on it depending on which model (or models) are intended to be run. In order to properly index and organize the databases, each sample must have the following: |
||
[[File:Testwork-NewProgram.png|thumb|Screenshot of entering a new testwork Program]] |
[[File:Testwork-NewProgram.png|thumb|Screenshot of entering a new testwork Program]] |
||
| − | * '''Program''': Used to group tests that were all part of the same batch of testing. Often this is denoted by the date of testing, lab name or part of the orebody that was being examined. |
+ | * '''[[Testwork Program|Program]]''': Used to group tests that were all part of the same batch of testing. Often this is denoted by the date of testing, lab name or part of the orebody that was being examined. Example Program names are '2013', 'west extension' or 'infill'. |
| − | [[File:Testwork- |
+ | [[File:Testwork-NewSample.png|thumb|Screenshot of dialogue to create new samples]] |
* '''Sample''': Sample name that is unique within a project. This can be a number, a drillhole number:from-to interval, or any other unique identifier. The same sample name will be used in all the tests in order to tell the database that "this is the same sample" when it goes looking to gather information. |
* '''Sample''': Sample name that is unique within a project. This can be a number, a drillhole number:from-to interval, or any other unique identifier. The same sample name will be used in all the tests in order to tell the database that "this is the same sample" when it goes looking to gather information. |
||
| + | The [[How to use the Litho table|Sample names must be declared]] before test results may be entered for them. |
||
| − | The database will only match samples (across the different tests) if both the '''Sample''' and '''Program''' entries are ''identical''. Enter these two values with care, otherwise the database won't be able to gather together the required tests for modelling, and samples will be missed from any calculations. |
||
If the database finds two different test results (for the same test) with the same '''Sample''' name, then the two test results are merged by arithmetic averaging. For example, if two ball mill work index tests at different closing screen sizes were performed on the same sample, and entered with the identical sample name, then the database will average the work index (for modelling) and will also average the test F80, gpr and P80 for display. |
If the database finds two different test results (for the same test) with the same '''Sample''' name, then the two test results are merged by arithmetic averaging. For example, if two ball mill work index tests at different closing screen sizes were performed on the same sample, and entered with the identical sample name, then the database will average the work index (for modelling) and will also average the test F80, gpr and P80 for display. |
||
| + | ===Entering a batch of test results=== |
||
| − | There are three ways to enter a test result: |
||
| + | * download the [https://www.sagmilling.com/articles/19/view/?s=1 test template spreadsheet] |
||
| − | # entering one test at a time by filling in the fields for a "[[Testwork: Single result entry|single test result]]"; |
||
| + | or |
||
| − | # cutting & pasting a table of values from a spreadsheet in a "[[testwork: Batch entry|batch]]"; |
||
| + | * using a spreadsheet provided by you laboratory, insert a row above the table of results and insert the '''field names''' for a particular test. |
||
| − | # cloning an existing test result (won't be available until some values are entered that can be cloned). |
||
| + | then |
||
| + | * define the [[How to use the Litho table|sample names]] to be entered, |
||
| + | * cut & paste a table of values from the spreadsheet in a "[[testwork: Batch entry|batch]]"; |
||
===Test Types=== |
===Test Types=== |
||
| Line 36: | Line 38: | ||
===Summary table, "All" results=== |
===Summary table, "All" results=== |
||
| + | The summary table of "All" results shows the listing of significant test results against the sample names. This provides a quick reference to check which samples contain sufficient test results to operate a model. |
||
| − | [[file:Testwork-Summary.png|thumb|Screenshot of example listing of test values available for different samples]] |
||
| − | The summary table of "All" results shows the listing of significant test results against the sample names. This provides a quick reference to check which samples contain sufficient test results to operate a model or to check for misspellings of sample names or programs. In order for a sample to properly match across the different tests, the sample name must be spelled identically in all the different testwork tables. |
||
This summary table is automatically generated and can not be manually edited. In order to adjust a value in this table, it is necessary to modify the individual testwork pages. |
This summary table is automatically generated and can not be manually edited. In order to adjust a value in this table, it is necessary to modify the individual testwork pages. |
||
| − | |||
| − | ===Queries Table=== |
||
| − | [[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 "[[Testwork: Queries|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 "query" 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 "queries" table can not be directly manipulated. The list is generated automatically by combining individual test results by matching the sample name and program fields. |
||
Latest revision as of 20:58, 19 August 2017
Contents
Access Level
Anyone with 'user' access level (privileges) and who has been set by an administrator to have 'read/write' access to a project will be able to enter test results for that project.
Users with 'read' access will be able to view test results, but not edit them or add new results. Contact your administrator if you need access to edit or add test results.
Entering Test Results
A newly created project will require entry of test results before circuit models may be created and run. To enter test results, click the "Testwork" link.
The testwork page consists of a series of links to the test pages for storing different types of test results. It will first show a summary of all the test programs and available types of test results that have been entered — but since no test results are entered, the list will be blank.
General Concepts
The testing program should collect a series of samples corresponding to a particular interval of drill core, mine bench or some other reasonably uniform composite. Each sample will then have a series of tests conducted on it depending on which model (or models) are intended to be run. In order to properly index and organize the databases, each sample must have the following:
- Program: Used to group tests that were all part of the same batch of testing. Often this is denoted by the date of testing, lab name or part of the orebody that was being examined. Example Program names are '2013', 'west extension' or 'infill'.
- Sample: Sample name that is unique within a project. This can be a number, a drillhole number:from-to interval, or any other unique identifier. The same sample name will be used in all the tests in order to tell the database that "this is the same sample" when it goes looking to gather information.
The Sample names must be declared before test results may be entered for them.
If the database finds two different test results (for the same test) with the same Sample name, then the two test results are merged by arithmetic averaging. For example, if two ball mill work index tests at different closing screen sizes were performed on the same sample, and entered with the identical sample name, then the database will average the work index (for modelling) and will also average the test F80, gpr and P80 for display.
Entering a batch of test results
- download the test template spreadsheet
or
- using a spreadsheet provided by you laboratory, insert a row above the table of results and insert the field names for a particular test.
then
- define the sample names to be entered,
- cut & paste a table of values from the spreadsheet in a "batch";
Test Types
Click on the link of the type of test that you want to enter date for. The abbreviations (on the list of links) for the different tests are:
Laboratory tests of grindability, impact, abrasion and compression.
- wibm: Bond ball mill work index (sometimes called "BWI")
- wirm: Bond rod mill work index (sometimes called "RWI")
- wic: Bond crushing work index (low energy impact, sometimes called "LEIT", "IWI" or "CWI")
- dwt: Drop Weight tests, SMC Test ® of SMCC Pty Ltd. and JK DWT (values stored include A×b and DWI)
- sgi: SAG Grindbility Index (also SAG Power Index™ or SPI™ of SGS Mineral Services; originally called a "Starkey SAG test"Starkey et al, 1994)
- ai: Bond abrasion index
- ucs: Unconfined Compressive Strength, a detailed geotechnical test conducted on drill core
- pli: Point Load Index, a field-test conducted on drill core
Geological tables, used for organizing and partitioning samples, or as proxies for test results.
- litho: Lithological, alteration and sample acquisition data, including drill hole intervals
Automatically generated tables. Assembled by the program out of the tests entered into the laboratory test tables.
- Testwork summary: Summarizes all the test results entered for a project, including samples with inadequate information for modelling.
Extra table, accessible to your administrators
- Laboratory Listing: Listing of laboratories and their colour schemes for plotting results.
Summary table, "All" results
The summary table of "All" results shows the listing of significant test results against the sample names. This provides a quick reference to check which samples contain sufficient test results to operate a model.
This summary table is automatically generated and can not be manually edited. In order to adjust a value in this table, it is necessary to modify the individual testwork pages.
