I am trying to change the cell colour depending on the input against the actual Par . ie Column A = the actual par for each hole, Column B is the actual score if the input for cell B2 is greater than cell A1 the cell = Red """" """""" """" """ = to """ """ """" = Green """" """""" """""""" less """" """ """ """" = Purple Many thanks

0 |

5/29/2010 12:49:01 PM

What version of Excel are you using? -- Biff Microsoft Excel MVP "Pop Sturman" <Pop Sturman@discussions.microsoft.com> wrote in message news:F6ECB6A0-6439-42A6-B32D-F685E0E92443@microsoft.com... >I am trying to change the cell colour depending on the input against the > actual Par . > ie Column A = the actual par for each hole, Column B is the actual score > > > if the input for cell B2 is greater than cell A1 the cell = Red > """" """""" """" """ = to """ """ """" = > Green > """" """""" """""""" less """" """ """ """" = Purple > > Many thanks > > >

0 |

5/29/2010 2:19:46 PM

Use conditional formatting... See http://www.cpearson.com/excel/cformatting.htm "Pop Sturman" wrote: > I am trying to change the cell colour depending on the input against the > actual Par . > ie Column A = the actual par for each hole, Column B is the actual score > > > if the input for cell B2 is greater than cell A1 the cell = Red > """" """""" """" """ = to """ """ """" = Green > """" """""" """""""" less """" """ """ """" = Purple > > Many thanks > > >

0 |

5/31/2010 12:35:01 PM

I need to keep track of the scores in a quiz for 12 weeks running, then total each contestant's best 9 scores. Is there any way to sum a column, automaticaly ignoring the 3 worst scores? =SUM(LARGE(A1:A12,ROW(1:9)) it is an array formula, so commit it with Ctrl-Shift-Enter. -- HTH Bob Phillips "Vance Burton" <Vance Burton@discussions.microsoft.com> wrote in message news:914AED28-4FC3-42EF-AB5A-D8943147F795@microsoft.com... > I need to keep track of the scores in a quiz for 12 weeks running, then total > each contestant's best 9 scores. > > Is ther...

I have a calendar where the user picks a range of dates to see a weekly or monthly score. However I don't want the dates to show because it spikes out the scores for each day. If a user has 12 items that were qa'd during the week of 7//16 and 7/20. I want to be able to pick those dates on the calendar but for the report to say 12 and score not 7/16 2 95% 7/17 3 100% 7/18 2 88% 7/19 4 72% and 7/20 1 100% my code says : DoCmd.OpenReport "RWeeklySummary", acViewPreview, , "[DateQA] between #" & Me.txtbegindate & "# and #" & Me.txtenddate &...

My boss has asked me to create a schedule for their golf team. How can I do this in excel . 12 players - 3 Groups of 4 6 days How can I randomly select players into teams so that no one can play with the same people. Hope this makes sense. -- All help much appreciated. Thanks Hi! I think your specification is a bit ambitious. On each day, player A plays with 3 others. If, every day, he were to play with a different set of 3 ("no one ca play with the same people"), then he would use up 18 other player during the 6 days. There are only 11. Maybe they will play as pairs again...

Hi I would like to know what kind of formula I will use to get a point score like +2 or -2 instead of a regular score but still using handicaps. Example a player with a 4 handicap on the third handicap hole gets a stroke so if he scores a 4 he would then have a 3 or birdie and get awarded 4 points instead of the 3. This would be modeled after the stableford system but using handicap also. Thanks in advance Karl ...

Does anyone know how to obtain an Excel worksheet that calculates golf handicaps? I would try to develop my own but don't know the mysteries of golf handicap calculation. D Several years back I posted code to do this. You can probably find it on Google. I had no idea how to calculate a golf handicap, either, but a quick Google search revealed all. On Sat, 10 Sep 2005 13:14:14 +0000 (UTC), "David Clark" <shots4league-oneday@yahoo.co.uk> wrote: >Does anyone know how to obtain an Excel worksheet that calculates golf >handicaps? I would try to develop my own ...

i have made a report that shows the scores and placings for contestants. Some events have 2 sets of scores and so have two final results which get added togeter and then divided by 2 to give a final percentage in the final mark Box. Then sometimes the same event has only 1 set of scores and 1 result and so the report needs to reflect result 1 as the Final percentage eg Place Contestants name Result 1 Result2 Final mark -- 1 Betty Boo 56% 75% 65.5% 1 Betty Boo 56% ...

