Excel Pivot Tables and Charts









You can download the Excel spreadsheet from /Oct Data on My Github Page

The spreadsheet contains tabs for Oct Vitals, Oct Rides, Oct Power Meter, along with the Oct Pivot Tables and Oct charts. (Note – It is too large of a file to preview on Github, due to formatting.)

Oct. Excel Pivot Tables and Charts


A sample of Oct. Rides color coded by Ride type. 


Pivot Table 1 = Summary of Oct. ride data showing sums of total distance, calories burned & averages of speed, cadence and power broken down by route and date. 


Pivot Table 2 = Combination of 2 pivot tables broken down by date, showing average heart rate, weight, BMI&, body fat %, muscle mass (lbs) before rides, and average heart rate, max heart rate and total calories burned during rides for the corresponding dates. 


Chart 1 = bar chart showing averages of speed, cadence & power broken down by route. 

Chart 2 = line chart showing blood pressure, & heart rate by date. (Note – data did not start getting collected on all of these until 10/14/2022.)

Chart 3 = average heart rate, weight, body fat& and muscle mass (lbs) on ride days. (Note – not all ride days had complete vitals.) 

Chart 4 = average and max heart rate with total calories burned during rides. 

To hire me click HERE


To learn more about the Freelance Data Analyst and Cloud Engineering work I do, please visit XL Mobile Media
To learn more about the Digital Marketing and Analytics work I do, please visit XL Digital Media