Difference between revisions of "Entering test results"

From SAGMILLING.COM
Jump to: navigation, search
(Test Types)
(Queries Table)
Line 33: Line 33:
   
 
===Queries Table===
 
===Queries Table===
[[file:Testwork-queries.png|thumb|Screenshot showing portion of a large query 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 "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 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 "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 "query" table can not be directly manipulated. The list is generated automatically by combining individual test results by matching the sample name and program fields.
+
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.
   
 
===Laboratory names===
 
===Laboratory names===

Revision as of 18:39, 3 January 2013

Entering Test Results

Screenshot of a blank newly created project

A newly created project will require entry of test results before circuit models may be created and run. To enter test results, click the "See Testwork results" link.

The testwork page consists of a series of links to the individual pages for storing different types of test results. It will first show a summary of all the results that have been entered — but since no test results are entered, the summary says "No results found.".

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:

  • Sample: Sample name that is unique. 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.
  • 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.

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.

There are three ways to enter a test result:

  1. entering on test at a time by filling in the fields for a "single test result";
  2. cutting & pasting a table of values from a spreadsheet in a "batch";
  3. cloning an existing test result (won't be available until some values are entered that can be cloned).

Test Types

File:Testwork-NoResults.png
Screenshot of testwork table with no values entered

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

File:Testwork-Summary.png
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.

Queries Table

File:Testwork-queries.png
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 "query" 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 "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.

Laboratory names

The laboratory where a test was conducted can be recorded with each sample. This is generally used for quality-control duplicate purposes in large testwork programs.

The list of laboratory names is pre-populated with a number of laboratories whose results have been used in model calibration during the development of SAGMILLING.COM. The listing of labs is accessible via the "+" button at the top of every set of testwork. This "+" button option "Show lab listing" brings up the list.

The listing can be modified the same as any testwork value. Clicking the "id" button will allow a row to be edited, and new entries can be added using the "Enter New Result" link at the bottom of the list.