iironiic's little experiment

**justin_ator** · 10-29-2011, 11:01 AM

Re: iironiic's little experiment

Lern 2 pleese crowds maang.

**One Winged Angel** · 10-29-2011, 11:03 AM

Re: iironiic's little experiment

Also I'm going to go ahead and laugh at the fact that I'm pretty sure I had some sort of influence over 20% being chosen hahahaha

**Enginuity** · 10-29-2011, 11:19 AM

Re: iironiic's little experiment

Oops, I implemented it incorrectly earlier (just implemented the scoring mechanism for Diff 12 for all difficulties). Score: 7.499.

To use this to calculate your score, you just have to replace my level ranks copied in with yours... [this shouldn't affect any of the formulas] this might take a little bit of effort unless you're familiar with excel...

I picked a random score (leonid's) and it came up with the same value as you did iironiic.

**Emithith** · 10-29-2011, 11:27 AM

Re: iironiic's little experiment

lol the way this formula works.. impressive.
Though, lol I would be like low 2 or something due to my lack of AAAs
Either way though, good job.

**iironiic** · 10-29-2011, 11:30 AM

Re: iironiic's little experiment

Originally posted by Enginuity

Oops, I implemented it incorrectly earlier (just implemented the scoring mechanism for Diff 12 for all difficulties). Score: 7.499.

To use this to calculate your score, you just have to replace my level ranks copied in with yours... [this shouldn't affect any of the formulas] this might take a little bit of effort unless you're familiar with excel...

I picked a random score (leonid's) and it came up with the same value as you did iironiic.

For some reason, I got 15.07611628 from your spreadsheet for my own level ranks haha. Am I doing something wrong?

**DossarLX ODI** · 10-29-2011, 11:32 AM

Re: iironiic's little experiment

Enginuity, this is all I see when I tried changing the levelranks to mine in excel:

Code:

Difficulty	# Songs	# Played	# AAA (well, rank = 1)	% AAA'd
1	5	#NAME?	#NAME?	#NAME?
2	27	#NAME?	#NAME?	#NAME?
3	31	#NAME?	#NAME?	#NAME?
4	44	#NAME?	#NAME?	#NAME?
5	53	#NAME?	#NAME?	#NAME?
6	70	#NAME?	#NAME?	#NAME?
7	100	#NAME?	#NAME?	#NAME?
8	143	#NAME?	#NAME?	#NAME?
9	167	#NAME?	#NAME?	#NAME?
10	173	#NAME?	#NAME?	#NAME?
11	88	#NAME?	#NAME?	#NAME?
12	50	#NAME?	#NAME?	#NAME?
13	2	#NAME?	#NAME?	#NAME?


Difficulty	Scores: 	AAA	-1	-2	-3	-4	-5	-6	-7	-8	-9	-10
1		#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?
1		#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?
1		#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?
1		#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?
2		#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?
2		#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?
2		#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?
2		#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?
3		#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?
3		#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?
3		#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?
3		#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?
4		#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?
4		#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?
4		#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?
4		#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?
5		#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?
5		#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?
5		#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?
5		#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?
6		#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?
6		#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?
6		#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?
6		#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?
7		#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?
7		#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?
7		#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?
7		#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?
8		#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?
8		#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?
8		#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?
8		#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?
9		#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?
9		#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?
9		#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?
9		#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?
10		#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?
10		#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?
10		#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?
10		#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?
11		#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?
11		#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?
11		#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?
11		#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?
12		#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?
12		#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?
12		#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?
12		#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?
13		#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?
13		#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?
13		#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?
13		#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?
												
Totals												
1		#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?
2		#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?
3		#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?
4		#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?
5		#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?
6		#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?
7		#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?
8		#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?
9		#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?
10		#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?
11		#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?
12		#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?
13		#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?
Weights: 		1	0.91	0.82	0.73	0.64	0.55	0.45	0.36	0.27	0.18	0.09
Weights2: 		1	0.83	0.67	0.5	0.33	0.17					
		1.25	0.92	0.83	0.75	0.67	0.58					
												
i	Weights * counts											
1		#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?
2		#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?
3		#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?
4		#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?
5		#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?
6		#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?
7		#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?
8		#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?
9		#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?
10		#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?
11		#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?
12		#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?
13		#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?	#NAME?

It also said the same thing with the levelranks you included originally

**Enginuity** · 10-29-2011, 11:38 AM

Re: iironiic's little experiment

Um, are you opening it on google docs? Google docs doesn't have the function I need

. (I was going to upload it in googledocs, but it doesn't recognize the function COUNTIFS)
I'll try your level ranks and see what happens, iironiic.

Edit: I know what I messed up on. It works fine for 12, but since you're 11, I messed up a couple entries... I'll repost. I didn't notice because I didn't have any 10, or 11 AAA's.

Edit 2: Is a value of 11.523 right for you? (iironiic)

Edit 3: Dossar, I think you need to use at least Excel 2007. Excel 2003 doesn't support the function... (nor does google docs).

**DossarLX ODI** · 10-29-2011, 11:46 AM

Re: iironiic's little experiment

I opened it up with OpenOffice (even though I said Excel because I can't tell the difference)

I'm assuming OpenOffice is missing the function then? If that is missing it and Google Docs, do you think there is another function that could work or is just that the only one you could think of

**iironiic** · 10-29-2011, 11:49 AM

Re: iironiic's little experiment

Originally posted by Enginuity

Um, are you opening it on google docs? Google docs doesn't have the function I need

. (I was going to upload it in googledocs, but it doesn't recognize the function COUNTIFS)
I'll try your level ranks and see what happens, iironiic.

Edit: I know what I messed up on. It works fine for 12, but since you're 11, I messed up a couple entries... I'll repost. I didn't notice because I didn't have any 10, or 11 AAA's.

Edit 2: Is a value of 11.523 right for you? (iironiic)

For myself, I got 11.6464 originally. If it helps, I have 60 FMO AAAs, 10 FMO BFs, 3 FMO booflags, 2 FMO double booflags, 3 FGO AAAs, 1 FGO booflag, and 1 FGO BF.

I'll try your program though just to see if I'm doing it right.

**Enginuity** · 10-29-2011, 11:50 AM

Re: iironiic's little experiment

There are various sources (from googling, mainly using SUMPRODUCT instead) that have workarounds for Excel 2003 (which I assume is more compatible with openoffice/googledocs. I'll see if I can get something up on google docs in a few hours...

I should probably get some schoolwork done instead of working on this :P.

@iironiic:
Sorry, I was dumb and did not fix all of the cells. Hm, somethings weird with the way I'm counting AAA's... hold on.

Edit 2: I know why. For some reason, your Distorted God score says 1410 averages instead of 1410 perfects...

**iironiic** · 10-29-2011, 12:00 PM

Re: iironiic's little experiment

Originally posted by Enginuity

There are various sources (from googling, mainly using SUMPRODUCT instead) that have workarounds for Excel 2003 (which I assume is more compatible with openoffice/googledocs. I'll see if I can get something up on google docs in a few hours...

I should probably get some schoolwork done instead of working on this :P.

@iironiic:
Sorry, I was dumb and did not fix all of the cells. Hm, somethings weird with the way I'm counting AAA's... hold on.

Edit 2: I know why. For some reason, your Distorted God score says 1410 averages instead of 1410 perfects...

Ohh... some scores are unrecorded so they are listed that way. It's a AAA though.

**Enginuity** · 10-29-2011, 12:04 PM

Re: iironiic's little experiment

Alright, I'll check rank 1 for AAA as well as no g and no boo's.
I do agree with your score now though. Silly mistakes

.

Attached Files

Score calculator.zip (82.7 KB, 6 views)

**iironiic** · 10-29-2011, 12:09 PM

Re: iironiic's little experiment

Originally posted by Enginuity

Alright, I'll check rank 1 for AAA as well as no g and no boo's.
I do agree with your score now though. Silly mistakes

.

Hahaha that's ok

Do you have the new spreadsheet so I can test the program for other people's level ranks?

**hi19hi19** · 10-29-2011, 12:12 PM

Re: iironiic's little experiment

Originally posted by hi19hi19

in b4 similar version of Patashu's TS difficulty algorithm

Damn I called that shit like a pr0.

As much as FFR and TS pretend to hate each other, you should talk to Patashu to see how he implemented his algorithm. As far as I can tell they work similarly.

**Enginuity** · 10-29-2011, 12:12 PM

Re: iironiic's little experiment

It's not going to work if they have unrecorded scores anywhere except for an unrecorded AAA. I guess you can manually edit the cells (but you'd need to figure out what I'm doing; didn't document it very much).

The attachment is in my previous post (I edited). Hopefully it works properly, let me know if anything isn't working.

iironiic's little experiment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment