I'm developing a tool with excel, but I don't know how to calculate the resource % in exchanges.
I sell 1.000.000 deut and I buy 40% met & 60%cry. If the exchange rates are 2,5:1,5:1 we have:
1kk deut for 714.286 met and 1.071.429 cry.
As you can see, 40% does not mean 0,4*1000. It's the 40% of the total: [714.286 : 1.071.429 = 40 : 60]
I don't know how to calculate this, is there someone who can help me?