🧮 Comprehensive Guide

[waxen pendant]

Yeah because he's too nice

Remember leavings/crops targets

[atomic apex]

We're going to need to start somewhere with localization, that spot is very easy to do

[waxen pendant]

I disagree, english and images are enough localization

We all have to know english to some extent

[atomic apex]

To be frank, I don't care if you disagree

[waxen pendant]

It's my opinion anyway!

Not that anyone asked...

But I stand for it!

[atomic apex]

I know, but localization is already something that's been discussed. And with in-game stuff it's easy because we can just use them straight from the data files

[atomic apex]

@cyan kernel when you have time, can you replace the Star Marmot with Island Doe on my Min Effort pasture?

[waxen pendant]

And change the title: For Shuma, with love milk

[atomic apex]

"now even milkier"

[cyan kernel]

;w;

[atomic apex]

i said when you have time! lol

[cyan kernel]

Updated

[north marten]

in the workshop solver is there a way to set the animal to 'none'?
I'm theorycrafting a pasture that satisfies my aesthetic desire while also being within the softcap

[quick wyvern]

Does just deleting the cell not work for you?

As a workaround

[chrome basin]

Leiton is it possible to remove some of the bottom of the parrot stamp image on the spreadsheet?

Sorry god that was an awful sentence

My point is the spacing on the bottom; can the bottom of the square be raised up at all or is that gonna squish it

Cuz like, there's nothing down there so idk why the box has so much room down there

[quick wyvern]

wait so...in 5.3.9, once you've accepted terms and swapped to auto, how do you...get it to populate

yea idk I turned it to manual and then back to auto, still nothin

[buoyant cloak]

The server is populated now so it's not my fault

[quick wyvern]

yea my older sheet 5.3.2 is auto-ing correctly

just not the 5.3.9 beta I copied

though I guess it's noteworthy that the 5.3.2 sheet seems to not have c3 info yet

both sheets have figured themselves out, carry on

[buoyant cloak]

Makes sense. I think it pings every 10 minutes

It wasn't up at 3:10, it was by 3:20

[chrome basin]

Leiton can I make a stupidly-small-but-nice request? Could you change the fill color ever-so-slightly of the important 6h/8h crafts in the Popularity area on the far left? Don't care which is lighter and which is darker and they can stay very similar, even more similar than shown below.
• Big 9 (8hs)
• All Crop & Leaving 6h (yes, even PP )
Just helps to quickly identify what's important and peaking, makes it a bit easier to go across the list on C2 to make a list similar to the one here: <#1038019456493953105 message>

[hasty blaze]

Just a relic of me not cropping it thoroughly. Here's one done properly:

[waxen pendant]

Why is it recommending rest on manual-net value (v5.3.9)

I thought the threshold was 3500?

[cyan kernel]

Threshold for 2nd day of crafting is 4000

[waxen pendant]

For net and gross?

[cyan kernel]

...Oh, hahaha, yeah that'll do it

The rest rec is based on gross, but doesn't swap if it's on Net

I'll fix that this morning real quick

[cyan kernel]

v5.3.10 is LIVE
Fixed the Rest Recommendations for Net Profit mode

[cyan kernel]

Did you one better.
Grey items are darker grey
Good 4/6hrs stayed the same
Big 9 are brighter grey

[buoyant cloak]

I'm not sure this makes sense. Net profit is substantially lower than gross, and so the rest values should be commensurately lower.

[cyan kernel]

Ye, I adjusted it so that if it's set to Net Profit mode, it changes the rest threshholds to 3250 and 3650 for d1/d2 respectively

Normally 3600 and 4000, so 350 difference to cover for granary products

[hasty blaze]

Jsyk I'm redoing the images to fit inside the cells so people won't have to deal with them floating or disappearing. Should be done in the next hour or so.

[cyan kernel]

Oooooo hell yeah

[buoyant cloak]

I wonder what our average net value has been...

[cyan kernel]

Part of my historical data tests I have planned for next week

That way I can nail down exactly what my rest recs should be instead of an educated guess

[chrome basin]

tybb, and now I attempt to go back to sleep cuz my body woke me up 20m before houses were avail... after sleeping for like an hour.

[tawdry quartz]

@cyan kernel , got anything pending or is it safe to do the 5.3.10 copy?

[cyan kernel]

I'll have a visual update later thanks to R'hasti

[cyan kernel]

v5.3.11 update done! New image template from @hasty blaze has been added, so no more shenanigans from Google.

@tawdry quartz @chrome basin Update is good to go!

[chrome basin]

I'll update before dinner tonight, juuuuuuuuuuuuuust in case

(but thank you, I appreciate the pings )

[cyan kernel]

I'm not pinging any more

[chrome basin]

That's fine, cuz I'm not updating for a few hours anyway

[chrome basin]

All set up on .11. I'm also gonna intentionally move the stamp slightly on every pic
Anyway, attempting bed for 6h, thanks again Leiton

[chrome basin]

Just to document it, that Rest Recommended for today was PRETTY WEIRD

[atomic apex]

did for mine too, on all...9 of my variations I ran

[chrome basin]

Sometimes the solver just... freezes. (v5.3.11)
I'm trying to test Garnet Weak, Caramels Strong, and I changed JUST those three items and it's like "nah fuck you"
(even when I don't do silly shit like this, it'll freeze at times; I don't mean crash, it just, doesn't do anything with no load bar)

@cyan kernel I don't know what you did, but uh, MAN. It's also related to the rest bug.
<#1038019456493953105 message> (keep going til I stop posting, there's some wonky shit going on)

