Go to Post Dash Board: Hey Robot, here is some new data. Dash Board: Robot, did you get that data yet? Hello? Robot: Yep! Thanks! Yep! Thanks! Yep! Thanks! Yep! Thanks! Yep! Thanks! Yep! Thanks!... Other Robots: Will you please shut up? - EricVanWyk [more]
Home
Go Back   Chief Delphi > Competition > Rules/Strategy > Scouting
CD-Media   CD-Spy  
portal register members calendar search Today's Posts Mark Forums Read FAQ rules

 
Closed Thread
Thread Tools Rate Thread Display Modes
  #1   Spotlight this post!  
Unread 11-03-2014, 22:15
bbradf44's Avatar
bbradf44 bbradf44 is offline
Registered User
AKA: Brad
FRC #3344 (Robocopz)
Team Role: Driver
 
Join Date: May 2013
Rookie Year: 2011
Location: Peachtree City
Posts: 111
bbradf44 is just really nicebbradf44 is just really nicebbradf44 is just really nicebbradf44 is just really nice
Question HTMLish based scouting

So im not even sure if this is possible, but ill give it a shot and see what people think. This year we are running scouting in the stands through either MS Excel or Access so that it can be run through Tableau. Our current setup requires all 6 scouts to have forms to fill out while the 7th inputs them into the database, then an 8th person runs a USB flash drive back and forth to the pits whenever we want to update where we have the Tableau program running. I got the idea while in my web design class today, would it be possible to have an HTML form running on cell phones or other 3g/4g enabled device that when the submit button is pressed, it sends the data to the database that will be either on our team website or in the cloud, which i can then open on my laptop in our pit(usb tethered to my phone)? The html file itself wont be online(but maybe i could put that on our website too) but rather stored on each of the phones. Ideas/criticisms welcome
  #2   Spotlight this post!  
Unread 11-03-2014, 22:32
SteveGPage's Avatar
SteveGPage SteveGPage is offline
Mentor - Scouting and Strategy
AKA: Steve
FRC #0836 (RoboBees)
Team Role: Mentor
 
Join Date: Feb 2006
Rookie Year: 2004
Location: Hollywood, MD
Posts: 521
SteveGPage has a reputation beyond reputeSteveGPage has a reputation beyond reputeSteveGPage has a reputation beyond reputeSteveGPage has a reputation beyond reputeSteveGPage has a reputation beyond reputeSteveGPage has a reputation beyond reputeSteveGPage has a reputation beyond reputeSteveGPage has a reputation beyond reputeSteveGPage has a reputation beyond reputeSteveGPage has a reputation beyond reputeSteveGPage has a reputation beyond repute
A couple of years ago we did something very similar to this approach. I set up a "Google Form" that any of the scout could run from any smartphone. They would enter the data for each robot/match. This data was stored in a google spreadsheet. Every 5 matches or so, I would download the data into excel (via a tethered hotspot) and then read it with a similar tool to Tableau (QlikView). Now we use an in-house developed Android app that loads data into a SQL database, but is still read via the dashboard. Hope this helps.
__________________
FRC 836, The RoboBees www.robobees.org
growingSTEMS www.growingSTEMS.org
2017: Southwest VA, Northern MD, Chesapeake District Championships, Championships
  #3   Spotlight this post!  
Unread 11-03-2014, 22:46
bbradf44's Avatar
bbradf44 bbradf44 is offline
Registered User
AKA: Brad
FRC #3344 (Robocopz)
Team Role: Driver
 
Join Date: May 2013
Rookie Year: 2011
Location: Peachtree City
Posts: 111
bbradf44 is just really nicebbradf44 is just really nicebbradf44 is just really nicebbradf44 is just really nice
Quote:
Originally Posted by SteveGPage View Post
A couple of years ago we did something very similar to this approach. I set up a "Google Form" that any of the scout could run from any smartphone. They would enter the data for each robot/match. This data was stored in a google spreadsheet. Every 5 matches or so, I would download the data into excel (via a tethered hotspot) and then read it with a similar tool to Tableau (QlikView). Now we use an in-house developed Android app that loads data into a SQL database, but is still read via the dashboard. Hope this helps.
That actually helps a lot. And here I am trying to over complicate things again with HTML and such. So did you have to re download the excel data every time or would you just be able to refresh if you have the Google drive installed?
__________________
2011: FRC 1922 Team Member
2012 (Build weeks 1-3): FRC 1922 Team Member

2012 (Weeks 4-Competition): FRC 3344 Mechanic and Pit Crew
2013: FRC 3344 Mechanical Lead and Head Driver
2014: FRC 3344 Team Captain and Head Driver

Record as driver: 7-11-0 and Proud of it

Last edited by bbradf44 : 11-03-2014 at 22:51.
  #4   Spotlight this post!  
Unread 11-03-2014, 23:15
SteveGPage's Avatar
SteveGPage SteveGPage is offline
Mentor - Scouting and Strategy
AKA: Steve
FRC #0836 (RoboBees)
Team Role: Mentor
 
Join Date: Feb 2006
Rookie Year: 2004
Location: Hollywood, MD
Posts: 521
SteveGPage has a reputation beyond reputeSteveGPage has a reputation beyond reputeSteveGPage has a reputation beyond reputeSteveGPage has a reputation beyond reputeSteveGPage has a reputation beyond reputeSteveGPage has a reputation beyond reputeSteveGPage has a reputation beyond reputeSteveGPage has a reputation beyond reputeSteveGPage has a reputation beyond reputeSteveGPage has a reputation beyond reputeSteveGPage has a reputation beyond repute
I'm glad it helps! I took the programming easy route and just reloaded the entire data set. It didn't take but 3 or 4 seconds, so I didn't worry about trying to just load the new records. At the time, I didn't have Google Drive installed, so I might do it differently now if that was what we are doing now.
__________________
FRC 836, The RoboBees www.robobees.org
growingSTEMS www.growingSTEMS.org
2017: Southwest VA, Northern MD, Chesapeake District Championships, Championships
  #5   Spotlight this post!  
Unread 11-03-2014, 23:17
saikiranra's Avatar
saikiranra saikiranra is offline
UCI
AKA: Saikiran Ramanan
FRC #3476 (Code Orange)
Team Role: Mentor
 
Join Date: Oct 2012
Rookie Year: 2011
Location: Irvine, CA
Posts: 200
saikiranra has a reputation beyond reputesaikiranra has a reputation beyond reputesaikiranra has a reputation beyond reputesaikiranra has a reputation beyond reputesaikiranra has a reputation beyond reputesaikiranra has a reputation beyond reputesaikiranra has a reputation beyond reputesaikiranra has a reputation beyond reputesaikiranra has a reputation beyond reputesaikiranra has a reputation beyond reputesaikiranra has a reputation beyond repute
Re: HTMLish based scouting

The simplest way to do this is to have an HTML based input page that sends the form data to an SQL database. To read the data, you can use PHP and do almost any type of analysis you would like. Very simple and straightforward.

If you don't want to deal with an internet connection, you can run a simple WAMP server (or equivalent) on a laptop and connect all the scouting laptops together using an ethernet switch. It will run exactly like a website server, except on a laptop. We ran a system like this at IRI, Fall Classic, Battle at the Border, and CVR.

There is a learning curve involved, but the FRC community is an amazing resource.
__________________
2014 - Current: Team 3476 Electronics, Programming, and Scouting Mentor
2011 - 2014: Team 696 Student and Drive Coach
  #6   Spotlight this post!  
Unread 13-03-2014, 01:53
terabyte128 terabyte128 is offline
Registered User
AKA: Sam
FRC #4030 (NullPointerException)
Team Role: Webmaster
 
Join Date: Feb 2014
Rookie Year: 2012
Location: United States
Posts: 18
terabyte128 is an unknown quantity at this point
Re: HTMLish based scouting

