A digital original record template management system and management method for metrology

Abstract

The application discloses a kind of digital original record template management system and management method for metrology, the system includes procedure specification module and appliance model module, procedure specification module includes basic data layer, structured data layer and association rule layer, basic data layer is used to store procedure specification metadata and unitized electronic form, structured data layer is structured and multi-dimensional index to metrology data, association rule layer maintains the mapping relationship of key information of instrument to be calibrated with procedure specification and measurement method and unitized electronic form;Appliance model module includes intelligent matching engine and combination generation engine, for automatically matching corresponding procedure specification, measurement item and measurement method, unitized electronic form is automatically matched based on mapping relationship, unitized electronic form is combined according to measurement item order, and digital original record template is generated.The application can reduce original record template storage, reduce template maintenance cost, meet the compliance calibration needs of different scenarios.

Description

Technical Field

[0001] This invention belongs to the field of metrology and calibration, and in particular relates to a management system and method for digital raw record templates used in metrology. Background Technology

[0002] The original metrological (verification / calibration) records of metrology laboratories are the core foundation for ensuring the compliance of metrological activities, data integrity, and traceability of results, and are also a key support for the effective operation of the laboratory management system. With the advancement of digital transformation in the industry, original records are gradually evolving from paper-based to electronic formats, solving problems such as the susceptibility to errors, high storage costs, and low retrieval efficiency of paper records. However, large-scale comprehensive metrology laboratories still face five major pain points in the development, management, and application of digital original record templates: (1) Low management efficiency: Large metrology laboratories usually need to maintain 20,000 to 40,000 different original record templates. Each template needs to be continuously revised with the updates of technical documents such as verification procedures or calibration specifications, and also needs to be continuously revised with the technical iteration of instrument models. The problems of large storage space and chaotic version management are prominent, and the annual maintenance cost is high. (2) Incomplete coverage of measurement methods: The same measurement item in a single technical document often has multiple compliant measurement methods, corresponding to different standard instrument configurations and data processing rules, etc. Most laboratories only make templates for commonly used methods, which cannot cover all compliant measurement paths; (3) High cost of model adaptation: The metrological characteristics of different models of instruments under the same technical document are different. The laboratory usually needs to make a separate template for each model, which results in a large amount of repetitive development work and a high error rate in template compilation. (4) Delayed response to customization: For customized measurement projects proposed by customers, it is necessary to make special templates on the spot. The delivery cycle is usually calculated in days, which affects the delivery efficiency of measurement business and increases management complexity. (5) Insufficient automation adaptability: Existing digital raw record templates do not have pre-built standardized automated calibration programming and lack automated data acquisition design. Most of the current mainstream automated calibration solutions are dedicated platforms provided by instrument manufacturers, which only support instruments of a single brand and lack unified calibration capabilities across manufacturers and types of instruments. Furthermore, mainstream automatic calibration systems have difficulty in automatically entering data into digital raw record templates and judging measurement results. Summary of the Invention

[0003] The purpose of this invention is to provide a digital raw record template management system and management method for metrology, which can cover all measurement methods in verification procedures and calibration specifications, support flexible configuration of measurement methods, reduce raw record template storage, reduce template maintenance costs, and meet the compliance calibration requirements of different scenarios.

[0004] To achieve the above objectives, one aspect of the present invention provides a digital raw record template management system for metrology, including a procedure specification module and an instrument model module; The procedure specification module has a three-layer data architecture, including a basic data layer, a structured data layer, and an association rule layer. The basic data layer is used to store procedure specification metadata, unitized spreadsheets, and information on standard instruments and instruments to be calibrated. The procedure specification metadata includes the procedure specification number and name, as well as the corresponding measurement items and measurement methods. The unitized spreadsheets are built based on a single measurement method for a single measurement item in the procedure specification and are used to store metrological data and SCPI instructions. The structured data layer adopts a wide table structure and uses globally unique cell addresses to structure and index the measurement data. It can automatically fill the measurement data into the unitized spreadsheet according to SCPI instructions. The association rule layer is used to maintain the mapping relationship between the key information of the calibrated instrument and the procedure specifications, as well as the mapping relationship between the measurement method and the unitized spreadsheet. The instrument model module includes an intelligent matching engine and a combination generation engine. The intelligent matching engine is used to automatically match the corresponding procedures and specifications and all its measurement items and corresponding measurement methods by searching in the procedure and specification module based on the key information of the instrument being calibrated. The combined generation engine is used to automatically match the corresponding unitized spreadsheet in the procedure specification module based on the mapping relationship between the measurement method and the unitized spreadsheet, according to the measurement items and measurement methods selected from the automatically matched measurement items and measurement methods. It combines the matched unitized spreadsheets in the order of measurement items to generate a digital original record template, and automatically fills the digital original record template with information on standard instruments and instruments under calibration, measurement points, permissible errors and measurement uncertainty components.

