UK diy (uk.d-i-y) For the discussion of all topics related to diy (do-it-yourself) in the UK. All levels of experience and proficency are welcome to join in to ask questions or offer solutions.

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to uk.d-i-y
external usenet poster
 
Posts: 13,431
Default Spreadsheet type data manipulation?

Hi all,

I've recently bought one of the Lascar USB data capture units
(EL-USB-3 Volts):

https://www.lascarelectronics.com/ea...gger-el-usb-3/

... and just used it to monitor the discharge of a 26Ah gel battery
into a ~7A (incandescent lamp) load (down to 11V).

The output from the logger is a CSV .txt file and their simple viewer
autoscales the Y axis (Volts / 15) and just shows the X in real time
(presumably taken from the PC start time and the reading intervals?),
however I'd like to display and annotate a graph with shifted Y axis
(say 10-15V) and the X in minutes (or hrs / min but starting from
zero).

I'm sure this would be something pretty easy to do with a spreadsheet
or maybe there are graphing apps that would take this data and allow
the sort of manipulation mentioned above without having to deal with
formula etc?

As we are all of BB now and bandwidth isn't a problem, I'll insert one
such log here for anyone so inclined to play ... ;-)

Cheers, T i m

(You can discard the low alarm column, just playing with that and I
can trim the leading and trailing 0V readings in Notepad+. If you do
that though you lose the initial column / time counts and would need
to adjust for each graph manually?).

