Anyone looking for a 10 ball test spreadsheet?

"Q" Protectors

"Q" Protectors

AzB Silver Member
Silver Member
After reading a couple threads the last few days about "rating my speed" along with a link for the 10 ball skill challenge http://billiards.colostate.edu/threads/ratings.html#10-ball I decided to try it myself. I figured it would be a little easier to keep track on a simple spreadsheet rather than writing my scores on paper. Of course! I always have to go a bit further then I need to. Along with looking for reasons to dabble in Excel (I'm not that good but I like to try)

I threw something quick and simple together and then expanded on it. Basically ALL you have to do is just enter YOUR score under the "me" column and "rack" row and then it starts adding your balls per rack and removing from the "ghosts" starting count of 100 at the bottom in the "totals" cell. When you've completed the 10 racks and have entered them in the appropriate boxes you'll get your final tally along with the ghost's final tally. I have my "total" cell flipping colors from red (which I consider a bad set) to green (which I consider a good set) based on a "greater than or equal to". It also takes the final tally for you and changes it into a "skill level" grade in accordance with what the skill challenge claims are the ratings.

It also takes the data entered and graphs it next to the current set you're playing. Showing you where you are against the ghost.


I took a screen shot of the format and threw a couple different set numbers in to show you how the things change. I have the green cell showing up for scores 50 and up, and red cell with anything below that. Under your "total" cell it takes your final score and converts it to Joe Tuckers "letter" rating system.

Ghost_zpse3ead450.jpg






Like I said "I always go a little further"
I then took the graphs from individual sets and ran them into a single graph giving you a much larger perspective on what's actually going on. There are only 2 sets moved into the graph shown but as more get added you could actually see if you are moving up that graph.

Ghost2_zps89fedf3e.jpg




If anyone is interested in it PM me.


Thanks for looking!:smile:
 
Aside from the statistical display of the information in graphs, charts or ratios, has this information proven to be of any benefit to you?

Matt B.
 
Bavafongoul said:
Aside from the statistical display of the information in graphs, charts or ratios, has this information proven to be of any benefit to you?

Matt B.
Click to expand...

I literally played 1 set with the most basic spreadsheet ever. I got a bug the next afternoon to expand the spreadsheet since I'm not the best at Excel and always love messing around in it.

To answer your question. I wouldn't know for a really long time. It will probably take a really long time to start getting good trending on your play. Guess if you really tried to get better at pool and dedicated to getting better it would absolutely prove whether you were or weren't getting better. It would take hundreds of sets to really start showing it. But there are people who really want to know if they're getting better. Play a set or 2 a night and add the numbers in. Bet after a year you'd see how many "balls" you've improved.
 
I guess what I was asking is not so much if your game has improved. That only would come from doing something differently or changing something.....could be mechanical or mental........obviously some days we have things in the back of out mind when we play or maybe your back was sore that day......but there has to be some trend data........numbers simply need statistical interpretation and if the current data set doesn't provide the information, it's simple to change the formulas.

However, the data may not even be currently recorded so it's would be impossible to retrieve and use in any subset. I was just wondering how this might be of conceivable help to a player. Don't get me wrong as I am not knocking the idea but was simply asking how I could benefit from something like this and was wondering what you've learned from it.

Thanks,

Matt B.
 
Bavafongoul said:
I guess what I was asking is not so much if your game has improved. That only would come from doing something differently or changing something.....could be mechanical or mental........obviously some days we have things in the back of out mind when we play or maybe your back was sore that day......but there has to be some trend data........numbers simply need statistical interpretation and if the current data set doesn't provide the information, it's simple to change the formulas.

However, the data may not even be currently recorded so it's would be impossible to retrieve and use in any subset. I was just wondering how this might be of conceivable help to a player. Don't get me wrong as I am not knocking the idea but was simply asking how I could benefit from something like this and was wondering what you've learned from it.

Thanks,

Matt B.
Click to expand...
Ba-humbug much?
 
I like what you have done. Tracking data can definitely help to show your progress - or lack thereof. Here are a couple of screen shots of an excel sheet that i have used for 10ball ghost. have done this for 9ball ghost, Fargo, Equal Offense as well. Admittedly, haven't played these in a while, but enjoy tracking when I do.

The bottom shot is the total.

evu3y7a8.jpg


ezehabu5.jpg




Sent from my iPad using Tapatalk 2
 
You must log in or register to reply here.
Back
Top