blacki

/** 
 * Returns the URL of a hyperlinked cell, if it's entered with hyperlink command. 
 * Supports ranges
 * @param {A1}  reference Cell reference
 * @customfunction
 */
function linkURL(reference) {
  var sheet = SpreadsheetApp.getActiveSheet();
  var formula = SpreadsheetApp.getActiveRange().getFormula();
  var args = formula.match(/=\w+\((.*)\)/i);

blacki

Dev Environment

I do the following on a per project basis.

Install virtualenv

If you don't have virtualenv installed, install it globally by running pip install virtualenv from any folder. If that didn't work because you have no pip try pip3 install virtualenv instead.

Create a new python for the project

blacki

.DS_Store
node_modules
npm-debug.log
yarn.lock
package.lock

blacki

                              ME
               WI          VT NH
WA ID MT ND MN IL MI    NY MA
OR NV WY SD IA IN OH PA NJ CT RI
CA UT CO NE MO KY WV VA MD DE
   AZ NM KS AR TN NC SC
         OK LA MS AL GA
HI AK    TX             FL

blacki

Keeling Curve

click chart

blacki

Visualizing stable/unstable equilibria in K-Means unsupervised learning algorithm. Each run follows the path of the mean converging as shown here

blacki

K-Means Unsupervised Learning Algorithm. Also see K-Means Equilibria here.

blacki

Generating clusters of random points

blacki

Generating random points to get a sense of the shape and distribution.

blacki

Moiré spiral patterns resulting from translating, rotating, as well as scaling random points. As described by Tadashi Tokieda on Numberphile