2b:null 2c:["$","title",null,{"children":"RREE | CCS | Observable"}] 31:Td1b,{ // --- Recopilar datos 1996–2024 de cada array (suma acumulada por fuente) --- const fuentes = [ { label: "Inun", data: inun_bienes, color: "#1A3A6B" }, { label: "TCA", data: tca_bienes, color: "#2EC4B6" }, { label: "Geológicas", data: terremoto_bienes, color: "#F4A261" }, { label: "Humanas", data: terr_bienes, color: "#909090" }, ]; const datosRango = fuentes.map(f => { const filas = f.data.filter(d => { const anio = Number(d["AÑO"]); return anio >= 1996 && anio <= 2024; }); const value = d3.sum(filas, d => d["Indemnizaciones"] ?? 0); return { label: f.label, color: f.color, value }; }).filter(d => d.value > 0); const total = d3.sum(datosRango, d => d.value); // --- Dimensiones --- const width = 900; const height = 500; const radius = Math.min(width, height) / 2 - 60; const svg = d3.create("svg") .attr("width", width) .attr("height", height); const g = svg.append("g") .attr("transform", `translate(${width / 2}, ${height / 2 + 20})`); // --- Título --- svg.append("text") .attr("x", width / 2) .attr("y", 28) .attr("text-anchor", "middle") .style("font-size", "15px") .style("font-weight", "bold") .text("Reparto de Indemnizaciones 1996-2024"); // --- Generador de pie y arcos --- const pie = d3.pie() .value(d => d.value) .sort(null); const arc = d3.arc() .innerRadius(radius * 0.45) // donut .outerRadius(radius); const arcLabel = d3.arc() .innerRadius(radius * 0.75) .outerRadius(radius * 0.75); const arcOuter = d3.arc() .innerRadius(radius * 1.1) .outerRadius(radius * 1.1); const arcos = pie(datosRango); // --- Sectores --- g.selectAll("path") .data(arcos) .join("path") .attr("d", arc) .attr("fill", d => d.data.color) .attr("stroke", "white") .attr("stroke-width", 2); // --- Etiquetas con línea de llamada --- arcos.forEach(d => { const pct = ((d.data.value / total) * 100).toFixed(1); const midAngle = (d.startAngle + d.endAngle) / 2; const posA = arcLabel.centroid(d); // punto interior de la línea const posB = arcOuter.centroid(d); // punto exterior const posC = [...posB]; posC[0] = radius * 1.25 * (midAngle < Math.PI ? 1 : -1); // punto horizontal const anchor = midAngle < Math.PI ? "start" : "end"; // Línea de llamada g.append("polyline") .attr("points", [posA, posB, posC].map(p => p.join(",")).join(" ")) .attr("fill", "none") .attr("stroke", "#555") .attr("stroke-width", 1); // Texto etiqueta g.append("text") .attr("x", posC[0] + (midAngle < Math.PI ? 6 : -6)) .attr("y", posC[1]) .attr("text-anchor", anchor) .attr("dominant-baseline", "middle") .style("font-size", "12px") .text(`${d.data.label} ${pct}%`); }); // --- Centro: total --- g.append("text") .attr("text-anchor", "middle") .attr("dominant-baseline", "middle") .attr("y", -10) .style("font-size", "11px") .style("fill", "#666") .text("Total"); g.append("text") .attr("text-anchor", "middle") .attr("dominant-baseline", "middle") .attr("y", 10) .style("font-size", "13px") .style("font-weight", "bold") .text(d3.format(",.0f")(total)); return svg.node(); }32:Tda6,{ // --- Recopilar datos 1996–2024 de cada array (suma acumulada por fuente) --- const fuentes = [ { label: "Inun", data: inun_bienes, color: "#1A3A6B" }, { label: "TCA", data: tca_bienes, color: "#2EC4B6" }, { label: "Geológicas", data: terremoto_bienes, color: "#F4A261" }, { label: "Humanas", data: terr_bienes, color: "#909090" }, ]; const datosRango = fuentes.map(f => { const filas = f.data.filter(d => { const anio = Number(d["AÑO"]); return anio >= 1996 && anio <= 2024; }); const value = d3.sum(filas, d => d["Indemnizaciones"] ?? 0); return { label: f.label, color: f.color, value }; }).filter(d => d.value > 0); const total = d3.sum(datosRango, d => d.value); // --- Formateadores --- const fmtEntero = new Intl.NumberFormat('es-ES', { maximumFractionDigits: 0 }); const fmtMM = new Intl.NumberFormat('es-ES', { minimumFractionDigits: 2, maximumFractionDigits: 2 }); // --- Dimensiones --- const width = 900; const height = 500; const radius = Math.min(width, height) / 2 - 60; const svg = d3.create("svg") .attr("width", width) .attr("height", height); const g = svg.append("g") .attr("transform", `translate(${width / 2}, ${height / 2 + 20})`); // --- Título --- svg.append("text") .attr("x", width / 2) .attr("y", 28) .attr("text-anchor", "middle") .style("font-size", "15px") .style("font-weight", "bold") .text("Reparto de Indemnizaciones 1996-2024"); // --- Generador de pie y arcos --- const pie = d3.pie() .value(d => d.value) .sort(null); const arc = d3.arc() .innerRadius(radius * 0.45) .outerRadius(radius); const arcLabel = d3.arc() .innerRadius(radius * 0.75) .outerRadius(radius * 0.75); const arcOuter = d3.arc() .innerRadius(radius * 1.1) .outerRadius(radius * 1.1); const arcos = pie(datosRango); // --- Sectores --- g.selectAll("path") .data(arcos) .join("path") .attr("d", arc) .attr("fill", d => d.data.color) .attr("stroke", "white") .attr("stroke-width", 2); // --- Etiquetas con línea de llamada --- arcos.forEach(d => { const pct = ((d.data.value / total) * 100).toFixed(1).replace(".", ","); const valorFmt = fmtEntero.format(d.data.value); const midAngle = (d.startAngle + d.endAngle) / 2; const posA = arcLabel.centroid(d); const posB = arcOuter.centroid(d); const posC = [...posB]; posC[0] = radius * 1.25 * (midAngle < Math.PI ? 1 : -1); const anchor = midAngle < Math.PI ? "start" : "end"; // Línea de llamada g.append("polyline") .attr("points", [posA, posB, posC].map(p => p.join(",")).join(" ")) .attr("fill", "none") .attr("stroke", "#555") .attr("stroke-width", 1); // Texto: nombre valor € (pct%) g.append("text") .attr("x", posC[0] + (midAngle < Math.PI ? 6 : -6)) .attr("y", posC[1]) .attr("text-anchor", anchor) .attr("dominant-baseline", "middle") .style("font-size", "12px") .text(`${d.data.label} ${valorFmt} € (${pct}%)`); }); // --- Centro: total en miles de millones --- g.append("text") .attr("text-anchor", "middle") .attr("dominant-baseline", "middle") .attr("y", -14) .style("font-size", "11px") .style("fill", "#666") .text("Total 1996–2024"); g.append("text") .attr("text-anchor", "middle") .attr("dominant-baseline", "middle") .attr("y", 8) .style("font-size", "13px") .style("font-weight", "bold") .text(`${fmtMM.format(total / 1_000_000_000)} MM€`); return svg.node(); }33:Tcc8,{ // --- Recopilar datos del año 2024 de cada array --- const fuentes = [ { label: "Inun", data: inun_bienes, color: "#1A3A6B" }, { label: "TCA", data: tca_bienes, color: "#2EC4B6" }, { label: "Geol", data: terremoto_bienes, color: "#F4A261" }, { label: "Humanas", data: terr_bienes, color: "#909090" }, ]; const datos2024 = fuentes.map(f => { const fila = f.data.find(d => d["AÑO"] == 2024); return { label: f.label, color: f.color, value: fila ? (fila["Indemnizaciones"] ?? 0) : 0 }; }).filter(d => d.value > 0); const total = d3.sum(datos2024, d => d.value); // --- Dimensiones --- const width = 600; const height = 500; const radius = Math.min(width, height) / 2 - 60; const svg = d3.create("svg") .attr("width", width) .attr("height", height); const g = svg.append("g") .attr("transform", `translate(${width / 2}, ${height / 2 + 20})`); // --- Título --- svg.append("text") .attr("x", width / 2) .attr("y", 28) .attr("text-anchor", "middle") .style("font-size", "15px") .style("font-weight", "bold") .text("Reparto de Indemnizaciones 2024"); // --- Generador de pie y arcos --- const pie = d3.pie() .value(d => d.value) .sort(null); const arc = d3.arc() .innerRadius(radius * 0.45) // donut .outerRadius(radius); const arcLabel = d3.arc() .innerRadius(radius * 0.75) .outerRadius(radius * 0.75); const arcOuter = d3.arc() .innerRadius(radius * 1.1) .outerRadius(radius * 1.1); const arcos = pie(datos2024); // --- Sectores --- g.selectAll("path") .data(arcos) .join("path") .attr("d", arc) .attr("fill", d => d.data.color) .attr("stroke", "white") .attr("stroke-width", 2); // --- Etiquetas con línea de llamada --- arcos.forEach(d => { const pct = ((d.data.value / total) * 100).toFixed(1); const midAngle = (d.startAngle + d.endAngle) / 2; const posA = arcLabel.centroid(d); // punto interior de la línea const posB = arcOuter.centroid(d); // punto exterior const posC = [...posB]; posC[0] = radius * 1.25 * (midAngle < Math.PI ? 1 : -1); // punto horizontal const anchor = midAngle < Math.PI ? "start" : "end"; // Línea de llamada g.append("polyline") .attr("points", [posA, posB, posC].map(p => p.join(",")).join(" ")) .attr("fill", "none") .attr("stroke", "#555") .attr("stroke-width", 1); // Texto etiqueta g.append("text") .attr("x", posC[0] + (midAngle < Math.PI ? 6 : -6)) .attr("y", posC[1]) .attr("text-anchor", anchor) .attr("dominant-baseline", "middle") .style("font-size", "12px") .text(`${d.data.label} ${pct}%`); }); // --- Centro: total --- g.append("text") .attr("text-anchor", "middle") .attr("dominant-baseline", "middle") .attr("y", -10) .style("font-size", "11px") .style("fill", "#666") .text("Total"); g.append("text") .attr("text-anchor", "middle") .attr("dominant-baseline", "middle") .attr("y", 10) .style("font-size", "13px") .style("font-weight", "bold") .text(d3.format(",.0f")(total)); return svg.node(); }34:T1f6c,{ // ── 1. Helpers ─────────────────────────────────────────────────────────────── const toNum = v => (v === "-" || v === "" || v == null) ? 0 : +v; const fmtI = v => Math.round(v).toLocaleString("es-ES"); // ── 2. Maps por año ────────────────────────────────────────────────────────── const bienesMap = new Map(bienes_polizas.map(d => [d.AÑO, toNum(d.TOTAL)])); const personasMap = new Map(personas_polcapits.map(d => [d.AÑO, toNum(d["Nº de Pólizas"])])); const pbMap = new Map(pb_polizas.map(d => [d.AÑO, toNum(d.TOTAL)])); // ── 3. Rango de años ───────────────────────────────────────────────────────── const allYears = [ ...bienes_polizas.map(d => d.AÑO), ...personas_polcapits.map(d => d.AÑO), ...pb_polizas.map(d => d.AÑO) ]; const yearMin = Math.min(...allYears); const yearMax = Math.max(...allYears); const years = Array.from({ length: yearMax - yearMin + 1 }, (_, i) => yearMin + i); // ── 4. Tabla wide + totales ─────────────────────────────────────────────────── const tablaWide = years.map(y => ({ AÑO: y, BIENES: bienesMap.get(y) ?? 0, PERSONAS: personasMap.get(y) ?? 0, PB: pbMap.get(y) ?? 0, get TOTAL() { return this.BIENES + this.PERSONAS + this.PB; } })); const totalesMap = new Map(tablaWide.map(d => [d.AÑO, d.TOTAL])); // ── 5. Formato long ────────────────────────────────────────────────────────── const series = ["BIENES", "PERSONAS", "PB"]; const META = { BIENES: { color: "#3b82f6", label: "Bienes" }, PERSONAS: { color: "#ef4444", label: "Personas" }, PB: { color: "#f59e0b", label: "PB" } }; const longData = tablaWide.flatMap(row => series .filter(s => row[s] > 0) .map(s => ({ año: row.AÑO, serie: s, valor: row[s] / 1_000_000, valorReal: row[s], totalAño: totalesMap.get(row.AÑO) })) ); const lookup = new Map(longData.map(d => [`${d.año}_${d.serie}`, d])); // ── 6. Chart ───────────────────────────────────────────────────────────────── const chart = Plot.plot({ title: "Exposición: Evolución cronológica del nº de pólizas de Riesgos Extraordinarios en España", width: 900, height: 480, marginLeft: 70, marginBottom: 50, style: { fontFamily: "system-ui, sans-serif", fontSize: "12px", cursor: "default" }, x: { label: "Año", tickRotate: -45, tickFormat: d => String(d) }, y: { label: "Nº de pólizas (millones)", grid: true }, color: { legend: true, domain: series, range: series.map(s => META[s].color), label: "Ramo" }, marks: [ Plot.barY(longData, { x: "año", y: "valor", fill: "serie" }), Plot.ruleY([0]) ] }); // ── 7. Wrapper + tooltip ────────────────────────────────────────────────────── const wrapper = document.createElement("div"); wrapper.style.cssText = "position:relative; display:inline-block; width:900px;"; const tip = document.createElement("div"); tip.style.cssText = ` position: absolute; display: none; pointer-events: none; background: #ffffff; border-radius: 3px; padding: 9px 13px 10px; font-family: system-ui, sans-serif; box-shadow: 0 2px 8px rgba(0,0,0,0.13); min-width: 160px; z-index: 99; `; wrapper.appendChild(chart); wrapper.appendChild(tip); // ── 8. Evento mousemove ─────────────────────────────────────────────────────── const svg = chart.querySelector("svg"); svg.addEventListener("mousemove", e => { const bar = e.target.closest?.("rect") ?? (e.target.tagName === "rect" ? e.target : null); if (!bar || !bar.getAttribute("fill")) { tip.style.display = "none"; return; } const fillColor = bar.getAttribute("fill"); const serie = series.find(s => META[s].color === fillColor); if (!serie) { tip.style.display = "none"; return; } // Índice posicional de la barra dentro de su serie const allBarsOfSerie = [...svg.querySelectorAll("rect")] .filter(r => r.getAttribute("fill") === fillColor && parseFloat(r.getAttribute("height") ?? 0) > 0); const barIdx = allBarsOfSerie.indexOf(bar); if (barIdx === -1) { tip.style.display = "none"; return; } const añosDeSerie = longData .filter(d => d.serie === serie) .sort((a, b) => a.año - b.año) .map(d => d.año); const año = añosDeSerie[barIdx]; if (!año) { tip.style.display = "none"; return; } const d = lookup.get(`${año}_${serie}`); if (!d) { tip.style.display = "none"; return; } // ── Contenido minimalista ───────────────────────────────────────────────── tip.innerHTML = `

${año}

${META[serie].label} ${fmtI(d.valorReal)}

Total ${año} ${fmtI(d.totalAño)}

`; // ── Posición: evitar salida por bordes ──────────────────────────────────── const wRect = wrapper.getBoundingClientRect(); const mx = e.clientX - wRect.left; const my = e.clientY - wRect.top; const tipW = 200; const offX = mx + tipW + 18 > wRect.width ? -(tipW + 10) : 18; tip.style.left = `${mx + offX}px`; tip.style.top = `${my - 14}px`; tip.style.display = "block"; }); svg.addEventListener("mouseleave", () => { tip.style.display = "none"; }); // ── Resalte de barra al hover ──────────────────────────────────────────────── svg.addEventListener("mouseover", e => { const bar = e.target.closest?.("rect") ?? (e.target.tagName === "rect" ? e.target : null); if (!bar) return; const fill = bar.getAttribute("fill"); if (series.some(s => META[s].color === fill)) bar.style.opacity = "0.75"; }); svg.addEventListener("mouseout", e => { const bar = e.target.closest?.("rect") ?? (e.target.tagName === "rect" ? e.target : null); if (!bar) return; bar.style.opacity = "1"; }); return wrapper; }35:T1254,{ // ========================================================= // 1) Funciones auxiliares // ========================================================= const toNumber = (v) => { if (v === null || v === undefined || v === "" || v === "-") return 0; if (typeof v === "number") return v; return Number(String(v).replace(/\./g, "").replace(",", ".")); }; const yearOf = (d) => Number(d.AÑO); const formatInt = (n) => n.toLocaleString("es-ES"); const formatMillions = (n) => `${n.toLocaleString("es-ES", { maximumFractionDigits: 0 })} M`; // ========================================================= // 2) Indexar arrays por año // ========================================================= const bienesByYear = new Map( bienes_polizas.map(d => [yearOf(d), d]) ); const personasByYear = new Map( personas_polcapits.map(d => [yearOf(d), d]) ); const pbByYear = new Map( pb_polizas.map(d => [yearOf(d), d]) ); // ========================================================= // 3) Construir rango completo de años // ========================================================= const allYears = [ ...bienes_polizas.map(yearOf), ...personas_polcapits.map(yearOf), ...pb_polizas.map(yearOf) ]; const minYear = Math.min(...allYears); const maxYear = Math.max(...allYears); const years = Array.from( { length: maxYear - minYear + 1 }, (_, i) => minYear + i ); // ========================================================= // 4) Tabla base anual // ========================================================= const tablaPolizasExposicion = years.map(year => ({ AÑO: year, BIENES: toNumber(bienesByYear.get(year)?.TOTAL), PERSONAS: toNumber(personasByYear.get(year)?.["Nº de Pólizas"]), PB: toNumber(pbByYear.get(year)?.TOTAL) })); // ========================================================= // 5) Formato largo + tooltip mejorado // ========================================================= const datosLargos = tablaPolizasExposicion.flatMap(d => { const totalAnual = d.BIENES + d.PERSONAS + d.PB; return [ { AÑO: d.AÑO, Tipo: "BIENES", Valor: d.BIENES / 1e6, tooltip: `${d.AÑO}\n` + `────────────\n` + `BIENES: ${formatInt(d.BIENES)} pólizas\n` + `Total anual: ${formatInt(totalAnual)} pólizas` }, { AÑO: d.AÑO, Tipo: "PERSONAS", Valor: d.PERSONAS / 1e6, tooltip: `${d.AÑO}\n` + `────────────\n` + `PERSONAS: ${formatInt(d.PERSONAS)} pólizas\n` + `Total anual: ${formatInt(totalAnual)} pólizas` }, { AÑO: d.AÑO, Tipo: "PB", Valor: d.PB / 1e6, tooltip: `${d.AÑO}\n` + `────────────\n` + `PB: ${formatInt(d.PB)} pólizas\n` + `Total anual: ${formatInt(totalAnual)} pólizas` } ]; }); // ========================================================= // 6) Colores // ========================================================= const colores = { BIENES: "#4C78A8", // azul PERSONAS: "#E15759", // rojo PB: "#F2CF5B" // amarillo }; // ========================================================= // 7) Gráfico final // ========================================================= return Plot.plot({ width: 1150, height: 560, marginTop: 60, marginRight: 30, marginBottom: 85, marginLeft: 90, style: { background: "white", fontFamily: "system-ui, sans-serif", fontSize: "12px" }, title: "Exposición: Evolución cronológica del nº de pólizas de Riesgos Extraordinarios en España", subtitle: "Suma anual de BIENES, PERSONAS y PB", x: { label: "Año", tickRotate: -45, tickSize: 0 }, y: { label: "Millones de pólizas", grid: true, tickFormat: formatMillions }, color: { domain: ["BIENES", "PERSONAS", "PB"], range: [colores.BIENES, colores.PERSONAS, colores.PB], legend: true, label: "Segmento" }, marks: [ Plot.barY( datosLargos, Plot.stackY({ x: "AÑO", y: "Valor", fill: "Tipo", title: "tooltip", inset: 0.5 }) ), Plot.barY( datosLargos, Plot.stackY({ x: "AÑO", y: "Valor", stroke: "white", strokeWidth: 1, fillOpacity: 0 }) ), Plot.ruleY([0]) ] }); }36:Tcc8,{ // --- Recopilar datos del año 2024 de cada array --- const fuentes = [ { label: "Inun", data: inun_bienes, color: "#1A3A6B" }, { label: "TCA", data: tca_bienes, color: "#2EC4B6" }, { label: "Geol", data: terremoto_bienes, color: "#F4A261" }, { label: "Humanas", data: terr_bienes, color: "#909090" }, ]; const datos2024 = fuentes.map(f => { const fila = f.data.find(d => d["AÑO"] == 2023); return { label: f.label, color: f.color, value: fila ? (fila["Indemnizaciones"] ?? 0) : 0 }; }).filter(d => d.value > 0); const total = d3.sum(datos2024, d => d.value); // --- Dimensiones --- const width = 600; const height = 500; const radius = Math.min(width, height) / 2 - 60; const svg = d3.create("svg") .attr("width", width) .attr("height", height); const g = svg.append("g") .attr("transform", `translate(${width / 2}, ${height / 2 + 20})`); // --- Título --- svg.append("text") .attr("x", width / 2) .attr("y", 28) .attr("text-anchor", "middle") .style("font-size", "15px") .style("font-weight", "bold") .text("Reparto de Indemnizaciones 2023"); // --- Generador de pie y arcos --- const pie = d3.pie() .value(d => d.value) .sort(null); const arc = d3.arc() .innerRadius(radius * 0.45) // donut .outerRadius(radius); const arcLabel = d3.arc() .innerRadius(radius * 0.75) .outerRadius(radius * 0.75); const arcOuter = d3.arc() .innerRadius(radius * 1.1) .outerRadius(radius * 1.1); const arcos = pie(datos2024); // --- Sectores --- g.selectAll("path") .data(arcos) .join("path") .attr("d", arc) .attr("fill", d => d.data.color) .attr("stroke", "white") .attr("stroke-width", 2); // --- Etiquetas con línea de llamada --- arcos.forEach(d => { const pct = ((d.data.value / total) * 100).toFixed(1); const midAngle = (d.startAngle + d.endAngle) / 2; const posA = arcLabel.centroid(d); // punto interior de la línea const posB = arcOuter.centroid(d); // punto exterior const posC = [...posB]; posC[0] = radius * 1.25 * (midAngle < Math.PI ? 1 : -1); // punto horizontal const anchor = midAngle < Math.PI ? "start" : "end"; // Línea de llamada g.append("polyline") .attr("points", [posA, posB, posC].map(p => p.join(",")).join(" ")) .attr("fill", "none") .attr("stroke", "#555") .attr("stroke-width", 1); // Texto etiqueta g.append("text") .attr("x", posC[0] + (midAngle < Math.PI ? 6 : -6)) .attr("y", posC[1]) .attr("text-anchor", anchor) .attr("dominant-baseline", "middle") .style("font-size", "12px") .text(`${d.data.label} ${pct}%`); }); // --- Centro: total --- g.append("text") .attr("text-anchor", "middle") .attr("dominant-baseline", "middle") .attr("y", -10) .style("font-size", "11px") .style("fill", "#666") .text("Total"); g.append("text") .attr("text-anchor", "middle") .attr("dominant-baseline", "middle") .attr("y", 10) .style("font-size", "13px") .style("font-weight", "bold") .text(d3.format(",.0f")(total)); return svg.node(); }37:T193e,{ const margin = { top: 80, right: 40, bottom: 60, left: 70 }; const width = 800 - margin.left - margin.right; const height = 500 - margin.top - margin.bottom; // Años en eje X const años = [...new Set(inun_bienes.map(d => d["AÑO"]))].sort((a, b) => a - b); const x = d3.scalePoint() .domain(años) .range([0, width]) .padding(0.5); const allCosts = [ ...todos_bienes.map(d => d["Costes Medios"]), ...inun_bienes.map(d => d["Costes Medios"]) ].filter(v => v != null); const y = d3.scaleLinear() .domain([0, d3.max(allCosts)]) .range([height, 0]) .nice(); const line = (data) => d3.line() .x(d => x(d["AÑO"])) .y(d => y(d["Costes Medios"])) .defined(d => d["Costes Medios"] != null && años.includes(d["AÑO"])) (data.filter(d => años.includes(d["AÑO"])).sort((a, b) => a["AÑO"] - b["AÑO"])); const svg = d3.create("svg") .attr("width", width + margin.left + margin.right) .attr("height", height + margin.top + margin.bottom); const g = svg.append("g") .attr("transform", `translate(${margin.left},${margin.top})`); // --- Título --- g.append("text") .attr("x", width / 2) .attr("y", -55) .attr("text-anchor", "middle") .style("font-size", "15px") .style("font-weight", "bold") .text("Coste medio por expediente de inundación (1990-2024)"); // --- Leyenda bajo el título --- const legendData = [ ["Riesgos extraordinarios", "#4E9AF1", "line"], ["Inundación", "#1A3A6B", "line"], ["Línea de tendencia de la inundación", "#E63946", "dashed"] ]; const legendSpacing = 180; const legendY = -35; const totalLegendWidth = legendSpacing * legendData.length; const legendStartX = (width - totalLegendWidth) / 2; legendData.forEach(([label, color, type], i) => { const lx = legendStartX + i * legendSpacing; const row = g.append("g").attr("transform", `translate(${lx}, ${legendY})`); row.append("line") .attr("x1", 0).attr("x2", 22) .attr("y1", 6).attr("y2", 6) .attr("stroke", color) .attr("stroke-width", 2.5) .attr("stroke-dasharray", type === "dashed" ? "5,3" : null); row.append("circle") .attr("cx", 11).attr("cy", 6).attr("r", type === "dashed" ? 0 : 4) .attr("fill", color); row.append("text") .attr("x", 28).attr("y", 10) .style("font-size", "12px") .text(label); }); // --- Ejes --- g.append("g") .attr("transform", `translate(0,${height})`) .call(d3.axisBottom(x)) .selectAll("text") .attr("transform", "rotate(-45)") .style("text-anchor", "end"); g.append("g") .call(d3.axisLeft(y).ticks(6).tickFormat(d3.format(",.0f"))); g.append("text") .attr("transform", "rotate(-90)") .attr("x", -height / 2) .attr("y", -55) .attr("text-anchor", "middle") .style("font-size", "12px") .text("Costes Medios"); // --- Línea todos_bienes --- g.append("path") .attr("d", line(todos_bienes)) .attr("fill", "none") .attr("stroke", "#4E9AF1") .attr("stroke-width", 2.5); g.selectAll(".dot-todos") .data(todos_bienes.filter(d => años.includes(d["AÑO"]))) .join("circle") .attr("class", "dot-todos") .attr("cx", d => x(d["AÑO"])) .attr("cy", d => y(d["Costes Medios"])) .attr("r", 4) .attr("fill", "#4E9AF1"); // --- Línea inun_bienes --- g.append("path") .attr("d", line(inun_bienes)) .attr("fill", "none") .attr("stroke", "#1A3A6B") .attr("stroke-width", 2.5); g.selectAll(".dot-inun") .data(inun_bienes) .join("circle") .attr("class", "dot-inun") .attr("cx", d => x(d["AÑO"])) .attr("cy", d => y(d["Costes Medios"])) .attr("r", 4) .attr("fill", "#1A3A6B"); // --- Curva polinómica (grado 3) sobre inun_bienes --- // Regresión polinómica manual usando mínimos cuadrados const inunData = inun_bienes .filter(d => d["Costes Medios"] != null && años.includes(d["AÑO"])) .sort((a, b) => a["AÑO"] - b["AÑO"]); // Normalizar años al índice 0..n para estabilidad numérica const xVals = inunData.map((_, i) => i); const yVals = inunData.map(d => d["Costes Medios"]); const degree = 3; // Construir matriz de Vandermonde y resolver por mínimos cuadrados function polyfit(xs, ys, deg) { const n = xs.length; const A = xs.map(x => Array.from({length: deg + 1}, (_, k) => Math.pow(x, k))); // Calcular ATA y ATy const ATA = Array.from({length: deg+1}, (_, i) => Array.from({length: deg+1}, (_, j) => A.reduce((s, row) => s + row[i] * row[j], 0))); const ATy = Array.from({length: deg+1}, (_, i) => A.reduce((s, row, r) => s + row[i] * ys[r], 0)); // Eliminación gaussiana const M = ATA.map((row, i) => [...row, ATy[i]]); for (let col = 0; col <= deg; col++) { let maxRow = col; for (let row = col+1; row <= deg; row++) if (Math.abs(M[row][col]) > Math.abs(M[maxRow][col])) maxRow = row; [M[col], M[maxRow]] = [M[maxRow], M[col]]; for (let row = col+1; row <= deg; row++) { const f = M[row][col] / M[col][col]; for (let k = col; k <= deg+1; k++) M[row][k] -= f * M[col][k]; } } const coeffs = new Array(deg+1).fill(0); for (let i = deg; i >= 0; i--) { coeffs[i] = M[i][deg+1]; for (let k = i+1; k <= deg; k++) coeffs[i] -= M[i][k] * coeffs[k]; coeffs[i] /= M[i][i]; } return coeffs; // [c0, c1, c2, c3] → c0 + c1*x + c2*x² + c3*x³ } const coeffs = polyfit(xVals, yVals, degree); const polyVal = (xi) => coeffs.reduce((s, c, k) => s + c * Math.pow(xi, k), 0); // Generar puntos suavizados a lo largo de los índices const numPoints = 200; const polyPoints = Array.from({length: numPoints}, (_, i) => { const xi = (i / (numPoints - 1)) * (xVals.length - 1); // Interpolar posición X en el scalePoint usando índice fraccional const i0 = Math.floor(xi); const i1 = Math.min(i0 + 1, inunData.length - 1); const t = xi - i0; const año0 = inunData[i0]["AÑO"]; const año1 = inunData[i1]["AÑO"]; const px = x(año0) + t * (x(año1) - x(año0)); const py = y(polyVal(xi)); return [px, py]; }); const polyLine = d3.line()(polyPoints); g.append("path") .attr("d", polyLine) .attr("fill", "none") .attr("stroke", "#E63946") .attr("stroke-width", 2) .attr("stroke-dasharray", "6,3"); return svg.node(); }38:T1710,{ const margin = { top: 80, right: 40, bottom: 60, left: 70 }; const width = 800 - margin.left - margin.right; const height = 500 - margin.top - margin.bottom; // Años en eje X const años = [...new Set(embate_bienes.map(d => d["AÑO"]))].sort((a, b) => a - b); const x = d3.scalePoint() .domain(años) .range([0, width]) .padding(0.5); const allCosts = [ ...embate_bienes.map(d => d["Costes Medios"]) ].filter(v => v != null); const y = d3.scaleLinear() .domain([0, d3.max(allCosts)]) .range([height, 0]) .nice(); const line = (data) => d3.line() .x(d => x(d["AÑO"])) .y(d => y(d["Costes Medios"])) .defined(d => d["Costes Medios"] != null && años.includes(d["AÑO"])) (data.filter(d => años.includes(d["AÑO"])).sort((a, b) => a["AÑO"] - b["AÑO"])); const svg = d3.create("svg") .attr("width", width + margin.left + margin.right) .attr("height", height + margin.top + margin.bottom); const g = svg.append("g") .attr("transform", `translate(${margin.left},${margin.top})`); // --- Título --- g.append("text") .attr("x", width / 2) .attr("y", -55) .attr("text-anchor", "middle") .style("font-size", "15px") .style("font-weight", "bold") .text("Coste medio por expediente de embate de mar (1995-2024)"); // --- Leyenda bajo el título --- const legendData = [ ["Embate de mar", "#1A3A6B", "line"], ["Línea de tendencia", "#E63946", "dashed"] ]; const legendSpacing = 180; const legendY = -35; const totalLegendWidth = legendSpacing * legendData.length; const legendStartX = (width - totalLegendWidth) / 2; legendData.forEach(([label, color, type], i) => { const lx = legendStartX + i * legendSpacing; const row = g.append("g").attr("transform", `translate(${lx}, ${legendY})`); row.append("line") .attr("x1", 0).attr("x2", 22) .attr("y1", 6).attr("y2", 6) .attr("stroke", color) .attr("stroke-width", 2.5) .attr("stroke-dasharray", type === "dashed" ? "5,3" : null); row.append("circle") .attr("cx", 11).attr("cy", 6).attr("r", type === "dashed" ? 0 : 4) .attr("fill", color); row.append("text") .attr("x", 28).attr("y", 10) .style("font-size", "12px") .text(label); }); // --- Ejes --- g.append("g") .attr("transform", `translate(0,${height})`) .call(d3.axisBottom(x)) .selectAll("text") .attr("transform", "rotate(-45)") .style("text-anchor", "end"); g.append("g") .call(d3.axisLeft(y).ticks(6).tickFormat(d3.format(",.0f"))); g.append("text") .attr("transform", "rotate(-90)") .attr("x", -height / 2) .attr("y", -55) .attr("text-anchor", "middle") .style("font-size", "12px") .text("Costes Medios"); // --- Línea embate_bienes --- g.append("path") .attr("d", line(embate_bienes)) .attr("fill", "none") .attr("stroke", "#1A3A6B") .attr("stroke-width", 2.5); g.selectAll(".dot-emb") .data(embate_bienes) .join("circle") .attr("class", "dot-emb") .attr("cx", d => x(d["AÑO"])) .attr("cy", d => y(d["Costes Medios"])) .attr("r", 4) .attr("fill", "#1A3A6B"); // --- Curva polinómica (grado 3) sobre embate_bienes --- // Regresión polinómica manual usando mínimos cuadrados const embData = embate_bienes .filter(d => d["Costes Medios"] != null && años.includes(d["AÑO"])) .sort((a, b) => a["AÑO"] - b["AÑO"]); // Normalizar años al índice 0..n para estabilidad numérica const xVals = embData.map((_, i) => i); const yVals = embData.map(d => d["Costes Medios"]); const degree = 3; // Construir matriz de Vandermonde y resolver por mínimos cuadrados function polyfit(xs, ys, deg) { const n = xs.length; const A = xs.map(x => Array.from({length: deg + 1}, (_, k) => Math.pow(x, k))); // Calcular ATA y ATy const ATA = Array.from({length: deg+1}, (_, i) => Array.from({length: deg+1}, (_, j) => A.reduce((s, row) => s + row[i] * row[j], 0))); const ATy = Array.from({length: deg+1}, (_, i) => A.reduce((s, row, r) => s + row[i] * ys[r], 0)); // Eliminación gaussiana const M = ATA.map((row, i) => [...row, ATy[i]]); for (let col = 0; col <= deg; col++) { let maxRow = col; for (let row = col+1; row <= deg; row++) if (Math.abs(M[row][col]) > Math.abs(M[maxRow][col])) maxRow = row; [M[col], M[maxRow]] = [M[maxRow], M[col]]; for (let row = col+1; row <= deg; row++) { const f = M[row][col] / M[col][col]; for (let k = col; k <= deg+1; k++) M[row][k] -= f * M[col][k]; } } const coeffs = new Array(deg+1).fill(0); for (let i = deg; i >= 0; i--) { coeffs[i] = M[i][deg+1]; for (let k = i+1; k <= deg; k++) coeffs[i] -= M[i][k] * coeffs[k]; coeffs[i] /= M[i][i]; } return coeffs; // [c0, c1, c2, c3] → c0 + c1*x + c2*x² + c3*x³ } const coeffs = polyfit(xVals, yVals, degree); const polyVal = (xi) => coeffs.reduce((s, c, k) => s + c * Math.pow(xi, k), 0); // Generar puntos suavizados a lo largo de los índices const numPoints = 200; const polyPoints = Array.from({length: numPoints}, (_, i) => { const xi = (i / (numPoints - 1)) * (xVals.length - 1); // Interpolar posición X en el scalePoint usando índice fraccional const i0 = Math.floor(xi); const i1 = Math.min(i0 + 1, embData.length - 1); const t = xi - i0; const año0 = embData[i0]["AÑO"]; const año1 = embData[i1]["AÑO"]; const px = x(año0) + t * (x(año1) - x(año0)); const py = y(polyVal(xi)); return [px, py]; }); const polyLine = d3.line()(polyPoints); g.append("path") .attr("d", polyLine) .attr("fill", "none") .attr("stroke", "#E63946") .attr("stroke-width", 2) .attr("stroke-dasharray", "6,3"); return svg.node(); }39:T1730,{ const margin = { top: 80, right: 40, bottom: 60, left: 70 }; const width = 800 - margin.left - margin.right; const height = 500 - margin.top - margin.bottom; // Años en eje X const años = [...new Set(embate_bienes_can.map(d => d["AÑO"]))].sort((a, b) => a - b); const x = d3.scalePoint() .domain(años) .range([0, width]) .padding(0.5); const allCosts = [ ...embate_bienes_can.map(d => d["Costes Medios"]) ].filter(v => v != null); const y = d3.scaleLinear() .domain([0, d3.max(allCosts)]) .range([height, 0]) .nice(); const line = (data) => d3.line() .x(d => x(d["AÑO"])) .y(d => y(d["Costes Medios"])) .defined(d => d["Costes Medios"] != null && años.includes(d["AÑO"])) (data.filter(d => años.includes(d["AÑO"])).sort((a, b) => a["AÑO"] - b["AÑO"])); const svg = d3.create("svg") .attr("width", width + margin.left + margin.right) .attr("height", height + margin.top + margin.bottom); const g = svg.append("g") .attr("transform", `translate(${margin.left},${margin.top})`); // --- Título --- g.append("text") .attr("x", width / 2) .attr("y", -55) .attr("text-anchor", "middle") .style("font-size", "15px") .style("font-weight", "bold") .text("Coste medio por expediente de embate de mar en Canarias (1995-2024)"); // --- Leyenda bajo el título --- const legendData = [ ["Embate de mar", "#1A3A6B", "line"], ["Línea de tendencia", "#E63946", "dashed"] ]; const legendSpacing = 180; const legendY = -35; const totalLegendWidth = legendSpacing * legendData.length; const legendStartX = (width - totalLegendWidth) / 2; legendData.forEach(([label, color, type], i) => { const lx = legendStartX + i * legendSpacing; const row = g.append("g").attr("transform", `translate(${lx}, ${legendY})`); row.append("line") .attr("x1", 0).attr("x2", 22) .attr("y1", 6).attr("y2", 6) .attr("stroke", color) .attr("stroke-width", 2.5) .attr("stroke-dasharray", type === "dashed" ? "5,3" : null); row.append("circle") .attr("cx", 11).attr("cy", 6).attr("r", type === "dashed" ? 0 : 4) .attr("fill", color); row.append("text") .attr("x", 28).attr("y", 10) .style("font-size", "12px") .text(label); }); // --- Ejes --- g.append("g") .attr("transform", `translate(0,${height})`) .call(d3.axisBottom(x)) .selectAll("text") .attr("transform", "rotate(-45)") .style("text-anchor", "end"); g.append("g") .call(d3.axisLeft(y).ticks(6).tickFormat(d3.format(",.0f"))); g.append("text") .attr("transform", "rotate(-90)") .attr("x", -height / 2) .attr("y", -55) .attr("text-anchor", "middle") .style("font-size", "12px") .text("Costes Medios"); // --- Línea embate_bienes --- g.append("path") .attr("d", line(embate_bienes_can)) .attr("fill", "none") .attr("stroke", "#1A3A6B") .attr("stroke-width", 2.5); g.selectAll(".dot-emb") .data(embate_bienes_can) .join("circle") .attr("class", "dot-emb") .attr("cx", d => x(d["AÑO"])) .attr("cy", d => y(d["Costes Medios"])) .attr("r", 4) .attr("fill", "#1A3A6B"); // --- Curva polinómica (grado 3) sobre embate_bienes --- // Regresión polinómica manual usando mínimos cuadrados const embData = embate_bienes_can .filter(d => d["Costes Medios"] != null && años.includes(d["AÑO"])) .sort((a, b) => a["AÑO"] - b["AÑO"]); // Normalizar años al índice 0..n para estabilidad numérica const xVals = embData.map((_, i) => i); const yVals = embData.map(d => d["Costes Medios"]); const degree = 3; // Construir matriz de Vandermonde y resolver por mínimos cuadrados function polyfit(xs, ys, deg) { const n = xs.length; const A = xs.map(x => Array.from({length: deg + 1}, (_, k) => Math.pow(x, k))); // Calcular ATA y ATy const ATA = Array.from({length: deg+1}, (_, i) => Array.from({length: deg+1}, (_, j) => A.reduce((s, row) => s + row[i] * row[j], 0))); const ATy = Array.from({length: deg+1}, (_, i) => A.reduce((s, row, r) => s + row[i] * ys[r], 0)); // Eliminación gaussiana const M = ATA.map((row, i) => [...row, ATy[i]]); for (let col = 0; col <= deg; col++) { let maxRow = col; for (let row = col+1; row <= deg; row++) if (Math.abs(M[row][col]) > Math.abs(M[maxRow][col])) maxRow = row; [M[col], M[maxRow]] = [M[maxRow], M[col]]; for (let row = col+1; row <= deg; row++) { const f = M[row][col] / M[col][col]; for (let k = col; k <= deg+1; k++) M[row][k] -= f * M[col][k]; } } const coeffs = new Array(deg+1).fill(0); for (let i = deg; i >= 0; i--) { coeffs[i] = M[i][deg+1]; for (let k = i+1; k <= deg; k++) coeffs[i] -= M[i][k] * coeffs[k]; coeffs[i] /= M[i][i]; } return coeffs; // [c0, c1, c2, c3] → c0 + c1*x + c2*x² + c3*x³ } const coeffs = polyfit(xVals, yVals, degree); const polyVal = (xi) => coeffs.reduce((s, c, k) => s + c * Math.pow(xi, k), 0); // Generar puntos suavizados a lo largo de los índices const numPoints = 200; const polyPoints = Array.from({length: numPoints}, (_, i) => { const xi = (i / (numPoints - 1)) * (xVals.length - 1); // Interpolar posición X en el scalePoint usando índice fraccional const i0 = Math.floor(xi); const i1 = Math.min(i0 + 1, embData.length - 1); const t = xi - i0; const año0 = embData[i0]["AÑO"]; const año1 = embData[i1]["AÑO"]; const px = x(año0) + t * (x(año1) - x(año0)); const py = y(polyVal(xi)); return [px, py]; }); const polyLine = d3.line()(polyPoints); g.append("path") .attr("d", polyLine) .attr("fill", "none") .attr("stroke", "#E63946") .attr("stroke-width", 2) .attr("stroke-dasharray", "6,3"); return svg.node(); }3a:[{"id":"26792c5ae6a105c923e21bc7c4cb1feec42b3bd7d90c58f4b7e9fe3bb06fb791cfe1f92e92a4d6cccb670ca3f2388166e54d9f5b0ec1ba36e7dcb4ceffd7ba1f","href":"https://static.observableusercontent.com/files/26792c5ae6a105c923e21bc7c4cb1feec42b3bd7d90c58f4b7e9fe3bb06fb791cfe1f92e92a4d6cccb670ca3f2388166e54d9f5b0ec1ba36e7dcb4ceffd7ba1f","name":"260527_Charla_EMBATE@3.xlsx","type":"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet","lastModified":1778655539898.161,"size":14132},{"id":"3a8a9472d26a4a28844c8d8583995118f014580c65b92c62c31dd42df62ed545a052a5cb156ad3479736fe8b7cfa7c90dc3368f0aff97e5b4fbe63b33955aaa3","href":"https://static.observableusercontent.com/files/3a8a9472d26a4a28844c8d8583995118f014580c65b92c62c31dd42df62ed545a052a5cb156ad3479736fe8b7cfa7c90dc3368f0aff97e5b4fbe63b33955aaa3","name":"Estadistica RREE 2024 web.xlsx","type":"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet","lastModified":1778655207701.752,"size":5972604},{"id":"26792c5ae6a105c923e21bc7c4cb1feec42b3bd7d90c58f4b7e9fe3bb06fb791cfe1f92e92a4d6cccb670ca3f2388166e54d9f5b0ec1ba36e7dcb4ceffd7ba1f","href":"https://static.observableusercontent.com/files/26792c5ae6a105c923e21bc7c4cb1feec42b3bd7d90c58f4b7e9fe3bb06fb791cfe1f92e92a4d6cccb670ca3f2388166e54d9f5b0ec1ba36e7dcb4ceffd7ba1f","name":"260527_Charla_EMBATE@2.xlsx","type":"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet","lastModified":1778655242856.915,"size":14132}] 2f:{"id":"57ae3c690765fdbd","slug":null,"title":"RREE","thumbnail":"49e3b8e7b5c25c76853ac31b4ed41e895e2facb91573182f4e68e995d0ccb899","access_level":"public","create_time":"$D2026-02-26T15:34:20.683Z","update_time":"$D2026-09-15T20:29:23.682Z","view_time":null,"first_public_time":"$D2026-02-26T15:34:20.683Z","has_unpublished_edits":null,"fork":false,"stars":0,"starred":false,"owner":{"type":"team","id":"b41ec3c254271ac8","login":"ccs529","name":"CCS","avatar_url":"https://avatars-next.observableusercontent.com/b59bc59c2d180c039d524a5d961ed3c9d500df42287155694895191c78044d7e","tier":"starter_2024","bio":""},"version":255,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"8e6ec184824ddf12","login":"uelosegi","name":"Uelosegi","avatar_url":"https://avatars-next.observableusercontent.com/dffdbab23303bc1c4d4ebb7f164683ea0e1cd331a930b0366c0adb65d402d1e0","tier":null,"bio":""}],"members":[{"type":"team","id":"b41ec3c254271ac8","login":"ccs529","name":"CCS","avatar_url":"https://avatars-next.observableusercontent.com/b59bc59c2d180c039d524a5d961ed3c9d500df42287155694895191c78044d7e","tier":"starter_2024","role":"editor"},{"type":"individual","id":"8e6ec184824ddf12","login":"uelosegi","name":"Uelosegi","avatar_url":"https://avatars-next.observableusercontent.com/dffdbab23303bc1c4d4ebb7f164683ea0e1cd331a930b0366c0adb65d402d1e0","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":1,"collection":null,"type":"notebook","body":{"titling":"auto","title":"RREE","cells":[{"id":0,"value":"# RREE","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":165,"value":"$31","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":244,"value":"$32","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":94,"value":"$33","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":202,"value":"$34","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":188,"value":"$35","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":158,"value":"$36","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":86,"value":"$37","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":237,"value":"$38","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":240,"value":"$39","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":4,"value":"d3 = require(\"d3@7\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":6,"value":"sheetjs = require(\"https://cdn.sheetjs.com/xlsx-0.20.1/package/dist/xlsx.full.min.js\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":18,"value":"rawFile = FileAttachment(\"Estadistica RREE 2024 web.xlsx\").arrayBuffer()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":21,"value":"workbook = {\n const data = new Uint8Array(rawFile);\n const wb = sheetjs.read(data, { type: \"array\" });\n console.log(\"Hojas encontradas:\", wb.SheetNames);\n return wb;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":25,"value":"workbook.SheetNames","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":206,"value":"rawFile1 = FileAttachment(\"260527_Charla_EMBATE@3.xlsx\").arrayBuffer()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":209,"value":"workbook1 = {\n const data = new Uint8Array(rawFile1);\n const wb = sheetjs.read(data, { type: \"array\" });\n console.log(\"Hojas encontradas:\", wb.SheetNames);\n return wb;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":212,"value":"workbook1.SheetNames","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":205,"value":"embate_bienes_can = {\n const sheetName = \"M. EMBATE DE MAR (CANARIAS)\";\n const sheet = workbook1.Sheets[sheetName];\n\n if (!sheet) throw new Error(\n `Hoja \"${sheetName}\" no encontrada. Disponibles: ${workbook1.SheetNames.join(\" | \")}`\n );\n\n const raw = sheetjs.utils.sheet_to_json(sheet, {\n range: \"B4:E34\",\n header: 1,\n defval: \"\"\n });\n\n const [headers, ...rows] = raw;\n\n return rows.map(row =>\n Object.fromEntries(\n headers.map((h, i) => [String(h).trim() || `Col${i + 1}`, row[i]])\n )\n )\n .filter(d => Number(d[\"AÑO\"]) >= 1995);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":221,"value":"embate_bienes = {\n const sheetName = \"M. EMBATE DE MAR\";\n const sheet = workbook1.Sheets[sheetName];\n\n if (!sheet) throw new Error(\n `Hoja \"${sheetName}\" no encontrada. Disponibles: ${workbook1.SheetNames.join(\" | \")}`\n );\n\n const raw = sheetjs.utils.sheet_to_json(sheet, {\n range: \"B4:E34\",\n header: 1,\n defval: \"\"\n });\n\n const [headers, ...rows] = raw;\n\n return rows.map(row =>\n Object.fromEntries(\n headers.map((h, i) => [String(h).trim() || `Col${i + 1}`, row[i]])\n )\n )\n .filter(d => Number(d[\"AÑO\"]) >= 1995);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":33,"value":"todos_bienes = {\n const sheetName = \"S2-I-B1\";\n const sheet = workbook.Sheets[sheetName];\n\n if (!sheet) throw new Error(\n `Hoja \"${sheetName}\" no encontrada. Disponibles: ${workbook.SheetNames.join(\" | \")}`\n );\n\n const raw = sheetjs.utils.sheet_to_json(sheet, {\n range: \"B641:E695\",\n header: 1,\n defval: \"\"\n });\n\n const [headers, ...rows] = raw;\n\n return rows.map(row =>\n Object.fromEntries(\n headers.map((h, i) => [String(h).trim() || `Col${i + 1}`, row[i]])\n )\n )\n .filter(d => Number(d[\"AÑO\"]) >= 1990);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":171,"value":"bienes_polizas = {\n const sheetName = \"S1-I-B\";\n const sheet = workbook.Sheets[sheetName];\n\n if (!sheet) throw new Error(\n `Hoja \"${sheetName}\" no encontrada. Disponibles: ${workbook.SheetNames.join(\" | \")}`\n );\n\n const raw = sheetjs.utils.sheet_to_json(sheet, {\n range: \"B8:J45\",\n header: 1,\n defval: \"\"\n });\n\n const [headers, ...rows] = raw;\n\n return rows.map(row =>\n Object.fromEntries(\n headers.map((h, i) => [String(h).trim() || `Col${i + 1}`, row[i]])\n )\n )\n .filter(d => Number(d[\"AÑO\"]) >= 1990);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":173,"value":"bienes_capitales = {\n const sheetName = \"S1-I-B\";\n const sheet = workbook.Sheets[sheetName];\n\n if (!sheet) throw new Error(\n `Hoja \"${sheetName}\" no encontrada. Disponibles: ${workbook.SheetNames.join(\" | \")}`\n );\n\n const raw = sheetjs.utils.sheet_to_json(sheet, {\n range: \"N8:U45\",\n header: 1,\n defval: \"\"\n });\n\n const [headers, ...rows] = raw;\n\n return rows.map(row =>\n Object.fromEntries(\n headers.map((h, i) => [String(h).trim() || `Col${i + 1}`, row[i]])\n )\n )\n .filter(d => Number(d[\"AÑO\"]) >= 1990);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":177,"value":"pb_polizas = {\n const sheetName = \"S1-II-PP\";\n const sheet = workbook.Sheets[sheetName];\n\n if (!sheet) throw new Error(\n `Hoja \"${sheetName}\" no encontrada. Disponibles: ${workbook.SheetNames.join(\" | \")}`\n );\n\n const raw = sheetjs.utils.sheet_to_json(sheet, {\n range: \"B8:I31\",\n header: 1,\n defval: \"\"\n });\n\n const [headers, ...rows] = raw;\n\n return rows.map(row =>\n Object.fromEntries(\n headers.map((h, i) => [String(h).trim() || `Col${i + 1}`, row[i]])\n )\n )\n .filter(d => Number(d[\"AÑO\"]) >= 1990);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":179,"value":"pb_capitales = {\n const sheetName = \"S1-II-PP\";\n const sheet = workbook.Sheets[sheetName];\n\n if (!sheet) throw new Error(\n `Hoja \"${sheetName}\" no encontrada. Disponibles: ${workbook.SheetNames.join(\" | \")}`\n );\n\n const raw = sheetjs.utils.sheet_to_json(sheet, {\n range: \"L8:R31\",\n header: 1,\n defval: \"\"\n });\n\n const [headers, ...rows] = raw;\n\n return rows.map(row =>\n Object.fromEntries(\n headers.map((h, i) => [String(h).trim() || `Col${i + 1}`, row[i]])\n )\n )\n .filter(d => Number(d[\"AÑO\"]) >= 1990);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":181,"value":"personas_polcapits = {\n const sheetName = \"S1-III-P\";\n const sheet = workbook.Sheets[sheetName];\n\n if (!sheet) throw new Error(\n `Hoja \"${sheetName}\" no encontrada. Disponibles: ${workbook.SheetNames.join(\" | \")}`\n );\n\n const raw = sheetjs.utils.sheet_to_json(sheet, {\n range: \"B9:E45\",\n header: 1,\n defval: \"\"\n });\n\n const [headers, ...rows] = raw;\n\n return rows.map(row =>\n Object.fromEntries(\n headers.map((h, i) => [String(h).trim() || `Col${i + 1}`, row[i]])\n )\n )\n .filter(d => Number(d[\"AÑO\"]) >= 1990);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":77,"value":"todos_personas = {\n const sheetName = \"S2-III-P1\";\n const sheet = workbook.Sheets[sheetName];\n\n if (!sheet) throw new Error(\n `Hoja \"${sheetName}\" no encontrada. Disponibles: ${workbook.SheetNames.join(\" | \")}`\n );\n\n const raw = sheetjs.utils.sheet_to_json(sheet, {\n range: \"B284:E322\",\n header: 1,\n defval: \"\"\n });\n\n const [headers, ...rows] = raw;\n\n return rows.map(row =>\n Object.fromEntries(\n headers.map((h, i) => [String(h).trim() || `Col${i + 1}`, row[i]])\n )\n )\n .filter(d => Number(d[\"AÑO\"]) >= 1990);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":79,"value":"todos_pb = {\n const sheetName = \"S2-II-PP\";\n const sheet = workbook.Sheets[sheetName];\n\n if (!sheet) throw new Error(\n `Hoja \"${sheetName}\" no encontrada. Disponibles: ${workbook.SheetNames.join(\" | \")}`\n );\n\n const raw = sheetjs.utils.sheet_to_json(sheet, {\n range: \"H12:K33\",\n header: 1,\n defval: \"\"\n });\n\n const [headers, ...rows] = raw;\n\n return rows.map(row =>\n Object.fromEntries(\n headers.map((h, i) => [String(h).trim() || `Col${i + 1}`, row[i]])\n )\n )\n .filter(d => Number(d[\"AÑO\"]) >= 1990);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":27,"value":"inun_bienes = {\n const sheetName = \"S2-I-B1\";\n const sheet = workbook.Sheets[sheetName];\n\n if (!sheet) throw new Error(\n `Hoja \"${sheetName}\" no encontrada. Disponibles: ${workbook.SheetNames.join(\" | \")}`\n );\n\n const raw = sheetjs.utils.sheet_to_json(sheet, {\n range: \"B15:E69\",\n header: 1,\n defval: \"\"\n });\n\n const [headers, ...rows] = raw;\n\n return rows.map(row =>\n Object.fromEntries(\n headers.map((h, i) => [String(h).trim() || `Col${i + 1}`, row[i]])\n )\n )\n .filter(d => Number(d[\"AÑO\"]) >= 1990);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":73,"value":"inun_personas = {\n const sheetName = \"S2-III-P1\";\n const sheet = workbook.Sheets[sheetName];\n\n if (!sheet) throw new Error(\n `Hoja \"${sheetName}\" no encontrada. Disponibles: ${workbook.SheetNames.join(\" | \")}`\n );\n\n const raw = sheetjs.utils.sheet_to_json(sheet, {\n range: \"B13:E51\",\n header: 1,\n defval: \"\"\n });\n\n const [headers, ...rows] = raw;\n\n return rows.map(row =>\n Object.fromEntries(\n headers.map((h, i) => [String(h).trim() || `Col${i + 1}`, row[i]])\n )\n )\n .filter(d => Number(d[\"AÑO\"]) >= 1990);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":75,"value":"inun_pb = {\n const sheetName = \"S2-II-PP\";\n const sheet = workbook.Sheets[sheetName];\n\n if (!sheet) throw new Error(\n `Hoja \"${sheetName}\" no encontrada. Disponibles: ${workbook.SheetNames.join(\" | \")}`\n );\n\n const raw = sheetjs.utils.sheet_to_json(sheet, {\n range: \"B12:E33\",\n header: 1,\n defval: \"\"\n });\n\n const [headers, ...rows] = raw;\n\n return rows.map(row =>\n Object.fromEntries(\n headers.map((h, i) => [String(h).trim() || `Col${i + 1}`, row[i]])\n )\n )\n .filter(d => Number(d[\"AÑO\"]) >= 1990);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":41,"value":"tca_bienes = {\n const sheetName = \"S2-I-B1\";\n const sheet = workbook.Sheets[sheetName];\n\n if (!sheet) throw new Error(\n `Hoja \"${sheetName}\" no encontrada. Disponibles: ${workbook.SheetNames.join(\" | \")}`\n );\n\n const raw = sheetjs.utils.sheet_to_json(sheet, {\n range: \"B201:E255\",\n header: 1,\n defval: \"\"\n });\n\n const [headers, ...rows] = raw;\n\n return rows.map(row =>\n Object.fromEntries(\n headers.map((h, i) => [String(h).trim() || `Col${i + 1}`, row[i]])\n )\n )\n .filter(d => Number(d[\"AÑO\"]) >= 1990);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":109,"value":"tca_personas = {\n const sheetName = \"S2-III-P1\";\n const sheet = workbook.Sheets[sheetName];\n\n if (!sheet) throw new Error(\n `Hoja \"${sheetName}\" no encontrada. Disponibles: ${workbook.SheetNames.join(\" | \")}`\n );\n\n const raw = sheetjs.utils.sheet_to_json(sheet, {\n range: \"B103:E141\",\n header: 1,\n defval: \"\"\n });\n\n const [headers, ...rows] = raw;\n\n return rows.map(row =>\n Object.fromEntries(\n headers.map((h, i) => [String(h).trim() || `Col${i + 1}`, row[i]])\n )\n )\n .filter(d => Number(d[\"AÑO\"]) >= 1990);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":113,"value":"tca_pb = {\n const sheetName = \"S2-II-PP\";\n const sheet = workbook.Sheets[sheetName];\n\n if (!sheet) throw new Error(\n `Hoja \"${sheetName}\" no encontrada. Disponibles: ${workbook.SheetNames.join(\" | \")}`\n );\n\n const raw = sheetjs.utils.sheet_to_json(sheet, {\n range: \"B96:E117\",\n header: 1,\n defval: \"\"\n });\n\n const [headers, ...rows] = raw;\n\n return rows.map(row =>\n Object.fromEntries(\n headers.map((h, i) => [String(h).trim() || `Col${i + 1}`, row[i]])\n )\n )\n .filter(d => Number(d[\"AÑO\"]) >= 1990);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":44,"value":"terremoto_bienes = {\n const sheetName = \"S2-I-B1\";\n const sheet = workbook.Sheets[sheetName];\n\n if (!sheet) throw new Error(\n `Hoja \"${sheetName}\" no encontrada. Disponibles: ${workbook.SheetNames.join(\" | \")}`\n );\n\n const raw = sheetjs.utils.sheet_to_json(sheet, {\n range: \"B77:E131\",\n header: 1,\n defval: \"\"\n });\n\n const [headers, ...rows] = raw;\n\n return rows.map(row =>\n Object.fromEntries(\n headers.map((h, i) => [String(h).trim() || `Col${i + 1}`, row[i]])\n )\n )\n .filter(d => Number(d[\"AÑO\"]) >= 1990);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":119,"value":"terremoto_personas = {\n const sheetName = \"S2-III-P1\";\n const sheet = workbook.Sheets[sheetName];\n\n if (!sheet) throw new Error(\n `Hoja \"${sheetName}\" no encontrada. Disponibles: ${workbook.SheetNames.join(\" | \")}`\n );\n\n const raw = sheetjs.utils.sheet_to_json(sheet, {\n range: \"B58:E96\",\n header: 1,\n defval: \"\"\n });\n\n const [headers, ...rows] = raw;\n\n return rows.map(row =>\n Object.fromEntries(\n headers.map((h, i) => [String(h).trim() || `Col${i + 1}`, row[i]])\n )\n )\n .filter(d => Number(d[\"AÑO\"]) >= 1990);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":123,"value":"terremoto_pb = {\n const sheetName = \"S2-II-PP\";\n const sheet = workbook.Sheets[sheetName];\n\n if (!sheet) throw new Error(\n `Hoja \"${sheetName}\" no encontrada. Disponibles: ${workbook.SheetNames.join(\" | \")}`\n );\n\n const raw = sheetjs.utils.sheet_to_json(sheet, {\n range: \"B40:E61\",\n header: 1,\n defval: \"\"\n });\n\n const [headers, ...rows] = raw;\n\n return rows.map(row =>\n Object.fromEntries(\n headers.map((h, i) => [String(h).trim() || `Col${i + 1}`, row[i]])\n )\n )\n .filter(d => Number(d[\"AÑO\"]) >= 1990);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":63,"value":"terr_bienes = {\n const sheetName = \"S2-I-B1\";\n const sheet = workbook.Sheets[sheetName];\n\n if (!sheet) throw new Error(\n `Hoja \"${sheetName}\" no encontrada. Disponibles: ${workbook.SheetNames.join(\" | \")}`\n );\n\n const raw = sheetjs.utils.sheet_to_json(sheet, {\n range: \"B328:E382\",\n header: 1,\n defval: \"\"\n });\n\n const [headers, ...rows] = raw;\n\n return rows.map(row =>\n Object.fromEntries(\n headers.map((h, i) => [String(h).trim() || `Col${i + 1}`, row[i]])\n )\n )\n .filter(d => Number(d[\"AÑO\"]) >= 1990);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":127,"value":"terr_personas = {\n const sheetName = \"S2-III-P1\";\n const sheet = workbook.Sheets[sheetName];\n\n if (!sheet) throw new Error(\n `Hoja \"${sheetName}\" no encontrada. Disponibles: ${workbook.SheetNames.join(\" | \")}`\n );\n\n const raw = sheetjs.utils.sheet_to_json(sheet, {\n range: \"B148:E186\",\n header: 1,\n defval: \"\"\n });\n\n const [headers, ...rows] = raw;\n\n return rows.map(row =>\n Object.fromEntries(\n headers.map((h, i) => [String(h).trim() || `Col${i + 1}`, row[i]])\n )\n )\n .filter(d => Number(d[\"AÑO\"]) >= 1990);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":131,"value":"terr_pb = {\n const sheetName = \"S2-II-PP\";\n const sheet = workbook.Sheets[sheetName];\n\n if (!sheet) throw new Error(\n `Hoja \"${sheetName}\" no encontrada. Disponibles: ${workbook.SheetNames.join(\" | \")}`\n );\n\n const raw = sheetjs.utils.sheet_to_json(sheet, {\n range: \"B124:E145\",\n header: 1,\n defval: \"\"\n });\n\n const [headers, ...rows] = raw;\n\n return rows.map(row =>\n Object.fromEntries(\n headers.map((h, i) => [String(h).trim() || `Col${i + 1}`, row[i]])\n )\n )\n .filter(d => Number(d[\"AÑO\"]) >= 1990);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":29,"value":"Inputs.table(inun_bienes, { width: \"100%\", height: 600 })","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":46,"value":"Plot.plot({\n marks: [\n Plot.ruleY([0]),\n Plot.lineY(inun_bienes, {x: \"AÑO\", y: \"Costes Medios\", z: \"\"})\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W3a","stdlib":"1"}} 30:"$2f:body"