Standardization method, storage medium and computer device for tank volume table

Abstract

The application discloses a kind of standardization method of oil tank volume table, storage medium and computer equipment, the method comprises the following steps: collecting initial oil tank volume table of multiple formats, the following processing is carried out to each initial oil tank volume table collected: identifying the feature data area in initial oil tank volume table;Parsing the feature data of the feature data area;The feature data is standardized, and the standardized oil tank volume table is generated according to the feature data after standardization processing.The application can automatically process initial oil tank volume table of multiple formats into standardized oil tank volume table, and provide convenience for later work of a large number of oil tank data statistics.

Description

TECHNICAL FIELD

[0001] The application belongs to the technical field of data processing application, and particularly relates to a standardization method of an oil tank volume table, a storage medium and a computer device. BACKGROUND

[0002] The oil tank volume table of an oil tank is basic data for oil tank foundation management and oil tank volume calculation. A typical oil tank volume table has a main capacity table, an interval capacity table, a static pressure correction table and a bottom capacity table. In practice, different calibration enterprises and institutions use different tools to calibrate oil tanks and generate corresponding oil tank volume tables. Since each oil depot includes multiple oil tanks, and each calibration enterprise and institution needs to calibrate the oil tanks of multiple oil depots, the formats of the oil tank volume tables exported by different calibration enterprises and institutions according to the reference formats recommended in the calibration regulations are not unified.

[0003] However, at present, when it is necessary to count the oil tank data of a certain region, the oil tank volume tables cannot be uniformly managed due to the non-uniform formats of the oil tank volume tables, and it is difficult to calculate and count the oil tank data of a certain region according to a unified standard.

[0004] Therefore, there is an urgent need for a standardization method of an oil tank volume table, a storage medium and a computer device. SUMMARY

[0005] The technical problem to be solved by the application is to process data of oil tank volume tables in multiple formats, so that the processed oil tank volume tables meet the requirements of standard oil tank volume tables, thereby realizing uniform management of the oil tank volume tables.

[0006] In view of the above problems, the application provides a standardization method of an oil tank volume table, a storage medium and a computer device.

[0007] In a first aspect, the application provides a standardization method of an oil tank volume table, comprising the following steps:

[0008] Collecting initial oil tank volume tables in multiple formats, and processing each collected initial oil tank volume table as follows:

[0009] Identifying a characteristic data region in the initial oil tank volume table;

[0010] Analyzing characteristic data of the characteristic data region;

[0011] Standardizing the characteristic data, and generating a standardized oil tank volume table according to the standardized characteristic data.

[0012] According to the embodiment of the application, preferably, identifying the characteristic data region in the initial oil tank volume table comprises the following steps:

[0013] marking a keyword in the initial oil tank volume table through a data anchor point;

[0014] identifying a start point and an end point of a feature data region according to the keyword;

[0015] demarcating the feature data region based on the start point and the end point of the feature data region.

[0016] According to an embodiment of the present application, preferably, parsing feature data of the feature data region comprises the following steps:

[0017] determining a storage mode of the feature data of the feature data region based on a preset determination rule library;

[0018] reading the feature data of the feature data region according to the storage mode.

[0019] According to an embodiment of the present application, preferably, after the reading of the feature data of the feature data region according to the storage mode, the method further comprises the following steps:

[0020] verifying whether the read feature data has data missing based on a preset verification rule:

[0021] when the read feature data has data missing, prompting that the initial oil tank volume table has data missing;

[0022] when the read feature data has no data missing, performing a step of standardizing the feature data.

[0023] According to an embodiment of the present application, preferably, the preset verification rule comprises:

[0024] when the feature data region in the initial oil tank volume table comprises a main volume table region, a static pressure correction table region, an interval volume table region and a bottom volume table region and data of each region covers a complete interval from a start value to a maximum value, determining that the read feature data has no data missing;

[0025] when the feature data region in the initial oil tank volume table comprises only the main volume table region, the static pressure correction table region and the bottom volume table region and data of each region covers a complete interval from a start value to a maximum value and a minimum division unit of data of the main volume table region is centimeter, determining that the read feature data has no data missing;

