Testwork: Aggregating samples - Revision history

Alex Doll: /* Example: Aggregation of data */

2017-08-19T19:55:35Z

Example: Aggregation of data

← Older revision		Revision as of 19:55, 19 August 2017
Line 36:		Line 36:
	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.		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, ~~and~~ the requirement to have a crushing work index value ~~is satisfied and~~ the samples ''LB 25th'' to ''LB minimum'' may now be used in the calculation.		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.

Alex Doll: /* Example: Aggregation of data */

2015-04-22T16:43:59Z

Example: Aggregation of data

← Older revision		Revision as of 16:43, 22 April 2015
Line 34:		Line 34:
	\| LB minimum\|\|12.2\|\|11.9\|\|\|\|50.9		\| LB minimum\|\|12.2\|\|11.9\|\|\|\|50.9
	\|}		\|}
	A [[Model:BondModel\|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, Wi<sub>C</sub>), so these are not available to the model.		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, and the requirement to have a crushing work index value is satisfied and the samples ''LB 25th'' to ''LB minimum'' may now be used in the calculation.		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, and the requirement to have a crushing work index value is satisfied and the samples ''LB 25th'' to ''LB minimum'' may now be used in the calculation.

Alex Doll: /* Model Results Table */

2015-04-22T16:43:18Z

Model Results Table

← Older revision		Revision as of 16:43, 22 April 2015
Line 2:		Line 2:
	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.		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.

	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.~~		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===		===Example: Aggregation of data===
Line 31:		Line 34:
	\| LB minimum\|\|12.2\|\|11.9\|\|\|\|50.9		\| LB minimum\|\|12.2\|\|11.9\|\|\|\|50.9
	\|}		\|}
	A [[Model:BondModel\|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, Wi<sub>C</sub>), so ~~those~~ ~~samples can~~ not be ~~run in~~ the ~~standard Bond/Barratt SAG circuit~~ model.		A [[Model:BondModel\|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, Wi<sub>C</sub>), so these are not available to the model.

	If the ~~Program~~ ~~settings~~ ~~have~~ a default value for a missing test results, the Wi<sub>C</sub> in this case, the requirement to have a crushing work index value is ~~relaxed~~ and the ~~default~~ ~~value~~ is used in the calculation ~~instead~~.		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, and the requirement to have a crushing work index value is satisfied and the samples ''LB 25th'' to ''LB minimum'' may now be used in the calculation.

Alex Doll: Alex Doll moved page Testwork: Queries to Testwork: Aggregating samples

2015-04-22T16:24:44Z

Alex Doll moved page Testwork: Queries to Testwork: Aggregating samples

← Older revision

Revision as of 16:24, 22 April 2015

Alex Doll at 13:07, 23 April 2014

2014-04-23T13:07:58Z

← Older revision		Revision as of 13:07, 23 April 2014
Line 31:		Line 31:
	\| LB minimum\|\|12.2\|\|11.9\|\|\|\|50.9		\| LB minimum\|\|12.2\|\|11.9\|\|\|\|50.9
	\|}		\|}
	A Bond/Barratt 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, Wi<sub>C</sub>), so those samples can not be run in the standard Bond/Barratt ~~model~~ ~~contained~~ in a ~~'bond' folder (however, they can be run if the Program settings have a default value for Wi<sub>C</sub> which relaxes the requirement to have a crushing work index value).~~		A [[Model:BondModel\|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, Wi<sub>C</sub>), 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 Wi<sub>C</sub> in this case, the requirement to have a crushing work index value is relaxed and the default value is used in the calculation instead.

Alex Doll: /* Requirements for matching results */

2014-04-23T12:36:30Z

Requirements for matching results

← Older revision		Revision as of 12:36, 23 April 2014
Line 3:		Line 3:

	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.		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.

	===Requirements for matching results===
	In order for a circuit model to correctly associate test results (to realize that "these are actually different tests on the same sample"), the following criteria must be satisfied:
	* The test results must be part of the same project
	* The `Sample` fields must be identical ("Composite 1" is not the same as "Composite No.1" or "composite 1")
	* The `[[Program]]` fields must be identical ("SAG feed" of Program "2010 survey" is not the same sample as "SAG feed" of program "2011 survey").

	===Example: Aggregation of data===		===Example: Aggregation of data===

Alex Doll: /* Queries Table */

2014-01-02T22:09:51Z

Queries Table

← Older revision		Revision as of 22:09, 2 January 2014
Line 1:		Line 1:
	==~~Queries~~ Table==		==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 ~~(contained in a 'bond' Project folder)~~ 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.

	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. ~~The~~ ~~matching~~ ~~algorithm~~ is ~~controlled~~ by ~~the~~ ~~'folder' that~~ has been ~~selected~~ for ~~this~~ [[~~Project~~]].		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.

	===Requirements for matching results===		===Requirements for matching results===
	In order for a ~~Project~~ to correctly associate test results (to realize that "these are actually different tests on the same sample"), the following criteria must be satisfied:		In order for a circuit model to correctly associate test results (to realize that "these are actually different tests on the same sample"), the following criteria must be satisfied:
	* The test results must be part of the same project ~~(having the same `ProjNum`)~~		* The test results must be part of the same project
	* The `Sample` fields must be identical ("Composite 1" is not the same as "Composite No.1" or "composite 1")		* The `Sample` fields must be identical ("Composite 1" is not the same as "Composite No.1" or "composite 1")
	* The `Program` fields must be identical ("SAG feed" of Program "2010 survey" is not the same sample as "SAG feed" of program "2011 survey").		* The `[[Program]]` fields must be identical ("SAG feed" of Program "2010 survey" is not the same sample as "SAG feed" of program "2011 survey").

	If a sample name is misspelled in one of the testwork tables, then that sample will not match the name in the other tables and that sample will not appear in the Query table. ''(Hint: you can see mismatched sample names by scrolling through the -All- table in testwork.)''

	===Example: Aggregation of data===		===Example: Aggregation of data===
Line 40:		Line 37:
	\| LB minimum\|\|12.2\|\|11.9\|\|\|\|50.9		\| LB minimum\|\|12.2\|\|11.9\|\|\|\|50.9
	\|}		\|}
	A Bond/Barratt 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, Wi<sub>C</sub>), so those samples can not be run in the standard Bond/Barratt model contained in a 'bond' folder (however, they can be run in a ~~'bond_SetWiC'~~ ~~folder~~ which relaxes the requirement to have a crushing work index value).		A Bond/Barratt 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, Wi<sub>C</sub>), so those samples can not be run in the standard Bond/Barratt model contained in a 'bond' folder (however, they can be run if the Program settings have a default value for Wi<sub>C</sub> which relaxes the requirement to have a crushing work index value).

