KR20100086883A - Method of automatically calculate processing cost for sheet metal working which uses autocad - Google Patents

Abstract

PURPOSE: A method for automatically calculating the cost which manufactures a sheet metal of sheet metal processor using AUTOCAD is provided to perform normalizing processing rate data through coupling between an AUTOCAD and a database. CONSTITUTION: In case a user is not authenticated, a user registration of an administrator is performed in user authentication page of a web server(S20,S21,S100). In case of processing rate data is not in the database, AUTOCAD program of a user client registers processing rate(S31). The AUTOCAD program processes extracting numerical value data of a product from an AUTOCAD drawing and calculating the processing rate the database(S50). The web server performs searching, confirming and correcting the result data(S70).

Description

{Method of automatically calculate processing cost for sheet metal working which uses autocad}

The present invention is a method for calculating the processing cost of the processing machine for sheet metal processing,

From the material cost, processing cost, bending ratio of the material cost input to the database server, and AUTOCAD installed on the user's computer, the numerical data values of the product drawings to be processed are calculated and calculated to calculate the processing cost so that the standard unit price of the processing cost can be applied. It is about a method.

 [Document 1] US 07058465 B2 (Amada Company, Limited) 2006.06.06

In the conventional method of calculating the processing cost, a method of calculating a price by calculating a total processing time or an expected processing time processed in a sheet metal processing machine has been proposed, but the method has been proposed after the program work in the CAM program in the CAM program. Expect the processing time and process it after completing the work, and if there are two sheet metal processing machines, and if the output of each sheet metal processing machine is not the same, the calculation time of CAM will be different and the standard unit price will be set. Since the database of these difficult and formulated data is stored in the PC where the work CAM program is installed, there is no function to handle the trouble of data management and the trouble of checking on the PC where the CAM program is installed.

In such a conventional technique, a user who calculates a unit price can extract data of a machining time of a machine connected to a CAM after preparing a machining drawing in a CAM program for a machine other than in AUTOCAD, which generally uses specification or quotation writing. There was a hassle of having to do CAM work when requesting a quote from the requestor, and the extracted data exists by sharing the computer folder by the computer where the CAM program is installed or by the internal network. There was a hassle to check on this installed computer. It is difficult to set the unit price extracted from the CAM as time, and it is difficult to activate the method of calculating the unit cost using the CAM because it is difficult to determine the unit price extracted as time from the CAM.

Therefore, the technical problem to be achieved by the present invention is not to use a method of extracting the time of the post-work process from the CAM by the user who needs unit price, but to set a unit price, using AUTOCAD, the numerical data of the drawings (area of product and Use the program to extract numerical data from AUTOCAD drawings and the socket program for communication with the database server to recognize the size of the material, the length of the cutting line, the number of holes, the number of point markings, the length of the marking line, and the number of bends). In addition, the numerical data extracted from AUTOCAD and the numerical data queried on the database server are calculated and linked, and the data values of the calculated processes and results are stored in the database server. Pages can be used to search, view, modify and print data. In addition, the correlation between the processing cost and the material size is characterized in that it can be processed by Fuzzy control.

As described in detail above, the present invention can make the standardization of the processing cost data by interlocking between AUTOCAD and the database, and output the value of the processing cost calculation result on the AUTOCAD drawing and stored in the database server and the web page on the web server. By querying the data from the corresponding database through the database, the statement and quotation can be searched, checked, printed, stored, and modified. Therefore, the statement creation time, the quotation creation time can be shortened, and the processing unit price can be standardized. As it is a system using an environment and a web server, it is possible to reduce the spatial constraints of the user when requesting the creation, calculation, and retrieval of processing unit cost.

The present invention for achieving the above object, the communication socket program with the server that can extract data by communication with the database server, LISP program and ARX that can decode and extract the numerical data of AUTOCAD drawings from AUTOCAD Fuzzy calculation module that analyzes files, numerical data values extracted from AUTOCAD, data values queried from database server, and calculated result value to calculate accurate wage rate, and retrieves data by querying the result values of the database from web server And it is characterized in that the output of the specification, the estimate on the web page can be confirmed.

Hereinafter, exemplary embodiments of the present invention will be described in detail with reference to the accompanying drawings.

