Coral Island Profits

[mortal saffron]

Here’s a profit sheet I made let me know what everyone thinks. https://docs.google.com/spreadsheets/d/1WqJ_cq-VK3Agr_YFWiYWPQmxW6e0f7oriHX4pB7n-J0/edit?usp=sharing

[rugged sinew]

Hey there! You may want to change the access setting so you don’t get a hundred permission requests 🥰

[mortal saffron]

Sorry new to this lol will do thanks

[mortal saffron]

I think I did it lol thank you

[half sand]

@mortal saffron calculations page is not working

[mortal saffron]

What are you trying to do and what’s it not doing sometimes it takes a few seconds to load the lines

Ah so I guess to use the scripts I set up you need the editor access I can do that I was just worried people would change things by accident or something lol

Should be able to use it now

[half sand]

the filters are empty whether I make my own copy or use your file

And I wouldn't open it to everyone, people should be able to make a copy and use it.

[mortal saffron]

Did you enter in a rank too I believe you need both a season and rank for it to pull and ok I can have it on view only and have people request to be editor to use the calculations tab

@half sand you will need to request editor access to use the calc tab now

@rugged sinew let me know if it’s working for you

[half sand]

So, it's not efficient for you. You'll be slammed with requests, let's try and make it work on a copy. DM you to try and resolve it

[last perch]

make it so people can make a copy of it and use at will.
having it be on request is bad for everyone, people need to wait till you accept, and you will get hundreds of requests

[mortal saffron]

I think I changed it back to editor but when it’s copied it doesn’t copy over part of the script that’s supposed to run so I have to figure that part out for people that want to copy it

[last perch]

i did a copy of it and tried to mess with it, its not very clear what i am supposed to edit. probably the scripts not working 100% is maybe not helping.
also some of your math seems wrong/weird,
take sugarcane for example, after 5 days it is harvestable every single day for the rest of the season, why is it only 4 growth cycles? and 8 harvests? a single sugarcane planted day 1 is harvestable 23 times (28 days - 5 growth days) / 1 regrowth day times isnt it? so 1 seed gives 23 crops in 28 days
correct me if im wrong

here's some feedback incase you wanna work on it:
have the controls that are supposed to be editable in the main(front) sheet
put some descriptions of what to expect and the desired inputs so people who open it later dont forget what to do and how to mess with it
put a version/tag on it and keep a link to the original incase you later update it people can check if theirs is outdated
the stuff that the user is not supposed to edit/change should clearly marked or maybe locked/hidden

[mortal saffron]

Ah thanks for the heads up on the sugarcane. All I saw when I looked it up was growth time and regrowth time and not that it reproduces everyday so I will fix that calculation. And I will also put the calculation tab first and add a cover sheet for notes as to what to do and how the sheet should react. Thank you so much for the input.

Just did a quick search and there are a few crops that continually regrow throughout a season so I will fix all those as well

[radiant fulcrum]

could prob use the coral guide to double check which crops regrow

[mortal saffron]

Yea that’s what I’m doing. I was trying to avoid that and use outside list sources since there’s so many crops lol but looks like that wasn’t the most accurate option lol

[radiant fulcrum]

well coral guide uses stuff straight from the game code so its currently the most accurate

[mortal saffron]

You’re talking about the wiki right?

[radiant fulcrum]

no not the wiki

https://coral.guide/

wiki is outdated

click this button and it turn it into a grid thatll show it easier which crop regrow

like this

[mortal saffron]

Oh dam that’s nice lol

[last perch]

Isn't that what the regrowth day column is for? The days it takes to regrow after harvest?

[mortal saffron]

Wait so if something regrows does that keep regrowing until end of season off one seed

[mortal saffron]

Yes but I thought it regrew once and you had to replant again

[radiant fulcrum]

yes

[mortal saffron]

😮

Dam I got some recalculating to do then lol

[radiant fulcrum]

i have the calculations done but i dont have the notebook with me or id share it

im just not good with spreadsheets

[mortal saffron]

Of how many harvests per season per crop?

[radiant fulcrum]

that would be in my notebook that i dont have with me lol

[mortal saffron]

lol I love spreadsheets

Well I won’t be home for another 9 hours anyways lol

[radiant fulcrum]

