Tue. March 19 2024 @
Username:    Password:   
center-left.png center-right.png
Navigation
 Main
Home
In Remembrance
TI99ers Awards (UPDATED)
TI99ers Hall of Fame
Web Links
Event Calendar
Articles
TI-99/4A Emulators
Search
News Categories
Privacy Policy
Contact Me

 Members Only
blank.gif blank.gif
Event Calendar

Summer
Sun Mon Tue Wed Thu Fri Sat
          1 2
3 4 5 6 7 8 9
10 11 12 13 14 15 16
17 18 19 20 21 22 23
24 25 26 27 28 29 30
31            
Legend:
Normal: 
Event: 
Today: 
blank.gif blank.gif
Member Birthdays

Month of March

03/03 - jslicer
03/31 - harleystroker2

No Birthdays Today

blank.gif blank.gif
Forum Threads
Newest Threads
bullet.gif Call for Jim Peterso...
bullet.gif OLUG Rules
Hottest Threads
No Threads created
blank.gif blank.gif
Latest Articles
bullet.gif Nominations Closed
bullet.gif Nominations are closed
bullet.gif Multiplan Part 10 by...
bullet.gif Multiplan Part 9 by ...
bullet.gif Multiplan Part 8 by ...
blank.gif blank.gif
Articles Hierarchy
Articles Home » Multiplan by Audrey Bucher » Multiplan Part 9 by Audrey Bucher
purple-btm-left.png purple-btm-right.png
Multiplan Part 9 by Audrey Bucher
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.
purple-btm-left.png purple-btm-right.png
Comments
No Comments have been Posted.
purple-btm-left.png purple-btm-right.png
Post Comment
Please Login to Post a Comment.
purple-btm-left.png purple-btm-right.png
Ratings
Rating is available to Members only.

Please login or register to vote.

No Ratings have been Posted.
purple-btm-left.png purple-btm-right.png
Login
Username
Password


Not a member yet?
Click here to register.

Forgotten your password?
Request a new one here.
blank.gif blank.gif
Users Online
bullet.gif Guests Online: 25

bullet.gif Members Online: 0

bullet.gif Total Members: 126
bullet.gif Newest Member: suberbanator
blank.gif blank.gif
Shoutbox
You must login to post a message.

December 21 2017
I wish each and everyone one a very Blessed Christmas and a prosperous New Year! Santa

December 31 2016
Happy New Year all Smile

June 23 2016
Hi Mike, welcome Smile. There are still lots of TI99 users out there Smile

June 22 2016
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!

April 23 2016
Hello my fellow ti99ers, have a great weekend Smile

blank.gif blank.gif
Member Poll
There are no polls defined.
blank.gif blank.gif
centerb-left.png centerb-right.png
center-left.png center-right.png
centerb-left.png centerb-right.png