EasyLog USB,Time,Voltage(Volts),Low Alarm
1,2018-10-11 10:11:01,0.05,11.5
2,2018-10-11 10:11:11,0.05,11.5
3,2018-10-11 10:11:21,0.05,11.5
4,2018-10-11 10:11:31,0.00,11.5
5,2018-10-11 10:11:41,0.00,11.5
6,2018-10-11 10:11:51,0.00,11.5
7,2018-10-11 10:12:01,0.00,11.5
8,2018-10-11 10:12:11,0.00,11.5
9,2018-10-11 10:12:21,12.85,11.5
10,2018-10-11 10:12:31,12.85,11.5
11,2018-10-11 10:12:41,12.35,11.5
12,2018-10-11 10:12:51,12.25,11.5
13,2018-10-11 10:13:01,12.25,11.5
14,2018-10-11 10:13:11,12.25,11.5
15,2018-10-11 10:13:21,12.25,11.5
16,2018-10-11 10:13:31,12.25,11.5
17,2018-10-11 10:13:41,12.25,11.5
18,2018-10-11 10:13:51,12.25,11.5
19,2018-10-11 10:14:01,12.25,11.5
20,2018-10-11 10:14:11,12.25,11.5
21,2018-10-11 10:14:21,12.25,11.5
22,2018-10-11 10:14:31,12.30,11.5
23,2018-10-11 10:14:41,12.30,11.5
24,2018-10-11 10:14:51,12.30,11.5
25,2018-10-11 10:15:01,12.30,11.5
26,2018-10-11 10:15:11,12.30,11.5
27,2018-10-11 10:15:21,12.30,11.5
28,2018-10-11 10:15:31,12.30,11.5
29,2018-10-11 10:15:41,12.30,11.5
30,2018-10-11 10:15:51,12.30,11.5
31,2018-10-11 10:16:01,12.30,11.5
32,2018-10-11 10:16:11,12.30,11.5
33,2018-10-11 10:16:21,12.30,11.5
34,2018-10-11 10:16:31,12.30,11.5
35,2018-10-11 10:16:41,12.30,11.5
36,2018-10-11 10:16:51,12.30,11.5
37,2018-10-11 10:17:01,12.30,11.5
38,2018-10-11 10:17:11,12.30,11.5
39,2018-10-11 10:17:21,12.30,11.5
40,2018-10-11 10:17:31,12.30,11.5
41,2018-10-11 10:17:41,12.30,11.5
42,2018-10-11 10:17:51,12.30,11.5
43,2018-10-11 10:18:01,12.30,11.5
44,2018-10-11 10:18:11,12.30,11.5
45,2018-10-11 10:18:21,12.30,11.5
46,2018-10-11 10:18:31,12.30,11.5
47,2018-10-11 10:18:41,12.30,11.5
48,2018-10-11 10:18:51,12.30,11.5
49,2018-10-11 10:19:01,12.30,11.5
50,2018-10-11 10:19:11,12.30,11.5
51,2018-10-11 10:19:21,12.30,11.5
52,2018-10-11 10:19:31,12.30,11.5
53,2018-10-11 10:19:41,12.30,11.5
54,2018-10-11 10:19:51,12.30,11.5
55,2018-10-11 10:20:01,12.30,11.5
56,2018-10-11 10:20:11,12.30,11.5
57,2018-10-11 10:20:21,12.30,11.5
58,2018-10-11 10:20:31,12.30,11.5
59,2018-10-11 10:20:41,12.30,11.5
60,2018-10-11 10:20:51,12.30,11.5
61,2018-10-11 10:21:01,12.30,11.5
62,2018-10-11 10:21:11,12.30,11.5
63,2018-10-11 10:21:21,12.30,11.5
64,2018-10-11 10:21:31,12.30,11.5
65,2018-10-11 10:21:41,12.30,11.5
66,2018-10-11 10:21:51,12.30,11.5
67,2018-10-11 10:22:01,12.30,11.5
68,2018-10-11 10:22:11,12.30,11.5
69,2018-10-11 10:22:21,12.30,11.5
70,2018-10-11 10:22:31,12.30,11.5
71,2018-10-11 10:22:41,12.30,11.5
72,2018-10-11 10:22:51,12.30,11.5
73,2018-10-11 10:23:01,12.30,11.5
74,2018-10-11 10:23:11,12.30,11.5
75,2018-10-11 10:23:21,12.30,11.5
76,2018-10-11 10:23:31,12.30,11.5
77,2018-10-11 10:23:41,12.30,11.5
78,2018-10-11 10:23:51,12.30,11.5
79,2018-10-11 10:24:01,12.30,11.5
80,2018-10-11 10:24:11,12.30,11.5
81,2018-10-11 10:24:21,12.30,11.5
82,2018-10-11 10:24:31,12.30,11.5
83,2018-10-11 10:24:41,12.30,11.5
84,2018-10-11 10:24:51,12.30,11.5
85,2018-10-11 10:25:01,12.30,11.5
86,2018-10-11 10:25:11,12.30,11.5
87,2018-10-11 10:25:21,12.30,11.5
88,2018-10-11 10:25:31,12.30,11.5
89,2018-10-11 10:25:41,12.30,11.5
90,2018-10-11 10:25:51,12.30,11.5
91,2018-10-11 10:26:01,12.30,11.5
92,2018-10-11 10:26:11,12.30,11.5
93,2018-10-11 10:26:21,12.30,11.5
94,2018-10-11 10:26:31,12.30,11.5
95,2018-10-11 10:26:41,12.30,11.5
96,2018-10-11 10:26:51,12.30,11.5
97,2018-10-11 10:27:01,12.30,11.5
98,2018-10-11 10:27:11,12.30,11.5
99,2018-10-11 10:27:21,12.30,11.5
100,2018-10-11 10:27:31,12.25,11.5
101,2018-10-11 10:27:41,12.30,11.5
102,2018-10-11 10:27:51,12.30,11.5
103,2018-10-11 10:28:01,12.25,11.5
104,2018-10-11 10:28:11,12.25,11.5
105,2018-10-11 10:28:21,12.25,11.5
106,2018-10-11 10:28:31,12.25,11.5
107,2018-10-11 10:28:41,12.25,11.5
108,2018-10-11 10:28:51,12.25,11.5
109,2018-10-11 10:29:01,12.25,11.5
110,2018-10-11 10:29:11,12.25,11.5
111,2018-10-11 10:29:21,12.25,11.5
112,2018-10-11 10:29:31,12.25,11.5
113,2018-10-11 10:29:41,12.25,11.5
114,2018-10-11 10:29:51,12.25,11.5
115,2018-10-11 10:30:01,12.25,11.5
116,2018-10-11 10:30:11,12.25,11.5
117,2018-10-11 10:30:21,12.25,11.5
118,2018-10-11 10:30:31,12.25,11.5
119,2018-10-11 10:30:41,12.25,11.5
120,2018-10-11 10:30:51,12.25,11.5
121,2018-10-11 10:31:01,12.25,11.5
122,2018-10-11 10:31:11,12.25,11.5
123,2018-10-11 10:31:21,12.25,11.5
124,2018-10-11 10:31:31,12.25,11.5
125,2018-10-11 10:31:41,12.25,11.5
126,2018-10-11 10:31:51,12.25,11.5
127,2018-10-11 10:32:01,12.25,11.5
128,2018-10-11 10:32:11,12.25,11.5
129,2018-10-11 10:32:21,12.25,11.5
130,2018-10-11 10:32:31,12.25,11.5
131,2018-10-11 10:32:41,12.25,11.5
132,2018-10-11 10:32:51,12.25,11.5
133,2018-10-11 10:33:01,12.25,11.5
134,2018-10-11 10:33:11,12.25,11.5
135,2018-10-11 10:33:21,12.25,11.5
136,2018-10-11 10:33:31,12.25,11.5
137,2018-10-11 10:33:41,12.25,11.5
138,2018-10-11 10:33:51,12.25,11.5
139,2018-10-11 10:34:01,12.25,11.5
140,2018-10-11 10:34:11,12.25,11.5
141,2018-10-11 10:34:21,12.25,11.5
142,2018-10-11 10:34:31,12.25,11.5
143,2018-10-11 10:34:41,12.25,11.5
144,2018-10-11 10:34:51,12.25,11.5
145,2018-10-11 10:35:01,12.25,11.5
146,2018-10-11 10:35:11,12.25,11.5
147,2018-10-11 10:35:21,12.25,11.5
148,2018-10-11 10:35:31,12.25,11.5
149,2018-10-11 10:35:41,12.25,11.5
150,2018-10-11 10:35:51,12.25,11.5
151,2018-10-11 10:36:01,12.25,11.5
152,2018-10-11 10:36:11,12.25,11.5
153,2018-10-11 10:36:21,12.25,11.5
154,2018-10-11 10:36:31,12.25,11.5
155,2018-10-11 10:36:41,12.20,11.5
156,2018-10-11 10:36:51,12.25,11.5
157,2018-10-11 10:37:01,12.20,11.5
158,2018-10-11 10:37:11,12.25,11.5
159,2018-10-11 10:37:21,12.25,11.5
160,2018-10-11 10:37:31,12.20,11.5
161,2018-10-11 10:37:41,12.25,11.5
162,2018-10-11 10:37:51,12.20,11.5
163,2018-10-11 10:38:01,12.20,11.5
164,2018-10-11 10:38:11,12.20,11.5
165,2018-10-11 10:38:21,12.20,11.5
166,2018-10-11 10:38:31,12.20,11.5
167,2018-10-11 10:38:41,12.20,11.5
168,2018-10-11 10:38:51,12.20,11.5
169,2018-10-11 10:39:01,12.20,11.5
170,2018-10-11 10:39:11,12.20,11.5
171,2018-10-11 10:39:21,12.20,11.5
172,2018-10-11 10:39:31,12.20,11.5
173,2018-10-11 10:39:41,12.20,11.5
174,2018-10-11 10:39:51,12.20,11.5
175,2018-10-11 10:40:01,12.20,11.5
176,2018-10-11 10:40:11,12.20,11.5
177,2018-10-11 10:40:21,12.20,11.5
178,2018-10-11 10:40:31,12.20,11.5
179,2018-10-11 10:40:41,12.20,11.5
180,2018-10-11 10:40:51,12.20,11.5
181,2018-10-11 10:41:01,12.20,11.5
182,2018-10-11 10:41:11,12.20,11.5
183,2018-10-11 10:41:21,12.20,11.5
184,2018-10-11 10:41:31,12.20,11.5
185,2018-10-11 10:41:41,12.20,11.5
186,2018-10-11 10:41:51,12.20,11.5
187,2018-10-11 10:42:01,12.20,11.5
188,2018-10-11 10:42:11,12.20,11.5
189,2018-10-11 10:42:21,12.20,11.5
190,2018-10-11 10:42:31,12.20,11.5
191,2018-10-11 10:42:41,12.20,11.5
192,2018-10-11 10:42:51,12.20,11.5
193,2018-10-11 10:43:01,12.20,11.5
194,2018-10-11 10:43:11,12.20,11.5
195,2018-10-11 10:43:21,12.20,11.5
196,2018-10-11 10:43:31,12.20,11.5
197,2018-10-11 10:43:41,12.20,11.5
198,2018-10-11 10:43:51,12.20,11.5
199,2018-10-11 10:44:01,12.20,11.5
200,2018-10-11 10:44:11,12.20,11.5
201,2018-10-11 10:44:21,12.20,11.5
202,2018-10-11 10:44:31,12.20,11.5
203,2018-10-11 10:44:41,12.20,11.5
204,2018-10-11 10:44:51,12.20,11.5
205,2018-10-11 10:45:01,12.20,11.5
206,2018-10-11 10:45:11,12.20,11.5
207,2018-10-11 10:45:21,12.20,11.5
208,2018-10-11 10:45:31,12.20,11.5
209,2018-10-11 10:45:41,12.20,11.5
210,2018-10-11 10:45:51,12.15,11.5
211,2018-10-11 10:46:01,12.15,11.5
212,2018-10-11 10:46:11,12.15,11.5
213,2018-10-11 10:46:21,12.15,11.5
214,2018-10-11 10:46:31,12.15,11.5
215,2018-10-11 10:46:41,12.15,11.5
216,2018-10-11 10:46:51,12.15,11.5
217,2018-10-11 10:47:01,12.15,11.5
218,2018-10-11 10:47:11,12.15,11.5
219,2018-10-11 10:47:21,12.15,11.5
220,2018-10-11 10:47:31,12.15,11.5
221,2018-10-11 10:47:41,12.15,11.5
222,2018-10-11 10:47:51,12.15,11.5
223,2018-10-11 10:48:01,12.15,11.5
224,2018-10-11 10:48:11,12.15,11.5
225,2018-10-11 10:48:21,12.15,11.5
226,2018-10-11 10:48:31,12.15,11.5
227,2018-10-11 10:48:41,12.15,11.5
228,2018-10-11 10:48:51,12.15,11.5
229,2018-10-11 10:49:01,12.15,11.5
230,2018-10-11 10:49:11,12.15,11.5
231,2018-10-11 10:49:21,12.15,11.5
232,2018-10-11 10:49:31,12.15,11.5
233,2018-10-11 10:49:41,12.15,11.5
234,2018-10-11 10:49:51,12.15,11.5
235,2018-10-11 10:50:01,12.15,11.5
236,2018-10-11 10:50:11,12.15,11.5
237,2018-10-11 10:50:21,12.15,11.5
238,2018-10-11 10:50:31,12.15,11.5
239,2018-10-11 10:50:41,12.15,11.5
240,2018-10-11 10:50:51,12.15,11.5
241,2018-10-11 10:51:01,12.15,11.5
242,2018-10-11 10:51:11,12.15,11.5
243,2018-10-11 10:51:21,12.15,11.5
244,2018-10-11 10:51:31,12.15,11.5
245,2018-10-11 10:51:41,12.15,11.5
246,2018-10-11 10:51:51,12.15,11.5
247,2018-10-11 10:52:01,12.15,11.5
248,2018-10-11 10:52:11,12.15,11.5
249,2018-10-11 10:52:21,12.15,11.5
250,2018-10-11 10:52:31,12.15,11.5
251,2018-10-11 10:52:41,12.15,11.5
252,2018-10-11 10:52:51,12.15,11.5
253,2018-10-11 10:53:01,12.15,11.5
254,2018-10-11 10:53:11,12.15,11.5
255,2018-10-11 10:53:21,12.15,11.5
256,2018-10-11 10:53:31,12.15,11.5
257,2018-10-11 10:53:41,12.15,11.5
258,2018-10-11 10:53:51,12.10,11.5
259,2018-10-11 10:54:01,12.10,11.5
260,2018-10-11 10:54:11,12.10,11.5
261,2018-10-11 10:54:21,12.15,11.5
262,2018-10-11 10:54:31,12.10,11.5
263,2018-10-11 10:54:41,12.10,11.5
264,2018-10-11 10:54:51,12.10,11.5
265,2018-10-11 10:55:01,12.10,11.5
266,2018-10-11 10:55:11,12.10,11.5
267,2018-10-11 10:55:21,12.10,11.5
268,2018-10-11 10:55:31,12.10,11.5
269,2018-10-11 10:55:41,12.10,11.5
270,2018-10-11 10:55:51,12.10,11.5
271,2018-10-11 10:56:01,12.10,11.5
272,2018-10-11 10:56:11,12.10,11.5
273,2018-10-11 10:56:21,12.10,11.5
274,2018-10-11 10:56:31,12.10,11.5
275,2018-10-11 10:56:41,12.10,11.5
276,2018-10-11 10:56:51,12.10,11.5
277,2018-10-11 10:57:01,12.10,11.5
278,2018-10-11 10:57:11,12.10,11.5
279,2018-10-11 10:57:21,12.10,11.5
280,2018-10-11 10:57:31,12.10,11.5
281,2018-10-11 10:57:41,12.10,11.5
282,2018-10-11 10:57:51,12.10,11.5
283,2018-10-11 10:58:01,12.10,11.5
284,2018-10-11 10:58:11,12.10,11.5
285,2018-10-11 10:58:21,12.10,11.5
286,2018-10-11 10:58:31,12.10,11.5
287,2018-10-11 10:58:41,12.10,11.5
288,2018-10-11 10:58:51,12.10,11.5
289,2018-10-11 10:59:01,12.10,11.5
290,2018-10-11 10:59:11,12.10,11.5
291,2018-10-11 10:59:21,12.10,11.5
292,2018-10-11 10:59:31,12.10,11.5
293,2018-10-11 10:59:41,12.10,11.5
294,2018-10-11 10:59:51,12.10,11.5
295,2018-10-11 11:00:01,12.10,11.5
296,2018-10-11 11:00:11,12.10,11.5
297,2018-10-11 11:00:21,12.10,11.5
298,2018-10-11 11:00:31,12.10,11.5
299,2018-10-11 11:00:41,12.05,11.5
300,2018-10-11 11:00:51,12.05,11.5
301,2018-10-11 11:01:01,12.05,11.5
302,2018-10-11 11:01:11,12.05,11.5
303,2018-10-11 11:01:21,12.05,11.5
304,2018-10-11 11:01:31,12.05,11.5
305,2018-10-11 11:01:41,12.05,11.5
306,2018-10-11 11:01:51,12.05,11.5
307,2018-10-11 11:02:01,12.05,11.5
308,2018-10-11 11:02:11,12.05,11.5
309,2018-10-11 11:02:21,12.05,11.5
310,2018-10-11 11:02:31,12.05,11.5
311,2018-10-11 11:02:41,12.05,11.5
312,2018-10-11 11:02:51,12.05,11.5
313,2018-10-11 11:03:01,12.05,11.5
314,2018-10-11 11:03:11,12.05,11.5
315,2018-10-11 11:03:21,12.05,11.5
316,2018-10-11 11:03:31,12.05,11.5
317,2018-10-11 11:03:41,12.05,11.5
318,2018-10-11 11:03:51,12.05,11.5
319,2018-10-11 11:04:01,12.05,11.5
320,2018-10-11 11:04:11,12.05,11.5
321,2018-10-11 11:04:21,12.05,11.5
322,2018-10-11 11:04:31,12.05,11.5
323,2018-10-11 11:04:41,12.05,11.5
324,2018-10-11 11:04:51,12.05,11.5
325,2018-10-11 11:05:01,12.05,11.5
326,2018-10-11 11:05:11,12.05,11.5
327,2018-10-11 11:05:21,12.05,11.5
328,2018-10-11 11:05:31,12.05,11.5
329,2018-10-11 11:05:41,12.05,11.5
330,2018-10-11 11:05:51,12.05,11.5
331,2018-10-11 11:06:01,12.05,11.5
332,2018-10-11 11:06:11,12.05,11.5
333,2018-10-11 11:06:21,12.05,11.5
334,2018-10-11 11:06:31,12.05,11.5
335,2018-10-11 11:06:41,12.05,11.5
336,2018-10-11 11:06:51,12.05,11.5
337,2018-10-11 11:07:01,12.05,11.5
338,2018-10-11 11:07:11,12.00,11.5
339,2018-10-11 11:07:21,12.00,11.5
340,2018-10-11 11:07:31,12.00,11.5
341,2018-10-11 11:07:41,12.00,11.5
342,2018-10-11 11:07:51,12.00,11.5
343,2018-10-11 11:08:01,12.00,11.5
344,2018-10-11 11:08:11,12.00,11.5
345,2018-10-11 11:08:21,12.00,11.5
346,2018-10-11 11:08:31,12.00,11.5
347,2018-10-11 11:08:41,12.00,11.5
348,2018-10-11 11:08:51,12.00,11.5
349,2018-10-11 11:09:01,12.00,11.5
350,2018-10-11 11:09:11,12.00,11.5
351,2018-10-11 11:09:21,12.00,11.5
352,2018-10-11 11:09:31,12.00,11.5
353,2018-10-11 11:09:41,12.00,11.5
354,2018-10-11 11:09:51,12.00,11.5
355,2018-10-11 11:10:01,12.00,11.5
356,2018-10-11 11:10:11,12.00,11.5
357,2018-10-11 11:10:21,12.00,11.5
358,2018-10-11 11:10:31,12.00,11.5
359,2018-10-11 11:10:41,12.00,11.5
360,2018-10-11 11:10:51,12.00,11.5
361,2018-10-11 11:11:01,12.00,11.5
362,2018-10-11 11:11:11,12.00,11.5
363,2018-10-11 11:11:21,12.00,11.5
364,2018-10-11 11:11:31,12.00,11.5
365,2018-10-11 11:11:41,12.00,11.5
366,2018-10-11 11:11:51,12.00,11.5
367,2018-10-11 11:12:01,12.00,11.5
368,2018-10-11 11:12:11,12.00,11.5
369,2018-10-11 11:12:21,12.00,11.5
370,2018-10-11 11:12:31,12.00,11.5
371,2018-10-11 11:12:41,12.00,11.5
372,2018-10-11 11:12:51,12.00,11.5
373,2018-10-11 11:13:01,12.00,11.5
374,2018-10-11 11:13:11,12.00,11.5
375,2018-10-11 11:13:21,12.00,11.5
376,2018-10-11 11:13:31,11.95,11.5
377,2018-10-11 11:13:41,11.95,11.5
378,2018-10-11 11:13:51,11.95,11.5
379,2018-10-11 11:14:01,11.95,11.5
380,2018-10-11 11:14:11,11.95,11.5
381,2018-10-11 11:14:21,11.95,11.5
382,2018-10-11 11:14:31,11.95,11.5
383,2018-10-11 11:14:41,11.95,11.5
384,2018-10-11 11:14:51,11.95,11.5
385,2018-10-11 11:15:01,11.95,11.5
386,2018-10-11 11:15:11,11.95,11.5
387,2018-10-11 11:15:21,11.95,11.5
388,2018-10-11 11:15:31,11.95,11.5
389,2018-10-11 11:15:41,11.95,11.5
390,2018-10-11 11:15:51,11.95,11.5
391,2018-10-11 11:16:01,11.95,11.5
392,2018-10-11 11:16:11,11.95,11.5
393,2018-10-11 11:16:21,11.95,11.5
394,2018-10-11 11:16:31,11.95,11.5
395,2018-10-11 11:16:41,11.95,11.5
396,2018-10-11 11:16:51,11.95,11.5
397,2018-10-11 11:17:01,11.95,11.5
398,2018-10-11 11:17:11,11.95,11.5
399,2018-10-11 11:17:21,11.95,11.5
400,2018-10-11 11:17:31,11.95,11.5
401,2018-10-11 11:17:41,11.95,11.5
402,2018-10-11 11:17:51,11.95,11.5
403,2018-10-11 11:18:01,11.95,11.5
404,2018-10-11 11:18:11,11.95,11.5
405,2018-10-11 11:18:21,11.95,11.5
406,2018-10-11 11:18:31,11.95,11.5
407,2018-10-11 11:18:41,11.95,11.5
408,2018-10-11 11:18:51,11.95,11.5
409,2018-10-11 11:19:01,11.95,11.5
410,2018-10-11 11:19:11,11.95,11.5
411,2018-10-11 11:19:21,11.90,11.5
412,2018-10-11 11:19:31,11.95,11.5
413,2018-10-11 11:19:41,11.90,11.5
414,2018-10-11 11:19:51,11.90,11.5
415,2018-10-11 11:20:01,11.90,11.5
416,2018-10-11 11:20:11,11.90,11.5
417,2018-10-11 11:20:21,11.90,11.5
418,2018-10-11 11:20:31,11.90,11.5
419,2018-10-11 11:20:41,11.90,11.5
420,2018-10-11 11:20:51,11.90,11.5
421,2018-10-11 11:21:01,11.90,11.5
422,2018-10-11 11:21:11,11.90,11.5
423,2018-10-11 11:21:21,11.90,11.5
424,2018-10-11 11:21:31,11.90,11.5
425,2018-10-11 11:21:41,11.90,11.5
426,2018-10-11 11:21:51,11.90,11.5
427,2018-10-11 11:22:01,11.90,11.5
428,2018-10-11 11:22:11,11.90,11.5
429,2018-10-11 11:22:21,11.90,11.5
430,2018-10-11 11:22:31,11.90,11.5
431,2018-10-11 11:22:41,11.90,11.5
432,2018-10-11 11:22:51,11.90,11.5
433,2018-10-11 11:23:01,11.90,11.5
434,2018-10-11 11:23:11,11.90,11.5
435,2018-10-11 11:23:21,11.90,11.5
436,2018-10-11 11:23:31,11.90,11.5
437,2018-10-11 11:23:41,11.90,11.5
438,2018-10-11 11:23:51,11.90,11.5
439,2018-10-11 11:24:01,11.90,11.5
440,2018-10-11 11:24:11,11.90,11.5
441,2018-10-11 11:24:21,11.90,11.5
442,2018-10-11 11:24:31,11.90,11.5
443,2018-10-11 11:24:41,11.90,11.5
444,2018-10-11 11:24:51,11.90,11.5
445,2018-10-11 11:25:01,11.90,11.5
446,2018-10-11 11:25:11,11.90,11.5
447,2018-10-11 11:25:21,11.90,11.5
448,2018-10-11 11:25:31,11.85,11.5
449,2018-10-11 11:25:41,11.90,11.5
450,2018-10-11 11:25:51,11.90,11.5
451,2018-10-11 11:26:01,11.85,11.5
452,2018-10-11 11:26:11,11.85,11.5
453,2018-10-11 11:26:21,11.85,11.5
454,2018-10-11 11:26:31,11.85,11.5
455,2018-10-11 11:26:41,11.85,11.5
456,2018-10-11 11:26:51,11.85,11.5
457,2018-10-11 11:27:01,11.85,11.5
458,2018-10-11 11:27:11,11.85,11.5
459,2018-10-11 11:27:21,11.85,11.5
460,2018-10-11 11:27:31,11.85,11.5
461,2018-10-11 11:27:41,11.85,11.5
462,2018-10-11 11:27:51,11.85,11.5
463,2018-10-11 11:28:01,11.85,11.5
464,2018-10-11 11:28:11,11.85,11.5
465,2018-10-11 11:28:21,11.85,11.5
466,2018-10-11 11:28:31,11.85,11.5
467,2018-10-11 11:28:41,11.85,11.5
468,2018-10-11 11:28:51,11.85,11.5
469,2018-10-11 11:29:01,11.85,11.5
470,2018-10-11 11:29:11,11.85,11.5
471,2018-10-11 11:29:21,11.85,11.5
472,2018-10-11 11:29:31,11.85,11.5
473,2018-10-11 11:29:41,11.85,11.5
474,2018-10-11 11:29:51,11.85,11.5
475,2018-10-11 11:30:01,11.85,11.5
476,2018-10-11 11:30:11,11.85,11.5
477,2018-10-11 11:30:21,11.85,11.5
478,2018-10-11 11:30:31,11.85,11.5
479,2018-10-11 11:30:41,11.85,11.5
480,2018-10-11 11:30:51,11.85,11.5
481,2018-10-11 11:31:01,11.85,11.5
482,2018-10-11 11:31:11,11.85,11.5
483,2018-10-11 11:31:21,11.85,11.5
484,2018-10-11 11:31:31,11.85,11.5
485,2018-10-11 11:31:41,11.80,11.5
486,2018-10-11 11:31:51,11.80,11.5
487,2018-10-11 11:32:01,11.80,11.5
488,2018-10-11 11:32:11,11.80,11.5
489,2018-10-11 11:32:21,11.80,11.5
490,2018-10-11 11:32:31,11.80,11.5
491,2018-10-11 11:32:41,11.80,11.5
492,2018-10-11 11:32:51,11.80,11.5
493,2018-10-11 11:33:01,11.80,11.5
494,2018-10-11 11:33:11,11.80,11.5
495,2018-10-11 11:33:21,11.80,11.5
496,2018-10-11 11:33:31,11.80,11.5
497,2018-10-11 11:33:41,11.80,11.5
498,2018-10-11 11:33:51,11.80,11.5
499,2018-10-11 11:34:01,11.80,11.5
500,2018-10-11 11:34:11,11.80,11.5
501,2018-10-11 11:34:21,11.80,11.5
502,2018-10-11 11:34:31,11.80,11.5
503,2018-10-11 11:34:41,11.80,11.5
504,2018-10-11 11:34:51,11.80,11.5
505,2018-10-11 11:35:01,11.80,11.5
506,2018-10-11 11:35:11,11.80,11.5
507,2018-10-11 11:35:21,11.80,11.5
508,2018-10-11 11:35:31,11.80,11.5
509,2018-10-11 11:35:41,11.80,11.5
510,2018-10-11 11:35:51,11.80,11.5
511,2018-10-11 11:36:01,11.80,11.5
512,2018-10-11 11:36:11,11.80,11.5
513,2018-10-11 11:36:21,11.80,11.5
514,2018-10-11 11:36:31,11.80,11.5
515,2018-10-11 11:36:41,11.80,11.5
516,2018-10-11 11:36:51,11.80,11.5
517,2018-10-11 11:37:01,11.75,11.5
518,2018-10-11 11:37:11,11.75,11.5
519,2018-10-11 11:37:21,11.75,11.5
520,2018-10-11 11:37:31,11.75,11.5
521,2018-10-11 11:37:41,11.75,11.5
522,2018-10-11 11:37:51,11.75,11.5
523,2018-10-11 11:38:01,11.75,11.5
524,2018-10-11 11:38:11,11.75,11.5
525,2018-10-11 11:38:21,11.75,11.5
526,2018-10-11 11:38:31,11.75,11.5
527,2018-10-11 11:38:41,11.75,11.5
528,2018-10-11 11:38:51,11.75,11.5
529,2018-10-11 11:39:01,11.75,11.5
530,2018-10-11 11:39:11,11.75,11.5
531,2018-10-11 11:39:21,11.75,11.5
532,2018-10-11 11:39:31,11.75,11.5
533,2018-10-11 11:39:41,11.75,11.5
534,2018-10-11 11:39:51,11.75,11.5
535,2018-10-11 11:40:01,11.75,11.5
536,2018-10-11 11:40:11,11.75,11.5
537,2018-10-11 11:40:21,11.75,11.5
538,2018-10-11 11:40:31,11.75,11.5
539,2018-10-11 11:40:41,11.75,11.5
540,2018-10-11 11:40:51,11.75,11.5
541,2018-10-11 11:41:01,11.75,11.5
542,2018-10-11 11:41:11,11.75,11.5
543,2018-10-11 11:41:21,11.75,11.5
544,2018-10-11 11:41:31,11.75,11.5
545,2018-10-11 11:41:41,11.75,11.5
546,2018-10-11 11:41:51,11.70,11.5
547,2018-10-11 11:42:01,11.70,11.5
548,2018-10-11 11:42:11,11.70,11.5
549,2018-10-11 11:42:21,11.70,11.5
550,2018-10-11 11:42:31,11.70,11.5
551,2018-10-11 11:42:41,11.70,11.5
552,2018-10-11 11:42:51,11.70,11.5
553,2018-10-11 11:43:01,11.70,11.5
554,2018-10-11 11:43:11,11.70,11.5
555,2018-10-11 11:43:21,11.70,11.5
556,2018-10-11 11:43:31,11.70,11.5
557,2018-10-11 11:43:41,11.70,11.5
558,2018-10-11 11:43:51,11.70,11.5
559,2018-10-11 11:44:01,11.70,11.5
560,2018-10-11 11:44:11,11.70,11.5
561,2018-10-11 11:44:21,11.70,11.5
562,2018-10-11 11:44:31,11.70,11.5
563,2018-10-11 11:44:41,11.70,11.5
564,2018-10-11 11:44:51,11.70,11.5
565,2018-10-11 11:45:01,11.70,11.5
566,2018-10-11 11:45:11,11.70,11.5
567,2018-10-11 11:45:21,11.70,11.5
568,2018-10-11 11:45:31,11.70,11.5
569,2018-10-11 11:45:41,11.70,11.5
570,2018-10-11 11:45:51,11.70,11.5
571,2018-10-11 11:46:01,11.70,11.5
572,2018-10-11 11:46:11,11.70,11.5
573,2018-10-11 11:46:21,11.70,11.5
574,2018-10-11 11:46:31,11.70,11.5
575,2018-10-11 11:46:41,11.70,11.5
576,2018-10-11 11:46:51,11.70,11.5
577,2018-10-11 11:47:01,11.65,11.5
578,2018-10-11 11:47:11,11.65,11.5
579,2018-10-11 11:47:21,11.65,11.5
580,2018-10-11 11:47:31,11.65,11.5
581,2018-10-11 11:47:41,11.65,11.5
582,2018-10-11 11:47:51,11.65,11.5
583,2018-10-11 11:48:01,11.65,11.5
584,2018-10-11 11:48:11,11.65,11.5
585,2018-10-11 11:48:21,11.65,11.5
586,2018-10-11 11:48:31,11.65,11.5
587,2018-10-11 11:48:41,11.65,11.5
588,2018-10-11 11:48:51,11.65,11.5
589,2018-10-11 11:49:01,11.65,11.5
590,2018-10-11 11:49:11,11.65,11.5
591,2018-10-11 11:49:21,11.65,11.5
592,2018-10-11 11:49:31,11.65,11.5
593,2018-10-11 11:49:41,11.65,11.5
594,2018-10-11 11:49:51,11.65,11.5
595,2018-10-11 11:50:01,11.65,11.5
596,2018-10-11 11:50:11,11.65,11.5
597,2018-10-11 11:50:21,11.65,11.5
598,2018-10-11 11:50:31,11.65,11.5
599,2018-10-11 11:50:41,11.65,11.5
600,2018-10-11 11:50:51,11.65,11.5
601,2018-10-11 11:51:01,11.65,11.5
602,2018-10-11 11:51:11,11.60,11.5
603,2018-10-11 11:51:21,11.60,11.5
604,2018-10-11 11:51:31,11.60,11.5
605,2018-10-11 11:51:41,11.60,11.5
606,2018-10-11 11:51:51,11.60,11.5
607,2018-10-11 11:52:01,11.60,11.5
608,2018-10-11 11:52:11,11.60,11.5
609,2018-10-11 11:52:21,11.60,11.5
610,2018-10-11 11:52:31,11.60,11.5
611,2018-10-11 11:52:41,11.60,11.5
612,2018-10-11 11:52:51,11.60,11.5
613,2018-10-11 11:53:01,11.60,11.5
614,2018-10-11 11:53:11,11.60,11.5
615,2018-10-11 11:53:21,11.60,11.5
616,2018-10-11 11:53:31,11.60,11.5
617,2018-10-11 11:53:41,11.60,11.5
618,2018-10-11 11:53:51,11.60,11.5
619,2018-10-11 11:54:01,11.60,11.5
620,2018-10-11 11:54:11,11.60,11.5
621,2018-10-11 11:54:21,11.60,11.5
622,2018-10-11 11:54:31,11.60,11.5
623,2018-10-11 11:54:41,11.60,11.5
624,2018-10-11 11:54:51,11.60,11.5
625,2018-10-11 11:55:01,11.60,11.5
626,2018-10-11 11:55:11,11.60,11.5
627,2018-10-11 11:55:21,11.55,11.5
628,2018-10-11 11:55:31,11.60,11.5
629,2018-10-11 11:55:41,11.55,11.5
630,2018-10-11 11:55:51,11.55,11.5
631,2018-10-11 11:56:01,11.55,11.5
632,2018-10-11 11:56:11,11.55,11.5
633,2018-10-11 11:56:21,11.55,11.5
634,2018-10-11 11:56:31,11.55,11.5
635,2018-10-11 11:56:41,11.55,11.5
636,2018-10-11 11:56:51,11.55,11.5
637,2018-10-11 11:57:01,11.55,11.5
638,2018-10-11 11:57:11,11.55,11.5
639,2018-10-11 11:57:21,11.55,11.5
640,2018-10-11 11:57:31,11.55,11.5
641,2018-10-11 11:57:41,11.55,11.5
642,2018-10-11 11:57:51,11.55,11.5
643,2018-10-11 11:58:01,11.55,11.5
644,2018-10-11 11:58:11,11.55,11.5
645,2018-10-11 11:58:21,11.55,11.5
646,2018-10-11 11:58:31,11.55,11.5
647,2018-10-11 11:58:41,11.55,11.5
648,2018-10-11 11:58:51,11.55,11.5
649,2018-10-11 11:59:01,11.55,11.5
650,2018-10-11 11:59:11,11.55,11.5
651,2018-10-11 11:59:21,11.50,11.5
652,2018-10-11 11:59:31,11.55,11.5
653,2018-10-11 11:59:41,11.55,11.5
654,2018-10-11 11:59:51,11.50,11.5
655,2018-10-11 12:00:01,11.50,11.5
656,2018-10-11 12:00:11,11.50,11.5
657,2018-10-11 12:00:21,11.50,11.5
658,2018-10-11 12:00:31,11.50,11.5
659,2018-10-11 12:00:41,11.50,11.5
660,2018-10-11 12:00:51,11.50,11.5
661,2018-10-11 12:01:01,11.50,11.5
662,2018-10-11 12:01:11,11.50,11.5
663,2018-10-11 12:01:21,11.50,11.5
664,2018-10-11 12:01:31,11.50,11.5
665,2018-10-11 12:01:41,11.50,11.5
666,2018-10-11 12:01:51,11.50,11.5
667,2018-10-11 12:02:01,11.50,11.5
668,2018-10-11 12:02:11,11.50,11.5
669,2018-10-11 12:02:21,11.50,11.5
670,2018-10-11 12:02:31,11.50,11.5
671,2018-10-11 12:02:41,11.50,11.5
672,2018-10-11 12:02:51,11.50,11.5
673,2018-10-11 12:03:01,11.50,11.5
674,2018-10-11 12:03:11,11.45,11.5
675,2018-10-11 12:03:21,11.50,11.5
676,2018-10-11 12:03:31,11.45,11.5
677,2018-10-11 12:03:41,11.45,11.5
678,2018-10-11 12:03:51,11.45,11.5
679,2018-10-11 12:04:01,11.45,11.5
680,2018-10-11 12:04:11,11.45,11.5
681,2018-10-11 12:04:21,11.45,11.5
682,2018-10-11 12:04:31,11.45,11.5
683,2018-10-11 12:04:41,11.45,11.5
684,2018-10-11 12:04:51,11.45,11.5
685,2018-10-11 12:05:01,11.45,11.5
686,2018-10-11 12:05:11,11.45,11.5
687,2018-10-11 12:05:21,11.45,11.5
688,2018-10-11 12:05:31,11.45,11.5
689,2018-10-11 12:05:41,11.45,11.5
690,2018-10-11 12:05:51,11.45,11.5
691,2018-10-11 12:06:01,11.45,11.5
692,2018-10-11 12:06:11,11.45,11.5
693,2018-10-11 12:06:21,11.45,11.5
694,2018-10-11 12:06:31,11.45,11.5
695,2018-10-11 12:06:41,11.45,11.5
696,2018-10-11 12:06:51,11.45,11.5
697,2018-10-11 12:07:01,11.45,11.5
698,2018-10-11 12:07:11,11.45,11.5
699,2018-10-11 12:07:21,11.40,11.5
700,2018-10-11 12:07:31,11.40,11.5
701,2018-10-11 12:07:41,11.40,11.5
702,2018-10-11 12:07:51,11.40,11.5
703,2018-10-11 12:08:01,11.40,11.5
704,2018-10-11 12:08:11,11.40,11.5
705,2018-10-11 12:08:21,11.40,11.5
706,2018-10-11 12:08:31,11.40,11.5
707,2018-10-11 12:08:41,11.40,11.5
708,2018-10-11 12:08:51,11.40,11.5
709,2018-10-11 12:09:01,11.40,11.5
710,2018-10-11 12:09:11,11.40,11.5
711,2018-10-11 12:09:21,11.40,11.5
712,2018-10-11 12:09:31,11.40,11.5
713,2018-10-11 12:09:41,11.40,11.5
714,2018-10-11 12:09:51,11.40,11.5
715,2018-10-11 12:10:01,11.40,11.5
716,2018-10-11 12:10:11,11.40,11.5
717,2018-10-11 12:10:21,11.40,11.5
718,2018-10-11 12:10:31,11.40,11.5
719,2018-10-11 12:10:41,11.40,11.5
720,2018-10-11 12:10:51,11.35,11.5
721,2018-10-11 12:11:01,11.35,11.5
722,2018-10-11 12:11:11,11.35,11.5
723,2018-10-11 12:11:21,11.35,11.5
724,2018-10-11 12:11:31,11.35,11.5
725,2018-10-11 12:11:41,11.35,11.5
726,2018-10-11 12:11:51,11.35,11.5
727,2018-10-11 12:12:01,11.35,11.5
728,2018-10-11 12:12:11,11.35,11.5
729,2018-10-11 12:12:21,11.35,11.5
730,2018-10-11 12:12:31,11.35,11.5
731,2018-10-11 12:12:41,11.35,11.5
732,2018-10-11 12:12:51,11.35,11.5
733,2018-10-11 12:13:01,11.35,11.5
734,2018-10-11 12:13:11,11.35,11.5
735,2018-10-11 12:13:21,11.35,11.5
736,2018-10-11 12:13:31,11.35,11.5
737,2018-10-11 12:13:41,11.35,11.5
738,2018-10-11 12:13:51,11.35,11.5
739,2018-10-11 12:14:01,11.30,11.5
740,2018-10-11 12:14:11,11.30,11.5
741,2018-10-11 12:14:21,11.30,11.5
742,2018-10-11 12:14:31,11.30,11.5
743,2018-10-11 12:14:41,11.30,11.5
744,2018-10-11 12:14:51,11.30,11.5
745,2018-10-11 12:15:01,11.30,11.5
746,2018-10-11 12:15:11,11.30,11.5
747,2018-10-11 12:15:21,11.30,11.5
748,2018-10-11 12:15:31,11.30,11.5
749,2018-10-11 12:15:41,11.30,11.5
750,2018-10-11 12:15:51,11.30,11.5
751,2018-10-11 12:16:01,11.30,11.5
752,2018-10-11 12:16:11,11.30,11.5
753,2018-10-11 12:16:21,11.30,11.5
754,2018-10-11 12:16:31,11.30,11.5
755,2018-10-11 12:16:41,11.25,11.5
756,2018-10-11 12:16:51,11.30,11.5
757,2018-10-11 12:17:01,11.25,11.5
758,2018-10-11 12:17:11,11.25,11.5
759,2018-10-11 12:17:21,11.25,11.5
760,2018-10-11 12:17:31,11.25,11.5
761,2018-10-11 12:17:41,11.25,11.5
762,2018-10-11 12:17:51,11.25,11.5
763,2018-10-11 12:18:01,11.25,11.5
764,2018-10-11 12:18:11,11.25,11.5
765,2018-10-11 12:18:21,11.25,11.5
766,2018-10-11 12:18:31,11.25,11.5
767,2018-10-11 12:18:41,11.25,11.5
768,2018-10-11 12:18:51,11.25,11.5
769,2018-10-11 12:19:01,11.25,11.5
770,2018-10-11 12:19:11,11.20,11.5
771,2018-10-11 12:19:21,11.20,11.5
772,2018-10-11 12:19:31,11.20,11.5
773,2018-10-11 12:19:41,11.20,11.5
774,2018-10-11 12:19:51,11.20,11.5
775,2018-10-11 12:20:01,11.20,11.5
776,2018-10-11 12:20:11,11.20,11.5
777,2018-10-11 12:20:21,11.20,11.5
778,2018-10-11 12:20:31,11.20,11.5
779,2018-10-11 12:20:41,11.20,11.5
780,2018-10-11 12:20:51,11.20,11.5
781,2018-10-11 12:21:01,11.20,11.5
782,2018-10-11 12:21:11,11.20,11.5
783,2018-10-11 12:21:21,11.20,11.5
784,2018-10-11 12:21:31,11.15,11.5
785,2018-10-11 12:21:41,11.15,11.5
786,2018-10-11 12:21:51,11.15,11.5
787,2018-10-11 12:22:01,11.15,11.5
788,2018-10-11 12:22:11,11.15,11.5
789,2018-10-11 12:22:21,11.15,11.5
790,2018-10-11 12:22:31,11.15,11.5
791,2018-10-11 12:22:41,11.15,11.5
792,2018-10-11 12:22:51,11.15,11.5
793,2018-10-11 12:23:01,11.15,11.5
794,2018-10-11 12:23:11,11.15,11.5
795,2018-10-11 12:23:21,11.15,11.5
796,2018-10-11 12:23:31,11.15,11.5
797,2018-10-11 12:23:41,11.10,11.5
798,2018-10-11 12:23:51,11.10,11.5
799,2018-10-11 12:24:01,11.10,11.5
800,2018-10-11 12:24:11,11.10,11.5
801,2018-10-11 12:24:21,11.10,11.5
802,2018-10-11 12:24:31,11.10,11.5
803,2018-10-11 12:24:41,11.10,11.5
804,2018-10-11 12:24:51,11.10,11.5
805,2018-10-11 12:25:01,11.10,11.5
806,2018-10-11 12:25:11,11.10,11.5
807,2018-10-11 12:25:21,11.55,11.5
808,2018-10-11 12:25:31,11.60,11.5
809,2018-10-11 12:25:41,11.65,11.5
810,2018-10-11 12:25:51,11.65,11.5
811,2018-10-11 12:26:01,11.65,11.5
812,2018-10-11 12:26:11,11.65,11.5
813,2018-10-11 12:26:21,11.65,11.5
814,2018-10-11 12:26:31,11.70,11.5
815,2018-10-11 12:26:41,11.70,11.5
816,2018-10-11 12:26:51,11.70,11.5
817,2018-10-11 12:27:01,11.70,11.5
818,2018-10-11 12:27:11,11.70,11.5
819,2018-10-11 12:27:21,11.70,11.5
820,2018-10-11 12:27:31,11.70,11.5
821,2018-10-11 12:27:41,11.70,11.5
822,2018-10-11 12:27:51,11.75,11.5
823,2018-10-11 12:28:01,11.75,11.5
824,2018-10-11 12:28:11,11.75,11.5
825,2018-10-11 12:28:21,11.75,11.5
826,2018-10-11 12:28:31,11.75,11.5
827,2018-10-11 12:28:41,11.75,11.5
828,2018-10-11 12:28:51,11.75,11.5
829,2018-10-11 12:29:01,11.75,11.5
830,2018-10-11 12:29:11,11.75,11.5
831,2018-10-11 12:29:21,11.75,11.5
832,2018-10-11 12:29:31,11.75,11.5
833,2018-10-11 12:29:41,11.75,11.5
834,2018-10-11 12:29:51,11.75,11.5
835,2018-10-11 12:30:01,11.80,11.5
836,2018-10-11 12:30:11,11.80,11.5
837,2018-10-11 12:30:21,0.05,11.5
838,2018-10-11 12:30:31,0.05,11.5
839,2018-10-11 12:30:41,0.05,11.5
840,2018-10-11 12:30:51,0.05,11.5
841,2018-10-11 12:31:01,0.05,11.5
842,2018-10-11 12:31:11,0.05,11.5
843,2018-10-11 12:31:21,0.00,11.5
844,2018-10-11 12:31:31,0.10,11.5
845,2018-10-11 12:31:41,0.05,11.5

  #2   Report Post  