[0005] Another aspect of the present invention provides a method for managing digital raw record templates for measurement, which utilizes the above-described system to manage raw record templates, including: Step S1: Create a blank spreadsheet, obtain the key information of the instrument to be calibrated, and based on the mapping relationship between the key information and the procedures and specifications, retrieve the corresponding procedures and specifications in the procedures and specifications module, list all measurement items and corresponding measurement methods of the procedures and specifications, and provide them to the user for selection. Step S2: Responding to the measurement items and corresponding measurement methods selected by the user, based on the mapping relationship between the measurement methods and the unitized spreadsheets, match the corresponding unitized spreadsheets in the procedure specification module, copy the matched unitized spreadsheets and arrange them in the order of the measurement items in the blank spreadsheets to generate a digital original record template. Step S3: Based on the information of the instrument under calibration and the standard instruments, automatically calculate the measurement points of the instrument under calibration parameters, and automatically fill in the measurement points, allowable error and measurement uncertainty components in the digital original record template.

[0006] According to the above-described aspects of the metrology digital original record template management system and management method of the present invention, it can cover all measurement methods of verification procedures and calibration specifications, support flexible configuration of measurement methods, reduce the storage of original record templates, reduce template maintenance costs, and meet the compliance calibration requirements of different scenarios. Attached Figure Description

[0007] To more clearly illustrate the technical solutions of the present invention, the accompanying drawings used in the description of the embodiments of the present invention will be briefly introduced below. Obviously, the drawings described below are only some embodiments of the present invention. For those skilled in the art, other drawings can be obtained based on these drawings without creative effort: Figure 1 This is a schematic diagram of the structure of a digital raw record template management system for measurement according to an embodiment of the present invention; Figure 2 This is a schematic diagram illustrating an application scenario of the digital raw record template management system for measurement according to an embodiment of the present invention; Figure 3 This is a flowchart of a method for managing digital raw record templates for measurement according to an embodiment of the present invention. Detailed Implementation

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

[0009] One embodiment of the present invention provides a digital original record template management system for measurement, capable of building and maintaining modular spreadsheets, and automatically matching modular spreadsheets to form digital original record templates that meet usage requirements. For example... Figure 1 As shown, the digital original record template management system for measurement in this embodiment of the invention includes a procedure specification module and an instrument model module.

[0010] The procedures and specifications module serves as the core data foundation of the system, storing all measurement-related structured data and employing a three-tier data architecture design. The three layers are: the basic data layer, the structured data layer, and the association rule layer.

[0011] The basic data layer stores specification metadata (including but not limited to: number, name, scope of application, implementation date, measurement item, measurement method), a unitized spreadsheet library, and a library of standard instruments and calibration instrument parameters. Among them, the unitized spreadsheet serves as the smallest data unit of measurement results, constructed for a single measurement method for a single measurement item, and supports storing multiple types of data such as numerical values, text, SCPI (Standard Commands for Programmable Instruments) instructions, and dynamic functions.

[0012] The pre-defined core fields in the modular spreadsheet include: metrological attribute fields, automation fields, and management fields. Metrological attribute fields include: verification / calibration item name, standard value, nominal value or indicated value, indication error, permissible error, measurement uncertainty, and measurement uncertainty components. The standard value is the displayed value or reading of the standard instrument, the nominal value is the displayed value of the instrument being calibrated, and the indicated value is the reading of the instrument being calibrated. Automation fields include: SCPI program control commands, data acquisition mapping rules, and dynamic calculation formulas. Management fields include: unique identifier, version number, associated technical document number, and range of instrument models used.

[0013] The structured data layer employs a wide-table storage structure, with each cell possessing a globally unique address identifier. It supports complex data organization formats such as row-column organization, nested structures, and virtual columns, and is responsible for the logical organization, multi-dimensional indexing, and business presentation of the basic data. Logical organization involves structuring the metrological data, establishing business relationships between data through rows, columns, nesting, and wide tables. Multi-dimensional indexing establishes rapid retrieval capabilities based on dimensions such as instrument, project, time, location, and standard, supporting dynamic queries. Business presentation transforms metrological data into calibration record tables, certificates, and other display formats that meet metrological management requirements through mapping rules, virtual columns, and calculation formulas.

[0014] In short, the basic data layer stores the original measurement values ​​and calculation results of metrological calibration, which is the foundation for measurement value traceability and data authenticity. The structured data layer references fields in the basic data layer through cell addresses, thereby decoupling the logical structure from the physical data. This satisfies the multi-dimensional storage needs of metrological data while ensuring measurement value uniformity, traceability, and reusability.

