System for oil product static metering calculation, data management and inventory checking

Abstract

The invention relates to the field of data management systems, and discloses a system for oil static metering calculation, data management and inventory checking, which comprises a data access and preprocessing module which can receive liquid level height, temperature and density original data transmitted by float-type, ultrasonic-type, radar-type and other external acquisition equipment through industrial communication protocols such as Modbus, 485 bus and the like. GB / T1885-1998 and GB / T19779-2005 national standard algorithms and API American standard algorithms are built in the system, calculation standards can be switched according to needs, a temperature compensation algorithm can be automatically adapted according to oil types, national metering specifications are strictly followed, personal errors caused by manual calculation are avoided, meanwhile, outrange data can be intercepted through a data validity verification function, abnormal data do not participate in calculation, and the system is high in reliability and high in reliability. It is ensured that the metering result is accurate and meets the industrial compliance requirement, and the problems that traditional manual measurement is limited in accuracy and not uniform in standard are solved.

Description

Technical Field

[0001] This invention relates to the field of data management systems, specifically to a system for static measurement calculation, data management, and inventory counting of oil products. Background Technology

[0002] Static measurement calculation of oil products is a measurement method for calculating the volume and mass of oil products when they are stationary in containers such as oil tankers and oil tankers. It is often used for the measurement of large-scale oil product inventory and handover. At present, the measurement and inventory management of oil products in static storage environments such as storage tanks and oil tank trucks mainly rely on manual measurement and simple mechanical or electronic instruments.

[0003] Currently, manual recording and data entry processes are cumbersome. From on-site measurement to data entry into the inventory management system, it often takes several hours or even multiple working days, making it difficult to achieve real-time updates of inventory data. Although some simple automatic metering devices can collect liquid level data, they lack a linkage interface with the inventory system, requiring secondary manual transfer of data. This results in a lag in inventory status and an inability to promptly detect emergencies such as abnormal oil losses and tank leaks, increasing the business risks for enterprises. To address this, we propose a system for static oil metering calculation, data management, and inventory counting. Summary of the Invention

[0004] To address the shortcomings of existing technologies, this invention provides a system for static measurement calculation, data management, and inventory counting of oil products. It solves the problems of cumbersome manual recording and data entry processes, which often take several hours or even multiple working days from on-site measurement to data entry into the inventory management system, making it difficult to achieve real-time updates of inventory data. Although some simple automatic metering devices can collect liquid level data, they lack a linkage interface with the inventory system, requiring secondary manual transfer of data, resulting in delayed inventory status and the inability to promptly detect emergencies such as abnormal oil product losses and tank leaks, thus increasing the business risks for enterprises.

[0005] To achieve the above objectives, the present invention provides the following technical solution: a system for static measurement calculation, data management, and inventory counting of oil products, comprising:

[0006] The data access and preprocessing module can receive raw data on liquid level, temperature, and density from external acquisition devices such as float-type, ultrasonic-type, and radar-type devices via industrial communication protocols such as Modbus and 485 bus. It has a built-in certificate management submodule with preset tank number and medium type, supports importing tank capacity table files and uniquely binding them to the corresponding tank number, and switching between multiple tank groups. It also supports importing, querying, editing, and visual viewing of tank capacity table certificates in PDF format. It has a data validity verification function and can automatically report errors and prompt abnormal information for liquid level, temperature, and density data that exceed the preset range.

[0007] The metering calculation and correction module has built-in GB / T1885-1998 and GB / T19779-2005 metering standard algorithms and API American standard metering algorithm. It can switch the calculation standard according to user needs, and can automatically complete temperature compensation and density correction based on the collected data. Combined with the associated tank capacity table, it calculates the volume and mass of oil under standard conditions.

[0008] The data storage and display module can synchronously store the measurement calculation results, raw input data, and calculation timestamps into the database, and supports real-time interface display of calculation results and multi-dimensional query and retrieval of historical measurement data.