Posted to uk.d-i-y
external usenet poster
 
Posts: 40,893
Default Spreadsheet type data manipulation?



"T i m" wrote in message
...
Hi all,

I've recently bought one of the Lascar USB data capture units
(EL-USB-3 Volts):

https://www.lascarelectronics.com/ea...gger-el-usb-3/

.. and just used it to monitor the discharge of a 26Ah gel battery
into a ~7A (incandescent lamp) load (down to 11V).

The output from the logger is a CSV .txt file and their simple viewer
autoscales the Y axis (Volts / 15) and just shows the X in real time
(presumably taken from the PC start time and the reading intervals?),
however I'd like to display and annotate a graph with shifted Y axis
(say 10-15V) and the X in minutes (or hrs / min but starting from
zero).

I'm sure this would be something pretty easy to do with a spreadsheet


Yep.


  #3   Report Post  
Posted to uk.d-i-y
external usenet poster
 
Posts: 4,564
Default Spreadsheet type data manipulation?

See he

http://wiki.diyfaq.org.uk/index.php/...sy_Volts_1.png

I am unable to upload the spreadsheet file itself to the wiki, but the only change I made was to insert a new column to calculate the elapsed time, using C3 =B3-$B$2 and use that as the x axis.

Owain
  #4   Report Post  
