Instructables

STATSulator : Training Log

Featured
Picture of STATSulator : Training Log
dsc_2891.jpg
dsc_2892.jpg
dsc_2862.jpg
stats-multi.jpg
stats-month.jpg
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. :)

 
Remove these adsRemove these ads by Signing Up

Step 1: Supplies

Picture of 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

Step 2: Tools

Picture of Tools
To cut the plexi glass you will need:
- a utility knife or x-acto knife
- Straight Edge (sXe)
- Clamps

To make the case you will need:
- Dremel
- I used the Dremel Workstation and can't recommend it highly enough.

itisnot_me6 years ago
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?
sanderl6 years ago
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
paqman6 years ago
So you gonna let us know when this goes up on source forge? I've been looking for something like this forever! Looks awesome.
jdege6 years ago
Your display shows average weight. How are you calculating the average?
joe (author)  jdege6 years ago
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 joe6 years ago
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
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?
slmh12966 years ago
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 (author)  slmh12966 years ago
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
Dantex6 years ago
It is really cool! I gave it a +!