Zamiell / stardew-valley

GNU General Public License v3.0
105 stars 79 forks source link

Fishing spreadsheet mistake? #35

Closed hawstom closed 2 years ago

hawstom commented 2 years ago

I think you made the same mistake I was about to make at Intro!I29. You calculated the average as

(max - min)/2 = 13450 ms

But it should be

min + (max - min)/2 = 14050 ms or more classically (max + min)/2 = 14050 ms

Right?

Zamiell commented 2 years ago

yeah i guess so

Zamiell commented 2 years ago

for 100-200:

(200 - 100)/2 = 50 ms

(200 + 100)/2 = 150 ms

Zamiell commented 2 years ago

ok, it should be fixed on the spreadsheet now. the good thing about spreadsheets is that i dont have to manually redo any of the calculations, lol