[X] My Assistant

Hello everyone.

I have made some excel-based calculation to find best arena in a game.
The results you can find [docs.google.com] here. Available 4 sheets: all arenas, only page one arenas, only page two arenas, only "non-schoolgirls" arena.

Calculation are next (top five in every section)
By monsters per round (how many monsters you will kill in one round, the higher - the better):

1. Dreamfall - 5.95
2. Exile - 5.938
3. To Kill A God - 5.937
4. Longest Journey - 5.072
5. Dark Skies - 5.066 or Eve of Death - 5.044

By experience per time (how much experience you would take in less time with minimum tiredness and difficulty, the higher - the better):

1. Eve of Death - 1.82685183
2. To Kill A God - 1.748097485
3. The Trio and the Tree - 1.616103429
4. New Wings - 1.484920978
5. Sealed Power - 1.426613697

By average drop (how many drops you will receive in this arena (lets take 20% as rate of drop), the higher - the better):

1. A Dance With Dragons - 144.8
2. The Trio and the Tree - 99.6
3. To Kill A God - 95
4. End of Days - 94.6
5. Eve of Death - 90.8

By drop per stamina (how many drops you will receive in this arena (lets take 20% as rate of drop) based on spent stamina, the higher - the better):

1. Dreamfall - 59.5
2. Exile - 59.38
3. To Kill A God - 59.37
4. Longest Journey - 50.72
5. Dark Skies - 50.66 or Eve of Death - 50.44

Absolute score (best arena at all, based on different parameters):

1. To Kill A God - 1829 points
2. Exile - 1330 points
3. Dreamfall - 1232 points
4. Eve of Death - 1172 points
5. The Trio and the Tree - 997 points

For low-level player, that didn't open page two arenas and only play page one, best arena is:

1. Dark Skies - 650 points
2. Growing Storm - 646 points
3. Power Flux - 643 points
4. Killzone - 641 points
5. Fresh Meat - 640 points

How this calculation worked?

• Column A - This is a name of arena. Pretty simply and self-explanatory.
• Column B - How many rounds we have got in arena
• Column C - This is experience modificator or else how many experience you have got in this stage (diverse from x1.0 to x3.0)
• Column D - [hidden column] How many normal monsters we have got in this arena
• Column E - [hidden column] How many bosses-monsters we have got in this arena
• Column F - [hidden column] How many schoolgirls-monsters we have got in this arena in non-final rounds
• Column G - [hidden column] How many schoolgirls-monsters we have got in this arena in final round
• Column H - [hidden column] How many god-monsters we have got in this arena in final round (Tenboro's dragons counts as gods, okay?)
• Column I - How many monster total we have got in arena (Column D + Column E + Column F + Column G + Column H)
• Column J - How many monsters per round we have. The higher this value - the more monster (in average) we have in a round. The higher this value is better. (Column I / Column B)
• Column K - How many stamina per battle we spent. The lower this value is better. I have used a 50 round = 1 stamina, because do two different calculation for great and normal stamina is useless... (Column B / 50)
• Column L - This is odd one, so listen careful. We all know that 1 stamina last 50 rounds no matter how many monsters each round have. So, 50 rounds that have only 1 monsters and 50 rounds each have 10 monster are both require one stamina, but second case is way better because it is more drops and experience. This column is my attempt to utilize this logic. Not know is this better way to do this, but it is better then nothing... Higher the value - is better (Column I * (Column J / Column K))*0.01)
• Column M - How many experience you have got. Literally we just take how many monsters we have got in arena, multiply to experience modificator. The higher results we have got is better (Column I * Column C)
• Column N - How much time we need to beat this arena. This is noway a real seconds/minutes but some kind of markers. To beat normal monster we need "1 point", to kill boss "3 points", to kill schoolgirl "10 points", to kill god "25 points". Lets just calculate it all (Column D * 1 + Column E * 3 + Column F2 * 8 + Column G2 * 8 + Column H2 * 15)
• Column O - This is a column, that calculate difficulty (or should I monotonous) of arena? Concept is like that: the more simply battle we have - the battle will be our time to beat arena, but we need more monsters per one round to increase our exp and loot income and decrease time consumption. In this column counts difficulty of arena to beat in short time, based on average difficulty of each round divide on numbers of rounds, compare to average monsters per round. If we have "1" in result - this mean that this arena have only light monsters and noway hard or time consuming, the more below 1 point - the harder this arena is. We use coefficient in column P formula (Column J / ((Column T + Column U + Column V + Column W + Column X + Column Y + Column Z + Column AA + Column AB + Column AC) / Column B))
• Column P - This is experience per time with taken in account tiredness and difficulty of arenas. The idea is simply - we want to spend less time with maximum experience outcome without any hard play, yeah? It is very odd column and I don't thing it present real status well. Any ideas here? (Column M / Column N * O2 )
• Column Q - This how many drops we have in this arenas. We want more drops, yes? More drops happens when we have got more enemies here. I guess the better solution here is just take total monster amount and multiply to 20%. This is luck-based column after all, not quality based. (Column I * 0.2)
• Column R - This how many drops we have in this arenas based on depleted stamina. We want many drops, but we want to lose as many stamina as we can! (Column P / Column K)
• Column S - The main column of table - this is where everything happens together - all values we have got from past calculation merged here in grand result, or just Column L * Column O * Column Q
• Column T - Column AC - [hidden column] Special column, used only in calculation in Column O. Represent "difficulty" of each arena, by using monster per round mechanic.

