It’s an often-overlooked fact that XLOOKUP needn’t work with just a single lookup value or even a single search column. The search value is straight forward, you’d expect that a single value could be a string pieced together from multiple sources. Before going further let’s look at an example, this first sheet of data represents […]
Category: Uncategorized
Like any programmer I use a keyboard practically every day, and finding a decent keyboard that’s right for you can be somewhat of a lottery. Being sick of my spare keyboard which feels like typing on some squishy sea creature (my usual keyboard developed intermittent keys), I decided to visit a retail store so I […]
Sometimes even the best of us end up scratching our heads trying to work out why a complex chain of matrices isn’t being applied as we expected, and for the novice to computer graphics getting an intuitive grasp of how matrix multiplications chain together can be rather difficult. So I built a tool to allow […]
I’m going to show a very simple plug-in, it will show the years, months and days since a given day, to ensure it has a reasonably unique name (which is important) I’ve called it sincer. Sincer will use wordpress short codes to insert the date interval into any post, so first it’s worth looking at […]
Pointers can be a confusing topic for the new C programmer, often explanations get bogged down in too much technical detail, or are just too simplistic. I’m going to attempt to show in both a simple and comprehensive manner just what pointers are and how to use them. First let’s consider the design of a […]
I bought a couple of 68008 CPU’s years ago always meaning to make something, as the 68000 series has a great instruction set and is fun to code on! First job was just to verify that I hadn’t been sent a counterfeit or DOA part… sadly something that is always a possibility theses days. As […]
Its fairly common to see libraries that are written in C++ but only offer a C API (some also offer C & C++ API’s). As someone who much prefers to code in C, I’ve sometimes needed to link my C application with a library that’s written in C++ (for example ODE). My initial solution was […]
For the purposes of this post, a very simple scenario is going to be considered. Given a Model structure that holds a pointer to a Mesh structure, the issue to be addressed is to whether or not there are references to a particular Mesh. Once all Models that reference a Mesh have been freed we […]
While this product is intended to be used with a Raspberry Pi, I bought it specifically to use with my FPGA board, having a HDMI (DVI) port on such a tiny board, just inspires a mobile build! While there is a PI type connector on the board, you can simply use the LCD as a […]
While originally waiting for my board to arrive I found and got a Z80 soft core working (in simulation) I was a little disappointed that tri-state logic seems to cause issues with yosys (I think that might be what was causing the logic “loops” later down the toolchain anyhow). Having recently gotten around to soldering […]