Exercise, eat properly, work hard, live hard, play hard, laugh hard, inspire people, solve problems. And leave the world around you a little better place than you found it. - ebarker [more]
 Chief Delphi paper: New Scouting Database from Team 2834
 CD-Media CD-Spy
 portal register members calendar search Today's Posts Mark Forums Read FAQ rules

#151
04-18-2011, 10:52 PM
 Ed Law Registered User FRC #0008 (formerly with 2834) Team Role: Mentor Join Date: Apr 2008 Rookie Year: 2009 Location: Foster City, CA, USA Posts: 760
Re: paper: New Scouting Database from Team 2834

Quote:
 Originally Posted by Travis Hoffman Thanks, Ed! Can you please explain in more detail the calculation on the WM Results tab, column G, "Wt. Avg. CCWM", when calculated in "default" mode? How is that number obtained? How is the weighting done?
The weighted average is calculated this way. This year there are 6 weeks of competition. By default, the weighted average is projected to the week after which is 7.
The OPR from each event is scaled by multiplying the reciprocal of the number of weeks between the event and week 7. For example if the event was in week 3, then the OPR (x) will multiply by 1/4. Let's say this team also attended a Week 5 event, that OPR (y) will multiply by 1/2. The weighted average will be (x/4+y/2)/(1/4+1/2). In this case, the week 5 event will have double the weight than the week 3 event since x is divided by 4 and y is only divided by 2.
I hope this makes sense. There is nothing special about this way of assigning weight. There can be many other ways to do it. The idea is the events closer to week 7 should have a higher weight than events that are earlier. I did it this way out of simplicity and convenience. You can use a quadratic function or exponential function if you wish.
__________________
Please don't call me Mr. Ed, I am not a talking horse.
#152
04-20-2011, 10:18 PM
 Ed Law Registered User FRC #0008 (formerly with 2834) Team Role: Mentor Join Date: Apr 2008 Rookie Year: 2009 Location: Foster City, CA, USA Posts: 760
Re: paper: New Scouting Database from Team 2834

Championship version 2 is out. Good news, all 4 divisions are now linked to FIRST website. You can just refresh the pages when you are at championship and everything should work. Remember each team has to play at least 3 matches before the OPR/CCWM can be calculated. And the numbers will start to stabilize as more matches are played.

I finally figured out that in Excel 2007/2010, I can still put in the link to web pages that I know the URL but the page does not exist yet. However I still need to figure out how to automate it like in Excel 2003. Microsoft changed the way how it is done and the old macro does not work anymore. This will be one of my off-season project.

By the way, I will be in St. Louis on Friday and Saturday without my team. I am the proud father of a Dean's List finalist who will be there with me as part of the 6 finalist from Michigan. I will be updating the OPR results regularly on my computer. If anybody plans to use this spreadsheet at the Championship and would like help, PM me and I will give you my cell phone number. My version of the spreadsheet has some goodies that may help your scouting team. I really have nothing to do the whole weekend there. I would be glad to help out any team if needed.
__________________
Please don't call me Mr. Ed, I am not a talking horse.
#153
04-21-2011, 07:53 PM
 Ed Law Registered User FRC #0008 (formerly with 2834) Team Role: Mentor Join Date: Apr 2008 Rookie Year: 2009 Location: Foster City, CA, USA Posts: 760
Re: paper: New Scouting Database from Team 2834

I did not realize they added some teams. Version 2b reflects the changes.
__________________
Please don't call me Mr. Ed, I am not a talking horse.
#154
04-29-2011, 07:16 PM
 PSHRobotics Registered User FRC #1182 Team Role: Programmer Join Date: Feb 2010 Rookie Year: 2008 Location: Missouri Posts: 38
Re: paper: New Scouting Database from Team 2834

Thank you so much for the work you have put in!
Although it is not that big of a deal for me at the moment, I do want to let you know for other people and for the future. When I use ctrl-shift-p to refresh, I get an error that says:
Quote:
 Run-time error '1004': Application-defined or object-defined error
If you need any help debugging I'd be happy to help, although my experience with complex excel functions and visual basic is very limited.

Edit: I did change the shortcut to ctrl-u and the same problem occurred.
#155
04-29-2011, 07:19 PM
 Vikesrock Team 2175 Founder AKA: Kevin O'Connor FRC #0238 Team Role: Engineer Join Date: Mar 2006 Rookie Year: 2007 Location: Manchester, NH Posts: 3,313
Re: paper: New Scouting Database from Team 2834

Quote:
 Originally Posted by PSHRobotics Thank you so much for the work you have put in! Although it is not that big of a deal for me at the moment, I do want to let you know for other people and for the future. When I use ctrl-shift-p to refresh, I get an error that says: If you need any help debugging I'd be happy to help, although my experience with complex excel functions and visual basic is very limited. Edit: I did change the shortcut to ctrl-u and the same problem occurred.
