SQBS Help Thread

The scariest thing of all is Protobowl
Post Reply
User avatar
AKKOLADE
Sin
Posts: 14927
Joined: Thu Apr 24, 2003 8:08 am

SQBS Help Thread

Post by AKKOLADE » Tue Jan 15, 2013 10:07 am

Inspired by seeing a few threads regarding questions about how to use this software, and since there isn't already a thread for it, I thought that a thread dedicated to handling questions about how to use SQBS would be useful. Hopefully, people well versed in the software would be willing to help out and answer questions.

A few starting points:
I'll also try to help where I can.

[stickied - staff]
Last edited by AKKOLADE on Tue Jan 15, 2013 10:12 am, edited 2 times in total.
Fred Morlan
PACE Vice President of Outreach, 2017-18
International Quiz Bowl Tournaments, co-owner
University of Kentucky CoP, 2017
hsqbrank manager, PACE member (former President and At Large member of Board), NAQT writer (former subject editor), HSAPQ freelance writer, former hsqb Administrator/Chief Administrator, 2012 NASAT Tournament Director

User avatar
AKKOLADE
Sin
Posts: 14927
Joined: Thu Apr 24, 2003 8:08 am

Re: SQBS Help Thread

Post by AKKOLADE » Tue Jan 15, 2013 10:07 am

This post reserved for FAQs/guides/walkthroughs.
Fred Morlan
PACE Vice President of Outreach, 2017-18
International Quiz Bowl Tournaments, co-owner
University of Kentucky CoP, 2017
hsqbrank manager, PACE member (former President and At Large member of Board), NAQT writer (former subject editor), HSAPQ freelance writer, former hsqb Administrator/Chief Administrator, 2012 NASAT Tournament Director

User avatar
Important Bird Area
Forums Staff: Administrator
Posts: 5316
Joined: Thu Aug 28, 2003 3:33 pm
Location: San Francisco Bay Area
Contact:

Re: SQBS Help Thread

Post by Important Bird Area » Tue Jan 15, 2013 12:23 pm

NAQT's guide to using SQBS is here.
Jeff Hoppes
President, Northern California Quiz Bowl Alliance
former HSQB Chief Admin (2012-13)
VP for Communication and history subject editor, NAQT
Editor emeritus, ACF

"I wish to make some kind of joke about Jeff's love of birds, but I always fear he'll turn them on me Hitchcock-style." -Fred

User avatar
dtaylor4
Auron
Posts: 3724
Joined: Tue Nov 16, 2004 11:43 am
Location: Springfield, IL

Re: SQBS Help Thread

Post by dtaylor4 » Tue Jan 15, 2013 5:11 pm

Fred wrote:SQBS guide by Donald Taylor and Dwight Wynne - written for PACE. While Dwight's "retired," Donald's still active on the board and would likely be willing to answer any questions you might have.
Fred speaks truth. I'll be more than glad to answer questions posed here or sent to me privately.
Donald Taylor
Springfield, IL
(Decatur) MacArthur '05/UIUC '09 BS Accountancy/'10 Master of Accounting Science
Freelance writer, staffer, stats guru, TD

Where is Christchurch? That's in Queensland
Where is Palmerston North? That's in New South Wales

User avatar
AKKOLADE
Sin
Posts: 14927
Joined: Thu Apr 24, 2003 8:08 am

Re: SQBS Help Thread

Post by AKKOLADE » Tue Jan 15, 2013 5:18 pm

Post the good ones, though!
Fred Morlan
PACE Vice President of Outreach, 2017-18
International Quiz Bowl Tournaments, co-owner
University of Kentucky CoP, 2017
hsqbrank manager, PACE member (former President and At Large member of Board), NAQT writer (former subject editor), HSAPQ freelance writer, former hsqb Administrator/Chief Administrator, 2012 NASAT Tournament Director

User avatar
dtaylor4
Auron
Posts: 3724
Joined: Tue Nov 16, 2004 11:43 am
Location: Springfield, IL

