This is great!
I need to protect some cells in my calculator
(via Google Sheets.). I'll share it soon. (Changing the wrong cells breaks the calculator ... need to error-proof them.)
You might be able to move my weapon lookup table into your sheet to provide the user a drop-down box pre-populated with the weapons ... and auto-populate many of the values: range, recoil, hit numbers, damage, etc. If you need help with vlookup or index(match), message me.
The formula in Y8 determines range from the target:
=ROUNDUP(FORECAST(E6,OFFSET(dis,MATCH(E6,rng)-1,,2,1),OFFSET(rng,MATCH(E6,rng)-1,,2,1)),0)
I was using it to learn the rules and accelerate burst or single-shot calculations. Feedback is welcomed. There are probably more elegant approaches to this. My excel skills are slightly better than average.
I added the weapons table to your sheet and added a few lookups to the first weapon slot.
https://docs.google.com/spreadsheets...it?usp=sharing