Nerd sheets here! (DT stats)

[Nipple Nibbler]

~update for week 7~
completed stats for week 7

kpm is a useless stat which you basically just admitted that you only added to your stat page to make yourself rank higher.

beam Point proven you're an idiot that has nothing better to do with your time but troll. Really sad that your life is so bad you need to try to make stuff up about someone else on the internet to make yourself feel better. You really should hold yourself to a higher standard if you're going to continue to run events. Never did I admit to putting any stats in just to make myself rank higher. Look at my terr rating it's complete garbage and 2nd lowest currently.

[beam]

In dueling leagues statistics such as wins, staying alive (not eliminated), and number of players knocked out are quite valuable. High points for first and second knockouts.

Average kills and kill to death are also quite telling of how useful a player is to the game. Negative points for getting eliminated early.

these are all absolutely fine metrics to use unlike kpm dpm or any other per minute stat in wb/jav which are completely useless and serve the opposite goal of what rageritual is supposedly intending by rewarding 50-20 blowout wins. my stats this season are obviously bad my wb team is 4-10 so any algorithm you use will put saiyan way ahead of me when he's 13-1 and having a historically great season in terms of kda so I guess you were trying to insult me by saying that but again just like your per minute stats you come off as really dumb

edit: realized this post looks kind of weird quoting turban and responding to rageritual

[Turban]

In dueling leagues statistics such as wins, staying alive (not eliminated), and number of players knocked out are quite valuable. High points for first and second knockouts.

Average kills and kill to death are also quite telling of how useful a player is to the game. Negative points for getting eliminated early.

[beam]

You spend more time in this game trolling than anything else which is why I tend to ignore most of your feedback regarding the sheets. But I can give you an example on how it's not useless. Let's look at the 10* Warbirds for DT-D. Mythril is in 2/6th for 10* players. He only has 6 rounds played because he was a free agent. Without time into the equation he would probably be last place for the 10* players.

Let's look at the 9.5s where you sit. Saiyan has way overperformed you and the rating shows it. Lockdown has very simular stats as you and you have ratings that match that. Comparing you with Lockdown I probably have to lower win points to maybe 5 instead of 7 they might be weighed a little too heavy but that was intended since, well winning in the end is what matters.

Some of us actually have lives and struggle to make every single game. If I wasn't my own boss I know I wouldn't be able to make every Sunday. Some are also free agents so putting time into the equation helps balance this out.

yes so you can use kda for people with lower kill and death totals kpm is a useless stat which you basically just admitted that you only added to your stat page to make yourself rank higher. it's just extremely hard for me to take you or your stat sheet seriously when you clearly have absolutely no understanding of how wb/jav works and refuse to take criticism on things that you are obviously wrong about

[Nipple Nibbler]

exactly why every per minute stat is not just useless but actually counterproductive when evaluating performance in wb/jav

You spend more time in this game trolling than anything else which is why I tend to ignore most of your feedback regarding the sheets. But I can give you an example on how it's not useless. Let's look at the 10* Warbirds for DT-D. Mythril is in 2/6th for 10* players. He only has 6 rounds played because he was a free agent. Without time into the equation he would probably be last place for the 10* players.

Let's look at the 9.5s where you sit. Saiyan has way overperformed you and the rating shows it. Lockdown has very simular stats as you and you have ratings that match that. Comparing you with Lockdown I probably have to lower win points to maybe 5 instead of 7 they might be weighed a little too heavy but that was intended since, well winning in the end is what matters.

Some of us actually have lives and struggle to make every single game. If I wasn't my own boss I know I wouldn't be able to make every Sunday. Some are also free agents so putting time into the equation helps balance this out.

[beam]

DT-D
TEAM	RP	TP	W	L	W%	K	D	K-D	K/D	KPM	DPM	LW
demonic	14	2:57:47	13	1	93	695	547	148	1.27	3.91	3.08	1
haze	14	3:13:16	10	4	71	653	622	31	1.05	3.38	3.22	4
malevolent	14	3:13:50	9	5	64	647	594	53	1.09	3.34	3.06	3
mastirs	14	3:38:22	9	5	64	644	604	40	1.07	2.95	2.77	2
terrorist	14	3:03:31	8	6	57	616	592	24	1.04	3.36	3.23	5
blast	14	3:14:47	5	9	36	611	648	-37	0.94	3.14	3.33	6
power	14	3:47:17	4	10	29	623	648	-25	0.96	2.74	2.85	9
slay	14	3:29:58	4	10	29	613	666	-53	0.92	2.92	3.17	8
spelunky	14	3:10:20	4	10	29	596	653	-57	0.91	3.13	3.43	7
patouf	14	3:01:44	4	10	29	541	678	-137	0.80	2.98	3.73	10

Thought we had loads of close games that went to the wire, most time played and we have more kills than Terrorist who have twice the amount of wins as we do.

exactly why every per minute stat is not just useless but actually counterproductive when evaluating performance in wb/jav

[Kassius]

DT-D
TEAM	RP	TP	W	L	W%	K	D	K-D	K/D	KPM	DPM	LW
demonic	14	2:57:47	13	1	93	695	547	148	1.27	3.91	3.08	1
haze	14	3:13:16	10	4	71	653	622	31	1.05	3.38	3.22	4
malevolent	14	3:13:50	9	5	64	647	594	53	1.09	3.34	3.06	3
mastirs	14	3:38:22	9	5	64	644	604	40	1.07	2.95	2.77	2
terrorist	14	3:03:31	8	6	57	616	592	24	1.04	3.36	3.23	5
blast	14	3:14:47	5	9	36	611	648	-37	0.94	3.14	3.33	6
power	14	3:47:17	4	10	29	623	648	-25	0.96	2.74	2.85	9
slay	14	3:29:58	4	10	29	613	666	-53	0.92	2.92	3.17	8
spelunky	14	3:10:20	4	10	29	596	653	-57	0.91	3.13	3.43	7
patouf	14	3:01:44	4	10	29	541	678	-137	0.80	2.98	3.73	10

