Hey Cheeky, I don't know the inner workings of your spreadsheet so don't take this the wrong way.. But how hard would it be to add a page that would have a button for running the calculations of multiple different shot rotations for side-by-side comparison with the currently selected gear? Even if all it did was the built-in ones. The hardest thing for me at the moment is switching weapons and clicking through all the pages to set up shot rotations; I always seem to forget.
On a side note: Now that you set the target's level to 70 you might not get 5 questions a week asking why it's off from the character sheet, but you can bet you'll get 10 asking why the spreadsheet says they are hit capped when they "aren't," Since people are so used to seeing hit cap at 142. I almost posted a bug, but before I did I checked your first release notes and saw the note.
