# Free Excel Template: Basic Seismic Vulnerability Scoring


> A simple scoring tool for deciding which buildings in a portfolio need a real seismic evaluation first — not a substitute for one.


*Structural Diagnostics — August 20, 2026 — 4 min read*

An owner with one building and a genuine budget for it can usually justify a proper seismic evaluation outright. An owner, facilities manager, or small engineering practice looking after a portfolio of a dozen or fifty older buildings has a different problem: which ones get looked at first, given that a full Tier 1/Tier 2 evaluation on every building in the same year is neither affordable nor necessary.

A basic seismic vulnerability scoring tool — a simple spreadsheet built around the same rapid-visual-screening-style factors used in formal RVS methodologies — exists to answer exactly that triage question. It is not, and was never meant to be, a substitute for a real structural evaluation. Its entire job is to turn a walk-through and a handful of known facts about a building into a rough, relative risk indicator that helps decide sequencing, not safety.

## What the Scoring Tool Covers

A basic scoring spreadsheet built on RVS principles typically pulls together four factors that correlate strongly with seismic vulnerability, each contributing qualitatively to an overall relative score rather than a precise engineering result:

**Building age relative to code era.** The single strongest proxy for whether ductile detailing requirements were actually in force when the building was designed — older generally scores higher-risk, with the exact cutoff depending on local code history.

**Vertical or plan irregularity.** Discontinuous lateral systems, re-entrant corners, and asymmetric stiffness distributions that concentrate seismic demand unpredictably.

**Soft or weak ground story.** Tuck-under parking, open storefronts, or an unusually tall or open ground floor relative to the floors above.

**Primary structural material and system.** Unreinforced masonry and non-ductile concrete frames score meaningfully higher-risk than modern steel or well-detailed reinforced concrete, all else equal.

| Scoring Factor | What It Flags | Why It Matters |
| --- | --- | --- |
| Building Age vs. Code Era | Whether ductile detailing requirements likely applied at design | Strongest single proxy for non-ductile failure modes |
| Vertical / Plan Irregularity | Discontinuous load paths, asymmetric stiffness | Concentrates seismic demand unpredictably |
| Soft / Weak Ground Story | Tuck-under parking, open storefronts, tall open ground floor | Associated with disproportionate collapse risk |
| Primary Structural Material/System | URM, non-ductile RC, steel, wood-frame | Different systems carry very different baseline vulnerability |

*Illustrative scoring structure only — an actual tool should be calibrated against a recognized methodology such as FEMA P-154, not used as-is for code compliance.*

## How It's Used in Practice

In practice, the tool is filled out by walking each building — or reviewing existing drawings and records where a walk-through isn't practical — and scoring each factor from readily observable evidence, not calculation: visible irregularity, apparent construction era, an obviously open ground floor. The spreadsheet then rolls the factor scores into a single relative number or color flag per building, red/yellow/green being the most common convention.

That output is a prioritization signal, not a verdict. A red flag means "evaluate this one sooner, relative to the others in the portfolio" — it does not mean the building is unsafe, and a green flag does not mean it's safe. Framed as illustrative relative scores across a few common building types, the pattern usually looks something like this:

![Dilapidated brick building with a weathered, peeling facade](https://images.unsplash.com/photo-1755502778032-d570687240ab?q=80&w=1200&auto=format&fit=crop)

*Building age and visible material condition are two of the easiest-to-observe inputs to a basic vulnerability score. — Photo: [Jakub Żerdzicki](https://unsplash.com/@jakubzerdzicki)*

**Illustrative Relative Risk Score by Building Type**

- Unreinforced Masonry, No Retrofit: 85%
- Non-Ductile RC Frame (pre-1970s era): 70%
- Wood-Frame with Soft Ground Story: 55%
- Modern Code-Compliant Steel/RC: 15%

## Practical Application: Prioritizing a Small Portfolio

A representative, composite scenario: a small city's facilities department owns fourteen buildings built between the 1940s and 1980s — fire stations, a library, several municipal offices — none of which have ever been formally screened for seismic risk, and the department's annual budget covers a full Tier 1 evaluation for only three or four buildings a year.

Rather than picking an evaluation order alphabetically or by visible deterioration, the facilities manager scores all fourteen buildings using a basic vulnerability spreadsheet over a few site visits. Three buildings return a clearly higher relative score than the rest — two are unreinforced masonry structures from the 1940s, one is a 1960s concrete building with an open, glazed ground-floor lobby consistent with a soft-story condition.

Those three go into the current year's formal Tier 1 evaluation budget; the remaining eleven are re-scored on a rolling basis as the department works through its multi-year evaluation schedule. The spreadsheet didn't tell the department anything about actual seismic capacity — it told them where to spend a formal evaluation budget first, which was the only question it was built to answer.

## Common Mistakes Without a Tool Like This

**Treating the output as an engineering determination.** A relative score, however carefully built, is not a substitute for a demand-capacity analysis and has no code standing on its own.

**Assuming a low score means "safe."** A green flag means lower relative priority within this specific portfolio, not an absence of seismic risk.

**Skipping recalibration after building changes.** A building that's had an addition, a change of occupancy, or unpermitted modifications needs to be re-scored — the original inputs no longer describe it.

**Using it to satisfy a mandatory retrofit ordinance.** Jurisdictions with mandatory soft-story or URM retrofit programs require a specific, recognized screening or evaluation methodology — a homemade spreadsheet score doesn't meet that bar, even one built on similar principles.

None of this replaces an engineer's judgment or a formal evaluation — it just makes sure that judgment gets applied to the right buildings first.

**Key Takeaways**

- A basic seismic vulnerability scoring tool answers a triage question — which buildings to evaluate first — not a safety question.
- Building age, irregularity, soft-story conditions, and structural material/system are the core RVS-style factors a simple scoring tool should track.
- A low relative score means lower priority within a specific portfolio, never confirmation that a building is actually safe.
- For code-mandated retrofit programs or any decision with real consequences, a formal methodology like FEMA P-154 or an ASCE 41 Tier 1 evaluation is required — a scoring spreadsheet only decides sequencing.

## References & Standards

1. FEMA P-154, Rapid Visual Screening of Buildings for Potential Seismic Hazards: A Handbook, Federal Emergency Management Agency.
2. ASCE/SEI 41-17, Seismic Evaluation and Retrofit of Existing Buildings — Tier 1 Screening Checklist, American Society of Civil Engineers.


---

**Author:** Retrofit Engineering Editorial Team — Tools & Practice Resources Division


Source: https://retrofit-engineering.com/blog/free-excel-template-basic-seismic-vulnerability-scoring