CN112767515A - Method, system, equipment and medium for drawing ground temperature curve graph of test point - Google Patents
Method, system, equipment and medium for drawing ground temperature curve graph of test point Download PDFInfo
- Publication number
- CN112767515A CN112767515A CN202110191800.6A CN202110191800A CN112767515A CN 112767515 A CN112767515 A CN 112767515A CN 202110191800 A CN202110191800 A CN 202110191800A CN 112767515 A CN112767515 A CN 112767515A
- Authority
- CN
- China
- Prior art keywords
- ground temperature
- test point
- test
- layer
- curve graph
- 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.)
- Pending
Links
- 238000012360 testing method Methods 0.000 title claims abstract description 230
- 238000000034 method Methods 0.000 title claims abstract description 39
- 239000002689 soil Substances 0.000 claims description 87
- 239000004927 clay Substances 0.000 claims description 54
- 238000004590 computer program Methods 0.000 claims description 12
- 238000003860 storage Methods 0.000 claims description 7
- 238000000605 extraction Methods 0.000 abstract description 2
- 238000009933 burial Methods 0.000 description 6
- 238000010586 diagram Methods 0.000 description 5
- 238000009826 distribution Methods 0.000 description 2
- 238000005553 drilling Methods 0.000 description 2
- 230000006870 function Effects 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 238000012545 processing Methods 0.000 description 2
- 238000003491 array Methods 0.000 description 1
- 238000004891 communication Methods 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
- 238000013507 mapping Methods 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06T—IMAGE DATA PROCESSING OR GENERATION, IN GENERAL
- G06T11/00—2D [Two Dimensional] image generation
- G06T11/20—Drawing from basic elements, e.g. lines or circles
- G06T11/203—Drawing of straight lines or curves
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
- G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Health & Medical Sciences (AREA)
- Artificial Intelligence (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Computational Linguistics (AREA)
- General Health & Medical Sciences (AREA)
- General Engineering & Computer Science (AREA)
- Investigation Of Foundation Soil And Reinforcement Of Foundation Soil By Compacting Or Drainage (AREA)
Abstract
The invention discloses a method, a system, equipment and a medium for drawing a ground temperature curve graph of a test point, wherein the drawing method comprises the following steps: receiving a creation instruction; creating an Excel worksheet according to the creating instruction, wherein the Excel worksheet comprises ground temperature test data; acquiring ground temperature test data; and drawing a ground temperature curve graph of the test point according to the ground temperature test data. According to the method, the ground temperature test data are obtained from the created Excel worksheet, the ground temperature curve graph of the test points is drawn according to the ground temperature test data, and the ground temperature test curve graph of the test points can be automatically drawn only by obtaining the ground temperature test data, so that later-stage informatization filing and later-stage data re-extraction and utilization are facilitated, the drawing time of the ground temperature test curve graph of the test points is shortened, and the working efficiency is improved.
Description
Technical Field
The invention relates to the field of ground temperature test data processing, in particular to a method, a system, equipment and a medium for drawing a ground temperature curve graph of a test point.
Background
At present, most of the manufacturing methods of the geothermal curves adopt manual drawing, a large amount of statistics needs to be carried out on data before drawing, errors are easy to occur in the statistical process, and the drawing process is mostly repeated in a continuous mechanical mode; secondly, different technicians have different standards and cannot be used uniformly; the manual drawing result is not easy to carry out post-informationized filing, and the post-data is inconvenient to extract and utilize again.
Disclosure of Invention
The invention provides a method, a system, equipment and a medium for drawing a ground temperature curve graph of a test point, aiming at overcoming the defects that the ground temperature curve graph is drawn by adopting an artificial drawing mode in the prior art, the filing of information at the later stage is inconvenient, and the data at the later stage is extracted and utilized again.
The invention solves the technical problems through the following technical scheme:
the invention provides a method for drawing a ground temperature curve graph of a test point, which comprises the following steps:
receiving a creation instruction;
creating an Excel worksheet according to the creating instruction, wherein the Excel worksheet comprises geothermal test data;
acquiring the ground temperature test data;
and drawing a ground temperature curve graph of the test point according to the ground temperature test data.
Preferably, the Excel worksheet further includes test point depth data, and the drawing method further includes:
acquiring the depth data of the test point;
and acquiring the ground temperature test data according to the depth data of the test point.
Preferably, the Excel worksheet further comprises a maximum value of ground temperature, a minimum value of ground temperature and an average value of ground temperature, and the drawing method further comprises:
receiving a dividing instruction;
dividing the test point into a plurality of soil layers and combining the same soil layers according to the dividing instruction and the test point depth data;
acquiring the maximum ground temperature, the minimum ground temperature and the average ground temperature of each soil layer according to the ground temperature test data;
obtaining coordinate axis information of the ground temperature curve graph of the test point according to the maximum ground temperature value, the minimum ground temperature value and the average ground temperature value;
and drawing a ground temperature curve graph of the test point according to the ground temperature test data and the coordinate axis information.
Preferably, the soil layer comprises at least one of 1 layer of filling soil, 1 layer of clay, 1 layer of silty clay, 1-1 layer of clay silty soil, 1 layer of silty clay and silty clay;
and/or the presence of a gas in the gas,
the coordinate axis information includes at least one of a depth range, a scale unit and a scale mark type of the test point.
The invention provides a system for drawing a ground temperature curve graph of a test point, which comprises a first receiving module, a creating module, a first obtaining module and a drawing module, wherein the first receiving module is used for receiving a ground temperature curve graph of the test point;
the first receiving module is used for receiving a creating instruction;
the creating module is used for creating an Excel worksheet according to the creating instruction, and the Excel worksheet comprises geothermal test data;
the first acquisition module is used for acquiring the ground temperature test data;
the drawing module is used for drawing the ground temperature curve graph of the test point according to the ground temperature test data.
Preferably, the Excel worksheet further comprises test point depth data, and the drawing system further comprises a second obtaining module;
the second acquisition module is used for acquiring the depth data of the test point;
the first obtaining module is specifically used for obtaining the ground temperature test data according to the test point depth data.
Preferably, the Excel worksheet further comprises a maximum geothermal value, a minimum geothermal value and an average geothermal value, and the drawing system further comprises a second receiving module, a dividing module, a third obtaining module and a fourth obtaining module;
the second receiving module is used for receiving a dividing instruction;
the dividing module is used for dividing the test point into a plurality of soil layers and combining the same soil layers according to the dividing instruction and the test point depth data;
the third acquisition module is used for acquiring the maximum value, the minimum value and the average value of the ground temperature of each soil layer according to the ground temperature test data;
the fourth acquisition module is used for acquiring coordinate axis information of the ground temperature curve graph of the test point according to the maximum ground temperature value, the minimum ground temperature value and the average ground temperature value;
the drawing module is specifically used for drawing the ground temperature curve graph of the test point according to the ground temperature test data and the coordinate axis information.
Preferably, the soil layer comprises at least one of 1 layer of filling soil, 1 layer of clay, 1 layer of silty clay, 1-1 layer of clay silty soil, 1 layer of silty clay and silty clay;
and/or the presence of a gas in the gas,
the coordinate axis information includes at least one of a depth range, a scale unit and a scale mark type of the test point.
A third aspect of the present invention provides an electronic device, which includes a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the processor implements the method for plotting the temperature graph of the test points according to the first aspect when executing the computer program.
A fourth aspect of the present invention provides a computer-readable storage medium, on which a computer program is stored, wherein the computer program, when being executed by a processor, implements the steps of the method for plotting a plot of the ground temperature of test points according to the first aspect.
The positive progress effects of the invention are as follows:
according to the method, the ground temperature test data are obtained from the created Excel worksheet, the ground temperature curve graph of the test points is drawn according to the ground temperature test data, and the ground temperature test curve graph of the test points can be automatically drawn only by obtaining the ground temperature test data, so that later-stage informatization filing and later-stage data re-extraction and utilization are facilitated, the drawing time of the ground temperature test curve graph of the test points is shortened, and the working efficiency is improved.
Drawings
Fig. 1 is a flowchart of a method for drawing a ground temperature curve of a test point in embodiment 1 of the present invention.
Fig. 2 is a schematic diagram of an Excel worksheet of a method for drawing a ground temperature curve graph of a test point in embodiment 1 of the present invention.
Fig. 3 is a schematic view of a coordinate axis format setting interface of a method for drawing a ground temperature curve diagram of a test point in embodiment 1 of the present invention.
Fig. 4 is a module schematic diagram of a system for drawing a ground temperature curve of a test point in embodiment 2 of the present invention.
Fig. 5 is a schematic structural diagram of an electronic device according to embodiment 3 of the present invention.
Detailed Description
The invention is further illustrated by the following examples, which are not intended to limit the scope of the invention.
Example 1
As shown in fig. 1, the embodiment provides a method for drawing a plot of a ground temperature of a test point, which may be applied to a client, and therefore may be executed by the client, where the client may be a tablet computer or a desktop computer, or may be other clients capable of operating the drawing method, and is not limited specifically here. Specifically, the drawing method includes:
And 102, creating an Excel worksheet according to the creating instruction, wherein the Excel worksheet comprises the earth temperature test data.
In this embodiment, the Excel worksheet further includes header information, a project number, and a project name. For example, as shown in fig. 2, header information in an Excel worksheet: a result curve of the ground temperature test in the X # well (namely a test point ground temperature test curve graph in the X # well); and (4) engineering numbering: XXX; the project name is as follows: XXXXX engineering; the header information can be arranged in the first row of the Excel worksheet, and the project number and the project name are arranged below the header information, for example, the second row is named as: and (4) engineering numbering: XXX; the third row is named: the project name is as follows: the xxxxxx project can adjust the location of the project number and the project name as required, and is not limited specifically here.
And 103, acquiring ground temperature test data.
In the embodiment, the client acquires the ground temperature test data in the depth range of the test points sequentially recorded by the user from top to bottom in the Excel worksheet.
And 104, drawing a ground temperature curve graph of the test point according to the ground temperature test data.
In the embodiment, an Excel worksheet template for drawing the geothermal test curve graph is manufactured by using Microsoft Excel2010 software of the client, after the Excel worksheet template is manufactured, the client only needs to acquire geothermal test data input by a user in the Excel worksheet, and then the geothermal test data can be automatically processed and drawn into the test point geothermal curve graph according to the geothermal test data.
In an alternative embodiment, the Excel worksheet further includes test point depth data, as shown in fig. 1, and the drawing method further includes:
In the embodiment, a client acquires test point depth data recorded in an Excel worksheet by a user, and the test depth of the test point ground temperature test data in engineering survey is about 20m generally, namely, the depth range of 0-20m is set according to 1m distance under the column of the test point depth (m) in the Excel worksheet; for example, the depth data of the test points is 20m, namely the depth range of the test points is 0-20m, the depth data of 0-20m is sequentially recorded in the column of the test point depth (m) in the Excel worksheet from top to bottom, the starting depth is set to 0m, the ending depth is set to 20m, and the depth data are sequentially recorded at the interval of 1 m. The test point depth data may also be set to other values according to actual needs, that is, may be set to a depth range of other values, and is not specifically limited herein.
In this embodiment, step 103 is specifically to obtain ground temperature test data according to the depth data of the test point.
In an optional embodiment, the Excel worksheet further comprises a maximum value of the ground temperature, a minimum value of the ground temperature and an average value of the ground temperature, as shown in fig. 1, and the plotting method further comprises:
In this embodiment, the soil layer includes at least one of 1 layer of filling soil, 1 layer of clay, 1 layer of silt silty clay, 1-1 layer of clay silty soil, 1 layer of silt silty clay, and silt silty clay. The soil layer name is at least one of 1 layer of filling soil, 1 layer of clay, 1 layer of silt silty clay, 1-1 layer of clay silty soil, 1 layer of silt silty clay and silt clay.
In the embodiment, the client receives the dividing instruction, divides the test points into a plurality of soil layers according to the dividing instruction and the test point depth data recorded in the Excel worksheet by the user, records corresponding soil layer names into a column of the soil layer names (bottom layer burial depth m) in the Excel worksheet, and merges cells in the Excel worksheets with consistent soil layers.
For example, according to the soil layer information condition obtained by field drilling, the test point is divided into a plurality of soil layers within the depth range of 0-20m and soil layer names (bottom layer burial depth m) are edited. Specifically, 0-1.2m is 1 layer of filling soil, 1.2m-4.0m is 1 layer of clay, 4.0m-6.5m is 1 layer of silty clay, 6.5m-7.0m is 1-1 layer of clay silty soil, 7.0m-9.0m is 1 layer of silty clay, and 9.0m-20.0m is ((r) silty clay).
In the present embodiment, layering is performed according to the depth condition under the soil layer name (bottom burial depth m), and the soil layer division principle is "rounding off" to ensure that no soil layer is lost.
And 1043, acquiring the maximum value of the ground temperature, the minimum value of the ground temperature and the average value of the ground temperature of each soil layer according to the ground temperature test data.
In this embodiment, the client obtains the maximum value, the minimum value and the average value of the ground temperature test data within the depth range of the soil layer respectively by using the same soil layer as a reference. For example: as shown in fig. 2, for the fill of (1), the method for calculating the maximum value of the ground temperature is as follows: inputting 'MAX (C6: C7)' into the column of the soil layer, wherein C6: C7 are within the depth range of the soil layer; the minimum value of the ground temperature is calculated by inputting 'MIN (C6: C7)' in the column of the soil layer, wherein C6: C7 is the depth range of the soil layer; the AVERAGE value of the ground temperature is calculated by inputting 'AVERAGE (C6: C7)' in the column of the soil layer. And so on for the same reason. Until finally calculating the silt clay, inputting the maximum value of the ground temperature into the row of the soil layer, inputting the minimum value of the ground temperature into the row of the soil layer, and inputting the AVERAGE value of the ground temperature into the row of the soil layer, wherein the AVERAGE value of the ground temperature is AVERAGE (C16: C26), and C16: C26 is the depth range of the silt clay distribution.
In this embodiment, the coordinate axis information includes at least one of a depth range, a scale unit, and a scale line type of the test point. When the client side obtains coordinate axis information of a ground temperature curve graph of the test point, specifically, a user double clicks the curve graph in an Excel worksheet, the client side pops up a coordinate axis format setting interface shown in fig. 3, and the user sets information such as a depth range, a scale unit, a scale line type and a ground temperature test data range of the test point on the coordinate axis format setting interface. For example, as shown in fig. 3, the user clicks "fixed" on the minimum value among the coordinate axis options and fills in 15.0; the maximum value is selected to be 'fixed' and is filled in for 20.0, namely the maximum depth is set to be 20.0m, the minimum depth is set to be 15.0m, and the minimum depth can also be set to be other values in the depth range; the main scale unit is selected to be 'fixed' and filled in 1.0; secondary scale unit checking 'automatic' default is 0.2; the inverse sequence scale value and the logarithmic scale can be selected without check, the display unit is selected to be 'none', and the type of the main scale mark is selected to be 'inside'; the type of the secondary scale mark is selected to be 'none'; the coordinate axis label selects "beside axis"; and automatically selecting the coordinate axis value and the maximum coordinate axis value in which the vertical coordinate axes are crossed, clicking and closing the information in the coordinate axis format setting interface after setting, and acquiring the coordinate axis information of the ground temperature curve graph of the test point in the coordinate axis format setting interface by the client at the moment.
In this embodiment, step 104 is to draw a ground temperature curve of the test point according to the ground temperature test data and the coordinate axis information.
In this embodiment, for example, the client creates an Excel worksheet as shown in fig. 2 according to the creation instruction, and if the depth range of the test point is 0-20m, specifically, a first row in the Excel worksheet is named as: header information: a result curve of the ground temperature test in the X # well (namely a test point ground temperature test curve graph in the X # well); the second row is named: and (4) engineering numbering: XXX; the third row is named: the project name is as follows: XXXXX engineering; the first column of the Excel worksheet is named: and (3) measuring point depth (m) (namely measuring point depth), and recording measuring point depth data of 0-20m in sequence from top to bottom at the interval of 1m from the initial depth of 0m in the column. The second column is named: the ground temperature (DEG C) (namely the ground temperature of the test point); the third column is named: soil layer name (bottom buried depth m); the fourth column is named: maximum (. degree. C.) (i.e., maximum geothermal); the fifth column is named: minimum (° c) (i.e., minimum geothermal); column six is named: mean (. degree. C.) (i.e., earth temperature mean); column seven is named: depth-to-ground temperature curve (i.e., test point-to-ground temperature curve). The created Excel worksheet can be used as an Excel worksheet template.
In the embodiment, the client side acquires the ground temperature test data and the coordinate axis information of the ground temperature curve graph of the test point in the created Excel worksheet, and then the ground temperature curve graph of the test point can be drawn according to the ground temperature test data and the coordinate axis information of the ground temperature curve graph of the test point, when the Excel worksheet is used for drawing the ground temperature curve graph of the test points in the later period, the client only needs to adjust the layering condition of the test points again, and the earth temperature test data recorded in the Excel worksheet by the user are obtained, then the maximum earth temperature value, the minimum earth temperature value and the average earth temperature value can be automatically calculated according to the earth temperature test data and automatically drawn into a ground temperature curve graph of the test point, the method for drawing the curve graph is not easy to make mistakes, is convenient for repeated utilization and electronic edition filing, greatly reduces repeated drawing work of machinery, and improves the working efficiency and the accuracy of drawing the curve graph.
Example 2
As shown in fig. 4, the present embodiment provides a system for plotting a ground temperature curve of a test point, where the system includes a first receiving module 1, a creating module 2, a first obtaining module 3, and a plotting module 4.
The first receiving module 1 is used for receiving a creation instruction.
The creating module 2 is used for creating an Excel worksheet according to the creating instruction, and the Excel worksheet comprises geothermal test data.
In this embodiment, the Excel worksheet further includes header information, a project number, and a project name. For example, as shown in fig. 4, header information in an Excel worksheet: a result curve of the ground temperature test in the X # well (namely a test point ground temperature test curve graph in the X # well); and (4) engineering numbering: XXX; the project name is as follows: XXXXX engineering; the header information can be arranged in the first row of the Excel worksheet, and the project number and the project name are arranged below the header information, for example, the second row is named as: and (4) engineering numbering: XXX; the third row is named: the project name is as follows: the xxxxxx project can adjust the location of the project number and the project name as required, and is not limited specifically here.
The first acquisition module 3 is used for acquiring geothermal test data;
in the embodiment, the client acquires the ground temperature test data in the depth range of the test points sequentially recorded by the user from top to bottom in the Excel worksheet.
And the drawing module 4 is used for drawing a ground temperature curve graph of the test point according to the ground temperature test data.
In the embodiment, an Excel worksheet template for drawing the geothermal test curve graph is manufactured by using Microsoft Excel2010 software of the client, after the Excel worksheet template is manufactured, the client only needs to acquire geothermal test data input by a user in the Excel worksheet, and then the geothermal test data can be automatically processed and drawn into the test point geothermal curve graph according to the geothermal test data.
In an alternative embodiment, the Excel worksheet further comprises test point depth data, as shown in fig. 4, and the drawing system further comprises a second obtaining module 5.
The second obtaining module 5 is configured to obtain test point depth data.
In the embodiment, a client acquires test point depth data recorded in an Excel worksheet by a user, and the test depth of the test point ground temperature test data in engineering survey is about 20m generally, namely, the depth range of 0-20m is set according to 1m distance under the column of the test point depth (m) in the Excel worksheet; for example, the depth data of the test points is 20m, namely the depth range of the test points is 0-20m, the depth data of 0-20m is sequentially recorded in the column of the test point depth (m) in the Excel worksheet from top to bottom, the starting depth is set to 0m, the ending depth is set to 20m, and the depth data are sequentially recorded at the interval of 1 m. The test point depth data may also be set to other values according to actual needs, that is, may be set to a depth range of other values, and is not specifically limited herein.
The first obtaining module 3 is specifically configured to obtain ground temperature test data according to the test point depth data.
In an optional embodiment, the Excel worksheet further includes a maximum value of the ground temperature, a minimum value of the ground temperature, and an average value of the ground temperature, as shown in fig. 4, the mapping system further includes a second receiving module 6, a dividing module 7, a third obtaining module 8, and a fourth obtaining module 9.
The second receiving module 6 is used for receiving a dividing instruction.
The dividing module 7 is used for dividing the test point into a plurality of soil layers and combining the same soil layers according to the dividing instruction and the test point depth data.
In this embodiment, the soil layer includes at least one of 1 layer of filling soil, 1 layer of clay, 1 layer of silt silty clay, 1-1 layer of clay silty soil, 1 layer of silt silty clay, and silt silty clay. The soil layer name is at least one of 1 layer of filling soil, 1 layer of clay, 1 layer of silt silty clay, 1-1 layer of clay silty soil, 1 layer of silt silty clay and silt clay.
In the embodiment, the client receives the dividing instruction, divides the test points into a plurality of soil layers according to the dividing instruction and the test point depth data recorded in the Excel worksheet by the user, records corresponding soil layer names into a column of the soil layer names (bottom layer burial depth m) in the Excel worksheet, and merges cells in the Excel worksheets with consistent soil layers.
For example, according to the soil layer information condition obtained by field drilling, the test point is divided into a plurality of soil layers within the depth range of 0-20m and soil layer names (bottom layer burial depth m) are edited. Specifically, 0-1.2m is 1 layer of filling soil, 1.2m-4.0m is 1 layer of clay, 4.0m-6.5m is 1 layer of silty clay, 6.5m-7.0m is 1-1 layer of clay silty soil, 7.0m-9.0m is 1 layer of silty clay, and 9.0m-20.0m is ((r) silty clay).
In the present embodiment, layering is performed according to the depth condition under the soil layer name (bottom burial depth m), and the soil layer division principle is "rounding off" to ensure that no soil layer is lost.
The third obtaining module 8 is used for obtaining the maximum value of the ground temperature, the minimum value of the ground temperature and the average value of the ground temperature of each soil layer according to the ground temperature test data.
In this embodiment, the client obtains the maximum value, the minimum value and the average value of the ground temperature test data within the depth range of the soil layer respectively by using the same soil layer as a reference. For example: as shown in fig. 2, for the fill of (1), the method for calculating the maximum value of the ground temperature is as follows: inputting 'MAX (C6: C7)' into the column of the soil layer, wherein C6: C7 are within the depth range of the soil layer; the minimum value of the ground temperature is calculated by inputting 'MIN (C6: C7)' in the column of the soil layer, wherein C6: C7 is the depth range of the soil layer; the AVERAGE value of the ground temperature is calculated by inputting 'AVERAGE (C6: C7)' in the column of the soil layer. And so on for the same reason. Until finally calculating the silt clay, inputting the maximum value of the ground temperature into the row of the soil layer, inputting the minimum value of the ground temperature into the row of the soil layer, and inputting the AVERAGE value of the ground temperature into the row of the soil layer, wherein the AVERAGE value of the ground temperature is AVERAGE (C16: C26), and C16: C26 is the depth range of the silt clay distribution.
The fourth obtaining module 9 is configured to obtain coordinate axis information of the ground temperature curve graph of the test point according to the maximum ground temperature value, the minimum ground temperature value, and the average ground temperature value.
In this embodiment, the coordinate axis information includes at least one of a depth range, a scale unit, and a scale line type of the test point. When the client side obtains coordinate axis information of a ground temperature curve graph of the test point, specifically, a user double clicks the curve graph in an Excel worksheet, the client side pops up a coordinate axis format setting interface shown in fig. 3, and the user sets information such as a depth range, a scale unit, a scale line type and a ground temperature test data range of the test point on the coordinate axis format setting interface. For example, as shown in fig. 3, the user clicks "fixed" on the minimum value among the coordinate axis options and fills in 15.0; the maximum value is selected to be 'fixed' and is filled in for 20.0, namely the maximum depth is set to be 20.0m, the minimum depth is set to be 15.0m, and the minimum depth can also be set to be other values in the depth range; the main scale unit is selected to be 'fixed' and filled in 1.0; secondary scale unit checking 'automatic' default is 0.2; the inverse sequence scale value and the logarithmic scale can be selected without check, the display unit is selected to be 'none', and the type of the main scale mark is selected to be 'inside'; the type of the secondary scale mark is selected to be 'none'; the coordinate axis label selects "beside axis"; and automatically selecting the coordinate axis value and the maximum coordinate axis value in which the vertical coordinate axes are crossed, clicking and closing the information in the coordinate axis format setting interface after setting, and acquiring the coordinate axis information of the ground temperature curve graph of the test point in the coordinate axis format setting interface by the client at the moment.
The drawing module 4 is specifically used for drawing a ground temperature curve graph of the test point according to the ground temperature test data and the coordinate axis information.
In this embodiment, for example, the client creates an Excel worksheet as shown in fig. 2 according to the creation instruction, and if the depth range of the test point is 0-20m, specifically, a first row in the Excel worksheet is named as: header information: a result curve of the ground temperature test in the X # well (namely a test point ground temperature test curve graph in the X # well); the second row is named: and (4) engineering numbering: XXX; the third row is named: the project name is as follows: XXXXX engineering; the first column of the Excel worksheet is named: and (3) recording test point depth (m) (namely test point depth) in the column from top to bottom at intervals of 1m from the initial depth of 0m, wherein the test point depth data is 0-20 m. The second column is named: the ground temperature (DEG C) (namely the ground temperature of the test point); the third column is named: soil layer name (bottom buried depth m); the fourth column is named: maximum (. degree. C.) (i.e., maximum geothermal); the fifth column is named: minimum (° c) (i.e., minimum geothermal); column six is named: mean (. degree. C.) (i.e., earth temperature mean); column seven is named: depth-to-ground temperature curve (i.e., test point-to-ground temperature curve). The created Excel worksheet can be used as an Excel worksheet template.
In the embodiment, the client side acquires the ground temperature test data and the coordinate axis information of the ground temperature curve graph of the test point in the created Excel worksheet, and then the ground temperature curve graph of the test point can be drawn according to the ground temperature test data and the coordinate axis information of the ground temperature curve graph of the test point, when the Excel worksheet is used for drawing the ground temperature curve graph of the test points in the later period, the client only needs to adjust the layering condition of the test points again, and the earth temperature test data recorded in the Excel worksheet by the user are obtained, then the maximum earth temperature value, the minimum earth temperature value and the average earth temperature value can be automatically calculated according to the earth temperature test data and automatically drawn into a ground temperature curve graph of the test point, the method for drawing the curve graph is not easy to make mistakes, is convenient for repeated utilization and electronic edition filing, greatly reduces repeated drawing work of machinery, and improves the working efficiency and the accuracy of drawing the curve graph.
Example 3
Fig. 5 is a schematic structural diagram of an electronic device according to embodiment 3 of the present invention. The electronic device comprises a memory, a processor and a computer program which is stored on the memory and can run on the processor, and the processor executes the computer program to realize the method for drawing the ground temperature curve graph of the test point in the embodiment 1. The electronic device 30 shown in fig. 5 is only an example, and should not bring any limitation to the functions and the scope of use of the embodiment of the present invention.
As shown in fig. 5, the electronic device 30 may be embodied in the form of a general purpose computing device, which may be, for example, a server device. The components of the electronic device 30 may include, but are not limited to: the at least one processor 31, the at least one memory 32, and a bus 33 connecting the various system components (including the memory 32 and the processor 31).
The bus 33 includes a data bus, an address bus, and a control bus.
The memory 32 may include volatile memory, such as Random Access Memory (RAM)321 and/or cache memory 322, and may further include Read Only Memory (ROM) 323.
The processor 31 executes a computer program stored in the memory 32 to execute various functional applications and data processing, such as a method for plotting a ground temperature curve of a test point provided in embodiment 1 of the present invention.
The electronic device 30 may also communicate with one or more external devices 34 (e.g., keyboard, pointing device, etc.). Such communication may be through input/output (I/O) interfaces 35. Also, the resulting device 30 may also communicate with one or more networks (e.g., a Local Area Network (LAN), a Wide Area Network (WAN), and/or a public network, such as the Internet) via a network adapter 36. As shown in FIG. 5, network adapter 36 communicates with the other modules of model-generating device 30 via bus 33. It should be understood that although not shown in the figures, other hardware and/or software modules may be used in conjunction with the model-generating device 30, including but not limited to: microcode, device drivers, redundant processors, external disk drive arrays, RAID (disk array) systems, tape drives, and data backup storage systems, etc.
It should be noted that although in the above detailed description several units/modules or sub-units/modules of the electronic device are mentioned, such a division is merely exemplary and not mandatory. Indeed, the features and functionality of two or more of the units/modules described above may be embodied in one unit/module according to embodiments of the invention. Conversely, the features and functions of one unit/module described above may be further divided into embodiments by a plurality of units/modules.
Example 4
The present embodiment provides a computer-readable storage medium, on which a computer program is stored, and the computer program, when executed by a processor, implements the steps of the method for drawing a plot of ground temperature of test points provided in embodiment 1.
More specific examples, among others, that the readable storage medium may employ may include, but are not limited to: a portable disk, a hard disk, random access memory, read only memory, erasable programmable read only memory, optical storage device, magnetic storage device, or any suitable combination of the foregoing.
In a possible implementation manner, the present invention can also be implemented in the form of a program product, which includes program code for causing a terminal device to execute the steps of implementing the method for plotting a ground temperature graph of test points described in example 1, when the program product runs on the terminal device.
Where program code for carrying out the invention is written in any combination of one or more programming languages, the program code may be executed entirely on the user device, partly on the user device, as a stand-alone software package, partly on the user device and partly on a remote device or entirely on the remote device.
While specific embodiments of the invention have been described above, it will be appreciated by those skilled in the art that this is by way of example only, and that the scope of the invention is defined by the appended claims. Various changes and modifications to these embodiments may be made by those skilled in the art without departing from the spirit and scope of the invention, and these changes and modifications are within the scope of the invention.
Claims (10)
1. A method for drawing a ground temperature curve graph of a test point is characterized by comprising the following steps:
receiving a creation instruction;
creating an Excel worksheet according to the creating instruction, wherein the Excel worksheet comprises geothermal test data;
acquiring the ground temperature test data;
and drawing a ground temperature curve graph of the test point according to the ground temperature test data.
2. The method for plotting a plot of the ground temperature of test points according to claim 1, wherein the Excel worksheet further comprises test point depth data, the method further comprising:
acquiring the depth data of the test point;
and acquiring the ground temperature test data according to the depth data of the test point.
3. The method for plotting a plot of the ground temperature of test points as recited in claim 2, wherein the Excel worksheet further comprises a maximum ground temperature value, a minimum ground temperature value and an average ground temperature value, the method further comprising:
receiving a dividing instruction;
dividing the test point into a plurality of soil layers and combining the same soil layers according to the dividing instruction and the test point depth data;
acquiring the maximum ground temperature, the minimum ground temperature and the average ground temperature of each soil layer according to the ground temperature test data;
obtaining coordinate axis information of the ground temperature curve graph of the test point according to the maximum ground temperature value, the minimum ground temperature value and the average ground temperature value;
and drawing a ground temperature curve graph of the test point according to the ground temperature test data and the coordinate axis information.
4. The method for plotting the geothermal curve of the test point of claim 3, wherein the soil layer comprises at least one of 1 layer of filling soil, 1 layer of clay, 1 layer of silt silty clay, 1-1 layer of clay silty soil, 1 layer of silt silty clay and silt silty clay;
and/or the presence of a gas in the gas,
the coordinate axis information includes at least one of a depth range, a scale unit and a scale mark type of the test point.
5. The system for drawing the ground temperature curve graph of the test point is characterized by comprising a first receiving module, a creating module, a first obtaining module and a drawing module;
the first receiving module is used for receiving a creating instruction;
the creating module is used for creating an Excel worksheet according to the creating instruction, and the Excel worksheet comprises geothermal test data;
the first acquisition module is used for acquiring the ground temperature test data;
the drawing module is used for drawing the ground temperature curve graph of the test point according to the ground temperature test data.
6. The system for plotting a plot of the ground temperature of test points as in claim 5, wherein if the Excel worksheet further comprises test point depth data, the system for plotting further comprises a second acquisition module;
the second acquisition module is used for acquiring the depth data of the test point;
the first obtaining module is specifically used for obtaining the ground temperature test data according to the test point depth data.
7. The system for drawing a ground temperature curve graph of test points as claimed in claim 6, wherein the Excel worksheet further comprises a maximum ground temperature value, a minimum ground temperature value and an average ground temperature value, and the system further comprises a second receiving module, a dividing module, a third obtaining module and a fourth obtaining module;
the second receiving module is used for receiving a dividing instruction;
the dividing module is used for dividing the test point into a plurality of soil layers and combining the same soil layers according to the dividing instruction and the test point depth data;
the third acquisition module is used for acquiring the maximum value, the minimum value and the average value of the ground temperature of each soil layer according to the ground temperature test data;
the fourth acquisition module is used for acquiring coordinate axis information of the ground temperature curve graph of the test point according to the maximum ground temperature value, the minimum ground temperature value and the average ground temperature value;
the drawing module is specifically used for drawing the ground temperature curve graph of the test point according to the ground temperature test data and the coordinate axis information.
8. The system for plotting test point geothermal plots of claim 7, wherein the soil layers comprise at least one of 1 layer of fill, 1 layer of clay, 1 layer of silt silty clay, 1-1 layer of clay silty soil, 1 layer of silt silty clay, and silt silty clay;
and/or the presence of a gas in the gas,
the coordinate axis information includes at least one of a depth range, a scale unit and a scale mark type of the test point.
9. An electronic device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, wherein the processor implements the method for plotting the temperature profile of test points according to any one of claims 1 to 4 when executing the computer program.
10. A computer-readable storage medium, on which a computer program is stored which, when being executed by a processor, carries out the steps of the method for plotting a plot of the ground temperature of test points as claimed in any one of claims 1 to 4.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110191800.6A CN112767515A (en) | 2021-02-19 | 2021-02-19 | Method, system, equipment and medium for drawing ground temperature curve graph of test point |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110191800.6A CN112767515A (en) | 2021-02-19 | 2021-02-19 | Method, system, equipment and medium for drawing ground temperature curve graph of test point |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN112767515A true CN112767515A (en) | 2021-05-07 |
Family
ID=75705541
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110191800.6A Pending CN112767515A (en) | 2021-02-19 | 2021-02-19 | Method, system, equipment and medium for drawing ground temperature curve graph of test point |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112767515A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113781599A (en) * | 2021-08-23 | 2021-12-10 | 上海市政工程设计研究总院（集团）有限公司 | Method and system for drawing drilling resistivity test result curve |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103605065A (en) * | 2013-10-23 | 2014-02-26 | 上海华力微电子有限公司 | Automatic wafer acceptance test curve output system |
| CN105955939A (en) * | 2016-04-27 | 2016-09-21 | 中国石油大学(华东) | Excel-based method for drawing oblique rose diagram of geologic body and geologic elements |
| CN109063008A (en) * | 2018-07-10 | 2018-12-21 | 武汉华信联创技术工程有限公司 | A kind of shallow layer ground-temperature energy comprehensive monitoring management system |
| CN109751044A (en) * | 2019-01-29 | 2019-05-14 | 河南理工大学 | A kind of oil area heat reservori top surface temperature isogram preparation method |
-
2021
- 2021-02-19 CN CN202110191800.6A patent/CN112767515A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103605065A (en) * | 2013-10-23 | 2014-02-26 | 上海华力微电子有限公司 | Automatic wafer acceptance test curve output system |
| CN105955939A (en) * | 2016-04-27 | 2016-09-21 | 中国石油大学(华东) | Excel-based method for drawing oblique rose diagram of geologic body and geologic elements |
| CN109063008A (en) * | 2018-07-10 | 2018-12-21 | 武汉华信联创技术工程有限公司 | A kind of shallow layer ground-temperature energy comprehensive monitoring management system |
| CN109751044A (en) * | 2019-01-29 | 2019-05-14 | 河南理工大学 | A kind of oil area heat reservori top surface temperature isogram preparation method |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113781599A (en) * | 2021-08-23 | 2021-12-10 | 上海市政工程设计研究总院（集团）有限公司 | Method and system for drawing drilling resistivity test result curve |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107562833B (en) | Contour line-based numerical model modeling method for complex terrain three-dimensional discrete unit method | |
| CN102609525B (en) | Method for dissecting and unifying geographic grid based on longitude and latitude | |
| US8793107B2 (en) | Accuracy-based significant point derivation from dense 3D point clouds for terrain modeling | |
| US20150363508A1 (en) | Grid-based analysis of geospatial trajectories | |
| Mortensen et al. | Wind atlas analysis and application program: WAsP 10 Help facility | |
| CN103699634A (en) | Database creation method and database creation system for one-stop pipeline detection | |
| Mortensen et al. | Wind atlas analysis and application program: WAsP 11 help facility | |
| CN111783304A (en) | Simulation analysis method and device for mine, equipment and storage medium | |
| CN112862967B (en) | Method and device for establishing three-dimensional geological model | |
| AU2013389292A1 (en) | Basin-to-reservoir modeling | |
| CN110826173A (en) | Soil moisture data acquisition method and system, storage medium and equipment | |
| CN102156796B (en) | Device and method for determining wind conditions using multiple wind resource grids | |
| CN112767515A (en) | Method, system, equipment and medium for drawing ground temperature curve graph of test point | |
| CN113807062A (en) | Online drawing method and device for combined density map and electronic equipment | |
| CN111243088A (en) | True three-dimensional aerial remote sensing geological interpretation method and system in engineering geological investigation | |
| CN115631423A (en) | Remote sensing satellite coverage prediction method considering meteorological prediction cloud picture and sensor measurement pendulum | |
| CN110706340B (en) | Pipeline three-dimensional visualization platform based on real geographic data | |
| CN105260389B (en) | A kind of unmanned plane reconnaissance image data management and visual display method | |
| Su et al. | Applying cloud computing and internet of things technologies to develop a hydrological and subsidence monitoring platform | |
| CN112906239B (en) | Comprehensive pipe rack safety state evaluation method and device, processor and storage medium | |
| CN116108516A (en) | Method for creating and integrating partitioned building information model of point cloud | |
| CN115408750A (en) | Power transmission line measurement finished product diagram generation method, device, equipment and storage medium | |
| CN114722624A (en) | Digital twin-based visual simulation system and application thereof | |
| CN103514569A (en) | Food crop yield visualization novel method based on GIS technology | |
| Mortensen | 46200 Planning and Development of Wind Farms: Wind resource assessment using the WAsP software |
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 | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20210507 |