|7 months ago||over 1 year ago|
|GNU General Public License v3.0 only||GNU General Public License v3.0 only|
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
I have 400 locations in Excel; how can I easily add their addresses into the same sheet?
1 project | reddit.com/r/excel | 24 Feb 2022
Apart from the mentioned solutions, you can try this code I wrote a while ago: https://github.com/krijnsent/geo_vba
Can I Create a Heat Map with Excel Data for a Downtown Area?
1 project | reddit.com/r/excel | 14 Jul 2021
As u/Grey_Patagonia_Vest describes: you could add some more information like a postal code to the address. If you're looking for "main street", that will give tons of hits, if you add a postal code and/or city there is a higher chance you get to your desired location/city. I've built this toolkit, based on OpenStreetMap / Nominatim to transform addresses to lat/long -> https://github.com/krijnsent/geo_vba , using the geo_nom_search function, you could give it a try.
Using VBA CSV interface to work with USA Cartographic Boundary Files (Shapefiles)
2 projects | reddit.com/r/vba | 20 Apr 2021
Not sure if it is of any use to you, but OSM has quite some data too. I have some code in a repository that could be of assistance: https://github.com/krijnsent/geo_vba
What are some alternatives?
VBA-JSON-parser - Backus-Naur Form JSON Parser based on RegEx for VBA
VBA_personal - Library with VBA, used in multiple projects.
crypto_vba - An Excel/VBA project to communicate with various cryptocurrency exchanges APIs
VBA-CSV-interface - The most powerful and comprehensive CSV/TSV/DSV data management library for VBA, providing parsing/writing capabilities compliant with RFC-4180 specifications and a complete set of tools for manipulating records, fields and files.
VBA-General - A repository of various modules and classes for interacting with Excel and doing other... things.
VBA-Better-Array - An array class for VBA providing features found in more modern languages