Ok, I finally got around to modifying the spreadsheet to account for what happens to enemy ToHit/Accuracy after +5, so it's now 100% accurate on that account. I also tweaked any values in it that were found to be incorrect.
Features:
-This spreadsheet will automatically calculate final accuracy for a wide range of enemy levels based on what defense and ToHit debuffs you have. You can use this to get a good idea of how a theoretical defense or debuff-based build will fare.
-The sheet will automatically adjust debuff values according to the level adjustment and inherent resistance that higher ranking foes have (AV resistances are assumed to be 85%).
-There is a player character ToHit calculator that will tell you your accuracy against varying levels of foes given your accuracy buffs.
-The sheet also holds the values for power effectiveness and PC ToHit against varying enemy levels and can calculate how the effects of a power are scaled against them.
-It also includes a basic recharge calculator that will calculate the modified recharge of a power given the base recharge and any buffs.
The sheet comes in .xls format. If you don't have Excel or any other spreadsheet program, then try out OpenOffice.org. OpenOffice.org is a free and open-source alternative to MSOffice.
You can download the sheet here.
The sheet was originally composed by Ladioss_Sopp and later picked up and edited by me.
Ok, I finally got around to modifying the spreadsheet to account for what happens to enemy ToHit/Accuracy after +5, so it's now 100% accurate on that account. I also tweaked any values in it that were found to be incorrect.
Features:
-This spreadsheet will automatically calculate final accuracy for a wide range of enemy levels based on what defense and ToHit debuffs you have. You can use this to get a good idea of how a theoretical defense or debuff-based build will fare.
-The sheet will automatically adjust debuff values according to the level adjustment and inherent resistance that higher ranking foes have (AV resistances are assumed to be 85%).
-There is a player character ToHit calculator that will tell you your accuracy against varying levels of foes given your accuracy buffs.
-The sheet also holds the values for power effectiveness and PC ToHit against varying enemy levels and can calculate how the effects of a power are scaled against them.
-It also includes a basic recharge calculator that will calculate the modified recharge of a power given the base recharge and any buffs.
The sheet comes in .xls format. If you don't have Excel or any other spreadsheet program, then try out OpenOffice.org. OpenOffice.org is a free and open-source alternative to MSOffice.
You can download the sheet here.
The sheet was originally composed by Ladioss_Sopp and later picked up and edited by me.