Ohio 2017

[jgrischow1]

Central Ohio

B state qualifiers:

1. New Albany A
2. Grandview Heights
3. Granville
(New Albany B)
4. Canal Winchester A
5. Thomas Ewing

C state qualifiers:

1. New Albany A
(New Albany B)
2. Olentangy Orange A
3. Lancaster
4. Upper Arlington A
5. Columbus Academy
6. Worthington Kilbourne A

[lumosityfan]

Oh for anyone following along on the livestream I made a medal table which you guys can help with as well: https://docs.google.com/spreadsheets/d/ ... sp=sharing Enjoy!

[RoboMarth]

Spent entirely too much time on this results tracker / predictor:

https://docs.google.com/spreadsheets/d/ ... sp=sharing

[Magikarpmaster629]

Spent entirely too much time on this results tracker / predictor:

https://docs.google.com/spreadsheets/d/ ... sp=sharing

Looks really cool! So when you put in the event scores it calculates which teams are predicted to place where? Do you have source code we could see?

[RoboMarth]

Spent entirely too much time on this results tracker / predictor:

https://docs.google.com/spreadsheets/d/ ... sp=sharing

Looks really cool! So when you put in the event scores it calculates which teams are predicted to place where? Do you have source code we could see?

Yep, it just calculates a predicted score based on the placings and an assumed average unranked placing. All Excel formulas / conditional formatting, I think you can just download the file as an Excel spreadsheet to see them.

[Unome]

Spent entirely too much time on this results tracker / predictor:

https://docs.google.com/spreadsheets/d/ ... sp=sharing

Looks really cool! So when you put in the event scores it calculates which teams are predicted to place where? Do you have source code we could see?

Yep, it just calculates a predicted score based on the placings and an assumed average unranked placing. All Excel formulas / conditional formatting, I think you can just download the file as an Excel spreadsheet to see them.

Pretty cool. The color scheme looks nice, I'll have to try that someday.

[Magikarpmaster629]

Looks really cool! So when you put in the event scores it calculates which teams are predicted to place where? Do you have source code we could see?

Yep, it just calculates a predicted score based on the placings and an assumed average unranked placing. All Excel formulas / conditional formatting, I think you can just download the file as an Excel spreadsheet to see them.

Pretty cool. The color scheme looks nice, I'll have to try that someday.

So I plugged in the scores for Missouri 2016 and it predicted the placements of the top 7 teams precisely (although predicted team scores were pretty far off). Nice work

[John Richardsim]

I've spent the past few hours putting this spreadsheet for my predictions for Ohio. I used both invite and regional results from this year, and for the top 10 teams of that, I brought in competition results from the past five years.

Predictions

I was pretty surprised with how it turned out. What do you all think?

[4Head]

I've spent the past few hours putting this spreadsheet for my predictions for Ohio. I used both invite and regional results from this year, and for the top 10 teams of that, I brought in competition results from the past five years.

Predictions

I was pretty surprised with how it turned out. What do you all think?

I got a fatal error when I opened the link.

[John Richardsim]

I've spent the past few hours putting this spreadsheet for my predictions for Ohio. I used both invite and regional results from this year, and for the top 10 teams of that, I brought in competition results from the past five years.

Predictions

I was pretty surprised with how it turned out. What do you all think?

I got a fatal error when I opened the link.

Whoops. Should be fixed now.