2a:null 2b:["$","title",null,{"children":"Advent of Code Leaderboard | neuefische | Observable"}] 30:T427,Plot.plot({ marks: [ Plot.line( points, Plot.map( { y: "cumsum" }, { z: "name", x: "day", y: "points", stroke: "name", strokeWidth: 1, curve: "monotone-y" } ) ), Plot.dot( points, Plot.map( { y: "cumsum" }, { z: "name", x: "day", y: "points", r: 2, fill: "name", stroke: "white", strokeWidth: 1, filter: (d) => !d.incomplete } ) ), Plot.text( points, Plot.selectLast( Plot.map( { y: "cumsum" }, { z: "name", x: "day", y: "points", text: (d) => (names.has(d.name) ? d.name : null), textAnchor: "start", dx: 5 } ) ) ) ], width, height: names.size * 16 + 50, x: { domain: domains.days, tickFormat, label: null }, y: { zero: true }, marginLeft: 50, marginRight: 80 })31:T559,points = { const start = active.length ? names.size : Object.keys(data.members).length, points = [], scores = {}; for (const [day, stars] of Object.entries(days).sort((a, b) => a[0].localeCompare(b[0]) )) { stars.sort((a, b) => a.ts - b.ts); const missing = new Set(names); const fastest = stars[0].ts; let p = start; for (const star of stars) { const score = (scores[star.name] = (scores[star.name] || 0) + p); points.push({ ...star, day, points: p--, score, minutes: (star.ts - fastest) / 1000 / 60, abs_minutes: fastest.getHours() * 60 + fastest.getMinutes() - offset + (star.ts - fastest) / 1000 / 60 }); missing.delete(star.name); } for (const name of missing) { points.push({ name, day, incomplete: true, points: 0, score: scores[name], minutes: Infinity, abs_minutes: Infinity }); } let rank = 1; for (const p of points .slice(points.length - names.size) .sort((a, b) => b.score - a.score)) p.rank = rank++; } for (const last of d3 .rollup( points.filter((d) => !d.incomplete), (d) => d[d.length - 1], (d) => d.name ) .values()) last.last = true; return points; }32:[] 2e:{"id":"6b18642b7142a558","slug":"advent-of-code-neuefische-leaderboard","title":"Advent of Code Leaderboard","thumbnail":"ae8168f11f65a30e2bcfd7a6829f49658b40a58dbd4fe4f8b7db89d9644385b6","access_level":"public","create_time":"$D2022-12-05T14:35:44.198Z","update_time":"$D2022-12-11T09:03:05.841Z","view_time":null,"first_public_time":"$D2022-12-05T14:35:44.198Z","fork":{"id":"60275b92d793090f","slug":"advent-of-code-leaderboard-2022","title":"Advent of Code Leaderboard","owner":{"id":"31b136fdb993b00a","login":"visnup","name":"Visnu Pitiyanuvath"}},"stars":1,"starred":false,"owner":{"type":"team","id":"4ff2473e30507308","login":"neuefische","name":"neuefische","avatar_url":"https://avatars-next.observableusercontent.com/669a23b12b3bdb14785fd0fdbb5efd7839ed2f7be02489d7d59e0b604d1a562b","tier":"starter_2024"},"version":2234,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"30151ae41f7fc118","login":"terezaif","name":"Tereza Iofciu","avatar_url":"https://avatars-next.observableusercontent.com/226f3cb624f4054ae9dc13ea08fbbc3e6927e81037fb0558ac27d1b27bc1b384","tier":null}],"members":[{"type":"team","id":"4ff2473e30507308","login":"neuefische","name":"neuefische","avatar_url":"https://avatars-next.observableusercontent.com/669a23b12b3bdb14785fd0fdbb5efd7839ed2f7be02489d7d59e0b604d1a562b","tier":"starter_2024","role":"editor"},{"type":"individual","id":"30151ae41f7fc118","login":"terezaif","name":"Tereza Iofciu","avatar_url":"https://avatars-next.observableusercontent.com/226f3cb624f4054ae9dc13ea08fbbc3e6927e81037fb0558ac27d1b27bc1b384","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":true,"trashed":false,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"title":"Advent of Code Leaderboard","cells":[{"id":0,"value":"

Advent of Code Leaderboard

Neuefische leaderboard and Private leaderboards I’m a member of.

\n\n

\n Join ${owner.name}’s leaderboard:\n on the join form\n use code ${owner.code}.
\n If you want to see your own leaderboard, paste JSON into the textarea below.\n

","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined"},{"id":1073,"value":"viewof owner = Inputs.select(owners, {\n label: \"Leaderboard\",\n format: (d) => d.name,\n value: owners.find((d) => d.id == new URL(location.href).searchParams.get(\"id\"))\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":827,"value":"viewof year = Inputs.select([\"2022\", \"2021\", \"2020\", \"2019\", \"2018\", \"2017\"], { label: \"Year\" })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1556,"value":"Plot.plot({\n marks: [\n Plot.line(points, {\n z: \"name\",\n x: \"day\",\n y: \"rank\",\n stroke: \"name\",\n strokeWidth: 1,\n curve: \"monotone-x\"\n }),\n Plot.dot(points, {\n z: \"name\",\n x: \"day\",\n y: \"rank\",\n r: 2,\n fill: \"name\",\n stroke: \"white\",\n strokeWidth: 1,\n filter: (d) => !d.incomplete\n }),\n Plot.text(\n points,\n Plot.selectLast({\n z: \"name\",\n x: \"day\",\n y: \"rank\",\n text: \"name\",\n textAnchor: \"start\",\n dx: 5\n })\n )\n ],\n x: { domain: domains.days, tickFormat, label: null },\n y: { reverse: true, insetBottom: 10 },\n width,\n height: names.size * 16 + 50,\n marginLeft: 50,\n marginRight: 80\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":236,"value":"### Score per day\nScore each day by person.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":1814,"value":"viewof active = Inputs.checkbox([\"Only score active (won’t match official scoring, but reads better)\"])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":708,"value":"$30","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":406,"value":"### Points\nHow many points did people get / how did they place per day?","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":1398,"value":"Plot.plot({\n marks: [\n Plot.cell(\n pointsComplete,\n { y: \"name\", x: \"day\", fill: \"points\", fillOpacity: 0.6, inset: 0 }\n ),\n Plot.text(\n pointsComplete,\n { y: \"name\", x: \"day\", text: \"points\", fontSize: 7 }\n ),\n Plot.text(\n pointsComplete,\n Plot.selectLast({\n x: \"day\",\n y: \"name\",\n z: \"name\",\n text: \"name\",\n textAnchor: \"start\",\n dx: 12\n })\n )\n ],\n width,\n x: { domain: domains.days, tickFormat, label: null },\n y: { domain: names, label: null, axis: null },\n color: { reverse: true },\n marginLeft: 50,\n marginRight: 80\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":457,"value":"### Time splits\nHow long did people take to finish, as a delta from the leader each day?","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":1521,"value":"Plot.plot({\n marks: [\n Plot.cell(\n pointsComplete,\n {\n y: \"name\",\n x: \"day\",\n fill: \"minutes\",\n fillOpacity: 0.6,\n filter: (d) => d.minutes < 120,\n inset: 0\n }\n ),\n Plot.text(\n pointsComplete,\n {\n y: \"name\",\n x: \"day\",\n text: (d) => d.minutes >= 99 ? \"99+\" : d.minutes.toFixed(0),\n fillOpacity: (d) => d.minutes >= 99 ? 0.3 : 1,\n fontSize: 7\n }\n ),\n Plot.text(\n pointsComplete,\n Plot.selectLast({\n x: \"day\",\n y: \"name\",\n z: \"name\",\n text: \"name\",\n textAnchor: \"start\",\n dx: 12\n })\n )\n ],\n width,\n x: { domain: domains.days, tickFormat, label: null },\n y: { domain: names, axis: null },\n color: { domain: [0, 100] },\n marginLeft: 50,\n marginRight: 80\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":229,"value":"### Score over time\nScore by real time by person.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":1383,"value":"Plot.plot({\n marks: [\n Plot.line(\n points,\n Plot.map(\n { y: \"cumsum\" },\n {\n x: \"ts\",\n y: \"points\",\n stroke: \"name\",\n strokeWidth: 1,\n curve: \"monotone-y\",\n marker: true\n }\n )\n ),\n Plot.text(\n points,\n Plot.selectLast(\n Plot.map(\n { y: \"cumsum\" },\n {\n x: \"ts\",\n y: \"points\",\n z: \"name\",\n text: \"name\",\n textAnchor: \"start\",\n dx: 5\n }\n )\n )\n )\n ],\n width,\n height: names.size * 16 + 50,\n x: { type: \"time\", domain: domains.time },\n marginLeft: 50,\n marginRight: 80\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":2170,"value":"### Normalised absolute minutes per day for top 9 people\nMinutes ranging from ${d3.min(top10, d => d.abs_minutes)} minute to ${d3.format(\".0f\")(d3.max(top10, d => d.abs_minutes)/60)} hours","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":2095,"value":"Plot.plot({\n height: 600,\n grid: true,\n y: {\n axis: null\n },\n fy: {\n axis: \"right\",\n label: null\n },\n facet: {\n data: top10,\n y: \"lname\",\n marginRight: 100,\n sort: { fy: \"points\", reduce: \"max\" }\n },\n marks: [\n Plot.areaY(\n top10,\n Plot.normalizeY({\n basis: \"median\",\n x: \"day\",\n y: \"abs_minutes\",\n fillOpacity: 0.2,\n fill: \"green\"\n })\n ),\n Plot.lineY(\n top10,\n Plot.normalizeY({\n basis: \"median\",\n x: \"day\",\n y: \"abs_minutes\",\n strokeWidth: 1,\n stroke: \"red\"\n })\n )\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1946,"value":"---\n## Use your own JSON\nTo see your own leaderboard paste its JSON from the API below:","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":1931,"value":"viewof yours = Inputs.textarea({ placeholder: \"Paste your JSON here\" })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1332,"value":"---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":2069,"value":"select pc.name, day, abs_minutes, top.rank, concat(top.rank,'_',pc.name) as lname from pointsComplete pc\n inner join\n(select name, row_number() over (order by points desc) rank from \n (select name, sum(points) AS points from pointsComplete group by name) pts) as top on top.name = pc.name\nwhere top.rank < 10\n","pinned":false,"hidden":false,"mode":"sql","author":"$undefined","summary":"$undefined","output":"top10","database":"var:pointsComplete"},{"id":1899,"value":"owners = [\n { name: \"terezaif\", id: 65509, code: \"65509-b7b442f8\" },\n { name: \"ma-re\", id: 1015140 },\n { name: \"matthiaslein\", id: 1618761, code: \"1618761-d9d2b37a\" }\n]","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1465,"value":"names = new Set(\n Object.values(data.members)\n .filter((d) => d.stars)\n .sort((a, b) => b.local_score - a.local_score)\n .map((d) => d.name || d.id)\n)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":821,"value":"domains = ({\n score: [0, Object.keys(data.members).length * 25 * 2],\n days: d3\n .cross(d3.range(1, 26), d3.range(1, 3))\n .map(([d, s]) => [dayFormat(d), s].join(\",\")),\n time: [new Date(year, 11, 1), new Date(year, 11, 31)]\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1763,"value":"pointsComplete = points.filter((d) => !d.incomplete)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":2089,"value":"offset = 6 * 60","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":26,"value":"$31","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":11,"value":"days = {\n const days = {};\n for (const { id, name, completion_day_level } of Object.values(data.members)) {\n for (const [day, parts] of Object.entries(completion_day_level)) {\n for (const [part, { get_star_ts }] of Object.entries(parts)) {\n const key = [dayFormat(day), part];\n (days[key] = days[key] || []).push({\n name: name || id,\n ts: new Date(get_star_ts * 1000)\n });\n }\n }\n }\n return days;\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1781,"value":"Get CORS-friendly leaderboard data while hiding session token via a proxy. Code at https://github.com/visnup/aoc-leaderboard.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":4,"value":"data = yours\n ? JSON.parse(yours)\n : fetch(\n `https://aoc-leaderboard-pi.vercel.app/api?year=${year}&id=${owner.id}`\n ).then((res) => res.json())","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":419,"value":"md`---`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1635,"value":"tickFormat = (d) => (d.includes(\",2\") ? null : d.split(\",\")[0].trim())","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":370,"value":"dayFormat = d3.format('2d')","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"}],"files":"$W32","stdlib":"1","titling":"auto"}} 2f:"$2e:body"