Jewnior wrote:Great tool, thank you for this!
Question about the Gold/Gem Ratio Calculator part:
How do I figure out what this would be? For some reason, I am having difficulty with this part of it.
Is the Gold/Gem Ratio Calculator on the left different from the Gold/Gem field where it tells you your craft time?
Hey thx for using my sheet.
Gold/Gem Ratio Calculator part is not related to other cells. Since gold/gem ratio is important to calculate real output and it fluctuate a lot with tradehouse situation, I added it to calculate the ratio quickly. I think there is no fixed gold/gem ratio in this game, because some people use iron keys to exchange gold to gems, some people use leather keys to exchange gems to gold. Some people like me who need massive amount of gems feel the ratio is about 1M:1gem, but some people who craft precrafts to earn gold might feel much less than that like 400k:1gem or 500k:1gems. And it'll affect the expected income significantly, especially when you craft and sell precrafts for gems or you buy precrafts for gems to craft high level items.
You can use the calculator on the left side to estimate what ratio you can use, and put it down on the cell next to craft time things to calculate the expected income. It's not something a sheet can automatically calculate.