PDA

View Full Version : Data Sheet Administration



Varza
06-01-2013, 05:39 AM
Hello everyone!

With some help, I have restored the data sheet information, so that it should be correct now. Since we couldn't replace the original version (the original owner did not come forth), it will have a new link now. Here it is:

Data Sheet (https://docs.google.com/spreadsheet/ccc?key=0AiQKRFnZ9_jpdEFtUUVnd2dQM1ZIX2IxT1RNZVlva lE#gid=0)

Full link: https://docs.google.com/spreadsheet/ccc?key=0AiQKRFnZ9_jpdEFtUUVnd2dQM1ZIX2IxT1RNZVlva lE#gid=0

This data sheet is read-only to prevent editing disasters. There is a submission form for new armors here:

Submission Form (https://docs.google.com/forms/d/1QJ-nufeakqTU1Dj617AbZCr7eIQI4X1AIIxJN36iryg/viewform)

Full link: https://docs.google.com/forms/d/1QJ-nufeakqTU1Dj617AbZCr7eIQI4X1AIIxJN36iryg/viewform

So if you have/know of an armor that's not on the sheet yet (the new Sasquatch stuff is a good example), submit it via the form and I will include it in the main page. You can see form responses on the read-only sheet for newly added stuff that I haven't gotten around to formatting and including.

Currently, I am the owner and only editor for this sheet. If anyone would like to be an editor, send me a PM with your email address and I will add you. I trust the users of this forum to not break it again, but I will be periodically saving a version to my local drive for backup purposes.

If anything is broken or wrong or you would like a nicer interface, please leave feedback here in this thread or send it to me by PM. I will do my best to fix it.

Iamofownage
06-01-2013, 05:58 AM
RESPECT this has been long awaited for gj!

L C
06-01-2013, 06:37 AM
Sticky this please

indonesian
06-01-2013, 06:50 AM
theres so much an empty boxes, i.e in the combine sheet.

i guess we need to make it filled by the new formulas from the fusing thread, maybe?

Varza
06-01-2013, 06:58 AM
theres so much an empty boxes, i.e in the combine sheet.

i guess we need to make it filled by the new formulas from the fusing thread, maybe?

To be completely honest, I don't fully understand that tab, it was in the original sheet version too. My understanding is that you have a % chance of getting (almost) any armor with a combination of elements from the armors you fused. But yes, we can continue to collect info in that sheet (want to be an editor? PM me -- I don't think I can add everything by myself).

And I now have an idea! If it is in fact possible to get any armor of certain elements from an armor fuse, I could put together a script that would tell you what your possible results are from what you're planning to fuse. It might end up being a separate web page. Then again, I'm not sure ALL armors are fusable at this point (boss armors and such?).

deathexe
06-01-2013, 07:06 AM
Don't think it'll be very effective having a fusion list. Since fusion is just a matter of getting the right element combinations, and the higher the rarity the better your chances at better armors. It could be worth a shot though, no harm trying.

jamiedmc
06-01-2013, 08:47 AM
awesome! ONly problem is that when I print it out... the font is sooo tiny as to be unreadable. I think it has something to do with that box on the right comparing armors. Does anybody know how to fool with the print setting so I can get a readable copy that is not 15 printed pages?

Varza
06-01-2013, 09:23 AM
My only idea is to download it as an Excel file (.xlsx) and then print it from there. Excel allows more settings and customization than Google docs does. That's just what I'd do, maybe someone has a better idea for printing it directly from the online version.

PS. When I try, it wants to print in landscape format and takes only 2 pages.

Sunsfan1caw
06-01-2013, 02:48 PM
Nice work Varza! Original owner was discopalace123, you should credit him in there somewhere to be fair.

Leosimas
06-01-2013, 04:16 PM
The read only is a must.
Thanks for your time and effort Varza and Discoplace

Also just for correction Flowstone+ increases 10/12 the total arara are wrong.

Justice711
06-01-2013, 04:20 PM
Great work, 2 thumbs up! Thanks!!

busteroaf
06-01-2013, 05:43 PM
Yes indeed, having a stable spreadsheet is much appreciated. I, for one, (not that it matters but I'm gonna say anyway) hate when everyone has access to stuff. It just begs for someone to screw it up, either on purpose, or just from sheer lack of paying attention. The less chiefs with their hands on it, the better for the rest of the indians.

Either way, thanks again for taking up this task.

Rediye
06-01-2013, 10:01 PM
The + version of tortoiseshell incorrect in the spreadsheet. Anyone know what it actually is? I've given up trying for Aegis and deciding between tortoise and wurm

Marcial1234
06-02-2013, 01:55 AM
tortoiseshell + :

Base: Attk: 276 Def: 448
Max: Attk: 828 Def: 1,276

Rediye
06-02-2013, 04:03 AM
tortoiseshell + :

Base: Attk: 276 Def: 448
Max: Attk: 828 Def: 1,276

Thanks Marcial!

Sir.
06-03-2013, 01:00 PM
Sweet job! This was much needed and should be very helpful to a lot of people. If you still need editors to help you I'm up for that, can send me a pm.



To be completely honest, I don't fully understand that tab, it was in the original sheet version too. My understanding is that you have a % chance of getting (almost) any armor with a combination of elements from the armors you fused. But yes, we can continue to collect info in that sheet (want to be an editor? PM me -- I don't think I can add everything by myself).

And I now have an idea! If it is in fact possible to get any armor of certain elements from an armor fuse, I could put together a script that would tell you what your possible results are from what you're planning to fuse. It might end up being a separate web page. Then again, I'm not sure ALL armors are fusable at this point (boss armors and such?).

No harm in that. :) Would be pretty nice to not have to figure out every possible armor when considering which to use in fusing. Saves a fair bit of thinking, especially good for in the late hours. :p

L C
06-04-2013, 10:55 PM
Bump (can't let this drop of the first page)

Nemmer
06-05-2013, 02:58 PM
Hello guys,

I've set up a little table with the BEST ARMORS per ELEMENT COMBINATION.

So if you always wanted to find out what the best Earth/Water-armor was - here it is.

I'm listing at least 4 armors each - the best three of each combination plus the best CRAFTABLE lvl50-armor (probably interesting for newer players).

In addition, you can find a list of all
- kaleidoscopic armors (all three)
- epic armors (all that I know of)
- overall best armors (top ten) *

* Please note that the Black Kaleidoscopic Raiment may be the best armor overall (no weak element, guaranteed attack bonus); however, since certain combinations are not used, and since many combinations are rather frequent (Fire/Spirit, Earth/Water etc.), there is no "best armor under any circumstance", but only a "best armor for an opponent's specific combination.

In short: BKal rocks, but so do others. If you have it - use it. If not - don't despair.

3623

Raistmar
06-05-2013, 03:15 PM
Nicely done nemmer.

indonesian
06-05-2013, 07:21 PM
great job nemmer.

i wish i could send you a reputation point, wise one please make a new fiture in our forum, maybe everyone could give a reputation point for everyone who had made a contribution :D

Jello
06-06-2013, 06:54 AM
Thank You. Nice job on the data sheet. I'd like to suggest adding a tab with the spreadsheet I made on the buildings and gold earning potential. I hunted around for something like this so I can see the actual gold stats on each building and level, but couldn't find anything. All I found were people's suggestions in the guides on what to build while leveling up.

What triggered all of this was when I built my first training field, the 1,167/hr didn't seem to match up. When I checked, it was actually only 900/hr for Lvl 1. I noticed this discrepancy on the Guard Tower (167 stated, 162 actual), Cathedral (500 stated, 450 actual), Tavern (475 stated, 450 actual), Conservatory (800 stated, 720 actual), and Monsters Nest (750 stated, 720 actual). The only 2 that are correct are the Fountain and Dungeon.

So I created an in-depth look at the earning potential for each building and level. Only exception is Lvl 3 for Conservatory and Dungeon as I didn't have the gems to upgrade these to test gold production. I assumed the values of the Lvl 3 Dungeon based on the Lvl 3 Tavern rate of increase.

Actual data would be nice so if anyone would care to contribute to these 2, get a stopwatch or timer, collect the gems from the building and start the stopwatch. At exactly 5 minutes write down the gems in the building but don't collect them. Do the same at the 10 minute mark. The 10 minute is the key, but the 5 minute will be a backup verification. All the rest (20, 30, 60 min) will be accurate if the 10 minute gold count is accurate. I did 3 checks at full 5, 10, 20, 30, and 60 minutes to verify accuracy if I wrote down just the 10 minute mark.

Hope this is useful information for everyone. I have it in Excel 2007 format if the person managing the Armors_Data spreadsheet would like it. Just PM me with your email address.

Jello


Edit: I have updated the spreadsheet to Rev 2. I added the data for Monster Nest L3, and did different calculations at the bottom to show the actual max gold/day can be 828,574 with 29 Monster Nest when collected at least every 2.1 hours. For long term collection (at least once every 11.9 hours), 14 Training Field Lvl 3 and 1 Dungeon Lvl 3 will be best (9,000 gold will be waiting in the dungeon each 11.9 hours). Replace the Dungeon Lvl 3 with a Monster Nest Lvl 3 for more frequent intervals.

Varza
06-06-2013, 01:14 PM
Jello, it's great to see you're still around. I think I was worried you might quit when all those problems popped up with the update (if that was not you, I am an idiot with bad memory, sorry!).

Anyway, thank you very much for that data, it will help people a lot! I sent you a wall of text PM, there's more info there, but yes, this data will be added to the spreadsheet.

Jello
06-07-2013, 07:40 PM
Did a fusion of Atlantean Avenger Armor+ and Chimera Corps Uniform for the quest "Complex Combination" and came up with Wavecharmer's Mantle:

3644

This is not on the list of results under Third Tier Combos for AA and Chimera.

I apparently don't understand how to get the image to just come up in the post instead of as a link.

Jello
06-07-2013, 09:26 PM
Also, any information on the new Flame Summoner's Shroud from FlameEater? It's not on the sheet. Here's the basics, but I don't know the Stat Increase or Stat Max Level Info.

Fire/Air | Regular | 70 | Legendary/4 Star | 293 | 423 | ? | ? | ? | ? | ? | ? | Yes | 200,000 | 50 | ? | 90 | 72

deathexe
06-07-2013, 09:30 PM
Also, any information on the new Flame Summoner's Shroud from FlameEater? It's not on the sheet. Here's the basics, but I don't know the Stat Increase or Stat Max Level Info.

Fire/Air | Regular | 70 | Legendary/4 Star | 293 | 423 | ? | ? | ? | ? | ? | ? | Yes | 200,000 | 50 | ? | 90 | 72

You can see the max stats for the +version in the boss screen if you need it.

Edit: it's 875/1364

Jello
06-09-2013, 12:27 PM
You can see the max stats for the +version in the boss screen if you need it.

Edit: it's 875/1364

So Max 875 Attack and 1364 Defense for a combined 2,239 (for +)? So probably 1795-1800 combined for non + version? Good defense, but I'm wondering if it's worth the 200,000 + Enhancements to replace Crius Armor +, or wait for something better. I guess I could put the Crius on my Earth to replace Monks Vestments.

Justice711
06-14-2013, 03:21 AM
Seriously need a bump. This should always be page 1 or sticky!

Alexa
06-14-2013, 09:30 PM
Oh and Jackalope regular and its ATK/DEF per level.. Please put it up :)

Jello
06-18-2013, 05:49 AM
Thanks Marcial for adding my Buildings and Gold tab to the worksheet.

Unresolved
06-18-2013, 07:26 PM
Thanks for all the hard work put into the spreadsheet. I see a couple problems though. When I download the file as an excel spreadsheet, some of the rows are too small to read without expanding them. Also, whenever I try to sort the rows by either smallest->largest or largest->smallest, the file crashes. Any idea what's causing this?

Dharkblade
06-19-2013, 08:06 PM
Hi not really much help now the epic is over but I've recently submitted jackalopes nemesis stats.

BethMo
06-21-2013, 02:16 PM
One of my guildmates just got Dragon Tamer; the increase per level is +7/+10. The chart shows that as the increase for Dragon Tamer+, so I suspect that's an error.

Marcial1234
06-21-2013, 02:23 PM
Corrected. thank you

BethMo
06-21-2013, 05:59 PM
One of my guildmates just got Dragon Tamer; the increase per level is +7/+10. The chart shows that as the increase for Dragon Tamer+, so I suspect that's an error.

Whoops, I'm wrong! His *was* the plus, base was 284/344. Wow, the non-plus must really stink. (Even the plus that he got was bad enough that he fused it into something else in disgust.)

ZFxAltiMeR
06-23-2013, 12:00 AM
not sure what to call it or whatever, but it isn't on the data sheet and the new boss armour (pyromancer's mantle) attack goes up 9/lvl and defence goes up 7/lvl. not sure where to submit this to but hope this helps as i've been looking all over for this info :)

Howzee87
06-23-2013, 08:05 AM
Just submitted details for Brawler's Armor + version

Base A:208 D:256
+ A:7 D:10
total A:551 D:746
combined: 1297

Big thanks to Epon for sending this info to me

Marcial1234
06-23-2013, 10:43 PM
ok thanks howzee. just added it

Silent follower
06-25-2013, 12:46 AM
Why was the monsters drop from the different areas table removed from the data sheet? I found it useful when checking where do you get easiest some specific armor materials. Or do we have another data sheet with this data and the fusion results?

Sir.
06-27-2013, 09:17 AM
Bumpity bump required.

BethMo
07-02-2013, 10:14 PM
Thatzme pointed out that the stats for Aegis of the Dragon in the spreadsheet are wrong. He doesn't remember the starting stats or plus per level, but at level 70 it's 1,160/1,321:
http://images.wikia.com/knightsanddragons/images/3/39/Aegis_of_the_dragon_helmet.png

Nemmer
07-03-2013, 04:43 AM
@Beth: noted, I just passed on the info to Varza. The value for def-per-lvl was wrong (8 when it should have been 12).

For everybody: please note that we basically took the scraps of the old (and misused) datasheet and tried to repair it as well as we could. So please be patient with us, the quality will near 100% over time.

Vezna
07-03-2013, 02:59 PM
I am suprised no one has added the stats for wanderers shroud yet. Anyone got the + version close to 70?

Raistmar
07-03-2013, 03:02 PM
I am suprised no one has added the stats for wanderers shroud yet. Anyone got the + version close to 70?

+ version max stats is shown in the epic boss page. Doubt there'd be many people leveling this armor though.

Newsmurf
07-03-2013, 07:06 PM
anyone know the stats on bk+?

Silent follower
07-03-2013, 11:16 PM
I sent the stats for Pyro+ with the webform, but they aren't added. Pyromancers mantle+ has 410/390 a/d with increases of 12/9 each level. Can somebody add them there?

Marco_
07-05-2013, 06:00 PM
Building Production tab:

Level 3 Training Field is listed as 21500 max gold, while in game it lists 24000. , for a gold/hour of 24000 / 14000 * (1166 2/3rds) = 2000 .
(And I think the sheet is kind of missing a sort of "max value reached after" column...)

Dungeon gold/hour: 2 and 3 seem to have one zero too much at the end.

Many wrong (propagated rounding errors?) values in Time Breakdown. Maybe the whole "Time Breakdown" part should just be changed to formulas instead of values?

- Percentage increase: unclear if that compares to level 1 or to the previous level
- Potential Per day: also has some wrong values. Wouldn't just using a simple formula of column Q = 24 * column D work fine there?

- the 167/1167 gold/hour values are of course Gree rounding/false advertising and actually being 167 2/3rds and 1166 2/3rds. ;)


heck, nearly every cell could probably be a formula using just
level 1 gold/hour, level 1 max gold and for level 2 and 3 their max gold as input.

(example for Training Fields:
D22 = E22 / E21 * D21
D23 = E23 / E21 * D21
H21 = D21 / 3600
H22 = D22 / 3600
H23 = D23 / 3600
etc.
Q21 = 24 * D21

(and D21 = 1166 + ( 2/3) )
)



Hmm, if I adjusted the cells correctly and gold/hr column is correct, in descending order:
- Fountain lvl3 36000 gold/day/square, but maxes after 5 minutes
- Monster Nest lvl3 30000 gold/day/square, but maxes after 2 hours
- Conservatory lvl3 28800 gold/day/square, but maxes after 30 minutes
- Training Fields lvl3 48000/2 = 24000 gold/day/square and maxes after 12 hours
- Monster Nest lvl2 22800 gold/day/square, but maxes after 2 hours
- Fountain lvl2 21600 gold/day/square, but maxes after 5 minutes
- Conservatory lvl2 21600 gold/day/square, but maxes after 30 minutes
- Conservatory lvl1 19200 gold/day/square, but maxes after 30 minutes
- Cathedral lvl3 19200 gold/day/square, but maxes after 1 hour
- Monster Nest lvl1 18000 gold/day/square, but maxes after 2 hours
- Tavern lvl3 18000 gold/day/square, but maxes after 4 hours
- Dungeon lvl3 18000 gold/day and maxes after 20 hours
- Training Fields lvl 2 33000/2 = 16500 gold/day/square and maxes after 12 hours
- Fountain lvl1 14400 gold/day/square, but maxes after 5 minutes
- Cathedral lvl2 14400 gold/day/square, but maxes after 1 hour
- Training Fields lvl 1 28000/2 = 14000 gold/day/square and maxes after 12 hours
.
.
.

