Go to Post There are two types of competitors in this world, those who aim to rise above their opponents and those who seek to drag them down. Which group do you want to belong to? Which group is more beneficial to our society? Think about it. - Karthik [more]
Home
Go Back   Chief Delphi > ChiefDelphi.com Website > Extra Discussion
CD-Events   CD-Media   CD-Spy   FRC-Spy  
portal register members calendar search Today's Posts Mark Forums Read FAQ rules

 
Reply
Thread Tools Rating: Thread Rating: 6 votes, 5.00 average. Display Modes
  #91   Spotlight this post!  
Unread 03-15-2010, 02:49 PM
Ed Law's Avatar
Ed Law Ed Law is offline
Registered User
FRC #2834 (Bionic Black Hawks [formerly Bionic Barons])
Team Role: Coach
 
Join Date: Apr 2008
Rookie Year: 2009
Location: Bloomfield Hills, Michigan, USA
Posts: 590
Ed Law has a reputation beyond reputeEd Law has a reputation beyond reputeEd Law has a reputation beyond reputeEd Law has a reputation beyond reputeEd Law has a reputation beyond reputeEd Law has a reputation beyond reputeEd Law has a reputation beyond reputeEd Law has a reputation beyond reputeEd Law has a reputation beyond reputeEd Law has a reputation beyond reputeEd Law has a reputation beyond repute
Re: paper: New Scouting Database from Team 2834

Thanks to "Vikesrock" who sent me the Wisconsin data, I have added the ranking information, Seeding Score and Coopertition Bonus but I am still missing the Hanging Points. He mentioned that the Seeding Score may have a slight error since 2194 is listed with the highest Coop points and 111 got the award. If anyone has more information, please let me know.
__________________
Please don't call me Mr. Ed, I am not a talking horse.

2014 Great Lakes Bay Region district
2014 Queen City regional
2014 Bedford district
2014 Michigan State Championship
Reply With Quote
  #92   Spotlight this post!  
Unread 03-17-2010, 11:46 PM
cygnus.x1 cygnus.x1 is offline
Registered User
FRC #1868 (Space Cookies)
Team Role: Mentor
 
Join Date: Dec 2008
Rookie Year: 2007
Location: Silicon Valley, California
Posts: 11
cygnus.x1 is an unknown quantity at this point
Thumbs up Re: paper: New Scouting Database from Team 2834

Thanks for reviving this spreadsheet Ed!

It's working great. We're off to SVR tomorrow.
__________________


http://www.spacecookies.org/
Reply With Quote
  #93   Spotlight this post!  
Unread 03-22-2010, 11:43 AM
Joe Ross's Avatar Unsung FIRST Hero
Joe Ross Joe Ross is offline
Registered User
FRC #0330 (Beachbots)
Team Role: Engineer
 
Join Date: Jun 2001
Rookie Year: 1997
Location: Los Angeles, CA
Posts: 7,717
Joe Ross has a reputation beyond reputeJoe Ross has a reputation beyond reputeJoe Ross has a reputation beyond reputeJoe Ross has a reputation beyond reputeJoe Ross has a reputation beyond reputeJoe Ross has a reputation beyond reputeJoe Ross has a reputation beyond reputeJoe Ross has a reputation beyond reputeJoe Ross has a reputation beyond reputeJoe Ross has a reputation beyond reputeJoe Ross has a reputation beyond repute
Re: paper: New Scouting Database from Team 2834

I'm having trouble updating the data for Silicon Valley. I change to the tab called SiliconValley and do ctrl-shift-p and I get Run-time error '1004'. If I hit debug, it's failing on the first querytable refresh. I notice that if I'm on one of the regionals with existing data, I see the external data toolbar pop up, but I don't see that on the later regionals. Is there something more I need to do?
Reply With Quote
  #94   Spotlight this post!  
Unread 03-22-2010, 09:35 PM
Ed Law's Avatar
Ed Law Ed Law is offline
Registered User
FRC #2834 (Bionic Black Hawks [formerly Bionic Barons])
Team Role: Coach
 
Join Date: Apr 2008
Rookie Year: 2009
Location: Bloomfield Hills, Michigan, USA
Posts: 590
Ed Law has a reputation beyond reputeEd Law has a reputation beyond reputeEd Law has a reputation beyond reputeEd Law has a reputation beyond reputeEd Law has a reputation beyond reputeEd Law has a reputation beyond reputeEd Law has a reputation beyond reputeEd Law has a reputation beyond reputeEd Law has a reputation beyond reputeEd Law has a reputation beyond reputeEd Law has a reputation beyond repute
Week 3 data is posted

