9
edits
Changes
Jump to navigation
Jump to search
Line 107:
Line 107: + + + + + + + + + + + + + + + + +
no edit summary
</syntaxhighlight>
</syntaxhighlight>
::::[[User:LahaiRoi|LahaiRoi]] ([[User talk:LahaiRoi|talk]]) 18:09, 10 September 2021 (UTC)
::::[[User:LahaiRoi|LahaiRoi]] ([[User talk:LahaiRoi|talk]]) 18:09, 10 September 2021 (UTC)
:::::Ok LahaiRoi, I've taken a look at your spreadsheet and I see where it went wrong. I think I didn't explain well what my formulas were. I'm attaching a screenshot below of some of my calculations.
:::::[[Media:Fertilizer_Crop_Quality_Chances_Screenshot.png]]
:::::I'm also attaching my spreadsheet. If you wish to see the formulas they are hidden within the headers.
:::::docs.google.com/spreadsheets/d/1IwVMmuggkY2kzK6wrdUCWNndWI9r79YD3hDnvXIzbf8/edit?usp=sharing
:::::If you look at the screenshot first, you can see that our calculations differ first at Basic Fertilizer and Farming Level 10. Our gold chances are the same. For silver, you calculate 48.4%; I have 44.3%. If you look at the way I've calculated it, I've broken down the calculation into two: first the Silver Chance Formula and then the actual Silver Chance. My Silver Chance Formula is exactly as given by the code. At Farming Level 10 with Basic Fertilizer, that is the first time that 0.75 becomes the minimum, which you can see in my calculation. Our values differ because I use that first then apply the probabilities. Looking at your calculation at the same levels (Row 29), you have min(G29*2*(1-G29),0.75) as your innermost min formula. You're multiplying the probability to the silver formula '''before''' taking the minimum. The code given above is first calculating the silver chance, then checking for iridium quality, then checking gold, finally silver. So I think your formula needs to be min(min(G29*2,0.75),1-G29) in order to follow the code.
:::::Additionally, if I change my calculations to ignore the 75% cap to silver chance, my values match yours.
:::::If that doesn't make sense to you, add a few intermediate columns that calculate the chance in parts. Make a column that calculates the silver chance, then another column that includes the silver chance and the probability the code checks for silver quality.
:::::I'm confident that what I have is correct, please view my spreadsheet for the full calculations. If you compare mine to the current tables, all my percentages match, except for the Deluxe Fertilizer table, which cannot possibly be correct since it lists a nonzero chance of harvesting a regular quality. If everyone here agrees, I will edit the table.