Re: SQBS Help Thread

Post by dtaylor4 » Tue Jan 15, 2013 8:13 pm

Fred wrote:Post the good ones, though!
Of course, keeping names anonymous.
Donald Taylor
Springfield, IL
(Decatur) MacArthur '05/UIUC '09 BS Accountancy/'10 Master of Accounting Science
Freelance writer, staffer, stats guru, TD

Where is Christchurch? That's in Queensland
Where is Palmerston North? That's in New South Wales

Eddie
Rikku
Posts: 440
Joined: Thu Mar 01, 2012 6:59 pm

Re: SQBS Help Thread

Post by Eddie » Sat Jan 19, 2013 11:29 pm

I have a question - how does one get the "Round Report" page to show up? I've seen some stat reports with it and some without it. Whenever I do stats ends up showing up so I'm not sure if there's anything special I'm doing.
Eddie Kim
he/him/his
local lad, no major affiliations

User avatar
Important Bird Area
Forums Staff: Administrator
Posts: 5316
Joined: Thu Aug 28, 2003 3:33 pm
Location: San Francisco Bay Area
Contact:

Re: SQBS Help Thread

Post by Important Bird Area » Sat Jan 19, 2013 11:57 pm

From the "Settings" menu, select "Reports" and check off the "include round reports" box.
Jeff Hoppes
President, Northern California Quiz Bowl Alliance
former HSQB Chief Admin (2012-13)
VP for Communication and history subject editor, NAQT
Editor emeritus, ACF

"I wish to make some kind of joke about Jeff's love of birds, but I always fear he'll turn them on me Hitchcock-style." -Fred

User avatar
dtaylor4
Auron
Posts: 3724
Joined: Tue Nov 16, 2004 11:43 am
Location: Springfield, IL

Re: SQBS Help Thread

Post by dtaylor4 » Sun Jan 20, 2013 4:12 pm

bt_green_warbler wrote:From the "Settings" menu, select "Reports" and check off the "include round reports" box.
I'll add that you will have to do this for every tournament, no matter how many tournaments you've done with the program.
Donald Taylor
Springfield, IL
(Decatur) MacArthur '05/UIUC '09 BS Accountancy/'10 Master of Accounting Science
Freelance writer, staffer, stats guru, TD

Where is Christchurch? That's in Queensland
Where is Palmerston North? That's in New South Wales

User avatar
silverscreentest
Lulu
Posts: 75
Joined: Fri Mar 21, 2008 12:00 pm
Location: A legend in my own mind.

Re: SQBS Help Thread

Post by silverscreentest » Sat Feb 02, 2013 5:27 pm

Fred wrote:A few starting points:
Site doesn't seem to working. Is it located elsewhere?

User avatar
Unicolored Jay
Forums Staff: Administrator
Posts: 766
Joined: Mon Jun 15, 2009 3:28 pm
Location: Columbus, Ohio

Re: SQBS Help Thread

Post by Unicolored Jay » Mon Feb 04, 2013 8:03 pm

silverscreentest wrote:
Fred wrote:A few starting points:
Site doesn't seem to working. Is it located elsewhere?
It seems to be working fine for me.
Jasper Lee
University of Tennessee
The Ohio State University '14
Solon High School '10

User avatar
silverscreentest
Lulu
Posts: 75
Joined: Fri Mar 21, 2008 12:00 pm
Location: A legend in my own mind.

Re: SQBS Help Thread

Post by silverscreentest » Wed Feb 13, 2013 11:10 pm

Works for me now. Must not have been working the day I posted. Thank you.

Eddie
Rikku
Posts: 440
Joined: Thu Mar 01, 2012 6:59 pm

Re: SQBS Help Thread

Post by Eddie » Fri Mar 08, 2013 1:31 am