Suggestion, anyone?

P.S. Based on THIS idea, but adapted to HV0.83 and more complicated.

This post has been edited by f4tal: Mar 11 2016, 21:08

I dont like absolute score for this one. Better rate them in income/time (income/round) , income/stmina and exp/time exp/stamina etc
There is a script to do it also, general advise only do the second page non sg arenas for the best efficiency.

I dont like absolute score for this one. Better rate them in income/time (income/round) , income/stmina and exp/time exp/stamina etc

In a table sheet I have columns specially for this, but, sure no problem, I put other grates right now in first post for everyone's convenience.
UPD: Done ^^

general advise only do the second page non sg arenas for the best efficiency.

As I can see top five arena in every category are from second page. There are only two exception and I placed alternative arena by the "|" symbol.

In a excel sheet I made a second page where only second page arenas are present.

Is it comfortable?

// by the way anyone can sort a table in anyway they would like.


This post has been edited by f4tal: Feb 29 2016, 15:07

i'd refer to rounds rather than time. time is dependant by many factors (ping, latency, last mile...) while turns are absolute.

i'd refer to rounds rather than time. time is dependant by many factors (ping, latency, last mile...) while turns are absolute.

As said above "time" in my table are not minute or seconds, - it is more like points... Rounds... I thought about it and come with this idea:
We have three arenas. One is 50 rounds, with only one monster in every (Total: 50 mobs). Second is 50 rounds, but with 10 monsters in every round (total 500 mobs). Third is 50 rounds with 10 schoolgirls (total 500 schoolgirls). Which arena you can finish faster? Every one have 50 rounds, but I guess first arena is fastest to beat and last one is hardest and longest.
So, amount of rounds is not good way to calculate time either, - we have equal amount of rounds, but they take different time to beat. =(

// I like google sense of humor - every time someone anonymous come to visit my excel sheet, system describe them as "anonymous cat", "anonymous badger", "anonymous coyote", e.t.c. ^^

This post has been edited by f4tal: Feb 29 2016, 15:23

I have always known that "To Kill a God" was the hardest (not longest) arena (high number of monsters average per round -> more buff to recast -> more cures -> ecc)...and now I see the motivation too (IMG:[invalid] style_emoticons/default/biggrin.gif)

I have always known that "To Kill a God"

This is first arena I am playing every day ^.^

Yes, it is long to beat (not so long as last three... >_>), but many monsters in one round (third place in rating), good exp bonus (x1.8) and occasionally many exp in short time (second place), it is all mean many drops per time (third place) and all this for only 1,6 stamina! (regenerate in hour and half).
To Kill a God is the only arena that present in all TOP 5 categories (Beside Eve of Death, in some manner...)

Yeah, this is greatest arena in game so far. And it is the only arena from second page I am playing on PFUDOR difficulty every day =)

This post has been edited by f4tal: Feb 29 2016, 17:30