We are taking a similar approach this year, but opting to store all the information in a MySQL database in the cloud (as well as the entire website). Of course, the downfall of this is that without a cellular connection we're sort of screwed.

Eventually I'd like to integrate Tableau, but we're just working with a simpler graphing plugin right now. I might run it locally off my laptop for the next competition if we can't get a good internet connection. It does make scouting much easier to just eliminate paper entirely. We also have an interactive system for data entry and automatically generated statistics based on teams.

If you're curious you can view the application here (source code)
  #7   Spotlight this post!  
Unread 13-03-2014, 10:46
aryker's Avatar
aryker aryker is offline
Registered User
FRC #0868 (TechHOUNDS)
Team Role: Mentor
 
Join Date: Jan 2013
Rookie Year: 2008
Location: United States
Posts: 79
aryker will become famous soon enougharyker will become famous soon enough
Re: HTMLish based scouting

We're doing something similar for our scouting system this year. We have a Raspberry Pi running a web server that hosts the HTML forms, and when you submit, the data gets stored in a MySQL database on the Pi. We've got web pages for data visualization and match prediction, as well as an Android app that we wrote for our coach's tablet that can grab the latest data from the database and then be used for strategy anywhere after being disconnected. Basically what this means is that any device with a web browser and an ethernet connection can be used to scout. We ordered some Chromebooks for our scouts to use in the stands. We're actually working on a final version to release to teams in the next week, so I'll be posting about that soon.
  #8   Spotlight this post!  
Unread 13-03-2014, 10:58
Andrew Schreiber Andrew Schreiber is offline
Joining the 900 Meme Team
FRC #0079
 
Join Date: Jan 2005
Rookie Year: 2000
Location: Misplaced Michigander
Posts: 4,074
Andrew Schreiber has a reputation beyond reputeAndrew Schreiber has a reputation beyond reputeAndrew Schreiber has a reputation beyond reputeAndrew Schreiber has a reputation beyond reputeAndrew Schreiber has a reputation beyond reputeAndrew Schreiber has a reputation beyond reputeAndrew Schreiber has a reputation beyond reputeAndrew Schreiber has a reputation beyond reputeAndrew Schreiber has a reputation beyond reputeAndrew Schreiber has a reputation beyond reputeAndrew Schreiber has a reputation beyond repute
Re: HTMLish based scouting

I tossed together a quick AngularJS app for talking to Parse.com to store my data (debated hitting Google Docs but Parse was just easy). Maybe I'll clean it up and open source it this weekend.
__________________




.
  #9   Spotlight this post!  
Unread 13-03-2014, 11:11
bbradf44's Avatar
bbradf44 bbradf44 is offline
Registered User
AKA: Brad
FRC #3344 (Robocopz)
Team Role: Driver
 
Join Date: May 2013
Rookie Year: 2011
Location: Peachtree City
Posts: 111
bbradf44 is just really nicebbradf44 is just really nicebbradf44 is just really nicebbradf44 is just really nice
Re: HTMLish based scouting

Thanks for all the reply's. For now it looks like im going to test out the google form method and see if i get the desired effects in tableau that i can get with access. We will be trying the MySQL method but probably wont have it completed before Peachtree. Im almost positive we will have a good cellular connection in the middle of Atlanta but you never know, so we will keep the access method i had come up with before as a backup
  #10   Spotlight this post!  
Unread 13-03-2014, 11:12
jlmcmchl jlmcmchl is offline
FF - The Breakfast Company
AKA: Jordan McMichael
FRC #0027 (Team RUSH 27)
Team Role: Alumni
 
Join Date: Feb 2012
Rookie Year: 2011
Location: Clarkston,MI
Posts: 327
jlmcmchl has much to be proud ofjlmcmchl has much to be proud ofjlmcmchl has much to be proud ofjlmcmchl has much to be proud ofjlmcmchl has much to be proud ofjlmcmchl has much to be proud ofjlmcmchl has much to be proud ofjlmcmchl has much to be proud of
Re: HTMLish based scouting

