![LeCroy WaveRunner 104MXI Operator'S Manual Download Page 181](http://html1.mh-extra.com/html/lecroy/waverunner-104mxi/waverunner-104mxi_operators-manual_1866369181.webp)
O
PERATOR
’
S
M
ANUAL
WRXi-OM-E Rev B
181
Exponential Decay Time Constant Excel Parameter (Excel Example 1)
This example calculates the time constant of an exponentially falling pulse, such as the light output of a phosphor.
The first figure shows a typical pulse, including pseudo-random noise, generated by a VBScript.
The pulse was generated by a formula of the form e
(1 – t/TC1)
* e
-t/TC2
, where TC1 and TC2 are time constants, The
requirement is to measure the time constant TC2, using the portion of the trace where TC1 has negligible effect.
This was done using Function F1, which is not a part of the measurement process.
For the actual measurement, Parameter P1 was set up as an Excel call. In Excel, the selected portion of the trace
was converted to logarithms, and the Excel function SLOPE was used, as shown here.
Here we see the input data in column B (with a time scale in A) created using the contents of cell F9, Horizontal
Per Step. The logarithmic data are in column D, with the time scale repeated in C. The output appears in cell H3,
using the formula
=1/SLOPE(D21:D51,C21:C51)
.