Log in

View Full Version : BBQ FIRST Website Reveal


Beaker
18-12-2014, 20:26
Inspired by this thread (http://www.chiefdelphi.com/forums/showthread.php?t=127716&highlight=Waterloo+Regional+2014), I created a website called BBQ FIRST to display blue banner related information all in one place.

BBQ FIRST currently can be used to find BBQ(Blue Banner Quotient) and SAUCE(Sextuple Advancement Uniform Counting Era), with the possibility of additional statistics metrics in the future. The website also shows rankings by BBQ and SAUCE, in case you were interested in finding the "Strongest" competitions like those in this thread (http://www.chiefdelphi.com/forums/showthread.php?t=131574&highlight=bbq).

Check it out here: bbqfirst.x10host.com (http://bbqfirst.x10host.com/index.php)

Happy BBQing!

AllenGregoryIV
18-12-2014, 22:42
Looks pretty good, thanks for making this.

Future Feature suggestions
- Ability to sort on the event pages. It would be nice to be able to sort by blue banners.
- Show where the banners came from on the team pages. If I see a team with a couple banners it would be nice to click and see quickly what they were for.

dodar
18-12-2014, 23:10
I dont know the depth of this, but just from the data I know offhand some data is missing. It looks like some of the 2005 data is missing.

Beaker
18-12-2014, 23:19
I dont know the depth of this, but just from the data I know offhand some data is missing. It looks like some of the 2005 data is missing.

As I've been working on this project I have noticed that the further back I've gone in years, lesser data is given by TBA. What did you notice that is missing? I would like to resolve this issue as soon as possible.


Future Feature suggestions
- Ability to sort on the event pages. It would be nice to be able to sort by blue banners.
- Show where the banners came from on the team pages. If I see a team with a couple banners it would be nice to click and see quickly what they were for.

Those are some good ideas! I will make sure to implement them in the near future.

dodar
19-12-2014, 00:12
Orlando 2005 is missing banners.

Jacob Bendicksen
19-12-2014, 00:41
This is awesome - hopefully we'll find more comestible statistics soon.

Beaker
19-12-2014, 00:43
Orlando 2005 is missing banners.

After looking into this some more, it looks like Orlando 2005 is missing an awards section on TBA, which would naturally lead to some banner loss.

The whole event seems to be messed up, with the Pink team appearing in 3 of the Eliminations Alliances, along with 2 6-team alliances against each other in the semifinals.

TBA link (http://www.thebluealliance.com/event/2005fl)

Hopefully, TBA can fix this. Until then, there is not much I can do.

wilful
19-12-2014, 01:31
I do believe that you have some data issues other than one 2005 event, just looking at my old high school team (766), the blue banners count has issues. Your site has 766 with one banner. However, the team was part of two winning alliances while I was a student (2011 sacramento, 2012 svr) and has wins both before and after. I checked TBA and they have the wins recorded, so either what you have considered as banners does not match with me and should be made more clear, or something is causing malfunctions with the data between what I see on TBA and what I see on your website.

I am not sure if this is a localized event or not, but I thought that it should be made known. I did notice that some of TBA's data was missing, although this does not account for the loss of quite a number of banners.

EDIT:

I was just changing the years and noticed that the number of banners changes with the year. It seems that 2015 is acting strange.

Beaker
19-12-2014, 01:41
So in response to wilful, it looks as if the 2011 and 2015 data scripts did not complete correctly for some teams. This is mainly due to an error that occurred when I ran multiple scripts at once, and the error has been resolved for 2011, but I am still working on 2015.

This error will be resolved shortly. The site may go down for 2-3 minutes so that I can update the data, but it will be accurate, which is what matters.

Beaker
19-12-2014, 01:44
Also, to avoid any confusion, the website not only does year by year banners, but also does week by week banners. This ensures that all banners were earned before the regional that the BBQ is being calculated for. If your team has less banners for a past event, this may be the cause.

Cory
19-12-2014, 10:41
Darn, I saw the thread title and was hoping for a listing of all good bbq joints within close proximity of each FRC event.

marshall
19-12-2014, 10:54
Darn, I saw the thread title and was hoping for a listing of all good bbq joints within close proximity of each FRC event.

Come to NC and we can take you to a few. ;-)

MARS_James
19-12-2014, 11:09
Ok i know BBQ and SAUCE but what is BBQ PDQ, BRIQUETTE and RIBS?

Navid Shafa
19-12-2014, 12:01
Any chance we can get a team rankings section for overall BBQ and overall BBQ by year?

MrForbes
19-12-2014, 12:09
842 has zero blue banners? I think there might be a few issues with BBQ....

Jack S.
19-12-2014, 13:08
Ok i know BBQ and SAUCE but what is BBQ PDQ, BRIQUETTE and RIBS?

In the top right hand corner there is a button labeled help. This button takes you to a page with information regarding the website, including the definitions of the various edible banner statistics. This button will be made more visible.

Here's the link:
http://bbqfirst.x10host.com/help.php

Beaker
19-12-2014, 13:20
842 has zero blue banners? I think there might be a few issues with BBQ....

This is actually the same thing that wilful pointed out earlier. I am actively working on this issue and have found the solution. The website will be updated to fix this very soon.

Thank you for pointing this out. I hate inaccurate data.

Libby K
19-12-2014, 13:26
- Show where the banners came from on the team pages. If I see a team with a couple banners it would be nice to click and see quickly what they were for.

Also, there's definitely data other than '05 missing - for example, 1923 is listed as only having one banner (not true.) Even if you're only counting 'banners' as event wins, we have two - 2009 New Jersey and 2011 Connecticut. Not sure which one is missing, since (as Allen mentioned) you can't tell what the listed one is from. This would be a helpful feature not only for searching but also in helping troubleshoot what's still coming in. :)

Jared
19-12-2014, 14:00
It seems to be missing some blue alliance data too. 236 got regional chairmans in 2008 that shows on blue alliance but not on BBQ.

mwmac
19-12-2014, 14:01
Also, there's definitely data other than '05 missing - for example, 1923 is listed as only having one banner (not true.) Even if you're only counting 'banners' as event wins, we have two - 2009 New Jersey and 2011 Connecticut. Not sure which one is missing, since (as Allen mentioned) you can't tell what the listed one is from. This would be a helpful feature not only for searching but also in helping troubleshoot what's still coming in. :)

2009 is missing for 1923

mwmac
19-12-2014, 14:38
In the top right hand corner there is a button labeled help. This button takes you to a page with information regarding the website, including the definitions of the various edible banner statistics. This button will be made more visible.

Here's the link:
http://bbqfirst.x10host.com/help.php

This is very helpful. One suggestion to assist in gauging a team's on field robot performance would be to net out blue banners associated with Chairman's awards earned. You could label this measure "Hot Sauce" in keeping with your food-centric nomenclature...

JesseK
20-12-2014, 09:04
These stats ... make no sense. The ranking of the results attempts to find a level of comparative competitiveness based upon 10 seasons of data in a competition where the only thing which is guaranteed to last 10 seasons are the bigger investments a team has made in tooling, infrastructure or facilities.

The stats don't even take into account groups of teams which keep winning the same Regional, thereby inflating that event's BBQ-ness.

It seems to me like we'd get a more realistic picture by using the trailing 2-4 years of event data for a given event and year, rather than "for all time".

Beaker
20-12-2014, 09:17
It seems to me like we'd get a more realistic picture by using the trailing 2-4 years of event data for a given event and year, rather than "for all time".

It seems to me that the statistics you are looking for are BRIQUETTE (Basically BBQ based on the last four years) and RIBS (BBQ based on the previous year).

Also, to calculate BBQ, the website is using every blue banner ever won (once the data is fixed in about an hour). SAUCE is the statistic that only has 10 years of data.

Michael Hill
20-12-2014, 10:16
It seems to me that the statistics you are looking for are BRIQUETTE (Basically BBQ based on the last four years) and RIBS (BBQ based on the previous year).

Also, to calculate BBQ, the website is using every blue banner ever won (once the data is fixed in about an hour). SAUCE is the statistic that only has 10 years of data.

ok, is this April Fools day or something?

Beaker
20-12-2014, 12:56
ok, is this April Fools day or something?

No it isn't. It's also no prank that the new data is uploaded. I have verified the banner counts of the teams that had missing blue banners, and that looks good now.

Oh and by the way:

- Show where the banners came from on the team pages. If I see a team with a couple banners it would be nice to click and see quickly what they were for.

Consider it done: http://bbqfirst.x10host.com/team_info.php?year=2015&tem=3847

Since I'm pretty confident that I have accurate data, I will update the calculations for each regional. That script takes about an hour so expect the website to be down around an hour from now for up to 5 minutes.

dodar
20-12-2014, 13:04
No it isn't. It's also no prank that the new data is uploaded. I have verified the banner counts of the teams that had missing blue banners, and that looks good now.

Oh and by the way:


Consider it done: http://bbqfirst.x10host.com/team_info.php?year=2015&tem=3847

Since I'm pretty confident that I have accurate data, I will update the calculations for each regional. That script takes about an hour so expect the website to be down around an hour from now for up to 5 minutes.
Nope, still missing 2005 Orlando.

Beaker
20-12-2014, 13:19
Nope, still missing 2005 Orlando.

In 2005, the Orlando Regional was officially called The Florida Regional.

It can be found here: http://bbqfirst.x10host.com/event_info.php?key=2005fl&year=2005

and here: http://www.thebluealliance.com/event/2005fl

If your team is missing awards from this event, it is probably because TBA doesn't have an awards page for the Florida Regional in 2005.

dodar
20-12-2014, 13:32
In 2005, the Orlando Regional was officially called The Florida Regional.

It can be found here: http://bbqfirst.x10host.com/event_info.php?key=2005fl&year=2005

and here: http://www.thebluealliance.com/event/2005fl

If your team is missing awards from this event, it is probably because TBA doesn't have an awards page for the Florida Regional in 2005.

Cant you manually input it? Missing banners, however many the amount, completely alters any data after the year missing data.

Beaker
20-12-2014, 13:54
I will manually input the data for you and your alliance partners, and make note of it so that the script doesn't overwrite it.

Michael Hill
20-12-2014, 15:06
No it isn't. It's also no prank that the new data is uploaded. I have verified the banner counts of the teams that had missing blue banners, and that looks good now.

Oh and by the way:


Consider it done: http://bbqfirst.x10host.com/team_info.php?year=2015&tem=3847

Since I'm pretty confident that I have accurate data, I will update the calculations for each regional. That script takes about an hour so expect the website to be down around an hour from now for up to 5 minutes.

I was just joking about how many ridiculous acronyms there are for statistics.

Beaker
20-12-2014, 17:07
I was just joking about how many ridiculous acronyms there are for statistics.

I was counter-joking about your joking. Most of those names I got from the Waterloo 2014 thread.

Also, the new data is all out there for the regionals now. Thanks for the help with troubleshooting. I am open to new features if there are any more requests.

OZ_341
20-12-2014, 17:34
Very fun to see this data for each team. Must have been a lot of work.

Two banners are missing for 341. We won Philly Chairman's in 2003 and Chesapeake Chairman's in 2005, for a total of 20 banners.

Thanks!

AdamHeard
20-12-2014, 17:42
The 2005 FMS had issues and many results are missing.

Not the fault of the site maker...

Beaker
20-12-2014, 21:08
Very fun to see this data for each team. Must have been a lot of work.

Two banners are missing for 341. We won Philly Chairman's in 2003 and Chesapeake Chairman's in 2005, for a total of 20 banners.

Thanks!

Thanks, it was quite the project.

After manually entering the data for that 2005 Florida Regional alliance, it seems like it will be quite another to keep manually entering data, however I will take note of yours and Libby's requests and when I find a more feasible method to do manual input, your data will be entered.

Also:
Any chance we can get a team rankings section for overall BBQ and overall BBQ by year?

If you mean a teams rankings section by banners, then yes it will happen. For now, there is a way to access an all teams ranking:

Go to the Manual Calculator
Type in 1 and press Tab
Type 9999 and press Tab


Of course there will be a more visible version eventually.

Navid Shafa
21-12-2014, 06:19
If you mean a teams rankings section by banners, then yes it will happen. For now, there is a way to access an all teams ranking:

Go to the Manual Calculator
Type in 1 and press Tab
Type 9999 and press Tab


Of course there will be a more visible version eventually.

Being able to see the full banner count list is cool, where as TBA Insights only shows the top of the ladder (without the ability to expand to the full data set). I look forward to the future additions you have in mind. Thanks for sharing!

Beaker
18-01-2015, 22:23
BBQ FIRST was down for a couple of days recently due to an error with my account. It's resolved now, but I had to create a new url for the website.

Here is the updated link: http://bbqfrc.x10host.com/

There have been a few updates, since I last posted. Check those out and as always, suggestions are welcomed!

Navid Shafa
30-03-2015, 18:42
So far the database seems to have been staying up to date, but it is currently behind on some of this week's cooking. ;)

How does the updating process work?

Jacob Bendicksen
30-03-2015, 19:27
So far the database seems to have been staying up to date, but it is currently behind on some of this week's cooking. ;)

How does the updating process work?

According to the help section on the website, here's how it works:

The website uses data that is pulled from The Blue Alliance. On an offline server the data is manipulated and is later uploaded to the live website. During these data uploads the website may be down for 10 minutes, but these uploads ensure that information is displayed faster than recalculating every time a page is requested.

Navid Shafa
30-03-2015, 19:40
According to the help section on the website, here's how it works:

Then the real question is, how often?

Beaker
30-03-2015, 21:06
Every week by Tuesday I have the data up to date

346CADmen
31-03-2015, 12:47
Darn, I saw the thread title and was hoping for a listing of all good bbq joints within close proximity of each FRC event.

Same here. In that spirit, for the VA regional the answer, is Buzz & Ned's, less than 2 miles from VCU.

Beaker
16-04-2015, 01:07
For all of your championship divisional BBQ desires...

http://bbqfrc.x10host.com/champs.php

Navid Shafa
30-04-2015, 18:32
Every week by Tuesday I have the data up to date

Any chance we can get a Post-CMP update?

Beaker
30-04-2015, 20:17
Of course. I was going to wait for chairman's data to be posted on TBA, but that doesn't look like it is happening anytime soon. It will be up tonight

Navid Shafa
30-04-2015, 20:19
Of course. I was going to wait for chairman's data to be posted on TBA, but that doesn't look like it is happening anytime soon. It will be up tonight

Other than 597 winning HOF, what else are you still needing?

Beaker
30-04-2015, 20:34
Other than 597 winning HOF, what else are you still needing?

That is all I need. Everything else looks like it is updated on TBA.

EDIT: Looks like TBA doesn't have some of the divisional awards posted. I will just have to rebuild data multiple times.

Navid Shafa
08-02-2016, 16:04
http://bbqfrc.x10host.com/champs.php

"This Account Has Been Suspended."

:(

Beaker
08-02-2016, 16:26
I didnt visit my account last month because I missed my calendar reminder. It should be unsuspended now.

Navid Shafa
08-03-2016, 16:30
Will this be updated throughout the season?

VacioArconte
08-03-2016, 16:51
Does anyone know what the different metrics stand for and what the numbers actually mean? The help page on the website is down.

Beaker
13-03-2016, 11:37
Will this be updated throughout the season?

Yep. I try to have it updated by Wednesday each week.

Navid Shafa
08-10-2016, 21:29
Looks like the banner counts for last season may not be included/propagated correctly.

Beaker
09-10-2016, 11:44
Looks like the banner counts for last season may not be included/propagated correctly.

The past two years I have loaded in the events for the next year, along with all the new teams using my local server setup. Over the summer, I added functionality for the website to update itself in the early morning hours on a weekday, in order to streamline the event update process.

The transition to a new season involves a lot of work, so I am currently working on a way to automate the whole process. The banners should be updated as soon as this is figured out, however there are quite a few changes that need to be made.

As I have just started college, I am trying to make it possible for BBQ FIRST to run itself as much as possible. I wouldn't mind help with the website either, it could be a really good experience for student web developers. Any interested students can DM me for more information.

ghesla
09-10-2016, 11:52
We really appreciate your work. Thank you!

Kartoffee
09-10-2016, 14:07
404 error. Can't view.

Beaker
09-10-2016, 16:03
404 error. Can't view.

http://downforeveryoneorjustme.com/bbqfrc.x10host.com

What?

Navid Shafa
09-10-2016, 16:36
Worked fine for me yesterday, seems to be just fine today.

euhlmann
09-10-2016, 16:54
http://downforeveryoneorjustme.com/bbqfrc.x10host.com

What?

The link in the original post is incorrect

Beaker
10-10-2016, 19:06
The link in the original post is incorrect

Yeah, there was a link change at a point after the time allowed for editing the original post. Sorry for the confusion.

JB987
10-10-2016, 19:53
Data shows only 4 BB for 987 in 2016, missing RCA and WCA also earned. Does BBQ no longer count off field banners?

Beaker
11-10-2016, 14:09
Data shows only 4 BB for 987 in 2016, missing RCA and WCA also earned. Does BBQ no longer count off field banners?

It should count those. I will look into the issue.

Joe Ross
11-10-2016, 14:23
Data shows only 4 BB for 987 in 2016, missing RCA and WCA also earned. Does BBQ no longer count off field banners?

I think it's championship banners it's not counting, not off the field banners.

mwmac
11-10-2016, 14:38
I think it's championship banners it's not counting, not off the field banners.

Correct, it is not counting Divisional banners at CMP...

Beaker
29-10-2016, 00:50
Correct, it is not counting Divisional banners at CMP...

After looking into the issue, the transition to automatic updates in the offseason resulted in a hole being left in some of the data. I have resolved the issue, and 987's team page should be correct now.

In the coming weeks I will be working on the automatic data generation for next year's events. This should be done before the 2017 season.