Fig. 1 is a system block diagram to which the processing unit cost calculating method according to the present invention is applied, and as shown therein, the program (2A) is downloaded in advance in order to process the processing unit price calculation request for the product shape of the AUTOCAD drawing from the user client 2. And install the authentication key for identity verification during installation. After setting the user's certification in the browser such as Internet Explorer in (3) to set the wage rate of the database, the material type for processing, the KG unit price of the material, the cutting cost per mm according to the material thickness, and the hole processing according to the material thickness Unit price, unit price for point marking, unit price per mm of marking line, bending cost per mm according to material thickness, bending price per kg weight of material, processing cost according to ratio of product size to material size, minimum wage processing cost Is inputted in (3A) to set the data in the database server 1A via the web server 1B.

Upon request for calculation of the processing cost of the product shape of the AUTOCAD drawing from the user client (2), the user is authenticated at (2A), and the data is extracted by querying the basic wage rate according to processing by socket communication with the database server (1A). Save to computer memory.

When the user client 2 selects the product shape in the AUTOCAD drawing 2B to calculate the unit price, the DXF code in the AUTOCAD file is read from the unit price calculation program 2A to extract the numerical data and the database 1A. It is extracted in advance from the user client (2) and calculated in conjunction with the threshold data values stored in the memory of the PC to calculate the machining unit price, the result value is output to the selected product shape of the user's AUTOCAD drawing (2B) text at the same time as the socket The data is stored with the index key value so that the data can be extracted later to the database server 1A using the program 2A. In this way, after the user performs an operation for making an estimate or a statement, the user selects a list of data after the user authentication is performed on the web server 1B connected to the database server 1A in the Internet browser 3, and a fuzzy processor ( This is a method of selecting and outputting the specification 3B or the quotation 3C after the calculation process in 3E).

Log (3D) such as yearly, monthly, weekly, daily, hourly, company, material, thickness, material usage, etc., as a query for analyzing and extracting data from the web server 1B connected to the database server 1A. To be analyzed.

Figure 2 is a flow chart of the setting state when the user client requests the use of the user PC after checking the AUTOCAD data extraction and socket communication program (S10) with the database of the first user PC

If it is not installed, the AUTOCAD data extraction and socket communication program with the database are installed (S11). Before the user client is used, the user's client authentication is checked (S20). This is done on the web server's user authentication page (S100)

Data about it is stored in the database server (S60). After the user authentication, the web server (S100) can be registered and modified in the program page for the wage rate for processing (S31), the data for the database server ( S60).

When calculating the processing unit price of the product in the AUTOCAD program of the user client, after confirming the presence or absence of the data processing rate in the database (S60) to register the processing rate if there is no wage data (S31).

When requesting the unit cost selection of the product from the AUTOCAD drawing of the user client, the processing rate of the database and the numerical data of the selected product in the AUTOCAD drawing are extracted and processed (S50), and the result is stored in the database server (S60).

After calculating the unit price of products in this way,

In the web server (S100) that has passed the user authentication, the result data can be searched, checked, and further deleted (S70). The program web page is made for output and can be output as a quotation (S80) and a specification (S81). By extracting a variety of data from the data of the database server (S60) has a feature that can be analyzed (S90) logs such as material usage, sales amount by company.

1 is a system block diagram to which the processing unit price calculation method according to the present invention is applied

2 is a system flow chart to which the processing unit price calculation method according to the present invention is applied.

*** Description of the symbols for the main parts of the drawings ***

1: server

1A: Database Server

1B: Web Server

2: User Client PC

2A: User authentication key, unit cost calculation program and communication socket program

2B: AUTOCAD and AUTOCAD Drawing

3: web program page

3A: Input machining rate

3B: Statement output

3C: Quotation Printing

3D: Log Analysis

3E: Fuzzy Processor

Claims (3)

An apparatus for calculating the processing cost of a product in a CAD drawing by a socket communication between a DATABASE server on which an internet (intranet) network is established and AUTOCAD in the above-described method for calculating the processing cost of sheet metal processing. Apparatus for the method of outputting the quotation and the specification for the processing cost through the program page of the web server, the data of the DATABASE server generated and stored by Clause 1 in the above-mentioned method of calculating the sheet processing cost of sheet metal processing. The length of the line extracted from AUTOCAD, the number of holes, the number of point markings, Numerical data extracted from AUTOCAD (Material Material, Material Thickness, Cutting Length, Number of Holes, Piercing Number, Point Marking Number), not the calculation of the machining cost for the length and bending of marking lines, rather than the calculation method for the machining time for CAM. , Marking line length, number of bends, length of bend lines).

Images