European NHC Rule

Hey everyone,

I just watched Wizards old video about making basic strategy in excel: /jCF-Btu5ZCk

Inspired by this, I started working on my own spreadsheet with basic strategy and now I feel stuck when started thinking about NHC rule.
I'm pretty sure I need to change Dealer's odds for 10 and Acem without assuming he doesn't have BJ, but when I assume he can have BJ my EV goes up to 3%.
So, my guess is that I'm doing something wrong. Do you have any advice or maybe you already got a spreadsheet like this?

I would be glad for any response.

My first guess would be that in your equations for players EV with a Dealer 10 or Ace you are somehow representing that player pushes (rather than loses) when dealer has blackjack and player does not have BJ.

Well ok maybe, I got it wrong, so what I should say is that my EV went down to -3%. And I'm sure it should be closer to 0%, so losing with dealer BJ only making it worse in this case.