Home

race result 11: Advanced Users Guide

Contents

1. 1 4 Bunch Times Bunch times are common in cycling as long as the gaps between the riders in a field are less than for example 1 second all of them receive the time of the first rider in the field There are two ways to do this in race result one is easy to use but does not run in real time calculation the other does but is more complicated Easy Option The field RankXPrevYRepeatedZ Will return the bunch time of result Y The previous rider is defined by rank X and the gap between two riders needs to be less or equal Z seconds If you add an R the field will return the rounded value and if you add the word Text the field will return the formatted time Rank2PrevlRepeatedlText Efficient Option In order to calculate the bunch times efficiently it should be set up as result in Main Window gt Results like this ID Name Time Format 9 Rounding 9 Formula Location 9 10 Bunch J no rounding if T1 TPrew 2 1 2 TPrev 2 10 T1 1 KK no rounding 1 TPrev X Y also returns the time of the previous rider from result Y The previous rider is defined by rank X So the time gap to the previous rider Is Tl TPrev 2 1 If this is less than 2 seconds the formula takes recursively the bunch time of the previous rider until the gap is gt 2 seconds If the gap is gt 2 seconds the time from result 1 will be used 7 5 Team Scores Accessing Other Participants When creating a race certificate for a team you can acce
2. rtormartis o IContestLengrth zTl1 s k d km h Relay numbers The bib number in race result has to be numerical If you have relay numbers like 11 A 11 B 11 C 12 A 12 B 12 C you can proceed as follows Use bib 111 for 11 A 112 for 11 B 113 for 11 C 121 for 12 A 122 for 12 B and so on Create a user defined field Re ayBib see chapter 4 4 using this expression Bib 10 amp eohoose Bib 9 10 A B Cc Use RelayBib instead of Bib on all lists certificates Team Score with Automatic Male Female Coed Detection Teams can be male female or coed These three categories will be scored separately i e there is a first place for the male teams a first place for the female teams and a first place for the coed teams The field TSx Sex automatically determines if the team is male TSx Sex 1 female TSx Sex 2 or coed TSx Sex 3 This field can then be used to group the team score 582 Team sonrie mil K Delete Basle Settings Deine a name for the Deam score and in nonnal case gel Chub gs filter such that anh participants with a club name will have team results Name TeamSeore Filtar Clubje Max Ha Of Teams M Limit Time Farmat himmcss k Real Time Computation Tris puartsssabahie Team Aggregation Choose criteria that the participants have to have in common in order to form a team Usually Contest and Club and possibly Sex in case of separated male a
3. Germany race result 11 Advanced Users Guide The SportsEventServer detects even long complex circular references and then refuses the calculation since something must be wrong in your definition However it shows the detection of the circular reference only in the log file 25 10 2014 19 39 00 57 New connection established ID 4 127 0 26 10 2014 19 33 00 583 Engine 4 started 127 0 0 1 12 race result Webs 507 507 18 40 03 1 26 10 2014 19 39 00 59 JobScheduler created a new JobQueue fc z d Pr 26 10 2014 19 39 00 59 Opening file C Users Soenke Desktop 127 0 0 1 is race esu Web S 12 12 15 38 00 4 25 10 2014 18 33 00 583 Statistic RefreshFile File ID 4 added to Fil 25 10 2014 19 39 00 59 Opening database 25 10 2014 18 33 00 583 Start loading settings 25 10 2014 19 38 00 560 Settings loaded 25 10 2014 19 39 00 60 FOXFT Start loading results 25 10 2014 19 39 00 60 FOXFT Results loaded 25 10 2014 19 39 00 60 FOXFT Start loading age groups 25 10 2014 13 38 00 860 FOXFT Age groups loaded 25 10 2014 19 39 00 60 FOXFT Start loading contests 25 10 2014 13 38 00 860 FOXFT Contests loaded 25 10 2014 19 39 00 60 FOXFT Start loading table values 25 10 2014 19 39 00 60 FOXFT Table values loaded 25 10 2014 19 39 00 60 FOXFT Start loading participants 25 10 2014 13 38 00 560 FOXFT Participants loaded 26 10 2014 13 38 00 60 FOXFT Start creating RanklIndex Statistik 26 10 2
4. racel result 11 Precision Passion German Engineering WWW raceresult com BEEN race result AG Haid und Neu Stra e 7 76131 Karlsruhe Germany race result 11 Advanced Users Guide This manual is intended for users that would like to understand the structure and advanced solutions of the race result 11 software in order to be able to create better solutions for special kinds of events This manual is not needed when using race result 11 for standard events race result 11 Advanced Users Guide TABLE OF CONTENTS ee NIE UC UON RR E E 5 DOYS CONNIE SOF UE DUE Baosesedenn estetica MEN E CINE INMUE 6 2 1 Working Online and Offline eese enne s 6 2 2 Browser and Windows Based ccccscsssssssesscsecsessessescesecsesseseeseesecseseeseeseceesaesausaesessesaesausauseeseeseeausausaesasseeaees 6 2 3 SPONS EVENT ENV e cece cares cen E ve cscs MIENNE MM MSN NIMM MINNS 7 2 4 Dine ORO oen cecinit I Hr cUE IEEE PRU Ma NEU Etro oimecasartsateceeaupcatatanieie RUN OR MIHI IDUM NUN UON EM NUNIE 8 2 5 TIVA Ez LT SS ALEC OW PRI RC 8 4 Data SIPUCtUre and Data PIOCBSSITIG sccsiccssscesccenndesstecnedssasveeusessionsdesntapancuacaeenenotutaniaenssugedunssnesabindyennitaunednaesniaeeatieates 9 3 1 Stored Data FS ARNDN ERR T 9 3 2 PAR 110 8 gl 2 0 eh re ee rer 10 3 3 BITE NE RETO mm 11 3 4 SOG KETTE E mm 11 3 5 Rounde
5. 3 team for the 10K race If you added Sex to the Team Aggregation fields you probably want to add it to the Grouping as well Otherwise the male and female teams will be ranked together for example on the three first ranks there may be male teams and a female team may have the 4 rank 6 Using the settings in the Results section you can define which times will be used to build the team times Simply select one or several results and determine if the team time will be the sum average minimum maximum or number of times Note these results also determine how the teams will be ranked If you select the finish time as Result 1 and sum these up the teams will be ranked by the sum of this time either ascending or descending If result 1 is not decisive result 2 and then result 3 will be considered If all results are not decisive two teams can have the same rank if the option Ties possible is activated Among others the team score provides the following new fields TSx Rank rank of the team TSx MaxRank highest rank given within the group Can be used two show rank 5 of 23 TSx Time1 formatted time of the team according to the Result 1 setting TSx DecimalTime1 decimal time of the team according to the Result 1 setting TSx Position All team members will be numbered from 1 to team size This field returns that number The order by which the team members are being numbered depends on the Order Participants setting TSx Number nu
6. 5 50 10 5 54 8 5 48 3 Total 0 46 2 6 34 6 1225 8 18 19 9 2407 8 2 2 1985 WILDHABER Marcel Galgenen Rd Zeit od T 5 50 8 2 534 2 5 48 2 Total 0 46 3 6 34 5 12 24 8 18 18 5 2407 5 3 16 1983 ZAHNER Simon D rnten Rd Zeit 547 5 5 50 6 5 54 9 5 48 Tota 046 1 633 1 1224 5 1819 7 2407 T Maybe you would like to have different column widths for the fields in the different lines like in the screenshot above the lap times in the second and third line have different column positions than the basic information above To do so you have two options You can enter the exact column position in the extended field settings click on the double arrow gt gt You can set a column offset All lines will have the same columns but for example in the second line the field will be moved one or several columns to the right i e the previous column has a greater column span By the way note that the system automatically determines the column widths in your list depending on the content unless you set specific column positions Therefore the system first determines the needed width for each column If the page is not wide enough for all the data for example because there are some very long club names it has to shorten some columns For this the system calculates the standard deviation of all columns and reduces the width of those columns width the highest standard deviation This means th
7. RHEINPOWER 24h von Duisbu owered by MountainBIKE 2014 LIVE TIMING Results Class Bib Name La Last Aw Min Max Bib Hame Last Aw Min Max Aer Team m 7 Berufsfeuerwehr Ascheni 54 24 10 16 PT 4044 1 HILBLUSEGER Ingo 17 Tar 3836 Wat o 1848 s NT Gossted s I a HET 3s 4044 2 RITZERFELD Rene 17 3736 1827 34710 2004 ath ROTEN MER 2 EB GR IE nik A044 3 KOCH Sivan 48 arar 3130 d648 41321 4007 3 BREULMANN Christopher 18 draa 3757 1703 1824 4044 4 RODER Stefan TE 64 1937 1813 2038 4007 4 KROGER Ralph iB 11 30 31 12 1843 42854 E 656 Fanta 4 Bi Laps 24 01 50 Became Mosel 4237 1 THORWARTH Maikas 4 20 00 2021 1842 2128 4179 1 GEIGER Uwe WW 3802 1739 1845 ME DIPL HIS X X mln 4179 2 MEUWEILER Jens 1 4732 1738 1843 1840 n a Jie dee boca ima EEC MEUM E A QUEE TLQ QUEM 4237 4 WASSERZIEHER Matthias 18 ara 3755 d711 1523 41704 GARTMANH Stefan 1 1830 1800 t652 1952 n ee ee ee eS oo E IRIS 3 3 at Ta may 1 4 E Gotten 16 A T MERC 1853 42152 SOHHEIDER Feliz e d MA eS T UMS OAAR olli A udo Wd quss ie 4215 3 BING Gordon 16 18 40 20 0 4840 2135 4145 3 CHARLY Mair 47 40 58 22343 37707 435815 4219 4 REINAHT Marc Cue WM NUS tee 41454 SASSE Simon 1 1730 1754 146339 1845 bx ras M UELLE FEES t Mp em X mW E AD 4250 2 GOLDGRUBER Flonan 20 18 00 1840 1755 2030 4176 2 DR GE Daniel 10 1526 1804 1722 1930 4250 3 HUPEM Holger o Ww es sp xm iren OUO Lek 4 deu eee ae 2b 4250 4 SIMAK Jan 20 1548 190 1753 2023 ee col WU ae CMM SEE
8. returns the first b characters or a right a b returns the last b characters or a iif a b c if a is true b will be returned c otherwise switch a b c d if a is true b will be returned otherwise if c is true d will be returned and so on choose n a b c d will return the nth parameter a if n 1 b if n 2 and so on format n s formats the time of n seconds according to the time format s e g format T5 mm ss k 4 4 User Defined Fields User defined fields can make your life a lot easier They are very similar to the derived fields like FirstLastName see above but they are not defined by the system but instead by you They can be defined in Main Window gt User Defined Fields Fct When you need one expression in many different parts of your file you should define it as user defined field For example when creating a new event file a user defined field DisplayName will be created using this expression trim Title amp amp Firstname amp amp Lastname www raceresult com 19 race result 11 Advanced Users Guide It is the default way to show a name on a result list on all result lists the name column refers to the user defined field DisplayName The big advantage is that you can change this user defined field and in consequence all the result lists will show the name in the new format You do not need to update every single result list 4 5 User Defined Functions User Defined Funct
9. same rank and then there will be a gap e g 1 2 3 3 5 The name of the rank is on the one hand helpful to remember what a rank is intended for on the other hand the name can also be used to access the field same as additional text fields and results If you name a rank OverallRank you can also access the field Overallhankp which adds a period to the number note that the fields with period return a text whereas the fields without period return a number In consequence the fields with period cannot be used to sort a list 3 9 Team Scores Whenever several participants build a team which will be compared with other teams you need a team score A team score will determine which participants belong to the same team calculate team results e g sum of the participants finish times and rank the teams among other teams Again the team score will only provide additional data fields such as team rank team time number of team members etc which can be used to create appropriate lists race certificates etc The team scores can be defined in Main Window gt Team Scores Note that you can create several team scores if needed When setting up the team score proceed in the following steps 1 Think about who builds a team Which fields do team members have in common In many cases this will be Contest and Club the team members have to have run the same contest and need to be in the same club You can also add the field Sex
10. til n Sita Sia Sila Sila si E Sila Sic Sila img gt 1 d ao I 1 Sila Sila E Sila STI Ti Sita Sit Sita Sila Sila Sila STlap FST Laprim rsTLaprifstLa Se STLap S1 LapTimqTS1 LapTi TS1 Lap S1 LapTimqTS1 LapTi T S 1 Lap S1 LapTimqI 1 LapTiTS1 Lap ES oO Other options are stickers or labels or printing on race bibs or envelopes etc www raceresult com r 27 race result 11 Advanced Users Guide 5 3 Presentations The Presenter program Windows based gives you extensive possibilities to present results on a screen This can be either a standard result list displayed page by page on a video wall or a special list having only one page and showing for example a leader board Page by Page Presentation These presentations are straightforward as they are so similar to a normal result list For example consider the following results from a 7h ski lap race 3 riders per team one of them on the track at a time make as many laps mountain up in the lift and down on the ski as possible in 7 hours TeamRace Meiringen Hasliberg 2014 Teams Fahrer TOP3 Startnr Name Runden Etappen Schnell Mittel Langsam Lemans Summe 1 d smilies 9 7 05 05 5 35 Runden 27 Capaul Kathrin 12 6 11 16 6 12 07 2 12 43 8 2 25 26 8 26 Capaul Franziska 15 r 11 19 2 12 02 9 12 46 3 3 00 44 4 25 Stoffel Katja 8 4 11 25 1 12 05 2 12 50 2 02 12 1 1 36 42 0 2 SchwurzchungHB77 1 7 07 30
11. 2 35 Runden 2 V gtli Sarah 11 5 11 26 8 12 00 2 12 29 5 2 12 03 1 T V gtli Anna Lena 12 6 11 40 0 12 16 9 13 11 7 221233 3 Nageli Diana 12 6 11 30 7 12 09 4 12 50 4 02 09 9 2 25 53 7 3 Gipfistirmerinna 2 7 13 15 3 35 Runden 5 Furrer Karoline 13 6 11257 12 096 13 27 5 2 38 04 8 6 Furrer Sandra 11 6 11 27 0 12 27 0 13 14 6 2 16 58 0 4 Furrer Martina 11 6 11 26 0 12 21 7 12 58 8 02 13 2 2 15 59 0 Herren 1 Ds Dritt simer Bissig ohni iis Teamcaptain dits J 56 7 06 58 5 39 Runden 168 Ammann Roland 13 6 10 36 6 10 58 7 11 42 8 2 22 44 1 166 Kohler Sandro 11 6 104852 11013 118 7 2 01 15 1 167 Ammann Andreas 15 6 10 22 7 10 46 4 11 05 7 01 22 0 2 41 37 1 2 Skiclub Schwarzsee 70 7 09 24 0 39 Runden 209 L tscher Sven 12 6 10 44 9 11 12 8 12 26 3 2 14 33 8 210 Thalmann Dominik 13 6 1027457 10 53 5 11 19 65 221750 1 208 Thalmann Benjamin 14 6 10 31 3 10 50 0 11 17 8 01 33 0 2 31 40 9 The presentation is running on a large TV in the team area where the teams can check their positions any time It is going through the list page by page and starting over from the top after the last page Leader Board Live Presentations Leader board presentations can be nice for both the announcer commenting on the race as well as for a video wall As example consider this leader board Rangliste Team Men Rangliste Team Women Rg SN Team Inline Swim MTB Laufen Gesamt Rg SN Team Inline Swim MTB Laufen Gesamt Wechsel Wechsel Wechse
12. 26 02 3 11 1 32 06 0 5 1 03 14 6 8 3 28 42 0 A 803 S llemal cho 30 30 2 8 27 02 8 3 1 58 04 6 5 1 11 24 5 7 4 09 12 1 00 39 4 00 45 5 00 30 0 47 23 1 00 42 5 00 47 3 00 40 0 24 54 0 K hni Marc Spieler Roman Gerber Philipp SANTSCHI Oliver Marti Nicole Niggli Selina M sch Florence Liniger Regula Rangliste Team Mixed Rangliste Couple Rg SN Team Inline Swim MTB Laufen Gesamt Rg SN Team Inline Swim MTB Laufen Gesamt Wechsel Wechsel Wechsel Diff Wechsel Wechsel Wechsel Dif 1 517 ZabooTeamPro 1 18 388 6 23 15 7 12 1 12 40 6 1 45 07 6 2 2 41 15 0 1 321 Team Mahu 17 59 0 2 21 14 4 3 1 21 56 2 2 56 39 5 17 2 59 10 0 00 35 2 00 35 5 00 21 3 00 27 2 00 30 7 00 22 8 Sumi Patrick Meyer Val rie D hler Friedrich Oldani Lukas Berger Marc Matter Br gger Sibylle Berger Marc Matter Br gger Sibylle 2 560 R ADYS ZABOO 19 07 2 7 23 14 1 11 1 18 30 2 3 46 10 1 3 2 48 36 7 2 384 R ADYS ZABOO BIKES 18 39 5 3 30 33 1 86 1 14 00 3 1 54 09 9 8 3 00 31 9 00 35 5 00 27 5 00 31 8 7 21 7 01 48 9 00 30 6 00 49 4 1 21 8 Rechsteiner Reto Brechb hlAndrea Zahnd Simon BIERI Matthias B rgi Yvonne B rgi Yvonne Spaeth Sandro SPAETH Sandro 5 616 Go for It 19 59 9 12 21 05 8 5 1 25 12 8 14 45 00 1 1 2 52 45 7 3 306 Les paresseux 19 16 4 6 23 41 0 11 1 25 28 7 6 53 13 6 6 3 03 14 8 00 28 7 00 31 7 00 26 5 11 30 7 00 30 8 00 37 7 00 26 3 4 04 7 Ackeret Jeanine M ller Seb
13. CROSS HOOGERHEIDE WORLD CHAMPIONSHIPS THE NETHERLANDS Final Results M lite Rank Bib No Name YoB Nation Laps Time Top Gap Prev 1 11 ALBERT Niels 1986 BELGIUM 10 102242 2 15 STYBAR Zdenek 1985 CZECH REPUBLIC 10 102481 0 21 9 0 21 9 3 8 NYS Sven 1978 BELGIUM 10 103028 0384 0165 4 9 WELLENS Bart 1978 BELGIUM 10 103348 1108 0322 5 29 MOUREY Francis 1980 FRANCE 10 103477 1235 0129 6 10 PAUWELS Kevin 1984 BELGIUM 10 103479 41237 0002 7 14 VANTHOURENHOUT Sven 1981 BELGIUM 10 103481 1239 0002 8 27 ZAHNER Simon 1983 SWITZERLANO 10 10348 1239 0000 9 30 CHAINEL Steve 1983 FRANCE 10 10348 1239 0000 10 12 VANTORNOUT Klaas 1982 BELGIUM 10 103482 1240 50001 11 22 FONTANA Marco Aurelio 1984 ITALY 10 103484 1242 0002 12 2 ALThijs 1980 NETHERLANDS 10 103485 1243 0001 13 21 FRANZOIEnrico 1982 ITALY 10 103490 1248 0005 14 32 LOPEZ Jonathan 1986 FRANCE 10 103507 1265 0017 15 26 HEULE Christian 1975 SWITZERLAND 10 103533 1291 0026 16 3 DEKNEGTGerben 1975 NETHERLANDS 10 104148 41506 0215 17 17 DLASK Petr 1976 CZECH REPUBLIC 10 104152 1510 0004 18 19 AUSBUHER Kamil 1975 CZECH REPUBLIC 10 104153 1511 30001 19 13 VERVECKEN Erwin 1972 BELGIUM 10 104153 1511 0000 20 1 BOOMLars 1985 NETHERLANDS 10 104154 1512 000 1 21 8 VAN IJZENDOORN Eddy 1985 NETHERLANDS 10 104159 1517 0005 T hsdrecht Sete RICOH Saerklin gt Sumano fm an C s CBE uuu
14. Kay Burrichter 1 25 10 0 M40 1970 3365 Karsten Wilkens 1 39 06 0 M50 1962 Jj kein 1 41 02 6 3194 Karl Josef Lamberty 1 32 22 5 M55 1354 3352 Walter Lemor 1 33 51 7 M40 1871 3015 Dr Hans Hermann Sass 1 34 48 4 M65 1947 4 LT St rlauf 1 41 50 9 3057 Roger Steffens 1 28 15 8 M40 1969 3119 Mathias Funk 1 32 523 M35 1973 FAIA lasehirmn hirmanan e 4 An A RAEN 4049 Note that the Page Break option offers a lot of option to insert page breaks for PDF output before a group header or to repeat the group header on a new page Also in the advanced settings accessible via the double arrow gt gt you can define colors for the group header Half Marathon T MCEirA al l 4 22 24 2 3089 Michael Plambeck 1 26 31 2 M35 3202 Soenke Sievers 1 27 53 7 M50 3005 Bernd Banasch 1 27 59 3 M45 Sparkasse in Steinburg 1 4 25 00 0 3367 Niels Burrichter 1 20 44 0 M40 3449 Kay Burrichter 1 25 10 0 M40 3365 Karsten Wilkens 1 39 06 0 M50 The advanced settings also offer dynamic formatting explained below Multi Line Lists Multi line lists are an easy way to put more information on a list One record participant can have up to 30 lines on the list Therefore simply select a line greater 1 for a field column of your list 22 race result AG Haid und Neu Stra e 7 76131 Karlsruhe Germany race result 11 Advanced Users Guide Rang Stnr Jhg Name Ort Elite Amateure 1 3 1984 FL CKIGER Lukas Leimiswil Rd Zeit 54 8
15. MT 178 WAP fa AT 44104 PUES E acta i 1 LITRO enm 4 3ha Wab 3 39S ais niens is I 2 ur i 4120 2 HUTING Manan 17 18528 182 1725 1934 4201 3 SCHIRBEL Jong T3 3934 3939 A AN AUS FOIE Mad M uA UE NES ue 4201 4 MITCHEL Ryan 37 ara 187 340737 o 2039 4120 4 DIAHMEN Markus i8 1036 34 05 1741 41528 IT ane A Su Fae su zi RLERHANH Tim a i tem IT e oss u Wa s 31358 4174 2 BECKER Jan Mam 17 18628 332 3 34720 4403 pee Ecc writer coca AE GU A INCUN 4174 3 EGGEN Max 18 d amp 51 1902 1720 1954 4255 3 WALDE Daniel 46 1T15 17 57 1708 1905 41144 REINECKE Dominik uO 3e gas A 2022 4955 4 KALB Dieter 48 17 52 17 57 1715 1853 01 11 2014 www sportservicehamburg de 16 45 30 Vorank nder Uhrzeit Ww Finisher w SHR Name Top Gap Zelt AK Alter Verein MW P SE AHK Pl 21 20 58 A 211 392 627 im Ziel AB3 Michael KONZE GER 1280 5B 0 01 16 21 38 Ma0 43 Rad Treff Borchen eV 398 147 Mao 21 20 58 A 211 A 393 827 im Ziel 4724 David HASLAUER 1280 57 1 58 16 21 40 MHK 19 VKB Bank 397 4B MHK 21 19 00 A 211 A 391 B27 im Ziel AT48 Paolo CAPRINI ITA 1278 58 0 04 16 10 27 M50 53 Trreno bie 396 32 M50 21 18 56 A 211 A 380 G27 im Ziel ASO Roland DOBRIMDT GER 4127B8 55 401 16 19 25 Med 48 VWurzelhopaar 385 146 MAD 21 18 55 A 211 A 368 G27 im Ziel 4651 Gaute RISNES NOR 4127B8 54 40 38 16 10 24 MO 44 Team Telemak 384 145 Mao 21 18 17 A 211 388 627 im Ziel ADA3 Mac VAN DER VOSSEN NED 1278 16 47 44 16 18 42 M30 33 Mo
16. Matthiesen Olbrisch Schenkies 4 55 04 9 5 LT Stoerlaut Papert Bohnsack Djurovac 4 5517 3 How did we do this Fields Columns 2a HK av Column Heading Data Alignment Line B uo TS1 Rank EES 1 vl eeo cub 1 1 1 E h Mellu TS1P1Lastname SSE 1 M e uo TS1P2Lastname SSE 1 M euo Rider3 en TS1P3 Lastname EEE 1 Me r u TS1 Time SEE MeLe BE OY gj r u 6 Filter H cw e NE o Records Conjunction Field Operator Value TS1Rank M9 and v TS1 Position race result AG Haid und Neu Stra e 7 76131 Karlsruhe Germany race result 11 Advanced Users Guide We use TS1 Px to access the three names of the athletes and show them in one line Without any other modification the report would look like this Rank Club Rider1 Rider Rider3 Time Half Marathon 1 LG Itzehoe Plambeck Sievers Banasch 4 22 24 1 LG Itzehoe Plambeck Sievers Banasch 422 24 2 1 LG Itzehoe Plambeck Sievers Banasch A224 2 2 Sparkasse in Steinburg Burrichter Burrichter Wilkens 4 25 00 0 2 Sparkasse in Steinburg Burrichter Burrichter Wilkens 4 25 00 0 2 Sparkasse in Steinburg Burrichter Burrichter Wilkens 4 25 00 0 j kein Lamberty Lemor Sass 4 41 02 6 j kein Lamberty Lemor Sass 4 41 02 5 3 kein Lamberty Lemor Sass 4 41 02 6 4 LT St rlaut Steffens Funk J rgens 4 41 50 9 4 LT St rlaut Steffens Funk J rgens 4 41 50 9 4 LT St rlaut Steffens Funk J rgens 4 41 50 3 It would still show one line per participant So we have to add the filter
17. TS1 Position 1 TS1 Position is the internal numbering of the team 1 gt first team member 2 gt second team member so the filter makes sure that only one record per team will be shown 7 6 When using a team score with lap mode see chapter 3 10 for example for a 24h mountain bike race you may need information about the participant who did the 25 lap of the team For this you can use TSx Ly For example Team Lap Race Additional Fields TS1 L25 Lastname returns the last name for the athlete that did the 25 lap of the team according to team score 1 After 751 125 any field can be used 1 1 For team scores there is no function like GapTimeTop so we have to calculate gap times manually Therefore the fields Team Gap Times TSx DecimalTimeTopY and TSx DecimalTimePrevY can be used which return the y team time of the first team previous team according to team score X A possible expression for the team gap time would thus be iif TS1l Rank 1 m n format TS1 DecimalTimel TS1 DecimalTimeTopl1 mm ss 1 8 First of all note that the following aggregation functions are not very fast and should be used rarely Aggregation Functions Assume you would like to show the number of finishers on a race certificate For this you can use the DCount functions which has a filter as first and only parameter DCount Finished If you would like to show the number of finishers that have
18. URKUNDE In most cases however you need to print several certificates at once which can be done using a Certificate Set in the Output Window Certificate Sets A certificate set is simply a set of certificates for certain participants in a certain order and using a specific design certificate The certificate sets can be accessed in the bottom left corner of the Output Window 26 y race result AG Haid und Neu Stra e 7 76131 Karlsruhe Germany race result 11 Advanced Users Guide race result 11 eae 2012 01 01 race result 11 Demo RHFVF 6 630 ia S Layout JPreaew List TiCet cates Contest Layout of the Certificate lt All Contests Create Edit Certiscate Half Marathon e EE 4 amp 10K Race Team Cerificate Team Certificate 1 per Team 1 per Participant Team Score TeamScore Certificate Certcate Type Onine Payment Participants List 123 Participants ListABC Random List Result Lists Age Group Winner For which participant do you want to create certificates CityChampionship Ranks l Finisher List Overall vice v 3 Newspaper Text Result Lest AG Dynamic Formatting Result List MF Only unshown certificates Reset Result List MF AG Fireshers Only Firushers _ Only Participants with AYN field Team Results Team Results m f Winners List General Filter Announcer Finisher List testkat gt Neve Lis ertificate Sets Order of The C
19. but theoretically it could also be a function like add T1 T2 Note that the add function does not exist in race result In case of operators the parameters called operands will be left and right of the operator In case of functions the parameters will be in round brackets after the function name separated by a semicolon You will find a complete list of all operators and functions in the race result Online Help Here the most important ones shall be discussed 4 2 Operators E equal returns true or false gt greater than returns true or false lt less than returns true or false lt less or equal returns true or false gt greater or equal returns true or false lt gt not equal returns true or false AND logical And returns true or false OR logical OR returns true or false XOR logical XOR returns true or false addition subtraction i multiplication division modulo time operator The operator will multiply the left operand with 60 and add the result to the right operand i e a b is equivalent to 60 a b This special operator makes it possible to write times intuitively e g 18 race result AG Haid und Neu Stra e 7 76131 Karlsruhe Germany race result 11 Advanced Users Guide IXT IL1 29 0D more than 1 hour 29 minutes less than amp concat strings The last operator amp is very important for lists and certificates Imagine you would like to show last name
20. data query etc The server prioritizes the job request and processes them At all times the server ensures data consistency it always knows which information needs to be calculated or updated 2 4 Online Forwarding Using the Online Forwarding is an easy way to provide live results on my raceresult com when working offline If you have an even unreliable Internet connection the SES will forward all write jobs to the SES in the Internet so that both servers the local server and the server in the Internet will do the same and thus have the same data status If your Internet connection breaks down the online forwarding stops but you still have access to all your data and can simply restart the online forwarding when your connection recovered 2 5 my raceresult com my raceresult com is an Internet platform to provide online registration and results to your participants It is connected directly to your event file i e whenever you change something in the file the changes will be reflected on my raceresult com almost immediately You only have to decide which information you would like to publish on the platform and you will not have to update the information ever yyy race result AG Haid und Neu Stra e 7 76131 Karlsruhe Germany race result 11 Advanced Users Guide 3 DATA STRUCTURE AND DATA PROCESSING Now we are starting with the advanced parts Remember that race result 11 separates the calculation of data and
21. for example the rank with ID 4 three additional fields can be used Rank4 the position of the participant according to the rank definition e g 47 Rank4p the position with a period at the end e g 47 MaxRank4 the number of participants in the same group e g 495 MaxRank helps to create an output like 47 of 495 in age group M50 Note that defining a rank only provides these additional fields Creating a report with this rank is a separate step and will be explained in chapter 5 Ranks can be defined entirely flexibly Theoretically you can define a rank that Only considers athletes named John groups them into those who are born in an even year and those who are born in an odd year and sorts and positions them by the rounded time in lap 2 fthetime in lap 2 is not decisive the participants shall be positioned by the length of their last name Yes this is a very hypothetical case but it shows that there are virtually no limits in what you can do The ranks will be defined in Main Window gt Ranks and their settings are based on three main pillars filter grouping sorting www raceresult com 13 race result 11 Advanced Users Guide Filter In most cases you would like to exclude certain participants from the rank for example those that have not finished These will not receive a rank more precisely the rank field will contain the value 1 For the standard ranks the filter is therefore simply Finishe
22. of all participants named John Simply add a filter to the list and use the field Position instead of the rank i Data Format View Excel Page PDF HTML Rank Bib Name YoB Sex AgeCat Club Time Half Marathon 1 3482 John Treyke 1974 m kein 1 43 38 0 2 3485 John Ramlow 1950 m AGS Itzehoe 1 59 37 4 3 3468 John Berndt 1955 m Dentaltechnik Itzehoe 2 14 41 6 5KRace 4 1323 John Witt 1995 m Juniors B Klasse 4c GS Edendorf Ursula Paarmann 26 32 8 Looks good but it should start at 1 again for the 5K race For that you can use the field Position which will start over at 1 when the highest grouping level changes the value Position2 would start over at 1 when the first or second highest grouping level changes the value 7 2 Gap Times To show the gap between a participant and the winner or the previous athlete you can use the two functions GapTimeTop and GapTimePrev Aggregation Functions Gaplimelop result ID rank ID text first time format GapTimePrev result ID rank ID text first time format The rank defines who the winner previous rider is winner overall winner gender winner age group Text first defines what to show for the first participant does not have a faster athlete The time format parameter defines how to format the gap time The expression GapTimeTop 1 2 mm ss may have this result Rank Bib Name YoB Sex AgeCat Club Time Half Marathon Men 1 3043 Olaf Stahl 1971m M40 MTV It
23. the presentation of data This and the next chapter only explain how to set up your event so that the system makes exactly the calculations you need The presentation layer will be explained later in chapter 5 So in order to understand race result 11 you have to understand first how it handles data Two aspects of handling data have to be separated making necessary data available calculation and retrieving data filtering selecting fields sorting Assume that you would like to create a list of the three riders that have been fastest in the second lap First you will set up your event so that it calculates the rank in the second lap From then on this information rank in second lap is available for all participants You can use this information like any other field e g year of birth but the system will make sure that it is always up to date even if the underlying results may change This field can then be used to retrieve the required data for example Fields rank in 2nd lap bib name time in 2nd lap Filter rank in 2nd lap 3 Records ordered by rank in 2nd lap This also means that the data retrieval is based on the participants but the participants data can have different sources Stored data fields e g bib number last name date of birth Assigned fields e g name or length of the assigned contest name of the event date of the event age group name Derived fields e g age derived from date of birth and eve
24. you would show the team s rank and time If you would like to show also information of the other team members you can simply enter the field expression in the top left corner and then select the team score and the participant L astFirstname Anal For example to show the last name of the second participant of the team according to team score 1 the system will use the field TS1 P2 Lastname In the preview you can see that selecting a team score participant only helps you to set up your certificate but internally the field name will be used EventName m Club amp amp TS1 Teamindex N TS1 P1 LastFirstname 81 P1 Time MUN TS1 P2 LastFirstname S1 P2 Time TS1 P3 LastFirstname 1 P3 Time Printing Certificates The certificates can be accessed and printed in the Participants Window through the Certificates tab race result 11 START Overview Main Window Participants Output myraceresultcom Tools mem 2012 01 01 race result 11 Demo RHFVF E 9 e Navigate General F1 E Results F2 amp History F3 amp Archives F4 New Participant F12 WK Delete Participant 1 H a ns O h Ise n I4 Go to First 4 Go to Previous gt Goto Next M Go to Last E List View F7 Sort Record 1 of 2850 Refresh and Sort 2l Bib at Search E Bib a Name 2 All 10 Background Certificate Certificate Background Team Certificate in Bib v d
25. 014 19 39 00 61 FOXFT RankIndex created mE 25 10 2014 19 39 00 61 FOXFT Start creating team scores 26 10 2014 19 39 00 61 Analyzing file dependencies 934 934 0 0 200 200 717 717 26 10 2014 13 39 00 62 WARNING Circular Reference T1 TS1 32 32 i 0 0 BEA 26 26 EE 26 10 2014 19 39 00 62 FOXFT Start creating Timelndex a Wartezeit 0 00 T 0 00s 25 10 2014 13 38 00 862 FOXFT Timelndex created 1 t 26 10 2014 19 39 00 62 File opened in 0 0281 sec ID 4 aktuell 0 00s J 0 00s 26 10 2014 19 39 00 64 FOXFT Trigger defined ID 1 Type 2 Re S e Ausf hrzeit 0 00s 0 00s lt gt aktuell 0 01s i 0 01s 26 10 2014 19 39 04 Version 11 1 87 If something is not working as expected checking for a circular reference may be helpful ine EL race result 11 Advanced Users Guide 4 EXPRESSIONS AND FUNCTIONS 4 1 Expressions and Functions In the last chapter we have already used expressions called them formulas without actually understanding what they are and how they work Expressions use some operators and functions on some data to generate some new data For example the expression max Il IZ d uses the data fields T1 and T2 to generate a new information the maximum of those two added to 1 Operators and functions are actually the same but operators always have two parameters and their syntax is different The expression TITIZ 41 n uses the operator
26. 3 Dirk Schlichting wn 1970 Mailhas Voigt 0 80 8 8 9 BSGNDR 3494 Rainer S nnichsen 1969 302 Michael Neumann 1963 351 Thorsten Beckmann 1970 CCC 3047 Nadja Kropius SEE Se BKK Gruner Jahr 280 Reinhard Sahn 1958 Bticher Kanguruh 131 Holger Hansen 1976 1046 Saskia Kropius 1996 1867 Andreas Meurer 1966 s 1590 Tule Becker 1998 3417 Dietrich von Tengg Kobligk 1969 eee omen 1585 Villy Pedersen 1854 624 Eric Jordan 1964 eino Andresen SS SS c 1 Felix F 1996 BSC Nordoe MTV Itzehoe Ae TOU MEE CL Body vym Nzenoe 1036 LukasRamm ag ooo 305 Nicole Kalbreyer nO US Teu 0 G 2 3 31909 BSC Sportfreunde Itzehoe 3415 Frank Kuppe amp amp 19590 Boxclub Itzehoe 2248 Marco Lucky Ulrich 1970 923 Holger Zimdahl 1968 600 Stefan Mattlat 1988 3416 Hubertus Heise 1962 lub IZ BSG FA Elmshorn 622 Ludger Rohe 1968 Boxclub IZ 3333 Andreas Michaelsen 1961 1870 Sophia Jensen 1995 2210 _ Marcel Barthel 1993 3332 Dirk Labusch 1976 1869 Yvonne Jensen 1965 3334 Markus Rauser 1970 3065 AndreasKropus 1 1 1 1 1969 3262 Peter Witt 1953 32 PAukesNemen 8935 BSG Feuerwehr Hamburg 279 Benedikta Sahn 1959 Ags Mihanl Menine 1968 Bumfei Runners 3207 Christian Hasch 1983 561 Stina Garbe 1991 2 simply define the number of columns and the column spacing in the Page settings of your list 5 2 Certificates Certificates are pretty straight
27. anrdbikers 383 173 M30 21 16 33 A 211 A 387 527 im Ziel A388 Jan OlafKOSCHINSKI GER 12786 32 006 16 18 47 M40 47 DPD Ho lint 382 144 M 211627 A 211 386 527 im Ziel A435 Vimdimir PAL CH SVK 41276 260 40 00 16 16 47 M50 55 The Slovak Snail Highlanders 391 31 M50 2116827 A 211 384 627 im Ziel 4575 Filippo ALTORELLI ITA 1278 26 40 58 16 16 42 M40 41 GS Amoruso 390 143 MAD 21 16 27 AMIA 385 627 im Ziel W A290 Michaela TUMOVA CZE 193 02 87 59 16 16 43 WHK 23 Pritce a 4 WHE 21 15 28 A 211 A 383 627 im Ziel A443 Sivo GRAUPNER GER 127527 28 48 16 15 40 1430 3B Prost Rico 388 172 M30 20 46 40 AJITA 344 627 im Ziel ASIS Zotan FULOP HUM l245 38 0 00 15 46 57 M30 31 Bringabanda SC 388 171 M30 20 46 50 A 211 343 B27 im Ziel A323 Jiri CECHURA CZE 1248 39 41 220 15 45 57 M50 48 Alttmning cz 38T 30 M50 20 4511 A 211 340 627 im Ziel A177 Lukas POHL 4124510 40 00 15 45 24 M30 31 TSO 386 170 M30 20 4511 A 211 A 342 827 im Ziel A634 Mare HULSHOF NED 41245310 4000 15 45 32 M40 48 WV de Meteoor 385 142 MAD 20 4511 A 211 341 627 imZiel A176 Georg LOSCHL 4124510 40 33 15 45 28 M30 35 TSD 384 169 M30 20 44 38 A 211 A 339 627 imZie A288 Michal KADLEC CZE 41244 37 40 13 15 44 58 MAD 41 Podali 383 141 Mado 20 44 25 A 211 A 337 627 imZie ATO Dieter SCHULZKI GER 4124424 40 03 15 44 36 M40 48 CSV MTE Taam 382 140 M40 20 34 22 A 211 A 338 827 im Ziel 4622 Chris DREVEL NED 1244 21 40 03 13 44 45 M40 44 Le C
28. astian Rentsch Manuel Ackeret Christian Koller Martin Schramek Diana Koller Martin Schramek Diana 4 518 ZabooTeamPro2 21 08 6 24 25 23 1 30 1 19 00 6 4 48 06 7 4 2 55 21 8 4 410 Reto amp Susu 19 59 3 14 23 26 9 10 1 27 43 2 9 54 329 10 3 07 07 7 00 40 8 00 34 4 00 27 3 14 06 8 00 27 2 00 36 6 00 21 2 7 57 7 Meyer Rico Beaudet Am lie German Benno Botha Joca Aschenberger Reto Gries Susanne Aschenberger Reto Gries Susanne 5 703 Backyard Legends 17 082 2 20 29 4 1 1 22 20 8 5 57 38 7 30 2 59 06 8 5 398 VS Express 19 34 6 9 25 17 6 27 1 22 57 9 3 1 03 54 1 40 3 13 20 9 00 32 3 00 30 5 00 26 8 17 51 8 00 31 3 00 44 0 00 21 1 14 10 8 Friedli Yannick Rollier Marc h ng rtner yves SCHAR Yvonne Willisch Marco Ruffiner Rachel Willisch Marco RUFFINER Rachel This event is a multisport event inline swim bike run with couples and teams of 4 The presentation shows the 4 categories via the Split Screen option of the Presenter For each category it only shows the leading 28 race result AG Haid und Neu Stra e 7 76131 Karlsruhe Germany race result 11 Advanced Users Guide teams and refreshes the information every second so that the announcer can see everything in almost real time The lists are standard lists with three lines per record and a filter like Rank 0 AND Rank lt 5 Note that some pictures and some colors can make the presentation look much better 2009 UCI CYCLO
29. at columns containing for example a time all times have the same length would not be reduced in width as this would cut the time in every line Instead the system will reduce the width of for example the club name so that only a few outliers will be cut Dynamic Formatting Dynamic formatting is way to format different records differently You can change the color background color and font style bold italic underlined For example you could print all men in blue and all women in red Therefore you need to enter an expression in the extended field settings double arrow button gt gt like this iif Sex f C FFOO00 C 40000FF The dynamic formatting can be defined either for the entire line or only for certain columns For further details please read the article in the race result Online Help Entering Complex Filters The filter settings for a list offer an easy definition of your filter for example Conjunction Field Operator Value Rank3 gt 0 and w Rank3 lt 3 and w If you need to enter a complex nested filter the GUI may be tedious In that case simply enter your filter in the first line like this iif Contest 2 AND T2 gt 5 OR Contest 3 AND T2 5 1 0 1 www raceresult com 23 race result 11 Advanced Users Guide Multi Language Reports When publishing a result list on my raceresult com you may would like to have for example the column headers in different languages Therefo
30. d based on the finish result see above but the filter can be any other expression e g FirstName John theoretical example from above Finished AND AYN1 participant needs to have finished and the AYN field needs to be set 523 the value in result 5 needs to be greater than 5 Grouping the fields selected here group those participants fulfilling the filter into several groups Two participants will only be in the same group if they have identical values in all fields For example a typical gender rank would be grouped by the fields Contest and Sex so that there are groups like 5K male 5K female 10K male 10K female For each of these groups there will be a 1 2 3 place Sorting the sorting can be defined either in the rank definition turn off option Order According to Contest or in the contest settings turn on the before mentioned option The selected order fields define how the participants shall be ordered and then ranked If the first field is not decisive the second field will be considered and so on For each field you can also define if the participants shall be ordered ascending or descending For example for lap races you will need descending more laps gt better position Finally there is an option Ties Possible which defines what happens if all sorting fields are not decisive if the option is turned off the participants will be ranked randomly If the option is on two participants will have the
31. d and Formatted Times esses eene tn snnt ADaP stans tastes nasa sta tassa snas na 11 3 6 Calculated Formula Resule ssiri noenee aaa Taoa EAE naa adaini 12 3 7 WS ERI ena E 13 3 0 ica CMT eee 13 0 9 Jag OL BS catruiesas item pr dU HEIN EINEN M UM MM MS MUI NEM M UM DUM 14 S10 dJBSgHESCOFBS WILL Mea MOUE escena mimi qn iir n ANNI IEtR E EE DUCUM A EDU ee mI in UT en eren mU CIp RM DEUS 15 3 11 Background Information Real Time Scoring Engine csscescseescssssesecseseeseseesessesessesaesesaesesauseesesessaes 16 A Expressions and ELO ERNEUT m m 18 4 1 Expressions and FUNCTIONS ccccccccssesscssssessessesecseesesseseeseesecausaesessessescaesauseusesseseesausacsecseseeseusaeseseesansansanseses 18 4 2 RIOT CREER TTE mU 18 4 4 User pcne d FCIS r umen eed iio rU M Io mH IS a MINIM NNNM UIN 19 4 5 User Demer FUNCIONS a a E AA 20 3 POMON UDO cera R E E 21 5 1 S e A A E ane 21 5 2 BIETET 25 9 9 Wiz A n 28 D Race SBIUD Ora tases escpa caa mI visus E HUNE MEMINI AN IM NI MEE MEN MM MUE 30 6 1 BEA CECI ENTER E 30 6 2 WEILE CDI NN 30 6 3 UECRUGIZIMBI ERIT 30 6 4 EIER S UI ERR AA E EA N A E E A A T P E A E EE E E E 30 Advanced Data Fields and FUNCTIONS xiscicsssscscsscvevesusstiutastinascasessbursneusu
32. e entered When creating reports you can easily select the desired data field in the field wizard www raceresult com 9 race result 11 Advanced Users Guide Default Fields Bib Lastname Firstname FirstLastname LastFirstname Title YearOfBirth YearOfBirth2 DateOfBirth Age AgeUOnLDec31 a Besides the standard fields like bib name club etc the 20 additional text fields ATF the 20 additional yes no fields AYN and the 20 additional yes no text fields AYNTF serve to save any kind of additional information Note that you can access these additional fields either by its name e g ATF5 or by the label you defined e g TShirt The second option is nice because you do not have to remember the number of the field and even if you change the numbering you do not have to update your reports In return you cannot change the label without changing your report Note that there are also stored fields that cannot be written in externally e g Created and Modified when the record has been created modified 3 2 Assigned Fields Depending on the contest age group nation country assigned to a participant you also have access to the other attributes of the selected contest age group nation You can access the attributes of the assigned contest age group country also simply by selecting them in the field wizard Contest Contest ContestName ContestDate ContestStart ContestStart Text ContestLength It works the sa
33. ected in the field wizard www raceresult com 11 race result 11 Advanced Users Guide Interim Results FinishTime Time DecimalTime1 RoundedTime1 Info Text 1 TimePositive1 1 kK Split Time2 DecimalTime 2 RoundedTimez2 Info Text TimePasitive Y In this list you can see that you can also access the formatted time via the name e g 70K_Split It has the same advantages and disadvantages like in case of the additional text fields when you change the ID you do not have to change your reports but when you change the name you have to The screenshot also shows that each result has two more fields nfoTextX is a text field that usually contains additional information from the timing system e g hits signal strength etc and TimePositiveX is a derived field which is 1 if the time value is greater zero and 0 otherwise Also note that for rounding and formatting times the settings from Main Window Results will be used If a rounding a time format is not specified there the rounding time format from the assigned contest will be used This way you can define a default time format for each contest and for some results you will define a 4 different time format e g s for points 3 6 Calculated Formula Results When defining a formula for a result in Main Window Results no values can be saved in this result but instead the SportsEventServer will automatically calculate the values according to your for
34. ernet connectivity 2 2 Browser and Windows Based Most parts of race result 11 are running in the Internet browser You would simply log in on www raceresult com and access your events Some parts however are Windows based programs for example the Transponder Module which creates the connection between your event file and your timing system When working offline the small program race result Web Serverruns as your local web server File Online Settings Events a 7 7B 77 NE CR race result 11 Demo E 2012 01 01 Demozen ses c Users S oenl Open Browser Transfer Credits amp http 10 56 48 210 Balance offline 50 Balance online 7 Open Event Transfer Download or upload credits race result 11 START Overview Main Window Search Participant a 2012 01 01 race result 11 Demo RHFVF Summary aes race result 11 Demo my raceresult com Statistics Boston United States 2012 01 01 race result 11 race rest an edo Also all other computers in your local network can access the event by entering the IP address of local server in the browser e g http 192 168 1 100 6 y race result AG Haid und Neu Stra e 7 76131 Karlsruhe Germany race result 11 Advanced Users Guide The Windows based program can work with event files stored both offline and online In order to open a file stored online select File gt Connect to Sports Event Server Open Event Strg 0 Connect t
35. ertificates Proposal 1 Proposal 2 Proposal 3 Proposal 5 User Defined Bib Lastname Club Contest 311 1 All Certificates Firstname Sex 411 zi All Team Certificates AgeGroup1 il z Award Ceremony 1 3 Age Rank3 s Award Ceremony 1 3 mf Certificate Web New List Category ap Import List Cetificate Set When creating a new event file some standard certificate sets will be set up automatically for example to print the certificates for the first three women and men per contest for the award ceremony Publishing Certificates Certificates can be published easily on my raceresult com Therefore go to the my raceresult com settings gt Publish gt Certificates and simply check those certificate set you would like to publish Certificate Sets will be used to publish certificates because this way you can define both the design certificate you would like to publish and for whom you would like to publish the certificate Only those participants fulfilling the filter in the certificate set will be able to download the certificate from my raceresult com What Else Certificates Can Do Besides certificates the certificates functionality can be used for many different applications For example it can be used to show the lap times for a team lap race esult CRM d Finanzen net S ZDNet de jj raceresult com 4 Collmex Ed Facebook Gj my raceresult com f race result 11 B u R p A E T O E A i T Jun ARESE RRREEE
36. first name and nation in brackets on a list Then you can use this expression LastName amp amp FirstName amp amp NationIOC amp In this example you can also see that fields need to be in square brackets when using them in expressions whereas fixed texts will be in double quotes The only fields that do not have to be in brackets are the decimal and rounded fields T1 T2 T3 and TR1 TR2 TR3 This way it is easy and intuitive to create formula results like T22 T21 Note that an operator expression like T12 T11 will only be calculated if both operands T11 and T12 are available If T12 is NULL not entered does not exist the result of T12 T11 is NULL as well In some cases however you may want to make the calculation assume result 32 can contain a bonus malus which shall be added if entered 112 111 132 If T11 and T12 are available the formula shall be evaluated no matter if T32 is available or not For that you can use the nz function which returns 0 if its parameter is NULL not available TIZ TI idSWmECIS2Z 4 3 Functions These are the most important functions Please find a complete list of all available functions in the race result Online Help nz a returns 0 if a is NULL and a otherwise max a b returns the maximum of a and b min a b returns the minimum of a and b ucase a converts all characters of a to upper case Icase a converts all characters of a to lower case left a b
37. forward you set them up in the Designer Tools gt Designer by placing data fields fixed text fields and pictures on the page The certificate can either be complete and include the background image for example to publish it online or it only contains the data fields and will be printed on the pre printed sheets Dynamic Formatting Dynamic formatting can be used similar to lists It can be defined in the top right corner BDF iif Sex F C FF0000 C 0000FF 4 K 000000 d ft 2 3 4 5 l8 I7 8 9 19 1 fere e ne Dey ne opp Data Dependant Images Using data dependent images you can use different images for different participants on the same certificate Assume you would like to show the flag of the participant s nationality on the certificate The flags are saved as flag XXX pg where XXX is the name of the country in IOC format Then add a data dependent image and use this expression flag amp NationIOC amp jpg 2U12 U1l U1 race resun 11 Demo jrxrirvr F ES Sey EIER TRHEE 8 19 1011 12113 14 15 116 17 18 11 If the pictures do not have the same dimension you may want to turn of the stretch mode and instead scale the image maintaining the image ratio see top right corner of the screenshot Em EL race result 11 Advanced Users Guide Team Certificates Certificates for teams work exactly the same like a normal certificate Instead of the individual rank and time
38. hampion 381 138 M4Q 20 44 19 A 211 A 335 827 im Ziel A382 Javer SIMON ESP 124418 002 15 34 37 MED 41 APLDXG 380 138 M40 2034 17 A 211 A 336 827 im Ziel A538 Matis VIMKESTEIJM NED 17244 18 001 15 34 33 M30 33 Zwaar 7002 379 188 M30 01 112014 15 48 49 wwiraceresult com fF 8B 0 race result 11 Advanced Users Guide 6 RACE SETUP GUIDE The best way to learn how to set up complex event files is to learn from examples That is why we provided different examples in the support section on our raceresult com website This section will describe some general design guide lines that proved to be helpful in the past 6 1 Choose IDs wisely When you set up results or ranks choose your IDs wisely Make sure that IDs are intuitive e g lap 1 in result 21 lap 2 in result 22 lap 3 in result 23 and so on instead of lap 1 in result 17 Also make sure to leave gaps in our IDs maybe you would like to add something in between later 6 2 Use Field Names You can access times ranks additional fields via the ID e g Rank3 or via its name e g AgeGroupRank The set up of your lists and certificates will be easier to understand later if you use the names instead of the IDs Therefore make sure to use a short yet concise name that you will not change later 6 3 Use User Defined Fields Whenever you need an expression like Choose lISlsex rz Men Women Coed create a User Defined Field You will definitely need thi
39. he formula will return the value of result 21 Otherwise it will return the value of T22 and add 10 seconds see next chapter to learn what the formula returns for men who do not have a time in result 22 The formula can also access the ranks and team scores Assume you would like to calculate points like this 1 place 10 points 2 place 9 points 10 place 1 point others 0 points For this you can use this simple formula max l11 Rank1 0 The formulas can be nested and thus get as complicated as necessary You can imagine that you can calculate virtually anything similar like in Excel 3 1 Finish Result Another important concept regarding results is the Finish Result The finish result is an attribute of a contest and can be defined in Main Window gt Contests Selecting one result as finish result has the following effects The field Finished will be 1 if the participant has a positive time in the finish result i e the field corresponds to the field TimePositiveX where X is the ID of the finish result The fields DecimalTime RoundedTime and Time without a number at the end will return the rounded decimal time value and formatted time of the selected finish result Note that the finish result can refer to different results for participants in different contests This will turn out to be very helpful later By default also the calculation of ranks is based on the finish result 3 8 Ranks After defining
40. if teams can have either only women or only men Enter these fields in the Team Aggregation settings 2 Define the minimum and maximum number of participants per team and enter these in the Number of Participants settings In many cases the teams will have a fixed size e g 3 participants per team so make sure to enter the same value for minimum and maximum If a team can have any number of women make sure to enter 0 for Min Number of Women 3 Usethe Filter setting to define who will be considered for the team score The filter may be Ob um en so that participants without a club name will be ignored 4 What happens if the number of participants of one club is larger than the maximum team size Depending on the option Max No of Teams the team score will create several teams for a club or it 14 race result AG Haid und Neu Stra e 7 76131 Karlsruhe Germany race result 11 Advanced Users Guide will associate the other participants of the same club with the team but they won t be scored Think of a team score for school classes all children shall be part of the team but only the best 5 shall be scored i e their finish times will be summed up for the team time 5 Think of how the teams will be grouped before the ranking Enter the appropriate fields in the Grouping settings Usually this is a subset of the Team Aggregation fields e g only Contest there will be a 1 2 3 team for the 5K race and another 1 27
41. ions are very advanced You can define not only your own derived fields but also your own functions in Main Window gt User Defined Fields Fct Assume you would like to change the upper lower case of words so that the first letter is in upper case and the other letters in lower case For this you could define this function RightCase x ucase left x l amp lcase mid Ix 2 You can use the new function like any other function now e g RightCase raCEreSuLt will return Raceresult Your functions can also have several parameters For example we can define the add function add x y x ly The names of the parameters can be defined freely When using them in the definition of the function they have to be in square brackets 20 race result AG Haid und Neu Stra e 7 76131 Karlsruhe Germany race result 11 Advanced Users Guide 5 PRESENTATION OPTIONS By now you should have an idea how to generate most of the data you need for scoring your event In chapter 7 we will cover some advanced fields and functions but for now this should be sufficient Having the necessary data it is now about bringing it into the right form using lists and certificates We assume that you have already familiarized yourself with lists and certificates You know that a list serves to put many records on one page whereas a certificate will have one record per page with free placement of data pictures and other elements You have explored the
42. l Diff Wechsel Wechsel Wechsel Diff 1 716 JuraDefi 17 54 1 2 21 52 6 2 1 14 30 3 1 45 333 1 2 41 18 9 1 810 Mt Pilatus Power 26 48 1 3 25 41 1 1 1 53 49 4 3 55 554 2 3 44 18 0 00 35 1 00 25 3 00 27 7 00 41 8 00 51 0 00 30 9 Joris Dubail Oriet Gilian Blanchard Tristan Jeanbourquin Patrick Gander Martina Stucki Sarah Schaerer Simone Wenger Iris 2 701 Gilgen Door Systems 19 08 2 3 28 46 9 15 1 20 42 4 2 50 00 5 3 3 00 23 6 2 807 Bikini Girls 26 16 7 2 27 132 4 1 45 52 1 1 1 06 59 6 4 3 48 37 9 00 42 2 00 40 5 00 22 6 19 04 7 01 05 0 00 38 7 00 32 3 4 19 9 Giorgetta Daniele Renner J rg Ryffel Lorenz Burri Hans Aebi Nicola Sandra Stocker Ines Saner Rita ROTHENB HLER Stefanie a 711 Tomahawks 20 01 1 5 23 01 6 7 1 30 18 2 3 55 06 9 5 3 10 20 1 811 BGH Alumni 24 20 4 1 36 40 8 11 2 04 05 1 7 52 50 5 1 3 59 55 6 00 31 7 00 43 8 00 36 6 29 01 2 00 38 3 00 53 2 00 27 2 15 37 5 Woodtli Marc Tschanz Stefan Luthi Stefan B hler Manfred Wehrli Daniela Knecht Arnika Hofer Christina H sler Barbara 4 707 kraftwerk domaspo 25 27 6 14 22 452 6 1 41 30 4 10 47 59 0 2 3 23 29 4 4 804 Hoch 2 Power 28 04 1 4 27 34 6 5 1 51 55 5 2 1 14 44 8 10 4 03 52 1 04 05 2 00 51 3 00 50 4 42 10 5 00 29 8 00 32 3 00 30 7 19 34 0 Lauri Christian Vitis Amir Sutter Stefan Leuenberger Niklaus Kummer Sandra Bichsel Colette Ruef Nina Kopp Nicole 5 712 Bier gewinnt 25 23 8 13
43. le you define that each participant can have the stored times Start 10k split half marathon split 30K split 40K split finish by setting up these results accordingly Note that a time is no more than a decimal number that usually represents the time in seconds So a time of 30 minutes would be stored as the value 1800 seconds Not necessarily the value stored has to be a time it can also present points or any other value that is a number To access these stored values you can use the field DecimalTimeX replace X e g DecimalTimeb for the value in the result with ID 5 There also is a short version 7x e g T5 Usually this short version would be used to calculate formula results see below for example using a formula like T5 T4 whereas on reports and certificates you would use the formatted times 0 30 00 instead of 1800 3 5 Rounded and Formatted Times The rounded and formatted times are derived from the stored decimal times The rounded times can be accessed via the fields RoundedTimeX or short TRx replace X e g RoundedTimeb or TR5 If you are showing rounded times on reports it is recommended to make calculations using rounded times as well otherwise rounding discrepancies may occur The rounded times are also the basis for the formatted times The system uses the rounded value to build a time string like 1 23 45 67 This formatted time can be accessed using the fields TimeX e g Timed All fields can simply be sel
44. mber of team members of that team TSx Teamlndex If several teams can be built from one club the first one will have team index 1 the second team index 2 and so on 3 10 Team Scores with Lap Mode The Lap Mode is a special mode of a team score designed for team lap races like 24h races There is only one timing point per lap and only one rider will be on the track at a time Thus a lap time may be the time stamp of one athlete minus the last timestamp from the previous athlete When activating the Lap Mode in Main Window Team Scores the team score will take all times from the team sort them and calculate the lap times The team will be scored first by the number of laps and second by the time needed The team score will then provide a lot of additional fields TS1 LTNumber TS41 LTActive TS4 LTMin TS41 LTAvg TS1 LTMax TS1 LTSum TS1 LTLastL ap TS1 LTEtaps For further information refer to the race result Online Help and the template Team Lap Race WWW raceresult com 15 race result 11 Advanced Users Guide 3 11 Background Information Real Time Scoring Engine On the previous pages you have read that race result 11 can be used to make a lot of complex calculations that are almost as flexible as Excel For a race it is not only important that you can make any kind of scoring but also that these calculations will be performed very fast with virtually no delay During the race you may need instant real time informati
45. me with the attributes of the event of course it is the same event for every participant Event Settings EventName EventID EventDate EventDate 2 Event lype EventZzlP r A simple use case for that is a race certificate instead of putting the event date on the certificate as fixed text better use the field EventDate so that you do not need to update the certificate next year Maybe you are wondering what attributes the assigned country nation has these are different representations of the name of the country If you select Germany as country for a participant you can show it on a list certificate as Germany GER DE or Deutschland 10 race result AG Haid und Neu Stra e 7 76131 Karlsruhe Germany race result 11 Advanced Users Guide Country CountryName CountryAlpha 2 Country Alpha3 CountrylOC Countrylntlame CountryFlag Contest Contest ContestName DAT TITLES 3 3 Derived Fields Derived fields can be used like any other data field but they are derived from other fields of the participant e g Age Derived from date for birth and event date Year year of birth e g 1983 derived from date of birth Year2 two digit year of birth e g 83 derived from date of birth LastFirstName Combines last and first name to e g Doe John 3 4 Stored Times For each participant an arbitrary number of times can be saved but you need to define these Results first in Main Window Results For examp
46. mula The formula can be any formula that returns a number since results can only contain numbers The formula assistant click on the hand symbol helps you to set up easy formulas and to learn the syntax 2 Difference Time Stan Time Start Time Index 2 Index 3 Index 4 Table C Aggregation Count of the results start Time through Start Time O Aggregation Count of the best results 1 through 1 Descending from Start Time through Start Time C2 Individual Formula Use Rounded Times Cancel The easiest kind of formulas are difference times Example when you save the time stamps after lap 1 2 3 in results 11 12 13 you can set up results with formulas T11 TO 112 111 113 112 to calculate the time of lap 1 29 Other formulas can build the sum average minimum maximum over several results or look up a value in a table Finally you can also build completely individual formulas using the expressions and functions described in the next chapter Very often the function f will be used For example the formula LT LAICUS Rade qo 12 race result AG Haid und Neu Stra e 7 76131 Karlsruhe Germany race result 11 Advanced Users Guide will return the value of result 21 if it is greater zero and the value of result 22 otherwise Many formulas use only times of the athlete however you can also access the participant s data e g iir Sex t I21 T22T10 If the participant is female t
47. nd female teams Cntenum 1 Contest Cntenum 2 Club Cntenurn Contin 4 Creale Mew TS Copy from Humber of Participant Sel here how many participants form beam you do not want to sort the participants within a team in certificates and result Ests according to their time define another sort criterium Min Humber of Participants 3 Max Mumber af Participants 3 Min Humber of Woman g Max Humber af Wom n Order Participants Grouping Define here criteria by which the teams will be separated during ranking Usually anhy Contest sn that teams of different contests receive separate ranks Cntenum 1 Critanum 2 Critanum A klimu 4 You can group your team results report for example by this expression choose TSl Sex Male Teams Female Teams Coed Teams www raceresult com 37
48. nt date Stored times e g time stamp when passing the 10K split timing point Calculated times e g time needed from half marathon split to marathon finish Formatted times the time stamp 5 minutes and 3 seconds can be presented in many formats e g 05 03 00 05 30 0 etc Calculated ranks e g rank in second lap or finish time rank of all athletes having the same first name hypothetically Calculated team results e g team rank team time If you know data bases you can think of a query over the table participants joined with other tables event data contest data age groups and some other magic that makes sure that you also have immediate access to all calculated values such as ranks Whenever you set up an event you need to think about first which information you would like to store besides the standards fields e g participation in city championship t shirt size etc and which information you would like to calculate which times points values are needed Which ranks are needed for my reports and certificates Which team results are needed Start to set up the scorings settings in Main Window gt Advanced Settings accordingly this chapter and then set up the reports you need chapter 5 In the following the data sources listed above will be described in detail 3 1 Stored Data Fields The stored data fields are pretty straight forward You enter something and when using the field it will show what you hav
49. o Sports Event Server Connect to Online Storage Create Zei File Close Print Exit Then make sure SportEventServer com is entered as server and click the Connect button Server Server Then enter your customer id and password and choose your event In order to open an offline file click File gt Open Event as usual and select the file on your computer You can also open a file in your local network if the computer is not the local server by using File gt Connect to Sports Event Server and enter the IP address of the local server 2 3 Sports Event Server The SportsEventServer is the program in the background doing all the data processing You can access it through the icon in the tray bar oul cir oT D 26 10 2014 Deus pT race result 11 Advanced Users Guide File Extras m Connections 127 0 0 1 12 race result Webs 12 12 15 38 11 1 1 29 10 2014 15 38 11 Demo2en ses Statistics 4 4 0 0 0 0 3 3 D 0 0 0 0498s 0 00s 0 01s currently 0 01s 29 10 2014 15 38 24 Version 11 1 88 In detail the SportsEventServer SES does the following As the local server the SES manages TCP IP connections to the various programs on various computers in your local network taccepts job request from these programs A job can either be a write job change participant data add a time change a setting etc or a read job retrieving settings performing a
50. on without any delay in order to be able to show it on a live screen or even in TV graphics For this reason the SportsEventServer in the background performs almost every calculation in real time i e whenever some data is changed e g a new lap time added the server will recalculate and update all depending data e g number of laps fastest lap slowest lap rank of this rider and other riders Therefore the server analyzes the dependencies in the event file and thus knows which information may need to be updated If some data is being changed The dependency tree may look like this RESULT 1 Finizh RESULT 11 After5wimming RESULT 13 AfterRunning RESULT 0 21 RESULT 0 23 RESULT 12 AfterBike RESULT 2 Swimming RESULT 0 22 RESULT 11 AfterSwimming RESULT 0 21 RESULT 13 AfterRunning RESULT 0 23 RESULT 3 Bike RESULT 11 AfterSwimming RANE 1 TotalRank RESULT O0 21 RESULT 1 Finish RESULT 12 AfterBike RESULT 13 AfterRunning RESULT 22 RESULT 0 23 RESULT 4 Running RANE 2 MFRanEkE RESULT 12 AfterBike RESULT 1 Finish RESULT 0 22 RESULT 13 AfterRunning RESULT 13 AfterRunning RESULT 0 23 RESULT 0 23 RANK 3 AGRank RESULT 1 Finish RESULT 13 AfterRunning RESULT 0 23 In this example the system understands that the Total Rank depends on the result Finish which itself depends on the result AfterRunning and so on This example is fairly simply If y
51. ou think of an event like the Tour de France you can imagine that an event file can have hundredths of results and dozens of ranks with long dependency trees There are results for each day special sprint scores overall scores and so on Real Time Limits Note that not everything can be calculated in real time Team scores will be updated in real time only if the real time option is activated in the settings A formula result will not be calculated in real time if it depends on a rank or a team score Everything that depends on something that is not being calculated in real time cannot be calculated in real time either If something is not being calculated in real time it will simply be calculated when needed if you open the result list based on a non real time team score the system will calculate the team score first before creating the list what will create an additional delay of a few milliseconds or seconds depending on the size of the event Circular References When you set up a complex race you can quickly make a tiny mistake which creates a circular references For example the definitions A B C 7 and B A create a circular reference If C has been updated A needs to be updated In return B needs to be updated and then A needs to be update again This will create an endless loop so that the system would never stop working unless it detects the circular reference 16 race result AG Haid und Neu Stra e 7 76131 Karlsruhe
52. ports Cover Sheet Back Sheet Similarly you can put an additional cover sheet at the beginning of your report and an additional back banner page at the end of the report Therefore set up the page as certificate in the Designer and then select it in the page settings of your list Multi Column Reports In some cases it can be helpful to split the page into several columns 24 race result AG Haid und Neu Stra e 7 76131 Karlsruhe Germany race result 11 Advanced Users Guide race result 11 Demo Participants List Bib Name YoB Bib Name YoB Bib Name YoB 265 Wolfgang Gollminski 1957 1045 Dagmar Kropius 1970 TOR HC ON ONE TON M x 1001 Hans WemerMalthieseen 1959 B96 Hamburgische Landesbank etrie en asse Gruner Jahr 1655 HekoNeumm 4993 550 Maltthine Kolberg 1972 3380 _ Birgit Wamke 1970 174 Hendrik Croppenstedt 1998 3378 Carmen Schalnus L bker D NE aae aama BSGHbg Landesbank TJ i i Aii 2 c m O Ep Oli 1973 Jio Hermann scnainus Lubker ST 467 Jens Fock 1966 338 denHomimenn 5 1967 1869 Joke Colmsce 1992 BSG Hein Gas 3378 _ Michael Bolte Moll 11961 354 J rg Croppenstedt 1963 3294 Christian Beutel 1968 3382 RainerTetz 1954 B Kai Neumann SCIEN GNE BGS Brunsb ttel 1589 Marten Becker oo ELITR brods piren LED nnd rv n a n Ke Lam urzeya 3354 Bernd Rimkus 1963 weg a a n Becker in ALLE 332
53. re you will find a small language box at the end of the label fields where you can enter your texts for different languages Bib EN Bib Sex Depending on the language chosen on my raceresult com the accordant text will be shown If you haven t entered the text in a specific language the system will show the English version If an English version is not available either the system will use the language entered first List Background The settings in the Page tab can be used to change the layout of your report for example you can define the page size and format page margins header and footer texts header and footer pictures If this does not fulfill all your needs you can also put a certificate in the background of your list which allows you to position texts and pictures freely like this race result 11 START Overview Window Participants Output myraceresultcom Tools Page Contest lt All Contests gt Half Marathon 5K Race 10K Race Participants Address List Club Registration List Online Payment Participants List123 Participants ListABC Random List Result Lists Age Group Winner CityChampionship Dynamic Formatting Finisher List Newspaper Text Result List AG Result List MF Result List MF AG Team Results Team Results m f Winners List New List Category Ga Import List Certificate Set www raceresult com This option gives you unlimited flexibility in designing your re
54. s expression in several reports certificates later so use a User Defined Field from the beginning 6 4 Finish Result It has been proofed helpful using ID 1 for the finish time result If you do so you always know that the most important time will be in result 1 and thus at the very top for example in the Results tab of the Participants Window Only if you have events with different numbers of laps per contest or with several finish lines at different locations it is very helpful to have several finish results For example ID Name Time Format Rounding 9 Formula Location 9 1 AfterLap1 no rounding T11 TO fh 2 Afterl ap2 Jh no rounding T12 TO 1 3 AfterLap3 J no rounding T13 TO fh 11 TimeStamp1 J no rounding fh 12 TimeStamp2 no rounding M 13 TimeStamp3 J no rounding 1 21 Lap1 J no rounding T11 TO fh 22 Lap2 4 no rounding T12 T11 1 23 Lap3 no rounding T13 T12 1 In this case there are three results for up to three detections 11 12 and 13 The results 21 22 and 23 calculate the time per lap whereas result 1 2 and 3 calculate the time from the gun start until finishing lap 1 2 38 If for example contest 1 has two laps and contest 2 three laps you can simply select AfterLap2 as finish result for contest 1 and AfterLap3 as finish result for contest 2 Instead of using different finish results there are the following alternatives a bad alternative Remove results 2 and 3 rename result 1 to FinishTime and
55. sesctndeugassiadacnasevaissdwiads Gateetseuseasendaandvenmaigtadieds 32 1 1 OSIEDIPEIBIU Ss stein C Enn cON OMEN IIIS MSIE NT M IM NEUES 32 1 2 Gan UNES RERORE UPS 32 Fo Jqopaud BU THIS epatiqutnedimnetadqn a dedu d HT NIMM HEIDE TUE UU SEN 32 1 4 PUn ed FILE TS RR m 33 715 Team Scores Accessing Other Participants eese nnns 33 www raceresult com 3 race result 11 Advanced Users Guide 1b Team Lap Race Additional Fields ssscissicccesssscssdssssdvaessonsstasaanicasdessestaasacivacsnaansiasaasdnncbiciidteavandenseniateiacsasineibinas 35 F Team agp TE eea E 35 L0 Aggregalon FUNCIONS isnon aoas ENE Eaa ETNE aiaa EANAN Aa 35 8 Frequently Asked Advanced Questions sess nnt 37 ay race result AG Haid und Neu Stra e 7 76131 Karlsruhe Germany race result 11 Advanced Users Guide 1 INTRODUCTION Managing and scoring a complex race is based on three pillars Managing and calculating the race data The race scoring software needs to make a lot of calculations like calculating interim times or lap times calculating ranks calculating team results etc Providing this data to different systems and devices Presenting this data in an appropriate from e g as a result list as a race certificate as text message to the athlete s cell phone etc In chapter 2 you will get to know the structure of the system which will help you understand ho
56. settings of lists and saw that you define these through sorting fields which can also create group headers data fields which define what information columns to show on the list and filters which define which records to show on the list You have also checked out the Designer which serves to place and format the elements on your race certificate In this advanced users guide we are now going to cover advanced topics for lists and certificates 5 1 Lists List Sorting Grouping The settings in the section Grouping Sorting define how the records on the list will be sorted If the first field in the first line of the settings is not decisive the second sorting field will be considered and so on When turning on the option Grouping a group header will be inserted every time the value of the field changes Rank Bib Half Marathon Men 3393 3013 3142 S 3338 3237 3349 3009 3134 3089 3049 3367 3449 WP BeN Wey Be Pp a e Name Tim Dammann Tilman Biallas Jens Schenkies Matthias Rickert Jan Mehlert Corwin Leue Oliver Salto Thorsten Karstens Michael Plambeck Olaf Stahl Niels Burrichter Kay Burrichter id Data Format H View 3 Excel Grouping Sorting Sorting Criterium Grouping 9 Contest ru E ContestName SexMF E AgeGroupPos1 E AgeGroup1 Rank3 E E In this example there are two groupings the first for the contest and the second for the age group Also note that the list is
57. sorted first by the field Contest the ID of the contest and then grouped by the ContestName This way the contests will be ordered by the contest ID instead of by the contest name but the contest name will be in the group header Using different fields expressions for the sorting and grouping is very commonly used For example consider the standard team results ii Data Format Grouping Sorting FE View 1 Excel Sorting Criterium Grouping Contest E ContestName TS1 Rank E TS1 Rank amp amp Club amp amp TS1 Teamlndex amp W amp TS1 Time1 TS1 Position E E The group header will show several data points team rank club name team time As a result the expression in the 5 line cannot be used for sorting as a text it would return this order 1 10 11 2 21 22 so that the field 7S7 Rank team rank will be used first for sorting www raceresult com 21 race result 11 Advanced Users Guide Maybe you are wondering what the three slashes in the group header are used for This is a small hack which creates columns within the group headers i Data Format E View E Page PDF i HTML Bib Mame Age Category YoB Half Marathon 1 LG Itzehoe 1 22 24 7 3083 Michael Plambeck 1 26 31 2 M35 1973 3202 Soenke Sievers 1 27 53 7 M50 1962 3005 Bernd Banasch 1 2 59 3 M45 1965 2 Sparkasse in Steinburg 1 25 00 0 3367 Niels Burrichter 1 20 44 0 M40 1968 3449
58. ss the data of all members of the team www raceresult com 33 race result 11 Advanced Users Guide Te bs tele As you can see you can access the data of the y member of the team according to team score x via TSx Py You can use this to turn the detailed team results Bib Name Age Category YoB Half Marathon 1 LG Itzehoe 4 22 24 2 3089 Michael Plambeck 1 26 31 2 M35 1973 3202 Soenke Sievers TZ bee M50 1962 3005 Bernd Banasch 12 533 M45 1965 E Sparkasse in Steinburg 4 25 00 0 3367 Niels Burrichter 1 20 44 0 M40 1968 3449 Kay Burrichter 1 25 10 0 M40 1970 3365 Karsten Wilkens 1 39 06 0 M50 1962 r kein 4 41 02 6 3194 Karl Josef Lamberty 1 32 22 5 M55 1954 3352 Walter Lemor 1 33 51 7 M40 1971 3015 Dr Hans Hermann Sass 1 34 48 4 M65 1947 4 LT St rlauf 4 41 50 9 3057 Roger Steffens 1 28 15 8 M40 1969 3119 Mathias Funk 1 32 52 3 M35 1973 3431 Joachim J rgens 1 40 42 8 M50 1958 into a short version with one line per team still showing the last names of the athletes Data Format Excel 8 Page PDF iB HTML Rank Club Rider1 Rider2 Rider3 Time Half Marathon 1 LG Itzehoe Plambeck Sievers Banasch 4 22 24 2 2 Sparkasse in Steinburg Burrichter Burrichter Wilkens 4 25 00 0 3 kein Lamberty Lemor Sass 4 41 02 6 4 LT St rlauf Steffens Funk J rgens 4 41 50 9 5 Lauffreunde Itzehoe Lassen Wierauske Eckhardt 4 A 24 5 6 kein Gr nbauer Wend Bade 4 54 05 4 T LG Dithmarschen Kreft Hein Petersen 4 64 2763 8 Heidgrabener SV
59. the same first name you can use this expression DCount Finished AND iilos FirstName amp FirstName amp Besides DCount there are the functions DSum DMin DMax DAvg that calculate the sum minimum maximum average of a field and DFirst that returns a field of the first participant fulfilling a expression If you would like to show the average age of all finishers you can use this expression www raceresult com 35 BH race result AG Haid und Neu Stra e 7 76131 Karlsruhe Germany race result 11 Advanced Users Guide DAvg Age IFinished Why the double quotes around the field names Because the parameter is the name instead of the content of the field that the function shall analyze race result 11 Advanced Users Guide 8 FREQUENTLY ASKED ADVANCED QUESTIONS How to overwrite a formula result manually The answer is you can t But you can create a result for the manual time Assume your formula result is result 11 Change the ID to 21 and add another result Manual Time with ID 22 As result 11 you can create a formula result with formula TO 122052 Taz T21 11 ManualOrFormulaResult 1 no rounding if T2220 T22 T1 1 21 FormulaResult 1 no rounding your formula 1 22 Manual no rounding 1t Speed or Time per km Make sure to enter the contest length in meters in Main Window Contests Then you can use these expressions format T1 ContestLength 1000 mm ss amp min km
60. use the formula TMax 11 13 TO This way the finish time will simply be the time after finishing the last lap what 30 race result AG Haid und Neu Stra e 7 76131 Karlsruhe Germany race result 11 Advanced Users Guide creates two problems First you have to change the rank settings so that someone with more laps Is better than someone with less laps Second if someone runs an additional lap for fun he would not have the correct finish time b good alternative Remove results 2 and 3 rename result 1 to FinishTime and use the formula choose Contest T12 T13 TO This is exactly what selecting different finish results for each contest would do in the background but you have more options Assume in contest 2 women run only two laps but men three Then you could use this formula choose lcontest s T127 zzt lSex eo r Tl2TT13 TO For the beginner we would recommend to simply select different finish results complicated enough but the advanced user may appreciate the additional flexibility of option b www raceresult com 31 race result 11 Advanced Users Guide 7 ADVANCED DATA FIELDS AND FUNCTIONS 7 1 Position Fields Ranks chapter 3 8 are a handy concept since they are defined once and can then be used everywhere on a list in a certificate in a text message However sometimes you may want to create a numbered list quickly without creating a rank definition Lets assume you need a result list
61. w data will be exchanged between different devices and components Chapters 3 and 4 are very important and will explain the race result data structure and teach you how to calculate the information you need Chapter 5 will then introduce different options to present the data in the appropriate format Chapter 6 will be a helpful practical guide how to set up your event with a lot of tips and tricks that make your work easier If chapters 3 and 4 were not enough for you chapter 7 will introduce additional data fields and functions not covered before and chapter 8 will provide answers to frequently asked advanced questions www raceresult com d race result 11 Advanced Users Guide 2 SYSTEM STRUCTURE 2 1 Working Online and Offline race result 11 has a server client based structure that runs both online and offline Working online means that your race data is stored in the Internet on a race result server and can be accessed from any place with an Internet connection When working offline your race data is stored locally on your computer and can be accessed only on that computer and other computers in the local network Usually you would work online before and after the event which allows easy online collaboration with other members of the team and also using the results and registration platform my raceresult com During the event however it is recommended to work offline so that you still have access to your data even if you lose Int
62. zehae Triathlon 1 16 55 3 2 3393 Tim Dammann 1983 m Men LG M nsterdorf 1 18 27 7 01 32 3 3367 Niels Burrichter 1965 m M40 Sparkasse in Steinburg 1 20 44 0 03 48 4 3219 Bernd Kaland 1959m M50 1 22 31 1 05 35 5 3009 Oliver Salto 1973m M35 TS Schenefeld 1 24 14 8 07 19 6 3134 Thorsten Karstens 1977m M35 SSV Hennstedt 1 24 55 4 08 00 T 3449 Kay Burrichter 1970m M40 Sparkasse in Steinburg 1 25 10 0 08 14 8 3102 Jan Dreyer 1965 m M45 TSV MuBberg 1 25 15 3 08 20 1 3 Top and Prev Times The functions GapTimeTop and GapTimePrev are actually based on the Top and Prev Times the fields RankXTopY and RankXPrevY 32 race result AG Haid und Neu Stra e 7 76131 Karlsruhe Germany race result 11 Advanced Users Guide return the time in result Y of the winner the previous athletes according to rank X So the field Rank2Top1 may return the decimal time of the first man woman If you add an R the field will return the rounded value Rank2Top1R Rank2PRev1R and if you add the word Text the field will return the formatted time Rank2Top1Text Rank2Prev1Text n nM So instead of GapTimeTop 1 2 mm ss you could write also iif Rank2 1 Tformat rRl lRankZTOplR l mmess Frequently RankXTopY is used in formulas calculating points For example the formula 550 250 Time Time0fFirst minimum 0 points could be implemented in race result like this max 0 550 250 TR1 Rank2Top1R

Download Pdf Manuals

Related Search

Related Contents

Wöhler A 400 e A 400PRO Wöhler A 400iHC  Wireless LAN USB Adapter - EUSSO Technologies, Inc.    Manuale di installazione e manutenzione Manifold di valvole  ダウンロード  Analyzing Computer Game Strategies through Visual    LX400 Brochure - Label Printers, Color Label  

Copyright © All rights reserved. Failed to retrieve file