Jello
07-05-2013, 07:47 PM
Hi Marco... someone else did the transfer to the Data Sheet, but it is correct (except for Training Field Level 3 max as noted below) compared to my original sheet. I now have editing rights so I just copied over the time to fill max gold columns that for some reason didn't make it. Also...


Building Production tab:

Level 3 Training Field is listed as 21500 max gold, while in game it lists 24000. , for a gold/hour of 24000 / 14000 * (1166 2/3rds) = 2000 .
(And I think the sheet is kind of missing a sort of "max value reached after" column...)

I mistakenly put 21,500 instead of 24,000 in for max gold. The Max gold is only what the building can hold, not what it produces. Gold/hour for TFL3 is still 1,800/hr, times 24 = 43,200 gold/day.


Dungeon gold/hour: 2 and 3 seem to have one zero too much at the end.

Dungeon L2 = 510/hr times 24 = 12,240 gold/day
Dungeon L3 = 756/hr times 24 = 18,144 gold/day (L3 is guesstimate based on the same increase in Tavern L3; I never upgraded a Dungeon to L3 to get an actual count)


Many wrong (propagated rounding errors?) values in Time Breakdown. Maybe the whole "Time Breakdown" part should just be changed to formulas instead of values?

Not sure where the errors are. I accurately and repeatedly measured 5, 10, and sometimes 30 minute intervals for each building and level. After seeing repeatedly that if I just took the 5 and 10 minute interval, I could accurately figure out the 20/30/60 minute figures. Do not go by what the game says on the Buy Buildings screen for gold production (in the cells "The Shop Stated Information")... most of them are inaccurate!


- Percentage increase: unclear if that compares to level 1 or to the previous level

% increase is the percentage increase per hour per level. So going from fountain L1 (600) to fountain L2 (900), that is a 50% increase - ((L2-L1)/L1). L2 (900) to L3 (1,200) is a 33% increase - ((L3-L2)/L2)


- Potential Per day: also has some wrong values. Wouldn't just using a simple formula of column Q = 24 * column D work fine there?

Again, let me know what is incorrect because I checked all the figures in column N * 24 and they all look correct.


- the 167/1167 gold/hour values are of course Gree rounding/false advertising and actually being 167 2/3rds and 1166 2/3rds. ;)

GREE's stated values are actually very incorrect. The 167/hr GREE states for a Guard Tower L1 is actually only 162/hr. The 1167/hr stated for the TFL1 is really only 900/hr. Same goes for Cathedral, Tavern, Conservatory, and Monsters Nest.



heck, nearly every cell could probably be a formula using just
level 1 gold/hour, level 1 max gold and for level 2 and 3 their max gold as input.

(example for Training Fields:
D22 = E22 / E21 * D21
D23 = E23 / E21 * D21
H21 = D21 / 3600
H22 = D22 / 3600
H23 = D23 / 3600
etc.
Q21 = 24 * D21

(and D21 = 1166 + ( 2/3) )
)

Formulas would probably work, and I did have some in the original excel sheet.


Hmm, if I adjusted the cells correctly and gold/hr column is correct, in descending order:
- Fountain lvl3 36000 gold/day/square, but maxes after 5 minutes
- Monster Nest lvl3 30000 gold/day/square, but maxes after 2 hours
- Conservatory lvl3 28800 gold/day/square, but maxes after 30 minutes
- Training Fields lvl3 48000/2 = 24000 gold/day/square and maxes after 12 hours
- Monster Nest lvl2 22800 gold/day/square, but maxes after 2 hours
- Fountain lvl2 21600 gold/day/square, but maxes after 5 minutes
- Conservatory lvl2 21600 gold/day/square, but maxes after 30 minutes
- Conservatory lvl1 19200 gold/day/square, but maxes after 30 minutes
- Cathedral lvl3 19200 gold/day/square, but maxes after 1 hour
- Monster Nest lvl1 18000 gold/day/square, but maxes after 2 hours
- Tavern lvl3 18000 gold/day/square, but maxes after 4 hours
- Dungeon lvl3 18000 gold/day and maxes after 20 hours
- Training Fields lvl 2 33000/2 = 16500 gold/day/square and maxes after 12 hours
- Fountain lvl1 14400 gold/day/square, but maxes after 5 minutes
- Cathedral lvl2 14400 gold/day/square, but maxes after 1 hour
- Training Fields lvl 1 28000/2 = 14000 gold/day/square and maxes after 12 hours

As stated, I added the Max out columns, so take a look.

IronymanX
07-06-2013, 12:58 AM
Very helpful, great Idea and doing!
This is game really unuser friendly, such stuff help get us thorugh.

DottorB
07-06-2013, 03:07 AM
Anyone got info for the last armor sets ?

gexstar
07-06-2013, 04:18 AM
Uhm, so what does this mean ?
Dungeon is better than Trainingfield now ? :D

Jello
07-06-2013, 04:24 AM
Uhm, so what does this mean ?
Dungeon is better than Trainingfield now ? :D

What are you seeing that makes you say that? dungeons l3 hold 15k and make 18k/day. 2 of them (each takes 1 spot) make 36k a day. Training fields l4 hold 24k and make 43k/day. One takes up a double spot.

Marco_
07-06-2013, 07:53 AM
[snip]

GREE's stated values are actually very incorrect. The 167/hr GREE states for a Guard Tower L1 is actually only 162/hr. The 1167/hr stated for the TFL1 is really only 900/hr. Same goes for Cathedral, Tavern, Conservatory, and Monsters Nest.

Ah, that could be a point of confusion...
If the gold/hr column contains official, but pretty fake numbers, write so in big neon letters!
And then have 2 columns _exactly_ next to each other for ex. "listed gold/hr" "measured gold/hr"
Else if the gold/hr column contains the value "800" and the "per hour" column contains the value "720" then the only logical conclusion I can make from the sheet is that something is wrong and that most likely it's the added data...
(especially with the knowledge that the google docs spreadsheet was once editable by everyone...)

Looking at the spreadsheet, especially the "per sec" column with that new insight, in combination with some testing of my own, I think I've reverse engeneered the building production system:
It looks like gold adding up is restricted to "ticks" on whole second boundaries.



0.5 -> 1 tick every 2 seconds -> 1800/hour
0.3333 -> 1 tick every 3 seconds -> 1200/hour
0.25 -> 1 tick every 4 seconds -> 900/hour
0.2 -> 1 tick every 5 seconds -> 720/hour
0.1667 -> 1 tick every 6 seconds -> 600/hour
0.1429 -> 1 tick every 7 seconds -> ~514.29/hour
0.125 -> 1 tick every 8 seconds -> 450/hour
0.1111 -> 1 tick every 9 seconds -> 400/hour
0.1 -> 1 tick every 10 seconds -> 360/hour
0.0909 -> 1 tick every 11 seconds -> ~327.27/hour
0.0833 -> 1 tick every 12 seconds -> 300/hour
0.0769 -> 1 tick every 13 seconds -> ~276.92/hour
0.0714 -> 1 tick every 14 seconds -> ~257.14/hour
0.0667 -> 1 tick every 15 seconds -> 240/hour
0.0625 -> 1 tick every 16 seconds -> 225/hour
0.0588 -> 1 tick every 17 seconds -> ~211.76/hour
0.0556 -> 1 tick every 18 seconds -> 200/hour
0.0526 -> 1 tick every 19 seconds -> ~189.47/hour
0.05 -> 1 tick every 20 seconds -> 180/hour
0.0476 -> 1 tick every 21 seconds -> ~171.43/hour
0.0455 -> 1 tick every 22 seconds -> ~163.64/hour


So Training Field level 3 is 1800 gold/hour because the only other option would have been 1 tick per second or in other words 3600 gold/hour. (which would have been nice though... ;) )


So I guess using "Time Breakdown -> per sec/per hour" that results in:


building level seconds between gold ticks max gold seconds to maxed time to maxed
Fountain 1 6 50 300 00:05:00
Fountain 2 4 75 300 00:05:00
Fountain 3 3 125 300 00:05:00
Guard Tower 1 22 2000 44000 12:13:20
Guard Tower 2 18 or 19 (test!) 2500
Guard Tower 3 14 or 15 (test!) 3300
Catherdral 1 8 500 4000 01:06:40
Catherdral 2 6 600 3600 01:00:00
Catherdral 3 5 800 4000 01:06:40
Tavern 1 8 1900 15200 04:13:20
Tavern 2 7(?) 2300 16100 04:28:20
Tavern 3 5(?) 3000 15000 04:10:00
Conservatory 1 5 400 2000 00:33:20
Conservatory 2 4 450 1800 00:30:00
Conservatory 3 3 600 1800 00:30:00
Dungeon 1 8 9000 72000 20:00:00
Dungeon 2 7(?) 10500 73500 20:25:00
Dungeon 3 5(?) 15000 75000 20:45:00
Training Field 1 4 14000 56000 15:33:20
Training Field 2 3 16500 49500 13:45:00
Training Field 3 2 24000 48000 13:20:00
Monster Nest 1 5 1500 7500 02:05:00
Monster Nest 2 4 1900 7600 02:06:40
Monster Nest 3 3 2500 7500 02:05:00

