Result Functions are used to compare an individual participants results.

Most use the format TFunction(a;b) where a and b define the range of Result IDs which should be considered.

e.g. TMin(1;10) - returns the minimum time from the Results with ID from 1 to 10

Some functions have additional parameters which are explained with the function. There are further additional variations of each function which are also explained within.

TCount()

TCount(a;b) counts how many times are entered in the results with ID a to b.

e.g. TCount(1;10) - returns how many times are entered in the Results with ID from 1 to 10

TCountIf()

TCountIf(a;b;c;d) counts how many times in the results a to b are greater than or equal to c but less than or equal to d, where c and d are times entered as seconds.

e.g. TCountIf(21;25;25200;36000) - Counts the number of times in Result IDs 21 - 25 which are greater than or equal to 25200s (07:00:00) and less than or equal to 36000 (10:00:00)

TTCount()

TTCount(a;b) takes an arbitrary list of result IDs and counts how many times are entered in those results

e.g. TTCount(10;20;30;40) - returns how many times are entered in the Results with IDs 10,20,30 & 40

TSum()

The function TSum(a;b) calculates the sum of the times in the results with IDs a to b.

TSum(10;12) - equivalent to nz(T10)+nz(T11)+nz(T12)

The function TSum(a;b;c;d) retrieves all times in the results with IDs a to b, sorts them from smallest to largest and then calculates the sum of the best results from positions c to d.

TSum(10;15;1;2) - sums the two best times of the results 10 to 15.
TSum(10;15;3;3) - returns the third best time of the results 10-15.

TSum(a;b;c;d;1) corresponds to TSum(a;b;c;d), but sorts the times in descending order.

TRSum()

TRSum(a;b), TRSum(a;b;c;d) and TRSum(a;b;c;d;1) have the same functionality as TSum() but use the rounded time values.

TTSum()

TTSum() takes an arbitrary list of result IDs and returns the sum of the times in those IDs

TTSum(10;20;30;40) - equivalent to nz(T10)+nz(T20)+nz(T30)+nz(T40)

TTRSum()

TTRSum() has the same functionality as TTSum() but uses the rounded time values.

TMin()

TMin(a;b) returns the minimum time or value from results with ID a to b

e.g. TMin(1;10) - returns the minimum time from the Results with ID from 1 to 10

TRMin()

TRMin(a;b) has the same functionality as TMin() but uses the rounded time values.

e.g. TRMin(1;10) - returns the minimum time from the Results with ID from 1 to 10 using rounded time values.

TMinID()

TMinID(a;b) has the same functionality like TMin() but returns the ID of the result that holds the minimum time.

e.g. TMinID(1;10) - returns the ID of the result with the minimum time from the Results with ID from 1 to 10

TMinText()

TMinText(a;b) has the same functionality like TMin() but returns the formatted time of the result.

TMinName()

TMinName(a;b) has the same functionality as TMin() but returns the name of the result that holds the minimum time.

This can only be used directly in output lists or in user-defined fields / functions, it cannot be used in Results as it returns a text value.

e.g. TMinName(1;10) - returns the name of the result with the minimum time from the Results with ID from 1 to 10

TTMin()

TTMin() takes an arbitrary list of result IDs and returns the minimum time or value from those results.

e.g. TTMin(11;21;31;41) - returns the minimum time from the list of results 11,12,14,13

TTRMin()

TTRMin() has the same functionality as TTMin() but returns the rounded time of the result that holds the minimum time.

TTMinID()

TTMinID() has the same functionality as TTMin() but returns the ID of the minimum result.

TTMinText()

TTMinText() has the same functionality as TTMin() but returns the formatted time of the minimum result.

TTMinName()

TTMinName() has the same functionality as TTMin() but returns the name of the result that holds the minimum time.

TTMinIndex()

TTMinIndex() has the same functionality as TTMin() but returns the position in the list of the result which holds the minimum time.

e.g. TTMinIndex(10;20;30;40) - returns a number 1-4 according to which result of 10,20,30 & 40 holds the minimum time

TMinIf()

TMinIf(a;b;c;d) returns the minimum time from results with ID a to b, which is greater than or equal to c but less than or equal to d.

e.g. TMinIf(1;10;3600;3900) - returns the minimum time from Results with ID from 1 to 10, which is greater than or equal to 1h and less than or equal to 1h05m

TMinIfID()

TMinIfID(a;b;c;d) has the same functionality like TMinIf(), but returns the minimum ID of the results with ID a to b, which is greater than or equal to c but less than or equal to d.

TAvg()

