Scoring Programme
Apr 9, 2009
I am looking for helping with an excel scoring programme i am designing. The programme is ready to go. But i was wondering how clever excel was. Basically i need to create some results from the programme. Normally i do filter auto filter, which is great but not very fast if doing it manually. Would excel be able to do this.
The data i am using is always changing. I would need for it to filter the three teams, by a name defined in three cells one page. Once the three teams have been filtered i then need to get the top four scores and copy and past them into a new sheet.
I have tried recording a macro, but this does not seem to like me changing data. And is also very restrcitive. As the programme is used across three league.
View 9 Replies
ADVERTISEMENT
May 5, 2009
I have a programme which works fine on my computer at home but when I send it via email to work the 'sort' function messes up (there is a chance it could be the 'vlookup' function, though) and all the cells in the sort range lose their formula reference - which is of course a tad annoying.
The part of the programme I'm having difficulty with is this:
Range("SsNo1").Resize(d, f).Offset(a, 0).Select
Selection.Sort Key1:=Range("FRSet1"), Order1:=xlDescending, Header:=xlGuess _
, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
DataOption1:=xlSortNormal
View 9 Replies
View Related
Jan 28, 2007
i'm writing a refrigeration selection user interface, working from values on an excel spreadsheet. how to get the programme to automatically select a value from a list or range once a user has selected corresponding value from a list within a combobox. for example if a user sets the temperature of their refrigerator to -5 celsius i need the programme to automatically select the corresponding value of enthalpy for the air at that temperature.
View 5 Replies
View Related
Nov 4, 2008
If I have a scoring grade for different categories (8 in total) & the grades looks something like that: 1a=500, 1b=400, 1c=300, 2a= 250, 2b=210...& so on till 4c, but with different numbers for each category.
I need to come up with a total score of points if a person is given a certain grade from the above. ex. if they scored 2a on a certain category, 1c on
another & with all the rest of 8 categories scored. The number i need to come up with is the total points.
View 9 Replies
View Related
Mar 15, 2008
I'm doing a GCSE project for which I need a little help with Excel.
I have a set of data about a persons monthly spending habits on
Food 300
Entertainment 200
Clothing 100
Transport 260
The pre calculated budget allowance for the month was 500
I would like to write a formula that would do the following; give the person an score out of 1.1-10 based on how well he spent on the above items which are in order of priority (i.e. it is better to spend more on food than on entertainment etc) And then an over all score (1.1-10) that will reflect how well they spent.
View 9 Replies
View Related
Apr 16, 2006
I am not so sure on the correct formula syntax or the correct terminologies to ask this next formula question. It is visualy explained clearer in the spreadhseet provided.
View 9 Replies
View Related
Feb 16, 2009
I have a small query about excel and whilst there is a really simple answer i'm struggling a little bit. I have create a score metric for data surrounding search data.
Basically i need a macro/formula that will take a list of values that may include duplicates and add up the corresponding score and place the results in a table.
See below - the macro will look at a list of values (column b) and add the scores up (column d) and then remove the duplicates and populate the score in (column f/g)
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
May 1, 2013
How to delete all the players names and rounds etc. so I can input all my own.
This template is perfect for what i need for my golf society.
View 10 Replies
View Related
Jan 15, 2010
I'm creating a basic Dart scoring spreadsheet, and its been going absolutely fantastic, but then I was asked to create the Sets and Legs, thats when I got stuck.
I'm looking for a formula (or anything) that will add a Set when the Legs reach the number 3, and then again but make it 2 if that player gets another 3 legs. If you know darts you will understand what I mean.
View 9 Replies
View Related
May 27, 2006
I am putting together a worksheet and analysis sheet for relative scoring of text values. (i.e. High = 3, Med = 2, Low =1, Yes = 2, No = 1, etc. I have a problem in finding a formula that will work to retain these values of text and calculate a relative score from the answers or text provided.
View 3 Replies
View Related
Apr 23, 2007
Have used excel for a while but never the need to go past SUM or AVG, etc.
Im trying to set up a point scoring sytem for 3 teams in various events. the highest scoring team would get 2 points, 2nd place 1, 3rd place 0. If 2 teams tied for first they both get 2. If they tie for second they both get 1. I spent 30 minutes before I came up with
=IF(AND(B3>B4, B3>B5),2,0)
and
=IF(OR(B3=B4, B3=B5),1)
Spent another 15 trying to figure out how to put the 2 together. Finally realized a)Im missing a whole bunch of formula, b)There is a lot more to excel than I thought I knew.
B3,B4,B5 are the teams scores. Looking for any help at this point. Even a push in the right direction.
View 6 Replies
View Related
Oct 29, 2008
I have a scoring system I monitor in excel (I have attached an example speadsheet). I score against a number of criteria e.g. criteria 1 scores "2", criteria 2 scores "4". My problem is that the criteria don't always attract a score, sometimes they blank. I also need to specify which criteria I want to count in the scoring as they are not always relevant every time.
I need formulae that will take this into account and be ready to total up only when a score is there (COUNTIF?); and out of the range of scores I want to total up only the specified criteria at choice (SUMIF?).
My COUNTIF and SUMIF skills are failing with this which is very complex for my level.
What would the formula be in each instance? I have attached the file to reference the cells that I have questions about.
Question ?A: - is this a COUNTIF?
In this cell I want to calculate the number of occurrences where there is a score detailed, but only for specified criteria, for argument's sake criteria 1,2,3,4,7 & 8
The answer would be 5 in this instance, not 6, because Criteria "3" did not receive a score.
I would want to have other cells which would calculate the number of occurences where there had been a score but using different combinations of criteria
Question ?B: - is this a SUMIF?
In this cell I want to calculate the total sum of scores for those specified criteria where there has been a score
The answer would be 13 in this instance (3+2+4+1+3 from the scores that occurred for those specified criteria)
I would want to have other cells which would calculate the total sum of the scores but using different combinations of criteria
View 7 Replies
View Related
Jan 8, 2014
create a unique scoring system on a set of given criteria that enables an even split in work for team members. so i.e. work comes in, and depending on the criteria of work its then passed to the relevant team member based on points. At the moment work is allocated A-Z which is working out unfair on team members as some are getting more/less work than others...a points system will enable a even split. so if a piece of work scores 30 points it goes to a junior member, if a piece of work scores 80 points it goes to a senior member and so on...my problem is how to link the points and criteria...Im guessing joint vlookups will be needed.
the only other way i can think a system is similar is like a fantasy football system...points based on criteria.
View 3 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
Aug 17, 2014
this is a competition scoring sheet
i want to add this automatically
when i enter chest number then the name of winner and team name want to come automatically and the pointing also (see sample)
point first 5 point second 3 third 1
how to do this
View 7 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
