Converting locations of cities to bigger map
Posted: 31 Aug 2020 10:23
Hiya!
I would like to enlarge the map of one of my favourite scenario's (currently its 2048x2048, but I would like it to be twice or even 4-times larger).
I am manually data-mining the locations of the cities on that map (AFAIK there is sadly no other way of extracting that information automatically) and will have to double or quadruple the coördinate-information.
That information I can then re-enter (by using the import-towns command) into a scenario made from the heightmap that I created from my original scenario.
I wonder if there is an easy way to do that in a spreadsheet programme (in my case Open Office Calc).
I have no experience with those kind of programmes, so maybe someone here can help me out
I'll try to explain what I would like to do, this is an example of my datasheet:
What I would like to know is if there is a formula that uses the data from the cells in columns D and E and doubles (and in another column quadruples) that data.
The only thing I could think of is using Sum and double the data from a cell.
But I am doing that manually (in the example its =SOM(D2;D2), where I manually have to change D2 to the cellnumber for each row), which will be a lot of work eventually and data-mining the coördinates is work enough
Is there a formula that I can easily copy-paste (or even easier, apply to an entire column) that would do what I would like?
I would like to enlarge the map of one of my favourite scenario's (currently its 2048x2048, but I would like it to be twice or even 4-times larger).
I am manually data-mining the locations of the cities on that map (AFAIK there is sadly no other way of extracting that information automatically) and will have to double or quadruple the coördinate-information.
That information I can then re-enter (by using the import-towns command) into a scenario made from the heightmap that I created from my original scenario.
I wonder if there is an easy way to do that in a spreadsheet programme (in my case Open Office Calc).
I have no experience with those kind of programmes, so maybe someone here can help me out
I'll try to explain what I would like to do, this is an example of my datasheet:
- Example543.png (16.39 KiB) Viewed 1721 times
The only thing I could think of is using Sum and double the data from a cell.
But I am doing that manually (in the example its =SOM(D2;D2), where I manually have to change D2 to the cellnumber for each row), which will be a lot of work eventually and data-mining the coördinates is work enough
Is there a formula that I can easily copy-paste (or even easier, apply to an entire column) that would do what I would like?
