Distances on World Map

Bob Sainsbury
Bob Sainsbury
Greenhorn
Joined Jul 2012 Posts: 1
edited 4 Dec 2012, 12:21AM
I have made a spreadsheet to calculate distances on the World Map. Put in the from and to co-ordinates in the grey cells and the distance is displayed. Note that it doesn't take into account obstacles.

https://docs.google.com/spreadsheet/ccc?key=0AgiblAFn-XSkdEI4Ymk4aHRMQ3BRVUpKQzZFZkVTLUE

For those who are interested, what it does is slant the wriggley y-axis at 120 degrees to the x-axis then adds a third z-axis at 120 dgrees to the other two. Distance is the maximum absolute of the three deltas.

Let me know what you think!
  • PhoenixBlack
    PhoenixBlack
    Greenhorn
    Joined Nov 2012 Posts: 7
    ok so I am not in anyway a mathamatician, in fact I never passed math... ever.... anyway I love the idea, its at least the start of something!

    but I have a question. If I enter my base cords, then the cords of a friend of mine, the distance that War Commander tells me and the distance the spreadsheet tells me are vastly different. ie. from 272,343 to 218,288 is 275km in war commander
    and 4o6 on the spreadsheet

    can you tell me what I have done wrong?
  • The Exile-S2K
    The Exile-S2K
    Strike-force Captain
    Joined May 2012 Posts: 669
    1 to something
    mmm
  • Indoctrinater
    Indoctrinater
    Potential Threat
    Joined Apr 2012 Posts: 45
    the spreadsheet is not working, perhaps it has been destroyed by someone who misued it.

    I do want to find a excel/spreadsheet formula that calculate distances across the map
    For example from 123,234 to 321,432, the values of the cells are
    A1: 123 (x co-ord of starting point)
    A2: 234 (y co-ord of starting point)
    B1: 321 (x co-ord of target point)
    B2: 432 (y co-ord of target point)
  • Daniel26
    Daniel26
    Master Tactician
    Joined Oct 2012 Posts: 2,219
    Being that the hexagonals are not evenly built on all sides may make distances vary from what game says and from what a spreadsheet might calculate.
    [COLOR="#00FF00"]Home Sector: 108
    Level: 42
    Group: Wolves of War (Inactive)  but friends of many.
    Event/Mission Rewards: Not all but way too many to keep track of.
  • Dave Vandervelde
    Dave Vandervelde
    Potential Threat
    Joined Nov 2012 Posts: 77
    It's just the Pythagorean Theorem... take the squares of the differences in the x and y values, then square root their sum. I picked a random place (83.467) and compared it to my base (468.351), and both Pythagorean Theorem and WC give a distance of 402 km.

    So, in the above example... sqrt[(83-468)^2 + (467-351)^2] = 402
  • KINGS_Of_Hell
    KINGS_Of_Hell
    Minor Nuisance
    Joined Jul 2013 Posts: 189

    spam

    a

      CLAN:KINGS 
    http://www.pixeljoint.com/files/icons/full/helicoptero_animado_2.gif
  • KINGS_Of_Hell
    KINGS_Of_Hell
    Minor Nuisance
    Joined Jul 2013 Posts: 189

    spams

      CLAN:KINGS 
    http://www.pixeljoint.com/files/icons/full/helicoptero_animado_2.gif
  • KINGS_Of_Hell
    KINGS_Of_Hell
    Minor Nuisance
    Joined Jul 2013 Posts: 189

    spams

      CLAN:KINGS 
    http://www.pixeljoint.com/files/icons/full/helicoptero_animado_2.gif
  • KINGS_Of_Hell
    KINGS_Of_Hell
    Minor Nuisance
    Joined Jul 2013 Posts: 189

    spams

      CLAN:KINGS 
    http://www.pixeljoint.com/files/icons/full/helicoptero_animado_2.gif
  • KINGS_Of_Hell
    KINGS_Of_Hell
    Minor Nuisance
    Joined Jul 2013 Posts: 189

    spams

      CLAN:KINGS 
    http://www.pixeljoint.com/files/icons/full/helicoptero_animado_2.gif
  • Chronicle Thomas
    Chronicle Thomas
    Greenhorn
    Joined May 2014 Posts: 6

    Hey Hi...
    Do you know about hellstorms in this event Operation: Cerberus
    This time will hellstorms be on sale for 12500XP or they will remain on 25000XP?


Sign In or Register to comment.