Angband.oook.cz
Angband.oook.cz
AboutVariantsLadderForumCompetitionComicScreenshotsFunniesLinks

Go Back   Angband Forums > Angband > Development

Reply
 
Thread Tools Display Modes
Old May 18, 2021, 19:00   #1
Julian
Apprentice
 
Join Date: Apr 2021
Posts: 89
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.

https://www.dropbox.com/sh/73omz6uj0...xmDjsYdwa?dl=0

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?

Eventually

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

Nothing besides the chart.
Julian is offline   Reply With Quote
Old May 25, 2021, 01:15   #2
MattB
Veteran
 
Join Date: Mar 2013
Location: Berkshire, UK
Posts: 1,212
MattB is on a distinguished road
I don't really have a need for this, but I absolutely love the fact that someone has done it.
Important work.
MattB is offline   Reply With Quote
Old May 27, 2021, 01:33   #3
Julian
Apprentice
 
Join Date: Apr 2021
Posts: 89
Julian is on a distinguished road
I've now updated the files to also include object activation failure chances

Edit: Needs some updating; I forgot to include intelligence bonuses.

Edit2: Fixed that, a small bug, and added a configurable racial bonus/penalty

Last edited by Julian; May 27, 2021 at 03:33.
Julian is offline   Reply With Quote
Reply


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 14:30.


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