Tool (version 2.1! Now Has Spell Calculations!!!) Exact Damage, Dps, And Crits. (23 Supporters)

So, I noticed how when I look at my weapon in the Character Stats menu, it does not take into account Skills, Crits, etc. So, I thought "I should make something that can calculate the exact amount!" After around 4 hours of work, I made this:

Yes, it looks complicated. In reality, you just need to input a few numbers. In the STATS area, just type in the percentage increase in that ability. If you do not want to look in-game (like using the Stats Tab on the main website) do not worry. The first sheet labeled "Skill Points" will break down all the percentages. Here is a picture of that:

Just look for the number, and the percentage is right next to it. As mentioned, numbers in yellow are not 100% accurate. If anyone knows those numbers, feel free to let me know. The other tabs are self-explanatory, and if anyone has any comments, suggestions, or problems, feel free to let me know. I also want to drive home the point that I do not work for Wynncraft, and this is mostly just information gathered from in-game sources, the wiki, etc. Also note that this is not a 100% accurate tool. Some assuming is done, as mentioned in some of the notes. (The Critical Hits sheet does A LOT of assuming.)

As of Version 2.0, I have added 4 new pages! One for each class, and their spell calculations! Here is a preview of the Archer page:




Once you input all your Weapon and Stats info, the Spells pages will automatically show a bunch of info on spells, regarding Damage, Mana Cost, etc

Now, there are 2 versions you can pick from. Microsoft Excel, or Google Sheets.

Link: (Excel)
http://www.mediafire.com/file/4cikdd2twp05kdl/Wynncraft+Weapon+Damage+Equation.xlsx

Link: (Google Sheets)
https://docs.google.com/spreadsheets/d/1txx1SwB2K_z-ZC_6TJv7nuriXmuV7t1k_KSV6J9mBhk/edit?usp=sharing

Spoiler: Changelog

Version 2.1:
- Fixed some numbers on the Skill Points page (Thanks CelsonicEXE!)

Version 2.0:
- Added Spells pages
- Removed Defense page

Version 1.1
- Added Google Sheets compatibility.

Version 1.0.1
- Added Changelog to the "Credits" Sheet
- Added a "Poison" Calculator on the "Damage and Character" Sheet. (Accidentally removed! Will add back in the next update!)
- Decreased the Zoom on the "Damage and Character" Sheet. (This can be modified in the View Tab on the Ribbon, or the top row with all the Excel editing tools.)

Version 1.0
- Release

Overall, this took around 8 hours of work. I even had to re-do a lot of my formulas multiple times, and I was very happy when I managed to complete it. I am still looking for ways to improve the spreadsheet, so make sure to keep an eye out for any new updates in the future :D

I greatly appreciate any and all feedback, comments, and suggestions regarding anything in this sheet or on this forum, as long as it is in a constructive manner.


I hope all of you have a good day, and I will see you all on the server :D

 

Great idea and execution, but fix light theme after "yellow".

 

You're my fucking saviour


I love you

 

Nice job doing this, i truly believe it was hard, and you were able to pull it out! :)

 

Really helpful! This will be quite useful for class-building. Cheers.

 

Light theme after yellow? Not sure what you mean by that.

________________________________

Thanks for all the praise so far! I was reluctant to release this fearing criticism, but I got the exact opposite. Just added a poll so you can rate this sheet, and feel free to keep sending feedback. :D

________________________________

Just doing what I enjoy :D

 

wat bout poison?

+1

 

Well, Poison is pretty self-explanatory. You just take the damage, and divide it by the time, and add that to both DPS's.

Ex:
Your weapon does (after all the calculations) 200-340 DPS.
It also has Poison: 200/3s.
Add the 200 to both sides of your damage.
Make sure to multiply your original DPS by 3, since the Poison takes 3 seconds
AKA 800 - 1220 Damage per 3 Seconds, or:
266.6 - 406.6 DPS (do this by dividing both by 3)

I will play around and see if I can add a Poison box, but no promises. Thanks for the suggestion, and I hope this helped!

________________________________

It was. Fun fact: After around 1 hour of work, I forgot that Weapons have both a Minimum and Maximum damage, so I had to redo almost all of my formulas to fix this. So in reality, it was closer to 5 hours of work. Nevertheless, I was happy with the final result, and I am glad you liked it! :D

 

Just updated the Spreadsheet, look at the "Changelog" Spoiler to see what's new!

 

I meant after the word yellow, all the text is white. This makes it impossible for Light Theme users to read. To fix this, use the "None" color, which has a default friendly to all themes.

 

Ahh, my bad. Just fixed. Sorry for the inconvenience.

 

Spoiler: I Don't Think So

 

Should be working now. The "None" selection was not working, so I just cleared the formatting and tested it on light theme myself. Once again, sorry for the inconvenience.

 

now make it so it calculates spell dmg

 

nice tool mate
awesome

 

BBBBBBUUUUUUUUUUUUUUMMMMMMMMMPPPPPPPP


I thought this already gained like 100000+ supporters what ??!1

________________________________

Also maybe add spells section? where you take in the spell damage % and the raw spell damage?

and maybe add the damage of spells? idk if it's too complicated or just simply unpossible but just giving ideas

 

Sorry for not reading these suggestions yet! I may get around to the Spells, but it will take a while, since I have A LOT of numbers to crunch and formulas to create for all the spells. Nevertheless, it is on my mind and if I can figure out a somewhat-simple way of calculating them it will be added :D

 

it goes up to 150 i think

 

I am currently working on the spells, as I have managed to figure out a formula that works (in theory). As mentioned in the main post, I do not have access to all the numbers of how this is all crunched, but I am doing my best. As of now, I have completed all of the Archer spells, and am working on the Warrior ones.

This may take all day since there is a lot of numbers to go through. For example, Arrow Storm Grade 1 has 10% Fire Damage on it, and what I do not know is if that 10% is removed from the 30% that each arrow does, or takes away 10% OF that 30%.

Simple version:
Each Arrow in Arrow Storm does 30% of the damage a normal arrow would do. Now, since 10% of that is fire, is 20% normal damage and 10% fire, or is 27% normal damage and 3% fire? (Since 10% of 30% is 3%)

If I knew how the damage worked, I would know which to use. But, since I don't, I am going with 20% Neutral and 10% Fire for the time being. If anyone has evidence that it is the other way around, please post it here and link the evidence if possible.

Sorry for a bit of my rambling, but just wanted to inform everyone and hopefully clear something up! (If anyone even understand that whole madhouse of numbers) :D

EDIT:

I found evidence that proved me wrong in the above statement:


How can you subtract 100% from 30%? My original theory must have been wrong. Therefore, I will have to re-do some of my calculations, and it may take longer than expected to complete the Spells part.

 

I wish, but people don't seem very excited about Excel spreadsheets ;-;