2b:null 2c:["$","title",null,{"children":"FOMB PR: Notice 2024 | José M. Zavala González | Observable"}] 31:Ta22,{ const accu_start = 13062.30; const data = waterfall( fomb_adjustment.filter(d => (d.partial !== true) | show_partial) .map(d => Object({...d, profit: d.cantidad})), accu_start, 'partida'); const colorDomain = ["Increase", "Decrease", "Total"], colorRange = [EA_COLORES_MAP['INDIGO'], EA_COLORES_MAP['RED'], "#1f77b4"]; const plot = Plot.plot({ width: 900, marginLeft: 70, marginBottom: 80, height: 500, caption: 'Fuentes: Junta de Supervisión Fiscal y análisis de Espacios Abiertos.', x: { domain: data.map(d => d.partida), // tickRotate: -30, }, y: { grid: true, nice: true, // label: "Total", domain: [12925, 13500], }, color: { domain: colorDomain, range: colorRange }, marks: [ Plot.axisX({ fontFamily: 'jaf-bernino-sans', label: null, tickFormat: d => partida_labels[d] ?? d, tickSize: 0, fontSize: 12, }), Plot.axisY({ fontVariant: 'tabular-nums', fontFamily: 'jaf-bernino-sans' , tickFormat: d => d3.format("$,.0f")(d)+'M', tickSize: 0, fontSize: 12, }), Plot.barY(data, { filter: d => d.partida !== 'Total', x: "partida", y1: "prior", y2: "accu", fill: d => d.profit >= 0 ? "Increase" : "Decrease", // title: d => d.partida === "Total" // ? `Total: ${fmt(d.accu)}` // : `${d.partida}\nProfit: ${fmt(d.profit)}\nRunning Total: ${fmt(d.accu)}`, }), Plot.text(data, { filter: d => d.partida !== 'Total', x: "partida", y: d => (d["prior"] + d['accu'])/2, // fill: d => d.date === "Total" ? "Total" : d.profit >= 0 ? "Increase" : "Decrease", text: d => d3.format('+$,.1f')(d.profit)+'M', fontWeight: 'bold', fontSize: 16, stroke: 'none', fill: 'white', fontVariant: 'tabular-nums', fontFamily: 'jaf-bernino-sans', }), Plot.ruleY(data, { x1: "partida", x2: "nextDay", y: "accu", strokeDasharray: "1.5" }), Plot.ruleY([accu_start], { // strokeDasharray: "1.5", }), plotLabel(data.filter((d,i) => [0,data.length-1].includes(i)).filter(d => d.profit >= 0), -11), plotLabel(data.filter((d,i) => [0,data.length-1].includes(i)).filter(d => d.profit < 0), 8) //plotLabel(data.filter(d => d.profit >= 0), "bottom"), //plotLabel(data.filter(d => d.profit < 0), "top") ] }) return plot }32:T5f4,{ let thedata = denied_items // .map(d => { // return {...d, cantidad: -1 * d.cantidad} // }) let theplot = Plot.plot({ caption: 'Fuentes: Junta de Supervisión Fiscal y análisis de Espacios Abiertos. *Asignaciones bajo la custodia de la Oficina de Gerencia y Presupuesto (OGP).', marginLeft: 360, height: 600, width: 800, marks: [ Plot.axisX({ fontFamily: 'jaf-bernino-sans', label: null, tickFormat: d => d3.format('$,.0f')(d)+'M', tickSize: 0, fontSize: 12, }), Plot.axisY({ label: null, fontSize: 12, fontFamily: 'jaf-bernino-sans', tickSize: 0, }), Plot.barX(thedata, { x: "cantidad", y: "label", fill: EA_COLORES_MAP['RED'], sort: {y: "-x", reverse: true}}), Plot.text(thedata, { filter: d => d.cantidad >= -20, x: "cantidad", y: "label", text: d => d3.format('$,.1f')(d.cantidad)+'M', fontWeight: 'bold', fontSize: 16, fontFamily: 'jaf-bernino-sans', textAnchor: 'end', dx: -5, fill: 'black', // sort: {y: "x", reverse: true}, }), Plot.text(thedata, { filter: d => d.cantidad < -20, x: "cantidad", y: "label", text: d => d3.format('$,.1f')(d.cantidad)+'M', fontWeight: 'bold', fontSize: 16, fontFamily: 'jaf-bernino-sans', textAnchor: 'start', dx: 5, fill: 'white', // sort: {y: "x", reverse: true}, }), Plot.ruleX([0]), ] }) return theplot }33:T633,{ let thedata = denied_items // .map(d => { // return {...d, cantidad: -1 * d.cantidad} // }) let theplot = Plot.plot({ caption: 'Sources: Fiscal Oversight and Management Board (FOMB) and analysis by Espacios Abiertos. *Assignments under the custody of the Office of Management and Budget (OMB).', marginLeft: 360, height: 600, width: 800, marks: [ Plot.axisX({ fontFamily: 'jaf-bernino-sans', label: null, tickFormat: d => d3.format('$,.0f')(d)+'M', tickSize: 0, fontSize: 12, }), Plot.axisY({ label: null, fontSize: 12, fontFamily: 'jaf-bernino-sans', tickSize: 0, tickFormat: d => labels_engligh[d] ?? d, }), Plot.barX(thedata, { x: "cantidad", y: "label", fill: EA_COLORES_MAP['RED'], sort: {y: "-x", reverse: true}}), Plot.text(thedata, { filter: d => d.cantidad >= -20, x: "cantidad", y: "label", text: d => d3.format('$,.1f')(d.cantidad)+'M', fontWeight: 'bold', fontSize: 16, fontFamily: 'jaf-bernino-sans', textAnchor: 'end', dx: -5, fill: 'black', // sort: {y: "x", reverse: true}, }), Plot.text(thedata, { filter: d => d.cantidad < -20, x: "cantidad", y: "label", text: d => d3.format('$,.1f')(d.cantidad)+'M', fontWeight: 'bold', fontSize: 16, fontFamily: 'jaf-bernino-sans', textAnchor: 'start', dx: 5, fill: 'white', // sort: {y: "x", reverse: true}, }), Plot.ruleX([0]), ] }) return theplot }34:T1144,{ const accu_start = 0.0; const data_prewaterfall = d3.sort(partially_approved_items.map(d => Object({...d, profit: d.cantidad})), d => d.profit) ; const data = waterfall(data_prewaterfall, accu_start, 'label'); const colorDomain = ["Increase", "Decrease", "Total"], // colorRange = ["#649334", "#cc392b", "#1f77b4"]; colorRange = [EA_COLORES_MAP['INDIGO'], EA_COLORES_MAP['RED'], EA_COLORES_MAP['RED']] const inside_label_cutoff = 15; const plot = Plot.plot({ width: 1000, marginLeft: 260, // marginRight: 40, marginBottom: 80, height: 500, caption: 'Fuentes: Junta de Supervisión Fiscal y análisis de Espacios Abiertos. *Asignaciones bajo la custodia de la Oficina de Gerencia y Presupuesto (OGP).', y: { domain: data.map(d => d.label).slice(1, data.length), // tickRotate: -30, }, x: { grid: true, nice: true, // label: "Total", // domain: [12925, 13500], }, color: { domain: colorDomain, range: colorRange }, marks: [ Plot.axisY({ fontFamily: 'jaf-bernino-sans', label: null, tickFormat: d => partida_labels[d] ?? d, tickSize: 0, fontSize: 12, tickPadding: 80, }), Plot.axisX({ fontVariant: 'tabular-nums', fontFamily: 'jaf-bernino-sans' , tickFormat: d => d3.format("$,.0f")(d)+'M', tickSize: 0, fontSize: 12, }), Plot.barX(data, { // filter: d => (d.label !== 'Total') , y: "label", x1: "prior", x2: "accu", fill: d => d.label === 'Total' ? 'Total' : (d.profit >= 0 ? "Increase" : "Decrease"), // sort: {y: "x", reverse: true}, // title: d => d.partida === "Total" // ? `Total: ${fmt(d.accu)}` // : `${d.partida}\nProfit: ${fmt(d.profit)}\nRunning Total: ${fmt(d.accu)}`, }), Plot.text(data, { filter: d => (d.label !== 'Total') & (Math.abs(d.profit) >= inside_label_cutoff), y: "label", x: d => (d["prior"] + d['accu'])/2, // fill: d => d.date === "Total" ? "Total" : d.profit >= 0 ? "Increase" : "Decrease", text: d => d3.format('+$,.1f')(d.profit)+'M', fontWeight: 'bold', fontSize: 16, stroke: 'none', fill: 'white', fontVariant: 'tabular-nums', fontFamily: 'jaf-bernino-sans', }), Plot.text(data, { filter: d => (d.label !== 'Total') & (Math.abs(d.profit) < inside_label_cutoff) & (d.profit > 0), y: "label", x: 'accu', textAnchor: 'start', dx: 5, text: d => d3.format('+$,.1f')(d.profit)+'M', // fontWeight: 'bold', fontSize: 16, stroke: 'none', fill: 'black', fontVariant: 'tabular-nums', fontFamily: 'jaf-bernino-sans', }), Plot.text(data, { filter: d => (d.label !== 'Total') & (Math.abs(d.profit) < inside_label_cutoff) & (d.profit < 0), y: "label", x: 'accu', textAnchor: 'end', dx: -5, text: d => d3.format('+$,.1f')(d.profit)+'M', // fontWeight: 'bold', fontSize: 16, stroke: 'none', fill: 'black', fontVariant: 'tabular-nums', fontFamily: 'jaf-bernino-sans', }), Plot.ruleX(data, { y1: "label", y2: "nextDay", x: "accu", strokeDasharray: "1.5" }), Plot.ruleX([accu_start], { // strokeDasharray: "1.5", }), // plotLabel(data.filter((d,i) => [0,data.length-1].includes(i)).filter(d => d.profit >= 0), -11), Plot.text(data, { filter: (d,i) => ([data.length-1].includes(i)) & d.profit >= 0, y: "label", x: "accu", // dy: -11, //frameAnchor: anchor, fill: 'white', textAnchor: 'start', dx: 5, fontWeight: "bold", text: d => d3.format("$,.1f")(d.accu)+'M', fontSize: 16, // stroke: 'none', fill: 'white', fontVariant: 'tabular-nums', fontFamily: 'jaf-bernino-sans', }), // plotLabel(data.filter((d,i) => [0,data.length-1].includes(i)).filter(d => d.profit < 0), 8) //plotLabel(data.filter(d => d.profit >= 0), "bottom"), //plotLabel(data.filter(d => d.profit < 0), "top") ] }) return plot }35:T1154,{ const accu_start = 0.0; const data_prewaterfall = d3.sort(partially_approved_items.map(d => Object({...d, profit: d.cantidad})), d => d.profit) ; const data = waterfall(data_prewaterfall, accu_start, 'label'); const colorDomain = ["Increase", "Decrease", "Total"], // colorRange = ["#649334", "#cc392b", "#1f77b4"]; colorRange = [EA_COLORES_MAP['INDIGO'], EA_COLORES_MAP['RED'], EA_COLORES_MAP['RED']] const inside_label_cutoff = 15; const plot = Plot.plot({ width: 1000, marginLeft: 300, // marginRight: 40, marginBottom: 80, height: 500, caption: 'Sources: Fiscal Oversight and Management Board (FOMB) and analysis by Espacios Abiertos. *Assignments under the custody of the Office of Management and Budget (OMB).', y: { domain: data.map(d => d.label).slice(1, data.length), // tickRotate: -30, }, x: { grid: true, nice: true, // label: "Total", // domain: [12925, 13500], }, color: { domain: colorDomain, range: colorRange }, marks: [ Plot.axisY({ fontFamily: 'jaf-bernino-sans', label: null, tickFormat: d => labels_engligh[d] ?? d, tickSize: 0, fontSize: 12, tickPadding: 80, }), Plot.axisX({ fontVariant: 'tabular-nums', fontFamily: 'jaf-bernino-sans' , tickFormat: d => d3.format("$,.0f")(d)+'M', tickSize: 0, fontSize: 12, }), Plot.barX(data, { // filter: d => (d.label !== 'Total') , y: "label", x1: "prior", x2: "accu", fill: d => d.label === 'Total' ? 'Total' : (d.profit >= 0 ? "Increase" : "Decrease"), // sort: {y: "x", reverse: true}, // title: d => d.partida === "Total" // ? `Total: ${fmt(d.accu)}` // : `${d.partida}\nProfit: ${fmt(d.profit)}\nRunning Total: ${fmt(d.accu)}`, }), Plot.text(data, { filter: d => (d.label !== 'Total') & (Math.abs(d.profit) >= inside_label_cutoff), y: "label", x: d => (d["prior"] + d['accu'])/2, // fill: d => d.date === "Total" ? "Total" : d.profit >= 0 ? "Increase" : "Decrease", text: d => d3.format('+$,.1f')(d.profit)+'M', fontWeight: 'bold', fontSize: 16, stroke: 'none', fill: 'white', fontVariant: 'tabular-nums', fontFamily: 'jaf-bernino-sans', }), Plot.text(data, { filter: d => (d.label !== 'Total') & (Math.abs(d.profit) < inside_label_cutoff) & (d.profit > 0), y: "label", x: 'accu', textAnchor: 'start', dx: 5, text: d => d3.format('+$,.1f')(d.profit)+'M', // fontWeight: 'bold', fontSize: 16, stroke: 'none', fill: 'black', fontVariant: 'tabular-nums', fontFamily: 'jaf-bernino-sans', }), Plot.text(data, { filter: d => (d.label !== 'Total') & (Math.abs(d.profit) < inside_label_cutoff) & (d.profit < 0), y: "label", x: 'accu', textAnchor: 'end', dx: -5, text: d => d3.format('+$,.1f')(d.profit)+'M', // fontWeight: 'bold', fontSize: 16, stroke: 'none', fill: 'black', fontVariant: 'tabular-nums', fontFamily: 'jaf-bernino-sans', }), Plot.ruleX(data, { y1: "label", y2: "nextDay", x: "accu", strokeDasharray: "1.5" }), Plot.ruleX([accu_start], { // strokeDasharray: "1.5", }), // plotLabel(data.filter((d,i) => [0,data.length-1].includes(i)).filter(d => d.profit >= 0), -11), Plot.text(data, { filter: (d,i) => ([data.length-1].includes(i)) & d.profit >= 0, y: "label", x: "accu", // dy: -11, //frameAnchor: anchor, fill: 'white', textAnchor: 'start', dx: 5, fontWeight: "bold", text: d => d3.format("$,.1f")(d.accu)+'M', fontSize: 16, // stroke: 'none', fill: 'white', fontVariant: 'tabular-nums', fontFamily: 'jaf-bernino-sans', }), // plotLabel(data.filter((d,i) => [0,data.length-1].includes(i)).filter(d => d.profit < 0), 8) //plotLabel(data.filter(d => d.profit >= 0), "bottom"), //plotLabel(data.filter(d => d.profit < 0), "top") ] }) return plot }36:T1129,{ const accu_start = 0.0; const data_prewaterfall = d3.sort(readjusted_items.map(d => Object({...d, profit: d.cantidad})), d => -d.profit) ; const data = waterfall(data_prewaterfall, accu_start, 'label'); const colorDomain = ["Increase", "Decrease", "Total"], // colorRange = ["#649334", "#cc392b", "#1f77b4"]; colorRange = [EA_COLORES_MAP['INDIGO'], EA_COLORES_MAP['RED'], EA_COLORES_MAP['INDIGO']] const inside_label_cutoff = 40; const plot = Plot.plot({ width: 1000, marginLeft: 290, marginRight: 50, marginBottom: 80, height: 900, caption: 'Fuentes: Junta de Supervisión Fiscal y análisis de Espacios Abiertos. *Asignaciones bajo la custodia de la Oficina de Gerencia y Presupuesto (OGP).', y: { domain: data.map(d => d.label).slice(1, data.length), // tickRotate: -30, }, x: { grid: true, nice: true, // label: "Total", // domain: [12925, 13500], }, color: { domain: colorDomain, range: colorRange }, marks: [ Plot.axisY({ fontFamily: 'jaf-bernino-sans', label: null, tickFormat: d => partida_labels[d] ?? d, tickSize: 0, fontSize: 12, // tickPadding: 80, }), Plot.axisX({ fontVariant: 'tabular-nums', fontFamily: 'jaf-bernino-sans' , tickFormat: d => d3.format("$,.0f")(d)+'M', tickSize: 0, fontSize: 12, }), Plot.barX(data, { // filter: d => (d.label !== 'Total') , y: "label", x1: "prior", x2: "accu", fill: d => d.label === 'Total' ? 'Total' : (d.profit >= 0 ? "Increase" : "Decrease"), // sort: {y: "x", reverse: true}, // title: d => d.partida === "Total" // ? `Total: ${fmt(d.accu)}` // : `${d.partida}\nProfit: ${fmt(d.profit)}\nRunning Total: ${fmt(d.accu)}`, }), Plot.text(data, { filter: d => (d.label !== 'Total') & (Math.abs(d.profit) >= inside_label_cutoff), y: "label", x: d => (d["prior"] + d['accu'])/2, // fill: d => d.date === "Total" ? "Total" : d.profit >= 0 ? "Increase" : "Decrease", text: d => d3.format('+$,.2f')(d.profit)+'M', fontWeight: 'bold', fontSize: 16, stroke: 'none', fill: 'white', fontVariant: 'tabular-nums', fontFamily: 'jaf-bernino-sans', }), Plot.text(data, { filter: d => (d.label !== 'Total') & (Math.abs(d.profit) < inside_label_cutoff) & (d.profit > 0), y: "label", x: 'accu', textAnchor: 'start', dx: 5, text: d => d3.format('+$,.2f')(d.profit)+'M', // fontWeight: 'bold', fontSize: 16, stroke: 'none', fill: 'black', fontVariant: 'tabular-nums', fontFamily: 'jaf-bernino-sans', }), Plot.text(data, { filter: d => (d.label !== 'Total') & (Math.abs(d.profit) < inside_label_cutoff) & (d.profit < 0), y: "label", x: 'accu', textAnchor: 'end', dx: -5, text: d => d3.format('+$,.2f')(d.profit)+'M', // fontWeight: 'bold', fontSize: 16, stroke: 'none', fill: 'black', fontVariant: 'tabular-nums', fontFamily: 'jaf-bernino-sans', }), Plot.ruleX(data, { y1: "label", y2: "nextDay", x: "accu", strokeDasharray: "1.5" }), Plot.ruleX([accu_start], { // strokeDasharray: "1.5", }), // plotLabel(data.filter((d,i) => [0,data.length-1].includes(i)).filter(d => d.profit >= 0), -11), Plot.text(data, { filter: (d,i) => (d.label === 'Total'), y: "label", x: "accu", // dy: -11, //frameAnchor: anchor, fill: 'white', textAnchor: 'end', dx: -5, fontWeight: "bold", text: d => d3.format("+$,.1f")(d.accu)+'M', fontSize: 16, // stroke: 'none', fill: 'white', fontVariant: 'tabular-nums', fontFamily: 'jaf-bernino-sans', }), // plotLabel(data.filter((d,i) => [0,data.length-1].includes(i)).filter(d => d.profit < 0), 8) //plotLabel(data.filter(d => d.profit >= 0), "bottom"), //plotLabel(data.filter(d => d.profit < 0), "top") ] }) return plot }37:T1139,{ const accu_start = 0.0; const data_prewaterfall = d3.sort(readjusted_items.map(d => Object({...d, profit: d.cantidad})), d => -d.profit) ; const data = waterfall(data_prewaterfall, accu_start, 'label'); const colorDomain = ["Increase", "Decrease", "Total"], // colorRange = ["#649334", "#cc392b", "#1f77b4"]; colorRange = [EA_COLORES_MAP['INDIGO'], EA_COLORES_MAP['RED'], EA_COLORES_MAP['INDIGO']] const inside_label_cutoff = 40; const plot = Plot.plot({ width: 1000, marginLeft: 320, marginRight: 50, marginBottom: 80, height: 900, caption: 'Sources: Fiscal Oversight and Management Board (FOMB) and analysis by Espacios Abiertos. *Assignments under the custody of the Office of Management and Budget (OMB).', y: { domain: data.map(d => d.label).slice(1, data.length), // tickRotate: -30, }, x: { grid: true, nice: true, // label: "Total", // domain: [12925, 13500], }, color: { domain: colorDomain, range: colorRange }, marks: [ Plot.axisY({ fontFamily: 'jaf-bernino-sans', label: null, tickFormat: d => labels_engligh[d] ?? d, tickSize: 0, fontSize: 12, // tickPadding: 80, }), Plot.axisX({ fontVariant: 'tabular-nums', fontFamily: 'jaf-bernino-sans' , tickFormat: d => d3.format("$,.0f")(d)+'M', tickSize: 0, fontSize: 12, }), Plot.barX(data, { // filter: d => (d.label !== 'Total') , y: "label", x1: "prior", x2: "accu", fill: d => d.label === 'Total' ? 'Total' : (d.profit >= 0 ? "Increase" : "Decrease"), // sort: {y: "x", reverse: true}, // title: d => d.partida === "Total" // ? `Total: ${fmt(d.accu)}` // : `${d.partida}\nProfit: ${fmt(d.profit)}\nRunning Total: ${fmt(d.accu)}`, }), Plot.text(data, { filter: d => (d.label !== 'Total') & (Math.abs(d.profit) >= inside_label_cutoff), y: "label", x: d => (d["prior"] + d['accu'])/2, // fill: d => d.date === "Total" ? "Total" : d.profit >= 0 ? "Increase" : "Decrease", text: d => d3.format('+$,.2f')(d.profit)+'M', fontWeight: 'bold', fontSize: 16, stroke: 'none', fill: 'white', fontVariant: 'tabular-nums', fontFamily: 'jaf-bernino-sans', }), Plot.text(data, { filter: d => (d.label !== 'Total') & (Math.abs(d.profit) < inside_label_cutoff) & (d.profit > 0), y: "label", x: 'accu', textAnchor: 'start', dx: 5, text: d => d3.format('+$,.2f')(d.profit)+'M', // fontWeight: 'bold', fontSize: 16, stroke: 'none', fill: 'black', fontVariant: 'tabular-nums', fontFamily: 'jaf-bernino-sans', }), Plot.text(data, { filter: d => (d.label !== 'Total') & (Math.abs(d.profit) < inside_label_cutoff) & (d.profit < 0), y: "label", x: 'accu', textAnchor: 'end', dx: -5, text: d => d3.format('+$,.2f')(d.profit)+'M', // fontWeight: 'bold', fontSize: 16, stroke: 'none', fill: 'black', fontVariant: 'tabular-nums', fontFamily: 'jaf-bernino-sans', }), Plot.ruleX(data, { y1: "label", y2: "nextDay", x: "accu", strokeDasharray: "1.5" }), Plot.ruleX([accu_start], { // strokeDasharray: "1.5", }), // plotLabel(data.filter((d,i) => [0,data.length-1].includes(i)).filter(d => d.profit >= 0), -11), Plot.text(data, { filter: (d,i) => (d.label === 'Total'), y: "label", x: "accu", // dy: -11, //frameAnchor: anchor, fill: 'white', textAnchor: 'end', dx: -5, fontWeight: "bold", text: d => d3.format("+$,.1f")(d.accu)+'M', fontSize: 16, // stroke: 'none', fill: 'white', fontVariant: 'tabular-nums', fontFamily: 'jaf-bernino-sans', }), // plotLabel(data.filter((d,i) => [0,data.length-1].includes(i)).filter(d => d.profit < 0), 8) //plotLabel(data.filter(d => d.profit >= 0), "bottom"), //plotLabel(data.filter(d => d.profit < 0), "top") ] }) return plot }38:T12c8,labels_engligh = Object({ // #4 'Depto. de Educación': 'Department of Education', 'Ajuste financiamiento de instalaciones (AEE y AAA)': 'Financing Adjustment for PRASA', 'Servicios compartidos con el Dpto. de Seg. Pública': 'Shared Services with Public Safety Department', 'Adm. De Serv. Médicos': 'Emergency Medical Services Administration', 'Expiración de Reserva de Fondos Federales*': 'Expansion of Federal Funds Reserve*', 'Dpto. de Salud': 'Department of Health', 'Dpto. de la Policía': 'Police Administration', 'Adm. De Serv. Médicos*': 'Medical Services Administration*', 'Financ. Elecciones*': 'Elections Financing*', 'Asig. para transp. De la policía*': 'Transportation Assignment to Police*', 'Jta. de Planificación': 'Planning Board', 'Dpto. del Trabajo y Rec. Humanos': 'Department of Labor and Human Resources', 'Depto. de Recr. y Deportes': 'Department of Recreation and Sports', 'Corte General de Justicia': 'General Court of Justice', 'Ofic. Del Inspector General': 'Office of the Inspector General', 'Ofic. de Protec. y Def. Personas con Impedimentos': 'Office of Defense for People with Disabilities', 'Dpto. de Hacienda': 'Department of Treasury', 'Adm. de Servicios Generales': 'General Services Administration', 'Guardia Nacional': 'National Guard', 'Inst. de Estadísticas': 'Institute of Statistics', 'Ofic. para el Desarollo Socioec. y Comunit.': 'Office for Socioeconomic and Community Development', 'Ofic. del Contralor Electoral': 'Office of the Electoral Comptroller', 'Centro de Diabetes': 'Diabetes Center', 'Ofic. de Transf. de Rec. Humanos': 'Human Resources Transformation Office', 'Neg. de Invest. Especiales': 'Special Investigations', 'Ofic. del Procurador del Veterano': 'Veteran\'s Advocate Office', 'Comisión de Desarrollo Cooperativo': 'Autonomous Municipalities Development Commission', 'Aut. del Puerto de las Américas': 'Ports Authority', 'Junta de Retiro': 'Retirement Board', // #3 'Reforma del servicio público*': 'Public Service Reform*', 'Facilitador de Educación Especial*': 'Special Education Facilitator*', 'Iniciativa Vida Plus*': 'Vida Plus Initiative*', 'Comisión Estatal de Elecciones': 'State Elections Commission', 'Subsidio para CDTs*': 'Subsidy for CDTs*', 'Dpto. de Estado': 'Department of State', 'Dpto. De Salud': 'Department of Health', 'Planes Territoriales Municipales*': 'Municipal Territorial Plans*', 'Junta de Planificación': 'Planning Board', 'Negociado de la Policia': 'Police Department', 'Ofic. del Def. del Pueblo': 'Office of the Citizen\'s Ombudsman', 'Ofic. De Transf. de Rec. Humanos': 'Human Resources Transformation Office', 'Administración de Familia y Niños': 'Family and Children Administration', 'Dpto. de Justicia': 'Deparment of Justice', 'Servicios de Salud Correccional': 'Correctional Health Services', 'Total': 'FOMB Budget', // #1 'Contrib. a partidos políticos': 'Contribution to Political Parties', 'Dpto. de Educación': 'Department of Education', 'Matching FEMA*': 'FEMA Matching*', 'CIMVAS*': 'CIMYAS*', 'Centro Comprensivo de Cáncer': 'Comprehensive Cancer Center', 'DRNA - Reserva mantenimiento*': 'DNER - Maintenance reserve*', 'Centro Comprensivo de Cáncer*': 'Comprehensive Cancer Center*', 'Neg. de Bomberos': 'Fire Department', 'Dpto. De Seguridad Pública*': 'Public Safety Department*', 'Cuerpo de Emerg. Médicas': 'Emergency Medical Corps', 'DRNA*': 'DNER*', 'DRNA': 'DNER', 'OGP': 'OMB', 'OGP*': 'OMB*', // #2 'Universidad de Puerto Rico*': 'University of Puerto Rico*', 'Municipios': 'Municipalities', 'Agenda de Administración Financiera*': 'Financial Management Agenda*', 'IDEAR - Dept. de Educación*': 'IDEAR - Department of Education*', 'Plan de Prevención de violencia y reconstrucción social*': 'Violence Prevention and Social Reconstruction Plan*', 'Dept. de Agricultura': 'Department of Agriculture', 'Financiación a entidades de salud*': 'Financing to Health Entities*', 'Análisis de Empleados - Dept. de Seguridad Pública*': 'Employee Analysis - Public Safety Department*', 'Dpto. de Corrección y Rehab.': 'Department of Corrections and Rehabilitation', 'Centros Residenciales para Menores bajo custodia del Gobierno*': 'Residential Centers for Minors in Government Custody*', 'Oficina de la Mujer': 'Office of the Women\'s Advocate', 'Liquidación de vacaciones*': 'Vacation Liquidation*', 'Pagos a Sin Fines de Lucro*': 'Payments to Non-Profit Organizations*', 'Inst. Ciencias Forenses': 'Forensic Sciences Institute', 'Secretariado del Dpto. de la Familia': 'Secretariat of the Department of Family', 'Dept. de Estado': 'State Department', 'Oficina del Gobernador': 'Office of the Governor', })39:T5f8,{ let thedata = approved_items // .map(d => { // return {...d, cantidad: -1 * d.cantidad} // }) let theplot = Plot.plot({ caption: 'Fuentes: Junta de Supervisión Fiscal y análisis de Espacios Abiertos. *Asignaciones bajo la custodia de la Oficina de Gerencia y Presupuesto (OGP).', marginLeft: 200, height: 600, width: 800, marks: [ Plot.axisX({ fontFamily: 'jaf-bernino-sans', label: null, tickFormat: d => d3.format('$,.0f')(d)+'M', tickSize: 0, fontSize: 12, }), Plot.axisY({ label: null, fontSize: 12, fontFamily: 'jaf-bernino-sans', tickSize: 0, }), Plot.barX(thedata, { x: "cantidad", y: "label", fill: EA_COLORES_MAP['INDIGO'], sort: {y: "x", reverse: true}}), Plot.text(thedata, { filter: d => d.cantidad >= 1.5, x: "cantidad", y: "label", text: d => d3.format('$,.1f')(d.cantidad)+'M', fontWeight: 'bold', fontSize: 16, fontFamily: 'jaf-bernino-sans', textAnchor: 'end', dx: -5, fill: 'white', // sort: {y: "x", reverse: true}, }), Plot.text(thedata, { filter: d => d.cantidad < 1.5, x: "cantidad", y: "label", text: d => d3.format('$,.1f')(d.cantidad)+'M', fontWeight: 'bold', fontSize: 16, fontFamily: 'jaf-bernino-sans', textAnchor: 'start', dx: 5, fill: 'black', // sort: {y: "x", reverse: true}, }), Plot.ruleX([0]), ] }) return theplot }3a:T637,{ let thedata = approved_items // .map(d => { // return {...d, cantidad: -1 * d.cantidad} // }) let theplot = Plot.plot({ caption: 'Sources: Fiscal Oversight and Management Board (FOMB) and analysis by Espacios Abiertos. *Assignments under the custody of the Office of Management and Budget (OMB).', marginLeft: 200, height: 600, width: 800, marks: [ Plot.axisX({ fontFamily: 'jaf-bernino-sans', label: null, tickFormat: d => d3.format('$,.0f')(d)+'M', tickSize: 0, fontSize: 12, }), Plot.axisY({ label: null, fontSize: 12, fontFamily: 'jaf-bernino-sans', tickSize: 0, tickFormat: d => labels_engligh[d] ?? d, }), Plot.barX(thedata, { x: "cantidad", y: "label", fill: EA_COLORES_MAP['INDIGO'], sort: {y: "x", reverse: true}}), Plot.text(thedata, { filter: d => d.cantidad >= 1.5, x: "cantidad", y: "label", text: d => d3.format('$,.1f')(d.cantidad)+'M', fontWeight: 'bold', fontSize: 16, fontFamily: 'jaf-bernino-sans', textAnchor: 'end', dx: -5, fill: 'white', // sort: {y: "x", reverse: true}, }), Plot.text(thedata, { filter: d => d.cantidad < 1.5, x: "cantidad", y: "label", text: d => d3.format('$,.1f')(d.cantidad)+'M', fontWeight: 'bold', fontSize: 16, fontFamily: 'jaf-bernino-sans', textAnchor: 'start', dx: 5, fill: 'black', // sort: {y: "x", reverse: true}, }), Plot.ruleX([0]), ] }) return theplot }3b:T1129,{ const accu_start = 0.0; const data_prewaterfall = d3.sort(approved_items.map(d => Object({...d, profit: d.cantidad})), d => -d.profit) ; const data = waterfall(data_prewaterfall, accu_start, 'label'); const colorDomain = ["Increase", "Decrease", "Total"], // colorRange = ["#649334", "#cc392b", "#1f77b4"]; colorRange = [EA_COLORES_MAP['INDIGO'], EA_COLORES_MAP['RED'], EA_COLORES_MAP['INDIGO']] const inside_label_cutoff = 14.1; const plot = Plot.plot({ width: 1000, marginLeft: 190, marginRight: 50, marginBottom: 80, height: 500, caption: 'Fuentes: Junta de Supervisión Fiscal y análisis de Espacios Abiertos. *Asignaciones bajo la custodia de la Oficina de Gerencia y Presupuesto (OGP).', y: { domain: data.map(d => d.label).slice(1, data.length), // tickRotate: -30, }, x: { grid: true, nice: true, // label: "Total", // domain: [12925, 13500], }, color: { domain: colorDomain, range: colorRange }, marks: [ Plot.axisY({ fontFamily: 'jaf-bernino-sans', label: null, tickFormat: d => partida_labels[d] ?? d, tickSize: 0, fontSize: 12, // tickPadding: 80, }), Plot.axisX({ fontVariant: 'tabular-nums', fontFamily: 'jaf-bernino-sans' , tickFormat: d => d3.format("$,.0f")(d)+'M', tickSize: 0, fontSize: 12, }), Plot.barX(data, { // filter: d => (d.label !== 'Total') , y: "label", x1: "prior", x2: "accu", fill: d => d.label === 'Total' ? 'Total' : (d.profit >= 0 ? "Increase" : "Decrease"), // sort: {y: "x", reverse: true}, // title: d => d.partida === "Total" // ? `Total: ${fmt(d.accu)}` // : `${d.partida}\nProfit: ${fmt(d.profit)}\nRunning Total: ${fmt(d.accu)}`, }), Plot.text(data, { filter: d => (d.label !== 'Total') & (Math.abs(d.profit) >= inside_label_cutoff), y: "label", x: d => (d["prior"] + d['accu'])/2, // fill: d => d.date === "Total" ? "Total" : d.profit >= 0 ? "Increase" : "Decrease", text: d => d3.format('+$,.2f')(d.profit)+'M', fontWeight: 'bold', fontSize: 16, stroke: 'none', fill: 'white', fontVariant: 'tabular-nums', fontFamily: 'jaf-bernino-sans', }), Plot.text(data, { filter: d => (d.label !== 'Total') & (Math.abs(d.profit) < inside_label_cutoff) & (d.profit > 0), y: "label", x: 'accu', textAnchor: 'start', dx: 5, text: d => d3.format('+$,.2f')(d.profit)+'M', // fontWeight: 'bold', fontSize: 16, stroke: 'none', fill: 'black', fontVariant: 'tabular-nums', fontFamily: 'jaf-bernino-sans', }), Plot.text(data, { filter: d => (d.label !== 'Total') & (Math.abs(d.profit) < inside_label_cutoff) & (d.profit < 0), y: "label", x: 'accu', textAnchor: 'end', dx: -5, text: d => d3.format('+$,.2f')(d.profit)+'M', // fontWeight: 'bold', fontSize: 16, stroke: 'none', fill: 'black', fontVariant: 'tabular-nums', fontFamily: 'jaf-bernino-sans', }), Plot.ruleX(data, { y1: "label", y2: "nextDay", x: "accu", strokeDasharray: "1.5" }), Plot.ruleX([accu_start], { // strokeDasharray: "1.5", }), // plotLabel(data.filter((d,i) => [0,data.length-1].includes(i)).filter(d => d.profit >= 0), -11), Plot.text(data, { filter: (d,i) => (d.label === 'Total'), y: "label", x: "accu", // dy: -11, //frameAnchor: anchor, fill: 'white', textAnchor: 'end', dx: -5, fontWeight: "bold", text: d => d3.format("+$,.1f")(d.accu)+'M', fontSize: 16, // stroke: 'none', fill: 'white', fontVariant: 'tabular-nums', fontFamily: 'jaf-bernino-sans', }), // plotLabel(data.filter((d,i) => [0,data.length-1].includes(i)).filter(d => d.profit < 0), 8) //plotLabel(data.filter(d => d.profit >= 0), "bottom"), //plotLabel(data.filter(d => d.profit < 0), "top") ] }) return plot }3c:Tf2e,{ let thedata = cambios_por_area; let thedata_long = aq.from(thedata) .fold(['aumento','decremento'], {as: ['tipo_cambio', 'cantidad']}) .objects(); const inside_bar_cuttoff = 20; const gap = 40; let theplot = Plot.plot({ caption: 'Fuentes: Junta de Supervisión Fiscal y análisis de Espacios Abiertos.', width: 1000, marginLeft: 260, marginRight: gap, color: { domain: ['aumento', 'decremento'], range: ['INDIGO', 'RED'].map(d => EA_COLORES_MAP[d]), }, x: { label: null, ticks: 0, }, y: { domain: thedata.map(d => d.area_observatorio), }, marks: [ // Plot.axisX({ // tickSize: 0, // label: null, // fontSize: 12, // fontFamily: 'jaf-bernino-sans', // fontVariant: 'tabular-nums', // tickFormat: d => d === 0 ? 0 : d3.format('+$.0f')(d)+'M', // }), Plot.axisY({ tickSize: 0, label: null, fontSize: 12, fontFamily: 'jaf-bernino-sans', tickPadding: gap+15, }), Plot.barX(thedata_long, { filter: d => d.tipo_cambio === 'aumento', x: "cantidad", y: "area_observatorio", z: 'tipo_cambio', fill: 'tipo_cambio', dx: gap, }), Plot.barX(thedata_long, { filter: d => d.tipo_cambio === 'decremento', x: "cantidad", y: "area_observatorio", z: 'tipo_cambio', fill: 'tipo_cambio', dx: -gap, }), // Labels: Monto aumento, dentro de la barra Plot.text(thedata_long, { filter: d => (d['tipo_cambio'] === 'aumento') & (Math.abs(d.cantidad) >= inside_bar_cuttoff), x: "cantidad", y: "area_observatorio", text: d => d3.format('+$.1f')(d.cantidad)+'M', textAnchor: 'end', dx: gap -5, fontSize: 12, fill: 'white', fontWeight: 'bold', }), // Labels: Monto aumento, fuera de la barra Plot.text(thedata_long, { filter: d => (d['tipo_cambio'] === 'aumento') & (Math.abs(d.cantidad) < inside_bar_cuttoff) & (d.cantidad >= 0.1), x: "cantidad", y: "area_observatorio", text: d => d3.format('+$.1f')(d.cantidad)+'M', textAnchor: 'start', dx: gap +5, fontSize: 12, fill: 'black', fontWeight: 'bold', }), // Labels: Monto decremento, dentro de la barra Plot.text(thedata_long, { filter: d => (d['tipo_cambio'] === 'decremento') & (Math.abs(d.cantidad) >= inside_bar_cuttoff), x: "cantidad", y: "area_observatorio", text: d => d3.format('+$.1f')(d.cantidad)+'M', textAnchor: 'start', dx: -gap +5, fontSize: 12, fill: 'white', fontWeight: 'bold', }), // Labels: Monto decremento, fuera de la barra Plot.text(thedata_long, { filter: d => (d['tipo_cambio'] === 'decremento') & (Math.abs(d.cantidad) < inside_bar_cuttoff) & (d.cantidad <= -0.1), x: "cantidad", y: "area_observatorio", text: d => d3.format('+$.1f')(d.cantidad)+'M', textAnchor: 'end', dx: -gap -5, fontSize: 12, fill: 'black', fontWeight: 'bold', }), // Cambio neto labels Plot.text(thedata, { // filter: d => (d['tipo_cambio'] === 'aumento') & (Math.abs(d.cantidad) < inside_bar_cuttoff) & (d.cantidad >= 0.1), x: 0, y: "area_observatorio", text: d => d3.format('+$.1f')(d.cambio_neto)+'M', fill: d => d.cambio_neto === 0 ? 'black' : d.cambio_neto > 0 ? EA_COLORES_MAP['INDIGO'] : EA_COLORES_MAP['RED'], // textAnchor: 'start', dx: gap +5, fontSize: 12, fontWeight: 'bold', }), // Plot.ruleX([0]), // Plot.dot(thedata, { // x: 'cambio_neto', // y: 'area_observatorio', // fill: 'black', // }) ] }) return theplot; }3d:Tf0b,{ // return null let thedata = aq.from(comparativo_area) .filter(d => Math.abs(d.variacion_dol) >= 0.1) .derive({ 'tipo_cambio': d => d.variacion_dol > 0 ? 'aumento' : 'decremento', }) .objects(); // let thedata_long = aq.from(thedata) // .fold(['aumento','decremento'], {as: ['tipo_cambio', 'cantidad']}) // .objects(); const inside_bar_cuttoff = 35; const gap = 40; let theplot = Plot.plot({ caption: 'Fuentes: Junta de Supervisión Fiscal y análisis de Espacios Abiertos.', width: 1000, marginLeft: 260, marginRight: gap, color: { domain: ['aumento', 'decremento'], range: ['INDIGO', 'RED'].map(d => EA_COLORES_MAP[d]), }, x: { label: null, ticks: 0, }, y: { domain: thedata.map(d => d.area_observatorio), }, marks: [ // Plot.axisX({ // tickSize: 0, // label: null, // fontSize: 12, // fontFamily: 'jaf-bernino-sans', // fontVariant: 'tabular-nums', // tickFormat: d => d === 0 ? 0 : d3.format('+$.0f')(d)+'M', // }), Plot.axisY({ tickSize: 0, label: null, fontSize: 12, fontFamily: 'jaf-bernino-sans', tickPadding: gap+15, }), Plot.barX(thedata, { filter: d => d.tipo_cambio === 'aumento', x: "variacion_dol", y: "area_observatorio", z: 'tipo_cambio', fill: 'tipo_cambio', dx: gap, }), Plot.barX(thedata, { filter: d => d.tipo_cambio === 'decremento', x: "variacion_dol", y: "area_observatorio", z: 'tipo_cambio', fill: 'tipo_cambio', dx: -gap, }), // Labels: Monto aumento, dentro de la barra Plot.text(thedata, { filter: d => (d['tipo_cambio'] === 'aumento') & (Math.abs(d.variacion_dol) >= inside_bar_cuttoff), x: "variacion_dol", y: "area_observatorio", text: d => d3.format('+$.1f')(d.variacion_dol)+'M', textAnchor: 'end', dx: gap -5, fontSize: 12, fill: 'white', fontWeight: 'bold', }), // Labels: Monto aumento, fuera de la barra Plot.text(thedata, { filter: d => (d['tipo_cambio'] === 'aumento') & (Math.abs(d.variacion_dol) < inside_bar_cuttoff) & (d.variacion_dol >= 0.1), x: "variacion_dol", y: "area_observatorio", text: d => d3.format('+$.1f')(d.variacion_dol)+'M', textAnchor: 'start', dx: gap +5, fontSize: 12, fill: 'black', fontWeight: 'bold', }), // Labels: Monto decremento, dentro de la barra Plot.text(thedata, { filter: d => (d['tipo_cambio'] === 'decremento') & (Math.abs(d.variacion_dol) >= inside_bar_cuttoff), x: "variacion_dol", y: "area_observatorio", text: d => d3.format('+$.1f')(d.variacion_dol)+'M', textAnchor: 'start', dx: -gap +5, fontSize: 12, fill: 'white', fontWeight: 'bold', }), // Labels: Monto decremento, fuera de la barra Plot.text(thedata, { filter: d => (d['tipo_cambio'] === 'decremento') & (Math.abs(d.variacion_dol) < inside_bar_cuttoff) & (d.variacion_dol <= -0.1), x: "variacion_dol", y: "area_observatorio", text: d => d3.format('+$.1f')(d.variacion_dol)+'M', textAnchor: 'end', dx: -gap -5, fontSize: 12, fill: 'black', fontWeight: 'bold', }), // Cambio neto labels Plot.text(thedata, { x: 0, y: "area_observatorio", text: d => d3.format('+.1%')(d.variacion_pct), fill: d => d.variacion_pct === 0 ? 'black' : d.variacion_pct > 0 ? EA_COLORES_MAP['INDIGO'] : EA_COLORES_MAP['RED'], // textAnchor: 'start', dx: gap +5, fontSize: 12, fontWeight: 'bold', }), ] }) return theplot; }3e:Teff,{ // return null let thedata = aq.from(comparativo_concepto) .filter(d => Math.abs(d.variacion_dol) >= 0.1) .derive({ 'tipo_cambio': d => d.variacion_dol > 0 ? 'aumento' : 'decremento', }) .objects(); // let thedata_long = aq.from(thedata) // .fold(['aumento','decremento'], {as: ['tipo_cambio', 'cantidad']}) // .objects(); const inside_bar_cuttoff = 75; const gap = 40; let theplot = Plot.plot({ caption: 'Fuentes: Junta de Supervisión Fiscal y análisis de Espacios Abiertos.', width: 1000, marginLeft: 310, marginRight: gap, color: { domain: ['aumento', 'decremento'], range: ['INDIGO', 'RED'].map(d => EA_COLORES_MAP[d]), }, x: { label: null, ticks: 0, }, y: { domain: thedata.map(d => d.nombre_concepto), }, marks: [ // Plot.axisX({ // tickSize: 0, // label: null, // fontSize: 12, // fontFamily: 'jaf-bernino-sans', // fontVariant: 'tabular-nums', // tickFormat: d => d === 0 ? 0 : d3.format('+$.0f')(d)+'M', // }), Plot.axisY({ tickSize: 0, label: null, fontSize: 12, fontFamily: 'jaf-bernino-sans', tickPadding: gap+15, }), Plot.barX(thedata, { filter: d => d.tipo_cambio === 'aumento', x: "variacion_dol", y: "nombre_concepto", z: 'tipo_cambio', fill: 'tipo_cambio', dx: gap, }), Plot.barX(thedata, { filter: d => d.tipo_cambio === 'decremento', x: "variacion_dol", y: "nombre_concepto", z: 'tipo_cambio', fill: 'tipo_cambio', dx: -gap, }), // Labels: Monto aumento, dentro de la barra Plot.text(thedata, { filter: d => (d['tipo_cambio'] === 'aumento') & (Math.abs(d.variacion_dol) >= inside_bar_cuttoff), x: "variacion_dol", y: "nombre_concepto", text: d => d3.format('+$.1f')(d.variacion_dol)+'M', textAnchor: 'end', dx: gap -5, fontSize: 12, fill: 'white', fontWeight: 'bold', }), // Labels: Monto aumento, fuera de la barra Plot.text(thedata, { filter: d => (d['tipo_cambio'] === 'aumento') & (Math.abs(d.variacion_dol) < inside_bar_cuttoff) & (d.variacion_dol >= 0.1), x: "variacion_dol", y: "nombre_concepto", text: d => d3.format('+$.1f')(d.variacion_dol)+'M', textAnchor: 'start', dx: gap +5, fontSize: 12, fill: 'black', fontWeight: 'bold', }), // Labels: Monto decremento, dentro de la barra Plot.text(thedata, { filter: d => (d['tipo_cambio'] === 'decremento') & (Math.abs(d.variacion_dol) >= inside_bar_cuttoff), x: "variacion_dol", y: "nombre_concepto", text: d => d3.format('+$.1f')(d.variacion_dol)+'M', textAnchor: 'start', dx: -gap +5, fontSize: 12, fill: 'white', fontWeight: 'bold', }), // Labels: Monto decremento, fuera de la barra Plot.text(thedata, { filter: d => (d['tipo_cambio'] === 'decremento') & (Math.abs(d.variacion_dol) < inside_bar_cuttoff) & (d.variacion_dol <= -0.1), x: "variacion_dol", y: "nombre_concepto", text: d => d3.format('+$.1f')(d.variacion_dol)+'M', textAnchor: 'end', dx: -gap -5, fontSize: 12, fill: 'black', fontWeight: 'bold', }), // Cambio neto labels Plot.text(thedata, { x: 0, y: "nombre_concepto", text: d => d3.format('+.1%')(d.variacion_pct), fill: d => d.variacion_pct === 0 ? 'black' : d.variacion_pct > 0 ? EA_COLORES_MAP['INDIGO'] : EA_COLORES_MAP['RED'], // textAnchor: 'start', dx: gap +5, fontSize: 12, fontWeight: 'bold', }), ] }) return theplot; }3f:T1675,{ // return null let thedata = aq.from(comparativo_area_concepto) .filter(aq.escape(d => d['area_observatorio'] === select_area_1)) .filter(d => Math.abs(d.variacion_dol) >= 0.1) // depends on scale y como cambiamos area pues cambia .derive({ 'tipo_cambio': d => d.variacion_dol > 0 ? 'aumento' : 'decremento', }) .orderby('variacion_dol') .objects(); // let thedata_long = aq.from(thedata) // .fold(['aumento','decremento'], {as: ['tipo_cambio', 'cantidad']}) // .objects(); const chart_width = 1000; // keep const actual_marginLeft = 260; // keep const actual_marginRight = 0; const actual_tickPadding = 15; // keep. 15 is good. let barSpacing_left = 55; // changeable let barSpacing_right = 65; // changeable const inside_bar_cutoff_pixels = 60; // TODO: usando pixel-length de barra en vez del variacion dolares const variacion_extent = d3.extent(thedata, d => d.variacion_dol) const variacion_span = variacion_extent[1] - variacion_extent[0]; console.log('variacion_extent', variacion_extent) const inside_bar_cuttoff = 0; // start off at zero, pero hay que measure a bunch const gap = 40; // should stay constant. Remember, total gap width is actually 2x gap (-gap y +gap) const bar_pixels_span = chart_width - actual_marginLeft - actual_tickPadding - actual_marginRight - 2*gap - barSpacing_left - barSpacing_right; const bar_pixels_span_pos = bar_pixels_span * Math.abs(variacion_extent[1] / variacion_span); const bar_pixels_span_neg = bar_pixels_span * Math.abs(variacion_extent[0] / variacion_span); const bar_pixels_scale = d3.scaleLinear().domain([0, variacion_span]).range([0, bar_pixels_span]); const marginLeft = actual_marginLeft + gap + actual_tickPadding + barSpacing_left; const marginRight = actual_marginRight + gap + barSpacing_right; let theplot = Plot.plot({ // style: 'background-color: #eeeeee', // useful a lo que probamos margins and stuff caption: 'Fuentes: Junta de Supervisión Fiscal y análisis de Espacios Abiertos. ' + JSON.stringify(variacion_extent), width: chart_width, marginLeft: marginLeft, marginRight: marginRight, // add more as needed to fit labels, random: + 30ish? color: { domain: ['aumento', 'decremento'], range: ['INDIGO', 'RED'].map(d => EA_COLORES_MAP[d]), }, x: { label: null, ticks: 0, }, y: { domain: thedata.map(d => d.nombre_concepto), }, marks: [ // Plot.axisX({ // tickSize: 0, // label: null, // fontSize: 12, // fontFamily: 'jaf-bernino-sans', // fontVariant: 'tabular-nums', // tickFormat: d => d === 0 ? 0 : d3.format('+$.0f')(d)+'M', // }), Plot.axisY({ tickSize: 0, label: null, fontSize: 12, fontFamily: 'jaf-bernino-sans', tickPadding: gap + actual_tickPadding + barSpacing_left, // +15 on top of gap looks nice for margin }), Plot.barX(thedata, { filter: d => d.tipo_cambio === 'aumento', x: "variacion_dol", y: "nombre_concepto", z: 'tipo_cambio', fill: 'tipo_cambio', dx: gap, }), Plot.barX(thedata, { filter: d => d.tipo_cambio === 'decremento', x: "variacion_dol", y: "nombre_concepto", z: 'tipo_cambio', fill: 'tipo_cambio', dx: -gap, }), // Labels: Monto aumento, dentro de la barra Plot.text(thedata, { filter: d => (d['tipo_cambio'] === 'aumento') & (Math.abs(bar_pixels_scale(d.variacion_dol)) >= inside_bar_cutoff_pixels), x: "variacion_dol", y: "nombre_concepto", text: d => d3.format('+$.1f')(d.variacion_dol)+'M', textAnchor: 'end', dx: gap -5, fontSize: 12, fill: 'white', fontWeight: 'bold', }), // Labels: Monto aumento, fuera de la barra Plot.text(thedata, { filter: d => (d['tipo_cambio'] === 'aumento') & (Math.abs(bar_pixels_scale(d.variacion_dol)) < inside_bar_cutoff_pixels) // & (d.variacion_dol >= 0.1) , x: "variacion_dol", y: "nombre_concepto", text: d => d3.format('+$.1f')(d.variacion_dol)+'M', textAnchor: 'start', dx: gap +5, fontSize: 12, fill: 'black', fontWeight: 'bold', }), // Labels: Monto decremento, dentro de la barra Plot.text(thedata, { filter: d => (d['tipo_cambio'] === 'decremento') & (Math.abs(bar_pixels_scale(d.variacion_dol)) >= inside_bar_cutoff_pixels), x: "variacion_dol", y: "nombre_concepto", text: d => d3.format('+$.1f')(d.variacion_dol)+'M', textAnchor: 'start', dx: -gap +5, fontSize: 12, fill: 'white', fontWeight: 'bold', }), // Labels: Monto decremento, fuera de la barra Plot.text(thedata, { filter: d => (d['tipo_cambio'] === 'decremento') & (Math.abs(bar_pixels_scale(d.variacion_dol)) < inside_bar_cutoff_pixels) // & (d.variacion_dol <= -0.1) , x: "variacion_dol", y: "nombre_concepto", text: d => d3.format('+$.1f')(d.variacion_dol)+'M', textAnchor: 'end', dx: -gap -5, fontSize: 12, fill: 'black', fontWeight: 'bold', }), // Cambio neto labels Plot.text(thedata, { x: 0, y: "nombre_concepto", text: d => d3.format('+.1%')(d.variacion_pct), // text: d => '•', fill: d => d.variacion_pct === 0 ? 'black' : d.variacion_pct > 0 ? EA_COLORES_MAP['INDIGO'] : EA_COLORES_MAP['RED'], // textAnchor: 'start', dx: gap +5, fontSize: 12, fontWeight: 'bold', }), ] }) return theplot; }40:T1675,{ // return null let thedata = aq.from(comparativo_area_programa) .filter(aq.escape(d => d['area_observatorio'] === select_area_2)) .filter(d => Math.abs(d.variacion_dol) >= 0.1) // depends on scale y como cambiamos area pues cambia .derive({ 'tipo_cambio': d => d.variacion_dol > 0 ? 'aumento' : 'decremento', }) .orderby('variacion_dol') .objects(); // let thedata_long = aq.from(thedata) // .fold(['aumento','decremento'], {as: ['tipo_cambio', 'cantidad']}) // .objects(); const chart_width = 1000; // keep const actual_marginLeft = 260; // keep const actual_marginRight = 0; const actual_tickPadding = 15; // keep. 15 is good. let barSpacing_left = 55; // changeable let barSpacing_right = 65; // changeable const inside_bar_cutoff_pixels = 60; // TODO: usando pixel-length de barra en vez del variacion dolares const variacion_extent = d3.extent(thedata, d => d.variacion_dol) const variacion_span = variacion_extent[1] - variacion_extent[0]; console.log('variacion_extent', variacion_extent) const inside_bar_cuttoff = 0; // start off at zero, pero hay que measure a bunch const gap = 40; // should stay constant. Remember, total gap width is actually 2x gap (-gap y +gap) const bar_pixels_span = chart_width - actual_marginLeft - actual_tickPadding - actual_marginRight - 2*gap - barSpacing_left - barSpacing_right; const bar_pixels_span_pos = bar_pixels_span * Math.abs(variacion_extent[1] / variacion_span); const bar_pixels_span_neg = bar_pixels_span * Math.abs(variacion_extent[0] / variacion_span); const bar_pixels_scale = d3.scaleLinear().domain([0, variacion_span]).range([0, bar_pixels_span]); const marginLeft = actual_marginLeft + gap + actual_tickPadding + barSpacing_left; const marginRight = actual_marginRight + gap + barSpacing_right; let theplot = Plot.plot({ // style: 'background-color: #eeeeee', // useful a lo que probamos margins and stuff caption: 'Fuentes: Junta de Supervisión Fiscal y análisis de Espacios Abiertos. ' + JSON.stringify(variacion_extent), width: chart_width, marginLeft: marginLeft, marginRight: marginRight, // add more as needed to fit labels, random: + 30ish? color: { domain: ['aumento', 'decremento'], range: ['INDIGO', 'RED'].map(d => EA_COLORES_MAP[d]), }, x: { label: null, ticks: 0, }, y: { domain: thedata.map(d => d.nombre_programa), }, marks: [ // Plot.axisX({ // tickSize: 0, // label: null, // fontSize: 12, // fontFamily: 'jaf-bernino-sans', // fontVariant: 'tabular-nums', // tickFormat: d => d === 0 ? 0 : d3.format('+$.0f')(d)+'M', // }), Plot.axisY({ tickSize: 0, label: null, fontSize: 12, fontFamily: 'jaf-bernino-sans', tickPadding: gap + actual_tickPadding + barSpacing_left, // +15 on top of gap looks nice for margin }), Plot.barX(thedata, { filter: d => d.tipo_cambio === 'aumento', x: "variacion_dol", y: "nombre_programa", z: 'tipo_cambio', fill: 'tipo_cambio', dx: gap, }), Plot.barX(thedata, { filter: d => d.tipo_cambio === 'decremento', x: "variacion_dol", y: "nombre_programa", z: 'tipo_cambio', fill: 'tipo_cambio', dx: -gap, }), // Labels: Monto aumento, dentro de la barra Plot.text(thedata, { filter: d => (d['tipo_cambio'] === 'aumento') & (Math.abs(bar_pixels_scale(d.variacion_dol)) >= inside_bar_cutoff_pixels), x: "variacion_dol", y: "nombre_programa", text: d => d3.format('+$.1f')(d.variacion_dol)+'M', textAnchor: 'end', dx: gap -5, fontSize: 12, fill: 'white', fontWeight: 'bold', }), // Labels: Monto aumento, fuera de la barra Plot.text(thedata, { filter: d => (d['tipo_cambio'] === 'aumento') & (Math.abs(bar_pixels_scale(d.variacion_dol)) < inside_bar_cutoff_pixels) // & (d.variacion_dol >= 0.1) , x: "variacion_dol", y: "nombre_programa", text: d => d3.format('+$.1f')(d.variacion_dol)+'M', textAnchor: 'start', dx: gap +5, fontSize: 12, fill: 'black', fontWeight: 'bold', }), // Labels: Monto decremento, dentro de la barra Plot.text(thedata, { filter: d => (d['tipo_cambio'] === 'decremento') & (Math.abs(bar_pixels_scale(d.variacion_dol)) >= inside_bar_cutoff_pixels), x: "variacion_dol", y: "nombre_programa", text: d => d3.format('+$.1f')(d.variacion_dol)+'M', textAnchor: 'start', dx: -gap +5, fontSize: 12, fill: 'white', fontWeight: 'bold', }), // Labels: Monto decremento, fuera de la barra Plot.text(thedata, { filter: d => (d['tipo_cambio'] === 'decremento') & (Math.abs(bar_pixels_scale(d.variacion_dol)) < inside_bar_cutoff_pixels) // & (d.variacion_dol <= -0.1) , x: "variacion_dol", y: "nombre_programa", text: d => d3.format('+$.1f')(d.variacion_dol)+'M', textAnchor: 'end', dx: -gap -5, fontSize: 12, fill: 'black', fontWeight: 'bold', }), // Cambio neto labels Plot.text(thedata, { x: 0, y: "nombre_programa", text: d => d3.format('+.1%')(d.variacion_pct), // text: d => '•', fill: d => d.variacion_pct === 0 ? 'black' : d.variacion_pct > 0 ? EA_COLORES_MAP['INDIGO'] : EA_COLORES_MAP['RED'], // textAnchor: 'start', dx: gap +5, fontSize: 12, fontWeight: 'bold', }), ] }) return theplot; }41:T1689,{ // return null let thedata = aq.from(comparativo_area_descripcion) .filter(aq.escape(d => d['area_observatorio'] === select_area_3)) .filter(d => Math.abs(d.variacion_dol) >= 0.1) // depends on scale y como cambiamos area pues cambia .derive({ 'tipo_cambio': d => d.variacion_dol > 0 ? 'aumento' : 'decremento', }) .orderby('variacion_dol') .objects(); // let thedata_long = aq.from(thedata) // .fold(['aumento','decremento'], {as: ['tipo_cambio', 'cantidad']}) // .objects(); const chart_width = 1000; // keep const actual_marginLeft = 350; // keep const actual_marginRight = 0; const actual_tickPadding = 15; // keep. 15 is good. let barSpacing_left = 55; // changeable let barSpacing_right = 65; // changeable const inside_bar_cutoff_pixels = 60; // TODO: usando pixel-length de barra en vez del variacion dolares const variacion_extent = d3.extent(thedata, d => d.variacion_dol) const variacion_span = variacion_extent[1] - variacion_extent[0]; console.log('variacion_extent', variacion_extent) const inside_bar_cuttoff = 0; // start off at zero, pero hay que measure a bunch const gap = 40; // should stay constant. Remember, total gap width is actually 2x gap (-gap y +gap) const bar_pixels_span = chart_width - actual_marginLeft - actual_tickPadding - actual_marginRight - 2*gap - barSpacing_left - barSpacing_right; const bar_pixels_span_pos = bar_pixels_span * Math.abs(variacion_extent[1] / variacion_span); const bar_pixels_span_neg = bar_pixels_span * Math.abs(variacion_extent[0] / variacion_span); const bar_pixels_scale = d3.scaleLinear().domain([0, variacion_span]).range([0, bar_pixels_span]); const marginLeft = actual_marginLeft + gap + actual_tickPadding + barSpacing_left; const marginRight = actual_marginRight + gap + barSpacing_right; let theplot = Plot.plot({ // style: 'background-color: #eeeeee', // useful a lo que probamos margins and stuff caption: 'Fuentes: Junta de Supervisión Fiscal y análisis de Espacios Abiertos. ' + JSON.stringify(variacion_extent), width: chart_width, marginLeft: marginLeft, marginRight: marginRight, // add more as needed to fit labels, random: + 30ish? color: { domain: ['aumento', 'decremento'], range: ['INDIGO', 'RED'].map(d => EA_COLORES_MAP[d]), }, x: { label: null, ticks: 0, }, y: { domain: thedata.map(d => d.descripcion), }, marks: [ // Plot.axisX({ // tickSize: 0, // label: null, // fontSize: 12, // fontFamily: 'jaf-bernino-sans', // fontVariant: 'tabular-nums', // tickFormat: d => d === 0 ? 0 : d3.format('+$.0f')(d)+'M', // }), Plot.axisY({ tickSize: 0, label: null, fontSize: 12, fontFamily: 'jaf-bernino-sans', tickPadding: gap + actual_tickPadding + barSpacing_left, // +15 on top of gap looks nice for margin }), Plot.barX(thedata, { filter: d => d.tipo_cambio === 'aumento', x: "variacion_dol", y: "descripcion", z: 'tipo_cambio', fill: 'tipo_cambio', dx: gap, }), Plot.barX(thedata, { filter: d => d.tipo_cambio === 'decremento', x: "variacion_dol", y: "descripcion", z: 'tipo_cambio', fill: 'tipo_cambio', dx: -gap, }), // Labels: Monto aumento, dentro de la barra Plot.text(thedata, { filter: d => (d['tipo_cambio'] === 'aumento') & (Math.abs(bar_pixels_scale(d.variacion_dol)) >= inside_bar_cutoff_pixels), x: "variacion_dol", y: "descripcion", text: d => d3.format('+$.1f')(d.variacion_dol)+'M', textAnchor: 'end', dx: gap -5, fontSize: 12, fill: 'white', fontWeight: 'bold', }), // Labels: Monto aumento, fuera de la barra Plot.text(thedata, { filter: d => (d['tipo_cambio'] === 'aumento') & (Math.abs(bar_pixels_scale(d.variacion_dol)) < inside_bar_cutoff_pixels) // & (d.variacion_dol >= 0.1) , x: "variacion_dol", y: "descripcion", text: d => d3.format('+$.1f')(d.variacion_dol)+'M', textAnchor: 'start', dx: gap +5, fontSize: 12, fill: 'black', fontWeight: 'bold', }), // Labels: Monto decremento, dentro de la barra Plot.text(thedata, { filter: d => (d['tipo_cambio'] === 'decremento') & (Math.abs(bar_pixels_scale(d.variacion_dol)) >= inside_bar_cutoff_pixels), x: "variacion_dol", y: "descripcion", text: d => d3.format('+$.1f')(d.variacion_dol)+'M', textAnchor: 'start', dx: -gap +5, fontSize: 12, fill: 'white', fontWeight: 'bold', }), // Labels: Monto decremento, fuera de la barra Plot.text(thedata, { filter: d => (d['tipo_cambio'] === 'decremento') & (Math.abs(bar_pixels_scale(d.variacion_dol)) < inside_bar_cutoff_pixels) // & (d.variacion_dol <= -0.1) , x: "variacion_dol", y: "descripcion", text: d => d3.format('+$.1f')(d.variacion_dol)+'M', textAnchor: 'end', dx: -gap -5, fontSize: 12, fill: 'black', fontWeight: 'bold', }), // Cambio neto labels Plot.text(thedata, { filter: d => d['2025_version_01'] !== 0, x: 0, y: "descripcion", text: d => d3.format('+.1%')(d.variacion_pct), // text: d => '•', fill: d => d.variacion_pct === 0 ? 'black' : d.variacion_pct > 0 ? EA_COLORES_MAP['INDIGO'] : EA_COLORES_MAP['RED'], // textAnchor: 'start', dx: gap +5, fontSize: 12, fontWeight: 'bold', }), ] }) return theplot; }42:T46b,comparativo_area_concepto = { const group_cols = ['Nombre Area Observatorio', 'Nombre Concepto'] let thedata = aq.from(sabana) .filter(d => d['Fondo'] === 'Subtotal Fondo General') .filter( d => (d['2025_version_01'] > 0) | (d['2025_version_02'] > 0) ) .groupby(group_cols) .rollup({ '2025_version_01': op.sum('2025_version_01'), '2025_version_02': op.sum('2025_version_02'), }) .derive({ 'Variacion': d => (d['2025_version_02'] - d['2025_version_01']), }) .derive({ 'Variacion %': aq.escape(d => (d['2025_version_01'] !== 0n) ? ( Number(d['Variacion']) / Number(d['2025_version_01']) ) : null), }) .orderby(group_cols) .rename({ 'Nombre Area Observatorio': 'area_observatorio', 'Nombre Concepto': 'nombre_concepto', 'Variacion': 'variacion_dol', 'Variacion %': 'variacion_pct', }) .objects() const cols_scale = ['variacion_dol', '2025_version_01', '2025_version_02']; thedata.forEach(d => { for (let c of cols_scale) { d[c] = Number(d[c]) / 1e3 // miles a millones } }) return thedata }43:T46b,comparativo_area_programa = { const group_cols = ['Nombre Area Observatorio', 'Nombre Programa'] let thedata = aq.from(sabana) .filter(d => d['Fondo'] === 'Subtotal Fondo General') .filter( d => (d['2025_version_01'] > 0) | (d['2025_version_02'] > 0) ) .groupby(group_cols) .rollup({ '2025_version_01': op.sum('2025_version_01'), '2025_version_02': op.sum('2025_version_02'), }) .derive({ 'Variacion': d => (d['2025_version_02'] - d['2025_version_01']), }) .derive({ 'Variacion %': aq.escape(d => (d['2025_version_01'] !== 0n) ? ( Number(d['Variacion']) / Number(d['2025_version_01']) ) : null), }) .orderby(group_cols) .rename({ 'Nombre Area Observatorio': 'area_observatorio', 'Nombre Programa': 'nombre_programa', 'Variacion': 'variacion_dol', 'Variacion %': 'variacion_pct', }) .objects() const cols_scale = ['variacion_dol', '2025_version_01', '2025_version_02']; thedata.forEach(d => { for (let c of cols_scale) { d[c] = Number(d[c]) / 1e3 // miles a millones } }) return thedata }44:T462,comparativo_area_descripcion = { const group_cols = ['Nombre Area Observatorio', 'DESCRIPCION'] let thedata = aq.from(sabana) .filter(d => d['Fondo'] === 'Subtotal Fondo General') .filter( d => (d['2025_version_01'] > 0) | (d['2025_version_02'] > 0) ) .groupby(group_cols) .rollup({ '2025_version_01': op.sum('2025_version_01'), '2025_version_02': op.sum('2025_version_02'), }) .derive({ 'Variacion': d => (d['2025_version_02'] - d['2025_version_01']), }) .derive({ 'Variacion %': aq.escape(d => (d['2025_version_01'] !== 0n) ? ( Number(d['Variacion']) / Number(d['2025_version_01']) ) : null), }) .orderby(group_cols) .rename({ 'Nombre Area Observatorio': 'area_observatorio', 'DESCRIPCION': 'descripcion', 'Variacion': 'variacion_dol', 'Variacion %': 'variacion_pct', }) .objects() const cols_scale = ['variacion_dol', '2025_version_01', '2025_version_02']; thedata.forEach(d => { for (let c of cols_scale) { d[c] = Number(d[c]) / 1e3 // miles a millones } }) return thedata }45:[{"id":"53588068d39a8542ab7b1fccf8af6a6bf00167813ecae763397dfdef3c51d237e675be1d6518e3ec68e87123b308687e82e90913e0662c12b76885e730d0d2e5","href":"https://static.observableusercontent.com/files/53588068d39a8542ab7b1fccf8af6a6bf00167813ecae763397dfdef3c51d237e675be1d6518e3ec68e87123b308687e82e90913e0662c12b76885e730d0d2e5","name":"Analysis_FOMB_NoV_05212024@5.xlsx","type":"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet","lastModified":1716391976395.662,"size":28579},{"id":"d605b0b625db65039982200c1e1bee069e08fa9463cce0448647dcca53864492a65028bb7b3c1d4d9e3ed391bec1ff25758a0086af08fdc4e9f3a210bf82611f","href":"https://static.observableusercontent.com/files/d605b0b625db65039982200c1e1bee069e08fa9463cce0448647dcca53864492a65028bb7b3c1d4d9e3ed391bec1ff25758a0086af08fdc4e9f3a210bf82611f","name":"fondo_general_area_observatorio_agencia.xlsx","type":"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet","lastModified":1717004319595.182,"size":11314},{"id":"b71c9ed71f3ce9006ad10f4d288865509a0357f5999d5efef984a5e94535b9950c70632f0f694b19fa3475782b8cde8ab15862ab7f2966d9270ffda6d013b373","href":"https://static.observableusercontent.com/files/b71c9ed71f3ce9006ad10f4d288865509a0357f5999d5efef984a5e94535b9950c70632f0f694b19fa3475782b8cde8ab15862ab7f2966d9270ffda6d013b373","name":"fondo_general_concepto_descripcion.xlsx","type":"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet","lastModified":1717006897152.05,"size":17201},{"id":"f47721805312c1b8d5c46e576834aadc055d777cffec8820c9f2f3d1f9753766279cf32f9d3a41f74e27be633e3bb5bce43c7d7d051d8d46f43bcead6d1aa3f1","href":"https://static.observableusercontent.com/files/f47721805312c1b8d5c46e576834aadc055d777cffec8820c9f2f3d1f9753766279cf32f9d3a41f74e27be633e3bb5bce43c7d7d051d8d46f43bcead6d1aa3f1","name":"sabana_with_area.parquet","type":"application/octet-stream","lastModified":1717082019777.08,"size":987565},{"id":"851134ed903ca5f733216bbeea14bca0e6619494ddfd9cda35250c9d31d1538d4a62b3c1d0295318abcdae3c559013d77fa558d4b57f00a85a5bf1e5cabcd22f","href":"https://static.observableusercontent.com/files/851134ed903ca5f733216bbeea14bca0e6619494ddfd9cda35250c9d31d1538d4a62b3c1d0295318abcdae3c559013d77fa558d4b57f00a85a5bf1e5cabcd22f","name":"Analysis_FOMB_NoV_05202024.xlsx","type":"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet","lastModified":1716234419418.499,"size":23444},{"id":"e14e60e52205360da34cf32faaea19722253953427a988a26096d086ae4facdd49f86dcbb0839d41ad60a62ba6499e2427b78e43d09b0cd8c0f1af33d21f56df","href":"https://static.observableusercontent.com/files/e14e60e52205360da34cf32faaea19722253953427a988a26096d086ae4facdd49f86dcbb0839d41ad60a62ba6499e2427b78e43d09b0cd8c0f1af33d21f56df","name":"Analysis_FOMB_NoV_05212024.xlsx","type":"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet","lastModified":1716308763088.137,"size":22142},{"id":"f669d504e4897e6eff8a5200e014371a2ed3ffa2a01fdd176bc96c43fbf949bb13eabc875f9d6d83f57845071eba21c6f32645a426e4a8861d484afff33cab67","href":"https://static.observableusercontent.com/files/f669d504e4897e6eff8a5200e014371a2ed3ffa2a01fdd176bc96c43fbf949bb13eabc875f9d6d83f57845071eba21c6f32645a426e4a8861d484afff33cab67","name":"Analysis_FOMB_NoV_05212024@1.xlsx","type":"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet","lastModified":1716309505795.75,"size":23875},{"id":"6e8392c282c5264ead082659174eae77b5b635324f1dd8eacc184aaba7b85c70f2c814bb1a3e92a9f9f7edb85453549187067e0f77806adf591f8d03928300d6","href":"https://static.observableusercontent.com/files/6e8392c282c5264ead082659174eae77b5b635324f1dd8eacc184aaba7b85c70f2c814bb1a3e92a9f9f7edb85453549187067e0f77806adf591f8d03928300d6","name":"Analysis_FOMB_NoV_05212024@2.xlsx","type":"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet","lastModified":1716316915614.591,"size":26054},{"id":"b67a9acc56116df802bcdec0fbe70562dd28472059941b6c86886999136c69bc083efec18f28bef52e0db100cec9f2a8cc782e41fd0d26699037e51a3ada6354","href":"https://static.observableusercontent.com/files/b67a9acc56116df802bcdec0fbe70562dd28472059941b6c86886999136c69bc083efec18f28bef52e0db100cec9f2a8cc782e41fd0d26699037e51a3ada6354","name":"Analysis_FOMB_NoV_05212024@3.xlsx","type":"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet","lastModified":1716317817186.322,"size":27549},{"id":"48be4525bb6a177ce92a6d327c147bf0da8d824eca4d73161bf78d511284c31156a1514c4d0539f28c8d38e5db756a9b31d3f90167497f1823c2cfaa65881e5b","href":"https://static.observableusercontent.com/files/48be4525bb6a177ce92a6d327c147bf0da8d824eca4d73161bf78d511284c31156a1514c4d0539f28c8d38e5db756a9b31d3f90167497f1823c2cfaa65881e5b","name":"Analysis_FOMB_NoV_05212024@4.xlsx","type":"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet","lastModified":1716320610427.72,"size":27624}] 2f:{"id":"ade58ee2d1fda4dc","slug":null,"title":"FOMB PR: Notice 2024","thumbnail":"8436595253514b6662269938f2be8b2ecab417637cf267f4d8d6f4e591430ea0","access_level":"public","create_time":"$D2024-05-20T17:27:38.885Z","update_time":"$D2024-06-18T18:10:09.536Z","view_time":null,"first_public_time":"$D2024-05-20T19:22:52.917Z","fork":false,"stars":0,"starred":false,"owner":{"type":"team","id":"247b19faa48b7d89","login":"jzavala-gonzalez","name":"José M. Zavala González","avatar_url":"https://avatars-next.observableusercontent.com/c80357963553ac341ea90ed3d79296a72d004aa90d9b89afd76f17e04dcf9277","tier":"starter_2024"},"version":1013,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"2c62f0243f8f45b0","login":"jzavala-gonzalez","name":"José M. Zavala González","avatar_url":"https://avatars-next.observableusercontent.com/c80357963553ac341ea90ed3d79296a72d004aa90d9b89afd76f17e04dcf9277","tier":null}],"members":[{"type":"team","id":"247b19faa48b7d89","login":"jzavala-gonzalez","name":"José M. Zavala González","avatar_url":"https://avatars-next.observableusercontent.com/c80357963553ac341ea90ed3d79296a72d004aa90d9b89afd76f17e04dcf9277","tier":"starter_2024","role":"editor"},{"type":"individual","id":"2c62f0243f8f45b0","login":"jzavala-gonzalez","name":"José M. Zavala González","avatar_url":"https://avatars-next.observableusercontent.com/c80357963553ac341ea90ed3d79296a72d004aa90d9b89afd76f17e04dcf9277","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":2,"collection":{"id":"6747c4e5c0f5d653","slug":"espacios-abiertos","title":"Espacios Abiertos","owner":{"id":"247b19faa48b7d89","login":"jzavala-gonzalez","name":"José M. Zavala González"}},"type":"notebook","body":{"title":"FOMB PR: Notice 2024","cells":[{"id":0,"value":"# FOMB PR: Notice 2024","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":62,"value":"viewof show_partial = Inputs.toggle({label: \"Show partial\", value: false})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":10,"value":"$31","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":99,"value":"partida_labels = Object({\n 'Inicial': 'Presupuesto del Ejecutivo',\n 'Revisado con aumento': 'Revisado\\ncon aumento',\n 'Revisado con decremento': 'Revisado\\ncon decremento',\n 'Parcialmente aprobado': 'Paricialmente\\naprobado',\n 'Total': 'Presupuesto de la Junta',\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":141,"value":"## Partidas denegadas temporeramente por la Junta de Supervisión Fiscal","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":116,"value":"$32","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":895,"value":"$33","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":200,"value":"## Partidas denegadas permanentemente por la Junta de Supervisión Fiscal","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":203,"value":"$34","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":920,"value":"$35","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":280,"value":"## Partidas revisadas por la Junta de Supervisión Fiscal","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":282,"value":"$36","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":968,"value":"$37","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":880,"value":"$38","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":304,"value":"## Partidas aprobadas por la Junta de Supervisión Fiscal","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":324,"value":"$39","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":878,"value":"$3a","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":311,"value":"$3b","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":519,"value":"## Reordenación de las prioridades presupuestarias de la Junta de Supervisión Fiscal","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":420,"value":"$3c","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":534,"value":"# Reordenaciones más recientes por área presupuestaria","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":536,"value":"$3d","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":581,"value":"# Reordenaciones más recientes por concepto de gasto","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":569,"value":"$3e","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":583,"value":"# Area-concepto para área de ${select_area_1}","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":670,"value":"listado_areas_1 = Array.from(new Set(comparativo_area_concepto\n.filter(d => (d.Variacion !== 0) & (Math.abs(d.variacion_dol) >= 0.1))\n.map(d => d['area_observatorio'])))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":650,"value":"viewof select_area_1 = Inputs.select(listado_areas_1, {label: \"Elige una\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":684,"value":"$3f","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":586,"value":"# Area-programa para área de ${select_area_2}","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":680,"value":"listado_areas_2 = Array.from(new Set(comparativo_area_programa\n.filter(d => (d.Variacion !== 0) & (Math.abs(d.variacion_dol) >= 0.1))\n.map(d => d['area_observatorio'])))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":837,"value":"viewof select_area_2 = Inputs.select(listado_areas_2, {label: \"Elige una\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":835,"value":"$40","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":853,"value":"# Area-descripción para área de ${select_area_3}","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":862,"value":"listado_areas_3 = Array.from(new Set(comparativo_area_descripcion\n.filter(d => (d.Variacion !== 0) & (Math.abs(d.variacion_dol) >= 0.1))\n.map(d => d['area_observatorio'])))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":860,"value":"viewof select_area_3 = Inputs.select(listado_areas_3, {label: \"Elige una\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":864,"value":"$41","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":509,"value":"htl.html`\n\n`","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":652,"value":"aq.from(comparativo_area_concepto).view(300)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":613,"value":"$42","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":839,"value":"aq.from(comparativo_area_programa).view()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":648,"value":"$43","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":857,"value":"aq.from(comparativo_area_descripcion)\n .filter(d => d.area_observatorio === 'Educación')\n .view()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":855,"value":"$44","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":591,"value":"from sabana","pinned":true,"hidden":false,"mode":"sql","author":"$undefined","summary":"$undefined","output":"sabana","database":"var:db"},{"id":444,"value":"aq.from(cambios_por_area)\n.fold(['aumento','decremento'], {as: ['tipo_cambio', 'cantidad']})\n .view()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":163,"value":"80.23 / 396.23","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":398,"value":"aq.from(all_items)\n .filter(d => d.area_observatorio === 'Educación')\n .orderby('cantidad')\n.view()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":418,"value":"aq.from(cambios_por_area).view()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":346,"value":"cambios_por_area = aq.from(all_items)\n .derive({\n 'tipo_cambio': d => {\n const sign = Math.sign(d.cantidad);\n if (sign === 1) {\n return 'aumento'\n } else if (sign === -1) {\n return 'decremento'\n } else {\n return 'ninguno'\n }\n }\n })\n .groupby('area_observatorio', 'tipo_cambio')\n .rollup({\n 'cantidad': op.sum('cantidad')\n })\n .groupby('area_observatorio')\n .pivot('tipo_cambio', 'cantidad')\n .impute({ aumento: () => 0, decremento: () => 0 })\n .derive({\n 'cambio_neto': d => d.aumento + d.decremento,\n })\n .orderby('cambio_neto')\n .objects()\n\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":375,"value":"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":357,"value":"Math.sign(0)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":344,"value":"# Apéndice","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":605,"value":"import {DuckDBClientKL} from \"@kimmolinna/duckdbclient\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":594,"value":"// db = DuckDBClientKL.of({\ndb = DuckDBClient.of({\n sabana: FileAttachment(\"sabana_with_area.parquet\")\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":538,"value":"comparativo_area = aq.from(comparativo_area_agencia)\n.groupby('area_observatorio')\n .rollup({\n '2025_version_01': op.sum('2025_version_01'),\n '2025_version_02': op.sum('2025_version_02'),\n 'variacion_dol': op.sum('variacion_dol'),\n })\n .derive({\n 'variacion_pct': d => d.variacion_dol / d['2025_version_01']\n })\n .orderby('variacion_dol')\n.objects()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":529,"value":"comparativo_area_agencia = {\n let workbook = await FileAttachment('fondo_general_area_observatorio_agencia.xlsx').xlsx()\n let data = workbook.sheet('Sheet1', {headers: true})\n data = aq.from(data)\n .rename({\n 'Nombre Area Observatorio': 'area_observatorio',\n 'Nombre Agencia': 'nombre',\n 'Variacion': 'variacion_dol',\n 'Variacion %': 'variacion_pct',\n })\n .derive({\n '2025_version_01': d => d['2025_version_01'] / 1e3,\n '2025_version_02': d => d['2025_version_02'] / 1e3,\n 'variacion_dol': d => d.variacion_dol / 1e3, // cambiar de miles a millones\n })\n .objects();\n return data\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":567,"value":"comparativo_concepto = aq.from(comparativo_concepto_descripcion)\n.groupby('nombre_concepto')\n .rollup({\n '2025_version_01': op.sum('2025_version_01'),\n '2025_version_02': op.sum('2025_version_02'),\n 'variacion_dol': op.sum('variacion_dol'),\n })\n .derive({\n 'variacion_pct': d => d.variacion_dol / d['2025_version_01']\n })\n .orderby('variacion_dol')\n.objects()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":564,"value":"comparativo_concepto_descripcion = {\n let workbook = await FileAttachment('fondo_general_concepto_descripcion.xlsx').xlsx()\n let data = workbook.sheet('Sheet1', {headers: true})\n data = aq.from(data)\n .rename({\n 'Nombre Concepto': 'nombre_concepto',\n 'DESCRIPCION': 'descripcion',\n 'Variacion': 'variacion_dol',\n 'Variacion %': 'variacion_pct',\n })\n .derive({\n '2025_version_01': d => d['2025_version_01'] / 1e3,\n '2025_version_02': d => d['2025_version_02'] / 1e3,\n 'variacion_dol': d => d.variacion_dol / 1e3, // cambiar de miles a millones\n })\n .objects();\n return data\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":109,"value":"workbook = FileAttachment(\"Analysis_FOMB_NoV_05212024@5.xlsx\").xlsx()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":110,"value":"workbook.sheetNames","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":111,"value":"denied_items = {\n let data = workbook.sheet('denied', {\n headers: true,\n // range: \"A1:J10\"\n })\n\n data.forEach(d => {\n d.status = 'denied';\n d.label = d.nombre\n if (d.bajo_custodia) {\n d.label += '*'\n }\n })\n return data\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":190,"value":"partially_approved_items = {\n let data = workbook.sheet('partially_approved', {\n headers: true,\n // range: \"A1:J10\"\n })\n\n data.forEach(d => {\n d.status = 'partially_approved';\n d.label = d.nombre\n if (d.bajo_custodia) {\n d.label += '*'\n }\n })\n return data\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":309,"value":"approved_items = {\n let data = workbook.sheet('approved', {\n headers: true,\n // range: \"A1:J10\"\n })\n\n data.forEach(d => {\n d.status = 'approved';\n d.label = d.nombre\n if (d.bajo_custodia) {\n d.label += '*'\n }\n })\n return data\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":277,"value":"readjusted_items = {\n let data = workbook.sheet('reajustes', {\n headers: true,\n // range: \"A1:J10\"\n })\n\n data.forEach(d => {\n d.status = 'readjusted';\n d.label = d.nombre\n if (d.bajo_custodia) {\n d.label += '*'\n }\n })\n return data\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":338,"value":"all_items = [\n ...denied_items,\n ...partially_approved_items,\n ...approved_items,\n ...readjusted_items,\n]","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":16,"value":"fmt = n => d3.format(\",d\")(n)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":14,"value":"plotLabel = (data, dy) => \n Plot.text(data, {\n x: \"partida\",\n y: \"accu\",\n dy: dy, \n //frameAnchor: anchor,\n fontWeight: \"bold\",\n text: d => d3.format(\"$,.1f\")(d.accu)+'M',\n fontSize: 16, // stroke: 'none', fill: 'white',\n fontVariant: 'tabular-nums',\n fontFamily: 'jaf-bernino-sans',\n })","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":5,"value":"waterfall = function f(numbers,accu_start, name) {\n let last = 0, accu = accu_start; \n let waterfall = numbers.map((d, i) => {\n last = accu;\n accu += d.profit;\n return {\n [name]: d[name],\n nextDay: i < (numbers.length - 1) ? numbers[i + 1][name] : \"Total\",\n prior: last,\n accu: accu,\n profit: d.profit\n };\n });\n\n waterfall = [\n {\n [name]: \"Inicial\",\n nextDay: numbers[0][name],\n prior: accu_start,\n accu: accu_start,\n profit: 0\n },\n ...waterfall,\n {\n [name]: \"Total\",\n nextDay: null,\n prior: accu_start,\n accu: accu,\n profit: 0\n }\n ]\n \n // waterfall.push({\n // partida: \"Total\",\n // nextDay: null,\n // prior: accu_start,\n // accu: accu,\n // profit: 0\n // });\n \n return waterfall;\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":74,"value":"waterfall(\n fomb_adjustment.filter(d => (d.partida !== 'Partial') | show_partial)\n .map(d => Object({...d, profit: d.cantidad})), 13062.30 ,'partida')","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":7,"value":"fomb_adjustment = [\n {partida: 'En cumplimiento', cantidad: 130.70},\n {partida: 'Revisado con aumento', cantidad: 291.09},\n {partida: 'Revisado con decremento', cantidad: -20.72},\n {partida: 'Denegado', cantidad: -396.96},\n {partida: 'Parcialmente aprobado', cantidad: -118.90, partial: true},\n]","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":34,"value":"fonts_link = \"https://use.typekit.net/szl4srx.css\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":36,"value":"fonts_link_element = \n// Importante para ver los fonts en el editor de Observable (o sea aqui)\nhtl.html`\n\n`","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":38,"value":"estilos = htl.html`\n\n`","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":138,"value":"import { EA_COLORES_MAP} from \"22dc6182207c44c8\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":352,"value":"import {aq, op} from '@uwdata/arquero';","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W45","stdlib":"1","titling":"auto"}} 30:"$2f:body"