I updated the database to include week 3 data. All the week 3 regional and district data are in each tab. However, due to the unfortunate circumstances at the Israel Regional, I did not include those data in the master database. The data is not very meaninful when each team played only 3 matches. Hence when you use the query tab, the Israel Regional data will not show up.
__________________
Please don't call me Mr. Ed, I am not a talking horse.

2014 Great Lakes Bay Region district
2014 Queen City regional
2014 Bedford district
2014 Michigan State Championship
Reply With Quote
  #95   Spotlight this post!  
Unread 03-23-2010, 10:51 AM
Ed Law's Avatar
Ed Law Ed Law is offline
Registered User
FRC #2834 (Bionic Black Hawks [formerly Bionic Barons])
Team Role: Coach
 
Join Date: Apr 2008
Rookie Year: 2009
Location: Bloomfield Hills, Michigan, USA
Posts: 590
Ed Law has a reputation beyond reputeEd Law has a reputation beyond reputeEd Law has a reputation beyond reputeEd Law has a reputation beyond reputeEd Law has a reputation beyond reputeEd Law has a reputation beyond reputeEd Law has a reputation beyond reputeEd Law has a reputation beyond reputeEd Law has a reputation beyond reputeEd Law has a reputation beyond reputeEd Law has a reputation beyond repute
Re: paper: New Scouting Database from Team 2834

Quote:
Originally Posted by Joe Ross View Post
I'm having trouble updating the data for Silicon Valley. I change to the tab called SiliconValley and do ctrl-shift-p and I get Run-time error '1004'. If I hit debug, it's failing on the first querytable refresh. I notice that if I'm on one of the regionals with existing data, I see the external data toolbar pop up, but I don't see that on the later regionals. Is there something more I need to do?
Last year, I entered the link manually after it becomes available which is usually a few days before each week's competition. There is no data but the page would be setup so my link will be valid. At the end of the season, I wrote a macro to automatically set it up for all the weeks and it worked. Unfortunately FIRST changed something this year and it is no longer working. Also I was forced to migrate to Excel 2007 and it does not look like they support the .iqy files any more. So now I am back to manually setting up the link after the competitions are over.

If anybody is interested in using this spreadsheet during the competition which has internet access, you need to set up the link. The easiest way is this. Use a browser to navigate to the page where they show ranking. Copy the URL. Go to the tab of the regional you want to use.

In Excel 2003, select cell A1, go to Data, Import External Data and then New Web Query. Paste the URL data into the box that says Address. Then select the table of the page that shows the ranking only. You will see a check mark. Then click import. Then go to cell A101 and A251 and do the same thing for qualifying and elimination match results. That's it.

In Excel 2007, select Data tab and click From Web. The rest are the same.

If you need more help, please PM me. I will walk you through over the phone.

Sorry I don't know enough to setup the link ahead of time for you when the page does not exist. If somebody knows how to overcome this, please let me know.
__________________
Please don't call me Mr. Ed, I am not a talking horse.

2014 Great Lakes Bay Region district
2014 Queen City regional
2014 Bedford district
2014 Michigan State Championship
Reply With Quote
  #96   Spotlight this post!  
Unread 03-30-2010, 07:46 PM
Joe Ross's Avatar Unsung FIRST Hero
Joe Ross Joe Ross is offline
Registered User
FRC #0330 (Beachbots)
Team Role: Engineer
 
Join Date: Jun 2001
Rookie Year: 1997
Location: Los Angeles, CA
Posts: 7,717
Joe Ross has a reputation beyond reputeJoe Ross has a reputation beyond reputeJoe Ross has a reputation beyond reputeJoe Ross has a reputation beyond reputeJoe Ross has a reputation beyond reputeJoe Ross has a reputation beyond reputeJoe Ross has a reputation beyond reputeJoe Ross has a reputation beyond reputeJoe Ross has a reputation beyond reputeJoe Ross has a reputation beyond reputeJoe Ross has a reputation beyond repute
Re: paper: New Scouting Database from Team 2834

Thanks, I think I figured it out. A few other things that (temporarily) got me. I had to set the properties of the web query to overwrite, or else it would insert new columns and throw everything off. I also had to change the last range in RefreshData to A251 instead of A201.

Once I did those, I was able to calculate the OPR and CCWM. Thanks!
Reply With Quote
  #97   Spotlight this post!  
Unread 03-30-2010, 09:25 PM
rulesall2 rulesall2 is offline
Registered User
no team
Team Role: Tactician
 
