(3.2.2.1) Tankadin Spreadsheet

Warning: Theorycraft inside.

Moderators: Fridmarr, Worldie, Aergis, theckhd

Postby Rhî » Mon Feb 23, 2009 3:17 am

Modal wrote:Any chance we could find a way of hosting this that involved fewer pop-ups and what look suspiciously like browser hijack attempts?


Tell me a good free hoster of your choice. But it shouldn't be necessary, the used hoster is legit and trustworthy. Probably it's my add blocker, but I don't have any popups.
Image
Rhî
 
Posts: 305
Joined: Fri Sep 21, 2007 4:41 am

Postby Rhî » Wed Feb 25, 2009 4:49 am

3.0.9.3 is available. Last Build for the moment. Next is 3.1.0.1.
Last edited by Rhî on Wed Feb 25, 2009 1:28 pm, edited 1 time in total.
Image
Rhî
 
Posts: 305
Joined: Fri Sep 21, 2007 4:41 am

Postby Kegg » Wed Feb 25, 2009 1:04 pm

couple of things I saw missing,

1h weapon - Hammer of Quiet Morning
Eng Trinket - Sonic Booster

Nice job on the spreadsheet and Thank you.
Kegg
 
Posts: 5
Joined: Tue Feb 24, 2009 2:45 pm

Postby Varmin » Tue Mar 03, 2009 5:08 am

After always questioning the dodge percentage of your sheet I decided to look into it and I think I finally found what was wrong.

On Sheet Stats_Calc, on B99 your current formula is uses 24.9999779921467 to calculate the dodge from agility.

I believe it should be changed to 52.0833 that you use in other cells of that row for agility.
Varmin
 
Posts: 172
Joined: Sun Jan 18, 2009 8:57 pm

Postby Mallot » Tue Mar 03, 2009 12:14 pm

Fantastic spreadsheet! I am trying to figure out, though, where you input your stats for the gear in your drop down validaion box. I have a couple of items that are not currently accounted for in the spreadsheet. I see that the vlookup is referencing different tabs, but I don't see those tabs displayed. Also, it would be extremely helpful if the dropdown menus were organized alphabetically.
Image
Mallot
 
Posts: 8
Joined: Wed Feb 25, 2009 7:06 am

Postby Rhî » Tue Mar 03, 2009 8:17 pm

Kegg wrote:couple of things I saw missing,

1h weapon - Hammer of Quiet Morning
Eng Trinket - Sonic Booster

Nice job on the spreadsheet and Thank you.


I'll add them.

Varmin wrote:After always questioning the dodge percentage of your sheet I decided to look into it and I think I finally found what was wrong.

On Sheet Stats_Calc, on B99 your current formula is uses 24.9999779921467 to calculate the dodge from agility.

I believe it should be changed to 52.0833 that you use in other cells of that row for agility.


Thank you very much for this feedback. That was really a big mistake in the calculation. 24.99 was the level 70 value. I'll add a level based formula.

Mallot wrote:Fantastic spreadsheet! I am trying to figure out, though, where you input your stats for the gear in your drop down validaion box. I have a couple of items that are not currently accounted for in the spreadsheet. I see that the vlookup is referencing different tabs, but I don't see those tabs displayed. Also, it would be extremely helpful if the dropdown menus were organized alphabetically.


I've hidden many sheet pages. The main reason is to not confuse semi experienced people. And unfortunately I've not the time to include some features like 'everyone can add new items easily'. At the moment the items are sorted by ilvl. Highest ones first. More comfort here is a future task.
Image
Rhî
 
Posts: 305
Joined: Fri Sep 21, 2007 4:41 am

Re: (3.0.9.3) Tankadin Spreadsheet

Postby Rhî » Mon Mar 30, 2009 4:34 am

I've uploaded a ptr based version of the spreadsheet. Feedback is highly appreciated.
Image
Rhî
 
Posts: 305
Joined: Fri Sep 21, 2007 4:41 am

Re: (3.0.9.3) Tankadin Spreadsheet

Postby sfrog » Tue Mar 31, 2009 6:17 am

Can't get to the download page due to a Pop-up frame thing that lands squarely over the page and won't let you get rid of it.
Image
Without Honor...there is no Hope.
User avatar
sfrog
 
Posts: 219
Joined: Tue Apr 01, 2008 1:16 am
Location: Anchorage, Alaska

Re: (3.0.9.3) Tankadin Spreadsheet

Postby Rhî » Tue Mar 31, 2009 11:40 pm

sfrog wrote:Can't get to the download page due to a Pop-up frame thing that lands squarely over the page and won't let you get rid of it.


Don't know what your problem is. Other people downloaded it a couple of times. If you could give me a for you working download host, I'll upload it there.
Image
Rhî
 
Posts: 305
Joined: Fri Sep 21, 2007 4:41 am

Re: (3.0.9.3) Tankadin Spreadsheet

Postby abinning » Fri Apr 03, 2009 7:20 am

I would be happy to help out with the hosting. I have set up an account with 100mb for you. Let me know if that is enough space. I'll PM you the info.
*edit* I forgot the link for the rest of the world.

http://tank.abits.biz
abinning
 
Posts: 103
Joined: Fri Oct 17, 2008 9:00 am

Re: (3.0.9.3) Tankadin Spreadsheet

Postby Rhî » Fri Apr 03, 2009 7:59 am

Thank you very much for that offering. I'm happy and accept it. :D
Image
Rhî
 
Posts: 305
Joined: Fri Sep 21, 2007 4:41 am

Re: (3.0.9.3) Tankadin Spreadsheet

Postby abinning » Fri Apr 03, 2009 11:24 am

I forgot to mention, I already uploaded the current versions.
abinning
 
Posts: 103
Joined: Fri Oct 17, 2008 9:00 am

Re: (3.0.9.3) Tankadin Spreadsheet

Postby Rhî » Fri Apr 03, 2009 1:04 pm

I've uploaded a new ptr based version with a brandnew feature.
Image
Rhî
 
Posts: 305
Joined: Fri Sep 21, 2007 4:41 am

Re: (3.0.9.3) Tankadin Spreadsheet

Postby Andurin » Tue Apr 07, 2009 3:38 am

Ouch.... a bit over my head, but looks like someone did a massive amount of theorycrafting... Should I get some more testing in it i`ll let you know what I find about it :P
Andurin
 
Posts: 851
Joined: Mon Jul 07, 2008 4:45 am

Re: (3.0.9.3) Tankadin Spreadsheet

Postby daiceman » Wed Apr 08, 2009 8:57 am

Hmm, for some reason I seem to have a higher parry rating then expected from the character sheet on armory.

Putting my gear into the sheet gives me 250 parry rating as expected on my character, but for some reason, it only gives me 18.89 parry instead of 19.46 parry
daiceman
 
Posts: 43
Joined: Tue Apr 22, 2008 1:53 pm

PreviousNext

Return to Advanced Theorycraft and Calculations

Who is online

Users browsing this forum: No registered users and 1 guest

Who is online

In total there is 1 user online :: 0 registered, 0 hidden and 1 guest (based on users active over the past 5 minutes)
Most users ever online was 380 on Tue Oct 14, 2008 6:28 pm

Users browsing this forum: No registered users and 1 guest