2015 OPR After Week Six Events
 

The OPR/CCWM numbers after six weeks of events have been posted, please see

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

Re: 2015 OPR After Week Six Events
 

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.

Re: 2015 OPR After Week Six Events
 

I have not used the latest version of Excel. The newest version I have is 2010.

Re: 2015 OPR After Week Six Events
 

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.

Re: 2015 OPR After Week Six Events
 

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?

Re: 2015 OPR After Week Six Events
 

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.

Re: 2015 OPR After Week Six Events
 

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.