Exporting data in suffix format from the ADE outputs window

Dear ppendyal,

ppendyal said:

but I am unable to find a way to export the data I have in the  ADE ouputs in suffix format. 

When I try to export, it always comes out in scientific notation. Is there a way to export in suffix format?

I'm not sure what process you are using to export or the data you are trying to export (i.e., waveform, outputs, variables, etc..). However, as you did not indicate what you have tried, did you happen to try changing the defaults formatting for Assembler as shown below?

Shawn

If you use the "save" icon on the results tab, then if the output formatting is set to "suffix", it outputs in engineering format. This is because spreadsheet tools will generally not understand suffix notation, so it's nearly always the wrong thing to do. If you pick scientific format, it honours that - it's just suffix notation that's transformed into engineering notation.

I don't believe there's any way to stop this - not that I found anyway.

Regards,

Andrew

Dear ppendyal,

I happened to recall after I wrote my response that I wrote a c-program some time ago to append both a numerical suffix and units to a floating point value. If you are in need of adding a numerical suffix to a comma-separated-variable file with exported values and a text header (such as what ADE will export), I translated it to a UNIX awk script and have attached it below. An example using a comma-separated-variable file "voltage.csv" without any numerical suffixes is shown below:

$ cat voltage.csv
Time,Voltage
2e-12,1e8
1e-09,100e-06
3e-3,7.717e-03
300e-03,7.28e-15
$
$ awk -f add_suffix_to_csv.nawk num_digits=4 voltage.csv > voltage_with_suffixes.csv
$
$ cat voltage_with_suffixes.csv
Time,Voltage
2.0000p,0.1000G
1.0000n,100.0000u
3.0000m,7.7170m
300.0000m,7.2800f

The AWK script "add_suffix_to_csv.nawk" is provided below if it is of any help to you ppendyal.

Shawn

add_suffix_to_csv.nawk.zip