31:T431,embed = { const scale = 35000 // bigger -> smaller return html`

How Montana plans to spend its ARPA money

What's included in House Bill 632, which allocates $2.3 billion from Montana's share of the American Rescue Plan Act.

${ // legend({ // color, // title: "Spending category", // tickSize: 0 // }) swatches({ color, columns: "150px" }) }

${await drawBundle(houseFloor632Allocations, [Math.min(width, 600), 400], scale)}

Data: Text of HB 632 on initial House passage. Graphic: Eric Dietrich / MTFP

` } 32:T568,drawBundle = (data, dims, scale) => { const MIN_WIDTH_FOR_LABEL = 45 const LINE_HEIGHT = 13 const [dimX, dimY] = dims const arrangement = arrange(data, [dimX / 2, dimY / 2], scale) let ctx = DOM.context2d(dimX, dimY); // Draw the squares arrangement.data.forEach(d => { ctx.strokeStyle = 'white' ctx.fillStyle = color(d.category); let [x0,y0] = d.square[0].p, [x1,y1] = d.square[3].p; ctx.beginPath() ctx.moveTo(x0,y0); ctx.lineTo(x1,y0); ctx.lineTo(x1,y1); ctx.lineTo(x0,y1); ctx.closePath(); ctx.fill(); ctx.stroke() if ((x1 - x0) > MIN_WIDTH_FOR_LABEL) { console.log(d) const amountLines = [dollarFormat(d.value)] const labelLines = d.label.split('\n') const lines = amountLines.concat(labelLines) ctx.textAlign = "center" ctx.fillStyle = 'black' ctx.font = "600 10pt Arial" lines.forEach((line, i) => { if (i > 0) ctx.font = "300 10pt Arial" ctx.fillText(line, (x0 + x1)/2, (y0 + y1)/2 + (i - (lines.length - 1)/2)*LINE_HEIGHT + 5); }) } }) // Draw the boundary ctx.strokeStyle = "black"; ctx.lineWidth = 2; drawPolygon(ctx,arrangement.polygon) // Highlight the last square // ctx.strokeStyle = "red"; // drawPolygon(ctx,arrangement.squares[arrangement.squares.length-1]) return ctx.canvas; }33:T1183,rawArpaData = [ { "category": "DOA", "label": "Capital\nprojects", "value": "119.3" }, { "category": "DLI", "label": "Corporation for National and Community Service", "value": "5.5" }, { "category": "DLI", "label": "Rapid Retraining", "value": "2" }, { "category": "DLI", "label": "Supplemental\nunemployment\nbenefits", "value": "286" }, { "category": "DLI", "label": "Unemployment Administration", "value": "5.2" }, { "category": "DMA", "label": "Increase funding for the Disaster Relief Fund", "value": "0" }, { "category": "infrastructure", "label": "Water, Sewer and Broadband", "value": "0" }, { "category": "DPHHS", "label": "Supplemental Nutrition Assistance Program", "value": "11" }, { "category": "DPHHS", "label": "Commodity Supplemental Food Program", "value": "0.2" }, { "category": "DPHHS", "label": "Child care\nsupport", "value": "111" }, { "category": "DPHHS", "label": "WIC", "value": "0" }, { "category": "DPHHS", "label": "Supporting Older Americans and their Families", "value": "1" }, { "category": "DPHHS", "label": "Family Violence Prevention", "value": "0.9" }, { "category": "DPHHS", "label": "Child Abuse Prevention", "value": "0.4" }, { "category": "DPHHS", "label": "Testing\n& contract\ntracing", "value": "143.4" }, { "category": "DPHHS", "label": "Increase public health workforce and investments", "value": "23" }, { "category": "DPHHS", "label": "Fund vaccine distribution, confidence, and supply chains", "value": "22.5" }, { "category": "DPHHS", "label": "Medicaid - Mandatory vaccine coverage", "value": "0" }, { "category": "DPHHS", "label": "Medicaid - Pregnant and Postpartum", "value": "0" }, { "category": "DPHHS", "label": "Medicaid - Mobile Crisis", "value": "0" }, { "category": "DPHHS", "label": "Medicaid - FMAP Increase", "value": "0" }, { "category": "DPHHS", "label": "Medicaid - Home and community based services", "value": "0" }, { "category": "DPHHS", "label": "Medicaid - Strike teams", "value": "0" }, { "category": "DPHHS", "label": "LIHEAP/Water Assistance", "value": "21" }, { "category": "DPHHS", "label": "SAMHSA", "value": "17" }, { "category": "DPHHS", "label": "CHIP", "value": "0" }, { "category": "DPHHS", "label": "Funding for Family Planning", "value": "0" }, { "category": "DPHHS", "label": "Funding for state homes", "value": "1.7" }, { "category": "DPHHS", "label": "Home Visiting Programs", "value": "0" }, { "category": "DPHHS", "label": "Emergency Assistance to Children and Families", "value": "2.8" }, { "category": "DPHHS", "label": "Elder Justice and Support", "value": "0" }, { "category": "DOC", "label": "Emergency\nrental\nassistance", "value": "152.4" }, { "category": "DOC", "label": "Homeless Assistance", "value": "11.6" }, { "category": "DOC", "label": "Homeowner Assistance", "value": "50" }, { "category": "DOC", "label": "State Small Business Credit Initiative", "value": "60" }, { "category": "OPI", "label": "K-12\neducation\naid", "value": "404" }, { "category": "OPI", "label": "Non-public school aid", "value": "7" }, { "category": "OCHE", "label": "College\naid", "value": "81.2" }, { "category": "OPI", "label": "Individuals with Disabilities Education Act", "value": "0" }, { "category": "Arts Council", "label": "National Endowment for the Arts", "value": "0" }, { "category": "MSL", "label": "Institute of Museum and Library Services", "value": "2.3" }, { "category": "DOT", "label": "Airport grants", "value": "0.6" }, { "category": "DOT", "label": "Rural transit grants", "value": "0.8" }, { "category": "flexible", "label": "State\nbudget\naid", "value": "910.1" }, { "category": "flexible", "label": "Local\ngovernment\naid", "value": "289" }, { "category": "flexible", "label": "Local Assistance and Tribal Consistency Fund", "value": "0" } ]34:T3c27,rawHouseFloor632Allocations = [ { "category": "Infrastructure", "agency": "governor", "HB632_section": "2", "ARPA_section": "602, 604", "hb632_amount": "619300000", "description": "State infrastructure projects and local infrastructure grants. $10M is allocated to rural regional water projects. At least $150M allocated to local government infrastructure grants.", "label": "State building\n projects & local\ninfrastructure grants" }, { "category": "Communications", "agency": "governor", "HB632_section": "6", "ARPA_section": "9901, 603", "hb632_amount": "250000000", "description": "Communication project grants related to broadband, cell towers, or public safety", "label": "Broadband/\ncell tower\ngrants" }, { "category": "Economic stablization", "agency": "governor", "HB632_section": "9", "ARPA_section": "9901, 602", "hb632_amount": "150000000", "description": "Economic stablization grants or loans", "label": "Business\ngrants/\nloans" }, { "category": "Economic stablization", "agency": "commerce", "HB632_section": "11", "ARPA_section": "3206, 3208", "hb632_amount": "50000000", "description": "Mortgage assistance", "label": "Mortgage assistance" }, { "category": "Economic stablization", "agency": "commerce", "HB632_section": "11", "ARPA_section": "3205", "hb632_amount": "11000000", "description": "Revolving fund for low-income housing", "label": "" }, { "category": "Economic stablization", "agency": "commerce", "HB632_section": "11", "ARPA_section": "3201, 3202, 3204", "hb632_amount": "152400000", "description": "Emergency Rental Assistance", "label": "Rental\naid" }, { "category": "Economic stablization", "agency": "commerce", "HB632_section": "12", "ARPA_section": "3301", "hb632_amount": "65000000", "description": "State Small Business Credit Initiative", "label": "" }, { "category": "Economic stablization", "agency": "DLI", "HB632_section": "13", "ARPA_section": "2206", "hb632_amount": "5500000", "description": "Workforce", "label": "" }, { "category": "Economic stablization", "agency": "DLI", "HB632_section": "13", "ARPA_section": "9031, 9032", "hb632_amount": "5200000", "description": "Unemployment Administration", "label": "" }, { "category": "Infrastructure", "agency": "MDT", "HB632_section": "14", "ARPA_section": "7102", "hb632_amount": "600000", "description": "Grants to airport", "label": "" }, { "category": "Infrastructure", "agency": "MDT", "HB632_section": "14", "ARPA_section": "3401", "hb632_amount": "800000", "description": "Grants for rural transit", "label": "" }, { "category": "Health & social services", "agency": "DPHHS", "HB632_section": "17", "ARPA_section": "11,011,102", "hb632_amount": "130000000", "description": "SNAP", "label": "SNAP" }, { "category": "Health & social services", "agency": "DPHHS", "HB632_section": "17", "ARPA_section": "1104", "hb632_amount": "200000", "description": "Commodity Supplemental Food Program", "label": "" }, { "category": "Health & social services", "agency": "DPHHS", "HB632_section": "17", "ARPA_section": "2204", "hb632_amount": "900000", "description": "Family Violence Prevention", "label": "" }, { "category": "Health & social services", "agency": "DPHHS", "HB632_section": "17", "ARPA_section": "2205", "hb632_amount": "1111000", "description": "Child Abuse Prevention", "label": "" }, { "category": "Health & social services", "agency": "DPHHS", "HB632_section": "17", "ARPA_section": "2301", "hb632_amount": "22500000", "description": "Vaccine Distribution and Supply", "label": "" }, { "category": "Health & social services", "agency": "DPHHS", "HB632_section": "17", "ARPA_section": "2401", "hb632_amount": "143400000", "description": "Testing and Contact Tracing", "label": "Testing\n& contact\ntracing" }, { "category": "Health & social services", "agency": "DPHHS", "HB632_section": "17", "ARPA_section": "2201, 2202", "hb632_amount": "111000000", "description": "Child Care Stabilization & Block Grants", "label": "Child\ncare\ngrants" }, { "category": "Health & social services", "agency": "DPHHS", "HB632_section": "17", "ARPA_section": "8004", "hb632_amount": "1700000", "description": "State Veterans' Homes", "label": "" }, { "category": "Health & social services", "agency": "DPHHS", "HB632_section": "17", "ARPA_section": "2501", "hb632_amount": "23000000", "description": "Public Health Workforce", "label": "" }, { "category": "Health & social services", "agency": "DPHHS", "HB632_section": "17", "ARPA_section": "9901/602", "hb632_amount": "20000000", "description": "Rapid Retraining Jobs Training (contracted private sector workforce training)", "label": "" }, { "category": "Health & social services", "agency": "DPHHS", "HB632_section": "17", "ARPA_section": "2701-2707", "hb632_amount": "17000000", "description": "Mental health and substance use disorder services", "label": "" }, { "category": "Health & social services", "agency": "DPHHS", "HB632_section": "17", "ARPA_section": "2911, 2912", "hb632_amount": "21000000", "description": "LIHEAP/Water Asssitance", "label": "" }, { "category": "Health & social services", "agency": "DPHHS", "HB632_section": "17", "ARPA_section": "2921", "hb632_amount": "1000000", "description": "Senior services, blind news service", "label": "" }, { "category": "Health & social services", "agency": "DPHHS", "HB632_section": "17", "ARPA_section": "4007, 4008", "hb632_amount": "930000", "description": "Emergency food and shelter program", "label": "" }, { "category": "Health & social services", "agency": "DPHHS", "HB632_section": "17", "ARPA_section": "9201, 9301, 9101, 1105", "hb632_amount": "2726000", "description": "Pandemic Emergency Asssitance, Elder Justice Programs, early childhood home visits, WIC", "label": "" }, { "category": "Other", "agency": "DOJ", "HB632_section": "19", "ARPA_section": "9901, 604", "hb632_amount": "1000000", "description": "Freezer, Morgue and Refridgeration Space", "label": "" }, { "category": "Other", "agency": "DOJ", "HB632_section": "19", "ARPA_section": "9901, 602", "hb632_amount": "1000000", "description": "Crime Lab Facility Space", "label": "" }, { "category": "Education", "agency": "OPI", "HB632_section": "20", "ARPA_section": "2001", "hb632_amount": "343817312", "description": "Basic Allocation to School Districts", "label": "Direct\nschool\ndistrict\nallocations" }, { "category": "Education", "agency": "OPI", "HB632_section": "20", "ARPA_section": "2001", "hb632_amount": "3400000", "description": "Supplemental Allocations to School Districts", "label": "" }, { "category": "Education", "agency": "OPI", "HB632_section": "20", "ARPA_section": "2001", "hb632_amount": "120000", "description": "Allocation to Other Educational Institutions", "label": "" }, { "category": "Education", "agency": "OPI", "HB632_section": "20", "ARPA_section": "2001", "hb632_amount": "555234", "description": "Education Leadership in Montana", "label": "" }, { "category": "Education", "agency": "OPI", "HB632_section": "20", "ARPA_section": "2001", "hb632_amount": "5475248", "description": "OPI Database Modernization", "label": "" }, { "category": "Education", "agency": "OPI", "HB632_section": "20", "ARPA_section": "2001", "hb632_amount": "1910096", "description": "Administration", "label": "" }, { "category": "Education", "agency": "OPI", "HB632_section": "20", "ARPA_section": "2001", "hb632_amount": "19100962", "description": "State Learning Loss", "label": "" }, { "category": "Education", "agency": "OPI", "HB632_section": "20", "ARPA_section": "2001", "hb632_amount": "3820192", "description": "State Summer Enrichment", "label": "" }, { "category": "Education", "agency": "OPI", "HB632_section": "20", "ARPA_section": "2001", "hb632_amount": "3820192", "description": "State Afterschool Programs", "label": "" }, { "category": "Education", "agency": "OPI", "HB632_section": "20", "ARPA_section": "2002", "hb632_amount": "7000000", "description": "Assistance to Nonpublic Schools", "label": "" }, { "category": "Education", "agency": "OPI", "HB632_section": "20", "ARPA_section": "2014", "hb632_amount": "10200000", "description": "Individuals with Disabilities Act", "label": "" }, { "category": "Education", "agency": "OCHE", "HB632_section": "21", "ARPA_section": "602rr", "hb632_amount": "7500000", "description": "Montana Research and Economic Development Initiative", "label": "" }, { "category": "Education", "agency": "OCHE", "HB632_section": "21", "ARPA_section": "602rr", "hb632_amount": "1000000", "description": "Teacher Education Programs", "label": "" }, { "category": "Education", "agency": "OCHE", "HB632_section": "21", "ARPA_section": "602rr", "hb632_amount": "1000000", "description": "Workforce Recovery COVID-19", "label": "" }, { "category": "Education", "agency": "OCHE", "HB632_section": "21", "ARPA_section": "602rr", "hb632_amount": "2000000", "description": "Accelerate Montana", "label": "" }, { "category": "Education", "agency": "OCHE", "HB632_section": "21", "ARPA_section": "602rr", "hb632_amount": "1500000", "description": "Cyber Hub", "label": "" }, { "category": "Education", "agency": "OCHE", "HB632_section": "21", "ARPA_section": "602rr", "hb632_amount": "2000000", "description": "Center for Translational Medicine", "label": "" }, { "category": "Education", "agency": "OCHE", "HB632_section": "21", "ARPA_section": "8006", "hb632_amount": "2000000", "description": "Rapid Retraining for Veterans", "label": "" }, { "category": "Education", "agency": "Arts Council", "HB632_section": "21", "ARPA_section": "2021", "hb632_amount": "764000", "description": "Montana Arts Council", "label": "" }, { "category": "Education", "agency": "State Library", "HB632_section": "21", "ARPA_section": "2921", "hb632_amount": "120000", "description": "Newsline", "label": "" }, { "category": "Education", "agency": "State Library", "HB632_section": "21", "ARPA_section": "2023", "hb632_amount": "1235444", "description": "Hot Spot Lending Program", "label": "" }, { "category": "Education", "agency": "State Library", "HB632_section": "21", "ARPA_section": "2023", "hb632_amount": "1000000", "description": "E-Learning Digital Content", "label": "" }, { "category": "Infrastructure", "agency": "", "HB632_section": "28", "ARPA_section": "9901", "hb632_amount": "2050000", "description": "OPI MT Learning 2 Center Civil Infrastructure Upgrades and the UM FLBS Sewer Treatment Plant (from HB 5)", "label": "" }, { "category": "Infrastructure", "agency": "", "HB632_section": "28", "ARPA_section": "9901", "hb632_amount": "5310000", "description": "Backfills university system building projects from House Bill 5", "label": "" }, { "category": "Infrastructure", "agency": "DNRC", "HB632_section": "29", "ARPA_section": "9901", "hb632_amount": "4500000", "description": "Backfills DNRC water project program grants from House Bill 6", "label": "" }, { "category": "Infrastructure", "agency": "DNRC", "HB632_section": "30", "ARPA_section": "9901", "hb632_amount": "429000", "description": "Backfills portion of allocation to state reclamation and development grants program in House Bill 7 ", "label": "" }, { "category": "Infrastructure", "agency": "Commerce", "HB632_section": "31", "ARPA_section": "9901", "hb632_amount": "9869800", "description": "Backfills portion of allocation to treasure state endowment program for water and wastewater projects in House Bill 11 ", "label": "" }, { "category": "Infrastructure", "agency": "Commerce", "HB632_section": "31", "ARPA_section": "9901", "hb632_amount": "100000", "description": "Backfills portion of allocation to treasure state endowment program for emergency infrastructure grants in House Bill 11 ", "label": "" }, { "category": "Infrastructure", "agency": "Commerce", "HB632_section": "31", "ARPA_section": "9901", "hb632_amount": "900000", "description": "Backfills portion of allocation to treasure state endowment program for infrastructure planning grants in House Bill 11 ", "label": "" }, { "category": "Infrastructure", "agency": "Commerce", "HB632_section": "31", "ARPA_section": "9901", "hb632_amount": "5000000", "description": "Backfills portion of allocation to treasure state endowment program for building regional water projects in House Bill 11 ", "label": "" }, { "category": "Infrastructure", "agency": "Commerce", "HB632_section": "32", "ARPA_section": "9901", "hb632_amount": "26200000", "description": "Replaces bonded funding for MT Veterinarian Diagnostic Lab project in House Bill 14", "label": "" }, { "category": "Infrastructure", "agency": "Commerce", "HB632_section": "32", "ARPA_section": "9901", "hb632_amount": "6500000", "description": "Replaces bonded funding for state liquor warehouse expansion in House Bill 14", "label": "" }, { "category": "Infrastructure", "agency": "Commerce", "HB632_section": "32", "ARPA_section": "9901", "hb632_amount": "4800000", "description": "Replaces bonded funding for UM-Western Block Hall renovation in House Bill 14", "label": "" }, { "category": "Infrastructure", "agency": "Commerce", "HB632_section": "32", "ARPA_section": "9901", "hb632_amount": "13707898", "description": "Backfills funding for water and wastewater projects included in House Bill 14", "label": "" }, { "category": "Infrastructure", "agency": "Commerce", "HB632_section": "32", "ARPA_section": "9901", "hb632_amount": "4720788", "description": "Backfills funding for water conservation projects included in House Bill 14", "label": "" } ]35:[] 2f:{"title":"Montana COVID-19 Stimulus","cells":[{"id":0,"value":"md`# Montana COVID-19 Stimulus\n\nAdapted from https://observablehq.com/@esperanc/square-packing\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":118,"value":"$31","pinned":false,"hidden":false,"mode":"ojs"},{"id":47,"value":"$32","pinned":false,"hidden":false,"mode":"ojs"},{"id":361,"value":"dollarFormat = d3.format('$.3s')","pinned":false,"hidden":false,"mode":"ojs"},{"id":70,"value":"color = {\n // const categories = Array.from(new Set(houseFloor632Allocations.map(d => d.category))).sort((a,b) => a.localeCompare(b))\n return d3.scaleOrdinal(categories, d3.schemeSet2)\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":229,"value":"$33","pinned":false,"hidden":false,"mode":"ojs"},{"id":272,"value":"$34","pinned":false,"hidden":false,"mode":"ojs"},{"id":278,"value":"houseFloor632Allocations = {\n return rawHouseFloor632Allocations.map(d => {\n return {\n category: d.category,\n label: d.label,\n value: +d.hb632_amount\n }\n })\n .sort((a,b) => categories.indexOf(a.category) - categories.indexOf(b.category))\n// .sort((a,b) => a.value - b.value)\n// .sort((a,b) => .5 - Math.random())\n}\n\n","pinned":false,"hidden":false,"mode":"ojs"},{"id":311,"value":"categories = [\n \"Economic stablization\",\n \"Health & social services\",\n \"Education\",\n \"Communications\",\n \"Infrastructure\",\n \n \"Other\",\n \n]","pinned":false,"hidden":false,"mode":"ojs"},{"id":237,"value":"arpaData = {\n return rawArpaData.map(d => ({...d, value: +d.value}))\n}\n \n // .sort((a,b) => b.value - a.value)","pinned":false,"hidden":false,"mode":"ojs"},{"id":8,"value":"md`### Libraries`","pinned":false,"hidden":false,"mode":"ojs"},{"id":29,"value":"config = ({heuristic: \"first\", metric: \"euclidean\", renderFreq: 10, closeFreq: 1, closeFactor: 0.3})","pinned":false,"hidden":false,"mode":"ojs"},{"id":50,"value":"// Draws the boundary of vertex list vlist onto a canvas using context ctx\nfunction drawPolygon (ctx,vlist) {\n let faces = vlist.faces();\n for (let f of vlist.rotAxesClock().faces()) faces.push(f.rotAxesCounter())\n \n // Draw the polygon\n ctx.beginPath();\n for (let d of faces) {\n let x1 = d[0].p[0];\n let y1 = d[0].p[1];\n let x2 = d[1].p[0];\n let y2 = d[1].p[1];\n ctx.moveTo(x1,y1);\n ctx.lineTo(x2,y2);\n }\n ctx.stroke();\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":23,"value":"arrange = (data, dims=[200,200], scale=1_000) => {\n let sa = new SquareArrangement(dims, config);\n const key = 'value'\n data.forEach((d,i) => {\n const area = d[key] / scale\n sa.addSquare(area)\n data[i].square = sa.squares[i]\n })\n sa.data = data\n return sa\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":15,"value":"import {SquareArrangement} from \"@esperanc/square-packing\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":76,"value":"import {legend, swatches} from \"@d3/color-legend\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":73,"value":"d3 = require(\"d3@6\")","pinned":false,"hidden":false,"mode":"ojs"}],"files":"$W35","stdlib":"1","titling":"auto"}