The links for the division data are wrong. If Ed doesn't see this and post a fixed version, I can post one when I get to my hotel tonight, probably around 11.
#156
04-29-2011, 09:06 PM
 Ed Law Registered User FRC #0008 (formerly with 2834) Team Role: Mentor Join Date: Apr 2008 Rookie Year: 2009 Location: Foster City, CA, USA Posts: 760
Re: paper: New Scouting Database from Team 2834

I did realize the links were wrong. I will be posting the updated links in a few minutes.
__________________
Please don't call me Mr. Ed, I am not a talking horse.
#157
04-29-2011, 09:20 PM
 Ed Law Registered User FRC #0008 (formerly with 2834) Team Role: Mentor Join Date: Apr 2008 Rookie Year: 2009 Location: Foster City, CA, USA Posts: 760
Re: paper: New Scouting Database from Team 2834

Version 3 is out. It contains data through Friday matches at Championship.

I put in the wrong links because the links were put in before the URL were available. For regionals/districts, event codes were used in the URL. I forgot that for Championship, the 4 divisions use the full name in the URL instead of the abbreviation code that is used on frclinks. Sorry about that. If anybody find anything else that is wrong, please let me know.
__________________
Please don't call me Mr. Ed, I am not a talking horse.
#158
04-29-2011, 10:52 PM
 Vikesrock Team 2175 Founder AKA: Kevin O'Connor FRC #0238 Team Role: Engineer Join Date: Mar 2006 Rookie Year: 2007 Location: Manchester, NH Posts: 3,313
Re: paper: New Scouting Database from Team 2834

Quote:
 Originally Posted by Ed Law Version 3 is out. It contains data through Friday matches at Championship.
Thanks Ed!
#159
05-01-2011, 05:24 PM
 Ed Law Registered User FRC #0008 (formerly with 2834) Team Role: Mentor Join Date: Apr 2008 Rookie Year: 2009 Location: Foster City, CA, USA Posts: 760
Re: paper: New Scouting Database from Team 2834

Version 4 is out. This should be the final version for this year unless somebody finds a mistake. I updated the world's ranking also. 1114 is still #1 in OPR world ranking and #2 in CCWM world ranking. 148 is #2 in OPR world ranking and #1 in CCWM world ranking.
__________________
Please don't call me Mr. Ed, I am not a talking horse.
#160
05-02-2011, 04:23 PM
 Ed Law Registered User FRC #0008 (formerly with 2834) Team Role: Mentor Join Date: Apr 2008 Rookie Year: 2009 Location: Foster City, CA, USA Posts: 760
Re: paper: New Scouting Database from Team 2834

Guess who has the highest OPR out of all 4 divisions during qualifying matches (63.4). (To see answer, highlight space to the right of Answer)
Guess who has the Most Win during the whole season (71)
Guess who has the Highest Win to Loss difference (55)

Awesome offensive machine
__________________
Please don't call me Mr. Ed, I am not a talking horse.
#161
07-29-2011, 11:40 PM
 Ed Law Registered User FRC #0008 (formerly with 2834) Team Role: Mentor Join Date: Apr 2008 Rookie Year: 2009 Location: Foster City, CA, USA Posts: 760
Re: paper: New Scouting Database from Team 2834

Quote:
 Originally Posted by Travis Hoffman Thanks, Ed. I thought it was a "what have you done for me lately" kind of deal. Another question, one you've been asked before, likely. When I attempt to open your spreadsheet in Excel 2003 (I have the Office 2007 compatibility pack), it always seems to freeze up. Is there a way to get your spreadsheet to work as an Excel 2003 xls, or perhaps is there a way to re-save it in another 2007 format such that it can be opened in 2003?
I finally was able to save it in 2003 format. It is version 4b. After I zipped the file, the file size is actually smaller than the zipped 2007 version. Quite surprising.
__________________
Please don't call me Mr. Ed, I am not a talking horse.
#162
02-27-2012, 01:27 AM
 Ed Law Registered User FRC #0008 (formerly with 2834) Team Role: Mentor Join Date: Apr 2008 Rookie Year: 2009 Location: Foster City, CA, USA Posts: 760
Re: paper: New Scouting Database from Team 2834

I created links of standing and match results for all the events already so all you have to do is refresh it at the event. I will test it to make sure they work during the Week 1 events. This is the first year we are not going to a Week 1 event so I will have more time to check the results and post them immediately afterwards.

