Should've used Raw fighting strength of troops, as the report tools often use that. It's a foolproof way of calculating strength. :p
And at the end if you add smithy upgrades to all hammers, strength ranking doesn't really change. Also your calculations might be slighty off as you've forgotten to include the hero items others used, which makes this a whole next level nightmare.