General Concepts for Spreadsheet

In-Sight Spreadsheet is an advanced job A job is a user-configured program in In-Sight Spreadsheet consisting of functions and designed for specific applications. You can create and edit jobs using the In-Sight Spreadsheet interface, and load them on a vision system for deployment in a live environment. development tool that allows you to configure complex jobs on your In-Sight vision system.

A job is a set of vision tools configured for a specific machine vision application, stored as a job file.

To begin using Spreadsheet, you can import prerecorded test filmstrips using the Filmstrip, or set up your camera acquisitions using the Acquisition Panel. Once you have images loaded into the Filmstrip, double-click on the image you want to use for setting up your vision tools.

Spreadsheet provides you with a wide array of functions and a flexible tabular interface for configuring jobs on your vision system. For a list of functions available in Spreadsheet, see Spreadsheet Toolbox.

You can add functions to your job in the following ways:

When you first add a function to Spreadsheet, the Property Sheet pop-up dialog appears, where you can configure the function parameters according to your needs.

Note: Some advanced functions do not have a Property Sheet dialog, and require manual input parameters.

Once you have configured the function, the cell executes and produces output data in the neighboring cells. You can reference the output cells of functions as input for other functions or in custom formulas. For more information, see Cell References.

The following sections provide more information on Spreadsheet tools and logic.