[0009] The inventory counting module can automatically perform inventory counting and update inventory records according to a preset cycle, and also allows users to query historical inventory counting records at any time.

[0010] The exception handling module immediately triggers an error reporting mechanism and records error information when an anomaly is detected. The abnormal data is not included in the measurement calculation, ensuring the reliability of the measurement results.

[0011] The practical tools submodule includes built-in functions for querying petroleum metering tables, converting density units, and querying volume correction factors. It can be linked with the metering calculation module to provide auxiliary verification support for metering work.

[0012] Furthermore, the certificate management submodule of the data access and preprocessing module also has a certificate encryption and storage function. It can perform AES256 encryption on the imported tank capacity meter certificate, and only authorized users can unlock and view the certificate content through a key, ensuring the security of the core data of the tank capacity meter. The certificate management submodule supports PDF visualization and AES256 encrypted storage of tank capacity meter certificates, and only authorized users can unlock and view them, ensuring that core metering data is not leaked. The user permission management module performs hierarchical allocation of permissions to achieve separation of rights and responsibilities for data operations. At the same time, the metering data, raw data, and timestamps are archived synchronously, supporting multi-dimensional historical queries and forming a complete data link, which solves the problems of scattered data and chaotic management in traditional systems.

[0013] Furthermore, the metering calculation and correction module also integrates an automatic back gauge calculation function, which can automatically calculate the oil level on the back gauge based on the front gauge height, receiving and dispatching mass, standard density, and metering temperature, replacing the manual calculation process. The system can automatically receive raw data from various types of acquisition devices via Modbus and 485 bus without manual input. The metering calculation and correction module can automatically complete temperature compensation, density correction, and oil volume calculation, and also integrates an automatic back gauge calculation function, replacing the traditional 10-minute manual calculation. The data storage and display module supports exporting results in multiple formats and automatically carries traceability information, greatly reducing repetitive operations for meter readers and improving calculation efficiency by more than 50%.

[0014] Furthermore, the data storage and display module supports exporting measurement results in multiple formats, including Excel reports, PDF measurement vouchers, and CSV raw data. The exported files automatically include traceability information such as report number, calculation standard, and generation time. The data access module is compatible with various acquisition devices such as float-type, ultrasonic, and radar-type sensors, as well as industrial protocols such as Modbus and 485. It can interface with existing enterprise measurement hardware. The petroleum meter query function supports multi-media adaptation, including crude oil and liquid chemicals, meeting the measurement needs of different oil products. It possesses excellent software and hardware compatibility and industry universality, solving the problem of low integration in traditional automatic metering systems.

[0015] Furthermore, the inventory counting module supports dual-mode inventory status updates. It can automatically update the inventory according to the final state after the tank handover according to a preset cycle, and it also supports users to manually enter data to complete the inventory update. It can also generate inventory counting reports for data archiving. The inventory counting module supports both automatic periodic inventory counting and manual update modes, and can generate standardized inventory counting reports. It can realize dynamic inventory monitoring and meet the needs of manual intervention in special scenarios. The multi-tank group batch configuration function can uniformly set measurement standards and warning thresholds for the same type of tanks, reduce repetitive configuration work, adapt to the large-scale management needs of enterprises with multiple storage tanks, and solve the defects of existing systems such as lagging inventory monitoring and poor adaptability.

[0016] Furthermore, the anomaly handling module can classify, mark, and trace the source of abnormal data, classifying anomalies into three categories: data exceeding the range, equipment communication interruption, and tank capacity table mismatch. It also records the time of the anomaly, the associated acquisition equipment, and the data source, facilitating users to quickly locate the cause of the anomaly. The utility tools submodule can work in conjunction with the metering module to perform auxiliary verification such as oil meter querying and density conversion, providing dual verification of metering results, reducing the impact of system failures on metering work, and improving overall operational stability.

