Star man.

Awesome work Billy, thanks
Tez

hi Billy need some help please. I'm running excell 2007 and i get this message when i open it.

cannot run the macro "championship2011.xls'!button2415_click' the macro may not be available in this workbook or all macros may be disabled

I downloaded the spreadsheet at work on an earlier version of excell and it works fine, but would really like it on my home pc.

your help would be much appreciated please

First you must click the Options button, shown below (highlighted orange above the formula bar)

[url=http://img218.imageshack.us/i/optionsy.jpg/[/url

Then select Enable this content and ok (as shown below)

[url=http://img401.imageshack.us/i/options1.jpg/[/url

To make it work everytime the spreadsheet opens you have to do the following:

1. Select Office File menu (Circle top left hand corner)
2. Click Excel Options (bottom right of the appering box)
3. On the window that appears selectr Trust
4. Now click the button on the right half of the window called Trust Settings
5. On the new window select Macro Settings
6. Select Enable all macros

=#FF0000BE WARNED ENABLING ALL MACROS CAN LEAD TO POTENTIALLY HARMFUL CODE AUTOMATICALLY RUNNING FROM WITHIN EXCEL FILES. Better to stick with the Options button as highlighted above if you are not familiar with VBA and Macros.

Thanks for that billy much appreciated

I'll stick to Fixing cars, they are much easier to fix than computers

Thanks again mate

Looking forward to the full version.

Regards
Tez

Just ironing out a few errors, will be up as soon as possible today.

Excel version now ready for download below. Images will open your default browser and go to relevant websites (excel version only). There is some data for you to look at the player stats but is test data only. Takes about 90 seconds to load.


[url=http://www.halifaxcomputers.co.uk/billy/c2011.xls[/url


OpenOffice version come soon, just converting it.


(If anyone wants a game by game stats file, I have made one [url=http://www.halifaxcomputers.co.uk/billy/Fax%20Stats%202011.xlshere[/url)

Cool. Thanks for your hard work.

Latest Updates as of 14/01/2011:

1. Squad updates for Barrow, Batley, Dewsbury, Featherstone, Hunslet (based on websites, may change). These will be updated as teams announce their squads and on appearances through the season.

2. progress form for when importing player statistics, so you don't think it has frozen. See image below
[url=http://img543.imageshack.us/i/progresso.jpg/[/url

3. Open office verison should be completed this evening or tomorrow at latest, sorry for the delay.

4. As you may or may not have noticed, this is now branded under Halifax RLFC logos. You can now download this spreadsheet as the official statistics for the rugby club from their website.


Download latest version here: [url=http://www.halifaxcomputers.co.uk/billy/c2011.xls[/url

Well done, fella!

Download here: [url=http://www.halifaxcomputers.co.uk/billy/c2011.xls[/url

Updated all squads now! (Hopefully they're right!)

Slight update to the program for importing stats. See screen shots below. Just gives you a live view of the stats importing on the import form and in the background the page will change to each section as it starts to import, giving you a view while you wait.

[url=http://img213.imageshack.us/i/progress1n.jpg/[/url

[url=http://img204.imageshack.us/i/progress2bu.jpg/[/url