I'm With Stupid (IWS) - historical spreadsheet

[MIJB#19]

I decided to make sure all the IWS results are in one spreadsheet.

At this point (after 40 competitions) I've tried to (and have been able to) find all the (complete) results and all the questions (most of them with all given awsners as well.)

I haven't taken the time to reformat most of the copy and pasted info, except for the host name and I've reformatted some of the info of IWS 1 to 10.

The spreadsheet is currently located at my website at:
http://matthijs.netherlands.com/iwshistory.zip

So far the zip file is smaller then 100kb and thus can be uploaded, though once it reaches over 100kb, I'll have to solve that problem some way...

[Alf]

Did you compiled average ranking (in precentage) per participant or do you award yourself with Mr Irrelevant IWS

[MIJB#19]

So far no overall rankings.
I just added the #38 score, which were missing from the copy I originally uploaded.

I'd be interested in creating an overall leaderboard, which I think will not take too much time...

For those interested, I compiled my own overall record, which is amazingly better then I always remembered (and signatured) it to be:


compet partic my rk bottom add info
IWS#1 39 21 19 ...
IWS#2 36 32 5 ...
IWS#3 45 37 9 ...
IWS#4 44 42 3 ...
IWS#5 48 20 29 ...
IWS#6 52 44 9 ...
IWS#7 47 47 1 ...
IWS#8 55 44 11 tied with critch
IWS#9 58 53 4 ...
IWS#10 52 39 14 ...
IWS#11 41 41 1 ...
IWS#12 40 40 1 ...
IWS#13 30 27 4 ...
IWS#14 22 15 8 ...
IWS#15 18 18 1 ...
IWS#16 22 22 1 ...
IWS#17 14 3 12 ...
IWS#18 18 16 3 ...
IWS#19 17 4 14 ...
IWS#20 10 n/a n/a I hosted this IWS
IWS#21 18 17 1 tied with Archer219
IWS#22 19 19 1 ...
IWS#23 21 8 14 ...
IWS#24 20 16 3 tied with Soxwin and BishopMVP; scoring system SUM in stead of PRODUCT
IWS#25 23 n/a n/a I did not participate
IWS#26 22 n/a n/a I did not participate
IWS#27 23 21 3 scoring system SUM in stead of PRODUCT
IWS#28 21 11 11 ...
IWS#29 30 28 3 ...
IWS#30 19 10 10 ...
IWS#31 33 33 1 ...
IWS#32 21 n/a n/a I did not participate
IWS#33 23 n/a n/a I did not participate
IWS#34 24 23 2 ...
IWS#35 27 27 1 ...
IWS#36 29 22 8 ...
IWS#37 25 23 3 ...
IWS#38 31 29 3 ...
IWS#39 22 20 3 ...
IWS#40 19 17 3 ...


[cuervo72]

Wow, no small undertaking. Good job MIJB.

[sterlingice]

Trying to cement your legacy here?

SI

[MIJB#19]

Hey, one can say he's the worst player ever, but there has to be some proof too, no? Besides, what's wrong at being the worst player in a contest to think "Stupid"?
That in mind, it seems impossible to finish at the bottom 3 for 19 out of all 40 comeptitions, especially since I joined "just" 35.

Seriously, are there any ideas for a scoring system to make an alltime scoring list?
What was the system used at the old site, Wade Moore did that one, right?

Sadly I have no access to the data from school (I compiled an all time rankings list yesterday). I do know that we have some people around who have won several competitions.
Alf and I are #2 and #1 on all time participation with 33 and 35 respectively.

[MIJB#19]

Al right, no input on a ranking system, I'll do one myself then.

So what did I do?
I put the rankings of everyone in every competition in a spreadsheet.
After that I calculated a percentage score being 100% for winners and being the (particpants-ranking+1)/participants for others.
So, taking my ranking of my last participation as an example:
17th place amongst 19 participants =>
(19-17+1)/19 = (3)/19 = 15.789%
Then I summed up all scores for all 40 events.
Hosts get no points. Instead, they receive a bonus multiplier, based on the total number of events devided by the total # of events minus number of hosts.
So taking my single participation as an example:
I have around 836 points and 1 host in 40 events being played so far (with rounded numbers) =>
836 * (40/(40-1)) = 836 * (40/39) = 836 * 1.03 = 857

Side note: this ranking system favours people with many participations, as it does favour participation in IWSs with a lot of participants.

Rankings
rank, participant, # of participations, # of points, # of host, # of wins

1	quiksand	30	2586	5	5
2	maple leafs	29	1760	1	1
3	swaggs	28	1588	1	2
4	albionmoonlight	25	1502	1	1
5	panerd	30	1427	1	1
6	msf518	23	1297	0	4
7	digamma	19	1290	1	1
8	bbor	19	1153	2	2
9	alf	33	1149	1	0
10	tro	14	1106	1	3
11	samdari	14	1061	0	1
12	primelord	14	1014	2	1
13	jeeberd	14	953	0	0
14	subby	14	941	0	0
15	ahbrady	13	937	0	1
16	dukerulesmab	14	906	0	0
17	masked	11	899	3	4
18	gold101	15	896	0	0
19	scottvib	15	871	0	1
20	mijb#19	35	858	1	0
21	mustang	14	851	0	0
22	marmel	16	836	0	1
23	draftdodger	22	829	0	0
24	buccaneer	13	813	0	0
25	mrskippy	17	759	0	0
26	tredwel	9	758	2	3
27	cuervo72	11	744	3	2
28	hammer755	12	734	0	1
29	anxiety	16	728	0	0
30	henry296	10	716	2	1
31	rpi-fan	14	716	1	1
32	shorty3281	20	712	0	0
33	sterlingice	9	676	2	3
34	wade moore	12	664	0	0
35	raven hawk	10	632	0	0
36	archer219	11	629	1	1
37	render	14	604	0	1
38	kcchief19	11	590	0	0
39	easy mac	11	583	0	0
40	wes huett	11	580	0	0
41	revrew	10	562	0	0
42	airhog	13	552	1	1
43	mattjones4heisman	8	541	0	0
44	bishopmvp	13	538	1	1
45	critch	16	529	0	0
46	kwhit	8	525	0	0
47	yacovfb	13	511	1	0
48	troyf	8	509	0	0
49	splitpersonality1	8	495	1	1
50	tasan	10	482	0	0
51	agpete	7	481	0	0
52	sublime	11	479	1	1
53	radii	9	477	0	0
54	bearcat729	7	465	0	0
55	eaglefan	12	459	0	0
56	3ric	14	456	0	0
57	wsucougar	8	441	0	0
58	bsak16	9	440	1	2
59	sooner333	8	432	0	0
60	vince	7	419	1	1
61	desert dweller	6	407	0	2
62	pyser	6	392	0	0
63	analbumcover	6	392	0	0
64	neuqua	6	382	0	1
65	oykib	5	378	0	0
66	issiddiqui	7	377	0	0
67	logan	8	370	0	0
68	tucker342	9	358	0	0
69	nothingman	6	353	0	1
70	centralmasshokie	8	341	0	0
71	franklinnoble	4	304	0	0
72	butter_of_69	7	303	0	0
73	samifan24	5	295	0	0
74	hornedfrog purple	8	293	0	1
75	syrinx	6	291	0	0
76	coltcrazy	5	287	0	0
77	senator	6	278	0	0
78	blade	5	276	1	1
79	illinifan999	8	269	0	0
80	joe canadian	5	268	1	1
81	bryce	3	267	0	1
82	wolfpack	5	261	0	0
83	hahnkim	4	257	0	0
84	qwikshot	5	255	0	1
85	sabotai	6	252	0	0
86	robbiedobbs	3	240	0	1
87	barkeep49	4	238	0	0
88	mrbug708	7	233	0	0
89	scooper	6	231	0	0
90	daimyo	4	231	0	0
91	dolfin	3	227	0	0
92	wasabiak	5	215	0	0
93	rainraven	5	210	0	0
94	dataking	4	204	0	0
95	saintanselm	4	202	0	0
96	aggie2002	4	196	0	0
97	vpi97	3	190	0	0
98	ardent enthusiast	4	190	0	1
99	heavyreign	2	172	0	1
100	john galt	3	167	0	0
101	rich1033	4	158	0	0
102	jim lynch	3	151	0	1
103	ryan s	4	145	0	0
104	skydog	2	142	0	0
105	katon	3	140	0	0
106	breizhmanu	4	137	0	0
107	pwatts14	2	134	0	0
108	golden eagle	3	123	0	0
109	vexroid	6	118	0	0
110	acstrider	2	116	0	0
111	b & b	2	115	0	0
112	bigjdotcome01	2	115	0	0
113	vtbub	2	112	0	0
114	scarecrow	3	105	0	0
115	jcclark02	1	95	0	0
116	mikevic	3	93	0	0
117	chiken22	2	90	0	0
118	conrhuskerly	3	90	0	0
119	kingnebwsu	1	88	0	0
120	fidatelo	1	84	0	0
121	markprior22	2	84	0	0
122	frozenrope	1	82	0	0
123	racer	1	81	0	0
124	johnywnstn	1	80	0	0
125	r	1	77	0	0
126	sjshaw	1	75	0	0
127	anrhydeddu	1	73	0	0
128	aylmar	2	70	0	0
129	dacman	1	70	0	0
130	kodos	1	68	0	0
131	wheels	1	67	0	0
132	smcindoe	1	67	0	0
133	sachmo71	3	67	0	0
134	dawgfan1980	2	63	0	0
135	passacaglia	1	61	0	0
136	hornsmaniac	1	56	0	0
137	rembrandt	3	55	0	0
138	mr. Simperless	2	54	0	0
139	mizzourah	3	54	0	0
140	johninmiddlega	2	50	0	0
141	the afoci	1	43	0	0
142	silver owl	1	36	0	0
142	raven	1	36	0	0
144	cringer	1	35	0	0
145	marc vaughn	1	35	0	0
146	stkellyy52	1	32	0	0
147	dutch	1	29	0	0
148	path12	1	28	0	0
149	rufusjonz	1	26	0	0
150	tauter	1	26	0	0
151	soxwin	1	25	0	0
152	eagleeye11	1	20	0	0
153	aesyrqwe	1	19	0	0
154	grdawg	1	17	0	0
155	fantasybandit	1	17	0	0
156	cubsfan915	1	15	0	0
157	pumpy tudors	1	15	0	0
158	axxon	1	15	0	0
159	livnlegend	1	13	0	0
160	sony	1	11	0	0
161	bonegavel	1	10	0	0
162	mrs. Coltcrazy	1	6	0	0
163	jasontobiasiv	1	5	0	0
164	jv10	1	2	0	0
165	craptacular	1	2	0	0

[MIJB#19]

For the excel sheets with rankings, you can find it (unzipped) here:
All Time IWS Rankings

[tucker342]

impressive! 68th place, go me!

[Maple Leafs]

Wow... #2? Behind only the master himself?

I have the numbers, and yet I'm not sure I really belong in the elite. I'm like the Eddie Murray of IWS.

[Butter]

Wouldn't the rankings be more accurate if they included an average points per participation stat?

Not to be an ass, because that work looked hard, but one more column would complete them, I think.

[MIJB#19]

avg can be arranged, it was in there originally actually.

Average percentages based on the calculated # of points (no bonuses for hosts).

rank, "name", # of participations, # of points without bonus, average (rounded scores)

1	jcclark02	1	95	95
2	bryce	3	267	89
3	kingnebwsu	1	88	88
4	heavyreign	2	172	86
5	fidatelo	1	84	84
6	frozenrope	1	82	82
7	racer	1	81	81
8	robbiedobbs	3	240	80
9	tredwel	9	720	80
10	johnywnstn	1	80	80
11	tro	14	1078	77
12	r	1	77	77
13	franklinnoble	4	304	76
14	samdari	14	1061	76
15	dolfin	3	227	76
16	oykib	5	378	76
17	masked	11	832	76
18	quiksand	30	2263	75
19	sjshaw	1	75	75
20	anrhydeddu	1	73	73
21	ahbrady	13	937	72
22	sterlingice	9	642	71
23	skydog	2	142	71
24	dacman	1	70	70
25	primelord	14	963	69
26	agpete	7	481	69
27	kodos	1	68	68
28	jeeberd	14	953	68
29	henry296	10	680	68
30	desert dweller	6	407	68
31	mattjones4heisman	8	541	68
32	wheels	1	67	67
33	subby	14	941	67
34	pwatts14	2	134	67
35	smcindoe	1	67	67
36	bearcat729	7	465	66
37	digamma	19	1258	66
38	kwhit	8	525	66
39	pyser	6	392	65
40	analbumcover	6	392	65
41	dukerulesmab	14	906	65
42	hahnkim	4	257	64
43	neuqua	6	382	64
44	troyf	8	509	64
45	vpi97	3	190	63
46	raven hawk	10	632	63
47	buccaneer	13	813	63
48	cuervo72	11	688	63
49	hammer755	12	734	61
50	passacaglia	1	61	61
51	mustang	14	851	61
52	splitpersonality1	8	482	60
53	gold101	15	896	60
54	barkeep49	4	238	60
55	maple leafs	29	1716	59
56	samifan24	5	295	59
57	nothingman	6	353	59
58	albionmoonlight	25	1464	59
59	vince	7	408	58
60	acstrider	2	116	58
61	scottvib	15	871	58
62	daimyo	4	231	58
63	b & b	2	115	58
64	bigjdotcome01	2	115	58
65	bbor	19	1095	58
66	coltcrazy	5	287	57
67	msf518	23	1297	56
68	revrew	10	562	56
69	hornsmaniac	1	56	56
70	john galt	3	167	56
71	vtbub	2	112	56
72	archer219	11	613	56
73	wade moore	12	664	55
74	swaggs	28	1549	55
75	wsucougar	8	441	55
76	sooner333	8	432	54
77	issiddiqui	7	377	54
78	blade	5	269	54
79	kcchief19	11	590	54
80	easy mac	11	583	53
81	radii	9	477	53
82	wes huett	11	580	53
83	marmel	16	836	52
84	wolfpack	5	261	52
85	joe canadian	5	261	52
86	qwikshot	5	255	51
87	dataking	4	204	51
88	saintanselm	4	202	50
89	jim lynch	3	151	50
90	rpi-fan	14	698	50
91	aggie2002	4	196	49
92	syrinx	6	291	48
93	tasan	10	482	48
94	bsak16	9	429	48
95	ardent enthusiast	4	190	48
96	katon	3	140	47
97	panerd	30	1391	46
98	senator	6	278	46
99	logan	8	370	46
100	anxiety	16	728	45
101	chiken22	2	90	45
102	mrskippy	17	759	45
103	butter_of_69	7	303	43
104	render	14	604	43
105	wasabiak	5	215	43
106	the afoci	1	43	43
107	centralmasshokie	8	341	43
108	sublime	11	468	43
109	markprior22	2	84	42
110	rainraven	5	210	42
111	sabotai	6	252	42
112	airhog	13	538	41
113	golden eagle	3	123	41
114	bishopmvp	13	525	40
115	tucker342	9	358	40
116	rich1033	4	158	39
117	scooper	6	231	39
118	yacovfb	13	498	38
119	eaglefan	12	459	38
120	draftdodger	22	829	38
121	hornedfrog purple	8	293	37
122	silver owl	1	36	36
122	raven	1	36	36
124	ryan s	4	145	36
125	shorty3281	20	712	36
126	cringer	1	35	35
127	scarecrow	3	105	35
128	aylmar	2	70	35
129	marc vaughn	1	35	35
130	breizhmanu	4	137	34
131	alf	33	1120	34
132	illinifan999	8	269	34
133	mrbug708	7	233	33
134	critch	16	529	33
135	3ric	14	456	33
136	stkellyy52	1	32	32
137	dawgfan1980	2	63	32
138	mikevic	3	93	31
139	conrhuskerly	3	90	30
140	dutch	1	29	29
141	path12	1	28	28
142	mr. Simperless	2	54	27
143	rufusjonz	1	26	26
144	tauter	1	26	26
145	johninmiddlega	2	50	25
146	soxwin	1	25	25
147	mijb#19	35	836	24
148	sachmo71	3	67	22
149	eagleeye11	1	20	20
150	vexroid	6	118	20
151	aesyrqwe	1	19	19
152	rembrandt	3	55	18
153	mizzourah	3	54	18
154	grdawg	1	17	17
155	fantasybandit	1	17	17
156	cubsfan915	1	15	15
157	pumpy tudors	1	15	15
158	axxon	1	15	15
159	livnlegend	1	13	13
160	sony	1	11	11
161	bonegavel	1	10	10
162	mrs. Coltcrazy	1	6	6
163	jasontobiasiv	1	5	5
164	jv10	1	2	2
165	craptacular	1	2	2

Now I know why I didn't want to rank this way, it favours people with only 1 (and succesful) participation.

[MIJB#19]

Still, I think neither of the ranking systems is good enough.
I mean, the first makes me look good at #20, while I'm obviously not.
The second ranking has succesful one-day-flies a top, though succesfull others like TredWel, Masked and TRO show up where they belong.

Any ideas?
I mean, I have the data, all it needs is a formula that can be easlily copy'n'pasted 164 times.

[cuervo72]

Somewhere I think you should work in how one did compared to the winner....so if the winner had 100000 points and you had 50000, you score .5 (winner of course scores 1). Maybe then multiply that by the number of participants ('n') to get your score for that IWS. That way, those IWS's with more participants are weighted (as they should be), but relative success/failure is a little more exact as compared with calculating solely based on rank.

The alternative to above would be to score in relation not to the winner, but to the maximum number of points possible. Actually, this might be better, because you can win and still have a few clunkers for answers, but that might be offset by IWS's with more participants. That way if you scored 100% in an "easy" IWS (smaller 'n'), it may be equal to a 50% win in a "hard" IWS (large 'n').

[panerd]

I like the rankings where I am #5 and not the one where I am #97. The first ones rightfully award those who particpate regularly.

[JeeberD]

#13 overall, not too shabby. I always seem to be in the top three or four but never win the damn thing. Hopefully that will change someday...