Travel, Tech, Thoughts…
-
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…
-
Aruba – Jamanota
I was in Aruba for four days for a conference. I didn’t have a lot of free time but, after checking out all of the details of the highest point, I thought that I could skip lunch one day, climb the highest point, and still make it back for the next session. So, I tried…
-
Invitation to Commit Scientific Fraud
I’m probably just naive and am definitely far too idealistic, but the email I just received crushed my spirit. I need to share it. Here’s the email with contact information removed but the website still intact so everyone can see who is doing this: Dear Professor, I’m XXXXX, a researcher at Well-online, the flagship editorial…
-
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…
-
Chocolate Ratings
I like chocolate. It’s probably my favorite sweet. Closing in on 50 years old, I came up with a new life goal – try as many types of chocolate as I can, rate them, and see if I can find my favorite chocolate. This page documents my ratings. Milk Chocolate Dark Chocolate White Chocolate (coming…
-
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…