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
    • About
    • Catalog
    • CONTENT LIBRARY
  • PE Exam
    • PE Forum & Errata
    • PE Store
    • PE Tools
    • PE Prep Series
    • PE 100-Day Marathon
  • LOGIN
  • PRICING
    • SOFTWARE & TRAINING
    • STORE
  • THE CAUSE
    • ABOUT US
    • 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. 

Raffle Winners

4/24/2019

 
A huge thank you to the nearly 300 respondents to the survey posted a couple weeks ago. I am very appreciative of the feedback provided by so many, and I can promise you I've read every single comment provided by you, and I've already started implementing some changes to the site that were suggested.

I mentioned I'd raffle a Toolkit & free 2018 PE Prep Guide (good as a reference book), and I decided to raffle a couple of each. The winners are:
​Philip Valdez
and
Stephen Crotts
If you're interested, there were a total of 296 respondents to the survey. 87.5% of readers either specify, approve, or recommend products in the industry.
MeyerFire
Some common feedback for improvement include:
  • better search capabilities on the site,
  • more interactive flowcharts,
  • expansion on better variety of topics,
  • consider continuing educational content,
  • breaking the Toolkit into a la carte (individual tool) subscriptions,
  • better use of international standards/units, and
  • video tutorials of tools

​I am thrilled with these concepts and look forward to incorporating all of these in greater capacity going forward. 

2018 Fire PE Exam Stats + 2019 Exam Updates

4/16/2019

 
Should it be called "preparing" or "prepping" for the PE (Principles and Practice of Engineering) Exam?

If you've studied for the exam and spent hours and hours covering thousands of pages of material - it just might feel more like "prepping" for doomsday more than anything else. The required references for 2019 alone now cover 9 different books, 12 volumes and over 6,500 pages.

This week I'm covering a review of the 2018 exam and some updates to 2019 for the Fire Protection PE Exam.

Discouraging 2018 Results 

The overall results from all 241 examinees came in December, and the results were not great.

Pass rates for first-time examinees fell to 56%, the lowest this decade. The pass rate for repeat takers also fell to 28%, the lowest rate since 2015. These results are published annually by NCEES.
Fire Protection PE Exam Pass Rate
4th Toughest Exam for First-Timers

We once again maintain a distinction for having one of the most difficult exams to pass. The 56% pass rate for first time examinees ranks 4th toughest of the 24 different PE disciplines, behind only software, civil (construction), and power systems.
Fire Protection PE Exam
The overall pass rate (first-time and repeat takers combined) isn't much better with fire protection having the 7th most difficult pass rate.

On a related note one of the adjacent fields where some people working in fire protection get their PE is mechanical and architectural. Architectural used to have an overall pass rate above 80%, but that appears to no longer be the case. The Mechanical PE on Thermal & Fluid Systems has an overall pass rate of 60%, higher than fire protection but not by a large degree.
Fire Protection PE Exam 2018
Raw Cut Score about 70%

With the popularity of the Weekly Exam Series (a 20-week series of mini-exams for Fire Protection PE examinees), I've gathered significantly better analytics on the difficulty of the actual exam and how well studying translates to passing the exam. 

We're now able to better estimate the raw cut score (the percentage of questions correct to pass the exam), and how the difficulty of the Weekly Exams compares to the actual exam.

From the 2018 exam, we've estimated an overall raw cut score of 69-70%. 
 
MeyerFire User Pass Rates

The statistic I love and get asked about more than anything is what the pass rates are for people buying the PE Prep Guide and what the pass rates are for people doing the Weekly Exams. 

In short, it is very difficult to calculate this value now that the Prep Guide has become so popular. Consider this - on the 2018 exam over 2 out of every 3 examinees had the 2018 edition in their hand when they took the exam. Many who didn't have the 2018 edition brought a copy of the 2017.

In concept, if nearly everyone has a copy of the book on the actual exam, then it becomes more of a prerequisite to taking the exam than it does a boost only to the person using it. Where I have found differentiation, though, is between examinees who get a copy, study early, and study thoroughly. Somewhat obviously - the best prepared tend to do better on the actual exam.

As for pass rates of the Weekly Exam - I'm trying hard to get those exact values. If you used the Weekly Exam Series in 2018, I would be very grateful to hear from you and how the test went.

