System and method for calculating autogenous volume deformation of concrete by one key

Abstract

The invention belongs to the technical field of computer software and engineering experiment data calculation, and discloses a system and a method for one-key calculation of concrete autogenous volume deformation, the system for one-key calculation of concrete autogenous volume deformation comprises a deformation calculation module and a process diagram drawing module, wherein the deformation calculation module is used for realizing data loading display, one-key calculation, interpolation calculation and data area emptying; and the process graph drawing module is used for realizing one-key drawing, graph attribute self-definition and preview export. According to the method, traditional manual operation of Excel for calculation is replaced, the calculation efficiency is improved, and the error rate is reduced.

Description

Technical Field

[0001] The present invention belongs to the technical field of computer software and engineering experiment data calculation, and particularly relates to a system and method for calculating the autogenous volume deformation of concrete with one key. Background Art

[0002] With the booming development of infrastructure construction in China, large-scale water conservancy and hydropower projects, river bridges, subways, high-speed rails, high-rise buildings and other projects have emerged continuously. The structural material concrete of these buildings is prone to deformation under special service environment conditions and complex stress states, which often leads to cracking and seriously affects the function and service life. In order to ensure the quality of the project, according to the specification requirements, it is necessary to conduct autogenous volume deformation experiments on concrete to evaluate the durability and stability of concrete. At present, this experimental calculation work uses Excel to record the experimental parameters and original experimental data, and manually operates the file for calculation. There are problems such as inconsistent Excel file versions, time-consuming and laborious data verification and inspection, easy interruption due to large amount of data dragged by the mouse during calculation, and manual setting of data sources for the process line. The calculation efficiency is low and the error rate is high. Summary of the Invention

[0003] The purpose of the present invention is to provide a system and method for calculating the autogenous volume deformation of concrete with one key, which replaces the traditional manual operation of Excel for calculation, improves the calculation efficiency and reduces the error rate.

[0004] The technical solution adopted by the present invention is a system for calculating the autogenous volume deformation of concrete with one key, including a deformation amount calculation module and a process line graph drawing module, wherein:

[0005] The deformation amount calculation module is used to realize data loading and display, one-key calculation, interpolation calculation and clearing the data area;

[0006] The process line graph drawing module is used to realize one-key drawing, customizing chart attributes and previewing and exporting.

[0007] Further, the deformation amount calculation module includes data loading and display, one-key calculation, interpolation calculation and clearing the data area; the data loading and display is used to load the Excel template stored in the database and display the experimental data of the autogenous volume deformation of concrete in the Excel file; the one-key calculation is used to batch calculate the age, age increment verification, temperature of specimen 1, temperature of specimen 2, autogenous change of specimen 1, autogenous change of specimen 2 and average autogenous change; the interpolation calculation is used to deduce the autogenous change of the input custom age; the clearing the data area is used to quickly clear the original experimental data of the autogenous volume deformation of concrete in the Excel file.

[0008] Furthermore, the experimental data of the autogenous volume deformation of the concrete includes initial parameters, the amount of experimental data, and the amount of data to be calculated, where:

[0009] The initial parameters include the specimen number, the coefficient of linear expansion of concrete β, the strain gauge number, the resistance at 0°C R0, the strain sensitivity F, the temperature constant a, and the temperature correction coefficient b;

[0010] The amount of experimental data includes the date, time, the resistance of specimen 1 R1, the resistance ratio of specimen 1 Z1, the resistance of specimen 2 R2, and the resistance ratio of specimen 2 Z2;

[0011] The amount of data to be calculated includes the age d, the temperature of specimen 1, the autogenous deformation of specimen 1, the temperature of specimen 2, the autogenous deformation of specimen 2, and the average autogenous deformation.

[0012] Furthermore, the formulas for batch calculating the age, the temperature of specimen 1, the temperature of specimen 2, the autogenous deformation of specimen 1, the autogenous deformation of specimen 2, and the average autogenous deformation in the one-key calculation are as follows:

[0013] The age calculation formula for the i-th row: Age (i) =(Date (i) - Date (0) )+(Time (i) - Time (0) );

[0014] The specimen temperature calculation formula for the i-th row: Specimen temperature (i) =(Resistance (i) - Resistance at 0°C)×Temperature constant;

