Concrete information acquisition and mapping method and report generation system therefor

Abstract

The present application provides a concrete information acquisition and graphing method and a report generating system thereof, which calculates an estimated compressive strength based on ultrasonic transmission velocity test data of a concrete structure input in an Excel file, and automatically calculates various values and graphs related thereto, thereby facilitating report making and the like, including the steps of inputting test values and test conditions into an Excel file; a test value and test condition saving stage; opening the Excel file; acquiring concrete information; drawing a graph setting; and outputting values and graphs of the ultrasonic transmission velocity test values, ultrasonic arrival time variation with respect to a trigger distance, ordinary concrete estimated compressive strength, and design reference strength and strength rate values drawn at the graph drawing setting stage through identifiers.

Description

Technical Field

[0001] This invention relates to a method for acquiring and visualizing concrete information based on an Excel file containing input data from ultrasonic wave transmission velocity tests in concrete, and a system for generating reports using this method.

[0002] This invention provides a more detailed explanation. Based on the test data of ultrasonic transmission speed of concrete structures input into the computer system and Excel file, it calculates the estimated compressive strength, etc., and automatically calculates various related values ​​and charts, which facilitates report creation and other tasks. Background Technology

[0003] Generally, structures must be constructed using concrete and steel reinforcement, as well as a variety of other materials, and therefore must be durable, watertight, and safe.

[0004] The concrete used to construct these structures must maintain appropriate compressive strength, depending on the characteristics of the structure to be constructed. In particular, the compressive strength of the concrete must be measured before or after the construction of the structure.

[0005] In other words, accurately measuring the compressive strength of a structure is essential for ensuring safety in subsequent work, but accurate measurement has always been very difficult. As the curing environment, which influences the compressive strength performance of concrete structures, changes, it is necessary to develop a technology that can more accurately measure the compressive strength of structures while being easy to measure and having minimal impact on subsequent engineering work.

[0006] In addition, previously, for example, if data charts were required to be attached to exam reports, since there was no separate procedure, the data had to be compared manually one by one, and the charts had to be attached after creation. This was not only time-consuming, but also reduced work efficiency.

[0007] Korean Patent Publication No. 10-2004-0100384 discloses a method for extracting line information and title information from ISO drawings of pipelines generated using the ISO generation function of the 3D modeling program PDS (Plant Design System). This method utilizes Excel's VBA and MicroStation Basic to automatically extract each line of information and title information from the pipeline in the PDS program. It can not only automatically extract the corresponding drawings and drawing information, but also quickly extract ISO drawings and drawing information, thus preventing operator errors.

[0008] Korean Patent Publication No. 10-2006-0036024 issues documents for investigating various statistical business-related data and connects them with a higher-level terminal for printing statistical processing reports; multiple sub-terminals for reporting investigation data related to the content of the documents issued by the higher-level terminal; and a process management server that allows the higher-level terminal to easily fill in the forms required for the data investigation, while automatically and simplifying the data summary work reported by the sub-terminals, summarizing and outputting the reports in real time to the higher-level terminal immediately after reporting, and managing the entire project's workflow management server to report the investigation content to the sub-terminals; as a real-time data summary project management system composed of these components, the process management server is characterized by storing the data from the higher-level terminal in multiple formats such as Korean, Excel, and Word as HTML format, and outputting the data reports from the sub-terminals in multiple formats such as Korean and Excel. The sub-terminals do not need to create separate forms for the issued data investigation; they only need to manage the input data on the network to perform real-time data summary management for the project, thereby achieving integration with the data management of the higher-level terminal. The transfer / processing of official documents between subordinate organizations is time-consuming and inefficient. Automated data aggregation saves human and material resources; effective data management through regular and on-demand reporting allows for real-time progress monitoring and appropriate responses; and real-time business processing via the internet improves decision-making and information efficiency.

[0009] Korean Patent Publication No. 10-2006-0089925 describes a process data management method that includes: a stage for experimentally determining the exposure time and focus conditions of a photolithography process; a step for automatically measuring the critical linewidth of a given measurement mode, including taking photos corresponding to the time and surrounding areas; a step for automatically measuring the critical linewidth of the measurement mode based on the focus conditions for the exposure time, and automatically taking a contour photograph of the measurement mode to save the data; and a method for converting the stored data into a common formatted file using macro functions. This method allows for the systematic and convenient application of the automatic functions of the critical linewidth measurement equipment and the macro functions of the software to automatically implement process data, thereby improving production efficiency, when setting process conditions in the photolithography process.

