Excel Templates for Process Management Samples6.pdf

About Global Documents

Global Documents provides you with documents from around the globe on a variety of topics for your enjoyment.
Global Documents utilizes edocr for all its document needs due to edocr's wonderful content features. Thousands of professionals and businesses around the globe publish marketing, sales, operations, customer service and financial documents making it easier for prospects and customers to find content.
Measure press key Print Process Control Color Print teach Print Process press enter
Teaching Printing Process Control by Colorimetry
1
    Bob Chung, RIT rycppr@rit.edu
    Wuhui Liu, Wuhan University wuhui_liu@163.com
    IGAEA Annual Conference
July 22-26, 2007, Rochester, New York
Teaching
Printing Process Control
by Colorimetry
Topics
 Introduction (5 min.)
 Printing process control (15 min.)
 Color measurement demo (15 min.)
 X-Rite 530 with ToolCrib
 X-Rite DTP 70 with ColorPort
 Using On-Site Excel templates (10
min.)
 Q/A (5 min.)
Teaching Printing Process Control by Colorimetry
2
Introduction
 Printing has been transformed from craft to
science.
 Print buyers demand quality.
 Color measurement devices are affordable.
 Modern process control techniques are matured.
 Standards-based printing becomes the norm.
 Industry level, e.g., SWOP, GRACoL, SNAP
 International level, e.g., ISO 12647
Introduction
 Printing specifications are about aim points and
tolerances.
 Colorimetry-based specifications are replacing
density-based specifications.
 Parameters used in densitometric conformance
• SID and tonal value increase
• ∆D and ∆TVI
 Parameters used in colorimetric conformance
• ∆E tolerance of CMYKRGB solids
• TVI tolerances
proof
aimpoin
t
X
Teaching Printing Process Control by Colorimetry
3
Motivation
 Print buyers demand a total solution from
content creation to prepress to printing.
 Publishing and packaging
 Here and around the world
 Digital color management integrates prepress
and press together.
 Device characterization requires colorimetry.
 Standard-based printing by colorimetry becomes
the trend.
 There is a need to learn how to teach standard-
based printing by colorimetry in school
curriculum.
Curriculum Emphases
1. Verify that the correct process inks are used
2. Adjust the ink amount to conform to
colorimetric aim points
3. Exercise process control
 Status T density & TVI (CGATS.4)
 ∆E & metric chroma (CGATS.5)
4. Document printing conformance of the press
run by sampling
Teaching Printing Process Control by Colorimetry
4
Equipment and Materials
 
 
Verifying Inks
1. Ink drawdown with a grind gauge block on a
Little Joe proofer
2. Measure colorimetric values over a range of ink
film thicknesses
3. Compute ∆E between sample measurement and
the ISO colorimetric standards (L*/a*/b*)
• K: 16/0/0
• C: 54/-36/-49
• M: 46/72/-5
• Y: 88/-6/90
4. Determine process ink conformance
Details are omitted due to time constraints.
Teaching Printing Process Control by Colorimetry
5
Achieving Printing Aims
 Conduct a press run
• Or having press sheet samples available
 Set solid ink density and colorimetric aim points
 Measure color control bar from press sheets by
IntelliTrax scanning spectral-densitometer
 Switch display to ∆E
 Select the new aim points from ink key with the
minimum ∆E
 Adjust inking until ∆E of all ink keys are in
tolerance
 
It’s possible for pressmen to print to
CIELAB directly.
Color Measurement
 Presses came with dedicated color
measurement sub-systems.
• Heidelberg | KBA
 Third-party color measurement systems
• X-Rite IntelliTrax (pressroom use)
• X-Rite DTP 70 with ColorPort (prepress use)
• X-Rite 530 with ToolCrib (hand-held)
Teaching Printing Process Control by Colorimetry
6
Data Analysis & Process Regulation
 On-site Excel (download instruction below)
 designed to monitor and regulate a sheet-fed offset
printing process to ensure temporal consistency.
 Accept data from a data file or from a color
measurement device directly.
URL:
www.rit.edu/~gravure/
CMS
Excel Templates
Color Repeatability Analysis
u: print | p: rit
On-site Excel
 Data section
 Designed for a fixed number of color patches
 Accept one set of standard and up to 30 sample
data sets
 Accept both status T density and CIELAB values
