Difference between revisions of "Excel Macros"

From IARC 207 Wiki
Jump to navigation Jump to search
imported>Bob
Line 5: Line 5:
 
* [[Julian to regular date converter]]  
 
* [[Julian to regular date converter]]  
 
* [[Regular Date to Julian Converter]]
 
* [[Regular Date to Julian Converter]]
* [[Calculate Daily Averages / Sums from hourly data]]
+
* [[Calculate Daily Averages / Sums from hourly data| MicroMet Format Daily Averages]]
 +
* [[Daily Averages 2| General Daily average Macro]]
 
* [[Freezing / Thawing Indices]]  
 
* [[Freezing / Thawing Indices]]  
 
* [[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

Revision as of 10:44, 1 August 2008

Handy Code Snippets

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