Page 3 of 3

Re: Experimenting with Google Charts and Graphs API.

Posted: Wed 11 Apr 2012 7:03 pm
by lardconcepts
In case anyone's interested, I cracked the problem of Nitrx's spreadsheet not expanding.

It's a hideous formula, and there's GOT to be a better/neater way, but... it seems to work!

Code: Select all

=ArrayFormula('Raw import'!A:A&","&'Raw import'!B:B&","&'Raw import'!C:C&","&'Raw import'!D:D&","&'Raw import'!E:E&","&'Raw import'!F:F&","&'Raw import'!G:G&","&'Raw import'!H:H&","&'Raw import'!I:I&","&'Raw import'!J:J&","&'Raw import'!K:K&","&'Raw import'!L:L&","&'Raw import'!M:M&","&'Raw import'!N:N&","&'Raw import'!O:O&","&'Raw import'!P:P&","&'Raw import'!Q:Q&","&'Raw import'!R:R&","&'Raw import'!S:S&","&'Raw import'!T:T&","&'Raw import'!U:U&","&'Raw import'!V:V)
https://docs.google.com/spreadsheet/ccc ... FBXMHFKemc

Oh, and I had to change the spreadsheet settings for "French", to make the graph work again, what with the commas vs semicolon thing.

I think beteljuice's php script is the way forward, at least for those that can use php on their server.
If not, feel free to copy that spreadsheet above and put your own dayfile.txt location in A1 of Raw Import and watch the magic happen :)

Re: Experimenting with Google Charts and Graphs API.

Posted: Mon 16 Apr 2012 4:21 pm
by lardconcepts
Update - just found Google Fusion Tables and it's WAY better for lots of data like in the monthly files.
I've got data collection on every 5 mins, so loads of data (about 8,000 rows a month).
But - swings and roundabouts - you currently can't import data like you can with spreadsheets (they're working on it though).
On the other hand, you can't have more than 400,000 cells in a Google Spreadsheet, but fusion tables are only limited by size; about 100Mb.

So, how about this: Here's temperatures from November to March, at 5 minute resolution.
Starting at average, click a point or roll the mouse or select an area and you can zoom right in and in and in until you can see every single data point.

http://weather.talking-news.info/ggraph ... sdemo.html
That graph took me two minutes to put together: Make graph, select columns, click "copy embed code".

The only thing I had to do was reformat and merge the date/time columns. Not ideal but I'm working on a workaround...

And the graph seems to load far quicker too. I think a combination of Fusion Tables for the big monthly files and Google Spreadsheets for the live import of Dayfiles is going to be the way forward. Right, back to the grindstone...

Re: Experimenting with Google Charts and Graphs API.

Posted: Mon 16 Apr 2012 10:47 pm
by beteljuice
:clap: Looks very interesting