[PEDA] Looking for an automated method to get a 484pin BGA Alterachip int...

[Wamnet@aol.com]

I stage it using an excel spreadsheet that, when I export the spreadsheet as 
space or comma delimited ( the latter takes some editing in Ultraedit to 
replace the commas with spaces) I can make an Protel ASCII part listing:

      Q?
      
      COMPNAME
      Part
         40 40
         Pin  0 0 4 0 1 1 10 0 0 2 0 'pinname' '1' 
      EndNormalPart
      EndDeMorganPart
      EndIEEEPart
   EndComponent
EndLibrary  
Library Version 2.0

You then take an old ASCII part and replace the line "Pin..." with the output 
from the Excel export. The 0 10 is the x y position; you have to edit that, I 
just make the y number add 1 during the copy and paste operation in Excel for 
the amount of lines I need for the pin count.


I then take the pinlist file from Altera (or a staged table from a PDF file 
as Brad mentioned) and use that to replace the last two line entries which are 
pin name and number.

Done this many times... works great. Upon import into Protel, you get a part 
that has all the pins lined up quite nicely... you just then grab the pins and 
move 'em where you want.