Updated goods and adventure price sheet

[Nukar]

Yesterday we released a new version.

Most important change is that we included trends.
Now it will be easy for all to see what goods changed prices and if they increased or decreased.
Since this is a new feature and we are somewhat limited by the sheets options we are currently trying to find a balance in the trends.
For this to work and stay up-to-date we need to set a baseline of current prices on a regular basis. Our current challenge is to find a balance when to baseline. We are looking at 1x per day, 1x per week or every time we update prices. A new baseline will set all trends to 0 for that moment.
Any suggestions, with a reason why, will be welcome.
(note player time is involved so 1x per hour wont be a realistic option)

Furthermore we added an other guide and some bug fixes.

In the adventure tab we can see the consequences of price changes as we see more and more adventures (guides) get profitable. So keep checking those as well.

Edit:
Also included some usefull links in the adventures tabs

[popovitsj]

Maybe I should provide an easy to understand example.

Let's say I'm offered 2 investment opportunities with the following properties. I can only choose one. Which will you choose?

Investment 1
Initial investment: 100 euro.
Time until return: 1 day
Return: 200 euro.
Return per invested euro: 2

Investment 2
Initial investment: 400 euro.
Time until return: 1 day
Return: 600 euro.
Return per invested euro: 1.5

Please note that this is exactly the kind of decision we face in TSO, because you cannot play 2 adventures at the same time.

[Nukar]

Yes this is how we work it out as wel.
you devide <profit>/<investment> = return

investment 1
200/100 = 2

investment 3
600/400 = 1.5

How is this different from what we do?
Take the top most adv in the list
losses (investment) = 2790
loot (return) = 6381
so our return per investment =
9381/2790 = 2.2870 = 2.29 rounded

So i dont see the problem you are trying to explain?

[SirRoy]

Please note that this is exactly the kind of decision we face in TSO, because you cannot play 2 adventures at the same time.

Yes you can play 2 adventures at the same time.

[Darklite93]

I've just noticed that the cost of troops for dark priests far exceeds the loot value, y?

[Darklite93]

Also could the loot value of all adventures be put in please

[Nukar]

I've just noticed that the cost of troops for dark priests far exceeds the loot value, y?

With the current prices as base the value of the losses exceeds the possible profit.

Also could the loot value of all adventures be put in please

If you look at the adventures tab you will see the average loot value per adventure in column E "Loot coins". Here you will see average loodrop value based on current prices.
If you want to see loot value per lootspot you can look at the 3rd column for the lootspot prices on the buy_sell tab.

Cheers
Nukar

[stalk]

Also could the loot value of all adventures be put in please

If you mean market value of loot spots there isn't really an established value for sons, motherly, dark brotherhood, secluded experiments as these adventures are rarely played and even more rarely sold spots for.

[Nukar]

I am sorry to inform you that google has some server issues at this moment.
If you have trouble reaching the sheets please be patient and try again after a few minutes.

Sorry for the trouble, but I'm unable to influence it at this moment.

Cheers,
Nukar

[Doomie]

The sheets have been updated to latest prices.