Input sheet

this is where the results are entered

you can type ONLY in the yellow cells.

a team consists of three men and three women, playing a mix of levels and mixed doubles only.

a two letter code is used to identify each player (see 'misc sheet').

scores are entered as described on the sheet.

the totals in the green cells are, total points won, and total games won.

at present there is a maximum of 64 matches (the first team, second team etc headers
are irrelevant are only there for my clubs convenience)



Tables sheet

this contains the player performance tables follwoing calculation

there are a total of 8 tables:

	individual men (NOT SINGLES)
	individual women (NOT SINGLES)
	men's doubles
	women's doubles
	mixed doubles
	
	the doubles table are also repeated but only including
	partnerships that have played a minumum number of games (see 'misc sheet')

these tables are designed to be printed landscape on A4 paper, though you may have
to adjust page margins and/or 'Adjust to xx%' to fit.


Calc sheet

where all the calculations are done


misc sheet

contains player and other data

club name : self explanatory
minumum game filter : see 'tables sheet'

there is a maximum of 80 players split equally between men and women
names are entered in the yellow cells
the two letter code is automatically generated, but you may have to manually change
some of them as duplicates are not automatically detected
(you may have to copy the formula to do this to some of the cells)

	


E-mail me if you have any problems