Ocean Optics OOIColor User Manual

OOIColor

Color Analysis Worksheet
User's Guide

Version 2.0, January 2001

Offices: East Coast

380 Main Street, Dunedin, Fla., USA

727.733.2447 •• 727.733.3962 Fax
8:30 a.m.-6 p.m. EST

West Coast
5190 Golden Foothill Parkway, El Dorado Hills, Calif., USA

916.939-4300 •• 916.939.4307 Fax
Noon-9 p.m. EST

Ocean Optics B.V. (Europe)
Nieuwgraaf 108 G, 6921 RK DUIVEN, The Netherlands

31-(0)26-3190500 •• 31-(0)26-3190505 Fax

E-mail: [e-mail] (general sales inquiries)

[e-mail] (for sales questions in
Europe)

[e-mail] (questions about orders)
[e-mail] (for technical

support)

Copyright © 1999 Ocean Optics, Inc.

All rights reserved. No part of this publication may be reproduced, stored in a retrieval
system, or transmitted, by any means, electronic, mechanical, photocopying, recording, or
otherwise, without written permission from Ocean Optics, Inc.

This manual shall not, by way of trade or otherwise, be lent, re-sold, hired out or otherwise
circulated without the prior consent of Ocean Optics, Inc. in any form of binding or cover
other than that in which it is published.

Every effort has been made to make this manual as complete and as accurate as possible, but
no warranty or fitness is implied. The information provided is on an “as is” basis. Ocean
Optics, Inc. shall have neither liability nor responsibility to any person or entity with respect
to any loss or damages arising from the information contained in this manual.

Table of Contents

Overview................................................................................................................................ 1

Worksheet Pages................................................................................................................ 2

Color Space and Illuminants......................................................................................... 2

Functions.......................................................................................................................... 2

Globals.............................................................................................................................. 2

Parameters ....................................................................................................................... 2

Coefficients and Intercept........................................................................................... 2

Integration Time........................................................................................................... 3

Sample to Average...................................................................................................... 3

Boxcar Smoothing Width ............................................................................................ 3

Delay Between Acquisitions ....................................................................................... 3

Observer ...................................................................................................................... 3

Illuminant Type ............................................................................................................ 3

Type of Color Measurement....................................................................................... 3

Type of Reference Tile ............................................................................................... 3

Acquisition ....................................................................................................................... 4

Store Reference.......................................................................................................... 4

Store Dark.................................................................................................................... 4

Calibrate Field Tile ...................................................................................................... 4

Start Acquisition........................................................................................................... 4

Stop Acquisition........................................................................................................... 4

Log Value ..................................................................................................................... 4

LAB Graphs and XYZ Graph ......................................................................................... 5

Experiment Tutorial............................................................................................................ 6

Reflective Color – An Overview.................................................................................... 6

Reflective Color Measurements with a White Standard.......................................... 6

Filed Tiles ......................................................................................................................... 7

Emissive Color Measurements..................................................................................... 8

Color Measurements: A Computation Tutorial......................................................... 9

Watch for Free Updates!................................................................................................. 11

Overview

OOIColor is a Microsoft Excel worksheet template, which contains all of the necessary code to
access data directly from our line of miniature fiber optic spectrometers. Coupled with the
appropriate fiber optic probes, the worksheet and spectrometer combination can measure
reflective or emissive color.

The worksheet template operates under Microsoft Excel, version 5.0 or higher. Consult your
Excel documentation or help files for instructions on how to open and use worksheet templates.

Install the software by inserting the floppy disk into your disk drive, and running the
SETUP.EXE program.

OOIColor is intended as both a stand-alone application that is ready to use, as well as a template
for developing your own software. Be sure that you save a copy of the original version of the
worksheet template before you make any modifications.

All data acquisition and analysis is performed within this worksheet. Several color space values
are reported in numeric form: XYZ, xyz, L*u*v*, L*a*b*, W*U*V* and u’v’w’. Graphs are
provided for XYZ and L*a*b* color spaces.

2

Worksheet Pages

Color Space and Illuminants

This worksheet page contains the tristimulus values for CIE1931 and CIE1964 observers as well
as the intensity of the 12 standard CIE illuminants. You should not change these values. When
you calibrate a field tile, or working standard, the reflectivity values are also stored on this page.

Functions

This worksheet page contains the source code for all of the data acquisition from the spectrometers
and processing macros. You are free to change this code as your experiments dictate, as long as
you follow the restrictions contained in the Credits and Copyright worksheet page.

Globals

The macro in this worksheet page defines all of the global variables used in this program.

Parameters

This worksheet page contains all of the parameters necessary for data acquisition and processing:

Coefficients and Intercept

These values are the wavelength calibration coefficients of your spectrometer. They are
obtained from the calibration sheet that accompanied you spectrometer when you received it
from our factory. If you are missing this calibration sheet, please contact us for a free
replacement copy.