Okay don't shoot me down here. I was really bored today at work and using a combination of satelite photos and tourist websites thought it would be fun to try and find out where/what the one o'clock gun is aimed at. Got all the data (assuming initial trajectory is 15 deg, edinburgh castle is roughly 85m above sea level and a light gun is used.) but screwed up majorly somewhere as got range to be 26.4 km. Not actually that good at using microsoft excel though - can anyone put me out of my misery/point me in the right direction?