CN101937210A - Application of Excel function formula in feed preparation and baiting for circular splicing process - Google Patents
Application of Excel function formula in feed preparation and baiting for circular splicing process Download PDFInfo
- Publication number
- CN101937210A CN101937210A CN2010101649317A CN201010164931A CN101937210A CN 101937210 A CN101937210 A CN 101937210A CN 2010101649317 A CN2010101649317 A CN 2010101649317A CN 201010164931 A CN201010164931 A CN 201010164931A CN 101937210 A CN101937210 A CN 101937210A
- Authority
- CN
- China
- Prior art keywords
- formula
- feed
- baiting
- application
- blanking
- 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
Images
Abstract
The invention relates to application of an Excel function formula in feed preparation and baiting for a circular splicing process, which mainly comprises the following steps of: firstly, setting a predefined formula of an Excel function; secondly, determining the following three values of the whole feed material: outer diameter D, inner diameter d and the width B of the feed material, and calculating other parameter values based on the predefined formula and the three determined values; thirdly, inputting the calculated parameter values to a computer program of a numerical control machine to obtain the optimal discharge size; and finally, carrying out feed preparation and baiting for the circular splicing process on the whole feed material. By using the function formula program in an Excel, the feed material can be cut in accordance with individual differences, thereby reasonably using the excessive material. Similarly, the function formula program not only saves a large amount of time for the feed preparation and discharge operations in the charge of process designers and baiting numerical control programmers, but also realizes the graft onto the numerical control machine so as to complete an intermediate series of miscellaneous procedures by program processing, so that the required parameters can be immediately obtained and the baiting can be finished by simply inputting the three known values, thereby realizing that a common worker can also complete the work of designers and programmers.
Description
Technical field
The present invention relates to a kind of application process of work piece cut, specifically be the spreadsheet functions formula the splicing of ring circle get the raw materials ready and blanking in application.
Background technology
Electrical form software is very important a software in the office automation, has been known by everybody now and is extensive use of.And function is a most important components of spreadsheet data, and function is very powerful.And the function performance that uses electrical form at present only just rests on summation, simple function such as average is used, and electrical form has just been wasted one's talent on a petty job very much.Spreadsheet functions one has 11 classes, is respectively database functions, date and time function, engineering function, financial function, information function, logical function, inquiry and referencing function, mathematics and trigonometric function, statistical function, text function and User-Defined Functions.In the live and work practice, multiple application can be arranged, even can design complicated statistical management form or small-sized Database Systems with electrical form.
At this, we are example with the ring circle splicing discharge that often runs in technological design and the production, simply set forth the application of spreadsheet functions in technological design and production.To make φ 3700/ φ 4000 as us and be the Circular Plate of interior external diameter, sequence of operation according to technological design personnel and rivet welding numerical control blanking programming personnel is: utilize CAXA or CAD computer drawing software to draw out φ 3700/ φ 4000 concentric circless, determine splicing isodisperse and corresponding central angle according to the wide standard of various plates; Equal round ring that then will be is wherein determined after the suitable surplus size to be rotated, behind a series of editors such as shift copy, could finally to obtain best discharge size and calculate area (as shown in Figure 1).But the drawback of this method is: 1, the drawing time longer, the drawing link is many and make mistakes easily etc.; 2, conventional drawing calculating all is the series of parameters that draws under the wide situation of feed plate having stipulated, these parameters can not be suitable for along with wide the changing of feed plate, want to utilize the wide different stub bar of plate such as the scene, have to abandon original drawing calculating and begin the beguine, take time and effort.
Summary of the invention
Technical matters solved by the invention is to provide a kind of function performance that utilizes spreadsheet functions, simplifies the numerical value measuring and calculating, carries out that the splicing of cut ring circle is got the raw materials ready and the application process of blanking.
Technical matters solved by the invention realizes by the following technical solutions:
A kind of spreadsheet functions formula ring circle splicing get the raw materials ready and blanking in application, it is characterized in that: mainly may further comprise the steps, at first set the predefine formula of spreadsheet functions; Secondly determine three numerical value of monoblock feed, outer diameter D, inner diameter d, the wide B of feed plate, calculate remaining parameter values by predefine formula and three definite numerical value, secondly the parameter values that calculates is input in the computer program of numerically-controlled machine again, draw best discharge size, at last the monoblock feed is encircled the circle splicing and get the raw materials ready and blanking.
The predefine formula of described setting spreadsheet functions is worked out by the staff.
Described outer diameter D, inner diameter d, the wide B numerical value of feed plate can be by directly recording on the monoblock feed.
The present invention is the function that the predefine formula is converted to corresponding spreadsheet functions when using, only need some specific numerical value of input, and these specific numerical value just can obtain by direct measurement, after in the spreadsheet functions that the numerical value input that directly records is corresponding, electrical form calculates according to predefined formula, can calculate and obtain the parameter values that all the other need, by numerically-controlled machine the monoblock feed be encircled the circle splicing according to the parameter values of calculating acquisition and get the raw materials ready and blanking.
The invention has the beneficial effects as follows the function formula program in the electrical form of utilizing, just can execute and cut because of material, reasonable use clout, saved cost, improved efficient, same such function formula program not only for technological design person and blanking numerical control programming person getting the raw materials ready and discharge has been saved the plenty of time, can also be with itself and numerically-controlled machine " grafting ", give routine processes middle a series of numerous and diverse links, but three known numeric value of doing of input that only need draw desired parameters and blanking with regard to moment, allow the common laborer also can finish designer and programmer's work.
Description of drawings
Fig. 1 is the existing synoptic diagram that obtains best discharge size by drawing.
Fig. 2 is the synoptic diagram of the best discharge size that obtains after the present invention uses.
Embodiment
For technological means, creation characteristic that the present invention is realized, reach purpose and effect is easy to understand, below in conjunction with specific embodiment and diagram, further set forth the present invention.
A kind of spreadsheet functions formula ring circle splicing get the raw materials ready and blanking in application, mainly may further comprise the steps, at first set the predefine formula of spreadsheet functions; Secondly determine three numerical value of monoblock feed 1, outer diameter D, inner diameter d, the wide B of feed plate, calculate remaining parameter values by predefine formula and three definite numerical value, secondly the parameter values that calculates is input in the computer program of numerically-controlled machine again, draw best discharge size, at last monoblock feed 1 is encircled the circle splicing and get the raw materials ready and blanking.
Wherein set the predefine formula of spreadsheet functions and work out by the staff, get the raw materials ready and blanking among the present invention monoblock feed 1 being encircled the circle splicing, the predefine formula of establishment is as follows:
R=D/2+5 (scalable coefficient);
R=d/2-5 (scalable coefficient);
α
0＝2·arcsin(B/2R)；
N＝2π/α
0；
n＝(2π/α
0，0)；
α＝2π/n；
b＝2·R·sin?α/2；
L＝R-r·cosα/2+(n-1)·[R
2-(b
1/2)
2]
1/2-[r
2-(b
1/2)
2]
1/2+10；
b
1＝2·r·sinα/2；
S＝B·L·10
-6。
Outer diameter D, inner diameter d, the wide B numerical value of feed plate can be by directly recording on the monoblock feed.
As shown in Figure 2, wide B 1600 is an example with outer diameter D 4000, inner diameter d 3700 and feed plate, and is as follows by the numerical value that predefined formula records:
The best discharge size that obtains is with the same by traditional plotting mode.
It is wide to need only the interior external diameter and oneself the predetermined feed plate that need in the input of program form in last chart, then a series of important parameters such as the length overall of its corresponding blanking isodisperse, blanking plate, beam overall, area can generate that (numerical value of first three lattice overstriking is manual pre-input value in the form, numerical value in the followed sheet is desired value corresponding and that generate automatically, just every important parameter of ring circle splicing discharge).
More than show and described ultimate principle of the present invention and principal character and advantage of the present invention.The technician of the industry should understand; the present invention is not restricted to the described embodiments; that describes in the foregoing description and the instructions just illustrates principle of the present invention; without departing from the spirit and scope of the present invention; the present invention also has various changes and modifications, and these changes and improvements all fall in the claimed scope of the invention.The claimed scope of the present invention is defined by appending claims and equivalent thereof.
Claims (3)
- A spreadsheet functions formula the splicing of ring circle get the raw materials ready and blanking in application, it is characterized in that: mainly may further comprise the steps, at first set the predefine formula of spreadsheet functions; Secondly determine three numerical value of monoblock feed, outer diameter D, inner diameter d, the wide B of feed plate, calculate remaining parameter values by predefine formula and three definite numerical value, secondly the parameter values that calculates is input in the computer program of numerically-controlled machine again, at last the monoblock feed is encircled the circle splicing and get the raw materials ready and blanking.
- According to the described spreadsheet functions formula of claim 1 ring circle splicing get the raw materials ready and blanking in application, it is characterized in that: the predefine formula of described setting spreadsheet functions is worked out by the staff.
- According to the described spreadsheet functions formula of claim 1 ring circle splicing get the raw materials ready and blanking in application, it is characterized in that: described outer diameter D, inner diameter d, the wide B numerical value of feed plate can be by directly recording on the monoblock feed.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2010101649317A CN101937210A (en) | 2010-04-30 | 2010-04-30 | Application of Excel function formula in feed preparation and baiting for circular splicing process |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2010101649317A CN101937210A (en) | 2010-04-30 | 2010-04-30 | Application of Excel function formula in feed preparation and baiting for circular splicing process |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN101937210A true CN101937210A (en) | 2011-01-05 |
Family
ID=43390592
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN2010101649317A Pending CN101937210A (en) | 2010-04-30 | 2010-04-30 | Application of Excel function formula in feed preparation and baiting for circular splicing process |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN101937210A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103106311A (en) * | 2013-02-18 | 2013-05-15 | 一重集团大连设计研究院有限公司 | Computing method of pipe shell type reactor grating |
| CN109145359A (en) * | 2018-06-28 | 2019-01-04 | 中铁山桥集团有限公司 | A kind of steel construction stock method based on BIM system and CAD software |
-
2010
- 2010-04-30 CN CN2010101649317A patent/CN101937210A/en active Pending
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103106311A (en) * | 2013-02-18 | 2013-05-15 | 一重集团大连设计研究院有限公司 | Computing method of pipe shell type reactor grating |
| CN103106311B (en) * | 2013-02-18 | 2015-08-19 | 一重集团大连设计研究院有限公司 | A kind of computing method of shell-and-tube reactor grid |
| CN109145359A (en) * | 2018-06-28 | 2019-01-04 | 中铁山桥集团有限公司 | A kind of steel construction stock method based on BIM system and CAD software |
| CN109145359B (en) * | 2018-06-28 | 2023-05-16 | 中铁山桥集团有限公司 | Steel structure material preparation method based on BIM system and CAD software |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN101877015B (en) | The three-dimensional labeling method of part processing | |
| CN107729003A (en) | Automatic generation method, device and the electronic equipment of code | |
| CN104932421B (en) | A kind of work of numerical control machine process CPS modeling methods based on instruction domain analysis | |
| DE212016000110U1 (en) | Data type remapping | |
| CN110377621B (en) | Interface processing method and device based on calculation engine | |
| CN102693281B (en) | AUTOCAD-based method for generating auxiliary line in PDMS | |
| CN103473216A (en) | Excel-based product process planning method | |
| US20170262436A1 (en) | Information-system-construction support tool and information-system-construction support program | |
| CN102870108A (en) | Method of generating electronic report | |
| CN102597949B (en) | The method of Computer-aided Design Technology system | |
| CN101937210A (en) | Application of Excel function formula in feed preparation and baiting for circular splicing process | |
| DE102017130613A1 (en) | Task scheduler | |
| CN116301735B (en) | Method, device and storage medium for organizing software elements into software data links | |
| CN110287243B (en) | Distributed data real-time acquisition and display system and method | |
| US20090327967A1 (en) | Engineering tool | |
| CN103530436A (en) | Tooling layout drawing parameterization generation method based on AUTOCAD. NET API | |
| CN113592288A (en) | Blanking plan scheduling method based on non-equivalent parallel machine model | |
| CN111489043B (en) | MPS-based enterprise medium-long term production planning system and method | |
| JP2022001977A (en) | Information processing device and computer program | |
| CN110770734A (en) | Method, apparatus and system for part build | |
| Wang et al. | Scheduling problems with exponential learning functions | |
| CN116757457B (en) | Method, device, equipment and storage medium for blanking plates in machining industry | |
| EP3534225A1 (en) | Module for industrial process automation and method for operating and project design | |
| CN101004804A (en) | System and method for querying files of standard operating procedure | |
| KR101612357B1 (en) | Method for making 2-dimensition drawings |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C02 | Deemed withdrawal of patent application after publication (patent law 2001) | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20110105 |