This is a collection of MS Excel workbooks I've created over the years which serve specific needs in offset and digital printing workflows and are offered free of charge on the Downloads page.
These workbooks go beyond one-time color for further evaluation of repeatability, consistency over short and long term reruns and macro stability or M Scores for sheet consistency..

This workbook returns a handsome report of all color metrics needed for the IDEAlliance G7 Digital Press Certification process, a badge offered only at the Manufacturers level. Use this newly updated test to compare your digital press to industry standards for Colormetric Accuracy using the latest G7 metrics and test charts. Also test for Run Uniformity, Repeatability and Macro Uniformity or M-Score. It also adds Topocolometric (heatmap) visualizations for Delta E uniformity of the sheet.

This is the basic M Score workbook created for Idealliance. This is a 3-sheet method which requires an iSisXL scanning spectrophotometer. Based on ISO TC-18621-21:2013. It returns an overall Uniformity or M-Score pass/fail per Idealliance specs for the G7 Digital Press Certification procedure.
It is available as a tool for those manufacturers interested in Idealliance's Digital Press Certification procedure.

This workbook calculates M Score using a completely new, single page chart. It's much faster than the traditional 3-Sheet method and can be measured with an i1IO, iSisWide or FD9. Multiple measurements can now be taken into consideration easily.
Evaluating sequential sheets for presses with multiple prints per belt or cylinder becomes highly efficient. Plus, checking larger sheet sizes such as 2up and 4up sheet becomes practical given the limited size of measurement devices.
These workbooks are for calculating SCTV for ECG workflows CTV for CMYKOGV workflows and for calculating the Metamerism Index of any ink/paper combination.

The first step in any ECG workflow is to bring the press into G7 compliance for CMYK and to use SCTV curves for the additional colorants. Lots of ways to get G7 curves for CMYK, this is a tool to calculate SCTV for the OGV used in most ECG workflows.
This workbook is setup to ingest CGATS data of the IDEAlliance SCTVi6 ECG color ramps measured with an i1 or i1IO spectro and returns curve data for each colorant plus black.

This uses a custom 7C Linearization chart to create CMYKOGV curves based on the SCTV ISO 28645 Standard math. Allows you to use one curve tool for both CMYK and OGV.
Universal chart can be used in either the iSis or i1IOPro2/3 Spectrophotometers.

This workbook provides feedback on how colors shift under different lighting conditions. Measure the control strip 3 times using a Baseline (D50) and two other lighting conditions (examples are D65, F11) and the workbook calculates the Metamerism Index for each patch using the DIN 6172 formulas. Helpful for answering the question of which inks/substrates exhibit the most or least metamerism and which colors are affected most and least. Red indicates a high index from the baseline, green the low

This workbook uses a either the IDEAllainace G7 Verifier strip or the included custom strip for the eXact Scan via DataMeasure v1.3.2. to evaluate for G7Master: Grayscale metrics. Supports bluetooth connection to the eXact Scan.

This one grew out of the G7 Verifier workbook but uses a custom Mini-P2P to plot the spider graphs for the primaries and overprints. Measured with the eXact scan via DataMeasure v1.3.2, the workbook evaluates for G7 Master: Targeted metrics. Supports bluetooth connection to the eXact Scan.
IDEAlliance is a registered trademark of the Printing United Alliance. The use of their name in no way infers endorsement of these workbooks. Only public domain charts and control strips are used except where otherwise mentioned and permission is given to use any custom strips from colorkyle.com. Each workbook may contain credits to others for some formulas used in the math.
Copyright © 2026 colorkyle.com - All Rights Reserved.
We use cookies to analyze website traffic and optimize your website experience. By accepting our use of cookies, your data will be aggregated with all other user data.