[OpenTRV-dev] google spreadsheet

Stuart Poulton EMAIL ADDRESS HIDDEN
Sat Sep 6 12:35:57 BST 2014


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
> 
> Energy	102,47	102,47	102,47	102,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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opentrv.org.uk/pipermail/opentrv-dev/attachments/20140906/93300e52/attachment.html>


More information about the OpenTRV-dev mailing list