D I A R Y
of a

P O O L    S H O O T E R

The Adventures of FastMikie
in search of Truth and Beauty in the art of pocket billiards.




Saturday, June 28, 2008

Playing Ability Test (PAT) Level ONE Spreadsheet


When I was still practicing with Level ONE, I didn't have a handy spreadsheet to do all the grunt arithmetic, so Practice Assistant Dave had to do it all with a pencil. Ugh.

Recently I went to Level TWO on the PAT test, and made up a spreadsheet to do the work of scoring, and that has worked out very well. That got me to thinking that I should do a spreadsheet for all those folks still at Level ONE, and I put some new features in this new spreadsheet, which are kinda fun. For example, the score column is orange until you pass the minimum to get a patch, then it turns the color of the lowest level patch (light green), and when you get to the next level, it turns the appropriate color (dark green). I also added a cumulative score column so you can compare mid-test scores to last time you took the test.

Now the PAT Level ONE spreadsheet is more advanced than PAT Level TWO, and that hardly seems right, so I'll have to go upgrade that one now. I'm a giver...

I'll do PAT Level THREE when I pass Level TWO, or when somebody else wants to modify one of my existing spreadsheets.

Here's the new Level ONE spreadsheet: Click here. Good Luck!

2 Comments:

Anonymous Anonymous said...

If you replace the average calculation with the average function:

AVERAGE(E3:I3)

then you can check your score and cumulative with every entry.

Friday, July 04, 2008 5:11:00 AM  
Blogger FastMikie said...

Nice suggestion!
I'll use it in my next update.

Thank you!!

Friday, July 04, 2008 8:13:00 AM  

Post a Comment

<< Home


Go to top of this blog

© Copyright 2004-2011, All rights reserved.