This is a question not so much about SQBS but about the HSQB interface itself - is there a way to determine around how many tossups were converted in a given round using the Round Report page of a tournament's stats if the tournament set uses powers? For a set without powers it's easy because I can simply multiply the TUpts/TUH by 20 and subtract from 200, but I'm not sure if there's a way to determine this for a set with powers.
Eddie Kim
he/him/his
local lad, no major affiliations

User avatar
dtaylor4
Auron
Posts: 3724
Joined: Tue Nov 16, 2004 11:43 am
Location: Springfield, IL

Re: SQBS Help Thread

Post by dtaylor4 » Fri Mar 08, 2013 2:18 am

pk14ster wrote:This is a question not so much about SQBS but about the HSQB interface itself - is there a way to determine around how many tossups were converted in a given round using the Round Report page of a tournament's stats if the tournament set uses powers? For a set without powers it's easy because I can simply multiply the TUpts/TUH by 20 and subtract from 200, but I'm not sure if there's a way to determine this for a set with powers.
Offhand, no. I *think* negs would also impact this.
Donald Taylor
Springfield, IL
(Decatur) MacArthur '05/UIUC '09 BS Accountancy/'10 Master of Accounting Science
Freelance writer, staffer, stats guru, TD

Where is Christchurch? That's in Queensland
Where is Palmerston North? That's in New South Wales

User avatar
Mewto55555
Forums Staff: Administrator
Posts: 709
Joined: Sat Mar 13, 2010 9:27 pm
Contact:

Re: SQBS Help Thread

Post by Mewto55555 » Fri Mar 08, 2013 2:27 pm

If rounds are being entered, then you can always just go to scoreboard page and do it manually -- unless your tournament is massive it will probably be not too much work.
Max
formerly of Ladue, Chicago

Eddie
Rikku
Posts: 440
Joined: Thu Mar 01, 2012 6:59 pm

Re: SQBS Help Thread

Post by Eddie » Fri Mar 08, 2013 11:06 pm

I'm talking about situations where you're just looking at a stat report for any given tournament on the tournament database, not when I'm the person entering stats.
Eddie Kim
he/him/his
local lad, no major affiliations

User avatar
Mewto55555
Forums Staff: Administrator
Posts: 709
Joined: Sat Mar 13, 2010 9:27 pm
Contact:

Re: SQBS Help Thread

Post by Mewto55555 » Fri Mar 08, 2013 11:10 pm

Oh I meant if round numbers are entered by the person who enters the stats (which they should have been, if the round report page is making sense), then on the Scoreboard page it's very easy to see what happened in each round, e.g. this -- and then just look at the bonus rows (the bottom of each game summary) to quickly see how many tossups got converted.
Max
formerly of Ladue, Chicago

User avatar
Excelsior (smack)
Rikku
Posts: 377
Joined: Sun Jan 25, 2009 12:20 am
Location: Madison, WI

Re: SQBS Help Thread

Post by Excelsior (smack) » Sat Mar 09, 2013 12:40 am

To make your life easier, consider this bookmarklet:

Code: Select all

javascript:(function(){x=document.getElementsByTagName('font');o=%22%22;tu=g=0;for(i=0;i%20%3C%20x.length;i++){if(x[i].color==%22red%22){o+=x[i].innerHTML;}if(x[i].size==%22-1%22){g+=1;q0=x[i].innerHTML;q1=q0.split('\n');q2=q1[3];q3=q2.replace('Bonuses:%20','').replace('%3Cbr%3E','');q4=q3.split(',%20');for(j=0;j%20%3C%20q4.length;j++){q5=q4[j].split('%20');q6=q5[q5.length-3];tu+=parseInt(q6);}}if(i==x.length-1%20||%20x[i+1].color==%22red%22){o+=%22%20-%3E%20%22+tu.toString()+%22%20TUs%20in%20%22+g.toString()+%22%20games\n%22;tu=g=0;}}alert(o);})();
Copy this code into a bookmark, and then click it when you're on the scoreboard page of an SQBS report. I have only tested it on two reports on the DB, so no guarantees that it works, but it might make your life easier.