I have always known that "To Kill a God" was the hardest (not longest) arena (high number of monsters average per round -> more buff to recast -> more cures -> ecc)...and now I see the motivation too (IMG:[invalid] style_emoticons/default/biggrin.gif)

A dance with dragons wants to have a word with you (IMG:[invalid] style_emoticons/default/heh.gif)

Also:
This is noway a real seconds/minutes but some kind of markers. To beat normal monster we need "1 point", to kill boss "3 points", to kill schoolgirl "10 points", to kill god "25 points". Lets just calculate it all (Column D * 1 + Column E * 3 + Column F2 * 10 + Column G2 * 10 + Column H2 * 25)
Even if it's just a guess I would add the number of rounds to the equation.

Also I would put SG at 8 and God at 15.

It would still be a single target melee metric (splash damage make the assumptions two monsters -> double time wrong, so 2H and mage cannot be calculated in that way) but a bit more correct.

My findings are that the final 6 arenas clear times for 1H should be something like:

To Kill A God: 100
Eve of Death: 102
The Trio and the Tree: 115
End of Days: 166
Eternal Darkness: 254
A Dance With Dragons: 398

A dance with dragons wants to have a word with you (IMG:[invalid] style_emoticons/default/heh.gif)

Seen videos of that.
Cleared all under 300 arenas in IWBTH/PFUDOR.
The last 3 arenas are only LONG.
Even if you count the last rounds with high numbers of monsters...about 2/3 of the arena are easy rounds with very few monsters.
Bosses (I leave out the fact that these are SCHOOLGIRLS, weak as hell) ? Spirit Shield says hi. Until five monsters you can go without Spark even without looking at the health bar.

To Kill A God: 100
Eve of Death: 102
The Trio and the Tree: 115

Also, I have to disagree with these 3 times.
I clear Eve of Death and The Trio and the Tree in about 4/5 of the time of To Kill a God...

This post has been edited by ppp82p: Feb 29 2016, 18:53

Seen videos of that.
Cleared all under 300 arenas in IWBTH/PFUDOR.
The last 3 arenas are only LONG.
Even if you count the last rounds with high numbers of monsters...about 2/3 of the arena are easy rounds with very few monsters.
Bosses (I leave out the fact that these are SCHOOLGIRLS, weak as hell) ? Spirit Shield says hi. Until five monsters you can go without Spark even without looking at the health bar.

Well, 37 hard rounds (DwD) are still significantly more than 0 hard rounds (TkaG).

Also, I have to disagree with these 3 times.
I clear Eve of Death and The Trio and the Tree in about 4/5 of the time of To Kill a God...

So you're faster in clearing an arena with more monsters and more rounds? (let's disregard the fact that you're not using 1H so it's pretty normal that our times are not directly comparable)
That sounds pretty strange.

A dance with dragons wants to have a word with you heh.gif

He is level 294 for now. 6 level after destiny will meet him ^^
And DwD is really not so hard, - it is just annoying - you need to kill ~250 lame and weak schoolgirls to meet this three dragons. Just take so much time >_> Beat it on Nintendo, by the way, not because IWBTH is hard, but because it takes SO LONG. I think I need to find better equipment with better damage output to increase my time.

Also I would put SG at 8 and God at 15.

Agreed. Fixed it. Gods are not so hard. Triple Trio in time-wise are alike 7-8 schoolgirls. So, I think your coefficient is better than my =)

Even if it's just a guess I would add the number of rounds to the equation.

Have a clue to exact formula? I think about different variants and all their not worthy/not logic/absurd. Add a rounds in formula sounds nice, but where exactly I should do it?

To Kill A God: 100
Eve of Death: 102
The Trio and the Tree: 115

I have never counting exactly how to long to beat this three boards, but I guess they all require dame time +/- minute/half. But it all depends on build, on luck and other parameters, so we can only talk about average time...

This post has been edited by f4tal: Feb 29 2016, 19:22

Have a clue to exact formula? I think about different variants and all their not worthy/not logic/absurd. Add a rounds in formula sounds nice, but where exactly I should do it?

It's very difficult.
The best way is probably to first decide the base time needed to clear a round with 1,2,3 ecc ecc monsters.
For example I know that on average in 1 minute I can clear:
16 rounds with 3 monsters
13-14 rounds with 4 monsters
11-12 rounds with 5 monsters
and so on

Then you can add all the rounds together and the final time should be quite a good approximation.
Unfortunately this is not easy to calculate from your excel file.

I have never counting exactly how to long to beat this three boards, but I guess they all require dame time +/- minute/half. But it all depends on build, on luck and other parameters, so we can only talk about average time...

I have started recording all my runs time since november or december.
I calculated those values based on my current best times.
Sure, there is a bit of variance, but is much lower that what you may think (in particular in SG arenas).
For example my best times in DwD are 28:11, 28:12, 28:13, 28:13.

And DwD is really not so hard, - it is just annoying - you need to kill ~250 lame and weak schoolgirls to meet this three dragons. Just take so much time >_> Beat it on Nintendo, by the way, not because IWBTH is hard, but because it takes SO LONG. I think I need to find better equipment with better damage output to increase my time.

Problem is, with 1H if you want to clear the later rounds faster you have to target the SGs first (just leaving the SGs will limit your counter-attacks), and 50+ consecutive rounds with 9 monsters can be brutal if your level is low (~300).

I think I need to find better equipment with better damage output to increase my time.

Hi, f4tal.
I saw your 1.x TPS.
SPEED KILLS EVERYTHING (IMG:[invalid] style_emoticons/default/cry.gif)

Loot_Drop_Rolls
three highest arenas get an additional +1 tier at IWBTH/PFUDOR. Dances with Dragons on PFUDOR is T8.
SG Trophies and DwD clear bonus are GOOD.
SG arenas are best.

You need holy/dark rapier and infusion.

This post has been edited by hansvar92: Mar 1 2016, 04:55

Hi, f4tal.
I saw your 1.x TPS.

It was before I have start to use Iron Browser. With Iron I have got 3-4 t/s (4 is cap I guess)

three highest arenas get an additional +1 tier at IWBTH/PFUDOR. Dances with Dragons on PFUDOR is T8.
SG Trophies and DwD clear bonus are GOOD.
SG arenas are best.

I agree. Really I like about final three arenas is drop of trophies. After beating, I have so many of them, so that my luck to get great equip is boosted. One time from Broken Glasses I have salvaged Leg Savage heavy gauntlets (?) of protection ^^

if your level is low (~300).

And thats a point: I am only 305 with 2 EXQ, 3 MAG and 2 LEG equips. So, it is a bit earlier for me to play this arenas on PFUDOR, Need a wait for better opportunity.

16 rounds with 3 monsters
13-14 rounds with 4 monsters
11-12 rounds with 5 monsters

You gave me really nice idea how can I enhance table and put rounds in calculation!
Will do it right now =P

UPD: Made it!
I have added special column, which calculate tedious/difficulty of each arena, based on rounds-system (Arena is great if have only regular mobs in each round, without bosses or schoolgirls), and then fixed formula to calculate "experience per time". Before this addition we have this situation:

1. Eve of Death
2. New Wings
3. To Kill A God
4. The Trio and the Tree
5. Sealed Power

But now:

1. Eve of Death
2. To Kill A God
3. The Trio and the Tree
4. New Wings
5. Sealed Power

I guess current situation represent exp per time more accurate when I have started to use rounds in formula...

This post has been edited by f4tal: Mar 1 2016, 10:42

I made my own calculations considering exp/turn ONLY: [pastebin.com] http://pastebin.com/kR25LKS1
We can clearly see that 100, 90 and 80 turns arenas are far superior with 100t being slightly better than 90 and 80. We get a pretty serious drop from 75t arena onwards.
So yeah arenas are balanced from 100 to 55 pretty consistently with 100 giving most exp and 55 giving least.

This post has been edited by cichy133: Mar 5 2016, 13:44

I made my own calculations considering exp/turn ONLY: [pastebin.com] [pastebin.com] http://pastebin.com/kR25LKS1

Ohhh, nice thing! It is very good that you make a real calculation with real turns and real received exp. ^^
I definitely agree that 80, 90 and 100 arenas are best in entire game, because high exp modificator and easy to beat them, but which one is best one of three - hard to say exactly, because theory and practice are different things... =)