[0026] When the characteristic data region in the initial oil tank volume table only includes the main capacity table region, the static pressure correction table region and the interval capacity table region, and the data in each region covers the complete interval from the start value to the maximum value, and the start value of the data in the main capacity table region is zero, it is determined that the read characteristic data does not have data missing;

[0027] When the characteristic data region in the initial oil tank volume table only includes the main capacity table region and the static pressure correction table region, and the data in each region covers the complete interval from the start value to the maximum value, and the minimum division unit of the data in the main capacity table region is centimeter and the start value is zero, it is determined that the read characteristic data does not have data missing.

[0028] According to an embodiment of the present application, preferably, the characteristic data is standardized, and a standardized oil tank volume table is generated according to the standardized characteristic data, including the following steps:

[0029] The characteristic data is converted into data conforming to a preset data storage standard, wherein the preset data storage standard includes the unit and attribute of the data;

[0030] The data conforming to the preset data storage standard is filled into a preset blank standardized oil tank volume table to generate the standardized oil tank volume table.

[0031] According to an embodiment of the present application, preferably, the standardized oil tank volume table is an Excel table, which includes a main capacity worksheet, an interval capacity worksheet, a static pressure correction worksheet and a bottom capacity worksheet,

[0032] Before the step of identifying the characteristic data region in the initial oil tank volume table, the method further includes the following steps:

[0033] The format of the initial oil tank volume table is converted into the format of the Excel table.

[0034] According to an embodiment of the present application, preferably, the standardized oil tank volume table includes a main capacity table, an interval capacity table, a static pressure correction table and a bottom capacity table, and after the step of filling the data conforming to the preset data storage standard into the preset blank standardized oil tank volume table to generate the standardized oil tank volume table, the method further includes the following steps:

[0035] Based on a tank volume calculation model, it is respectively verified whether the data in the main capacity table, the interval capacity table, the static pressure correction table and the bottom capacity table conforms to consistency:

[0036] When the data in the main capacity table, the interval capacity table, the static pressure correction table and the bottom capacity table all conforms to consistency, the standardized oil tank volume table is exported;

[0037] When the data in the main volume table, the interval volume table, the static pressure correction table and the bottom volume table do not conform to consistency, it is prompted that the standardized oil tank volume table data is missing.

[0038] According to the embodiment of the present application, preferably, based on the tank volume calculation model, whether the data in the main volume table, the interval volume table, the static pressure correction table and the bottom volume table conforms to consistency is respectively verified, including the following steps:

[0039] The data in each table among the main volume table, the interval volume table, the static pressure correction table and the bottom volume table is verified in the following manner:

[0040] From the starting value to the maximum value in each table, every predetermined number of data is sequentially sampled, and whether the sequentially sampled data is uniformly upward is judged:

[0041] When the sequentially sampled data from each table is uniformly upward, it is determined that the data in the main volume table, the interval volume table, the static pressure correction table and the bottom volume table conforms to consistency;

[0042] When the sequentially sampled data from any one of the main volume table, the interval volume table, the static pressure correction table and the bottom volume table is not uniformly upward, it is determined that the data in the main volume table, the interval volume table, the static pressure correction table and the bottom volume table does not conform to consistency.

[0043] In the second aspect, the present application provides a storage medium, which has a computer program stored thereon, and the computer program is executed by a processor to implement the steps of the above method.

[0044] In the third aspect, the present application provides a computer device, which includes a memory and a processor, and the memory has a computer program stored thereon, and the computer program is executed by the processor to implement the steps of the above method.

[0045] Compared with the prior art, one or more embodiments in the above scheme can have the following advantages or beneficial effects:

[0046] The standardized method of the oil tank volume table of the present application can collect initial oil tank volume tables of various formats, and the following processing is performed on each collected initial oil tank volume table: identifying a characteristic data area in the initial oil tank volume table; analyzing the characteristic data of the characteristic data area; standardizing the characteristic data, and generating a standardized oil tank volume table according to the standardized characteristic data, which can automatically process initial oil tank volume tables of various formats into a standardized oil tank volume table, and provide convenience for later statistical work on a large amount of oil tank data.

[0047] Other features and advantages of the invention will be set forth in the description which follows, and will be apparent in part from the description, or may be learned by practicing the invention. The objects and other advantages of the invention may be realized and obtained by means of the structures particularly pointed out in the description, claims, and drawings. Attached Figure Description

