# Damage Calculation Formula for Dice

Hopefully I haven’t been duplicating work of an easily-available resource, but I have been working on a formula/algorithm to calculate the average damage for a particular weapon. Though I developed this initially for Neverwinter Nights, theoretically, this should work for any DND-like dice game (e.g. Knights of the Old Republic).

As I have found, this calculation depends on several factors, and doesn’t follow easy linear trajectories. Obviously, the average value of a 2D6 roll is 7, but that calculation does not consider things like criticals, damage reduction, or hit chance.

In summary, the algorithm follows these steps:

1. Calculate the relative probabilities for each roll value. For example, the relative frequency of each result for 2D6:
 Value Probability 2 3 4 5 6 7 8 9 10 11 12 1 2 3 4 5 6 5 4 3 2 1
To calculate this in a generic fashion, you must perform polynomial expansion to the degree of the number of dice to roll.
2. For each possible value of the dice roll, you must then calculate the eventual damage of both a hit and a critical hit, ensuring that you include the damage bonuses in the critical hit calculation, but not the damage reduction, which should come after the critical hit multiplier. Currently, my algorithm does not handle dice rolls in the Massive Critical calculation since we’d probably have to perform another polynomial expansion. It only handles a static Massive Critical value. For overall values where the damage reduction causes the sum to total a value less than zero, treat the value as zero.
1. Also calculate the hit chance for non-critical hits and the hit chance for critical hits, and then multiply those values against the damage values for the hit and critical hit, respectively.
• Under normal rules, a D20 attack roll of 1 always misses, and a roll of 20 always hits and always hits critically.
3. Add the expected damage results (non-critical hit chance * non-critical hit damage + critical hit chance * critical hit damage) for each value of the dice roll, then divide by the total number of outcomes for the dice roll (e.g. 2D6 has 36 possible outcomes).

So, in conclusion, the answer to which weapon produces the most damage is obviously “it depends”.

I have packaged this algorithm into an ODS file, which does contain macros. LibreOffice may not let you run it by default, but hopefully you can examine the code easily enough. I had to dip back in to VB Script, which I thought I had abandoned so many years ago, so forgive me for ignorance of any language features. If you don’t want to download the file from the Project page, I have also encoded the ODS file in Base64 in the following block:

Base64 encoding of the calculation Spreadsheet

OLL1Oz1tidj3ffn/v5yCKNtxIpJQZpKX9pAnrZZJCMQlgFouCsWX/kWPl+9P2E//gyPp/9rNqv/hPj93lHAMrLHlyurtO27dqxIdfDWOEobLOEvzp7a9MiK/r6S9Msq37qAQI2r9mt8KVdXLz2IivZNSPUArnPVotnvMmi44Sb2j2p1CHPABRlp6xpoT/6oUXF0EioTxXnHvzGHOImJYoIK5SKSh3qXFnOaFo9tJVpC4BMrgtsr3ihyjTjPGcFeBcWKuBVUsGOdUPQ+sYacw7T04UVmo28B0Rz2K3hfKkMR2DBLUAVhfXgXltL4KIlE3VMJjrmT8wMhrEFAINS2uyjdA66WVl0Rvv4TL2vYFM76MHqPXiDjHqKUBzNJeEu9Yu45ZHD99DtgrY39b
67AXHQvaA6WmMB77sghGqH5r7O05NwTldGEi9pwVVQPYhWGSaFfuEzAoMSjxKLUXCfXSIjTr1lWYv4+6sYoRODRANoxbrVkzMXqMUa0k+xZYd4wvVdqxoMAj7nV3KLJOiBUdrdy9h0/p2liqSYynhlDtrUV8n3oNeqyAQ4sAGB3AULZq7bFEM/se2NpjfgW2wGgbzSI3NPRtMmcY7REKIgBGcIMxmoK4kc5F2sjbt8DgeWAJDxpayjPnpOwDK39FJK53YEjQQhphjBUGpxdLqWcfVThEcSIdpyXCSCWOCYHHMhW0hHkKQ5Gwb+cYNIKrECXgTYrhimEs0tvwq/ityQrDLeDm5ZqxJyRyLtGNneAtf0MsneL+BHYC+9XAqhIftkDsz65qWZG2ruTJ
skWxFlwNPYILF8DTSjmEHUGcqH+soCP3s2vQERQDN9IcChnudnWduNWRGV2BQbtacziQBJ50RFoGFg3pi9VEgcvELQuve1pzQ/9wTqfDISL44a1MrOzul0G3Nei+ho0NYIVdnQ5XTiOXF2Mro1F6KShqHYkow679WOhjEQwu77TZGWX3hB8DS7t0zD1qAFq0AuOmlcVpeBjei3YxJuWK0zVyymNFIhlTLzseNamPx702dToUMYjuiztW0HR/itHswZp+B9Y1EymGbgGhUMbwLETorFlfpciuwMkd2yjQLTNH8lnr3jOqMz+27h1ju1ZaEbLZHNnNljv12AnsBPargRVKyTcaJ/vnKlCPZJ9Z+mARZ4UiIT5ScuhRJEL1tnRmdkh66ixma5AYBuHl
Tphi6xSnjjvm0djEzlISd5YcF+ax1/hnFDRpT1HcM9x9W7n5HY36ibsfwNirYFqISyFBRTECLcsrBVCFi6vX6KcU9DPARLcz3H2mZb8ln7j7m4JGLVvRrm0EPJL3q1i5ejnosccGA2oiVPIEsFi9PMa1H8tASxDtA5hsPZvAReFKO5htYL72W2IKGLSFaWl271gY/nFZsMLJItg0dz92+TN5qM8t3efuMxfV5LDm5Xh5wPK1/gWOH4GVL4HrtDz+gcAC5ew/qEBvyL40vyU/UhIjpYeyBlTvphKvlLnxSYMld+4eBHysVJAswddgXFr21LLEVkiBDNNLta4O7r4cum+p1E3VKMOwFETsSPlytxUp1f3aAl4Mit5e1ZPpmjbulRAx03VMcvcRmX0P
enD3eiS5GcBgBAiLelxYToEmQPwcsI32PMEuDJof92N9ntr2Ln9wkQEYG5GXb9w95xLnqyYeKxqxXshT2SqKfH282m+45LP9RZWzjB4+UEfEpjRIhCubI+HaUCFWqVjLSElVewMNVmt7Uo/lsjHp63QwXc2l9DoR+rlXZSs3+r68lbqLe92/2vE/pKDLVwE2pKD8xo3/JDuOJWTY8JOrELPxt4XzXAQ/nGRN8G26QfB0K5HB4LgraNrbqw1CNimVYVkWJVTlWiUu8quFuxazHSPczIZQF2F6cd3kREHXHApR77cVtLZDDypf8XvOHCKy4QY1q6+FxsRxBveXxrwwXzLqKTq+axxt6LG04PmcOcrNUdzbbPGHgpb0FjQxwiEkdQb3xEeivcxQZp3g
Ck7wyAPXoRsZT89bHixP9xgYCHPcvd4OkOPpjbt/z5lDOtHOEM89BtzgEWcOvajMorzSOBKv8I4v3Pz18aK41NM5c4QISamJCFMSNudYYJaF4pnhaiQ6HMBiz62U5hN8S62l2OBbsYk0H3qJ1Vcft3V2dXZjnAY/q+mjtbGHYxoyObstzJLvufYUxo139FimLPZ/9HF60P88YIeO6wHftyUx8/T+mJvZmifIupKOPNGbPMsrsNtWsVigIWBip9xTAqy5tQLf4W6x7IthuuEiGWFmGYeEZZeCHbpLnqhdL1vJUUchH0xwp5bai10ysq9CqrEj25pXwy2S8Oc+sC31Y6WdXZRoN+6+znD3eN+X/8zd17FpPlHSGShA4gjYVkEIdu2FognFuQ1s1tEc
ixKG8GMFXQ65e9w/cfdwynPaGTzjxcPXhOBP1IYtQkrGP8V5kDKfrQ+AxRbkMa59O5nUsU703mOCUuPB0pVdFS6RHSkDcNM2Ml459KTaj3Wn6PFUyozPkieeYA13O9TnhjCxT8+xqlOk6AfuvjGL+xc5PuuxGtvXBPY1LY+79iv1iwCLbI20bXerN1f3zHi0WzqT01nh0bgZSXAPre5Kt7ekNXZj5pUA5+Yt7r70UB0TVXrBlJA2XFRmLAg+Retsxf9p42dXNJMT4OIeUwNhZ0ua8kOhFk8/0ukmQDjywmd626+PtKe1eEvQJF21AYxKO50YfWyMQ2giTF8fcPdDOWvGVia4wFAAKd8KtbbSjgewYVbNCn606as/Fw4xsRYv7AE1MJI9rYlrABgT
BiemcXoHxrVQ6rpMzbSqL4+fYiJy1lYEC8cLKQ8tD4O3t7eP27mc1dXqddFgbBdOACFVEIcNug8+we5PrczNkJa2YoXq7BQDb2Q4EmWi3E5cEtyutpqGb5JPD/oLAGtfCJjm/D0tSX0+RX3cmvN6mrvvxo8dsYeTrKkd5lbdUu1585HvHpfmRBCqKqmrhQLJPPM6iC0H2+rpgMUI9gLN6ZBJ8G47wnCE1YN40aCg/V1BY22odZnba6OeKZ0QDs902RbFzYV4otc9nrlrEDsKmqwKWtJbdD4AC26w3NiSLg00R1vylBm80WPsOQUNnvqxoWK2Vd26oaCvu+ve4+6ZX0DBXRKOzPGo6BPAWrw+Hvee+1mTqhqaqXfHQ5Fu67Fxu1iqx0kZR97IHM+v
L/yvy8ulsPbXi3qmx+LLy/89FqV/vcxKIv7ysviXlzBR7l+bF//14kUwUAJa5D+J+8r7VzpOy+MfB6zVW6BAuU/j52vY0nklz1dR1v8OpUw+ugafLd0o/JeKur/0xFpqrUaW62hRrYO+Xz9H4bK9Q5Zt0KKW69lJaxjThh9z945Ktue23CL4pWa3pHMvHTVOi/QUvB1sLwYFpoRiHGsiOSMaJLEhfHuxdotOt8rz6T5PfCZIDCw+tudo3tQ0klKtu5GUo8GgpsRFG1DcNAoBzmbmHcs4svQozBFNT1seVqhpyyPTOrW4nqTYpwZG1EAIafWgCxJtJG/ti7aFdUpixuoOLIHPbgw80Py05fEEdw/zAJqUDxW0zftkTusyNuzr25t2UOzMNSoF9VV2
4ZimMhbVuU5Zd94Y19tWcaEL22jtdOgsp0xnSstxx27v0WwMxl0cCZrSurn/1GMnsBPYrwYmW1vX3H7uzXUPVUug47Wk09SAsCBr2KFPUfl+zo+81rFGXA23haQ+ItwuyXLeuWRV8HnT6uFSoUV9rIvOuj5WjGXWQ30e4n7c2VpHdm9r0Isev2HgnvlI47Up5+MTL3vbyJmDn9vxR6KfeA5W75MU6+L6W9RAxuDFO2oJfI5k/1oQf53n4TZ2/IER8AywqvSxw30QIIe/D4doS14cFktaHNIAjFNzmTXNq738ODebvVjH5Gye4CRxMOo4Z44ldnfJTUrmfMl6WT3oPIz9GntKtaSWhmmfSpkl4FoI4eHJVqZlRwHzbsQGHVoe4SD2L918krXUqcdO
p2FpZkvxOTSrx6IeQWLxcMnah7rP3d/qyPZj/1hDPjHN+hVc1CvXAT2TN2cDWOFPKWiSwoQG3bdOvufuwULE2BKuOtW6E6yceyZvzkZ7EEfsCWBFTnD3Wk1RA2/AHAyaJWCO/CVgfzEMfOr5lwv4q9+wttXsglvWJBl9nDXKkv1XXknFnS/FonVxPTpfRxLN4CKpLpCafJvfkVSd22r/dCXZudBDnim3Dz6kkV5g1PZJ3HMYjJx/lew5p4I+gZ3ATmAnsBPYCewEdgI7gZ3ATmAnsBPYCewEdgI7gZ3ATmAnsBPYCewEdgI7gZ3ATmAnsBPYCewEdgI7gZ3ATmAnsBPYCewEdgI7gZ3ATmAnsBPYCewEdgI7gZ3ATmAnsBPYCewEdgI7gZ3ATmAn
o06nY8va3GAvl0uGLJRSvmeTkIjOUhtZyJ7IRoRjXfuEbNGkeBg9EKbtGszxD7OaMJKCCAxXLEw9RcU2U+tr1NdeXaP+Ajd7A8y015kUnl4qrq+/VFy/2DbCfLBgftv2LVTKl9tPz+uKRbp9CdkpV3ksSLSHqaSL7Smluamigdrs0lynXm/Y6nNBerxUfMwCTlhB3Fsq7uHQyz1Oo3lOAzlkg4RJRmLJ55tIOCJd0MCxVXUunPoLVX+9/XTvDUiEn4WD1cJmEKccx8+eYWISFo703GYkoYznjunpwxdmy8ltG/AoXIwOUTsR7TPfnysK5rg2YAQ2sTkKyPg/U2xdvh46thQq8nRpA1S3hUy+JWG6n+HP+vn51KPD2FcYUM4gjwlhgajCoWzWndJQ
25y21S5nmrsv09yG5ZR0W2NftjU6VrNZzrbzfdl2jqxOSdua+7KtBUdNSdta+7INua7VapQxji1iCKPjGcugpGiWqhKFAxL0B3BoI8dqi9W+3OJhSkya8CDCoVlszdmQ6NvN8Xy7J4URXOMIMxPcJ+bk7OzhYchnBlUYkLpT+0GahPgpsyfTJmJ/uDGbEfVBU8hM/lBi/skiTJMwnNQkmImHGfLDjMGZhIxqi/Wf68Xj5MdjI6t4oP7Tc2QE91LspwNC+NWFGrCIO4ehjGPMlHAxzokvnnX2gtg3Q/xAQriY9HCYgmuUjJhORvqggZkQ8cG1VwRk86TGQeh7mPnp81yrSvmaCaqh3QsD0aRxcdBi3qfaZRtmjqg8HrNJVa6UHp/rY1tbp7MDne4O
dO5i7I0d6Dzfgc7mDnS21tUJjJujUHB3pm/Ql19rcDgkJn9KQDLlDLZkzZjcD+fUgSJRk1x9ocbvATfegCkEbvDmNecQup5d2Fn9hT3b4/ZtuMERQNd4R+NheoiO74g/9ATNynWe4Uc+LczWQQpgSwjmBC7Mzg9LZQsWi7n67/bNtGeW33bXYy+kmNemauDoR/NHrITzASO05dFqG3iuZd/5HtaMKhDPPeDMvKzRXvfyjYPM2+uvb27/+Pzmm3Xt/PPWqZ+9NZyzM9up64+xbumNEuRe9KJb0V1792u8zCb+DLr3yrnP0jGgxbgBNXvt+j7wyX6h/puIvEHQuKNheJievx6m25IHw7a63f+5fT0iTBzc2fkN1zFDxS1LrXg5ALj3nvhg8304F+mO
tt78Wu1j4RDBoyfjQ4iDzR9onlh0uppNs6hz9FezjkJPZwMSdVaSqCNJ1HndJLpPCGYVZJDePC2fpVM0tC6BUL0C4RAMQmIne18PQ7Lxcg4JEQCR8FkZEumdMyB3JCS6pSwWiYf8xKOK8ejwERFCVeARyniENuERWs0jpHiEyvDIsVqOnr+k5JEw6RMFIO3u67PXS6RXf0dDztFf0lDGn+x9TR45q3nkKB45rzs+uveCKKhmcHTYb/L1QIh2FZsdHkXuOijSDY7QnoIjN4ORuwmM3NUwchWM3HIwqmsGR1LySIB0h5OAnHB0wtGWcdSoAo4aGY4am+CosRpHDYWjxglHf2M2wFFUSSK95qdHL+BpdhUSrlGWcY02SblGq3OukUq6RqWyrqt3W/sT
148XUdY9ilM73ZwgicjvHJ7znQspKZdXtwmZ7BDLMU1Xljt1rAlKAxriNF5ZH96/shfW1fqbSxpFOEB+SINtglJu5/yOoHwihNPc15Mra8tSn8Ic534KE5T7PPBphlIj5FfRvlpKjyhlY8UVuCrN0S0fKyyxNVl4M35lBa5KhwzuxwpLrOC0Kh7RscK3ObEjagc0ySDHDStuCU4/rawN55kPwH6/n+5nU8pi4C6XS6BmS4ODEpdtGVGoMACIILlYDtypCww2QRyOtU9iqyal2+QGsdHUQA5bUc0YygVEuCvzcpyiqkwtv3bx6OzaxT00BxvIRueZAtdTZRaOT5VZWJVNIN/0xHcB3ohJ9ePN60NesWTsWhJboypgOBvtpkZX5SmlpalSQBe7Mtdz
nDnQ1xX0fhC+Z5gjVoEHg/AAkqBknCZdpAmcCwTCRjuZ8gbNpNO9mp8DhjLKeGlINL7ZCXa8slQ3PCH9pSpnDTRmYdgJFebMgChbUTT2DqP9s1ovG+Z/CRSo2r8GBVwHSExZAoLeQ7NlcbkdRHSbhrrsNBnoNkMMyylIlJhf01DNGEKPUFnsIRUNtcaKETHVVrrUqYZSO8ltnIoko5lfka5Vfp7PeFco3r8Fcs6Wu4rom8U6lc3Us9Zm54yo2DUjGCA7RAHJ15e645XDE30tjVxZr7Fon8r5yTuYiiQVbclAE0zuVta3MKP5jw2cHrQmNdUSb8coFV6L4sn3OM9riAzzQLSXHWRY5QYYNu0l+gf+tR02q4IZY9JdzlHyKJsYxaFabvIS7WAKYyHY
b10X+tx2voKE3MDg0xgrDfaL2Qj6crIY14c740uIIrglxZHPaC5sVe3EDhAhloFnkMGYwWxjZ6KmEONYnBP1lEALLTSzQ5xzmMoj4+wi4wfaZCG1xZSZPYURUZ/ANN7CWMyiVA0EonVwJqz78M5qqrBFx4ZpM40VxugxkM8bM1MoNBO/XLfVyjMDQbfDikvQBjdVl1N/XKsIdVC/vtTHquJ0VYuHZufasRqgSXGV4FR1uVjIhTjGPBftSS3UodNEo73AS22PdX8W3BPJMgydFdHK7wJ9fGUYDX31YebLKhkIcE+zaS1dSjym7Ry09JpeImolXglhfzx/R1De6A3Ec1IWdXnXZ9dzoS/iqhAJFXcBzxz1UbWp7M7xZ6HAm4vSP4zpe8BUnEchOQzv
EY43YvO9oSR8sF8fPeeja1wQPScj8M6uISbuUb4b3o723V08wPdi/BjvvWHvvSfy3juh9++FNY9KaNCv+5pydJRuZVTJVynRYE22spjJg69tCIzEJwgOUYQxTSGxb4jNmeQmRa05LqbLOamVslDejDvTF6LiJjklog89Wzjyq3/rrQRxpj6tIDonDOIrSnn6Zcju96ugYIxfWNwt4ODxfr3jkG/zU6Xnb5SGR+kuzDomQYNAJeiYPHKci4uOZnDKPLpGW84gOTcpRdWOIWW5PDspP8OzZ4mkYyQhQdC5ZZySkL8hS489BjVJ+aoc+5Uxys7fEZSfY2Idqc+jKHnYwfCnIBCePs159+RuDRx3NeDI025B2jG5UDBxplx4aHkcaOs5Jxe0HXdMfgRt
DzicPSlts0HaZuemLVSftiOg8VyruIRbThPIxU22mTBGxcgW3tAtr/n9JktcqwPUfs4hX1uIDcVOaCjkCLP5zSGYG3H71HzUUoxF4tgrftUdlc9uNkWoPHfqXRShTSCLxRRBkZhw6oNMwxujN5Rz+VbkxdRZ6sduoN+kwpYnMJPTrMPGuj2gFYUR0fP+T9Gr3tp50/nycGtX2X4yGOo3+c70uWuEOrZsR36V7FQQOBFMtRKl5el/IJO+Tr7uz2rQ262KiQTmpYqyhxWDUtPQE9xqHXQ0OW3++lL920RW/M43CGn0+urq6hI0B4uRrEFCI/IyivXNY2VFkOS1lyiSm3L1P6UvxYU0Wz+yXrtmvcpYywSjqkb6oAmgxeN91L4tXhEPMOu1mNVXDMWY
RiX9GdxskUtajkGTcrHG/dyh7zGeJSFd16WdSH04Ebbdbsm4OqNa3bhzG+xIaUXAwpDQEJYyMrNDw/8tNbDLSt77W9CAT6XHOE5pRqbvmT4Fre29AXpWkL5hFSv8YqB7i5Lr+IsD56icT3eoURZjGRWgij2BezOUnLINpgLzzZ5zma1ktk5ZvqaC0u2qIHcchVZyYc0wZYOV5VKIVAjOeC4EK8iMTamgTewvHus2jHuVn/eMfcj4x4x9ucb8g7x2ql/KQlPy9V/4VZ/gEzjo3T6UT+YY4NM4PcnTLM1T9vBkXHs5fNusDqssWQCHc/A/QEWS0Zo+vGuN1ZhdY/7sOCXc3mkT+5ZNNCoZ9VgdLWDlWxf7s0eTqMDam8Zn1R+HsFmniJQFeXVP5N4/
d1xoVVwYZae8i4pQSnn5cidtA82aJp0kpeCv35SKV1l6FyvdcWeuX6B5ec7pyZOT5wSvvq18fLKEjCNKrhX1S1E5gcShLiKLa2Vktk6/Kt+qf13R+Rw5sOJSJ/QhEaccCiGH8BM5nfBK0n2thIxUKOCIVwjwIa8Ip0IDSLbTKq9HVzbGkpYVRuTxWvGECCqFQhRFX6KzL5QtCmq5XC5serdDHUrmaHGoqWT0a1OU0hdD8YTEmY0xrVg8LyTPysmzk69CoynVbRy2r1+9ejaQfJwiAf04NifPzbFr14o0WVkiGL1ETdk37+0cC3FkY6gzCEwaKNtOsQ5kJyJCqRavCj+DvAv4Ds5FPshj5ApvH7R6eXFx/mH4DkQLb6/rXy8uy4fCn/ogOEXEhSvo
lVzzP5A6pjwP2ZNnKZC/aNskash68iHlQqDuhczx/rkHiHxisZ53lXqHyGNy6KTfDp99QuX5W4q9XOWtHgpaB9gJ8znlnzeAJGW4e51rAw5L5zVEAFsrVaZ3/i4Ue9SddL+DVrk3HeNQ/8R/A9UajJ6CBuhY66nmzc1xK7AXe4eOdf1eXw9enm/01mwkPx9t2Tb0y8hot4rTob6qk9oajC+Ks8lNeaB5quP36KSoemB8fmufdYOZ7JtOjMDWzsujdnntdroemAxup1o5AmPrqW824+/clngzU/Wn49XTbBCI6aRLJO7jdByozpkhYpy+qfP7ehTdNfRkzln3cTapFUGjuO7pQeRoK+z6Fpfjbp224c/algbGPfxiYzN+Fky1UfleDwajptGwtdh3
jLUx6njre69U9yTF7kXSbYh6H/vFDk/iMdy2tuPoKpJj96DfMoE+fxU7/4MdGzKrEtBGJivC9pmusNHt41Js8TLazuvltT4tPG3AbqA0R+P2oUY4zbbhUJ4rdtK6a8T1D9VG1HkGJN+RQ2Wdv6I7zGOKFhWiNqs+OFlzLNb20a5k1o7HFxr16E3P8nB3oJc8z5NuuNGRGcDW7xa6vWBaNC3OezAX1dSZYfwOy8SNIj17W58Do8zvcW2wbbGF6MKbY7UNbB9XbnaYrQEww62XyTSiG0y3djjLP6yOS+3s3H3U+RF++BdQSwcIZQcMS60DAACUCAAAUEsDBBQACAgIAPApgkwAAAAAAAAAAAAAAAAVAAAATUVUQS1JTkYvbWFuaWZlc3QueG1stVRL
bsIwEN1zisjbKnbLqooISKXqBUoPMNiTYMmeWPYYwe2b0PKpKiQiwW6+7z17xp4tdt4VW4zJdlSLF/ksCiTdGUttLb5WH+WrWMwnMw9kG0xcHY2i76N0cmuRI1UdJJsqAo+pYl11Acl0Onskrv7WVwemk3chYCrmk+LM11iHZd8f9+fqJjtXBuBNLdQ1kHPYo7FQ8j5gLSAEZzVwX6a2ZORBsLzUKVOICCZtEFmoMVJWm+zXBNYlxUdTBmqvSLEeWlRDfhSL7ogHmf11XgFm3LEa0qNwE+8dprvDemS4P+hvTEbT3DDovuppNMeyo8a2OR4g0lTduFAp03Bcma3Ulwgjh4HM/QO8/zje+n3XKuloA5dOPwj/k4EMRHMiWj+a6B2G17QEp7P7mdiN
jDP172ebfwNQSwcIlRxkVTcBAAAUBQAAUEsBAhQAFAAACAAA8CmCTIVsOYouAAAALgAAAAgAAAAAAAAAAAAAAAAAAAAAAG1pbWV0eXBlUEsBAhQAFAAACAAA8CmCTPa43fjbFQAA2xUAABgAAAAAAAAAAAAAAAAAVAAAAFRodW1ibmFpbHMvdGh1bWJuYWlsLnBuZ1BLAQIUABQACAgIAPApgkzDCYjZswgAAOdiAAALAAAAAAAAAAAAAAAAAGUWAABjb250ZW50LnhtbFBLAQIUABQACAgIAPApgky+f3EiigYAACgmAAAKAAAAAAAAAAAAAAAAAFEfAABzdHlsZXMueG1sUEsBAhQAFAAICAgA8CmCTH3fy5WiAQAAUQMAAAgAAAAAAAAAAAAA
AAAAEyYAAG1ldGEueG1sUEsBAhQAFAAICAgA8CmCTLT3aNIFAQAAgwMAAAwAAAAAAAAAAAAAAAAA6ycAAG1hbmlmZXN0LnJkZlBLAQIUABQAAAgAAPApgkwAAAAAAAAAAAAAAAAaAAAAAAAAAAAAAAAAACopAABDb25maWd1cmF0aW9uczIvdG9vbHBhbmVsL1BLAQIUABQAAAgAAPApgkwAAAAAAAAAAAAAAAAcAAAAAAAAAAAAAAAAAGIpAABDb25maWd1cmF0aW9uczIvYWNjZWxlcmF0b3IvUEsBAhQAFAAACAAA8CmCTAAAAAAAAAAAAAAAABoAAAAAAAAAAAAAAAAAnCkAAENvbmZpZ3VyYXRpb25zMi9zdGF0dXNiYXIvUEsBAhQAFAAA

1 Like

I purposefully didn’t include additional damage of other types (e.g. +1D6 Fire Damage), since those essentially require their own calculation with this algorithm, with different types of damage having potentially different resistance values for each enemy. So, you’d just add the algorithm’s value for normal damage to the algorithm’s value for these other types of damage.

Also, I didn’t include support for multiple attacks to calculate damage per round, but to calculate, just add the results of this algorithm for each attack according to the attack bonus for each attack.

Your link does not work and what on earth am I supposed to do with that block of data?

Just bite the bullet and make a project of it. On the front page of this site Contribute/Project. Fill in the form and upload your spreadsheet in an archive.

TR

`base64 -d data.txt > 'Damage Calculator.ods' # Assuming you copied the data to 'data.txt'`

Or you can try a browser decoder.

But, I did create a project for this tool, and the file linkage seems to work better there than in the old forums.