Get documents about "Vets auto League score sheet - Excel
Shared by: jaboxer
-
Stats
- views:
- 303
- posted:
- 7/31/2009
- language:
- English
- pages:
- 11
Document Sample
Midland VeteransTrack and Field League Men
Division East at Rugby
Date 8/7/2009 Match 3
Club:- Charnwood Harborough Leamington 0 R & N Lions R & N Saints Nuneaton Tamworth
EVENT Number 51-52/R Pts 25-26/Q Pts 31-32/S Pts 15-16/ Pts 29-30/E Pts 33-34 Pts 7-8./I Pts 17-18/L Pts
Name Tim Barton Dean Rushby Dom Browne 0 Ian Gidley Geoff Powell 0 Paul Tasker
M35 100m Perf. 12.2 8 14.4 4 13.1 5 12.8 7 12.9 6
Name Chris Ashmore 0 Chris Georgion 0 Clive Morrison David Ronchetti Terry Selway Carlton McDonald
M40 100m Perf. 12.3 7 12.4 6 12.1 8 13.8 3 13.6 4 12.6 5
Name Alan Baxter Tony Harrison Phil Clayton 0 Alan Hull Dave Bunker 0 0
M50 100m Perf. 13.4 7 14.6 5 13.1 8 14.2 6 15.6 4 16.4 3
Name Adrian Booth Dean Rushby Tony Foster 0 Paul Crocker David Ronchetti 0 Paul Tasker
M35 400m Perf. 63.9 4 68.7 3 62.0 6 62.6 5 61.8 7 56.7 8
Name Kevin Pye 0 Mark Wise 0 Mike Lewis Adrian White Eric Fowler Carlton McDonald
M40 400m Perf. 59.0 7 64.8 3 59.6 5 59.4 6 65.9 2 60.7 4 58.7 8
Name Malcolm Baxter Stuart Avins Laurie Dunne 0 Dave Cowley John Heywood Geoff Hudson 0
M60 400m Perf. 72.9 6 77.0 4 67.0 8 69.0 7 91.4 3 76.1 5
Name Alan Baxter Dean Rushby Darren Woodward 0 Steve Harris Mark Barrowclough Steve Arnold Mark Williams
M35 2K walk Perf. 13:51.5 2 13:22.3 3 0.0 4 11:37.3 5 11:26.0 6 09:54.7 7 08:55.7 8
Name Dave Harmer David Oram Andy Johnson 0 Paddy Lynch John Love Colin Turner John Culshaw Snr
M60 2K walk Perf. 12:31.3 7 DSQ 14:02.9 6 DSQ 14:35.1 4 10:35.9 8 14:30.1 5
Name 0 0 Bernie Gaffney 0 Paul Birch Dave Parkin Steve Tampin Howard Bush
M35 1500m Perf. 06:33.1 3 04:30.5 8 04:36.0 7 04:50.5 5 04:52.3 4 04:39.2 6
Name 0 Will Clap Dave Ashworth 0 Terry Egan Brian Summers Eric Fowler Andrew Wright
M40 1500m Perf. 04:40.2 6 04:31.0 7 04:45.0 5 04:51.7 4 04:30.9 8
Name Steve Nelson Tony Harrison Alex Montgomery 0 Terry Aitkens Neil Glover 0 Glyn Brown
M50 1500m Perf. 05:26.3 5 05:11.7 6 05:09.8 7 05:08.9 8 05:31.5 4 05:44.4 3
Name John Statham Will Clap Chris Georgion 0 Alan Hull John Love Terry Selway Carlton McDonald
Relay Medley Tim Barton Tony Harrison Phil Clayton 0 Clive Morrison Mark Barrowclough Geoff Hudson Gavin Showell
(200,200,400 Chris Ashmore A Pitcher Mark Wise 0 Terry Egan Greg Spellman Eric Fowler Paul Tasker
,800)
Kevin Pye Stuart Avins Tony Foster 0 Paul Birch Dave Parkin Steve Tampin Howard Bush
Perf. 04:05.0 8 04:32.7 3 04:24.1 5 04:17.8 6 04:30.9 4 04:36.0 2 04:06.6 7
TOTALS
64 37 75 0 70 46 37 64
(track)
7/31/2009 f5a45629-594f-417f-a703-4f6d7d914717.xls 1
Midland VeteransTrack and Field League Men
Division East at Rugby
Date 8/7/2009 Match 3
Club:- Charnwood Harborough Leamington 0 R & N Lions R & N Saints Nuneaton Tamworth
EVENT Number 51-52/R Pts 25-26/Q Pts 31-32/S Pts 15-16/ Pts 29-30/E Pts 33-34 Pts 7-8./I Pts 17-18/L Pts
M50 Name Dave Harmer 0 Mick Aston 0 Dave Cowley Frank Blackwell 0 0
Pole Vault Perf. 1.80 5.5 1.80 5.5 2.50 8 1.90 7
M35 Name Chris Ashmore Andy Wilkinson Darren Woodward 0 Paul Crocker David Ronchetti Terry Selway Gavin Showell
Pole vault Perf. 3.00 7 1.90 4 2.50 5 1.50 3 2.70 6 3.70 (LR?) 8
Name Dave Harmer Stuart Avins Laurie Dunne 0 Dave Cowley John Love 0 Colin Green
M60 High J Perf. 1.20 4 1.30 5.5 1.30 5.5 1.35 8 1.00 3 1.35 7
Name John Statham Andy Wilkinson David Phillips 0 John Moreland Frank Blackwell Craig Mills John Culshaw Jnr
M40 Discus Perf. 19.71 4 14.93 2 23.80 6 40.42 8 21.54 5 19.19 3 25.83 7
Name Paul Askew Tony Harrison Tony Foster 0 Dave Cowley Frank Blackwell 0 Colin Green
M50 Triple J Perf. 7.12 3 8.42 6 8.25 4 9.80 8 8.79 7 8.26 5
Name B Hawkesworth Tony Harrison Dom Browne 0 John Moreland Frank Blackwell 0 Phil Owen
M50 Shot Perf. 9.31 7 7.51 5 7.58 6 11.57 8 7.31 4 7.20 3
Name Chris Ashmore Tony Harrison Chris Georgion 0 Paul Crocker David Ronchetti Terry Selway John Culshaw Jnr
M40 Long J Perf. 5.28 8 4.12 3 4.91 7 4.50 4 4.11 2 4.78 6 4.50 5
Name B Hawkesworth Stuart Avins Dai Vaughan 0 Dave Cowley John Love 0 Phil Owen
M60 Discus Perf. 34.91 8 24.40 4 22.82 3 31.22 6 25.77 5 32.00 7
Field Totals 39.5 32.5 41 0 55 36 15 42
Track Totals 64 37 75 0 70 46 37 64
Final
TOTALS 103.5 69.5 116 0 125 82 52 106
Positions (Team) 4 6 2 1 5 7 3
Other results
Adrian Booth 100m 13.6 Henry Mortimer 1500m 05:53.0 Dave Bunker 2K Walk 14:30.1
Steve Nelson 100m Mark Mcaleehan 100m 13.0 Andrew Johnson
Steve Nelson Long Jump Steve Webb 400m 64.5? John Culshaw
John Statham 100m Andy Johnson John Heywood 1500m 06:13.0
John Culshaw 2k Walk 11:03.1 Greg Spellman
David Phillips 400m 63.0? Jason Love 1500m 04:53.3
Note;- All events + Relays Score ; 8,7,6,5,4,3,2,1
7/31/2009 f5a45629-594f-417f-a703-4f6d7d914717.xls 2
Division East at Rugby 8/7/2009 Midland Veteran's Track and Field League 2009 Women
Match 3
Club:- Charnwood Harborough Leamington 0 R & N Lions R & N Saints Nuneaton Tamworth
EVENT Number 91-92/R Pts 75-76/Q Pts 81-82/S Pts 65-66/M Pts 79-80/E Pts 83-84 Pts 57-58/I Pts 67-68/L Pts
100m Name Tanya Goodwin Nicki James Lorraine Benton 0 Tracy Webb Christine Hawker 0 0
W35 Perf. 17.1 5 18.2 4 16.0 6 13.9 8 14.3 7
100m Name Sophia Howard Jill Roginski Cathy Lyon Green 0 Juliette Crossin Sally Hine 0 Cathy Lyon Green
W40 Perf. 17.7 4 16.5 5 15.1 7 13.9 8 15.9 6 18.6 3
100m Name 0 Jenny Jones June Johnson 0 Chris Cox Barbara Parkinson Viv Kirkland 0
W60 Perf. 35.8 4 21.7 5 16.6 8 18.0 6 17.5 7
400m Name Sophia Howard Nicki James Carol Blower 0 Tracy Webb Christine Hawker 0 0
W35 Perf. 77.0 5 76.8 6 89.0 4 62.6 8 71.1 7
400m Name NickyThompson Ruth Bingham Judith Hanlon 0 Lesley Willis Kate Williams Mary Hall 0
W40 Perf. 78.8 6 87.2 4 72.6 7 67.0 8 81.2 5
400m Name 0 Jill Roginski Lorraine Benton 0 Angel Copson Sally Hine 0 0
W50 Perf. 83.0 6 83.9 5 76.9 8 82.5 7
2Km Walk Name Sophia Howard Yvonne Barber 0 0 Ann Rollins Val Cross Ann Wheeler 0
W40 Perf. 13:37.0 6 15:06.3 4 13:22.6 7 14:40.6 5 10:48.3 8
2Km Walk Name Sylvia Johnson Jenny Jones June Johnson 0 Carol Birch Barbara Parkinson Viv Kirkland 0
W60 Perf. 17:57.1 4 18:42.7 3 15:14.3 6 12:47.4 8 14:47.5 7 15:21.7 5
1500m Name Sophia Howard Hannah Eveleigh Carol Blower 0 Jo Love Kate Williams 0 0
W35 Perf. 06:13.0 6 05:11.3 8 06:28.5 4 06:00.2 7 06:15.2 5
1500m Name NickyThompson Karen Brooks Monica Williamson 0 Michelle Leach Linda Carter Mary Hall 0
W40 Perf. 05:32.9 6 05:40.3 5 05:09.3 8 5;44.5 4 05:58.8 3 5.16.3 7
1500m Name 0 0 June Johnson 0 Angela Copson Barbara Parkinson 0 0
W60 Perf. 06:42.1 6 05:23.7 (LR?) 8 06:33.5 7
Relay Names 0 Jill Roginski Lorraine Benton 0 Juliette Crossin Sally Hine 0 0
Medley
0 Karen Brooks Judith Hanlon 0 Lesley Willis Linda Carter 0 0
0 Nicki James Carol Blower 0 Tracy Webb Chris Hawker 0 0
(200,200,
0 Hannah Eveleigh Monica Williamson 0 Michelle Leach Kate Williams 0 0
400,800) Perf. 5.11.0 6 5.10.3 7 4.56.3 8 5.30.4 5
TOTALS 42 55 65 0 90 70 27 3
(track)
7/31/2009 f5a45629-594f-417f-a703-4f6d7d914717.xls 3
Division East at Rugby 8/7/2009 Midland Veteran's Track and Field League 2009 Women
Match 3
Club:- Charnwood Harborough Leamington Mansfield R & N Lions R & N Saints Nuneaton Tamworth
EVENT Number 91-92 Pts 75-76 Pts 81-82 Pts 65-66 Pts 79-80 Pts 83-84 Pts 57-58/I Pts 67-68 Pts
W35 Name Dorothy Rubery 0 Manjit Bain 0 Debbie Murch Jayne Scales 0 0
Hammer Perf. 22.27 6 27.00 7 27.47 8 17.46 5
W50 Name Elaine Mee Jill Roginski Lorraine Benton 0 Chris Cox Sally Hine Viv Kirkland 0
Hammer Perf. 16.83 5 23.91 8 13.77 4 18.25 6 21.04 7
W40 Name Sophia Howard Jill Roginski Judith Hanlon 0 Lesley Willis Chris Hawker Viv Kirkland Cathy Lyon Green
Long J Perf. 3.56 7 3.16 4 3.54 6 4.20 (LR?) 8 3.18 5 2.76 3
W35 Name Dorothy Rubery Jill Roginski Manjit Bain 0 Tracey Webb Jayne Scales Viv Kirkland 0
Discus Perf. 13.62 4 16.73 6 18.05 8 14.22 5 17.47 7 13.08 3
Name 0 0 0 0 0 0 0 0
Spare Perf.
Field
Totals 22 18 25 0 27 12 15 3
Track
Totals 42 55 65 0 90 70 27 3
Final
TOTALS 64 73 90 0 117 82 42 6
Positions (Team) 5 4 2 1 3 6 7
Note;- All events + Relays Score 8,7,6,5,4,3,2,1
GUESTS
7/31/2009 f5a45629-594f-417f-a703-4f6d7d914717.xls 4
Midland Vets League (east) 2009
Overall Positions
Men
Match 1
Match 2 Tamworth Match 3 Rugby Match 4 Nuneaton
Leamington
Total
Total Total Total Total Total
Team
Score Lge Pts Score Lge Pts Score Lge Pts Score Lge Pts League Position
score Pts score Pts score
Pts
R & N(lions) 121 8 125 8 245.5 16 125 8 370.5 24 370.5 24 1
Leamington 108 7 97 5 205 12 116 7 321 19 321 19 2
Charnwood 93 5.5 115 7 208 12.5 103.5 5 311.5 17.5 311.5 17.5 3
Tamworth 93 5.5 98 6 191 11.5 106 6 297 17.5 297 17.5 4
R & N(Saints) 72 4 84.5 4 156.5 8 82 4 238.5 12 238.5 12 5
Harborough 71 3 44 2 115 5 69.5 3 184.5 8 184.5 8 6
Nuneaton 64 2 53 3 117 5 52 2 169 7 169 7 7
0 0 0 0 0 0
Women
Match 1
Match 2 Tamworth Match 3 Rugby Match 4 Nuneaton
Leamington
Total
Total Total Total Total Total
Team
Score Lge Pts Score Lge Pts Score Lge Pts Score Lge Pts League Position
score Pts score Pts score
Pts
R & N(lions) 115 8 106 8 221 16 117 8 338 24 338 24 1
Leamington 77 6 56 5 133 11 90 7 223 18 223 18 2
R & N(Saints) 78 7 48 4 126 11 82 6 208 17 208 17 3
Charnwood 70 5 74 7 144 12 64 4 208 16 208 16 4
Harborough 40 4 67 6 107 10 73 5 180 15 180 15 5
Nuneaton 25 3 33 3 58 6 42 3 100 9 100 9 6
Tamworth 9 2 32 2 41 4 6 2 47 6 47 6 7
0 0 0 0 0 0
Original sheet
Dave Cowley
f5a45629-594f-417f-a703-4f6d7d914717.xls cowleyclan@talk21.com 7/31/2009
Mens Declaration Vets Eastern League 2009 match 3 Rugby
Club:- Charnwood Harborough Leamington R & N Lions R & N Saints Nuneaton
Events 51-52/R 25-26/Q 31-32/S 15-16/ 29-30/E 33-34 7-8./I
M35 100m Tim Barton Dean Rushby Dom Browne Ian Gidley Geoff Powell
M40 100m Chris Ashmore Chris Georgion Clive Morrison David Ronchetti Terry Selway
M50 100m Alan Baxter Tony Harrison Phil Clayton Alan Hull Dave Bunker
M35 400m Adrian Booth Dean Rushby Tony Foster Paul Crocker David Ronchetti
M40 400m Kevin Pye Mark Wise Mike Lewis Adrian White Eric Fowler
M60 400m Malcolm Baxter Stuart Avins Laurie Dunne Dave Cowley John Heywood Geoff Hudson
M35 2K walk Alan Baxter Dean Rushby Darren Woodward Steve Harris Mark Barrowclough Steve Arnold
M60 2K walk Dave Harmer David Oram Andy Johnson Paddy Lynch John Love Colin Turner
M35 1500m Bernie Gaffney Paul Birch Dave Parkin Steve Tampin
M40 1500m Will Clap Dave Ashworth Terry Egan Brian Summers Eric Fowler
M50 1500m Steve Nelson Tony Harrison Alex Montgomery Terry Aitkens Neil Glover
John Statham Will Clap Chris Georgion Alan Hull John Love Terry Selway
Relay Medley Tim Barton Tony Harrison Phil Clayton Clive Morrison Mark Barrowclough Geoff Hudson
(200,200,400,800) Chris Ashmore A Pitcher Mark Wise Terry Egan Greg Spellman Eric Fowler
Kevin Pye Stuart Avins Tony Foster Paul Birch Dave Parkin Steve Tampin
M50 Pole Vault Dave Harmer Mick Aston Dave Cowley Frank Blackwell
M35 Pole vault Chris Ashmore Andy Wilkinson Darren Woodward Paul Crocker David Ronchetti Terry Selway
M60 High J Dave Harmer Stuart Avins Laurie Dunne Dave Cowley John Love
M40 Discus John Statham Andy Wilkinson David Phillips John Moreland Frank Blackwell Craig Mills
M50 Triple J Paul Askew Tony Harrison Tony Foster Dave Cowley Frank Blackwell
M50 Shot B Hawkesworth Tony Harrison Dom Browne John Moreland Frank Blackwell
M40 Long J Chris Ashmore Tony Harrison Chris Georgion Paul Crocker David Ronchetti Terry Selway
M60 Discus B Hawkesworth Stuart Avins Dai Vaughan Dave Cowley John Love
Guests Adrian Booth David Philips John Heywood
Steve Nelson Henry Mortimore Greg Spellman
John Statham Mark McAleeham Jason Love
Steve Webb Dave Bunker
Andy Johnson
f5a45629-594f-417f-a703-4f6d7d914717.xls
Mens Declaration Vets Eastern League 2009 match 3 Rugby
Tamworth
17-18/L
Paul Tasker
Carlton McDonald
Paul Tasker
Carlton McDonald
Mark Williams
John Culshaw Snr
Howard Bush
Andrew Wright
Glyn Brown
Carlton McDonald
Gavin Showell
Paul Tasker
Howard Bush
Gavin Showell
Colin Green
John Culshaw Jnr
Colin Green
Phil Owen
John Culshaw Jnr
Phil Owen
John Culshaw
f5a45629-594f-417f-a703-4f6d7d914717.xls
Womens Declarations Eastern vets Match 3, 2009 Rugby
Club:- Charnwood Harborough Leamington R & N Lions R & N Saints Nuneaton Tamworth
Events 91-92/R 75-76/Q 81-82/S 65-66/M 79-80/E 83-84 57-58/I 67-68/L
100m W35 Tanya Goodwin Nicki James Lorraine Benton Tracy Webb Christine Hawker
100m W40 Sophia Howard Jill Roginski Judith Hanlon Juliette Crossin Sally Hine Cathy Lyon Green
100m W60 Jenny Jones June Johnson Chris Cox Barbara Parkinson Viv Kirkland
400m W35 Sophia Howard Nicki James Carol Blower Tracy Webb Christine Hawker
400m W40 NickyThompson Ruth Bingham Judith Hanlon Lesley Willis Kate Williams Mary Hall
400m W50 Jill Roginski Lorraine Benton Angel Copson Sally Hine
2Km Walk W40 Sophia Howard Yvonne Barber Ann Rollins Val Cross Ann Wheeler
2Km Walk W60 Sylvia Johnson Jenny Jones June Johnson Carol Birch Barbara Parkinson Viv Kirkland
1500m W35 Sophia Howard Hannah Eveleigh Carol Blower Jo Love Kate Williams
1500m W40 NickyThompson Karen Brooks Monica Williamson Michelle Leach Linda Carter Mary Hall
1500m W60 June Johnson Angela Copson Barbara Parkinson
Jill Roginski Lorraine Benton Juliette Crossin Sally Hine
Relay Medley Karen Brooks Judith Hanlon Lesley Willis Linda Carter
(200,200,400,800) Nicki James Carol Blower Tracy Webb Chris Hawker
Hannah Eveleigh Monica Williamson Michelle Leach Kate Williams
W35 Hammer Dorothy Rubery Manjit Bain Debbie Murch Jayne Scales
W50 Hammer Elaine Mee Jill Roginski Lorraine Benton Chris Cox Sally Hine Viv Kirkland
W40 Long J Sophia Howard Jill Roginski Judith Hanlon Lesley Willis Chris Hawker Viv Kirkland Cathy Lyon Green
W35 Discus Dorothy Rubery Jill Roginski Manjit Bain Tracey Webb Jayne Scales Viv Kirkland
Spare
f5a45629-594f-417f-a703-4f6d7d914717.xls
This score sheet has declaration sheets which automatically add the names and events to the result
On the results sheets the scores will add up automatically and be shown at the bottom of the page,
for giving interim scores!. Transfer the final results to the positions sheet which will also auto add.
Notes on using Vets League Score Sheet
1 Look through the tabs at the bottom of the Page and see what
the sheets say before changing anything.
2 Make a backup copy just in case!!
y
ition da
Good idea to try your printers now, see all sheets print OK
(landscape)
Compet
3 Go to the Grey Men dec / women dec tabs
4 Delete the names [on this sheet only not the reults sheet] not
the events!!! (If names present!) (the
Before
names were only left in to illustrate how it works) Check ALL
the Headers and Footers are correct. [see View]
5 Resave with your own Name [eg VetsL09m1]
Try and Have a reader to help you enter the results on the day
6
sults
In The declaration sheets Put in the team and Numbers; under
each team fill in names. Put in the Initial + surnames in the
first re
correct columns from the declaration sheets (Short names can
go in completely but long names will cause problems printing).
Before
7 Check the names have automatically appeared on the
appropriate score sheet; If correct SAVE
8 Repeat steps 6+7 for Men dec/women dec.
results
9 After entering all the names select the results tab Men or
Women Then find the event you need
10 Enter performance under name
r
To ente
11 Enter score in correct column to the right
12 Check the scores have added at the bottom
13 Save every few events for safety
14 When all events are entered check no spaces are left
s
e result
15 If all is correct Save!!
plete th
results 16 Determine positions of clubs from scores and add to bottom
line. Save again.
lete the
17 Print a copy IF OK run rest off
18 Transfer results to positions sheet (print out is helpful here)
19 If clever with excel sort on column P then Q Need to highlight
p
To Com
women's and men's results separately.
20 Check positions are correct and SAVE
21 Print a copy IF OK run rest off
22 Well done get out the whisky!!!!!
ANY Problems on the day Shout for DAVE Cowley
GOOD LUCK!!
After match send copies of all sheets and declarations to Area
Secretary.
NB if events different change on declaration sheet not score sheet
es and events to the results sheet.
at the bottom of the page, useful
et which will also auto add.
If you are NOT the first
match of the year:-
Update the Final
position scores from
the previous match(es)
Before the Day of
competition
If Not from the east
change the names and
Numbers
Related docs
