Ranking Racing Sheet

Nov 7, 2007

First off, can someone guide me to a better formula to E2:E14 or E21 if used later without the array? Other folks will use this workbook. Next, is there a way to do that without using columns F2 or G2. There are numbers below 0 to take into account that need ranked. The whole idea is to rank them as to whatever #'s are closest to 4.7000. I eventually want it to match the name in column- A2 to the appropriate ranking. 0.0000 is #1 and the highest abs would be #13-(1.0098) in the sheet. If anything in A2:A21 is added or removed I'd like the entire row to remain "blank".

************************************************************************>Microsoft Excel - newstart.xls___Running: xl97 : OS = Windows ME (F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)boutD2E2F2G2H2D3E3F3G3H3D4E4F4G4H4D5E5F5G5H5D6E6F6G6H6D7E7F7G7H7D8E8F8G8H8D9E9F9G9H9D10E10F10G10H10D11E11F11G11H11D12E12F12G12H12D13E13F13G13H13D14E14F14G14H14=
ABCDEFGHI1Name / Car #1st Pass2nd PassBest Run4.70000 Name2Bartlett 5254.65694.55594.6569-0.04310.00000.00001Moody3R. Stringer 41334.72264.58994.5899-0.11010.00010.00012S. Stringer4Norman 4894.73474.68924.6892-0.0108-0.00030.00033Powell5M. Jones 46594.73534.69934.6993-0.00070.00040.00044A. Mears6Powell 4134.73944.69974.6997-0.00030.00050.00055K. Rierson7Penner 42914.78304.99034.78300.0830-0.00070.00076M. Jones8Moody 49074.81024.70004.70000.0000-0.01080.01087Norman9A. Mears F4094.92884.70044.70040.00040.01180.01188D. David10K. Rierson 450R5.57334.70054.70050.0005-0.04310.04319Bartlett11Muse 47995.84025.70215.70211.00210.08300.083010Penner12LH Newlin 44425.84525.70985.70981.0098-0.11010.110111R. Stringer13D. David 48386.42984.71184.71180.01181.00211.002112M. Muse14S. Stringer 4229.20154.70014.70010.00011.00981.009813LH Newlin15 Sheet1
[HtmlMaker 2.42] To see the formula in the cells just click on the cells hyperlink or click the Name box

View 12 Replies


ADVERTISEMENT

Grading Sheet With Ranking

Jan 30, 2009

I'm a Navy instructor with a monster of a workbook. Im doing fairly well considering my lack of Excel knowledge but can seem to figure this out. The following is straight out of my workbook and represents 1 out of a possible 30 students. Sometimes I get 15 and sometimes 30.
JOESCHMOE123-45-6789#TESTGRADERETEST%PointsTotalAverage1Maint. Test1007.5%7.5007.500100.000%2Maint. Prac10017.5%17.50025.000100.000%3US Test1007.5%7.50032.500100.000%4US Prac17.5%0.00032.500100.000%5ST Test7.5%0.00032.50065.000%6ST Prac17.5%0.00032.50056.522%7SurfXit Test7.5%0.00032.50043.333%8SurfXit Prac17.5%0.00032.50039.394%

I have 8 tests with 2 different weightings (7.5 and 17.5). Ive figured out how to calculate everything but a way to rank each student by grade percentage. Is there a way to calculate the class standing out of all the students with green color for top top 10%?

View 12 Replies View Related

Ranking Values And Ranking Duplicates The Same Rank

Mar 30, 2014

Ranking values and ranking duplicates the same rank I'm looking to rank a group of numbers that will possibly have duplicate numbers that I want to show as a tie but have no break in the rankings.

Example:
20
18
18
15
12
11
11
9

The ranking I am looking for is:
1
2
2
3
4
5
5
6

View 2 Replies View Related

VBA To Compare Racing Times

Dec 30, 2008

I have a spreadsheet of about many rows and 5 cols shown in the attached. I show 3 races..each will have a different time to the previous race. I want to use the rsq function to compare the data for that race in col c with that in col d and produce the answer for the 1st race in each row in col e for that race..then proceed to do the same for race 2,then race 3 etc...

I need a formula in e2 I can drag down...each cell in col e should be filled with the answer for that race..I have thousands of races..

View 4 Replies View Related

Populating A Table From A Separate Sheet Based On Ranking

Mar 21, 2014

I'm looking to populate tables for specific tasks that my site performs and compare their performance against the other top sites in the company. I need to pull the site # and their performance based on the task, ranking them from first to last.

View 5 Replies View Related

Horse Racing / Betting Formulas

Aug 3, 2007

I've made my own spreadsheet to record my racing bets. Everything works great, however I want to expand it to become more complex.

There are 2 formulas I'm having trouble creating:

1...the formula for dead-heat finishes including the Rule 4 deductions (2,3 & 4 way dead-hets)
2...the formula for each-way bets including the Rule 4 deductions (the win part & the placed part)

I guess only people with knowledge of horse racing / betting will be able to help me on this.

View 9 Replies View Related

Summary Of Horse Racing Statistics

May 6, 2009

i need to do the following on the attached spreadsheet using a macro: SHEET 1. This is an example of the original data i will be working with i need

1) You will notice that the Min and Max columns are not all together, i need these to all be together. I then only want the Race course, race time, date and type, Min, Max and ratings.

2) I then want the following formula added to Column F, Max minus Min. In column G i would like the following formula Rating minus Min. And finally in Column H Rating minus Max.

3) I would the like to Highlight in Yellow the horse with the highest possible number. I want this done for each column (F,G,H) in each race i would like all Horses that dont have a yellow cell in any of the Columns (F,G,H) to be deleted, leaving me with just the highlighted horses. An example of the required final result is contained in Sheet 2 of the attached spreadsheet.

View 2 Replies View Related

Horse Racing Odd's Line Formula

Oct 7, 2006

I have odds line numbers on this excel sheet which is the VL column. I'd like to be able to scratch a horse, (delete a horse from the sheet) and the odds line (VL column) will update to the new value after the horses is scratched from this sheet.

Now I do this in a program that uses VBA and transports this info to Access, where then I export to Excel to this sheet.

Here's the formula I use for the odds line...

#EQUAL(#COLVAL(51),1, .00001)*((#COLVAL(53))-(#COLVAL(53)*.4))/(#COLVAL(50))+
#EQUAL(#COLVAL(51),2, .00001)*((#COLVAL(53))-(#COLVAL(53)*.25))/(#COLVAL(50))+
#EQUAL(#COLVAL(51),3, .00001)*((#COLVAL(53))-(#COLVAL(53)*.10))/(#COLVAL(50))+
#EQUAL(#COLVAL(51),4, .00001)*((#COLVAL(53))+(#COLVAL(53)*.05))/(#COLVAL(50))+
#EQUAL(#COLVAL(51),5, .00001)*((#COLVAL(53))+(#COLVAL(53)*.10))/(#COLVAL(50))+
#EQUAL(#COLVAL(51),6, .00001)*((#COLVAL(53))+(#COLVAL(53)*.25))/(#COLVAL(50))+
#EQUAL(#COLVAL(51),7, .00001)*((#COLVAL(53))+(#COLVAL(53)*.40))/(#COLVAL(50))+
#EQUAL(#COLVAL(51),8, .00001)*((#COLVAL(53))+(#COLVAL(53)))/(#COLVAL(50))+
#EQUAL(#COLVAL(51),9, .00001)*((#COLVAL(53))+(#COLVAL(53)*1.3))/(#COLVAL(50))+
#EQUAL(#COLVAL(51),10, .00001)*((#COLVAL(53))+(#COLVAL(53)*1.6))/(#COLVAL(50))+
#EQUAL(#COLVAL(51),11, .00001)*((#COLVAL(53))+(#COLVAL(53)*1.9))/(#COLVAL(50))+
#EQUAL(#COLVAL(51),12, .00001)*((#COLVAL(53))+(#COLVAL(53)*2.2))/(#COLVAL(50))+
#EQUAL(#COLVAL(51),13, .00001)*((#COLVAL(53))+(#COLVAL(53)*2.7))/(#COLVAL(50))

I added a couple of columns in the excel sheet to occomadate this formula which should work if coded into excel properly. Notice the (50), (51), (53) numbers.

(50) = TC in this excel sheet
(51) = 2V in this excel sheet
(53) = TCa in this excel sheet
VL column is where this formula updates to.

I have one other minor problem with something else, but so not to confuse, I'll mention it later.

View 9 Replies View Related

Ranking Without Zero And Ranking On Multiple Factors?

Aug 12, 2014

I am facing some problem with ranking formulae. Attached is a file illustrating them.

Problem 1: Ranking without zero I have a set of data for products. They have a number next to it. Some of the products have a ZERO value next to them. I want to rank the data in an ascending order while ignoring the products with ZERO value next to them.

Problem 2: Ranking on multiple factors I have a set of data for 50 products. There are 5 factors based on which I want to pick the best and the worst. Each factor has a value which can be a negative number, zero or positive number.

This is what I am doing presently: Ranking the products on each factor in a separate column. Points are assigned based on the ranking, i.e. if the ranking of "product A" on Factor 1 is 32, then it gets 32 points It is assumed that equal importance [weight] is given to each factor, thus average points is calculated based on ranking of each product on each factor. Average points are again ranked in descending order The top & bottom 10 are picked from this ranking.

Number of products and number of factors can be different for each analysis. Presently I am giving equal importance to the rankings for each of the factors, what if I have to give varied importance [weight] to the factors.

View 1 Replies View Related

Charting Live Horse Racing Odds

Sep 28, 2009

I have a line graph which I use in conjunction with live horseracing odds. On the vertical axis are the odds which are sourced from a worksheet. Each horse is represented by a data series that moves along the horizontal axis. The refresh rate is determined by the user embedded in the code.

I would like to expand the length of each data change along the horizontal axis as the data can be volatile. Sometimes there are rapid changes on the vertical axis which makes it difficult to interpret. With each refresh the line data moves about 3mm. It would be much better if it were about 5mm, especially as I now use a widescreen display.

There are no values on the horizontal axis as such, only time is suppose set by Excel?

View 9 Replies View Related

Counting Macro Based On 2 Criteria (Horse-racing Spreadsheet)

Jun 21, 2006

Horses have 5 running styles; early speed to late closers; denoted as 1 to 5 in column Z. I'd like to count those noted as 1 thru 3 for each race.

In column FC (the last column with data) I have a race ID # for each race on the spreadsheet, somewhere between 2500 to 5000 races in each one. They're a monthly record. The race ID # is a concatenation of columns B (Track ID), C ( Date) & D (race #). Each is unique to its race. E.G. Aqueduct, jan 1st, 2004, 2nd race is id'd as AQU379872.

Would it be possible to create a macro that would (A) count the number of horse 1s, horse 2s & horse 3s from a specific race ID & then post those numbers in columns FD thru FF & (B) then continue to the next race ID in column FC & count those horses from that race & so on thru the entire spreadsheet?

Would it be simpler if each race ID were changed to a number--race 1 down to race 2500?

View 9 Replies View Related

VBA Ranking

Jan 7, 2009

I have a sheet name "GP", and the range "A1:A5".

I need your kind help with a code that if the cells in the range become 10, then the cell across in column B will rank the order of the cell that scored 10.

ie: if A2=10 then B2=1st, A4=10 then B4 = 2nd, A5=10 then B5=3rd, A1=10 then B1=4th, A3=10 then B3=5th.

The ranking is placed according to the which cell results to 10 first.

View 9 Replies View Related

Ranking Without Gap

May 4, 2006

i need to rank database and get an output of 1, 2, 3, 4, and ect. even if the first 2 had a tie of 1; 1;. So if i have 500 records and the first 3 are tie at 1st place than the next rank should NOT be 4 but instead should be 2 and so on. Is it possible?

# Rank
65 - 1
65 - 1
65 - 1
60 - 2
58 - 3
58 - 3
50 - 4

View 6 Replies View Related

Ranking With Two Criteria

May 6, 2014

Formulas for ranking by column "PTS" and then by "DIF" if the PTS are equal for two or more teams...

View 5 Replies View Related

RANKing Words?

Feb 9, 2009

The Excel function RANK allows one to automatically rank a number within a given range of numbers. Can anyone think of a way to do the same thing with words?

For example, imagine a list of 20 words in a column, with space to add ten more words (complete range B2 to B31, which include the last ten blank cells). If these were numbers, then in the previous column one could simply put in the RANK formula covering the full range, which would then auto update as you added more numbers to the spare ten cells of the range. Assuming that all the values being ranked are unique, and you would therefore get a unique rank number, to order them in rank order, one would simply have the list of possible rank values a column or two removed and VLOOKUP the ranks and their appropriate values.

But what if these numbers were WORDS? The first 20 words are FIXED and will not change, the next ten cells of the range could have any other words typed into them. There is no RANK function for words so how would you suggest that ranking by words is achieved, that does not require any intervention, and as new words were added to the spare ten cells in the range, then the rank would automatically update? This list of ranked words would then be VLOOKUP’d in the same fashion as above with the final list being used to fuel a drop down box, so the user would have an alphabetical listing of all the potential words in the range.

View 7 Replies View Related

Ranking To Ignore 0

Apr 27, 2009

I need the folwing formula to ignore any 0 in column Q, and rank only values of 1 or greater.

=RANK(Q6,$Q$6:$Q$20,1)

View 3 Replies View Related

Ranking Query

Apr 30, 2009

I have a spreadsheet which we use to rank scores for our golf society.

At the start of our season it was decided that if anyone of the top 3 scores were tied we would separate them using a second criteria(back nine score). Any scores from position 4 down would still be tied.

From searching this forum i have managed to separate ties using the 'back nine' second criteria(using a hidden helper column) but only for all the ranking positions not just the top 3.

I have attached the file.

View 9 Replies View Related

Ranking Formula ...

Jun 10, 2009

I need to rank sales with Nation, Area and Division. I figure how to calculate National rank, Area but have a bit of an issue with Divisional Rank. I need to re-calculate division rank by looking at Area rank and if this individual already .....

View 9 Replies View Related

Ranking - Ties

Jun 17, 2009

I've a problem with scoring using the rank formula.

Example: four players score, 28,17,39,6. The 39 score wins, gets 4 points, 28 = 3points, 17 = 2 points, 6 = 1 point.

The rank formula will work this out fine.

However if you get two scores tied, for example 28, 28, 39, 6, using rank the points score for each 28 returns 2 when I actually need it to be 2.5
(Thats 3points +2points / 2).

View 11 Replies View Related

Ranking Assistance

Oct 13, 2009

i was looking for some assistance in regards to a formula i have used for ranking. i have attached a sample spreadsheet of what i have done so far but struggling to work something so thot id try here.

(Sample WB) Currently i have managed to rank in accordance to column E but as i have alot of 0% i would like to be able to rank the 0% in accordance to the number of work done (column C).

For example i have 62 0% answers and Username Q has actioned 316 jobs with 0 Failures so should be ranked 1st as he has the highest number of jobs.

View 12 Replies View Related

Non Numerical Ranking

Feb 3, 2010

Is there an equivalent of =rank for non-numerical data? If not, is it possible to sort data (into another column if necessary) alphabetically without resorting to a macro?

View 12 Replies View Related

Ranking A List

Jan 21, 2006

I have a list of values that I need to rank in descending order. Usually
the RANK function is OK, but here is my problem. I need the list to use
'generous' rules. If there is a tie for 2nd, lets say, then I need the next
place to be 3rd, NOT 4th as the RANK function does.

