This should keep me busy through 2022...

junderwood

junderwood

Active member
PXL_20220326_165735112.jpeg

After doing some math, it looked pretty clear that if I built pedals onsie-twosie, a large percentage of each pedal's cost would be in shipping components. Especially for projects that include parts from several sources. So I decided to go through PedalPCB's available boards and make some long term plans! Now I just have to check all these components into my "inventory system" (just a google sheets doc), and get to soldering!

Out of curiosity, how do folks here manage component inventory? I feel like there's probably a better solution than just a big spreadsheet, but since I'm doing this for me (and friends) vs running a business, my needs are kind of in between simple and not-so-simple.
 
Honestly, I had to do it old school where I look at EVERY SINGLE baggie and storage box I have and see what I’m running low on. If I have less that a sheet of resistors left, order 20+. Capacitors you should have at least 20 of the common values. Pots will take you a while to inventory….

It took me probably an hour to check and list everything in a notebook
 
Last edited:
I hate spreadsheets... they're clunky and awkward.

I'd rather just do a table in a simple text edit program, such as Apple's Text Edit. That or pen and paper.
 
junderwood said:
After doing some math, it looked pretty clear that if I built pedals onsie-twosie, a large percentage of each pedal's cost would be in shipping components. Especially for projects that include parts from several sources. So I decided to go through PedalPCB's available boards and make some long term plans! Now I just have to check all these components into my "inventory system" (just a google sheets doc), and get to soldering!

Out of curiosity, how do folks here manage component inventory? I feel like there's probably a better solution than just a big spreadsheet, but since I'm doing this for me (and friends) vs running a business, my needs are kind of in between simple and not-so-simple
Click to expand...
I'm in Canada so international shipping/duty adds up quickly. I plan projects and manage my inventory on a spreadsheet and it works for me. Helps me plan in advance so when I'm ready to do a build, I know ... or I think I know that I have all the components I need.
 
Last edited:
junderwood said:
Here's how I've been managing things so far: https://docs.google.com/spreadsheet...tH7trWYmpyd9dMfNPYmaJxzrKcg/edit?usp=drivesdk

Once this batch is done, I'll clear out the pedal columns and enter in the components needed for the next batch. Seems like there should be a better way to subtract components from stock as you're building each pedal 🤔🤔🤔
Click to expand...
I added column to the far right of my spreadsheet to move projects to my "completed section". Simple formula takes it out of my inventory so I get some sort of live result of my spread sheet and keep everything rolling this way.
 
I made a tabbed spreadsheet while ordering things because I was already losing track of stuff. I update the quantities manually after each build. My stash is all inside plastic bags inside plastic bags inside the cardboard boxes they were shipped in but sorted for component type and the baggies I've labelled with the values.
 
thewintersoldier said:
Y'all put more effort into Excell spreadsheets and stocking parts than you do building.
fetchimage
Click to expand...
I beg your pardon. I resemble that remark. My pathetic-ness is purely subjective. :cool:
 
"Spread sheet" is a dirty word in our house! And to be honest I'm not sure I've ever seen one...

If you buy resistors from Tayda they're barely 1c each, so if I see I'm getting low I order 100 with my next order. Same with MLCCs, etc. Caps I am a bit more conservative with because I like to buy the better quality ones like Wima and Panasonic. Recently I bought 100 each of 100µF, 47µF and 10µF from Mouser because I could get slightly smaller versions than I get from Tayda. Buying in lots of 100 gets you a better price at Mouser.

But this remains a hobby for me, so no spread sheets!
 
You must log in or register to reply here.
Back
Top