Posted to uk.d-i-y
external usenet poster
 
Posts: 4,564
Default Spreadsheet type data manipulation?

On Thursday, 11 October 2018 16:23:32 UTC+1, wrote:
See he

http://wiki.diyfaq.org.uk/index.php/...sy_Volts_1.png


and this one with the time labels corrected

http://wiki.diyfaq.org.uk/index.php/...sy_Volts_2.png

Owain
  #5   Report Post  
Posted to uk.d-i-y
external usenet poster
 
Posts: 13,431
Default Spreadsheet type data manipulation?

On Thu, 11 Oct 2018 08:23:29 -0700 (PDT),
wrote:

See he

http://wiki.diyfaq.org.uk/index.php/...sy_Volts_1.png

Sweet (thanks). ;-)

I am unable to upload the spreadsheet file itself to the wiki, but the only change I made was to insert a new column to calculate the elapsed time, using C3 =B3-$B$2 and use that as the x axis.


That's what I thought one could use (but no idea how) but had you
trimmed any leading 0V's I'm guessing you would have to subtract the
value of that time (say 6 x 10s intervals) from the start of the new X
axis scale (for the axis 'Total_Elapsed_Time' to be pertinent?

For a standard load across a range of batteries, the elapsed time down
to a specific voltage (depending on the type of LA battery being
tested) is what I use to give me a quick 'usefulness' guide.

Similar with the trailing 0V's *and*, where the voltage lifts when the
load auto-disconnects (but the logger is still connected and running).
Whilst I can work out the actual elapsed time, it would be nice if the
graph itself reflected that (and I don't really actually need the sub
times come to think of it, as long as the final time is shown in hrs /
mins or just mins)? I notice on your X the mins just repeat ever hour?

Another thing that your graph has shown up is the (lowish) resolution
of the logger, compared with my fancy charger / logger in any case.
Now with the current 10s logging interval it tells me I have over 3
days worth of logging g, so that could be faster if it really
mattered (and it doesn't as such, other than seeing a slightly
smoother line). ;-)

It would make a difference on the Optimate charge graph as you can see
the various charge / test phases in better detail.

So, seeing your formula for just that bit, it's obvious to me that I'd
probably need a more basic graphing app, even if I have to bit of
manual pruning beforehand (in Notepad+ or OO Calc)?