[0017] Furthermore, the petroleum metering query function of the practical tools submodule supports multi-oil type adaptation. It can call the corresponding GB / T1885-1998 sub-item metering tables for different media such as crude oil and liquid chemicals to achieve accurate query of standard density and volume correction coefficient. The system has built-in GB / T1885-1998, GB / T19779-2005 national standard algorithms and API American standard algorithms, and can switch the calculation standard as needed. The temperature compensation algorithm can automatically adapt according to the oil type, strictly follow national metrological specifications, avoid human error in manual calculation, and the data validity verification function can block out data beyond the range. Abnormal data is not included in the calculation, ensuring that the measurement results are accurate and meet industry compliance requirements, solving the pain points of limited accuracy and inconsistent standards in traditional manual measurement.

[0018] Furthermore, the system also includes a user permission management module, which can assign permissions according to roles, dividing users into three categories: administrators, metrologists, and queryers. Administrators have system configuration and certificate management permissions, metrologists can only perform metrological calculations and data export operations, and queryers can only view historical data within their authorized scope.

[0019] Furthermore, the temperature compensation algorithm of the metering calculation and correction module can automatically switch correction logic according to the type of oil. For crude oil, the 59A standard correction formula is used, and for liquid chemicals, the 60A special correction model is used to adapt to the thermal expansion characteristics of different media.

[0020] Furthermore, the multi-tank group switching function of the data access and preprocessing module supports batch configuration of tank groups, which can divide oil tanks of the same type and medium into a tank group, realize the batch application of tank capacity table, metering standard and early warning threshold, and reduce repetitive configuration operations.

[0021] In summary, the technical effects and advantages of this invention are as follows:

[0022] 1. In this invention, the system incorporates the national standard algorithms GB / T1885-1998 and GB / T19779-2005, as well as the American standard algorithm API. The calculation standard can be switched as needed, and the temperature compensation algorithm can automatically adapt to the type of oil. It strictly follows national metrological standards, avoids human error in manual calculation, and the data validity verification function can block out data exceeding the measurement range. Abnormal data is not included in the calculation, ensuring that the measurement results are accurate and meet industry compliance requirements. This solves the pain points of limited accuracy and inconsistent standards in traditional manual measurement.

[0023] 2. In this invention, the system can automatically receive raw data from various types of acquisition devices via Modbus and 485 bus without manual input. The metering calculation and correction module can automatically complete temperature compensation, density correction and oil quantity calculation. It also integrates the automatic back gauge calculation function, replacing the traditional 10-minute manual calculation. The data storage and display module supports exporting results in multiple formats and automatically carries traceability information, greatly reducing the repetitive operations of meterers and improving the calculation efficiency by more than 50%.

[0024] 3. In this invention, the certificate management submodule supports PDF visualization of tank capacity table certificates and AES256 encrypted storage, which can only be unlocked and viewed by authorized users, ensuring that core metering data is not leaked; the user permission management module allocates permissions in a hierarchical manner to achieve separation of rights and responsibilities for data operations, while the metering data, original data, and timestamps are archived synchronously, supporting multi-dimensional historical queries and forming a complete data link, which solves the problems of scattered data and chaotic management in traditional systems.

[0025] 4. In this invention, the inventory counting module supports both automatic periodic inventory counting and manual update modes, and can generate standardized inventory counting reports, which can realize dynamic inventory monitoring and meet the needs of manual intervention in special scenarios. The batch configuration function of multiple tank groups can uniformly set the measurement standards and early warning thresholds for the same type of oil tanks, reduce repetitive configuration work, adapt to the large-scale management needs of enterprises with multiple storage tanks, and solve the defects of existing systems such as lagging inventory monitoring and poor adaptability.

[0026] 5. In this invention, the anomaly handling module can classify, mark, and trace the source of three types of anomalies: data over-range, equipment communication interruption, and tank capacity mismatch. It records the time, equipment, and source of the anomaly, helping users to quickly locate the fault. The utility tool sub-module can work in conjunction with the metering module to complete auxiliary verification such as oil meter query and density conversion, and double-verify the metering results, reducing the impact of system faults on metering work and improving the overall operational stability.

