Go Back   Angband Forums > Angband > Development

Thread Tools Display Modes
Prev Previous Post   Next Post Next
Old May 18, 2021, 19:00   #1
Join Date: Apr 2021
Posts: 122
Julian is on a distinguished road
Angband melee calculations spreadsheet

I made this for my own nefarious purposes, and figure I might as well share it in case anyone else finds it useful.

It’s a spreadsheet that lets you configure class, weapon, target AC, etc, and gives you a display of how much damage per round a character does at various str/dex combos. (Also a lot of the intermediate values, like number of blows.)

You can change a number of the game constants (fairly easily) and see how that affects things. With a bit more work, you can change the formulas as well, and see how your changes propagate.

It’s an Apple Numbers spreadsheet. There’s an Excel version, but I can’t guarantee it works.

To answer the most obvious questions:

Why’d you make this?

As stated above: Nefarious Purposes.

I added a class/weapon, but I can’t pick it

You have to hand-populate the menu as well, and make sure the name matches.

The in-game numbers don’t match

It could be an error in the sheet, or an artifact of the Angband code using integer math, which truncates decimals, so the spreadsheet will be close, but not identical. (For instance, monster AC in the to-hit calculation is multiplied by 2/3. At AC 1, that’s 0 in Angband, and .6666 in the spreadsheet.)

I figured it was close enough for anyone mucking around in the guts of the combat mechanics, and trying to force a spreadsheet to do integer math is way more effort than I want to put in. (I am not a spreadsheet person.)

What’s with the last line in the critical table?

I had to fake something unachievable to make the calculations work

What’s with the next-to-last line in the critical table?

Only Grond gets those crits in Angband.

The to-hit calculations are weird

Yes. Yes they are.

Are you going to add ranged weapons?


What’s the monster AC table on the other sheet used for?

Nothing besides the chart.
Julian is offline   Reply With Quote

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Some calculations (AC and accuracy) wobbly Vanilla 11 March 28, 2021 07:15
blow calculations in V wobbly Vanilla 20 August 6, 2018 13:40
speed vs damage calculations? Sky Vanilla 7 November 27, 2016 06:46
Item power calculations: consiter crits? Domiano Development 2 January 21, 2013 23:22
Best melee? Swede2378 Vanilla 22 June 16, 2010 21:03

All times are GMT +1. The time now is 23:29.

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2023, vBulletin Solutions Inc.