some coordinates act weird?

pein · 2019-06-21 18:08:12

in google sheets and in excel too, when i split data to column, some coords turn from something like (-3924,1082) to those weird long millions

jinbaili83 · 2019-06-21 18:49:37

Take look at https://onemap.wondible.com/ around 8-9 milion East from centre, four eve spawns in equal distances from eachother.
I suspect it is when tutorial zone gets moved/reset one live gets recorded.

pein · 2019-06-21 18:57:12

i mean the coords come with weird fromat from lifelog data and get converted to this single 9 number digit which is weird

jinbaili83 · 2019-06-21 19:44:20

I'm currently using libreoffice and it imports just fine.
I'm pasting data as unformated text but i separete colums with "," space and ( ) so x,y coords are in separate columns.
What is your cell formating? Mabye program detects some pattern and autoformats to something else?

jasonrohrer · 2019-06-21 19:44:56

jinbaili83, do you have any clue what those weird "four corners" are on onemap, around the central spiral? I haven't had a chance to look into it.

jasonrohrer · 2019-06-21 19:47:31

Oh, those are d-towns.

The X and Y coords are multiplied by some factor, I think, pushing out positive or negative as needed.

pein · 2019-06-22 00:13:32

ok figured out, in excel i had to choose the column and put to text mode

don't know why some of them was acting weird, like 500 entries were different than others
had some similarity, like -3800 coords os probably same families

with some lookups i was able to do a map of today data, added a sheet for names, added parents and names avalaible, then split names and sorted based on families, then checked the bigger named ones and marked in snagit editor to the spots, then picked their color

seems like circle goes around counter clockwise 13-14 hours and that why we were on SE NE in first 8 hours

One Hour One Life Forums

#1 2019-06-21 18:08:12

some coordinates act weird?

#2 2019-06-21 18:49:37

Re: some coordinates act weird?

#3 2019-06-21 18:57:12

Re: some coordinates act weird?

#4 2019-06-21 19:44:20

Re: some coordinates act weird?

#5 2019-06-21 19:44:56

Re: some coordinates act weird?

#6 2019-06-21 19:47:31

Re: some coordinates act weird?

#7 2019-06-22 00:13:32

Re: some coordinates act weird?

Board footer