Patch ID
D v
D r
D g
D b
L *
a *
b *
Standa rd
Zero
0.07
0.07
0.08
0.08
93.5
0.7
0.7
Description:
100%_K
1 .61
1.58
1.63
1.67
17.5
1.5
2.5
1 .61
50%_K
0 .51
0.51
0.51
0.50
62.4
0.2
-0.7
1 .38
3 C_Neutral
1 .00
0.95
0.91
0.97
38.4
-2.8
-0.9
1 .45
7%_K
1 .05
100%_C
0.73
1 .38
0.41
0.20
56.1
-37.9
-47.0
15 .6
10:49 AM
50%_C
0.38
0 .52
0.24
0.15
73.5
-19.0
-24.8
17 .8
7%_C
14 .7
Time: 8:00 am
100%_M
0.68
0.29
1 .45
0.82
46.7
73.9
-0.7
17 .4
50%_M
0.36
0.18
0 .50
0.36
69.6
34.0
-4.5
# N / A
7%_M
# N / A
Temp: 67 F
100%_Y
0.14
0.10
0.19
1 .05
86.2
-2.8
89.4
# N / A
50%_Y
0.11
0.09
0.14
0 .48
89.4
-2.8
44.4
# N / A
7%_Y
Gray
3 . 0
Humid: 53
Green
0.81
1.37
0.49
1.03
49.9
-66.7
26.1
Red
0.68
0.29
1.45
1.52
46.0
69.2
45.2
Blue
1.41
1.34
1.33
0.76
24.7
18.3
-43.3
First sheet of long 
term samples Oked by 
Ken; All densities 
were measured wet.
Aim point
D_100%DG_50%DG_7%
Teaching Printing Process Control by Colorimetry
7
On-site Process Control
 Temporal consistency—∆ of solids and TVIs
On-site Process Control
 Temporal consistency—∆C* of chromatic grays
Teaching Printing Process Control by Colorimetry
8
On-site Quality Assurance
 CP & CpK of solid ink densities (CMYK) and CP
& CpK of 50% TVI
SID
Dv (K)
Dr (C)
Dg (M)
Db (Y)
Aim point
1.61
1.38
1.45
1.05
Tolerance
0.2
0.2
0.2
0.2
Average
1.65
1.34
1.47
1.05
s
0.049
0.046
0.028
0.019
CP
0.68
0.73
1.18
1.73
(x-LSL)/3s
0.94
0.46
1.41
1.75
(USL-x)/3s
0.43
1.00
0.96
1.70
CpK
0.43
0.46
0.96
1.70
TVI
Dv (K)
Dr (C)
Dg (M)
Db (Y)
Aim point
15.58
17.84
14.74
17.41
Tolerance
6.00
6.00
6.00
6.00
Average
17.03
17.96
15.90
17.16
s
1.167
1.050
1.104
1.211
CP
0.86
0.95
0.91
0.83
(x-LSL)/3s
1.27
0.99
1.25
0.76
(USL-x)/3s
0.44
0.92
0.56
0.90
CpK
0.44
0.92
0.56
0.76
On-site Quality Assurance
 Measure CMY gray at a specific location of the
press sheet over time.
 Plot all data points in the a*b* diagram.
 Temporal consistency is indicated by the spread
of the data.
Teaching Printing Process Control by Colorimetry
9
Conclusions

Implementing standard-based printing
 Begins with material conformance verification
and process control.
• Use ISO compliant inks and correct grade of paper
• Use color measurement and process know-how for
process regulation
 Ends with documented conformance of the entire
press run.
 Teaching standards-based printing requires
 Knowledge of colorimertry and standards
 Press and color measurement equipment
 Hands-on learning and comprehension
Q/A
Thank You for Your Attention.
Using X-Rite 530 Spectrodensitometer 
 
Date Last Updated:  June 22, 2007 
 
 
1. Purpose:  
The purpose of this document is to assist the user in setting up the X-Rite 
530 Spectrodensitometer, and to use the X-Rite ToolCrib application for 
automated data collection.  
This standard operating procedure assumes basic knowledge of the 
Mac OS X operating system, Microsoft Excel, and the X-Rite 530 
Spectrodensitometer. See the 500 Series Spectrodensitometer Quick Help 
Guide for instructions on using the 530. 
 
