Introducing YellowFruit.

Packet databases and other quizbowl sites, apps, or software should be discussed here.
User avatar
Ndg
Rikku
Posts: 387
Joined: Tue Oct 30, 2012 3:24 pm
Location: Wisconsin

Introducing YellowFruit.

Post by Ndg »

I suppose I may as well make a proper thread for this now that various versions have been floating around for close to a year.

What is it?
A standalone Windows application for (manual) stat entry. Think of it as SQBS but with
- Less crummy UI
- Support for phases/stages (don't need multiple files for one tournament)
- Better looking, easier-to-navigate, customizable html reports. Here is a sample stat report.

Download the latest version here. A macOS version is also available, but it might not work on all devices.
(v3.0.2, December 2022)


I won't clutter this post with screenshots but you can see some (slightly out of date) ones here

What isn't it?
"Live" stats entry. There are other tools you can use for that if that's what you want.

Is constructive criticism welcome?
Yes.
Last edited by Ndg on Sat Dec 10, 2022 9:05 pm, edited 23 times in total.
Andrew Nadig

Mannhiem Mannheim Manheim Township, 2005-11
Carnegie Mellon University, 2011-15
User avatar
the return of AHAN
Auron
Posts: 1988
Joined: Thu Feb 01, 2007 10:40 pm

Re: Introducing YellowFruit.

Post by the return of AHAN »

I'm interested in a Mac version since all of our devices in my school are Apple products.
Jeff Price
Barrington High School Coach (2021 & 2023 HSNCT Champions, 2023 PACE Champions, 2023 Illinois Masonic Bowl Class 3A State Champions)
Barrington Station Middle School Coach (2013 MSNCT Champions, 2013 & 2017 Illinois Class AA State Champions)
------------------------------------------------------------------------------
User avatar
Atlashill
Wakka
Posts: 144
Joined: Sun Mar 16, 2014 4:52 pm
Location: Sedalia, MO

Re: Introducing YellowFruit.

Post by Atlashill »

I'm in the process of giving it a run-through with scoresheets I've retained from a 36-team tournament. So far I'm enjoying the option to name pools and phases all at once, as well as the sidebar where standings are updating as I enter games. However, it's a bit of a hassle to click "add game", then "new game" over and over. It would be nice if there was a third button where once you added a game, it automatically begins creation of another entry. This would help streamline data entry when having to deal with multiple scoresheets on short time.

I'm making additional notes on some of the benefits and drawbacks compared to SQBS, I am curious as to what tweaks or features you're thinking of including in the near future.
Kyle Hill—Liberty (Mo.) '03—Truman State '07
Moderator for hire based in Sedalia, Mo.
User avatar
Ndg
Rikku
Posts: 387
Joined: Tue Oct 30, 2012 3:24 pm
Location: Wisconsin

Re: Introducing YellowFruit.

Post by Ndg »

Atlashill wrote: Mon Sep 30, 2019 8:41 pm it's a bit of a hassle to click "add game", then "new game" over and over. It would be nice if there was a third button where once you added a game, it automatically begins creation of another entry.

Good idea. It shouldn't be difficult for me to add an "accept and new" button. In the meantime (I don't know whether you mean "click" literally) you can mitigate this by using the keyboard shortcuts, alt-A and ctrl-G.
Atlashill wrote: Mon Sep 30, 2019 8:41 pm I am curious as to what tweaks or features you're thinking of including in the near future.
I have nothing major in mind. What exists now is more or less my vision for what it ought to be. The next version will have auto-save ability and probably improvements to the division editing UI, which right now can be problematic if you need to go back and change things after you've started adding games.
Andrew Nadig

Mannhiem Mannheim Manheim Township, 2005-11
Carnegie Mellon University, 2011-15
jonah
Auron
Posts: 2383
Joined: Thu Jul 20, 2006 5:51 pm
Location: Chicago

Re: Introducing YellowFruit.

Post by jonah »

Looks like in the SQBS converter, for forfeits you output a blank line for tossups heard. SQBS would output a 0.
Jonah Greenthal
National Academic Quiz Tournaments
User avatar
Atlashill
Wakka
Posts: 144
Joined: Sun Mar 16, 2014 4:52 pm
Location: Sedalia, MO

Re: Introducing YellowFruit.

Post by Atlashill »

Adding UG & D2 was an excellent idea. Is it possible to add an option, for high school tournaments, where UG and D2 become Small School (SS) and JV? We have a handful of tournaments that offer either if not both awards, and this would be an easy way to keep track. (For the tournament I'm slowly rebuilding as a test-run for YF, I had 11 small schools out of 36 teams, which I've indicated as D2.)
Kyle Hill—Liberty (Mo.) '03—Truman State '07
Moderator for hire based in Sedalia, Mo.
User avatar
Ndg
Rikku
Posts: 387
Joined: Tue Oct 30, 2012 3:24 pm
Location: Wisconsin

Re: Introducing YellowFruit.

Post by Ndg »

