[Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register]

Author Message
ppopko
General User

Joined: 10 Jun 2012
Posts: 5

 Posted: Sun Jun 10, 2012 6:51 am    Post subject: Spreadsheets for Dummies Hello, I have just installed "Open Office". The computer "Guy" in our local paper suggested this program. I know as much about spreadsheets as I do about "Brain Surgery"! I have taken over the job as the secretary of our golf league, a although I have purchased a program to take care of the golf things, I would like to learn how to set up a spreadsheet so I can keep a running average for 12 men playing 20 weeks. This way I can get a true average instead of a Handicap. Like I said, I know very little about spreadsheets and will appreciate any help. ppopko
JohnV

Joined: 07 Mar 2003
Posts: 9183
Location: Lexinton, Kentucky, USA

 Posted: Sun Jun 10, 2012 10:55 am    Post subject: In the 1st row of a sheet put in the 12 names, e.g., A1 = Jones. In the 20 rows below enter the scores but for now enter 1 in A2. Click out of A2 then click back into it. Hover your cursor over the black box at its lower right until it changes shape then left click and drag down to A21. In A22 enter the formula =AVERAGE(A2:A21) As above, this formula can be dragged across the page. Don't worry about any division by zero errors. They will go away when you enter actual scores. Blank cell are not included in an average so this will give you a running average of the scores as of the current week.
ppopko
General User

Joined: 10 Jun 2012
Posts: 5

Posted: Sun Jun 10, 2012 11:30 am    Post subject:

 JohnV wrote: In the 1st row of a sheet put in the 12 names, e.g., A1 = Jones. In the 20 rows below enter the scores but for now enter 1 in A2. Click out of A2 then click back into it. Hover your cursor over the black box at its lower right until it changes shape then left click and drag down to A21. In A22 enter the formula =AVERAGE(A2:A21) As above, this formula can be dragged across the page. Don't worry about any division by zero errors. They will go away when you enter actual scores. Blank cell are not included in an average so this will give you a running average of the scores as of the current week.
 Quote: John V, Thanks you. While i was waiting I messed around with the spreadsheet and came up with this: I entered week 1 thru 18 across the top and the players down the side. I entered all the scores i have so far thru 8 weeks. I put in a formula that gave me the total of the scores each player has for the times they each played. Now all I have to do is have a formula that divides the total by the number of weeks played for an average. I hope I don't have to start over! ppopko
JohnV

Joined: 07 Mar 2003
Posts: 9183
Location: Lexinton, Kentucky, USA

 Posted: Mon Jun 11, 2012 5:46 am    Post subject: Do I need to tell you to use the Average formula instead of the Sum formula?
jrkrideau
Super User

Joined: 08 Aug 2005
Posts: 6732

Posted: Mon Jun 11, 2012 9:10 am    Post subject: Re: Spreadsheets for Dummies

 ppopko wrote: Hello, I have just installed "Open Office". The computer "Guy" in our local paper suggested this program. I know as much about spreadsheets as I do about "Brain Surgery"! I have taken over the job as the secretary of our golf league, a although I have purchased a program to take care of the golf things, I would like to learn how to set up a spreadsheet so I can keep a running average for 12 men playing 20 weeks. This way I can get a true average instead of a Handicap. Like I said, I know very little about spreadsheets and will appreciate any help. ppopko

Following on from your subject line, I would suggest getting hold of something like Excel for Dummies or any other intro to spreadsheets, such as QatroPro or Lotus123. Spreadsheet principles are basically the same for any spreadsheet--different bells and whistles but the nitty-gritty is the same.

Your local library should have some copies or you probably can pick one up in a used bookstore for a pittance. Such a book can save lots of time and head-pounding.
_________________
jrkrideau
Currently using Windows 7 & OOo 3.4.0 and Ubuntu 12.04 & LibreOffice 3.5.2.2
 Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First
 All times are GMT - 8 Hours Page 1 of 1

 Jump to: Select a forum OpenOffice.org Forums----------------Setup and TroubleshootingOpenOffice.org WriterOpenOffice.org CalcOpenOffice.org ImpressOpenOffice.org DrawOpenOffice.org MathOpenOffice.org BaseOpenOffice.org Macros and APIOpenOffice.org Code Snippets Community Forums----------------General DiscussionSite Feedback
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum