12-29-13, 12:37 PM | #1 |
Apprentice EcoRenovator
Join Date: Mar 2013
Location: UK
Posts: 131
Thanks: 13
Thanked 35 Times in 32 Posts
|
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 |
12-30-13, 12:33 PM | #2 |
Apprentice EcoRenovator
Join Date: Mar 2013
Location: UK
Posts: 131
Thanks: 13
Thanked 35 Times in 32 Posts
|
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 Any other suggestions?? |
12-30-13, 11:06 PM | #3 |
Apprentice EcoRenovator
Join Date: Apr 2011
Location: PNW
Posts: 197
Thanks: 0
Thanked 47 Times in 31 Posts
|
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. |
12-30-13, 11:08 PM | #4 |
Supreme EcoRenovator
Join Date: Oct 2008
Location: Austin, TX
Posts: 1,154
Thanks: 14
Thanked 257 Times in 241 Posts
|
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... |
12-31-13, 06:12 AM | #5 |
Apprentice EcoRenovator
Join Date: Mar 2013
Location: UK
Posts: 131
Thanks: 13
Thanked 35 Times in 32 Posts
|
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 |
|
|