geo_vba
A geographic toolkit/library for VBA, excel etc. (by krijnsent)
Vincenty-Excel
Thaddeus Vincenty's Direct and Inverse formulae for geodesic calculations in Excel (distance, azimuth, latitude, longitude). (by tdjastrzebski)
Our great sponsors
| geo_vba | Vincenty-Excel | |
|---|---|---|
| 3 | 1 | |
| 5 | 44 | |
| - | - | |
| 0.0 | 2.0 | |
| over 3 years ago | about 1 year ago | |
| VBA | VBA | |
| GNU General Public License v3.0 only | MIT License |
The number of mentions indicates the total number of mentions that we've tracked plus the number of user suggested alternatives.
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.
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.
geo_vba
Posts with mentions or reviews of geo_vba.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2021-04-20.
-
I have 400 locations in Excel; how can I easily add their addresses into the same sheet?
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?
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)
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
Vincenty-Excel
Posts with mentions or reviews of Vincenty-Excel.
We have used some of these posts to build our list of alternatives
and similar projects.
What are some alternatives?
When comparing geo_vba and Vincenty-Excel you can also consider the following projects:
VBA-CSV-interface - The power you need to cleanse, filter, sort, reshape, manage and analyze data from CSV files.
geodesy - Libraries of geodesy functions implemented in JavaScript
Export-MS-Project-to-MS-Excel - Export tasks, Gantt chart and resources from MS Project to MS Excel. No additional software or installation required. Using build-in MS Project features (VBA).
JustMoreVBA - A collection of code snippets, modules, and classes that I've written and collected over the years.
Power-Refresh - Schedule refresh of any Excel file using open-source scheduler & refresher written on VBA
vba-macros - Some VBA macros for personal use