Remove Advertisements

(3.2.2.1) Tankadin Spreadsheet

Warning: Theorycraft inside.

Moderators: Fridmarr, Worldie, Aergis, theckhd

Re: (3.2.0.2) Tankadin Spreadsheet

Postby fuzzygeek » Tue Aug 18, 2009 4:40 am

Corman wrote:I'm using Excel and using http://www.artofsolving.com/online-document-converter to convert. No issues.


Interesting. I tried this, and there are no macros in the resulting spreadsheet at all.
Image
User avatar
fuzzygeek
Maintankadonor
 
Posts: 5130
Joined: Wed Aug 01, 2007 1:58 pm

Re: (3.2.0.2) Tankadin Spreadsheet

Postby duriek » Wed Aug 19, 2009 8:51 am

fuzzygeek wrote:
Corman wrote:I'm using Excel and using http://www.artofsolving.com/online-document-converter to convert. No issues.


Interesting. I tried this, and there are no macros in the resulting spreadsheet at all.

Me too, I tried converting it and the macros don't work when I open it in Excel.
Image
User avatar
duriek
Maintankadonor
 
Posts: 77
Joined: Fri Sep 26, 2008 9:48 pm
Location: New Jersey

Re: (3.2.0.2) Tankadin Spreadsheet

Postby gmf1 » Wed Aug 19, 2009 10:49 pm

I couldn't even get it to convert so just go open calc. Any help with my previous post?
Image
User avatar
gmf1
Maintankadonor
 
Posts: 381
Joined: Tue Jun 03, 2008 12:55 am
Location: Toowoomba, Queensland, Australia

Re: (3.2.0.2) Tankadin Spreadsheet

Postby bentglasstube » Thu Aug 20, 2009 4:49 pm

Rhî,

First of all, many thanks or creating this for us.

I went through the Stats_Calc sheet and found what I think are a few inaccuracies, so here's a big list with corrections.

Code: Select all
Items from Heroic ToC 5 Man are now ilvl 219 and have slightly higher stats

Rings with sockets not working in bottom slot:
  Items_Raw!AD13  =IF(AC13="Active",VLOOKUP(Items!C102,Finger!3:141,254,0),0)
  Items_Raw!AE13  =IF(AC13="Active",VLOOKUP(Items!C102,Finger!3:141,255,0),0)

Human base stats incorrect
  Human!F82       153
  Human!N82       8284
  Human!R82       5584

HP from stamina rounding errors
  Stats_Calc!D5   =ROUNDDOWN(C17*I17*J17*K17,0)*10-180
  Stats_Calc!F5   =ROUNDDOWN(D17*I17*J17*K17,0)*10
  Stats_Calc!K5   =ROUNDDOWN(H17*I17*J17*K17,0)*10

Kings multiplier being added to intellect for mana calculation
  Stats_Calc!G8   =ROUNDDOWN(SUM(E20:H20)*I20,0)*15
   
Spirit regen too high
  Stats_Calc!C86  =ROUNDDOWN((0.001+B23*VLOOKUP(Stats!C8,'Combat Ratings'!A91:B170,2,0)*(B20^0.5))*5*0.6,0)

Dodge from agility percentages change (also BoK affecting agi additively)
  Stats_Calc!C99  3.50%
  Stats_Calc!D99  =C14%/IF(Stats!C8<80,24.9999779921467,59.89)
  Stats_Calc!E99  =(ROUNDDOWN((D14+E14+F14+G14)*H14,0)%/IF(Stats!C8<80,24.9999779921467,59.89))
 
Dodge calculations slightly off
  Stats_Calc!A99  =C99+D99+G99+H99+IF(E99+F99+I99=0,0,1/(1.1347+0.956/(E99+F99+I99)))
  Stats_Calc!B99  =C99+D99+G99+H99+IF(E99+F99+I99=0,0,1/(1.1347+0.956/(E99+F99+I99)))


Armor also seems to be incorrect, but I can't quite get that one to work nor do I understand what you are doing in that cell with adding 3500 to the components so I just left it alone.

If you have any questions about these changes or think that I have done something incorrectly let me know and I'm sure one of us will wind up enlightened.
User avatar
bentglasstube
 
Posts: 40
Joined: Mon Jul 13, 2009 11:46 am
Location: Phoenix, AZ

Re: (3.2.0.2) Tankadin Spreadsheet

Postby Rhî » Sat Aug 22, 2009 3:37 pm

Thank you for that awesome feedback. Armor thingy was the coolest error. I was playing around with some numbers awhile ago. I guess, I've forgot to undo these 3500. :)
Image
Rhî
 
Posts: 305
Joined: Fri Sep 21, 2007 4:41 am

Re: (3.2.0.2) Tankadin Spreadsheet

Postby gmf1 » Sun Sep 06, 2009 5:11 am

Hello :) Still no update with new items?

Love the sheet been using it for ages but can't add all the new gear.

Thankyou.
Image
User avatar
gmf1
Maintankadonor
 
Posts: 381
Joined: Tue Jun 03, 2008 12:55 am
Location: Toowoomba, Queensland, Australia

Re: (3.2.0.2) Tankadin Spreadsheet

Postby Rhî » Mon Sep 07, 2009 6:19 am

Wednesday or Thursday.
Image
Rhî
 
Posts: 305
Joined: Fri Sep 21, 2007 4:41 am

Re: (3.2.0.2) Tankadin Spreadsheet

Postby bentglasstube » Tue Sep 08, 2009 12:07 pm

I did some more number crunching with various races of paladins on the armory and came up with 3.494% as the base dodge for all races rather than the 3.5% I mentioned above.
User avatar
bentglasstube
 
Posts: 40
Joined: Mon Jul 13, 2009 11:46 am
Location: Phoenix, AZ

Re: (3.2.0.2) Tankadin Spreadsheet

Postby Salline » Thu Sep 10, 2009 1:43 am

Macros aren't working for me either, using OpenOfficePortable 3.1.0

Rhi, is there any possibility this gets fixed in the upcoming release?
(btw, did you try to open the spreadsheet on another machine with a fresh OO-install? Maybe the portable version of OO?)

And one request: Please add the "Reticulated Armor Webbing" (Engineerung Glove Enchant, +885 Armor) to the sheet. :)

Other than that, outstanding work!
Salline
 
Posts: 1
Joined: Thu Sep 10, 2009 1:34 am

Re: (3.2.0.2) Tankadin Spreadsheet

Postby Rhî » Thu Sep 10, 2009 9:11 am

New version is delayed. No eta.
Image
Rhî
 
Posts: 305
Joined: Fri Sep 21, 2007 4:41 am

Re: (3.2.2.1) Tankadin Spreadsheet

Postby Rhî » Thu Sep 10, 2009 1:26 pm

New version uploaded. Based on PTR-Build!
Image
Rhî
 
Posts: 305
Joined: Fri Sep 21, 2007 4:41 am

Re: (3.2.2.1) Tankadin Spreadsheet

Postby gmf1 » Fri Sep 11, 2009 11:44 pm

Your the best :) Ty!
Image
User avatar
gmf1
Maintankadonor
 
Posts: 381
Joined: Tue Jun 03, 2008 12:55 am
Location: Toowoomba, Queensland, Australia

Re: (3.2.2.1) Tankadin Spreadsheet

Postby Rhî » Sat Sep 12, 2009 2:08 pm

Thanks to Marblehead: Excel users are getting a compatible version. See 1st post.
Image
Rhî
 
Posts: 305
Joined: Fri Sep 21, 2007 4:41 am

Re: (3.2.2.1) Tankadin Spreadsheet

Postby Reejin » Mon Sep 21, 2009 10:37 am

How does this spreadsheet compare to using the RAWR program?

http://www.codeplex.com/Rawr

There is one problem with the RAWR program as it does not do the Libram particularly well as of yet.
Reejin
 
Posts: 13
Joined: Thu Aug 27, 2009 12:07 pm

Re: (3.2.2.1) Tankadin Spreadsheet

Postby towelliee » Fri Nov 20, 2009 9:48 pm

so is this better then rawr or no?
towelliee
 
Posts: 1160
Joined: Tue May 27, 2008 8:09 am

PreviousNext

Return to Advanced Theorycraft and Calculations

Who is online

Users browsing this forum: Google [Bot] and 1 guest


Remove Advertisements

Who is online

In total there are 2 users online :: 1 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: Google [Bot] and 1 guest
?php } else { ?