CN110569285A - Method and device for calculating background value of soil element - Google Patents
Method and device for calculating background value of soil element Download PDFInfo
- Publication number
- CN110569285A CN110569285A CN201910849046.3A CN201910849046A CN110569285A CN 110569285 A CN110569285 A CN 110569285A CN 201910849046 A CN201910849046 A CN 201910849046A CN 110569285 A CN110569285 A CN 110569285A
- Authority
- CN
- China
- Prior art keywords
- background value
- worksheet
- measurement data
- soil element
- value calculation
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
- 239000002689 soil Substances 0.000 title claims abstract description 151
- 238000000034 method Methods 0.000 title claims abstract description 60
- 238000005259 measurement Methods 0.000 claims abstract description 133
- 238000004364 calculation method Methods 0.000 claims abstract description 132
- 238000012216 screening Methods 0.000 claims abstract description 28
- 230000000007 visual effect Effects 0.000 claims abstract description 20
- 230000006870 function Effects 0.000 claims description 113
- 238000005070 sampling Methods 0.000 claims description 40
- 230000002159 abnormal effect Effects 0.000 claims description 19
- 238000012545 processing Methods 0.000 abstract description 7
- 230000008569 process Effects 0.000 description 7
- 238000011835 investigation Methods 0.000 description 4
- 238000011160 research Methods 0.000 description 4
- 238000001514 detection method Methods 0.000 description 3
- 238000010586 diagram Methods 0.000 description 3
- 238000007796 conventional method Methods 0.000 description 2
- 238000012163 sequencing technique Methods 0.000 description 2
- 238000005527 soil sampling Methods 0.000 description 2
- 230000003068 static effect Effects 0.000 description 2
- 238000004891 communication Methods 0.000 description 1
- 238000004590 computer program Methods 0.000 description 1
- 238000013461 design Methods 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 238000011156 evaluation Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
- 230000001360 synchronised effect Effects 0.000 description 1
- 238000012546 transfer Methods 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2458—Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
- G06F16/2462—Approximate or statistical queries
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/248—Presentation of query results
Landscapes
- Engineering & Computer Science (AREA)
- Physics & Mathematics (AREA)
- Theoretical Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Databases & Information Systems (AREA)
- General Engineering & Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Computational Linguistics (AREA)
- Probability & Statistics with Applications (AREA)
- Fuzzy Systems (AREA)
- Mathematical Physics (AREA)
- Software Systems (AREA)
- Investigation Of Foundation Soil And Reinforcement Of Foundation Soil By Compacting Or Drainage (AREA)
- Testing Or Calibration Of Command Recording Devices (AREA)
Abstract
The embodiment of the invention discloses a method and a device for calculating a background value of a soil element, wherein the method comprises the following steps: compiling based on an original measurement data worksheet to obtain a condition data worksheet, and screening the soil element measurement data by using the condition data worksheet to obtain a target soil element measurement data set; compiling based on the condition data worksheet to obtain a background value calculation worksheet, and performing iterative calculation on the target soil element measurement data set by using the background value calculation worksheet to obtain a background value calculation result; and linking the background value calculation result to a cell corresponding to the statistical data worksheet, and displaying in a visual mode. By adopting the method, a large number of processing tasks of the soil element measurement data can be effectively dealt with, the background value calculation efficiency is greatly improved, and the labor amount of a calculator is effectively reduced.
Description
Technical Field
the embodiment of the invention relates to the technical field of batch processing of soil element data, in particular to a method and a device for calculating a background value of a soil element, and further relates to electronic equipment and a computer-readable storage medium.
Background
During research on soil geochemistry, it is often necessary to calculate background values for soil elements. The background value of the soil element is a statistical characteristic value, usually, standard deviation exceeding the average value by +/-3 times (or +/-2 times) is used as an abnormal value judgment standard, after abnormal value data in the measurement data set is screened out, the judgment standard is calculated again, the screening … is iterated again until no abnormal value data exists in the soil element measurement data set, and finally, the average value is calculated for the soil element data set without the abnormal value, so that a background value calculation result is obtained. At present, the method of using "SPSS statistical analysis software" and Excel (or WPS) software to calculate the element background value in the industry still needs the assistance of a computer to perform iterative calculation. However, the number of iterations is large, which results in a complicated calculation process; especially, for variable combinations of more soil elements corresponding to different sampling areas and different sampling types, the calculation workload is very large, which results in high operation cost. In recent years, with the rapid development of network technology, setting intelligent and automatic computing tools by means of built-in function algorithms becomes a key point of attention in the field.
Therefore, how to design an automatic calculation tool capable of performing multivariable in batches has great practical significance for calculating element background values in soil geochemistry investigation and research work.
Disclosure of Invention
Therefore, the embodiment of the invention provides a method for calculating a background value of a soil element, which is used for solving the problems that the calculation process of soil element data is complicated, the processing efficiency is low, and the research progress of soil chemistry investigation is influenced in the prior art.
In order to achieve the above object, the embodiments of the present invention provide the following technical solutions:
in a first aspect, an embodiment of the present invention provides a method for calculating a background value of a soil element, including: obtaining an original measurement data worksheet for recording soil element measurement data; compiling by using a preset first built-in function based on the original measurement data worksheet to obtain a condition data worksheet for screening the soil element measurement data; screening the soil element measurement data by using the condition data worksheet to obtain a target soil element measurement data set; compiling by using a preset second built-in function based on the condition data worksheet to obtain a background value calculation worksheet for automatic iterative calculation; performing iterative computation on the target soil element measurement data set by using the background value computation worksheet to obtain a background value computation result; compiling by using a preset third built-in function based on the original measurement data worksheet, the condition data worksheet and the background value calculation worksheet to obtain a statistical data worksheet; and linking the background value calculation result to a cell corresponding to the statistical data worksheet, and displaying the background value calculation result in a visual mode.
Further, the statistics worksheet comprises: the variable setting area is provided with a plurality of variable setting cells and the calculation result display area is provided with a plurality of result display cells; the step of linking the background value calculation result to the cell corresponding to the statistical data worksheet and displaying the background value calculation result in a visual manner specifically includes: and linking the background value calculation result to a result display cell in the statistical data worksheet and displaying the result in a visual mode.
further, the method for calculating the background value of the soil element further comprises the following steps: setting a drop-down menu based on variable setting cells in the statistical data worksheet; setting variable conditions in the variable setting cells in the statistical data worksheet through the pull-down menu; wherein the variable condition includes at least one of a sampling region of the soil element measurement data and a sampling type of the soil element measurement data; and displaying the background value calculation result corresponding to the variable condition in a visual mode in the result display cell in the statistical data worksheet based on the variable condition.
Further, the original measurement data worksheet is a summary form of soil survey records of the soil element measurement data; wherein the soil element measurement data comprises at least one of a sampling area, a sampling type, and soil element measurement data.
Further, the condition data worksheet is used for screening the soil element measurement data according to at least one screening condition of the sampling area and the sampling type.
Further, the method for calculating the background value of the soil element further comprises the following steps: performing iterative computation on the soil element measurement data in the condition data working table according to a preset background value computation rule respectively based on different columns in the background value computation working table to obtain a background value computation result; wherein the background value calculation result comprises at least one of a background value, iteration times, the number of screened abnormal values and the number of samples.
Further, the method for calculating the background value of the soil element further comprises the following steps: and editing the meaning explanation notes of the variable combination in the variable setting cells in the variable setting area.
In a second aspect, the present invention also provides an apparatus for calculating a background value of a soil element, including: the original measurement data worksheet obtaining unit is used for obtaining an original measurement data worksheet used for recording soil element measurement data; the condition data worksheet compiling unit is used for compiling by utilizing a preset first built-in function based on the original measurement data worksheet to obtain a condition data worksheet for screening the soil element measurement data; screening the soil element measurement data by using the condition data worksheet to obtain a target soil element measurement data set; the background value calculation unit is used for compiling by using a preset second built-in function based on the condition data worksheet to obtain a background value calculation worksheet for automatic iterative calculation; performing iterative computation on the target soil element measurement data set by using the background value computation worksheet to obtain a background value computation result; the statistical data worksheet compiling unit is used for compiling by utilizing a preset third built-in function based on the original measurement data worksheet, the condition data worksheet and the background value calculation worksheet to obtain a statistical data worksheet; and the background value calculation result display unit is used for linking the background value calculation result to the cells corresponding to the statistical data worksheet and displaying the background value calculation result in a visual mode.
Further, the statistics worksheet comprises: the variable setting area is provided with a plurality of variable setting cells and the calculation result display area is provided with a plurality of result display cells; the step of linking the background value calculation result to the cell corresponding to the statistical data worksheet and displaying the background value calculation result in a visual manner specifically includes: and linking the background value calculation result to a result display cell in the statistical data worksheet and displaying the result in a visual mode.
Further, the device for calculating the background value of the soil element further comprises: the drop-down menu setting unit is used for setting a drop-down menu based on the variable setting cell in the statistical data worksheet; the variable condition setting unit is used for setting variable conditions in the variable setting cells in the statistical data worksheet through the pull-down menu; wherein the variable condition includes at least one of a sampling region of the soil element measurement data and a sampling type of the soil element measurement data; and the background value calculation result display unit is used for visually displaying the background value calculation result corresponding to the variable condition in the result display cell in the statistical data worksheet based on the variable condition.
further, the original measurement data worksheet is a summary form of soil survey records of the soil element measurement data; wherein the soil element measurement data comprises at least one of a sampling area, a sampling type, and soil element measurement data.
further, the condition data worksheet is used for screening the soil element measurement data according to at least one screening condition of the sampling area and the sampling type.
Further, the device for calculating the background value of the soil element further comprises: the calculation result of the background value of the column is used for obtaining the iterative calculation of the soil element measurement data in the condition data working table based on different columns in the background value calculation working table according to the preset background value calculation rule respectively to obtain the calculation result of the background value; wherein the background value calculation result comprises at least one of a background value, iteration times, the number of screened abnormal values and the number of samples.
further, the device for calculating the background value of the soil element further comprises: and the explanation annotation unit is used for explaining and annotating the meaning of the variable combination edited by the variable setting unit in the variable setting area.
In a third aspect, an embodiment of the present invention further provides an electronic device, including: a processor and a memory; the memory is used for storing a program of a method for calculating a background value of a soil element, and after the electronic device is powered on and runs the program of the method for calculating the background value of the soil element through the processor, the method for calculating the background value of the soil element is executed.
In a fourth aspect, embodiments of the present invention also provide a computer-readable storage medium having one or more program instructions embodied therein, the one or more program instructions being configured to be executed by a server to perform any one of the above-mentioned methods for calculating a background value of a soil element.
By adopting the method for calculating the background value of the soil element, disclosed by the invention, a large number of processing tasks of the soil element measurement data can be effectively dealt with, the calculation efficiency of the background value is greatly improved, the labor amount of a calculator is effectively reduced, and the use experience of a user is improved.
Drawings
in order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below. It should be apparent that the drawings in the following description are merely exemplary, and that other embodiments can be derived from the drawings provided by those of ordinary skill in the art without inventive effort.
Fig. 1 is a flowchart of a method for calculating a background value of a soil element according to an embodiment of the present invention;
FIG. 2 is a schematic diagram of an apparatus for calculating a background value of a soil element according to an embodiment of the present invention;
Fig. 3 is a schematic diagram of an electronic device according to an embodiment of the present invention;
fig. 4 is a structural diagram of a calculation tool designed based on a method for calculating a background value of a soil element according to an embodiment of the present invention.
Detailed Description
the present invention is described in terms of particular embodiments, other advantages and features of the invention will become apparent to those skilled in the art from the following disclosure, and it is to be understood that the described embodiments are merely exemplary of the invention and that it is not intended to limit the invention to the particular embodiments disclosed. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
the technical scheme disclosed by the invention relates to a method for calculating a background value of a soil element. The invention aims to: the method for automatically calculating the background value in batches is provided for research work with a large amount of background value calculation like soil geochemistry survey evaluation.
the following describes an embodiment of the method for calculating a background value of a soil element according to the present invention in detail. As shown in fig. 1, which is a flowchart of a method for calculating a background value of a soil element according to an embodiment of the present invention, a specific implementation process includes the following steps:
Step S101: and obtaining an original measurement data worksheet for recording soil element measurement data.
In the embodiment of the invention, the original measurement data worksheet is a summary spreadsheet of soil element measurement data recorded in soil sampling investigation and detection work. The soil element measurement data comprises field data which participate in calculation, such as a sampling area (or an administrative area), a sampling type (or a sample type), soil elements and the like.
Step S102: compiling by using a preset first built-in function based on the original measurement data worksheet to obtain a condition data worksheet for screening the soil element measurement data; and screening the soil element measurement data by using the condition data worksheet to obtain a target soil element measurement data set.
after the raw measurement data worksheet is obtained in step S101, in this step, a preset first built-in function may be used to compile based on the raw measurement data worksheet and/or a preset statistical data worksheet, so as to obtain a condition data worksheet for screening soil element measurement data.
In an embodiment of the present invention, the first built-in function is similar to a built-in function in Excel (or WPS), and may include at least one built-in function of a database function, a date and time function, a statistical function, an engineering function, a logic function, a query and reference function, an information function, a mathematical and trigonometric function, and a text function, or may be a user-defined function or a combination of multiple built-in functions, which is not specifically limited herein.
specifically, the condition data worksheet may be used to screen the soil element measurement data in the original measurement data worksheet according to the screening conditions of the sampling area (or administrative area) and the sampling type (or sample type), so as to obtain a target soil element measurement data set satisfying the screening conditions of the sampling area (or administrative area) and the sampling type (or sample type).
Step S103: compiling by using a preset second built-in function based on the condition data worksheet to obtain a background value calculation worksheet for automatic iterative calculation; and performing iterative computation on the target soil element measurement data set by using the background value computation worksheet to obtain a background value computation result.
After the target soil element measurement data set is screened in step S102, a second built-in function may be used for compilation in this step to obtain a background value calculation worksheet for automatic iterative calculation.
Further, based on the target soil element measurement data set, iterative calculation for automatically eliminating abnormal values in the target soil element measurement data set can be performed by using the background value calculation worksheet, so that a background value calculation result meeting the user requirements and obtained by automatic iterative calculation is obtained. The second built-in function is similar to the first built-in function, and may include at least one built-in function of a database function, a date and time function, a statistical function, an engineering function, a logic function, a query and reference function, an information function, a mathematical and trigonometric function, and a text function, or may be a user-defined function or a combination of multiple built-in functions, which is not limited herein.
it should be noted that, the data sets to be calculated are not screened from the raw measurement data worksheet during calculation, but are screened in advance according to the screening conditions to form the data sets in the condition data worksheet, and only the data sets in the condition data worksheet are calculated during calculation, so that the complexity of iterative calculation is reduced.
In the automatic iterative computation process in the background value computation worksheet, the computation of the background value needs to be iterated for many times, and the abnormal value is manually removed in a sequencing mode in each time by the conventional method. In the invention, the automatic iterative computation method adopts a built-in condition function to automatically eliminate the abnormal value. After each iterative computation, in the next column of the column data set in the background value computation worksheet, automatically computing and setting new conditions, eliminating new abnormal values and forming a new data set until iteration is finished when no new abnormal value exists.
Step S104: and compiling by using a preset third built-in function based on the original measurement data worksheet, the condition data worksheet and the background value calculation worksheet to obtain a statistical data worksheet.
After the actual soil element measurement data is recorded in the original measurement data worksheet, the statistical data worksheet can be compiled based on the original measurement data worksheet, the condition data worksheet and the background value calculation worksheet by using a preset third built-in function, and the statistical data worksheet is obtained.
The statistics worksheet may comprise: the variable setting area is provided with a plurality of variable setting cells and the calculation result display area is provided with a plurality of result display cells. In addition, a variable setting cell in the variable setting area may set a meaning explanation comment of a variable combination.
The third built-in function is similar to the first built-in function and the second built-in function, and may include at least one built-in function of a database function, a date and time function, a statistical function, an engineering function, a logic function, a query and reference function, an information function, a mathematical and trigonometric function, and a text function, or may be a user-defined function or a combination of multiple built-in functions, which is not specifically limited herein.
Step S105: and linking the background value calculation result to a cell corresponding to the statistical data worksheet, and displaying the background value calculation result in a visual mode.
Specifically, the linking of the background value calculation result to the cell corresponding to the statistical data worksheet and the display of the background value calculation result in a visual manner include: and linking the background value calculation result to a result display cell in the statistical data worksheet and displaying the result in a visual mode.
Further, in the embodiment of the present invention, a drop-down menu may be set based on a variable setting cell in the statistical data worksheet; and setting variable conditions in the variable setting cells in the statistical data worksheet through the pull-down menu. Wherein the variable condition includes at least one of a sampling region of the soil element measurement data and a sampling type of the soil element measurement data. And displaying the background value calculation result corresponding to the variable condition in a visual mode in the result display cell in the statistical data worksheet based on the variable condition.
in addition, in the embodiment of the present invention, iterative computation may be performed on the soil element measurement data in the condition data working table according to preset background value computation rules respectively based on different columns in the background value computation working table, so as to obtain a background value computation result. Wherein the background value calculation result comprises at least one of a background value, iteration times, the number of screened abnormal values and the number of samples.
As shown in fig. 4, the soil element background value calculation tool according to the present invention includes a statistical calculation worksheet, a condition data worksheet, and a background value calculation worksheet. In the actual implementation process, passwords can be set for the statistical calculation worksheet, the condition data worksheet and the background value calculation worksheet for protection; meanwhile, hiding a condition data worksheet and a background value calculation worksheet; and opening a calculation tool to see the original measurement data worksheet and the statistical calculation worksheet. After the soil element measurement data is copied and pasted into the original measurement data worksheet, variables or variable combinations (such as different sampling areas and sampling types) can be set in a variable setting area in the statistical calculation worksheet, and background value calculation results under the conditions of corresponding variables or variable combinations are displayed in a result display area. The background value is calculated by using the calculating tool, so that the working efficiency can be greatly improved, and the labor intensity is reduced.
For example, after the fields in the actual detection data table in the original survey process of province a are adjusted to be consistent with the original measurement data worksheet in the calculation tool designed by the invention, the data thereof can be correspondingly set into the original measurement data worksheet. Setting all sample type data of province A in a variable setting area of a statistical calculation worksheet; according to the annotation of the variable combination meaning of the variable setting cell, setting the province name as 'A province' through a set 'province name' pull-down menu; setting the 'sample type' to be null through a set 'sample type' pull-down menu; i.e. all sample type data conditions set to province a. And displaying the soil element measurement data corresponding to all sample type data conditions in the province A in a calculation result display area of the statistical calculation worksheet. Similarly, the required background value calculation result data can be obtained by changing the variables as required.
When the data volume is large, the method for calculating the background value of the soil element can effectively deal with the processing tasks of a large amount of soil element measurement data, greatly improves the calculation efficiency of the background value, and effectively lightens the labor amount of a calculator, thereby improving the use experience of a user.
Corresponding to the method for calculating the background value of the soil element, the invention also provides a device for calculating the background value of the soil element. Since the embodiment of the device is similar to the above method embodiment, the description is simple, and for the relevant points, please refer to the description in the above method embodiment section, and the embodiment of the device for calculating the background value of the soil element described below is only schematic. Fig. 2 is a schematic view of an apparatus for calculating a background value of a soil element according to an embodiment of the present invention.
The device for calculating the background value of the soil element comprises the following parts:
An original measurement data worksheet obtaining unit 201 for obtaining an original measurement data worksheet for recording soil element measurement data.
In the embodiment of the invention, the original measurement data worksheet is a summary spreadsheet of soil element measurement data recorded in soil sampling investigation and detection work. The soil element measurement data comprises field data which participate in calculation, such as a sampling area (or an administrative area), a sampling type (or a sample type), soil elements and the like.
A condition data worksheet compiling unit 202, configured to compile by using a preset first built-in function based on the original measurement data worksheet, to obtain a condition data worksheet for screening soil element measurement data; and screening the soil element measurement data by using the condition data worksheet to obtain a target soil element measurement data set.
After the raw measurement data worksheet is obtained in the raw measurement data worksheet obtaining unit 201, the condition data worksheet creating unit 202 may create a condition data worksheet for screening the soil element measurement data by using a preset first built-in function based on the raw measurement data worksheet and/or a preset statistical data worksheet.
In an embodiment of the present invention, the first built-in function is similar to a built-in function in Excel (or WPS), and may include at least one built-in function of a database function, a date and time function, a statistical function, an engineering function, a logic function, a query and reference function, an information function, a mathematical and trigonometric function, and a text function, or may be a user-defined function or a combination of multiple built-in functions, which is not specifically limited herein.
Specifically, the condition data worksheet may be used to screen the soil element measurement data in the original measurement data worksheet according to the screening conditions of the sampling area (or administrative area) and the sampling type (or sample type), so as to obtain a target soil element measurement data set satisfying the screening conditions of the sampling area (or administrative area) and the sampling type (or sample type).
A background value calculation unit 203, configured to compile by using a preset second built-in function based on the condition data worksheet, and obtain a background value calculation worksheet for automatic iterative calculation; and performing iterative computation on the target soil element measurement data set by using the background value computation worksheet to obtain a background value computation result.
After the target soil element measurement data set is screened out in the condition data worksheet compiling unit 202, a second built-in function can be adopted for compiling in the step, and a background value calculation worksheet for automatic iterative calculation is obtained.
Further, based on the target soil element measurement data set, iterative calculation for automatically eliminating abnormal values in the target soil element measurement data set can be performed by using the background value calculation worksheet, so that a background value calculation result meeting the user requirements and obtained by automatic iterative calculation is obtained. The second built-in function is similar to the first built-in function, and may include at least one built-in function of a database function, a date and time function, a statistical function, an engineering function, a logic function, a query and reference function, an information function, a mathematical and trigonometric function, and a text function, or may be a user-defined function or a combination of multiple built-in functions, which is not limited herein.
It should be noted that, the data sets to be calculated are not screened from the raw measurement data worksheet during calculation, but are screened in advance according to the screening conditions to form the data sets in the condition data worksheet, and only the data sets in the condition data worksheet are calculated during calculation, so that the complexity of iterative calculation is reduced.
In the automatic iterative computation process in the background value computation worksheet, the computation of the background value needs to be iterated for many times, and the abnormal value is manually removed in a sequencing mode in each time by the conventional method. In the invention, the automatic iterative computation method adopts a built-in condition function to automatically eliminate the abnormal value. After each iterative computation, in the next column of the column data set in the background value computation worksheet, automatically computing and setting new conditions, eliminating new abnormal values and forming a new data set until iteration is finished when no new abnormal value exists.
And the statistical data worksheet compiling unit 204 is configured to compile a statistical data worksheet by using a preset third built-in function based on the raw measurement data worksheet, the condition data worksheet, and the background value calculation worksheet.
After the actual soil element measurement data is recorded in the original measurement data worksheet, the statistical data worksheet can be compiled based on the original measurement data worksheet, the condition data worksheet and the background value calculation worksheet by using a preset third built-in function, and the statistical data worksheet is obtained.
the statistics worksheet may comprise: the variable setting area is provided with a plurality of variable setting cells and the calculation result display area is provided with a plurality of result display cells. In addition, a variable setting cell in the variable setting area may set a meaning explanation comment of a variable combination.
The third built-in function is similar to the first built-in function and the second built-in function, and may include at least one built-in function of a database function, a date and time function, a statistical function, an engineering function, a logic function, a query and reference function, an information function, a mathematical and trigonometric function, and a text function, or may be a user-defined function or a combination of multiple built-in functions, which is not specifically limited herein.
And a background value calculation result display unit 205, configured to link the background value calculation result to a cell corresponding to the statistical data worksheet, and display the result in a visualized manner.
Specifically, the linking of the background value calculation result to the cell corresponding to the statistical data worksheet and the display of the background value calculation result in a visual manner include: and linking the background value calculation result to a result display cell in the statistical data worksheet and displaying the result in a visual mode.
Further, in the embodiment of the present invention, a drop-down menu may be set based on a variable setting cell in the statistical data worksheet; and setting variable conditions in the variable setting cells in the statistical data worksheet through the pull-down menu. Wherein the variable condition includes at least one of a sampling region of the soil element measurement data and a sampling type of the soil element measurement data. And displaying the background value calculation result corresponding to the variable condition in a visual mode in the result display cell in the statistical data worksheet based on the variable condition.
In the embodiment of the invention, the soil element measurement data in the condition data working table can be subjected to iterative computation according to preset background value computation rules respectively based on different columns in the background value computation working table, so as to obtain a background value computation result. Wherein the background value calculation result comprises at least one of a background value, iteration times, the number of screened abnormal values and the number of samples.
In addition, setting passwords for the statistical calculation worksheet, the condition data worksheet and the background value calculation worksheet for protection, and hiding the condition data worksheet and the background value calculation worksheet; and opening a calculation tool to see the original measurement data worksheet and the statistical calculation worksheet. After the soil element measurement data is copied and pasted into the original measurement data worksheet, variables or variable combinations (such as different sampling areas and sampling types) can be set in a variable setting area in the statistical calculation worksheet, and background value calculation results under the conditions of corresponding variables or variable combinations are displayed in a result display area. The background value is calculated by using the calculating tool, so that the working efficiency can be greatly improved, and the labor intensity is reduced.
By adopting the device for calculating the background value of the soil element, disclosed by the invention, a large number of processing tasks of the soil element measurement data can be effectively dealt with, the calculation efficiency of the background value is greatly improved, the labor amount of a calculator is effectively reduced, and the use experience of a user is improved.
Corresponding to the method for calculating the background value of the soil element, the invention also provides electronic equipment. Since the embodiment of the electronic device is similar to the above method embodiment, the description is relatively simple, and please refer to the description of the above method embodiment, and the electronic device described below is only schematic. Fig. 3 is a schematic view of an electronic device according to an embodiment of the present invention.
The electronic device specifically includes: a processor 301 and a memory 302; wherein, the memory 302 is used for running one or more program instructions for storing a program of the method for calculating the background value of the soil element, and the server is powered on and runs the program of the method for calculating the background value of the soil element through the processor 301 to execute any one of the methods for calculating the background value of the soil element. The electronic device of the present invention may be a server.
Corresponding to the method for calculating the background value of the soil element, the invention also provides a computer storage medium. Since the embodiment of the computer storage medium is similar to the above method embodiment, the description is simple, and please refer to the description of the above method embodiment, and the computer storage medium described below is only schematic.
The computer storage medium contains one or more program instructions for executing the method for calculating a background value of a soil element by a server.
In an embodiment of the invention, the processor or processor module may be an integrated circuit chip having signal processing capabilities. The Processor may be a general purpose Processor, a Digital Signal Processor (DSP), an Application Specific Integrated Circuit (ASIC), a Field Programmable Gate Array (FPGA) or other Programmable logic device, discrete Gate or transistor logic device, discrete hardware component.
The various methods, steps and logic blocks disclosed in the embodiments of the present invention may be implemented or performed. A general purpose processor may be a microprocessor or the processor may be any conventional processor or the like. The steps of the method disclosed in connection with the embodiments of the present invention may be directly implemented by a hardware decoding processor, or implemented by a combination of hardware and software modules in the decoding processor. The software module may be located in ram, flash memory, rom, prom, or eprom, registers, etc. storage media as is well known in the art. The processor reads the information in the storage medium and completes the steps of the method in combination with the hardware.
the storage medium may be a memory, for example, which may be volatile memory or nonvolatile memory, or which may include both volatile and nonvolatile memory.
The nonvolatile Memory may be a Read-Only Memory (ROM), a Programmable ROM (PROM), an Erasable PROM (EPROM), an Electrically Erasable PROM (EEPROM), or a flash Memory.
The volatile Memory may be a Random Access Memory (RAM) which serves as an external cache. By way of example and not limitation, many forms of RAM are available, such as Static random access memory (Static RAM, SRAM), Dynamic RAM (DRAM), Synchronous DRAM (SDRAM), Double Data Rate SDRAM (ddr Data Rate SDRAM), Enhanced SDRAM (ESDRAM), synclink DRAM (SLDRAM), and Direct memory bus RAM (DRRAM).
the storage media described in connection with the embodiments of the invention are intended to comprise, without being limited to, these and any other suitable types of memory.
Those skilled in the art will appreciate that the functionality described in the present invention may be implemented in a combination of hardware and software in one or more of the examples described above. When software is applied, the corresponding functionality may be stored on or transmitted over as one or more instructions or code on a computer-readable medium. Computer-readable media includes both computer storage media and communication media including any medium that facilitates transfer of a computer program from one place to another. A storage media may be any available media that can be accessed by a general purpose or special purpose computer.
the above-mentioned embodiments, objects, technical solutions and advantages of the present invention are further described in detail, it should be understood that the above-mentioned embodiments are only exemplary embodiments of the present invention, and are not intended to limit the scope of the present invention, and any modifications, equivalent substitutions, improvements and the like made on the basis of the technical solutions of the present invention should be included in the scope of the present invention.
Claims (10)
1. A method of calculating a background value for a soil element, comprising:
Obtaining an original measurement data worksheet for recording soil element measurement data;
Compiling by using a preset first built-in function based on the original measurement data worksheet to obtain a condition data worksheet for screening the soil element measurement data; screening the soil element measurement data by using the condition data worksheet to obtain a target soil element measurement data set;
Compiling by using a preset second built-in function based on the condition data worksheet to obtain a background value calculation worksheet for automatic iterative calculation; performing iterative computation on the target soil element measurement data set by using the background value computation worksheet to obtain a background value computation result;
Compiling by using a preset third built-in function based on the original measurement data worksheet, the condition data worksheet and the background value calculation worksheet to obtain a statistical data worksheet;
And linking the background value calculation result to a cell corresponding to the statistical data worksheet, and displaying the background value calculation result in a visual mode.
2. The method of calculating a background value for a soil element as claimed in claim 1 wherein said statistical data worksheet comprises: the variable setting area is provided with a plurality of variable setting cells and the calculation result display area is provided with a plurality of result display cells;
The step of linking the background value calculation result to the cell corresponding to the statistical data worksheet and displaying the background value calculation result in a visual manner specifically includes:
And linking the background value calculation result to a result display cell in the statistical data worksheet and displaying the result in a visual mode.
3. The method of calculating a background value for a soil element as recited in claim 2, further comprising:
Setting a drop-down menu based on variable setting cells in the statistical data worksheet;
Setting variable conditions in the variable setting cells in the statistical data worksheet through the pull-down menu; wherein the variable condition includes at least one of a sampling region of the soil element measurement data and a sampling type of the soil element measurement data;
And displaying the background value calculation result corresponding to the variable condition in a visual mode in the result display cell in the statistical data worksheet based on the variable condition.
4. The method of calculating a soil element background value as claimed in claim 1, wherein the raw measurement data worksheet is a summary sheet of soil survey records of the soil element measurement data; wherein the soil element measurement data comprises at least one of a sampling area, a sampling type, and soil element measurement data.
5. The method of calculating a soil element background value as claimed in claim 1, wherein the condition data worksheet is used for screening the soil element measurement data according to at least one screening condition of a sampling region and a sampling type.
6. The method of calculating a background value for a soil element as recited in claim 1, further comprising: performing iterative computation on the soil element measurement data in the condition data working table according to a preset background value computation rule respectively based on different columns in the background value computation working table to obtain a background value computation result; wherein the background value calculation result comprises at least one of a background value, iteration times, the number of screened abnormal values and the number of samples.
7. The method of calculating a background value for a soil element as recited in claim 2, further comprising: and editing the meaning explanation notes of the variable combination in the variable setting cells in the variable setting area.
8. An apparatus for calculating a background value of a soil element, comprising:
The original measurement data worksheet obtaining unit is used for obtaining an original measurement data worksheet used for recording soil element measurement data;
the condition data worksheet compiling unit is used for compiling by utilizing a preset first built-in function based on the original measurement data worksheet to obtain a condition data worksheet for screening the soil element measurement data; screening the soil element measurement data by using the condition data worksheet to obtain a target soil element measurement data set;
The background value calculation unit is used for compiling by using a preset second built-in function based on the condition data worksheet to obtain a background value calculation worksheet for automatic iterative calculation; performing iterative computation on the target soil element measurement data set by using the background value computation worksheet to obtain a background value computation result;
the statistical data worksheet compiling unit is used for compiling by utilizing a preset third built-in function based on the original measurement data worksheet, the condition data worksheet and the background value calculation worksheet to obtain a statistical data worksheet;
and the background value calculation result display unit is used for linking the background value calculation result to the cells corresponding to the statistical data worksheet and displaying the background value calculation result in a visual mode.
9. An electronic device, comprising:
A processor; and
A memory for storing a program for a method of calculating a background value of a soil element, the electronic device being powered on and executing the program for the method of calculating a background value of a soil element by the processor to perform the method of calculating a background value of a soil element as claimed in any one of claims 1 to 7.
10. A computer readable storage medium having one or more program instructions embodied therein for execution by a server of the method of calculating a background value for a soil element of any of claims 1-7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910849046.3A CN110569285B (en) | 2019-09-09 | 2019-09-09 | Method and device for calculating background value of soil element |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910849046.3A CN110569285B (en) | 2019-09-09 | 2019-09-09 | Method and device for calculating background value of soil element |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN110569285A true CN110569285A (en) | 2019-12-13 |
| CN110569285B CN110569285B (en) | 2022-11-25 |
Family
ID=68778608
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910849046.3A Expired - Fee Related CN110569285B (en) | 2019-09-09 | 2019-09-09 | Method and device for calculating background value of soil element |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110569285B (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112307733A (en) * | 2020-10-15 | 2021-02-02 | 平和县鑫泰德远矿业有限公司 | Pyrophyllite ore stacking method convenient for ore blending |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103176221A (en) * | 2013-03-07 | 2013-06-26 | 李春华 | Mineralizing abnormal feature identification method based on different geological unit background values and contrast values |
| CN103345566A (en) * | 2013-02-26 | 2013-10-09 | 郑有业 | Geochemical exploration anomaly recognizing and evaluating method based on contents contained in geology |
| CN109856663A (en) * | 2017-11-30 | 2019-06-07 | 中国辐射防护研究院 | The measurement method of Cs-137 γ spectrum in a kind of soil |
-
2019
- 2019-09-09 CN CN201910849046.3A patent/CN110569285B/en not_active Expired - Fee Related
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103345566A (en) * | 2013-02-26 | 2013-10-09 | 郑有业 | Geochemical exploration anomaly recognizing and evaluating method based on contents contained in geology |
| CN103176221A (en) * | 2013-03-07 | 2013-06-26 | 李春华 | Mineralizing abnormal feature identification method based on different geological unit background values and contrast values |
| CN109856663A (en) * | 2017-11-30 | 2019-06-07 | 中国辐射防护研究院 | The measurement method of Cs-137 γ spectrum in a kind of soil |
Non-Patent Citations (4)
| Title |
|---|
| J. MATSCHULLAT等: "Geochemical background-can we calculate it?", 《ENVIRONMENTAL GEOLOGY》 * |
| 朱月珍: "中国土壤中元素的地域背景值", 《中国环境监测》 * |
| 王登峰等: "土壤元素背景值确定方法评述", 《农业科技》 * |
| 王登峰等: "海南岛农田土壤重金属背景值评价方法研究――以铬为例", 《热带作物学报》 * |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112307733A (en) * | 2020-10-15 | 2021-02-02 | 平和县鑫泰德远矿业有限公司 | Pyrophyllite ore stacking method convenient for ore blending |
Also Published As
| Publication number | Publication date |
|---|---|
| CN110569285B (en) | 2022-11-25 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US10699067B2 (en) | Form design and data input in which a server provides a repository of form templates that are distributed to multiple form filing client systems | |
| Wu | Series expansion of the SABR joint density | |
| Etherington et al. | Approaches to the economic evaluation of agroforestry farming systems | |
| US6920620B2 (en) | Method and system for creating test component layouts | |
| CN110569285B (en) | Method and device for calculating background value of soil element | |
| Tankov | Lévy copulas: review of recent results | |
| CN115730605A (en) | Data analysis method based on multi-dimensional information | |
| CN112784341A (en) | BIM (building information modeling) model attribute determination method and device, computer equipment and storage medium | |
| CN116595859A (en) | Audit model construction method, device, equipment and medium based on machine learning | |
| CN116956838A (en) | Project determining method and device for engineering quantity list | |
| CN114117975A (en) | Method for automatically generating function coverage rate of finite state machine | |
| CN112558969A (en) | Webpage form generation method, device, equipment and medium | |
| CN112861491A (en) | Report processing method and device, electronic equipment and computer readable storage medium | |
| CN111832610A (en) | 3D printing organization prediction method, system, medium and terminal equipment | |
| CN115658617A (en) | Signal visualization analysis processing method and system based on MATLAB/App Designer development | |
| CN113327097B (en) | Analysis drawing method and device | |
| Chen et al. | Pay attention to the ignorable missing data mechanisms! an exploration of their impact on the efficiency of regression coefficients | |
| Bocevska et al. | An example of application design using solidworks application programming interface | |
| CN116956837A (en) | Project determining method and device for engineering quantity list | |
| CN114092641A (en) | Method, device and equipment for generating wiring board drawing and readable storage medium | |
| CN111966431A (en) | Calculation formula self-defining method applied to laboratory management system | |
| CN115437621A (en) | Process editing method and device based on robot process automation | |
| CN113127117A (en) | Qt development framework-based interface paging display method, device, system and medium | |
| Asghari et al. | Transform-based evaluation of prices and Greeks of lookback options driven by Lévy processes | |
| CN111221878B (en) | Knowledge point correlation value determining method and device in knowledge space, computer equipment and storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant | ||
| CF01 | Termination of patent right due to non-payment of annual fee | ||
| CF01 | Termination of patent right due to non-payment of annual fee |
Granted publication date: 20221125 |