Measure what you see.
SMART CHART¬3OFTWARE -ANUAL ¬ ¬ ¬%¬
"9+ 'ARDNER¬'MB( ,AUSITZER¬3TR ¬ $ ¬'ERETSRIED 'ERMANY 4EL ¬¬ GARDNER ¬ ¬ &AX¬¬ WWW BYK COM INSTRUMENTS "9+¬ ¬'ARDNER¬53! ¬'UILFORD¬2OAD #OLUMBIA ¬-$¬ 53! 0HONE¬¬ ¬ &AX¬¬ ¬
smart-chart® Manual Advanced Analysis Overview 2. Data to Excel 2.1 Pivot 3. Excel QC Reports 3.1 Trend MinMax for wave-scan family 3.2 Balance S-Chart for wave-scan family 3.
1. Overview Numerous production parameters influence color and appearance. Representative quality control requires structured analysis. The smart-chart software allows for systematic planning and efficient handling of the series. Depending on the application, the system can be used in various ways, from single measurements in R&D up to routine process control procedures. The smart-chart software allows to create so-called Organizer files which define the object to be measured and the sampling procedure.
2. Data to Excel The desired data are filtered and documented in a worksheet. A Pivot function allows to customize the layout in Excel.To recall data saved in a database use the button "Data to Excel" from the Data Analysis module (1): The “Open Data” window opens which allows to specify the data to be selected: Make sure the required database is selected (2). Data can be filtered out of the database by selecting specific parameters according to your Organizer definitions, e.g.
Note: The layout of the data in Excel can be changed by using the Pivot function (see 2.1). Selection of individual datasets: Use the button "Filter Result" (6) of the "Open Data" window to display a list of all the records according to your filter criterions: Note: If the same object was measured with several instruments, e.g. wave-scan and BYK-mac, every dataset is listed as a separate record.
2.1 Pivot The measurement data can be shown in various ways. Use the "Open Data" function to select the desired datasets as described above: Press the "Pivot" button (1). A window appears which allows to define the criteria to be displayed in rows and columns: Highlight the desired criteria for the columns in the "Criteria" field (2) and press the button (3). Then select the criteria to be shown in the rows and move it to the "Rows" field (4).
the rows several criteria can be chosen. Additionally, the sequence of the entries can be defined. Therefore, highlight the required criteria (5) and use the up and down arrows (6). After all definitions are done, press OK (7) to go back to the "Open Data" window. Press the "Show Data" button (8) to transfer the selected data to Excel: Note: The Pivot function groups the data and does not represent the values of individual objects. E.g.
3. Analyze Data using QC Reports Preprepared test reports for BYK-mac and wave-scan assist in analyzing the data of multiple test series. Press the button "Excel QC Reports" (1) to find the list of the various Excel workbooks: Select the desired report by double click (2) or highlight and press "Open" (3).
3.1 Trend MinMax for the wave-scan family This report will give information on the process stability. The average and range by day or week are charted. The data can be shown for individual colors of a specific month as a daily line trend (1). In addition, the average of the previous 3 months plus the ranges respectively are shown in a bar graph (2). Up to 4 zones (e.g. Horizontal, Left, Right, ...) can be shown on one page, i.e. up to 4 filters can be defined per report.
Press "OK" to start the analysis. The data are filtered from the database and the results appear in the report. Finished Trend MinMax Report: Note: 3 or 4 Zones can be displayed on one page, an icon for the desired report can be selected accordingly.
3.2 Balance S-Chart for the wave-scan family The new Balance Chart, a 2-dimensional appearance system, allows evaluating process stability as well as harmony between add-on parts and car body. The ratio of the various structure sizes are evaluated Æ improved correlation to the visual perception. Scale 1: Wd - Measurement for Orange Peel (1) The most critical parameter is orange peel as this type of structure is most obvious to the customer at a far distance. Scale 2: B - Balance (2) ..
Display of the results can be grouped by Color or Individual (7). Thus, every data point will be the average of the horizontal or vertical zones of one color, or of one vehicle Æ good measure for process stability. The “Define Filter” button (8) allows for selection of specific parameters like model, color or paint line. To start the analysis, click the "OK" button (9), the data are filtered from the database and the results appear in the report.
3.3 BYK-mac link ... analyses and documents the color data measured with the BYK-mac. The file can be directly opened from the Windows Start menu or in the software auto-chart under the function "QC-Reports". There are two BYK-mac link specific toolbars for e.g. data transfer, selecting data and to switch to different data analysis graphs: Note: As a default setting Data Table, delta Lab- and Effect Graph are displayed. To activate additional worksheets, press the icon "View" and check the required graphs.
Selection (3) This function enables to populate the color graphs for further analysis: Compare Standard and Samples Select the appropriate standard (4), then highlight the samples to be compared: Press "OK" to start the population of the graphs. Compare Sample readings Select "none" in the Standard box (4) and highlight the samples to be analyzed. By selecting "none" the first sample in the list will be automatically used as standard. Press "OK" to start the population of the graphs.
Save the new filter with the "Save As" function from the "File" menu (9). It is recommended to use descriptive names. After saving click "Show Data" (10), the "Selection Dialog" box will appear (see "Selection"). Data Table ... gives the numerical results of the selected standard and samples.
Spectral Curves The spectral curves can be displayed in two ways: - Grouped by angle - one graph per angle showing the curves of the selected samples and standard (red line). - Grouped by sample - one graph per sample including the curves of the various angles. The standard is shown as a dotted line. The numerical “Spectral Data Table” can be viewed in an additional page to be selected in the Tab-bar at the bottom of the workbook. Note: The spectral data is only displayed for single measurement zones.
Trend by Angle Color and effect data are displayed on one report. The data is grouped by angle. Thus, the uniformity per angle can be easily analyzed. Lab 3 illuminants In this chart color data for 3 illuminants are displayed simultaneously per measurement angle. The desired illuminants can be picked by use of the drop-down list. In the graphs specific symbols are used for the different illuminants. The table below shows the numerical results.
Custom Specific Color Difference Methods When selecting custom specific color difference methods (16) an additional report is available in the Tab-bar at the bottom of the workbook named “D_Table”. Also the icon Data Table is now linked with this new report. The report “D_Table” allows the calculation of a weighted dE. In the upper part of the report, the tolerance settings are defined. The weighting factors (S-factors) (17) can either be automatically calculated or manually input.
Color difference components can be shown either weighted or as regular CIELAB color differences (20). If da or db are out of tolerance they are highlighted in the corresponding color e.g. if db is negative and out of specification it is highlighted in blue. All other components are marked red. When using weighted components a tolerance of 1 is used by definition. Effect data is shown numerically and in a sparkle difference graph for each angle (21).
259 021 775 E 1007
