A method for automatically calculating the proportion of materials for high-temperature alloy smelting

Abstract

The invention belongs to the technical field of metallurgical engineering, and discloses a method for automatically calculating the charging ratio of high-temperature alloy smelting. The high-temperature alloy mainly comprises 11 elements, namely: Cr, Ni, C, Mn, Si, Nb, W, Mo, Co, N, and Fe; and 17 optional raw materials, namely: 57 low-carbon chromium, 75 low-carbon chromium, micro-carbon chromium, metallic chromium, high-carbon chromium, graphite, nickel plate, metallic manganese, ferrosilicon, ferroniobium, metallic tungsten, ferromolybdenum, metallic cobalt, chromium nitride, carbon steel, and pure iron. The method realizes automatic calculation of charging ratio for smelting, and automatically determines the minimum charging amount when adjusting the components. The method has accurate calculation and high efficiency, and is widely applicable to high-temperature alloy smelting, greatly improves the first-time qualified rate of smelting, improves smelting efficiency, reduces energy consumption loss and manpower loss caused by waiting for the furnace, reduces raw material loss, and provides guarantee for smelting stability.

Description

Technical Field

[0001] The invention relates to the technical field of metallurgical engineering, and in particular to a method for automatically calculating the proportion of high-temperature alloy smelting materials. Background Art

[0002] For discrete high-temperature alloy product processing units, there are many types of products with small batches, and the minimum batch is only 1 piece. During production, it is necessary to calculate the material ratio according to different target composition requirements, and perform material smelting based on the calculation results. High-temperature alloy smelting involves 11 elements and 17 types of raw materials. The existing technology can only make a rough estimate by manual use of a calculator, and measure the composition after adding materials based on the estimated results. Repeated material addition and adjustment based on the composition results may still fail to meet the target ratio requirements in the end. In this case, both working hours and manpower are wasted, and the cost of raw material consumption is increased. There is an urgent need for an automatic calculation method to replace manual work to improve calculation efficiency and accuracy.

[0003] Among the existing methods to replace manual calculation, there are methods that use Excel spreadsheet formulas for calculation and Python's Numpy matrix calculation tool for solving determinants. Both methods require personnel to enter a large amount of information, have high requirements on the user level, do not consider the selectivity of raw materials, have no new ratio and composition adjustment function distinction, and cannot meet the needs of discrete high-temperature alloy product smelting and feeding ratio calculation. Summary of the invention

[0004] In order to overcome the above-mentioned defects in the prior art, the present invention provides a method for automatically calculating the material ratio for high-temperature alloy smelting.

[0005] A method for automatically calculating the material ratio of high-temperature alloy smelting, comprising the following steps:

[0006] S1. Determine the total weight of all raw materials and smelting required for the batching process in the high-temperature alloy smelting process;

[0007] S2. Establish a feature extraction module to feed each material type according to the preset feed ratio of each material type, and obtain the actual feed ratio of each material type in real time during the feeding process;

[0008] S3. Select the required elements according to the required materials in the alloy melting process, and list the linear relationship between the individual element composition and dosage in the raw materials and the elements required for smelting;

[0009] S4. Construct an input data module, input weight data of each material, smelting operation control parameters and preset values ​​of material ratio of each material, and obtain prediction input data;

[0010] S5. Establish a raw material allocation module, calculate the actual value obtained in step S2 and the predicted input data in step S4 according to the minimum feeding weight scheme, and obtain raw material allocation data.

[0011] Furthermore, the ingredients required in the batching process in step S1 include: 57 low-carbon chromium, 75 low-carbon chromium, micro-carbon chromium, metallic chromium, high-carbon chromium, graphite, nickel plate, metallic manganese, ferrosilicon, ferroniobium, metallic tungsten, ferromolybdenum, metallic cobalt, chromium nitride, carbon steel, pure iron, 304 briquette, and recycled steel ingot, among which 11 elements including Cr, Ni, C, Mn, Si, Nb, W, Mo, Co, N, and Fe are selected as the controlled components.