Atlashill wrote: Mon Sep 30, 2019 8:41 pm It would be nice if there was a third button where once you added a game, it automatically begins creation of another entry. This would help streamline data entry when having to deal with multiple scoresheets on short time.
jonah wrote: Wed Oct 02, 2019 11:16 pm Looks like in the SQBS converter, for forfeits you output a blank line for tossups heard. SQBS would output a 0.
Atlashill wrote: Thu Oct 03, 2019 10:51 pm Adding UG & D2 was an excellent idea. Is it possible to add an option, for high school tournaments, where UG and D2 become Small School (SS) and JV? We have a handful of tournaments that offer either if not both awards, and this would be an easy way to keep track. (For the tournament I'm slowly rebuilding as a test-run for YF, I had 11 small schools out of 36 teams, which I've indicated as D2.)
I've addressed these in the newest version (linked above).
Andrew Nadig

Mannhiem Mannheim Manheim Township, 2005-11
Carnegie Mellon University, 2011-15
User avatar
Atlashill
Wakka
Posts: 144
Joined: Sun Mar 16, 2014 4:52 pm
Location: Sedalia, MO

Re: Introducing YellowFruit.

Post by Atlashill »

There's a bug with the new version (2.3.2): when I attempt to save phases, the screen goes blank, and it's not possible to save the file from that point.
Kyle Hill—Liberty (Mo.) '03—Truman State '07
Moderator for hire based in Sedalia, Mo.
User avatar
Ndg
Rikku
Posts: 387
Joined: Tue Oct 30, 2012 3:24 pm
Location: Wisconsin

Re: Introducing YellowFruit.

Post by Ndg »

Atlashill wrote: Sun Oct 20, 2019 9:42 pm There's a bug with the new version (2.3.2): when I attempt to save phases, the screen goes blank, and it's not possible to save the file from that point.
Fixed
Andrew Nadig

Mannhiem Mannheim Manheim Township, 2005-11
Carnegie Mellon University, 2011-15
User avatar
Ndg
Rikku
Posts: 387
Joined: Tue Oct 30, 2012 3:24 pm
Location: Wisconsin

Re: Introducing YellowFruit.

Post by Ndg »

the return of AHAN wrote: Mon Sep 30, 2019 11:08 am I'm interested in a Mac version since all of our devices in my school are Apple products.
I've linked a MacOS version in the original post.
Andrew Nadig

Mannhiem Mannheim Manheim Township, 2005-11
Carnegie Mellon University, 2011-15
User avatar
Ndg
Rikku
Posts: 387
Joined: Tue Oct 30, 2012 3:24 pm
Location: Wisconsin

Re: Introducing YellowFruit.

Post by Ndg »

I think this has been done in some form before, but if anyone needs an easy way to move stat reports from Neg5 to the hsquizbowl database, I've added an "Import QBJ" option.

There are a few caveats with this:
- This is only for the specific schema version 2.1 file that Neg5 exports
- Neg5 doesn't seem to export phases or divisions/pools, so you would have to reconstruct those manually
- The newest version supports tiebreakers, but Neg5 doesn't, so any time a team plays multiple games in one round, those games are assumed to be tiebreakers
- Files with data that you wouldn't be allowed to enter manually in YF will be rejected (for example, Neg5 fails to verify that total TU heard for a team is not greater than the game's TU read times the max players per team)
Andrew Nadig

Mannhiem Mannheim Manheim Township, 2005-11
Carnegie Mellon University, 2011-15
jij03
Lulu
Posts: 38
Joined: Sun Dec 23, 2018 5:49 pm

Re: Introducing YellowFruit.

Post by jij03 »

I think i can speak for the entire Missouri Circuit at this point

This Application has been quite useful to the circuit this season, our stats recording and uploading processes have been overall more efficient and quick. I enjoyed using it for FORKAST and Three Trails. Though there are a couple of hiccups here and there, which have already been specified, Using Yellow fruit has been more intuitive than SQBS overall.
Aidan McWilliams
Fort Osage '21
Mizzou '25
mithokie
Rikku
Posts: 345
Joined: Mon Apr 17, 2006 2:39 pm
Location: Blacksburg, VA

Re: Introducing YellowFruit.

Post by mithokie »

For the VHSL Scholastic Bowl format, we have 30 toss-up questions per match with no powers and no bonuses. There is also a directed round of 10 questions to each time that can be bounced back and stolen.

In SQBS, I used the Lightning Round option to track the directed round points for each team. Does anyone have a good suggestion for how to use Yellow Fruit to record VHSL matches?

Thanks.
Matt Beeken
Eastern Montgomery High School
Math Instructional Coach
Scholastic Bowl Coach (2022 - ??)
mbeeken AT mcps DOT org
Joshua Rutsky
Tidus
Posts: 663
Joined: Mon Oct 24, 2005 9:59 am
Location: Hoover, AL

Re: Introducing YellowFruit.

Post by Joshua Rutsky »

Seconded. I understand that both this and Neg5 were written with the common 20/20 format in mind, but it would be a HUGE difference-maker for many of us in states where worksheet rounds or lightning rounds still exist to add this functionality to the programs. Something as basic as one extra field per team to record those points and carry them into the results would make it possible for us to use these programs regularly. Please consider this addition.
Joshua Rutsky
VP for Curriculum and Camp Operations, Qwiz
ASCA Board Member
Hoover High School Coach (Retired)
User avatar
Ndg
Rikku
Posts: 387
Joined: Tue Oct 30, 2012 3:24 pm
Location: Wisconsin

