Hi guys, let me know if i'm wrong .

4b EV :

50nl (blinds 0.25 / 0.50). we open(MP) 3bb($1.5) CO 3bet 9bb($4.5) , we 4bet 20bb($10) (pot 15,25)

Let's say his 3bet range is 9,06% (111combos) and 30combos(only value shove), to know what is 30 combos in % from his range we need
30 / 111 = 27%

73% of the time we get 4.5$ (his 3bet) + 0.75$ (blinds) + 1.5$ (our initial raise) = 6.75$
27% of the time we lose 10$(4bet)-1.5$(initial raise)= 8.5$

4BET EV = (Fold% * we get X$)-(Shove% * we lose X$) = 0.736,75 - 0.278.5 = 2,63$EV

few questions : did i miss something ? how to make formula in google excel where i can just put numbers? so next time i don't need spend a lot of time to calculate it or maybe you can recommend software for it ? CREV?

and can anyone share 5bet shove formula when we OOP? like BTN raise , we 3bet on SB , he 4bet and we shove .

Thank you.