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.

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.