CN113312683A - Method for calculating size of aluminum-clad invar steel processing mold by combining EXCEL - Google Patents

Method for calculating size of aluminum-clad invar steel processing mold by combining EXCEL Download PDF

Info

Publication number
CN113312683A
CN113312683A CN202110550019.3A CN202110550019A CN113312683A CN 113312683 A CN113312683 A CN 113312683A CN 202110550019 A CN202110550019 A CN 202110550019A CN 113312683 A CN113312683 A CN 113312683A
Authority
CN
China
Prior art keywords
diameter
cladding
excel
aluminum
invar steel
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
Application number
CN202110550019.3A
Other languages
Chinese (zh)
Inventor
高瞻
黄卫星
张凯云
袁苑珠
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Changzhou Tefa Huayin Wire & Cable Co ltd
Original Assignee
Changzhou Tefa Huayin Wire & Cable Co ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Changzhou Tefa Huayin Wire & Cable Co ltd filed Critical Changzhou Tefa Huayin Wire & Cable Co ltd
Priority to CN202110550019.3A priority Critical patent/CN113312683A/en
Publication of CN113312683A publication Critical patent/CN113312683A/en
Pending legal-status Critical Current

Links

Images

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F30/00—Computer-aided design [CAD]
    • G06F30/10—Geometric CAD
    • B—PERFORMING OPERATIONS; TRANSPORTING
    • B21—MECHANICAL METAL-WORKING WITHOUT ESSENTIALLY REMOVING MATERIAL; PUNCHING METAL
    • B21C—MANUFACTURE OF METAL SHEETS, WIRE, RODS, TUBES OR PROFILES, OTHERWISE THAN BY ROLLING; AUXILIARY OPERATIONS USED IN CONNECTION WITH METAL-WORKING WITHOUT ESSENTIALLY REMOVING MATERIAL
    • B21C1/00—Manufacture of metal sheets, metal wire, metal rods, metal tubes by drawing
    • B21C1/02—Drawing metal wire or like flexible metallic material by drawing machines or apparatus in which the drawing action is effected by drums
    • 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/242—Query formulation
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F30/00—Computer-aided design [CAD]
    • G06F30/20—Design optimisation, verification or simulation

Landscapes

  • Engineering & Computer Science (AREA)
  • Physics & Mathematics (AREA)
  • Theoretical Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Geometry (AREA)
  • General Engineering & Computer Science (AREA)
  • Computer Hardware Design (AREA)
  • Evolutionary Computation (AREA)
  • Mathematical Analysis (AREA)
  • Pure & Applied Mathematics (AREA)
  • Mathematical Optimization (AREA)
  • Computational Mathematics (AREA)
  • Mathematical Physics (AREA)
  • Computational Linguistics (AREA)
  • Data Mining & Analysis (AREA)
  • Databases & Information Systems (AREA)
  • Mechanical Engineering (AREA)
  • Metal Extraction Processes (AREA)

Abstract

The invention relates to the field of cables and wires, in particular to a method for calculating the size of an aluminum-clad invar steel processing mold by combining EXCEL. The method comprises the steps of establishing a name table of the aluminum-clad invar steel-clad wire drawing processing technology in the EXCEL, inputting a corresponding calculation formula, editing related formulas and requirements by using the EXCEL table to obtain an aluminum-clad invar steel single-wire processing technology table, combining the heating requirement and the cladding speed requirement of a hard steel wire to obtain the size of a cladding die and the size of a wire drawing die, and then processing the steel wire, so that the processing efficiency is improved.

Description

