Comparing Power Meters using a Spreadsheet

-

My Stages SB20 Smart Bike has crank power meters.  I routinely compare them with readings from my Garmin Rally Pedals.  Here's how I do it.

Add Gamin Pedals







Mount Garmin pedals on the SB20 Smart Bike.

This means two independent power meter systems are available to simultaneously measure the same activity.





Prepare an Activity

You can use Zwift to do a free ride, race or structured workout (or consider using a advanced structured workout app like TrainerDay). 


Configure Zwift to use the Stages Bike for Resistance (formerly Controllable).

Use the Stages PM as the Power Source and for Cadence.

Tip: Also use an HRM. Heart rate data helps you synchronize metrics in a later step.
   


Get a Second Opinion

Use another app or device to simultaneously record your Zwift Activity.  I use a Garmin computer to record activities on the Stages Bike.  It is configured to use the Garmin Pedals for Power and Cadence. It also gets heart rate data from the same HRM used in the previous step.

Test Scenario

The overall scenario looks like this:

Summary

Zwift will:

1.  Get Power and Cadence data from the Stages PM.

2.  Control the SB20 Smart Bike.

3.  Get Heart Rate data from a specific HRM. 

Garmin Computer will:

4.  Get Power and Cadence data from the Garmin pedals.

2.  Gets simulation data SB20 Smart Bike that is controlled by Zwift.

3.  Get Heart Rate data from the same HRM as #3 above. 

Doing Test Ride

You can now start a free ride, race or structured workout in Zwift:
  • Zwift Event: Start the activity in Zwift.
  • Garmin Computer: Start the Garmin Computer when the Zwift Event starts.
When the event ends:
  • Zwift Event: Save the event. You can optionally configure Zwift transfer the results to connect.garmin.com to make the next steps easier.
  • Garmin Computer: Stop the Garmin Computer when the Zwift Event ends. Transfer the workout to connect.garmin.com.
You now have two views on the same event. If you configured Zwift to transfer results to connect.garmin.com, both workouts will listed there as Activities. If you didn't set this up, just download the .FIT file for this event from Zwift. 

Zwift and Garmin computer files measure the same power produced by a rider.  Speed and distance do not match.  Read why it doesn't matter: Smart Bikes and Bike Computers are WRONG. 

Getting .FIT files from connect.garmin.com





Download the .FIT file(s) for the test:

✓ Open the Activity
✓ Click ⛭ utility icon in the top right corner
✓ Export Original menu item.


 


You now have two .FIT files: 

1.  From Zwift with SB20 power readings.
2.  From Garmin Computer with Garmin pedal power readings.
 

Convert .FIT files to .csv 



Use website utility: https://gotoes.org/strava/convert_fit_files_to_csv.php to convert your .FIT files to .csv

Reload this page twice to create .csv files for each of your .FIT files.





Load each .csv into a Spreadsheet

Use your spreadsheet tool of choice. Excel and Google Sheets are fine. I used Apple Numbers.


  Notes:

  1. I normally take just the heart rate, cadence and power columns from each .csv file. I rename SB20 columns to SB20 HR, SB20 cadence and SB20 power. I repeat this pattern for the Garmin columns.
  2. Samples usually do not align. Timestamps don't help much. Instead, I the HRM to align patterns in the data. In this example, I push the SB20 data up by one row.
  3. (optional) I add calculations for averages of the different cadence and power columns. This is helpful for quick comparisions.

Building Charts

There are lots of analysis options, depending on your spreadsheet skills. 

To get started, I normally select the different power columns and create a line chart:


If you got this far, you're now on your own.  Good luck and good testing 🚴🏼‍♂️.

Comments

Post a Comment

Popular posts from this blog

Stages SB20 - Drive Belt Adjustments

-
Image
 STAGES SB20 DRIVE BELT ADJUSTMENT  Stages includes belt adjustment tips in their support note on fixing SB20 noises:   Flywheel Making Noise . Several people have mentioned these instructions are incomplete. I’ll try to help . I wish this process was easier. Good news: With practice, you can complete all adjustments in less than 30 minutes. TWO GOALS Adjusting the drive belt accomplishes two things: Align the belt to ride as much as possible in the centre of the drive cogs. This reduces friction and positions the front axle perpendicular to the drive belt. Don’t be too worried about this step. The SB20 manufacturing tolerances aren’t perfect. Getting the front drive wheel roughly aligned and generally perpendicular is about all we can expect to achieve. Get belt tension right. Optimal tension means quieter running and no slipping during hard efforts. For most of us, this is a trial-and-error process.You want tight but not too tight. For me, this is measured as a 1 cm def...
