Jump to content

WheelLog - 100 cell spreadsheet average chart

Bob Eisenman

Recommended Posts

I made a WheelLog recording of a 10 km ride and imported the comma separated value (CSV) file into a spreadsheet. Copying only the speed, battery %, voltage and distance columns to a new spreadsheet and inserting a line chart of the values produces a line graph with a lot of variation, especially for the battery trace:


If you create a new column for each parameter trace which is a plot of the average of each 100 incremented cells rather than a plot of all cells then the resulting chart is easier to read. In the chart shown above the average 100 cell trace is plotted over the single cell trace. In the following chart only the averaged 100 cell trace is shown:


Yellow=  (battery) voltage

Red= battery %

Blue= speed (km/hr)

Green= distance (km)


Edited by Bob Eisenman
  • Like 1
  • Upvote 2
Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • Create New...