A method for spot-checking abnormal points in laboratory sample analysis of geochemical census
A sample analysis and geochemical technology, applied in the direction of material inspection products, complex mathematical operations, soil material testing, etc., can solve the problems of insufficient sampling quantity and representativeness, and achieve the effect of solving the insufficient sampling quantity and representativeness
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
Method used
Image
Examples
Embodiment 1
[0066] This embodiment provides a method for spot check and inspection of abnormal points in sample analysis of a geochemical census laboratory. The flow of the method is as follows figure 1 Shown, including:
[0067] Step 101: Obtain and organize sample data: each area or each batch of samples sent for inspection is divided into multiple batches (or called tasks) for analysis during laboratory testing; the test results of all elements of each batch of samples are obtained , And then remove all the test results of quality control samples, and remove the quality control samples as the analysis batch. Among them, there are quality control samples including external monitoring samples, internal password precision control samples, clear code standard materials, and password duplicate samples. Combine all analysis batches by element to obtain a total sample of each element.
[0068] The test results of the above analysis batch samples can be stored in txt file format, excel file format,...
Embodiment 2
[0116] This embodiment provides a method for spot check and inspection of abnormal points for sample analysis in a geochemical census laboratory. The method is implemented by a compiled EXCEL application file containing VBA (Microsoft Visual Basic for Applications) macro code. The file includes two Basic worksheet, specifically:
[0117] The worksheet "SmpList" is used to store the coding information of the test samples, including serial number, laboratory number, original number, sample lithology, analysis batch, original code sample number, monitoring sample type and detection element information.
[0118] The worksheet "RawData" is used to store the imported sample data of the geochemical survey, including basic sample information, such as analysis number, analysis batch number, and detection results of each element;
[0119] The results are output in multiple new worksheets, which are automatically added during the running of the program.
[0120] This example does not limit the e...
PUM
Login to View More Abstract
Description
Claims
Application Information
Login to View More 


