# Profile Job Panel

The Profile 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. panel illustrates cell dependencies and execution times for any cell in the active job that contains formulas or data. The Profile Job table excludes cells containing text and fixed numbers. Dependencies and execution times are most useful while trying to improve spreadsheet performance, because the functions that take the most time to execute can be easily identified for possible optimization. The Profile Job dialog is also helpful when you want to find the formulas or functions that cause errors and return (#ERR) in an In-Sight job.

Enable the Profile Job panel by clicking the View menu and selecting Profile Job.

You can select multiple rows in the table using Ctrl or Shift and click, or Ctrl+A to select all. When you select multiple rows, the total time label changes to Selected Time and displays the combined execution time for the selected cells. You can also copy and paste the current selection into a document or spreadsheet using Ctrl+C and Ctrl+V, or by right-clicking and selecting Copy.

Note:

Keep the following in mind:

- Execution times for identical jobs running on different In-Sight vision systems models and In-Sight emulators vary according to the processing capabilities of the respective systems and the image resolution.

- The Profile Job dialog calculates time differently than the status bar and the GetAllTime function Functions are tools that are available in Spreadsheet for processing and analyzing acquisitions or other results. You can add functions to your Spreadsheet job to create tool chains and produce results for specific applications.. The Time (ms) column in the Profile Job dialog also accounts for the construction of result graphics, while the other two do not.

Number | Description
1 | In the View menu, you can change the layout of the Profile Job table: Only Show Tools: Filters the table to only show cells that return data structures such as vision tools. Show Dependencies: Displays a table showing all cells that reference or are referenced by the selected cell. Click a cell in the Profile Job table to see the dependencies. Columns: Filters which columns are visible in the Profile Job table.
2 | In the Settings menu, you can enable the following: Click Auto Clear All Results to show only the results from the most recent spreadsheet run. Click Selection Sync to control how focus is synchronized between the spreadsheet and the Profile Job table. You can choose from the following: Off: Synchronization between the spreadsheet cells and the table rows is completely disabled. Spreadsheet to Table: Selecting a cell in the spreadsheet highlights the corresponding row in the Profile Job table but not the other way around. Table to Spreadsheet: Selecting a row in the Profile Job table highlights the corresponding cell in the spreadsheet, but not the other way around. Bidirectional: Selecting either a spreadsheet cell or a table row highlights the corresponding item in both views.
3 | Click Clear All Results to remove all results from the table. Use this to reset the table before a new run or analysis.
4 | The table columns are the following: Order: Sequence number of the cell that indicates when the job executes the cell in order. For example, 1 indicates that the cell is executed first, 5 indicates that the cell is executed fifth. Cell: Shows the location of the cell in the spreadsheet. Expression: Shows the expression or formula that defines the function of the cell. Time (ms): Shows the total execution time in milliseconds, including both tool and graphics time. Result: Shows the current output value of the cell. Enabled: Indicates the Cell State for each cell. Tool Time (ms): Shows the execution time of the tool cell in milliseconds without the graphics. Graphics Time (ms): Shows the execution time in milliseconds to calculate and render graphics for the cell. Name: Shows the assigned name of the cell.
5 | The dependency table shows all cells that reference or are referenced by the selected cell. Click a row in the Profile Job table to see the dependencies. You can increase or decrease the level of dependency by clicking the Plus or Minus buttons, or click Show All to see all levels of dependencies.