Spreadsheet Editor

The Spreadsheet Editor is used to configure and program an In-Sight® vision system. The spreadsheet is analogous to other spreadsheet applications in terms of its standard operations and functionality, such as manipulating blocks of cells, editing cells, referencing cells and inserting functions. It consists of the following parts:

Number Description

1

The Recipe Manager, used to configure recipes within the spreadsheet.

2

The spreadsheet, where functions are added and logic is created.

3

The In-Sight Toolbox, which provides drag-and-drop access to the Vision Tools and spreadsheet functions.

4

The Properties tab of the spreadsheet cells.

Organized into a table of cells arranged in 400 rows (numbered 0 to 399) and 26 columns (labeled A to Z), each cell is identified by its column letter and row number; for example, cell A2 is located at the intersection of column A and row 2.

The spreadsheet is configured one cell at a time. The contents of each cell are defined as a formula, and any piece of information inserted into a cell (whether a single numeric value or a complex vision processing function) is considered a part of the formula.

When you highlight a cell, it becomes outlined in black and the information in the cell is displayed in the Formula Bar of the Job Edit toolbar. Clicking on a cell automatically makes it the active cell.

Note: Right-clicking within the spreadsheet displays a shortcut menu that allows you to perform various spreadsheet operations.