Hi all, I made a quick and dirty excel table to see which crop is worth the most. I think there are still many errors and bugs contained, but I hope it helps someone. If anyone can help me to make it better I would be very happy. By the way... awesome game. With best regards. Preview: €dit: Added v0.5 - Strawberry fix
Useful table! I've always been one to like knowing exactly what I'm working with. My only suggestion would be to add "cost" or something similar to the "per day" column. It took me a bit to realize what it meant, but otherwise, I see no issues or improvements.
Hey nice table. I did something similar with crops also but not on excel. How did you get your maximum harvest numbers?
Thanks for your reply. Maximum harvest numbers was a little tricky for me... the first way I tried is: - "days per month / days to grow = x" But with the regrow it was a little complicated. My formal now is: - "(days per month - days to grow) / regrow after x days + 1" and round down After I count with my hands (yes I did ) it fits for all. @Khranos: What exactly do you mean by costs? Or did you mean "per day" minus the seed price?
Oh good to have someone around who knows his maths! Thank you! I've been using a list I found on the internet, but they only had "profit" listed and I don't know how they actually calculated it.
There are some things that you have got wrong, like your total potential profit, as you only account for the value of 1 seed, also I feel like there are some errors with maximum harvests, as I calculated that strawberry's should be harvestable 6 times (according to the current wiki values anyway). Anyway, I threw together this spreadsheet too if anyone is interested... (Zip is the excel files, png is for people who just want an image) (Winter is broken as the wiki is empty for it)
Hm... did they change the regrow time? I thought it would be every 3 days for strawberry's. Thanks for helping. I will look into it tomorrow.
I'd suggest porting this excel sheet over to Google Sheets. That way we can all view the table and keep up with the live edits rather than per-version distribution. https://www.google.ca/sheets/about/
This is my sheet. https://docs.google.com/spreadsheets/d/1E8dGzHNH7F2V4b4MYizsa8lQJ03P531beW-QG4_9o5c/pubhtml and downloadable if you want to change number: https://drive.google.com/drive/u/0/folders/0BwgmldvY1E8QUHlKMEFINnVQNUE
Google Sheets are a perfect way. I think you already got it @subedod? Thanks for sharing. @Eternalmyst: Maximum harvest means how often you can harvest one type of crop per month on one field. So this is theoretically the maximum you can get from a crop per month (some crops need to be seed again, some regrow by itself).
Hey mates! Isn't the crops Profit per day wrong? Its missing the seed price in the calculation (i think) ? THX in advice. im searching for a good spreed sheet since I will request a "difficutly" Mod and I want to calculat how much it will need to Nerf crops income prices and such