[PEDA] Signal integrity analysis
Hi all, I am a signal integrity analysis virgin until today. However, it occurred to me that the software must generate a spice netlist which represents the PCB area of interest. Our IC designers could really do with this, so they can add it to their simulations. Does anyone know how I can get this spice netlist information out of Protel? Perhaps there is something I could access through writing a macro...? Any ideas? Dave Watling * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * To post a message: mailto:[EMAIL PROTECTED] * * To leave this list visit: * http://www.techservinc.com/protelusers/leave.html * * Contact the list manager: * mailto:[EMAIL PROTECTED] * * Forum Guidelines Rules: * http://www.techservinc.com/protelusers/forumrules.html * * Browse or Search previous postings: * http://www.mail-archive.com/[EMAIL PROTECTED] * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
[PEDA] Keepouts
Hi, I wish to prevent a polygon from pouring in a certain area. I have used a fill as a keepout on that layer, but I then get DRC errors showing shorts where I have put the fill over tracks. I also get DRC clearance errors where the fill is under a component. Is there a neater way of doing this so it comes up DRC clean? Regards Dave * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * To post a message: mailto:[EMAIL PROTECTED] * * To leave this list visit: * http://www.techservinc.com/protelusers/leave.html * * Contact the list manager: * mailto:[EMAIL PROTECTED] * * Forum Guidelines Rules: * http://www.techservinc.com/protelusers/forumrules.html * * Browse or Search previous postings: * http://www.mail-archive.com/[EMAIL PROTECTED] * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Re: [PEDA] Analysing...
I would definitely try running Regclean to clean up your windows registry - seems to alleviate most random crashing. You can find it using an internet search. David Watling JaMi Smith [EMAIL PROTECTED]To: Protel EDA Forum [EMAIL PROTECTED] bal.net cc: Subject: Re: [PEDA] Analysing... 04-Aug-2003 03:59 PM Please respond to Protel EDA Forum Not to beat a dead horse, but what are you using for mouse software? - Original Message - From: Choong Keat Yian [EMAIL PROTECTED] To: Protel EDA Forum [EMAIL PROTECTED] Sent: Saturday, August 02, 2003 5:49 AM Subject: Re: [PEDA] Analysing... You know , i have have my own confusion both self afflicted and for using Protel.,Since i join this company i has been told to use Protel but the fact is that it seem to me Protel's old and new version do not alleviate anything much other than cosmetic and workaround change as the main sunject matter.Imagine all the feature it got but some is quite unusable for what it intended to be,and i still didnt know why my Protel 99SE with service pack 6 still crash even thought i have 256 mb ram on a Asus board with Pentium 4 at 2.4Ghz.It happen on multiple machines both new and old and i dont think the problem is with the Nvidia's graphic engine. Choong Terry Creer [EMAIL PROTECTED] wrote: Ok, Thanks to all who answered. I think the long term fix is to rip up the 35 polys, and do it properly by laying keepouts in the right areas and using as few polys as possible. Pain in the bum, but nicer in the long run. however, I think with these suggestions, I can wing it until it can be re-done. Cheers, TC __ McAfee VirusScan Online from the Netscape Network. Comprehensive protection for your entire computer. Get your free trial today! http://channels.netscape.com/ns/computing/mcafee/index.jsp?promo=393397 Get AOL Instant Messenger 5.1 free of charge. Download Now! http://aim.aol.com/aimnew/Aim/register.adp?promo=380455 * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * To post a message: mailto:[EMAIL PROTECTED] * * To leave this list visit: * http://www.techservinc.com/protelusers/leave.html * * Contact the list manager: * mailto:[EMAIL PROTECTED] * * Forum Guidelines Rules: * http://www.techservinc.com/protelusers/forumrules.html * * Browse or Search previous postings: * http://www.mail-archive.com/[EMAIL PROTECTED] * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
[PEDA] BOM sorter version 10
Hi again, Minor bug found - version 10 available at: http://www.proteluser.com/download Regards David Watling * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * To post a message: mailto:[EMAIL PROTECTED] * * To leave this list visit: * http://www.techservinc.com/protelusers/leave.html * * Contact the list manager: * mailto:[EMAIL PROTECTED] * * Forum Guidelines Rules: * http://www.techservinc.com/protelusers/forumrules.html * * Browse or Search previous postings: * http://www.mail-archive.com/[EMAIL PROTECTED] * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
[PEDA] BOM sorter version 9 available
Hi all, Another minor bug fix: http://www.proteluser.com/download Regards Dave * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * To post a message: mailto:[EMAIL PROTECTED] * * To leave this list visit: * http://www.techservinc.com/protelusers/leave.html * * Contact the list manager: * mailto:[EMAIL PROTECTED] * * Forum Guidelines Rules: * http://www.techservinc.com/protelusers/forumrules.html * * Browse or Search previous postings: * http://www.mail-archive.com/[EMAIL PROTECTED] * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
[PEDA] BOM sorter - version 8
Hi all, Bug found in Qty column - version 8 available on: http://www.proteluser.com/download Regards Dave * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * To post a message: mailto:[EMAIL PROTECTED] * * To leave this list visit: * http://www.techservinc.com/protelusers/leave.html * * Contact the list manager: * mailto:[EMAIL PROTECTED] * * Forum Guidelines Rules: * http://www.techservinc.com/protelusers/forumrules.html * * Browse or Search previous postings: * http://www.mail-archive.com/[EMAIL PROTECTED] * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Re: [PEDA] never mind! it works BOM sorter - version 7
Hi Dennis, The minor bug is a well reported bug with forms in VBA. Can't do anything about it - sorry! Dave Dennis Saputelli [EMAIL PROTECTED]To: Protel EDA Forum [EMAIL PROTECTED] olsinc.comcc: Subject: Re: [PEDA] never mind! it works BOM sorter - version 7 28-Jun-2003 01:50 AM Please respond to Protel EDA Forum sorry Dave -never mind i was on a different machine and security was on high it works now as a feeble defense i had checked that briefly but on the first machine it was Excel XP or something newer than this machine which is Excel 2000 They put the security level setting in different places in the 2 versions for the unlearned in 2000 it is on Tools Macro and in XP it is on a tab in Tools/Options anyway Dave thanks a ton this is a terrific utility there is one little bug still (at least for me) if you drag the window with the option settings around it leaves a series of ghosts behind itself doesn't matter much really this is really going to save a lot of time i used to use the protel format (to get the grouping and count) then basically junk all the designator that wrapped to the next line import to excel and then pump them back it it really sucked compared to this so when do you release the bag label macro ? :) Dennis Saputelli [EMAIL PROTECTED] wrote: Hi all, I hope you will like this - I think I have satisfied most requests. Any other suggestions will be gratefully ignored. http://www.proteluser.com/download Regards David Watling -- Dennis Saputelli = send only plain text please! - no HTML == ___ Integrated Controls, Inc. www.integratedcontrolsinc.com 2851 21st Streettel: 415-647-0480 San Francisco, CA 94110 fax: 415-647-3003 * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * To post a message: mailto:[EMAIL PROTECTED] * * To leave this list visit: * http://www.techservinc.com/protelusers/leave.html * * Contact the list manager: * mailto:[EMAIL PROTECTED] * * Forum Guidelines Rules: * http://www.techservinc.com/protelusers/forumrules.html * * Browse or Search previous postings: * http://www.mail-archive.com/[EMAIL PROTECTED] * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Re: [PEDA] BOM sorter version 6 now!
Hi Dennis, I have looked at your suggestions, and I have made 1 change to the program, so it now always puts in the hyphen for consecutive designator numbers, whilst stripping similar prefixes. The other suggestions are noted, but I will have to put them on the back-burner for now. Your comment about the 'unformatted' option is noted, but all I've written there is a 'dumb' bit of code that simply looks at similar Part Types and Footprints, and tots them up without even looking at the designators. It's probably just a matter of preference, so I've written what I prefer! The code is unlocked, so anyone can play with it and perhaps come up with some better ideas. Version 6 now available at: http://www.proteluser.com/download/ Regards David Watling Dennis Saputelli [EMAIL PROTECTED]To: Protel EDA Forum [EMAIL PROTECTED] olsinc.comcc: Subject: Re: [PEDA] BOM sorter version 3 26-Jun-2003 04:44 PM Please respond to Protel EDA Forum i had a quick look nice! not to look a gift horse in the mouth but ... re 'Sort without formatting' the only difference i notice is that the designator prefix character is not stripped for items after the first this is my preferred appearance R1 R5 R6 or R1,R5,R6 as opposed to R1,5,6 but using the unformatted method the designators are not properly sorted! i know it is a pain in the butt to do that sort of a sort, but i have done it in the distant past including an optional 'crunch' R1 R32 R33 R34 R35 R72 would crunch to R1 R32-R35 R72 another minor thought it might be nice to have an option to not use commas to separate the designators we use a downstream process which requires the commaa to be stripped -- Dennis Saputelli = send only plain text please! - no HTML == ___ Integrated Controls, Inc. www.integratedcontrolsinc.com 2851 21st Streettel: 415-647-0480 San Francisco, CA 94110 fax: 415-647-3003 * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * To post a message: mailto:[EMAIL PROTECTED] * * To leave this list visit: * http://www.techservinc.com/protelusers/leave.html * * Contact the list manager: * mailto:[EMAIL PROTECTED] * * Forum Guidelines Rules: * http://www.techservinc.com/protelusers/forumrules.html * * Browse or Search previous postings: * http://www.mail-archive.com/[EMAIL PROTECTED] * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
[PEDA] BOM sorter - version 7
Hi all, I hope you will like this - I think I have satisfied most requests. Any other suggestions will be gratefully ignored. http://www.proteluser.com/download Regards David Watling * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * To post a message: mailto:[EMAIL PROTECTED] * * To leave this list visit: * http://www.techservinc.com/protelusers/leave.html * * Contact the list manager: * mailto:[EMAIL PROTECTED] * * Forum Guidelines Rules: * http://www.techservinc.com/protelusers/forumrules.html * * Browse or Search previous postings: * http://www.mail-archive.com/[EMAIL PROTECTED] * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Re: [PEDA] BOM sorter version 5
Hi all, Look, no attachments! If you want version 5, you can either e-mail me directly at: [EMAIL PROTECTED] Or, if you know your way around the VBA editor, you can simply replace all the code in the module called 'BOM_sorter' with the listing below. Regards David Watling Public Const top_column = 1 Public Const top_row = 2 Public Const qty_text = Qty Public split_array() As String Public Qty As Integer Sub BOM_sort_with_format() Call BOM_sort(True) End Sub Sub BOM_sort_without_format() Call BOM_sort(False) End Sub Sub BOM_sort(with_format As Boolean) Dim index_cells As Variant i = 0 Application.ScreenUpdating = False ' insert 'Qty' column If Cells(top_row - 1, top_column + 4) qty_text Then ' insert column Columns(top_column + 4).Insert Shift:=xlToRight Cells(top_row - 1, top_column + 4) = qty_text End If Do While (Cells(i + top_row, top_column) Empty) Or (Cells(i + top_row, top_column + 1) Empty) index_cells = Cells(i + top_row, top_column) Cells(i + top_row, top_column + 2) Cells(i + top_row, top_column + 4) = 1 j = i + 1 Do While (Cells(j + top_row, top_column) Empty) Or (Cells(j + top_row, top_column + 1) Empty) If Cells(j + top_row, top_column) Cells(j + top_row, top_column + 2) = index_cells Then If Cells(j + top_row, top_column + 1) Empty Then ' increment Qty column Cells(i + top_row, top_column + 4) = Cells(i + top_row, top_column + 4) + 1 ' append to upper row If Cells(i + top_row, top_column + 1) = Empty Then Cells(i + top_row, top_column + 1) = Cells(j + top_row, top_column + 1) Else Cells(i + top_row, top_column + 1) = Cells(i + top_row, top_column + 1) , Cells(j + top_row, top_column + 1) End If End If ' delete row Rows(j + top_row).Delete j = j - 1 End If j = j + 1 Loop i = i + 1 Loop If with_format Then i = 0 Do While (Cells(i + top_row, top_column) Empty) Or (Cells(i + top_row, top_column + 1) Empty) ' format designators Cells(i + top_row, top_column + 1) = sort_designators(Cells(i + top_row, top_column + 1)) ' fill in Qty column Cells(i + top_row, top_column + 4) = Qty i = i + 1 Loop ' data sort by part type footprint Range(Rows(top_row), Rows(top_row + i)).Sort _ Key1:=Columns(top_column + 1), _ Order1:=xlAscending, _ Header:=xlNo, OrderCustom:=1, MatchCase:= _ False, Orientation:=xlTopToBottom End If Columns(top_column + 1).EntireColumn.AutoFit Columns(top_column + 4).EntireColumn.AutoFit Application.ScreenUpdating = True End Sub Function sort_designators(string_l) Dim text_array() As String Dim no_array() As String Dim designators_array() As String Dim types_array() As String Dim types_flag As Boolean ' split up the string split_array = Split(string_l, ,) ReDim text_array(UBound(split_array)) ReDim no_array(UBound(split_array)) ReDim types_array(0) Qty = UBound(split_array) + 1 n_types = 0 ' remove spaces split into text numbers For k = 0 To UBound(split_array) split_array(k) = Replace(split_array(k), , ) For num_len = 1 To Len(split_array(k)) charac_l = Asc(Mid$(split_array(k), num_len, 1)) If charac_l = 48 And charac_l = 57 Then Exit For Next num_len = num_len - 1 text_array(k) = Left$(split_array(k), num_len) If text_array(k) Then last_type = text_array(k) Else text_array(k) = last_type End If no_array(k) = Right$(split_array(k), Len(split_array(k)) - num_len) types_flag = False ' count types For l = 0 To UBound(types_array) If text_array(k) = types_array(l) Then types_flag = True Exit For End If Next If types_flag = False Then ReDim Preserve types_array(UBound(types_array) + 1) types_array(l - 1) = text_array(k) End If Next ReDim Preserve types_array(UBound(types_array) - 1) ReDim designators_array(UBound(types_array)) ' re-order numbers text (bubble sort) For k = 0 To UBound(split_array) For l = 0 To UBound(split_array) - 1 If Val(no_array(l)) Val(no_array(l + 1)) Then temp_text = no_array(l) no_array(l) = no_array(l + 1) no_array(l + 1) = temp_text temp_text = text_array(l) text_array(l) = text_array(l + 1) text_array(l + 1) = temp_text End If Next Next ' sort numbers to types For k = 0 To UBound(types_array) designators_array(k) = types_array(k) For l = 0 To UBound(no_array) If text_array(l) = types_array(k) Then designators_array(k) = designators_array(k) no_array(l) , End If Next designators_array(k) = Left$(designators_array(k), Len(designators_array(k)) - 1) Next ' Join types sort_designators = Join(designators_array, ; ) End Function * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * To post a message: mailto:[EMAIL PROTECTED] * * To leave this list visit: * http://www.techservinc.com/protelusers/leave.html * * Contact the list manager: * mailto:[EMAIL PROTECTED] * * Forum Guidelines Rules: * http://www.techservinc.com/protelusers/forumrules.html * * Browse or Search previous postings: * http://www.mail-archive.com/[EMAIL PROTECTED] * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
[PEDA] Attachments (BOM sorter)
Hi Abd, If you look back at the first e-mail I sent on this subject, I believed it was going to be rejected, so I asked people to e-mail me directly. I think the attachment rejection still works on attachments greater then a certain size, since an example file I sent got rejected before I zipped it. I presumed at the time that the main reason for rejecting attachments was because of the large size of Protel databases which would be bounced around the world to everyone. I didn't know I needed permission to send attachments, and presuably no-one else did, as no-one else mentioned it. Lastly, I think it was a bit strong chastising me for merely exposing a weakness. Regards David Watling Abd ul-Rahman LomaxTo: Protel EDA Forum [EMAIL PROTECTED] [EMAIL PROTECTED]cc: com Subject: Re: [PEDA] BOM sorter 24-Jun-2003 05:41 PM Please respond to Protel EDA Forum While the intention to provide a utility to Protel users is appreciated, it is very bad form to send any attachments to a mailing list without permission. At one time this list was set to reject attachments, it appears that this has been lost. This is a serious security issue. A number of us have write access to a Protel user filespace that has been used for this kind of purpose. I've been rather buried lately but I'm sure that there is someone here who would post the files. However, to access the filespace, as I recall, you must be a member of [EMAIL PROTECTED] and accept a yahoo cookie for the session. I think that if you join the list and register with yahoo you may be able to upload the files yourself. As to why the access is limited to list members, the decision was made because the yahoo user agreement in effect provides that material which is accessible to the general public has thereby been placed in the public domain. On the one hand, this might be an argument against using yahoo for the user lists, on the other hand, there are many benefits. In any case, decisions like this rest with the Association, [EMAIL PROTECTED] (You can join these lists by sending a piece of mail to, for example, [EMAIL PROTECTED] In that case you can subscribe and read the lists by regular email without accepting yahoo cookies if that concerns you.) The protel-users family of lists on yahoogroups.com is generally set for moderator approval of membership because of bad experience with spammers. The approval, for anyone who is actually interested in Protel, is merely a formality. I do recommend joining [EMAIL PROTECTED] if you are at all involved with Protel. This is primarily a backup list for the Forum, which you are now reading. If you have an urgent question that pops up unexpectedly, and the Forum seems to be down, you can then ask it there without having to wait for moderator approval of your membership. That list is also open to non-emergency posts regarding Protel issues, but please, except in an emergency, do not post the same message or question to both lists. Either list generally works for getting good support, but the Forum list is larger and includes nearly everyone who is subscribed to the yahoogroups list. The yahoogroups list does, however, count among its members nearly every major writer for the Forum list. (The protel-users list will not add significantly, under present conditions, to your mail load) * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * To post a message: mailto:[EMAIL PROTECTED] * * To leave this list visit: * http://www.techservinc.com/protelusers/leave.html * * Contact the list manager: * mailto:[EMAIL PROTECTED] * * Forum Guidelines Rules: * http://www.techservinc.com/protelusers/forumrules.html * * Browse or Search previous
Re: [PEDA] BOM sorter version 3 - Example Protel99SE BOM
Hi Darren, Good idea - here's one I did earlier (I had to zip it up as it got rejected before): (See attached file: Example BOM.zip) Regards Dave Darren [EMAIL PROTECTED]To: 'Protel EDA Forum' [EMAIL PROTECTED] .au cc: Subject: Re: [PEDA] BOM sorter version 3 - please overwrite the 24-Jun-2003 12:05 original AM Please respond to Protel EDA Forum Hi David, What would be handy, is if you could supply an example input and output spreadsheet file. Regards, Darren Moore -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Hi, Found a minor bug when it comes to blank Part Types. (See attached file: BOM sorter readme.txt)(See attached file: BOM sorter.xls) Regards David Watling Example BOM.zip Description: Zip archive
Re: [PEDA] BOM sorter
Hi Brad, I would suggest you have your macro security set to 'high' in Excel. This will disable any loaded macros, without any prompts. Set your macro security to 'medium' (if you trust me!) This is found in Tools-Macro-Security Regards David Watling Brad Velander [EMAIL PROTECTED]To: Protel EDA Forum [EMAIL PROTECTED] .comcc: Subject: Re: [PEDA] BOM sorter 20-Jun-2003 09:05 PM Please respond to Protel EDA Forum I tried it as well after seeing your message. I opened BOM Sort.XLS, saw the BOM Sort toolbar, opened a CSV BOM, clicked BOM SORT and got an error message stating The macro BOM sorter.xls'!BOM_sort_with_Format' cannot be found. The funny thing is that both macros appear in the list when you check the macros. Sincerely, Brad Velander. Lead PCB Designer Norsat International Inc. Microwave Products Tel (604) 292-9089 (direct line) Fax (604) 292-9010 email: [EMAIL PROTECTED] http://www.norsat.com -Original Message- From: John A. Ross [Design] [mailto:[EMAIL PROTECTED] Sent: Friday, June 20, 2003 9:09 AM To: Protel EDA Forum Subject: Re: [PEDA] BOM sorter Dave All I get out of it is run time error 13 type mismatch. Is the procedure just open file, load csv and go? Best Regards John A. Ross * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * To post a message: mailto:[EMAIL PROTECTED] * * To leave this list visit: * http://www.techservinc.com/protelusers/leave.html * * Contact the list manager: * mailto:[EMAIL PROTECTED] * * Forum Guidelines Rules: * http://www.techservinc.com/protelusers/forumrules.html * * Browse or Search previous postings: * http://www.mail-archive.com/[EMAIL PROTECTED] * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
[PEDA] BOM sorter version 2 - please overwrite the original
Hi again Brad all, Try running it on a 'Client spreadsheet' BOM. It will definitely not work on a Protel BOM. It was looping until Part Type was empty, so if any Part types were empty, it stopped there. I have corrected this, so it now checks the first two columns. I don't know what this run time error 13 is - could someone send me a BOM which displays this error? I will write a read.me file soon, as I seem to be getting some interest. I now know how the guys at Protel feel when users start reporting bugs! (See attached file: BOM sorter.xls) Regards David Watling Brad Velander [EMAIL PROTECTED]To: Protel EDA Forum [EMAIL PROTECTED] .comcc: Subject: Re: [PEDA] BOM sorter 20-Jun-2003 09:23 PM Please respond to Protel EDA Forum Well I got the macros to be recognized, had to change the macro security level. Now I have it adding a Qty header and it seems to format the column widths but nothing else happens. To Dave Watling, Dave, I think that your excel wooksheet needs at least a small readme file. It is not as simple as one might think it could be. Can you give us the BOM format, number of columns, headers or no headers, anything else that we might not inherently know. While playing, it did combine two designators onto one line but listed the quantity still as 1. That is as far it would go, just one line and it was in error because it should have had a quantity of 2. It also doesn't seem to handle rows where the first column is blank. And I have now seen the runtime error 13 a number of times as well. Sincerely, Brad Velander. Lead PCB Designer Norsat International Inc. Microwave Products Tel (604) 292-9089 (direct line) Fax (604) 292-9010 email: [EMAIL PROTECTED] http://www.norsat.com CONFIDENTIALITY: This e-mail and any attached files may contain information that is confidential and may be privileged. If you are not the intended recipient or the person responsible for delivering the message to the intended recipient, please notify the sender immediately and do not disclose the contents to another person, use it for any purpose or store or copy the information in any medium. Thank you. -Original Message- From: John A. Ross [Design] [mailto:[EMAIL PROTECTED] Sent: Friday, June 20, 2003 9:09 AM To: Protel EDA Forum Subject: Re: [PEDA] BOM sorter Dave All I get out of it is run time error 13 type mismatch. Is the procedure just open file, load csv and go? Best Regards John A. Ross BOM sorter.xls Description: application/msexcel
[PEDA] BOM sorter - with readme file
Hi all, Here is version 2 again with a readme file: (See attached file: BOM sorter readme.txt)(See attached file: BOM sorter.xls) Regards David Watling BOM sorter readme.txt Description: Binary data BOM sorter.xls Description: application/msexcel
[PEDA] BOM sorter version 3 - please overwrite the original
Hi, Found a minor bug when it comes to blank Part Types. (See attached file: BOM sorter readme.txt)(See attached file: BOM sorter.xls) Regards David Watling BOM sorter readme.txt Description: Binary data BOM sorter.xls Description: application/msexcel
[PEDA] BOM sorter
Hi all, If you've ever pulled your hair out because you can't get a sensible BOM into Excel, for the purpose of ordering parts and assembling PCBs, then I may have the answer. I've written a single click BOM sorter in Excel 2000 VBA, to sort the 'CSV' or 'Client spreadsheet' BOMs into a sensible format, with all similar components on the same row. I'll attempt to attach it here, but it will probably be blocked. However, if you are interested, just send me an e-mail at: [EMAIL PROTECTED] (See attached file: BOM sorter.xls) The code is unlocked, so you can play with it. Please note: it doesn't run under Excel97. Regards David Watling BOM sorter.xls Description: application/msexcel