paulc Posted June 29, 2014 Share Posted June 29, 2014 Having a bit too much time on my hands I've made an attempt at producing a performance index of clubs in the Scottish Junior Cup over the past 5 seasons. I intend to update it at the completion of each round in the future. The index is attached. ---- For geeks interested in how I calculated the index Each win earns the following number of points Round 1 victory - 10 Round 2 victory - 11 Round 3 victory - 12 Round 4 victory - 13 Round 5 victory - 14 Round 6 victory - 15 SF Victory - 16 Final victory - 17 (teams which progress as a result of their opponent scratching or because of an appeal do not earn any points.) These points are cumulative so a team winning in round 1 and then being eliminated earns 10 points. A team winning the cup (and playing in round 1) earns 108 points The index covers the last 5 seasons. It is weighted so that performances in more recent seasons earn more points than in earlier seasons. The weights I settled on are current season - 60 current season-1 50 currrent season-2 40 current season-3 30 current season-4 20 So a team winning the cup (and playing in round 1) would earn 108*60 (6480) points in the current season. A team winning the cup (and playing in round 1) in the earliest season covered by the index would earn 108*20 (2160) points. The total number of points that could be earned by a team winning the cup in all 5 seasons (and playing in Round 1 is (108*20)+(108+30)+108*40)+(108*50)+(108*60) = 21600. Each club's total points is then multiplied by (1000/21600) to give an index with 1000 being the highest possible score. As a continuing project I will update the table at the end of each round in the future. When Round 1 2014-15 is completed Round 1 2009-10 will drop out of the calculations and the highest weight of 60 will apply to Round 1 2014-15 and Rounds 2-Final 2013-14 etc. juniors index.xls Link to comment Share on other sites More sharing options...
theesel1994 Posted June 29, 2014 Share Posted June 29, 2014 I thought you'd missed Largs Thistle out - wasn't expecting to see them in 6th spot. Link to comment Share on other sites More sharing options...
glensmad Posted June 29, 2014 Share Posted June 29, 2014 Excellent work. Good to see us in the top 10, hope we can stay there. Link to comment Share on other sites More sharing options...
Guest Posted June 29, 2014 Share Posted June 29, 2014 Whitletts in 20th, above quite a few prem teams. Last seasons run to the quarters probably pushed us up a good bit Link to comment Share on other sites More sharing options...
Guest Posted June 29, 2014 Share Posted June 29, 2014 Does the teams sitting on 0 points, mean that they havnt won a scottish tie in 5 seasons?? Link to comment Share on other sites More sharing options...
paulc Posted June 29, 2014 Author Share Posted June 29, 2014 Yes indeed. "At least" 5 seasons (unless they are relative newcomers to the juniors) Link to comment Share on other sites More sharing options...
energyzone Posted June 30, 2014 Share Posted June 30, 2014 Irvine Vics recent record is terrible considering they've just won the ADL. Troon are very low as well. Link to comment Share on other sites More sharing options...
fan of the juniors Posted June 30, 2014 Share Posted June 30, 2014 33rd? Didn't think we would be as high as that lol Link to comment Share on other sites More sharing options...
jimbaxters Posted June 30, 2014 Share Posted June 30, 2014 Excel's not working on my computer. Who's at the top please? Link to comment Share on other sites More sharing options...
Jimper7 Posted June 30, 2014 Share Posted June 30, 2014 Excel's not working on my computer. Who's at the top please?. Have a guess jb lol Link to comment Share on other sites More sharing options...
jimbaxters Posted June 30, 2014 Share Posted June 30, 2014 . Have a guess jb lol Is it us??? Nice Link to comment Share on other sites More sharing options...
LongTimeLurker Posted June 30, 2014 Share Posted June 30, 2014 Another highlight is Bo'ness United (554.2) second and top in the east with Linlithgow Rose (324.1) trailing badly in seventh place only slightly ahead of Camelon (316.7). Link to comment Share on other sites More sharing options...
HTG Posted June 30, 2014 Share Posted June 30, 2014 What is the purpose of weighting over such a relatively short period? With that degree of weighting it won't be long before you're as well discounting anything more than 5 years old - if you keep the thing running. Unless it's an ongoing "last 5 seasons" with the oldest dropping off? In which case, weighting makes less sense for a relatively short window. Bo'ness have got a really consistent record in the last 5 seasons but the weighting doesn't feel right if a club like the Rose has won the thing and reached the final in 2 of the last 5 seasons and that record positions them 100s of points behind. Link to comment Share on other sites More sharing options...
LongTimeLurker Posted June 30, 2014 Share Posted June 30, 2014 The five year thing makes it like the euro coefficient system? Edit: another snippet that might be of interest is that the top north region club is Culter in 54th place, followed by Deveronside in 68th and Hermes in 71st. Link to comment Share on other sites More sharing options...
jimbaxters Posted June 30, 2014 Share Posted June 30, 2014 What is the purpose of weighting over such a relatively short period? With that degree of weighting it won't be long before you're as well discounting anything more than 5 years old - if you keep the thing running. Unless it's an ongoing "last 5 seasons" with the oldest dropping off? In which case, weighting makes less sense for a relatively short window. Bo'ness have got a really consistent record in the last 5 seasons but the weighting doesn't feel right if a club like the Rose has won the thing and reached the final in 2 of the last 5 seasons and that record positions them 100s of points behind. The boy's done well to put the thing together for 5 seasons. What does it matter how long it was over? As long as everyone knows the scoring system used then they know what it's based on. It's obviously a gauge of consistency. If you want a gauge of cup winning success then count the stars on the club shirts. Link to comment Share on other sites More sharing options...
jimbaxters Posted June 30, 2014 Share Posted June 30, 2014 Excellent work. Good to see us in the top 10, hope we can stay there. I heard your team made it to the semi final two seasons ago. Is that right? Link to comment Share on other sites More sharing options...
db11 Posted June 30, 2014 Share Posted June 30, 2014 The five year thing makes it like the euro coefficient system? Edit: another snippet that might be of interest is that the top north region club is Culter in 54th place, followed by Deveronside in 68th and Hermes in 71st. The coefficient system takes into account the last five years - there is no weighting the fifa world rankings have a similar weighting system Link to comment Share on other sites More sharing options...
paulc Posted June 30, 2014 Author Share Posted June 30, 2014 What is the purpose of weighting over such a relatively short period? With that degree of weighting it won't be long before you're as well discounting anything more than 5 years old - if you keep the thing running. Unless it's an ongoing "last 5 seasons" with the oldest dropping off? In which case, weighting makes less sense for a relatively short window. Bo'ness have got a really consistent record in the last 5 seasons but the weighting doesn't feel right if a club like the Rose has won the thing and reached the final in 2 of the last 5 seasons and that record positions them 100s of points behind. Perhaps you missed this. "When Round 1 2014-15 is completed Round 1 2009-10 will drop out of the calculations and the highest weight of 60 will apply to Round 1 2014-15 and Rounds 2-Final 2013-14 etc." FIFA also weights the results from the previous 5 seasons. Linlithgow won the Cup in the most distant season covered - soon to disappear from the index! In three of the five seasons covered they failed to win a single game in one, and won just a single tie in each of the other two. Over the 5 seasons Bo'ness won 22 ties and Linlithgow 15. I am considering changing the weighting. Currently it is 20-30-40-50-60 (FIFA uses 20-40-60-80-100). I might favour a tighter weighting 20-25-30-35-40 so that results in season 5 have double the weight in season 1 compared to 3 times the weight at present (With FIFA it is 5 times the weight). Link to comment Share on other sites More sharing options...
CLYDEBANK Posted June 30, 2014 Share Posted June 30, 2014 I'm surprised we got in the top 60! We've not had much luck in the draw in the early rounds in the last five years, drawing Talbot (away), Linlithgow Rose (away),Bonnyrigg Rose (away), Bathgate (away), Glenafton (away) and Irvine Meadow (away). ..........maybe a bit luckier next time! Link to comment Share on other sites More sharing options...
superbigal Posted June 30, 2014 Share Posted June 30, 2014 Am I missing something ? Are points scored for getting a bye in round 1 ? Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.