[OpenTRV-dev] google spreadsheet
Bo Herrmannsen
EMAIL ADDRESS HIDDEN
Tue Sep 9 20:42:27 BST 2014
hehe... i figured it in the end... i just replaced all comma with dots...
but just order a huge box of goodies from OEM so i can start monitoring
everything in the utility closet
data from the rad's will follow as soon we figure how
2014-09-09 21:38 GMT+02:00 Bruno Girin <EMAIL ADDRESS HIDDEN>:
> Google Spreadsheet is a nightmare to use for data collection when you're
> not American. It doesn't understand 24 hour times properly to start with.
>
> On 6 September 2014 12:59, Bo Herrmannsen <EMAIL ADDRESS HIDDEN>
> wrote:
>
>> 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____( )________|
>> ( ) ) /
>> \ ( (_/
>> \_)
>>
>>
>>
>>
>> _______________________________________________
>> 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/20140909/9e7c0d42/attachment-0001.html>
More information about the OpenTRV-dev
mailing list