Pellet engineering instrument high-stage design system and control method

Abstract

A pellet engineering instrument high-stage design system and a control method belong to the technical field of pellet engineering automation instruments, and the pellet engineering instrument high-stage design system comprises a pellet instrument budget basic database, a pellet instrument price database, a system configuration interface module and a master control center, and the three modules are connected with the master control center. An engineer sets input pellet instrument high-stage design options through a system configuration interface, the system automatically queries and matches a pellet instrument budget basic database and a pellet instrument price database according to the input content by analyzing expert experience and related standards and pellet processes, and automatically generates a pellet instrument high-stage equipment table and budget through an algorithm. And full-automatic high-stage design is completed. According to the method, expert experience is combined with related standards and the pelletizing process, automatic design and standardization of the high-stage instrument are achieved with the minimum system input quantity to the maximum extent, the design productivity is improved, and the design error rate is reduced.

Description

Technical Field

[0001] The invention belongs to the technical field of pelletizing engineering automation instruments, and in particular relates to a pelletizing engineering instrument high-stage design system and a control method. Background Art

[0002] In traditional engineering design, the pelletizing engineering automation instrumentation high stage needs to prepare a budget estimate table through EXCEL, which is inefficient, has a high error rate, a large workload, and there is no specially customized efficient design software.

[0003] In the prior art, no automatic design software has been developed to automatically complete the technology and algorithms of automated design using computer programs, thereby greatly improving design efficiency, reducing error rates, and achieving drawing standardization.

[0004] In the existing technology, there is no combination of expert experience with relevant standards and pelletizing processes to achieve automatic design of high-level instruments with minimal system input to the greatest extent possible, nor is there a method or system designed to standardize the design process, improve design productivity, and reduce the design error rate.

[0005] Defects and shortcomings of existing technology (manual labor):

[0006] (1) Low efficiency.

[0007] (2) High error rate.

[0008] (3) Low degree of standardization.

[0009] (4) Heavy workload. Summary of the invention

[0010] In order to solve the above-mentioned problems, the present invention proposes: a high-stage design system for pelletizing engineering instruments, including a pelletizing instrument budget basic database, a pelletizing instrument price database, and a system configuration interface three modules and a main control center. The pelletizing instrument budget basic database, the pelletizing instrument price database, and the system configuration interface three modules are all connected to the main control center. The engineering personnel set and input the pelletizing instrument high-stage design options through the system configuration interface. The system automatically queries and matches the pelletizing instrument budget basic database and the pelletizing instrument price database based on the input content by analyzing the expert experience and relevant standards and the pelletizing process, and automatically generates the pelletizing instrument high-stage equipment table and budget through the algorithm to complete the fully automated high-stage design.

[0011] Furthermore, a basic database of pelletizing instrument budget is designed and constructed, involving workshops including: raw material yard, coal powder preparation, concentrate drying room, high-pressure batching room, pelletizing room, chain grate machine room, rotary kiln, ring cooler, heat recovery fan, furnace hood air dust removal, main electrostatic precipitator and main exhaust fan, finished product system, dust removal system, water pump station, energy metering, and air compressor station; according to expert experience, relevant standards, and pelletizing process, the information of various instruments in the above workshops is constructed, including "name", "unit", "quantity", "unit price", "total price", and "installation fee", forming Table 1, where:

[0012] 1) All kinds of instruments and equipment are listed in full based on engineering experience;

[0013] 2) Instrument quantity: pre-set as a constant value based on engineering experience and stored in the database. When the engineer makes a specific input in the "system configuration interface", the input value is taken;

[0014] 3) Equipment unit price: call the "pellet instrument price database" to read the unit prices of different grades of equipment;

[0015] 4) Total equipment price: Total equipment price = quantity x unit price;

[0016] 5) Installation fee: Set the coefficient based on the "System Configuration Interface" and take the equipment installation fee.

[0017] Furthermore, a pelletizing instrument price database is designed and constructed, involving all pelletizing engineering instrument types, forming Table 2, and the instrument prices are divided into grades for estimation. The number of grades is greater than or equal to 3, and a database is established for ready use.

[0018] Further, in the overall configuration interface, using a drop-down menu or fill-in-the-blank method, the engineer configures the following parameters to form Table 3:

[0019] The investment / equipment level option is used to search the price quantity library and allocate prices according to the selected level in the later stage;

[0020] The installation fee ratio option is used to make an estimate of the installation construction fee based on the filled ratio in the later stage. Installation fee = equipment price * ratio;

[0021] The Isolation Distributor Location option is used to select whether to include signal isolation equipment;

