Teachings of the Red Crane Spreadsheet

by

Hello and welcome to the guide for the Teachings of the Red Crane spreadsheet for Mistweaver! With the setup process being streamlined from the Legion version of the spreadsheet, a majority of this guide will go into explaining all the options in the dropdowns, as well as some caveats that had to have been made. Each section of the Table of Contents will take you to a different page in the spreadsheet.

From WoWAnalyzer

This page is used as a landing page for the spreadsheet, containing a link to this guide, a link to making a new copy of the master sheet, as well as a “Recent Change” block that will update and recolor itself if your version of the sheet is ever out of date from the master sheet.

WoWAnalyzer is a powerful tool for analyzing your combat logs, and a lot of the data in the spreadsheet needs the variables from WoWAnalyzer in order to give accurate data. In a given log for your Mistweaver, there is a tab called “Player Log Data” with all the data from the log that is relevant from the given fight. Highlight all of it and copy (Ctrl+C) it. In the spreadsheet, delete everything in the Orange-colored cells, and paste without formatting (Ctrl+Shift+V) the data from WoWAnalyzer into the “From WoWAnalyzer” block’s upper leftmost orange cell. This repopulates the cell with your own specific combat log, giving you accurate results in the rest of the sheet.

From WoWAnalyzer, highlight one of the tables in the Player Log Data tab and copy it.

In the spreadsheet, clear out the current data in the From WoWAnalyzer page and paste without formatting (Ctrl + Shift + V). Do this again for the other table.

If Ctrl + Shift + V doesn’t work, right click the cell to paste to and select Paste Values Only.

If you are having issues with pasting double-spacing itself, try using another internet browser when copying from WoWAnalyzer, or paste it and reconfigure it in another part of the spreadsheet.

Setup, Results, and Tools

This page contains some setup that can be used to tune your player with raid consumables, as well as some important tools for your specific situation, including mistweaver stat weights, trinket comparisons, and tier one azerite trait values. Each block will have its own heading in how it affects overall results, as well as how to read some of the Tools.

Pre-Fight Options

This block is fairly self-explanatory, as it contains everything that would be available to you before a boss is even pulled.

Pre-Fight Options block.

  • Character Race – For this variable, only the passive throughput increases are taken into account. The actives are taken into account in the “Character Race Rankings” graph later on.
  • Flask and Augment – These variables are binary, yes/no answers to if you have them active or not.
  • Weapon Enchant – This variable adds the average uptime of the secondary stat buffs to the stats’ ratings. While Coastal Surge and Siphoning aren’t available in this dropdown, they are still shown in the “Weapon Enchant Rankings” graph.
  • Intellect Buff – There are three options for this variable; “None”, “From Scroll”, or “From Mage”. Each option gives a different amount of Intellect gain, with None increasing your Intellect by 0%, the inscription scroll giving 7% gain, and the Mage buff Arcane Intellect giving 10% intellect.
  • Level 15, 90, and 100 Talents – If you have the spreadsheet looking at the WoWAnalyzer data (more on other options below), these three must be set to the talents used in the given fight. When more data is present in the “Previous Logs” page and the “Log to Analyze” is changed to “Average From Logs”, different talents can be selected based on the variables in the averages.

Spreadsheet Options

This block alters what set of variables is loaded in for weights, as well as controls the display options for later graphs.

