A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | NOTE: if you do not understand anything in this spreadsheet there are definitions below, just scroll down and read, everything you need to know about gardening is in this sheet | |||||||||||||||||||||||||
2 | ||||||||||||||||||||||||||
3 | Life Span (days) | Initial Water Lv. | Water Lv. After Harvest | Days before Harvesting | Harvest Yield | Cost to Make 1 Flower Seed (flux) | Crop Price Per Unit | Average Yield Revenue (flux) | Number of Harvests (Basic) | Number of Harvests (Golden 1st) | Total Profit (Everlasting) | Total Profit (Golden 9) | Profit per Moonlight Bulb | Theoretical Market Price of Seed | % Return on Investment | Notes | ||||||||||
4 | Qubbage | 7 | 2 | 1 | 1 | 1 | 1590 | 820 | 820 | 6 | 7 | 3330.0 | 3427.8 | N/A | 5017.8 | 215.6 | All of the prices for vegtables varry a lot, I wouldn't reccomend relying on the prices listed here | |||||||||
5 | Unicorn Chard | 7 | 2 | N/A | 1 | 5-7 | 10000 | 170 | 1020 | 1 | 1 | -8980.0 | -9702.2 | N/A | 1020.0 | -89.8 | ||||||||||
6 | Uggplant | 10 | 3 | 1 | 1 | 3 | 9960 | 139 | 417 | 8 | 10 | -6624.0 | -6512.2 | N/A | 3447.8 | -65.4 | ||||||||||
7 | Purp'lil | 10 | 4 | 2 | 1 | 31 | 6460 | 30 | 930 | 3 | 5 | -3670.0 | -2532.2 | N/A | 3927.8 | -39.2 | ||||||||||
8 | Onionito | 10 | 3 | N/A | 1 | 2-3 | 4560 | 300 | 750 | 1 | 1 | -3810.0 | -4532.2 | N/A | 750.0 | -83.6 | ||||||||||
9 | Totter Tate | 14 | 4 | N/A | 1 | 2-3 | 12900 | 810 | 2025 | 1 | 1 | -10875.0 | -11597.2 | N/A | 2025.0 | -84.3 | ||||||||||
10 | Qumato | 14 | 3 | 1 | 1 | 6-9 | 2040 | 48 | 360 | 12 | 14 | 2280.0 | 2277.8 | N/A | 4320.0 | 111.8 | ||||||||||
11 | Cinnamellon | 14 | 3 | 2 | 1 | 2 | 3670 | 200 | 400 | 6 | 7 | -1270.0 | -1592.2 | N/A | 2400.0 | -34.6 | ||||||||||
12 | Bunfeed | 21 | 5 | N/A | 1 | 3-5 | 3510 | 770 | 3080 | 1 | 1 | -430.0 | -1152.2 | N/A | 3080.0 | -12.3 | ||||||||||
13 | Corn on the Cube | 21 | 4 | 3 | 1 | 1-2 | 2950 | 850 | 1275 | 6 | 7 | 4700.0 | 5252.8 | N/A | 8202.8 | 178.1 | ||||||||||
14 | /// Alchemy Seeds | Note: You can harvest a crop on the day it would wither, before it actually withers. It is possible to lose a harvest if you don't harvest a crop before it withers, keep that in mind! | ||||||||||||||||||||||||
15 | Shapestone | 15 | 1 | 1 | 3 | 400 | 42585 | 25 | 10000 | 5 | 5 | 7415.0 | 6692.8 | 6692.8 | 50000.0 | 17.4 | ||||||||||
16 | Formicite | 15 | 1 | 1 | 3 | 350 | 43200 | 28 | 9800 | 5 | 5 | 5800.0 | 5077.8 | 5077.8 | 49000.0 | 13.4 | ||||||||||
17 | Infinium | 15 | 1 | 1 | 3 | 425 | 45050 | 23 | 9775 | 5 | 5 | 3825.0 | 3102.8 | 3102.8 | 48875.0 | 8.5 | ||||||||||
18 | Cinnabar | 15 | 3 | 1 | 3 | 70 | 45600 | 38 | 2660 | 4 | 5 | -34960.0 | -33022.2 | -33022.2 | 12577.8 | -72.4 | ||||||||||
19 | Crystal | 15 | 3 | 1 | 3 | 100 | 34250 | N/A | N/A | 4 | 5 | N/A | N/A | N/A | N/A | N/A | ||||||||||
20 | Eye of Q'bthulhu | 15 | 3 | 1 | 3 | 750 | 18500 | 18 | 13500 | 4 | 5 | 35500.0 | 48277.8 | 24138.9 | 66777.8 | 261.0 | These two crops' %s are so high because the cost of the | |||||||||
21 | Gleamstone | 15 | 3 | 1 | 3 | 500 | 7900 | 23 | 11500 | 4 | 5 | 38100.0 | 48877.8 | 24438.9 | 56777.8 | 618.7 | crystals to make them isnt factored in, as crystals are not tradable | |||||||||
22 | Fishing Lure | 15 | 3 | 1 | 3 | 150 | 52350 | 28 | 4200 | 4 | 5 | -35550.0 | -32072.2 | -16036.1 | 20277.8 | -61.3 | Lures can be looted for glim | |||||||||
23 | Day Drop | 15 | 3 | 1 | 3 | 750 | 32225 | 45 | 33750 | 4 | 5 | 102775.0 | 135802.8 | 67901.4 | 168027.8 | 421.4 | ||||||||||
24 | Tentacle of Q'bthulhu | 15 | 3 | 1 | 3 | 15 | 40850 | 590 | 8850 | 4 | 5 | -5450.0 | 2677.8 | 892.6 | 43527.8 | 6.6 | ||||||||||
25 | Golden Soul | 15 | 3 | 1 | 3 | 5 | 34025 | 2000 | 10000 | 4 | 5 | 5975.0 | 15252.8 | 5084.3 | 49277.8 | 44.8 | ||||||||||
26 | Sunlight Bulb | 15 | 3 | 1 | 3 | 400 | 33400 | 25 | 10000 | 4 | 5 | 6600.0 | 15877.8 | 5292.6 | 49277.8 | 47.5 | ||||||||||
27 | Builderite | 15 | 3 | 1 | 3 | 115 | 52800 | 183 | 21045 | 4 | 5 | 31380.0 | 51702.8 | 12925.7 | 104502.8 | 97.9 | ||||||||||
28 | Insta-Grower | 15 | 3 | 1 | 3 | 15 | 54530 | 666 | 9990 | 4 | 5 | -14570.0 | -5302.2 | -1325.6 | 49227.8 | -9.7 | Insta-growers are not a high volume market | |||||||||
29 | Primordial Flame | 15 | 3 | 1 | 3 | 150 | 61960 | 90 | 13500 | 4 | 5 | -7960.0 | 4817.8 | 1204.4 | 66777.8 | 7.8 | ||||||||||
30 | Wallflowers | 15 | 3 | 1 | 3 | 55 | 51460 | 311 | 17105 | 4 | 5 | 16960.0 | 33342.8 | 8335.7 | 84802.8 | 64.8 | ||||||||||
31 | Nitro-Glitterine | 15 | 3 | 1 | 3 | 70 | 55300 | 218 | 15260 | 4 | 5 | 5740.0 | 20277.8 | 5069.4 | 75577.8 | 36.7 | ||||||||||
32 | /// Rare Seeds | Note: Seed costs are for Evolving Alchemy Plant, but can also be obtained from opening compost heaps and bobble pods. Chaos chests and Gem Dust cannot be traded, so they cannot be sold for profit. | ||||||||||||||||||||||||
33 | Chaos Chest | 8 | 3 | 1 | 2 | 1 | 29000 | N/A | N/A | 3 | 4 | N/A | N/A | N/A | N/A | N/A | ||||||||||
34 | Water Gem Dust | 8 | 3 | 1 | 2 | 750-1250 | 29000 | N/A | N/A | 3 | 4 | N/A | N/A | N/A | N/A | N/A | ||||||||||
35 | Air Gem Dust | 8 | 3 | 1 | 2 | 750-1250 | 29000 | N/A | N/A | 3 | 4 | N/A | N/A | N/A | N/A | N/A | ||||||||||
36 | Fire Gem Dust | 8 | 3 | 1 | 2 | 750-1250 | 29000 | N/A | N/A | 3 | 4 | N/A | N/A | N/A | N/A | N/A | ||||||||||
37 | Cosmic Gem Dust | 8 | 3 | 1 | 2 | 750-1250 | 29000 | N/A | N/A | 3 | 4 | N/A | N/A | N/A | N/A | N/A | ||||||||||
38 | Pearl of Wisdom | 8 | 3 | 1 | 2 | 4 | 29000 | 1800 | 7200 | 3 | 4 | -7400.0 | -922.2 | N/A | 28077.8 | -3.2 | ||||||||||
39 | Golden Pitcher | 8 | 1 | 1 | 2 | 1 | 29000 | 6500 | 6500 | 4 | 4 | -3000.0 | -3722.2 | N/A | 26000.0 | -10.3 | ||||||||||
40 | ||||||||||||||||||||||||||
41 | Note: There is a global 3-day timer for when Alchemy Plants can be harvested. For example, you can plant a Seed, water it with a Golden Watering Can after it sprouts, and it can be harvested either the next day, in 2 days, or in 3 days, depending on the global timer, instead of the time after you plant the seed. | |||||||||||||||||||||||||
42 | Another Note: It does not matter when you plant your seeds becuase tuesday does not have an effect on any crop on this sheet. That being said you want to plant so that the crop sprouts as close to reset time as possilbe so that you dont miss a harvest from it whithering before you get to it. For me (because I live in North America) that means I plant late in the day. | |||||||||||||||||||||||||
43 | ||||||||||||||||||||||||||
44 | / / / / INGREDIENT VALUES | Random Prices For Things Used To Craft Vegtables: | ||||||||||||||||||||||||
45 | Concentrated Compost is not factored into the values for the crop prices. | Faerie Dust: | 3000 | |||||||||||||||||||||||
46 | Moonlight Bulbs are not factored into the calculation of the flux cost to make flower seeds, and Insta-Growers are not factored into the costs of growing flowers, as they are only for speeding up growth from seed to sprout. | Sticky Ichor: | 750 | |||||||||||||||||||||||
47 | Moonlight Temper Price Per Unit in Flux: | 2500 | Watering Can Price Per Unit in Flux: | 3000 | Golden Watering Can Price Per Unit in Flux: | 6500 | Enchanted Wood: | 800 | ||||||||||||||||||
48 | Prices of other ingredients are taken from the Marketplace (adjuested if outlier price). Accurate as of Dec 26 2023. | Veridium: | 27 | |||||||||||||||||||||||
49 | Wild Cupcake: | 1200 | ||||||||||||||||||||||||
50 | Easiest biome to farm Moonlight Bulbs in, as far as I know, is Fae Forest. (300+ per hour with 1 acct, you can get much more with 7 alts) | Mushroom Chunk: | 89 | |||||||||||||||||||||||
51 | ||||||||||||||||||||||||||
52 | / / / FORMULAS | Note: Unicorn Chard, Onionito, Totter Tate, and Bunfeed can only be harvested once, and then the crop withers. | ||||||||||||||||||||||||
53 | Number of Harvests (Watering Can, Tractor, or Everlasting Watering Can only) | ((Life Span + 1)) - Initial Water Level) / (Water Level after Harvest * Days between Harvesting) | ||||||||||||||||||||||||
54 | Number of Harvests (1 Golden Watering Can, then Watering Can/Everlasting Watering Can/Tractor) | Life Span / (Water Level after Harvest * Days between Harvesting) | ||||||||||||||||||||||||
55 | Number of Harvests (Golden Watering Can only) | Life Span / (Days between Harvesting) | ||||||||||||||||||||||||
56 | Total Profit | (Number of Harvests * Average Yield Revenue) - Cost to Make Flower Seed - Total Cost of Watering Cans Used | ||||||||||||||||||||||||
57 | Note: Life spans are increased by 1 day in the formulas, because you can interact with a crop on the day it withers, before it actually withers. Example: If you plant a Day Drop Flower Seed on January 1st at 11:00 AM, the crop will wither on January 16th at 11:00 AM, but you can still harvest the crop on that day, if you harvest it at a time before 11:00 AM, but only after the servers change what day it is. (7:00 AM EST) | |||||||||||||||||||||||||
58 | / / / KEY | |||||||||||||||||||||||||
59 | Life Span - | How long until a crop withers. Unlike watering and harvesting, withering time depends entirely on the time when you place the crop, instead of what day it is. As such, losing a harvest is possible if you plant a crop too early in the day, or don't harvest the crop quickly enough before it withers. | ||||||||||||||||||||||||
60 | Initial Water Level - | How many times a crop has to be watered until the first harvest. | ||||||||||||||||||||||||
61 | Water Level after Harvest - | How many times you have to water a crop after harvesting. | ||||||||||||||||||||||||
62 | Days before Harvesting - | How long you have to wait before you can harvest a crop again after harvesting the crop and filling the water level. | ||||||||||||||||||||||||
63 | Harvest Yield - | How much of the crop you get when you harvest it. | ||||||||||||||||||||||||
64 | Cost to Make Flower Seed - | The cost of making 1 given flower seed, in flux. Cost taken from the cost of all ingredients combined, not the market value of the seed itself. | ||||||||||||||||||||||||
65 | Crop Price Per Unit - | The market value of each unit of the crop. | ||||||||||||||||||||||||
66 | Yield Revenue - | The value of each individual harvest of the given flower seed, in flux. | ||||||||||||||||||||||||
67 | Average Revenue/Cost | The value of each individual harvest of the given flower seed divided by the cost of making 1 of that flower seed. | ||||||||||||||||||||||||
68 | Number of Harvests (Basic) | The number of times you can harvest the crop before it withers, assuming you only use a watering can, the hydration tractor, or the everlasting watering can. | ||||||||||||||||||||||||
69 | Number of Harvests (Golden 1st) | The number of times you can harvest the crop before it withers, assuming you use a golden watering can once before the first harvest, and a watering can, hydration tractor, or everlasting watering can otherwise. | ||||||||||||||||||||||||
70 | Number of Harvests (Golden All) | The number of times you can harvest the crop before it withers, assuming you only use a golden watering can. | ||||||||||||||||||||||||
71 | Total Profit (Basic) - | The profit you receive from harvesting a plant until it withers, assuming you only use a watering can. Market cost of watering cans are taken into account. | ||||||||||||||||||||||||
72 | Total Profit (Everlasting) - | The profit you receive from harvesting a plant until it withers, assuming you only use an everlasting watering can or the hydration tractor. | ||||||||||||||||||||||||
73 | Total Profit (Golden 9) - | The profit you receive from harvesting one of nine plants until they wither, assuming you use a golden watering can once before the first harvest, on nine crops in a 3x3 radius, and a hydration tractor or an everlasting watering can otherwise. Market cost of golden watering cans taken into account. | ||||||||||||||||||||||||
74 | Profit per Moonlight Bulb - | The Golden 9 total profit divided by the number of moonlight bulbs it takes to make one of that crop. | ||||||||||||||||||||||||
75 | Theoretical Market Price of Seed - | What the market price of the seed should be, ie. you should buy the seeds if they are below this number. This number is one of the two following values (which is higher): the revenue generated from the "golen 9" method, or the revenue generated from the "everlasting" method. Note this is different from "total profit" because this value does not take into account the price of the seed. Essentially max revenue. | ||||||||||||||||||||||||
76 | % Return on Investment- | The max % return from making the seed (from using either Golden 9, or Everlasting, whichever is better). | ||||||||||||||||||||||||
77 | ||||||||||||||||||||||||||
78 | / / / CREDITS | |||||||||||||||||||||||||
79 | Turb0kayest - | Making this spreadsheet and calculating costs, revenues, and profits | ||||||||||||||||||||||||
80 | JeremyHub - | Maintaining with current prices as of date listed above, added some more helpful info/columns | IGN: JeremyHub | Discord: JeremyHub | ||||||||||||||||||||||
81 | Trove Wiki - | Source of most of the information in the spreadsheet | Feel free to contact me if any of the prices / formulas are wrong | |||||||||||||||||||||||
82 | Trion Worlds Inc. - | Owns rights and properties to Trove | ||||||||||||||||||||||||
83 | ||||||||||||||||||||||||||
84 | / / / CHANGELOG | |||||||||||||||||||||||||
85 | 12/26/23: | Deleted some columns that were not useful & confusing, cleaned up some formulas | ||||||||||||||||||||||||
86 | 8/31/2021: | Deleted the "golden 1" column as it was leading to confusion | ||||||||||||||||||||||||
87 | 8/4/2021: | Added note at top of sheet | ||||||||||||||||||||||||
88 | 6/16/2021: | Added "Notes" column and some notes | ||||||||||||||||||||||||
89 | 6/12/2021: | Fixed Gem Dust seeds and Choas Chest seeds to reflect accurate lifespan and number of harvests. | ||||||||||||||||||||||||
90 | 13 May 2021: | Added % Return on Investment column and corresponding key term, thanks to u/Munckeey for this suggestion | ||||||||||||||||||||||||
91 | Adjusted all columns so that they don't show more than one decimal place. | |||||||||||||||||||||||||
92 | 5 May 2021: | Added Theoretical Market Price of Seed column and apprroitate key terms. | ||||||||||||||||||||||||
93 | Added JeremyHub to credits | |||||||||||||||||||||||||
94 | 21 July 2020 : | Changed the Golden All column (column P) into Golden 9, and changed the Key terms accordingly. | ||||||||||||||||||||||||
95 | Modified Conditional Formatting coloration to separate profits from crop seeds and alchemy seeds. | |||||||||||||||||||||||||
96 | Concentrated Compost is no longer taken into calculation for seed prices. | |||||||||||||||||||||||||
97 | Added borders around profit values. | |||||||||||||||||||||||||
98 | 28 July 2020 : | Added Profit per Moonlight Bulb column. | ||||||||||||||||||||||||
99 | 8 August 2020 : | Fixed Golden 9 values not taking cost of golden watering cans into account properly, thanks to krillmee for pointing this out! | ||||||||||||||||||||||||
100 |