I would hope that no body starts morning that I am not writing about enough technology lately, but I’m finding it hard to write about anything at all. Never mind getting motivated to write about the very little news going around. I have been spending my time riding my bike when weather allows, but when the bad weather comes I have to take it inside to the virtual playground of Zwift.

Writing recently in my newsletter I covered my love of the cycling (and running) platform and trying to gamify my cycling as much as possible. I’m still in the very early stages but having just crossed into level 11, my aim is to complete as many of the available routes as possible. Unfortunately Zwift is not great at this, and although the information is obtainable, it’s not easy to work with. So I spent some time building a way to track it.

(adsbygoogle = window.adsbygoogle || []).push({});

There are loads of posts discussing several online and offline manual methods plotting out distances, XP points and the dreaded hilly bits. Thankfully a huge amount of data exists about each route, because so many people have ridden them. While looking for ways to automate this I stumbled on some spreadsheet methods on Reddit, and put together my own version combining several of them.

It’s dead easy to use, most routes link to information about the route you will take and the world used. The spreadsheet itself outlines distance covered (KM) and distance claimed (M) during the route, as well as the XP you will be rewarded for completing it. After a few weeks I am only at 12 % due to better weather currently, but I have done some of the worst – Road to Sky up Alpe Du Zwift, and Mountain 8 up the Epic KOM I particularly hated.

(adsbygoogle = window.adsbygoogle || []).push({});

Don’t forget some worlds are only open on certain days so plan accordingly. Grab the spreadsheet from here and start Zwifting!