Join Date: Feb 2009
Rookie Year: 2008
Location: The moon
Posts: 55
rulesall2 has much to be proud ofrulesall2 has much to be proud ofrulesall2 has much to be proud ofrulesall2 has much to be proud ofrulesall2 has much to be proud ofrulesall2 has much to be proud ofrulesall2 has much to be proud ofrulesall2 has much to be proud ofrulesall2 has much to be proud of
Re: paper: New Scouting Database from Team 2834

There is a mistake in the WPI regional. During the regional the last qualification match was not counted when the data was saved into FMS so the version that is out on the FIRST site isn't the final version that was used for alliance selections, which were re-done after the error was realized. The match can be found here: http://www.thebluealliance.net/tbatv/match/2010wor_qm58

That would bump 2791 to 7th seed 5th alliance captain at WPI. And 190 would also be bumped up to 6th seed 4th alliance captain. This would mean 2104 would not be the #5 Alliance captain, but instead was the 8th alliance captain. Below is the list of the alliance selection of WPI with teams in order of captain, 1st pick, 2nd pick.
WPI 2010.

1 230 20 228 W
2 1735 2370 663 F
3 3280 348 157 SF
4 190 2523 839 SF
5 2791 195 1124 QF
6 2877 172 3205 QF
7 358 716 2621 QF
8 2104 1995 3125 QF
Reply With Quote
  #98   Spotlight this post!  
Unread 03-30-2010, 09:42 PM
XaulZan11's Avatar
XaulZan11 XaulZan11 is offline
Registered User
AKA: John Christiansen
FRC #1732 (Hilltoppers)
Team Role: Mentor
 
Join Date: Nov 2006
Rookie Year: 2006
Location: Milwaukee, Wi
Posts: 1,052
XaulZan11 has a reputation beyond reputeXaulZan11 has a reputation beyond reputeXaulZan11 has a reputation beyond reputeXaulZan11 has a reputation beyond reputeXaulZan11 has a reputation beyond reputeXaulZan11 has a reputation beyond reputeXaulZan11 has a reputation beyond reputeXaulZan11 has a reputation beyond reputeXaulZan11 has a reputation beyond reputeXaulZan11 has a reputation beyond reputeXaulZan11 has a reputation beyond repute
Send a message via AIM to XaulZan11
Re: paper: New Scouting Database from Team 2834

Thanks for putting this together again. It's a huge help for the Championship.

I came across two errors, however, regarding Wisconsin and Midwest. For Wisconsin, it says 1732 was picked 4th or 13th; we were actually picked 3rd. For Midwest, it says we were first pick, but we were actually AC1. A quick glance finds some more errors with those regionals.

I didn't check other regionals, but I would suggest you check all the regionals using the information from this thread: http://www.chiefdelphi.com/forums/sh...ce+selectio n
Reply With Quote
  #99   Spotlight this post!  
Unread 03-31-2010, 11:32 AM
Ed Law's Avatar
Ed Law Ed Law is offline
Registered User
FRC #2834 (Bionic Black Hawks [formerly Bionic Barons])
Team Role: Coach
 
Join Date: Apr 2008
Rookie Year: 2009
Location: Bloomfield Hills, Michigan, USA
Posts: 590
Ed Law has a reputation beyond reputeEd Law has a reputation beyond reputeEd Law has a reputation beyond reputeEd Law has a reputation beyond reputeEd Law has a reputation beyond reputeEd Law has a reputation beyond reputeEd Law has a reputation beyond reputeEd Law has a reputation beyond reputeEd Law has a reputation beyond reputeEd Law has a reputation beyond reputeEd Law has a reputation beyond repute
Re: paper: New Scouting Database from Team 2834

Quote:
Originally Posted by rulesall2 View Post
There is a mistake in the WPI regional. During the regional the last qualification match was not counted when the data was saved into FMS so the version that is out on the FIRST site isn't the final version that was used for alliance selections, which were re-done after the error was realized. The match can be found here: http://www.thebluealliance.net/tbatv/match/2010wor_qm58

That would bump 2791 to 7th seed 5th alliance captain at WPI. And 190 would also be bumped up to 6th seed 4th alliance captain. This would mean 2104 would not be the #5 Alliance captain, but instead was the 8th alliance captain. Below is the list of the alliance selection of WPI with teams in order of captain, 1st pick, 2nd pick.
WPI 2010.

1 230 20 228 W
2 1735 2370 663 F
3 3280 348 157 SF
4 190 2523 839 SF
5 2791 195 1124 QF
6 2877 172 3205 QF
7 358 716 2621 QF
8 2104 1995 3125 QF
Thank you for pointing that out. I will make these changes when I publish after all district/regionals are done. It takes an hour to repopulate the data into the central database sheets WM data and OPR data. I can't change that every time there is one mistake.
__________________
Please don't call me Mr. Ed, I am not a talking horse.

