This tool updates your Voltaic Benchmark Progress Sheet with high scores and averages of completed challenges on KovaaK.
Run it before checking your progress sheet, or leave it running in the background to keep your sheet up-to-date as you play.
Easily keep track of additional scenarios beyond the scope of the Voltaic Benchmarks through the configuration file.
-
Download and extract the latest release.
-
Go here, and ensure you are logged in to the same Google Account that owns your progress sheet.
- Click the blue
Enable Google Sheets API
button. - Click
Next
in the bottom-right. - Click
Create
in the bottom-right. - Click the blue
DOWNLOAD CLIENT CONFIGURATION
button. - Move the
credentials.json
file to your extracted folder, alongsideProgressSheetUpdater.exe
andconfig.json
.
- Click the blue
- Open
config.json
in your text editor of choice and add your sheet's ID. Then save and close the file.
{
...
"sheet_id": "175i2Us2Vyi3eauSe5rWE94KE4DmIJE_iusa2d4OvC3E",
...
}
You can edit the options in this config to your liking.
"stats_path":
Here you input the path to your Kovaak's stats folder, for most people it is
"C:\\Program Files (x86)\\Steam\\steamapps\\common\\FPSAimTrainer\\FPSAimTrainer\\stats".
Make sure you use "\\".
"sheet_id":
Here you input the id of your Progression Sheet.
To get the id you need the part between the "d/" and the "/edit"
For "https://docs.google.com/spreadsheets/d/abcde12345xyz/edit#gid=316103388" it would be "abcde12345xyz"
"highscore_ranges":
Here you input the range where the highscores will be pasted into, keep them at the preset if you do not wish to add extra scenarios to track.
"average_ranges":
Here you input the range where the averages will be pasted into, keep them at the preset if you do not wish to add extra scenarios to track.
"update_sheet_on_startup":
If "true" this updates your sheet on startup of the program, using all runs u played even when the program was not running.
If "false" this will not update your sheet on startup.
"calculate_averages":
If "true" the program calculates the averages of your last x runs.
If "false" it does not.
"num_of_runs_to_average":
Here you input the number of runs you want to use to calculate the averages.
"polling_interval":
Here you input the time between updates to the sheet.
Polling rates lower than 60 are not advised to use.
-
Run
ProgressSheetUpdater.exe
.- Choose the account that owns your progress sheet.
- Click
Advanced
in the bottom-left, thenGo to Quickstart (unsafe)
. - Click
Allow
. - Click
Allow
again. A file calledtoken.pickle
will be saved to avoid future prompts.
-
Beat your high scores.
Windows with Python 3.7+,
$ git clone https://github.com/VoltaicHQ/Progress-Sheet-Updater
$ cd Progress-Sheet-Updater
$ pip install -r requirements.txt
Edit the paths in main.spec
to match your setup.
$ pyinstaller main.spec main.py