I got about a 7ft spray.
Do NOT shake up the Diet Coke! Unless you plan on slamming it into the pavement creating a diet coke rocket!
We tried it too about 2 weeks ago; used regular Mentos and got about a 6 foot spew out of Regular Coke, not diet.