TOPIC: Trade Good Yields Spreadsheet

Thought I'd share this since I put the time into it.

Please confirm/check my numbers before relying on them for purchasing decisions.

2021: jeff321.com/files/Trade_Good_Yields_2021.xlsx (updated 10/19/2020)
2020: jeff321.com/files/Trade_Good_Yields_2020.xlsx (updated 10/17/2019)
2019: jeff321.com/files/Trade_Good_Yields_2019.xlsx
2018: jeff321.com/files/Trade_Good_Yields_2018.xlsx

Jeff321 wrote: Thought I'd share this since I put the time into it.

Can anyone confirm/check my numbers?

Attachment not found

Could also share my spreadsheet if there is any interest.

This looks like a great spreadsheet is there anywhere here where it is explained how to read all the information contained?
Sorry still getting the hand of this TD thing.

The two important columns are the "$1k Order - Condensed - C/UC/R" and "$1k Order - Uncondensed - C/UC/R".

Basically the numbers below that are, if you get that order from TD, and transmute everything, how many trade goods you will end up with on average.

And then the $8k section is simply those numbers multiplied by 8.

I uploaded the full Excel spreadsheet, here's the link: jeff321.com/files/Trade_Good_Yields_2018.xlsx

Jeff321 wrote: The two important columns are the "$1k Order - Condensed - C/UC/R" and "$1k Order - Uncondensed - C/UC/R".

Basically the numbers below that are, if you get that order from TD, and transmute everything, how many trade goods you will end up with on average.

And then the $8k section is simply those numbers multiplied by 8.

I uploaded the full Excel spreadsheet, here's the link: jeff321.com/files/Trade_Good_Yields_2018.xlsx

This is great! Thanks so much for doing this.

Interesting...

So... if I read that correctly, go condensed if you care more about:

• Alchemist Parchment [large difference]
• Dwarven Steel [average difference]
• Enchanter's Munition [large difference]
• Mystic Silk [small difference]

Go uncondensed if you care more about:

• Alchemist Ink [huge difference]
• Philosopher's Stone [average difference]
• Darkwood Plank [minor difference]
• Minotaur Hide [minor difference]

Looking at $ values, condensed looks like it may have a very slight edge. But that's highly dependent on the $ values you happen to pick.

Fiddy wrote: Alchemist Ink [huge difference]

I was surprised by that one. Overall Condensed seems worth it though.

I will likely do my standard 1k condensed and 1k not condensed.

I think the ink difference is because you get Potion of Distilled Healing in the condensed pack.

Kirk Bauer wrote: I think the ink difference is because you get Potion of Distilled Healing in the condensed pack.

That is a good point, if you made all your Potion Bliss Mead (common) into Distilled Healing you would only get 0.84 Ink from commons instead of the 1 you get from the condensed pack.

Condensed has no extra work for trade good benefit also, so there is that to consider.

Thanks for the clarification I’ll check out the full spreadsheet when I get home from Gamehole

Updated. Check my numbers please.

2019: jeff321.com/files/Trade_Good_Yields_2019.xlsx
2018: jeff321.com/files/Trade_Good_Yields_2018.xlsx

$1k order (120 packs) uncondensed

Trade Good	2018	2019
Alchemist's Ink	4.56	6.84
Alchemist's Parchment	6.84	6.84
Aragonite	1.2	1.2
Darkwood Plank	18.72	15
Dwarven Steel	6.72	7.56
Elven Bismuth	1.44	1.44
Enchanter's Munition	2.28	2.28
Minotaur Hide	5.04	5.04
Mystic Silk	17.64	15.24
Oil of Enchantment	1.44	1.44
Philosopher's Stone	9.12	12.12
1,000 GP Gold Bar	5.4	5.4