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 12-29-13, 01:37 PM   #1
Ormston
Apprentice EcoRenovator
 
Join Date: Mar 2013
Location: UK
Posts: 131
Thanks: 13
Thanked 35 Times in 32 Posts
Default Any suggestions for graph/chart software?

Has anyone found a good graph plotting software, something that accepts .CSV files and plots them with the ability to zoom in and out to look at parts of the graph more precisely.

Thanks Steve

Ormston is offline   Reply With Quote
Old 12-30-13, 01:33 PM   #2
Ormston
Apprentice EcoRenovator
 
Join Date: Mar 2013
Location: UK
Posts: 131
Thanks: 13
Thanked 35 Times in 32 Posts
Default

Downloaded a installed and un-installed a load of programs trying to find something suitable, finally found DBPlot.

It mostly does what i need although it is not the most obvious user interface and there appears to be no help or tutorials.

DBPlot (Database and CSV Plot) | Free Development software downloads at SourceForge.net

Click image for larger version

Name:	DBPlot.jpg
Views:	878
Size:	294.0 KB
ID:	3818

Any other suggestions??
Ormston is offline   Reply With Quote
Old 12-31-13, 12:06 AM   #3
mejunkhound
Apprentice EcoRenovator
 
Join Date: Apr 2011
Location: PNW
Posts: 196
Thanks: 0
Thanked 47 Times in 31 Posts
Default

parse your csv data into any common spreadsheet (aka excel) and you can do about anything with the data.

I've taken voltage and current csv files from a scope plot, put into excel, and generate hysterysis curves.

You can even make up equations to match your data, etc..
Too much to give a tutorial here, find an online guide for spreadsheet operations.
mejunkhound is offline   Reply With Quote
Old 12-31-13, 12:08 AM   #4
NiHaoMike
Supreme EcoRenovator
 
NiHaoMike's Avatar
 
Join Date: Oct 2008
Location: Austin, TX
Posts: 1,125
Thanks: 15
Thanked 245 Times in 231 Posts
Default

I use Libreoffice. There's also Python (requires programming experience) and Octave.
__________________
To my surprise, shortly after Naomi Wu gave me a bit of fame for making good use of solar power, Allie Moore got really jealous of her...
NiHaoMike is offline   Reply With Quote
Old 12-31-13, 07:12 AM   #5
Ormston
Apprentice EcoRenovator
 
Join Date: Mar 2013
Location: UK
Posts: 131
Thanks: 13
Thanked 35 Times in 32 Posts
Default

Thanks guys
i've been using Libreoffice and still use it to add column headers and remove/adjust rogue data from my CSV files however for visualising it's not great.
The ability to zoom in on a day or hour of data then be able to scroll forward and backwards in time is so useful when you have a long term datalog(or high speed logging).
I know it should be possible to create this functuality in a spreadsheet, but the time involved and having to modify it every time i add new sensors to the system is not worth it.

I'm currently implementing the control system for my ASHP to under floor heating and hot water tank.
Without the datalogging i would never have spotted several issues effecting efficiency and possibly destroying the heat pump.

Thanks for the suggestions
Steve

Ormston 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:59 AM.


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