With a history of various tech work since 1989, and a programming and tech writing history that goes back to 1977, this site is a place for me to post some of that work. Some earlier dates are guesses, and code from that time might need tweaking to get it to work again. Hopefully someone will find this stuff useful.
- Using Python and GDAL to Split Multipart SOUNDG Lat/Long/Depth from NOAA S-57 ENC Files into KML Files for use with QGIS
Abstract: A 2003 Python script named get_soundg.py extracted ELEV from the multipart SOUNDG layer, but in 2017 was found to generate numerous errors. Building on the excellent foundation the code provided while extracting to the KML file type provides a viable solution for what appears to be a common request.
- Using Excel to Accurately Inventory Restaurant Beverages plus Bottle, Can & Keg Deposits
Abstract: Restaurants and other hospitality facilities will have part of their F&B budget rotating through container deposits for bottles and cans of pop (aka “soda”) and alcoholic beverages, as well as kegs of those products in states which require those deposits. Some states require twice the deposit amounts per container than some other states, and larger venues and amusement parks may have considerable funds constantly applied to this requirement. A monthly inventory spreadsheet technique assists in keeping track of where these funds are applied.