Excel Macros

Handy Code Snippets

This page contains links to several Excel Macros. Feel free to use or add additional ones.

• Save Macros in Excel-- a brief How-To
• Create a Toolbar button -- a brief How-To (useful with some macros)
• Julian to regular date converter
• Regular Date to Julian Converter
• MicroMet Format Daily Averages
• General Daily average Macro
• General Monthly average Macro
• DewPoint Calculator Routine
• Relative Humidity Calculator Routine
• Line Deleter for going through online data from shand
• Cell Wrap -- Useful for long column headers in data spreadsheets.
• Data Split -- Short Macro for splitting comma & tab separated data such as when you open a .txt file in Excel
• LI7700 Data Parser -- Short Macro for junking bad data on a quick first cut for a LI-7700 Open Path CH4 Analyzer
• Hourly Data Parser -- Another short utility for down sampling data to hourly.