Return of the Top Defenses of the Top 5 Leagues 2016-2017 (stats)

3 posters

Go down

Return of the Top Defenses of the Top 5 Leagues 2016-2017 (stats) Empty Return of the Top Defenses of the Top 5 Leagues 2016-2017 (stats)

Post by rwo power Fri Sep 16, 2016 12:46 am

Stats up to 28 November 2016, 23:59 GMT+1:
Return of the Top Defenses of the Top 5 Leagues 2016-2017 (stats) Def13

red - League champion
black - club plays CL*
blue - club plays EL*
green - no participation in EL/CL
*)  that is, club qualified for the CL/EL spots, but might not actually go through the qualification/play-offs

The FIFA Club World Cup matches of Real Madrid will be listed in the League Cup column as Spain does not have a League cup and I don't want to add some extra columns only for the CWC and Real Madrid. The Italian Supercup is missing atm as they will play it somewhere around XMas.

Final Stats for 2016:
Stats up to 08 May 2016, 23:59 GMT+2:
Return of the Top Defenses of the Top 5 Leagues 2016-2017 (stats) Th-def15

More on Defensive Records plus the previous Statistics:
Spoiler:


Last edited by rwo power on Tue Nov 29, 2016 12:17 am; edited 11 times in total
rwo power
rwo power
Super Moderator
Super Moderator

Club Supported : Asante Kotoko
Posts : 20978
Join date : 2011-06-05

Back to top Go down

Return of the Top Defenses of the Top 5 Leagues 2016-2017 (stats) Empty Re: Return of the Top Defenses of the Top 5 Leagues 2016-2017 (stats)

Post by rwo power Fri Sep 16, 2016 12:49 am

So. This is the first table for the 2016/17 season as finally I got rid of the Div/0 errors now that all CL/EL matches of the first round were played. ^^

Stats up to 15 September 2016, 23:59 GMT+2:
Return of the Top Defenses of the Top 5 Leagues 2016-2017 (stats) Def10

I'm posting this again here as the first post will always be updated with the newest table, so the first table would get lost if I don't repeat it here.

Have fun with the numbers! If you find any mistakes, please don't hesitate to point them out so that I can fix them.
rwo power
rwo power
Super Moderator
Super Moderator

Club Supported : Asante Kotoko
Posts : 20978
Join date : 2011-06-05

Back to top Go down

Return of the Top Defenses of the Top 5 Leagues 2016-2017 (stats) Empty Re: Return of the Top Defenses of the Top 5 Leagues 2016-2017 (stats)

Post by iftikhar Fri Sep 16, 2016 10:48 am

Kudos for putting in such an effort. You may simplify the table (a bit) if you bunch all domestic cups and European games in a single column respectively.
iftikhar
iftikhar
Fan Favorite
Fan Favorite

Club Supported : Liverpool
Posts : 9347
Join date : 2011-06-06
Age : 52

Back to top Go down

Return of the Top Defenses of the Top 5 Leagues 2016-2017 (stats) Empty Re: Return of the Top Defenses of the Top 5 Leagues 2016-2017 (stats)

Post by rwo power Fri Sep 16, 2016 11:03 am

Actually that wouldn't be simplifying it - it would make it more complicated for me to keep up with the matches that were played. By taking them apart I can more easily go through the results lists and see from the number of matches played per competition whether I missed something or not.

The calculation itself is trivial as that's done automagically by LibreOffice Calc after I entered the proper formulas - I just need to make sure that I don't mess up the number of goals against and matches played per competition.

If you are curious - this is how the calculation is done:
Spoiler:
rwo power
rwo power
Super Moderator
Super Moderator

Club Supported : Asante Kotoko
Posts : 20978
Join date : 2011-06-05

Back to top Go down

Return of the Top Defenses of the Top 5 Leagues 2016-2017 (stats) Empty Re: Return of the Top Defenses of the Top 5 Leagues 2016-2017 (stats)

Post by rwo power Mon Sep 19, 2016 3:44 am

Stats up to 18 September 2016, 23:59 GMT+2:
Return of the Top Defenses of the Top 5 Leagues 2016-2017 (stats) Def11


Stats up to 21 September 2016, 23:59 GMT+2:
Return of the Top Defenses of the Top 5 Leagues 2016-2017 (stats) Def12
rwo power
rwo power
Super Moderator
Super Moderator

Club Supported : Asante Kotoko
Posts : 20978
Join date : 2011-06-05

Back to top Go down

Return of the Top Defenses of the Top 5 Leagues 2016-2017 (stats) Empty Re: Return of the Top Defenses of the Top 5 Leagues 2016-2017 (stats)

Post by rwo power Sun Sep 25, 2016 9:57 pm

Stats up to 25 September 2016, 23:00 GMT+2:
Return of the Top Defenses of the Top 5 Leagues 2016-2017 (stats) Def13
rwo power
rwo power
Super Moderator
Super Moderator