[0015] The association rule layer maintains the mapping relationship between instrument models and procedures, the mapping relationship between measurement methods and unitized spreadsheets, cross-table data reference rules, and condition triggering logic, thereby realizing dynamic association and adaptation of data.

[0016] The instrument model module is a functional execution layer geared towards real-world business scenarios. It is responsible for generating directly usable digital raw record templates and driving automated calibration processes. The instrument model module includes an intelligent matching engine, a combination generation engine, an automatic calibration engine, and secondary development interfaces.

[0017] Intelligent matching engine: Based on the input key information such as the model and name of the instrument being calibrated, the engine automatically matches the corresponding procedures, specifications, measurement items and optional measurement methods through a dynamic query architecture built from the intermediate tables in the database. These are presented to the user in a checklist format. Customized requirements can also be entered. The built-in NLP (Natural Language Processing) module can automatically parse the text requirements, perform semantic processing and map them into structured query conditions.

[0018] The combined generation engine automatically matches corresponding modular spreadsheets based on the user's selected measurement items, methods, and customization requirements. It then generates digital raw record templates by combining these templates in the order of the measurement items, automatically filling in predefined information such as instrument parameters, measurement points, permissible errors, and uncertainty components. Measurement point generation follows metrological principles; linear ranges use equally spaced sampling, while wide-range parameters (such as frequency and attenuation) employ logarithmic equally spaced algorithms, ensuring full-range coverage while minimizing data redundancy.

[0019] Automatic calibration engine: It parses the SCPI instructions in the original record, sends programmable commands to the standard instrument and the instrument being calibrated through the metrology adapter, automatically collects measurement data and fills it into the corresponding cells, automatically calculates the indication error and the combined measurement uncertainty based on the preset formula, completes the qualification judgment, and supports data traceability throughout the process.

[0020] Secondary development interface: Open unitized spreadsheet editing permissions, support custom measurement methods, modify SCPI instructions, and adjust calculation formulas to meet personalized business needs. All modifications are automatically recorded with version information, operator and operation time, and backtracking is supported.

[0021] Application scenarios of the digital original record template management system for measurement according to embodiments of the present invention are as follows: Figure 2 As shown, a metrology system is formed by connecting the metrology adapter to the standard instrument and the instrument being calibrated.

[0022] The metering adapter consists of an interface adapter, a data acquisition card, and an adapter cable, forming the hardware connection layer. It supports mainstream instrument communication interfaces such as VISA (Virtual Instrument Software Architecture), TCP / IP, USB (Universal Serial Bus), and GPIB (General Purpose Interface Bus), enabling command transmission and data interaction between standard instruments, the instruments being calibrated, and the original record template management system. It also supports automatic device address scanning and identification, eliminating the need for manual configuration.

[0023] Standard instruments are reference objects with definite values ​​and measurement uncertainties used in metrological verification / calibration to realize the definition of a given quantity.

[0024] The instrument being calibrated is the measurement object that needs to be verified or calibrated, usually a single instrument or a single device.

[0025] Another embodiment of the present invention provides a method for managing digital original record templates for measurement, which utilizes the above-described method for managing digital original record templates for measurement. For example... Figure 3 As shown, the method of this embodiment includes the following steps S1-S3, and no manual editing of the table format is required throughout the process.

[0026] Step S1: Information Acquisition and Matching. Launch the instrument model module, import the list of instruments to be calibrated, select one instrument, create a blank spreadsheet, and obtain key information about the instrument, such as its model and name. Match the corresponding technical documents (verification procedures or calibration specifications, etc.) based on the mapping relationship. Search the procedure / specification module using the field mapping relationship to locate the corresponding technical document (procedure / specification) number and name, and automatically extract all measurement items and their corresponding measurement methods. List all measurement items and corresponding measurement methods under this technical document for the user to select. A customizable checkbox is set in the upper left corner of the pop-up list, allowing users to input custom requirements after selection.

[0027] Step S2: Project Selection and Unit Matching. The user-selected measurement items, measurement methods, and customized requirements are marked and mapped to the corresponding unitized spreadsheets in the specification module using unique identifiers. The selected unitized spreadsheets are then copied to the created blank spreadsheet. If the user selects the customization option, custom requirements can be entered and automatically adapted to the specified location in the template.

[0028] Step S3: Template Generation and Parameter Filling. The system sorts the matched unitized spreadsheets according to the measurement items. Based on the parameters of the instrument under test and the standard instruments, it automatically calculates the measurement points of the instrument under test and automatically fills in information such as measurement points, permissible errors, and measurement uncertainty components. It also embeds the corresponding SCPI automatic calibration instructions to generate a complete and executable digital raw record template.