Quote:
Originally Posted by bbradf44 View Post
So im not even sure if this is possible, but ill give it a shot and see what people think. This year we are running scouting in the stands through either MS Excel or Access so that it can be run through Tableau. Our current setup requires all 6 scouts to have forms to fill out while the 7th inputs them into the database, then an 8th person runs a USB flash drive back and forth to the pits whenever we want to update where we have the Tableau program running. I got the idea while in my web design class today, would it be possible to have an HTML form running on cell phones or other 3g/4g enabled device that when the submit button is pressed, it sends the data to the database that will be either on our team website or in the cloud, which i can then open on my laptop in our pit(usb tethered to my phone)? The html file itself wont be online(but maybe i could put that on our website too) but rather stored on each of the phones. Ideas/criticisms welcome
One issue here is I've never been to an event with a solid data connection. Your system is entirely dependent on that, and will cause headaches and frustration at game time.

Simpler, less dependent solutions I've seen were applications that store the data locally and then push the data to a local server by the push of a button. You're on a good path with using HTML and <form> tags, though. This would also eliminate the 8th person; the 7th person's job is handled by computers, making more people available for other important jobs at competition. Additionally, you can setup Tableau on the local server, and print out data for your upcoming matches to run down to the pits, eliminating extra time needed to process the data in the pits, while still making the data available for developing strategy.
__________________


