21 replies to this topic

[aa0007]

Definitions:

ceil(x) will round up to the nearest integer. Also called the least value function.
min(x,y) will return the lower value of the two.
max(x,y) will return the higher value of the two.

A combination of these and parentheses can be used to calculate all values.

skillLevel: the TOTAL skill level over all the pots (ie. an AL 50 and LF 60 pot has a skillLevel of 110)
duration: self explanatory 

Below I've compiled a list of all of the composing formulas available to the community/released by hoof. Enjoy.

 

Experience:

experience =(ceil(min(skillLevel,duration)/60 + skillLevel/500)*10)

Gold Cost Per Potion:

goldCost = max(skillLevel*duration, 5000)

Time to Create Potion:

timeToCreate = (max( ((ceil(max(skillLevel,150.0)/20)*5) + (ceil(duration/30)*30)) - ((composingLevel-1)*5), 60))

Cost to Create Instantly:

instantCost = ceil((1 - (percentComplete / 100)) * initialGoldCost * (2 ^ instantCompletesInLast24Hours))

Also, in case anyone is wondering, here is the best possible achievable XP per minute (roughly). The values are based on the approximation that the maximum possible skill level in a potion goes up by 150 per level, which may or may not be true as the levels progress.

[RebornJedi]

[aa0007]

 

I cleaned it up for you. Now Lehman should be able to understand it.

[tharzill]

Oh my aching head! lol But thanks aa!

[Versair]

May I ask how do you use instant gold correctly besides having the gold on hand and clicking the button? Sadly the rest of the post went over my head so I can't even comment on it.

[aa0007]

May I ask how do you use instant gold correctly besides having the gold on hand and clicking the button? Sadly the rest of the post went over my head so I can't even comment on it.

 

That's the correct way to do it, but what I mean is that you can make various potions and they'll each have some gold cost associated with them. By "correct" way I mean the order in which you do those multiple potions and what those potions actually are.

 

Edit added some definitions to the top post, hopefully they help. Feel free to google for more information, they're standard functions in programming/mathematical languages.

[Removed94]

And off to Excel I go

[Rocknoor]

I'm sorry AA...I'm standing here at the dock watching your teaser ferry steam off in the distance...I have no clue what you are trying to tell me with your teaser as it relates to additional XP and correct usage of the instant gold usage.  Is this an adddtional cost and xp gain over the base calculations.  (ie..if an AL10 pot of 30 min duration at Composing level 2 garners me 10xp for a $5000 gold cost per rendition) Using base figures and assuming I'm very good at timing in a 24 hour period (assuming 22 renderings) I can get 220 xp at a cost of $110,000 gold. What the heck is your 140xp at 250,000 gold, is it addition to the baseline I just established or are you using a different baseline for your calculations.  Without explaination of your variables your chart to me has no relevance as you establish no baseline for your calculations...enlighten me please at to why I missed the boat on this.

[2dragon911]

what does Ceil stand for?

 

[yotwehc]

what does Ceil stand for?

If I'm not mistaken, it means rounding upwards

[aa0007]

what does Ceil stand for?

 

1. ceil(x) will round up to the nearest integer. Also called the least value function.

    

[Yuuzhan]

I have created a small excel file (easier then programming a web version for now ) which include the above mentioned formulas.  This will also include Fragment cost.

 

http://evolutions.yv...osing_Calc.xlsx

[Yuuzhan]

Also looks like the leveling formula is:

 

CurrentLevel^2 * 250

(That is (currentLevel to the power of two) times 250)

to describe the amount of XP you need to get to the next level.

 

EG:

You are level 1: 1^2*250 = 1*250 = 250 XP needed to get to level 2

You are level 2: 2^2*250 = 4*250 = 1000 XP needed to get to level 3

You are level 3: 3^2*250 = 9*250 = 2250 XP needed to get to level 4

You are level 4: 4^2*250 = 16*250 = 4000 XP needed to get to level 5

You are level 5: 5^2*250 = 25*250 = 6250 XP needed to get to level 6

[yotwehc]

I have created a small excel file (easier then programming a web version for now ) which include the above mentioned formulas. This will also include Fragment cost.

http://evolutions.yv...osing_Calc.xlsx

Thanks for this awesome excel! My favorite pot to make is a duration 54 lvl 54 with 3 skills @ 18 each = 6 common but your excel keeps telling me it should be 3 common?

[Yuuzhan]

Whoops, forgot to do the Duration Multiplication.

 

Re-download it and it should be good.

[aa0007]

 

Also looks like the leveling formula is:

 

CurrentLevel^2 * 250

(That is (currentLevel to the power of two) times 250)

to describe the amount of XP you need to get to the next level.

 

EG:

You are level 1: 1^2*250 = 1*250 = 250 XP needed to get to level 2

You are level 2: 2^2*250 = 4*250 = 1000 XP needed to get to level 3

You are level 3: 3^2*250 = 9*250 = 2250 XP needed to get to level 4

You are level 4: 4^2*250 = 16*250 = 4000 XP needed to get to level 5

You are level 5: 5^2*250 = 25*250 = 6250 XP needed to get to level 6

 

Hey, that's interesting. Can also be represented as (level-1)*(500) + 250 needed - that's the difference between the two levels. 

[Savanc]

All makes perfect sense to me

 

And that was without sarcasm

[Savanc]

I have no clue what you are trying to tell me with your teaser as it relates to additional XP and correct usage of the instant gold usage.  Is this an adddtional cost and xp gain over the base calculations.  (ie..if an AL10 pot of 30 min duration at Composing level 2 garners me 10xp for a $5000 gold cost per rendition) Using base figures and assuming I'm very good at timing in a 24 hour period (assuming 22 renderings) I can get 220 xp at a cost of $110,000 gold. What the heck is your 140xp at 250,000 gold, is it addition to the baseline I just established or are you using a different baseline for your calculations.  Without explaination of your variables your chart to me has no relevance as you establish no baseline for your calculations...enlighten me please at to why I missed the boat on this.

 

He means that if you use the instant finish option in the most optimal way that you will get an X amount of XP for an Y amount of gold from that.

It has nothing to do with making potions that you will wait for to complete.

 

 

An example of (an attempt at) optimal instant finish strategies:

 

Let's take 4 different situations:

• Situation 1: you only instant finish potions of skill level 54 and duration 54.
• Situation 2: you only instant finish potions of skill level 215 and duration 215.
• Situation 3: you first instant finish potions of skill level 54 and duration 54 and then instant finish potions of skill level 215 and duration 215.
• Situation 4: you first instant finish potions of skill level 215 and duration 215 and then instant finish potions of skill level 54 and duration 54.

 

Suppose you have 1 million gold to spend.

 

A potion of 54 / 54 earns you 20 XP and takes 5,000 gold to make. This is also the cost to make the first instant finish.

A potion of 215 / 215 earns you 50 XP and takes 46,225 gold to make. This is also the cost to make the first instant finish.

 

 

Situation 1:

The first instant finish costs 5,000 gold.

The second instant finish costs 10,000 gold.

The third instant finish costs 20,000 gold.

The fourth instant finish costs 40,000 gold.

The fifth instant finish costs 80,000 gold.

The sixth instant finish costs 160,000 gold.

The seventh instant finish costs 320,000 gold.

The eighth instant finish costs 640,000 gold.

 

With 1 million gold you can instant finish 7 potions which costs you 635,000 gold and gets you 140 XP.

 

 

 

Situation 2:

The first instant finish costs 46,225 gold.

The second instant finish costs 92,450 gold.

The third instant finish costs 184,900 gold.

The fourth instant finish costs 369,800 gold.
The fourth instant finish costs 739,600 gold.

 

With 1 million gold you can instant finish 4 potions which costs you 693,375 gold and gets you 200 XP.

 

 

 

Situation 3:

The first instant finish costs 5,000 gold.

The second instant finish costs 10,000 gold. After this we switch to the 215 / 215 potion.

The third instant finish costs 184,900 gold.

The fourth instant finish costs 369,800 gold.
The fourth instant finish costs 739,600 gold.

 

With 1 million gold you can instant finish 4 potions which costs you 569,700 gold and gets you 120 XP.

 

 

 

Situation 4:

The first instant finish costs 46,225 gold.

The second instant finish costs 92,450 gold.

The third instant finish costs 184,900 gold.
The fourth instant finish costs 369,800 gold. After this we switch to the 54 / 54 potion.

The fifth instant finish costs 80,000 gold.

The sixth instant finish costs 160,000 gold.

The seventh instant finish costs 320,000 gold.

 

With 1 million gold you can instant finish 6 potions which costs you 933,375 gold and gets you 240 XP.

 

 

 

Summary:

• Situation 1: 7 potions; 635,000 gold; 140 XP.
• Situation 2: 4 potions; 693,375 gold; 200 XP.
• Situation 3: 4 potions; 569,700 gold; 120 XP.
• Situation 4: 6 potions; 933,375 gold; 240 XP.

 

The 4th situation earns us the most XP. And considering we were looking to spend 1 million gold to get as much XP as possible it is the winner here.

Between situation 1 and 2 I would definitely go for 2; it is only slightly more expensive and earns us a lot more XP.

As we can see situation 3 (although slightly the cheapest) earns us the least XP, and is probably not preferred.: situation 2 earns us much more XP. You could even go for situation 2 and not make the last potion. This will be cheaper and give you more XP than situation 3 would.

 

aa0007 came up with a list that shows us that 250 XP can be reached with 1 million gold.

I have only used 2 potions here to keep it simple. And I came pretty close (240 XP).

There is a wide arsenal of potion skill levels and durations that are available and there are no doubt better combinations of potions that will get you to 250 XP for 1 million gold (or less).

 

 

 

General rules of thumb iIf you want to spend a certain amount of gold and want the most XP out of instant finish:

• Do not stick with 1 potion all the time.
• Big potions first; smaller potions last.

[Versair]

Savanc's post makes more sense to me (but not complete sense sadly). I think I have a better idea of what is being said now, but what exactly do you mean when you say something like "54 / 54" are you talking about total skill levels with a duration of 54 minutes? Like 18-18-18? Or just simply 1 skill at 54 with a duration of 54? And I don't even know how that works if you are able to use 4 skills or 5 because then do you try to make the levels close to even or what?

 

Moral of the story is that I'm probably leveling in a very inefficient way.

[Savanc]

what exactly do you mean when you say something like "54 / 54" are you talking about total skill levels with a duration of 54 minutes? Like 18-18-18? Or just simply 1 skill at 54 with a duration of 54?

 

With 54 / 54 I mean a potion with a total skill level of 54 and a duration of 54.

How you come to that total skill level is less important.

 

It can be 1 skill at level 54, or 2 skills at 27, or 1 skill at 40 and 1 skill at 14, or 3 skills at 18, etc.

Most of the times I try to have my skills to be at level 40 because level 20 and 40 are the cheapest when it comes to fragments (only 1 or 2 common fragments, and no rare fragments).

 

For example, suppose I make a 54 / 54 potion in the various manners I just mentioned.

1. 1 skill at level 54 would take 3 common fragments and 1 rare (the duration would double that).
2. 2 skills at 27 would take 4 common fragments.
3. 1 skill at 40 and 1 skill at 14 would take 3 fragments.
4. 3 skills at 18 would take 3 fragments.

Obviously option 3 and 4 are the cheapest in fragments while still being a 54 / 54 potion.

 

 

 

 

Moral of the story is that I'm probably leveling in a very inefficient way.

 

Most ways are fairly efficient. Some are just a little bit more efficient (by just a few percent).