Thanks for the help fixing my math - my spreadsheet now works. This helps me understand what one can gain or lose in a give match, and I thought others might find it useful as well. Note, these points are for streetsoccer. O-Y is your opponents ranking - your ranking. Thus a negative number means he is better than you. win(d) is a win in extra time. Thus if you play someone ranked 300 points lower than you (-300) and lose, you will lose 27 points. Winning will only gain you 5 points. Hope this helps others as it helped me

(O-Y) win lose win(d) lose(d) draw

-300……5…..-27…..-2……-21…….-8

-250……6…..-26……0……-19…….-7

-200……8…..-24……1……-18…….-5

-150……9…..-23……3……-16…….-3

-100…..12…..-20……5……-14…….-1

-50…..14…..-18……7……-12……..1

0…..16…..-16…..10……-10……..3

50…..18…..-14…..12…….-7……..5

100…..20…..-12…..14…….-5……..8

150…..23……-9…..16…….-3…….10

200…..24……-8…..18…….-1…….12

250…..26……-6…..19……..0…….13

300…..27……-5…..21……..2…….14

The math:

change = 32*(R-E)/M

M= max result (5 in streetsoccer)

R = result of match (5 for win, 4 for win draw, 0 for loss, etc)

E = expected result

= M/(1+10^((O-Y)/400))

where O = opponents ranking, Y = your ranking

with courier font

(O-Y) win lose win(d) lose(d) draw

-300……5…..-27…..-2……-21…….-8

-250……6…..-26……0……-19…….-7

-200……8…..-24……1……-18…….-5

-150……9…..-23……3……-16…….-3

-100…..12…..-20……5……-14…….-1

-50…..14…..-18……7……-12……..1

0…..16…..-16…..10……-10……..3

50…..18…..-14…..12…….-7……..5

100…..20…..-12…..14…….-5……..8

150…..23……-9…..16…….-3…….10

200…..24……-8…..18…….-1…….12

250…..26……-6…..19……..0…….13

300…..27……-5…..21……..2…….14