4
edits
Changes
no edit summary
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)
: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)
:: It seems you are using basically the same thing I am using, but instead of ''+1'' you just round the number up. This is correct, as long as the number is not a whole number. However, when it is a whole number, it does not have the same effect, as 6 will stay 6, instead of there being 7. This is the case of Green Beans. I drew it out into a table for each day, and you do get 7 harvests (not 6). This means that every regrowing crop that has its last harvest at the last day it is alive has wrong gold per day. This should be fixed. Please don't take this as an offense, I just want to help. Thanks.[[User:Slash0|Slash0]] ([[User talk:Slash0|talk]]) 16:58, 9 July 2022 (UTC)