|
|
Rank | Posts | Team |
Player Coach | 1067 | No Team Selected |
Joined | Service | Reputation |
Mar 2006 | 19 years | |
Online | Last Post | Last Page |
Aug 2020 | Jan 2012 | LINK |
Milestone Posts |
|
Milestone Years |
|
Location |
|
Signature |
TO BE FIXED |
|
| Quote ="bluenwhite"Hi Billy
Without sounding patronising, I would like to say what a superb spreadsheet you have developed.
A couple of points Billy.
Row 28 - Featherstone Rovers v Barrow Raiders should be 14th April and not 14th March.
Also on the teamsheets, Andrew Henderson should be Squad No 9 Hooker and Mitch should be Squad No 8 I think.
I am an Excel user myself and produce lots of cost reports, the work that has gone into this must have been exhausting. It is truely a magnificent effort.
Thank you for your efforts.
Regards
Tez, bluenwhite'"
Thanks for your kind words Tez, always appreciated.
I will get round to sorting out those problems tomorrow. Many thanks for your input and don't hesitate to get in touch if you have any suggestions or find any errors.
Billy
|
|
|
Rank | Posts | Team |
Player Coach | 1067 | No Team Selected |
Joined | Service | Reputation |
Mar 2006 | 19 years | |
Online | Last Post | Last Page |
Aug 2020 | Jan 2012 | LINK |
Milestone Posts |
|
Milestone Years |
|
Location |
|
Signature |
TO BE FIXED |
|
|
At last the open office version works. Sorry for the delay, it's been a journey, ha ha!
Download OpenOffice version (3.2.1) here: [url=http://www.halifaxcomputers.co.uk/billy/c2011.ods [/url
Download Official Excel version here: [url=http://www.halifaxcomputers.co.uk/billy/c2011.xls [/url
|
|
|
|
Rank | Posts | Team |
Player Coach | 1067 | No Team Selected |
Joined | Service | Reputation |
Mar 2006 | 19 years | |
Online | Last Post | Last Page |
Aug 2020 | Jan 2012 | LINK |
Milestone Posts |
|
Milestone Years |
|
Location |
|
Signature |
TO BE FIXED |
|
| =#FF0000Data Update Available:
Fixture and player data updates available for the following fixtures within Championship 2011 spreadsheet
=#0000BFFeatherstone 54 - 10 Oldham
Swinton 22 - 28 Halifax
[uNotes:[/u
- Player updates can be done by using the [i'Download Statistics'[/i button within [i'Player Stats'[/i sheet.
- Fixture updates can be done by using [i'Load Results'[/i button within [i'League Table'[/i sheet.
- [iPlayer Stats[/i allows you to see Leading Try Scorers, Goal Scorers, Points Scorers and each Championship teams player data.
- [iPlayer Stats[/i include all Nothern Rail Cup, Challenge Cup and Championship (including play offs) games through the season.
|
|
|
Rank | Posts | Team |
Player Coach | 1067 | No Team Selected |
Joined | Service | Reputation |
Mar 2006 | 19 years | |
Online | Last Post | Last Page |
Aug 2020 | Jan 2012 | LINK |
Milestone Posts |
|
Milestone Years |
|
Location |
|
Signature |
TO BE FIXED |
|
| =#FF0000Data Update Available: 5th February 2011
=#0000BFToulouse 40 - 38 Dewsbury
Player and fixture data now available for updating
|
|
|
Rank | Posts | Team |
International Board Member | 8296 | No Team Selected |
Joined | Service | Reputation |
Jun 2003 | 22 years | |
Online | Last Post | Last Page |
Mar 2018 | May 2017 | LINK |
Milestone Posts |
|
Milestone Years |
|
Location |
|
Signature |
TO BE FIXED |
|
| Just updated the results/fixtures in the OpenOffice spreadsheet, no problem. Tried dong the stats page and it just says calculating for about 1 min before returning a page with just #N/A in every box. Glitch?
|
|
|
|
Rank | Posts | Team |
Player Coach | 1067 | No Team Selected |
Joined | Service | Reputation |
Mar 2006 | 19 years | |
Online | Last Post | Last Page |
Aug 2020 | Jan 2012 | LINK |
Milestone Posts |
|
Milestone Years |
|
Location |
|
Signature |
TO BE FIXED |
|
| =#FF0000Data Update Available: 6th February 2011
=#0000BFBarrow 24-20 York
Batley 4-24 Leigh
Gateshead 20-32 Sheffield
Skolars 18-62 Widnes
Oldham 28-22 Hunslet
Player and fixture data now available for updating
|
|
|
Rank | Posts | Team |
Player Coach | 1067 | No Team Selected |
Joined | Service | Reputation |
Mar 2006 | 19 years | |
Online | Last Post | Last Page |
Aug 2020 | Jan 2012 | LINK |
Milestone Posts |
|
Milestone Years |
|
Location |
|
Signature |
TO BE FIXED |
|
| Quote ="Tortured Soul"Just updated the results/fixtures in the OpenOffice spreadsheet, no problem. Tried dong the stats page and it just says calculating for about 1 min before returning a page with just #N/A in every box. Glitch?'"
Ok, will check that now
|
|
|
Rank | Posts | Team |
Club Coach | 16474 | No Team Selected |
Joined | Service | Reputation |
May 2005 | 20 years | |
Online | Last Post | Last Page |
Apr 2016 | Feb 2016 | LINK |
Milestone Posts |
|
Milestone Years |
|
Location |
|
Signature |
TO BE FIXED |
|
| This is excellent, well done Billyfax.
|
|
|
|
Rank | Posts | Team |
Player Coach | 1067 | No Team Selected |
Joined | Service | Reputation |
Mar 2006 | 19 years | |
Online | Last Post | Last Page |
Aug 2020 | Jan 2012 | LINK |
Milestone Posts |
|
Milestone Years |
|
Location |
|
Signature |
TO BE FIXED |
|
| Quote ="-VIKINGMAN-"This is excellent, well done Billyfax.'"
Thanks Vikingman, it always annoys me that you can never find out anything about our league stats. So I thought I would do them myself.
If anyone has suggestions then just let me know and I'll see what I can do.
|
|
|
Rank | Posts | Team |
Player Coach | 1067 | No Team Selected |
Joined | Service | Reputation |
Mar 2006 | 19 years | |
Online | Last Post | Last Page |
Aug 2020 | Jan 2012 | LINK |
Milestone Posts |
|
Milestone Years |
|
Location |
|
Signature |
TO BE FIXED |
|
| [size=150[u OpenOffice Fix[/u[/size
Slackness on my part meant one missing letter caused all the issues. Download repaired version below
Download OpenOffice version (3.2.1) here: [url=http://www.halifaxcomputers.co.uk/billy/c2011.ods [/url
|
|
|
Rank | Posts | Team |
International Board Member | 8296 | No Team Selected |
Joined | Service | Reputation |
Jun 2003 | 22 years | |
Online | Last Post | Last Page |
Mar 2018 | May 2017 | LINK |
Milestone Posts |
|
Milestone Years |
|
Location |
|
Signature |
TO BE FIXED |
|
| Quote ="billyfax"[size=150[uOpenOffice Fix[/u[/size
Slackness on my part meant one missing letter caused all the issues. Download repaired version below
Download OpenOffice version (3.2.1) here: [url=http://www.halifaxcomputers.co.uk/billy/c2011.ods[/url'"
No slackness at all, Billy. Works fine now.
TBH, fella, it's great that someone is willing to take the time to do this so that everyone has access to the stats in one place rather than searching the web for what they need. That can be a right bind as I found out when I used to do the fantasy league on RLFans.
Sterling work, mate.
|
|
|
|
Rank | Posts | Team |
Player Coach | 1067 | No Team Selected |
Joined | Service | Reputation |
Mar 2006 | 19 years | |
Online | Last Post | Last Page |
Aug 2020 | Jan 2012 | LINK |
Milestone Posts |
|
Milestone Years |
|
Location |
|
Signature |
TO BE FIXED |
|
| =#FF0000Data Update Available: 13th February 2011
=#0000BF
Saturday:
Widnes 44-28 Toulouse
Sunday:
Dewsbury 14-0 Keighley
Halifax 50-10 Oldham
Hunslet 8-12 Batley
Leigh 42-22 Swinton
Rochdale 18-30 Barrow
Sheffield 16-16 Whitehaven
York 22-32 Featherstone
Player and fixture data now available for updating
|
|
|
Rank | Posts | Team |
Player Coach | 1067 | No Team Selected |
Joined | Service | Reputation |
Mar 2006 | 19 years | |
Online | Last Post | Last Page |
Aug 2020 | Jan 2012 | LINK |
Milestone Posts |
|
Milestone Years |
|
Location |
|
Signature |
TO BE FIXED |
|
| =#FF0000Data Update Available: 20th February 2011
=#0000BF
Saturday:
Keighley 22-36 Toulouse
Sunday:
Batley 60-6 Gateshead
Barrow 22-28 Featherstone
Widnes 50-10 Rochdale
Whitehaven P-P Halifax
London Skolars 16-16 York
Leigh 68-6 Sheffield
Hunslet 30-0 Workington
Doncaster 18-30 Dewsbury
Player and fixture data for Championship teams now available for updating
|
|
|
Rank | Posts | Team |
Player Coach | 62 | No Team Selected |
Joined | Service | Reputation |
Jun 2007 | 18 years | |
Online | Last Post | Last Page |
Jul 2013 | Jul 2013 | LINK |
Milestone Posts |
|
Milestone Years |
|
Location |
|
Signature |
TO BE FIXED |
|
| I'm using the Open Office version
I find the scores page updates but the Player Stats although it appears to try and update, remain as they were after the first round of fixtures.
Any suggestions?
|
|
|
Rank | Posts | Team |
Player Coach | 1067 | No Team Selected |
Joined | Service | Reputation |
Mar 2006 | 19 years | |
Online | Last Post | Last Page |
Aug 2020 | Jan 2012 | LINK |
Milestone Posts |
|
Milestone Years |
|
Location |
|
Signature |
TO BE FIXED |
|
| Quote ="Cosmonaught"I'm using the Open Office version
I find the scores page updates but the Player Stats although it appears to try and update, remain as they were after the first round of fixtures.
Any suggestions?'"
Fixed - Cells were incorrectly protected
Download OpenOffice version (3.2.1) here: [url=http://www.halifaxcomputers.co.uk/billy/c2011.ods [/url
|
|
|
Rank | Posts | Team |
International Board Member | 8296 | No Team Selected |
Joined | Service | Reputation |
Jun 2003 | 22 years | |
Online | Last Post | Last Page |
Mar 2018 | May 2017 | LINK |
Milestone Posts |
|
Milestone Years |
|
Location |
|
Signature |
TO BE FIXED |
|
| Quote ="billyfax"Fixed - Cells were incorrectly protected
Download OpenOffice version (3.2.1) here: [url=http://www.halifaxcomputers.co.uk/billy/c2011.ods[/url'"
Another thing I have noticed since downloading this update is that on the player/team/point scorer pages is that they are ordered by appearances rather than highest point scorers. I don't know how you meant to do it, but I thought it may have been better to order them by points rather than apps. Not a criticism as i couldn't make tables like these, just a point.
|
|
|
Rank | Posts | Team |
Player Coach | 1067 | No Team Selected |
Joined | Service | Reputation |
Mar 2006 | 19 years | |
Online | Last Post | Last Page |
Aug 2020 | Jan 2012 | LINK |
Milestone Posts |
|
Milestone Years |
|
Location |
|
Signature |
TO BE FIXED |
|
| =#FF0000Data Update Available: 27th February 2011
=#0000BFToulouse 34 - 22 London Skolars
Featherstone 16 - 22 Widnes
York 28 - 22 Keighley
Sheffield 12 - 16 Hunslet
Workington 12 - 42 Leigh
Halifax 25 - 26 Batley
Dewsbury 16 - 12 Barrow
Player and fixture data for Championship teams now available for updating
|
|
|
Rank | Posts | Team |
Player Coach | 62 | No Team Selected |
Joined | Service | Reputation |
Jun 2007 | 18 years | |
Online | Last Post | Last Page |
Jul 2013 | Jul 2013 | LINK |
Milestone Posts |
|
Milestone Years |
|
Location |
|
Signature |
TO BE FIXED |
|
|
|
|
|
Rank | Posts | Team |
Player Coach | 4914 | No Team Selected |
Joined | Service | Reputation |
Apr 2009 | 16 years | |
Online | Last Post | Last Page |
Jan 2024 | Aug 2023 | LINK |
Milestone Posts |
|
Milestone Years |
|
Location |
|
Signature |
TO BE FIXED |
|
|
|
|
|
Rank | Posts | Team |
Player Coach | 1067 | No Team Selected |
Joined | Service | Reputation |
Mar 2006 | 19 years | |
Online | Last Post | Last Page |
Aug 2020 | Jan 2012 | LINK |
Milestone Posts |
|
Milestone Years |
|
Location |
|
Signature |
TO BE FIXED |
|
| =#FF0000Data Update Available: 5th March 2011
=#0000BF
Challenge Cup Games:
Featherstone 86 - 0 The Army
Leigh Miners 26 - 56 Barrow
Keighley 16 - 10 Toulouse
Player data now available for updating
|
|
|
Rank | Posts | Team |
Player Coach | 1067 | No Team Selected |
Joined | Service | Reputation |
Mar 2006 | 19 years | |
Online | Last Post | Last Page |
Aug 2020 | Jan 2012 | LINK |
Milestone Posts |
|
Milestone Years |
|
Location |
|
Signature |
TO BE FIXED |
|
| =#FF0000Data Update Available: 6th March 2011
=#0000BF
Challenge Cup Games:
Siddal 6 - 54 Widnes
Batley 64 - 10 Fryston
Leigh 68 - 24 Hull Dockers
Sheffield 82 - 0 Leeds Met
Northumbria University 0 - 132 York
South Wales 6 - 62 Dewsbury
Hunslet 48 - 10 Warrington Wizards
Halifax 76 - 6 Castleford Lock Lane
Player data now available for updating
|
|
|
Rank | Posts | Team |
Player Coach | 62 | No Team Selected |
Joined | Service | Reputation |
Jun 2007 | 18 years | |
Online | Last Post | Last Page |
Jul 2013 | Jul 2013 | LINK |
Milestone Posts |
|
Milestone Years |
|
Location |
|
Signature |
TO BE FIXED |
|
| Quote ="swifty62"sign petition for fax to get in SL and he might.'"
I'll back your bid if you back ours
I'd love to be surprised on 31st March and the RFL announce they're giving licences to two REAL teams (yours and mine), but sadly I can't see them abandoning their short-sighted ideas to keep propping up failing expansion teams.
|
|
|
Rank | Posts | Team |
Player Coach | 1067 | No Team Selected |
Joined | Service | Reputation |
Mar 2006 | 19 years | |
Online | Last Post | Last Page |
Aug 2020 | Jan 2012 | LINK |
Milestone Posts |
|
Milestone Years |
|
Location |
|
Signature |
TO BE FIXED |
|
| =#FF0000Data Update Available: 10th March 2011
=#0000BF
Championship:
Leigh 36 - 10 Featherstone
Player and fixture data for Championship teams now available for updating
|
|
|
Rank | Posts | Team |
Player Coach | 1067 | No Team Selected |
Joined | Service | Reputation |
Mar 2006 | 19 years | |
Online | Last Post | Last Page |
Aug 2020 | Jan 2012 | LINK |
Milestone Posts |
|
Milestone Years |
|
Location |
|
Signature |
TO BE FIXED |
|
| =#FF0000Data Update Available: 12th March 2011
=#0000BF
Championship:
Toulouse 26 - 12 Halifax
Player and fixture data for Championship teams now available for updating
|
|
|
Rank | Posts | Team |
Player Coach | 1067 | No Team Selected |
Joined | Service | Reputation |
Mar 2006 | 19 years | |
Online | Last Post | Last Page |
Aug 2020 | Jan 2012 | LINK |
Milestone Posts |
|
Milestone Years |
|
Location |
|
Signature |
TO BE FIXED |
|
| =#FF0000Data Update Available: 13th March 2011
=#0000BF
Championship:
Batley 28 - 0 Dewsbury
Hunslet 28 - 28 York
Sheffield 16 - 44 Widnes
Player and fixture data for Championship teams now available for updating
|
|
|
|
|