Rating sheet for chessplayers

[mackobae]

Hi, I don-t know what forum I should post this in. Sorry if it-s placed wrong.

Chessplayers has rating that varies each game they play. The change depends on (obviously) the outcome: win, loss or draw. How much is added or removed from the players rating depends on the difference of the opponents rating.
All this can be read from a table off course.

I-m a bit of a excel novis as well as an english novice obviously, so I wonder how to get this in to an excel sheet so I can just fill in my opponent, their rating, and so the sheet goes in to the table and, well, makes the count for me.

Anyone? Is this possible?

[jwright650]

Is this "ratings table" already on an Excel spreadsheet? What you describe sounds very possible in Excel, just need more specifics on how your sheet will be laid out...maybe work up a sample sheet and attach it to your post so that somebody trying to help will have something to work with, rather than spending a bunch of time creating something from scratch.
Just offering some suggestions to help you get your questions answered quicker.

[mackobae]

Is this "ratings table" already on an Excel spreadsheet? What you describe sounds very possible in Excel, just need more specifics on how your sheet will be laid out...maybe work up a sample sheet and attach it to your post so that somebody trying to help will have something to work with, rather than spending a bunch of time creating something from scratch.
Just offering some suggestions to help you get your questions answered quicker.

Good suggestion. I have made a simple sheet. At the bottom the table I want the excelsheet to use for the difference in rating to add or substract.

[jwright650]

Good looking sheet...now, how do you read it?..LOL
Guide me through what is supposed to happen to the scores and how the math works for wins, losses, and draws. I think we can get this sheet operational once we figure how what needs to happen to the scores.

[mackobae]

Hehe.
Ok. At top the Old Rating, is the rating that I have and what is used to calculate the changes.
Opponent 1 etc are the opponents I meet, their rating, the result of the game, the difference in my rating to my opponents.
In the table form row 20, are the numbers to change rating. The result against opponent 1 was a win = 1. Ok, in the table I read that I then get 9 points to add to my old rating. I need the sheet to understand to read the difference in rating, look in the table, pick out 9, and put it in the change column. The the New floating rating changes to 1825+9=1834.
Opponent 2: 1825-1534=291. I won, hence the 1, so in the table I pick up 5 points to add. So the floating rating will say: 1834+5=1839.
Opponent 3 has better rating than me. So the difference is 153 in my opponents favour. The I have too collect the points from the right part of the table, Player with inferior rating. so 0,5, draw that is, gives 7 points. New floating rating than is: 1839+7=1846.
And so on.

[Ed_Collins]

Try this and let me know if that helps.

The IF / VLOOKUP statement proved to be too complex for me to enter it in one cell... so I "cheated" and entered it six in different cells and then just hid the result of these cells by setting the font color to match the background color.

chessrating.xlsx

[Ed_Collins]

By the way, I'm a tournament player also, with a USCF rating of 1809.

[mackobae]

Ed_Collins. Fantastic!!! Many thanks!

[mackobae]

I have now extended the sheet somewhat. The table is on it's own sheet, and I have prolonged the number of possible opponents.
As you can see i now have a problem. i don't want the sheet to do the calc before I have filled in the cells.
optimum would be to be able to fill in a coming tournament and the the sheet does all math but leaves the change until the result is filled in.
If there is no opponent filled in at all, the sheet would then leave everything blank.
Is this possible?

[Wagstaff]

Assuming you dont want to calculate until col d is filled in, use this formula in col e

Please Login or Register  to view this content.

Then for the formula in col f use this

Please Login or Register  to view this content.

Regards

[mackobae]

Doesn'7 work for me. :-(

[Wagstaff]

chessrating (1).xlsxOk,

I have changed the formulas to read from col A

Is that what you are after?

[mackobae]

YES!!
And the reason it didnt work is that I use a swedish Excel. So the command IF is OM iin swedish. :-)

Many many thanks everybody!!!

[jwright650]

Many many thanks everybody!!!

Glad to see that you got your sheet all fixed up and working