TestO Datalogger - what do you think?

[jcafe]

Hello Pingu,
I try to use your Excel file but it doesn't work.
I tried everything, but it's impossible.
Could you check my testo log .csv file, and tell me if I do something bad, or tell me what I have exactly to do to make it work.
Thank you so much

 

[Brian H]

@Pingu ^^^^

 

[Pingu]

Hello Pingu,
I try to use your Excel file but it doesn't work.
I tried everything, but it's impossible.
Could you check my testo log .csv file, and tell me if I do something bad, or tell me what I have exactly to do to make it work.
Thank you so much

The spreadsheet that I posted was for data from a different dataset. Here is your data pasted into an old spreadsheet I had...

(the file is 4Mb)

http://www.porterbility.co.uk/Files/XLS/2017-10-07-180150_jcafe.xlsx

Here is the data that I have not loaded, as it was not part of my original spreadsheet...

http://www.porterbility.co.uk/Files/XLS/2017-10-07-180150_jcafe.csv

 

[jcafe]

Thank you so much ! And now, if I want to load new data, what have I to do ? Have I to copy past each data, or is there a fast method to load all data ?

 

[Pingu]

Thank you so much ! And now, if I want to load new data, what have I to do ? Have I to copy past each data, or is there a fast method to load all data ?

Load the module below and save the spreadsheet into an xlsm file.

http://www.porterbility.co.uk/Files/XLS/2017-10-07-180150_jcafe.txt

To load new data, copy the data saved from TestO into the appropriate column in the Raw Data sheet.

Do not delete any lines manually as they are linked to Graph Data. Use z_Delete_Data to delete your data.

You need to be in Graph Data when you run the macro a_Prepare_Data. It will copy all the data from Raw Data and it will prepare the data ready to produce the graphs.

To produce the graphs, insert the start and finish lines in the red boxes in Graph Data and run the appropriate graph macro.

 

[Pingu]

@jcafe . Post added in case you read the previous post before I edited it.

 

[jcafe]

Thanks you, for make a new graph Excel macro crash my Mac lol.
I will try to develop an online version (PHP/JS).
If forum members can give their testo log file. Csv, so that I could create the graph with real scales without bug

 

[Pingu]

I used TestO data to create the graphic that shows the relative valve-piston positions.

 

[Dalek]

I’m just glad the car starts when I turn the key!