[0029] The following provides a more detailed explanation of each step.

[0030] Step S1: First, launch the instrument model module, import the list of instruments to be calibrated, select one instrument from the list, and create a blank spreadsheet. Obtain key information about the instrument to be calibrated, such as instrument model and name, through field matching. The specific steps for capturing key information are: first capture the corresponding fields, such as instrument model and instrument name, and then locate the relevant information. After confirming the key information of the instrument to be calibrated, the system matches the corresponding technical documents (including verification procedures, calibration specifications, etc.) in the procedure and specification module according to the mapping relationship. Through the field mapping relationship, the system retrieves and locates the key information of the corresponding technical documents in the procedure and specification module database. Key information includes number, name, measurement items, measurement methods, etc. The system automatically extracts all measurement items and corresponding measurement methods. A pop-up window appears, displaying a list of all measurement items and corresponding measurement methods under the technical documents matched for the instrument to be calibrated. The pop-up list is a checkbox for user selection. A customized checkbox is located in the upper left corner of the pop-up list, allowing users to enter custom requirements.

[0031] Taking the instrument model field as an example, if the instrument model being calibrated is "8491B", it is matched against the procedure and specification data in the procedure and specification module. Based on the mapping relationship between the field identification value and the procedure and specification data, the "instrument model" field is searched one-to-one in the procedure and specification data. After finding the corresponding instrument model, the procedure and specification number and other information matching that instrument model are located. After the system obtains the matching record for "Instrument Model 8491B", it extracts the matching procedure specification number "JJF 2092-2024", procedure specification name "Radio Frequency and Microwave Attenuator Calibration Specification", procedure specification measurement items and covered measurement methods. "Measurement Item 1: Attenuation of Variable Attenuator" includes "Measurement Method 1.1 Inductive Voltage Divider Attenuation Standard Device Method", "Measurement Method 1.2 Attenuation Calibration Device Method", "Measurement Method 1.3 Measurement Receiver Method", "Measurement Method 1.4 Vector Network Analyzer Method", and "Measurement Method 1.5 Voltmeter Method". "Measurement Item 2: Inherent Attenuation of Variable Attenuator (Attenuation of Fixed Attenuator)" includes "Measurement Method 2.1 Inductive Voltage Divider Attenuation Standard Device Method", "Measurement Method 2.2 Attenuation Calibration Device Method", "Measurement Method 2.3 Measurement Receiver Method", "Measurement Method 2.4 Vector Network Analyzer Method", and "Measurement Method 2.5 Voltmeter Method". "Measurement Item 3: Voltage Standing Wave Ratio" includes "Measurement Method 3.1 Voltage Standing Wave Ratio". The extracted and captured process specification number, process specification name, process specification measurement items, and the measurement methods covered by those items are copied to a pop-up window for display. The displayed process specification measurement items and the measurement methods they cover allow users to select the desired measurement items and corresponding methods. The search for the instrument name field is the same as the search for the instrument model field, only the field type differs.

[0032] Step S2: After the user selects the measurement requirements, the system marks the selected measurement items and methods. The measurement items and methods listed in the pop-up window are mapped from the specification data. Through this mapping, the corresponding measurement items and methods in the specification data can be found and located. Each measurement method has a unique identifier, and each unitized spreadsheet in the specification module also has a unique identifier. A mapping mechanism is pre-established between the measurement methods and the unitized spreadsheets in the specification module. An application-layer logical dynamic query architecture is pre-built between the measurement methods and the unitized spreadsheets in the specification module using an intermediate database table. That is, each measurement method corresponds to a specific unitized spreadsheet in the specification module. The application-layer logical dynamic query architecture typically has two modes: one is where the application layer calls a function to execute a fixed SQL selection; the other is where the application layer receives a query description object, interprets business rules, generates dynamic SQL statements, and then executes them. The association between the measurement method and the unitized spreadsheet is achieved by mapping the unique identifier of the measurement method to the unique identifier of the unitized spreadsheet. By associating the measurement items and their corresponding measurement methods listed in the pop-up window with the measurement methods in the specification data, the system achieves the association between the measurement items and their corresponding measurement methods listed in the pop-up window and the unitized spreadsheet. That is, when the pop-up window lists all measurement items and measurement methods corresponding to the specification at the end of step S1, the displayed measurement items and their measurement methods can be matched to the measurement methods in the specification data of the specification module through a mapping relationship, and then matched to the unique unitized spreadsheet in the specification through another mapping relationship. After the system recognizes that the user has checked the "Customization" option, if the "Customization" option is checked, the cell restrictions below the "Customization" option are removed, allowing text input, and the customized requirement information entered by the user is copied to the specified cell location in the original record spreadsheet; if the "Customization" option is not checked, no operation is performed. Customization requirements include, but are not limited to, the requirements of the measurement items, the measurement methods used for the measurement items, etc., including the measurement items and their corresponding measurement methods selected by the user according to the customization requirements.