2. Equipment and Materials Needed: 
2.1. X-Rite 530 Spectrodensitometer with interface cable 
X-Rite ToolCrib 4.1.0.15 
Apple Computer running Mac OS X 
Data entry and analysis application. (E.g. Excel) 
Keyspan USB Twin Serial Adapter (pn# USA-28x) 
 
3. Navigation, Function Screen, and Calibration Procedure 
3.1. Navigation Keys: 
 
Figure 1: Navigation Keys 
 
 
 
 
3.2. Function Screen: 
 
Figure 2: Function Screen 
 
3.3. Calibration Procedure: 
3.3.1. Press Main Menu key
to access Measurement list. 
3.3.2. Use Tab or key and scroll to Calibration in Measurement 
list. 
3.3.3. Press enter
to access Calibration function. User Dialog 
will prompt Measure White. 
3.3.4. Place instrument in shoe and measure white patch. User 
Dialog will indicate calibration Completed. 
 
4. Interfacing X-Rite 530 with X-Rite ToolCrib 
4.1. Procedure: Calibrate device prior to connecting 
4.2. Connecting X-Rite 530 to the host computer: 
4.2.1. Plug the keyspan into a USB port on the computer. 
4.2.2. Plug the X-Rite 530 interface cable into serial port 1 on the 
keyspan. 
4.2.3. Plug the X-Rite 530 interface cable into the interface port 
on the 530. 
4.3. Launching the applications: 
4.3.1. Launch the ToolCrib application. The application icon 
should be in the Dock, if not, the application install path is: 
CIAS HD: Applications: CMS: ToolCrib 
4.3.2. Launch Microsoft Excel 2004 or other desired data analysis 
software. 
4.4. Configuring ToolCrib Instrument Connection Parameters: 
 
Figure 3: Connection Parameters  
4.4.1. Set the Instrument parameter to 500 Series. 
4.4.2. Set the Protocol parameter to RCI 
4.4.3. The Serial 
Port 
parameter 
should 
be 
set 
to 
/dev/cu.USA28X1b1P1.1 
4.4.4. The BaudRate parameter should be set to 9600. 
4.4.5. Select the Connect button. 
4.5. ToolCrib Instrument Configuration Tab Setup: 
 
Figure 4: ToolCrib application window displaying the Instrument Configuration tab. 
4.5.1. These 
settings 
are 
located under 
the 
Instrument 
Configuration subsection. 
4.5.2. The Baud Rate parameter should be set to 9600. 
4.5.3. The Protocol parameter should be set to RCI. 
4.5.4. The Personality parameter should be set to Normal. 
4.5.5. The Delimiter parameter should be set to CR&LF. 
4.5.6. The Separator parameter should be set to Tab. 
4.5.7. The Auto XMT parameter must be set to On with 
spreadsheet filtering. Select the X-Key button. (Figure 5) 
 
Figure 5: X-Key Button 
4.5.8. In X-Key, set separator to Enter  
 
Figure 6: Input Text Separation 
4.5.9. ToolCrib will now transfer instrument data to the foremost 
application. 
Note: ToolCrib will only transfer the data that is displayed on the device 
window. Eg. Density or CIELAB; but not both. Place cursor in Excel. 
(Leave X-Key running in background) Make measurements. (Data 
sequence mimics device (KCMY) 
 
5. Density Measurement—CMYK (Absolute) 
 
 
Figure 7: Density Options in XRite 530 
5.1. Press Main Menu key
to access Measurement list.  
5.2. Use Tab or
key and scroll to Density in Measurement list.  
5.3. Press enter
to access Density function.  
5.4. Once in Density function use Tab or keys to highlight Options 
in upper right of the Function Screen.  
5.5. Press enter
to access Density Options.   
5.6. Use Tab or
key and scroll to Color. Press enter to select 
Color and use Tab or keys to scroll through options. 
5.7. Select All and enter
  
5.8. Press Escape key
    
5.9. Use Tab or
key and scroll to Mode. Press enter to select 
Mode and use Tab or keys to scroll through options. 
5.10. Select Absolute and enter
 
5.11. Press Escape key
 
5.12. Use Tab or
key and scroll to Reference. Press enter
to 
select Reference and use Tab or
keys to scroll through options.  
5.13. Select Auto and enter
 
5.14. Press Escape key
and start measurements. 
 
 
 
 
 
6. L*a*b* Measurement 
 
 
Figure 8: Color Measurement Options 
6.1. Press Main Menu key
to access Measurement list.  
6.2. Use Tab or
key and scroll to Color in Measurement list.  
6.3. Press enter
to access Color function.  
6.4. Once in Color function, use Tab or
keys to highlight Options 
in upper right of the Function Screen.  
6.5. Press enter   to access color Options.  
6.6. Use Tab or
key and scroll to Color Space. Press enter
to 
select Color Space and use Tab or
keys to scroll through 
options.  
6.7. Press enter
to select L*a*b*.  
6.8. Press Escape key
and start measurements. 
 
7. Spectral Reflectance Measurement: 
 
 
Figure 9: Spectral Reflectance Options 
7.1. Press Main Menu key
to access Measurement list. 
7.2. Use Tab or
key and scroll to Density in Measurement list.  
7.3. Press enter
to access Color function.  
7.4. Once in Color function use Tab or
keys to highlight Options 
in upper right of the Function Screen.  
  
7.5. Press enter
to access color Options.  
7.6. Use Tab or
key and scroll to Color Space. Press enter   to 
select Color Space and use Tab or
keys to scroll through 
options.  
7.7. Press enter   to select Reflectance.  
7.8. Press Escape key
and start measurements. 
7.9. Spectral reflectance is measured in 10nm increments from 
400nm to 700nm.  
Note: Reflectance values are reported as percentages to convert to a 
fractional amount divide by 100. For example: 3.27% is 0.0327  
7.10. If using ToolCrib to automatically enter data into an Excel 
spreadsheet, data will only enter as percentages—the conversion 
must be done in Excel. 
 
8. Related Reading: 
 
500 Series Spectrodensitometer Quick Help Guide: 
www.xrite.com/documents/manuals/en/528-
00_500_Series_Operators_ Manual_en.pdf 
 
www.measureitrite.com 
Using ColorPort with X-Rite DTP 70 
 
Date Last Updated:  July 18, 2007 
 
1. Purpose 
The purpose of this document is to assist the user to use the ColorPort 1.5.4 
application to measure test target, e.g., IT8.7/4, and generate color data with DTP 70.  
This standard operating procedure assumes basic knowledge of the Mac OS X 
operating system, test target, print file format. 
 
2. Equipment and Materials Needed 
• Measurement hardware: X-Rite DTP 70 
• Measurement software: ColorPort 1.5.4  
 
3. Procedure 
 
1. Switch on DTP 70. The power button is on the left side of device’ back. 
2. Launch ColorPort 1.5.4. There are two main menus, one is Create Target, the 
other is Measure Target. Create Target is to create test target samples that 
will be printed measured. 
3. Go to Create Target and set Measurement Device, Color space, Patch set, 
paper size in figure 1. In Measurement Device, you should choose X-Rite 
DTP 70 from the device list. In Color space you should choose CMYK color 
space. In Patch Set, you can choose an existed test target patch setting, you 
also can create a custom test target. In paper size, you can change the size of 
printing paper and color patches layout. 
 
Figure 1. The ‘Create Target’ function in ColorPort  
                     The method to create a custom target is: 
   In figure 2, Press New, go to Customize as shown in figure 3.  Here you can 
set your own target by inputting CMYK value into the blank.  Give the target 
a name and save it, a custom target is been set. You also can import a 
measured data file to create a new target by pressing Import Patches in 
figure3. 
 
Figure 2. Patch set options 
 
Figure 3. Customize function 
    After all parameters in figure 1 are set, press Save Target in  to save test target. 
It will save the test target as a Tiff image.  
4. Print test target image, and cut paper along the dotted line. 
5. Go to Measure Target as shown as in figure 4. Firstly, choose the target you 
want to measure; then select the measurement device and connect. After 
device DTP 70 is connected. You can input your printed target into device in 
the direction of the arrow, Press the yellow button on DTP 70, it will begin to 
work. 
 
Figure 4. Measure target function 
 
6. After finishing measurement, Press Save Data  in figure 4 to save. There are 
several formats of data, we suggest to save data in CGATS format, and 
spectral range in 380nm-780nm. 
 
Figure 5. Data format options 
7.  Press Clear Data in Figure 4, you can begin a new measurement.