Abstract: A data profiling module receives user selection of spreadsheets, and the data from the selected spreadsheets is profiled. At least one matching column is identified among the spreadsheets selected. The data profiling module calculates a match metric for the at least one matching column, and unifies the spreadsheets into a single composite spreadsheet using the at least one identified matching column. A preview view of a composite spreadsheet is generated, visually indicating the at least one matching column, any non-matching columns between the spreadsheets, and the match metric for the matching columns. An action history module identifies spreadsheets for use in the procedure, and stores any action applied to the spreadsheets as a procedure template that can be applied to a plurality of other spreadsheets.

Abstract: A data profiling module receives user selection of spreadsheets, and the data from the selected spreadsheets is profiled. At least one matching column is identified among the spreadsheets selected. The data profiling module calculates a match metric for the at least one matching column, and unifies the spreadsheets into a single composite spreadsheet using the at least one identified matching column. A preview view of a composite spreadsheet is generated, visually indicating the at least one matching column, any non-matching columns between the spreadsheets, and the match metric for the matching columns. An action history module identifies spreadsheets for use in the procedure, and stores any action applied to the spreadsheets as a procedure template that can be applied to a plurality of other spreadsheets.

Abstract: The present invention provides a method and apparatus for accurately matching colors. The color matching system includes a host computer and a color input device in communication with the host computer. Preferably the color input device is capable of obtaining spectral data, such as that obtained using a spectrophotometer. The host computer includes a color library, a color management system, a monitor, and a user interface. In one aspect of the invention, the user selects a target color, a color library to use for matching, a color distance tolerance, and a light source under which the colors are to be matched. The target color is compared to the colors in the library and the color or colors in the library that are within the specified color tolerance are reported. In a second aspect of the invention, the user selects a color and two illuminants. The color under each of the two illuminants is compared and the color distance between the two is reported.

Abstract: The present invention provides a method and apparatus for accurately matching colors. The color matching system includes a host computer and a color input device in communication with the host computer. Preferably the color input device is capable of obtaining spectral data, such as that obtained using a spectrophotometer. The host computer includes a color library, a color management system, a monitor, and a user interface. In one aspect of the invention, the user selects a target color, a color library to use for matching, a color distance tolerance, and a light source under which the colors are to be matched. The target color is compared to the colors in the library and the color or colors in the library that are within the specified color tolerance are reported. In a second aspect of the invention, the user selects a color and two illuminants. The color under each of the two illuminants is compared and the color distance between the two is reported.