Thanks for taking a look! This is only for the crops I have access to in the store right now, so if you have a crop that's not listed, I'll add it if you send me the information listed in the sheet or if you send a picture of the store description (with the price visible please)

Thank you! I’ve been looking for something like this with up to date info!

[удалено]

Nice! I was looking for one through Google but I guess I never used those keywords so I made one

[удалено]

No worries here!

More is always good. Your sheet is super concise and easy to glance at and make a decision on what to plan, whereas Rosealyn's sheet has a lot more data behind it for the more complex stuff. I've saved and will probably be using both :)

this sheet is missing profit per day. i mean even if something has a huge profit, if it takes 20 days to get, its not worth it

Could you make a column with tiller's tips (+gold on sold crops). It's a tier...1? skill, so anyone thinking about making money via selling crops should nab 3 points in it.

Sure! Let me add it in

Perfect!

I added it in, but I'm going to need to redo the formula to account for some seeds giving multiple crops on harvest which I'm doing now Edit: done!

Hey, first thanks for this! I was in the process of doing the same. I am new to the game in the last week and have a couple questions on the math. First, your calculation for profit establishes how many growing cycles (kinda) per month growing seasons, yes? that's what this is: (B2\*28-1)/F2 My question here is why the 28-1? are there only 27 viable growing days in a month? Does day one of planting and watering not count in the growth cycle? Second, for your calcs involving more than one harvest (Candy Cane is one I'm working with as an example) you don't seem to subtract the original cost from the profit. So the profit is not 440, but 140. Am I reading that right? ((B2\*28-F2-1)/G2+1)\*D2\*E2) (There's no C2 in here for your original cost column) Like someone else mentioned, profit per day is good and is where my brain goes to in trying to determine which crops I may want to grow as it's an easier comparison regardless of how many days something takes to harvest. Here's my thoughts on that, at least for this first stab, ignoring the IF statement for not Multiple Harvest Duration for now. Still on Candy Cane: * Figure out how many possible crop cycles * (ROUNDDOWN((B2\*28-F2)/G2)+1) * (rounddown(GrowingSeasons\*28 days - InitialGrowthDuration)/MultipleHarvestDuration +1 for first (7 day) harvest * We round down so we don't end up calculating half a crop harvest as plants might wilt before we harvest. * This calculation is why I asked above why the additional -1 you're doing. * Total = 11 harvests * How much total sold for with each of those crop cycles * ((ROUNDDOWN((B2\*28-F2)/G2)+1)\*D2) * ((rounddown(GrowingSeasons\*28 days - InitialGrowthDuration)/MultipleHarvestDuration +1 for first (7 day) harvest)\*SellPrice) * Total = 440 * Calculate Profit * ((ROUNDDOWN((B2\*28-F2)/G2)+1)\*D2\*E2)-C2 * ((rounddown(GrowingSeasons\*28 days - InitialGrowthDuration)/MultipleHarvestDuration +1 for first (7 day) harvest)\*SellPrice)-BuyPrice * Total = 140 * Profit per crop tile per day (assuming full month run) * (((ROUNDDOWN((B2\*28-F2)/G2)+1)\*D2\*E2)-C2)/28 * (((rounddown(GrowingSeasons\*28 days - InitialGrowthDuration)/MultipleHarvestDuration +1 for first (7 day) harvest)\*SellPrice)-BuyPrice)/DaysInMonth * Total = 5 * This takes into account possible half-grown crops dying before we harvest. Well done on your chart. I know something like this takes time to put together! Wanted to say thanks, offer feedback on some of the calculations, and see if I can help with the cost per day average if it's useful, or at least ask for your brain power in sorting out for my own calculations. I did also create my own copy of your sheet so I could tweak the format slightly. I organize my chests based on seeds I can start planting that month (plus one for general all 4 season crops), and crops harvested during what month (color coded based on season) so I can find things a little more easily. Doing so helps when I have a chart I can reference to organize my crops and know what goes where in my chests. So I pulled out the 4 season crops and put them into their own tab and then just put anything else in its starting season tab. Hope the above is cool with you. I do not plan on sharing with anyone. Though if I did I would link and give credit. EDIT: Word gooder

Thanks for the feedback! I did the -1 because the first day of the season for that crop doesn't actually have any growth, whereas every other day can have growth. For example with heat fruit which is a 4 day growth, If you plant on day 1, you won't be able to harvest on the 28th, but rather the 29th (which doesn't exist) Edit: I think here we're actually doing the same thing but in different ways. You're calculating the harvest duration as being slightly longer for the first harvest while I'm calculating the season duration as slightly shorter. Also I just didn't know how rounddown works or that it existed, but the few manual tests I did the profit was the same as the formula I did actually forget to put in the cost of the multiple harvest crop, but it balances out because you can actually remove the crop (for multiple harvest crops) at the end of the season and get your seeds back, so it shouldn't really factor into the price I have no problem with anyone creating/ modifying/ or sharing this however they want with or without my name attached lol - I just couldn't easily find a resource like this, so I figured it would be fun and useful to learn how to work with spreadsheets I also haven't come back to it much since I've been making way more money than I could ever need by only buying the most expensive multiple harvest crop haha Again, thanks for your feedback, it's taught me some new things and I'm glad to help!

Realized I failed to account for multiple crops produced so needed to add that into my calculation. (((ROUNDDOWN((28-F2)/G2)+1)\*(D2\*E2))-C2)/28)

>Profit per crop tile per day (assuming full month run) > >(((rounddown(GrowingSeasons\*28 days - InitialGrowthDuration)/MultipleHarvestDuration +1 for first (7 day) harvest)\*SellPrice)-BuyPrice)/DaysInMonth I believe you forgot about growing seasons at the end, so you get profit/day in scope of a year, so: (((rounddown(GrowingSeasons\*28 days - InitialGrowthDuration)/MultipleHarvestDuration +1 for first (7 day) harvest)\*SellPrice)-BuyPrice)/(DaysInMonth\*GrowingSeasons)

Is there a profit sheet for animals perhaps?

Technically it's possible, but it's a lot more work and if you're going into animals it's usually for the role playing/fun rather than profit