Thought we had loads of close games that went to the wire, most time played and we have more kills than Terrorist who have twice the amount of wins as we do.

[beam]

~update for week 7~
DT-D is done
DT-J and DT-B will be done tomorrow after work.

I am going to ditch the filters. I presorted DT-D them by *, then secondary by rating per minute. (still need to find time to tweak this). This is a great way to see how players are doing compared to other players with the same * and not a bad way to tell who needs to be bumped up/down next season if I keep it this way.

once again tracking rating per minute in wb/jav is the most retarded thing u can do cuz it just adds value to fast blowout wins and makes close wins that drag out and actually test a player's ability significantly less valuable it makes sense in base because not every game lasts the same amount of time and kills rack up until time is up but in wb/jav every single game ends once a team gets 50 kills

[Nipple Nibbler]

~update for week 7~
DT-D is done
DT-J and DT-B will be done tomorrow after work.

I am going to ditch the filters. I presorted DT-D them by *, then secondary by rating per minute. (still need to find time to tweak this). This is a great way to see how players are doing compared to other players with the same * and not a bad way to tell who needs to be bumped up/down next season if I keep it this way.

[Nipple Nibbler]

Took a nap that turned into hibernation for 12 hours lol, updated basing this morning. Games played might be a better, or at the least an easier way to approach it, I will look into that at some point this week. It's all about trying to find the balance of opinions of everyone (including myself) and what is fair. I completely agree that someone with only 2 games played shouldn't be leading in "per game or per minute" type stats.

It's all trial and error trying to get everything in a good spot. If I can get everything working how I want it to be, one of the next tasks I want to do is to make a "career" one and collect as many seasons together as I can, also separating playoffs from regular seasons.

Temporary fix for sorting thing, I set up a filter view that is pre-sorted by rating.


In other news....."2:beam> so draft tried to cheat and enter FA under another name cuz saiyan benched him" <----LOL...

[ogron]

great stuff, nipple, thanks.

my personal feeling is that it is your work and your authorship, and you should exercise editorial discretion and sort the stats in a way that you feel is best. players always have the option to copy the sheet and sort it differently, anyway.

for minimums, i think the whole point of averages is that they're an average of a large sample size. averages have no value if the sample size sucks. it's more important to be fair to people playing almost every game than it is to include as many people as possible. i don't even know if i would go by minutes, since there's a large variance between 15-30 minutes. Maybe GP would be better. Probably at least 50% of the games played. Players below that threshold will still have their counting stats displayed, just not their averages.

[Nipple Nibbler]

~update for week 6~
DT-D done
Dt-J done

I will do basing tomorrow after IRL work.

Claushouse Turban had a look and had no luck either. I will probably remove the filter views ability to function and just pre-sort it by rating, which is still on my to-do list to try to balance. If I do I will revisit it again for the next event to see if I can get it working, there has to be a way, it's just not co-operating right now. I have some theories, but not the time right now to test them. I will increase minimum time played for stuff'n things to 45 minutes for dueling leagues and at least 60 for base for this week. I should probably change that to some sort of % of average time played or something so I don't have to keep changing it.

[ogron]

Nipple Nibbler funnily enough, turban is the absolute god of Google Sheets. If there's a solution to your sorting issue, he could absolutely help you solve it. If not, sort it yourself. If a player really wants to do their own sorting they can just do 'Save Copy As' and go to town on it. I think curation is more important.

For the minimum time, just eyeball it? In terr, it seems like there's a natural cutoff around Aprix and Major Crisis up to Week 10. If it feels wrong including someone because they've played too little and it's unfair to those playing the majority of the games, they should be excluded from the KPG/DPG-type averages. Even then, only because they're not overwhelming categories. Averages should really be for players playing most games. If you took a sample of the best 4 games from the players who've played 10 and compared it to those with only 4 GP, their averages would completely blow them out of the water.

[Nipple Nibbler]

Claushouse

On raising the minimum time played issue:
I was raising it every week but then I felt I was raising it too fast. I am not sure how quick to raise the cap, if I raise it too quick only a small amount of players actually get ratings. I am open to suggestions on how much to raise it per week for dueling/basing, basing probably should be higher than dueling. Originally I was thinking 15 mins per week for basing and 10 for dueling.

On sorting it by rating:
I want to do this. I have yet to find a way to be able to sort it by default and allow players to set their own filter views. If I disable allowing players to set up filter views I can then sort it however I want. A good example of this, try to set a filter view in the standings page. It will give you a #REF error if you try to sort something there because I have sorted it by default already. I have been struggling trying to get the filter things to co-operate all season. I want to sort it by rating by default, but at the same time allow people to sort it how they want via filter views. Maybe the two of us combined could figure it out together sometime?

[ogron]

I am coming for you, sir.

lol turby

i love all the great work nipple is doing, but i just don't get why do all that work, and create a ratings formula, then include low sample size players (like turb in terr) and NOT sort by your own ratings formula.

i look into the sheets and they're just this unsorted mess, why aren't the top people at the top? when you look at a stats sheet you wanna see who is up there and then work your way down.

this applies to all leagues/ships, but i'll use terr since that's what i play.

for terr, if you sorted by nipple's own ratings formula then excluded people below 100 minutes, it would look like this:





those are two incredibly small and quick changes that would make this monumentally epic task of doing the stats for every league all season much more digestible and accurate, and help showcase the work nipple is doing.