(3.2.2.1) Tankadin Spreadsheet

[fuzzygeek]

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.

[duriek]

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.

[gmf1]

I couldn't even get it to convert so just go open calc. Any help with my previous post?

[bentglasstube]

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.

[Rhî]

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.

[gmf1]

Hello Still no update with new items?

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

Thankyou.

[Rhî]

Wednesday or Thursday.

[bentglasstube]

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.

[Salline]

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!

[Rhî]

New version is delayed. No eta.

[Rhî]

New version uploaded. Based on PTR-Build!

[gmf1]

Your the best Ty!

[Rhî]

Thanks to Marblehead: Excel users are getting a compatible version. See 1st post.

[Reejin]

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.

[towelliee]

so is this better then rawr or no?