Tracking the data

OK, so it’s just basic tracking of the data in an Excel spreadsheet. Basis hasn’t made an API (or even a basic export facility) available, so there’s no useful way to get data from it.

For example, it tells you how long your longest non-standing/moving period was for the day, but not WHEN it was, which would be a useful piece of information.

So this is all done by hand, simply copying numbers, which is decidedly low tech…

There’s a little bit of simple conditional formatting – total steps highlights at 10K (yellow at best recorded), calories and the rolling seven-day calorie average at 3K.

I used to have a column for gym days, which I deleted – wish I’d kept it, as it shows I burn more and more often when I’m NOT supposed to be going to the gym.

Also, when I’m out walking, it’s about 1500 steps/km, it seems.

01c

 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s