Skip to main content

Exporting WKO files to CSV

Phew.

I've spent *far too long* decoding the WKO+ binary file format. I'm still not there yet. But close enough that all my WKO files (wow, I have so many) can be exported to CSV and played with in MS access and MS excel.

It was freakin' difficult.

Put it another way, I had to give up decoding via hexdump and hexcmp tools in the end and wrote a tool of my own to compare and examine in binary (!?). But anyways, now all my data is as free as a bird and I'm already creating lots of pointless analysis to explain why I'm so crap! :-)

If you're at all interested the project is hosted over at sourceforge and you can download the convert, it's source code and a document that describes the WKO binary file format. You will also find an older project of mine that converts binary data files from my beloved HAC4 into Polar harm format too.

I can get back to concentrate on riding my bike now!

Edit: Oh, and today I just had my code to support WKO import into Golden Cheetah committed to the repository. Oh and Raceday now supports WKO import too.

Cool.

Popular posts from this blog

W'bal its implementation and optimisation

So, the implementation of W'bal in GoldenCheetah has been a bit of a challenge.

The Science I wanted to explain what we've done and how it works in this blog post, but realised that first I need to explain the science behind W'bal, W' and CP.

W' and CP How hard can you go, in watts, for half an hour is going to be very different to how hard you can go for say, 20 seconds. And then thinking about how hard you can go for a very long time will be different again. But when it comes to reviewing and tracking changes in your performance and planning future workouts you quickly realise how useful it is to have a good understanding of your own limits.

In 1965 two scientists Monod and Scherrer presented a ‘Critical Power Model’ where the Critical Power of a muscle is defined as ‘the maximum rate of work that it can keep up for a very long time without fatigue’. They also proposed an ‘energy store’ (later to be termed W’, pronounced double-ewe-prime) that represented a finit…

Polarized Training a Dialectic

Below, in the spirit of the great continental philosophers, is a dialectic that attempts to synthesize the typical arguments that arise when debating a polarized training approach.

It is not intended to serve as an introduction to Polarized training, there are many of those in-print and online. I think that Joe Friel's blog post is a good intro for us amateurs.

For Synthesis Against A Elite athletes have been shown in a number of studies to train in a polarized manner [1][2][3] There is more than one way to skin a cat. Elite athletes adopt plans that include high-volumes of low intensity and low-volumes of high-intensity. Elite athletes have also been shown to train in a pyramidical manner
[13] B Polarized Zones are between LT1/VT1 and LT2/VT2 [1]
LT1/VT1 and LT2/VT2 can be identified using a number of field based approaches [4][5][6][7]

You can follow guidelines on mapping LT1/LT2 to cycling power to make it useful for amateur cyclists. Polarized zones are har…

W'bal optimisation by a mathematician !

So the integral computation for W'bal was expensive.

I tried to optimise from a domain and  programming perspective, where Dave Waterworth, a mathematician found a much more elegant and fast reformulation.

This means W'bal can EASILY be computed as you ride.

To explain the math here are his words;

I posted a comment on you Blog post on optimising the Wbal model. I've done some more thinking and I defn think it can be done without visiting the previous samples as the Skiba formula can be decomposed further, i.e. From your blog I believe the integral part of the equation is:





Basically this takes a weighted sum of preceding W'exp samples where the weight decays at a rate determined by tau, older samples are weighted less than newer ones. We can approximate as a sum provided tau is large compared to Ts (the sample rate):





Basic properties of exponential functions allow the for…