31:T535,32:T508,function plotTeamDotPlot(data = all_data) { return Plot.plot({ width: width, y: { domain: d3.sort(data, (d) => -d["W/L%"]).map((d) => d.team), grid: true }, x: { grid: true }, color: { range: ["green", "red"], 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.dotX(data_merged, { fill: "black", r: 3, y: "team", x: "W" }), Plot.dotX(data_merged, { y: "team", stroke: "black", shape: "square", fill: "white", r: 3, x: "target_games" }), 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}` }) ] }); }33:[{"id":"b753f01bdf6235908bb56a7238673c76326ce9ba63ca3dba93d9650673491c7fd0dc60cab958bb3f67cc28a7762c3b9b4dc7f0edf8e52dcb4d0c12b0673269b9","href":"https://static.observableusercontent.com/files/b753f01bdf6235908bb56a7238673c76326ce9ba63ca3dba93d9650673491c7fd0dc60cab958bb3f67cc28a7762c3b9b4dc7f0edf8e52dcb4d0c12b0673269b9","name":"casey_standings.csv","type":"text/csv","lastModified":1641587953233.595,"size":423},{"id":"d11e6ebfab2a7dca704adbe46ea6f67f3db6106c2d0d7dce4390a20904b7325925ee913b47b5381d389c3120d673f52f5957f1df2c87a9c82d7fbb284cbb89b0","href":"https://static.observableusercontent.com/files/d11e6ebfab2a7dca704adbe46ea6f67f3db6106c2d0d7dce4390a20904b7325925ee913b47b5381d389c3120d673f52f5957f1df2c87a9c82d7fbb284cbb89b0","name":"NBA O_U Pool (2021-22) - Picks (1).csv","type":"text/csv","lastModified":1641588065818.566,"size":3731}] 2f:{"title":"NBA over/under updated daily (ENTIRE POOL)","cells":[{"id":4,"value":"# NBA over/under updated daily (ENTIRE POOL)\n\nNBA live standings data is scraped from basketball-reference. 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":724,"value":"viewof rawPrediction = Inputs.select(keys, {\n label: \"Select someones predictions\"\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":274,"value":"## Projected points: ${total_points} / 56","pinned":false,"hidden":false,"mode":"md"},{"id":367,"value":"$31","pinned":false,"hidden":false,"mode":"html"},{"id":293,"value":"dotPlot = plotTeamDotPlot()","pinned":false,"hidden":false,"mode":"ojs"},{"id":515,"value":"Inputs.table(rawOvers)","pinned":false,"hidden":false,"mode":"ojs"},{"id":752,"value":"# All totals","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})","pinned":false,"hidden":false,"mode":"ojs"},{"id":827,"value":"## Appendix","pinned":false,"hidden":false,"mode":"md"},{"id":859,"value":"all_totals = keys.map((d) => {\n return { name: d, total: calculateTotal(everyoneDict[d]) };\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":687,"value":"rawEveryone = FileAttachment(\"NBA O_U Pool (2021-22) - Picks (1).csv\").csv()","pinned":false,"hidden":false,"mode":"ojs"},{"id":691,"value":"everyoneDict = {\n const dict = {};\n for (var i = 1; i < rawEveryone.length; i += 3) {\n if (rawEveryone[i][\"\"] !== \"\") {\n dict[rawEveryone[i][\"\"]] = [\n rawEveryone[0],\n rawEveryone[i],\n rawEveryone[i + 1],\n rawEveryone[i + 2]\n ];\n dict[rawEveryone[i][\"\"]].columns = file.columns;\n }\n }\n return dict;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":719,"value":"keys = Object.keys(everyoneDict)","pinned":false,"hidden":false,"mode":"ojs"},{"id":286,"value":"$32","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 range: [\"green\", \"red\"],\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":763,"value":"calculateTotal(rawOvers)","pinned":false,"hidden":false,"mode":"ojs"},{"id":310,"value":"function didHit(d) {\n if (d.over_under === \"over\" && d.target_percent < d[\"W/L%\"]) return d.lock;\n if (d.over_under === \"under\" && d.target_percent > d[\"W/L%\"]) 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 if (d.over_under === \"over\" && d.target_percent < d[\"W/L%\"]) return d.lock;\n if (d.over_under === \"under\" && d.target_percent > d[\"W/L%\"]) return d.lock;\n });\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":262,"value":"total_points = calculateTotal(rawOvers)","pinned":false,"hidden":false,"mode":"ojs"},{"id":246,"value":"file = {\n return FileAttachment(\"casey_standings.csv\").csv();\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":530,"value":"","pinned":false,"hidden":false,"mode":"html"},{"id":127,"value":"rawOvers = {\n const x = everyoneDict[rawPrediction];\n x.columns = file.columns;\n return x;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":737,"value":"file","pinned":false,"hidden":false,"mode":"ojs"},{"id":150,"value":"data_merged = d3\n .sort(all_data, (d) => d.team)\n .map((d, i) => {\n d.target_percent = parseFloat(rawOvers[0][rawOvers.columns[i]]) / 82;\n d.target_games = parseFloat(rawOvers[0][rawOvers.columns[i]]);\n d.over_under = rawOvers[1][rawOvers.columns[i]] === \"o\" ? \"over\" : \"under\";\n d.lock = +rawOvers[3][rawOvers.columns[i]];\n return d;\n })","pinned":false,"hidden":false,"mode":"ojs"},{"id":129,"value":"all_data = [...west_data, ...east_data]","pinned":false,"hidden":false,"mode":"ojs"},{"id":23,"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":27,"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":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":221,"value":"import { Plot } from \"@mkfreeman/plot-tooltip\"","pinned":false,"hidden":false,"mode":"ojs"}],"files":"$W33","stdlib":"1","titling":"auto"}