MP Flight Attack Separation Geometry

[Lace]

I have created a spreadsheet which calculates TOT separation by inputting a dogleg offset to the attack run for a four-ship flight.  You can play with the timings, desired final attack heading (relative).  It may be of some use to some MP squadrons, so I thought I'd share it.  Fill in the blue pen, read off the yellow boxes.  Assumes turn away is +ve and turn back to target -ve. (doesn't matter if it is left or right).  The example below shows a four ship splitting from the main attack axis at 30 second intervals and arriving over the target with 22 second and 30 degree separation.

Attack Separation Geometry Calculator.xlsx