31:T68a,32:T5bb,hexPlot = () => Plot.plot({ height: 700, width: width, x: { nice: true, axis: "top", tickRotate: width < 800 ? 90 : 0 }, y: { grid: true, label: "← Under · Over →", labelAnchor: "center", ticks: false, tickFormat: Math.abs }, tooltip: { stroke: "black" }, marks: [ Plot.hexagon( allPicksMerged, Plot.stackY2({ x: (d) => d.Team, r: (d) => d.lock, opacity: (d) => highlightPerson === "-- --" ? 1 : d.Name === highlightPerson ? 1 : 0.2, y: (d) => d.over_under === "over" ? 1 : d.over_under === "under" ? -1 : 0, fill: (d) => d["over_under"], title: (d) => ` ${d.Name} \n ${d.over_under} :${d.lock}` }) ), // Plot.text( // allPicksMerged, // Plot.stackY2({ // text: (d) => (d.lock > 1 ? d.lock : ""), // x: (d) => d.Team, // r: (d) => d.lock, // opacity: (d) => // highlightPerson === "-- --" // ? 1 // : d.Name === highlightPerson // ? 1 // : 0.2, // y: (d) => // d.over_under === "over" ? 1 : d.over_under === "under" ? -1 : 0, // fill: "white", // title: (d) => ` ${d.Name}` // }) // ), Plot.ruleY([0]) ] })33:T5c9,function plotTeamDotPlot(data = all_data) { return Plot.plot({ width: width, y: { domain: d3 .sort(data, (d) => (!sort ? -d["W/L%"] : -d["target_games"])) .map((d) => d.team), grid: true }, x: { grid: true }, color: { range: [dotColors[1], dotColors[0]], domain: ["HIT", "MISS"], legend: true }, tooltip: { stroke: "black" }, marginLeft: 150, marks: [ Plot.link(data_merged, { x1: "target_games", y1: "team", x2: "W", y2: "team", strokeWidth: (d) => d.lock * 2, stroke: (d) => { return didHit(d) > 0 ? "HIT" : "MISS"; } }), Plot.tickX(data_merged, { strokeWidth: 5, stroke: (d) => { return didHit(d) > 0 ? "HIT" : "MISS"; }, // stroke: "black", y: "team", x: "W" }), Plot.tickX(data_merged, { x: "target_games", y: "team", strokeWidth: 5 // stroke: (d) => { // return didHit(d) > 0 ? "HIT" : "MISS"; // } }), Plot.barX(data_merged, { x1: "W", width: 20, fill: "transparent", y: "team", x2: "target_games", title: (d) => ` ${d.team} \n Over/Under Line: ${d.target_games}\n TOTAL WINS: ${d.W} \n TOTAL LOSSES: ${d.L} \n \n What did I pick? ${d.over_under} \n Lock amount: ${d.lock}` }) ] }); }34:[] 2f:{"title":"NBA over/under pool (2022-2023) Final Scores","cells":[{"id":4,"value":"# NBA over/under pool (2022-2023) Final Scores\nCongratulations to our winners this year.\n\n1) Matt Belcher\n2) Joel Haber\n3) Casey Haber\n\nLast place goes to..... Michael Tringali\n\nFeel free to double check you scores here https://docs.google.com/spreadsheets/d/10TauSNge688uN9kAKtNvJfSYtcydiurs31iSbP4ZXRk/edit?usp=sharing","pinned":false,"hidden":false,"mode":"md"},{"id":843,"value":"Plot.plot({\n width: 400,\n marginLeft: 110,\n marginTop: -10,\n y: {\n domain: d3.sort(all_totals, (d) => -d.total).map((d) => d.name)\n },\n marks: [\n Plot.barX(all_totals, {\n fill: \"steelblue\",\n y: \"name\",\n x: \"total\"\n }),\n Plot.textX(all_totals, {\n fill: \"black\",\n dx: 10,\n y: \"name\",\n x: \"total\",\n text: \"total\"\n })\n ]\n})\n","pinned":false,"hidden":false,"mode":"ojs"},{"id":274,"value":"## Total points: ${calculateTotal(rawOvers)} / 56","pinned":false,"hidden":false,"mode":"md"},{"id":367,"value":"$31","pinned":false,"hidden":false,"mode":"html"},{"id":724,"value":"viewof person = Inputs.select(keys.sort(), {\n label: \"Select a person's predictions\",\n value: urlParam\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":293,"value":"dotPlot = plotTeamDotPlot()","pinned":false,"hidden":false,"mode":"ojs"},{"id":1033,"value":"viewof sort = Inputs.toggle({ label: \"Sort by O/U amount \", value: true })","pinned":false,"hidden":false,"mode":"ojs"},{"id":1101,"value":"## Everyone's Picks","pinned":false,"hidden":false,"mode":"md"},{"id":1088,"value":"colorLegend","pinned":false,"hidden":false,"mode":"ojs"},{"id":1065,"value":"heatMapPicks(highlightPerson)","pinned":false,"hidden":false,"mode":"ojs"},{"id":1108,"value":"viewof highlightPerson = Inputs.select(highlightKeys.sort(), {\n label: \"See someone's picks\"\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1190,"value":"scheduleTableGames(todaysGames, everyoneDict[person])","pinned":false,"hidden":false,"mode":"ojs"},{"id":1272,"value":"viewof d1 = date({ value: d3.timeFormat(\"%Y-%m-%d\")(new Date()) })","pinned":false,"hidden":false,"mode":"ojs"},{"id":827,"value":"## Appendix","pinned":false,"hidden":false,"mode":"md"},{"id":1149,"value":"This [github repo](https://github.com/caHaber/flat-data-nba-standings) scrapes the standings data from [Basketball Reference](https://www.basketball-reference.com/leagues/NBA_2022_standings.html) daily. ","pinned":false,"hidden":false,"mode":"md"},{"id":1257,"value":"$32","pinned":false,"hidden":false,"mode":"ojs"},{"id":286,"value":"$33","pinned":false,"hidden":false,"mode":"ojs"},{"id":5,"value":"function plotTeamBarChart(data = data_merged) {\n return Plot.plot({\n width: width,\n y: {\n domain: d3.sort(data, (d) => -d[\"W/L%\"]).map((d) => d.team)\n },\n x: {\n domain: [0, 1],\n grid: true\n },\n color: {\n domain: [\"over\", \"under\"],\n legend: true\n },\n tooltip: {\n stroke: \"black\"\n },\n marginLeft: 150,\n marks: [\n Plot.barX(data, {\n fill: \"skyblue\",\n y: \"team\",\n x: \"W/L%\",\n title: (d) =>\n `${d.team} \\n Over or Under: ${d.over_under} \\n Lock amount: ${\n d.lock\n } \\n Difference in W/L %: ${parseFloat(\n d.target_percent - d[\"W/L%\"]\n ).toFixed(3)}`\n }),\n Plot.dotX(data_merged, {\n y: \"team\",\n fill: \"over_under\",\n r: \"lock\",\n x: \"target_percent\"\n })\n ]\n });\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":310,"value":"function didHit(d) {\n console.log(d);\n if (d.over_under === \"over\" && d.target_games < d[\"W\"]) return d.lock;\n if (d.over_under === \"under\" && d.target_games > d[\"W\"]) return d.lock;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":747,"value":"function calculateTotal(datum) {\n const merged = d3\n .sort(all_data, (d) => d.team)\n .map((d, i) => {\n // d.target_percent = parseFloat(datum[0][datum.columns[i]]) / 82;\n d.target_games = parseFloat(datum[0][datum.columns[i]]);\n d.over_under = datum[1][datum.columns[i]] === \"o\" ? \"over\" : \"under\";\n d.lock = +datum[3][datum.columns[i]];\n return d;\n });\n return d3.sum(merged, (d) => {\n return didHit(d);\n });\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":1288,"value":"param = new URLSearchParams(location.search)","pinned":false,"hidden":false,"mode":"ojs"},{"id":1275,"value":"urlParam = param.get(\"name\") ? param.get(\"name\").replaceAll(\"-\", \" \") : null","pinned":false,"hidden":false,"mode":"ojs"},{"id":530,"value":"","pinned":false,"hidden":false,"mode":"html"},{"id":1298,"value":"singleDay = {\n const d = d3.timeParse(\"%Y-%m-%d\")(d1).toString().split(\" \").slice(0, 4);\n if (d[2].split(\"\")[0] === \"0\") {\n d[2] = d[2].split(\"\")[1];\n }\n return d.join(\" \");\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":1271,"value":"todaysGames = getGames(\n singleDay,\n d3.timeParse(\"%Y-%m-%d\")(d1).toString().split(\" \")[1]\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":1168,"value":"allPicksMerged = {\n let arr = [];\n keys.forEach((key) => {\n const x = mergePicksWithOvers(everyoneDict[key]);\n arr.push(x);\n });\n // arr = arr.sort((a, b ) => a[0][0].Name )\n // return arr;\n var sorted = arr.flat().sort((a, b) => {\n if (highlightPerson !== \"-- --\") {\n return a.Name === highlightPerson\n ? -1\n : b.Name === highlightPerson\n ? 1\n : b.lock - a.lock;\n }\n return b.lock - a.lock;\n });\n return sorted;\n // return picks.map((d) => mergePicksWithOvers(d));\n // .map((d) => mergePicksWithOvers(d[1]))\n // .flat();\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":859,"value":"all_totals = keys.map((d) => {\n return { name: d, total: calculateTotal(everyoneDict[d]) };\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":127,"value":"rawOvers = {\n const x = everyoneDict[person];\n return x;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":150,"value":"data_merged = mergePicksWithOvers(rawOvers)","pinned":false,"hidden":false,"mode":"ojs"},{"id":1165,"value":"mergePicksWithOvers = (singlePicks) => {\n return d3\n .sort(all_data, (d) => d.team)\n .map((d, i) => {\n const c = { ...d };\n c.Name = singlePicks[1].Name;\n c.target_percent = parseFloat(singlePicks[0][columns[i]]) / 82;\n c.target_games = parseFloat(singlePicks[0][columns[i]]);\n c.Team = columns[i];\n c.over_under = singlePicks[1][columns[i]] === \"o\" ? \"over\" : \"under\";\n c.lock = +singlePicks[3][columns[i]];\n c.projected_wins = d[\"W/L%\"] * 82;\n c[\"W\"] = +d[\"W\"];\n return c;\n });\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":129,"value":"all_data = [...west_data, ...east_data]","pinned":false,"hidden":false,"mode":"ojs"},{"id":1235,"value":"WEST_RAW = d3.csv(\n \"https://raw.githubusercontent.com/caHaber/flat-data-nba-standings/master/WEST_standings.csv\",\n {\n \"Cache-Control\": \"no-cache\"\n }\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":1241,"value":"EAST_RAW = d3.csv(\n \"https://raw.githubusercontent.com/caHaber/flat-data-nba-standings/master/EAST_standings.csv\",\n {\n \"Cache-Control\": \"no-cache\"\n }\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":107,"value":"west_data = parseRawStandings(WEST_RAW, \"Western Conference\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":57,"value":"east_data = parseRawStandings(EAST_RAW, \"Eastern Conference\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":96,"value":"function parseRawStandings(data, conference) {\n data.map((d) => {\n d.team = d[conference];\n d[\"W/L%\"] = +d[\"W/L%\"];\n return d;\n });\n return data;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":1217,"value":"dotColors = [d3.schemeSet1[0], d3.schemeSet1[2]]","pinned":false,"hidden":false,"mode":"ojs"},{"id":221,"value":"import { Plot } from \"@cahaber/plot-tooltip\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":1086,"value":"import {\n heatMapPicks,\n highlightKeys,\n colorLegend\n} from \"@cahaber/over-under-22-23-picks\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":931,"value":"import {\n rawEveryone,\n keys,\n everyoneDict,\n columns\n} from \"@cahaber/nba-over-under-shared-components\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":1188,"value":"import {\n scheduleTableGames,\n getGames\n} from \"@cahaber/nba-over-under-who-are-you-rooting-for\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":1268,"value":"import { date } from \"@jashkenas/inputs\"","pinned":false,"hidden":false,"mode":"ojs"}],"files":"$W34","stdlib":"1","titling":"auto"}