Polar Electro announced last year to shut down their Webpage PolarPersonalTrainer by 31.12.2019, as a result older Polar Fitness and GPS watches like the RC3 GPS will be obsolete. There are several options available to still use the watches, but I wanted to have a solution which keeps all training data local and have similar functionality as the Webpage. My software enables to further use these older devices and creates relevant running training information in form of Excel WorkSheets. The software imports the training data in form HRM and GPX Files, creates training session worksheet for each training, and adds the training to an overview sheet.
Export of Fitness Data from the Polar Watch
The data can be easily exported by the Polar Websync Software. Connect your watch, start Websync, and click on Trainingscomputer. Check for Trainingdata and export a selection or all stored files. You then can select the directory to store the trainingdata. In order to get proper yearly overviews, it is recommended to store the training of different years in seperate folders.
This software aims to provide a similar (of course restricted) functionality as the website PolarPersonalTrainer by creating excel sheets with a similar look as the website. For each training session, an individual excel workbook is created as shown in the next figure. All headlines and info is in German, but this can be changed easily when cloning the github repository. Example: 19010601.xlsx
The filename of the individual excel sheet is derived from the filenames of the hrm and gpx files. The data heartrate, pace, speed, and altitude versus time is stored in the same workbook in worksheet ‘Data’ to be used for further analysis.
The software then adds the information on the overview table to a separate excel which should give an overview over the yearly training. It contains of a first sheet which gives overview over total duration, total distance, and number of training sessions for each month.
The workbook contains for each month a table with the detailed overview table, an example with only one training is depicted below.
The software als tries to detect if a training session was of type interval by analyzing variation in heart rate and speed and then adds this information to the worksheet ‘Intervalle’. An example of the yearly overview excel workbook can be found under “Overview_2019.xlsx”.
General example to scan a folder for updated training files, analyze the GPX and HRM data, create a dedicated training session workbook, and update the overview workbook:
python PyPersonalTrainer.py -m scan -o ../Ueberblick_2019.xlsx -tf ../Trainingsdaten_2019 -sf ../Trainingsheets_2019
More information on the usage and different options is available on github. It incldues a jupyter notebook with more detailed examples and a batch file which could be run when new training sessions are available.