https://docs.google.com/spreadsheets/d/1CHMCdmPTtWsOjqICzcPXvJc0Vw2HMk3kaWYACQCz774/edit?usp=sharing
It's not perfect, but does have some formulas for calculating the damage for the "shooting range" results. I'm sure it can be improved upon if someone is interested. And certainly adding additional weapons to it would be simple.
So, I copied that spreadsheet and made a few changes. Take a look at https://docs.google.com/spreadsheets/d/19uJ-Z8qC0VCpHxQPDxF0fBkzWtSWYiICg7AHD72328Q/edit?usp=sharing and tell me what you think.
Longer-term, I’d love to compare carbines and blaster rifles in the same way.
However, this still doesn’t take into account what happens with the boost dice on certain weapons. We’d need to run some Monte Carlo simulations for that.