Spreadsheet Options block.

  • Log to Analyze – Choose between “From WoWAnalyzer” or “Average from Logs” to load in which set of variables to get stat weights and other results.
  • Player Stats – You can load in three different stat ratings. “From Player Stats” loads in the “Player Stats” block on this page, “From WoWAnalyzer” loads in the stats associated with the current fight in the “From WoWAnalyzer” page, while “From Previous Logs” takes the average rating of stats from the logs in the “Previous Logs” page of the spreadsheet.
    • It is intended that the “Player Stats” option should be used in either Log to Analyze’s options, while the “From WoWAnalyzer” option should only be used with the “From WoWAnalyzer” option and “From Previous Logs” should only be used with “Average from Logs”.
    • To explain further, using “Player Stats” allows you to set your stats in the spreadsheet to your current stats, regardless of what is in the entered log. Whichever dropdown you decide to analyze loads in all the variables to see how your different stats would affect that fight(s).
  • Include Active Character Racials – This toggle is purely for the “Character Race Rankings” graph, where it adds the average uptime of throughput increasing active racial abilities to the total throughput a specific character race can do. There are some active racials that aren’t included, like Blood Elves’ Arcane Torrent or Draenei’s Light of the Naaru, as they don’t immediately impact healing, or require another variable specifically for it to gain a weight.
  • Haste Weight – Haste is a tricky stat weight, as there are two different metrics that go into it, Efficiency (HPM) and Throughput (HPCT). Its efficiency weight is where it just increases the healing that your HoT effects do per cast, meaning your cast times are unaffected and you repeat the same casts with more Haste. Its throughput weight is more about being able to heal more in a given time frame, where you spam cast spells to deal with incoming damage.
    • Haste’s actual weight is somewhere between its efficiency weight and its throughput weight, but assigning a value of it somewhere in between is entirely arbitrary and not accurate; it’s on a fight-to-fight, group-to-group basis.
  • Trinkets Max Display – These two variables are used exclusively for the Throughput Trinkets Graph, allowing you to display trinkets at the difficulties you are able to clear and actually obtain said trinkets from.
    • Dungeon Trinkets have a base iLvL of 340.
      • PvP Trinkets are included in this variable.
    • Raid Trinkets have a base iLvL of 340.
      • World Boss Trinkets are included in this, and have a base of 355, except for Doom’s Hatred / Lion’s Grace, which are a base 370 iLvL.
    • Each iLvL option is added to the base iLvL. If a trinket doesn’t show up with the iLvL Cap’s color, it’s already reached the iLvL cap currently available.
  • Azerite Trait Display – This toggles the display of the Tier One Azerite Traits block between percent gains and the raw value of stats for each trait.

Trinket Comparisons

Trinket Comparison block.

Now that all the setup is done, time to get into the results! This block is for focusing in on comparisons between two specific trinkets, looking at their item level as well as if they have a socket, and comparing their effects against one another. Pretty simple, but very important.

Tier One Azerite Traits

This block is quite different from its artifact counterpart from Legion, because the true value of each trait is different depending on what type of content you’re doing, as the spell selection can vary wildly. The combat log that is used for WarcraftLogs, and subsequently WoWAnalyzer, doesn’t export dungeon content in such a way that the latter can easily parse. Meaning that this spreadsheet isn’t equipped to handle dungeon weights. However, the Azerite Traits block exists outside of logs (for the most part), as it shows how much each trait increases what it increases, instead of how much it affects your overall throughput.

Tier One Azerite Traits block.

This looks a bit intimidating, but it’s setup in a way that should be fairly intuitive. Reading a line, using the columns’ headers to fill in the gaps, should be enough to form a sentence. For example, given this specific log and all the variables not shown, “Font of Life from Uldir on Normal difficulty without the 5 iLvL trait increases the healing of Essence Font’s bolt by 8.88%”. Using this, you can look at fights where you had used Essence Font, increase its bolt healing by this amount, and compare it to another trait you may have to see how much it impacts your healing. The same can be done with any other azerite trait in this spreadsheet.

As is typical of my spreadsheets, all orange-colored cells are, and should be, changed by the user for their circumstance. The cells here have been edited to only allow changes from sources where they’re actually available from. Traits that can be found on both Raid and Dungeon sources have all difficulties present, but will only work where it makes sense (ie Mythic +10 Uldir doesn’t exist, while Dungeons is only Mythic difficulty on up, so Normal/Heroic will thrown errors as well).

Stat Weights

Empty Stat Weights block.

Moved to its own little area underneath “Player Stats”, this block tells you the normalized value of the next one rating of each stat you add to your total, which helps determine the value of gear to compare against one another. The values you’ll see when you load in the spreadsheet for the first time are not indicative of any real stat weights, as the variables used are arbitrary to test the sheet.

 

 

Item Comparison

