paper: 4536 scouting database BETA

[Caleb Sykes]

Originally Posted by Caleb Sykes

Unless someone notices an error, I will not be releasing another update until after championships.

Update on updates.
By request, I have decided to release an update on Friday night with division preview tabs. I might also do match/ranking predictions using components, but no guarantees.

[Caleb Sykes]

I would just like to remind everyone that the changed tower strength at champs means that some of these metrics lose value if they are applied to the championship events. Specifically, teleop Tower Captured, eOPR1, and eOPR2 should not be directly applied to the championship event. I will create a new metric ceOPR (championship elimination OPR) in my Friday update which will be calculated in the same way eOPR1 is currently calculated, but modified to account for the change in tower strength.

[joeojazz]

Hi I was looking at your scouting info and didn't see my team 5712 in the championship preview. Also wanted to say how great this is and how useful this will be when checking out alliance partners and opponents.

[Caleb Sykes]

Originally Posted by joeojazz

Hi I was looking at your scouting info and didn't see my team 5712 in the championship preview.

Originally Posted by Caleb Sykes

Per request, I have also added a "championship preview" sheet which contains data on the best event (by OPR) of every team registered for championships as of 5PM CST on 4/18/2016. There is no new information on this sheet, all data are copied directly from the "world results" sheet. I am not planning to release updates if/when the championship team list changes, so you will have to update this sheet yourself.

Your team will be included in this tab in the Friday update.

[Caleb Sykes]

I have uploaded a new championships preview database. It contains an updated teams list in the "championship preview" sheet, as well as divisional preview sheets. All results from these 9 sheets are taken directly from the "world results" sheet.

Additionally, I have created a new metric ceOPR (championship eliminations OPR), which can be used to predict elimination scores at championships. This value is equivalent to (total points) + 2.5*(subtracted tower strength) + 2.5*(cross defense count). This value is only in the world results, championship preview, and divisional preview sheets, not in the previous events.

Let me know if you have any questions or concerns.

[jajabinx124]

Originally Posted by Caleb Sykes

I have uploaded a new championships preview database. It contains an updated teams list in the "championship preview" sheet, as well as divisional preview sheets. All results from these 9 sheets are taken directly from the "world results" sheet.

Additionally, I have created a new metric ceOPR (championship eliminations OPR), which can be used to predict elimination scores at championships. This value is equivalent to (total points) + 2.5*(subtracted tower strength) + 2.5*(cross defense count). This value is only in the world results, championship preview, and divisional preview sheets, not in the previous events.

Let me know if you have any questions or concerns.

Just wanna say thanks for making this scouting database and making a championship preview version of it! This makes pre-scouting much easier and these stats will be useful.

[Travis Hoffman]

Originally Posted by Caleb Sykes

I have uploaded a new championships preview database. It contains an updated teams list in the "championship preview" sheet, as well as divisional preview sheets. All results from these 9 sheets are taken directly from the "world results" sheet.

Additionally, I have created a new metric ceOPR (championship eliminations OPR), which can be used to predict elimination scores at championships. This value is equivalent to (total points) + 2.5*(subtracted tower strength) + 2.5*(cross defense count). This value is only in the world results, championship preview, and divisional preview sheets, not in the previous events.

Let me know if you have any questions or concerns.

You are quite the awesome person for doing this. Thank you kindly.

[mitchellzone]

Caleb, you're awesome for doing this, thanks!

One suggestion: On the championship preview tab, it would be great to have an additional column with what division each team is in. This would allow us to just ingest the data once into any analytics platform and very quickly group the teams into divisions by that field rather than having to load them each separately and join them.

Thanks again!

/mike

[Wayne TenBrink]

Thanks for the excellent work!

Please check the Carson preview tab. It appears to be blank.

[Caleb Sykes]

Originally Posted by Wayne TenBrink

Thanks for the excellent work!

Please check the Carson preview tab. It appears to be blank.

It displays fine for me. Do all of the other division preview sheets display properly for you?

[Wayne TenBrink]

Originally Posted by Caleb Sykes

It displays fine for me. Do all of the other division preview sheets display properly for you?

It's all there now. Third download was the charm. Thanks again.