While I've reached out to everyone, I still haven't heard from the following users: Pepe Sylvia, GingerSnap, RoundONE, JT, Ginger, AB, JDB Falcon, onebadshark, MAXCRYPT, Senior, Old Guy, Ryan, Tip Top, na, dot dot dot, and yeass. [if you can't tell, we have a lot of fun on the Weekly Exam Series]

If you're one of these people, please shoot me an email at jdmeyer@meyerfire.com. Your input helps craft future editions and support success for others going forward.

A Checklist of Resources

Are you planning to take the 2019 exam? If so, you'll want to see our list of every resource we know to be available to you. The list includes formula sheets, practice exams, reference materials, Prep Books, Study Communities, and Courses. It's all here: https://www.meyerfire.com/pe-tools.html

Changes to the 2019 PE Exam

​Once again the exam writers can't help but make tweaks between each edition of the PE Exam. While published articles as old as five years ago suggested a narrowing of required references down to just the NFPA and SFPE handbooks, the actual exam references have done anything but condense.

For 2019, there's a few notable changes from the 2018 Exam (as published by SFPE):
  • NFPA 12-2015 was added as a required reference.
  • NFPA 24-2016 was added as a required reference.
  • NFPA 25 changed from the 2017 edition to the 2014 edition.
  • NFPA 30 was removed.
  • NFPA 92-2012 was added as a required reference.

Here's the year to year changes, with edition, additions or subtracted changes highlighted.
Fire Protection PE Exam Changes
The 2019 PE Prep Guide Release

Fortunately this year, SFPE released the required references earlier than in years past. As a result the 2019 PE Prep Guide, which usually would ship in June, will ship earlier. At this time I'm estimating a mid-may shipment of these editions for anyone who pre-orders a copy. Of course if you'd rather get a copy in your hands now, we still have the 2018 edition available.

Weekly Exam Prep Series

Back for a third year the Weekly Exam Prep Series will kick off June 3rd. If you're looking to get as much regular practice as is available anywhere in a fun exam-simulated pace, then this is for you. See where you rank and get access to over 400 questions with the Weekly Exams. Learn more about the Weekly Exam Prep Series here.

2019 vs. 2020 Exam

Big changes are ahead for the 2020 exam. Not only will the Fire Protection PE Exam transition to a computer-based exam, but the legacy of bringing in volumes and volumes of references will go away as well. As we understand it today, there will be a single, condensed reference book with formulas and charts that can be used on the exam - and that's it. It'll be a different delivery, different problem types, and a different reference.

It'll be a big change and without a doubt make 2020 examinees feel like guinea pigs in the sense of trying out something new to everyone involved (examinees, the exam writers, and prep material producers). That could be intimidating or could be an opportunity depending upon how you look at it.

Know someone interested in taking the PE Exam? Feel free to send them this article today.

Related:
Are you "prepping" for the 2019 PE Exam? Here's some related past articles on the topic:
A 2018 PE Exam Summer in Review
Updates for the 2018 Fire Protection PE Exam
Thoughts on the 2017 PE Prep Season
5 Tips to Crush P.E. Exam Prep
Fire P.E. Exam Ranked 3rd Toughest, 6th Overall
Collaborate with Others Studying for the PE Exam

Calculate the Quick-Response Area Reduction

4/10/2019

 
Looking for an opportunity to turn a basic concept into a controversial one on a project? Great! This week I'm exploring the quick-response remote area reduction that's provided in NFPA 13.

Suppress Early, Suppress Less
The concept behind reducing the calculated hydraulically remote area in a fire sprinkler system is entirely based on fighting a smaller fire earlier in the development of the fire.

There's a handful of factors that contribute to the timing of sprinkler response (a good future discussion), which include the thermal sensitivity, sprinkler temperature rating, distance of sprinklers relative to the ceiling, sprinkler spacing, ceiling height, and dynamics of the fire itself.

The reduction in the hydraulically remote area is based upon comparative tests of quick-response against standard-response spray sprinklers. According to the NFPA 13 handbook, the tests demonstrated that the earlier the water is applied to the fire, the smaller the fire and ultimately the less number of sprinklers needed to activate.

Not Universally Accepted
While the remote area reduction has been included in NFPA 13 for years, it's not universally accepted. Many engineer specifications don't allow the reduction, and design standards for major organizations such as the Department of Defense (UFC 3-600-01) don't permit it either.

Why not accept the remote area reduction, if NFPA 13 includes it? Like other elements in hydraulic design for fire sprinkler systems, not using the remote area reduction provides an additional safety factor to the system.

Additionally, since the quantity of sprinklers relates to the quantity of water flowing in the system, main sizes are directly impacted by using or not using the quick response area reduction. Building owners may opt to not want to reduce the remote area to preserve reasonable (larger) main sizes and give themselves flexibility on building modifications and sprinkler system changes in the future.

Quick-Response Area Reduction Calculator
This quick calculator is in part a checklist of prerequisites to reduce the remote area on a fire sprinkler system, in part a method of showing your work, and in part a quick calculator on determining your final remote area size. Don't see it below? Give it a try here.
​

This site is all about helping you shine in fire protection. Want these weekly tools & articles? Subscribe here, for free.

Updates to Flowchart for Canopies, Overhangs

4/3/2019

 
A little earlier than this time last year I wrote an article covering how NFPA 13 addresses sprinkler protection underneath canopies, overhangs, and exterior projections on buildings. It ended up as one of my favorites and I've had good feedback on it as well.

With the big changes in re-organization to the 2019 Edition of NFPA 13, it is only appropriate to make a few updates to the flowchart and get it in your hands so you can do what you do best.
​
Picture
subscribe & get the flowchart

Here's a link to the original article in full. If you haven't read it, it might be worth a few minutes here:
​
Picture
Sprinkler protection for canopies & overhangs are an important part of the overall protection scheme for a building.
If you know someone who might find this useful, please send this to them and let them know they can subscribe to these free weekly tools & resources here.
    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

    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 an International Code Council Preferred Education Provider.

All text, images, and media ​Copyright © 2022 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
    • About
    • Catalog
    • CONTENT LIBRARY
  • PE Exam
    • PE Forum & Errata
    • PE Store
    • PE Tools
    • PE Prep Series
    • PE 100-Day Marathon
  • LOGIN
  • PRICING
    • SOFTWARE & TRAINING
    • STORE
  • THE CAUSE
    • ABOUT US
    • BECOME AN INSTRUCTOR
    • HELP/SUPPORT