MeyerFire
  • Blog
  • Forum
  • THE TOOLKIT
    • SUBMIT AN IDEA
    • BACKFLOW DATABASE*
    • CLEAN AGENT ESTIMATOR*
    • CLOUD CEILING CALCULATOR
    • DOMESTIC DEMAND*
    • FIRE FLOW CALCULATOR*
    • FIRE PUMP ANALYZER*
    • FIRE PUMP DATABASE*
    • FRICTION LOSS CALCULATOR
    • HANGER SPACER*
    • IBC TRANSLATOR*
    • K-FACTOR SELECTOR*
    • NFPA 13 EDITION TRANSLATOR ('19 ONLY)
    • NFPA 13 EDITION TRANSLATOR ('99-'22)*
    • LIQUIDS ANALYZER*
    • OBSTRUCTION CALCULATOR
    • OBSTRUCTIONS AGAINST WALL*
    • PLUMBING FIXTURE COUNTS
    • QUICK RESPONSE AREA REDUCTION
    • REMOTE AREA ANALYZER*
    • SPRINKLER DATABASE*
    • SPRINKLER FLOW*
    • SYSTEM ESTIMATOR*
    • TEST & DRAIN CALCULATOR
    • THRUST BLOCK CALCULATOR
    • TRAPEZE CALCULATOR
    • UNIT CONVERTER
    • VOLUME & COMPRESSOR CALCULATOR
    • WATER STORAGE*
    • WATER SUPPLY (US)
    • WATER SUPPLY (METRIC)
  • UNIVERSITY
    • JOIN
    • CATALOG
    • CONTENT LIBRARY
  • PE Exam
    • PE Forum & Errata
    • PE Store
    • PE Tools
    • PE Prep Series
    • PE 100-Day Marathon
  • LOGIN
  • PRICING
    • SOFTWARE & TRAINING
    • STORE
  • OUR CAUSE
    • ABOUT MEYERFIRE
    • BECOME AN INSTRUCTOR
    • HELP/SUPPORT
Picture

Why Engineers Should Love Excel

4/25/2019

 
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.

Engineering Microsoft Excel
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.
​
Sprinkler Trapeze Calculator
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. 


Comments are closed.
    Picture
    Why Sponsor?

    ALL-ACCESS

    Picture
    GET THE TOOLKIT

    SUBSCRIBE

    Get Free Articles via Email:
    + Get calculators, tools, resources and articles
    + Get our PDF Flowchart for Canopy & Overhang Requirements instantly
    Picture
    + No spam
    ​+ Unsubscribe anytime
    I'm Interested In:

    AUTHOR

    Joe Meyer, PE, is a Fire Protection Engineer out of St. Louis, Missouri who writes & develops resources for Fire Protection Professionals. See bio here: About


    FILTERS

    All
    Announcements
    Book Review
    Calculators
    Career
    Course
    Design Challenge
    Fire Alarm
    Fire Events
    Fire Suppression
    Flammable & Combustible Liquids
    Flexible Drops
    Floor Control Valve
    Life Safety
    News
    NICET
    Passive Fire Protection
    PE Exam
    Products
    Site Updates
    Special Hazards
    Sprinkler Systems
    Standpipes
    Tools
    Videos


    ARCHIVES

    May 2023
    April 2023
    March 2023
    January 2023
    December 2022
    November 2022
    October 2022
    September 2022
    August 2022
    May 2022
    April 2022
    March 2022
    February 2022
    January 2022
    November 2021
    October 2021
    September 2021
    August 2021
    July 2021
    June 2021
    May 2021
    April 2021
    March 2021
    February 2021
    December 2020
    November 2020
    October 2020
    August 2020
    July 2020
    June 2020
    May 2020
    April 2020
    March 2020
    February 2020
    January 2020
    December 2019
    November 2019
    October 2019
    September 2019
    August 2019
    July 2019
    June 2019
    May 2019
    April 2019
    March 2019
    February 2019
    January 2019
    December 2018
    November 2018
    October 2018
    September 2018
    August 2018
    July 2018
    June 2018
    May 2018
    April 2018
    March 2018
    February 2018
    January 2018
    December 2017
    November 2017
    October 2017
    September 2017
    August 2017
    July 2017
    May 2017
    April 2017
    September 2016
    August 2016
    July 2016
    June 2016
    July 2015
    June 2015
    May 2015

    RSS Feed

Picture
​Home
Our Cause
The Blog
The Forum
PE Exam Prep
The Toolkit

MeyerFire University
​Pricing
Login
​Support
Contact Us
Picture

MeyerFire.com is a startup community built to help fire protection professionals shine.
Our goal is to improve fire protection practices worldwide. We promote the industry by creating helpful tools and resources, and by bringing together industry professionals to share their expertise.

​MeyerFire, LLC is a NICET Recognized Training Provider and International Code Council Preferred Education Provider.

All text, images, and media ​Copyright © 2023 MeyerFire, LLC

We respect your privacy and personal data. See our Privacy Policy and Terms of Service. 
The views, opinions, and information found on this site represent solely the author and do not represent the opinions of any other party, nor does the presented material assume responsibility for its use. Fire protection and life safety systems constitute a critical component for public health and safety and you should consult with a licensed professional for proper design and code adherence.

Discussions are solely for the purpose of peer review and the exchange of ideas. All comments are reviewed. Comments which do not contribute, are not relevant, are spam, or are disrespectful in nature may be removed. Information presented and opinions expressed should not be relied upon as a replacement for consulting services. Some (not all) outbound links on this website, such as Amazon links, are affiliate-based where we receive a small commission for orders placed elsewhere.

  • Blog
  • Forum
  • THE TOOLKIT
    • SUBMIT AN IDEA
    • BACKFLOW DATABASE*
    • CLEAN AGENT ESTIMATOR*
    • CLOUD CEILING CALCULATOR
    • DOMESTIC DEMAND*
    • FIRE FLOW CALCULATOR*
    • FIRE PUMP ANALYZER*
    • FIRE PUMP DATABASE*
    • FRICTION LOSS CALCULATOR
    • HANGER SPACER*
    • IBC TRANSLATOR*
    • K-FACTOR SELECTOR*
    • NFPA 13 EDITION TRANSLATOR ('19 ONLY)
    • NFPA 13 EDITION TRANSLATOR ('99-'22)*
    • LIQUIDS ANALYZER*
    • OBSTRUCTION CALCULATOR
    • OBSTRUCTIONS AGAINST WALL*
    • PLUMBING FIXTURE COUNTS
    • QUICK RESPONSE AREA REDUCTION
    • REMOTE AREA ANALYZER*
    • SPRINKLER DATABASE*
    • SPRINKLER FLOW*
    • SYSTEM ESTIMATOR*
    • TEST & DRAIN CALCULATOR
    • THRUST BLOCK CALCULATOR
    • TRAPEZE CALCULATOR
    • UNIT CONVERTER
    • VOLUME & COMPRESSOR CALCULATOR
    • WATER STORAGE*
    • WATER SUPPLY (US)
    • WATER SUPPLY (METRIC)
  • UNIVERSITY
    • JOIN
    • CATALOG
    • CONTENT LIBRARY
  • PE Exam
    • PE Forum & Errata
    • PE Store
    • PE Tools
    • PE Prep Series
    • PE 100-Day Marathon
  • LOGIN
  • PRICING
    • SOFTWARE & TRAINING
    • STORE
  • OUR CAUSE
    • ABOUT MEYERFIRE
    • BECOME AN INSTRUCTOR
    • HELP/SUPPORT