If Function & Golf Analysis
Jul 5, 2008
I have been putting together workbook for my golf analysis.
Against each hole (1-18) I enter in one row which club I used from the tee which could be any of the following: D,3w,5w,1,2,3,4,5,6,7,8,9,w,s.
I also have a row that says whether I have hit the fiarway or not. If hit fairway = 1 if missed = 0.
What I want to be able to do is show the % of times I hit the fairway with each club. This would seem ida for the if function but I'm not quite sure how it would work because the result row is going to need to look at every hole to see if the club used was d,5w,3 etc etc and 'if' so then it will need to look at the row which says 'hit fairway or not' i.e. 1 or 0. This is where I get lost and am not sure if I do need the 'if' function or something else? Perhaps I need additional rows?
View 9 Replies
ADVERTISEMENT
Nov 22, 2006
in excel, is there a place called data analysis under tools? im an exchange student in sweden andthe work that teacher gave me is half swedish and half english.. im looking for histogram there.
View 3 Replies
View Related
Jun 4, 2009
i use it to arrange players for every hole during golf tournaments. The present sheet (that i have attached) will allow as few as 2 players per hole. i have been informed that it should not assign less than 3 players per hole. the math in the code needs to be adjusted so that it knows to always start with 3 somes and work up from there. i can do the math on a sheet of paper i just don't know how to code the math . the attached sheet is what a member on the forum previously did for me. i take no credit for it, i am not capable doing what this sheet does for me.
View 4 Replies
View Related
Feb 6, 2009
Not sure if this is do-able but I figured I would try. For a golf league coming up later this year I want to figure out how many Birdies, Pars, Bogies, Dbl. Bogies and Others each (20) golfers have during the season. After each round I would input their scores and I am looking for a program that would look at the score of the hole and the par for the hole and figure out what they got 1 under par = birdie, even par = par, 1 over = bogie, 2 over = dbl bogie and 3 over = other.
I started by creating a simple if statement but it ran out too long and my other issue is adding up the number of birdies, pars..etc for each round. Meaning a golfer can have bogies on hole #1 and #2 and the if statement can take care of that but how would get a total saying the golfer had 2 bogies.
Something like this with the - meaning a column.
birdies Pars bogies dbl bogies others total holes
4 - 5 - 3 - 4 - 4 - 5 - 6 - 5 - 8 1 4 2 1 1 9
I would do this each week and total the number of each to keep a running total at the bottom of each column. We play on the same course each week so the pars for each hole can be hard coded.
View 9 Replies
View Related
Apr 21, 2009
I run a spreadsheet that manages golf tournaments. i have to group
the # of players evenly as possible on each hole once they are entered into the tournament. since the number of players varies from tournament to tournament the math gets complicated trying to get the groupings right. i can do the math on paper but do not know how to code the math in a macro. this would save me a ton of time if someone can figure this out. i have attached a sample .xls that includes all the info i could think of a person needs to see what is going on. If i am asking to much i understand and will remove the thread.
View 6 Replies
View Related
Feb 15, 2008
I am trying to compute the handicap for a golf group. We base our handicaps on the lowest 4 of your most recent 5 rounds. I have no problem selecting the 4 lowest of 5 using the SMALL function. My problem is have the formula select only the most recent 5 rounds. Because everyone doesn't play every day the five most recent scores might be over several weeks and the others might be in the last week.
I am only entering the adjusted score (not hole by hole). The header columns have the date played.
The formula currently shows =SUM(SMALL($F9:$J9,{1,2,3,4}))/4.
View 9 Replies
View Related
Aug 7, 2009
I am organizing a golf scoreboard for my golf tournaments. Basically, this is what I want to do:
I would like to rank the players that are entered by their score, in ascending order. Basically, I want to take the column for "total strokes" and organize the numbers so that it will rank the numbers that are entered. If there are no numbers entered in a specific row, I don't want that "zero" to be ranked in the list. So for example, if I have five golfers but they are spread out over 10 rows, I would still need to have five numbers in the rank: 1,2,3,4, and 5, not 1 to 10, as if it were ranking the rows that have nothing entered in them.
This is how it will look:
Johnson - Strokes : 70 - Rank :1
Williams - Strokes : 75 - Rank : 3
Patterson - Strokes : 72 - Rank : 2
View 9 Replies
View Related
Oct 7, 2006
I couldn't find a solution to where I'm at now, but Derks formula...
= SUMIF($J$5:$J$44,J5,$K$5:$K$44)/COUNTIF($J$5:$J$44,J5)
from...
excel formula
...Almost gets what I need, but my data will not always be in a high/low descending order. I'm braindead; I can't think of how to make this formula work.
View 9 Replies
View Related
Mar 14, 2008
I am creating a workbook to manage golfer scores, teams, winnings, handicap, ect. I am having trouble with the statistics sheet. I Need A Sub To:
1. Column "B" , take the average of the lowest 5 numbers in columns "AB" though "AU"
2. Column "C" , take the average of the lowest 10 numbers in columns "G" through "Z" divided by 0.96
3. Column "D" , take the average of the lowest 10 numbers in columns "AW" through "BP"
this needs to happen for each row where there is a name. (names added daily)
I have included a similar sheet as the one i am working with along with some command buttons typically not included. Should show some of the problems I am having.
View 5 Replies
View Related
Dec 30, 2013
I am building a golf spread sheet with page 1 being where I will input scores, also on this page I have a drop down list with the 9 golf course names. What I have done is I have added 9 sheets with the names of each golf course, on this sheet I have added the scorecard. So what i am wanting to do is, on sheet 1 use a drop list with the name of the course, then choose what tees we are using and let it populate on sheet1 hole 1 thru 18, with the yardage and par for the hole.
View 4 Replies
View Related
Mar 18, 2007
Just starting to use excel and have a problem I hope someone can solve. Trying to set up handicap system for golf league. Column A is players. Column B shows average of last 5 rounds played and rounded to nearest whole number. column C shows the same without rounding. column D and beyond show scores with column D being the most recent. Have this all this working well with one problem. Each week I insert new column D, enter scores, and everything is recalculated. How do I deal with absent players? Is there a way to enter perhaps "A" for absent and excel will know to count the last 5 cells with numerical values only?
View 14 Replies
View Related
Jan 31, 2014
I run a golf society and need to set up a golf aggregate sheet that will allow me to enter the players weekly scores and the sheet will then look for the lowest score entered for each player and replace it with their score of this week.
View 13 Replies
View Related
Jan 15, 2006
I would like to set up a Excel spreadsheet for golf handicaps where it will use the 4 lowest scores of the last 5 entries. It must be able to work even if there are missed entries (someone didn't show up/blanks ignored). I would like it to work if there are only three scores used at the beginning of the season, but when there are 5 or more scores, use only the 4 lowest scores out of the last 5. I want it to average these scores. The scores would start in column d. The following is an example of scores with an underscore being a blank:
Golfer 1 45,50,42,43,46,37,45,45,46,44
Golfer 2 41,43,42,_,41,_,_,47,42,39
Golfer 3 44,43,45,54,_,45,43,40,42,_
View 9 Replies
View Related
Jul 15, 2006
If the number in one cell is larger than the number in another cell then i would need a 2 added to yet another cell.
I the first two cells are equal then I would need to add a 1 to that 3rd cell.
View 3 Replies
View Related
Apr 21, 2014
organising a golf tour for 32 players.playing in teams of 4 (4 Balls) for 4 games of golf and the teams are to be randomly selected such that no player plays in a group with a person he has played with in a previous game. finding it difficult to create a spreadsheet which meets this criteria.
need to build into the spreadsheet the fact that the variable mix of people is constrained by the fact that at least 4 persons have to use a buggy (which will have 2 people in it) and as the tour progresses and courses become physically demanding a number of people (N) for the last 2 rounds may also ask for the use of buggies as well.develop a spreadsheet to make the 4 Ball team selections.
View 2 Replies
View Related
May 25, 2008
I am using Excel 2002 in Xp and also want to use the spreadsheet on my Pocket PC using Pocket Excel.
I have a column of 10 numbers with rows 1,3,5,7 & 9 representing the individual gross scores of the 5 team members. Rows 2,4,6,8 & 10 have either a 0 or -1 (calculated) in them representing the strokes (or discount) the player receives for that hole. So the net scores for each player will be row 1 + row 2 and so on.
I need a formula that will calculate the total of the 2 lowest net scores and 1 low gross score with the score for each player only being used once which will then represent the team score for that hole.
A sample column would have 4,0,3,0,4,0,3,0,5,-1 in it.
View 9 Replies
View Related
Jul 28, 2014
I am attempting to put together a golf tournament spreadsheet. I have figured out how to review a list of numbers, find the lowest ten scores and make a list of those scores. Next to that I want to have excel input the name of the player that shot that score. The problem is, a couple of scores match so excel is only returning one of the golfers names. I am trying to have it return the other golfer who scored the same score.
Here is the formula I am using in Column N:
=SMALL($L$2:$L$21,1) This runs from 1 thru 10 for the 10 lowest scores.
Here is the formula I am using in Column O:
=INDEX($A$2:$A$21,MATCH(1,INDEX(($L$2:$L$21=$N2)*ISNA(MATCH($A$2:$A$21,N$2:N2,0)),0),0))
Here is the formula I am using in Column P: (gives same info as column O formula)
=INDEX($A$2:$A$21,MATCH(SMALL($L$2:$L$21,ROW(N1)),$L$2:$L$21,0))
Column A = golfers names
Column L = list of all golfers scores
Column N = lowest ten scores in order
Spreadsheet Attached : Golf Excel Score.xls
View 11 Replies
View Related
Apr 25, 2013
I am trying to create a golf table that shows how many games are played how many points are given for 1st 2nd 3rd and so on we give 10 pts for 9 for 2nd and so on......
View 12 Replies
View Related
Jul 28, 2014
I am attempting to put together a golf tournament spreadsheet. I have figured out how to review a list of numbers, find the lowest ten scores and make a list of those scores. Next to that I want to have excel input the name of the player that shot that score. The problem is, a couple of scores match so excel is only returning one of the golfers names. I am trying to have it return the other golfer who scored the same score.
Here is the formula I am using in Column N:
=SMALL($L$2:$L$21,1) This runs from 1 thru 10 for the 10 lowest scores.
Here is the formula I am using in Column O:
=INDEX($A$2:$A$21,MATCH(1,INDEX(($L$2:$L$21=$N2)*ISNA(MATCH($A$2:$A$21,N$2:N2,0)),0),0))
Here is the formula I am using in Column P: (gives same info as column O formula)
=INDEX($A$2:$A$21,MATCH(SMALL($L$2:$L$21,ROW(N1)),$L$2:$L$21,0))
Column A = golfers names
Column L = list of all golfers scores
Column N = lowest ten scores in order
View 4 Replies
View Related
Apr 1, 2008
I need a formula to figure the 5 lowest of last 6 sores, since everyone doesn't play every week there would be blank spaces and it needs to just give me the average if they have less than 6 scores!
I have manipulated the formulas until I am blue in the face and cannot get it to work;
View 9 Replies
View Related
Jun 10, 2006
Golfers have a numeric handicap based upon their proven ability (reported scores); the lower the handicap, the better the golfer.
My golf group is randomly drawn into handicap-balanced foursomes. If 24 guys are playing, six teams are created as follows:
1) The six players with the lowest golf handicaps are "Captains," and are randomly drawn.
2) After the Captains are drawn, the six players with the next lowest handicaps are then randomly drawn as the #2 players for each team.
3) The same process is followed to randomly determine the #3 player and #4 player for each team.
If the number of players is not divisible by four, some threesomes are then created, and one, two or three players are then on two teams. e.g., If we have 29 players, we draw 5 foursomes (20 players) and 3 threesomes (9 players). In this event, each threesome will use the scores of a randomly drawn player (Ghost) from one of the five foursomes.
(Each Threesome's "Ghost" player should be drawn from the group [captains, #2's, #3's, #4's] which will best round-out and handicap-balance the team.)
View 9 Replies
View Related
Aug 7, 2009
I need to write a program that will take numbers from various sheets, do a function on them (specifically a statistical analysis), and print that number to a cell on one sheet. I've tried to have all of the numbers go to one cell and have the analysis done on them, but after so many sheets, I get a memory error. I don't necessarily need all of the numbers to be saved, just the result is what I need.
View 14 Replies
View Related
May 11, 2009
how to tackle a piece of work that I really don't want to do.
We have extracted some summary information on one of our products. The workbook has 10 sheets, one for each of our 10 main sales channels. Each sheet has the same layout of information on. There are 7 tables on each sheet, and each one cuts the data in a different way (eg one summarises by age of purchaser (in age bands), another by demographic group etc). Each table then has the same 14 columns of key data (eg number of sales, average order value).
I've been asked to analyse this information "for anything interesting". At the moment, the only way I can think to do this is to print out the 10 sheets, sit down with a highlighter, and try to visually identify trends and anomalies. The idea fills me with dread, and I suspect will be quite inefficient.
I've asked whether I can get the data in a pivot table or some other format that might be more conducive to analysis, and have been told no. (There will easily be more than 100,000 lines in the original data (we're using Excel 2003)). To be honest, I'm not sure that I'd really be that much better off, even if it were in a pivot table.
View 9 Replies
View Related
Aug 20, 2009
to figure out a breakeven analysis.
Here is the situation. I bought 100 shares of stock at $40 each for total investment of $4000. The stock price is now $26 a share so the investment is down $1,400. I want to figure out the number of additional shares I need to buy at $26 so that when the price goes to $26.01 i turn a profit.
View 9 Replies
View Related
Dec 17, 2012
My boss wants me to take the holiday info from SAGE for 80 employees and create a record on excel. He wants to know what holidays each employee has taken and is due to take throughout the year. As each employee works a different amount of hours and a different shift pattern, SAGE records their holiday entitlement in hours rather than days. I have attached an example of one employees details and if come up with an excel document containing similar information for 80 individuals - all starting on different dates and all having a different amount of holiday entitlement. He wants to be able to look at each employees record for the year and see not only holiday data but sick days too. I don't know where to start with this - I've thought about creating a workbook with 80 pages and create a 12 month calendar for each individual with days off marked on it?
View 4 Replies
View Related
Aug 13, 2008
What's the technique for opening a .pdf file and copying its contents into Excel for subsequent analysis by VBA?
On my Mac version of Excel there doesn't seem a facility to import it or even copy and paste it. Is this something that's available in Windows versions of XL?
View 10 Replies
View Related
Feb 10, 2012
I need to summarise a batch of data in this format....
YearPeriodAccountCustomerPart NumberSalespersonChannelValue2011Jan1SteveA1KylieHome1502011Feb2BillA2KylieExport1802011
Mar3FredA3KylieHome2002011Apr4JohnA4KylieExport1002011May5AndyA5KylieHome85
And need to put it in the following format...
Salesperson - KylieJanFebMarAprMaySteve150Bill180Fred200John100Andy85
I know I can use a series of pivot tables but would like to keep the size of the file to a minimum.
Is a DSum the way to go or can I use a Sum if and use an and function with the sum if?
formula if so to saveme a bucketload of trial and error attempts...
View 2 Replies
View Related
Sep 25, 2012
I have a problem that I am finding impossible to find a solution to myself. I want to take the maximum value on a graph (in a column) that has the 2 values next to it (above and below) within 5% of that value. If they are not within 5% I want it to look for the second largest value with the same conditions and so on until the conditions are met.
If it makes it simpler, the final point can be ignored as there are only values above it in the column.
It is in column H, which goes from H3:H51
View 5 Replies
View Related
Feb 23, 2007
I found this code in the posts to automatically install the Analysis ToolPak at Open.
Private Sub Workbook_Open()
AddIns("Analysis ToolPak").Installed = True
End Sub
I tried this in the workbook module but it doesn't seem to work. Is this code correct or have I done something incorrectly?
Also, are there any drawbacks to an automatic install of an add in like this and if it runs the code every time the workbook opens, is there any performance issues (maybe only opens a bit slower)?
View 9 Replies
View Related
Sep 4, 2009
If I wanted to calculate weighted average of a bunch of salespeople, is there a way to not include some values, such as ones below a certain value? I'm trying to so something like, what would my weighted average be if I didn't include my bottom 2 salespeople or my top 2 salespeople.
View 9 Replies
View Related
