{"product_id":"cycling-log-bike-ride-tracker","title":"Cycling Log and Bike Ride Tracker Spreadsheet","description":"\u003cp\u003eThis cycling log is for riders who put in enough distance to wear out a chain and want their rides and their bike parts in one file. Log each ride once with distance, time and climbing, and the workbook works out your speed, your weekly totals and how worn every part is.\u003c\/p\u003e\u003cp\u003eEvery part on every bike counts the distance ridden since it was fitted, and tells you when the chain, the tires or the brake pads are due.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003ePlease read:\u003c\/strong\u003e This is a tracker tool only, not financial, tax, legal, medical or any other professional advice or advisory service. It records and calculates what you enter; you are solely responsible for checking all figures, rates, dates and results and for every decision you make. By purchasing, downloading or using it, you accept these terms (your statutory consumer rights are not affected).\u003c\/p\u003e\u003ch2\u003eThe dashboard\u003c\/h2\u003e\u003cp\u003eNothing on the dashboard is typed. Pick All bikes or one bike and the whole page follows.\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003e\n\u003cstrong\u003eDistance:\u003c\/strong\u003e distance ridden and how much of the year's goal it is\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eThe year so far:\u003c\/strong\u003e distance added up month by month against the pace for your goal\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eThe last 16 weeks:\u003c\/strong\u003e every week's distance against your weekly goal\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eThe longest rides:\u003c\/strong\u003e your five longest, with time, climbing and speed\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eAverage speed\u003c\/strong\u003e over moving time, by month, and your average heart rate\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eHow worn the parts are:\u003c\/strong\u003e each part's distance against its life, amber when due soon\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eKinds of ride:\u003c\/strong\u003e road, gravel, commute, group rides and indoor as shares, and meters climbed month by month\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eWhat sets it apart\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003e\n\u003cstrong\u003eParts that count their own distance:\u003c\/strong\u003e list the chain, tires, pads, cassette and service for each bike with the day each was fitted. Every ride on that bike adds to them, and each part reads Fine, Due soon or Replace now\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eA rough date, not just a percentage:\u003c\/strong\u003e each part's remaining life is divided by the last eight weeks of riding on that bike, so you know whether it is next week or next spring\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eEvery ride worked out:\u003c\/strong\u003e distance, moving time and climbing typed, with average speed and meters climbed per kilometer calculated on every row\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eWeeks, months and the year:\u003c\/strong\u003e every week from Monday against your weekly goal, monthly distance, and progress toward your goal for the year\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eSix connected tabs\u003c\/h2\u003e\u003cp\u003eStart Here, Setup, Rides, Maintenance, Weekly and Dashboard. Rides are copied from any bike computer or app, and the file handles up to four bikes. The worked example follows one rider from January to September: 135 rides on a road bike, a gravel bike and an indoor trainer, ten parts tracked, brake pads marked Replace now and a tire and chain due soon. It doubles as a mileage tracker and bike maintenance record, and keeps your cycling training in a clear bike ride log and bike parts tracker.\u003c\/p\u003e\u003ch2\u003eLight and dark editions\u003c\/h2\u003e\u003cp\u003eEvery download includes a light edition and a dark edition. Every tab is restyled, not just the dashboard, and both use the same formulas. Each comes filled with a worked example and blank, in Excel and in Google Sheets.\u003c\/p\u003e\u003ch2\u003eWorks with\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eMicrosoft Excel 2016, 2019, 2021 and Microsoft 365, on Windows and Mac, and LibreOffice\u003c\/li\u003e\n\u003cli\u003eGoogle Sheets with a free Google account. The Google Sheets version is a real workbook you make your own copy of, not a PDF with a link in it.\u003c\/li\u003e\n\u003cli\u003eNo dynamic arrays, no macros, no add-ins and no subscription\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eWhat you download\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eLight edition: the Excel workbook filled with a worked example, and a blank one\u003c\/li\u003e\n\u003cli\u003eDark edition: the same two files in the dark design\u003c\/li\u003e\n\u003cli\u003eThe instruction guide, which has one-click links to the Google Sheets versions (light and dark, filled and blank)\u003c\/li\u003e\n\u003cli\u003eThe terms of use as a PDF\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003eYour files are ready to download as soon as payment clears. The template is for personal and business use on your own devices, so please do not share or resell the files. Questions before or after you buy? Use our contact page and we will help.\u003c\/p\u003e\u003ch2\u003eFrequently asked questions\u003c\/h2\u003e\u003ch3\u003eDoes it work in Excel and Google Sheets?\u003c\/h3\u003e\u003cp\u003eYes. You download Excel workbooks for Excel 2016 or later on Windows and Mac, and the instruction guide has one-click links to make your own copy in Google Sheets with a free Google account.\u003c\/p\u003e\u003ch3\u003eHow many bikes can I track?\u003c\/h3\u003e\u003cp\u003eUp to four bikes, each with its own parts and rides.\u003c\/p\u003e\u003ch3\u003eHow does it know when a part needs replacing?\u003c\/h3\u003e\u003cp\u003eEach part counts the distance ridden on its bike since the day it was fitted, compares it with the part's life and reads Fine, Due soon or Replace now, with a rough due date.\u003c\/p\u003e\u003ch3\u003eDoes it import rides from my bike computer?\u003c\/h3\u003e\u003cp\u003eNo. You copy distance, moving time and climbing from any bike computer or app, and the file works out the rest.\u003c\/p\u003e\u003ch3\u003eWhat is the difference between the light and dark editions?\u003c\/h3\u003e\u003cp\u003eOnly the look. Both have the same tabs and formulas, and both are included in every download.\u003c\/p\u003e","brand":"OPXVIA","offers":[{"title":"Default Title","offer_id":67597873053790,"sku":"OPX-222","price":14.0,"currency_code":"CAD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0769\/2094\/6782\/files\/cycling-log-bike-ride-tracker-01.jpg?v=1790833193","url":"https:\/\/opxviashop.com\/products\/cycling-log-bike-ride-tracker","provider":"OPXVIA","version":"1.0","type":"link"}