09Jan 2014

The Updated Bill of Materials and Stock Management Tool

Stock management and Bill of Materials generation are usually neglected when it comes to making projects, so I updated a tool I made a while back...

BoM generator

Unfortunately for Linux users, this utility is made using Visual Basic functions in an Excel file!
It works fairly simply: just enter your schematics’ components references in the excel sheet, along with the corresponding Digikey webpage address. Click on the “fetch” button and the script will automatically get all your components characteristics from the internet and tell you the components costs depending on the number of prototypes you want to make. Then click the “sort BoM” button and your BoM will automatically be sorted by component type and value.
Another functionality allows you to check that all the components present in your BoM are also present on the (very simple) Kicad generated one. Finally, using another Excel sheet containing your current stock, the Bill of Materials will let you know if you have enough components for the assembly stage. You can download the BoM template here and the corresponding stock file there. Here is the video of the tool in action:


1. On Sunday, January 12 2014, 19:02 by BilHerd

Very Cool. You are right about the BOM often being neglected in smaller projects. Bigger CAD packages such as OrCad include some part controls but it is harder to find for DIY. I downloaded about a dozen packages a few months ago and ended up with Partkeepr, but like most things this size it's a love/hate relationship.

I will try this on my next small project.

2. On Sunday, January 12 2014, 20:30 by limpkin

@BilHerd : Thanks Bill! That's an honor having you here on my website.

3. On Tuesday, January 21 2014, 12:48 by cotton

I also agree that stock and BOM management get neglected for small projects. I think that points to a lack of good tools!

I tried this out with Excel 2010 but I couldn't get it to work. I picked a few random Digi-Key parts, but when I click "Fetch Information from Digi-Key", it just sets the price/chip to 0.

You might also be interested in EEnventory:


It is a Web app for tracking inventory. It can import both part detail and order information from Digi-Key and Mouser. It doesn't have KiCad integration yet (working on it!), so you still need to enter BOMs by hand.

4. On Friday, January 9 2015, 16:07 by Kevin

Hi Limpkin,

Cool, thanks for the inspiration! I took the liberty of attempting a port to Google Spreadsheets (for those of us without Excel). It's still pretty rough, but I think I got the basic functionality done:


5. On Saturday, January 10 2015, 12:28 by limpkin

@Kevin : sweet! don't hesitate to ping me when everything is working well... many people will be interested in it!

This post's comments feed

Add a comment

Comments can be formatted using a simple wiki syntax.

They posted on the same topic

Trackback URL : http://www.limpkin.fr/index.php?trackback/194