Jim, you hit the nail on the head, even with extensive calculations, the error is large. Seasoned EMC chaps tend to ask for thin-walled Honeycombe openings with a depth at least 5 times the hole dia. If you can't live with a deep hole, life gets hard....
Derek Walton Owner: L F Research EMC Design and Test Facility, Poplar Grove, IL USA.

