Matt Weiner wrote:What would be the difficulty of adding an "SQBSify" button to a sheet that spits out its results in the text-based encoding that SQBS .dat files use, into, say, a centralized Google Doc that you can then save as such a file to have your stats done by robot?
For the moment, I'm ignoring all the stuff at the front and back of the SQBS file, some of which I've figured out and some of which I haven't.
For each game, SQBS records the results as follows:
[Game ID]
[number of team on left - SQBS tracks teams by number; for instance 0 is the first team entered in the Team Entry box]
[number of team on right]
[score of team on left]
[score of team on right]
[tossups heard - this is set to zero if SQBS does not keep track of it]
[round number]
[number of bonuses heard by team on left]
[number of bonus points scored by team on left]
[number of bonuses heard by team on right]
[number of bonus points scored by team on right]
[up to nine? lines of zeros; this appears to have something to do with bonus conversion tracking settings but I haven't figured it out yet. For automatic bonus tracking without bouncebacks, it's six lines of zeros. For no bonuses (tossups-only), there are no lines of zeros.]
{[number to indicate Player on Team Left, e.g., 0 to indicate Player #1, 1 to indicate Player #2, etc.; -1 is used to indicate the absence of a player in that position - I believe these numbers refer to the order in which the players are listed on the roster, but I'm not 100% sure]
[games played (<= 1) by corresponding player on Team Left]
[powers scored by corresponding player on Team Left]
[tossups scored by corresponding player on Team Left]
[negs scored by corresponding player on Team Left]
[custom point value tossups scored by corresponding player on Team Left]
[total points scored by corresponding player on Team Left]
[number to indicate Player on Team Right]
[games played (<= 1) by corresponding player on Team Right]
[powers scored by corresponding player on Team Right]
[tossups scored by corresponding player on Team Right]
[negs scored by corresponding player on Team Right]
[custom point value tossups scored by corresponding player on Team Right]
[total points scored by corresponding player on Team Right]}
Repeat the lines in braces six times (once for each player slot; even if a team only has one player), then go to the next game.
Basically, the difficulty here is that the macro needs to know the number of each team (and the number of each player on that team) and the game ID number to properly execute stats by robot, notwithstanding those bonus-related zeros that I haven't parsed yet. Because of this, I'm hesitant to declare the plausibility of an "SQBSify" button for a single scoresheet without it being able to read something else from an external file.