Bob Eisenman Posted November 11, 2017 Share Posted November 11, 2017 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) Link to comment Share on other sites More sharing options...
This topic is now archived and is closed to further replies.