Sample output for http://www.hsquizbowl.org/db/tournament ... ats/games/:
Round 1 -> 50 TUs in 3 games
Round 2 -> 45 TUs in 3 games
Round 3 -> 50 TUs in 3 games
Round 4 -> 53 TUs in 3 games
Round 5 -> 54 TUs in 3 games
Round 6 -> 48 TUs in 3 games
Round 7 -> 51 TUs in 3 games
Round 8 -> 50 TUs in 3 games
Round 9 -> 49 TUs in 3 games
Round 10 -> 49 TUs in 3 games
The difficulty of doing this makes clear the need for a better method of representing quizbowl statistics, which is something I have thoughts about and will probably post about eventually.
Ashvin Srivatsa
Corporate drone '?? | Yale University '14 | Sycamore High School (OH) '10

Eddie
Rikku
Posts: 440
Joined: Thu Mar 01, 2012 6:59 pm

Re: SQBS Help Thread

Post by Eddie » Sat Mar 09, 2013 7:10 pm

I apologize for my lack of computer skills, but how do I bookmark a chunk of Javascript code on Google Chrome?
Eddie Kim
he/him/his
local lad, no major affiliations

Urech hydantoin synthesis
Tidus
Posts: 521
Joined: Thu Dec 30, 2010 3:35 pm

Re: SQBS Help Thread

Post by Urech hydantoin synthesis » Sat Mar 09, 2013 11:59 pm

Enter the code into the space for the URL (in the popup for making a bookmark), and that should do the trick.
Ben Zhang
Columbia '18 | Ladue '14
PACE member

User avatar
AKKOLADE
Sin
Posts: 14927
Joined: Thu Apr 24, 2003 8:08 am

Re: SQBS Help Thread

Post by AKKOLADE » Thu Nov 14, 2013 1:30 pm

Is there any way to output rosters to a text file (or equivalent)?
Fred Morlan
PACE Vice President of Outreach, 2017-18
International Quiz Bowl Tournaments, co-owner
University of Kentucky CoP, 2017
hsqbrank manager, PACE member (former President and At Large member of Board), NAQT writer (former subject editor), HSAPQ freelance writer, former hsqb Administrator/Chief Administrator, 2012 NASAT Tournament Director

jonah
Auron
Posts: 2251
Joined: Thu Jul 20, 2006 5:51 pm
Location: Chicago

Re: SQBS Help Thread

Post by jonah » Thu Nov 14, 2013 2:15 pm

Grams's Go-Go Boots wrote:Is there any way to output rosters to a text file (or equivalent)?
I don't know of a "proper" way to do it, but if you open up a copy of the SQBS data file in Notepad (or whatever), I think you'll be able to trim it down to the relevant parts without too much difficulty.
Jonah Greenthal
National Academic Quiz Tournaments

AlecKamas
Kimahri
Posts: 5
Joined: Tue Jul 09, 2013 9:42 pm

Re: SQBS Help Thread

Post by AlecKamas » Sat Nov 16, 2013 6:00 pm

I'm attempting to use SQBS on a Mac and it won't let generate reports for only certain rounds. The system generates a report that includes different numbers of games for each team. I have selected the option to only include certain rounds, but the program seems to ignore it. Any workarounds?
Alec Kamas
University of Kentucky

User avatar
AKKOLADE
Sin
Posts: 14927
Joined: Thu Apr 24, 2003 8:08 am

Re: SQBS Help Thread

Post by AKKOLADE » Sat Nov 22, 2014 12:29 am

Is there anyway to add divisions to a tournament after it's created?

