pre scouting

[logank013]

What I do for pre scouting is make my own scouting sheet using ed law's scouting data base (reply if you need a link). I copy his big world rank tab to an excel file. Then, you could either use copy and paste or use the "vlookup" function to sort and find the data for that team. His sheet for this year broke opr into 5 components. Tote, Can, Litter, Coop, and Foul. Then, you can use the rank function to make a ranking system. This can tell you what the strengths of robots are. For example, our team was really fast with totes but were usually bad with the cans. That was reflected in our opr data.

Just remember that opr can be messed up based off of how teams schedule's were. The better the schedule a team gets, the better their stats look. This typically is only truly effective for the top 10 teams of an event but it helps. I made a pre scouting sheet for the Archimedes Division using that system I explained above. If you want, I can post that sheet on here. I also did a (Different type of style but possibly better) pre scouting sheet for IRI which was a lot of fun.

[evanperryg]

Originally Posted by logank013

What I do for pre scouting is make my own scouting sheet using ed law's scouting data base (reply if you need a link). I copy his big world rank tab to an excel file. Then, you could either use copy and paste or use the "vlookup" function to sort and find the data for that team. His sheet for this year broke opr into 5 components. Tote, Can, Litter, Coop, and Foul. Then, you can use the rank function to make a ranking system. This can tell you what the strengths of robots are. For example, our team was really fast with totes but were usually bad with the cans. That was reflected in our opr data.

Almost exactly what we do. It's easy and one sheet can be used for many events.