John Ormsby (aka NASANUT) sent in what he playfully called a Dumb Question:
I have a spreadsheet that contains a 10 by 10 matrix of values. Each value is different. There are column headings at the top, ranging from 0 to 9 and there are row headings on the left, also ranging from 0 to 9.
What I want to do is this. I want to search for a value within the matrix, and if found, want Excel to tell me the row and column that it is in. In other words, if I search the matrix for ‘150’ and it is found at cell F7, then Excel can either tell me ‘F7’ or the row and column headings (I can work with either).
The problem I have is that all of my searching only results in information on how to go the other way (i.e. provide the column and row and ‘find’ the value).
The beautiful thing about this question is that a) it’s not at all dumb, it’s a surprisingly hard problem, and b) I had a lot of other things on my to do list (some of them fairly urgent) but of course I dropped everything to try to figure this out!
In this week’s episode, I open with the sad news that Reggie Ashworth, author of the great apps AppDelete and VidConvert has passed away. We have a minor bit of news about Clarify that is slightly hopeful that it will survive into the next version of Mac App Store (but don’t get your heart set on it). Then we finally start having some fun as we play interviews from CSUN’s Assistive Technology Conference: Second Sight and Orcam MyEye 2.0. I answer a dumb question about why I care so much about accessibility. Then I’ll give you a multi-media tour of a free app from Microsoft called Seeing AI.
Listener (and good friend) Rally brings us our Dumb Question this week:
When MacOS High Sierra is installed, the photo and video formats are changed to HEIF and HEVF, respectively. I presume that means that the Photos library on the Mac is updated to this new format for all the pictures in the local library.
Is the iCloud Photos library also updated? If not, what happens when new HEIF photos are uploaded to the library?
I also have about 50 Photos libraries from our travels on my NAS device (i.e., they are not the system Photos library). How would they be managed under High Sierra when I use them in my videos?
This week’s Chit Chat Across the Pond is Lynda Gousha and I talking about the new hotness, and I recommend listening to the latest Let’s Talk Apple at lets-talk.ie/… if you want to really understand the Irish tax kerfuffle with Apple. We got the chance to actually use the PowerAll Power Bank to jump start our car. We have two Dumb Questions, one about how to figure out what photos aren’t in any album in Apple Photos, and the second asking why people care about Playlists. That launches me into an explanation of how I finally was able to get Pocketcasts to do what I lost when they removed playlists. We’ve now got a Patreon set up for the NosillaCast, so please head over to podfeet.com/patreon and pledge some money to help the show, but ONLY if you can afford it! I’ve decided to take on the challenge of building my own IRC chat server (with a lot of help from Bart of course) so I walk you through what we’ve done so far.
Hello Granny, congratulations on your first Grand Geek. I’ll assume it’s okay to say “Grand Geek” because any baby brought in by Apple Watch has got to be a Grand Geek, right?
Anyway, Todd McCann from the Trucker Dump Podcast. Here’s the problem to be solved. I am apparently an idiot. I keep hearing the podcasters I listen to and any reviews I see about new podcasting apps, everything revolves around podcast playlists. For the life of me I can’t figure out why anybody would want to make a podcast playlist.
I mean, music? Sure! 3 minute song, there’s a whole bunch of them, want to listen to a whole bunch in a row, I understand. Podcasts? 45 minutes, an hour, 2 hours if you’re looking at MacBreak Weekly, something like that, why would you want to make a podcast playlist when you’re only going to be looking for a new podcast every 45 minutes or so.
Our Dumb Question this week comes from John Ormsby, aka NasaNut in the chat room. He’s asking whether it’s ok to follow the advice of some app developers and partially turn off the protections Apple has put in place in El Capitan.