Get the Desktop App for Battle.net Now
- All your games in 1 place
- Log in once
- Automatic game updates
In an effort to get my spreadsheet (the aforementioned "M") out to everybody in half-decent shape before the end of the weekend, I'm making a list of what I need to do.
I'll be updating this thread as I knock items off the list. Once they're all done, I'll consider it ready for reasonable consumption.
Edited by Vrkhyz#1472 on 1/28/2013 7:38 PM PST
I added a column for set bonuses to the Armor worksheet. For those of you who already have a copy, this is where you'll record all your set bonuses, rather than append them to the items themselves. It's column O in this picture:
I added Life per Kill to the Armor worksheet and the individual worksheets, after which I tested it. Seems to be working as intended. I'm mulling over a couple macro buttons to copy current gear to the test columns on the DPS worksheet. Shouldn't take long, and has less room for error.
I know how but I'm Uber Lazy :(
Do you think it would be a worthwhile addition?
It would be fantastic, actually. Something for you to play with on your copy, perhaps.
I added the "Copy" buttons for 1.0.6 and PTR data. I also added a bunch of blank comments and some blanket instructions for the Weapons worksheet, the Armor worksheet, and the individual armor sheets. So I just need to get it posted. That'll have to wait until after the hockey game and the dinner party, though.
It would be fantastic, actually. Something for you to play with on your copy, perhaps.;
Oh boy, it's going to take every ounce of motivation to get myself to do it. Yes, I am that lazy; and yes, it's a very bad habit :((
I have one requirement for it to work. You CAN NOT change the layout of the columns and rows. Based on what I saw
a) they will never change anyway
b) i may be able to simply use the named ranges and it won't be an issue, since you did a fabulous job of naming everything!
OK, i started the process...Nobody get too excited I have a long way to go!
It took more time to capture the video than it did to write the code!
I didn't realize FRAPS does not don't capture the desktop with Windows 8. DUH, of course it can't! I started to download a screen recorder then I just said, EFF IT, i'll do it with my phone.
So far I got it importing your characters into the spreadsheet
lmao, what a horrible quality video...idc, I was trying to record and mouse click and i only have two hands! OH well, it was quick and dirty and I have to go :D
UPDATE: I have fully completed loading the list of your characters from your profile into the spreadsheet.
I have also completed the code to properly select your character.
This includes formatting for your hardcore characters, level and paragon.
Here is a screenshot: http://imgur.com/KYM20lV
I didn't really have anytime to work on this today so that is as far as I got. I just got back from my son's TKD and right now my daughter wants to read me a story...
I'll get back on in a bit
Oooh! Cool. I can't tell whether the info is being pulled into the right worksheets, though. I think the real DPS number got blown out on the DPS worksheet and the Snapshot worksheet, as I didn't see them in the video. But we can talk here or in-game. Overall, though, this looks like a fantastic feature! Thanks a bunch!
I have not programmed it to pull the data into the worksheets.
The way it works as of the previous update is.
1.) Type in your battle tag
2.) Click on the button "Get Characters"
3.) Select hero from drop down list
That's all it did up to the previous update. It will show you your list of heroes. The hero display will have: class, name, level, paragon. As can be seen by screenshot: http://imgur.com/KYM20lV
UPDATE: I know succesfully programmed and called the get hero details api. Once you select a hero it will show you summary details of the hero you selected. This summary info is directly from blizzard.
This can be seen by screenshot: http://imgur.com/Rgr4HRp
NEXT: Program "Load Character" button. This part is the heavy lifting. This button will actually load all item data into your worksheets.
Threats of violence. We take these seriously and will alert the proper authorities.
Posts containing personal information about other players. This includes physical addresses, e-mail addresses, phone numbers, and inappropriate photos and/or videos.
Harassing or discriminatory language. This will not be tolerated.