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: 5, // 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]
