Replace spreadsheet site scoring without losing the scorecard

Most expansion teams build their first scorecard in Excel or Google Sheets, and for good reason. A weighted scorecard is honest. Everyone can see the criteria, the weights, and how a site earned its number, and you can defend every cell in a committee.

The model is rarely the problem. What breaks is everything around it. Once you need real travel-time access, current demographics, competitor locations, and a record of where each figure came from, the scorecard drifts away from reality, and it gets slower with every candidate you add.

A spreadsheet cannot turn an address into a drive-time or walk-time trade area, so you fall back on a radius or a ZIP code that ignores roads, rivers, and rush hour. The population and competitor figures get pasted in once and quietly go stale, with no refresh and no flag when a number is three years old. Each site is scored on its own, so a strong candidate that mostly pulls sales from the store two miles away looks fine until it shows up in comps. And when a reviewer asks where the 45,000 came from, the honest answer is usually a copy and paste from months ago, with no source and no date attached.

The part that works is the part a committee can read, and you should not give it up. The right replacement keeps a visible, adjustable weighted scorecard. You set the criteria, you set the weights, and you can see how much each factor contributed to the final score. The number traces back to named components rather than a model you have to take on faith.

On top of that scorecard, a dedicated tool builds drive-time and walk-time trade areas from the real road network, with time-of-day effects. It pulls demographics and demand inside each trade area automatically and keeps the data vintage attached. It maps competition and estimates cannibalization against your own units, so you can separate net-new demand from demand you would only move around. And it timestamps every figure and exports a brief you can hand to a real estate committee.

Migrating does not mean starting over. Lift your existing criteria and weights into the new scorecard as they are, then let live data fill the inputs you used to paste by hand. Run a handful of sites you already know well, compare the output to your spreadsheet, and adjust the weights until the model agrees with your judgment on the obvious cases. After that, every new candidate is scored the same way, in minutes, with the work shown.

Mapping software is the common next step, and it solves only half the problem. It will plot your sites and draw a heat map, but most mapping tools do not score sites or model cannibalization. Moving from a spreadsheet to a map can trade a transparency gap for an analysis gap. Look for a tool that keeps the scorecard and adds the geography, rather than one that hands you pins and leaves the decision to you.