Shulou(Shulou.com)06/01 Report--

How to use excel to quickly build the schematic package of orCAD devices, I believe that many inexperienced people do not know what to do about it. Therefore, this paper summarizes the causes and solutions of the problem. Through this article, I hope you can solve this problem.

Detailed explanation of the topic:

This discussion uses excel to quickly establish the schematic package of multi-pin devices. For hardware design, if it is compared to building a house, then the "device library" is "bricks". "quality of bricks", "types of bricks" and "reserves of bricks" determine your work efficiency to a great extent.

The AD is as follows:

The PADS is as follows:

For "ordinary components", there is basically no difference in the use of "AD", "PADS" or "orCAD". For example, for resistor-capacitance devices, the screenshots of the three are as follows:

As shown above, due to the small number of device pins, simple verification and other factors, the impact of the software itself on efficiency is minimal.

But at present, the integration of "electronic circuit" is getting higher and higher, and the number of pins used in chips is also increasing exponentially, especially for highly integrated MCU, ARM chips, FPGA/CPLD, DSP and so on, many of the STM32 chips whose pins have reached 100 pins are no longer rare. At this time, it is very difficult to rely entirely on the manual production of "IC schematic library".

1. Usage

As shown in the figure above, the method is to make "New Part from SpreadSheet" under "library file" under "orCAD" for rapid production, and the auxiliary tool is "excel 2013".

For example, "EPM240T100C5", which is a "CPLD chip" with a number of pins of "100PIN", is cut into "5 PART" when drawing a library

As shown above, if you use AD to draw, you need to check one by one and set "each PIN foot" independently; the amount of work is large, and it is difficult to check later.

2. Optimization scheme

Use "orCAD" production library, if you use "New Part from SpreadSheet", you can use "excel" self-correction function to achieve troubleshooting; as shown in the following figure, first fill in "component name", "number of components".

According to the CPLD chip discussed above, input the information into the excel table according to the schematic diagram:

Total number of PIN feet. PIN feet can be counted after full input.

With the help of the "fill sequence", we can know the following three points:

I), "PIN feet": "PIN feet total" is "100PIN"

Ii), "repeat pin number": use "countif function" to quickly check whether "input pin number" is a "unique pin number". If there is a "repeat pin number", the device cannot be generated. It needs to be checked and then generated.

Finally, click "OK" to automatically generate the catalog, as shown in the following figure:

After reading the above, have you mastered how to use excel to quickly build the schematic package of orCAD devices? If you want to learn more skills or want to know more about it, you are welcome to follow the industry information channel, thank you for reading!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.