[0015] The specimen autogenous deformation calculation formula for the i-th row: Specimen autogenous deformation (i) =Response sensitivity×(Resistance ratio (i) - Resistance ratio (0) )+(Temperature correction coefficient - Coefficient of linear expansion of concrete)×(Specimen temperature (i) - Specimen temperature (0) );

[0016] The average autogenous deformation calculation formula for the i-th row: Average autogenous deformation (i) =(Autogenous deformation of specimen 1 (i) + Autogenous deformation of specimen 2 (i) )÷2.

[0017] Furthermore, the formula for interpolation calculation is as follows:

[0018] The autogenous deformation calculation formula for the age x to be calculated: Autogenous deformation (x) =Average autogenous deformation (x前) +(Age (x) - Age (x前) )÷(Age (x后) - Age (x前) )×(Average autogenous deformation (x后)-Average independent variable (x前) )。

[0019] Furthermore, the process line chart drawing module includes one - key drawing, chart property customization, and preview and export. The one - key drawing is used to draw three concrete autogenous volume deformation process line charts with age as the abscissa and the independent variables of Specimen 1, Specimen 2, and the average independent variable as the ordinates. The chart property customization is used to configure a series of properties of the concrete autogenous volume deformation process line chart and store them in the database for direct calling next time. The preview and export is used to set the size of the concrete autogenous volume deformation process line chart and export it as a picture.

[0020] A method for one - key calculation of concrete autogenous volume deformation, implemented through the above - mentioned system for one - key calculation of concrete autogenous volume deformation, includes the following steps:

[0021] S1. In the deformation quantity calculation module, load the Excel template stored in the database through the SpreadSheet component and display the experimental data of the concrete autogenous volume deformation in the Excel file.

[0022] S2. After confirming that the experimental data is correct, call the one - key batch verification calculation method to calculate the age, temperature of Specimen 1, temperature of Specimen 2, independent variable of Specimen 1, independent variable of Specimen 2, and average independent variable.

[0023] S3. Switch to the process line chart drawing module. In the process line chart drawing module, organize the independent variables of Specimen 1, Specimen 2, and the average independent variable in the SpreadSheet component into three arrays required for the concrete autogenous volume deformation process line chart, set them into the ChartControl component, and draw three concrete autogenous volume deformation process line charts with age as the abscissa and the independent variables of Specimen 1, Specimen 2, and the average independent variable as the ordinates.

[0024] S4. Configure a series of properties of the concrete autogenous volume deformation process line chart and store them in the database for direct calling next time.

[0025] S5. Set the size of the concrete autogenous volume deformation process line chart and export it as a picture.

[0026] Furthermore, in S2, the one - key batch verification calculation method is specifically as follows: Set the calculation formula Formula of the first row in a programming way, and then call the copy function CopyFrom to copy the formula of the first row to all the remaining cells to achieve fast calculation.

[0027] The beneficial effects of the present invention are as follows:

[0028] (1). The system embeds an Excel template and is seamlessly docked with the original data;

[0029] (2) The algorithm realizes the one - key calculation function, reduces the manual dragging calculation amount and improves the efficiency;

[0030] (3) The one - key drawing accurately binds the dynamic data source, avoiding manual adjustment of the data range;

[0031] (4) The system controls the Excel template and calculation rules to ensure the unity of version and algorithm;

[0032] In summary, the present invention provides a method and a system design idea for calculating the autogenous volume deformation of concrete, replacing the traditional way of calculating by manually operating Excel, improving the calculation efficiency, reducing the error rate, and generating objective economic and social benefits, with broad application prospects and development space. BRIEF DESCRIPTION OF THE DRAWINGS

[0033] Figure 1 It is a flowchart of the method for calculating the autogenous volume deformation of concrete with one - key calculation according to the present invention;

[0034] Figure 2 It is a schematic diagram of the Excel template file of the system for calculating the autogenous volume deformation of concrete with one - key calculation according to the present invention;

[0035] Figure 3 It is a schematic diagram of the interface of the deformation amount calculation module of the system for calculating the autogenous volume deformation of concrete with one - key calculation according to the present invention;

