Why Engineers Should Love Excel

When I was six years old, I came home from school unexpectedly excited one day.

I ran up our driveway, pushed wide the door and yelled to my mom.

“You won’t believe it! There’s this place at school where you can go through shelves and shelves of books and pick out anyone you want – 
and it’s free! They call it a library.”

It wasn’t one of my mom’s proudest parenting moments, but in our house, we never pretended to be great readers… or apparently even pretended to introduce kids to a library.

I guess I’ll just come out and say it… Both of my parents are accountants.

Now, I know what you’re thinking, and yes, the accountants are where my well-rounded sense of humor comes from.

But there’s another big benefit to having parents as accountants – 
and it’s having a love for spreadsheets.

I’m not sure if little excel formulas naturally run through my veins or whether it was every family calendar my parents ever created, but one way or another I thoroughly appreciate the power a spreadsheet has.

Even if your parents are not both CPAs, there’s a place for Microsoft Excel in your engineering life.

Excel isn't just made for your uncle accountant anymore - there's potential any engineer can love.

For one, Microsoft Excel is not called
the “Swiss Army Knife of Software” for naught. Excel is a blank canvas for any calculation you need to make. You can quickly create and repeat repetitive calculations to speed up and organize your workflow. You can complete reports, forms, create charts, tables, organize content, or use any of a myriad of highly powerful tools.

Here are a few of my most often used formulas:
​

• =concatenate(cell,”psi")      Will combine strings from any combination of cells or text, in this case cell A1 and psi
• =lookup(cell,range)             Will lookup a value in a cell against a table. Great for quick reference calculators.
• =vlookup(cell,range,column number,match)    Will lookup a value in a table and return adjacent results
• =if(test,value if true,value if false)     Determines a logical test and returns different values on the outcome.
• =countif(range,value)          Will count specific items in a list if they match criteria.

That’s pretty much all of my secret sauce. About 95% of the tools created combine those formulas alongside mathematical operators (like max(), min(), sin(), sqrt(), etc.).
​
One of the best parts about using Excel is that you may already have access to it. If your company has a Microsoft Office suite (or what’s now their subscription model with Office 365), you already have access to these tools.

Creating helpful resources is what we’re all about, and Excel is the epitome of giving you, the rockstar designer or engineer, the ability to create and flourish with the tools you need. 

You didn’t get into the industry to do poor, sloppy work. You came here to help save lives. We shouldn’t have to wait for programmers to create the daily tools we need to do great work. Excel is one way you can organize and validate the great work you do.

There came a point near the end of my undergraduate work and at the beginning of graduate school where I realized I needed to create a clean, organized method to show details within calculations. The method I slowly developed needed a single logic path, had to be easy to follow, would thoroughly explain the process, and had to allow the easy repetition of the work.

What’s resulted is the standard format that’s used in the PE Prep Guide and on many of the tools you’ll see around this site. Concepts are researched, painstakingly created, tested, refined, tested, refined, beta tested, and refined more.
​

Standard formatting for MeyerFire tools - note the equations and worked examples with references cited.

If you’ve followed the blog for a while, you already know the blog, daily forum, and even the PE prep materials are all created to help foster discussion that leads to shared expertise and knowledge.

Outside of a few major players and organizations, the fire protection industry is comprised of thousands of thousands of small outfits that welcome this shared expertise. Our industry thrives on the contributions from a wide spread of individual parties.

​Don’t let me or anyone else douse your enthusiasm to create resources that improve your ability to impact the industry. 

Keep on keepin’ on. 

​Oh and remember to take your kids to the library.