geo_vba
A geographic toolkit/library for VBA, excel etc. (by krijnsent)
excel-formula-print
VBA macro to print formulas with variable names (by chris-hendrix)
Our great sponsors
| geo_vba | excel-formula-print | |
|---|---|---|
| 3 | 1 | |
| 5 | 3 | |
| - | - | |
| 0.0 | 0.0 | |
| over 3 years ago | almost 3 years ago | |
| VBA | VBA | |
| GNU General Public License v3.0 only | - |
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
excel-formula-print
Posts with mentions or reviews of excel-formula-print.
We have used some of these posts to build our list of alternatives
and similar projects.
-
Good general Mechanic Calculation Suite?
Shameless plug, but I wrote an Excel macro that displays the formula in terms of its variables. Makes checking a breeze. And super easy to paste into Word if you are creating a report.
What are some alternatives?
When comparing geo_vba and excel-formula-print 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.
SQLiteC-for-VBA - SQLite library for VBA wrapping ADODB and SQLite C-language API.
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).
vba-macros - Some VBA macros for personal use
Power-Refresh - Schedule refresh of any Excel file using open-source scheduler & refresher written on VBA