User guide
×
Menu
Index

Google Drive Spreadsheets

 
The free Google Drive Spreadsheet cloud service is used for creating and modifying configuration files.  When a new configuration is ready to be loaded into the Quadstick, the user selects a menu command that converts the spreadsheet into a CSV file and downloads it into the Quadstick flash drive or uses the QuadStick Manager Program download function.
 
Each profile mode within a Configuration spreadsheet file is on a separate “sheet”. The sheets are associated with tabs along the bottom of the spreadsheet page. Profiles are numbered, starting with 1, in the order in which their tabs appear from left to right.  The active profile mode number displays on the status LEDs when the profile is changed or when the Quadstick is idle.
 
As shown on the following pages, the columns and rows in a profile sheet follow a fixed layout.  The Outputs are in the leftmost column, followed by an Output Function selection and then the Input(s) that control the Output.  The Inputs for a row may be either a single input or a sequence of up to eight inputs.  By default there can be 128 rows which have a single input, but optionally by reducing the number of rows to 64, a sequence of up to eight inputs may be used. Later, in a Keyboard configuration, we show how the optional sequential input columns are employed for pattern matching.
 
The Default Configuration file is available at: http:// demo. quadstick.com/ (in order to see and try the QuadStick menu commands, it is necessary to log in with a Google account, make a copy of the  spreadsheet and grant permission to run the scripts).
 
Elements that make up a Configuration Mode sheet.
 
 
 
Google Drive Spreadsheets
1

Name of Spreadsheet

1. Name of Spreadsheet
This is usually the name of the game or descriptive of the configuration's purpose.
2

Type of sheet

2. Type of sheet
Drop down list with "Profile Name", "Preferences", and "Infrared".  The contents of the cell must be from that list.  Any other text will break the configuration file.
3

CSV filename

3. CSV filename
Cell A2 of the first sheet contains the name of the text file that actually goes into the Quadstick's flash.  The Quadstick sorts the names of its configuration files alphanumerically, with the exceptions that "default.csv" is always first, and "prefs.csv" is not a game configuration file.  The file name must be of the format "something.csv".   Only cell A2 of the first sheet controls the CSV filename.  The A2 cell on other sheets is ignored.   If the format of the filename is wrong, the cell will turn Red.
4

Console Controls Name Group

4. Console Controls Name Group
The names used for the outputs and be from either the Playstation or XBox button naming conventions.     If this value is changed, all the button names will be updated to match, which can take a few minutes.
5

Output Names

5. Output Names
Dropdown list of the available output names.  The first row with a blank Output Name will terminate the sheet.  Any contents following the first blank row can break the configuration file.
6

Output Function

6. Output Function
Controls how the Input's status effects the Output.
7

Input Names

7. Input Names
Dropdown list of available Input values.  A list of unused inputs can be displayed by using the "Add-ons->Quadstick->List unused inputs" menu command.  While the Unused Inputs list is open, selecting any input will highlight other uses of the same input.
8

Communication Channel

8. Communication Channel
The data from the sheet can be routed out through either the USB channel or Bluetooth channel (or both).  This is primarily used when the Bluetooth module is configured as a mouse for a PC. 
9

Comment Area

9. Comment Area
Any column after J is not part of the configuration and can be used for comments. 
10

Mode Sheet Name

10. Mode Sheet Name
Descriptive name of the sheet.  Only "Reference Card" is reserved.  The position of the sheet determines the number of the mode it is for.