Electronics Forum | Mon Jul 29 20:06:32 EDT 2024 | bsziszi
You can try SMT Maestro
Electronics Forum | Tue Jul 30 07:40:01 EDT 2024 | jergod
Okay, havent heard about that. Thanks. Where i can find this program?
Electronics Forum | Fri Aug 02 11:54:57 EDT 2024 | proceng1
We definitely need more moderation from SPAM accounts, unfortunately.
Electronics Forum | Tue Jul 30 10:16:25 EDT 2024 | jergod
Yes, i found program from earlier posts. thanks. Yes, seems like it doesnt work for references like C1-9 etc. But for me it seems to be good enough for most of cases!
Electronics Forum | Thu Aug 01 12:50:04 EDT 2024 | zerk
Hello. Last Excel (from 2018) allows you to split cell into rows with Power Query (see on youtube) So you can split your Bom into rows, sort by REFDES, and then combine it with your CAD file.
Electronics Forum | Fri Aug 02 11:52:40 EDT 2024 | mistrthou
Attach a screenshot of a text document? This forum for all of the benefit of the knowledge has a lot of bad going on (spam, bots, lack of moderation)
Electronics Forum | Fri Aug 02 12:03:00 EDT 2024 | spoiltforchoice
For a while at least a typo on the URL revealed there was at least a trial installation of an alternative forum software, some delay and hoops to jump through should kill the worst spam. I will edit my earlier post with an attachment of some kind at
Electronics Forum | Tue Jul 30 14:00:28 EDT 2024 | proceng1
If both BOM and CAD are Excel spreadsheets, you could write a routine to search the BOM for the REF DES, and then paste the Manuf PN from the column in that row. The issue becomes if you are searching for R1, it's going to find R10, R11, R12 etc. W
Electronics Forum | Tue Jul 30 09:05:08 EDT 2024 | spoiltforchoice
SMT Maestro is long gone from the wider web. You have to beg those of us who have a copy to share a link or find one of the previously shared links in this forum and see if it is still active. Technically this basic requirement is not that difficult
Electronics Forum | Fri Aug 02 10:38:02 EDT 2024 | spoiltforchoice
There are several solutions on forums & youtube for breaking up a cell into multiple rows. I have this macro in LibreOffice Calc for expanding ranges if only I knew how to format on this hideous forum software REM ***** BASIC ***
winsouce.jpg)