Method for calculating size of aluminum-clad invar steel processing mold by combining EXCEL
Technical Field
The invention relates to a dimension of an aluminum-wrapped invar steel processing mold, in particular to a method for calculating the dimension of the aluminum-wrapped invar steel processing mold by combining EXCEL.
Background
The method comprises the following steps of establishing a power transmission line, determining the section of a lead, and limiting the transmission capacity, along with the change of the operation mode of a system, increasing the transmission capacity of the established line more and more, and increasing the transmission capacity of the established line by two technical schemes:
firstly, removing an established line, and newly building a line using a large-section or multi-split conductor;
and secondly, the existing line iron tower is kept unchanged, and the existing lead is replaced by a heat-resistant lead.
The first method for dismantling the established line is very difficult to obtain the corridor protocol of the newly-built transmission line in the implementation process, and the investment is huge.
The second method is to maintain the established line, and replace the existing lead with a heat-resistant lead, so as to achieve the purpose of improving the transmission capacity, and thus, the application in the line modification engineering is more and more extensive.
The heat-resistant wire is an aluminum-coated invar-steel-core heat-resistant wire, the aluminum-coated invar-steel-core heat-resistant wire is made of two special materials, namely an aluminum-coated invar-steel core and a super heat-resistant aluminum alloy, so that the transmission capacity can be doubled or more under the conditions that the cross section of the wire is unchanged and the sag is not increased, the original line corridor can be fully utilized, and the tower does not need to be modified. A great deal of cost and time can be saved.
Invar steel: the iron-nickel alloy material has the greatest characteristics of low expansion coefficient and good plasticity in atmospheric temperature change, the thermal expansion coefficient is remarkably reduced near the magnetic temperature, namely the Curie point, and the abnormal thermal expansion phenomenon occurs, so that the small or even near-zero expansion coefficient can be obtained in a wide temperature range near the room temperature. The method is mainly used for manufacturing elements with nearly constant size in the temperature variation range.
At present, the continuous extrusion coating of invar steel mainly adopts a process of high-frequency heating or medium-high frequency mixed heating and then entering a coating host machine for coating.
At present, the requirements of the electric conductivity of the domestic aluminum-coated invar single line are two series of 10% electric conductivity and 14% electric conductivity, so that how to ensure that the electric conductivity meets the requirements of the standard and simultaneously the requirements of various parameters in the standard including the minimum aluminum layer thickness and the average aluminum layer thickness are also met. This requires precise dimensioning for the configuration of the overmolding.
Disclosure of Invention
The invention aims to solve the defects and provides a method for calculating the size of an aluminum-clad invar steel processing die by combining EXCEL.
In order to overcome the defects in the background art, the technical scheme adopted by the invention for solving the technical problems is as follows: the method for calculating the size of the mould for processing the aluminum-clad invar steel by combining the EXCEL comprises the following steps of sequentially carrying out aluminum cladding on an invar steel wire by using a cladding mould in the processing of the aluminum-clad invar steel, drawing a cladded cladding rod by using each wire drawing mould, controlling the compression ratio of each pass of drawing to be between 16 and 18 percent and controlling the total compression ratio to be between 70 and 85 percent, wherein the method comprises the following steps of:
firstly, establishing a name table of an aluminum-clad invar steel cladding wire drawing processing technology in an EXCEL table, wherein the name table comprises the names of the diameter a of an invar steel wire, the conductivity of the invar steel wire, the conductivity of an aluminum rod, the calculated value of the diameter of a 10% conductivity cladding die, the value, the required conductivity of a product, the name code, D = the cladding diameter, D = the finished product diameter, the number of wire drawing passes, the total compression ratio =, the ratio mu =ofeach diameter, the drawing pass, the size of each die and the estimated diameter of an invar steel core;
secondly, editing a calculation formula of the diameter of the coating die in the EXCEL, wherein the calculation formula comprises the following steps:
（61%×S2+2%×S1) S = product required conductivity;
S1is the area of invar wire, S1=π×（a）2/4；
S2Is the area of aluminum, S2=S- S1；
S is the area of the cladding rod, S = π × D2/4；
The diameter of the coating die is taken as = D + 0.06;
thirdly, editing a calculation formula of the dimension of each wire drawing die in the EXCEL, wherein the calculation formula comprises the following steps:
Sn=（（Sn-1）2×μ）1/2
in the formula:
when n is 1, Sn-1The value of (D) is the coating diameter D calculated in the second step of the step;
μ = 1-compression ratio;
and fourthly, inputting the diameter value of the invar steel wire, the required conductivity value of the product, the diameter value of the finished product and the compression ratio value into the EXCEL to obtain the diameter of the cladding die and the size of each wire drawing die.
According to another embodiment of the present invention, the method further comprises controlling the wire drawing speed to be below 2.5m/S in the step S2.
The invention has the beneficial effects that: the method for calculating the size of the aluminum-clad invar steel processing die by combining the EXCEL is characterized in that the heating requirement and the cladding speed requirement of the hard steel wire are combined after the size of the cladding die and the size of the wire drawing die are obtained. And (5) drawing speed requirement. And editing related formulas and requirements by using an EXCEL table to obtain an aluminum-coated invar single-line processing process table.
Drawings
The invention is further illustrated with reference to the following figures and examples.
FIG. 1 is a schematic structural diagram of unfilled values in an embodiment of the present invention;
FIG. 2 is a diagram illustrating a structure filled with values according to an embodiment of the present invention.
Detailed Description
In order to make the objects, technical solutions and advantages of the embodiments of the present invention clearer, the technical solutions 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, but 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.
The method for calculating the size of the mould for processing the aluminum-clad invar steel by combining the EXCEL comprises the following steps of sequentially carrying out aluminum cladding on an invar steel wire by using a cladding mould in the processing of the aluminum-clad invar steel, drawing a cladded cladding rod by using each wire drawing mould, controlling the total compression ratio to be between 70 and 85 percent, controlling the compression ratio of each drawing pass to be between 16 and 18 percent, and controlling the wire drawing speed to be below 2.5m/s, wherein the method comprises the following steps of:
firstly, establishing a name table of an aluminum-clad invar steel cladding wire drawing processing technology in an EXCEL, wherein the name table comprises the name of the diameter a of an invar steel wire, the conductivity of the invar steel wire, the conductivity of an aluminum rod, the calculated value of the diameter of a 10% conductivity cladding die, the value, the required conductivity of a product, the name code, D = the cladding diameter, D = the finished product diameter, the number of wire drawing passes, the total compression ratio =, the diameter ratio μ =perpass, the drawing pass, the size of each die and the estimated diameter of an invar steel core;
secondly, editing a calculation formula of the diameter of the coating die in the EXCEL, wherein the calculation formula comprises the following steps:
（61%×S2+2%×S1) S = product required conductivity;
S1is the area of invar wire, S1=π×（a）2/4；
S2Is the area of aluminum, S2=S- S1；
S is the area of the cladding rod, S = π × D2/4；
The diameter of the coating die is taken as = D + 0.06;
thirdly, editing a calculation formula of the dimension of each wire drawing die in the EXCEL, wherein the calculation formula comprises the following steps:
Sn=（（Sn-1）2×μ）1/2
in the formula:
when n is 1, Sn-1The value of (D) is the coating diameter D calculated in the second step of the step;
μ = 1-compression ratio;
and fourthly, inputting the diameter value of the invar steel wire, the required conductivity value of the product, the diameter value of the finished product and the compression ratio value into the EXCEL to obtain the diameter of the cladding die and the size of each wire drawing die.
Examples
Firstly, establishing a table shown in the figure 1 in the EXCEL, wherein the table comprises an invar wire diameter a, an invar wire conductivity, an aluminum rod conductivity, a 10% conductivity cladding die diameter calculated value, a product required conductivity, a name code, D = cladding diameter, D = finished product diameter, the number of drawing channels, a total compression ratio =, a diameter ratio μ =perchannel, drawing passes, a size of each die and a name of an invar core estimated diameter, and corresponds to a corresponding position in the figure 1;
secondly, editing a calculation formula of the diameter of the coating die in EXCEL, wherein the calculation value of the diameter of the 10% conductivity coating die is shown in figure 1;
thirdly, editing a calculation formula of the dimension of each wire drawing die in the EXCEL, wherein S needs to be noted when n is 1n-1The value of (D) is the coating diameter D calculated in the second step of the step;
and fourthly, inputting a diameter value of the invar steel wire, a required conductivity value of the product, a diameter value of a finished product and a compressibility value in the EXCEL, inputting a diameter d of the finished product to be completed in a table according to the conductivity of 2% of the domestic invar steel wire, the conductivity of 61% of the aluminum rod required for coating according to the standard, the conductivity of the finished product determined by the difference between the cross section area of the invar steel and the area of the aluminum layer, the diameter a of the invar steel wire is 5.5mm, the required conductivity of the product is 10%, the conductivity of the invar steel wire is 2%, the conductivity of the aluminum rod is 61%, the diameter d of the finished product is 3.2mm, and the number of wire drawing tracks is 7, so that the size of each mould can be obtained, as shown in figure 2, the mould can be processed after the size is obtained, and the processing efficiency is improved.
The above description is only for the preferred embodiment of the present invention, but the scope of the present invention is not limited thereto, and any person skilled in the art should be considered to be within the technical scope of the present invention, and the technical solutions and the inventive concepts thereof according to the present invention should be equivalent or changed within the scope of the present invention.

