Turning Technologies TurningPoint - Manual (Page 207)

TurningPoint for Office 2003 User Guide 207
Parser Documents
Format Excel Documents
You can format an Excel spreadsheet so that it can be used with the TurningPoint Parser. The TurningPoint
Parser will only use the data displayed in the first sheet of an Excel Workbook to create question slides.
Figure 3-1 displays a sample Excel spreadsheet that contains information to create four TurningPoint
slides.
Figure 3-1
Figure 3-1 displays four questions and their corresponding answers. Column A contains Question Text,
columns B through K may contain Answer Text, and all columns that follow after column K are ignored by
the TurningPoint Parser. The text does not have to be in any specific font. If you want to use Questions and
Answers only, there must be a blank line after each Answer row. If you wish to use tags, use one row for the
Question and Answer Text, one row for all of the tags (multiple tags are allowed per cell, see cell D3 in
Figure 3-1), and one blank row below the tags. Make sure to include only one blank row between each tag
row and the following Question row. As soon as the TurningPoint Parser detects two blank rows, it will
stop searching for text.
The spreadsheet also contains several TurningPoint tags that allow the TurningPoint Parser to process
additional information about the format of slides. A detailed listing of the TurningPoint tags and how they
are used in figure 3-1 is shown below in figure 3-2. This table explains how the tags are used to format
interactive slides. The tags are not case sensitive.
Figure 3-2
Tag Cell # Description and Allowed Values
<d> A1 Session ID
A2, or any
untagged row in
column A Question Text
<a> A6, or directly
below any
Question Text Question Alias Text