No just SQL, actually Microsoft SQL, DevExpress XPO and DevExpress AFX together with an multitier source code generator that creates increment-able source code (developed by me in the past 5 years 🙂).
P.s. reading it back the answer could have been 'Yes'.
Well, that is way more sophisticated than my efforts done in access, excel and Dbase.... so a yes would be appropriate indeed.
Does a spare-part inventory system on-board ships count as special ?
Ocean going vessels carry thousands of different spares.
(included ladida options, e.g. individual setting of min/max volume, average consume rate, automated printing of order lists and online ordering. page per part data entry/modification)
Thanks all, after reading all this and giving it some more thought, I decided to use small anti-static bags.
The size of the bags is 10cm(4") x 15cm(6") with a zip-lock. From a ebay-shop I got 15 pack's of 50pcs (750bags) for about 120 Euro's. The bags are 'Metal-in' and 0.1mm (4mill) thick.
The size of the bags is 10cm(4") x 15cm(6") with a zip-lock. From a ebay-shop I got 15 pack's of 50pcs (750bags) for about 120 Euro's. The bags are 'Metal-in' and 0.1mm (4mill) thick.
Attachments
Next I must build a drawer-cabinet that holds 4 drawers that store the bags.
The drawers are (about) 60x60cm and 15cm high each drawer is divided into 6 10cm wide slots.
The exact wood measures are:
Bottom plate: 60cm x (60cm + (7 x 8d)); 1 needed (per drawer)
Front plate: 15cm x (60cm + (7 x 8d)); 2 needed (per drawer)
Dividers: 15cm x 60cm; 7 needed (per drawer)
Spacers: 10cm; 12 needed (for all drawers)
All plate's(boards) are of 8mm MDF (medium density fiber-board (http://en.wikipedia.org/wiki/Medium-density_fibreboard)).
You need wood-glue, a good quality tape and a bit of 'skill' to build the drawer.
After gluing the dividers in place, do not forget to lift the spacers (so they do not get glued in place).
The drawers are (about) 60x60cm and 15cm high each drawer is divided into 6 10cm wide slots.
The exact wood measures are:
Bottom plate: 60cm x (60cm + (7 x 8d)); 1 needed (per drawer)
Front plate: 15cm x (60cm + (7 x 8d)); 2 needed (per drawer)
Dividers: 15cm x 60cm; 7 needed (per drawer)
Spacers: 10cm; 12 needed (for all drawers)
All plate's(boards) are of 8mm MDF (medium density fiber-board (http://en.wikipedia.org/wiki/Medium-density_fibreboard)).
You need wood-glue, a good quality tape and a bit of 'skill' to build the drawer.
After gluing the dividers in place, do not forget to lift the spacers (so they do not get glued in place).
Attachments
Last edited:
I use a numbered drawer system. No particular order. Each drawer has 3 or 4 compartments. I use an excel spreadsheet to keep track of what is in each drawer. Someone said it before, you just have to remember to update the quantities on the spreadsheet or database. Since I don't keep that many of most individual values, I can keep multiple values in the same compartment. For my mass quantity selection, they are in individual bags in a "range" bag. I have a 0 - 1K bag, a 1K to 10K bag, etc.
Last edited:
This is the second part of the components-cabinet build.
After building the drawers we need to attach the rails to the bottom of the drawer, this is easily done using mounting-glue (as shown).
Next a simple box (one side open) is build, the height of this box matches the space under my lab-desk.
Width outside: 60cm + (2 x 8mm MDF) + (2 x 12mm rail) + (2 x 18mm board)
Height outside: (4 x (15cm + 8mm MDF drawer)) + (3 x 12mm space between drawers) + (2cm space on top) + (2 x 8mm MDF top and bottom)
After building the box, the drawer rails are mounted in the box.
Next the box is moved under the desk (the old cabinet is set to the side, it is hard to depart fro it, I have been using the old one for more then 30 years 🙂)
One last thing to do to the drawers, fronts have to be added and a small handle is then attached to the front.
The last pictures show the drawers in the cabinet. All done.
Total cost, 130 Euro.
See also http://www.diyaudio.com/forums/part...resistors-small-capacitors-5.html#post4157434 and http://www.diyaudio.com/forums/part...resistors-small-capacitors-5.html#post4157436
After building the drawers we need to attach the rails to the bottom of the drawer, this is easily done using mounting-glue (as shown).
Next a simple box (one side open) is build, the height of this box matches the space under my lab-desk.
Width outside: 60cm + (2 x 8mm MDF) + (2 x 12mm rail) + (2 x 18mm board)
Height outside: (4 x (15cm + 8mm MDF drawer)) + (3 x 12mm space between drawers) + (2cm space on top) + (2 x 8mm MDF top and bottom)
After building the box, the drawer rails are mounted in the box.
Next the box is moved under the desk (the old cabinet is set to the side, it is hard to depart fro it, I have been using the old one for more then 30 years 🙂)
One last thing to do to the drawers, fronts have to be added and a small handle is then attached to the front.
The last pictures show the drawers in the cabinet. All done.
Total cost, 130 Euro.
See also http://www.diyaudio.com/forums/part...resistors-small-capacitors-5.html#post4157434 and http://www.diyaudio.com/forums/part...resistors-small-capacitors-5.html#post4157436
Attachments
Last edited:
hi All, eying up A4 flip file dividers/wallets etc.
slide/negative holders v's business card holders v's gaming card holders.
(on paper) the latter is the winner:
RIO Direct 270 Pockets Trading Card Sleeves Storage Wallets Album Pages Collection, Neutral Transparent Game Card Sleeves Holder Set for Pokemon, Skylanders, Top Trumps: Amazon.co.uk: Toys & Games
"RIO Direct 270 Pockets Trading Card Sleeves Storage Wallets"
30 sheets of 9up giving 270 pouches for under a tenner.
portrait pocket & seemingly stout materials were the tipping points for me.
(9 up, use 6, 3 spare so 2 pages for each decade of E12 leaving about 50% unused sheets assuming roughly 90 in a set of 10ohm up to 10Meg)
Deffo not UV proof & undoubtedly great at generating static. ESD version by Bondline with 'sensible' price break pls?
Hope that helps someone out there
Cheers!
:-j
slide/negative holders v's business card holders v's gaming card holders.
(on paper) the latter is the winner:
RIO Direct 270 Pockets Trading Card Sleeves Storage Wallets Album Pages Collection, Neutral Transparent Game Card Sleeves Holder Set for Pokemon, Skylanders, Top Trumps: Amazon.co.uk: Toys & Games
"RIO Direct 270 Pockets Trading Card Sleeves Storage Wallets"
30 sheets of 9up giving 270 pouches for under a tenner.
portrait pocket & seemingly stout materials were the tipping points for me.
(9 up, use 6, 3 spare so 2 pages for each decade of E12 leaving about 50% unused sheets assuming roughly 90 in a set of 10ohm up to 10Meg)
Deffo not UV proof & undoubtedly great at generating static. ESD version by Bondline with 'sensible' price break pls?
Hope that helps someone out there
Cheers!
:-j
See here,
How do you store your Resistors and small Capacitors?
I never liked it.
The plus on these self made holders is, there of wood, no sagging no easy way to damage them, and a low investment cost 🙂
How do you store your Resistors and small Capacitors?
I never liked it.
The plus on these self made holders is, there of wood, no sagging no easy way to damage them, and a low investment cost 🙂
Thanks for adding the photos Jackinnj
(a experiencing liiiiiiitle bit of valve envy here)
nice compact flip thru access to the SMD r's
Cheers!
:-j
(a experiencing liiiiiiitle bit of valve envy here)
nice compact flip thru access to the SMD r's
Cheers!
:-j
Stop searching and building and getting irritated.
I use these for over 20 years.
Perfect for allmost anything but the biggest parts.
Zoekresultaten | Conrad.be
Place tape on the largest side and you know what's inside.
Give the boxes a unique code, like Rxx, Txx, Dxx, Cxx to make the difference for Resistorbox xx, Transistorbox xx, Diode, Capacitor.
If you make an excel sheet, with A - F on top and 1 to 10 on the side, you do not have to keep all the parts by their value (for instance semiconductors and ic.s). On your page you see eg.
BC108B - T01 - B6
2N3819 - T01 - B7
AF109 - T06 - F3
etc...
Works perfect...
Do you want to see my parts?
After 20 years of use.
Let me know.
Cheers
I use these for over 20 years.
Perfect for allmost anything but the biggest parts.
Zoekresultaten | Conrad.be
Place tape on the largest side and you know what's inside.
Give the boxes a unique code, like Rxx, Txx, Dxx, Cxx to make the difference for Resistorbox xx, Transistorbox xx, Diode, Capacitor.
If you make an excel sheet, with A - F on top and 1 to 10 on the side, you do not have to keep all the parts by their value (for instance semiconductors and ic.s). On your page you see eg.
BC108B - T01 - B6
2N3819 - T01 - B7
AF109 - T06 - F3
etc...
Works perfect...
Do you want to see my parts?
After 20 years of use.
Let me know.
Cheers
Not bad at all.
I will get some, it will not solve my resistor and capacitor storage while I do like the envelops, they allow easy insertion of new values and deletion of no longer needed value (I do hold stock for E48 but allow for additional values as needed).
I will get some, it will not solve my resistor and capacitor storage while I do like the envelops, they allow easy insertion of new values and deletion of no longer needed value (I do hold stock for E48 but allow for additional values as needed).
outstanding! Thankyou Tarzan!! the more ideas the merrier.
need to hit this:
https://www.weltroniker.de/DB-Pool/WEL_Blister.pdf
With google translate tomorrow as my language abilities are strictly limited to English & Bad English.
:-j
p.s. little chance of me stopping designing, building / making (sparks & sawdust mostly) but the sentiment was very much appreciated. ;-j
need to hit this:
https://www.weltroniker.de/DB-Pool/WEL_Blister.pdf
With google translate tomorrow as my language abilities are strictly limited to English & Bad English.
:-j
p.s. little chance of me stopping designing, building / making (sparks & sawdust mostly) but the sentiment was very much appreciated. ;-j
Yep, these are the boxes.
No messing around with ebveloppes, different size of whatever boxes, plastic bags...
Clean, easy, handy and they last for ages...
You can even store mica's, small switches, pusbuttons, spacers, pcb connectors (small), trimpots, LDR's, electrolitics (small), smd's.
Sorry, no sandwiches...
No messing around with ebveloppes, different size of whatever boxes, plastic bags...
Clean, easy, handy and they last for ages...
You can even store mica's, small switches, pusbuttons, spacers, pcb connectors (small), trimpots, LDR's, electrolitics (small), smd's.
Sorry, no sandwiches...
I keep all my resistors in plastic bags, and all those in a big cardboard box. Every time I need a resistor, I go through all the bags until I find it. No, they're not in any kind of order, just whatever order they ended up in the last time I looked for a resistor. I also have some common values in small parts cabinets that are labeled, and some easily read boxes in plastic storage bins. I do keep a master list of all values that tells me where to look. Sort of. Capacitors follow a similar system, I just don't have as many of them. Then there are the parts on reels out in the garage, lined up in cardboard boxes in no sort of order. Oddly, I have little trouble finding what I need in a couple minutes.