Tavg(a;b) calculates the average of the times in Results with ID from a to b

e.g. TAvg(1;10) - returns the average time of the Results with ID from 1 to 10

TRAvg()

TRAvg(a;b) has the same functionality as TAvg() but uses the rounded time values.

e.g. TRAvg(1;10) - returns the average time of the Results with ID from 1 to 10 using rounded time values

TTAvg()

TTAvg() takes an arbitrary list of result IDs and returns the average of the times or values in those results

TTAvg(10;20;30;40) - returns the average time of results 10,20,30 & 40

TTRAvg()

TTRAvg() has the same fnuctionality as TTAvg() but uses the rounded time values

TMax()

TMax(a;b) returns the maximum time or value from results with ID a to b.

e.g. TMax(1;10) - returns the maximum time from the Results with ID from 1 to 10

TRMax()

TRMax(a;b) has the same functionality as TMax() but uses the rounded time values.

e.g. TRMax(1;10) - returns the maximum time from the Results with ID from 1 to 10 using rounded time values

TMaxID()

TMaxID(a;b) has the same functionality as TMax() but returns the ID of the result that holds the maximum time.

e.g. TMaxID(1;10) - returns the ID of the result with the maximum time from the Results with ID from 1 to 10

TMaxText()

TMaxText(a;b) has the same functionality as TMax() but returns the formatted time of the result that holds the maximum time

TMaxName()

TMaxName(a;b) has the same functionality as TMax() but returns the name of the result that holds the maximum time.

This can only be used directly in output lists or in user-defined fields / functions, it cannot be used in Results as it returns a text value.

e.g. TMaxName(1;10) - returns the name of the Result with the maximum time from the Results with ID from 1 to 10

TTMax()

TTMax() takes an arbitrary list of result IDs and returns the maximum time or value from those results.

e.g. TTMax(11;21;31;41) - returns the maximum time from the list of results 11,21,31,41

TTRMax()

TTRMax() has the same functionality as TTMax() but returns the rounded time of the result that holds the maximum time.

TTMaxID()

TTMaxID() has the same functionality as TTMax() but returns the ID of the maximum result.

TTMaxText()

TTMaxText() has the same functionality as TTMax() but returns the formatted time of the result that holds the maximum time.

TTMaxName()

TTMaxName() has the same functionality as TTMax() but returns the name of the result that holds the maximum time.

TTMaxIndex()

TTMaxIndex() has the same functionality as TTMax() but returns the position in the list of the result which holds the maximum time.

e.g. TTMaxIndex(10;20;30;40) - returns a number 1-4 according to which result of 10,20,30 & 40 holds the maximum time

TMaxIf()

TMaxIf(a;b;c;d) returns the maximum time from results with ID a to b, which is greater than or equal to c but less than or equal to d.

e.g. TMaxIf(1;10;3600;3900) - returns the maximum time from Results with ID from 1 to 10, which is greater than or equal to 1h and less than or equal to 1h05m

TMaxIfID()

TMaxIfID(a;b;c;d) has the same functionality like TMaxIf(), but returns the minimum ID of the results with ID a to b, which is greater than or equal to c but less than or equal to d.

TFirst()

TFirst(a;b) scans the results a to b and returns the first time entered (Lowest ID).

e.g. TFirst(1;10) - returns the time from the result with the lowest ID from Results with ID from 1 to 10

The function TFirst(a;b;c;d) retrieves all times in the results with IDs a to b and sorts them from smallest to largest.
It then only considers the cth best to dth best result and returns the first time of these (=lowest ID).

e.g. TFirst(1;10;1;3) - Returns the result with the lowest ID from the smallest 3 times from Result IDs 1-10

TFirst(a;b;c;d;1) corresponds to TFirst(a;b;c;d), but sorts the times in descending order.

TFirst(a;b;0;0;0;c) scans the results a to b and returns the cth time entered.

e.g. TFirst(1;10;0;0;0;3) - Returns the result of the 3rd result (according to Result IDs) which has been entered from Result IDs 1-10

TRFirst()

TRFirst(a;b), TRFirst(a;b;c;d), TRFirst(a;b;c;d;1) and TRFirst(a;b;0;0;0;c) has the same functionality as TFirst() but use the rounded time values.

TFirstID()

TRFirstID(a;b), TRFirstID(a;b;c;d), TRFirstID(a;b;c;d;1) and TRFirstID(a;b;0;0;0;c) has the same functionality as TFirst() but returns the ID of the result that holds the first time.

TFirstText()

