 |
|
|
|
Next: Happy Xmas everybody
|
| Author |
Message |
External
Since: Dec 12, 2007
Posts: 9
|
(Msg. 1) Posted: Mon Dec 17, 2007 11:22 pm
Post subject: [V] Average Weapon Damage
Archived from groups: rec>games>roguelike>angband (more info?)
|
|
|
I started making a spreadsheet to help me figure out if a ranger I had
should wield a long bow of power, of extra might, or of extra shots.
After finding the answer, I made another to decide if String's extra two
blows per round would hold up against the newer items I was finding,
and well, you get the idea.
http://bromleyoil.com/filehost/angband-3.0.8-weapons.ods
(It's an Open Office.org Calc spreadsheet, I don't have MS Excel)
Here's the spreadsheet in it's most recent form. It makes extensive use
of cell ranges ("define names") and some standard functions, but no
macros. I implemented the melee and ranged damage equations from L.
Dickens' Angband 3.0.5 spoiler file, but I haven't yet trolled the
source code to verify the accuracy of those formula. I also imported
all the vanilla artifacts from H. Kornelis' 3.0.8 spoiler file.
The spreadsheet considers player race, class, +hit, +dam, str and dex.
It calculates the blows per round for each weapon - even considering the
bonuses to str and dex some items have. It adjusts for accuracy and
calculates the average amount of extra damage from critical hits. You
can enter the AC and racial flags of an enemy you want to consider the
damage against, and the spreadsheet will adjust for any applicable slays.
Highlight rows of weapons and go to Data>Sort to order them by
descending damage or whatever you want.
There's a sheet for player stats, melee weapons, and ranged weapons.
The only known inaccuracy is it doesn't consider the additional +hit and
+damage you might get from the str or dex bonuses on a weapon.
I'd love to get any feedback, just so long as it's not "I could have
told you Deathwreaker did the most damage."  |
|
| Back to top |
|
 | |