[0048] The accompanying drawings are provided to further illustrate the invention and form part of the specification. They are used in conjunction with the embodiments of the invention to explain the invention and do not constitute a limitation thereof. In the drawings:

[0049] Figure 1 A flowchart illustrating the standardization method for the oil tank volume table according to Embodiment 1 of the present invention is shown;

[0050] Figure 2 A flowchart illustrating the standardization method for the oil tank volume table according to Embodiment 2 of the present invention is shown;

[0051] Figure 3 A flowchart of the standardization method for the oil tank volume table in Embodiment 3 of the present invention is shown. Detailed Implementation

[0052] The embodiments of the present invention will be described in detail below with reference to the accompanying drawings and examples, so that the process of how the present invention uses technical means to solve technical problems and achieve technical effects can be fully understood and implemented accordingly. It should be noted that, as long as there is no conflict, the various embodiments and features in the various embodiments of the present invention can be combined with each other, and the resulting technical solutions are all within the protection scope of the present invention.

[0053] Example One

[0054] To address the aforementioned technical problems in the prior art, this invention provides a standardized method for creating an oil tank volume table.

[0055] Reference Figure 1 The standardization method for the oil tank volume table in this embodiment includes the following steps:

[0056] S110, collect initial oil tank volume tables in various formats, and perform the following processing on each collected initial oil tank volume table:

[0057] S120, use data anchors to mark the keywords in the initial tank volume table;

[0058] S130, Identify the start and end points of the feature data region based on the keywords;

[0059] S140, the feature data region is defined based on the start point and end point of the feature data region;

[0060] S150, determining a storage mode of the characteristic data of the characteristic data region based on a preset determination rule library;

[0061] S160, reading the characteristic data of the characteristic data region according to the storage mode;

[0062] S170, verifying whether the read characteristic data is missing based on a preset verification rule;

[0063] If yes, step S180 is performed;

[0064] If no, step S190 is performed;

[0065] S180, prompting missing of initial oil tank volume table data;

[0066] S190, converting the characteristic data into data conforming to a preset data storage standard, and filling the data conforming to the preset data storage standard into a preset blank standardized oil tank volume table to generate a standardized oil tank volume table, wherein the preset data storage standard comprises a unit and an attribute of the data.

[0067] In step S170, the preset verification rule comprises:

[0068] When the characteristic data region in the initial oil tank volume table comprises a main volume table region, a static pressure correction table region, an interval volume table region and a bottom volume table region and data of each region covers a complete interval from a start value to a maximum value, it is determined that the read characteristic data is not missing;

[0069] When the characteristic data region in the initial oil tank volume table comprises only the main volume table region, the static pressure correction table region and the bottom volume table region and data of each region covers a complete interval from a start value to a maximum value, and a minimum separation unit of the data of the main volume table region is centimeter, it is determined that the read characteristic data is not missing;

[0070] When the characteristic data region in the initial oil tank volume table comprises only the main volume table region, the static pressure correction table region and the interval volume table region and data of each region covers a complete interval from a start value to a maximum value, and the start value of the data of the main volume table region is zero, it is determined that the read characteristic data is not missing;

[0071] When the characteristic data region in the initial oil tank volume table comprises only the main volume table region and the static pressure correction table region and data of each region covers a complete interval from a start value to a maximum value, and a minimum separation unit of the data of the main volume table region is centimeter and the start value is zero, it is determined that the read characteristic data is not missing.

[0072] The principle of the preset inspection rule is as follows:

[0073] When the characteristic data region in the initial oil tank volume table does not exist the interval capacity table region, if the minimum division unit of the main capacity table region data is centimeter, the interval capacity table region is converted according to the main capacity table region data.

[0074] When the characteristic data region in the initial oil tank volume table does not exist the bottom capacity table region, if the starting value of the main capacity table region data is zero, the bottom capacity table region is converted according to the main capacity table region data.

[0075] The standardization method of the oil tank volume table of the embodiment can automatically process the initial oil tank volume tables in multiple formats into the standardized oil tank volume table, and provides convenience for the later work of the statistics of a large amount of oil tank data.