Re: Introducing YellowFruit.

Post by Ndg »

Joshua Rutsky wrote: Wed Jan 29, 2020 10:12 am Seconded. I understand that both this and Neg5 were written with the common 20/20 format in mind, but it would be a HUGE difference-maker for many of us in states where worksheet rounds or lightning rounds still exist to add this functionality to the programs. Something as basic as one extra field per team to record those points and carry them into the results would make it possible for us to use these programs regularly. Please consider this addition.
This is certainly something I can do if I see sufficient demand for it. I have no experience whatsoever with (non-NHBB) quiz bowl involving this sort of thing, so I would encourage anyone who uses lightning rounds to either DM me or post here with details of how your particular format works so I can design a solution that works for as many people as possible. For example,
mithokie wrote: Wed Dec 18, 2019 2:20 pm For the VHSL Scholastic Bowl format [...] There is also a directed round of 10 questions to each time that can be bounced back and stolen.
How many points is each part worth in this format? Is there a bonus for sweeping the round as in NHBB?
Andrew Nadig

Mannhiem Mannheim Manheim Township, 2005-11
Carnegie Mellon University, 2011-15
User avatar
Cody
2008-09 Male Athlete of the Year
Posts: 2891
Joined: Sun Nov 15, 2009 12:57 am

Re: Introducing YellowFruit.

Post by Cody »

For VHSL, all you need is a lightning round box score for both teams (same as any other lightning round format even though VHSL functions differently). SQBS handles it well by leaving it open imo.

As for details, each team can score some integer multiple of ten points, no more than 200 combined, no sweep bonus.
Cody Voight, VCU ’14.
Joshua Rutsky
Tidus
Posts: 663
Joined: Mon Oct 24, 2005 9:59 am
Location: Hoover, AL

Re: Introducing YellowFruit.

Post by Joshua Rutsky »

Alabama’s Elementary and Middle School format is 20/20 with a 100 point worksheet round at the halfway point. Both teams participate, and there is no bounceback, so all that would be needed is a field for entering a score for each team on that segment, and an option to enable it.

Your considering this is much appreciated. I have used SQBS for a long time, and it is still a good option, but it has needed a real overhaul for quite some time.
Joshua Rutsky
VP for Curriculum and Camp Operations, Qwiz
ASCA Board Member
Hoover High School Coach (Retired)
User avatar
Fado Alexandrino
Yuna
Posts: 834
Joined: Sat Jun 12, 2010 8:46 pm
Location: Farhaven, Ontario

Re: Introducing YellowFruit.

Post by Fado Alexandrino »

As SCT approaches and NAQT requires hosts to report in SQBS, are there any known bugs that need to be addressed, or the SQBS export as is good enough for NAQT standards?
Joe Su, OCT
Lisgar 2012, McGill 2015, McGill 2019, Queen's 2020
User avatar
Important Bird Area
Forums Staff: Administrator
Posts: 6112
Joined: Thu Aug 28, 2003 3:33 pm
Location: San Francisco Bay Area
Contact:

Re: Introducing YellowFruit.

Post by Important Bird Area »

For the record: we do still require SQBS for SCT results reporting. We are planning to reconsider this policy for 2021 if YellowFruit continues to be stable and error-free in the meantime.
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
Atlashill
Wakka
Posts: 144
Joined: Sun Mar 16, 2014 4:52 pm
Location: Sedalia, MO

Re: Introducing YellowFruit.

Post by Atlashill »

If we're throwing in state-specific quirks, I might as well put Missouri's forward since (as Aidan has mentioned above and also successfully advocated) several hosts here have switched to YellowFruit.

Our overtime scoring is slightly different, in that 1) any tossups scored are one point instead of 10 and 2) they aren't suppose to count toward a team's score for playoff advancement or an individual's stats. In SQBS, the ability to specify point values for tossups made indicating these tossups possible. Perhaps if a fourth column of tossups is added, this could be a customizable score column where either our OT tossups, superpowers, or other quirks can be properly scored. (Though, in the case of playoff advancement, there might have to be a little more done to get that in.)
Kyle Hill—Liberty (Mo.) '03—Truman State '07
Moderator for hire based in Sedalia, Mo.
User avatar
Ndg
Rikku
Posts: 387
Joined: Tue Oct 30, 2012 3:24 pm
Location: Wisconsin

Re: Introducing YellowFruit.

Post by Ndg »

Atlashill wrote: Tue Feb 04, 2020 2:19 am If we're throwing in state-specific quirks, I might as well put Missouri's forward since (as Aidan has mentioned above and also successfully advocated) several hosts here have switched to YellowFruit.

