Page 2 of 6 FirstFirst 1 2 3 4 ... LastLast
Results 11 to 20 of 51
  1. #11
    Player
    Jahaudant's Avatar
    Join Date
    Aug 2013
    Posts
    315
    Character
    Jahaudant Rivea
    World
    Sargatanas
    Main Class
    Conjurer Lv 60
    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!
    (0)

  2. #12
    Player
    Lucavern's Avatar
    Join Date
    Sep 2013
    Posts
    95
    Character
    Lucavern D'karnak
    World
    Excalibur
    Main Class
    Pugilist Lv 50
    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.
    (0)

  3. #13
    Player
    Jahaudant's Avatar
    Join Date
    Aug 2013
    Posts
    315
    Character
    Jahaudant Rivea
    World
    Sargatanas
    Main Class
    Conjurer Lv 60
    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.
    (0)

  4. #14
    Player
    Lucavern's Avatar
    Join Date
    Sep 2013
    Posts
    95
    Character
    Lucavern D'karnak
    World
    Excalibur
    Main Class
    Pugilist Lv 50
    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.
    (0)
    Last edited by Lucavern; 11-02-2013 at 01:40 AM.

  5. #15
    Player
    Soulburn32's Avatar
    Join Date
    Aug 2013
    Posts
    341
    Character
    Soul Burn
    World
    Adamantoise
    Main Class
    Gladiator Lv 50
    - 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]
    (0)
    Last edited by Soulburn32; 11-02-2013 at 01:59 AM.

  6. #16
    Player
    TheGlow's Avatar
    Join Date
    Sep 2013
    Posts
    25
    Character
    Kurai Entreri
    World
    Gilgamesh
    Main Class
    Gladiator Lv 50
    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.
    (0)

  7. #17
    Player
    Lucavern's Avatar
    Join Date
    Sep 2013
    Posts
    95
    Character
    Lucavern D'karnak
    World
    Excalibur
    Main Class
    Pugilist Lv 50
    Jahaudant, sent ya an email with updates to the Food tables. Take a look and let me know if it looks right.
    (0)

  8. #18
    Player
    Jahaudant's Avatar
    Join Date
    Aug 2013
    Posts
    315
    Character
    Jahaudant Rivea
    World
    Sargatanas
    Main Class
    Conjurer Lv 60
    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.
    (0)
    Last edited by Jahaudant; 11-02-2013 at 04:21 AM.

  9. #19
    Player
    Lucavern's Avatar
    Join Date
    Sep 2013
    Posts
    95
    Character
    Lucavern D'karnak
    World
    Excalibur
    Main Class
    Pugilist Lv 50
    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.
    (0)
    Last edited by Lucavern; 11-02-2013 at 04:07 AM.

  10. #20
    Player
    Jahaudant's Avatar
    Join Date
    Aug 2013
    Posts
    315
    Character
    Jahaudant Rivea
    World
    Sargatanas
    Main Class
    Conjurer Lv 60
    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.
    (0)
    Last edited by Jahaudant; 11-02-2013 at 04:25 AM.

Page 2 of 6 FirstFirst 1 2 3 4 ... LastLast