Hey, I remembered I used to know some simple excel formulas like gather and add bunch of ratings on school subjects and make a column for the average, so then another to say like "if above > this or below < this" it would be approved or not and display by color or throw to charts (not necessary), in this case sounds like it could be applied similarly to display if its a hit or a miss.
But anyway, don't take the work for it because Im saying... Thats indeed too nerd. Im sure you do that to exercise and improve your own knowledge and code skills. Nice work!