Pre-Scouting of all Divisions
 

I created a google doc earlier today for the curie division to get data on the teams in the division along with photos of each robot.

I have now created one for each division, I have filled out some of the information on some of the teams that I know off hand to give an idea of how this works. I have also filled in all of the OPR and triple balance information. Feel free to fill in any missing information and fix any incorrect data.

Curie Division
Galileo Division
Archimedes Division
Newton Division

Re: Pre-Scouting of all Divisions
 

You must spread some Reputation around before giving it to jblay again.


Thanks for organizing this, Joe! See you next week bud.

Re: Pre-Scouting of all Divisions
 

I hope these help teams specifically with knowledge on robot dimensions, Thursday is going to be a rough day and hopefully this helps make it easier for some people.

I'm pretty excited to be on Curie with you Stogi, hopefully we get a match with your team at some point.

Re: Pre-Scouting of all Divisions
 

Awesome. Awesome Awesome Awesome. Thanks so much for this, you're the best :).

Re: Pre-Scouting of all Divisions
 

Hey Joe, I know this may be a lot of work but, any chance you can throw into the spreadsheets the team names and average OPR?

It may be helpful as I know that I often can't remember a team number but the name jumps out to me.

Re: Pre-Scouting of all Divisions
 

This is great! where did the data come from?

Re: Pre-Scouting of all Divisions
 

By bridge balance assister, the primary device for this is a stinger. 1501's platform is also included. Just as a general question, should anything that aids balancing be counted? My specific notions are to drive brakes and a swerve drive being able to shift their wheels perpendicular to the bridge to avoid sliding.

Thoughts?

One other thing that might be worth noting is that some robots (see 4334 and 4001) are significantly shorter than a wide robot at ~21". Perhaps they could be labelled under-size bot.

Re: Pre-Scouting of all Divisions
 

Thanks for posting this, I know what I'll be doing later this afternoon.

I tried editing it yesterday, but it didn't seem for it to work. Don't you have to share the document with specific people to allow them to edit it? Or is it public?

Thanks again!

Re: Pre-Scouting of all Divisions
 

Also, some long bots (like us) aren't the full 38 inches. Perhaps add a collumn for actual dimensions? Either way, thank you for this.

Re: Pre-Scouting of all Divisions
 

You just have to make sure you sign into Google Docs with a Google/Gmail account. The sign-in link is usually in the upper right of the shared google doc.

Re: Pre-Scouting of all Divisions
 

If you have something like that you should just put a note on there to explain it. If you are a different dimension I would attach the note to the dimension part of the sheet. If you have some sort of weird assister like brakes you should put that you have an assiter with a note as to what makes it different.

I am fine with including these things if it is wanted but I would like it if the people that want the data can throw it in. This is supposed to be a collaboration so I leave to the CD world to add what they think is needed. I worry a bit that team names will make the spreadsheet cluttered however.

For OPR rank I used the adjusted rank on the 2834 scouting database. I'm not sure if this is the most popular one to use but it's just the one that I like for this year.

Re: Pre-Scouting of all Divisions
 

Any additional notes teams wish to add can be put here:

Galileo
Curie
Newton
Archimedes

Re: Pre-Scouting of all Divisions
 

These features already exist in each spreadsheet by clicking the alternate document on the bottom right of the screen.

Re: Pre-Scouting of all Divisions
 

just FYI it says you need permission to access. request sent by me

Re: Pre-Scouting of all Divisions
 

Thank you to whoever put in the search function in the Newton sheet. I have added it to the others.

Re: Pre-Scouting of all Divisions
 

My apologies, they have all been fixed.

I have changed it so that it is now just a note sheet, still sorted by rank. The info displayed has not been changed, just the title. By putting notes here the originals can remain organized and notes are there for scouts to look at.

EDIT: fixed my previous post to reflect the changes.

EDIT: Archimedes also has a team # sorted version, but I could not figure out how to link the two sheets at this late (Early?) hour. If someone could do that to this document as well as the others it would be greatly appreciated.

Re: Pre-Scouting of all Divisions
 

Hi! Stuypulse! might want to add to your DB. 195 HAS a bridge balancing device (stinger) :)
Thanks for the great Data!

Re: Pre-Scouting of all Divisions
 

It's up to you to update data that you see is off. This is a collaboration.

Re: Pre-Scouting of all Divisions
 

I would like to say thanks for this... it's very useful.

And whoever, put cursed in the title of the Curie division spreadsheet.... well-played.:p

Re: Pre-Scouting of all Divisions
 

The spreadsheet is public; it only needs to be shared with specific collaborators if you want people's emails to appear as their names (instead of Anonymous User ###).

Added, along with CCWM. All data displayed is courtesy of team 2834.

Re: Pre-Scouting of all Divisions
 

The OPR used; how is it calculated? By this I mean, how does the Co-Op bridge play into it? Is it the teams best event or an average? I would suggest using 1114's with the teams best event but I suppose it's up to you guys. I just think that best/latest event is the best measure of how good a team will be at Championships.

Re: Pre-Scouting of all Divisions
 

The OPR that is used in these spreadsheets is from 2834's spreadsheet. It assigns each alliance 5 points per CP earned in the match. This gives each alliance 10 points if a full coop is preformed (5 for a non-balanced coop) which is like half of a double balance that the teams could each be attempting if they didn't go for a coop.

I agree that most recent data is most relevant, but for an impartial objective spreadsheet that is shared by multiple teams, it is probably better to go by overall data, rather than deciding to ignore some data, and presenting it to other teams.

Re: Pre-Scouting of all Divisions
 

I can't believe how quickly these forms are being filled out. Curie already has all 100 teams orientation's filled out which was the original and main purpose of these sheets.

Re: Pre-Scouting of all Divisions
 

Crowd sourcing is awesome. What would you say to a column with "2012 record", "highest finish" and "highest draft position"?

Re: Pre-Scouting of all Divisions
 

As teams start to do this, don't forget to post pics to Thefirstalliance.org, it is a new and growing resource put together by a couple of Comets(3357) alumni to centralize the vast reserves of FRC Data!

Re: Pre-Scouting of all Divisions
 

Are these scouting materials something that could be attached to event pages on Thefirstalliance.org? They would be neat resources to see in looking back on events.

For example, include the Curie scouting page on the Curie division page on Thefirstalliance.org.

Re: Pre-Scouting of all Divisions
 

Or have The First Alliance serve the data that the spreadsheet is giving (teams in a division sorted by OPR, CCWM, orientation data etc...)

Re: Pre-Scouting of all Divisions
 

IMHO, it's more of a "novelty" - something that would be nice to know, but wouldn't be particularly critical to scouting (and would in turn clutter the spreadsheet), because such records are highly dependent on the environment and because most, if not all teams, will be making additions and/or changes to their robot that will change their comparative performance.

If someone were to do it, though, I don't think it would be particularly hard. I believe that Ed Law's database already contains data like that sorted by team (although it may not be cumulative, but rather per regional/district).

If you want to do it yourself, the gist of the process I used was to first sort the data into columns of text values (I had to create columns of the original values, and then input =TEXT(<cellref>,0) to do this), and then use VLOOKUP with a list of teams in said division to look up the corresponding stats.

There is one thing I'd like to make a note of though. While I understand that everyone wants to contribute as much as they can to these spreadsheets - which is exactly what we want, after all - I've had to revert a number of changes (to the formulas that summarize/filter the data) recently, because the editor didn't properly assess the changes they made. Because of this, I'm requesting that people please refrain from editing the formulas in the current spreadsheets until they have tested the formula in a duplicate worksheet to ensure that it properly works.

That being said, I really am amazed by how fast this has gone - once we figured out a way to display which teams didn't have data entered, the data for those teams was filled in within less than a day!

As an aside about TFA, I'd just like to say that although it was a bit tricky to work with, it really helped me with adding OPR and CCWM to the spreadsheet.

Re: Pre-Scouting of all Divisions
 

Where exactly do notes go? I have changed our teams entry to say "1 (21" long)" in the Wide robot field, but it appears to not be counting it in the number of wide teams now.

- Alex

Re: Pre-Scouting of all Divisions
 

Right-click the cell you want to add a note for and click insert comment.

Re: Pre-Scouting of all Divisions
 

I believe Curie's OPR's do not match the correct team.

Re: Pre-Scouting of all Divisions
 

Which database are you using to check OPRs?

Re: Pre-Scouting of all Divisions
 

https://docs.google.com/spreadsheet/...aaXg2dGc#gid=5

The OPR's were corrected since the original post.

Re: Pre-Scouting of all Divisions
 

Good to know. I had to revert to my last edit (since other data points had been shuffled as well), which is probably what fixed things.

On another note, I need to reiterate this:

The same goes for reordering the spreadsheet.

Please remember that this is a public document, and any changes you make will change the document that other people are working with.

Re: Pre-Scouting of all Divisions
 

Team 2410, of Archimedes, is filled out. Added one note to the notes doc, which seems to have been a graveyard as far as activity goes o.0

Team 3255 in the Newton division has been updated with our info. Thanks for providing this valuable info!

Re: Pre-Scouting of all Divisions
 

Thank you for doing this pre-scouting work for all teams competing. It makes our scouting experience more complete, and a bit easier!