[0010] Existing technical documents

[0011] Patent documents

[0012] Patent Document 1: Korean Patent Publication No. 10-2004-0100384 (Published on December 2, 2004, Title: PDS-ISO Drawing Information Extraction Method)

[0013] Patent Document 2: Korean Patent Publication No. 10-2006-0036024 (Published on April 27, 2006, Title: Real-time Data Summary Project Management System and Management Method Thereof)

[0014] Patent Document 3: Korean Patent Publication No. 10-2006-0089925 (Published on August 10, 2006, Title: Engineering Data Management Method) Summary of the Invention

[0015] The problem that the invention aims to solve

[0016] The purpose of this invention is to calculate the estimated compressive strength of concrete structures based on ultrasonic transmission speed test data of concrete structures input into a computer system and an Excel file, and to automatically calculate various related values ​​and graphs, providing a method for obtaining and graphical representation of concrete information based on Excel files for report preparation and other tasks, so as to facilitate its use.

[0017] Another objective of this invention is to provide a system for obtaining concrete information based on an Excel file containing concrete rebound hardness test data and generating reports using a graphical method. This system allows concrete ultrasonic transmission speed test data to be used to obtain concrete information based on an input Excel file and automatically generates reports based on the input Excel file.

[0018] The technical issues of this invention are not limited to those mentioned above. Other unmentioned technical issues can be clearly understood by the owner from the following description.

[0019] means for solving problems

[0020] To achieve the aforementioned objective, the method for acquiring and visualizing concrete information based on an Excel file containing input data from concrete ultrasonic transmission velocity tests is characterized by the following steps:

[0021] To test the ultrasonic transmission speed in concrete, input the test values ​​and test conditions, then input the test values ​​and test conditions into an Excel file so that the test values ​​can be stored in memory via the Excel file;

[0022] The test values ​​and test conditions entered in the Excel file are saved in memory.

[0023] The steps to open an Excel file include loading the Excel file stored in the memory;

[0024] Based on the test values ​​and test conditions in the Excel file, concrete information is obtained by calculating concrete information such as ultrasonic transmission speed test value, ultrasonic arrival time at the detector distance, estimated compressive strength of ordinary concrete, design reference strength, and strength rate.

[0025] In the drawing setup phase, the drawing module is used to set the experimental values ​​of ultrasonic wave transmission speed, the time it takes for the ultrasonic wave to reach the trigger, and the graphical drawing environment for the estimated compressive strength of ordinary concrete; and

[0026] The graphic output of the ultrasonic transmission speed test value, the time for ultrasonic waves to reach the trigger, the estimated compressive strength of ordinary concrete, the design reference strength, and the strength rate value, which are plotted in the graphic drawing setup stage, is output through the identifier.

[0027] In this invention, the drawing module is characterized by being composed of a drawing module and a spacing change module, which respectively draw the basic X-axis and Y-axis to draw graphics in the program, and a spacing change module for changing the spacing between the X-axis and Y-axis.

[0028] In this invention, the ultrasonic transmission speed is characterized by calculation using both surface and direct methods.

[0029] To achieve the aforementioned objective, based on an Excel file containing experimental data of ultrasonic transmission velocity in concrete, the following steps are performed using concrete information acquisition and visualization methods:

[0030] To test the ultrasonic transmission speed in concrete, input the test values ​​and test conditions, then input the test values ​​and test conditions into an Excel file so that the test values ​​can be stored in memory via the Excel file;

[0031] The test values ​​and test conditions entered in the Excel file are saved in memory.

[0032] The steps to open an Excel file include loading the Excel file stored in the memory;

[0033] Based on the test values ​​and test conditions in the Excel file, concrete information acquisition stage, such as ultrasonic transmission speed test value, distance of the detector from the ultrasonic wave arrival time, estimated compressive strength of ordinary concrete, design reference strength, strength rate and other concrete information;

[0034] In the drawing setup phase, the drawing module is used to set the experimental values ​​of ultrasonic wave transmission speed, the time it takes for the ultrasonic wave to reach the trigger, and the graphical drawing environment for the estimated compressive strength of ordinary concrete; and

