31:T448,plot_1 = { const dedup_data = [...vascular_dtol_colls, ...bryophyte_dtol_colls] .map((d) => { return { Group: d.Group, Species: d.Genus + d.Species }; }) .filter( (value, index, self) => index === self.findIndex( (t) => t.Group === value.Group && t.Species === value.Species ) ); let inner_plot = Plot.plot({ width: 300, caption: "Figure 1 - Number of plant species collected for the Darwin Tree of Life Project.", y: { grid: true }, marks: [ Plot.barY( dedup_data, Plot.groupX( { y: "count" }, { x: "Group", fill: (d) => (d.Group == "Vascular Plants" ? "#e5f5e0" : "#a1d99b"), title: () => "Number of plants collected:" } ) ), Plot.text( dedup_data, Plot.groupX( { y: "count" }, { x: "Group", text: (d) => `${d.length}`, dy: -6 } ) ), Plot.ruleY([0]) ] }); return inner_plot; }32:T4eb,plot_2 = { const dedup_data = [...vascular_dtol_colls, ...bryophyte_dtol_colls] .map((d) => { return { Group: d.Group, Family: d.Family }; }) .filter( (value, index, self) => index === self.findIndex( (t) => t.Group === value.Group && t.Family === value.Family ) ); let plot = Plot.plot({ width: 300, caption: "Figure 2 - Number of plant families collected for the Darwin Tree of Life Project. Target family numbers are indicated as fractions at the top of the bars.", y: { grid: true }, marks: [ Plot.barY( dedup_data, Plot.groupX( { y: "count" }, { x: "Group", fill: (d) => (d.Group == "Vascular Plants" ? "#e5f5e0" : "#a1d99b"), title: () => "Number of families of plant collected:" } ) ), Plot.text( dedup_data, Plot.groupX( { y: "count" }, { x: "Group", text: (d) => d[0].Group == "Vascular Plants" ? `${d.length}/132` : `${d.length}/128`, dy: -6 } ) ), Plot.ruleY([0]) ] }); return plot; }33:[] 2f:{"title":"DToL Plant Working Group Dashboard","cells":[{"id":548,"value":"viewof plot_all = html`\n

DToL Plant Working Group Dashboard

\n\n

This document charts the progress made so far in collecting plant samples for the Darwin Tree of Life project. Overall, ${\n vascular_dtol_colls.length + bryophyte_dtol_colls.length\n} species have been collected up until ${new Date().toLocaleDateString(\n \"en-UK\",\n { weekday: \"long\", year: \"numeric\", month: \"long\", day: \"numeric\" }\n)}. A full and updated list of the DToL plant species, priorities, and collections can be found here for bryophytes, and here for vascular plants.

\n\n

${plot_1}

${plot_2}

${plot_3}

`","pinned":false,"hidden":false,"mode":"ojs"},{"id":25,"value":"$31","pinned":false,"hidden":false,"mode":"ojs"},{"id":381,"value":"$32","pinned":false,"hidden":false,"mode":"ojs"},{"id":279,"value":"// hmm a bit janky, but works.\nft = (d, i) => {\n if (i % 3 == 0 || d == 80) {\n if (d < 1) {\n return d * 1000 + \"Mb\";\n } else {\n return d + \"Gb\";\n }\n }\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":6,"value":"vascular_dtol_colls = fetch(\n \"https://docs.google.com/spreadsheets/d/e/2PACX-1vQnttoVuGLAaqVzqaCjb7Qyc7gKgSNCb7INVIDdS8X83S78nZ_szlHcOxpveueKSrDkRzlqmUGWmtHx/pub?gid=0&single=true&output=csv\",\n {\n method: \"GET\",\n headers: {\n Accept: \"text/csv\"\n }\n }\n)\n .then((response) => response.text())\n .then((d) =>\n d3\n .csvParse(d)\n .filter((d) => d[\"Collected (anyone/any year)\"])\n .map((d) => {\n return {\n Group: \"Vascular Plants\",\n Family: d.Family,\n Genus: d.Genus,\n Species: d.Genus + \" \" + d.Species\n };\n })\n .filter(\n (v, i, a) =>\n a.findIndex((v2) =>\n [\"Group\", \"Family\", \"Species\"].every((k) => v2[k] === v[k])\n ) === i\n )\n )","pinned":false,"hidden":false,"mode":"ojs"},{"id":28,"value":"bryophyte_dtol_colls = fetch(\n \"https://docs.google.com/spreadsheets/d/e/2PACX-1vSWzz8Sut3hQFB4DyxYE_wiZZrHB41VXokc8eihEGAOKdMPDhGw2KkJIl-zjAob6oeDcqgri1zcF3d8/pub?gid=0&single=true&output=csv\",\n {\n method: \"GET\",\n headers: {\n Accept: \"text/csv\"\n }\n }\n)\n .then((response) => response.text())\n .then((d) =>\n d3\n .csvParse(d)\n .filter(\n (d) =>\n d[\"Collected in 2020\"] === \"yes\" ||\n d[\"Collected by RBGE after jan2021\"] === \"yes\" ||\n d[\"Collected by RBGE after jan2022\"] === \"yes\"\n )\n .map((d) => {\n return {\n Group: \"Bryophytes\",\n Family: d.Family,\n Genus: d.Genus,\n Species: d.Genus + \" \" + d.Species\n };\n })\n )","pinned":false,"hidden":false,"mode":"ojs"},{"id":64,"value":"gs_data = fetch(\n \"https://docs.google.com/spreadsheets/d/e/2PACX-1vSt0R1T3MpoOM6UFNMaT_Q9gR5TYyUZC1wgLqW_6_cH9zzII8ehadrbHX8bpktjTv2_yt_KHaj3x_e1/pub?output=csv\",\n {\n method: \"GET\",\n headers: {\n Accept: \"text/csv\"\n }\n }\n)\n .then((response) => response.text())\n .then((d) =>\n d3\n .csvParse(d)\n .filter((d) => d[\"ID Number\"] !== \"\")\n .map((d) => +d[\"GS pg (1C)\"])\n .sort(function (a, b) {\n return a - b;\n })\n )","pinned":false,"hidden":false,"mode":"ojs"},{"id":442,"value":"htl.html`