# excel

## Plotting dynamic ranges in Excel

One annoying thing about using charts in Excel to represent data is that by default it encourages you to define a finite sheet range to plot data. This can be annoying when you’re dealing with data where the total number…

## How have I not known this ….. until now …

Recently came across this thing in Excel completely by accident, unsure how long it has been a thing? I’ve never ever read anything about it before on the internet or ever seen anyone using it before. Maybe it’s been a…

## VBA functions for determining (and graphing of) moment, shear, and deflection for a simply supported beams +/- cantilevers (Part 3)

Well after saying here that there was limited practical use for point moments for a simply supported beam, so I wasn’t going to (didn’t see a need to) include them. I’ve eaten those words now and added the ability to…

## Using error bars to highlight chart values

This is a handy technique that I was recently reminded of, using error bars to highlight values on XY scatter charts. If you have an Excel chart you might often have the need to highlight a certain value of interest.…

## Fun with functions…. Improving Excels native REPLACE() function

You know what annoys me about Excels built in REPLACE() function, it does not work like the equivalent VBA function Replace() function. It’s that simple and that is enough of a reason to think twice about using it if you…

## VBA functions for determining (and graphing of) moment, shear, and deflection for a simply supported beams +/- cantilevers (Part 2)

One thing to state up front, the shear, moment and deflection are all based on the loads given, so if they are factored ultimate loads then the moment, shear and deflection are factored. Which for the deflection might not be…

## VBA functions for determining (and graphing of) moment, shear, and deflection for a simply supported beams +/- cantilevers (Part 1)

Today we bring you moment, shear, deflection stuff! Sharing some basic VBA functions for determining the moment, shear and deflection of a simply supported beam (with or without cantilever) under almost any typical loading scenario imaginable. Point loads, variable length…

## Fun with functions….Use cases for Excels LET() function

If you’re not aware of what the LET() function is, prepare to be informed (and get out from under the rock you’ve been hiding under!). The LET function was introduced in July 2020, and I must admit it wasn’t until…

## Excel…. Version control…. Git the hell out of here!

Version tracking Excel VBA code with git…. I’m not talking about uploading your spreadsheets to GitHub and calling it a day…. boring, we can do a bit better than that obviously! I’m talking about extracting your actual VBA code from…

## Stuff I should have known earlier … shortcuts…

The other day I learned a useful shortcut in windows, being that the Windows key + SHIFT + S opens up the snipping tool in windows, very handy. This is something I always used to open manually with a search…

## Drawing Reinforcement in Excel…Really (Part 3)

In Part 2 we covered the functions for creating coordinates for accurately representing shear reinforcement (stirrups and links) using an XY scatter chart in Excel. In this third and final part, we’ll cover the functions for outputting the minimum lengths…

## Drawing Reinforcement in Excel…Really (Part 1)

One thing that irks me about a lot of spreadsheets I’ve seen created over the years is the fact that the inputs for something that can be visualised are hidden behind a few numbers in cells. No visual representations of…

## To minimum or not to minimum, that is the question?

Minimum steel, love it or hate it, we have minimums for a reason even if it seems like overkill sometimes given that we may have very low demands. This post will demonstrate why (I hope) we are required to comply…

## Improving Excels spellchecker with highlighting

Excel does many things well, but it goes without saying many things could be vastly improved, or at the very least shown a bit of love by Microsoft. One particular thing in Excel that that causes me some frustration is…