[0012] Furthermore, the user interface is designed, including three interfaces: raw material composition input, new furnace opening-smelting ratio calculation, and composition adjustment-smelting ratio calculation. The three interfaces correspond to corresponding tables respectively, and the raw material allocation data obtained in step S5 is output as a calculation process table.

[0013] Furthermore, the user interface requirement input, automatic formula calculation, and output data are visually color-coded.

[0014] Furthermore, the accounting process table is separated from the user interface, and both the accounting process and the user interface are selectively hidden so that the display screen shows a single working interface.

[0015] Further, according to step S3, the weight of each raw material added is set as an unknown number, and the linear relationship between the target element content and the raw material added weight is obtained according to the forward and reverse calculation paths of the target element content. The linear equation is expressed as:

[0016] Further, the weight of all added raw materials × Cr element percentage + the weight of the material in the furnace × Cr element percentage + the weight of the steel ingot × Cr element percentage = the total weight of this planned smelting × the target content percentage of Cr element;

[0017] The weight of all added raw materials × Ni element percentage + the weight of the material in the furnace × Ni element percentage + the weight of the steel ingot × Ni element percentage = the total weight of this planned smelting × the target content percentage of Ni element;

[0018] The weight of all added raw materials × the percentage of C element + the weight of the material in the furnace × the percentage of C element + the weight of the steel ingot × the percentage of C element = the total weight of this planned smelting × the target content percentage of C element;

[0019] The weight of all added raw materials × the percentage of Mn element + the weight of the material in the furnace × the percentage of Mn element + the weight of the steel ingot × the percentage of Mn element = the total weight of this planned smelting × the target content percentage of Mn element;

[0020] The weight of all added raw materials × Si element percentage + the weight of the material in the furnace × Si element percentage + the weight of the steel ingot × Si element percentage = the total weight of this planned smelting × the target content percentage of Si element;

[0021] The weight of all added raw materials × the percentage of Nb element + the weight of the material in the furnace × the percentage of Nb element + the weight of the steel ingot × the percentage of Nb element = the total weight of this planned smelting × the target content percentage of Nb element;

[0022] The weight of all added raw materials × the percentage of W element + the weight of the material in the furnace × the percentage of W element + the weight of the steel ingot × the percentage of W element = the total weight of this planned smelting × the target content percentage of W element;

[0023] The weight of all added raw materials × Mo element percentage + the weight of the material in the furnace × Mo element percentage + the weight of the steel ingot × Mo element percentage = the total weight of this planned smelting × the target content percentage of Mo element;

[0024] The weight of all added raw materials × Co element percentage + the weight of the material in the furnace × Co element percentage + the weight of the steel ingot × Co element percentage = the total weight of this planned smelting × the target content percentage of Co element;

[0025] The weight of all added raw materials × the percentage of N element + the weight of the material in the furnace × the percentage of N element + the weight of the steel ingot × the percentage of N element = the total weight of this planned smelting × the percentage of the target content of N element;

[0026] The weight of all added raw materials × the percentage of Fe element + the weight of the material in the furnace × the percentage of Fe element + the weight of the steel ingot × the percentage of Fe element = the total weight of this planned smelting × the target content percentage of Fe element.

[0027] Furthermore, in the user interface, the coefficients of Cr, Ni, C, Mn, Si, Nb, W, Mo, Co, N, and Fe are arranged horizontally in a certain order, and the vacancies are replaced by zeros. The values ​​calculated by the linear equation correspond to the order of the horizontally arranged coefficients from top to bottom to form an equation series matrix; the MINVERSE function provided in the Excel spreadsheet is used to solve the inverse matrix of the series matrix of the above-mentioned unknown coefficients, and the MMLULT function provided in the Excel spreadsheet is used to solve the unknowns in the inverse matrix, thereby obtaining the solutions to the unknowns of the set added weight of each element.

[0028] Furthermore, the raw material compositions in the corresponding tables in the New Furnace-Smelting Ratio Calculation and Composition Adjustment-Smelting Ratio Calculation interfaces are all derived from the table data in the raw material composition entry interface, the input data in the calculation process of the corresponding tables in the New Furnace-Smelting Ratio Calculation and Composition Adjustment-Smelting Ratio Calculation interfaces, the weight and composition of the materials in the furnace, the weight and composition of the recovered steel ingots, the total weight of this planned smelting, the target ratio and the types and composition of raw materials are derived from the corresponding contents in the respective front-end interfaces, and the output raw material addition weight information in the front-end interface is derived from the corresponding contents of the respective calculation processes.

