<div dir="ltr">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.<br></div><div class="gmail_extra"><br><div class="gmail_quote">On 6 September 2014 12:59, Bo Herrmannsen <span dir="ltr"><<a href="mailto:bo.herrmannsen@gmail.com" target="_blank">bo.herrmannsen@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">yeah... i'm planning to start logging it on EmonCms<div><br></div><div>but i just wanted to show off a bit and thought there was an easy way to graph each figure</div></div><div class="HOEnZb"><div class="h5"><div class="gmail_extra"><br><br><div class="gmail_quote">2014-09-06 13:55 GMT+02:00 Stuart Poulton <span dir="ltr"><<a href="mailto:stuart@poulton.org.uk" target="_blank">stuart@poulton.org.uk</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div style="word-wrap:break-word">Ok,<div><br></div><div>Probably easier to get the arduino to output something more friendly to parse with code ?</div><div><br></div><div>Cheers</div><div><br></div><div>Stuart</div><div><br><div><div>On 6 Sep 2014, at 12:36, Bo Herrmannsen <<a href="mailto:bo.herrmannsen@gmail.com" target="_blank">bo.herrmannsen@gmail.com</a>> wrote:</div><br><blockquote type="cite"><div dir="ltr">from serial output of arduino ide..<div><br></div><div><br></div></div><div class="gmail_extra"><br><br><div class="gmail_quote">2014-09-06 13:35 GMT+02:00 Stuart Poulton <span dir="ltr"><<a href="mailto:stuart@poulton.org.uk" target="_blank">stuart@poulton.org.uk</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div style="word-wrap:break-word">Bo,<div><br></div><div>Where’s the data coming from ? Wouldn’t it be easier to output a CSV, or even better, pump it into a database ?</div><div><br></div><div>Stuart</div><div><br></div><div><br><div><div>On 6 Sep 2014, at 12:22, Bo Herrmannsen <<a href="mailto:bo.herrmannsen@gmail.com" target="_blank">bo.herrmannsen@gmail.com</a>> wrote:</div><br><blockquote type="cite"><div dir="ltr">hehe<div><br></div><div>i figured it, in denmark we use , as decimal seperator where as in most english speaking countries . is used... i'm now on track</div><div><br></div><div>just need to take every X row and put them on the first line...</div><div><br></div><div><a href="https://docs.google.com/spreadsheets/d/16nr3SxuExRpgibBxnyjHKFIuhiaFgm9xU9s2EY3ODB8/edit?usp=sharing" target="_blank">https://docs.google.com/spreadsheets/d/16nr3SxuExRpgibBxnyjHKFIuhiaFgm9xU9s2EY3ODB8/edit?usp=sharing</a><br></div><div><br></div><div>ie first line is total energy... 6-7 lines down the same comes again... now i want the first line to look like</div><div><br><table dir="ltr" style="table-layout:fixed;font-size:13px;font-family:arial,sans,sans-serif;border-collapse:collapse;border:1px solid rgb(204,204,204)" border="1" cellpadding="0" cellspacing="0"><colgroup><col width="100"><col width="100"><col width="100"><col width="257"><col width="100"></colgroup><tbody><tr style="height:21px"><td style="padding:2px 3px;vertical-align:bottom">Energy</td><td style="padding:2px 3px;vertical-align:bottom;text-align:right">102,47</td><td style="padding:2px 3px;vertical-align:bottom;text-align:right">102,47</td><td style="padding:2px 3px;vertical-align:bottom;text-align:right">102,47</td><td style="padding:2px 3px;vertical-align:bottom;text-align:right">102,47</td></tr></tbody></table><br></div><div>is there a tool for that?</div></div><div class="gmail_extra"><br><br><div class="gmail_quote">2014-09-06 13:10 GMT+02:00 Stuart Poulton <span dir="ltr"><<a href="mailto:stuart@poulton.org.uk" target="_blank">stuart@poulton.org.uk</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div style="word-wrap:break-word"><div>Not quite sure what you’re doing but works fine here.</div><div><br></div><div><span><Screen Shot 2014-09-06 at 12.10.05.png></span></div><div><br></div><div>Stuart</div><br><div><div>On 6 Sep 2014, at 11:27, Bo Herrmannsen <<a href="mailto:bo.herrmannsen@gmail.com" target="_blank">bo.herrmannsen@gmail.com</a>> wrote:</div><br><blockquote type="cite"><div style="font-family:Helvetica;font-size:12px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px"><div dir="ltr">seems it does not simply split but also adds the delimiter to the result<div><br></div><div><span style="font-family:arial,sans,sans-serif;font-size:13px;white-space:pre-wrap">102:47:00.000</span><br></div><div><span style="font-family:arial,sans,sans-serif;font-size:13px;white-space:pre-wrap"><br></span></div><div><span style="font-family:arial,sans,sans-serif;font-size:13px;white-space:pre-wrap">my initial thought is simple rude: WTF.... cant you just do as told.... )(/&%¤#¤</span></div></div><div class="gmail_extra"><br><br><div class="gmail_quote">2014-09-06 11:54 GMT+02:00 Bo Herrmannsen<span> </span><span dir="ltr"><<a href="mailto:bo.herrmannsen@gmail.com" target="_blank">bo.herrmannsen@gmail.com</a>></span>:<br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex"><div dir="ltr">So i got the serial output in to a spreadsheet...<div><br></div><div>want to split it up right so its more usefull</div><div><br></div><div>raw data: <span style="font-family:arial,sans,sans-serif;font-size:13px;white-space:pre-wrap">Energy: 102.47 </span></div><div><font face="arial, sans, sans-serif"><span style="white-space:pre-wrap"><br></span></font></div><div><font face="arial, sans, sans-serif"><span style="white-space:pre-wrap"><br></span></font></div><div><font face="arial, sans, sans-serif"><span style="white-space:pre-wrap">formula: </span></font><span dir="auto" style="font-family:Inconsolata,monospace,arial,sans,sans-serif;font-size:13px;white-space:pre-wrap">=</span><span dir="auto" style="font-family:Inconsolata,monospace,arial,sans,sans-serif;font-size:13px;white-space:pre-wrap">split</span><span dir="auto" style="font-weight:bold;font-family:Inconsolata,monospace,arial,sans,sans-serif;font-size:13px;white-space:pre-wrap;background-color:rgb(229,229,229)">(</span><span dir="auto" style="font-family:Inconsolata,monospace,arial,sans,sans-serif;font-size:13px;white-space:pre-wrap;color:rgb(247,152,29)">A1</span><span dir="auto" style="font-family:Inconsolata,monospace,arial,sans,sans-serif;font-size:13px;white-space:pre-wrap">;</span><span dir="auto" style="font-family:Inconsolata,monospace,arial,sans,sans-serif;font-size:13px;white-space:pre-wrap"> </span><span dir="auto" style="color:green;font-family:Inconsolata,monospace,arial,sans,sans-serif;font-size:13px;white-space:pre-wrap">":"</span><span dir="auto" style="font-family:Inconsolata,monospace,arial,sans,sans-serif;font-size:13px;white-space:pre-wrap">;</span><span dir="auto" style="font-family:Inconsolata,monospace,arial,sans,sans-serif;font-size:13px;white-space:pre-wrap"> </span><span dir="auto" style="color:rgb(17,85,204);font-family:Inconsolata,monospace,arial,sans,sans-serif;font-size:13px;white-space:pre-wrap">False</span><span dir="auto" style="font-weight:bold;font-family:Inconsolata,monospace,arial,sans,sans-serif;font-size:13px;white-space:pre-wrap;background-color:rgb(229,229,229)">)</span></div><div><font><span style="white-space:pre-wrap"><font face="Inconsolata, monospace, arial, sans, sans-serif"><b><br></b></font></span></font></div><div><font><span style="white-space:pre-wrap"><font face="Inconsolata, monospace, arial, sans, sans-serif"><b>result: </b></font></span></font><span style="color:rgb(119,119,119);font-family:arial,sans,sans-serif;font-size:12px;text-align:right">102.47.00</span></div><div><font><span style="white-space:pre-wrap"><span style="font-family:Inconsolata,monospace,arial,sans,sans-serif"><font face="arial, sans, sans-serif"><br></font></span></span></font></div><div><font><span style="white-space:pre-wrap"><span style="font-family:Inconsolata,monospace,arial,sans,sans-serif"><font face="arial, sans, sans-serif">have tried to set the format of the result cell to automatic, text, numbers....</font></span></span></font></div><div><font><span style="white-space:pre-wrap"><span style="font-family:Inconsolata,monospace,arial,sans,sans-serif"><font face="arial, sans, sans-serif"><br></font></span></span></font></div><div><font><span style="white-space:pre-wrap"><span style="font-family:Inconsolata,monospace,arial,sans,sans-serif"><font face="arial, sans, sans-serif">no matter what it added .00 </font></span></span></font></div><div><font><span style="white-space:pre-wrap"><span style="font-family:Inconsolata,monospace,arial,sans,sans-serif"><font face="arial, sans, sans-serif"><br></font></span></span></font></div><div><font><span style="white-space:pre-wrap"><span style="font-family:Inconsolata,monospace,arial,sans,sans-serif"><font face="arial, sans, sans-serif">what am i doing wrong?<br clear="all"></font></span></span></font><div><br></div>--<span> </span><br><div dir="ltr"><pre><pre><span style="white-space:pre-wrap"> |||||
@(~Ô^Ô~)@
-------------oOo---U---oOo-------------
| |
| Bo Herrmannsen |
| |
| |
| "blessed are the "cracked", |
| for its they who let in the light" |
| Ooo |
|_________________ooO____( )________|
( ) ) /
\ ( (_/
\_)
</span></pre></pre><pre style="white-space:pre-wrap"><br></pre></div></div></div></blockquote></div><br><br clear="all"><div><br></div>--<span> </span><br><div dir="ltr"><pre><pre><span style="white-space:pre-wrap"> |||||
@(~Ô^Ô~)@
-------------oOo---U---oOo-------------
| |
| Bo Herrmannsen |
| |
| |
| "blessed are the "cracked", |
| for its they who let in the light" |
| Ooo |
|_________________ooO____( )________|
( ) ) /
\ ( (_/
\_)
</span></pre></pre><pre style="white-space:pre-wrap"><br></pre></div></div>_______________________________________________<br>OpenTRV-dev mailing list<br><a href="mailto:OpenTRV-dev@lists.opentrv.org.uk" target="_blank">OpenTRV-dev@lists.opentrv.org.uk</a><br><a href="http://lists.opentrv.org.uk/listinfo/opentrv-dev" target="_blank">http://lists.opentrv.org.uk/listinfo/opentrv-dev</a></div></blockquote></div><br></div><br>_______________________________________________<br>
OpenTRV-dev mailing list<br>
<a href="mailto:OpenTRV-dev@lists.opentrv.org.uk" target="_blank">OpenTRV-dev@lists.opentrv.org.uk</a><br>
<a href="http://lists.opentrv.org.uk/listinfo/opentrv-dev" target="_blank">http://lists.opentrv.org.uk/listinfo/opentrv-dev</a><br>
<br></blockquote></div><br><br clear="all"><div><br></div>-- <br><div dir="ltr"><pre><pre><span style="white-space:pre-wrap"> |||||
@(~Ô^Ô~)@
-------------oOo---U---oOo-------------
| |
| Bo Herrmannsen |
| |
| |
| "blessed are the "cracked", |
| for its they who let in the light" |
| Ooo |
|_________________ooO____( )________|
( ) ) /
\ ( (_/
\_)
</span></pre></pre><pre style="white-space:pre-wrap"><br></pre></div>
</div>
_______________________________________________<br>OpenTRV-dev mailing list<br><a href="mailto:OpenTRV-dev@lists.opentrv.org.uk" target="_blank">OpenTRV-dev@lists.opentrv.org.uk</a><br><a href="http://lists.opentrv.org.uk/listinfo/opentrv-dev" target="_blank">http://lists.opentrv.org.uk/listinfo/opentrv-dev</a><br></blockquote></div><br></div></div><br>_______________________________________________<br>
OpenTRV-dev mailing list<br>
<a href="mailto:OpenTRV-dev@lists.opentrv.org.uk" target="_blank">OpenTRV-dev@lists.opentrv.org.uk</a><br>
<a href="http://lists.opentrv.org.uk/listinfo/opentrv-dev" target="_blank">http://lists.opentrv.org.uk/listinfo/opentrv-dev</a><br>
<br></blockquote></div><br><br clear="all"><div><br></div>-- <br><div dir="ltr"><pre><pre><span style="white-space:pre-wrap"> |||||
@(~Ô^Ô~)@
-------------oOo---U---oOo-------------
| |
| Bo Herrmannsen |
| |
| |
| "blessed are the "cracked", |
| for its they who let in the light" |
| Ooo |
|_________________ooO____( )________|
( ) ) /
\ ( (_/
\_)
</span></pre></pre><pre style="white-space:pre-wrap"><br></pre></div>
</div>
_______________________________________________<br>OpenTRV-dev mailing list<br><a href="mailto:OpenTRV-dev@lists.opentrv.org.uk" target="_blank">OpenTRV-dev@lists.opentrv.org.uk</a><br><a href="http://lists.opentrv.org.uk/listinfo/opentrv-dev" target="_blank">http://lists.opentrv.org.uk/listinfo/opentrv-dev</a><br></blockquote></div><br></div></div><br>_______________________________________________<br>
OpenTRV-dev mailing list<br>
<a href="mailto:OpenTRV-dev@lists.opentrv.org.uk" target="_blank">OpenTRV-dev@lists.opentrv.org.uk</a><br>
<a href="http://lists.opentrv.org.uk/listinfo/opentrv-dev" target="_blank">http://lists.opentrv.org.uk/listinfo/opentrv-dev</a><br>
<br></blockquote></div><br><br clear="all"><div><br></div>-- <br><div dir="ltr"><pre><pre><span style="white-space:pre-wrap"> |||||
@(~Ô^Ô~)@
-------------oOo---U---oOo-------------
| |
| Bo Herrmannsen |
| |
| |
| "blessed are the "cracked", |
| for its they who let in the light" |
| Ooo |
|_________________ooO____( )________|
( ) ) /
\ ( (_/
\_)
</span></pre></pre><pre style="white-space:pre-wrap"><br></pre></div>
</div>
</div></div><br>_______________________________________________<br>
OpenTRV-dev mailing list<br>
<a href="mailto:OpenTRV-dev@lists.opentrv.org.uk">OpenTRV-dev@lists.opentrv.org.uk</a><br>
<a href="http://lists.opentrv.org.uk/listinfo/opentrv-dev" target="_blank">http://lists.opentrv.org.uk/listinfo/opentrv-dev</a><br>
<br></blockquote></div><br></div>