Tag Archives: Atmel QTouchtools

All tiny AVR parts in a spreadsheet

I just made a spreadsheet of all the tinyAVR parts. All my pals love the MCU selector guide, but I have a lot of analog dinosaur buddies that prefer a spreadsheet to a web-based interface. You can sort the data and this spreadsheet has the filter box on the columns, so you can sort out things you care about and exclude the things you don’t. The spreadsheet fits on a 24-inch display, and you can print it out on a single B-sized sheet and use it as an infographic.


This screenshot shows how all the tinyAVR parts will fit on one 11×17 ledger-sized or B-sized sheet of paper.

I started with an Excel dump of the selector guide after adding every single parameter to the search. I then took all the tinyAVR parts, and rearranged the columns, throwing out the irrelevant ones. I also combined the automotive parts with the basic parts. That added two columns for automotive temp and automotive Vcc range. Adding 2 columns to remove 13 rows seemed like a good deal. The part name links to the product page on our website.

I made a column for each package. That took a long time. Semiconductor companies think of a part as the silicon die, with the package being almost irrelevant. We systems folk know the package might be the most important thing. I tried to put the smaller packages on the left, with those big ol’ DIP (dual-inline plastic) parts on the right side. There is a second sheet in the spreadsheet that shows all the parts by number and there I put the package size, in mm. In both sheets, the package name links to the definition page on our website.


The second sheet of the spreadsheet shows all the tinyAVR parts by number. I put the exact package size on this page.

Besides the packages and package size, I also spent a long time getting pricing. My buddy Wayne Yamaguchi requested this, and he is absolutely right, price is the most important spec of any part, and I hate when it takes 5 clicks to find it. These prices are a bit sketchy. All I did was click on the “Buy” link and select a handful of parts from each family, and then looked at the Digi-Key price, in 1000s. I put in the highest and lowest of the few I selected, but this is by no means scientific or dispositive, as the lawyers would say. What I should do is put the price in the “Package” column, so you know what the package is and what price we charge, but many parts are in the same package but have two Vcc ranges, so there is no unique way to encode this and keep the spreadsheet on one printable page. Maybe I can blow out the second page to show every orderable part number and its price and specs. Always time to do it over, never time to do it right.

The major thing I want to add is the OrCAD 9.2 footprint name for the packages. I am afraid to do this now, since we have all been burned by narrow-DIP/wide-DIP and narrow -SOIC/wide-SOIC and what pin numbering to use on SOT parts, so that will have to wait for next time. If anyone has a proven definitive list of the OrCAD footprints, please let me know. paul.rako[yeah, the at sign]atmel.com

You can highlight all the parts and use the “Data>Sort” function to order them any way you want. I did it by Flash memory size and part name. You can also use the little filter boxes on each column to include or exclude, or even put in a logical range with equal or less than or all the other things. Its not exactly grep or regular expressions, but it can get the job done helping you to find the right part.


Excel filter boxes let you select just the parameters you care about.

I am told this spreadsheet works OK in Open Office/Libre. My pal Dave asked that any columns that are filtered be lit up red, but that takes a macro, and the VB macro may not work in Open Office, we are checking for that. Meanwhile, check there are 36 part families or that the little filter box does not have 3 pixels different to show the filter is on.


When you have filtered a column, it is almost impossible to tell, since the only indication is the icon makes this 3-pixel change.

Weasel weasel, CYA CYA, legal boilerplate—this is a hobby job, not an official Atmel document. If the selector guide had it wrong, it is wrong here too. I made my own mistakes too. And I already told you the pricing and the tiny1634 stuff was dicey. What I am hoping is that I can get some community support where you point out the errors, and tell me what to add. paul.rako[yeah, the at sign]atmel.com I also ask that you send this URL link to your pals, instead of just emailing the spreadsheet. That way the bosses will see you like this, and I can have the time to keep working on it.


If Hans Camenzind, the inventor of the 555 timer chip was still alive, he might have a copy of the tinyAVR spreadsheet up on his office wall. I miss Hans, at least he came to my Analog Aficionados party one year, before we lost him to the Grim Reaper.


Atmel’s long-term partnership with ARM

This week, Atmel expanded its ARM Cortex-A5 microprocessor (MPU) portfolio with new SAMA5D3 devices that deliver smaller packaging, extended temperature support and an alternative peripheral mix. The latest SAMA5D3 devices – designed to neatly balance high performance and low-power operation – also boast an expanded ecosystem with new software and hardware.

As we’ve previously discussed on Bits & Pieces, Atmel offers an extensive portfolio of microcontrollers (MCUs) and microprocessors (MPUs) based on the world’s most popular 8- and 32-bit architectures: Atmel AVR and ARM. Indeed, Atmel’s two decades of microcontroller leadership and innovation include many industry-firsts:

  • The first Flash microcontroller, the first ARM7-based 32-bit Flash microcontroller
  • The first 100nA microcontroller with RAM retention
  • The first ARM9-based Flash microcontroller

“In order to simplify the embedded design process, we’ve meticulously built a robust ecosystem around our ARM microcontrollers,” an Atmel engineering rep told Bits & Pieces. “Meaning, Atmel offers a wide range of software tools and embedded software that support leading operating systems, along with low-cost evaluation kits.”

In addition, Atmel’s flexible and highly integrated ARM-based MCUs are designed to optimize system control, user interface (UI) management and ease of use. That’s why our ARM Cortex-M3 and M4 based architectures share a single integrated development platform (IDP): Atmel Studio 6. This platform offers time-saving source code with more than 1,600 example projects, access to debuggers/simulators, integration with Atmel QTouchtools for capacitive touch applications and the Atmel Gallery online apps store where embedded software extensions can be downloaded.

Meanwhile, Atmel ARM-based MPUs range from entry-level devices to advanced highly-integrated devices with extensive connectivity, refined interfaces and ironclad security.

“Whether you are working on new, existing or legacy designs, a wide range of Atmel ARM-based devices provides the latest features and functionality. These devices also feature the lowest power consumption, a comprehensive set of integrated peripherals and high-speed connectivity,” the engineering rep added.

Interested in learning more about Atmel’s extensive ARM portfolio? You can check out our ARM MCUs here and our ARM MPUs here.