[0029] Furthermore, for the user interface requirements input, automatic formula calculation and output data, the information entered is marked with orange cell color, the information automatically brought out by the formula is marked with colorless cells, the output information is marked with light green cell color, and only orange cells have open editing permissions, while the remaining cells are locked for editing.

[0030] Furthermore, in the same Excel table in step S5, 135 duplicate appendices for adjusting component-smelting ratio calculation are established. For the total weight information of the adjusting components in the appendices, the weight of the raw materials is in the range of 0-30kg, and the advanced input is made at an interval of 0.5; the weight of the raw materials is in the range of 30-100kg, and the advanced input is made at an interval of 2; the weight of the raw materials is in the range of 100-200kg, and the advanced input is made at an interval of 5; the weight of the raw materials is in the range of 200-300kg, and the advanced input is made at an interval of 10. The remaining information is derived from the adjusting component denominator table. The non-zero addition weight is judged in each duplicate appendix, and the MIN function is used to obtain the total weight of the adjusting components when the minimum non-zero addition weight is obtained, and the result is returned to the adjusting component denominator table, so as to realize the intelligent and automatic determination of the minimum total addition weight of the adjusting components.

[0031] Due to the adoption of the above technical scheme, the beneficial technical effects of the present invention are as follows: the present invention realizes automatic calculation of smelting ratio and charging, and automatically determines the minimum charging amount when adjusting the composition; the calculation is accurate and efficient, and is widely applicable to high-temperature alloy smelting, greatly improving the first-time qualified rate of smelting, improving smelting efficiency, reducing energy consumption loss and manpower loss caused by waiting for the furnace, reducing raw material loss, and providing guarantee for smelting stability. BRIEF DESCRIPTION OF THE DRAWINGS

[0032] Figure 1 It is the user interface for inputting raw material components in the present invention;

[0033] Figure 2 It is the user interface for calculating the smelting ratio of the newly opened furnace in the present invention;

[0034] Figure 3 It is the user interface for adjusting composition and calculating smelting ratio in the present invention;

[0035] Figure 4 It is the core calculation process chart of the smelting charge weight in the present invention.

[0036] Specific usage

[0037] In order to more clearly illustrate the technical solution of the present invention, the present invention is further described below in conjunction with the accompanying drawings. Obviously, the accompanying drawings described below are only one embodiment of the present invention. For ordinary technicians in this field, without paying any creative work, other embodiments can be obtained based on this drawing and embodiment, which all belong to the protection scope of the present invention.

[0038] according to Figure 1-4 As shown, a method for automatically calculating the material ratio of high-temperature alloy smelting includes the following steps:

[0039] S1. Determine the total weight of all raw materials and smelting required for the batching process in the high-temperature alloy smelting process;

[0040] S2. Establish a feature extraction module to feed each material type according to the preset feed ratio of each material type, and obtain the actual feed ratio of each material type in real time during the feeding process;

[0041] S3. Select the required elements according to the required materials in the alloy melting process, and list the linear relationship between the individual element composition and dosage in the raw materials and the elements required for smelting;

[0042] S4. Construct an input data module, input weight data of each material, smelting operation control parameters and preset values ​​of material ratio of each material, and obtain prediction input data;

[0043] S5. Establish a raw material allocation module, calculate the actual value obtained in step S2 and the predicted input data in step S4 according to the minimum feeding weight scheme, and obtain raw material allocation data.

[0044] The present invention realizes automatic calculation of smelting ratio and feeding, and automatically determines the minimum feeding amount when adjusting the composition; the calculation is accurate and efficient, and is widely applicable to high-temperature alloy smelting, greatly improving the first-time qualified rate of smelting, improving smelting efficiency, reducing energy consumption loss and manpower loss caused by waiting for the furnace, reducing raw material loss, and providing guarantee for smelting stability.

