Spreadsheet is the way to go.
Having said that, you don't need four offers so if there is slack it is worth sticking in one or two aspirational options. It is a long course and so better to be somewhere that sounds appealing, perhaps far enough but not to far from home, and so on.
DD had a poor UCAT and was too ill to take BMAT, but luckily had strong grades. She decided from the outset that it would probably take two years and that first time round she would focus on places she wanted to go to, albeit ones that were likely to interview her, and then hope that achieved grades, more experience, and better aptitude test results the following year would mean she had a stronger chance. In the end she got two offers, one from her top choice, but had made so many plans for her gap year that she took one anyway.
One factor that was important to her was the ability to intercalate externally. I know others will argue that since intercalations no longer carry F1/F2 points they are not worth doing, but DD, who has just finished hers, is very pleased she had the opportunity to study something that interested her in a world leading research department. Not only does she now have scope, once she finishes her medical degree, to continue onto an academic PhD, but the additional science she has picked up should help when she starts applying for jobs within a traditionally competitive specialisation. Most importantly the science was apparently "really cool".