PLD Equipment Planner

[Jahaudant]

Updated for 2.38

PLD Equipment Planner v2.38.2 - Click to Open

How to use
This is the main sheet that I work from personally, and where I'll be copying over updates from my test sheet in the future. You will have no edit permissions so the first step is to create your own copy. To do this click "File", then "Make a copy...", and name it whatever you want. You can now edit your copy. If you wish to see how the planner functions before doing this you can check out the Demo sheet Demo sheet removed due to repeated vandalism.

The only fields that you need to change are the race select and the equipment select drop-downs that allow you to select the gear for each available slot. Lastly, you will need to edit the allocated stats cells with your distribution of your 30 optional stat points.

The equipment select drop downs pull the gear and their stats from the Equipment sheet. It's pretty self explanatory should you want to add your own items such as low level dungeon or melded gear.

To-do List

• Add functionality for custom Nexus and Novus stats without having to mess with the master equipment list.
• Make accessory lists more user friendly in terms of DPS and tank selection.
• Add buff switches for Rampart, Sentinel and Bulwark.
• Include defensive buffs average mitigation over time in mitigation and EHP display.
• Include Sword Oaths additional 50 potency attack in the auto-attack damage display.

Notes and Issues
The damage and enmity tables are based on formula provided by Valk (http://valk.dancing-mad.com/) who seems to have dropped off the radar since the final Beta Test ended. His numbers are not 100% accurate, but they are close.

The planner may not work correctly if exported and opened in Microsoft Excel or similar.

---
---

Updates

• 26/09/2014 - v2.38.2
  • Included Skill Speed in enmity per second calculations.

• 26/09/2014 - v2.38.1
  • Updated the equipment lists for patch 2.38.
  • Removed all gear lower than item level 80. These items are now inconsequential even to brand new players.
  • Added the following food effects: (HQ) Popoto Pancakes, Steamed Catfish, Lava Toad Legs, Stuffed Cabbage, Apkallu Omlette, Black Truffle Risoto.

• 23/12/13 - v2.1.2
  • Base HP and VIT HP cells are no longer displayed since these numbers are relatively useless to users.
    
  • A new option "In Party?" has been added. Changing this will switch the party bonus to all of your stats on and off. Note: this option assumes all stat bonuses are applied (STR, VIT, DEX).
    
  • Damage formula has been updated to be more accurate.
    
  • Block and parry mitigation formulas has been updated and should now be correct.

• 16/12/13 - v2.1.1
  • Average item level display has been added.
    
  • The planner will now automatically remove head armor stats when using Heavy Darklight Armor, and feet armor stats when using Heavy Darklight Flanchard.
    
  • New equipment has been added; Darklight Macuahuitl, Darklight Kite Shield, Lord's Celata, Lord's Cuirass, Lord's Gauntlets, Lord's Plate Belt, Lord's Trousers, Lord's Sabatons.
    
  • New food has been added; HQ Sauteed Couerl.
  Credit goes to Griever2003 for sharing his work and allowing me to include his ideas, thank you!

• 16/12/13 - v2.1
  • Updated existing items to correct 2.1 values; Allagan Blade, Heavy Allagan Gauntlets, Heavy Allagan Cuisses, Curtana Zenith, Holy Shield Zenith, The Wall of Crags.
    
  • New equipment has been added; Break Blade, Morbid Mogblade, Onion Shield, Crown of Light, Armor of Light, Gauntlets of Light, Belt of Light, Breeches of Light, Sabatons of Light, Ultima Choker of Fending, Ultima Choker of Striking, Tremor Earring of Fending, Tremor Earring of Striking, Inferno Bangle of Fending, Inferno Bangle of Striking, Vortex Ring of Fending, Vortex Ring of Striking, Ultima Band of Fending, Ultima Band of Striking.
    
  • An easy comparison table has been added.
    
  • Block and parry stats are now displayed courtesy of YarozeX
    
  • i70 crafted accessories have been added with max melded valued set by default (change these to your own melds in the equipment tab).
    
  • All items have been renamed and reordered for easier usage.

• 1/11/13 - v2.0.1
  • Changed food to display the correct number based on your current total respective stat that food is meant to increase. For example, HQ Finger Sandwich will now give you 14 VIT if you have under 500 total VIT, but will adjust itself to give you 15 VIT once you surpass 500 total VIT.
    
  • Fully implemented race select. No longer required to manually edit your STR value.
    
  • Adjusted Shield Oath enmity modifier.

---
---

Any feedback or suggestions for improvement, error reporting etc would be greatly appreciated!

The sheet is free to use and copy at your whim. It's built in a way that makes it incredibly easy to re-purpose to any job/class in the game and I have absolutely no problems with anyone that would like to do just that. If you do use my sheet as a base for another jobs equipment planner I would appreciate a mention though!