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
- 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
Step 2: Tools
- a utility knife or x-acto knife
- Straight Edge (sXe)
To make the case you will need:
- I used the Dremel Workstation and can't recommend it highly enough.
Step 3: App Walkthrough 1
Whats of note here is the table on the left I call the peer pressure module so you and your friends can motivate each other to ride.
Step 4: App Walkthrough 2 - Add Data
Also this page can take uploads from MotionBased exports. So you don't have to key in info twice if you are using a garmin. MotionBased if you are not paying will only allow you to view the last few activities.
Step 5: App Walkthrough 4 - View Time Reports
On these screens you can see your time, breakdown of activities, breakdown of weather and the details of each activity.
Step 6: App Walkthrough 4 - View Details
Also this exports to a CSV file so you can do your own graphs in excel.
Step 7: App Walkthrough 6 - View Activity by Month
Step 8: App Walkthrough 7 - User Prefs
Also on this page you can choose to get monthly status reports and choose to make your info public or not. And by public it just show your total hours in the peer pressure chart on the left.
Step 9: App Walkthrough 8- Healthy Eating Disorder
WARNING: Remember this is a geeky little web page, don't give yourself an eating disorder... seriously.
Step 10: The Desktop Version
Step 11: Desktop Version - Plexi Glass 1
Clamp your straight edge (shout out to minor threat!) to the plexiglass and score it with your x-acto knife.
Step 12: Desktop Version - Plexi Glass 2
Step 13: Desktop Version - Base 1 - Four Corners
Use the first one you make to template the bottom one.
Step 14: Desktop Version - Base 2 - Drilling
With the dremel, set the speed to high and slowly lower the bit through the plexi.
Step 15: Desktop Version - Base 3- Board of Education
Step 16: Desktop Version - Base 4- Allthread
Line them up on top of each other and see how much room you will need for the althread. I needed about 2 3/4".
Cut the allthread to length.
Step 17: Desktop Version - Base 5- Attach
If it does attach them, once again using a washer on each side of the plexi glass.
Step 18: Desktop Version - Base 6- Rubber Feet
Step 19: Desktop Version - Program
Step 20: Desktop Version - PHP
Step 21: Props
I totally tried to bite radiorental's style and use an analog gauge like his really cool analog network meter instructable.
I purchased a neat looking gauge off of ebay but it required more amps than the stamp could deliver so I grabbed the LCD and think it worked out ok. You can see the analog prototype below.
Thanks for looking at this.