I've seen such spreadsheets, and in theory that works just fine, if......
1. you know how much pump gas is in the tank (no guesswork allowed here). Just because your fuel gauge says 1/2 doesn't mean diddly.
2 what's the mixture of stuff that's already in there. I used to mix mine that way, and after running the tank down to 1/4 or less and refilling with pump gas there's still residual "stuff" left in there. What do you do to get the correct mixture next time, soften the mix? I could still smell the race gas exhaust smell as long as two fillups later! The race gas stays in the tank a LONG time, although being diluted more with each fill.
Too many variables unless you completely empty the tank every time. You realize of course after pumping the tank until it won't pull anymore still leaves just over a gallon of "stuff" left in the bottom. Besides, when I was racing, 100 octane wouldn't do the trick. I pumped the street gas out, and poured in 10 gal. of 114. The gallon that was left in the bottom was of no significance.
I agree that adding a mixture to a tank of "who knows what" would be challenging. But that's not what I'm doing. I started with an empty tank (or a gallon left as you stated) and am mixing directly into the tank. So I would add 5 gallons of pump gas, 7 gallons of race gas (for example) to add a total of 12 gallons of mixed gas. That is very simple and also very reliable. I'm not swapping out race and pump gas at the track, etc. so this will work for people as long as they are diligent about it. And again for low mileage drivers like myself this should be a safe, cost effective solution.