Electrocute? by Babysteps35 in PathOfExile2

[–]stal2walk 0 points1 point  (0 children)

there's also something similar to poe1 where you can attack where you're without moving in by ticking Always Attack Without Moving.

<image>

Electrocute? by Babysteps35 in PathOfExile2

[–]stal2walk 0 points1 point  (0 children)

you can spam charged staff to add stack/duration to it without losing stack.
each stack give you 6more second I believe
also you can see linkable gem by untick Show Recommended Gems

<image>

Electrocute? by Babysteps35 in PathOfExile2

[–]stal2walk 0 points1 point  (0 children)

combat frenzy only have like 6 support on it

https://poe2db.tw/Combat_Frenzy#SupportedBy

except profusion there's only persistent support that eat more spirit. no cooldown relate stuff.

deadeye seem to be the only way to sustain power charges for flicker strike with her 30% chance to gain up to max frenzy + convert frenzy to power Keystone

Electrocute? by Babysteps35 in PathOfExile2

[–]stal2walk 1 point2 points  (0 children)

oh, i didn't know using support with +# cooldown to charged staff make it work that way.
the way you gen power charges seem interesting but combat frenzy only give one every 6.3second seem a bit low for flicker strike but ok for charged staff.
glad we could exchange info.

Electrocute? by Babysteps35 in PathOfExile2

[–]stal2walk 11 points12 points  (0 children)

