Resting Heart Rate Calculator

	A	B	D	E	F	G	H	J	K
1	These two fields are copied from your tcx file		All of these are calculated, but may need to copy them down to the end of your data					Here you go:
2	ns1:Time	ns1:Value3	time	time -1	has a minute passed?	index of where to start averaging	average heart rate over previous minute	min heart rate	56

3		63	0:00:00	12/29/1899 23:59:00	FALSE			which occurs:	0:02:29
4		63	0:00:01	12/29/1899 23:59:01	FALSE
5		62	0:00:02	12/29/1899 23:59:02	FALSE
6		62	0:00:03	12/29/1899 23:59:03	FALSE
7		62	0:00:04	12/29/1899 23:59:04	FALSE
8		62	0:00:05	12/29/1899 23:59:05	FALSE
9		62	0:00:06	12/29/1899 23:59:06	FALSE
10		62	0:00:07	12/29/1899 23:59:07	FALSE
11		62	0:00:08	12/29/1899 23:59:08	FALSE
12		63	0:00:09	12/29/1899 23:59:09	FALSE
13		63	0:00:10	12/29/1899 23:59:10	FALSE
14		63	0:00:11	12/29/1899 23:59:11	FALSE
15		63	0:00:12	12/29/1899 23:59:12	FALSE
16		63	0:00:13	12/29/1899 23:59:13	FALSE
17		63	0:00:14	12/29/1899 23:59:14	FALSE
18		63	0:00:15	12/29/1899 23:59:15	FALSE
19		63	0:00:16	12/29/1899 23:59:16	FALSE
20		62	0:00:17	12/29/1899 23:59:17	FALSE
21		62	0:00:18	12/29/1899 23:59:18	FALSE
22		62	0:00:19	12/29/1899 23:59:19	FALSE
23		62	0:00:20	12/29/1899 23:59:20	FALSE
24		62	0:00:21	12/29/1899 23:59:21	FALSE
25		62	0:00:22	12/29/1899 23:59:22	FALSE
26		62	0:00:23	12/29/1899 23:59:23	FALSE
27		62	0:00:24	12/29/1899 23:59:24	FALSE
28		61	0:00:25	12/29/1899 23:59:25	FALSE
29		62	0:00:26	12/29/1899 23:59:26	FALSE
30		62	0:00:27	12/29/1899 23:59:27	FALSE
31		63	0:00:28	12/29/1899 23:59:28	FALSE
32		63	0:00:29	12/29/1899 23:59:29	FALSE
33		63	0:00:30	12/29/1899 23:59:30	FALSE
34		63	0:00:31	12/29/1899 23:59:31	FALSE
35		63	0:00:32	12/29/1899 23:59:32	FALSE
36		63	0:00:33	12/29/1899 23:59:33	FALSE
37		63	0:00:34	12/29/1899 23:59:34	FALSE
38		64	0:00:35	12/29/1899 23:59:35	FALSE
39		64	0:00:36	12/29/1899 23:59:36	FALSE
40		64	0:00:37	12/29/1899 23:59:37	FALSE
41		64	0:00:38	12/29/1899 23:59:38	FALSE
42		65	0:00:39	12/29/1899 23:59:39	FALSE
43		64	0:00:40	12/29/1899 23:59:40	FALSE
44		65	0:00:41	12/29/1899 23:59:41	FALSE
45		65	0:00:42	12/29/1899 23:59:42	FALSE
46		64	0:00:43	12/29/1899 23:59:43	FALSE
47		64	0:00:44	12/29/1899 23:59:44	FALSE
48		64	0:00:45	12/29/1899 23:59:45	FALSE
49		64	0:00:46	12/29/1899 23:59:46	FALSE
50		64	0:00:47	12/29/1899 23:59:47	FALSE
51		64	0:00:48	12/29/1899 23:59:48	FALSE
52		64	0:00:49	12/29/1899 23:59:49	FALSE
53		63	0:00:50	12/29/1899 23:59:50	FALSE
54		63	0:00:51	12/29/1899 23:59:51	FALSE
55		64	0:00:52	12/29/1899 23:59:52	FALSE
56		63	0:00:53	12/29/1899 23:59:53	FALSE
57		63	0:00:54	12/29/1899 23:59:54	FALSE
58		63	0:00:55	12/29/1899 23:59:55	FALSE
59		63	0:00:56	12/29/1899 23:59:56	FALSE
60		62	0:00:57	12/29/1899 23:59:57	FALSE
61		62	0:00:58	12/29/1899 23:59:58	FALSE
62		61	0:00:59	12/29/1899 23:59:59	FALSE			62.90163934
63		61	0:01:00	0:00:00	TRUE	1	62.90	62.90163934
64		62	0:01:01	0:00:01	TRUE	2	62.89	-60
65		62	0:01:02	0:00:02	TRUE	3	62.87	61
66		61	0:01:03	0:00:03	TRUE	4	62.85
67		61	0:01:04	0:00:04	TRUE	5	62.84
68		61	0:01:05	0:00:05	TRUE	6	62.82
69		61	0:01:06	0:00:06	TRUE	7	62.80
70		60	0:01:07	0:00:07	TRUE	8	62.77
71		61	0:01:08	0:00:08	TRUE	9	62.75
72		60	0:01:09	0:00:09	TRUE	10	62.72
73		60	0:01:10	0:00:10	TRUE	11	62.67
74		60	0:01:11	0:00:11	TRUE	12	62.62
75		60	0:01:12	0:00:12	TRUE	13	62.57
76		60	0:01:13	0:00:13	TRUE	14	62.52
77		60	0:01:14	0:00:14	TRUE	15	62.48
78		60	0:01:15	0:00:15	TRUE	16	62.43
79		60	0:01:16	0:00:16	TRUE	17	62.38
80		59	0:01:17	0:00:17	TRUE	18	62.31
81		59	0:01:18	0:00:18	TRUE	19	62.26
82		59	0:01:19	0:00:19	TRUE	20	62.21
83		59	0:01:20	0:00:20	TRUE	21	62.16
84		60	0:01:21	0:00:21	TRUE	22	62.13
85		60	0:01:22	0:00:22	TRUE	23	62.10
86		60	0:01:23	0:00:23	TRUE	24	62.07
87		61	0:01:24	0:00:24	TRUE	25	62.05
88		62	0:01:25	0:00:25	TRUE	26	62.05
89		62	0:01:26	0:00:26	TRUE	27	62.07
90		63	0:01:27	0:00:27	TRUE	28	62.08
91		64	0:01:28	0:00:28	TRUE	29	62.11
92		64	0:01:29	0:00:29	TRUE	30	62.13
93		63	0:01:30	0:00:30	TRUE	31	62.13
94		62	0:01:31	0:00:31	TRUE	32	62.11
95		61	0:01:32	0:00:32	TRUE	33	62.08
96		61	0:01:33	0:00:33	TRUE	34	62.05
97		60	0:01:34	0:00:34	TRUE	35	62.00
98		60	0:01:35	0:00:35	TRUE	36	61.95
99		60	0:01:36	0:00:36	TRUE	37	61.89
100		60	0:01:37	0:00:37	TRUE	38	61.82