PLD Equipment Planner

[Jahaudant]

Added HP and and damage/enmity table to the demo.

Thanks for pointing out the missing drops, I clearly didn't pay much attention to that part!

[Lucavern]

Not sure if it was intentional Jahaudant, but I think you lost the Food category in the demo when making the last round of changes.

[Jahaudant]

It was intentional. Because of how food stats change depending on your current total each table (2 on the main sheet, and 1 on the demo) requires a separate reference. See the food section on the equipment sheet.
I don't have time to do that right now so rather than break the demo completely I opted to just remove the food option.

I'll re-add food to the demo soon.

[Lucavern]

Not a problem at all Jahaudant. I kinda figured it was intentional as the references for the totals would have been broken otherwise. My spreadsheet skills are a bit rusty, but I wonder if its possible to set it up to do a comparison against a value (i.e. 3% of total vit) while putting a max value on it. As it looks right now in the food table, you hard-coded the food values based on stats assigned to the relative set. I can take a crack at it if you'd like, got an idea or two that might pan out.

Edit: Duh, yeah it is. Would just need to wrap an IF statement around the value. This is what I get for being half-asleep.

[Soulburn32]

- Coil Drop Locations by Armor Slot -


Head: Allagan Helm [Turn 5]

Chest: Heavy Allagan Armor [Turn 1]

Hands: Heavy Allagan Gauntlets [Turn 4]

Waist: Allagan Plate Belt [Turn 2]

Legs: Heavy Allagan Cuisses [Turn 2]

Feet: Heavy Allagan Flanchard [Turn 1]


Neck: Allagan Choker of Fending [Turn 1]

Ears: Allagan Earrings of Fending [Turn 2]

Bracelets: Allagan Bracelets of Fending [Turn 4]

Rings: Allagan Ring of Fending [Turn 2]


Sword: Allagan Blade [Turn 5]

Shield: Allagan Round Shield [Turn 1]

[TheGlow]

What factors into the HP setting for Party? It looks like you just have a hard value in there.
And the 2nd set is just for visual comparisons?
Initially I was just copying the same book/sheet and ctrl+pgdn/up and toggling between to see differences.

[Lucavern]

Jahaudant, sent ya an email with updates to the Food tables. Take a look and let me know if it looks right.

[Jahaudant]

Getting a parse error on all the cells to do with food in the sheet you sent. Nonetheless, I think you are trying to do something the spreadsheet already does?

Open the original, put all i90 gear on and select HQ Finger Sandwich for example. Now start removing equipment. You'll see the food stats adjust as you lose VIT/Parry/Acc.

Use of the MIN function does this quite simply.

[Lucavern]

Hmm, lemme take a second look at that. Not getting any errors on my copy. Food values weren't updating as I removed gear on the copy I made.

Edit: SOB! I found part of the problem. When downloading a copy as a .xlsx it looses the formulas on the Food table as just statically sets what they were at time of download. *sigh* So yeah.... I just reinvented the wheel in a sense. For example, I ended up using =IF((SUM(Main!F$6:Main!F$20)*0.05)>23,23,(SUM(Main!F$6:Main!F$20))*0.05) for HQ La Noscean Toast's Parry for Set1. *Grumble*

Still not sure why you are getting parse errors though with the file I sent ya.

[Jahaudant]

Probably the same reason I was getting parse errors. Excel and Google Spreadsheets don't always play well together!

TheGlow: Party HP bonus is 3% of your total VIT rounded down then multiplied by 14.5.