Diablo 3 Stat + Build Calculator for DPS and Toughness
I created a utility to pull your Diablo 3 data into a spreadsheet and run comparisons on different builds. This is a quick document to show you how to get started.
Setting up an editable spreadsheet
The utility is read-only by default. To begin using it you must first save a copy to your Google Drive:
- Make sure you're logged into your Google account
- Follow this URL: http://yellow5.us/d3/builds/
- You'll be redirected to the Google spreadsheet. The reason for the redirect is so I can make changes without having to update URLs everywhere.
- Click File -> Make a Copy... Make sure you don't export it to Excel. It needs to remain as a Google spreadsheet.
Importing your Diablo 3 Heroes
Once you've made a copy there should be two new menu items at the top of the spreadsheet: Builds and Battle.net. The first time you use these menus, Google Sheets will ask for your permission to use extended features. If you don't accept, the snapshot and API import features will not work.
You import a character's equipment and stats by using the Battle.net menu. Import... will prompt you for your Battle Tag. After that you can use the menu to choose any Seasonal (S) or Non-seasonal (NS) hero in your list. They must be level 70 to show in the menu.
When you select a hero it will process for a while (roughly 10 seconds, give or take). This is expected -- it will pull in stats for each piece of your gear, and Google isn't really speedy when it comes to gathering the data and pushing said data into a spreadsheet. Once it's finished you'll see all your hero's stats loaded, including set bonuses if any exist (factoring in if you're wearing a RoRG). It WILL NOT import your usage of Paragon points since this is not presented in the API. Once Blizzard fixes this I'll work on shoe-horning that feature. Unfortunately you'll need to manually add Paragon stats to the associated section of the Build page for now.
Builds will allow you to save a snapshot of your stats as they're configured. This is useful if you want to compare multiple builds (or even heroes). Using this menu is pretty self-explanatory. You can overwrite the currently saved build, save a new build, and load / remove an existing build.
Compare stats on your saved builds by clicking the Charts tab at the bottom. There are a couple pre-made charts on that page. Feel free to add more.
The only tabs meant to be easily edited are Builds and Charts (if you're inclined to add / edit one of the example charts).
Stats can be amended if you want to calculate DPS for specific skill combinations, but make sure the rStats named range contains your new fields. You can add your custom Stat field as a column in the ChartData page for use in new charts. Firebird DoT is there as an example. The others tabs contain formula data. Feel free to pick those apart. Edit them at your own risk =)
Again, here's the URL: http://yellow5.us/d3/builds/. I'll make updates as time / needs allow. I appreciate any honest feedback!
Why is my ancient offhand's damage too low?
The API has not been updated to show the correct damage for ancient offhands. Unfortunately you'll need to enter the average damage manually.
The Builds and Battle.net menus aren't showing. Why not?
Make sure you saved a copy. Also make sure your copy is a Google Spreadsheet and NOT a Microsoft Excel file.