[0076] The standardization method of the oil tank volume table of the embodiment inspects whether the read characteristic data exists the data missing condition before converting the characteristic data, quickly screens the characteristic data meeting the standardization processing, and ensures the effectiveness of each standardized oil tank volume table.

[0077] Example Two

[0078] To solve the above technical problems in the prior art, the embodiment of the present application provides a standardization method of an oil tank volume table based on the first embodiment, wherein the method of the embodiment of the present application improves the step S190 in the first embodiment, and in the embodiment, the standardized oil tank volume table includes a main capacity table, an interval capacity table, a static pressure correction table and a bottom capacity table.

[0079] With reference to Figure 2 The standardization method of the oil tank volume table of the embodiment includes the following steps:

[0080] S210, collecting initial oil tank volume tables in multiple formats, and performing the following processing on each collected initial oil tank volume table:

[0081] S220, marking a keyword in the initial oil tank volume table through a data anchor point;

[0082] S230, identifying a starting point and an end point of a characteristic data region according to the keyword;

[0083] S240, delimiting the characteristic data region based on the starting point and the end point of the characteristic data region;

[0084] S250, determining a storage mode of the characteristic data of the characteristic data region based on a preset judgment rule library;

[0085] S260, reading feature data of the feature data area according to the storage mode;

[0086] S270, verifying whether the read feature data is missing based on a preset verification rule:

[0087] If yes, step S280 is performed;

[0088] If no, step S291 is performed;

[0089] S280, prompting missing initial oil tank volume table data;

[0090] S291, converting the feature data into data conforming to a preset data storage standard, and filling the data conforming to the preset data storage standard into a preset blank standardized oil tank volume table to generate a standardized oil tank volume table, wherein the preset data storage standard includes units and attributes of the data;

[0091] S292, verifying whether data in the main volume table, the interval volume table, the static pressure correction table and the bottom volume table is consistent based on a tank volume calculation model:

[0092] If yes, step S293 is performed;

[0093] If no, step S294 is performed;

[0094] S293, exporting the standardized oil tank volume table;

[0095] S294, prompting missing standardized oil tank volume table data.

[0096] In step S292, verifying whether data in the main volume table, the interval volume table, the static pressure correction table and the bottom volume table is consistent based on a tank volume calculation model includes the following steps:

[0097] The data in each table among the main volume table, the interval volume table, the static pressure correction table and the bottom volume table is verified in the following manner:

[0098] Sampling the data in order from a starting value to a maximum value in each table by a predetermined number, and judging whether the sampled data is uniformly upward:

[0099] When the sampled data in each table is uniformly upward, it is determined that the data in the main volume table, the interval volume table, the static pressure correction table and the bottom volume table is consistent;

[0100] When the data sampled in sequence from any one of the main capacity table, the interval capacity table, the static pressure correction table and the bottom capacity table is not uniformly upward, it is determined that the data in the main capacity table, the interval capacity table, the static pressure correction table and the bottom capacity table do not conform to consistency.

[0101] The standardization method of the oil tank volume table in the embodiment verifies whether the feature data has data missing before and after converting the feature data and generating the standardized oil tank volume table, and double verification is performed before and after the standardization of the oil tank volume table, so that the effectiveness of each standardized oil tank volume table can be further ensured.

[0102] Example Three

[0103] To solve the above technical problems in the prior art, an embodiment of the present application provides an oil tank volume table standardization method based on the first embodiment, wherein in the embodiment, the standardized oil tank volume table is an Excel table which includes a main capacity worksheet, an interval capacity worksheet, a static pressure correction worksheet and a bottom capacity worksheet.

[0104] With reference to Figure 3 The oil tank volume table standardization method of the embodiment includes the following steps:

[0105] S310, preprocessing, that is, converting the format of the initial oil tank volume table into the format of the Excel table. For the original oil tank volume table files in the text format, the txt format, the Word format and other non-Excel formats provided by the enterprise, the data files need to be converted into the Excel format, wherein the oil tank volume table is referred to as a tank table hereinafter;

[0106] S320, identifying the feature data area of each tank table file. Each tank table should have the data area of the main capacity table and the static pressure correction table regardless of the format, and can optionally have the data area of the interval capacity table and the bottom capacity table.