I know there are discussions of OPR before or after penalties. I will try to address them at a later time.
__________________
Please don't call me Mr. Ed, I am not a talking horse.
#163
03-06-2012, 02:00 AM
 Ed Law Registered User FRC #0008 (formerly with 2834) Team Role: Mentor Join Date: Apr 2008 Rookie Year: 2009 Location: Foster City, CA, USA Posts: 760
Re: paper: New Scouting Database from Team 2834

Week 1 results are posted. It took a little longer to get this done because FIRST changed the format of the team standing page and I have to modify quite a bit in the macro.

I also fixed all the links for all future events. They should be working now.
__________________
Please don't call me Mr. Ed, I am not a talking horse.
#164
03-06-2012, 12:17 PM
 Ed Law Registered User FRC #0008 (formerly with 2834) Team Role: Mentor Join Date: Apr 2008 Rookie Year: 2009 Location: Foster City, CA, USA Posts: 760
Re: paper: New Scouting Database from Team 2834

Good News. I was able to get the OPR of Hybrid, Bridge, Teleop and Coopertition separately. It is much easier than I thought. It took about 20 lines of code and 20 minutes. I put the OPR results in each event. I put it all the way to the right so it does not mess up the columns of other data.

Would somebody please compare my numbers with numbers published by others to see if it is consistent?

To get the True World OPR for each individual component will take more work. I will add it in the next few weeks.
__________________
Please don't call me Mr. Ed, I am not a talking horse.
#165
03-11-2012, 11:26 PM
 Ed Law Registered User FRC #0008 (formerly with 2834) Team Role: Mentor Join Date: Apr 2008 Rookie Year: 2009 Location: Foster City, CA, USA Posts: 760
Re: paper: New Scouting Database from Team 2834

Week 2 results are out. New true world ranking is posted. The highest OPR is now 36.71 from Team 2056 folowed closely by Team 67 with OPR of 36.16

All the links of week 2 events that I put in last week worked. Just use Cntl-Shirt-P to run the macro and you will get the overall OPR as well as OPR for hybrid, bridge, teleop and coopertition during the event.
__________________
Please don't call me Mr. Ed, I am not a talking horse.

 Thread Tools Display Modes Rate This Thread Linear Mode Rate This Thread: 5 : Excellent 4 : Good 3 : Average 2 : Bad 1 : Terrible

 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 User Control Panel Private Messages Subscriptions Who's Online Search Forums Forums Home Announcements     User Announcements FIRST     General Forum         FIRST E-Mail Blast Archive     Rumor Mill     Career     Robot Showcase Technical     Technical Discussion     Robotics Education and Curriculum     Motors     Electrical         CAN     Programming         NI LabVIEW         C/C++         Java         Python     Control System         FRC Control System         Sensors     Pneumatics     Kit & Additional Hardware     CAD         Inventor         SolidWorks         Creo     IT / Communications         3D Animation and Competition         Website Design/Showcase         Videography and Photography         Computer Graphics     National Instruments LabVIEW and Data Acquisition         LabView and Data Acquisition Competition     Unsung FIRST Heroes     Awards         Chairman's Award     Rules/Strategy         Scouting         You Make The Call     Team Organization         Fundraising         Starting New Teams         Finding A Team         College Teams     Championship Event     Regional Competitions     District Events     Off-Season Events     Thanks and/or Congrats     FRC Game Design     OCCRA         OCCRA Q&A         OCCRA Programming Other     Chit-Chat         Games/Trivia             Fantasy FIRST     Car Nack's Corner     College & University Education     Dean Kamen's Inventions     FIRST-related Organizations         Western Region Robotics Forum         Southern California Regional Robotics Forum         The Blue Alliance             Video Archives     FIRST In the News...     FIRST Lego League         Lego Mindstorm Discussion     FIRST Tech Challenge     VEX         VEX Robotics Competition         VEX IQ     Televised Robotics     Math and Science         NASA Discussion ChiefDelphi.com Website     CD Forum Support     Extra Discussion

 Similar Threads Thread Thread Starter Forum Replies Last Post paper: 2007 Championship Event Scouting Database, presented by Team 1114 Karthik Extra Discussion 18 04-10-2007 04:02 PM paper: Waterloo Regional Scouting Database astephen68 Extra Discussion 3 03-04-2007 06:34 PM paper: Scoring for scouting database wheeler Extra Discussion 1 01-27-2007 02:56 PM paper: 2006 Excel Scouting database Greg Needel Scouting 11 04-20-2006 08:41 PM White Paper Discuss: Scouting database Marjory Frosty Extra Discussion 0 01-08-2006 06:03 PM

All times are GMT -5. The time now is 04:52 PM.

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

 -- English (12 hour) -- English (24 hour) Contact Us - Chief Delphi - Rules - Archive - Top