search

tcgoetz / GarminDB

Download and parse data from Garmin Connect or a Garmin watch, FitBit CSV, and MS Health CSV files into and analyze data in Sqlite serverless databases with Jupyter notebooks.
GNU General Public License v2.0
1.1k stars 138 forks source link

BMR/Active Calories in Activities #240

Open HenningoDK opened 1 month ago

HenningoDK commented 1 month ago

I would like to see the 'Active Calories' included for each individual activity in 'garmin_activities.db' table 'activities'. It exists already as part of the daily summary, but I cannot find it as activity-specific in the database.

The .json files for activity details include values for "calories" and "bmrCalories". I believe the calculation for Active Calories is = Total Calories - BMR Calories.

Adding either BMR Calories, Active Calories or both as separate fields would be great!

tcgoetz commented 2 weeks ago

I believe the calories for an activity, field=calories, is the activities contribution to active calories. I think you should just use the calories field.

HenningoDK commented 1 day ago

Thank you for the reply. The calories-field value matches what is called Total Calories Burned in the Garmin Connect-app though, so it is not exactly what I am looking for. I need to subtract the Resting Calories or BMR Calories, but for now, I can get only get to that number by subtracting an estimate of that value.