Looking For ELO Rating System?
Nov 23, 2013Im looking for a ELO rating. Its a system which they often use with Chess.
View 3 Replies
ADVERTISEMENT
Rating Columns
Sep 3, 2008I have an interest in horse racing and I use spreadsheets to help with my form study. I have reasonble knowledge generally of but am self taught.
What I want to be able to do automatically is to re rate 6 columns (shown with yellow at the top)(columns BA-BF)in a worksheet after scratching occur. I have away of eliminating the ratings out of the 6 columns after scratchings but would like to rerate the columns so the ratings start at 1 and rate up. Now when a zero appears it needs to stay a zero as that means it has no rating but where a blank occurs it would indicate a scratched horse. I want to keep the number of rows without deleting any for the scratched horses so it matches other worksheets I use and also need to keep the horses in race order.Hope this makes sense.
IF Formula To Choose A Rating
Nov 3, 2009I've different rating matrix as below;
more than 90% - " Excellent"
80% to 89% - "Very Good"
65% to 79% - "Good"
below 64% - "Low"
hence if any of the rating falls in a cell need a formula to corresponds that (lets say in cell "A1" if the rating is 85% then result should be "Very Good")
If,average,sum Formula, For Rating Chart
Oct 3, 2008I'm trying to get a formula working that is basically for a rating chart. The chart is somewhat simple, but the formula is a bit complex (for me anyway)
So the details are the rating is on three axis with three levels, and here is what I need to do.
At the moment the formula below works, but it isn't 100% accurate because I actually need to take an average of F5+G5 then take that value and add it to H5 then divide by two to get the proper average of the two charts. (if that makes sense.
=IF(AVERAGE(F5:H5)>2.33,"High",IF(AVERAGE(F5:H5)>1.67,"Medium",IF(AVERAGE(F5:H5)<1.67,"Low")))
Here is the formula that I thought would have worked, but Excel begs to differ
=IF(SUM((AVERAGE(F5:G5))+H5)/2>2.33,"High",IF(SUM((AVERAGE(F5:G5))+H5)/2>1.67,"Medium",IF(SUM((AVERAGE(F5:G5))+H5)/2<1.67,"Low")))
I played with the brackets quite a bit thinking I had something in the wrong order, but nothing seems to work. I always get FALSE in the field and an error as well when I enter the formula.
Array Formula- Performance Rating
Jun 26, 2007I have a list of employees who each have a performance rating (very top, consistent, etc). Each employee is also either above the midpoint of a salary range or below (which is represented by a separate column with 'Yes' for above and 'No' for below).
What I am trying to do is apply a separate set of %'s for each group of employees. So, for the employees who are below, I want to return 10% and 8% for each respective rating, but for those employees who are above, I want to return 8% and 6%. (for example).
Display TEXT Only Based On Number Rating And Calculations?
Jun 15, 2014I am trying to display result of risk assessment matrix in excel. I have three columns PROBABILITY , IMPACT and RISK RATING (probability *impact).
Probability = Very Low(1), Low(2), Medium (3), High (4), Very High (5)
Impact = Low(1), Medium(2), High(3)
Risk Rating = Low (value between 1 -3), Medium (value between 4 - 6), High (value between 7 - 15)
Is there any way that I just use TEXT in the cell (visible to user) and excel does its magic in the background using the numbers that I have for each TEXT? I don't want to display numbers.
Automated Target Dates Based On Priority Rating
Dec 16, 2008I have a list of issues and depending on their priority would require a different target closure date e.g. low priority = 90 days, medium = 45 days, High = 10 days.
So if I have the following columns:
Issue No (Unique Ref #)
Date Raised
Priority (Low/Medium/High)
Target Closure (based on the pre-determined criteria as detailed in above paragraph)
Can somebody suggest a formula to enter in the "Target Closure" column so it is automated?
IF Formula: Assign A Specific Letter To Each Rating, Depending Of The Obtained Number
Jun 15, 2009I have some delivery ratings from suppliers, and I want to assign a specific letter to each rating, depending of the obtained number. Criteria is:.........
View 4 Replies View RelatedMatrix To Return Risk Rating - Array Returns Opposite Result
Nov 20, 2013I am looking up a risk matrix to return the risk rating... it is very simple, it works on one sheet, but on a different sheet (looking up different data, but same basic format) it returns exactly the opposite rating.
My formula is: =INDEX($G$6:$K$10,MATCH(I19,$G$5:$K$5,0),MATCH(J19,$F$6:$F$10,0))
Here is F4 to K10
I have data validation on I19 and J19 based on the cells below
Consequence
Priority
Very Low
Low
Medium
High
Very High
[Code] ..........
BUT... when I put Very Low and Very Low in the two cells (I19 and K19) I get Very High as the return.
Points System
Jun 27, 2007Currently I'm working on a prediction game using excel. Can excel do the tabulation itself(Points awarded) if I just key in the result? Can anyone help me? Thanks in advance.
Examples below,
Result 3-1
Name Predicted Scored Points
Alex 3-1 5
Brian 4-1 4
Charlie 2-0 3
Derrick 3-3 1
Eric 0-2 0
Point System:
1 point for correct goals/no goal by either both teams
3 points for correct result ( Win, Lose, or Draw - say result is 3-1, 3 points if you predicted a Chelsea 2-0 win)
5 points for correct match results
No points for incorrect score and results.
Booking System
Mar 12, 2008I'm trying to create a lesson booking system,
View 11 Replies View RelatedPoints System..
Nov 15, 2009I m trying make a spreadsheet up to fine the following i have also included a file
raymond ran 11 seconds so he gets 150 points which is .6 of a second better than his Personal best time (PB's) but matt ran 13.6 seconds but it is 1.1 seconds slower than his Personal best time so he is minus 275 for every .100 of a second they get 25 points added or taken off
Numbering System
Oct 19, 2009Wondering if there is a formula for Excel that could replicate a numbering format like in Word?
Example:
A1.1.
A1.1.1.
A1.1.2.
A1.2.
A1.2.1.
A1.2.2.
A1.3.
and so on...
Idealy I would like to go farther than the 3rd level.
UPDATE TO ANOTHER SYSTEM
Feb 20, 2007Below is a formula that links other worksheets from other workbooks to cell B4. If I copied this to another computer system in My Documents that is named other than Tom would the links get updated to that system. If not is there a macro that can handle this to be updated to another computer system.
=('C:Documents and SettingsTomMy DocumentsHORSESHOE MASTER SCOREBOARD[2007 HORSESHOE SCOREBOARD TO 15 PTS. ANDREA & ROGER''S.xlsm] PAID UP '!B4)+('C:Documents and SettingsTomMy DocumentsHORSESHOE MASTER SCOREBOARD[2007 HORSESHOE SCOREBOARD TO 15 PTS. DAVE & PAULA''S.xlsm] PAID UP '!B4)+('C:Documents and SettingsTomMy DocumentsHORSESHOE MASTER SCOREBOARD[2007 HORSESHOE SCOREBOARD TO 15 PTS. DAVE DUVAL''S.xlsm] PAID UP '!B4)+('C:Documents and SettingsTomMy DocumentsHORSESHOE MASTER SCOREBOARD[2007 HORSESHOE SCOREBOARD TO 15 PTS. PHIL & YVETTE''S.xlsm] PAID UP '!B4)+('C:Documents and SettingsTomMy DocumentsHORSESHOE MASTER SCOREBOARD[2007 HORSESHOE SCOREBOARD TO 15 PTS.
System Of Equations
Apr 19, 2007how the Process to solve the following problem:
1A = 15x + 32y + 5z
1B = 6x + 2y + 8z
1C = 3x + 11y + 19z ...
Setup New Inventory System?
Aug 26, 2013We have 100+ clients. Each client has inventory in our warehouse. Every day we write down how many items went out to our client on a piece of paper and subtract that number to get a balance inventory. When we run low, we order more on a new FO number. What is the best approach for tracking this? I was thinking one way is to put our clients in a drop box at the top of the page and then the data will appear at the bottom, however I can't get that to work. I am trying filters to see, but I am unable to subtract the balance automatically from the last FO# and from the correct area.
Is there a way to choose a client and product at the top of the page and have the tracking below?
Create System To Measure KPI?
Jan 3, 2014I am looking to create a system to measure KPI (key performance indicators). I need to include a weekly target and then measure performance for that week against the target. I want to create a form to make data entry simple, how best it would be to implement using excel. Would I have 2 tables, one for targets and one for performance and then use look ups.
View 9 Replies View RelatedSoccer System And Dates
Feb 28, 2007Ive got an example below of how i'm sorting fixtures and how to determine winners/losers and draws.
******** ******************** ************************************************************************>Microsoft Excel - Book2___Running: 11.0 : OS = Windows XP (F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)boutF1G1H1F2G2H2F3G3H3F4G4H4=
ABCDEFGH102/03/2007Team*A**Team*B000202/03/2007Team*C**Team*D000309/03/2007Team*A**Team*D000409/03/2007Team*B**TeamC000Sheet1*
[HtmlMaker 2.42] To see the formula in the cells just click on the cells hyperlink or click the Name box
PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.
What I'm struggling with is the ability to change dates and still be able to add the teams figures up.
When adding, for instance, Team A's wins I'm using
=f1+f3
and similar for defeats and draws.
But when I change dates, for instance game 3 to the 10th, Team A is still counting F1 and F3 yet its games now in row 1 and row 4.
How can i get it to change with the sorting.
Im sorting fixtures via the sort feature in data.
Using VBA To Select An Option In A System Msg Box
Oct 6, 2007I have a button in a template file (.xlt) that will save the file as the customer name in cell C4. That template file feeds an Access database and when you save the template file you are prompted with the following system message:
If record DOES NOT exist in DB:
If record DOES exist in DB:
My code is as follows: ....
Enter System For The DF Part
Jan 10, 2008In MS Query:
Like '%ST%DF%'
Works fine.and returns:
DOCIDREVISION
31ST-9DF02007
40ST-9DF01006
73ST-9DF01016
74ST-9DF01011
74ST-9DF02004
I want to use the [Enter system] for the DF part.
When I try to use the following in MS Query:
Like '%ST' & [Enter Sys] & '%'
the pop up window appears but after entering DF
I receive an error: Missing Right parenthisis or illeagal variable?
Add The System Time To A File Name
Feb 25, 2009How do I add the system time to a file name
My
ChDir "S:ProductionProduction Request Forms"
ActiveWorkbook.SaveAs Filename:= _
"S:ProductionProduction Request Forms" & SaveWorkbook & "_Request" & Time & ".xls", _
FileFormat:=xlNormal, Password:="", WriteResPassword:="", _
ReadOnlyRecommended:=False, CreateBackup:=False
Interesting System Error
Mar 3, 2009The macro below will generate a System Error '-2147417848 (80010108)' when executed as shown below but only when there is a value in the 6th column that ends in .0006(or .00061). It will however run if no empty cells are present after the cell with .0006 in the 6th column (i.e. J = 1 to 6). This can be avoided by using the "On Error Resume Next". What is strange is if the value ends in anything other than .0006(or.0061) in the 6th column it will work fine (i.e. .00062 or .0005).
In a new workbook I have the following values in A1:B6
1125924.4684333.2496895-1217.935514LOFT -1785884.895
2422123847.627 221.0003 -482.8184125LOFT -1698521.0006
The Macro:
Sub Macro1()
'
'
'On Error Resume Next
Application.Calculation = xlCalculationManual
Set OldWb = ActiveWorkbook
Set NewWb = Workbooks.Add
Application.ScreenUpdating = False
For I = 1 To 2
For J = 1 To 7
NewWb.Sheets("Sheet1").Cells(I, J) = OldWb.Sheets("Sheet1").Cells(I, J)
Next J
Next I
Application.ScreenUpdating = True
Application.Calculation = xlCalculationAutomatic
End Sub
Getting Username From System In A Cell
Apr 17, 2009I am trying to get the username from the system to display in A1 in a file in Excel. I got this code form internet and put it in the sheet by clicking right mouse on the sheet1 tab and view code and then pasted it there.
Function UserNameWindows() As String
UserNameWindows = Environ("USRNAME")
End Function
And then as per the instructions on the same page I inserted this formula in A1 : =UserNameWindows()
The person stated that by doing this, I should be able to get user name displayed in A1. BUt all it gives me is #NAME?.
Points System Using Nested Ifs
Jun 12, 2006I am trying to work out a point scoring system and have the following formula =IF(OR(C9="",F9="",'Winning Scores'!C7="",'Winning Scores'!F7=""),0,IF(C9+F9='Winning Scores'!C7+'Winning Scores'!F7,"3","0")+IF(OR(AND(C9>F9,'Winning Scores'!C7>'Winning Scores'!F7),AND(AM!C9<AM!F9,'Winning Scores'!C7<'Winning Scores'!F7)),1,0))
Which is basically saying that if C7 and F7 = C9 and F9 in the 'winning scores spreadsheet, to give 3 points but it is returning 3 points if C7=F9, and I only want it to relate to C7 - do you know how I would do this?
I also need to award 1 point if the highest score is chosen but not if the exact score, hence if the score was '3' '2' and the person chose these exact numbers 3 points would be awarded but it they chose '3' 1' only 1 point would be awarded as they chose the winning team
Flashcard System For 2 Languages
Jul 27, 2006I'm currently studying japanese and I need to make a flashcard system so that I can memorise words a lot faster. An old friend told me that it is possible to make a flashcard system in excel (or maybe Access due to its database system - I cant remember which sorry). I'm looking at a basic system that first shows me the japanese - then i click it and it reveals the english, click the english and it then moves onto the next japanese word etc etc. Though, I have no idea where to start in building such a system, my excel knowledge is not great but it I'll give anything a try
View 2 Replies View RelatedFile System Object
Feb 14, 2007how the "File System object" works in Excel?
I have a various information in one log file, which need to import to excel. So it's i need to declare all fields i need?
Creating Ranking System
Mar 27, 2007I am trying to create a spreadsheet that will automatically create a ranking system after data is input manually.
If you look in the example, you'll see roughly 30 people will be ranked on various metrics, and on another sheet, I would like 1-30 to be displayed in each of the different metrics, thus creating a ranking.
I'm not sure how to go about doing this, and any help would be greatful. I've tried different excel tutorials and searched and searced the help features, but couldn't exactly find what i was looking for.
Error 429. EXTRA.System
Jul 13, 2007I've got this code that I use to open the active session of a program I use (EXTRA! 8.0). When I try to code it to open a specific new instance of the program, I get a run-time error 429. When I debug, it's stopping on the line where I get the new instance. I've searched on this issue, but I still don't understand what the problem is.
Sub log_in()
Dim Sys As Object
Dim Sess2 As Object
Dim lngOldSysTimeout As Long
Set Sys = CreateObject("EXTRA.System")
If Sys Is Nothing Then
MsgBox Prompt:="EXTRA! not properly installed on this PC." _
& " Terminating execution.", Buttons:=16, _
Title:="E!PC Not Properly Installed"
Exit Sub
End If
Set Sess2 = GetObject("C:Program FilesExtra!sessionsCCS2.edp")
If Sess2 Is Nothing Then
MsgBox Prompt:="DLC.edp not found. Terminating execution." _
, Buttons:=16, Title:="E!PC Not Properly Installed"
Exit Sub
End If
End Sub
Detect Operating System
Mar 8, 2008how can I detect the OS of the computer a sheet is running on and launch a macro accordingly?
I have built a calculator that utilizes an embedded wave file but doesn't work correctly with Vista. With Vista it actually causes WMP to be launched instead of just playing the file. So I was hoping to be able to skip the sound on Vista machines but play for all other OS's.
Making Big Data System Into Table?
Jul 1, 2014I have a big system of data, me not knowing better i have it such that the categories is listed in the start of the row, and new data for periods are listed in the columns following. when i mark the data and click table, it puts the scroll down thing on top of the columns, which is of no use to me at all, i need them at the start of the row. is this possible, or do i need to reorganize all the data, and VBA code used to sort and collect it ?
View 7 Replies View Related
