hardman wrote: ↑Sat Mar 23, 2024 9:13 pm
I use an Excel spreadsheet from which I created a Pivot Table. It allows me to sort by one or more of the attributes listed below simultaneously. The more you know about the knife you are looking for, the more specific it gets. It just requires that when you enter the knife into your inventory on the spreadsheet, you need to include as many attributes as possible.
The attributes I can sort by include the following. And, importantly, I can sort by as many attributes as I want simultaneously.
1) Manufacturer (e.g., Case Cutlery)
2) Model (e.g., 6347)
3) Type ( e.g. Folding or Fixed)
4) No. of Blades (e.g., 3)
5) Style (e.g., Stockman)
6) Handle Cover Material (e.g., Bone)
7) Blade Steel (e.g., Stainless Steel, or Damascus, or Whatever)
8.) Size, in inches (Closed for Folders; Overall length for Fixed)
9) Year (if known)
10) Date Acquired
11) Other Identifying Descriptors (Free form text to help describe the knife)
12) Price
If I were to recreate my database/spreadsheet, I would also include an attribute for source, as in where did I get the knife from.
So, once opening my spreadsheet I can filter or sort using the Spreadsheet itself or the Pivot Table function. For example, I can ask it to show me only my Case Cutlery Redbone Whittlers with three blades that have Chrome Vanadium steel blades. And that is what it will show me, and nothing else. And, it will give me a subtotal showing what I collectively paid for the knives meeting that description.
I can carry this spreadsheet right on my phone, so I always have it with me.
In a perfect world, I would love to have a photograph of each knife linked to its description in the Spreadsheet. But that could definitely result in a file size that would be a problem, and therefore make it difficult to transfer between my computer and my phone. As it is now - without a photograph - I can just email the spreadsheet with Pivot Table from one to the other.
Probably more than you ever wanted to know. Sorry.
