[OpenTRV-dev] google spreadsheet

[Bo Herrmannsen]

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