Worksheet

The Color Worksheet is a spreadsheet that understands color. Rows in the worksheet are for profiles, images, color lists and workflow information. Columns are for color transformations, comparisons and delta-E calculations. The combined effect is a multi-purpose tool with unlimited color evaluation configurations.

Worksheet Concepts

First, a few important concepts and definitions, as far as the Worksheet is concerned:

The Worksheet contains one or more Workflows, each of which contains one or more Transforms.

A Workflow is best understood as the “lifecycle of a color”. It starts with a single source of color: an image or list of colors. Transforms then convert these colors using ICC Profiles. It’s possible to have multiple profiles converting color through multiple transforms, each picking up the color from the previous transform and converting it to a new form.

When two color sources are loaded into the Worksheet, each begins its own Workflow. Transforms can be applied to each Workflow as needed.

This allows for a wide variety of scenarios and the ability to do simple comparisons or to model complex workflows.

At any point the delta-E (∆E) function can be activated to calculate the color shifts between any transform in the sheet. A few examples include:

• Two color measurement lists are opened into the worksheet and delta-E calculates the difference between them. This could be comparing two different paper measurements, an original set of measurements and a set after the sample faded, or was laminated, or a new set is measured to see if an inkjet has color shifted.

• An image is opened into the Worksheet twice and AdobeRGB is assigned to one and a scanner profile to the other. You can see the visual difference in the images and once delta-E is activated, a heatmap of color shifts visualizes the parts of the image most affected.

• A list of brand colors is opened into the Worksheet and transformed by a press profile and an inkjet profile. Delta-E is activated and each transform is compared with the original colors to see which step in a separation-then-proofing workflow caused some concerning color shifts.

Worksheet Layout

The worksheet is composed of 4 horizontal regions:

Workflows

Shows workflow boundaries, delta-E controls

Profiles

The Profiles region is a graphical representation of profiles and their transforms. It includes color-accurate tabs showing color spaces, profile names & icons, rendering intent popup menus and a profile popup menu for changing profiles & setting other parameters. The Profiles region also allows linking of profiles into device link profiles.

Images

The Images region shows 2D images of graphics files or color lists (target layouts). Images can be shown tiled together, singly, sliced for showing the same image detail for each transform or a single image affected by each transform. A dropper tool is available for sampling colors from each transform & delta-E calculations. The target selection marquee will select a grid of points from an image and multiple popular target formats are available. This can be used for sampling target colors from an image & displaying as a list for further processing. Image details are available including resolution, file size, RAM size, EXIF data, and so forth.

Colors

Shows numeric color values in list form along with a color-accurate sample patch that can be sorted by any column. Color values can be displayed using a variety of units (Lab, LCH, XYZ, Yxy, etc). Device values can include total ink value (TAC), spectral values with default to D50, 2 degree calculation. Custom illuminants may be loaded into the software in the Color Setup section.

Hint: The W, P, I and C keys will open or close each region

Region popup menus for workflows, profiles, images and lists

The Colors region contains a handle for changing the width of the “name” column of any color list.