Skip to content

Instantly share code, notes, and snippets.

View scytacki's full-sized avatar

Scott Cytacki scytacki

  • Concord Consortium
  • Medford, MA
View GitHub Profile
@scytacki
scytacki / survey-cleaner.gs
Last active February 8, 2017 17:54 — forked from kjola8/survey-cleaner.gs
Google Spreadsheet script to convert survey answers to numbers.
/*
The goal is to identify each column for the type that is
and then convert the cells to numbers.
To identify it, we need to ignore the first few rows which will be headers.We could probably be safe and just skip the first
4 rows and start there.
*/
function getUnique_(values) {
var o = {}, a = [], i, e;