[0035] The graphical output stage includes the plotting of the ultrasonic transmission velocity test values, the ultrasonic arrival time based on the detector distance, the estimated compressive strength and design reference strength of ordinary concrete, and the strength values ​​output via indicators.

[0036] The report generation system includes:

[0037] DB stores test object information, including structure name, structure division, components, and detailed segment data of components.

[0038] Test data DB12 includes the ultrasonic transmission velocity calculated based on the test location, the ultrasonic arrival time calculated based on the distance to the detector, the estimated compressive strength, the comparison with the design strength of each component location, and the stored strength rate data.

[0039] The concrete information stored in the Excel file is obtained as the information required to generate the report and stored in the test object information acquisition section of the test object information database;

[0040] The test data acquisition unit acquires and stores the concrete information stored in the Excel file as the information required to generate the report in the test data database; and

[0041] The report generation section includes a graphics generation processor and a report generation processor.

[0042] In this invention, the report generation processor generates a file in a preset report format by adding explanations to the test results.

[0043] Generate a Word document report file, including graphs and necessary analysis annotations.

[0044] The graphics generated by the graphics generation processor are compared and analyzed with the stored standard data, and the analysis results of the structural aging state are included in the report file.

[0045] Invention Effects

[0046] The present invention relates to a method for acquiring and visualizing concrete information based on an input Excel file for ultrasonic transmission velocity test data of concrete, and a system for generating reports using that file. Based on the ultrasonic transmission velocity test data of the concrete structure compiled in the computer system and the Excel file, the estimated compressive strength, etc., are calculated, and various related values ​​and graphs are automatically calculated, facilitating report production and other tasks.

[0047] In other words, in the traditional method of only looking at numerical data, administrators need to continuously check the numerical data, which is inconvenient. However, the advantage of this invention is that administrators can conveniently view concrete information by referring to charts.

[0048] In addition, reports are automatically generated based on concrete information such as concrete ultrasonic transmission speed test data obtained from the organized Excel file, which is very convenient.

[0049] In addition to the above, the specific effects of the present invention will be described in conjunction with the explanation of the specific matters of implementing the invention below. Attached Figure Description

[0050] Figure 1 According to an example of the present invention, concrete information and a diagram of the graphical device are obtained based on an Excel file containing test data of ultrasonic transmission speed in concrete.

[0051] Figure 2 According to one embodiment of the present invention, concrete information and a graphical flowchart are obtained by using an Excel file containing test data of ultrasonic transmission speed in concrete.

[0052] Figure 3 and Figure 4 This is a graph of the test data information of the ultrasonic transmission speed of concrete entered into an Excel file, according to an example of the present invention.

[0053] Figure 5 and Figure 6 This is a graph illustrating the estimated compressive strength calculated from ultrasonic transmission velocity test data of the superstructure according to an embodiment of the present invention, using numerical values ​​and graphs. Figure 5 This indicates that the floor is related to S1. Figure 6 This indicates that the floor is related to S2.

[0054] Figure 7 This is an example of the present invention, based on the test data of ultrasonic transmission speed of concrete entered into an Excel file, and is a graph representing the estimated compressive strength, design reference strength, and stiffness ratio in numerical and graphical form.

[0055] Figure 8 This is a control composition diagram of an automatic test report generation device according to an example of the present invention.

[0056] Figure 9 This is a flowchart illustrating the process of automatically generating test reports according to an embodiment of the present invention.

[0057] The drawings illustrate specific embodiments of the invention, which are described in more detail below. These drawings are not intended to limit the scope of the invention in any way, but are provided to enable those skilled in the art to understand the concept of the invention by referring to particular embodiments.

[0058] Explanation of reference numerals in the attached figures

[0059] 10: Report generation equipment 11: Test subject information DB

[0060] 12: Exam Data Database 13: Exam Candidate Information Acquisition Department

[0061] 14: Experimental Data Acquisition Section 15: Report Generation Section

[0062] 16: Graphics rendering processor 17: Report generation processor

[0063] 110: Controller 120: User

[0064] 130: Excel file; 140: Drawing module

[0065] 150: Indicator Detailed Implementation

[0066] This invention can be modified in many ways and can take many forms. Specific implementation examples will be shown in the figures and described in detail herein.

[0067] However, this is not intended to limit the invention to a specific form of initiation, but should be understood to include all modifications, equivalents or substitutions within the scope of the inventive concept and technology.

[0068] The terminology used in this application is for illustrative purposes only and is not intended to limit the invention. Singular expressions include plural expressions unless the context clearly distinguishes them.

[0069] Unless otherwise defined, all terms used herein, including technical or scientific terms, have the same meaning as commonly understood by one of ordinary skill in the art to which this invention pertains.

[0070] Terms defined in commonly used dictionaries should be interpreted as having a meaning consistent with the meaning in the context of the relevant art, and should not be interpreted as having an ideal or overly formal meaning unless explicitly defined in this application.

[0071] The embodiments of the present invention will now be described in detail with reference to the accompanying drawings.

[0072] Figure 1 According to one embodiment of the present invention, concrete information and a diagram of the graphical device are obtained by using an Excel file containing test data of ultrasonic transmission speed in concrete. Figure 2 According to one embodiment of the present invention, concrete information and a graphical flowchart are obtained by using an Excel file containing test data of ultrasonic transmission speed in concrete. Figure 3 and Figure 4This is a graph of the test data of ultrasonic transmission speed in concrete entered into an Excel file, according to an example of the present invention. Figure 5 and Figure 6 This is a graphical representation of the estimated compressive strength calculated based on ultrasonic transmission velocity test data of the superstructure, according to an example of the present invention. Figure 5 It's about the base plate, specifically the diagram of S1. Figure 6 It refers to the diagram of the base plate, which is S2. Figure 7 According to an example of the present invention, the estimated compressive strength, design reference strength, and stiffness ratio are calculated based on the test data of ultrasonic transmission speed of concrete entered into an Excel file, and are illustrated with numerical values ​​and charts. Figure 8 This is a control structure diagram of an automatic test report generation device according to an example of the present invention. Figure 9 This is a flowchart illustrating the action of automatically generating a test report according to an example of the present invention.

[0073] like Figure 1 As shown, the method of acquiring and displaying concrete information based on the Excel file containing the test data of the ultrasonic transmission speed of concrete of the present invention involves using the Excel file as a database for concrete information calculation and drawing commands. According to the selection of the user 120, the controller 110 calculates and quantifies the required information based on the relevant data extracted from the Excel file 130, displays it in a format controlled by the drawing module 140, and then outputs it along with the numerical values ​​through the graphic 150.

[0074] The control unit 110 uses the data input from the Excel file 130 to calculate concrete information such as the ultrasonic transmission speed test value, the ultrasonic arrival time at the trigger distance, the estimated compressive strength of ordinary concrete, the design reference strength, and the stiffness ratio. This information is then used as a processor to represent it numerically or graphically, including memory storing executable programs. The design reference strength can be stored in advance as data.

[0075] The ultrasonic transmission speed test can be conducted using equipment such as Fundit by measuring the ultrasonic transmission speed per 10cm length on the concrete surface.

[0076] The processor reads the program in the memory, identifies the filling trajectory information of the marked area designed at the mark 150, obtains the data recognition result, responds to the user's drawing command, determines the graphic type, draws the graphic, and displays the graphic through the mark 150.

[0077] The Excel file 130 serves as a database, storing the data required for drawing the graph. This data may include conditions such as the test location, and automatically compiled data based on these conditions, such as the transmission speed of the surface method or direct method, the ultrasonic arrival time at the detector distance, the estimated compressive strength, a comparison with the design strength of each component location, and the strength rate.

[0078] The Excel file 130 also performs automatic formula calculations via marker 140 under the control of control character 110, and plots the results graphically. Based on the information calculated by the automatic formula, the calculations may include, according to the test object's level and other conditions, the ultrasonic wave propagation speed calculated using pre-stored formulas, the ultrasonic wave arrival time calculated based on the distance to the detector, the estimated compressive strength, a comparison with the design strength of each component location, and the strength rate.

[0079] The drawing module 140 can learn given information and extract information for drawing graphics. Here, the information for drawing graphics can include image features and text features. For example, image features can be extracted by recognizing objects in geometric shapes such as points, lines, circles, and triangles.

