About the creator

I built this because nobody handed me one.

“Open a spreadsheet. Good luck.”

My ICS instructor, the day a major flood turned our training class into a real EOC

My first EOC wasn't supposed to be real.

I was sitting in an ICS training course when a major flood hit, and the class became a real activation. When it came time to track the finances, the trainer didn't even know how to start. He told me to open a spreadsheet, and good luck.

So I did. I built a shadow burn-rate system that tracked labor, equipment, materials and other costs, so leadership could see what the response was spending each day. Over time it grew into a much larger workbook.

But every event was different. With each fire, flood and record snow, I had to reinvent how I approached the project and work through all its details again, starting from a blank sheet.

Then came COVID-19. It started in the EOC like any other activation, and after a few weeks the whole operation went virtual. The finance tracking had to work for people who were no longer in the same room.

Emergency Operations Center staff meet outside the EOC building on Switzer Mesa in Flagstaff while smoke from the Museum Fire rises over the mountains behind them
Museum Fire, Flagstaff, July 2019. Staff from the joint County and City EOC hold an afternoon meeting in the yard on Switzer Mesa as the fire burns in the background. I'm at far right, in the back.Photo: Jake Bacon, Arizona Daily Sun

I’ve worked in public administration for over 19 years, and I hold a bachelor’s degree and a master’s degree in Public Administration, both from Northern Arizona University. In the EOC my role was always the same one: Finance Section Chief, through large snowstorms, wildfires that turned into post-wildfire flooding, floods and the pandemic. I completed ICS 300 and ICS 400 along the way.

Field-tested on the Museum Fire (Flagstaff, July 2019), floods, record snow and the virtual COVID-19 EOC, where the methods behind TRACE were worked out.

From one spreadsheet to a system.

  1. 1

    “Good luck”

    A major flood in the middle of ICS training. No process, no template, just a blank spreadsheet.

  2. 2

    A shadow burn rate

    Labor, equipment, materials and other costs, tracked day by day so the EOC knew what it was spending.

  3. 3

    The big workbook

    A larger workbook that tried to hold everything, and still had to be reworked for every new event.

  4. 4

    Fires, floods, mega snow, a pandemic

    Every disaster brought new details, and every time I was rebuilding the system from scratch. COVID-19 moved the EOC online.

  5. 5

    TRACE: Tracking Response Activity and Cost Evidence

    Everything I learned, built once, so no one has to start from a blank spreadsheet again.

You name it, I lived it.

Sandbag volunteersDebris removalSheltersMoving animalsFloodsFiresRecord snowCOVID-19 (virtual EOC)
15

project worksheets on a single event, spanning two different agencies. Each one with its own crews, equipment, costs and paperwork.

What I wish I'd had on day one.

TRACE is the tool I wanted every time I opened that blank spreadsheet. It keeps the know-how with your agency, whether your own staff do the work or a consultant helps. It turns your own team into the expert: PoppaGPT answers PAPPG questions as they work, and everything stays set up and ready for every incident after this one.

A live burn rateLabor, equipment, materials and other costs, totaled as the work happens.
Crew time from the fieldCrew bosses sign time and shift tickets on their phones, even with no signal.
Many projects, many agenciesEvery project worksheet and every agency kept separate, without a new workbook for each one.
Ready for FEMASigned SF-261 and OF-297 forms, a reimbursement packet and a one-click LEMO export.

If you've been handed the spreadsheet, let's talk.

Email: see the contact page. Or connect with me on LinkedIn.