Alex Doll: /* Queries Table */

2013-04-13T18:26:42Z

Queries Table

← Older revision		Revision as of 18:26, 13 April 2013
Line 1:		Line 1:
	==Queries Table==		==Queries Table==
	[[file:Testwork-queries.png\|thumb\|Screenshot showing portion of a large 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 "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]] (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.		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 (contained in a 'bond' Project folder) 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.

	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.		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. The matching algorithm is controlled by the 'folder' that has been selected for this [[Project]].

			===Requirements for matching results===
			In order for a Project to correctly associate test results (to realize that "these are actually different tests on the same sample"), the following criteria must be satisfied:
			* The test results must be part of the same project (having the same `ProjNum`)
			* The `Sample` fields must be identical ("Composite 1" is not the same as "Composite No.1" or "composite 1")
			* The `Program` fields must be identical ("SAG feed" of Program "2010 survey" is not the same sample as "SAG feed" of program "2011 survey").

			If a sample name is misspelled in one of the testwork tables, then that sample will not match the name in the other tables and that sample will not appear in the Query table. ''(Hint: you can see mismatched sample names by scrolling through the -All- table in testwork.)''

	===Example: Aggregation of data===		===Example: Aggregation of data===

Alex Doll: /* Queries Table */

2013-04-13T18:02:21Z

Queries Table

@@ Line 1: / Line 1: @@
-===Queries Table===
+==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 "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 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]] (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.
 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.

Alex Doll: /* Queries Table */

2013-01-03T16:36:39Z

Queries Table

← Older revision		Revision as of 16:36, 3 January 2013
Line 1:		Line 1:
	===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 "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 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.