the only thing is i was never sure if the day of planting seeds counted or not but it may be a decent start

[mortal saffron]

The only day that doesn’t seem to count is the first day of the season which is weird the wiki shows an actual picture of the stages for a whole season and the first crop always has two seed days then after that it’s one seed day

[radiant fulcrum]

hmmm my calculations dont have that. and are for "not counting day planted" as well

[radiant fulcrum]

have u tested this yourself or just gone off the wiki?

[mortal saffron]

Gone off wiki so far

[radiant fulcrum]

might need to do some testing then.

but id have to make sure to not have that one skill active 🤔

sounds like i need a fresh save

[half sand]

The first day counts. Example, plant takes 8 days to grow, you planted it on 20 and on 28th you will have a harvest.

[mortal saffron]

Yea I’m only calculating for fresh starts so no skills lol

[mortal saffron]

So for peppers are 7 days to grow but harvest on the 8th

[radiant fulcrum]

thats also the wiki and its outdated and things change so cant rly go off that

imma still do some testing

[mortal saffron]

Ah ok then got it thanks

[radiant fulcrum]

Here what I had done. First number is the price of the seed bag, second number is the price of the crop of base quality, the hunter in () is how many harvest I would get, and the third number is the total I would get with max harvest minus the cost of the seed bag

It’s crude so sry

So for example strawberry: at 4 harvest max would be 4(max harvest) x102 (base price)which is 408. 408- 145 (seed bag) is 263.

but i didnt count the day of planting seeds nor did i count the day of harvest so it could be wrong

[mortal saffron]

Sweet ok definitely something to start with atleast lol thanks man I’ll have to try and rework the spreadsheet tonight

[radiant fulcrum]

Np! Hope it helps some!

[radiant fulcrum]

Okay so started testing on a fresh save with turnips which take 4 days to mature. Planted on day 1 of spring but was not harvestable till day 5.

Potatoes (5 days to mature) planted on day 1 not harvestable till day 6

Planted another set of turnips on day 4 so I'll see how long that takes

[wide geode]

I would help with this but TBH I just got the game like last week and barely know what I am doing

[mortal saffron]

So it looks like the first day of the season doesn’t count towards growth

[wide geode]

nope. that is the only thing I know from HM Games in my history of farming sims

[mortal saffron]

When you Plant something in the middle of the season how many days does it take till harvest?

[wide geode]

same thing I would assume

[mortal saffron]

Loved harvest moon

[radiant fulcrum]

Set of turnips planted on day 4 (4days to mature) harvestable on day 8

[mortal saffron]

Well the wiki shows day one doesn’t count but then if you plant after the first harvest something that takes 5 days will be harvestable in 5 days not 6

[wide geode]

Ah Got it

[radiant fulcrum]

So can confirm that day 1 of season does not count BUT any other day that seeds are planted on does not count

[mortal saffron]

So it looks like day one doesn’t count

[mortal saffron]

Ok sweet thanks

[wide geode]

Day 1 might be the only factor that it seems math is off

[radiant fulcrum]

So yeah any day that seeds r planted does not count

[mortal saffron]

That will help with counting how many harvests a crop will have in one season

[radiant fulcrum]

So my math on my crude stuff seems to be okay

[radiant fulcrum]

So after testing the day the seed is planted does not count

[mortal saffron]

Wait doesn’t count? I thought you said something planted on day 4 and takes 4 days was harvested on day 8

[radiant fulcrum]

If your count the number 4 then it would be 4,5,6,7

So no the day the seed is planted does not count

[mortal saffron]

Ah your right

[radiant fulcrum]

I took screenshots of the growth progress as well

I'll attached those in a bit

[mortal saffron]

Heck ya man

[wide geode]

I use a formula for harvest moon spreadsheets on google sheets =If(Cell with Regrow="", 1, Rounddown((Number of Days/Cell with Initial Day Growth)/Regrow Cell)+1)

that is to only get the harvests per season

if you want Days for Profit, that gets trickier cause it is two separate formulas and even I had to ask Google Gemini for the process on that

[radiant fulcrum]

so just stating this again for info with pictures: the day the seed is planted on DOES NOT count. example: turnips planted on day 1 (matures in 4 days) were not harvestable till day 5 (took 5 days) and potatoes planted on day 1 ( matures in 5 days) were not harvestable till day 6 (took 6 days).

