Go to Post Gracious professionalism is a two-way street. - Bharat Nain [more]
Home
Go Back   Chief Delphi > ChiefDelphi.com Website > Extra Discussion
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 04-14-2017, 03:29 PM
Rachel Lim Rachel Lim is online now
Registered User
no team
 
Join Date: Sep 2014
Rookie Year: 2014
Location: Berkeley, CA
Posts: 309
Rachel Lim has a reputation beyond reputeRachel Lim has a reputation beyond reputeRachel Lim has a reputation beyond reputeRachel Lim has a reputation beyond reputeRachel Lim has a reputation beyond reputeRachel Lim has a reputation beyond reputeRachel Lim has a reputation beyond reputeRachel Lim has a reputation beyond reputeRachel Lim has a reputation beyond reputeRachel Lim has a reputation beyond reputeRachel Lim has a reputation beyond repute
paper: 2017 Component OPR Spreadsheet

Thread created automatically to discuss a document in CD-Media.

2017 Component OPR Spreadsheet by Rachel Lim
Reply With Quote
  #2   Spotlight this post!  
Unread 04-14-2017, 03:40 PM
Rachel Lim Rachel Lim is online now
Registered User
no team
 
Join Date: Sep 2014
Rookie Year: 2014
Location: Berkeley, CA
Posts: 309
Rachel Lim has a reputation beyond reputeRachel Lim has a reputation beyond reputeRachel Lim has a reputation beyond reputeRachel Lim has a reputation beyond reputeRachel Lim has a reputation beyond reputeRachel Lim has a reputation beyond reputeRachel Lim has a reputation beyond reputeRachel Lim has a reputation beyond reputeRachel Lim has a reputation beyond reputeRachel Lim has a reputation beyond reputeRachel Lim has a reputation beyond repute
Re: paper: 2017 Component OPR Spreadsheet

Component OPR data is also linked below in csv format. I'll add week 7 calculations into the folder and spreadsheet after this weekend.

Folder with all data: link

By event: link
By team: link
By team (max OPR only): link

By division:
Carver: link
Galileo: link
Hopper: link
Newton: link
Roebling: link
Turing: link
Reply With Quote
  #3   Spotlight this post!  
Unread 04-15-2017, 06:26 PM
Citrus Dad's Avatar
Citrus Dad Citrus Dad is offline
Business and Scouting Mentor
AKA: Richard McCann
FRC #1678 (Citrus Circuits)
Team Role: Mentor
 
Join Date: May 2012
Rookie Year: 2012
Location: Davis
Posts: 1,278
Citrus Dad has a reputation beyond reputeCitrus Dad has a reputation beyond reputeCitrus Dad has a reputation beyond reputeCitrus Dad has a reputation beyond reputeCitrus Dad has a reputation beyond reputeCitrus Dad has a reputation beyond reputeCitrus Dad has a reputation beyond reputeCitrus Dad has a reputation beyond reputeCitrus Dad has a reputation beyond reputeCitrus Dad has a reputation beyond reputeCitrus Dad has a reputation beyond repute
Re: paper: 2017 Component OPR Spreadsheet

Nice job. However, looks like they've switched a few teams.
__________________
Reply With Quote
  #4   Spotlight this post!  
Unread 04-18-2017, 02:04 PM
Rachel Lim Rachel Lim is online now
Registered User
no team
 
Join Date: Sep 2014
Rookie Year: 2014
Location: Berkeley, CA
Posts: 309
Rachel Lim has a reputation beyond reputeRachel Lim has a reputation beyond reputeRachel Lim has a reputation beyond reputeRachel Lim has a reputation beyond reputeRachel Lim has a reputation beyond reputeRachel Lim has a reputation beyond reputeRachel Lim has a reputation beyond reputeRachel Lim has a reputation beyond reputeRachel Lim has a reputation beyond reputeRachel Lim has a reputation beyond reputeRachel Lim has a reputation beyond repute
Re: paper: 2017 Component OPR Spreadsheet

Quote:
Originally Posted by Citrus Dad View Post
Nice job. However, looks like they've switched a few teams.
Finally had some time to fix this, and replaced the old excel sheet with a new one that should hopefully have the correct data. If there are still errors or discrepancies please let me know.

