Tag: technology
-
LibreOffice Calc – Search for Specific Text Across Columns
I have a task I am asked to do fairly regularly that involves searching through a large spreadsheet (around 4,000 rows with about a dozen columns) looking for very specific text. There are, of course, various ways I could accomplish this. But I finally found a solution that speeds this up and want to document…
-
Batch Convert MP4 to MKV
I ran into an issue where a number of my MP4 files on my fileserver were stuttering when I tried to play them back using Plex on my TV. After a lot of googling, I found out that this was due to some header information in the MP4 files and that the simple solution was…
-
FreeCAD Import STL
I’m not a FreeCAD expert. I bought a 3D printer and am constantly coming up with new ideas for 3D prints to solve issues around my house and office. That required me to begin learning how to use CAD software and, as an open-source advocate, FreeCAD was the obvious choice for CAD. I design most…
-
Bambu A1 Mini – 0.2 extruder doesn’t work!
I bought a Bambu A1 Mini with the AMS in December 2023. It was supposed to be a present for my son so he could print some things. Well, he never really printed much on it, but I’ve been using it a lot. After nearly 8 months of printing dozens of projects on it, I…
-
Airtable Forms for Third-Party to Submit Updated Information
I have a use case that is probably more common than I realize. I am a faculty member at a university and our department wants to keep track of our alumni. To do that, we built an Airtable base that contains basic contact information for them. We can obviously update the base by hand, but…
-
Getting Ollama and Open WebUI Working on Kubuntu 23.10
I have two specific use cases for setting up AI locally instead of using ChatGPT (for which I have a subscription as I use it for a variety of tasks, as does my wife). I needed to analyze interviews but couldn’t upload them to the web for security reasons. I also wanted to work on…
-
3D Printing Flexible PLA or TPU on Bambu A1 Mini
I had an idea for a print that required flexible filament. The go-to flexible filament is TPU, but I was going to use the print with food, so I looked around for something that I thought would be safer with food and found Flashforge’s flexible PLA. I was excited to try out this print. Once…
-
Converting EPUB to Mp3 on Linux
I read a lot. It’s part of my job. But I also have times when I have to be physically up and about and could listen to an audiobook (e.g., mowing the lawn). I typically listen to podcasts at those times, but I do have some e-books I’d like to listen to that don’t have…
-
Linux – Adding BPM to ID3 Tags
I spent the better part of a year (in my spare time) organizing my music collection. With my music carefully organized and accurately tagged, I found myself wanting the Beats Per Minute (BPM) for some of my music and realized that BPM can be included in the ID3 tags of MP3 files or the Vorbis…
-
R – Combining Data from Two Variables
(NOTE: This was done in R 4.3.1 using RStudio 2023.03.0.) Here’s the scenario: I have a variable (V1) from Country A with roughly ~1,000 responses that measures religious affiliation with the following options: To be clear, there are no responses to V1 from the participants in the other country (Country B), only from individuals from…