2014 Great Lakes Bay Region district
2014 Queen City regional
2014 Bedford district
2014 Michigan State Championship
Reply With Quote
  #100   Spotlight this post!  
Unread 03-31-2010, 12:09 PM
Ed Law's Avatar
Ed Law Ed Law is offline
Registered User
FRC #2834 (Bionic Black Hawks [formerly Bionic Barons])
Team Role: Coach
 
Join Date: Apr 2008
Rookie Year: 2009
Location: Bloomfield Hills, Michigan, USA
Posts: 590
Ed Law has a reputation beyond reputeEd Law has a reputation beyond reputeEd Law has a reputation beyond reputeEd Law has a reputation beyond reputeEd Law has a reputation beyond reputeEd Law has a reputation beyond reputeEd Law has a reputation beyond reputeEd Law has a reputation beyond reputeEd Law has a reputation beyond reputeEd Law has a reputation beyond reputeEd Law has a reputation beyond repute
Re: paper: New Scouting Database from Team 2834

Quote:
Originally Posted by XaulZan11 View Post
Thanks for putting this together again. It's a huge help for the Championship.

I came across two errors, however, regarding Wisconsin and Midwest. For Wisconsin, it says 1732 was picked 4th or 13th; we were actually picked 3rd. For Midwest, it says we were first pick, but we were actually AC1. A quick glance finds some more errors with those regionals.

I didn't check other regionals, but I would suggest you check all the regionals using the information from this thread: http://www.chiefdelphi.com/forums/sh...ce+selectio n
My program automatically calculates the Alliance captain and picking order based on the ranking. Unfortunately, the Wisconsin ranking list is missing. My data came from "Vikesrock" but there may be small errors in it. The FIRST Midwest data shows 1732 ranked number 2 which is why my program thought you were first pick instead of AC1. I will fix these problems when I publish the final data before championship.
__________________
Please don't call me Mr. Ed, I am not a talking horse.

2014 Great Lakes Bay Region district
2014 Queen City regional
2014 Bedford district
2014 Michigan State Championship
Reply With Quote
  #101   Spotlight this post!  
Unread 03-31-2010, 12:11 PM
Ed Law's Avatar
Ed Law Ed Law is offline
Registered User
FRC #2834 (Bionic Black Hawks [formerly Bionic Barons])
Team Role: Coach
 
Join Date: Apr 2008
Rookie Year: 2009
Location: Bloomfield Hills, Michigan, USA
Posts: 590
Ed Law has a reputation beyond reputeEd Law has a reputation beyond reputeEd Law has a reputation beyond reputeEd Law has a reputation beyond reputeEd Law has a reputation beyond reputeEd Law has a reputation beyond reputeEd Law has a reputation beyond reputeEd Law has a reputation beyond reputeEd Law has a reputation beyond reputeEd Law has a reputation beyond reputeEd Law has a reputation beyond repute
Re: paper: New Scouting Database from Team 2834

Week 4 data is published. Colorado data is missing from FIRST.
__________________
Please don't call me Mr. Ed, I am not a talking horse.

2014 Great Lakes Bay Region district
2014 Queen City regional
2014 Bedford district
2014 Michigan State Championship
Reply With Quote
  #102   Spotlight this post!  
Unread 04-06-2010, 09:40 AM
Ed Law's Avatar
Ed Law Ed Law is offline
Registered User
FRC #2834 (Bionic Black Hawks [formerly Bionic Barons])
Team Role: Coach
 
Join Date: Apr 2008
Rookie Year: 2009
Location: Bloomfield Hills, Michigan, USA
Posts: 590
Ed Law has a reputation beyond reputeEd Law has a reputation beyond reputeEd Law has a reputation beyond reputeEd Law has a reputation beyond reputeEd Law has a reputation beyond reputeEd Law has a reputation beyond reputeEd Law has a reputation beyond reputeEd Law has a reputation beyond reputeEd Law has a reputation beyond reputeEd Law has a reputation beyond reputeEd Law has a reputation beyond repute
Re: paper: New Scouting Database from Team 2834

Week 5 data is published. I will publish the data again after championship division data is available. I will be in Atlanta and can only update these data at night at the hotel since there is no internet access at the competition.

