Starting to transfer to a spreadsheet instead of my usual paper notebook I list all my electronics in to get a grasp on all my parts (towers, laptops, memory, motherboards, videocards, etc). Lately I’ve been on a kick of labeling all my shelves (medicine, linen, kitchenware) and trying to sort things into random plastic bins I’ve had laying around waiting for a purpose.

I realize I could dive into deep rabbit holes for every category. With electronics I’m thinking of documenting every chip, board, and component along with compatibilities. Pantries and personal goods could be inventoried and auto-reordered, better tracking of my tools and materials with service reminders for equipment, etc etc.

I’ve gone through years where I throw everything away and get rid of anything not used recently and years where I horde everything and anything. Seems moderation in both is key and why keeping it all in mind and documented seems like the right thing to do if you have the time to kill.

tldr, what tips or tricks do you use to keep up with all your shit?

    • Cataphract@lemmy.mlOP
      link
      fedilink
      arrow-up
      0
      ·
      1 year ago

      it’s not so much needing a computer as I’m trying to transition myself into newer and hopefully more efficient systems of data entry and cataloging. I’ve definitely had to take time to find a notebook I’ve misplaced and I type a lot faster than I write so it just makes sense. Looking at what has a certain type of memory I can pull from something not being used anymore is helpful and just fun in my opinion for brainstorming configurations. The past couple of years I’ve received a bunch of new stuff I need to figure out what I’m doing with it so time to streamline it all.

  • IMALlama@lemmy.world
    link
    fedilink
    arrow-up
    0
    ·
    1 year ago

    Personally I’ve been trending the opposite direction: getting rid of things. We had our first kid about 7 years ago, which has seriously decreased my time for tinkering. I didn’t realize it at first, so I kept on picking up projects that interested me, got some pieces for them, organized them, and… they’re still there years later. The worst a somewhat sentimental things, that don’t really see much use, and are also projects. For example, I bought the boom box of my youth. It’s from the 80s (it wasn’t new when I had it 25 years ago) and needs some TCL - potentiometers cleaned up, some loose connections run down, etc. It’s low on my list of things to fix because it doesn’t actually sound that great and cant compete with my Bluetooth speaker.

    • Cataphract@lemmy.mlOP
      link
      fedilink
      arrow-up
      0
      ·
      1 year ago

      I was at your stage a little over 10 years ago, renting and moving, kids slowly getting more things. Now they’re starting to move out and I’ve purchased a larger run down house that needs to be filled up. There’s some things I regret getting rid of like materials but for the most part I’m happy I don’t have so much to keep track of at the moment. The projects I’ve shelved for some many years are starting to get dusted off again and I’m finally getting back into hobbies and tinkering again. Definitely a good observation on the bluetooth speaker, there’s some things it’s just not worth putting the effort into unless it’s a niche need like a portable cassette player etc. I’m hoping you experience the same thing and get some of that time back in your future to do what you want.

      • IMALlama@lemmy.world
        link
        fedilink
        arrow-up
        0
        ·
        1 year ago

        Thanks for the thoughtful reply! I am holding on to some things in hopes of being able to do with the kids when they’re older, but it has been pretty liberating getting rid of some of this stuff.

  • digger@lemmy.ca
    link
    fedilink
    arrow-up
    0
    ·
    1 year ago

    The only thing I have inventoried is what’s in the attic. Everything is in large plastic totes by category. I keep a text file listing each tote and what’s in each. You looking for something specific? Search for that word in the text file and then go open up tote F3.

    The totes are color coded based on what category of item is in them & have their contents written on the lids using a chalkboard marker for anyone in the family who doesn’t want to use the text file.

  • xia@lemmy.sdf.org
    link
    fedilink
    English
    arrow-up
    0
    ·
    1 year ago

    Sounds easy. Well, straight-forward, at least. For such things i use “zim” (a desktop wiki). Tangibles (like a motherboard) get a page that contains “links” to all the variables and components you want to trak/index (the actual target pages don’t actually have to exist). I would the drop that page in a hierarchy of containers (building, room, box, etc). Then, you can locate the page using any of the backlinks (like, by component), and reference the page path if you actually need to lay hands on it in the future. There is also a search feature, but i like the backlinks.

  • Bear@lemmynsfw.com
    link
    fedilink
    English
    arrow-up
    0
    ·
    1 year ago

    I get rid of what I don’t want or haven’t used in years. No need to track anything.

  • Retro_unlimited@lemmy.world
    link
    fedilink
    arrow-up
    0
    ·
    1 year ago

    Nothing wrong with being organized. And knowing where everything is when you need it. But it’s also a ton of work.

    I have been packing for moving, so I have every box labeled and in a spread sheet of all contents (with serial numbers) and the size of the box too. It’s helped many times as I keep needing things I already packed.

  • Brkdncr@lemmy.world
    link
    fedilink
    arrow-up
    0
    ·
    1 year ago

    Spreadsheets are for math. You want a database, specifically an asset management database. Snipe-it for example.

    • Cataphract@lemmy.mlOP
      link
      fedilink
      arrow-up
      0
      ·
      11 months ago

      Thank you for the common sense response, it hadn’t clicked but I think this was my problem. The format of the spreadsheet and trying to make it work for my purposes just made me stop everytime I attempted it. This identified my problem I believe and now I can look into other options. As other’s have said, I probably could get it to work for my purposes but learning and understanding all the tools with the program just isn’t worth it for this one singular reason.

    • BearOfaTime@lemm.ee
      link
      fedilink
      arrow-up
      0
      ·
      1 year ago

      Meh, spreadsheets are for whatever you use them for. I use them for a lighter version of project management, where I don’t need all the rules of a project management app because they get in the way.

  • Toes♀@ani.social
    link
    fedilink
    arrow-up
    0
    ·
    1 year ago

    I had a buddy who made a custom Microsoft Access interface to track all the different coffees that they had.

    LibreOffice Base would be a reasonable choice if you don’t mind the effort to set it up.

  • 𞋴𝛂𝛋𝛆@lemmy.world
    link
    fedilink
    English
    arrow-up
    0
    ·
    1 year ago

    I used to track everything. Now I just keep stuff in regions of my room and know basically where to look. At the same time, I have nearly floor to ceiling drawer cabinets in my room, a closet full of shelves, and a raised bed I made to allow full size plastic totes to fit under. My electronics station is integrated into my bed with a swivel laptop stand that can work in bed or at my desk. For components, everything is organized by E95 log scale with the like number values consolidated. So like one drawer/container might have 0.47, 4.7, 47, 470, 4k7, 47k, 470k, and 4m7.

  • dustyData@lemmy.world
    link
    fedilink
    arrow-up
    0
    ·
    1 year ago

    What in the OCD is this? /s

    No, but seriously, I use only a spreadsheet for the things I need to track. Is there a proper small scale database solution?

  • cm0002@lemmy.world
    link
    fedilink
    arrow-up
    0
    ·
    edit-2
    1 year ago

    I’ve been getting around to giving a Grocy a try.

    It’s a pretty much an ERP system for the household (Even their tagline is “ERP beyond the fridge”)

    It supports a whole bunch of things, the least of which is household inventory tracking and it even has the ability to integrate with a barcode scanner. So you can tie it into like a product API to scan the retailer barcodes or tie it into your own DB for lookup for your own custom barcodes

    It’s a bit involved if you’re not into self hosting and servers and such though

    • Churbleyimyam@lemm.ee
      link
      fedilink
      arrow-up
      0
      ·
      1 year ago

      Grocy looks really good; thanks for the recommendation. Do you know if it can generate meal plans based on what you have in stock and tell you what you need to get to make particular meals? It looks like they have a ‘desktop’ version for those who don’t want to host it on their server too.

    • Crogdor@lemmy.world
      link
      fedilink
      arrow-up
      0
      ·
      edit-2
      1 year ago

      I tried Grocy for a while, but eventually stopped. Data entry was a huge pain.

      Using the iOS companion app to scan grocery items into the app resulted in data issues that prevented me updating the item in the web app later. The only recourse was to add the items by hand in the web app, but then go in to each one separately with the mobile app to register the barcode. This also resulted in losing the additional metadata about the products that the mobile app would automatically configure if you onboarded the items through the mobile app, as it was able to look up additional data online and prefill a lot of stuff.

      At the end of the day, it was too much of a hassle. I do like the idea, and may come back to Grocy again, but for now I have to pass.

      • RagnarokOnline@programming.dev
        link
        fedilink
        arrow-up
        0
        ·
        1 year ago

        Enterprise Resource Planning is the acronym I know. It’s usually used in a company context and is essentially a system that “can do it all” (HR, inventory management, customer relationship management, etc…)

  • Most people don’t do that. They just have general places to keep track of important things. Most people are far less organised than you.

    Some people on here are saying you come across as mentally ill in some way, but I don’t think that’s necessarily true. I would hope you naturally find some sense of joy or fulfillment in keeping track of different types of databases for minor practical benefits. I’m no psychologist though.

    • thermal_shock@lemmy.world
      link
      fedilink
      English
      arrow-up
      0
      ·
      1 year ago

      sometimes organizing things is a hobby and can ease stress. in your full control and helps calm the mind. not for everyone of course, but I don’t think it’s an illness either.

  • Etterra@lemmy.world
    link
    fedilink
    arrow-up
    0
    ·
    1 year ago

    I’ve got a Shulker farm, so I’m set for space. The trouble is that even after recursively duplicating trillions upon trillions of pens, I still can’t ever find one when I actually need it.