eg
Scores Rank(correct) Rank(wrong)
14.04 1 1
12.665 2 2
12.665 2 2
11.725 3 4
0.000 4 5

View 9 Replies View Related

Ranking, Ordering

Jan 29, 2010

A number of columns (B to U) contain names, details and scores of players. The A column contains the ranking, e.g. 1 to 100.

If a player (row) is deleted, that ranking number is also gone. Is there a way to make the A column always maintain the integrity and completeness of the numbering, e.g. if rank (row) 16 is deleted, the range of B17:U100 moves one row up and the former 17 is now 16? And if a new row is inserted, the ranking numbers after the insertion move up one row and a new number is added at the end?

2. There are 6 columns of scores, P to U. But out of these 6 scores, only the best 4 count for the ranking. The two worst (highest) scores are dropped. Is there a way to automate the process by selecting only the 4 best (lowest) numbers to be summed into the Total column (C), which in turn determines the rankings in the A column?*

And then can the whole range B2:U100 automatically be sorted according to the ranking in column (A)?

*It is possible that there are 3 or 4 bad scores, all with the same value. In that case only 2 could be discarded, and 1 or 2 would be summed into the ranking cell.

View 8 Replies View Related

Ranking Values 1 To 100?

Jan 22, 2014

I have a data base of numbers Columns C to K with values from Row 2 to 3766. I want to rank each of these columns by value 1 to 100. However, some of the columns will assign 1 to the highest value and 100 to the lowest. In other columns it will be reverse, 1 is given to the lowest value and 100 to the highest. I can do a rank by percentile but that's not the scoring I'm looking for. Also don't know how to reverse assignment of high or low values. One further note, some of the cells are blank in which case I want to assign a neutral score of 50.

View 2 Replies View Related

Ranking And Points Behind

Feb 21, 2007

im doing a excell sheet for a fantasy league that i ahve created. I have a "total" cell to combine the total points for each player. I then used the "rank" formula to rank the highest points to that player. My question is...can i show like how many points behind everyone else is from who ever the "rank 1" is in?

Not sure if you can do 2 formuals in same cell or not. maybe i could have rank and how many points are behind in same cell

Example. lets say
Player points rank
Tim 5000 1
Jimmy 4000 2 -1000
Sara 3500 3 -1500

View 9 Replies View Related

Ranking The Employee

Feb 2, 2009

i have two col A and B

In col A name of the employee
In col B there production for the Month

I need in c col to rank them that according to there production for the month like 1,2,3, etc.

View 9 Replies View Related

Final Ranking

Feb 12, 2009

I need to do a final ranking for the employees those who have been already ranked on three different segments. And there will be also employees who are not qualified for the ranking in any one of the three different segments. So in the final ranking need to find the final qualified employees who are ranked in all the segments and we need to rank them, and the employees who are not qualified also has to be mentioned.

View 9 Replies View Related

Time & Ranking

Jun 19, 2009

I am trying to create a time sheet:

I need to mearsure the time in atleast MM:SS:MS. (Minutes:Seconds:Milli Seconds). what is the best way to do this?

Then once that is sorted out I need to rank the times? e.g. lowest time 1st, second lowest 2nd and so on.

View 9 Replies View Related

Conditional Ranking From B6:J6

Oct 17, 2009

[data] ...

I need to be able to rank the numbers in the bottom row above based on the criteria in the yellow above. e.g.

Amoung all m's Phil = _____
Amoung all m's red's Phil = _____
Amoung all m's washer's Phil = _____
Amoung all m's washer's Team1 Phil = _____ etc etc

I began using a series on concatenations and found a nice sumproduct formula that worked well going up and down the column, but how can i do the same going across the columns.

View 9 Replies View Related

Reverse Ranking

Jul 28, 2006

I have a column of events,there are 7000 in my sheet.The scores for each contestant in the event are in col.2. In col 4 I have the rank printed for each contestant in each event in ascending order.I want to know how to print them in opposite order i.e highest in each event is ranked 1 etc into column 5.

View 9 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved