a) Go to the "File”, “Open" function and
select ‘Files of type’ “All files
(*.*)”.
b) You will now be able to see the logged data of the LCS
software with a ".ldt" at the end.
c) Select the LCS file you want to import.
d) Though its a unknown format, Excel will open the Text
Import Wizard like shown on picture below:
e) Change to the next window with "Next".
f) The next window will look like shown in picture
below:
g) In this window change the separator to
"Semicolon".
h) After this the logger data will show in the correct
column and look like in picture below:
i) Now again change to the next window with "Next".
j) Only change the data format of the first column to data
(Date, see picture below):
That’s it!
k) Finish the import function with "Finish"
l) The data will now show up as seen on picture
below:
The structure of each sweep (row) is the same:
- DATE & TIME
- Peak 1 Frequency (MHz)
- Peak 1 Value (dBm)
- Peak 2 Frequency (MHz)
- Peak 2 Value (dBm)
- Peak 3 Frequency (MHz)
- Peak 3 Value (dBm)
- First frequency value (dBm)
- Second frequency value (dBm)
- Third frequency value (dBm)
- etc.
Please note:
- The screenshots are made with the English version of Microsoft Excel but it should be easy to understand the above instructions.
- The number of the stored peaks depends on how many markers you have set in the LCS software (1 to 10 possible).
- The number of frequency values depends on span and used filter. The higher the span and the smaller the used filter the more frequency values will be stored per sweep.
- The first frequency value is always set to -170.00 to better identify the start of the frequency value data.
- The frequency step between each frequency value is always the same. In our example it is 1.5MHz. The higher the span and the smaller the used filter the smaller the steps will be.
- The smallest time value shown is one second. Smaller time segments simply can be identified by the number of rows between each second.