After I've cycled / logged these 2 batteries I might put one on
daughters rabbit hutch electric fence and solar panel so I can get
some idea just how well the solar panel(s) might be able to balance
the energiser (or not), especially with the winter coming up.

Cheers, T i m


  #6   Report Post  
Posted to uk.d-i-y
external usenet poster
 
Posts: 13,431
Default Spreadsheet type data manipulation?

On Thu, 11 Oct 2018 08:32:35 -0700 (PDT),
wrote:

On Thursday, 11 October 2018 16:23:32 UTC+1, wrote:
See he

http://wiki.diyfaq.org.uk/index.php/...sy_Volts_1.png

and this one with the time labels corrected

http://wiki.diyfaq.org.uk/index.php/...sy_Volts_2.png


Thanks again Owain, very neat!

I think that has convinced me that with that sort of graph, the
interim times aren't really relevant so maybe only the who hours and
final time would be sufficient?

It would be different for the charge plot as it might be interesting
to see when transitioned between the various phases (bulk - test etc)
but that is of less use in general to seeing how a battery fares under
load.

This should be an ongoing thing so I'd ideally need a solution I could
manage. [1]

Cheers, T i m

[1] FWIW etc. The charger / logger only logs when you press the start
button (and apply the charge / load) and stops looking at the end of
the process. You can also apply the scaling to the live display so
that it's pretty well ready to use at the end. It's just that it's not
always convenient to connect that unit up and a PC to do the logging
.....

p.s. This USB logger would also be handy for long term monitoring of
say a car battery. With a 60 second sample time you can cover 22 days.
;-)
  #7   Report Post  
Posted to uk.d-i-y
external usenet poster
 
Posts: 4,564
Default Spreadsheet type data manipulation?

On Thursday, 11 October 2018 17:10:40 UTC+1, T i m wrote:
http://wiki.diyfaq.org.uk/index.php/...sy_Volts_2.png

Thanks again Owain, very neat!
I think that has convinced me that with that sort of graph, the
interim times aren't really relevant so maybe only the who hours and
final time would be sufficient?


Presumably they can be taken out or adjusted. This is the first time I've used LibreOffice Calc and graphs, so I'm not used to playing about with it - just used the chart wizard. No other software was used and no other data maipulation carried out. Just formatted the time column to 'Time' and the axis value to HH:MM:SS (on the second try!)

This should be an ongoing thing so I'd ideally need a solution I could
manage.


Once you've set up the spreadsheet chart to use cell ranges, axis resolutions etc you'd just paste in the comma delimited stuff into the sheet and the chart will update to the new values.

Owain
  #8   Report Post  
Posted to uk.d-i-y
external usenet poster
 
Posts: 2,640
Default Spreadsheet type data manipulation?

T i m wrote:
Hi all,

I've recently bought one of the Lascar USB data capture units
(EL-USB-3 Volts):

https://www.lascarelectronics.com/ea...gger-el-usb-3/

.. and just used it to monitor the discharge of a 26Ah gel battery
into a ~7A (incandescent lamp) load (down to 11V).

The output from the logger is a CSV .txt file and their simple viewer
autoscales the Y axis (Volts / 15) and just shows the X in real time
(presumably taken from the PC start time and the reading intervals?),
however I'd like to display and annotate a graph with shifted Y axis
(say 10-15V) and the X in minutes (or hrs / min but starting from
zero).

I'm sure this would be something pretty easy to do with a spreadsheet
or maybe there are graphing apps that would take this data and allow
the sort of manipulation mentioned above without having to deal with
formula etc?

As we are all of BB now and bandwidth isn't a problem, I'll insert one
such log here for anyone so inclined to play ... ;-)

Cheers, T i m

(You can discard the low alarm column, just playing with that and I
can trim the leading and trailing 0V readings in Notepad+. If you do
that though you lose the initial column / time counts and would need
to adjust for each graph manually?).

