This app allows you to upload race results CSV files from Virtual Skipper 5, adjust base times, and visualize the results through both a detailed table and a line chart. The tracker includes a rating system, base time adjustment, and comparisons between the leader's time, the base time, and each player's race time.
Your race results CSV files are located in your C:\Documents\Vsk5\Results folder
This application allows you to:
Upload race data: You can upload race results CSV files to visualize and analyze race results.
Adjust base time: You can set a base time to compare player performance against a reference time (like the fastest recorded time).
Visualize results: Race results are displayed in a table and a line chart for easy analysis.
Export to PNG: Download the chart and table in PNG image format for future reference.
a. File Upload
At the top of the screen, you will find an input field labeled "Choose File". This allows you to upload a CSV file containing the race data. The CSV should follow this structure:
Column 1: Rank (1 for first place, 2 for second, etc.)
Column 2: Race Time (in minutes / seconds)
Column 3: Player Login (name of the player)
Column 4: Nickname (not used)
After selecting the file, the app processes the data and displays the results in a table and a chart.
b. Base Time Slider
The Base Time refers to a reference time against which the race times will be compared. This could be the fastest time achieved in the race, or any other specific time you wish to use as a benchmark.
Adjust Base Time: Use the slider under the "Adjust Base Time" section to set a reference time. The slider ranges from 0 milliseconds to 2,100,000 milliseconds (35 minutes). As you adjust the slider, the table and chart will update to reflect how each player’s time compares to the base time.
The format of the time displayed is mm:ss, where:
mm is the number of minutes
ss is the number of seconds.
c. Results Table
Each row represents a player and their performance:
Rank: The player's ranking in the race.
Login: The player's name or login.
Race Time: The time it took the player to complete the race.
Leader Time Offset: The time difference between the player and the leader’s time (first place).
Base Time Offset: The difference between the player’s time and the base time.
Rating (%): A percentage rating showing the player’s performance relative to the base time. A higher rating means the player performed closer to the base time.
d. Line Chart
The line chart visualizes the race times for each player in relation to the base time. The X-axis represents the players (their logins), while the Y-axis shows their race time in seconds. The chart includes:
Race Time Line (Blue): Displays the player's race times.
Base Time Line (Red): Displays the base time you’ve set, allowing you to visually compare each player's performance.
The Rating System is designed to show how each player's race time compares to a reference time, known as the Base Time. It calculates a percentage that reflects how closely each player's race time matches the Base Time.
How It Works:
A 100% rating means the player’s time is exactly equal to the Base Time.
Ratings lower than 100% indicate that the player took longer to finish the race than the Base Time.
Ratings higher than 100% (if applicable) mean the player completed the race faster than the Base Time.
Example:
Let’s say the Base Time is 1 minute (or 60 seconds), and a player's race time is 1 minute and 20 seconds (or 80 seconds).
The Rating for this player would be 75% because the player took 20 seconds longer than the Base Time.
If the player's race time was faster than the Base Time, their rating would be above 100%.
If a player's race time is exactly equal to the Base Time, they score 100%.
If a player’s race time is slower than the Base Time, the rating decreases based on how much longer it took them to finish.
If a player’s race time is faster, the rating will be higher than 100%.
The Rating gives you a quick idea of how each player performed in relation to the chosen Base Time, helping you compare their times more easily.
a. Leader Time
The Leader Time is the fastest race time, typically the first-place time. This time serves as the benchmark for comparing each player's performance.
Leader Time Offset: This value shows the time difference between a player and the leader's race time. A 0:00 value means the player had the same race time as the leader.
Example:
If the leader's time is 1:00, and a player's time is 1:05, the Leader Time Offset for that player will be +0:05 (5 seconds slower than the leader).
b. Base Time vs Player Time
The Base Time Offset compares the player's time to the base time. This can help you assess how close each player is to your target or reference time.
Example:
If the base time is 1:00, and a player's time is 1:15, the Base Time Offset for that player will be +0:15 (15 seconds slower than the base time).
Base Time can be adjusted via the slider, and the table will automatically update to reflect the difference in time for each player.
Performance Analysis: The app helps you analyze performance relative to a reference time, whether that’s the fastest race time (leader time) or any other target time you choose (base time).
Flexibility: The ability to adjust the base time and compare it with player performance is a powerful tool for race organizers and participants to track improvement or evaluate performance in different conditions.
Chrono Score is a simple but powerful tool to analyze race performance. Whether you're comparing times against a leader, tracking improvements with a base time, this app provides an easy way to manage and visualize race data.
Upload your race results CSV files to view the race times and performance ratings on a dynamic slider chart!