Automatic Coordinate Calculation Spreadsheet

[bassair]

I needed to find some spawn points and the only information I could get was... complicated at best, and once I understood it I came up with a simple spreadsheet to do the required maths for me. 

 

The spreadsheet can be found here on Google Drive and should work perfectly. It requires RoboMat's Coordinate Viewer, technically.

 

The spreadsheet cannot be edited directly so you need to either download it (file > download as) or copy it to your own drive (file > make a copy)

 

To use it, you find a spot on your map, turn on the coordinate viewer and put the absolute coordinate into the "absolute coordinate" box. It then gives you the maths. 

 

The "coordinate" output box gives you the main variable (so if you put an X in you get the X out) and then the "position" gives you the remainder, which is the position. 

 

To explain more, to set a spawnpoint you need worldX, worldY, posX and posY

 

                     worldX = #,
                     worldY = #,
                     posX = #,
                     posY = #,

 

If you put the absolute X coordinates from the coordinate viewer into the spreadsheet - we'll use 10632 for this - it'll give you "35" as the coordinates and "132" as the position. 

 

                     worldX = 35,

                     worldY = #,
                     posX = 132,

                     posY = #,

 

Any feedback is appreciated. I really hope this helps!

[RoboMat]

Hehe the coordinate viewer actually does that for you already.

 

That's what the "relative" coordinates are

 

WorldX = CellX

WorldY = CellY

 

etc.

 

[bassair]

Ohhhh o_o we couldn't figure it out T_T Well, fail. I'm all embarrassed now.

[RoboMat]

Ohhhh o_o we couldn't figure it out T_T Well, fail. I'm all embarrassed now.

 

Don't feel embarrassed

[okeer]

if this is what you get, what do we enter in serveroptions:

unedited

DisplayUserName=trueSpawnPoint=0,0,0SafetySystem=true

didnt figured out what to enter there, now trying to get my coords with your way (edit later with outcome) - is there a way to obtain coords out of the map viewer by blindcoder?

[harakka]

 is there a way to obtain coords out of the map viewer by blindcoder?

Nope.