Tanking stat spreadsheet online

[Krados]

I'm a tankasin working on min/maxing before 1.2 and have been working on modding out based on the spreadsheet. So I have 2 questions:
1. Is everything on the spreadsheet still accurate and up to date?
2. If the Maximum values as posted earlier are

Quote:Def = 366.5094886
Shield = 262.6413789
Abs = 405.8491325
Squishiness = 0.3006961

Is there any combination of mods to actually reach these numbers?
The best I can do, with re-modding and full Rakata was

Def = 308
Shield = 343
Absorb = 411
Squishiness = .29849

Which actually gives me better "squishiness" and "spikey-ness" than the 'optimal' stats....

[hxxr]

(02-08-2012 07:07 AM)Neokarasu Wrote:  I've gotten around to making a Max EDR (Min Squishiness) graph for all of the various classes. The result is actually pretty interesting to me considering I don't keep up with other classes's thread. For example, I didn't expect Juggs to be the best Avoidance tank. Assassins have the most balance with respect to Defense/Shield/Absorb at higher level.

No surprise at all to be honest. Looking at the skills it's obvious ... however, it's nice to see someone worked up such pretty curves that you can show to others to prove your point. :>

Assassins scale best with absorb rating, getting more +shield chance than the other tanks.

Powertechs gain increased armor, absorbtion and shield rating in their talent tree and even build more threat when shielding attacks - clearly a mitigation tank, especially considering how the 2-roll system works.

Juggernauts get an absorbtion shield, no bonus absorbtion, very little shielding, no further armor increase and a lot more bonus defense chance and stronger cooldowns than other tanks ... it's not that Juggernauts scale much better with defense - they just scale worse with shield/absorb rating.

[Evel]

(03-16-2012 12:59 PM)Krados Wrote:  Is there any combination of mods to actually reach these numbers?
The best I can do, with re-modding and full Rakata was

Def = 308
Shield = 343
Absorb = 411
Squishiness = .29849

Which actually gives me better "squishiness" and "spikey-ness" than the 'optimal' stats....

My best setup in full Rakata is as follows:

Def = 374
Shield = 326
Absorb = 387
Squishiness = 0.29884

This is much closer in line with the charts floating around here and still keeps my HP above 21K.

[Krados]

(03-16-2012 11:10 PM)Evel Wrote:  My best setup in full Rakata is as follows:

Def = 374
Shield = 326
Absorb = 387
Squishiness = 0.29884

This is much closer in line with the charts floating around here and still keeps my HP above 21K.

I hate to ask, but when you get a chance, could you update your askmrrobot.com setup to reflect this, so I can see what's what with mods.

[Qai'roc]

Im new to this site, but have been 50 for a while. I already know my question will be noob, but I need so help so I don't really lol. I have absolutely no idea on how to use this spreadsheet. I currently have Microsoft Excel Viewer (Not sure if this is better or worst than Excel 2007) I can't select anything everything is grayed out and I cant access any of it. Was also wondering if there is a guide for using this sheet anywhere? Unless someone feels generous and is willing to help me out themselves. (Would be greatly appreciated if so) But not totally needed. I can follow basic concepts just need someone to point the way.

[LagunaD]

Reading the instructions in the original post might be a good start.

[Kyosuke_88]

https://docs.google.com/spreadsheet/ccc?...zlTR01OQXc

was the result of mine...

and am wearing:
columi: chest / head / implant
Rakata: bracers / belt / legs / pants / offhand / implant
war leader: ear
Relics: matrix cube and relic of the shrouded crusader.
Custom: main hand


I feel that i do not lack threat or aggro but i do feel i take a lot of dmg on a lot of bosses, mostly those that use the force (as i dont get to use retaliation to increase defenses)

but yea...
should i take the columi enchantments and put into the rakata gear
and in case how many of them etc?

[Qai'roc]

(03-18-2012 12:25 PM)LagunaD Wrote:  Reading the instructions in the original post might be a good start.

LOL i knew someone was going to do it. I have indeed read the regular post. 3+ times now. I think my viewer maybe wrong so i will try that since u can never get a decent answer from forum folk.

[LagunaD]

(03-19-2012 02:20 AM)Qairoc Wrote:  

(03-18-2012 12:25 PM)LagunaD Wrote:  Reading the instructions in the original post might be a good start.

LOL i knew someone was going to do it. I have indeed read the regular post. 3+ times now. I think my viewer maybe wrong so i will try that since u can never get a decent answer from forum folk.

Well, as far as "a guide for using this spreadsheet", which you asked for, the original post fits that description.

Excel Viewer does not allow you modify workbooks. The original post explains how to make an online copy and edit it in your web browser.

[Evel]

(03-17-2012 09:00 AM)Krados Wrote:  I hate to ask, but when you get a chance, could you update your askmrrobot.com setup to reflect this, so I can see what's what with mods.

It is on the Wish List of my character, which is where I got those numbers from. Not sure if you are able to see that?