How can I avoid ADE outputs like 33 m% of 120 mdB?

It's not clear what you want. You can control the default formatting (via Options->Output Formatting) or the specific formatting for any output using the digits, notation and suffix column. If you want something else, please contact customer support (it won't get enhanced just by asking here).

Andrew

It's not clear what you want. You can control the default formatting (via Options->Output Formatting) or the specific formatting for any output using the digits, notation and suffix column. If you want something else, please contact customer support (it won't get enhanced just by asking here).

Andrew

Dear Stephan,

Just to add to Andrew's response and in response to your direct question:

StephanWeber said:

Actually I like the units and using suffixes, but for csv export this makes Excel calculations very difficult too.

If you export the Assembler results in ".csv" format, by default, the results do not use the suffixes that appear in the Assembler window. Hence, you should be able directly import the ".csv" file into Excel and it will import properly formatted numerical data that can be used directly in computations. I am using:

$ virtuoso -W
sub-version ICADVM20.1-64b.500.23

Shawn

Dear Stephan,

StephanWeber said:

Actually I like the units and using suffixes,

If you happen to like the suffixes Assembler can add to your data, I created an Excel workbook that adds the suffixes to the data and attached the example workbook. Basically, export the Assembler data to a ".csv" file. Copy the resultant data into the example workbook tab "assembler_data.csv" (replacing the example data). In the tab labeled "assembler_data", the data will be shown using the Cadence defined suffixes in lieu of the scientific notation found in the exported Assembler ".csv" file. You can adjust the number of digits in the "assembler_data" tab by navigation to the "Variable tab and changing the yellow shade box adjacent the text "num_digits".

Shawn

example_suffix_formatted_workbook_sml_032722.xlsx

Hi Shawn and Andrew, thanks for fast reponse. With CSV and Excel I am quite fine for now. However can you can tell how to get in the ADE output table itself not these nasty things like 30 mdB or 120 m%? How can I force e.g. 0.030 dB or 0.12% instead. I can switch to 30E-3 or 3E-2, but also this is ugly.

Bye Stephan

I think you need a new choice of "floating point" rather than scientific or engineering or suffix which then shows without an exponent. That has the downside of not being scalable with all values (because if you are trying to show a small or large value it won't fit) but might be appropriate for some values. You'll need to request this enhancement via customer support, as you can't do it now.

Andrew

OK.

Indeed having a new setting like "floating point" would be helpful, and indeed often e.g. for nominal conditions the offset output is very small like nVolts, but vs MC the values can be much larger.

Also Excel is not good on this. In a forum I found that someone was able to let Excel work with M and m, but not with the long list like Tera down to Fempto. 

For outputs in dB or % it would be nice to define e.g. x:6:3, so 6 digits in total and 3 after "." And if the output would go beyond 1k, it could start to reduce the digits after ".". And if we go above 1M, it could start to use 1E6 or go for M.

Bye Stephan