View Full Version : 2013 Championship OPR/CCWM spreadsheet
The scouting database for 2013 Championship is now available at
http://www.chiefdelphi.com/media/papers/2174
There are a number of changes to the version after Week 7 events
1) Division data for 400 teams
2) Links set up for all 4 divisions for those who use Cntr-Shift-P to do automatic update at the event. If the link does not work, PM or email me or stop by our pit in Galileo division
3) Number of events attended now includes the championship
4) Alliance selection order is now reported based on the CD thread on Alliance selection. Thanks to Joe Ross who worked so hard to put everything in one convenient spreadsheet
If there is any error, please let me know.
I would love to see how you use these data to enhance your scouting at championship. Please stop by and say hi and show me your scouting system. I would be glad to show you ours. We use tablets -> bluetooth -> master tablet -> laptop Excel spreadsheet. We are in the Galileo division.
DELurker
19-04-2013, 12:47
Please stop by and say hi and show me your scouting system. I would be glad to show you ours. We use tablets -> bluetooth -> master tablet -> laptop Excel spreadsheet. We are in the Galileo division.
I was under the impression that all all wireless networks, including Bluetooth, IEEE 802.11*, and IEEE 802.15.4, were banned from venues on the grounds that they can potentially interfere with the field signals since they all reside inside the same frequency range (2.4 GHz ISM). Did I misread something? Has someting changed? I cannot find any reference in the manuals, but I remember announcements about it from events.
jlmcmchl
19-04-2013, 13:07
Last I checked, FIRST did not address 802.15(Bluetooth) in the rule book, only 802.11. And this year I did not see anything in the rule book regarding either standard(trust me, I had to make sure that Bluetooth worked for Team RUSH's scouting system right when the rule book came out, and I did not see anything there or in the administrative handbook).
DELurker
19-04-2013, 17:53
If that's the case, I'm a happy guy. I had wanted to use 802.15.4 to make a comm network from stands to pit using ZigBee.
RufflesRidge
19-04-2013, 18:00
And this year I did not see anything in the rule book regarding either standard(trust me, I had to make sure that Bluetooth worked for Team RUSH's scouting system right when the rule book came out, and I did not see anything there or in the administrative handbook).
Try T04
T04
Teams are not allowed to set up their own 802.11a/b/g/n/ac (2.4GHz or 5GHz) wireless communication (e.g. access points or ad-hoc networks) in the venue.
Banderoonies
19-04-2013, 18:04
The scouting database for 2013 Championship is now available at
http://www.chiefdelphi.com/media/papers/2174
There are a number of changes to the version after Week 7 events
1) Division data for 400 teams
2) Links set up for all 4 divisions for those who use Cntr-Shift-P to do automatic update at the event. If the link does not work, PM or email me or stop by our pit in Galileo division
3) Number of events attended now includes the championship
4) Alliance selection order is now reported based on the CD thread on Alliance selection. Thanks to Joe Ross who worked so hard to put everything in one convenient spreadsh
If there is any error, please let me know.
I would love to see how you use these data to enhance your scouting at championship. Please stop by and say hi and show me your scouting system. I would be glad to show you ours. We use tablets -> bluetooth -> master tablet -> laptop Excel spreadsheet. We are in the Galileo division.
Ed, thank you for all your scouting work. 195 uses your database each season to understand the stats for robots in our division. We can't thank you enough for all you do for ALL FIRST teams.
Sandra from 195
Try T04
T04
Teams are not allowed to set up their own 802.11a/b/g/n/ac (2.4GHz or 5GHz) wireless communication (e.g. access points or ad-hoc networks) in the venue.
As Zigbee isn't a 802.11 standard (it is 802.15.4), couldn't you still set up the network anyhow?
RufflesRidge
19-04-2013, 19:35
As Zigbee isn't a 802.11 standard (it is 802.15.4), couldn't you still set up the network anyhow?
Presumably you could.
It may be worth noting however, that the FTC wireless system runs on the 2.4GHz band and last year they were using wireless sniffers to identify and shut down any 2.4GHz networks at the Championship.
Presumably you could.
It may be worth noting however, that the FTC wireless system runs on the 2.4GHz band and last year they were using wireless sniffers to identify and shut down any 2.4GHz networks at the Championship.
That's interesting. Do you know what kind of wireless sniffer they used? Some can see the whole 2.4 Ghz frequency while others can only see 802.11 networks
DELurker
20-04-2013, 09:59
It may be worth noting however, that the FTC wireless system runs on the 2.4GHz band and last year they were using wireless sniffers to identify and shut down any 2.4GHz networks at the Championship.
Well, that eliminates almost all standard wireless protocols with the 2.4GHz and 5GHz note. However, 802.15.4 has ten channels down in the 700-900 MHz range that aren't prohibited... Now to just find a device that works in that range...
I found a potential problem with the links to update the data automatically in the 4 divisions in version 1. It has double links so it gets the data for the regional I copied the cell from and also the division. This explains why last year's spreadsheet had issues with links and I had to completely delete all the links and start again. If you don't know what I am talking about, don't worry about it.
If you plan to update the data automatically at the Championship by pressing Cntr-Shift-P and you have problem with the link, download version 2 and it has a better chance it will work. I will try out the links as soon as the links are up on the FIRST website. Excel is so complicated. I learn something new everyday.
JohnFogarty
22-04-2013, 17:47
They use Metageek Wi-Spy Pro. They can detect anything within the 2.4Ghz-5Ghz band. Bluetooth is actually a filter setting in the interference filters.
So my recommendation. If you think it could cause a problem. Don't do it.
Version 3 is out with the Championship data.
1) World ranking is updated with championship division qualifying matches
2) On the OPR and CCWM Results tab, championship division is not included because some of the options is to project it to that week. So if max OPR is used, it does not include data from this weekend. However it is very easy for you to change that yourselves.
3) This will be the last update this year unless there is an error.
OrangeCataclysm
28-04-2013, 14:34
I don't see the data for Curie winners when searched in Query.
Curie data was wrong on my spreadsheet. It was pointing to the wrong competition. I will fix it and publish again as soon as possible.
I transferred the wrong data into the database and messed up the whole thing. It took a while to regenerate everything. Version 4 is now posted. If you find any other problem, please let me know.
AllenGregoryIV
21-05-2013, 04:14
Ed, I was messing the spreadsheet and your macro for calculating OPR results wasn't allowing championship results as a Max event for a team even though they were listed on that page.
The macro was starting the range at M4 instead of I4.
It should read "Range("I4").Select", to allow for the 4 division OPRs to be included. I'm not sure if it was a choice or an error but I just found it odd.
Ed, I was messing the spreadsheet and your macro for calculating OPR results wasn't allowing championship results as a Max event for a team even though they were listed on that page.
The macro was starting the range at M4 instead of I4.
It should read "Range("I4").Select", to allow for the 4 division OPRs to be included. I'm not sure if it was a choice or an error but I just found it odd.
It was by choice for a number of reasons. That's how I did it the previous years also. However you are welcome to change the formula to fit your need.
vBulletin® v3.6.4, Copyright ©2000-2017, Jelsoft Enterprises Ltd.