Pre-Scouting of all Divisions

[jblay]

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 (https://docs.google.com/spreadsheet/ccc?key=0AuF1A5cZW-3sdEJIMHVnRnVNY2daa3p4dzRaaXg2dGc#gid=5)
Galileo Division (https://docs.google.com/spreadsheet/ccc?key=0AuF1A5cZW-3sdE1JclphNU9rRWJYV2xfMVVrWVY1b1E#gid=5)
Archimedes Division (https://docs.google.com/spreadsheet/ccc?key=0AuF1A5cZW-3sdG5wcmFtRXZ6d1JuRmJZcWJJcEN4N1E#gid=5)
Newton Division (https://docs.google.com/spreadsheet/ccc?key=0AuF1A5cZW-3sdFZ1QVcweVotN3pBZW1yUGZJRVBqRnc#gid=5)

[Akash Rastogi]

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


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

[jblay]

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


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

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.

[Hallry]

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.

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

[jwfoss]

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.

[Banderoonies]

This is great! where did the data come from?

[LeelandS]

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?

[lemiant]

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.

[Kim Masi]

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!

[smistthegreat]

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.

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.

[SteveGPage]

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!

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.

[jblay]

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.
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?

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.

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.

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.

[PAR_WIG1350]

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

Galileo (https://docs.google.com/spreadsheet/ccc?key=0AhJK9G0wk-vcdGp6aUlzM1ZZRjNMZEF6eU16RENVV2c#gid=5)
Curie (https://docs.google.com/spreadsheet/ccc?key=0AhJK9G0wk-vcdF82Ti13T2FSMDB5dkIzUFZWenFEM3c#gid=5)
Newton (https://docs.google.com/spreadsheet/ccc?key=0AhJK9G0wk-vcdG5kLXQ1UU5lVkJYeUx5dXI3ZlVtYWc#gid=5)
Archimedes (https://docs.google.com/spreadsheet/ccc?key=0AhJK9G0wk-vcdGJ0a3V3RWdod1pUeGdnQ2c5UGNtWHc#gid=5)

[jblay]

Seeing as all divisions are now team # sorted, and they change between rank and # sorted fairly frequently, I have created copies of the sheets that are rank sorted and have removed most of the data so you won't have to update both sheets unless you are changing the ranks or photo links. I have also added a comment section to the table in this version for those who desire this feature.

Galileo (https://docs.google.com/spreadsheet/ccc?key=0AhJK9G0wk-vcdGp6aUlzM1ZZRjNMZEF6eU16RENVV2c#gid=5)
Curie (https://docs.google.com/spreadsheet/ccc?key=0AhJK9G0wk-vcdF82Ti13T2FSMDB5dkIzUFZWenFEM3c#gid=5)
Newton (https://docs.google.com/spreadsheet/ccc?key=0AhJK9G0wk-vcdG5kLXQ1UU5lVkJYeUx5dXI3ZlVtYWc#gid=5)
Archimedes (https://docs.google.com/spreadsheet/ccc?key=0AhJK9G0wk-vcdGJ0a3V3RWdod1pUeGdnQ2c5UGNtWHc#gid=5)

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

[tyron256]

Seeing as all divisions are now team # sorted, and they change between rank and # sorted fairly frequently, I have created copies of the sheets that are rank sorted and have removed most of the data so you won't have to update both sheets unless you are changing the ranks or photo links. I have also added a comment section to the table in this version for those who desire this feature.

Galileo (https://docs.google.com/spreadsheet/ccc?key=0AhJK9G0wk-vcdGp6aUlzM1ZZRjNMZEF6eU16RENVV2c#gid=5)
Curie (https://docs.google.com/spreadsheet/ccc?key=0AhJK9G0wk-vcdF82Ti13T2FSMDB5dkIzUFZWenFEM3c#gid=5)
Newton (https://docs.google.com/spreadsheet/ccc?key=0AhJK9G0wk-vcdG5kLXQ1UU5lVkJYeUx5dXI3ZlVtYWc#gid=5)
Archimedes (https://docs.google.com/spreadsheet/ccc?key=0AhJK9G0wk-vcdGJ0a3V3RWdod1pUeGdnQ2c5UGNtWHc#gid=5)

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

[jblay]

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

[PAR_WIG1350]

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

My apologies, they have all been fixed.

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

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.

[Banderoonies]

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

[jblay]

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

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

[bam-bam]

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

[slijin]

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?

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 ###).

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?

Added, along with CCWM. All data displayed is courtesy of team 2834 (http://www.chiefdelphi.com/media/papers/download/3398).

[Grim Tuesday]

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.

[EdwardP]

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.

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.

[jblay]

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.

[Grim Tuesday]

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

[jdunston94]

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!

[Kellen Hill]

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!

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.

[Grim Tuesday]

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

[slijin]

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

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.

[lemiant]

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.

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

[slijin]

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

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

[snowmobiler9]

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

[slijin]

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

Which database are you using to check OPRs?

[snowmobiler9]

Which database are you using to check OPRs?

https://docs.google.com/spreadsheet/ccc?key=0AuF1A5cZW-3sdEJIMHVnRnVNY2daa3p4dzRaaXg2dGc#gid=5

The OPR's were corrected since the original post.

[slijin]

https://docs.google.com/spreadsheet/ccc?key=0AuF1A5cZW-3sdEJIMHVnRnVNY2daa3p4dzRaaXg2dGc#gid=5

The OPR's were corrected since the original post.

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:

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!

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.

[CalTran]

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

[ElJeffe3255]

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

[FRCmentor4-3528]

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