[0027] 6. In this invention, the data access module is compatible with various acquisition devices such as float type, ultrasonic type, and radar type, as well as industrial protocols such as Modbus and 485. It can be connected to the existing metering hardware of enterprises. The petroleum meter query function supports multiple media such as crude oil and liquid chemicals, meeting the metering needs of different oil products. It has good software and hardware compatibility and industry universality, and solves the problem of low integration of traditional automatic metering systems. Attached Figure Description

[0028] Figure 1 This is a schematic diagram of a system for static measurement calculation, data management and inventory counting of oil products according to the present invention. Detailed Implementation

[0029] The technical solutions of the embodiments of the present invention will be clearly and completely described below with reference to the accompanying drawings. Obviously, the described embodiments are only some embodiments of the present invention, and not all embodiments. Based on the embodiments of the present invention, all other embodiments obtained by those skilled in the art without creative effort are within the scope of protection of the present invention.

[0030] refer to Figure 1 The system shown is for static measurement calculation, data management, and inventory counting of oil products, including:

[0031] The data access and preprocessing module can receive raw data on liquid level, temperature, and density from external acquisition devices such as float-type, ultrasonic-type, and radar-type devices via industrial communication protocols such as Modbus and 485 bus. It has a built-in certificate management submodule with preset tank number and medium type, supports importing tank capacity table files and uniquely binding them to the corresponding tank number, and switching between multiple tank groups. It also supports importing, querying, editing, and visual viewing of tank capacity table certificates in PDF format. It has a data validity verification function and can automatically report errors and prompt abnormal information for liquid level, temperature, and density data that exceed the preset range.

[0032] The metering calculation and correction module has built-in GB / T1885-1998 and GB / T19779-2005 metering standard algorithms and API American standard metering algorithm. It can switch the calculation standard according to user needs, and can automatically complete temperature compensation and density correction based on the collected data. Combined with the associated tank capacity table, it calculates the volume and mass of oil under standard conditions.

[0033] The data storage and display module can synchronously store the measurement calculation results, raw input data, and calculation timestamps into the database, and supports real-time interface display of calculation results and multi-dimensional query and retrieval of historical measurement data.

[0034] The inventory counting module can automatically perform inventory counting and update inventory records according to a preset cycle, and also allows users to query historical inventory counting records at any time.

[0035] The exception handling module immediately triggers an error reporting mechanism and records error information when an anomaly is detected. The abnormal data is not included in the measurement calculation, ensuring the reliability of the measurement results.

[0036] The practical tools submodule includes built-in functions for querying petroleum metering tables, converting density units, and querying volume correction factors. It can be linked with the metering calculation module to provide auxiliary verification support for metering work.

[0037] The certificate management submodule of the data access and preprocessing module also has a certificate encryption and storage function. It can encrypt the imported tank capacity meter certificate with AES256, and only authorized users can unlock and view the certificate content through a key, ensuring the security of the core data of the tank capacity meter. The certificate management submodule supports PDF visualization of tank capacity meter certificates and AES256 encrypted storage. Only authorized users can unlock and view the certificate, ensuring that the core metering data is not leaked. The user permission management module allocates permissions in a hierarchical manner to realize the separation of rights and responsibilities for data operations. At the same time, the metering data, raw data, and timestamps are archived synchronously, supporting multi-dimensional historical queries and forming a complete data link, which solves the problems of scattered data and chaotic management in traditional systems.

[0038] The metering calculation and correction module also integrates the automatic back gauge calculation function, which can automatically calculate the oil level on the back gauge based on the front gauge height, receiving and dispatching quality, standard density, and metering temperature, replacing the manual calculation process. The system can automatically receive raw data from various types of acquisition devices via Modbus and 485 bus without manual input. The metering calculation and correction module can automatically complete temperature compensation, density correction, and oil volume calculation. It also integrates the automatic back gauge calculation function, replacing the traditional 10-minute manual calculation. The data storage and display module supports exporting results in multiple formats and automatically carries traceability information, greatly reducing repetitive operations for meter readers and improving the efficiency of measurement by more than 50%.

