Stardew Valley

Stardew Valley

Not enough ratings
100% achievements in Stardew Valley. A useful table!
By Rigbi_Raket
A table created for intermediate players, those who are already somewhat familiar with the game and need tools to assist with progression or tracking their progress.
   
Award
Favorite
Favorited
Unfavorite
The guide was originally written in Russian and automatically translated into English. However, I personally went through almost all the item names to ensure they match those used in the game itself. If you find any discrepancies with the English version of the game, please let me know so I can correct them. I am not a native English speaker, so there may be some mistakes, if anything - always glad for your corrections! Thank you.

Ссылка на руководство на русском языке [Link to the manual in Russian] ↓
https://gtm.steamproxy.vip/sharedfiles/filedetails/?id=3210875155
Initially, the guide was written with the goal of providing a quick start, but it was later reworked into a more comprehensive and informative table.

The table also allows you to track your progress in a semi-automatic mode - if you're aiming for perfection or achievements, you can fill in parts of it to keep track of your progress. More details are provided in the description of each page.

I highly value your feedback, as I am committed to maintaining, improving, and making this table more user-friendly for you. So, please share your criticism, suggestions, and ideas - everything will be read and possibly implemented!

Version 1.1 has been released - more details can be found on the "Debug → Table Version" page.
The table is created in Google Sheets, so to use it, all you need to do is follow the link, click on "File" in the top left corner → Make a copy, then name it as you like and start using it!



Link - https://docs.google.com/spreadsheets/d/1vFdhmw5Mj0IN3K2ykVQQRg5QfSUn-mX1oe64qL34OmA/edit?usp=sharing

Since the table is online, it can be accessed from any device:
• On a PC: If you have a browser installed, you can use all the features of the table.
• On a phone: You can also use it in a browser, but Google Sheets has poor adaptability for mobile devices, so I recommend downloading the Google Sheets app on your phone (via official marketplaces under the name "Sheets"). However, even there, some navigation issues may arise. More details will be in the navigation section.

Below are two sections:
1. Navigation: Tips for using the table, shortcuts, and basic features of Google Sheets.
2. Description: An explanation of the table sheets to help you navigate through it.
This section will help you quickly navigate the table and utilize all its features to unlock its full potential.

Table on PC

Keyboard Shortcuts
  • Ctrl + F or F3 or Ctrl + H
Ctrl + F and F3 are shortcuts for searching and work not only in tables but also in any browser on any page. In the table, they search only within the visible data - they ignore hidden cells or data on other sheets.
Ctrl + H is a shortcut for searching and/or replacing text / formulas. If you need to find data across different sheets or within hidden cells on one sheet, you can use this search function, which will display the cell where the desired value is found.

Clickable Navigation Elements
  • Checkboxes
Checkboxes (empty squares) are values that change when clicked. They have only two states:
• Empty square - "False" (0), meaning the checkbox is inactive.
• Square with a checkmark - "True" (1), meaning the checkbox is active and confirms the presence of something related to it.
  • Expanding Rows / Columns via the "Plus" Icon
Throughout the table, you may notice "plus" icons on the left and top - these are groups of rows or columns that can be expanded or collapsed by clicking on them. They are used to hide potentially useful information until needed.
If you see a row / column that seems incomplete or missing some data, it is likely hidden.
  • Expanding Rows / Columns via Cell Numbers / Column Names
If there are too many hidden cells, right-click on the block on the left → Expand All Groupsor Collapse All Groups. The location of this block is shown in the image below:



Table on Phone
  • Most Actions with Taps
The table on the phone has an annoying habit - any tap (except zooming in/out) activates the editing mode, which hides the sheet names (replacing them with table tools). You can exit this mode by tapping the checkmark in the top left corner.
  • Using Navigation
To switch to another page from the main one, tap the cell with the link, and an additional window will appear. Tap it to go to the desired location.
To expand groups, in the phone app, there is a double arrow in the top left corner. Tapping it enables the use of "plus" icons (to expand / collapse groups).



General
  • Various Colors
For items / resources where cell colors are used, their meanings are defined by the seasons in which they can be obtained:
• Pink / Purple - Spring
• Green / Light Green - Summer
• Orange - Fall
• Blue / Turquoise - Winter
In all cases, only one color per cell is used, indicating the first season in which the item can be obtained/found.
  • Reading Notes
On some sheets, there are cells (usually marked with an asterisk at the end of the text) with a small triangle in the corner:
• On PC - It is black. To read, simply click the cell.
• On Phone - It is white (if dark mode is enabled, otherwise black). Tap the cell → Show Note.
  • Careful Use
