I've opened up these numbers on the sheet (they're all there, just hidden). In case it isn't obvious, when dealing with the sheet...
Perception
Green = Confirmed number
Yellow = Assumed number based on information provided and patterns in other numbers
Rarity Increases
Green = Confirmed number
Light Blue = Predicted number
Rarity at completion
Dark blue = Rotation can be used for blue scrips
Red = Rotation can be used for red scrips
Yellow = Rotation can be used for counterfoil
Green = Rotation can be used for 8/8 quality on ephemeral node
Nice! I'll try to get these added in at some point today. I can't post while I'm at work but I can still view threads, so I'll do it while that's going on and reply when I get back home.Yes, I'm that bored. Bored enough (but also inspired by your work) that I even went and bought +perc food that grants +2, +3, +4, and +5 perception respectively, to test for absolute perception caps for levels 56, 58, 60, and 1-star folklore. I neglected level 59 items, but I'll go back and do that. I also found the absolute floor for level 56 items, and using this I will try to extrapolate floors and test them for the other items.
Knowing these caps, I feel like we can extrapolate other values for the other items, but I'll get around to trying this out later. The exact difference between ceiling and floor is 101 perception.
-level 56: 539 perception cap; 438 perception floor (80 on methodical appraisal; 439 perception was 83 on methodical)
-level 58: 563 perception cap
-level 60: 585 perception cap
-L60 1-star: 695 perception cap
Yeah, I did consider that. But given that it doesn't add up for the two rotations mentioned (when dealing with Cuprite) despite it being 4x MA for both (one is 4x MA directly, the other 2x 1.5 MA and 1x MA), it's clear that once you push in the number, decimals are not retained in any way. Effectively it must be rounding up/down at the point of action, rather than just hiding any decimal numbers within the rarity value of the item you're working on. So it's important to keep this in mind. ^^I think what is happening is that there is some hidden decimal number for the base amount of the methodical appraisal that rounds to produce each of those results, probably something like this:
(MA = x1.0 potency; DE + MA = x1.5 potency; Impulsive = x0.9 potency; Impulsive + DE = x1.35 potency)
If we assume proper rounding at the tenth's digit (round down at 4, round up at 5), then these numbers seem to line up
Thankya.nice work!Same to you!
Awesome! We now have confirmed numbers for everything when it comes to gathering requirements, and safely assumed numbers for all perception requirements (would be nice to get them confirmed, I might try your food method later on to get this done).Testing for these next!
EDIT: yes, you can one-shot clear with 648; testing 647 next. Also as far as 94 rarity from methodical, initial calculation suggests around 631-633 perception (I noticed 475-477 perception gave 94 on methodical with a cap of 539, a difference of 62-64. the one-star cap being 695: 695 - 62 = 633; 695 - 64 = 631) I will gear for this and try on the next set of nodes.
EDIT 2: for the legendary nodes: 647 is a 1-shot clear; 631 perception was 94 on methodical, 141 on methodical with discerning eye, 84 on impulsive (ran out of attempts to try impulsive + discerning eye). My data suggests that the lowest possible might be 630, so I can try again with 630 but that might require some remelding, and 629 would drop it down to 92 if my calculations are correct.
EDIT 3: Just tested methodical again with 630 and 634 perception on folklore node: both came out to 94
EDIT 4: Tried again with 629 and 635 perception. 629 was 92 on methodical; 635 was 96 on methodical.
That leaves just the 82/83/84/85/87 numbers to be confirmed for ME, DE-ME, IA and DE-IA... although I should probably note that at this moment they are mostly irrelevant for Cuprite onwards, but it would be nice to have accurate calculations for future reference. It'd at least be interesting for the sake of getting certain results (eg. if you want 3/8 instead of 8/8) on ephemerals.