Feel free to point out any holes there might be in my theory.
And if someone wants to stopwatch-time Guard Tower 2 and/or 3 to determine which of the values it is, please do so! (if nobody wants to, I guess I can try installing KnD in a Android emulator and run that test there somewhere in the next 2 weeks...)

Jello
07-11-2013, 12:56 PM
I added Armor of Boreas (reg and plus) to the sheet. Anyone have information on Boreas' Nemesis for the data sheet that I can add. I didn't get one from the DPC so I can't check the exact stats. I did get a Lightning Lord Armor+ though which wasn't on the sheet so I added it, then enhanced something else with it.

Singa
07-11-2013, 02:42 PM
Nice sheet!

Yoalias
07-12-2013, 02:04 AM
Hi,

How could you make Armor of Eurus + ?

I had only one without "+"...

Thx

KayOrzz
07-12-2013, 02:09 AM
Hi,

How could you make Armor of Eurus + ?

I had only one without "+"...

Thx

level current one to level 35 to unlock the plus

go to summoning stone and summon enough eurus to kill and collect enough materials to craft another set

craft eurus+

3 simple steps

:o

Yoalias
07-12-2013, 02:11 AM
oki :)

Too difficult for me.. I cant kill epic boss after level 20... Not enought strong :/

KayOrzz
07-12-2013, 02:34 AM
oki :)

Too difficult for me.. I cant kill epic boss after level 20... Not enought strong :/

all bosses at summoning stone are level 1 :rolleyes:

Yoalias
07-12-2013, 02:44 AM
exact!

I just need diamonds.... :/

only 65 now :)

gexstar
07-16-2013, 12:53 PM
Is this thing still beeing update ?

Combustion Armor and Clayplate Armor are missing.

Jello
07-16-2013, 01:21 PM
ive been updating it with new boss armors and other things i come across that arent there or are wrong. if anyone has info for combustion and/or clayplate, or anything not there, pm me and i will update the sheet.

Jello

gexstar
07-16-2013, 01:31 PM
ive been updating it with new boss armors and other things i come across that arent there or are wrong. if anyone has info for combustion and/or clayplate, or anything not there, pm me and i will update the sheet.

Jello

Ok, great. I send you a pm with all the info i got on those two.

ToddWY
07-16-2013, 01:49 PM
...
It looks like gold adding up is restricted to "ticks" on whole second boundaries.
...

Great work breaking everything down in your post, but I think it might work a little differently than that. From my quick testing it looks like the gold only adds up on whole second boundaries when you're on the castle screen, but if you leave the game and come back it's leveled up according to the stated in game numbers. I'll try to test more thoroughly if I have a chance this evening, but someone might be able to verify before that.

Lii
07-17-2013, 02:08 AM
Copied the armor leveling information to the main spreadsheet (the one mentioned in this thread) to keep things in one place :)

Would be nice if we could get a sticky on this thread...

Shayken
07-19-2013, 03:41 AM
The armor spreadsheet says that Asura Armor can be smithed with Asura Charms but I can't find it in my armorsmith. I asked in the forum if it can be smithable and the response I got was that it used be smithable but not anymore. I know most ppl won't care because its rubbish armor, but I thought I'd point it out.

Btw, this spreadsheet is freakin awesome. I hope more ppl jump on board to help perfect it. :)

Marco_
07-19-2013, 04:05 AM
Hmm, maybe something like "Can be Smithed?": "Yes (epic boss)" or just "epic boss" or something like that to distinguish between storyline craftables and epic boss craftables?

(Also need to collect all that epic boss / boss armor / epic boss materials link stuff some time in the future to fix/improve the wiki...)

Marco_
07-19-2013, 07:50 AM
Small correction:
Craft material for Armor of Eurus is Jagged Scales, not Dancing Flames.
Dancing Flames is the material for Wanderer's Shroud.

What would be really helpful: a dated changelog in the topic starter post; that way I could know if my local copy is up to date (google docs is way too sluggish compared to LibreOffice...) .

Sakino
07-19-2013, 02:22 PM
Here a list of suspect data to re check...
Admiral hateheart nemesis, someone have got it?
Asura armor+' miss some stats
Boreas nemesis + have only max stats
I think we missed deva nemesis +
Dragon tamer + increases by 7/10
Flamegem nemesis is missing stats, i saw it picture on the forum, i will edit this post if i find
Need guardian battlegear + basic stats plus increase, i may approximate em to 11/12 level increase whit appropriate basic stats of 454/474
Molten shroud and plus version of itself have same stats, missing the max stats of the plus version i cant approximate em
Notus nemesis and plus are missing all stats ecept the max one
Need rageborne raiments +
Need ruby plate mail +
Tempered battlegear aproximate stats based on the max stats are an increase of 13/9 whit basics of 500/423
Need tortoise nemesis stats
Need volcanic mantle plus, the dark prince chests drop tons of this s**t and no one checked em? XD

Jello
07-19-2013, 03:13 PM
Here a list of suspect data to re check...

Thank's for the update information...

Asura armor+' miss some stats - waiting for a person a few posts back to hopefully get me the info.
Boreas nemesis + have only max stats - someone recent should have it. Please send me any info
I think we missed deva nemesis + - Not sure if there was a + of this nemesis
Dragon tamer + increases by 7/10 - Corrected on the sheet
Need guardian battlegear + basic stats plus increase, i may approximate em to 11/12 level increase whit appropriate basic stats of 454/474 - Added to the sheet
Molten shroud and plus version of itself have same stats, missing the max stats of the plus version - Removed stats from + for now
Notus nemesis and plus are missing all stats except the max one - I know people have it. I will ask in my guild for info
Need rageborne raiments + - Is there a + for this?
Need ruby plate mail + - Anyone? Anyone?
Tempered battlegear aproximate stats based on the max stats are an increase of 13/9 whit basics of 500/423 - Added info
Need tortoise nemesis stats
Need volcanic mantle + - I've never seen a plus, but maybe someone else has.

Sir William
07-19-2013, 04:29 PM
Boreas nemesis + have only max stats - someone recent should have it. Please send me any info


What info are you looking for?

Boreas nemesis maxed is 441/561

Not + version

Sakino
07-20-2013, 05:54 PM
Thank's for the update information...

Asura armor+' miss some stats - waiting for a person a few posts back to hopefully get me the info.
Boreas nemesis + have only max stats - someone recent should have it. Please send me any info
I think we missed deva nemesis + - Not sure if there was a + of this nemesis
Dragon tamer + increases by 7/10 - Corrected on the sheet
Need guardian battlegear + basic stats plus increase, i may approximate em to 11/12 level increase whit appropriate basic stats of 454/474 - Added to the sheet
Molten shroud and plus version of itself have same stats, missing the max stats of the plus version - Removed stats from + for now
Notus nemesis and plus are missing all stats except the max one - I know people have it. I will ask in my guild for info
Need rageborne raiments + - Is there a + for this?
Need ruby plate mail + - Anyone? Anyone?
Tempered battlegear aproximate stats based on the max stats are an increase of 13/9 whit basics of 500/423 - Added info
Need tortoise nemesis stats
Need volcanic mantle + - I've never seen a plus, but maybe someone else has.

After this check, my eyes were burning, please get some softer shaded color for background, and make the lines thinner... My eyes will say thanks to you.
Another thing... Can you adjust storm sorcer and lightin lord element to match for the plus and unplus? Actually for both they is an air water one and a water air one. A last thing.... Can you paint the lines to have different colors? Like a darken one and a lighter one, to get throught the name, stats etc, whitout have to check 10 times after looking away for a second... Thank!

Zaindo
07-20-2013, 07:44 PM
Thank you! The sheet makes looking up data so much easier.

Barbanium
07-20-2013, 09:50 PM
Hi!, I made a calculator that calculates the cost of enhancing and simulates the process when the type of armor being used to enhance (e.g snakeskin) is the input. I used the data of the "points required to level" from this:

https://docs.google.com/spreadsheet/ccc?key=0AiQKRFnZ9_jpdEFtUUVnd2dQM1ZIX2IxT1RNZVlva lE#gid=9

and I will give credit to it.

I just wanna know who are the creators of this doc so I can name them once I posted the calc. :D

Lii
07-20-2013, 11:13 PM
Hi!, I made a calculator that calculates the cost of enhancing and simulates the process when the type of armor being used to enhance (e.g snakeskin) is the input. I used the data of the "points required to level" from this:

https://docs.google.com/spreadsheet/ccc?key=0AiQKRFnZ9_jpdEFtUUVnd2dQM1ZIX2IxT1RNZVlva lE#gid=9