[0033] Step S3: After Step S2 identifies the measurement items and their corresponding measurement methods, and locates the corresponding unitized spreadsheets in the procedure specification module through mapping relationships, the system copies these unitized spreadsheets to the newly created spreadsheet in Step S1. These unitized spreadsheets are sorted according to the order of the measurement items. The unitized spreadsheets are constructed based on the procedure specification measurement methods and include, but are not limited to, verification / calibration item names, standard values, nominal values ​​or indicated values, errors, permissible errors, and measurement uncertainties. UAutomatic calibration commands (usually SCPI commands). In step S1, the system captures the model information of the instrument being calibrated. Through mapping relationships, it searches for the corresponding standard instrument information and calibrated instrument information based on the "instrument model" field in the standard instrument information and calibrated instrument information. Then, based on the measurement items and corresponding measurement methods selected by the user, it matches the standard instruments corresponding to the measurement methods in the searched standard instrument information. Finally, it obtains the standard instrument information and calibrated instrument information matching the instrument model and the selected measurement method. The system copies this information to the spreadsheet containing the standard instrument and calibrated instrument information. Simultaneously, the system obtains the range information of the calibrated instrument. The range information is stored in the standard instrument information and calibrated instrument information. Following the principle of covering at least 5 measurement points covering the upper and lower limits of the range, it calculates the measurement points for the corresponding measurement items based on the equal-interval method. Taking 5 measurement points as an example, when the range is [-L, L], the upper and lower limits of the range are defined by function calls, with the measurement point interval being... The calculated measurement points are: -L, -L / 2, 0, L / 2, L. Then, the system obtains the permissible error of the measurement points of the instrument being calibrated. This permissible error is stored in the standard instrument information and the instrument being calibrated information involved in the digital model. The permissible error of the corresponding measurement point is imported into the corresponding cell. If the preset permissible error is not a single value but is associated with a calculation formula for the measured point, the calculation formula is imported and associated with the measured point value. Next, the system obtains information on the influence of the standard instrument and the instrument being calibrated on the measurement uncertainty components. This information is stored in the standard instrument information and the instrument being calibrated information. The measurement uncertainty components influenced by the standard instrument are imported into the corresponding measurement uncertainty component cells. The information on the influence of the standard instrument on the measurement uncertainty components includes, but is not limited to, the influence of the expanded uncertainty of the superior institution, the influence of the standard instrument's own resolution, and the influence of the measurement method. The information on the influence of the instrument being calibrated on the measurement uncertainty components includes, but is not limited to, the influence of the resolution of the instrument being calibrated.

[0034] Once the digitized original record template is generated, the automatic calibration process can be started directly. The specific steps are as follows: 1) The system pops up a connection prompt, guiding the user to complete the hardware connection of the computer, standard instruments, and instrument under calibration through the metrology adapter, and automatically identifies the instrument's communication address; 2) Click the automatic calibration start button. The system will execute the preset SCPI instructions in the original record in sequence, send control instructions to the standard instrument and the instrument being calibrated in turn, and automatically collect measurement data and fill it into the corresponding cells. 3) The indication error and measurement uncertainty are automatically calculated based on preset formulas, and the error is compared with the allowable error to complete the qualification judgment. No manual intervention is required throughout the process. 4) After calibration, the system automatically checks the data integrity. If there are any missing or abnormal data, it prompts for retesting. If all data is normal, the system automatically saves the original record and supports exporting it to a standardized format for cross-system interaction.

[0035] Taking the calibration of the 8491B type coaxial fixed attenuator as an example, the method for managing digital raw record templates for measurement according to embodiments of the present invention will be further described in detail.

