Category Archives: Uncategorized

This is an upgrade to my earlier blog “My First Custom Excel Ribbon using Excel-DNA“, now written for dotnet core. I add in Microsoft.Extensions support for dependency injection, configuration, and for logging, which should be an easy way to hook up to your app settings, plus quickly set-up your DI and logging frameworks of choice (e.g.Continue reading “My First Custom Excel-DNA Add-In (dotnet6 edition)”

git is the defacto way to manage source code, if you haven’t heard of git this blog is not for you. If you are a software developer, data scientist, data engineer, dev ops engineer or frankly in any role that touches software development, and you haven’t heard of git … well, where have you been?Continue reading “Super Power your git config”

This article is very persuasive. By the end you will wonder why you ever used Visio. It gets more technical as you progress, so stop reading whenever you want (I suppose this is true whether I wrote this sentence or not). I discuss: Just want the code? https://bitbucket.org/andysprague44/sprague.andy.plantuml.c4 C4 C4 diagrams are a great wayContinue reading “Diagrams as Code – C4 diagrams with Azure icons”

So I recently picked up a legacy(ish) python application that had a CI/CD pipeline that built from a setup.py file (think: python setup.py build). I wanted to create a local dev environment using the only sensible choice (excluding docker) – conda. I also wanted to utilize an environment.yml file to give new developers a veryContinue reading “Python – (Ab)Using Environments”