Pool league

ratman1976

New Member
Joined
Oct 17, 2006
Messages
10
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?
 

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().

ratman1976

New Member
Joined
Oct 17, 2006
Messages
10
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

MrExcel MVP
Joined
Mar 17, 2004
Messages
19,958
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
It's really hard to tell how that breaks up, any chance you could use the HTML Maker?
 

ratman1976

New Member
Joined
Oct 17, 2006
Messages
10

ADVERTISEMENT

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

ratman1976

New Member
Joined
Oct 17, 2006
Messages
10

ADVERTISEMENT

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

MrExcel MVP
Joined
Mar 17, 2004
Messages
19,958
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
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

MrExcel MVP
Joined
Mar 17, 2004
Messages
19,958
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
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
ABCDEF
1DuesPlayer Last NamePlayer First NameStarting HandicapW/LHandicap
Sheet1
 

Forum statistics

Threads
1,136,924
Messages
5,678,598
Members
419,774
Latest member
MooseWinooski

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top