User manual

127
Fig. 4.17.2. The Spreadsheet/AmpFile Options dialog box with the AmpFile Type tab chosen.
4.17.1 AMP Text and XLS File Structure
When the Spreadsheet data is saved to an ASCII text AmpFile, the structure of an AMP text file will be
similar to the example shown in Fig. 4.17.1.1. In this example the DC, PkAmp, Rs and Rm analyses were
calculated, but the Lat, Dur, RiseTm, DecTm, Area, CoastLn, PSamp, PSlat, Slope and AvgAmp analyses
were not, and column place was kept by putting in a double quote “”.
Note that DC, PkAmp, CoastLn, PSamp and AvgAmp are in Units (either pA here, or mV or V); Lat, Dur,
RiseTm, DecTm and PSlat are in ms; Area is in unit*ms; Slope is in unit/ms; and Rs and Rm are either in
Mohm (or Units of pA where they have to be converted to Mohms; see Sections 4.11.11 and 4.11.12).
Alternatively, the Spreadsheet data can be saved to an XLS file that can be directly loaded into Excel (Fig.
4.17.1.2). Since only the DC, PkAmp, Rs and Rm analyses were calculated in this example, only they are
printed. The Lat, Dur, RiseTm, DecTm, Area, CoastLn, PSamp, PSlat, Slope and AvgAmp columns are
not put into the XLS file.
8924R021.AMP Filename TimeOfDay Time_min Time_sec Time_m:s AD Sx Pul# Unit DC PkAmp
1 89240217.P0 "12:48:35.6" 0.003333 0.2000 "0:00.2" 0 0 1 pA -166.626 -23.499
2 89240218.P1 "12:48:45.6" 0.170000 10.2000 "0:10.2" 0 1 1 pA -148.315 -309.448
3 89240219.P0 "12:48:55.6" 0.336667 20.2000 "0:20.2" 0 0 1 pA -153.503 -26.855
4 89240220.P1 "12:49:05.6" 0.503333 30.2000 "0:30.2" 0 1 1 pA -144.958 -372.620
Lat_ms Dur_ms RiseTm_ms DecTm_ms Area_unit*ms CoastLn PSamp PSlat_ms Slope_unit/ms AvgAmp Rs_Mohm Rm_Mohm
"" "" "" "" "" "" "" "" "" "" 8.739 268.661
"" "" "" "" "" "" "" "" "" "" 8.960 258.184
"" "" "" "" "" "" "" "" "" "" 8.659 250.398
"" "" "" "" "" "" "" "" "" "" 9.137 265.063
Fig. 4.17.1.1. The first four sweeps (taken 10 sec apart) of an Amp file ASCII text file. This is the full 24
columns wide AMP file, but it had to be separated into two sections to fit on this page. Only DC, PkAmp,
Rs and Rm were calculated, the other values were not calculated and were set to “” (empty).