Adam Morris brainysmurf

GSheets Formula Tipizoid #1

Learn how to collect a series of columns that that contains target text in the header. Link to Example

The data

You have a database-like table in a Google spreadsheet that is the output of a Google Form that asks questions on a variety of topics. The form itself is organized into sections, where the the first question ("What grade are you in?") will then jump to the relevant section with grade-specific questions. Each section has some questions that repeat ("English") but others that do not ("Design" because students don't take Design until 9th Grade). The result is the following:

        (  First section in form   ) (    Second section in form   )

Writing a custom kernel for Jupyter

Introduction / movitation

Already, Jupyter notebook system is great for sharing course content, and does it in a way that I can constantly write and improve it. However, there was one drawback in the course that I'm offering (IB Diploma Computer Science) and it's that it teaches Pseudocode, and not any official language. That means that I can't just ask them to open the terminal, or use a text editor and execute.

However, like all Open Source tools, Jupyter is very customizable. So I set to work. This is what I wanted:

students can input pseudocode from scratch
student can play with and improve code provided to them

Concurrency in Google AppsScripts (V8)

Steps to reproduce

Run useForLoop independently, and observe it takes about 7 seconds to complete
Run entrypoint which calls useForLoop three times, asynchronously
Observe that the second run takes at least three times as long as the first run to complete
Repeat the process above but in a browser, and observe the expected behaviour

Conclusion: Even though the documentation indicates that you can define async functions, and that you can make Promises, it ain't actually async.

Benchmark: Reading and Writing Spreadsheet using Google Apps Script

October 12, 2018 Published.

October 18, 2018 Updated. In order to compare with Advanced Google Service, a result of Sheets API by UrlFetchApp was added to Appendix.

Loop Benchmarks: V8 vs RHINO

Looping code was written to be compatible with both engines. It simply does nested loops with multiplication in the body.

Conclusion: V8 is way faster.
Caveat: This does not paint a complete picture.

Results:

RHINO

Interfaces in Javascript for Google Apps Scripts

I really like named parameters. I can live without them, but there is one place where I really need them. Cases in which I want to create a class and the paramters are guaranteed to be present, nothing extra. This is one way of implementing them. (It's kinda ugly, but kinda cool.)

Project Key

Either copy into your project, or use as a library: MWzXfEDYTWuJ_Xj0ap9H8-68b30WIDiE_

Wrong behaviour

Things one can get used to for the V8 Google Apps Scripts engine

A bit of a monologue about various syntax changes and adjustments in learning and using the tool.

Logging is slooooooow

I know. Everyone knows.

That's why I wrote a library that writes to a spreadsheet instead. Ever since I started using it I'm far more productive. I don't know how people are still putting with that god-awful lagging logger.

	import time

	prompt = """
	You have a choice:

	a) $1 million, right now
	b) $0.02 right now, then doubled every month
	"""

	while True:

	import subprocess
	import sys


	subprocess.check_call([sys.executable, "-m", "pip", "install", "arcade"])
	# If you wish to reverse the install, uncomment the following line:
	# subprocess.check_call([sys.executable, "-m", "pip", "uninstall", "--yes", "arcade"])


	try:

	function globalStrictMode_() {
	'use strict';
	return function () {
	return this; // returns null in strict mode, global object if not
	}.apply(null, []);
	}

	function globalDefaultMode_() {
	return function () {
	return this; // returns null in strict mode, global object if not