Embedded Files
TFB TV (YouTube Channel) has a couple of terrific videos comparing 9mm and 380 pistols with regards to capacity vs size and weight. This is my modified version of their spreadsheet where I weighted capacity on a diminishing returns basis (see explanation video below). If you mouse over the upper right corner of the spreadsheets, you can open in Google Sheets.
MagGuts
MagGuts
MagGuts +2 magazine upgrade for the Sig P365XL boosts capacity to 14 rounds.
MagGuts +2 for P365XL
MagGuts MC1Sc
Rounds per Size & Weight Spreadsheet
Sig P365XL Review
Glock 9mm Dummy Rounds
Sentry Solutions Tuf-Glide
Sentry Solutions Tuf-Cloth
MagGuts +2 for P365XL
MagGuts MC1Sc
Rounds per Size & Weight Spreadsheet
Sig P365XL Review
Glock 9mm Dummy Rounds
Sentry Solutions Tuf-Glide
Sentry Solutions Tuf-Cloth
Handguns - Rounds per size and weight
Handguns - Rounds per size and weight
NEW (Beta) Volume analysis tab
Thanks to Blue Guns for supplying water displacement samples for this testing. NEW (Beta) Volume analysis tab
This tab replaces the height x width portion of the original spreadsheet with a total volume measurement (in cubic centimeters). The hypothesis is that there may be some gun manufacturers who put engineering effort into reducing overall volume, are not getting enough credit when looking at just height and width( for example the oval slide on the Walther PPQ vs blocky Glock).
28.03A walkthru of my modified version of the TFB TV rounds per size and weight spreadsheet.
Why "weighted rounds"? Look up "Marginal Utility".
Kinetic Energy per size & weight.
Why "weighted rounds"? Look up "Marginal Utility".
Kinetic Energy per size & weight.
Handguns - Round Count Opportunity Cost
Handguns - Round Count Opportunity Cost
6:57A walkthru of my Round Count Opportunity Cost spreadsheet
The average gunfight involves less than 4 rounds fired. Many threats are repelled by simply brandishing a firearm. So in my weighting I favor the first 3 rounds of capacity and then give diminishing value for each additional round thereafter as follows:
1 - 1
2 - 2
3 - 3
4 - 3.98
5 - 4.94
6 - 5.88
7 - 6.8
8 - 7.7
9 - 8.58
10 - 9.43
11 - 10.23
12 - 10.98
13 - 11.68
14 - 12.33
15 - 12.93
16 - 13.48
17 - 13.98
To put the size and weight values on approximately equal footing, I multiplied the Weighted Rounds/oz by three when calculating the Weighted Composite.
Report abuse