Edit: I just found out you can fix it easily by making a new tournament, hitting the divisions check box, and then merging with the old tournament.
Last edited by AKKOLADE on Sat Nov 22, 2014 12:32 am, edited 1 time in total.
Fred Morlan
PACE Vice President of Outreach, 2017-18
International Quiz Bowl Tournaments, co-owner
University of Kentucky CoP, 2017
hsqbrank manager, PACE member (former President and At Large member of Board), NAQT writer (former subject editor), HSAPQ freelance writer, former hsqb Administrator/Chief Administrator, 2012 NASAT Tournament Director

User avatar
Important Bird Area
Forums Staff: Administrator
Posts: 5316
Joined: Thu Aug 28, 2003 3:33 pm
Location: San Francisco Bay Area
Contact:

Re: SQBS Help Thread

Post by Important Bird Area » Sat Nov 22, 2014 12:32 am

Under Settings --> General, there is a checkbox for "use divisions?"
Jeff Hoppes
President, Northern California Quiz Bowl Alliance
former HSQB Chief Admin (2012-13)
VP for Communication and history subject editor, NAQT
Editor emeritus, ACF

"I wish to make some kind of joke about Jeff's love of birds, but I always fear he'll turn them on me Hitchcock-style." -Fred

Joshua Rutsky
Tidus
Posts: 512
Joined: Mon Oct 24, 2005 9:59 am
Location: Hoover, AL

Re: SQBS Help Thread

Post by Joshua Rutsky » Fri Feb 27, 2015 3:05 pm

jonah wrote:
Grams's Go-Go Boots wrote:Is there any way to output rosters to a text file (or equivalent)?
I don't know of a "proper" way to do it, but if you open up a copy of the SQBS data file in Notepad (or whatever), I think you'll be able to trim it down to the relevant parts without too much difficulty.

If anyone develops this into a function in the software itself, they will become my personal hero.
Joshua Rutsky
Coach, Hoover High School, Hoover, AL

zman147
Lulu
Posts: 18
Joined: Fri Oct 26, 2012 11:35 am

Re: SQBS Help Thread

Post by zman147 » Tue Jun 23, 2015 6:51 am

Is it possible to create a file with information about a quiz bowl tournament, without using SQBS, and then import or load that file into SQBS and have all of the data appear?
Ziad Ali
"Anyone can speak Troll, all you have to do is point and grunt."
Early College at Guilford '15
NC State University '19

Urech hydantoin synthesis
Tidus
Posts: 521
Joined: Thu Dec 30, 2010 3:35 pm

Re: SQBS Help Thread

Post by Urech hydantoin synthesis » Tue Jun 23, 2015 7:07 am

zman147 wrote:Is it possible to create a file with information about a quiz bowl tournament, without using SQBS, and then import or load that file into SQBS and have all of the data appear?
As far as I know, the only thing of this sort is uploadable text file rosters, details of which are under "Entering Rosters from a File" in the Concise Manual for SQBS.
Ben Zhang
Columbia '18 | Ladue '14
PACE member

User avatar
Captain Sinico
Auron
Posts: 2836
Joined: Sun Sep 21, 2003 1:46 pm
Location: Champaign, Illinois

Re: SQBS Help Thread

Post by Captain Sinico » Fri Jun 26, 2015 1:51 pm

NAQT's registration system does that automatically, to some extent.
Mike Sorice
Coach, Centennial High School (2014-) & Team Illinois (2016-)
Alumnus, Illinois ABT & Fenwick Scholastic Bowl
ACF
IHSSBCA
PACE

jonah
Auron
Posts: 2251
Joined: Thu Jul 20, 2006 5:51 pm
Location: Chicago

Re: SQBS Help Thread

Post by jonah » Fri Jun 26, 2015 2:01 pm

zman147 wrote:Is it possible to create a file with information about a quiz bowl tournament, without using SQBS, and then import or load that file into SQBS and have all of the data appear?
It depends what you mean. Is it conceptually possible? Sure. Is there a tool out there that lets you do it? As Mike said, NAQT's registration system will output a loadable SQBS file with team names and rosters (and some ancillary information like whether teams are undergrad-title-eligible); the file won't include existing game data, and as far as I know no one has done that yet.

