Number II

Team Stats

	Tenpins Winter League
	Heavy Rollers Bowling Team
	SCORES
	Team Member	Week 1	Week 2	Week 3	Week 4	Week 5	Week 6	Week 7	Week 8	Week 9	Week 10
	Ronnie Roundmarble	182	180	181	194	185	195	203	180	171	180
	Penny Pinsetter	140	150	143	140	140	117	146	140	140	140
	Annie Allie	186	170	155	170	170	170	154	191	156	165
	Sam Splitter	130	130	106	166	102	109	155	83	160	132
	AVERAGE
	Team Member	Week 1	Week 2	Week 3	Week 4	Week 5	Week 6	Week 7	Week 8	Week 9	Week 10
	Annie Allie
	Penny Pinsetter
	Ronnie Roundmarble
	Sam Splitter
	Team Average
	HANDICAP
	Team Member	Week 1	Week 2	Week 3	Week 4	Week 5	Week 6	Week 7	Week 8	Week 9	Week 10
	Annie Allie
	Penny Pinsetter
	Ronnie Roundmarble
	Sam Splitter
	Team Handicap
	BOWLER ANALYSIS	Annie
		Week 1	Week 2	Week 3	Week 4	Week 5	Week 6	Week 7	Week 8	Week 9	Week 10
	Scores
	Average
	Handicap

Parameters

Handicap Calculation Parameters
League Basis Average	230
Handicap Percentage Factor	0.85

Documentation

Create Date	By Whom	Description	Workbook Name
		Bowling Team Performance Tracking	ERROR:#N/A
Mod. Date	By Whom	Mod. Description	Last Version Backup Name : VERSION BACKUP NAME : Before modifying any worksheet, save the original workbook with the following name format: Original name_yyyymmdd
		Enter bowler's weekly scores in cell range C6:L9 of the Team Stats worksheet
		Enter bowler's first name in cell C27 to view individual statistics and to update the chart in the Bowler Performance worksheet
Create Date	Sheet Name	Creator	Purpose
	Team Stats
	Parameters		Store parameters for handicap calculation

&F