[0036] Activate the instrument model module, import the list of instruments under test, select the 8491B coaxial fixed attenuator, and create a blank spreadsheet. Within the blank spreadsheet, the system retrieves key information about the 8491B coaxial fixed attenuator: the "Instrument Model" field is identified as "8491B," and the "Instrument Name" field is identified as "Coaxial Fixed Attenuator." Based on the "Instrument Model" field and the identification value "8491B," a match is performed. The "Instrument Model" is then matched against the specification data in the specification module, and a search is conducted within the "Instrument Model" data. Once the instrument model "8491B" is found, its information is located. Then, by mapping this information with the specification number and other information in the specification data, we can obtain and extract the specification number "JJF 2092-2024" corresponding to the "8491B" model, the specification name "RF and Microwave Attenuator Calibration Specification", the specification measurement items and the measurement methods covered, "Measurement Item 1: Attenuation of Variable Attenuator" including "Measurement Method 1.1 Inductive Voltage Divider Attenuation Standard Device Method", "Measurement Method 1.2 Attenuation Calibration Device Method", "Measurement Method 1.3 Measurement Receiver Method", "Measurement Method 1.4 Vector Network Analyzer Method", "Measurement Method 1.5 Voltmeter Method", "Measurement Item 2: Inherent Attenuation of Variable Attenuator (Attenuation of Fixed Attenuator)" including "Measurement Method 2.1 Inductive Voltage Divider Attenuation Standard Device Method", "Measurement Method 2.2 Attenuation Calibration Device Method", "Measurement Method 2.3 Measurement Receiver Method", "Measurement Method 2.4 Vector Network Analyzer Method", "Measurement Method 2.5 Voltmeter Method", and "Measurement Item 3: Voltage Standing Wave Ratio" including "Measurement Method 3.1 Voltage Standing Wave Ratio".

[0037] The extracted information will then be displayed as a checklist in a new pop-up window, with a "Customization" checkbox in the upper left corner. If the customer submitting the test request is "to measure only the attenuation of the variable attenuator, using the vector network analyzer method," the user should check the "Customization" checkbox in the upper left corner of the pop-up window as required, and enter "to measure only the attenuation of the variable attenuator, using the vector network analyzer method" in the input field below the checkbox. The user should also check the following measurement items and methods covered in the procedure specification: "Measurement Item 1: Attenuation of the variable attenuator" and "Measurement Method 1.4: Vector network analyzer method." After the system recognizes the selected "Customization" option, it will copy the "to measure only the attenuation of the variable attenuator, using the vector network analyzer method" to the specified cell in the original record spreadsheet. Simultaneously, based on the mapping relationship between the information displayed in the pop-up list and the specification data, and the mapping relationship between the specification data and the unitized spreadsheets, the system identifies the selected "Measurement Item 1: Attenuation of Variable Attenuator" and "Measurement Method 1.4: Vector Network Analyzer Method," and maps them to the corresponding unitized spreadsheets through unique identifiers. The system copies the matching unitized spreadsheets, sorts them according to the order of the measurement items, and forms the preliminary structure of the original record spreadsheet. The resulting measurement item information includes: Verification / calibration item name "1. Attenuation of Variable Attenuator," frequency (covering DC to 18GHz), standard value (to be measured), nominal value "6dB," error (calculated after the measurement reading, the calculation formula is "nominal value - standard value"), permissible error "±0.3dB," and measurement uncertainty. U (Measurement uncertainty component u introduced by standard instruments) B1 =“0.021dB”, the measurement uncertainty component u introduced by the resolution of the instrument under test. res =“0.0003dB”, the measurement uncertainty component u introduced by measurement repeatability. A =" "Where s(x) is the standard deviation of 6 measurements, and the measurement uncertainty is..." Automatic calibration instructions (which can be programmed according to the instruction manual).