[0022] The trade measurement option is used to select whether to select a trade measurement scale in the raw material input workshop;

[0023] The temperature transmitter option is used to select whether to use a temperature transmitter;

[0024] The Isolation Distribution Backup Ratio option is used to configure the backup ratio.

[0025] Furthermore, the configuration interface of each pelletizing workshop is constructed to form Table 4. The workshops involved include: raw material yard, coal powder preparation, concentrate drying room, high-pressure batching room, pelletizing room, chain grate machine room, rotary kiln, ring cooler, heat recovery fan, furnace hood air dust removal, main electrostatic precipitator and main exhaust fan, finished product system, dust removal system, water pump station, energy metering, and air compressor station; according to the expert engineering design experience, specifications, and process content, the instrument detection distribution of each workshop of the pelletizing plant is configured in the interface.

[0026] A control method according to the above-mentioned pelletizing engineering instrument high-stage design system comprises the following steps:

[0027] S1. Read the input content of the engineering staff;

[0028] S2. According to the number of "workshops" entered in Table 4, find out which workshops the pelletizing plant includes:

[0029] 0 means there is no workshop with this name, 1~n: input integers to indicate how many workshops with this name there are in the project;

[0030] S3. Retrieve "Table 1" "Basic Database of Estimated Cost of Pelletizing Instruments" and preliminarily configure the contents and quantity of instruments in each workshop;

[0031] S4. According to the workshop instrument information input in "Table 4", modify the content and quantity of instruments in each workshop;

[0032] Correct the number of various instruments in the workshop:

[0033] Calculate the number of "isolators", "distributors" and "temperature transmitters"

[0034] Calculate the number of "instrument panel box" and "DC power supply"

[0035] S5. Calculate the price of each instrument according to the instrument grade and special options entered in "Table 3";

[0036] Price according to grade:

[0037] Calculate the installation fee based on the installation fee ratio

[0038] Correct the price of settlement instruments such as belt scales in batching and raw material workshops according to trade measurement

[0039] S6. Generate a final high-stage instrument equipment table;

[0040] S7. Generate the final high-stage instrument budget table.

[0041] Furthermore, the step S4 includes the following steps:

[0042] S41. Correct the number of instruments in the workshop:

[0043] According to the situation of instruments in a workshop input in "Table 4", correct the number of instruments;

[0044] S42. Calculate the number of “isolators”, “distributors” and “temperature transmitters”:

[0045] For instruments that input and output 4-20mA DC signals:

[0046] Isolator quantity algorithm:

[0047] N1 = (number of four-wire instruments + number of actuators * 2) * (1 + standby ratio)

[0048] Distributor quantity algorithm:

[0049] N2 = number of two-wire instruments * (1 + standby ratio)

[0050] Temperature transmitter quantity calculation method:

[0051] N3 = (number of thermocouples + number of thermal resistors) * (1 + spare ratio)

[0052] S43. Calculate the quantity of “instrument panel box” and “DC power supply”:

[0053] Number of “instrument panel boxes”: The number of instrument panel boxes is configured according to the number of instruments in the workshop, usually 1, and the pelletizing room and batching room are set to 2~3.

[0054] Number of “DC power supplies”: Number of DC power supplies = number of panels (with isolated distributors).

[0055] The beneficial effects of the present invention are: the present invention combines expert experience with relevant standards and pelletizing technology to achieve the automatic design of the instrument at a high stage with the minimum system input to the greatest extent, standardize the design process, improve the design productivity, and reduce the design error rate. It has the following advantages:

[0056] (1) Efficient.

[0057] (2) High accuracy.

[0058] (3) Drawing standardization.

[0059] (4) Reduce labor intensity.

[0060] (5) Designs are made based on expert experience to improve design quality. BRIEF DESCRIPTION OF THE DRAWINGS

[0061] Figure 1 This is a system flow chart for the high-stage design of pelletizing engineering instrumentation of the present invention. DETAILED DESCRIPTION

[0062] In order to make the technical means and objectives of the present invention easy to understand, the present invention is further described below in combination with specific implementation methods. A pelletizing engineering instrument high-stage design system includes a pelletizing instrument budget basic database, a pelletizing instrument price database, and a system configuration interface three modules and a main control center. The pelletizing instrument budget basic database, the pelletizing instrument price database, and the system configuration interface are all connected to the main control center. Through the system configuration interface, the engineer sets and inputs the pelletizing instrument high-stage design options. The system automatically queries and matches the pelletizing instrument budget basic database and the pelletizing instrument price database based on the input content, by analyzing expert experience and relevant standards and pelletizing processes, and automatically generates a pelletizing instrument high-stage equipment table and budget through an algorithm to complete a fully automated high-stage design. The purpose of this patent is to realize the automatic design of pelletizing plant instruments at a high stage.

