Hydropower engineering civil engineering test data statistical analysis method and system
Technical Field
The invention belongs to the technical field of test data management of hydropower engineering, and relates to a statistical analysis method and a statistical analysis system for civil engineering test data of the hydropower engineering.
Background
The test detection is one of the quality inspection methods and is also an important link in construction quality management. The variety of raw materials, intermediate products and finished products is various, the detection control standards are different, the related detection items and indexes are many, the evaluation standards of the test results have personalized differences due to the characteristics of the test results and the use of a large amount of local materials, and the test results are difficult to completely master by testers, so that the problems of wrong detection results and the like can occur if wrong detection items and detection indexes are used.
The laboratory needs to complete the processes of civil engineering commission test, sample taking and sample sending and evidence finding in multiple units and multiple departments in cooperation. The conditions of untimely information transmission, inconsistent information of the entrusting order and the sampling and sending sample order, inadequate witnesses, incomplete data and the like occur occasionally. The management mode has adverse effects on test work and quality control, greatly reduces test work efficiency, and influences material management, project acceptance evaluation and project progress.
The quality of the physical engineering is mainly evaluated through various types of test results, and generally, the quality is evaluated through establishing machine account data and then summarizing to obtain a civil engineering test detection report form of the hydropower engineering. The workload of manual statistics of test data is huge, the difficulty of data acquisition and summary analysis is large, the test period is difficult to control, and errors are easy to occur. The data statistics work occupies the main energy of the backbone of the test technology, and the energy for analyzing the development and change trend of the entity engineering quality reflected by the test data and how to further improve the engineering quality is less. The statistical analysis of the test results is relatively lagged, so that the analysis results are difficult to quickly obtain response, and meanwhile, the test results are inconvenient to query.
In order to solve the problems of the traditional test management, the efficiency of test work needs to be improved, and the adverse effect of work errors on engineering quality management is reduced to the maximum extent. The informatization and automation of hydropower engineering test data management are inevitable trends in industry development.
Disclosure of Invention
In order to solve the defects in the prior art, the application provides a method and a system for statistical analysis of civil engineering test data of the hydropower engineering, which utilize the Internet of things and the mobile application technology to realize acquisition and dynamic analysis of civil engineering test detection information for the hydropower engineering, and solve the problems of untimely test entrustment, insufficient sampling amount, difficult statistics and summarization of test data, large workload, poor timeliness and the like in the manual traditional management mode of the civil engineering test.
In order to achieve the above purpose, the invention adopts the following technical scheme:
a statistical analysis method for civil engineering test data of hydroelectric engineering comprises the following steps:
step 1: obtaining the arrival batch and the arrival quantity through the arrival detail, and pushing test entrustment information according to the arrival time to remind test detection personnel and supervision personnel to carry out test sampling work in time;
step 2: constructing a test detection standard library, and recording a sampling standard and a test standard;
and step 3: prompting the sampling quantity according to the arrival batch and the arrival quantity to form a sample label (a sample two-dimensional code), recording sampling information and finishing the registration of the detection sample;
and 4, step 4: the method comprises the following steps that a sample principal determines a detection project, a tester carries out test detection work according to standards, and scans a sample label through mobile equipment to finish test result registration;
and 5: through comparison with the test standard in the standard library, judgment of a test result is formed, a test detection report (electronic version and printable) meeting the standard is formed according to the template, and the test detection report can be pushed to a delivery inspector and business managers at all levels after the test is finished and confirmed by testers;
step 6: and counting and summarizing the test results to form a test detection summary report for each party, evaluating the conformity of sampling and sample results according to the standard, and helping each party master the test detection condition.
The invention further comprises the following preferred embodiments:
preferably, the arrival details in step 1 include arrival time, manufacturer, model, arrival batch, quantity and inspection certificate.
Preferably, the step 3 of testing the sample registry comprises: basic information registration, test entrustment registration and test sample witness registration;
the basic information includes: the test piece types are divided into three types of raw materials, intermediate products and finished products; the sampling place of the test piece and the national and industrial standards according to which the test is carried out;
the test entrustment registration refers to an entruster who registers a test carried out by an entrustment laboratory;
the test sample witness registration refers to registering a proctorial unit for witness to the sampling condition of the test sample.
Preferably, the detection items in step 4 include: specific surface area, setting time, stability, strength, chloride ions, standard consistency, density, sulfur trioxide, loss on ignition, magnesium oxide, alkali content, insoluble substances and heat of hydration.
Preferably, the judging of the test result in the step 5 comprises: calculating the number of to-be-detected units of various detection items according to time intervals, counting the actual detection number, and evaluating whether the detection frequency of the current test meets the requirement; and
and (4) counting the maximum value, the minimum value and the average value of the detection results of all the detection items, comparing the maximum value, the minimum value and the average value with the standard values of the detection items, and evaluating whether the detection items meet the technical standard.
Preferably, the step 6 of counting and summarizing the test results refers to classifying and summarizing the detection data in a selected time period according to the type of the detection object, the manufacturer and the inspection unit to form a total detection number and a detection ledger statistical table, and displaying the abnormal data in a marking manner for analyzing and observing the quality change rule and searching the reason causing the quality fluctuation.
The invention also discloses a statistical analysis system of the statistical analysis method of the civil engineering test data of the hydropower engineering, which comprises the following steps:
the data acquisition module is used for acquiring the arrival batch and the arrival quantity through the arrival details, pushing test entrustment information according to the arrival time and reminding test detection personnel and supervision personnel to carry out test sampling work in time;
the standard library construction module is used for constructing a test detection standard library and recording a sampling standard and a test standard;
the sampling module is used for prompting the sampling quantity according to the arrival batch and the arrival quantity, forming a sample label, recording sampling information and finishing the registration of the detection sample;
the test detection module is used for determining a detection item, carrying out test detection work according to the standard, scanning a sample label through the mobile equipment and finishing test result registration;
the test result judging module is used for forming judgment of a test result by comparing with a test standard in the standard library, forming a test detection report meeting the standard according to the template, and pushing the test detection report to the inspector and the business managers at all levels after the test is finished;
and the test result counting and summarizing module is used for counting and summarizing the test results to form a test detection summarizing report for all parties to use, evaluating the conformity of sampling and sample results according to the standard and helping all parties to master the test detection condition.
The beneficial effect that this application reached:
1. the method comprises the steps that an informatization technology is adopted to carry out overall process management on civil engineering quality detection work of the hydropower engineering, a hydropower engineering civil engineering test management standard library is arranged in a system, comprises relevant test management systems, standards and management processes of the country, the industry and the like, covers various hydropower engineering civil engineering test detection types, detection items, detection item standard values and sampling frequency requirements, and realizes the functions of item screenable and standard configurable according to the actual conditions of the items to form a test management standard library suitable for each item unit;
2. by adopting a mobile interconnection technology, the whole test detection process information is collected in real time, the detection result is automatically calculated according to the data calculation rule and the logical relationship, the computer automatically pushes the work task, tracks the progress of the test work, greatly improves the process operation efficiency through online examination and approval, improves the timeliness and effectiveness of information transmission, and provides data basis for the subsequent test detection work and material management work;
3. the method is characterized in that the detection technical standard of the civil engineering test of the hydropower engineering is structurally decomposed, a computer is used for replacing manual calculation, the civil engineering test data of the hydropower engineering are counted, the conformity evaluation of the detection result and the detection frequency is automatically carried out, the management ledger of the civil engineering test of the hydropower engineering is automatically generated according to the preset rule, the statistical analysis of the test data is automatically completed, a statistical report is generated, a visual chart can be formed, the quality conditions of various performance indexes of the civil engineering are visually reflected, convenient query means and a printout function are provided, the refined management and control of the whole process are realized, the working efficiency is greatly improved, the occurrence probability of working errors is reduced, the high-efficiency application of the test data is realized, the fluctuation of the detection result is timely found, and the quality of the solid.
Drawings
FIG. 1 is a flow chart of a statistical analysis method of civil engineering test data of a hydroelectric project;
FIG. 2 is a flow chart of an embodiment of a statistical analysis method for civil engineering test data of the hydroelectric engineering.
Detailed Description
The present application is further described below with reference to the accompanying drawings. The following examples are only for illustrating the technical solutions of the present invention more clearly, and the protection scope of the present application is not limited thereby.
As shown in fig. 1-2, taking cement test management as an example for explanation, the statistical analysis method for civil engineering test data of hydropower engineering of the invention comprises the following steps:
step 1: obtaining the arrival batch and the arrival quantity through the arrival detail, and pushing test entrustment information according to the arrival time to remind test detection personnel and supervision personnel to carry out test sampling work in time;
the cement arrival details comprise arrival time, manufacturers, cement models, arrival batches, quantity, inspection certificates and the like.
Step 2: constructing a test detection standard library, and recording a sampling standard and a test standard;
and step 3: prompting the sampling quantity according to the arrival batch and the arrival quantity to form a sample label (a sample two-dimensional code), recording sampling information and finishing the registration of the detection sample;
in specific implementation, after the test entrusts are recorded, according to the arrival batch and the arrival quantity (600T in the same batch of bulk cement, a group of samples are extracted), the sampling quantity is determined, sampling information (sampling time and the like) is recorded, and the cement detection sample registration is completed.
The cement test sample registration comprises: basic information registration, test entrustment registration and test sample witness registration;
the basic information includes:
A. test piece type: the civil engineering test projects (according to the production links) of the hydroelectric engineering can be generally divided into three types, namely raw materials, intermediate products (processing plants and mixing plants) and finished products.
B. Sampling site: i.e. the sampling site of the test piece.
C. The detection basis is as follows: namely the national and industrial standards according to which the test is based.
The test entrustment registration refers to an entruster who registers a test carried out by an entrustment laboratory;
the test sample witness registration refers to registering a proctorial unit for witness to the sampling condition of the test sample.
And 4, step 4: the method comprises the following steps that a sample principal determines a detection project, a tester carries out test detection work according to standards, and scans a sample label through mobile equipment to finish test result registration;
the cement test detection items comprise: specific surface area, coagulation time, stability, strength, chloride ions, standard consistency, density, sulfur trioxide, loss on ignition, magnesium oxide, alkali content, insoluble substances and hydration heat;
different detection items respectively correspond to respective detection item standards to judge whether the detection results are combined;
and 5: through comparison with the test standard in the standard library, judgment of a test result is formed, a test detection report (electronic version and printable) meeting the standard is formed according to the template, and the test detection report can be pushed to a delivery inspector and business managers at all levels after the test is finished and confirmed by testers;
defining detection items of the detection objects in a test standard library, and carrying out detection type identification; the method selects detection types in the delegation management, determines detection items according to delegation, and is divided into general detection, all-item detection and custom detection items. In the sample test result, the detection items required in the detection are listed, the detection standard is displayed, and the detection result is judged; and after the detection result is filled, the system displays a test detection report according to the template.
The report types comprise supervision units, test units, construction unit compiling week, month and year (regular) reports, quality supervision (irregular) reports, engineering project test total reports and the like.
Step 6: and counting and summarizing the test results to form a test detection summary report for each party, evaluating the conformity of sampling and sample results according to the standard, and helping each party master the test detection condition.
According to the acceptance criteria of masonry structure engineering construction quality, the general Portland cement, the moderate-heat Portland cement low-heat slag Portland cement and the hydraulic concrete construction criteria, the sampling frequency requirement and the standard value of the detection project are set, and evaluation and measurement standards are provided for sampling and test results.
The test summarization is to perform classified summarization of detection data in a selected time period according to the types of detection objects, manufacturers and inspection units to form a total detection number and a detection ledger statistical table, and perform labeled display on abnormal data, so as to analyze and observe quality change rules and search causes of quality fluctuation.
Usually, the detection ledger of a certain detection object for a certain unit of a certain detection is calculated.
The evaluation main content comprises the following steps: the method comprises the following steps of detection frequency and conformance evaluation, detection result statistics and conformance evaluation, analysis of physical engineering quality conditions and the like.
The test evaluation comprises: calculating the number of to-be-detected units of various detection items according to time intervals, counting the actual detection number, and evaluating whether the detection frequency of the current test meets the requirement;
according to the standards of 'inspection and acceptance of masonry structure engineering construction quality', 'general Portland cement', 'moderate heat Portland cement low heat slag Portland cement' and 'hydraulic engineering concrete construction standard', the system establishes a test frequency calculation logic through statistics of test evaluation, forms statistics of the number of the test items to be inspected, and performs statistics with actual sampling inspection of the test items to form a sampling number to be inspected and realize data comparison, thereby forming a periodic test material item sampling frequency conformity report form and providing reference and evaluation basis for test management of test managers.
And counting data such as the maximum value, the minimum value, the average value and the like of the detection result of each detection item, comparing the data with the standard value of the detection item, and evaluating whether the detection item meets the technical standard or not.
The detection result of the sample is the comprehensive evaluation of a plurality of detection items, so that the processing of the detection result evaluation and the maintenance of the detection result data are required to be carried out separately for different detection items.
The invention discloses a statistical analysis system for civil engineering test data of hydropower engineering, which comprises:
the information acquisition module is used for obtaining the cement shipment batch and the shipment quantity through the cement shipment detail;
the sampling module is used for determining the sampling quantity according to the arrival batch and the arrival quantity, recording sampling information and finishing cement detection sample registration;
the detection module is used for determining a cement detection project and a detection project standard and carrying out cement detection;
the test report generation module is used for filling the detection result into the test report template, and generating and pushing a cement detection test report;
and the test evaluation module is used for setting test result evaluation standards and carrying out test summary and test evaluation.
The present applicant has described and illustrated embodiments of the present invention in detail with reference to the accompanying drawings, but it should be understood by those skilled in the art that the above embodiments are merely preferred embodiments of the present invention, and the detailed description is only for the purpose of helping the reader to better understand the spirit of the present invention, and not for limiting the scope of the present invention, and on the contrary, any improvement or modification made based on the spirit of the present invention should fall within the scope of the present invention.