[0107] In the embodiment, the method for identifying the feature data area of each tank table file is a rule and an algorithm for processing and analyzing special documents such as tank table files and calibration reports. In the identification process, the key method is the data anchor point, that is, the starting point and the end point of the effective data area can be accurately identified.

[0108] In the embodiment, the interference data in the tank table file is processed. The interference data is the additional information specific to the tank table file. Some tank table original files have explanatory words unrelated to the tank table information and additional layout titles. When identifying the feature data area of each tank table file, these interference data need to be excluded.

[0109] S330, parsing the feature data area data. According to the identified feature data area, the key data in the feature data area is parsed. The key data includes title, data attribute, unit, interval, etc.

[0110] In parsing the feature data area data, the tank table data storage format is determined. For complex storage format of tank table, the extensible rule base is used for identification. The complex storage format includes: storage mode with automatic line change sub-area, mode stored according to printing format, etc. The determination of tank table data storage format is very important for data parsing, which determines whether the key data parsing is accurate.

[0111] S340, data missing test. After the key data is parsed, the determination of whether the key data is missing is made. In the determination, there are special rules for the test of oil tank table, which includes: if the interval capacity table is missing in a tank table, but the minimum partition of the main capacity table is centimeter, it is also considered as a usable tank table; for the bottom capacity table, if the bottom capacity table is missing, but the starting value of the main capacity table is zero, it is also considered as a reasonable tank table data; check the tank table model parsed, whether the data covers the complete interval from the starting value to the maximum value, etc.

[0112] S350, standardization processing of key data without data missing. The key data without data missing is standardized and saved in a unified standardized format. The standardized format is a special format for tank table processing. Tank tables of different formats are standardized to include four sheets of main capacity table, interval capacity table, static pressure correction table and bottom capacity table.

[0113] S360, automatic verification. Through the automatic verification of the imported standardized tank table by multiple rules, it is judged whether the standardized tank table data meets the consistency verification. The verification algorithm is developed for the type of oil tank table data, in which the tank volume calculation model is used. The specific process of verification is that for the standardized tank table, the method of sampling verification every certain data from 0 to the maximum value is used, and when the result meets the uniform upward and no abnormal jump data, the standardized tank table is determined to be qualified. Through automatic verification, the accuracy of the standardized tank table data can be tested, and the tank table can be automatically tested.

[0114] S370, data storage and standardized export. All qualified standardized tank tables are exported and stored.

[0115] S380, prompt and reason for unqualified standardized tank table.

[0116] The standardized method of the oil tank volume table provided by the embodiment can automatically identify tank table data in different formats and unify the data into a standard format, can batch process tank table data generated by different systems and different calibration institutions, and facilitates later statistical work.

[0117] Example Four

[0118] To solve the above technical problems in the prior art, the embodiment of the present application further provides a storage medium.

[0119] The storage medium of the embodiment has a computer program stored thereon, and the program is executed by a processor to implement the steps of the method in the above embodiment.

[0120] Example Five

[0121] To solve the above technical problems in the prior art, the embodiment of the present application further provides a computer device.

[0122] The computer device of the embodiment includes a memory and a processor, and the memory has a computer program stored thereon, and the computer program is executed by the processor to implement the steps of the method.

[0123] Although the embodiments disclosed in the present application are as above, the content described is only the embodiments adopted for the purpose of facilitating the understanding of the present application, and is not intended to limit the present application. Any person skilled in the art of the present application can make any modification and change in the implementation form and details without departing from the spirit and scope of the present application, but the protection scope of the present application shall be subject to the scope defined in the appended claims.

Claims

