Squad Ratings 2015/16

The Fighting Cock · 8 Aug 2015

Results are based on ratings submitted by members of the forum after each match. You can leave your ratings for the last match in the corresponding thread here.

[raw]
<script src="https://cdnjs.cloudflare.com/ajax/libs/jquery-sheetrock/1.0.0/dist/sheetrock.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/handlebars.js/1.1.2/handlebars.min.js"></script>

<div id="squad-ratings">

<h3>Team</h3>
<ul id="team">
<script id="team-template" type="text/x-handlebars-template">
<li><strong>Tottenham Hotspur</strong><br>
<img src="http://www.thefightingcock.co.uk/spurs-logo-ratings.png" alt="Tottenham Hotspur" /><br>
<div class="stats">
Team average: <strong>{{cells.TeamAverageRound}}</strong><br>
Matches Played: <strong>{{cells.MatchesPlayed}}</strong><br>
Players Used: <strong>{{cells.PlayersUsed}}</strong><br>
Ratings received: <strong>{{cells.RatingsSubmit}}</strong><br>
Best match: <strong>{{cells.BestMatch}}</strong> ({{cells.BestMatchRound}})<br>
Worst match: <strong>{{cells.WorstMatch}}</strong> ({{cells.WorstMatchRound}})<br>
Best player: <strong>{{cells.BestPlayer}}</strong> ({{cells.BestPlayerRound}})<br>
Worst player: <strong>{{cells.WorstPlayer}}</strong> ({{cells.WorstPlayerRound}})
</div>
</li>
</script>
</ul>

<h3>Manager</h3>
<ul id="mg">
<script id="mg-template" type="text/x-handlebars-template">
<li><a href="{{cells.ForumThread}}" class="rate-player"><strong>{{cells.Player}}</strong></a><br>
<img src="{{cells.Photo}}" alt="{{cells.Player}}" /><br>
<div class="stats">
Average: <strong>{{cells.Average}}</strong><br>
Games: <strong>{{cells.Games}}</strong><br>
Ratings received: <strong>{{cells.Ratings}}</strong><br>
Best: <strong>{{cells.BestMatch}}</strong> ({{cells.HighestRound}})<br>
Worst: <strong>{{cells.WorstMatch}}</strong> ({{cells.LowestRound}})<br>
<a href="{{cells.ForumThread}}"><i class="fa fa-comments-o"></i> {{cells.Surname}} forum thread</a>
</div>
</li>
</script>
</ul>

<h3>Player Rankings</h3>
<ul id="hr">
<script id="hr-template" type="text/x-handlebars-template">
<li><a href="{{cells.ForumThread}}" class="rate-player"><strong>{{cells.Player}}</strong></a> <span class="position">{{cells.Position}}</span><br>
<img src="{{cells.Photo}}" alt="{{cells.Player}}" /><br />
<div class="stats">
<span class="rank">{{cells.Rank}}</span>
Rating / Games: <strong>{{cells.Average}}</strong> / <span class="games">{{cells.Games}}</span><br>
Premier League: <strong>{{cells.PLRound}}</strong> / <span class="games">{{cells.PLG}}</span><br>
FA Cup: <strong>{{cells.FACRound}}</strong> / <span class="games">{{cells.FACG}}</span><br>
League Cup: <strong>{{cells.LCRound}}</strong> / <span class="games">{{cells.LCG}}</span><br>
Europa League: <strong>{{cells.ELRound}}</strong> / <span class="games">{{cells.ELG}}</span><br>
Ratings received: <strong>{{cells.Ratings}}</strong><br>
Best: <strong>{{cells.BestMatch}}</strong> ({{cells.HighestRound}})<br>
Worst: <strong>{{cells.WorstMatch}}</strong> ({{cells.LowestRound}})<br>
<a href="{{cells.ForumThread}}"><i class="fa fa-comments-o"></i> {{cells.Surname}} forum thread</a>
</div>
</li>
</script>
</ul>

<h3>Best Defender</h3>
<ul id="df">
<script id="df-template" type="text/x-handlebars-template">
<li><a href="{{cells.ForumThread}}" class="rate-player"><strong>{{cells.Player}}</strong></a><br>
<img src="{{cells.Photo}}" alt="{{cells.Player}}" /><br />
<div class="stats">Average: <strong>{{cells.Average}}</strong><br>
Games: <strong>{{cells.Games}}</strong><br>
Ratings received: <strong>{{cells.Ratings}}</strong><br>
Best: <strong>{{cells.BestMatch}}</strong> ({{cells.HighestRound}})<br>
Worst: <strong>{{cells.WorstMatch}}</strong> ({{cells.LowestRound}})<br>
<a href="{{cells.ForumThread}}"><i class="fa fa-comments-o"></i> {{cells.Surname}} forum thread</a>
</div>
</li>
</script>
</ul>