Click to Read

Stages SB20 - What's Inside?

-
Image
The Stages SB20  indoor smart bike was released in 2020. Let's take a look at the electronics that enable it  on platforms like Zwift.com and TrainerDay.com. An external power supply routes power to different bike components through a series of printed circuit boards (PCBs). The bike also includes two battery powered crank-based power meters. Here's an overview the basic functions: USB Board - Wedged vertically under the phone tray. It powers 3 USB ports. Upper Board - Fastened horizontally under the phone support rail. This System On a Chip (SoC) handles wireless communication and controls the bike itself. Switch Board - This wire distribution board sits inside the aluminum handlebar stem. It routes connections for the brake level controls  and under handlebar tape "blip" shifter buttons.  Lower Board - This mainly analog circuit board is attached to the flywheel / electronic brake unit. It controls bike resistance and sends power to other PCBs. Power Meter...
Click to Read

SB20 - Clicking and Rubbing Noises

-
Image
Just about everyone who rides indoors will eventually hear clicking or scraping noises. Some noises are inconsequential. Others can represent a serious issue.  Let's take a look at some of the most common noise complaints with the Stages SB20 smart bike. Parts Before getting started, here are some key SB20 part names : Flywheel Rubbing against Plastic Cover Manufacturing variances, heat and wear can cause the right plastic cover to make rubbing noises as the flywheel spins. These noises persist after pedalling stops. You can eliminate the problem by trimming the right plastic cover as shown above. Flywheel Cogs Rubbing against Front Cover Fastener Adjusting drive belt tension can move the front axle forward causing it to rub or scrape against the metal fasteners holding the front cover in place.  To verify: Remove the front cover. Look at the front cogs. Do they rub against the front cover fasteners when pedalling . Note: Removing the front cover can cause noises to stop. Th...
Click to Read

What is Erg Mode and Why Can it Suck?

-
Image
Free Riding is Easy Let's start with the relationship between resistance , cadence and power (watts) when doing an indoor free ride (sometimes called sim mode ). Free riding follows a simple formula:  Power in watts  =   How hard you push   ⨉   How fast you pedal   Your indoor bike offers constant resistance when you stay in the same physical or virtual gear. Pedal at a constant RPM and you get a consistent number of watts. If you then pedal 10% faster, you produce 10% more watts.  Pedal 10% slower, you produce 10% fewer watts. 📣 Free Riding Summary: When simulated riding conditions stay the same, pedalling faster produces more watts. Pedalling slower produces fewer watts. And don't forget: There is one way to go faster in Zwift.  Produce more watts 💪.    If only indoor riding was always this simple... Erg Mode When doing structured workouts, Erg mode is popular. It allows you to produce a desired number of watts whether y...
Click to Read

SB20 - Both Power Meter Cranks have Failed - Now What?

-
Image
When your Stages SB20 smart bike is working normally, the built-in power meter cranks provide power and cadence data to apps like Zwift . Behind the scenes, they also provide the data that lets the SB20 regulate resistance when running in Erg mode. Some riders also add 3rd party power meter pedals .  They can work very well.   It surprises many people that Erg mode requires the built-in Stages power meters even when 3rd party power meters are in use.   For more information on SB20 erg mode , see: Erg Mode with a Stages SB20 Smart Bike . Question of the Day 📣 Question:  If my Stages crank power meters fail a nd I have another set of 3rd party power meter pedals , can I still use my SB20 bike?  The Short Answer: You can still do free rides and races in Zwift and other apps. You will not be able to use Erg mode.  ------------------- Urban legend: Erg mode still works with 3rd Party Cranks   Some people report that Erg mode still works when they use ...
Click to Read

Batteries and SB20 Power Meters

-
Image
Today's question: How does battery level affect SB20 power meter measurement? Let's do a deep dive and find out! Replaceable Batteries The Stages SB20 power meters have replaceable batteries. An advantage: No degradation of built-in batteries as the power meters age. A disadvantage: No ability to top up batteries to 100% whenever you wish. Battery Life CR2032 button cell batteries are used in the SB20 power meters. Stages says they should last 150-200 hours . Let's verify this claim with bench tests and torque measurements. Estimating Remaining Capacity The StagesPower  app, and others like BT Inspector, report battery capacity. They use the Bluetooth Low Energy (BLE) wireless protocol to ask each power meter for a battery life estimate.   🔬It doesn't matter which app you use.  All apps report the estimate returned by the power meters. Why Battery Estimates are so Bad Many people complain that battery life estimates from the power meters show 100% most of time. The...
Click to Read