MeyerFire
  • Blog
  • Daily
  • Exam Prep
    • CFPS Tools
    • NICET Tools
    • PE Forum & Errata
    • PE Problems
    • PE Store
    • PE Tools
    • PE Prep Series
  • TOOLS
    • TOOLKIT (FREE TRIAL)
    • *TOOLKIT (PURCHASE)
    • SUBMIT AN IDEA
    • BACKFLOW DATABASE*
    • CLEAN AGENT ESTIMATOR
    • CLOUD CEILING CALCULATOR
    • DOMESTIC DEMAND
    • FIRE PUMP ANALYZER
    • FIRE PUMP DATABASE*
    • FIRE FLOW CALCULATOR*
    • FRICTION LOSS CALCULATOR
    • HANGER SPACER
    • IBC TRANSLATOR*
    • K-FACTOR SELECTOR
    • NFPA 13 EDITION TRANSLATOR ('19 ONLY)
    • NFPA 13 EDITION TRANSLATOR ('99-'19)*
    • LIQUIDS ANALYZER*
    • OBSTRUCTION CALCULATOR
    • OBSTRUCTIONS AGAINST WALL*
    • PLUMBING FIXTURE COUNTS
    • REMOTE AREA ANALYZER
    • QUICK RESPONSE AREA REDUCTION
    • SPRINKLER DATABASE*
    • SPRINKLER FLOW*
    • TEST & DRAIN CALCULATOR
    • THRUST BLOCK CALCULATOR
    • TRAPEZE CALCULATOR
    • UNIT CONVERTER
    • VOLUME & COMPRESSOR CALCULATOR
    • WATER SUPPLY (US)
    • WATER SUPPLY (METRIC)
  • CODE CALLS
  • LOGIN
  • STORE
  • About
Picture
WEEKLY TAKEAWAYS AS A FIRE PROTECTION ENGINEER

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?

    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:

    The Toolkit

    Get access to every tool, the downloadable Toolkit, Sprinkler Database, Calculators and more:
    Picture
    Picture
    See all the details here.
    FREE 30-DAY TRIAL
    GET THE TOOLKIT

    Author

    Joseph Meyer, PE, owns/operates his own Fire Protection Engineering practice in St. Louis, Missouri. See bio on About page.

    Categories

    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

    Archives

    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

Home - About - Blog - Contact - Exam Prep - Store
Picture
Copyright © 2020 MeyerFire, LLC
The views, opinions, and information found on this site represent solely the author shown 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. Some (not all) outbound links on this website, such as Amazon links, are affiliate-based where we receive a commission for orders placed elsewhere.
  • Blog
  • Daily
  • Exam Prep
    • CFPS Tools
    • NICET Tools
    • PE Forum & Errata
    • PE Problems
    • PE Store
    • PE Tools
    • PE Prep Series
  • TOOLS
    • TOOLKIT (FREE TRIAL)
    • *TOOLKIT (PURCHASE)
    • SUBMIT AN IDEA
    • BACKFLOW DATABASE*
    • CLEAN AGENT ESTIMATOR
    • CLOUD CEILING CALCULATOR
    • DOMESTIC DEMAND
    • FIRE PUMP ANALYZER
    • FIRE PUMP DATABASE*
    • FIRE FLOW CALCULATOR*
    • FRICTION LOSS CALCULATOR
    • HANGER SPACER
    • IBC TRANSLATOR*
    • K-FACTOR SELECTOR
    • NFPA 13 EDITION TRANSLATOR ('19 ONLY)
    • NFPA 13 EDITION TRANSLATOR ('99-'19)*
    • LIQUIDS ANALYZER*
    • OBSTRUCTION CALCULATOR
    • OBSTRUCTIONS AGAINST WALL*
    • PLUMBING FIXTURE COUNTS
    • REMOTE AREA ANALYZER
    • QUICK RESPONSE AREA REDUCTION
    • SPRINKLER DATABASE*
    • SPRINKLER FLOW*
    • TEST & DRAIN CALCULATOR
    • THRUST BLOCK CALCULATOR
    • TRAPEZE CALCULATOR
    • UNIT CONVERTER
    • VOLUME & COMPRESSOR CALCULATOR
    • WATER SUPPLY (US)
    • WATER SUPPLY (METRIC)
  • CODE CALLS
  • LOGIN
  • STORE
  • About