![]() |
![]() |
#1 |
Super Moderator
Join Date: May 2009
Location: Warsaw, Poland
Posts: 964
Thanks: 189
Thanked 110 Times in 86 Posts
|
![]() 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. |
![]() |
![]() |
![]() |
#2 |
Master EcoRenovator
Join Date: Dec 2008
Location: Vancouver Island BC
Posts: 745
Thanks: 23
Thanked 37 Times in 30 Posts
|
![]() 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.. |
![]() |
![]() |
![]() |
#3 |
Supreme EcoRenovator
Join Date: Mar 2009
Location: Portland, OR
Posts: 4,004
Thanks: 303
Thanked 724 Times in 534 Posts
|
![]() 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.. |
![]() |
![]() |
![]() |
|
|