[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