[0063] Architecture design:

[0064] Combining expert experience with relevant standards and pelletizing processes, we can achieve automatic design of the power supply system with minimal system input to the greatest extent possible, standardize the design process, improve design productivity, and reduce the design error rate.

[0065] The patented system structure is designed as follows:

[0066] Construct three modules: "Basic database for rough estimate of pelletizing instrument", "Price database for pelletizing instrument" and "System configuration interface". The administrator has the authority to modify the database parameters.

[0067] Through the "system configuration interface", engineers can input high-stage design options for pelletizing instruments. Based on the input content, the system analyzes expert experience, relevant standards, and pelletizing processes, and automatically queries and matches the "pelletizing instrument budget basic database" and "pelletizing instrument price database". The system automatically generates a high-stage equipment table and budget for pelletizing instruments through algorithms to complete fully automated high-stage design.

[0068] Software environment:

[0069] In order to meet the needs of office and design to the greatest extent, this patent uses the VBA language environment of the conventional software EXCEL for degree development, without the need to install additional plug-ins, so as to adapt to user habits, and is compatible with WPS. The system input end is designed in the EXCEL table, which is very convenient for users to use.

[0070] The program is written in VBA language, involving VBA language such as cell judgment, writing, deleting, row and column operations, and table generation.

[0071] Hardware composition:

[0072] In order to best meet office and design needs, the hardware is adapted to conventional computer systems.

[0073] 1. Design of “Basic database for rough estimate of pelletizing instrument”:

[0074] The design of "Basic Database of Estimated Cost of Pelletizing Instruments" involves workshops including: raw material yard, coal powder preparation, concentrate drying room, high-pressure batching room, pelletizing room, chain grate machine room (roasting machine), rotary kiln, ring cooler, heat recovery fan, furnace hood air dust removal, main electrostatic precipitator and main exhaust fan, finished product system, dust removal system, water pump station, energy metering, compressor station and other workshops.

[0075] According to expert experience, relevant standards, and pelletizing process, the information of various instruments in the above workshops is constructed, including "name", "unit", "quantity", "unit price", "total price", and "installation fee", among which:

[0076] 1) All kinds of instruments and equipment are listed in full based on engineering experience;

[0077] 2) Instrument quantity: pre-set as a constant value based on engineering experience and stored in the database. When the engineer makes a specific input in the "system configuration interface", the input value is taken;

[0078] 3) Equipment unit price: call the "pellet instrument price database" to read the unit prices of different grades of equipment;

[0079] 4) Total equipment price: Total equipment price = quantity x unit price;

[0080] 5) Installation fee: The equipment installation fee is calculated based on the coefficient set in the "System Configuration Interface";

[0081] Taking the "Chain Grate Room" of the main plant of the pelletizing project as an example, the following lists the "Pelletizing Instrument Estimation Basic Database" information of the pelletizing room related instruments. The data of more than ten other workshops are similar in form but different in content. The content is compiled by engineers based on design experience and will not be listed again.

[0082] Table 1

[0083]

[0084] 2. Design of “Pelletizing Instrument Price Database”:

[0085] The design of "pellet instrument price database" involves all types of pellet engineering instruments, including: temperature, pressure, flow, level, various analysis systems, valves, signal equipment, etc. The database structure is constructed as follows:

[0086] Table 2

[0087]

[0088]

[0089] In the above table, the instrument prices are divided into grades (multiple grades, more than 3 grades) and the database is established for reference. Due to the wide variety of pelletizing engineering instruments, only some instruments are listed in the table, and the price structure of other instruments is the same.

[0090] 3. “System Configuration Interface” Design:

[0091] 1) Overall configuration interface:

[0092] In the overall configuration interface, engineers configure the following parameters using the drop-down menu or fill-in-the-blank method:

[0093] Table 3

[0094]

[0095]

[0096] In Table 3 above:

[0097] 1. The investment / equipment level option is used to find the price quantity library according to the selected level in the later stage, and the price is used

[0098] 2. The installation fee ratio option is used to make an estimate of the installation construction cost based on the filled ratio in the later stage. Installation fee = equipment price * ratio

[0099] 3. The isolation distributor location option is used to select whether to include signal isolation equipment

[0100] 4. The trade measurement option is used to select whether to select a trade measurement scale in the raw material input workshop

[0101] 5. The temperature transmitter option is used to select whether to use a temperature transmitter.

[0102] 6. The isolation distribution backup ratio option is used to configure the backup ratio