EasyLog USB,Time,Voltage(Volts),Low Alarm
1,2018-10-11 10:11:01,0.05,11.5
2,2018-10-11 10:11:11,0.05,11.5
3,2018-10-11 10:11:21,0.05,11.5
4,2018-10-11 10:11:31,0.00,11.5
5,2018-10-11 10:11:41,0.00,11.5
6,2018-10-11 10:11:51,0.00,11.5
7,2018-10-11 10:12:01,0.00,11.5
8,2018-10-11 10:12:11,0.00,11.5
9,2018-10-11 10:12:21,12.85,11.5
10,2018-10-11 10:12:31,12.85,11.5
11,2018-10-11 10:12:41,12.35,11.5
12,2018-10-11 10:12:51,12.25,11.5
13,2018-10-11 10:13:01,12.25,11.5
14,2018-10-11 10:13:11,12.25,11.5
15,2018-10-11 10:13:21,12.25,11.5
16,2018-10-11 10:13:31,12.25,11.5
17,2018-10-11 10:13:41,12.25,11.5
18,2018-10-11 10:13:51,12.25,11.5
19,2018-10-11 10:14:01,12.25,11.5
20,2018-10-11 10:14:11,12.25,11.5
21,2018-10-11 10:14:21,12.25,11.5
22,2018-10-11 10:14:31,12.30,11.5
23,2018-10-11 10:14:41,12.30,11.5
24,2018-10-11 10:14:51,12.30,11.5
25,2018-10-11 10:15:01,12.30,11.5
26,2018-10-11 10:15:11,12.30,11.5
27,2018-10-11 10:15:21,12.30,11.5
28,2018-10-11 10:15:31,12.30,11.5
29,2018-10-11 10:15:41,12.30,11.5
30,2018-10-11 10:15:51,12.30,11.5
31,2018-10-11 10:16:01,12.30,11.5
32,2018-10-11 10:16:11,12.30,11.5
33,2018-10-11 10:16:21,12.30,11.5
34,2018-10-11 10:16:31,12.30,11.5
35,2018-10-11 10:16:41,12.30,11.5
36,2018-10-11 10:16:51,12.30,11.5
37,2018-10-11 10:17:01,12.30,11.5
38,2018-10-11 10:17:11,12.30,11.5
39,2018-10-11 10:17:21,12.30,11.5
40,2018-10-11 10:17:31,12.30,11.5
41,2018-10-11 10:17:41,12.30,11.5
42,2018-10-11 10:17:51,12.30,11.5
43,2018-10-11 10:18:01,12.30,11.5
44,2018-10-11 10:18:11,12.30,11.5
45,2018-10-11 10:18:21,12.30,11.5
46,2018-10-11 10:18:31,12.30,11.5
47,2018-10-11 10:18:41,12.30,11.5
48,2018-10-11 10:18:51,12.30,11.5
49,2018-10-11 10:19:01,12.30,11.5
50,2018-10-11 10:19:11,12.30,11.5
51,2018-10-11 10:19:21,12.30,11.5
52,2018-10-11 10:19:31,12.30,11.5
53,2018-10-11 10:19:41,12.30,11.5
54,2018-10-11 10:19:51,12.30,11.5
55,2018-10-11 10:20:01,12.30,11.5
56,2018-10-11 10:20:11,12.30,11.5
57,2018-10-11 10:20:21,12.30,11.5
58,2018-10-11 10:20:31,12.30,11.5
59,2018-10-11 10:20:41,12.30,11.5
60,2018-10-11 10:20:51,12.30,11.5
61,2018-10-11 10:21:01,12.30,11.5
62,2018-10-11 10:21:11,12.30,11.5
63,2018-10-11 10:21:21,12.30,11.5
64,2018-10-11 10:21:31,12.30,11.5
65,2018-10-11 10:21:41,12.30,11.5
66,2018-10-11 10:21:51,12.30,11.5
67,2018-10-11 10:22:01,12.30,11.5
68,2018-10-11 10:22:11,12.30,11.5
69,2018-10-11 10:22:21,12.30,11.5
70,2018-10-11 10:22:31,12.30,11.5
71,2018-10-11 10:22:41,12.30,11.5
72,2018-10-11 10:22:51,12.30,11.5
73,2018-10-11 10:23:01,12.30,11.5
74,2018-10-11 10:23:11,12.30,11.5
75,2018-10-11 10:23:21,12.30,11.5
76,2018-10-11 10:23:31,12.30,11.5
77,2018-10-11 10:23:41,12.30,11.5
78,2018-10-11 10:23:51,12.30,11.5
79,2018-10-11 10:24:01,12.30,11.5
80,2018-10-11 10:24:11,12.30,11.5
81,2018-10-11 10:24:21,12.30,11.5
82,2018-10-11 10:24:31,12.30,11.5
83,2018-10-11 10:24:41,12.30,11.5
84,2018-10-11 10:24:51,12.30,11.5
85,2018-10-11 10:25:01,12.30,11.5
86,2018-10-11 10:25:11,12.30,11.5
87,2018-10-11 10:25:21,12.30,11.5
88,2018-10-11 10:25:31,12.30,11.5
89,2018-10-11 10:25:41,12.30,11.5
90,2018-10-11 10:25:51,12.30,11.5
91,2018-10-11 10:26:01,12.30,11.5
92,2018-10-11 10:26:11,12.30,11.5
93,2018-10-11 10:26:21,12.30,11.5
94,2018-10-11 10:26:31,12.30,11.5
95,2018-10-11 10:26:41,12.30,11.5
96,2018-10-11 10:26:51,12.30,11.5
97,2018-10-11 10:27:01,12.30,11.5
98,2018-10-11 10:27:11,12.30,11.5
99,2018-10-11 10:27:21,12.30,11.5
100,2018-10-11 10:27:31,12.25,11.5
101,2018-10-11 10:27:41,12.30,11.5
102,2018-10-11 10:27:51,12.30,11.5
103,2018-10-11 10:28:01,12.25,11.5
104,2018-10-11 10:28:11,12.25,11.5
105,2018-10-11 10:28:21,12.25,11.5
106,2018-10-11 10:28:31,12.25,11.5
107,2018-10-11 10:28:41,12.25,11.5
108,2018-10-11 10:28:51,12.25,11.5
109,2018-10-11 10:29:01,12.25,11.5
110,2018-10-11 10:29:11,12.25,11.5
111,2018-10-11 10:29:21,12.25,11.5
112,2018-10-11 10:29:31,12.25,11.5
113,2018-10-11 10:29:41,12.25,11.5
114,2018-10-11 10:29:51,12.25,11.5
115,2018-10-11 10:30:01,12.25,11.5
116,2018-10-11 10:30:11,12.25,11.5
117,2018-10-11 10:30:21,12.25,11.5
118,2018-10-11 10:30:31,12.25,11.5
119,2018-10-11 10:30:41,12.25,11.5
120,2018-10-11 10:30:51,12.25,11.5
121,2018-10-11 10:31:01,12.25,11.5
122,2018-10-11 10:31:11,12.25,11.5
123,2018-10-11 10:31:21,12.25,11.5
124,2018-10-11 10:31:31,12.25,11.5
125,2018-10-11 10:31:41,12.25,11.5
126,2018-10-11 10:31:51,12.25,11.5
127,2018-10-11 10:32:01,12.25,11.5
128,2018-10-11 10:32:11,12.25,11.5
129,2018-10-11 10:32:21,12.25,11.5
130,2018-10-11 10:32:31,12.25,11.5
131,2018-10-11 10:32:41,12.25,11.5
132,2018-10-11 10:32:51,12.25,11.5
133,2018-10-11 10:33:01,12.25,11.5
134,2018-10-11 10:33:11,12.25,11.5
135,2018-10-11 10:33:21,12.25,11.5
136,2018-10-11 10:33:31,12.25,11.5
137,2018-10-11 10:33:41,12.25,11.5
138,2018-10-11 10:33:51,12.25,11.5
139,2018-10-11 10:34:01,12.25,11.5
140,2018-10-11 10:34:11,12.25,11.5
141,2018-10-11 10:34:21,12.25,11.5
142,2018-10-11 10:34:31,12.25,11.5
143,2018-10-11 10:34:41,12.25,11.5
144,2018-10-11 10:34:51,12.25,11.5
145,2018-10-11 10:35:01,12.25,11.5
146,2018-10-11 10:35:11,12.25,11.5
147,2018-10-11 10:35:21,12.25,11.5
148,2018-10-11 10:35:31,12.25,11.5
149,2018-10-11 10:35:41,12.25,11.5
150,2018-10-11 10:35:51,12.25,11.5
151,2018-10-11 10:36:01,12.25,11.5
152,2018-10-11 10:36:11,12.25,11.5
153,2018-10-11 10:36:21,12.25,11.5
154,2018-10-11 10:36:31,12.25,11.5
155,2018-10-11 10:36:41,12.20,11.5
156,2018-10-11 10:36:51,12.25,11.5
157,2018-10-11 10:37:01,12.20,11.5
158,2018-10-11 10:37:11,12.25,11.5
159,2018-10-11 10:37:21,12.25,11.5
160,2018-10-11 10:37:31,12.20,11.5
161,2018-10-11 10:37:41,12.25,11.5
162,2018-10-11 10:37:51,12.20,11.5
163,2018-10-11 10:38:01,12.20,11.5
164,2018-10-11 10:38:11,12.20,11.5
165,2018-10-11 10:38:21,12.20,11.5
166,2018-10-11 10:38:31,12.20,11.5
167,2018-10-11 10:38:41,12.20,11.5
168,2018-10-11 10:38:51,12.20,11.5
169,2018-10-11 10:39:01,12.20,11.5
170,2018-10-11 10:39:11,12.20,11.5
171,2018-10-11 10:39:21,12.20,11.5
172,2018-10-11 10:39:31,12.20,11.5
173,2018-10-11 10:39:41,12.20,11.5
174,2018-10-11 10:39:51,12.20,11.5
175,2018-10-11 10:40:01,12.20,11.5
176,2018-10-11 10:40:11,12.20,11.5
177,2018-10-11 10:40:21,12.20,11.5
178,2018-10-11 10:40:31,12.20,11.5
179,2018-10-11 10:40:41,12.20,11.5
180,2018-10-11 10:40:51,12.20,11.5
181,2018-10-11 10:41:01,12.20,11.5
182,2018-10-11 10:41:11,12.20,11.5
183,2018-10-11 10:41:21,12.20,11.5
184,2018-10-11 10:41:31,12.20,11.5
185,2018-10-11 10:41:41,12.20,11.5
186,2018-10-11 10:41:51,12.20,11.5
187,2018-10-11 10:42:01,12.20,11.5
188,2018-10-11 10:42:11,12.20,11.5
189,2018-10-11 10:42:21,12.20,11.5
190,2018-10-11 10:42:31,12.20,11.5
191,2018-10-11 10:42:41,12.20,11.5
192,2018-10-11 10:42:51,12.20,11.5
193,2018-10-11 10:43:01,12.20,11.5
194,2018-10-11 10:43:11,12.20,11.5
195,2018-10-11 10:43:21,12.20,11.5
196,2018-10-11 10:43:31,12.20,11.5
197,2018-10-11 10:43:41,12.20,11.5
198,2018-10-11 10:43:51,12.20,11.5
199,2018-10-11 10:44:01,12.20,11.5
200,2018-10-11 10:44:11,12.20,11.5
201,2018-10-11 10:44:21,12.20,11.5
202,2018-10-11 10:44:31,12.20,11.5
203,2018-10-11 10:44:41,12.20,11.5
204,2018-10-11 10:44:51,12.20,11.5
205,2018-10-11 10:45:01,12.20,11.5
206,2018-10-11 10:45:11,12.20,11.5
207,2018-10-11 10:45:21,12.20,11.5
208,2018-10-11 10:45:31,12.20,11.5
209,2018-10-11 10:45:41,12.20,11.5
210,2018-10-11 10:45:51,12.15,11.5
211,2018-10-11 10:46:01,12.15,11.5
212,2018-10-11 10:46:11,12.15,11.5
213,2018-10-11 10:46:21,12.15,11.5
214,2018-10-11 10:46:31,12.15,11.5
215,2018-10-11 10:46:41,12.15,11.5
216,2018-10-11 10:46:51,12.15,11.5
217,2018-10-11 10:47:01,12.15,11.5
218,2018-10-11 10:47:11,12.15,11.5
219,2018-10-11 10:47:21,12.15,11.5
220,2018-10-11 10:47:31,12.15,11.5
221,2018-10-11 10:47:41,12.15,11.5
222,2018-10-11 10:47:51,12.15,11.5
223,2018-10-11 10:48:01,12.15,11.5
224,2018-10-11 10:48:11,12.15,11.5
225,2018-10-11 10:48:21,12.15,11.5
226,2018-10-11 10:48:31,12.15,11.5
227,2018-10-11 10:48:41,12.15,11.5
228,2018-10-11 10:48:51,12.15,11.5
229,2018-10-11 10:49:01,12.15,11.5
230,2018-10-11 10:49:11,12.15,11.5
231,2018-10-11 10:49:21,12.15,11.5
232,2018-10-11 10:49:31,12.15,11.5
233,2018-10-11 10:49:41,12.15,11.5
234,2018-10-11 10:49:51,12.15,11.5
235,2018-10-11 10:50:01,12.15,11.5
236,2018-10-11 10:50:11,12.15,11.5
237,2018-10-11 10:50:21,12.15,11.5
238,2018-10-11 10:50:31,12.15,11.5
239,2018-10-11 10:50:41,12.15,11.5
240,2018-10-11 10:50:51,12.15,11.5
241,2018-10-11 10:51:01,12.15,11.5
242,2018-10-11 10:51:11,12.15,11.5
243,2018-10-11 10:51:21,12.15,11.5
244,2018-10-11 10:51:31,12.15,11.5
245,2018-10-11 10:51:41,12.15,11.5
246,2018-10-11 10:51:51,12.15,11.5
247,2018-10-11 10:52:01,12.15,11.5
248,2018-10-11 10:52:11,12.15,11.5
249,2018-10-11 10:52:21,12.15,11.5
250,2018-10-11 10:52:31,12.15,11.5
251,2018-10-11 10:52:41,12.15,11.5
252,2018-10-11 10:52:51,12.15,11.5
253,2018-10-11 10:53:01,12.15,11.5
254,2018-10-11 10:53:11,12.15,11.5
255,2018-10-11 10:53:21,12.15,11.5
256,2018-10-11 10:53:31,12.15,11.5
257,2018-10-11 10:53:41,12.15,11.5
258,2018-10-11 10:53:51,12.10,11.5
259,2018-10-11 10:54:01,12.10,11.5
260,2018-10-11 10:54:11,12.10,11.5
261,2018-10-11 10:54:21,12.15,11.5
262,2018-10-11 10:54:31,12.10,11.5
263,2018-10-11 10:54:41,12.10,11.5
264,2018-10-11 10:54:51,12.10,11.5
265,2018-10-11 10:55:01,12.10,11.5
266,2018-10-11 10:55:11,12.10,11.5
267,2018-10-11 10:55:21,12.10,11.5
268,2018-10-11 10:55:31,12.10,11.5
269,2018-10-11 10:55:41,12.10,11.5
270,2018-10-11 10:55:51,12.10,11.5
271,2018-10-11 10:56:01,12.10,11.5
272,2018-10-11 10:56:11,12.10,11.5
273,2018-10-11 10:56:21,12.10,11.5
274,2018-10-11 10:56:31,12.10,11.5
275,2018-10-11 10:56:41,12.10,11.5
276,2018-10-11 10:56:51,12.10,11.5
277,2018-10-11 10:57:01,12.10,11.5
278,2018-10-11 10:57:11,12.10,11.5
279,2018-10-11 10:57:21,12.10,11.5
280,2018-10-11 10:57:31,12.10,11.5
281,2018-10-11 10:57:41,12.10,11.5
282,2018-10-11 10:57:51,12.10,11.5
283,2018-10-11 10:58:01,12.10,11.5
284,2018-10-11 10:58:11,12.10,11.5
285,2018-10-11 10:58:21,12.10,11.5
286,2018-10-11 10:58:31,12.10,11.5
287,2018-10-11 10:58:41,12.10,11.5
288,2018-10-11 10:58:51,12.10,11.5
289,2018-10-11 10:59:01,12.10,11.5
290,2018-10-11 10:59:11,12.10,11.5
291,2018-10-11 10:59:21,12.10,11.5
292,2018-10-11 10:59:31,12.10,11.5
293,2018-10-11 10:59:41,12.10,11.5
294,2018-10-11 10:59:51,12.10,11.5
295,2018-10-11 11:00:01,12.10,11.5
296,2018-10-11 11:00:11,12.10,11.5
297,2018-10-11 11:00:21,12.10,11.5
298,2018-10-11 11:00:31,12.10,11.5
299,2018-10-11 11:00:41,12.05,11.5
300,2018-10-11 11:00:51,12.05,11.5
301,2018-10-11 11:01:01,12.05,11.5
302,2018-10-11 11:01:11,12.05,11.5
303,2018-10-11 11:01:21,12.05,11.5
304,2018-10-11 11:01:31,12.05,11.5
305,2018-10-11 11:01:41,12.05,11.5
306,2018-10-11 11:01:51,12.05,11.5
307,2018-10-11 11:02:01,12.05,11.5
308,2018-10-11 11:02:11,12.05,11.5
309,2018-10-11 11:02:21,12.05,11.5
310,2018-10-11 11:02:31,12.05,11.5
311,2018-10-11 11:02:41,12.05,11.5
312,2018-10-11 11:02:51,12.05,11.5
313,2018-10-11 11:03:01,12.05,11.5
314,2018-10-11 11:03:11,12.05,11.5
315,2018-10-11 11:03:21,12.05,11.5
316,2018-10-11 11:03:31,12.05,11.5
317,2018-10-11 11:03:41,12.05,11.5
318,2018-10-11 11:03:51,12.05,11.5
319,2018-10-11 11:04:01,12.05,11.5
320,2018-10-11 11:04:11,12.05,11.5
321,2018-10-11 11:04:21,12.05,11.5
322,2018-10-11 11:04:31,12.05,11.5
323,2018-10-11 11:04:41,12.05,11.5
324,2018-10-11 11:04:51,12.05,11.5
325,2018-10-11 11:05:01,12.05,11.5
326,2018-10-11 11:05:11,12.05,11.5
327,2018-10-11 11:05:21,12.05,11.5
328,2018-10-11 11:05:31,12.05,11.5
329,2018-10-11 11:05:41,12.05,11.5
330,2018-10-11 11:05:51,12.05,11.5
331,2018-10-11 11:06:01,12.05,11.5
332,2018-10-11 11:06:11,12.05,11.5
333,2018-10-11 11:06:21,12.05,11.5
334,2018-10-11 11:06:31,12.05,11.5
335,2018-10-11 11:06:41,12.05,11.5
336,2018-10-11 11:06:51,12.05,11.5
337,2018-10-11 11:07:01,12.05,11.5
338,2018-10-11 11:07:11,12.00,11.5
339,2018-10-11 11:07:21,12.00,11.5
340,2018-10-11 11:07:31,12.00,11.5
341,2018-10-11 11:07:41,12.00,11.5
342,2018-10-11 11:07:51,12.00,11.5
343,2018-10-11 11:08:01,12.00,11.5
344,2018-10-11 11:08:11,12.00,11.5
345,2018-10-11 11:08:21,12.00,11.5
346,2018-10-11 11:08:31,12.00,11.5
347,2018-10-11 11:08:41,12.00,11.5
348,2018-10-11 11:08:51,12.00,11.5
349,2018-10-11 11:09:01,12.00,11.5
350,2018-10-11 11:09:11,12.00,11.5
351,2018-10-11 11:09:21,12.00,11.5
352,2018-10-11 11:09:31,12.00,11.5
353,2018-10-11 11:09:41,12.00,11.5
354,2018-10-11 11:09:51,12.00,11.5
355,2018-10-11 11:10:01,12.00,11.5
356,2018-10-11 11:10:11,12.00,11.5
357,2018-10-11 11:10:21,12.00,11.5
358,2018-10-11 11:10:31,12.00,11.5
359,2018-10-11 11:10:41,12.00,11.5
360,2018-10-11 11:10:51,12.00,11.5
361,2018-10-11 11:11:01,12.00,11.5
362,2018-10-11 11:11:11,12.00,11.5
363,2018-10-11 11:11:21,12.00,11.5
364,2018-10-11 11:11:31,12.00,11.5
365,2018-10-11 11:11:41,12.00,11.5
366,2018-10-11 11:11:51,12.00,11.5
367,2018-10-11 11:12:01,12.00,11.5
368,2018-10-11 11:12:11,12.00,11.5
369,2018-10-11 11:12:21,12.00,11.5
370,2018-10-11 11:12:31,12.00,11.5
371,2018-10-11 11:12:41,12.00,11.5
372,2018-10-11 11:12:51,12.00,11.5
373,2018-10-11 11:13:01,12.00,11.5
374,2018-10-11 11:13:11,12.00,11.5
375,2018-10-11 11:13:21,12.00,11.5
376,2018-10-11 11:13:31,11.95,11.5
377,2018-10-11 11:13:41,11.95,11.5
378,2018-10-11 11:13:51,11.95,11.5
379,2018-10-11 11:14:01,11.95,11.5
380,2018-10-11 11:14:11,11.95,11.5
381,2018-10-11 11:14:21,11.95,11.5
382,2018-10-11 11:14:31,11.95,11.5
383,2018-10-11 11:14:41,11.95,11.5
384,2018-10-11 11:14:51,11.95,11.5
385,2018-10-11 11:15:01,11.95,11.5
386,2018-10-11 11:15:11,11.95,11.5
387,2018-10-11 11:15:21,11.95,11.5
388,2018-10-11 11:15:31,11.95,11.5
389,2018-10-11 11:15:41,11.95,11.5
390,2018-10-11 11:15:51,11.95,11.5
391,2018-10-11 11:16:01,11.95,11.5
392,2018-10-11 11:16:11,11.95,11.5
393,2018-10-11 11:16:21,11.95,11.5
394,2018-10-11 11:16:31,11.95,11.5
395,2018-10-11 11:16:41,11.95,11.5
396,2018-10-11 11:16:51,11.95,11.5
397,2018-10-11 11:17:01,11.95,11.5
398,2018-10-11 11:17:11,11.95,11.5
399,2018-10-11 11:17:21,11.95,11.5
400,2018-10-11 11:17:31,11.95,11.5
401,2018-10-11 11:17:41,11.95,11.5
402,2018-10-11 11:17:51,11.95,11.5
403,2018-10-11 11:18:01,11.95,11.5
404,2018-10-11 11:18:11,11.95,11.5
405,2018-10-11 11:18:21,11.95,11.5
406,2018-10-11 11:18:31,11.95,11.5
407,2018-10-11 11:18:41,11.95,11.5
408,2018-10-11 11:18:51,11.95,11.5
409,2018-10-11 11:19:01,11.95,11.5
410,2018-10-11 11:19:11,11.95,11.5
411,2018-10-11 11:19:21,11.90,11.5
412,2018-10-11 11:19:31,11.95,11.5
413,2018-10-11 11:19:41,11.90,11.5
414,2018-10-11 11:19:51,11.90,11.5
415,2018-10-11 11:20:01,11.90,11.5
416,2018-10-11 11:20:11,11.90,11.5
417,2018-10-11 11:20:21,11.90,11.5
418,2018-10-11 11:20:31,11.90,11.5
419,2018-10-11 11:20:41,11.90,11.5
420,2018-10-11 11:20:51,11.90,11.5
421,2018-10-11 11:21:01,11.90,11.5
422,2018-10-11 11:21:11,11.90,11.5
423,2018-10-11 11:21:21,11.90,11.5
424,2018-10-11 11:21:31,11.90,11.5
425,2018-10-11 11:21:41,11.90,11.5
426,2018-10-11 11:21:51,11.90,11.5
427,2018-10-11 11:22:01,11.90,11.5
428,2018-10-11 11:22:11,11.90,11.5
429,2018-10-11 11:22:21,11.90,11.5
430,2018-10-11 11:22:31,11.90,11.5
431,2018-10-11 11:22:41,11.90,11.5
432,2018-10-11 11:22:51,11.90,11.5
433,2018-10-11 11:23:01,11.90,11.5
434,2018-10-11 11:23:11,11.90,11.5
435,2018-10-11 11:23:21,11.90,11.5
436,2018-10-11 11:23:31,11.90,11.5
437,2018-10-11 11:23:41,11.90,11.5
438,2018-10-11 11:23:51,11.90,11.5
439,2018-10-11 11:24:01,11.90,11.5
440,2018-10-11 11:24:11,11.90,11.5
441,2018-10-11 11:24:21,11.90,11.5
442,2018-10-11 11:24:31,11.90,11.5
443,2018-10-11 11:24:41,11.90,11.5
444,2018-10-11 11:24:51,11.90,11.5
445,2018-10-11 11:25:01,11.90,11.5
446,2018-10-11 11:25:11,11.90,11.5
447,2018-10-11 11:25:21,11.90,11.5
448,2018-10-11 11:25:31,11.85,11.5
449,2018-10-11 11:25:41,11.90,11.5
450,2018-10-11 11:25:51,11.90,11.5
451,2018-10-11 11:26:01,11.85,11.5
452,2018-10-11 11:26:11,11.85,11.5
453,2018-10-11 11:26:21,11.85,11.5
454,2018-10-11 11:26:31,11.85,11.5
455,2018-10-11 11:26:41,11.85,11.5
456,2018-10-11 11:26:51,11.85,11.5
457,2018-10-11 11:27:01,11.85,11.5
458,2018-10-11 11:27:11,11.85,11.5
459,2018-10-11 11:27:21,11.85,11.5
460,2018-10-11 11:27:31,11.85,11.5
461,2018-10-11 11:27:41,11.85,11.5
462,2018-10-11 11:27:51,11.85,11.5
463,2018-10-11 11:28:01,11.85,11.5
464,2018-10-11 11:28:11,11.85,11.5
465,2018-10-11 11:28:21,11.85,11.5
466,2018-10-11 11:28:31,11.85,11.5
467,2018-10-11 11:28:41,11.85,11.5
468,2018-10-11 11:28:51,11.85,11.5
469,2018-10-11 11:29:01,11.85,11.5
470,2018-10-11 11:29:11,11.85,11.5
471,2018-10-11 11:29:21,11.85,11.5
472,2018-10-11 11:29:31,11.85,11.5
473,2018-10-11 11:29:41,11.85,11.5
474,2018-10-11 11:29:51,11.85,11.5
475,2018-10-11 11:30:01,11.85,11.5
476,2018-10-11 11:30:11,11.85,11.5
477,2018-10-11 11:30:21,11.85,11.5
478,2018-10-11 11:30:31,11.85,11.5
479,2018-10-11 11:30:41,11.85,11.5
480,2018-10-11 11:30:51,11.85,11.5
481,2018-10-11 11:31:01,11.85,11.5
482,2018-10-11 11:31:11,11.85,11.5
483,2018-10-11 11:31:21,11.85,11.5
484,2018-10-11 11:31:31,11.85,11.5
485,2018-10-11 11:31:41,11.80,11.5
486,2018-10-11 11:31:51,11.80,11.5
487,2018-10-11 11:32:01,11.80,11.5
488,2018-10-11 11:32:11,11.80,11.5
489,2018-10-11 11:32:21,11.80,11.5
490,2018-10-11 11:32:31,11.80,11.5
491,2018-10-11 11:32:41,11.80,11.5
492,2018-10-11 11:32:51,11.80,11.5
493,2018-10-11 11:33:01,11.80,11.5
494,2018-10-11 11:33:11,11.80,11.5
495,2018-10-11 11:33:21,11.80,11.5
496,2018-10-11 11:33:31,11.80,11.5
497,2018-10-11 11:33:41,11.80,11.5
498,2018-10-11 11:33:51,11.80,11.5
499,2018-10-11 11:34:01,11.80,11.5
500,2018-10-11 11:34:11,11.80,11.5
501,2018-10-11 11:34:21,11.80,11.5
502,2018-10-11 11:34:31,11.80,11.5
503,2018-10-11 11:34:41,11.80,11.5
504,2018-10-11 11:34:51,11.80,11.5
505,2018-10-11 11:35:01,11.80,11.5
506,2018-10-11 11:35:11,11.80,11.5
507,2018-10-11 11:35:21,11.80,11.5
508,2018-10-11 11:35:31,11.80,11.5
509,2018-10-11 11:35:41,11.80,11.5
510,2018-10-11 11:35:51,11.80,11.5
511,2018-10-11 11:36:01,11.80,11.5
512,2018-10-11 11:36:11,11.80,11.5
513,2018-10-11 11:36:21,11.80,11.5
514,2018-10-11 11:36:31,11.80,11.5
515,2018-10-11 11:36:41,11.80,11.5
516,2018-10-11 11:36:51,11.80,11.5
517,2018-10-11 11:37:01,11.75,11.5
518,2018-10-11 11:37:11,11.75,11.5
519,2018-10-11 11:37:21,11.75,11.5
520,2018-10-11 11:37:31,11.75,11.5
521,2018-10-11 11:37:41,11.75,11.5
522,2018-10-11 11:37:51,11.75,11.5
523,2018-10-11 11:38:01,11.75,11.5
524,2018-10-11 11:38:11,11.75,11.5
525,2018-10-11 11:38:21,11.75,11.5
526,2018-10-11 11:38:31,11.75,11.5
527,2018-10-11 11:38:41,11.75,11.5
528,2018-10-11 11:38:51,11.75,11.5
529,2018-10-11 11:39:01,11.75,11.5
530,2018-10-11 11:39:11,11.75,11.5
531,2018-10-11 11:39:21,11.75,11.5
532,2018-10-11 11:39:31,11.75,11.5
533,2018-10-11 11:39:41,11.75,11.5
534,2018-10-11 11:39:51,11.75,11.5
535,2018-10-11 11:40:01,11.75,11.5
536,2018-10-11 11:40:11,11.75,11.5
537,2018-10-11 11:40:21,11.75,11.5
538,2018-10-11 11:40:31,11.75,11.5
539,2018-10-11 11:40:41,11.75,11.5
540,2018-10-11 11:40:51,11.75,11.5
541,2018-10-11 11:41:01,11.75,11.5
542,2018-10-11 11:41:11,11.75,11.5
543,2018-10-11 11:41:21,11.75,11.5
544,2018-10-11 11:41:31,11.75,11.5
545,2018-10-11 11:41:41,11.75,11.5
546,2018-10-11 11:41:51,11.70,11.5
547,2018-10-11 11:42:01,11.70,11.5
548,2018-10-11 11:42:11,11.70,11.5
549,2018-10-11 11:42:21,11.70,11.5
550,2018-10-11 11:42:31,11.70,11.5
551,2018-10-11 11:42:41,11.70,11.5
552,2018-10-11 11:42:51,11.70,11.5
553,2018-10-11 11:43:01,11.70,11.5
554,2018-10-11 11:43:11,11.70,11.5
555,2018-10-11 11:43:21,11.70,11.5
556,2018-10-11 11:43:31,11.70,11.5
557,2018-10-11 11:43:41,11.70,11.5
558,2018-10-11 11:43:51,11.70,11.5
559,2018-10-11 11:44:01,11.70,11.5
560,2018-10-11 11:44:11,11.70,11.5
561,2018-10-11 11:44:21,11.70,11.5
562,2018-10-11 11:44:31,11.70,11.5
563,2018-10-11 11:44:41,11.70,11.5
564,2018-10-11 11:44:51,11.70,11.5
565,2018-10-11 11:45:01,11.70,11.5
566,2018-10-11 11:45:11,11.70,11.5
567,2018-10-11 11:45:21,11.70,11.5
568,2018-10-11 11:45:31,11.70,11.5
569,2018-10-11 11:45:41,11.70,11.5
570,2018-10-11 11:45:51,11.70,11.5
571,2018-10-11 11:46:01,11.70,11.5
572,2018-10-11 11:46:11,11.70,11.5
573,2018-10-11 11:46:21,11.70,11.5
574,2018-10-11 11:46:31,11.70,11.5
575,2018-10-11 11:46:41,11.70,11.5
576,2018-10-11 11:46:51,11.70,11.5
577,2018-10-11 11:47:01,11.65,11.5
578,2018-10-11 11:47:11,11.65,11.5
579,2018-10-11 11:47:21,11.65,11.5
580,2018-10-11 11:47:31,11.65,11.5
581,2018-10-11 11:47:41,11.65,11.5
582,2018-10-11 11:47:51,11.65,11.5
583,2018-10-11 11:48:01,11.65,11.5
584,2018-10-11 11:48:11,11.65,11.5
585,2018-10-11 11:48:21,11.65,11.5
586,2018-10-11 11:48:31,11.65,11.5
587,2018-10-11 11:48:41,11.65,11.5
588,2018-10-11 11:48:51,11.65,11.5
589,2018-10-11 11:49:01,11.65,11.5
590,2018-10-11 11:49:11,11.65,11.5
591,2018-10-11 11:49:21,11.65,11.5
592,2018-10-11 11:49:31,11.65,11.5
593,2018-10-11 11:49:41,11.65,11.5
594,2018-10-11 11:49:51,11.65,11.5
595,2018-10-11 11:50:01,11.65,11.5
596,2018-10-11 11:50:11,11.65,11.5
597,2018-10-11 11:50:21,11.65,11.5
598,2018-10-11 11:50:31,11.65,11.5
599,2018-10-11 11:50:41,11.65,11.5
600,2018-10-11 11:50:51,11.65,11.5
601,2018-10-11 11:51:01,11.65,11.5
602,2018-10-11 11:51:11,11.60,11.5
603,2018-10-11 11:51:21,11.60,11.5
604,2018-10-11 11:51:31,11.60,11.5
605,2018-10-11 11:51:41,11.60,11.5
606,2018-10-11 11:51:51,11.60,11.5
607,2018-10-11 11:52:01,11.60,11.5
608,2018-10-11 11:52:11,11.60,11.5
609,2018-10-11 11:52:21,11.60,11.5
610,2018-10-11 11:52:31,11.60,11.5
611,2018-10-11 11:52:41,11.60,11.5
612,2018-10-11 11:52:51,11.60,11.5
613,2018-10-11 11:53:01,11.60,11.5
614,2018-10-11 11:53:11,11.60,11.5
615,2018-10-11 11:53:21,11.60,11.5
616,2018-10-11 11:53:31,11.60,11.5
617,2018-10-11 11:53:41,11.60,11.5
618,2018-10-11 11:53:51,11.60,11.5
619,2018-10-11 11:54:01,11.60,11.5
620,2018-10-11 11:54:11,11.60,11.5
621,2018-10-11 11:54:21,11.60,11.5
622,2018-10-11 11:54:31,11.60,11.5
623,2018-10-11 11:54:41,11.60,11.5
624,2018-10-11 11:54:51,11.60,11.5
625,2018-10-11 11:55:01,11.60,11.5
626,2018-10-11 11:55:11,11.60,11.5
627,2018-10-11 11:55:21,11.55,11.5
628,2018-10-11 11:55:31,11.60,11.5
629,2018-10-11 11:55:41,11.55,11.5
630,2018-10-11 11:55:51,11.55,11.5
631,2018-10-11 11:56:01,11.55,11.5
632,2018-10-11 11:56:11,11.55,11.5
633,2018-10-11 11:56:21,11.55,11.5
634,2018-10-11 11:56:31,11.55,11.5
635,2018-10-11 11:56:41,11.55,11.5
636,2018-10-11 11:56:51,11.55,11.5
637,2018-10-11 11:57:01,11.55,11.5
638,2018-10-11 11:57:11,11.55,11.5
639,2018-10-11 11:57:21,11.55,11.5
640,2018-10-11 11:57:31,11.55,11.5
641,2018-10-11 11:57:41,11.55,11.5
642,2018-10-11 11:57:51,11.55,11.5
643,2018-10-11 11:58:01,11.55,11.5
644,2018-10-11 11:58:11,11.55,11.5
645,2018-10-11 11:58:21,11.55,11.5
646,2018-10-11 11:58:31,11.55,11.5
647,2018-10-11 11:58:41,11.55,11.5
648,2018-10-11 11:58:51,11.55,11.5
649,2018-10-11 11:59:01,11.55,11.5
650,2018-10-11 11:59:11,11.55,11.5
651,2018-10-11 11:59:21,11.50,11.5
652,2018-10-11 11:59:31,11.55,11.5
653,2018-10-11 11:59:41,11.55,11.5
654,2018-10-11 11:59:51,11.50,11.5
655,2018-10-11 12:00:01,11.50,11.5
656,2018-10-11 12:00:11,11.50,11.5
657,2018-10-11 12:00:21,11.50,11.5
658,2018-10-11 12:00:31,11.50,11.5
659,2018-10-11 12:00:41,11.50,11.5
660,2018-10-11 12:00:51,11.50,11.5
661,2018-10-11 12:01:01,11.50,11.5
662,2018-10-11 12:01:11,11.50,11.5
663,2018-10-11 12:01:21,11.50,11.5
664,2018-10-11 12:01:31,11.50,11.5
665,2018-10-11 12:01:41,11.50,11.5
666,2018-10-11 12:01:51,11.50,11.5
667,2018-10-11 12:02:01,11.50,11.5
668,2018-10-11 12:02:11,11.50,11.5
669,2018-10-11 12:02:21,11.50,11.5
670,2018-10-11 12:02:31,11.50,11.5
671,2018-10-11 12:02:41,11.50,11.5
672,2018-10-11 12:02:51,11.50,11.5
673,2018-10-11 12:03:01,11.50,11.5
674,2018-10-11 12:03:11,11.45,11.5
675,2018-10-11 12:03:21,11.50,11.5
676,2018-10-11 12:03:31,11.45,11.5
677,2018-10-11 12:03:41,11.45,11.5
678,2018-10-11 12:03:51,11.45,11.5
679,2018-10-11 12:04:01,11.45,11.5
680,2018-10-11 12:04:11,11.45,11.5
681,2018-10-11 12:04:21,11.45,11.5
682,2018-10-11 12:04:31,11.45,11.5
683,2018-10-11 12:04:41,11.45,11.5
684,2018-10-11 12:04:51,11.45,11.5
685,2018-10-11 12:05:01,11.45,11.5
686,2018-10-11 12:05:11,11.45,11.5
687,2018-10-11 12:05:21,11.45,11.5
688,2018-10-11 12:05:31,11.45,11.5
689,2018-10-11 12:05:41,11.45,11.5
690,2018-10-11 12:05:51,11.45,11.5
691,2018-10-11 12:06:01,11.45,11.5
692,2018-10-11 12:06:11,11.45,11.5
693,2018-10-11 12:06:21,11.45,11.5
694,2018-10-11 12:06:31,11.45,11.5
695,2018-10-11 12:06:41,11.45,11.5
696,2018-10-11 12:06:51,11.45,11.5
697,2018-10-11 12:07:01,11.45,11.5
698,2018-10-11 12:07:11,11.45,11.5
699,2018-10-11 12:07:21,11.40,11.5
700,2018-10-11 12:07:31,11.40,11.5
701,2018-10-11 12:07:41,11.40,11.5
702,2018-10-11 12:07:51,11.40,11.5
703,2018-10-11 12:08:01,11.40,11.5
704,2018-10-11 12:08:11,11.40,11.5
705,2018-10-11 12:08:21,11.40,11.5
706,2018-10-11 12:08:31,11.40,11.5
707,2018-10-11 12:08:41,11.40,11.5
708,2018-10-11 12:08:51,11.40,11.5
709,2018-10-11 12:09:01,11.40,11.5
710,2018-10-11 12:09:11,11.40,11.5
711,2018-10-11 12:09:21,11.40,11.5
712,2018-10-11 12:09:31,11.40,11.5
713,2018-10-11 12:09:41,11.40,11.5
714,2018-10-11 12:09:51,11.40,11.5
715,2018-10-11 12:10:01,11.40,11.5
716,2018-10-11 12:10:11,11.40,11.5
717,2018-10-11 12:10:21,11.40,11.5
718,2018-10-11 12:10:31,11.40,11.5
719,2018-10-11 12:10:41,11.40,11.5
720,2018-10-11 12:10:51,11.35,11.5
721,2018-10-11 12:11:01,11.35,11.5
722,2018-10-11 12:11:11,11.35,11.5
723,2018-10-11 12:11:21,11.35,11.5
724,2018-10-11 12:11:31,11.35,11.5
725,2018-10-11 12:11:41,11.35,11.5
726,2018-10-11 12:11:51,11.35,11.5
727,2018-10-11 12:12:01,11.35,11.5
728,2018-10-11 12:12:11,11.35,11.5
729,2018-10-11 12:12:21,11.35,11.5
730,2018-10-11 12:12:31,11.35,11.5
731,2018-10-11 12:12:41,11.35,11.5
732,2018-10-11 12:12:51,11.35,11.5
733,2018-10-11 12:13:01,11.35,11.5
734,2018-10-11 12:13:11,11.35,11.5
735,2018-10-11 12:13:21,11.35,11.5
736,2018-10-11 12:13:31,11.35,11.5
737,2018-10-11 12:13:41,11.35,11.5
738,2018-10-11 12:13:51,11.35,11.5
739,2018-10-11 12:14:01,11.30,11.5
740,2018-10-11 12:14:11,11.30,11.5
741,2018-10-11 12:14:21,11.30,11.5
742,2018-10-11 12:14:31,11.30,11.5
743,2018-10-11 12:14:41,11.30,11.5
744,2018-10-11 12:14:51,11.30,11.5
745,2018-10-11 12:15:01,11.30,11.5
746,2018-10-11 12:15:11,11.30,11.5
747,2018-10-11 12:15:21,11.30,11.5
748,2018-10-11 12:15:31,11.30,11.5
749,2018-10-11 12:15:41,11.30,11.5
750,2018-10-11 12:15:51,11.30,11.5
751,2018-10-11 12:16:01,11.30,11.5
752,2018-10-11 12:16:11,11.30,11.5
753,2018-10-11 12:16:21,11.30,11.5
754,2018-10-11 12:16:31,11.30,11.5
755,2018-10-11 12:16:41,11.25,11.5
756,2018-10-11 12:16:51,11.30,11.5
757,2018-10-11 12:17:01,11.25,11.5
758,2018-10-11 12:17:11,11.25,11.5
759,2018-10-11 12:17:21,11.25,11.5
760,2018-10-11 12:17:31,11.25,11.5
761,2018-10-11 12:17:41,11.25,11.5
762,2018-10-11 12:17:51,11.25,11.5
763,2018-10-11 12:18:01,11.25,11.5
764,2018-10-11 12:18:11,11.25,11.5
765,2018-10-11 12:18:21,11.25,11.5
766,2018-10-11 12:18:31,11.25,11.5
767,2018-10-11 12:18:41,11.25,11.5
768,2018-10-11 12:18:51,11.25,11.5
769,2018-10-11 12:19:01,11.25,11.5
770,2018-10-11 12:19:11,11.20,11.5
771,2018-10-11 12:19:21,11.20,11.5
772,2018-10-11 12:19:31,11.20,11.5
773,2018-10-11 12:19:41,11.20,11.5
774,2018-10-11 12:19:51,11.20,11.5
775,2018-10-11 12:20:01,11.20,11.5
776,2018-10-11 12:20:11,11.20,11.5
777,2018-10-11 12:20:21,11.20,11.5
778,2018-10-11 12:20:31,11.20,11.5
779,2018-10-11 12:20:41,11.20,11.5
780,2018-10-11 12:20:51,11.20,11.5
781,2018-10-11 12:21:01,11.20,11.5
782,2018-10-11 12:21:11,11.20,11.5
783,2018-10-11 12:21:21,11.20,11.5
784,2018-10-11 12:21:31,11.15,11.5
785,2018-10-11 12:21:41,11.15,11.5
786,2018-10-11 12:21:51,11.15,11.5
787,2018-10-11 12:22:01,11.15,11.5
788,2018-10-11 12:22:11,11.15,11.5
789,2018-10-11 12:22:21,11.15,11.5
790,2018-10-11 12:22:31,11.15,11.5
791,2018-10-11 12:22:41,11.15,11.5
792,2018-10-11 12:22:51,11.15,11.5
793,2018-10-11 12:23:01,11.15,11.5
794,2018-10-11 12:23:11,11.15,11.5
795,2018-10-11 12:23:21,11.15,11.5
796,2018-10-11 12:23:31,11.15,11.5
797,2018-10-11 12:23:41,11.10,11.5
798,2018-10-11 12:23:51,11.10,11.5
799,2018-10-11 12:24:01,11.10,11.5
800,2018-10-11 12:24:11,11.10,11.5
801,2018-10-11 12:24:21,11.10,11.5
802,2018-10-11 12:24:31,11.10,11.5
803,2018-10-11 12:24:41,11.10,11.5
804,2018-10-11 12:24:51,11.10,11.5
805,2018-10-11 12:25:01,11.10,11.5
806,2018-10-11 12:25:11,11.10,11.5
807,2018-10-11 12:25:21,11.55,11.5
808,2018-10-11 12:25:31,11.60,11.5
809,2018-10-11 12:25:41,11.65,11.5
810,2018-10-11 12:25:51,11.65,11.5
811,2018-10-11 12:26:01,11.65,11.5
812,2018-10-11 12:26:11,11.65,11.5
813,2018-10-11 12:26:21,11.65,11.5
814,2018-10-11 12:26:31,11.70,11.5
815,2018-10-11 12:26:41,11.70,11.5
816,2018-10-11 12:26:51,11.70,11.5
817,2018-10-11 12:27:01,11.70,11.5
818,2018-10-11 12:27:11,11.70,11.5
819,2018-10-11 12:27:21,11.70,11.5
820,2018-10-11 12:27:31,11.70,11.5
821,2018-10-11 12:27:41,11.70,11.5
822,2018-10-11 12:27:51,11.75,11.5
823,2018-10-11 12:28:01,11.75,11.5
824,2018-10-11 12:28:11,11.75,11.5
825,2018-10-11 12:28:21,11.75,11.5
826,2018-10-11 12:28:31,11.75,11.5
827,2018-10-11 12:28:41,11.75,11.5
828,2018-10-11 12:28:51,11.75,11.5
829,2018-10-11 12:29:01,11.75,11.5
830,2018-10-11 12:29:11,11.75,11.5
831,2018-10-11 12:29:21,11.75,11.5
832,2018-10-11 12:29:31,11.75,11.5
833,2018-10-11 12:29:41,11.75,11.5
834,2018-10-11 12:29:51,11.75,11.5
835,2018-10-11 12:30:01,11.80,11.5
836,2018-10-11 12:30:11,11.80,11.5
837,2018-10-11 12:30:21,0.05,11.5
838,2018-10-11 12:30:31,0.05,11.5
839,2018-10-11 12:30:41,0.05,11.5
840,2018-10-11 12:30:51,0.05,11.5
841,2018-10-11 12:31:01,0.05,11.5
842,2018-10-11 12:31:11,0.05,11.5
843,2018-10-11 12:31:21,0.00,11.5
844,2018-10-11 12:31:31,0.10,11.5
845,2018-10-11 12:31:41,0.05,11.5

