How to Use Landsouls spreadsheet
WILDLY OUT OF DATE
I hope to get an updated version for the latest edition of the spreadsheet up and running some time in the near future
This guide will hopefully help people learn to use the landsouls spreadsheet, which has been the gold standard for warrior DPS simulations for a long time.
for a lot of the images might need to right click -> view image in order to see exactly what's going on and what stuff looks like.
You are going to need a version of excel that is '97 or sooner. I own excel 2007 and the screenshots used will be from that version of excel. all of the screenshots were taken using version 2.602 of landsouls spreadsheet.
Most of this information is presented in the manual presented in the intro tab. this guide is NOT a substitute for reading it. This guide is designed to help you if you are having problems understanding how to use the spreadsheet after already reading the manual.
Go to this link:
you should see this:
The fury Tab
Please note that the arms tab is set up exactly the same as the fury tab,
after entering in your character name and server, press the green button to have it load your armory in to the spreadsheet.
For each area of the equipment section, there are drop-downs with all gems/gear/enchants you can use for that slot
The Item drop down is sorted by the +/- DPS rank in the lookup tab (I will discuss this later on in the guide)
Gems are sorted by quality and color
Now on to the lookup tab
Also located in the stat adjustment area is the "check sheet" option. This is the setting to change which tab (fury or arms) the lookup tab will be drawing its data from.
Please note that the +/- DPS values in the lookup tab do not always correlate to the values of the fury or arms tabs. when there is a conflict in numbers, trust the fury/arms tabs over the lookup tab.
so lets say you got a new item, and want to know the best gem set up to use for that item.
In this example I am going to use getting a shadowmourne as an example.
Before changing anything this is what my loadout looks like:
Changes will always be outlined in red
Now because I see that I am over 100% ArP I automatically know that it would do me no good to use another ArP gem in the 3rd socket in shadowmourne, so I add a 20 STR gem.
Any ArP rating beyond 100% is wasted. since I am above 100% I need to check if having an ArP gem that is only being partially used is the best use of a socket. In cases like these you want to try and find a yellow socket with a decent socket bonus and then use an orange gem and see what result that has on your DPS metric. In this case I used a +10str/+10crit gem, and it in fact was a DPS increase.
Because I am a jewlcrafter there is one more gemming path that I need to check out which is changing my +34 ArP gem in to a +34 STR gem and then making all of the other gems be ArP. Although I am close to the ArP cap with this setup it is a minor DPS loss. this is probably due to the "free" stats gained from gaining the socket bonus by using the orange gem.
I hope this guide has been helpful for you, if you have any questions, comments, or suggestions feel free to post them.
Some of these screenshots show the player named piston being loaded, that is not me. that is one of my fellow guild mates that I originally posted on my guild forums to help him learn how to use the spreadsheet. Do NOT whisper piston in game.
I know landsoul has a copyright on his spreadsheet, so I know I should have some sort of disclaimer recognizing that he owns the rights to it, I do not pretend to be the creator or copyright holder of the spreadsheet, all recognition goes to him for that. (insert a proper legal disclaimer here)