CN111859596A - Control valve model selection method and control valve model selection device - Google Patents
Control valve model selection method and control valve model selection device Download PDFInfo
- Publication number
- CN111859596A CN111859596A CN201910304990.0A CN201910304990A CN111859596A CN 111859596 A CN111859596 A CN 111859596A CN 201910304990 A CN201910304990 A CN 201910304990A CN 111859596 A CN111859596 A CN 111859596A
- Authority
- CN
- China
- Prior art keywords
- control valve
- data table
- type selection
- model selection
- selection
- 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.)
- Granted
Links
- 238000010187 selection method Methods 0.000 title claims abstract description 11
- 238000005192 partition Methods 0.000 claims abstract description 32
- 238000000034 method Methods 0.000 claims abstract description 31
- 230000008676 import Effects 0.000 claims abstract description 19
- 238000004364 calculation method Methods 0.000 claims description 97
- 238000012545 processing Methods 0.000 claims description 25
- 238000004590 computer program Methods 0.000 claims description 13
- 230000007246 mechanism Effects 0.000 claims description 11
- 238000012216 screening Methods 0.000 claims description 7
- 238000004513 sizing Methods 0.000 claims description 7
- 230000001276 controlling effect Effects 0.000 description 5
- 238000010586 diagram Methods 0.000 description 5
- 230000006870 function Effects 0.000 description 4
- 230000008569 process Effects 0.000 description 2
- 238000012369 In process control Methods 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000013479 data entry Methods 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 238000010965 in-process control Methods 0.000 description 1
- 239000007788 liquid Substances 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 230000001105 regulatory effect Effects 0.000 description 1
- 230000004044 response Effects 0.000 description 1
- 239000002699 waste material Substances 0.000 description 1
Images
Landscapes
- Feedback Control In General (AREA)
- General Factory Administration (AREA)
Abstract
The invention provides a control valve type selection method and a control valve type selection device, and relates to the field of control valve type selection, wherein the control valve type selection method comprises the following steps: the method comprises the steps of obtaining a control valve data table in an excel format, wherein the control valve data table comprises a plurality of partitions, each partition is provided with the same number of cells, the number of rows and the number of columns of the cells are the same, a plurality of parameters of different control valves are recorded in different partitions, and the same parameter of each control valve is located at the same position in the partition; acquiring a target position of a parameter required by model selection of a control valve in a first subarea in a control valve data table; extracting parameters required by model selection of all control valves from the control valve data table according to the target position, and importing the parameters required by model selection of each control valve into the model selection data table in an excel format; and importing the type selection data table into type selection calculation software to obtain a type selection result file. The invention realizes the batch import of data.
Description
Technical Field
The invention relates to the field of control valve model selection, in particular to a control valve model selection method and a control valve model selection device.
Background
The control valve is an actuator in a self-control system, as a terminal element in process control, whose application quality is directly reflected in the regulating quality of the system. The quality of the control valve application is very important to correctly calculate and select types except the quality of the product and whether a user correctly installs, uses and maintains the control valve. When model selection calculation is carried out, control valve data needs to be imported into calculation software according to a certain format, the existing entry method is purely manual entry, and when the problem of model selection of a large number of control valves is solved, the method is time-consuming, labor-consuming, high in error rate and difficult to achieve efficient and accurate entry results.
Disclosure of Invention
In view of the above, the present invention provides a control valve type selection method and a control valve type selection device, which are used to solve the problems that when a control valve is selected, control valve parameters need to be manually entered into a type selection data table, which is time-consuming, labor-consuming, and has a high error rate.
In order to solve the technical problem, the invention provides a control valve model selection method, which comprises the following steps:
the method comprises the steps of obtaining a control valve data table in an excel format, wherein the control valve data table comprises a plurality of partitions, each partition is provided with the same number of cells, the number of rows and the number of columns of the cells are the same, a plurality of parameters of different control valves are recorded in different partitions, and the same parameter of each control valve is located at the same position in the partition;
Acquiring a target position of a parameter required by model selection of the control valve in a first subarea in the control valve data table;
extracting all parameters required by model selection of the control valves from the control valve data table according to the target position, and importing the parameters required by model selection of each control valve into a model selection data table in an excel format, wherein the parameters required by model selection of each control valve in the model selection data table occupy one row of cells;
and importing the type selection data table into type selection calculation software to obtain a type selection result file, wherein the type selection result file comprises type selection calculation result parameters of each control valve.
Optionally, after the extracting, according to the position, parameters required for model selection of all the control valves from the control valve data table and importing the parameters required for model selection of each control valve into the model selection data table with an excel format, the method further includes:
and displaying a data processing interface according to the input of a user, wherein the data processing interface is used for screening, replacing or filling the parameters required by the specified type selection in the type selection data table.
Optionally, after the extracting, according to the position, parameters required for model selection of all the control valves from the control valve data table and importing the parameters required for model selection of each control valve into the model selection data table with an excel format, the method further includes:
And displaying a data input interface according to the input of the user, wherein the data input interface is used for providing an interface for the user to manually input the parameters of the control valve into the type selection data table.
Optionally, after obtaining the type selection result file, the method further includes:
acquiring a first position of a designated type selection calculation result parameter in a type selection result file and a second position of the designated type selection calculation result parameter in the control valve data table;
and when an instruction for importing the specified type selection calculation result parameters into the control valve data table is received, importing the specified type selection calculation result parameters of the first position in the type selection result file into a second position in the control valve data table.
Optionally, after obtaining the type selection result file, the method further includes:
if the control valve is a partial rotation or butterfly valve, importing a model selection calculation result parameter required by the torque calculation of the control valve into a torque calculation module, wherein the torque calculation module is used for calculating the torque of the control valve;
and outputting the calculation result of the torque calculation module so that a user can select an actuating mechanism of the control valve according to the calculation result.
The invention also provides a control valve model selection device, which comprises:
The control valve data table comprises a plurality of partitions, each partition is provided with the same number of cells, the number of rows and the number of columns of the cells are the same, a plurality of parameters of different control valves are recorded in different partitions, and the same parameter of each control valve is located at the same position in the partition;
the second acquisition module is used for acquiring the target position of the parameters required by the model selection of the control valve in the first subarea in the control valve data table;
the first import module is used for extracting all parameters required by model selection of the control valves from the control valve data table according to the target position, importing the parameters required by model selection of each control valve into a model selection data table in an excel format, wherein the parameters required by model selection of each control valve occupy one row of cells in the model selection data table;
and the second import module is used for importing the type selection data table into type selection calculation software to obtain a type selection result file, and the type selection result file comprises type selection calculation result parameters of each control valve.
Optionally, the control valve type selection device further includes:
And the data processing module is used for displaying a data processing interface according to the input of a user, and the data processing interface is used for screening, replacing or filling the parameters required by the specified type selection in the type selection data table.
Optionally, the control valve type selection device further includes:
and the data input module is used for displaying a data input interface according to the input of a user, and the data input interface is used for providing an interface for manually inputting the parameters of the control valve into the type selection data table for the user.
Optionally, the control valve type selection device further includes:
the third acquisition module is used for acquiring a first position of the appointed type selection calculation result parameter in the type selection result file and a second position of the appointed type selection calculation result parameter in the control valve data table;
and the third importing module is used for importing the type selection calculation result parameter of the first position to the second position in the control valve data table when receiving an instruction of importing the specified type selection calculation result parameter to the control valve data table.
Optionally, the control valve type selection device further includes:
the fourth importing module is used for importing the type selection calculation result parameters required by the torque calculation of the control valve into the torque calculation module if the control valve is a partial rotation or butterfly valve, and the torque calculation module is used for calculating the torque of the control valve;
And the output module is used for outputting the calculation result of the torque calculation module so that a user can select the actuating mechanism of the control valve according to the calculation result.
The invention also comprises a control valve type selection device, which comprises a memory, a processor and a computer program which is stored on the memory and can run on the processor; and when the processor executes the program, the control valve type selection method is realized.
The invention also includes a computer readable storage medium having a computer program stored thereon, wherein the program, when executed by a processor, performs the steps of the above-described method for controlling valve selection.
The technical scheme of the invention has the following beneficial effects:
in the embodiment of the invention, the positions of the parameters required by model selection of all control valves are determined according to the positions of the parameters required by model selection of the first control valve in the control valve data table, and the parameters required by model selection of all control valves are automatically imported into model selection calculation software according to the determined positions; therefore, batch import of data is realized, data processing time is shortened, and the problems of manpower waste and high error rate under the condition of manual processing are solved.
Drawings
FIG. 1 is a schematic flow chart of a method for controlling valve model selection according to an embodiment of the present invention;
FIG. 2 is a schematic flow chart of a method for controlling valve type selection according to another embodiment of the present invention;
FIG. 3 is a data processing interface according to an embodiment of the present invention;
FIG. 4 is a data processing interface in another embodiment of the present invention;
FIG. 5 is a schematic structural diagram of a control valve model selection device according to an embodiment of the present invention;
FIG. 6 is a schematic structural diagram of a control valve type selection device according to another embodiment of the present invention;
fig. 7 is a schematic structural diagram of a control valve model selection device according to another embodiment of the present invention.
Detailed Description
In order to make the objects, technical solutions and advantages of the embodiments of the present invention clearer, the technical solutions of the embodiments of the present invention will be clearly and completely described below with reference to the drawings of the embodiments of the present invention. It is to be understood that the embodiments described are only a few embodiments of the present invention, and not all embodiments. All other embodiments, which can be derived by a person skilled in the art from the described embodiments of the invention, are within the scope of the invention.
Referring to fig. 1, fig. 1 is a schematic flow chart illustrating a method for controlling valve type selection according to an embodiment of the present invention, the method including:
Step 101: the method comprises the steps of obtaining a control valve data table in an excel format, wherein the control valve data table comprises a plurality of partitions, each partition is provided with the same number of cells, the number of rows and the number of columns of the cells are the same, a plurality of parameters of different control valves are recorded in different partitions, and the same parameter of each control valve is located at the same position in the partition;
for example, assuming that each valve data table has 60 rows, the first control valve has a bit number in the cell "a 1", the second control valve has a bit number in the cell "a 61", and the nth control valve has a bit number in the cell "a 1+60 × n";
step 102: acquiring a target position of a parameter required by model selection of the control valve in a first subarea in the control valve data table;
step 103: extracting all parameters required by model selection of the control valves from the control valve data table according to the target position, and importing the parameters required by model selection of each control valve into a model selection data table in an excel format, wherein the parameters required by model selection of each control valve in the model selection data table occupy one row of cells;
step 104: and importing the type selection data table into type selection calculation software to obtain a type selection result file, wherein the type selection result file comprises type selection calculation result parameters of each control valve.
The model selection calculation software can be the existing control valve model selection calculation software.
According to the embodiment of the invention, the batch import of the control valve data is realized, a large amount of time and labor are saved, and the problem of high error rate in manual import is avoided.
Referring to fig. 2, fig. 2 is a schematic flow chart illustrating a method for controlling valve type selection according to another embodiment of the present invention, the method including:
step 201: acquiring a control valve data table provided by a user;
in some cases, the user-supplied control valve data table is not in excel format, for example, it may be in PDF format; therefore, the control valve data table needs to be converted into an excel format;
step 202: judging whether the control valve data table is in an excel format, if so, entering a step 204, and otherwise, entering a step 203;
step 203: converting the control valve data table into an excel format;
step 204: acquiring a target position of a parameter required by model selection of the control valve in a first subarea in the control valve data table;
step 205: establishing a type selection data table in an excel format, wherein the type selection data table can be named as valvedat.xls, and parameters required by type selection are brought into the type selection data table;
The creation of the type selection data table is not limited to be located during the execution of step 205, and may be created before step 205.
In some cases, the parameters required by the model selection in the model selection data table may not meet the requirements of the model selection calculation software, and therefore, optionally, the method for model selection of the control valve according to the embodiment of the present invention further includes:
step 206: sorting parameters required by the designated model selection in the model selection data table;
for example, the computing software may not be able to identify part of the proposed parameters required for the type selection, and therefore, optionally, sorting the parameters required for the specified type selection in the type selection data table may further include:
and displaying a data processing interface according to the input of a user on the user interface, wherein the data processing interface is used for screening, replacing or filling the parameters required by the specified type selection in the type selection data table.
Referring to fig. 3, fig. 3 is a data processing interface in an embodiment of the present invention, in this embodiment, the specified parameters required for type selection are media state parameters, when the media state is processed, the media state in the type selection data table is extracted, and it is assumed that the extracted state includes data such as "Gas/value", "Liquid", and "team", and the number of each kind of data may also be displayed, and data that can be recognized by the computing software is selected for replacement.
Wherein the user input may be: clicking a 'item processing data' button of the data processing interface, clicking a 'medium state' button under the 'item processing data' button, and then clicking a 'screening' button under the 'medium state' button.
The above embodiment of the present invention may process the data format of the model selection data table into a format recognizable by the calculation software, so as to achieve the purpose of importing the parameters required by the model selection of the control valve into the calculation software.
In some embodiments of the present invention, there may be a portion of the data required for model selection that cannot be directly extracted from the control valve data table, and therefore, optionally, sorting the parameters required for the specified model selection in the model selection data table may include:
a data entry interface is displayed, as shown with reference to fig. 4, in response to user input on the user interface for providing the user with an interface for manually entering parameters for the control valve into the type selection data table.
The above embodiment of the present invention may manually input the part of the data required for model selection, which cannot be directly extracted from the control valve data table, into the model selection control table, so as to achieve the purpose of importing the parameters required for model selection of the control valve into the calculation software.
Step 207: and importing the data into computing software, and performing type selection calculation to obtain a type selection result file.
In some cases, the obtained selected result file needs to be reintroduced into the user data table for the user to view, and therefore, in some embodiments of the present invention, referring to fig. 2, the method for selecting a control valve according to an embodiment of the present invention may further include:
assuming that the typing result file in the above step 104 may include a first typing result file, the first typing result file may be named valvedat.
Step 208: acquiring a first position of a designated type selection calculation result parameter in the first type selection result file and a second position of the designated type selection calculation result parameter in the control valve data table;
step 209: and when an instruction for importing the specified type selection calculation result parameters into the control valve data table is received, importing the specified type selection calculation result parameters of the first position in the type selection result file into a second position in the control valve data table.
For example, the type selection result parameter may be "select Cv", assuming that it is located in the cell "B1" in the first type selection result file and the cell "C1" in the control valve data table, an instruction to import the designated type selection calculation result parameter into the control valve data table is generated by clicking a "import data to specification table" button on a user interface, and data located in the cell "B1" of the first type selection result file is imported into the cell "C1" of the control valve data table.
The above embodiment of the present invention is used to import the data of the model selection result required by the user into the control valve data table, so that the user can perform the next analysis.
In some cases, if the control valve includes a biased or butterfly valve, torque calculations and actuator sizing may also be required. Therefore, the control valve type selection method of the embodiment of the invention may further include:
assuming that the typing result file in step 104 may include a second typing result file, the second typing result file may be named protab.
step 211: if the control valve is a partial rotation or butterfly valve, importing a model selection calculation result parameter required by the torque calculation of the control valve into a torque calculation module according to user input, wherein the torque calculation module is used for calculating the torque of the control valve;
step 212: outputting a calculation result of the torque calculation module so that a user can select an actuating mechanism of the control valve according to the calculation result;
step 213: manually selecting the type of an executing mechanism according to the torque calculation result of the torque calculation book, and importing the type of the executing mechanism and the torque calculation result into the detailed type selection result book;
Wherein, in step 211, the user input may be: clicking an "open function list" button on the user interface, clicking a "import from PROTAB" button under the "open function list", and then clicking a "generate torque calculation book" button under the "import from PROTAB".
In step 213, when importing the actuator model and the torque calculation result into the model selection result specification, the user may input: clicking a button of 'opening a function table' on a user interface, and clicking a button of 'importing an execution mechanism result' under the 'opening the function table'.
In some embodiments of the present invention, step 210 may further include:
and if the control valve is not a bias rotation or butterfly valve, ending the program.
The embodiment of the invention is used for carrying out torque calculation on the eccentric rotation and the butterfly valve and selecting the type of the executing mechanism so as to perfect the type selection calculation result.
Based on the same inventive concept, an embodiment of the present invention further provides a control valve model selection apparatus, please refer to fig. 5, the apparatus includes:
the first obtaining module 501 is configured to obtain a control valve data table in an excel format, where the control valve data table includes multiple partitions, each partition has the same number of cells, the number of rows and the number of columns of the cells are the same, multiple parameters of different control valves are recorded in different partitions, and the same parameter of each control valve is located at the same position in the partition;
A second obtaining module 502, configured to obtain a target position of a parameter required for model selection of the control valve in the first zone in the control valve data table;
a first importing module 503, configured to extract parameters required for model selection of all the control valves from the control valve data table according to the target position, and import the parameters required for model selection of each control valve into a model selection data table in an excel format, where the parameters required for model selection of each control valve occupy one row of cells in the model selection data table;
a second import module 504, configured to import the type selection data table into type selection calculation software, so as to obtain a type selection result file, where the type selection result file includes a type selection calculation result parameter of each control valve.
The embodiment of the invention is used for automatically importing the control valve data when the control valve is selected, thereby saving a large amount of time and labor when the data is manually input and reducing the error rate.
Referring to fig. 6, fig. 6 is a schematic structural diagram of a control valve type selection device according to another embodiment of the present invention, in some embodiments of the present invention, optionally, the control valve type selection device may further include:
and the data processing module 505 is configured to display a data processing interface according to user input, where the data processing interface is configured to filter, replace, or fill the parameters required by the specified type selection in the type selection data table.
Optionally, the control valve type selection device may further include:
a data input module 506 for displaying a data input interface for providing a user with an interface for manually entering parameters of a control valve into the type selection data table according to user input.
This embodiment is used to arrange the selection data table into a format recognizable by the computing software.
Optionally, the control valve type selection device may further include:
a third obtaining module 507, configured to obtain a first position of a specified type selection calculation result parameter in a type selection result file, and a second position of the specified type selection calculation result parameter in the control valve data table;
a third importing module 508, configured to import the model selection calculation result parameter at the first position to a second position in the control valve data table when receiving an instruction to import the specified model selection calculation result parameter to the control valve data table.
The embodiment is used for importing the type selection calculation results into the control valve data table provided by the user in batches so that the user can perform the next analysis.
Optionally, the control valve type selection device may further include:
A fourth importing module 509, configured to import a model selection calculation result parameter required by the torque calculation of the control valve into a torque calculation module if the control valve is a partial rotation or a butterfly valve, where the torque calculation module is configured to calculate a torque of the control valve;
and the output module 510 is configured to output the calculation result of the torque calculation module, so that a user can select an actuator of the control valve according to the calculation result.
The embodiment is used for calculating the torque of the eccentric rotation and the butterfly valve so as to facilitate the selection of the type of the actuating mechanism by a user.
Referring to fig. 7, fig. 7 is a schematic structural diagram of a control valve model selection device according to another embodiment of the present invention, the control valve model selection device 700 includes: a processor 701 and a memory 702, wherein:
in an embodiment of the present invention, the control valve type selection apparatus 700 further includes: a computer program stored on a memory 702 and executable on a processor 701, the computer program when executed by the processor 701 performing the steps of:
the method comprises the steps of obtaining a control valve data table in an excel format, wherein the control valve data table comprises a plurality of partitions, each partition is provided with the same number of cells, the number of rows and the number of columns of the cells are the same, a plurality of parameters of different control valves are recorded in different partitions, and the same parameter of each control valve is located at the same position in the partition;
Acquiring a target position of a parameter required by model selection of the control valve in a first subarea in the control valve data table;
extracting all parameters required by model selection of the control valves from the control valve data table according to the target position, and importing the parameters required by model selection of each control valve into a model selection data table in an excel format, wherein the parameters required by model selection of each control valve in the model selection data table occupy one row of cells;
and importing the type selection data table into type selection calculation software to obtain a type selection result file, wherein the type selection result file comprises type selection calculation result parameters of each control valve.
Optionally, the computer program when executed by the processor 702 may further implement the steps of:
and after the parameters required by model selection of all the control valves are proposed from the control valve data table according to the positions and are imported into the model selection data table in an excel format, displaying a data processing interface according to user input, wherein the data processing interface is used for screening, replacing or filling the specified parameters required by model selection in the model selection data table.
Optionally, the computer program when executed by the processor 702 may further implement the steps of:
And after the parameters required by model selection of all the control valves are proposed from the control valve data table according to the positions and are imported into the model selection data table in the excel format, displaying a data input interface according to user input, wherein the data input interface is used for providing an interface for manually inputting the parameters of the control valves into the model selection data table for a user.
Optionally, the computer program when executed by the processor 702 may further implement the steps of:
after the model selection result file is obtained, acquiring a first position of a specified model selection calculation result parameter in the model selection result file and a second position of the specified model selection calculation result parameter in the control valve data sheet;
and when an instruction for importing the specified type selection calculation result parameters into the control valve data table is received, importing the specified type selection calculation result parameters of the first position in the type selection result file into a second position in the control valve data table.
Optionally, the computer program when executed by the processor 702 may further implement the steps of:
after the model selection result file is obtained, if the control valve is a bias rotation or butterfly valve, importing model selection calculation result parameters required by torque calculation of the control valve into a torque calculation module, wherein the torque calculation module is used for calculating the torque of the control valve;
And outputting the calculation result of the torque calculation module so that a user can select an actuating mechanism of the control valve according to the calculation result.
The embodiment of the present invention further provides a computer-readable storage medium, where a computer program is stored on the computer-readable storage medium, and when the computer program is executed by a processor, the computer program implements each process of the above-mentioned control valve model selection method embodiment, and can achieve the same technical effect, and in order to avoid repetition, the detailed description is omitted here. The computer-readable storage medium may be a Read-Only Memory (ROM), a Random Access Memory (RAM), a magnetic disk or an optical disk. While the foregoing is directed to the preferred embodiment of the present invention, it will be understood by those skilled in the art that various changes and modifications may be made without departing from the spirit and scope of the invention as defined in the appended claims.
Claims (12)
1. A method of control valve sizing, comprising:
the method comprises the steps of obtaining a control valve data table in an excel format, wherein the control valve data table comprises a plurality of partitions, each partition is provided with the same number of cells, the number of rows and the number of columns of the cells are the same, a plurality of parameters of different control valves are recorded in different partitions, and the same parameter of each control valve is located at the same position in the partition;
Acquiring a target position of a parameter required by model selection of the control valve in a first subarea in the control valve data table;
extracting all parameters required by model selection of the control valves from the control valve data table according to the target position, and importing the parameters required by model selection of each control valve into a model selection data table in an excel format, wherein the parameters required by model selection of each control valve in the model selection data table occupy one row of cells;
and importing the type selection data table into type selection calculation software to obtain a type selection result file, wherein the type selection result file comprises type selection calculation result parameters of each control valve.
2. The method for model selection of control valves according to claim 1, wherein after extracting parameters required for model selection of all control valves from the control valve data table according to the positions and importing the parameters required for model selection of each control valve into the model selection data table in excel format, the method further comprises the following steps:
and displaying a data processing interface according to the input of a user, wherein the data processing interface is used for screening, replacing or filling the parameters required by the specified type selection in the type selection data table.
3. The method for model selection of control valves according to claim 1, wherein after extracting parameters required for model selection of all control valves from the control valve data table according to the positions and importing the parameters required for model selection of each control valve into the model selection data table in excel format, the method further comprises the following steps:
And displaying a data input interface according to the input of the user, wherein the data input interface is used for providing an interface for the user to manually input the parameters of the control valve into the type selection data table.
4. The method for model selection of a control valve according to claim 1, wherein after obtaining the model selection result file, the method further comprises:
acquiring a first position of a designated type selection calculation result parameter in a type selection result file and a second position of the designated type selection calculation result parameter in the control valve data table;
and when an instruction for importing the specified type selection calculation result parameters into the control valve data table is received, importing the specified type selection calculation result parameters of the first position in the type selection result file into a second position in the control valve data table.
5. The method for model selection of a control valve according to claim 1, after obtaining the model selection result file, further comprising:
if the control valve is a partial rotation or butterfly valve, importing a model selection calculation result parameter required by the torque calculation of the control valve into a torque calculation module, wherein the torque calculation module is used for calculating the torque of the control valve;
and outputting the calculation result of the torque calculation module so that a user can select an actuating mechanism of the control valve according to the calculation result.
6. A control valve sizing device, comprising:
the control valve data table comprises a plurality of partitions, each partition is provided with the same number of cells, the number of rows and the number of columns of the cells are the same, a plurality of parameters of different control valves are recorded in different partitions, and the same parameter of each control valve is located at the same position in the partition;
the second acquisition module is used for acquiring the target position of the parameters required by the model selection of the control valve in the first subarea in the control valve data table;
the first import module is used for extracting all parameters required by model selection of the control valves from the control valve data table according to the target position, importing the parameters required by model selection of each control valve into a model selection data table in an excel format, wherein the parameters required by model selection of each control valve occupy one row of cells in the model selection data table;
and the second import module is used for importing the type selection data table into type selection calculation software to obtain a type selection result file, and the type selection result file comprises type selection calculation result parameters of each control valve.
7. The control valve sizing device according to claim 6, further comprising:
and the data processing module is used for displaying a data processing interface according to the input of a user, and the data processing interface is used for screening, replacing or filling the parameters required by the specified type selection in the type selection data table.
8. The control valve sizing device according to claim 6, further comprising:
and the data input module is used for displaying a data input interface according to the input of a user, and the data input interface is used for providing an interface for manually inputting the parameters of the control valve into the type selection data table for the user.
9. The control valve sizing device according to claim 6, further comprising:
the third acquisition module is used for acquiring a first position of the appointed type selection calculation result parameter in the type selection result file and a second position of the appointed type selection calculation result parameter in the control valve data table;
and the third importing module is used for importing the type selection calculation result parameter of the first position to the second position in the control valve data table when receiving an instruction of importing the specified type selection calculation result parameter to the control valve data table.
10. The control valve sizing device according to claim 6, further comprising:
the fourth importing module is used for importing the type selection calculation result parameters required by the torque calculation of the control valve into the torque calculation module if the control valve is a partial rotation or butterfly valve, and the torque calculation module is used for calculating the torque of the control valve;
and the output module is used for outputting the calculation result of the torque calculation module so that a user can select the actuating mechanism of the control valve according to the calculation result.
11. A control valve selection device comprising a memory, a processor and a computer program stored on the memory and executable on the processor; characterized in that the processor, when executing the program, implements a control valve selection method according to any one of claims 1 to 5.
12. A computer-readable storage medium, on which a computer program is stored, which program, when being executed by a processor, carries out the steps of the method for control valve selection according to any one of claims 1-5.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910304990.0A CN111859596B (en) | 2019-04-16 | 2019-04-16 | Control valve type selection method and control valve type selection device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910304990.0A CN111859596B (en) | 2019-04-16 | 2019-04-16 | Control valve type selection method and control valve type selection device |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN111859596A true CN111859596A (en) | 2020-10-30 |
| CN111859596B CN111859596B (en) | 2024-02-02 |
Family
ID=72951244
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910304990.0A Active CN111859596B (en) | 2019-04-16 | 2019-04-16 | Control valve type selection method and control valve type selection device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111859596B (en) |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| DE202013105338U1 (en) * | 2013-11-22 | 2014-01-29 | Jdv Control Valves Co., Ltd. | Parameter selection and calculation system for control valves |
| CN104156493A (en) * | 2013-05-13 | 2014-11-19 | 进典工业股份有限公司 | Parameter selection control device of control valve |
| US20150120065A1 (en) * | 2013-10-25 | 2015-04-30 | Yi-Ming Fan | Parameter selection and calculation system for control valves |
| CN105138777A (en) * | 2015-08-27 | 2015-12-09 | 北京恒华伟业科技股份有限公司 | Pole tower model selection method and device |
| US20160274593A1 (en) * | 2015-03-17 | 2016-09-22 | Azbil Corporation | Positioner |
| CN106372143A (en) * | 2016-08-29 | 2017-02-01 | 中国能源建设集团广东省电力设计研究院有限公司 | EXCEL internal function-based two-dimensional data linear query/valve selection method |
| CN109241514A (en) * | 2018-09-10 | 2019-01-18 | 深圳市泰洲科技有限公司 | Data automatically imported method, device, computer equipment and storage medium |
-
2019
- 2019-04-16 CN CN201910304990.0A patent/CN111859596B/en active Active
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104156493A (en) * | 2013-05-13 | 2014-11-19 | 进典工业股份有限公司 | Parameter selection control device of control valve |
| US20150120065A1 (en) * | 2013-10-25 | 2015-04-30 | Yi-Ming Fan | Parameter selection and calculation system for control valves |
| DE202013105338U1 (en) * | 2013-11-22 | 2014-01-29 | Jdv Control Valves Co., Ltd. | Parameter selection and calculation system for control valves |
| US20160274593A1 (en) * | 2015-03-17 | 2016-09-22 | Azbil Corporation | Positioner |
| CN105138777A (en) * | 2015-08-27 | 2015-12-09 | 北京恒华伟业科技股份有限公司 | Pole tower model selection method and device |
| CN106372143A (en) * | 2016-08-29 | 2017-02-01 | 中国能源建设集团广东省电力设计研究院有限公司 | EXCEL internal function-based two-dimensional data linear query/valve selection method |
| CN109241514A (en) * | 2018-09-10 | 2019-01-18 | 深圳市泰洲科技有限公司 | Data automatically imported method, device, computer equipment and storage medium |
Non-Patent Citations (3)
| Title |
|---|
| W BOOYSEN 等: "Selection of control valves on water optimisation projects", 《2011 PROCEEDINGS OF THE 8TH CONFERENCE ON THE INDUSTRIAL AND COMMERCIAL USE OF ENERGY》, pages 53 - 58 * |
| 李丽芬: "热力膨胀阀选型方法研究及对系统可靠性的影响", 《中国优秀硕士学位论文全文数据库 工程科技Ⅱ辑（2010）》, no. 04, pages 028 - 42 * |
| 王波: "协同液压设计资源共享平台及泵选型CAD系统开发", 《中国优秀博硕士学位论文全文数据库 (硕士)工程科技Ⅱ辑（2007）》, no. 02, pages 029 - 50 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN111859596B (en) | 2024-02-02 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| WO2017121400A1 (en) | Method, system and device for testing and readable storage medium | |
| Rushing et al. | Design and analysis of experiments by Douglas Montgomery: A supplement for using JMP | |
| CN113901647B (en) | Part technical specification compiling method and device, storage medium and electronic equipment | |
| Pascoe et al. | Designing and documenting experiments in CMIP6 | |
| CN114116441A (en) | UI (user interface) testing method and device, electronic equipment and storage medium | |
| CN112527676A (en) | Model automation test method, device and storage medium | |
| Alcácer et al. | Applying random coefficient models to strategy research: testing for firm heterogeneity, predicting firm-specific coefficients, and estimating Strategy Trade-Offs | |
| CN117235527A (en) | End-to-end containerized big data model construction method, device, equipment and medium | |
| Baig et al. | D-VASim: an interactive virtual laboratory environment for the simulation and analysis of genetic circuits | |
| CN110826306B (en) | Data acquisition method and device, computer readable storage medium and electronic equipment | |
| CN117094296A (en) | VB language-based form splitting method, intelligent terminal and storage medium | |
| CN111859596A (en) | Control valve model selection method and control valve model selection device | |
| CN106688002A (en) | Simulation system, simulation method, and simulation program | |
| US20190138921A1 (en) | Interactive guidance system for selecting thermodynamics methods in process simulations | |
| US20210049522A1 (en) | Future Prediction Simulation Apparatus, Method, and Computer Program | |
| CN115658617A (en) | Signal visualization analysis processing method and system based on MATLAB/App Designer development | |
| CN109492747A (en) | A kind of the network structure generation method and device of neural network | |
| CN116562254B (en) | System, method, electronic device and storage medium for rapidly generating report | |
| US9489369B2 (en) | Spread sheet application having multidimensional cells | |
| US11315198B2 (en) | Data analysis engine | |
| WO2023079810A1 (en) | Computer system and method for assisting investigation of device conditions | |
| CN117193733B (en) | Method for constructing and using example library and method for evaluating generated example code | |
| JP7186411B1 (en) | Information processing system, information processing method and information processing program | |
| US20230143489A1 (en) | Data analysis apparatus and data analysis method | |
| CN108038012A (en) | Data calibration method and device, electronic equipment and computer-readable recording medium |
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 |