[0036] Figure 4 It is a schematic diagram of the interface for drawing the process line of the system for calculating the autogenous volume deformation of concrete with one - key calculation according to the present invention;

[0037] Figure 5 It is a schematic diagram of the interface for customizing the chart properties of the system for calculating the autogenous volume deformation of concrete with one - key calculation according to the present invention;

[0038] Figure 6 It is a schematic diagram of the preview and export interface of the system for calculating the autogenous volume deformation of concrete with one - key calculation according to the present invention. DETAILED DESCRIPTION OF THE EMBODIMENTS

[0039] In order to make the purpose, technical solutions and advantages of the present invention clearer and more understandable, the technical solutions of the present invention will be further described in detail below with reference to the drawings.

[0040] A system for calculating the autogenous volume deformation of concrete with one - key calculation includes a deformation amount calculation module and a process line graph drawing module.

[0041] Deformation amount calculation module

[0042] The deformation amount calculation module is used to realize data loading and display, one - key calculation, interpolation calculation and clearing the data area.

[0043] The deformation calculation module includes data loading and display, one-key calculation, interpolation calculation, and clearing the data area.

[0044] The data loading and display is used to load the Excel template stored in the database and display the experimental data of the autogenous volume deformation of concrete in the Excel file.

[0045] The experimental data of the autogenous volume deformation of concrete includes initial parameters, the amount of experimental data, and the amount of data to be calculated.

[0046] The initial parameters include the specimen number, the coefficient of linear expansion of concrete β, the strain gauge number, the resistance R0 at 0°C, the strain sensitivity F, the temperature constant a, and the temperature correction coefficient b.

[0047] The amount of experimental data includes the date, time, the resistance R1 of specimen 1, the resistance ratio Z1 of specimen 1, the resistance R2 of specimen 2, and the resistance ratio Z2 of specimen 2.

[0048] The amount of data to be calculated includes the age d, the temperature of specimen 1, the autogenous deformation of specimen 1, the temperature of specimen 2, the autogenous deformation of specimen 2, and the average autogenous deformation.

[0049] The one-key calculation is used to batch calculate the age, age increment verification, the temperature of specimen 1, the temperature of specimen 2, the autogenous deformation of specimen 1, the autogenous deformation of specimen 2, and the average autogenous deformation.

[0050] Age increment verification: Since the experimental period is long and the amount of data is large, there may be errors or disorder in the recording order when manually recording data, resulting in the age not increasing normally. Therefore, it is necessary to judge each row of the age column to determine whether the age of the current row is greater than the age of the previous experiment. If it is greater, it is normal; if it is less, it is abnormal data, and the system will give a prompt during the verification process.

[0051] Among them, the autogenous deformation is the autogenous volume deformation, which is the deformation that occurs over time without external force.

[0052] The interpolation calculation is used to calculate the autogenous deformation of the custom age input.

[0053] The clearing of the data area is used to quickly clear the original experimental data of the autogenous volume deformation of concrete in the Excel file.

[0054] In an exemplary embodiment, the one-key calculation: performs age calculation, specimen 1 temperature calculation, specimen 1 autogenous deformation calculation, specimen 2 temperature calculation, specimen 2 autogenous deformation calculation, and average autogenous deformation calculation; the interpolation calculation: after the one-key calculation is completed, input the age to be calculated (the custom age number input after calculating the autogenous deformation), and click the interpolation calculation to calculate the autogenous deformation corresponding to the age to be calculated (the deformation after interpolation calculation); the clearing of the data area: clears all the data starting from the 8th row downwards, and the respective calculation formulas are as follows:

[0055] Age calculation formula for the i-th row: Age (i) =(Date (i) -Date (0) )+(Time (i) -Time (0) );

[0056] Specimen temperature calculation formula for the i-th row: Specimen temperature (i) =(Resistance (i) -Resistance at 0°C)×Temperature constant;

[0057] Specimen self-variation calculation formula for the i-th row: Specimen self-variation (i) =Reaction sensitivity×(Resistance ratio (i) -Resistance ratio (0) )+(Temperature correction coefficient - Concrete linear expansion coefficient)×(Specimen temperature (i) -Specimen temperature (0) );

[0058] Average self-variation calculation formula for the i-th row: Average self-variation (i) =(Self-variation of Specimen 1 (i) +Self-variation of Specimen 2 (i) )÷2;