[0038] The aforementioned "frequency coverage from DC to 18 GHz, nominal value of 6 dB, permissible error of ±0.3 dB, and measurement uncertainty component u introduced by standard instruments" refers to... B1 The measurement uncertainty component u introduced by the resolution of the calibrated instrument is 0.021 dB. res The value of 0.0003dB originates from the standard instrument information and the instrument being calibrated information in the specification module. It is first based on the previously captured "Instrument Model: 8491B", and then uses a mapping relationship to find and match the corresponding standard instrument information. Measurement Item 1: Variable Decay attenuation of the reducer1. Measurement Method 1.1 Inductive Voltage Divider Attenuation Standard Device Method: The corresponding standard equipment consists of two signal sources, two isolators, and one inductive voltage divider attenuation standard device. 2. Measurement Method 1.2 Attenuation Calibration Device Method: The corresponding standard equipment consists of one signal source, two isolators, and one attenuation calibration device. 3. Measurement Method 1.3 Measurement Receiver Method: The corresponding standard equipment consists of one signal source and one measurement receiver. 4. Measurement Method 1.4 Vector Network Analyzer Method: The corresponding standard equipment consists of only one vector network analyzer. 5. Measurement Method 1.5 Voltmeter Method: The corresponding standard equipment consists of one low-frequency signal generator, one matched load, and one voltmeter. Measurement Item 2: Inherent attenuation of the variable attenuator (attenuation of the fixed attenuator) 6. Measurement Method 2.1 Inductive Voltage Divider Attenuation Standard Device Method: The corresponding standard equipment consists of two signal sources, two isolators, and one inductive voltage divider attenuation standard device. 7. Measurement Method 2.2 Attenuation Calibration Device Method: The corresponding standard equipment consists of one signal source, two isolators, and one attenuation calibration device. 8. Measurement Method 2.3 Measurement Receiver Method: The corresponding standard equipment consists of one signal source and one measurement receiver. 9. Measurement Method 2.4 Vector Network Analyzer Method: The corresponding standard equipment consists of only one vector network analyzer. 10. Measurement Method 2.5 Voltmeter Method: The corresponding standard equipment consists of one low-frequency signal generator, one matched load, and one voltmeter. Measurement item 3: Voltage Standing Wave Ratio (VSWR)11. Measurement method 3.1 Voltage Standing Wave Ratio (VSWR), the corresponding standard instrument is only one vector network analyzer. ) and the information of the instrument being calibrated (model 8491B, name coaxial fixed attenuator, nominal attenuation value 6dB, frequency coverage range DC to 18GHz. Permissible error is ±0.3dB, the measurement uncertainty component uures introduced by resolution is 0.0003dB). Based on the measurement items and corresponding measurement methods selected by the user, the system finally matches the standard instrument information (measurement item 1 attenuation of variable attenuator: measurement method 1.4 vector network analyzer method, the corresponding standard instrument is only one vector network analyzer), corresponding to the specific instrument model: N5247A, instrument name: vector network analyzer, the introduced measurement uncertainty component uB1 = "0.021dB". The system copies the model, name, manufacturer, traceability certificate, and other information of the standard instrument and the model, name, manufacturer, and other information of the instrument being tested to the original record spreadsheet to record the standard instrument and the instrument being calibrated information. The table is located in the specified position. Simultaneously, the system copies the acquired information to the original record spreadsheet. The frequency coverage range of the calibrated instrument is from DC to 18 GHz. Based on the basic data with function calls and arithmetic operations copied from the original record spreadsheet, covering measurement points in the "MHz" and "GHz" frequency ranges, the specific values ​​of the frequency measurement points are calculated as follows: 0.1 MHz, 250 MHz, 500 MHz, 750 MHz, 1 GHz, 4.5 GHz, 9 GHz, 13.5 GHz, and 18 GHz. At this point, the original record spreadsheet for the 8491B coaxial fixed attenuator is complete.

[0039] In summary, the metrology digital original record template management system and method of this invention reduces the storage and maintenance costs of original record templates by constructing modular spreadsheets and automatically matching them to form original record templates that meet usage requirements. This satisfies the compliance calibration needs of different scenarios and also enables the acquisition, storage, and processing of industrial data for verification / calibration. The metrology digital original record template management system and method of this invention have at least the following beneficial effects: 1. Digitize original records to effectively reduce resource consumption caused by a large number of paper original records; 2. The original verification / calibration records are modularized into templates for easier maintenance and management; 3. Overcome the limitation of existing procedures and specifications that typically only provide a single original record template when there are multiple measurement methods for a measurement item, and achieve flexible configuration of digitized original records for all measurement methods; 4. Reduces the risk of excessive differences or errors in the original record templates due to numerous models of the same type of calibrated instrument; can automatically configure measurement points and allowable errors according to the metrological characteristics of the calibrated instrument. 5. Resolves the issue of not being able to configure the original record template in a timely manner when customers raise customized requirements for measurement projects, and enables manual and automatic entry of original data.

[0040] The foregoing has only described certain exemplary embodiments of the present invention by way of illustration. Undoubtedly, those skilled in the art can modify the described embodiments in various ways without departing from the spirit and scope of the present invention. Therefore, the foregoing drawings and descriptions are illustrative in nature and should not be construed as limiting the scope of protection of the claims of the present invention.

Claims

1. A digital raw record template management system for measurement, characterized in that, Includes a procedure and specification module and an instrument model module; The procedure specification module has a three-layer data architecture, including a basic data layer, a structured data layer, and an association rule layer. The basic data layer is used to store procedure specification metadata, unitized spreadsheets, and information on standard instruments and instruments to be calibrated. The procedure specification metadata includes the procedure specification number and name, as well as the corresponding measurement items and measurement methods. The unitized spreadsheets are built based on a single measurement method for a single measurement item in the procedure specification and are used to store metrological data and SCPI instructions. The structured data layer adopts a wide table structure and uses globally unique cell addresses to structure and index the measurement data. It can automatically fill the measurement data into the unitized spreadsheet according to SCPI instructions. The association rule layer is used to maintain the mapping relationship between the key information of the calibrated instrument and the procedure specifications, as well as the mapping relationship between the measurement method and the unitized spreadsheet. The instrument model module includes an intelligent matching engine and a combination generation engine. The intelligent matching engine is used to automatically match the corresponding procedures and specifications and all its measurement items and corresponding measurement methods by searching in the procedure and specification module based on the key information of the instrument being calibrated. The combined generation engine is used to automatically match the corresponding unitized spreadsheet in the procedure specification module based on the mapping relationship between the measurement method and the unitized spreadsheet, according to the measurement items and measurement methods selected from the automatically matched measurement items and measurement methods. It combines the matched unitized spreadsheets in the order of measurement items to generate a digital original record template, and automatically fills the digital original record template with information on standard instruments and instruments under calibration, measurement points, permissible errors and measurement uncertainty components.

