by keme » Mon Jun 23, 2008 10:53 am
First, the original submission has a bug in the range used for "rank arbitration", making it fail sometimes. Corrected here (I hope...)
I made a few shortcuts to facilitate copying of formulas.
When selecting teams, the "rank displacement" depends on the team column, so in column A you will have the 1st above and below the middle of the ranking. In column B the 2nd, etc. That means if you want to extend the teams list, you just copy the 3 bottom rows of column H as far as you need to the right. If you want a teams list elsewhere, you probably need to alter the formulas. You can safely overwrite the team deviation box when copying, as it doesn't serve any purpose other than displaying the standard deviation in team strength.
If you insert rows below a range, you start outside the range. That means the range is not expanded in formulas. If you insert new rows inside the range (between row 2 and 17 in the original file), all formulas using that range will adjust to the new range. Right click in the row numbers to insert new rows.
As for larger teams, if they have even numbers you could just combine the pairs to make teams of 4,6,8..., or you could insert the pairs as source of a new (identical) selector sheet to have better weighted setups for teams of 4 (and with one step further you have teams of 8, etc.)
In any case, with more than two players there are more options than the pairing that we examine here, so you're not certain to get a "best match" anymore ("fairly good match" at best). For that you need something more advanced than the list approach.
 Attachments

 bestmatch.ods
 (11.31 KiB) Downloaded 110 times
Apache OO 3.4.1/4.1.2/4.1.3, on Ms Windows 7/10 and Mac OSX 10.8.5 and 10.11.
LibreOffice 4.3.3.2 on Mepis Antix MX 14