I have another hot bug where the solver is STILL Recommending Earrings over Egg and Butter for a 4686 Sheepfluff Rug x Bed combo, and yes I have Earrings at OVERFLOWING. Does it have the right modifier for Overflowing? (check the link above, it's basically a mini-thread at this point)

[cyan kernel]

😰

[cyan kernel]

Mkay I figured out why it's aggressively suggesting Rest today

But I don't have time to fix it. Essentially the Cycle 4 rest rec is still relying on peak prediction instead of breakpoints, so I need to redo that whole section of code. Can get that done later today.

As for the Cycle 5 shenanigans

I'll tell ya the same thing I tell everyone else

maybe don't try to solve farther ahead than advertised, shit breaks

[chrome basin]

Much of the Cycle 5 stuff was happening for Cycle 4 as well, where it would just freeze and stuff too.

[cyan kernel]

If you froze it, it's because you broke the logic with what-if testing

[chrome basin]

Heck.

Truth be told, I put Suff-None for everything I didn't care about

[cyan kernel]

....

[chrome basin]

But again, the same thing happened for C2

[cyan kernel]

Yes that would break it

[chrome basin]

w/o the Suff-None

[chrome basin]

It actually worked after an F5 refresh

[cyan kernel]

Hm

I'll double-check but I'm 99.9% sure that's either google or your browser blipping

[chrome basin]

I'll blep all I want

👅

[cyan kernel]

🔪

[chrome basin]

:c

[atomic apex]

if doing what-ifs, just fill in the ones you DO care about, and leave the rest blank, otherwise peak detection goes insane

[chrome basin]

I tried that and it was "awaiting input"

[atomic apex]

oh using Manual

i do my what-ifs using Auto >.>

[chrome basin]

I, don't see how that would be any different.

Cuz it'd still have no data for C4.

[atomic apex]

on auto its not going by the entries, its going by the peak data

[cyan kernel]

You can manually change the peak data

[chrome basin]

Just to make sure though, it's not like, ignoring Overflowing, right?

Cuz it was so weird to keep calcing Earrings at a higher value than Egg or Butter

[cyan kernel]

I said I was gonna fix that later 🔪

[chrome basin]

OH, sorry.

[atomic apex]

it was definitely pulling the 0.6 multiplier for my testing this morning

[chrome basin]

(that was part of my C5 testing too, wasn't sure if that was partially it)

[cyan kernel]

I'm 99% sure it was using Overflowing properly, cuz that's the whole breakpoint system

But it still shouldn't have been suggesting double earring two days in a row

[atomic apex]

definitely plenty of earrings overflowing

[chrome basin]

It's weird that the reusing items thing is happening more and more.

[atomic apex]

i mean...we knew that would be the case

we talked about re-using the 4hr connectors multiple times if they showed up, regardless of their supply

[chrome basin]

Oh I know, esp if they're VH and good.

(which is the case for Earrings)

[atomic apex]

@cyan kernel future thinking ideas to help with increased load/calculations that 6.3 will bring:

1. I know I mentioned coming up with craft combinations via scripting before, just listing it again due to potential of new items in january and it being even more necessary/useful
2. What if....the solving of recs and even the amounts for each craft on the right side were offloaded to JS and triggered via a "calculate" button, so google sheets isnt having to calculate every time something changes, and JS can do it much faster anyhow

[cyan kernel]

That's presently what I'm thinking I'll have to do

[atomic apex]

i know how much everyone here loves JS 😄

[cyan kernel]

Stable v5.3.11 updated in links in pins and on Reddit Hub. Please update if you get the chance, lots of major bug fixes and QoL updates.

[molten cloud]

So it's been a long time i tried to set the spreadsheet on Automatic mode by curiosity.. What does it do exactly? Because i cant run the spreadsheet on automatic since it's been implemented, it does nothing, or i'm just too dumb to understand what is does

[cyan kernel]

The Automatic Mode presently relies on Mienna's plugin data, so any time there's a patch, no matter how small, Automatic Mode won't work for a day or two, until Dalamud and Mienna have both done their updates.

[molten cloud]

I'm ok with the fact it cant work after a patch, seems logic since it depends on Mienna's plugin.. But it never worked for me in the past, and i wonder if this is because of French.

Or just me ._.

[cyan kernel]

Hm... You followed the steps completely, gave Google Sheets' permissions, ran the ToS Agreement, and then swapped to Auto mode?

[molten cloud]

All of that

But lets wait for Dalamud update before engaging anything

[cyan kernel]

Ye
I've also not tested in other languages so that might also be it? But we'll wait til after the plugin's working.

[tawdry quartz]

5.3.11 Beta in manual mode, it doesn't even have radish on the radar if you override strong

value calcs right though

[cyan kernel]

Apparently that's correct, if I'm reading the recs discussion right?

@chrome basin @buoyant cloak can y'all confirm?

[chrome basin]

I was an idiot who forgot to check the Overrides

But I think what Kal is saying is that if you check the override for Radish to strong, it's not showing

[cyan kernel]

I'll run a check when I get home. I might have messed up the overrides with my tweaks.

Or groove might be getting calc'd higher than it should

[chrome basin]

They did say Beta; is last week's Beta .11 the same as Stable .11?

[cyan kernel]

Yep, no changes

[chrome basin]

Ah

(glad I DL'd a new copy, it saved all my last week info)

[cyan kernel]

Which means there's a bug SOMEWHERE

[chrome basin]

SOMEHERE, SOMETHERE, SOMEWHERE

[cyan kernel]

You don't get to make fun of me after messing up recs when my spreadsheet was perfectly functional 🔪

[chrome basin]

I was making a funny, sheeeeeeesh

You do perfect recs at 5am with a sheet that doesn't just know what's a true strong C2

❤️

[cyan kernel]

Watch me

[chrome basin]

"Leiton I thought you said it was foolproof"

Little did you know, the biggest fool of them all was doing recs!

[cyan kernel]

Foolproof =/= Parrotproof

Putting you back in the box

[chrome basin]

Love you too ❤️

[frozen ember]

is 5.3.2 still the latest stable version?

[waxen pendant]

Pins

[frozen ember]

the pinned version is older than the one I have which is why I asked

[waxen pendant]

I think @cyan kernel messed up the dots

xD

But it went from .2 to .11

Idk how this works but 11 seems higher than 2?

I see how you could get confused tho

[cyan kernel]

5.3.11 is correct

[waxen pendant]

It should have been .02 to .11

[frozen ember]

oooh right it's .11 not .1.1

[random stump]

In versioning there are no decimals, so 2 is less than 11

[atomic apex]

to be fair, 5.3.11 has 2 decimals 😄

[waxen pendant]

I thought decimals used "," instead of "."

[random stump]

Depends on the language

[waxen pendant]

Maff is a language itself :p

English just wants to f around not doing things like the rest of the world

[atomic apex]

its a period in most places, a few use comma, but the number is shrinking

by land mass, comma is more common though

and in Canada its both, which seems confusing as hell 😄

[waxen pendant]

Well, we use period for multiplier or for separating thousands

like 100.000

[atomic apex]

as a multiplier?!

[waxen pendant]

or 5 . 2 = 10

[atomic apex]

thats...wrong

[waxen pendant]

It's not

[atomic apex]

it should be a higher dot

not a period

[random stump]

Aye, 5 · 2 = 10

[atomic apex]

yeah that

[waxen pendant]

I meant that tbh

[atomic apex]

yeah thats pretty much everywhere

[waxen pendant]

I just don't know how to do that on keyboard

Just remembering my school time xD

[atomic apex]

me neither, which is why i just use x lol

[waxen pendant]

Which we used paper, not tablets

[atomic apex]

5x2=10

fairly universal too

[waxen pendant]

But in algebra x is supposed to mean a number, not a sign of multiplier

[atomic apex]

yeah, but most people arent doing algebra in discord

• gets used a lot too

[waxen pendant]

true

[atomic apex]

or just put everything in parentheses!

(5)(2)=10

[waxen pendant]

I've... never seen that

[atomic apex]

it's not generally how you would write it but it solves the same

[cyan kernel]

Radish Strong:

Verdict: user error

[atomic apex]

New feature suggestion: Pull previous weeks peaks to identify these:

[waxen pendant]

This one leiton?

[atomic apex]

i can only guess he checked the wrong override box, or maybe accidentally unchecked it

[chrome basin]

Worked fine for me with it checked.

hell I didn't even have Horn at Insuf and the override saved me that's why I missed the correct agenda originally

[atomic apex]

lol

[waxen pendant]

5am parrot scares me

[chrome basin]

My homies and I all HATE 5a Parrot.

[atomic apex]

whats the difference?

[chrome basin]

5a Parrot doesn't have access to plogons

3a Parrot does.

[atomic apex]

oh

yeah, even with plugins i get annoyed

[chrome basin]

If I had plogons, I wouldn't have made such an amateur mistake

Manually inputting all the data at 5a? Madness.

[atomic apex]

well, i was using um

the recs bot before

but its not here yet

or rather the newer ones not here yet

[waxen pendant]

Hopefully the improved UI mentioned on the live letter makes it easier

[atomic apex]

improvements: now inaccessible to plugins or packet capture

[waxen pendant]

yikes

But the community always wins

After I saw the video of the person fighting DSR from the moon

I believe anything is possible

[chrome basin]

It'll likely be that for the first half of 6.3's week

[atomic apex]

doubtful

TC will update fast

[chrome basin]

I mean plogons alone will take most of the first day and the UI improvements may require manual updates from AutoMammet and TC

[atomic apex]

likely not TC due to how it's done. Automammet, could totally see that

[tawdry quartz]

I guess I'm making a new copy off of stable...

so strange... It worked correctly on the fresh copy with the exact same data provided as the beta sheet

[atomic apex]

pebcak?

[chrome basin]

To-Do: Spreadsheet being able to calculate mid-day supply change before even recommending it to me

[atomic apex]

Issue: Today's rec only rated 1300 (14681&1300) as opposed to these

[chrome basin]

(it also shows Onion without realizing it'll drop supply tiers after the first line of them until after you start setting things, same with Boiled Egg)

[atomic apex]

yes...the fact that i cant finish placing items before the left chart completely changes is...infuriating >.>

[molten cloud]

So. i can confirm, Automatic mode on spreadsheet definitively don't work for me ¯_(ツ)_/¯

I have this so its not a real problem

[waxen pendant]

Why not?

[molten cloud]

idk xD Since it was inplemented, it never worked for me

[waxen pendant]

Maybe a permission issue?

[molten cloud]

All accepted as said in the "READ BEFORE USE" tab. More like a language issue

OR, just me doing shit

[cyan kernel]

Hm, did you change anything? Regarding the language issue? Like, did you tell Google to auto-translate or something?

If you changed the names of the tabs, that would break it

[molten cloud]

Nothing like that

I just copy a fresh new one to re-test https://puu.sh/JrL0k/94f399d674.mp4

idk if i have to do one more step or not

[cyan kernel]

Aha!

I need to put a note in about this

The first time you attempt to run Accept ToS, you're only giving google permissions

You have to run it again to actually run the script

It's really stupid, I hate Google

[molten cloud]

ngl, run the scripts a second time just delete the READ BEFORE USE tab, and that all, nothing pop, automatic mode is still as white as before, awaiting for inputs

[cyan kernel]

Takes up to 5 minutes before it'll pull the peaks

[molten cloud]

Was gonna said OH wait a sec, something happens xD

[cyan kernel]

It's kinda weird, setting a 5-minute timer on apps script doesn't actually give you a 5-minute timer

It's actually a "any random time within the next 5 minutes when I feel like it" timer

[molten cloud]

Owkaay so actually it works, i was just impatient! 😄

But in fact i never re-clicked to accept terms of service a second time

[left elbow]

Is there any way i can get the tuesday supply and demand data? id10t error and i lost half of it.

[chrome basin]

DMing

[left elbow]

DMing?

[waxen pendant]

He will send a direct message to you

[left elbow]

got it !!! Thanks so much

[quick wyvern]

why in the world can I not get the auto-sheet to work yesterday and today

yesterday it was stuck with last week's info, and today a fresh sheet is stuck with full blanks

[frozen ember]

So how do I input the Groove Move into the sheet?

[cyan kernel]

You don't until I fix up the sheet to allow it

[frozen ember]

👍

[cyan kernel]

To-Do Tonight:

Add 6th item slot for groove move agendas on Solver tab - DONE

Fix calculations on Solver to account for groove move slot - DONE

Fix Base Value on Solver tab, the lookups on SP4 for 6Cx lookups, maybe also gross value slots? - DONE

Add SP4 functionality for 6-craft agendas to work into breakpoints - DONE

Add SP2 functionality for groove move slot on material solver - DONE

Add SP1 functionality for 6-craft agendas to work into groove - DONE

Update AppsScript ResetNewWeek to clear proper colums on Solver tab - DONE

[atomic apex]

my ideas just getting ignored 😭

[cyan kernel]

What, the JS solver?

I'm going to be doing that, or working with Mienna on hers

But I'm adding groove moving first for both crime time and tomorrow's recs

[atomic apex]

no, C2 strongs based on previous week peak location

[cyan kernel]

That requires automation and therefore can't be guaranteed

So I'm working on this first

[atomic apex]

oh i just meant checking it vs your historical sheet

[cyan kernel]

It's the same sheet

If people don't save the historical data manually, then the C2 data would get fucked up

[atomic apex]

oh

you mean....not everyone makes 40 copies of the sheet every week?! >.>

[cyan kernel]

So I'd have to run checks to make sure it's the right season, have to tell people how to store data, have to tell people how to get that historical data

Believe me I'd rather do it that way

But people be dumb

And adding that would break it for 99% of people

[atomic apex]

more and more reasons i wish we had a public database of info

[cyan kernel]

Soon (TM)

[cyan kernel]

BETA v5.4.0 IS OUT, BABY

GROOVE MOVERS ARE
BACK
IN
ACTION

https://docs.google.com/spreadsheets/d/1yAfkO_OQNXexkSFGo3oABaIFmC83rqdejyuhs_dboHM/copy

[atomic apex]

now you just need to add them to SP1 >.>

[cyan kernel]

Non

I'm just gonna go with the JS solver doing everything

[atomic apex]

there we go

[chrome basin]

@cyan kernel Are you doing Groove Moving or something? You had Nonexistent-Increasing for Pumpkin on C2 data (on v5.4)

Dunno if that was int or accident

(also Radish's override was checked)

[cyan kernel]

...Forgot to reset the Workshop tab, my bad

[chrome basin]

[quick wyvern]

FYI Leiton, the beta 5.4 version is labeled as 5.3.11 on the about page

not that it matters a ton but there it is

[dense tulip]

fwiw, I was having some problems getting the sheet to pull down data

[quick wyvern]

yea it's been over 20 minutes myself and I've yet to get an auto update on my 5.4 copy s well

[quick wyvern]

my copy of 5.3.11 (Stable) also does not seem to be automatically updating

[quick wyvern]

my 5.3.2 copy seems to have auto updated

[quick wyvern]

@buoyant cloak the auto values are entered fine on your end right?

[buoyant cloak]

Log looks good for sending peaks

[atomic apex]

its still showing cycle 2, not cycle 3

unless it starts at 0

[quick wyvern]

I'm literally getting no automation updates

on multiple versions

[atomic apex]

let me make a new copy and test

[quick wyvern]

this is the blank I made today just to test this for another user

been like this for literally 3.5 hours

[atomic apex]

working

do accept ToS again

[quick wyvern]

but...but why? this other user and I have gotten no updates all night

[atomic apex]

see if that fixes it

[quick wyvern]

done. no popup appeared because I'd already accepted

[atomic apex]

expand the section hidden over between AB and AI

make sure nothings in AC1 and AE1

on workshop tab

[quick wyvern]

and yet my 5.3.2 copy is working still...

[atomic apex]

so, do you make sure to always do Accept ToS twice?

[quick wyvern]

twice? what

[atomic apex]

so the first time when it asks you to approve, it doesnt actually run the script

[quick wyvern]

I did not do that for my previous version O_o

[atomic apex]

so after you approve, you still need to run the script

its a Google safety thing. Leitons going to make some changes to make it more clear

[quick wyvern]

that worked for my newest sheet, why the heck did my previous sheets not need that?!

[atomic apex]

does the old one still have the scripts to manually pull peak data?

under Automation

[quick wyvern]

it has the extra options under auto, yea

not that I used them

[atomic apex]

most likely you hit some other one first, which gave the popup

before the accept ToS

like converting to auto

[quick wyvern]

maybe.

[atomic apex]

any script will trigger the google prompt

[quick wyvern]

bollocks

[atomic apex]

yeah

i asked him to make one thats just for accepting googles' safety stuff, so its more visible

[quick wyvern]

well thanks for solving the mystery

[atomic apex]

I need to get an OC Tech Support role

[quick wyvern]

yea I can see step 3 on the read this sheet kiiiiind of says this might be needed

but not in the way I'd expect

[atomic apex]

yeh

[quick wyvern]

I assumed this step "worked" when it popped up the message and emailed me

which it clearly did not

[atomic apex]

we talked about it a few hours ago, so he hasnt had time to update it

[quick wyvern]

so I could just chalk this up to me being dumb but I'd like to pretend the wording is confusing instead

[atomic apex]

honestly, its google imo

if you approve the thing, RUN THE THING THAT MADE YOU APPROVE IT!

[quick wyvern]

you can read the above, but tl;dr you need to run the "accept terms of service" command a second time to let the sheet start working. the first time google stops it and gives that popup instead.

[buoyant cloak]

It is legit confusing

[atomic apex]

yeah i only noticed because turning it to auto didnt work

i dont do the ToS

[tawdry quartz]

The accept ToS script is what sets the timers for pull peak and weekly reset though

[cyan kernel]

v5.4.1 TO DO

Add a "Allow Permissions" script that does nothing, add to Automation UI, and update READ BEFORE USE tab.

Fix Granary tab pulling the wrong week.

Fix Animals tab

Try to fix mid-day breakpoints in the solver...

[soft raptor]

Yo. Is it possible, that workshop solver gives me worse results with pasture producs allowed than with dissabled?

Also, why does recomendations changes every time I try to fill it into calculator?

[waxen pendant]

Oh that's probably because of supply breakpoints

Everytime you craft something, you might be crossing a supply breakpoint

So it changes

#1035744302699134986 message

[soft raptor]

Oh, ok. Good to know

Just tried new beta and thats much better tho. Even fixes the recomendation changing

[atomic apex]

i do manual so i can mess around with it

[waxen pendant]

@cyan kernel when i clicked c2 rest this happened

v5.4 beta

[cyan kernel]

Looks like you copy-pasted

Don't do that

[waxen pendant]

I did. A lot

[atomic apex]

copy/paste copies the formatting rules. if you do that, right click, and paste as values

[waxen pendant]

oh welp, manual input then

Wait, the values looks fine, just that weird blackout for rest. I can ignore that.

[atomic apex]

yeah its just the cell color changing

[waxen pendant]

Is there another fix for "click ToS twice"?

I've clicked a few times and waited half an hour

[cyan kernel]

Did you turn on auto mode?

[cyan kernel]

Up in the menu

Extensions - Apps Scripts

On the new page, check the left side if the screen for a clock, click it

Screenshot that page pls

[cyan kernel]

Hmmm

Back to spreadsheet

On Workshop tab, unhide all tabs, ignore the warning, and screenshot that pls

[cyan kernel]

....Huh.

Okay, last thing

Extensions - Macros - Import Macro

Import PullPeak

Extensions - Macros - PullPeak

[cyan kernel]

Click PullPeak

Does that pull things?

[waxen pendant]

Wait a few minutes? nothing happened

[cyan kernel]

Hm okay so something is wrong with the script
I'll take a look

[waxen pendant]

I needed automatic sheet to test the new big9 preset

I can't do it with manual inputs because it will be biased from main rec crafting

[tawdry quartz]

Mienna's site filters request after your first pull of the day doesn't it?

[waxen pendant]

And autosheet gets the base value, right?

[cyan kernel]

I genuinely can't find the issue

I'll check with Mienna when she's awake and see if the site is getting pinged

[waxen pendant]

But it did work for you?

[cyan kernel]

Nope

[atomic apex]

site is down. currently anyways

[waxen pendant]

It's working again

I'm currently running the tests for week 13 on the presets

[atomic apex]

maybe earlier, but its down atm lol

[tawdry quartz]

5.4.0 calcing weird for anyone else? I'm 5.4.0 beta in auto mode

[atomic apex]

mine matched Polar's this morning

i dont use auto but i do use 5.4 beta

[tawdry quartz]

for some reason pulled peaks have earrings marked as 7 weak

[tawdry quartz]

i think that's it

[atomic apex]

can you give me a share link to your sheet?

[tawdry quartz]

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

[atomic apex]

thats very strange, thats the only thing wrong. its gotta be an issue on the database, which is unfortunately down right now so I cant check the value there

[tawdry quartz]

it is 6w right?

[atomic apex]

well, i show 6w but i trusted other things 😄 let me verify manually

yes, definitely 6w

C7 peak would have had a plummeting on C3

@buoyant cloak can you check the peak site when you have a moment, and also confirm what it's showing for earring? KalToren pulled C7 for earring peak

[tawdry quartz]

i edited the peak data to say 6w and my solver matched the recs now.

[buoyant cloak]

Earring is item 16, yeah? 6W

I'll fix the db and wake it up >.<

DB awake and with correct data

I'm sorry I dropped the ball on this. I've been really busy this week with work and just legit did not have much time in front of my computer. I am currently working on a solution to automatically update this with a more reliable peak set, and I honestly have no idea why it just shuts down sometimes.

For those who want to know exactly why it got it wrong: On C2, I was testing a Beachcomber bug using Polar's supply data, which was different than mine. His had 0 used earrings while mine had 6, and I forgot to switch back after I fixed the error. On C3, beachcomber saw Surplus with 0 crafted, and that made absolutely no sense, and since it failed to detect the 6W on C3, it remained confused for C4.

[cyan kernel]

It's okay
Shit happens, take breaks and try not to stress

[buoyant cloak]

To be clear, when I say "work this week" I basically mean teambuilding field trips

It's a lot of time spent afk, and it's not optional, but it is also not stressful

[atomic apex]

wth, I typed Leiton, realized I wanted to tag him, went back to beginning and hit @ and it did this:

Mienna is clearly Discord's favorite

anyhow, @cyan kernel can you add S11 historical data into the beta sheet?

[buoyant cloak]

Maybe you're Discord's favorite

(It seems to just assume you want to tag the last people who posted)

[atomic apex]

makes sense, just never had it do that for when I added a @ to an existing name

[buoyant cloak]

I've never been able to add an @ to an existing name. Typing @ just brings up the menu to @ someone.

And then if you do, it inserts the @ link after the @ and before the thing you already typed

@buoyant cloak Mienna

[atomic apex]

its probably Teams that I'm thinking of

[frozen ember]

anyone know why my spreadsheet recommended me Rope/Shark Oil for C6 this week instead of Rapier? Despite the value being lower when I checked? (5.4 beta)

[quick wyvern]

automatic or manual?

[frozen ember]

Manual

[quick wyvern]

can only assume it's a data entry issue then

this is my results using auto

you can check the related items and make sure they are all entered correctly?

what are the actual cowrie numbers it calculates out for each?

[frozen ember]

all correct for today at least

[quick wyvern]

well today isn't c6

[frozen ember]

no I mean

my data entry was good for today

[quick wyvern]

and what about the other days lol

I guess that would be hard to check atm

[frozen ember]

I'd need someone else's sheet for that

but the weird thing is

[quick wyvern]

is this the base value you get for firesand/garnet?

[frozen ember]

I'm getting Base 3258 for Rope/Shark Oil; and 3552 for Firesand/Garnet. So it SHOULDN'T be recommending me Rope/Shark Oil

and yet

[quick wyvern]

you may need to share your copy of the sheet to get further assistance

[frozen ember]

https://docs.google.com/spreadsheets/d/15BVCY8f7ppoy2LkuPOeaRXu4TFueSQp9Toa4zoLItGI/edit#gid=362422318

it also gave me the wrong value for C3's Cowries which may be related?

[quick wyvern]

also have you tried unchecking then checking the red "refresh the sheet" square

[frozen ember]

yeah, didn't change anything

[quick wyvern]

hmm

with your data entry I get a recommendation of earring - boiled egg - onion soup - boiled egg - onion soup...until I start typing that in and the rec changes

so that's weird

but I also don't have the rest of the week entered

and yea that c3 value doesn't seem correct

guess thar be some bugs, you are correct. guess leiton will need to take a look later

[frozen ember]

yeh

I'd ping them but I dun wanna be annoying

[quick wyvern]

swapping to auto causes the recs to be accurate again too

[atomic apex]

the recs are looking at the right side as something you crafted that day

as far as supply changes

[frozen ember]

even then, clearing C6's agenda still makes it recommend Shark Oil

[quick wyvern]

or in my case, utter nonsense

once I put in the rest of the week's crafting it was shark oil though. at least with the supply info coppied from clawtooth

[atomic apex]

i think there was a supply issue with the shark oil? not sure. you'd have to look through rec-prep, it came up

[quick wyvern]

oh really 🤔

[atomic apex]

that was...many hours ago

brain fried

[quick wyvern]

ahhhhhhh ok I see now. because shark oil isn't actually peaking on 6

it's peak 7

so after a few crafts, the shark oil falls in price

might still be something the sheet recs should handle eventually? idk

I still don't see the same recs as claw for...whatever reason. whatever.

and c3 on the sheet is still way off

[prime oasis]

Suggestion: Comprehensive Guide should include the percentage chance of receiving bonus leavings next to the corresponding mood. Would take up little space and is quite helpful for folks to know. There's a ton of awesome info on the Pasture tab, but that is conspicuously missing.

If I were to base what feed I use on only what's listed there, I would think premium is definitely the best choice. Which we of course now know is not the case 🙂

[atomic apex]

this stuff can probably be consolidated into just 1 box taking up the left half of that space or something and put feed info in the right half

[prime oasis]

The whole section above that is not great either - really trying to sell Premium. I'm sure it's just what was used initially and hasn't been updated.

[atomic apex]

thats a....Leiton thing

something about animals being happy >.>

[prime oasis]

haha ok

[cyan kernel]

I'll fix it up sometime next week

[cyan kernel]

Gonna be a bit busy today and tomorrow but I should have a lot fixed up by the weekend o7

Side note, sorry for the slower updates lately. I've been extremely badly neglecting my tabletop game, movie nights, and husband for three months now and I need to step back a bit and give them some focus.

Still going to be throwing a lot of work into the spreadsheet updates, and working with Mienna and Polar for recs. Just can't keep neglecting my other responsibilities.

[tawdry quartz]

@buoyant cloak do you match this for value in Beachcomber?

seems stronger than the official req if radish goes weak

(i wasn't sure whether to put this here or in workshop questions...)

[buoyant cloak]

Pretty sure Horn isn’t a D2 peak and it is in the top 15 highest value crafts so none of my code is using it before peak

[tawdry quartz]

i'm actually surprised it's saying the value it is. Horn is low this week, so it feels like it's basically a throw-away link between the eggs.

hrm.... i'm getting a different value when I plug in the main rec in the solver

[tawdry quartz]

OK, yeah, my sheet flaked out when it reset from season 13. I made a fresh copy and values are matching now and i'm not seeing horn anymore.

5.3.11 beta and 5.4.0 beta both broke when automatic and transitioning to new season.

[arctic fable]

What time is the spreadsheet supposed to fetch data? I thought I saw a timer earlier saying it should have been about 40 minutes ago my time, but it hasn't, and now I can't find that time again so I don't know if I imagined or misread

[tawdry quartz]

did you re-run the accept terms script? that's what schedules the pull peaks script when in auto mode

[arctic fable]

I just got 5.3.11 this morning

Walked through everything

Or do you mean you have to redo accept terms after switching from manual to auto?

[tawdry quartz]

the first time you run accept terms and it prompts you to allow permissions, the accept terms script doesn't actually run. You have to run it a second time for it to actually do it's thing.

the pull peak should attempt to run every 5 minutes. Once it has the data from Mienna's database, it stops trying to pull.

[arctic fable]

Ah, good to know, I'll try that after lunch

[tawdry quartz]

easy way to tell you have successfully run the set terms: READ BEFORE USE tab gets hidden by the script. If you still have that tab and didn't hide it manually, it's not run yet.

tab = sheet

FYI, you may want to give the 5.4.0 beta a try. 5.3.11 can't do full groove move (which we've had come up both this season and last). 5.4.0 can support 4-4-4-4-4-4 agendas.

[arctic fable]

ah, I usually wait until it's marked stable

ok, accept ToS again fixed it, thanks! has info now

[arctic fable]

one last question: does it now auto-clear itself for new weeks? I was using 5.3.1 before, and it had an automation action to reset for new week

[tawdry quartz]

there's 2 triggers that get set, one resets the sheet every week, the other periodically checks if it can pull peaks

[arctic fable]

figured as much, thought I'd verify

thanks again!

[tawdry quartz]

ymmv, but I've had some wierd issues the past 2 resets. Oddly enough, my old "bugged" version of the 5.4.0 sheet I had that went through reset is working properly again now.

[arctic fable]

noted, will keep an eye out

appreciate all the help 🙂

[frozen ember]

once again got a different value for the today's 6 item rec and it seems not to be accounting for groove for some reason?

[waxen pendant]

Did you make a fresh copy?

[frozen ember]

no, should I have done? I'm on Manual btw

[waxen pendant]

Its worth trying? One thing I learned is that Google sheets is weird

[frozen ember]

fresh copy has the same result

have also double checked data entry

[waxen pendant]

On manual?

[frozen ember]

yes

[waxen pendant]

Im not the expert but maybe automatic having the historical data already checks whats strong and weak peaking?

Try an automated version and check their peaks

Comparing to the manual

[frozen ember]

I've not had much luck even getting automatic to work

despite having accepting the T&Cs

[chrome basin]

Did you make Egg strong?

Egg is a confirmed Strong since it was Strong last week, so be sure to check the override box on the far right.

[frozen ember]

oh I didn't see egg was strong in rec prep

[chrome basin]

[waxen pendant]

Yeah I just checked my version

[chrome basin]

It's usually right at reset on C1

[waxen pendant]

Egg strong should give you right results

[frozen ember]

yeah egg strong makes it work

does U mean Weak?

[chrome basin]

U means Unknown

[frozen ember]

ahh

[chrome basin]

AKA: An Imposter(?)

It means "C2-6 last season Weak Peak"; it shows Skyrocketing but we don't know what it actually is.
Egg was a last season C2-6 Strong and Skyrocketing so it was a true Strong

You combine last season's data with this chart to figure out if something is a true strong or an unknown

[frozen ember]

aaah k

[cyan kernel]

I'll be incorporating that on Auto mode once the major changes and fixes are done

Same issue as with scripts, if I add it now, it'd be a hassle to fix later

[atomic apex]

bug: it thinks Shark Oil isnt acceptable after Essential Draught

[cyan kernel]

Added to the to-do list

[harsh flint]

When I put in the work orders for cycle 4, as soon as I put in the 2nd item; it's changing the work orders on me.

1st item entered

2nd Item entered

[arctic fable]

What version is that?

[harsh flint]

5.311

[arctic fable]

Ah, not sure then, I had that with 5.3.1 but it seems to have gone away with 11 for me

[harsh flint]

Whats funny; if i start the new recommended set, when i put the boiled egg it flips to the original recommendation lol

[chrome basin]

So this is because of supply thresholds

The sheet internally calculates the value of mid-day supply changes correctly, but the suggestions window sadly does not, until it realizes "oh you're crafting that? That'll drop. Lemme give you a new suggestion" midway through your agenda input.

This will usually happen when the suggestions window recommends something that isn't peaking that day, or an item we've already used earlier in the week

While both Onion Soup and Spruce are C5-peaking items (and therefore, crafting them on C4 will give them a bit of a boost), the solver has no idea what kind of pre-peak (Weak or Strong) it will be, and therefore, cannot calculate what the supply will be, so it defaults to the fact that it's sufficient-none atm and would result in Surplus should you craft 6 of them, hence why inputting it would then change the values and spit out a new suggestion.

[harsh flint]

oh wow. would it be beneficial then to do a workshop split order this time? or just pick one of the two sets and run with it for all 3?

[chrome basin]

Nope, just to do the #🦜︱recommendations we've put out, which would be Rope - Bed - Rope - Bed.

The problem with using only one tool is all of them tend to "glitch out" in some way. Comp Guide was relatively useless on today when making Recs (outside of getting correct values after inputting an agenda). Beachcomber was closer, but still a bit off today as well, but that was likely a personal issue I keep having with it internally. We also have a bot in testing (currently in a private channel) that gave us a decent readout:

(also do note the above values depend on you swapping C3's 2nd rope to Brush, and all values are Grooveless)

But yeah, we went over what to pick for a "I rested C2, what do I do for C4?" rec for an HOUR this morning, so we recommend rope-bed-rope-bed (it's better than the 5-craft rec, trust me, we did extensive checking), but the 5-craft rec is pretty close too

[harsh flint]

Ahh okies, excellent, thank you very much! 🙂 ❤️

[chrome basin]

Leiton, please ping me when the threshold fix is in, ty

[cyan kernel]

I have a lot of things piled on a tiny plate. I'll get to things when I can. Sorry for the wait.

[waxen pendant]

Suggestion: You know how when you hover your mouse over a recipe and it shows you what material it uses? Can't you add the amount aswell?

Like: 2x Cabbage

[cyan kernel]

I'll add it to the list

[chrome basin]

https://twitter.com/Bloodkraft/status/1596209423466332160

Bloodkraft (@Bloodkraft)

@WorkshopParrot is it possible on the picture to place a "week # " say above cycle for example. Can be like W-14

Twitter · Nov 25, 2022, 6:29 PM

Just thought I'd drop this suggestion here

[indigo goblet]

So I'm having issues getting my sheet to utilize the automatic workshop information script. I was having issues on my first copy of the sheet, so I copied a fresh sheet at someone's suggestion, and I've accepted the ToS and enabled the script(Top Left of Workshop page reads "Current Mode: Automatic"). But the "READ BEFORE USE" tab is still persisting and the workshop page continues to not update after about a 20 minute wait.

[waxen pendant]

I made a copy to test this since i'm on pc now and apparently it's not downloading data from the cloud

We have that sometimes when the thing is offline

[indigo goblet]

Ah okay, so it's just a "It'll work when it works" type situation?

[waxen pendant]

That's what happened before :p

[quick wyvern]

if the read before use tab is still visible (not hidden), you likely need to run the Accept ToS script a second time

the first time you run it, you likely got a popup from google you needed to accept. After you accept that, you need to run the Accept ToS script a second time, since the google popup prevented the first run

[tawdry quartz]

If read before use did not go away, you need to re-run the Accept ToS script so it sets the schedules for pulling the data in auto mode.

the same script that hides the read before use sheet also is what sets up the triggers for pulling the peak data from the database.

[quick wyvern]

So what I typed above yea?

[frozen ember]

Had an issue with C5 where it was reccing me the wrong thing - wanted me to do potion-growth form. But as soon as I input one potion it flipped to the correct rec (because of mid-day supply)

[tawdry quartz]

Most don't realize it's the Accept TOS script that sets the scheduling

[indigo goblet]

Well thats the thing, on the first sheet I did that and still didn't get it. But as someone mentioned, it's something with the script getting info. Haven't checked if it's back to working yet.

[quick wyvern]

I can't speak to your first sheet, but your fresh copy sure as heck won't work if you don't accept the tos properly, which hides it.

[indigo goblet]

I've obvs done that by now

[quick wyvern]

so on your fresh copy, you have accepted the TOS again? is that copy now functioning?

[quick wyvern]

I can't take that for granted unless you tell me as such, since your previous statement made it sound like you had not

[indigo goblet]

Accepted, but not functioning

[quick wyvern]

is your fresh version a 5.4 or a 5.3.11 copy

[indigo goblet]

5.3.11. Someone had asked about the version prior but no one mentioned if it was an issue or not

[quick wyvern]

made my own clone of that version, it does not seem to be updating immediately. I'll check again in 5 minutes, but there may be an issue with the service that provides the auto data

that or something has changed in the sheet

[indigo goblet]

I've had two copies go for over an hour and not update currently. Let me try a 5.4 sheet and see if it just works

[quick wyvern]

I just cloned a 5.4 and it also isn't updating yet

despite the correctly applied TOS script and auto swap

iirc the script tries every 5 minutes so if it doesn't work in 5 then there may be an issue with the data source

[indigo goblet]

That cloud pull thing someone mentioned must still be going I guess

[indigo goblet]

This message

[quick wyvern]

Bruh I entirely missed that somehow, my bad

At least I got to the same conclusion…

[tawdry quartz]

database site is still down

fyi, you can test it by going manually to the site: http://island.ws:1483/?week=14

that's where the sheet pulls data

if that doesn't respond, it's not gonna update

[quick wyvern]

mienna is on vacation, so it's likely not going to change for a bit

[buoyant cloak]

Please tag me when stuff like this happens. It is trivial for me to reboot the server but I can’t do it if I don’t know about it

[buoyant cloak]

I’m gonna reply here as well. Please don’t accurately diagnose the problem as the server being offline without pinging me to fix it. XP

It literally will never recover if I don’t take action

[waxen pendant]

I had no idea this was needed xD

[buoyant cloak]

Yeah. Idk. Sometimes the server just stops being a server. I haven’t looked into it too much because it doesn’t throw any errors to direct my troubleshooting and we’re probably going to be moving it once we get our website hosting up

[quick wyvern]

yea sorry, I considered it and then when I remembered the like...3 other times I've pinged you because "oh no it's down" when it wasn't at all, and hesitated. Rip

[buoyant cloak]

Have you? I don’t remember a single instance of this

[quick wyvern]

well there was at least...one time? where I pinged you asking if it was down and it turns out I needed to accept the ToS more times

maybe I'm misremembering. oh well. I'll ping you next time. 🫡

[buoyant cloak]

Poked the server. It's back up 🙂

[soft raptor]

Is this right? In Rec, it says base is 4k

Using beta 5.4

[waxen pendant]

Are you on manual or automatic?

[soft raptor]

Manual

Dunno how automatic works with solver

I dont have C3 inputs tho

[waxen pendant]

And your workshop tab is fully filled with c1-c4?

[waxen pendant]

Then it wont work.

[soft raptor]

Oh, ok then

[waxen pendant]

Switch to automatic and it will download supply from the cloud

[chrome basin]

Egg's value will be wonky due to C2 though

Egg - Egg = 5175
Earring - Egg = 5151
Egg - Earring = 5127
Earring - Earring = 5103
(can replace Earring w/ Butter)

[soft raptor]

If I switch it to auto, it doesnt show me anything tho. Gonna check whole guide again

[chrome basin]

"READ BEFORE USE"

[soft raptor]

Ye ye, just reading it again

Hmmm, I have accepted ToS before. Do I need to accept it every time I open it?

[waxen pendant]

Probably not, you already downloaded th supply/demand

[chrome basin]

Yeah if you missed Brushes, Brush Crook is better

Tools were kinda borken this week and I didn't see Brush Crook anywhere until after recs

[soft raptor]

Yes I did.

Awesome tool again.

Fuck, I have fangs for only 2 crooks

I seriously need to replace animals

[waxen pendant]

?pasturesetups

[obtuse basin]

Several of our recommended pasture setups can be found starting here: #1035157933165649971 message

[soft raptor]

So probably one column with crooks, other 2 with fingies

[queen quartz]

Q: on the newest spreadsheet "📺 Video Tutorial Soon 📺" will this include how to manually set up the greyed out/hidden columns that are updated with the script if we choose manual mode instead of auto?

A: "LeitonGrey: But to answer: I'll be adding some quick-change functionality for easier swapping between Manual and Auto"

[cyan kernel]

v5.4.1 is now live.

Pasture tab fixed with recommendation for GREENFEED.

Granary tab fixed so it properly pulls next week's granary values when in Auto mode.

Workshop tab updated with leaving/crop/granary costs in entirety.

SP4 updated to properly use 6-craft items in calculations.

SCRIPT: Accept ToS has been altered, new Initialize Timers has been added, and READ BEFORE USE tab has been updated with proper instructions.

[chrome basin]

It keeps wanting to do early items that are really good, which would be quite an opportunity loss.

[cyan kernel]

I'm like 99% sure Mienna and I already tested and confirmed that using strong items on early peaks is better than saving for later

[chrome basin]

Shark Oil is not peaking in any way.

[cyan kernel]

Oh that

Hmm

I can prooooobably fix early usage

If it hasn't peaked yet, and isn't peaking next day, 1/4 value

[waxen pendant]

Did you mean crafting 12 eggs now and still using it for later links?

[cyan kernel]

Ya

[waxen pendant]

Guess we need new softcaps for eggs 😓

[tawdry quartz]

i already gave up my grand buffalo for a blue beak just to get some extra egg

[cyan kernel]

We'll have plenty of weeks without eggs

[chrome basin]

It's a solid 4h, but it's arguably the worst of the main 1-leaving ones like Knife, Butter, Earrings, etc

CC's a good category, but Foodstuffs is not at all. It's just been High/VH very often lately

[tawdry quartz]

i don't like confections because you're pigeon-holed into only doing confections as the only confection with a second category is islefish pie

[chrome basin]

It'd be nice if 6.3 gives every category multiple 4h/6h/8h with some secondary categories.

Alternatively, remove Confections and make them all Foodstuffs plz

[waxen pendant]

Recipes just need a complete overhaul

[chrome basin]

Foodstuffs instantly becomes a solid category

(with no 8h)

[tawdry quartz]

at least with foodstuffs, both the 4h link to other stuff

[cyan kernel]

Give Arms a 4hr opener pls for the love of god

[tawdry quartz]

this, yes

[cyan kernel]

Confections at least have each other

Arms have literally nothing

Furniture needs some love too, it's trash

[tawdry quartz]

Arms most of the time is dependent on the secondary links. Poor Iron axe has no 4h secondary tho

we need a Metalworks 4h...

We need like a Isleworks Stiletto or something

hrm.... Isleworks Hook (Metalworks/Sundries)... if only...

[chrome basin]

??? It at least has Crook/Rapier

Furniture is a dead category, as is Metalworks

Like Arms could definitely use some bumps up, but it at least has a link, unlike Furniture (Bed) and Metalworks (I don't even remember)

[tawdry quartz]

metalworks is silver and scythe

[chrome basin]

Okay fair

Still, almost every category is missing something

4h links, good 8hs, secondary categories to link to, etc.

[cyan kernel]

When I said Arms have nothing

I mean that rapier and crook have garbage connections, and nothing else has any

[tawdry quartz]

lmao, bronze sheep.... metalworks/furnishings. even if it were VH/NE good luck

[cyan kernel]

Oh boy firesand

[chrome basin]

Unburied Treasures

[tawdry quartz]

macua/crook have necklace...

[chrome basin]

Concoctions

[chrome basin]

Why are you even mentioning Macua?

[cyan kernel]

Iron Axe will never be crafted, ever

[cyan kernel]

I hear a certain avian loves it

I still demand a parrot in a barbut wielding a macuahuitl

Pls

[chrome basin]

It was actually in a primary alt-rec recently.

[chrome basin]

lissenhereulittleshit

[chrome basin]

By all means if you wanna pay an artist, I won't turn down gifts

I just imagine a floofy smol parrot wearing a helmet and his eyes aren't even seen cuz he's so smol with a sword like taped to his wing

[arctic fable]

please make this happen

[cyan kernel]

Non
It's the bird picking up a knife gif

[chrome basin]

https://tenor.com/view/bird-knife-threaten-what-did-you-say-ill-cut-gif-14394092

[cyan kernel]

But parrot in a barbut picking up a mini macuahuitl

[arctic fable]

does last night's announcement mean the beta 5.4.1 link is no longer a beta?

[cyan kernel]

Technically still beta

I let updates go 1 week before pushing to stable

Juuuuuuust in case

[arctic fable]

fair enough, know that feeling

[arctic fable]

@cyan kernel minor nitpick on 5.4.x, in the instructions it says initialize timers, but the automation menu item's labelled initialize triggers

[chrome basin]

#1045653739236753438 message
Mienna found the issue for the 2820

[arctic fable]

also not sure if important or expected, but the value it comes up with for the recs today differs from what was calculated in the recs channel

(2568 vs 2952)

[chrome basin]

Do you have Butter's Imposter box checked?

CG (Comp Guide) assumes ALL C2 items are weak-peaking unless you check the box

[arctic fable]

I don't, wasn't aware of having to do that

[buoyant cloak]

(2568 vs 2952)
This is the same math but assuming a weak peak. It uses Insuff for the first row of Butter and Suff for the second

[arctic fable]

let's see...

[chrome basin]

If you did everything correct, it'll show 2820 (which is still incorrect due to a bug, but at least you'll know you didn't mess up )

[arctic fable]

confirmed

2820 with it checked

[chrome basin]

It's a common issue on C2 yeah

Even with automatic mode, you still have to check the box because C1 is dumb and stinky and I hate it 🔪

[arctic fable]

are cockatoos your spirit animal? 😄

[chrome basin]

whowat

[arctic fable]

they're the angriest parrot species I've run into 😄

🔪

[cyan kernel]

Fixed

[cyan kernel]

Fixed

[chrome basin]

5.4.2?

(tybb ❤️ sorry no want to booli)

[cyan kernel]

v5.4.2 LIVE

• HOTFIX: 6-craft calculations fixed (again)
• Renamed scripts to remove confusion.

[chrome basin]

chef's kiss

(PS: Pin and first tab still say 5.4.1)

[frozen ember]

NEGA PARROT

[chrome basin]

Lol I use the Dark Reader plugin because bright-ass whites feels bad on the ol' eyeballs.

[tender bough]

I wonder how it'd look if you only inverted the luminance curve instead of flipping the colors

oh, wait, that's what it's doing (otherwise we'd have yellow cowries)

[chrome basin]

https://tenor.com/view/jfk-clone-high-i-like-your-funny-words-magic-man-jack-black-gif-18659433

[tender bough]

https://en.wikipedia.org/wiki/Luma_(video)

[chrome basin]

Seems to be missing 60 cowries somewhere. Egg is C3S, should be getting Insuf for both. Butter still C2S, NE for both.
Parsnip and Earring/Knife are both the same value; neither hit the Insuf C2
Resolved.

[atomic apex]

can't explain lol

[chrome basin]

... what the fuck?

5.4.1 or 5.4.2?

[atomic apex]

5.4.2

[chrome basin]

Okay literally what the fuck

[atomic apex]

if you do knife its 3300 though?

[chrome basin]

Nope, also 3240

[atomic apex]

oh, wtf

[chrome basin]

Lemme just redo it

Parsnip - 204
Egg 1 - 792
Knife - 1254
Butt 1 - 1908
Egg 2 - 2550
Butt 2 - 3240

[atomic apex]

lol butt 1 and butt 2

sorry its 3 am, i am a child

when i put in parsnip, i get 264

[chrome basin]

I'm the one who typed it; I'm the child

wtf do you MEAN 264

Parsnip is High Suff None Suff None, right?

[atomic apex]

uh, sounds right

I dont use manual fill

but its C6/C7 so it should be suff none

[chrome basin]

4/5*

6/7 would be Insuf

[atomic apex]

yours says 4/5?

[chrome basin]

That's what a Suff-None would be yes

lemme go back to the island when my RETAINERS are coming back

Heck.

OH

OH WAIT A MINUTE

THIS IS THE BUG ISN'T IT

CLEVER GIRL

264 with Insuf; god DAMMIT

[atomic apex]

oh, yes

[chrome basin]

Yeah I got First Hour Bugged

[atomic apex]

makes sense lol

[chrome basin]

ffs

I'm so mad that bug is a thing

[atomic apex]

I really love the TC data

[frozen ember]

mine says 3090, probably because I usually only get to my recs later in the day

anyone have the data from this morning?

[atomic apex]

what data?

[frozen ember]

supply and demand

[atomic apex]

oh, no, I usually just plug in peaks

[frozen ember]

'cause sometimes it feels like inputting later in the day after crafts have started make the sheet wrong

[atomic apex]

it can

if your supply changed already in-game

I would use the automatic method

[frozen ember]

I've had issues getting automatic to work

[atomic apex]

what version are you using?

[frozen ember]

I was using 5.4.0 when I was having issues, I'm now on 5.4.2 for manual stuff but I've been having issues pretty much since Automatic was implemented

[atomic apex]

if that ones got only 2 things under Automation, you have to run the ToS one twice

for 5.4.2 they're split so you just run all 3

[frozen ember]

also, I personally feel that even if Automatic is faster, if Manual doesn't work for whatever reason or use-case that should still be investigated. Suppose for whatever reason that the script breaks like someone has a power outage or something. People should still be able to input what they see in game and get the answer out.

[atomic apex]

it does work

the data from automatic is just better than your individual data

[frozen ember]

it just feels like it's more of a black box than it used to be. When Leiton made their own data entries public on the older versions of the sheet, there was a resource so you could see if your supply had changed due to a craft earlier in the day. Now with the automation, and no record of if my supply has changed earlier in the day I can't tell if my sheet is wrong because of my supply change or another reason.

[atomic apex]

Right, and that was converted into the data that comes from automatic, which is also compiled automatically. It's better data, and it doesn't require manual effort.

Polar's issue this morning is an excellent example of that. his sheet showed the wrong data because it was just his data, whereas mine is from our database which is more accurate

[frozen ember]

ok but that's different -- that's a known bug in the game.

which we've known about since the beginning

[atomic apex]

but also the identical same problem, supply info being incorrect

Leiton has said he will add a way to expand the peak data into the sheet, but not sure when and really is just unnecessary

[frozen ember]

so where does the Database's numbers come from then? They must be inputted from someone's client right? Couldn't there be a similar issue to Polar's if the person whose game the data comes from is bugged like his was?

[atomic apex]

crowd-sourced from many people and goes by the lowest supply found in case some people crafted or the bug hits

[frozen ember]

is it publicly viewable?

[atomic apex]

yeah, http://island.ws:1483/?week=15

[cyan kernel]

I am presently contemplating creating a spreadsheet of my own, have it pull peaks automatically, and fill out the day's supply/demand based on them

Then it would just be a constant, steady resource of base supply/demand values for everyone who prefers manual

This would be... extremely easy to busy, frankly. Just takes time.

Nobody would have to copy it, it would just be a static link forever showing the base values

[frozen ember]

yeah it's just I've had issues getting the automation to work despite accepting ToS a few times and also I just prefer using my own numbers where possible

[cyan kernel]

The current sheet will always use your own numbers, now that breakpoints are fully implemented

The issue is that your own crafts can "hide" peaks, so manual entry will always be less accurate

[quick wyvern]

seems like a decent idea to have a super simple sheet of base data

as long as it isn't time consuming for the Makers, that is

at least then when people are on manual and getting weird info we can point to it and go "does your data match this"

[cyan kernel]

That's exactly why I wanna make it

Shoooooould have time this week. Was going to do it last week but didn't have time with all the fixes on comp guide.

[quick wyvern]

any idea why 5.4.2 would not be updating on auto mode despite running the scripts

sigh

oh the answer was "literally the moment you complain it'll figure it out after 5 minutes"

sheet saying to run pudding caramel c6 when they peak c7 is interesting

[woven tartan]

pants-on-head question: how much time do i need to give the sheet in auto mode before it fills in the workshop tab? like a moron i forgot to set schedule yesterday and am trying to solve out my remaining time orz

[tawdry quartz]

it's supposed to attempt to pull peaks every 5 minutes until it has data for the day

technically, the pull peaks script runs every 5 minutes, but it just stops once it sees it's already set data

if you go to extensions > app scripts, you can always run it manually if you don't want to wait. The script is PullPeak

[woven tartan]

hmmm i got a loading bar off that, but something about my browser i think is just breaking everything--would be hard to reproduce though since idfk what im screwing up tbh

[tawdry quartz]

did you ever get the screen to give the sheet access to your google account?

[woven tartan]

yup

honestly itd probably be more effort to figure out how im mysteriously breaking it (firefox? im gonna blind-guess firefox) than to just math out base * pop * demand real quick

ive only got two 6h options to choose from, effectively lol

so was trying to kill a mosquito with a flamethrower i think--not fully caffeinated rn tbh

[tawdry quartz]

we can set the data manually for now. In the workshop tab, unhide columns AC-AG

make sure the top looks like this:

4W
2W
2S
5S
7S
3W
7W
6S
2S
6S
3S
5W
3W
3S
6S
4W
2S
2W
6W
3S
3S
5S
5W
4S
5S
7S
7W
7S
4S
4S
6W
7S
2W
3W
2W
5W
7S
4S
5S
5W
6W
6W
7W
6S
7W
4W
4W
2S
3W
7W

paste that in for column AC3-AC52

you can then re-hide columns AC-AG

[woven tartan]

should the solver be "awaiting input"? i filled out cycle 4 and clicked the done box--it's calculating cowries with groove, but things like it displaying the items being made dont seem to be working:

im basically just trying to gather info at this point since i haaaaaaaaaate being the user thats like "thing broke, pls fix, no idea what i did"

[arctic fable]

FWIW, I use it with Firefox without issue

even with ublock origin and a bunch of other things

[woven tartan]

yeah im running like, adblock and noscript, but my noscript is "let google do whatever it wants" right now

as someone thats worked tech support before, im driving myself nuts right now lol

[arctic fable]

possibly dumb troubleshooting question, tried grabbing a fresh copy of the sheet and stepping through again?

[woven tartan]

it was fresh, but lemme try another

trying both the stable and beta sheets, just waiting to see if they pull data rq

[arctic fable]

did you fill in just C4 or all of C2-4?

[woven tartan]

just 4, which makes me think this is a PEBCAK

also it looks like the beta sheet can pull automatic for me, the stable notsomuch

so that initialize timers was the trick there

[arctic fable]

I've never tried that, the solver might not be able to handle not having data for all the days

you could try filling stuff in for C2/C3 from what was posted in #🤖︱bot-recs

[woven tartan]

yup--PEBCAK, the sheet wanted C2/C3 to predict C4

[arctic fable]

my brain will never not parse C4 as the explosive at first glance

[quick wyvern]

Yea you need every day’s data

[frozen ember]

for some reason the sheet is reccing Knife instead of rope as the first craft C5 despite both the Base and Groove values being better for rope

[waxen pendant]

Hm?

Knife should have higher value

But it should change once you click the first knife

[quick wyvern]

@buoyant cloak the website seems to be down

[chrome basin]

Wrong channel

[quick wyvern]

is it? last time this is where the pinging occurred. where would you rather it be? lol

[chrome basin]

Oh is this for Auto?

Then I guess right channel? idfk

[quick wyvern]

yea it's the website that has the data for the autosheet

[atomic apex]

its done by the bot which is no worky anyhow

[quick wyvern]

and maybe also the bot idk

yea the site seems to just be down entirely, rather than missing data

[atomic apex]

yeah, happens when database isnt used for too long. for no apparant reason

[chrome basin]

nvm my b

My brain is split 30 ways

[tender bough]

literally nobody querying server after friday?

[ebon reef]

oh is that why the spreadsheet isn't working

i just downloaded it for the first time and was like, wat XD

this is all i'm getting, so I wasn't sure if it was because something was wrong on my end

[buoyant cloak]

The server is back up, for the record

Sorry, forgot to mention

It has been since like 2 hours ago

[ebon reef]

oh, then it is me. Is there something I'm doing wrong to not get this to populate?

[arctic fable]

it grabbed data here without issue

you have "check when done" checked

you're not going to get reqs for C3 until tomorrow if that's what you mean

[atomic apex]

you also arent showing like...the rest of the sheet. it doesnt fill in the right side for you

[arctic fable]

the right side is to fill in what you're actually crafting that day

[ebon reef]

so this is normal then?

just wanna make sure XD

[arctic fable]

yes

[atomic apex]

yup

[arctic fable]

top left is your suggestions

[ebon reef]

okai!

[arctic fable]

though odd, C2 suggests resting for me

[ebon reef]

yeah it took me forever to find this place lmao, I was trying to check for updates since I had the 4.1 sheet and was like, "uhhhhhhhhh"

c2 for resting?

OH

i see it

[arctic fable]

as in Cycle 2 says Rest Recommended for me in the sheet

[ebon reef]

yeah, I just set it up in accordance to how i had it before

i unchecked the rest day and it's showing that now

[atomic apex]

yeah it wont suggest rest if one is picked

[arctic fable]

oh, yeah, didn't see you had one checked

[ebon reef]

X3

[arctic fable]

so yeah, sheet's working fine

[ebon reef]

WELP TIME TO FIX THAT

[arctic fable]

but in any case, on the right hand side you need to fill in what you're actually doing that day, since the sheet needs to know that for future predictions

[ebon reef]

yeye

[arctic fable]

(since people might not be able to make the best rec due to material shortages)

[ebon reef]

i was used to the other one lmao

this XD

[arctic fable]

yeah, it's changed a bit, but it's overall a lot simpler to use now IMO

[ebon reef]

hecc, i gotta go fix my workshops now XD

so would i be correct in assuming the cowries plugin for dalamud follows this then?

or is that not affiliated?

[arctic fable]

I don't know the answer to that, @buoyant cloak might

I suspect unrelated though

[ebon reef]

ah okai

i love the mammet one. Don't have to spend 20 minutes inputting things anymore lmao

[buoyant cloak]

Beachcomber is by me, it's a completely different algorithm than the spreadsheet

[ebon reef]

ah!

very cool c:

[buoyant cloak]

One, thank you for pinging me! Two, I told the bot to ping the database every hour, and if it doesn’t get a response to ping me, so that you don’t have to moving forward

Either the ping will keep it alive, or it’ll notify me that it’s dead. I consider this a win-win

[buoyant cloak]

This is technically a spushi question: Hey Leiton, where does your list of schedules come from? Like, which efficient schedules are you pre-emptively removing?

[cyan kernel]

5.4.3 To Do

• Check future peaks for Big 9 items and reduce estimated value to weigh against using them early

[cyan kernel]

All efficient 3, 4, and 5 craft agendas that are efficient and don't use triples.

[soft raptor]

Latest beta. Does recomend <4200 crafts. Any idea why? Its all in auto. Or does it predict some crafts that will be more profitable later?

[atomic apex]

You need to mark cycle 3 as done. Look at the top left and you'll see it's still trying to figure out C3

[soft raptor]

Im going to burry myself

[atomic apex]

Bury me too. I have a 2-hour meeting in an hour, and I only got like 2.5 hours of sleep

[soft raptor]

I hope your meeting was fine

[atomic apex]

still in it lol

[frozen ember]

is there something up with the formulas on the sheet, or did Recsbot get the numbers wrong? Both Auto and Manual for my sheet give 4131 Base (4719 w/ 15 Groove) for tomorrow

wait never mind, just read the tweet

[atomic apex]

....I now kind of have a desire for Polar's parrot head to be placed on Tweety

[chrome basin]

[chrome basin]

CG is giving you the right numbers, assuming Firesand isn't a C7S. Mienna has coded BC/RB to assume worst case scenario (Firesand is C7S), so it lowballs on purpose.

Both numbers are correct; we don't know which it is.

[atomic apex]

Schrodinger's cowries

[frozen ember]

yeah I thought so - I was just worried something was hecky

[chrome basin]

There's a 9/14 chance CG is correct and a 5/14 chance BC/RB's lowball is correct.

[harsh flint]

Is there a way to put in a custom entry and get around the "data validation violation error"?

and still have it count for items created?

that happened

[quick wyvern]

no.

[cyan kernel]

Presently no

[quick wyvern]

ok so @buoyant cloak I know you said you don't need to be pinged if the site is down...but it's not "down" per say, it's just...lacking in data?

[atomic apex]

it gets updated by the bot, which never ran

[harsh flint]

Which is the current version? 5.3.2 or 5.3.11?

[quick wyvern]

neither of those lol

[harsh flint]

https://tenor.com/view/oh-my-star-trek-gif-19129737

[quick wyvern]

well 5.3.11 is the latest "stable" but we're on 5.4.2 beta

see pins

[harsh flint]

saw the pin, the .11 had me confused lol. Wife had a .2 version and i was like, how did you get that one? she's like i just got it from the link in reddit

so used to .11 being one one not eleven

Can we put suggestions in here or do they need to go elsewhere?

[quick wyvern]

here's probably fine?

[harsh flint]

Suggestion for the Granary Tab for Manual mode to be a little more automated. Have the granary manual input pull from the Workshop tab automatically so that way when the user updates the Weekly Popularity on the Workshop tab the Granary updates with it.

Cells B3 thru B7 on the Granary tab would need to reference =Workshop!O22 thru O26

[cyan kernel]

No. The granary tab says "Next Week's Popularity," not "This Week's Popularity." It's meant to be used for pre-planning.

[arctic fable]

anyone happen to know why 5.4.2's recs for c3 are absolutely nothing like today's recs? my c2 was brush -> shield -> brush -> shield, and its c3 suggestion for me is brush -> scythe -> cuffs -> scythe which....isn't even in the recs list in #🦜︱recommendations

[brittle lava]

i unlocked island sanctuary only yesterday, so i missed my chance to make c1 a rest day and didn't have enough materials to set the work agenda properly according to recommendations. would it be a huge disaster if i do how i see fit until i've reached a decent rank/piled up enough materials?
i've read somewhere that supply/demand is the same for everyone but the guide says it changes depending on what you craft, so i'm a little confused. 🤔
& will the demand/shift reset every weak or is it an ongoing process?

[arctic fable]

it starts the same for everyone each week

on c1 it all resets

from there it diverges based on what you craft

the reason we set c1 as a rest is so we can see what the week has reset everything to, and figure out what's best to start crafting from there

[rose dagger]

c1 also has nothing peaking, so it's the worst day to do any crafting on even if we did know what to craft ahead of time

[arctic fable]

if you only just unlocked the island though, you won't be able to make the vast majority of things

so for now your main concern is just levelling up and building everything

[brittle lava]

ah, i see. so i can 'ruin' this weak (i more or less understood how it works) and go exactly according to recommendations starting the next weak. thanks for clarifying. :>
and sorry if you answer the same questions time and time again. i scrolled through various threads but couldn't find the answer. ;;

and that's what i've meaning to do. levelling, building and storing materials before i set the work agenda properly. 💪

[arctic fable]

yeah, you won't really be able to take full advantage of the agendas here until rank 9 or so

since you won't have the upgraded workshops, etc.

[brittle lava]

duly noted, thank you! <3
by the way, is there a recommendation on what best to build on landmarks? 3 workshops and the granary is a given, as i understand.
but you can also choose between a wind mill, tree fort and bathhouse. are those of any use or just for aesthetic purposes?

[arctic fable]

the landmarks are whatever you think is pretty

they have the same effect otherwise

(some xp for building them and I think some effect on the workshop but I can't remember what it is)

[brittle lava]

alright, now i know what to do and am less confused, you have my thanks. 🤗

[arctic fable]

np

[rose dagger]

landmarks increase groove cap! and you need all four plots filled for the outfit tataru gives you and the otter fountain

[arctic fable]

ah, groove cap, that was it thanks

either way, it doesn't matter which landmarks you choose

[brittle lava]

oh, i see! right now i only have one landmark, so i need to wait until i get four by doing the 'main quests' with each rank, yes?
if it doesn't matter which landmark, though, all the better, i can turn the wind mill into a bathhouse then. :>

[buoyant cloak]

Just so it's in the right channel, for debugging purposes: This is the same rec Recsbot made when trying to figure out what to make for the rest of the week with only C1's info

[rose dagger]

you can also just build a bathhouse later on XD

[buoyant cloak]

So it seems like a stab in the dark for a C3 rec if you're missing C2's peak data

[arctic fable]

if it matters, it gave me this rec when I opened it like... 2 hours ago?

it does have flakes -> radish as its bottom rec

[buoyant cloak]

Just to be 100% sure, the database has info from C2

[brittle lava]

ah, i thought it's an upgrade like a renovation because the bathhouse popped up later in the list.
if it's just another option, i'll better wait, otherwise it'd be a waste of materials. c:

[buoyant cloak]

Wait

[arctic fable]

any other info I can gather?