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

rlrl

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

rlrl

To make it work everytime the spreadsheet opens you have to do the followingOffice 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

BE 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.


rlrl


OpenOffice version come soon, just converting it.


(If anyone wants a game by game stats file, I have made one rlhererl)

Cool. Thanks for your hard work.

Latest Updates as of 14/01/2011http://img543.imageshack.us/img543/7111/progresso.jpg" >rl

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 herehttp://www.halifaxcomputers.co.uk/billy/excel.gif" >rl

Well done, fella!

Download herehttp://www.halifaxcomputers.co.uk/billy/excel.gif" >rl

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.

rlrl

rlrl

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

At last the open office version works. Sorry for the delay, it's been a journey, ha ha!

Download OpenOffice version (3.2.1) herehttp://www.halifaxcomputers.co.uk/billy/ods.jpg" >rl

Download Official Excel version herehttp://www.halifaxcomputers.co.uk/billy/xls.jpg" >rl

Data Update Available 5th February 2011

Toulouse 40 - 38 Dewsbury

Player and fixture data now available for updating

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?