Color harmony with process and environmental feedback
A computerized system and method for analyzing color consistency on automotive parts and for providing feedback on painting processes occurring in an assembly plant. The system and method facilitates data collection and analysis at numerous points during the assembly paint processes and the identification of possible adjustments so that parts are painted within a specified tolerance. Body and bumper parts are measured during an inspection process. Measurement and colorimetric data is stored in association with an identifier for the body part or bumper. Measurements relate to equipment and paint mix variables as well as environmental variables that influence the paint results. A software application facilitates analysis of the data and troubleshooting possible causes for color discrepancies. As the color trends away from a specified standard, paint process, including environmental, changes are made, prior to the painting of parts in the bumper or body so that color mismatches are prevented.
1. A computerized method for analyzing color trend data comprising:
(a) storing in a database for each one of a plurality of body parts:
(i) a body part identifier;
(ii) color measurement data collected during application of a paint color to said body part; and
(iii) paint process data collected during application of said paint color to said body part;
(b) storing in said database for each of a plurality of vehicles, a vehicle identification number associated with:
(i) a first body part identifier for a first body part installed on said vehicle; and
(ii) a second body part identifier for a second body part installed on said vehicle;
(c) receiving at a server, a request to access said color measurement data associated with each of said body part identifiers during application of said paint color to said body part; and
(d) generating at said server for display at a user computer, a screen comprising for each of said vehicle identification numbers, data related to a first color measurement for said first body part identifier and a second color measurement for said second body part identifier.
2. The computerized method of claim 1 wherein said paint process data is selected from the group consisting of device data, material data, and environmental data.
3. The computerized method of claim 2 wherein said environmental data comprises temperature and humidity data for a paint booth.
4. The computerized method of claim 1 further comprising generating at said server for display at a user computer, a screen comprising a color measurement for said first body part identifier and at least one tolerance value for said color measurement.
5. The computerized method of claim 1 wherein said body parts are selected from the group consisting of automotive panels and bumpers.
6. The computerized method of claim 1 further comprising generating at said server for display at a user computer, a screen comprising for each of said vehicle identification numbers, a value for a paint process related to said first body part identifier.
7. The computerized method of claim 1 wherein said screen further comprises paint process data for said first body part identifier and said second body part identifier.
8. A computerized system for analyzing color trend data comprising:
(a) a database for storing for:
(1) for each one of a plurality of body parts:
(A) a body part identifier;
(B) color measurement data collected during application of a paint color to said body part; and
(C) paint process data collected during application of said paint color to said body part;
(2) for each of a plurality of vehicles, a vehicle identification number associated with:
(A) a first body part identifier for a first body part installed on said vehicle; and
(B) a second body part identifier for a second body part installed on said vehicle; and
(b) a server with programming instructions to:
(1) receive at said server, a request to access said color measurement data associated with each of said body part identifiers during application of said paint color to said body part; and
(2) generate at said server for display at a user computer, a screen comprising for each of said vehicle identification numbers, data related to a first color measurement for said first body part identifier and a second color measurement for said second body part identifier.
9. The computerized system of claim 8 wherein said paint process data is selected from the group consisting of device data, material data, and environmental data.
10. The computerized system of claim 9 wherein said environmental data comprises temperature and humidity data for a paint booth.
11. The computerized system of claim 8 wherein said screen further comprises a color measurement for said first body part identifier and at least one tolerance value for said color measurement.
12. The computerized system of claim 8 wherein said body parts are selected from the group consisting of automotive panels and bumpers.
13. The computerized system of claim 8 wherein said screen further comprises for each of said vehicle identification numbers, a value for a paint process related to said first body part identifier.
14. A computerized method for analyzing color trend data comprising:
(a) receiving at a server for each one of a plurality of body parts:
(i) a body part identifier;
(ii) color measurement data collected during application of a paint color to said body part; and
(iii) paint process data collected during application of said paint color to said body part;
(b) storing in a database said body part identifiers, said color measurement data, and said paint process data;
(c) associating a first body part identifier for a first body part installed on a vehicle with a second body part identifier for a second body part installed on said vehicle, said vehicle having a vehicle identification number;
(d) receiving at said server a request to access said color measurement data associated with each of said first and second body part identifiers during application of said paint color to said body part; and
(e) generating at said server for display at a user computer, a screen comprising for said vehicle identification number, data related to a first color measurement for said first body part identifier and a second color measurement for said second body part identifier.
15. The computerized method of claim 14 wherein said paint process data is selected from the group consisting of device data, material data, and environmental data.
16. The computerized method of claim 15 wherein said environmental data comprises temperature and humidity data for a paint booth.
17. The computerized method of claim 14 further comprising generating at said server for display at a user computer, a screen comprising a color measurement for said first body part identifier and at least one tolerance value for said color measurement.
18. The computerized method of claim 14 wherein said body parts are selected from the group consisting of automotive panels and bumpers.
19. The computerized method of claim 14 further comprising generating at said server for display at a user computer, a screen comprising for each of a plurality of vehicles, a value for a paint process related to said first body part identifier.
20. The computerized method of claim 14 wherein said screen further comprises paint process data for said first body part identifier and said second body part identifier.