So, we’ve published this cool profit calculating spreadsheet for Ranch Simulator with all these fancy functions that basically tells us how much money we’re making. It considers stuff like crops dying, how long it takes to load them up, and how long it takes to get them to the market. And guess what?
Pineapples are the winners here! Why, you ask? Well, you can pick and carry them in a basket, quite easily. Unlike Watermelons and Pumpkins – they can’t be put into the baskets, so they end up being the slowpokes in the profit game.
Ranch Simulator: Profit Calculating Table
Details for Nerds
The table assumes transit-time per crop item to be 5 seconds for all. This is the time to carry the crop to the truck. This could be any number as long as it is the same for each crop.
The major factor is that some crops are basket harvestable and some are not.
Since Grapes and Pineapples are both basket-harvestable, they automatically are competing for the top spot. Pineapples win because you only need to harvest one and the single-item price is higher.
The function for plant-death and crops harvested is basically where there may be some error. I used 20% death rate per “pick”. So, each time you pick a crop, you have a 20% chance there will be no re-growth (dead plant).
Plus, with each round of picking you do, the number is increased as well. My numbers may be off, as it could be 10% or some non-linear value. But keeping them all the same is the real factor. I am open to hear and try your ideas on more complicated functions.
Example: With 10 Pineapple Plants
The function rounds down [Crop Items(1-(Regrowth Stage20%)]
First Harvest, you get 10 Pineapples.
Function for Second Harvest is
=rounddown(10(1-(20.2)),0) = 6
Function for Third Harvest is
=rounddown(6(1-(30.2)),0) = 2
Etc. down to 1. Then rounding down would get you zero crop.
Special thanks to Draken Kiele for this table explanation!
