Go to Post Anything that moves sideways is a waste of time. - Tom Bottiglieri [more]
Home
Go Back   Chief Delphi > FIRST > General Forum
CD-Media   CD-Spy  
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 21-03-2016, 12:52
Roboshant's Avatar
Roboshant Roboshant is offline
Design Lead 17, Scouting Captain 16
AKA: Dikshant Sharma
FRC #0226
Team Role: Leadership
 
Join Date: Jun 2015
Rookie Year: 2015
Location: Troy, MI
Posts: 151
Roboshant is a name known to allRoboshant is a name known to allRoboshant is a name known to allRoboshant is a name known to allRoboshant is a name known to allRoboshant is a name known to all
Google Sheets Offline Phone Scouting

This is a simple scouting form I created that can be used on Android, iOS, Web, or pretty much anything that can access an excel editor. Specifically, Google sheets is used.
Method:
-Scouters copy the Google sheets onto their phones, and share the file with the head scouter: scouting form
-Scouters enter match data into the form
-During a set interval of matches data is sent over to the Head Scouter.
-This can be sent by micro USB (Android only), Bluetooth, going to an internet access area outside of the match area, turning on data to save online, and many other ways.
-Head scouter copies the data in the 'Data Aggregation ' sheet of the scouting form into the 'Data Aggregation' in the data entry form.
-as data is pasted into the data entry tab, it automatically goes into the pivot table.
-Specific match data can be seen through the 'Compiling' sheet in the data entry form.

*Note this is set up for the FIM Troy competition. If one wants to change this to a specific event, simply change the formulas in the compiling tab to=Filter('Data Aggregation'!D$2:AH$3040,'Data Aggregation'!C$2:C$3040=the team number that you want). Also do not forget to change the numbers of the teams in the pivot table and teams section.

All comments and suggestions are greatly appreciated. Please feel free to contact me if you have any questions.
__________________




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 22:49.

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