PDA

View Full Version : Weapon Comparison Spreadsheet



Jyhdif
04-14-2016, 01:16 PM
I was commenting on janave's post (https://www.ddo.com/forums/showthread.php/367715-Savage-Species!-New-race-coming-to-DDO?highlight=) about a new end game maul when I decided to do some weapon comparisons. I quickly found the old ESOS vs. TF Falchion thread from September 2015 (https://www.ddo.com/forums/showthread.php/465174-Is-ESOS-still-best?) and started adapting the math to spreadsheet use. I know that Alkusoittow (https://www.ddo.com/forums/member.php/425339-Alkusoittow?)'s D (https://www.ddo.com/forums/showthread.php/466370-DPS-Oracle-A-complete-DPS-calculator-for-every-build-and-blade?)PS (https://www.ddo.com/forums/showthread.php/466370-DPS-Oracle-A-complete-DPS-calculator-for-every-build-and-blade?) Oracle (https://www.ddo.com/forums/showthread.php/466370-DPS-Oracle-A-complete-DPS-calculator-for-every-build-and-blade?) does these calculations far better, but it does not have the graphing function that I wanted to be able to compare different weapons, given standard inputs, across build base damage mods (or any other variable).

I exported one of the graphs I created comparing the ESOS, TF Falchion, ERiftmaker and janave's maul, which I nicknamed "Life in Balance", at melee power 120 and seeker 30, assuming 0 fort and ideal conditions (e.g. attacking outsiders for the riftmaker).

If you would like the data, I have moved it to google sheets (https://docs.google.com/spreadsheets/d/1omUVnUXFhO2sgZ9i29LXCwOfUn7mhkPdq1J5sNFXOh0/edit?usp=sharing). I would suggest moving it back to Excel or Open Office, as the graphing function of google sheets does not allow the same manipulation that Excel and others do. The graph here is from a pivot chart in Excel, as I could not figure out how to get google sheets to properly label the data lines (as you will see in the google sheet). I did not fully verify that everything copied correctly, but the graph lines look similar, so I assumed all the formula remained intact in the transfer to google.

Here is an example of the output you can get from the Excel version:

http://i.imgur.com/CyxuBkB.png?1


I will let you look at the spreadsheet to see what went into this.

Edit:

Well, since this was mentioned in the recent chronicle, I figured I would give a few pointers on its use for those who hate spreadsheets. When you download the spreadsheet (and ideally open in libreOffice, Open Office or Excel), you will see the first ~400 lines of the first worksheet are taken up by the four weapons in the graph, each taking 100 lines representing base build damages ranging from ~52-152 (yes i realize 152 is unrealistic, so you can change this to 30-130 or any other range you like).

To add weapons to the sheet, simply replace one of the ones already there and replicated it across the 100 lines for that weapon, or add it to the end. The second worksheet, where all the calculations are done, only goes up to 1000, so it has space for 10 weapons. If you want to add more, simply highlight the last row in the second sheet and drag it down another 100 lines, or however many increments of 100 you desire (100 per weapon). However, more than 10 lines would probably clog the graph and be less useful anyhow, so you can probably leave the second sheet alone unless you find a problem with the math.

Once you have changed a weapon or two or added whatever you want, go to the worksheet with the graph, right click (or ctrl-click for mac) and click "refresh data" (In Excel that is, not sure where this function is in Open Office, LibreOffice or google sheets, but it should be similar, if not automatic).

I am no master of spreadsheets, so if anyone has ideas on how to make this process more user friendly outside of moving it to a database program with a frontend user input frame, please share.

Thunder-Monkey
04-14-2016, 09:58 PM
Your dedication to crunching the numbers is admirable, but to do it on a non-existent hypothetical weapon??? Above and beyond mate!

Big fan of your work.

TM

Jyhdif
04-15-2016, 11:23 AM
Your dedication to crunching the numbers is admirable, but to do it on a non-existent hypothetical weapon??? Above and beyond mate!

Big fan of your work.

TM

He he, thanks. Curiosity sometimes gets the best of me, so I venture down various rabbit holes, sometimes finding something interesting. I figured I would provide the results of this particular rabbit quest to the community in case anyone could use it or modify it to their needs.

If I had the programming skills, I would make a quick web program for people to enter data and get a graph, much like this one (http://www.afterlifeguild.org/Thott/ddo/) from years ago. Maybe I will make learning this a pet project :)

Lanadazia
04-22-2016, 01:14 PM
what exactly do you mean by build base damage mod?
and what is the correct name for the TF falchion?

Jyhdif
04-23-2016, 01:09 PM
what exactly do you mean by build base damage mod?
and what is the correct name for the TF falchion?

Build base damage mod would be anything contributing to the base damage of a build not including seeker and melee power and the weapon itself (as those are their own variables in the formula). This would primarily be comprised of stat bonuses to damage (e.g. str, dex or whatever you are using to damage things with your weapons), deadly, power attack, and anything else that adds to the number listed to the right of your weapon die in the inventory panel detail pane (i.e. after the 2d4 18-20x2, the +XX number).

If you would prefer just using the base damage of an actual character, you can set that to be standard across the 100 entries for a weapon and then increment one of the other variables to your liking (e.g. melee power). I have done this myself, because I am more of a casual player than many here and I don't think I have ever seen a 100 base damage mod on any of my characters :)

As for the correct name of the TF falchion, I am not sure what you mean. The full name is Thunderforged, and they are crafted using ingots, shadow dragonscales and fire dragon scales, with tier 3 requiring fire or shadow Phlogistons. If you are asking the specific upgrades on the particular TF Falchion used in this sheet, it would be the same that Grailhawk used in the old ESOS vs. TF Falchion thread I noted in the original post, which was T1 First Degree Burns, T2 Dragon's Edge, T3 Crippling Flames. You could change this to mortal fear, as I believe that is still what many use despite the lack of proc in legendary content, and the only difference would be changing the 135-325 on crit fire damage to 8-64 on hit force damage and figuring out the damage per hit equivalent of the moral fear proc on non-bosses. Note, I did not include a damage calculation for crippling flames that included the level drain, so you could be more precise with that as well.