[OpenTRV-dev] google spreadsheet

[Bo Herrmannsen]

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____(   )________|
                 (   )    ) /
                  \ (    (_/
                   \_)
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opentrv.org.uk/pipermail/opentrv-dev/attachments/20140906/dd1ad091/attachment-0001.html>