Table Tennis ELO ratings spreadsheet?

Hi all,

Many thanks in advance for any help you can give here. I downloaded a spreadsheet which I think is laid out how I want it to be. A simple way to record sets won down the left hand side, and then each players rating change after that game. It means I can scale the spreadsheet accordingly and see what is happening game by game. It's a bit long winded, but otherwise fine for me.

However, my main problem with the spreadsheet is that the ratings "increase" or "decrease" following a win isn't scaled in the way I would want it to be. For example, we have Simon starting on 1900 points, and Jess starting on 1300 points (based on their current estimated skill level), which I would consider a huge gap. When Simon beats Jess, his points increase isn't scaled to her rating, but is instead scaled to his own rating. The higher Simon is, the less points he will gain... as opposed to also factoring in that Jess is a much lower rated player so he should get almost no points increase by beating a lower player.

Is there any way of setting it up so I can easily tweak the points +/- based on my preference? The kfactor at the top left might be aiming to do that, but I don't see it as very effective. Also, for some reason the kfactor only applies to cell E2 for some reason, then there is a static "30" factor seemingly added on the rest of the cells. I'm therefore a bit confused and not understanding this spreadsheet very well.