Tools - my own
Excel VBA scripts
- Greeks.bas - Converts greek letter names to greek letters. E.g. converts "Omega" to Ω and "alpha" to α. Don't use quotes. Also, undoes any formatting, so use before formatting.
- SubSuper.bas - Converts [box bracketed text] to subscript and {braced text} to superscript. Note Greeks above undoes SubSuper formatting.
- collapseRange.bas - 3 subroutines: 1) collapseRows to remove empty rows from selected range; 2) collapseColumns to remove empty columns from selected range; 3) collapseAll to do both 1 & 2.
- This function for MS Excel converts the target cell to Water Year (in CA, WY starts in October, calendar month 10):
=IF(MONTH(A1)-10<0,YEAR(A1),YEAR(EDATE(DATE(YEAR(A1),10,1),11)))
Tools - others
(free unless otherwise noted)
GIS-related
Format converters
- CSV to SHP: CSVtoSHP [from Christopher Michaelis] - Requires Microsoft Dot Net Framework. I haven't tried this, as Epoint2GE works fine, but could be useful. A bit burdensome to install, and heavy (the Zonum Solutions tools are lightweight).
- SHP to KML: Shp2kml [from Zonum Solutions] - Works great--includes the option to put the shp attribute information in the kml feature balloon.
- XLS to KML: Epoint2GE [from Zonum Solutions] - An Excel VBA program for converting WGS84 coordinates (unprojected or UTM in meters)
- KML to SHP: Kml2shp [from Zonum Solutions]
Programming-related
Database connection strings: ConnectionStrings.com |