CN113297829A - Gas metering instrument calibrating device and method based on spreadsheet - Google Patents
Gas metering instrument calibrating device and method based on spreadsheet Download PDFInfo
- Publication number
- CN113297829A CN113297829A CN202110560830.XA CN202110560830A CN113297829A CN 113297829 A CN113297829 A CN 113297829A CN 202110560830 A CN202110560830 A CN 202110560830A CN 113297829 A CN113297829 A CN 113297829A
- Authority
- CN
- China
- Prior art keywords
- module
- data
- main program
- computer main
- process flow
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
- G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/23—Updating
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
Abstract
The invention provides a gas metering instrument calibrating device and a gas metering instrument calibrating method based on a spreadsheet, and belongs to the field of gas meter calibration. The problems that the existing gas instrument calibrating device is inflexible to change of requirements and complex in calibrating process change are solved. The verification device comprises an electronic form setting module, an input module, an upper computer main program module and an output module, wherein the electronic form setting module is in communication connection with the upper computer main program module, the input module is in communication connection with the upper computer main program module, the upper computer main program module is in communication connection with the output module, the input module collects data of a metering instrument, the output module outputs the processed data to an external execution mechanism, and the electronic form setting module comprises a process flow form, a file form opening module, a form data reading module, a classification function data module, a process setting parameter obtaining module, a process generation module and an output control module which are sequentially connected. The method is mainly used for detecting the gas metering instrument.
Description
Technical Field
The invention belongs to the field of gas meter verification, and particularly relates to a gas meter verification device and a gas meter verification method based on a spreadsheet.
Background
The verification of the flowmeter mainly comprises verifying and measuring the content of the metering performance requirement, the general technical requirement, the control of a metering device and the like. Because the flow meters have different forms and different principles, the verification methods are different, and different input flow information needs to be given in order to realize the full coverage of the measurement range of the meters in the verification process, so the labor intensity of the verification process is increased, excessive manual interactive intervention is performed in the verification process, and excessive uncertainty is introduced to the measurement and identification results.
The existing gas meter identification system can be divided into manual, semi-automatic and full-automatic verification modes. The full-automatic calibrating device is control detection software customized for a certain type of instrument, if the detected instrument is changed or the detection process is updated, the software needs to be upgraded again or set in a complex way, and the upgrading and setting work needs professional personnel to complete, so that a larger problem is caused if the requirement is changed frequently.
Disclosure of Invention
The invention provides a gas metering instrument calibration device and a gas metering instrument calibration method based on a spreadsheet, aiming at solving the problems in the prior art.
In order to achieve the purpose, the invention adopts the following technical scheme: a gas metering instrument calibrating device based on an electronic form comprises an electronic form setting module, an input module, an upper computer main program module and an output module, wherein the electronic form setting module is in communication connection with the upper computer main program module, the input module is in communication connection with the upper computer main program module, the upper computer main program module is in communication connection with the output module, the input module acquires metering instrument data, the output module outputs the processed data to an external execution mechanism, the electronic form setting module comprises a process flow form, a file opening form module, a form reading data module, a classification function data module, a process setting parameter obtaining module, a process generation module and an output control module which are in communication connection in sequence, the file opening form module is used for opening the process flow form, and the form reading data module is used for reading form data, the classification function data module is used for classifying the read data, the process setting parameter obtaining module is used for obtaining process parameters and putting the process parameters into a corresponding database, the process procedure generating module is used for generating a process flow, and the output control module is used for outputting the process flow to the upper computer main program module.
Furthermore, the host program module of the upper computer, the module for reading the form data, the module for generating the technological process and the output control module adopt C + + writing programs.
Further, the process flow table is of the type xls or xlsx.
The invention also provides a gas metering instrument calibration method based on the spreadsheet, which comprises the following steps:
the method comprises the following steps: compiling a process flow table by using a table editor according to the verification flow;
step two: opening a process flow table, reading table data, changing the table data into a standard data format and storing the standard data format into a specified structural body in a memory;
step three: classifying the data stored in the structural body according to the function setting data and the parameter setting data, and then storing the data in a new structural body capable of updating the data and the parameters again;
step four: generating a process associated with the set electronic form data according to the obtained process parameters, and executing and transferring the process to an output file for calibrating or storing the process;
step five: outputting the process flow to a host program module of an upper computer;
step six: the input module collects data of the metering instrument and transmits the data to the upper computer main program module, the upper computer main program module transmits the process flow to the output module, and the output module outputs the processed data to the external execution mechanism.
Furthermore, the process flow table adopts password protection and reliability protection.
Compared with the prior art, the invention has the beneficial effects that: the invention solves the problems that the existing gas meter calibrating device is inflexible to change of requirements and complex in calibrating process change. The invention can realize the unified customization of the spreadsheet of the own process file according to the actual requirements of the user, has very simple operation and can realize any complex verification process setting. The setting of the verification process and the process is completed through one spreadsheet, and the user can complete the setting work of the process only by maintaining the spreadsheet. The host computer main program module completes the basic input and output functions and the basic display functions, and the specific relation between the input and the output is configured and completed by the electronic form setting module. The electronic forms are storable, modifiable and preferably customized, which makes the system particularly flexible to accommodate different uses. The invention changes the verification process flow of the gas meter into an independent file independent of the main program, the file can be generated by using a standard table editor, the change of the use requirement, the change of the process flow and the change of the verification meter can be realized by changing the independent table, the set table can be backed up and stored, namely, the table is only required to be set once for a specific requirement, the main program does not need any change, and the universality of the gas identification system is enhanced.
Drawings
FIG. 1 is a schematic structural diagram of a gas meter calibrating device based on a spreadsheet according to the present invention;
FIG. 2 is a schematic diagram of a spreadsheet setup module according to the present invention;
FIG. 3 is an exemplary diagram of a process flow table set up in accordance with the present invention.
1-a spreadsheet setting module, 2-an input module, 3-an upper computer main program module, 4-an output module, 5-a process flow table, 6-a file table opening module, 7-a form data reading module, 8-a classification function data module, 9-a process setting parameter obtaining module, 10-a process generating module and 11-an output control module.
Detailed Description
The technical solution in the embodiments of the present invention will be clearly and completely explained below with reference to the drawings in the embodiments of the present invention.
Referring to fig. 1-3 to illustrate the embodiment, a gas metering instrument calibrating device based on a spreadsheet comprises a spreadsheet setting module 1, an input module 2, an upper computer main program module 3 and an output module 4, wherein the spreadsheet setting module 1 is in communication connection with the upper computer main program module 3, the input module 2 is in communication connection with the upper computer main program module 3, the upper computer main program module 3 is in communication connection with the output module 4, the input module 2 collects metering instrument data, the output module 4 outputs the processed data to an external execution mechanism, the spreadsheet setting module 1 comprises a process flow table 5, an open file table module 6, a form reading data module 7, a classification function data module 8, an obtaining process setting parameter module 9, a generating process module 10 and an output control module 11 which are in communication connection in sequence, the file table opening module 6 is used for opening a process flow table 5, the form data reading module 7 is used for reading form data, the classification function data module 8 is used for classifying the read data, the process setting parameter obtaining module 9 is used for obtaining process parameters and placing the process parameters into a corresponding database, the process flow generating module 10 is used for generating a process flow, and the output control module 11 is used for outputting the process flow to the upper computer main program module 3.
In this embodiment, the host computer program module 3, the form data reading module 7, the process procedure generating module 10, and the output control module 11 all adopt C + + programming, and the type of the process flow table 5 is xls or xlsx.
The embodiment is a gas metering instrument calibration method based on an electronic form, which comprises the following steps:
the method comprises the following steps: compiling a process flow table 5 by using a table editor according to the verification flow;
step two: opening a process flow table 5, reading table data, changing the table data into a standard data format and storing the standard data format into a specified structural body in a memory;
step three: classifying the data stored in the structural body according to the function setting data and the parameter setting data, and then storing the data in a new structural body capable of updating the data and the parameters again;
step four: generating a process associated with the set electronic form data according to the obtained process parameters, and executing and transferring the process to an output file for calibrating or storing the process;
step five: outputting the process flow to an upper computer main program module 3;
step six: the input module 2 collects data of the metering instrument and transmits the data to the upper computer main program module 3, the upper computer main program module 3 transmits the process flow to the output module 4, and the output module 4 outputs the processed data to the external execution mechanism.
The input module 2 acquires data required by the device, converts the data into a standard data format and prepares for the next data use. The output module 4 outputs the processed data to an external execution mechanism to complete the output control function of the calibrating device. The host computer main program module 3 completes the display of the device, the interface design, the function completion, the real-time display of data, the data flow display of output, and the reading of the configuration form of the system, thereby realizing the customization of the device. The spreadsheet setup module 1 uses standard form editing tools to edit the data and complete parameter settings within the form for a particular certification instrument and certification process flow. The device is programmed in Visual C + +, is divided into two components and comprises four modules. The input module 2 and the output module 4 are interfaces for exchanging data with the outside, the input data is processed after being converted into a standard format, and is converted into a data format required by the outside to be output after being analyzed, and the data is stored in a structural body of the internal memory. The upper computer main program module 3 adopts a C + + writing program to realize graphic language display of a user interface, the main functions of the upper computer main program module 3 can be divided into two parts, and the first part has the functions of a human-computer interface, instruction execution, information display and the like; the second part of the functions is to interface data with the set spreadsheet setting module 1, correctly and reliably read the data in the process flow table 5, and automatically generate the process flow for the verification of the gas meter according to the data in the process flow table 5. In the process of reading the process flow table 5, validity verification of data in the table needs to be completed, and judgment is performed according to the valid range of the data set in the process flow table 5, wherein the validity comprises a normal value, an upper limit, a lower limit, an upper limit and a lower limit.
The open file table module 6 opens the process flow table 5; the form data reading module 7 reads form data from the opened file; the classification functional data module 8 classifies the read data; the process parameter obtaining module 9 obtains process parameters and puts the process parameters into a corresponding database; the generation process module 10 generates a suitable process according to the set data; the output control module 11 outputs the calculation result to the upper computer main program module 3. The open file table module 6 uses C + + programming, and the types of the table which can be opened include xls and xlsx; the form data reading module 7 is compiled by visual C + +, reads data in xls and xlsx, changes the data into a standard data format and stores the data in a specified structural body in a memory; the classification function data module 8 classifies the data stored in the structure according to the function setting data and the parameter setting data, and then stores the data in a new structure capable of updating the data structure and the parameters. And the process setting parameter obtaining module 9 obtains process parameters required by the verification of the gas meter according to the data in the classified structure body. The generating process module 10 generates a specific process associated with the set spreadsheet data using the C + + language according to the obtained process parameters, which process can be executed and can be saved to an output file for calibration or re-storage of the process. The output control module 11 adopts Visual C + + to write a program, so that the accurate output function customized by the final process flow is realized, and the output function is well defined in the set spreadsheet.
The process flow table 5 flexibly configures important parameters, so that a hierarchical password protection function is set, and the data of the system can be protected from being illegally changed by password protection and reliability protection. In addition, as the process flow table 5 is important, the two tables are stored and are backup to each other. The specific protection of the process table 5 includes two types, the first type is password protection, the use right is divided into 3 levels according to the use right of the parameters, and the levels are respectively a system administrator, an administrator and a user, the system administrator can change the parameters in all the process tables 5, the administrator can only change fixed parameters and can not delete data in the process tables 5, and the user can only change simple process parameters which need to be changed during operation and can not delete any data.
The right part of fig. 2 is a data provider, which uses a process flow table 5 that can be edited by the data provider using conventional tools, which process flow table 5 has certain reliability and safety measures. The left part of fig. 2 is a user of data, processes and processes the data, and the processing flow is as shown in fig. 2. The data user and the data provider are closely related, dependent and restricted. The relationship between the user of the data and the provider of the data is: the user of the data only has an execution function, and the specific fine actions to be completed need the provider of the data to set and restrict. The user of the data adopts visual C + + to write programs, and the provider of the data can use wps or excel tools to design, so that the data can be separated from the data. The process of making the process file and the programming thereof do not need a special programmer to change the main program, but only wps or excel software is needed, so that the gas verification system has convenient flexibility.
As shown in fig. 3, it is an example of a specific set process flow table 5, and the process flow table 5 defines all processes of a specific verification meter, including left and right parameter settings, project design, and execution sequence as a natural number sequence of the table. The table contains a form set number entry that is a required entry, protected, non-deletable, and only subject to change, and that determines the steps of the system's aggregate process flow, which is an important parameter. The remaining parameters may be varied. The flow verification points can be set according to national verification rules or special enterprise standards, the data of the verification points can be set freely, and different verification flows can be set according to the types of instruments and the verification outline requirements. The system can collect data of outlet pressure, inlet pressure, medium pressure and medium temperature, and can also set other data quantity, wherein DO is digital quantity output, DI is digital quantity input, AI is analog quantity input, AO is analog quantity output, and PI is pulse quantity input. Calibration devices such as sonic nozzles, bell jars, etc. may also be provided. The data in the table can be changed to change the process effect.
The working principle is as follows: the input module 2, the upper computer main program module 3 and the output module 4 complete basic input and output functions and basic display functions, and the specific relation between input and output is configured by the spreadsheet setting module 1. The process flow table 5 is storable, modifiable and preferably customizable, which makes the configuration of the apparatus particularly flexible and adaptable to various uses.
The working process is as follows: firstly, setting a process flow table 5 or selecting the existing process flow table 5 to provide for a device, automatically starting the device, reading the table, storing the table into a memory, and then generating an execution step of a program according to the setting requirements of the process flow table 5 so as to finish the verification work of the gas meter.
The present invention provides a gas metering instrument calibration device and calibration method based on spreadsheet, which are introduced in detail above, and the principle and implementation of the present invention are explained by applying specific examples, and the description of the above examples is only used to help understanding the method and core ideas of the present invention; meanwhile, for a person skilled in the art, according to the idea of the present invention, there may be variations in the specific embodiments and the application scope, and in summary, the content of the present specification should not be construed as a limitation to the present invention.
Claims (5)
1. The utility model provides a gas metering device calibrating installation based on spreadsheet which characterized in that: the device comprises an electronic form setting module (1), an input module (2), an upper computer main program module (3) and an output module (4), wherein the electronic form setting module (1) is in communication connection with the upper computer main program module (3), the input module (2) is in communication connection with the upper computer main program module (3), the upper computer main program module (3) is in communication connection with the output module (4), the input module (2) acquires metering instrument data, the output module (4) outputs the processed data to an external execution mechanism, the electronic form setting module (1) comprises a process flow form (5), a file opening form module (6), a form data reading module (7), a classification function data module (8), a process setting parameter obtaining module (9), a process generation module (10) and an output control module (11) which are in communication connection in sequence, the file table opening module (6) is used for opening a process flow table (5), the form data reading module (7) is used for reading form data, the classification function data module (8) is used for classifying the read data, the process setting parameter obtaining module (9) is used for obtaining process parameters and placing the process parameters into a corresponding database, the process flow generating module (10) is used for generating a process flow, and the output control module (11) is used for outputting the process flow to the upper computer main program module (3).
2. A spreadsheet-based gas meter verification device as claimed in claim 1, wherein: the host computer main program module (3), the form data reading module (7), the process generation module (10) and the output control module (11) are written in a C + + mode.
3. A spreadsheet-based gas meter verification device as claimed in claim 1, wherein: the process flow table (5) is of the type xls or xlsx.
4. A method of calibrating a spreadsheet-based gas meter calibration device according to claim 1, wherein: it comprises the following steps:
the method comprises the following steps: compiling a process flow table (5) by using a table editor according to the verification flow;
step two: opening a process flow table (5), reading table data, and storing the table data into a specified structural body in a memory in a standard data format;
step three: classifying the data stored in the structural body according to the function setting data and the parameter setting data, and then storing the data in a new structural body capable of updating the data and the parameters again;
step four: generating a process associated with the set electronic form data according to the obtained process parameters, and executing and transferring the process to an output file for calibrating or storing the process;
step five: outputting the process flow to an upper computer main program module (3);
step six: the input module (2) collects data of the metering instrument and transmits the data to the upper computer main program module (3), the upper computer main program module (3) transmits the process flow to the output module (4), and the output module (4) outputs the processed data to an external execution mechanism.
5. The spreadsheet-based gas metering instrument verification method of claim 4, wherein: the process flow table (5) adopts password protection and reliability protection.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110560830.XA CN113297829A (en) | 2021-05-22 | 2021-05-22 | Gas metering instrument calibrating device and method based on spreadsheet |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110560830.XA CN113297829A (en) | 2021-05-22 | 2021-05-22 | Gas metering instrument calibrating device and method based on spreadsheet |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN113297829A true CN113297829A (en) | 2021-08-24 |
Family
ID=77323829
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110560830.XA Pending CN113297829A (en) | 2021-05-22 | 2021-05-22 | Gas metering instrument calibrating device and method based on spreadsheet |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113297829A (en) |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102183737A (en) * | 2011-03-11 | 2011-09-14 | 浙江中控自动化仪表有限公司 | Multi-channel and multi-parameter automatic verification system and automatic verification method |
| CN102998028A (en) * | 2012-12-27 | 2013-03-27 | 重庆川仪自动化股份有限公司 | Ultrasonic heat meter verification system |
| CN104111436A (en) * | 2014-08-05 | 2014-10-22 | 上海市计量测试技术研究院 | Automatic detection system and method for digital multimeter |
| CN104266731A (en) * | 2014-10-21 | 2015-01-07 | 中山欧麦克仪器设备有限公司 | System for verifying electromagnetic flowmeter |
| CN105526998A (en) * | 2016-02-26 | 2016-04-27 | 成都千嘉科技有限公司 | Communication-based electronic gas meter detection device and method |
| CN112344980A (en) * | 2019-08-09 | 2021-02-09 | 浙江中控技术股份有限公司 | Full-automatic verification system and method for pointer instrument |
-
2021
- 2021-05-22 CN CN202110560830.XA patent/CN113297829A/en active Pending
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102183737A (en) * | 2011-03-11 | 2011-09-14 | 浙江中控自动化仪表有限公司 | Multi-channel and multi-parameter automatic verification system and automatic verification method |
| CN102998028A (en) * | 2012-12-27 | 2013-03-27 | 重庆川仪自动化股份有限公司 | Ultrasonic heat meter verification system |
| CN104111436A (en) * | 2014-08-05 | 2014-10-22 | 上海市计量测试技术研究院 | Automatic detection system and method for digital multimeter |
| CN104266731A (en) * | 2014-10-21 | 2015-01-07 | 中山欧麦克仪器设备有限公司 | System for verifying electromagnetic flowmeter |
| CN105526998A (en) * | 2016-02-26 | 2016-04-27 | 成都千嘉科技有限公司 | Communication-based electronic gas meter detection device and method |
| CN112344980A (en) * | 2019-08-09 | 2021-02-09 | 浙江中控技术股份有限公司 | Full-automatic verification system and method for pointer instrument |
Non-Patent Citations (3)
| Title |
|---|
| 杨 霞: "基于 EXCEL 的电测仪表自动检定方法", 《技术与市场》 * |
| 莫文雄等: "基于模版匹配和查表法的高精度指针式仪表自动检定系统研制", 《电测与仪表》 * |
| 黄雨等: "基于iFIX的差压流量计自动检定系统设计与实现", 《冶金自动化》 * |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US7302675B2 (en) | System and method for analyzing a graphical program using debugging graphical programs | |
| US7849449B2 (en) | Implementing a design flow for a programmable hardware element that includes a processor | |
| US8176471B2 (en) | Static binding of nodes to virtual instruments in a graphical program | |
| US6163763A (en) | Method and apparatus for recording and viewing error data generated from a computer simulation of an integrated circuit | |
| US6263301B1 (en) | Method and apparatus for storing and viewing data generated from a computer simulation of an integrated circuit | |
| CN112131829A (en) | Verification method, system and related device of chip register | |
| CN107844424A (en) | Model-based testing system and method | |
| CN109063362B (en) | Avionics software interface control file design management system | |
| CN104615928B (en) | Measurement and examination method, verification system and server | |
| CN110196720A (en) | A kind of Simulink generates the optimization method of dynamic link library | |
| US8527964B2 (en) | Measurement project analyzer | |
| CN111650847A (en) | Method for integrating actuator model in aeroengine hardware on loop platform | |
| US6421634B1 (en) | Interface independent test system | |
| US7647578B2 (en) | Programmatic creation and management of tasks in a graphical program | |
| CN115345101A (en) | UVM-based chip register verification method | |
| CN113297829A (en) | Gas metering instrument calibrating device and method based on spreadsheet | |
| CN115392176B (en) | SoC chip top module integrated design method and system | |
| CN114841119B (en) | Register modeling method, device, equipment and medium in multi-user mode | |
| CN113485879A (en) | Labview-based automatic testing method for calling vivado-tcl script | |
| CN112027111A (en) | Real-time acquisition and display method and system for aircraft bus data | |
| CN106154144A (en) | The generation method of CPU element test graphics vector | |
| CN111240979A (en) | Method and system for man-machine interaction logic engine for artificial intelligence | |
| US20130262016A1 (en) | Automatically Configuring a Measurement System Using Measurement Results Data Capture Images Annotated with Instrumentation Configuration | |
| CN109542760A (en) | A kind of Virtual prototype mutation testing case generation method based on equipment specification | |
| CN109542698A (en) | A kind of Virtual prototype error-detecting method based on mutation testing |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20210824 |
|
| WD01 | Invention patent application deemed withdrawn after publication |