Club Supported : Asante Kotoko
Posts : 20978
Join date : 2011-06-05

Back to top Go down

Return of the Top Defenses of the Top 5 Leagues 2016-2017 (stats) Empty Re: Return of the Top Defenses of the Top 5 Leagues 2016-2017 (stats)

Post by iftikhar Mon Sep 26, 2016 8:08 am

Can we have list of the just the top 20 teams???
iftikhar
iftikhar
Fan Favorite
Fan Favorite

Club Supported : Liverpool
Posts : 9347
Join date : 2011-06-06
Age : 52

Back to top Go down

Return of the Top Defenses of the Top 5 Leagues 2016-2017 (stats) Empty Re: Return of the Top Defenses of the Top 5 Leagues 2016-2017 (stats)

Post by rwo power Mon Sep 26, 2016 10:17 am

Top20 of what? Money list? UEFA coefficients? Top20 of the defense list (this changes after every matchday though).

But frankly, I don't really feel like keeping two separate lists as keeping up with one is sufficient work already. If you like I can explain to you how to set up such a list in a spreadsheet with the necessary formulas, and then you can try to keep a list with the clubs you want to have in it (you can simply copy the numbers from my table, if you like).
rwo power
rwo power
Super Moderator
Super Moderator

Club Supported : Asante Kotoko
Posts : 20978
Join date : 2011-06-05

Back to top Go down

Return of the Top Defenses of the Top 5 Leagues 2016-2017 (stats) Empty Re: Return of the Top Defenses of the Top 5 Leagues 2016-2017 (stats)

Post by Hapless_Hans Mon Sep 26, 2016 4:28 pm

Great work as usual :bow:

The thing that I don't understand though is - the top five leagues, shouldn't that be 78 teams?
How do you decide which teams you leave out? For example, I see all of Bundesliga is in there, but the lower regions of La Liga don't seem to find entrance.

And, most of all. What the hell is Basel doing in there :coffee:
Hapless_Hans
Hapless_Hans
Forum Legend
Forum Legend

Club Supported : Lyon
Posts : 34048
Join date : 2013-09-17

Back to top Go down

Return of the Top Defenses of the Top 5 Leagues 2016-2017 (stats) Empty Re: Return of the Top Defenses of the Top 5 Leagues 2016-2017 (stats)

Post by rwo power Mon Sep 26, 2016 4:55 pm

Well, call me a bit lazy, but originally it was about the teams that got the best defenses, then I added all the CL+EL teams of the Top5 leagues (then ENG, ESP, GER, ITA + FRA - plus FC Basel, just because ^^)  and with time I added some more of the better known and much talked about teams here at GL.  Then a little later I decided to add the rest of the Bundesliga (again just because I could Razz). Let me ponder a little about it and maybe I'll add the rest of ENG, ESP, ITA and FRA. ^^
rwo power
rwo power
Super Moderator
Super Moderator

Club Supported : Asante Kotoko
Posts : 20978
Join date : 2011-06-05

Back to top Go down

Return of the Top Defenses of the Top 5 Leagues 2016-2017 (stats) Empty Re: Return of the Top Defenses of the Top 5 Leagues 2016-2017 (stats)

Post by Hapless_Hans Mon Sep 26, 2016 5:00 pm

I see. You don't have to add anything for my taste. I guess if one of the lesser known teams had some excellent defensive record which would see them somewhere up in this table, you'd include them anyway.
Hapless_Hans
Hapless_Hans
Forum Legend
Forum Legend

Club Supported : Lyon
Posts : 34048
Join date : 2013-09-17

Back to top Go down

Return of the Top Defenses of the Top 5 Leagues 2016-2017 (stats) Empty Re: Return of the Top Defenses of the Top 5 Leagues 2016-2017 (stats)

Post by rwo power Mon Sep 26, 2016 5:04 pm

Exactly. As soon as I see that there are some unfancied teams doing really well, I usually add them, too, just like I often add teams if they have an interesting goalie prospect between the sticks, to see how he's doing.
rwo power
rwo power
Super Moderator
Super Moderator

Club Supported : Asante Kotoko
Posts : 20978
Join date : 2011-06-05

Back to top Go down

Return of the Top Defenses of the Top 5 Leagues 2016-2017 (stats) Empty Re: Return of the Top Defenses of the Top 5 Leagues 2016-2017 (stats)

Post by iftikhar Mon Sep 26, 2016 6:00 pm

rwo power wrote:Top20 of what? Money list? UEFA coefficients? Top20 of the defense list (this changes after every matchday though).

But frankly, I don't really feel like keeping two separate lists as keeping up with one is sufficient work already. If you like I can explain to you how to set up such a list in a spreadsheet with the necessary formulas, and then you can try to keep a list with the clubs you want to have in it (you can simply copy the numbers from my table, if you like).
Thumbs up
iftikhar
iftikhar
Fan Favorite
Fan Favorite

Club Supported : Liverpool
Posts : 9347
Join date : 2011-06-06
Age : 52

