[OpenTRV-dev] google spreadsheet

[Stuart Poulton]

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
>> 
>> 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
> 
> 
> _______________________________________________
> 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/1d8402bf/attachment.html>