Our overtime scoring is slightly different, in that 1) any tossups scored are one point instead of 10 and 2) they aren't suppose to count toward a team's score for playoff advancement or an individual's stats. In SQBS, the ability to specify point values for tossups made indicating these tossups possible. Perhaps if a fourth column of tossups is added, this could be a customizable score column where either our OT tossups, superpowers, or other quirks can be properly scored. (Though, in the case of playoff advancement, there might have to be a little more done to get that in.)
This sounds the same as NHBB rules, where the game effectively ends in a tie score, but one team is declared the winner. I'm assuming this is sudden-death, and there are no negs in overtime?
Andrew Nadig

Mannhiem Mannheim Manheim Township, 2005-11
Carnegie Mellon University, 2011-15
sgoebel
Lulu
Posts: 40
Joined: Sat Mar 11, 2017 9:44 pm
Location: Shreveport, LA

Re: Introducing YellowFruit.

Post by sgoebel »

Ignore this - sorry.
Last edited by sgoebel on Tue Feb 04, 2020 3:25 pm, edited 1 time in total.
Stephen Goebel
Coach, C.E. Byrd HS 2013-2020
Unaffiliated, Caddo Magnet HS 2020-
User avatar
Important Bird Area
Forums Staff: Administrator
Posts: 6112
Joined: Thu Aug 28, 2003 3:33 pm
Location: San Francisco Bay Area
Contact:

Re: Introducing YellowFruit.

Post by Important Bird Area »

Just to make my previous post clear: SCT has strict reporting requirements that do not apply to regular-season high school and middle school events.

If you are keeping statistics for this year's SCT, please use SQBS, not any other program.
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
Atlashill
Wakka
Posts: 144
Joined: Sun Mar 16, 2014 4:52 pm
Location: Sedalia, MO

Re: Introducing YellowFruit.

Post by Atlashill »

Ndg wrote: Tue Feb 04, 2020 2:45 am
Atlashill wrote: Tue Feb 04, 2020 2:19 am If we're throwing in state-specific quirks, I might as well put Missouri's forward since (as Aidan has mentioned above and also successfully advocated) several hosts here have switched to YellowFruit.

Our overtime scoring is slightly different, in that 1) any tossups scored are one point instead of 10 and 2) they aren't suppose to count toward a team's score for playoff advancement or an individual's stats. In SQBS, the ability to specify point values for tossups made indicating these tossups possible. Perhaps if a fourth column of tossups is added, this could be a customizable score column where either our OT tossups, superpowers, or other quirks can be properly scored. (Though, in the case of playoff advancement, there might have to be a little more done to get that in.)
This sounds the same as NHBB rules, where the game effectively ends in a tie score, but one team is declared the winner. I'm assuming this is sudden-death, and there are no negs in overtime?
Correct, sudden-death/golden tossup. Thankfully, the state changed their procedure to first-to-one; it used to be first-to-three.
Kyle Hill—Liberty (Mo.) '03—Truman State '07
Moderator for hire based in Sedalia, Mo.
User avatar
a Joe
Rikku
Posts: 342
Joined: Sun Sep 21, 2014 5:45 pm
Location: Nesconset, NY
Contact:

Re: Introducing YellowFruit.

Post by a Joe »

Do you think you can add an import from SQBS feature in a future release for easy conversion? Not a programmer, so sorry if I just made an insanely hard suggestion.
"THE" Joe Feldman
President, The Long Island Quiz Bowl Alliance
President, Suffolk County Community College Traveling Trivia Team
Founder, American Quizbowl League
President Emeritus, Smithtown High School West

Ask me how I (almost) monopolized Quizbowl
User avatar
Ndg
Rikku
Posts: 387
Joined: Tue Oct 30, 2012 3:24 pm
Location: Wisconsin

Re: Introducing YellowFruit.

Post by Ndg »

Snoopy wrote: Wed Feb 05, 2020 6:46 pm Do you think you can add an import from SQBS feature in a future release for easy conversion? Not a programmer, so sorry if I just made an insanely hard suggestion.
What is the use case for doing this? It's not necessarily that hard, but I haven't come with a reason to justify the work.
Andrew Nadig

Mannhiem Mannheim Manheim Township, 2005-11
Carnegie Mellon University, 2011-15
User avatar
a Joe
Rikku
Posts: 342
Joined: Sun Sep 21, 2014 5:45 pm
Location: Nesconset, NY
Contact:

Re: Introducing YellowFruit.

Post by a Joe »

Ndg wrote: Wed Feb 05, 2020 9:51 pm What is the use case for doing this? It's not necessarily that hard, but I haven't come with a reason to justify the work.
I suppose to standardize report formats in the future if/when Yellowfruit becomes the new standard.
"THE" Joe Feldman
President, The Long Island Quiz Bowl Alliance
President, Suffolk County Community College Traveling Trivia Team
Founder, American Quizbowl League
President Emeritus, Smithtown High School West

Ask me how I (almost) monopolized Quizbowl
User avatar
Ndg
Rikku
Posts: 387
Joined: Tue Oct 30, 2012 3:24 pm
Location: Wisconsin

Re: Introducing YellowFruit.

Post by Ndg »

I don't think there's any point in having everyone dig out years of old SQBS files, if they even exist, and re-post the stats, if that's what you mean.
Andrew Nadig

Mannhiem Mannheim Manheim Township, 2005-11
Carnegie Mellon University, 2011-15
User avatar
MSchnippert
Lulu
Posts: 14
Joined: Mon Nov 07, 2011 3:27 pm
Location: Maclay School, Tallahassee, FL

Re: Introducing YellowFruit.

Post by MSchnippert »

Thanks for your work on this. I've been playing with it in anticipation of my tournament next weekend. I was able to use the error reporting function in the import QBJ to troubleshoot my Neg5 database that NAQT couldn't import last year. (Not expecting them to, but I was able to send them some VERY delayed individual stats they can add if they want to.)

I'm debating paper scoring with this for my tournament or using Neg5 again and this to help fix data entry errors. Troubleshooting wasn't hard, but would've been even easier with everything fresh on my mind. I just wish one was solidly easier than the other.

I did have one import issue - on the attached file (ending changed from qbj to jpg to be able to attach it), it said round 4 was invalid for Maclay MS-Bainbridge MS which was 145-0. When I added something to both teams to make it 150-5, everything worked fine. I'm really not concerned with it, but I figured I'd send it to you if it could help you find an issue.
Matt Schnippert
Brain Bowl Coach
Maclay School
Tallahassee, FL
User avatar
Ndg
Rikku
Posts: 387
Joined: Tue Oct 30, 2012 3:24 pm
Location: Wisconsin

Re: Introducing YellowFruit.

Post by Ndg »

MSchnippert wrote: Fri Feb 14, 2020 4:05 pm I did have one import issue - on the attached file (ending changed from qbj to jpg to be able to attach it), it said round 4 was invalid for Maclay MS-Bainbridge MS which was 145-0. When I added something to both teams to make it 150-5, everything worked fine. I'm really not concerned with it, but I figured I'd send it to you if it could help you find an issue.
Thank you for pointing that out. It turns out it's treating a score of zero as not having a score. Sorry.
Andrew Nadig

Mannhiem Mannheim Manheim Township, 2005-11
Carnegie Mellon University, 2011-15
User avatar
Ndg
Rikku
Posts: 387
Joined: Tue Oct 30, 2012 3:24 pm
Location: Wisconsin

Re: Introducing YellowFruit.

Post by Ndg »

I've published a new version up above, with the following notable changes:
  1. You can now manually override final rankings (shown when reporting All Games)
  2. Use of "phase"/"stage" record to compute final rankings is now on by default. If this produces undesirable results, see #1 (or turn it off via the report settings).
  3. You can now export results in tournament schema (qbj) version 2.0 format. The main motivation for this is to be able to send more detailed results to NAQT than is possible with the SQBS format. However, there will undoubtedly be some kinks to work out, so I would advise sending NAQT both qbj and sqbs files for the time being.
  4. Basic lightning round support
Also, there's a website
Andrew Nadig

Mannhiem Mannheim Manheim Township, 2005-11
Carnegie Mellon University, 2011-15
User avatar
Atlashill
Wakka
Posts: 144
Joined: Sun Mar 16, 2014 4:52 pm
Location: Sedalia, MO

Re: Introducing YellowFruit.

Post by Atlashill »

I just had a tournament host who used YF 2.5.1 come across an issue when uploading files to the database this weekend. Apparently the _games.html file was rejected because "it does not appear to be a valid SQBS file".

(addendum) Found the culprit. 2.5.1 introduced a cumulative tossup score at the bottom of each game (awesome idea). Unfortunately, there is an HTML command in the code that the database might be rejecting:

Code: Select all

<td align=left><b>Total</b></td>
<td/>
<td align=right><b>2</b></td>
<td align=right><b>10</b></td>
<td align=right><b>130</b></td>
</tr>
<tr>
<td align=left><b>Total</b></td>
<td/>
<td align=right><b>0</b></td>
<td align=right><b>3</b></td>
<td align=right><b>30</b></td>
(another addendum) Jeffrey has informed me that the issue has been fixed on HSQB's end. I was able to upload a _games.html file created in YF2.5.1 without issue.
Last edited by Atlashill on Sun Feb 23, 2020 1:08 pm, edited 1 time in total.
Kyle Hill—Liberty (Mo.) '03—Truman State '07
Moderator for hire based in Sedalia, Mo.
ScoBo
Rikku
Posts: 286
Joined: Wed Jan 10, 2007 5:05 pm
Location: Kansas City area
Contact:

Re: Introducing YellowFruit.

Post by ScoBo »

Atlashill wrote: Sun Feb 23, 2020 12:22 pm (addendum) Found the culprit. 2.5.1 introduced a cumulative tossup score at the bottom of each game (awesome idea). Unfortunately, there is an HTML command in the code that the database might be rejecting:

Code: Select all

...
<td/>
...
Fixed the database to accept this. Sorry for the inconvenience. Anyone who uploaded stats this weekend might want to check if their games reports are missing and re-upload if it is.
Jeffrey Hill • Missouri Quizbowl Alliance president • UMR/Missouri S&T 2009 • Liberty (MO) 2005
Post your tournaments, SQBS reports, and question sets to the Quizbowl Resource Center Database!
User avatar
the return of AHAN
Auron
Posts: 1988
Joined: Thu Feb 01, 2007 10:40 pm

Re: Introducing YellowFruit.

Post by the return of AHAN »

Ndg wrote: Sun Feb 16, 2020 11:05 pm I've published a new version up above, with the following notable changes:
  1. You can now manually override final rankings (shown when reporting All Games)
  2. Use of "phase"/"stage" record to compute final rankings is now on by default. If this produces undesirable results, see #1 (or turn it off via the report settings).
  3. You can now export results in tournament schema (qbj) version 2.0 format. The main motivation for this is to be able to send more detailed results to NAQT than is possible with the SQBS format. However, there will undoubtedly be some kinks to work out, so I would advise sending NAQT both qbj and sqbs files for the time being.
  4. Basic lightning round support
Also, there's a website
Are there any plans to build a web-based version of this software that could provide live stats? BI used Neg5 yesterday primarily so I don't have to stand over my stats people, waiting for them to enter the sheets, and then upload a new stat report, before I go announce award winners and seeds for rebrackets. Neg5 makes that SUPER convenient, and it's the reason I use it, despite Yellow Fruit's superior interface.
Thank you for staffing yesterday, btw.
Jeff Price
Barrington High School Coach (2021 & 2023 HSNCT Champions, 2023 PACE Champions, 2023 Illinois Masonic Bowl Class 3A State Champions)
Barrington Station Middle School Coach (2013 MSNCT Champions, 2013 & 2017 Illinois Class AA State Champions)
------------------------------------------------------------------------------
User avatar
Ndg
Rikku
Posts: 387
Joined: Tue Oct 30, 2012 3:24 pm
Location: Wisconsin

Re: Introducing YellowFruit.

Post by Ndg »

Wow, sorry about that. Thanks for fixing it so quickly.
ScoBo wrote: Sun Feb 23, 2020 1:06 pm Fixed the database to accept this. Sorry for the inconvenience. Anyone who uploaded stats this weekend might want to check if their games reports are missing and re-upload if it is.
While we're on the subject of what the database will and won't accept -- it would be cool to be able upload pages with <tfoot> tags in them. :smile:
Andrew Nadig

Mannhiem Mannheim Manheim Township, 2005-11
Carnegie Mellon University, 2011-15
User avatar
Ndg
Rikku
Posts: 387
Joined: Tue Oct 30, 2012 3:24 pm
Location: Wisconsin

Re: Introducing YellowFruit.

Post by Ndg »

the return of AHAN wrote: Sun Feb 23, 2020 2:53 pm Are there any plans to build a web-based version of this software that could provide live stats? BI used Neg5 yesterday primarily so I don't have to stand over my stats people, waiting for them to enter the sheets, and then upload a new stat report, before I go announce award winners and seeds for rebrackets. Neg5 makes that SUPER convenient, and it's the reason I use it, despite Yellow Fruit's superior interface.
Thank you for staffing yesterday, btw.
Not right now, no. Maybe in the long term once I've finished all the other enhancements I can think of, but it's not something I have any idea how to do right now, so I'm not inclined to prioritize it.

Furthermore, I like the hsquizbowl database being the central repository for (non-NAQT) stats, and I'm reluctant to create yet another place people have to search for stats if they don't know where they are.
Andrew Nadig

Mannhiem Mannheim Manheim Township, 2005-11
Carnegie Mellon University, 2011-15
Joshua Rutsky
Tidus
Posts: 663
Joined: Mon Oct 24, 2005 9:59 am
Location: Hoover, AL

Re: Introducing YellowFruit.

Post by Joshua Rutsky »

I'd just like to say that we used YellowFruit yesterday for the Alabama State MS and ES championships, and it ran beautifully. The update to make worksheet/lightning rounds function was a godsend, and the interface is much easier than SQBS with one exception - in SQBS, you can tab into the field for team selection and begin typing the name of the team that is playing; in YellowFruit I was forced to click each time and select the field with my mouse before I could enter the team name. I don't know if that's a shortcut I'm missing or not, but it would be a nice fix for a future version. I also was a little uncertain about the way to set up field rankings manually, but eventually figured it out.

Thank you for this effort, and thank you to all of the folks out there taking time to write these great projects on their own time because they love the game.
Joshua Rutsky
VP for Curriculum and Camp Operations, Qwiz
ASCA Board Member
Hoover High School Coach (Retired)
User avatar
Atlashill
Wakka
Posts: 144
Joined: Sun Mar 16, 2014 4:52 pm
Location: Sedalia, MO

Re: Introducing YellowFruit.

Post by Atlashill »

Joshua Rutsky wrote: Mon Feb 24, 2020 11:54 amthe interface is much easier than SQBS with one exception - in SQBS, you can tab into the field for team selection and begin typing the name of the team that is playing; in YellowFruit I was forced to click each time and select the field with my mouse before I could enter the team name. I don't know if that's a shortcut I'm missing or not, but it would be a nice fix for a future version.
I'd also like to echo this suggestion, and likewise my gratitude for considering everyone's suggestions to developing this software. If you were to set up a Patreon, I suspect a few of us would happily make a contribution.
Kyle Hill—Liberty (Mo.) '03—Truman State '07
Moderator for hire based in Sedalia, Mo.
User avatar
Ndg
Rikku
Posts: 387
Joined: Tue Oct 30, 2012 3:24 pm
Location: Wisconsin

