OCCRA
Go to Post This 6 weeks of work, sweat, thinking, designing, building, talking, discussing, turning wrenches, wiring, programming, drawing on chalk boards, eating pizza, drinking mountain dew, with the students - is what the FIRST experience is really about. - meaubry [more]
Home
Go Back   Chief Delphi > Other > FIRST-related Organizations > The Blue Alliance
CD-Media  
portal register members calendar search Today's Posts Mark Forums Read FAQ rules

 
Reply
Thread Tools Rate Thread Display Modes
  #1   Spotlight this post!  
Unread 08-23-2018, 12:38 PM
Eiim's Avatar
Eiim Eiim is offline
Registered User
AKA: Ethan Chapman
FRC #4611 (OZone Robotics)
Team Role: CAD
 
Join Date: Jan 2018
Rookie Year: 2017
Location: Ohio
Posts: 15
Eiim is just really niceEiim is just really niceEiim is just really niceEiim is just really nice
TBA Requests - Google Sheets add-on for Blue Alliance data

I've just made and published TBA Requests, a Google Sheets add-on that allows you to easily access data from thebluealliance.com within Google Sheets. I know many teams, including my own this year, use Google Forms for scouting and Google Sheets for data analysis. One downside of this approach has always been that Blue Alliance data was difficult to use. This add-on tries to solve this problem. If you try it out, let me know what you think of it! (The code's also on Github, btw)
Reply With Quote
  #2   Spotlight this post!  
Unread 08-23-2018, 01:11 PM
nuclearnerd's Avatar
nuclearnerd nuclearnerd is offline
Speaking for myself, not my team
AKA: Brendan Simons
FRC #5406 (Celt-X)
Team Role: Engineer
 
Join Date: Jan 2014
Rookie Year: 2014
Location: Hamilton, Ontario, Canada
Posts: 883
nuclearnerd has a reputation beyond reputenuclearnerd has a reputation beyond reputenuclearnerd has a reputation beyond reputenuclearnerd has a reputation beyond reputenuclearnerd has a reputation beyond reputenuclearnerd has a reputation beyond reputenuclearnerd has a reputation beyond reputenuclearnerd has a reputation beyond reputenuclearnerd has a reputation beyond reputenuclearnerd has a reputation beyond reputenuclearnerd has a reputation beyond repute
Re: TBA Requests - Google Sheets add-on for Blue Alliance data

Ahmazing!