Claims (2)

1. The utility model provides a method for combine EXCEL to calculate aluminium package invar steel mold processing size, aluminium package invar steel processing loops through the cladding mould and carries out the aluminium cladding to the invar steel wire rod, draws through each way wire drawing mould to the cladding pole that the cladding was accomplished, and the compression ratio of drawing each pass is controlled between 16% -18%, and total compression ratio is controlled between 70% -85%, its characterized in that, the method comprises:
firstly, establishing a name table of an aluminum-clad invar steel cladding wire drawing processing technology in an EXCEL, wherein the name table comprises the name of the diameter a of an invar steel wire, the conductivity of the invar steel wire, the conductivity of an aluminum rod, the calculated value of the diameter of a 10% conductivity cladding die, the value, the required conductivity of a product, the name code, D = the cladding diameter, D = the finished product diameter, the number of wire drawing passes, the total compression ratio =, the diameter ratio μ =perpass, the drawing pass, the size of each die and the estimated diameter of an invar steel core;
secondly, editing a calculation formula of the diameter of the coating die in the EXCEL, wherein the calculation formula comprises the following steps:
（61%×S2+2%×S1) S = product required conductivity;
S1is the area of invar wire, S1=π×（a）2/4；
S2Is the area of aluminum, S2=S- S1；
S is the area of the cladding rod, S = π × D2/4；
The diameter of the coating die is taken as = D + 0.06;
thirdly, editing a calculation formula of the dimension of each wire drawing die in the EXCEL, wherein the calculation formula comprises the following steps:
Sn=（（Sn-1）2×μ）1/2
in the formula:
when n is 1, Sn-1The value of (D) is the coating diameter D calculated in the second step of the step;
μ = 1-compression ratio;
and fourthly, inputting the diameter value of the invar steel wire, the required conductivity value of the product, the diameter value of the finished product and the compression ratio value into the EXCEL to obtain the diameter of the cladding die and the size of each wire drawing die.
2. The method of calculating the dimensions of an aluminum-clad invar tooling mold in combination with EXCEL as in claim 1, wherein the draw speed is controlled to be below 2.5 m/s.
CN202110550019.3A 2021-05-20 2021-05-20 Method for calculating size of aluminum-clad invar steel processing mold by combining EXCEL Pending CN113312683A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202110550019.3A CN113312683A (en) 2021-05-20 2021-05-20 Method for calculating size of aluminum-clad invar steel processing mold by combining EXCEL

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202110550019.3A CN113312683A (en) 2021-05-20 2021-05-20 Method for calculating size of aluminum-clad invar steel processing mold by combining EXCEL