I also added in week 7 component OPR data. I'll try update the google sheets, libreoffice calc, and csv files with the new/corrected data soon -- if anyone is using those and wants the new data let me know and I'll prioritize it.

Final change: using the preliminary match schedules, I added a lookup by match number, so you can compare both alliances in two graphs. Comparing the three ways to search the data:

Lookup by team (enter team number):



Lookup by alliance (enter three team numbers):

(palindrome alliance!)


Lookup by match (enter division name and match number)

Last edited by Rachel Lim : 04-19-2017 at 12:18 AM.
Reply With Quote
  #5   Spotlight this post!  
Unread 04-19-2017, 09:18 AM
Chris86 Chris86 is offline
Registered User
FRC #1481 (Riveters)
Team Role: Mentor
 
Join Date: Mar 2010
Rookie Year: 2007
Location: Farmington Hills, MI
Posts: 52
Chris86 is a splendid one to beholdChris86 is a splendid one to beholdChris86 is a splendid one to beholdChris86 is a splendid one to beholdChris86 is a splendid one to beholdChris86 is a splendid one to beholdChris86 is a splendid one to behold
Re: paper: 2017 Component OPR Spreadsheet

Its likely just a type in the spreadsheet, but on the notes tab, 120 points in auto and 40 points in teleop is listed as having a value of 3 auto gears and 5 teleop gears. It should be 3 auto gears and 3 teleop gears.

Thank you for putting all this together, its been an interesting resource to look through and compare teams with.
__________________
Mentor Team #1481 2018-
Coach Team #1700 2016-
Lead Mentor Team #4064 2011-2015
Team #86 2007-2011
Reply With Quote
  #6   Spotlight this post!  
Unread 04-19-2017, 11:39 AM
JesseK's Avatar
JesseK JesseK is offline
Expert Flybot Crasher
FRC #1885 (ILITE)
Team Role: Mentor
 
Join Date: Mar 2007
Rookie Year: 2005
Location: Reston, VA
Posts: 4,220
JesseK has a reputation beyond reputeJesseK has a reputation beyond reputeJesseK has a reputation beyond reputeJesseK has a reputation beyond reputeJesseK has a reputation beyond reputeJesseK has a reputation beyond reputeJesseK has a reputation beyond reputeJesseK has a reputation beyond reputeJesseK has a reputation beyond reputeJesseK has a reputation beyond reputeJesseK has a reputation beyond repute
Re: paper: 2017 Component OPR Spreadsheet

Just a quick note as a warning to using component OPR data to make decisions - OPR, and in particular component OPR for non-linear tasks, can vary wildly from the truth. This causes any data derived from those values to also vary wildly.

Here is a sample for my team. It suggests that at vagle we had a less than one half of one teleop gear per match average. For teleop this is unbelievably far off from what actually happened (and is far off from the component OPR sum...). It also suggests that our climbs at CHS Champs only hit 80% of the time, yet we had a 100% rate across all matches that event. On top of that the component OPR data for our autonomous shows us hitting the autonomous rotor every time at chscmp - but I know for a fact we couldn't seem to hit an auton gear while on the Blue Alliance.

Again, this isn't an issue with this particular calculator or divisions.co (my calculators/sims have similar-but-different issues). Rather, it's an issue with relying on statistics generated from non-contextual numbers. Keep that in mind as we work with partners and attempt to estimate opponents these next two weeks.
__________________
Drive Coach, 1885 (2007-present)

1885: YouTube | CAD Library
Reply With Quote
  #7   Spotlight this post!  
Unread 04-25-2017, 09:22 AM
mtgrogan mtgrogan is offline
Registered User
FRC #0033
 
Join Date: Apr 2017
Location: Rochester Hills, MI
Posts: 1
mtgrogan is an unknown quantity at this point
Re: paper: 2017 Component OPR Spreadsheet

Thanks Rachel for this and the Component OPR Google sheet calculator. We found them a great addition to our scouting tools this year. Plus they made me explore some new areas of Excel and Sheets - always a good thing!