2. The system as described in claim 1, characterized in that, The modular spreadsheet also stores dynamic calculation formulas. The instrument model module also includes an automatic calibration engine, which sends control commands to the standard instrument and the instrument being calibrated according to the SCPI instructions in the digital original record template, automatically collects measurement data and fills it into the corresponding cells, automatically calculates the indication error based on the dynamic calculation formula, and synthesizes the measurement uncertainty for qualification judgment.

3. The system as described in claim 1 or 2, characterized in that, The association rule layer is also used to maintain the mapping relationship between measurement methods and standard instruments and calibrated instruments; The combined generation engine searches for the corresponding standard instruments and instrument information in the procedure specification module based on the key information of the instrument being calibrated. Based on the selected measurement item and its corresponding measurement method, it matches the standard instrument corresponding to the measurement method in the searched standard instrument information and copies the matched standard instrument information and instrument information to the digital original record template. Obtain the range of the instrument being calibrated from the instrument information, and calculate the measurement points for the corresponding measurement items based on the range; obtain the permissible error and measurement uncertainty components of the measurement points of the instrument being calibrated from the instrument information.

4. The system as described in claim 1 or 2, characterized in that, The modular spreadsheet includes fields for measurement attributes, automation, and management. The measurement attributes include project name, standard value, nominal value or indicated value, indication error, permissible error, measurement uncertainty, and measurement uncertainty components. The automation fields include SCPI instructions, data entry mapping rules, and dynamic calculation formulas. The management fields include a unique identifier, version number, associated technical document number, and range of instrument models used.

5. The system as described in claim 1 or 2, characterized in that, The metadata of the procedure / specification includes the procedure / specification number, name, scope of application, implementation date, measurement items, and measurement methods; The key information about the instrument being calibrated includes the instrument model and instrument name.

6. The system as described in claim 1 or 2, characterized in that, The intelligent matching engine supports customized requirements and has a built-in natural language processing module that can automatically parse customized requirement text and map it into structured query conditions.

7. A method for managing digital raw record templates for measurement, characterized in that, Managing original record templates using the system described in any one of claims 1-6 includes: Step S1: Create a blank spreadsheet, obtain the key information of the instrument to be calibrated, and based on the mapping relationship between the key information and the procedures and specifications, retrieve the corresponding procedures and specifications in the procedures and specifications module, list all measurement items and corresponding measurement methods of the procedures and specifications, and provide them to the user for selection. Step S2: Responding to the measurement items and corresponding measurement methods selected by the user, based on the mapping relationship between the measurement methods and the unitized spreadsheets, match the corresponding unitized spreadsheets in the procedure specification module, copy the matched unitized spreadsheets and arrange them in the order of the measurement items in the blank spreadsheets to generate a digital original record template. Step S3: Based on the information of the instrument under calibration and the standard instruments, automatically calculate the measurement points of the instrument under calibration parameters, and automatically fill in the measurement points, allowable error and measurement uncertainty components in the digital original record template.

8. The method as described in claim 7, characterized in that, Step S3 includes: Based on the key information of the instrument being calibrated, the corresponding standard instruments and instrument information are found in the procedure and specification module. Then, based on the measurement items and corresponding measurement methods selected by the user, the standard instruments corresponding to the measurement methods are matched in the searched standard instrument information. The matched standard instrument information and instrument information are copied to a spreadsheet. Obtain the range of the instrument being calibrated from the instrument information, and calculate the measurement points for the corresponding measurement items based on the equal interval method, according to the principle of covering at least 5 measurement points covering the upper and lower limits of the range. Obtain the permissible error and measurement uncertainty components of the measurement points of the instrument being calibrated from the instrument information.

9. The method as described in claim 7 or 8, characterized in that, Also includes: The system is connected to the standard instruments and the instrument being calibrated via a metrology adapter. Execute the SCPI instructions in the digital raw record template in sequence, send control instructions to the standard instrument and the instrument being calibrated in turn, automatically collect measurement data and fill it into the corresponding cells; The system automatically calculates the indication error, synthesizes the measurement uncertainty, and compares the error with the allowable error to complete the qualification judgment.

Images