BEAST - Bannerlord Early Access Skirmish Tournament

[Ikea Knight]

Hey everybody, here are all the stats from the matches so far in alphabetical order. You can find your K/D/A and also your average K/D/A.

For all Issues with this table (especially names) pls PM me and I will fix it with the next update.

Issues:
1. I only used the screenshots to fill in the stats. If we have no screenshots there won't be stats.
2. I used the name given on the screenshots. If you changed your name between matches, you will appear twice with different names.
3. I couldn't read some names. Can't read Cyrillic -sorry. I used the Clantag only here.
4. There might be some typos. Afterall it is all bloody long list
5. Keep in mind that average stats for players that only played once or twice don't have any real meaning.
6. I used only the raw stats: So I ignored if players broke rules or left the tourney.
I will try to update it for the rest of the tourney.

隐藏: Google.doc

Beast Playerstats

Original Worksheet Player,Kill,Death,Assist,Score,Class [EEE],8,7,7,1590,Inf aaaaaaaaa,9,7,8,1700,Inf aaaaaaaaa,16,9,7,3010,Inf aaaaaaaaa,7,1,5,1390,Cav Adiq,7,5,8,1610,Cav Adiq,7,9,7,1605,cav Adiq,4,6,2,810,inf Adiq,3,5,2,545,Inf Adiq,2,6,0,330,Inf Adiq,9,8,2,1450,Inf Adiq,7,3,2,1030,cav Adiq,7...

docs.google.com

Edit:

I removed the images in favor of the google doc which looks nicer and is easier to read.



New Update: I added all the new matches from K.O & and changed the layout to Kills per Rounds / Death per Rounds and so on.

I also added a detailed stat which is hard to read but basicayl you see each players total performance on map and then it is divided in each faction.

Also I did the same for Clans.

I've been working on this for hours today. And I think there are more things I could do wtih this list. I'll try to add new things or explain more today or thursday.

Take a look

 

[Firunien]

Stats are always nice, thanks Ikea !

 

[Indi4N]

Great work lad

 

[Aprikosenmann]

Good job.
It would be nice if the average was per round and not per map since you never know if it was 3-2 or 3-0.

 

[Ikea Knight]

Good job.
It would be nice if the average was per round and not per map since you never know if it was 3-2 or 3-0.

Since I only had screenshots at the end of the match that wasn't an option.
Also that took me already about 8 hours. It was so long that my girlfriend was getting annoyed by the constant rhythmic sound of my mechanical keyboard. If I had done that 3 to 5 times as long ( so for each round) she surely would have left me.

I still want to add to the table. Maybe something like kills per life or similiar.
I also wrote down all the classes at the end of match. I might add them aswell.
The issue here is that the losing team almost always used light infantry in the last round. - Probably due to the gold.
I might also highlight the best 5 inf/ cav / archers of the tourney. There are many interesting things I'd like to add.

 

[Aprikosenmann]

I dont get that. You would "just" need another row with rounds played where you add the number of rounds. 3-0 + 3-1 + 3-2 = 12 rounds played.
Would be nice if your list was a public google.doc where we can sort by the values.

 

[Namakan]

nice work
+1 to having it a public view-only doc so we can sort n stuff

also, if not too late, maybe also include "matches played"?

 

[Ikea Knight]

I dont get that. You would "just" need another row with rounds played where you add the number of rounds. 3-0 + 3-1 + 3-2 = 12 rounds played.
Would be nice if your list was a public google.doc where we can sort by the values.

Ah okay.
Now I get what you mean. The terminology with rounds, matches and sets is a little bit wonky.
Google doc is a good idea. I will look into it later today.

also, if not too late, maybe also include "matches played"?

I started out with that, but as soon as teams were changing out players it became too hard to track it.
Some people would have 6 games played other 1 or two in the same team.

It's not to late to add it though. It is obviously an important parameter.
I simply didn't come up with a clever formula to make excel work for me.
Someone who is better at excel can probably find a solution.

 

[Namakan]

I started out with that, but as soon as teams were changing out players it became too hard to track it.
Some people would have 6 games played other 1 or two in the same team.

It's not to late to add it though. It is obviously an important parameter.
I simply didn't come up with a clever formula to make excel work for me.
Someone who is better at excel can probably find a solution.

My first ideas would be to either store the total rounds played (at least as far as you can tell from the screenshots) or to count it with decimals, e.g. someone played 4 out of 5 maps in a match, they get 0.8 matches added to their total.
Just as you though, I'm unsure if either of these are a good idea , and both of them would most likely require you to to through every match again.

 

[Ikea Knight]

I updated the OP. Hope you like it.

 

[TheBard]

My first ideas would be to either store the total rounds played (at least as far as you can tell from the screenshots) or to count it with decimals, e.g. someone played 4 out of 5 maps in a match, they get 0.8 matches added to their total.
Just as you though, I'm unsure if either of these are a good idea , and both of them would most likely require you to to through every match again.

That idea is actually very good.
However, you'd have to break down the tables for that to work in group stage (3 screenshots = 1 match) and Knock Out (starting this week, 5 screenshots = one match)

 

[Ikea Knight]

Well I uploaded two sheets to the google doc.
One is with the final and summarized data.
The other is my original worksheet, where you can find everyones total K/D/A per every single match.
So basically the screenshots as a table.

 

[Ikea Knight]

OP updated

 

[Tryerror]

Very Cool and so much work amazing.
I do have a Question so, how do you calculate those things like Rounds lost. DR1 has in your table lost 12 Rounds. In the Groupstage DR1 lost 2 Rounds and 0 in the Top16.

 

[Ikea Knight]

Very Cool and so much work amazing.
I do have a Question so, how do you calculate those things like Rounds lost. DR1 has in your table lost 12 Rounds. In the Groupstage DR1 lost 2 Rounds and 0 in the Top16.

Yes that still needs some work and I hope to fix it by tomorrow.
Right now it counts the sum of all rounds played by all players of that team.
So if DR lost two rounds, each player lost twice. With 6 players that would that's 12 rounds lost.

I guess the easy solution would be to divide by 6, however there were matches where only 5 or 4 players remained at the end so it won't be acurate.

Sorry I didn't fix that yesterday, but after hours of work is was looking for some relaxed time in the evening

 

[Aeronwen]

This a huge amount of work - really good job

 

[WakaWaka]

great job thanks for this!

 

[Ikea Knight]

great job thanks for this!

Currently working on an updated version.

 

[Black_Corsair]

so who are the top 3 players? )