Based on the continued questions that we see from people comparing one power device to another, I decided to try and make something useful. Here is a very rough start at a Google Sheet to compare power values.
See the [Power Tolerances] tab in my google sheet.
- It features 2 areas, with 2 fields for data entry (both in bright yellow)
- Device Power Value
- Device Power Tolerance
You enter one data value and the tolerance related to the measuring device. The manufacturers of smart trainers and power meters list a tolerance, and I plan to populate a list for quick reference. This is the other value. Then do a second one and you can see the variation between them, with the tolerance in effect.
The current calculations take the Power Value and Tolerance, and calculate the Maximum, Middle, and Minimum values. It reports 3 sections as if the data value is either the Max, Mid, or Min with respect to the total range.
I envision taking this and comparing the calculated values to identify if the gaps between data from two devices meet within some acceptable range, or if they are separated. Long term, adding in considerations for things like drivetrain loss could be good.
I decided to start with this and see if people think it has some value for continued refinement?