I need a formula that returns a value based on data like this: Here’s a graphical explanation of what I’m supposed to get out of the data: If the data looked like this: then it would be very easy, for example with: =IF(A:A="","",LEN(A:A*LEFT(B:B,FIND(" ",B:B)-1))-FIND(".",A:A*LEFT(B:B,FIND(" ",B:B)-1))) But sadly the data isn’t […]
Monthly Archives: March 2026
230 posts
I have an issue with the challenges.cloudflare.com domain that my browser is downloading (and uploading) large amounts of data from every now and then. The data usage is within less than a 10 hour period as you can see in the 2nd screenshot. I suspect it might be one of […]
I’m customizing my Linux Computer to act as a smart TV. I have a Roku Remote laying around. Is there anyway to hook into the presses of a Roku Remote on my Linux Computer to for instance press space to pause a video or similar? I imagine I can configure […]
I want the user to be able to key the name of the CMD, and an optional variable to be passed to the CMD. Would that just be CMD-name variable? Or …. In the CMD file, how do I receive that variable? What if the user does not pass the […]
I am trying to understand how modern SSD controllers place pages when using superblock or superpage striping across internal resources such as channels, chips, dies, and planes. From what I understand, a superpage and superblock are a group of flash pages and a group of flash blocks that are at […]
I have some websites that make good use of certain colors with CSS, all within the CMYK gamut. Long story short: different GPU’s and screens, which all have 99% or more of the entire CMYK gamut all show up different on each. They’re usually more saturated when they shouldn’t be. […]
Magento 2 catalog permissions help store owners control which products or categories each customer group can view. By setting these… Continue reading on Medium »
during the last couple of days my internet experienced short outages, today it was out for over an hour, internet provider checks show signal good to house hookup, have had this item for multiple years with no previous problem. How do I determine if item is on point of failure, […]