Hate to hear you had this happen..I myself also have had this happen even when I measure the sugar properly. Still having truckloads of yeast in suspension, fermentables that did not ferment during primary, mini-fermentations kicking up post racking, so....it happens.
I use this technique for the rare batch I have that ends up overcarbed in the bottle with some good success..
I also moved to kegging this year which has eliminated the bottle overcarbing issues. I try to steer clear of the quick shake force method for kegging..I just set my CO2 for my target carb rate and let it ride until she is ready adjusting as needed.