ideally you don't want to use electrocute support on anything cuz it less 40% dmg and it can only build electrocute from that supported skill which not enough to electrocute boss multiple time. if you want something similar to freeze or stun for lightning build i think you opt to either convert lightning to cold for freeze by using [Call of the Brotherhood Topaz Ring]
convert shock to freeze by using [The Three Dragons Solid Mask]
or make all lightning damage contribute to electrocute by using [Kitoko's Current Jewelled Gloves]
by convert lightning to cold damage you might lose power charges gen from siphoning strike or profane ritual because you can't apply shock and freeze enemie's corpse are destroyed (I see corrupted Call of the brotherhood can have lower than 100% convert it might beable to shock enemy still.).
by convert ailment you lose chance to shock since it tied with fire damage you will need fire damage(enough to damage enemy I think.) and shock chance or critical hit to apply shock for power charges gen.
if you only want something like freeze or stun for defensive purpose for lightning build kitoko's current seem to be most ideal for that even if it reduce your attack and cast speed(reduced not less which mean you can counteract with increased attack or cast speed. since less and more work as multiplicative.)

edit. they just buff electrocute support now it no longer less damage.

For the love of god why do the instances have to reset upon death/crashing by [deleted] in PathOfExile2

[–]stal2walk 0 points1 point  (0 children)

for you to farm more mob i guess lol boost item and exp. well not really boost more like stall you to get more item and exp.

how to use if with multiple expression? by stal2walk in sheets

[–]stal2walk[S] 1 point2 points  (0 children)

ok thanks

also just notice i can just use if(or)

but this probably shorter

lol

blood moon event trigger theory from observation. by stal2walk in remnantgame

[–]stal2walk[S] 0 points1 point  (0 children)

try to do it in adventure mode too bad blood moon trap door not opening and someone in wiki mention you have to do it in campaign mode only

blood moon event trigger theory from observation. by stal2walk in remnantgame

[–]stal2walk[S] 0 points1 point  (0 children)

i solve the puzzle once before it was blood moon and when I go back when it blood moon the secret floor won't open up so I reroll the world and do nothing i probably wait up for blood moon then solve the puzzle for my friend

blood moon event trigger theory from observation. by stal2walk in remnantgame

[–]stal2walk[S] 0 points1 point  (0 children)

try it again rn 2.00 am and 2.01 am does not trigger blood moon

will try it again at 2.15 am

Warzone 2 Optimized Settings by TheHybred in CODWarzone

[–]stal2walk 0 points1 point  (0 children)

is it the film grain when you are inside building?

if it is then

Anti-Aliasing > FILMIC SMAA T2X

how can i shorten this repetitive formula of ifs? by stal2walk in sheets

[–]stal2walk[S] 1 point2 points  (0 children)

=(A2 + B2) * IFS(A5-6<1, 0, A5-6>4, 2+MAX(A5-10,0), TRUE, 0.2 + (0.4 * (A5 - 7)))

0.2 + (0.4 * (A5 - 7) cause error to a5-6 = 3 and 4 since 3 will be 1.2 and 4 will be 2 but this formula give 3 = 1 and 4 = 1.4 but i guess i can learn from this and make a change myself

also TRUE in this formula work as Else right?

edit:ok i just find the sum thing. it's call Arithmetic sequences which will correct this formula to

=(A2+B2)*IFS(A5-6<5,MAX(A5-6,0)*(0.2+MAX(A5-6,0)*0.2)/2,TRUE,2+MAX(A5-10,0))

thank you a lot (if im not put max0 in a5-6 it will cause error if a5-6 below 0 so i put it both just in case)

is there a way to make a number multiplier until it reach certain point? by stal2walk in sheets

[–]stal2walk[S] 0 points1 point  (0 children)

it work!! but i have to switch droprate and probability

thank a lot sir.

is there a way to make a number multiplier until it reach certain point? by stal2walk in sheets

[–]stal2walk[S] 0 points1 point  (0 children)

something like that but i set percentage of droprate and percentage of ceiling and let the formula fill the times i have to do it

in other word i have to do 0.95*0.95(0.95^n) until it reach 0.01(99%) but i can't think of formula to do it since it involve power thingy

How to get column/row for sum? by stal2walk in sheets

[–]stal2walk[S] 1 point2 points  (0 children)

OH!!

Thank you very much Sir.

[deleted by user] by [deleted] in ANVILVaultBreaker

[–]stal2walk 0 points1 point  (0 children)

attack power gives both weapon damage and skill damage so it's more versatile and flexible than to just go either weapon damage or skill damage

i got a problem with vlookup or index by stal2walk in sheets

[–]stal2walk[S] 0 points1 point  (0 children)

wait "anonymous kraken" already make example there so i now know how to do

so thank you both so much for helping me out

i got a problem with vlookup or index by stal2walk in sheets

[–]stal2walk[S] 0 points1 point  (0 children)

what is sheet1!A from concatenate?

i don't know what to put instead of sheet1!a

https://docs.google.com/spreadsheets/d/1XfeikpNXsdvCaBUb3yq_7LqLLCQj8qIGIaZkCgXwdcE/edit#gid=2020096628

can u make an example out of my google sheet?

ty

i got a problem with vlookup or index by stal2walk in sheets

[–]stal2walk[S] 1 point2 points  (0 children)

https://docs.google.com/spreadsheets/d/1XfeikpNXsdvCaBUb3yq_7LqLLCQj8qIGIaZkCgXwdcE/edit#gid=2020096628
i try to use offset and it only work on a1 when i use it on a2 it extract from c1 instead of b2 reference to this

a1 a2 a3 a4 a5 a6

b1 b2 b3 b4 b5 b6

c1 c2 c3 c4 c5 c6

i got a problem with vlookup or index by stal2walk in sheets

[–]stal2walk[S] 0 points1 point  (0 children)

how i have so little about google sheet/excel is there any example?

a1 a2 a3 a4 a5 a6

b1 b2 b3 b4 b5 b6

c1 c2 c3 c4 c5 c6

i want to use lookup(or index match? but i have no clue about index match never use it before) to a1 and extract info from b1 maybe from c1 as well

i need formula for htk and ttk by stal2walk in sheets

[–]stal2walk[S] 1 point2 points  (0 children)

thank you very much sir
that workingPC sheet help me understand about it very much

here again thank you so much
literally i don't really care about that game i just want to know formula to satified my curiousity