Page 1 of 2 1 2 >
Topic Options
Rate This Topic
#506243 - 11/11/20 06:09 AM MMArmy - a statistical index October 2020
ulithebison


Registered: 03/30/20
Posts: 403
Loc: Germany
MMArmy - a statistical index October 2020

Introduction
I have taken a course in Excel PowerQuery. This is a possibility to evaluate large amounts of data in Excel independently.
Among other things, the possibility of loading data from the web is provided here. So I could load the fighter record of fighter XYZ into Excel.
(No Chubby, that's not hacking - you fool).

In order to practice the whole thing, I took a look at MMArmy.
Here I pulled out Top100-Camps - as of September 30th - as well as all camps from the alliance roster and afterwards saved the data (fights, wins, losses, titles etc.).
Then I waited one month and did the same again on October 31st. So the difference from this result is the change of the month October.
It will of course be the case that new camps that were created in the current month will not be included in the database.
However, all forum members should be registered with their camps. The whole thing is always considered per camp.
I will now present the results to you.

Top 20 - Most fights in October 2020

In this table you can find the camps with the most fights in October.
As probably always, this list is led by Matty with about 1,545 fights.
He is followed by Judo, who returned from retirement this month. I'm pretty sure he could take Matty's place.
They are followed at some distance by Amp and Black-Santa.
However, we know that this table says nothing about success (Sorry Matty).

Best Win % in October 2020 >100 Fights

A little more interesting is the Top 20 by Win % with more than 100 fights.
The list is headed by Neverland. He could win almost 70% of all his fights.
However, towards the end of the month it became more and more apparent that he was either looking for the easy fights or even had feeder camps. He was already banned from the forum. Ingame I think too.
In second or first place is Peasant with the camp "Club Casual" with 66.03% Win%, closely followed by Simon with 65.79%
It is interesting that Judo with far more than 1.000 fights has a value of over 50% Win% (Sorry Matty).

Top 20 - Most EFC Title Wins in October 2020

Since this table is also not so meaningful, since many fights can take place in lower leagues, we direct our attention to the EFC.
In this table you can find the camps with the most EFC title wins in the month of October. This includes all weight classes.
Here Smooth Jesus could secure the first place with 34 titles. Followed by Tyson Ali (BlindPhaedo) with 30 titles.
It is interesting that Smooth Jesus managed to get into the top 20 with three camps. Drink also managed to place two camps in the top 20.

Top 20 - Fights/EFC Title October 2020

Since the EFC titles are only an absolute number, it is difficult to determine if the camp was really the most efficient now.
Camps with many fighters logically win more titles than camps with less active fighters.
Therefore I have compared the number of fights of the camp in the respective month with the number of won EFC titles of the camp (Fights/EFC Titles).
So this means how many fights did it take a camp to win an EFC title.

This ratio now also shows that the high Win% (66%) of Peasant (Club Casual) is not reflected in the title wins.
Some might argue that he only fights for his statistics and not for titles and therefore his record is useless.

Although Smooth Jesus won a total of 34 titles with his camp of the same name, he needed about 16 fights per title.
On second place is Tyson Ali (BlindPhaedo) with 11.37 fights per title win.

In the month of October would be on rank 1 Simon with his Ryngwell MMA Camp. According to the ratio he won a title every 10.86 fights.

If you now look at the Win%, number of EFC titles won and the ratio Fights/EFC titles, I would say that Simon was the most successful and efficient coach/camp in October.

Summary
I hope you enjoyed this statistical excursion and that you could take some interesting information with you.
If you have any suggestions or points you would like to share with me, feel free to do so.
Otherwise: Fuck this old forum.
_________________________
Reinz Gym | MMA Jeddah Club

Top
#506248 - 11/11/20 06:47 AM Re: MMArmy - a statistical index October 2020 [Re: ulithebison]
Matty


Registered: 10/30/08
Posts: 13429
Great write-up, very interesting, maybe I need to go retire a camp or 10 and focus on using my knowledge of playing the game for years on my main camp or two instead of spamming challenge all laugh

Top
#506251 - 11/11/20 07:57 AM Re: MMArmy - a statistical index October 2020 [Re: Matty]
The Captain


Registered: 01/11/12
Posts: 4722
Loc: California
This is all beautiful.. *Chef kiss
_________________________
Bay Bombers, The Fighting 15th, Bando Brothers, Swingin Cats

**Most Improved Player of 2015**
**Coach of the Year of 2016**
**Most Entertaining Poster of 2016, and 2018**
**Best Event of 2016: Basebrawl**
**UFC Prediction King of 2016**




Top
#506273 - 11/11/20 05:49 PM Re: MMArmy - a statistical index October 2020 [Re: The Captain]
Peasant


Registered: 04/24/17
Posts: 119
What a great write up. Thanks for taking the time to do this. I love these kind of things. Looking forward to Novembers one.

Top
#506280 - 11/12/20 01:35 AM Re: MMArmy - a statistical index October 2020 [Re: Peasant]
Picograms95


Registered: 01/20/20
Posts: 209
Loc: Germany
great work uli! Would laughed my ass off if you'd written (Sorry Matty) under each statistic, no matter the text/description you wrote for that lol

Top
#506282 - 11/12/20 01:38 AM Re: MMArmy - a statistical index October 2020 [Re: Picograms95]
Matty


Registered: 10/30/08
Posts: 13429
haha I was expecting that after the first few pics laugh

Top
#506304 - 11/12/20 11:26 PM Re: MMArmy - a statistical index October 2020 [Re: Matty]
DrinkDrankCrunk


Registered: 12/20/08
Posts: 9599
Great to see THC up there. Thanks for sharing.
_________________________
DisGracedies------------------------------------------------------Sadaharu Oh Dojo-----------------------------------------------Yeltsin-------------------

Top
#506305 - 11/12/20 11:58 PM Re: MMArmy - a statistical index October 2020 [Re: DrinkDrankCrunk]
ulithebison


Registered: 03/30/20
Posts: 403
Loc: Germany
If all coaches, who are in an alliance, ingame would assign their camps to the corresponding alliance, even alliance results would be possible.
Unfortunately not everyone has done this.
_________________________
Reinz Gym | MMA Jeddah Club

Top
#506657 - 12/01/20 03:42 AM Re: MMArmy - a statistical index October 2020 [Re: ulithebison]
Matty


Registered: 10/30/08
Posts: 13429
are we gonna see a November version uli? smile

Top
#506659 - 12/01/20 06:00 AM Re: MMArmy - a statistical index October 2020 [Re: Matty]
ulithebison


Registered: 03/30/20
Posts: 403
Loc: Germany
I am loading the data already. Takes a while. smile
_________________________
Reinz Gym | MMA Jeddah Club

Top
#506660 - 12/01/20 07:02 AM Re: MMArmy - a statistical index October 2020 [Re: ulithebison]
Matty


Registered: 10/30/08
Posts: 13429
awesome laugh

Top
#506680 - 12/02/20 02:39 AM Re: MMArmy - a statistical index October 2020 [Re: Matty]
ulithebison


Registered: 03/30/20
Posts: 403
Loc: Germany
It will not let me load the data. I don't know why. :-(
_________________________
Reinz Gym | MMA Jeddah Club

Top
#506762 - 12/04/20 06:37 AM Re: MMArmy - a statistical index October 2020 [Re: ulithebison]
Peasant


Registered: 04/24/17
Posts: 119
Is it working?

Top
#506763 - 12/04/20 07:08 AM Re: MMArmy - a statistical index October 2020 [Re: Peasant]
ulithebison


Registered: 03/30/20
Posts: 403
Loc: Germany
nope. I am sorry.
But I will try to make the spreadsheet a bit leaner and easier for me to handle and will start a new run with January.
I also ask Chief for help but he didn't respond. Would be cool if he could give me the whole data. Would be a lot easier. At least for me.
_________________________
Reinz Gym | MMA Jeddah Club

Top
#506766 - 12/04/20 07:15 AM Re: MMArmy - a statistical index October 2020 [Re: ulithebison]
Peasant


Registered: 04/24/17
Posts: 119
That hurts. This was one of the best ever posts ever and was lforward to the update. Really Dissapointing

Top
#506771 - 12/04/20 07:47 AM Re: MMArmy - a statistical index October 2020 [Re: Peasant]
ulithebison


Registered: 03/30/20
Posts: 403
Loc: Germany
Next year then.
_________________________
Reinz Gym | MMA Jeddah Club

Top
#506914 - 12/11/20 10:19 PM Re: MMArmy - a statistical index October 2020 [Re: ulithebison]
Tok


Registered: 02/01/08
Posts: 2793
Loc: France
Nice job, love those stats !
_________________________
Tok Striking Camp : http://www.mmarmy.com/camp_display.php?id=4404

Tok Fighting System: http://www.mmarmy.com/camp_display.php?id=4718


Top
#507124 - 12/22/20 11:43 PM Re: MMArmy - a statistical index October 2020 [Re: ulithebison]
BrodyArmBar


Registered: 07/19/20
Posts: 20
woo! love seeing myself in that top 5 for october. makes me wanna keep playing. awesome work.

Top
Page 1 of 2 1 2 >


Who's Online
1 Registered (Simon), 113 Guests and 2 Spiders online.
Key: Admin, Global Mod, Mod