Question on the week 7 data you added - It looks like the gear counts show zero for all week 7 events. Is there a reason you didn't calculate this field?
Reply With Quote
  #8   Spotlight this post!  
Unread 05-03-2017, 01:35 AM
Rachel Lim Rachel Lim is online now
Registered User
no team
 
Join Date: Sep 2014
Rookie Year: 2014
Location: Berkeley, CA
Posts: 309
Rachel Lim has a reputation beyond reputeRachel Lim has a reputation beyond reputeRachel Lim has a reputation beyond reputeRachel Lim has a reputation beyond reputeRachel Lim has a reputation beyond reputeRachel Lim has a reputation beyond reputeRachel Lim has a reputation beyond reputeRachel Lim has a reputation beyond reputeRachel Lim has a reputation beyond reputeRachel Lim has a reputation beyond reputeRachel Lim has a reputation beyond repute
Re: paper: 2017 Component OPR Spreadsheet

Sorry I never responded to these--I was catching up on homework after Houston and missed these posts entirely. I realize it's probably too late for this to be useful now, but for the sake of having accurate information online / in case someone does use this later, I've replaced the spreadsheet posted online. Also, thanks to Basel for noticing that I somehow replaced team 3319 with 3332, who no longer exists (I have no idea how that happened, and sorry to 3319 about this). Both that and the other stuff noted below has been fixed.

Since I now have the system set up, I'll try to start the spreadsheet earlier next year. And I'll hopefully manage to get it set up for both (half)champs.

Quote:
Originally Posted by Chris86 View Post
Its likely just a type in the spreadsheet, but on the notes tab, 120 points in auto and 40 points in teleop is listed as having a value of 3 auto gears and 5 teleop gears. It should be 3 auto gears and 3 teleop gears.

Thank you for putting all this together, its been an interesting resource to look through and compare teams with.
Quote:
Originally Posted by JesseK View Post
Just a quick note as a warning to using component OPR data to make decisions - OPR, and in particular component OPR for non-linear tasks, can vary wildly from the truth. This causes any data derived from those values to also vary wildly.

Here is a sample for my team. It suggests that at vagle we had a less than one half of one teleop gear per match average. For teleop this is unbelievably far off from what actually happened (and is far off from the component OPR sum...). It also suggests that our climbs at CHS Champs only hit 80% of the time, yet we had a 100% rate across all matches that event. On top of that the component OPR data for our autonomous shows us hitting the autonomous rotor every time at chscmp - but I know for a fact we couldn't seem to hit an auton gear while on the Blue Alliance.

Again, this isn't an issue with this particular calculator or divisions.co (my calculators/sims have similar-but-different issues). Rather, it's an issue with relying on statistics generated from non-contextual numbers. Keep that in mind as we work with partners and attempt to estimate opponents these next two weeks.
That was a typo, although there was another issue with gear counts that I think might have caused part of the underestimation of gear abilities. I apologize for this and hope it didn't mislead too many teams. However I completely agree OPR does not replace scouting (even correctly calculated OPR). All calculations based on match data have their limitations.


Quote:
Originally Posted by mtgrogan View Post
Thanks Rachel for this and the Component OPR Google sheet calculator. We found them a great addition to our scouting tools this year. Plus they made me explore some new areas of Excel and Sheets - always a good thing!

Question on the week 7 data you added - It looks like the gear counts show zero for all week 7 events. Is there a reason you didn't calculate this field?
I'm still not sure what happened there. It should have been there and does now...
Reply With Quote
  #9   Spotlight this post!  
Unread 02-19-2018, 08:15 PM
Jacob Plicque Jacob Plicque is offline
Registered User
FRC #0086 (Team Resistance)
Team Role: Mentor
 
Join Date: Apr 2006
Rookie Year: 2001
Location: Jacksonville, Fl
Posts: 61
Jacob Plicque is an unknown quantity at this point
Smile Re: paper: 2017 Component OPR Spreadsheet

Rachel
I really found your component OPR research in 2017 to be really interesting in tracking game trends and strategies. I hope you will continue for 2018
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 01:41 PM.

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


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