Back to top Go down

Return of the Top Defenses of the Top 5 Leagues 2016-2017 (stats) Empty Re: Return of the Top Defenses of the Top 5 Leagues 2016-2017 (stats)

Post by rwo power Sun Oct 02, 2016 10:34 pm

@iftikhar: So what do you need to know? Please ask and you shall be given answers ^^


Stats up to 02 October 2016, 23:30 GMT+2:
Return of the Top Defenses of the Top 5 Leagues 2016-2017 (stats) Def14
rwo power
rwo power
Super Moderator
Super Moderator

Club Supported : Asante Kotoko
Posts : 20978
Join date : 2011-06-05

Back to top Go down

Return of the Top Defenses of the Top 5 Leagues 2016-2017 (stats) Empty Re: Return of the Top Defenses of the Top 5 Leagues 2016-2017 (stats)

Post by rwo power Mon Oct 17, 2016 10:11 pm

Stats up to 17 October 2016, 23:00 GMT+2:
Return of the Top Defenses of the Top 5 Leagues 2016-2017 (stats) Def15
rwo power
rwo power
Super Moderator
Super Moderator

Club Supported : Asante Kotoko
Posts : 20978
Join date : 2011-06-05

Back to top Go down

Return of the Top Defenses of the Top 5 Leagues 2016-2017 (stats) Empty Re: Return of the Top Defenses of the Top 5 Leagues 2016-2017 (stats)

Post by rwo power Fri Oct 21, 2016 2:44 am

Stats up to 20 October 2016, 23:59 GMT+2:
Return of the Top Defenses of the Top 5 Leagues 2016-2017 (stats) Def16
rwo power
rwo power
Super Moderator
Super Moderator

Club Supported : Asante Kotoko
Posts : 20978
Join date : 2011-06-05

Back to top Go down

Return of the Top Defenses of the Top 5 Leagues 2016-2017 (stats) Empty Re: Return of the Top Defenses of the Top 5 Leagues 2016-2017 (stats)

Post by rwo power Mon Oct 24, 2016 2:08 am

Stats up to 23 October 2016, 23:59 GMT+2:
Return of the Top Defenses of the Top 5 Leagues 2016-2017 (stats) Def17
rwo power
rwo power
Super Moderator
Super Moderator

Club Supported : Asante Kotoko
Posts : 20978
Join date : 2011-06-05

Back to top Go down

Return of the Top Defenses of the Top 5 Leagues 2016-2017 (stats) Empty Re: Return of the Top Defenses of the Top 5 Leagues 2016-2017 (stats)

Post by rwo power Mon Nov 07, 2016 11:01 am

Stats up to 6 November 2016, 23:59 GMT+1:
Return of the Top Defenses of the Top 5 Leagues 2016-2017 (stats) Def10
rwo power
rwo power
Super Moderator
Super Moderator

Club Supported : Asante Kotoko
Posts : 20978
Join date : 2011-06-05

Back to top Go down

Return of the Top Defenses of the Top 5 Leagues 2016-2017 (stats) Empty Re: Return of the Top Defenses of the Top 5 Leagues 2016-2017 (stats)

Post by rwo power Sun Nov 20, 2016 11:45 pm

Stats up to 20 November 2016, 23:59 GMT+1:
Return of the Top Defenses of the Top 5 Leagues 2016-2017 (stats) Def11
rwo power
rwo power
Super Moderator
Super Moderator

Club Supported : Asante Kotoko
Posts : 20978
Join date : 2011-06-05

Back to top Go down

Return of the Top Defenses of the Top 5 Leagues 2016-2017 (stats) Empty Re: Return of the Top Defenses of the Top 5 Leagues 2016-2017 (stats)

Post by rwo power Thu Nov 24, 2016 10:26 pm

Stats up to 23 November 2016, 23:00 GMT+1:
Return of the Top Defenses of the Top 5 Leagues 2016-2017 (stats) Def12
rwo power
rwo power
Super Moderator
Super Moderator

Club Supported : Asante Kotoko
Posts : 20978
Join date : 2011-06-05

Back to top Go down

Return of the Top Defenses of the Top 5 Leagues 2016-2017 (stats) Empty Re: Return of the Top Defenses of the Top 5 Leagues 2016-2017 (stats)

Post by rwo power Tue Nov 29, 2016 12:17 am

Stats up to 28 November 2016, 23:59 GMT+1:
Return of the Top Defenses of the Top 5 Leagues 2016-2017 (stats) Def13
rwo power
rwo power
Super Moderator
Super Moderator

Club Supported : Asante Kotoko
Posts : 20978
Join date : 2011-06-05

Back to top Go down

Return of the Top Defenses of the Top 5 Leagues 2016-2017 (stats) Empty Re: Return of the Top Defenses of the Top 5 Leagues 2016-2017 (stats)

Post by Sponsored content


Sponsored content


Back to top Go down

Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum