27:null 28:["$","title",null,{"children":"Comext Data | Meili Vanegas-Hernandez | Observable"}] 2d:Td5a,chart = { var margin = { top: 5, right: 0, bottom: 25, left: 0 }; var w = width - margin.left - margin.right; var h = (ets_benchmarks.length + 1) * eventDim.height * 1.2 - margin.top - margin.bottom; let x = value === "emission intensity" ? x_ei : x_euros; var svg = d3.create("svg"); svg .attr("width", w + margin.left + margin.right) .attr( "height", eventDim.height * ets_benchmarks.length + margin.top + margin.bottom ) .append("g") .attr("transform", "translate(" + margin.left + "," + margin.top + ")"); var g_cbam = svg .selectAll("g.cbam") .data(Object.keys(cbam_product)) .enter() .append("g") .attr("class", "cbam") .attr("id", (d) => `${d.replaceAll(" ", "-")}`) .attr( "transform", (d, i) => "translate(0," + dimensions[i] * eventDim.height + ")" ); g_cbam .append("text") .attr("x", 1) .attr("y", (d, i) => eventDim.height / 2) .style("font-size", "8px") .style("font-weight", "bold") .text((d) => d.toUpperCase()); g_cbam .selectAll("g.benchmark") .data((d) => cbam_product[d].sort()) .enter() .append("g") .attr("class", "benchmark") .append("text") .attr("x", 10) .attr("y", (d, i) => i * eventDim.height + eventDim.height) .style("font-size", "11px") .text((d) => d); let emission_intensities = g_cbam .selectAll("g.emission-intensities") .data((d) => cbam_product[d].sort()) .enter() .append("g") .attr("id", (d) => d.replaceAll(" ", "-")) .attr("class", "emission-intensities"); emission_intensities .append("line") .attr("x1", 210) .attr("x2", 510) .attr("y1", (d, i) => i * eventDim.height + eventDim.height) .attr("y2", (d, i) => i * eventDim.height + eventDim.height) .style("stroke", "black"); emission_intensities .selectAll("circle.ei_values") .data(emission_intensity_types) .enter() .append("circle") .attr("class", "ei_values") .attr("cx", function (d) { if (this.parentNode.id.replaceAll("-", " ") == "Flat steel") console.log( `x ${ 210 + x( get_ei_values(partner, this.parentNode.id.replaceAll("-", " "), d) ) }` ); return ( 210 + x(get_ei_values(partner, this.parentNode.id.replaceAll("-", " "), d)) ); }) .attr("cy", function () { if (this.parentNode.id.replaceAll("-", " ") == "Flat steel") console.log( cbam_product[ this.parentNode.parentNode.id.replaceAll("-", " ") ].indexOf(this.parentNode.id.replaceAll("-", " ")) ); return ( cbam_product[ this.parentNode.parentNode.id.replaceAll("-", " ") ].indexOf(this.parentNode.id.replaceAll("-", " ")) * eventDim.height + eventDim.height ); }) .attr("r", 5) .attr("fill", (d, i) => color(d)) .append("title") .text(function (d) { return `${this.parentNode.parentNode.id.replaceAll( "-", " " )}: ${d3.format(".3f")(get_ei_values(partner, this.parentNode.parentNode.id.replaceAll("-", " "), d))} (${d})`; }); svg .append("g") .attr( "transform", "translate(210," + ets_benchmarks.length * eventDim.height + ")" ) .call(d3.axisBottom(x)); return svg.node(); }2e:T51b,function get_ei_values(partner, ets_benchmark, ei) { let data_benchmark = data.filter( (x) => x["ets_benchmark"] === ets_benchmark && x["partner"] === partner ); if (ei == "ei_calculated") console.log( "data_benchmark", data_benchmark.map((d) => parseFloat(`${d["ei_calculated"]}`)) ); let emission_intensities = data_benchmark .map((x) => !isNaN(parseFloat(x[ei]) * parseFloat(x["quantity_in100kg"])) ? parseFloat(x[ei]) * parseFloat(x["quantity_in100kg"]) : 0 ) .reduce((cum, i) => cum + i); if (ei == "ei_calculated") console.log("emission_intensities", emission_intensities); let quantity = data_benchmark .map((x) => !isNaN(parseFloat(x["quantity_in100kg"])) ? parseFloat(x["quantity_in100kg"]) : 0 ) .reduce((cum, i) => cum + i); if (ei == "ei_calculated") console.log("quantity", quantity); let value_euros = data_benchmark .map((x) => !isNaN(parseFloat(x["value_in_euros"])) ? parseFloat(x["value_in_euros"]) : 0 ) .reduce((cum, i) => cum + i); return !isNaN(emission_intensities / quantity) ? value === "emission intensity" ? emission_intensities / (quantity * 1.0) : (emission_intensities * value_euros) / (quantity * 1.0) : 0; }2f:T6d7,function swatches({ color, columns = null, format = (x) => x, swatchSize = 15, swatchWidth = swatchSize, swatchHeight = swatchSize, marginLeft = 0 }) { const id = DOM.uid().id; if (columns !== null) return html`

${color .domain() .map((value) => { const label = format(value); return html`

${document.createTextNode(label)}

`; })}

`; return html`

${color .domain() .map( (value) => html`${document.createTextNode(format(value))}` )}

`; }30:[{"id":"7f004478d9ba8ca7e39c3631df388a9afe323ddc0043912c3126cf7eb3212a2b26136abdb544ffc1d0b6e994f88ab894deedc21a74e4ec8fa9a4998b3296c11d","href":"https://static.observableusercontent.com/files/7f004478d9ba8ca7e39c3631df388a9afe323ddc0043912c3126cf7eb3212a2b26136abdb544ffc1d0b6e994f88ab894deedc21a74e4ec8fa9a4998b3296c11d","name":"231110_comext_ei_data@2.csv","type":"text/csv","lastModified":1699624249743.927,"size":210486},{"id":"3dc73005b6d288b044a62620bc360493474a21c9b46445911e61a7b848e8474249e13c91797502d69b35fc8a8ad7ddb6456d553c7cc5176709d4bef86b3db89b","href":"https://static.observableusercontent.com/files/3dc73005b6d288b044a62620bc360493474a21c9b46445911e61a7b848e8474249e13c91797502d69b35fc8a8ad7ddb6456d553c7cc5176709d4bef86b3db89b","name":"231115_comext_ei_data.csv","type":"text/csv","lastModified":1700064366318.274,"size":465765},{"id":"271398b17847dff3e6b3899a7217164e9ed92c127f76a872a130b61ac867a74819b740f5b8036013f11e9c8aab845ce5e6bf9ba4c9ea4105fd1d2fd3aa75c3a3","href":"https://static.observableusercontent.com/files/271398b17847dff3e6b3899a7217164e9ed92c127f76a872a130b61ac867a74819b740f5b8036013f11e9c8aab845ce5e6bf9ba4c9ea4105fd1d2fd3aa75c3a3","name":"231115_comext_ei_data@2.csv","type":"text/csv","lastModified":1700065655104.969,"size":465763},{"id":"95ba049af7ece43d8a8c8d6831a9e973556ee273a9df4f337245dfa5a5e305db09f88191b26d58503e6aa3dec6d671f0bd6da09b82d83a4696a9e7d6a330022e","href":"https://static.observableusercontent.com/files/95ba049af7ece43d8a8c8d6831a9e973556ee273a9df4f337245dfa5a5e305db09f88191b26d58503e6aa3dec6d671f0bd6da09b82d83a4696a9e7d6a330022e","name":"231110_comext_ei_data@1.csv","type":"text/csv","lastModified":1699621013517.041,"size":219000},{"id":"61487ec726d8a97e2548db2eccb6e12d22601dbc096de0e8166b8ad76006d1c183f6dc1a7c65361f9592ff2e26154925f30d34302cf74944a9192523fe245ef9","href":"https://static.observableusercontent.com/files/61487ec726d8a97e2548db2eccb6e12d22601dbc096de0e8166b8ad76006d1c183f6dc1a7c65361f9592ff2e26154925f30d34302cf74944a9192523fe245ef9","name":"231115_comext_ei_data@1.csv","type":"text/csv","lastModified":1700064471931.98,"size":465764},{"id":"5030a2dbd7bdc209f32f5b034d1af36612c7810b104884a80f34c6463360395cb4aaed003252b941b8ee63d702eec0d7eca8d95385c269c5f47715338d90bf04","href":"https://static.observableusercontent.com/files/5030a2dbd7bdc209f32f5b034d1af36612c7810b104884a80f34c6463360395cb4aaed003252b941b8ee63d702eec0d7eca8d95385c269c5f47715338d90bf04","name":"231110_comext_ei_data.csv","type":"text/csv","lastModified":1699607531088.084,"size":219042}] 2b:{"id":"dcf4f2e77747c000","slug":null,"title":"Comext Data","thumbnail":"90409f8acf191ade51c2e800d651afaba998ceea23d85d7245eb39fa7bbac91c","access_level":"public","create_time":"$D2023-11-09T14:16:08.856Z","update_time":"$D2023-11-17T13:01:59.795Z","view_time":null,"first_public_time":"$D2023-11-09T14:16:08.856Z","has_unpublished_edits":null,"fork":false,"stars":0,"starred":false,"owner":{"type":"team","id":"7e421362d6355592","login":"meilivh","name":"Meili Vanegas-Hernandez","avatar_url":"https://avatars-next.observableusercontent.com/65fb99c719a764c44bbfab2b29aebc3a656d4d7555acc712e1a1a379bc5849fb","tier":"starter_2024"},"version":411,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"1eeec6caba8cf3b9","login":"meilivh","name":"Meili Vanegas-Hernandez","avatar_url":"https://avatars-next.observableusercontent.com/c39e2af6a77192324fc005b266944cfdbe7d008610a81905c77831fdd4e122b1","tier":null}],"members":[{"type":"individual","id":"1eeec6caba8cf3b9","login":"meilivh","name":"Meili Vanegas-Hernandez","avatar_url":"https://avatars-next.observableusercontent.com/c39e2af6a77192324fc005b266944cfdbe7d008610a81905c77831fdd4e122b1","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"title":"Comext Data","cells":[{"id":0,"value":"# Comext Data","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":230,"value":"viewof partner = Inputs.select([...new Set(data.map((d) => d[\"partner\"]))], {\n value: \"CN\",\n label: \"Choose a partner\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":355,"value":"viewof value = Inputs.select([\"value in euros\", \"emission intensity\"], {\n value: \"emission intensity\",\n label: \"Select a value to show\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":290,"value":"labelSegments = swatches({\n color: d3\n .scaleOrdinal()\n .domain(emission_intensity_types)\n .range(Object.values(typeColors))\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":14,"value":"$2d","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":411,"value":"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":3,"value":"data = {\n let comext_ei_data = await FileAttachment(\n \"231115_comext_ei_data@2.csv\"\n ).csv();\n comext_ei_data = comext_ei_data\n .sort((a, b) => a[\"cbam_product\"] - b[\"cbam_product\"])\n .map((d) => {\n d[\"ets_benchmark\"] = d[\"ets_benchmark\"].replaceAll(\"-\", \" \");\n return d;\n });\n return comext_ei_data;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":25,"value":"$2e","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":307,"value":"await get_ei_values(\"CN\", \"Flat steel\", \"ei_jrc2023\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":385,"value":"function format_ets_benchmark(ets_benchmark) {\n return ets_benchmark.replace(\"Ferro alloys\", \"Ferro-alloys\");\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":259,"value":"ets_benchmarks = Object.values(cbam_product).flat()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":76,"value":"cbam_product = {\n let cbam = [...new Set(data.map((x) => x[\"cbam_product\"]))].sort();\n let cbam_dict = {};\n await cbam.map((d) => (cbam_dict[d] = []));\n await data.map((d) => {\n if (\n d[\"ets_benchmark\"] !== \"\" &&\n !cbam_dict[d[\"cbam_product\"]].includes(d[\"ets_benchmark\"])\n )\n cbam_dict[d[\"cbam_product\"]].push(d[\"ets_benchmark\"]);\n });\n return cbam_dict;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":272,"value":"typeColors = {\n return [\"#e76f51\", \"#2a9d8f\", \"#f4a261\"]; //, \"#e9c46a\", \"#264653\"];\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":310,"value":"x_ei = d3\n .scaleLinear()\n .domain([\n 0,\n d3.max(\n [].concat.apply(\n [],\n [\n data.map((d) => parseFloat(d[\"ei_old\"])),\n data.map((d) => parseFloat(d[\"ei_calculated\"])),\n data.map((d) => parseFloat(d[\"ei_jrc2023\"]))\n ]\n )\n )\n ])\n .range([0, 300])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":350,"value":"x_euros = d3\n .scaleLinear()\n .domain([\n 0,\n d3.max(\n [].concat.apply(\n [],\n [\n data.map((d) => d[\"ei_old\"] * d[\"value_in_euros\"]),\n data.map((d) => d[\"ei_calculated\"] * d[\"value_in_euros\"])\n ]\n )\n )\n ])\n .range([0, 300])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":205,"value":"emission_intensity_types = [\"ei_old\", \"ei_jrc2023\", \"ei_calculated\"]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":137,"value":"dimensions = {\n let temp = Object.values(cbam_product).map((d) => d.length);\n let lengths = [];\n let cum = 0;\n for (let i = 0; i < temp.length; ++i) {\n lengths.push(cum);\n cum += temp[i];\n }\n return lengths;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":29,"value":"eventDim = {\n return {\n height: 30,\n width: width,\n colorWidth: 10\n };\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":279,"value":"color = d3.scaleOrdinal(typeColors)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":292,"value":"$2f","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":294,"value":"function entity(character) {\n return `&#${character.charCodeAt(0).toString()};`;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":37,"value":"html`\n\n\n \n