Armor Progression

[Sifu]

I just wanted to toss this out there in case it is useful for anyone.

Armor Progression (https://docs.google.com/spreadsheet/ccc?key=0AjxUcOrItoV0dHFlNkRqUmV1d1lxMWkzdHJCMW92Z UE&usp=sharing)

I have been using Excel to do this for a while now. I just pull the starting stats of the armor and the gains per level in a simple cell reference so I can see the strength of the armor as I level it up. This gives me a good idea how far I will have to level it before I can wear it. It's not going to touch the Works of the Armors Data, The Epic Boss Calculator, The Armor Leveling Caluclator, etc., but since I do use it each new armor, I thought others might want it.

I shamelessly borrowed the armor data from Lii's Epic Boss Battle Calculator.
http://www.funzio.com/forum/showthread.php?55912-Theorycrafting-solved-the-Epic-Boss-damage!/page5&highlight=epic+boss+battle+calculator

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

That spreadsheet claims it auto updates from the Armors Data spreadsheet. Since copying the Armor Data copied formulas, this one may as well, but I make no claim that it does.

I added an armor-picker so to spruce it up before sharing it. Hope someone finds it useful.

**I think it would be awesome if this was another workbook in the Armors Data spreadsheet. PLEASE FEEL FREE TO COPY THIS INTO THAT AWESOME PIECE OF WORK**

[Lord Of The Infernal]

Thank you ^_^

[Sifu]

Mission accomplished as long as it helps at least one other person =)

[detoxic]

Awesome spreadsheet! It's not letting me pick an armor though. Maybe because it's "view only"?

[Helena G Wells]

Awesome spreadsheet! It's not letting me pick an armor though. Maybe because it's "view only"?

File > Make a copy

You get an editable personal copy.

[detoxic]

File > Make a copy

You get an editable personal copy.

Ah, there we go! Thanks

[Sifu]

I decided to go whole-hog on this. The formatting and arranging isn't exactly pretty. If you have any ideas on the layout or formatting to make this easier to read, just let me know. However, I decided, "Why manually look it up? Isn't that what a good spreadsheet is for?"

I added some lookups to tell you at what level the new armor will surpass your existing armor. It does separate lookups for attack and defense. In order to do this, you have to also put in what armor you are currently using and what level that armor is at. If you have made a copy, you might want to make a new copy to see those changes.

Edit: I did not put in any error checking in case the new armor never surpasses your old armor, so fair warning. I may work on that later.