<h3>Best Midfielder</h3>
<ul id="mf">
<script id="mf-template" type="text/x-handlebars-template">
<li><a href="{{cells.ForumThread}}" class="rate-player"><strong>{{cells.Player}}</strong></a><br>
<img src="{{cells.Photo}}" alt="{{cells.Player}}" /><br />
<div class="stats">Average: <strong>{{cells.Average}}</strong><br>
Games: <strong>{{cells.Games}}</strong><br>
Ratings received: <strong>{{cells.Ratings}}</strong><br>
Best: <strong>{{cells.BestMatch}}</strong> ({{cells.HighestRound}})<br>
Worst: <strong>{{cells.WorstMatch}}</strong> ({{cells.LowestRound}})<br>
<a href="{{cells.ForumThread}}"><i class="fa fa-comments-o"></i> {{cells.Surname}} forum thread</a>
</div>
</li>
</script>
</ul>

<h3>Best Forward</h3>
<ul id="fw">
<script id="fw-template" type="text/x-handlebars-template">
<li><a href="{{cells.ForumThread}}" class="rate-player"><strong>{{cells.Player}}</strong></a><br>
<img src="{{cells.Photo}}" alt="{{cells.Player}}" /><br />
<div class="stats">Average: <strong>{{cells.Average}}</strong><br>
Games: <strong>{{cells.Games}}</strong><br>
Ratings received: <strong>{{cells.Ratings}}</strong><br>
Best: <strong>{{cells.BestMatch}}</strong> ({{cells.HighestRound}})<br>
Worst: <strong>{{cells.WorstMatch}}</strong><br>
<a href="{{cells.ForumThread}}"><i class="fa fa-comments-o"></i> {{cells.Surname}} forum thread</a>
</div>
</li>
</script>
</ul>

<h3>Months</h3>
<ul id="months">
<script id="months-template" type="text/x-handlebars-template">
<li><strong style="margin-bottom: 20px;display: block;">{{cells.Month}}</strong>
<div class="stats">
Matches: <strong>{{cells.Matches}}</strong><br>
Average: <strong>{{cells.AverageRound}}</strong><br>
Best Match: <strong>{{cells.BestGame}}</strong> ({{cells.BestGameRound}})<br>
Worst Match: <strong>{{cells.WorstGame}}</strong> ({{cells.WorstGameRound}})<br>
Best Player: <strong>{{cells.BestPlayer}}</strong> ({{cells.BestPlayerRound}})<br>
Worst Player: <strong>{{cells.WorstPlayer}}</strong> ({{cells.WorstPlayerRound}})
</div>
</li>
</script>
</ul>
</div>

<script>
var mySpreadsheet = 'https://docs.google.com/spreadsheets/d/1PIpwtjcT0UhenkAmf7U9y6MXLSJCYTYr-khoRSs21_4/edit#gid=2121660352';
// Compile the Handlebars template for HR leaders.
var HRTemplate = Handlebars.compile($('#hr-template').html());
// Load player ratings
$('#hr').sheetrock({
url: mySpreadsheet,
query: "select A,B,C,D,E,F,G,H,I,J,K,L,M,N,O,P,Q,R,S,T,U,V,AR,AS,AT,AU,AV where (E != 'MG') AND (F > 0) order by F desc",
rowTemplate: HRTemplate
});

var DFTemplate = Handlebars.compile($('#df-template').html());
// Load top defender
$('#df').sheetrock({
url: mySpreadsheet,
query: "select A,B,C,D,E,F,G,H,I,J,K,L,M,N,AQ where (E = 'DF') AND (H > AQ) order by F desc",
fetchSize: 1,
rowTemplate: DFTemplate
});

var MFTemplate = Handlebars.compile($('#mf-template').html());
// Load top midfielder
$('#mf').sheetrock({
url: mySpreadsheet,
query: "select A,B,C,D,E,F,G,H,I,J,K,L,M,N,AQ where (E = 'MF') AND (H > AQ) order by F desc",
fetchSize: 1,
rowTemplate: MFTemplate
});

var FWTemplate = Handlebars.compile($('#fw-template').html());
// Load top forward
$('#fw').sheetrock({
url: mySpreadsheet,
query: "select A,B,C,D,E,F,G,H,I,J,K,L,M,N,AQ where (E = 'FW') order by F desc",
fetchSize: 1,
rowTemplate: FWTemplate
});

var MGTemplate = Handlebars.compile($('#mg-template').html());
// Load top forward
$('#mg').sheetrock({
url: mySpreadsheet,
query: "select A,B,C,D,E,F,G,H,I,J,K,L,M,N where (E = 'MG')",
rowTemplate: MGTemplate
});

var monthSheet = 'https://docs.google.com/spreadsheets/d/1PIpwtjcT0UhenkAmf7U9y6MXLSJCYTYr-khoRSs21_4/edit#gid=196204868';
// Compile the Handlebars template for HR leaders.
var MONTHTemplate = Handlebars.compile($('#months-template').html());
// Load player ratings
$('#months').sheetrock({
url: monthSheet,
query: "select A,B,C,F,I,K,L,N,O,Q,R,T order by C asc",
fetchSize: 10, // Increase this to show other months
rowTemplate: MONTHTemplate
});