(says the data nerd who hasn't bothered to learn the TBA API yet)
Reply With Quote
  #3   Spotlight this post!  
Unread 08-23-2018, 03:52 PM
ngreen ngreen is online now
Mentor
AKA: Nelson Green
FRC #1108 (Panther Robotics)
Team Role: Mentor
 
Join Date: Jan 2003
Rookie Year: 2002
Location: Paola, KS
Posts: 1,067
ngreen has a reputation beyond reputengreen has a reputation beyond reputengreen has a reputation beyond reputengreen has a reputation beyond reputengreen has a reputation beyond reputengreen has a reputation beyond reputengreen has a reputation beyond reputengreen has a reputation beyond reputengreen has a reputation beyond reputengreen has a reputation beyond reputengreen has a reputation beyond repute
Re: TBA Requests - Google Sheets add-on for Blue Alliance data

Good work.

I started doing something: https://docs.google.com/spreadsheets...it?usp=sharing

I decided to try to make a twitter list using the TBA twitter accounts: https://twitter.com/FIRST_Team_1108/...tweets/members

There is a Zapier integration pulling the Twitter accounts from the Google Sheet ("Twitter List"). https://zapier.com/apps/google-sheet...a-twitter-list

One bottle neck was not seeing a straightforward way to get all the active team numbers. There may be a way to do it if I dug in, but it'd be something nice to have sometimes. Same with a way to get all the event keys for a given year. It might help to show a couple example of using the custom queries, which might solve this.

For now, I just queried the teams at the Greater Kansas City regional for this list. It actually turned out I wasn't following 3 local teams.
Reply With Quote
  #4   Spotlight this post!  
Unread 08-23-2018, 05:38 PM
Eiim's Avatar
Eiim Eiim is offline
Registered User
AKA: Ethan Chapman
FRC #4611 (OZone Robotics)
Team Role: CAD
 
Join Date: Jan 2018
Rookie Year: 2017
Location: Ohio
Posts: 15
Eiim is just really niceEiim is just really niceEiim is just really niceEiim is just really nice
Re: TBA Requests - Google Sheets add-on for Blue Alliance data

Quote:
Originally Posted by ngreen View Post
One bottle neck was not seeing a straightforward way to get all the active team numbers. There may be a way to do it if I dug in, but it'd be something nice to have sometimes. Same with a way to get all the event keys for a given year. It might help to show a couple example of using the custom queries, which might solve this.

For now, I just queried the teams at the Greater Kansas City regional for this list. It actually turned out I wasn't following 3 local teams.
Just found out that TBA does support finding all events and teams in a year. I'll definitely work on those given how useful they could be in various situations. I like the Zapier integration idea as well. I think a Twitter/Facebook/etc mass follow list for all FRC could be valuable for certain people/organizations/teams that want to be inclusive in helping out all teams.
Reply With Quote
  #5   Spotlight this post!  
Unread 08-23-2018, 07:53 PM
jaredhk's Avatar
jaredhk jaredhk is offline
No longer old enough to volunteer
AKA: Jared Hasen-Klein
no team (Volunteer, 1836 Alum, and extreme instigator)
 
Join Date: Feb 2015
Rookie Year: 2009
Location: 🥑Southern California
Posts: 486
jaredhk has a reputation beyond reputejaredhk has a reputation beyond reputejaredhk has a reputation beyond reputejaredhk has a reputation beyond reputejaredhk has a reputation beyond reputejaredhk has a reputation beyond reputejaredhk has a reputation beyond reputejaredhk has a reputation beyond reputejaredhk has a reputation beyond reputejaredhk has a reputation beyond reputejaredhk has a reputation beyond repute
Re: TBA Requests - Google Sheets add-on for Blue Alliance data

Brilliant. This makes me obsolete.
__________________
JARED HASEN-KLEIN
w: jaredhk.me // Facebook @jhasenklein // Instagram @rationalskeptic
―――
Dean's List Finalist // The Blue Alliance developer // Los Angeles FLL VOY 2017 // CPP 2022 // *53 FIRST Events and Counting! (16,874 miles) * // Team 1836: The MilkenKnights Class of 2018

―――
FREE ROBOTICS RESOURCES // Admin of: FB's FIRST ROBOTICS NETWORK // How to: FIRST DIVERSITY, EQUITY, & INCLUSION
―――
"I am, as I've said, merely competent. But in an age of incompetence, that makes me extraordinary." -Billy Joel
Reply With Quote
  #6   Spotlight this post!  
Unread 08-23-2018, 08:00 PM
AllenGregoryIV's Avatar
AllenGregoryIV AllenGregoryIV is offline
Engineering Coach
AKA: Allen "JAG" Gregory
FRC #3847 (Spectrum)
Team Role: Coach
 
Join Date: Jul 2008
Rookie Year: 2003
Location: Texas
Posts: 3,051
AllenGregoryIV has a reputation beyond reputeAllenGregoryIV has a reputation beyond reputeAllenGregoryIV has a reputation beyond reputeAllenGregoryIV has a reputation beyond reputeAllenGregoryIV has a reputation beyond reputeAllenGregoryIV has a reputation beyond reputeAllenGregoryIV has a reputation beyond reputeAllenGregoryIV has a reputation beyond reputeAllenGregoryIV has a reputation beyond reputeAllenGregoryIV has a reputation beyond reputeAllenGregoryIV has a reputation beyond repute
Send a message via AIM to AllenGregoryIV
Re: TBA Requests - Google Sheets add-on for Blue Alliance data

This is very useful, thanks for making this.
__________________

Team 647 | Cyber Wolf Corps | Alumni | 2003-2006 | Shoemaker HS
Team 2587 | DiscoBots | Mentor | 2008-2011 | Rice University / Houston Food Bank
Team 3847 | Spectrum | Coach | 2012-20... | St Agnes Academy
LRI | Alamo Regional | 2014-20...
"Competition has been shown to be useful up to a certain point and no further, but cooperation, which is the thing we must strive for today, begins where competition leaves off." - Franklin D. Roosevelt
Reply With Quote
  #7   Spotlight this post!  
Unread 08-23-2018, 08:04 PM
CptJJ's Avatar
CptJJ CptJJ is offline
Registered User
AKA: Jonathan Sessa
FRC #4414 (HighTide)
Team Role: Mentor
 
Join Date: Feb 2016
Rookie Year: 2013
Location: Ventura
Posts: 54
CptJJ is a name known to allCptJJ is a name known to allCptJJ is a name known to allCptJJ is a name known to allCptJJ is a name known to allCptJJ is a name known to all
As someone who has used TBA API in google sheets this addition would be much appreciated. This could really enable a lot of teams to create some awesome scouting data apps!
__________________
- Team 3925 (Circuit Of Life) Student / Engineering Director / Alumnus Mentor 2013 - 2018 -
- Deans List Finalist Ventura Regional 2016 -
- Team 4414 (HighTide) Lead Mentor 2018 - Now -
Reply With Quote
  #8   Spotlight this post!  
Unread 08-24-2018, 12:49 AM
Skyehawk's Avatar
Skyehawk Skyehawk is offline
Nuts N' Bolts
AKA: Skye Leake
FRC #2767 (Stryke Force, Thunder Robotics, Team F.U.N.)
Team Role: Mentor
 
Join Date: Nov 2012
Rookie Year: 2011
Location: Kalamazoo, MI
Posts: 702
Skyehawk has a reputation beyond reputeSkyehawk has a reputation beyond reputeSkyehawk has a reputation beyond reputeSkyehawk has a reputation beyond reputeSkyehawk has a reputation beyond reputeSkyehawk has a reputation beyond reputeSkyehawk has a reputation beyond reputeSkyehawk has a reputation beyond reputeSkyehawk has a reputation beyond reputeSkyehawk has a reputation beyond reputeSkyehawk has a reputation beyond repute
Re: TBA Requests - Google Sheets add-on for Blue Alliance data

Just dropping this in here, sorry I can't supply more context at the moment. Just do a google search for TBA Python support layer.

Using python & google sheets in harmony
__________________
My time in FIRST has made me a better person, frankly I don't know where I'd be without it.
  • A small mountain of hardware, good memories & life lessons with 876: 2011 - 2018
  • Inevitable good times with 2767 : 2018 - ????

Last edited by Skyehawk : 08-24-2018 at 12:52 AM.
Reply With Quote
  #9   Spotlight this post!  
Unread 08-24-2018, 01:25 AM
ngreen ngreen is online now
Mentor
AKA: Nelson Green
FRC #1108 (Panther Robotics)
Team Role: Mentor
 
Join Date: Jan 2003
Rookie Year: 2002
Location: Paola, KS
Posts: 1,067
ngreen has a reputation beyond reputengreen has a reputation beyond reputengreen has a reputation beyond reputengreen has a reputation beyond reputengreen has a reputation beyond reputengreen has a reputation beyond reputengreen has a reputation beyond reputengreen has a reputation beyond reputengreen has a reputation beyond reputengreen has a reputation beyond reputengreen has a reputation beyond repute
Re: TBA Requests - Google Sheets add-on for Blue Alliance data

Quote:
Originally Posted by Skyehawk View Post
Just dropping this in here, sorry I can't supply more context at the moment. Just do a google search for TBA Python support layer.

Using python & google sheets in harmony
Cool, complex but cool.

Something I'd like to try is to periodically run a python script to pull data from the Sheet and produce charts for the scouts and drive team. Last couple years I've had AppSheet apps, which use Sheets and Drive. This add-in looks helpful to get match data into Sheets and the Appsheet app can be used by scouts for data input (on phones -- or synced later). The python script will create graphs, save them to the drive and update the Sheet. There are several places run a periodic script from, but I recall the IBM cloud virtual kit having that ability -- maybe something like this.

Quote:
Originally Posted by Eiim View Post
Just found out that TBA does support finding all events and teams in a year. I'll definitely work on those given how useful they could be in various situations. I like the Zapier integration idea as well. I think a Twitter/Facebook/etc mass follow list for all FRC could be valuable for certain people/organizations/teams that want to be inclusive in helping out all teams.
Some reason TBACustom is returning blank for me. I was trying "=TBACustom("teams/1","team_number")", for example.
Reply With Quote
  #10   Spotlight this post!  
Unread 08-24-2018, 01:41 AM
jaredhk's Avatar
jaredhk jaredhk is offline
No longer old enough to volunteer
AKA: Jared Hasen-Klein
no team (Volunteer, 1836 Alum, and extreme instigator)
 
Join Date: Feb 2015
Rookie Year: 2009
Location: 🥑Southern California
Posts: 486
jaredhk has a reputation beyond reputejaredhk has a reputation beyond reputejaredhk has a reputation beyond reputejaredhk has a reputation beyond reputejaredhk has a reputation beyond reputejaredhk has a reputation beyond reputejaredhk has a reputation beyond reputejaredhk has a reputation beyond reputejaredhk has a reputation beyond reputejaredhk has a reputation beyond reputejaredhk has a reputation beyond repute
Re: TBA Requests - Google Sheets add-on for Blue Alliance data

Quote:
Originally Posted by ngreen View Post
Some reason TBACustom is returning blank for me. I was trying "=TBACustom("teams/1","team_number")", for example.
Me too actually. Hadn't tried that yet.
__________________
JARED HASEN-KLEIN
w: jaredhk.me // Facebook @jhasenklein // Instagram @rationalskeptic
―――
Dean's List Finalist // The Blue Alliance developer // Los Angeles FLL VOY 2017 // CPP 2022 // *53 FIRST Events and Counting! (16,874 miles) * // Team 1836: The MilkenKnights Class of 2018

―――
FREE ROBOTICS RESOURCES // Admin of: FB's FIRST ROBOTICS NETWORK // How to: FIRST DIVERSITY, EQUITY, & INCLUSION
―――
"I am, as I've said, merely competent. But in an age of incompetence, that makes me extraordinary." -Billy Joel
Reply With Quote
  #11   Spotlight this post!  
Unread 08-24-2018, 02:27 AM
ngreen ngreen is online now
Mentor
AKA: Nelson Green
FRC #1108 (Panther Robotics)
Team Role: Mentor
 
Join Date: Jan 2003
Rookie Year: 2002
Location: Paola, KS
Posts: 1,067
ngreen has a reputation beyond reputengreen has a reputation beyond reputengreen has a reputation beyond reputengreen has a reputation beyond reputengreen has a reputation beyond reputengreen has a reputation beyond reputengreen has a reputation beyond reputengreen has a reputation beyond reputengreen has a reputation beyond reputengreen has a reputation beyond reputengreen has a reputation beyond repute
Re: TBA Requests - Google Sheets add-on for Blue Alliance data

Quote:
Originally Posted by jaredhk View Post
Me too actually. Hadn't tried that yet.
Looking at code, I suspect this (Line 657):

return JSON.stringify(json[0]['blue_score'])

shouldn't be there.

https://github.com/Eiim/tba-requests/blob/master/TBA.gs
Reply With Quote
  #12   Spotlight this post!  
Unread 08-24-2018, 07:43 AM
Eiim's Avatar
Eiim Eiim is offline
Registered User
AKA: Ethan Chapman
FRC #4611 (OZone Robotics)
Team Role: CAD
 
Join Date: Jan 2018
Rookie Year: 2017
Location: Ohio
Posts: 15
Eiim is just really niceEiim is just really niceEiim is just really niceEiim is just really nice
Re: TBA Requests - Google Sheets add-on for Blue Alliance data

Quote:
Originally Posted by ngreen View Post
Looking at code, I suspect this (Line 657):

return JSON.stringify(json[0]['blue_score'])

shouldn't be there.

https://github.com/Eiim/tba-requests/blob/master/TBA.gs
Correct! Not sure why that's there. I'll update the add-on and Github today.
Reply With Quote
  #13   Spotlight this post!  
Unread 08-24-2018, 07:47 AM
Billfred's Avatar
Billfred Billfred is offline
Never look back, no, never say die
AKA: Always attack with the warrior's cry...
FRC #1293 (Pandamaniacs); FTC #11444 (Garnet Squadron) (Also, CD mod.)
Team Role: Mentor
 
Join Date: Feb 2004
Rookie Year: 2004
Location: The Shadow Realm
Posts: 9,624
Billfred has a reputation beyond reputeBillfred has a reputation beyond reputeBillfred has a reputation beyond reputeBillfred has a reputation beyond reputeBillfred has a reputation beyond reputeBillfred has a reputation beyond reputeBillfred has a reputation beyond reputeBillfred has a reputation beyond reputeBillfred has a reputation beyond reputeBillfred has a reputation beyond reputeBillfred has a reputation beyond repute
Re: TBA Requests - Google Sheets add-on for Blue Alliance data

Quote:
Originally Posted by jaredhk View Post
Brilliant. This makes me obsolete.
https://www.youtube.com/watch?v=qeWEMKMV1Ko

I don't have an immediate need for this spreadsheet, but I am so looking forward to it next season!
__________________
William "Billfred" Leverette - Gamecock/Jessica Boucher victim/Owner/Director of Bricks 4 Kidz in Columbia, SC.

2004-2006: FRC 1293 (D5 Robotics) - Student, Mentor, Coach
2007-2009: FRC 1618 (Capital Robotics) - Mentor, Coach
2009-2013: FRC 2815 (Los Pollos Locos) - Mentor, Coach - Palmetto '09, Peachtree '11, Palmetto '11, Palmetto '12
2010: FRC 1398 (Keenan Robo-Raiders) - Mentor - Palmetto '10
2014-2016: FRC 4901 (Garnet Squadron) - Co-Founder and Head Bot Coach - Orlando '14, SCRIW '16
2017: FRC 5402 (Iron Kings) - Mentor, Coach (oh, and I worked at AndyMark during this time)
2018-: FRC 1293 (Pandamaniacs) - Mentor

114 events (more than will fit in a ChiefDelphi signature), 15 seasons, over 74,500 miles, and still on a mission from Bob.
Rule #1: Do not die. Rule #2: Be respectful. Rule #3: Be safe. Rule #4: Follow the handbook.
Reply With Quote
  #14   Spotlight this post!  
Unread 08-24-2018, 02:41 PM
lynca's Avatar
lynca lynca is online now
Andrew Lynch
FRC #2587 (DiscoBots)
Team Role: Mentor
 
Join Date: Feb 2004
Rookie Year: 2001
Location: Houston, TX
Posts: 1,765
lynca has a reputation beyond reputelynca has a reputation beyond reputelynca has a reputation beyond reputelynca has a reputation beyond reputelynca has a reputation beyond reputelynca has a reputation beyond reputelynca has a reputation beyond reputelynca has a reputation beyond reputelynca has a reputation beyond reputelynca has a reputation beyond reputelynca has a reputation beyond repute
Re: TBA Requests - Google Sheets add-on for Blue Alliance data

This is a great first step for people looking to dive more into TBA API.

The TBA Request Help document was helpful.

I also like the idea of people sharing their TBA Google Sheet Template.

I made an Event List Example
__________________
History: 624 -->118 --> 2158 --> 2587
LinkedIn , Facebook, Twitter

Last edited by lynca : 08-24-2018 at 02:44 PM.
Reply With Quote
  #15   Spotlight this post!  
Unread 08-24-2018, 03:03 PM
ngreen ngreen is online now
Mentor
AKA: Nelson Green
FRC #1108 (Panther Robotics)
Team Role: Mentor
 
Join Date: Jan 2003
Rookie Year: 2002
Location: Paola, KS
Posts: 1,067
ngreen has a reputation beyond reputengreen has a reputation beyond reputengreen has a reputation beyond reputengreen has a reputation beyond reputengreen has a reputation beyond reputengreen has a reputation beyond reputengreen has a reputation beyond reputengreen has a reputation beyond reputengreen has a reputation beyond reputengreen has a reputation beyond reputengreen has a reputation beyond repute
Re: TBA Requests - Google Sheets add-on for Blue Alliance data

Quote:
Originally Posted by lynca View Post
This is a great first step for people looking to dive more into TBA API.

The TBA Request Help document was helpful.

I also like the idea of people sharing their TBA Google Sheet Template.

I made an Event List Example
Oops, didn't notice I shared my TBA API authorization key. Looking over your document reminded me. Something to think of before sharing.

I like the idea of having some template.
Reply With Quote
Reply


Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT -5. The time now is 08:38 PM.

The Chief Delphi Forums are sponsored by Innovation First International, Inc.


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
Copyright © Chief Delphi