Spreadsheets

The DATA mode displays your fixture information in spreadsheet format. WYSIWYG compiles many spreadsheets that are accessible from the columns shortcut bar. All of these spreadsheets contain the same information, but are sorted and filtered differently. Each column in the spreadsheet represents one fixture attribute. The following information is compiled.

DATA mode also displays your rigging point information in spreadsheet format. For more information on rigging point spreadsheets, see Rigging point spreadsheet.

Data fields

Notes:

Spot - This is an assigned identifier number usually used for automated fixtures. A spot number is required for automated fixtures when using AutoFocus.

Channel - This is the assigned control channel number you will use at your control console to control the fixture. For moving lights, the channel number recorded in WYSIWYG is the starting channel number.

Data fields

DataFields-spreadsheet.png 

Working in the spreadsheet

Data may be entered in a number of ways within the WYSIWYG file. The plot can be created, and then edited, or the data may be entered in a spreadsheet, and then placed on the plot. Any entries or changes are reciprocated throughout the file; changes made in DATA mode will be updated in CAD mode and vice versa.

Selection

Standard selection functionality is offered in the DATA > Spreadsheets. Selected cells are highlighted in orange.

SelectEntireRow-spreadsheet.png 

To add or modify data

Select a cell, and type the desired value in the appropriate cell. Notice that some cells accept text (e.g. Channel column), so you click on them and start typing text. Some cells will display a drop-down list when they are selected, so you can choose your data from the drop-down list or type the desired option (e.g. Lens column).

The Spreadsheet has built in intelligence, and will not accept invalid data entry. For example, you cannot enter non-numerical data in the Channel column, (it will display an error message).

Columns that are read-only or non-editable cannot be modified from the Spreadsheet. These columns may be tinted slightly darker for easy identification from the View Options.

Entering the same data into multiple cells

You can enter the same information to multiple cells at the same time by selecting a series of cells, typing your text in the first cell selected, and then pressing the ENTER button. You can also delete data in multiple cells at the same time by selecting the cells, and then pressing the DELETE button.

When entering data in some columns (such as Color and Gobo), a drop-down list will appear displaying some options to help you enter the data into the cell(s). For the Color column, for instance:

Listpreviousgel.png 

To input sequential numerical data

If you are entering sequential numerical values for a field such as Channel or Spot, you can use incremental data entry to facilitate your work. WYSIWYG will calculate the next available value based on the number of required channels for the previous fixture.

  1. In a column, select a series of fixtures to enter incremental data, by using a selection method such as click and drag.
  2. Enter in the first cell the starting value of the data, and then a plus sign ( + ).

Example: If the first channel in the selected fixtures should be 101, enter “101 +” and then press ENTER.

To assign sequential patch to fixtures

If you are assigning a sequential patch for a list of fixtures, you can use incremental data entry to facilitate your work. WYSIWYG will calculate the next available value based on the number of required channels for the previous fixture.

  1. Select the fixtures you want to patch sequentially.
  2. In the first cell type “UniverseName. Starting Address +” 

Example: “F.1 +”

