Spreed Sheet for armor and weapon for relayering Items

[PaPa]

so I've made a spreed sheet to track my suit and current weapon stats and my current re-layering weapon and how it will fit into my suit once re-layered.

If you have question post here so if anyone else has question about same thing.

*updated*
I've Recently updated this spreed sheet shows a lot more info and will help a lot when re-layering a weapon

*Updated* 10-1-19
Added character base stats.

[PaPa]

new updated

[PaPa]

any suggestion or comments?

[tiggerjlk]

The only thing I can really think of, is maybe having an area to put in your character's stats as well. That will come in handy for someone who is trying to get to max stamina for example, so they don't forget to include the character's stats as well.

Way off topic: If my base resist of cold is 40, and I add an item that has cold resist of 20%, should that add 8 to my total, to add up to 48?
I was curious because when I put in all of my resists for PHY, it adds up to 166 on your spreadsheet. But if I add the percentage of each to my base the sum total I added as the percentage, comes up to 114.38. Either way it adds up to more than the allocated 70 total points.

I was also never sure if the percentage was compounded. for example, if my resist is 40 then I add a 40% resist, that makes it 56. Then if I add a second piece that has 5% more resist, does it add to the base of 43, or to the new total of 56? Or am I thinking about it all wrong?

Either way, the spreadsheet comes in handy!

[PaPa]

Ill add that and ill figure out how the formula works for it

[PaPa]

ok so for the resists you have your base set resists of 44 and with protection of 34 (for me anyways) the armor does not stack , so if your armor is lower then your natural protection the armor does not matter.

[tiggerjlk]

Ahh. ok. that makes sense.
thanks!