Page 1 of 1

Gearing and Calculators Spreadsheet

Posted: Mon Jul 09, 2018 7:19 pm
by Ramasee
snip

Re: Gearing and Calculators Spreadsheet

Posted: Tue Jul 10, 2018 8:12 am
by Redsun
Interesting...will check it out! Thanks for sharing :)

Re: Gearing and Calculators Spreadsheet

Posted: Tue Jul 10, 2018 8:39 am
by lefze
Thanks again for taking the time to make this, amazing work.

Re: Gearing and Calculators Spreadsheet

Posted: Tue Jul 10, 2018 8:55 am
by nocturnalguest
Thank you very much for sharing this huge chunk of hard work with community.

Re: Gearing and Calculators Spreadsheet

Posted: Tue Jul 10, 2018 9:21 am
by Fenris78
Looks good but I cant find the cell to enter the actual level ; stats only show equipement bonuses, and dont seem to count the base stats of a rank 40 character...

Any hints ?

Re: Gearing and Calculators Spreadsheet

Posted: Tue Jul 10, 2018 3:19 pm
by Ramasee
Some of the classes haven't had the base stats put in the data. To the right of the first purple column you will see a column that starts with "Needs:" anything in that column hasnt been data input.

The entire document uses career rank 40.

Re: Gearing and Calculators Spreadsheet

Posted: Tue Jul 10, 2018 6:11 pm
by Fallenkezef
Ramasee wrote:
Mon Jul 09, 2018 7:19 pm
I have been working on a project in my non-warhammer spare time (such as between total war turns, hearthstone turns, spare time in office at work, and waiting for 'old' men to take potty breaks during warbands). Originally started it for my own characters, then grew into a tool for the guild, and then I started working on the rest of it to eventually share with the community.

It is currently not entirely finished but I have been lax of late on inputting the remaining chunks of data. I'm not sure if I will continue with the data input since many of the people that made the game fun for me have left. That said, I don't want the work to be wasted, specially since it was supposed to be released.

https://docs.google.com/spreadsheets/d/ ... sp=sharing

The above is a spreadsheet that contains:
1. New initiative calculator with results that can take into account buffs and debuffs.
2. Armor Penetration / Effective Armor Mitigation calculator.
3. Auto Attack per hit and dps calculator.
4. Effective Absorb mitigation calculator.
5. Effective Health and Heal modifier calculator. (sans toughness)
6. A gear build sheet for each class (on order). This includes talismans, renown points, base stats, and most of the t4 gear.

Anything that you find wrong with any of it, just post here. If its a quick fix, I will fix it. If not, I will write it in the notes put throughout the document until I get the will to continue the project.
Nice, thanks the spreadsheet is very helpful.

Re: Gearing and Calculators Spreadsheet

Posted: Wed Jul 11, 2018 1:20 am
by Dabbart
Looks cool! Thanks for the work! Unfortunately, I shouldn’t bother to use it... :mrgreen:

Jk....