Angband Forums Angband melee calculations spreadsheet
 User Name Remember Me? Password
 Register FAQ Members List Calendar Search Today's Posts Mark Forums Read

 Thread Tools Display Modes
 May 18, 2021, 19:00 #1 Julian Apprentice   Join Date: Apr 2021 Posts: 93 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.
 May 25, 2021, 01:15 #2 MattB Veteran   Join Date: Mar 2013 Location: Berkshire, UK Posts: 1,212 I don't really have a need for this, but I absolutely love the fact that someone has done it. Important work.
 May 27, 2021, 01:33 #3 Julian Apprentice   Join Date: Apr 2021 Posts: 93 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.

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

 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 Rules
 Forum Jump User Control Panel Private Messages Subscriptions Who's Online Search Forums Forums Home Angband     AAR     Vanilla     Development     ToME     Sil     Variants     Competition The real world     Idle chatter     Oook! Obsolete     v4

 Similar Threads Thread Thread Starter Forum Replies Last Post wobbly Vanilla 11 March 28, 2021 07:15 wobbly Vanilla 20 August 6, 2018 13:40 Sky Vanilla 7 November 27, 2016 06:46 Domiano Development 2 January 21, 2013 23:22 Swede2378 Vanilla 22 June 16, 2010 21:03

All times are GMT +1. The time now is 12:30.

 Contact Us - Angband.oook.cz - Archive - Top