The Hacker’s Diet with OpenOffice.org
I designed these weight loss spreadsheets so that I could follow John Walker’s Hacker’s Diet using the free OpenOffice.org.
Weight Tracker ODS
My own spreadsheet to monitor daily weight change.
Features:
- Records daily weigh-ins
- Performs exponential smoothing to filter out daily variation
- Calculates weight loss per day/week/month/year
- Calculates how many Calories you’ve over/undereaten
- Calculates your Body Mass Index or “BMI”
- Forecasts when you’ll achieve your target weight
- Graphs your progress
Update 01/18/10: Version 2.2.1 of WTODS is out! Read the change log, or visit the Weight Tracker ODS site at Launchpad for more information.
Download Weight Tracker ODS v2.2.1 [100k ZIP]
OpenOffice.org Computer Tools
My conversion of John Walker’s Excel Computer Tools into the OpenDocument standard. Includes everything except for the weight tracker and meal planner.
Download OpenOffice.org Computer Tools [310k ZIP]
22 Responses
leave one →
Trackbacks & Pingbacks
- Resuming development on Weight Tracker 2, now Weight Tracker ODS « Jon Thysell
- Weight Tracker ODS progressing well for the New Year « Jon Thysell
- Weight Tracker ODS 2.2.1 Released « Jon Thysell
- The Hacker’s Diet and related tools « Food Near Snellville
- Wendys, Steak ‘n Shake, Alons, lagging indicators and more. « Food Near Snellville
- How I lost 30 lbs. « Computers, and other annoyances
Thank you for this!
I’ve been hoping to find something tht would do this for OpenOffice, and I just found this today. (Using the new 3.1.1)
So far I really like it. The Charts button seems greyed out but I’m hoping as I add more data it will eventually activate.
Thanks again!
The current version appears to start and stop in 2008. Is there a method I’m too dim to see to make this applicable to 2009 -2010, please? I’m new to Open Office (and Excel, for that matter) and don’t want to mess around with cells that are no doubt protected for very good reasons.
Posted my dumb question too soon. I started pushing buttons on the main tab and found where one can add years. Will read the directions first next time.
Awesome. Thank you!
Linked here from the Hacker’s Diet team at Spark People.
Thank you for working this up! However, I cannot get past Feb 2009. There appears to be a formula error on what would be Feb29 and every month thereafter has a #name error where the date would be.
I am currently looking into that. For some reason the hidden “Total” sheet is not refreshing properly. When I delete and re-enter the formula, it works fine.
Hopefully the next version will address this.
Hi,
I’ve been entering data in this spreadsheet for 2 weeks and have been trying to figure out why the delta change per week doesn’t coincide with what I’ve entered. It seems the delta change per week is based over the whole month even if you’ve only entered a few days of data. Wouldn’t it make more sense to base it over the time period entered instead?
This is a bug in the current version that will be fixed in the next release.
Hi, thanks for the update. delta loss per week is good now. There is a tiny bug in the chart in that it specifies the unit as “lbs” even it’s configured for metric.
Cheers
Thanks! I’ve opened a bug targeted at the next version.
Bug #510146: Chart shows lbs. even when set to metric
Not a bug, but the chart weight axis origin is zero. It would look better I think if the weight started at goal weight or current weight – 10% or something.
I adjusted the Y axis by unprotecting the sheet, right-clicking the chart, selecting Edit, and then going to Format / Axis / Y-Axis. On the Scale tab, I unchecked Automatic beside the Minimum box, and entered the value I wanted (e.g. my goal weight – 10).
Having it be a configuration variable (e.g. your goal weight, as mentioned), or calculated to something that doesn’t leave your data a narrow, fuzzy squiggle on the screen would be good, however.
Yes, it’s a good idea and there’s defintely room for improvement for the chart. I released it as-is because I needed a new version out the door while I had the time to work on it.
It’s definitely something I’ll look into for the next release.
I’ve opened a bug so that I don’t forget to address this in the next release:
Bug #526500: Chart y-axis range too large to be useful
Have you seen the withings wifi weighing scale? I got one last week and can now update a spreadsheet automatically with weight and BIA readings. Though I don’t know what the formula is to turn those into body fat readings.
I’ve been using an older version that didn’t graph, and didn’t total until the end of the month. V 2.2.1 RULES. Many thanks. I’ve hit my goal, and this program (along with, of course, exercise & changing my eating habits) was a major part of it; when people ask how I lost 30 lbs., I say the first thing to do is weigh yourself every day, and I point to the Hacker’s Diet and this program. Many thanks.