31:T458,Plot.plot({ height: isMobile ? 900 : 575, width: isMobile ? 400 : width, marginLeft: 40, grid: true, color: { domain: ["F", "M"], range: [purple, green], legend: true, tickFormat: d => d === "M" ? "Male runner" : "Female runner" //reformats legend names }, marks: [ Plot.line(SFEPAll.filter(d => d.year === SFEselectedYear), { x: "parsedTime", y: "gender_place", curve: "bump-x", //https://observablehq.com/@observablehq/plot-line#curve stroke: "gender", strokeWidth: 5, }), Plot.dot(SFEPAll.filter(d => d.year === SFEselectedYear), { x: "parsedTime", y: "gender_place", title: (d) => `Overall place: ${d.gender_place} \n ${d.firstname} ${d.lastname} \n ${d.formattime}`, fill: "gender", stroke: "#FFFFFF", r: 4, }), ], x: { type: "linear", label: "Finishing Time (hrs)", }, y: { tickFormat: d3.format("d"), reverse: true, type: "linear", label: `Finishing Position`, }, tooltip: { fill: "gender", stroke: "#222222", r: 6 } })32:T46a,Plot.plot({ height: SFEplacementTimes.length * 16, width: isMobile ? 400 : width, marginLeft: 43, marks: [ Plot.barX(SFEplacementTimes, { x1: "fastTime", x2: "slowTime", y: "placement", fill: "fasterGender", }), Plot.dot(SFEplacementTimes, { x: "slowTime", // slower gender dots y: "placement", fill: d => d.fasterGender === "M" ? "F" : "M", stroke: "white" }), Plot.dot(SFEplacementTimes, { x: "fastTime", // faster gender dots y: "placement", fill: "fasterGender", stroke: "white" }), Plot.text(SFEplacementTimes, { x: "fastTime", y: "placement", text: "placement", textAnchor: "end", dx: -6 }) ], color: { domain: ["F", "M"], range: [purple, green], legend: true, tickFormat: d => d === "M" ? "Male won position" : "Female won position" //reformats legend names }, x: { grid: true, domain: [SFEyMin, SFEyMax], label: `Finishing time (hrs)`, // tickFormat: d3.format("1s"), }, y: { // label: `Finishing position`, axis: null, }, })33:T454,Plot.plot({ height: isMobile ? 900 : 675, width: isMobile ? 400 : width, marginLeft: 40, grid: true, color: { domain: ["F", "M"], range: [purple, green], legend: true, tickFormat: d => d === "M" ? "Male runner" : "Female runner" //reformats legend names }, marks: [ Plot.line(DTPAll.filter(d => d.year === DTselectedYear), { x: "parsedTime", y: "gender_place", curve: "bump-x", //https://observablehq.com/@observablehq/plot-line#curve stroke: "gender", strokeWidth: 5, }), Plot.dot(DTPAll.filter(d => d.year === DTselectedYear), { x: "parsedTime", y: "gender_place", title: (d) => `Overall place: ${d.gender_place} \n ${d.firstname} ${d.lastname} \n ${d.formattime}`, fill: "gender", stroke: "#FFFFFF", r: 4, }), ], x: { type: "linear", label: "Finishing Time (hrs)", }, y: { tickFormat: d3.format("d"), reverse: true, type: "linear", label: `Finishing Position`, }, tooltip: { fill: "gender", stroke: "#222222", r: 6 } })34:T41b,Plot.plot({ height: DTplacementTimes.length * 10, width: isMobile ? 400 : width, marginLeft: 43, marks: [ Plot.barX(DTplacementTimes, { x1: "fastTime", x2: "slowTime", y: "placement", fill: "fasterGender", }), Plot.dot(DTplacementTimes, { x: "slowTime", // slower gender dots y: "placement", fill: d => d.fasterGender === "M" ? "F" : "M", stroke: "white" }), Plot.dot(DTplacementTimes, { x: "fastTime", // faster gender dots y: "placement", fill: "fasterGender", stroke: "white" }), Plot.text(DTplacementTimes, { x: "fastTime", y: "placement", text: "placement", textAnchor: "end", dx: -6 }) ], color: { domain: ["F", "M"], range: [purple, green], legend: true, tickFormat: d => d === "M" ? "Male won position" : "Female won position" //reformats legend names }, x: { grid: true, domain: [DTyMin, DTyMax], label: `Finishing time (hrs)`, }, y: { axis: null, }, })35:[] 2f:{"title":"How Fast To Podium?","cells":[{"id":0,"value":"# How Fast To Podium?\n## 2022 Racing Schedule","pinned":false,"hidden":false,"mode":"md"},{"id":11,"value":"Ultra racing seasons is here. We're training for the following races in our household:","pinned":false,"hidden":false,"mode":"md"},{"id":934,"value":"Race name | Distance | Time | Overall | By Gender\n-------- | -------- | -------- | -------- | --------\n[Salt Flat Endurance](https://saltflatsenduranceruns.com/) | 50km | 4:30:48 | 4 | 4\n[Golden Gate Dirty Thirty](https://dirty30.org/events/golden-gate-dirty-30/) | 50km | 6:27:21 | 9 | 8\n[Madison Down](https://www.themadisonmarathon.com/) | 50km \n[Never Summer](https://gnarrunners.com/never-summer-100k/) | 60km \n[Flagstaff Sky Peaks](https://aravaiparunning.com/network/flagstaff/) | 80km \n[Flagstaff Sky Peaks](https://aravaiparunning.com/network/flagstaff/) | 26km \n[Run the Rock](https://www.alpinerunning.co/run-the-rock-50) | 50km ","pinned":false,"hidden":false,"mode":"md"},{"id":953,"value":"In order to get an understanding of the competition field, I wanted to build out a little interface to show me what the average finishing times were for a given placement (podium position). That way, I'd have a rough idea of how fast I need to run in order to place, say, top 5 in my gender or age group. ","pinned":false,"hidden":false,"mode":"md"},{"id":955,"value":"- I \"show my work\" in [this notebook](https://observablehq.com/d/25625c45f00d135e?collection=@wiederkehra/running) for the resulting interface below, in all of its analysis messiness 💅\n- And [here](https://observablehq.com/@wiederkehra/how-fast-to-podium-data) is where I'm uploading and wrangling all the data from each race, then importing it into this notebook in an effort to keep things tidy.","pinned":false,"hidden":false,"mode":"md"},{"id":2291,"value":"### Skip to...\n- [Slat Flats Endurance 50K](https://observablehq.com/@wiederkehra/how-fast-to-podium#cell-1070)\n- [Golden Gate Dirty Thirty 50K](https://observablehq.com/@wiederkehra/how-fast-to-podium#cell-2277)","pinned":false,"hidden":false,"mode":"md"},{"id":19,"value":"---","pinned":false,"hidden":false,"mode":"md"},{"id":1070,"value":"# Salt Flats Endurance 50K","pinned":false,"hidden":false,"mode":"md"},{"id":1096,"value":"viewof SFEselectedGender = Inputs.select([\"male\", \"female\"], {label: \"Select your gender\"}) // \"all\" ","pinned":false,"hidden":false,"mode":"ojs"},{"id":1072,"value":"viewof SFEselectedPlace = Inputs.select(new Set(SFEselectedData.map(d => d.gender_place)), {label: \"Select your ideal placing\"})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1077,"value":"${SFEselectedData.filter(d => d.gender_place === SFEselectedPlace).length} ${DTrunnerGender} ${plurality} finished in place ${SFEselectedPlace} over the history of the race. The average finishing time for that placing is ${SFEhours} hours and ${SFEminutes.toFixed(0)} minutes. The ${DTrunnerGender} who placed ${SFEselectedPlace} in ${thisYear}, finished in ${SFEmostRecentHour} and ${SFEmostRecentMinutes} minutes.","pinned":false,"hidden":false,"mode":"md"},{"id":1320,"value":"viewof SFEselectedYear = Inputs.select(new Set(SFEselectedData.map(d => d.year)), {label: \"Select a year\"})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1259,"value":"### Salt Flats Endurance finishers in ${SFEselectedYear}","pinned":false,"hidden":false,"mode":"md"},{"id":1247,"value":"$31","pinned":false,"hidden":false,"mode":"ojs"},{"id":2019,"value":"### Difference in finisher times in ${SFEselectedYear}, by place and gender\nWhether a female or male runner won the position overall and the difference of finishing time from the runner of the opposite gender in that position","pinned":false,"hidden":false,"mode":"md"},{"id":1669,"value":"$32","pinned":false,"hidden":false,"mode":"ojs"},{"id":2139,"value":"---","pinned":false,"hidden":false,"mode":"md"},{"id":2277,"value":"# Dirty Thirty 50K","pinned":false,"hidden":false,"mode":"md"},{"id":2221,"value":"viewof DTselectedGender = Inputs.select([\"male\", \"female\"], {label: \"Select your gender\"}) // \"all\" ","pinned":false,"hidden":false,"mode":"ojs"},{"id":2222,"value":"viewof DTselectedPlace = Inputs.select(new Set(DTselectedData.map(d => d.gender_place)), {label: \"Select your ideal placing\"})","pinned":false,"hidden":false,"mode":"ojs"},{"id":2223,"value":"${DTselectedData.filter(d => d.gender_place === DTselectedPlace).length} ${DTrunnerGender} ${plurality} finished in place ${DTselectedPlace} over the history of the race. The average finishing time for that placing is ${DThours} hours and ${DTminutes.toFixed(0)} minutes. The ${DTrunnerGender} who placed ${DTselectedPlace} in ${thisYear}, finished in ${DTmostRecentHour} and ${DTmostRecentMinutes} minutes.","pinned":false,"hidden":false,"mode":"md"},{"id":2131,"value":"viewof DTselectedYear = Inputs.select(new Set(DTselectedData.map(d => d.year)), {label: \"Select a year\"})","pinned":false,"hidden":false,"mode":"ojs"},{"id":2110,"value":"### Dirty Thirty finishers in ${DTselectedYear}","pinned":false,"hidden":false,"mode":"md"},{"id":2085,"value":"$33","pinned":false,"hidden":false,"mode":"ojs"},{"id":2158,"value":"### Difference in finisher times in ${DTselectedYear}, by place and gender\nWhether a female or male runner won the position overall and the difference of finishing time from the runner of the opposite gender in that position","pinned":false,"hidden":false,"mode":"md"},{"id":2159,"value":"$34","pinned":false,"hidden":false,"mode":"ojs"},{"id":1068,"value":"---","pinned":false,"hidden":false,"mode":"md"},{"id":1090,"value":"### Formulas and transformations","pinned":false,"hidden":false,"mode":"md"},{"id":2280,"value":"👋 On my list of things to do to refactor and make these more flexible based on the inputs above. ","pinned":false,"hidden":false,"mode":"md"},{"id":1938,"value":"Range plot variables and transformations ","pinned":false,"hidden":false,"mode":"md"},{"id":1995,"value":"purple = '#8891a8';","pinned":false,"hidden":false,"mode":"ojs"},{"id":1998,"value":"green = '#1c9099';","pinned":false,"hidden":false,"mode":"ojs"},{"id":1421,"value":"SFEracersByYear = SFEPAll.filter(function(obj) {\n if(obj.year === SFEselectedYear) {\n return obj; // return only racers in the selected year\n }\n }).map(obj => { \n return { \n year: obj.year, \n place: obj.gender_place, \n parsedTime: obj.parsedTime,\n gender: obj.gender,\n }; // return only the values we need\n});","pinned":false,"hidden":false,"mode":"ojs"},{"id":2179,"value":"DTracersByYear = DTPAll.filter(function(obj) {\n if(obj.year === DTselectedYear) {\n return obj; // return only racers in the selected year\n }\n }).map(obj => { \n return { \n year: obj.year, \n place: obj.gender_place, \n parsedTime: obj.parsedTime,\n gender: obj.gender,\n }; // return only the values we need\n});","pinned":false,"hidden":false,"mode":"ojs"},{"id":1479,"value":"SFEracersByPlacement = SFEracersByYear.reduce((group, placement) => {\n const { place } = placement;\n group[place] = group[place] ?? []; // if the finishing place is the same\n group[place].push(placement); // push these objects to the same array \n return group;\n }, []);","pinned":false,"hidden":false,"mode":"ojs"},{"id":2182,"value":"DTracersByPlacement = DTracersByYear.reduce((group, placement) => {\n const { place } = placement;\n group[place] = group[place] ?? []; // if the finishing place is the same\n group[place].push(placement); // push these objects to the same array \n return group;\n }, []);","pinned":false,"hidden":false,"mode":"ojs"},{"id":1715,"value":"SFEplacementTimes = SFEracersByPlacement.slice(1).map((item) => { // slice to remove that first empty array\n const firstItem = item[0];\n const firstItemGender = item[0].gender;\n const secondItem = item[1];\n return {\n fastTime: parseFloat(firstItem.parsedTime),\n slowTime: secondItem ? parseFloat(secondItem.parsedTime) : null,\n fasterGender: firstItemGender,\n placement: item[0].place,\n year: item[0].year,\n };\n});","pinned":false,"hidden":false,"mode":"ojs"},{"id":2185,"value":"DTplacementTimes = DTracersByPlacement.slice(1).map((item) => { // slice to remove that first empty array\n const firstItem = item[0];\n const firstItemGender = item[0].gender;\n const secondItem = item[1];\n return {\n fastTime: parseFloat(firstItem.parsedTime),\n slowTime: secondItem ? parseFloat(secondItem.parsedTime) : null,\n fasterGender: firstItemGender,\n placement: item[0].place,\n year: item[0].year,\n };\n});","pinned":false,"hidden":false,"mode":"ojs"},{"id":1953,"value":"SFEyMin = d3.min(SFEplacementTimes, d => d.fastTime)","pinned":false,"hidden":false,"mode":"ojs"},{"id":2189,"value":"DTyMin = d3.min(DTplacementTimes, d => d.fastTime)","pinned":false,"hidden":false,"mode":"ojs"},{"id":1956,"value":"SFEyMax = d3.max(SFEplacementTimes, d => d.slowTime)","pinned":false,"hidden":false,"mode":"ojs"},{"id":2192,"value":"DTyMax = d3.max(DTplacementTimes, d => d.slowTime)","pinned":false,"hidden":false,"mode":"ojs"},{"id":1904,"value":"---","pinned":false,"hidden":false,"mode":"md"},{"id":1944,"value":"Paragraph variables","pinned":false,"hidden":false,"mode":"md"},{"id":1111,"value":"SFErunnerGender = SFEselectedGender != \"male\" && SFEselectedGender != \"female\" ? \"\" : `${SFEselectedGender}`","pinned":false,"hidden":false,"mode":"ojs"},{"id":2270,"value":"DTrunnerGender = DTselectedGender != \"male\" && DTselectedGender != \"female\" ? \"\" : `${DTselectedGender}`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1285,"value":"plurality = SFEselectedData.filter(d => d.gender_place === SFEselectedPlace).length > 1 ? \"runners\" : \"runner\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":1294,"value":"SFEselectedData = (SFEselectedGender != \"male\" ? SFEPFemale : SFEPMale)","pinned":false,"hidden":false,"mode":"ojs"},{"id":2154,"value":"DTselectedData = (DTselectedGender != \"male\" ? DTPFemale : DTPMale)","pinned":false,"hidden":false,"mode":"ojs"},{"id":1137,"value":"SFEplacingData = SFEselectedData.filter(d => d.gender_place === SFEselectedPlace)","pinned":false,"hidden":false,"mode":"ojs"},{"id":2205,"value":"DTplacingData = DTselectedData.filter(d => d.gender_place === DTselectedPlace)","pinned":false,"hidden":false,"mode":"ojs"},{"id":1094,"value":"SFEindividualTimes = SFEplacingData.map(object => {\n return parseFloat(object.parsedTime);\n});","pinned":false,"hidden":false,"mode":"ojs"},{"id":2206,"value":"DTindividualTimes = DTplacingData.map(object => {\n return parseFloat(object.parsedTime);\n});","pinned":false,"hidden":false,"mode":"ojs"},{"id":1145,"value":"SFEaverageTime = average(SFEindividualTimes).toFixed(fixedFloat)","pinned":false,"hidden":false,"mode":"ojs"},{"id":2207,"value":"DTaverageTime = average(DTindividualTimes).toFixed(fixedFloat)","pinned":false,"hidden":false,"mode":"ojs"},{"id":1150,"value":"SFEhours = parseInt(SFEaverageTime.substring(0, SFEaverageTime.indexOf('.')))","pinned":false,"hidden":false,"mode":"ojs"},{"id":2208,"value":"DThours = parseInt(DTaverageTime.substring(0, DTaverageTime.indexOf('.')))","pinned":false,"hidden":false,"mode":"ojs"},{"id":1163,"value":"SFEminutes = parseFloat(SFEaverageTime.substring(SFEaverageTime.length - strSlice)) * 60","pinned":false,"hidden":false,"mode":"ojs"},{"id":2209,"value":"DTminutes = parseFloat(DTaverageTime.substring(DTaverageTime.length - strSlice)) * 60","pinned":false,"hidden":false,"mode":"ojs"},{"id":1560,"value":"thisYear = JSON.stringify(new Date().getFullYear());","pinned":false,"hidden":false,"mode":"ojs"},{"id":1180,"value":"SFEmostRecentWinner = SFEplacingData.filter(d => d.year === thisYear)","pinned":false,"hidden":false,"mode":"ojs"},{"id":2210,"value":"DTmostRecentWinner = DTplacingData.filter(d => d.year === thisYear)","pinned":false,"hidden":false,"mode":"ojs"},{"id":1570,"value":"If mostRecentWinner throws an error, it could be because there are no results yet for this year in a particular race. I need to add a conditional that tests for that and returns thisYear - 1 for last year in those cases. ","pinned":false,"hidden":false,"mode":"md"},{"id":1187,"value":"SFEmostRecentTime = SFEmostRecentWinner.map(object => {\n const time = object.parsedTime;\n const newTime = time.toString();\n return newTime;\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":2211,"value":"DTmostRecentTime = DTmostRecentWinner.map(object => {\n const time = object.parsedTime;\n const newTime = time.toString();\n return newTime;\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1209,"value":"SFEmostRecentHour = parseInt(SFEmostRecentTime[0].substring(0, SFEmostRecentTime[0].indexOf('.')))","pinned":false,"hidden":false,"mode":"ojs"},{"id":2212,"value":"DTmostRecentHour = parseInt(DTmostRecentTime[0].substring(0, DTmostRecentTime[0].indexOf('.')))","pinned":false,"hidden":false,"mode":"ojs"},{"id":1201,"value":"SFEmostRecentMinutes = (parseFloat(SFEmostRecentTime[0].substring(SFEmostRecentTime[0].length - strSlice)) * 60).toFixed(0)","pinned":false,"hidden":false,"mode":"ojs"},{"id":2213,"value":"DTmostRecentMinutes = (parseFloat(DTmostRecentTime[0].substring(DTmostRecentTime[0].length - strSlice)) * 60).toFixed(0)","pinned":false,"hidden":false,"mode":"ojs"},{"id":291,"value":"---","pinned":false,"hidden":false,"mode":"md"},{"id":1001,"value":"### Data imports","pinned":false,"hidden":false,"mode":"md"},{"id":991,"value":"import {SFEPAllGen as SFEPAll} from \"@wiederkehra/how-fast-to-podium-data\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":994,"value":"import {SFEPFemale} from \"@wiederkehra/how-fast-to-podium-data\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":997,"value":"import {SFEPMale} from \"@wiederkehra/how-fast-to-podium-data\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":2088,"value":"import {DTPAllGen as DTPAll} from \"@wiederkehra/how-fast-to-podium-data\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":2091,"value":"import {DTPFemale as DTPFemale} from \"@wiederkehra/how-fast-to-podium-data\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":2094,"value":"import {DTPMale as DTPMale} from \"@wiederkehra/how-fast-to-podium-data\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":1373,"value":"import {Plot} from \"@mkfreeman/plot-tooltip\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":256,"value":"---","pinned":false,"hidden":false,"mode":"md"},{"id":800,"value":"### General formulas and variables","pinned":false,"hidden":false,"mode":"md"},{"id":1275,"value":"isMobile = width < 768","pinned":false,"hidden":false,"mode":"ojs"},{"id":1147,"value":"fixedFloat = 3","pinned":false,"hidden":false,"mode":"ojs"},{"id":881,"value":"strSlice = 4","pinned":false,"hidden":false,"mode":"ojs"},{"id":728,"value":"average = arr => arr.reduce( ( p, c ) => p + c, 0 ) / arr.length;","pinned":false,"hidden":false,"mode":"ojs"}],"files":"$W35","stdlib":"1","titling":"auto"}