hello, I need a formula. How can you make a number in a spreadsheet equal a different number. Here's the skinny: Par equals zero (not higher or below par) Birdie equals -1...so our event has pars worth 2 points birdies worth 4. I have entered all the scores and a coinciding table with the reference to par -1, +2, etc- now I want a table that converts that number to the coinciding points...thanks in advance -- GOLFER ------------------------------------------------------------------------ GOLFER's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=23859 View thi...

I have created a database to hold golf scores. The setup is as follows; tblCourse CourseID Name Address etc. tblCourseDetails CourseID TeeID Hole Par Yardage Handicap tblRounds RoundID CourseID GolferID etc tblRoundDetails RoundID Hole Score I am trying to query for all holes with the par = 3 and have all the scores for those par 3 holes. I will do the same for par 4 and par5s as well. I will use this as the basis for a report to show average scores on each of the holes. Each time I try to create a query I get results that show multiple entries or entries that are not from the par ...

There are 24 players in my golf league. I would like to get a running average of the last scores midway thru the season which runs for 20 weeks. I need the average of the last 8 scores submitted and not just an average of the last 8 weeks which could have one or more missing scores. 51 52 49 46 42 43 43 45 43 45 47 39 44 45 47 50 Hi! Try this entered as array using the key combo of CTRL,SHIFT,ENTER: =AVERAGE(A100:INDEX(A1:A100,LARGE(IF(A1:A100<>"",ROW(A1:A100)),8))) Use a big enough range to cover any future entries! Biff "Golf Averages" <GolfAverages@...

In a golf tournament, we have two groups of winners. One group is those players with the lowest gross scores. The second group is those players with the lowest net (gross minus handicap) scores. In the example, 3 players would be rewarded for their highest finish, be it gross or net. They cannot win a prize in both categories. Example: Name Hdc Gross Scr Net Scr Gross Rank Net Rank Bob 12 87 75 6 6 Carl 6 78 72 2 4 Ed 17 ...

Hi to all I would really like to enhance a formula: In bridge (the game) the raw scores are ranked and a value assigned where the top score will get the result of: (no of scores-1)*2 and the next will get 2 less than the top. So for 9 raw scores you get 16, 14, 12, etc . . . down to 4, 2, 0 as shown under the column headed SCORES (shared positions share both score values) Board Results SCORE Should be 1 500 16 4 1 -300 0 0 1 400 8 2 2 -200 3 1 2 450 14 4 2 -200 3 1 3 -50 6 0 3 430 11 3 3 430 11 ...

Being that I am (1) too cheap to fork out $30 for software that doe this for you, and (2) interested in learning more about Excel, I hav been trying to create a spreadsheet that will calculate my gol handicap. The calculation for getting your handicap calls for usin the handicap differential of your 20 most recent rounds of golf, and o those 20, averaging the 10 lowest and then multiplying that average b 0.96. I've attached the spreadsheet that I have created and would b eternally grateful to anyone who can help. So far, this is what I have: =AVERAGE(N2:N35)*0.96 But I need to filter ...

Looking for an excel spreadsheet that tracks golf stats. Thanks Rich in Maine Using Ron's google search addin http://www.rondebruin.nl/ asking for golf in the subject line, I get -- http://tinyurl.com/58qk8 Don Guillett SalesAid Software donaldb@281.com "Rich Reed" <rric31@maine.rr.com> wrote in message news:1bsSd.22614$vK5.948@twister.nyroc.rr.com... > Looking for an excel spreadsheet that tracks golf stats. > > Thanks > > Rich in Maine > > ...

Hi, I have an xls with a list of football matches. In column A I will have the home scores and in column B, I will have teh away team's scores. I then have in column C my predicition for teh home team and in column D the away team score predcition. I want column E to compare teh two sets of scores and award me 3 points for an exact match of the scores and 1 point if I predict teh correct wwinner or a draw. - How can I do this? Thanks Simon -- Number_8 ------------------------------------------------------------------------ Number_8's Profile: http://www.excelforum.com/member.php...

i run a race team. we have 20 teams competeing. we select 7 riders each to compete in various age and skill levels. we sort the riders by age and skill level. as we score the races, i need a formula that will send the results back to the team score card. for example i have 20 score card, one for each team. each card has 3colums with 7 cells. after we sort the riders they are no longer grouped by teams. the formula would have to know to send the score of a rider from team (a) to the correct score card and if the first cell has a score in it, to place it in the next cell in the column a...

