Results 1 to 9 of 9
  1. #1

    Weapon Grid Spreadsheet

    Since I was already making a weapon grid spreadsheet for my union, figured I might as well share it here. Basically: You enter your weapons with their skill lvl and what type of skills they have and the sheet will calculate you your total assault/defender values and color everything automatically so you immediately see what weapons still need some work. If you wanna use it, just create a copy or download it.

    Anyways, have fun.


  2. #2

    Join Date
    Oct 2016
    Posts
    1,851
    Credits
    1,531
    Items User Name Style ChangeUsername Change
    Made one myself the other day as well. You need to add in soul weapons because they have different values than SSR weapons (11% at sLv1, +1% per skill level for 30% at sLv20). I'm not sure if they do yet but I recall reading someone saying they work as element damage instead of assault but would need verification.

  3. #3
    Ye, apparently elemental damage, which is why I left them out for now. Easy enough to add though. Will have to add other things like dbl atk, ascension, etc too in the future.

  4. #4

    Join Date
    Jul 2017
    Posts
    3,601
    Credits
    3,784
    For the record, I've also made one, attached to a damage calc.

  5. #5

    Join Date
    Jan 2018
    Location
    Singapore
    Posts
    1,431
    Credits
    1,038
    Quote Originally Posted by blubbergott View Post
    Since I was already making a weapon grid spreadsheet for my union, figured I might as well share it here. Basically: You enter your weapons with their skill lvl and what type of skills they have and the sheet will calculate you your total assault/defender values and color everything automatically so you immediately see what weapons still need some work. If you wanna use it, just create a copy or download it.

    Anyways, have fun.
    Actually done one back in the past with my account template thread already

    That said, I do have a suggestion: weapon name and type seems a bit redundant in a weapon grid calculator, the primary concern would be the weapon skill buffs IMO. Removing those 2 sections saves quite a bit of time in entering info.

  6. #6
    Quote Originally Posted by Cobblemaniac View Post
    Actually done one back in the past with my account template thread already

    That said, I do have a suggestion: weapon name and type seems a bit redundant in a weapon grid calculator, the primary concern would be the weapon skill buffs IMO. Removing those 2 sections saves quite a bit of time in entering info.
    Gl finding out which weapon is which without any identifier. Type seemed somewhat relevant at least and takes like a second to enter. :P

  7. #7

    Join Date
    Jan 2018
    Location
    Singapore
    Posts
    1,431
    Credits
    1,038
    Quote Originally Posted by blubbergott View Post
    Gl finding out which weapon is which without any identifier. Type seemed somewhat relevant at least and takes like a second to enter. :P
    Indeed. I was stating you didn't need to know which weapon because...

    Stats can be your hime stats instead, or total atk.

    Skills can be typed in.

    Weapon type... yeah I concede. That does matter with the 10/20% stat buff (forgot which number it was) for your hime, or if you don't have the weapon type for a soul.

    Rarity... is rarity.

    Nothing much else for show IMO, which was why I was kinda against using weapon names.

    That said, I think you might need to include a formula for the relic weapon skills, they operate on different multipliers, and maybe your union buddies have one.

  8. #8
    Added sheets for accessories. I personally never remember what KH have what accessories, what needs leveling and so on, so figured that might come in handy.

  9. #9
    Played around a bit more and now it can calculate how many Rs and SRs you still need to max out each grid. Added 2 options for enhancing that you can toggle between (always use SR4 if possible and always use as many Rs as possible), but feel free to add your own options. Can probably give you a decent estimate how long it'll take you to finish a grid if you focus on it.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •