Maintenance for the week of November 25:
• [COMPLETE] PC/Mac: NA and EU megaservers for maintenance – November 25, 4:00AM EST (9:00 UTC) - 7:00AM EST (12:00 UTC)
• Xbox: NA and EU megaservers for maintenance – November 27, 6:00AM EST (11:00 UTC) - 9:00AM EST (14:00 UTC)
• PlayStation®: NA and EU megaservers for maintenance – November 27, 6:00AM EST (11:00 UTC) - 9:00AM EST (14:00 UTC)

[Excel] Build Calculator -Version 4.1

Soulac
Soulac
✭✭✭✭✭
✭✭
Welcome to my first "little" Excel sheet I made.

At first every calculated skill could be slighty different to the IG values, cause this game round up and down rly weird..
The difference with stats should be between 0-20 and between cost of skills 0-3, so not that much!

Values for Enchants are standard legendary, but u´re free too change it or improve it. (Make a dropdown if you want.)
Enchants on Jewelry are the V12 blue ones, so change it if you use something else!

If you find a way to shorten this long formulars I use, do it! Every help ist useful.

How it works:
Put in your class, your race and every base stat.
With base stat I mean without attributs, without any skillpoint used (in passives as example) and without any skills slotted.
Then chose your equip, your enchants, your traits and everything else you can find.
Important: atm there is no option for mundusstones or divine traits, so pls add things like a Tower Bonus (+100 Stamina) to the base stats!

Features
- full race support
- full class support
- calculate your final stats
- softcaps included!
- see the changes if you switch a single item with something else!
- cost of dodgeroll / breakfree based on used armor!
- amount of possible dodge´s and breakfree´s / minute without using anything else!
- Option for Magelight, Entropy, Emperor, Vamp etc.
- calculate the cost of every skill including Ultimates!
- use the standard Sets or change it to your own!
- calculates with enchants and traits like Infused
- calculate the average regeneration each minute
- see how often you´re able to activate a single skill compared to other skills
- option for potions and bufffood!
- Tooltipdmg calculation

Bugs
Well I need your help with that!

Patchnotes 4.1:
- Mundus stone support
- Divine Trait Support
- Breton Passive fix
- Vampire healthregeneration fix
- New Spellcost calculation

Download Version 4.1: click
Second download link: click

Please give me some feedback and make some suggestions.

Soulac
Edited by Soulac on 10 January 2015 22:24
R.I.P Dawnbreaker / Auriel´s Bow
Member of the Arena Guild and the overpowered Banana Squad.
Nathaerizh aka Cat - Nightblade V16 - EU

- Meow -
  • Grao
    Grao
    ✭✭✭✭✭
    hmm, I cant download it...
  • Soulac
    Soulac
    ✭✭✭✭✭
    ✭✭
    Grao wrote: »
    hmm, I cant download it...

    The link was a bit older, this one should work.
    https://www.dropbox.com/s/q9hnrt5pr5qqbm4/Build Calculator - 3.0 (1).xlsx?dl=0

    I will upload a new version with some improved calculations, fixes and tooltip dmg calculation soon.

    Edited by Soulac on 16 December 2014 15:27
    R.I.P Dawnbreaker / Auriel´s Bow
    Member of the Arena Guild and the overpowered Banana Squad.
    Nathaerizh aka Cat - Nightblade V16 - EU

    - Meow -
  • Soulac
    Soulac
    ✭✭✭✭✭
    ✭✭
    Update 4.0:
    - Improvement of skillcost calculation (should show the exact value as in game now)
    - new Tooltip DMG calculator

    How to use the tooltip dmg calculator:
    - the calculator gets magicka and spelldmg by used base stats, armor, equip, enchants etc. and use them to calculate the tooltip dmg.
    - Rankcoef = 0.1 - 0.7 (Morph Rank 1 = 0.4)
    - Skillcoef = additional calculation (use your actual ingame stats to find the exact value. Cause rounding differences it´s not 100% correct, but its maybe a difference of +-1)

    Download: Click
    Edited by Soulac on 16 December 2014 16:48
    R.I.P Dawnbreaker / Auriel´s Bow
    Member of the Arena Guild and the overpowered Banana Squad.
    Nathaerizh aka Cat - Nightblade V16 - EU

    - Meow -
  • TheHutz
    TheHutz
    Soul Shriven
    This should be useful when I put together my V14 set in a few days. I'll be sure to take a look.
  • Grao
    Grao
    ✭✭✭✭✭
    Cool ^^ thanks
  • Solariken
    Solariken
    ✭✭✭✭✭
    ✭✭✭✭
    I think you have the start of something really cool here. I'm looking forward to populating and playing with it when I get home. :smiley:
  • Soulac
    Soulac
    ✭✭✭✭✭
    ✭✭
    New Update!

    Patchnotes 4.1:
    - Mundus stone support
    - Divine Trait Support
    - Breton Passive fix
    - Vampire healthregeneration fix
    - New Spellcost calculation

    Download: click
    R.I.P Dawnbreaker / Auriel´s Bow
    Member of the Arena Guild and the overpowered Banana Squad.
    Nathaerizh aka Cat - Nightblade V16 - EU

    - Meow -
  • Morshire
    Morshire
    ✭✭✭✭
    Nice, thanks for updating. I have been following this thread for all my builds. Does that sound right? Following for sure, oh using the calculator for the builds? Well anyway, appreciate the effort.
    Follow me if I advance, Kill me if I retreat, Avenge me if I die.

    When this immediate evil power has been defeated, we shall not yet have won the long battle with the elemental barbarities. Another evil, it may be an invisible adversary, will attempt, again, and yet again, to destroy our frail civilization. Is it true, I wonder, that the only way to escape a war is to be in it?

    If I die, you are forgiven, If I live, I will kill you.
Sign In or Register to comment.