#### rogermccarthy

##### SOC-12

(yes I know this has been done using GURPS Far Trader but I am working in CT and given the different UWP's can't see any easy way of porting it over even if I wanted to).

Can anyone less mathematically challenged than myself suggest an excel formula that allows you to calculate jump distances based on the 4 digit hex codes?

Obviously it's clear looking at Yres in 1802 that Kinorb in 2202 is four hexes away because there is a +4 difference betwen the first two digits of each code.

However how does one (or indeed can one)calculate that Louzy 1604 is three hexes away from Yres 1802 and 6 hexes from Kinorb 2202 without looking at the map?

Assuming that such a formula can be generated how would I go about turning a simple list of world names and location codes into a travel distance matrix?

I am fairly happy playing with excel formulae, but am somewhat rusty on pivot tables etc