optimizer Sheet
Below you will find info regarding this google sheet, what each tab does, and how you can contribute. If you don't feel like reading and just want to jump in, I won't judge.

Current Version:

Important to know:

• As the sheet grows, so does its performance impact. have some patience with it <3
  
• During Development the cell-limit was reached. A new version/feature would require a full rebuild, a lot of time, and might come at the cost of the ease of use of the current I/O Sheet.

Additions:

• Finn gifts
  
• More Cauldron Control
  
• Ingredients known by zone
  
• Brewplanner Improvement
  
• Bonus Stars Implementation
  
• Cheapest Recipes per type and rarity (for expeditions)

To Upgrade:

• Copy all user input from the 4.0 front sheet to the new one

Previous Versions:
v4.1[docs.google.com]
v4.0[docs.google.com]
v3.0[docs.google.com]
v2.0[docs.google.com]
v1.1[docs.google.com]
v1.0[docs.google.com]

Data Sheet
Since Optimizer v3.0, the optimizer sheet builds from a separate data sheet. This has three main benefits:

• When new or wrong data is brought to my attention, I'm possibly able to edit/add it to the data sheets, allowing all users to get the data update automatically.
  
• the almost 7k perfect recipes that are provided to the sheet are calculated on the data section, since there's no reason why every user should do this for themselves, costing them performance!
  
• Should anyone wish to build sheets based on the collected data, they can totally do so from the data sheets directly. That way their own sheets will receive dynamic updates too!

Current Version:

Previous Versions:
v1.0[docs.google.com]

Sheet Management
On this workbook, I just keep short data on which sheets exists, what state they are in, and what they are for. It allows me to update the current version and push the link right to your current sheet (optimizer v4.0+).
Recently I moved the list of features and their development status / notes to this sheet aswell.

The front page of the sheet is where most of the magic (doesn't actually) happen.
You'll enter all data related to your specific playthrough on this sheet, and see any data generated for you here. All in one convenient place.
All the blue squares are means for user input, and any data protection required is applied!

Ever mess things up anyways? You can always grab a fresh copy!

These Tabs were made so you can look at Data your way.
You can:

• Use All Filter View Features
  
• Sort
  
• Hide Columns
  
• Rearrange Columns
  
• Hide Rows
  
• Rearrange Rows

This is where the magic happens. As a general user, you shouldn't have need to go into these.

If you encounter any missing or erroneous data: Please contact me, I'll add the information to the external data sheet in a way that will safely update for everyone.

Should you wish to take a look, I certainly won't stop you. But be careful, so much as dragging a cell somewhere could destroy a lot.

Gathering the data for this game has definitely been a for-the-community, by-the-community project. Should you find any data or calculation in the sheet to be incorrect or missing, please consider contacting me so I can have a look at the cause of the issue. Try to provide as much related information as you are able to expedite the process of a solution being implemented!