Difference between revisions of "Excel Macros"

From IARC 207 Wiki
Jump to navigation Jump to search
imported>Bob
imported>Bob
Line 2: Line 2:
 
This page contains links to several Excel Macros that Bob's made.  Feel free to use or add additional ones.
 
This page contains links to several Excel Macros that Bob's made.  Feel free to use or add additional ones.
 
* [[Save Macros in Excel]]-- a brief How-To
 
* [[Save Macros in Excel]]-- a brief How-To
* [[Julian to regular date converter]] (written for excel)
+
* [[Julian to regular date converter]]  
* [[Calculate Daily Averages / Sums from hourly data]] (written for excel)
+
* [[Regular Date to Julian Converter]]
* [[Freezing / Thawing Indices]] (written for excel)
+
* [[Calculate Daily Averages / Sums from hourly data]]
 +
* [[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:21, 12 March 2008

Handy Code Snippets

This page contains links to several Excel Macros that Bob's made. Feel free to use or add additional ones.