Technical data

Chapter 7 93
List Sequencer Spreadsheet Data Entry
Spreadsheet setup
List Sequencer Spreadsheet Data Entry
Spreadsheet setup
Using a spreadsheet to enter data into the Sequence Analyzer, provides a quick and easy way to generate
a tab separated file which is used directly on the test set to set up the source and/or analyzer List
Sequencer.
An example of a spreadsheet, showing an analyzer sequence combined with a source sequence, is shown
in Figure 7-1.
Figure 7-1 Sample spreadsheet
In order to generate a tab separated values file that can be used in the list sequencers, the spreadsheet
layout should adhere to the following rules which can also be seen in the example in Figure 7-1:
• All row entries should start in column 1 (leftmost column).
• All rows that start with a single # are treated as comment rows and are ignored by the list sequencers.
(The optional rows showing the names of the parameters begin with “#”.)
• A row with the string “### Analyzer Parameters ###” in the 1st column marks the start of the
Analyzer List Sequencer parameters.
• The next row contains the parameters for the first acquisition in the sequence (shown in red in the
illustration), and should have the number 1 in column 1.
• The next row contains the parameters for the first analysis step in the acquisition (shown in blue in
the illustration). If there were no analysis steps associated with acquisition 1, then this row would be
replaced by a row containing the parameters for acquisition 2.
• In an analysis step row, the analysis number should start and 1 and increment by 1 for every analysis
step in an acquisition.
• Rows are populated as required using Figure 7-1 as a guide (acquisition number should increment by
1 in column 1 for every acquisition).
• If you are using the test set source list sequencer, then this information appears in the spreadsheet
after the analyzer sequence information.
• A row with the string “### Source Parameters ###” in the 1st column marks the start of the Source
List Sequencer parameters.
• The next row contains the parameters for the first source step, with the number 1 in column 1.