44:["$","title",null,{"children":"Black Canyon Ultras | Benjamin Wiederkehr | Observable"}] 4c:T4cd,finishingTimesByGenderPlaceF = Plot.plot({ width, height: 600, grid: true, color: { legend: true, ...getColorConfig("year") }, y: { data: filteredFinishers, domain: [1, d3.max(allFinishers.filter(d=> d.gender === finishingTimeByGenderPlaceGender).map(d => d.gender_place))], reverse: true, type: "log", label: "↓ Gender Place" }, x: { axis: "top", label: "Hours →", data: filteredFinishers, domain: d3.extent(allFinishers.filter(d=> d.gender === finishingTimeByGenderPlaceGender).map((d) => d.hours)) }, marks: [ Plot.ruleY([3, 10, 20, 50, 100, 500], {strokeOpacity: 0.2}), Plot.line(filteredFinishers.filter(d=> d.gender === finishingTimeByGenderPlaceGender), { x: "hours", y: "gender_place", stroke: "year", strokeWidth: 4, curve: "linear", }), Plot.dot(filteredFinishers.filter(d=> d.gender === finishingTimeByGenderPlaceGender), { x: "hours", y: "gender_place", fill: "year", stroke: "#FFFFFF", strokeWidth: 0.5, title: d=> getParticipantTitle(d), r: 4, }) ], tooltip: { fill: "current-color", stroke: "#000", "stroke-width": "2px", r: 8, } })4d:[] 48:{"id":"4e1489dad522219b","slug":"black-canyon-ultras","title":"Black Canyon Ultras","thumbnail":"aad25fab10a0ca44e512c18e5583453324843f0730ef7b731601c0d329165f3c","access_level":"public","create_time":"$D2022-11-06T19:14:30.125Z","update_time":"$D2022-11-18T01:02:11.634Z","view_time":null,"first_public_time":"$D2022-11-06T19:14:30.125Z","has_unpublished_edits":null,"fork":{"id":"c91c26400d1b120c","slug":"how-fast-to-podium-data","title":"How Fast To Podium? Data","owner":{"id":"7d04db8988659721","login":"wiederkehra","name":"Anna Wiederkehr"}},"stars":0,"starred":false,"owner":{"type":"team","id":"bb234bc618cbaf28","login":"wiederkehr","name":"Benjamin Wiederkehr","avatar_url":"https://avatars-next.observableusercontent.com/f3dc4fbdea9cafc8095cdfc0a88577957a1caff8850093984e6c971fa3bf4e94","tier":"starter_2024","bio":"Swiss Interaction Designer, co-founder and director of Interactive Things.","followed_by_you":false,"follows_you":false},"version":2540,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"65bbb4bedd0301ab","login":"wiederkehr","name":"Benjamin Wiederkehr","avatar_url":"https://avatars-next.observableusercontent.com/f3dc4fbdea9cafc8095cdfc0a88577957a1caff8850093984e6c971fa3bf4e94","tier":null,"bio":"Swiss Interaction Designer, co-founder and director of Interactive Things.","followed_by_you":false,"follows_you":false}],"members":[{"type":"individual","id":"65bbb4bedd0301ab","login":"wiederkehr","name":"Benjamin Wiederkehr","avatar_url":"https://avatars-next.observableusercontent.com/f3dc4fbdea9cafc8095cdfc0a88577957a1caff8850093984e6c971fa3bf4e94","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":true,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"titling":"auto","title":"Black Canyon Ultras","cells":[{"id":0,"value":"# Black Canyon Ultras\nThe [Black Canyon Ultras](https://aravaiparunning.com/network/blackcanyon/) are 100K and 60K point-to-point trail races along the Black Canyon National Recreation Trail in Arizona, USA. The race is organized by organized by [Aravaipa Running](https://www.aravaiparunning.com/) and has become a staple on the ultra running calendar. One of the reasons for this might be that the 100K race is a qualifier for the [Western States Endurance Run](https://www.wser.org/) and the top two female and male finishers win direct entry (Golden Tickets) to one of the most prestigious ultra races in the USA. \n\nThis document provides visual tools to explore and analyze the results of the 100K race over the past 9 years. It all started with my own curiosity about the race that I’ll run for the first time in February 2023. Hopefully, this is helpful to others as well.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":892,"value":"toc({selector: \"h2,h3,h4,h5,h6\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":909,"value":"---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1083,"value":"## Configuration\nThis documents includes the results from all years since the first edition in 2014. But not all installments of the race took place on the original course. If you’re only interested in the original course or if you want to analyze one specific year, filter the years with the dropdown below.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":609,"value":"viewof year = Inputs.select([...presets, ...events.map(d => d.year)], {label: \"Select years\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1091,"value":"---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":546,"value":"## Participant Overview\nLet’s start with a colorful overview of all participants over the years ordered by their finishing time. We can see how many people push themselves to finish below the 17 hour mark — the time limit to qualify for the Western States lottery.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1267,"value":"viewof participantColoryBy = Inputs.select(new Map([[\"Year\", \"year\"], [\"Gender\", \"gender\"], [\"Age Group\", \"age_group\"], [\"Age\", \"age\"], [\"Place\", \"place\"], [\"Gender Place\", \"gender_place\"]]), {label: \"Color by\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1504,"value":"participantScatterplot = Plot.plot({\n width,\n height: 800,\n grid: true,\n color: {\n legend: true,\n label: convertAttributeToLabel(participantColoryBy),\n ...getColorConfig(participantColoryBy)\n },\n x : {\n axis: \"top\",\n label: \"Hours →\",\n },\n marks: [\n Plot.dotX(filteredFinishers, Plot.dodgeY({anchor: \"middle\", x: \"hours\", r: 4, fill: participantColoryBy, title: d=> getParticipantTitle(d)}))\n ],\n tooltip: {\n fill: \"current-color\",\n stroke: \"#000\",\n \"stroke-width\": \"2px\",\n r: 8\n }\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1204,"value":"---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":832,"value":"## Participant Demographics\nNext, let’s look at the demographic breakdown of the participants. Below you’d find the distribution of the participants across gender, age group, and age. Change the dropdown just below to switch from percentages to absolute values to see the increase in participant numbers over the years.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":860,"value":"viewof demographicDistribution = Inputs.select([\"Proportion\", \"Absolute\"], {label: \"Change distribution\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":974,"value":"### Gender Distribution","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":773,"value":"genderDistribution = Plot.plot({\n width,\n grid: true,\n color: {\n legend: true,\n ...getColorConfig(\"gender\")\n },\n x: {\n axis: \"top\",\n label: demographicDistribution === \"Absolute\" ? \"Participants →\" : \"Participants (%) →\",\n percent: demographicDistribution === \"Absolute\" ? false : true\n },\n facet: {\n data: filteredResults,\n y: \"year\",\n label: \"\",\n },\n marks: [\n Plot.barX(filteredResults, Plot.stackX(Plot.groupZ({x: demographicDistribution === \"Absolute\" ? \"count\" : \"proportion-facet\"}, {fill: \"gender\", insetLeft: 1, title: d => getDistributionTitle(d, \"gender\")}))),\n ],\n tooltip: {\n fill: \"current-color\",\n stroke: \"#000\",\n \"stroke-width\": \"2px\",\n }\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1761,"value":"### Age Group Distribution","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":980,"value":"ageGroupDistribution = Plot.plot({\n width,\n grid: true,\n color: {\n legend: true,\n ...getColorConfig(\"age_group\")\n },\n x: {\n axis: \"top\",\n label: demographicDistribution === \"Absolute\" ? \"Participants →\" : \"Participants (%) →\",\n percent: demographicDistribution === \"Absolute\" ? false : true\n },\n facet: {\n data: filteredResults,\n y: \"year\",\n label: \"\",\n },\n marks: [\n Plot.barX(filteredResults, Plot.stackX(Plot.groupZ({x: demographicDistribution === \"Absolute\" ? \"count\" : \"proportion-facet\"}, {fill: \"age_group\", insetLeft: 1, title: d => getDistributionTitle(d, \"age_group\")}))),\n ],\n tooltip: {\n fill: \"current-color\",\n stroke: \"#000\",\n \"stroke-width\": \"2px\",\n }\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":983,"value":"### Age Distribution","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1646,"value":"ageDistribution = Plot.plot({\n width,\n grid: true,\n color: {\n legend: true,\n nice: true,\n ...getColorConfig(\"age\"),\n label: \"Age\"\n },\n x: {\n axis: \"top\",\n label: demographicDistribution === \"Absolute\" ? \"Participants →\" : \"Participants (%) →\",\n percent: demographicDistribution === \"Absolute\" ? false : true\n },\n facet: {\n data: filteredResults,\n y: \"year\",\n label: \"\",\n },\n marks: [\n Plot.barX(filteredResults, Plot.stackX(Plot.groupZ({x: demographicDistribution === \"Absolute\" ? \"count\" : \"proportion-facet\"}, {fill: \"age\", insetLeft: 1, title: d => getDistributionTitle(d, \"age\")}))),\n ],\n tooltip: {\n fill: \"current-color\",\n stroke: \"#000\",\n \"stroke-width\": \"2px\",\n }\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":989,"value":"---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":916,"value":"## Finishing Times\nNow that we know who the participants are, it’s time to look more closely into their performances. The first two charts show the chain of runners that cross the finish line. The charts are separated into a ranking of the overall place and gender place. Below, you’ll find an analysis of the distribution of finishing times by years and demographics. When looking at these charts, be mindful that not all races are run on the original course and therefore the finish times might not be directly comparable. For example, 2019 was a reroute with faster finishing times on average.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":544,"value":"### Finishing Times by Overall Place","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":459,"value":"finishingTimesByPlace = Plot.plot({\n width,\n height: 800,\n grid: true,\n color: {\n legend: true,\n ...getColorConfig(\"year\")\n },\n y: {\n data: filteredFinishers,\n domain: [1, d3.max(allFinishers.map(d => d.place))],\n reverse: true,\n type: \"log\",\n label: \"↓ Place\",\n },\n x: {\n axis: \"top\",\n label: \"Hours →\",\n data: filteredFinishers,\n domain: [d3.min(allFinishers.map((d) => d.hours)), d3.max(allFinishers.map((d) => d.hours))]\n },\n marks: [\n Plot.ruleY([3, 10, 20, 50, 100, 500], {strokeOpacity: 0.2}),\n Plot.line(filteredFinishers, {\n x: \"hours\",\n y: \"place\",\n stroke: \"year\",\n strokeWidth: 4,\n curve: \"linear\",\n }),\n Plot.dot(filteredFinishers, {\n x: \"hours\",\n y: \"place\",\n fill: \"year\",\n stroke: \"#FFFFFF\",\n strokeWidth: 0.5,\n title: d=> getParticipantTitle(d),\n r: 4,\n })\n ],\n tooltip: {\n fill: \"current-color\",\n stroke: \"#000\",\n \"stroke-width\": \"2px\",\n r: 8,\n }\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1598,"value":"### Finishing Times by Gender Place","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1606,"value":"viewof finishingTimeByGenderPlaceGender = Inputs.select(new Map([[\"Female\", \"F\"], [\"Male\", \"M\"]]), {label: \"Select gender\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1596,"value":"$4c","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":956,"value":"### Finishing Times by Year","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":959,"value":"finishingTimesByYear = Plot.plot({\n width,\n height: _.uniqBy(filteredResults, d => d.year).length * 100,\n color: {\n legend: true,\n ...getColorConfig(\"year\")\n },\n grid: true,\n x: {\n axis: \"top\",\n label: \"Hours →\",\n },\n y: {\n label: \"↑ Participants\"\n },\n facet: {\n data: filteredFinishers,\n y: \"year\",\n label: \"\",\n },\n marks: [\n Plot.rectY(filteredFinishers, Plot.binX({y: \"count\"}, {x: \"hours\", fill: \"year\", title: d => getDistributionTitle(d, \"hours\")})),\n Plot.ruleY([0])\n ],\n tooltip: {\n fill: \"current-color\",\n stroke: \"#000\",\n \"stroke-width\": \"2px\",\n }\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":548,"value":"### Finishing Times by Gender","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":561,"value":"finishingTimesByGender = Plot.plot({\n width,\n height: 200,\n grid: true,\n color: {\n legend: true,\n ...getColorConfig(\"gender\")\n },\n x: {\n axis: \"top\",\n label: \"Hours →\",\n },\n y: {\n label: \"↑ Participants\",\n },\n facet: {\n data: filteredFinishers,\n y: \"gender\",\n label: \"\",\n },\n marks: [\n Plot.rectY(filteredFinishers, Plot.binX({y: \"count\"}, {x: \"hours\", fill: \"gender\", title: d => getDistributionTitle(d, \"hours\")})),\n Plot.ruleY([0])\n ],\n tooltip: {\n fill: \"current-color\",\n stroke: \"#000\",\n \"stroke-width\": \"2px\",\n }\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":675,"value":"### Finishing Times by Age","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":670,"value":"finishingTimesByAge = Plot.plot({\n width,\n height: 700,\n grid: true,\n color: {\n legend: true,\n ...getColorConfig(\"age_group\")\n },\n x: {\n axis: \"top\",\n label: \"Hours →\",\n },\n y: {\n label: \"↑ Participants\",\n },\n facet: {\n data: filteredFinishers,\n y: \"age_group\",\n label: \"\",\n },\n marks: [\n Plot.rectY(filteredFinishers, Plot.binX({y: \"count\"}, {x: \"hours\", fill: \"age_group\", title: d => getDistributionTitle(d, \"hours\")})),\n Plot.ruleY([0])\n ],\n tooltip: {\n fill: \"current-color\",\n stroke: \"#000\",\n \"stroke-width\": \"2px\",\n }\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":688,"value":"---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":684,"value":"## Performance Analysis\nFor many of us in ultra running, outcomes are less important than the process. Still, this is a challenging race with high stakes (Golden Ticket for WSER, anyone?). People push themselves to perform at their very best. This effort can be rewarded with a high ranking like a podium or top 10 finish. But pushing yourself over the edge might also result in the dreaded DNF (Did Not Finish) or even DNS (Did Not Start).","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":992,"value":"### Top Placements","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":692,"value":"viewof placementInput = Inputs.select(new Map([[\"Female Podium\", \"F-3\"], [\"Female Top 10\", \"F-10\"],[\"Male Podium\", \"M-3\"], [\"Male Top 10\", \"M-10\"]]), {label: \"Select placement\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":690,"value":"topPlacementsPerYear = Plot.plot({\n width,\n grid: true,\n color: {\n ...getColorConfig(\"year\")\n },\n facet: {\n data: placementResults,\n y: \"year\",\n label: null,\n },\n x: {\n axis: \"top\",\n label: \"Hours →\",\n },\n y: {\n label: \"\",\n },\n marks: [\n Plot.barX(placementResults, {x: \"hours\", y: \"gender_place\", fill: \"transparent\", sort: {y: \"x\"}}),\n Plot.dot(placementResults, {x: \"hours\", y: \"gender_place\", r: 4, fill: \"year\", sort: {y: \"x\"}, title: d=> getParticipantTitle(d)}),\n Plot.ruleY(placementResults, {x: \"hours\", y: \"gender_place\", stroke: \"year\", strokeWidth: 3, sort: {y: \"x\"}}),\n ],\n tooltip: {\n fill: \"current-color\",\n stroke: \"#000\",\n \"stroke-width\": \"2px\",\n r: 8,\n }\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":771,"value":"### Outcome Distribution","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":851,"value":"viewof performanceDistribution = Inputs.select([\"Proportion\", \"Absolute\"], {label: \"Change distribution\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":835,"value":"statusDistribution = Plot.plot({\n width,\n grid: true,\n color: {\n legend: true,\n ...getColorConfig(\"status\"),\n },\n x: {\n axis: \"top\",\n percent: performanceDistribution === \"Absolute\" ? false : true,\n label: performanceDistribution === \"Absolute\" ? \"Participants →\" : \"Participants (%) →\",\n },\n facet: {\n data: allResults,\n y: \"year\",\n label: \"\",\n },\n marks: [\n Plot.barX(allResults, Plot.stackX(Plot.groupZ({x: performanceDistribution === \"Absolute\" ? \"count\" : \"proportion-facet\"}, {fill: \"status\", insetLeft: 1, order: [\"Finished\", \"DNF\", \"DNS\"], title: d => getDistributionTitle(d, \"status\")})))\n ],\n tooltip: {\n fill: \"current-color\",\n stroke: \"#000\",\n \"stroke-width\": \"2px\",\n }\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1659,"value":"---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1657,"value":"## Performance Projection\nHyped about the race and ready to jump in yourself? Godspeed! With the following two tools, you can guesstimate your likely place if you already know your target time or you can calculate what it takes to place in certain percentage of the field of participants. Please note, these are not reliable predictions and should be taken with a big salt tablet.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1661,"value":"### If I finish in _x_ hours, where will I place?\nPlease note, we’re using the last 3 years on the original course and the median place of all finishers within a 20 minute window to calculate the projected place.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":2060,"value":"Based on the last 3 years and under the assumption that the next race will have a similar number of participants with similar performances, you might likely place somewhere between ${getHTP(HTPInput)[0]} – ${getHTP(HTPInput)[2]} if you finish within ${HTPInput} hours.","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1666,"value":"viewof HTPInput = Inputs.range([Math.floor(d3.min(allFinishers, d => d.hours)), 20], {step: 0.25, value: 12, label: \"Target time (hours)\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1709,"value":"HTPChart = Plot.plot({\n width,\n height: 400,\n x: {\n axis: \"top\",\n label: \"Hours →\",\n domain: [7, 20]\n },\n y: {\n label: \"↓ Place\",\n reverse: true,\n type: \"log\",\n },\n marks: [\n Plot.ruleY([3, 10, 20, 50, 100, 500], {strokeOpacity: 0.1}),\n Plot.lineY(originalFinishers, {x: \"hours\", y: \"place\", z: \"year\", strokeOpacity: 0.25, strokeWidth: 1}),\n Plot.ruleX([1], {x: HTPInput, stroke: categoryColors[2], strokeWidth: 1, strokeOpacity: 0.5}),\n Plot.ruleY(getHTP(HTPInput), {stroke: categoryColors[2], strokeWidth: 1, strokeOpacity: 0.5}),\n Plot.dot(getHTP(HTPInput), {x: HTPInput, y: d => d, r: 3, fill: categoryColors[2]}),\n Plot.ruleX([{min: getHTP(HTPInput)[0], max: getHTP(HTPInput)[2]}], {x: HTPInput, y1: \"min\", y2: \"max\", stroke: categoryColors[2], strokeWidth: 2}),\n Plot.text(getHTP(HTPInput), {x: HTPInput + 0.1, y: d => d, textAnchor: \"start\", fontWeight: \"bold\"}),\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1663,"value":"### If I want to place in the top _x_ percent, how fast will I have to finish?","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":2408,"value":"Based on the last 3 years and under the assumption that the next race will have a similar number of participants with similar performances, you will have to finish within ${getPTH(PTHInput)[0]} – ${getPTH(PTHInput)[1]} hours to likely be in the top ${PTHInput}% of participants.","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1670,"value":"viewof PTHInput = Inputs.range([1, 100], {step: 1, value: 0.5, label: \"Target place (%)\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2067,"value":"PTHChart = Plot.plot({\n width,\n height: 400,\n x: {\n axis: \"top\",\n label: \"Hours →\",\n domain: [7, 20]\n },\n y: {\n label: \"↓ Place\",\n reverse: true,\n type: \"log\",\n },\n marks: [\n Plot.ruleY([3, 10, 20, 50, 100, 500], {strokeOpacity: 0.1}),\n Plot.lineY(originalFinishers, {x: \"hours\", y: \"place\", z: \"year\", strokeOpacity: 0.25, strokeWidth: 1}),\n Plot.ruleX(getPTH(PTHInput), {stroke: categoryColors[2], strokeWidth: 1, strokeOpacity: 0.5}),\n Plot.ruleY([getPTH(PTHInput)[1]], {y: d => getHTP(d)[1], stroke: categoryColors[2], strokeWidth: 1, strokeOpacity: 0.5}),\n Plot.dotX(getPTH(PTHInput), {y: () => getHTP(getPTH(PTHInput)[1])[1], r: 3, fill: categoryColors[2]}),\n Plot.ruleY([{min: getPTH(PTHInput)[0], max: getPTH(PTHInput)[1]}], {y: d => getHTP(d.max)[1], x1: \"min\", x2: \"max\", stroke: categoryColors[2], strokeWidth: 2}),\n Plot.textX(getPTH(PTHInput), {y: () => getHTP(getPTH(PTHInput)[1])[1], dx: 4, dy: -8, textAnchor: \"start\", fontWeight: \"bold\"}),\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":199,"value":"---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":550,"value":"## Appendix\nBoring or interesting (depending on your nerd-level) datasets, functions, and variables that drive the visualizations in this document.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":109,"value":"**Import data from UltraSignup**","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":394,"value":"// List of ids from the events on UltraSignup\nevents = [ \n {year: \"2014\", id:\"24355\", course:\"original\"}, \n {year: \"2015\", id:\"29244\", course:\"original\"}, \n {year: \"2016\", id:\"34087\", course:\"original\"}, \n {year: \"2017\", id:\"38965\", course:\"reroute\"},\n {year: \"2018\", id:\"48278\", course:\"original\"}, \n {year: \"2019\", id:\"57827\", course:\"reroute\"}, \n {year: \"2020\", id:\"67039\", course:\"original\"}, \n {year: \"2021\", id:\"77199\", course:\"original\"}, \n {year: \"2022\", id:\"84317\", course:\"original\"}\n]\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":134,"value":"results = Promise\n .all(events.map(_event => d3.json(`https://observable-cors-proxy.herokuapp.com/https://ultrasignup.com/service/events.svc/results/${_event[\"id\"]}/1/json?_search=false&nd=1652384347174&rows=1500&page=1&sidx=status%20asc%2C%20&sord=asc`)))\n .then((_events)=> _events.map((_event, i) => _event.map(_result => ({\n ..._result, \n time: +_result.time,\n year: events[i].year,\n course: events[i].course,\n status: _result.status <= 1 ? \"Finished\" : _result.status <= 2 ? \"DNF\" : \"DNS\",\n age_group: _result.agegroup === \"<20\" ? \"0-20\" : _result.agegroup,\n hours: +parseFloat((_result.time / 1000) / 3600).toFixed(2)\n })).sort((a, b) => a.hours - b.hours)))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":890,"value":"**Prepare datasets**","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":587,"value":"allResults = results.flat();","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":590,"value":"allFinishers = allResults.filter(d => d.status === \"Finished\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":707,"value":"placementResults = _.flatten(results.map(year => {\n const gender = placementInput.substring(0, placementInput.indexOf(\"-\"));\n const place = placementInput.substring(placementInput.indexOf(\"-\") + 1, placementInput.length);\n const sortedByPlace = _.sortBy(year, \"gender_place\");\n const filteredByStatus = sortedByPlace.filter(result => result.status === \"Finished\");\n const filteredByGender = filteredByStatus.filter(result => result.gender === gender);\n return filteredByGender.slice(0,place)\n}))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1102,"value":"**Filter datasets**","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1105,"value":"presets = [\"All years\", \"Original course only\"]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1123,"value":"filter = (result) => {\n let filtered;\n if(result.year === year){\n filtered = true;\n };\n if(year === presets[0]){\n filtered = true;\n }\n if(year === presets[1] && result.course === \"original\"){\n filtered = true;\n };\n return filtered;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":767,"value":"filteredResults = allResults.filter(filter)\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":635,"value":"filteredFinishers = allFinishers.filter(filter)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2205,"value":"originalFinishers = allFinishers.filter(result => result.course === \"original\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2035,"value":"relevantFinishers = originalFinishers.filter(result => result.year > events[events.length - 1][\"year\"]-3)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2273,"value":"**Variables**","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":2277,"value":"categoryColors = [\"#edc949\", \"#f28e2c\", \"#e15759\", \"#af7aa1\", \"#4e79a7\", \"#76b7b2\", \"#59a14f\", \"#9c755f\", \"#bab0ab\"]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1329,"value":"**Functions**","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1323,"value":"convertAttributeToLabel = (attribute) => {\n return attribute.replace(\"_\", \" \").toLowerCase().split(' ').map(word => word.charAt(0).toUpperCase() + word.slice(1)).join(\" \")\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1315,"value":"getColorConfig = (attribute) => {\n let config = {\n nice: true,\n };\n if(\n attribute === \"year\" ||\n attribute === \"age_group\" ||\n attribute === \"status\"){\n config = {\n ...config,\n type: \"categorical\",\n range: categoryColors,\n }\n }else if (attribute === \"gender\") {\n config = {\n ...config,\n type: \"categorical\",\n range: [categoryColors[2], categoryColors[4]],\n }\n }else{\n config = {\n ...config,\n type: \"linear\",\n range: [categoryColors[0], \"#333377\"],\n interpolate: d3.interpolateHcl\n }\n }\n return config\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1729,"value":"getParticipantTitle = (d) => `${d.firstname} ${d.lastname} (${d.city}, ${d.state}) – Place: ${d.place}, Time: ${d.hours} hours`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1739,"value":"getDistributionTitle = (d, attribute) => `${d[attribute]}: ${\"count\"}`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2257,"value":"getHTP = (hours) => {\n const tolerance = 1/6;\n const similarFinishers = relevantFinishers.filter(d => (\n d.hours > hours - tolerance && d.hours < hours + tolerance\n ));\n const minPlace = d3.max([1, d3.min(similarFinishers, d => d.place)]);\n const maxPlace = d3.max([1, d3.max(similarFinishers, d => d.place)]);\n const medianPlace = d3.max([1, Math.round(d3.median(similarFinishers, d => d.place))]);\n return [minPlace, medianPlace, maxPlace];\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2337,"value":"getPTH = (place) => {\n const similarFinishers = _.sortBy(relevantFinishers, d => d.hours).slice(0, relevantFinishers.length * place / 100);\n const minHours = d3.min(similarFinishers, d => d.hours);\n const maxHours = d3.max(similarFinishers, d => d.hours);\n return [minHours, maxHours];\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":888,"value":"**Import libraries**","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":2511,"value":"import {Plot} from \"@mkfreeman/plot-tooltip\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":894,"value":"import {toc} from \"@harrystevens/toc\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":715,"value":"_ = import(\"https://cdn.skypack.dev/lodash\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W4d","stdlib":"1"}} 24:null