EcoRenovator  

Go Back   EcoRenovator > Improvements > Tools
Advanced Search
 


Blog 60+ Home Energy Saving Tips Recent Posts Search Today's Posts Mark Forums Read


Reply
 
Thread Tools Display Modes
Old 03-23-11, 08:19 AM   #1
Piwoslaw
Super Moderator
 
Piwoslaw's Avatar
 
Join Date: May 2009
Location: Warsaw, Poland
Posts: 960
Thanks: 188
Thanked 110 Times in 86 Posts
Default Spreadsheets for tracking data

What spreadsheets do you use to track data on your home computer? How would you rate them?

I use an old version of Open Office (on an even older version of Linux, Fedora 6). It has more options than I need (basic math plus graphs), so I haven't thought about upgrading it, but there is one shortcoming: when plotting, say energy usage, with the date on the horizontal axis, all the entries on that axis are evenly spaced, i.e. the distance between any two sequential date entries is the same, no matter if the difference between those entries is 1 day or 2 months. What I'd like is the horizontal entries to be spaced proportionally to the dates they represent. Is there an option in Open Office that would allow this? Or any other program?

__________________
Ecorenovation - the bottomless piggy bank that tries to tame the energy hog.
Piwoslaw is offline   Reply With Quote
Old 03-23-11, 12:16 PM   #2
strider3700
Master EcoRenovator
 
Join Date: Dec 2008
Location: Vancouver Island BC
Posts: 745
Thanks: 23
Thanked 37 Times in 30 Posts
Default

I use open office for my minute by minute readings of energy use and google docs for my daily and monthly. When I take the time to get the programming done to automatically fill the spreadsheet I'll be using google docs for everything.

It has a graph that will spread thigns out by date and lots of cool zooming options.

here is my over a month behind filling it out (hence the automation programming needed) hotwater usage spreadsheet as an example.

https://spreadsheets.google.com/ccc?...thkey=CKSwgdgK

Also here's my whole house electric usage broken down with a bunch of info I work out
https://spreadsheets.google.com/ccc?...thkey=CJC147YI

I'm very happy with google docs. I'm at work at the moment but 100% of my data is there easy to access and trivial to share.

Last edited by strider3700; 03-23-11 at 01:18 PM..
strider3700 is offline   Reply With Quote
Old 03-23-11, 08:32 PM   #3
AC_Hacker
Supreme EcoRenovator
 
AC_Hacker's Avatar
 
Join Date: Mar 2009
Location: Portland, OR
Posts: 4,004
Thanks: 303
Thanked 723 Times in 534 Posts
Default Spreadsheet - Gnumeric...

I'm using Gnumeric, because it's small & free. It acts a lot like Excel, but for now it's getting the job done. The graphics are fair.

I've used MS Excel before and I like it, the graphics are better than Gnumeric, but I still have trouble displaying data the way I would like. The graphics are kind of semi-automatic and there are places where I would like to be able to tweak, I can't. I don't know if it's a limitation of the program or the user.

I keep think that there is something out there that would give me awsome control, and still be open source, but I haven't found it yet.

-AC_Hacker

__________________
I'm not an HVAC technician. In fact, I'm barely even a hacker...

Last edited by AC_Hacker; 03-23-11 at 08:40 PM..
AC_Hacker is offline   Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -5. The time now is 01:08 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Ad Management by RedTyger
Inactive Reminders By Icora Web Design