Publications (1)

Publication Number Publication Date
CN113312683A true CN113312683A (en) 2021-08-27

Family

ID=77373849

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202110550019.3A Pending CN113312683A (en) 2021-05-20 2021-05-20 Method for calculating size of aluminum-clad invar steel processing mold by combining EXCEL

Country Status (1)

Country Link
CN (1) CN113312683A (en)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN114722080A (en) * 2022-06-07 2022-07-08 江苏邦润智能科技有限公司 Wire drawing processing production early warning method and system of wire drawing machine

Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US6487470B1 (en) * 2000-07-18 2002-11-26 General Electric Company Method and apparatus for determining magnet wire production die sets
CN103473216A (en) * 2013-06-28 2013-12-25 湖南天雁机械有限责任公司 Excel-based product process planning method
CN108563903A (en) * 2018-04-28 2018-09-21 中国十九冶集团有限公司 Lofting method for wind power tower drum based on Excel table
CN111940536A (en) * 2020-07-24 2020-11-17 江苏亨通电力智网科技有限公司 Method for manufacturing aluminum-coated invar wire

Patent Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US6487470B1 (en) * 2000-07-18 2002-11-26 General Electric Company Method and apparatus for determining magnet wire production die sets
CN103473216A (en) * 2013-06-28 2013-12-25 湖南天雁机械有限责任公司 Excel-based product process planning method
CN108563903A (en) * 2018-04-28 2018-09-21 中国十九冶集团有限公司 Lofting method for wind power tower drum based on Excel table
CN111940536A (en) * 2020-07-24 2020-11-17 江苏亨通电力智网科技有限公司 Method for manufacturing aluminum-coated invar wire

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN114722080A (en) * 2022-06-07 2022-07-08 江苏邦润智能科技有限公司 Wire drawing processing production early warning method and system of wire drawing machine
CN114722080B (en) * 2022-06-07 2022-08-26 江苏邦润智能科技有限公司 Wire drawing processing production early warning method and system of wire drawing machine

