Pool league

[ratman1976]

I run a small town pool league and use excell to track player handicaps, ect. we use a simple system for handicapping. Players can be from 2- to 7+ (2- 2 2+ 3- 3 3+ 4- 4 4+) and so on. if a player is a 2+ and wins they go to a 3- and so on. I want to be able to just type a W or an L and have it look up the players previous handicap and return a new handicap in the next field. I've allready figured out how to count the W's and L's and return the total for a teams weekly wins on another page, and give stats on a players wins and losses. I then print each sheet out weekly. Teams have 8 players but only play 5 each week so some players might not play for 2,3 or more weeks. I also use access to keep track of all the people that have played in the league. some players play a few sessions then quit for a few. this way i can keep track of their handicaps when not playing and havew a list of all the people that have played in the league. Can i get excel to transfer a players handicap to access each time it changes?

 

[Scott Huish]

Hi, welcome to the board!

Can you post a sample of your sheet and expected results? The sticky How to display your sheet on the board/HTML Maker FAQ here
http://www.mrexcel.com/board2/viewtopic.php?t=92622 has the link to Colo's HTML Maker and shows you how to use it.

 

[ratman1976]

1 R-Place Larry 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 W L
Pd Gardner Larry 4+ W 5- L 4+ 4+ W 5- L 4+ L 4 W 4+ L 4 W 4+ W 5- 5 / 4
Pd Baker Carl 7+ W 7+ W 7+ 7+ 7+ L 7 7 2 / 1
Pd Baker Connie 4+ L 4 W 4+ L 4 W 4+ L 4 W 4+ L 4 L 4- L 3+ L 3 W 3+ 3+ 4 / 7
Pd Cook Kaland 5+ W 6- W 6 L 6- L 5+ W 6- L 5+ L 5 L 5- W 5 L 5- L 4+ 4 / 7
Pd Munger Tim 6+ L 6 L 6- W 6 L 6- L 5+ L 5 W 5+ W 6- W 6 W 6+ 5 / 5
Pd Sites Lorrie 4+ W 5- W 5 5 L 5- 5- L 4+ 4+ 4+ 2 / 2
Pd Weschke Suzan 3+ W 4- W 4 L 4- L 3+ L 3 W 3+ W 4- W 4 4 W 4+ 6 / 3
Pd Shultz Layton 7+ W 7+ W 7+ W 7+ W 7+ 7+ W 7+ W 7+ 7+ W 7+ W 7+ 8 / 0
36 29

 

[Scott Huish]

It's really hard to tell how that breaks up, any chance you could use the HTML Maker?

 

[ratman1976]

I added that to excel and it shows up in addins but I don't see a HTML menu?

 

[ratman1976]

I use office 2003

 

[ratman1976]

A1 = dues pd A2 = Player Last Name A3 = Player first name a4 = Starting handicap a5 = W or L if player won or lost a6 = handicap after win or loss a7 = W or L and so on

 

[Scott Huish]

I added that to excel and it shows up in addins but I don't see a HTML menu?

Go to Tools Add-ins, check the box next to the HTMLmaker and click OK.

If you get an error, the FAQ at the link I posted above should tell you how to fix the error you're getting.

 

[Scott Huish]

Based on your sample, I'm guessing that your headings go across from A1 not down, is this correct?

Like this, and continuing out?

Book1
	A	B	C	D	E	F
1	Dues	Player Last Name	Player First Name	Starting Handicap	W/L	Handicap
Sheet1

 

[ratman1976]

yes