Gearing and Calculators Spreadsheet

Looking for Addons? We've got those.
Fan art? Some amazing artists here.
RvR Videos? 6v6 fights? Show off your skills!
Looking to stream the game? We encourage it!

Moderators: Management, Web Developer

Forum rules
Before posting on this forum, be sure to read the Terms of Use
User avatar
Ramasee
Posts: 369

Gearing and Calculators Spreadsheet

Post#1 » 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.
Spreadsheet that has many formulas reduced to easy to use inputs. -- https://docs.google.com/spreadsheets/d/ ... sp=sharing

Ads
User avatar
Redsun
Posts: 66

Re: Gearing and Calculators Spreadsheet

Post#2 » Tue Jul 10, 2018 8:12 am

Interesting...will check it out! Thanks for sharing :)
Polemos - Fuzzh - Baigon - Middian - Bigon - Lengo

User avatar
lefze
Posts: 805

Re: Gearing and Calculators Spreadsheet

Post#3 » Tue Jul 10, 2018 8:39 am

Thanks again for taking the time to make this, amazing work.
Rip Phalanx

nocturnalguest
Posts: 93

Re: Gearing and Calculators Spreadsheet

Post#4 » Tue Jul 10, 2018 8:55 am

Thank you very much for sharing this huge chunk of hard work with community.

Fenris78
Posts: 10

Re: Gearing and Calculators Spreadsheet

Post#5 » Tue Jul 10, 2018 9:21 am

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 ?

User avatar
Ramasee
Posts: 369

Re: Gearing and Calculators Spreadsheet

Post#6 » Tue Jul 10, 2018 3:19 pm

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.
Spreadsheet that has many formulas reduced to easy to use inputs. -- https://docs.google.com/spreadsheets/d/ ... sp=sharing

User avatar
Fallenkezef
Posts: 1373

Re: Gearing and Calculators Spreadsheet

Post#7 » Tue Jul 10, 2018 6:11 pm

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.
Alea iacta est

Dabbart
Posts: 1909

Re: Gearing and Calculators Spreadsheet

Post#8 » Wed Jul 11, 2018 1:20 am

Looks cool! Thanks for the work! Unfortunately, I shouldn’t bother to use it... :mrgreen:

Jk....

Ads

Who is online

Users browsing this forum: No registered users and 2 guests