Category: 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…
-
Qualitative Analysis Using LLMs on a Local Machine
While most of my research is quantitatively oriented, I am a mixed-methods researcher and periodically use qualitative sociological methods for research projects (typically interviews). I have used a variety of software packages to analyze qualitative data over the years, from NVIVO to Taguette to an abandoned R package to just coding text in word processing…
-
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…
-
National Youth Leadership Forum-Engineering & Rice Elite Tech Camp
I posted previously about National Youth Leadership Forum (NYLF) and its extremely expensive summer camps. In that post, I detailed what the camps included and that, from my perspective as a college professor, the camps did not seem worth the money involved. Of course, I cannot call these camps “scams” because you are getting something…
-
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…