The first maps rolled out today from the LibreCalc generated start scripts, the automated creation of the download pages will be addressed next week. With the switch to a free office package and the cleaning up of the programmes, it is now much easier for my co-authors to familiarise themselves with map production in OpenAndroMaps. In addition, a flexible folder structure was implemented to allow porting to other machines and effective load balancing/caching. Porting means cleaning up 9 years of organically grown programmes and simply rewriting them, leaving out my beloved PERL for pure administration jobs. This is impossible to do manually, so far Excel-VBA programmes in combination with PERL scripts have done most of the hard work.įor about 10 days now, I have been sitting in front of the computer every free minute and porting VBA to Starbasic. Last but not least, the web pages must be regenerated after each update. Corresponding start-up programmes for each individual production step such as conversion of file formats, creation of boundary polys, elevation data, sea areas, inheritance of bike/MTB/hike routes etc,etc. This means that different tag mappings have to be created and assigned to individual maps.īut also such trivial things as map centres, languages, fineness of elevation data, allocation to render queues (load balancing) have to be managed. Well, with OAM there is a stock of around 270 maps to manage with the most diverse settings.įor example, map symbols for petrol stations and drinking water sources in urban areas appear only at much higher zoom levels than in Scandinavia – for this, there is also the ELEMENTS theme by Tobias, which takes this into account. ods format.Many people might ask themselves: “Why Excel for an OSM map project? If you wish, please upload a small spreadsheet in. You could be experiencing problems if there are blank rows or columns in your table or your table is otherwise malformed.

The data in other columns get sorted as well. At this point I can choose which column to sort by.

Then, in the menu bar, I click on Data, Sort. Bank Amount Rate % -Cum/Qtrly- Started on Ending On

Libreoffice calc excel