Exercise Tracker -- make a copy of your own
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZAA
1
Phil.2:12b-13 Work out your own salvation with fear and trembling; For it is God who operates in you both the willing and the working for His good pleasure.
2
3
This google sheet is for personal tracking of his/her bodily exercise and spiritual exercise (largely based on the 12 points of practices). You may feel free to adjust or add your own metrics.
4
Record your exercise in the Daily sheet. Change just the first Date in the Daily sheet to your starting date. The row above the column title row indicates the kind of input for each column. See the table below for their meanings.Example
5
Use the functions in the menu "My" to invoke the script to aggregate the daily data by week/month/year.
6
- Aggregate:Compute aggregates for new data rows
7
- Reset:Remove all aggregated data rows, if any. Build/rebuild the header rows in weekly/monthly/yearly (e.g. when you add new columns or update old data)
8
Reset is likely to take minutes in setting the column widths etc. Please let it run through (coffee break!) as long as the progress bar on top right showing it is progressing.
9
Tip: after Reset, you may manually adjust the formatting in the hidden row of the header. This way the rows generated by Aggregate will all inherit the same formatting. You might want to set up conditional formatting per column to indicate if a value is excellent, good, average, below average, poor etc. This will help you get a visual overall impression of areas of strength and weakness and progress or regression. You may copy one of the cells below to get the preset conditional formatting.
10
Conditional format for2-3 / week2-3 hours / week (unit being minutes)1 hour / week (unit minutes)Scale 1-10Best everyday2-3 / dayBest all 6 / weekBest every weekBest almost everydayBest AlwaysExerciseWalk
11
Cell to copy
12
13
Y/N1-10#<unit>##<unit>...+GM
14
DailyMark Y if did itRate it in a scale of 1 to 10 (best)Input the number of <unit>s, or simply the number of times if just #, doing itsame as #<unit>same as ..., whatever it is, e.g. Y/N or # etc.N/A
15
WeeklyD: count days marked Y1-10: AverageS(<unit>): SumS(<unit>): SumGeometry mean of columns of the row preceding this column following the previous GM or empty column.
16
D: count days
17
MonthlyAverages of all for full weekly numbersSum of all
18
YearlyAverages of all for full weekly numbersSum of all
19
For GM to be meaningful, you would want to define the metrics such that consistently across all larger means better. For Y/N, Y should be the desired one.
20
GM provides a way to combine the data of multiple columns (related, e.g. on bodily exercise or on contacting people), giving equal weight to the relative progress/regression over a period of time. We may then plot a chart with one trend line GM, instead of 5 or 7 lines for individual columns (or total 30 or 40 lines).
21
22
23
24
1 Tim.4:7b-8 Exercise yourself unto godliness. For bodily exercise is profitable for a little, but godliness is profitable for all things, having promise of the present life and of that which is to come.
25
1 Cor.9:25-26a And everyone who contends exercises self-control in all things; they then, that they may receive a corruptible crown, but we, an incorruptible. I therefore run in this way, not as though without a clear aim;
26
Phil.2:12b-13 Work out your own salvation with fear and trembling; For it is God who operates in you both the willing and the working for His good pleasure.
27
Prov.4:18 But the path of the righteous is like the light of dawn, Which shines brighter and brighter until the full day.
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...
 
 
 
Control
Daily
Weekly
Monthly
Yearly
Chart Weekly
Chart Monthly
Chart Yearly