| This spreadsheet accepts the actual teams in
colums C and D below. Only cells with PINK background are editable.
Instructions start at cell I 15. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| TEAM |
LINE |
Partner |
Partner |
Pair |
Blue |
Orange |
Yellow |
Green |
Red |
Black |
|
| Blue |
1 |
Bernadette Hearns |
Audrey Duffy |
Bernadette Hearns
Audrey Duffy |
Bernadette Hearns
Audrey Duffy |
Emer MacDiarmada
Deirdre Clerkin |
Ciara Quinn Bernie
Caffrey |
Elizabeth Hunt
Deirdre Bennett |
Lana Kalejs Emma Ryan |
Gillian Fulcher Rhona
Brogan |
|
| Orange |
1 |
Emer MacDiarmada |
Deirdre Clerkin |
Emer MacDiarmada
Deirdre Clerkin |
Roisin Wallace Ger
Ryan |
Patricia Halford Ann
Finnegan |
Mary Hughes Susan
Ward |
Eva Greene Bernie
Doherty |
Rachel Murphy Jo
O'Brien |
Marjorie Flood Rita
Hayes |
|
| Yellow |
1 |
Ciara Quinn |
Bernie Caffrey |
Ciara Quinn Bernie
Caffrey |
Pauline Pardy Helen
Spillane |
Maureen McCullough
Maureen Neylon |
Paula Walsh Madeline
Morgan |
Margaret Gaynor
Oisine Hannon |
Deirdre Naughton
Marita McGeady |
Clare Garrihy Miriam
Rogers |
|
| Green |
1 |
Elizabeth Hunt |
Deirdre Bennett |
Elizabeth Hunt
Deirdre Bennett |
Judy Glynn Jean
Henneberry |
Catherine Keogh
Clodagh Shortall |
Therese Kilcline Mary
Taaffe |
Valerie Timon Bridie
Keegan |
Philippa Howley
Patricia Power |
Mairead Johnson
Grainne Doyle |
|
| Red |
1 |
Lana Kalejs |
Emma Ryan |
Lana Kalejs Emma Ryan |
Noreen Maher Edel
Clarke |
Ann Hawkshaw Teresa
Horan |
Angela McDonnell
Carmel Grogan |
Aideen Bracken Finola
Patten |
Eileen Ring Christina
Walsh |
Marian Cronin Susan
Mulholland |
|
| Black |
1 |
Gillian Fulcher |
Rhona Brogan |
Gillian Fulcher Rhona
Brogan |
Aisling O'Neill
Cliona Fitzsimons |
Clare Byrne Deirdre
Byrne |
Kay Terry Marian
O'Driscoll |
Derville Hoey
Patricia McCormack |
Maria Mitton Colette
Scrivener |
Mary Farrelly
Isabelle Benzini |
|
| Blue |
2 |
Roisin Wallace |
Ger Ryan |
Roisin Wallace Ger
Ryan |
Mairead Guiney Mary
Sullivan |
Angie Boothman Liz
Brennan |
Brenda Farrell Mary
Mahon |
Mary Martin Eithne
Cusack |
Lucy Joyce Maura
Tutty |
Deirdre Furlong Trish
Gorman |
|
| Orange |
2 |
Patricia Halford |
Ann Finnegan |
Patricia Halford Ann
Finnegan |
Ger O'Brien Patricia
Coady |
Brenda Crowley Mary
Lennon |
Fiona McDermot Noreen
Kelly |
Yvonne McEntee Marian
Claffey |
Sue Spencer Gallina
Runova |
Mary Sharkey Barbara
Moloney |
|
| Yellow |
2 |
Mary Hughes |
Susan Ward |
Mary Hughes Susan
Ward |
Rosaleen O'Malley Gay
O'Hea |
Catherine O'Donoghue
Mary MacDiarmada |
Marina Reddy Paula
McHugh |
Teresa Kirk Una
Waters |
Ann Carey Bernadette
Lynch |
Siobhan King Nuala
Breach |
|
| Green |
2 |
Eva Greene |
Bernie Doherty |
Eva Greene Bernie
Doherty |
Jane O'Brien
Marjorie Griffith |
Dolores Ryan Aine
Houston |
Blanaid Morris
Geraldine Barry |
Judy Rudden Sarah
Sheridan |
Christelle Grimaud
Orla Donnelly |
Patricia Timoney
Paula Courtney |
|
| Red |
2 |
Rachel Murphy |
Jo O'Brien |
Rachel Murphy Jo
O'Brien |
Tracey Macken Avril
Molloy |
Marie Byrne Jane
Garvey |
Sinead Ryan Ann Marie
O'Meara |
Rosaleen Proudfoot
Geraldine Grogan |
Jackie O'Brien Eilish
Logan |
Fiona Gleeson
Catherine Kearney |
|
| Black |
2 |
Marjorie Flood |
Rita Hayes |
Marjorie Flood Rita
Hayes |
|
|
|
|
|
|
|
| Blue |
3 |
Pauline Pardy |
Helen Spillane |
Pauline Pardy Helen
Spillane |
Week Numbers: |
Dates: |
Team Names: |
Enter the team names in cells H16 to H21. |
|
| Orange |
3 |
Maureen McCullough |
Maureen Neylon |
Maureen McCullough
Maureen Neylon |
Week 1 THURSDAY |
21 January 2010 |
Blue |
Enter the individual names in cells C3 to D68 as suggested in columns A
and B. |
|
| Yellow |
3 |
Paula Walsh |
Madeline Morgan |
Paula Walsh Madeline
Morgan |
Week 1 FRIDAY |
22
January 2010 |
Orange |
If necessary, change the number of games to be played in cell H27. |
|
| Green |
3 |
Margaret Gaynor |
Oisine Hannon |
Margaret Gaynor
Oisine Hannon |
Week 2 THURSDAY |
28
January 2010 |
Yellow |
If necessary, change the points categories in cells H29 to H32. |
|
| Red |
3 |
Deirdre Naughton |
Marita McGeady |
Deirdre Naughton
Marita McGeady |
Week 2 FRIDAY |
29
January 2010 |
Green |
If necessary, change the days and times in cells F27 to F32. |
|
| Black |
3 |
Clare Garrihy |
Miriam Rogers |
Clare Garrihy Miriam
Rogers |
Week 3 THURSDAY |
04
February 2010 |
Red |
If necessary, change the starting date in cell G16. |
|
| Blue |
4 |
Judy Glynn |
Jean Henneberry |
Judy Glynn Jean
Henneberry |
Week 3 FRIDAY |
05
February 2010 |
Black |
Enter the Court allocations and results in the games columns on Sheet
WeeklyScores. |
|
| Orange |
4 |
Catherine Keogh |
Clodagh Shortall |
Catherine Keogh
Clodagh Shortall |
Week 4 THURSDAY |
11
February 2010 |
|
|
|
| Yellow |
4 |
Therese Kilcline |
Mary Taaffe |
Therese Kilcline Mary
Taaffe |
Week 4 FRIDAY |
12
February 2010 |
|
|
|
| Green |
4 |
Valerie Timon |
Bridie Keegan |
Valerie Timon Bridie
Keegan |
Week 5 THURSDAY |
18
February 2010 |
|
|
| Red |
4 |
Philippa Howley |
Patricia Power |
Philippa Howley
Patricia Power |
Week 5 FRIDAY |
19
February 2010 |
|
|
| Black |
4 |
Mairead Johnson |
Grainne Doyle |
Mairead Johnson
Grainne Doyle |
Weekly Times: |
|
|
| Blue |
5 |
Noreen Maher |
Edel Clarke |
Noreen Maher Edel
Clarke |
THURSDAY |
TOTAL GAMES |
21 |
|
|
| Orange |
5 |
Ann Hawkshaw |
Teresa Horan |
Ann Hawkshaw Teresa
Horan |
7 30 pm |
POINTS CATEGORY |
LIMIT |
|
|
| Yellow |
5 |
Angela McDonnell |
Carmel Grogan |
Angela McDonnell
Carmel Grogan |
9 00 pm |
UPPER LIMIT FOR ZERO POINTS |
4 |
|
|
| Green |
5 |
Aideen Bracken |
Finola Patten |
Aideen Bracken Finola
Patten |
FRIDAY |
UPPER LIMIT FOR ONE
POINT |
7 |
|
|
| Red |
5 |
Eileen Ring |
Christina Walsh |
Eileen Ring Christina
Walsh |
7 30 pm |
UPPER LIMIT FOR TWO
POINTS |
10 |
|
|
| Black |
5 |
Marian Cronin |
Susan Mulholland |
Marian Cronin Susan
Mulholland |
9 00 pm |
UPPER LIMIT FOR THREE POINTS |
15 |
|
|
| Blue |
6 |
Aisling O'Neill |
Cliona Fitzsimons |
Aisling O'Neill
Cliona Fitzsimons |
|
ABOVE UPPER
LIMIT FOR THREE POINTS GETS FOUR POINTS |
|
|
| Orange |
6 |
Clare Byrne |
Deirdre Byrne |
Clare Byrne Deirdre
Byrne |
|
IF CHANGING
THE ABOVE LIMITS
.. |
|
|
| Yellow |
6 |
Kay Terry |
Marian O'Driscoll |
Kay Terry Marian
O'Driscoll |
|
You might
like to have the same total points regardless of game score |
|
|
| Green |
6 |
Derville Hoey |
Patricia McCormack |
Derville Hoey
Patricia McCormack |
|
|
| Red |
6 |
Maria Mitton |
Colette Scrivener |
Maria Mitton Colette
Scrivener |
|
|
| Black |
6 |
Mary Farrelly |
Isabelle Benzini |
Mary Farrelly
Isabelle Benzini |
|
|
| Blue |
7 |
Mairead Guiney |
Mary Sullivan |
Mairead Guiney Mary
Sullivan |
|
|
| Orange |
7 |
Angie Boothman |
Liz Brennan |
Angie Boothman Liz
Brennan |
|
|
| Yellow |
7 |
Brenda Farrell |
Mary Mahon |
Brenda Farrell Mary
Mahon |
|
|
| Green |
7 |
Mary Martin |
Eithne Cusack |
Mary Martin Eithne
Cusack |
|
|
| Red |
7 |
Lucy Joyce |
Maura Tutty |
Lucy Joyce Maura
Tutty |
|
|
| Black |
7 |
Deirdre Furlong |
Trish Gorman |
Deirdre Furlong Trish
Gorman |
|
|
| Blue |
8 |
Ger O'Brien |
Patricia Coady |
Ger O'Brien Patricia
Coady |
|
|
| Orange |
8 |
Brenda Crowley |
Mary Lennon |
Brenda Crowley Mary
Lennon |
|
|
| Yellow |
8 |
Fiona McDermot |
Noreen Kelly |
Fiona McDermot Noreen
Kelly |
|
|
| Green |
8 |
Yvonne McEntee |
Marian Claffey |
Yvonne McEntee Marian
Claffey |
|
|
| Red |
8 |
Sue Spencer |
Gallina Runova |
Sue Spencer Gallina
Runova |
|
|
| Black |
8 |
Mary Sharkey |
Barbara Moloney |
Mary Sharkey Barbara
Moloney |
|
|
| Blue |
9 |
Rosaleen O'Malley |
Gay O'Hea |
Rosaleen O'Malley Gay
O'Hea |
|
|
| Orange |
9 |
Catherine O'Donoghue |
Mary MacDiarmada |
Catherine O'Donoghue
Mary MacDiarmada |
|
|
| Yellow |
9 |
Marina Reddy |
Paula McHugh |
Marina Reddy Paula
McHugh |
|
|
| Green |
9 |
Teresa Kirk |
Una Waters |
Teresa Kirk Una
Waters |
|
|
| Red |
9 |
Ann Carey |
Bernadette Lynch |
Ann Carey Bernadette
Lynch |
|
|
| Black |
9 |
Siobhan King |
Nuala Breach |
Siobhan King Nuala
Breach |
|
|
|
| Blue |
10 |
Jane O'Brien |
Marjorie Griffith |
Jane O'Brien
Marjorie Griffith |
|
|
|
| Orange |
10 |
Dolores Ryan |
Aine Houston |
Dolores Ryan Aine
Houston |
|
|
|
| Yellow |
10 |
Blanaid Morris |
Geraldine Barry |
Blanaid Morris
Geraldine Barry |
|
|
|
| Green |
10 |
Judy Rudden |
Sarah Sheridan |
Judy Rudden Sarah
Sheridan |
|
|
| Red |
10 |
Christelle Grimaud |
Orla Donnelly |
Christelle Grimaud
Orla Donnelly |
|
|
|
| Black |
10 |
Patricia Timoney |
Paula Courtney |
Patricia Timoney
Paula Courtney |
|
|
|
| Blue |
11 |
Tracey Macken |
Avril Molloy |
Tracey Macken Avril
Molloy |
|
|
| Orange |
11 |
Marie Byrne |
Jane Garvey |
Marie Byrne Jane
Garvey |
|
|
| Yellow |
11 |
Sinead Ryan |
Ann Marie O'Meara |
Sinead Ryan Ann Marie
O'Meara |
|
|
|
|
| Green |
11 |
Rosaleen Proudfoot |
Geraldine Grogan |
Rosaleen Proudfoot
Geraldine Grogan |
|
|
|
|
| Red |
11 |
Jackie O'Brien |
Eilish Logan |
Jackie O'Brien Eilish
Logan |
|
|
| Black |
11 |
Fiona Gleeson |
Catherine Kearney |
Fiona Gleeson
Catherine Kearney |
|
|
| |
|
|
|
|
|
|
| |
|
|
|
|
|
|
| |
|
|
|
|
|
|
| |
|
|
|
|
|
|
| |
|
|
|
|
|
|
| |
|
|
|
|
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|