Excel Workbooks

---

This workbook requires an iSis for color and and iSis Wide for M-Scores and 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. It evaluates for Colormetric Accuracy, Run Uniformity, Repeatability and Macro Uniformity or M-Score. It also adds visualizations for the M-Score deviations.

This is the basic M Score workbook I created for Idealliance. I based it on the newer math of ISO 18621-21:2013.

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.

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.

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 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