I managed to get it to work. I'm not sure what I did. I think selecting and deselecting the passives might have calculated it differently - I'm not sure.
Anyway, I made a few corrections and additions to my spreadsheet, which I find easier to use (for me):
I also bought a new shield from the AH for just 24,999 gold! This shield is crazy good for that much gold. It actually gives me the same effective health in terms of blocking as shields that are much more overpriced compared to this. It is a stellar deal, and is a huge upgrade compared to my last shield: