Excel Archives - Being Brunel
Evaluate: Excel’s Dirty Secret
June 4, 2016
As much as I hate to promote the use of Excel, I’ll grudgingly admit that it’s a useful application. And until you’ve all learned Python- it remains one of the most popular pieces of engineering software today. So you might as well learn how to squeeze every last drop of functionality from it.Read More
More Engineering with Excel
May 14, 2016 4
The one thing that unites all engineers across the globe is a love of Excel. In fact, it’s more than a love, it’s an obsession- the things I’ve seen some engineers achieve with Excel…Read More
Microsoft Office for Engineers
March 10, 2014
Did you know that I maintain (adj. to sporadically apply fixes that break everything) three add-ins for the Microsoft Office suite? Each one borne out of a frustration with the software from continued exposure…Read More
Programming Civil Engineers
January 30, 2014 9
The world of engineering has been becoming progressively more digital; with monstrosities such as ProjectWise entering the common vernacular (verb. to make someone else’s document control…Read More
Parametric Design
October 14, 2013 4
After a weekend of prototyping (lit. creating an application from libraries and scripts loosely held together by hope and gaffa tape), this is the beginnings of my contribution to parametric design. “Woah” I hear you cry; “an application that draws…Read More
EngCel: Colours, Names and More
March 28, 2013 2
EngCel is a free add-in for Excel that I write and maintain. At its core EngCel it’s an easy-to-use in-line syntax for super-script, sub-script, Greek and mathematical characters. This week I thought I’d update you all on…Read More
CalcPaper for Excel
March 14, 2013
Tom asked if I would like to write a post. I have been impressed with Tom’s office add-ins. Similarly irritated by excel, I thought I too would post some useful excel macros that I have developed to overcome this.
Calculation…Read More
Inline Sub/Super- Script in Excel, and More…
October 25, 2012 23
I have written an Excel add-in called EngCel which does, however, make engineering in Excel a little more bearable. EngCel provides in-line superscript and subscript shortcuts for excel using the fairly standard ^ and…Read More
Engineering with Excel
August 30, 2012 4
Considering how ubiquitous the Office suite is, however, it is not that surprising that for (relatively) simple calculations, repetitive design methods and result processing most engineers turn to Excel. Despite how much it…Read More
