Difference between revisions of "Excel Macros"
Jump to navigation
Jump to search
imported>Bob |
|||
| (6 intermediate revisions by 5 users not shown) | |||
| 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]] |
| + | * [[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. | * [[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 | ||
| + | *[[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.
- 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.
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.