set of turnips planted on day 4 (matures in 4 days) were not harvestable till day 8 (took 5 days counting seed day)

[wide geode]

Computer formulas like google sheets dont count day 0 in math so I would assume so would coral island

[radiant fulcrum]

i asumed too but we were told that seed day was counted

which is why i wanted to do some testing to confirm

[wide geode]

Ah ok

[radiant fulcrum]

@half sand this is the results i got

[mortal saffron]

This is awesome man thanks for taking the time to do this now I can accurately recalculate the formulas

[radiant fulcrum]

np! i like feeling useful lol

[mortal saffron]

Lmao same 😂

That’s y I built this spreadsheet

[radiant fulcrum]

I would assume day harvested would not count towards regrowth on multi harvest crops but until I get to summer I can't test that out

[wide geode]

Same here. but based on math with formulas, that checks out

[radiant fulcrum]

I’ll push the save soonish just to double check and make sure though

[mortal saffron]

https://docs.google.com/spreadsheets/d/1_MRoRcOWGQXAMF2YjIbBtLad0RyQhtigy4_LGaX1Hnk/edit?usp=sharing

updated version. still ned to add a new feature and instructions but formulas should be updated now.

[last perch]

had a look and it seems much closer to real values now,
but the final formula is still wrong i think.
you have profit_per_day = ((sell_price x growth_cycles) - seed_price) / 28
you're assuming only 1 seed was used, which is wrong for all single-harvest crops, you're missing the seeds_month multiplication with seed_price
the final formula should be profit_per_day = ((sell_price x growth_cycles) - (seed_price x seeds_month)) / 28
right?
example:
sunflower has 3 growth cycles, 20 per seed, 70 sell price, your formula gives 6.79/day, (((3 x 70) - 20)/28)
but you had to buy 3 seeds, not 1. so the real profit is 5.35/day

btw, what does the total_days column represent?
sugarcane has the value 8, with a growth cycle of 5 and regrowth of 1, where does that 8 comes from?
planting it on day 1, it is harvestable on day 6, and every single day after, like 7, 8, 9, etc, so i dont see why 8 here

im not even sure you need this column at all, all single-harvest crops dont make use of this value, and all regrowth crops also dont make use of this value at all

[last perch]

one thing you could add, but that might be more niche is the profit_per_day but not taking into account the whole season but only how many days it uses.
this is more for the single-harvest crops.
example:
sunflower has 3 growth cycles taking 8 days each, 20 per seed, 70 sell price, the final profit_per_day is 5.35, but in reality those 3 cycles took 24 days, not 28. which bring the profit_per_day up to 6.25
i could then plant something else so those 3 days arent exactly wasted (in this case i cant plant anything in 3 days but my point still stands)

[last perch]

another example to my earlier point:
chard: growth_cycle=6, cycles_per_season=4, seed=50, sell=111, profit_per_day=8.7
cauliflower: growth_cycle=10, cycles_per_season=2, seed=70, sell=175, profit_per_day=7.5,
based on these values, which are the ones on the sheet, chard looks like its a better option to plant.
but if you added the profit_per_day only taking into account the cycle and not the whole season, cauliflower jumps from 7.5 to 10

imagine this scenario:
if i plant cauliflower first, planting on day one, im now on day 21, i still have 7 whole days left in the season, i could then plant a chard,
now im on day 27 (effectively only "wasting" 1 day), with 2 cauliflowers and 1 chard, total_profit_per_day=((175 x 2 + 111) - (70 x 2 + 50) / 28) = 9.67
going for cauliflowers first and using the remaining time on something else gives higher profit_per_day than straight up planting chards the entire season, and looking at those 7.5 on cauliflower would never make me think this way, but if i had the profit_per_day_cycle which is 10, then i know for a fact now that cauliflower is better than chard but i cant plant it all 28 days, so i could then debate if i do want to plant cauliflowers and see if i try to fit something else in the remaining days or plant something else entirely.

i hope im explaining my point clearly, but do let me know if there is anything you dont understand.

[wide geode]

I see where you are going with this but how would that work combining the different crops in one spreadsheet just focused on one crop and their growth cycles for you to compare then filter to plan yourself?

This isnt a program that auto filters everything, it is simply a spreadsheet at the moment for self reference

[mortal saffron]

@last perch yes I see your points clearly. So the single harvest crops should have a different formula, it should be counting multiple seeds if not I’ll have to change it lol. As for the total days column it was used in my previous formula but I don’t think it’s needed now so I will probably delete it. As for the days used I use 28 for a constant so that each plant has the same “grow” days and it takes in count the non productive days.

[last perch]

i'm not asking for a filter or something to take this into account. just an extra column that gives the price_per_day but uses just the days used in the cycle and not the whole 28 days.
because if not then its misleading, as i explained, chard is "ranked" higher than cauliflower when technically cauliflower gives more profit per day

[last perch]

for the single-harvest crops, just add that multiplication i said and it should be good.

i understand your reasoning for the 28 days thing, i just said that an extra column could be added that ignores those non productive days because in some cases, the cauliflower being one of those, there are enough days left in the season to fit another crop. so technically the cauliflower doesnt have non productive days

but thats something i can add to my copy either way, i just thought it would be helpful for more people to know the effective profit per day instead of per season

[mortal saffron]

Ah ok I see your point now. Ok I can do that and I’ll take it a step further. I’ll add another limb in the calculations page to search how many days left and have it pull every crop for that season and rank that will be harvestable with how many days left in the season

[wide geode]

That is why I suggested my rounddown formula a while back. it takes account the initial growth time, takes that out of the equation and then divides with regrow days. then you add back in the 1 for initial crop growth. single Harvest is I guess that formula you gave due to the amount of times you have to sell and buy crops. My bad for jumping the gun

[last perch]

yea, i also could have probably worded my point a little bit better, for regrowth crops, its totally fine as it is the the profits are okay, it was just the single-harvest ones that were a bit misleading (in my opinion) because of the non productive days (which in some cases make sense, other not so much because there are enough days to plant other stuff) or you could not plant them all cycles in a season, only a cycle or 2 and it would give better payout but you had no way to know that.

[last perch]

yea, thats above and beyond, keep it up!

[wide geode]

That is more than I know what to do

[mortal saffron]

Yea man no worries I got you lol and thanks lol

[mortal saffron]

lol yea it can definitely be a challenge lol

[mortal saffron]

@last perch so I redid the formulas and added in an extra row for actual profit/day let me know what you think. Oh and I added the seasons day on the calculation tab so everything that will grow within the remaining days will show up

[last perch]

just had a look. its looking good!
now its easy to see which crops are good no matter if we want to compare the whole 28 days or just their growth cycles

here is some more feedback/food for thought:

• 1
  the base_profit_day_28_days is looking at it the whole season (including the non productive days) correct?
  the base_profit_day is just 1 growth cycle correct?
  if so, you dont actually need different formulas for single-harvest and regrowth-harvest crops.
  i noticed that on single-harvest you include the seeds_month value in the calculations to account for the multiple seeds needed, and on regrowth-harvest crops the formula doesnt use that value, since their value is correct (1), you could reuse the formula and save yourself the time and headache of having that not included.

• 2
  what do you think about using the same formula for all crops in the base_profit_day which is 1 cycle.
  regrowth-harvest crops are using the season formula there and the values are the same, which defeats the point of having that column, its obvious that 1 cycle of those crops have a low profit per day so it should reflect that aswell.

• 3
  if you're up for a challenge, the profit per day in the calculations sheet could/should reflect the actual profit based on the remaining days.
  example, i input day 15, its showing the regrowth-harvest crops as the best option because its using the whole season, but i only have half a season left so the profit is actually lower, it might not even be worth it to plant them

• 4
  the total_growth_cycles is still not correct for a few crops.
  example: strawberry shows 4 growth cycles, at 10g/4rg, i plant on day1, harvest at 11, 15, 19, 23, 27, its actually 5 total growth cycles
  you have a couple of +1 in there that are messing up the calculations
  from the looks of it, removing the +1 to the regrowth_days gives me the correct results
  cucumber shows 5 when its actually 7 (which is quite a boost in the profit_per_day)

[mortal saffron]

Ok lol so for number one yes correct the equation is looking at the whole season. The single harvest will have multiple seeds bought throughout the season that’s why it’s not just one seed for the single harvests.

2. The regrowth crops aren’t using the full season it just looks that way because they can be harvested multiple time so with one seed they can grow till almost the end of the season so this helps show which crop gives you the most bang for your buck.

3. The season day search only uses one full grow cycle not the whole season

4. The total grow cycle column is technically supposed to say total seasonal harvests but change if the name means changing alot of formulas and I was feeling lazy lol

[last perch]

let me explain better what i meant:

1. you have ((sell_price x total_growth_cycles) - seed_price) / 28 for regrowth
   and also ((sell_price x total_growth_cycles) - (seed_price * seeds_month)) / 28 for single-harvest
   im saying you could use the 2nd equation for all crops, less work for you 😄

2. i might have misinterpreted then, is the base_profit_per_day column not supposed to represent 1 cycle only? are you instead removing the non productive days?

3. go to the calculations sheet, put spring day 15, it will show sugarcane as the best crop with 17$ profit per day, thats the value on day 1, not 15. at day 15 you will only harvest 9, (23*9 - 50) / 13 = 12$ profit
   thats what i meant by calculating the remaining days xD

4. yea, my point still stands, your equation is giving less total harvests than what should be, some crops have 1 or 2 lower harvests than normal

[mortal saffron]

1. Ah yea now I see and yea I could use the same formula. That would have saved a couple minutes but since all crops aren’t done now changing it won’t save me anytime lol but I might change it so it’s more uniform

2. Correct it’s calculated to measure total days the crop takes to provide in a season so essentially column m should have been used in the equation but column m was built after that equation lol

3. Ah okay yea I understand now and yea that might be alittle tricky but I’ll see what I can do lol

4. Ah I see what happened I was adding 1 to each regrows day because I was still thinking that each regrowth time had an extra day like the initial crop did ( if you want since I can’t do it on mobile - do you know how to drag/copy cells? If so drag that formula from sugar cane all the way down please)

[wide geode]

On mobile, all you do is copy a cell and then highlight cells and paste

[mortal saffron]

Yea but it doesn’t change the cell number so I’d manually have to change each cell number to match the line and it’s just annoying on mobile lol

[wide geode]

Unless your using the $ in cell numbers, it should change cell columns and rows, I do spreadsheets 95% of the time on Google Sheets app and it works that way for me. If not for you, I don’t know how to change that back to the default

[last perch]

i didnt notice that i could edit the original, i fixed it

[mortal saffron]

Thanks I dont use the mobile app too much so I didn’t know it’s auto changes the formula lol

[last perch]

btw, the profit per day, calculated for the remaining days is easy to do, but i dont know where to change, im not too familiar with this dynamic table things in excel
the remaining_harvest cell is =ROUNDDOWN(MAX(((((28-current_day)-(growth_days))/regrowth_days)+1),0)),
the profit_per_day cell is =((remaining_harvest x sell_price)-(seed_price x seeds_month))/(28-current_day)
here is it working for the sugarcane as a proof of concept:

[mortal saffron]

Thanks for that and yea I just have to visualize what cells need to go into the formula and the layout of it lol just going to take alil extra brain power lol than the others lol

[last perch]

another thing, if i select a season in the calculations sheet, the "any" crops dont appear in the table

[mortal saffron]

Yea I noticed that last night let me see if I can fix that now

I hate how limited the mobile app is lol I will have to fix that when I get home

[wide geode]

https://docs.google.com/spreadsheets/d/1X_xLAoo_COaIbu2d0NdkBeiDojyZaKSzKEU8hQ5fF3k/edit?usp=sharing

This is for the Story of Seasons: AWL Game but they have a search by day tab which might help you with this current day situation if your able to click the cells and check the formulas

[mortal saffron]

Dude that spreadsheet is a work of art lol who ever did that is amazing lol

Did they change harvesting moon to story of seasons? This looks just like Harvey moon

[radiant fulcrum]

devs change publishing partners so name had to change

that why Harvest Moon aint doing so good anymore and Story of Seasons is way better

imo

[last perch]

i read somewhere that the Story of Seasons devs are the "original" harvest moon devs from the earlier titles, they are in a different company and the old company holds the Harvest Moon IP, thats why story of seasons looks more like harvest moon than the actually newer harvest moon games

[radiant fulcrum]

Natsume owns the right to the title of "Harvest Moon" while Marvelous uses "Story of Seasons"

[mortal saffron]

Oh dam that’s crazy

[mortal saffron]

Dam lol

Because a wonderful life was my favorite harvest moon game lol

[radiant fulcrum]

theres a story of seasons remake of it

[mortal saffron]

I had a hand scripted Manuel before excel existed 😂

[mortal saffron]

Ah so that’s a remake that’s why it looks identical lol

[wide geode]

Yes. what dark said. Though there is always changes to base games to make it more modern and non copyrighted to the titled versions

[mortal saffron]

almost done with the changes will probably upload the new copy tonight. The script took forever to get it to read the right info to tell how many harvests are left to the season when you enter in what day of the season your on to be able to accurately produce the profit per day for the remaining days

[mortal saffron]

https://docs.google.com/spreadsheets/d/1SY9n9QPTLTfoI723D972lVDIPap3uqnqjPgpaBMQ8DQ/edit?usp=sharing

pretty much all set just gotta finish the instructions page but all formulas should be set

[last perch]

had a look, its looking good!
-# just wish the script didnt take that long to get the data 🙁

[last perch]

hate to be the bearer of bad news but the formulas are still not 100% correct,
just changing the day from 1 to 2 makes lots of crops produce 1 less harvest than they should when they actually should still be able to produce the same
(all/most the ones that show 27/28 growing days seem to be affected)

[mortal saffron]

Ugh I was only testing with day 1 lol ok I’ll look into it

[mortal saffron]

Yea ik but the script is 700 lines long so it has a lot to read lol

[mortal saffron]

@last perch hey I’m doing the maths for the day of season and harvests left and everything on my end is fine what crops aren’t matching? I did all the crops in spring and they were fine

[last perch]

every single-harvest crop that has the Growing days value at 28 is wrong.
starfruit/cactus(13,x): 1->14->27
beet/rose/sproutfruit/chard/radish(6,x): 1->7->13->20->26

all of those show the correct harvest count at day 1, but on day 2 and all of them get 1 less harvest.
(as you can see on the attached screenshots)

[mortal saffron]

Well if they have 4 harvests from a full 28 days and you take one day away then that will be 3 harvests

The calculation is 29-1 days because you can still plant on the day you enter in the box

So that day doesn’t count towards the amount of lost days

[last perch]

will copy-paste this again incase you missed it:

starfruit/cactus(13,x): 1->14->27
beet/rose/sproutfruit/chard/radish(6,x): 1->7->13->20->26

all of these show up as 28 full days.
none of them end on the day 28 so something is wrong there

2 ending on day 27 gives you 1 buffer day so starting on day 2 should still allow all harvests,
the other 5 end on day 26 so you have 2 buffer days
yet all of them show up as 28 growing days

i think the issue here is not on the equations to get the harvests but more on the fundamentals.
you use 28alot in your equations, and because of that you add a few +1 in some places.
actually a season only has 27 days to grow things, you start on day 1, on day 28, 27 days have passed.

all your crops have the "Total days" as "growth days" +1. if you switched the 28with 27and skipped adding this extra +1, everything would work out just fine

[mortal saffron]

So what equation are you thinking is wrong because if you take a radish grow time it’s 6 days but the first day don’t count so you harvest in day 7 28/7= 4 you plant on day 2 that’s 27 days that’s only 3 full crop cycles

[last perch]

let me give you a clear example:
starfruit: growing days = 13, total days = 14, total harvest: round(28 / 14) = 2, growing days: total_days x total harvests = 14 x 2 = 28
so according to your math starfruit has no buffer days, if you plant on day 2, then you only get 1 total harvest.
this is wrong

radish works exactly the same

and i'll explain why

[mortal saffron]

Wait if there’s no buffer days and you plant on day 2 you will only get one harvest

[last perch]

correct

the problem is that you math is saying that there is no buffer days. but in reality there is

lets plant them on day 1
starfruit has 13 growing days so: 1 + 13 -> 14, harvest on day 14 and plant again
14 + 13 -> 27, harvest on 27