1. A method of standardizing tank gauges, characterized by, The method comprises the following steps: Collecting initial oil tank volume tables in various formats, and performing the following processing on each collected initial oil tank volume table: Identifying a feature data region in the initial oil tank volume table; Parsing feature data of the feature data region; Standardizing the feature data, and generating a standardized oil tank volume table according to the standardized feature data; The step of parsing feature data of the feature data region comprises the following steps: Determining a storage mode of the feature data of the feature data region based on a preset determination rule library; Reading the feature data of the feature data region according to the storage mode; After the step of reading the feature data of the feature data region according to the storage mode, the method further comprises the following steps: Based on a preset verification rule, verifying whether the read feature data is missing: When the read feature data is missing, prompting that the initial oil tank volume table is missing data; When the read feature data is not missing, performing the step of standardizing the feature data; The preset verification rule comprises: When the feature data region in the initial oil tank volume table comprises a main volume table region, a static pressure correction table region, an interval volume table region, and a bottom volume table region, and the data of each region covers a complete interval from a starting value to a maximum value, it is determined that the read feature data is not missing; When the feature data region in the initial oil tank volume table comprises only the main volume table region, the static pressure correction table region, and the bottom volume table region, and the data of each region covers a complete interval from the starting value to the maximum value, and the minimum unit of the data in the main volume table region is centimeters, it is determined that the read feature data is not missing; When the feature data region in the initial oil tank volume table comprises only the main volume table region, the static pressure correction table region, and the interval volume table region, and the data of each region covers a complete interval from the starting value to the maximum value, and the starting value of the data in the main volume table region is zero, it is determined that the read feature data is not missing; When the feature data region in the initial oil tank volume table comprises only the main volume table region and the static pressure correction table region, and the data of each region covers a complete interval from the starting value to the maximum value, and the minimum unit of the data in the main volume table region is centimeters and the starting value is zero, it is determined that the read feature data is not missing.

2. The method of claim 1, wherein, The step of identifying the feature data region in the initial oil tank volume table comprises the following steps: Marking a keyword in the initial oil tank volume table through a data anchor point; Identifying a start point and an end point of the feature data region according to the keyword; Delimiting the feature data region based on the start point and the end point of the feature data region.

3. The method of claim 1, wherein, The step of standardizing the feature data and generating a standardized oil tank volume table according to the standardized feature data comprises the following steps: Converting the feature data into data conforming to a preset data storage standard, wherein the preset data storage standard comprises a unit and an attribute of the data; Filling the data conforming to the preset data storage standard into a preset blank standardized oil tank volume table to generate the standardized oil tank volume table.

4. The method of claim 3, wherein, the standardized oil tank volume table is an Excel table including a main capacity worksheet, an interval capacity worksheet, a static pressure correction worksheet, and a bottom capacity worksheet, wherein, before the step of identifying the feature data area in the initial oil tank volume table, the method further comprises the step of: converting the format of the initial oil tank volume table into the format of the Excel table.

5. The method of claim 3, wherein, the standardized oil tank volume table includes a main capacity table, an interval capacity table, a static pressure correction table, and a bottom capacity table, and after the step of filling the data meeting the preset data storage standard into the preset blank standardized oil tank volume table to generate the standardized oil tank volume table, the method further comprises the steps of: based on the tank volume calculation model, respectively verifying whether the data in the main capacity table, the interval capacity table, the static pressure correction table, and the bottom capacity table meet the consistency: when the data in the main capacity table, the interval capacity table, the static pressure correction table, and the bottom capacity table all meet the consistency, exporting the standardized oil tank volume table; when the data in the main capacity table, the interval capacity table, the static pressure correction table, and the bottom capacity table do not meet the consistency, prompting that the data of the standardized oil tank volume table is missing.

6. The method of claim 5, wherein, based on the tank volume calculation model, respectively verifying whether the data in the main capacity table, the interval capacity table, the static pressure correction table, and the bottom capacity table meet the consistency, including the steps of: for the data in each of the main capacity table, the interval capacity table, the static pressure correction table, and the bottom capacity table, the following method is used for verification: from the starting value to the maximum value in each table, every predetermined number of data is sequentially sampled to determine whether the sequentially sampled data is uniformly upward: when the sequentially sampled data from each table is uniformly upward, it is determined that the data in the main capacity table, the interval capacity table, the static pressure correction table, and the bottom capacity table all meet the consistency; when the sequentially sampled data from any one of the main capacity table, the interval capacity table, the static pressure correction table, and the bottom capacity table is not uniformly upward, it is determined that the data in the main capacity table, the interval capacity table, the static pressure correction table, and the bottom capacity table do not meet the consistency.

7. A storage medium having stored thereon a computer program, characterized in that The computer program is executed by the processor to realize the steps of the method of any one of claims 1 to 6.

8. A computer device comprising a memory and a processor, characterized in that, The computer program is stored on the memory and is executed by the processor to realize the steps of the method of any one of claims 1 to 6.

Images