PDA

View Full Version : Weapon Grid Spreadsheet



blubbergott
04-04-2018, 04:50 PM
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. (https://docs.google.com/spreadsheets/u/1/d/1zuBcbcJbJ3x86iB20HaCUEZ9PAbDLWqO-ByrX0mnMyU/edit?usp=sharing)

Aidoru
04-04-2018, 05:50 PM
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.

blubbergott
04-04-2018, 05:56 PM
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.

Slashley
04-04-2018, 11:59 PM
For the record, I've also made one, attached to a damage calc (https://docs.google.com/spreadsheets/d/1PhfOAQk6EyK5l33ux_C4T-cexVIQp6D-_Hbd-OO1OmQ/edit#gid=39423565).

Cobblemaniac
04-05-2018, 04:46 AM
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. (https://docs.google.com/spreadsheets/u/1/d/1zuBcbcJbJ3x86iB20HaCUEZ9PAbDLWqO-ByrX0mnMyU/edit?usp=sharing)

Actually done one back in the past with my account template thread already :silly:

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.

blubbergott
04-05-2018, 06:27 AM
Actually done one back in the past with my account template thread already :silly:

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

Cobblemaniac
04-05-2018, 07:15 AM
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.

blubbergott
04-21-2018, 04:26 PM
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.

blubbergott
05-02-2018, 10:04 AM
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.