What is the specific problem you're trying to solve? Where are you starting from?
Jonah Greenthal
National Academic Quiz Tournaments

User avatar
tintinnabulation
Wakka
Posts: 141
Joined: Wed Nov 23, 2011 1:04 am

Re: SQBS Help Thread

Post by tintinnabulation » Sat Jan 21, 2017 9:48 am

We're having trouble saving the tournament. Nothing comes up in the "Save as type" box when we hit "Save" or "Save As" and the file seems empty when we open it. Are we missing something?

Edit: mostly solved
Brittany Trang
Ohio State
Northwestern

jonah
Auron
Posts: 2251
Joined: Thu Jul 20, 2006 5:51 pm
Location: Chicago

Re: SQBS Help Thread

Post by jonah » Sat Jan 21, 2017 10:54 am

tintinnabulation wrote:We're having trouble saving the tournament. Nothing comes up in the "Save as type" box when we hit "Save" or "Save As" and the file seems empty when we open it. Are we missing something?

Edit: mostly solved
You can just leave that blank. I use the extension ".sqbs" for the data file, but it doesn't really matter.

I had forgotten this thread existed and now see my previous post, which reminds me to mention that
jonah wrote:
zman147 wrote:Is it possible to create a file with information about a quiz bowl tournament, without using SQBS, and then import or load that file into SQBS and have all of the data appear?
It depends what you mean. Is it conceptually possible? Sure. Is there a tool out there that lets you do it? As Mike said, NAQT's registration system will output a loadable SQBS file with team names and rosters (and some ancillary information like whether teams are undergrad-title-eligible); the file won't include existing game data, and as far as I know no one has done that yet.
NAQT's registration system can now output game data that's already been loaded into NAQT's system (assuming it doesn't exceed SQBS's limitation of eight players for any one team in any one game), though applications are pretty limited because only Chad and I (more or less) can load stats to begin with.
Jonah Greenthal
National Academic Quiz Tournaments

sgoebel
Lulu
Posts: 26
Joined: Sat Mar 11, 2017 9:44 pm
Location: Shreveport, LA

Re: SQBS Help Thread

Post by sgoebel » Sun Sep 24, 2017 6:02 pm

AlecKamas wrote:I'm attempting to use SQBS on a Mac and it won't let generate reports for only certain rounds. The system generates a report that includes different numbers of games for each team. I have selected the option to only include certain rounds, but the program seems to ignore it. Any workarounds?
This issue seems to still exist in the Mac version of SQBS. Have any Mac users found workarounds for this?
Stephen Goebel
Coach, C.E. Byrd High School, Shreveport, LA

User avatar
dtaylor4
Auron
Posts: 3724
Joined: Tue Nov 16, 2004 11:43 am
Location: Springfield, IL

Re: SQBS Help Thread

Post by dtaylor4 » Mon Sep 25, 2017 10:46 am

sgoebel wrote:
AlecKamas wrote:I'm attempting to use SQBS on a Mac and it won't let generate reports for only certain rounds. The system generates a report that includes different numbers of games for each team. I have selected the option to only include certain rounds, but the program seems to ignore it. Any workarounds?
This issue seems to still exist in the Mac version of SQBS. Have any Mac users found workarounds for this?
In my extensive experience, I have had enough issues with the Mac version of SQBS that I do everything I can to not use it if I don't have to.
Donald Taylor
Springfield, IL
(Decatur) MacArthur '05/UIUC '09 BS Accountancy/'10 Master of Accounting Science
Freelance writer, staffer, stats guru, TD

Where is Christchurch? That's in Queensland
Where is Palmerston North? That's in New South Wales

sgoebel
Lulu
Posts: 26
Joined: Sat Mar 11, 2017 9:44 pm
Location: Shreveport, LA

Re: SQBS Help Thread

Post by sgoebel » Wed Oct 18, 2017 7:24 pm

