Follow via Facebook Follow via Twitter Follow via YouTube Follow via RSS Steam Group

Author Topic: Spreadsheets  (Read 3789 times)


  • Alumni
  • Posts: 246
  • Reputation: +0/-0
Re: Spreadsheets
« Reply #15 on: Jun 04, 2013, 09:36 PM »
It may be better for you to do burst and sustained?
Or at least sustained for PvE and burst for PvP?? For all classes?

I think you should do a Sentinel one as well, from the Combat's perspective.. i'm interested in seeing what you come up with..

I can put all of my stats, with min/max tooltip damage into a spreadsheet if you want.

Actually, I could make the Combat spec relatively quick compared to the effort I would have to put into other classes. I don't need your tooltip damage but I do need a few other things.

Este already filled out most of the information when he helped me with the Watchman sheet. Here is an example of his work --

Just fill out the missing Combat abilities and their coefficients and give me your skill tree names and descriptions. To find the coefficients of abilities, just search for the ability in and click the "effect details" of that ability, which will expand and give you all the required numbers. I need it all and then I can start my work.

Sorry mate but I don't follow on how you calculate the health min/max? and I don't know what a coefficient is..?


  • Alumni
  • Posts: 24
  • Reputation: +0/-0
Re: Spreadsheets
« Reply #16 on: Jun 08, 2013, 01:27 PM »
Luckily, you don't need to know the definition of a coefficient :)

All you have to do is exactly what I described for torhead. I'll include an example...

As you can see in the picture below, torhead gives you the "coefficient," "StandardHealthPercentMin," "StandardHealthPercentMax," and "AmountModifierPercent." Those are the values I need for all of your abilities if you would like a spreadsheet made for you. All you have to do is a little copy/pasting so it's pretty easy if you're willing to put a little time into it.

This is the example screenshot of Smash
« Last Edit: Jun 08, 2013, 01:31 PM by Inovisible »


  • Alumni
  • Posts: 246
  • Reputation: +0/-0
Re: Spreadsheets
« Reply #17 on: Jun 08, 2013, 07:20 PM »
some abilities (like Blade Rush, the main skill for Combat) do not have the mix/max health, though? Maybe torhead is incomplete


  • Alumni
  • Posts: 24
  • Reputation: +0/-0
Re: Spreadsheets
« Reply #18 on: Jun 09, 2013, 09:47 AM »
Even after I fill out all of the numbers from torhead, I will need to check a few of your parses to compare the data in my spreadsheet to actual in-game data, since I know not to trust everything torhead says. From there, I'll make a few more tweaks and that sheet will get my stamp of approval in the "About" tab of my spreadsheets.

Occasionally, torhead will be missing some abilities. When this happens, just copy/paste the entire line of numbers and throw it into the spreadsheet you are making for me like the example below.

Blade Rush

WeaponDamage: Slots=>[ SecondaryMelee ], FlurryBlowsMax=>1, AmountModifierPercent=>-0.11, FlurryBlowsMin=>1, IsSpecialAbility=>1

ModifyMetaStat: Amount=>0.3, Stat=>Modifier for proc rate, Coefficient=>1, StatModType=>1


* Live Streams

Data retrieved in 0.09 seconds.

* Recent Posts

Site Stuff by Ratio
[Aug 09, 2018, 07:56 PM]

Canderous Ordo Trash Talk by Cates
[Apr 26, 2017, 04:49 PM]

New Voice Communicator...? by Cates
[Apr 26, 2017, 04:49 PM]

Star Citizen by Cates
[Nov 19, 2016, 05:21 AM]

Free Games by Crabbok
[Jul 29, 2016, 11:47 PM]

XCOM 2: LD50 at War! by Yuri
[Jul 14, 2016, 05:17 PM]

Overwatch by Crabbok
[Apr 30, 2016, 04:17 PM]

Disney buys Star Wars by Dargos
[Apr 14, 2016, 04:57 AM]

Free Division Clothing "Gear" Sets by Cates
[Mar 06, 2016, 08:23 PM]

Internet on the Island by Fixate
[Mar 03, 2016, 07:14 AM]

* Gallery

XCOM: LD50@War

Views: 4164
By: Acorns