Gaming Swiss Algorithm

Hi,
I am interested in an expansion to this spreadsheet:http://www.excelforum.com/showthread...33#post4414633

in the similar way to the backgammon question. It is like rugby, where the score that a team gets is a combination of the number of tries and the number of kicks - so instead of just entering "win" for white, you enter "2 tries, 7 kicks" and that gives a score of 2x5 + 7x3 (5 for a try, 3 for a kick). I would like to be able to enter the number of tries and the number of kicks. I will have a go at doing this myself, but if someone was able to have another look at it that would be amazing.

Thank you,
Mike

Many thanks to Kaper - after about 12 hours coding I've adapted it for my game (Blood Bowl!): http://www.sann0638.co.uk/exscore/

Glad to hear that.
Would be lovely if you post the adopted version here - then someone else could benefit too.

Best,

Kaper