Excel protected but without password. -----Messaggio originale----- Da: Piaggio, Marco Inviato: venerdì 28 maggio 2010 10.53 A: 'acc_tr_vsk@xxxxxxxxxxxxx' Oggetto: R: [acc_tr_vsk] Swapping for the micros Good Jluc! I try to do this with a execl (see attached document) It is very simple but it can be used only for 4x4 and 7 races, minimum 4 partecipants. Verify if can be usefull. You have to change only the "alphabetic name" a, b, c, d, e ... with the partecipants name and leave space for absent, and press "ctrl r" to activate macro. -----Messaggio originale----- Da: acc_tr_vsk-bounce@xxxxxxxxxxxxx [mailto:acc_tr_vsk-bounce@xxxxxxxxxxxxx] Per conto di jd-pmc@xxxxxxxxxxxxx Inviato: venerdì 28 maggio 2010 10.33 A: acc_tr_vsk@xxxxxxxxxxxxx Oggetto: [acc_tr_vsk] Swapping for the micros Hello good Fellows, For the next micro, i have generated a random list of the UNT: alb keeper adoonis colibri aimo rein darrengbr jiel We shall use a circular swapping very simple based on this list. map1: alb,keep,adoo map2: keep, adoo, coli map3: adoo, coli, aimo ... and so on map7: darren,jiel, alb If someone is absent, the system remains but his name is removed from the above list. If someone joins during the event, his name goes at his proper position. As it will be 3vs3 races, if all are present we shall need 7 races to allow all to participate to at least 2 races. If one of us is absent, we shall race only 6 maps. And so on with a minimum of 5 races played. CU soon, Jluc No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.819 / Virus Database: 271.1.1/2895 - Release Date: 05/27/10 20:30:00