Conquer Club

@SoN!c, stop spamming the thread

and a Usain Bolt cup GFX again (that comes with the new "box"):

Mad777 wrote:@SoN!c, stop spamming the thread

Lol, and i was thinking it wouldn't upload

I will clean this up later, this is the main thread

Added a Games column for completed games including incomplete matches so you don't have to try and add up the partial games in the grid.

NEW (see guide for more details):

There is now a dedicated games section in the middle (some columns have been rearranged for this) - Games, Home, Away, Fouls

Ever wanted to know how well you or others are doing on their home maps or maps other than home maps?

There are new columns Games, Home and Away

Games - total number of games played including partial matches
Home - games won/total on home maps
Away - games won/total on non-home maps

The guide goes through how this is counted when maps are Random.

New - form data showing your match results in sequence so you can see trends and streaks

chipv wrote:New - form data showing your match results in sequence so you can see trends and streaks

I LOVE that!
FANTASTIC enhancements, Chipv!

Thanks, there is more, not sure where to put them, maybe a new sheet

You can start adding tabs in the spreadsheet, as I’m sure you will come with more side ranking

chipv wrote:Thanks, there is more, not sure where to put them, maybe a new sheet

I love all your updates mates, my stathead goes crazy

Mad777 wrote:You can start adding tabs in the spreadsheet, as I’m sure you will come with more side ranking

Done and guide updated.

There is now a new Top 10 tab showing these

Added Best Streak column on Scoreboard for longest winning streak and that gives a new stat in the Top 10 tab also

Few changes after Clanlord Carl spotted an issue with Fouls (thanks).

The top 10 numbers have been adjusted to make it fairer for League 9 - so we now have averages instead of totals and no dependencies on number of matches completed.

Main scoreboard has a fix for calculating the Days count which now has the correct fastest players.

I've replaced the Top 10 tab with a complete Leaderboard version so everyone can see where they are

Love all the extra stats on the spreadsheet, thanks chipv

Thanks and keep the suggestions and issues coming!

Excellent job!!!!!

Form update:



This update will make it a lot easier to figure out match status:

Green, Yellow Red no change - win, draw, loss
Blue - incomplete matches
Black - this is where no match has been scheduled as an impact from a resting player or a kicked player.

You will be able to see these in advance every week so you will get blues and possibly a black but that at least makes it easier to confirm the expected number of matches.

This was bugging me so I have made a fix for win streaks:

Skipped Matches (Black squares) do not count as a win but also do not break win streaks

• Row 1: Black square does not count as a win but it does not break win streaks so the biggest streak is 6.
• Row 2: The green squares are not broken up by anything so the biggest streak is 5.
• Row 3: There is a sequence of 4 green squares with a black square in the middle. Black squares do not count as a win but also do not break win streaks so this biggest streak is 4.

I was PMd a suggestion so good it has been implemented - thanks to Rockiesman for this suggestion!

The form now has orange squares for 3-1 leaving green squares for 4-0. No change in streak calculation - it now counts green/orange as a win as it really was doing before.

To make all the colours match the grid has been changed to show losses in red.

• Row 1: Black square does not count as a win but it does not break win (green / orange) streaks so the biggest streak is 6.
• Row 2: The green / orange squares are not broken up by anything so the biggest win streak is 5.
• Row 3: There is a green / orange win streak of 2

There is a tradeoff here - perhaps not so easy to see the streaks but the form results colours now match the grid and league table which seems a better outcome.

Sorry one more colour change - orange to brown as brown is a better contrast.

I am considering adding squares for the whole season (purple and black) so that it shows you upcoming skipped matches.

Form - Match results in sequence (Green = 4-0, Brown = 3-1, Yellow = 2-2, red = loss, blue = incomplete, black = skipped vs rest or kicked player)
Best Streak - longest streak of consecutive wins (4-0 or 3-1) - skipped games (black squares) do not count as a win but they do not break win streaks (consecutive green / brown squares). For example:

• Row 1: Black square does not count as a win but it does not break win (green / brown) streaks so the biggest streak is 6.
• Row 2: The green / brown squares are not broken up by anything so the biggest win streak is 5.
• Row 3: There is a green / brown win streak of 2

This is what it would look like if I included another colour for matches not sent out yet:



Any good or too much?

Ended up with this - the grid colours match also

Added a new stat to the leaderboard - Strength. This is more commonly known as PPG (points per game) but we are using it as points per match instead as we only allocate points for matches.

This stat is often used to calculate opposition strength based on past matches and to use this to predict future results by calculating opposition strength for the remaining matches.