[0039] The data storage and display module supports exporting measurement results in multiple formats, including Excel reports, PDF measurement vouchers, and CSV raw data. Exported files automatically include traceability information such as report number, calculation standard, and generation time. The data access module is compatible with various acquisition devices such as float-type, ultrasonic, and radar-type sensors, as well as industrial protocols like Modbus and 485. It can interface with existing enterprise measurement hardware. The petroleum meter query function supports multi-media adaptation, including crude oil and liquid chemicals, meeting the measurement needs of different oil products. It possesses excellent hardware and software compatibility and industry universality, solving the problem of low integration in traditional automatic metering systems.

[0040] The inventory counting module supports dual-mode inventory status updates. It can automatically update the inventory according to the final state after the tank handover according to a preset cycle, and it also supports users to manually enter data to complete the inventory update. It can also generate inventory counting reports for data archiving. The inventory counting module supports both automatic periodic inventory counting and manual update modes, and can generate standardized inventory counting reports. It can realize dynamic inventory monitoring and meet the needs of manual intervention in special scenarios. The multi-tank group batch configuration function can uniformly set measurement standards and warning thresholds for the same type of tanks, reduce repetitive configuration work, adapt to the large-scale management needs of enterprises with multiple storage tanks, and solve the defects of existing systems such as lagging inventory monitoring and poor adaptability.

[0041] The anomaly handling module can classify, mark, and trace abnormal data, classifying anomalies into three categories: data exceeding the range, equipment communication interruption, and tank capacity mismatch. It records the time of occurrence, associated acquisition equipment, and data source, facilitating users to quickly locate the cause of the anomaly. The utility tools sub-module can work in conjunction with the metering module to perform auxiliary verification such as oil meter query and density conversion, providing double verification of metering results, reducing the impact of system failures on metering work, and improving overall operational stability.

[0042] Among them, the petroleum meter query function of the practical tools submodule supports multi-oil type adaptation. It can call the corresponding GB / T1885-1998 sub-item metering table for different media such as crude oil and liquid chemicals to achieve accurate query of standard density and volume correction coefficient. The system has built-in GB / T1885-1998, GB / T19779-2005 national standard algorithms and API American standard algorithms. The calculation standard can be switched as needed, and the temperature compensation algorithm can automatically adapt according to the oil type. It strictly follows national metrological specifications and avoids human error in manual calculation. At the same time, the data validity verification function can block out-of-range data and abnormal data will not participate in the calculation, ensuring that the measurement results are accurate and meet industry compliance requirements. This solves the pain points of limited accuracy and inconsistent standards in traditional manual measurement.

[0043] The system also includes a user permission management module, which can assign permissions according to roles, dividing users into three categories: administrators, metrologists, and queryers. Administrators have system configuration and certificate management permissions, metrologists can only perform metrological calculations and data export operations, and queryers can only view historical data within their authorized scope.

[0044] Among them, the temperature compensation algorithm of the metering calculation and correction module can automatically switch the correction logic according to the type of oil. It uses the 59A standard correction formula for crude oil and the 60A special correction model for liquid chemicals to adapt to the thermal expansion characteristics of different media.

[0045] Among them, the multi-tank group switching function of the data access and preprocessing module supports batch configuration of tank groups, which can divide oil tanks of the same type and the same medium into a tank group, realize the batch application of tank capacity table, metering standard and early warning threshold, and reduce repetitive configuration operations.

[0046] I. System Overall Architecture Deployment

[0047] In this embodiment, the system for static measurement calculation, data management, and inventory counting of oil products is deployed on the enterprise's local server, adopting a C / S architecture. The client supports Windows 7 and above operating systems, while the server is equipped with a MySQL database to store measurement data and certificate information. The system establishes communication connections with field radar level gauges, platinum resistance thermometers, and density sensors via Modbus and 485 buses. The overall architecture includes a data access and preprocessing module, a measurement calculation and correction module, a data storage and display module, an inventory counting module, an anomaly handling module, and a utility tool sub-module. These modules work together to achieve full-process management of static measurement of oil products.

