Spectrum Software
Industrial Strength Simulation




Spectrum Software has released Micro-Cap 11, the eleventh generation of our SPICE circuit simulator.

For users of previous Micro-Cap versions, check out the new features available in the latest version. For those of you who are new to Micro-Cap, take our features tour to see what Micro-Cap has to offer.




Questions and Answers - Fall 2004


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.

Return to the main Newsletter page