PvE Stat Calculator

PvE Stat Calculator

in Community Creations

Posted by: Taerik.3405

Taerik.3405

I spent about 17 hours putting this little gem together, it doesnt have the new gear on it yet, and I have a friend who is inserting this into a webbased app so you dont even need excel for it.

http://filebin.ca/N4Gl0RUy1Tp

edit:
Thanks to Algon Kokoon for updating the spreadsheet to be compatible with excel 2007, and its cleaner, through clever use of SUMPRODUCT there are no more nested if statements.

http://www.rediscovergaming.com/cyberstorm/PvEGear.zip

(edited by Taerik.3405)

PvE Stat Calculator

in Community Creations

Posted by: Silver Chopper.4506

Silver Chopper.4506

The excel file doesn’t work Drop-down menus don’t exist.

PvE Stat Calculator

in Community Creations

Posted by: Avorniel.5708

Avorniel.5708

I spent about 17 hours putting this little gem together, it doesnt have the new gear on it yet, and I have a friend who is inserting this into a webbased app so you dont even need excel for it.

http://filebin.ca/N4Gl0RUy1Tp

the file location made my virus checker have major hissy fit and wouldn’t let me open it,
Would like to view it but I trust my virus checker more…

PvE Stat Calculator

in Community Creations

Posted by: Taerik.3405

Taerik.3405

Special thanks goes out to Algon Kokoon for updating this to be compatible with excel 2007,

http://www.rediscovergaming.com/cyberstorm/PvEGear.zip

updated the OP to also contain the link

PvE Stat Calculator

in Community Creations

Posted by: Enkidu.5472

Enkidu.5472

Just used it, very cool. I don’t do much endgame gearhunting since I just ding 80 and start a new char, but the program is easy to use and provides a wealth of information, so I’m keeping it.

The excel file doesn’t work Drop-down menus don’t exist.

Do so. Left click on whichever input cell you want, and a dropdown menu arrow appears to the right of that cell.

PvE Stat Calculator

in Community Creations

Posted by: Taerik.3405

Taerik.3405

The guy that was putting this onto a wepapp disappeared, if anyone has the skills to make a web based application for spreadsheets please by all means build off what is here

PvE Stat Calculator

in Community Creations

Posted by: Linc.6834

Linc.6834

bump for Thumbs-Up! Excellent update sir. With the intent of constructive critisism you left out the new Giver’s stats from wintersday (mmm delicious 10% condition duration weapons) Also there’s the all the ascended gear as well. Not to mention consumables which I’m quite sure you are aware of. I’ve been taking classes at www.udacity.com and if I ever finish the webapp class putting this together will be a prioity of mine.