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?
Converting locations of cities to bigger map
Moderator: Graphics Moderators
Converting locations of cities to bigger map
Projects: http://www.tt-forums.net/viewtopic.php?f=26&t=57266
Screenshots: http://www.tt-forums.net/viewtopic.php?f=47&t=56959
Scenario of The Netherlands: viewtopic.php?f=60&t=87604
Winner of the following screenshot competitions:
sep 2012, jan 2013, apr 2013, aug 2013, mar 2014, mar 2016, oct 2020
All my work is released under GPL-license (either V2 or V3), if not clearly stated otherwise.
Screenshots: http://www.tt-forums.net/viewtopic.php?f=47&t=56959
Scenario of The Netherlands: viewtopic.php?f=60&t=87604
Winner of the following screenshot competitions:
sep 2012, jan 2013, apr 2013, aug 2013, mar 2014, mar 2016, oct 2020
All my work is released under GPL-license (either V2 or V3), if not clearly stated otherwise.
- 2TallTyler
- Route Supervisor
- Posts: 505
- Joined: 11 Aug 2019 18:15
- Contact:
Re: Converting locations of cities to bigger map
In Google Sheets and Excel you can click and drag that square at the bottom right corner of your selected cell, to extend your selection to an entire column or row, and it will extrapolate the formula for each line. I’d be surprised if your software lacks that feature.
Re: Converting locations of cities to bigger map
Exactly what I needed!! Thank you!!2TallTyler wrote: ↑31 Aug 2020 16:01 In Google Sheets and Excel you can click and drag that square at the bottom right corner of your selected cell, to extend your selection to an entire column or row, and it will extrapolate the formula for each line. I’d be surprised if your software lacks that feature.
Projects: http://www.tt-forums.net/viewtopic.php?f=26&t=57266
Screenshots: http://www.tt-forums.net/viewtopic.php?f=47&t=56959
Scenario of The Netherlands: viewtopic.php?f=60&t=87604
Winner of the following screenshot competitions:
sep 2012, jan 2013, apr 2013, aug 2013, mar 2014, mar 2016, oct 2020
All my work is released under GPL-license (either V2 or V3), if not clearly stated otherwise.
Screenshots: http://www.tt-forums.net/viewtopic.php?f=47&t=56959
Scenario of The Netherlands: viewtopic.php?f=60&t=87604
Winner of the following screenshot competitions:
sep 2012, jan 2013, apr 2013, aug 2013, mar 2014, mar 2016, oct 2020
All my work is released under GPL-license (either V2 or V3), if not clearly stated otherwise.
Re: Converting locations of cities to bigger map
also, almost certainly you can use
to double a value
Code: Select all
=2*D2
Re: Converting locations of cities to bigger map
Thnx for the tip!Eddi wrote: ↑02 Sep 2020 11:17 also, almost certainly you can useto double a valueCode: Select all
=2*D2
Projects: http://www.tt-forums.net/viewtopic.php?f=26&t=57266
Screenshots: http://www.tt-forums.net/viewtopic.php?f=47&t=56959
Scenario of The Netherlands: viewtopic.php?f=60&t=87604
Winner of the following screenshot competitions:
sep 2012, jan 2013, apr 2013, aug 2013, mar 2014, mar 2016, oct 2020
All my work is released under GPL-license (either V2 or V3), if not clearly stated otherwise.
Screenshots: http://www.tt-forums.net/viewtopic.php?f=47&t=56959
Scenario of The Netherlands: viewtopic.php?f=60&t=87604
Winner of the following screenshot competitions:
sep 2012, jan 2013, apr 2013, aug 2013, mar 2014, mar 2016, oct 2020
All my work is released under GPL-license (either V2 or V3), if not clearly stated otherwise.
Who is online
Users browsing this forum: No registered users and 19 guests