[0059] Self-variation calculation formula for the age x to be calculated: Self-variation (x) =Average self-variation (x前) +(Age (x) -Age (x前) )÷(Age (x后) -Age (x前) )×(Average self-variation (x后) -Average self-variation (x前) ), where:

[0060] Self-variation (x) : Autogenous volume deformation of the age x to be calculated;

[0061] Age (x前) : Age less than the age x to be calculated;

[0062] Age (x后) : Age greater than the age x to be calculated;

[0063] Average self-variation (x前) : Average self-variation of the age less than the age x to be calculated;

[0064] Average self-variation (x后) : Average self-variation of the age greater than the age x to be calculated.

[0065] The principle of realizing batch calculation (one-key batch verification calculation method) is as follows: Set the calculation formula (Formula) of the first row in a programming way, and then call the copy function CopyFrom(CellRange source) to copy the formula of the first row to all the remaining cells to achieve fast calculation.

[0066] Process line chart drawing module

[0067] The process line chart drawing module is used to realize one-key drawing, customizing chart properties and previewing and exporting.

[0068] The process line chart drawing module includes one-key drawing, customizing chart properties and previewing and exporting.

[0069] One-key drawing is used to draw three concrete autogenous volume deformation process line charts with age as the abscissa and the self-variations of Specimen 1, Specimen 2 and the average self-variation as the ordinates.

[0070] Customizing chart properties is used to configure a series of properties (title, series, plot area, appearance, coordinate axes, etc.) of the concrete autogenous volume deformation process line chart and store them in the database for direct calling next time.

[0071] Previewing and exporting is used to set the size of the concrete autogenous volume deformation process line chart and export it as a picture.

[0072] A method for one-key calculating the autogenous volume deformation of concrete, as Figure 1 shown, includes the following steps:

[0073] S1. In the deformation quantity calculation module, load the Excel template stored in the database through the SpreadSheet component and display the experimental data of the autogenous volume deformation of concrete in the Excel file (as Figure 2 shown).

[0074] S2. After confirming that the experimental data is correct (if the experimental data is incorrect, it can be directly edited and modified), call the one-key batch verification calculation method to calculate the age, the temperature of Specimen 1, the temperature of Specimen 2, the self-variation of Specimen 1, the self-variation of Specimen 2 and the average self-variation (as Figure 3 shown).

[0075] S3. Switch to the process line chart drawing module. In the process line chart drawing module, organize the self-variations of Specimen 1, Specimen 2 and the average self-variation in the SpreadSheet component into three arrays required for the concrete autogenous volume deformation process line chart, set them into the ChartControl component, and draw three concrete autogenous volume deformation process line charts with age as the abscissa and the self-variations of Specimen 1, Specimen 2 and the average self-variation as the ordinates (as Figure 4 shown).

[0076] S4, Configure a series of attributes (such as title, series, plotting area, appearance, and coordinate axes, etc.) of the autogenous volume deformation process line graph of concrete (as Figure 5 shown) and store them in the database for direct call next time.

[0077] S5, Set the size of the autogenous volume deformation process line graph of concrete and export it as a picture (as Figure 6 shown).

Claims

1. A system for calculating the autogenous volume deformation of concrete with one key, characterized in that, It includes a deformation calculation module and a process line diagram drawing module, among which: The deformation calculation module is used to realize data loading display, one-key calculation, interpolation calculation and clearing data area; The process line diagram drawing module is used to achieve one-click drawing, chart property customization and preview export.

2. The system for calculating the autogenous volume deformation of concrete with one key according to claim 1, characterized in that, The deformation calculation module includes data loading display, one-key calculation, interpolation calculation and clearing data area; the data loading display is used to load the Excel template stored in the database and display the experimental data of concrete autogenous volume deformation in the Excel file; the one-key calculation is used to batch calculate age, age increment verification, specimen 1 temperature, specimen 2 temperature, specimen 1 self-variation, specimen 2 self-variation and average self-variation; the interpolation calculation is used to infer the input custom age self-variation; the clearing data area is used to quickly clear the experimental original data of concrete autogenous volume deformation in the Excel file.