[0080] The drawing module 140 may consist of a graphics drawing module, which draws the basic X-axis and Y-axis for plotting graphs in the program, and a spacing variation module for changing the spacing between the X-axis and Y-axis. In other words, the "graphics drawing" module draws the basic X-axis and Y-axis for plotting graphs in the program. The spacing variation module dynamically changes the spacing between the X-axis and Y-axis based on the data. That is, the chart is displayed through this processing.

[0081] Similarly, the program automatically generates graphics based on the user's selection, driven by the control of control character 110.

[0082] The identifier 150 will display the test location and other conditions entered in the Excel file 130, as well as the ultrasonic transmission speed of the surface method or direct method calculated based on the conditions, the ultrasonic arrival time of the trigger distance, the estimated compressive strength, the comparison with the design strength of each component location, and the graph drawn by the strength rate and drawing module 140.

[0083] like Figure 2As shown, according to an example of the present invention, based on the concrete information acquisition and visualization operation of an Excel file containing test data of the ultrasonic transmission speed of concrete, the test values ​​and test conditions are input into the Excel file 130 by testing the ultrasonic transmission speed of concrete, so as to store the test values ​​and test conditions in memory (S10); the test value and test condition storage stage (S20) is performed to save the test values ​​and test conditions input in the Excel file 130 in memory; the step of opening the Excel file (S30) is performed to load the Excel file 130 stored in memory; based on the Excel file 130... The test values ​​and test conditions are used to obtain concrete information (S40), such as ultrasonic transmission speed, ultrasonic arrival distance, estimated compressive strength of ordinary concrete, design reference strength, strength rate, and other concrete information; the graphic drawing setting stage (S50) is used to set the graphic drawing environment, such as the ultrasonic transmission speed test value, the ultrasonic arrival time as the distance to the detector, and the estimated compressive strength of ordinary concrete; and the graphic output stage (S60) is used to display the values ​​in the design reference strength and strength rate.

[0084] The test value and test condition input phase (S10) is as follows: Figure 3 and Figure 4 As shown, when the interval between the two triggers is increased by 10cm for each component, it can be the test value of ultrasonic transmission speed.

[0085] Figure 3 This indicates that if it's the base plate, S1 and Figure 4 It is stated that if it is a base plate, increasing the interval between the two triggers by 10cm will improve the ultrasonic transmission speed.

[0086] The drawing setup phase (S50) is as follows: Figure 3 and Figure 4 As shown, with the input of the ultrasonic transmission speed test value, such as Figures 5 to 7 As shown, the experimental values ​​of ultrasonic transmission speed, ultrasonic arrival time at trigger distance, and estimated compressive strength of ordinary concrete will be obtained through numerical and graphical methods.

[0087] Figure 5 The base plate is shown as S1. Figure 6 The base plate is S2, according to Figure 3 and Figure 4 The data includes calculated values ​​and charts for the compressive strength, ultrasonic transmission speed using the surface method, ultrasonic transmission speed using the direct method, and ultrasonic arrival time at the detector distance, based on information such as the ultrasonic transmission speed.

[0088] Figure 7 The ultrasonic transmission speed, estimated compressive strength, design reference strength, and strength rate of S1 and S2, starting from the base plate, are presented in numerical and graphical form.

[0089] According to the embodiments of the present invention, Excel data can be organized by inserting necessary parameters to export columns, etc. After organizing the Excel data, charts can be obtained by converting the data format and using the four arithmetic operations.

[0090] like Figure 8 As shown, according to an embodiment of the present invention, the test report automatic generation device 10 may consist of test object information DB11, test data DB12, test object information acquisition unit 13, test data acquisition unit 14, and report generation unit 15.

[0091] DB11 stores information about the test objects. This information may include the structural name, structural classification such as the superstructure or substructure of the bridge, component names, and detailed ranges of component names.

[0092] The DB12 test data can automatically generate test values ​​of ultrasonic transmission speed based on conditions such as location, ultrasonic arrival time based on the distance of the probe, estimated compressive strength, comparison with the design strength of each component location, and strength rate, etc.

[0093] The test object information acquisition unit 13 acquires the concrete information stored in the Excel file 130 as the information required to generate the report and stores it in the test object information DB11.

[0094] The test data acquisition unit 14 acquires the test result data of the test subjects, obtains the information stored in the Excel file 130 as the information required to generate the report, and stores it in the test data DB12.

