Knights & Dragons Armor-Enhancing Simulator and Calculator

[Barbanium]

THIS WILL NO LONGER BE FIXED NOR UPDATED.
PLEASE DOWNLOAD YOUR OWN COPY WHILE IT IS STILL WORKING PROPERLY.

Hi! I made 2 calculators that simulate the enhancing process of your armor and calculate the total cost of enhancement and total time to craft the enhancing armors.

Please read and follow these advisories so everyone can use the calculators properly.

DON'TS:

• DON'T copy, cut or paste cells
• DON'T change the formatting of cells
• DON'T add rows or columns of cells
• DON'T add spreadsheets
• MOST IMPORTANTLY: DON'T do anything that will ruin the calculators

Level-to-Level Calculator

FULL LINK: https://docs.google.com/spreadsheet/...vMjJYb3c#gid=0

FEATURES:

• Simulates enhancing process from a level to another
• Calculates total cost & crafting time, EP, and many more
• Compatible with Epic Tier armors (Lvl 99 Cap.) and Black Kaleidoscopic Armor
• Compatible with any number of Armorsmiths
• Takes account of number of armors needed for last enhancement
• Detects impossible input combinations/user-input errors
• 100% accurate calculations if assumptions are met

ASSUMPTIONS:

• FOUR armors are used per enhancement EXCEPT for last enhancement
(which could be less than 4)
• Enhancing armors are ALWAYS SAME TYPE as indicated in input
• ALL Armorsmiths have SAME level as indicated in input
• ALL enhancing armors are CRAFTED in Armorsmiths

One-Time Enhancement Calculator

FULL LINK: https://docs.google.com/spreadsheet/...vMjJYb3c#gid=4

FEATURES:

• Simulates enhancing process of ONE enhancement
• Calculates resulting level, enhancement cost, and EP
• Gives freedom to number or type of enhancing armors
• Shows level cap and star ranking of enhancing armors
• Compatible with Epic Tier armors (Lvl 99 Cap.) and Black Kaleidoscopic Armor
• Detects impossible input combinations/user-input errors
• 100% accurate calculations

NOTE: Most of the cells are shaded because they're protected,
so no one but me can edit formulas and data.

Thanks to:

Varza, Lii, Jello and other contributors of these spreadsheets:
https://docs.google.com/spreadsheet/...NZVlvalE#gid=9

deathexe for suggesting a time calculator feature

Nate R and dengel for their calculator and suggestions

Sifu for suggesting a feature that determines the number of armors needed for the last enhancement

and Unresolved for his Gold Efficiency of Enhancement Cost spreadsheet.

[Lord Ash]

Good job Barbie

[deathexe]

Nate R had also done something similar to this awhile back, thought that you might want to check it out too. He included the time it would take to produce the amout of gold required, though I haven't tried it out for myself. It's on the last post of this page:

http://www.funzio.com/forum/showthre...ribute./page11

[Musketeer]

I'm confused by the exp on armor before/after enhancing, can you clarify? The input doesn't seem to affect the outcome.

Armor doesn't earn experience, it gains enhancement points, the max being 5070 for a capped level 70.

[Marco_]

I think it has been broken already. (for ex. cell C5 and a bunch of values in O, P, Q and R) You should really somehow block/protect some cells from being edited...

[Nicco]

I think it has been broken already. (for ex. cell C5 and a bunch of values in O, P, Q and R) You should really somehow block/protect some cells from being edited...

Past spreadsheets have proven, open editing ends poorly.

[Jello]

I'm confused by the exp on armor before/after enhancing, can you clarify? The input doesn't seem to affect the outcome.

Armor doesn't earn experience, it gains enhancement points, the max being 5070 for a capped level 70.

I'm sure he meant EP not Exp.

[Barbanium]

Good job Barbie

Thanks!

Nate R had also done something similar to this awhile back, thought that you might want to check it out too. He included the time it would take to produce the amout of gold required, though I haven't tried it out for myself. It's on the last post of this page:

http://www.funzio.com/forum/showthre...ribute./page11

He didn't seem to publish it yet. That or I can't find his calculator.

I'm confused by the exp on armor before/after enhancing, can you clarify? The input doesn't seem to affect the outcome.

Armor doesn't earn experience, it gains enhancement points, the max being 5070 for a capped level 70.

I'm sure he meant EP not Exp.

Yeah, I meant EP. I got used to the term "exp" from other games. Nevertheless, I changed it now. And it's not a "he", it's a she.

I think it has been broken already. (for ex. cell C5 and a bunch of values in O, P, Q and R) You should really somehow block/protect some cells from being edited...

Fixed! I don't know how else others can edit it now. If it does get edited, please let me know so I can fix it.

Past spreadsheets have proven, open editing ends poorly.

I protected the formulas and data now. Hopefully they can't get edited again.

[Genocide788]

This is beautiful Barb. Could i request you add in a 5th armorsmith? Some of us do have 5 of them, esp during the current event.

[Barbanium]

See, the thing about 3 or 5 armorsmiths is that if you're trying to craft Level 11 Uncommons and Fusion Stone Armors, there's a chance that you'll be left with using only 1 or 2 if you have 3 or 1, 2, 3, or 4 if you have 5 when crafting the last enhancing armors you need. And determining whether you'll use less than 3 or 5 armorsmiths when crafting those last armors are what I find really hard.

But I'll try what I can.

[Jello]

FYI: Minor correction on the cost per armor for a couple of levels. I found the mistake on the original sheet when I was doing my 1-30 level testing today:

Level 09 600 2400
Level 10 700 2800
Level 11 800 3200
Level 12 900 3600

Also, be sure to correct the EP Points Necessary for 1-30. I made corrections to it today on the Data Sheet:

Level 11 should be 5 EP
Level 16 should be 6 EP
Level 24 should be 9 EP
Level 27 & 28 should be 10 EP

Total should be 194 EP.

[Barbanium]

Wow, thanks Jello!

I wasn't expecting you would personally tell me changes from the Armors_Data spreadsheets so I can update my calculator. I really appreciate it.

Anyway, it's all updated now.

[Nate R]

Glad I could help a little bit :P

Maybe we could work together to improve these.

[Nate R]

Here's my version... I think it gives a little more freedom to explore possibilities. And it doesn't matter if you have 3 or 5 armor smiths.

http://www36.zippyshare.com/v/18165933/file.html
Mirror: http://www.4shared.com/file/bnYCsk5S...by_Nate_R.html

Edit: I'm sorry it took me over a week to actually post it.. I work a lot and my girlfriend wanted Nate time all weekend :P

[SoloStar]

Great work. Wish it had 3 armorsmiths though.