Did you know that AN-SOF data can be exported to Excel?
It is important to be able to export data so we can write reports and share our progress with colleagues. Simulation results can be exported to CSV (Comma Separated Values) files, where data are saved in tabular format. CSV files can then be opened with a spreadsheet program, such as Microsoft Excel or Google Sheets.
We will find the “Export” button next to the following tables:
- Select a wire in AN-SOF, go to Main menu > Results > List Currents. Move the slider to choose a segment and click on the Current on Segment button or Input List button (it is enabled if there is a source there). A table of current/input impedance vs. frequency will be shown.
- Go to Main menu > Results > Power Budget/RCS to display the table of input power, radiated power, directivity, gain and efficiency.
- The far-field can be tabulated as a function of the direction (far-field pattern) for a chosen frequency or as a function of frequency for a selected direction (theta,phi). Go to Main menu > Results > List Far-Field Pattern for the first option or Results > List Far-Field Spectrum for the second one.
- Regarding the near field, we can say the same as in 3). Go to Main menu > Results > List Near E-Field (H-Field) Pattern or Results > List Near E-Field (H-Field) Spectrum.
Regarding plots, after plotting some result in AN-XY Chart, AN-Polar or AN-Smith, go to the main menu of any of these applications > File > Export to export a CSV file.
In addition, there is a Copy Plot (Ctrl+C) command in the Edit menu of these applications. This option is called Copy Workspace in the File menu of AN-SOF. It sends the graphic to the clipboard as a bitmap, which can then be pasted elsewhere (Ctrl+V), e.g. in Microsoft Word, Power Point or their Google-equivalents, in an image editor, in an email body, etc.