External
Since: Apr 14, 2005
Posts: 92
|
(Msg. 2) Posted: Tue Dec 18, 2007 10:46 am
Post subject: Re: [V] Average Weapon Damage [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
That's very cool. Another thing you could do is incorporate the brands and
slays into the damage calculation; so instead of having a single column for
damage, you could have one for damage to demons, one for damage to
non-cold-resistant monsters, etc. You might end up with a lot of columns,
though.
Nick.
--
"You are judging by social rules, and finding crime. I am considering an
elemental struggle, and finding no crime, just grim, primeval danger." - The
Midwich Cuckoos, John Wyndham |
|
| Back to top |
|
| |
External
Since: Nov 15, 2007
Posts: 45
|
(Msg. 3) Posted: Tue Dec 18, 2007 11:17 pm
Post subject: Re: Average Weapon Damage [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
On Dec 18, 10:05 pm, Billy Moore <bi....DeleteThis@tranquility.net> wrote:
> > That's very cool. Another thing you could do is incorporate the brands and
> > slays into the damage calculation; so instead of having a single column for
> > damage, you could have one for damage to demons, one for damage to
> > non-cold-resistant monsters, etc. You might end up with a lot of columns,
> > though.
>
> > Nick.
>
> Yeah I wish it were a little easier to compare damage versus different
> enemy types without twiddling the enemy flags at the top of the melee
> sheet and re-sorting the weapons based on damage. One column for each
> of the primary enemy types (even just demon, dragon, and undead) might
> work, but even then it's pretty uncommon to find an enemy that only fits
> one qualifier. Almost all the demons, dragons, and undead are evil, and
> a lot of them aren't resistant to everything either, so you'd probably
> end up having to look at 3-4 different columns anyway. I guess I could
> add a monster type drop down, like for the player class and race. That
> would make it a little easier to work with, especially if I could macro
> a re-sort when you change the enemy profile. I need to re-import the
> artifact data anyway, my grabber script was reporting resist light on
> anything that had resist lightning when I took the last snapshot.
You don't need a column for each monster type, you need a column for
each multiplier:
x1
x2 = Animal, Evil (generic slays)
x3 = Brands, family-specific slays
x5 = *Slay* (aka KILL) Demon, Dragon, Undead >> Stay informed about: [V] Average Weapon Damage |
|
| Back to top |
|
| |
External
Since: Nov 15, 2007
Posts: 45
|
(Msg. 4) Posted: Tue Dec 18, 2007 11:31 pm
Post subject: Re: Average Weapon Damage [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
On Dec 18, 10:05 pm, Billy Moore <bi....DeleteThis@tranquility.net> wrote:
> > That's very cool. Another thing you could do is incorporate the brands and
> > slays into the damage calculation; so instead of having a single column for
> > damage, you could have one for damage to demons, one for damage to
> > non-cold-resistant monsters, etc. You might end up with a lot of columns,
> > though.
>
> > Nick.
>
> Yeah I wish it were a little easier to compare damage versus different
> enemy types without twiddling the enemy flags at the top of the melee
> sheet and re-sorting the weapons based on damage. One column for each
> of the primary enemy types (even just demon, dragon, and undead) might
> work, but even then it's pretty uncommon to find an enemy that only fits
> one qualifier. Almost all the demons, dragons, and undead are evil, and
> a lot of them aren't resistant to everything either, so you'd probably
> end up having to look at 3-4 different columns anyway. I guess I could
> add a monster type drop down, like for the player class and race.
I didn't see what you were getting at initially. I don't think this
really matters much, since you almost never have more than 3 or 4
weapons to compare, and it is often not only damage that you care
about. (Immunities, resistances, and stat bonuses can matter too.) >> Stay informed about: [V] Average Weapon Damage |
|
| Back to top |
|
| |
External
Since: Dec 12, 2007
Posts: 9
|
(Msg. 5) Posted: Wed Dec 19, 2007 12:05 am
Post subject: Re: [V] Average Weapon Damage [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
> That's very cool. Another thing you could do is incorporate the brands and
> slays into the damage calculation; so instead of having a single column for
> damage, you could have one for damage to demons, one for damage to
> non-cold-resistant monsters, etc. You might end up with a lot of columns,
> though.
>
> Nick.
Yeah I wish it were a little easier to compare damage versus different
enemy types without twiddling the enemy flags at the top of the melee
sheet and re-sorting the weapons based on damage. One column for each
of the primary enemy types (even just demon, dragon, and undead) might
work, but even then it's pretty uncommon to find an enemy that only fits
one qualifier. Almost all the demons, dragons, and undead are evil, and
a lot of them aren't resistant to everything either, so you'd probably
end up having to look at 3-4 different columns anyway. I guess I could
add a monster type drop down, like for the player class and race. That
would make it a little easier to work with, especially if I could macro
a re-sort when you change the enemy profile. I need to re-import the
artifact data anyway, my grabber script was reporting resist light on
anything that had resist lightning when I took the last snapshot.
I never realized quite how complicated the calculations are in this game
until I tried to cram them all into a single cell... it actually
overflows Calc's formula capacity unless you break it up across multiple
cells. >> Stay informed about: [V] Average Weapon Damage |
|
| Back to top |
|
| |
External
Since: Dec 12, 2007
Posts: 13
|
(Msg. 6) Posted: Fri Dec 21, 2007 2:23 pm
Post subject: Re: [V] Average Weapon Damage [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
"Billy Moore" <billy.DeleteThis@tranquility.net> wrote in message
news:eb5bb$476758c1$d08d6b98$6466@TRANQUILITY.NET...
>I started making a spreadsheet to help me figure out if a ranger I had
>should wield a long bow of power, of extra might, or of extra shots. After
>finding the answer, I made another to decide if String's extra two blows
>per round would hold up against the newer items I was finding, and well,
>you get the idea.
>
> http://bromleyoil.com/filehost/angband-3.0.8-weapons.ods
> (It's an Open Office.org Calc spreadsheet, I don't have MS Excel)
>
> Here's the spreadsheet in it's most recent form. It makes extensive use
> of cell ranges ("define names") and some standard functions, but no
> macros. I implemented the melee and ranged damage equations from L.
> Dickens' Angband 3.0.5 spoiler file, but I haven't yet trolled the source
> code to verify the accuracy of those formula. I also imported all the
> vanilla artifacts from H. Kornelis' 3.0.8 spoiler file.
>
> The spreadsheet considers player race, class, +hit, +dam, str and dex. It
> calculates the blows per round for each weapon - even considering the
> bonuses to str and dex some items have. It adjusts for accuracy and
> calculates the average amount of extra damage from critical hits. You can
> enter the AC and racial flags of an enemy you want to consider the damage
> against, and the spreadsheet will adjust for any applicable slays.
>
> Highlight rows of weapons and go to Data>Sort to order them by descending
> damage or whatever you want.
>
> There's a sheet for player stats, melee weapons, and ranged weapons. The
> only known inaccuracy is it doesn't consider the additional +hit and
> +damage you might get from the str or dex bonuses on a weapon.
>
> I'd love to get any feedback, just so long as it's not "I could have told
> you Deathwreaker did the most damage."
Billy
I'm working on the User Manual at rephial.org, and if you're ok with it, I
shall borrow this for providing info for the UM. It may not go in in this
form but it could be very useful.
Cheers
James >> Stay informed about: [V] Average Weapon Damage |
|
| Back to top |
|
| |
External
Since: Dec 12, 2007
Posts: 9
|
(Msg. 7) Posted: Sat Dec 22, 2007 8:32 pm
Post subject: Re: [V] Average Weapon Damage [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
JAMES Doyle wrote:
>
> Billy
>
> I'm working on the User Manual at rephial.org, and if you're ok with it, I
> shall borrow this for providing info for the UM. It may not go in in this
> form but it could be very useful.
>
> Cheers
>
> James
>
>
Please feel free to use the spreadsheet in part or in its entirety, or
to use any information you find therein for any project you wish. Just
let me update it for the accurate 3.0.9 information before you go
assimilating too much information, I was using a slightly-out-of-date
spoiler file to generate the one I linked earlier. I should have it
done sometime in the next day or two, I'll post again soon.
-Billy >> Stay informed about: [V] Average Weapon Damage |
|
| Back to top |
|
| |
External
Since: Dec 12, 2007
Posts: 9
|
(Msg. 8) Posted: Sat Dec 22, 2007 11:36 pm
Post subject: Re: [V] Average Weapon Damage [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
> JAMES Doyle wrote:
>>
>> Billy
>>
>> I'm working on the User Manual at rephial.org, and if you're ok with
>> it, I shall borrow this for providing info for the UM. It may not go
>> in in this form but it could be very useful.
>>
>> Cheers
>>
>> James
>>
>
> Please feel free to use the spreadsheet in part or in its entirety, or
> to use any information you find therein for any project you wish. Just
> let me update it for the accurate 3.0.9 information before you go
> assimilating too much information, I was using a slightly-out-of-date
> spoiler file to generate the one I linked earlier. I should have it
> done sometime in the next day or two, I'll post again soon.
>
> -Billy
I don't think much if anything is different, but
http://www.bromleyoil.com/filehost/angband-3.0.9-weapons.ods was
generated using the lib/edit/artifact.txt file included with the
precompiled Angband 3.0.9 windows binary distribution. It should be
accurate (the old one claimed all lightning brands had rlite).
Let me know if you spot any errors or want something changed.
-Billy >> Stay informed about: [V] Average Weapon Damage |
|
| Back to top |
|
| |
| Related Topics: | Possible to see actualy damage numbers? - Is there an option you can enable to see the actually damage you are doing with a weapon? For instance - You hit the blubbering icky thing for 15 points of damage. Or possibly a quick patch that could achieve this effect? Thanks :)
[Quick] (and others) Non-elemental Damage for Mages - I am currently playing Quickband, but believe my questions is relevant to Vanilla and most variants as well. Despite the difficulties, I thoroughly enjoy playing mage characters. The ability to eat, identify things, teleport away, teleport other things...
weapon too heavy [O] - I decided to give [O] another try, now that it has usable squelch, and played a few games with the current comp character. In my last attempt, I ran across the Desperate Adventurer on dLevel 3, and when he gave me over 1000 gold I broke my usual pattern...
pretty decent weapon [NPP] - Sometimes randarts are powerful. This was from NPP 0.4.0 [patched in ways that do not matter]. I'm posting for someone else. I am not this lucky. m) The Long Sword of Drien (2d9) (+22,+24) (+3) It increases your constitution by 3. It increases your...
[vanilla] best race for a Ranger? - I have beaten the game twice already, with a Gnome Mage and a Dwarf Priest. I am now working on an Dunadan Warrior (around dlevel 55 or so), and I think after this I will try a Ranger. But I don't know which Race to choose for my Ranger, what are the.. |
|
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
|
|
|
FAQ
Profile
Private Messages
Log in