[0095] The report generation section 15 may include a graphics generation processor 16 and a report generation processor 17.

[0096] Reference Figure 9 The following describes an example of the automatic generation process of a test report based on the invention described above:

[0097] First, the test report automatic generation device 10 obtains the structural name, structural division (e.g., bridge: superstructure, substructure), component name, and detailed interval information of component name from the test object information DB11 stored in the Excel file 130 by the test object information acquisition unit 13.

[0098] For example, the user can sequentially specify the structure name, structure division (e.g., bridge: superstructure, substructure), component name, and detailed interval information of the component name through the operation section, and then press the "Search" button to extract the list from the corresponding test object information DB11 and display it on the screen.

[0099] In addition, the test object information acquisition unit 13 obtains and stores the location and other conditions from the Excel file 130 in the test data DB12, as well as the ultrasonic transmission speed, ultrasonic arrival distance, estimated compressive strength, comparison with the design strength of each component location, and strength rate automatically sorted based on the conditions, extracts a list from the test data DB12 and displays it on the screen.

[0100] Therefore, the report generation section 15 generates a report file based on the information stored in the test subject information DB11 and the information stored in the test data DB12.

[0101] Subsequently, the graphics generation processor 16 of the report generation section 15 generates graphics from the list of Excel files using an Excel program.

[0102] The Excel file lists the structure name, structural division (e.g., bridge: superstructure, substructure), component name, detailed interval information and location of component name, as well as the ultrasonic transmission speed test value, ultrasonic arrival time of trigger distance, estimated compressive strength, comparison with the design strength of each component location and strength rate automatically generated based on these conditions. Therefore, the graph is generated based on this information.

[0103] Additionally, the report generation section 15 does not have a graphics generation processor 16 configured, and can be directly referenced. Figure 1 The graph shown is drawn by the drawing module 140. Conversely, if a graph generation processor 16 is configured in the report generation section 15, the graph can be drawn in a new way using the values ​​stored in the Excel file 130.

[0104] The report generation processor 17 can be implemented through a text program to insert the graphic image generated by the graphic generation processor 16 into a specified position and automatically output comments on it.

[0105] The report generation processor 17 can generate files in a preset report format by adding descriptions of the test results.

[0106] In this embodiment, the report generation processor 17 can generate a Word format report file, which includes graphics and the necessary analysis annotations.

[0107] The report generation processor 17 can compare and analyze the graphics generated by the graphics generation processor 16 with stored standard data and include annotations of the analysis results in the report file. For example, safety diagnostic annotations reflecting the degree of structural aging can be printed out compared with past test results.

[0108] The safety diagnostic annotation can be determined based on the structural assessment level calculated by the safety diagnostic program stored in the control section 110.

[0109] In other words, the control unit 110 can store safety diagnostic programs and use them to calculate the location and extent of structural damage. Furthermore, it can execute evaluation algorithms for detailed component intervals, calculating the safety diagnostic assessment level of each detailed component interval based on ultrasonic transmission velocity test values. After calculating the safety diagnostic assessment level of each detailed component interval, it then calculates the overall component assessment level based on these levels.

[0110] The evaluation algorithms for the detailed segments of each component, for example, the base plate can be an algorithm that distinguishes between S1, S2, and the lower flange faces of S1-G12 for relative evaluation, or the most critical detailed segments of the entire structure can be differentiated by level.

[0111] In this case, past ultrasonic transmission velocity test values ​​can be compared with current ultrasonic transmission velocity test values, and the evaluation level can be calculated based on the difference. If the ultrasonic transmission velocity test values ​​of the most critical detail range affecting the overall structure in the past differ significantly from the current ultrasonic transmission velocity test values, then the overall evaluation level of the structure will be lowered. Conversely, if the ultrasonic transmission velocity test values ​​of the least critical detail range affecting the overall structure differ significantly from the current ultrasonic transmission velocity test values, then the overall evaluation level of the structure will not be lowered.

[0112] As described above, the preferred embodiments of the invention have been illustrated in the detailed description of the invention, but this is only a illustrative description of the preferred embodiments and not a limitation thereof. Furthermore, anyone skilled in the art to which this invention pertains can make various modifications and imitations without departing from the scope of the inventive concept.

Claims

