nvm think i figured it out, just had to alter the formula to include the new column of values.

i figured that i can calc 4b shove ranges w this stuff if i change the values in a way that:
-"Big Blind" --> my pf open size otb
-"Size of villain's raise preflop" --> his 3b size
-"% villain is raising from the button" --> his 3b%
-"% villain is calling a shove (estimate)" --> % villain calls my 4b shove
obv i calc my equity vs his stack off range facing a 4b shove.

do u guys think its correct or am i missing something?

That seems fine, you could also just do the equity calcs or use another calculator/make ur own for it too.

getting all sort of errors is this because I'm using windows works ?
( well aware this could sound like a stupid question )

I'm guessing yes.
the macros are broken with open office too.
you have to use it manually, i.e. use pokerstove and enter the values manually.

already did that but got wrong results
guess I'm gonna have to forget about it
isn't there any other program i can use for 3bet shoving calc.

Yea, to my knowledge this only works with Excel type programs. I might be able to get an old version that doesn't use Stove directly to be useable in Works's spreadsheet program, but I just had all my programs reset on this computer again so it'd be a while for it to work.

Been busy with personal statistics type things right now, though, so I can't work on this for a while sadly.

tx anyway for the answer at least now i know its waist of time trying to get this to work

Wow, cool thing Steve!
Didnt know that I get the calculator here in the forum (for free)
ty,ty,ty

For clarification I wanted to make sure that the total equity resulting from plugging all necessary fields into the endgame calculator, is in denominations of chips right?