Yulis
09-21-2015, 06:37 PM
**UPDATE 8/8/17**
I'm making my departure from the game. I haven't added any updates since the last update on 6/27. If someone wishes to take over and watch changes and make updates to this elemental lore spreadsheet, please feel free. Best of luck to everyone on their adventures in and out of the game.
**UPDATE** 6/27/17
Added 925 to show mana earned per 30 pulse from EL:W
Adjusted 411 to function correctly by showing max enchant you can eblade based on your ATTUNED element
Adjusted 917 - I don't remember what I did to this (made the correction a few months back and never wrote down what was actually fixed)
Corrected some wording/spelling in a few spots (cosmetic)
**UPDATE** 12/12/16
Corrected issue with crit padding points not adding correctly for cell G88 for Mage Armor
Added:
950 - Core Tap - I went through and figured out the intervals for EL:A on this spell, it should bring up a very close to accurate chance to CHANNEL a spell with any EL:A ranks entered. I did not do the same with EL:W or EL:F, too time consuming to figure it all out and put it into the spreadsheet. Just the shown thresholds on the gswiki are shown here for EL:W and EL:F (may get around to fixing EL:W & EL:F for this spell, just not anytime soon)
550 - Time Stop
New/updated file is zipped and attached to the bottom of this post
**UPDATE** 12/8/16
I decided to not be lazy and made updates to the spreadsheet. I was holding out for changes to Enchanting, but they don't see to be coming RSN.
Added:
515 - Rapid fire's cooldown and EL:F & EL:W bonuses have been added
520 - Mage Armor (replaced old Stone Skin)
Updated:
413 - fixed incorrect data showing for the "Persistent TD Push Down from EL:F"
New/updated file is zipped and attached to bottom of this post.
**UPDATE** 6/16/16
512 - Cold Snap
I added in the updated changes the released/updated spell Cold Snap
**UPDATE** 2/16/16
Added:
902 - Elemental Edge
411 - Elemental Blade
535 - Haste
Updated:
520 - Stone Skin (adjusted for recent summation change)
506 - Celerity (Utility Actions Only)
**UPDATE** 12/16/15
I added spell 513 - Elemental Focus to the chart to show the new AS boost benefit to casting bolts against the same target.
**UPDATE** 11/18/15
Corrected 512 (Ice Patch) ability to turn 903 bolts into 1709 (Minor Cold) due to information update. Number of bolts changed to minor cold are based on SEED 10 Summation and not previously thought SEED 9.
**UPDATED** 11/16/15
I've added % Chance to apply burn for minor acid (904)
I added a 414/419 benefit to the Earth Lore Benefit worksheet - this was previously missing on the worksheet
I also corrected a couple of minor spelling mistakes.
I've compiled all (hopefully) spells that benefit from the Elemental Lores and created a spreadsheet that'll run all the calculations for you. I did fix a few issues from my last update (typos, incorrect lore calculations under a couple spells).
The sheet is pretty easy to follow. The first worksheet will calculate the benefits based on the ranks you enter for each element.
Spell 502, you need to choose what element you're attuned to if you wish to see the DS push down associated with your available lore ranks.
Spell 514, enter your current level (top of worksheet 1) **The results are based off Level, Lore ranks and personal experience using the spell. It should give you a good idea of your chances to SLAP/CLENCH/POUND targets**
Spell 520, enter your MjE Spell ranks (top of worksheet 1)
Spell 519, in the 3rd column of benefits for it, you can enter in your end-roll and it will show you the reduced chance (if roll is under 150) for an instant kill chance based on your fire lore.
Spell 912, call wind doesn't seem to follow the summation chart so the benefit on it is estimated and should provide a very close return result compared to how it works in game.
Spell 413, enter your Elemental Mana Control ranks (top of worksheet 1)
Clearly 506 (Haste) is subject to change and current changes to 519 (Immolation) have not been implemented yet, but you can still see what kind of return results you get from lores.
I have not added 925 since it's still under construction.
The second worksheet will automatically update the adjusted DF for any bolt spells, based off your lore ranks.
The last worksheet is simply a copy of the summation chart you can find on the gswiki - it's just there for reference.
I've added 4 other worksheets, they provide just the benefits of each individual lore. You still input your lore ranks/level/EM:C/MjE Spell ranks in worksheet 1, all the calculations will carry over to the individual lore worksheets.
You can download the zipped file here: 8674
The excel file works fine in 2010 or newer. I know some equations/functions do not work in 2003. I'm not sure about Excel 2007, but hopefully it shouldn't cause any issues. You can convert it to a Google Sheet and it should work without issues, but I have not done this.
If anyone sees any issues, please let me know. Also, if I missed any spells, list them off for me so I can get them added on.
On a last note; The worksheets are protected, but not by password. If by some chance you want to change things around or wish to see the equations used, feel free to unlock the worksheets.
Enjoy!
I'm making my departure from the game. I haven't added any updates since the last update on 6/27. If someone wishes to take over and watch changes and make updates to this elemental lore spreadsheet, please feel free. Best of luck to everyone on their adventures in and out of the game.
**UPDATE** 6/27/17
Added 925 to show mana earned per 30 pulse from EL:W
Adjusted 411 to function correctly by showing max enchant you can eblade based on your ATTUNED element
Adjusted 917 - I don't remember what I did to this (made the correction a few months back and never wrote down what was actually fixed)
Corrected some wording/spelling in a few spots (cosmetic)
**UPDATE** 12/12/16
Corrected issue with crit padding points not adding correctly for cell G88 for Mage Armor
Added:
950 - Core Tap - I went through and figured out the intervals for EL:A on this spell, it should bring up a very close to accurate chance to CHANNEL a spell with any EL:A ranks entered. I did not do the same with EL:W or EL:F, too time consuming to figure it all out and put it into the spreadsheet. Just the shown thresholds on the gswiki are shown here for EL:W and EL:F (may get around to fixing EL:W & EL:F for this spell, just not anytime soon)
550 - Time Stop
New/updated file is zipped and attached to the bottom of this post
**UPDATE** 12/8/16
I decided to not be lazy and made updates to the spreadsheet. I was holding out for changes to Enchanting, but they don't see to be coming RSN.
Added:
515 - Rapid fire's cooldown and EL:F & EL:W bonuses have been added
520 - Mage Armor (replaced old Stone Skin)
Updated:
413 - fixed incorrect data showing for the "Persistent TD Push Down from EL:F"
New/updated file is zipped and attached to bottom of this post.
**UPDATE** 6/16/16
512 - Cold Snap
I added in the updated changes the released/updated spell Cold Snap
**UPDATE** 2/16/16
Added:
902 - Elemental Edge
411 - Elemental Blade
535 - Haste
Updated:
520 - Stone Skin (adjusted for recent summation change)
506 - Celerity (Utility Actions Only)
**UPDATE** 12/16/15
I added spell 513 - Elemental Focus to the chart to show the new AS boost benefit to casting bolts against the same target.
**UPDATE** 11/18/15
Corrected 512 (Ice Patch) ability to turn 903 bolts into 1709 (Minor Cold) due to information update. Number of bolts changed to minor cold are based on SEED 10 Summation and not previously thought SEED 9.
**UPDATED** 11/16/15
I've added % Chance to apply burn for minor acid (904)
I added a 414/419 benefit to the Earth Lore Benefit worksheet - this was previously missing on the worksheet
I also corrected a couple of minor spelling mistakes.
I've compiled all (hopefully) spells that benefit from the Elemental Lores and created a spreadsheet that'll run all the calculations for you. I did fix a few issues from my last update (typos, incorrect lore calculations under a couple spells).
The sheet is pretty easy to follow. The first worksheet will calculate the benefits based on the ranks you enter for each element.
Spell 502, you need to choose what element you're attuned to if you wish to see the DS push down associated with your available lore ranks.
Spell 514, enter your current level (top of worksheet 1) **The results are based off Level, Lore ranks and personal experience using the spell. It should give you a good idea of your chances to SLAP/CLENCH/POUND targets**
Spell 520, enter your MjE Spell ranks (top of worksheet 1)
Spell 519, in the 3rd column of benefits for it, you can enter in your end-roll and it will show you the reduced chance (if roll is under 150) for an instant kill chance based on your fire lore.
Spell 912, call wind doesn't seem to follow the summation chart so the benefit on it is estimated and should provide a very close return result compared to how it works in game.
Spell 413, enter your Elemental Mana Control ranks (top of worksheet 1)
Clearly 506 (Haste) is subject to change and current changes to 519 (Immolation) have not been implemented yet, but you can still see what kind of return results you get from lores.
I have not added 925 since it's still under construction.
The second worksheet will automatically update the adjusted DF for any bolt spells, based off your lore ranks.
The last worksheet is simply a copy of the summation chart you can find on the gswiki - it's just there for reference.
I've added 4 other worksheets, they provide just the benefits of each individual lore. You still input your lore ranks/level/EM:C/MjE Spell ranks in worksheet 1, all the calculations will carry over to the individual lore worksheets.
You can download the zipped file here: 8674
The excel file works fine in 2010 or newer. I know some equations/functions do not work in 2003. I'm not sure about Excel 2007, but hopefully it shouldn't cause any issues. You can convert it to a Google Sheet and it should work without issues, but I have not done this.
If anyone sees any issues, please let me know. Also, if I missed any spells, list them off for me so I can get them added on.
On a last note; The worksheets are protected, but not by password. If by some chance you want to change things around or wish to see the equations used, feel free to unlock the worksheets.
Enjoy!