BOM /parts list separated into sections?

BOM /parts list separated into sections?

Postby dnsmth9000 » May 21st, '18, 19:47

It seems like the most useful parts list to work from would be the Individual Voice Parts List http://www.e-licktronic.com/en/index.php?controller=attachment?id_attachment=68 if it was correlated with the Mouser BOM https://www.mouser.com/ProjectManager/ProjectDetail.aspx?AccessID=ae6c8bf807 and was available as an Excel file or similar editable spreadsheet... has anyone put something like that together?

There is more info in the Mouser BOM than in the parts list, and it would be helpful to have the extra detail (for example the manufacturer name and part number) when finding and organising the components into the Yocto sections. Additionally I might want to order the parts by section as I build rather than get them all at once, but that is quite complicated as it stands.

I guess I am going to try and make such a spreadsheet before I start, but I figured maybe someone already made something like this?
dnsmth9000
 
Posts: 13
Joined: May 21st, '18, 19:25

Re: BOM /parts list separated into sections?

Postby dnsmth9000 » May 23rd, '18, 15:30

I made a CSV table and annotated the Individual Voice PartsList table with the details from the Mouser BOM. In case it is useful to anyone I uploaded it here:
http://www.mediafire.com/file/qywou80fj ... Sheet3.csv
I don't have my kit or parts yet but the idea is to use this to organise the parts once I get the BOM and have received the kit, I will probably update it when I get everything. There are a lot of discrepancies that I think would have been really confusing.

To make this I took the Individual Voice PartsList pdf and extracted the table into csv table using Tabula, as well as the Main_PartList, and did my best to connect each part to an item on the Mouser BOM, or tag it as included in the kit. I added a note where it seems like the part on the BOM has different specifications than is given in the parts list, or some other info that might be useful. I am assuming all the potentiometers that werent in the BOM are in the kit. There are still some things on the BOM that aren't mentioned in the parts list but should mostly be just jumper cables and spacers etc, and some transistors that aren't mentioned on the Yocto product page but I am assuming are included. Each part is also tagged with a section so you can filter if you just want to look at the PSU or whatever section you are working on. There could well be mistakes so check that the mouser info columns and the partslist info seem to make sense, and Tabula sometimes misses rows as pulling a table from a pdf is a mess so one or two entries might have got lost.
dnsmth9000
 
Posts: 13
Joined: May 21st, '18, 19:25

Re: BOM /parts list separated into sections?

Postby tulippx » Jan 31st, '21, 02:02

Very useful spreadsheet. Thank you for doing this.
tulippx
 
Posts: 1
Joined: Jan 31st, '21, 02:01

Re: BOM /parts list separated into sections?

Postby Djdu11 » Nov 8th, '21, 23:23

Hello guys! Super usefull thx!

So if I’m right we can substitute RC4558P for the uPC4558CA?

Thx in advance
Djdu11
 
Posts: 1
Joined: Nov 7th, '21, 10:51


Return to Yocto² Hardware

Who is online

Users browsing this forum: No registered users and 1 guest

cron