Note: You can skip channels between the patching of one fixture to the next. To specify the number of channels that should be skipped, add that number to the end of the equation “UniverseName . Starting Address + [# of channels to skip between patching]”.

Example: “F.1 + 4”

  1. Hit Enter.

Result: The selected fixtures are automatically sequentially patched.

 

Fixtures selected for multi-fixture sequential patching. The example used is "F.1 +".

After performing the multi-fixture patching command, the fixtures are patched sequentially.
To choose a new value
  1. Select the appropriate cell.
  2. If values are available, there will be a drop-down arrow in the cell. Click the drop-down arrow to display the list of available values.
  3. Select the value from the drop-down list.

Result: The cell changes to the selected value.

Inserting fixtures in data mode

Any fixtures inserted in DATA mode are assigned the status “unhung” and are placed in the Flight Case. The Flight Case allows you to drag and drop “unhung” fixtures onto your drawing. For more information about the Flight Case, see The Flight Case.

To insert fixtures in data mode
  1. Click the Fixture tool on the Data toolbar.

inset_1.jpgThe Fixture button.

  1. Navigate to the desired fixture.
  2. In the Multiple box, type the number of fixtures of that type required.
  3. Click Insert.

Result: The fixtures are inserted below the last entry in the spreadsheet.

Tip: If you have a shortcut created for the desired fixture, you can right-click on the shortcut and choose Insert or Insert Multiple.

Inserting positions in data mode

A position cannot exist in WYSIWYG unless it is recorded in the Position Manager. You can if you type a new value into the position field of a fixture, the Pick a value from the list dialog box is automatically displayed. This is because a position cannot exist in WYSIWYG unless it is recorded in the Position Manager. You can select from the list of positions that already exist or you can click Managers menu to open the Position Manager to create a new position.

If you are making this change to a fixture that was previously hung on a different position, that fixture will be unhung and sent to the Flight Case under its new position field. From there, you can drag it back onto the drawing.

If the position does not yet exist in the drawing, you must draw a hang structure and assign it the appropriate position name before you will be able to hang the fixture again. For more information on drawing hang structures, see Hang structures.

For more information on drawing items from the Flight Case, see Entering and modifying objects in the Flight Case.

Inserting color in data mode

To insert color in data mode
  1. Click in the color field of the fixture for which you want to assign color.
  2. Click the drop-down list in the cell and select either None, Multiple Gel Input..., or Pick from Library.

Note:  If you know the catalog code for the gel, you can type the gel code in the cell to choose it. For example, if you want Rosco's "Roscolux Light Red" gel, type "R26" in the cell and hit ENTER. Rosco's "Roscolux Light Red" gel will be selected.

  1. Use Pick from Library to select a color among those you have already used in your plot. Selecting this option will bring up the Color Select window where you can locate the color you want from a library.

ColorSelect-Data.png 

  1. Use Multiple Gel Input... if you already know the color that you want to assign (for example, R54, L112, and so on). Selecting this option will bring up the Multiple Gel Input... window where you can enter the color you want.

MultipleGelInput.png 

WYSIWYG accommodates multiple color entries for one fixture as follows:

Customizing spreadsheets

There are different ways to sort and view your data. You can modify a spreadsheet to suit your needs. Customizing a view allows you to change how the data is displayed and sorted.

To modify a data sheet
  1. From the Options menu, choose View Options.

Result: The View Options window appears.

Tip: You can also click the View Options tool on the Standard toolbar.

inset_0.jpgThe View Options button.

Note: You can also right-click on the Spreadsheet shortcut and select Properties.

  1. In the General tab, specify how the data sheet will be displayed.
  2. In the Data Options tab, specify the information that will be displayed in the data sheet.
  3. Click OK.

General tab

Options on the General tab affect the current data sheet.

ViewOptionsGeneral-Spreadsheet.png 

Scene

Appearance Options

Display Options

Data Options tab

ViewOptionsDataOptions.png 

Detail Level

Column Options

Sort Options

Font options

To display the Spreadsheet with your preferred font settings, right-click on the Spreadsheet and select Set Font. Choose your preferred font, style, color, size, and script, and click OK. The text in the Spreadsheet is now displayed with your new font settings.

AllData-FontOptions-Data.png 

Column heading

Some column options are also listed if you right-click on the column heading.

Filter bar

When enabled, the Filter Bar appears on the first row of the Spreadsheet. The Filter Bar offers an easy way to filter the Spreadsheet or search for exact text or fixtures in any column. The Filter Bar accepts text in multiple columns simultaneously making it easier to find a fixture in your Spreadsheet.

Note: To clear a filter string, you can click the X button which appears at the right side of the column. If you have multiple filters, you can click the X button which is located above the row headers (very far left column with row numbers), and this clears all filter strings and displays all rows in the Spreadsheet are displayed again.

To apply a data filter using the filter bar
  1. In the spreadsheet, click the filter bar on the column you want to filter.
  2. Type the specific text, or select the data from a drop-down menu you want to filter for.

Result: The spreadsheet refreshes, displaying only fixtures that meet the filter criteria.

To remove data filters

In the spreadsheet, click the X button which appears at the right side of the column.

Note: If you have multiple filters, you can click the X button which is located above the row headers (very far left column with row numbers), and this clears all filter strings and displays all rows in the Spreadsheet are displayed again.

Result: The spreadsheet returns to its unfiltered state.

Finding and replacing text in the spreadsheet

Information found in cells can be quickly accessed and edited using the Find or the Find and Replace functions. Find allows you to search your spreadsheet for words or whole phrases, then selects the words when found. Find and Replace searches your spreadsheet the same as Find, but with the additional option to replace the words.

To find text in the spreadsheet
  1. From the Edit menu, choose Find.
  2. Alternately, you can use the shortcut CTRL+F.

Result: The Find dialog box appears.

Find-Spreadsheet.png 

  1. In the Find what field, type the text you want to search for.
  2. Select the Match case checkbox to search for only words that match the exact case of the text entered in the Find what field.
  3. In the Direction section, select Up or Down to search the spreadsheet in the chosen direction.
  4. To search for the next instance of the chosen text, click Find Next.
To find and replace text in the spreadsheet
  1. From the Edit menu, choose Find and Replace.
  2. Alternately, you can use the shortcut CTRL+SHIFT+H.

Result: The Replace dialog box appears.

Replace-Spreadsheet.png 

  1. In the Find what field, type the text you want to search for.
  2. In the Replace with field, type the text you want to replace any found text with.
  3. Select the Match case checkbox to search for only words that match the exact case of the text entered in the Find what field.
  4. To search for the next instance of the chosen text, click Find Next.
  5. To replace found text with the text written in the Replace with field, click Replace.
  6. To replace all instances of the found text with the text written in the Replace with field, click Replace All.

Grouping the spreadsheet by a column

The group by option is available for the Column in Key 1 sort, which groups the Spreadsheet into sections. Each section has a button which expands (+) and collapses (-) so you can choose if you wish to displays the rows of data in a group or not.

AllData-Group-Spreadsheet.png 

Freezing spreadsheet columns

The Freezing Column options allows you to keep your information in place as you scroll through the rest of the spreadsheet. This is useful if the spreadsheet is very large and you have headings that you want to stay in place.

To freeze spreadsheet columns

Right-click a column header, and select Freeze Columns.

To unfreeze spreadsheet columns

Right-click a column header, and select Unfreeze Columns.

Creating a new spreadsheet

To create a new sheet
  1. On the shortcut bar, click the Columns tab.
  2. Right-click on the shortcut bar and choose New Spreadsheet.

Result: The Enter new Spreadsheet name dialog box appears.

EnternewSpreadsheetname.png 

  1. In the Name box, type a name for the new spreadsheet.
  2. From the Spreadsheet Type drop-down list, click Fixtures or Rigging Point.
  3. Click OK.
  4. Scroll to the bottom of the list of Column shortcuts. Your new spreadsheet name should be at the bottom of the list. Click on the shortcut to view your spreadsheet.

Note: It may be easier to clone an existing spreadsheet and modify it than to start a new one from scratch. See To clone a shortcut for more details.

Exporting a spreadsheet

The Spreadsheet can be exported to numerous formats, in case you wish to use the spreadsheet data from you lighting show in a different program.

To export a spreadsheet
  1. Select File > Export.
  2. An Export File dialog box appears for you to enter a file name, and select a file type. Supported file types include: Microsoft Excel (.xlsx) and (.xls), HTML (.htm), Comma Separated Values (.csv), WYSIWYG Spreadsheet (.wss)
  3. Another option in the File menu is to Export to Worksheet. This option automatically copies a snapshot of the Spreadsheet into the Worksheet tab. This is convenient at the end of a project, because a worksheet can be inserted into a Layout (a Spreadsheet cannot be inserted directly anymore).

Rigging point spreadsheet

DATA mode displays information of all your Rigging Points in spreadsheet format. Each Rigging Point in your plot appears as a separate row in the Rigging Point spreadsheet, while attributes appear as columns.

The following attributes appear as columns in the Rigging Point spreadsheet:

Tip: You can rename these columns with more useful titles via the Spreadsheet’s View Options > Data Options tab. For more information, see Data Options tab.

Rigging Point spreadsheets work the same as the Spreadsheet with fixture data. Follow the steps in the reference sections corresponding to the following list of operations.

Working in the spreadsheet

Customizing spreadsheets

Filter bar

Finding and replacing text in the spreadsheet

Finding and replacing text in the spreadsheet

Grouping the spreadsheet by a column

Freezing spreadsheet columns

Exporting a spreadsheet

To rename a rigging point in spreadsheet
  1. On the Rigging Point spreadsheet, click in the Name cell.
  2. Type the new name.

Note: The new name must be unique.

  1. On your keyboard, press Enter or click on the spreadsheet off the Name cell.

Result: The name of the selected Rigging Point changes.

To rename multiple rigging points in spreadsheet

Follow the steps in the section To input sequential numerical data.

Note: The selected Rigging Points must have unique names and must end in a number. You cannot use one name for all the multiple selected Rigging Points.

Result: The name of the multiple Rigging Points changes.

To change type/bridle/position in spreadsheet

Follow the steps in the section To choose a new value.

Note: When multiple cells are selected on the Type or Bridle column, you can change the Type or Bridle values for all the selected Rigging Points.

To change X, Y, or Z of rigging points in spreadsheet
  1. On the Rigging Point spreadsheet, click in the X, Y, or Z cell you want to change.
  2. In the selected cell, type the new coordinate and related unit symbol or letter.
  3. On your keyboard, press Enter or click on the spreadsheet off the selected cell.

Tip: Enter the coordinates in the same way as you enter coordinates in the Position Tool.

Result: The selected Rigging Point’s location changes.

Note: Multiple cells selection.

To change capacity and load in spreadsheet
  1. On the Rigging Point spreadsheet, click in the cell.

Result: The unit (lbs, kg, or t) disappears but will reappear after keyboard Enter is pressed.

  1. In the selected cell, type the new number.

Note: Only numbers can be entered.

  1. On your keyboard, press Enter or click on the spreadsheet off the selected cell.

Result: The capacity or load of the selected Rigging Point changes.

Note: Multiple cells selection.