Spreadsheet type data manipulation?

Oct 11, 2018 6 Replies
T

Hi all,



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



formatting link



.. 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
Vote
Twitter Facebook LinkedIn
S

See here:

formatting link

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

Vote
Twitter Facebook LinkedIn
S

and this one with the time labels corrected

formatting link

Owain

Vote
Twitter Facebook LinkedIn
T

Sweet (thanks). ;-)

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 , 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

Vote
Twitter Facebook LinkedIn
T

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. ;-)

Vote
Twitter Facebook LinkedIn
S

Presumably they can be taken out or adjusted. This is the first time I've u sed 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 m aipulation carried out. Just formatted the time column to 'Time' and the ax is value to HH:MM:SS (on the second try!)

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

Owain

Vote
Twitter Facebook LinkedIn
B

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

Vote
Twitter Facebook LinkedIn

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required