JPH10202184A - Coating composition content and cost-calculating apparatus - Google Patents

Abstract

PROBLEM TO BE SOLVED: To constitute a system for quickly calculating coating composition contents and the cost in automobile coating repair. SOLUTION: The computer system comprises recording means for recording a type of a commercialized automobile, an area of each of portions, another recording means for recording coating composition standards and the like representing coating colors of the commercialized automobile, inputting means for inputting the type of the automobile to be coated and repaired, the portions, the colors, a rate of areas to be repaired and the like, calculating means for calculating coating composition contents and cost thereof based on the recorded data and input values, and outputting means for outputting the calculated composition contents and the cost thereof.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to an apparatus for calculating the content and cost of a paint mixture, and more particularly, to an apparatus for calculating the content and cost of a paint composition used in repairing paint on an automobile.

[0002]

Conventionally, as a method of color matching in a coating process, a commercially available paint is combined, a collation with a target color sample is performed, and after a number of blending attempts are made, a use is attempted. The composition ratio of the paint to be used was determined. In addition, the cost of the paint is calculated by actually measuring the area of the object to be coated and calculating the amount of coating. Therefore, it takes a long time to determine the content of the paint mixture and calculate the cost of the coating, which has been a problem in promptly submitting a quote and shortening the processing delivery date.

[0003] With regard to repair painting of automobiles, the paint colors of automobile manufacturers are determined, and the paint mix standards are publicly disclosed by paint manufacturers for each paint color.
Therefore, although the work of determining the blending ratio is reduced, it is easier than general coating processing.However, since the coating portion covers many places and each shape is complicated, measurement of the coating area, calculation of the mixing amount, As for the calculation of the paint cost and the like, it takes more time and effort, and the above-mentioned problems have not been solved.

Further, according to the conventional manual operation,
Mistakes may occur in the search of formulation standards, calculation of paint amount and cost, transcription when creating various documents, etc., which is one of the causes of wasting the prepared paint and making incorrect estimates. I was Therefore, development of an apparatus for reducing the number of manual operations and promoting automation is expected.

Therefore, the present inventor has determined that in the repair processing of an automobile paint, the content of the paint and the cost of the paint are promptly determined, so that the worker can be instructed correctly on the content of the process and can make a quick estimate. As a result of intensive studies on the devices that can be made, the present invention has been reached.

[0006]

The present invention solves the above-mentioned problems by a computer system. That is,
The computer system is a device that calculates the content and cost of a paint mixture used in automobile painting repair,
At least an area data recording means for recording the type of the commercial vehicle and the area of each part, a blending standard and a price of the paint expressing the paint color of the manufacturer of the commercial vehicle, and an application amount per unit area are recorded. Paint data recording means,
Means for inputting the type, location and color of the vehicle to be repaired, means for inputting the repaired area ratio of the portion to be repaired, the entered repaired area ratio, and the area recorded by the area data recording means From the data, the means for calculating the repair area, the calculated repair area, and the paint data recorded by the paint data recording means, from the paint blending reference data and price data, and from the application amount data per unit area, An apparatus comprising: means for calculating the content and cost of a paint mixture; and means for outputting the calculated content and cost of a paint formulation.

[0007] Further, the present invention is an apparatus characterized in that the calculated contents of paint preparation are output to a painting work instruction sheet.

[0008]

BEST MODE FOR CARRYING OUT THE INVENTION The purpose of the present invention is to pay attention to the fact that the area of an automobile part and the mixing standard of colors to be painted by an automobile manufacturer are publicly known, and these are recorded in advance. Computer processing,
The purpose of the present invention is to perform search and calculation operations quickly and accurately to improve the efficiency of painting and improve the speed of customer service.

Hereinafter, an embodiment of an apparatus for calculating the content and cost of paint preparation according to the present invention will be described in detail with reference to the drawings.

FIG. 1 is a system configuration diagram for explaining an example of an apparatus for calculating the contents of paint preparation and costs according to the present invention. The file device stores an area data file and a paint data file. In the area data file, the surface area of each part is recorded for each type of commercially available automobile. Further, in the paint data file, correspondence data between the paint color of the automobile manufacturer and the blending standard by the paint manufacturer is recorded.

FIG. 2 shows an example of the area data file. The area of each part is recorded for each vehicle type. Since there are hundreds of models of domestic cars alone, it is difficult to input data for all models at once, but when the new specification car is released or every time the paint repair processing is done, input the target car model sequentially. Then, it is preferable to enhance the recorded contents. Since there are many types of vehicles for which the area of each part is disclosed, it is only necessary to input published data for many types of vehicles, but for vehicles without published values, actual measurements must be made. For vehicle types that are not recorded in the area data file, an average numerical value for each group classified according to vehicle size or type may be recorded in advance and substituted.

