#Weapon Charts
echo lynx
@digital coral will have to join. @formal stone as well 🙂
Oh, I guess tagging them pulls them in.
Anyway, enjoy 😛
safe sapphire
Cool, thanks 🙂
@digital coral If you're trying to sort the data like that, you could probably utilize the "2handedwclass" column since it essentially refers to different animations.
formal stone
digital coral
<@!151366817082900480> If you're trying to sort the data like that, you could pr...
fthe issue was every data became invalid for some reason if I used the sort function
safe sapphire
Hrmm, I'd guess you copied an earlier version that didn't use $ when referring to some cells. Sorting seems to work fine, as far as I can tell.
digital coral
Hrmm, I'd guess you copied an earlier version that didn't use $ when referring t...
nope it still does this, i use sort A-Z and it breaks the entire thing
and idk what 2handedwclass is exactly
digital coral
moving the other post here:
https://docs.google.com/spreadsheets/d/1hnw2eGXj1daq6S8R5Lwx-YUnnY84fHxKgcKor99tdiY/edit?usp=sharing i made a copy and sorted them by speed and sword->axe->mace->scepter, daggers/katars under, 2h below, ranged last
another interesting note, the sheet is suggesting crossbow dps is above in raw dps, meaning crafted colossus crossbow at 75ias beats grand matron bow at 99ias when using faith (12 fana)
digital coral
Faith 12fana roll. wouldn't this make demon crossbow obsolete in most cases? aside from wrath
Act 1 Merc:
AST IAS APS B.DPS BOW AVG.DMG STR / DEX
Demon Crossbow 49.5 141 / 98
8 0 2.5 123(.75)
Pellet Bow 63 83 / 155
10 0 2.08 131(.04)
9 10 2.27 143(.01)
8 34 2.5 157(.50)
Gorgon Crossbow 72.5 117 / 105
11 0 1.92 139(.20)
10 7 2.08 150(.80)
9 23 2.27 164(.56)
8 52 2.5 181(.25)
Colossus Crossbow 78.5 163 / 77
12 0 1.78 139(.73)
11 5 1.92 150(.72)
10 19 2.08 163(.28)
9 39 2.27 178(.20)
8 75 2.5 196(.25)
For Zon:
I'd note slower weapon higher dps isn't bad but with the -10% it's easily 15% dps gain if not more over bows. Yet I do not hear ppl crafting crossbows
Reaching cap frame on crossbows isn't too difficult putting Demon Crossbow in an awkward spot. The stat requirements for Colossus makes Gorgon win because +46 dex, and frame cap makes Pellet niche but stronger than the bow options still and saves you IAS on items.
safe sapphire
and idk what 2handedwclass is exactly
It's the weapon class for determining a character's base frames per attack. Changed it to just "wclass". The text files have a column for both 1-handed and 2-handed versions to differentiate how 2-handed swords get handled when wielded by 1 or 2 hands. I opted for a single column and just separated alternate modes of use.
1hs is for 1-handed swinging weapons, 1ht is for 1-handed thrusting weapons... that kind of thing. Each character class has a number assigned for each weapon class, and that's basically what ends up creating weapon speed breakpoints. For example, barbarian has 16 base frames for 1hs, whereas necromancer has 19 base frames for 1hs.
Crossbows are absolutely busted for mercs, as far as I know. And really good for characters too. Demon crossbow has great DPS at low IAS but gets beaten by the others pretty quickly, yeah.
If people are going for what was best in vanilla/s1 rather than what's currently best in PD2, I imagine it's just an issue of ignorance. Maybe this kind of side-by-side dps comparison chart can help remedy that.
digital coral
It's the weapon class for determining a character's base frames per attack. Chan...
where do I find this?
like, small screencap would help
Also, demon crossbow only beats out the competition at 10ias because it caps so quickly. The rest starts overtaking it at 30ias, and fanaticism by default gets past that
Though, it has 2 uses? Upgraded Demon Machine is actually really good with strafe and wrath runeword for more amp procs.
safe sapphire
Not sure if there's a single text file with all that. But I found it here: http://www.mannm.org/d2library/faqtoids/animspeed.html
digital coral
https://d2.lc/IAS/ I use this
it has the mercs too, though ofc you'd have to reference the crossbows as bows on A1 but animation is the same
safe sapphire
Added werewolf/werebear and the mercs to the original google sheet if you're interested
formal stone
https://d2.lc/IAS/ I use this
this might help u abit https://mmmpld.github.io/pod-attack-calc/
it doesn't reset
digital coral
what changes have happened in pod though?
safe sapphire
Is there anything that calc does that the sheet doesn't that would be helpful to add? Breakpoints, maybe?
formal stone
non for bases as far as i know
digital coral
yes breakpoints
after choosing wep etc, and auras ias table is quite helpful
so you can compare zeal vs vengeance/sacrifice
safe sapphire
Hrmm, can't really think of a good way to add that. Or maybe it just seems a little daunting to do in a spreadsheet. Started to notice performance issues after adding all the wereforms and mercs... not sure it can handle much more. Maybe it could be optimized somehow
digital coral
yeah checked the pod calc out, it's as good, have all the relevant info like weapon speed in [-10], breakpoints and skills as well as slow/decryp, ty Kass
digital coral
Hrmm, can't really think of a good way to add that. Or maybe it just seems a lit...
Idk much about sheets, one way would be to seperate mercs below so they're on a different sheet
formal stone
np i just asked in the POD discord if they ever changed any ias from base weapons
digital coral
so whenver you do stuff that one is by itself
formal stone
when i get an answer i'll let u know
digital coral
np i just asked in the POD discord if they ever changed any ias from base weapon...
if they do, it will show on the [ias] so I will be able to tell! it's why I particularly mentioned this 1
formal stone
but remember if something like Amazon spear bases was changed in PD2
tho i think it was the only once
digital coral
ah i see the correction, yes I'm aware of the spears
formal stone
it was the only once right ?
digital coral
the matri pike
and yes
only 2 bases
you can use a different spear to "simulate" the correct ias though
formal stone
ah ok so did remember right 😄
safe sapphire
Just made the chart editable btw
digital coral
in what way, example?
safe sapphire
I believe it was view only before
digital coral
oooh I see, yeah updated and i can edit
safe sapphire
Feel free to show/hide columns and sort to help analyze whatever
Still not sure why sorting wasn't working for you on the copied version
formal stone
Btw BW fun fact i have thought about adding ias bps onto bases 
but im such a potato at doing all the math and shit that is needed also its alot of work and i dont even think it could be in the description for every skill and maybe something like fanat lvl 14 for faith and so on etc
digital coral
honestly I'd ask of the pd2 team can add it to advanced sheet
and take into account fana/burst
safe sapphire
Oh, maybe it's just an issue with the weapon speed. Gunna see what's causing it
formal stone
well they would have to add every base and every skill to auto show when equipped
digital coral
the actual speed is consistent among weapons, see here: (let me find it)
formal stone
i dont think its that easy
digital coral
and yes maybe not, but adding the bps isthe same for each weapon speed, daggers are the only that differ from the other 1h
so it wouldn't be that tedious
safe sapphire
I think I see the problem. The second row isn't staying at the top
digital coral
funny how the only thing i tried to sort is the one that breaks it
also, can we name all the empty to 0? so it doesnt land at the bottom
ooooh I see what you meant with 2nd row now
safe sapphire
oh that may not be it... looks like it sorts fine if you sort the whole column, but not if you try sorting from the green filter button
digital coral
there's another problem, the ias for weapons got messed up when you sorted
i noticed when i tried adding 0's that some of these weapons are now unlisted that should've been -10 20 etc
oh nvm, im checking non elt bases
oh, it looks fixed
safe sapphire
Okay, so it seems to be due to the "light blue" numbers which reference that top column. They use $ so they'll always look at that cell even if the filter changes what's in that cell
You could just sort the whole column by right-clicking the column header letter instead of clicking the filter dropdown menu. But I think it may work both ways if I just remove those $s
digital coral
oh I see, the filter button actually moves them and the top "k" just rearranges them
safe sapphire
lol nope that didn't work... maybe there's a way to tell it that the top two rows are meant to be separate instead of just the top row
safe sapphire
I added green/red backgrounds for the bases that are different than the other two in the same line. Green for faster, red for slower.
digital coral
and how is it faster
safe sapphire
it's faster than the normal/exceptional versions (war staff and rune staff)
weapon speed modifier of 10 instead of 20
digital coral
added 0 to all that were non assuming they were 0 speed, but seems some were just unmarked, gonna go through all 0s
safe sapphire
Yeah, blank means 0
digital coral
noticed 1 was off, but the rest looks fine
safe sapphire
what was off?
digital coral
archon staff was unnamed, so i put 0 on it, edited to 10
safe sapphire
huh, weird. the text is also white instead of gray for the wsm - did you do that too?
digital coral
wsm?
safe sapphire
weapon speed modifier
digital coral
row?
safe sapphire
the wsm for archon staff, with the green background
digital coral
ah that
no, I didnt edit color on the text
i changed it tho, same gray now
whats the sort you normally do
oh found it
safe sapphire
hrmmm... I'm noticing something weird. there are some items that are showing a dps difference from vanilla, that wasn't like that previously
should only be the amazon spears that are different
safe sapphire
Expanded some columns and am looking at elder staff right now
digital coral
ah
it was unnamed
therefore it probably defaulted to 0?
instead of 10
10 is the correct one though
safe sapphire
Yeah, but it wasn't like that previously. Gunna reset to a previous save. Something weird happened and I don't wanna deal with it.
er, wait a sec
digital coral
after the reload i'll check elder staff
safe sapphire
looks like it's the same in the previous version. I feel like I'm going crazy
checking the source file now
digital coral
I edited my old copy to 10
this is the result
which just happens to be exactly what the current result shows
same ed/str/dex etc
safe sapphire
I copied all the data from the game's text files. It looks like elder staff is just 0 speed instead of 10
Not sure when that happened
safe sapphire
oh, okay. so the error happened when copying the column and editing it to have vanilla info instead
safe sapphire
That's just weird that I didn't see any vanilla difference previously. I remember seeing just the amazon spears with a difference in that column.
digital coral
well the vanilla ias calc says its 0
and same calc says the other are 10
i made elder staff a green 0
safe sapphire
Oh, so the pd2 wiki is just wrong? Whoops.
digital coral
yeah, this staff has not changed in pd2 so it's an error in wiki
told them as much just now, I dont have an acc for it
safe sapphire
hrmm, looks like small crescent and glorious axe both had their speed changed to 0
digital coral
they should both be 10
oh I know why
i was adding 0s and you sorted at the same time
so there's likely 1-2 that isn't what they should be
edited small crescent
safe sapphire
That'd do it. Glad everything is looking normal again
digital coral
I manually checked every single 0 and compared, there was nothing else that didn't match the pod calc
minus the norm spear changed in PD2
safe sapphire
Good to hear
digital coral
is it possible to have these
above here
assuming you can cut them off from being sorted
purely visual, so no big deal if its annoying
safe sapphire
Yeah that's kind of what I originally wanted to do, just to save space. Let's find out how it looks.
digital coral
and it works no issues, nice
safe sapphire
I feel like it might fit better above everything else
that way, you could exclude it from the filter group as well
safe sapphire
That works I suppose. None of the solutions really appeal to me so far though
Now that those cells are outside of the filter group, it doesn't matter which way you sort things. That's a good functional difference
Downside is you kinda need to always show the columns beneath them - I'd probably want to be able to hide druid, necro, and sorc dps since they aren't really relevant in most cases.
I think I could fix that by adding more columns and having them be thinner
digital coral
yeah I see what you're saying now
safe sapphire
would just need a big block of columns that I'd never want to hide
digital coral
I think it's just how the spreadsheet works? or can you make 2 master columns
easy fix maybe move stats far left
you'd have to make those slighly larger or my idea, merge top cells
and move less desirable classes to the right
safe sapphire
Would just need to make all the "always-visible" columns adjacent to eachother
what do you mean by merge the top cells?
put it in 1 row instead of 2?
digital coral
no but that works as well, meant like this 1 sec
safe sapphire
I see
