CN115270053B - Method for solving calculation and evidence problems in standard gas preparation process based on Excel - Google Patents
Method for solving calculation and evidence problems in standard gas preparation process based on Excel Download PDFInfo
- Publication number
- CN115270053B CN115270053B CN202210915131.7A CN202210915131A CN115270053B CN 115270053 B CN115270053 B CN 115270053B CN 202210915131 A CN202210915131 A CN 202210915131A CN 115270053 B CN115270053 B CN 115270053B
- Authority
- CN
- China
- Prior art keywords
- gas
- automatically
- certificate
- data
- ppm
- 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.)
- Active
Links
- 238000004364 calculation method Methods 0.000 title claims abstract description 38
- 238000002360 preparation method Methods 0.000 title claims abstract description 22
- 238000000034 method Methods 0.000 title claims abstract description 21
- 238000006243 chemical reaction Methods 0.000 claims abstract description 10
- 238000007599 discharging Methods 0.000 claims abstract description 4
- 239000007789 gas Substances 0.000 claims description 82
- 238000004519 manufacturing process Methods 0.000 claims description 6
- 238000012216 screening Methods 0.000 claims description 5
- 239000003085 diluting agent Substances 0.000 claims description 4
- 239000000126 substance Substances 0.000 claims description 4
- 230000006399 behavior Effects 0.000 claims description 3
- 239000004615 ingredient Substances 0.000 claims description 3
- 230000004199 lung function Effects 0.000 claims description 3
- 238000009472 formulation Methods 0.000 description 5
- 239000000203 mixture Substances 0.000 description 5
- IJGRMHOSHXDMSA-UHFFFAOYSA-N Atomic nitrogen Chemical compound N#N IJGRMHOSHXDMSA-UHFFFAOYSA-N 0.000 description 4
- 238000010586 diagram Methods 0.000 description 4
- 238000012795 verification Methods 0.000 description 4
- 239000000243 solution Substances 0.000 description 3
- 238000004422 calculation algorithm Methods 0.000 description 2
- 239000012895 dilution Substances 0.000 description 2
- 238000010790 dilution Methods 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 229910052757 nitrogen Inorganic materials 0.000 description 2
- 238000005303 weighing Methods 0.000 description 2
- QVGXLLKOCUKJST-UHFFFAOYSA-N atomic oxygen Chemical group [O] QVGXLLKOCUKJST-UHFFFAOYSA-N 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 210000004556 brain Anatomy 0.000 description 1
- 238000013461 design Methods 0.000 description 1
- 238000009826 distribution Methods 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 230000010354 integration Effects 0.000 description 1
- 239000001301 oxygen Substances 0.000 description 1
- 229910052760 oxygen Inorganic materials 0.000 description 1
- 238000011160 research Methods 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F17/00—Digital computing or data processing equipment or methods, specially adapted for specific functions
- G06F17/10—Complex mathematical operations
- G06F17/11—Complex mathematical operations for solving equations, e.g. nonlinear equations, general mathematical optimization problems
Landscapes
- Engineering & Computer Science (AREA)
- Physics & Mathematics (AREA)
- Mathematical Physics (AREA)
- General Physics & Mathematics (AREA)
- Pure & Applied Mathematics (AREA)
- Mathematical Optimization (AREA)
- Mathematical Analysis (AREA)
- Computational Mathematics (AREA)
- Data Mining & Analysis (AREA)
- Theoretical Computer Science (AREA)
- Operations Research (AREA)
- Algebra (AREA)
- Databases & Information Systems (AREA)
- Software Systems (AREA)
- General Engineering & Computer Science (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention relates to a method for solving calculation and evidence problems in a standard gas preparation process based on Excel, and belongs to the field of automation. The method comprises the following steps: s1: calculating before preparation; s2: calculating in the preparation process; s3: calculating after the preparation is completed; s4: automatically discharging labels; s5: automatically issuing a certificate; s6: mg/m 3 And ppm conversion calculation toolbox. In the configuration process, all calculation can be completed by a computer, and a printable configuration record is generated; labels can be automatically produced according to the configuration discipline; the certificate can be automatically produced according to the preparation record and the label; ppm and mg/m 3 Can be automatically converted with each other.
Description
Technical Field
The invention belongs to the field of automation, and relates to a method for solving the problems of calculation and evidence discharge in the standard gas preparation process based on Excel.
Background
In daily production of standard gas, a large-scale and numerous calculation is often carried out, so that the workload of gas distribution staff is complex, long-time calculation is easy to cause brain fatigue, and finally errors are caused, and whether the configuration errors or the calculation errors can possibly cause certain influence on the standard gas product.
Meanwhile, after the configuration of the standard gas is finished, an analyst is required to send out a label and a certificate to each bottle of standard gas, and the label and the certificate of each bottle are different, so that the analyst can carefully input and check the information of each bottle of standard gas, the workload is great, the error is easy to occur, and when the label is sent out, the correct number is required to be selected from the bottle-by-bottle match, and the time and the labor are wasted.
In order to avoid printing errors (bottle number errors, component concentration errors and the like), improve production and verification efficiency (label certificates need to be printed one by one, checked one by one and the like), reduce calculation errors, and improve customer satisfaction, the research is conducted.
Disclosure of Invention
In view of the above, the present invention aims to provide a method for solving the calculation and verification problems in the standard gas preparation process based on Excel.
In order to achieve the above purpose, the present invention provides the following technical solutions:
a method for solving calculation and evidence problems in standard gas preparation process based on Excel, the method comprising the steps of:
s1: calculating before preparation;
s2: calculating in the preparation process;
s3: calculating after the preparation is completed;
s4: automatically discharging labels;
s5: automatically issuing a certificate;
S6：mg/m 3 and ppm conversion calculation toolbox.
Optionally, the S1 specifically is: selecting a corresponding table according to the target standard gas type number, then pulling down the table to select the corresponding gas type, and automatically giving the molecular weight and density information corresponding to the gas type for calculation after the selection is completed;
firstly, designing 7 tables which are single-component, two-element, three-element, four-element, five-element and five-element lung function qi and tool box according to the category number, and selecting the tables according to the purposes to start calculation; then, setting a pull-down option to select gas types, establishing a database, inputting the gas types which can be involved in the database, and finishing setting through data-effectiveness-sequence; secondly, after the selection of the types is completed, the corresponding molecular weight is automatically generated according to the selected types, and the selection is completed through a formula VLOOKUP () to automatically screen out the corresponding molecular weight and density; and finally, after finishing the selection, inputting corresponding information including temperature, volume, humidity, information of the diluent gas and content to be configured, selecting proper total molar mass according to the temperature and the volume, and calculating the mass of the first component by combining the information of the diluent gas and the content to be configured.
Optionally, the S2 specifically is:
the quality of the components which are not added is calculated through the quality of the components which are already added, when the method is operated, the empty bottle quality is firstly weighed, the specific area is input, the quality is weighed again after the first component is added according to the quality prompt, the specific area is input, and the added quality and the quality which needs to be added next are automatically calculated; the pressure of the cylinder is calculated according to the type and the mass of the added gas.
Optionally, the S3 specifically is:
after all the preparation is completed, calculating the final result and integrating the data; calculating corresponding molar mass according to the type and the mass of the medium filled each time, obtaining total molar mass through addition, dividing the total molar mass by the respective molar mass to obtain the respective molar mass ratio, and outputting the ratio in the form of percentage or ppm to obtain a result; using the IF () judgment formula, the percentage is output when the output value is greater than a certain number, and the ppm is output when it is less than a certain value.
Optionally, the S4 specifically is:
after the configuration is completed, a label is automatically generated according to the data on the special gas configuration check record, wherein the configuration pressure and the validity period are fixed data and are not changed, the name, the bottle number, the volume, the gas type and the content are automatically read, and the time is automatically generated into the time of day through a TODAY () program.
Optionally, the step S5 specifically includes:
s51: according to the certificate of the previous version, a main body frame is set, the YEAR and MONTH are automatically generated through YEAR (TODAY ()) and MONTH (TODAY ()), then all gas types are described by using the simplest Chinese characters in a database, are singly in a column, correspond to each type one by one, the corresponding names are selected through VLOOKUP () formula, the names are connected through a & symbol, the names and the names are separated by 'medium', the bottom gas is separated by 'medium', other components are arranged at the front and the rear to form complete standard gas names,
s52: naming each standard gas in the database, wherein the naming format and the automatic generation format are required to be completely consistent, otherwise, the standard gas cannot be normally issued; the standard gas of three or more may cause the deviation of the front and back sequence of the automatically generated names due to the different filling sequence, and needs to be considered;
s53: the names are arranged in a row, the corresponding standard gas numbers are input in the next row, the IF (AND ()) multiple condition selection function is used in the third row, IF the content of each component is in the range allowed by the certificate, the standard substance number in the last row is output, otherwise, the blank is output, AND the range of the certificate is screened; screening out correct certificate numbers through names by using VLOOKUP () to obtain correct certificate numbers in a certificate range;
the resulting certificate is automatically generated from the tag and record.
Optionally, the step S6 specifically includes:
there are two metering modes in daily production of standard gas, one is a molar concentration mode of mol/mol, expressed as percentage or ppm; the other is mg/m 3 Is a weight-to-volume ratio of (a) to (b); to achieve the conversion of the two metering modes, firstly, setting a gas type pull-down option through a data-validity-sequence; then, establishing data in a database, and shooting the related data and types to be used into a row in a one-to-one correspondence manner so as to be screened; through VLOOKUP () screenSelecting data corresponding to each variety, and using the data to complete mg/m 3 And a conversion calculation between ppm;
species and ingredients mg/m 3 As input area, the two upper behaviors mg/m 3 Converted to ppm, lower row to ppm converted to mg/m 3 The category column can freely input or select the correct category through a pull-down option, and the next column inputs the number to be calculated to obtain the result of the corresponding metering method; the table is data at 20 ℃, when the temperature is changed, the volume is changed along with the change of the temperature, and the volume change of different gases along with the change of the temperature is inconsistent, and mg/m is adopted 3 The value will vary with temperature during metering.
The invention has the beneficial effects that:
1. all calculation in the configuration process can be completed by a computer, and a printable configuration record is generated;
2. labels can be automatically produced according to the configuration discipline;
3. the certificate can be automatically produced according to the preparation record and the label;
4. ppm and mg/m 3 Can be automatically converted with each other.
Additional advantages, objects, and features of the invention will be set forth in part in the description which follows and in part will become apparent to those having ordinary skill in the art upon examination of the following or may be learned from practice of the invention. The objects and other advantages of the invention may be realized and obtained by means of the instrumentalities and combinations particularly pointed out in the specification.
Drawings
For the purpose of making the objects, technical solutions and advantages of the present invention more apparent, the present invention will be described in the following preferred detail with reference to the accompanying drawings, in which:
FIG. 1 is a table column diagram;
FIG. 2 is a schematic diagram of a certification;
FIG. 3 is a schematic diagram of a standard substance certificate;
FIG. 4 is a schematic diagram of a computer according to the present invention.
Detailed Description
Other advantages and effects of the present invention will become apparent to those skilled in the art from the following disclosure, which describes the embodiments of the present invention with reference to specific examples. The invention may be practiced or carried out in other embodiments that depart from the specific details, and the details of the present description may be modified or varied from the spirit and scope of the present invention. It should be noted that the illustrations provided in the following embodiments merely illustrate the basic idea of the present invention by way of illustration, and the following embodiments and features in the embodiments may be combined with each other without conflict.
Wherein the drawings are for illustrative purposes only and are shown in schematic, non-physical, and not intended to limit the invention; for the purpose of better illustrating embodiments of the invention, certain elements of the drawings may be omitted, enlarged or reduced and do not represent the size of the actual product; it will be appreciated by those skilled in the art that certain well-known structures in the drawings and descriptions thereof may be omitted.
The same or similar reference numbers in the drawings of embodiments of the invention correspond to the same or similar components; in the description of the present invention, it should be understood that, if there are terms such as "upper", "lower", "left", "right", "front", "rear", etc., that indicate an azimuth or a positional relationship based on the azimuth or the positional relationship shown in the drawings, it is only for convenience of describing the present invention and simplifying the description, but not for indicating or suggesting that the referred device or element must have a specific azimuth, be constructed and operated in a specific azimuth, so that the terms describing the positional relationship in the drawings are merely for exemplary illustration and should not be construed as limiting the present invention, and that the specific meaning of the above terms may be understood by those of ordinary skill in the art according to the specific circumstances.
Referring to fig. 1 to 4, the method for solving the calculation and evidence problems in the standard gas preparation process based on Excel is provided. And (3) finishing the design of a main interface of the standard gas configuration check record through an EXCEL program, establishing a formula and establishing a database.
After the 'special gas automatic configuration check record' is finished, the tag and the certificate are automatically generated by reading data on the check record, and after specific data are input, all elements are automatically generated, manual operation is not needed, and only manual selection and printing are needed.
1. Calculation before formulation
The corresponding table is selected according to the target standard gas types, then the corresponding gas types are selected by pulling down on the table, and after the selection is completed, the program automatically gives out the information such as the molecular weight, the density and the like corresponding to the gas types for calculation. The method is characterized in that a plurality of programs are used, wherein the programs are designed according to the types and the numbers and are divided into 7 tables of single component, two-element, three-element, four-element, five-element and five-element lung function, and the tables can be independently selected according to the purposes to start calculation; setting a pull-down option to select gas types, wherein a database is required to be established, the gas types which can be involved are input into the database, and then the setting is completed through a data-validity-sequence; secondly, after the selection of the types is completed, the corresponding molecular weight is automatically generated according to the selected types, and the selection is completed through a formula VLOOKUP (), so that the corresponding molecular weight, density and the like can be automatically screened out; finally, after the selection is completed, the corresponding information such as temperature, volume, humidity, information of the dilution gas, the content to be configured, etc. needs to be input, and then the program selects the proper total molar mass according to the temperature and the volume, and calculates the mass of the first component by combining the information of the dilution gas and the content to be configured, as shown in fig. 1.
2. Calculation in formulation
The calculation in the preparation process is mainly to calculate the mass of the non-added component by the mass of the already added component, for example, when 40L of air is prepared, the first component is oxygen, the mass to be added is 1100g, but 1109g is added in actual operation, and 1109g is needed to be returned to calculate the mass of nitrogen to be added. If nitrogen is added directly at a fixed molar mass, configuration errors can be increased, affecting configuration results.
During operation, firstly weighing the empty bottle, inputting the empty bottle into a specific area, weighing the empty bottle after the first component is added according to the quality prompt, and inputting the empty bottle into the specific area, so that the added quality and the next added quality can be automatically calculated. The pressure of the gas cylinder can be calculated according to the type and the quality of the added gas, and the pressure has certain fluctuation due to different filling speeds, has a small range and is ignored.
3. Calculation after completion of formulation
Post-formulation calculations are the final result of the calculation and the integration of the data after all formulations are completed. According to the type and the mass of the medium filled each time, the corresponding molar mass is calculated, the total molar mass is obtained by adding, the ratio of the respective molar mass is obtained by dividing the respective molar mass by the total molar mass, and the ratio is output in the form of percentage or ppm, so that the result is obtained. Here, the judgment formula of IF () is repeated, and when the output value is larger than a certain number, the percentage content is output, and when the output value is smaller than a certain value, the ppm content is output.
4. Automatic label discharging
After the configuration is completed, a label is automatically generated according to the data on the special gas configuration check record, the label style is shown in figure 2, wherein the configuration pressure is shown in the specification, the validity period is that the fixed data is not changed, the name, the bottle number, the volume, the gas type and the content are automatically read, and the time is automatically generated into the time of day through a TODAY () program. And can be freely changed if the time is changed to other time.
5. Automatic certificate issuing
Automatic certificate issuing is the most difficult point of the program, because the automatic identification of the range of certificates and the automatic generation of certificate numbers are all difficulties.
(1) According to the certificate of the previous version, a main body frame is set, the YEAR and MONTH are automatically generated through YEAR (TODAY ()) and MONTH (TODAY ()), then all gas types are described by using the simplest Chinese characters in a database, are singly in a column, correspond to each type one by one, the corresponding names are selected through VLOOKUP () formula, the names are connected through a & symbol, the names and the names are separated by 'medium', the bottom gas is separated by 'medium', other components are arranged at the front and the rear to form complete standard gas names,
(2) Each standard gas is named in the database, the named format and the automatic generation format must be completely consistent, otherwise the standard gas cannot be normally issued. The standard gas of three or more may cause a deviation in the order of the automatically generated names due to the difference in the filling order, and must be taken into consideration to avoid the occurrence.
(3) The names are arranged in a row, the corresponding standard gas numbers are input in the next row, the IF (AND ()) multiple condition selection function is used in the third row, IF the content of each component is in the range allowed by the certificate, the standard substance number in the last row is output, otherwise, the blank is output, AND the range of the certificate can be screened out. The correct certificate number is screened out by name by VLOOKUP () to obtain the correct certificate number in the certificate range, as shown in fig. 3.
The certificate thus obtained is automatically generated from the tag and record without any modification and manipulation, and the data and tag will absolutely correspond one to one without careful verification.
6、mg/m 3 Calculation tool box for conversion between ppm and ppm
There are generally two metering modes in the daily production of standard gas, one is a molar concentration mode of mol/mol, and is generally expressed as percentage or ppm; the other is mg/m 3 In terms of weight-to-volume ratio. The molar concentration mode which is more convenient to produce is only used in the production, no specific and simple method exists for switching between the two metering modes, and the data are changed along with the change of the gas type. To achieve automatic switching, first, a gas species pull-down option is set through a data-validity-sequence; then, establishing data in a database, and shooting the related data and types to be used into a row in a one-to-one correspondence manner so as to be screened; screening out data corresponding to each variety through VLOOKUP () and using the data to complete mg/m 3 And conversion calculations between ppm.
As shown in FIG. 4, the species and ingredients mg/m 3 As input area, the two upper behaviors mg/m 3 Converted to ppm, lower row to ppm converted to mg/m 3 The category bar can be freely input or the correct category can be selected through a pull-down option, and the next bar is required to be inputThe number to be calculated can obtain the result of the corresponding metering method. The table is data at 20 ℃, and when the temperature is changed, the volume is changed along with the change of the temperature, and the volume change of different gases along with the change of the temperature is inconsistent, so that mg/m is adopted 3 The value will vary with temperature during metering.
1. The work needing manual calculation in the standard gas configuration process is automatically completed by a computer, and the work comprises calculation, screening, judgment, output, prompt and the like.
2. After the special gas configuration check record is finished, the tag is automatically generated by reading the data on the check record.
3. Automatically generating a certificate by reading the 'special gas configuration check record' and the content of the tag, automatically judging whether the range is within the allowable range of the certificate, automatically generating a certificate number if the range is within the allowable range of the certificate, and otherwise, not generating the number.
4. Establishing algorithm ppm and mg/m 3 The automatic calculation problem of the mutual conversion between two common standard gas measuring units.
The calculation algorithm of the invention saves calculation time, writing time, verification time and label output time, and at least saves about 5 minutes for each bottle of gas on average, if about 600 bottles are prepared per month, about 3000 minutes per month is saved, about 600 hours per year is saved, and 75 full working days are saved. Errors and returns due to calculation errors are reduced, and quality accidents due to label and certificate errors are reduced.
Finally, it is noted that the above embodiments are only for illustrating the technical solution of the present invention and not for limiting the same, and although the present invention has been described in detail with reference to the preferred embodiments, it should be understood by those skilled in the art that modifications and equivalents may be made thereto without departing from the spirit and scope of the present invention, which is intended to be covered by the claims of the present invention.
Claims (1)
1. The method for solving the calculation and evidence problems in the standard gas preparation process based on Excel is characterized by comprising the following steps: the method comprises the following steps:
s1: calculating before preparation;
s2: calculating in the preparation process;
s3: calculating after the preparation is completed;
s4: automatically discharging labels;
s5: automatically issuing a certificate;
S6：mg/m 3 a ppm conversion calculation toolbox;
the S1 specifically comprises the following steps: selecting a corresponding table according to the target standard gas type number, then pulling down the table to select the corresponding gas type, and automatically giving the molecular weight and density information corresponding to the gas type for calculation after the selection is completed;
firstly, designing 7 tables which are single-component, two-element, three-element, four-element, five-element and five-element lung function qi and tool box according to the category number, and selecting the tables according to the purposes to start calculation; then, setting a pull-down option to select gas types, establishing a database, inputting the gas types which can be involved in the database, and finishing setting through data-effectiveness-sequence; secondly, after the selection of the types is completed, the corresponding molecular weight is automatically generated according to the selected types, and the selection is completed through a formula VLOOKUP () to automatically screen out the corresponding molecular weight and density; finally, after finishing the selection, inputting corresponding information including temperature, volume, humidity, information of the diluent gas and content to be configured, selecting proper total molar mass according to the temperature and the volume, and calculating the mass of the first component by combining the information of the diluent gas and the content to be configured;
the step S2 is specifically as follows:
the quality of the components which are not added is calculated through the quality of the components which are already added, when the method is operated, the empty bottle quality is firstly weighed, the specific area is input, the quality is weighed again after the first component is added according to the quality prompt, the specific area is input, and the added quality and the quality which needs to be added next are automatically calculated; calculating the pressure of the gas cylinder according to the type and the quality of the added gas;
the step S3 is specifically as follows:
after all the preparation is completed, calculating the final result and integrating the data; calculating corresponding molar mass according to the type and the mass of the medium filled each time, obtaining total molar mass through addition, dividing the total molar mass by the respective molar mass to obtain the respective molar mass ratio, and outputting the ratio in the form of percentage or ppm to obtain a result; using an IF () judgment formula, outputting percentage content when the output value is greater than a certain number, and outputting ppm when the output value is less than a certain value;
the step S4 specifically comprises the following steps:
after the configuration is completed, automatically generating a label according to the data on the special gas configuration check record, wherein the configuration pressure and the validity period are fixed data and are not changed, the name, the bottle number, the volume, the gas type and the content are automatically read, and the time is automatically generated into the time of day through a TODAY () program;
the step S5 specifically comprises the following steps:
s51: according to the certificate of the previous version, a main body frame is set, the YEAR and MONTH are automatically generated through YEAR (TODAY ()) and MONTH (TODAY ()), then all gas types are described by using the simplest Chinese characters in a database, are singly in a column, correspond to each type one by one, the corresponding names are selected through VLOOKUP () formula, the names are connected through a & symbol, the names and the names are separated by 'medium', the bottom gas is separated by 'medium', other components are arranged at the front and the rear to form complete standard gas names,
s52: naming each standard gas in the database, wherein the naming format and the automatic generation format are required to be completely consistent, otherwise, the standard gas cannot be normally issued; the standard gas of three or more may cause the deviation of the front and back sequence of the automatically generated names due to the different filling sequence, and needs to be considered;
s53: the names are arranged in a row, the corresponding standard gas numbers are input in the next row, the IF (AND ()) multiple condition selection function is used in the third row, IF the content of each component is in the range allowed by the certificate, the standard substance number in the last row is output, otherwise, the blank is output, AND the range of the certificate is screened; screening out correct certificate numbers through names by using VLOOKUP () to obtain correct certificate numbers in a certificate range;
the obtained certificate is automatically generated according to the label and the record;
the step S6 specifically comprises the following steps:
there are two metering modes in daily production of standard gas, one is a molar concentration mode of mol/mol, expressed as percentage or ppm; the other is mg/m 3 Is a weight-to-volume ratio of (a) to (b); to achieve the conversion of the two metering modes, firstly, setting a gas type pull-down option through a data-validity-sequence; then, establishing data in a database, and shooting the related data and types to be used into a row in a one-to-one correspondence manner so as to be screened; screening out data corresponding to each variety through VLOOKUP () and using the data to complete mg/m 3 And a conversion calculation between ppm;
species and ingredients mg/m 3 As input area, the two upper behaviors mg/m 3 Converted to ppm, lower row to ppm converted to mg/m 3 The category column can freely input or select the correct category through a pull-down option, and the next column inputs the number to be calculated to obtain the result of the corresponding metering method; the table is data at 20 ℃, when the temperature is changed, the volume is changed along with the change of the temperature, and the volume change of different gases along with the change of the temperature is inconsistent, and mg/m is adopted 3 The value will vary with temperature during metering.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202210915131.7A CN115270053B (en) | 2022-08-01 | 2022-08-01 | Method for solving calculation and evidence problems in standard gas preparation process based on Excel |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202210915131.7A CN115270053B (en) | 2022-08-01 | 2022-08-01 | Method for solving calculation and evidence problems in standard gas preparation process based on Excel |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN115270053A CN115270053A (en) | 2022-11-01 |
| CN115270053B true CN115270053B (en) | 2024-04-02 |
Family
ID=83747292
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202210915131.7A Active CN115270053B (en) | 2022-08-01 | 2022-08-01 | Method for solving calculation and evidence problems in standard gas preparation process based on Excel |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN115270053B (en) |
Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CA2321416A1 (en) * | 1999-10-01 | 2001-04-01 | L'air Liquide, Societe Anonyme Pour L'etude Et L'exploitation Des Procedes Georges Claude | Process and apparatus for producing a diagram of an installation comprising apparatuses supplied with gas |
| CN1414365A (en) * | 2001-10-24 | 2003-04-30 | 中国石油化工股份有限公司巴陵分公司 | Method of detecting gas cylinder |
| CN103559402A (en) * | 2013-11-07 | 2014-02-05 | 大连东方之星信息技术有限公司 | Statistical analyzing method applying linear regression method |
| CN103759793A (en) * | 2013-12-31 | 2014-04-30 | 广西玉柴机器股份有限公司 | Calibration device and method for gas flow meter |
| CN108960734A (en) * | 2018-07-09 | 2018-12-07 | 苏州七彩云霞软件有限公司 | A kind of gas bomb is filled with MES system and operation method |
| CN109872048A (en) * | 2019-01-22 | 2019-06-11 | 长乐恒申合纤科技有限公司 | Implementation method that is a kind of plus playing production of intelligent management |
| CN111898228A (en) * | 2020-08-03 | 2020-11-06 | 姚成蔚 | Visual gas pipe network static simulation system based on CAD and calculation method thereof |
| CN213900743U (en) * | 2020-10-20 | 2021-08-06 | 山西惠丰特种汽车有限公司 | Pneumatic three-position automatic conversion device |
| CN114743661A (en) * | 2022-03-28 | 2022-07-12 | 淞清(太仓)生物科技有限公司 | Sweep sign indicating number based tandem mass spectrometry kit automation of operation device |
-
2022
- 2022-08-01 CN CN202210915131.7A patent/CN115270053B/en active Active
Patent Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CA2321416A1 (en) * | 1999-10-01 | 2001-04-01 | L'air Liquide, Societe Anonyme Pour L'etude Et L'exploitation Des Procedes Georges Claude | Process and apparatus for producing a diagram of an installation comprising apparatuses supplied with gas |
| CN1414365A (en) * | 2001-10-24 | 2003-04-30 | 中国石油化工股份有限公司巴陵分公司 | Method of detecting gas cylinder |
| CN103559402A (en) * | 2013-11-07 | 2014-02-05 | 大连东方之星信息技术有限公司 | Statistical analyzing method applying linear regression method |
| CN103759793A (en) * | 2013-12-31 | 2014-04-30 | 广西玉柴机器股份有限公司 | Calibration device and method for gas flow meter |
| CN108960734A (en) * | 2018-07-09 | 2018-12-07 | 苏州七彩云霞软件有限公司 | A kind of gas bomb is filled with MES system and operation method |
| CN109872048A (en) * | 2019-01-22 | 2019-06-11 | 长乐恒申合纤科技有限公司 | Implementation method that is a kind of plus playing production of intelligent management |
| CN111898228A (en) * | 2020-08-03 | 2020-11-06 | 姚成蔚 | Visual gas pipe network static simulation system based on CAD and calculation method thereof |
| CN213900743U (en) * | 2020-10-20 | 2021-08-06 | 山西惠丰特种汽车有限公司 | Pneumatic three-position automatic conversion device |
| CN114743661A (en) * | 2022-03-28 | 2022-07-12 | 淞清(太仓)生物科技有限公司 | Sweep sign indicating number based tandem mass spectrometry kit automation of operation device |
Non-Patent Citations (5)
| Title |
|---|
| A real-time construction safety monitoring system for hazardous gas integrating wireless sensor network and building information modeling technologies;Cheung Weng-Fong 等;《Sensors》;20180202;第18卷(第2期);1-24 * |
| Emission factors for ethene and ammonia from a tunnel study with a photoacoustic trace gas detection system;Moeckli Marc A. 等;《Environmental science & technology》;19960827;第30卷(第9期);2864-2867 * |
| MathCAD在相平衡计算中的应用;吴选军;;《化工高等教育》;20090228;第26卷(第01期);50-54 * |
| 巧用EXCEL制作检定证书;王国龙 等;《计量与测试技术》;20120730;第39卷(第07期);21-22 * |
| 浅析认证标准气不确定度的来源及计算方法;夏朝彬;《天然气工业》;19960728(第04期);66-69 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN115270053A (en) | 2022-11-01 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| EP0089190B1 (en) | The production of descriptive labels for different items | |
| WO1999042940A1 (en) | Computer aided system for compliance with chemical control laws | |
| CN109766529B (en) | Report generation method and equipment | |
| CN107730157A (en) | A kind of extraction of traditional Chinese medicine weighs allocator | |
| CN106909604B (en) | Automatic checking method and system for EXCEL form and ACCESS database based on rules | |
| Wasserman et al. | Statistical analysis of discrete relational data | |
| CN112464632B (en) | Dynamic storage and conversion method for table style under excel report | |
| Oosterhaven et al. | Estimating international interindustry linkages: Non-survey simulations of the Asian-Pacific economy | |
| CN111078766A (en) | Data warehouse model construction system and method based on multidimensional theory | |
| CN115270053B (en) | Method for solving calculation and evidence problems in standard gas preparation process based on Excel | |
| CN112801621A (en) | BOM bill of material sorting and approving method, system and computer readable storage medium | |
| CN116468010A (en) | Report generation method, device, terminal and storage medium | |
| Theil | Who forecasts best? | |
| CN109697211B (en) | Method and system for processing cross table derived data and computer readable storage medium | |
| Otlet et al. | 14C interlaboratory comparison in the UK: Experiment design, preparation and preliminary results | |
| CN112434077A (en) | Data statistics display method, device, equipment and medium based on customized report | |
| JPH0744630A (en) | Sales plan devising and supporting method and system therefor | |
| CN106384322A (en) | Management method for corresponding relation of blood sampling bag and sample tube | |
| CN109614602A (en) | A kind of rapid generation of profile measurement report | |
| CN112465418B (en) | Material loading method and device based on product life cycle management | |
| CN108053258A (en) | The data analysing method and system of wood type price index | |
| CN113127498A (en) | Method and system for efficiently calculating pre-actual cost of shipbuilding product | |
| CN111046339A (en) | Method and device for processing simulation base period data | |
| CN112733494B (en) | Method and system for automatically generating standard detection report | |
| CN113610396B (en) | Method and system for structuring matrix designer based on construction quality acceptance table |
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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |