[OpenTRV-dev] google spreadsheet

[Bo Herrmannsen]

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.
>
>
> 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____(   )________|
                 (   )    ) /
                  \ (    (_/
                   \_)
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opentrv.org.uk/pipermail/opentrv-dev/attachments/20140906/eff5448b/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Screen Shot 2014-09-06 at 12.10.05.png
Type: image/png
Size: 27481 bytes
Desc: not available
URL: <http://lists.opentrv.org.uk/pipermail/opentrv-dev/attachments/20140906/eff5448b/attachment-0001.png>