Re: Introducing YellowFruit.

Post by Ndg »

Atlashill wrote: Mon Feb 24, 2020 2:16 pm
Joshua Rutsky wrote: Mon Feb 24, 2020 11:54 amthe interface is much easier than SQBS with one exception - in SQBS, you can tab into the field for team selection and begin typing the name of the team that is playing; in YellowFruit I was forced to click each time and select the field with my mouse before I could enter the team name. I don't know if that's a shortcut I'm missing or not, but it would be a nice fix for a future version.
I'd also like to echo this suggestion,
I think I figured out a way to fix this. Hopefully it'll look decent. We'll see. In the meantime, I would point out that you can press Enter or the down arrow rather than clicking, although I realize that there isn't actually any visual indication of when the dropdown has focus.
Andrew Nadig

Mannhiem Mannheim Manheim Township, 2005-11
Carnegie Mellon University, 2011-15
User avatar
Ndg
Rikku
Posts: 387
Joined: Tue Oct 30, 2012 3:24 pm
Location: Wisconsin

Re: Introducing YellowFruit.

Post by Ndg »

Joshua Rutsky wrote: Mon Feb 24, 2020 11:54 am I also was a little uncertain about the way to set up field rankings manually, but eventually figured it out.
Looking at your stat reports, I think some of the weirdness is because you had single-elim playoffs (or maybe not quite... I can't tell) so you didn't actually have pools/divisions for the playoffs. I think if you just don't use a grouping phase, you'll get one big list of teams sorted in the right order since you already entered all of the rankings, and that will probably look nicer than grouping them by their prelim brackets.
Andrew Nadig

Mannhiem Mannheim Manheim Township, 2005-11
Carnegie Mellon University, 2011-15
Joshua Rutsky
Tidus
Posts: 663
Joined: Mon Oct 24, 2005 9:59 am
Location: Hoover, AL

Re: Introducing YellowFruit.

Post by Joshua Rutsky »

Ndg wrote: Wed Feb 26, 2020 12:50 pm
Atlashill wrote: Mon Feb 24, 2020 2:16 pm
Joshua Rutsky wrote: Mon Feb 24, 2020 11:54 amthe interface is much easier than SQBS with one exception - in SQBS, you can tab into the field for team selection and begin typing the name of the team that is playing; in YellowFruit I was forced to click each time and select the field with my mouse before I could enter the team name. I don't know if that's a shortcut I'm missing or not, but it would be a nice fix for a future version.
I'd also like to echo this suggestion,
I think I figured out a way to fix this. Hopefully it'll look decent. We'll see. In the meantime, I would point out that you can press Enter or the down arrow rather than clicking, although I realize that there isn't actually any visual indication of when the dropdown has focus.

Ah! Didn't realize that was an option, and I guess I never hit the enter key while I had the focus on that dropdown. That makes everything much easier.

Yeah, you're probably right about the ranking issue, but maybe adding a short explanation of how to make this work to your help page would be useful. I'll see if I can work one up quickly and share it with you if you will PM me an address. No need for you to do all the work. :)
Joshua Rutsky
VP for Curriculum and Camp Operations, Qwiz
ASCA Board Member
Hoover High School Coach (Retired)
User avatar
Father of the Ragdoll
Rikku
Posts: 270
Joined: Mon Apr 03, 2017 11:11 pm
Location: Austin, Texas

Re: Introducing YellowFruit.

Post by Father of the Ragdoll »

Came across what looks like an error of some sort. All of the headings for this entry are shifted 1 to the left starting with ppg.
Brad Maclaine, McLain
(they/them)
The University of Texas at Austin - Ph.D. Human Development and Family Sciences, 202X; M.S. Social Work, 2021
University of Illinois at Urbana-Champaign - B.S. Psychology, 2019
Rockford Auburn High School - 2015
User avatar
Atlashill
Wakka
Posts: 144
Joined: Sun Mar 16, 2014 4:52 pm
Location: Sedalia, MO

Re: Introducing YellowFruit.

Post by Atlashill »

Illinois Admin wrote: Mon Mar 09, 2020 2:19 pm Came across what looks like an error of some sort. All of the headings for this entry are shifted 1 to the left starting with ppg.
It looks like you didn't specify any divisions? If that's the case, then it looks like that cell was omitted altogether, rather than a blank space created to fill in.
Kyle Hill—Liberty (Mo.) '03—Truman State '07
Moderator for hire based in Sedalia, Mo.
User avatar
Father of the Ragdoll
Rikku
Posts: 270
Joined: Mon Apr 03, 2017 11:11 pm
Location: Austin, Texas

Re: Introducing YellowFruit.

Post by Father of the Ragdoll »

