CN113204586A - Transformer electromagnetic calculation method, system, medium and equipment based on Excel report - Google Patents
Transformer electromagnetic calculation method, system, medium and equipment based on Excel report Download PDFInfo
- Publication number
- CN113204586A CN113204586A CN202110472528.9A CN202110472528A CN113204586A CN 113204586 A CN113204586 A CN 113204586A CN 202110472528 A CN202110472528 A CN 202110472528A CN 113204586 A CN113204586 A CN 113204586A
- Authority
- CN
- China
- Prior art keywords
- transformer
- calculation
- target value
- database
- excel
- 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.)
- Pending
Links
- 238000004364 calculation method Methods 0.000 title claims abstract description 115
- 238000012545 processing Methods 0.000 claims abstract description 17
- 238000013461 design Methods 0.000 claims abstract description 10
- 230000006870 function Effects 0.000 claims description 44
- 238000000034 method Methods 0.000 claims description 18
- XEEYBQQBJWHFJM-UHFFFAOYSA-N Iron Chemical group [Fe] XEEYBQQBJWHFJM-UHFFFAOYSA-N 0.000 claims description 10
- 239000003921 oil Substances 0.000 claims description 9
- 229910000976 Electrical steel Inorganic materials 0.000 claims description 5
- RYGMFSIKBFXOCR-UHFFFAOYSA-N Copper Chemical compound [Cu] RYGMFSIKBFXOCR-UHFFFAOYSA-N 0.000 claims description 4
- 229910000831 Steel Inorganic materials 0.000 claims description 4
- 239000010959 steel Substances 0.000 claims description 4
- 230000010354 integration Effects 0.000 abstract description 2
- 238000004590 computer program Methods 0.000 description 9
- 238000010586 diagram Methods 0.000 description 8
- 238000012423 maintenance Methods 0.000 description 3
- 238000004519 manufacturing process Methods 0.000 description 3
- 229910052802 copper Inorganic materials 0.000 description 2
- 239000010949 copper Substances 0.000 description 2
- 230000007547 defect Effects 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2458—Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
- G06F16/2462—Approximate or statistical queries
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/23—Updating
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- Databases & Information Systems (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- Probability & Statistics with Applications (AREA)
- Fuzzy Systems (AREA)
- Mathematical Physics (AREA)
- Software Systems (AREA)
- Computational Linguistics (AREA)
- Supply And Distribution Of Alternating Current (AREA)
Abstract
The invention discloses a transformer electromagnetic calculation method based on Excel reports, which is characterized in that data or parameters in a transformer design manual are subjected to electronic processing to obtain a database; writing an Excel report form by applying an Excel function, a control and a user-defined formula to a database according to a transformer electromagnetic calculation formula, and calculating to obtain a target value; comparing the calculated target value with a set threshold value, and if the target value meets the requirement, obtaining a transformer standard calculation list of the corresponding scheme; if the standard calculation list does not meet the requirements, adjusting parameters in the standard calculation list of the transformer, repeating until the standard calculation list meets the threshold requirements, and generating a plurality of schemes; and determining the weight of each part corresponding to each scheme according to the generated multiple schemes, calculating the cost of the transformer of different schemes according to the weight of each part, and selecting the scheme with the lowest cost as a final result to be output. The electromagnetic calculation method is based on the Excel calculation function, meets the electromagnetic calculation requirement of the transformer through data integration and processing, and does not need to purchase cost; the operation is simple.
Description
Technical Field
The invention belongs to the technical field of electric power, and particularly relates to a transformer electromagnetic calculation method, a transformer electromagnetic calculation system, a transformer electromagnetic calculation medium and transformer electromagnetic calculation equipment based on an Excel report.
Background
The electromagnetic calculation of the transformer comprises hundreds of calculation formulas, and ten thousand parameter values or constants in a calculation manual need to be inquired in an auxiliary mode during calculation. In summary, the workload of electromagnetic calculations is particularly enormous. Early on, computers were not common and these work were done by manual calculations, perhaps requiring tens of sheets of paper for the data. Once the target value is not consistent with the set threshold value, all calculations need to be manually calculated again, and the calculations are repeated until the target value is qualified. On one hand, the labor hour is consumed, and on the other hand, the manual calculation is easy to make mistakes.
At present, computers are popularized, electromagnetic calculation of transformers is mostly realized through large-scale software, but software purchase cost is high, complicated programming language compiling generation is included, purchase cost is low, and later maintenance cost and upgrading cost are high; meanwhile, if the functions of the local computing part need to be adjusted, the software needs to be operated by professional personnel, and the modification is poor.
Disclosure of Invention
The technical problem to be solved by the invention is to provide a transformer electromagnetic calculation method, system, medium and device based on Excel report forms aiming at the defects in the prior art, based on the Excel calculation function, through data integration and processing, the transformer electromagnetic calculation requirement is met, and the purchase cost is not needed; the operation is simple.
The invention adopts the following technical scheme:
a transformer electromagnetic calculation method based on an Excel report comprises the following steps:
s1, performing electronic processing on data or parameters in the transformer design manual to obtain a database;
s2, combining and calling the data of different databases by using an index function, a match function and a lookup function of the database obtained in the step S1 according to a transformer electromagnetic calculation formula, compiling an Excel report by using a control and a custom formula, and finally calculating to obtain a target value;
s3, comparing the target value obtained by calculation in the step S2 with a set threshold value, and if the target value meets the requirement, obtaining a transformer standard calculation list corresponding to the scheme; if the requirements are not met, adjusting parameters in the standard calculation list of the transformer, repeating the step S2 until the requirements of the threshold are met, and generating a plurality of schemes; and determining the weight of each part corresponding to each scheme according to the generated multiple schemes, calculating the cost of the transformer of different schemes according to the weight of each part, and selecting the scheme with the lowest cost as a final result to be output.
Specifically, in step S1, the database includes iron core cross-sectional data, a silicon steel sheet parameter table, a wire gauge size and additional loss parameter table, and the iron core cross-sectional data, the silicon steel sheet parameter table and the additional loss parameter table are stored in a table form; the area of the cross section of the wire is realized by a self-defined formula.
Further, the self-defined formula of the section area of the wire is defined as: subtracting the area of the round part of the wire from the product of the width and the thickness of the wire; and calling an if function to participate in calculation so as to adjust the area deviation caused by the corresponding different fillets of the wires with different specifications.
Specifically, in step S2, the index function searches for values in the cross cells of a certain row and a certain column for selecting a parameter value specified in the database; the match function searches a specific item in the range cell, and then returns the relative position of the corresponding item in the area for returning the position of the database parameter value; looking up one row or one column and looking up the value of the same position in the other row or the other column for looking up different iron core sections corresponding to different iron core diameters; rounding the data with a round function to determine data valid bits; when the length and width numerical values of the wire gauge are called, the method is realized through an Excel pull-down list control; and finally, participating in addition, subtraction, multiplication, division and power mixed calculation through mutual reference of the cells to finally obtain the target value.
Further, the target values include no-load loss, impedance voltage, coil temperature rise, and oil top layer temperature rise.
Specifically, in step S3, the target value includes a threshold value set by the no-load loss, the impedance voltage, the coil temperature rise and the oil top layer temperature rise, and is judged by an if judgment statement, and if the target value is smaller than the threshold value, the target value is qualified; if the target value is larger than the threshold value, the target value is unqualified.
Specifically, in step S3, the weight of each component includes the weight of copper wire, the weight of insulating oil, and the weight of steel.
Another technical solution of the present invention is a transformer electromagnetic calculation method system based on Excel report, including:
the database module is used for performing electronic processing on data or parameters in the transformer design manual to obtain a database;
the calculation module is used for performing combined calling on data of different databases by applying an index function, a match function and a lookup function to the database module according to the electromagnetic calculation formula of the transformer, compiling an Excel report by using a control and a custom formula, and finally calculating to obtain a target value;
the output module compares the target value calculated by the calculation module with a set threshold value, and if the target value meets the requirement, a transformer standard calculation list corresponding to the scheme is obtained; if the standard calculation list does not meet the requirements, adjusting parameters in the standard calculation list of the transformer, and repeatedly calculating by the calculation module until the standard calculation list meets the threshold requirements to generate a plurality of schemes; and determining the weight of each part corresponding to each scheme according to the generated multiple schemes, calculating the cost of the transformer of different schemes according to the weight of each part, and selecting the scheme with the lowest cost as a final result to be output.
Another technical solution of the present invention is a computer-readable storage medium storing one or more programs, the one or more programs including instructions, which when executed by a computing device, cause the computing device to execute a transformer electromagnetic calculation method based on an Excel report.
Another technical solution of the present invention is a computing device, including:
one or more processors, a memory, and one or more programs, wherein the one or more programs are stored in the memory and configured for execution by the one or more processors, the one or more programs comprising instructions for performing an Excel report-based transformer electromagnetic calculation method.
Compared with the prior art, the invention has at least the following beneficial effects:
the electromagnetic calculation method of the transformer based on the Excel report table solves the problems of complexity of manual calculation, improves calculation accuracy and overcomes the defects of high cost and inconvenience in maintenance of large-scale software. According to the invention, a large number of transformer calculation formulas are integrated in an Excel report, and are organically linked through cell calling, so that an electromagnetic calculation sheet conforming to the habit of the transformer industry is finally generated, complete parameters required by drawing of subsequent engineering drawings are clearly presented, and drawing of transformer drawings is facilitated; by increasing the cost calculation of the transformer, the optimal calculation list is selected favorably, and the manufacturing cost is optimized; the method can also be used as a tool for bidding of the transformer, and the cost price can be accurately given.
Furthermore, the setting of the database in the step S1 is convenient for an operator to update the database, and the update can be realized only by modifying the Excel cell value; in addition, the database is established, so that a complicated procedure for consulting the transformer manual is avoided, and the reliability of consulting the data is improved.
Furthermore, the setting of the self-defined formula of the cross-sectional area of the lead is convenient for calculating the current density and the resistance of the lead, and the process of looking up a manual is omitted.
Furthermore, in step S2, index, match, and lookup functions are set, so that the iron core section parameters are called one-to-one, and the wire section parameters are called two-to-one; and the drop-down list control is arranged to realize the clicking of the wire gauge size, so that errors caused by data input are avoided.
Further, a target value and a threshold value are set, and the difference value comparison is used as a judgment basis for judging whether the electromagnetic calculation sheet of the Excel report terminates the operation or is qualified.
Further, the final electromagnetic calculation sheet is confirmed according to step S3. The weight of copper wires, the weight of insulating oil and the weight of steel in different schemes are utilized, the cost of the transformer in different schemes can be calculated, the scheme with the lowest cost is selected as the final output, and an Excel report form of the scheme is determined to be a universal electromagnetic calculation single standard format in the transformer industry.
In summary, the present invention solves many disadvantages of similar professional software: the purchase and later maintenance costs are high, the operation and popularization of a specially-assigned person are difficult, and the software can be modified poorly. The invention can realize the electromagnetic calculation report function of the transformer only by installing Excel software on a computer, and has no other cost; the method can be used by people familiar with simple Excel operation; the database is simple to update, and only the cell data needs to be replaced; the function can be conveniently adjusted according to the data requirement; meanwhile, the invention is easy to copy and exchange and is not limited by the grade requirement of the computer.
The technical solution of the present invention is further described in detail by the accompanying drawings and embodiments.
Drawings
FIG. 1 is a flow chart of the present invention.
Detailed Description
The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are some, not all, embodiments of the present invention. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
It will be understood that the terms "comprises" and/or "comprising," when used in this specification and the appended claims, specify the presence of stated features, integers, steps, operations, elements, and/or components, but do not preclude the presence or addition of one or more other features, integers, steps, operations, elements, components, and/or groups thereof.
It is also to be understood that the terminology used in the description of the invention herein is for the purpose of describing particular embodiments only and is not intended to be limiting of the invention. As used in the specification of the present invention and the appended claims, the singular forms "a," "an," and "the" are intended to include the plural forms as well, unless the context clearly indicates otherwise.
It should be further understood that the term "and/or" as used in this specification and the appended claims refers to and includes any and all possible combinations of one or more of the associated listed items.
Various structural schematics according to the disclosed embodiments of the invention are shown in the drawings. The figures are not drawn to scale, wherein certain details are exaggerated and possibly omitted for clarity of presentation. The shapes of various regions, layers and their relative sizes and positional relationships shown in the drawings are merely exemplary, and deviations may occur in practice due to manufacturing tolerances or technical limitations, and a person skilled in the art may additionally design regions/layers having different shapes, sizes, relative positions, according to actual needs.
Referring to fig. 1, the invention relates to a transformer electromagnetic calculation method based on an Excel report, which comprises the following steps:
s1, performing electronic processing on data or parameters in the transformer design manual to obtain a database;
all parameter tables required by electromagnetic calculation of the transformer comprise iron core section data, a silicon steel sheet parameter table, a wire gauge size and additional loss parameter table, all the parameter tables are stored in different cells of Excel, the cells are convenient to call, and the parameter tables are stored in fixed cells as data stocks after being processed electronically; the area of the section of the wire is realized by a self-defined formula without looking up a table.
The self-defined formula of the section area of the wire is defined as: subtracting the area of the round part of the wire from the product of the width and the thickness of the wire; and calling an if function to participate in calculation so as to adjust the area deviation caused by the corresponding different fillets of the wires with different specifications.
S2, according to the electromagnetic calculation formula of the transformer, applying Excel functions, controls and custom formulas to the database obtained in the step S1, and obtaining a target value through automatic calculation;
the target values include no-load loss, impedance voltage, coil temperature rise, and oil top layer temperature rise.
The Excel report automatic calculation core part comprises: the computing unit selects index, match, lookup and round functions suitable for data calling and processing; the index function searches values in the cross cells of a certain row and a certain column for selecting the designated parameter values in the database; the match function searches for a particular item in the range cell and then returns the relative location of the item in this region for returning the location of the database parameter value for the index function to call for the value; looking up one row or one column and looking up the value of the same position in the other row or the other column for looking up different iron core sections corresponding to different iron core diameters; the round function rounds the data to determine the data valid bit.
For convenient operation, an Excel control is built in; the control mainly uses a drop-down list control, for example, when the length and width numerical values of the wire gauge are called, the control is realized through the Excel drop-down list control, and invalid wire specifications are prevented from being input.
Meanwhile, formulas with different functions are customized according to needs, functions are called through Excel cells, electromagnetic calculation formulas of the transformer are connected in series, and calculation of the target value is achieved.
When the area of the section of the wire is calculated, a formula is customized: subtracting the area of the round part of the wire from the product of the width and the thickness of the wire; and for different lead fillets with different sizes, the area deviation caused by the lead with different specifications corresponding to different fillets is adjusted by calling the if function to participate in calculation. The area of the conducting wires with different specifications can be calculated by only clicking the width and the thickness.
The automatic calculation is that the Excel cells are associated through an electromagnetic calculation formula after being called, and the calculation is automatically participated in.
S3, comparing the target value obtained by calculation in the step S2 with a set threshold value, taking an Excel report meeting the requirements as a scheme of a standard calculation sheet of the transformer, and obtaining the cost of the transformer under the scheme according to the obtained weight of each part; by adjusting the key parameters, the cost of the transformer under different schemes can be obtained, and finally, a scheme report with the lowest cost is selected to output a calculation single standard format which is universal in the transformer industry.
Setting a threshold value, judging by using an if judgment statement, and prompting the unit cell to be green if the target value is smaller than the threshold value so as to show that the target value is qualified; if the value is larger than the threshold value, the alarm is 'red' to indicate that the target value is unqualified.
The weight of each part comprises the weight of copper wires, the weight of insulating oil and the weight of steel.
S4, if not, returning to the step S2.
In another embodiment of the present invention, an electromagnetic calculation system for a transformer based on an Excel report is provided, where the system can be used to implement the electromagnetic calculation method for a transformer based on an Excel report, and specifically, the electromagnetic calculation system for a transformer based on an Excel report includes a database module, a calculation module, and an output module.
The database module is used for performing electronic processing on data or parameters in a transformer design manual to obtain a database;
the calculation module is used for compiling an Excel report form by applying Excel functions, controls and custom formulas to the database module according to the electromagnetic calculation formula of the transformer, and finally calculating to obtain a target value;
the output module compares the target value calculated by the calculation module with a set threshold value, and if the target value meets the requirement, a transformer standard calculation list corresponding to the scheme is obtained; if the standard calculation list does not meet the requirements, adjusting parameters in the standard calculation list of the transformer, and repeatedly calculating by the calculation module until the standard calculation list meets the threshold requirements to generate a plurality of schemes; and determining the weight of each part corresponding to each scheme according to the generated multiple schemes, calculating the cost of the transformer of different schemes according to the weight of each part, and selecting the scheme with the lowest cost as a final result to be output.
In yet another embodiment of the present invention, a terminal device is provided that includes a processor and a memory for storing a computer program comprising program instructions, the processor being configured to execute the program instructions stored by the computer storage medium. The Processor may be a Central Processing Unit (CPU), or may be other general purpose Processor, a Digital Signal Processor (DSP), an Application Specific Integrated Circuit (ASIC), an off-the-shelf Programmable gate array (FPGA) or other Programmable logic device, a discrete gate or transistor logic device, a discrete hardware component, etc., which is a computing core and a control core of the terminal, and is adapted to implement one or more instructions, and is specifically adapted to load and execute one or more instructions to implement a corresponding method flow or a corresponding function; the processor provided by the embodiment of the invention can be used for the operation of electromagnetic calculation of the transformer based on the Excel report, and comprises the following steps:
performing electronic processing on data or parameters in a transformer design manual to obtain a database; writing an Excel report form by applying an Excel function, a control and a user-defined formula to a database according to a transformer electromagnetic calculation formula, and finally calculating to obtain a target value; comparing the calculated target value with a set threshold value, and if the target value meets the requirement, obtaining a transformer standard calculation list of the corresponding scheme; if the standard calculation list does not meet the requirements, adjusting parameters in the standard calculation list of the transformer, repeating until the standard calculation list meets the threshold requirements, and generating a plurality of schemes; and determining the weight of each part corresponding to each scheme according to the generated multiple schemes, calculating the cost of the transformer of different schemes according to the weight of each part, and selecting the scheme with the lowest cost as a final result to be output.
In still another embodiment of the present invention, the present invention further provides a storage medium, specifically a computer-readable storage medium (Memory), which is a Memory device in a terminal device and is used for storing programs and data. It is understood that the computer readable storage medium herein may include a built-in storage medium in the terminal device, and may also include an extended storage medium supported by the terminal device. The computer-readable storage medium provides a storage space storing an operating system of the terminal. Also, one or more instructions, which may be one or more computer programs (including program code), are stored in the memory space and are adapted to be loaded and executed by the processor. It should be noted that the computer-readable storage medium may be a high-speed RAM memory, or may be a non-volatile memory (non-volatile memory), such as at least one disk memory.
The processor can load and execute one or more instructions stored in the computer readable storage medium to realize corresponding steps of electromagnetic calculation of the transformer based on the Excel report in the embodiment; one or more instructions in the computer-readable storage medium are loaded by the processor and perform the steps of:
performing electronic processing on data or parameters in a transformer design manual to obtain a database; writing an Excel report form by applying an Excel function, a control and a user-defined formula to a database according to a transformer electromagnetic calculation formula, and calculating to obtain a target value; comparing the calculated target value with a set threshold value, and if the target value meets the requirement, obtaining a transformer standard calculation list of the corresponding scheme; if the standard calculation list does not meet the requirements, adjusting parameters in the standard calculation list of the transformer, repeating until the standard calculation list meets the threshold requirements, and generating a plurality of schemes; and determining the weight of each part corresponding to each scheme according to the generated multiple schemes, calculating the cost of the transformer of different schemes according to the weight of each part, and selecting the scheme with the lowest cost as a final result to be output.
The invention is based on the Excel report function, can conveniently realize the electromagnetic calculation of the transformer by operating the cell data, and simultaneously outputs the electromagnetic calculation sheet of the transformer which meets the industry regulation.
In conclusion, the electromagnetic calculation method for the transformer based on the Excel report is simple and easy to operate, and the program is easy to modify; no cost is increased; the output interface completely meets the habit requirements of the transformer industry, is convenient to read and exchange, is suitable for transformer designers to use, is also suitable for reference learning of related industry personnel, and has strong practicability and wide application range.
As will be appreciated by one skilled in the art, embodiments of the present application may be provided as a method, system, or computer program product. Accordingly, the present application may take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects. Furthermore, the present application may take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, and the like) having computer-usable program code embodied therein.
The present application is described with reference to flowchart illustrations and/or block diagrams of methods, apparatus (systems), and computer program products according to embodiments of the application. It will be understood that each flow and/or block of the flow diagrams and/or block diagrams, and combinations of flows and/or blocks in the flow diagrams and/or block diagrams, can be implemented by computer program instructions. These computer program instructions may be provided to a processor of a general purpose computer, special purpose computer, embedded processor, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, create means for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be stored in a computer-readable memory that can direct a computer or other programmable data processing apparatus to function in a particular manner, such that the instructions stored in the computer-readable memory produce an article of manufacture including instruction means which implement the function specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be loaded onto a computer or other programmable data processing apparatus to cause a series of operational steps to be performed on the computer or other programmable apparatus to produce a computer implemented process such that the instructions which execute on the computer or other programmable apparatus provide steps for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
The above-mentioned contents are only for illustrating the technical idea of the present invention, and the protection scope of the present invention is not limited thereby, and any modification made on the basis of the technical idea of the present invention falls within the protection scope of the claims of the present invention.
Claims (10)
1. The electromagnetic calculation method of the transformer based on the Excel report is characterized by comprising the following steps of:
s1, performing electronic processing on data or parameters in the transformer design manual to obtain a database;
s2, combining and calling the data of different databases by using an index function, a match function and a lookup function of the database obtained in the step S1 according to a transformer electromagnetic calculation formula, compiling an Excel report by using a control and a custom formula, and finally calculating to obtain a target value;
s3, comparing the target value obtained by calculation in the step S2 with a set threshold value, and if the target value meets the requirement, obtaining a transformer standard calculation list corresponding to the scheme; if the requirements are not met, adjusting parameters in the standard calculation list of the transformer, repeating the step S2 until the requirements of the threshold are met, and generating a plurality of schemes; and determining the weight of each part corresponding to each scheme according to the generated multiple schemes, calculating the cost of the transformer of different schemes according to the weight of each part, and selecting the scheme with the lowest cost as a final result to be output.
2. The method of claim 1, wherein in step S1, the database comprises core section data, silicon steel sheet parameter table, wire gauge dimension and additional loss parameter table, the core section data, the silicon steel sheet parameter table and the additional loss parameter table are stored in table form; the area of the cross section of the wire is realized by a self-defined formula.
3. The method of claim 2, wherein the wire cross-sectional area custom formula is defined as: subtracting the area of the round part of the wire from the product of the width and the thickness of the wire; and calling an if function to participate in calculation so as to adjust the area deviation caused by the corresponding different fillets of the wires with different specifications.
4. The method according to claim 1, wherein in step S2, the index function finds values in the cross cells of a certain row and a certain column for selecting the parameter values specified in the database; the match function searches a specific item in the range cell, and then returns the relative position of the corresponding item in the area for returning the position of the database parameter value; looking up one row or one column and looking up the value of the same position in the other row or the other column for looking up different iron core sections corresponding to different iron core diameters; rounding the data with a round function to determine data valid bits; when the length and width numerical values of the wire gauge are called, the method is realized through an Excel pull-down list control; and finally, participating in addition, subtraction, multiplication, division and power mixed calculation through mutual reference of the cells to finally obtain the target value.
5. The method of claim 4, wherein the target values include no-load loss, impedance voltage, coil temperature rise, and oil top layer temperature rise.
6. The method according to claim 1, wherein in step S3, the target values include idle load loss, impedance voltage, coil temperature rise and oil top layer temperature rise setting threshold values, and if the target value is smaller than the threshold value, the target value is qualified; if the target value is larger than the threshold value, the target value is unqualified.
7. The method of claim 1, wherein in step S3, the component weights include a copper wire weight, an insulating oil weight, and a steel weight.
8. A system for electromagnetic calculation of a transformer based on an Excel report is characterized by comprising the following steps:
the database module is used for performing electronic processing on data or parameters in the transformer design manual to obtain a database;
the calculation module is used for performing combined calling on data of different databases by applying an index function, a match function and a lookup function to the database module according to the electromagnetic calculation formula of the transformer, compiling an Excel report by using a control and a custom formula, and finally calculating to obtain a target value;
the output module compares the target value calculated by the calculation module with a set threshold value, and if the target value meets the requirement, a transformer standard calculation list corresponding to the scheme is obtained; if the standard calculation list does not meet the requirements, adjusting parameters in the standard calculation list of the transformer, and repeatedly calculating by the calculation module until the standard calculation list meets the threshold requirements to generate a plurality of schemes; and determining the weight of each part corresponding to each scheme according to the generated multiple schemes, calculating the cost of the transformer of different schemes according to the weight of each part, and selecting the scheme with the lowest cost as a final result to be output.
9. A computer readable storage medium storing one or more programs, the one or more programs comprising instructions, which when executed by a computing device, cause the computing device to perform any of the methods of claims 1-7.
10. A computing device, comprising:
one or more processors, memory, and one or more programs stored in the memory and configured for execution by the one or more processors, the one or more programs including instructions for performing any of the methods of claims 1-7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110472528.9A CN113204586A (en) | 2021-04-29 | 2021-04-29 | Transformer electromagnetic calculation method, system, medium and equipment based on Excel report |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110472528.9A CN113204586A (en) | 2021-04-29 | 2021-04-29 | Transformer electromagnetic calculation method, system, medium and equipment based on Excel report |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN113204586A true CN113204586A (en) | 2021-08-03 |
Family
ID=77027796
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110472528.9A Pending CN113204586A (en) | 2021-04-29 | 2021-04-29 | Transformer electromagnetic calculation method, system, medium and equipment based on Excel report |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113204586A (en) |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2012155494A1 (en) * | 2011-05-16 | 2012-11-22 | 河北省电力研究院 | Verifying method of optimal control parameter in whole network for automatic voltage control system |
| CN104239651A (en) * | 2014-10-11 | 2014-12-24 | 福建省闽西天龙变压器有限公司 | Method applied to structural design of power transformer and material utilization amount statistics |
| CN104779047A (en) * | 2015-03-26 | 2015-07-15 | 浙江永固输配电设备有限公司 | Electromagnetic design method of amorphous alloy transformer |
| CN105956332A (en) * | 2016-05-31 | 2016-09-21 | 河北工业大学 | Expert system based transformer electromagnetic optimization design method |
| CN109446494A (en) * | 2018-10-19 | 2019-03-08 | 国电南瑞科技股份有限公司 | A kind of water utilities calculation method based on Report Engine |
-
2021
- 2021-04-29 CN CN202110472528.9A patent/CN113204586A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2012155494A1 (en) * | 2011-05-16 | 2012-11-22 | 河北省电力研究院 | Verifying method of optimal control parameter in whole network for automatic voltage control system |
| CN104239651A (en) * | 2014-10-11 | 2014-12-24 | 福建省闽西天龙变压器有限公司 | Method applied to structural design of power transformer and material utilization amount statistics |
| CN104779047A (en) * | 2015-03-26 | 2015-07-15 | 浙江永固输配电设备有限公司 | Electromagnetic design method of amorphous alloy transformer |
| CN105956332A (en) * | 2016-05-31 | 2016-09-21 | 河北工业大学 | Expert system based transformer electromagnetic optimization design method |
| CN109446494A (en) * | 2018-10-19 | 2019-03-08 | 国电南瑞科技股份有限公司 | A kind of water utilities calculation method based on Report Engine |
Non-Patent Citations (1)
| Title |
|---|
| 张栋: "《Word/Excel/PPT从入门到精通》", 北京：中国青年出版社, pages: 263 - 266 * |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| Cus et al. | Approach to optimization of cutting conditions by using artificial neural networks | |
| Maniya et al. | A selection of material using a novel type decision-making method: Preference selection index method | |
| CN109766586B (en) | Method and system for automatically generating electromagnetic transient simulation model of large-scale power grid | |
| EP0811941A2 (en) | A capability predictor | |
| CN106875094A (en) | A kind of multiple target Job-Shop method based on polychromatic sets genetic algorithm | |
| US7870527B2 (en) | Method for stacked pattern design of printed circuit board and system thereof | |
| CN113657820B (en) | Production line batching method, device, equipment and readable storage medium | |
| CN104217063A (en) | Simulation design method for rolling hole patterns of steel rail | |
| Sahu et al. | A DEA approach for optimization of multiple responses in electrical discharge machining of AISI D2 steel | |
| CN109034676B (en) | Power distribution network fault recovery scheme interval evaluation method under incomplete index weight information | |
| Golshan et al. | Multi-objective optimisation of electrical discharge machining of metal matrix composite Al/SiC using non-dominated sorting genetic algorithm | |
| CN112053037B (en) | Flexible PCB workshop scheduling optimization method and system | |
| Sukthomya et al. | Taguchi experimental design for manufacturing process optimisation using historical data and a neural network process model | |
| CN105956332B (en) | transformer electromagnetic optimization design method based on expert system | |
| CN113204586A (en) | Transformer electromagnetic calculation method, system, medium and equipment based on Excel report | |
| CN102254076B (en) | Tool for analyzing manufacturability of three-dimensional model design | |
| CN101221586A (en) | Power electronic circuit optimization method based on decoupling technology and genetic algorithm | |
| JP4319007B2 (en) | Development period shortening support method | |
| CN111709634A (en) | Method, device, equipment and medium for generating operation risk prompt list | |
| CN113890043B (en) | Phase-shifting transformer site selection method, system and medium based on multi-condition constraint | |
| CN113867275B (en) | Optimization method for preventive maintenance joint scheduling of distributed workshop | |
| CN112257347B (en) | Simulation system of power transformation equipment | |
| CN102831279B (en) | Automatic calculation system and method of electroplating technological parameters of diamond products based on CAD (computer-aided design) | |
| CN115663930B (en) | Method for building power supply system of transformer substation, computer equipment and readable storage medium | |
| CN112949249B (en) | Method, system and device for determining element placement position |
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 | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20210803 |