Re: Experimenting with Google Charts and Graphs API.
Posted: Wed 11 Apr 2012 7:03 pm
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!
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
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)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