1. A method for acquiring and graphically representing concrete information based on an Excel file containing experimental data of ultrasonic transmission velocity in concrete, characterized in that, The method for acquiring and graphical representation of concrete information based on an Excel file containing input concrete ultrasonic transmission velocity test data includes the following steps: Test the ultrasonic transmission speed in concrete, and input the test values ​​and test conditions into an Excel file so that the test values ​​can be stored in the storage system via the Excel file; The test values ​​and test conditions entered in the Excel file are saved in memory. The steps to open an Excel file include loading the Excel file stored in the memory; Based on the test values ​​and test conditions in the Excel file, concrete information acquisition stage, such as ultrasonic transmission speed test value, distance of the detector from the ultrasonic wave arrival time, estimated compressive strength of ordinary concrete, design reference strength, strength rate and other concrete information; In the drawing setup phase, the drawing module is used to set the experimental values ​​of ultrasonic wave transmission speed, the time it takes for the ultrasonic wave to reach the trigger, and the graphical drawing environment for the estimated compressive strength of ordinary concrete; and The experimental values ​​of ultrasonic transmission speed, the change of ultrasonic arrival time with the distance of the detector, the estimated compressive strength and design reference strength and strength rate of ordinary concrete, and the numerical and graphical outputs of the values ​​plotted in the graphic drawing setup stage are output through identifiers.

2. The method for acquiring and graphical representation of concrete information based on an Excel file containing experimental data of ultrasonic transmission velocity in concrete, as described in claim 1, is characterized in that... The plotting module includes test data on the ultrasonic transmission speed of concrete compiled from an Excel file, a plotting module for drawing basic X-axis and Y-axis graphs in the program, and a module for changing the spacing between the X-axis and Y-axis.

3. The method for acquiring and graphical representation of concrete information based on an Excel file containing experimental data of ultrasonic transmission velocity in concrete, as described in claim 1, is characterized in that... The ultrasonic wave transmission speed is calculated using the surface method and the direct method.

4. A report generation system utilizing an Excel file containing input data on ultrasonic wave transmission velocity in concrete for concrete information acquisition and visualization, characterized in that... The method for acquiring and graphical representation of concrete information based on an Excel file containing input concrete ultrasonic transmission velocity test data includes the following steps: To test the ultrasonic transmission speed in concrete, input the test values ​​and test conditions, then input the test values ​​and test conditions into an Excel file so that the test values ​​can be stored in memory via the Excel file; The test values ​​and test conditions entered in the Excel file are saved in memory. The steps to open an Excel file include loading the Excel file stored in the memory; Based on the test values ​​and test conditions in the Excel file, concrete information acquisition stage, such as ultrasonic transmission speed test value, distance of the detector from the ultrasonic wave arrival time, estimated compressive strength of ordinary concrete, design reference strength, strength rate and other concrete information; In the drawing setup phase, the drawing module is used to set the experimental values ​​of ultrasonic wave transmission speed, the time it takes for the ultrasonic wave to reach the trigger, and the graphical drawing environment for the estimated compressive strength of ordinary concrete; and The experimental values ​​of ultrasonic transmission velocity, the variation of ultrasonic arrival time with the distance to the detector, the estimated compressive strength and design reference strength and strength rate of ordinary concrete, and the numerical and graphical outputs of these values ​​are generated through identifiers during the graphic drawing setup phase. The report generation system includes: DB stores test object information, including structure name, structure division, components, and detailed segment data of components. Test data DB12 is used to store test values ​​of ultrasonic transmission velocity calculated based on location conditions, ultrasonic arrival time (depending on the distance to the detector), estimated compressive strength, comparison with the design strength of each component location, and strength rate data. The concrete information stored in the Excel file is obtained as the information required to generate the report and stored in the test object information acquisition section of the test object information database; The test data acquisition unit acquires and stores the concrete information stored in the Excel file as the information required to generate the report in the test data database; and The report generation section includes a graphics generation processor and a report generation processor.

5. The report generation system according to claim 4, which utilizes an Excel file containing input data on ultrasonic transmission velocity in concrete for concrete information acquisition and visualization, is characterized in that... The report generation processor generates a file in a preset report format by adding explanations to the test results. Generate a Word document report file, including graphs and necessary analysis annotations. By comparing and analyzing the graphics generated by the graphics generation processor with stored standard data, the report file includes annotations on the analysis results of the structural aging state.

Images