LessGoudarzi/codeSnippets

Snippet Archiving

Reference Material

• Help with GitHub
• Managing Projects/Milestones, etc.

codeSnippets

Snippet Archiving

We often find ourselves re-generating code that we know we have already produced on another project. As such, we are hoping to use this github to collect together various snippets of code that we can later use.

The following provide links to the organizations associated with the software we often work with:

• VBA, primarily for Excel but some with Word and Access
• D3.js, a very powerful data visualiaztion package written in javascript
  • Dimple.js an extension of D3.js
  • Crossfilter.js another useful library of javascript
• JQuery, jQuery is a fast, small, and feature-rich JavaScript library. It makes things like HTML document traversal and manipulation, event handling, animation, and Ajax much simpler with an easy-to-use API that works across a multitude of browsers. With a combination of versatility and extensibility, jQuery has changed the way that millions of people write JavaScript.
• eViews, an econometric programming language
• [GAMS] will add link soon

We plan on putting together alternative files that will share the various code snippets that we have found useful to re-use.

We will put links to the files here.

• VBA
• D3JS
• [eViews]
• Other, GAMS

Each section that follows contains links to snippets in each language.

Any comments ar suggestions are welcome.

VBA

• Creating Listing of Worksheets in a workbook with menu of hyperlinks

• Creating and using an Index

• Splitting a string, used in my case to allow reading an ascii file

• Getting last row and column in a worksheet

• [Creating an Excel Dashboard: GDX data extract, radio boxes and graphs](https://github.com/LessGoudarzi/codeSnippets/blob/master/Nuggets supporting an Excel VBA Dashboard.md)

• [Sort Routines](https://github.com/LessGoudarzi/codeSnippets/blob/master/VBA Sort Routines.md)

• File selection from dialog

• Collection of VBA Routines

  • compare load shapes ascii read and cycling.bas
  • compare load shapes.bas
  • demand recast for load shapes.bas
  • excelRangeToCSV.bas
  • export_jason.bas
  • extract and process weather station data.bas
  • myListofMacros.bas
  • NYISO load file processing.bas
  • pauseUntil.bas
  • range statistic functions.bas
  • read_ascii_vba.bas
  • Sub export_Jason_table.bas
  • Summary_Analysis.bas

• Calculate frequency distribution

D3JS

• A shell with libraries and basic page layout

• A couple of filters that proved valuable

  • Filter based on value = x
  • Filter based on >= value
  • Filter union of two arrays based on key element in an array

Other and GAMS

• Writing to xls from gdx adding column headers