EXCEL internal function-based two-dimensional data linear query/valve selection method

Abstract

The invention relates to an EXCEL internal function-based two-dimensional data linear query / valve selection method. The method comprises the steps of 1) establishing standard valve parameters in EXCEL, and forming a two-dimensional array corresponding to a temperature and a pressure; 2) performing a query by applying an EXCEL internal function, wherein the query method comprises the steps of determining a form and a row number in which a corresponding material is located according to the valve material; determining a row number in which the temperature is close to upper and lower temperature scales according to a design temperature of a valve; and determining left and right column numbers according to a design pressure of the valve, and obtaining upper, lower, left and right corner values of an interval in which the design temperature and pressure of the valve are located; and 3) calculating upper and lower linear values of the design temperature and a linear ratio of the design pressure according to the four corner values, then calculating a nominal class interpolation value, and selecting the valve corresponding to a nominal class. According to the method, during valve selection of power generation plants, the problems of dull, complex and tedious calculation process, large workload, low efficiency and high error rate are avoided, the manual calculation workload can be greatly reduced, and the quickness and accuracy of model selection are improved.

Description

technical field [0001] The invention relates to a valve selection method, in particular to a two-dimensional data linear query / selection valve method based on an EXCEL internal function, which is suitable for querying and selecting valve types in electric power plants. It belongs to the technical field of electric equipment. Background technique [0002] At present, for the calculation of valve model selection, especially for the selection of valves in electric power plants, it is necessary to consult different standards, such as DL, ASME, API, NB, etc., to calculate the specific pound class or nominal pressure level, generally four intermediate interpolations are required Calculate to select a valve that meets the design requirements. This calculation and selection method in the prior art has problems such as boring, complicated and cumbersome calculation process, error-prone, heavy calculation workload, high difficulty and low efficiency. In addition, in the bidding proc...

AI Technical Summary

Problems solved by technology

[0003] The purpose of the present invention is to provide a two-dimensional data linearization method based on EXCEL internal functions in order to solve the technical problems such as boring, complex and tedious, heavy workload, low efficiency and error-prone calculation process of the valve selection and storage in the prior art electric power plant. Query / Select Valve Method

Images