var teamSheet = 'https://docs.google.com/spreadsheets/d/1PIpwtjcT0UhenkAmf7U9y6MXLSJCYTYr-khoRSs21_4/edit#gid=987459834';
// Compile the Handlebars template for HR leaders.
var TEAMTemplate = Handlebars.compile($('#team-template').html());
// Load player ratings
$('#team').sheetrock({
url: teamSheet,
query: "select A,B,C,E,F,H,I,K,L,N,O,Q order by C asc",
rowTemplate: TEAMTemplate
});
</script>
[/raw]

[raw]
<div id="squad-ratings">
<h3>Matches</h3>
</div>
<iframe src="https://docs.google.com/spreadsheets/d/1PIpwtjcT0UhenkAmf7U9y6MXLSJCYTYr-khoRSs21_4/pubhtml/sheet?headers=false&gid=962847569&range=A1:AF60" width="728" height="800"></iframe>[/raw]
View full table

[raw]
<div id="squad-ratings">
<h3>Squad</h3>
</div>
<iframe src="https://docs.google.com/spreadsheets/d/1PIpwtjcT0UhenkAmf7U9y6MXLSJCYTYr-khoRSs21_4/pubhtml/sheet?headers=false&gid=856087559&range=A1:AK30" width="728" height="800"></iframe>[/raw]
View full table

View results on the BBC website

[raw]<script language="JavaScript" type="text/javascript">
rp_account = "11232";
rp_site = "79850";
if (window.innerWidth < 730) {
rp_zonesize = "374798-15";
} else if (window.innerWidth < 1024) {
rp_zonesize = "374798-2";
} else {
rp_zonesize = "374798-1";
}
rp_adtype = "js";
rp_smartfile = "[SMART FILE URL]";
</script>
<script type="text/javascript" src="http://ads.rubiconproject.com/ad/11232.js"></script>[/raw]

Guido 🇺🇦 · 9 Aug 2015

Eriksen best midfielder WTF!!!!

Yorkshire_Spurs · 9 Aug 2015

How do you submit your ratings?

The Fighting Cock · 9 Aug 2015

Yorkshire_Spurs said:
How do you submit your ratings?

There should be a thread after each game. Might put it up the day after to stop the knee-jerk ratings. Any obvious ones (like all 1's or all 10's) are automatically removed anyway.

Yorkshire_Spurs · 9 Aug 2015

The Fighting Cock said:
http://www.thefightingcock.co.uk/fo...-premier-league-manchester-united-away.15166/

There should be a thread after each game. Might put it up the day after to stop the knee-jerk ratings. Any obvious ones (like all 1's or all 10's) are automatically removed anyway.

Sounds good. I like the idea. Should give a pretty interesting view on player performance through the season.

SantaHat · 9 Aug 2015

Nice try

zin

Jayc1 · 9 Aug 2015

This is great. Cheers :adethumbup:

zin · 9 Aug 2015

SantaHat said:
Nice try zin

FightingIllini · 9 Aug 2015

Oh this has to be a smiley

moley · 9 Aug 2015

You can vote multiple times

Admin

Admin · 9 Aug 2015

moley said:
You can vote multiple times Admin

Yea, its handled through Google forms. I could make it so you can only vote once but everyone would need a Google account.

Edit: Actually, I should be able to remove duplicates at this end.

Deuce · 9 Aug 2015

Im glad were doing this again.

Josh Pauls · 11 Aug 2015

This is genius

Bale'sHairLine · 11 Aug 2015

Good on you, mate. Really nice idea. Thank you.

I'd leave it till the next day - I'm pretty sure I'd have given Bentaleb -10 if it was possible at the time. So it's probably best to let people calm down a bit before voting!

lovetheshirt · 11 Aug 2015

I have missed this. I was disappointed when

zin stopped a few years back (although I understand the reasons).

Admin is this going to be for locals only - don't want outsiders voting do you? :harryhmm:

Admin · 11 Aug 2015

lovetheshirt said:
Admin is this going to be for locals only - don't want outsiders voting do you?

You have to be registered to access the form.

Dannyboy · 11 Aug 2015

Multiple votes? This is really going to test my split personality syndrome.

therealITK · 11 Aug 2015

I was wondering what had happened to the thread.

Looking forward to seeing the results and hopefully it will be an upward trend for our team.

NorseYid · 16 Aug 2015

Can you give me a link to rate the Stoke Home game?

sammyspurs · 18 Aug 2015

The Fighting Cock said:
There should be a thread after each game. Might put it up the day after to stop the knee-jerk ratings. Any obvious ones (like all 1's or all 10's) are automatically removed anyway.

Why not just make it 2 - 9 then?

Squad Ratings 2015/16

Latest Spurs videos from Sky Sports

The Fighting Cock

Guido 🇺🇦

"Legacy Fan"

Yorkshire_Spurs

@daveyglee

The Fighting Cock

Yorkshire_Spurs

@daveyglee

SantaHat

Jayc1

zin

FightingIllini

moley

Admin

Omnipotent

Deuce

Josh Pauls

Bale'sHairLine

lovetheshirt

The fault, dear Brutus, is not in our stars

Admin

Omnipotent

Dannyboy

therealITK

NorseYid

sammyspurs