106,342
edits
Changes
no edit summary
:::Added. [[User:Margotbean|margotbean]] ([[User talk:Margotbean|talk]]) 01:24, 11 December 2021 (UTC)
:::Added. [[User:Margotbean|margotbean]] ([[User talk:Margotbean|talk]]) 01:24, 11 December 2021 (UTC)
::::👍 --[[User:Odg|Odg]] ([[User talk:Odg|talk]]) 22:21, 11 December 2021 (UTC)
::::👍 --[[User:Odg|Odg]] ([[User talk:Odg|talk]]) 22:21, 11 December 2021 (UTC)
==Calculations==
I was making a spreadsheet of this in excel for personal use, and I am using math to determine the number of harvests. The formula is ''Harvests = Round.down((Available days-Initial grow days)/Regrow Days)+1'' where ''Available days'' is maximum number of days that crop can be grown (ie. 2 seasons = 28*2 = 56 days). With this formula, gold per day comes out to be exact same for Corn as is provided here, however for some other crops (coffee/green bean) it seems the ''+1'' at the end of this formula must be missing for the gold per day to match. I think my formula for number of harvests is correct, as you need to calculate how many regrows there are, and the ''+1'' is there to account for the initial yield (before the regrowing starts). Is this a calculation error, or did I miss something? [[User:Slash0|Slash0]] ([[User talk:Slash0|talk]]) 16:04, 9 July 2022 (UTC)
I was making a spreadsheet of this in excel for personal use, and I am using math to determine the number of harvests. The formula is ''Harvests = Round.down((Available days-Initial grow days)/Regrow Days)+1'' where ''Available days'' is maximum number of days that crop can be grown (ie. 2 seasons = 28*2 = 56 days). With this formula, gold per day comes out to be exact same for Corn as is provided here, however for some other crops (coffee/green bean) it seems the ''+1'' at the end of this formula must be missing for the gold per day to match. I think my formula for number of harvests is correct, as you need to calculate how many regrows there are, and the ''+1'' is there to account for the initial yield (before the regrowing starts). Is this a calculation error, or did I miss something? [[User:Slash0|Slash0]] ([[User talk:Slash0|talk]]) 16:04, 9 July 2022 (UTC)
:The formula was derived from [https://docs.google.com/spreadsheets/d/1fz4nVTKWIT-97CjkNDVm0EUpG8M4OqCO2tSN9B8x4Xg/edit#gid=0 this spreadsheet]. I've updated it over the years, but the basic calculation method hasn't changed. I should probably upload the updated version to google docs sometime. [[User:Margotbean|margotbean]] ([[User talk:Margotbean|talk]]) 16:26, 9 July 2022 (UTC)