dtaylor4 wrote:
sgoebel wrote:
AlecKamas wrote:I'm attempting to use SQBS on a Mac and it won't let generate reports for only certain rounds. The system generates a report that includes different numbers of games for each team. I have selected the option to only include certain rounds, but the program seems to ignore it. Any workarounds?
This issue seems to still exist in the Mac version of SQBS. Have any Mac users found workarounds for this?
In my extensive experience, I have had enough issues with the Mac version of SQBS that I do everything I can to not use it if I don't have to.
I was able to get the windows version of SQBS to run on a Mac using WINE without any real problems. Trying to print quick reports locked up the program, but everything else worked just fine.
Stephen Goebel
Coach, C.E. Byrd High School, Shreveport, LA

User avatar
Progcon
Rikku
Posts: 434
Joined: Fri Dec 20, 2013 8:24 pm

Re: SQBS Help Thread

Post by Progcon » Wed Oct 18, 2017 7:29 pm

What version of SQBS should I download for Linux (Xfce Unbuntu)? I would like to avoid using a Windows OS if possible.
Harris Bunker
Grosse Pointe North High School '15
Michigan State University 2015-

sgoebel
Lulu
Posts: 26
Joined: Sat Mar 11, 2017 9:44 pm
Location: Shreveport, LA

Re: SQBS Help Thread

Post by sgoebel » Wed Oct 18, 2017 10:23 pm