Yes you can use excel to parse the data and then graph it however you
want and although I've not done it for years,get a macro to do the whole
thing for you - but might involve some visual basic as well.
But The easy log graph software allows you to draw a box round the
graphical data points of interest and re plot them thus giving scope
for zooming in and drawing a suppressed zero y axis (and X axis for that
matter). Not sure if you can save that within easy log or maybe just
take screen shots when you hare happy with the format?

Might be a lot easier if you are not a spreadsheet wizard.

hth
Bob
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Popular transistor data in spreadsheet format? Don Kuenz Electronics Repair 22 July 10th 14 07:24 PM
Where Can I find a company that feeds property sales data? (not zillow where I type it one by one - but can query the data feed company programmatically)? Does anyone know who sells something like this? Zodex Home Repair 2 August 28th 08 04:03 PM
anyone know a good mortgage comparison spreadsheet? [email protected] Home Ownership 3 July 21st 06 07:26 AM
Electrical estimating spreadSheet? ashnook UK diy 0 March 3rd 06 08:42 AM
Excel spreadsheet for cutting gears using a rotary table [email protected] Metalworking 4 December 15th 04 04:23 AM


All times are GMT +1. The time now is 08:24 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 DIYbanter.
The comments are property of their posters.
 

About Us

"It's about DIY & home improvement"