Hi,
I am using the datataker to record 10 schedules. I notice the default data output is not very user friendly to bring into excel. The data is of the format:
2011/05/06 16:16:14 0.027099 1L -198.3888 ppm
2011/05/06 16:16:14 0.027099 2L -11.53183 ppm
2011/05/06 16:16:14 0.027099 3L -204.0634 ppm
2011/05/06 16:16:14 0.290405 1L -199.2348 ppm
2011/05/06 16:16:14 0.290405 2L -9.45050 ppm
2011/05/06 16:16:14 0.290405 3L -204.3279 ppm
Is there a way to change the data output to something more user friendly i.e.
Time Stamp1 1L -198.3888 2L -11.531 3L -204.3279
Time Stamp2 1L -199.2348 2L -9.45 3L -204.3279
It is just really difficult to get a trend graph in excel with the default output. Sort of need a macro otherwise. Also, does anyone have issues with the time stamp being separated, I'm looking to determine the time step between readings which is hard given the space between the time value and remainder of seconds.
Thanks
Hi,
I am using the datataker to record 10 schedules. I notice the default data output is not very user friendly to bring into excel. The data is of the format:
````
2011/05/06 16:16:14 0.027099 1L -198.3888 ppm
2011/05/06 16:16:14 0.027099 2L -11.53183 ppm
2011/05/06 16:16:14 0.027099 3L -204.0634 ppm
2011/05/06 16:16:14 0.290405 1L -199.2348 ppm
2011/05/06 16:16:14 0.290405 2L -9.45050 ppm
2011/05/06 16:16:14 0.290405 3L -204.3279 ppm
````
Is there a way to change the data output to something more user friendly i.e.
````
Time Stamp1 1L -198.3888 2L -11.531 3L -204.3279
Time Stamp2 1L -199.2348 2L -9.45 3L -204.3279
````
It is just really difficult to get a trend graph in excel with the default output. Sort of need a macro otherwise. Also, does anyone have issues with the time stamp being separated, I'm looking to determine the time step between readings which is hard given the space between the time value and remainder of seconds.
Thanks