I'll download openoffice and see what needs to change

Cheers for testing it.

I know I'm a pain, but I can't be bothered with Microsoft all the time, so OpenOffice does for me.

Cheers, fella!

I can see where the issue is and should hopefully have this sorted tomorrow.

Now updated for OpenOffice 3.1

Make sure the following options are checked to make sure Spreadsheet will work properly

=#FF0000Macro Security

Tools -> Options -> OpenOffice.org -> Security -> Macro Security (Button) -> Set to Medium
note - if you don't want a macro warning to enable macros everytime then set the option to Low. This is not recommended for other spreadsheets though.

=#FF0000Enable VBA Properties

Tools -> Options -> Load/Save -> VBA Properties

Make sure all tick boxes are enabled, especially the one called 'Executable Code' under Excel

=#408000You should now be able to use the button on the league menu. Please download the latest Excel spreadsheet [url=http://www.halifaxcomputers.co.uk/billy/c2010.xlshere[/url.

Works now.



Do I need to save it in its current format (excel), or can I save it in OpenOffice format?

Btw, att. for Blackpool v Keighley was 468.




Many thanks.

Cheers for the attendance TS, I've been looking all over for that one.

I've tried saving the spreadsheet as an =#408000Openoffice Spreadsheet (*.ods) and the functions still work fine so you should be ok to save it in Open Office format.

Thanks for all your help, Billy.

I've updated the super league spreasheet so it now does automated updates for fixtures from the league table page. Works with both Excel and OpenOffice.

You need to take a look at the NRC group results tables. They are out of kilter.

They look fine on mine. Try downloading [url=http://www.halifaxcomputers.co.uk/billy/c2010.odsthis version[/url which is a OpenOffice one that I use for testing.

I don't get it! Yesterday, when I updated the results, the tables were all over the place. Just checked again before I did anything else and they are fine. Bleeding pc's.

Yeah, computers are a pain. If they weren't I wouldn't have a job!



What you might find is, if it doesn't quite work if you close it and reopen it should be fine, as all tables are recalculated when you open the spreadsheet anyway.

Attendance for Blackpool game was 194.

I knew you'd come through for me on that one, cheers TS.

Updated first post with tables which I will keep up to date during season.

Fixed issue with average attendances in championship games.

[url=http://www.halifaxcomputers.co.uk/billy/c2010.xlsChampionship 2010[/url (Excel Version)

[url=http://www.halifaxcomputers.co.uk/billy/c2010.odsChampionship 2010[/url (Open Office Version)

For your deduction table: Keighley have been deducted 9pts for entering administration, I believe.

Updated spreadsheet so points column reads PD instead of GD and put Bonus point column in Main part of table as well as home and away sections.

Added Championship One Excel Spreadsheet. Go to first post or you can download it [url=http://www.halifaxcomputers.co.uk/billy/c1-2010.xlshere[/url.

You can update the quarter final draw by clicking in the Home or Away team box and selecting the team from the drop down box.

For those using the Automated update, the quarter finals should look like the following:



The final standings after all completed fixtures is as follows:

You need to add Keighley's points deduction. This is the RFL's official table. www.therfl.co.uk/~therflc/tables ... onalleague

You need to add Keighley's points deduction. This is the RFL's official table. www.therfl.co.uk/~therflc/tables ... onalleague

For some reason, it doesn't seem to be updating the championship spreadsheet when I click on the update button.

I will check that out today.

A bit of slack programming on my part. Fixed the OpenOffice one so it now works properly hopefully.

[url=http://www.halifaxcomputers.co.uk/billy/c2010.odsOpenOffice Version of Championship Spreadsheet[/url

For those using automated results update please set the NRC semi finals as follows: