🧮 Comprehensive Guide

[arctic fable]

I just tried running init timers again to see if it maybe re-grabs updated info

[buoyant cloak]

SilverEarCuffs is a 4/5 peak, so it's possible the sheet thinks it's pre-peaking and therefore usable

Idk, I should stop trying to debug. I don't know the inner workings

[arctic fable]

so wait on Leiton to chime in?

[buoyant cloak]

Yeah, probably

[arctic fable]

k, should I ping or will they see regardless?

[buoyant cloak]

The point is that Scythe is peaking tomorrow so there's reason to have it in recs

He'll see it

[arctic fable]

yeah, that I can get, just confused that it's thinking values are basically opposite

[buoyant cloak]

I'd believe that Brush - Scythe - Silver - Scythe is actually worth more tomorrow than the rec

The thing is that we don't want to use Silver before its peak

Because we're almost certainly gonna use it later in the week for way more money

[arctic fable]

got it

I'll go with the channel rec for now then unless Leiton wants me to try something later

[buoyant cloak]

Judging by the talk in #1035334923164327976, it looks like Silver was discussed for today, but it shouldn't be used

So I think the sheet's recommendations are what other people got as well

[arctic fable]

in that case, should I try checking silver as an imposter?

[buoyant cloak]

Imposters are only for C1 and they determine it's C2 peak

We know all the C2 peaks at this point

[arctic fable]

ah

[buoyant cloak]

I'd just put in Corn - Radish as your rec and wait for Leiton to chime in about why it recommended Silver

[arctic fable]

thank you 😄

[cyan kernel]

I don't have a smart-value system in place for Big 9 items yet. Next update will have it when I get time to do coding.

[arctic fable]

IOW the current solver basically can't take into account that it can make even more by using that item later in the week?

[cyan kernel]

Correct

[arctic fable]

👍 thanks for clarifying 🙂

[quick wyvern]

to be clear, what you craft only changes supply for that item. Everything else will continue to be the same as every other player's island. so the only way to "ruin" anything would be to craft something early, raising its supply before the corret day. And it wouldn't "ruin" the whole week, it would lower value for a single day at worst

[brittle lava]

that's reassuring to know, thank you. :> i'd like to think i understood the basics, i just wanted to make sure if i can go according to plan at a later point and do what's possible with a low rank and only a few materials until then, so that i can still benefit from exp and cowries without making a mess of things.

that only a single item is affected - the one i craft - is good to know, 'cause the guide made it sound like the whole statistics will change. /'> and if the effect isn't that bad in general, i can also start in the middle of the week, with minimal lower value gain perhaps. so thank you for clarifying further, much appreciated. <3

[quick wyvern]

the supplies do change throughout the week, but in the same way for everyone (except if you craft some, then yours will be that many higher)

but yea you can always join in part way through a week

[brittle lava]

of course, due to items being crafted - makes sense. :> but if i choose another item to craft that's not on the list, only the supply of that specific item will change in another way than calculated, not the supply of the rest, if i understood you correctly? (sorry, english isn't my native language. 🙈)

[quick wyvern]

basically, yes

example: supply of FakeItem started at 4 for the week. You craft two, so your supply is now 6. Then on c2 the supply for everyone drops by 4. Now everyone else's supply is 0, while yours would instead be 2.

(the game uses different internal numbers, this is just for an example)

[brittle lava]

ah, i get it, it's simple math. will the popularity and demand stay the same for everyone else, too, though, no matter how i stockpile supplies?

i thought i've read something about preventing 'overflowing' as to not lower the gain.

[buoyant cloak]

If you make a lot of an item in the workshop, its supply will go up, and it will be worth less

But only the items you're making

Popularity doesn't change over the source of the week. Only supply

We get new popularity next week

[brittle lava]

ah, okay. it all makes sense if you think about it, it just sounds unnecessarily complicated at first. 🙈

you're doing gods work here, i'm glad this discord exists - there a few things more frustrating than not getting the hang of it and googling the hell out of it but not finding a specific answer for your specific questions.
so thank you all for lending a helping hand. 💕

[buoyant cloak]

I feel the same way. A lot of the time I want to know a really specific technical detail and I know people know it but it just isn't out there! Glad to help! :D

[dense tulip]

I'm trying to use the Spreadsheet again to figure out what I should put for the remaining days of the week, since I won't be able to set them

I am trying to use the automation, but I'm having trouble getting it to work

It says this:

[chrome basin]

It literally won't work without C4's info

[dense tulip]

I'm just trying to get it to pull in the information we have on popularity and previous peaks

I'm not expecting it to generate recommendations for me

[chrome basin]

Oh, do you have the "READ BEFORE USE" tab still?
If so, be sure to follow it

[dense tulip]

I followed it

[quick wyvern]

website seems fine

I just swapped my sheet to auto, it is working 100%

[quick wyvern]

the systems are up, is this a 5.4.2 sheet?

if so and you're sure you ran all the automation setup steps properly, try a fresh sheet

[dense tulip]

no this is 5.3.11

should I be using the Beta?

[quick wyvern]

I have a 5.3.11 sheet, one moment...

my 5.3.11 sheet also works

[dense tulip]

I did it again with a fresh 5.4.2 sheet, nothing happened

oh jk

it just showed up

🎉

alright time to do an absolute horrid job at making up something for the next few days

[quick wyvern]

probably is rest c5, then craft like shark oil c6 and whatever the other average granary was c7

[dense tulip]

oh I see there are some things in #1035334923164327976

that come with a giant warning not to use them but hey

my sub is running out and I want to go on break for 2 weeks

seems to be life EV optimal to put those in and not think about it

[patent cliff]

If you can wait 4.5 hours (or tomorrow, or whatever) we will have the full regular recs for the rest of this week, and then #1042986590370275398 for the next week.

[dense tulip]

alas, I believe it's going away tonight?

but anyways I appreciate the work y'all do!

[patent cliff]

Took me a sec to parse that. Your sub is running out tonight? Then yeah, just go ahead with the guesses for this week, and then this thing for next week: #1042986590370275398 message

[quick wyvern]

5.4.2 recommends rest on c5, on manual mode for this week

which is...a bit odd

oh it's presumably because it wants to run almost the same agenda twice, on c6 and c7, for whatever reason

[arctic fable]

oh, yeah, it's quite different from bot-recs

[bleak shale]

Guys, how does value (big blue) cell and rest recommendations work? I am using v5.3.11, cause while following reddit posts is faster and easier, I prefer to have freedom of controlling how much of each materials/ingredients I have. Today I noticed something weird, my spreadsheet recommended me rest on C5 and since reddit post recommended rest on C6, I got curious, cause so far rest recommendations were always the same. So I started setting rest in different days and putting agendas. In the end I saw that guide recommended me rest on C5 while the lowest value from items was on C7. Why? Does amount showed in value is not the same (or at least very close) to amount we will get after finishing the cycle?

Also, while I gathered courage to start asking: sometimes I see that agenda recommended by guide changes while I am inputting it, f.e. guide shows me that I should go with agenda1 and after I put f.e. 2nd item recommended agenda changes completely, usually for actually better one Oo At least according to value showed in guide.

Sorry if I am trying to simplify some things too much xD

[waxen pendant]

Now, second

https://discord.com/channels/1034534280757522442/1035744302699134986

Check this research

It has everything regarding how breakpoints works

It`s the answer to why the sheet change the recs once you input some craft on the workshop

[bleak shale]

Sweet, I'll read it and if i'll have any more questions. I'll ask them here 😄

[patent cliff]

The other bit as far as why reddit or #🦜︱recommendations might have a different answer is that those are done by hand, cross-referencing multiple different tools. None of the tools are perfect, yet. So the spreadsheet might have one thing, but the bot has something different, and the human looks at both of them and says "oh, the bot is better this time" and publishes that one.

[bleak shale]

No, no, this I understand. I was more curious why my guide showed that rest is recommended on C5 while it also showed that C7 will have lower value from recommended items.

[quick wyvern]

be careful here. c7 should not be the day with lower value, but c6

the reason c7 would be lower value using the sheet is if you follow the sheet's recs entirely blindly, and use c7's main stuff on c6

I was actually wondering about this earlier if you scroll up a little. I'm not sure of the exact "why" details, but the reason it recommends c5 rest is becase it thinks it can use almost the same recs on c6 and c7 and get away with it

[bleak shale]

For C6 I have Firesand/Juice/Formula/Juice and for C7 I have Clam/Oil/Clam/Oil, looking at the reddit post, it can be the issue

[quick wyvern]

my version did not recommend clam/shark lol

but anyway the reason it would be recommending clam/shark for c7 is because you just used its best option on c6

[bleak shale]

Mine changed to it after I input 2nd item from original agenda and this one, according to value, is better xD

Original was Potion/Juice/Formula/Juice, the same as on reddit xD

Tbh, I kinda follow guide blindly (as I am not good in analysing stuff, truth be told, i'm still amazed someone got enough skill and time to put a massive speadsheet that thinks for you Oo), only changes I make are to check the reddit agendas and if agendas change while I'm inputting one and then I'm using one that shows the highest value

[quick wyvern]

still not sure why you don't just follow #🦜︱recommendations or the reddit/twitter blindly instead then for better results

after a certain point you have a surplus of all resources so...

generally a week or two after you hit cap

anyway the source of the issues is likely related to an issue with calculating the value of the vegetable juice agenda. the base value of that agenda does not match the other solver's results for the same agenda in this case

it's probably a bug

oh

oh no I'm dumb, right, the values above are correct for a "growth formula c2" user

@bleak shale did you use growth formula on c2?

[bleak shale]

I was worried at beginning that following them will leave me with not enough mats to do others or to craft feeds so I make a habit of filling up spreadsheet, then checking my resources then changing or leaving as it is. But as we talk and I read and I see my resources right now, I think I'll not have to worry about stuff like this at least till next IS patch

[bleak shale]

3 times

I mean I put it in agenda 3 times, not 6, like this:

[quick wyvern]

well for the main agenda, which did brush - spruce on c2, the sheet still recommends rest on c5. I'm honestly not sure what the source of the bug is though

if you follow what the sheet wants to do, it gets a combined total of 9072 cowries for the last 3 days

but if you force the solver to rest c6, it then solves for 9780 for the same 3 days

[bleak shale]

I see. I think I'll just follow posts and return to worrying about resources after next IS patch (I think it'll be 6.3) depending on what changes SE will make

[patent cliff]

If you're gonna follow anything blindly, follow #🦜︱recommendations . The solver at this point is for people that like getting their hands dirty, it's never really been the best tool for just fire-and-forget. And if you're managing your pasture/crops/granary reasonably, then all the rare mats are easily at a long-term surplus.

Sorry, apparently didn't scroll all the way, so some of that is redundant. Point stands, tho.

[brave pasture]

Hi, just started island sanc yesterday. I have just unlocked workshop I and tbh I am confused on how to use the workshop/workshop solver in the comprehensive guide. I did see from the reddit which my friend provided the list of recommended items to be gathered in the workshop. but when i looked in the workshop solver, it says cycle 2?

[chrome basin]

If you're trying to solve for C7, you need to check the "Check When Done" boxes down to C7

(sorry mine's in dark theme; it's the column just to the right of your picture)

To save on time, the spreadsheet only calculates one cycle at a time. When you check the "Check When Done" checkbox for C2, it then solves for C3. If you check C2, 3, 4, 5, and 6, it'll solve for C7 (the current cycle)

[brave pasture]

ohhh i see it now!

[chrome basin]

Also something to note: You want to set your agenda a day in advance or you will lose time on your agenda (e.g., setting your agenda right at reset loses you the first hour, which is quite a loss on your total income). This is why we use C1's data to solve for C2, during C1, to give people nearly 24h in advance

[brave pasture]

i see i see. so this is why in the reddit post that c1 and c6 are rest days?

[chrome basin]

So C1 is ALWAYS a rest day, forever, because C1 sucks and we cannot use any information to solve for it. Plus, no items are peaking on it.
C6 was just the worst day of the week based on the data.

[brave pasture]

[chrome basin]

We typically set our "next season" rest cycles to 1 (because always 1) and 7, and the 7 you just adjust to the day we say to rest in #🦜︱recommendations

But because you just started, you probably can't follow Recs to a T yet (some recipes unlock at Rank 9, plus rare materials, etc)

[brave pasture]

yes my friend told me since it's c7, best I can do for now is gather mats and set the rest days

since it's already late and the current season is done

[chrome basin]

Yup, though definitely try to get some out of today so you can use them next week

[brave pasture]

thank you!

[brittle lava]

Is it completely random if you catch a rare animal or can you improve your chances by coming from behind, hiding behind a tree and such?
couldn't find anything to that matter and i'm frustrated to no end by now. />

[cinder veldt]

there's no rhyme or reason. anything you see like 'stand behind it' is entirely anecotal

eventually RNG will shine on you

[brittle lava]

okay, so no technique but simply random.
let's hope for the best. 🥹 and thank you!

[brave pasture]

hello! what does these stuff mean? I'm not seeing it at the reddit post of the recommended items per cycle

[arctic fable]

there's a few things the sheet can't handle yet

iirc in particular items that might have a better peak later in the season

looks like today's main rec is Squid Ink - Shark Oil - Squid Ink - Shark Oil

(see #🦜︱recommendations )

[brave pasture]

the items in here have better peak than the recommended?

[arctic fable]

yes, but the thing is that they might have a better peak than today if used on a later cycle

that's a situation the sheet can't handle yet

[brave pasture]

ohh i see

[arctic fable]

e.g. an item might peak on both say, C4 and C6

by C6 you have more groove built up

so it'd be better to use it that day

[brave pasture]

i cant see squid ink in here though. does that mean i have to level up my sanctuary to obtain the items?

i just started last week on wednesday

[arctic fable]

yeah

that one's a later level

[brave pasture]

agh

[arctic fable]

you're missing a bunch at this point

[brave pasture]

guess i have to level up first

thanks!

[arctic fable]

np

for now pretty much don't worry about trying to optimize, just make sure to keep the workshop busy doing whatever you can for exp

[brave pasture]

okie!

[arctic fable]

the important thing is to just have them producing constantly 🙂

[brave pasture]

got it. thanks!

do i choose any of the items?

[arctic fable]

ideally ones that do have a groove

err

not groove

but can chain off each other

if there's something further down in the sheet's recs that you can do, then go ahead and use that

[brave pasture]

i'm

i'm lost sorry i dont know what u mean by groove and chaining off

[arctic fable]

so if you look at each item in the list

you'll see it has certain categories attached

if you set your workshop to craft 2 different items in a row that are in the same category, you'll see the second item is marked "efficiency bonus"

like this

[brave pasture]

i see i see, i'll try!

[arctic fable]

you get more money and exp by setting that up that way

and that's one of the things the sheet solves for

groove is just something you build up by producing (you'll see your current groove in the top right corner)

and it gives an added bonus to how many cowries you get for making things

that's why it's important to just keep the workshops busy, if they're idle/resting, they'll lose groove

that's unavoidable overall because you have to have two rest days a week but in general...

in any case, the eff bonus is why you'll often see recs that are the same set of items back to back like the above ink -> oil -> ink -> oil, since they get bonus off each other

[brave pasture]

oke i understand, let me try this. thank you!

[arctic fable]

np, hope that helps

FWIW, https://discord.com/channels/1034534280757522442/1034960890178588763 has a ton of detail about how it all works

[cyan kernel]

If you aren't max level, you can't directly follow the regular recommendations. The sheet is built to only give you the best of what your island can make. So make sure your My Island tab is updated, and it'll have the best info.

[quick wyvern]

that's definitely not what their problem was

[arctic fable]

hm, that's the explanation I was given last time the sheet didn't match recs here

[quick wyvern]

and it may have been correct then

but their sheet rec is boiled egg hora

bruh

[arctic fable]

🤷‍♂️

[cyan kernel]

Ye that's a case of low-rank recs

[quick wyvern]

yea I can only assume they have shark oiled unchecked

or something

[cyan kernel]

Low-rank recs will always be super weird, cuz they have to make due with what they have

[arctic fable]

I honestly didn't use the sheet until rank 10 so I've never seen it in low rec mode 🙂

[quick wyvern]

definitely not a sheet bug

[arctic fable]

yeah, I didn't realize until later that they were at low rank still

I forgot you can customize sheet for that

☕

[brave pasture]

ah yeah, still grasping the comprehensive guide as i only started last week

or was it this week

i really cant track anymore

[arctic fable]

we didn't have any imposters to set this week btw did we? sheet is recommending brush -> oil for me rather than ink -> oil

[rose dagger]

we didn't bother with imposter testing cause garnet was a guaranteed strong for c2

[arctic fable]

yep, just trying to understand the rec discrepancy this time

[cyan kernel]

That's because we're 100% using Brush later in the week, so we don't want to lose the value

[quick wyvern]

yea now THIS part IS the "we're saving it for later" bit

[arctic fable]

ah, so this is the same peak issue as last week

[quick wyvern]

well sort of

we might need it as a link for later

[cyan kernel]

I've been too busy to get it fixed sadly, I'm hoping I can get it done soon

[arctic fable]

np

I mostly just report these in case legit bug rather than solver shortcoming

as a dev, I'm painfully aware of how much actual data helps

[cyan kernel]

Oh yeah no it helps for sure

[arctic fable]

that said, my area is currently TLS, not so much excel formulas so, very different kind of data gathering 🙂

[cyan kernel]

Right now there are only four issues

1: No groove movers in the algorithm, have to solve manually. No possible fix outside of building an external solver.

2: Doesn't save items for future peaks when it would be more profitable to do so. Gonna take some work, but I know how to do it.

3: Low-Rank players see "Rest Recommended" every day, practically guaranteed, cuz they can't hit top values. Easily fixed.

4: Rest recs for C4/C5/C6/C7 aren't as precise as I'd like them to be, but honestly I don't know if I can make them better with Sheets' limitations.

Beachcomber and Recs Bot have FAR more processing power to work with, so they can solve multiple days at a time, and then just pick the lowest.

I can't solve more than one day without Google's servers melting down, so I had to come up with an algorithm for determining estimated day values based on cowries/hour and peak/prepeak/postpeak for set combos.

So it'll get the rest day right like 95% of the time, but any days with weird agendas or days that are SUPER close, it has a chance to get messed up.

It'll never be a big loss, and right now Mienna has the only solvers that can do better, so it's not too big of a deal, but I refuse to lose 🔪

[quick wyvern]

does Ciena's solver also do pretty well?

[cyan kernel]

I haven't checked its rest recs

[quick wyvern]

not sure if it actually does a rest rec as much as just shows agendas and ciena makes a judgement call

so fair

[cyan kernel]

At least not since Ciena first introduced it, and it was still wonky back then

[arctic fable]

wait, Sheets doesn't use client-side JS to do the actual solving? o.0

WTF?

or am I misunderstanding that?

[cyan kernel]

Nope! It's server-side. Otherwise it wouldn't be able to use the apps script and auto-solve without the file ever being open.

[arctic fable]

I didn't realize it could without the file being open, it always seems to defer updating until I actually switch to that tab that day

so I assumed it was client-side

yow

I'm going to guess you wouldn't have that issue with actual Excel + macros

[cyan kernel]

Nah, Excel was only marginally faster

It's inefficient as all hell :(

[arctic fable]

I mean, yeah, only so much you can do with VBA and such

oh well, it's what we have to work with I guess

[cyan kernel]

The only way I can get past Google's limitations at this point is to build a separate solver

Which

No

Not when Mienna's already built a fantabulous one that does almost everything I would want my own to do

[arctic fable]

remind me, hers is a dalamud plugin iirc?

[rose dagger]

yes, you just need to enable testing builds for it iirc

[arctic fable]

yeah, I mostly play on a PS5 to be honest, so that's not actually an option for me

just wondered if I was thinking of the right plugin

[rose dagger]

ah, gotcha

[patent cliff]

Beachcomber for Dalamud yes. But also a standalone (java?) used for testing purposes and built into the recsbot.

[buoyant cloak]

Yeah, at the moment it's just something I have personally and recsbot

Who has been doing great this week!

Good mammet

Once we get a website up and running the algorithm should be accessible to everyone though

[tender bough]

I somewhat lament the bot being named "Pathfinder Mk0" instead of "RoboParrot"

[brittle lava]

Is it enough to feed the animals once a day or is it necessary to feed them twice? 🤔

[waxen pendant]

Are you this same Jessidhia?

[tender bough]

yes

though I didn't make that one, I just keep it working through Dalamud updates 😇

[waxen pendant]

Thank you for your work! Was tired of dying to my wife turning on the TV

[buoyant cloak]

I appreciate the updated meaning of "wife aggro"

[waxen pendant]

Now you got me thinking if it was on purpose

[muted kayak]

hello I have the spreadsheet but not sure how to use solver. I activated Automation (next to Help word) but it is still empty thanks

[muted kayak]

I also clicked on "Manual <> Auto " a couple times but I can not tell if it is in Manual or auto mode. the readme says, "via Change Mode menu to swap between them anytime" . I can't find Change Mode menu in the document menu.

I see "manual <> auto" here but nothing in menus called "Change Mode"

• each time I press on Accept terms, it completes. until a little while ago, in which it gave a Red warning about triggers.
• clicking on words Manual <> Auto does not seem to do anything. so I'm not sure if I'm in auto or manual .

after pressing accept terms several times now I get some new warning message

no idea how to delete these extra triggers.

[atomic apex]

Workshop tab tells you current mode at top left

[atomic apex]

this is a do it once ever kind of thing >.>

sorry technically twice, one to accept the google security thing, then once to actually do it. they are split in 5.3 though to make it easier

[atomic apex]

at the top, go to Extensions->Apps Script
On the left, hit Triggers (alarm clock symbol)
you'll probably see a LOT of triggers.
go through and delete them ALL, then go do the accept terms thing again, and...dont do it anymore after that

alternatively, delete the sheet and copy a new one

[muted kayak]

yes it says Automatic on workshop tab, I didn't know to look there sorry, I only looked on Solver page

[muted kayak]

good then this is done/activated step, only weird thing is on my river gmail account I got permissions to work but on my alt email account I could not get permissions on automatic script to go through. but it's fine for now if even River account can work.

[atomic apex]

well, if its giving you the red thing its probably got a ton of triggers and they shoul dbe removed

[muted kayak]

this is what I see on triggers

[atomic apex]

yeah, it should have 2 lines, i would delete them all and then run the thing once again

my screenshot above is how it should look

[quick wyvern]

or make a fresh sheet and only click the right number of times

[muted kayak]

deleted all triggers, Automation script now runs with no red trigger errors . rechecked triggers and it is only 2 now called Head like yours.

now that that is done how do I get solver page to show cycle 3 ?

[quick wyvern]

check off cycle 2 as done.

[muted kayak]

do I need to refresh or reopen it?

should these Agenda boxes be checked? not sure what they do

[muted kayak]

I did that originally but the solver would not show anything so I tried opening and closing the document and other things as well to get it to show stuff. since I thought it would be good to at least try and restart document first to see if it was anything simple. The method XurKane showed was the best advice since now I also know about triggers location.

There is no need to do fresh sheet which would be worse since I added a bunch of personal notes and stuff to this sheet, and now it seems to work except the results do not match what beachcomber app says.

thanks @atomic apex now I'm investigating why Beachcomber does not show same results as Spreadsheet.

[quick wyvern]

you only needed to know where the triggers were, because you successfully spam ran the script so many times that you overloaded it.

[muted kayak]

yep and now that Xur Kane knew where they were that helped a lot.

[quick wyvern]

as the heading of the column says, either you are running one agenda on all three workshops, or you aren't.

[muted kayak]

does agenda mean do same thing on all 3 workshops?

[quick wyvern]

what

[muted kayak]

the spreadsheet short word terms if I check the box does it mean do the same thing in all 3 workshops?

I have it checked now but it does not auto fill it in if that is what Agenda means.

it's still empty or do I need to do it manually?

[cyan kernel]

You'll need to fill in the agenda from the dropdowns. Since you're doing all of the same agenda, you can just input the one row.

[muted kayak]

ty now I see data in lower left with images of the items. I'm not sure how this Solver page works.

• what does the Red box do exactly "Refresh the v sheet v" what does "v" mean for v sheet v ?
• For "This Season's Material List" is there a way it can check the inventory I have in the game automatically or do I need to manually enter this somewhere?

[cyan kernel]

It's just arrows pointing down. Untick and retick the box to refresh the solver if you're ever worried that it isn't functioning properly.

You can enter your inventory on the My Island tab.

[muted kayak]

ty

[quick wyvern]

@austere jasper

workshop tab should look like this.

[austere jasper]

yeah that's what I've got

[quick wyvern]

so it's working then

well

why does yours say potion is low, and mine says it's very high XD

[austere jasper]

there's the mystery lol. not sure

[quick wyvern]

is yours 5.4.2 or 5.3.11

[austere jasper]

5.4.2

have one open of 5.3.11 as well I can check. It says very high

[quick wyvern]

yea idk both of my copies have the correct data lol

both versions

might just want to make sure all the fields are clear, or maybe download a new copy lol

anyway after that you'd just uncheck anything you don't want to craft, then go to the solver page, check off days you are "done" with, and see what it solves basically.

it won't know to save things for later though

so uh...use your best judgement 😛

[austere jasper]

lol, I see. Trying that now

alright that seems to work. I suppose the only remaining question is whether or not the recommendation list is ordered by value in descending order?

[quick wyvern]

should be yea

[austere jasper]

alright cool, thanks. Finally have a solution to my rare mat problem working here

was beginning to think I'd just have to guess and hope for some cowries to roll in

lol

[muted kayak]

I'm getting Boiled Egg suggested for C5 but I believe that is incorrect based on what Cienna posted

is there something I could do to fix this so it shows correct C5?

[quick wyvern]

this isn't your answer, but it looks like you have values in the black squares, which are inflating your numbers

5253 is too high.

should be 4833

[muted kayak]

let me make it all White and see ?

[quick wyvern]

don't do that X_X

just uncheck rest

delete the squares

then recheck

[muted kayak]

uncheck rest for day 2?

when i uncheck rest day 2 is empty

I never put anything in there

[quick wyvern]

weird. your numbers are too high lol.

[muted kayak]

let me restart it

[quick wyvern]

anyway I think the wrong rec is a known issue, but leiton hasn't had a chance to work on it recently.

still good to post it here just in case though

[muted kayak]

since C2 = rest day should I only have Check of Rest or both Checks in C2 ?

[quick wyvern]

one check to set as rest, the 2nd to mark it as done

so both

wait what's your 3rd day look like

you have more than 24 hours of crafts in it

that's why the number's too high XD

that should make the whole row red as an error though

like this

[muted kayak]

yes I have Exact same amount

but it's not Red

mine did not turn red color

[quick wyvern]

maybe you copy pasted?

you managed to break that protection somehow. lol

[muted kayak]

It is all from Drop down choices

[quick wyvern]

you still have more than 24 hours of crafting on both your entered days

[muted kayak]

where

C3 = butter , fingers, butter, finger, butter

I mean where is it more than 24 hours used?

there were no instructions on how to pick dropdowns so I just picked for each drop down

does dropdown not check for total hours?

[quick wyvern]

4+8+4+8+4 = 28 hours

X_X

[muted kayak]

Oic, I don't think I broke it, it should be designed to not allow a final dropdown box if you already have 24 hours

that is a design issue

[quick wyvern]

for fuck's sake

if you put in too many hours, it turns BRIGHT RED

[muted kayak]

it's not red

[quick wyvern]

on YOUR copy it isn't

[muted kayak]

you see my screen shot I got no error message and no red color

[quick wyvern]

you, somehow, disabled the feature that does this

this is not the normal way the sheet works

just yours.

[muted kayak]

I swear I didn't touch any settings except to delete triggers

anyway this chat is getting too violent for me with your swearing words so I think we should just leave it be for now.

there was no need to yell at me like that

[mild canyon]

Djinnistorm is right, though. On a normal sheet it should turn red, like this:

[muted kayak]

ya I think something is wrong with my sheet which is why I came in here for help in first place but not to be yelled at

[mild canyon]

That's my sheet and it's working properly. I'd suggest pulling a new copy of the sheet and re-entering your data on it as a fix 🙂

Not worth smashing your head against a wall to try and find/fix it

[muted kayak]

there was issue with my sheet yesterday and I thought it was fixed after we deleted the extra triggers with Xur help.

[mild canyon]

Yeah, but since there's definitely something still wrong with it - and it doesn't take all that much time to start fresh with a new copy that's going to be the best solution ^_^

[muted kayak]

I'm going to download another sheet and copy over all my notes into it. I have a bunch of notes and things written on different pages to help me understand the sections better since there are a lot of new procedures with island

[mild canyon]

Google sheets is finicky. It's suuuuuuuuper easy to unintentionally break something and finding that something is often a major pain in the butt!

[muted kayak]

I made a copy sheet page of My island and put 95% of all my notes on extra page so I didn't think it would hurt anything let me check new one I'm trying to find orginal

on the real pages I mainly just put small notes , but in "copy of my island" page I put extra columns and many things

so I was hoping my added notes on copy of my island would not interfere with stuff since it's copy inside it

[mild canyon]

Adding a blank sheet won't break anything, that's fine. Notes in existing sheets honestly could. If possible, I'd keep all your notations to a brand new tab

It would be better to just use the + button on the bottom left and make a new tab that's not a copy of anything

Google likes to try to be "smart" with copies and sometimes it can really muck things up

[muted kayak]

should I get the Beta?

[mild canyon]

That's what I'm running. I'm also new and I grabbed the beta because I didn't want to have to re-learn the sheet once it changed over to match the beta setup

[muted kayak]

there is a new item in Beta that was not in the one I had.

Initialize timers , did you click on that?

oh I see it now

I need to click it, there are updated Readme

[mild canyon]

Yep! There's the "READ BEFORE USE" tab that walks through all the important things about the sheet and that's one of the steps. However, once you click one of the options under automation (I think it's the timers one) it hides that read before use tab, so make sure to read all of it! lol

[muted kayak]

they changed the steps a little bit

[mild canyon]

Makes sense ^_^

[muted kayak]

now the Red color is working on this Beta one. I was using older version of the doc. If I use extra dropdown it stops me.

does it take a long time for you? I feel like it's a good 3 min before it updates the suggestions in the top Left corner for the Cycle.

[mild canyon]

Yeah, there's a lot of calculation stuff the sheet has to work through so it's always going to take a little bit

[muted kayak]

does your sheet also show boiled egg for Cycle 5?
this is the brand new Beta, and I have not added any notes or anything to it since the 5 min ago I downloaded it.

[mild canyon]

Yeah, without any of the data filled in for the week in the Workshop tab, mine has the same Cycle 5 recommendations as you:

[muted kayak]

cienna posted different C5-6-7 that I'm going to follow, which was confirmed also by Mienna around 1.5 hours ago.

here is post from cienna for 5-6-7 and a little bit lower Mienna confirmed it for rest of this week. #💵︱island-chat message

[floral pewter]

uh... that's not normal rec

[muted kayak]

Not sure why spreadsheet has boiled eggs for C7 and not the Earrings , it might be calculating differently than way Cienna and Mienna did it.

[floral pewter]

That's for crimetime

[muted kayak]

OH

so all the Workshop solver in this Spreadsheet assumes Crime time? this is good to know.

[floral pewter]

Normal rec matches recommendation.

idk

It doesn't look like it.

[muted kayak]

is there a way you know of to use this Spreadsheet and see same recommend that you and Mienna worked out instead of Crime Time result (boiled eggs) ?

Spreadsheet solver matched yours for C3 and C4 exactly.

[floral pewter]

well? idk

[mild canyon]

Do you have the supply and demand inputs for Cycles 1-4 input on the "Workshop" tab of the sheet (it's the tab right before "Workshop Solver")

If those aren't filled in (along with the weekly popularity) then the recommendations on the workshop solver tab won't be a match for what you see posted in the #🦜︱recommendations channel

When my sheet matched yours for C5, that was without any data filled in for the Workshop tab. Which leads me to believe yours is blank as well

[vast igloo]

the spreadsheet is just one tool. Recs are made using the best results from multiple tools which slightly different algorithms, plus some manual work, so it won't always perfectly match any single solver.

[buoyant cloak]

I have a question about the workshop solver tab in the sheet, why are there only 5 slots instead of 6 for things to be crafted in?

But it’s because solving for 6 crafts would make Google sheets explode

I think it literally crashed the page

[vapid tendon]

ohhhhh ok makes sense thank you for the info just found it odd from the last version i was using

[sharp slate]

i have the script working but it's not exactly filling everything, is that normal?

[waxen pendant]

It's C1 my friend

[sharp slate]

yes i know

[waxen pendant]

?recs

[obtuse basin]

On Cycle 1, we can predict Cycle 2 but know nothing about the rest of the season.
On Cycle 2, we can predict Cycle 3 and if items will peak early or late in the season.
On Cycle 3, we can predict Cycle 4.
On Cycle 4, we can predict the rest of the Season (Cycles 5-7)

Workshop recommendations can be found in the #🦜︱recommendations channel.

[sharp slate]

but im talking about the right side

shouldn't that be filled?

[waxen pendant]

ignore right side if automatic

that's for manual

[sharp slate]

ah that makes more sense, thanks

the popularity is the same for everybody?

oh yeah it says there, lmao

[balmy vault]

Pardon me for some dumb questions, but I haven't been able to find a detailed how-to-use guide for the comprehensive guide workshop solver. I mean do I have to manually input all popularities and supplies by hand or is it able to fetch it automatically from somewhere? Also are popularities and supplies all the input it needs?

[cyan kernel]

Check out the Read Before Use tab to set up the sheet's automation. You can swap between manual and automatic mode, and that tab explains how to do that as well. Popularity and Supply will pretty much cover all the solver needs to figure things out.

As for a detailed guide, I'll be making one for the new version coming out for the 6.3 patch update.

[balmy vault]

I followed the "read before use" tab and tried switching to the automatics mode but nothing happened. Do I have to do something else before it automatically fetches data?

[quick wyvern]

no

keep in mind it won't literally fill out the manual section

if it's working it'll look like this in the workshop tab, with the squares on the right for manual mode blank

[balmy vault]

Is it able to produce a vacation plan with popularity only then? Or is there any other tools that can do that?

[quick wyvern]

vacation plans are only /next_week in the bot_spam channel.

as far as I know that's the only tool with that functionality atm

though with the patch dropping next week results may vary

[balmy vault]

The thing is I actually play in CN servers so after next week we won't have the same workshop product list (We will still be at 6.2 then). I'm afraid the vacation plan will eventually be unusable. That's why I want to find a tool that I can custom to give vacation plans.

Thanks for the help though

[quick wyvern]

ah. well if it helps, recommendations here won't be assuming new stuff for at least a week, maybe two, after patch. After that...idk

[balmy vault]

It seems the reason automatic mode doesn't work for me is because of this (I tried to run the PullPeak function)? As far as I know google sheet app script is run on server side, so there is nothing I can do I guess?

[patent cliff]

That error looks like it means that the server that holds the peak data fell over. There is indeed nothing you can do about it.

[quick wyvern]

hmm. that...shouldn't happen

though honestly I'm not sure that was your issue before, since it was working before

[patent cliff]

Server fall over.

[quick wyvern]

@buoyant cloak server is rip?

[buoyant cloak]

Yeah, it’s been dead for a couple days

I’ve been out of town and couldn’t fix it

[buoyant cloak]

This has been my life every hour for the past 3 days

[rose dagger]

oh no

[quick wyvern]

plus one extra ping from me for the exact same reason, my bad yo

[buoyant cloak]

Lol, you had no way of knowing. Thank you for the ping! I literally asked for this!

[patent cliff]

🇫

Poor bot

[waxen pendant]

Memets uprising

[waxen pendant]

@cyan kernel did you add the new animals to the My Island tab? I'd like to mess up a bit with new setups

[cyan kernel]

Haven't yet no, still doin stuff

[waxen pendant]

It's aight, just wanted to check

[cyan kernel]

I'll get it updated in the next couple days. All the information is there, I just gotta make it look pretty

[waxen pendant]

Ye no worries, i was jst looking for a tool to play with

[atomic apex]

@cyan kernel 10 new crafts, 7 new materials

[woven cosmos]

I have enabled the scripts for the spreadsheet. It shows to be in Automatic mode. Popularity and Supply remain blank after Initialize Timers. What am I missing?

[cinder veldt]

the data that automatic mode needs depends on plug-ins working. for the time being, using #🦜︱recommendations is suggested

[atomic apex]

technically it depends on packet capture, which is entirely borked atm

with no ETA in sight

[woven cosmos]

Ok, so for now, its not me...its them 😉

[atomic apex]

hmm, @buoyant cloak is it possible to have the bot update the database based on the peak data you're manually giving it?

that way the spreadsheet will work

[buoyant cloak]

Not automatically....but I could make a command to push it.

[buoyant cloak]

Okay, I did it

And updated the db to look for 60 items

[cyan kernel]

update v5.5.0 is Complete.

The following tabs are fully updated with the new information, except for maps. (I don't make them myself, I wait for someone with more artistic talent to make something that looks nice)

• Ranks
• Gathering
• Cropland
• Pasture
• Animals
• Buildings
• My Island

Additionally, Secret Project 3 has been updated to include the new material and workshop icons ( @chrome basin ), as well as Jayko's new recommended setups. The solver and recommendations pages have also been updated to accommodate for the new Wild Card spots, as not all 20 spots are required to cover all leaving needs.

Workshop, Workshop Solver, and the entire backend will require another couple of days to fix up and get ready for official launch on Monday.

[chrome basin]

Twitter will be very happy tonight

[chrome basin]

@cyan kernel

Also the mats list error

[cyan kernel]

I specifically said those two aren't updated yet and told you where to get the icons for copy/paste

[chrome basin]

That's not what I read

I see ping for Parrot and "shit's done yo"

[waxen pendant]

Don't you want to add Xur's crop to the cropland tab? That way they have access to the optimized setup right there

[cyan kernel]

I did, I thought?

[waxen pendant]

Not on cropland tab, i just did a copy. Maybe somewhere else and i'm missing it xD

[cyan kernel]

I used the greenfeed setup with 3 cabbage and 3 pumpkin, at the top of Xur's testing. It's the setup I used to determine the feed export tiers.

For Premium, I just used the old premium setup and substituted a radish and onion for paprika and leek, since it still fits the new softcaps.

[waxen pendant]

I'm really sorry and sleep deprived

In my mind you were going to paste the image from xur

[cyan kernel]

You're fine bby boo <3

On a side note, I'm proud to present my own pasture setup, meeting all of my own criteria:
No fucking coblyns
Contains Alligator, Star Marmot, Glyptodon and Pup, Tiger, Griffin, and Paissa
Greenfeed-only

[waxen pendant]

looking good

Do you want those 2 chocos?

As in "I want a couple"

[cyan kernel]

I wanted at least 1, but giving the one a partner felt nice uwu

And yes I DO want three morbols
I love them

[waxen pendant]

Ye i was just curious about the feathers and horns being at 2

And then i saw the couple chocos and nannys

[cyan kernel]

I didn't like horn being at yellow, is the only reason I got an extra nanny

[waxen pendant]

Set horn softcap to 1.49 :B

No one will notice, it's horns

[cyan kernel]

🔪

If I swapped out the nanny, it would be for another karakul

Cuz I do still need the milk

[waxen pendant]

Thats what i thought

[arctic fable]

I'm suddenly picturing a karakul "Got Milk?" ad

[quartz frigate]

Am I doing something wrong to cause the fields not to populate when set to automatic?

[arctic fable]

that stuff is broken right now while the sheet gets reworked for the new materials from the patch I believe

your best bet is to use either #🦜︱recommendations or one of the week / alt bot commands for now

[quartz frigate]

I'm only rank 9 though

[quick wyvern]

those commands can accept rank now

[arctic fable]

was it /alt_recs ?

[quick wyvern]

as an option

/alts I think

[arctic fable]

I don't use them so I don't remember them all

[waxen pendant]

/alts indeed

on #🚽︱bot-spam

[quartz frigate]

thanks, I'll toy around with it

[quick wyvern]

/alts only does 1 day out I think though

[waxen pendant]

idk if /this_week has ranks in it

[quick wyvern]

it do

[patent cliff]

Automatic relies on packet capture from plugins/teamcraft to get the data. 6.3 broke the bejeezus out of packetcap, and the hotfix changed it again.

[quick wyvern]

ah yea that too

shit's double broken

[cyan kernel]

Automatic is likely to be unavailable for a bit. I should have the workshop solver fully updated for Manual Mode by no later than Monday.

sweating

[arctic fable]

relax 🙂

[cyan kernel]

NO

ONLY PANIC

[quartz frigate]

either i rank up or beachcomber comes back and i'll retreat back to lurking in the shadows and copy pasting recs

[cyan kernel]

I have to figure out how to reduce over 320,000 possible agendas down to something Google can actually handle 😭

[arctic fable]

I can send you coffee/beer/<insert beverage of your choice> money if it'd help? 🙂

[cyan kernel]

No no, I don't need money for the update, I just need time xD

I'm desperately hoping nobody wants to make plans for Sunday, cuz it's my one free day before my vacation, and I won't be able to do any spreadsheet work for two straight weeks

Polar's gonna be squawking up a storm the whole time I'm gone :3c

[arctic fable]

I hope that wasn't misunderstood, I meant to help you unwind, not work faster

[buoyant cloak]

For the the record, the backing db is up to date

@cyan kernel does the spreadsheet still pull both this week and next week for the popularity data? I’m still seeing almost everyone ask for both 21 and 22 on the server.

[cyan kernel]

It does not, or at least it should not

[buoyant cloak]

It’s possible folks are still using an old spreadsheet but it’s basically every request

[minor pagoda]

updated the weather filter for 6.3 if you want to use that

https://codepen.io/gandalfgoatman/pen/abjwoOd

[violet latch]

is this the new crop setup?

[amber wagon]

is there an offline list of all the crafts from the agenda from the workshop mammeth ?

[rose dagger]

yea, in the spreadsheet. see the pins

though only the beta has the new ones. stable should get its update

[amber wagon]

I've been going through the spreadsheet for the last hour and still haven't found it might be me being stupid and not realizing something very obvious

[quick wyvern]

it's the "workshop" tab

you could also use https://ffxiv.gamerescape.com/wiki/Category:Sanctuary_Crafted I guess

[boreal prawn]

I can't find the new doc.

I didn't see it pinned. last thing I was pinned was fro moctober

[quick wyvern]

that's the post time, not the edit time

[boreal prawn]

OH, right, sorry.

[quick wyvern]

can scroll up in channel for info from Leiton about the state of the project

oh it's been pushed up a bit. here: #1035157445774938202 message

Official 6.3 version is Soon

[boreal prawn]

Did they change the respawnign?

[waxen pendant]

Some reports of the sheet being unaccessible, not going to ping just to drop it here.

[cyan kernel]

5.5.1 is not finished yet. Still a lot to do and very short time frames to work with 😭

[mellow mason]

I'm probaly about to ask something stupid but I can't seem to find Island Billy on my Island. I'm searching between 3 am and 6 am around 26, 23 on my Island but he won't appear.
I tried it for a few ingame Days but so far no luck. Is it just a rare spawn and I have to try for more days or did he move somewhere else?
Sorry 😞

[patent cliff]

Check the pins in #💵︱island-chat there's a bug

[mellow mason]

Thank you very much

[woven cosmos]

Time is always against us 😦 Any idea when it might be available? If you didnt do such excellent work we wouldnt ask 🙂

[waxen pendant]

Just noticed this. Didn't you mean Cropland?

[cyan kernel]

Nah, Cropland has drift, so it's theoretically better to not automate. But that's a pain in the ass, so, automation!

[waxen pendant]

Ya but 1 harvest every 96 days. People are so forgetful that they can forget to harvest for weeks xD

[cyan kernel]

Oh yeah no it's fine, but it is technically still a loss. So I can't say it's doubly worth for Crops. But Pasture, there's no loss and no drift, so it's 110% recommended.

[cyan kernel]

At this point I'm thinking it will likely be when I get back from vacation in February. I won't have most of my tools while I'm on my trip, and quite frankly trying to update the sheet without those tools would ruin my vacation and I don't want to do that.

[woven cosmos]

Thanks for the reply. I will look for something in February. Enjoy your vacation, safe travels!

[cyan kernel]

6.3 dropped at the worst possible time, all of my game nights, movie nights, chores, errands, and appointments were the last week

I haven't even done the other 6.3 content yet cuz I haven't had time

[woven cosmos]

Something to look forward to when you get back 😄

[icy light]

Griffin loc on the beta sheet (v5.5.0 6.3 Beta)
is incorrect. says 15, 12 whereas should be 15, 22. [Y coordinate is wrong]
(when i initially went to location I thought I had to catch the griffin in mid air XD )

[arctic fable]

that'd be a nice gameplay addition XD

[cyan kernel]

God damnit one sec

Fixed! Just got to the hotel so I have wifi \o/

[arctic fable]

enjoy your vacation 😄

[icy light]

ahaha no worries, I too hope you enjoy your vaca XD

[brittle sundial]

Where is the beta? I saw it earlier on my phone in this chat this morning, but now I can't find it anywhere?

[quick wyvern]

the pins

[old copper]

i love that the "pasture suggestions" thing will call you a monster (rightfully so) if you enter "no feed" on any of the animals

[chrome basin]

It's kinda mean and insulting to monsters though.

[weak crystal]

Does the beta pasture setup solver not work yet?

I wanted to see what my drops would be if I modified one of the setups, but I can't get it to change the animals

[quick wyvern]

works fine

make sure you're on the My Island tab

[weak crystal]

https://tenor.com/view/homer-simpson-les-simpson-matt-groening-ouff-non-gif-12807779

[atomic apex]

@cyan kernel rando suggestion: make a more static version of CG without workshop solver stuff, as a published version for people who just want to view the data and dont necessarily have a google account

[fair mesa]

maybe I am super blind, but cant find yellow coblyn and Twinklefleece in the Animal list ("my island") of the beta version (5.5.0)

[golden cliff]

you're not blind. it's the same for me. it's funny though that it does show the correct leavings for both. it just complains in the name (Animal) column that the entry is invalid. maybe a google limitation? I guess twinkle and yellow coblyn would be the last entries in an alphabetically sorted animal list and maybe got dropped? just speculating...

[cinder veldt]

I suspect the validation didn't get updated to include the new rows. while letion's enjoying some well-deserved vacation, if you need a pasture customizer before he gets back, try my sheet (in #1064380796556816384)

[golden cliff]

the thing is, it does work. you can input the names manually and it shows the correct values and calculates it correctly. it just complains about the name and you cannot select the animals from the dropdown.

which makes it really not an urgent issue, just a convenience thing, I'd say.

[fair mesa]

ohh I didn't know it put in the right values 😄 well thank you, it isn't urgent, but now I can calculate which animals I drop for seedling/griffin 🙂

[chrome basin]

Please keep all commands to #🚽︱bot-spam

[kind fulcrum]

The 5.5.0 Beta version doesn't seem to have rows in the Workshop tab for the craftable items (Coral Sword through Isleworks Dressing). Am I missing something?

[arctic fable]

it's not ready for 6.3 yet

it was mainly updated for the pasture tabs and such I believe

[kind fulcrum]

Oh. I could have sworn I saw screenshots of the solver using the new crafts, but could be wrong.

[arctic fable]

but the solver still needs work, Leiton's been on vacation

[kind fulcrum]

Ahh ok I won't complain then!

[arctic fable]

for the time being your best bet is the recs channel and/or /alts, especially since the latter can now handle missing recipes and such

[chrome basin]

Comp Guide's Workshop Solver is not updated for 6.3.

Some additions were made, but they were not for the workshop solver stuff yet.
In addition, due to how Demand Shift patterns changed with 6.3, the sheet will not work correctly. If you happen to know which of the C2 data is a 6/7 peak, change them to "Insuf - None" and it should work. C1 data is still a bit broken though.

(Leiton, unpin this when this isn't the case anymore )

[arctic fable]

thanks Parrot

[urban mist]

Heya, I'm trying to do the Automation -> Accept Terms of Service, but I just get a generic error from Google Docs when I click "Go to Island Sanctuary's Automation (unsafe)".

[quick wyvern]

auto doesn't work atm anyway

[cinder veldt]

the automation stuff/workshop solver isn't working

[quick wyvern]

so don't bother

[urban mist]

oh ok

[cyan kernel]

I've got some work to get done today but I'm hoping to have it done for next season o7

[urban mist]

I'm pretty sure I don't have any landmark locations filled, but it won't let me write 0.

[cinder veldt]

may I suggest waiting until a new version is posted before messing with it?

[urban mist]

Just trying to learn how the spreadsheet works, but sure

[quartz veldt]

I was about to post that I can't see the automation part of the stable 5.3.11 but everyone here seems to know this already.

[quick wyvern]

Yep. Auto isn’t updated yet. Soon™️

[reef orbit]

I'm not sure if its been done for a future update of this sheet, but I'm working on minimized logic for pattern recognition with the 6.3 supply/demand patterns. I could easily write it to the spreadsheet format if that would be helpful.

[iron pagoda]

I am getting "Error! Make sure the checkbox for single workshop agenda isn't checked!" How do I fix this?

[cinder veldt]

the solver isn't working and hasn't been updated for 6.3. if you need customized recs, see the ?recsbot prompt in #🚽︱bot-spam

[iron pagoda]

got it, thanks

[chrome basin]

(oh, I could have told you that, sorry!)

[quartz veldt]

how long has this beta of 5.5.0 been around?

like it been weeks now since the update, and the guide yet to add in the new items.

[cinder veldt]

leiton took a well-deserved holiday. if you need customized recommendations, try out the ?recsbot prompts in #🚽︱bot-spam in the meantime

[delicate patrol]

Oh. Wow. I had no idea the sheet wasn't working. I assumed I just couldn't figure it out, after spending hours trying to get it to work. I strongly recommend putting something in the current build that lets people know, so they don't waste hours inputting data into it, and poking around, like I did. Please please please. I'm not mad-- this is a volunteer effort, and I paid absolutely nothing for it-- just please, put something on the reddit post, or in the sheet, that tells new people not to try.

[chrome basin]

Most people get the newest link from the , and the first pin on there mentions that it's not updated for 6.3. The newest version is also outright missing the new recipes.
AFAIK the sheet works fine if you both exclude new recipes, and also happen to know the correct data for C1 and 2, because the changes to Demand Shift will likely take Leiton quite awhile to rework because it kind of broke the system entirely.

[delicate patrol]

Understood, and thank you for the response. I found it from a google search, which directed me to the Reddit thread. Maybe put something there? Coming here was my last resort.

[chrome basin]

I went ahead and updated my pin regarding the C2 Cycle bit yeah, for the time being, we recommend using #🦜︱recommendations or using the commands mentioned there in #🚽︱bot-spam if you need a personalized rec

[chrome basin]

@cyan kernel

[delicate patrol]

Thank you!

[chrome basin]

@delicate patrol For the time being though, for C2, if you look in #💵︱island-chat, you may happen to spot one of the Chinese players who are still on Patch 6.2 and report the old (working) demand shift data. If you see what is a C3W, you can leave them as Insuf-Increasing and change ALL other instances of Insuf-Increasing to Insuf-None instead. That should fix most of your issues, though again, C1 has other junk data that may break the peaks a bit, most notably, Insuf-None may break the data.

[cyan kernel]

To update!
First of all, apologies for the radio silence, I've had a lot going on both at home and at work.

So, the workshop solver. We knew this was going to be an issue moving forward, and Mienna has created RexBot to alleviate it, but to put it simply:

Solving the workshop to our degree of accuracy requires a lot of processing power. Other solvers have gotten around this by going with "good enough" recs based on simpler algorithms.

RexBot can take things pretty far for a bit until we figure out a more permanent solution, but Comp Guide only has three options.

Build a solver in Apps Script.
Curate the available agendas.
Offload the solver to a dedicated database.

Option 1 is not realistic. Building a solver from scratch has already been done, by Mienna, and it works far better than anything I could build in Apps Script. Plus I doubt Google Sheets would be able to handle it anyway.

Option 2 would be reducing the accuracy of our solutions, which I do not want to do.

Option 3 is the best choice, and presently underway via the website slowly making its way.

The primary goal with this website is to replace the Comp Guide, entirely, but first and foremost replacing its solver. Mienna has already done that.

So instead of wracking my brain trying to figure out a solution for the CG solver, I am simply going to shelve it to help push the website development along.

[woven cosmos]

Is there a link to Rexbot or this website somewhere? I have searched through every channel on this discord, including pins, reddit and google and have clearly overlooked it.

[chrome basin]

Website is still in development.
Rex (the nickname for the bot) is what's being used in #🦜︱recommendations and #🚽︱bot-spam when you run custom recs commands like /this_week.

[woven cosmos]

Ok. Just as feedback - perhaps a statement of a website not currently available or in development and a cleanup of all the outdated information on the server. Seems to be confusion as to what is actually available, how it is used, and where to locate it currently. You all are doing some great work. It would be a shame to see its value diluted by lack of understanding or accessibility.

[queen quartz]

sad :( I preferred the google sheet since it let me uncheck items I didn't want to make or didn't have enough materials to make without having to go gather 🤢

[quick wyvern]

the nocraft option for the bot lets you ignore up to 3 items on any given alt request, or a few materials entirely.

[obtuse basin]

Crop info, including recommended setups and crop order, can be found in #1065241173247152260 inside #1034953674100842516

[willow lily]

can I ask how does the automation work? I have enabled it but nothing seems to be happening

[quick wyvern]

it doesn't. use #🚽︱bot-spam instead.

this sheet is discontinued and this thread should probably be locked

[chrome basin]

Leiton still keeps it updated, just the solver is discontinued FTR

[quick wyvern]

solver-less version is Soon™️

[cyan kernel]

6.4 will be without a solver yep

[chrome basin]

Sucks, but we can take solace in knowing Google Spreadsheets is 100% to blame

[cyan kernel]

Eh, honestly at some point we're gonna have the same issue with Beachcomber and Rexbot

[chrome basin]

😬

[cyan kernel]

I have ideas but not entirely sure how to implement them yet

[arctic fable]

Spin up several EC2 instances that eval a subset of the list in parallel? 🙂

[west iron]

So if I was using the Granary recommendation part of the Google sheet, where do I go now to get that recommendation?

[cinder veldt]

same as always: "get whatever you're lowest on"

[quartz veldt]

Any update on the comprehensive guide update for 6.4?

[quick wyvern]

Leiton expressed interest in updating the non-solver parts of the comp guide Soon.

just letting you know it's currently planned

[cyan kernel]

It's not done yet, been busy as all hell IRL

But the moment I get a break, the 6.4 CG will be up ASAP!

[quartz veldt]

Any update so far?

[cyan kernel]

Not yet, every time I think I'll get a minute to sit down and work on it, something else pops up

[upbeat violet]

Was there gonna be a comprehensive guide website or something? I recall that a while ago