TRFirstText(a;b), TRFirstText(a;b;c;d), TRFirstText(a;b;c;d;1) and TRFirstText(a;b;0;0;0;c) has the same functionality as TFirst() but returns the formatted time of the result.

TFirstName()

TFirstName(a;b), TFirstName(a;b;c;d), TFirstName(a;b;c;d;1) and TFirstName(a;b;0;0;0;c) have the same functionality as TFirst() but return the name of the result that holds the first time.

TTFirst()

TTFirst() takes an arbitrary list of result IDs and returns the first time entered according to the order of the results in the list.

e.g. TTFirst(11;21;31;41) - returns the first time from the list of results 11,12,14,13 in that order

TTRFirst()

TTRFirst() has the same functionality as TTFirst() but returns the rounded time of the first result.

TTFirstID()

TTFirstID() has the same functionality as TTFirst() but returns the ID of the first result.

TTFirstText()

TTFirstText() has the same functionality as TTFirst() but returns the formatted time of the first result.

TTFirstName()

TTFirstName() has the same functionality as TTFirst() but returns the name of the first result.

TTFirstIndex()

TTFirstIndex() has the same functionality as TTFirst() but returns the position in the list of the first result.

e.g. TTFirstIndex(10;20;30;40) - returns a number 1-4 according to the first result of 10,20,30 & 40 which holds a time

TLast()

TLast(a;b) scans the results a to b and returns the last time entered (Highest ID).

e.g. TLast(1;10) - returns the time from the result with the highest ID from Results with ID from 1 to 10

The function TLast(a;b;c;d) retrieves all times in the results with IDs a to b and sorts them from smallest to largest.
It then only considers the cth best to dth best result and returns the last time of these (=highest ID).

e.g. TLast(1;10;1;3) - Returns the result with the highest ID from the smallest 3 times from Result IDs 1-10

TLast(a;b;c;d;1) corresponds to TLast(a;b;c;d), but sorts the times in descending order.

TLast(a;b;0;0;0;c) scans the results a to b and returns the cth last time entered.

e.g. TLast(1;10;0;0;0;3) - Returns the result of the 3rd from last result (according to Result IDs) which has been entered from Result IDs 1-10

TRLast()

TRLast(a;b), TRLast(a;b;c;d), TRLast(a;b;c;d;1) and TRLast(a;b;0;0;0;c) have the same functionality as TLast() but use the rounded time values.

TLastID()

TLastID(a;b), TLastID(a;b;c;d), TLastID(a;b;c;d;1) and TLastID(a;b;0;0;0;c) have the same functionality as TLast() but return the ID of the result that holds the last time.

See TLast() for examples of using this.

TLastText()

TLastText(a;b), TLastText(a;b;c;d), TLastText(a;b;c;d;1) and TLastText(a;b;0;0;0;c) have the same functionality as TLast() but return the formatted time of the result.

See TLast() for examples of using this.

TLastName()

TLastName(a;b), TLastName(a;b;c;d), TLastName(a;b;c;d;1) and TLastName(a;b;0;0;0;c) have the same functionality as TLast() but return the name of the result that holds the last time.

See TLast() for examples of using this.

TTLast()

TTLast() takes an arbitrary list of result IDs and returns the last time entered according to the order of the results in the list.

e.g. TTLast(11;12;14;13) - returns the last time from the list of results 11,12,14,13 in that order

TTRLast()

TTRLast() has the same functionality as TTLast() but returns the rounded time of the last result.

TTLastID()

TTLastID() has the same functionality as TTLast() but returns the ID of the last result.

TTLastText()

TTLastText() has the same functionality as TTLast() but returns the formatted time of the last result.

TTLastName

TTLastName() has the same functionality as TTLast() but returns the name of the last result.

TTLastIndex()

TTLastIndex() has the same functionality as TTLast() but returns the position in the list of the last result.

e.g. TTLastIndex(10;20;30;40) - returns a number 1-4 according to the last result of 10,20,30 & 40 which holds a time

T()

T(x) returns the value in result x as decimal value.

Avoid using the T() function for Formula Results - it creates major dependencies within your file!

TR()

TR(x) returns the rounded time in result x as decimal value.

Avoid using the TR() function for Formula Results - it creates major dependencies within your file!

TName()

TName(x) returns the name of the result with ID x.

TText()

TText(x) returns the formated time value in result x.

DMaxMin()

DMaxMin(a;b;c) scans the results a to b and returns the maximum of times less than c, where c is a time value entered as seconds.

e.g. DMaxMin(1;10;3600) - Returns the maximum time from Results 1-10 which is less than 3600s (1 hour)