12:19 am, April 15, 2016
693
Weapon Comparison Spreadsheet
I was commenting on janave's post 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 and started adapting the math to spreadsheet use. I know that Alkusoittow's DPS Oracle 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. 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:
I will let you look at the spreadsheet to see what went into this.
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. 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:
I will let you look at the spreadsheet to see what went into this.