Pool League Statistics Spreadsheet (Lotus 1-2-3) - League.wk1 (0/1)

Pool League Statistics Spreadsheet (Lotus 1-2-3) - League.wk1 (0/1)

Post by Tim Loc » Wed, 17 Sep 1997 04:00:00

Here is a spreadsheet I conjured up to keep track of our league last year.
It is not real fancy. I was using it on Lotus 1-2-3 v2.4 in my palmtop
which was handy because I could take it to the games and put in the scores.
If you have a VGA or color laptop, you might want to add some lines and
graphics or color.

Most of the macros work, except perhaps the \G macro which is supposed to
draw a graph of a player's scores. When you add players, you will have to
manually recopy the position numbers as they will break. I'll have to write
a script for inserting a player. At the bottom is an area to enter team
stats. I used to have this set up to automatically calculate from the
players stats, but players were changing teams and it was becoming a mess
and REALLY slowed down the recalculation (especially on an 8Mhz palmtop.
We're talking minutes...).

I added the second season area recently in anticipation of this year's
league which hasn't started yet so there are ERR's in the average column.
No big deal. If you make major improvements to it I would really appreciate
a copy and I'll post it again if I do.

Have fun!


On the Internet, no one knows you're a VIC-20.