and I will give credit to it.

I just wanna know who are the creators of this doc so I can name them once I posted the calc. :D

Hi Bard,

Nice calculator!
I made the original Armor leveling docment (if that was what you were referring to). Initially it was based on numbers people had posted on the forum. Then Jello have spent (I guess) hours and hours verifying and updating all the data for the levels, to get it to the level of detail we have today :)

Barbanium
07-21-2013, 07:42 PM
Hi Bard,

Nice calculator!
I made the original Armor leveling docment (if that was what you were referring to). Initially it was based on numbers people had posted on the forum. Then Jello have spent (I guess) hours and hours verifying and updating all the data for the levels, to get it to the level of detail we have today :)
Hi! I special mentioned you and Jello in the thread:
http://www.funzio.com/forum/showthread.php?61980-Knights-amp-Dragons-Armor-Enhancing-Simulator-and-Calculator

also, here's the calculator. I added a time calculator feature:
https://docs.google.com/spreadsheet/ccc?key=0Ao5016Mn5Xg6dFh1eEJkZjNhZlJnMXljWHlvMjJYb 3c#gid=0

btw, it's Barbanium (Barb for short), not Bard :p

Lii
07-21-2013, 11:29 PM
Hi! I special mentioned you and Jello in the thread:
http://www.funzio.com/forum/showthread.php?61980-Knights-amp-Dragons-Armor-Enhancing-Simulator-and-Calculator

also, here's the calculator. I added a time calculator feature:
https://docs.google.com/spreadsheet/ccc?key=0Ao5016Mn5Xg6dFh1eEJkZjNhZlJnMXljWHlvMjJYb 3c#gid=0

btw, it's Barbanium (Barb for short), not Bard :p

Lol, sorry about that! I have see you flash by on Line and figured you were Barb. I have no idea why I wrote Bard, b & d are not even close on the keyboard... Maybe I unconsciously know that you are good at singing? ;)

Anyways, thanks for the calculator :)

anuarreyes
07-23-2013, 08:44 AM
Just a question maybe it was said before but isnīt the table where you compare armors kind of out of place where it says start attack it indicates the rarity of the armor and then all the slots from down there are out of place D:

Lii
07-23-2013, 05:22 PM
Just a question maybe it was said before but isnīt the table where you compare armors kind of out of place where it says start attack it indicates the rarity of the armor and then all the slots from down there are out of place D:

Never used that part so haven't thought about it, but thanks for commenting on it. Fixed the rows so that the text line up with the actual result. Not sober enough to figure out what whoever wrote the part with the comparison formulas wanted to achieve, so not sure if they work as expected though.

anuarreyes
07-23-2013, 10:27 PM
Np Thanks as I see it, it put the cost ep and all the stats to help make the better decision on which armor max out for example the Big four so you can focus on which give priority

ToddWY
07-24-2013, 01:00 PM
I did verify (on Android at least) that gold accumulates faster when you're not playing the game. If you're playing and checking the gold you'll see it growing at the rates listed in the spreadsheet. When the game is closed it accrues at the rates specified in the building descriptions and what the upgraded rates should be. I only verified for Monster Nest level 2 (950 gph), Training Field level 2 (1375 gph) & Training Field level 3 (2000 gph). Granted you do loose a few gold even opening the game to check the totals, but they were close enough I'm confident that's the way it's working.

As far as I can tell playing the game at all (Arena, quest, epic battles, etc) drops the production to the rates shown on the spreadsheet.

Jello
07-29-2013, 08:03 PM
I have updated the Data Sheet with an estimation from QuantumP 86's numbers from 70-99 on the Epic armor.

I have also added a new tab called 'Stats by Level'. It shows the increase from 1 to 100 for the Commander and Followers stats, as well as rewards for each level. I started doing an approximate experience to the next level from 8-20, then lost my droid to work with. I am missing a couple of levels that i forgot to take a snapshot or write down. Levels 45-49 I am working on with another iPhone so I should have those. But if anyone has level 10, 24, and 26 to fill in the blanks I missed that would be great.

Marco_
07-30-2013, 04:42 AM
I'll probably install K&D on an emulator later in the week to start filling in the blank first part of my quests log, so I can probably screenshot those early levelups then.

Jello
08-03-2013, 04:20 PM
Another new tab added to the Data Sheet - "Epic Boss History"

Revelate posted in the [Danger] Slimelord Glorg thread a good list of bosses and elements. I thought I would take it one step further and try to complete it and put it in the Data Sheet for reference. I've wondered where some of the older Legendary armor came from since I've only been playing since Sasquatch. I'm not sure about 2 things:

1) Bone Dragon - Was his armor Exorcist's Vestments or Lightning Lord Armor (or something else?).

2) I show Gremlin Battlesuit boss dropped mats for Battlesuit Remnants which was an Earth only element armor. I also show the next boss as Mountain Man Gorlog that dropped mats for Mountainvine Shroud which was also Earth only. Is this correct?

Thanks for any assistance, and I hope this data is used by many people as a good reference for past bosses and armor elements.

Justice711
08-12-2013, 04:54 AM
Bump up :)

NoGrip61
08-13-2013, 06:44 AM
I just submitted a data ticket for the Blazeborne Vanguard, regular armor, 5*. Some clarifications:
Fused from regular Armor of Notus and regular Armor of Phyrus.
Attack/Defense:
Base stats: 576/429
Level 6 stats: 631/529
Increments: 11/10

The maximum level for a 5* was "99" on the data sheet, so I'm not sure if that's true or what it meant, but I calculated the stats at level 70 to be 1346/1179.

...

On a side note, I don't understand why this isn't a sticky yet...

Jello
08-13-2013, 08:01 AM
thanks for the info. blazeborne is an Epic 5* armor and its max level is 99. That is what the 99 on the data sheet means. there are 3 epic armors: Moontide, Blazeborne, and the New guild war award Cloudrange. All 3 are 5* and are max level 99. Its odd that they didnt just make it 90, making room for a future 6* to be 100.

if anyone has stats on thr plus version, please let me know.

Matti1992
08-13-2013, 08:41 AM
How do we calculate the max stats for an armor?

NoGrip61
08-13-2013, 09:11 AM
How do we calculate the max stats for an armor?
Use the formula:
(Base stats) + (Max Level or any level)*(stat increase) = Max stats or at whichever level number you entered in.

Blazeborne Regular max stats @ 99 (A/D): 1665/1469

cubey
08-17-2013, 03:30 PM
Aegis of the Fallen Normal

Fire/Spirit
Base 308/425
Increments: 6/10
Max: 722/1115
Total: 1837

Silent follower
08-20-2013, 12:59 AM
Bump up and info on the Cloudrange Platemail which is partly missing and partly incorrect:

Cloudrange Platemail (normal)

A 466 increase 9 max 1348
D 601 increase 10 max 1581

Archetype
08-20-2013, 02:37 AM
Wow , this is actually pretty good.
It's nice to have something we can look at to compare one armor to the other.
Good Job :D

I'll try to help updating some armors+ which i have ~

Marco_
08-21-2013, 12:50 PM
Ugh, hard to parse...
- the idiots at google docs in their infinite wisdom decided that upon cvs export, they should insert thousands separator commas... :mad:
- at least 1 armor is listed on Recently Added, but not on Armors (Blazeborne+)
- when armors get bumped from Recently Added to Armors, I guess any more fixes to that armor aren't also fixed on Recently Added, so my smart idea of "cat"-ing the 2 csv files generated from the sheets together to get all armors and then "| sort | uniq" them to removing duplicate entries, fails because the rows are slightly different...

Barbanium
08-22-2013, 02:36 AM
Hi! When I was enhancing my Bkale and started using Fusion Stone armors (those that give 50 EP when elements are matching), I noticed 164 EP is added to my Bkale when 4 Fusion Stone armors are used.
(Note: ALL 4 OF THEM ARE LEVEL 1)

Now based on Armors_Data, under Armor Leveling tab, Non-Craftable Rares that do not match elements give 40 EP (4 of them would be 160 EP)

So my question is: Why don't they match?
Is this new with the K&D updates? A special case for Bkale? Or the data is wrong?

Pic for proof:

http://i.imgur.com/Y6A4Y4N.png

I cut out those from the original screenshots cause I'm ashamed to show my current gold and fusion stones
but BELIEVE ME, that's the result that I got.

And while you're at it, please confirm that the EP data from the other types of armor are correct. :D

Sifu
08-22-2013, 05:37 AM
I thought Bkal was different. Being all elements, it is also none. It gets the attack bonus for all, however, does not match any element for enhancement.

Silent follower
08-22-2013, 06:07 AM
The new leviathan nemesis armor stats are:

A 247 increase 7 max 590
D 253 increase 8 max 645

Barbanium
08-22-2013, 12:03 PM
I thought Bkal was different. Being all elements, it is also none. It gets the attack bonus for all, however, does not match any element for enhancement.

