31:Taea,treemapChart = (flatData, chartWidth, chartHeight) => { const margin = 0 const hierarched = hierarchyTransform(flatData) // scale factor ensures overall treemap chart in graphic is sized proportionally to largest // dx and dy center the scaled graphic in the canvas const scale = Math.sqrt(hierarched.value / treemapBucketMaxValue) const dx = 0.5*chartWidth*(1 - scale) const dy = 0.5*chartHeight*(1 - scale) const root = d3.treemap() .tile(d3.treemapBinary) // .size([chartWidth - 2*margin, chartHeight - 2*margin]) .size([chartWidth*scale, chartHeight*scale]) .padding(1) .round(true) (hierarched) // adapted from https://observablehq.com/@jianan-li/basic-tooltip const tooltip = d3.select("body").append("div") .attr("class", "svg-tooltip") .style("position","absolute") .style("visibility","hidden") .text("Default text") const svg = d3.create("svg") .attr("viewBox", [0, 0, chartWidth, chartHeight]) .style("font", "10px sans-serif") const leaf = svg .append('g') .attr('transform', `translate(${dx},${dy})`) .selectAll("g") .data(root.leaves()) .join("g") .attr("transform", d => `translate(${d.x0},${d.y0})`); // leaf.append("title") // .text(d => `${d.ancestors().reverse().map(d => d.data.name).join("/")}\n${format(d.value)}`); leaf.append("rect") .attr('class','hoverable') .attr("id", d => (d.leafUid = DOM.uid("leaf")).id) .attr("fill", d => { while (d.depth > 1) d = d.parent; return color(d.data[0]); }) .attr("fill-opacity", 0.7) .attr('stroke', d => { while (d.depth > 1) d = d.parent; return color(d.data[0]); }) // .attr('stroke-width', 1/scale) // .attr('stroke','white') .attr("width", d => d.x1 - d.x0) .attr("height", d => d.y1 - d.y0) .on("mouseover", event => tooltip.style("visibility", "visible")) .on("mousemove", event => updateTooltip(tooltip, event)) .on("mouseout", event => tooltip.style("visibility", "hidden")) leaf.append("clipPath") .attr("id", d => (d.clipUid = DOM.uid("clip")).id) .append("use") .attr("xlink:href", d => d.leafUid.href); leaf .filter(d => (scale * (d.x1 - d.x0) >= 60) && (scale * (d.y1 - d.y0) >= 30)) .append('g') .append("text") .attr("clip-path", d => d.clipUid) .selectAll("tspan") .filter(d => false) .data(d => d.data.label.split(/(?=[A-Z][a-z])|\s+/g).concat(format(d.value))) .join("tspan") .style('pointer-events','none') .attr("x", 3) .attr("y", (d, i, nodes) => `${(i === nodes.length - 1) * 0.3 + 1.1 + i * 0.9}em`) .attr("fill-opacity", (d, i, nodes) => i === nodes.length - 1 ? 0.7 : null) .text(d => d); return svg.node(); }32:T919,embed1 = { const bucketHeight = 200 return html` ${style}

What state government plans to spend

Amounts budgeted by the 2021 Montana Legislature.

${await legend()}

Routine state budget

Hover over or tap each budget category for more detail.

${format(d3.sum(hb2Budget, d => d.amount))} — Fiscal Year 2022 and 2023 agency budgets

${percentFormat(federalFraction.hb2Budget)} from federal funding

${await treemapChart(hb2Budget, colWidth, bucketHeight)}

Spending included in the main state budget bill, House Bill 2.

${format(d3.sum(longRangeBudget, d => d.amount))} — State infrastructure programs

${percentFormat(federalFraction.longRangeBudget)} from federal funding

${await treemapChart(longRangeBudget, colWidth, bucketHeight)}

Spending authorized in 2021 via House Bills 5, 6, 7, 8, 9, 10, 11, 12 and 14. Excludes spending backfilled from ARPA, below.

Federal COVID-19 stimulus

${format(d3.sum(cares2Budget, d => d.amount))} — CARES II allocation

All federal funding

${await treemapChart(cares2Budget, colWidth, bucketHeight)}

State spending from the December 2020 federal covid relief package, allocated via House Bills 3 and 630. Money from the initial CARES Act was allocated by former Gov. Steve Bullock.

${format(d3.sum(arpaBudget, d => d.amount))} — American Rescue Plan Act (ARPA) allocation

All federal funding

${await treemapChart(arpaBudget, colWidth, bucketHeight)}

State spending from the March 2021 federal COVID relief package, allocated via House Bill 632.

Source: MTFP analysis of bill texts and Legislative Fiscal Division data.

` }33:T51b,style = ``34:[{"id":"e577848876b5f8d8f972bea83e7d222477f25723770871b14988bc8ec0bdd8caee9b51e410a0a844f0213198ea7235cb62ad1388c4c3e37438fa43035d71f831","href":"https://static.observableusercontent.com/files/e577848876b5f8d8f972bea83e7d222477f25723770871b14988bc8ec0bdd8caee9b51e410a0a844f0213198ea7235cb62ad1388c4c3e37438fa43035d71f831","name":"2023-long-range-budget@5.csv","type":"text/csv","lastModified":1625684908513.623,"size":2346},{"id":"5fd265c5e8a1a267de507718f0cb095f1bf37941141ed188f636b350dc195a4278eaf546428629a5ce3cfa6581fadcecb22cc4a989e9f1f5fd4a235087cbb1ab","href":"https://static.observableusercontent.com/files/5fd265c5e8a1a267de507718f0cb095f1bf37941141ed188f636b350dc195a4278eaf546428629a5ce3cfa6581fadcecb22cc4a989e9f1f5fd4a235087cbb1ab","name":"arpa-budget@3.csv","type":"text/csv","lastModified":1625602324272.348,"size":4004},{"id":"fb69475e3235dcf749ca3e996e6f6491210192819abec2a3efe81c01d3e3e8d3b45e58b5126973ae114cf56945fb2d63ebc7acfbc83269ccbee24eee8fd47310","href":"https://static.observableusercontent.com/files/fb69475e3235dcf749ca3e996e6f6491210192819abec2a3efe81c01d3e3e8d3b45e58b5126973ae114cf56945fb2d63ebc7acfbc83269ccbee24eee8fd47310","name":"arpa-budget@4.csv","type":"text/csv","lastModified":1625685052384.135,"size":4021},{"id":"ebb82e61d0e1bba577a7cb4091ffba6c8fe3ddaba476dba357eb97da859af1852ae056d24bc578170996119932ebce49e61aa2d3ea261fc9977762499a2b7e1f","href":"https://static.observableusercontent.com/files/ebb82e61d0e1bba577a7cb4091ffba6c8fe3ddaba476dba357eb97da859af1852ae056d24bc578170996119932ebce49e61aa2d3ea261fc9977762499a2b7e1f","name":"2023-long-range-budget@3.csv","type":"text/csv","lastModified":1625602232665.063,"size":2244},{"id":"f7c5f68a3d599474bcb725916cca66c4a2f2da4e4844981e30c904da5f6832f411ce11a50062b798d4e24ea2367af281ea5807fd1110bb447a90a19d90952c37","href":"https://static.observableusercontent.com/files/f7c5f68a3d599474bcb725916cca66c4a2f2da4e4844981e30c904da5f6832f411ce11a50062b798d4e24ea2367af281ea5807fd1110bb447a90a19d90952c37","name":"hb-2-budget.csv","type":"text/csv","lastModified":1625603372978.315,"size":5059},{"id":"e8bae58e1e86ad367b319f4eab78ed928c4a5c094e361b0bd2c54900ba190aa4718ea5eea49c895289a04999a888975048f976f71364df5644833c4acaf646e2","href":"https://static.observableusercontent.com/files/e8bae58e1e86ad367b319f4eab78ed928c4a5c094e361b0bd2c54900ba190aa4718ea5eea49c895289a04999a888975048f976f71364df5644833c4acaf646e2","name":"cares2-budget@4.csv","type":"text/csv","lastModified":1625604773726.554,"size":814}] 2f:{"title":"Montana 2022-23 budget","cells":[{"id":0,"value":"md`# Montana 2022-23 budget\n\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":496,"value":"md`## Data`","pinned":false,"hidden":false,"mode":"ojs"},{"id":499,"value":"hb2Budget = {\n const raw = await FileAttachment(\"hb-2-budget.csv\").csv()\n return raw.map(d => ({\n bucket: 'HB 2',\n category: d.category,\n label: d.label.replace('Govenror\\'s Office', 'Governor\\'s Office'),\n amount: +d.all_funds_2023,\n gf_amount: +d.gf_2023_total,\n fed_total_amount: +d.federal_2023,\n other_state_amount: +d.all_funds_2023 - +d.gf_2023_total -+d.federal_2023\n }))\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":717,"value":"longRangeBudget = {\n const raw = await FileAttachment(\"2023-long-range-budget@5.csv\").csv()\n return raw.map(d => ({\n bucket: 'long-range',\n category: d.category.replace('Other Infrastructure', 'Other infrastructure'),\n label: d.label,\n amount: +d.total_non_arpa,\n gf_amount: +d.gen_fund,\n non_gf_state_amount: +d.state_funds,\n fed_non_stimulus_fed_amount: +d.non_arpa_federal,\n bonding: +d.bonding,\n fed_stimulus_amount: 0,\n fed_total_amount: +d.non_arpa_federal,\n other_state_amount: +d.total_non_arpa - +d.gen_fund -+d.non_arpa_federal,\n }))\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":672,"value":"cares2Budget = {\n const raw = await FileAttachment(\"cares2-budget@4.csv\").csv()\n return raw.map(d => ({\n bucket: 'CARES2',\n category: d.category,\n label: d.label.replace('COVID-19 Vaccination, Testing efforts', 'COVID-19 Vaccination, Testing Efforts'),\n amount: +d.approps,\n gf_amount: 0,\n non_gf_state_amount: 0,\n fed_non_stimulus_fed_amount: 0,\n fed_stimulus_amount: +d.approps,\n fed_total_amount: +d.approps,\n other_state_amount: 0,\n }))\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":726,"value":"arpaBudget = {\n const raw = await FileAttachment(\"arpa-budget@4.csv\").csv()\n return raw.map(d => ({\n bucket: 'ARPA',\n category: d.category,\n label: d.label,\n amount: +d.amount,\n gf_amount: 0,\n non_gf_state_amount: 0,\n fed_non_stimulus_fed_amount: 0,\n fed_stimulus_amount: +d.amount,\n fed_total_amount: +d.amount,\n other_state_amount: 0,\n }))\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":989,"value":"combined = hb2Budget.concat(longRangeBudget).concat(cares2Budget).concat(arpaBudget)","pinned":false,"hidden":false,"mode":"ojs"},{"id":1148,"value":"federalFraction = ({\n hb2Budget: d3.sum(hb2Budget, d => d.fed_total_amount) / d3.sum(hb2Budget, d => d.amount),\n longRangeBudget: d3.sum(longRangeBudget, d => d.fed_total_amount) / d3.sum(longRangeBudget, d => d.amount), \n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1054,"value":"spending = ({\n total: d3.sum(combined, d => d.amount),\n federal: d3.sum(combined, d => d.fed_total_amount),\n generalFund: d3.sum(combined, d => d.gf_amount),\n stimulus: d3.sum(cares2Budget.concat(arpaBudget), d => d.amount)\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":997,"value":"spendingFormatted = ({\n total: format(spending.total),\n federalOnly: format(spending.federal),\n generalFundOnly: format(spending.generalFund),\n stimulus: format(spending.stimulus),\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1044,"value":"// from Census for 2020\nmontanaPopulation = 1_084_225","pinned":false,"hidden":false,"mode":"ojs"},{"id":1050,"value":"spendingPerCapita = ({\n total: spending.total / montanaPopulation,\n federalOnly: spending.federal / montanaPopulation,\n generalFundOnly: spending.generalFund / montanaPopulation,\n stimulus: spending.stimulus / montanaPopulation,\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1038,"value":"spendingFractions = ({\n total: spending.total / spending.total,\n federalOnly: spending.federal / spending.total,\n generalFundOnly: spending.generalFund / spending.total,\n stimulus: spending.stimulus / spending.total,\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":477,"value":"height = 400","pinned":false,"hidden":false,"mode":"ojs"},{"id":565,"value":"colWidth = {\n const padding = 10\n const gutter = 10\n const minColWidth = 300\n const maxColWidth = 450\n \n const twoColWidth = (width - 2*padding - gutter) / 2\n const oneColWidth = width - 2*padding\n \n if (twoColWidth < minColWidth) return oneColWidth\n return Math.min(twoColWidth, maxColWidth)\n \n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":476,"value":"layOutTreemap = hierarchy => d3.treemap()\n .tile(d3.treemapSquarify)\n .size([width, height])\n .padding(1)\n .round(true)\n (hierarchy)","pinned":false,"hidden":false,"mode":"ojs"},{"id":686,"value":"hierarchyTransform = flatData => d3.hierarchy(d3.group(flatData, d => d.category))\n .sum(d => d.amount)","pinned":false,"hidden":false,"mode":"ojs"},{"id":682,"value":"treemapBucketMaxValue = {\n \n const values = [\n hierarchyTransform(hb2Budget),\n hierarchyTransform(longRangeBudget),\n hierarchyTransform(cares2Budget),\n hierarchyTransform(arpaBudget),\n ]\n const maxTotal = d3.sum(values, d => d.value)\n // return values\n return maxTotal\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":869,"value":"legend = () => {\n const legendItem = (category) => {\n return html`

\n \n ${category}\n

`\n }\n return html`

\n ${categories.map(legendItem)}\n

`\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":472,"value":"$31","pinned":false,"hidden":false,"mode":"ojs"},{"id":579,"value":"$32","pinned":false,"hidden":false,"mode":"ojs"},{"id":738,"value":"updateTooltip = (tooltip, event) => {\n const data = event.target.__data__.data\n // console.log(data)\n \n const fractionFromFed = data.fed_total_amount / data.amount\n const fractionFromGF = data.gf_amount / data.amount\n const fractionFromOtherState = data.other_state_amount / data.amount\n \n const makeLine = (amount, label) => {\n if (amount === 0) return ''\n const fraction = amount / data.amount\n return `

• ${format(amount)} ${label} (${percentFormat(fraction)})

`\n }\n \n const content = `\n

${data.label}

${format(data.amount)} allocated

\n\n${makeLine(data.gf_amount, 'from General Fund')}\n${makeLine(data.other_state_amount, 'from specialized state funds')}\n${makeLine(data.fed_total_amount, 'from federal funds')}\n\n

\n`\n tooltip.html(content)\n tooltip.style(\"top\", (event.pageY-10)+\"px\").style(\"left\",(event.pageX+10)+\"px\")\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":805,"value":"percentFormat = d => {\n if (d === 0) return '0%'\n if (d < 0.01) return d3.format('.1%')(d)\n return d3.format('.0%')(d)\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":751,"value":"format = {\n const format = d3.format(\"$,.3s\");\n return d => (d === 0) ? '$0' : format(d).replace('G',' billion').replace('M', ' million')\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":882,"value":"categories = [\n \"Governance\",\n \"Economic support\",\n \"Health & social services\",\n \"Education\",\n \n \"Transportation\",\n \n \"Justice\",\n \n \"Broadband\", \n \"Other infrastructure\",\n\n ]\n// [\"Governance\", \"Economic support\", \"Health & Social Services\", \"Transportation\", \"Justice\", \"Education\", \"Infrastructure\"]","pinned":false,"hidden":false,"mode":"ojs"},{"id":16,"value":"color = cat => {\n const colorScale = d3.scaleOrdinal(d3.schemeDark2).domain(categories)\n if (categories.includes(cat)) return colorScale(cat)\n \n return 'gray'\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":305,"value":"data = ({\n \"nodes\": [\n { \n \"name\": \"source 1\",\n color: 'red'\n },\n {\n \"name\": \"source 2\",\n color: 'red',\n },\n {\n \"name\": \"source 3\",\n color: 'red',\n },\n {\n \"name\": \"budget area 1\",\n color: 'blue',\n },\n {\n \"name\": \"budget area 2\",\n color: 'green',\n },\n {\n \"name\": \"budget area 3\",\n color: 'orange',\n },\n ],\n \"links\": [\n {\n \"source\": \"source 1\",\n \"target\": \"budget area 1\",\n \"value\": 25,\n },\n {\n \"source\": \"source 1\",\n \"target\": \"budget area 2\",\n \"value\": 83,\n },\n {\n \"source\": \"source 2\",\n \"target\": \"budget area 2\",\n \"value\": 45,\n },\n {\n \"source\": \"source 3\",\n \"target\": \"budget area 3\",\n \"value\": 32,\n },\n {\n \"source\": \"source 3\",\n \"target\": \"budget area 1\",\n \"value\": 100,\n },\n ]\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":580,"value":"$33","pinned":false,"hidden":false,"mode":"ojs"},{"id":7,"value":"d3 = require(\"d3@6\", \"d3-sankey@0.12\")","pinned":false,"hidden":false,"mode":"ojs"}],"files":"$W34","stdlib":"1","titling":"auto"}