CN-116150098-B - Method and system for managing operation daily report data

CN116150098BCN 116150098 BCN116150098 BCN 116150098BCN-116150098-B

Abstract

The application relates to the technical field of data management, in particular to a method and a system for managing operation daily report data, wherein the method comprises the steps of importing and storing an operation daily report in an Excel format; the method comprises the steps of preprocessing the operation daily report, determining a corresponding effective data starting line and a corresponding effective data ending line, circularly scanning the operation daily report according to the effective data starting line and the effective data ending line to obtain operation data of the operation daily report, and generating a corresponding statistical report based on the operation data. The method analyzes the operation daily report in the Excel format based on the specific algorithm, classifies and stores the data of each factory, can inquire and extract related data according to different service requirements, has high efficiency, saves labor cost and is not easy to lose compared with the method for storing the operation data of sewage treatment by only using the Excel document, and can systematically and modularly manage and effectively extract a plurality of data.

Inventors

YANG QIANG
Zhang Tuanyong
CHEN XIUBO
XU ZHIWEI
HU QINGXIA

Assignees

日照城投环境科技集团有限公司

Dates

Publication Date: 20260508
Application Date: 20221206

Claims (5)

1. A method of managing run daily report data, comprising: importing and storing an Excel-format operation daily report, wherein the method comprises the steps of obtaining operation time through the file name of the operation daily report, converting the operation time into a required date format, judging whether the operation daily report corresponding to the operation time is imported or not, and importing if not; preprocessing the operation daily report, and determining a corresponding effective data start line and an effective data end line, wherein the method comprises the steps of taking the 1 st column data in the operation daily report as characteristic data, scanning down line by line until different characteristic data appear, and updating effective data end line information in real time; The method comprises the steps of carrying out cyclic scanning on an operation daily report according to the effective data starting line and the effective data ending line, and obtaining the operation data of the operation daily report, wherein the cyclic scanning comprises the steps of starting a cycle, creating an object in each cycle, wherein the object is used for recording the effective data, adding the object into a list, starting a cycle, traversing the effective data in the list until all the effective data of the operation daily report are stored in a database, including creating a RowScale object in each cycle, recording the name of a sewage treatment plant and the effective data belonging to the sewage treatment plant, such as the effective data starting line, the effective data ending line, the processing capacity and the like, and adding the object into the RowScale list; Then starting a cycle, traversing the data in the RowScale list, acquiring corresponding effective data according to different columns in the operation daily statement, and storing the effective data as a record in a database; and generating a corresponding statistical report based on the operation data.
2. The method for managing operation daily report data as claimed in claim 1, further comprising: Importing and storing an Excel format ecological environment detection table, wherein the ecological environment detection table comprises the emission concentration and the emission amount of the effluent index; Preprocessing the ecological environment detection table, and determining effective data starting lines and effective data ending lines; Scanning line by line from the beginning line of the effective data to the ending line of the effective data to obtain detection data of the ecological environment detection table; Calculating the average value of the discharge concentration and the discharge amount of the water outlet index based on the detection data; and judging whether the average value of the discharge concentration and the discharge amount of the effluent index is abnormal data, if not, counting the discharge concentration, and counting the total discharge amount.
3. The running daily report data management method as claimed in claim 2, wherein the step of judging whether the average of the discharge concentration and the discharge amount of the water discharge index is abnormal data comprises: In the case where the emission concentration or emission amount is empty or equal to 0, it is confirmed as abnormal data.
4. A method of managing run daily data as claimed in claim 3, further comprising: Judging whether the hour flow exceeds a preset threshold value based on the discharge amount, wherein the hour flow is the discharge amount in 1 hour; if so, counting the abnormal hour flow rate, and recording the maximum emission concentration and the maximum emission amount.
5. An operation daily data management system, characterized by using the operation daily data management method as claimed in any one of claims 1 to 4, comprising: The importing module is configured to import and store an Excel-format operation daily report; the preprocessing module is configured for preprocessing the operation daily statement and determining a corresponding valid data starting line and a valid data ending line; The acquisition module is configured to circularly scan the operation daily statement according to the effective data starting line and the effective data ending line to acquire the operation data of the operation daily statement; and the generation module is configured to generate a corresponding statistical report based on the operation data.

Description

Method and system for managing operation daily report data Technical Field The application relates to the technical field of data processing, in particular to a method and a system for managing operation daily report data. Background The daily operating report of the sewage treatment industry covers data such as sewage treatment capacity, load rate, electricity consumption, sludge treatment capacity, reclaimed water recycling amount, water inlet and outlet indexes, auxiliary agent dosage, dosing cost and the like, and most sewage treatment plants generally adopt Excel document forms for storing various data in the operation process. However, storing the operation data of sewage treatment by Excel documents is a quite backward form, and the reporting, storing and counting are time-consuming and labor-consuming, easy to lose and easy to make mistakes. Disclosure of Invention In order to save labor cost and improve efficiency, the application provides a method and a system for managing operation daily report data. In a first aspect, the present application provides a method for managing operation daily report data, which adopts the following technical scheme: A method of managing run daily report data, comprising: importing and storing an Excel-format operation daily report; preprocessing the operation daily report, and determining a corresponding valid data starting line and a valid data ending line; performing cyclic scanning on the operation daily statement according to the effective data starting line and the effective data ending line to acquire operation data of the operation daily statement; and generating a corresponding statistical report based on the operation data. By adopting the technical scheme, the operation daily statement in the Excel format is analyzed based on the specific algorithm, the data of each factory are classified and stored, related data can be queried and extracted according to different service requirements, compared with the operation data of sewage treatment which is stored only by the Excel document, the efficiency is high, the labor cost is saved, the data is not easy to lose, and a plurality of data can be managed and effectively extracted in a systematic and modularized mode. Optionally, the step of importing and storing the Excel-format running daily report includes: acquiring the running time according to the file name of the running daily report; converting the run time into a desired date format; Judging whether the operation daily statement corresponding to the operation time is imported or not, and if not, importing. Optionally, the step of preprocessing the running daily report to determine a corresponding valid data start line and valid data end line includes: and scanning downwards row by taking the 1 st column data in the operation daily report as characteristic data until different characteristic data appear, and updating effective data end row information in real time. Optionally, the step of circularly scanning the operation daily report according to the valid data start line and the valid data end line to obtain the operation data of the operation daily report includes: starting a cycle, namely scanning line by line from the starting line of the effective data to the ending line of the effective data, wherein each cycle creates an object, and the object is used for recording the effective data; adding the object to a list; And starting a cycle, traversing the effective data in the list until all the effective data of the running daily report are stored in the database. Optionally, the step of starting a cycle, traversing the data in the list until all valid data of the running daily report are saved to the database includes: and acquiring corresponding effective data according to different columns in the operation daily report, and storing the effective data as a record in a database. Optionally, the method further comprises: Importing and storing an Excel format ecological environment detection table, wherein the ecological environment detection table comprises the emission concentration and the emission amount of the effluent index; Preprocessing the ecological environment detection table, and determining effective data starting lines and effective data ending lines; Scanning line by line from the beginning line of the effective data to the ending line of the effective data to obtain detection data of the ecological environment detection table; Calculating the average value of the discharge concentration and the discharge amount of the water outlet index based on the detection data; and judging whether the average value of the discharge concentration and the discharge amount of the effluent index is abnormal data, if not, counting the discharge concentration, and counting the total discharge amount. Optionally, the step of determining whether the average value of the discharge concentration and the discharge amount of the effluent index is abnormal data incl