I have been using an excel spreadsheet to list all the bolts (during the design we try to minimise different types and lengths of bolts where possible).
The spreadsheet has the item description (ie filter housing), the bolt size (M10, M12 etc), the bolt length (mm), the bolt type (hex head, cap screw etc), the material (A2-70, A4-70, Gr8.8 etc), the type of washers required and the quantity.
The drawings are examined and the fastener data for each item/component is then added to the excel table - that is the relatively easy, although tedious bit.
The problem I have is then going through the table to pick out all the same size bolts/washers/nuts etc of the same meterials to list for when we order the fasteners from one of our suppliers. Mistakes are being made at this stage that possibly means a shortage of bolts on the work site.
My questions are:
1. Does anyone use such an excel sheet successfully for a similar type of thing? (any samples/links??)
2. Is there software available for this sort of thing?
Any comments would be most welcome as I am coming close to counting my last bolts.....