[0045] The ingredients required in the batching process in step S1 include: 57 low-carbon chromium, 75 low-carbon chromium, micro-carbon chromium, metallic chromium, high-carbon chromium, graphite, nickel plate, metallic manganese, ferrosilicon, ferroniobium, metallic tungsten, ferromolybdenum, metallic cobalt, chromium nitride, carbon steel, pure iron, 304 briquette, and recycled steel ingots, among which 11 elements, Cr, Ni, C, Mn, Si, Nb, W, Mo, Co, N, and Fe, are selected as the controlled components.

[0046] In the above specific technical scheme, according to the raw materials required for alloy smelting in the prior art, the optional raw materials are set to include 57 low-carbon chromium, 75 low-carbon chromium, micro-carbon chromium, metallic chromium, high-carbon chromium, graphite, nickel plate, metallic manganese, ferrosilicon, ferroniobium, metallic tungsten, ferromolybdenum, metallic cobalt, chromium nitride, carbon steel, pure iron, and 304 briquettes, a total of 17 types. In addition, recycled self-melting steel ingots are also included in the selection range according to the actual measured composition, so that 11 elements including Cr, Ni, C, Mn, Si, Nb, W, Mo, Co, N, and Fe are selected as the controlled components.

[0047] Design the user interface, including three interfaces: raw material composition input, new furnace-smelting ratio calculation, and composition adjustment-smelting ratio calculation. The three interfaces correspond to corresponding tables, and the raw material allocation data obtained in step S5 is output as a calculation process table. Visual color marking is performed on the user interface demand input, automatic formula calculation, and output data. The calculation process table is separated from the user interface, and both the calculation process and the user interface are selectively hidden, so that the display screen shows a single working interface.

[0048] Three interfaces are set up to record different data contents respectively, which is convenient for staff to operate in a targeted manner. The interfaces can be selectively hidden to ensure that the working interface of the display screen is clean and tidy. Different contents are marked with visual color markings to facilitate staff to accurately locate the required data.

[0049] According to step S3, the weight of each raw material added is set as an unknown number, and the linear relationship between the target element content and the raw material added weight is obtained according to the forward and reverse calculation paths of the target element content. The linear equation is expressed as:

[0050] The weight of all added raw materials × Cr element percentage + the weight of the material in the furnace × Cr element percentage + the weight of the steel ingot × Cr element percentage = the total weight of this planned smelting × the target content percentage of Cr element;

[0051] The weight of all added raw materials × Ni element percentage + the weight of the material in the furnace × Ni element percentage + the weight of the steel ingot × Ni element percentage = the total weight of this planned smelting × the target content percentage of Ni element;

[0052] The weight of all added raw materials × the percentage of C element + the weight of the material in the furnace × the percentage of C element + the weight of the steel ingot × the percentage of C element = the total weight of this planned smelting × the target content percentage of C element;

[0053] The weight of all added raw materials × the percentage of Mn element + the weight of the material in the furnace × the percentage of Mn element + the weight of the steel ingot × the percentage of Mn element = the total weight of this planned smelting × the target content percentage of Mn element;

[0054] The weight of all added raw materials × Si element percentage + the weight of the material in the furnace × Si element percentage + the weight of the steel ingot × Si element percentage = the total weight of this planned smelting × the target content percentage of Si element;

[0055] The weight of all added raw materials × the percentage of Nb element + the weight of the material in the furnace × the percentage of Nb element + the weight of the steel ingot × the percentage of Nb element = the total weight of this planned smelting × the target content percentage of Nb element;

[0056] The weight of all added raw materials × the percentage of W element + the weight of the material in the furnace × the percentage of W element + the weight of the steel ingot × the percentage of W element = the total weight of this planned smelting × the target content percentage of W element;

[0057] The weight of all added raw materials × Mo element percentage + the weight of the material in the furnace × Mo element percentage + the weight of the steel ingot × Mo element percentage = the total weight of this planned smelting × the target content percentage of Mo element;

[0058] The weight of all added raw materials × Co element percentage + the weight of the material in the furnace × Co element percentage + the weight of the steel ingot × Co element percentage = the total weight of this planned smelting × the target content percentage of Co element;