[0048] II. Specific Implementation Process of Each Module

[0049] (I) Implementation of Data Access and Preprocessing Module

[0050] The multi-protocol data acquisition system connects to three radar level gauges (deployed in vertical oil storage tanks #1, #2, and #3) via the Modbus-RTU protocol, and connects to platinum resistance thermometers and online density sensors inside the tanks via a 485 bus. The data acquisition frequency is set to 1 time / minute, and it receives raw data of liquid level (unit: m), oil temperature (unit: ℃), and oil density (unit: kg / m³) in real time. For oil tanks without automatic acquisition capabilities, manual input of measurement data from handheld dipsticks and density meters is supported.

[0051] The certificate management and tank capacity table binding system has a built-in certificate management submodule. After logging in with a USB key, administrators can import tank capacity table certificates (PDF format) issued by the National Large-Capacity Metrology Station. The certificates contain core data such as the tank's decimeter capacity table and static pressure correction table. The submodule uses the AES256 algorithm to encrypt and store the certificates, which can only be unlocked and viewed by authorized metrologists. After importing, the tank capacity table is uniquely bound to the corresponding tank number (e.g., tank #1). It supports the creation of "crude oil tank groups" and "chemical tank groups," enabling batch configuration of metrological standards and early warning thresholds within the tank groups. Tanks #1 and #2 are assigned to the crude oil tank group, and tank #3 is assigned to the liquid chemical tank group.

[0052] The data validity verification system presets reasonable ranges for each parameter: liquid level 0-15m, oil temperature -10℃-60℃, crude oil density 800-900kg / m³, and liquid chemical density 750-850kg / m³. When the liquid level data of tank #1 is 16.2m, the system automatically determines it as an out-of-range anomaly, pops up a prompt box saying "Liquid level data exceeds the maximum range of the tank (15m)," and marks the data as invalid, preventing it from proceeding to the next calculation.

[0053] (II) Implementation of the Measurement Calculation and Correction Module

[0054] For crude oil tank groups, users can choose between the GB / T1885-1998 national standard algorithm or the API American standard algorithm. For the No. 3 liquefied chemical tank, the GB / T19779-2005 dedicated standard is used by default. Taking the crude oil metering of No. 1 tank as an example, after the user selects the national standard algorithm, the system starts the temperature compensation and density correction process.

[0055] Temperature compensation is performed according to the correction formula in standard 59A of GB / T1885-1998, converting the actual temperature (e.g., 28℃) into volume at a standard temperature of 20℃. The formula is as follows:

[0056] ;

[0057] in, The volume is the lookup volume at the measured temperature (taken from the tank capacity table). This is the volume correction factor (obtained through the Utilities submodule; the value corresponding to 28℃ and crude oil density of 850kg / m³). =0.992).

[0058] The density correction is based on the difference between the standard density (850 kg / m³) and the measured density (848 kg / m³), and a mass conversion is performed using the following formula:

[0059] ;

[0060] in, The standard density is 20℃. Given the water content (measured at 0.1%), the final calculated standard mass of crude oil in tank #1 is 1256.8t.

[0061] After the No. 1 tank completes the oil collection operation, given the front ruler height of 10.2m, the collected oil mass of 50t, the standard density of 850kg / m³, and the metering temperature of 28℃, the system calls the rear ruler calculation function to automatically calculate the rear ruler height as 10.8m with an accuracy of 0.5mm, replacing the traditional 10-minute manual calculation.

[0062] (III) Implementation of Data Storage and Display Module

[0063] The data synchronization storage system synchronously stores the measurement results of tank #1 (standard volume 1477.5m³, standard mass 1256.8t), raw collected data, calculation timestamp, and calculation standard (GB / T1885-1998) into the MySQL database, and establishes an index of "tank number-metering time-data type" to facilitate multi-dimensional queries.

