Log in

View Full Version : 2015 OPR After Week Six Events

Ed Law
05-04-2015, 01:38
The OPR/CCWM numbers after six weeks of events have been posted, please see

http://www.chiefdelphi.com/media/papers/2174
dcarr
05-04-2015, 01:46
The OPR/CCWM numbers after six weeks of events have been posted, please see

http://www.chiefdelphi.com/media/papers/2174

Thanks once again! Question - are your macros generally compatible with versions of Excel for OS X? I'm experiencing some crashes and unpredictable behavior, but I'm not sure if this is a known issue, or if these are bugs with the Excel 2016 Preview that I'm using.

Edit: confirmed this is a problem with the Excel 2016 Preview. Works fine in Excel 2011.
Ed Law
05-04-2015, 23:41
I have not used the latest version of Excel. The newest version I have is 2010.
Michael Hill
06-04-2015, 09:25
Just wanted to note a correction. 3138 was not selected for elims at Queen City, but was brought in as a backup before the first match. We were eliminated in the quarterfinals.
Ed Law
06-04-2015, 09:42
Just wanted to note a correction. 3138 was not selected for elims at Queen City, but was brought in as a backup before the first match. We were eliminated in the quarterfinals.

Thanks for the information. I am not sure where to make the correction. Can you help me by pointing out where it is showing in error?
Michael Hill
06-04-2015, 09:50
I'm not exactly sure how you're storing information. It does show we finished as quarterfinalists. I'm not sure if you say "Did not reach eliminations" for "Alliance 2" only if we didn't pick or weren't selected rather than including information about backup robots. I thought in previous years' databases, those were kept track of.
Ed Law
06-04-2015, 10:13
I'm not exactly sure how you're storing information. It does show we finished as quarterfinalists. I'm not sure if you say "Did not reach eliminations" for "Alliance 2" only if we didn't pick or weren't selected rather than including information about backup robots. I thought in previous years' databases, those were kept track of.

In the Alliances Field, "Did not reach eliminations" mean was not drafted. I can change it to read "Was not drafted" to make it more clear next time.

I think you are right. Before FIRST started publishing the alliance selection order, the spreadsheet used to deduce the selection order whenever possible and include information about backup teams. I have to check the program to see why it is not showing that any more. I think because I already know the selection order, I completely bypassed that logic so I was not checking for backup teams anymore. You can tell a team is a backup team when they were not initially drafted but they finish as a quarterfinalist, semifinalist, finalist or winner.