[0059] The weight of all added raw materials × the percentage of N element + the weight of the material in the furnace × the percentage of N element + the weight of the steel ingot × the percentage of N element = the total weight of this planned smelting × the percentage of the target content of N element;

[0060] The weight of all added raw materials × the percentage of Fe element + the weight of the material in the furnace × the percentage of Fe element + the weight of the steel ingot × the percentage of Fe element = the total weight of this planned smelting × the target content percentage of Fe element.

[0061] In the above specific technical solution, the weight of the raw materials is calculated respectively according to the above 11 linear equations and the types of raw materials required for the alloy, so as to determine the weight of the raw materials required to be added.

[0062] In the user end interface, the coefficients of Cr, Ni, C, Mn, Si, Nb, W, Mo, Co, N, and Fe are arranged horizontally in a certain order, and the vacancies are replaced by zeros. The values ​​calculated by the linear equation correspond to the order of the horizontally arranged coefficients from top to bottom to form an equation series matrix; the MINVERSE function of the Excel table is used to solve the inverse matrix of the series matrix of the above-mentioned unknown coefficients, and the MMLULT function of the Excel table is used to solve the unknown numbers of the inverse matrix, so as to obtain the solution of the unknown number of the added weight of each element set. The alloy smelting batching calculation method of the present invention is applicable to a variety of computer software platforms, has a fast and simple matrix calculation method in Excel, can be quickly adjusted according to demand, and has high adaptability.

[0063] The raw material compositions in the corresponding tables in the New Furnace-Smelting Proportion Calculation and Adjustment of Composition-Smelting Proportion Calculation interfaces are all derived from the table data in the raw material composition entry interface. The input data in the calculation process of the corresponding tables in the New Furnace-Smelting Proportion Calculation and Adjustment of Composition-Smelting Proportion Calculation interfaces, the weight and composition of the materials in the furnace, the weight and composition of the recovered steel ingots, the total weight of this planned smelting, the target ratio and the types and composition of raw materials are derived from the corresponding contents in the respective front-end interfaces. The output raw material addition weight information in the front-end interface is derived from the corresponding contents of the respective calculation processes. Multiple interfaces cooperate with each other to improve the orderliness of data input and output.

[0064] For the user interface requirements input, automatic formula calculation and output data, the required input information is marked with orange cell color, the information automatically brought out by the formula is marked with colorless cells, and the output information is marked with light green cell color. Only orange cells have open editing permissions, and the remaining cells are locked for editing, so as to reduce the probability of incorrect input and modification.

[0065] In the same Excel table in step S5, 135 duplicate appendices for adjusting ingredients and smelting ratio calculation are established. The total weight information of the adjusting ingredients in the appendices is that the weight of the raw materials is in the range of 0-30kg, and the advanced input is made at an interval of 0.5; the weight of the raw materials is in the range of 30-100kg, and the advanced input is made at an interval of 2; the weight of the raw materials is in the range of 100-200kg, and the advanced input is made at an interval of 5; the weight of the raw materials is in the range of 200-300kg, and the advanced input is made at an interval of 10. The rest of the information is derived from the adjusting ingredient denominator table. The non-zero addition weight is judged in each duplicate appendix, and the MIN function is used to obtain the total weight of the adjusting ingredients when the minimum non-zero addition weight is obtained, and the result is returned to the adjusting ingredient denominator table, so that the minimum total addition weight of the adjusting ingredients can be obtained intelligently and automatically.

[0066] In the above specific technical scheme, a function of automatically solving the minimum total weight of added materials is designed. The implementation method is to exhaustively enumerate the total weight of added materials in the range of 0-300kg in a certain advanced way, and obtain the feeding scheme values ​​respectively. Those with negative added weights are eliminated, and the total added weights with positive added weights are minimized by using the MINIMUM function, which is the minimum total added weight. This function realizes the consumption of the least raw materials when adjusting the ingredients, saving material consumption costs.

[0067] Specifically, the steps for automatically calculating the material ratio for high-temperature alloy smelting are as follows:

[0068] 1. Open the Excel table for automatic ratio calculation;