[0064] The results display and export client interface displays the metering data of each oil tank in real time, and supports filtering historical data by oil tank number and time range. Metering personnel can export the results as Excel receipt and dispatch reports, PDF metering vouchers (automatically stamped with electronic seals) or CSV raw data. The exported files all carry traceability information such as calculation standards and generation time, which can be directly used for trade settlement archiving.

[0065] (iv) Implementation of the inventory counting module

[0066] The system is preset to automatically perform inventory count at 2:00 AM every day, updating the inventory records based on the final state after the tank handover: For tank #1, the system automatically extracts the last measurement data of the day (1256.8t) to update the inventory; if manual intervention is required, the administrator can manually enter the sampling data of tank #3 (782.3t) to complete the inventory update and generate an "Inventory Count Report", which includes information such as the type of oil, total inventory, and increase or decrease compared to the previous day for each tank.

[0067] (v) Implementation of the exception handling module

[0068] When sensor communication is interrupted in tank #2, the system will mark the anomaly type as "device communication interruption", record the time of the anomaly, the associated device (radar level gauge of tank #2) and the data source (Modbus communication link), and send an SMS warning to the administrator; at the same time, the missing data in that period will be marked as "communication anomaly" to ensure that invalid data is not included in the inventory statistics.

[0069] (vi) Implementation of the practical tools sub-module

[0070] When performing density correction on liquid chemicals in tank #3, the metrologist can use the "Volume Correction Factor Query" function in the submodule, select the "Liquid Chemicals (60A)" category, and enter the standard density of 780 kg / m³ and the measurement temperature of 30℃ to quickly find the correct volume correction factor. =0.989, which is corrected in conjunction with the metering calculation module to avoid errors from manual table lookup.

[0071] III. Implementation of User Access Management

[0072] The system has three levels of access control roles:

[0073] Administrator: Has full permissions for certificate import, system configuration, and permission allocation; can reset user passwords and back up the database.

[0074] Metrologists can only perform data viewing, measurement calculation, and result export operations; they do not have certificate modification permissions.

[0075] Inquirer: Can only view historical metering data within the authorized scope; no operational permissions.

[0076] IV. Implementation Results

[0077] In this embodiment, after the system was put into use, the measurement error of tanks 1#-3# decreased from ±0.5% calculated manually to ±0.1%, the calculation efficiency increased by 60%, the inventory counting time was shortened from 2 hours to 10 minutes, and the full-process traceability of measurement data was realized through certificate encryption and access control, which fully met the compliance and accuracy requirements of enterprises in trade settlement and inventory management.

[0078] Finally, it should be noted that the above description is only a preferred embodiment of the present invention and is not intended to limit the present invention. Although the present invention has been described in detail with reference to the foregoing embodiments, those skilled in the art can still modify the technical solutions described in the foregoing embodiments or make equivalent substitutions for some of the technical features. Any modifications, equivalent substitutions, improvements, etc., made within the spirit and principles of the present invention should be included within the protection scope of the present invention.

Claims

