I created a spreadsheet to do the math. Give it a try, and use the goal seeking feature to back solve. Click here for the link.
Hi Brian,
I clicked on the link - your s/sheet is very neat and appears to give me a result of 2 watts required to deliver 80dB from my line-source speakers at my 3.5m listening distance ... did I drive it correctly?

Does this mean I theoretically have about 100 times the power in reserve (if I have a 200w amp driving my bass panels)? So if ten times the power gives a 2:1 SPL ratio, I have a 4:1 SPL ratio "available" for transients??

But maybe in terms of the apocryphal reproduction of "a glass breaking on tiles" - which we are assuming will give a realistic, life-like representation of live music - it is not so much the theoretical steady-state SPL ratio capability which is key, it is (as Russell D suggested) more how much instantaneous (undistorted) power the amp can deliver in an instant - ie. for 20 msec, 10 msec and 1 msec??

I suspect this depends on amp topology as well as how good its PS is ... and still we come back to the question of what is the amount of headroom required ... 4:1? ... 10:1?

Regards,
Andy