Pool League Spreadsheet

[Kyrad42]

Hello! My boyfriend recently signed me up to create a new spreadsheet for his local small pool league. The old software they were using is no longer and I wanted to try making formulas to do it on excel since it is a small league. I have copies of the old stats he’d send out every week, so I’m trying to recreate it in excel. I’m having some trouble with the formulas though or where to start. All the players have an average and a rating. That will change each week based on who they shot and whether they won or lost. Any help or tips would be appreciated. I don’t know as much as I thought I did about excel and I’m stuck! I can upload a template if any one would like to see.

 

[awoohaw]

HI Kyrad42, welcome to the forum.
The forum would love to help, but we need some sample data and expected results.
Could you create a mini worksheet using the xl2bb add in (link below) and share with us.
Probably 6 players and 3 or 4 weeks of matches with how the results are captured and how the rating/average affects the number of games to win in each match (if you use that kind of handicap system).

If you cannot install the add in, please post the data as a TABLE and not an image. Workable data helps the forum help you.

Thanks in advance.

 

[AhoyNC]

Maybe this link will give you some ideas.