1. A system for static measurement calculation, data management, and inventory counting of oil products, characterized in that, include: The data access and preprocessing module can receive raw data on liquid level, temperature, and density from external acquisition devices such as float-type, ultrasonic-type, and radar-type devices via industrial communication protocols such as Modbus and 485 bus. It has a built-in certificate management submodule with preset tank number and medium type, supports importing tank capacity table files and uniquely binding them to the corresponding tank number, and switching between multiple tank groups. It also supports importing, querying, editing, and visual viewing of tank capacity table certificates in PDF format. It has a data validity verification function and can automatically report errors and prompt abnormal information for liquid level, temperature, and density data that exceed the preset range. The metering calculation and correction module has built-in GB / T1885-1998 and GB / T19779-2005 metering standard algorithms and API American standard metering algorithm. It can switch the calculation standard according to user needs, and can automatically complete temperature compensation and density correction based on the collected data. Combined with the associated tank capacity table, it calculates the volume and mass of oil under standard conditions. The data storage and display module can synchronously store the measurement calculation results, raw input data, and calculation timestamps into the database, and supports real-time interface display of calculation results and multi-dimensional query and retrieval of historical measurement data. The inventory counting module can automatically perform inventory counting and update inventory records according to a preset cycle, and also allows users to query historical inventory counting records at any time. The exception handling module immediately triggers an error reporting mechanism and records error information when an anomaly is detected. The abnormal data is not included in the measurement calculation, ensuring the reliability of the measurement results. The practical tools submodule includes built-in functions for querying petroleum metering tables, converting density units, and querying volume correction factors. It can be linked with the metering calculation module to provide auxiliary verification support for metering work.

2. The system for static measurement calculation, data management, and inventory counting of oil products according to claim 1, characterized in that: The certificate management submodule of the data access and preprocessing module also has a certificate encryption and storage function, which can encrypt the imported tank capacity table certificate with AES256, and only authorized users can unlock and view the certificate content through a key, thus ensuring the security of the core data of the tank capacity table.

3. The system for static measurement calculation, data management, and inventory counting of oil products according to claim 1, characterized in that: The metering calculation and correction module also integrates an automatic back gauge calculation function, which can automatically calculate the oil level on the back gauge based on the front gauge height, receiving and dispatching quality, standard density, and metering temperature, replacing the manual calculation process.

4. The system for static measurement calculation, data management, and inventory counting of oil products according to claim 1, characterized in that: The data storage and display module supports exporting measurement results in multiple formats. It can export calculation results in formats such as Excel reports, PDF measurement vouchers, and CSV raw data. The exported files will automatically include traceability information such as report number, calculation standard, and generation time.

5. The system for static measurement calculation, data management, and inventory counting of oil products according to claim 1, characterized in that: The inventory counting module supports dual-mode inventory status updates: it can automatically update the inventory according to the final state after the oil tank handover at a preset cycle, and it also supports users to manually enter data to complete the inventory update. It can also generate inventory counting reports for data archiving.

6. The system for static measurement calculation, data management, and inventory counting of oil products according to claim 1, characterized in that: The anomaly handling module can classify, mark, and trace the source of abnormal data, classifying the anomaly types into three categories: data over-range, equipment communication interruption, and tank capacity mismatch. It also records the time of the anomaly, the associated acquisition device, and the data source, making it easier for users to quickly locate the cause of the anomaly.

7. The system for static measurement calculation, data management, and inventory counting of oil products according to claim 1, characterized in that: The petroleum metering table query function of the utility tool submodule supports multi-oil product type adaptation. It can call the corresponding GB / T1885-1998 sub-item metering tables for different media such as crude oil and liquid chemicals to achieve accurate query of standard density and volume correction coefficient.

8. The system for static measurement calculation, data management, and inventory counting of oil products according to claim 1, characterized in that: The system also includes a user permission management module, which can assign permissions according to roles, dividing users into three categories: administrators, metrologists, and queryers. Administrators have system configuration and certificate management permissions, metrologists can only perform metrological calculations and data export operations, and queryers can only view historical data within their authorized scope.

9. A system for static measurement calculation, data management, and inventory counting of oil products according to claim 1, characterized in that: The temperature compensation algorithm of the metering calculation and correction module can automatically switch correction logic according to the type of oil. It uses the 59A standard correction formula for crude oil and the 60A special correction model for liquid chemicals to adapt to the thermal expansion characteristics of different media.

10. A system for static measurement calculation, data management, and inventory counting of oil products according to claim 1, characterized in that: The multi-tank group switching function of the data access and preprocessing module supports batch configuration of tank groups, which can divide oil tanks of the same type and medium into a tank group, realize the batch application of tank capacity table, metering standard and early warning threshold, and reduce repetitive configuration operations.

Images