[Excel spreadsheet] Every gun and its base stats

Deleted
Deleted Member

Posts: 0

[Excel spreadsheet] Every gun and its base stats Apr 19, 2017 0:33:03 GMT LemurFromTheId, capn233, and 8 more like this

Quote

Post by Deleted on Apr 19, 2017 0:33:03 GMT

~~docs.google.com/spreadsheets/d/1F28K4ZdwkX7TEczAS74BWVjiFvy41U2-hLfmCKAm1Ro/edit?usp=sharing~~

Alright the MP part of the game uses the gunstats.ebx from SP for some reason? So the right values should be:

docs.google.com/spreadsheets/d/1liglzDn_3GGIkzG2KPFpeooVapW97KBA4Lulz44XI3g/edit?usp=sharing

Although it's likely that some values are overriden at launch

Last Edit: Apr 19, 2017 2:13:47 GMT by Deleted

Pearl
N5

optics cuck

Games: Mass Effect Trilogy, KOTOR, Mass Effect Andromeda
Origin: FatherOfPearl
PSN: FatherOfPearl
Prime Posts: 7,305
Prime Likes: 3,002
Posts: 3,898 Likes: 13,409

[Excel spreadsheet] Every gun and its base stats Apr 19, 2017 1:19:31 GMT

Quote

Post by Pearl on Apr 19, 2017 1:19:31 GMT

>browse spreadsheet
>X5 assault rifle

it exists

“The story so far: In the beginning the Universe was created. This has made a lot of people very angry and been widely regarded as a bad move.” ― Douglas Adams, 1980

konfeta
N3

Posts: 314 Likes: 399

[Excel spreadsheet] Every gun and its base stats Apr 19, 2017 1:24:15 GMT

Quote

Post by konfeta on Apr 19, 2017 1:24:15 GMT

Does there exist something similar with enemy HP levels? Would be nice to know the thresholds for one shot situations.

Though would also need to know which boosts are additive and which boosts are multiplicative as well.

cosmiccricket N1 Posts: 36 Likes: 47 cosmiccricket inherit Male 5119 0 Sept 7, 2017 23:52:32 GMT 47 cosmiccricket 36 N1 Mar 19, 2017 21:40:55 GMT March 2017 cosmiccricket	[Excel spreadsheet] Every gun and its base stats Apr 19, 2017 1:24:50 GMT via mobile Miaoven Winter likes this Quote Select Post Deselect Post Link to Post Member Give Gift Back to Top Post by cosmiccricket on Apr 19, 2017 1:24:50 GMT Aww shiet time to get to work

Ghost Of N7_SP3CTR3
N3

Games: Mass Effect Trilogy, Dragon Age: Origins, Dragon Age 2, Mass Effect Andromeda
Origin: N7_SP3CTR3
Prime Posts: 2077
Posts: 393 Likes: 1,659

[Excel spreadsheet] Every gun and its base stats Apr 19, 2017 1:30:40 GMT

Quote

Post by Ghost Of N7_SP3CTR3 on Apr 19, 2017 1:30:40 GMT

Nice work WB.

Origin/Steam ID: N7_SP3CTR3

cosmiccricket
N1

Posts: 36 Likes: 47

[Excel spreadsheet] Every gun and its base stats Apr 19, 2017 1:35:59 GMT

Quote

Post by cosmiccricket on Apr 19, 2017 1:35:59 GMT

I'm seeing a lot of inconsistencies. Most if not all of the damage numbers seem to be off, and some other things like max ammo are off too.

These stats seem to be closer to the SP stats than the MP stats.

Last Edit: Apr 19, 2017 1:37:25 GMT by cosmiccricket

Deleted
Deleted Member

Posts: 0

[Excel spreadsheet] Every gun and its base stats Apr 19, 2017 1:54:32 GMT akots likes this

Quote

Post by Deleted on Apr 19, 2017 1:54:32 GMT

Apr 19, 2017 1:35:59 GMT cosmiccricket said:

I'm seeing a lot of inconsistencies. Most if not all of the damage numbers seem to be off, and some other things like max ammo are off too.

These stats seem to be closer to the SP stats than the MP stats.

As far as I can tell, this file is being overriden at launch when entering MP, so take those values with a grain of salt

edit: MP uses gunstats.ebx from SP, wtf?

edit: yeah MP uses gunstats.ebx from SP but overrides the gun damage value, somewhere, everything else seems to be exactly the same

Last Edit: Apr 19, 2017 2:19:20 GMT by Deleted

cosmiccricket
N1

Posts: 36 Likes: 47

[Excel spreadsheet] Every gun and its base stats Apr 19, 2017 2:22:42 GMT

Quote

Post by cosmiccricket on Apr 19, 2017 2:22:42 GMT

I know that the Mattock has different max ammo in MP, for one. But I think it's safe to say that guns have the same reload time.

Also the damage values are still off in your 2nd sheet. I can tell immediately because the Widow I definitely does not have 495 damage in MP.

Last Edit: Apr 19, 2017 2:26:28 GMT by cosmiccricket

Deleted
Deleted Member

Posts: 0

[Excel spreadsheet] Every gun and its base stats Apr 19, 2017 2:39:55 GMT akots likes this

Quote

Post by Deleted on Apr 19, 2017 2:39:55 GMT

Apr 19, 2017 2:22:42 GMT cosmiccricket said:

I know that the Mattock has different max ammo in MP, for one. But I think it's safe to say that guns have the same reload time.

Also the damage values are still off in your 2nd sheet. I can tell immediately because the Widow I definitely does not have 495 damage in MP.

yes, but everything else except damage is exactly the same afaik (did some testing on my own)

cosmiccricket N1 Posts: 36 Likes: 47 cosmiccricket inherit Male 5119 0 Sept 7, 2017 23:52:32 GMT 47 cosmiccricket 36 N1 Mar 19, 2017 21:40:55 GMT March 2017 cosmiccricket	[Excel spreadsheet] Every gun and its base stats Apr 19, 2017 3:13:41 GMT via mobile Quote Select Post Deselect Post Link to Post Member Give Gift Back to Top Post by cosmiccricket on Apr 19, 2017 3:13:41 GMT Patch 1.05 changed the mattock max ammo to 160-200, the hesh to 60-75, and lowered the Predator's ROF to 450 but the sheet still has the old values.
	Last Edit: Apr 19, 2017 3:21:07 GMT by cosmiccricket

Deleted
Deleted Member

Posts: 0

[Excel spreadsheet] Every gun and its base stats Apr 19, 2017 3:46:18 GMT

Quote

Post by Deleted on Apr 19, 2017 3:46:18 GMT

Apr 19, 2017 3:13:41 GMT cosmiccricket said:

Patch 1.05 changed the mattock max ammo to 160-200, the hesh to 60-75, and lowered the Predator's ROF to 450 but the sheet still has the old values.

cool. then for a lot of weapons, nothing got changed except the damage, and for some guns it's completely different. that was a mistake on my part.

Pearl
N5

optics cuck

Games: Mass Effect Trilogy, KOTOR, Mass Effect Andromeda
Origin: FatherOfPearl
PSN: FatherOfPearl
Prime Posts: 7,305
Prime Likes: 3,002
Posts: 3,898 Likes: 13,409

[Excel spreadsheet] Every gun and its base stats Apr 19, 2017 3:54:54 GMT bacon4breakfast likes this

Quote

Post by Pearl on Apr 19, 2017 3:54:54 GMT

A quick key for some of the unusual names:

X5 = Avenger AAX5, the white assault rifle used in all the marketing and cutscenes that is conspicuously absent from gameplay.
Logitech = L-89 Halberd, named Logitech due to what I assume is some kind of promotional deal. Now it drops from regular packs so ¯\_(ツ)_/¯
Zephyr = Ushior, I think. The stats seem to line up but I'm not 100% on this one.
iShare = Isharay

Last Edit: Apr 19, 2017 3:56:05 GMT by Pearl

“The story so far: In the beginning the Universe was created. This has made a lot of people very angry and been widely regarded as a bad move.” ― Douglas Adams, 1980

LemurFromTheId
N3

Games: Mass Effect Trilogy, Dragon Age: Origins, Dragon Age 2, Dragon Age Inquistion, Baldur's Gate, Neverwinter Nights, Jade Empire, Mass Effect Andromeda
Origin: LemurFromTheId
Posts: 542 Likes: 1,539

[Excel spreadsheet] Every gun and its base stats Apr 19, 2017 4:15:09 GMT

Quote

Post by LemurFromTheId on Apr 19, 2017 4:15:09 GMT

Great job, OP! Even if damage values and such have been or will be updated, this gives us precise reload times and accuracy stats.

Origin/Steam ID: LemurFromTheId — "M-300 Claymore. An elegant weapon, for a more civilized age."

capn233 N4 Games: Mass Effect Trilogy, Dragon Age: Origins, Dragon Age Inquisition, Mass Effect Andromeda Posts: 1,708 Likes: 2,714 capn233 inherit Male 115 0 Nov 16, 2024 3:52:07 GMT 2,714 capn233 1,708 N4 Aug 1, 2016 15:04:33 GMT August 2016 YouTube capn233 Mass Effect Trilogy, Dragon Age: Origins, Dragon Age Inquisition, Mass Effect Andromeda	[Excel spreadsheet] Every gun and its base stats Apr 19, 2017 4:19:31 GMT Kenny Bania and bacon4breakfast like this Quote Select Post Deselect Post Link to Post Member Give Gift Back to Top Post by capn233 on Apr 19, 2017 4:19:31 GMT They were overriding weapon stats day 1 for some reason, mostly to make mp balance worse I think.
	"Are all people from your galaxy loud-mouthed braggarts?" "Nope. Just me, baby. Just me."

LemurFromTheId
N3

Games: Mass Effect Trilogy, Dragon Age: Origins, Dragon Age 2, Dragon Age Inquistion, Baldur's Gate, Neverwinter Nights, Jade Empire, Mass Effect Andromeda
Origin: LemurFromTheId
Posts: 542 Likes: 1,539

[Excel spreadsheet] Every gun and its base stats Apr 19, 2017 4:23:13 GMT Kenny Bania, bacon4breakfast, and 1 more like this

Quote

Post by LemurFromTheId on Apr 19, 2017 4:23:13 GMT

Apr 19, 2017 4:19:31 GMT capn233 said:

They were overriding weapon stats day 1 for some reason, mostly to make mp balance worse I think.

Makes sense.

Origin/Steam ID: LemurFromTheId — "M-300 Claymore. An elegant weapon, for a more civilized age."

Deleted
Deleted Member

Posts: 0

[Excel spreadsheet] Every gun and its base stats Apr 19, 2017 5:52:07 GMT akots likes this

Quote

Post by Deleted on Apr 19, 2017 5:52:07 GMT

Apr 19, 2017 4:15:09 GMT LemurFromTheId said:

Great job, OP! Even if damage values and such have been or will be updated, this gives us precise reload times and accuracy stats.

Yeah except the accuracy stats are incomplete, the spreadsheet only covers the data from gunstats.ebx (The big weapon table), but not individual modifiers that are located in every single weapon file, such as Recoil curve data, etc

Announcements

Recent Threads

Post by Deleted on Apr 19, 2017 0:33:03 GMT

Post by Pearl on Apr 19, 2017 1:19:31 GMT

Post by konfeta on Apr 19, 2017 1:24:15 GMT

Post by cosmiccricket on Apr 19, 2017 1:24:50 GMT

Post by Ghost Of N7_SP3CTR3 on Apr 19, 2017 1:30:40 GMT

Post by cosmiccricket on Apr 19, 2017 1:35:59 GMT

Post by Deleted on Apr 19, 2017 1:54:32 GMT

Post by cosmiccricket on Apr 19, 2017 2:22:42 GMT

Post by Deleted on Apr 19, 2017 2:39:55 GMT

Post by cosmiccricket on Apr 19, 2017 3:13:41 GMT

Post by Deleted on Apr 19, 2017 3:46:18 GMT

Post by Pearl on Apr 19, 2017 3:54:54 GMT

Post by LemurFromTheId on Apr 19, 2017 4:15:09 GMT

Post by capn233 on Apr 19, 2017 4:19:31 GMT

Post by LemurFromTheId on Apr 19, 2017 4:23:13 GMT

Post by Deleted on Apr 19, 2017 5:52:07 GMT