[0103] 2) Configuration interface of each pelletizing workshop:

[0104] Construct the "pelletizing workshop configuration interface", involving workshops including: raw material yard, coal powder preparation, concentrate drying room, high-pressure batching room, pelletizing room, chain grate machine room (roasting machine), rotary kiln, ring cooler, heat recovery fan, furnace hood wind dust removal, main electrostatic precipitator and main exhaust fan, finished product system, dust removal system, water pump station, energy metering, compressor station and other workshops.

[0105] According to the expert engineering design experience, specifications, and process content, the instrument detection distribution of each workshop of the pelletizing plant is configured in the interface to meet the specific design requirements of different projects. See Table 4.

[0106] Table 4

[0107]

[0108]

[0109] 4. Procedure steps: Figure 1 As shown;

[0110] 1) Read the input from the engineer

[0111] 2) According to the number of "workshops" entered in Table 4, find out which workshops the pelletizing plant includes:

[0112] 0 means there is no workshop with this name

[0113] 1~n: Enter an integer to indicate how many workshops of the same name there are in the project.

[0114] 3) Retrieve "Table 1" "Basic Database of Estimated Estimation of Pelletizing Instruments" and preliminarily configure the contents and quantity of instruments in each workshop

[0115] 4) According to the workshop instrument information entered in "Table 4", modify the content and quantity of instruments in each workshop

[0116] Correct the number of various instruments in the workshop

[0117] Calculate the number of "isolators", "distributors" and "temperature transmitters"

[0118] Calculate the number of "instrument panel box" and "DC power supply"

[0119] 5) According to the instrument grade and special options entered in "Table 3", solve the price of each instrument according to the grade and price

[0120] Calculate the installation fee based on the installation fee ratio

[0121] Correct the price of settlement instruments such as belt scales in batching and raw material workshops according to trade measurement

[0122] 6) Generate the final high-level instrument equipment table

[0123] 7) Generate the final high-level instrument budget table

[0124] 5 Algorithm Design

[0125] In the above procedure step 4), the algorithms involved are:

[0126] 1) Correct the number of instruments in the workshop

[0127] According to the situation of the instruments in a workshop entered in "Table 4", the number of instruments is corrected. For example, if the instrument engineer enters 18 in the "Number of Ore Slots" of the "Batching Room", the number of radar level meters in the instrument equipment table is forced to be set to 8.

[0128] 2) Calculate the number of "isolators", "distributors" and "temperature transmitters"

[0129] For instruments that input and output 4-20mA DC signals:

[0130] Isolator quantity algorithm:

[0131] N1 = (number of four-wire instruments + number of actuators * 2) * (1 + standby ratio)

[0132] Distributor quantity algorithm:

[0133] N2 = number of two-wire instruments * (1 + standby ratio)

[0134] Temperature transmitter quantity calculation method:

[0135] N3 = (number of thermocouples + number of thermal resistors) * (1 + spare ratio)

[0136] 3) Calculate the number of "instrument panel box" and "DC power supply"

[0137] Number of “instrument panel boxes”: The number of instrument panel boxes is configured according to the number of instruments in the workshop, usually 1, and the pelletizing room and batching room are usually set to 2~3.

[0138] Number of “DC power supplies”: Number of DC power supplies = number of panels (with isolated distributors).

[0139] The above description is only a preferred specific implementation manner of the present invention, but the protection scope of the present invention is not limited thereto. Any technician familiar with the technical field can make equivalent replacements or changes according to the technical solutions and concepts of the present invention within the technical scope disclosed by the present invention, which should be covered by the protection scope of the present invention.

Claims

1. A pelletizing engineering instrument high-level design system, characterized in that: It includes three modules, namely, the basic database for estimated cost of pelletizing instrument, the price database for pelletizing instrument, and the system configuration interface, as well as the main control center. The three modules are connected to the main control center. The engineers set and input the high-stage design options of pelletizing instrument through the system configuration interface. The system automatically queries and matches the basic database for estimated cost of pelletizing instrument and the price database for pelletizing instrument based on the input content by analyzing the expert experience, relevant standards and pelletizing process. The high-stage equipment table and estimated cost of pelletizing instrument are automatically generated through the algorithm to complete the fully automated high-stage design.