3. The system for calculating the autogenous volume deformation of concrete with one key according to claim 2, wherein, The experimental data of the concrete autogenous volume deformation includes initial parameters, experimental data volume and data volume to be calculated, wherein: The initial parameters include specimen number, concrete linear expansion coefficient β, strain gauge number, 0℃ resistance R0, strain sensitivity F, temperature constant a and temperature correction coefficient b; The experimental data include date, time, specimen 1 resistance R1, specimen 1 resistance ratio Z1, specimen 2 resistance R2 and specimen 2 resistance ratio Z2; The data that need to be calculated include age d, specimen 1 temperature, specimen 1 independent variation, specimen 2 temperature, specimen 2 independent variation and average independent variation.

4. The system for calculating the autogenous volume deformation of concrete with one key according to claim 2, characterized in that, The formula for batch calculation of age, temperature of specimen 1, temperature of specimen 2, independent variable of specimen 1, independent variable of specimen 2 and average independent variable in the one-key calculation is: The calculation formula for the age of the i-th row: age (i) =(date (i) -date (0) )+(time (i) -time (0) ); Calculation formula for the temperature of the specimen in the i-th row: Specimen temperature (i) =(resistance (i) -resistance at 0°C)×temperature constant; Self-variation calculation formula for the i-th row of specimens: Specimen self-variation (i) = Response sensitivity × (Resistance ratio (i) - Resistance ratio (0) ) + (Temperature correction coefficient - Concrete linear expansion coefficient) × (Specimen temperature (i) - Specimen temperature (0) ); Average independent variable calculation formula for the i-th row: average independent variable (i) = (Independent variable of Specimen 1 (i) + Independent variable of Specimen 2 (i) ) ÷ 2.

5. The system for calculating the autogenous volume deformation of concrete with one key according to claim 2, characterized in that The interpolation calculation formula is: Independent variable calculation formula for the age to be calculated x: Independent variable (x) = Average independent variable (x前) + (Age (x) - Age (x前) ) ÷ (Age (x后) - Age (x前) ) × (Average independent variable (x后) - Average independent variable (x前) ).

6. The system for calculating the autogenous volume deformation of concrete with one key according to claim 1, characterized in that, The process line diagram drawing module includes one-click drawing, chart attribute customization and preview export; the one-click drawing is used to draw three concrete autogenous volume deformation process line diagrams with age as the horizontal coordinate and specimen 1 independent change, specimen 2 independent change and average independent change as the vertical coordinate; the chart attribute customization is used to configure a series of attributes of the concrete autogenous volume deformation process line diagram and store them in the database for direct call next time; the preview export is used to set the size of the concrete autogenous volume deformation process line diagram and export it as a picture.

7. A method for calculating the autogenous volume deformation of concrete with one key, which is implemented by the system for calculating the autogenous volume deformation of concrete with one key according to any one of claims 1-6, characterized in that, The following steps are involved: S1, in the deformation calculation module, the Excel template stored in the database is loaded through the SpreadSheet component and the experimental data of the concrete autogenous volume deformation in the Excel file is displayed; S2, after confirming that the experimental data is correct, call the one-key batch verification calculation method to calculate the age, specimen 1 temperature, specimen 2 temperature, specimen 1 independent variable, specimen 2 independent variable and average independent variable; S3, switching to the process line diagram drawing module, in which the specimen 1 independent variable, specimen 2 independent variable and average independent variable in the SpreadSheet component are organized into three arrays required for the concrete autogenous volume deformation process line diagram, and set to the ChartControl component to draw three concrete autogenous volume deformation process line diagrams with age as the horizontal axis and specimen 1 independent variable, specimen 2 independent variable and average independent variable as the vertical axis; S4. Configure a series of attributes of the autogenous volume deformation process line diagram of the concrete and store them in the database for direct calling next time; S5. Set the size of the autogenous volume deformation process line diagram of the concrete and export it as a picture.

8. The method for calculating the autogenous volume deformation of concrete with one key according to claim 7, characterized in that In the above S2, the one-key batch verification calculation method is specifically as follows: Set the calculation formula Formula of the first row in a programming manner, and then call the copy function CopyFrom to copy the formula of the first row to all the remaining cells to achieve rapid calculation.

Images