Atlashill wrote: Fri Mar 13, 2020 5:57 pm
Illinois Admin wrote: Mon Mar 09, 2020 2:19 pm Came across what looks like an error of some sort. All of the headings for this entry are shifted 1 to the left starting with ppg.
It looks like you didn't specify any divisions? If that's the case, then it looks like that cell was omitted altogether, rather than a blank space created to fill in.
That seems to be another issue. I specified divisions (each team is assigned to one) but it will not show up in the exported results
Brad Maclaine, McLain
(they/them)
The University of Texas at Austin - Ph.D. Human Development and Family Sciences, 202X; M.S. Social Work, 2021
University of Illinois at Urbana-Champaign - B.S. Psychology, 2019
Rockford Auburn High School - 2015
User avatar
Ndg
Rikku
Posts: 387
Joined: Tue Oct 30, 2012 3:24 pm
Location: Wisconsin

Re: Introducing YellowFruit.

Post by Ndg »

Atlashill wrote: Fri Mar 13, 2020 5:57 pm
Illinois Admin wrote: Mon Mar 09, 2020 2:19 pm Came across what looks like an error of some sort. All of the headings for this entry are shifted 1 to the left starting with ppg.
It looks like you didn't specify any divisions? If that's the case, then it looks like that cell was omitted altogether, rather than a blank space created to fill in.
yeah, the workaround here would be to actually implement the playoff divisions that the tournament used. (Edit: that was not the problem) Things tend to be a little weird when you're using phases or divisions but not both.

Obviously, still a bug. I'll fix it at some point. Not really in any hurry since there won't be any more stats for anyone to enter for a while.
Last edited by Ndg on Fri Mar 13, 2020 7:39 pm, edited 1 time in total.
Andrew Nadig

Mannhiem Mannheim Manheim Township, 2005-11
Carnegie Mellon University, 2011-15
User avatar
Ndg
Rikku
Posts: 387
Joined: Tue Oct 30, 2012 3:24 pm
Location: Wisconsin

Re: Introducing YellowFruit.

Post by Ndg »

Illinois Admin wrote: Fri Mar 13, 2020 7:07 pm
Atlashill wrote: Fri Mar 13, 2020 5:57 pm
Illinois Admin wrote: Mon Mar 09, 2020 2:19 pm Came across what looks like an error of some sort. All of the headings for this entry are shifted 1 to the left starting with ppg.
It looks like you didn't specify any divisions? If that's the case, then it looks like that cell was omitted altogether, rather than a blank space created to fill in.
That seems to be another issue. I specified divisions (each team is assigned to one) but it will not show up in the exported results
Turned out to be an issue with setting the correct phase's divisions to group teams by. I'm still working on making that more intuitive and discoverable.
Andrew Nadig

Mannhiem Mannheim Manheim Township, 2005-11
Carnegie Mellon University, 2011-15
nicole.
Rikku
Posts: 254
Joined: Sat May 04, 2019 11:16 am

Re: Introducing YellowFruit.

Post by nicole. »

For me, it appears the mac version of 2.5.1 crashes on launch every time I try to open it. Is that just me or is it widespread?
Nic Pruitt (they/them)

Founder of the Maine Quiz Bowl Alliance (MEQBA)
Bates College '25
Kings College London, Winter '24 Semester
Ridgewood '21
Director of Outreach, American Quizbowl League, Prometheus Science Bowl, and Long Island Quiz Bowl Alliance
Outreach and Technology, Florida Quiz Bowl Association
User avatar
Ndg
Rikku
Posts: 387
Joined: Tue Oct 30, 2012 3:24 pm
Location: Wisconsin

Re: Introducing YellowFruit.

Post by Ndg »

nick. wrote: Thu May 21, 2020 11:07 pm For me, it appears the mac version of 2.5.1 crashes on launch every time I try to open it. Is that just me or is it widespread?
I have not heard of anything like this happening. Any further details you can give me would be helpful (maybe).
Andrew Nadig

Mannhiem Mannheim Manheim Township, 2005-11
Carnegie Mellon University, 2011-15
nicole.
Rikku
Posts: 254
Joined: Sat May 04, 2019 11:16 am

Re: Introducing YellowFruit.

Post by nicole. »

Ok, so whenever I open YellowFruit 2.5.1 on my laptop, it crashes and I get this crash report. Link to the full report: https://docs.google.com/document/d/1Kqm ... sp=sharing
Nic Pruitt (they/them)

Founder of the Maine Quiz Bowl Alliance (MEQBA)
Bates College '25
Kings College London, Winter '24 Semester
Ridgewood '21
Director of Outreach, American Quizbowl League, Prometheus Science Bowl, and Long Island Quiz Bowl Alliance
Outreach and Technology, Florida Quiz Bowl Association
User avatar
Ndg
Rikku
Posts: 387
Joined: Tue Oct 30, 2012 3:24 pm
Location: Wisconsin

Re: Introducing YellowFruit.

Post by Ndg »

Thanks. I'm hopeful that some upgrades I've been planning to make soon will fix this. I'll have a new version out at some point this summer and I guess we'll see. Other than that there's not a whole lot of information to go off of.
Andrew Nadig

Mannhiem Mannheim Manheim Township, 2005-11
Carnegie Mellon University, 2011-15
Post Reply