Introduction: This page describes more or less how to import and read raw log files generated by ESI Viewpoint software. This page does not go into depth on the actual structure of raw log files.

Using Excel, open a file called “mp917macros.xls” and “Enable macros”. Open the TDR rawlog file. You will have to import it as a “delimited” file. The delimiters used will be “tab”, “space” and “|” (the last one will be typed in the “other” box. Please save the imported log file as an Excel Workbook. You will see for starters:

File comments look like this:

Raw scans start like this:

And end like this:

Choose the cell at the start of the raw scan that has “RAW” in it (And only “RAW”. Any other cell will screw up the data bigtime). Press ALT+F8. Choose mp917macros.XLS!RawTDRtraceImport and run. You will see that the macro copies the date and time of the TDR measurement and the data, arranges it on a new excel worksheet and calculates the time. Should the time not be calculated (you will see that in the column all the values are 0) go into the Tools/Option/Calculation menu and set to “Automatic” under calculation. Press “Calc now” and then “OK”.

Two columns should be selected automatically. Go to the \Insert\Chart menu. Double click on XY Scatter. You will see an example of the chart on the screen. Click next. Make the chart title “<sample> <depth> <date> <time>”. Click next. Save the chart as a new sheet and name the sheet after the time. Instead of colons “:” use periods “.” Such the “9:53:46” will appear as “9.53.46”.

On the chart that appears press ALT+F8. Run the macro mp917macros.XLS!NewChartFormat. You will see that it does some stuff to the chart, such as ridding it of the legend, the gray background, and adding to the X-axis “Time (ns)” and “Impedance” to the Y-axis. Double click on the Y-Axis. Reset the Maximum value in the Scale sheet to 250. (unless the trace exceeds 250, in which case it should be 260).

Rename the new worksheet from “sheet1” to “<chart sheet name>.d”. That is to say, if the chart’s name is “9.53.46” then “sheet1” will become “9.53.46.d”. Return to the main TDR log sheet and hit “Page Down” on the keyboard till you reach the next Raw Scan.

Please hit save on occasion. I usually do after every 3-4 imported and scans, on the “RAW” cell of the next trace that I am going to import.

Click here for the MP-917 macros file, mp917macros.zip

Click here for more information on the ESI Environmental Sensors MP-917 TDR

Up to the top of the page

Back to Guy Serbin's TDR page

Questions, comments, suggestions? Email me.