Found under the Data menu, Named Functions are curated LAMBDA functions for Chartroom.
Converts a table of Chartroom rink numbers into a comma and semi-colon-separated text string.
Usage: For a pool of 14 teams playing 3 rounds enter the formula e.g. =GETRINKS(E5:AC18) in any blank cell, gives text likeĀ 1,6,3;1,4,7;2,7,4;2,3,6;3,1,5;3,2,1;4,2,6;4,1,2;5,3,7;5,7,3;6,4,1;6,5,4;7,5,2;7,6,5
Expands a Chartroom rink string into an existing blank pool.
Usage: For a pool of 14 teams playing 3 rounds enter the formula =EXPANDRINKS("1,6,3;1,4,7;2,7,4;2,3,6;3,1,5;3,2,1;4,2,6;4,1,2;5,3,7;5,7,3;6,4,1;6,5,4;7,5,2;7,6,5") in the cell for Team 1 Round 1. Be sure to set the rinks by selecting, then going Ctrl+C followed by Ctrl+Shift+V.