Calculating Reduction from AC - Excel Sheet (in General)


Newlin [SeeD] July 13 2013 4:44 PM EDT

https://docs.google.com/spreadsheet/ccc?key=0AiFdlOC2ytyYdEtwd3E3YWVTeElVcWdzMmtZbHJxbUE&usp=sharing

You can simply select each armor piece from the drop down, add your desired + AC, and then select if it is named or not.

If I get bored I will add more damage reduction factors such as the Mage Shield, ToE, SoC, etc. and perhaps add a sheet for physical or magical damage.

Let me know if there is any interest and how well it works for you.

Eliteofdelete [Battle Royale] July 13 2013 5:15 PM EDT

If you get bored you should port it to here.

https://docs.google.com/spreadsheet/ccc?key=0AiysQXQAJMUodFVBNkZKQmttQU1uWTFPTUdsc2ptMXc#gid=1

[Unrivaled]Twist Of Fate [SeeD] July 13 2013 5:40 PM EDT

Definitely informative. Especially since i'm using 2 walls :)

Newlin [SeeD] July 13 2013 9:04 PM EDT

If you get bored you should port it to here.

Ported!

Hanging around CB without any BA to burn makes for excellent motivation for such related projects.

The Half-Dragon July 13 2013 11:25 PM EDT

Um. Perhaps you messed up, or did it like this purposely considering it didn't grant complete magical resistance, or simply because you can't make it work properly, but... When I have it listing just a shield, it shows a Mithril shield with 40 bonus AC giving the same magical resistance as a Mage shield with 40 bonus AC. Which, unless they're using Decay, is incorrect. :x

Newlin [SeeD] July 13 2013 11:28 PM EDT

It is currently just based on AC. I have yet to factor in things such as the mage shield or factor out those items that don't give armor with each added +

The Half-Dragon July 14 2013 1:23 AM EDT

Oh, I see. :3

Newlin [SeeD] July 14 2013 3:15 PM EDT

It now factors in the Mage Shield, Elven Hauberk, Shield of Capacity, and I have taken into account those items which do not confer AC with each plus.

Note: the original link no longer exists it is now incorporated in the link Eliteofdelete brought forth.

Newlin [SeeD] July 14 2013 9:55 PM EDT

I now have a Damage Calculations sheet added. This allows you to compare up to four melee and ranged weapons in regards to their damage output with different strengths and multipliers.

I'm sure there are a few bugs but I hope it helps some of you out.
This thread is closed to new posts. However, you are welcome to reference it from a new thread; link this with the html <a href="/bboard/q-and-a-fetch-msg.tcl?msg_id=003LD9">Calculating Reduction from AC - Excel Sheet</a>