2. The pelletizing engineering instrument high-level design system according to claim 1, characterized in that: The basic database of pelletizing instrument budget estimate was designed and constructed. The workshops involved included: raw material yard, coal powder preparation, concentrate drying room, high-pressure batching room, pelletizing room, chain grate machine room, rotary kiln, ring cooler, heat recovery fan, furnace hood air dust removal, main electrostatic precipitator and main exhaust fan, finished product system, dust removal system, water pump station, energy metering, and air compressor station. According to expert experience, relevant standards, and pelletizing process, the information of various instruments in the above workshops was constructed, including "name", "unit", "quantity", "unit price", "total price", and "installation fee", forming Table 1, where: 1) All kinds of instruments and equipment are listed in full based on engineering experience; 2) Instrument quantity: pre-set as a constant value based on engineering experience and stored in the database. When the engineer makes a specific input in the "system configuration interface", the input value is taken; 3) Equipment unit price: call the "pellet instrument price database" to read the unit prices of different grades of equipment; 4) Total equipment price: Total equipment price = quantity x unit price; 5) Installation fee: Set the coefficient based on the "System Configuration Interface" and take the equipment installation fee.

3. The pelletizing engineering instrument high-level design system according to claim 2, characterized in that: Design and construct a pelletizing instrument price database, involving all pelletizing engineering instrument types, forming Table 2, and divide the instrument prices into grades for estimation. The number of grades is greater than or equal to 3, and a database is established for future use.

4. The pelletizing engineering instrument high-level design system according to claim 3, characterized in that: On the overall configuration interface, using the drop-down menu or fill-in-the-blank method, the engineer configures the following parameters to form Table 3: The investment / equipment level option is used to search the price quantity library and allocate prices according to the selected level in the later stage; The installation fee ratio option is used to make an estimate of the installation construction fee based on the filled ratio in the later stage. Installation fee = equipment price * ratio; The Isolation Distributor Location option is used to select whether to include signal isolation equipment; The trade measurement option is used to select whether to select a trade measurement scale in the raw material input workshop; The temperature transmitter option is used to select whether to use a temperature transmitter; The Isolation Distribution Backup Ratio option is used to configure the backup ratio.

5. The pelletizing engineering instrument high-level design system according to claim 4, characterized in that: Construct the configuration interface of each pelletizing workshop to form Table 4. The workshops involved include: raw material yard, coal powder preparation, concentrate drying room, high-pressure batching room, pelletizing room, chain grate machine room, rotary kiln, ring cooler, heat recovery fan, furnace hood air dust removal, main electrostatic precipitator and main exhaust fan, finished product system, dust removal system, water pump station, energy metering, and air compressor station; according to the expert engineering design experience, specifications, and process content, the instrument detection distribution of each workshop of the pelletizing plant is configured in the interface.

6. A control method for a pelletizing engineering instrumentation high-stage design system according to claim 1, characterized in that: The steps include: S1. Read the input content of the engineering staff; S2. According to the number of "workshops" input in Table 4, find out which workshops the pelletizing plant includes: 0 means there is no workshop with this name, 1~n: input integers to indicate how many workshops with this name there are in the project; S3. Retrieve "Table 1" "Basic Database of Estimated Cost of Pelletizing Instruments", and preliminarily configure the contents and quantity of instruments in each workshop; S4. According to the workshop instrument information input in "Table 4", modify the content and quantity of instruments in each workshop; Correct the number of various instruments in the workshop: Calculate the number of "isolators", "distributors", and "temperature transmitters" Calculate the number of "instrument panel box" and "DC power supply" S5. Calculate the price of each instrument according to the instrument grade and special options entered in "Table 3"; Price according to grade: Calculate the installation fee based on the installation fee ratio Correct the price of settlement instruments such as belt scales in batching and raw material workshops according to trade measurement S6. Generate a final high-stage instrument equipment table; S7. Generate the final high-stage instrument budget table.

7. The control method of the pelletizing engineering instrument high-stage design system according to claim 6, characterized in that: The step S4 includes the following steps: S41. Correct the number of instruments in the workshop: According to the situation of instruments in a workshop input in "Table 4", correct the number of instruments; S42. Calculate the quantity of "isolators", "distributors" and "temperature transmitters": For instruments that input and output 4-20mA DC signals: Isolator quantity algorithm: N1 = (number of four-wire instruments + number of actuators * 2) * (1 + standby ratio) Distributor quantity algorithm: N2 = number of two-wire instruments * (1 + standby ratio) Temperature transmitter quantity calculation method: N3 = (number of thermocouples + number of thermal resistors) * (1 + spare ratio) S43. Calculate the quantity of "instrument panel box" and "DC power supply": Number of "instrument panel boxes": The number of instrument panel boxes is configured according to the number of instruments in the workshop, usually 1, and the pelletizing room and batching room are set to 2~3. Quantity of "DC power supplies": Quantity of DC power supplies = number of panels (with isolated distributors).

Images