It's just one equation, changing the cells that it's pulling numbers from. Each section just required inputting different weapon damages and the rest filled out itself. It took longer waiting for people to get me some of the numbers I was missing than it did to make it.



Yeah, SP is where discrepancies come from now, which is the opposite of where CCP has said they wanted it to be. However, it doesn't matter which gun you use, really, wherever you're at with your SP investment. You've got a 1, maybe 2 (sometimes zero, sometimes 3 for HMG) difference in the number of bullets it takes you to kill your target depending on which tier weapon you use.

Why should people spend a buttload more ISK, CPU, and PG for a target to die in sometimes just a single bullet less, if any difference at all? The bigger differences really only start to appear for going against hp-tanked heavies, and even then, it's just a couple bullets.

You don't understand how to read the spreadsheet, so we'll go through it together.

Look at the top section under the Standard heading (this is with no SP investment in damage increasing skills). You're shooting at some guy who has, let's say 400 hp. You pick up a militia or standard assault rifle (they have the same damage), and you'd kill him in 13 shots. If you had an advanced gun instead, you'd have killed him in... 13 shots. BUT if you had proto, you'd have killed him in a whole 12 shots.

Now, if you had maxed your SP, you'd have killed him in 11 shots with a militia or standard AR, but only 10 shots with advanced or proto.

If you had maxed SP and 2 damage mods, you'd have killed him in 9 shots if you were using militia, standard or advanced AR. Only 8 shots if you had proto.

You're only saving 1 bullet (if any) in those situations. Why would you need to use a higher gun? There's need to upgrade your SP investment and maybe stack damage mods, but there's absolutely no real reason to fit a higher level gun if it's only going to save you a single bullet vs your target. You're sacrificing a lot of ISK, CPU, and PG to kill someone in 1 less bullet.

This has nothing to do with proto vs militia fits. The difference in the tiers of guns isn't "not big" it's almost nonexistent. This is to highlight that it doesn't matter what weapon YOU use, because you kill everyone in almost the same amount of bullets regardless of which tier you have equipped. There is no reason to sacrifice more ISK, CPU and PG to fit the higher level gun because it doesn't kill any faster for you.

No, it's that it doesn't matter what gun you use regardless of where you're at. If you have no SP invested, or max your SP investment, or even stack damage mods on top of that, no matter which gun you use, you'll kill at almost the exact same rate. So there's no point in actually using those higher guns you unlock, just as long as you spend your SP in the skills that increase damage passively, because that makes a difference. Using a higher level gun gives you either no extra killing power or practically negligible extra killing power.

Rocking higher tier weapons still puts you well ahead of your opposition and it's saved me plenty of times.

I fail to see how using vastly more fitting space and ISK to kill someone in 1 less bullet (or the same amount of bullets depending on the upgrade) is putting you "well ahead."