[OpenTRV-dev] google spreadsheet
Bruno Girin
EMAIL ADDRESS HIDDEN
Tue Sep 9 20:38:21 BST 2014
Google Spreadsheet is a nightmare to use for data collection when you're
not American. It doesn't understand 24 hour times properly to start with.
On 6 September 2014 12:59, Bo Herrmannsen <EMAIL ADDRESS HIDDEN> wrote:
> yeah... i'm planning to start logging it on EmonCms
>
> but i just wanted to show off a bit and thought there was an easy way to
> graph each figure
>
>
> 2014-09-06 13:55 GMT+02:00 Stuart Poulton <EMAIL ADDRESS HIDDEN>:
>
>> Ok,
>>
>> Probably easier to get the arduino to output something more friendly to
>> parse with code ?
>>
>> Cheers
>>
>> Stuart
>>
>> On 6 Sep 2014, at 12:36, Bo Herrmannsen <EMAIL ADDRESS HIDDEN> wrote:
>>
>> from serial output of arduino ide..
>>
>>
>>
>>
>> 2014-09-06 13:35 GMT+02:00 Stuart Poulton <EMAIL ADDRESS HIDDEN>:
>>
>>> Bo,
>>>
>>> Where’s the data coming from ? Wouldn’t it be easier to output a CSV,
>>> or even better, pump it into a database ?
>>>
>>> Stuart
>>>
>>>
>>> On 6 Sep 2014, at 12:22, Bo Herrmannsen <EMAIL ADDRESS HIDDEN>
>>> wrote:
>>>
>>> hehe
>>>
>>> i figured it, in denmark we use , as decimal seperator where as in most
>>> english speaking countries . is used... i'm now on track
>>>
>>> just need to take every X row and put them on the first line...
>>>
>>>
>>> https://docs.google.com/spreadsheets/d/16nr3SxuExRpgibBxnyjHKFIuhiaFgm9xU9s2EY3ODB8/edit?usp=sharing
>>>
>>> ie first line is total energy... 6-7 lines down the same comes again...
>>> now i want the first line to look like
>>>
>>> Energy102,47102,47102,47102,47
>>> is there a tool for that?
>>>
>>>
>>> 2014-09-06 13:10 GMT+02:00 Stuart Poulton <EMAIL ADDRESS HIDDEN>:
>>>
>>>> Not quite sure what you’re doing but works fine here.
>>>>
>>>> <Screen Shot 2014-09-06 at 12.10.05.png>
>>>>
>>>> Stuart
>>>>
>>>> On 6 Sep 2014, at 11:27, Bo Herrmannsen <EMAIL ADDRESS HIDDEN>
>>>> wrote:
>>>>
>>>> seems it does not simply split but also adds the delimiter to the result
>>>>
>>>> 102:47:00.000
>>>>
>>>> my initial thought is simple rude: WTF.... cant you just do as told....
>>>> )(/&%¤#¤
>>>>
>>>>
>>>> 2014-09-06 11:54 GMT+02:00 Bo Herrmannsen <EMAIL ADDRESS HIDDEN>:
>>>>
>>>>> So i got the serial output in to a spreadsheet...
>>>>>
>>>>> want to split it up right so its more usefull
>>>>>
>>>>> raw data: Energy: 102.47
>>>>>
>>>>>
>>>>> formula: =split(A1; ":"; False)
>>>>>
>>>>> *result: *102.47.00
>>>>>
>>>>> have tried to set the format of the result cell to automatic, text,
>>>>> numbers....
>>>>>
>>>>> no matter what it added .00
>>>>>
>>>>> what am i doing wrong?
>>>>>
>>>>> --
>>>>>
>>>>> |||||
>>>>> @(~Ô^Ô~)@
>>>>> -------------oOo---U---oOo-------------
>>>>> | |
>>>>> | Bo Herrmannsen |
>>>>> | |
>>>>> | |
>>>>> | "blessed are the "cracked", |
>>>>> | for its they who let in the light" |
>>>>> | Ooo |
>>>>> |_________________ooO____( )________|
>>>>> ( ) ) /
>>>>> \ ( (_/
>>>>> \_)
>>>>>
>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>> --
>>>>
>>>> |||||
>>>> @(~Ô^Ô~)@
>>>> -------------oOo---U---oOo-------------
>>>> | |
>>>> | Bo Herrmannsen |
>>>> | |
>>>> | |
>>>> | "blessed are the "cracked", |
>>>> | for its they who let in the light" |
>>>> | Ooo |
>>>> |_________________ooO____( )________|
>>>> ( ) ) /
>>>> \ ( (_/
>>>> \_)
>>>>
>>>>
>>>>
>>>> _______________________________________________
>>>> OpenTRV-dev mailing list
>>>> EMAIL ADDRESS HIDDEN
>>>> http://lists.opentrv.org.uk/listinfo/opentrv-dev
>>>>
>>>>
>>>>
>>>> _______________________________________________
>>>> OpenTRV-dev mailing list
>>>> EMAIL ADDRESS HIDDEN
>>>> http://lists.opentrv.org.uk/listinfo/opentrv-dev
>>>>
>>>>
>>>
>>>
>>> --
>>>
>>> |||||
>>> @(~Ô^Ô~)@
>>> -------------oOo---U---oOo-------------
>>> | |
>>> | Bo Herrmannsen |
>>> | |
>>> | |
>>> | "blessed are the "cracked", |
>>> | for its they who let in the light" |
>>> | Ooo |
>>> |_________________ooO____( )________|
>>> ( ) ) /
>>> \ ( (_/
>>> \_)
>>>
>>>
>>>
>>> _______________________________________________
>>> OpenTRV-dev mailing list
>>> EMAIL ADDRESS HIDDEN
>>> http://lists.opentrv.org.uk/listinfo/opentrv-dev
>>>
>>>
>>>
>>> _______________________________________________
>>> OpenTRV-dev mailing list
>>> EMAIL ADDRESS HIDDEN
>>> http://lists.opentrv.org.uk/listinfo/opentrv-dev
>>>
>>>
>>
>>
>> --
>>
>> |||||
>> @(~Ô^Ô~)@
>> -------------oOo---U---oOo-------------
>> | |
>> | Bo Herrmannsen |
>> | |
>> | |
>> | "blessed are the "cracked", |
>> | for its they who let in the light" |
>> | Ooo |
>> |_________________ooO____( )________|
>> ( ) ) /
>> \ ( (_/
>> \_)
>>
>>
>>
>> _______________________________________________
>> OpenTRV-dev mailing list
>> EMAIL ADDRESS HIDDEN
>> http://lists.opentrv.org.uk/listinfo/opentrv-dev
>>
>>
>>
>> _______________________________________________
>> OpenTRV-dev mailing list
>> EMAIL ADDRESS HIDDEN
>> http://lists.opentrv.org.uk/listinfo/opentrv-dev
>>
>>
>
>
> --
>
> |||||
> @(~Ô^Ô~)@
> -------------oOo---U---oOo-------------
> | |
> | Bo Herrmannsen |
> | |
> | |
> | "blessed are the "cracked", |
> | for its they who let in the light" |
> | Ooo |
> |_________________ooO____( )________|
> ( ) ) /
> \ ( (_/
> \_)
>
>
>
>
> _______________________________________________
> OpenTRV-dev mailing list
> EMAIL ADDRESS HIDDEN
> http://lists.opentrv.org.uk/listinfo/opentrv-dev
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opentrv.org.uk/pipermail/opentrv-dev/attachments/20140909/1a7d2691/attachment.html>
More information about the OpenTRV-dev
mailing list