Author Topic: Automating larger package creation using Excel  (Read 1612 times)

0 Members and 1 Guest are viewing this topic.

Offline Pack34

  • Frequent Contributor
  • **
  • Posts: 667
Automating larger package creation using Excel
« on: October 28, 2014, 12:54:54 am »
I've always enjoyed finding ways to use Excel to make my job easier. I've put together the below spreadsheet to easily create larger footprints.

There's still some work to make it more automated, but the idea is that you would update your pad information, create additional rows depending on the number of sides and pins you have, and then drag down the formulas.

When you've done this, you simply need to copy column F and paste it into the command area in Eagle and you can watch your footprint being created before your eyes. It's actually kind of fin to watch on larger packages.


Offline Jeroen3

  • Super Contributor
  • ***
  • Posts: 3392
  • Country: nl
  • Embedded Engineer
Re: Automating larger package creation using Excel
« Reply #1 on: October 31, 2014, 10:25:58 am »
It's a great trick. Copy paste the pinlist from the datasheet and create the pins/pads in symbol/package designer including the name.
The names are the most annoying of all to do manually.

Offline teksturi

  • Regular Contributor
  • *
  • Posts: 59
  • Country: fi
Re: Automating larger package creation using Excel
« Reply #2 on: December 28, 2014, 07:02:51 pm »
This look very useful. I made few improvements. Now you can use two row or four row tabs and just put parameters and excel will calculate pads for you. Maybe new improvements other time.



Share me

Digg  Facebook  SlashDot  Delicious  Technorati  Twitter  Google  Yahoo