2b:null 2c:["$","title",null,{"children":"Seat area interactive playground | Joseph Ricafort | Observable"}] 31:T5d9,function makeSeat (b) { const AREA_ON_FILL = "#777777" const AREA_OFF_FILL = "#f2f2f2" const [p6, p5, p4, p3, p2, p1] = b.split("") const isOnArr = b.split("").map(bd => bd == 1 ? "on" : "off") return ` ` }32:T663,function makeSeatCount (b) { // const [p1, p2, p3, p4, p5] = pCountArr // const seatScale = d3.scaleLinear() // .domain(pCountExtent) // .range() const AREA_ON_FILL = "#777777" const AREA_OFF_FILL = "#f2f2f2" const [p6, p5, p4, p3, p2, p1] = b.split("") const isOnArr = b.split("").map(bd => bd == 1 ? "on" : "off") return ` ` }33:T6ed,makeArrow = (orient) => { const rotationAngle = orient === "top" && 0 || orient === "upper-right" && 45 || orient === "right" && 90 || orient === "lower-right" && 145 || orient === "down" && 180 || orient === "lower-left" && 180 + 45 || orient === "left" && 270 || orient === "upper-left" && 270 + 45 const circleSize = orient === "fully-centered" && 54 || orient === "partially-centered" && 30 || 0 const arrow = ` ` const circle = ` ` if(orient === "fully-centered" || orient === "partially-centered") return circle else if(orient === "empty") return "" else return arrow }34:[] 2f:{"id":"36ce3c9854a46116","slug":null,"title":"Seat area interactive playground","thumbnail":"03623dcecd71c5ec430401962ff545498ec788e45712dfbc06b15732138b7fea","access_level":"public","create_time":"$D2023-03-18T13:50:20.726Z","update_time":"$D2023-04-15T23:59:54.511Z","view_time":null,"first_public_time":"$D2023-03-18T13:50:20.726Z","has_unpublished_edits":null,"fork":false,"stars":0,"starred":false,"owner":{"type":"team","id":"3d0b4e3ec7e42220","login":"josephricafort","name":"Joseph Ricafort","avatar_url":"https://avatars-next.observableusercontent.com/98de557fc6705b8929316825ea99a949993910a62c69bd71444237f50c5077af","tier":"starter_2024"},"version":534,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"13742c0768377f5c","login":"josephricafort","name":"Joseph Ricafort","avatar_url":"https://avatars-next.observableusercontent.com/98de557fc6705b8929316825ea99a949993910a62c69bd71444237f50c5077af","tier":null}],"members":[{"type":"individual","id":"13742c0768377f5c","login":"josephricafort","name":"Joseph Ricafort","avatar_url":"https://avatars-next.observableusercontent.com/98de557fc6705b8929316825ea99a949993910a62c69bd71444237f50c5077af","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"title":"Seat area interactive playground","cells":[{"id":0,"value":"# Seat area interactive playground","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":121,"value":"Illustrated visual categorizing different combinations","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":108,"value":"directionsSet = [...new Set(combPressures.map(d => d.direction))]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":116,"value":"dirSetOrdered = [\n \"fully-centered\",\n \"lower-left\",\n \"left\",\n \"upper-left\", \n \"down\",\n \"up\", \n \"upper-right\",\n \"right\",\n \"lower-right\",\n \"partially-centered\", \n \"empty\"\n]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":263,"value":"## Different combinations of seat directions","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":267,"value":"We group combinations based on which direction they lean more towards.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":198,"value":"html`${\n dirSetOrdered.map(dir => {\n return `

${makeArrow(dir)}${dir}

${combPressures.filter(d => d.direction === dir).map(comb => makeSeat(comb.b))}

`\n })\n}`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":310,"value":"## Visualize directions over time","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":373,"value":"sensorCombiTemporal","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":321,"value":"sensorCombiDir = aq.from(sensorCombiTemporal)\n .derive({ \n date: aq.escape(d => {\n let newDate = new Date(d.date)\n newDate.setMinutes(0, 0, 0)\n return newDate\n }),\n pAtLeastOne: d => d.sensorSum > 0 ? 1 : 0\n })\n .groupby(\"date\", \"direction\")\n .rollup({\n sensorCount: d => op.sum(d.pAtLeastOne)\n })\n .objects()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":509,"value":"sensorCombiWide = aq.from(sensorCombiDir)\n .groupby(\"date\")\n .pivot(\"direction\", \"sensorCount\")\n .derive(dirSetOrdered.reduce((objInds, ind) => {\n return {...objInds, [ind]: aq.escape(d => typeof d[ind] === \"undefined\" ? 0 : d[ind])}\n }, {}))\n .orderby(\"date\")\n .objects()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":297,"value":"html`

${\n dirSetOrdered.map(dir => `${makeArrow(dir)}`)\n}

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":314,"value":"Plot.plot({\n marks: [\n Plot.cell(sensorCombiDir, {\n x: \"direction\", \n y: \"date\",\n fill: \"sensorCount\"\n }),\n Plot.text(sensorCombiDir, {\n x: \"direction\", \n y: \"date\",\n text: \"sensorCount\",\n fill: d => d.sensorCount > 150 ? \"white\" : \"black\"\n })\n ],\n x: {\n domain: dirSetOrdered\n },\n color: {\n range: [\"white\", \"red\"]\n },\n marginLeft: 120,\n height: 10000,\n width: 700,\n grid: true\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":449,"value":"## Minutes vs hours/days/months scrolly","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":461,"value":"N_SPLIT_HOUR = 6","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":466,"value":"minutesPerInterval = 60 / N_SPLIT_HOUR","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":454,"value":"sensorCombiHourMin = aq.from(sensorCombiTemporal)\n .derive({\n minuteInterval: aq.escape(d => {\n const minutes = d.date.getUTCMinutes()\n let upperLimit = minutesPerInterval\n\n for(let i=0; i <= N_SPLIT_HOUR; i++){\n if(minutes <= i * minutesPerInterval) return i * minutesPerInterval\n }\n \n return upperLimit\n }),\n date: aq.escape(d => {\n let newDate = new Date(d.date)\n newDate.setMinutes(0, 0, 0)\n return newDate\n }),\n })\n .groupby(\"date\", \"minuteInterval\")\n .rollup({\n p1Count: d => op.sum(+d.p1),\n p2Count: d => op.sum(+d.p2),\n p3Count: d => op.sum(+d.p3),\n p4Count: d => op.sum(+d.p4),\n p5Count: d => op.sum(+d.p5),\n })\n .orderby(\"date\", \"minuteInterval\")\n .objects()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":488,"value":"pCountExtent = {\n const pCountArr = aq.from(sensorCombiHourMin)\n .derive({\n pCount: d => d[\"p1Count\"] + d[\"p2Count\"] + d[\"p3Count\"] + d[\"p4Count\"] + d[\"p5Count\"]\n })\n .objects()\n .map(d => d.pCount)\n\n return d3.extent(pCountArr)\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":437,"value":"### Graphic maker functions","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":7,"value":"$31","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":485,"value":"$32","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":221,"value":"$33","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":93,"value":"## Appendix","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":95,"value":"import {aq, op} from \"@uwdata/arquero\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":98,"value":"import {d3} from \"@josephricafort/60daysofmesitting\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":102,"value":"import {combPressures} from \"@josephricafort/60daysofmesitting\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":316,"value":"import {sensorCombiTemporal} from \"@josephricafort/60daysofmesitting\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":343,"value":"function convertTo24Hour(time) {\n\n var hours = parseInt(time.substr(0, 2));\n\n if(time.indexOf('AM') != -1 && hours == 12) {\n time = time.replace('12', '00');\n }\n if(time.indexOf('PM') != -1 && hours < 12) {\n time = time.replace(hours, (hours + 12));\n }\n if(time.indexOf('AM') != -1 && hours < 10) { \n time = \"0\" + time\n }\n\n return time.replace(/(AM|PM)/, '');\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":346,"value":"function compareHour(a,b) {\n\n var atime = Date.parse('9/19/2014 ' + convertTo24Hour(a.time));\n var btime = Date.parse('9/19/2014 ' + convertTo24Hour(b.time));\n\n if (atime < btime) {\n return -1;\n }\n\n if (atime > btime) {\n return 1;\n }\n\n return 0;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W34","stdlib":"1","titling":"auto"}} 30:"$2f:body"