[0069] 2. Confirm / maintain raw material composition information;

[0070] 3. When a new furnace is opened, enter the total weight of the planned smelting, the target proportion composition, the weight and composition of the materials in the furnace, the weight and composition of the added recycled ingots, select and confirm the variable raw materials, and you can get the added material weight information;

[0071] 4. When adjusting the ingredients, enter the target ratio, weight and composition of the materials in the furnace, select and confirm the variable raw materials, and you can get the minimum added weight information for qualified ingredient adjustment.

Claims

1. A method for automatically calculating the material ratio for high-temperature alloy smelting, characterized in that: The following steps are involved: S1. Determine the total weight of all raw materials and smelting required for the batching process in the high-temperature alloy smelting process; S2. Establish a feature extraction module to feed each material type according to the preset feed ratio of each material type, and obtain the actual feed ratio of each material type in real time during the feeding process; S3. Select the required elements according to the required materials in the alloy melting process, and list the linear relationship between the individual element composition and dosage in the raw materials and the elements required for smelting; S4. Construct an input data module, input weight data of each material, smelting operation control parameters and preset values ​​of material ratio of each material, and obtain prediction input data; S5. Establish a raw material allocation module, calculate the actual value obtained in step S2 and the predicted input data in step S4 according to the minimum feeding weight scheme, and obtain raw material allocation data.

2. The method for automatically calculating the material ratio of high-temperature alloy smelting according to claim 1 is characterized in that: The ingredients required in the batching process in step S1 include: 57 low-carbon chromium, 75 low-carbon chromium, micro-carbon chromium, metallic chromium, high-carbon chromium, graphite, nickel plate, metallic manganese, ferrosilicon, ferroniobium, metallic tungsten, ferromolybdenum, metallic cobalt, chromium nitride, carbon steel, pure iron, 304 briquette, and recycled steel ingots, among which 11 elements, Cr, Ni, C, Mn, Si, Nb, W, Mo, Co, N, and Fe, are selected as the controlled components.

3. The method for automatically calculating the material ratio of high-temperature alloy smelting according to claim 1 is characterized in that: The user interface is designed, including three interfaces: raw material composition input, new furnace opening-smelting ratio calculation, and composition adjustment-smelting ratio calculation. The three interfaces correspond to corresponding tables respectively. The raw material allocation data obtained in step S5 is output as a calculation process table.

4. The method for automatically calculating the material ratio of high-temperature alloy smelting according to claim 3 is characterized in that: The user interface requirement input, automatic formula calculation, and output data are visually marked with colors.

5. The method for automatically calculating the material ratio of high-temperature alloy smelting according to claim 4 is characterized in that: The accounting process form is separated from the user interface, and both the accounting process and the user interface are selectively hidden so that the display screen shows a single working interface.

6. The method for automatically calculating the material ratio of high-temperature alloy smelting according to claim 1 is characterized in that: According to step S3, the weight of each raw material added is set as an unknown number, and the linear relationship between the target element content and the raw material added weight is obtained according to the forward and reverse calculation paths of the target element content. The linear equation is expressed as: The weight of all added raw materials × Cr element percentage + the weight of the material in the furnace × Cr element percentage + the weight of the steel ingot × Cr element percentage = the total weight of this planned smelting × the target content percentage of Cr element; The weight of all added raw materials × Ni element percentage + the weight of the material in the furnace × Ni element percentage + the weight of the steel ingot × Ni element percentage = the total weight of this planned smelting × the target content percentage of Ni element; The weight of all added raw materials × the percentage of C element + the weight of the material in the furnace × the percentage of C element + the weight of the steel ingot × the percentage of C element = the total weight of this planned smelting × the target content percentage of C element; The weight of all added raw materials × the percentage of Mn element + the weight of the material in the furnace × the percentage of Mn element + the weight of the steel ingot × the percentage of Mn element = the total weight of this planned smelting × the target content percentage of Mn element; The weight of all added raw materials × Si element percentage + the weight of the material in the furnace × Si element percentage + the weight of the steel ingot × Si element percentage = the total weight of this planned smelting × the target content percentage of Si element; The weight of all added raw materials × the percentage of Nb element + the weight of the material in the furnace × the percentage of Nb element + the weight of the steel ingot × the percentage of Nb element = the total weight of this planned smelting × the target content percentage of Nb element; The weight of all added raw materials × the percentage of W element + the weight of the material in the furnace × the percentage of W element + the weight of the steel ingot × the percentage of W element = the total weight of this planned smelting × the target content percentage of W element; The weight of all added raw materials × Mo element percentage + the weight of the material in the furnace × Mo element percentage + the weight of the steel ingot × Mo element percentage = the total weight of this planned smelting × the target content percentage of Mo element; The weight of all added raw materials × Co element percentage + the weight of the material in the furnace × Co element percentage + the weight of the steel ingot × Co element percentage = the total weight of this planned smelting × the target content percentage of Co element; The weight of all added raw materials × the percentage of N element + the weight of the material in the furnace × the percentage of N element + the weight of the steel ingot × the percentage of N element = the total weight of this planned smelting × the percentage of the target content of N element; The weight of all added raw materials × the percentage of Fe element + the weight of the material in the furnace × the percentage of Fe element + the weight of the steel ingot × the percentage of Fe element = the total weight of this planned smelting × the target content percentage of Fe element.

