Pokemon Scarlet/Violet - Sandwich Research

*** Recipe lookup site: psandwich.io
*** Updated 12/12/2023: Information is fully complete!

BASIC INFORMATION
All sandwich ingredients contain hidden values that have been datamined. You can see a listing of values here: https://serebii.net/scarletviolet/sandwichingredients.shtml
https://docs.google.com/spreadsheets/d/1cHY8_SEP50bCZYCBb3V4MPq20xLPN5JXKrEtF1FNbNI/
When added to a sandwich, some filling ingredients have multiple pieces, and their contribution to the recipe is multiplied by the number of pieces successfully added to the sandwich. The powers and types in the sandwich are determined by the highest values contributed by the sum of all ingredients. The top half of the baguette is a special ingredient with all values equal to zero, so it makes no difference if you add it to the sandwich or not. Furthermore, your choice of pick makes no difference and is simply an aesthetic choice.


FLAVOR BONUS
The highest flavor in a sandwich will add +100 of a power to the sandwich as listed below, but only if the total value of that flavor is 16 or higher:

  Sweet:  Egg Power +100
  Salty:  Encounter Power +100
  Sour:   Teensy Power +100
  Bitter: Item Drop Power +100
  Hot:    Humungo Power +100

However, if the two highest flavors are the following (with no particular order), it will result in these powers instead, and it doesn't require the minimum value of 16:

  Sweet + Hot:    Raid Power +100
  Sweet + Sour:   Catching Power +100
  Salty + Bitter: Exp. Point Power +100

Flavor value ties are resolved in this order, chosen from left-to-right:
  Sweet, Salty, Sour, Bitter, Hot


POWER AND TYPE
After all power values are added up, the top three values are chosen and then ordered from highest to lowest.
Power value ties are resolved in this order, chosen from left-to-right:
  Egg Power, Catching Power, Exp. Point Power, Item Drop Power, Raid Power, Humungo Power, Teensy Power, Encounter Power

The highest three type values are chosen and ordered from highest-to-lowest, then paired with the powers of the same rank.
Type value ties are resolved in this order, chosen from left-to-right:
  Normal, Fighting, Flying, Poison, Ground, Rock, Bug, Ghost, Steel, Fire, Water, Grass, Electric, Psychic, Ice, Dragon, Dark, Fairy
However, the final two types are swapped when pairing with the powers. For Egg Power, the type is still paired, but simply isn't shown.

If the top type is 280 or higher, then the type assigned to the top power is assigned to the second power as well, shifting down the type that would be assigned to the second power to the third one instead. In that case, the third power will be assigned the third highest type due to the aforementioned swap.
Finally, if the highest type is 480 or higher, then all powers will be assigned the top type.


LEVEL
To get a power of level 2 or higher, the total value for that power must be 100 or higher. In addition, to get level 2 of a power, the type value assigned to that power must be at least 180, and for level 3, it must be at least 480. However, for the third power in a recipe, it cannot be a higher level than the highest power. Additionally, for the third power to achieve level 2, its assigned type and the highest type must both be at least 280.
This is summarized by the following table:

      MINIMUM (POWER, TYPE) VALUE REQUIREMENTS
         1st Place Power | 2nd Place Power | 3rd Place Power
Level 1       1, 1       |      1, 1       |      1, 1
Level 2     100, 180     |    100, 180     |    100, 280*
Level 3     100, 480     |    100, 480     |    100, 480*
* 1st place must also meet the same requirements of 3rd place for 3rd place to increase in level.


ADDITIONAL CASE
If all six fillings are the same large filling, and the level of the first power is 2, then the second power's level will be 2. These are the large fillings: Fried Fillet, Hamburger, Noodles, Potato Salad, Rice, or Potato Tortilla.


HERBA MYSTICA
Herba Mystica add 1000 Title Power and 250 to all types. With at least one Herba Mystica, the power requirement for the second power is removed, making it always level 2, and if the top type is at least 280, the third power will be level 2 as well. Additionally, adding two or more Herba Mystica will add Sparkling Power and remove the power requirement for the third power as well, making all powers level 3. Sparkling Power and Title Power will be the top two powers, leaving only the third power changeable.
In single player, the maximum values of a recipe make it impossible to get 280 in a type without at least one Herba Mystica and it's also impossible in single player to get 480 in a type without two Herba Mystica.


PRESET RECIPES
The rules here apply to creative mode sandwiches only, and not the recipes obtained in-game. If you make a sandwich matching the recipe of a named sandwich, no ingredient stats are checked, and you will simply get the powers preset for that sandwich. If the completion screen says a custom name instead of "A Tasty <Name> Original," that means it's a preset game recipe.


CREDITS
Reddit user Illustrious-Big-2992 for finding the dual flavors mechanics.
Most of this was translating the source code from this project to human readable language: https://www.reddit.com/r/pokemon/comments/zeqt4i/i_made_a_scarlet_violet_sandwich_calculator/
(More are credited there. The work done is theirs, I simply summarized the findings.)