Progcon wrote:What version of SQBS should I download for Linux (Xfce Unbuntu)? I would like to avoid using a Windows OS if possible.
If you use Wine (https://www.winehq.org) - I was only able to get the "executable" version to work.
Stephen Goebel
Coach, C.E. Byrd High School, Shreveport, LA

User avatar
Progcon
Rikku
Posts: 434
Joined: Fri Dec 20, 2013 8:24 pm

Re: SQBS Help Thread

Post by Progcon » Thu Oct 19, 2017 1:02 pm

sgoebel wrote:
Progcon wrote:What version of SQBS should I download for Linux (Xfce Unbuntu)? I would like to avoid using a Windows OS if possible.
If you use Wine (https://www.winehq.org) - I was only able to get the "executable" version to work.
I was afraid you'd say Wine because it was kind of a pain to install due to an error it made in my package manager. I however, was able to use the executable version successfully.

Thanks!
Harris Bunker
Grosse Pointe North High School '15
Michigan State University 2015-

jacke
Lulu
Posts: 26
Joined: Thu Sep 28, 2017 5:07 pm

Re: SQBS Help Thread

Post by jacke » Thu Oct 19, 2017 1:48 pm

Can two people working on the same tournament/division on different devices merge their files into one?
Jack E.
Bermudian Springs HS
Princeton University '21, Club president

jonah
Auron
Posts: 2251
Joined: Thu Jul 20, 2006 5:51 pm
Location: Chicago

Re: SQBS Help Thread

Post by jonah » Thu Oct 19, 2017 3:21 pm

jacke wrote:Can two people working on the same tournament/division on different devices merge their files into one?
In principle, yes, but it's somewhat error-prone. It's better to divide tournaments and scoresheets such that there will be no need to merge except perhaps at a rebracket.

If you have to merge, here's how to do it:
1. Make backup copies of everything.
2. Open the file you want to merge into.
3. Go to File, then Merge Files.
4. Choose the file you want to merge from.
5. Go through the games and clean up whatever got messed up.
Jonah Greenthal
National Academic Quiz Tournaments

User avatar
TylerV
Lulu
Posts: 92
Joined: Sat Feb 16, 2013 7:58 pm

Re: SQBS Help Thread

Post by TylerV » Thu Oct 19, 2017 9:43 pm

jonah wrote:
jacke wrote:Can two people working on the same tournament/division on different devices merge their files into one?
In principle, yes, but it's somewhat error-prone. It's better to divide tournaments and scoresheets such that there will be no need to merge except perhaps at a rebracket.

If you have to merge, here's how to do it:
1. Make backup copies of everything.
2. Open the file you want to merge into.
3. Go to File, then Merge Files.
4. Choose the file you want to merge from.
5. Go through the games and clean up whatever got messed up.

To reinforce on this advice, it's really important that all teams/players are entered in exactly the same. For this purpose, John Doe with a space after the e is different than John Doe with no space. If these don't match it will insert both into the merged file and treat them as different people.
Tyler Vaughan
Gibson-assembling tossups from lists of named things on Wikipedia since 2014.
UW-Platteville, Rock Valley, UIUC 2014-2017
Head Editor @ NHBB MS
Subject Editor @ SCOP, USABB
Editor @ NHBB

jacke
Lulu
Posts: 26
Joined: Thu Sep 28, 2017 5:07 pm

Re: SQBS Help Thread

Post by jacke » Thu Oct 19, 2017 9:54 pm

Okay thanks! Are there any tricks with the round/games, too? I assume no overlap on that.
Jack E.
Bermudian Springs HS
Princeton University '21, Club president

User avatar
dtaylor4
Auron
Posts: 3724
Joined: Tue Nov 16, 2004 11:43 am
Location: Springfield, IL

Re: SQBS Help Thread

Post by dtaylor4 » Fri Oct 20, 2017 10:37 am

jacke wrote:Okay thanks! Are there any tricks with the round/games, too? I assume no overlap on that.
To ensure no overlap, I would have one person stick with the traditional numbering of games (starting at 0), and the other start at a higher number, i.e. 400, so that each game still has its' own individual ID (assuming the entry people do the smart thing and write the ID # on the scoresheet once the game is entered).
Donald Taylor
Springfield, IL
(Decatur) MacArthur '05/UIUC '09 BS Accountancy/'10 Master of Accounting Science
Freelance writer, staffer, stats guru, TD

Where is Christchurch? That's in Queensland
Where is Palmerston North? That's in New South Wales

User avatar
1.82
Rikku
Posts: 252
Joined: Thu Feb 05, 2015 9:35 pm
Location: San Jose, California
Contact:

Re: SQBS Help Thread

Post by 1.82 » Fri Oct 20, 2017 6:27 pm

dtaylor4 wrote:
jacke wrote:Okay thanks! Are there any tricks with the round/games, too? I assume no overlap on that.
To ensure no overlap, I would have one person stick with the traditional numbering of games (starting at 0), and the other start at a higher number, i.e. 400, so that each game still has its' own individual ID (assuming the entry people do the smart thing and write the ID # on the scoresheet once the game is entered).
Alternately, a good trick that I learned from Cody Voight is based on the fact that game numbers don't actually have to be numbers. Consequently, you can enter the game played in room 117 in round 1 as 117-1, the game played in room 119 in round 2 as 119-2, and so on. This gives every game an unambiguous and unique ID that can be easily found without having to worry about writing IDs on scoresheets, and it's useful for rebracketing even if you don't have to deal with stats input from multiple sources.
Naveed Chowdhury
Maryland '16
Georgia Tech '17

MichaelFalk
Lulu
Posts: 92
Joined: Mon Jan 03, 2005 12:01 am
Location: Milwaukee, WI
Contact:

Re: SQBS Help Thread

Post by MichaelFalk » Sun Nov 05, 2017 8:40 am

sgoebel wrote:This issue seems to still exist in the Mac version of SQBS. Have any Mac users found workarounds for this?
Unfortunately, I had the same problem, and also noted problems with duplicate ID numbers being allowed, negative amounts of tossups/negs being allowed, and no warnings for games played >4.0 or for bonus points being scored by a team with no tossups answered.

The workaround for me, unfortunately, was to go back to a Windows PC to fix the errors and generate the stats reports from there.
--
Michael Falk
Played for Iowa State University, 2001-2004
Coaching for St. Mary's Visitation (Elm Grove, WI), grades 6-8, 2010-present

Post Reply