Crafting Sim FFXIV: A Step-by-Step Guide to Crafting in Google Sheets
Introduction
Crafting is a crucial aspect of SimFFXIV, allowing players to create and customize their characters’ equipment. In this article, we will guide you through the process of crafting in Google Sheets, a powerful tool that enables you to create and manage your crafting recipes.
Setting Up Your Google Sheet
Before you can start crafting, you need to set up your Google Sheet. Here’s a step-by-step guide:
- Create a new Google Sheet by clicking on the "+" button in the top left corner of the screen.
- Give your sheet a title, such as "Crafting Recipes."
- Set up your sheet by creating columns for the following information:
- Recipe Name: The name of the crafting recipe.
- Ingredients: A list of ingredients required for the recipe.
- Quantity: The quantity of each ingredient required.
- Cost: The cost of each ingredient.
- Total Cost: The total cost of the recipe.
- Crafting Time: The time required to craft the recipe.
- Notes: Any additional notes or comments about the recipe.
Creating a Crafting Recipe
To create a crafting recipe, follow these steps:
- In the Ingredients column, list the ingredients required for the recipe.
- In the Quantity column, enter the quantity of each ingredient required.
- In the Cost column, enter the cost of each ingredient.
- In the Total Cost column, calculate the total cost of the recipe.
- In the Crafting Time column, enter the time required to craft the recipe.
- In the Notes column, add any additional notes or comments about the recipe.
Adding a Recipe to Your Sheet
To add a recipe to your sheet, follow these steps:
- Click on the Insert menu in the top left corner of the screen.
- Select Table.
- In the Table Properties dialog box, enter the following information:
- Table Name: The name of the table (e.g. "Crafting Recipes").
- Column Names: Enter the column names for each ingredient, quantity, cost, total cost, crafting time, and notes.
- Click OK to save the table.
Editing a Recipe
To edit a recipe, follow these steps:
- Select the Recipe Name column.
- Click on the Edit button in the top right corner of the screen.
- Make the necessary changes to the recipe.
Using Google Sheets to Manage Your Crafting Recipes
Once you have created and edited your crafting recipes, you can use Google Sheets to manage them. Here are some ways to do so:
- Filtering Recipes: Use the Filter function to quickly find specific recipes. For example, you can filter by Recipe Name or Cost.
- Sorting Recipes: Use the Sort function to sort your recipes by Cost, Quantity, or Total Cost.
- Searching Recipes: Use the Search function to quickly find specific recipes. For example, you can search by Recipe Name or Ingredients.
- Creating a Recipe Book: Use the Insert menu to create a new sheet for your recipe book. This will allow you to organize your recipes in a logical and easy-to-navigate way.
Tips and Tricks
Here are some additional tips and tricks to help you get the most out of Google Sheets for crafting:
- Use Conditional Formatting: Use conditional formatting to highlight specific recipes or ingredients that are missing or have incorrect information.
- Use AutoFill: Use auto-fill to quickly enter the quantity or cost of each ingredient.
- Use the Filter function: Use the Filter function to quickly find specific recipes or ingredients.
- Use the Sort function: Use the Sort function to sort your recipes by Cost, Quantity, or Total Cost.
Conclusion
Crafting in SimFFXIV is a fun and rewarding experience that requires careful planning and management. By using Google Sheets to manage your crafting recipes, you can streamline your crafting process and save time. With these tips and tricks, you can take your crafting to the next level and become a master crafter in no time.
Additional Resources
If you’re interested in learning more about crafting in SimFFXIV, here are some additional resources:
- The Official SimFFXIV Wiki: The official SimFFXIV wiki is a comprehensive resource that covers everything from crafting to character development.
- SimFFXIV Forums: The SimFFXIV forums are a great place to ask questions and get help from other players.
- SimFFXIV YouTube Channel: The SimFFXIV YouTube channel has a wealth of tutorials and guides on crafting and other topics.