Difference between revisions of "Excel Macros"

From IARC 207 Wiki
Jump to navigation Jump to search
imported>Bob
 
 
(9 intermediate revisions by 6 users not shown)
Line 1: Line 1:
 
== Handy Code Snippets ==
 
== Handy Code Snippets ==
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.  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)
+
* [[Tool Bar Button|Create a Toolbar button]] -- a brief How-To (useful with some macros)
* [[Calculate Daily Averages / Sums from hourly data]] (written for excel)
+
* [[Julian to regular date converter]]  
* [[Freezing / Thawing Indices]] (written for excel)
+
* [[Regular Date to Julian Converter]]
 +
* [[Calculate Daily Averages / Sums from hourly data| MicroMet Format Daily Averages]]
 +
* [[Daily Averages 2| General Daily average Macro]]
 +
* [[Monthly Averages| General Monthly average Macro]]
 +
* [[DewPoint Calculator Routine]]
 +
* [[Relative Humidity Calculator Routine]]
 +
* [[Double Line Delete| 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.
 +
===Elephant snippets===
 +
(There may be quite a bit of duplication I'm to lazy to figure it out)... these are copy/pastes of full modules FWIW, too.
 +
* [[Excel Macro Averages]]
 +
* [[Excel Macro Cheap Windrose]]
 +
* [[Excel Macro Snow Algo]]
 +
* [[Excel Macro WindCheck]]

Latest revision as of 10:37, 17 July 2019

Handy Code Snippets

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

Elephant snippets

(There may be quite a bit of duplication I'm to lazy to figure it out)... these are copy/pastes of full modules FWIW, too.