I need a formula that will automaticaly update handicaps using the last three scores entered. ex: A1 B1 C1 D1 E1 formula 35 32 38 -- Message posted from http://www.ExcelForum.com > using the last three > scores entered. > > ex: A1 B1 C1 D1 E1 formula > > 35 32 38 ?? <g> What are you playing Crazy Golf? To add up the last three scores in row 1 try: =SUM(OFFSET(A1,0,COUNT(1:1)-3):OFFSET(A1,0,COUNT(1:1))) Assumes that there ar...

I am trying to change the cell colour depending on the input against the actual Par . ie Column A = the actual par for each hole, Column B is the actual score if the input for cell B2 is greater than cell A1 the cell = Red """" """""" """" """ = to """ """ """" = Green """" """""" """""""" less """" ...

Hello - I am trying to figure out a way to track a fantasy golf pool. I need to track every player's totals earnings and then create a report which shows every team (made up of anywhere from 5 to 10 players). I created a spreadsheet listing each player and their total earnings. I'm stuck at this point, since I don't know how to create each team in such a way that would allow me to then print a report, sorted in descending order, based on the teams total earnings and listing each player on the teams and their individual earnings. Is this possible using Excel? Any help w...

I'm trying to track a golfing Nassau bets between two teams. In columns B & C are the two teams respective scores on each hole. Column D tracks how Team 1 stands for Bet #1. If Team 1 has the highest score on hole 1, they are -1, if they are lowest on hole 1 they are +1, and if they tie, they are 0 (zero). Each hole then increments column D by one, up or down, or remains the same depending on the outcome of that hole. Once a team is up or down by 2 a new bet (Bet 2) starts and is tracked in column E. (Etc. to Bets 3, 4 and perhaps 5.) Bet two, once started should increment ju...

I'm making a score sheet with results and the total result, but was wondering how I can make the position appear under the total (e.g First, second etc), in other words the formula. I'm sure there's a way it's just been a long day Thanks Nick There is rank; for example +RANK(B1,A1:A25,1) will show you where the value in B1 stands among values in A1:A25. the final argument ",1" is optional, but in this case makes it so that the lowest number has the "best" ranking. "Nick H" <anonymous@discussions.microsoft.com> wrote in message news:0...

I have just posted this in a golf newsgroup, but then it occurred to me I would probably have more chance going to the specialist group? I have just been co-opted as secretary to the Senior's section at my golf club, and I have been trying to set up an Excel programme to use for the yearly medal trophy. We play a medal once a month (12 times a year) and the best three rounds for each player are added together - the person with the lowest 3 scores winning the trophy. What I would like to do is set up a sum in Excel which will take the lowest three scores (for each person) and add them toget...

Is there a formula for this? Stableford Golf Scores. To work out a players total points based on their handicap. Each hole is handicapped (Stroke Index 1-18). The players handicap indicates the hole upon which he can deduct a stroke, ie. Players handicap is -4, he deducts a stroke on each of the first four handicapped holes. If his handicap is -28, he deducts a stroke on each hole, 1-18 and an additional stroke on holes handicapped 1 thru 10. (His handicap minus 18). Players handicaps run from -0 to -28. Points are scored as follows: 1 over par= 1pt par= 2pt 1 under par= 3pt 2 under pa...

I am trying to set up a spread sheet for my golf league. Here's an example: Member ___ Today's Score __ Net __ Current Handicap John Smith _____75 ________ 70___________5 Bill Smith _____76_________71___________5 Tom Smith _____ 77_________72___________5 John Parks _____72_________66___________8 Bill Parks _____78 ________69 __________ 9 Tom Parks _____80 ________ 73__________ 7 ...... and so on for 180 golfers Now I figured out how to list lowest net scores for todays round int an "A" Flight "B" Flight and a "...

Anyone ever put RMS into a golf store. Wondering the best way to deal with clubs with different options such as shaft flex and loft. Is RMS a good fit? How were these items handled? Let me know if you have anyone has any expierience with this. Zack, Matrix Item. Rob "Zack Anderson" <zack@electronicbiz.com> wrote in message news:4E934E5C-6452-41D7-ACA0-88C392B77124@microsoft.com... > Anyone ever put RMS into a golf store. Wondering the best way to deal > with > clubs with different options such as shaft flex and loft. Is RMS a good > fit? > How wer...

Following many helpful emails I have updated the Excel based gol scoring and recording system with stableford calculation. Get it a www.junipergreen.net The Template Wizard add-in is no longer required and the database shee is now contained in the same workbook. Acknowlegment t www.rondebruin.nl for code assisting with copy results to databas function : -- juniper62 ----------------------------------------------------------------------- juniper622's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1613 View this thread: http://www.excelforum.com/showthread.php?th...