Difference between revisions of "Excel Macros"

From IARC 207 Wiki
Jump to navigation Jump to search
Line 9: Line 9:
 
* [[Monthly Averages| General Monthly average Macro]]
 
* [[Monthly Averages| General Monthly average Macro]]
 
* [[DewPoint Calculator Routine]]
 
* [[DewPoint Calculator Routine]]
 +
* [[Relative Humidity Calculator Routine]]
 
* [[Double Line Delete| Line Deleter for going through online data from shand]]
 
* [[Double Line Delete| Line Deleter for going through online data from shand]]
 
* [[Cell Wrap]] -- Useful for long column headers in data spreadsheets.
 
* [[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
 
* [[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
 
* [[LI7700 Data Parser]] -- Short Macro for junking bad data on a quick first cut for a LI-7700 Open Path CH4 Analyzer

Revision as of 11:53, 28 November 2011

Handy Code Snippets

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