Another fairly straightforward block, this tool assigns an Item Value to an item whose stats are entered in each column. If there are items that have an additional effect on them that affect your throughput, is an Equip Effects block that has the relevant information as well as a note describing what it is.

Item Comparison block.

Previous Logs

The next page of the spreadsheet is the Previous Logs page, where you can store the variables from up to 10 different logs to be used in the Log to Analyze dropdown in the Spreadsheet Options block in the Setup, Results, and Tools page.

In the From WoWAnalyzer block are all the variable from the log currently entered in the From WoWAnalyzer page, but the layout has been changed to be better for quick copy/pasting. To transfer these variables to be used later:

1. Select the cells C3:X5 and Copy them.

2. Select the upper leftmost cell of the range where you want to paste the current log’s data.

3. Paste without formatting (Ctrl+Shift+V) to place the log’s data! It should inherit the editable-orange it had.

And that’s it! You’ll have this log’s data to be used when you want to get the results from multiple logs at once using the relevant dropdown option.

Graphs

Sweet, sweet graphs.

Throughput Trinket Rankings

One of the major parts of the sheet is trinket comparisons. This graph compares all the trinkets that are mainly for increasing your healing, whether that be through stat procs or their own healing effects. This graph uses the Trinkets Max Display variables found in the Setup, Results, and Tools page to set the item level of the trinkets for this graph.

Mana Trinket Rankings

Following the same vein, this graph compares the three available trinkets that interact with mana with one another. However, instead of being looked at from a per-second basis, it instead takes the average amount of mana gained/saved over the course of the Fight Length variable.

  • Surging Alchemist Stone uses Coastal Mana Potion, the instant mana potion.
  • Fangs of Intertwined Essence is used an amount of times equal to Fight Length / 120, rounded down to the nearest whole number.
  • Darkmoon Deck: Tides’s mana values are bugged, only returning one amount instead of scaling.

Character Race Rankings

This graph is a bit weird, as some races share the same passive racial abilities, while other active racial abilities are omitted because they have no impact on your healing throughput.

  • Blood Elf’s Arcane Torrent isn’t factored in, as the numerous spammable spells Mistweaver has makes it difficult to assign a Healing amount to each point of mana.
  • Dark Iron Dwarf’s Fireblood, when included, assumes dispelling one debuff whenever it’s available.
  • Draenei’s Light of the Naaru is not included, as including Player Health can be a a bit fluid based on buffs.
  • Human’s Human Spirit passive racial is weak at the start of the expansion, where secondary stats are very small.
  • Mag’har Orc’s Ancestral Call splits up the stats added into the four secondary stats before taking their average uptime.
  • Night Elf (Day) and Night Elf (Night) are for the time changes in their Touch of Elune passive, where they get 1% Critical Strike in the day and 1% Haste in the night.
  • Nightborne have no healing throughput racial abilities.
  • Pandaren double whichever food is selected in the Pre-Fight Options block on the Setup, Results, and Tools page.
  • Undead’s healing from Touch of the Grave can vary wildly over a fight as it is essentially Leech, which is very volatile.
  • Void Elf’s Entropic Embrace assumes it is proc’d consistently every minute.

Weapon Enchant Rankings

A fairly simple graph, this one shows the average stat gain of the Navigation enchants, compared to Siphoning and Coastal Surge.

Transferring from Sheet to Sheet

Whenever an update is made to the master sheet, you’ll for sure want to transfer your Previous Logs page, while everything else should be easy enough to change back to how it was setup. To do this, select all the relevant cells in the Previous Logs page, Copy (Ctrl+C) them and Paste Without Formatting (Ctrl+Shift+V) them into the new, up to date copy of the spreadsheet.

Link to the Spreadsheet

Please make sure to set it up to your logs, as that is how the spreadsheet works best.

If there are any issues or questions you have with the spreadsheet, feel free to contact me on Discord (Garg#6987).


 

If you like this and the other content provided here on PeakofSerenity by myself and other Monks, consider supporting us through Patreon or Paypal. If you have any questions, leave a comment below or join us on the Monk discord channel, PeakofSerenity.