The only thing I can suggest is to check the Wiki in regards to travel speeds - http://wiki.en.tribalwars2.com/index.php?title=Battles#Speed_and_Discipline

There is a travel time estimation as well - so my best guess is a randomized variable within the equation may be changing the times up slightly as well.

Check here: http://wiki.en.tribalwars2.com/index.php?title=Barracks

Specifically:

7 | Taining grounds | This research will increase your discipline by 33%. Discipline increases your army arrival time estimation. |

19 | Large grounds | This research will increase your discipline by 33%. Discipline increases your army arrival time estimation. |

23 | Fortified Roof | Researching this will increase this building's hit points by 50% |

25 | Military Academy | This research will increase your discipline by 33%. Discipline increases your army arrival time estimation. |

22% error cannot be attributed to discipline.

Because it is a hexagon grid, when traveling to 430|278 from 431|277 they are going the distance and a half. Which is why you're running into weird travel times. It's because the game is calculating the hexgrid Z value as well as X and Y. (Kinda)

So to calculate distance it's going to be

Your explanation led me to another thread where I found this:

The tiles in TW2 are hexagons and a hexagon always has a diameter to width ratio of 1.155. So the diameter of a hexagon is always 1.155 x its width.

So since the width of TW2 hexagon tile is 1, proven by looking at the travelling speeds between adjacent tiles which are connected face to face (the width),

then the diameter must be 1.155 x 1 = 1.155.

The radius then, which would be the centre of the tile to the point edge, would be 0.5775. This is the same dimension as the face length.

The vertical arrangement of tiles is such that the centre to centre distance of tiles in a line vertically is three times the radius or approximately 1.73 tiles.

You can see that this ratio is correct by taking any unit and dividing the vertical time to nearest tile by the travel time per tile and you get 1.73... as the multiplier.

So using your spears example, 14 minutes per tile x 1.73 = 24.22 minutes.

SQRT((IF(ISEVEN(D2),C2-0.5,C2)-IF(ISEVEN(B2),A2-0.5,A2))^2 + 0.75 * (B2-D2)^2)

This assumes x1, y1, x2, y2 are in cells a2,b2,c2,d2.

I'm not gonna lie, I kinda cheated and went to this article.coolmite;n2542 said:Thanks Tokano! Where do you get the value of z?

I gave up trying to use the Pythagorean Theorem route since it never was quite as accurate as I would have liked. Then I found this article a few days ago and it helped tweak it in a way I wouldn't have considered.

Granted, it's based off of Civilization V, but it can be applied to TW2 since he's only considering a flat 2D plane.