Remember, when copying the table to your own drive, you become the editor. Edit carefully, as some actions may break cells containing formulas or auxiliary elements, rendering the table non-functional. But don't worry:
In Google Sheets, you can always revert to a previous state (every edit is tracked and recorded on Google's servers). To restore the table to a working state:
• On PC - In the top right, to the left of "Share," there are three buttons. Click the first one (clock-arrow), find the desired moment, and revert to that save.
• On Phone - Only through the browser. Go to the link: [https://docs.google.com/spreadsheets/u/0/](https://docs.google.com/spreadsheets/u/0/), open the table, and follow the same steps as on PC.
A section created for a brief overview of the table itself so that you can further navigate through it. The description will be divided into two parts:
• At the beginning of each sheet, there will be an excerpt from the table, as it is the most concise and allows for quick understanding.
• Then, I will explain in more detail what this sheet can be useful for or clarify certain points.

🔘 Main

  • This page is created for quick switching to other sheets:

By tapping (on mobile) or hovering the cursor (on PC), you will have the option to go to the link (to the sheet) you need.
  • The page contains descriptions for each sheet (except the main one, where all this is written):

To reveal the description, you need to click the plus sign on the left to expand the full page description.
  • Descriptions for some pages differ in formatting:

There are pages where the description is divided into sections, as such sections exist on the page itself. Where the description is not divided, the page represents a single category.

🍽️ Cooking

  • This sheet lists all the necessary resources for creating all dishes:

If you aim to complete the cooking achievement from the start of the game, this will help you see the necessary resources and save them for later use.
[When I decided to pursue this in my game, I had to wait a whole year to get a seasonal plant I needed.]
  • Checkboxes are also added to track personal progress:

Checkboxes require manual clicking to mark a dish as cooked (when clicked, the color and highlight will change, making it easier to distinguish uncooked dishes).

⚙️ Crafting

The same working principle as "🍽️ Cooking", but for crafting items.

📦 Bundles

  • Checklist for all bundles:

Helps track progress on bundles without having to check each one individually in the game.
  • Locations / methods of obtaining items can be found in other sheets:

Locations are stored in hidden columns on other sheets. More details about hidden columns – in navigation.

💎 Collections

  • A sheet dedicated to a specific category in the game, which can be viewed in the player's inventory:

Here, you can find item locations (shipped items), recommendations for finding them (artifacts and minerals), as well as mandatory conditions required to obtain certain objects (fishing).
*This sheet also allows tracking progress.

🔢 Calculator

Crops & Trees

  • This section lists all crops and trees that can be profitable:

• When planting crops, it's important to consider not only the profit per unit of the finished product but also the overall benefit in relation to time spent and the cost of saplings.
• Trees generate income only in the long run, as their saplings are quite expensive in the early stages, making their profitability low within a single season, let alone a day.
  • Profit is calculated approximately to show the profitability of each crop:

The calculator is based on formulas found online, meaning the table describes theoretical values that may slightly differ from actual numbers. However, it provides a general picture of farming profitability.
  • In addition to profit from raw crops, processing profitability is also calculated:

Beyond profit from planting → harvesting, the profitability of processing crops in different ways (kegs/jars/barrels) is also calculated per day / season.

Food

  • This section calculates the cost of making food by purchasing ingredients:

This is primarily designed for one of Mr. Qi's quests, but if you have excess resources and cooking skills, nothing stops you from using it for profit.
*Resources that cannot be purchased are not counted (treated as zero), which makes the calculations slightly biased, but this method of earning is usually relevant at the end of the game when resources should be in abundance.

Stardew Valley Fair

  • This section calculates the necessary points from selected products to win the contest:

This is a dynamic calculator that computes points based on the items you select - you can check if your items will allow you to win.
*On the next sheet, there is the same calculator for the achievement, which includes my suggested way to win in the first year.

🏆 Achievements

  • Methods for obtaining these achievements are described:

Each achievement has an explanation of how to obtain it. Some are simple and self-explanatory with basic descriptions and my comments. More complex achievements are broken down into steps, with checkboxes available for tracking completed stages.

The sheet is divided into two main parts (manual and semi-automatic tracking) + perfection (which belongs to the first but requires additional interaction)
  • Manual tracking

These achievements do not require separate sheets. They are marked either immediately (upon completing a certain action, you need to enter and check the box) or step-by-step in their description.
  • Semi-automatic tracking

Some achievements involve collecting items, which are counted from other sheets or from other achievements. However, everything in this section is fully automatic and does not need to be manually adjusted.
  • Additional events

These events do not have Steam achievements but hold in-game value for progression. They require tracking and function similarly to other achievements.

Debug

A sheet that enables part of the table to function; it is recommended to modify it only if you understand how Google Sheets works.
I would appreciate any comments and feedback - rewards and thumbs up, all are welcome!