Before the golf season is over I thought I would show you how I keep track of my husband's golf foursome's scores.
Load up MP and turn the recalc off. In row 1 you can place the name of the club if any and place any print commands you might want in R1C1. I make the default format width 8 and change the width in Cl to 10. I use general format and no decimal places for the scores but use 1 decimal place for the averages.
In R3C3 I place the first player's name..Don, R3C5, the second player, John..R3C7, the third, Pete..R3C9, and the fourth..Harry. In R4C1, I place 10 dashes and copy this right, 8 columns. In R5C1 place the word DATE, R5C2, the word SCORE and in R5C3, the word PUTTS. Go to R5C4 and copy from R5C2.(The word SCORE will appear.) Do the same in R5C6 and R5C8. Go to R5C5 and copy from R5C3. (The word PUTTS will appear.) Do the same in R5C7 and R5C9. In R6C1 I again place 10 dashes and copy it right for 8 columns.
Now we're ready to enter the data. Place the cell pointer in R7C1 and hit A for Alpha, otherwise MP will think you are entering a formula. My first entry this year was 04/20/88. Keep arrowing right and enter the appropriate scores and putts for each player. My sample sheet has 9 entries. Now let's enter some formulas.
First of all we are going to name the columns to make the formulas simple. I named R7:24C2 DS (for Don's score) and R7:24C3, DP (for Don's putts). Name the remaining columns accordingly, eg: JS,JP,PS,PP,HS, & HP. MP will propose the proper areas.
In R25C1 place the words TOTAL AVG. Go to R25C2 and enter the formula Average(DS), R25C3, Average(DP).
Enter formulas in remaining columns accordingly, eg: Average(JS), Average(JP), Average(PS), Average(PP), Average(HS) and Average(HP).
This row will then calculate the averages of-all scores and putts.
Go to R28C1 and enter the words LOW AVG. More about that later. Now enter the word HANDICAP in R31C1. Now is where the work comes in. In order to find the low average for each player, you must take the average of the 10 lowest scores in the last 20 scores. So we need to make a table containing these scores. Place your cell pointer in R1C1O and place the words LAST TWENTY SCORES. (You can use the format continuous command to do this).
Go to R3C10 and place the word ROUND. Now place each players name in Columns 1l, 12, 13 and 14. (Don, John, Pete, Harry). In R4C1O to R4C23 place the numbers 1 through 20. Now place each player's last 20 scores in the appropriate columns, going back to last season if necessary. Now go to R24C10 and place the words LOW AVG.
Before we go any further, we now must sort C11 to find Don's low average. Hit S for sort. You will see the following menu:
SORT by column:C
between rows:1 and:255
order:[>]
Enter column 11, tab over to the next area and enter 4, tab over and enter 23, tab over and change the order to <. MP will now sort C11 in descending order. Now we can place a formula in R24C11.
Place the formula Average(R[-10]C:R[-1]C) in R24C11 and MP will calculate the Low Average for Don. Place this figure in R25C11. (do not use the copy command as it will copy the formula and the number will change later) and name this cell DLA (Don low average). To find the low average for each player, you must sort each remaining column and place the same formula in R24. MP will propose the proper rows but you will need to change the order to <. Don't forget to retype the figure in R25 and name each cell accordingly, eg: JLA, PLA and HLA.
BEFORE YOU GO ANY FURTHER NOW, SORT THE SPREADSHEET BY C10 BETWEEN ROWS 4 AND 23 IN ASCENDING ORDER OR YOU WILL HAVE A MESS.
Now we're ready to finish up. Place your cell pointer at R28C2 and hit C for copy, F for from and enter DLA for the cell. Don's low average will automatically appear. Do the same in column 4 for John (JLA), column 6 for Pete(PLA) and column 8 for Harry(HLA).
Next in R31C2 enter the formula for the handicap. Since this foursome always plays a 9 hole course, I used the formula..(RC[-3]-34)*96%. Handicap equals the Low Average less the course rating times 96%. The course rating where they play is 34, so you will NEED TO ADJUST THIS FORMULA according to your course. Place this same formula in C4,C6 and C8. You can use the Copy From command.
Now hit FCTN 8 for recalc and presto you have a score sheet ready to print out.
This can be used for one player or many. Just remember to sort by each player to get the low average and then resort by column 10 (Round number). When you edit each cell to get the low average, it's a good idea to check the formula to make sure it is correct. Average(R[-10]C:R[-1]C). It should come out the same but occasionally one of the numbers in the formula comes up wrong and I don't know why.
Each time a new round is played, you will need to do the following. Place the cell pointer at R4C11. Now Delete 1 row between columns 11 and 14. Next go to R23C11 and Insert 1 row between coumuns 11 and 14. Now you will be able to enter the latest scores and still have the last 20 scores in your table.
This sounds much more complicated than it actually is. I will demonstrate it at the meeting if anyone is interested. Feel free to call me with any questions.
Table './ti99er00_phpf1/phpf_online' is marked as crashed and last (automatic?) repair failedTable './ti99er00_phpf1/phpf_online' is marked as crashed and last (automatic?) repair failedTable './ti99er00_phpf1/phpf_online' is marked as crashed and last (automatic?) repair failed
Users Online
Table './ti99er00_phpf1/phpf_online' is marked as crashed and last (automatic?) repair failed Guests Online: 0
Just wanted to say 'I'm glad I found you!' Pulled out my TI and have started to play with it again. I forgot how much fun it was. Wish there were more people out there still using it!
Main
Members Only
