Differences

This shows you the differences between two versions of the page.

--- moonshine:freth_s_moonshine_guide [2025/01/16 11:15] – [Steps to Success] freth
+++ moonshine:freth_s_moonshine_guide [2025/03/10 10:27] (current) – freth
@@ Line 7: / Line 7: @@
 ===== The Numbers =====
-There are 138 skills in Wurm Unlimited.  When you cook a recipe, the result has a value that points to one of the skill affinities.  What determines the total value of the result are number values of the cooking furnace (campfire, oven, etc.), the container cooked in, the ingredients themselves and rarities.
+There are 138 skills in Wurm Unlimited.  When you cook a recipe, the result has a value that points to one of the skill affinities.  What determines the total value of the result are number values of the cooking furnace (campfire, oven, etc.), the container cooked in, the ingredients themselves, and rarities.
-What determines the duration are the quality of the ingredients, the quality of the result, the preparation (chopped, etc.) and the added flavor (salt, etc.).
+What determines the duration are the quality of the ingredients, the preparation (chopped, etc.), the added flavor (salt, etc.), and the quality of the result.
 Knowing this, it makes sense that you need to know the values of each furnace, each container, and each ingredient.
-Thankfully, someone else has already done the work for us.  I have listed the known number values [[moonshine:freth_s_moonshine_guide#numbers|below]].  You can also find all number values at [[https://wurmfood.com/|Wurmfood.com]].  Each drop-down has the values.
+Thankfully, someone else has already done the work for us.  I have listed the known number values [[moonshine:freth_s_moonshine_guide#numbers|below]].  You can also find all number values at [[https://wurmfood.com/|Wurmfood.com]].  Each drop-down has the values.  You may also want to check out their [[https://wurmcoders.com/moonshine|moonshine generator]].
-Gather the numbers together in a list.  I recommend a spreadsheet.
+Gather the numbers together in their respective tables.  I recommend a spreadsheet.  More on how to configure a spreadsheet [[https://freth.us/player/doku.php?id=moonshine:freth_s_moonshine_guide#steps_to_success|below]].
 ===== The Recipes =====
@@ Line 57: / Line 57: @@
 What you'll need:
-* The numeric values for various items (see [[moonshine:freth_s_moonshine_guide#numbers|below]]).
+* Choose a method for calculating recipe totals.  I use a Google Docs spreadsheet.
-* A way to calculate recipe totals.
+* Copy the [[moonshine:freth_s_moonshine_guide#numbers|value/item pair tables]] into your project.
-* A simple test recipe to determine player offsets.  Your own is all that matters on Mythmoor.
+* Configure your project to access the data for visual presentation and calculations.  For Google Docs you'll want to set up [[https://support.google.com/docs/answer/63175?hl=en&co=GENIE.Platform%3DDesktop|named ranges]] and use [[https://support.google.com/appsheet/answer/10107325?hl=en|data validation]] to lookup and retrieve data in your tables.  These two functions will give you an interactive spreadsheet you can use to create recipes and see the affinity they point to.  I made a [[https://www.youtube.com/watch?v=E045p7D9LmU|video]] on how to use these functions.
+How to calculate:
-. Make a spreadsheet calculator, it'll save you a ton of time.
+* Add up the values of furnace, cooking container and ingredients.  To keep things simple I ensure none of the items I'm using are rare, because rarity adds to the total.  This means my oven is normal, my cooking containers are normal, and my ingredients are normal.
-. Create a "Data" tab in your spreadsheet and paste in the .
-. Reference those value/name pairs.
+* Determine your own affinity offset by devising a simple recipe.  Add up the recipe values in your calculator (again, furnace, cooking container, ingredients, any rarities).  Once the values are added up, use the modulus function to get the remainder of your value against 138.  This effectively reduces the total down to a number between 0 and 137.  You can then use this number to see what the default affinity is that the recipe points to (match the number with the default affinity table).  This is the actual affinity the recipe points to //before player offset//.
+* Taste the recipe you made to see what affinity it will give you.  The difference between the default affinity number and your tasted affinity number is your character's offset.  You will need to factor this offset into all recipes you make.  Once I had my 138 recipes, I ordered my recipes into a new list, based on my character's offset, and reference it when making affinity moonshine.
 ====== Numbers ======