7. The method for automatically calculating the material ratio of high-temperature alloy smelting according to claim 5, characterized in that: In the user interface, the coefficients of Cr, Ni, C, Mn, Si, Nb, W, Mo, Co, N, and Fe are arranged horizontally in a certain order, and the vacancies are replaced by zeros. The values ​​calculated by the linear equation correspond to the order of the horizontally arranged coefficients from top to bottom to form an equation series matrix; the MINVERSE function of the Excel spreadsheet is used to solve the inverse matrix of the series matrix of the above unknown coefficients, and the MMLULT function of the Excel spreadsheet is used to solve the unknowns of the inverse matrix, so as to obtain the solutions of the unknowns of the set feeding weight of each element.

8. The method for automatically calculating the material ratio of high temperature alloy smelting according to claim 7, characterized in that: The raw material compositions in the corresponding tables in the New Furnace-Smelting Ratio Calculation and Adjustment of Composition-Smelting Ratio Calculation interfaces are all derived from the table data in the raw material composition entry interface. The input data in the calculation process of the corresponding tables in the New Furnace-Smelting Ratio Calculation and Adjustment of Composition-Smelting Ratio Calculation interfaces, the weight and composition of the materials in the furnace, the weight and composition of the recovered steel ingots, the total weight of this planned smelting, the target ratio and the types and composition of raw materials are derived from the corresponding contents in the respective front-end interfaces. The output raw material addition weight information in the front-end interface is derived from the corresponding contents of the respective calculation processes.

9. The method for automatically calculating the material ratio of high-temperature alloy smelting according to claim 4, characterized in that: For user interface requirements input, automatic formula calculation and output data, the required input information is marked with orange cell color, the information automatically brought out by the formula is marked with colorless cells, and the output information is marked with light green cell color. Only orange cells have open editing permissions, and the remaining cells are locked for editing.

10. The method for automatically calculating the material ratio for high temperature alloy smelting according to claim 1, characterized in that: In the same Excel table in step S5, 135 duplicate appendices for adjusting ingredients and smelting ratio calculation are established. The total weight information of the adjusting ingredients in the appendices is that the weight of the raw materials is in the range of 0-30kg, and the advanced input is made at an interval of 0.5; the weight of the raw materials is in the range of 30-100kg, and the advanced input is made at an interval of 2; the weight of the raw materials is in the range of 100-200kg, and the advanced input is made at an interval of 5; the weight of the raw materials is in the range of 200-300kg, and the advanced input is made at an interval of 10. The rest of the information is derived from the adjusting ingredient denominator table. The non-zero addition weight is judged in each duplicate appendix, and the MIN function is used to obtain the total weight of the adjusting ingredients when the minimum non-zero addition weight is obtained, and the result is returned to the adjusting ingredient denominator table, so that the minimum total addition weight of the adjusting ingredients can be obtained intelligently and automatically.

Images