Let me give you a tour of how I set up the calorie burner calculator. Firstly, I utilized the link database¹ function to separate my database into three views.

The Calculator

Change the calculator properties as needed (ie. for weight fluctuations).

The Calendar

The calendar view is set up to provide a quick reference for the week’s progress. For example, I use it to determine if I have achieved 3 days of cardio every week. Properties shown here are Activity and Calories Burned.

The Log

Here is where I input every circuit (workout). The following properties need to be manually updated for the calculator to return a result:

• Activity

• Intensity

• Stopwatch (Include End Date and Time)

• Week (Inside Circuit entry): This property is for those that want to calculate calories burned weekly.

Tip: Calculate calories burned for a particular week by filtering this view by "Week :: Is :: __" and calculate the sum below the Calories Burned Column.

Formulas

Weight to Kg:

round(100 * prop("Weight lbs") * 0.453592 / 100)

Calories Burned:

round(100 * prop("Weight to Kg") * prop("MET Score") * dateBetween(end(prop("Stopwatch")), start(prop("Stopwatch")), "minutes") / 60) / 100

MET Score (example of one string for “run” activity):

if(prop("Activity") == "Run" and prop("Intensity") == "Leisure" or prop("Activity") == "Run" and prop("Intensity") == "Medium", 9, if(prop("Activity") == "Run" and prop("Intensity") == "Intense", 11

Footnotes

Link Database: (trigger: /link database) Use this function to place a copy of your database inside another page or area. The properties and data within a linked databases can be altered, however, the original database will change as well. This acts as a mirror rather than a duplication. The only altercations that can be made without changing the original database are sort, filter, property arrangement and database view.

COPY TEMPLATE