Similar Documents

Publication Publication Date Title
CN101060025B (en) Manufacturing method of copper-clad aluminum busbar
CN100426630C (en) Method for twining VPI corona-prevention layer between stator coil main insulating layer and corona-prevention layer
CN109735826B (en) Graphene/copper composite material and preparation method and application thereof
CN106653154A (en) High-strength aluminum-clad steel wire and production method thereof
CN113312683A (en) Method for calculating size of aluminum-clad invar steel processing mold by combining EXCEL
CN111105901B (en) Improved bronze Nb method3Preparation method of Sn superconducting wire
CN102820101A (en) Long rectangular hollow conductor processing method
CN106128545A (en) Graphene core electric conductor and preparation method thereof
CN102527768A (en) Manufacturing method of copper-clad aluminum pipe
CN203288345U (en) A novel direct-current low-inductance square power cable
CN111940536A (en) Method for manufacturing aluminum-coated invar wire
CN104493425A (en) Cold drawing molding manufacturing process of copper-clad aluminum composite busbar
CN115216661A (en) Preparation method of aluminum alloy single wire
CN104022454A (en) Preparation method of Nb3Al superconducting wire rod
CN204424009U (en) A kind of press soft structure conductor press stranding device
CN202495860U (en) Nodeless wire embedding device of high-power motor stator random embedded winding
CN211319908U (en) Novel reactor for copper-clad aluminum wire
CN221861288U (en) Three-layer insulated wire with wear-resistant characteristic
CN213904953U (en) Super-high voltage resistant electric shock wire
CN208834755U (en) High-performance aluminium alloy core high conductivity aluminum stranded conductor
CN207128299U (en) A kind of wind-driven generator pulling press strip eccentric circular hole positioning tool
CN211578400U (en) Special type ABC air wire of high efficiency
CN112223887A (en) Automatic lamination insulation forming method for laminated amorphous alloy strip
CN209657864U (en) The highly conductive energy-saving conductor of low-tension
CN2524425Y (en) Foil winding magnetic control type motor soft starter

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
RJ01 Rejection of invention patent application after publication

Application publication date: 20210827