Long Course Level 1 Licensed Open Meet
6/7th January 2007 (1EM7051)

Ponds Forge International Pool Sheffield

Using the links below you can view, save and print a text file listing all the accepted entries from your Club. The swimmers are listed in event order, showing their competitor number and the total number of competitors in the event.

The file is a tab separated, simple text file which is actually intended to be imported into a Spreadsheet program (like Microsoft Excel) and then with a few simple formatting operations it can produce a 'Splits Sheet' useful for Coaches and Team Managers to use on the day to record swimmers times. If you are interested in this scroll to the bottom of the list for a few basic pointers as to how to achieve the best results.

ASKERN SPA
BARROW ASC
BIDDULPH
BIGGLESWADE
BOLDMERE
BOLTON METRO
BRAMCOTE
BUXTON
CALVERTON
CO BIRM'HAM
CO CAMBRIDGE
CO DERBY
CO LEEDS
CO LEICESTER
CO MILTON K
CREWE FLYERS
DEEPINGS
DERBYPHOENIX
ETWALL
FALCON NTTM
GRANTHAM
GUERNSEY
KELLY COLL
KINGSTONHULL
LEANDER
LEEK
LINCOLN VULC
LOUGHBORO UN
LOUGHBOROUGH
LOUTH
LUTON
MATLOCK
MID BEDS
NEWARK
NEWCASTLE ST
NOVA CENT'N
OAKENGATES T
OLDHAM AQUA
PERTH CITY
PRESTON
RIPLEY
SADDLEWORTH
SHERWOOD
SHREWSBURY
STOCKPORT MO
STOCKSBRIDGE
SWADLINCOTE
SWINDON DOLP
TRENTON
TREONTE
TRIDENT
WARRINGTON W
WEAR VALLEY
WINDSOR
WINSFORD
WIRRAL METRO
WORCESTER
WORKSOP

Return to Top

Guidance on creating a Splits Sheet Spreadsheet

To save the data use the 'File - Save As' command on your Browser. Save the file as a TEXT (.TXT) file, NOT as a HTML file.

Open the file with your favorite Spreadsheet - remember to select 'Files of Type' to be Text Files or All Files (MS Excel will automatically recognise that it is a text file and start the Text Import Wizard).

Select 'Delimited' rather than 'Fixed Width' - click Next.

Make sure that the Delimiter TAB is ticked, but 'Treat Consecutive Delimiters as One' MUST be unticked - click Next.

VERY IMPORTANT - Scroll down in the Data Preview window until you can see the first swimmers, then select the column containing the Year of Birth, (click at the top of the column where its labeled General). The column will highlight. Then change its 'Column Data Format' from 'General' to 'Text'. If you forget to do this then Excel will probably interpret all the years as negative numbers and remove the brackets - its an accounting practice!

Click Finish and the file will be imported into a new spreadsheet window. You should already see the basic layout taking shape. Simply apply a few basic 'tidying up' formatting operations, for example:

Set Column Widths (suggest Col A = 5, Col B = 22, Col C = 5, Col D = 9)

Make the top 2 rows Bold and make the top 3 rows 'Title rows' so they print at the top of each page. Don't know how? - use File - Page Set up - Sheet, 'Rows to repeat at top' entry, (set to $1:$3)

Set print margins to suit your printer (and to make it fit across just one page) and turn Gridlines on. Don't know how? - use File - Page Set up - Sheet, and tick 'Gridlines' in the Print section.

Then save as an Excel worksheet (file type .xls) and try a printout. We hope you find this useful.

Return to Top