<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body>
<p>
<div>
<b><a class="bz_bug_link
bz_status_NEEDINFO "
title="NEEDINFO - importing/inserting data from a file into the current sheet EDITING, FILEOPEN"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=133677#c3">Comment # 3</a>
on <a class="bz_bug_link
bz_status_NEEDINFO "
title="NEEDINFO - importing/inserting data from a file into the current sheet EDITING, FILEOPEN"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=133677">bug 133677</a>
from <span class="vcard"><a class="email" href="mailto:bugzilla@greggferry.com" title="OldSurferDude <bugzilla@greggferry.com>"> <span class="fn">OldSurferDude</span></a>
</span></b>
<pre>Created <span class=""><a href="http://bugs.documentfoundation.org/attachment.cgi?id=161623" name="attach_161623" title="CALC file used to analyze data file">attachment 161623</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=161623&action=edit" title="CALC file used to analyze data file">[details]</a></span>
CALC file used to analyze data file
With this spread sheet I can determine the length of time a sensor is on or
off.
To get the data into the spreadsheet:
1. open up data in a text document
2. select all and copy date.
3. in the CALC document, move to cell A1
4. paste
5. change the first column type to Date(YMD)
6. OK
7. sort the five columns by location(C), sensor(D), time(B)
8. go to the first entry in seconds on(F) column
9. Select that entry and the one in secondsoff(G)
10. Copy
11. Select all the cells in (F) that have data data location 1, and sensor 2
12. paste
the pasted cells now show how many seconds the sensor was on in column (F) and
hours off in column (G)</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>