Question: How do I create a triangle waveform source?
Answer: A triangle waveform source can be created using the Voltage Source
component available in the Waveform Sources group of the Analog Primitives section
in the Component menu. When the source is placed in a schematic, select the Pulse
tab. Set the PW (pulse width) parameter to 0. The TR and TF parameters will define
the rise and fall times of the triangle source respectively. Due to the zero value
of the pulse width, the result will be a triangle waveform. For a current triangle
waveform, select the part called Current Source, available in the same group, and
follow the same technique.
Question: I've run a simulation and specified the waveforms to print their data
in the numeric output file. If I open the numeric output file and then copy and paste
the tabular data into Excel, all of the data copied gets pasted into a single cell.
How do I send this data over to Excel so that it will place each piece of data in its
own cell?
Answer: When numeric output is enabled for a waveform and the simulation is run, a
column of data for that waveform will be placed in the Numeric Output file which can be
accessed under the specific analysis menu (Transient, AC, or DC). This output is just
a text file that will have one of the extensions: .TNO, .ANO, or .DNO depending on the
type of analysis that was run. In Excel, you can then use the Get External Data / Import
Text File option that is available under the Data menu to import the tabular data into
Excel. This Excel function lets you choose the delimiter that the import will use. When
importing numeric output files, both the Tab and the Space delimiters should be
selected.
By default, Micro-Cap will usually place a lot more information in the numeric output
than just the tabular data of the waveform such as the operating point results for
individual devices. This can potentially take up a large amount of the file and probably
is not information that one would want to import into Excel. The Import Text File
function in Excel lets you choose the first row to begin the import process on as a
way to skip all of the other information and just import the tabular waveform data.
Alternatively, in Micro-Cap, the Properties dialog box in the analysis provides a way
to limit the type of information that is sent to the numeric output file. In the Numeric
Output page of the Properties dialog box, disabling all of the options but Include
Numeric Output and Include Waveform Values will result in a numeric output file with
just the tabular waveform data.
|