Field reset: Kettering Kickoff ('13, '14), Kettering ('14, '15), Bedford ('14), Woodhaven ('16), Carver ('16), Einstein! ('16)
Referee: Bedford ('15), MARC ('15, '16), Kettering Kickoff ('15, '16), Kettering District (#1&2: '16), Troy ('16)
  #11   Spotlight this post!  
Unread 14-03-2014, 16:06
xSAWxBLADEx's Avatar
xSAWxBLADEx xSAWxBLADEx is offline
DaBears til 13 turned Free Agent 14
AKA: Michael Hawley
no team (Free Agent)
Team Role: Scout
 
Join Date: Jan 2009
Rookie Year: 2006
Location: Berkley, MI
Posts: 359
xSAWxBLADEx will become famous soon enoughxSAWxBLADEx will become famous soon enough
Send a message via MSN to xSAWxBLADEx
Re: HTMLish based scouting

My old team tried everything, Sql servers, excel spreadsheets, etc. and at the end of the year we always resorted back to paper and pens. Yes, we had the OPR data and raw match data ran through a excel database much like Ed's, but real match scouting was paper and pens. Sorry tree huggers, I have to admit I love killing the trees if it meant getting clean scouting forms.
__________________
2006-Palmetto Regional Champions with 11 and 1251 (MORT, TIGERS, BEARS, O MY!)
2007-Pittsburgh Regional Champions with 123 and 337 / Detroit Regional Champions with 123 and 903
2009-Traverse City District Competition Champions with 85 and 2645 / Traverse City District Competition Chairman's Award / Michigan State Championship Finalists with 1918 and 904 / Championship Finalist with 217 and 68
2013-Grand Blanc District Competition Champions with 33 and 1718

  #12   Spotlight this post!  
Unread 14-03-2014, 17:16
jlmcmchl jlmcmchl is offline
FF - The Breakfast Company
AKA: Jordan McMichael
FRC #0027 (Team RUSH 27)
Team Role: Alumni
 
Join Date: Feb 2012
Rookie Year: 2011
Location: Clarkston,MI
Posts: 327
jlmcmchl has much to be proud ofjlmcmchl has much to be proud ofjlmcmchl has much to be proud ofjlmcmchl has much to be proud ofjlmcmchl has much to be proud ofjlmcmchl has much to be proud ofjlmcmchl has much to be proud ofjlmcmchl has much to be proud of
Re: HTMLish based scouting

Quote:
Originally Posted by xSAWxBLADEx View Post
My old team tried everything, Sql servers, excel spreadsheets, etc. and at the end of the year we always resorted back to paper and pens. Yes, we had the OPR data and raw match data ran through a excel database much like Ed's, but real match scouting was paper and pens. Sorry tree huggers, I have to admit I love killing the trees if it meant getting clean scouting forms.
Wait... what does this have to do with the thread?
__________________


Field reset: Kettering Kickoff ('13, '14), Kettering ('14, '15), Bedford ('14), Woodhaven ('16), Carver ('16), Einstein! ('16)
Referee: Bedford ('15), MARC ('15, '16), Kettering Kickoff ('15, '16), Kettering District (#1&2: '16), Troy ('16)
  #13   Spotlight this post!  
Unread 14-03-2014, 22:26
xSAWxBLADEx's Avatar
xSAWxBLADEx xSAWxBLADEx is offline
DaBears til 13 turned Free Agent 14
AKA: Michael Hawley
no team (Free Agent)
Team Role: Scout
 
Join Date: Jan 2009
Rookie Year: 2006
Location: Berkley, MI
Posts: 359
xSAWxBLADEx will become famous soon enoughxSAWxBLADEx will become famous soon enough
Send a message via MSN to xSAWxBLADEx
Re: HTMLish based scouting

Quote:
Originally Posted by jlmcmchl View Post
Wait... what does this have to do with the thread?
I am just saying we tried using computer to aid with scouting, and it didn't work for us. I am just letting other teams know that if html scouting doesn't work, paper is a wonderful alternative.
__________________
2006-Palmetto Regional Champions with 11 and 1251 (MORT, TIGERS, BEARS, O MY!)
2007-Pittsburgh Regional Champions with 123 and 337 / Detroit Regional Champions with 123 and 903
2009-Traverse City District Competition Champions with 85 and 2645 / Traverse City District Competition Chairman's Award / Michigan State Championship Finalists with 1918 and 904 / Championship Finalist with 217 and 68
2013-Grand Blanc District Competition Champions with 33 and 1718

  #14   Spotlight this post!  
Unread 15-03-2014, 00:46
Merfoo's Avatar
Merfoo Merfoo is offline
Registered User
FRC #0955 (CV Robotics)
Team Role: Programmer
 
Join Date: Feb 2012
Rookie Year: 2012
Location: America
Posts: 48
Merfoo is an unknown quantity at this point
Re: HTMLish based scouting

Our team developed a html/js scouting application that wrote .csv files for each match and could also collect every match.csv file to compile a "master" file which has data about each robot based on the match data. Worked pretty well at our last district.
https://github.com/FRC-Team-955/AerialAssistScouting
  #15   Spotlight this post!  
Unread 15-03-2014, 10:39
wesleyac's Avatar
wesleyac wesleyac is offline
Registered User
AKA: Wesley Aptekar-Cassels
FRC #1678 (Citrus Circuits)
Team Role: Programmer
 
Join Date: Jan 2014
Rookie Year: 2013
Location: Davis, CA
Posts: 56
wesleyac is a splendid one to beholdwesleyac is a splendid one to beholdwesleyac is a splendid one to beholdwesleyac is a splendid one to beholdwesleyac is a splendid one to beholdwesleyac is a splendid one to beholdwesleyac is a splendid one to beholdwesleyac is a splendid one to behold
Re: HTMLish based scouting

Quote:
Originally Posted by jlmcmchl View Post
You're on a good path with using HTML and <form> tags, though. This would also eliminate the 8th person; the 7th person's job is handled by computers, making more people available for other important jobs at competition.
You can also eliminate the person who runs down to the pits by storing it on a server. Although that depends on data as well. As for data issues,storing to disk can help. That way, if it's a temporary issue, you can upload it later, or if it's a major issue, print it or run a laptop/tablet to the pits.

Our team does something similar to this. We haven't had issues with cell data yet.
__________________
Quote:
Originally Posted by The programming team
Define "works."
Closed Thread


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 Off
HTML code is Off
Forum Jump


All times are GMT -5. The time now is 18:34.

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


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright © Chief Delphi