Overland Park Open 2017

[JustinTimeCuber]

ok just made it better
https://pastebin.com/07MPuiKh

 

[Tycubing]

Man, I should rename this thread now to "Competition Simulation?"

 

[biscuit]

Man, I should rename this thread now to "Competition Simulation?"

Go for it. Though it's not quite there yet

 

[JustinTimeCuber]

I'll make a new thread for the software once I get it finished, although I need to do more research on SQL and accessing the database so that it isn't so horrible to set up.

 

[biscuit]

I'll make a new thread for the software once I get it finished, although I need to do more research on SQL and accessing the database so that it isn't so horrible to set up.

I can write querys for you if you need. Just tell me what you need and the applicable variables.

 

[JustinTimeCuber]

I'm looking for a way to input an ID and output up to 3 of their latest competitions, excluding DNFs, in this format. Order does not matter for the times.

DaysSinceCompetition;t1,t2,t3,t4...,tn
DaysSinceCompetition;t1,t2,t3,t4...,tn
DaysSinceCompetition;t1,t2,t3,t4...,tn

Days since competition would be measured from April 29, not today.

My file is
98;10.04,12.53,11.17,10.07,12.02,13.07,11.19,8.75,8.74,11.87,11.78,9.80,9.76,11.97,8.70,12.81,9.07,10.58,10.60,10.43 //MCC Alpha
203;10.74,10.78,11.42,9.75,13.12,11.32,13.73,9.56,11.03,10.51,10.32,11.39,10.95,12.44,12.60 //Dixon
274;13.93,12.45,11.71,11.64,10.18,9.98,11.76,12.18,12.16 //US Nationals

I did get a DNF at nationals but it is left out.

Speaking of my file, I created a function that I'll be using a lot to get a random time according to my specifications. It didn't work at first, then I changed an if to an else if, and then it worked, and I still don't know why. I simulated an Ao100 and it was pretty realistic (I'm slightly faster now but how could it know!) The Ao100 was 11.11.

e: Ran two more ao100s, and got 11.07 and 11.27. The Ao300 is 11.15. This looks promising, as there is about the correct amount of variance.

 

[JustinTimeCuber]

Based on ao300, expected results for the test group
2009OLSO01 (Christopher Olson): 9.12
2013BARK01 (Justin Barker): 11.15
2015WEBS01 (Garrett Webster): 13.05
2015SPEC01 (Tyler Specht): 14.34
2015BUCK03 (Asher Buckner): 25.19

 

[Tycubing]

2015SPEC01 (Tyler Specht): 14.34

Man, I didn't know my official results were THAT bad

 

[JustinTimeCuber]

Man, I didn't know my official results were THAT bad

A lot of people's ao300s were worse than their mean of 100000 averages of 5 (mo10^5ao5) that the program uses. (basically it does 100k trials and averages them). Here are those results:

2013BARK01 (Justin Barker) - Good: 99896 Bad: 104 Average: 11.00
2015WEBS01 (Garrett Webster) - Good: 99911 Bad: 89 Average: 13.06
2015BUCK03 (Asher Buckner) - Good: 99906 Bad: 94 Average: 25.09
2015SPEC01 (Tyler Specht) - Good: 99900 Bad: 100 Average: 13.93
2009OLSO01 (Christopher Olson) - Good: 99908 Bad: 92 Average: 8.93

In no particular order though, I have to work on a sorting algorithm before I can do the fun stuff with average ranking and second round/final.

 

[Tycubing]

Competitor limit has been reached. You should do your pick em now, Justin.

 

[JustinTimeCuber]

Competitor limit has been reached. You should do your pick em now, Justin.

Yeah but I'm tired...

I'll have it up by tonight.

 

[JustinTimeCuber]

Pick 'Em Link
$10 thecubicle.us gift card for whoever wins because I'm a generous soul

If I win then I just force myself to have at least $10 until I buy something from there

 

[Tycubing]

List of Kilominx competitors

David Woner
Garrett Webster
Tyler Specht
Kristen Wiley
Justin Barker
Julian Chavez
Elliot Miller
Jake Gustafson
Dylan Fritz

 

[JustinTimeCuber]

List of Kilominx competitors

David Woner
Garrett Webster
Tyler Specht
Kristen Wiley
Justin Barker
Julian Chavez
Elliot Miller
Jake Gustafson
Dylan Fritz

so at least I didn't pick anyone who wasn't competing

 

[Draranor]

So, I'm doing my pick 'em entry, and I got to the square-1 section, but I have no idea what to put for it cause I don't know who even MIGHT be competing. So I just put DNF for all of them lol

 

[JustinTimeCuber]

So, I'm doing my pick 'em entry, and I got to the square-1 section, but I have no idea what to put for it cause I don't know who even MIGHT be competing. So I just put DNF for all of them lol

probably a bad idea, because unless everyone DNFs sq1 or it doesn't happen you will get penalized (there's no penalty in leaving a blank answer). If you want you can change yours, just PM me.

 

[Draranor]

probably a bad idea, because unless everyone DNFs sq1 or it doesn't happen you will get penalized (there's no penalty in leaving a blank answer). If you want you can change yours, just PM me.

I'll probably pm you in a little bit; I wasn't sure if I should've left them blank or not, because I forgot which was better to do. Also I think I made a typo in one of my answers

 

[JustinTimeCuber]

4 responses so far.

 

[Tycubing]

4 responses so far.

Yay. My chances are 1/4

 

[JustinTimeCuber]

Yay. My chances are 1/5

ftfy, someone else responded