Like this spreadsheet? Support me with a Ko-fi!

https://ko-fi.com/mossymax

This is a sheet to calculate and track the total ammo of different guns, based on their magazine stat and their inventory size stat. Go to each tab for different weapons, and please leave a comment if you find an incorrect cell. Master Database page is empty for now

There's usually a linear relationship between inventory size stat and reserves. this gets shifted depending on the magazine stat, by about a maximum of 5 ammo in either direction. For some weapon types I only have the baseline at 100 mag stat, without the mag-based shifting

Total Ammo = Magazine + Extra Reserves

Now including Primaries! This tab has accurate mag sizes for all primaries

Database tab contains all gun rolls to search through. Individual Weapon Type tabs are the same info, just pared down

*All except swords, which work differently, so are just on their own tab

Mag Boosting Perks

Thanks to all the volunteers who have supplied data, including

Inventory Boosting Perks/Mods

Thanks longshotbob

Enhanced Chain Reaction

Thanks longshotbob

Field Prep / Air Trigger

rapid shotgun

Thanks longshotbob

Enhanced Field Prep / Air Trigger

1x Reserves Mod

Thanks longshotbob

2x Reserves Mod

Traces / (Linear) Fusions

Thanks longshotbob

3x Reserves Mod

Enhanced Battery

Thanks longshotbob

Ionized Battery

Thanks longshotbob

Sword Capacity Boosting Mods

Rocket Sidearm

Thanks longshotbob

1x Reserves Mod

Grenade Launchers

2x Reserves Mod

High Explosive Ordnance

3x Reserves Mod

Remote Detonation

Thanks longshotbob

Aggressive LFR

Thanks longshotbob

Augmented Drum

LeafOnTheWind

Thanks longshotbob

Thanks longshotbob

Aggressive MG

Thanks longshotbob

Sword Capacity Boosting Perks

Impact Stat boost

Thanks longshotbob

Bottomless Grief

Thanks longshotbob

Reservoir Burst

Thanks longshotbob

Tempered Edge

Enhanced Killing Tally

(sorry if I've forgotten anyone, let me know and I'll add you to the list)

Thanks longshotbob

Extra thanks to Halcyon for the original python script that I modified to create this database!

Enhanced Cold Steel

Enhanced Flash Counter

In normal activities - Stowed ammo is total ammo

395 Total Ammo = 48 Mag + 347 Extra Reserves

IN THE ENCLAVE FIRING RANGE - The game adds your mag to your extra reserves. ENCLAVE EXTRA RESERVES WHILE READIED = 395 = NORMAL TOTAL AMMO (48+347 = 395)

Family Reference