Preliminary
Document
5.2
Results.csv File Format
“Results.CSV” will contain all question information as well as all keypad responses. Each question record will be in
the following format:
Each question record will be formatted as follows:
Question Information
<Question Number (Major)>,[Question Number (Minor)],[Times Voted],[Question
Type],<Correct Answer>,<Text Line 1>,<Text Line 2>,…,<Text Line 12>
Keypad Voting Information (continuation of the same record but separated for readability)
<Keypad Address>,<Response Data>,<Status>,<Serial Number>…Repeated for all 50
keypads…[CR][LF]
Where:
Item Fixed
Length
(Characters)
Description
Question Configuration
Items
Fixed Length
(Characters)
Description
Question Number
(Major)
2 Question
Number
(01-99)
Question Number
(Minor)
1
Re-Vote Number (0 = initial vote, 1=first re-vote, 2=second re-vote,
etc). The limit is 9
Question Type
1
ASCII value representing the question type (same as impromptu list)
Correct Answer
1
Correct answer (numeric keypress expected). For example, if the
correct answer is “True” for a True/False Question, “1” would be listed
as the correct answer.
Text Line N
20
Text string for line N. Data must be exactly 20 characters long for each
line of text. Extra space on each line should be padded with spaces
(hex 0x20).
Keypad Vote Items
Items below repeated for all 50 keypads
Keypad Address
2
Keypad Address (01-50)
Response Data
1
Status
2
Battery status, and other status options TBD
Serial Number
6
Serial Number of the keypad (000000 – FFFFFF)
