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!

[CianaIezuborn]

I(I currently don't have an accurate set of base stats for each race at 50)

Race STR DEX VIT INT MND PIE
Hellsguard 20 17 21 20 22 20
Sea Wolves 22 18 23 17 21 19
Sun Seeker 21 22 20 18 19 20
Moon Keepers 18 21 17 19 23 22
Dunesfolk 17 20 17 21 22 23
Plainsfolk 18 22 18 21 20 21
Duskwight 20 20 19 23 20 18
Wildwood 19 23 18 22 17 21
Highlander 23 20 22 18 20 17
Midlander 21 19 20 21 18 21

Class STR DEX VIT INT MND PIE HP MP HPCoeff MPCoeff
Paladin 171 161 214 91 171 140 2214 1474 14.5 0

Note: VIT is accurate on Paladin base stats, I need to go back and recheck the other base stats.

Here's what I've picked up and use in my spreadsheet, so far it's been accurate when predicting paladin stats. I think the only bug I had in VIT calculation was from the party bonus that you helped me correct, but I've been accurately predicting different race HP totals outside of a party with these numbers.

If you'd like I can send you a copy of my spreadsheet with these base values, I'm not going to post it here due to not wanting to distract from yours which I think is more complete for secondary stats and a lot more polished. Thanks for your work!

[Leiron]

I believe the issue is that the enmity buff isn't 2x, if it was, a Paladin in Sword Oath would not be able to catch up to a Shield Oath.
I genuinely believe the buff may actually be lesser, a 20% buff.
That would explain why the enmity generation of a Paladin in sword oath is higher.
It takes you 25% longer to deal the same damage a Paladin in Sword Oath would deal, and since damage also is a major component for enmity, the enmity buff does not make up for the difference in damage.
As such, a 20% enmity buff would be below the 25% damage loss, and would explain the enmity generation loss.
Unless I am mistaken in which case please correct me on the matter.

[CianaIezuborn]

Also, I've got drop down lists for the different equipment slots for quick changing of gear for comparison. To add a drop down list for say, weapon slot:

1. Select C6
2. Click Data -> Validation
3. Criteria = List from a range, choose the range to be Equipment!A2:A8
4. On invalid data: Reject input
5. Appearance: check Display in-cell button to show list

On mine I actually go from range A2:A30, it won't show options for empty cells. Saves some changes in the future as you add more gear. It looks like if you added that then VLookup would handle pulling the correct values as you change gear.

[Jahaudant]

The sheet uses drop downs for all equipment slots (and race select). You won't see the drop downs until you've made a copy of the sheet! Until then you do not have editing permissions.

Edit: I've removed protections on the document, protected each sheet individually, and added a Demo sheet that anyone can view, edit or vandalize at their leisure.

If you could take another look and let me know if the Demo is working for you, and if it's possible for you to edit any of the other sheets? Thanks.

[Jahaudant]

Updated with better food functionality, working race select, and adjusted Shield Oath enmity modifier.

[Soulburn32]

Can someone break down the gear from coil and what if any pieces have to be purchased with myth.

Like just a quick and dirty slot by slot of the gear and what turn of coil it drops on.

[Jahaudant]

Funny enough, I have these listed in the random info section of the Equipment Planner.

Turn 1
Heavy Allagan Armor (LEFT)
Heavy Allagan Flanchard (LEFT)
Allagan Choker of Fending
Allagan Round Shield

Turn 2
Heavy Allagan Cuisses (RIGHT)
Allagan Earrings of Fending
Allagan Ring of Fending
Allagan Plate Belt

Turn 4
Heavy Allagan Gauntlets
Allagan Bracelets of Fending

Turn 5
Allagan Helm
Allagan Blade

[Soulburn32]

edit: never mind i'll just look up the names and what slot they go with

[Lucavern]

Demo page appears to be working without making copy now Jahaudant. Can not modify the Main/Equipment/RandomInfo sheets. Would you consider adding the hp table to the Demo sheet?

Random Info page appears to be missing Allagan Round Shield from T1 and Allagan Tasset of Fending from T2 (forget if thats the actual name or not, forgive me).