STATSulator : Training Log

The STATSulator is a php/mysql app and bs2 lcd desktop display that keeps track of all your training. It allows you to see what your training buddies are also putting in, raw hours, not the details for your friends activity...

This STATulator was born around new years 07, I was talking with some bike riding buddies and they were looking at their end of year spreadsheets. How many miles they rode, how little they used their mountain bike... And the inner geek in me decided to write the STATSulator.

After a full year of use it has turned out really useful for me. It has shown me how much I rode my commuter bike, after that the mountain bike... But now I carried my craziness over to a new level and track my weight in it as well.

As a project I thought it would be neat ot also make a physical desktop display for it that at a glance would display my stats, to see if I could skip riding that day. :)

Step 1 Supplies

I used the following for this project, but you could use a ton of things for this.

- Plexiglass small sheet
- Allthread (I used #6/32)
- 16 nuts ( I used #6/32)
- 16 washers (I used #6)

- Basic Stamp 2
- Basic Stamp Board
- Parallax 4 x 20 LCD (I used the 4x20 backlit model)

- Wall Wart

-Linux box ( I use fedora core 8)
-- Have PHP/Apache/Mysql Installed
-- Install the BSTAMP Package from sourceforge to compile bs2 code
-- JPGraph

Comments

[itisnot_me]

I would really love to see the code/database that you used to put this app together. i myself am a web developer and this intrigues me. do you happen to have any php/mysql tuts. how about ubuntu, would it work on this thing. also can you use this for just about anything? like saving for something or clients or what not?

[sanderl]

I'm anxiously waiting to see the code. I can't wait to try this. This will be a great tool to get my buddies on their bikes this year!!! Is there anyway to be alerted when you post the code? Thanks, Sander

[paqman]

So you gonna let us know when this goes up on source forge? I've been looking for something like this forever! Looks awesome.

[jdege]

Your display shows average weight. How are you calculating the average?

[joe]

I am using my average weight, which is stored in a table.
The table is called weights and has 4 columns
mysql> desc weights;
+--------+---------+
| Field | Type |
+--------+---------+
| id | int(11)
| uid | int(11)
| weight | float
| date | date

Then I use a select the avg weight for the user I am looking for,
select round(avg(weight),0) from weights where uid='$uid'

-Joe

[jdege]

Using an exponentially-weighted moving average would possibly provide a better indicator of what your true weight is, and would certainly have a higher buzzword coefficient.

The Hacker's Diet

[GorillazMiko]

WOW, THAT'S REALLY COOL!

_{No, I am not going to talk in Caps Lock for the rest of this comment.}

Wow, you did an excellent job, it looks really super duper coolio. Yeah. Coolio.
But seriously Joe, this is just awesome. Great job.
+1 rating.

_{By the way, why did you feature it yourself?}

[slmh1296]

Joe I love this I am going to build one. Do you have to have a linux system or will windows work I have a extra hardrive I can use but did not want to go throught the trouble of that.

[joe]

Thanks!, You don't need linux for this, you could use windows. The stamp support for windows is even better.

You can get a unix like environment on windows though, using cygwin. Cygwin is available at http://cygwin.com/http://cygwin.com/

But regardless of that there is a really easy to install package from XAMPP that includes apache,mysql,php,perl for windows linux or os x. Check it out here: http://www.apachefriends.org/en/xampp.htmlhttp://www.apachefriends.org/en/xampp.html

-Joe

[Dantex]

It is really cool! I gave it a +!