..in the Excel spreadsheet below the fatal route is split into four legs...
...and allows one to adjust the speed for each leg....the point being to end up with 59.6 minutes in the box D13 ( this equates to 59 minutes 36 seconds , the calculations are done with decimal parts of minutes)...
..it takes the lift-off time from the HOL report......the zone boundary call time is for the first call......the boundary itself 10NM from the centre of the field ......uses the most probable route to Carnlough passing Ballymena ..........shows that a higher speed over the water can make up for the slower sections......the "delta" lines are the times for each leg.....
........when you change the distance (over the ground) for the first leg it will show the speed required to reach the point reported....
....for the next two legs changing the speed ripples down and corrects the arrival time.....
.the last leg is set to 151 kt GS for two minutes as per RACAL ........
..you can download a copy from
here ...it is only small...there is also a readme file at the same link , with a more detailed explanation.....
rgds Robin.....