Yeah, you're totally right about that. My point is, even though Armors_Data shows that you can only receive 40 EP from NON-MATCHING Non-Craftable Rares, I got 41 EP per Wavecharmer (Total of 164 EP) when I was enhancing my Bkale.

I know it's just a difference of 1 EP but I really want my calc as accurate as possible.
So anyone managing these data, could you PLEASE confirm if this is right or wrong? :)

Unresolved
08-22-2013, 12:04 PM
Yeah, you're totally right about that. My point is, even though Armors_Data shows that you can only receive 40 EP from NON-MATCHING Non-Craftable Rares, I got 41 EP per Wavecharmer (Total of 164 EP) when I was enhancing my Bkale.

I know it's just a difference of 1 EP but I really want my calc as accurate as possible.
So anyone managing these data, could you PLEASE confirm if this is right or wrong? :)

Was your wavecharmer level 2?

Barbanium
08-22-2013, 12:13 PM
Nope. Fresh from the Fusing Basic Water and Basic Spirit, which are also fresh from Armorsmiths. (Also level 1)

-Solo-
08-22-2013, 12:15 PM
Even if it was lv2, why would it give an extra point? Doesn't only + armor carry over minus 1 point?

Unresolved
08-22-2013, 12:21 PM
Even if it was lv2, why would it give an extra point? Doesn't only + armor carry over minus 1 point?

No, all armors give 1 point per additional level.

Marco_
08-23-2013, 01:41 PM
Feature request: extra column: "can be fused" (yes/no/unknown(?))

Jello
08-23-2013, 01:45 PM
Feature request: extra column: "can be fused" (yes/no/unknown(?))

Are you referring to fusing one armor with another and using a fusion star? Or do you mean can the armor itself be created by fusing? If its the latter I think that would be quite an impossible feat to figure out. I know there is a thread dedicated to what can be possibly fused with other armors and elements. There is a sheet somewhere that shows the possibilities by fusing certain armors.

Alitia
08-23-2013, 09:07 PM
I'm so thankful for this! I only saw this after a friend showed me and its a great help! I used it as an excel on my computer and iPad so it's efficient use

Barbanium
08-23-2013, 09:16 PM
Hi! When I was enhancing my Bkale and started using Fusion Stone armors (those that give 50 EP when elements are matching), I noticed 164 EP is added to my Bkale when 4 Fusion Stone armors are used.
(Note: ALL 4 OF THEM ARE LEVEL 1)

Now based on Armors_Data, under Armor Leveling tab, Non-Craftable Rares that do not match elements give 40 EP (4 of them would be 160 EP)

So my question is: Why don't they match?
Is this new with the K&D updates? A special case for Bkale? Or the data is wrong?

Pic for proof:

http://i.imgur.com/Y6A4Y4N.png

I cut out those from the original screenshots cause I'm ashamed to show my current gold and fusion stones
but BELIEVE ME, that's the result that I got.

And while you're at it, please confirm that the EP data from the other types of armor are correct. :D

Just wanna bump my question. Anyone who can help, please respond. :)

Sakino
08-24-2013, 08:55 AM
Just wanna bump my question. Anyone who can help, please respond. :)
Used an unmatchng wawecharmer for encanching, and it gave me 40 ep. Thats strange.

Sir.
08-24-2013, 07:14 PM
Are you referring to fusing one armor with another and using a fusion star? Or do you mean can the armor itself be created by fusing? If its the latter I think that would be quite an impossible feat to figure out. I know there is a thread dedicated to what can be possibly fused with other armors and elements. There is a sheet somewhere that shows the possibilities by fusing certain armors.

For a lot of armors it's quite safe to say they can't be fused. Armors like aegis, chitinous or eldrith by example (at random). They've been around so long, that if they were fusable someone must have gotten one before. I think a 'fusable' column could be quite useful.

Marco_
08-26-2013, 08:50 AM
Are you referring to fusing one armor with another and using a fusion star? Or do you mean can the armor itself be created by fusing? If its the latter I think that would be quite an impossible feat to figure out. I know there is a thread dedicated to what can be possibly fused with other armors and elements. There is a sheet somewhere that shows the possibilities by fusing certain armors.
I meant analogous to the "can be smithed" column, if it can be the result of fusion.
We know DP is a "no", Aegis o/t Dragon is a "no", Cloudrange is probably a "no" for now and recent boss armors should all be a "no" but for those of us who have been playing relatively shortly, which of the boss armors belong before and which after the cutoff is hard to know.

I'm working on a script that fetches a csv dump of sheet 1 (and sheet 2 since not all of its armors are always listed on sheet 1) of the spreadsheet into a database and then runs some SQL SELECT queries on it. Primary task: "what are the best armors for this epic boss?" lists, but I wanted to also try it for "what are the possible results if I fuse elem1/elem2 + elem3/elem4 ?" lists, but that runs into the problem that there doesn't seem to be a listing yet which armors can and can't be the result of fusion, so I'm then not sure which entries to prune from the list (except for everything ending in a + of course ;) ) .

Zyntree
08-28-2013, 06:34 AM
I've been working on a list, and this is what I have so far. I've posted it in the fusing thread, but received no corrections or additions yet. All of these have been confirmed, so at least this could be a tentative start, with ??? by some and obviuos nos by others (Aegis of Dragon...)

***
Armor of the Infernal
Roc Feather
Sky Guardian
Spectral Captain
Storm Sorcerer
Swamp Shaman

****
Blackfrost Raiment
Boilerplate
Cloud King
Flamehunter
Guardian Battlegear
Ruby Platemail
Clayplate Mantle
Combustion

*****
Blazeborn Vanguard
Moontide Platemail

Datasheet admin, what do you think. Will you add this column of fusable or no?

NoGrip61
08-28-2013, 08:21 AM
Rocfeather and Sky Guardian are mixed up between 3 and 4 stars.

Marco_
08-28-2013, 08:48 AM
Rocfeather and Sky Guardian are mixed up between 3 and 4 stars.
Roc should be moved to 3, but Sky Guardian is listed as 3 in the spreadsheet.
I wish I had the time to comb through 100+ pages of the fusion results topic... :-|

NoGrip61
08-28-2013, 10:34 AM
Roc should be moved to 3, but Sky Guardian is listed as 3 in the spreadsheet.
I wish I had the time to comb through 100+ pages of the fusion results topic... :-|
So it is... always thought it was a 4* due to the stats.
Meh, it's mostly chance anyways. I just plan ahead for what my possible outcomes will be and then decide if I want to go through with it or not.

Varza
08-28-2013, 01:33 PM
Hey guys, I've been a little less active these days (thank Gree :P ), but I need to credit Ramuar for the recent changes, but doesn't have a forum account. He locked the first two columns, which is a great improvement to usability (now why didn't I think of that?). Thanks, Ramuar! :)

Marco_
08-28-2013, 03:16 PM
Hey guys, I've been a little less active these days (thank Gree :P ), but I need to credit Ramuar for the recent changes, but doesn't have a forum account. He locked the first two columns, which is a great improvement to usability (now why didn't I think of that?). Thanks, Ramuar! :)
Hmm, has he also accidentally disabled anonymous viewing? When I try to view the spreadsheet I get a Google Docs login page... :(

-Solo-
08-29-2013, 01:46 AM
Guardians have been changed so that's one info that has to be updated.

Keep up the good work.

Jello
08-29-2013, 03:59 AM
Guardians have been changed so that's one info that has to be updated.

Keep up the good work.

Thanks for pointing that out. I have updated to level 5 which is all the data I have right now. If anyone has stats for Level 6-10 please let me know.

Atilas
08-31-2013, 09:31 PM
The Attack per level for normal Assassin's shroud is incorrect. The spreadsheet shows 8 attack per level. It is actually 9 attack per level.

Marco_
09-01-2013, 05:55 AM
The Attack per level for normal Assassin's shroud is incorrect. The spreadsheet shows 8 attack per level. It is actually 9 attack per level.
Yep, that seems to match with my level 35 non-plus assasin.
That also means that for max attack 324 + (69 * 9) = 945, which makes sense, since Assasin+ also has slightly higher max_atk than max_def in the sheet.

Zyntree
09-01-2013, 10:24 AM
Glad to see the fusable column in the spreadsheet now. Thx guys. This thing is invaluable to me. I'm a big fan of the Armor by element section too (tab 4). It would be cool to see another section under that tab for **** fusing combos. Seeing the possibilities graphically would make it easier to plot probabilities... just a thought.

Rended
09-01-2013, 01:38 PM
Glad to see the fusable column in the spreadsheet now. Thx guys. This thing is invaluable to me. I'm a big fan of the Armor by element section too (tab 4). It would be cool to see another section under that tab for **** fusing combos. Seeing the possibilities graphically would make it easier to plot probabilities... just a thought.
+1 for the idea

Lii
09-03-2013, 12:32 PM
Yeah, you're totally right about that. My point is, even though Armors_Data shows that you can only receive 40 EP from NON-MATCHING Non-Craftable Rares, I got 41 EP per Wavecharmer (Total of 164 EP) when I was enhancing my Bkale.

I know it's just a difference of 1 EP but I really want my calc as accurate as possible.
So anyone managing these data, could you PLEASE confirm if this is right or wrong? :)

Hi Barb,

I verified with three different armors (including bkal) that unmatching uncraftable armors give 41 EP as you say. So I have updated the spreadsheet with the new number. I know someone else said they actually did get 40EP, but as my own research shows 41 I'll go on that for now ;)

Lii
09-03-2013, 12:37 PM
Glad to see the fusable column in the spreadsheet now. Thx guys. This thing is invaluable to me. I'm a big fan of the Armor by element section too (tab 4). It would be cool to see another section under that tab for **** fusing combos. Seeing the possibilities graphically would make it easier to plot probabilities... just a thought.

Hi Zyntree,

I updated the armor by element tab with the recent armors and also added a note on armors confirmed to be able to get through fusing/combining on that page. Was it something like that you had in mind?

Zyntree
09-03-2013, 05:33 PM
Hi Zyntree,

I updated the armor by element tab with the recent armors and also added a note on armors confirmed to be able to get through fusing/combining on that page. Was it something like that you had in mind?

Ah yes. That is wonderful. Thanks :). I've been putting in combos in a spreadsheet and writing down all possible combinations with my chosen armors... this will make looking at those probabilities much better. Now if only I could craft one of those epics...

NinjaMaster
09-08-2013, 03:09 AM
Am I right in saying that a Water and spirit basic fusing could get me a Moontide and black frost ?
But of course random

anuarreyes
09-09-2013, 06:50 PM
Am I right in saying that a Water and spirit basic fusing could get me a Moontide and black frost ?
But of course random

Yeah you could with very low chances you are probably gonna finish with a wavecharmer mantle

iH8t2lose2
09-09-2013, 07:07 PM
For contributions 1.6 mil is air

iH8t2lose2
09-09-2013, 07:08 PM
And 1.8 mil is water

iH8t2lose2
09-09-2013, 07:10 PM
Also, epics are five green stars instead of gold

Sifu
09-11-2013, 06:57 AM
I have an idea for a feature that could be added to the spreadsheet. I have been doing this on my own, but it could work here. Not sure if others are interested in something like this or not...

I have been putting in the base stats of my armor and then using a simple cell reference + level gain for att and def and copying that all the way to max level. I use this to assess when my new armor will have enough stats that I consider it "usable". For instance, I am leveling SS+ at the moment.

1.....264.....292
2.....B2+8...C2+12
3
4
5
etc

Using this, I can see that my att won't be competitive with my maxed big 4 until I get the armor to the high 50's and that is likely when I will start to use it for more things. Because the def scales so well, I have started to use it some in snakeskin farming since it doesn't take much att to one-shot all those mobs.

I was going to build this out with an armor picker that would automatically load the base stats and the level gains. Then it occurred to me, I would need to copy this whole data sheet to have all that info. Seems like it would just be easier if it was a feature of your incredible work rather than re-inventing the wheel (I confess to shameless flattery here).

Anyways, not sure how much work that might take considering all the data you already have collected. Also not sure if others would even use it, so it might not be worth your time. Just a thought.

NinjaMaster
09-11-2013, 02:46 PM
Sifu, very good idea.
I was also going to do the same for the epic history bosses whereby I could see at a glance what is best to keep and upgrade or use as fusion materials.
Also due to being a very new player, with these def and att information on the epics I can see what I am up against in arena.
Ty in advance people and very very decent work done here....very informative information that's help me in the spreadsheet and forum.

FlipDaddy
09-13-2013, 08:55 AM
Is it just me or is the data sheet down at the moment?

Jemnidad
09-13-2013, 09:35 AM
Is it just me or is the data sheet down at the moment?

Looks like it to me too.

Zyntree
09-13-2013, 12:46 PM
Looks like it's working for me. Maybe it came online

Zrednic
09-13-2013, 09:08 PM
There are 3 +armors that are input into the spreadsheet as normal versions, when they are not.
Cloudrange , volcanic mantle, and mantle of the beast all have +versions with the regular tag.

I would also enjoy seeing a 'available outside of chests' flag, as that is my personal interest. I try to filter by regular versions, but that occludes some useful (craft able) non-regular armors.

Zyntree
09-16-2013, 09:05 PM
I would like to make an addition to the fusible armor notes.
Barbarian Raiding Gear can be fused
Epics can no longer be fused (to the best of my knowledge)

Silent follower
09-17-2013, 12:02 AM
You cannot add the Epics to the form, I used the form but had to pick Legendaries when I added the data for Forgestone Aegis regular. The data once more are:

A 571, increase 11 MAX: 1649
D 541, increase 10 MAX:1521

gnolaum
09-23-2013, 05:01 PM
Request sticky!

ramuara
09-25-2013, 12:25 PM
I finally have a working forum account and have made the recent updates from here and the form submissions.

-Solo-
09-25-2013, 12:33 PM
Is Troll's non+ stats that low or is that a mistake?

Nec772
09-29-2013, 08:36 AM
Armor of the Bear normal appears to have Atk go up by 9 points per level and Def go up by 6 points per level that should make its max 1049 Atk and 780 Def.

EljayK
09-30-2013, 04:18 PM
BeastMaster's Battlegear: normal: 572/572 starting. 10/10 per level. 99 levels (Epic.) 1552/1552 final.

Tectonic+ : 581/652 starting. 9/14 per level. 99 levels. (Epic) 1463/2024 final.

cool-extreme
10-02-2013, 01:07 PM
Tetcnonic mantle+
Blazeborn vanguard+
Added trought submit form

gnolaum
10-08-2013, 08:47 PM
Excellent resource! Thanks!

One minor quibble howerver ...

Any reason why some armors are listed as WATER/SPIRIT (i.e. Soulshard Necromantle), and others was SPIRIT/WATER (i.e. Moontide)

Personally I would start at FIRE and proceed clockwise, thus SPIRIT/WATER would be the 'correct' representation.

Barbanium
10-08-2013, 10:16 PM
Hi everyone! I just wanna ask, who created the Building Production tab in these spreadsheets? I'm planning to make a Gold Income Calculator and to make it accurate, I need to ask a bunch of questions to the creator of this tab. I'm asking anyone who could point to me that person. If you're that person, however, please respond. Thanks in advance! :D

NoGrip61
10-09-2013, 04:12 AM
Any reason why some armors are listed as WATER/SPIRIT (i.e. Soulshard Necromantle), and others was SPIRIT/WATER (i.e. Moontide).

Some armors are listed that way in the game.

EljayK
10-09-2013, 05:16 AM
Excellent resource! Thanks!

One minor quibble howerver ...

Any reason why some armors are listed as WATER/SPIRIT (i.e. Soulshard Necromantle), and others was SPIRIT/WATER (i.e. Moontide)

Personally I would start at FIRE and proceed clockwise, thus SPIRIT/WATER would be the 'correct' representation.

Like nogrip said; They are listed how they are listed in the game. Moontide and Necromantle have different attack animations. Top left affects which animation is first, (spirit in top left will have lightning bolt), the bottom right affects the delivery/impact animation, (spirit will have a purple burst at feet).

Sky Guardian and Beastmaster Battlegear are this way. They are same elements, but the elements are in a different order, so the animations are different. Sky guardian is a lightning bolt with a lightning bolt with a wind gust, beastmaster is a spirit flare with a tornado.

gnolaum
10-09-2013, 06:58 PM
That may be, and I may be in the minority; but when I search the datasheet I'm not interested in the attack animation. I'm looking at stats and elements. When I want a X/Y armor, I don't want to have to remember to also search for Y/X.

But that's just me, do what you want.

NoGrip61
10-10-2013, 09:53 AM
That may be, and I may be in the minority; but when I search the datasheet I'm not interested in the attack animation. I'm looking at stats and elements. When I want a X/Y armor, I don't want to have to remember to also search for Y/X.

But that's just me, do what you want.

I agree, it is annoying, but it is what it is, and it's accurate to the game. You can sort the columns by element, which makes things easier.

Tvidgmfrks
10-10-2013, 06:09 PM
May I just say I love the data sheet! However, I believe we need an update on the fusable items, especially as I see that as the most useful trait of the sheet. I did not see a fuseable yes/no on the submission form, we should add that if possible. I've seen many new fuseable armors that are just old boss armors such as chitinous, ethereal, and a few others. Also as none of the epics are fuseable maybe we can get rid of those. I know we all appreciate the tireless efforts of those keeping up with the new info and I am very grateful for it! Thank you.

Zyntree
10-10-2013, 06:19 PM
That may be, and I may be in the minority; but when I search the datasheet I'm not interested in the attack animation. I'm looking at stats and elements. When I want a X/Y armor, I don't want to have to remember to also search for Y/X.

But that's just me, do what you want.

I found it frustrating too, when trying to only look at elements of a certain combination, and it would leave some out because the elements appeared in different orders. There is a search column all the way to the right on the spreadsheet, and I believe it works when sorting armors by element, regardless of element order.

Hope this helps

ramuara
10-11-2013, 01:03 PM
May I just say I love the data sheet! However, I believe we need an update on the fusable items, especially as I see that as the most useful trait of the sheet. I did not see a fuseable yes/no on the submission form, we should add that if possible. I've seen many new fuseable armors that are just old boss armors such as chitinous, ethereal, and a few others. Also as none of the epics are fuseable maybe we can get rid of those. I know we all appreciate the tireless efforts of those keeping up with the new info and I am very grateful for it! Thank you.

I added can be fused to the form. I'll purge the old values and if someone submits a new list I can update it.

Tvidgmfrks
10-12-2013, 09:05 AM
I added can be fused to the form. I'll purge the old values and if someone submits a new list I can update it.

CONFIRMED Fusion Results:

Admiral's Battleworn Regalia
Armor of the Infernal Lord
Barbarian Raiding Gear
Battlesuit Remnants
Blackfrost Raiment
Boilerplate Armor
Bone Harvester's Garb
Chitinous Armor
Clayplate Mantle
Cloud King's Finery
Combustion Armor
Deep Dragon Mail
Eldritch Keeper's Robes
Ethereal Garment
Flamehunter's Garb
Flame Summoner's Shroud
Guardian's Battlegear
Half-Dragon Warrior's Armor
Horrible Wurm Costume
Hunter's Garb
Hydromancer's Mantle
Jackalope's Chaingarb
Mantle of the Beast
Moontide Platemail
Mountainvine Shroud
Pyromancer's Mantle
Rocfeather Robes
Ruby Plate Mail
Sky Guardian
Spectral Captain's Uniform
StarSong Shroud
Steam Wizard's Robes
Storm Sorcerer
Swamp Shaman
Tempered Battlegear
Tortoiseshell Aegis
Wanderer's Shroud

Unconfirmed:

Jian's Battlegear
All Epic Boss Armors after Wandering Flame

Aegis of the Dragon
Black Kaleidoscopic Raiment
Dark Prince's Royal Armor
Dragon Tamer's Costume
Starmetal Kaleidoscopic Raiment
Steam Powered Exo Skeleton
Wicked Wraith

Aegis of Sky Majesty
Beastmaster's Battlegear
Blazeborn Vanguard
Maelstrom Irons
Tectonic Mantle


Here's a list majestic zero posted on the fusing armor restults thread, hope this helps! And thank you!

ramuara
10-13-2013, 10:00 AM
Here's a list majestic zero posted on the fusing armor restults thread, hope this helps! And thank you!

I filled in all the confirmed ones. Thanks for finding me the list!

StMichael
10-14-2013, 02:29 AM
The info for the Ravenlord non-plus armour appears to be wrong. The data is way off for a 4-star, and is too wide a gap with its plus version.

NoGrip61
10-14-2013, 04:53 AM
http://i48.photobucket.com/albums/f214/SSjetta/Random/Gree_Knights_ArmorCount_20131016.png
I just made this from the epic boss history tab.


Ravenlord's Mantle + is correct, but the regular appears to be the base stats, not max.

ramuara
10-14-2013, 02:50 PM
The info for the Ravenlord non-plus armour appears to be wrong. The data is way off for a 4-star, and is too wide a gap with its plus version.

Filled in from wiki now that it's bee updated there, I guess I should have left it blank when it was unknown to make it less confusing.

BUBER
10-20-2013, 02:47 PM
Hi everyone! I just wanna ask, who created the Building Production tab in these spreadsheets? I'm planning to make a Gold Income Calculator and to make it accurate, I need to ask a bunch of questions to the creator of this tab. I'm asking anyone who could point to me that person. If you're that person, however, please respond. Thanks in advance! :D

Hi Barbanium. I think it was Jello (http://www.funzio.com/forum/member.php?110307-Jello), however some values changed when the Monster Nest was updated. Also some have pointed out that gold production when you are INSIDE GAME and NOT are different.

BUBER.

BUBER
10-20-2013, 02:52 PM
Beringar's Nemesis (Regular)
A 286, increase 8 MAX: 678
D 246, increase 7 MAX: 589

BUBER.

BUBER
10-20-2013, 02:57 PM
Scorchstone Aegis+ (Plus)
A 417, increase 9 MAX: 1038
D 502, increase 14 MAX: 1468

The Base Defense in the spreadsheet is erroneously listed as 402.


BUBER.

ramuara
10-20-2013, 08:36 PM
Scorchstone Aegis+ (Plus)
A 417, increase 9 MAX: 1038
D 502, increase 14 MAX: 1468

The Base Defense in the spreadsheet is erroneously listed as 402.


BUBER.

Thanks, both updated

Sakino
10-22-2013, 01:12 PM
Epic armors, when used as fodders, give out 180 eps if matching, 150 if not. They can give off legendaries (and in my opinion surely) if fused togheter. I fused beastmaster battlegear 94 and blazeborne 85 and got maxed admiral regalia. Is so easy to get things on droid...

Justice711
10-22-2013, 07:11 PM
Thanks for updating the spreadsheet

Marco_
10-28-2013, 03:16 AM
Hmm, with Witch's Robes non-plus combined stats being 1897, stat inflation is getting us very close to the point where all of the "bigger four" become obsolete and the route becomes: big four -> boss non-plus -> boss+...

Sakino
10-28-2013, 06:00 AM
Hmm, with Witch's Robes non-plus combined stats being 1897, stat inflation is getting us very close to the point where all of the "bigger four" become obsolete and the route becomes: big four -> boss non-plus -> boss+...
This is a sort of good thing, to eat slowly the difference between the epics.
A sort of table of strenght of the armors
Basics
Uncommons
Volcanic mantle. I dont want to put this armor above, cause is sort of junk...
One star
Fuseable two stars
Two star plus
One star plus(this looks strange, but big four is better than chest plus armors like forgemaster garb....)
Craftable Three stars
Oldest boss armors
Oldest boss armors plus
Old boss armors
Craftable Three stars plus
Recent boss armors
Chest three stars
Old chest legendaries
Chest three stars plus
Old chest legendaries plus
Old boss armors plus
Chest legendaries
Chest legendaries plus
Recent boss armors plus
Moontide, blazeborne and cloudrange
Old epics plus and regular epics
Epics plus

Newsmurf
12-12-2013, 05:00 PM
bumpity bump bump mcbump

shush
12-13-2013, 03:50 AM
Hmm, with Witch's Robes non-plus combined stats being 1897, stat inflation is getting us very close to the point where all of the "bigger four" become obsolete and the route becomes: big four -> boss non-plus -> boss+...

That is true and sad. Both armors cost the same to max, just IMHO the story armors are much harder to get by than the EB non Plus armors. (That stupid evil jewels took forever to get enough to craft 2 armors)

I always asked myself why non of those other 1 - 3 gold star armors are worth anything. They have such nice design and look really cool. But are not usable because of the bad stats.

EljayK
12-13-2013, 07:06 AM
Hmm, with Witch's Robes non-plus combined stats being 1897, stat inflation is getting us very close to the point where all of the "bigger four" become obsolete and the route becomes: big four -> boss non-plus -> boss+...

It goes further than that actually. Look at the stats of a non-plus boss armor at level 50. They're almost better than the big four. Take less work too. Don't have to increase to a certain level then increase again, and it can go 20 levels higher. Is it worth the time and energy to get a boss air/water? Probably not. But is it worth the time and energy to get a boss wind/spirit non-plus up to 50? More than likely yes. That armor at level 50 will see you smashing through sunken carack.

I am starting to see no difference in going: Some big4 > non-plus boss > Boss+ > Fuse epics

Oxilated
01-02-2014, 12:12 AM
Sorry for reviving this thread, but is anyone still updating this spreadsheet. i would like to see the armor by elements tab be updated

vesture of the frost is missing in the list

in fact, i would like to see all of the tab updated

ramuara
01-25-2014, 11:50 AM
Sorry for reviving this thread, but is anyone still updating this spreadsheet. i would like to see the armor by elements tab be updated

vesture of the frost is missing in the list

in fact, i would like to see all of the tab updated

Sorry I've been only updating the main spreadsheet as that's the one I use and I don't have lots of extra time to throw at it. If someone wants to help out with other parts send me a pm and I'll try to add them as a maintainer.

rgu
11-27-2014, 01:24 AM
Amazing Job!!!!