[mortal saffron]

So where are you saying the buffer isn’t being applied?

It would be 14 + 14

[last perch]

no

[mortal saffron]

There’s no regrowth

[last perch]

but its never 14 in the first place

[mortal saffron]

It’s a new seed

[last perch]

thats where its fundamentally wrong

but it never takes 14 days

start on day 1 and 13 growing days doesnt mean it takes 14 days

[mortal saffron]

But we tested the growth times when you plant something it harvests the day after the full grow cycle

It grows for 13 days and harvest on day 14

[last perch]

exactly

[mortal saffron]

@radiant fulcrum tested the growth and harvest days

So if they harvest on 14 then 28/14 is two

[last perch]

so its the "planting day" + 13, 1+13 =14, what if you plant on 14? 14+13=27, not 28

[mortal saffron]

But it’s two seeds correct?

Each seed harvests on day 14

14*2=28

[last perch]

no

[mortal saffron]

Ohhhhhj I’m dumb lol

[last perch]

you harvesting on day 14 means that 13 days passed

because you started on day 1

[mortal saffron]

lol dude my brain is hurting 😂

Right yea I get wat your saying now lol so there’s technically a buffer for each harvest

If you plant the same day you harvest

[last perch]

yea, you plant on day 14, same day you harvested, then add 13 days to that. its now day 27

so if you started on day 2, 2 + 13 = 15, harvest on 15, plant again, 15 + 13 = 28, its now day 28, harvest

its not 15 + 14, which would make it go over season

[mortal saffron]

So technically there should be no +1 in the total days column on the crops sheet

[last perch]

yup, which makes that column kinda meaningless xd
-# for the regrowth crops its adding +2, which is even worse xd

[mortal saffron]

So the +1 only really effects all crops with regrowth days

[last perch]

nope, not even those

[mortal saffron]

Well if it take 4 days to grow then 2 days to regrow and you harvest on day 5 then the second harvest is on day 7 and not 6

[last perch]

correct

[mortal saffron]

So the +1 is only for the initial planting

[last perch]

no

[mortal saffron]

Not every regrow cycle

[last perch]

just remove the +1 from everywhere

and assume that a season has 27 days to grow stuff and not 28

[mortal saffron]

Ah ok I think I see where your going lol

[last perch]

lets look at the starfruit example from before, 13 growing days.
with your math, it was 14 full days, round(28/14) = 2 total harvests, 14x2 = 28 full growing days, (28-28) = 0 buffer days

reality:
13 days, round(27/13) = 2 total harvests, 13x2 = 26 full growing days, (27-26) = 1 buffer day

you were confusing the start of the season as day 1 with having to add +1 to the growing days because something that took 13 days was harvestable on day 14, so the math looked like growing days +1, this bit was wrong and messing up lots of things

[mortal saffron]

Gotcha ok then well looks like I got a lot more work to do now lol

[last perch]

another example:
beet has 6 growing days, your math was saying it took 7 full days, so 28/7 = 4 total harvests and no buffer days.
it should be: 27/6 = 4 total harvests, 4x6=24, so actually a whole 3 buffer days

1->7->13->19->25
as you can see, from the day you plant to the day you harvest, its always +6 and not +7, which is in line with the growing days value that the game shows

[last perch]

this was making some crops have 1 less harvest even at day 1, like rice / garlic/ red cabbage / cotton / lily / pineapple

[mortal saffron]

Right gotcha I understand now

[last perch]

i went ahead and fixed all the equations for the columns in the crops sheet, they all show the correct values now, some were still showing wrong results in the total monthly harvests.
the only thing left is fixing the scripts, i can also do that if you want.
or also if the equations arent to your liking, feel free to revert my changes and fix them in a way that makes sense to you
-# i did it in a way that made sense to me xD

[mortal saffron]

Awesome I appreciate that and if you know how to mess with scripts by all means lol I’m not home and can’t access scripts on mobile and yes I’ll take a look when I get a chance

[last perch]

done.
-# i also found a bug in the calculations for the regrowth crops, if the remaining days were enough for a growth cycle, it always returned 0.
-# it was using the totaldays value for that (lets exclude the +1 or +2 from before), and in regrowth crops, that includes 1 regrowth cycle, aka, 2 total harvests. so it was either 0 or 2+, never 1.

[mortal saffron]

Ah ok I think I understand lol

[last perch]

i tested a few different days with all the crops i mentioned, it seems to give the correct remaining harvests.

[last perch]

imagine its day 20, so 7 remaining days, and a crop has totaldays 10 (6 growth + 4 regrowth).
there was an if checking remaining days < totaldays, so 7 < 10, and return 0. and the else was a floor with a +2 at the end, so either it was 0 or 2+, never 1.
this is wrong because this regrowth crop can give 1 harvest.
i rewrote that.

found a bug on calculateProfitPerDaysLeft(sellPrice, seedPrice, harvestsLeft, d2Num);
it doesnt specify if its a single-harvest or a regrowth crop, and inside the function you're treating as if it was only 1 seed used.

[mortal saffron]

So it’s only calculating regrowth crops then

[mortal saffron]

I think that +2 was when I was thinking regrowth days had an extra day before they were harvested plus the extra day from the plant day

[last perch]

yea, but you were using that function for all crops

here, day 1, the profit per days left is way higher than the profit for the whole season. they should be the same, its day 1.
those that are higher are the single-harvest, the function was only using 1 seed in the calculation instead of the required amount

now, as you can see, the profit per days left is the same as the profit for the season, as it should be on day 1.

[mortal saffron]

Ahhhh ok then yea I see now

[mortal saffron]

Thank you for that, this has been a crazy project lol

[last perch]

couple of suggestions regarding the search:
is it possible and/or worth it to make that search include various things, like if i were to search "sugarcane, pumpkin" it gives the results for both
also, is it intended or a bug, if i search for "sugarcane", "cane nectar" doesnt appear even tho "sugarcane" is the ingredient

now that we got the crops working as it should, time to fix the other sheets xD

i dont know if you automated or did it manually, but there might be prices that are wrong.
one i know for sure is the cane nectar, it sells for 20 and not 50.
http://coral.guide has the correct price, the wikis are using outdated prices from an earlier version

[mortal saffron]

Yea the script only pulls the word that is written in the cell so if you typed cane it should show everything with cane in the word but I’ll have to fix it so it finds every item even if it’s a partial match and Yea I used the wiki lol

And chat gpt cuz I don’t want to spend hours typing prices lol

[mortal saffron]

fixed the search bar only pulling actual name now if you type can sugarcane will pull up too

[mortal saffron]

how long do trees take to grow? wiki says 28 with 4 regrow but the guide says 25 with 1 day regrow

[wide geode]

Trees take one day break between harvests but grow withing 25 days depending on the tree type. there are fruit trees, Actual Fruit/nut trees that are 1 tile and then there is the basic farm trees

[mortal saffron]

Thanks yea we had a discussion yesterday in the normal chat about it lol the guide wasn’t accurate

[wide geode]

How is the spreadsheet? I noticed a few changes from last time but the calculation sheet still is funky

[mortal saffron]

Been working doubles and haven’t had much time to work on it. But I thought I had the calculation sheet all set what’s up with it?

[wide geode]

It shows the crops first and not really show the top overall items like it was. Not only that but it used to have something with the profit over season for all artisan goods too but I think that was removed which is why it is having issues

At least the second half I thought was there

[mortal saffron]

It seems to be pulling up all crops and artisan goods for me. It will only put the crops at the top of you enter in a day in the day of season cell since crops are the ones affected by the day of season

[wide geode]

Oh ok

[mortal saffron]

I had to unfilter the sheet it was only showing certain items so maybe that’s why you couldn’t see anything

[peak rock]

does the sheet include ocean crops?

or is there a different sourdce for that somewhere?

[wide geode]

Haven’t looked specifically for those in the sheet since I’m not there yet but since they used the wiki starting off, it might not be there. Though they commented work been busy so I assume they’ll add it later

[mortal saffron]

No not yet it only includes the byproducts of the ocean crop I will hopefully have some time to work on it tomorrow as well as fixing some prices. Was told that some selling prices were off.

[mortal saffron]

Correction yes they are in there they were just filtered out at the time I looked. Also all prices should be accurate now and all items should be in the sheet for each machine listed. I think the only one missing now is the mayonnaise machine