drumpel
11-19-2019, 02:22 PM
**UPDATE 12/5/19**
Corrected the On-Node pulse equation to output correct data
Corrected equation in the chart that shows up under cell E16 "Essence Pool based on Kill / Pulse while Off-Node hunting" to correctly calculate essence earned
attached updated .zip file to end of original post
----------------------------------------------------------------------------------------------------
This is built to help you figure out how many kills it takes to fill up your essence pool (though after all this work, the update they pushed out makes it kind of moot because SENSE verb was updated).
Wizards can check the current state of their static pool using the SENSE verb; the breakpoints in terms of percent full are: 95, 90, 75, 50, 25, 10, and 0. No message will appear if the pool is empty.
--
Naos
This is calculated around the idea that every mana point spent gives you a 1:1 return on the bonus essence you get per kill, up to +12 bonus.
In the spreadsheet there are spots to input your info:
B1 - enter your EL:W ranks
B2 - enter your EL:F ranks
B3 - enter your EMC ranks
B4 - enter your current level
B5 - enter your total mana (no enchancives)
B11 - enter the creature level
B12 - enter the average mana you usually spend per kill
B13 - enter the average kills you make per pulse
B7 - this shows you your max Essence Pool size
B8 - this shows you how much Essence you gain per pulse off-node
B9 - this shows you how much Essence you gain per pulse on node
The chart that starts on A16 will populate data based on the information you input above it.
Column 1 shows how many kills you need
Column 2 shows how much essence you would earn, based on kills, if you didn't pulse
Column 3 shows how much essence you're building up based on the Average # of kills you enter in cell B13
Basically you just see what your Max Essence Pool size is and reference that number on the chart to see how many kills you need to do to hit your max pool amount while out hunting because you're most likely not going to have access to an immediate node.
Hopefully you can use this to get an idea of how many kills it will take you to fill your essence pool to 100%.
My level 76 wizard, I'd enter in this info for him:
B1 = 67 (EL:W ranks)
B2 = 0 (EL:F ranks)
B3 = 83 (EMC ranks)
B4 = 76 (current level)
B5 = 293 (his max mana, no enhancives)
B11 = 76 (hunts like level)
B12 = 24 (avg mana per kill)
B13 = 5 (avg kills per pulse)
I see his Max Essence Pool (B7) = 793
I see his Off-Node pulse = 31
I see his On-Node pulse = 47
I look down Column 3 in the chart and looks like 35 kills means 797 essence in my pool, based on him averaging 5 kills per pulse - so I should be maxed at this point and I should run off to a Node to rest so I empty essence pool faster.
File attached here: 9485
Corrected the On-Node pulse equation to output correct data
Corrected equation in the chart that shows up under cell E16 "Essence Pool based on Kill / Pulse while Off-Node hunting" to correctly calculate essence earned
attached updated .zip file to end of original post
----------------------------------------------------------------------------------------------------
This is built to help you figure out how many kills it takes to fill up your essence pool (though after all this work, the update they pushed out makes it kind of moot because SENSE verb was updated).
Wizards can check the current state of their static pool using the SENSE verb; the breakpoints in terms of percent full are: 95, 90, 75, 50, 25, 10, and 0. No message will appear if the pool is empty.
--
Naos
This is calculated around the idea that every mana point spent gives you a 1:1 return on the bonus essence you get per kill, up to +12 bonus.
In the spreadsheet there are spots to input your info:
B1 - enter your EL:W ranks
B2 - enter your EL:F ranks
B3 - enter your EMC ranks
B4 - enter your current level
B5 - enter your total mana (no enchancives)
B11 - enter the creature level
B12 - enter the average mana you usually spend per kill
B13 - enter the average kills you make per pulse
B7 - this shows you your max Essence Pool size
B8 - this shows you how much Essence you gain per pulse off-node
B9 - this shows you how much Essence you gain per pulse on node
The chart that starts on A16 will populate data based on the information you input above it.
Column 1 shows how many kills you need
Column 2 shows how much essence you would earn, based on kills, if you didn't pulse
Column 3 shows how much essence you're building up based on the Average # of kills you enter in cell B13
Basically you just see what your Max Essence Pool size is and reference that number on the chart to see how many kills you need to do to hit your max pool amount while out hunting because you're most likely not going to have access to an immediate node.
Hopefully you can use this to get an idea of how many kills it will take you to fill your essence pool to 100%.
My level 76 wizard, I'd enter in this info for him:
B1 = 67 (EL:W ranks)
B2 = 0 (EL:F ranks)
B3 = 83 (EMC ranks)
B4 = 76 (current level)
B5 = 293 (his max mana, no enhancives)
B11 = 76 (hunts like level)
B12 = 24 (avg mana per kill)
B13 = 5 (avg kills per pulse)
I see his Max Essence Pool (B7) = 793
I see his Off-Node pulse = 31
I see his On-Node pulse = 47
I look down Column 3 in the chart and looks like 35 kills means 797 essence in my pool, based on him averaging 5 kills per pulse - so I should be maxed at this point and I should run off to a Node to rest so I empty essence pool faster.
File attached here: 9485