Ok, I got tons of rep-points with comments + pm's after my post in another thread, about how to improve your game.
I wrote in that thread that I am using an excel-file to keep score of everything I do when practising and competing in pool.
Some people have asked to get a copy of the excel-file, but I don't want to give it away, since I have used lots of hours making it. Another reason is that it is complicated to get started with it, without someone to explain it, so if you really want to keep record of your matches etc you should create a system of your own.
But I have decided that I can give you a view of how it looks like, and what's in it. This way it is easier for you to make a file for your own. See the attached photo.
You can see that I register name of the opponent, what level the player has (in my opinion, I rate them from 1-5, 1 is pro), race, break and runs etc.
In top of the photo you can see matches registered, average of break & runs, time-out and other info. This is information that the file gives me based on the information I feed it from each match.
I have several hundreds of matches registered, but I can search in the file, and the matches in the photo are my matches from the Norwegian 9-ball Championship in 2008, when Tommy Wolff became Norwegian Champion. Also with the search-function I can find information about my winning percentage against level 2 players, my break & run stats against level 4 players etc. It might not sound important, but when you have many hundreds of matches like I do, it's easy to notice things that needs to change. For example when I play level 2 players, about 40 % of my matches has got a "bad start", which means I am down 3-1, 4-2 or something after the first racks. Should I take time-out earlier? Play more safeties in the beginning? Questions that can help me perform better in the beginning of matches against level 2 players in the future.
Anyway, since the photo (copy screen) is from a tournament I didn't do the stats for my breaks (the blue zone) or my errors, because I was afraid it would distract me during tournament.
To the right, in the "notes"-field I put in notes from my matches, if there is something that should be remembered.
In the bottom of the photo you can see the menu of the excel-file. I have one sheet just for my 14-1 matches, one sheet for my schedule, budget, one sheet for registering just matches won/lost in tournaments, what place I finish and how many entrances etc (then calculate average and progress), one sheet for the drills I plan to do, and the results of the drills, and I have also something I use very much, and that's the button in black called "Players". After a match, or if I have watched a match between two players, I take notes of their strong and weak skills, and make a summary of each player. Does he jump good or bad, how is his kicking/banking skills, fast or slow player etc.
Why do I keep record of other players skills? Because when I am gonna play a guy in an important match it is good to know if he for example jumps terrible. That gives you more safety-options, because you don't necessarily need to freeze the cueball, it can be good enough to just hide it behind some balls.
If you have questions come with them - I'll try to answer as good as I can. By using this excel-file pool is now a sport for me, and not just something I do to kill some time while drinking beer. It's more fun now, and I can actually see progress from month to month!
I wrote in that thread that I am using an excel-file to keep score of everything I do when practising and competing in pool.
Some people have asked to get a copy of the excel-file, but I don't want to give it away, since I have used lots of hours making it. Another reason is that it is complicated to get started with it, without someone to explain it, so if you really want to keep record of your matches etc you should create a system of your own.
But I have decided that I can give you a view of how it looks like, and what's in it. This way it is easier for you to make a file for your own. See the attached photo.
You can see that I register name of the opponent, what level the player has (in my opinion, I rate them from 1-5, 1 is pro), race, break and runs etc.
In top of the photo you can see matches registered, average of break & runs, time-out and other info. This is information that the file gives me based on the information I feed it from each match.
I have several hundreds of matches registered, but I can search in the file, and the matches in the photo are my matches from the Norwegian 9-ball Championship in 2008, when Tommy Wolff became Norwegian Champion. Also with the search-function I can find information about my winning percentage against level 2 players, my break & run stats against level 4 players etc. It might not sound important, but when you have many hundreds of matches like I do, it's easy to notice things that needs to change. For example when I play level 2 players, about 40 % of my matches has got a "bad start", which means I am down 3-1, 4-2 or something after the first racks. Should I take time-out earlier? Play more safeties in the beginning? Questions that can help me perform better in the beginning of matches against level 2 players in the future.
Anyway, since the photo (copy screen) is from a tournament I didn't do the stats for my breaks (the blue zone) or my errors, because I was afraid it would distract me during tournament.
To the right, in the "notes"-field I put in notes from my matches, if there is something that should be remembered.
In the bottom of the photo you can see the menu of the excel-file. I have one sheet just for my 14-1 matches, one sheet for my schedule, budget, one sheet for registering just matches won/lost in tournaments, what place I finish and how many entrances etc (then calculate average and progress), one sheet for the drills I plan to do, and the results of the drills, and I have also something I use very much, and that's the button in black called "Players". After a match, or if I have watched a match between two players, I take notes of their strong and weak skills, and make a summary of each player. Does he jump good or bad, how is his kicking/banking skills, fast or slow player etc.
Why do I keep record of other players skills? Because when I am gonna play a guy in an important match it is good to know if he for example jumps terrible. That gives you more safety-options, because you don't necessarily need to freeze the cueball, it can be good enough to just hide it behind some balls.
If you have questions come with them - I'll try to answer as good as I can. By using this excel-file pool is now a sport for me, and not just something I do to kill some time while drinking beer. It's more fun now, and I can actually see progress from month to month!
Attachments
Last edited:
