Category Archives: Uncategorized

Excel tip – adding two numbers where one is text

Just a quick tip as i couldn’t quickly find the answer in google.

If you have two cells of data and you want to add them when one might have text instead of a number, use the SUM function.

For instance

Class Section 1
QTY
Section 2
QTY
Totals
Robots 10,000 1,000 =sum(B2:C2)
=11,000
Humans 9,000,000,000 n/a =sum(B3:C3)
=9,000,000,000
Plants n/a n/a =sum(B4:C4)
=0

I also searched for: sum two values if isnumeric, excel add two numbers if text only include the non text and excel add two numbers if text.

Office music

isolation with headphones

or Togetherness by synchronised streaming?

​

Apps used: 

  • Logitech media server (aka squeezebox) – running on a  Raspberry Pi
  • Squeezer (Android) for remote control, queuing tracks, playlist management and synchronising the players
  • SB player (Android) to play the 

    Ps, it’s way past my bedtime! Insomnia is a pain. Goodnight all. 

    Nail surgery; aka needle phobia

    So, by the time this gets published, I’ll have had nail surgery. Partial nail avulsion, is the technical term. Part of my nail is getting cut off, then the nail bed killed with a chemical. This is actually the second time I’ve had this done on this particular toe, just the other side’s gone bad this time.

    Part of the process involves having local anaesthetic injected into the toe. It is really quite painful, and I’m told makes the toe swell quite impressively as the anaesthetic goes in. I mention this, because I’m terrified of needles and injections. When I’m in the same room as one that I can see, I almost can’t take my eyes off it, it just seems like a thread. Nuts, but there we are.

    I’ve told this story a few times, but not to my blog I think. It goes back to when I was in hospital, going to have an appendectomy because my appendix was threatening to go pop. Junior doctor decided it would be a great idea to draw blood, and leave a port type thing in my elbow so that they could push anaesthetic in later at need.

    So, in went the needle.. and ow. Very ow. Very very ow. Apparently, I’ve inherited veins that seem to move, and don’t like to be pinned with needles very easily. Eventually, he gave up and pull it out. The needle that’d been very straight going in, was now bent 90 degrees. I don’t know how he did it, but ow ow ow ow.

    Refused to let him try again, refused to let a senior doctor try again. In the end they agreed to use anaesthetic cream on my palm, then take the blood they needed from there. Anyway, ever since I’ve been scared of injections and needles. Yay! Surgery’ll be fun 😉

    Daily blog

    Just because, I’m gunna try to blog daily again. Obviously, I’m cheating, loading multiple blogs in at once and having them post automagically, but still. Something for every day. Even if it’s something short like this!

    Bodies are stupid. Soon, I’m going to have surgery on my foot, because apparently nails sometimes curl and cut into the nailbed. This is pleasant… \s

    Antihistamines, general rambling

    Apparently, cetirizine hydrochloride, the root chemical in a lot of common antihistamines has, this year, developed a new side effect for me. Absolute, stunning, crippling exhaustion. So. I’ve yet to try loradatine this year, but now I’m kinda scared. Gunna have to try it on a weekend, when getting crippling exhaustion doesn’t matter. Till then, yay for itchy eyes and running nose.

    Annoyingly, I did something neat with Magento the other week, and meant to post about it here. I forget what it was now though :/ When you’re doing an average of 20-30 support tickets a day, these things just vanish from the head. Note to self: Write a draft in the meantime.

    Setup a ProjectZomboid server for a friend. It’s running pretty well. One thing that I did run into, it seems it eats system entropy. That’s fine on a hardware server, but commonly on Virtual Machines (like the one I run most things on), entropy starvation is a thing. When that happens, the PZ server takes a very long time to start, as it’s gathering sufficient entropy for something. A quick fix is to install an entropy generator. Currently using “haveged”. Not sure how secure that is; but it’s better than everything requiring secure random numbers choking. Anyone have any preferences for entropy generation on a VM?

    Let’s Encrypt!

    I signed up for the closed-beta of let’s encrypt earlier, so this blog is now encrypted. So far, so good. I’d quite like to use the SSL certificate it provides in my Jabber server, but I’d need to automate renewal.. and it’s not *quite* there yet.

    Let’s Encrypt’ll hit open beta soon. Looks like the only feasible way HTTPs will be supported widespread. Even with domain validated SSLs, ssls cost too much at the moment, and are too much of a hassle.