Discover @Rotifer Open Source projects

Michael Maguire (@Rotifer)

Rotifer

Stars
174
Global Rank 132,429 (Top 5 %)
Followers 57
Following 18
Registered over 11 years ago
Most used languages

JavaScript
31.3 %

VBA 12.5 %

Visual Basic 12.5 %

HTML
12.5 %

Perl
12.5 %

PLpgSQL 6.3 %

Python
6.3 %

R
6.3 %
Location 🇬🇧 United Kingdom
Country Total Rank 6,236
Country Ranking

Visual Basic 6

VBA 29

PLpgSQL 98

Perl
618

JavaScript
1,275

R
1,642

HTML
2,457

GoogleSpreadsheetProgramming_2015

Contains all code examples given in the 2015 version of my Leanpub book "Google Spreadsheet Programming". Each chapter is given its own GAS file (.gs).

JavaScript

JavaScript and Google App Script code

VBA

Spreadsheet2SQL

GAS code to convert values in a spreadsheet to SQL statements. Header row is used to for the "CREATE TABLE" statement, data rows are used to create "INSERT" statements. Cangenerate SQLite, MySQL and PostgreSQL versions of SQL

SqliteVba

VBA classes written for use in Excel to interact with SQLite

SpreadsheetToHtmlSelect

Contains GAS and HTML that shows how to use a spreadsheet named range to dynamically populate a Html Service dropdown list. See blog entry:

VBA_SQL_GENERATOR

minimal_perl

Notes on Minimal Perl

databases

Notes and code snippets on databases, SQL and general database programming

algorithms

Algorithms in Python manily but also a few in Perl and R

mypython

VBA_GAS_UDFs

General utility functions for Excel and Google Sheets

PostgreSQL_Applications

Shiny Apps with PostgreSQL back-end.

blog_code

All code used in blog entries from 2016 onwards.

MYR

GAS_TASKS

General pieces of GAS written for specific purposes