1) Colorado data is now included.
2) Wisconsin data was republished by FIRST and is included.
3) For Midwest, I only manually fixed the data for Team 1732. Some other team's data may still be wrong.
4) For WPI, I tried to fix the data by manually adding the seeding points for the 6 teams from the last match. However, the order is still not right because there must have been some penalties that affected the points. I decided to leave it as is until FIRST fix the data.
5) I added a macro to replace one regional's data when there is a change instead of redoing all the regionals in the central database. This will make it easier for me if FIRST publish corrected data.
6) Israel data is not in the central database. The sheet for that regional is still available.

If you are aware of any corrected data that is republished, please let me know. If you want good data in this database, you need to work with your regional director and FIRST to get the data corrected. A lot of teams and TBA depend on these data.
__________________
Please don't call me Mr. Ed, I am not a talking horse.

2014 Great Lakes Bay Region district
2014 Queen City regional
2014 Bedford district
2014 Michigan State Championship
Reply With Quote
  #103   Spotlight this post!  
Unread 04-06-2010, 11:59 PM
Ed Law's Avatar
Ed Law Ed Law is offline
Registered User
FRC #2834 (Bionic Black Hawks [formerly Bionic Barons])
Team Role: Coach
 
Join Date: Apr 2008
Rookie Year: 2009
Location: Bloomfield Hills, Michigan, USA
Posts: 590
Ed Law has a reputation beyond reputeEd Law has a reputation beyond reputeEd Law has a reputation beyond reputeEd Law has a reputation beyond reputeEd Law has a reputation beyond reputeEd Law has a reputation beyond reputeEd Law has a reputation beyond reputeEd Law has a reputation beyond reputeEd Law has a reputation beyond reputeEd Law has a reputation beyond reputeEd Law has a reputation beyond repute
Re: paper: New Scouting Database from Team 2834

There was a small error in Midwest data. When I switched the ranking of 1732 and 16 manually, I forgot to switch their OPR, CCWM etc. It is now corrected in version 2. This is one of the reasons why I don't like to change the data manually. There is always a chance of human error introduced.
__________________
Please don't call me Mr. Ed, I am not a talking horse.

2014 Great Lakes Bay Region district
2014 Queen City regional
2014 Bedford district
2014 Michigan State Championship
Reply With Quote
  #104   Spotlight this post!  
Unread 04-08-2010, 05:52 PM
Ed Law's Avatar
Ed Law Ed Law is offline
Registered User
FRC #2834 (Bionic Black Hawks [formerly Bionic Barons])
Team Role: Coach
 
Join Date: Apr 2008
Rookie Year: 2009
Location: Bloomfield Hills, Michigan, USA
Posts: 590
Ed Law has a reputation beyond reputeEd Law has a reputation beyond reputeEd Law has a reputation beyond reputeEd Law has a reputation beyond reputeEd Law has a reputation beyond reputeEd Law has a reputation beyond reputeEd Law has a reputation beyond reputeEd Law has a reputation beyond reputeEd Law has a reputation beyond reputeEd Law has a reputation beyond reputeEd Law has a reputation beyond repute
Re: paper: New Scouting Database from Team 2834

Championship division data is now included. I will be posting divisonal strength tonight.
__________________
Please don't call me Mr. Ed, I am not a talking horse.

2014 Great Lakes Bay Region district
2014 Queen City regional
2014 Bedford district
2014 Michigan State Championship
Reply With Quote
  #105   Spotlight this post!  
Unread 04-12-2010, 10:43 PM
Ed Law's Avatar
Ed Law Ed Law is offline
Registered User
FRC #2834 (Bionic Black Hawks [formerly Bionic Barons])
Team Role: Coach
 
Join Date: Apr 2008
Rookie Year: 2009
Location: Bloomfield Hills, Michigan, USA
Posts: 590
Ed Law has a reputation beyond reputeEd Law has a reputation beyond reputeEd Law has a reputation beyond reputeEd Law has a reputation beyond reputeEd Law has a reputation beyond reputeEd Law has a reputation beyond reputeEd Law has a reputation beyond reputeEd Law has a reputation beyond reputeEd Law has a reputation beyond reputeEd Law has a reputation beyond reputeEd Law has a reputation beyond repute
Re: paper: New Scouting Database from Team 2834

It seems that since I last posted, some teams dropped out and some teams were added. I will update it Thursday morning after the match schedule comes out and at the end of each day.

How many teams going to Atlanta will actually be using this database and update it in real time? If you do, please stop by our pit and say hi. I would love to talk to you and get some feedback.
__________________
Please don't call me Mr. Ed, I am not a talking horse.

2014 Great Lakes Bay Region district
2014 Queen City regional
2014 Bedford district
2014 Michigan State Championship
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

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 09:46 PM.

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


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