The Spreadsheet Isn't Going Anywhere
Let's get this out of the way: spreadsheets work. Every M&E appraiser I know — myself included — has a workbook template they've refined over years. Column widths dialed in, formulas carrying forward, conditional formatting flagging gaps.
There's a reason the industry runs on Excel and Google Sheets. They're flexible enough to handle a one-off piece of lab equipment and a 500-asset manufacturing plant in the same format. They export cleanly into reports. Bankers know how to read them.
Nobody needs to be convinced to abandon spreadsheets. But most of us are spending 60-70% of our engagement time on everything that happens before we start filling in cells. That's the part worth examining.
The Hidden Costs Nobody Tracks
Think about the last multi-site appraisal you did with another appraiser. How many times did you deal with:
- Two versions of the same workbook with conflicting serial numbers
- Photos dumped into a folder with no connection to the asset they belong to
- A comp screenshot saved somewhere on someone's desktop three months ago
- Formatting differences between your template and your colleague's template that required manual cleanup before combining
These aren't spreadsheet problems. They're workflow problems that happen to surface in spreadsheets.
I ran a rough time audit on a 50-asset machinery appraisal last year. The breakdown was sobering.
Where the Hours Actually Go
Site visit and photography: 6-8 hours. This is the core work. Walking the floor, photographing nameplates, talking to operators, noting condition. No shortcut here, and there shouldn't be.
Photo sorting and organization: 3-4 hours. Matching 200+ photos to 50 assets. Renaming files. Pulling EXIF data for timestamps. Rotating images. Cropping nameplates for readability.
Data entry: 4-6 hours. Transcribing serial numbers from photos. Looking up year of manufacture. Cross-referencing model numbers against manufacturer specs. Entering dimensions, capacities, and specifications.
Comp research: 8-12 hours. This is where most appraisers spend the bulk of their desk time. Searching auction results, dealer listings, and industry databases. Screenshotting comps. Recording URLs, sale dates, and conditions. Adjusting for comparable differences.
Report assembly: 3-4 hours. Pulling everything together. Writing narrative sections. Formatting tables. Inserting photos. Generating the final PDF.
Total: 24-34 hours for a 50-asset job.
Look at that breakdown. The site visit — the part that actually requires your expertise, your trained eye, your professional judgment — is less than a third of the total time. The rest is data handling.
The Compliance Gap That's Getting Wider
USPAP evidence requirements aren't getting simpler. Standards Rule 7-2 expects personal property appraisers to maintain workfiles that allow another appraiser to understand and replicate the analysis. In practice, this means:
- Photographs with verifiable dates and locations
- Documented sources for every comparable sale
- Clear chain of custody for digital evidence
- Consistent methodology applied across all assets
A spreadsheet can hold the final data, but it can't prove how you got there. When a banker calls eight months later asking about Asset #37 — that CNC lathe in Building C — can you pull up the original nameplate photo, the three comps you considered, and the condition notes you took on-site?
Most of us can. Eventually. After digging through folders, email attachments, and maybe a phone backup. But "eventually" isn't the same as "systematically."
The gap between what USPAP expects and what most of us can actually produce on demand is real. It's not a crisis yet, but the trend is clear: documentation standards are tightening, and flat files don't inherently create audit trails.
Where Automation Helps (and Where It Doesn't)
There's a useful line to draw between tasks that require appraisal judgment and tasks that are just data handling.
Judgment calls that will always need a human:
- Condition rating — you have to see the machine, hear it run, check for wear
- Value reconciliation — weighing three comps against each other when they tell different stories
- Scope of work decisions — what's included, what's excluded, what's grouped
- Client communication — understanding why the bank needs OLV vs. FMV and advising accordingly
- Extraordinary assumptions and hypothetical conditions
Data handling that's ripe for automation:
- Extracting serial numbers, makes, and models from nameplate photos
- Matching photos to assets based on sequence and metadata
- Pulling structured data from comp listings
- Formatting consistent output across team members
- Maintaining an evidence trail linking every data point to its source
The first list is why you're a credentialed appraiser. The second list is why you're exhausted on Friday afternoons.
The Real Goal
Nobody in this industry needs a lecture about modernizing. M&E appraisers are pragmatic people — we use what works. Spreadsheets work.
But the grunt work between the site visit and the spreadsheet — the sorting, transcribing, searching, and organizing — that's not appraisal work. That's data entry with professional liability attached.
The question isn't whether to replace spreadsheets. It's whether you can get to the spreadsheet faster, with better data, and with an evidence trail that actually holds up when someone asks about it two years later.
The appraiser who can do a 50-asset job in 18 hours instead of 30 — with better documentation — isn't cutting corners. They're just not spending half their time renaming photo files.
Jared Lukes is the founder of Appraisal Dream, building AI tools to help M&E appraisers work faster without cutting corners.