+ Reply to Thread
Page 1 of 5 1 2 3 4 5 LastLast
Results 1 to 15 of 64
Like Tree7Likes

Thread: [3.0] Inquisitor Spreadsheet

  1. #1
    RIFT Guide Writer Pokesi's Avatar
    Join Date
    Dec 2010
    Posts
    193

    Default [3.0] Inquisitor Spreadsheet

    Hey, I have been working on Spreadsheet for inquisitor for awhile and its finally at the point where I can even think of showing it to the public.

    To get full rights and proper use of the sheet do the following steps.
    1. Click the link above
    2. Press the sign in button at top right corner
    3. Log in to your Google drive account.
    4. Go to files at top left - > Make a copy.
    5. Go to your Google drive
    6. Open the spreadsheet




    Stat weights do not update automatically, it has to be done manually (I have no idea how to automatize this.)
    How to do it.


    I did not implement any type of gear list or anything simply because I feel it is not needed. With the stat weights you calculated you can simply go fight dragons with t-swizzle as long as you replace the weights with your own.
    There is also now a item comparison tool in its own tab for you to compare items if you want to do this.
    Last edited by Pokesi; 01-12-2015 at 09:19 AM.

  2. #2
    Shadowlander
    Join Date
    Oct 2014
    Posts
    35

    Default

    your work is appreciated, i like!
    Zehnvierzig - Cleric - Veritas et Aequitas - T1 Clear HK 5/11

  3. #3
    Telaran Colga's Avatar
    Join Date
    Mar 2011
    Posts
    64

    Default

    Thank you for your efforts. I know these things are time consuming.

  4. #4
    Ascendant forbiddenlake's Avatar
    Join Date
    Jun 2013
    Posts
    5,682

    Default

    So how exactly does one calculate / update one's stat weights?
    Last edited by forbiddenlake; 12-04-2014 at 10:08 AM.

  5. #5
    RIFT Guide Writer Pokesi's Avatar
    Join Date
    Dec 2010
    Posts
    193

    Default

    Instructions are in calc tab when you scroll right a bit.

  6. #6
    Soulwalker
    Join Date
    Sep 2014
    Posts
    20

    Default

    What does ^ and FOWE stand for in the rotation tab?

  7. #7
    RIFT Guide Writer Pokesi's Avatar
    Join Date
    Dec 2010
    Posts
    193

    Default

    F = Flaring
    O = Orchestra/Lavafield
    W = Wildgrowth
    E = Enrage
    ^ = time spent channeling
    its just for purposes of counting the total damage done by spells.

    for clearer view of the rotation you can look at CowGoesMoo's post
    Last edited by Pokesi; 12-04-2014 at 12:20 PM.

  8. #8
    Soulwalker
    Join Date
    Sep 2014
    Posts
    20

    Default

    Quote Originally Posted by Pokesi View Post
    F = Flaring
    O = Orchestra/Lavafield
    W = Wildgrowth
    E = Enrage
    ^ = time spent channeling
    its just for purposes of counting the total damage done by spells.

    for clearer view of the rotation you can look at CowGoesMoo's post
    Thank you.

  9. #9
    Soulwalker
    Join Date
    Nov 2011
    Posts
    20

    Default

    Thanks you for that, there is something wrong about the statweights althought:
    I calculated the statweights the way you described and came to the following statweights:

    Wis 1.03512
    Int 0.42077
    SP 1.00000
    SC 0.30102
    CP 0.95779

    1 Point Wisdom gives 0.75 SP & 0.5Crit statweights must behave the same way:

    So 1 Point Wis Statweight should be equal to 0.75 SP Statweight + 0.5 Crit Statweight:
    1.03512 = 0.75 * 1 + 0.5 * 0.30103
    1.03512 = 0.900515

    Same goes for Int:
    1 Point Int gives 0.25 SP & 0.5Crit

    0.42077 = 0.25 * 1 + 0.5 * 030103
    0.42077 = 0.400515

    Tripple checked that now, somthing is not right here.

  10. #10
    Plane Touched
    Join Date
    Oct 2013
    Posts
    280

    Default

    There's +sp and +wis modifiers.
    Cowculator@Greybriar <Crayons>
    rip
    RIP Pyromancer's Aegis
    Quote Originally Posted by krug View Post
    Sharax will definitely be bug free .

  11. #11
    RIFT Guide Writer usman's Avatar
    Join Date
    Dec 2010
    Posts
    1,319

    Default

    Need to try to wrap my head around this, so is this 1 SP weight that everything else has been compared to before or after modifiers?
    Ambi - Cleric - Apotheosys.


  12. #12
    Plane Touched
    Join Date
    Oct 2013
    Posts
    280

    Default

    Before modifiers, so just gear stats (and runes and orbs).
    Cowculator@Greybriar <Crayons>
    rip
    RIP Pyromancer's Aegis
    Quote Originally Posted by krug View Post
    Sharax will definitely be bug free .

  13. #13
    RIFT Guide Writer usman's Avatar
    Join Date
    Dec 2010
    Posts
    1,319

    Default

    but the wiz is post modifiers?
    Ambi - Cleric - Apotheosys.


  14. #14
    RIFT Guide Writer Pokesi's Avatar
    Join Date
    Dec 2010
    Posts
    193

    Default

    Quote Originally Posted by Console View Post
    Thanks you for that, there is something wrong about the statweights althought:
    I calculated the statweights the way you described and came to the following statweights:

    Wis 1.03512
    Int 0.42077
    SP 1.00000
    SC 0.30102
    CP 0.95779

    1 Point Wisdom gives 0.75 SP & 0.5Crit statweights must behave the same way:

    So 1 Point Wis Statweight should be equal to 0.75 SP Statweight + 0.5 Crit Statweight:
    1.03512 = 0.75 * 1 + 0.5 * 0.30103
    1.03512 = 0.900515

    Same goes for Int:
    1 Point Int gives 0.25 SP & 0.5Crit

    0.42077 = 0.25 * 1 + 0.5 * 030103
    0.42077 = 0.400515

    Tripple checked that now, somthing is not right here.
    if you multiply the wisdom weight by 1.15 (Resonance + 10%wisdom from spec)
    and intelligence by 1.05 you will notice you get approximately the same values

  15. #15
    RIFT Guide Writer Pokesi's Avatar
    Join Date
    Dec 2010
    Posts
    193

    Default

    Finally got off work so here's an bit more in-depth answer.

    All the stats are compared before the modifiers so its pure stats from gear/runes/orbs that you have to look at.



    Quote Originally Posted by Console View Post
    snip
    Problem with math done in this post was that it assumed that gaining 1wisdom in gear actually gives you 1 wisdom while in in fact gives you 1.15 wisdom but this is hidden and you do not have you think about it all you see in gear while you compare is 1 wisdom difference same applies for int with its own modifier and spellpower as well.
    Last edited by Pokesi; 12-10-2014 at 02:38 AM.

+ Reply to Thread
Page 1 of 5 1 2 3 4 5 LastLast

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts