1 of 1 people found this helpful
Create a number field in the Results table, say, laneNumberHeat.
After finding the 16 results by time, execute this script:
Sort Records [ Results::time ]
Replace Field Contents [
Let ( [
ranking = "¶13¶9¶5¶1¶4¶8¶12¶16¶14¶10¶6¶2¶3¶7¶11¶15¶" ;
result = ¶ & Get ( RecordNumber ) & ¶
ValueCount ( Left ( ranking ; Position ( ranking ; result ; 1 ; 1 ) ) )
Sort Records [ Results::laneNumberHeat ]
Thank you so much! You made my day!
Your code worked perfectly. Based on your code, I was then able to make a 100 m Finals Sheet taking the 16 runners in the two heats to make the Final heat of 8.