City
of Derby Swimming Club
Affiliated to ASA East Midland Region and
Derbyshire ASA
Twenty Fifth Short
Course Level 2 Licensed Open Meet
26th/27th April 2008 (2EM8051)
Queen's Leisure Centre, Derby
All entries have been accepted
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.
Click on your Club name to view your accepted entries. (Use the BACK button on your Browser to return to this screen).
Check out the Swimmer Information sheet here
ASHBOURNE
BELPERMARLIN
BERKHAMSTED
BIGGLESWADE
BRAMCOTE
BRIERLEY
BURTON
BUXTON
CALV BING
CHASE
CO CAMBRIDGE
CO DERBY
CO LINCOLN P
CO LIVERPOOL
CREWE FLYERS
DANE VALLEY
DERBYPHOENIX
DOVE VALLEY
DRONFIELD
ECKINGTON
ELLESMERE PT
ETWALL
EVERTON
FALCON NTTM
GRANTHAM
HADEN HILL
ILKESTON
KIMBERLEY
KINGSBURY
LEEK
LINCOLN VULC
LIVERPOOLPEN
LONG EATON
LOUTH
MANSFIELD
MATLOCK
NESTON
NORTHGATE
NOTTMLEANDER
NUNEATON
OAKENGATES
RIPLEY
ROTHWELL&DIS
RYKNELD
SANDBACH
SATELLITE
SHERWOOD
SHREWSBURY
SOUTH LINCS
STOCKPORT MO
STOURBRIDGE
SWADLINCOTE
WALLASEY
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.
|
Meet Menu Entries Programme Points Results
Session
One Word Session
One |
|
|
|
|
|
© City of Derby Swimming Club
|