FIG. 3 shows an example of a paint data file. The paint maker's blending standard for the paint color of the automobile maker, the paint price, and the amount applied per 100 cm ² are recorded. The paint color of the car manufacturer is indicated by a color code. Also, in order to facilitate comparison with a color sample based on the blending standard, a color sample card No. Is also recorded. Usually, several sets of compounding standards are exemplified by a paint maker for one paint color of an automobile maker. This is because the color changes subtly due to differences in production lots of automobile manufacturers, discoloration over time, and the like. Therefore, when selecting a paint maker's compounding standard, the color sample card and the color of the actual vehicle must be compared to confirm that they are the same color.

The means for recording area data, paint data and the like is not particularly limited. Usually, it may be used for a computer. Internal memories such as semiconductor memories and hard disks, and external memories such as floppy disks, various optical disks, and magnetic tapes can be used.

The means for inputting the type, location, and color of the vehicle to be repaired and the means for inputting the repair area ratio of the portion to be repaired are not particularly limited as long as they are normally input to a computer. . An input device provided with the computer, for example, a keyboard or the like, or an input device of various terminals connected to a communication line or the like may be used.

The repair area ratio of the part to be repaired is
It refers to the ratio of the area of the part to be repaired to the surface area of the part to be repaired. For example, the value may be 0.5 when only half of the front surface of the door is painted, and may be 1.2 when the whole surface of the door and the end surface following the back surface are painted. The purpose of introducing this parameter is to determine the approximate value by visual measurement instead of actually measuring the repair area, and to improve the work efficiency. Since the area ratio is determined for each part having a relatively small area, an area that is not much different from the actually measured value can be obtained. In the description of the present invention, the repair area ratio may be referred to as the integration rate in some cases.

Means for calculating a repaired area from the input repaired area ratio and the area data recorded by the area data recording means, and the calculated repaired area and recorded in the paint data recording means. Means for calculating the content and cost of paint formulation from paint formulation reference data, price data, and application amount data per unit area, are configured by combining a main memory of a computer with a central processing unit. be able to.
That is, the central processing unit performs selection and calculation in response to a command from the control program in the main memory.

Means for outputting the calculated content and cost of the paint are not particularly limited as long as they are output devices normally used in a computer. A CRT, a printer, and the like can be used.

FIG. 4 is a flow chart showing an example of processing executed by the apparatus. FIGS. 5 and 6 are schematic diagrams for explaining the details of the processing, and illustrate a case where the target portion of the coating is a hood and the coating process is a base coat. First, a vehicle type, a part, a color code, an integration rate, and the like, which are marked with circles in FIG. 5, are input. Based on these input data, the area of the parts, the amount of application per unit area, marked with squares. , Reference paint composition, reference paint cost, card code, etc. are retrieved from the area data file and the paint data file.

Next, the content of paint composition and the cost of paint required for the actual painting process are calculated by the calculation formula in FIG.
In FIGS. 5 and 6, these calculated values are marked with triangles. That is, the amount of application required for the base coat of the hood is calculated by equation (1), and the paint cost is obtained by equation (2).

In an actual automobile coating repair, the painting process often requires surface coating, clear coating, two-color coating, and the like, and the repair portion often covers several parts. In such a case, the series of processes described above
The same applies to other parts and other coating steps, and the paint amount and the coating cost for each coating step and each part are determined. The type of paint hardener, the type of clear coating agent, the color code for the second color, and the like must be input as necessary. As a result, paint cost for each part (total)
Is calculated by summing the paint costs in each coating process, and the coating amount (total) for each coating process is calculated by summing the paint amounts in each part. This calculation method is schematically shown by equations (3) and (4) in FIG.

The paint composition required for the current coating process is represented by equation (5) in FIG. 6, the paint cost for each coating step is represented by equation (6), and the total paint cost is represented by equation (7). Or (8). The calculated content is output by an output device such as a printer, and is executed in an optimal form according to the purpose.

Claim 2 relates to the purpose of performing the painting operation quickly and accurately. Although the content of the paint mixture necessary for the coating process is indispensable for the instruction of the content of the coating operation, the content of the formulation correctly calculated by the computer must not be erroneously indicated by a mistaken transcription or the like. It is important to output the work instructions directly from the computer to prevent errors. The work instruction includes a card No. for retrieving a coating part, its coating ratio, and a color sample, along with the preparation content for each coating process. Preferably, etc. are specified.

The painting work according to the work instruction sheet according to the present invention is performed as follows. That is, the worker first grasps the paint repaired part based on the repaired part and the integration rate entered in the instruction sheet, and confirms by looking at the actual vehicle. Next, the paint is prepared. After comparing and confirming the color sample searched in the above with the color of the actual vehicle, the dispensing is performed based on the dispensing content specified by the instruction sheet. The prepared paint is applied on the toning plate and checked again with the actual vehicle color. If there is a slight difference in color, the paint formulation must be reworked. Usually, several reworkings are required in many cases. Therefore, it is preferable that the amount of the paint to be prepared is calculated including the loss by collation in advance and written in the instruction sheet. After the color of the vehicle matches, the painting operation is performed.

The total paint cost and the paint cost (total) for each part are effectively used for business activities through estimation work. Since it is possible to quickly submit a quote and to immediately correct the contents of the quote, communication with customers can be facilitated and business results can be improved.

It is more convenient if not only the paint cost but also the labor cost, auxiliary material cost, utility cost, etc. required for the coating process are output at the same time. For this purpose, a reference cost of each of these costs is recorded in advance for each coating step and each coating portion, and the respective costs can be calculated and output in the same procedure as the paint cost calculation.

In addition, the present invention is based on the knowledge of those skilled in the art for input means, recording means, arithmetic means, output means, etc., and for input contents, recorded contents, output contents, etc., without departing from the scope of the invention. The present invention can be implemented in various improved, modified, and modified modes.

Embodiments of the present invention will be described in detail below.

First Embodiment As shown in FIG. 1, a computer is provided in a central processing unit, an HD is provided in a built-in main memory, a keyboard is provided in an input device, a CRT and a printer are provided in an output device, an area data file, and a paint data file. The FD was used to construct the calculation device of the present invention. In the main memory, the flow of FIG. 4 and the surface coating and clear coating
A control program capable of executing a flow similar to that of FIG. 4 is recorded. In addition, the area data file and the paint data file include, for the main types of vehicles marketed in Japan, the area of each part, the paint maker's blending standard for the paint color of the car maker, and the card No. , Price, application amount per unit area, and the like are recorded.

Using the calculation apparatus of this example, a work instruction sheet for repairing the coating of a Corolla 4-door sedan manufactured by Toyota Motor Corporation was prepared. The main contents are shown in FIG. 7, but input values such as a vehicle type, a coating part, a color code, an integration rate (repair ratio), a paint compounding content calculated based on these, a type of a curing agent, Amount, used solvent amount and the like, and the card No. Is specified. When the paint was repaired based on this work instruction, it was confirmed that the work content was clearly instructed, so there was no paint mix error and the work efficiency was significantly improved.

Second Embodiment Using the calculation device manufactured in the first embodiment, a work instruction sheet was prepared for repairing the coating of a Corolla 4-door sedan manufactured by Toyota Motor Corporation. As shown in FIG.
The repaired parts are the hood, the right front fender, and the left front fender, and the painting process is three processes of surfacer, base coat, and clear. Input values such as vehicle type, painted part, color code, integration rate (repair ratio) for each part, and paint composition contents calculated based on these, type and amount of hardener, amount of surfacer paint, amount of clear paint , Amount of solvent used, etc. and card No. Is specified. The paint cost was calculated according to FIG. 6, equation (7) or (8), and as shown in FIG. 9, the overall paint cost could be calculated. As a result, it is possible to quickly submit a quote including an estimate for each part, and it has become possible to smoothly respond to customers.

[0031]

According to the paint blending content and cost calculating apparatus according to the present invention, the paint blending content can be calculated quickly and accurately, so that the coating can be repaired quickly and the blending mistake can be prevented. Generation can be prevented, and work efficiency is improved. Further, since the calculation of the paint cost including the cost for each part can be performed quickly, it is possible to submit the estimate at an early stage and to easily explain the contents of the estimate.

[Brief description of the drawings]

FIG. 1 is a system configuration diagram illustrating an example of a paint blending content and cost calculation device according to the present invention.

FIG. 2 is a partially enlarged view illustrating an example of an area data file according to the present invention.

FIG. 3 is an explanatory diagram showing an example of a paint data file according to the present invention.

FIG. 4 is a flowchart showing an example of processing executed by the paint content and cost calculation device according to the present invention.

FIG. 5 is a schematic diagram illustrating an example of a process executed by the paint calculation content and cost calculation device according to the present invention.

FIG. 6 is a schematic diagram illustrating calculations used in a process performed by a paint mixing content and cost calculation device according to the present invention.

FIG. 7 is an explanatory diagram showing an example of a work instruction sheet according to the present invention.

FIG. 8 is an explanatory diagram showing another example of the work instruction sheet according to the present invention.

FIG. 9 is an explanatory diagram showing an example of a paint cost calculation method according to the present invention.

Claims (2)

[Claims] 1. An apparatus for calculating the content and cost of a paint to be used in repairing a paint for an automobile, an area data recording means for recording at least an area of each type and a part of a commercial automobile, and a manufacturer coating of a commercial automobile. Paint data recording means for recording the paint mix standard and price, and the amount of coating per unit area, Paint repair, means for inputting the type and location and color of the automobile, Paint repair Means for inputting the repair area ratio of the part, means for calculating the repair area from the input repair area ratio and the area data recorded by the area data recording means, the calculated repair area, Based on the paint composition reference data and price data recorded in the paint data recording means, and the coating amount data per unit area, the paint A means for calculating the content and cost of the composition, and a means for outputting the content and cost of the calculated composition of the paint. 2. The apparatus for calculating the content of a paint and the cost according to claim 1, wherein the calculated content of the paint is output to a painting work instruction sheet.